用户登录

×

商品价格仅对会员开放

15天内免登录

忘记密码? 立即注册
爆款推荐


爆款推荐

新品推荐


新品推荐

新品推荐

品牌推荐


品牌推荐

品牌推荐

粮油米面


粮油专区

粮油米面

肉禽类(冻品)


肉食专区

肉禽类(冻品)

酒水饮料


酒水饮料

酒水饮料

  • 会稽山精装陈年花雕 600ml*12瓶/箱

    会稽山精装陈年花雕 600ml*12瓶/箱
  • 加多宝金罐凉茶 310ml*24罐/箱

    加多宝金罐凉茶 310ml*24罐/箱
  • 加洛(葡国公鸡)干红葡萄酒 750ml*6瓶/箱

    加洛(葡国公鸡)干红葡萄酒 750ml*6瓶/箱
  • 嘉诚庄园【意大利原瓶进口】荣誉酿酒师干红葡萄酒 750ml*6瓶/箱

    嘉诚庄园【意大利原瓶进口】荣誉酿酒师干红葡萄酒 750ml*6瓶/箱
  • 会稽山唐宋天禧黄酒 480ml*12瓶/箱

    会稽山唐宋天禧黄酒 480ml*12瓶/箱
  • 黄金河谷半干红葡萄酒 750ml*6瓶/箱

    黄金河谷半干红葡萄酒 750ml*6瓶/箱
水产海鲜(冻)


水产海鲜

水产海鲜(冻)

成品/半成品


加工食品

成品/半成品

调味品


调味干货

调味品

酒店用品


酒店用品

酒店用品

