{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "17.46"
},
"ordering_operation": {
"using_filesort": true,
"nested_loop": [
{
"table": {
"table_name": "l",
"access_type": "ALL",
"rows_examined_per_scan": 69,
"rows_produced_per_join": 1,
"filtered": "1.45",
"cost_info": {
"read_cost": "16.06",
"eval_cost": "0.20",
"prefix_cost": "16.26",
"data_read_per_join": "232"
},
"used_columns": [
"location_id",
"dispatch",
"is_default",
"object_ids",
"layout_id",
"position",
"custom_html"
],
"attached_condition": "((`ea201_diorama`.`l`.`layout_id` = 1) and (`ea201_diorama`.`l`.`dispatch` = 'products.view') and (find_in_set(30387,`ea201_diorama`.`l`.`object_ids`) or (`ea201_diorama`.`l`.`object_ids` = '')))"
}
},
{
"table": {
"table_name": "d",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"location_id",
"lang_code"
],
"key_length": "10",
"ref": [
"ea201_diorama.l.location_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.00",
"eval_cost": "0.20",
"prefix_cost": "17.46",
"data_read_per_join": "240"
},
"used_columns": [
"location_id",
"lang_code",
"name",
"title",
"meta_description",
"meta_keywords"
],
"attached_condition": "<if>(is_not_null_compl(d), (`ea201_diorama`.`d`.`location_id` = `ea201_diorama`.`l`.`location_id`), true)"
}
}
]
}
}
}
location_id | dispatch | is_default | object_ids | layout_id | position | custom_html | lang_code | name | title | meta_description | meta_keywords |
---|---|---|---|---|---|---|---|---|---|---|---|
19 | products.view | 0 | 1 | 0 | fr | Produits | Diorama.fr - Décors miniatures : arbres miniatures, figurines, articles miniatures. | N° 1 du décor miniature - tout pour construire votre diorama, maquette, modélisme maquette d’architecte. Arbres miniatures, figurines et personnages miniatures, décors miniatures, crèches de noël | miniatures, maquettes, maquette, décors miniatures, crèches provençales, maquettes, arbres miniatures, végétation miniature, végétations miniatures, circuits de trains, personnages maquettes, figurines maquettes, figurines, personnages, plateaux, décors architectes, Noch, Heki, Preiser, Busch, Brawa, Evergreen, Woodland, Mid, Revell, Auhagen, échelles 1:87, 1:160, 1:120, 1:220, 1:100, 1:200, 1:43, 1:50, 1:22,5, HO, N, Z, TT, G, O, diorama, dioramas, |