[ DB ] CONNECT:[ UseTime:0.001016s ] mysql:dbname=shoem_db;host=127.0.0.1;charset=utf8
[ SQL ] SHOW COLUMNS FROM `33hao_type_brand` [ RunTime:0.000860s ]
[ SQL ] SELECT `brand_id` FROM `33hao_type_brand` WHERE ( type_id=0 ) [ RunTime:0.000308s ]
[ SQL ] SHOW COLUMNS FROM `33hao_brand` [ RunTime:0.000660s ]
[ SQL ] SELECT `brand_id`,`brand_name`,`brand_pic`,`show_type` FROM `33hao_brand` WHERE `brand_apply` = 1 ORDER BY brand_sort desc [ RunTime:0.000381s ]
[ SQL ] SHOW COLUMNS FROM `33hao_goods` [ RunTime:0.000967s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT `goods_commonid`,count(*) FROM `33hao_goods` WHERE `goods_state` = 1 AND ( `goods_name` LIKE '%低%温%热%熔%胶%' OR `goods_jingle` LIKE '%低%温%热%熔%胶%' ) GROUP BY goods_commonid ) `_group_count_` LIMIT 1 [ RunTime:0.013608s ]
[ 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 ( `goods_name` LIKE '%低%温%热%熔%胶%' OR `goods_jingle` LIKE '%低%温%热%熔%胶%' ) GROUP BY goods_commonid ORDER BY is_own_shop desc,goods_id desc LIMIT 0,20 [ RunTime:0.014075s ]
[ SQL ] SHOW COLUMNS FROM `33hao_goods_images` [ RunTime:0.000923s ]
[ SQL ] SELECT * FROM `33hao_goods_images` WHERE `goods_commonid` IN (105467,105468,105469,105158,105037,105036,106295) ORDER BY is_default desc,goods_image_sort asc [ RunTime:0.003561s ]
[ SQL ] SHOW COLUMNS FROM `33hao_groupbuy` [ RunTime:0.000840s ]
[ SQL ] SELECT `groupbuy_id`,`goods_commonid` FROM `33hao_groupbuy` WHERE `state` = 20 AND `start_time` < 1576494320 AND `end_time` > 1576494320 AND `goods_commonid` IN (105467,105468,105469,105158,105037,105036,106295) [ RunTime:0.000420s ]
[ 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.010416s ]
[ SQL ] SHOW COLUMNS FROM `33hao_goods_class` [ RunTime:0.000835s ]
[ SQL ] SELECT `gc_id` FROM `33hao_goods_class` WHERE ( gc_show=1 and gc_parent_id!=0 ) ORDER BY rand() LIMIT 10 [ RunTime:0.000993s ]
[ SQL ] SELECT `goods_id`,`goods_name`,`goods_image`,`goods_promotion_price` FROM `33hao_goods` WHERE `gc_id` IN (1856,2607,2294,3316,3128,3074,2599,447,2284,3387) AND `goods_state` = 1 ORDER BY rand() LIMIT 18 [ RunTime:0.009466s ]
[ SQL ] SHOW COLUMNS FROM `33hao_favorites` [ RunTime:0.000739s ]
[ SQL ] SELECT `fav_id` FROM `33hao_favorites` WHERE `member_id` = null AND `fav_type` = 'goods' [ RunTime:0.000250s ]