[ 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 ]
￥ 52.00已有23人评价
亿日
益银工具
佰事诚鞋业
南方博亿
倡议
恒宝
华昌集团
三川织造
正义
日盛鞋扣
弘扬
辉原
永兴隆
普江百兴鞋材
飞亚多头电脑针车
宏展模具
锦焕皮革
泰亚
国辉科技
胜源鞋材
华宇织造
百兴
正琳鞋材
家新鞋业
Glory Trading
旭旺鞋业
浙江雨茹儿鞋业
协成鞋业
中软塑胶
创易
中隆能源科技
