SELECT *, cscart_dropdown_images.dropdown_image_id as dropdown_image_id, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_categories LEFT JOIN cscart_category_descriptions ON cscart_category_descriptions.category_id = cscart_categories.category_id AND cscart_category_descriptions.lang_code = 'ro'  LEFT JOIN cscart_dropdown_images ON cscart_dropdown_images.categ_id = 19540 LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 19540  AND cscart_seo_names.type = 'c'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'ro'  AND cscart_seo_names.company_id = cscart_categories.company_id  WHERE cscart_categories.category_id = 19540 AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.company_id = 1

Query is invalid

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "277.03"
    },
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_categories",
          "access_type": "const",
          "possible_keys": [
            "PRIMARY",
            "c_status",
            "p_category_id"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "category_id"
          ],
          "key_length": "3",
          "ref": [
            "const"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 1,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "0.00",
            "eval_cost": "0.10",
            "prefix_cost": "0.00",
            "data_read_per_join": "2K"
          },
          "used_columns": [
            "category_id",
            "parent_id",
            "id_path",
            "level",
            "company_id",
            "usergroup_ids",
            "status",
            "product_count",
            "position",
            "timestamp",
            "is_op",
            "localization",
            "age_verification",
            "age_limit",
            "parent_age_verification",
            "parent_age_limit",
            "selected_views",
            "default_view",
            "product_details_view",
            "product_columns",
            "is_trash"
          ]
        }
      },
      {
        "table": {
          "table_name": "cscart_category_descriptions",
          "access_type": "const",
          "possible_keys": [
            "PRIMARY"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "category_id",
            "lang_code"
          ],
          "key_length": "9",
          "ref": [
            "const",
            "const"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 1,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "0.00",
            "eval_cost": "0.10",
            "prefix_cost": "0.00",
            "data_read_per_join": "3K"
          },
          "used_columns": [
            "category_id",
            "lang_code",
            "category",
            "description",
            "meta_keywords",
            "meta_description",
            "page_title",
            "age_warning_message"
          ]
        }
      },
      {
        "table": {
          "table_name": "cscart_dropdown_images",
          "access_type": "ALL",
          "rows_examined_per_scan": 1366,
          "rows_produced_per_join": 1366,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "2.83",
            "eval_cost": "136.60",
            "prefix_cost": "139.43",
            "data_read_per_join": "1M"
          },
          "used_columns": [
            "dropdown_image_id",
            "categ_id",
            "dd_status",
            "image_width",
            "image_height",
            "custom_menu_settings",
            "push_menu_items",
            "offset_right",
            "offset_bottom",
            "menu_width",
            "menu_min_height",
            "url",
            "company_id"
          ],
          "attached_condition": "<if>(is_not_null_compl(cscart_dropdown_images), (`maniamall_cscart`.`cscart_dropdown_images`.`categ_id` = 19540), true)"
        }
      },
      {
        "table": {
          "table_name": "cscart_seo_names",
          "access_type": "const",
          "possible_keys": [
            "PRIMARY",
            "dispatch"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "object_id",
            "type",
            "dispatch",
            "lang_code",
            "company_id"
          ],
          "key_length": "210",
          "ref": [
            "const",
            "const",
            "const",
            "const",
            "const"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 1366,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "1.00",
            "eval_cost": "136.60",
            "prefix_cost": "277.03",
            "data_read_per_join": "2M"
          },
          "used_columns": [
            "name",
            "object_id",
            "company_id",
            "type",
            "dispatch",
            "path",
            "lang_code"
          ]
        }
      }
    ]
  }
}