SELECT 
  a.destination_id, 
  a.status, 
  a.localization, 
  b.destination 
FROM 
  cscart_destinations as a 
  LEFT JOIN cscart_destination_descriptions as b ON a.destination_id = b.destination_id 
  AND b.lang_code = 'en' 
WHERE 
  1 = 1 
ORDER BY 
  b.destination

Query time 0.00318

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "281.80"
    },
    "ordering_operation": {
      "using_temporary_table": true,
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "117.00"
      },
      "nested_loop": [
        {
          "table": {
            "table_name": "a",
            "access_type": "ALL",
            "rows_examined_per_scan": 117,
            "rows_produced_per_join": 117,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "1.00",
              "eval_cost": "23.40",
              "prefix_cost": "24.40",
              "data_read_per_join": "88K"
            },
            "used_columns": [
              "destination_id",
              "localization",
              "status"
            ]
          }
        },
        {
          "table": {
            "table_name": "b",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "destination_id",
              "lang_code"
            ],
            "key_length": "9",
            "ref": [
              "webmarco.a.destination_id",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 117,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "117.00",
              "eval_cost": "23.40",
              "prefix_cost": "164.80",
              "data_read_per_join": "89K"
            },
            "used_columns": [
              "destination_id",
              "lang_code",
              "destination"
            ]
          }
        }
      ]
    }
  }
}

Result

destination_id status localization destination
102 A Afganistan
15 A Albania
61 A Albania - Counties without Tirana
65 A Andorra
108 A Argentina
109 A Armenia
110 A Australia
16 A Austria
111 A Azerbaijan
92 D Balkan - Xhuljano
91 D Ballkan - Elio
112 A Barbados
63 D Belarus
17 A Belgium
113 A Belize
126 A Bolivia
18 A Bosnia and Herzegovina
127 A Brazil
19 A Bulgaria
72 A Canada
132 A Chile
134 A Colombia
135 A Costa Rica
20 A Croatia
136 A Cuba
21 A Cyprus
22 A Czech Republic
1 A Default rate area (all countries)
23 A Denmark
128 A Dominican Republic
129 A Ecuador
89 A Egypt
130 A El Salvador
24 A Estonia
25 A Finland
26 A France
114 A Georgia
56 A Germany
27 A Greece
115 A Grenada
116 A Guatemala
117 A Haiti
118 A Honduras
28 A Hungary
29 A Iceland
30 A Ireland
9 A Italia
144 A Jamaica
131 A Kazakhstan
88 A Kosova
59 A Kosovo
133 A Kyrgyzstan
57 A La tariffa dall Italia verso l’estero a partire da
31 A Latvia
32 A Liechtenstein
33 A Lithuania
34 A Luxembourg
35 A Macedonia
36 A Malta
82 A Mexico
37 A Moldova, Republic of
38 A Monaco
39 A Montenegro
40 A Netherlands
119 A Nicaragua
41 A Norway
120 A Pakistan
121 A Panama
122 A Papa New Guinea
123 A Paraguay
124 A Peru
106 A Philippines
42 A Poland
43 A Portugal
125 A Puerto Rico
44 A Republic of Serbia
45 A Romania
46 D Russian Federation
137 A Saint Lucia
103 A San Marino
11 A Sardegna
105 A Saudi Arabia
47 A Serbia
12 A Sicilia
48 A Slovakia
49 A Slovenia
90 A South West Ballkan - Kevin
50 A Spain
138 A Suriname
51 A Sweden
52 A Switzerland
139 A Tajikistan
100 A Tirana & Durres - Albania
60 A Tirana - Albania
53 A Turkey
140 A Turkmenistan
14 A Tutte le Isole Minori Italiane
54 A Ukraine
107 A United Arab Emirates
55 A United Kingdom (Great Britain)
62 A United States
141 A Uruguay
142 A Uzbekistan
104 A Vatican City State
13 A Venetian Lagoon (Islands)
143 A Venezuela
84 A Zona 1 - Riser Trade Co Ltd
93 A Zona 1 - The Comfort Shpk
85 A Zona 2 - Riser Trade Co Ltd
94 A Zona 2 - The Comfort Shpk
86 A Zona 3 - Riser Trade Co Ltd
95 A Zona 3 - The Comfort Shpk
87 A Zona 4 - Riser Trade Co Ltd
96 A Zona 4 - The Comfort Shpk
97 A Zona 5 - The Comfort Shpk
98 A Zona 6 - The Comfort Shpk
101 A Zona A - The Comfort Shpk