Celebrating Liberty - nossairmandade.com

Messages Timeline Exceptions Views17 Route Queries22 Models42 Livewire0 Mails Gate Session Request

8.2.27356ms7MBGET hymn/{hymnId}/{hymnName?}

Booting (220ms)time
Application (136ms)time
1 x Booting (61.85%)
220ms
1 x Application (38.15%)
136ms

17 templates were rendered

1x hymns.hymnhymn.blade.phpblade
1x hymns.partials.audio_block_displayaudio_block_display.blade.phpblade
1x hymns.partials.audio_file_displayaudio_file_display.blade.phpblade
1x hymns.patterns.00.blade.phpblade
1x hymns.partials.notationnotation.blade.phpblade
1x hymns.patterns.print.00.blade.phpblade
1x hymns.partials.sun_moon_starssun_moon_stars.blade.phpblade
1x layouts.partials.other_mediaother_media.blade.phpblade
1x layouts.partials.feedback_formfeedback_form.blade.phpblade
1x layouts.appapp.blade.phpblade
1x layouts.partials.headhead.blade.phpblade
1x layouts.partials.page_toppage_top.blade.phpblade
1x layouts.partials.login_formlogin_form.blade.phpblade
1x layouts.partials.headerheader.blade.phpblade
1x layouts.partials.navnav.blade.phpblade
1x layouts.partials.footerfooter.blade.phpblade
1x layouts.partials.footer_jsfooter_js.blade.phpblade

uri: GET hymn/{hymnId}/{hymnName?}
middleware: web
controller: App\Http\Controllers\HymnController@show
namespace: App\Http\Controllers
prefix
where
file: app/Http/Controllers/HymnController.php:34-51

22 statements were executed, 4 of which were duplicates, 18 unique. Show only duplicated45.86ms

select * from `hymns` where `id` = '4160' limit 1

740μsnossadevHymnController.php#38

Bindings	0: 4160
Backtrace	15. app/Http/Controllers/HymnController.php:38 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `persons` where `persons`.`id` in (97)

530μsnossadevHymnController.php#38

Bindings	0: 97
Backtrace	20. app/Http/Controllers/HymnController.php:38 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `persons` where `persons`.`id` in (478)

520μsnossadevHymnController.php#38

Bindings	0: 478
Backtrace	20. app/Http/Controllers/HymnController.php:38 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `hymn_translations` where `hymn_translations`.`hymn_id` in (4160)

7.64msnossadevHymnController.php#38

Backtrace

20. app/Http/Controllers/HymnController.php:38
21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `hymn_hinarios` where `hymn_hinarios`.`hymn_id` in (4160)

1.96msnossadevHymnController.php#38

Backtrace

20. app/Http/Controllers/HymnController.php:38
21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `hinarios`.*, `hymn_hinarios`.`hymn_id` as `laravel_through_key` from `hinarios` inner join `hymn_hinarios` on `hymn_hinarios`.`hinario_id` = `hinarios`.`id` where `hymn_hinarios`.`hymn_id` = 4160

2.95msnossadevHymn.php#143

Bindings	0: 4160
Backtrace	19. app/Models/Hymn.php:143 20. view::hymns.hymn:68 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69

select * from `hymn_hinarios` where `hinario_id` = 132 order by `section_number` asc, `list_order` asc

4.07msnossadevHinario.php#42

Bindings	0: 132
Backtrace	14. app/Models/Hinario.php:42 15. view::hymns.hymn:75 17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69

select * from `hymns` where `hymns`.`id` = 4159 and `hymns`.`id` is not null limit 1

520μsnossadevHinario.php#45

Bindings	0: 4159
Backtrace	20. app/Models/Hinario.php:45 21. view::hymns.hymn:75 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 25. vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69

select * from `hymn_translations` where `hymn_translations`.`hymn_id` in (4159)

5.14msnossadevHinario.php#45

Backtrace

25. app/Models/Hinario.php:45
26. view::hymns.hymn:75
28. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
29. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
30. vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69

select * from `hinario_translations` where `hinario_translations`.`hinario_id` = 132 and `hinario_translations`.`hinario_id` is not null

680μsnossadevModelWithTranslations.php#31

