Linux Unplugged Podcast

Weekly Linux talk show with no script, no limits, surprise guests and tons of opinion.

Tagged: Non-Profit

Linux Festivus For the Rest of Us
The first LinuxFest is back and better than ever. We share stories and friends from one of the best Linux gatherings of the year: LinuxFest Northwest.
Episode 560
Apr 28, 2024
1:15:10

Search

Listen on

Apple Podcasts Spotify RSS feed

Messages Timeline Exceptions Views19 Route Queries11 Models5 Mails Gate Session Request

Request history8.3.6161ms4MBGET podcasts/{podcast}/tags/{tag}

Booting (35.34ms)time
Application (125ms)time
1 x Application (77.98%)
125ms
1 x Booting (22.02%)
35.34ms

19 templates were rendered

1x podcasts.tagtag.blade.php#?blade
1x layouts.podcastpodcast.blade.php#?blade
2x podcasts.iframeiframe.blade.php#?blade
1x podcasts.partials.playerplayer.blade.php#?blade
1x podcasts.partials.listenlisten.blade.php#?blade
1x layouts.lawhublawhub.blade.php#?blade
1x layouts.appapp.blade.php#?blade
1x components.navnav.blade.php#?blade
1x partials.breadcrumbsbreadcrumbs.blade.php#?blade
1x components.bannerbanner.blade.php#?blade
1x layouts.basebase.blade.php#?blade
1x partials.metameta.blade.php#?blade
1x partials.gtmgtm.blade.php#?blade
1x breadcrumbs::json-ldjson-ld.php#?php
1x partials.iconsicons.blade.php#?blade
1x partials.assetsassets.blade.php#?blade
1x partials.gtm_noscriptgtm_noscript.blade.php#?blade
1x partials.session_messagessession_messages.blade.php#?blade

uri: GET podcasts/{podcast}/tags/{tag}
middleware: web
domain: https://lawhuborg-www-dev.azurewebsites.net
controller: App\Http\Controllers\PodcastController@tag
namespace: App\Http\Controllers
prefix: podcasts/{podcast:slug}
where
as: podcasts.tags.show
file: app/Http/Controllers/PodcastController.php:95-100

11 statements were executed, 4 of which were duplicates, 7 unique. Show only duplicated29.91ms

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

8.6mslawschooltransparency_stageImplicitRouteBinding.php#61

Bindings	0: linux-unplugged
Backtrace	17. vendor/laravel/framework/src/Illuminate/Routing/ImplicitRouteBinding.php:61 18. vendor/laravel/framework/src/Illuminate/Routing/Router.php:959 21. middleware::bindings:41 22. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183 23. vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:78

select max(`created_at`) as aggregate from `podcast_episodes`

3.42mslawschooltransparency_stagePodcast.php#116

Backtrace

19. app/Podcast.php:116
26. app/Podcast.php:115
35. vendor/laravel/framework/src/Illuminate/Routing/ImplicitRouteBinding.php:61
36. vendor/laravel/framework/src/Illuminate/Routing/Router.php:959
39. middleware::bindings:41

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-06 17:00:00' order by `created_at` desc) and `podcast_episodes`.`podcast_id` in (4) order by `name` asc

3.29mslawschooltransparency_stageExecutesQueries.php#34

Bindings	0: 2024-10-06 17:00:00
Backtrace	15. vendor/staudenmeir/eloquent-has-many-deep/src/Eloquent/Relations/Traits/ExecutesQueries.php:34 22. vendor/laravel/framework/src/Illuminate/Routing/ImplicitRouteBinding.php:61 23. vendor/laravel/framework/src/Illuminate/Routing/Router.php:959 26. middleware::bindings:41 27. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183

select distinct `tags`.*, `podcast_episodes`.`podcast_id` as `laravel_through_key` from `tags` inner join `podcast_episode_tags` on `podcast_episode_tags`.`tag_id` = `tags`.`id` inner join `podcast_episodes` on `podcast_episodes`.`id` = `podcast_episode_tags`.`episode_id` where `podcast_episodes`.`podcast_id` = 4 and `tags`.`slug` = 'non-profit' order by `name` asc limit 1

1.65mslawschooltransparency_stageExecutesQueries.php#34

Bindings	0: 4 1: non-profit
Backtrace	15. vendor/staudenmeir/eloquent-has-many-deep/src/Eloquent/Relations/Traits/ExecutesQueries.php:34 18. vendor/laravel/framework/src/Illuminate/Routing/ImplicitRouteBinding.php:56 19. vendor/laravel/framework/src/Illuminate/Routing/Router.php:959 22. middleware::bindings:41 23. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183

select `podcast_episodes`.*, `podcast_episode_tags`.`tag_id` as `pivot_tag_id`, `podcast_episode_tags`.`episode_id` as `pivot_episode_id` from `podcast_episodes` inner join `podcast_episode_tags` on `podcast_episodes`.`id` = `podcast_episode_tags`.`episode_id` where `podcast_episode_tags`.`tag_id` = 62 and `podcast_id` = 4 order by `created_at` desc

