SHOW FULL COLUMNS FROM `ds_cart` [ RunTime:0.000790s ]
SELECT * FROM `ds_cart` WHERE `buyer_id` IS NULL [ RunTime:0.000670s ]
SHOW FULL COLUMNS FROM `ds_adv` [ RunTime:0.000849s ]
SELECT * FROM `ds_adv` WHERE `ap_id` = 21 AND `adv_enabled` = 1 AND `adv_startdate` < 1728694800 AND `adv_enddate` > 1728694800 ORDER BY `adv_sort` ASC,`adv_id` ASC [ RunTime:0.002637s ]
SHOW FULL COLUMNS FROM `ds_v_goodsclass_forselect` [ RunTime:0.001122s ]
SELECT * FROM `ds_v_goodsclass_forselect` WHERE ( gc_idthree =711 ) LIMIT 1 [ RunTime:0.002486s ]
SHOW FULL COLUMNS FROM `ds_company_introduction` [ RunTime:0.000999s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `ds_company_introduction` `company` LEFT JOIN `ds_store` `store` ON `store`.`store_id`=`company`.`store_id` LEFT JOIN `ds_goods_global_search` `v` ON `company`.`store_id`=`v`.`store_id` WHERE `v`.`gc_id_3` = '711' AND `store`.`store_state` = '0' GROUP BY `company`.`store_id` ) `_group_count_` [ RunTime:0.012414s ]
SELECT company.store_id AS store_id,company.shopname AS shopname,company.companytype AS companytype,company.yearmoney AS yearmoney,company.shoplimit AS shoplimit FROM `ds_company_introduction` `company` LEFT JOIN `ds_store` `store` ON `store`.`store_id`=`company`.`store_id` LEFT JOIN `ds_goods_global_search` `v` ON `company`.`store_id`=`v`.`store_id` WHERE `v`.`gc_id_3` = '711' AND `store`.`store_state` = '0' GROUP BY `company`.`store_id` LIMIT 0,10 [ RunTime:0.010633s ]
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 ('77541','119614') GROUP BY `company`.`store_id` [ RunTime:0.004097s ]
SHOW FULL COLUMNS FROM `ds_goods` [ RunTime:0.001300s ]
SELECT COUNT(*) AS think_count FROM `ds_goods` WHERE ( store_id=77541 ) [ RunTime:0.002494s ]
SELECT COUNT(*) AS think_count FROM `ds_goods` WHERE ( store_id=119614 ) [ RunTime:0.000793s ]