Query time 0.00601
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "0.70"
},
"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": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.25",
"eval_cost": "0.10",
"prefix_cost": "0.35",
"data_read_per_join": "16"
},
"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": "0.25",
"eval_cost": "0.01",
"prefix_cost": "0.70",
"data_read_per_join": "133"
},
"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 |
| 403 |
22 |
286,276M |
|
0.000 |
|
Postnatal + Feeding Support - GROW + GATHER (GIFT VOUCHER - Edinburgh) |
<h4><span style="color: var(--redactor2-fg-heading);">Postnatal + Feeding Support - The gift of support and peace of mind when they have welcomed a new little love into the world.</span></h4>
<p><strong>**Classes are located in Edinburgh**</strong></p>
<p>An at home support session once baby has arrived with time to focus on feeding. Sessions can last from one hour to a whole afternoon depending on your need. One of our qualified midwives can visit you at home, at a time that suits you and when you know baby might be ready to feed, to ensure that feeding is going well and to help you with any issue that you might be having. Great for reassurance if this is your first baby as well as promoting confidence for anyone who has fed before. Happy to chat about your birth experiences and make sure that you are feeling well physically and emotionally. </p>
<h5></h5>
<h5>
</h5>
<h5></h5>
<p><br></p>
<p></p> |
N |
N |
0.00 |
N |
|
|
|
|
|
|
10 |
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 |
1766492956 |
Grow+Gather |