Query time 0.00357
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "9.52"
},
"ordering_operation": {
"using_filesort": true,
"nested_loop": [
{
"table": {
"table_name": "sd",
"access_type": "ref",
"possible_keys": [
"section"
],
"key": "section",
"used_key_parts": [
"section",
"status"
],
"key_length": "6",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 21,
"rows_produced_per_join": 2,
"filtered": "10.00",
"index_condition": "((`ea201_diorama`.`sd`.`section` <=> 'A') and (`ea201_diorama`.`sd`.`status` <=> 'A'))",
"cost_info": {
"read_cost": "2.80",
"eval_cost": "0.42",
"prefix_cost": "7.00",
"data_read_per_join": "13K"
},
"used_columns": [
"param_id",
"param",
"param_2",
"param_3",
"param_4",
"param_5",
"section",
"status",
"position",
"parent_id",
"id_path",
"class",
"param_6"
],
"attached_condition": "(`ea201_diorama`.`sd`.`param_5` = '2')"
}
},
{
"table": {
"table_name": "cscart_static_data_descriptions",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"param_id",
"lang_code"
],
"key_length": "9",
"ref": [
"ea201_diorama.sd.param_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 2,
"filtered": "100.00",
"cost_info": {
"read_cost": "2.10",
"eval_cost": "0.42",
"prefix_cost": "9.52",
"data_read_per_join": "1K"
},
"used_columns": [
"param_id",
"lang_code",
"descr"
]
}
}
]
}
}
}
Result
param_id |
param |
descr |
param_2 |
param_3 |
param_4 |
param_5 |
param_6 |
status |
position |
parent_id |
id_path |
class |
33 |
|
Modélisme miniature |
|
C:0:N |
right |
2 |
|
A |
1 |
0 |
33 |
|
31 |
http://www.diorama.fr/architectes-miniatures-maquettes-architecture.html |
Architectes |
|
C:634:N |
right |
2 |
|
A |
2 |
0 |
31 |
|
34 |
|
Vegetation |
|
C:177:Y |
|
2 |
|
A |
3 |
0 |
34 |
|
35 |
|
Figurines |
|
C:165:Y |
|
2 |
|
A |
4 |
0 |
35 |
|
37 |
|
Voitures véhicules |
|
C:398:Y |
|
2 |
N |
A |
5 |
0 |
37 |
|
38 |
|
Equipements accessoires |
|
C:185:Y |
|
2 |
N |
A |
6 |
0 |
38 |
|
39 |
|
Routes, tunnels, ponts, voies sncf |
|
C:209:Y |
|
2 |
N |
A |
8 |
0 |
39 |
|
40 |
|
Maisons, bâtiments |
|
C:194:Y |
|
2 |
N |
A |
10 |
0 |
40 |
|
42 |
|
Peinture, patines |
|
C:204:Y |
|
2 |
N |
A |
12 |
0 |
42 |
|
43 |
|
Outils, materiaux, colles |
|
C:203:Y |
|
2 |
N |
A |
13 |
0 |
43 |
|
44 |
|
Construction des volumes |
|
C:226:Y |
|
2 |
N |
A |
14 |
0 |
44 |
|
45 |
|
Maquettes, modélisme ferroviaire |
|
|
|
2 |
N |
A |
15 |
0 |
45 |
|
46 |
|
Dameuses miniatures et chasses neiges |
|
C:711:Y |
|
2 |
N |
A |
17 |
0 |
46 |
|
36 |
|
Téléphériques |
|
C:668:Y |
|
2 |
N |
A |
18 |
0 |
36 |
|
47 |
https://www.diorama.fr/decors-pour-le-slot.html |
Slot |
|
C:712:N |
|
2 |
N |
A |
19 |
0 |
47 |
|
26 |
|
Jouets miniatures |
|
C:544:Y |
right |
2 |
N |
A |
20 |
0 |
26 |
|
22 |
https://www.diorama.fr/noel-neige-creches.html |
Décors de crèches |
|
C:264:N |
right |
2 |
N |
A |
30 |
0 |
22 |
|