自营旗舰店
(default) 96 queries took 830 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Store`.`id`, `Store`.`seller_id`, `Store`.`area_id`, `Store`.`category_id`, `Store`.`category_name`, `Store`.`area`, `Store`.`grade`, `Store`.`address`, `Store`.`phone`, `Store`.`logo`, `Store`.`banner`, `Store`.`name`, `Store`.`description`, `Store`.`isaudit`, `Store`.`realname`, `Store`.`id_card`, `Store`.`zipcode`, `Store`.`expired`, `Store`.`advertising`, `Store`.`mobile`, `Store`.`client_id`, `Store`.`created`, `Store`.`modified`, `Store`.`ismallbilling`, `Store`.`business_license_register`, `Store`.`business_license_valid`, `Store`.`org_code`, `Store`.`org_code_valid`, `Store`.`scope_business`, `Store`.`is_license`, `Store`.`is_contract`, `Store`.`mem_fees`, `Store`.`star_level`, `Store`.`min_buy_price`, `Store`.`free_freight_flag`, `Store`.`is_usenew`, `Store`.`style`, `Store`.`headbanner`, `Store`.`footbanner` FROM `jmuv3`.`stores` AS `Store` WHERE `Store`.`id` = 37240 AND `Store`.`isaudit` = 1 LIMIT 1111
2SELECT `Seller`.`id`, `Seller`.`user_id`, `Seller`.`name`, `Seller`.`code`, `Seller`.`store_id`, `Seller`.`grade`, `Seller`.`isaudit`, `Seller`.`auditment`, `Seller`.`isdelete`, `Seller`.`created`, `Seller`.`modified`, `Seller`.`source`, `Seller`.`company_property`, `Seller`.`reg_years`, `Seller`.`company_brand`, `Seller`.`registe_address`, `Seller`.`delivery_area`, `Seller`.`delivery_address`, `Seller`.`is_own_traffic`, `Seller`.`owner_id`, `Seller`.`lairage_time`, `Seller`.`open_reason`, `Seller`.`open_time` FROM `jmuv3`.`sellers` AS `Seller` WHERE `Seller`.`id` = 41768 LIMIT 1111
3SELECT `Userinfo`.`id`, `Userinfo`.`user_id`, `Userinfo`.`area_id`, `Userinfo`.`area`, `Userinfo`.`company_phone`, `Userinfo`.`company_url`, `Userinfo`.`company_scale`, `Userinfo`.`company_name`, `Userinfo`.`company_office`, `Userinfo`.`company_address`, `Userinfo`.`company_zipcode`, `Userinfo`.`company_turnover`, `Userinfo`.`holder_name`, `Userinfo`.`holder_phone`, `Userinfo`.`holder_email`, `Userinfo`.`buyer_name`, `Userinfo`.`buyer_phone`, `Userinfo`.`buyer_email`, `Userinfo`.`created`, `Userinfo`.`modified`, `Userinfo`.`other_name`, `Userinfo`.`other_phone`, `Userinfo`.`other_email`, `Userinfo`.`biznum_cert`, `Userinfo`.`foodprod_cert`, `Userinfo`.`foodcircu_cert`, `Userinfo`.`catering_cert`, `Userinfo`.`foodbusiness_cert`, `Userinfo`.`license_number`, `Userinfo`.`buyer_card`, `Userinfo`.`superior_card`, `User`.`id`, `User`.`parent_id`, `User`.`username`, `User`.`password`, `User`.`salt`, `User`.`group_id`, `User`.`last_login`, `User`.`last_ip`, `User`.`login`, `User`.`avatar`, `User`.`avatar_position`, `User`.`realname`, `User`.`gender`, `User`.`phone`, `User`.`mobile`, `User`.`email`, `User`.`birthday`, `User`.`reserve_msg`, `User`.`guide`, `User`.`isaudit`, `User`.`auditment`, `User`.`platform_id`, `User`.`option_id`, `User`.`created`, `User`.`modified`, `User`.`is_pk`, `User`.`fax`, `User`.`position`, `User`.`department`, `User`.`contact_address`, `User`.`qq`, `User`.`is_delete`, `User`.`is_bill`, `User`.`ft_id`, `User`.`billdays`, `User`.`tag`, `User`.`integral`, `User`.`openid`, `User`.`alipay_id`, `User`.`alipay_app_auth_token`, `User`.`alipay_refresh_token`, `User`.`alipay_app_id`, `User`.`code` FROM `jmuv3`.`userinfos` AS `Userinfo` LEFT JOIN `jmuv3`.`users` AS `User` ON (`Userinfo`.`user_id` = `User`.`id`) WHERE `Userinfo`.`user_id` = 78611 LIMIT 1111
4SELECT `Area`.`lft`, `Area`.`rght` FROM `jmuv3`.`areas` AS `Area` WHERE `Area`.`id` = 47 LIMIT 1110
5SELECT `Area`.`id`, `Area`.`parent_id`, `Area`.`name`, `Area`.`letter`, `Area`.`order`, `Area`.`lft`, `Area`.`rght` FROM `jmuv3`.`areas` AS `Area` WHERE 1 = 1 AND `Area`.`lft` <= 6512 AND `Area`.`rght` >= 6513 ORDER BY `Area`.`lft` asc444
6SELECT `Category`.`lft`, `Category`.`rght` FROM `jmuv3`.`categories` AS `Category` WHERE `Category`.`id` = 1893 LIMIT 1110
7SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name`, `Category`.`isrecommend`, `Category`.`lft`, `Category`.`rght`, `Category`.`nc_code`, `Category`.`ft_code`, `Category`.`isshow`, `Category`.`sort` FROM `jmuv3`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`lft` <= 1001 AND `Category`.`rght` >= 1002 ORDER BY `Category`.`lft` asc332
8SELECT `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
9SELECT `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
10SELECT `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
11SELECT `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
12SELECT COUNT(*) AS `count` FROM `jmuv3`.`goods` AS `Good` LEFT JOIN `jmuv3`.`sellers` AS `Seller` ON (`Good`.`seller_id` = `Seller`.`id`) LEFT JOIN `jmuv3`.`stores` AS `Store` ON (`Good`.`store_id` = `Store`.`id`) LEFT JOIN `jmuv3`.`goodsviews` AS `Goodsview` ON (`Good`.`id` = `Goodsview`.`goods_id`) LEFT JOIN `jmuv3`.`specs` AS `DefaultSpec` ON (`DefaultSpec`.`issetspec` = 1 AND `Good`.`spec_id` = `DefaultSpec`.`id`) WHERE `Good`.`store_id` = 37240 AND `Good`.`isaudit` = 1 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 21111
13SELECT `Innercategory`.`id`, `Innercategory`.`parent_id`, `Innercategory`.`store_id`, `Innercategory`.`name`, `Innercategory`.`lft`, `Innercategory`.`rght`, `Innercategory`.`order`, `Innercategory`.`isdisplay`, `Innercategory`.`isdelete`, `Innercategory`.`created`, `Innercategory`.`modified` FROM `jmuv3`.`innercategories` AS `Innercategory` WHERE `Innercategory`.`store_id` = 37240 AND `Innercategory`.`isdelete` = 0 AND `Innercategory`.`isdisplay` = 1 ORDER BY `Innercategory`.`order` ASC484825
14SELECT `StoresCall`.`id`, `StoresCall`.`store_id`, `StoresCall`.`user_name`, `StoresCall`.`type`, `StoresCall`.`created`, `Store`.`id`, `Store`.`seller_id`, `Store`.`area_id`, `Store`.`category_id`, `Store`.`category_name`, `Store`.`area`, `Store`.`grade`, `Store`.`address`, `Store`.`phone`, `Store`.`logo`, `Store`.`banner`, `Store`.`name`, `Store`.`description`, `Store`.`isaudit`, `Store`.`realname`, `Store`.`id_card`, `Store`.`zipcode`, `Store`.`expired`, `Store`.`advertising`, `Store`.`mobile`, `Store`.`client_id`, `Store`.`created`, `Store`.`modified`, `Store`.`ismallbilling`, `Store`.`business_license_register`, `Store`.`business_license_valid`, `Store`.`org_code`, `Store`.`org_code_valid`, `Store`.`scope_business`, `Store`.`is_license`, `Store`.`is_contract`, `Store`.`mem_fees`, `Store`.`star_level`, `Store`.`min_buy_price`, `Store`.`free_freight_flag`, `Store`.`is_usenew`, `Store`.`style`, `Store`.`headbanner`, `Store`.`footbanner` FROM `jmuv3`.`stores_calls` AS `StoresCall` LEFT JOIN `jmuv3`.`stores` AS `Store` ON (`StoresCall`.`store_id` = `Store`.`id`) WHERE `StoresCall`.`store_id` = 37240 AND `StoresCall`.`type` = 1 LIMIT 1111
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`, `Seller`.`id`, `Seller`.`user_id`, `Seller`.`name`, `Seller`.`code`, `Seller`.`store_id`, `Seller`.`grade`, `Seller`.`isaudit`, `Seller`.`auditment`, `Seller`.`isdelete`, `Seller`.`created`, `Seller`.`modified`, `Seller`.`source`, `Seller`.`company_property`, `Seller`.`reg_years`, `Seller`.`company_brand`, `Seller`.`registe_address`, `Seller`.`delivery_area`, `Seller`.`delivery_address`, `Seller`.`is_own_traffic`, `Seller`.`owner_id`, `Seller`.`lairage_time`, `Seller`.`open_reason`, `Seller`.`open_time`, `Store`.`id`, `Store`.`seller_id`, `Store`.`area_id`, `Store`.`category_id`, `Store`.`category_name`, `Store`.`area`, `Store`.`grade`, `Store`.`address`, `Store`.`phone`, `Store`.`logo`, `Store`.`banner`, `Store`.`name`, `Store`.`description`, `Store`.`isaudit`, `Store`.`realname`, `Store`.`id_card`, `Store`.`zipcode`, `Store`.`expired`, `Store`.`advertising`, `Store`.`mobile`, `Store`.`client_id`, `Store`.`created`, `Store`.`modified`, `Store`.`ismallbilling`, `Store`.`business_license_register`, `Store`.`business_license_valid`, `Store`.`org_code`, `Store`.`org_code_valid`, `Store`.`scope_business`, `Store`.`is_license`, `Store`.`is_contract`, `Store`.`mem_fees`, `Store`.`star_level`, `Store`.`min_buy_price`, `Store`.`free_freight_flag`, `Store`.`is_usenew`, `Store`.`style`, `Store`.`headbanner`, `Store`.`footbanner`, `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`, `DefaultSpec`.`id`, `DefaultSpec`.`store_id`, `DefaultSpec`.`goods_id`, `DefaultSpec`.`stock`, `DefaultSpec`.`unit`, `DefaultSpec`.`price`, `DefaultSpec`.`range_price`, `DefaultSpec`.`spec_1`, `DefaultSpec`.`spec_2`, `DefaultSpec`.`value_1`, `DefaultSpec`.`value_2`, `DefaultSpec`.`price_1`, `DefaultSpec`.`price_2`, `DefaultSpec`.`price_3`, `DefaultSpec`.`price_4`, `DefaultSpec`.`reduce_1`, `DefaultSpec`.`reduce_2`, `DefaultSpec`.`reduce_3`, `DefaultSpec`.`reduce_4`, `DefaultSpec`.`discount_1`, `DefaultSpec`.`discount_2`, `DefaultSpec`.`discount_3`, `DefaultSpec`.`discount_4`, `DefaultSpec`.`sku`, `DefaultSpec`.`description`, `DefaultSpec`.`issetspec`, `DefaultSpec`.`oldgoodid`, `DefaultSpec`.`oldid`, `DefaultSpec`.`created`, `DefaultSpec`.`modified`, `DefaultSpec`.`article`, `DefaultSpec`.`integral` FROM `jmuv3`.`goods` AS `Good` LEFT JOIN `jmuv3`.`sellers` AS `Seller` ON (`Good`.`seller_id` = `Seller`.`id`) LEFT JOIN `jmuv3`.`stores` AS `Store` ON (`Good`.`store_id` = `Store`.`id`) LEFT JOIN `jmuv3`.`goodsviews` AS `Goodsview` ON (`Good`.`id` = `Goodsview`.`goods_id`) LEFT JOIN `jmuv3`.`specs` AS `DefaultSpec` ON (`DefaultSpec`.`issetspec` = 1 AND `Good`.`spec_id` = `DefaultSpec`.`id`) WHERE `Good`.`store_id` = 37240 AND `Good`.`isaudit` = 1 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 ORDER BY `Good`.`modified` DESC LIMIT 8885
16SELECT `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`.`issetspec` = 0 AND `Spec`.`goods_id` IN (218414, 217813, 181921, 181928, 181941, 181950, 225386, 177478) ORDER BY `Spec`.`created` DESC331
17SELECT `Image`.`id`, `Image`.`goods_id`, `Image`.`image`, `Image`.`thumbnail`, `Image`.`isindex` FROM `jmuv3`.`goodsimages` AS `Image` WHERE `Image`.`type` = 0 AND `Image`.`goods_id` IN (218414, 217813, 181921, 181928, 181941, 181950, 225386, 177478) ORDER BY `Image`.`created` DESC16161
18SELECT `Ladderprice`.`id`, `Ladderprice`.`goods_id`, `Ladderprice`.`ordinary_black_price`, `Ladderprice`.`gold_price`, `Ladderprice`.`vip_card_price`, `Ladderprice`.`ladprice`, `Ladderprice`.`left_interval`, `Ladderprice`.`right_interval`, `Ladderprice`.`created`, `Ladderprice`.`modified` FROM `jmuv3`.`ladderprices` AS `Ladderprice` WHERE `Ladderprice`.`goods_id` IN (218414, 217813, 181921, 181928, 181941, 181950, 225386, 177478) ORDER BY `id` ASC001
19SELECT `GoodsArea`.`id`, `GoodsArea`.`goods_id`, `GoodsArea`.`city_id`, `GoodsArea`.`sale_price`, `GoodsArea`.`created`, `GoodsArea`.`modified` FROM `jmuv3`.`goods_areas` AS `GoodsArea` WHERE `GoodsArea`.`goods_id` IN (218414, 217813, 181921, 181928, 181941, 181950, 225386, 177478)8847
20SELECT `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`, `Seller`.`id`, `Seller`.`user_id`, `Seller`.`name`, `Seller`.`code`, `Seller`.`store_id`, `Seller`.`grade`, `Seller`.`isaudit`, `Seller`.`auditment`, `Seller`.`isdelete`, `Seller`.`created`, `Seller`.`modified`, `Seller`.`source`, `Seller`.`company_property`, `Seller`.`reg_years`, `Seller`.`company_brand`, `Seller`.`registe_address`, `Seller`.`delivery_area`, `Seller`.`delivery_address`, `Seller`.`is_own_traffic`, `Seller`.`owner_id`, `Seller`.`lairage_time`, `Seller`.`open_reason`, `Seller`.`open_time`, `Store`.`id`, `Store`.`seller_id`, `Store`.`area_id`, `Store`.`category_id`, `Store`.`category_name`, `Store`.`area`, `Store`.`grade`, `Store`.`address`, `Store`.`phone`, `Store`.`logo`, `Store`.`banner`, `Store`.`name`, `Store`.`description`, `Store`.`isaudit`, `Store`.`realname`, `Store`.`id_card`, `Store`.`zipcode`, `Store`.`expired`, `Store`.`advertising`, `Store`.`mobile`, `Store`.`client_id`, `Store`.`created`, `Store`.`modified`, `Store`.`ismallbilling`, `Store`.`business_license_register`, `Store`.`business_license_valid`, `Store`.`org_code`, `Store`.`org_code_valid`, `Store`.`scope_business`, `Store`.`is_license`, `Store`.`is_contract`, `Store`.`mem_fees`, `Store`.`star_level`, `Store`.`min_buy_price`, `Store`.`free_freight_flag`, `Store`.`is_usenew`, `Store`.`style`, `Store`.`headbanner`, `Store`.`footbanner`, `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`, `DefaultSpec`.`id`, `DefaultSpec`.`store_id`, `DefaultSpec`.`goods_id`, `DefaultSpec`.`stock`, `DefaultSpec`.`unit`, `DefaultSpec`.`price`, `DefaultSpec`.`range_price`, `DefaultSpec`.`spec_1`, `DefaultSpec`.`spec_2`, `DefaultSpec`.`value_1`, `DefaultSpec`.`value_2`, `DefaultSpec`.`price_1`, `DefaultSpec`.`price_2`, `DefaultSpec`.`price_3`, `DefaultSpec`.`price_4`, `DefaultSpec`.`reduce_1`, `DefaultSpec`.`reduce_2`, `DefaultSpec`.`reduce_3`, `DefaultSpec`.`reduce_4`, `DefaultSpec`.`discount_1`, `DefaultSpec`.`discount_2`, `DefaultSpec`.`discount_3`, `DefaultSpec`.`discount_4`, `DefaultSpec`.`sku`, `DefaultSpec`.`description`, `DefaultSpec`.`issetspec`, `DefaultSpec`.`oldgoodid`, `DefaultSpec`.`oldid`, `DefaultSpec`.`created`, `DefaultSpec`.`modified`, `DefaultSpec`.`article`, `DefaultSpec`.`integral` FROM `jmuv3`.`goods` AS `Good` LEFT JOIN `jmuv3`.`sellers` AS `Seller` ON (`Good`.`seller_id` = `Seller`.`id`) LEFT JOIN `jmuv3`.`stores` AS `Store` ON (`Good`.`store_id` = `Store`.`id`) LEFT JOIN `jmuv3`.`goodsviews` AS `Goodsview` ON (`Good`.`id` = `Goodsview`.`goods_id`) LEFT JOIN `jmuv3`.`specs` AS `DefaultSpec` ON (`DefaultSpec`.`issetspec` = 1 AND `Good`.`spec_id` = `DefaultSpec`.`id`) WHERE `Good`.`store_id` = 37240 AND `Good`.`isaudit` = 1 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`isrecommend` = 1 LIMIT 80018
21SELECT `Brand`.`id`, `Brand`.`name`, `Brand`.`grade`, `Brand`.`describe`, `Brand`.`created`, `Brand`.`modified`, `Brand`.`isdelete`, `Brand`.`store_id`, `Brand`.`innercategory_id`, `Brand`.`innercategory_name` FROM `jmuv3`.`brands` AS `Brand` WHERE `Brand`.`store_id` = 37240 AND `Brand`.`isdelete` = 1 ORDER BY `Brand`.`grade` asc, `Brand`.`modified` desc001
22SELECT `RecommendsStoresNew`.`id`, `RecommendsStoresNew`.`store_id`, `RecommendsStoresNew`.`recommend_type`, `RecommendsStoresNew`.`recommend_name`, `RecommendsStoresNew`.`innercategory_id`, `RecommendsStoresNew`.`describe`, `RecommendsStoresNew`.`isshow`, `RecommendsStoresNew`.`adimage`, `RecommendsStoresNew`.`created`, `RecommendsStoresNew`.`modified`, `RecommendsStoresNew`.`order` FROM `jmuv3`.`recommends_stores_news` AS `RecommendsStoresNew` WHERE `RecommendsStoresNew`.`store_id` = 37240 AND `RecommendsStoresNew`.`isshow` = 1 ORDER BY `order` asc10101
23SELECT `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`, `Seller`.`id`, `Seller`.`user_id`, `Seller`.`name`, `Seller`.`code`, `Seller`.`store_id`, `Seller`.`grade`, `Seller`.`isaudit`, `Seller`.`auditment`, `Seller`.`isdelete`, `Seller`.`created`, `Seller`.`modified`, `Seller`.`source`, `Seller`.`company_property`, `Seller`.`reg_years`, `Seller`.`company_brand`, `Seller`.`registe_address`, `Seller`.`delivery_area`, `Seller`.`delivery_address`, `Seller`.`is_own_traffic`, `Seller`.`owner_id`, `Seller`.`lairage_time`, `Seller`.`open_reason`, `Seller`.`open_time`, `Store`.`id`, `Store`.`seller_id`, `Store`.`area_id`, `Store`.`category_id`, `Store`.`category_name`, `Store`.`area`, `Store`.`grade`, `Store`.`address`, `Store`.`phone`, `Store`.`logo`, `Store`.`banner`, `Store`.`name`, `Store`.`description`, `Store`.`isaudit`, `Store`.`realname`, `Store`.`id_card`, `Store`.`zipcode`, `Store`.`expired`, `Store`.`advertising`, `Store`.`mobile`, `Store`.`client_id`, `Store`.`created`, `Store`.`modified`, `Store`.`ismallbilling`, `Store`.`business_license_register`, `Store`.`business_license_valid`, `Store`.`org_code`, `Store`.`org_code_valid`, `Store`.`scope_business`, `Store`.`is_license`, `Store`.`is_contract`, `Store`.`mem_fees`, `Store`.`star_level`, `Store`.`min_buy_price`, `Store`.`free_freight_flag`, `Store`.`is_usenew`, `Store`.`style`, `Store`.`headbanner`, `Store`.`footbanner`, `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`, `DefaultSpec`.`id`, `DefaultSpec`.`store_id`, `DefaultSpec`.`goods_id`, `DefaultSpec`.`stock`, `DefaultSpec`.`unit`, `DefaultSpec`.`price`, `DefaultSpec`.`range_price`, `DefaultSpec`.`spec_1`, `DefaultSpec`.`spec_2`, `DefaultSpec`.`value_1`, `DefaultSpec`.`value_2`, `DefaultSpec`.`price_1`, `DefaultSpec`.`price_2`, `DefaultSpec`.`price_3`, `DefaultSpec`.`price_4`, `DefaultSpec`.`reduce_1`, `DefaultSpec`.`reduce_2`, `DefaultSpec`.`reduce_3`, `DefaultSpec`.`reduce_4`, `DefaultSpec`.`discount_1`, `DefaultSpec`.`discount_2`, `DefaultSpec`.`discount_3`, `DefaultSpec`.`discount_4`, `DefaultSpec`.`sku`, `DefaultSpec`.`description`, `DefaultSpec`.`issetspec`, `DefaultSpec`.`oldgoodid`, `DefaultSpec`.`oldid`, `DefaultSpec`.`created`, `DefaultSpec`.`modified`, `DefaultSpec`.`article`, `DefaultSpec`.`integral` FROM `jmuv3`.`goods` AS `Good` LEFT JOIN `jmuv3`.`sellers` AS `Seller` ON (`Good`.`seller_id` = `Seller`.`id`) LEFT JOIN `jmuv3`.`stores` AS `Store` ON (`Good`.`store_id` = `Store`.`id`) LEFT JOIN `jmuv3`.`goodsviews` AS `Goodsview` ON (`Good`.`id` = `Goodsview`.`goods_id`) LEFT JOIN `jmuv3`.`specs` AS `DefaultSpec` ON (`DefaultSpec`.`issetspec` = 1 AND `Good`.`spec_id` = `DefaultSpec`.`id`) WHERE `Good`.`store_id` = 37240 AND `Good`.`isaudit` = 1 AND `Good`.`isdelete` = 0 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`recommends_stores_new_id` = 18 AND `Good`.`recommend_flag_order` != 99 ORDER BY `Good`.`recommend_flag_order` asc LIMIT 33310
24SELECT `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`.`issetspec` = 0 AND `Spec`.`goods_id` IN (217731, 181162, 223642) ORDER BY `Spec`.`created` DESC221
25SELECT `Image`.`id`, `Image`.`goods_id`, `Image`.`image`, `Image`.`thumbnail`, `Image`.`isindex` FROM `jmuv3`.`goodsimages` AS `Image` WHERE `Image`.`type` = 0 AND `Image`.`goods_id` IN (217731, 181162, 223642) ORDER BY `Image`.`created` DESC881
26SELECT `Ladderprice`.`id`, `Ladderprice`.`goods_id`, `Ladderprice`.`ordinary_black_price`, `Ladderprice`.`gold_price`, `Ladderprice`.`vip_card_price`, `Ladderprice`.`ladprice`, `Ladderprice`.`left_interval`, `Ladderprice`.`right_interval`, `Ladderprice`.`created`, `Ladderprice`.`modified` FROM `jmuv3`.`ladderprices` AS `Ladderprice` WHERE `Ladderprice`.`goods_id` IN (217731, 181162, 223642) ORDER BY `id` ASC001
27SELECT `GoodsArea`.`id`, `GoodsArea`.`goods_id`, `GoodsArea`.`city_id`, `GoodsArea`.`sale_price`, `GoodsArea`.`created`, `GoodsArea`.`modified` FROM `jmuv3`.`goods_areas` AS `GoodsArea` WHERE `GoodsArea`.`goods_id` IN (217731, 181162, 223642)3341
28SELECT `RecommendsStoresNew`.`id`, `RecommendsStoresNew`.`store_id`, `RecommendsStoresNew`.`recommend_type`, `RecommendsStoresNew`.`recommend_name`, `RecommendsStoresNew`.`innercategory_id`, `RecommendsStoresNew`.`describe`, `RecommendsStoresNew`.`isshow`, `RecommendsStoresNew`.`adimage`, `RecommendsStoresNew`.`created`, `RecommendsStoresNew`.`modified`, `RecommendsStoresNew`.`order` FROM `jmuv3`.`recommends_stores_news` AS `RecommendsStoresNew` WHERE `RecommendsStoresNew`.`id` = 18 AND `RecommendsStoresNew`.`isshow` = 1 LIMIT 1111
29SELECT `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`, `Seller`.`id`, `Seller`.`user_id`, `Seller`.`name`, `Seller`.`code`, `Seller`.`store_id`, `Seller`.`grade`, `Seller`.`isaudit`, `Seller`.`auditment`, `Seller`.`isdelete`, `Seller`.`created`, `Seller`.`modified`, `Seller`.`source`, `Seller`.`company_property`, `Seller`.`reg_years`, `Seller`.`company_brand`, `Seller`.`registe_address`, `Seller`.`delivery_area`, `Seller`.`delivery_address`, `Seller`.`is_own_traffic`, `Seller`.`owner_id`, `Seller`.`lairage_time`, `Seller`.`open_reason`, `Seller`.`open_time`, `Store`.`id`, `Store`.`seller_id`, `Store`.`area_id`, `Store`.`category_id`, `Store`.`category_name`, `Store`.`area`, `Store`.`grade`, `Store`.`address`, `Store`.`phone`, `Store`.`logo`, `Store`.`banner`, `Store`.`name`, `Store`.`description`, `Store`.`isaudit`, `Store`.`realname`, `Store`.`id_card`, `Store`.`zipcode`, `Store`.`expired`, `Store`.`advertising`, `Store`.`mobile`, `Store`.`client_id`, `Store`.`created`, `Store`.`modified`, `Store`.`ismallbilling`, `Store`.`business_license_register`, `Store`.`business_license_valid`, `Store`.`org_code`, `Store`.`org_code_valid`, `Store`.`scope_business`, `Store`.`is_license`, `Store`.`is_contract`, `Store`.`mem_fees`, `Store`.`star_level`, `Store`.`min_buy_price`, `Store`.`free_freight_flag`, `Store`.`is_usenew`, `Store`.`style`, `Store`.`headbanner`, `Store`.`footbanner`, `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`, `DefaultSpec`.`id`, `DefaultSpec`.`store_id`, `DefaultSpec`.`goods_id`, `DefaultSpec`.`stock`, `DefaultSpec`.`unit`, `DefaultSpec`.`price`, `DefaultSpec`.`range_price`, `DefaultSpec`.`spec_1`, `DefaultSpec`.`spec_2`, `DefaultSpec`.`value_1`, `DefaultSpec`.`value_2`, `DefaultSpec`.`price_1`, `DefaultSpec`.`price_2`, `DefaultSpec`.`price_3`, `DefaultSpec`.`price_4`, `DefaultSpec`.`reduce_1`, `DefaultSpec`.`reduce_2`, `DefaultSpec`.`reduce_3`, `DefaultSpec`.`reduce_4`, `DefaultSpec`.`discount_1`, `DefaultSpec`.`discount_2`, `DefaultSpec`.`discount_3`, `DefaultSpec`.`discount_4`, `DefaultSpec`.`sku`, `DefaultSpec`.`description`, `DefaultSpec`.`issetspec`, `DefaultSpec`.`oldgoodid`, `DefaultSpec`.`oldid`, `DefaultSpec`.`created`, `DefaultSpec`.`modified`, `DefaultSpec`.`article`, `DefaultSpec`.`integral` FROM `jmuv3`.`goods` AS `Good` LEFT JOIN `jmuv3`.`sellers` AS `Seller` ON (`Good`.`seller_id` = `Seller`.`id`) LEFT JOIN `jmuv3`.`stores` AS `Store` ON (`Good`.`store_id` = `Store`.`id`) LEFT JOIN `jmuv3`.`goodsviews` AS `Goodsview` ON (`Good`.`id` = `Goodsview`.`goods_id`) LEFT JOIN `jmuv3`.`specs` AS `DefaultSpec` ON (`DefaultSpec`.`issetspec` = 1 AND `Good`.`spec_id` = `DefaultSpec`.`id`) WHERE `Good`.`store_id` = 37240 AND `Good`.`isaudit` = 1 AND `Good`.`isdelete` = 0 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`recommends_stores_new_id` = 19 AND `Good`.`recommend_flag_order` != 99 ORDER BY `Good`.`recommend_flag_order` asc LIMIT 65510
30SELECT `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`.`issetspec` = 0 AND `Spec`.`goods_id` IN (225189, 223527, 219712, 166384, 217813) ORDER BY `Spec`.`created` DESC221
31SELECT `Image`.`id`, `Image`.`goods_id`, `Image`.`image`, `Image`.`thumbnail`, `Image`.`isindex` FROM `jmuv3`.`goodsimages` AS `Image` WHERE `Image`.`type` = 0 AND `Image`.`goods_id` IN (225189, 223527, 219712, 166384, 217813) ORDER BY `Image`.`created` DESC991
32SELECT `Ladderprice`.`id`, `Ladderprice`.`goods_id`, `Ladderprice`.`ordinary_black_price`, `Ladderprice`.`gold_price`, `Ladderprice`.`vip_card_price`, `Ladderprice`.`ladprice`, `Ladderprice`.`left_interval`, `Ladderprice`.`right_interval`, `Ladderprice`.`created`, `Ladderprice`.`modified` FROM `jmuv3`.`ladderprices` AS `Ladderprice` WHERE `Ladderprice`.`goods_id` IN (225189, 223527, 219712, 166384, 217813) ORDER BY `id` ASC001
33SELECT `GoodsArea`.`id`, `GoodsArea`.`goods_id`, `GoodsArea`.`city_id`, `GoodsArea`.`sale_price`, `GoodsArea`.`created`, `GoodsArea`.`modified` FROM `jmuv3`.`goods_areas` AS `GoodsArea` WHERE `GoodsArea`.`goods_id` IN (225189, 223527, 219712, 166384, 217813)5545
34SELECT `RecommendsStoresNew`.`id`, `RecommendsStoresNew`.`store_id`, `RecommendsStoresNew`.`recommend_type`, `RecommendsStoresNew`.`recommend_name`, `RecommendsStoresNew`.`innercategory_id`, `RecommendsStoresNew`.`describe`, `RecommendsStoresNew`.`isshow`, `RecommendsStoresNew`.`adimage`, `RecommendsStoresNew`.`created`, `RecommendsStoresNew`.`modified`, `RecommendsStoresNew`.`order` FROM `jmuv3`.`recommends_stores_news` AS `RecommendsStoresNew` WHERE `RecommendsStoresNew`.`id` = 19 AND `RecommendsStoresNew`.`isshow` = 1 LIMIT 1111
35SELECT `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`, `Seller`.`id`, `Seller`.`user_id`, `Seller`.`name`, `Seller`.`code`, `Seller`.`store_id`, `Seller`.`grade`, `Seller`.`isaudit`, `Seller`.`auditment`, `Seller`.`isdelete`, `Seller`.`created`, `Seller`.`modified`, `Seller`.`source`, `Seller`.`company_property`, `Seller`.`reg_years`, `Seller`.`company_brand`, `Seller`.`registe_address`, `Seller`.`delivery_area`, `Seller`.`delivery_address`, `Seller`.`is_own_traffic`, `Seller`.`owner_id`, `Seller`.`lairage_time`, `Seller`.`open_reason`, `Seller`.`open_time`, `Store`.`id`, `Store`.`seller_id`, `Store`.`area_id`, `Store`.`category_id`, `Store`.`category_name`, `Store`.`area`, `Store`.`grade`, `Store`.`address`, `Store`.`phone`, `Store`.`logo`, `Store`.`banner`, `Store`.`name`, `Store`.`description`, `Store`.`isaudit`, `Store`.`realname`, `Store`.`id_card`, `Store`.`zipcode`, `Store`.`expired`, `Store`.`advertising`, `Store`.`mobile`, `Store`.`client_id`, `Store`.`created`, `Store`.`modified`, `Store`.`ismallbilling`, `Store`.`business_license_register`, `Store`.`business_license_valid`, `Store`.`org_code`, `Store`.`org_code_valid`, `Store`.`scope_business`, `Store`.`is_license`, `Store`.`is_contract`, `Store`.`mem_fees`, `Store`.`star_level`, `Store`.`min_buy_price`, `Store`.`free_freight_flag`, `Store`.`is_usenew`, `Store`.`style`, `Store`.`headbanner`, `Store`.`footbanner`, `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`, `DefaultSpec`.`id`, `DefaultSpec`.`store_id`, `DefaultSpec`.`goods_id`, `DefaultSpec`.`stock`, `DefaultSpec`.`unit`, `DefaultSpec`.`price`, `DefaultSpec`.`range_price`, `DefaultSpec`.`spec_1`, `DefaultSpec`.`spec_2`, `DefaultSpec`.`value_1`, `DefaultSpec`.`value_2`, `DefaultSpec`.`price_1`, `DefaultSpec`.`price_2`, `DefaultSpec`.`price_3`, `DefaultSpec`.`price_4`, `DefaultSpec`.`reduce_1`, `DefaultSpec`.`reduce_2`, `DefaultSpec`.`reduce_3`, `DefaultSpec`.`reduce_4`, `DefaultSpec`.`discount_1`, `DefaultSpec`.`discount_2`, `DefaultSpec`.`discount_3`, `DefaultSpec`.`discount_4`, `DefaultSpec`.`sku`, `DefaultSpec`.`description`, `DefaultSpec`.`issetspec`, `DefaultSpec`.`oldgoodid`, `DefaultSpec`.`oldid`, `DefaultSpec`.`created`, `DefaultSpec`.`modified`, `DefaultSpec`.`article`, `DefaultSpec`.`integral` FROM `jmuv3`.`goods` AS `Good` LEFT JOIN `jmuv3`.`sellers` AS `Seller` ON (`Good`.`seller_id` = `Seller`.`id`) LEFT JOIN `jmuv3`.`stores` AS `Store` ON (`Good`.`store_id` = `Store`.`id`) LEFT JOIN `jmuv3`.`goodsviews` AS `Goodsview` ON (`Good`.`id` = `Goodsview`.`goods_id`) LEFT JOIN `jmuv3`.`specs` AS `DefaultSpec` ON (`DefaultSpec`.`issetspec` = 1 AND `Good`.`spec_id` = `DefaultSpec`.`id`) WHERE `Good`.`store_id` = 37240 AND `Good`.`isaudit` = 1 AND `Good`.`isdelete` = 0 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`recommends_stores_new_id` = 20 AND `Good`.`recommend_flag_order` != 99 ORDER BY `Good`.`recommend_flag_order` asc LIMIT 66610
36SELECT `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`.`issetspec` = 0 AND `Spec`.`goods_id` IN (217689, 221784, 210358, 225007, 201653, 225190) ORDER BY `Spec`.`created` DESC221
37SELECT `Image`.`id`, `Image`.`goods_id`, `Image`.`image`, `Image`.`thumbnail`, `Image`.`isindex` FROM `jmuv3`.`goodsimages` AS `Image` WHERE `Image`.`type` = 0 AND `Image`.`goods_id` IN (217689, 221784, 210358, 225007, 201653, 225190) ORDER BY `Image`.`created` DESC10101
38SELECT `Ladderprice`.`id`, `Ladderprice`.`goods_id`, `Ladderprice`.`ordinary_black_price`, `Ladderprice`.`gold_price`, `Ladderprice`.`vip_card_price`, `Ladderprice`.`ladprice`, `Ladderprice`.`left_interval`, `Ladderprice`.`right_interval`, `Ladderprice`.`created`, `Ladderprice`.`modified` FROM `jmuv3`.`ladderprices` AS `Ladderprice` WHERE `Ladderprice`.`goods_id` IN (217689, 221784, 210358, 225007, 201653, 225190) ORDER BY `id` ASC001
39SELECT `GoodsArea`.`id`, `GoodsArea`.`goods_id`, `GoodsArea`.`city_id`, `GoodsArea`.`sale_price`, `GoodsArea`.`created`, `GoodsArea`.`modified` FROM `jmuv3`.`goods_areas` AS `GoodsArea` WHERE `GoodsArea`.`goods_id` IN (217689, 221784, 210358, 225007, 201653, 225190)6645
40SELECT `RecommendsStoresNew`.`id`, `RecommendsStoresNew`.`store_id`, `RecommendsStoresNew`.`recommend_type`, `RecommendsStoresNew`.`recommend_name`, `RecommendsStoresNew`.`innercategory_id`, `RecommendsStoresNew`.`describe`, `RecommendsStoresNew`.`isshow`, `RecommendsStoresNew`.`adimage`, `RecommendsStoresNew`.`created`, `RecommendsStoresNew`.`modified`, `RecommendsStoresNew`.`order` FROM `jmuv3`.`recommends_stores_news` AS `RecommendsStoresNew` WHERE `RecommendsStoresNew`.`id` = 20 AND `RecommendsStoresNew`.`isshow` = 1 LIMIT 1111
41SELECT `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`, `Seller`.`id`, `Seller`.`user_id`, `Seller`.`name`, `Seller`.`code`, `Seller`.`store_id`, `Seller`.`grade`, `Seller`.`isaudit`, `Seller`.`auditment`, `Seller`.`isdelete`, `Seller`.`created`, `Seller`.`modified`, `Seller`.`source`, `Seller`.`company_property`, `Seller`.`reg_years`, `Seller`.`company_brand`, `Seller`.`registe_address`, `Seller`.`delivery_area`, `Seller`.`delivery_address`, `Seller`.`is_own_traffic`, `Seller`.`owner_id`, `Seller`.`lairage_time`, `Seller`.`open_reason`, `Seller`.`open_time`, `Store`.`id`, `Store`.`seller_id`, `Store`.`area_id`, `Store`.`category_id`, `Store`.`category_name`, `Store`.`area`, `Store`.`grade`, `Store`.`address`, `Store`.`phone`, `Store`.`logo`, `Store`.`banner`, `Store`.`name`, `Store`.`description`, `Store`.`isaudit`, `Store`.`realname`, `Store`.`id_card`, `Store`.`zipcode`, `Store`.`expired`, `Store`.`advertising`, `Store`.`mobile`, `Store`.`client_id`, `Store`.`created`, `Store`.`modified`, `Store`.`ismallbilling`, `Store`.`business_license_register`, `Store`.`business_license_valid`, `Store`.`org_code`, `Store`.`org_code_valid`, `Store`.`scope_business`, `Store`.`is_license`, `Store`.`is_contract`, `Store`.`mem_fees`, `Store`.`star_level`, `Store`.`min_buy_price`, `Store`.`free_freight_flag`, `Store`.`is_usenew`, `Store`.`style`, `Store`.`headbanner`, `Store`.`footbanner`, `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`, `DefaultSpec`.`id`, `DefaultSpec`.`store_id`, `DefaultSpec`.`goods_id`, `DefaultSpec`.`stock`, `DefaultSpec`.`unit`, `DefaultSpec`.`price`, `DefaultSpec`.`range_price`, `DefaultSpec`.`spec_1`, `DefaultSpec`.`spec_2`, `DefaultSpec`.`value_1`, `DefaultSpec`.`value_2`, `DefaultSpec`.`price_1`, `DefaultSpec`.`price_2`, `DefaultSpec`.`price_3`, `DefaultSpec`.`price_4`, `DefaultSpec`.`reduce_1`, `DefaultSpec`.`reduce_2`, `DefaultSpec`.`reduce_3`, `DefaultSpec`.`reduce_4`, `DefaultSpec`.`discount_1`, `DefaultSpec`.`discount_2`, `DefaultSpec`.`discount_3`, `DefaultSpec`.`discount_4`, `DefaultSpec`.`sku`, `DefaultSpec`.`description`, `DefaultSpec`.`issetspec`, `DefaultSpec`.`oldgoodid`, `DefaultSpec`.`oldid`, `DefaultSpec`.`created`, `DefaultSpec`.`modified`, `DefaultSpec`.`article`, `DefaultSpec`.`integral` FROM `jmuv3`.`goods` AS `Good` LEFT JOIN `jmuv3`.`sellers` AS `Seller` ON (`Good`.`seller_id` = `Seller`.`id`) LEFT JOIN `jmuv3`.`stores` AS `Store` ON (`Good`.`store_id` = `Store`.`id`) LEFT JOIN `jmuv3`.`goodsviews` AS `Goodsview` ON (`Good`.`id` = `Goodsview`.`goods_id`) LEFT JOIN `jmuv3`.`specs` AS `DefaultSpec` ON (`DefaultSpec`.`issetspec` = 1 AND `Good`.`spec_id` = `DefaultSpec`.`id`) WHERE `Good`.`store_id` = 37240 AND `Good`.`isaudit` = 1 AND `Good`.`isdelete` = 0 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`recommends_stores_new_id` = 21 AND `Good`.`recommend_flag_order` != 99 ORDER BY `Good`.`recommend_flag_order` asc LIMIT 65510
42SELECT `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`.`issetspec` = 0 AND `Spec`.`goods_id` IN (177478, 220213, 215560, 223566, 222917) ORDER BY `Spec`.`created` DESC001
43SELECT `Image`.`id`, `Image`.`goods_id`, `Image`.`image`, `Image`.`thumbnail`, `Image`.`isindex` FROM `jmuv3`.`goodsimages` AS `Image` WHERE `Image`.`type` = 0 AND `Image`.`goods_id` IN (177478, 220213, 215560, 223566, 222917) ORDER BY `Image`.`created` DESC661
44SELECT `Ladderprice`.`id`, `Ladderprice`.`goods_id`, `Ladderprice`.`ordinary_black_price`, `Ladderprice`.`gold_price`, `Ladderprice`.`vip_card_price`, `Ladderprice`.`ladprice`, `Ladderprice`.`left_interval`, `Ladderprice`.`right_interval`, `Ladderprice`.`created`, `Ladderprice`.`modified` FROM `jmuv3`.`ladderprices` AS `Ladderprice` WHERE `Ladderprice`.`goods_id` IN (177478, 220213, 215560, 223566, 222917) ORDER BY `id` ASC001
45SELECT `GoodsArea`.`id`, `GoodsArea`.`goods_id`, `GoodsArea`.`city_id`, `GoodsArea`.`sale_price`, `GoodsArea`.`created`, `GoodsArea`.`modified` FROM `jmuv3`.`goods_areas` AS `GoodsArea` WHERE `GoodsArea`.`goods_id` IN (177478, 220213, 215560, 223566, 222917)5544
46SELECT `RecommendsStoresNew`.`id`, `RecommendsStoresNew`.`store_id`, `RecommendsStoresNew`.`recommend_type`, `RecommendsStoresNew`.`recommend_name`, `RecommendsStoresNew`.`innercategory_id`, `RecommendsStoresNew`.`describe`, `RecommendsStoresNew`.`isshow`, `RecommendsStoresNew`.`adimage`, `RecommendsStoresNew`.`created`, `RecommendsStoresNew`.`modified`, `RecommendsStoresNew`.`order` FROM `jmuv3`.`recommends_stores_news` AS `RecommendsStoresNew` WHERE `RecommendsStoresNew`.`id` = 21 AND `RecommendsStoresNew`.`isshow` = 1 LIMIT 1111
47SELECT `Innercategory`.`id`, `Innercategory`.`parent_id`, `Innercategory`.`store_id`, `Innercategory`.`name`, `Innercategory`.`lft`, `Innercategory`.`rght`, `Innercategory`.`order`, `Innercategory`.`isdisplay`, `Innercategory`.`isdelete`, `Innercategory`.`created`, `Innercategory`.`modified` FROM `jmuv3`.`innercategories` AS `Innercategory` WHERE `Innercategory`.`id` = 18431 LIMIT 1111
48SELECT `Innercategory`.`id`, `Innercategory`.`name` FROM `jmuv3`.`innercategories` AS `Innercategory` WHERE `Innercategory`.`store_id` = 37240 AND `Innercategory`.`isdelete` = 0 AND `Innercategory`.`isdisplay` = 1 AND `Innercategory`.`parent_id` = 18431 LIMIT 63316
49SELECT `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`, `Seller`.`id`, `Seller`.`user_id`, `Seller`.`name`, `Seller`.`code`, `Seller`.`store_id`, `Seller`.`grade`, `Seller`.`isaudit`, `Seller`.`auditment`, `Seller`.`isdelete`, `Seller`.`created`, `Seller`.`modified`, `Seller`.`source`, `Seller`.`company_property`, `Seller`.`reg_years`, `Seller`.`company_brand`, `Seller`.`registe_address`, `Seller`.`delivery_area`, `Seller`.`delivery_address`, `Seller`.`is_own_traffic`, `Seller`.`owner_id`, `Seller`.`lairage_time`, `Seller`.`open_reason`, `Seller`.`open_time`, `Store`.`id`, `Store`.`seller_id`, `Store`.`area_id`, `Store`.`category_id`, `Store`.`category_name`, `Store`.`area`, `Store`.`grade`, `Store`.`address`, `Store`.`phone`, `Store`.`logo`, `Store`.`banner`, `Store`.`name`, `Store`.`description`, `Store`.`isaudit`, `Store`.`realname`, `Store`.`id_card`, `Store`.`zipcode`, `Store`.`expired`, `Store`.`advertising`, `Store`.`mobile`, `Store`.`client_id`, `Store`.`created`, `Store`.`modified`, `Store`.`ismallbilling`, `Store`.`business_license_register`, `Store`.`business_license_valid`, `Store`.`org_code`, `Store`.`org_code_valid`, `Store`.`scope_business`, `Store`.`is_license`, `Store`.`is_contract`, `Store`.`mem_fees`, `Store`.`star_level`, `Store`.`min_buy_price`, `Store`.`free_freight_flag`, `Store`.`is_usenew`, `Store`.`style`, `Store`.`headbanner`, `Store`.`footbanner`, `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`, `DefaultSpec`.`id`, `DefaultSpec`.`store_id`, `DefaultSpec`.`goods_id`, `DefaultSpec`.`stock`, `DefaultSpec`.`unit`, `DefaultSpec`.`price`, `DefaultSpec`.`range_price`, `DefaultSpec`.`spec_1`, `DefaultSpec`.`spec_2`, `DefaultSpec`.`value_1`, `DefaultSpec`.`value_2`, `DefaultSpec`.`price_1`, `DefaultSpec`.`price_2`, `DefaultSpec`.`price_3`, `DefaultSpec`.`price_4`, `DefaultSpec`.`reduce_1`, `DefaultSpec`.`reduce_2`, `DefaultSpec`.`reduce_3`, `DefaultSpec`.`reduce_4`, `DefaultSpec`.`discount_1`, `DefaultSpec`.`discount_2`, `DefaultSpec`.`discount_3`, `DefaultSpec`.`discount_4`, `DefaultSpec`.`sku`, `DefaultSpec`.`description`, `DefaultSpec`.`issetspec`, `DefaultSpec`.`oldgoodid`, `DefaultSpec`.`oldid`, `DefaultSpec`.`created`, `DefaultSpec`.`modified`, `DefaultSpec`.`article`, `DefaultSpec`.`integral` FROM `jmuv3`.`goods` AS `Good` LEFT JOIN `jmuv3`.`sellers` AS `Seller` ON (`Good`.`seller_id` = `Seller`.`id`) LEFT JOIN `jmuv3`.`stores` AS `Store` ON (`Good`.`store_id` = `Store`.`id`) LEFT JOIN `jmuv3`.`goodsviews` AS `Goodsview` ON (`Good`.`id` = `Goodsview`.`goods_id`) LEFT JOIN `jmuv3`.`specs` AS `DefaultSpec` ON (`DefaultSpec`.`issetspec` = 1 AND `Good`.`spec_id` = `DefaultSpec`.`id`) WHERE `Good`.`store_id` = 37240 AND `Good`.`isaudit` = 1 AND `Good`.`isdelete` = 0 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`recommends_stores_new_id` = 22 AND `Good`.`recommend_flag_order` != 99 ORDER BY `Good`.`recommend_flag_order` asc LIMIT 66610
50SELECT `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`.`issetspec` = 0 AND `Spec`.`goods_id` IN (223636, 215167, 217179, 215483, 217075, 216205) ORDER BY `Spec`.`created` DESC001
51SELECT `Image`.`id`, `Image`.`goods_id`, `Image`.`image`, `Image`.`thumbnail`, `Image`.`isindex` FROM `jmuv3`.`goodsimages` AS `Image` WHERE `Image`.`type` = 0 AND `Image`.`goods_id` IN (223636, 215167, 217179, 215483, 217075, 216205) ORDER BY `Image`.`created` DESC771
52SELECT `Ladderprice`.`id`, `Ladderprice`.`goods_id`, `Ladderprice`.`ordinary_black_price`, `Ladderprice`.`gold_price`, `Ladderprice`.`vip_card_price`, `Ladderprice`.`ladprice`, `Ladderprice`.`left_interval`, `Ladderprice`.`right_interval`, `Ladderprice`.`created`, `Ladderprice`.`modified` FROM `jmuv3`.`ladderprices` AS `Ladderprice` WHERE `Ladderprice`.`goods_id` IN (223636, 215167, 217179, 215483, 217075, 216205) ORDER BY `id` ASC001
53SELECT `GoodsArea`.`id`, `GoodsArea`.`goods_id`, `GoodsArea`.`city_id`, `GoodsArea`.`sale_price`, `GoodsArea`.`created`, `GoodsArea`.`modified` FROM `jmuv3`.`goods_areas` AS `GoodsArea` WHERE `GoodsArea`.`goods_id` IN (223636, 215167, 217179, 215483, 217075, 216205)6644
54SELECT `RecommendsStoresNew`.`id`, `RecommendsStoresNew`.`store_id`, `RecommendsStoresNew`.`recommend_type`, `RecommendsStoresNew`.`recommend_name`, `RecommendsStoresNew`.`innercategory_id`, `RecommendsStoresNew`.`describe`, `RecommendsStoresNew`.`isshow`, `RecommendsStoresNew`.`adimage`, `RecommendsStoresNew`.`created`, `RecommendsStoresNew`.`modified`, `RecommendsStoresNew`.`order` FROM `jmuv3`.`recommends_stores_news` AS `RecommendsStoresNew` WHERE `RecommendsStoresNew`.`id` = 22 AND `RecommendsStoresNew`.`isshow` = 1 LIMIT 1111
55SELECT `Innercategory`.`id`, `Innercategory`.`parent_id`, `Innercategory`.`store_id`, `Innercategory`.`name`, `Innercategory`.`lft`, `Innercategory`.`rght`, `Innercategory`.`order`, `Innercategory`.`isdisplay`, `Innercategory`.`isdelete`, `Innercategory`.`created`, `Innercategory`.`modified` FROM `jmuv3`.`innercategories` AS `Innercategory` WHERE `Innercategory`.`id` = 18435 LIMIT 1111
56SELECT `Innercategory`.`id`, `Innercategory`.`name` FROM `jmuv3`.`innercategories` AS `Innercategory` WHERE `Innercategory`.`store_id` = 37240 AND `Innercategory`.`isdelete` = 0 AND `Innercategory`.`isdisplay` = 1 AND `Innercategory`.`parent_id` = 18435 LIMIT 62216
57SELECT `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`, `Seller`.`id`, `Seller`.`user_id`, `Seller`.`name`, `Seller`.`code`, `Seller`.`store_id`, `Seller`.`grade`, `Seller`.`isaudit`, `Seller`.`auditment`, `Seller`.`isdelete`, `Seller`.`created`, `Seller`.`modified`, `Seller`.`source`, `Seller`.`company_property`, `Seller`.`reg_years`, `Seller`.`company_brand`, `Seller`.`registe_address`, `Seller`.`delivery_area`, `Seller`.`delivery_address`, `Seller`.`is_own_traffic`, `Seller`.`owner_id`, `Seller`.`lairage_time`, `Seller`.`open_reason`, `Seller`.`open_time`, `Store`.`id`, `Store`.`seller_id`, `Store`.`area_id`, `Store`.`category_id`, `Store`.`category_name`, `Store`.`area`, `Store`.`grade`, `Store`.`address`, `Store`.`phone`, `Store`.`logo`, `Store`.`banner`, `Store`.`name`, `Store`.`description`, `Store`.`isaudit`, `Store`.`realname`, `Store`.`id_card`, `Store`.`zipcode`, `Store`.`expired`, `Store`.`advertising`, `Store`.`mobile`, `Store`.`client_id`, `Store`.`created`, `Store`.`modified`, `Store`.`ismallbilling`, `Store`.`business_license_register`, `Store`.`business_license_valid`, `Store`.`org_code`, `Store`.`org_code_valid`, `Store`.`scope_business`, `Store`.`is_license`, `Store`.`is_contract`, `Store`.`mem_fees`, `Store`.`star_level`, `Store`.`min_buy_price`, `Store`.`free_freight_flag`, `Store`.`is_usenew`, `Store`.`style`, `Store`.`headbanner`, `Store`.`footbanner`, `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`, `DefaultSpec`.`id`, `DefaultSpec`.`store_id`, `DefaultSpec`.`goods_id`, `DefaultSpec`.`stock`, `DefaultSpec`.`unit`, `DefaultSpec`.`price`, `DefaultSpec`.`range_price`, `DefaultSpec`.`spec_1`, `DefaultSpec`.`spec_2`, `DefaultSpec`.`value_1`, `DefaultSpec`.`value_2`, `DefaultSpec`.`price_1`, `DefaultSpec`.`price_2`, `DefaultSpec`.`price_3`, `DefaultSpec`.`price_4`, `DefaultSpec`.`reduce_1`, `DefaultSpec`.`reduce_2`, `DefaultSpec`.`reduce_3`, `DefaultSpec`.`reduce_4`, `DefaultSpec`.`discount_1`, `DefaultSpec`.`discount_2`, `DefaultSpec`.`discount_3`, `DefaultSpec`.`discount_4`, `DefaultSpec`.`sku`, `DefaultSpec`.`description`, `DefaultSpec`.`issetspec`, `DefaultSpec`.`oldgoodid`, `DefaultSpec`.`oldid`, `DefaultSpec`.`created`, `DefaultSpec`.`modified`, `DefaultSpec`.`article`, `DefaultSpec`.`integral` FROM `jmuv3`.`goods` AS `Good` LEFT JOIN `jmuv3`.`sellers` AS `Seller` ON (`Good`.`seller_id` = `Seller`.`id`) LEFT JOIN `jmuv3`.`stores` AS `Store` ON (`Good`.`store_id` = `Store`.`id`) LEFT JOIN `jmuv3`.`goodsviews` AS `Goodsview` ON (`Good`.`id` = `Goodsview`.`goods_id`) LEFT JOIN `jmuv3`.`specs` AS `DefaultSpec` ON (`DefaultSpec`.`issetspec` = 1 AND `Good`.`spec_id` = `DefaultSpec`.`id`) WHERE `Good`.`store_id` = 37240 AND `Good`.`isaudit` = 1 AND `Good`.`isdelete` = 0 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`recommends_stores_new_id` = 25 AND `Good`.`recommend_flag_order` != 99 ORDER BY `Good`.`recommend_flag_order` asc LIMIT 66610
58SELECT `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`.`issetspec` = 0 AND `Spec`.`goods_id` IN (177402, 215753, 217755, 179312, 215335, 217756) ORDER BY `Spec`.`created` DESC001
59SELECT `Image`.`id`, `Image`.`goods_id`, `Image`.`image`, `Image`.`thumbnail`, `Image`.`isindex` FROM `jmuv3`.`goodsimages` AS `Image` WHERE `Image`.`type` = 0 AND `Image`.`goods_id` IN (177402, 215753, 217755, 179312, 215335, 217756) ORDER BY `Image`.`created` DESC991
60SELECT `Ladderprice`.`id`, `Ladderprice`.`goods_id`, `Ladderprice`.`ordinary_black_price`, `Ladderprice`.`gold_price`, `Ladderprice`.`vip_card_price`, `Ladderprice`.`ladprice`, `Ladderprice`.`left_interval`, `Ladderprice`.`right_interval`, `Ladderprice`.`created`, `Ladderprice`.`modified` FROM `jmuv3`.`ladderprices` AS `Ladderprice` WHERE `Ladderprice`.`goods_id` IN (177402, 215753, 217755, 179312, 215335, 217756) ORDER BY `id` ASC001
61SELECT `GoodsArea`.`id`, `GoodsArea`.`goods_id`, `GoodsArea`.`city_id`, `GoodsArea`.`sale_price`, `GoodsArea`.`created`, `GoodsArea`.`modified` FROM `jmuv3`.`goods_areas` AS `GoodsArea` WHERE `GoodsArea`.`goods_id` IN (177402, 215753, 217755, 179312, 215335, 217756)6645
62SELECT `RecommendsStoresNew`.`id`, `RecommendsStoresNew`.`store_id`, `RecommendsStoresNew`.`recommend_type`, `RecommendsStoresNew`.`recommend_name`, `RecommendsStoresNew`.`innercategory_id`, `RecommendsStoresNew`.`describe`, `RecommendsStoresNew`.`isshow`, `RecommendsStoresNew`.`adimage`, `RecommendsStoresNew`.`created`, `RecommendsStoresNew`.`modified`, `RecommendsStoresNew`.`order` FROM `jmuv3`.`recommends_stores_news` AS `RecommendsStoresNew` WHERE `RecommendsStoresNew`.`id` = 25 AND `RecommendsStoresNew`.`isshow` = 1 LIMIT 1111
63SELECT `Innercategory`.`id`, `Innercategory`.`parent_id`, `Innercategory`.`store_id`, `Innercategory`.`name`, `Innercategory`.`lft`, `Innercategory`.`rght`, `Innercategory`.`order`, `Innercategory`.`isdisplay`, `Innercategory`.`isdelete`, `Innercategory`.`created`, `Innercategory`.`modified` FROM `jmuv3`.`innercategories` AS `Innercategory` WHERE `Innercategory`.`id` = 18432 LIMIT 1111
64SELECT `Innercategory`.`id`, `Innercategory`.`name` FROM `jmuv3`.`innercategories` AS `Innercategory` WHERE `Innercategory`.`store_id` = 37240 AND `Innercategory`.`isdelete` = 0 AND `Innercategory`.`isdisplay` = 1 AND `Innercategory`.`parent_id` = 18432 LIMIT 66616
65SELECT `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`, `Seller`.`id`, `Seller`.`user_id`, `Seller`.`name`, `Seller`.`code`, `Seller`.`store_id`, `Seller`.`grade`, `Seller`.`isaudit`, `Seller`.`auditment`, `Seller`.`isdelete`, `Seller`.`created`, `Seller`.`modified`, `Seller`.`source`, `Seller`.`company_property`, `Seller`.`reg_years`, `Seller`.`company_brand`, `Seller`.`registe_address`, `Seller`.`delivery_area`, `Seller`.`delivery_address`, `Seller`.`is_own_traffic`, `Seller`.`owner_id`, `Seller`.`lairage_time`, `Seller`.`open_reason`, `Seller`.`open_time`, `Store`.`id`, `Store`.`seller_id`, `Store`.`area_id`, `Store`.`category_id`, `Store`.`category_name`, `Store`.`area`, `Store`.`grade`, `Store`.`address`, `Store`.`phone`, `Store`.`logo`, `Store`.`banner`, `Store`.`name`, `Store`.`description`, `Store`.`isaudit`, `Store`.`realname`, `Store`.`id_card`, `Store`.`zipcode`, `Store`.`expired`, `Store`.`advertising`, `Store`.`mobile`, `Store`.`client_id`, `Store`.`created`, `Store`.`modified`, `Store`.`ismallbilling`, `Store`.`business_license_register`, `Store`.`business_license_valid`, `Store`.`org_code`, `Store`.`org_code_valid`, `Store`.`scope_business`, `Store`.`is_license`, `Store`.`is_contract`, `Store`.`mem_fees`, `Store`.`star_level`, `Store`.`min_buy_price`, `Store`.`free_freight_flag`, `Store`.`is_usenew`, `Store`.`style`, `Store`.`headbanner`, `Store`.`footbanner`, `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`, `DefaultSpec`.`id`, `DefaultSpec`.`store_id`, `DefaultSpec`.`goods_id`, `DefaultSpec`.`stock`, `DefaultSpec`.`unit`, `DefaultSpec`.`price`, `DefaultSpec`.`range_price`, `DefaultSpec`.`spec_1`, `DefaultSpec`.`spec_2`, `DefaultSpec`.`value_1`, `DefaultSpec`.`value_2`, `DefaultSpec`.`price_1`, `DefaultSpec`.`price_2`, `DefaultSpec`.`price_3`, `DefaultSpec`.`price_4`, `DefaultSpec`.`reduce_1`, `DefaultSpec`.`reduce_2`, `DefaultSpec`.`reduce_3`, `DefaultSpec`.`reduce_4`, `DefaultSpec`.`discount_1`, `DefaultSpec`.`discount_2`, `DefaultSpec`.`discount_3`, `DefaultSpec`.`discount_4`, `DefaultSpec`.`sku`, `DefaultSpec`.`description`, `DefaultSpec`.`issetspec`, `DefaultSpec`.`oldgoodid`, `DefaultSpec`.`oldid`, `DefaultSpec`.`created`, `DefaultSpec`.`modified`, `DefaultSpec`.`article`, `DefaultSpec`.`integral` FROM `jmuv3`.`goods` AS `Good` LEFT JOIN `jmuv3`.`sellers` AS `Seller` ON (`Good`.`seller_id` = `Seller`.`id`) LEFT JOIN `jmuv3`.`stores` AS `Store` ON (`Good`.`store_id` = `Store`.`id`) LEFT JOIN `jmuv3`.`goodsviews` AS `Goodsview` ON (`Good`.`id` = `Goodsview`.`goods_id`) LEFT JOIN `jmuv3`.`specs` AS `DefaultSpec` ON (`DefaultSpec`.`issetspec` = 1 AND `Good`.`spec_id` = `DefaultSpec`.`id`) WHERE `Good`.`store_id` = 37240 AND `Good`.`isaudit` = 1 AND `Good`.`isdelete` = 0 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`recommends_stores_new_id` = 23 AND `Good`.`recommend_flag_order` != 99 ORDER BY `Good`.`recommend_flag_order` asc LIMIT 66610
66SELECT `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`.`issetspec` = 0 AND `Spec`.`goods_id` IN (215862, 178332, 217463, 180692, 181604, 180745) ORDER BY `Spec`.`created` DESC001
67SELECT `Image`.`id`, `Image`.`goods_id`, `Image`.`image`, `Image`.`thumbnail`, `Image`.`isindex` FROM `jmuv3`.`goodsimages` AS `Image` WHERE `Image`.`type` = 0 AND `Image`.`goods_id` IN (215862, 178332, 217463, 180692, 181604, 180745) ORDER BY `Image`.`created` DESC11111
68SELECT `Ladderprice`.`id`, `Ladderprice`.`goods_id`, `Ladderprice`.`ordinary_black_price`, `Ladderprice`.`gold_price`, `Ladderprice`.`vip_card_price`, `Ladderprice`.`ladprice`, `Ladderprice`.`left_interval`, `Ladderprice`.`right_interval`, `Ladderprice`.`created`, `Ladderprice`.`modified` FROM `jmuv3`.`ladderprices` AS `Ladderprice` WHERE `Ladderprice`.`goods_id` IN (215862, 178332, 217463, 180692, 181604, 180745) ORDER BY `id` ASC001
69SELECT `GoodsArea`.`id`, `GoodsArea`.`goods_id`, `GoodsArea`.`city_id`, `GoodsArea`.`sale_price`, `GoodsArea`.`created`, `GoodsArea`.`modified` FROM `jmuv3`.`goods_areas` AS `GoodsArea` WHERE `GoodsArea`.`goods_id` IN (215862, 178332, 217463, 180692, 181604, 180745)6644
70SELECT `RecommendsStoresNew`.`id`, `RecommendsStoresNew`.`store_id`, `RecommendsStoresNew`.`recommend_type`, `RecommendsStoresNew`.`recommend_name`, `RecommendsStoresNew`.`innercategory_id`, `RecommendsStoresNew`.`describe`, `RecommendsStoresNew`.`isshow`, `RecommendsStoresNew`.`adimage`, `RecommendsStoresNew`.`created`, `RecommendsStoresNew`.`modified`, `RecommendsStoresNew`.`order` FROM `jmuv3`.`recommends_stores_news` AS `RecommendsStoresNew` WHERE `RecommendsStoresNew`.`id` = 23 AND `RecommendsStoresNew`.`isshow` = 1 LIMIT 1111
71SELECT `Innercategory`.`id`, `Innercategory`.`parent_id`, `Innercategory`.`store_id`, `Innercategory`.`name`, `Innercategory`.`lft`, `Innercategory`.`rght`, `Innercategory`.`order`, `Innercategory`.`isdisplay`, `Innercategory`.`isdelete`, `Innercategory`.`created`, `Innercategory`.`modified` FROM `jmuv3`.`innercategories` AS `Innercategory` WHERE `Innercategory`.`id` = 18434 LIMIT 1111
72SELECT `Innercategory`.`id`, `Innercategory`.`name` FROM `jmuv3`.`innercategories` AS `Innercategory` WHERE `Innercategory`.`store_id` = 37240 AND `Innercategory`.`isdelete` = 0 AND `Innercategory`.`isdisplay` = 1 AND `Innercategory`.`parent_id` = 18434 LIMIT 63316
73SELECT `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`, `Seller`.`id`, `Seller`.`user_id`, `Seller`.`name`, `Seller`.`code`, `Seller`.`store_id`, `Seller`.`grade`, `Seller`.`isaudit`, `Seller`.`auditment`, `Seller`.`isdelete`, `Seller`.`created`, `Seller`.`modified`, `Seller`.`source`, `Seller`.`company_property`, `Seller`.`reg_years`, `Seller`.`company_brand`, `Seller`.`registe_address`, `Seller`.`delivery_area`, `Seller`.`delivery_address`, `Seller`.`is_own_traffic`, `Seller`.`owner_id`, `Seller`.`lairage_time`, `Seller`.`open_reason`, `Seller`.`open_time`, `Store`.`id`, `Store`.`seller_id`, `Store`.`area_id`, `Store`.`category_id`, `Store`.`category_name`, `Store`.`area`, `Store`.`grade`, `Store`.`address`, `Store`.`phone`, `Store`.`logo`, `Store`.`banner`, `Store`.`name`, `Store`.`description`, `Store`.`isaudit`, `Store`.`realname`, `Store`.`id_card`, `Store`.`zipcode`, `Store`.`expired`, `Store`.`advertising`, `Store`.`mobile`, `Store`.`client_id`, `Store`.`created`, `Store`.`modified`, `Store`.`ismallbilling`, `Store`.`business_license_register`, `Store`.`business_license_valid`, `Store`.`org_code`, `Store`.`org_code_valid`, `Store`.`scope_business`, `Store`.`is_license`, `Store`.`is_contract`, `Store`.`mem_fees`, `Store`.`star_level`, `Store`.`min_buy_price`, `Store`.`free_freight_flag`, `Store`.`is_usenew`, `Store`.`style`, `Store`.`headbanner`, `Store`.`footbanner`, `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`, `DefaultSpec`.`id`, `DefaultSpec`.`store_id`, `DefaultSpec`.`goods_id`, `DefaultSpec`.`stock`, `DefaultSpec`.`unit`, `DefaultSpec`.`price`, `DefaultSpec`.`range_price`, `DefaultSpec`.`spec_1`, `DefaultSpec`.`spec_2`, `DefaultSpec`.`value_1`, `DefaultSpec`.`value_2`, `DefaultSpec`.`price_1`, `DefaultSpec`.`price_2`, `DefaultSpec`.`price_3`, `DefaultSpec`.`price_4`, `DefaultSpec`.`reduce_1`, `DefaultSpec`.`reduce_2`, `DefaultSpec`.`reduce_3`, `DefaultSpec`.`reduce_4`, `DefaultSpec`.`discount_1`, `DefaultSpec`.`discount_2`, `DefaultSpec`.`discount_3`, `DefaultSpec`.`discount_4`, `DefaultSpec`.`sku`, `DefaultSpec`.`description`, `DefaultSpec`.`issetspec`, `DefaultSpec`.`oldgoodid`, `DefaultSpec`.`oldid`, `DefaultSpec`.`created`, `DefaultSpec`.`modified`, `DefaultSpec`.`article`, `DefaultSpec`.`integral` FROM `jmuv3`.`goods` AS `Good` LEFT JOIN `jmuv3`.`sellers` AS `Seller` ON (`Good`.`seller_id` = `Seller`.`id`) LEFT JOIN `jmuv3`.`stores` AS `Store` ON (`Good`.`store_id` = `Store`.`id`) LEFT JOIN `jmuv3`.`goodsviews` AS `Goodsview` ON (`Good`.`id` = `Goodsview`.`goods_id`) LEFT JOIN `jmuv3`.`specs` AS `DefaultSpec` ON (`DefaultSpec`.`issetspec` = 1 AND `Good`.`spec_id` = `DefaultSpec`.`id`) WHERE `Good`.`store_id` = 37240 AND `Good`.`isaudit` = 1 AND `Good`.`isdelete` = 0 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`recommends_stores_new_id` = 26 AND `Good`.`recommend_flag_order` != 99 ORDER BY `Good`.`recommend_flag_order` asc LIMIT 66610
74SELECT `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`.`issetspec` = 0 AND `Spec`.`goods_id` IN (180831, 180216, 180150, 180809, 180214, 181928) ORDER BY `Spec`.`created` DESC001
75SELECT `Image`.`id`, `Image`.`goods_id`, `Image`.`image`, `Image`.`thumbnail`, `Image`.`isindex` FROM `jmuv3`.`goodsimages` AS `Image` WHERE `Image`.`type` = 0 AND `Image`.`goods_id` IN (180831, 180216, 180150, 180809, 180214, 181928) ORDER BY `Image`.`created` DESC13131
76SELECT `Ladderprice`.`id`, `Ladderprice`.`goods_id`, `Ladderprice`.`ordinary_black_price`, `Ladderprice`.`gold_price`, `Ladderprice`.`vip_card_price`, `Ladderprice`.`ladprice`, `Ladderprice`.`left_interval`, `Ladderprice`.`right_interval`, `Ladderprice`.`created`, `Ladderprice`.`modified` FROM `jmuv3`.`ladderprices` AS `Ladderprice` WHERE `Ladderprice`.`goods_id` IN (180831, 180216, 180150, 180809, 180214, 181928) ORDER BY `id` ASC001
77SELECT `GoodsArea`.`id`, `GoodsArea`.`goods_id`, `GoodsArea`.`city_id`, `GoodsArea`.`sale_price`, `GoodsArea`.`created`, `GoodsArea`.`modified` FROM `jmuv3`.`goods_areas` AS `GoodsArea` WHERE `GoodsArea`.`goods_id` IN (180831, 180216, 180150, 180809, 180214, 181928)6644
78SELECT `RecommendsStoresNew`.`id`, `RecommendsStoresNew`.`store_id`, `RecommendsStoresNew`.`recommend_type`, `RecommendsStoresNew`.`recommend_name`, `RecommendsStoresNew`.`innercategory_id`, `RecommendsStoresNew`.`describe`, `RecommendsStoresNew`.`isshow`, `RecommendsStoresNew`.`adimage`, `RecommendsStoresNew`.`created`, `RecommendsStoresNew`.`modified`, `RecommendsStoresNew`.`order` FROM `jmuv3`.`recommends_stores_news` AS `RecommendsStoresNew` WHERE `RecommendsStoresNew`.`id` = 26 AND `RecommendsStoresNew`.`isshow` = 1 LIMIT 1111
79SELECT `Innercategory`.`id`, `Innercategory`.`parent_id`, `Innercategory`.`store_id`, `Innercategory`.`name`, `Innercategory`.`lft`, `Innercategory`.`rght`, `Innercategory`.`order`, `Innercategory`.`isdisplay`, `Innercategory`.`isdelete`, `Innercategory`.`created`, `Innercategory`.`modified` FROM `jmuv3`.`innercategories` AS `Innercategory` WHERE `Innercategory`.`id` = 18436 LIMIT 1111
80SELECT `Innercategory`.`id`, `Innercategory`.`name` FROM `jmuv3`.`innercategories` AS `Innercategory` WHERE `Innercategory`.`store_id` = 37240 AND `Innercategory`.`isdelete` = 0 AND `Innercategory`.`isdisplay` = 1 AND `Innercategory`.`parent_id` = 18436 LIMIT 64416
81SELECT `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`, `Seller`.`id`, `Seller`.`user_id`, `Seller`.`name`, `Seller`.`code`, `Seller`.`store_id`, `Seller`.`grade`, `Seller`.`isaudit`, `Seller`.`auditment`, `Seller`.`isdelete`, `Seller`.`created`, `Seller`.`modified`, `Seller`.`source`, `Seller`.`company_property`, `Seller`.`reg_years`, `Seller`.`company_brand`, `Seller`.`registe_address`, `Seller`.`delivery_area`, `Seller`.`delivery_address`, `Seller`.`is_own_traffic`, `Seller`.`owner_id`, `Seller`.`lairage_time`, `Seller`.`open_reason`, `Seller`.`open_time`, `Store`.`id`, `Store`.`seller_id`, `Store`.`area_id`, `Store`.`category_id`, `Store`.`category_name`, `Store`.`area`, `Store`.`grade`, `Store`.`address`, `Store`.`phone`, `Store`.`logo`, `Store`.`banner`, `Store`.`name`, `Store`.`description`, `Store`.`isaudit`, `Store`.`realname`, `Store`.`id_card`, `Store`.`zipcode`, `Store`.`expired`, `Store`.`advertising`, `Store`.`mobile`, `Store`.`client_id`, `Store`.`created`, `Store`.`modified`, `Store`.`ismallbilling`, `Store`.`business_license_register`, `Store`.`business_license_valid`, `Store`.`org_code`, `Store`.`org_code_valid`, `Store`.`scope_business`, `Store`.`is_license`, `Store`.`is_contract`, `Store`.`mem_fees`, `Store`.`star_level`, `Store`.`min_buy_price`, `Store`.`free_freight_flag`, `Store`.`is_usenew`, `Store`.`style`, `Store`.`headbanner`, `Store`.`footbanner`, `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`, `DefaultSpec`.`id`, `DefaultSpec`.`store_id`, `DefaultSpec`.`goods_id`, `DefaultSpec`.`stock`, `DefaultSpec`.`unit`, `DefaultSpec`.`price`, `DefaultSpec`.`range_price`, `DefaultSpec`.`spec_1`, `DefaultSpec`.`spec_2`, `DefaultSpec`.`value_1`, `DefaultSpec`.`value_2`, `DefaultSpec`.`price_1`, `DefaultSpec`.`price_2`, `DefaultSpec`.`price_3`, `DefaultSpec`.`price_4`, `DefaultSpec`.`reduce_1`, `DefaultSpec`.`reduce_2`, `DefaultSpec`.`reduce_3`, `DefaultSpec`.`reduce_4`, `DefaultSpec`.`discount_1`, `DefaultSpec`.`discount_2`, `DefaultSpec`.`discount_3`, `DefaultSpec`.`discount_4`, `DefaultSpec`.`sku`, `DefaultSpec`.`description`, `DefaultSpec`.`issetspec`, `DefaultSpec`.`oldgoodid`, `DefaultSpec`.`oldid`, `DefaultSpec`.`created`, `DefaultSpec`.`modified`, `DefaultSpec`.`article`, `DefaultSpec`.`integral` FROM `jmuv3`.`goods` AS `Good` LEFT JOIN `jmuv3`.`sellers` AS `Seller` ON (`Good`.`seller_id` = `Seller`.`id`) LEFT JOIN `jmuv3`.`stores` AS `Store` ON (`Good`.`store_id` = `Store`.`id`) LEFT JOIN `jmuv3`.`goodsviews` AS `Goodsview` ON (`Good`.`id` = `Goodsview`.`goods_id`) LEFT JOIN `jmuv3`.`specs` AS `DefaultSpec` ON (`DefaultSpec`.`issetspec` = 1 AND `Good`.`spec_id` = `DefaultSpec`.`id`) WHERE `Good`.`store_id` = 37240 AND `Good`.`isaudit` = 1 AND `Good`.`isdelete` = 0 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`recommends_stores_new_id` = 24 AND `Good`.`recommend_flag_order` != 99 ORDER BY `Good`.`recommend_flag_order` asc LIMIT 66610
82SELECT `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`.`issetspec` = 0 AND `Spec`.`goods_id` IN (177732, 177734, 177736, 177752, 179953, 179960) ORDER BY `Spec`.`created` DESC001
83SELECT `Image`.`id`, `Image`.`goods_id`, `Image`.`image`, `Image`.`thumbnail`, `Image`.`isindex` FROM `jmuv3`.`goodsimages` AS `Image` WHERE `Image`.`type` = 0 AND `Image`.`goods_id` IN (177732, 177734, 177736, 177752, 179953, 179960) ORDER BY `Image`.`created` DESC16161
84SELECT `Ladderprice`.`id`, `Ladderprice`.`goods_id`, `Ladderprice`.`ordinary_black_price`, `Ladderprice`.`gold_price`, `Ladderprice`.`vip_card_price`, `Ladderprice`.`ladprice`, `Ladderprice`.`left_interval`, `Ladderprice`.`right_interval`, `Ladderprice`.`created`, `Ladderprice`.`modified` FROM `jmuv3`.`ladderprices` AS `Ladderprice` WHERE `Ladderprice`.`goods_id` IN (177732, 177734, 177736, 177752, 179953, 179960) ORDER BY `id` ASC001
85SELECT `GoodsArea`.`id`, `GoodsArea`.`goods_id`, `GoodsArea`.`city_id`, `GoodsArea`.`sale_price`, `GoodsArea`.`created`, `GoodsArea`.`modified` FROM `jmuv3`.`goods_areas` AS `GoodsArea` WHERE `GoodsArea`.`goods_id` IN (177732, 177734, 177736, 177752, 179953, 179960)6645
86SELECT `RecommendsStoresNew`.`id`, `RecommendsStoresNew`.`store_id`, `RecommendsStoresNew`.`recommend_type`, `RecommendsStoresNew`.`recommend_name`, `RecommendsStoresNew`.`innercategory_id`, `RecommendsStoresNew`.`describe`, `RecommendsStoresNew`.`isshow`, `RecommendsStoresNew`.`adimage`, `RecommendsStoresNew`.`created`, `RecommendsStoresNew`.`modified`, `RecommendsStoresNew`.`order` FROM `jmuv3`.`recommends_stores_news` AS `RecommendsStoresNew` WHERE `RecommendsStoresNew`.`id` = 24 AND `RecommendsStoresNew`.`isshow` = 1 LIMIT 1111
87SELECT `Innercategory`.`id`, `Innercategory`.`parent_id`, `Innercategory`.`store_id`, `Innercategory`.`name`, `Innercategory`.`lft`, `Innercategory`.`rght`, `Innercategory`.`order`, `Innercategory`.`isdisplay`, `Innercategory`.`isdelete`, `Innercategory`.`created`, `Innercategory`.`modified` FROM `jmuv3`.`innercategories` AS `Innercategory` WHERE `Innercategory`.`id` = 18433 LIMIT 1111
88SELECT `Innercategory`.`id`, `Innercategory`.`name` FROM `jmuv3`.`innercategories` AS `Innercategory` WHERE `Innercategory`.`store_id` = 37240 AND `Innercategory`.`isdelete` = 0 AND `Innercategory`.`isdisplay` = 1 AND `Innercategory`.`parent_id` = 18433 LIMIT 66616
89SELECT `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`, `Seller`.`id`, `Seller`.`user_id`, `Seller`.`name`, `Seller`.`code`, `Seller`.`store_id`, `Seller`.`grade`, `Seller`.`isaudit`, `Seller`.`auditment`, `Seller`.`isdelete`, `Seller`.`created`, `Seller`.`modified`, `Seller`.`source`, `Seller`.`company_property`, `Seller`.`reg_years`, `Seller`.`company_brand`, `Seller`.`registe_address`, `Seller`.`delivery_area`, `Seller`.`delivery_address`, `Seller`.`is_own_traffic`, `Seller`.`owner_id`, `Seller`.`lairage_time`, `Seller`.`open_reason`, `Seller`.`open_time`, `Store`.`id`, `Store`.`seller_id`, `Store`.`area_id`, `Store`.`category_id`, `Store`.`category_name`, `Store`.`area`, `Store`.`grade`, `Store`.`address`, `Store`.`phone`, `Store`.`logo`, `Store`.`banner`, `Store`.`name`, `Store`.`description`, `Store`.`isaudit`, `Store`.`realname`, `Store`.`id_card`, `Store`.`zipcode`, `Store`.`expired`, `Store`.`advertising`, `Store`.`mobile`, `Store`.`client_id`, `Store`.`created`, `Store`.`modified`, `Store`.`ismallbilling`, `Store`.`business_license_register`, `Store`.`business_license_valid`, `Store`.`org_code`, `Store`.`org_code_valid`, `Store`.`scope_business`, `Store`.`is_license`, `Store`.`is_contract`, `Store`.`mem_fees`, `Store`.`star_level`, `Store`.`min_buy_price`, `Store`.`free_freight_flag`, `Store`.`is_usenew`, `Store`.`style`, `Store`.`headbanner`, `Store`.`footbanner`, `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`, `DefaultSpec`.`id`, `DefaultSpec`.`store_id`, `DefaultSpec`.`goods_id`, `DefaultSpec`.`stock`, `DefaultSpec`.`unit`, `DefaultSpec`.`price`, `DefaultSpec`.`range_price`, `DefaultSpec`.`spec_1`, `DefaultSpec`.`spec_2`, `DefaultSpec`.`value_1`, `DefaultSpec`.`value_2`, `DefaultSpec`.`price_1`, `DefaultSpec`.`price_2`, `DefaultSpec`.`price_3`, `DefaultSpec`.`price_4`, `DefaultSpec`.`reduce_1`, `DefaultSpec`.`reduce_2`, `DefaultSpec`.`reduce_3`, `DefaultSpec`.`reduce_4`, `DefaultSpec`.`discount_1`, `DefaultSpec`.`discount_2`, `DefaultSpec`.`discount_3`, `DefaultSpec`.`discount_4`, `DefaultSpec`.`sku`, `DefaultSpec`.`description`, `DefaultSpec`.`issetspec`, `DefaultSpec`.`oldgoodid`, `DefaultSpec`.`oldid`, `DefaultSpec`.`created`, `DefaultSpec`.`modified`, `DefaultSpec`.`article`, `DefaultSpec`.`integral` FROM `jmuv3`.`goods` AS `Good` LEFT JOIN `jmuv3`.`sellers` AS `Seller` ON (`Good`.`seller_id` = `Seller`.`id`) LEFT JOIN `jmuv3`.`stores` AS `Store` ON (`Good`.`store_id` = `Store`.`id`) LEFT JOIN `jmuv3`.`goodsviews` AS `Goodsview` ON (`Good`.`id` = `Goodsview`.`goods_id`) LEFT JOIN `jmuv3`.`specs` AS `DefaultSpec` ON (`DefaultSpec`.`issetspec` = 1 AND `Good`.`spec_id` = `DefaultSpec`.`id`) WHERE `Good`.`store_id` = 37240 AND `Good`.`isaudit` = 1 AND `Good`.`isdelete` = 0 AND `Good`.`isshow` = 1 AND `Good`.`ishide` = 2 AND `Good`.`recommends_stores_new_id` = 41 AND `Good`.`recommend_flag_order` != 99 ORDER BY `Good`.`recommend_flag_order` asc LIMIT 66610
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`.`issetspec` = 0 AND `Spec`.`goods_id` IN (216063, 216062, 225175, 216064, 185258, 216644) ORDER BY `Spec`.`created` DESC001
91SELECT `Image`.`id`, `Image`.`goods_id`, `Image`.`image`, `Image`.`thumbnail`, `Image`.`isindex` FROM `jmuv3`.`goodsimages` AS `Image` WHERE `Image`.`type` = 0 AND `Image`.`goods_id` IN (216063, 216062, 225175, 216064, 185258, 216644) ORDER BY `Image`.`created` DESC11111
92SELECT `Ladderprice`.`id`, `Ladderprice`.`goods_id`, `Ladderprice`.`ordinary_black_price`, `Ladderprice`.`gold_price`, `Ladderprice`.`vip_card_price`, `Ladderprice`.`ladprice`, `Ladderprice`.`left_interval`, `Ladderprice`.`right_interval`, `Ladderprice`.`created`, `Ladderprice`.`modified` FROM `jmuv3`.`ladderprices` AS `Ladderprice` WHERE `Ladderprice`.`goods_id` IN (216063, 216062, 225175, 216064, 185258, 216644) ORDER BY `id` ASC001
93SELECT `GoodsArea`.`id`, `GoodsArea`.`goods_id`, `GoodsArea`.`city_id`, `GoodsArea`.`sale_price`, `GoodsArea`.`created`, `GoodsArea`.`modified` FROM `jmuv3`.`goods_areas` AS `GoodsArea` WHERE `GoodsArea`.`goods_id` IN (216063, 216062, 225175, 216064, 185258, 216644)6644
94SELECT `RecommendsStoresNew`.`id`, `RecommendsStoresNew`.`store_id`, `RecommendsStoresNew`.`recommend_type`, `RecommendsStoresNew`.`recommend_name`, `RecommendsStoresNew`.`innercategory_id`, `RecommendsStoresNew`.`describe`, `RecommendsStoresNew`.`isshow`, `RecommendsStoresNew`.`adimage`, `RecommendsStoresNew`.`created`, `RecommendsStoresNew`.`modified`, `RecommendsStoresNew`.`order` FROM `jmuv3`.`recommends_stores_news` AS `RecommendsStoresNew` WHERE `RecommendsStoresNew`.`id` = 41 AND `RecommendsStoresNew`.`isshow` = 1 LIMIT 1111
95SELECT `Innercategory`.`id`, `Innercategory`.`parent_id`, `Innercategory`.`store_id`, `Innercategory`.`name`, `Innercategory`.`lft`, `Innercategory`.`rght`, `Innercategory`.`order`, `Innercategory`.`isdisplay`, `Innercategory`.`isdelete`, `Innercategory`.`created`, `Innercategory`.`modified` FROM `jmuv3`.`innercategories` AS `Innercategory` WHERE `Innercategory`.`id` = 18457 LIMIT 1111
96SELECT `Innercategory`.`id`, `Innercategory`.`name` FROM `jmuv3`.`innercategories` AS `Innercategory` WHERE `Innercategory`.`store_id` = 37240 AND `Innercategory`.`isdelete` = 0 AND `Innercategory`.`isdisplay` = 1 AND `Innercategory`.`parent_id` = 18457 LIMIT 66616