SHOW FULL COLUMNS FROM `ds_articleclass` [ RunTime:0.002818s ]
SELECT * FROM `ds_articleclass` WHERE `ac_id` <= 7 ORDER BY `ac_sort` ASC [ RunTime:0.002480s ]
SHOW FULL COLUMNS FROM `ds_article` [ RunTime:0.001230s ]
SELECT `article`.`article_id`,`article`.`ac_id`,`article`.`article_url`,`article`.`article_title`,`article`.`article_time`,`article_class`.`ac_name`,`article_class`.`ac_parent_id` FROM `ds_article` `article` LEFT JOIN `ds_articleclass` `article_class` ON `article`.`ac_id`=`article_class`.`ac_id` WHERE ( article.article_show = '1' and (article_class.ac_id <= 7 or (article_class.ac_parent_id > 0 and article_class.ac_parent_id <= 7)) ) ORDER BY `article_sort` ASC,`article_time` DESC LIMIT 300 [ RunTime:0.001218s ]
SHOW FULL COLUMNS FROM `ds_cart` [ RunTime:0.001000s ]
SELECT * FROM `ds_cart` WHERE `buyer_id` IS NULL [ RunTime:0.002407s ]
SHOW FULL COLUMNS FROM `ds_adv` [ RunTime:0.001149s ]
SELECT * FROM `ds_adv` WHERE `ap_id` = 21 AND `adv_enabled` = 1 AND `adv_startdate` < 1653253200 AND `adv_enddate` > 1653253200 ORDER BY `adv_sort` ASC,`adv_id` ASC [ RunTime:0.000910s ]
SHOW FULL COLUMNS FROM `ds_v_goodsclass_forselect` [ RunTime:0.001181s ]
SELECT * FROM `ds_v_goodsclass_forselect` WHERE ( gc_idthree =2046 ) LIMIT 1 [ RunTime:0.000825s ]
SHOW FULL COLUMNS FROM `ds_goods` [ RunTime:0.003236s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `ds_goods` `goods` LEFT JOIN `ds_store` `store` ON `store`.`store_id`=`goods`.`store_id` WHERE `goods`.`state` <> 2 AND `goods`.`goods_state` = 1 AND `goods`.`goods_verify` = 1 AND `store`.`store_state` = 0 AND `goods`.`gc_id_3` = 2046 GROUP BY `goods`.`goods_id` ) `_group_count_` [ RunTime:0.002596s ]
SELECT `goods`.`goods_commonid`,`goods`.`goods_id`,`goods`.`gc_id_1`,`goods`.`gc_id_2`,`goods`.`gc_id_3`,`goods`.`goods_name`,`goods`.`goods_advword`,`goods`.`gc_id`,`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` FROM `ds_goods` `goods` LEFT JOIN `ds_store` `store` ON `store`.`store_id`=`goods`.`store_id` WHERE `goods`.`state` <> 2 AND `goods`.`goods_state` = 1 AND `goods`.`goods_verify` = 1 AND `store`.`store_state` = 0 AND `goods`.`gc_id_3` = 2046 GROUP BY `goods`.`goods_id` ORDER BY `goods_edittime` DESC LIMIT 0,12 [ RunTime:0.002824s ]
SHOW FULL COLUMNS FROM `ds_goodsclass` [ RunTime:0.000965s ]
SELECT `gc_name`,`gc_id` FROM `ds_goodsclass` [ RunTime:0.002563s ]
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`.`state` <> 2 AND `goods`.`goods_state` = 1 AND `goods`.`goods_verify` = 1 AND `store`.`store_state` = 0 AND `goods`.`gc_id_3` = 2046 AND `brand`.`brand_id` IS NOT NULL AND `brand`.`brand_recommend` = '1' GROUP BY `goods`.`brand_id` [ RunTime:0.001024s ]
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`.`state` <> 2 AND `goods`.`goods_state` = 1 AND `goods`.`goods_verify` = 1 AND `store`.`store_state` = 0 AND `goods`.`gc_id_3` = 2046 GROUP BY `goods`.`areaid_2` [ RunTime:0.000862s ]
SHOW FULL COLUMNS FROM `ds_goodscertificate_relation` [ RunTime:0.002497s ]
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`.`state` <> 2 AND `goods`.`goods_state` = 1 AND `goods`.`goods_verify` = 1 AND `store`.`store_state` = 0 AND `goods`.`gc_id_3` = 2046 GROUP BY `goodsrelation`.`goods_certificate_id` [ RunTime:0.000970s ]
SELECT `TDK_title`,`TDK_description` FROM `ds_goodsclass` WHERE `gc_id` = 2046 LIMIT 1 [ RunTime:0.002475s ]