[ DB ] CONNECT:[ UseTime:0.011639s ] mysql:dbname=shoem_db;host=127.0.0.1;charset=utf8
[ SQL ] SHOW COLUMNS FROM `33hao_goods_class` [ RunTime:0.000972s ]
[ SQL ] SELECT `gc_id`,`gc_name`,`type_id`,`gc_parent_id` FROM `33hao_goods_class` WHERE `gc_id` = 2750 AND `gc_show` = 1 LIMIT 1 [ RunTime:0.000435s ]
[ SQL ] SELECT `gc_id`,`gc_name`,`type_id`,`gc_parent_id` FROM `33hao_goods_class` WHERE `gc_parent_id` = 2750 AND `gc_show` = 1 ORDER BY gc_sort desc [ RunTime:0.000473s ]
[ SQL ] SHOW COLUMNS FROM `33hao_type_brand` [ RunTime:0.000598s ]
[ SQL ] SELECT `brand_id` FROM `33hao_type_brand` WHERE ( type_id=2 ) [ RunTime:0.000180s ]
[ SQL ] SHOW COLUMNS FROM `33hao_brand` [ RunTime:0.000625s ]
[ SQL ] SELECT `brand_id`,`brand_name`,`brand_pic`,`show_type` FROM `33hao_brand` WHERE `brand_apply` = 1 ORDER BY brand_sort desc [ RunTime:0.000293s ]
[ SQL ] SHOW COLUMNS FROM `33hao_goods` [ RunTime:0.000831s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT `goods_commonid`,count(*) FROM `33hao_goods` WHERE `goods_state` = 1 AND ( `gc_id` = 2750 OR `gc_id_1` = 2750 OR `gc_id_2` = 2750 ) GROUP BY goods_commonid ) `_group_count_` LIMIT 1 [ RunTime:0.009818s ]
[ SQL ] SELECT `goods_id`,`goods_commonid`,`goods_name`,`goods_jingle`,`gc_id`,`store_id`,`store_name`,min(goods_price) as goods_price,min(goods_promotion_price) as 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 `33hao_goods` WHERE `goods_state` = 1 AND ( `gc_id` = 2750 OR `gc_id_1` = 2750 OR `gc_id_2` = 2750 ) GROUP BY goods_commonid ORDER BY is_own_shop desc,goods_id desc LIMIT 20,20 [ RunTime:0.010193s ]
[ SQL ] SHOW COLUMNS FROM `33hao_goods_images` [ RunTime:0.000734s ]
[ SQL ] SELECT * FROM `33hao_goods_images` WHERE `goods_commonid` IN (102408,102412,102416,102419,102425,102428,102388,102431,102422,102433,102436,102443,102438,102441,102446,102449,102454,102455,102460,102462) ORDER BY is_default desc,goods_image_sort asc [ RunTime:0.003370s ]
[ SQL ] SHOW COLUMNS FROM `33hao_groupbuy` [ RunTime:0.000787s ]
[ SQL ] SELECT `groupbuy_id`,`goods_commonid` FROM `33hao_groupbuy` WHERE `state` = 20 AND `start_time` < 1576492332 AND `end_time` > 1576492332 AND `goods_commonid` IN (102408,102412,102416,102419,102425,102428,102388,102431,102422,102433,102436,102443,102438,102441,102446,102449,102454,102455,102460,102462) [ RunTime:0.000445s ]
[ SQL ] SELECT `goods_id`,`goods_name`,`goods_price`,`goods_image`,`evaluation_count` FROM `33hao_goods` WHERE `goods_state` = 1 AND `goods_verify` = 1 ORDER BY evaluation_count desc LIMIT 5 [ RunTime:0.010150s ]
[ SQL ] SELECT `gc_id` FROM `33hao_goods_class` WHERE ( gc_show=1 and gc_parent_id!=0 ) ORDER BY rand() LIMIT 10 [ RunTime:0.000998s ]
[ SQL ] SELECT `goods_id`,`goods_name`,`goods_image`,`goods_promotion_price` FROM `33hao_goods` WHERE `gc_id` IN (1897,1963,2239,2709,2593,368,2298,3368,2882,3378) AND `goods_state` = 1 ORDER BY rand() LIMIT 18 [ RunTime:0.009352s ]
[ SQL ] SHOW COLUMNS FROM `33hao_favorites` [ RunTime:0.000741s ]
[ SQL ] SELECT `fav_id` FROM `33hao_favorites` WHERE `member_id` = null AND `fav_type` = 'goods' [ RunTime:0.000220s ]