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

休闲食品加工设备

烹饪加热设备

处理加工类设备

消毒清洗类设备

低温储存设备

常温储存设备

厨房配套设备

其他专业设备

文具用品

办公耗材

办公设备

其他办公用品

(default) 55 queries took 110 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` ASC10102
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)53532
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` asc23232
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` asc17172
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` asc772
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` asc332
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` asc552
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` asc15152
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` asc30302
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` asc19192
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` asc34342
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` asc992
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` asc772
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` asc112
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