(default) 68 queries took 710 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`, `Store`.`food_licence_valid`, `Store`.`update_time` 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`, `Seller`.`update_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`, `Userinfo`.`update_time`, `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`, `User`.`is_changepass`, `User`.`failed_login_times`, `User`.`point`, `User`.`update_time` FROM `jmuv3`.`userinfos` AS `Userinfo` LEFT JOIN `jmuv3`.`users` AS `User` ON (`Userinfo`.`user_id` = `User`.`id`) WHERE `Userinfo`.`user_id` = 78611 LIMIT 1112
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`, `Area`.`update_time` FROM `jmuv3`.`areas` AS `Area` WHERE 1 = 1 AND `Area`.`lft` <= 6518 AND `Area`.`rght` >= 6519 ORDER BY `Area`.`lft` asc445
6SELECT `Category`.`lft`, `Category`.`rght` FROM `jmuv3`.`categories` AS `Category` WHERE `Category`.`id` = 1893 LIMIT 1111
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` asc333
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)53533
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 2002002003
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` = 21122
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`, `Innercategory`.`update_time` FROM `jmuv3`.`innercategories` AS `Innercategory` WHERE `Innercategory`.`store_id` = 37240 AND `Innercategory`.`isdelete` = 0 AND `Innercategory`.`isdisplay` = 1 ORDER BY `Innercategory`.`order` ASC404029
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`, `Store`.`food_licence_valid`, `Store`.`update_time` 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 1112
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`.`issample`, `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`, `Good`.`stock_status`, `Good`.`is_combination`, `Good`.`update_time`, `Good`.`is_video`, `Good`.`or_newfood`, `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`, `Seller`.`update_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`, `Store`.`food_licence_valid`, `Store`.`update_time`, `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`, `DefaultSpec`.`point` 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 8884
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`, `Spec`.`point` FROM `jmuv3`.`specs` AS `Spec` WHERE `Spec`.`issetspec` = 0 AND `Spec`.`goods_id` IN (230064, 217731, 229693, 233007, 233009, 233012, 233006, 232536) ORDER BY `Spec`.`created` DESC001
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 (230064, 217731, 229693, 233007, 233009, 233012, 233006, 232536) ORDER BY `Image`.`created` DESC881
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 (230064, 217731, 229693, 233007, 233009, 233012, 233006, 232536) ORDER BY `id` ASC441
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 (230064, 217731, 229693, 233007, 233009, 233012, 233006, 232536)8856
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`.`issample`, `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`, `Good`.`stock_status`, `Good`.`is_combination`, `Good`.`update_time`, `Good`.`is_video`, `Good`.`or_newfood`, `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`, `Seller`.`update_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`, `Store`.`food_licence_valid`, `Store`.`update_time`, `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`, `DefaultSpec`.`point` 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 80038
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` asc771
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`.`issample`, `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`, `Good`.`stock_status`, `Good`.`is_combination`, `Good`.`update_time`, `Good`.`is_video`, `Good`.`or_newfood`, `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`, `Seller`.`update_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`, `Store`.`food_licence_valid`, `Store`.`update_time`, `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`, `DefaultSpec`.`point` 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 32220
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`, `Spec`.`point` FROM `jmuv3`.`specs` AS `Spec` WHERE `Spec`.`issetspec` = 0 AND `Spec`.`goods_id` IN (217731, 229693) ORDER BY `Spec`.`created` DESC001
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, 229693) ORDER BY `Image`.`created` DESC221
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, 229693) ORDER BY `id` ASC441
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, 229693)2249
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`.`issample`, `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`, `Good`.`stock_status`, `Good`.`is_combination`, `Good`.`update_time`, `Good`.`is_video`, `Good`.`or_newfood`, `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`, `Seller`.`update_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`, `Store`.`food_licence_valid`, `Store`.`update_time`, `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`, `DefaultSpec`.`point` 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 65521
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`, `Spec`.`point` FROM `jmuv3`.`specs` AS `Spec` WHERE `Spec`.`issetspec` = 0 AND `Spec`.`goods_id` IN (231115, 230110, 230117, 230015, 230058) ORDER BY `Spec`.`created` DESC001
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 (231115, 230110, 230117, 230015, 230058) ORDER BY `Image`.`created` DESC551
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 (231115, 230110, 230117, 230015, 230058) 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 (231115, 230110, 230117, 230015, 230058)5549
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`.`issample`, `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`, `Good`.`stock_status`, `Good`.`is_combination`, `Good`.`update_time`, `Good`.`is_video`, `Good`.`or_newfood`, `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`, `Seller`.`update_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`, `Store`.`food_licence_valid`, `Store`.`update_time`, `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`, `DefaultSpec`.`point` 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 64419
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`, `Spec`.`point` FROM `jmuv3`.`specs` AS `Spec` WHERE `Spec`.`issetspec` = 0 AND `Spec`.`goods_id` IN (229289, 230028, 230057, 229945) ORDER BY `Spec`.`created` DESC001
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 (229289, 230028, 230057, 229945) ORDER BY `Image`.`created` DESC441
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 (229289, 230028, 230057, 229945) 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 (229289, 230028, 230057, 229945)4454
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`.`issample`, `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`, `Good`.`stock_status`, `Good`.`is_combination`, `Good`.`update_time`, `Good`.`is_video`, `Good`.`or_newfood`, `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`, `Seller`.`update_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`, `Store`.`food_licence_valid`, `Store`.`update_time`, `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`, `DefaultSpec`.`point` 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 61127
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`, `Spec`.`point` FROM `jmuv3`.`specs` AS `Spec` WHERE `Spec`.`issetspec` = 0 AND `Spec`.`goods_id` = (225773) 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` = (225773) ORDER BY `Image`.`created` DESC111
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` = (225773) 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` = (225773)1137
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`, `Innercategory`.`update_time` 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 63319
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`.`issample`, `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`, `Good`.`stock_status`, `Good`.`is_combination`, `Good`.`update_time`, `Good`.`is_video`, `Good`.`or_newfood`, `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`, `Seller`.`update_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`, `Store`.`food_licence_valid`, `Store`.`update_time`, `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`, `DefaultSpec`.`point` 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 65518
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`, `Spec`.`point` FROM `jmuv3`.`specs` AS `Spec` WHERE `Spec`.`issetspec` = 0 AND `Spec`.`goods_id` IN (231114, 215753, 225007, 215335, 177402) 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 (231114, 215753, 225007, 215335, 177402) ORDER BY `Image`.`created` DESC10101
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 (231114, 215753, 225007, 215335, 177402) 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 (231114, 215753, 225007, 215335, 177402)5546
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` = 25 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`, `Innercategory`.`update_time` FROM `jmuv3`.`innercategories` AS `Innercategory` WHERE `Innercategory`.`id` = 18432 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` = 18432 LIMIT 66616
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`.`issample`, `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`, `Good`.`stock_status`, `Good`.`is_combination`, `Good`.`update_time`, `Good`.`is_video`, `Good`.`or_newfood`, `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`, `Seller`.`update_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`, `Store`.`food_licence_valid`, `Store`.`update_time`, `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`, `DefaultSpec`.`point` 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 66621
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`, `Spec`.`point` FROM `jmuv3`.`specs` AS `Spec` WHERE `Spec`.`issetspec` = 0 AND `Spec`.`goods_id` IN (230059, 230014, 230027, 230127, 230113, 229946) 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 (230059, 230014, 230027, 230127, 230113, 229946) ORDER BY `Image`.`created` DESC661
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 (230059, 230014, 230027, 230127, 230113, 229946) 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 (230059, 230014, 230027, 230127, 230113, 229946)6651
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` = 26 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`, `Innercategory`.`update_time` FROM `jmuv3`.`innercategories` AS `Innercategory` WHERE `Innercategory`.`id` = 18436 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` = 18436 LIMIT 66619
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`.`issample`, `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`, `Good`.`stock_status`, `Good`.`is_combination`, `Good`.`update_time`, `Good`.`is_video`, `Good`.`or_newfood`, `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`, `Seller`.`update_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`, `Store`.`food_licence_valid`, `Store`.`update_time`, `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`, `DefaultSpec`.`point` 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 60017
66SELECT `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
67SELECT `Innercategory`.`id`, `Innercategory`.`parent_id`, `Innercategory`.`store_id`, `Innercategory`.`name`, `Innercategory`.`lft`, `Innercategory`.`rght`, `Innercategory`.`order`, `Innercategory`.`isdisplay`, `Innercategory`.`isdelete`, `Innercategory`.`created`, `Innercategory`.`modified`, `Innercategory`.`update_time` FROM `jmuv3`.`innercategories` AS `Innercategory` WHERE `Innercategory`.`id` = 18457 LIMIT 1111
68SELECT `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 66618