[ DB ] CONNECT:[ UseTime:0.000464s ] mysql:host=127.0.0.1;port=3306;dbname=hb_dsmall;charset=utf8
[ SQL ] SHOW COLUMNS FROM `ds_goods` [ RunTime:0.001058s ]
[ SQL ] SELECT `goods_id`,`goods_name`,`goods_advword`,`goods_image`,`store_id`,`goods_promotion_price`,`goods_price` FROM `ds_goods` WHERE `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY rand() LIMIT 6 [ RunTime:0.001009s ]
[ SQL ] SHOW COLUMNS FROM `ds_pxianshigoods` [ RunTime:0.000625s ]
[ SQL ] SELECT * FROM `ds_pxianshigoods` WHERE `xianshigoods_state` = 1 AND `xianshigoods_starttime` < 1620819714 AND `xianshigoods_end_time` > 1620819714 ORDER BY xianshigoods_recommend desc LIMIT 6 [ RunTime:0.000402s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_addtime desc LIMIT 6 [ RunTime:0.002380s ]
[ SQL ] SHOW COLUMNS FROM `ds_groupbuy` [ RunTime:0.000678s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ds_groupbuy` WHERE `groupbuy_state` = 20 AND `groupbuy_starttime` < 1620819714 AND `groupbuy_endtime` > 1620819714 LIMIT 1 [ RunTime:0.000379s ]
[ SQL ] SELECT * FROM `ds_groupbuy` WHERE `groupbuy_state` = 20 AND `groupbuy_starttime` < 1620819714 AND `groupbuy_endtime` > 1620819714 ORDER BY groupbuy_recommended desc LIMIT 0,15 [ RunTime:0.000404s ]
[ SQL ] SHOW COLUMNS FROM `ds_link` [ RunTime:0.000674s ]
[ SQL ] SELECT * FROM `ds_link` ORDER BY link_sort asc [ RunTime:0.001058s ]
[ SQL ] SHOW COLUMNS FROM `ds_article` [ RunTime:0.000530s ]
[ SQL ] SELECT `a`.`article_id`,`a`.`article_url`,`a`.`article_title` FROM `ds_article` `a` INNER JOIN `ds_articleclass` `ac` ON `a`.`ac_id`=`ac`.`ac_id` WHERE `ac`.`ac_code` = 'notice' AND `a`.`article_show` = 1 ORDER BY a.article_sort asc,a.article_time desc LIMIT 3 [ RunTime:0.000422s ]
[ SQL ] SHOW COLUMNS FROM `ds_goodsclass` [ RunTime:0.000629s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE `gc_parent_id` = 0 AND `gc_show` = 1 ORDER BY gc_sort asc [ RunTime:0.000444s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=2 ) [ RunTime:0.000336s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (2,14,15,16,29,41) AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_commend desc,goods_id desc LIMIT 8 [ RunTime:0.001998s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=2 ) ORDER BY gc_sort desc LIMIT 5 [ RunTime:0.000400s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (14) AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_commend desc,goods_id desc LIMIT 8 [ RunTime:0.001927s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (15) AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_commend desc,goods_id desc LIMIT 8 [ RunTime:0.001935s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (16) AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_commend desc,goods_id desc LIMIT 8 [ RunTime:0.001918s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (29) AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_commend desc,goods_id desc LIMIT 8 [ RunTime:0.001921s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (41) AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_commend desc,goods_id desc LIMIT 8 [ RunTime:0.001930s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=3 ) [ RunTime:0.000402s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (3,18,19,21,23,26) AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_commend desc,goods_id desc LIMIT 8 [ RunTime:0.001960s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=3 ) ORDER BY gc_sort desc LIMIT 5 [ RunTime:0.000389s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (18) AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_commend desc,goods_id desc LIMIT 8 [ RunTime:0.001929s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (19) AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_commend desc,goods_id desc LIMIT 8 [ RunTime:0.001992s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (21) AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_commend desc,goods_id desc LIMIT 8 [ RunTime:0.001933s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (23) AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_commend desc,goods_id desc LIMIT 8 [ RunTime:0.001957s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (26) AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_commend desc,goods_id desc LIMIT 8 [ RunTime:0.001933s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=4 ) [ RunTime:0.000419s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (4,20,27,42,43,44) AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_commend desc,goods_id desc LIMIT 8 [ RunTime:0.001947s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=4 ) ORDER BY gc_sort desc LIMIT 5 [ RunTime:0.000374s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (20) AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_commend desc,goods_id desc LIMIT 8 [ RunTime:0.001961s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (27) AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_commend desc,goods_id desc LIMIT 8 [ RunTime:0.002117s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (42) AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_commend desc,goods_id desc LIMIT 8 [ RunTime:0.001953s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (43) AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_commend desc,goods_id desc LIMIT 8 [ RunTime:0.002328s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (44) AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_commend desc,goods_id desc LIMIT 8 [ RunTime:0.002023s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=5 ) [ RunTime:0.000419s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (5,22,28,45,46) AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_commend desc,goods_id desc LIMIT 8 [ RunTime:0.002674s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=5 ) ORDER BY gc_sort desc LIMIT 5 [ RunTime:0.000375s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (22) AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_commend desc,goods_id desc LIMIT 8 [ RunTime:0.001945s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (28) AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_commend desc,goods_id desc LIMIT 8 [ RunTime:0.002374s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (45) AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_commend desc,goods_id desc LIMIT 8 [ RunTime:0.001963s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (46) AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_commend desc,goods_id desc LIMIT 8 [ RunTime:0.001947s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=6 ) [ RunTime:0.000364s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (6,24,25,47,48) AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_commend desc,goods_id desc LIMIT 8 [ RunTime:0.002575s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=6 ) ORDER BY gc_sort desc LIMIT 5 [ RunTime:0.000380s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (24) AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_commend desc,goods_id desc LIMIT 8 [ RunTime:0.001949s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (25) AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_commend desc,goods_id desc LIMIT 8 [ RunTime:0.002261s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (47) AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_commend desc,goods_id desc LIMIT 8 [ RunTime:0.001963s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (48) AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_commend desc,goods_id desc LIMIT 8 [ RunTime:0.002383s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=7 ) [ RunTime:0.000400s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (7,30,49,50,51) AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_commend desc,goods_id desc LIMIT 8 [ RunTime:0.001993s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=7 ) ORDER BY gc_sort desc LIMIT 5 [ RunTime:0.000380s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (30) AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_commend desc,goods_id desc LIMIT 8 [ RunTime:0.002568s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (49) AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_commend desc,goods_id desc LIMIT 8 [ RunTime:0.001954s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (50) AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_commend desc,goods_id desc LIMIT 8 [ RunTime:0.001934s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (51) AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_commend desc,goods_id desc LIMIT 8 [ RunTime:0.001928s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=8 ) [ RunTime:0.000369s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (8,31,52,53) AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_commend desc,goods_id desc LIMIT 8 [ RunTime:0.001899s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=8 ) ORDER BY gc_sort desc LIMIT 5 [ RunTime:0.000389s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (31) AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_commend desc,goods_id desc LIMIT 8 [ RunTime:0.001927s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (52) AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_commend desc,goods_id desc LIMIT 8 [ RunTime:0.001934s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (53) AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_commend desc,goods_id desc LIMIT 8 [ RunTime:0.001948s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=9 ) [ RunTime:0.000399s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (9,32,54,55,56,57) AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_commend desc,goods_id desc LIMIT 8 [ RunTime:0.001983s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=9 ) ORDER BY gc_sort desc LIMIT 5 [ RunTime:0.000375s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (32) AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_commend desc,goods_id desc LIMIT 8 [ RunTime:0.001945s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (54) AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_commend desc,goods_id desc LIMIT 8 [ RunTime:0.001925s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (55) AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_commend desc,goods_id desc LIMIT 8 [ RunTime:0.001922s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (56) AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_commend desc,goods_id desc LIMIT 8 [ RunTime:0.001929s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (57) AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_commend desc,goods_id desc LIMIT 8 [ RunTime:0.001929s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=13 ) [ RunTime:0.000378s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (13,58,59,60) AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_commend desc,goods_id desc LIMIT 8 [ RunTime:0.001949s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=13 ) ORDER BY gc_sort desc LIMIT 5 [ RunTime:0.000389s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (58) AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_commend desc,goods_id desc LIMIT 8 [ RunTime:0.001931s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (59) AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_commend desc,goods_id desc LIMIT 8 [ RunTime:0.001971s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (60) AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY goods_commend desc,goods_id desc LIMIT 8 [ RunTime:0.001924s ]
[ SQL ] SHOW COLUMNS FROM `ds_advposition` [ RunTime:0.000652s ]
[ SQL ] SELECT `ap_id`,`ap_name`,`ap_width`,`ap_height` FROM `ds_advposition` [ RunTime:0.000291s ]
[ SQL ] SHOW COLUMNS FROM `ds_adv` [ RunTime:0.000597s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=1 and adv_enabled = 1 and adv_startdate < 1620799200 and adv_enddate > 1620799200 ) ORDER BY adv_sort desc LIMIT 10 [ RunTime:0.000384s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=2 and adv_enabled = 1 and adv_startdate < 1620799200 and adv_enddate > 1620799200 ) ORDER BY adv_sort desc LIMIT 10 [ RunTime:0.000394s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=8 and adv_enabled = 1 and adv_startdate < 1620799200 and adv_enddate > 1620799200 ) ORDER BY adv_sort desc LIMIT 1 [ RunTime:0.000385s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=3 and adv_enabled = 1 and adv_startdate < 1620799200 and adv_enddate > 1620799200 ) ORDER BY adv_sort desc LIMIT 1 [ RunTime:0.000394s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=9 and adv_enabled = 1 and adv_startdate < 1620799200 and adv_enddate > 1620799200 ) ORDER BY adv_sort desc LIMIT 1 [ RunTime:0.000354s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=5 and adv_enabled = 1 and adv_startdate < 1620799200 and adv_enddate > 1620799200 ) ORDER BY adv_sort desc LIMIT 1 [ RunTime:0.000403s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=10 and adv_enabled = 1 and adv_startdate < 1620799200 and adv_enddate > 1620799200 ) ORDER BY adv_sort desc LIMIT 1 [ RunTime:0.000369s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=6 and adv_enabled = 1 and adv_startdate < 1620799200 and adv_enddate > 1620799200 ) ORDER BY adv_sort desc LIMIT 1 [ RunTime:0.000396s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=11 and adv_enabled = 1 and adv_startdate < 1620799200 and adv_enddate > 1620799200 ) ORDER BY adv_sort desc LIMIT 1 [ RunTime:0.000364s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=7 and adv_enabled = 1 and adv_startdate < 1620799200 and adv_enddate > 1620799200 ) ORDER BY adv_sort desc LIMIT 1 [ RunTime:0.000479s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=12 and adv_enabled = 1 and adv_startdate < 1620799200 and adv_enddate > 1620799200 ) ORDER BY adv_sort desc LIMIT 1 [ RunTime:0.000373s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=4 and adv_enabled = 1 and adv_startdate < 1620799200 and adv_enddate > 1620799200 ) ORDER BY adv_sort desc LIMIT 1 [ RunTime:0.000364s ]
