Query time 0.00118
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "9.74"
},
"grouping_operation": {
"using_filesort": false,
"nested_loop": [
{
"table": {
"table_name": "cscart_products",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"status"
],
"key": "PRIMARY",
"used_key_parts": [
"product_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": "3K"
},
"used_columns": [
"product_id",
"product_code",
"product_type",
"owner_id",
"status",
"list_price",
"amount",
"weight",
"length",
"width",
"height",
"shipping_freight",
"low_avail_limit",
"timestamp",
"is_edp",
"edp_shipping",
"unlimited_download",
"tracking",
"free_shipping",
"zero_price_action",
"is_pbp",
"is_op",
"is_oper",
"company_id",
"is_returnable",
"return_period",
"avail_since",
"localization",
"min_qty",
"max_qty",
"qty_step",
"list_qty_count",
"tax_ids",
"age_verification",
"age_limit",
"usergroup_ids",
"options_type",
"exceptions_type",
"details_layout",
"shipping_params",
"out_of_stock_actions",
"updated_timestamp",
"facebook_obj_type",
"parent_product_id"
]
}
},
{
"table": {
"table_name": "popularity",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"total"
],
"key": "PRIMARY",
"used_key_parts": [
"product_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": "32"
},
"used_columns": [
"product_id",
"total"
]
}
},
{
"table": {
"table_name": "cscart_product_sales",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"pa"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id",
"product_id"
],
"key_length": "6",
"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": "16"
},
"used_columns": [
"category_id",
"product_id",
"amount"
]
}
},
{
"table": {
"table_name": "cscart_product_prices",
"access_type": "ref",
"possible_keys": [
"membership",
"product_id",
"lower_limit",
"membership_id"
],
"key": "product_id",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"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": "24"
},
"used_columns": [
"product_id",
"price",
"lower_limit",
"usergroup_id",
"percentage_discount"
],
"attached_condition": "<if>(is_not_null_compl(cscart_product_prices), ((`ea201_francemaqu`.`cscart_product_prices`.`lower_limit` = 1) and (`ea201_francemaqu`.`cscart_product_prices`.`usergroup_id` in (0,0,1))), true)"
}
},
{
"table": {
"table_name": "cscart_product_descriptions",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"product_id"
],
"key": "PRIMARY",
"used_key_parts": [
"product_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": "1.00",
"eval_cost": "0.20",
"prefix_cost": "2.40",
"data_read_per_join": "3K"
},
"used_columns": [
"product_id",
"lang_code",
"product",
"shortname",
"short_description",
"full_description",
"meta_keywords",
"meta_description",
"search_words",
"page_title",
"age_warning_message",
"promo_text",
"cls_stop_words"
]
}
},
{
"table": {
"table_name": "shared_prices",
"access_type": "ref",
"possible_keys": [
"usergroup",
"product_id",
"company_id",
"lower_limit",
"usergroup_id"
],
"key": "product_id",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"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": "3.60",
"data_read_per_join": "32"
},
"used_columns": [
"product_id",
"price",
"percentage_discount",
"lower_limit",
"company_id",
"usergroup_id"
],
"attached_condition": "<if>(is_not_null_compl(shared_prices), ((`ea201_francemaqu`.`shared_prices`.`lower_limit` = 1) and (`ea201_francemaqu`.`shared_prices`.`company_id` = 1) and (`ea201_francemaqu`.`shared_prices`.`usergroup_id` in (0,0,1))), true)"
}
},
{
"table": {
"table_name": "companies",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"company_id"
],
"key_length": "4",
"ref": [
"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": "4.80",
"data_read_per_join": "5K"
},
"used_columns": [
"company_id",
"status",
"company"
],
"attached_condition": "<if>(found_match(companies), ((`ea201_francemaqu`.`companies`.`status` = 'A') or 0), true)"
}
},
{
"table": {
"table_name": "cscart_products_categories",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"pt"
],
"key": "pt",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 2,
"rows_produced_per_join": 2,
"filtered": "100.00",
"cost_info": {
"read_cost": "2.00",
"eval_cost": "0.40",
"prefix_cost": "7.20",
"data_read_per_join": "32"
},
"used_columns": [
"product_id",
"category_id",
"link_type",
"category_position"
]
}
},
{
"table": {
"table_name": "cscart_categories",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"c_status",
"p_category_id"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"ref": [
"ea201_francemaqu.cscart_products_categories.category_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "5.00",
"cost_info": {
"read_cost": "2.00",
"eval_cost": "0.02",
"prefix_cost": "9.60",
"data_read_per_join": "267"
},
"used_columns": [
"category_id",
"usergroup_ids",
"status",
"storefront_id"
],
"attached_condition": "((`ea201_francemaqu`.`cscart_categories`.`storefront_id` in (0,1)) and ((`ea201_francemaqu`.`cscart_categories`.`usergroup_ids` = '') or find_in_set(0,`ea201_francemaqu`.`cscart_categories`.`usergroup_ids`) or find_in_set(1,`ea201_francemaqu`.`cscart_categories`.`usergroup_ids`)) and (`ea201_francemaqu`.`cscart_categories`.`status` in ('A','H')))"
}
},
{
"table": {
"table_name": "cscart_seo_names",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"dispatch"
],
"key": "PRIMARY",
"used_key_parts": [
"object_id",
"type",
"dispatch",
"lang_code",
"company_id"
],
"key_length": "210",
"ref": [
"const",
"const",
"const",
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.05",
"eval_cost": "0.02",
"prefix_cost": "9.67",
"data_read_per_join": "173"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"lang_code",
"company_id",
"path"
]
}
},
{
"table": {
"table_name": "cscart_discussion",
"access_type": "const",
"possible_keys": [
"object_id",
"company_id"
],
"key": "object_id",
"used_key_parts": [
"object_id",
"object_type",
"company_id"
],
"key_length": "10",
"ref": [
"const",
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.05",
"eval_cost": "0.02",
"prefix_cost": "9.74",
"data_read_per_join": "2"
},
"used_columns": [
"object_id",
"object_type",
"type",
"company_id"
]
}
}
]
}
}
}
Result
| product_id |
product_code |
product_type |
owner_id |
status |
list_price |
amount |
weight |
length |
width |
height |
shipping_freight |
low_avail_limit |
timestamp |
is_edp |
edp_shipping |
unlimited_download |
tracking |
free_shipping |
zero_price_action |
is_pbp |
is_op |
is_oper |
company_id |
is_returnable |
return_period |
avail_since |
localization |
min_qty |
max_qty |
qty_step |
list_qty_count |
tax_ids |
age_verification |
age_limit |
usergroup_ids |
options_type |
exceptions_type |
details_layout |
shipping_params |
out_of_stock_actions |
updated_timestamp |
facebook_obj_type |
parent_product_id |
lang_code |
product |
shortname |
short_description |
full_description |
meta_keywords |
meta_description |
search_words |
page_title |
age_warning_message |
promo_text |
cls_stop_words |
price |
category_ids |
popularity |
company_name |
sales_amount |
seo_name |
seo_path |
discussion_type |
| 10682 |
TAM-14016 |
P |
0 |
A |
0.00 |
5 |
0.000 |
0 |
0 |
0 |
0.00 |
0 |
1701344813 |
N |
N |
N |
B |
N |
R |
N |
N |
N |
1 |
Y |
10 |
0 |
|
0 |
0 |
0 |
0 |
6 |
N |
0 |
0 |
P |
F |
default |
a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} |
S |
1727340056 |
activity |
0 |
fr |
Honda CX500 Turbo 1/12 - Tamiya 14016 |
|
<p> Maquette moto japonaise de sport à peindre et à monter : Honda CX500 Turbo 1/12 - Tamiya 14016</p> |
<h2>Maquette moto : Honda CX500 Turbo 1/12 - <a href="http://france-maquette.fr/index.php?dispatch=products.search&features_hash=V86&variant_id=86">Tamiya</a> 14016</h2>
<h3>Kit de modélisme de moto japonaise à peindre et à monter</h3>
<p><strong>Contenu de la boîte de modélisme :</strong></p>
<ul>
<li><strong>1 maquette Honda CX500 Turbo 1/12</strong></li>
<li>Notice de montage</li>
<li>Décalcomanies</li>
</ul>
<p><strong>Informations sur le coffret Tamiya représentant une moto sportive moderne :</strong></p>
<p>Découvrez l'innovation révolutionnaire de la Honda CX500 Turbo de 1980 avec la maquette Tamiya 14016 à l'échelle 1/12. Cette moto emblématique marque l'histoire en tant que première moto de série turbocompressée au monde, et cette maquette vous permet de revivre son excellence technique.</p>
<p>La CX500 Turbo était équipée d'un moteur bicylindre en V refroidi par liquide, développant une puissance impressionnante de 82 ch grâce à son système de turbocompression novateur, conçu en collaboration avec IHI. Tous ces détails techniques sont fidèlement reproduits dans cette maquette, en mettant particulièrement en avant le moteur turbocompressé, vous permettant de comprendre son fonctionnement en détail.</p>
<p>Le modèle comporte également des éléments de conception avancée, tels qu'un capot monobloc avec phare intégré, une suspension arrière Pro-Link unique, une suspension avant anti-piqué réglable, et bien plus encore. Les vis métalliques renforcent la rigidité des roues et des fourches avant, et les conduites de frein et autres câbles sont représentés avec des tubes en vinyle pour plus de réalisme.</p>
<p>Enrichissez votre collection de maquettes avec cette Honda CX500 Turbo, un chef-d'œuvre de l'ingénierie moto des années 80, dont le modèle réduit capturera l'essence de cette époque révolutionnaire.</p> |
maquette Honda CX500 Turbo 1/12, maquette moto, maquette 14016 |
Maquette moto japonaise de sport à peindre et à monter : Honda CX500 Turbo 1/12 - Tamiya 14016 |
14016, maquette Honda CX500 Turbo 1/12, maquette moto |
Tamiya 14016 - Maquette moto Honda CX500 Turbo 1/12 |
|
|
|
37.70000000 |
12M,11 |
4213 |
France Maquette |
9 |
honda-cx500-turbo-1-12-tamiya-14016 |
11/12 |
B |