Union - nossairmandade.com

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

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

Booting (299ms)time
Application (171ms)time
1 x Booting (63.55%)
299ms
1 x Application (36.45%)
171ms

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 duplicated59.75ms

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

670μsnossadevHymnController.php#38

Bindings	0: 1581
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 (56)

400μsnossadevHymnController.php#38

Bindings	0: 56
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 ('')

430μsnossadevHymnController.php#38

Bindings	0:
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 (1581)

8.48msnossadevHymnController.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 (1581)

2.26msnossadevHymnController.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` = 1581

3.03msnossadevHymn.php#143

Bindings	0: 1581
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` = 54 order by `section_number` asc, `list_order` asc

3.48msnossadevHinario.php#42

Bindings	0: 54
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` = 1580 and `hymns`.`id` is not null limit 1

540μsnossadevHinario.php#45

Bindings	0: 1580
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 (1580)

7.41msnossadevHinario.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` = 54 and `hinario_translations`.`hinario_id` is not null

600μsnossadevModelWithTranslations.php#31

Bindings	0: 54
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` = 54 order by `section_number` asc, `list_order` asc

3.92msnossadevHinario.php#57

Bindings	0: 54
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` = 1582 and `hymns`.`id` is not null limit 1

560μsnossadevHinario.php#60

Bindings	0: 1582
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 (1582)

9.03msnossadevHinario.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` = 1581

4.23msnossadevHymn.php#161

Bindings	0: 1581
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 (4304)

490μ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 (5)

1.04msnossadevHymn.php#161

Bindings	0: 5
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 (5)

3.3msnossadevHymn.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` = 1581 and `media_file_id` = 4304 limit 1

6.35msnossadevHymn.php#241

Bindings	0: 1581 1: 4304
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

740μ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` = 56 and `is_portrait` = 1 limit 1

910μsnossadevPerson.php#28

Bindings	0: 56 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` = 56 and `person_images`.`person_id` is not null

1.17msnossadevPerson.php#32

