Query time 0.00501
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": "range",
"possible_keys": [
"PRIMARY",
"c_status",
"parent",
"id_path",
"p_category_id"
],
"key": "id_path",
"key_length": "767",
"used_key_parts": ["id_path"],
"rows": 81,
"filtered": 100,
"index_condition": "cscart_categories.id_path like '560/%'",
"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.category_id <> 265 and cscart_categories.parent_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 |
1098 |
1097 |
560/1097/1098 |
ACEFAST |
0 |
A |
0 |
0 |
acefast |
560/1097 |
none |
1122 |
1121 |
560/1121/1122 |
AceFast |
0 |
A |
0 |
0 |
acefast |
560/1121 |
none |
1084 |
1083 |
560/1083/1084 |
Apple |
0 |
A |
0 |
0 |
apple |
560/1083 |
none |
1099 |
1097 |
560/1097/1099 |
Apple |
0 |
A |
0 |
0 |
apple |
560/1097 |
none |
1048 |
1047 |
560/1047/1048 |
Apple |
0 |
A |
0 |
0 |
apple |
560/1047 |
none |
1123 |
1121 |
560/1121/1123 |
Apple |
0 |
A |
0 |
0 |
apple |
560/1121 |
none |
1100 |
1097 |
560/1097/1100 |
Apple Copy |
0 |
A |
0 |
0 |
apple-copy |
560/1097 |
none |
1124 |
1121 |
560/1121/1124 |
Apple Copy |
0 |
A |
0 |
0 |
apple-copy |
560/1121 |
none |
1125 |
1121 |
560/1121/1125 |
Baseus |
0 |
A |
0 |
0 |
baseus |
560/1121 |
none |
1062 |
1061 |
560/1061/1062 |
Baseus |
0 |
A |
0 |
0 |
baseus |
560/1061 |
none |
1085 |
1083 |
560/1083/1085 |
Baseus |
0 |
A |
0 |
0 |
baseus |
560/1083 |
none |
1101 |
1097 |
560/1097/1101 |
Baseus |
0 |
A |
0 |
0 |
baseus |
560/1097 |
none |
1049 |
1047 |
560/1047/1049 |
Baseus |
0 |
A |
0 |
0 |
baseus |
560/1047 |
none |
1126 |
1121 |
560/1121/1126 |
Belkin |
0 |
A |
0 |
0 |
belkin |
560/1121 |
none |
1063 |
1061 |
560/1061/1063 |
Belkin |
0 |
A |
0 |
0 |
belkin |
560/1061 |
none |
1086 |
1083 |
560/1083/1086 |
Belkin |
0 |
A |
0 |
0 |
belkin |
560/1083 |
none |
1102 |
1097 |
560/1097/1102 |
Belkin |
0 |
A |
0 |
0 |
belkin |
560/1097 |
none |
1127 |
1121 |
560/1121/1127 |
Bios |
0 |
A |
0 |
0 |
bios |
560/1121 |
none |
1064 |
1061 |
560/1061/1064 |
Bios |
0 |
A |
0 |
0 |
bios |
560/1061 |
none |
1128 |
1121 |
560/1121/1128 |
Borofone |
0 |
A |
0 |
0 |
borofone |
560/1121 |
none |
1065 |
1061 |
560/1061/1065 |
Borofone |
0 |
A |
0 |
0 |
borofone |
560/1061 |
none |
1087 |
1083 |
560/1083/1087 |
Borofone |
0 |
A |
0 |
0 |
borofone |
560/1083 |
none |
1050 |
1047 |
560/1047/1050 |
Borofone |
0 |
A |
0 |
0 |
borofone |
560/1047 |
none |
1103 |
1097 |
560/1097/1103 |
Borofone |
0 |
A |
0 |
0 |
borofone |
560/1097 |
none |
1051 |
1047 |
560/1047/1051 |
Breaking |
0 |
A |
0 |
0 |
breaking |
560/1047 |
none |
1104 |
1097 |
560/1097/1104 |
Breaking |
0 |
A |
0 |
0 |
breaking |
560/1097 |
none |
1129 |
1121 |
560/1121/1129 |
Breaking |
0 |
A |
0 |
0 |
breaking |
560/1121 |
none |
1066 |
1061 |
560/1061/1066 |
Breaking |
0 |
A |
0 |
0 |
breaking |
560/1061 |
none |
1088 |
1083 |
560/1083/1088 |
Breaking |
0 |
A |
0 |
0 |
breaking |
560/1083 |
none |
1105 |
1097 |
560/1097/1105 |
Canyon |
0 |
A |
0 |
0 |
canyon |
560/1097 |
none |
1076 |
1075 |
560/1075/1076 |
Deji |
0 |
A |
0 |
0 |
deji |
560/1075 |
none |
1052 |
1047 |
560/1047/1052 |
Deppa |
0 |
A |
0 |
0 |
deppa |
560/1047 |
none |
1106 |
1097 |
560/1097/1106 |
Deppa |
0 |
A |
0 |
0 |
deppa |
560/1097 |
none |
1130 |
1121 |
560/1121/1130 |
Deppa |
0 |
A |
0 |
0 |
deppa |
560/1121 |
none |
1067 |
1061 |
560/1061/1067 |
Deppa |
0 |
A |
0 |
0 |
deppa |
560/1061 |
none |
1089 |
1083 |
560/1083/1089 |
Deppa |
0 |
A |
0 |
0 |
deppa |
560/1083 |
none |
1077 |
1075 |
560/1075/1077 |
Duracell |
0 |
A |
0 |
0 |
duracell |
560/1075 |
none |
1107 |
1097 |
560/1097/1107 |
Elray |
0 |
A |
0 |
0 |
elray |
560/1097 |
none |
1053 |
1047 |
560/1047/1053 |
Gerffins |
0 |
A |
0 |
0 |
gerffins |
560/1047 |
none |
1108 |
1097 |
560/1097/1108 |
Gerffins |
0 |
A |
0 |
0 |
gerffins |
560/1097 |
none |
1068 |
1061 |
560/1061/1068 |
Gerffins |
0 |
A |
0 |
0 |
gerffins |
560/1061 |
none |
1131 |
1121 |
560/1121/1131 |
Gerffins |
0 |
A |
0 |
0 |
gerffins |
560/1121 |
none |
1090 |
1083 |
560/1083/1090 |
Gerffins |
0 |
A |
0 |
0 |
gerffins |
560/1083 |
none |
1078 |
1075 |
560/1075/1078 |
GP |
0 |
A |
0 |
0 |
gp |
560/1075 |
none |
1132 |
1121 |
560/1121/1132 |
GP |
0 |
A |
0 |
0 |
gp |
560/1121 |
none |
1054 |
1047 |
560/1047/1054 |
HOCO |
0 |
A |
0 |
0 |
hoco |
560/1047 |
none |
1109 |
1097 |
560/1097/1109 |
Hoco |
0 |
A |
0 |
0 |
hoco |
560/1097 |
none |
1069 |
1061 |
560/1061/1069 |
Hoco |
0 |
A |
0 |
0 |
hoco |
560/1061 |
none |
1133 |
1121 |
560/1121/1133 |
Hoco |
0 |
A |
0 |
0 |
hoco |
560/1121 |
none |
1091 |
1083 |
560/1083/1091 |
Hoco |
0 |
A |
0 |
0 |
hoco |
560/1083 |
none |
1092 |
1083 |
560/1083/1092 |
JOYROOM |
0 |
A |
0 |
0 |
joyroom |
560/1083 |
none |
1055 |
1047 |
560/1047/1055 |
K-Doo |
0 |
A |
0 |
0 |
k-doo |
560/1047 |
none |
1110 |
1097 |
560/1097/1110 |
K-DOO |
0 |
A |
0 |
0 |
k-doo |
560/1097 |
none |
1079 |
1075 |
560/1075/1079 |
Maxvi |
0 |
A |
0 |
0 |
maxvi |
560/1075 |
none |
1111 |
1097 |
560/1097/1111 |
Maxvi |
0 |
A |
0 |
0 |
maxvi |
560/1097 |
none |
1134 |
1121 |
560/1121/1134 |
Maxvi |
0 |
A |
0 |
0 |
maxvi |
560/1121 |
none |
1056 |
1047 |
560/1047/1056 |
MOMAX |
0 |
A |
0 |
0 |
momax |
560/1047 |
none |
1135 |
1121 |
560/1121/1135 |
Prime Line |
0 |
A |
0 |
0 |
prime-line |
560/1121 |
none |
1070 |
1061 |
560/1061/1070 |
Prime Line |
0 |
A |
0 |
0 |
prime-line |
560/1061 |
none |
1112 |
1097 |
560/1097/1112 |
Prime Line |
0 |
A |
0 |
0 |
prime-line |
560/1097 |
none |
1093 |
1083 |
560/1083/1093 |
Remax |
0 |
A |
0 |
0 |
remax |
560/1083 |
none |
1057 |
1047 |
560/1047/1057 |
Remax |
0 |
A |
0 |
0 |
remax |
560/1047 |
none |
1071 |
1061 |
560/1061/1071 |
Remax |
0 |
A |
0 |
0 |
remax |
560/1061 |
none |
1113 |
1097 |
560/1097/1113 |
Remax |
0 |
A |
0 |
0 |
remax |
560/1097 |
none |
1136 |
1121 |
560/1121/1136 |
Rivacase |
0 |
A |
0 |
0 |
rivacase |
560/1121 |
none |
1094 |
1083 |
560/1083/1094 |
Rocket |
0 |
A |
0 |
0 |
rocket |
560/1083 |
none |
1137 |
1121 |
560/1121/1137 |
Rocket |
0 |
A |
0 |
0 |
rocket |
560/1121 |
none |
1114 |
1097 |
560/1097/1114 |
Samsung |
0 |
A |
0 |
0 |
samsung |
560/1097 |
none |
1138 |
1121 |
560/1121/1138 |
Samsung |
0 |
A |
0 |
0 |
samsung |
560/1121 |
none |
1080 |
1075 |
560/1075/1080 |
Smartbuy |
0 |
A |
0 |
0 |
smartbuy |
560/1075 |
none |
1058 |
1047 |
560/1047/1058 |
Totu |
0 |
A |
0 |
0 |
totu |
560/1047 |
none |
1095 |
1083 |
560/1083/1095 |
uBear |
0 |
A |
0 |
0 |
ubear |
560/1083 |
none |
1139 |
1121 |
560/1121/1139 |
uBear |
0 |
A |
0 |
0 |
ubear |
560/1121 |
none |
1115 |
1097 |
560/1097/1115 |
Ubik |
0 |
A |
0 |
0 |
ubik |
560/1097 |
none |
1081 |
1075 |
560/1075/1081 |
Varta |
0 |
A |
0 |
0 |
varta |
560/1075 |
none |
1116 |
1097 |
560/1097/1116 |
Vespa |
0 |
A |
0 |
0 |
vespa |
560/1097 |
none |
1117 |
1097 |
560/1097/1117 |
Vidvie |
0 |
A |
0 |
0 |
vidvie |
560/1097 |
none |
1072 |
1061 |
560/1061/1072 |
W.O.L.T. |
0 |
A |
0 |
0 |
w-o-l-t |
560/1061 |
none |
1140 |
1121 |
560/1121/1140 |
W.O.L.T. |
0 |
A |
0 |
0 |
w-o-l-t |
560/1121 |
none |
1073 |
1061 |
560/1061/1073 |
Xiaomi |
0 |
A |
0 |
0 |
xiaomi |
560/1061 |
none |
1096 |
1083 |
560/1083/1096 |
Xiaomi |
0 |
A |
0 |
0 |
xiaomi |
560/1083 |
none |
1118 |
1097 |
560/1097/1118 |
Xiaomi |
0 |
A |
0 |
0 |
xiaomi |
560/1097 |
none |
1141 |
1121 |
560/1121/1141 |
Xiaomi |
0 |
A |
0 |
0 |
xiaomi |
560/1121 |
none |
1059 |
1047 |
560/1047/1059 |
Xiaomi |
0 |
A |
0 |
0 |
xiaomi |
560/1047 |
none |
1082 |
1075 |
560/1075/1082 |
Xiaomi |
0 |
A |
0 |
0 |
xiaomi |
560/1075 |
none |
1060 |
1047 |
560/1047/1060 |
Без Бренда |
0 |
A |
0 |
0 |
bez-brenda |
560/1047 |
none |
1119 |
1097 |
560/1097/1119 |
Прочее |
0 |
A |
0 |
0 |
prochee |
560/1097 |
none |
1074 |
1061 |
560/1061/1074 |
Тех Пак |
0 |
A |
0 |
0 |
teh-pak |
560/1061 |
none |
1120 |
1097 |
560/1097/1120 |
Тех Пак |
0 |
A |
0 |
0 |
teh-pak |
560/1097 |
none |
1142 |
1121 |
560/1121/1142 |
Тех Пак |
0 |
A |
0 |
0 |
teh-pak |
560/1121 |
none |
1299 |
1121 |
560/1121/1299 |
K-DOO |
10 |
A |
0 |
0 |
k-doo |
560/1121 |
none |
1047 |
560 |
560/1047 |
PowerBank |
10 |
A |
0 |
0 |
powerbank |
560 |
none |
1097 |
560 |
560/1097 |
Кабели |
20 |
A |
0 |
0 |
kabeli |
560 |
none |
1061 |
560 |
560/1061 |
АЗУ |
30 |
A |
0 |
0 |
azu |
560 |
none |
1083 |
560 |
560/1083 |
БЗУ |
40 |
A |
0 |
0 |
bzu |
560 |
none |
1121 |
560 |
560/1121 |
СЗУ |
50 |
A |
0 |
0 |
szu |
560 |
none |
1075 |
560 |
560/1075 |
Батарейки |
60 |
A |
0 |
0 |
batareyki |
560 |
none |