[ DB ] CONNECT:[ UseTime:0.003993s ] mysql:host=127.0.0.1;port=3306;dbname=mall_chtc365;charset=utf8
[ SQL ] SHOW COLUMNS FROM `ds_goodsclass` [ RunTime:0.001103s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE `gc_parent_id` = 0 AND `gc_show` = 1 ORDER BY `gc_sort` ASC LIMIT 5 [ RunTime:0.000415s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=817 ) [ RunTime:0.000417s ]
[ SQL ] SHOW COLUMNS FROM `ds_goods` [ RunTime:0.001131s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (817,818,1020,820,821,863,822,990,1017,823,824,825,826,827,828,829,830,831,832,833,864,1016,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1031,1044,1045,1046,850,851,854,855,856,857,858,859,860,861,862,865,866,867,981,983,868,869,870,991) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.003572s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=817 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000405s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (990,991) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.002594s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (1017) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.002994s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (822,868,869,870) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.002853s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (863,865,866,867,981,983) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.002739s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (821,857,858,859,860,861,862) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.002594s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=817 ) ORDER BY `gc_sort` ASC LIMIT 10 [ RunTime:0.000287s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (818,823,824,825,826,827,828,829,830,831,832,833,864,1016) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.002953s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (1020,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1031,1044,1045,1046) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.002984s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (820,850,851,854,855,856) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.002869s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (821,857,858,859,860,861,862) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.002759s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (863,865,866,867,981,983) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.002974s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (822,868,869,870) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.002937s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (990,991) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.002777s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (1017) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.003169s ]
[ SQL ] SHOW COLUMNS FROM `ds_pboothgoods` [ RunTime:0.001473s ]
[ SQL ] SELECT * FROM `ds_pboothgoods` WHERE `gc_id` IN ('') AND `boothgoods_state` = 1 LIMIT 18 [ RunTime:0.000273s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `goods_id` IN ('') AND `goods_state` = 1 AND `goods_verify` = 1 ORDER BY `goods_id` DESC [ RunTime:0.000293s ]
[ SQL ] SELECT `goods_id`,`goods_name`,`goods_image`,`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 `goods_sort` ASC LIMIT 18 [ RunTime:0.002026s ]
[ SQL ] SHOW COLUMNS FROM `ds_xunjiaorder` [ RunTime:0.001065s ]
[ SQL ] SELECT * FROM `ds_xunjiaorder` ORDER BY `id` DESC LIMIT 8 [ RunTime:0.000454s ]