中国领先的餐饮酒店B2B全球采购平台

(default) 10 queries took 20 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `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` ASC	10	10	3
2	SELECT `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)	53	53	4
3	SELECT `Category`.`id` FROM `jmuv3`.`recommends_categories` AS `RecommendsCategory` LEFT JOIN `jmuv3`.`categories` AS `Category` ON (`RecommendsCategory`.`category_id` = `Category`.`id`) LEFT JOIN `jmuv3`.`recommends` AS `Recommend` ON (`Recommend`.`type` = 3 AND `RecommendsCategory`.`recommend_id` = `Recommend`.`id`) WHERE `Recommend`.`code` = 'indexv2_hot_categories' AND `Recommend`.`type` = 3 ORDER BY `RecommendsCategory`.`sort_order` ASC, `RecommendsCategory`.`modified` DESC LIMIT 200	200	200	2
4	SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name` FROM `jmuv3`.`categories` AS `Category` WHERE `Category`.`id` IN (7, 55, 34, 38, 26, 59, 11, 52, 17, 48, 23, 18, 41, 49, 12, 56, 61, 27, 53, 5, 24, 35, 62, 50, 21, 32, 43, 57, 13, 51, 25, 6, 36, 1, 2, 4, 9, 10, 8, 3, 564, 590, 471, 211, 477, 759, 791, 776, 123, 460, 462, 574, 215, 286, 461, 530, 742, 456, 589, 208, 561, 811, 181, 582, 188, 578, 575, 735, 793, 473, 504, 788, 548, 708, 84, 738, 591, 599, 605, 815, 262, 513, 1891, 596, 706, 758, 765, 121, 282, 537, 122, 527, 289, 757, 209, 260, 586, 207, 455, 790, 265, 463, 577, 737, 762, 284, 486, 810, 291, 294, 459, 103, 570, 764, 190, 281, 545, 1894, 569, 576, 608, 714, 792, 115, 549, 585, 761, 734, 766, 808, 69, 285, 541, 496, 542, 567, 593, 760, 457, 264, 292, 492, 579, 503, 547, 602, 523, 552, 607, 744, 494, 495, 287, 521, 555, 711, 733, 107, 507, 466, 709, 263, 280, 467, 80, 288, 559, 787, 184, 189, 192, 202, 329, 510, 786, 106, 335, 543, 566, 111, 261, 293, 512, 266, 595, 501, 583, 95, 191, 789, 180, 517, 195, 782, 290, 568, 210, 212, 465, 778) ORDER BY FIELD(`Category`.`id`, 7,55,34,38,26,59,11,52,17,48,23,18,41,49,12,56,61,27,53,5,24,35,62,50,21,32,43,57,13,51,25,6,36,1,2,4,9,10,8,3,564,590,471,211,477,759,791,776,123,460,462,574,215,286,461,530,742,456,589,208,561,811,181,582,188,578,575,735,793,473,504,788,548,708,84,738,591,599,605,815,262,513,1891,596,706,758,765,121,282,537,122,527,289,757,209,260,586,207,455,790,265,463,577,737,762,284,486,810,291,294,459,103,570,764,190,281,545,1894,569,576,608,714,792,115,549,585,761,734,766,808,69,285,541,496,542,567,593,760,457,264,292,492,579,503,547,602,523,552,607,744,494,495,287,521,555,711,733,107,507,466,709,263,280,467,80,288,559,787,184,189,192,202,329,510,786,106,335,543,566,111,261,293,512,266,595,501,583,95,191,789,180,517,195,782,290,568,210,212,465,778) ASC	200	200	3
5	SELECT `Category`.`lft`, `Category`.`rght` FROM `jmuv3`.`categories` AS `Category` WHERE `Category`.`id` = 190 LIMIT 1	1	1	1
6	SELECT `Category`.`id`, `Category`.`name` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`lft` <= 271 AND `Category`.`rght` >= 272 ORDER BY `Category`.`lft` asc	3	3	1
7	SELECT `Category`.`lft`, `Category`.`rght` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 190 LIMIT 1	1	1	1
8	SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 272 AND `Category`.`lft` > 271 ORDER BY `Category`.`lft` asc	0	0	3
9	SELECT COUNT(*) AS `count` FROM `jmuv3`.`goods` AS `Good` LEFT JOIN `jmuv3`.`stores` AS `Store` ON (`Store`.`id` = `Good`.`store_id`) LEFT JOIN `jmuv3`.`sellers` AS `Seller` ON (`Seller`.`id` = `Store`.`seller_id`) LEFT JOIN `jmuv3`.`users` AS `User` ON (`User`.`id` = `Seller`.`user_id`) LEFT JOIN `jmuv3`.`specs` AS `DefaultSpec` ON (`DefaultSpec`.`goods_id` = `Good`.`id` AND `DefaultSpec`.`issetspec` = 1) LEFT JOIN `jmuv3`.`categories` AS `Category` ON (`Category`.`id` = `Good`.`category_id`) WHERE `Good`.`isaudit` = 1 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Store`.`isaudit` = 1 AND `User`.`is_delete` = 0 AND `Good`.`category_id` = (190)	1	1	1
10	SELECT `Good`.`id`, `Good`.`name`, `Good`.`type`, `Good`.`image`, `Good`.`from`, `DefaultSpec`.`issetspec`, `DefaultSpec`.`price`, `DefaultSpec`.`price_1`, `DefaultSpec`.`price_2`, `DefaultSpec`.`price_3`, `DefaultSpec`.`price_4`, `DefaultSpec`.`point` FROM `jmuv3`.`goods` AS `Good` LEFT JOIN `jmuv3`.`stores` AS `Store` ON (`Store`.`id` = `Good`.`store_id`) LEFT JOIN `jmuv3`.`sellers` AS `Seller` ON (`Seller`.`id` = `Store`.`seller_id`) LEFT JOIN `jmuv3`.`users` AS `User` ON (`User`.`id` = `Seller`.`user_id`) LEFT JOIN `jmuv3`.`specs` AS `DefaultSpec` ON (`DefaultSpec`.`goods_id` = `Good`.`id` AND `DefaultSpec`.`issetspec` = 1) LEFT JOIN `jmuv3`.`categories` AS `Category` ON (`Category`.`id` = `Good`.`category_id`) WHERE `Good`.`isaudit` = 1 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Store`.`isaudit` = 1 AND `User`.`is_delete` = 0 AND `Good`.`category_id` = (190) ORDER BY `Store`.`grade` DESC, `Good`.`modified` DESC LIMIT 16	2	2	1

