[ DB ] CONNECT:[ UseTime:0.000295s ] mysql:host=127.0.0.1;port=3306;dbname=heijinwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `ds_typebrand` [ RunTime:0.000571s ]
[ SQL ] SELECT `brand_id` FROM `ds_typebrand` WHERE `type_id` = 1 [ RunTime:0.000152s ]
[ SQL ] SHOW COLUMNS FROM `ds_brand` [ RunTime:0.000472s ]
[ 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.000158s ]
[ 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.000165s ]
[ SQL ] SHOW COLUMNS FROM `ds_attribute` [ RunTime:0.000430s ]
[ SQL ] SELECT `attr_id`,`attr_name` FROM `ds_attribute` WHERE `type_id` = 1 AND `attr_show` = 1 ORDER BY attr_sort asc [ RunTime:0.000135s ]
[ SQL ] SHOW COLUMNS FROM `ds_attributevalue` [ RunTime:0.000442s ]
[ 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.000128s ]
[ SQL ] SHOW COLUMNS FROM `ds_goods` [ RunTime:0.000900s ]
[ SQL ] SELECT COUNT(distinct CONCAT(goods_commonid)) AS tp_count FROM `ds_goods` WHERE `gc_id_3` = 386 AND `goods_state` = 1 AND `goods_verify` = 1 LIMIT 1 [ RunTime:0.000600s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) FROM `ds_goods` WHERE `gc_id_3` = 386 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY CONCAT(goods_commonid) ) `_group_count_` LIMIT 1 [ RunTime:0.000639s ]
[ 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` = 386 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY CONCAT(goods_commonid) LIMIT 0,12 [ RunTime:0.000984s ]
[ SQL ] SHOW COLUMNS FROM `ds_goodsimages` [ RunTime:0.000597s ]
[ SQL ] SELECT * FROM `ds_goodsimages` WHERE `goods_commonid` IN (531,532,533,534) ORDER BY is_default desc,goods_image_sort asc [ RunTime:0.000504s ]
[ SQL ] SHOW COLUMNS FROM `ds_store` [ RunTime:0.000903s ]
[ SQL ] SELECT `store_id`,`member_id`,`store_domain` FROM `ds_store` WHERE `store_id` IN (1) [ RunTime:0.000142s ]
[ SQL ] SHOW COLUMNS FROM `ds_goodsclass` [ RunTime:0.000496s ]
[ SQL ] SELECT `gc_id`,`gc_title`,`gc_keywords`,`gc_description` FROM `ds_goodsclass` WHERE `gc_keywords` <> '' [ RunTime:0.000131s ]