Query time 0.00805
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "8.48"
},
"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": 0,
"rows_produced_per_join": 1,
"filtered": "0.00",
"unique_row_not_found": true,
"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": "0.00",
"eval_cost": "0.20",
"prefix_cost": "1.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": "2.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": "0.00",
"eval_cost": "0.20",
"prefix_cost": "2.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": 4,
"rows_produced_per_join": 4,
"filtered": "100.00",
"cost_info": {
"read_cost": "4.00",
"eval_cost": "0.80",
"prefix_cost": "7.60",
"data_read_per_join": "64"
},
"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": "0.00",
"eval_cost": "0.04",
"prefix_cost": "8.40",
"data_read_per_join": "534"
},
"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.00",
"eval_cost": "0.04",
"prefix_cost": "8.44",
"data_read_per_join": "347"
},
"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.00",
"eval_cost": "0.04",
"prefix_cost": "8.48",
"data_read_per_join": "4"
},
"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 |
10749 |
REV-00300 |
P |
0 |
H |
0.00 |
0 |
0.000 |
0 |
0 |
0 |
0.00 |
0 |
1696543200 |
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 |
1711457067 |
activity |
0 |
fr |
Puzzle 3D Harry Potter : Grand hall de Poudlard - Revell 300 |
|
Puzzle 3D facile à monter sans colle ni peinture pour les enfants à partir de 8 ans : Harry Potter - Grand hall de Poudlard - Revell 300 |
<h2>Puzzle 3D Harry Potter : Grand hall de Poudlard - Revell 300</h2>
<h3>Bâtiment emblématique de l'univers de Harry Potter facile à monter pour les enfants à partir de 8 ans</h3>
<p><strong>Contenu du coffret Revell :</strong></p>
<ul>
<li>1 x Puzzle 3D Harry Potter : Grand hall de Poudlard</li>
<li>Notice de montage</li>
</ul>
<p><strong>Information sur le modèle de l'école de Poudlard de Harry Potter en puzzle 3D Revell facile à monter :</strong></p>
<p>Revell présente un puzzle 3D du Grand Hall de Poudlard, un incontournable pour les jeunes sorciers et sorcières de 8 ans et plus. Cette maquette, adaptée aux débutants, plonge les fans de Harry Potter au cœur de la magie du célèbre château de Poudlard.</p>
<p>Construisez méticuleusement chaque détail de ce lieu emblématique, du plafond étoilé aux grandes tables de banquet. Le Grand Hall est le centre névralgique de Poudlard, où les étudiants se rassemblent pour des repas somptueux, des célébrations festives et bien plus encore. Grâce à cette maquette, vous pouvez recréer l'atmosphère chaleureuse et mystique de ce lieu magique directement chez vous.</p>
<p>Ce puzzle 3D est un excellent moyen d'explorer la créativité tout en se plongeant dans l'univers de Harry Potter. Une fois terminée, cette maquette devient un objet de collection époustouflant et un rappel constant du monde enchanté de Poudlard. Offrez aux jeunes sorciers l'opportunité de s'immerger pleinement dans la magie de cet univers légendaire.</p> |
puzzle 3D revell, maquette revell, maquette Grand hall de Poudlard |
Puzzle 3D facile à monter sans colle ni peinture pour les enfants à partir de 8 ans : Harry Potter - Grand hall de Poudlard - Revell 300
|
Revell 300, Revell 300, maquette Puzzle 3D Harry Potter : Grand hall de Poudlard |
Revell 300 - Puzzle 3D Harry Potter - Grand hall de Poudlard |
|
|
|
20.10000000 |
451M,112,119,114 |
2524 |
France Maquette |
|
puzzle-3d-harry-potter-grand-hall-de-poudlard-revell-300 |
451 |
B |