Query time 0.00157
JSON explain
{
"query_block": {
"select_id": 1,
"filesort": {
"sort_key": "cscart_categories.is_trash, cscart_categories.position, cscart_category_descriptions.category",
"temporary_table": {
"table": {
"table_name": "cscart_categories",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"c_status",
"parent",
"id_path",
"p_category_id"
],
"key": "parent",
"key_length": "3",
"used_key_parts": ["parent_id"],
"ref": ["const"],
"rows": 21,
"filtered": 100,
"attached_condition": "(cscart_categories.usergroup_ids = '' or find_in_set(0,cscart_categories.usergroup_ids) or find_in_set(1,cscart_categories.usergroup_ids)) and cscart_categories.`status` = 'A' and cscart_categories.id_path like '560/1121/%' and cscart_categories.category_id <> 265 and cscart_categories.storefront_id in (0,1)"
},
"table": {
"table_name": "cscart_category_descriptions",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "9",
"used_key_parts": ["category_id", "lang_code"],
"ref": ["admin_test.cscart_categories.category_id", "const"],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(cscart_category_descriptions.lang_code = 'ru')"
},
"table": {
"table_name": "cscart_seo_names",
"access_type": "ref",
"possible_keys": ["PRIMARY", "dispatch"],
"key": "PRIMARY",
"key_length": "206",
"used_key_parts": ["object_id", "type", "dispatch", "lang_code"],
"ref": [
"admin_test.cscart_categories.category_id",
"const",
"const",
"const"
],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(cscart_seo_names.`type` = 'c' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'ru')"
}
}
}
}
}
Result
category_id |
parent_id |
id_path |
category |
position |
status |
company_id |
storefront_id |
seo_name |
seo_path |
ab__lc_catalog_image_control |
ab__fn_category_status |
ab__fn_label_color |
ab__fn_label_background |
ab__fn_use_origin_image |
ab__fn_label_text |
ab__fn_label_show |
1122 |
1121 |
560/1121/1122 |
AceFast |
0 |
A |
0 |
0 |
acefast |
560/1121 |
none |
Y |
#ffffff |
#333333 |
N |
|
Y |
1123 |
1121 |
560/1121/1123 |
Apple |
0 |
A |
0 |
0 |
apple |
560/1121 |
none |
Y |
#ffffff |
#333333 |
N |
|
Y |
1124 |
1121 |
560/1121/1124 |
Apple Copy |
0 |
A |
0 |
0 |
apple-copy |
560/1121 |
none |
Y |
#ffffff |
#333333 |
N |
|
Y |
1125 |
1121 |
560/1121/1125 |
Baseus |
0 |
A |
0 |
0 |
baseus |
560/1121 |
none |
Y |
#ffffff |
#333333 |
N |
|
Y |
1126 |
1121 |
560/1121/1126 |
Belkin |
0 |
A |
0 |
0 |
belkin |
560/1121 |
none |
Y |
#ffffff |
#333333 |
N |
|
Y |
1127 |
1121 |
560/1121/1127 |
Bios |
0 |
A |
0 |
0 |
bios |
560/1121 |
none |
Y |
#ffffff |
#333333 |
N |
|
Y |
1128 |
1121 |
560/1121/1128 |
Borofone |
0 |
A |
0 |
0 |
borofone |
560/1121 |
none |
Y |
#ffffff |
#333333 |
N |
|
Y |
1129 |
1121 |
560/1121/1129 |
Breaking |
0 |
A |
0 |
0 |
breaking |
560/1121 |
none |
Y |
#ffffff |
#333333 |
N |
|
Y |
1130 |
1121 |
560/1121/1130 |
Deppa |
0 |
A |
0 |
0 |
deppa |
560/1121 |
none |
Y |
#ffffff |
#333333 |
N |
|
Y |
1131 |
1121 |
560/1121/1131 |
Gerffins |
0 |
A |
0 |
0 |
gerffins |
560/1121 |
none |
Y |
#ffffff |
#333333 |
N |
|
Y |
1132 |
1121 |
560/1121/1132 |
GP |
0 |
A |
0 |
0 |
gp |
560/1121 |
none |
Y |
#ffffff |
#333333 |
N |
|
Y |
1133 |
1121 |
560/1121/1133 |
Hoco |
0 |
A |
0 |
0 |
hoco |
560/1121 |
none |
Y |
#ffffff |
#333333 |
N |
|
Y |
1134 |
1121 |
560/1121/1134 |
Maxvi |
0 |
A |
0 |
0 |
maxvi |
560/1121 |
none |
Y |
#ffffff |
#333333 |
N |
|
Y |
1135 |
1121 |
560/1121/1135 |
Prime Line |
0 |
A |
0 |
0 |
prime-line |
560/1121 |
none |
Y |
#ffffff |
#333333 |
N |
|
Y |
1136 |
1121 |
560/1121/1136 |
Rivacase |
0 |
A |
0 |
0 |
rivacase |
560/1121 |
none |
Y |
#ffffff |
#333333 |
N |
|
Y |
1137 |
1121 |
560/1121/1137 |
Rocket |
0 |
A |
0 |
0 |
rocket |
560/1121 |
none |
Y |
#ffffff |
#333333 |
N |
|
Y |
1138 |
1121 |
560/1121/1138 |
Samsung |
0 |
A |
0 |
0 |
samsung |
560/1121 |
none |
Y |
#ffffff |
#333333 |
N |
|
Y |
1139 |
1121 |
560/1121/1139 |
uBear |
0 |
A |
0 |
0 |
ubear |
560/1121 |
none |
Y |
#ffffff |
#333333 |
N |
|
Y |
1140 |
1121 |
560/1121/1140 |
W.O.L.T. |
0 |
A |
0 |
0 |
w-o-l-t |
560/1121 |
none |
Y |
#ffffff |
#333333 |
N |
|
Y |
1141 |
1121 |
560/1121/1141 |
Xiaomi |
0 |
A |
0 |
0 |
xiaomi |
560/1121 |
none |
Y |
#ffffff |
#333333 |
N |
|
Y |
1142 |
1121 |
560/1121/1142 |
Тех Пак |
0 |
A |
0 |
0 |
teh-pak |
560/1121 |
none |
Y |
#ffffff |
#333333 |
N |
|
Y |
1299 |
1121 |
560/1121/1299 |
K-DOO |
10 |
A |
0 |
0 |
k-doo |
560/1121 |
none |
N |
#ffffff |
#222222 |
N |
|
N |