最新销量榜
最近一周累计销售额TOP3的商品
市场热度

今日新增产品:0

市场动态

[品牌供应商] 百汇农珍 荞麦面 查看价格

[品牌供应商] 晋谷21号 小米 查看价格

[品牌供应商] 五谷杂粮面 查看价格

[品牌供应商] 杂粮礼盒 查看价格

专业设备
更多
(default) 112 queries took 198 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` 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 2002002002
4SELECT `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) ASC2002003
5SELECT `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
6SELECT `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
7SELECT `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
8SELECT `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
9SELECT `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
10SELECT `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
11SELECT `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
12SELECT `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
13SELECT `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
14SELECT `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
15SELECT `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
16SELECT `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
17SELECT `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
18SELECT `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
19SELECT `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
20SELECT `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
21SELECT `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
22SELECT `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
23SELECT `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
24SELECT `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
25SELECT `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
26SELECT `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
27SELECT `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
28SELECT `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
29SELECT `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
30SELECT `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
31SELECT `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
32SELECT `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
33SELECT `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
34SELECT `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
35SELECT `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
36SELECT `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
37SELECT `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
38SELECT `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
39SELECT `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
40SELECT `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
41SELECT `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
42SELECT `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
43SELECT `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
44SELECT `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
45SELECT `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
46SELECT `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
47SELECT `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
48SELECT `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
49SELECT `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
50SELECT `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
51SELECT `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
52SELECT `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
53SELECT `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
54SELECT `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
55SELECT `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
56SELECT `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
57SELECT `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
58SELECT `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
59SELECT `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
60SELECT `Adimage`.`id`, `Adimage`.`name`, `Adimage`.`img`, `Adimage`.`ad_id`, `Adimage`.`sort`, `Adimage`.`created`, `Adimage`.`modified`, `Adimage`.`filename`, `Adimage`.`address`, `Adimage`.`code`, `Adimage`.`link`, `Adimage`.`codegroup` FROM `jmuv3`.`adimages` AS `Adimage` WHERE `Adimage`.`ad_id` = 4111
61SELECT COUNT(*) AS `count` FROM `jmuv3`.`goods` AS `Good` WHERE `Good`.`isaudit` = 1 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`modified` > '2017-04-28 00:00:00'111
62SELECT `Good`.`id`, `Good`.`name`, `Store`.`grade`, `DefaultSpec`.`price`, `DefaultSpec`.`price_1`, `DefaultSpec`.`price_2`, `DefaultSpec`.`price_3`, `DefaultSpec`.`issetspec`, `DefaultSpec`.`integral` 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`.`id` = `Good`.`spec_id`) WHERE `Store`.`isaudit` = 1 AND `Good`.`isaudit` = 1 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `User`.`is_delete` =0 AND `DefaultSpec`.`issetspec` = 1 ORDER BY `Good`.`modified` DESC LIMIT 4441
63SELECT `Good`.`id` FROM `jmuv3`.`recommends_goods` AS `RecommendsGood` left JOIN `jmuv3`.`recommends` AS `Recommend` ON (`Recommend`.`id` = `RecommendsGood`.`recommend_id`) left JOIN `jmuv3`.`goods` AS `Good` ON (`Good`.`id` = `RecommendsGood`.`goods_id`) 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`) WHERE `Recommend`.`type` = 2 AND `Recommend`.`code` = 'market_category_goods' AND `RecommendsGood`.`category_id` IN (569, 570, 571, 572, 573, 574, 575) AND `Store`.`isaudit` = 1 AND `Good`.`isaudit` = 1 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `User`.`is_delete` = 0 ORDER BY `RecommendsGood`.`sort_order` asc, `RecommendsGood`.`modified` desc LIMIT 14882
64SELECT `Good`.`id`, `Good`.`name`, `Good`.`image` FROM `jmuv3`.`goods` AS `Good` WHERE `Good`.`id` IN (133509, 61545, 133336, 49518, 132120, 132577, 132467, 133179)881
65SELECT `Spec`.`id`, `Spec`.`store_id`, `Spec`.`goods_id`, `Spec`.`stock`, `Spec`.`unit`, `Spec`.`price`, `Spec`.`range_price`, `Spec`.`spec_1`, `Spec`.`spec_2`, `Spec`.`value_1`, `Spec`.`value_2`, `Spec`.`price_1`, `Spec`.`price_2`, `Spec`.`price_3`, `Spec`.`price_4`, `Spec`.`reduce_1`, `Spec`.`reduce_2`, `Spec`.`reduce_3`, `Spec`.`reduce_4`, `Spec`.`discount_1`, `Spec`.`discount_2`, `Spec`.`discount_3`, `Spec`.`discount_4`, `Spec`.`sku`, `Spec`.`description`, `Spec`.`issetspec`, `Spec`.`oldgoodid`, `Spec`.`oldid`, `Spec`.`created`, `Spec`.`modified`, `Spec`.`article`, `Spec`.`integral` FROM `jmuv3`.`specs` AS `Spec` WHERE `Spec`.`goods_id` IN (133509, 61545, 133336, 49518, 132120, 132577, 132467, 133179) AND `issetspec` = 1881
66SELECT `Goodsview`.`id`, `Goodsview`.`goods_id`, `Goodsview`.`stock`, `Goodsview`.`crt_collection`, `Goodsview`.`his_collection`, `Goodsview`.`favorites_count_bak`, `Goodsview`.`order_count`, `Goodsview`.`order_volume`, `Goodsview`.`payed_volume`, `Goodsview`.`finish_volume`, `Goodsview`.`month_volume`, `Goodsview`.`week_volume`, `Goodsview`.`order_volume_week`, `Goodsview`.`payed_volume_week`, `Goodsview`.`finish_volume_week`, `Goodsview`.`comment_count`, `Goodsview`.`created`, `Goodsview`.`modified`, `Goodsview`.`store_id` FROM `jmuv3`.`goodsviews` AS `Goodsview` WHERE `Goodsview`.`goods_id` IN (133509, 61545, 133336, 49518, 132120, 132577, 132467, 133179)881
67SELECT `Good`.`id`, `Good`.`sn`, `Good`.`seller_id`, `Good`.`store_id`, `Good`.`spec_id`, `Good`.`category_id`, `Good`.`category_name`, `Good`.`innercategory_id`, `Good`.`innercategory_name`, `Good`.`type`, `Good`.`least`, `Good`.`unit`, `Good`.`price`, `Good`.`min_price_1`, `Good`.`max_price_1`, `Good`.`min_price_2`, `Good`.`max_price_2`, `Good`.`min_price_3`, `Good`.`max_price_3`, `Good`.`min_price_4`, `Good`.`max_price_4`, `Good`.`name`, `Good`.`adword`, `Good`.`image`, `Good`.`brand`, `Good`.`description`, `Good`.`auditreason`, `Good`.`isperiod`, `Good`.`period_1`, `Good`.`period_2`, `Good`.`isaudit`, `Good`.`isshow`, `Good`.`isdelete`, `Good`.`ismianyi`, `Good`.`isrecommend`, `Good`.`recommenddesc`, `Good`.`recommendpos`, `Good`.`nopass_number`, `Good`.`importedareas_id`, `Good`.`oldid`, `Good`.`created`, `Good`.`modified`, `Good`.`audittime`, `Good`.`client_id`, `Good`.`recommends_stores_new_id`, `Good`.`brand_id`, `Good`.`storage`, `Good`.`shelflife`, `Good`.`netweight`, `Good`.`packaging`, `Good`.`produc_id`, `Good`.`area`, `Good`.`product_date1`, `Good`.`product_date2`, `Good`.`from`, `Good`.`recommend_flag_order`, `Good`.`factory`, `Good`.`ishide`, `Good`.`totalweight`, `Good`.`goods_long`, `Good`.`goods_width`, `Good`.`goods_high`, `Good`.`goods_type`, `Good`.`taxrate`, `Good`.`goods_guarantee`, `Good`.`goods_guarantee_unit`, `Good`.`goods_code`, `Good`.`is_ladder` FROM `jmuv3`.`goods` AS `Good` left JOIN `jmuv3`.`goodsviews` AS `Goodsview` ON (`Goodsview`.`id` = `Good`.`id`) WHERE `Good`.`id` IN (133509, 61545, 133336, 49518, 132120, 132577, 132467, 133179) ORDER BY `Goodsview`.`order_volume` desc LIMIT 4443
68SELECT `Good`.`id` FROM `jmuv3`.`recommends_goods` AS `RecommendsGood` left JOIN `jmuv3`.`recommends` AS `Recommend` ON (`Recommend`.`id` = `RecommendsGood`.`recommend_id`) left JOIN `jmuv3`.`goods` AS `Good` ON (`Good`.`id` = `RecommendsGood`.`goods_id`) 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`) WHERE `Recommend`.`type` = 2 AND `Recommend`.`code` = 'market_category_goods' AND `RecommendsGood`.`category_id` IN (468, 469, 470, 471, 472, 473, 474, 475, 476, 477, 478, 479, 480, 481, 482, 483, 484, 485, 486, 487, 488, 489, 490) AND `Store`.`isaudit` = 1 AND `Good`.`isaudit` = 1 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `User`.`is_delete` = 0 ORDER BY `RecommendsGood`.`sort_order` asc, `RecommendsGood`.`modified` desc LIMIT 14442
69SELECT `Good`.`id`, `Good`.`name`, `Good`.`image` FROM `jmuv3`.`goods` AS `Good` WHERE `Good`.`id` IN (37469, 65205, 31604, 66572)441
70SELECT `Spec`.`id`, `Spec`.`store_id`, `Spec`.`goods_id`, `Spec`.`stock`, `Spec`.`unit`, `Spec`.`price`, `Spec`.`range_price`, `Spec`.`spec_1`, `Spec`.`spec_2`, `Spec`.`value_1`, `Spec`.`value_2`, `Spec`.`price_1`, `Spec`.`price_2`, `Spec`.`price_3`, `Spec`.`price_4`, `Spec`.`reduce_1`, `Spec`.`reduce_2`, `Spec`.`reduce_3`, `Spec`.`reduce_4`, `Spec`.`discount_1`, `Spec`.`discount_2`, `Spec`.`discount_3`, `Spec`.`discount_4`, `Spec`.`sku`, `Spec`.`description`, `Spec`.`issetspec`, `Spec`.`oldgoodid`, `Spec`.`oldid`, `Spec`.`created`, `Spec`.`modified`, `Spec`.`article`, `Spec`.`integral` FROM `jmuv3`.`specs` AS `Spec` WHERE `Spec`.`goods_id` IN (37469, 65205, 31604, 66572) AND `issetspec` = 1441
71SELECT `Goodsview`.`id`, `Goodsview`.`goods_id`, `Goodsview`.`stock`, `Goodsview`.`crt_collection`, `Goodsview`.`his_collection`, `Goodsview`.`favorites_count_bak`, `Goodsview`.`order_count`, `Goodsview`.`order_volume`, `Goodsview`.`payed_volume`, `Goodsview`.`finish_volume`, `Goodsview`.`month_volume`, `Goodsview`.`week_volume`, `Goodsview`.`order_volume_week`, `Goodsview`.`payed_volume_week`, `Goodsview`.`finish_volume_week`, `Goodsview`.`comment_count`, `Goodsview`.`created`, `Goodsview`.`modified`, `Goodsview`.`store_id` FROM `jmuv3`.`goodsviews` AS `Goodsview` WHERE `Goodsview`.`goods_id` IN (37469, 65205, 31604, 66572)441
72SELECT `Good`.`id`, `Good`.`sn`, `Good`.`seller_id`, `Good`.`store_id`, `Good`.`spec_id`, `Good`.`category_id`, `Good`.`category_name`, `Good`.`innercategory_id`, `Good`.`innercategory_name`, `Good`.`type`, `Good`.`least`, `Good`.`unit`, `Good`.`price`, `Good`.`min_price_1`, `Good`.`max_price_1`, `Good`.`min_price_2`, `Good`.`max_price_2`, `Good`.`min_price_3`, `Good`.`max_price_3`, `Good`.`min_price_4`, `Good`.`max_price_4`, `Good`.`name`, `Good`.`adword`, `Good`.`image`, `Good`.`brand`, `Good`.`description`, `Good`.`auditreason`, `Good`.`isperiod`, `Good`.`period_1`, `Good`.`period_2`, `Good`.`isaudit`, `Good`.`isshow`, `Good`.`isdelete`, `Good`.`ismianyi`, `Good`.`isrecommend`, `Good`.`recommenddesc`, `Good`.`recommendpos`, `Good`.`nopass_number`, `Good`.`importedareas_id`, `Good`.`oldid`, `Good`.`created`, `Good`.`modified`, `Good`.`audittime`, `Good`.`client_id`, `Good`.`recommends_stores_new_id`, `Good`.`brand_id`, `Good`.`storage`, `Good`.`shelflife`, `Good`.`netweight`, `Good`.`packaging`, `Good`.`produc_id`, `Good`.`area`, `Good`.`product_date1`, `Good`.`product_date2`, `Good`.`from`, `Good`.`recommend_flag_order`, `Good`.`factory`, `Good`.`ishide`, `Good`.`totalweight`, `Good`.`goods_long`, `Good`.`goods_width`, `Good`.`goods_high`, `Good`.`goods_type`, `Good`.`taxrate`, `Good`.`goods_guarantee`, `Good`.`goods_guarantee_unit`, `Good`.`goods_code`, `Good`.`is_ladder` FROM `jmuv3`.`goods` AS `Good` left JOIN `jmuv3`.`goodsviews` AS `Goodsview` ON (`Goodsview`.`id` = `Good`.`id`) WHERE `Good`.`id` IN (37469, 65205, 31604, 66572) ORDER BY `Goodsview`.`order_volume` desc LIMIT 4443
73SELECT `Good`.`id` FROM `jmuv3`.`recommends_goods` AS `RecommendsGood` left JOIN `jmuv3`.`recommends` AS `Recommend` ON (`Recommend`.`id` = `RecommendsGood`.`recommend_id`) left JOIN `jmuv3`.`goods` AS `Good` ON (`Good`.`id` = `RecommendsGood`.`goods_id`) 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`) WHERE `Recommend`.`type` = 2 AND `Recommend`.`code` = 'market_category_goods' AND `RecommendsGood`.`category_id` IN (529, 530, 531, 532, 533, 534) AND `Store`.`isaudit` = 1 AND `Good`.`isaudit` = 1 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `User`.`is_delete` = 0 ORDER BY `RecommendsGood`.`sort_order` asc, `RecommendsGood`.`modified` desc LIMIT 14662
74SELECT `Good`.`id`, `Good`.`name`, `Good`.`image` FROM `jmuv3`.`goods` AS `Good` WHERE `Good`.`id` IN (48367, 47361, 131457, 17013, 70043, 70048)661
75SELECT `Spec`.`id`, `Spec`.`store_id`, `Spec`.`goods_id`, `Spec`.`stock`, `Spec`.`unit`, `Spec`.`price`, `Spec`.`range_price`, `Spec`.`spec_1`, `Spec`.`spec_2`, `Spec`.`value_1`, `Spec`.`value_2`, `Spec`.`price_1`, `Spec`.`price_2`, `Spec`.`price_3`, `Spec`.`price_4`, `Spec`.`reduce_1`, `Spec`.`reduce_2`, `Spec`.`reduce_3`, `Spec`.`reduce_4`, `Spec`.`discount_1`, `Spec`.`discount_2`, `Spec`.`discount_3`, `Spec`.`discount_4`, `Spec`.`sku`, `Spec`.`description`, `Spec`.`issetspec`, `Spec`.`oldgoodid`, `Spec`.`oldid`, `Spec`.`created`, `Spec`.`modified`, `Spec`.`article`, `Spec`.`integral` FROM `jmuv3`.`specs` AS `Spec` WHERE `Spec`.`goods_id` IN (48367, 47361, 131457, 17013, 70043, 70048) AND `issetspec` = 1661
76SELECT `Goodsview`.`id`, `Goodsview`.`goods_id`, `Goodsview`.`stock`, `Goodsview`.`crt_collection`, `Goodsview`.`his_collection`, `Goodsview`.`favorites_count_bak`, `Goodsview`.`order_count`, `Goodsview`.`order_volume`, `Goodsview`.`payed_volume`, `Goodsview`.`finish_volume`, `Goodsview`.`month_volume`, `Goodsview`.`week_volume`, `Goodsview`.`order_volume_week`, `Goodsview`.`payed_volume_week`, `Goodsview`.`finish_volume_week`, `Goodsview`.`comment_count`, `Goodsview`.`created`, `Goodsview`.`modified`, `Goodsview`.`store_id` FROM `jmuv3`.`goodsviews` AS `Goodsview` WHERE `Goodsview`.`goods_id` IN (48367, 47361, 131457, 17013, 70043, 70048)661
77SELECT `Good`.`id`, `Good`.`sn`, `Good`.`seller_id`, `Good`.`store_id`, `Good`.`spec_id`, `Good`.`category_id`, `Good`.`category_name`, `Good`.`innercategory_id`, `Good`.`innercategory_name`, `Good`.`type`, `Good`.`least`, `Good`.`unit`, `Good`.`price`, `Good`.`min_price_1`, `Good`.`max_price_1`, `Good`.`min_price_2`, `Good`.`max_price_2`, `Good`.`min_price_3`, `Good`.`max_price_3`, `Good`.`min_price_4`, `Good`.`max_price_4`, `Good`.`name`, `Good`.`adword`, `Good`.`image`, `Good`.`brand`, `Good`.`description`, `Good`.`auditreason`, `Good`.`isperiod`, `Good`.`period_1`, `Good`.`period_2`, `Good`.`isaudit`, `Good`.`isshow`, `Good`.`isdelete`, `Good`.`ismianyi`, `Good`.`isrecommend`, `Good`.`recommenddesc`, `Good`.`recommendpos`, `Good`.`nopass_number`, `Good`.`importedareas_id`, `Good`.`oldid`, `Good`.`created`, `Good`.`modified`, `Good`.`audittime`, `Good`.`client_id`, `Good`.`recommends_stores_new_id`, `Good`.`brand_id`, `Good`.`storage`, `Good`.`shelflife`, `Good`.`netweight`, `Good`.`packaging`, `Good`.`produc_id`, `Good`.`area`, `Good`.`product_date1`, `Good`.`product_date2`, `Good`.`from`, `Good`.`recommend_flag_order`, `Good`.`factory`, `Good`.`ishide`, `Good`.`totalweight`, `Good`.`goods_long`, `Good`.`goods_width`, `Good`.`goods_high`, `Good`.`goods_type`, `Good`.`taxrate`, `Good`.`goods_guarantee`, `Good`.`goods_guarantee_unit`, `Good`.`goods_code`, `Good`.`is_ladder` FROM `jmuv3`.`goods` AS `Good` left JOIN `jmuv3`.`goodsviews` AS `Goodsview` ON (`Goodsview`.`id` = `Good`.`id`) WHERE `Good`.`id` IN (48367, 47361, 131457, 17013, 70043, 70048) ORDER BY `Goodsview`.`order_volume` desc LIMIT 4443
78SELECT `Good`.`id` FROM `jmuv3`.`recommends_goods` AS `RecommendsGood` left JOIN `jmuv3`.`recommends` AS `Recommend` ON (`Recommend`.`id` = `RecommendsGood`.`recommend_id`) left JOIN `jmuv3`.`goods` AS `Good` ON (`Good`.`id` = `RecommendsGood`.`goods_id`) 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`) WHERE `Recommend`.`type` = 2 AND `Recommend`.`code` = 'market_category_goods' AND `RecommendsGood`.`category_id` IN (64, 65, 66, 67, 68) AND `Store`.`isaudit` = 1 AND `Good`.`isaudit` = 1 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `User`.`is_delete` = 0 ORDER BY `RecommendsGood`.`sort_order` asc, `RecommendsGood`.`modified` desc LIMIT 14662
79SELECT `Good`.`id`, `Good`.`name`, `Good`.`image` FROM `jmuv3`.`goods` AS `Good` WHERE `Good`.`id` IN (66391, 72319, 73307, 73188, 73576, 132793)661
80SELECT `Spec`.`id`, `Spec`.`store_id`, `Spec`.`goods_id`, `Spec`.`stock`, `Spec`.`unit`, `Spec`.`price`, `Spec`.`range_price`, `Spec`.`spec_1`, `Spec`.`spec_2`, `Spec`.`value_1`, `Spec`.`value_2`, `Spec`.`price_1`, `Spec`.`price_2`, `Spec`.`price_3`, `Spec`.`price_4`, `Spec`.`reduce_1`, `Spec`.`reduce_2`, `Spec`.`reduce_3`, `Spec`.`reduce_4`, `Spec`.`discount_1`, `Spec`.`discount_2`, `Spec`.`discount_3`, `Spec`.`discount_4`, `Spec`.`sku`, `Spec`.`description`, `Spec`.`issetspec`, `Spec`.`oldgoodid`, `Spec`.`oldid`, `Spec`.`created`, `Spec`.`modified`, `Spec`.`article`, `Spec`.`integral` FROM `jmuv3`.`specs` AS `Spec` WHERE `Spec`.`goods_id` IN (66391, 72319, 73307, 73188, 73576, 132793) AND `issetspec` = 1661
81SELECT `Goodsview`.`id`, `Goodsview`.`goods_id`, `Goodsview`.`stock`, `Goodsview`.`crt_collection`, `Goodsview`.`his_collection`, `Goodsview`.`favorites_count_bak`, `Goodsview`.`order_count`, `Goodsview`.`order_volume`, `Goodsview`.`payed_volume`, `Goodsview`.`finish_volume`, `Goodsview`.`month_volume`, `Goodsview`.`week_volume`, `Goodsview`.`order_volume_week`, `Goodsview`.`payed_volume_week`, `Goodsview`.`finish_volume_week`, `Goodsview`.`comment_count`, `Goodsview`.`created`, `Goodsview`.`modified`, `Goodsview`.`store_id` FROM `jmuv3`.`goodsviews` AS `Goodsview` WHERE `Goodsview`.`goods_id` IN (66391, 72319, 73307, 73188, 73576, 132793)661
82SELECT `Good`.`id`, `Good`.`sn`, `Good`.`seller_id`, `Good`.`store_id`, `Good`.`spec_id`, `Good`.`category_id`, `Good`.`category_name`, `Good`.`innercategory_id`, `Good`.`innercategory_name`, `Good`.`type`, `Good`.`least`, `Good`.`unit`, `Good`.`price`, `Good`.`min_price_1`, `Good`.`max_price_1`, `Good`.`min_price_2`, `Good`.`max_price_2`, `Good`.`min_price_3`, `Good`.`max_price_3`, `Good`.`min_price_4`, `Good`.`max_price_4`, `Good`.`name`, `Good`.`adword`, `Good`.`image`, `Good`.`brand`, `Good`.`description`, `Good`.`auditreason`, `Good`.`isperiod`, `Good`.`period_1`, `Good`.`period_2`, `Good`.`isaudit`, `Good`.`isshow`, `Good`.`isdelete`, `Good`.`ismianyi`, `Good`.`isrecommend`, `Good`.`recommenddesc`, `Good`.`recommendpos`, `Good`.`nopass_number`, `Good`.`importedareas_id`, `Good`.`oldid`, `Good`.`created`, `Good`.`modified`, `Good`.`audittime`, `Good`.`client_id`, `Good`.`recommends_stores_new_id`, `Good`.`brand_id`, `Good`.`storage`, `Good`.`shelflife`, `Good`.`netweight`, `Good`.`packaging`, `Good`.`produc_id`, `Good`.`area`, `Good`.`product_date1`, `Good`.`product_date2`, `Good`.`from`, `Good`.`recommend_flag_order`, `Good`.`factory`, `Good`.`ishide`, `Good`.`totalweight`, `Good`.`goods_long`, `Good`.`goods_width`, `Good`.`goods_high`, `Good`.`goods_type`, `Good`.`taxrate`, `Good`.`goods_guarantee`, `Good`.`goods_guarantee_unit`, `Good`.`goods_code`, `Good`.`is_ladder` FROM `jmuv3`.`goods` AS `Good` left JOIN `jmuv3`.`goodsviews` AS `Goodsview` ON (`Goodsview`.`id` = `Good`.`id`) WHERE `Good`.`id` IN (66391, 72319, 73307, 73188, 73576, 132793) ORDER BY `Goodsview`.`order_volume` desc LIMIT 4442
83SELECT `Good`.`id` FROM `jmuv3`.`recommends_goods` AS `RecommendsGood` left JOIN `jmuv3`.`recommends` AS `Recommend` ON (`Recommend`.`id` = `RecommendsGood`.`recommend_id`) left JOIN `jmuv3`.`goods` AS `Good` ON (`Good`.`id` = `RecommendsGood`.`goods_id`) 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`) WHERE `Recommend`.`type` = 2 AND `Recommend`.`code` = 'market_category_goods' AND `RecommendsGood`.`category_id` IN (177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206) AND `Store`.`isaudit` = 1 AND `Good`.`isaudit` = 1 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `User`.`is_delete` = 0 ORDER BY `RecommendsGood`.`sort_order` asc, `RecommendsGood`.`modified` desc LIMIT 14772
84SELECT `Good`.`id`, `Good`.`name`, `Good`.`image` FROM `jmuv3`.`goods` AS `Good` WHERE `Good`.`id` IN (43490, 62313, 26375, 66133, 66888, 66884, 30118)771
85SELECT `Spec`.`id`, `Spec`.`store_id`, `Spec`.`goods_id`, `Spec`.`stock`, `Spec`.`unit`, `Spec`.`price`, `Spec`.`range_price`, `Spec`.`spec_1`, `Spec`.`spec_2`, `Spec`.`value_1`, `Spec`.`value_2`, `Spec`.`price_1`, `Spec`.`price_2`, `Spec`.`price_3`, `Spec`.`price_4`, `Spec`.`reduce_1`, `Spec`.`reduce_2`, `Spec`.`reduce_3`, `Spec`.`reduce_4`, `Spec`.`discount_1`, `Spec`.`discount_2`, `Spec`.`discount_3`, `Spec`.`discount_4`, `Spec`.`sku`, `Spec`.`description`, `Spec`.`issetspec`, `Spec`.`oldgoodid`, `Spec`.`oldid`, `Spec`.`created`, `Spec`.`modified`, `Spec`.`article`, `Spec`.`integral` FROM `jmuv3`.`specs` AS `Spec` WHERE `Spec`.`goods_id` IN (43490, 62313, 26375, 66133, 66888, 66884, 30118) AND `issetspec` = 1771
86SELECT `Goodsview`.`id`, `Goodsview`.`goods_id`, `Goodsview`.`stock`, `Goodsview`.`crt_collection`, `Goodsview`.`his_collection`, `Goodsview`.`favorites_count_bak`, `Goodsview`.`order_count`, `Goodsview`.`order_volume`, `Goodsview`.`payed_volume`, `Goodsview`.`finish_volume`, `Goodsview`.`month_volume`, `Goodsview`.`week_volume`, `Goodsview`.`order_volume_week`, `Goodsview`.`payed_volume_week`, `Goodsview`.`finish_volume_week`, `Goodsview`.`comment_count`, `Goodsview`.`created`, `Goodsview`.`modified`, `Goodsview`.`store_id` FROM `jmuv3`.`goodsviews` AS `Goodsview` WHERE `Goodsview`.`goods_id` IN (43490, 62313, 26375, 66133, 66888, 66884, 30118)771
87SELECT `Good`.`id`, `Good`.`sn`, `Good`.`seller_id`, `Good`.`store_id`, `Good`.`spec_id`, `Good`.`category_id`, `Good`.`category_name`, `Good`.`innercategory_id`, `Good`.`innercategory_name`, `Good`.`type`, `Good`.`least`, `Good`.`unit`, `Good`.`price`, `Good`.`min_price_1`, `Good`.`max_price_1`, `Good`.`min_price_2`, `Good`.`max_price_2`, `Good`.`min_price_3`, `Good`.`max_price_3`, `Good`.`min_price_4`, `Good`.`max_price_4`, `Good`.`name`, `Good`.`adword`, `Good`.`image`, `Good`.`brand`, `Good`.`description`, `Good`.`auditreason`, `Good`.`isperiod`, `Good`.`period_1`, `Good`.`period_2`, `Good`.`isaudit`, `Good`.`isshow`, `Good`.`isdelete`, `Good`.`ismianyi`, `Good`.`isrecommend`, `Good`.`recommenddesc`, `Good`.`recommendpos`, `Good`.`nopass_number`, `Good`.`importedareas_id`, `Good`.`oldid`, `Good`.`created`, `Good`.`modified`, `Good`.`audittime`, `Good`.`client_id`, `Good`.`recommends_stores_new_id`, `Good`.`brand_id`, `Good`.`storage`, `Good`.`shelflife`, `Good`.`netweight`, `Good`.`packaging`, `Good`.`produc_id`, `Good`.`area`, `Good`.`product_date1`, `Good`.`product_date2`, `Good`.`from`, `Good`.`recommend_flag_order`, `Good`.`factory`, `Good`.`ishide`, `Good`.`totalweight`, `Good`.`goods_long`, `Good`.`goods_width`, `Good`.`goods_high`, `Good`.`goods_type`, `Good`.`taxrate`, `Good`.`goods_guarantee`, `Good`.`goods_guarantee_unit`, `Good`.`goods_code`, `Good`.`is_ladder` FROM `jmuv3`.`goods` AS `Good` left JOIN `jmuv3`.`goodsviews` AS `Goodsview` ON (`Goodsview`.`id` = `Good`.`id`) WHERE `Good`.`id` IN (43490, 62313, 26375, 66133, 66888, 66884, 30118) ORDER BY `Goodsview`.`order_volume` desc LIMIT 4443
88SELECT `Good`.`id` FROM `jmuv3`.`recommends_goods` AS `RecommendsGood` left JOIN `jmuv3`.`recommends` AS `Recommend` ON (`Recommend`.`id` = `RecommendsGood`.`recommend_id`) left JOIN `jmuv3`.`goods` AS `Good` ON (`Good`.`id` = `RecommendsGood`.`goods_id`) 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`) WHERE `Recommend`.`type` = 2 AND `Recommend`.`code` = 'market_category_goods' AND `RecommendsGood`.`category_id` IN (287, 288, 289, 290, 291, 292, 293, 294, 295, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 310, 311, 312, 313, 314, 315, 316, 317, 318, 319, 320, 321, 322, 323) AND `Store`.`isaudit` = 1 AND `Good`.`isaudit` = 1 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `User`.`is_delete` = 0 ORDER BY `RecommendsGood`.`sort_order` asc, `RecommendsGood`.`modified` desc LIMIT 14222
89SELECT `Good`.`id`, `Good`.`name`, `Good`.`image` FROM `jmuv3`.`goods` AS `Good` WHERE `Good`.`id` IN (69663, 69668)221
90SELECT `Spec`.`id`, `Spec`.`store_id`, `Spec`.`goods_id`, `Spec`.`stock`, `Spec`.`unit`, `Spec`.`price`, `Spec`.`range_price`, `Spec`.`spec_1`, `Spec`.`spec_2`, `Spec`.`value_1`, `Spec`.`value_2`, `Spec`.`price_1`, `Spec`.`price_2`, `Spec`.`price_3`, `Spec`.`price_4`, `Spec`.`reduce_1`, `Spec`.`reduce_2`, `Spec`.`reduce_3`, `Spec`.`reduce_4`, `Spec`.`discount_1`, `Spec`.`discount_2`, `Spec`.`discount_3`, `Spec`.`discount_4`, `Spec`.`sku`, `Spec`.`description`, `Spec`.`issetspec`, `Spec`.`oldgoodid`, `Spec`.`oldid`, `Spec`.`created`, `Spec`.`modified`, `Spec`.`article`, `Spec`.`integral` FROM `jmuv3`.`specs` AS `Spec` WHERE `Spec`.`goods_id` IN (69663, 69668) AND `issetspec` = 1221
91SELECT `Goodsview`.`id`, `Goodsview`.`goods_id`, `Goodsview`.`stock`, `Goodsview`.`crt_collection`, `Goodsview`.`his_collection`, `Goodsview`.`favorites_count_bak`, `Goodsview`.`order_count`, `Goodsview`.`order_volume`, `Goodsview`.`payed_volume`, `Goodsview`.`finish_volume`, `Goodsview`.`month_volume`, `Goodsview`.`week_volume`, `Goodsview`.`order_volume_week`, `Goodsview`.`payed_volume_week`, `Goodsview`.`finish_volume_week`, `Goodsview`.`comment_count`, `Goodsview`.`created`, `Goodsview`.`modified`, `Goodsview`.`store_id` FROM `jmuv3`.`goodsviews` AS `Goodsview` WHERE `Goodsview`.`goods_id` IN (69663, 69668)221
92SELECT `Good`.`id`, `Good`.`sn`, `Good`.`seller_id`, `Good`.`store_id`, `Good`.`spec_id`, `Good`.`category_id`, `Good`.`category_name`, `Good`.`innercategory_id`, `Good`.`innercategory_name`, `Good`.`type`, `Good`.`least`, `Good`.`unit`, `Good`.`price`, `Good`.`min_price_1`, `Good`.`max_price_1`, `Good`.`min_price_2`, `Good`.`max_price_2`, `Good`.`min_price_3`, `Good`.`max_price_3`, `Good`.`min_price_4`, `Good`.`max_price_4`, `Good`.`name`, `Good`.`adword`, `Good`.`image`, `Good`.`brand`, `Good`.`description`, `Good`.`auditreason`, `Good`.`isperiod`, `Good`.`period_1`, `Good`.`period_2`, `Good`.`isaudit`, `Good`.`isshow`, `Good`.`isdelete`, `Good`.`ismianyi`, `Good`.`isrecommend`, `Good`.`recommenddesc`, `Good`.`recommendpos`, `Good`.`nopass_number`, `Good`.`importedareas_id`, `Good`.`oldid`, `Good`.`created`, `Good`.`modified`, `Good`.`audittime`, `Good`.`client_id`, `Good`.`recommends_stores_new_id`, `Good`.`brand_id`, `Good`.`storage`, `Good`.`shelflife`, `Good`.`netweight`, `Good`.`packaging`, `Good`.`produc_id`, `Good`.`area`, `Good`.`product_date1`, `Good`.`product_date2`, `Good`.`from`, `Good`.`recommend_flag_order`, `Good`.`factory`, `Good`.`ishide`, `Good`.`totalweight`, `Good`.`goods_long`, `Good`.`goods_width`, `Good`.`goods_high`, `Good`.`goods_type`, `Good`.`taxrate`, `Good`.`goods_guarantee`, `Good`.`goods_guarantee_unit`, `Good`.`goods_code`, `Good`.`is_ladder` FROM `jmuv3`.`goods` AS `Good` left JOIN `jmuv3`.`goodsviews` AS `Goodsview` ON (`Goodsview`.`id` = `Good`.`id`) WHERE `Good`.`id` IN (69663, 69668) ORDER BY `Goodsview`.`order_volume` desc LIMIT 4222
93SELECT `Good`.`id` FROM `jmuv3`.`recommends_goods` AS `RecommendsGood` left JOIN `jmuv3`.`recommends` AS `Recommend` ON (`Recommend`.`id` = `RecommendsGood`.`recommend_id`) left JOIN `jmuv3`.`goods` AS `Good` ON (`Good`.`id` = `RecommendsGood`.`goods_id`) 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`) WHERE `Recommend`.`type` = 2 AND `Recommend`.`code` = 'market_category_goods' AND `RecommendsGood`.`category_id` IN (600, 601, 602, 603, 604, 605, 606, 607, 608, 609, 610, 611, 612, 613, 614, 615, 616, 617, 618, 619, 620, 621, 622, 623, 624, 625, 626, 627, 628, 629, 630, 631, 632, 633, 634, 635, 636, 637, 638, 639, 640, 641, 642, 643, 644, 645, 646, 647, 648, 649, 650, 651, 652, 653, 654, 655, 656, 657, 658, 659, 660, 661, 662, 663, 664, 665, 666, 667, 668, 669, 670, 671, 672, 673, 674, 675, 676, 677, 678, 679, 680, 681, 682, 683, 684, 685, 686, 687, 688, 689, 690, 691, 692, 693, 694, 695, 696, 697, 698, 699, 700, 701, 702, 703, 704, 705) AND `Store`.`isaudit` = 1 AND `Good`.`isaudit` = 1 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `User`.`is_delete` = 0 ORDER BY `RecommendsGood`.`sort_order` asc, `RecommendsGood`.`modified` desc LIMIT 14332
94SELECT `Good`.`id`, `Good`.`name`, `Good`.`image` FROM `jmuv3`.`goods` AS `Good` WHERE `Good`.`id` IN (67432, 55777, 133216)331
95SELECT `Spec`.`id`, `Spec`.`store_id`, `Spec`.`goods_id`, `Spec`.`stock`, `Spec`.`unit`, `Spec`.`price`, `Spec`.`range_price`, `Spec`.`spec_1`, `Spec`.`spec_2`, `Spec`.`value_1`, `Spec`.`value_2`, `Spec`.`price_1`, `Spec`.`price_2`, `Spec`.`price_3`, `Spec`.`price_4`, `Spec`.`reduce_1`, `Spec`.`reduce_2`, `Spec`.`reduce_3`, `Spec`.`reduce_4`, `Spec`.`discount_1`, `Spec`.`discount_2`, `Spec`.`discount_3`, `Spec`.`discount_4`, `Spec`.`sku`, `Spec`.`description`, `Spec`.`issetspec`, `Spec`.`oldgoodid`, `Spec`.`oldid`, `Spec`.`created`, `Spec`.`modified`, `Spec`.`article`, `Spec`.`integral` FROM `jmuv3`.`specs` AS `Spec` WHERE `Spec`.`goods_id` IN (67432, 55777, 133216) AND `issetspec` = 1331
96SELECT `Goodsview`.`id`, `Goodsview`.`goods_id`, `Goodsview`.`stock`, `Goodsview`.`crt_collection`, `Goodsview`.`his_collection`, `Goodsview`.`favorites_count_bak`, `Goodsview`.`order_count`, `Goodsview`.`order_volume`, `Goodsview`.`payed_volume`, `Goodsview`.`finish_volume`, `Goodsview`.`month_volume`, `Goodsview`.`week_volume`, `Goodsview`.`order_volume_week`, `Goodsview`.`payed_volume_week`, `Goodsview`.`finish_volume_week`, `Goodsview`.`comment_count`, `Goodsview`.`created`, `Goodsview`.`modified`, `Goodsview`.`store_id` FROM `jmuv3`.`goodsviews` AS `Goodsview` WHERE `Goodsview`.`goods_id` IN (67432, 55777, 133216)331
97SELECT `Good`.`id`, `Good`.`sn`, `Good`.`seller_id`, `Good`.`store_id`, `Good`.`spec_id`, `Good`.`category_id`, `Good`.`category_name`, `Good`.`innercategory_id`, `Good`.`innercategory_name`, `Good`.`type`, `Good`.`least`, `Good`.`unit`, `Good`.`price`, `Good`.`min_price_1`, `Good`.`max_price_1`, `Good`.`min_price_2`, `Good`.`max_price_2`, `Good`.`min_price_3`, `Good`.`max_price_3`, `Good`.`min_price_4`, `Good`.`max_price_4`, `Good`.`name`, `Good`.`adword`, `Good`.`image`, `Good`.`brand`, `Good`.`description`, `Good`.`auditreason`, `Good`.`isperiod`, `Good`.`period_1`, `Good`.`period_2`, `Good`.`isaudit`, `Good`.`isshow`, `Good`.`isdelete`, `Good`.`ismianyi`, `Good`.`isrecommend`, `Good`.`recommenddesc`, `Good`.`recommendpos`, `Good`.`nopass_number`, `Good`.`importedareas_id`, `Good`.`oldid`, `Good`.`created`, `Good`.`modified`, `Good`.`audittime`, `Good`.`client_id`, `Good`.`recommends_stores_new_id`, `Good`.`brand_id`, `Good`.`storage`, `Good`.`shelflife`, `Good`.`netweight`, `Good`.`packaging`, `Good`.`produc_id`, `Good`.`area`, `Good`.`product_date1`, `Good`.`product_date2`, `Good`.`from`, `Good`.`recommend_flag_order`, `Good`.`factory`, `Good`.`ishide`, `Good`.`totalweight`, `Good`.`goods_long`, `Good`.`goods_width`, `Good`.`goods_high`, `Good`.`goods_type`, `Good`.`taxrate`, `Good`.`goods_guarantee`, `Good`.`goods_guarantee_unit`, `Good`.`goods_code`, `Good`.`is_ladder` FROM `jmuv3`.`goods` AS `Good` left JOIN `jmuv3`.`goodsviews` AS `Goodsview` ON (`Goodsview`.`id` = `Good`.`id`) WHERE `Good`.`id` IN (67432, 55777, 133216) ORDER BY `Goodsview`.`order_volume` desc LIMIT 4332
98SELECT `Good`.`id` FROM `jmuv3`.`recommends_goods` AS `RecommendsGood` left JOIN `jmuv3`.`recommends` AS `Recommend` ON (`Recommend`.`id` = `RecommendsGood`.`recommend_id`) left JOIN `jmuv3`.`goods` AS `Good` ON (`Good`.`id` = `RecommendsGood`.`goods_id`) 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`) WHERE `Recommend`.`type` = 2 AND `Recommend`.`code` = 'market_category_goods' AND `RecommendsGood`.`category_id` IN (757, 758, 759, 760, 761, 762, 763, 764, 765, 766) AND `Store`.`isaudit` = 1 AND `Good`.`isaudit` = 1 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `User`.`is_delete` = 0 ORDER BY `RecommendsGood`.`sort_order` asc, `RecommendsGood`.`modified` desc LIMIT 1413132
99SELECT `Good`.`id`, `Good`.`name`, `Good`.`image` FROM `jmuv3`.`goods` AS `Good` WHERE `Good`.`id` IN (69184, 52059, 52048, 72903, 72851, 72881, 52076, 72791, 49072, 49040, 48986, 49155, 49078)13131
100SELECT `Spec`.`id`, `Spec`.`store_id`, `Spec`.`goods_id`, `Spec`.`stock`, `Spec`.`unit`, `Spec`.`price`, `Spec`.`range_price`, `Spec`.`spec_1`, `Spec`.`spec_2`, `Spec`.`value_1`, `Spec`.`value_2`, `Spec`.`price_1`, `Spec`.`price_2`, `Spec`.`price_3`, `Spec`.`price_4`, `Spec`.`reduce_1`, `Spec`.`reduce_2`, `Spec`.`reduce_3`, `Spec`.`reduce_4`, `Spec`.`discount_1`, `Spec`.`discount_2`, `Spec`.`discount_3`, `Spec`.`discount_4`, `Spec`.`sku`, `Spec`.`description`, `Spec`.`issetspec`, `Spec`.`oldgoodid`, `Spec`.`oldid`, `Spec`.`created`, `Spec`.`modified`, `Spec`.`article`, `Spec`.`integral` FROM `jmuv3`.`specs` AS `Spec` WHERE `Spec`.`goods_id` IN (69184, 52059, 52048, 72903, 72851, 72881, 52076, 72791, 49072, 49040, 48986, 49155, 49078) AND `issetspec` = 113131
101SELECT `Goodsview`.`id`, `Goodsview`.`goods_id`, `Goodsview`.`stock`, `Goodsview`.`crt_collection`, `Goodsview`.`his_collection`, `Goodsview`.`favorites_count_bak`, `Goodsview`.`order_count`, `Goodsview`.`order_volume`, `Goodsview`.`payed_volume`, `Goodsview`.`finish_volume`, `Goodsview`.`month_volume`, `Goodsview`.`week_volume`, `Goodsview`.`order_volume_week`, `Goodsview`.`payed_volume_week`, `Goodsview`.`finish_volume_week`, `Goodsview`.`comment_count`, `Goodsview`.`created`, `Goodsview`.`modified`, `Goodsview`.`store_id` FROM `jmuv3`.`goodsviews` AS `Goodsview` WHERE `Goodsview`.`goods_id` IN (69184, 52059, 52048, 72903, 72851, 72881, 52076, 72791, 49072, 49040, 48986, 49155, 49078)13131
102SELECT `Good`.`id`, `Good`.`sn`, `Good`.`seller_id`, `Good`.`store_id`, `Good`.`spec_id`, `Good`.`category_id`, `Good`.`category_name`, `Good`.`innercategory_id`, `Good`.`innercategory_name`, `Good`.`type`, `Good`.`least`, `Good`.`unit`, `Good`.`price`, `Good`.`min_price_1`, `Good`.`max_price_1`, `Good`.`min_price_2`, `Good`.`max_price_2`, `Good`.`min_price_3`, `Good`.`max_price_3`, `Good`.`min_price_4`, `Good`.`max_price_4`, `Good`.`name`, `Good`.`adword`, `Good`.`image`, `Good`.`brand`, `Good`.`description`, `Good`.`auditreason`, `Good`.`isperiod`, `Good`.`period_1`, `Good`.`period_2`, `Good`.`isaudit`, `Good`.`isshow`, `Good`.`isdelete`, `Good`.`ismianyi`, `Good`.`isrecommend`, `Good`.`recommenddesc`, `Good`.`recommendpos`, `Good`.`nopass_number`, `Good`.`importedareas_id`, `Good`.`oldid`, `Good`.`created`, `Good`.`modified`, `Good`.`audittime`, `Good`.`client_id`, `Good`.`recommends_stores_new_id`, `Good`.`brand_id`, `Good`.`storage`, `Good`.`shelflife`, `Good`.`netweight`, `Good`.`packaging`, `Good`.`produc_id`, `Good`.`area`, `Good`.`product_date1`, `Good`.`product_date2`, `Good`.`from`, `Good`.`recommend_flag_order`, `Good`.`factory`, `Good`.`ishide`, `Good`.`totalweight`, `Good`.`goods_long`, `Good`.`goods_width`, `Good`.`goods_high`, `Good`.`goods_type`, `Good`.`taxrate`, `Good`.`goods_guarantee`, `Good`.`goods_guarantee_unit`, `Good`.`goods_code`, `Good`.`is_ladder` FROM `jmuv3`.`goods` AS `Good` left JOIN `jmuv3`.`goodsviews` AS `Goodsview` ON (`Goodsview`.`id` = `Good`.`id`) WHERE `Good`.`id` IN (69184, 52059, 52048, 72903, 72851, 72881, 52076, 72791, 49072, 49040, 48986, 49155, 49078) ORDER BY `Goodsview`.`order_volume` desc LIMIT 4443
103SELECT `Good`.`id` FROM `jmuv3`.`recommends_goods` AS `RecommendsGood` left JOIN `jmuv3`.`recommends` AS `Recommend` ON (`Recommend`.`id` = `RecommendsGood`.`recommend_id`) left JOIN `jmuv3`.`goods` AS `Good` ON (`Good`.`id` = `RecommendsGood`.`goods_id`) 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`) WHERE `Recommend`.`type` = 2 AND `Recommend`.`code` = 'market_category_goods' AND `RecommendsGood`.`category_id` IN (583, 584, 585, 586, 587) AND `Store`.`isaudit` = 1 AND `Good`.`isaudit` = 1 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `User`.`is_delete` = 0 ORDER BY `RecommendsGood`.`sort_order` asc, `RecommendsGood`.`modified` desc LIMIT 14332
104SELECT `Good`.`id`, `Good`.`name`, `Good`.`image` FROM `jmuv3`.`goods` AS `Good` WHERE `Good`.`id` IN (69246, 68256, 47938)331
105SELECT `Spec`.`id`, `Spec`.`store_id`, `Spec`.`goods_id`, `Spec`.`stock`, `Spec`.`unit`, `Spec`.`price`, `Spec`.`range_price`, `Spec`.`spec_1`, `Spec`.`spec_2`, `Spec`.`value_1`, `Spec`.`value_2`, `Spec`.`price_1`, `Spec`.`price_2`, `Spec`.`price_3`, `Spec`.`price_4`, `Spec`.`reduce_1`, `Spec`.`reduce_2`, `Spec`.`reduce_3`, `Spec`.`reduce_4`, `Spec`.`discount_1`, `Spec`.`discount_2`, `Spec`.`discount_3`, `Spec`.`discount_4`, `Spec`.`sku`, `Spec`.`description`, `Spec`.`issetspec`, `Spec`.`oldgoodid`, `Spec`.`oldid`, `Spec`.`created`, `Spec`.`modified`, `Spec`.`article`, `Spec`.`integral` FROM `jmuv3`.`specs` AS `Spec` WHERE `Spec`.`goods_id` IN (69246, 68256, 47938) AND `issetspec` = 1331
106SELECT `Goodsview`.`id`, `Goodsview`.`goods_id`, `Goodsview`.`stock`, `Goodsview`.`crt_collection`, `Goodsview`.`his_collection`, `Goodsview`.`favorites_count_bak`, `Goodsview`.`order_count`, `Goodsview`.`order_volume`, `Goodsview`.`payed_volume`, `Goodsview`.`finish_volume`, `Goodsview`.`month_volume`, `Goodsview`.`week_volume`, `Goodsview`.`order_volume_week`, `Goodsview`.`payed_volume_week`, `Goodsview`.`finish_volume_week`, `Goodsview`.`comment_count`, `Goodsview`.`created`, `Goodsview`.`modified`, `Goodsview`.`store_id` FROM `jmuv3`.`goodsviews` AS `Goodsview` WHERE `Goodsview`.`goods_id` IN (69246, 68256, 47938)331
107SELECT `Good`.`id`, `Good`.`sn`, `Good`.`seller_id`, `Good`.`store_id`, `Good`.`spec_id`, `Good`.`category_id`, `Good`.`category_name`, `Good`.`innercategory_id`, `Good`.`innercategory_name`, `Good`.`type`, `Good`.`least`, `Good`.`unit`, `Good`.`price`, `Good`.`min_price_1`, `Good`.`max_price_1`, `Good`.`min_price_2`, `Good`.`max_price_2`, `Good`.`min_price_3`, `Good`.`max_price_3`, `Good`.`min_price_4`, `Good`.`max_price_4`, `Good`.`name`, `Good`.`adword`, `Good`.`image`, `Good`.`brand`, `Good`.`description`, `Good`.`auditreason`, `Good`.`isperiod`, `Good`.`period_1`, `Good`.`period_2`, `Good`.`isaudit`, `Good`.`isshow`, `Good`.`isdelete`, `Good`.`ismianyi`, `Good`.`isrecommend`, `Good`.`recommenddesc`, `Good`.`recommendpos`, `Good`.`nopass_number`, `Good`.`importedareas_id`, `Good`.`oldid`, `Good`.`created`, `Good`.`modified`, `Good`.`audittime`, `Good`.`client_id`, `Good`.`recommends_stores_new_id`, `Good`.`brand_id`, `Good`.`storage`, `Good`.`shelflife`, `Good`.`netweight`, `Good`.`packaging`, `Good`.`produc_id`, `Good`.`area`, `Good`.`product_date1`, `Good`.`product_date2`, `Good`.`from`, `Good`.`recommend_flag_order`, `Good`.`factory`, `Good`.`ishide`, `Good`.`totalweight`, `Good`.`goods_long`, `Good`.`goods_width`, `Good`.`goods_high`, `Good`.`goods_type`, `Good`.`taxrate`, `Good`.`goods_guarantee`, `Good`.`goods_guarantee_unit`, `Good`.`goods_code`, `Good`.`is_ladder` FROM `jmuv3`.`goods` AS `Good` left JOIN `jmuv3`.`goodsviews` AS `Goodsview` ON (`Goodsview`.`id` = `Good`.`id`) WHERE `Good`.`id` IN (69246, 68256, 47938) ORDER BY `Goodsview`.`order_volume` desc LIMIT 4332
108SELECT `Good`.`id` FROM `jmuv3`.`recommends_goods` AS `RecommendsGood` left JOIN `jmuv3`.`recommends` AS `Recommend` ON (`Recommend`.`id` = `RecommendsGood`.`recommend_id`) left JOIN `jmuv3`.`goods` AS `Good` ON (`Good`.`id` = `RecommendsGood`.`goods_id`) 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`) WHERE `Recommend`.`type` = 2 AND `Recommend`.`code` = 'market_category_goods' AND `RecommendsGood`.`category_id` IN (276, 277, 278, 279, 280, 281, 282) AND `Store`.`isaudit` = 1 AND `Good`.`isaudit` = 1 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `User`.`is_delete` = 0 ORDER BY `RecommendsGood`.`sort_order` asc, `RecommendsGood`.`modified` desc LIMIT 1410102
109SELECT `Good`.`id`, `Good`.`name`, `Good`.`image` FROM `jmuv3`.`goods` AS `Good` WHERE `Good`.`id` IN (71888, 68367, 71062, 71071, 71130, 72003, 57622, 36057, 57687, 57643)10101
110SELECT `Spec`.`id`, `Spec`.`store_id`, `Spec`.`goods_id`, `Spec`.`stock`, `Spec`.`unit`, `Spec`.`price`, `Spec`.`range_price`, `Spec`.`spec_1`, `Spec`.`spec_2`, `Spec`.`value_1`, `Spec`.`value_2`, `Spec`.`price_1`, `Spec`.`price_2`, `Spec`.`price_3`, `Spec`.`price_4`, `Spec`.`reduce_1`, `Spec`.`reduce_2`, `Spec`.`reduce_3`, `Spec`.`reduce_4`, `Spec`.`discount_1`, `Spec`.`discount_2`, `Spec`.`discount_3`, `Spec`.`discount_4`, `Spec`.`sku`, `Spec`.`description`, `Spec`.`issetspec`, `Spec`.`oldgoodid`, `Spec`.`oldid`, `Spec`.`created`, `Spec`.`modified`, `Spec`.`article`, `Spec`.`integral` FROM `jmuv3`.`specs` AS `Spec` WHERE `Spec`.`goods_id` IN (71888, 68367, 71062, 71071, 71130, 72003, 57622, 36057, 57687, 57643) AND `issetspec` = 110101
111SELECT `Goodsview`.`id`, `Goodsview`.`goods_id`, `Goodsview`.`stock`, `Goodsview`.`crt_collection`, `Goodsview`.`his_collection`, `Goodsview`.`favorites_count_bak`, `Goodsview`.`order_count`, `Goodsview`.`order_volume`, `Goodsview`.`payed_volume`, `Goodsview`.`finish_volume`, `Goodsview`.`month_volume`, `Goodsview`.`week_volume`, `Goodsview`.`order_volume_week`, `Goodsview`.`payed_volume_week`, `Goodsview`.`finish_volume_week`, `Goodsview`.`comment_count`, `Goodsview`.`created`, `Goodsview`.`modified`, `Goodsview`.`store_id` FROM `jmuv3`.`goodsviews` AS `Goodsview` WHERE `Goodsview`.`goods_id` IN (71888, 68367, 71062, 71071, 71130, 72003, 57622, 36057, 57687, 57643)10101
112SELECT `Good`.`id`, `Good`.`sn`, `Good`.`seller_id`, `Good`.`store_id`, `Good`.`spec_id`, `Good`.`category_id`, `Good`.`category_name`, `Good`.`innercategory_id`, `Good`.`innercategory_name`, `Good`.`type`, `Good`.`least`, `Good`.`unit`, `Good`.`price`, `Good`.`min_price_1`, `Good`.`max_price_1`, `Good`.`min_price_2`, `Good`.`max_price_2`, `Good`.`min_price_3`, `Good`.`max_price_3`, `Good`.`min_price_4`, `Good`.`max_price_4`, `Good`.`name`, `Good`.`adword`, `Good`.`image`, `Good`.`brand`, `Good`.`description`, `Good`.`auditreason`, `Good`.`isperiod`, `Good`.`period_1`, `Good`.`period_2`, `Good`.`isaudit`, `Good`.`isshow`, `Good`.`isdelete`, `Good`.`ismianyi`, `Good`.`isrecommend`, `Good`.`recommenddesc`, `Good`.`recommendpos`, `Good`.`nopass_number`, `Good`.`importedareas_id`, `Good`.`oldid`, `Good`.`created`, `Good`.`modified`, `Good`.`audittime`, `Good`.`client_id`, `Good`.`recommends_stores_new_id`, `Good`.`brand_id`, `Good`.`storage`, `Good`.`shelflife`, `Good`.`netweight`, `Good`.`packaging`, `Good`.`produc_id`, `Good`.`area`, `Good`.`product_date1`, `Good`.`product_date2`, `Good`.`from`, `Good`.`recommend_flag_order`, `Good`.`factory`, `Good`.`ishide`, `Good`.`totalweight`, `Good`.`goods_long`, `Good`.`goods_width`, `Good`.`goods_high`, `Good`.`goods_type`, `Good`.`taxrate`, `Good`.`goods_guarantee`, `Good`.`goods_guarantee_unit`, `Good`.`goods_code`, `Good`.`is_ladder` FROM `jmuv3`.`goods` AS `Good` left JOIN `jmuv3`.`goodsviews` AS `Goodsview` ON (`Goodsview`.`id` = `Good`.`id`) WHERE `Good`.`id` IN (71888, 68367, 71062, 71071, 71130, 72003, 57622, 36057, 57687, 57643) ORDER BY `Goodsview`.`order_volume` desc LIMIT 4443

用户登录

×

商品价格仅对会员开放

15天内免登录

忘记密码? 立即注册