Query time 0.00532
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "0.35"
},
"nested_loop": [
{
"table": {
"table_name": "cscart_categories",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"c_status",
"p_category_id"
],
"key": "PRIMARY",
"used_key_parts": [
"category_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": "2K"
},
"used_columns": [
"category_id",
"parent_id",
"id_path",
"level",
"company_id",
"storefront_id",
"usergroup_ids",
"status",
"product_count",
"position",
"timestamp",
"is_op",
"localization",
"age_verification",
"age_limit",
"parent_age_verification",
"parent_age_limit",
"selected_views",
"default_view",
"product_details_view",
"product_columns",
"is_trash",
"is_default",
"category_type"
]
}
},
{
"table": {
"table_name": "cscart_category_descriptions",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"category_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": "3K"
},
"used_columns": [
"category_id",
"lang_code",
"category",
"description",
"meta_keywords",
"meta_description",
"page_title",
"age_warning_message"
]
}
},
{
"table": {
"table_name": "cscart_seo_names",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"dispatch"
],
"key": "PRIMARY",
"used_key_parts": [
"object_id",
"type",
"dispatch",
"lang_code"
],
"key_length": "206",
"ref": [
"const",
"const",
"const",
"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": "1K"
},
"used_columns": [
"name",
"object_id",
"company_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
]
}
}
Result
| category_id |
parent_id |
id_path |
level |
company_id |
storefront_id |
usergroup_ids |
status |
product_count |
position |
timestamp |
is_op |
localization |
age_verification |
age_limit |
parent_age_verification |
parent_age_limit |
selected_views |
default_view |
product_details_view |
product_columns |
is_trash |
is_default |
category_type |
lang_code |
category |
description |
meta_keywords |
meta_description |
page_title |
age_warning_message |
name |
object_id |
type |
dispatch |
path |
seo_name |
seo_path |
| 267 |
0 |
267 |
1 |
0 |
0 |
0 |
A |
254 |
3 |
1695250800 |
N |
|
N |
0 |
N |
0 |
|
|
default |
0 |
N |
N |
C |
en |
Family + Self Care |
<p><span style="color: var(--redactor2-text-color);">Sometimes, the greatest gift isn’t more - it’s less. More of what matters, less of what doesn’t. Our curated </span>self-care gifts<span style="color: var(--redactor2-text-color);"> and </span>family wellbeing gifts<span style="color: var(--redactor2-text-color);"><strong> </strong>nurture both her and those she loves, offering real support when it’s needed most.</span><span style="color: var(--redactor2-text-color);"></span></p> |
pamper gift ideas, bath gift sets, stress relieving presents, beauty gifts, relaxing gifts, self care gifts, mental health gifts, self care hamper, wellbeing gifts, pamper gift ideas, sympathy gifts, new mum gifts, baby shower gifts, gifts for friends, |
Thoughtful family and self-care gifts and bundles designed to nourish, comfort, and support. From relaxation essentials to practical gifts for busy parents, our curated collections bring care to every stage of life. |
Helpful gifts for family and self care |
|
family-self-care |
267 |
c |
|
|
family-self-care |
|