[ DB ] CONNECT:[ UseTime:0.011908s ] 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.008831s ]
[ 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.007782s ]
[ SQL ] SHOW COLUMNS FROM `benben_app_cat` [ slave|RunTime:0.008378s ]
[ SQL ] SELECT `cat_name`,`parame` FROM `benben_app_cat` WHERE `is_show` = 1 ORDER BY `sort` ASC LIMIT 10 [ slave|RunTime:0.007740s ]
[ SQL ] SHOW COLUMNS FROM `benben_shop` [ slave|RunTime:0.008836s ]
[ SQL ] SELECT `id`,`shop_logo`,`shop_name`,`mobile`,`longitude`,`latitude`,`synopsis`,`province`,`city`,`district`,`address`,`shop_title_pic`,`main_category`,`main_goods`,`shop_customer`,`shop_email`,`is_vip`,`is_logistics`,user_id shop_user_id,`gallery_ids`,`lnglat_address`,`shop_pic`,`category_id`,`shop_index_about`,`shop_index_circle` FROM `benben_shop` WHERE `id` = 0 LIMIT 1 [ slave|RunTime:0.007745s ]
[ SQL ] SHOW COLUMNS FROM `benben_user` [ slave|RunTime:0.008823s ]
[ SQL ] SELECT id,head_img as shop_logo,from_base64(user_nickname) as shop_name,mobile,0 as longitude, 0 as latitude, null as synopsis,province,city,district,address,null as shop_title_pic,null as main_category,null as main_goods,null as shop_customer, null as shop_email,is_vip,0 as is_logistics,id as shop_user_id,0 as gallery_ids,null as lnglat_address,"" as shop_pic,0 as category_id FROM `benben_user` WHERE `id` = 0 LIMIT 1 [ slave|RunTime:0.007712s ]
[ SQL ] SHOW COLUMNS FROM `benben_gallery` [ slave|RunTime:0.008337s ]
[ SQL ] SELECT group_concat(gallery_title) FROM `benben_gallery` WHERE `id` IN (0) LIMIT 1 [ slave|RunTime:0.007593s ]
[ SQL ] SHOW COLUMNS FROM `benben_region` [ slave|RunTime:0.008147s ]
[ SQL ] SELECT `region_name` FROM `benben_region` WHERE `region_id` IS NULL LIMIT 1 [ slave|RunTime:0.007537s ]
[ SQL ] SELECT `region_name` FROM `benben_region` WHERE `region_id` IS NULL LIMIT 1 [ slave|RunTime:0.007508s ]
[ SQL ] SELECT `region_name` FROM `benben_region` WHERE `region_id` IS NULL LIMIT 1 [ slave|RunTime:0.007523s ]
[ SQL ] SHOW COLUMNS FROM `benben_shop_category` [ slave|RunTime:0.008415s ]
[ SQL ] SELECT * FROM `benben_shop_category` WHERE `cat_id` IS NULL LIMIT 1 [ slave|RunTime:0.007562s ]
[ SQL ] SHOW COLUMNS FROM `benben_goods` [ slave|RunTime:0.008778s ]
[ SQL ] SELECT `id`,`cat_id`,`goods_name`,`title_pic`,`goods_price`,`market_price`,`sale_num`,`goods_number`,`is_three_dimension`,`vip_price` FROM `benben_goods` WHERE `shop_id` = 0 AND `is_onsale` = 1 AND `is_original` = 0 AND `is_pre_sale` = 0 ORDER BY `sort_order` ASC,`id` DESC LIMIT 0,8 [ slave|RunTime:0.008361s ]
[ SQL ] SHOW COLUMNS FROM `benben_goods_category` [ slave|RunTime:0.008260s ]
[ SQL ] SELECT `cat_id`,`cat_name` FROM `benben_goods_category` WHERE `cat_id` IN (171,222,180,282) [ slave|RunTime:0.007660s ]
[ SQL ] SHOW COLUMNS FROM `benben_shop_case` [ slave|RunTime:0.008503s ]
[ SQL ] SELECT `id`,`shop_id`,`case_name`,`case_top_image` FROM `benben_shop_case` WHERE `shop_id` = 0 ORDER BY `sort_order` DESC,`id` DESC LIMIT 0,6 [ slave|RunTime:0.007608s ]
[ SQL ] SHOW COLUMNS FROM `benben_shop_photo` [ slave|RunTime:0.008469s ]
[ SQL ] SELECT `id`,`photo_name`,`photo_img` FROM `benben_shop_photo` WHERE `shop_id` = 0 ORDER BY `sort_order` ASC,`id` DESC LIMIT 0,8 [ slave|RunTime:0.007622s ]
[ SQL ] SHOW COLUMNS FROM `benben_business_circle` [ slave|RunTime:0.008697s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `benben_business_circle` `bc` LEFT JOIN `benben_user` `u` ON `bc`.`user_id`=`u`.`id` LEFT JOIN `benben_goods_category` `gc` ON `bc`.`goods_cate_id`=`gc`.`cat_id` LEFT JOIN `benben_business_circle_cate` `bcc` ON `bc`.`cate_id`=`bcc`.`cat_id` LEFT JOIN `benben_shop` `s` ON `bc`.`user_id`=s.user_id and s.is_del=0 and s.original_checked=1 LEFT JOIN `benben_shop_category` `sc` ON `s`.`category_id`=`sc`.`cat_id` WHERE `bc`.`status` = 1 LIMIT 1 [ slave|RunTime:0.007850s ]
[ SQL ] SELECT bc.id,bc.cate_id,bc.goods_cate_id,bc.phone,bc.add_time,bc.img_url,bc.publish_location,bc.content,bc.likes,bc.num_comment,ifnull(s.id,u.id) user_id,ifnull(s.shop_name,from_base64(u.user_nickname)) user_nickname,ifnull(s.shop_logo,u.head_img) head_img,case when s.id is not null then 1 else 0 end as is_shop,u.is_vip,u.vip_type,gc.cat_name goods_cat_name,bcc.cat_name as cat_name1,bcc.cat_alias_name,concat(gc.cat_name,bcc.cat_alias_name) cat_name,bc.end_time-0 end_time,sc.shop_auth_code,s.original_checked,sc.type,sc.mark_down FROM `benben_business_circle` `bc` LEFT JOIN `benben_user` `u` ON `bc`.`user_id`=`u`.`id` LEFT JOIN `benben_goods_category` `gc` ON `bc`.`goods_cate_id`=`gc`.`cat_id` LEFT JOIN `benben_business_circle_cate` `bcc` ON `bc`.`cate_id`=`bcc`.`cat_id` LEFT JOIN `benben_shop` `s` ON `bc`.`user_id`=s.user_id and s.is_del=0 and s.original_checked=1 LEFT JOIN `benben_shop_category` `sc` ON `s`.`category_id`=`sc`.`cat_id` WHERE `bc`.`status` = 1 ORDER BY `bc`.`add_time` DESC LIMIT 0,3 [ slave|RunTime:0.008122s ]
[ SQL ] SHOW COLUMNS FROM `benben_business_circle_comment` [ slave|RunTime:0.008317s ]
[ SQL ] SELECT bc.id,bc.circle_id,bc.content,bc.add_time,ifnull(s.id,u.id) as user_id,ifnull(s.shop_name,from_base64(u.user_nickname)) as user_nickname,ifnull(s.shop_logo,u.head_img) as head_img,case when s.id is not null then 1 else 0 end as is_shop,u.id as real_user_id FROM `benben_business_circle_comment` `bc` LEFT JOIN `benben_user` `u` ON `bc`.`user_id`=`u`.`id` LEFT JOIN `benben_shop` `s` ON `bc`.`user_id`=s.user_id and s.is_del=0 and s.original_checked=1 WHERE `bc`.`circle_id` = 182 AND `bc`.`parent_id` = 0 ORDER BY `bc`.`add_time` DESC LIMIT 0,3 [ slave|RunTime:0.007957s ]
[ SQL ] SHOW COLUMNS FROM `benben_business_circle_likes` [ slave|RunTime:0.008358s ]
[ SQL ] SELECT ifnull(s.id,u.id) user_id,ifnull(s.shop_name,from_base64(u.user_nickname)) user_nickname,case when s.id is not null then 1 else 0 end as is_shop FROM `benben_business_circle_likes` `bcl` LEFT JOIN `benben_user` `u` ON `bcl`.`user_id`=`u`.`id` LEFT JOIN `benben_shop` `s` ON `bcl`.`user_id`=s.user_id and s.is_del=0 and s.original_checked=1 WHERE `bcl`.`circle_id` = 182 ORDER BY `bcl`.`add_time` DESC LIMIT 0,4 [ slave|RunTime:0.007879s ]
[ SQL ] SELECT bc.id,bc.circle_id,bc.content,bc.add_time,ifnull(s.id,u.id) as user_id,ifnull(s.shop_name,from_base64(u.user_nickname)) as user_nickname,ifnull(s.shop_logo,u.head_img) as head_img,case when s.id is not null then 1 else 0 end as is_shop,u.id as real_user_id FROM `benben_business_circle_comment` `bc` LEFT JOIN `benben_user` `u` ON `bc`.`user_id`=`u`.`id` LEFT JOIN `benben_shop` `s` ON `bc`.`user_id`=s.user_id and s.is_del=0 and s.original_checked=1 WHERE `bc`.`circle_id` = 181 AND `bc`.`parent_id` = 0 ORDER BY `bc`.`add_time` DESC LIMIT 0,3 [ slave|RunTime:0.007865s ]
[ SQL ] SELECT ifnull(s.id,u.id) user_id,ifnull(s.shop_name,from_base64(u.user_nickname)) user_nickname,case when s.id is not null then 1 else 0 end as is_shop FROM `benben_business_circle_likes` `bcl` LEFT JOIN `benben_user` `u` ON `bcl`.`user_id`=`u`.`id` LEFT JOIN `benben_shop` `s` ON `bcl`.`user_id`=s.user_id and s.is_del=0 and s.original_checked=1 WHERE `bcl`.`circle_id` = 181 ORDER BY `bcl`.`add_time` DESC LIMIT 0,4 [ slave|RunTime:0.007847s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `benben_business_circle` `bc` WHERE `bc`.`status` = 1 LIMIT 1 [ slave|RunTime:0.007618s ]
[ SQL ] SHOW COLUMNS FROM `benben_supply_circle` [ slave|RunTime:0.008577s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `benben_supply_circle` `bc` LEFT JOIN `benben_user` `u` ON `bc`.`user_id`=`u`.`id` LEFT JOIN `benben_goods_category` `gc` ON `bc`.`goods_cate_id`=`gc`.`cat_id` LEFT JOIN `benben_supply_circle_cate` `bcc` ON `bc`.`cate_id`=`bcc`.`cat_id` LEFT JOIN `benben_shop` `s` ON `bc`.`user_id`=s.user_id and s.is_del=0 and s.original_checked=1 LEFT JOIN `benben_shop_category` `sc` ON `s`.`category_id`=`sc`.`cat_id` WHERE `bc`.`status` = 1 AND `bc`.`is_limit` = 0 LIMIT 1 [ slave|RunTime:0.007893s ]
[ SQL ] SELECT bc.id,bc.cate_id,bc.goods_cate_id,bc.phone,bc.add_time,bc.img_url,bc.publish_location,bc.content,bc.likes,ifnull(s.id,u.id) user_id,ifnull(s.shop_name,from_base64(u.user_nickname)) user_nickname,ifnull(s.shop_logo,u.head_img) head_img,ifnull(s.mobile,u.mobile) mobile,u.is_vip,u.vip_type,case when s.id is not null then 1 else 0 end as is_shop,gc.cat_name goods_cat_name,bcc.cat_name as cat_name1,bcc.cat_alias_name,concat(gc.cat_name,bcc.cat_alias_name) cat_name,bc.end_time-1779170606 end_time,sc.shop_auth_code,s.original_checked,sc.type,bc.num_comment,sc.mark_down,s.id as shop_id FROM `benben_supply_circle` `bc` LEFT JOIN `benben_user` `u` ON `bc`.`user_id`=`u`.`id` LEFT JOIN `benben_goods_category` `gc` ON `bc`.`goods_cate_id`=`gc`.`cat_id` LEFT JOIN `benben_supply_circle_cate` `bcc` ON `bc`.`cate_id`=`bcc`.`cat_id` LEFT JOIN `benben_shop` `s` ON `bc`.`user_id`=s.user_id and s.is_del=0 and s.original_checked=1 LEFT JOIN `benben_shop_category` `sc` ON `s`.`category_id`=`sc`.`cat_id` WHERE `bc`.`status` = 1 AND `bc`.`is_limit` = 0 ORDER BY `bc`.`add_time` DESC LIMIT 0,3 [ slave|RunTime:0.008125s ]
[ SQL ] SHOW COLUMNS FROM `benben_supply_circle_comment` [ slave|RunTime:0.008329s ]
[ SQL ] SELECT scc.id,scc.circle_id,scc.content,scc.add_time,ifnull(s.id,u.id) as user_id,ifnull(s.shop_name,from_base64(u.user_nickname)) as user_nickname,ifnull(s.shop_logo,u.head_img) as head_img,case when s.id is not null then 1 else 0 end as is_shop,u.id as real_user_id,likes FROM `benben_supply_circle_comment` `scc` LEFT JOIN `benben_user` `u` ON `scc`.`user_id`=`u`.`id` LEFT JOIN `benben_shop` `s` ON `scc`.`user_id`=s.user_id and s.is_del=0 and s.original_checked=1 WHERE `scc`.`circle_id` = 335 AND `scc`.`parent_id` = 0 ORDER BY `scc`.`add_time` DESC LIMIT 0,3 [ slave|RunTime:0.007869s ]
[ SQL ] SHOW COLUMNS FROM `benben_supply_circle_likes` [ slave|RunTime:0.008243s ]
[ SQL ] SELECT ifnull(s.id,u.id) user_id,ifnull(s.shop_name,from_base64(u.user_nickname)) user_nickname FROM `benben_supply_circle_likes` `scl` LEFT JOIN `benben_user` `u` ON `scl`.`user_id`=`u`.`id` LEFT JOIN `benben_shop` `s` ON `scl`.`user_id`=s.user_id and s.original_checked=1 WHERE `scl`.`circle_id` = 335 ORDER BY `scl`.`add_time` DESC LIMIT 0,4 [ slave|RunTime:0.008137s ]
[ SQL ] SELECT scc.id,scc.circle_id,scc.content,scc.add_time,ifnull(s.id,u.id) as user_id,ifnull(s.shop_name,from_base64(u.user_nickname)) as user_nickname,ifnull(s.shop_logo,u.head_img) as head_img,case when s.id is not null then 1 else 0 end as is_shop,u.id as real_user_id,likes FROM `benben_supply_circle_comment` `scc` LEFT JOIN `benben_user` `u` ON `scc`.`user_id`=`u`.`id` LEFT JOIN `benben_shop` `s` ON `scc`.`user_id`=s.user_id and s.is_del=0 and s.original_checked=1 WHERE `scc`.`circle_id` = 333 AND `scc`.`parent_id` = 0 ORDER BY `scc`.`add_time` DESC LIMIT 0,3 [ slave|RunTime:0.008076s ]
[ SQL ] SELECT ifnull(s.id,u.id) user_id,ifnull(s.shop_name,from_base64(u.user_nickname)) user_nickname FROM `benben_supply_circle_likes` `scl` LEFT JOIN `benben_user` `u` ON `scl`.`user_id`=`u`.`id` LEFT JOIN `benben_shop` `s` ON `scl`.`user_id`=s.user_id and s.original_checked=1 WHERE `scl`.`circle_id` = 333 ORDER BY `scl`.`add_time` DESC LIMIT 0,4 [ slave|RunTime:0.007902s ]
[ SQL ] SELECT scc.id,scc.circle_id,scc.content,scc.add_time,ifnull(s.id,u.id) as user_id,ifnull(s.shop_name,from_base64(u.user_nickname)) as user_nickname,ifnull(s.shop_logo,u.head_img) as head_img,case when s.id is not null then 1 else 0 end as is_shop,u.id as real_user_id,likes FROM `benben_supply_circle_comment` `scc` LEFT JOIN `benben_user` `u` ON `scc`.`user_id`=`u`.`id` LEFT JOIN `benben_shop` `s` ON `scc`.`user_id`=s.user_id and s.is_del=0 and s.original_checked=1 WHERE `scc`.`circle_id` = 332 AND `scc`.`parent_id` = 0 ORDER BY `scc`.`add_time` DESC LIMIT 0,3 [ slave|RunTime:0.007864s ]
[ SQL ] SELECT ifnull(s.id,u.id) user_id,ifnull(s.shop_name,from_base64(u.user_nickname)) user_nickname FROM `benben_supply_circle_likes` `scl` LEFT JOIN `benben_user` `u` ON `scl`.`user_id`=`u`.`id` LEFT JOIN `benben_shop` `s` ON `scl`.`user_id`=s.user_id and s.original_checked=1 WHERE `scl`.`circle_id` = 332 ORDER BY `scl`.`add_time` DESC LIMIT 0,4 [ slave|RunTime:0.007755s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `benben_supply_circle` `bc` LEFT JOIN `benben_user` `u` ON `bc`.`user_id`=`u`.`id` WHERE `bc`.`status` = 1 AND `bc`.`is_limit` = 0 LIMIT 1 [ slave|RunTime:0.007626s ]
