Query time 0.00068
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 |
6131 |
6042 |
5742/5811/6042/6131 |
4 |
0 |
0 |
A |
0 |
110 |
1623967200 |
N |
|
N |
0 |
N |
0 |
|
|
default |
0 |
N |
N |
Y |
#ffffff |
#333333 |
N |
none |
N |
0 |
0 |
N |
N |
|
|
|
Y |
|
|
|
|
|
0 |
en |
Camera Image Sensors |
|
Camera Image Sensors, Competitive Prices, Cheap Prices, Products On Webmarco, Online Shopping, Online Shops, Webmarco, Web Marco, Marcoweb, Marco Web, Marcoweb, Camera Image Sensors for Sale, Buy Camera Image Sensors Online |
Discover the products of the Camera Image Sensors category only on Webmarco. Buy safe, fast and high quality product by just a click on webmarco.com! |
Camera Image Sensors - Shop Online on Webmarco |
|
|
Y |
|
camera-image-sensors |
6131 |
c |
|
5742/5811/6042 |
camera-image-sensors |
5742/5811/6042 |