Query time 0.00052
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "3.50"
},
"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.10",
"prefix_cost": "0.00",
"data_read_per_join": "4K"
},
"used_columns": [
"product_id",
"product_code",
"status",
"company_id",
"amount",
"weight",
"shipping_freight",
"updated_timestamp",
"usergroup_ids",
"is_edp",
"edp_shipping",
"tracking",
"free_shipping",
"zero_price_action",
"out_of_stock_actions",
"min_qty",
"max_qty",
"qty_step",
"list_qty_count",
"tax_ids",
"shipping_params"
]
}
},
{
"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.10",
"prefix_cost": "0.00",
"data_read_per_join": "4K"
},
"used_columns": [
"product_id",
"lang_code",
"product",
"short_description"
]
}
},
{
"table": {
"table_name": "cscart_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.10",
"prefix_cost": "0.00",
"data_read_per_join": "6K"
},
"used_columns": [
"company_id",
"status"
]
}
},
{
"table": {
"table_name": "cscart_company_descriptions",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"company_id",
"lang_code"
],
"key_length": "10",
"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.10",
"prefix_cost": "0.00",
"data_read_per_join": "1K"
},
"used_columns": [
"company_id",
"lang_code",
"i18n_company"
]
}
},
{
"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": 5,
"rows_produced_per_join": 5,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.25",
"eval_cost": "0.50",
"prefix_cost": "1.75",
"data_read_per_join": "80"
},
"used_columns": [
"product_id",
"category_id",
"link_type"
]
}
},
{
"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": [
"wearethehelpful_scalesta_net.cscart_products_categories.category_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "5.00",
"cost_info": {
"read_cost": "1.25",
"eval_cost": "0.03",
"prefix_cost": "3.50",
"data_read_per_join": "668"
},
"used_columns": [
"category_id",
"storefront_id",
"usergroup_ids",
"status"
],
"attached_condition": "((`wearethehelpful_scalesta_net`.`cscart_categories`.`storefront_id` in (0,1)) and ((`wearethehelpful_scalesta_net`.`cscart_categories`.`usergroup_ids` = '') or (0 <> find_in_set(0,`wearethehelpful_scalesta_net`.`cscart_categories`.`usergroup_ids`)) or (0 <> find_in_set(1,`wearethehelpful_scalesta_net`.`cscart_categories`.`usergroup_ids`))) and (`wearethehelpful_scalesta_net`.`cscart_categories`.`status` in ('A','H')))"
}
}
]
}
}
}
Result
| product_id |
company_id |
category_ids |
product_code |
weight |
tracking |
product |
short_description |
is_edp |
edp_shipping |
shipping_freight |
free_shipping |
zero_price_action |
tax_ids |
qty_step |
list_qty_count |
max_qty |
min_qty |
in_stock |
shipping_params |
company_status |
out_of_stock_actions |
updated_timestamp |
company_name |
| 946 |
32 |
303,297,267,277,282 |
|
0.000 |
|
About Hedgehog |
<p><span style="font-size:21px;font-weight:700;">'About Hedgehog' by Dani Seatter</span></p>
<p>In times of loss, it can be hard to find the words (and strength) to explain the concept of death to children. <em>Let this book help.</em><em></em></p>
<p>‘About Hedgehog’ is Dani’s third award winning sustainably made book for early years. Dealing with important issues around childhood bereavement, Dani has created a gentle story to enable both children and parents, as well as early years practitioners and therapists, to begin to have those all important conversations around death and what that means. Whether children have experienced the death of a beloved pet, a family member or a significant bereavement with a parent or sibling, this book is the perfect way to help young children explore their feelings by creating a safe environment from which to do so.</p> |
N |
N |
0.00 |
N |
|
|
|
|
|
|
13 |
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;} |
A |
N |
1766489131 |
Eco-Able Ltd |