SHOW FULL COLUMNS FROM `ds_cart` [ RunTime:0.004469s ]
SELECT * FROM `ds_cart` WHERE `buyer_id` IS NULL [ RunTime:0.000709s ]
SHOW FULL COLUMNS FROM `ds_adv` [ RunTime:0.004328s ]
SELECT `adv_id`,`ap_id`,`adv_title`,`adv_link`,`adv_code`,`adv_startdate`,`adv_enddate`,`adv_sort`,`adv_enabled`,`adv_clicknum`,`adv_bgcolor`,`adv_provestatus`,`adv_createtime`,`adv_priority`,`adv_abstract`,`createuser`,`update_user`,`update_time` FROM `ds_adv` WHERE `ap_id` = 1 AND `adv_enabled` = 1 AND `adv_startdate` < 1728961200 AND `adv_enddate` > 1728961200 ORDER BY `adv_sort` ASC,`adv_id` ASC [ RunTime:0.000873s ]
SELECT `adv_id`,`ap_id`,`adv_title`,`adv_link`,`adv_code`,`adv_startdate`,`adv_enddate`,`adv_sort`,`adv_enabled`,`adv_clicknum`,`adv_bgcolor`,`adv_provestatus`,`adv_createtime`,`adv_priority`,`adv_abstract`,`createuser`,`update_user`,`update_time` FROM `ds_adv` WHERE `ap_id` = 90 AND `adv_enabled` = 1 AND `adv_startdate` < 1728961200 AND `adv_enddate` > 1728961200 ORDER BY `adv_sort` ASC,`adv_id` ASC [ RunTime:0.004301s ]
SHOW FULL COLUMNS FROM `ds_search_adv` [ RunTime:0.001086s ]
SELECT `adv_id`,`adv_type`,`keywords`,`adv_title`,`adv_link`,`adv_startdate`,`adv_enddate`,`adv_sort`,`adv_enabled`,`adv_clicknum`,`adv_provestatus`,`adv_createtime`,`goods_id` FROM `ds_search_adv` WHERE `adv_type` = 1 AND `adv_enabled` = 1 AND `adv_startdate` < 1728961200 AND `adv_enddate` > 1728961200 ORDER BY `adv_id` DESC [ RunTime:0.004296s ]
SHOW FULL COLUMNS FROM `ds_applet` [ RunTime:0.000855s ]
SELECT `app_state` FROM `ds_applet` WHERE `member_id` IS NULL LIMIT 1 [ RunTime:0.004364s ]
SHOW FULL COLUMNS FROM `ds_articlehelpclass` [ RunTime:0.000810s ]
SELECT `ac_help_id`,`ac_code`,`ac_name`,`ac_parent_id`,`ac_sort` FROM `ds_articlehelpclass` WHERE `ac_help_id` NOT IN (7,8,9) ORDER BY ac_parent_id ASC, CASE WHEN ac_sort IS NULL THEN 1 ELSE 0 END ASC, ac_sort ASC, ac_help_id ASC [ RunTime:0.004207s ]
SHOW FULL COLUMNS FROM `ds_articlehelp` [ RunTime:0.000789s ]
SELECT `articlehelp_id`,`ac_help_id`,`article_url`,`article_show`,`article_sort`,`article_title`,`article_content`,`article_time`,`article_pic` FROM `ds_articlehelp` WHERE `article_show` = 1 AND `ac_help_id` NOT IN (7,8,9) ORDER BY `article_sort` [ RunTime:0.008339s ]
SHOW FULL COLUMNS FROM `ds_link` [ RunTime:0.000840s ]
SELECT * FROM `ds_link` ORDER BY IF(link_sort IS NULL, 1, 0) asc, link_sort asc [ RunTime:0.004214s ]
SHOW FULL COLUMNS FROM `ds_config` [ RunTime:0.000808s ]
SELECT * FROM `ds_config` [ RunTime:0.004270s ]
SHOW FULL COLUMNS FROM `ds_v_goodsclass_forselect` [ RunTime:0.000965s ]
SELECT * FROM `ds_v_goodsclass_forselect` WHERE ( gc_idthree =2064 ) LIMIT 1 [ RunTime:0.004435s ]
SHOW FULL COLUMNS FROM `ds_company_introduction` [ RunTime:0.001098s ]
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` = '2064' AND `store`.`store_state` = '0' GROUP BY `company`.`store_id` ) `_group_count_` [ RunTime:0.014146s ]
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` = '2064' AND `store`.`store_state` = '0' GROUP BY `company`.`store_id` LIMIT 0,10 [ RunTime:0.011240s ]
SHOW FULL COLUMNS FROM `ds_favorites` [ RunTime:0.004565s ]
SELECT * FROM `ds_favorites` WHERE `fav_id` = 100958 AND `fav_type` = 'store' AND `member_id` IS NULL LIMIT 1 [ RunTime:0.000879s ]
SELECT * FROM `ds_favorites` WHERE `fav_id` = 101935 AND `fav_type` = 'store' AND `member_id` IS NULL LIMIT 1 [ RunTime:0.004189s ]
SELECT * FROM `ds_favorites` WHERE `fav_id` = 119533 AND `fav_type` = 'store' AND `member_id` IS NULL LIMIT 1 [ RunTime:0.000658s ]
SELECT * FROM `ds_favorites` WHERE `fav_id` = 100958 AND `fav_type` = 'store' AND `member_id` IS NULL LIMIT 1 [ RunTime:0.004319s ]
SELECT * FROM `ds_favorites` WHERE `fav_id` = 101935 AND `fav_type` = 'store' AND `member_id` IS NULL LIMIT 1 [ RunTime:0.000799s ]
SELECT * FROM `ds_favorites` WHERE `fav_id` = 119533 AND `fav_type` = 'store' AND `member_id` IS NULL LIMIT 1 [ RunTime:0.004118s ]
SHOW FULL COLUMNS FROM `ds_goodsclass` [ RunTime:0.000903s ]
SELECT `gc_name`,`gc_id` FROM `ds_goodsclass` [ RunTime:0.004190s ]
SELECT `sj`.`auth_verify`,`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`,masternum.name num,`company`.`register_no`,`company`.`legal_person`,company.year AS year,`company`.`registration_authority`,`company`.`registration_status`,`company`.`business_scope`,`store`.`grade_id`,`company`.`ty_name`,`company`.`ty_legalPersonName`,`company`.`ty_regStatus`,`company`.`ty_estiblishTime`,`company`.`ty_regCapital`,`company`.`ty_regNumber`,`company`.`ty_creditCode`,`company`.`ty_toTime`,`company`.`ty_approvedTime`,`company`.`ty_companyOrgType`,`company`.`ty_staffNumRange`,`company`.`ty_regInstitute`,`company`.`ty_regLocation`,`company`.`ty_businessScope`,`company`.`ty_id`,`company`.`ty_checkflg`,`area`.`area_name`,area1.area_name as area_name1,area2.area_name as area_name2,`company`.`company_province_id` 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_master` `masternum` ON `masternum`.`status`=0 and masternum.id=company.num and masternum.type = "YGRS" 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 ('100958','101935','119533') GROUP BY `company`.`store_id` [ RunTime:0.002911s ]
SHOW FULL COLUMNS FROM `ds_hottags` [ RunTime:0.004350s ]
SELECT * FROM `ds_hottags` ORDER BY CASE WHEN hottags_sort = 0 THEN hottags_id ELSE hottags_sort END ASC [ RunTime:0.000770s ]
SHOW FULL COLUMNS FROM `ds_goods` [ RunTime:0.004776s ]
SELECT `img_thumb_one`,`img_thumb_two`,`img_thumb_three` FROM `ds_goods` WHERE `goods_id` = 149472 LIMIT 1 [ RunTime:0.000608s ]
SELECT `img_thumb_one`,`img_thumb_two`,`img_thumb_three` FROM `ds_goods` WHERE `goods_id` = 149471 LIMIT 1 [ RunTime:0.004116s ]
SELECT `img_thumb_one`,`img_thumb_two`,`img_thumb_three` FROM `ds_goods` WHERE `goods_id` = 149470 LIMIT 1 [ RunTime:0.000565s ]
SELECT `img_thumb_one`,`img_thumb_two`,`img_thumb_three` FROM `ds_goods` WHERE `goods_id` = 141857 LIMIT 1 [ RunTime:0.004105s ]
SELECT `img_thumb_one`,`img_thumb_two`,`img_thumb_three` FROM `ds_goods` WHERE `goods_id` = 141856 LIMIT 1 [ RunTime:0.000544s ]
SELECT `img_thumb_one`,`img_thumb_two`,`img_thumb_three` FROM `ds_goods` WHERE `goods_id` = 132866 LIMIT 1 [ RunTime:0.004112s ]
SELECT `img_thumb_one`,`img_thumb_two`,`img_thumb_three` FROM `ds_goods` WHERE `goods_id` = 149044 LIMIT 1 [ RunTime:0.000572s ]