Bindings	0: 132
Backtrace	19. app/Models/ModelWithTranslations.php:31 20. app/Models/ModelWithTranslations.php:15 21. app/Models/Hinario.php:110 22. view::hymns.hymn:82 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110

select * from `hymn_hinarios` where `hinario_id` = 132 order by `section_number` asc, `list_order` asc

3.19msnossadevHinario.php#57

Bindings	0: 132
Backtrace	14. app/Models/Hinario.php:57 15. view::hymns.hymn:86 17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69

select * from `hymns` where `hymns`.`id` = 4161 and `hymns`.`id` is not null limit 1

610μsnossadevHinario.php#60

Bindings	0: 4161
Backtrace	20. app/Models/Hinario.php:60 21. view::hymns.hymn:86 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 25. vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69

select * from `hymn_translations` where `hymn_translations`.`hymn_id` in (4161)

8.55msnossadevHinario.php#60

Backtrace

25. app/Models/Hinario.php:60
26. view::hymns.hymn:86
28. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
29. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
30. vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69

select `media_files`.*, `hymn_media_files`.`hymn_id` as `laravel_through_key` from `media_files` inner join `hymn_media_files` on `hymn_media_files`.`media_file_id` = `media_files`.`id` where `hymn_media_files`.`hymn_id` = 4160

2.67msnossadevHymn.php#161

Bindings	0: 4160
Backtrace	19. app/Models/Hymn.php:161 20. view::hymns.partials.audio_block_display:1 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69

select * from `media_file_upvotes` where `media_file_upvotes`.`media_file_id` in (4924)

420μsnossadevHymn.php#161

Backtrace

24. app/Models/Hymn.php:161
25. view::hymns.partials.audio_block_display:1
27. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
28. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
29. vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69

select * from `media_sources` where `media_sources`.`id` in (108)

670μsnossadevHymn.php#161

Bindings	0: 108
Backtrace	24. app/Models/Hymn.php:161 25. view::hymns.partials.audio_block_display:1 27. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 28. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 29. vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69

select * from `media_source_translations` where `media_source_translations`.`media_source_id` in (108)

550μsnossadevHymn.php#161

Backtrace

29. app/Models/Hymn.php:161
30. view::hymns.partials.audio_block_display:1
32. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
33. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
34. vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69

select * from `hymn_media_files` where `hymn_id` = 4160 and `media_file_id` = 4924 limit 1

2.68msnossadevHymn.php#241

Bindings	0: 4160 1: 4924
Backtrace	15. app/Models/Hymn.php:241 16. view::hymns.partials.audio_block_display:3 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 20. vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69

select * from `hymn_notation_translations` where `hymn_notation_translations`.`hymn_notation_id` = 0 and `hymn_notation_translations`.`hymn_notation_id` is not null

490μsnossadevHymn.php#39

Bindings	0: 0
Backtrace	19. app/Models/Hymn.php:39 20. view::hymns.partials.notation:3 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69

select * from `person_images` where `person_id` = 97 and `is_portrait` = 1 limit 1

420μsnossadevPerson.php#28

Bindings	0: 97 1: 1
Backtrace	15. app/Models/Person.php:28 16. view::hymns.hymn:221 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 20. vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69

select * from `person_images` where `person_images`.`person_id` = 97 and `person_images`.`person_id` is not null

430μsnossadevPerson.php#32

Bindings	0: 97
Backtrace	19. app/Models/Person.php:32 20. view::hymns.hymn:221 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69

select * from `person_images` where `person_id` = 97 and `is_portrait` = 1 limit 1

430μsnossadevPerson.php#28

Bindings	0: 97 1: 1
Backtrace	15. app/Models/Person.php:28 16. view::hymns.hymn:222 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 20. vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69

App\Models\HymnHinario: 27
App\Models\HymnTranslation: 4
App\Models\Hymn: 3
App\Models\Person: 2
App\Models\Hinario: 1
App\Models\HinarioTranslation: 1
App\Models\MediaFile: 1
App\Models\MediaSource: 1
App\Models\MediaSourceTranslation: 1
App\Models\HymnMediaFile: 1

