Query time 0.00513
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": 113,
"filtered": 100,
"index_condition": "cscart_categories.id_path like '954/%'",
"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 |
1033 |
1032 |
954/990/1032/1033 |
ABINGO |
0 |
A |
0 |
0 |
abingo |
954/990/1032 |
none |
1022 |
1021 |
954/990/1021/1022 |
Apple |
0 |
A |
0 |
0 |
apple |
954/990/1021 |
none |
1034 |
1032 |
954/990/1032/1034 |
Apple |
0 |
A |
0 |
0 |
apple |
954/990/1032 |
none |
992 |
991 |
954/990/991/992 |
Apple |
0 |
A |
0 |
0 |
apple |
954/990/991 |
none |
956 |
955 |
954/955/956 |
Apple |
0 |
A |
0 |
0 |
apple |
954/955 |
none |
957 |
955 |
954/955/957 |
Baseus |
0 |
A |
0 |
0 |
baseus |
954/955 |
none |
969 |
968 |
954/966/968/969 |
Baseus |
0 |
A |
0 |
0 |
baseus |
954/966/968 |
none |
1035 |
1032 |
954/990/1032/1035 |
Baseus |
0 |
A |
0 |
0 |
baseus |
954/990/1032 |
none |
993 |
991 |
954/990/991/993 |
Baseus |
0 |
A |
0 |
0 |
baseus |
954/990/991 |
none |
994 |
991 |
954/990/991/994 |
Borofone |
0 |
A |
0 |
0 |
borofone |
954/990/991 |
none |
958 |
955 |
954/955/958 |
Borofone |
0 |
A |
0 |
0 |
borofone |
954/955 |
none |
970 |
968 |
954/966/968/970 |
Borofone |
0 |
A |
0 |
0 |
borofone |
954/966/968 |
none |
1023 |
1021 |
954/990/1021/1023 |
Borofone |
0 |
A |
0 |
0 |
borofone |
954/990/1021 |
none |
1036 |
1032 |
954/990/1032/1036 |
Borofone |
0 |
A |
0 |
0 |
borofone |
954/990/1032 |
none |
995 |
991 |
954/990/991/995 |
Breaking |
0 |
A |
0 |
0 |
breaking |
954/990/991 |
none |
959 |
955 |
954/955/959 |
Breaking |
0 |
A |
0 |
0 |
breaking |
954/955 |
none |
1024 |
1021 |
954/990/1021/1024 |
Breaking |
0 |
A |
0 |
0 |
breaking |
954/990/1021 |
none |
1037 |
1032 |
954/990/1032/1037 |
Breaking |
0 |
A |
0 |
0 |
breaking |
954/990/1032 |
none |
996 |
991 |
954/990/991/996 |
Celebrat |
0 |
A |
0 |
0 |
celebrat |
954/990/991 |
none |
1025 |
1021 |
954/990/1021/1025 |
Celebrat |
0 |
A |
0 |
0 |
celebrat |
954/990/1021 |
none |
1038 |
1032 |
954/990/1032/1038 |
Celebrat |
0 |
A |
0 |
0 |
celebrat |
954/990/1032 |
none |
1026 |
1021 |
954/990/1021/1026 |
Defender |
0 |
A |
0 |
0 |
defender |
954/990/1021 |
none |
997 |
991 |
954/990/991/997 |
Deppa |
0 |
A |
0 |
0 |
deppa |
954/990/991 |
none |
998 |
991 |
954/990/991/998 |
Dsaila |
0 |
A |
0 |
0 |
dsaila |
954/990/991 |
none |
960 |
955 |
954/955/960 |
Gerffins |
0 |
A |
0 |
0 |
gerffins |
954/955 |
none |
971 |
968 |
954/966/968/971 |
GERFFINS |
0 |
A |
0 |
0 |
gerffins |
954/966/968 |
none |
999 |
991 |
954/990/991/999 |
Gerffins |
0 |
A |
0 |
0 |
gerffins |
954/990/991 |
none |
1039 |
1032 |
954/990/1032/1039 |
Gerffins |
0 |
A |
0 |
0 |
gerffins |
954/990/1032 |
none |
1000 |
991 |
954/990/991/1000 |
Harman |
0 |
A |
0 |
0 |
harman |
954/990/991 |
none |
1001 |
991 |
954/990/991/1001 |
HAYLOU |
0 |
A |
0 |
0 |
haylou |
954/990/991 |
none |
1002 |
991 |
954/990/991/1002 |
Hoco |
0 |
A |
0 |
0 |
hoco |
954/990/991 |
none |
1040 |
1032 |
954/990/1032/1040 |
Hoco |
0 |
A |
0 |
0 |
hoco |
954/990/1032 |
none |
961 |
955 |
954/955/961 |
HOCO |
0 |
A |
0 |
0 |
hoco |
954/955 |
none |
972 |
968 |
954/966/968/972 |
Hoco |
0 |
A |
0 |
0 |
hoco |
954/966/968 |
none |
1027 |
1021 |
954/990/1021/1027 |
Hoco |
0 |
A |
0 |
0 |
hoco |
954/990/1021 |
none |
1003 |
991 |
954/990/991/1003 |
Honor/Huawei |
0 |
A |
0 |
0 |
honor-huawei |
954/990/991 |
none |
973 |
968 |
954/966/968/973 |
Hopestar |
0 |
A |
0 |
0 |
hopestar |
954/966/968 |
none |
1004 |
991 |
954/990/991/1004 |
In-Pods |
0 |
A |
0 |
0 |
in-pods |
954/990/991 |
none |
1005 |
991 |
954/990/991/1005 |
ITEL |
0 |
A |
0 |
0 |
itel |
954/990/991 |
none |
1006 |
991 |
954/990/991/1006 |
JBL |
0 |
A |
0 |
0 |
jbl |
954/990/991 |
none |
974 |
968 |
954/966/968/974 |
JBL |
0 |
A |
0 |
0 |
jbl |
954/966/968 |
none |
1028 |
1021 |
954/990/1021/1028 |
JBL |
0 |
A |
0 |
0 |
jbl |
954/990/1021 |
none |
975 |
968 |
954/966/968/975 |
Koleer |
0 |
A |
0 |
0 |
koleer |
954/966/968 |
none |
976 |
968 |
954/966/968/976 |
Leef |
0 |
A |
0 |
0 |
leef |
954/966/968 |
none |
1007 |
991 |
954/990/991/1007 |
Lenovo |
0 |
A |
0 |
0 |
lenovo |
954/990/991 |
none |
977 |
968 |
954/966/968/977 |
Lenovo |
0 |
A |
0 |
0 |
lenovo |
954/966/968 |
none |
978 |
968 |
954/966/968/978 |
Marshall |
0 |
A |
0 |
0 |
marshall |
954/966/968 |
none |
1008 |
991 |
954/990/991/1008 |
Marshall |
0 |
A |
0 |
0 |
marshall |
954/990/991 |
none |
1029 |
1021 |
954/990/1021/1029 |
Maxvi |
0 |
A |
0 |
0 |
maxvi |
954/990/1021 |
none |
1041 |
1032 |
954/990/1032/1041 |
Maxvi |
0 |
A |
0 |
0 |
maxvi |
954/990/1032 |
none |
1042 |
1032 |
954/990/1032/1042 |
Mosidun |
0 |
A |
0 |
0 |
mosidun |
954/990/1032 |
none |
979 |
968 |
954/966/968/979 |
OneDer |
0 |
A |
0 |
0 |
oneder |
954/966/968 |
none |
980 |
968 |
954/966/968/980 |
Ovevo |
0 |
A |
0 |
0 |
ovevo |
954/966/968 |
none |
1043 |
1032 |
954/990/1032/1043 |
Prime Line |
0 |
A |
0 |
0 |
prime-line |
954/990/1032 |
none |
1009 |
991 |
954/990/991/1009 |
QCY |
0 |
A |
0 |
0 |
qcy |
954/990/991 |
none |
1010 |
991 |
954/990/991/1010 |
Realme |
0 |
A |
0 |
0 |
realme |
954/990/991 |
none |
1030 |
1021 |
954/990/1021/1030 |
Remax |
0 |
A |
0 |
0 |
remax |
954/990/1021 |
none |
981 |
968 |
954/966/968/981 |
Remax |
0 |
A |
0 |
0 |
remax |
954/966/968 |
none |
1044 |
1032 |
954/990/1032/1044 |
Remax |
0 |
A |
0 |
0 |
remax |
954/990/1032 |
none |
962 |
955 |
954/955/962 |
Remax |
0 |
A |
0 |
0 |
remax |
954/955 |
none |
1011 |
991 |
954/990/991/1011 |
Remax |
0 |
A |
0 |
0 |
remax |
954/990/991 |
none |
982 |
968 |
954/966/968/982 |
Rocket |
0 |
A |
0 |
0 |
rocket |
954/966/968 |
none |
1012 |
991 |
954/990/991/1012 |
Rocket |
0 |
A |
0 |
0 |
rocket |
954/990/991 |
none |
1013 |
991 |
954/990/991/1013 |
Samsung |
0 |
A |
0 |
0 |
samsung |
954/990/991 |
none |
987 |
986 |
954/966/986/987 |
SBER |
0 |
A |
0 |
0 |
sber |
954/966/986 |
none |
1045 |
1032 |
954/990/1032/1045 |
SmartBuy |
0 |
A |
0 |
0 |
smartbuy |
954/990/1032 |
none |
1014 |
991 |
954/990/991/1014 |
Sodo |
0 |
A |
0 |
0 |
sodo |
954/990/991 |
none |
983 |
968 |
954/966/968/983 |
SODO |
0 |
A |
0 |
0 |
sodo |
954/966/968 |
none |
1015 |
991 |
954/990/991/1015 |
Sony |
0 |
A |
0 |
0 |
sony |
954/990/991 |
none |
1016 |
991 |
954/990/991/1016 |
TFN |
0 |
A |
0 |
0 |
tfn |
954/990/991 |
none |
1046 |
1032 |
954/990/1032/1046 |
TOTU |
0 |
A |
0 |
0 |
totu |
954/990/1032 |
none |
988 |
986 |
954/966/986/988 |
VK Капсула |
0 |
A |
0 |
0 |
vk-kapsula |
954/966/986 |
none |
1017 |
991 |
954/990/991/1017 |
Xiaomi |
0 |
A |
0 |
0 |
xiaomi |
954/990/991 |
none |
984 |
968 |
954/966/968/984 |
Xiaomi |
0 |
A |
0 |
0 |
xiaomi |
954/966/968 |
none |
1018 |
991 |
954/990/991/1018 |
Yison |
0 |
A |
0 |
0 |
yison |
954/990/991 |
none |
963 |
955 |
954/955/963 |
Yison |
0 |
A |
0 |
0 |
yison |
954/955 |
none |
1019 |
991 |
954/990/991/1019 |
Аналог AirPods |
0 |
A |
0 |
0 |
analog-airpods |
954/990/991 |
none |
985 |
968 |
954/966/968/985 |
Без Бренда |
0 |
A |
0 |
0 |
bez-brenda |
954/966/968 |
none |
964 |
955 |
954/955/964 |
Без Бренда |
0 |
A |
0 |
0 |
bez-brenda |
954/955 |
none |
991 |
990 |
954/990/991 |
Беспроводные |
0 |
A |
0 |
0 |
besprovodnye |
954/990 |
none |
967 |
966 |
954/966/967 |
Напольные колонки |
0 |
A |
0 |
0 |
napolnye-kolonki |
954/966 |
none |
1021 |
990 |
954/990/1021 |
Полноразмерные |
0 |
A |
0 |
0 |
polnorazmernye |
954/990 |
none |
968 |
966 |
954/966/968 |
Портативные колонки |
0 |
A |
0 |
0 |
portativnye-kolonki |
954/966 |
none |
1032 |
990 |
954/990/1032 |
Проводные |
0 |
A |
0 |
0 |
provodnye |
954/990 |
none |
1020 |
991 |
954/990/991/1020 |
Прочее |
0 |
A |
0 |
0 |
prochee |
954/990/991 |
none |
1031 |
1021 |
954/990/1021/1031 |
С Ушками |
0 |
A |
0 |
0 |
s-ushkami |
954/990/1021 |
none |
986 |
966 |
954/966/986 |
Умные колонки |
0 |
A |
0 |
0 |
umnye-kolonki |
954/966 |
none |
989 |
986 |
954/966/986/989 |
Яндекс-станции |
0 |
A |
0 |
0 |
yandeks-stancii |
954/966/986 |
none |
990 |
954 |
954/990 |
Наушники |
10 |
A |
0 |
0 |
naushniki |
954 |
none |
965 |
954 |
954/965 |
Микрофоны |
20 |
A |
0 |
0 |
mikrofony |
954 |
none |
966 |
954 |
954/966 |
Музыкальные колонки |
30 |
A |
0 |
0 |
muzykalnye-kolonki |
954 |
none |
955 |
954 |
954/955 |
AUX |
40 |
A |
0 |
0 |
aux |
954 |
none |