今日最大牌

每天都要新惊喜
  • 晨光山珍特级野生原木黑木耳

    3人收藏

  • 雏牧香冻猪带肉脊骨

    2人收藏

  • 北京辰森餐饮管理系统/餐饮系统/快餐管理系统/中餐管理系统/餐饮后台系统

    1人收藏

  • 0人收藏

  • 悠格食品级保鲜食品级保鲜盒冰箱储藏盒衣物收纳箱密封整理箱 5件套

    3人收藏

  • 太太乐蒜蓉辣椒酱 1kg/袋

    3人收藏

  • 爱森 猪腰

    0人收藏

  • 盐水鸭

    1人收藏

  • 雪龙黑牛   眼肉XL-3A

    1人收藏

  • 光明米业苏北大米

    0人收藏

(default) 102 queries took 134 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 `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` = 5111
6select store.id,store.logo,view.favorites_count from recommends_stores recommendsStores left join recommends r on r.id = recommendsStores.recommend_id left join stores store on store.id= recommendsStores.store_id left join sellers seller on seller.id=store.seller_id left join users user on user.id=seller.user_id left join storeviews view on view.store_id=store.id where user.is_delete=0 and store.isaudit = 1 and r.code='day_brand' order by recommendsStores.sort , recommendsStores.modified limit 1010102
7SELECT `Good`.`id` FROM `jmuv3`.`goods` AS `Good` WHERE `Good`.`store_id` = 48 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `isdelete` = 0 ORDER BY `created` desc10101
8SELECT `RecommendsGood`.`id`, `RecommendsGood`.`goods_id`, `RecommendsGood`.`sort_order`, `RecommendsGood`.`recommend_id`, `RecommendsGood`.`category_id`, `RecommendsGood`.`start`, `RecommendsGood`.`end`, `RecommendsGood`.`created`, `RecommendsGood`.`modified`, `RecommendsGood`.`image` FROM `jmuv3`.`recommends_goods` AS `RecommendsGood` WHERE `goods_id` IN (1531, 1518, 1517, 1516, 1515, 1512, 1504, 1503, 1201, 193) AND `recommend_id` = 24 ORDER BY `RecommendsGood`.`sort_order` ASC, `RecommendsGood`.`modified` ASC LIMIT 1002
9SELECT `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` WHERE `Good`.`store_id` = 48 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `isdelete` = 0 ORDER BY `created` desc LIMIT 1112
10SELECT `Good`.`id` FROM `jmuv3`.`goods` AS `Good` WHERE `Good`.`store_id` = 28438 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `isdelete` = 0 ORDER BY `created` desc26261
11SELECT `RecommendsGood`.`id`, `RecommendsGood`.`goods_id`, `RecommendsGood`.`sort_order`, `RecommendsGood`.`recommend_id`, `RecommendsGood`.`category_id`, `RecommendsGood`.`start`, `RecommendsGood`.`end`, `RecommendsGood`.`created`, `RecommendsGood`.`modified`, `RecommendsGood`.`image` FROM `jmuv3`.`recommends_goods` AS `RecommendsGood` WHERE `goods_id` IN (146351, 146350, 146349, 146299, 146298, 71898, 71939, 71927, 71920, 71885, 70735, 69293, 69917, 70482, 70475, 70466, 70462, 70387, 18471, 70450, 70444, 70437, 70434, 68623, 70293, 70282) AND `recommend_id` = 24 ORDER BY `RecommendsGood`.`sort_order` ASC, `RecommendsGood`.`modified` ASC LIMIT 1002
12SELECT `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` WHERE `Good`.`store_id` = 28438 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `isdelete` = 0 ORDER BY `created` desc LIMIT 1112
13SELECT `Good`.`id` FROM `jmuv3`.`goods` AS `Good` WHERE `Good`.`store_id` = 16 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `isdelete` = 0 ORDER BY `created` desc331
14SELECT `RecommendsGood`.`id`, `RecommendsGood`.`goods_id`, `RecommendsGood`.`sort_order`, `RecommendsGood`.`recommend_id`, `RecommendsGood`.`category_id`, `RecommendsGood`.`start`, `RecommendsGood`.`end`, `RecommendsGood`.`created`, `RecommendsGood`.`modified`, `RecommendsGood`.`image` FROM `jmuv3`.`recommends_goods` AS `RecommendsGood` WHERE `goods_id` IN (483, 1012, 199) AND `recommend_id` = 24 ORDER BY `RecommendsGood`.`sort_order` ASC, `RecommendsGood`.`modified` ASC LIMIT 1002
15SELECT `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` WHERE `Good`.`store_id` = 16 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `isdelete` = 0 ORDER BY `created` desc LIMIT 1112
16SELECT `Good`.`id` FROM `jmuv3`.`goods` AS `Good` WHERE `Good`.`store_id` = 28448 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `isdelete` = 0 ORDER BY `created` desc002
17SELECT `RecommendsGood`.`id`, `RecommendsGood`.`goods_id`, `RecommendsGood`.`sort_order`, `RecommendsGood`.`recommend_id`, `RecommendsGood`.`category_id`, `RecommendsGood`.`start`, `RecommendsGood`.`end`, `RecommendsGood`.`created`, `RecommendsGood`.`modified`, `RecommendsGood`.`image` FROM `jmuv3`.`recommends_goods` AS `RecommendsGood` WHERE `goods_id` IS NULL AND `recommend_id` = 24 ORDER BY `RecommendsGood`.`sort_order` ASC, `RecommendsGood`.`modified` ASC LIMIT 1002
18SELECT `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` WHERE `Good`.`store_id` = 28448 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `isdelete` = 0 ORDER BY `created` desc LIMIT 1002
19SELECT `Good`.`id` FROM `jmuv3`.`goods` AS `Good` WHERE `Good`.`store_id` = 3 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `isdelete` = 0 ORDER BY `created` desc49491
20SELECT `RecommendsGood`.`id`, `RecommendsGood`.`goods_id`, `RecommendsGood`.`sort_order`, `RecommendsGood`.`recommend_id`, `RecommendsGood`.`category_id`, `RecommendsGood`.`start`, `RecommendsGood`.`end`, `RecommendsGood`.`created`, `RecommendsGood`.`modified`, `RecommendsGood`.`image` FROM `jmuv3`.`recommends_goods` AS `RecommendsGood` WHERE `goods_id` IN (132690, 132671, 132666, 1016, 999, 586, 587, 588, 584, 583, 582, 581, 580, 579, 578, 577, 576, 575, 574, 573, 565, 564, 563, 561, 562, 560, 559, 558, 556, 555, 554, 553, 552, 545, 544, 334, 80, 86, 158, 131, 105, 104, 101, 98, 93, 91, 56, 59, 53) AND `recommend_id` = 24 ORDER BY `RecommendsGood`.`sort_order` ASC, `RecommendsGood`.`modified` ASC LIMIT 1002
21SELECT `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` WHERE `Good`.`store_id` = 3 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `isdelete` = 0 ORDER BY `created` desc LIMIT 1112
22SELECT `Good`.`id` FROM `jmuv3`.`goods` AS `Good` WHERE `Good`.`store_id` = 6909 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `isdelete` = 0 ORDER BY `created` desc20201
23SELECT `RecommendsGood`.`id`, `RecommendsGood`.`goods_id`, `RecommendsGood`.`sort_order`, `RecommendsGood`.`recommend_id`, `RecommendsGood`.`category_id`, `RecommendsGood`.`start`, `RecommendsGood`.`end`, `RecommendsGood`.`created`, `RecommendsGood`.`modified`, `RecommendsGood`.`image` FROM `jmuv3`.`recommends_goods` AS `RecommendsGood` WHERE `goods_id` IN (167465, 167464, 167461, 143343, 133254, 133253, 133252, 133246, 133243, 133239, 133238, 133208, 133202, 133190, 133177, 133172, 133169, 133152, 133148, 133141) AND `recommend_id` = 24 ORDER BY `RecommendsGood`.`sort_order` ASC, `RecommendsGood`.`modified` ASC LIMIT 1002
24SELECT `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` WHERE `Good`.`store_id` = 6909 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `isdelete` = 0 ORDER BY `created` desc LIMIT 1112
25SELECT `Good`.`id` FROM `jmuv3`.`goods` AS `Good` WHERE `Good`.`store_id` = 28451 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `isdelete` = 0 ORDER BY `created` desc19191
26SELECT `RecommendsGood`.`id`, `RecommendsGood`.`goods_id`, `RecommendsGood`.`sort_order`, `RecommendsGood`.`recommend_id`, `RecommendsGood`.`category_id`, `RecommendsGood`.`start`, `RecommendsGood`.`end`, `RecommendsGood`.`created`, `RecommendsGood`.`modified`, `RecommendsGood`.`image` FROM `jmuv3`.`recommends_goods` AS `RecommendsGood` WHERE `goods_id` IN (146355, 146354, 146353, 146352, 146348, 146347, 146346, 146345, 136088, 136086, 136083, 135772, 135769, 135768, 135766, 135743, 135723, 132625, 132623) AND `recommend_id` = 24 ORDER BY `RecommendsGood`.`sort_order` ASC, `RecommendsGood`.`modified` ASC LIMIT 1002
27SELECT `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` WHERE `Good`.`store_id` = 28451 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `isdelete` = 0 ORDER BY `created` desc LIMIT 1112
28SELECT `Good`.`id` FROM `jmuv3`.`goods` AS `Good` WHERE `Good`.`store_id` = 28646 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `isdelete` = 0 ORDER BY `created` desc12121
29SELECT `RecommendsGood`.`id`, `RecommendsGood`.`goods_id`, `RecommendsGood`.`sort_order`, `RecommendsGood`.`recommend_id`, `RecommendsGood`.`category_id`, `RecommendsGood`.`start`, `RecommendsGood`.`end`, `RecommendsGood`.`created`, `RecommendsGood`.`modified`, `RecommendsGood`.`image` FROM `jmuv3`.`recommends_goods` AS `RecommendsGood` WHERE `goods_id` IN (178785, 152936, 152935, 152933, 152931, 152930, 140583, 140560, 140305, 140279, 139866, 139854) AND `recommend_id` = 24 ORDER BY `RecommendsGood`.`sort_order` ASC, `RecommendsGood`.`modified` ASC LIMIT 1002
30SELECT `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` WHERE `Good`.`store_id` = 28646 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `isdelete` = 0 ORDER BY `created` desc LIMIT 1112
31SELECT `Good`.`id` FROM `jmuv3`.`goods` AS `Good` WHERE `Good`.`store_id` = 28685 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `isdelete` = 0 ORDER BY `created` desc10101
32SELECT `RecommendsGood`.`id`, `RecommendsGood`.`goods_id`, `RecommendsGood`.`sort_order`, `RecommendsGood`.`recommend_id`, `RecommendsGood`.`category_id`, `RecommendsGood`.`start`, `RecommendsGood`.`end`, `RecommendsGood`.`created`, `RecommendsGood`.`modified`, `RecommendsGood`.`image` FROM `jmuv3`.`recommends_goods` AS `RecommendsGood` WHERE `goods_id` IN (145885, 145884, 145883, 145882, 145881, 143367, 143366, 143364, 143363, 143360) AND `recommend_id` = 24 ORDER BY `RecommendsGood`.`sort_order` ASC, `RecommendsGood`.`modified` ASC LIMIT 1002
33SELECT `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` WHERE `Good`.`store_id` = 28685 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `isdelete` = 0 ORDER BY `created` desc LIMIT 1112
34SELECT `Good`.`id` FROM `jmuv3`.`goods` AS `Good` WHERE `Good`.`store_id` = 28615 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `isdelete` = 0 ORDER BY `created` desc111
35SELECT `RecommendsGood`.`id`, `RecommendsGood`.`goods_id`, `RecommendsGood`.`sort_order`, `RecommendsGood`.`recommend_id`, `RecommendsGood`.`category_id`, `RecommendsGood`.`start`, `RecommendsGood`.`end`, `RecommendsGood`.`created`, `RecommendsGood`.`modified`, `RecommendsGood`.`image` FROM `jmuv3`.`recommends_goods` AS `RecommendsGood` WHERE goods_id = (133335) AND `recommend_id` = 24 ORDER BY `RecommendsGood`.`sort_order` ASC, `RecommendsGood`.`modified` ASC LIMIT 1002
36SELECT `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` WHERE `Good`.`store_id` = 28615 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `isdelete` = 0 ORDER BY `created` desc LIMIT 1111
37SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id` FROM `jmuv3`.`categories` AS `Category` WHERE `Category`.`parent_id` IS NULL ORDER BY FIELD(`Category`.`name`, '食材','粮油调料','酒水饮料','综合用品','厨房用具','专业设备','办公用品','家具','信息化系统','基建装潢') ASC LIMIT 1010102
38SELECT Store.id,Store.logo FROM `jmuv3`.`recommends_stores` AS `RecommendsStore` left JOIN `jmuv3`.`recommends` AS `Recommend` ON (`Recommend`.`id` = `RecommendsStore`.`recommend_id`) left JOIN `jmuv3`.`stores` AS `Store` ON (`Store`.`id` = `RecommendsStore`.`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` = 1 AND `Recommend`.`code` = 'brand_category_stores' AND `RecommendsStore`.`category_id` = 7 AND `Store`.`isaudit` = 1 AND `User`.`is_delete` = 0 ORDER BY `RecommendsStore`.`sort` ASC, `RecommendsStore`.`modified` ASC LIMIT 1616161
39SELECT `Storeview`.`store_id`, `Storeview`.`favorites_count`, `Storeview`.`created`, `Storeview`.`modified` FROM `jmuv3`.`storeviews` AS `Storeview` WHERE `Storeview`.`store_id` = 84 LIMIT 1110
40SELECT `Good`.`id` FROM `jmuv3`.`goods` AS `Good` WHERE `Good`.`store_id` = 84 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `Good`.`isdelete` = 017171
41SELECT `RecommendsGood`.`id`, `RecommendsGood`.`goods_id`, `RecommendsGood`.`sort_order`, `RecommendsGood`.`recommend_id`, `RecommendsGood`.`category_id`, `RecommendsGood`.`start`, `RecommendsGood`.`end`, `RecommendsGood`.`created`, `RecommendsGood`.`modified`, `RecommendsGood`.`image` FROM `jmuv3`.`recommends_goods` AS `RecommendsGood` WHERE `goods_id` IN (1475, 1545, 1568, 1614, 1618, 1619, 1620, 1621, 1622, 1648, 1690, 1694, 1724, 1727, 1728, 1730, 1737) AND `recommend_id` = 25 ORDER BY `RecommendsGood`.`sort_order` ASC, `RecommendsGood`.`modified` ASC LIMIT 1002
42SELECT `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` WHERE `Good`.`store_id` = 84 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `Good`.`isdelete` = 0 ORDER BY `Good`.`id` ASC LIMIT 1112
43SELECT `Storeview`.`store_id`, `Storeview`.`favorites_count`, `Storeview`.`created`, `Storeview`.`modified` FROM `jmuv3`.`storeviews` AS `Storeview` WHERE `Storeview`.`store_id` = 13 LIMIT 1110
44SELECT `Good`.`id` FROM `jmuv3`.`goods` AS `Good` WHERE `Good`.`store_id` = 13 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `Good`.`isdelete` = 016161
45SELECT `RecommendsGood`.`id`, `RecommendsGood`.`goods_id`, `RecommendsGood`.`sort_order`, `RecommendsGood`.`recommend_id`, `RecommendsGood`.`category_id`, `RecommendsGood`.`start`, `RecommendsGood`.`end`, `RecommendsGood`.`created`, `RecommendsGood`.`modified`, `RecommendsGood`.`image` FROM `jmuv3`.`recommends_goods` AS `RecommendsGood` WHERE `goods_id` IN (1442, 1450, 1454, 1455, 1456, 1458, 1459, 1460, 1461, 1466, 1506, 1507, 1508, 1509, 1510, 154109) AND `recommend_id` = 25 ORDER BY `RecommendsGood`.`sort_order` ASC, `RecommendsGood`.`modified` ASC LIMIT 1002
46SELECT `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` WHERE `Good`.`store_id` = 13 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `Good`.`isdelete` = 0 ORDER BY `Good`.`id` ASC LIMIT 1111
47SELECT `Storeview`.`store_id`, `Storeview`.`favorites_count`, `Storeview`.`created`, `Storeview`.`modified` FROM `jmuv3`.`storeviews` AS `Storeview` WHERE `Storeview`.`store_id` = 22307 LIMIT 1000
48SELECT `Good`.`id` FROM `jmuv3`.`goods` AS `Good` WHERE `Good`.`store_id` = 22307 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `Good`.`isdelete` = 021211
49SELECT `RecommendsGood`.`id`, `RecommendsGood`.`goods_id`, `RecommendsGood`.`sort_order`, `RecommendsGood`.`recommend_id`, `RecommendsGood`.`category_id`, `RecommendsGood`.`start`, `RecommendsGood`.`end`, `RecommendsGood`.`created`, `RecommendsGood`.`modified`, `RecommendsGood`.`image` FROM `jmuv3`.`recommends_goods` AS `RecommendsGood` WHERE `goods_id` IN (6230, 6244, 6811, 6817, 6820, 6825, 6829, 6838, 6904, 6905, 6906, 6907, 6909, 6910, 6911, 6913, 6914, 6917, 6918, 6919, 54799) AND `recommend_id` = 25 ORDER BY `RecommendsGood`.`sort_order` ASC, `RecommendsGood`.`modified` ASC LIMIT 1002
50SELECT `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` WHERE `Good`.`store_id` = 22307 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `Good`.`isdelete` = 0 ORDER BY `Good`.`id` ASC LIMIT 1111
51SELECT `Storeview`.`store_id`, `Storeview`.`favorites_count`, `Storeview`.`created`, `Storeview`.`modified` FROM `jmuv3`.`storeviews` AS `Storeview` WHERE `Storeview`.`store_id` = 20572 LIMIT 1000
52SELECT `Good`.`id` FROM `jmuv3`.`goods` AS `Good` WHERE `Good`.`store_id` = 20572 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `Good`.`isdelete` = 021211
53SELECT `RecommendsGood`.`id`, `RecommendsGood`.`goods_id`, `RecommendsGood`.`sort_order`, `RecommendsGood`.`recommend_id`, `RecommendsGood`.`category_id`, `RecommendsGood`.`start`, `RecommendsGood`.`end`, `RecommendsGood`.`created`, `RecommendsGood`.`modified`, `RecommendsGood`.`image` FROM `jmuv3`.`recommends_goods` AS `RecommendsGood` WHERE `goods_id` IN (9942, 16540, 22933, 23198, 24903, 26308, 30875, 30909, 31002, 31211, 31226, 31236, 31311, 31344, 31357, 31373, 31414, 31535, 31827, 31836, 31856) AND `recommend_id` = 25 ORDER BY `RecommendsGood`.`sort_order` ASC, `RecommendsGood`.`modified` ASC LIMIT 1002
54SELECT `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` WHERE `Good`.`store_id` = 20572 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `Good`.`isdelete` = 0 ORDER BY `Good`.`id` ASC LIMIT 1111
55SELECT `Storeview`.`store_id`, `Storeview`.`favorites_count`, `Storeview`.`created`, `Storeview`.`modified` FROM `jmuv3`.`storeviews` AS `Storeview` WHERE `Storeview`.`store_id` = 21071 LIMIT 1000
56SELECT `Good`.`id` FROM `jmuv3`.`goods` AS `Good` WHERE `Good`.`store_id` = 21071 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `Good`.`isdelete` = 021211
57SELECT `RecommendsGood`.`id`, `RecommendsGood`.`goods_id`, `RecommendsGood`.`sort_order`, `RecommendsGood`.`recommend_id`, `RecommendsGood`.`category_id`, `RecommendsGood`.`start`, `RecommendsGood`.`end`, `RecommendsGood`.`created`, `RecommendsGood`.`modified`, `RecommendsGood`.`image` FROM `jmuv3`.`recommends_goods` AS `RecommendsGood` WHERE `goods_id` IN (6737, 19911, 25134, 26969, 28577, 28639, 29220, 35151, 49170, 49171, 49172, 49173, 49174, 49175, 49176, 49177, 49180, 49181, 49182, 49183, 49184) AND `recommend_id` = 25 ORDER BY `RecommendsGood`.`sort_order` ASC, `RecommendsGood`.`modified` ASC LIMIT 1002
58SELECT `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` WHERE `Good`.`store_id` = 21071 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `Good`.`isdelete` = 0 ORDER BY `Good`.`id` ASC LIMIT 1111
59SELECT `Storeview`.`store_id`, `Storeview`.`favorites_count`, `Storeview`.`created`, `Storeview`.`modified` FROM `jmuv3`.`storeviews` AS `Storeview` WHERE `Storeview`.`store_id` = 1190 LIMIT 1110
60SELECT `Good`.`id` FROM `jmuv3`.`goods` AS `Good` WHERE `Good`.`store_id` = 1190 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `Good`.`isdelete` = 0001
61SELECT `RecommendsGood`.`id`, `RecommendsGood`.`goods_id`, `RecommendsGood`.`sort_order`, `RecommendsGood`.`recommend_id`, `RecommendsGood`.`category_id`, `RecommendsGood`.`start`, `RecommendsGood`.`end`, `RecommendsGood`.`created`, `RecommendsGood`.`modified`, `RecommendsGood`.`image` FROM `jmuv3`.`recommends_goods` AS `RecommendsGood` WHERE `goods_id` IS NULL AND `recommend_id` = 25 ORDER BY `RecommendsGood`.`sort_order` ASC, `RecommendsGood`.`modified` ASC LIMIT 1002
62SELECT `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` WHERE `Good`.`store_id` = 1190 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `Good`.`isdelete` = 0 ORDER BY `Good`.`id` ASC LIMIT 1002
63SELECT `Storeview`.`store_id`, `Storeview`.`favorites_count`, `Storeview`.`created`, `Storeview`.`modified` FROM `jmuv3`.`storeviews` AS `Storeview` WHERE `Storeview`.`store_id` = 11363 LIMIT 1110
64SELECT `Good`.`id` FROM `jmuv3`.`goods` AS `Good` WHERE `Good`.`store_id` = 11363 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `Good`.`isdelete` = 0661
65SELECT `RecommendsGood`.`id`, `RecommendsGood`.`goods_id`, `RecommendsGood`.`sort_order`, `RecommendsGood`.`recommend_id`, `RecommendsGood`.`category_id`, `RecommendsGood`.`start`, `RecommendsGood`.`end`, `RecommendsGood`.`created`, `RecommendsGood`.`modified`, `RecommendsGood`.`image` FROM `jmuv3`.`recommends_goods` AS `RecommendsGood` WHERE `goods_id` IN (39551, 69348, 69376, 69420, 69462, 69721) AND `recommend_id` = 25 ORDER BY `RecommendsGood`.`sort_order` ASC, `RecommendsGood`.`modified` ASC LIMIT 1002
66SELECT `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` WHERE `Good`.`store_id` = 11363 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `Good`.`isdelete` = 0 ORDER BY `Good`.`id` ASC LIMIT 1111
67SELECT `Storeview`.`store_id`, `Storeview`.`favorites_count`, `Storeview`.`created`, `Storeview`.`modified` FROM `jmuv3`.`storeviews` AS `Storeview` WHERE `Storeview`.`store_id` = 22461 LIMIT 1110
68SELECT `Good`.`id` FROM `jmuv3`.`goods` AS `Good` WHERE `Good`.`store_id` = 22461 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `Good`.`isdelete` = 0331
69SELECT `RecommendsGood`.`id`, `RecommendsGood`.`goods_id`, `RecommendsGood`.`sort_order`, `RecommendsGood`.`recommend_id`, `RecommendsGood`.`category_id`, `RecommendsGood`.`start`, `RecommendsGood`.`end`, `RecommendsGood`.`created`, `RecommendsGood`.`modified`, `RecommendsGood`.`image` FROM `jmuv3`.`recommends_goods` AS `RecommendsGood` WHERE `goods_id` IN (132390, 132711, 133530) AND `recommend_id` = 25 ORDER BY `RecommendsGood`.`sort_order` ASC, `RecommendsGood`.`modified` ASC LIMIT 1002
70SELECT `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` WHERE `Good`.`store_id` = 22461 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `Good`.`isdelete` = 0 ORDER BY `Good`.`id` ASC LIMIT 1112
71SELECT `Storeview`.`store_id`, `Storeview`.`favorites_count`, `Storeview`.`created`, `Storeview`.`modified` FROM `jmuv3`.`storeviews` AS `Storeview` WHERE `Storeview`.`store_id` = 11372 LIMIT 1110
72SELECT `Good`.`id` FROM `jmuv3`.`goods` AS `Good` WHERE `Good`.`store_id` = 11372 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `Good`.`isdelete` = 0661
73SELECT `RecommendsGood`.`id`, `RecommendsGood`.`goods_id`, `RecommendsGood`.`sort_order`, `RecommendsGood`.`recommend_id`, `RecommendsGood`.`category_id`, `RecommendsGood`.`start`, `RecommendsGood`.`end`, `RecommendsGood`.`created`, `RecommendsGood`.`modified`, `RecommendsGood`.`image` FROM `jmuv3`.`recommends_goods` AS `RecommendsGood` WHERE `goods_id` IN (65779, 67092, 69622, 69641, 133894, 133898) AND `recommend_id` = 25 ORDER BY `RecommendsGood`.`sort_order` ASC, `RecommendsGood`.`modified` ASC LIMIT 1002
74SELECT `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` WHERE `Good`.`store_id` = 11372 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `Good`.`isdelete` = 0 ORDER BY `Good`.`id` ASC LIMIT 1111
75SELECT `Storeview`.`store_id`, `Storeview`.`favorites_count`, `Storeview`.`created`, `Storeview`.`modified` FROM `jmuv3`.`storeviews` AS `Storeview` WHERE `Storeview`.`store_id` = 28442 LIMIT 1000
76SELECT `Good`.`id` FROM `jmuv3`.`goods` AS `Good` WHERE `Good`.`store_id` = 28442 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `Good`.`isdelete` = 0331
77SELECT `RecommendsGood`.`id`, `RecommendsGood`.`goods_id`, `RecommendsGood`.`sort_order`, `RecommendsGood`.`recommend_id`, `RecommendsGood`.`category_id`, `RecommendsGood`.`start`, `RecommendsGood`.`end`, `RecommendsGood`.`created`, `RecommendsGood`.`modified`, `RecommendsGood`.`image` FROM `jmuv3`.`recommends_goods` AS `RecommendsGood` WHERE `goods_id` IN (133393, 160054, 160056) AND `recommend_id` = 25 ORDER BY `RecommendsGood`.`sort_order` ASC, `RecommendsGood`.`modified` ASC LIMIT 1002
78SELECT `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` WHERE `Good`.`store_id` = 28442 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `Good`.`isdelete` = 0 ORDER BY `Good`.`id` ASC LIMIT 1111
79SELECT `Storeview`.`store_id`, `Storeview`.`favorites_count`, `Storeview`.`created`, `Storeview`.`modified` FROM `jmuv3`.`storeviews` AS `Storeview` WHERE `Storeview`.`store_id` = 28447 LIMIT 1110
80SELECT `Good`.`id` FROM `jmuv3`.`goods` AS `Good` WHERE `Good`.`store_id` = 28447 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `Good`.`isdelete` = 0551
81SELECT `RecommendsGood`.`id`, `RecommendsGood`.`goods_id`, `RecommendsGood`.`sort_order`, `RecommendsGood`.`recommend_id`, `RecommendsGood`.`category_id`, `RecommendsGood`.`start`, `RecommendsGood`.`end`, `RecommendsGood`.`created`, `RecommendsGood`.`modified`, `RecommendsGood`.`image` FROM `jmuv3`.`recommends_goods` AS `RecommendsGood` WHERE `goods_id` IN (132244, 132261, 132395, 132396, 133444) AND `recommend_id` = 25 ORDER BY `RecommendsGood`.`sort_order` ASC, `RecommendsGood`.`modified` ASC LIMIT 1002
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` WHERE `Good`.`store_id` = 28447 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `Good`.`isdelete` = 0 ORDER BY `Good`.`id` ASC LIMIT 1111
83SELECT `Storeview`.`store_id`, `Storeview`.`favorites_count`, `Storeview`.`created`, `Storeview`.`modified` FROM `jmuv3`.`storeviews` AS `Storeview` WHERE `Storeview`.`store_id` = 10168 LIMIT 1110
84SELECT `Good`.`id` FROM `jmuv3`.`goods` AS `Good` WHERE `Good`.`store_id` = 10168 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `Good`.`isdelete` = 029291
85SELECT `RecommendsGood`.`id`, `RecommendsGood`.`goods_id`, `RecommendsGood`.`sort_order`, `RecommendsGood`.`recommend_id`, `RecommendsGood`.`category_id`, `RecommendsGood`.`start`, `RecommendsGood`.`end`, `RecommendsGood`.`created`, `RecommendsGood`.`modified`, `RecommendsGood`.`image` FROM `jmuv3`.`recommends_goods` AS `RecommendsGood` WHERE `goods_id` IN (2813, 3301, 6565, 6679, 6726, 7769, 8254, 9420, 9481, 10862, 10889, 10912, 11003, 11018, 11086, 11087, 11580, 11588, 11593, 11594, 11605, 11624, 11655, 11688, 12400, 12403, 12408, 12426, 12555) AND `recommend_id` = 25 ORDER BY `RecommendsGood`.`sort_order` ASC, `RecommendsGood`.`modified` ASC LIMIT 1002
86SELECT `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` WHERE `Good`.`store_id` = 10168 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `Good`.`isdelete` = 0 ORDER BY `Good`.`id` ASC LIMIT 1111
87SELECT `Storeview`.`store_id`, `Storeview`.`favorites_count`, `Storeview`.`created`, `Storeview`.`modified` FROM `jmuv3`.`storeviews` AS `Storeview` WHERE `Storeview`.`store_id` = 9841 LIMIT 1110
88SELECT `Good`.`id` FROM `jmuv3`.`goods` AS `Good` WHERE `Good`.`store_id` = 9841 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `Good`.`isdelete` = 0221
89SELECT `RecommendsGood`.`id`, `RecommendsGood`.`goods_id`, `RecommendsGood`.`sort_order`, `RecommendsGood`.`recommend_id`, `RecommendsGood`.`category_id`, `RecommendsGood`.`start`, `RecommendsGood`.`end`, `RecommendsGood`.`created`, `RecommendsGood`.`modified`, `RecommendsGood`.`image` FROM `jmuv3`.`recommends_goods` AS `RecommendsGood` WHERE `goods_id` IN (68815, 70197) AND `recommend_id` = 25 ORDER BY `RecommendsGood`.`sort_order` ASC, `RecommendsGood`.`modified` ASC LIMIT 1002
90SELECT `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` WHERE `Good`.`store_id` = 9841 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `Good`.`isdelete` = 0 ORDER BY `Good`.`id` ASC LIMIT 1112
91SELECT `Storeview`.`store_id`, `Storeview`.`favorites_count`, `Storeview`.`created`, `Storeview`.`modified` FROM `jmuv3`.`storeviews` AS `Storeview` WHERE `Storeview`.`store_id` = 17506 LIMIT 1110
92SELECT `Good`.`id` FROM `jmuv3`.`goods` AS `Good` WHERE `Good`.`store_id` = 17506 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `Good`.`isdelete` = 0551
93SELECT `RecommendsGood`.`id`, `RecommendsGood`.`goods_id`, `RecommendsGood`.`sort_order`, `RecommendsGood`.`recommend_id`, `RecommendsGood`.`category_id`, `RecommendsGood`.`start`, `RecommendsGood`.`end`, `RecommendsGood`.`created`, `RecommendsGood`.`modified`, `RecommendsGood`.`image` FROM `jmuv3`.`recommends_goods` AS `RecommendsGood` WHERE `goods_id` IN (157366, 162108, 162109, 162110, 176642) AND `recommend_id` = 25 ORDER BY `RecommendsGood`.`sort_order` ASC, `RecommendsGood`.`modified` ASC LIMIT 1002
94SELECT `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` WHERE `Good`.`store_id` = 17506 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `Good`.`isdelete` = 0 ORDER BY `Good`.`id` ASC LIMIT 1112
95SELECT `Storeview`.`store_id`, `Storeview`.`favorites_count`, `Storeview`.`created`, `Storeview`.`modified` FROM `jmuv3`.`storeviews` AS `Storeview` WHERE `Storeview`.`store_id` = 28632 LIMIT 1110
96SELECT `Good`.`id` FROM `jmuv3`.`goods` AS `Good` WHERE `Good`.`store_id` = 28632 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `Good`.`isdelete` = 021211
97SELECT `RecommendsGood`.`id`, `RecommendsGood`.`goods_id`, `RecommendsGood`.`sort_order`, `RecommendsGood`.`recommend_id`, `RecommendsGood`.`category_id`, `RecommendsGood`.`start`, `RecommendsGood`.`end`, `RecommendsGood`.`created`, `RecommendsGood`.`modified`, `RecommendsGood`.`image` FROM `jmuv3`.`recommends_goods` AS `RecommendsGood` WHERE `goods_id` IN (135523, 135701, 135703, 135704, 135707, 135714, 135715, 135721, 135724, 135727, 135728, 135762, 136028, 136029, 136030, 136033, 224448, 224495, 224496, 224503, 224505) AND `recommend_id` = 25 ORDER BY `RecommendsGood`.`sort_order` ASC, `RecommendsGood`.`modified` ASC LIMIT 1002
98SELECT `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` WHERE `Good`.`store_id` = 28632 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `Good`.`isdelete` = 0 ORDER BY `Good`.`id` ASC LIMIT 1111
99SELECT `Storeview`.`store_id`, `Storeview`.`favorites_count`, `Storeview`.`created`, `Storeview`.`modified` FROM `jmuv3`.`storeviews` AS `Storeview` WHERE `Storeview`.`store_id` = 28630 LIMIT 1110
100SELECT `Good`.`id` FROM `jmuv3`.`goods` AS `Good` WHERE `Good`.`store_id` = 28630 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `Good`.`isdelete` = 0221
101SELECT `RecommendsGood`.`id`, `RecommendsGood`.`goods_id`, `RecommendsGood`.`sort_order`, `RecommendsGood`.`recommend_id`, `RecommendsGood`.`category_id`, `RecommendsGood`.`start`, `RecommendsGood`.`end`, `RecommendsGood`.`created`, `RecommendsGood`.`modified`, `RecommendsGood`.`image` FROM `jmuv3`.`recommends_goods` AS `RecommendsGood` WHERE `goods_id` IN (133501, 134349) AND `recommend_id` = 25 ORDER BY `RecommendsGood`.`sort_order` ASC, `RecommendsGood`.`modified` ASC LIMIT 1002
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` WHERE `Good`.`store_id` = 28630 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isaudit` = 1 AND `Good`.`isdelete` = 0 ORDER BY `Good`.`id` ASC LIMIT 1111

用户登录

×

商品价格仅对会员开放

15天内免登录

忘记密码? 立即注册