_token: izTuUWVAr1k9b1lqG2iemHouUsIOizDe1ZFaF8IF
_previous: array:1 [ "url" => "https://dev.nossairmandade.com/hymn/4160/CelebratingLiberty" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/hymn/4160/CelebratingLiberty

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:17 [▼
  "content-length" => array:1 [▶
    0 => "0"
  ]
  "connection" => array:1 [▶
    0 => "close"
  ]
  "host" => array:1 [▶
    0 => "dev.nossairmandade.com"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "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 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Wed, 16 Apr 2025 13:19:31 GMT"
  ]
  "set-cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Im1HQmdXc3Q2VUVOSmZ6b3FzS1NwWXc9PSIsInZhbHVlIjoibnA2T28wemE0ZFJUQ2VkNHVpT0dYKys2TjJsWjhKSk1WRDRqVFlvWGtvK0FDb3lOZ3doWFVDaFFPNGs1Vk5OZy9ST09XdDZhMmNnL2xsMSt3V2lwSk5YWUZtREszVVB2TGdiK0o3cTZrS2REdU5tQW0rRTUxa0JvQ3UzU3J5VEEiLCJtYWMiOiI3MDQwNDkwOWFjOWNjODU1YmE4MDdjOGM3OWMyM2UxOWQ4ZWRlM2NhZjMyZWNkYjhjM2QxMmI3MGFkNDkzNzkxIiwidGFnIjoiIn0%3D; expires=Wed, 16 Apr 2025 15:19:31 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6Im1HQmdXc3Q2VUVOSmZ6b3FzS1NwWXc9PSIsInZhbHVlIjoibnA2T28wemE0ZFJUQ2VkNHVpT0dYKys2TjJsWjhKSk1WRDRqVFlvWGtvK0FDb3lOZ3doWFVDaFFPNGs1Vk5OZy9ST09Xd ▶"
    1 => "laravel_session=eyJpdiI6IjBmeW5UZ3RLSisrNjBWVFFBTWRXbHc9PSIsInZhbHVlIjoiMzd6ZnZPWW5yTlpEV2tYUzJzR1hudldmKzgyamNQa3dhWkxvZEVIN2MxeUV0WWxuUkNWcG42RmU0RUljRlVHai8xTkh6NmZIbWc4bFFBTDQwUU9ZdmtuSDVPK2hIN1JvOGdYcTJRdnU0Wmh6SjFTNGpWSStHdWpFY0tSRi9jUlgiLCJtYWMiOiJiMmE1Nzc0NDhlMGM2YjA1NGI3NTQzOWRkMzIwYTEzNTU0ZDA3NTNkZWI5ZTcxMGFkZGMwMDBmMDA3M2FhMzI3IiwidGFnIjoiIn0%3D; expires=Wed, 16 Apr 2025 15:19:31 GMT; Max-Age=7200; path=/; httponly ◀laravel_session=eyJpdiI6IjBmeW5UZ3RLSisrNjBWVFFBTWRXbHc9PSIsInZhbHVlIjoiMzd6ZnZPWW5yTlpEV2tYUzJzR1hudldmKzgyamNQa3dhWkxvZEVIN2MxeUV0WWxuUkNWcG42RmU0RUljRlVHai8x ▶"
    2 => "lid=eyJpdiI6IlRKV2MwVUZ2Mmt3ajkzdjdRcUhqYlE9PSIsInZhbHVlIjoiMytITGg3OWc2bSs3Qk9HVHRGajJZNmRNWFJxWlRjRnllVFJiUGJON1FZbUlTQWV4anBVVzJDS3dzSGpaaWdSbSIsIm1hYyI6ImRkMzJkMjExMmVjY2E5ZDNiZmRiMzc2ZjEzMjVlOGYxMmJjNWYzMDdjMjE0ODgxNzk3Mjk0N2MwMjY1MzZkM2MiLCJ0YWciOiIifQ%3D%3D; expires=Thu, 16 Apr 2026 13:19:31 GMT; Max-Age=31536000; path=/; httponly ◀lid=eyJpdiI6IlRKV2MwVUZ2Mmt3ajkzdjdRcUhqYlE9PSIsInZhbHVlIjoiMytITGg3OWc2bSs3Qk9HVHRGajJZNmRNWFJxWlRjRnllVFJiUGJON1FZbUlTQWV4anBVVzJDS3dzSGpaaWdSbSIsIm1hYyI6ImRk ▶"
  ]
  "Set-Cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Im1HQmdXc3Q2VUVOSmZ6b3FzS1NwWXc9PSIsInZhbHVlIjoibnA2T28wemE0ZFJUQ2VkNHVpT0dYKys2TjJsWjhKSk1WRDRqVFlvWGtvK0FDb3lOZ3doWFVDaFFPNGs1Vk5OZy9ST09XdDZhMmNnL2xsMSt3V2lwSk5YWUZtREszVVB2TGdiK0o3cTZrS2REdU5tQW0rRTUxa0JvQ3UzU3J5VEEiLCJtYWMiOiI3MDQwNDkwOWFjOWNjODU1YmE4MDdjOGM3OWMyM2UxOWQ4ZWRlM2NhZjMyZWNkYjhjM2QxMmI3MGFkNDkzNzkxIiwidGFnIjoiIn0%3D; expires=Wed, 16-Apr-2025 15:19:31 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Im1HQmdXc3Q2VUVOSmZ6b3FzS1NwWXc9PSIsInZhbHVlIjoibnA2T28wemE0ZFJUQ2VkNHVpT0dYKys2TjJsWjhKSk1WRDRqVFlvWGtvK0FDb3lOZ3doWFVDaFFPNGs1Vk5OZy9ST09Xd ▶"
    1 => "laravel_session=eyJpdiI6IjBmeW5UZ3RLSisrNjBWVFFBTWRXbHc9PSIsInZhbHVlIjoiMzd6ZnZPWW5yTlpEV2tYUzJzR1hudldmKzgyamNQa3dhWkxvZEVIN2MxeUV0WWxuUkNWcG42RmU0RUljRlVHai8xTkh6NmZIbWc4bFFBTDQwUU9ZdmtuSDVPK2hIN1JvOGdYcTJRdnU0Wmh6SjFTNGpWSStHdWpFY0tSRi9jUlgiLCJtYWMiOiJiMmE1Nzc0NDhlMGM2YjA1NGI3NTQzOWRkMzIwYTEzNTU0ZDA3NTNkZWI5ZTcxMGFkZGMwMDBmMDA3M2FhMzI3IiwidGFnIjoiIn0%3D; expires=Wed, 16-Apr-2025 15:19:31 GMT; path=/; httponly ◀laravel_session=eyJpdiI6IjBmeW5UZ3RLSisrNjBWVFFBTWRXbHc9PSIsInZhbHVlIjoiMzd6ZnZPWW5yTlpEV2tYUzJzR1hudldmKzgyamNQa3dhWkxvZEVIN2MxeUV0WWxuUkNWcG42RmU0RUljRlVHai8x ▶"
    2 => "lid=eyJpdiI6IlRKV2MwVUZ2Mmt3ajkzdjdRcUhqYlE9PSIsInZhbHVlIjoiMytITGg3OWc2bSs3Qk9HVHRGajJZNmRNWFJxWlRjRnllVFJiUGJON1FZbUlTQWV4anBVVzJDS3dzSGpaaWdSbSIsIm1hYyI6ImRkMzJkMjExMmVjY2E5ZDNiZmRiMzc2ZjEzMjVlOGYxMmJjNWYzMDdjMjE0ODgxNzk3Mjk0N2MwMjY1MzZkM2MiLCJ0YWciOiIifQ%3D%3D; expires=Thu, 16-Apr-2026 13:19:31 GMT; path=/; httponly ◀lid=eyJpdiI6IlRKV2MwVUZ2Mmt3ajkzdjdRcUhqYlE9PSIsInZhbHVlIjoiMytITGg3OWc2bSs3Qk9HVHRGajJZNmRNWFJxWlRjRnllVFJiUGJON1FZbUlTQWV4anBVVzJDS3dzSGpaaWdSbSIsIm1hYyI6ImRk ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▼
  "_token" => "izTuUWVAr1k9b1lqG2iemHouUsIOizDe1ZFaF8IF"
  "_previous" => array:1 [▶
    "url" => "https://dev.nossairmandade.com/hymn/4160/CelebratingLiberty"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

1 x Booting (61.85%)	220ms
1 x Application (38.15%)	136ms