Query time 0.00073
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 |
6067 |
6008 |
5291/6008/6067 |
3 |
0 |
0 |
A |
0 |
40 |
1623967200 |
N |
|
N |
0 |
N |
0 |
|
|
default |
0 |
N |
N |
Y |
#ffffff |
#333333 |
N |
none |
N |
0 |
0 |
N |
N |
|
|
|
Y |
|
|
|
|
|
0 |
en |
Concession Food Containers |
|
Concession Food Containers, Competitive Prices, Cheap Prices, Products On Webmarco, Online Shopping, Online Shops, Webmarco, Web Marco, Marcoweb, Marco Web, Marcoweb, Concession Food Containers for Sale, Buy Concession Food Containers Online |
Discover the products of the A category only on Webmarco. Buy safe, fast and high quality product by just a click on webmarco.com! |
Concession Food Containers - Shop Online on Webmarco |
|
|
Y |
|
concession-food-containers |
6067 |
c |
|
5291/6008 |
concession-food-containers |
5291/6008 |