Query time 0.00223
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "33.80"
},
"ordering_operation": {
"using_temporary_table": true,
"using_filesort": true,
"nested_loop": [
{
"table": {
"table_name": "cscart_categories",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"c_status",
"parent",
"id_path",
"p_category_id"
],
"key": "parent",
"used_key_parts": [
"parent_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 60,
"rows_produced_per_join": 0,
"filtered": "0.08",
"cost_info": {
"read_cost": "15.00",
"eval_cost": "0.01",
"prefix_cost": "21.00",
"data_read_per_join": "181"
},
"used_columns": [
"category_id",
"parent_id",
"id_path",
"company_id",
"usergroup_ids",
"status",
"position",
"age_verification",
"age_limit",
"is_trash",
"ab__lc_catalog_image_control",
"ab__fn_category_status",
"ab__fn_label_color",
"ab__fn_label_background",
"ab__fn_use_origin_image",
"storefront_id"
],
"attached_condition": "(((`s2cart`.`cscart_categories`.`usergroup_ids` = '') or (0 <> find_in_set(0,`s2cart`.`cscart_categories`.`usergroup_ids`)) or (0 <> find_in_set(1,`s2cart`.`cscart_categories`.`usergroup_ids`))) and (`s2cart`.`cscart_categories`.`status` = 'A') and (`s2cart`.`cscart_categories`.`id_path` like '1530/%') and (`s2cart`.`cscart_categories`.`category_id` <> 414) and (`s2cart`.`cscart_categories`.`storefront_id` in (0,3)))"
}
},
{
"table": {
"table_name": "cscart_category_descriptions",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id",
"lang_code"
],
"key_length": "9",
"ref": [
"s2cart.cscart_categories.category_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.01",
"eval_cost": "0.01",
"prefix_cost": "21.02",
"data_read_per_join": "324"
},
"used_columns": [
"category_id",
"lang_code",
"category",
"age_warning_message",
"ab__custom_category_h1",
"ab__fn_label_text",
"ab__fn_label_show"
]
}
},
{
"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": [
"s2cart.cscart_categories.category_id",
"const",
"const",
"const"
],
"rows_examined_per_scan": 696,
"rows_produced_per_join": 34,
"filtered": "100.00",
"cost_info": {
"read_cost": "9.30",
"eval_cost": "3.48",
"prefix_cost": "33.80",
"data_read_per_join": "58K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
]
}
}
}
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 |
age_verification |
age_limit |
age_warning_message |
ab__custom_category_h1 |
1531 |
1530 |
1530/1531 |
Bags and Sleeves |
0 |
A |
0 |
0 |
bags-and-sleeves |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1533 |
1530 |
1530/1533 |
Barcode Scanner |
0 |
A |
0 |
0 |
barcode-scanner |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1535 |
1530 |
1530/1535 |
Blank Media |
0 |
A |
0 |
0 |
blank-media |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1537 |
1530 |
1530/1537 |
Cabinet |
0 |
A |
0 |
0 |
cabinet |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1541 |
1530 |
1530/1541 |
Camera |
0 |
A |
0 |
0 |
camera |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1538 |
1530 |
1530/1538 |
Camera accessories |
0 |
A |
0 |
0 |
camera-accessories |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1542 |
1530 |
1530/1542 |
Card Printer |
0 |
A |
0 |
0 |
card-printer |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1543 |
1530 |
1530/1543 |
Card Reader |
0 |
A |
0 |
0 |
card-reader |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1544 |
1530 |
1530/1544 |
Cash Drawer |
0 |
A |
0 |
0 |
cash-drawer |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1545 |
1530 |
1530/1545 |
Cleaning Kits |
0 |
A |
0 |
0 |
cleaning-kits |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1548 |
1530 |
1530/1548 |
Conference Phones |
0 |
A |
0 |
0 |
conference-phones |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1551 |
1530 |
1530/1551 |
Controller |
0 |
A |
0 |
0 |
controller |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1565 |
1530 |
1530/1565 |
Desksets Combo |
0 |
A |
0 |
0 |
desksets-combo |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1566 |
1530 |
1530/1566 |
Desktop |
0 |
A |
0 |
0 |
desktop |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1567 |
1530 |
1530/1567 |
Digital Accessories |
0 |
A |
0 |
0 |
digital-accessories |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1569 |
1530 |
1530/1569 |
Docking Station |
0 |
A |
0 |
0 |
docking-station |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1576 |
1530 |
1530/1576 |
Electronic Aerosol |
0 |
A |
0 |
0 |
electronic-aerosol |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1577 |
1530 |
1530/1577 |
Electronic Cash Register |
0 |
A |
0 |
0 |
electronic-cash-register |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1605 |
1530 |
1530/1605 |
Graphic Cards |
0 |
A |
0 |
0 |
graphic-cards |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1613 |
1530 |
1530/1613 |
Hard Disks |
0 |
A |
0 |
0 |
hard-disks |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1614 |
1530 |
1530/1614 |
HDD Cases |
0 |
A |
0 |
0 |
hdd-cases |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1615 |
1530 |
1530/1615 |
Headphones |
0 |
A |
0 |
0 |
headphones |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1619 |
1530 |
1530/1619 |
Home Appliances |
0 |
A |
0 |
0 |
home-appliances |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1627 |
1530 |
1530/1627 |
Keyboard |
0 |
A |
0 |
0 |
keyboard |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1628 |
1530 |
1530/1628 |
Kitchen Appliances |
0 |
A |
0 |
0 |
kitchen-appliances |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1675 |
1530 |
1530/1675 |
Label Printer |
0 |
A |
0 |
0 |
label-printer |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1673 |
1530 |
1530/1673 |
Label Printers Accessories |
0 |
A |
0 |
0 |
label-printers-accessories |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1839 |
1530 |
1530/1839 |
Landline Phone |
0 |
A |
0 |
0 |
landline-phone |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1840 |
1530 |
1530/1840 |
Laptop Batteries |
0 |
A |
0 |
0 |
laptop-batteries |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1841 |
1530 |
1530/1841 |
Laptop cooling pads/stands |
0 |
A |
0 |
0 |
laptop-cooling-pads-stands |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1842 |
1530 |
1530/1842 |
Laptop Power Adapter |
0 |
A |
0 |
0 |
laptop-power-adapter |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1843 |
1530 |
1530/1843 |
Laptop series |
0 |
A |
0 |
0 |
laptop-series |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1845 |
1530 |
1530/1845 |
Laptops |
0 |
A |
0 |
0 |
laptops |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1857 |
1530 |
1530/1857 |
LED Displays |
0 |
A |
0 |
0 |
led-displays |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1871 |
1530 |
1530/1871 |
LED TV |
0 |
A |
0 |
0 |
led-tv |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1891 |
1530 |
1530/1891 |
Mobile |
0 |
A |
0 |
0 |
mobile |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1885 |
1530 |
1530/1885 |
Mobile Accessories |
0 |
A |
0 |
0 |
mobile-accessories |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1894 |
1530 |
1530/1894 |
Monitors |
0 |
A |
0 |
0 |
monitors |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1895 |
1530 |
1530/1895 |
Mouse |
0 |
A |
0 |
0 |
mouse |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1897 |
1530 |
1530/1897 |
Multimedia Player |
0 |
A |
0 |
0 |
multimedia-player |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1898 |
1530 |
1530/1898 |
Network Accesories |
0 |
A |
0 |
0 |
network-accesories |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1902 |
1530 |
1530/1902 |
Network Attached Storage |
0 |
A |
0 |
0 |
network-attached-storage |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1903 |
1530 |
1530/1903 |
Network Components |
0 |
A |
0 |
0 |
network-components |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1922 |
1530 |
1530/1922 |
Personal Care |
0 |
A |
0 |
0 |
personal-care |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1924 |
1530 |
1530/1924 |
Plug and Sockets |
0 |
A |
0 |
0 |
plug-and-sockets |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1925 |
1530 |
1530/1925 |
POS Terminals |
0 |
A |
0 |
0 |
pos-terminals |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1927 |
1530 |
1530/1927 |
Power Supply |
0 |
A |
0 |
0 |
power-supply |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1928 |
1530 |
1530/1928 |
Processor |
0 |
A |
0 |
0 |
processor |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1929 |
1530 |
1530/1929 |
Projectors and accessories |
0 |
A |
0 |
0 |
projectors-and-accessories |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1933 |
1530 |
1530/1933 |
Ram |
0 |
A |
0 |
0 |
ram |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1935 |
1530 |
1530/1935 |
Scanner |
0 |
A |
0 |
0 |
scanner |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1936 |
1530 |
1530/1936 |
Servers |
0 |
A |
0 |
0 |
servers |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1938 |
1530 |
1530/1938 |
Smart wrist band |
0 |
A |
0 |
0 |
smart-wrist-band |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1939 |
1530 |
1530/1939 |
Softwares |
0 |
A |
0 |
0 |
softwares |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1940 |
1530 |
1530/1940 |
Solid State Drive |
0 |
A |
0 |
0 |
solid-state-drive |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1941 |
1530 |
1530/1941 |
Speakers |
0 |
A |
0 |
0 |
speakers |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1946 |
1530 |
1530/1946 |
Spike Busters and Surge Protectors |
0 |
A |
0 |
0 |
spike-busters-and-surge-protectors |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1948 |
1530 |
1530/1948 |
Tablets |
0 |
A |
0 |
0 |
tablets |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1954 |
1530 |
1530/1954 |
TV TUNER |
0 |
A |
0 |
0 |
tv-tuner |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1956 |
1530 |
1530/1956 |
UPS |
0 |
A |
0 |
0 |
ups |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1957 |
1530 |
1530/1957 |
USB Hubs |
0 |
A |
0 |
0 |
usb-hubs |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1962 |
1530 |
1530/1962 |
virtual reality |
0 |
A |
0 |
0 |
virtual-reality |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|
1963 |
1530 |
1530/1963 |
WEBCAM |
0 |
A |
0 |
0 |
webcam |
1530 |
none |
Y |
#ffffff |
#333333 |
N |
|
N |
N |
0 |
|
|