[ DB ] CONNECT:[ UseTime:0.001017s ] mysql:host=47.107.151.200;port=3306;dbname=hb_dsmall;charset=utf8
[ SQL ] SHOW COLUMNS FROM `ds_navigation` [ RunTime:0.001136s ]
[ SQL ] SELECT * FROM `ds_navigation` ORDER BY `nav_sort` [ RunTime:0.000641s ]
[ SQL ] SHOW COLUMNS FROM `ds_goods` [ RunTime:0.001263s ]
[ 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.001825s ]
[ SQL ] SHOW COLUMNS FROM `ds_pxianshigoods` [ RunTime:0.001004s ]
[ SQL ] SELECT * FROM `ds_pxianshigoods` WHERE `xianshigoods_state` = 1 AND `xianshigoods_starttime` < 1566395965 AND `xianshigoods_end_time` > 1566395965 ORDER BY xianshigoods_recommend desc LIMIT 6 [ RunTime:0.000908s ]
[ 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.005717s ]
[ SQL ] SHOW COLUMNS FROM `ds_groupbuy` [ RunTime:0.001015s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ds_groupbuy` WHERE `groupbuy_state` = 20 AND `groupbuy_starttime` < 1566395965 AND `groupbuy_endtime` > 1566395965 LIMIT 1 [ RunTime:0.000653s ]
[ SQL ] SELECT * FROM `ds_groupbuy` WHERE `groupbuy_state` = 20 AND `groupbuy_starttime` < 1566395965 AND `groupbuy_endtime` > 1566395965 ORDER BY groupbuy_recommended desc LIMIT 0,15 [ RunTime:0.000833s ]
[ SQL ] SHOW COLUMNS FROM `ds_link` [ RunTime:0.000850s ]
[ SQL ] SELECT * FROM `ds_link` ORDER BY link_sort asc [ RunTime:0.000492s ]
[ SQL ] SHOW COLUMNS FROM `ds_article` [ RunTime:0.000868s ]
[ 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.000611s ]
[ SQL ] SHOW COLUMNS FROM `ds_goodsclass` [ RunTime:0.000840s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE `gc_parent_id` = 0 AND `gc_show` = 1 ORDER BY gc_sort asc [ RunTime:0.000560s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=2 ) [ RunTime:0.000536s ]
[ 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.002695s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=2 ) ORDER BY gc_sort desc LIMIT 5 [ RunTime:0.000554s ]
[ 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.002326s ]
[ 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.002159s ]
[ 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.002106s ]
[ 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.002195s ]
[ 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.002124s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=3 ) [ RunTime:0.000561s ]
[ 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.002539s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=3 ) ORDER BY gc_sort desc LIMIT 5 [ RunTime:0.000551s ]
[ 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.002093s ]
[ 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.002197s ]
[ 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.002827s ]
[ 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.002155s ]
[ 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.002090s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=4 ) [ RunTime:0.000552s ]
[ 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.002528s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=4 ) ORDER BY gc_sort desc LIMIT 5 [ RunTime:0.000549s ]
[ 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.002085s ]
[ 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.002979s ]
[ 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.002991s ]
[ 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.002112s ]
[ 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.002157s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=5 ) [ RunTime:0.000544s ]
[ 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.002486s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=5 ) ORDER BY gc_sort desc LIMIT 5 [ RunTime:0.000557s ]
[ 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.002112s ]
[ 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.002529s ]
[ 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.002154s ]
[ 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.002090s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=6 ) [ RunTime:0.000600s ]
[ 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.002585s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=6 ) ORDER BY gc_sort desc LIMIT 5 [ RunTime:0.000592s ]
[ 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.002222s ]
[ 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.002149s ]
[ 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.002129s ]
[ 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.002153s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=7 ) [ RunTime:0.000607s ]
[ 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.002371s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=7 ) ORDER BY gc_sort desc LIMIT 5 [ RunTime:0.000557s ]
[ 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.003022s ]
[ 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.002109s ]
[ 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.002102s ]
[ 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.002259s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=8 ) [ RunTime:0.000578s ]
[ 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.002370s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=8 ) ORDER BY gc_sort desc LIMIT 5 [ RunTime:0.000570s ]
[ 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.002271s ]
[ 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.002393s ]
[ 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.002189s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=9 ) [ RunTime:0.000574s ]
[ 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.002879s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=9 ) ORDER BY gc_sort desc LIMIT 5 [ RunTime:0.000536s ]
[ 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.002235s ]
[ 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.002219s ]
[ 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.002218s ]
[ 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.002215s ]
[ 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.002209s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=13 ) [ RunTime:0.000566s ]
[ 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.002369s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=13 ) ORDER BY gc_sort desc LIMIT 5 [ RunTime:0.000579s ]
[ 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.002127s ]
[ 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.002167s ]
[ 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.002173s ]
[ SQL ] SHOW COLUMNS FROM `ds_advposition` [ RunTime:0.000918s ]
[ SQL ] SELECT `ap_id`,`ap_name`,`ap_width`,`ap_height` FROM `ds_advposition` [ RunTime:0.000535s ]
[ SQL ] SHOW COLUMNS FROM `ds_adv` [ RunTime:0.000861s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=1 and adv_enabled = 1 and adv_startdate < 1561946400 and adv_enddate > 1561946400 ) ORDER BY adv_sort desc LIMIT 10 [ RunTime:0.000556s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=2 and adv_enabled = 1 and adv_startdate < 1561946400 and adv_enddate > 1561946400 ) ORDER BY adv_sort desc LIMIT 10 [ RunTime:0.000570s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=8 and adv_enabled = 1 and adv_startdate < 1561946400 and adv_enddate > 1561946400 ) ORDER BY adv_sort desc LIMIT 1 [ RunTime:0.000589s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=3 and adv_enabled = 1 and adv_startdate < 1561946400 and adv_enddate > 1561946400 ) ORDER BY adv_sort desc LIMIT 1 [ RunTime:0.000550s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=9 and adv_enabled = 1 and adv_startdate < 1561946400 and adv_enddate > 1561946400 ) ORDER BY adv_sort desc LIMIT 1 [ RunTime:0.000574s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=5 and adv_enabled = 1 and adv_startdate < 1561946400 and adv_enddate > 1561946400 ) ORDER BY adv_sort desc LIMIT 1 [ RunTime:0.000563s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=10 and adv_enabled = 1 and adv_startdate < 1561946400 and adv_enddate > 1561946400 ) ORDER BY adv_sort desc LIMIT 1 [ RunTime:0.000563s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=6 and adv_enabled = 1 and adv_startdate < 1561946400 and adv_enddate > 1561946400 ) ORDER BY adv_sort desc LIMIT 1 [ RunTime:0.000557s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=11 and adv_enabled = 1 and adv_startdate < 1561946400 and adv_enddate > 1561946400 ) ORDER BY adv_sort desc LIMIT 1 [ RunTime:0.000576s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=7 and adv_enabled = 1 and adv_startdate < 1561946400 and adv_enddate > 1561946400 ) ORDER BY adv_sort desc LIMIT 1 [ RunTime:0.000553s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=12 and adv_enabled = 1 and adv_startdate < 1561946400 and adv_enddate > 1561946400 ) ORDER BY adv_sort desc LIMIT 1 [ RunTime:0.000555s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=4 and adv_enabled = 1 and adv_startdate < 1561946400 and adv_enddate > 1561946400 ) ORDER BY adv_sort desc LIMIT 1 [ RunTime:0.000564s ]
![凯儿得乐 丝柔新生儿纸尿裤 NB40片[5kg以下]](http://www.hengbaogroup.cn/uploads/home/store/goods/11/11_2019070109374168415.jpg)
![雀氏(chiaus)经典装柔润金棉纸尿裤新生儿NB42片+S60片[0-5kg]](http://www.hengbaogroup.cn/uploads/home/store/goods/11/11_2019070109353686200.jpg)
