Query time 0.00074
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "43.92"
},
"ordering_operation": {
"using_temporary_table": true,
"using_filesort": true,
"cost_info": {
"sort_cost": "7.60"
},
"nested_loop": [
{
"table": {
"table_name": "a",
"access_type": "ref",
"possible_keys": [
"cs",
"country_code"
],
"key": "country_code",
"used_key_parts": [
"country_code"
],
"key_length": "8",
"ref": [
"const"
],
"rows_examined_per_scan": 76,
"rows_produced_per_join": 7,
"filtered": "10.00",
"cost_info": {
"read_cost": "12.00",
"eval_cost": "1.52",
"prefix_cost": "27.20",
"data_read_per_join": "851"
},
"used_columns": [
"state_id",
"country_code",
"code",
"status"
],
"attached_condition": "(`ea201_diorama`.`a`.`status` = 'A')"
}
},
{
"table": {
"table_name": "b",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"state_id",
"lang_code"
],
"key_length": "9",
"ref": [
"ea201_diorama.a.state_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 7,
"filtered": "100.00",
"cost_info": {
"read_cost": "7.60",
"eval_cost": "1.52",
"prefix_cost": "36.32",
"data_read_per_join": "5K"
},
"used_columns": [
"state_id",
"lang_code",
"state"
]
}
}
]
}
}
}
Result
code |
state |
01 |
- |
02 |
Aisne |
03 |
Allier |
04 |
Alpes de Haute-Provence |
06 |
Alpes-Maritimes |
07 |
Ardêche |
08 |
Ardennes |
09 |
Ariège |
10 |
Aube |
11 |
Aude |
12 |
Aveyron |
13 |
Bouches-du-Rhône |
14 |
Calvados |
15 |
Cantal |
16 |
Charente |
17 |
Charente-Maritime |
18 |
Cher |
19 |
Corrèze |
2A |
Corse-du-Sud |
21 |
Côte-d'Or |
22 |
Côtes d'Armor |
23 |
Creuse |
t5 |
Deux-Sèvres |
24 |
Dordogne |
25 |
Doubs |
26 |
Drôme |
91 |
Essonne |
27 |
Eure |
28 |
Eure-et-Loir |
29 |
Finistère |
30 |
Gard |
32 |
Gers |
33 |
Gironde |
05 |
Haut-Rhin |
2B |
Haute-Corse |
31 |
Haute-Garonne |
43 |
Haute-Loire |
52 |
Haute-Marne |
fg |
Haute-Saône |
t1 |
Haute-Savoie |
87 |
Haute-Vienne |
ff |
Hautes-Pyrénées |
92 |
Hauts-de-Seine |
34 |
Hérault |
35 |
Ille-et-Vilaine |
36 |
Indre |
37 |
Indre-et-Loire |
38 |
Isère |
39 |
Jura |
40 |
Landes |
41 |
Loir-et-Cher |
42 |
Loire |
44 |
Loire-Atlantique |
45 |
Loiret |
46 |
Lot |
47 |
Lot-et-Garonne |
48 |
Lozère |
49 |
Maine-et-Loire |
50 |
Manche |
51 |
Marne |
96 |
Mayenne |
97 |
Meurthe-et-Moselle |
98 |
Meuse |
99 |
Morbihan |
f1 |
Moselle |
f2 |
Nièvre |
f3 |
Nord |
59 |
Nord |
f4 |
Oise |
f5 |
Orne |
75 |
Paris |
f6 |
Pas-de-Calais |
f8 |
Puy-de-Dôme |
f9 |
Pyrénées-Atlantiques |
fa |
Pyrénées-Orientales |
ft |
Rhône |
fh |
Saône-et-Loire |
fi |
Sarthe |
fl |
Savoie |
t3 |
Seine-et-Marne |
t2 |
Seine-Maritime |
93 |
Seine-Saint-Denis |
80 |
Somme |
81 |
Tarn |
82 |
Tarn-et-Garonne |
90 |
Territoire-de-Belfort |
95 |
Val-d'Oise |
94 |
Val-de-Marne |
83 |
Var |
84 |
Vaucluse |
85 |
Vendée |
86 |
Vienne |
88 |
Vosges |
89 |
Yonne |
t6 |
Yvelines |
t4 |
Yvelines |
t7 |
Yvelines |