SELECT 
  cscart_et_mv_vsb.vsb_id, 
  cscart_et_mv_vsb.company_id, 
  cscart_et_mv_vsb.status, 
  cscart_et_mv_vsb.position, 
  cscart_et_mv_vsb.data as settings, 
  cscart_et_mv_vsb_data.data as q_data, 
  cscart_et_mv_vsb.data as settings, 
  cscart_et_mv_vsb_data.data, 
  cscart_et_mv_vsb_data.text 
FROM 
  cscart_et_mv_vsb 
  LEFT JOIN cscart_et_mv_vsb_data ON cscart_et_mv_vsb_data.vsb_id = cscart_et_mv_vsb.vsb_id 
  AND cscart_et_mv_vsb_data.lang_code = 'en' 
WHERE 
  1 
  AND cscart_et_mv_vsb.status = 'A' 
  AND cscart_et_mv_vsb.company_id = '174' 
ORDER BY 
  cscart_et_mv_vsb.position asc

Query time 0.01606

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "63050.40"
    },
    "ordering_operation": {
      "using_temporary_table": true,
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "52306.92"
      },
      "nested_loop": [
        {
          "table": {
            "table_name": "cscart_et_mv_vsb",
            "access_type": "ALL",
            "rows_examined_per_scan": 558,
            "rows_produced_per_join": 5,
            "filtered": "1.00",
            "cost_info": {
              "read_cost": "119.48",
              "eval_cost": "1.12",
              "prefix_cost": "120.60",
              "data_read_per_join": "133"
            },
            "used_columns": [
              "vsb_id",
              "company_id",
              "status",
              "position",
              "data"
            ],
            "attached_condition": "((`webmarco`.`cscart_et_mv_vsb`.`status` = 'A') and (`webmarco`.`cscart_et_mv_vsb`.`company_id` = '174'))"
          }
        },
        {
          "table": {
            "table_name": "cscart_et_mv_vsb_data",
            "access_type": "ALL",
            "rows_examined_per_scan": 9374,
            "rows_produced_per_join": 52306,
            "filtered": "100.00",
            "using_join_buffer": "Block Nested Loop",
            "cost_info": {
              "read_cost": "161.49",
              "eval_cost": "10461.38",
              "prefix_cost": "10743.47",
              "data_read_per_join": "1M"
            },
            "used_columns": [
              "data_id",
              "vsb_id",
              "text",
              "data",
              "lang_code"
            ],
            "attached_condition": "<if>(is_not_null_compl(cscart_et_mv_vsb_data), ((`webmarco`.`cscart_et_mv_vsb_data`.`vsb_id` = `webmarco`.`cscart_et_mv_vsb`.`vsb_id`) and (`webmarco`.`cscart_et_mv_vsb_data`.`lang_code` = 'en')), true)"
          }
        }
      ]
    }
  }
}