# Time: 211213 13:07:57
# User@Host: root[root] @ [10.60.0.50] Id: 311
# Query_time: 6.692598 Lock_time: 0.000494 Rows_sent: 1878 Rows_examined: 3756
SET timestamp=1639372077;
select goods_list0_.goods_store_id as goods78_2_, goods_list0_.id as id2_, goods_list0_.id as id89_1_, goods_list0_.createtime as createtime89_1_, goods_list0_.disabled as disabled89_1_, goods_list0_.activity_status as activity4_89_1_, goods_list0_.areaId as areaId89_1_, goods_list0_.audit_reason as audit6_89_1_, goods_list0_.bargain_status as bargain7_89_1_, goods_list0_.bind_status as bind8_89_1_, goods_list0_.binddiscount as binddisc9_89_1_, goods_list0_.combin_begin_time as combin10_89_1_, goods_list0_.combin_end_time as combin11_89_1_, goods_list0_.combin_price as combin12_89_1_, goods_list0_.combin_status as combin13_89_1_, goods_list0_.delivery_status as delivery14_89_1_, goods_list0_.deposit_price as deposit15_89_1_, goods_list0_.description_evaluate as descrip16_89_1_, goods_list0_.ems_trans_fee as ems17_89_1_, goods_list0_.express_trans_fee as express18_89_1_, goods_list0_.gc_id as gc75_89_1_, goods_list0_.goodsBrandName as goodsBr19_89_1_, goods_list0_.goodsClass as goodsClass89_1_, goods_list0_.goodsDetailAddress as goodsDe21_89_1_, goods_list0_.goodsId as goodsId89_1_, goods_list0_.goodsImage as goodsImage89_1_, goods_list0_.goods_price_type as goods24_89_1_, goods_list0_.goodsPromotionType as goodsPr25_89_1_, goods_list0_.goodsStoreName as goodsSt26_89_1_, goods_list0_.goodsUnit as goodsUnit89_1_, goods_list0_.goods_brand_id as goods76_89_1_, goods_list0_.goods_choice_type as goods28_89_1_, goods_list0_.goods_click as goods29_89_1_, goods_list0_.goods_collect as goods30_89_1_, goods_list0_.goods_current_price as goods31_89_1_, goods_list0_.goods_description as goods32_89_1_, goods_list0_.goods_details as goods33_89_1_, goods_list0_.goods_fee as goods34_89_1_, goods_list0_.goods_inventory as goods35_89_1_, goods_list0_.goods_inventory_detail as goods36_89_1_, goods_list0_.goods_main_photo_id as goods77_89_1_, goods_list0_.goods_name as goods37_89_1_, goods_list0_.goods_price as goods38_89_1_, goods_list0_.goods_property as goods39_89_1_, goods_list0_.goods_recommend as goods40_89_1_, goods_list0_.goods_salenum as goods41_89_1_, goods_list0_.goods_seller_time as goods42_89_1_, goods_list0_.goods_serial as goods43_89_1_, goods_list0_.goods_status as goods44_89_1_, goods_list0_.goods_store_id as goods78_89_1_, goods_list0_.goods_transfee as goods45_89_1_, goods_list0_.goods_volume as goods46_89_1_, goods_list0_.goods_weight as goods47_89_1_, goods_list0_.group_id as group79_89_1_, goods_list0_.group_buy as group48_89_1_, goods_list0_.inventory_type as inventory49_89_1_, goods_list0_.isBy as isBy89_1_, goods_list0_.isBys as isBys89_1_, goods_list0_.mail_trans_fee as mail52_89_1_, goods_list0_.minimum_quantity as minimum53_89_1_, goods_list0_.onSellTime as onSellTime89_1_, goods_list0_.seo_description as seo55_89_1_, goods_list0_.seo_keywords as seo56_89_1_, goods_list0_.stocking_period as stocking57_89_1_, goods_list0_.store_price as store58_89_1_, goods_list0_.store_recommend as store59_89_1_, goods_list0_.store_recommend_time as store60_89_1_, goods_list0_.storeempty_price as storeempty61_89_1_, goods_list0_.transport_id as transport80_89_1_, goods_list0_.weixin_shop_hot as weixin62_89_1_, goods_list0_.weixin_shop_hotTime as weixin63_89_1_, goods_list0_.weixin_shop_recommend as weixin64_89_1_, goods_list0_.weixin_shop_recommendTime as weixin65_89_1_, goods_list0_.ztc_admin_id as ztc81_89_1_, goods_list0_.ztc_admin_content as ztc66_89_1_, goods_list0_.ztc_apply_time as ztc67_89_1_, goods_list0_.ztc_begin_time as ztc68_89_1_, goods_list0_.ztc_click_num as ztc69_89_1_, goods_list0_.ztc_dredge_price as ztc70_89_1_, goods_list0_.ztc_gold as ztc71_89_1_, goods_list0_.ztc_pay_status as ztc72_89_1_, goods_list0_.ztc_price as ztc73_89_1_, goods_list0_.ztc_status as ztc74_89_1_, accessory1_.id as id101_0_, accessory1_.createtime as createtime101_0_, accessory1_.disabled as disabled101_0_, accessory1_.album_id as album13_101_0_, accessory1_.config_id as config14_101_0_, accessory1_.ext as ext101_0_, accessory1_.height as height101_0_, accessory1_.info as info101_0_, accessory1_.middle_pic_url as middle7_101_0_, accessory1_.name as name101_0_, accessory1_.path as path101_0_, accessory1_.size as size101_0_, accessory1_.small_pic_url as small11_101_0_, accessory1_.user_id as user15_101_0_, accessory1_.width as width101_0_ from jm_goods goods_list0_ left outer join jm_pic accessory1_ on goods_list0_.goods_main_photo_id=accessory1_.id where ( goods_list0_.goods_status=0) and goods_list0_.goods_store_id=6936;
# Time: 211213 13:19:18
# User@Host: root[root] @ [10.60.0.50] Id: 389
# Query_time: 19.597969 Lock_time: 0.000157 Rows_sent: 2222 Rows_examined: 4444
SET timestamp=1639372758;
select articles0_.articleClass_id as article11_1_, articles0_.id as id1_, articles0_.id as id98_0_, articles0_.createtime as createtime98_0_, articles0_.disabled as disabled98_0_, articles0_.accid as accid98_0_, articles0_.articleClass_id as article11_98_0_, articles0_.content as content98_0_, articles0_.display as display98_0_, articles0_.mark as mark98_0_, articles0_.sequence as sequence98_0_, articles0_.title as title98_0_, articles0_.url as url98_0_, articles0_.user_id as user12_98_0_ from jm_article articles0_ where articles0_.articleClass_id=163844 order by articles0_.createtime desc;
# Time: 211213 13:24:11
# User@Host: root[root] @ [10.60.0.50] Id: 137
# Query_time: 117.384021 Lock_time: 0.000181 Rows_sent: 549 Rows_examined: 6500
SET timestamp=1639373051;
select * from jm_article where 1=1 and display= 1 and articleClass_id in (select id from jm_articletype where parent_id =1 ) order by sequence asc , createtime desc;
# Time: 211213 13:26:27
# User@Host: root[root] @ [10.60.0.50] Id: 119
# Query_time: 77.948327 Lock_time: 0.000617 Rows_sent: 230 Rows_examined: 460
SET timestamp=1639373187;
select goods_list0_.goods_store_id as goods78_2_, goods_list0_.id as id2_, goods_list0_.id as id89_1_, goods_list0_.createtime as createtime89_1_, goods_list0_.disabled as disabled89_1_, goods_list0_.activity_status as activity4_89_1_, goods_list0_.areaId as areaId89_1_, goods_list0_.audit_reason as audit6_89_1_, goods_list0_.bargain_status as bargain7_89_1_, goods_list0_.bind_status as bind8_89_1_, goods_list0_.binddiscount as binddisc9_89_1_, goods_list0_.combin_begin_time as combin10_89_1_, goods_list0_.combin_end_time as combin11_89_1_, goods_list0_.combin_price as combin12_89_1_, goods_list0_.combin_status as combin13_89_1_, goods_list0_.delivery_status as delivery14_89_1_, goods_list0_.deposit_price as deposit15_89_1_, goods_list0_.description_evaluate as descrip16_89_1_, goods_list0_.ems_trans_fee as ems17_89_1_, goods_list0_.express_trans_fee as express18_89_1_, goods_list0_.gc_id as gc75_89_1_, goods_list0_.goodsBrandName as goodsBr19_89_1_, goods_list0_.goodsClass as goodsClass89_1_, goods_list0_.goodsDetailAddress as goodsDe21_89_1_, goods_list0_.goodsId as goodsId89_1_, goods_list0_.goodsImage as goodsImage89_1_, goods_list0_.goods_price_type as goods24_89_1_, goods_list0_.goodsPromotionType as goodsPr25_89_1_, goods_list0_.goodsStoreName as goodsSt26_89_1_, goods_list0_.goodsUnit as goodsUnit89_1_, goods_list0_.goods_brand_id as goods76_89_1_, goods_list0_.goods_choice_type as goods28_89_1_, goods_list0_.goods_click as goods29_89_1_, goods_list0_.goods_collect as goods30_89_1_, goods_list0_.goods_current_price as goods31_89_1_, goods_list0_.goods_description as goods32_89_1_, goods_list0_.goods_details as goods33_89_1_, goods_list0_.goods_fee as goods34_89_1_, goods_list0_.goods_inventory as goods35_89_1_, goods_list0_.goods_inventory_detail as goods36_89_1_, goods_list0_.goods_main_photo_id as goods77_89_1_, goods_list0_.goods_name as goods37_89_1_, goods_list0_.goods_price as goods38_89_1_, goods_list0_.goods_property as goods39_89_1_, goods_list0_.goods_recommend as goods40_89_1_, goods_list0_.goods_salenum as goods41_89_1_, goods_list0_.goods_seller_time as goods42_89_1_, goods_list0_.goods_serial as goods43_89_1_, goods_list0_.goods_status as goods44_89_1_, goods_list0_.goods_store_id as goods78_89_1_, goods_list0_.goods_transfee as goods45_89_1_, goods_list0_.goods_volume as goods46_89_1_, goods_list0_.goods_weight as goods47_89_1_, goods_list0_.group_id as group79_89_1_, goods_list0_.group_buy as group48_89_1_, goods_list0_.inventory_type as inventory49_89_1_, goods_list0_.isBy as isBy89_1_, goods_list0_.isBys as isBys89_1_, goods_list0_.mail_trans_fee as mail52_89_1_, goods_list0_.minimum_quantity as minimum53_89_1_, goods_list0_.onSellTime as onSellTime89_1_, goods_list0_.seo_description as seo55_89_1_, goods_list0_.seo_keywords as seo56_89_1_, goods_list0_.stocking_period as stocking57_89_1_, goods_list0_.store_price as store58_89_1_, goods_list0_.store_recommend as store59_89_1_, goods_list0_.store_recommend_time as store60_89_1_, goods_list0_.storeempty_price as storeempty61_89_1_, goods_list0_.transport_id as transport80_89_1_, goods_list0_.weixin_shop_hot as weixin62_89_1_, goods_list0_.weixin_shop_hotTime as weixin63_89_1_, goods_list0_.weixin_shop_recommend as weixin64_89_1_, goods_list0_.weixin_shop_recommendTime as weixin65_89_1_, goods_list0_.ztc_admin_id as ztc81_89_1_, goods_list0_.ztc_admin_content as ztc66_89_1_, goods_list0_.ztc_apply_time as ztc67_89_1_, goods_list0_.ztc_begin_time as ztc68_89_1_, goods_list0_.ztc_click_num as ztc69_89_1_, goods_list0_.ztc_dredge_price as ztc70_89_1_, goods_list0_.ztc_gold as ztc71_89_1_, goods_list0_.ztc_pay_status as ztc72_89_1_, goods_list0_.ztc_price as ztc73_89_1_, goods_list0_.ztc_status as ztc74_89_1_, accessory1_.id as id101_0_, accessory1_.createtime as createtime101_0_, accessory1_.disabled as disabled101_0_, accessory1_.album_id as album13_101_0_, accessory1_.config_id as config14_101_0_, accessory1_.ext as ext101_0_, accessory1_.height as height101_0_, accessory1_.info as info101_0_, accessory1_.middle_pic_url as middle7_101_0_, accessory1_.name as name101_0_, accessory1_.path as path101_0_, accessory1_.size as size101_0_, accessory1_.small_pic_url as small11_101_0_, accessory1_.user_id as user15_101_0_, accessory1_.width as width101_0_ from jm_goods goods_list0_ left outer join jm_pic accessory1_ on goods_list0_.goods_main_photo_id=accessory1_.id where ( goods_list0_.goods_status=0) and goods_list0_.goods_store_id=6936;
【无标题】
最新推荐文章于 2024-09-04 20:48:11 发布