Bindings	0: 56
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` = 56 and `is_portrait` = 1 limit 1

710μsnossadevPerson.php#28

Bindings	0: 56 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: 89
App\Models\Hymn: 3
App\Models\HymnTranslation: 3
App\Models\Person: 1
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: f8LHRp2ysyvZdPDT2JptkNvqnLX2qoCCuLcA8kFZ
_previous: array:1 [ "url" => "https://dev.nossairmandade.com/hymn/1581/Union" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/hymn/1581/Union

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 => "Mon, 14 Apr 2025 11:45:25 GMT"
  ]
  "set-cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlFMak5CNzZscm5wRHJMV056dXRjeXc9PSIsInZhbHVlIjoiemx2L0dKQzJ1SE1tQTBlNmV0TVVMUU42Y1RnaEpiWWJkTlpHQlg3blJ2dXE3Y1lOUkpmdjhDZlByNzg4dm5UazRrM1QrL3haNTJWcFVQRzdvdDZPUTBNRXR4MWcwcGRaVnByUEJmVkNTWkFXamw1dnJpK0tLUjlHYUVWS05EMjQiLCJtYWMiOiJmOTcwNjFkOWEzMTAzNTM3ZDY0OTcyOGE2YTZhY2E3YjkyMDkyZWNiMGJlY2ZmMDBiZTk5ZmY3MmE2MzEwNDUxIiwidGFnIjoiIn0%3D; expires=Mon, 14 Apr 2025 13:45:25 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IlFMak5CNzZscm5wRHJMV056dXRjeXc9PSIsInZhbHVlIjoiemx2L0dKQzJ1SE1tQTBlNmV0TVVMUU42Y1RnaEpiWWJkTlpHQlg3blJ2dXE3Y1lOUkpmdjhDZlByNzg4dm5UazRrM1QrL ▶"
    1 => "laravel_session=eyJpdiI6Ik5adGhzWlk2THVjbytRbUNOaGRvV1E9PSIsInZhbHVlIjoiSkFlSXc5N2syQWVrTE8reE1EaDV0eTYybUZQMnpoR0hrYk5zbytpdkV2cnlpS0FjdWhSSEYydHk0SXVETG80czdVZjhHeTdQMFRxSkRDMWVybVdhTG1BbHJsVTVZb05sQVBlVmZXL2RnODVHYS9PUWNPbGJ5OXV4bG1RZUM2VE8iLCJtYWMiOiJjNjdiNTkzYTI1ZjVkZWY4NzVmYTI2YjkyMWRmYzkzMWZmYzFjMzgwNTUxNjM3YWFiZWQxY2I1YmFjNTZkNzg2IiwidGFnIjoiIn0%3D; expires=Mon, 14 Apr 2025 13:45:25 GMT; Max-Age=7200; path=/; httponly ◀laravel_session=eyJpdiI6Ik5adGhzWlk2THVjbytRbUNOaGRvV1E9PSIsInZhbHVlIjoiSkFlSXc5N2syQWVrTE8reE1EaDV0eTYybUZQMnpoR0hrYk5zbytpdkV2cnlpS0FjdWhSSEYydHk0SXVETG80czdV ▶"
    2 => "lid=eyJpdiI6IlF0MDFVaW5seGhyZEVlN1hpTDJ4M3c9PSIsInZhbHVlIjoiMWNXK2JjZWFJeHRIN0M3UldvbTBHbkJVZ2JJcy9uNUVNVWZGckhscFVySE1DYnhmYngyN01YeFBPekt5UWxSYSIsIm1hYyI6ImE5MmI3ZTJhYTJkMTY1MGZhYTgzYTMwNDM0M2VjNDM5YzU3OTBjZDFlNTJkZDExNjIzZGYxMGFhZjQ1MmU0MWQiLCJ0YWciOiIifQ%3D%3D; expires=Tue, 14 Apr 2026 11:45:25 GMT; Max-Age=31536000; path=/; httponly ◀lid=eyJpdiI6IlF0MDFVaW5seGhyZEVlN1hpTDJ4M3c9PSIsInZhbHVlIjoiMWNXK2JjZWFJeHRIN0M3UldvbTBHbkJVZ2JJcy9uNUVNVWZGckhscFVySE1DYnhmYngyN01YeFBPekt5UWxSYSIsIm1hYyI6ImE5 ▶"
  ]
  "Set-Cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlFMak5CNzZscm5wRHJMV056dXRjeXc9PSIsInZhbHVlIjoiemx2L0dKQzJ1SE1tQTBlNmV0TVVMUU42Y1RnaEpiWWJkTlpHQlg3blJ2dXE3Y1lOUkpmdjhDZlByNzg4dm5UazRrM1QrL3haNTJWcFVQRzdvdDZPUTBNRXR4MWcwcGRaVnByUEJmVkNTWkFXamw1dnJpK0tLUjlHYUVWS05EMjQiLCJtYWMiOiJmOTcwNjFkOWEzMTAzNTM3ZDY0OTcyOGE2YTZhY2E3YjkyMDkyZWNiMGJlY2ZmMDBiZTk5ZmY3MmE2MzEwNDUxIiwidGFnIjoiIn0%3D; expires=Mon, 14-Apr-2025 13:45:25 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IlFMak5CNzZscm5wRHJMV056dXRjeXc9PSIsInZhbHVlIjoiemx2L0dKQzJ1SE1tQTBlNmV0TVVMUU42Y1RnaEpiWWJkTlpHQlg3blJ2dXE3Y1lOUkpmdjhDZlByNzg4dm5UazRrM1QrL ▶"
    1 => "laravel_session=eyJpdiI6Ik5adGhzWlk2THVjbytRbUNOaGRvV1E9PSIsInZhbHVlIjoiSkFlSXc5N2syQWVrTE8reE1EaDV0eTYybUZQMnpoR0hrYk5zbytpdkV2cnlpS0FjdWhSSEYydHk0SXVETG80czdVZjhHeTdQMFRxSkRDMWVybVdhTG1BbHJsVTVZb05sQVBlVmZXL2RnODVHYS9PUWNPbGJ5OXV4bG1RZUM2VE8iLCJtYWMiOiJjNjdiNTkzYTI1ZjVkZWY4NzVmYTI2YjkyMWRmYzkzMWZmYzFjMzgwNTUxNjM3YWFiZWQxY2I1YmFjNTZkNzg2IiwidGFnIjoiIn0%3D; expires=Mon, 14-Apr-2025 13:45:25 GMT; path=/; httponly ◀laravel_session=eyJpdiI6Ik5adGhzWlk2THVjbytRbUNOaGRvV1E9PSIsInZhbHVlIjoiSkFlSXc5N2syQWVrTE8reE1EaDV0eTYybUZQMnpoR0hrYk5zbytpdkV2cnlpS0FjdWhSSEYydHk0SXVETG80czdV ▶"
    2 => "lid=eyJpdiI6IlF0MDFVaW5seGhyZEVlN1hpTDJ4M3c9PSIsInZhbHVlIjoiMWNXK2JjZWFJeHRIN0M3UldvbTBHbkJVZ2JJcy9uNUVNVWZGckhscFVySE1DYnhmYngyN01YeFBPekt5UWxSYSIsIm1hYyI6ImE5MmI3ZTJhYTJkMTY1MGZhYTgzYTMwNDM0M2VjNDM5YzU3OTBjZDFlNTJkZDExNjIzZGYxMGFhZjQ1MmU0MWQiLCJ0YWciOiIifQ%3D%3D; expires=Tue, 14-Apr-2026 11:45:25 GMT; path=/; httponly ◀lid=eyJpdiI6IlF0MDFVaW5seGhyZEVlN1hpTDJ4M3c9PSIsInZhbHVlIjoiMWNXK2JjZWFJeHRIN0M3UldvbTBHbkJVZ2JJcy9uNUVNVWZGckhscFVySE1DYnhmYngyN01YeFBPekt5UWxSYSIsIm1hYyI6ImE5 ▶"
  ]
]

session_attributes

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

1 x Booting (63.55%)	299ms
1 x Application (36.45%)	171ms