[ DB ] CONNECT:[ UseTime:0.008260s ] mysql:dbname=shoem_db;host=127.0.0.1;charset=utf8
[ SQL ] SHOW COLUMNS FROM `33hao_type_brand` [ RunTime:0.001024s ]
[ SQL ] SELECT `brand_id` FROM `33hao_type_brand` WHERE ( type_id=0 ) [ RunTime:0.000327s ]
[ SQL ] SHOW COLUMNS FROM `33hao_brand` [ RunTime:0.000708s ]
[ SQL ] SELECT `brand_id`,`brand_name`,`brand_pic`,`show_type` FROM `33hao_brand` WHERE `brand_apply` = 1 ORDER BY brand_sort desc [ RunTime:0.000393s ]
[ SQL ] SHOW COLUMNS FROM `33hao_goods` [ RunTime:0.000870s ]
[ 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.013692s ]
[ 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.014092s ]
[ SQL ] SHOW COLUMNS FROM `33hao_goods_images` [ RunTime:0.000841s ]
[ SQL ] SELECT * FROM `33hao_goods_images` WHERE `goods_commonid` IN (100299,104107,100439,100441,100324,104114,100308,104112,100306,104111,100303,104110,100301,104109,101648,101649,102534,102553,105377,105376) ORDER BY is_default desc,goods_image_sort asc [ RunTime:0.003860s ]
[ SQL ] SHOW COLUMNS FROM `33hao_groupbuy` [ RunTime:0.000815s ]
[ SQL ] SELECT `groupbuy_id`,`goods_commonid` FROM `33hao_groupbuy` WHERE `state` = 20 AND `start_time` < 1576494742 AND `end_time` > 1576494742 AND `goods_commonid` IN (100299,104107,100439,100441,100324,104114,100308,104112,100306,104111,100303,104110,100301,104109,101648,101649,102534,102553,105377,105376) [ RunTime:0.000578s ]
[ 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.010306s ]
[ SQL ] SHOW COLUMNS FROM `33hao_goods_class` [ RunTime:0.000912s ]
[ SQL ] SELECT `gc_id` FROM `33hao_goods_class` WHERE ( gc_show=1 and gc_parent_id!=0 ) ORDER BY rand() LIMIT 10 [ RunTime:0.000996s ]
[ SQL ] SELECT `goods_id`,`goods_name`,`goods_image`,`goods_promotion_price` FROM `33hao_goods` WHERE `gc_id` IN (3368,2686,2422,395,2209,1885,3144,1939,2308,1897) AND `goods_state` = 1 ORDER BY rand() LIMIT 18 [ RunTime:0.009318s ]
[ SQL ] SHOW COLUMNS FROM `33hao_favorites` [ RunTime:0.000783s ]
[ SQL ] SELECT `fav_id` FROM `33hao_favorites` WHERE `member_id` = null AND `fav_type` = 'goods' [ RunTime:0.000245s ]