[ DB ] CONNECT:[ UseTime:0.000352s ] mysql:host=127.0.0.1;port=3306;dbname=heijinwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `ds_typebrand` [ RunTime:0.000611s ]
[ SQL ] SELECT `brand_id` FROM `ds_typebrand` WHERE `type_id` = 1 [ RunTime:0.000163s ]
[ SQL ] SHOW COLUMNS FROM `ds_brand` [ RunTime:0.000515s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ds_brand` WHERE `brand_id` IN (2,3,4,5,6) AND `brand_apply` = 1 LIMIT 1 [ RunTime:0.000169s ]
[ SQL ] SELECT `brand_id`,`brand_name`,`brand_initial`,`brand_pic`,`show_type` FROM `ds_brand` WHERE `brand_id` IN (2,3,4,5,6) AND `brand_apply` = 1 ORDER BY show_type asc,brand_recommend desc,brand_sort asc LIMIT 0,15 [ RunTime:0.000192s ]
[ SQL ] SHOW COLUMNS FROM `ds_attribute` [ RunTime:0.000467s ]
[ SQL ] SELECT `attr_id`,`attr_name` FROM `ds_attribute` WHERE `type_id` = 1 AND `attr_show` = 1 ORDER BY attr_sort asc [ RunTime:0.000140s ]
[ SQL ] SHOW COLUMNS FROM `ds_attributevalue` [ RunTime:0.000440s ]
[ SQL ] SELECT `attr_value_id`,`attr_value_name`,`attr_id` FROM `ds_attributevalue` WHERE `type_id` = 1 ORDER BY attr_value_sort asc,attr_value_id asc [ RunTime:0.000133s ]
[ SQL ] SHOW COLUMNS FROM `ds_goods` [ RunTime:0.000655s ]
[ SQL ] SELECT COUNT(distinct CONCAT(goods_commonid)) AS tp_count FROM `ds_goods` WHERE `gc_id_3` = 296 AND `goods_state` = 1 AND `goods_verify` = 1 LIMIT 1 [ RunTime:0.000442s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) FROM `ds_goods` WHERE `gc_id_3` = 296 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY CONCAT(goods_commonid) ) `_group_count_` LIMIT 1 [ RunTime:0.000429s ]
[ SQL ] SELECT CONCAT(goods_commonid) as nc_distinct,`goods_id`,`goods_commonid`,`goods_name`,`goods_jingle`,`gc_id`,`store_id`,`store_name`,`goods_price`,`goods_promotion_price`,`goods_promotion_type`,`goods_marketprice`,`goods_storage`,`goods_image`,`goods_freight`,`goods_salenum`,`color_id`,`evaluation_good_star`,`evaluation_count`,`is_virtual`,`is_fcode`,`is_appoint`,`is_presell`,`have_gift` FROM `ds_goods` WHERE `gc_id_3` = 296 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY CONCAT(goods_commonid) LIMIT 0,12 [ RunTime:0.000725s ]
[ SQL ] SHOW COLUMNS FROM `ds_goodsimages` [ RunTime:0.000463s ]
[ SQL ] SELECT * FROM `ds_goodsimages` WHERE `goods_commonid` IN (460,461,462,463) ORDER BY is_default desc,goods_image_sort asc [ RunTime:0.000340s ]
[ SQL ] SHOW COLUMNS FROM `ds_store` [ RunTime:0.000758s ]
[ SQL ] SELECT `store_id`,`member_id`,`store_domain` FROM `ds_store` WHERE `store_id` IN (1) [ RunTime:0.000147s ]
[ SQL ] SHOW COLUMNS FROM `ds_goodsclass` [ RunTime:0.000455s ]
[ SQL ] SELECT `gc_id`,`gc_title`,`gc_keywords`,`gc_description` FROM `ds_goodsclass` WHERE `gc_keywords` <> '' [ RunTime:0.000155s ]