Query time 0.00727
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "1.20"
},
"nested_loop": [
{
"table": {
"table_name": "cscart_pages",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"page_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.20",
"prefix_cost": "0.00",
"data_read_per_join": "2K"
},
"used_columns": [
"page_id",
"parent_id",
"id_path",
"status",
"page_type",
"position",
"timestamp",
"membership_id",
"localization",
"new_window",
"use_avail_period",
"avail_from_timestamp",
"avail_till_timestamp",
"usergroup_ids",
"company_id"
]
}
},
{
"table": {
"table_name": "cscart_page_descriptions",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"page_id",
"lang_code"
],
"key_length": "9",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.20",
"prefix_cost": "0.00",
"data_read_per_join": "3K"
},
"used_columns": [
"page_id",
"lang_code",
"page",
"description",
"meta_keywords",
"meta_description",
"page_title",
"link"
]
}
},
{
"table": {
"table_name": "cscart_ult_objects_sharing",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"share_object_id",
"share_company_id",
"share_object_type"
],
"key_length": "159",
"ref": [
"const",
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.20",
"prefix_cost": "0.00",
"data_read_per_join": "160"
},
"used_columns": [
"share_company_id",
"share_object_id",
"share_object_type"
]
}
},
{
"table": {
"table_name": "cscart_seo_names",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"dispatch"
],
"key": "PRIMARY",
"used_key_parts": [
"object_id",
"type",
"dispatch",
"lang_code"
],
"key_length": "206",
"ref": [
"const",
"const",
"const",
"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": "1.20",
"data_read_per_join": "1K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"lang_code",
"path"
]
}
}
]
}
}
Result
page_id |
parent_id |
id_path |
status |
page_type |
position |
timestamp |
membership_id |
localization |
new_window |
use_avail_period |
avail_from_timestamp |
avail_till_timestamp |
usergroup_ids |
company_id |
lang_code |
page |
description |
meta_keywords |
meta_description |
page_title |
link |
seo_name |
seo_path |
28 |
12 |
12/28 |
A |
T |
10 |
1225926000 |
0 |
|
0 |
N |
0 |
0 |
0 |
1 |
fr |
Maquette La Bonne Franquette - Montmartre |
<p><strong>Maquette La Bonne Franquette - Montmartre</strong></p>
<p>Cette maquette est une reproduction du restaurant La Bonne Franquette à Montmartre. Elle est insérée dans une boite à chaussures. Elle a été réalisée en carte plastique 1,5 mm + profilés Evergreen. Les huisseries sont récupérées sur des reliquats de modèles Faller. Les affiches sont des reproductions en impression laser de photos prises sur place. La Renault 4L est un modèle Norev. Les ardoises sont faites en petits morceaux découpés dans des plaques Evergreen de 1mm , peintes en acrylique et patinées en terre à décors.<br /> <br /> Cette maquette a été réalisée par notre partenaire VIP Maquettes.</p>
<p><img style="width: 530px; height: 424px;" src="http://www.diorama.fr/images/common_images/bonne_franquette_700.jpg" alt="" width="530" height="451" /></p>
<p><img style="width: 530px; height: 424px;" src="http://www.diorama.fr/images/common_images/bonne_franquette_383_700.jpg" alt="" width="530" height="451" /></p>
<p><img style="width: 530px; height: 424px;" src="http://www.diorama.fr/images/common_images/bonne_franquette_377_700.jpg" alt="" width="530" height="451" /></p> |
Maquette La Bonne Franquette - Montmartre |
Maquette La Bonne Franquette - Montmartre |
Maquette La Bonne Franquette - Montmartre |
|
maquette-la-bonne-franquette-montmartre-fr |
12 |