食材 粮油调料 酒水饮料 综合用品 厨房用具 专业设备 办公用品 家具 信息化系统 基建装潢

休闲食品加工设备

烹饪加热设备

处理加工类设备

消毒清洗类设备

低温储存设备

常温储存设备

厨房配套设备

其他专业设备

文具用品

办公耗材

办公设备

其他办公用品

(default) 55 queries took 125 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name` FROM `jmuv3`.`categories` AS `Category` LEFT JOIN `jmuv3`.`categories` AS `ParentCategory` ON (`Category`.`parent_id` = `ParentCategory`.`id`) WHERE `Category`.`parent_id` is null ORDER BY FIELD(`Category`.`name`, '食材', '粮油调料', '酒水饮料', '综合用品', '厨房用具', '专业设备', '办公用品', '家具', '信息化系统', '基建装潢'), `Category`.`id` ASC10103
2SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_id`, `ChildCategory`.`name`, `ChildCategory`.`isrecommend`, `ChildCategory`.`lft`, `ChildCategory`.`rght`, `ChildCategory`.`nc_code`, `ChildCategory`.`ft_code`, `ChildCategory`.`isshow`, `ChildCategory`.`sort` FROM `jmuv3`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` IN (7, 5, 6, 1, 2, 4, 9, 10, 8, 3)53533
3SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 48 ORDER BY `Category`.`lft` asc772
4SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 49 ORDER BY `Category`.`lft` asc772
5SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 50 ORDER BY `Category`.`lft` asc112
6SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 34 ORDER BY `Category`.`lft` asc23233
7SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 35 ORDER BY `Category`.`lft` asc21212
8SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 36 ORDER BY `Category`.`lft` asc17173
9SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 37 ORDER BY `Category`.`lft` asc112
10SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 38 ORDER BY `Category`.`lft` asc662
11SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 39 ORDER BY `Category`.`lft` asc442
12SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 40 ORDER BY `Category`.`lft` asc332
13SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 41 ORDER BY `Category`.`lft` asc552
14SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 42 ORDER BY `Category`.`lft` asc332
15SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 43 ORDER BY `Category`.`lft` asc774
16SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 44 ORDER BY `Category`.`lft` asc442
17SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 45 ORDER BY `Category`.`lft` asc333
18SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 46 ORDER BY `Category`.`lft` asc553
19SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 47 ORDER BY `Category`.`lft` asc112
20SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 11 ORDER BY `Category`.`lft` asc552
21SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 12 ORDER BY `Category`.`lft` asc48482
22SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 13 ORDER BY `Category`.`lft` asc15153
23SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 14 ORDER BY `Category`.`lft` asc19192
24SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 15 ORDER BY `Category`.`lft` asc26262
25SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 16 ORDER BY `Category`.`lft` asc112
26SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 17 ORDER BY `Category`.`lft` asc30303
27SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 18 ORDER BY `Category`.`lft` asc12122
28SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 19 ORDER BY `Category`.`lft` asc11112
29SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 20 ORDER BY `Category`.`lft` asc27272
30SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 21 ORDER BY `Category`.`lft` asc19193
31SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 22 ORDER BY `Category`.`lft` asc112
32SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 26 ORDER BY `Category`.`lft` asc37372
33SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 27 ORDER BY `Category`.`lft` asc51512
34SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 28 ORDER BY `Category`.`lft` asc46462
35SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 29 ORDER BY `Category`.`lft` asc10102
36SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 30 ORDER BY `Category`.`lft` asc14142
37SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 31 ORDER BY `Category`.`lft` asc10102
38SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 32 ORDER BY `Category`.`lft` asc13132
39SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 33 ORDER BY `Category`.`lft` asc112
40SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 55 ORDER BY `Category`.`lft` asc1061062
41SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 56 ORDER BY `Category`.`lft` asc27272
42SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 57 ORDER BY `Category`.`lft` asc24242
43SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 58 ORDER BY `Category`.`lft` asc222
44SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 59 ORDER BY `Category`.`lft` asc10102
45SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 60 ORDER BY `Category`.`lft` asc772
46SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 61 ORDER BY `Category`.`lft` asc34343
47SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 62 ORDER BY `Category`.`lft` asc993
48SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 63 ORDER BY `Category`.`lft` asc112
49SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 51 ORDER BY `Category`.`lft` asc552
50SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 52 ORDER BY `Category`.`lft` asc552
51SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 53 ORDER BY `Category`.`lft` asc773
52SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 54 ORDER BY `Category`.`lft` asc113
53SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 23 ORDER BY `Category`.`lft` asc772
54SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 24 ORDER BY `Category`.`lft` asc442
55SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 25 ORDER BY `Category`.`lft` asc112