Query time 0.00098
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",
"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 |
seo_name |
seo_path |
7093 |
7022 |
5372/5495/5847/7022/7093 |
5 |
0 |
0 |
A |
0 |
10 |
1623967200 |
N |
|
N |
0 |
N |
0 |
|
|
default |
0 |
N |
N |
Y |
#ffffff |
#333333 |
N |
none |
N |
0 |
0 |
N |
N |
|
|
|
Y |
|
|
|
|
|
0 |
en |
Guitar Accessories |
|
Guitar Accessories, Guitar Accessories for Sale, Acoustic Guitar Pickups, Guitar Capor, Eletric Guitar Pickups, Guitar Cases, Guitar Gig Bags, Guitar Fittings, Guitar Parts, Guitar Humidifers, Guitar Picks, Guitar Slides, Guitar Stands, webmarco |
Discover the products of the Guitar Accessories category only on Webmarco. Buy safe, fast and high quality product by just a click on webmarco.com! |
Guitar Accessories - Shop Online on Webmarco |
|
|
Y |
|
guitar-accessories |
5372/5495/5847/7022 |