Query time 0.00082
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "10.86"
},
"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": 23,
"rows_produced_per_join": 2,
"filtered": "10.00",
"index_condition": "((`ea201_francemaqu`.`sd`.`section` <=> 'A') and (`ea201_francemaqu`.`sd`.`status` <=> 'A'))",
"cost_info": {
"read_cost": "3.50",
"eval_cost": "0.46",
"prefix_cost": "8.10",
"data_read_per_join": "14K"
},
"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_francemaqu`.`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_francemaqu.sd.param_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 2,
"filtered": "100.00",
"cost_info": {
"read_cost": "2.30",
"eval_cost": "0.46",
"prefix_cost": "10.86",
"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 |
66 |
|
PROMOS |
|
C:453:Y |
|
2 |
N |
A |
0 |
0 |
66 |
|
47 |
|
Nouveautés maquettes |
|
C:116:Y |
|
2 |
|
A |
1 |
0 |
47 |
|
38 |
|
Avions |
Maquettes Avions |
C:5:Y |
right |
2 |
|
A |
2 |
0 |
38 |
|
35 |
|
Voitures |
|
C:9:Y |
right |
2 |
|
A |
2 |
0 |
35 |
|
67 |
|
Camions |
|
C:110:Y |
|
2 |
|
A |
3 |
0 |
67 |
|
68 |
|
Maquettes bois 3D |
|
C:463:Y |
|
2 |
|
A |
4 |
0 |
68 |
|
37 |
|
Maquettes bois |
|
C:87:Y |
right |
2 |
|
A |
5 |
0 |
37 |
|
44 |
|
Bateaux |
|
C:14:Y |
|
2 |
|
A |
6 |
0 |
44 |
|
39 |
|
Maquettes militaires |
|
C:2:Y |
right |
2 |
|
A |
6 |
0 |
39 |
|
36 |
|
Motos |
|
C:11:Y |
right |
2 |
|
A |
7 |
0 |
36 |
|
34 |
|
Peintures |
|
C:36:Y |
right |
2 |
|
A |
8 |
0 |
34 |
|
33 |
|
Outils, accessoires |
|
C:23:Y |
right |
2 |
|
A |
9 |
0 |
33 |
|
43 |
|
Figurines |
|
C:17:Y |
|
2 |
|
A |
10 |
0 |
43 |
|
45 |
|
Décors |
|
C:21:Y |
|
2 |
|
A |
10 |
0 |
45 |
|
70 |
|
Puzzles et Maquette 3D |
|
C:451:Y |
|
2 |
N |
A |
20 |
0 |
70 |
|
41 |
http://www.france-maquette.fr/maquettes-kits-complets.html |
KITS |
|
C:32:N |
|
2 |
|
A |
30 |
0 |
41 |
|
40 |
|
Maquettes à Thème |
|
C:114:Y |
|
2 |
|
A |
31 |
0 |
40 |
|
48 |
|
Premières maquettes |
|
C:119:Y |
|
2 |
|
A |
40 |
0 |
48 |
|
42 |
|
Maquettes adultes |
|
C:0:N |
|
2 |
|
A |
50 |
0 |
42 |
|
71 |
|
TOUTES LES MAQUETTES |
|
C:0:N |
|
2 |
N |
A |
50 |
0 |
71 |
|
29 |
index.php?dispatch=sitemap.view |
Plan du site |
|
|
right |
2 |
N |
A |
70 |
0 |
29 |
|