1.9mslawschooltransparency_stagePodcastController.php#97

Bindings

0: 62
1: 4

Backtrace

15. app/Http/Controllers/PodcastController.php:97
16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
18. vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21
19. vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

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

1.52mslawschooltransparency_stagePodcastController.php#97

Backtrace

20. app/Http/Controllers/PodcastController.php:97
21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
23. vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21
24. vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select max(`created_at`) as aggregate from `podcast_episodes`

2.07mslawschooltransparency_stagePodcast.php#116

Backtrace

19. app/Podcast.php:116
26. app/Podcast.php:115
38. app/Http/Controllers/PodcastController.php:97
39. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
40. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

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-06 17:00:00' order by `created_at` desc) and `podcast_episodes`.`podcast_id` in (4) order by `name` asc

3.5mslawschooltransparency_stageExecutesQueries.php#34

Bindings

0: 2024-10-06 17:00:00

Backtrace

15. vendor/staudenmeir/eloquent-has-many-deep/src/Eloquent/Relations/Traits/ExecutesQueries.php:34
25. app/Http/Controllers/PodcastController.php:97
26. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
27. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
28. vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21

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` in (959) order by `name` asc

1.41mslawschooltransparency_stagePodcastController.php#97

Backtrace

19. app/Http/Controllers/PodcastController.php:97
20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
22. vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21
23. vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

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` in (959) order by `name` asc

1.06mslawschooltransparency_stagePodcastController.php#97

Backtrace

19. app/Http/Controllers/PodcastController.php:97
20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
22. vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21
23. vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

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` = 959 order by `name` asc

1.49mslawschooltransparency_stagepodcast.blade.php#20

Bindings	0: 959
Backtrace	15. view::layouts.podcast:20 17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72 20. vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/ViewEngineDecorator.php:34

App\Podcast: 2Podcast.php#?
App\Tag: 2Tag.php#?
App\PodcastEpisode: 1PodcastEpisode.php#?

_token: YMpeYAp5rzy2kYKMPFMntnfSoBC1Fm8UoyZTrBMd
PHPDEBUGBAR_STACK_DATA: []

telescope

View in Telescope

path_info

/podcasts/linux-unplugged/tags/non-profit

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array: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 => "a929690d-cdc8-4a9a-accf-e8979f9d6bb0"
  ]
  "client-ip" => array:1 [▶
    0 => "3.144.8.165:50388"
  ]
  "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 => "3.144.8.165:50388,20.96.237.171"
  ]
  "x-original-url" => array:1 [▶
    0 => "/podcasts/linux-unplugged/tags/non-profit"
  ]
  "x-waws-unencoded-url" => array:1 [▶
    0 => "/podcasts/linux-unplugged/tags/non-profit"
  ]
  "x-client-ip" => array:1 [▶
    0 => "3.144.8.165"
  ]
  "x-client-port" => array:1 [▶
    0 => "50388"
  ]
  "cdn-loop" => array:1 [▶
    0 => "cloudflare; loops=1"
  ]
  "x-forwarded-host" => array:1 [▶
    0 => "lawhuborg-www-dev.azurewebsites.net"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "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"
  ]
  "cf-ipcountry" => array:1 [▶
    0 => "US"
  ]
  "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 => "92d2afe95bafc9bb-EWR"
  ]
  "connection" => array:1 [▶
    0 => "close"
  ]
  "host" => array:1 [▶
    0 => "lawhuborg-www-dev.azurewebsites.net"
  ]
]

request_cookies

[]

response_headers

  0 of 0   
array:7 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "private, must-revalidate"
  ]
  "date" => array:1 [▶
    0 => "Tue, 08 Apr 2025 15:09:40 GMT"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => "-1"
  ]
  "set-cookie" => array:1 [▶
    0 => "XSRF-TOKEN=YMpeYAp5rzy2kYKMPFMntnfSoBC1Fm8UoyZTrBMd; expires=Wed, 09 Apr 2025 15:09:40 GMT; Max-Age=86400; path=/; secure; samesite=none"
  ]
  "Set-Cookie" => array:1 [▶
    0 => "XSRF-TOKEN=YMpeYAp5rzy2kYKMPFMntnfSoBC1Fm8UoyZTrBMd; expires=Wed, 09-Apr-2025 15:09:40 GMT; path=/; secure"
  ]
]

session_attributes

  0 of 0   
array:2 [▼
  "_token" => "YMpeYAp5rzy2kYKMPFMntnfSoBC1Fm8UoyZTrBMd"
  "PHPDEBUGBAR_STACK_DATA" => []
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-08 15:09:40	GET	/podcasts/linux-unplugged/tags/non-profit	19 11 5

1 x Application (77.98%)	125ms
1 x Booting (22.02%)	35.34ms

Tagged: Non-Profit

Linux Festivus For the Rest of Us

Search

Listen on