(default) 10 queries took 20 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `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` ASC

SELECT `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)

SELECT `Category`.`id` FROM `jmuv3`.`recommends_categories` AS `RecommendsCategory` LEFT JOIN `jmuv3`.`categories` AS `Category` ON (`RecommendsCategory`.`category_id` = `Category`.`id`) LEFT JOIN `jmuv3`.`recommends` AS `Recommend` ON (`Recommend`.`type` = 3 AND `RecommendsCategory`.`recommend_id` = `Recommend`.`id`) WHERE `Recommend`.`code` = 'indexv2_hot_categories' AND `Recommend`.`type` = 3 ORDER BY `RecommendsCategory`.`sort_order` ASC, `RecommendsCategory`.`modified` DESC LIMIT 200

200

SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name` FROM `jmuv3`.`categories` AS `Category` WHERE `Category`.`id` IN (7, 55, 34, 38, 26, 59, 11, 52, 17, 48, 23, 18, 41, 49, 12, 56, 61, 27, 53, 5, 24, 35, 62, 50, 21, 32, 43, 57, 13, 51, 25, 6, 36, 1, 2, 4, 9, 10, 8, 3, 564, 590, 471, 211, 477, 759, 791, 776, 123, 460, 462, 574, 215, 286, 461, 530, 742, 456, 589, 208, 561, 811, 181, 582, 188, 578, 575, 735, 793, 473, 504, 788, 548, 708, 84, 738, 591, 599, 605, 815, 262, 513, 1891, 596, 706, 758, 765, 121, 282, 537, 122, 527, 289, 757, 209, 260, 586, 207, 455, 790, 265, 463, 577, 737, 762, 284, 486, 810, 291, 294, 459, 103, 570, 764, 190, 281, 545, 1894, 569, 576, 608, 714, 792, 115, 549, 585, 761, 734, 766, 808, 69, 285, 541, 496, 542, 567, 593, 760, 457, 264, 292, 492, 579, 503, 547, 602, 523, 552, 607, 744, 494, 495, 287, 521, 555, 711, 733, 107, 507, 466, 709, 263, 280, 467, 80, 288, 559, 787, 184, 189, 192, 202, 329, 510, 786, 106, 335, 543, 566, 111, 261, 293, 512, 266, 595, 501, 583, 95, 191, 789, 180, 517, 195, 782, 290, 568, 210, 212, 465, 778) ORDER BY FIELD(`Category`.`id`, 7,55,34,38,26,59,11,52,17,48,23,18,41,49,12,56,61,27,53,5,24,35,62,50,21,32,43,57,13,51,25,6,36,1,2,4,9,10,8,3,564,590,471,211,477,759,791,776,123,460,462,574,215,286,461,530,742,456,589,208,561,811,181,582,188,578,575,735,793,473,504,788,548,708,84,738,591,599,605,815,262,513,1891,596,706,758,765,121,282,537,122,527,289,757,209,260,586,207,455,790,265,463,577,737,762,284,486,810,291,294,459,103,570,764,190,281,545,1894,569,576,608,714,792,115,549,585,761,734,766,808,69,285,541,496,542,567,593,760,457,264,292,492,579,503,547,602,523,552,607,744,494,495,287,521,555,711,733,107,507,466,709,263,280,467,80,288,559,787,184,189,192,202,329,510,786,106,335,543,566,111,261,293,512,266,595,501,583,95,191,789,180,517,195,782,290,568,210,212,465,778) ASC

