# Query soft limit for Debugbar is reached after 100 queries, additional 7 queries onlyshow the query. Limits can be raised in the config (debugbar.options.db.soft_limit)
PeopleController.php#417proddbConnection Established
Friendship.php#305proddb14.56msselect friends.friend_user_id, friends.friend_favour, t4.parent_id from (
SELECT
IF(
t2.id ISNOTNULL,
t1.second_user,
IF(
t3.id ISNOTNULL,
t1.first_user,
NULL
)
) AS friend_user_id, friend_favour
FROM friendships AS t1
LEFTJOIN users AS t2 ON t1.first_user = t2.id and t2.id =205LEFTJOIN users AS t3 ON t1.second_user = t3.id and t3.id =205where (t1.first_user =205or t1.second_user =205) and (t1.status ='confirmed')
GROUPBY friend_user_id
ORDERBY t1.id desc
) as friends innerjoin `users` as `t4` on `t4`.`id` = `friends`.`friend_user_id` leftjoin `personalinformations` as `t5` on `t5`.`user_id` = `friends`.`friend_user_id` leftjoin `attending_addreses` as `t6` on `t6`.`user_id` = `friends`.`friend_user_id` leftjoin `states` as `t7` on `t7`.`id` = `t6`.`state` where `t4`.`deleted_at` isnull
PeopleController.php#490proddb56.53msselect `users`.*, (selectcount(*) from `wholesale_products` where `users`.`id` = `wholesale_products`.`user_id` and `wholesale_products`.`deleted_at` isnull) as `products_count`, (selectcount(*) from `post_attachments` where `users`.`id` = `post_attachments`.`user_id` and `type` =2) as `videos_count`, (selectcount(*) from `post_attachments` where `users`.`id` = `post_attachments`.`user_id` and `type` =1) as `images_count` from `users` where `id` in (13070, 10230, 12237, 13415, 14067, 11287, 14148, 11835, 11361, 10670, 12987, 11973, 13578, 12138, 12159, 12328, 12649, 14150, 12072, 13687, 14021, 13048, 14174, 12625, 10821, 12157, 11901, 12744, 13920, 11870) and `users`.`deleted_at` isnullorderby `first_name` asc