[ DB ] CONNECT:[ UseTime:0.012845s ] mysql:host=rm-bp140g900gk55624xco.mysql.rds.aliyuncs.com;port=3306;dbname=app_taoshihui_2020;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `benben_pc_cat` [ slave|RunTime:0.009610s ]
[ SQL ] SELECT `ac`.`id`,`ac`.`cat_name_pc`,`ac`.`is_show`,`ac`.`parame`,`ac`.`pc_url`,`ac`.`parent_id`,`ac`.`position_id`,`ac`.`auth_check` FROM `benben_pc_cat` `ac` WHERE `ac`.`status` = 1 AND `ac`.`parent_id` = 0 ORDER BY `sort` ASC,`id` ASC [ slave|RunTime:0.008459s ]
[ SQL ] SHOW COLUMNS FROM `benben_app_cat` [ slave|RunTime:0.009235s ]
[ SQL ] SELECT `cat_name`,`parame` FROM `benben_app_cat` WHERE `is_show` = 1 ORDER BY `sort` ASC LIMIT 10 [ slave|RunTime:0.008374s ]
[ SQL ] SHOW COLUMNS FROM `benben_goods` [ slave|RunTime:0.010019s ]
[ SQL ] SELECT `g`.*,g.sale_num as sale_number,FROM_UNIXTIME(g.pre_begin_time , '%Y年%m月%d日 %H:%i') as pre_begin_time,FROM_UNIXTIME(g.pre_end_time , '%Y年%m月%d日 %H:%i') as pre_end_time,FROM_UNIXTIME(g.sale_begin_time , '%Y年%m月%d日 %H:%i') as sale_begin_time,FROM_UNIXTIME(g.sale_end_time , '%Y年%m月%d日 %H:%i') as sale_end_time,FROM_UNIXTIME(g.pre_end_time , '%m月%d日 %H:%i') as pre_end_time_bottom FROM `benben_goods` `g` WHERE `g`.`id` = '849' AND `g`.`is_onsale` = 1 LIMIT 1 [ slave|RunTime:0.008523s ]
[ SQL ] SHOW COLUMNS FROM `benben_system` [ slave|RunTime:0.008956s ]
[ SQL ] SELECT * FROM `benben_system` WHERE `conf_key` = 'base' LIMIT 1 [ slave|RunTime:0.008238s ]
[ SQL ] SELECT * FROM `benben_system` WHERE `conf_key` = 'watermark' LIMIT 1 [ slave|RunTime:0.008198s ]
[ SQL ] SELECT * FROM `benben_system` WHERE `conf_key` = 'base' LIMIT 1 [ slave|RunTime:0.008283s ]
[ SQL ] SHOW COLUMNS FROM `benben_shop` [ slave|RunTime:0.009644s ]
[ SQL ] SELECT `s`.`id`,`s`.`shop_logo`,`s`.`shop_name`,`s`.`rank_id`,s.user_id as shop_user_id,`s`.`province`,`s`.`city`,`s`.`district`,`s`.`address`,u.user_login as mobile FROM `benben_shop` `s` LEFT JOIN `benben_user` `u` ON `s`.`user_id`=`u`.`id` WHERE `s`.`id` = 279 LIMIT 1 [ slave|RunTime:0.008255s ]
[ SQL ] SHOW COLUMNS FROM `benben_region` [ slave|RunTime:0.008899s ]
[ SQL ] SELECT `region_name` FROM `benben_region` WHERE `region_id` = 24 LIMIT 1 [ slave|RunTime:0.008225s ]
[ SQL ] SELECT `region_name` FROM `benben_region` WHERE `region_id` = 2781 LIMIT 1 [ slave|RunTime:0.008235s ]
[ SQL ] SELECT `region_name` FROM `benben_region` WHERE `region_id` = 2792 LIMIT 1 [ slave|RunTime:0.008239s ]
[ SQL ] SHOW COLUMNS FROM `benben_goods_comment` [ slave|RunTime:0.009016s ]
[ SQL ] SELECT ifnull(cast(avg(stars) as decimal(18,1)),3) FROM `benben_goods_comment` WHERE `shop_id` = 279 LIMIT 1 [ slave|RunTime:0.008388s ]
[ SQL ] SELECT ifnull(cast(avg(ship_stars)as decimal(18,1)),3) FROM `benben_goods_comment` WHERE `shop_id` = 279 LIMIT 1 [ slave|RunTime:0.008263s ]
[ SQL ] SELECT ifnull(cast(avg(shop_stars)as decimal(18,1)),3) FROM `benben_goods_comment` WHERE `shop_id` = 279 LIMIT 1 [ slave|RunTime:0.008275s ]
[ SQL ] SHOW COLUMNS FROM `benben_goods_attr` [ slave|RunTime:0.008931s ]
[ SQL ] SELECT `a`.*,b.id as attrid,`b`.`attr_name`,`b`.`attr_type`,`b`.`attr_values`,`b`.`attr_catid` FROM `benben_goods_attr` `a` LEFT JOIN `benben_attribute` `b` ON `a`.`attr_id`=`b`.`id` WHERE ( a.goods_id = '849' and a.attr_value != '' ) [ slave|RunTime:0.008346s ]
[ SQL ] SELECT `goods_name`,`title_pic`,`goods_price` FROM `benben_goods` WHERE `id` = 849 LIMIT 1 [ slave|RunTime:0.008230s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `benben_goods_comment` `gc` LEFT JOIN `benben_user` `u` ON `gc`.`user_id`=`u`.`id` WHERE `gc`.`goods_id` = '849' AND `gc`.`status` = 0 AND `gc`.`parent_id` = 0 LIMIT 1 [ slave|RunTime:0.008265s ]
[ SQL ] SELECT `gc`.*,`u`.`head_img`,`u`.`user_nickname`,`u`.`mobile` FROM `benben_goods_comment` `gc` LEFT JOIN `benben_user` `u` ON `gc`.`user_id`=`u`.`id` WHERE `gc`.`goods_id` = '849' AND `gc`.`status` = 0 AND `gc`.`parent_id` = 0 ORDER BY `gc`.`add_time` DESC LIMIT 0,2 [ slave|RunTime:0.008324s ]
[ SQL ] SHOW COLUMNS FROM `benben_goods_comment_hymn` [ slave|RunTime:0.009026s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `benben_goods_comment_hymn` WHERE `fc_id` = 90 LIMIT 1 [ slave|RunTime:0.008309s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `benben_goods_comment` WHERE `parent_id` = 90 LIMIT 1 [ slave|RunTime:0.008274s ]
[ SQL ] SELECT * FROM `benben_goods_comment_hymn` WHERE `fc_id` = 90 AND `user_id` = 0 LIMIT 1 [ slave|RunTime:0.008274s ]
[ SQL ] SELECT `comment_desc` FROM `benben_goods_comment` WHERE `parent_id` = 90 AND `type` = 2 [ slave|RunTime:0.008294s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `benben_goods_comment_hymn` WHERE `fc_id` = 89 LIMIT 1 [ slave|RunTime:0.008267s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `benben_goods_comment` WHERE `parent_id` = 89 LIMIT 1 [ slave|RunTime:0.008241s ]
[ SQL ] SELECT * FROM `benben_goods_comment_hymn` WHERE `fc_id` = 89 AND `user_id` = 0 LIMIT 1 [ slave|RunTime:0.008282s ]
[ SQL ] SELECT `comment_desc` FROM `benben_goods_comment` WHERE `parent_id` = 89 AND `type` = 2 [ slave|RunTime:0.008248s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `benben_goods_comment` `gc` LEFT JOIN `benben_user` `u` ON `gc`.`user_id`=`u`.`id` LEFT JOIN `benben_order_goods` `og` ON `og`.`id`=`gc`.`rec_id` WHERE `gc`.`goods_id` = '849' AND `gc`.`status` = 0 AND `gc`.`parent_id` = 0 LIMIT 1 [ slave|RunTime:0.008262s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `benben_goods_comment` `gc` LEFT JOIN `benben_user` `u` ON `gc`.`user_id`=`u`.`id` WHERE `gc`.`goods_id` = '849' AND ( gc.stars <= 1 and gc.parent_id = 0 ) LIMIT 1 [ slave|RunTime:0.008287s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `benben_goods_comment` `gc` LEFT JOIN `benben_user` `u` ON `gc`.`user_id`=`u`.`id` WHERE `gc`.`goods_id` = '849' AND ( gc.stars > 1 AND gc.stars < 4 and gc.parent_id = 0 ) LIMIT 1 [ slave|RunTime:0.008284s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `benben_goods_comment` `gc` LEFT JOIN `benben_user` `u` ON `gc`.`user_id`=`u`.`id` WHERE `gc`.`goods_id` = '849' AND ( gc.stars > 4 and gc.parent_id = 0 ) LIMIT 1 [ slave|RunTime:0.008339s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `benben_goods_comment` `gc` LEFT JOIN `benben_user` `u` ON `gc`.`user_id`=`u`.`id` LEFT JOIN `benben_order_goods` `og` ON `og`.`id`=`gc`.`rec_id` WHERE `gc`.`goods_id` = '849' LIMIT 1 [ slave|RunTime:0.008326s ]
[ SQL ] SHOW COLUMNS FROM `benben_user_address` [ slave|RunTime:0.009250s ]
[ SQL ] SELECT * FROM `benben_user_address` WHERE `user_id` IS NULL AND `status` = 1 ORDER BY `is_default` DESC,`id` DESC LIMIT 1 [ slave|RunTime:0.008323s ]
[ SQL ] SELECT `cat_id` FROM `benben_goods` WHERE `id` = 849 LIMIT 1 [ slave|RunTime:0.008227s ]
[ SQL ] SHOW COLUMNS FROM `benben_goods_category` [ slave|RunTime:0.009076s ]
[ SQL ] SELECT `cat_name` FROM `benben_goods_category` WHERE `cat_id` = 188 LIMIT 1 [ slave|RunTime:0.008217s ]
[ SQL ] UPDATE `benben_goods` SET `goods_views`=`goods_views`+1 WHERE `id` = 849 [ master|RunTime:0.010393s ]
请登录
