SHOW FULL COLUMNS FROM `ds_articleclass` [ RunTime:0.001176s ]
SELECT * FROM `ds_articleclass` WHERE `ac_id` <= 7 ORDER BY `ac_sort` ASC [ RunTime:0.002612s ]
SHOW FULL COLUMNS FROM `ds_article` [ RunTime:0.001112s ]
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.003011s ]
SHOW FULL COLUMNS FROM `ds_cart` [ RunTime:0.000966s ]
SELECT * FROM `ds_cart` WHERE `buyer_id` IS NULL [ RunTime:0.002347s ]
SHOW FULL COLUMNS FROM `ds_adv` [ RunTime:0.000926s ]
SELECT * FROM `ds_adv` WHERE `ap_id` = 21 AND `adv_enabled` = 1 AND `adv_startdate` < 1653246000 AND `adv_enddate` > 1653246000 ORDER BY `adv_sort` ASC,`adv_id` ASC [ RunTime:0.002671s ]
SHOW FULL COLUMNS FROM `ds_v_goodsclass_forselect` [ RunTime:0.003202s ]
SELECT * FROM `ds_v_goodsclass_forselect` WHERE ( gc_idtwo =6 ) LIMIT 1 [ RunTime:0.002780s ]
SHOW FULL COLUMNS FROM `ds_v_storelist` [ RunTime:0.001617s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `ds_v_storelist` `v` WHERE `v`.`gc_id_2` = 6 GROUP BY `v`.`store_id` ) `_group_count_` [ RunTime:0.293519s ]
SELECT distinct v.store_id FROM `ds_v_storelist` `v` WHERE `v`.`gc_id_2` = 6 GROUP BY `v`.`store_id` LIMIT 0,10 [ RunTime:0.320958s ]
SELECT count(distinct v.store_id) as count_store,goodsclass.gc_id,goodsclass.gc_name FROM `ds_v_storelist` `v` LEFT JOIN `ds_goodsclass` `goodsclass` ON `v`.`gc_id_3`=`goodsclass`.`gc_id` WHERE `v`.`gc_id_2` = 6 AND `goodsclass`.`gc_id` IS NOT NULL AND `goodsclass`.`gc_id` IN (713,714,715,716,717,718,2003) GROUP BY `v`.`gc_id_3` [ RunTime:0.292868s ]