1 x Application (92.5%) | 377ms |
1 x Booting (7.5%) | 30.56ms |
select `podcasts`.*, (select count(*) from `podcast_episodes` where `podcasts`.`id` = `podcast_episodes`.`podcast_id`) as `episodes_count` from `podcasts` where `slug` = 'linux-unplugged' order by `name` asc limit 1
Bindings |
|
Backtrace |
|
select max(`created_at`) as aggregate from `podcast_episodes`
Backtrace |
|
select distinct `podcast_hosts`.*, (select count(*) from `podcast_episodes` where `podcast_hosts`.`id` = `podcast_episodes`.`host_id`) as `episodes_count`, `podcast_episodes`.`podcast_id` as `laravel_through_key` from `podcast_hosts` inner join `podcast_episodes` on `podcast_episodes`.`host_id` = `podcast_hosts`.`id` where exists (select * from `podcast_episodes` where `podcast_hosts`.`id` = `podcast_episodes`.`host_id` and `created_at` >= '2024-10-11 21:47:00' order by `created_at` desc) and `podcast_episodes`.`podcast_id` in (4) order by `name` asc
Bindings |
|
Backtrace |
|
select * from `podcast_episodes` where `podcast_episodes`.`podcast_id` = 4 and `podcast_episodes`.`podcast_id` is not null and `slug` = '600/everyone-everywhere-all-at-once' order by `created_at` desc limit 1
Bindings |
|
Backtrace |
|
select `podcasts`.*, (select count(*) from `podcast_episodes` where `podcasts`.`id` = `podcast_episodes`.`podcast_id`) as `episodes_count` from `podcasts` where `podcasts`.`id` in (4) order by `name` asc
Backtrace |
|
select max(`created_at`) as aggregate from `podcast_episodes`
Backtrace |
|
select distinct `podcast_hosts`.*, (select count(*) from `podcast_episodes` where `podcast_hosts`.`id` = `podcast_episodes`.`host_id`) as `episodes_count`, `podcast_episodes`.`podcast_id` as `laravel_through_key` from `podcast_hosts` inner join `podcast_episodes` on `podcast_episodes`.`host_id` = `podcast_hosts`.`id` where exists (select * from `podcast_episodes` where `podcast_hosts`.`id` = `podcast_episodes`.`host_id` and `created_at` >= '2024-10-11 21:47:00' order by `created_at` desc) and `podcast_episodes`.`podcast_id` in (4) order by `name` asc
Bindings |
|
Backtrace |
|
select `podcast_hosts`.*, (select count(*) from `podcast_episodes` where `podcast_hosts`.`id` = `podcast_episodes`.`host_id`) as `episodes_count`, `podcast_episode_hosts`.`episode_id` as `pivot_episode_id`, `podcast_episode_hosts`.`host_id` as `pivot_host_id` from `podcast_hosts` inner join `podcast_episode_hosts` on `podcast_hosts`.`id` = `podcast_episode_hosts`.`host_id` where `podcast_episode_hosts`.`episode_id` = 1000 order by `name` asc
Bindings |
|
Backtrace |
|
select * from `podcast_episodes` where `podcast_episodes`.`podcast_id` = 4 and `podcast_episodes`.`podcast_id` is not null and `created_at` < '2025-02-02 19:00:00' order by `created_at` desc limit 1
Bindings |
|
Backtrace |
|
select `podcasts`.*, (select count(*) from `podcast_episodes` where `podcasts`.`id` = `podcast_episodes`.`podcast_id`) as `episodes_count` from `podcasts` where `podcasts`.`id` in (4) order by `name` asc
Backtrace |
|
select max(`created_at`) as aggregate from `podcast_episodes`
Backtrace |
|
select distinct `podcast_hosts`.*, (select count(*) from `podcast_episodes` where `podcast_hosts`.`id` = `podcast_episodes`.`host_id`) as `episodes_count`, `podcast_episodes`.`podcast_id` as `laravel_through_key` from `podcast_hosts` inner join `podcast_episodes` on `podcast_episodes`.`host_id` = `podcast_hosts`.`id` where exists (select * from `podcast_episodes` where `podcast_hosts`.`id` = `podcast_episodes`.`host_id` and `created_at` >= '2024-10-11 21:47:00' order by `created_at` desc) and `podcast_episodes`.`podcast_id` in (4) order by `name` asc
Bindings |
|
Backtrace |
|
select * from `podcast_episodes` where `podcast_episodes`.`podcast_id` = 4 and `podcast_episodes`.`podcast_id` is not null and `created_at` > '2025-02-02 19:00:00' order by `created_at` asc, `created_at` desc limit 1
Bindings |
|
Backtrace |
|
select `podcasts`.*, (select count(*) from `podcast_episodes` where `podcasts`.`id` = `podcast_episodes`.`podcast_id`) as `episodes_count` from `podcasts` where `podcasts`.`id` in (4) order by `name` asc
Backtrace |
|
select max(`created_at`) as aggregate from `podcast_episodes`
Backtrace |
|
select distinct `podcast_hosts`.*, (select count(*) from `podcast_episodes` where `podcast_hosts`.`id` = `podcast_episodes`.`host_id`) as `episodes_count`, `podcast_episodes`.`podcast_id` as `laravel_through_key` from `podcast_hosts` inner join `podcast_episodes` on `podcast_episodes`.`host_id` = `podcast_hosts`.`id` where exists (select * from `podcast_episodes` where `podcast_hosts`.`id` = `podcast_episodes`.`host_id` and `created_at` >= '2024-10-11 21:47:00' order by `created_at` desc) and `podcast_episodes`.`podcast_id` in (4) order by `name` asc
Bindings |
|
Backtrace |
|
select `podcast_playlists`.*, (select count(*) from `podcast_episodes` inner join `podcast_episode_playlists` on `podcast_episodes`.`id` = `podcast_episode_playlists`.`episode_id` where `podcast_playlists`.`id` = `podcast_episode_playlists`.`playlist_id`) as `episodes_count`, `podcast_episode_playlists`.`episode_id` as `pivot_episode_id`, `podcast_episode_playlists`.`playlist_id` as `pivot_playlist_id` from `podcast_playlists` inner join `podcast_episode_playlists` on `podcast_playlists`.`id` = `podcast_episode_playlists`.`playlist_id` where `podcast_episode_playlists`.`episode_id` = 1000 order by `name` asc
Bindings |
|
Backtrace |
|
select * from `podcast_episodes` where `podcast_episodes`.`podcast_id` = 4 and `podcast_episodes`.`podcast_id` is not null and exists (select * from `podcast_playlists` inner join `podcast_episode_playlists` on `podcast_playlists`.`id` = `podcast_episode_playlists`.`playlist_id` where `podcast_episodes`.`id` = `podcast_episode_playlists`.`episode_id` and 0 = 1 order by `name` asc) and `id` not in ('{\"id\":1000,\"title\":\"Everyone, Everywhere, All at Once\",\"slug\":\"600\/everyone-everywhere-all-at-once\",\"season\":null,\"number\":\"600\",\"guest\":null,\"duration\":\"1:08:50\",\"media_url\":\"https:\/\/aphid.fireside.fm\/d\/1437767933\/f31a453c-fa15-491f-8618-3f71f1d565e5\/62834d7c-515b-4ad9-9614-221ea0fce7ba.mp3\",\"image_url\":\"https:\/\/assets.fireside.fm\/file\/fireside-images\/podcasts\/images\/f\/f31a453c-fa15-491f-8618-3f71f1d565e5\/cover.jpg\",\"created_at\":\"2025-02-02T19:00:00.000000Z\",\"date\":\"Feb 2, 2025\",\"excerpt\":\"We celebrate 600 episodes, announce a new show feature, and officially launch the FreeBSD challenge.\",\"headline\":\"Linux Unplugged Episode 600: Everyone, Everywhere, All at Once\",\"player_url\":\"https:\/\/lawhuborg-www-dev.azurewebsites.net\/podcasts\/linux-unplugged\/player\/600\/everyone-everywhere-all-at-once\",\"url\":\"https:\/\/lawhuborg-www-dev.azurewebsites.net\/podcasts\/linux-unplugged\/600\/everyone-everywhere-all-at-once\"}', '{\"id\":999,\"title\":\"Psycho Shower Linux Power\",\"slug\":\"599\/psycho-shower-linux-power\",\"season\":null,\"number\":\"599\",\"guest\":null,\"duration\":\"1:02:12\",\"media_url\":\"https:\/\/aphid.fireside.fm\/d\/1437767933\/f31a453c-fa15-491f-8618-3f71f1d565e5\/18bdc1c3-db01-4f3d-8813-eb4a4a4af8e7.mp3\",\"image_url\":\"https:\/\/assets.fireside.fm\/file\/fireside-images\/podcasts\/images\/f\/f31a453c-fa15-491f-8618-3f71f1d565e5\/cover.jpg\",\"created_at\":\"2025-01-26T16:30:00.000000Z\",\"date\":\"Jan 26, 2025\",\"excerpt\":\"On the eve of episode 600, we introduce our next challenge and explore the new wave of Linux phones.\",\"headline\":\"Linux Unplugged Episode 599: Psycho Shower Linux Power\",\"player_url\":\"https:\/\/lawhuborg-www-dev.azurewebsites.net\/podcasts\/linux-unplugged\/player\/599\/psycho-shower-linux-power\",\"url\":\"https:\/\/lawhuborg-www-dev.azurewebsites.net\/podcasts\/linux-unplugged\/599\/psycho-shower-linux-power\"}', '{\"id\":1001,\"title\":\"Taming the Demons\",\"slug\":\"601\/taming-the-demons\",\"season\":null,\"number\":\"601\",\"guest\":null,\"duration\":\"1:08:42\",\"media_url\":\"https:\/\/aphid.fireside.fm\/d\/1437767933\/f31a453c-fa15-491f-8618-3f71f1d565e5\/75da12ed-c228-4e80-b259-287ef42cc42c.mp3\",\"image_url\":\"https:\/\/assets.fireside.fm\/file\/fireside-images\/podcasts\/images\/f\/f31a453c-fa15-491f-8618-3f71f1d565e5\/cover.jpg\",\"created_at\":\"2025-02-09T16:15:00.000000Z\",\"date\":\"Feb 9, 2025\",\"excerpt\":\"It\'s week one of our FreeBSD challenge, and for one of us, that penalty Windows install looks uncomfortably close! Plus, Zach Mitchell joins us to update us on Planet Nix.\",\"headline\":\"Linux Unplugged Episode 601: Taming the Demons\",\"player_url\":\"https:\/\/lawhuborg-www-dev.azurewebsites.net\/podcasts\/linux-unplugged\/player\/601\/taming-the-demons\",\"url\":\"https:\/\/lawhuborg-www-dev.azurewebsites.net\/podcasts\/linux-unplugged\/601\/taming-the-demons\"}') order by `created_at` desc limit 5
Bindings |
|
Backtrace |
|
select `tags`.*, `podcast_episode_tags`.`episode_id` as `pivot_episode_id`, `podcast_episode_tags`.`tag_id` as `pivot_tag_id` from `tags` inner join `podcast_episode_tags` on `tags`.`id` = `podcast_episode_tags`.`tag_id` where `podcast_episode_tags`.`episode_id` = 1000 order by `name` asc
Bindings |
|
Backtrace |
|
select * from `podcast_episodes` where `podcast_episodes`.`podcast_id` = 4 and `podcast_episodes`.`podcast_id` is not null and exists (select * from `tags` inner join `podcast_episode_tags` on `tags`.`id` = `podcast_episode_tags`.`tag_id` where `podcast_episodes`.`id` = `podcast_episode_tags`.`episode_id` and 0 = 1 order by `name` asc) and `id` not in (1000, 999, 1001) order by `created_at` desc limit 5
Bindings |
|
Backtrace |
|
select `podcast_sponsors`.*, (select count(*) from `podcast_episodes` inner join `podcast_episode_sponsors` on `podcast_episodes`.`id` = `podcast_episode_sponsors`.`episode_id` where `podcast_sponsors`.`id` = `podcast_episode_sponsors`.`sponsor_id`) as `episodes_count`, `podcast_episode_sponsors`.`episode_id` as `pivot_episode_id`, `podcast_episode_sponsors`.`sponsor_id` as `pivot_sponsor_id` from `podcast_sponsors` inner join `podcast_episode_sponsors` on `podcast_sponsors`.`id` = `podcast_episode_sponsors`.`sponsor_id` where `podcast_episode_sponsors`.`episode_id` = 1000 order by `name` asc
Bindings |
|
Backtrace |
|
200
[]
[]
0 of 0array:35 [▼ "sec-fetch-mode" => array:1 [▶ 0 => "navigate" ] "sec-fetch-user" => array:1 [▶ 0 => "?1" ] "sec-fetch-dest" => array:1 [▶ 0 => "document" ] "x-arr-log-id" => array:1 [▶ 0 => "d71eaf37-0464-4ca2-8f3a-44763ade7188" ] "client-ip" => array:1 [▶ 0 => "18.191.236.82:45110" ] "disguised-host" => array:1 [▶ 0 => "lawhuborg-www-dev.azurewebsites.net" ] "x-site-deployment-id" => array:1 [▶ 0 => "lawhuborg-www-dev" ] "was-default-hostname" => array:1 [▶ 0 => "lawhuborg-www-dev.azurewebsites.net" ] "x-appservice-proto" => array:1 [▶ 0 => "https" ] "x-arr-ssl" => array:1 [▶ 0 => "2048|256|CN=Microsoft Azure RSA TLS Issuing CA 08, O=Microsoft Corporation, C=US|CN=*.azurewebsites.net, O=Microsoft Corporation, L=Redmond, S=WA, C=US" ] "x-forwarded-tlsversion" => array:1 [▶ 0 => "1.3" ] "x-forwarded-for" => array:1 [▶ 0 => "18.191.236.82:45110,20.96.237.171" ] "x-original-url" => array:1 [▶ 0 => "/podcasts/linux-unplugged/600/everyone-everywhere-all-at-once" ] "x-waws-unencoded-url" => array:1 [▶ 0 => "/podcasts/linux-unplugged/600/everyone-everywhere-all-at-once" ] "x-client-ip" => array:1 [▶ 0 => "18.191.236.82" ] "x-client-port" => array:1 [▶ 0 => "45110" ] "sec-ch-ua-platform" => array:1 [▶ 0 => ""Windows"" ] "x-forwarded-host" => array:1 [▶ 0 => "lawhuborg-www-dev.azurewebsites.net" ] "sec-ch-ua-mobile" => array:1 [▶ 0 => "?0" ] "cf-ipcountry" => array:1 [▶ 0 => "US" ] "cf-connecting-ip" => array:1 [▶ 0 => "20.96.237.171" ] "sec-ch-ua" => array:1 [▶ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "cf-visitor" => array:1 [▶ 0 => "{"scheme":"https"}" ] "max-forwards" => array:1 [▶ 0 => "10" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "x-forwarded-proto" => array:1 [▶ 0 => "https" ] "cdn-loop" => array:1 [▶ 0 => "cloudflare; loops=1" ] "accept-encoding" => array:1 [▶ 0 => "gzip, br" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "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" ] "cf-ray" => array:1 [▶ 0 => "92fdefdbb82ec9bb-EWR" ] "connection" => array:1 [▶ 0 => "close" ] "host" => array:1 [▶ 0 => "lawhuborg-www-dev.azurewebsites.net" ] ]
[]
0 of 0array:7 [▼ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "private, must-revalidate" ] "date" => array:1 [▶ 0 => "Sun, 13 Apr 2025 21:08:07 GMT" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "expires" => array:1 [▶ 0 => "-1" ] "set-cookie" => array:1 [▶ 0 => "XSRF-TOKEN=vWC7sSzkZgEaGGJy6hfIpDHNmQC8RfbUNyvNHIFr; expires=Mon, 14 Apr 2025 21:08:08 GMT; Max-Age=86400; path=/; secure; samesite=none" ] "Set-Cookie" => array:1 [▶ 0 => "XSRF-TOKEN=vWC7sSzkZgEaGGJy6hfIpDHNmQC8RfbUNyvNHIFr; expires=Mon, 14-Apr-2025 21:08:08 GMT; path=/; secure" ] ]
0 of 0array:2 [▼ "_token" => "vWC7sSzkZgEaGGJy6hfIpDHNmQC8RfbUNyvNHIFr" "PHPDEBUGBAR_STACK_DATA" => [] ]