SHOW FULL COLUMNS FROM `ds_cart` [ RunTime:0.001101s ]
SELECT * FROM `ds_cart` WHERE `buyer_id` IS NULL [ RunTime:0.003686s ]
SHOW FULL COLUMNS FROM `ds_adv` [ RunTime:0.000824s ]
SELECT * FROM `ds_adv` WHERE `ap_id` = 21 AND `adv_enabled` = 1 AND `adv_startdate` < 1728687600 AND `adv_enddate` > 1728687600 ORDER BY `adv_sort` ASC,`adv_id` ASC [ RunTime:0.003709s ]
SHOW FULL COLUMNS FROM `ds_v_goodsclass_forselect` [ RunTime:0.000940s ]
SELECT * FROM `ds_v_goodsclass_forselect` WHERE ( gc_idthree =1150 ) LIMIT 1 [ RunTime:0.003677s ]
SHOW FULL COLUMNS FROM `ds_goods_global_search` [ RunTime:0.000863s ]
SELECT COUNT(*)
FROM ds_goods_global_search
WHERE gc_id_3 = '1150' [ RunTime:0.012244s ]
SELECT COUNT(*) AS think_count FROM ( SELECT `goods`.`goods_commonid`,`goods`.`goods_id`,`goods`.`goods_name`,`goods`.`goods_advword`,`goods`.`gc_id`,`goods`.`gc_id_1`,`goods`.`gc_id_2`,`goods`.`gc_id_3`,`goods`.`store_id`,`goods`.`price`,`goods`.`goods_promotion_price`,`goods`.`goods_promotion_type`,`goods`.`goods_marketprice`,`goods`.`goods_storage`,`goods`.`goods_image`,`goods`.`goods_freight`,`goods`.`goods_salenum`,`goods`.`color_id`,`goods`.`evaluation_good_star`,`goods`.`evaluation_count`,`goods`.`is_virtual`,`goods`.`is_goodsfcode`,`goods`.`is_appoint`,`goods`.`is_presell`,`goods`.`is_have_gift`,`goods`.`product_param_content`,(
SELECT COUNT(*)
FROM ds_goods_global_search
WHERE gc_id_3 = 1150 AND store_id = goods.store_id AND goods_edittime > goods.goods_edittime
) + 1 AS rownum,`goods_edittime` FROM `ds_goods_global_search` `goods` WHERE `goods`.`gc_id_3` = '1150' ) `t1` WHERE `t1`.`rownum` = '1' [ RunTime:0.023633s ]
SELECT * FROM ( SELECT `goods`.`goods_commonid`,`goods`.`goods_id`,`goods`.`goods_name`,`goods`.`goods_advword`,`goods`.`gc_id`,`goods`.`gc_id_1`,`goods`.`gc_id_2`,`goods`.`gc_id_3`,`goods`.`store_id`,`goods`.`price`,`goods`.`goods_promotion_price`,`goods`.`goods_promotion_type`,`goods`.`goods_marketprice`,`goods`.`goods_storage`,`goods`.`goods_image`,`goods`.`goods_freight`,`goods`.`goods_salenum`,`goods`.`color_id`,`goods`.`evaluation_good_star`,`goods`.`evaluation_count`,`goods`.`is_virtual`,`goods`.`is_goodsfcode`,`goods`.`is_appoint`,`goods`.`is_presell`,`goods`.`is_have_gift`,`goods`.`product_param_content`,(
SELECT COUNT(*)
FROM ds_goods_global_search
WHERE gc_id_3 = 1150 AND store_id = goods.store_id AND goods_edittime > goods.goods_edittime
) + 1 AS rownum,`goods_edittime` FROM `ds_goods_global_search` `goods` WHERE `goods`.`gc_id_3` = '1150' ) `t1` WHERE `t1`.`rownum` = '1' ORDER BY `t1`.`goods_edittime` DESC LIMIT 0,12 [ RunTime:0.028625s ]
SHOW FULL COLUMNS FROM `ds_store` [ RunTime:0.001418s ]
SELECT `store_id`,`member_id`,`store_name` FROM `ds_store` WHERE `store_id` IN (99112,78086,120777,119502,119638,91990,120729,99105,85281,99258,120576,99144) [ RunTime:0.003802s ]
SHOW FULL COLUMNS FROM `ds_company_introduction` [ RunTime:0.001079s ]
SELECT company.ty_name,company.store_id,company.shopname,mastertype.name companytype,
company.ptype, company.year, masterusd.name yearmoney,
company.introduce,company.company_address,company.company_address_detail,
company.num,company.register_no,company.legal_person,
date_format( from_unixtime( company.year ), "%Y-%m-%d" ) AS year,
company.registration_authority,company.registration_status,
company.business_scope,store.grade_id,company.tel,
area.area_name,area1.area_name as area_name1,area2.area_name as area_name2,company.company_province_id,sj.auth_verify FROM `ds_company_introduction` `company` LEFT JOIN `ds_store` `store` ON `store`.`store_id`=`company`.`store_id` LEFT JOIN `ds_goodsclass` `class` ON FIND_IN_SET( class.gc_id, company.ptype ) LEFT JOIN `ds_master` `masterusd` ON `masterusd`.`status`=0 and masterusd.id=company.yearmoney and masterusd.type = "zczj" LEFT JOIN `ds_master` `mastertype` ON `mastertype`.`status`=0 and mastertype.id=company.companytype and mastertype.type = "QYLX" LEFT JOIN `ds_area` `area` ON `area`.`area_id`=`company`.`company_province_id` LEFT JOIN `ds_area` `area1` ON `area1`.`area_id`=`company`.`company_city_id` LEFT JOIN `ds_area` `area2` ON `area2`.`area_id`=`company`.`company_area_id` LEFT JOIN `ds_storejoinin` `sj` ON `company`.`userid`=`sj`.`member_id` WHERE `company`.`store_id` IN ('99112','78086','120777','119502','119638','91990','120729','99105','85281','99258','120576','99144') GROUP BY `company`.`store_id` [ RunTime:0.010009s ]
SHOW FULL COLUMNS FROM `ds_goodsclass` [ RunTime:0.001062s ]
SELECT `gc_name`,`gc_id` FROM `ds_goodsclass` [ RunTime:0.003773s ]
SHOW FULL COLUMNS FROM `ds_goods` [ RunTime:0.001190s ]
SELECT count(goods.goods_id) as count_goods,brand.brand_id,brand.brand_name FROM `ds_goods` `goods` LEFT JOIN `ds_store` `store` ON `store`.`store_id`=`goods`.`store_id` LEFT JOIN `ds_brand` `brand` ON `goods`.`brand_id`=`brand`.`brand_id` WHERE `goods`.`gc_id_3` = '1150' AND `brand`.`brand_id` IS NOT NULL AND `brand`.`brand_recommend` = '1' GROUP BY `goods`.`brand_id` [ RunTime:0.004217s ]
SELECT count(goods.goods_id) as count_goods,area.area_id,area.area_name FROM `ds_goods` `goods` LEFT JOIN `ds_store` `store` ON `store`.`store_id`=`goods`.`store_id` LEFT JOIN `ds_area` `area` ON `goods`.`areaid_2`=`area`.`area_id` WHERE `area`.`area_id` IS NOT NULL AND `goods`.`gc_id_3` = '1150' GROUP BY `goods`.`areaid_2` [ RunTime:0.001373s ]
SHOW FULL COLUMNS FROM `ds_goodscertificate_relation` [ RunTime:0.003869s ]
SELECT count(goodsrelation.goods_id) as count_goods,storecer.store_certificate_id goods_certificate_id,storecer.name FROM `ds_goodscertificate_relation` `goodsrelation` LEFT JOIN `ds_store_certificate` `storecer` ON `goodsrelation`.`goods_certificate_id`=`storecer`.`store_certificate_id` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_id`=`goodsrelation`.`goods_id` LEFT JOIN `ds_store` `store` ON `store`.`store_id`=`goods`.`store_id` WHERE `storecer`.`store_certificate_id` IS NOT NULL AND `goods`.`gc_id_3` = '1150' GROUP BY `goodsrelation`.`goods_certificate_id` [ RunTime:0.034984s ]
SELECT `TDK_title`,`TDK_description` FROM `ds_goodsclass` WHERE `gc_id` = 1150 LIMIT 1 [ RunTime:0.000680s ]
SELECT `img_thumb_one`,`img_thumb_two`,`img_thumb_three` FROM `ds_goods` WHERE `goods_id` = 151934 LIMIT 1 [ RunTime:0.003605s ]
SELECT `img_thumb_one`,`img_thumb_two`,`img_thumb_three` FROM `ds_goods` WHERE `goods_id` = 144323 LIMIT 1 [ RunTime:0.003602s ]
SELECT `img_thumb_one`,`img_thumb_two`,`img_thumb_three` FROM `ds_goods` WHERE `goods_id` = 150547 LIMIT 1 [ RunTime:0.000599s ]
SELECT `img_thumb_one`,`img_thumb_two`,`img_thumb_three` FROM `ds_goods` WHERE `goods_id` = 147061 LIMIT 1 [ RunTime:0.003546s ]
SELECT `img_thumb_one`,`img_thumb_two`,`img_thumb_three` FROM `ds_goods` WHERE `goods_id` = 146993 LIMIT 1 [ RunTime:0.000715s ]
SELECT `img_thumb_one`,`img_thumb_two`,`img_thumb_three` FROM `ds_goods` WHERE `goods_id` = 144531 LIMIT 1 [ RunTime:0.003500s ]
SELECT `img_thumb_one`,`img_thumb_two`,`img_thumb_three` FROM `ds_goods` WHERE `goods_id` = 150263 LIMIT 1 [ RunTime:0.000708s ]
SELECT `img_thumb_one`,`img_thumb_two`,`img_thumb_three` FROM `ds_goods` WHERE `goods_id` = 146191 LIMIT 1 [ RunTime:0.003565s ]
SELECT `img_thumb_one`,`img_thumb_two`,`img_thumb_three` FROM `ds_goods` WHERE `goods_id` = 141804 LIMIT 1 [ RunTime:0.000565s ]
SELECT `img_thumb_one`,`img_thumb_two`,`img_thumb_three` FROM `ds_goods` WHERE `goods_id` = 118799 LIMIT 1 [ RunTime:0.003632s ]
SELECT `img_thumb_one`,`img_thumb_two`,`img_thumb_three` FROM `ds_goods` WHERE `goods_id` = 149833 LIMIT 1 [ RunTime:0.000604s ]
SELECT `img_thumb_one`,`img_thumb_two`,`img_thumb_three` FROM `ds_goods` WHERE `goods_id` = 104696 LIMIT 1 [ RunTime:0.003584s ]