Query time 0.00064
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "1.20"
},
"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.20",
"prefix_cost": "0.00",
"data_read_per_join": "5K"
},
"used_columns": [
"category_id",
"parent_id",
"id_path",
"level",
"company_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",
"ab__fn_category_status",
"ab__fn_label_color",
"ab__fn_label_background",
"ab__fn_use_origin_image",
"ab__lc_catalog_image_control",
"ab__lc_landing",
"ab__lc_subsubcategories",
"ab__lc_menu_id",
"ab__lc_how_to_use_menu",
"ab__lc_inherit_control",
"edp_quote_lang_var",
"amz_item_type",
"amz_browse_node",
"amz_synchronization",
"amz_feed_product_type",
"amz_template_type",
"amz_template_version",
"amz_category",
"ebay_category",
"storefront_id"
]
}
},
{
"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.20",
"prefix_cost": "0.00",
"data_read_per_join": "4K"
},
"used_columns": [
"category_id",
"lang_code",
"category",
"description",
"meta_keywords",
"meta_description",
"page_title",
"age_warning_message",
"ab__fn_label_text",
"ab__fn_label_show",
"ab__custom_category_h1"
]
}
},
{
"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": "1.00",
"eval_cost": "0.20",
"prefix_cost": "1.20",
"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 |
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 |
ab__fn_category_status |
ab__fn_label_color |
ab__fn_label_background |
ab__fn_use_origin_image |
ab__lc_catalog_image_control |
ab__lc_landing |
ab__lc_subsubcategories |
ab__lc_menu_id |
ab__lc_how_to_use_menu |
ab__lc_inherit_control |
edp_quote_lang_var |
amz_item_type |
amz_browse_node |
amz_synchronization |
amz_feed_product_type |
amz_template_type |
amz_template_version |
amz_category |
ebay_category |
storefront_id |
lang_code |
category |
description |
meta_keywords |
meta_description |
page_title |
age_warning_message |
ab__fn_label_text |
ab__fn_label_show |
ab__custom_category_h1 |
name |
object_id |
type |
dispatch |
path |
seo_name |
seo_path |
7073 |
6980 |
5362/6980/7073 |
3 |
0 |
0 |
A |
0 |
50 |
1623967200 |
N |
|
N |
0 |
N |
0 |
|
|
default |
0 |
N |
N |
Y |
#ffffff |
#333333 |
N |
none |
N |
0 |
0 |
N |
N |
|
|
|
Y |
|
|
|
|
|
0 |
en |
Baby Mobile Accessories |
|
Baby Mobile Accessories, best quality, discounts and offers, competitive prices, cheap baby play products, daily care of baby toys, products, necessary accessory for safety and fun of babies, continuous entertainment, accessories for a daily fun , |
Baby Mobile Accessories, Discover the products of the Health & Beauty category only on Webmarco. Low price products and fast shipping throughout Europe.
Original product. Buy online on WebMarco |
Baby Mobile Accessories - Shop Online Baby Mobile Accessories on Webmarco |
|
|
Y |
|
baby-mobile-accessories |
7073 |
c |
|
5362/6980 |
baby-mobile-accessories |
5362/6980 |