[ DB ] CONNECT:[ UseTime:0.005146s ] mysql:dbname=shoem_db;host=127.0.0.1;charset=utf8
[ SQL ] SHOW COLUMNS FROM `33hao_goods_class` [ RunTime:0.000936s ]
[ SQL ] SELECT `gc_id`,`gc_name`,`type_id`,`gc_parent_id` FROM `33hao_goods_class` WHERE `gc_id` = 3101 AND `gc_show` = 1 LIMIT 1 [ RunTime:0.000452s ]
[ SQL ] SELECT `gc_id`,`gc_name`,`type_id`,`gc_parent_id` FROM `33hao_goods_class` WHERE `gc_parent_id` = 3101 AND `gc_show` = 1 ORDER BY gc_sort desc [ RunTime:0.000457s ]
[ SQL ] SHOW COLUMNS FROM `33hao_type_brand` [ RunTime:0.000563s ]
[ SQL ] SELECT `brand_id` FROM `33hao_type_brand` WHERE ( type_id=2 ) [ RunTime:0.000189s ]
[ SQL ] SHOW COLUMNS FROM `33hao_brand` [ RunTime:0.000593s ]
[ SQL ] SELECT `brand_id`,`brand_name`,`brand_pic`,`show_type` FROM `33hao_brand` WHERE `brand_apply` = 1 ORDER BY brand_sort desc [ RunTime:0.000295s ]
[ SQL ] SHOW COLUMNS FROM `33hao_goods` [ RunTime:0.000765s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT `goods_commonid`,count(*) FROM `33hao_goods` WHERE `goods_state` = 1 AND ( `gc_id` = 3101 OR `gc_id_1` = 3101 OR `gc_id_2` = 3101 ) GROUP BY goods_commonid ) `_group_count_` LIMIT 1 [ RunTime:0.009702s ]
[ 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` = 3101 OR `gc_id_1` = 3101 OR `gc_id_2` = 3101 ) GROUP BY goods_commonid ORDER BY is_own_shop desc,goods_id desc LIMIT 0,20 [ RunTime:0.010092s ]
[ SQL ] SHOW COLUMNS FROM `33hao_goods_images` [ RunTime:0.000809s ]
[ SQL ] SELECT * FROM `33hao_goods_images` WHERE `goods_commonid` IN (104648,104647,104646,104645,104644,104643,104642,104640,104641,104638,104639,104584,104583,104582,104581,104580,104579,104578,104577,104575) ORDER BY is_default desc,goods_image_sort asc [ RunTime:0.003566s ]
[ SQL ] SHOW COLUMNS FROM `33hao_groupbuy` [ RunTime:0.000780s ]
[ SQL ] SELECT `groupbuy_id`,`goods_commonid` FROM `33hao_groupbuy` WHERE `state` = 20 AND `start_time` < 1576489836 AND `end_time` > 1576489836 AND `goods_commonid` IN (104648,104647,104646,104645,104644,104643,104642,104640,104641,104638,104639,104584,104583,104582,104581,104580,104579,104578,104577,104575) [ RunTime:0.000448s ]
[ 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.000274s ]
[ SQL ] SELECT `gc_id` FROM `33hao_goods_class` WHERE ( gc_show=1 and gc_parent_id!=0 ) ORDER BY rand() LIMIT 10 [ RunTime:0.000927s ]
[ SQL ] SELECT `goods_id`,`goods_name`,`goods_image`,`goods_promotion_price` FROM `33hao_goods` WHERE `gc_id` IN (2958,2365,3160,1960,2437,2486,3376,492,437,2499) AND `goods_state` = 1 ORDER BY rand() LIMIT 18 [ RunTime:0.009259s ]
[ SQL ] SHOW COLUMNS FROM `33hao_favorites` [ RunTime:0.000627s ]
[ SQL ] SELECT `fav_id` FROM `33hao_favorites` WHERE `member_id` = null AND `fav_type` = 'goods' [ RunTime:0.000209s ]