[ DB ] CONNECT:[ UseTime:0.000944s ] mysql:host=47.107.151.200;port=3306;dbname=hb_dsmall;charset=utf8
[ SQL ] SHOW COLUMNS FROM `ds_navigation` [ RunTime:0.001139s ]
[ SQL ] SELECT * FROM `ds_navigation` ORDER BY `nav_sort` [ RunTime:0.000608s ]
[ SQL ] SHOW COLUMNS FROM `ds_goods` [ RunTime:0.001258s ]
[ 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.001778s ]
[ SQL ] SHOW COLUMNS FROM `ds_pxianshigoods` [ RunTime:0.000976s ]
[ SQL ] SELECT * FROM `ds_pxianshigoods` WHERE `xianshigoods_state` = 1 AND `xianshigoods_starttime` < 1574044387 AND `xianshigoods_end_time` > 1574044387 ORDER BY xianshigoods_recommend desc LIMIT 6 [ RunTime:0.000791s ]
[ 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.004776s ]
[ SQL ] SHOW COLUMNS FROM `ds_groupbuy` [ RunTime:0.001006s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ds_groupbuy` WHERE `groupbuy_state` = 20 AND `groupbuy_starttime` < 1574044387 AND `groupbuy_endtime` > 1574044387 LIMIT 1 [ RunTime:0.000659s ]
[ SQL ] SELECT * FROM `ds_groupbuy` WHERE `groupbuy_state` = 20 AND `groupbuy_starttime` < 1574044387 AND `groupbuy_endtime` > 1574044387 ORDER BY groupbuy_recommended desc LIMIT 0,15 [ RunTime:0.000764s ]
[ SQL ] SHOW COLUMNS FROM `ds_link` [ RunTime:0.000815s ]
[ SQL ] SELECT * FROM `ds_link` ORDER BY link_sort asc [ RunTime:0.000477s ]
[ SQL ] SHOW COLUMNS FROM `ds_article` [ RunTime:0.000841s ]
[ 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.000579s ]
[ SQL ] SHOW COLUMNS FROM `ds_goodsclass` [ RunTime:0.000818s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE `gc_parent_id` = 0 AND `gc_show` = 1 ORDER BY gc_sort asc [ RunTime:0.000555s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=2 ) [ RunTime:0.000556s ]
[ 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.002752s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=2 ) ORDER BY gc_sort desc LIMIT 5 [ RunTime:0.000555s ]
[ 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.002228s ]
[ 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.002137s ]
[ 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.002197s ]
[ 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.002219s ]
[ 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.002241s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=3 ) [ RunTime:0.000578s ]
[ 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.002670s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=3 ) ORDER BY gc_sort desc LIMIT 5 [ RunTime:0.000581s ]
[ 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.002208s ]
[ 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.002186s ]
[ 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.002215s ]
[ 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.002210s ]
[ 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.002184s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=4 ) [ RunTime:0.000621s ]
[ 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.002646s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=4 ) ORDER BY gc_sort desc LIMIT 5 [ RunTime:0.000560s ]
[ 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.002184s ]
[ 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.002161s ]
[ 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.002179s ]
[ 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.002221s ]
[ 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.002228s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=5 ) [ RunTime:0.000568s ]
[ 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.002518s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=5 ) ORDER BY gc_sort desc LIMIT 5 [ RunTime:0.000537s ]
[ 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.002197s ]
[ 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.002191s ]
[ 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.002217s ]
[ 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.002174s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=6 ) [ RunTime:0.000590s ]
[ 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.002534s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=6 ) ORDER BY gc_sort desc LIMIT 5 [ RunTime:0.000564s ]
[ 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.002132s ]
[ 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.002155s ]
[ 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.002169s ]
[ 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.002183s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=7 ) [ RunTime:0.000589s ]
[ 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.002655s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=7 ) ORDER BY gc_sort desc LIMIT 5 [ RunTime:0.000565s ]
[ 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.002206s ]
[ 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.002167s ]
[ 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.002202s ]
[ 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.002188s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=8 ) [ RunTime:0.000570s ]
[ 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.002407s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=8 ) ORDER BY gc_sort desc LIMIT 5 [ RunTime:0.000566s ]
[ 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.002180s ]
[ 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.002162s ]
[ 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.002225s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=9 ) [ RunTime:0.000555s ]
[ 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.002899s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=9 ) ORDER BY gc_sort desc LIMIT 5 [ RunTime:0.000573s ]
[ 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.002203s ]
[ 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.002217s ]
[ 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.002199s ]
[ 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.002255s ]
[ 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.002248s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=13 ) [ RunTime:0.000557s ]
[ 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.002454s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=13 ) ORDER BY gc_sort desc LIMIT 5 [ RunTime:0.000548s ]
[ 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.002189s ]
[ 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.002209s ]
[ 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.002153s ]
[ SQL ] SHOW COLUMNS FROM `ds_adminlog` [ RunTime:0.000865s ]
[ SQL ] SHOW COLUMNS FROM `ds_advposition` [ RunTime:0.000887s ]
[ SQL ] SELECT `ap_id`,`ap_name`,`ap_width`,`ap_height` FROM `ds_advposition` [ RunTime:0.000524s ]
[ SQL ] SHOW COLUMNS FROM `ds_adv` [ RunTime:0.000898s ]
[ 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.000684s ]
[ 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.000578s ]
[ 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.000564s ]
[ 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.000531s ]
[ 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.000564s ]
[ 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.000548s ]
[ 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.000575s ]
[ 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.000580s ]
[ 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.000566s ]
[ 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.000546s ]
[ 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.000546s ]
[ 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.000577s ]
![凯儿得乐 丝柔新生儿纸尿裤 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)