200

SELECT `Category`.`lft`, `Category`.`rght` FROM `jmuv3`.`categories` AS `Category` WHERE `Category`.`id` = 190 LIMIT 1

SELECT `Category`.`id`, `Category`.`name` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`lft` <= 271 AND `Category`.`rght` >= 272 ORDER BY `Category`.`lft` asc

SELECT `Category`.`lft`, `Category`.`rght` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 190 LIMIT 1

SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 272 AND `Category`.`lft` > 271 ORDER BY `Category`.`lft` asc

SELECT COUNT(*) AS `count` FROM `jmuv3`.`goods` AS `Good` LEFT JOIN `jmuv3`.`stores` AS `Store` ON (`Store`.`id` = `Good`.`store_id`) LEFT JOIN `jmuv3`.`sellers` AS `Seller` ON (`Seller`.`id` = `Store`.`seller_id`) LEFT JOIN `jmuv3`.`users` AS `User` ON (`User`.`id` = `Seller`.`user_id`) LEFT JOIN `jmuv3`.`specs` AS `DefaultSpec` ON (`DefaultSpec`.`goods_id` = `Good`.`id` AND `DefaultSpec`.`issetspec` = 1) LEFT JOIN `jmuv3`.`categories` AS `Category` ON (`Category`.`id` = `Good`.`category_id`) WHERE `Good`.`isaudit` = 1 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Store`.`isaudit` = 1 AND `User`.`is_delete` = 0 AND `Good`.`category_id` = (190)

SELECT `Good`.`id`, `Good`.`name`, `Good`.`type`, `Good`.`image`, `Good`.`from`, `DefaultSpec`.`issetspec`, `DefaultSpec`.`price`, `DefaultSpec`.`price_1`, `DefaultSpec`.`price_2`, `DefaultSpec`.`price_3`, `DefaultSpec`.`price_4`, `DefaultSpec`.`point` FROM `jmuv3`.`goods` AS `Good` LEFT JOIN `jmuv3`.`stores` AS `Store` ON (`Store`.`id` = `Good`.`store_id`) LEFT JOIN `jmuv3`.`sellers` AS `Seller` ON (`Seller`.`id` = `Store`.`seller_id`) LEFT JOIN `jmuv3`.`users` AS `User` ON (`User`.`id` = `Seller`.`user_id`) LEFT JOIN `jmuv3`.`specs` AS `DefaultSpec` ON (`DefaultSpec`.`goods_id` = `Good`.`id` AND `DefaultSpec`.`issetspec` = 1) LEFT JOIN `jmuv3`.`categories` AS `Category` ON (`Category`.`id` = `Good`.`category_id`) WHERE `Good`.`isaudit` = 1 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Store`.`isaudit` = 1 AND `User`.`is_delete` = 0 AND `Good`.`category_id` = (190) ORDER BY `Store`.`grade` DESC, `Good`.`modified` DESC LIMIT 16

用户登录