Query time 0.00072
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "35.10"
},
"ordering_operation": {
"using_temporary_table": true,
"using_filesort": true,
"cost_info": {
"sort_cost": "5.50"
},
"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": 55,
"rows_produced_per_join": 5,
"filtered": "10.00",
"cost_info": {
"read_cost": "12.00",
"eval_cost": "1.10",
"prefix_cost": "23.00",
"data_read_per_join": "616"
},
"used_columns": [
"state_id",
"country_code",
"code",
"status"
],
"attached_condition": "(`ea201_francemaqu`.`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_francemaqu.a.state_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 5,
"filtered": "100.00",
"cost_info": {
"read_cost": "5.50",
"eval_cost": "1.10",
"prefix_cost": "29.60",
"data_read_per_join": "4K"
},
"used_columns": [
"state_id",
"lang_code",
"state"
]
}
}
]
}
}
}
Result
code |
state |
01 |
- |
02 |
Aisne |
03 |
Allier |
04 |
Alpes-de-Haute-Provence |
06 |
Alpes-Maritimes |
07 |
Ardeche |
08 |
Ardennes |
09 |
Ariege |
10 |
Aube |
11 |
Aude |
12 |
Aveyron |
13 |
Bouches-du-Rhone |
14 |
Calvados |
15 |
Cantal |
16 |
Charente |
17 |
Charente-Maritime |
18 |
Cher |
19 |
Correze |
2A |
Corse-du-Sud |
21 |
Cote-d'Or |
22 |
Cotes-d'Armor |
23 |
Creuse |
24 |
Dordogne |
25 |
Doubs |
26 |
Drome |
91 |
Essonne |
27 |
Eure |
28 |
Eure-et-Loir |
29 |
Finistere |
30 |
Gard |
32 |
Gers |
33 |
Gironde |
2B |
Haute-Corse |
31 |
Haute-Garonne |
43 |
Haute-Loire |
52 |
Haute-Marne |
05 |
Haute-Vienne |
87 |
Haute-Vienne |
92 |
Hauts-de-Seine |
34 |
Herault |
35 |
Ille-et-Vilaine |
36 |
Indre |
37 |
Indre-et-Loire |
38 |
Isere |
39 |
Jura |
40 |
Landes |
41 |
Loir-et-Cher |
42 |
Loire |
44 |
Loire-Atlantique |
45 |
Loiret |
46 |
Lot |
47 |
Lot-et-Garonne |
48 |
Lozere |
49 |
Maine-et-Loire |
50 |
Manche |
51 |
Marne |
75 |
Paris |
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 |
Vendee |
86 |
Vienne |
88 |
Vosges |
89 |
Yonne |