1 x Application (93.65%) | 1.31s |
1 x Booting (6.35%) | 88.88ms |
select count(*) as aggregate from `users` left join `instructors` as `ins` on `ins`.`user_id` = `users`.`id` left join `organizations` as `org` on `org`.`user_id` = `users`.`id` where `users`.`role` in (2, 4) and (`ins`.`status` = 1 or `org`.`status` = 1) and `users`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select `users`.*, `ins`.`organization_id`, case when org.id is null then ins.uuid else org.uuid end as uuid,
case when org.id is null then ins.country_id else org.country_id end as country_id,
case when org.id is null then ins.province_id else org.province_id end as province_id,
case when org.id is null then ins.state_id else org.state_id end as state_id,
case when org.id is null then ins.city_id else org.city_id end as city_id,
case when org.id is null then ins.professional_title else org.professional_title end as professional_title,
case when org.id is null then ins.postal_code else org.postal_code end as postal_code,
case when org.id is null then ins.address else org.address end as address,
case when org.id is null then ins.about_me else org.about_me end as about_me,
case when org.id is null then ins.gender else org.gender end as gender,
case when org.id is null then ins.social_link else org.social_link end as social_link,
case when org.id is null then ins.slug else org.slug end as slug,
case when org.id is null then ins.is_private else org.is_private end as is_private,
case when org.id is null then ins.remove_from_web_search else org.remove_from_web_search end as remove_from_web_search,
case when org.id is null then ins.is_offline else org.is_offline end as is_offline,
case when org.id is null then ins.offline_message else org.offline_message end as offline_message,
case when org.id is null then ins.consultation_available else org.consultation_available end as consultation_available,
case when org.id is null then ins.hourly_rate else org.hourly_rate end as hourly_rate,
case when org.id is null then ins.hourly_old_rate else org.hourly_old_rate end as hourly_old_rate,
case when org.id is null then ins.available_type else org.available_type end as available_type,
case when org.id is null then ins.created_at else org.created_at end as approval_date from `users` left join `instructors` as `ins` on `ins`.`user_id` = `users`.`id` left join `organizations` as `org` on `org`.`user_id` = `users`.`id` where `users`.`role` in (2, 4) and (`ins`.`status` = 1 or `org`.`status` = 1) and `users`.`deleted_at` is null limit 12 offset 24
Bindings |
|
Backtrace |
|
select `ranking_levels`.*, `user_badges`.`user_id` as `pivot_user_id`, `user_badges`.`ranking_level_id` as `pivot_ranking_level_id` from `ranking_levels` inner join `user_badges` on `ranking_levels`.`id` = `user_badges`.`ranking_level_id` where `user_badges`.`user_id` = 128993
Bindings |
|
Backtrace |
|
select * from `courses` where `courses`.`user_id` = 128993 and `courses`.`user_id` is not null
Bindings |
|
Backtrace |
|
select `ranking_levels`.*, `user_badges`.`user_id` as `pivot_user_id`, `user_badges`.`ranking_level_id` as `pivot_ranking_level_id` from `ranking_levels` inner join `user_badges` on `ranking_levels`.`id` = `user_badges`.`ranking_level_id` where `user_badges`.`user_id` = 128994
Bindings |
|
Backtrace |
|
select * from `courses` where `courses`.`user_id` = 128994 and `courses`.`user_id` is not null
Bindings |
|
Backtrace |
|
select `ranking_levels`.*, `user_badges`.`user_id` as `pivot_user_id`, `user_badges`.`ranking_level_id` as `pivot_ranking_level_id` from `ranking_levels` inner join `user_badges` on `ranking_levels`.`id` = `user_badges`.`ranking_level_id` where `user_badges`.`user_id` = 128995
Bindings |
|
Backtrace |
|
select * from `courses` where `courses`.`user_id` = 128995 and `courses`.`user_id` is not null
Bindings |
|
Backtrace |
|
select `ranking_levels`.*, `user_badges`.`user_id` as `pivot_user_id`, `user_badges`.`ranking_level_id` as `pivot_ranking_level_id` from `ranking_levels` inner join `user_badges` on `ranking_levels`.`id` = `user_badges`.`ranking_level_id` where `user_badges`.`user_id` = 128996
Bindings |
|
Backtrace |
|
select * from `courses` where `courses`.`user_id` = 128996 and `courses`.`user_id` is not null
Bindings |
|
Backtrace |
|
select `ranking_levels`.*, `user_badges`.`user_id` as `pivot_user_id`, `user_badges`.`ranking_level_id` as `pivot_ranking_level_id` from `ranking_levels` inner join `user_badges` on `ranking_levels`.`id` = `user_badges`.`ranking_level_id` where `user_badges`.`user_id` = 128997
Bindings |
|
Backtrace |
|
select * from `courses` where `courses`.`user_id` = 128997 and `courses`.`user_id` is not null
Bindings |
|
Backtrace |
|
select `ranking_levels`.*, `user_badges`.`user_id` as `pivot_user_id`, `user_badges`.`ranking_level_id` as `pivot_ranking_level_id` from `ranking_levels` inner join `user_badges` on `ranking_levels`.`id` = `user_badges`.`ranking_level_id` where `user_badges`.`user_id` = 128998
Bindings |
|
Backtrace |
|
select * from `courses` where `courses`.`user_id` = 128998 and `courses`.`user_id` is not null
Bindings |
|
Backtrace |
|
select `ranking_levels`.*, `user_badges`.`user_id` as `pivot_user_id`, `user_badges`.`ranking_level_id` as `pivot_ranking_level_id` from `ranking_levels` inner join `user_badges` on `ranking_levels`.`id` = `user_badges`.`ranking_level_id` where `user_badges`.`user_id` = 128999
Bindings |
|
Backtrace |
|
select * from `courses` where `courses`.`user_id` = 128999 and `courses`.`user_id` is not null
Bindings |
|
Backtrace |
|
select `ranking_levels`.*, `user_badges`.`user_id` as `pivot_user_id`, `user_badges`.`ranking_level_id` as `pivot_ranking_level_id` from `ranking_levels` inner join `user_badges` on `ranking_levels`.`id` = `user_badges`.`ranking_level_id` where `user_badges`.`user_id` = 129000
Bindings |
|
Backtrace |
|
select * from `courses` where `courses`.`user_id` = 129000 and `courses`.`user_id` is not null
Bindings |
|
Backtrace |
|
select `ranking_levels`.*, `user_badges`.`user_id` as `pivot_user_id`, `user_badges`.`ranking_level_id` as `pivot_ranking_level_id` from `ranking_levels` inner join `user_badges` on `ranking_levels`.`id` = `user_badges`.`ranking_level_id` where `user_badges`.`user_id` = 129001
Bindings |
|
Backtrace |
|
select * from `courses` where `courses`.`user_id` = 129001 and `courses`.`user_id` is not null
Bindings |
|
Backtrace |
|
select `ranking_levels`.*, `user_badges`.`user_id` as `pivot_user_id`, `user_badges`.`ranking_level_id` as `pivot_ranking_level_id` from `ranking_levels` inner join `user_badges` on `ranking_levels`.`id` = `user_badges`.`ranking_level_id` where `user_badges`.`user_id` = 129002
Bindings |
|
Backtrace |
|
select * from `courses` where `courses`.`user_id` = 129002 and `courses`.`user_id` is not null
Bindings |
|
Backtrace |
|
select `ranking_levels`.*, `user_badges`.`user_id` as `pivot_user_id`, `user_badges`.`ranking_level_id` as `pivot_ranking_level_id` from `ranking_levels` inner join `user_badges` on `ranking_levels`.`id` = `user_badges`.`ranking_level_id` where `user_badges`.`user_id` = 129003
Bindings |
|
Backtrace |
|
select * from `courses` where `courses`.`user_id` = 129003 and `courses`.`user_id` is not null
Bindings |
|
Backtrace |
|
select `ranking_levels`.*, `user_badges`.`user_id` as `pivot_user_id`, `user_badges`.`ranking_level_id` as `pivot_ranking_level_id` from `ranking_levels` inner join `user_badges` on `ranking_levels`.`id` = `user_badges`.`ranking_level_id` where `user_badges`.`user_id` = 129004
Bindings |
|
Backtrace |
|
select * from `courses` where `courses`.`user_id` = 129004 and `courses`.`user_id` is not null
Bindings |
|
Backtrace |
|
select `meta_title`, `meta_description`, `meta_keyword`, `og_image` from `metas` where `slug` = 'default' limit 1
Bindings |
|
Backtrace |
|
select * from `languages` where `iso_code` = 'ar' limit 1
Bindings |
|
Backtrace |
|
select * from `categories` where `status` = 1
Bindings |
|
Backtrace |
|
select * from `subcategories` where `subcategories`.`category_id` in (1, 2, 3, 4, 6, 12, 13, 14, 15)
Backtrace |
|
select count(*) as aggregate from `cart_management` where `user_id` is null
Backtrace |
|
select count(*) as aggregate from `wishlists` where `user_id` is null
Backtrace |
|
select * from `menus`
Backtrace |
|
select * from `menus` where `status` = 1 and `type` = 1
Bindings |
|
Backtrace |
|
select * from `menus` where `status` = 1 and `type` = 2
Bindings |
|
Backtrace |
|
select * from `notifications` where `user_id` is null and `user_type` = 3 and `is_seen` = 'no' order by `created_at` desc
Bindings |
|
Backtrace |
|
select * from `notifications` where `user_id` is null and `user_type` = 2 and `is_seen` = 'no' order by `created_at` desc
Bindings |
|
Backtrace |
|
select * from `languages` where `status` = 1
Bindings |
|
Backtrace |
|
select * from `menus` where `status` = 1
Bindings |
|
Backtrace |
|
select * from `menus` where `status` = 1 and `type` = 2
Bindings |
|
Backtrace |
|
select * from `menus` where `status` = 1 and `type` = 3
Bindings |
|
Backtrace |
|
select * from `menus` where `status` = 1 and `type` = 4
Bindings |
|
Backtrace |
|
200
0 of 0array:1 [▼ "page" => "3" ]
[]
0 of 0array:16 [▼ "x-https" => array:1 [▶ 0 => "1" ] "accept-encoding" => array:1 [▶ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [▶ 0 => "document" ] "sec-fetch-user" => array:1 [▶ 0 => "?1" ] "sec-fetch-mode" => array:1 [▶ 0 => "navigate" ] "sec-fetch-site" => array:1 [▶ 0 => "none" ] "accept" => array:1 [▶ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] "sec-ch-ua-platform" => array:1 [▶ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [▶ 0 => "?0" ] "sec-ch-ua" => array:1 [▶ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "connection" => array:1 [▶ 0 => "keep-alive" ] "host" => array:1 [▶ 0 => "plan-b-eg.online" ] ]
[]
0 of 0array:5 [▼ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Fri, 04 Jul 2025 12:42:49 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IlhoQ2cweTA3anBRK3QvZVhCSndodXc9PSIsInZhbHVlIjoiZ0FUcTJoY1poc1g5MjRzTzlVWCtwcGpMYmtpK0JRSGhPT3cxVmhaUDBXbWFHVHZlZ01tcHRuV1g2d2lCdkcrdk8vbGNGODVzL0xqYVBaMStXSEZqWmtrR3pYcTlQZ2NqVmZNYlZWcmVSZHVCNmVGS2ZDRU9DZGdnK1JWRTVnNlMiLCJtYWMiOiI1NDg0MmRlYTI5MGQxNWE5MWJlZTJhOWU1OTkyZjFlNmUyNjdkMzcwNmY1NzI4OTM3ZGNkYzU0Y2JkZmUxYTY5IiwidGFnIjoiIn0%3D; expires=Fri, 04 Jul 2025 14:42:50 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IlhoQ2cweTA3anBRK3QvZVhCSndodXc9PSIsInZhbHVlIjoiZ0FUcTJoY1poc1g5MjRzTzlVWCtwcGpMYmtpK0JRSGhPT3cxVmhaUDBXbWFHVHZlZ01tcHRuV1g2d2lCdkcrdk8vbGNGO ▶" 1 => "planb_session=eyJpdiI6IjRadHdoUTQyT2tFY3RRQytHUDduZ3c9PSIsInZhbHVlIjoiZ1RWQ0RKZEloZEdWR05IdG90UUNVQWtQOEtGWENHd205NUl4OHRyZ2hiMThBYlI4NGtGQTN5VUIzc0ZzZnI5QzZxaVRQMFlpWTlQbWVTd2x6a0daL3lPWmlvOXU3TzdJM1lLR09ZeUZxdWlkY2JSOFl2UjlhQTVDUEJ4K081R04iLCJtYWMiOiJhY2VkYTFkMjlhZDMzNTM1ODA5MjgzMjY2NjY5Mzg4OGQ0ZWJiMzkxMzgwZjViNzM4ZmIwNzFiZmU4ZWVjMTMxIiwidGFnIjoiIn0%3D; expires=Fri, 04 Jul 2025 14:42:50 GMT; Max-Age=7200; path=/; httponly ◀planb_session=eyJpdiI6IjRadHdoUTQyT2tFY3RRQytHUDduZ3c9PSIsInZhbHVlIjoiZ1RWQ0RKZEloZEdWR05IdG90UUNVQWtQOEtGWENHd205NUl4OHRyZ2hiMThBYlI4NGtGQTN5VUIzc0ZzZnI5QzZxaV ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IlhoQ2cweTA3anBRK3QvZVhCSndodXc9PSIsInZhbHVlIjoiZ0FUcTJoY1poc1g5MjRzTzlVWCtwcGpMYmtpK0JRSGhPT3cxVmhaUDBXbWFHVHZlZ01tcHRuV1g2d2lCdkcrdk8vbGNGODVzL0xqYVBaMStXSEZqWmtrR3pYcTlQZ2NqVmZNYlZWcmVSZHVCNmVGS2ZDRU9DZGdnK1JWRTVnNlMiLCJtYWMiOiI1NDg0MmRlYTI5MGQxNWE5MWJlZTJhOWU1OTkyZjFlNmUyNjdkMzcwNmY1NzI4OTM3ZGNkYzU0Y2JkZmUxYTY5IiwidGFnIjoiIn0%3D; expires=Fri, 04-Jul-2025 14:42:50 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IlhoQ2cweTA3anBRK3QvZVhCSndodXc9PSIsInZhbHVlIjoiZ0FUcTJoY1poc1g5MjRzTzlVWCtwcGpMYmtpK0JRSGhPT3cxVmhaUDBXbWFHVHZlZ01tcHRuV1g2d2lCdkcrdk8vbGNGO ▶" 1 => "planb_session=eyJpdiI6IjRadHdoUTQyT2tFY3RRQytHUDduZ3c9PSIsInZhbHVlIjoiZ1RWQ0RKZEloZEdWR05IdG90UUNVQWtQOEtGWENHd205NUl4OHRyZ2hiMThBYlI4NGtGQTN5VUIzc0ZzZnI5QzZxaVRQMFlpWTlQbWVTd2x6a0daL3lPWmlvOXU3TzdJM1lLR09ZeUZxdWlkY2JSOFl2UjlhQTVDUEJ4K081R04iLCJtYWMiOiJhY2VkYTFkMjlhZDMzNTM1ODA5MjgzMjY2NjY5Mzg4OGQ0ZWJiMzkxMzgwZjViNzM4ZmIwNzFiZmU4ZWVjMTMxIiwidGFnIjoiIn0%3D; expires=Fri, 04-Jul-2025 14:42:50 GMT; path=/; httponly ◀planb_session=eyJpdiI6IjRadHdoUTQyT2tFY3RRQytHUDduZ3c9PSIsInZhbHVlIjoiZ1RWQ0RKZEloZEdWR05IdG90UUNVQWtQOEtGWENHd205NUl4OHRyZ2hiMThBYlI4NGtGQTN5VUIzc0ZzZnI5QzZxaV ▶" ] ]
0 of 0array:5 [▼ "local" => "ar" "_token" => "yzQ5pQMAqb6fzpvXr2B1jMCKmlc61lRAdeUsEeXA" "_previous" => array:1 [▶ "url" => "https://plan-b-eg.online/all-instructor?page=3" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]