Query time 0.00078
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "7.46"
},
"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_categories",
"access_type": "ALL",
"possible_keys": [
"PRIMARY",
"c_status",
"p_category_id"
],
"rows_examined_per_scan": 59,
"rows_produced_per_join": 2,
"filtered": "4.00",
"cost_info": {
"read_cost": "6.40",
"eval_cost": "0.24",
"prefix_cost": "6.64",
"data_read_per_join": "6K"
},
"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')))"
}
},
{
"table": {
"table_name": "cscart_products_categories",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"pt"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id",
"product_id"
],
"key_length": "6",
"ref": [
"wearethehelpful_scalesta_net.cscart_categories.category_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 2,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.59",
"eval_cost": "0.24",
"prefix_cost": "7.46",
"data_read_per_join": "37"
},
"used_columns": [
"product_id",
"category_id",
"link_type"
]
}
}
]
}
}
}
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 |
| 1127 |
43 |
267,271,288,294,276,277,278,297M,300,309,319,323 |
|
0.000 |
B |
The Full Anara Experience - Hydrate, Nourish & Protect |
<p>A full-circle ritual for the skin and the senses.
The <b>Full Anara Experience</b> is a luxury 5-step botanical skincare set that hydrates, nourishes and protects your complexion through every season of life.</p>
<p>Formulated with clean, pregnancy and menopause friendly ingredients, it’s the ultimate way to restore radiance and balance while gifting a moment of calm, ritual and care.</p>
<h4>Why It’s Helpful</h4>
<p>When hormones, stress, or life changes leave your skin feeling tired, dry or sensitive, this ritual helps bring it back to balance. Each step works in harmony to hydrate deeply, smooth fine lines, and protect the skin barrier, all without the harsh ingredients that can disrupt hormones or overwhelm delicate skin. It’s more than skincare; it’s an act of self-care that grounds, restores, and gives back energy when life takes it out of you.</p>
<p></p> |
N |
N |
0.00 |
N |
|
6 |
|
|
|
|
3 |
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 |
1769863372 |
Anara Skincare |