[ DB ] CONNECT:[ UseTime:0.031250s ] mysql:host=127.0.0.1;port=3306;dbname=wap_adli_trade_c;charset=utf8
[ SQL ] SHOW COLUMNS FROM `ds_store` [ RunTime:0.000000s ]
[ SQL ] SELECT `store_id` FROM `ds_store` ORDER BY `grade_id` DESC [ RunTime:0.000000s ]
[ SQL ] SHOW COLUMNS FROM `ds_goods` [ RunTime:0.000000s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT `goods`.`goods_id`,`goods`.`goods_commonid`,`goods`.`goods_name`,`goods`.`goods_advword`,`goods`.`gc_id`,`goods`.`store_id`,`goods`.`goods_addtime`,`goods`.`store_name`,`goods`.`goods_price`,`goods`.`goods_promotion_price`,`goods`.`goods_promotion_type`,`goods`.`goods_marketprice`,`goods`.`goods_storage`,`goods`.`goods_image`,`goods`.`goods_freight`,`goods`.`goods_salenum`,`goods`.`color_id`,`goods`.`evaluation_good_star`,`goods`.`evaluation_count`,`goods`.`is_virtual`,`goods`.`is_goodsfcode`,`goods`.`is_appoint`,`goods`.`is_presell`,`goods`.`is_have_gift`,count(*) FROM `ds_goods` `goods` INNER JOIN `ds_goodscommon` `goodscommon` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goods`.`gc_id_3` = 179 AND `goods`.`goods_state` = 1 AND `goods`.`goods_verify` = 1 GROUP BY `goods`.`goods_commonid` ) `_group_count_` LIMIT 1 [ RunTime:0.015625s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) FROM `ds_goods` `goods` INNER JOIN `ds_goodscommon` `goodscommon` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` INNER JOIN `ds_store` `store` ON `goods`.`store_id`=`store`.`store_id` WHERE `goods`.`gc_id_3` = 179 AND `goods`.`goods_state` = 1 AND `goods`.`goods_verify` = 1 GROUP BY `goods`.`goods_commonid` ) `_group_count_` LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SELECT `goods`.`goods_id`,`goods`.`goods_commonid`,`goods`.`goods_name`,`goods`.`goods_advword`,`goods`.`gc_id`,`goods`.`store_id`,`goods`.`goods_addtime`,`goods`.`store_name`,`goods`.`goods_price`,`goods`.`goods_promotion_price`,`goods`.`goods_promotion_type`,`goods`.`goods_marketprice`,`goods`.`goods_storage`,`goods`.`goods_image`,`goods`.`goods_freight`,`goods`.`goods_salenum`,`goods`.`color_id`,`goods`.`evaluation_good_star`,`goods`.`evaluation_count`,`goods`.`is_virtual`,`goods`.`is_goodsfcode`,`goods`.`is_appoint`,`goods`.`is_presell`,`goods`.`is_have_gift` FROM `ds_goods` `goods` INNER JOIN `ds_goodscommon` `goodscommon` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` INNER JOIN `ds_store` `store` ON `goods`.`store_id`=`store`.`store_id` WHERE `goods`.`gc_id_3` = 179 AND `goods`.`goods_state` = 1 AND `goods`.`goods_verify` = 1 GROUP BY `goods`.`goods_commonid` ORDER BY `grade_id` DESC,`goods`.`goods_addtime` DESC LIMIT 0,20 [ RunTime:0.015625s ]
[ SQL ] SHOW COLUMNS FROM `ds_goodsimages` [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `ds_goodsimages` WHERE `goods_commonid` IN (10518,10463) ORDER BY `goodsimage_isdefault` DESC,`goodsimage_sort` ASC [ RunTime:0.000000s ]
[ SQL ] SELECT `store_id`,`member_id`,`store_name` FROM `ds_store` WHERE `store_id` IN (1531,1454) [ RunTime:0.000000s ]
[ SQL ] SELECT `store_name` FROM `ds_store` WHERE `store_id` = 1531 LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SELECT `store_name` FROM `ds_store` WHERE `store_id` = 1454 LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SHOW COLUMNS FROM `ds_mbcategory` [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `ds_mbcategory` ORDER BY `gc_id` [ RunTime:0.000000s ]
[ SQL ] SHOW COLUMNS FROM `ds_goodsclass` [ RunTime:0.000000s ]
[ SQL ] SELECT `gc_id`,`gc_title`,`gc_keywords`,`gc_description` FROM `ds_goodsclass` WHERE `gc_keywords` <> '' [ RunTime:0.000000s ]
[ SQL ] SHOW COLUMNS FROM `ds_favorites` [ RunTime:0.000000s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ds_favorites` WHERE `fav_type` = 'store' LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ds_favorites` WHERE `fav_type` = 'goods' LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SHOW COLUMNS FROM `ds_brand` [ RunTime:0.000000s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ds_brand` WHERE `brand_recommend` = 1 AND `brand_apply` = 1 LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SELECT `brand_id`,`brand_name`,`brand_pic` FROM `ds_brand` WHERE `brand_recommend` = 1 AND `brand_apply` = 1 ORDER BY `brand_sort` ASC,`brand_id` DESC LIMIT 0,20 [ RunTime:0.000000s ]
