Ave Maria - nossairmandade.com

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

8.2.28124ms2MBGET hymn/{hymnId}/{hymnName?}

Booting (26.28ms)time
Application (97.35ms)time
1 x Application (78.74%)
97.35ms
1 x Booting (21.26%)
26.28ms

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 duplicated51.95ms

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

750μsnossadevHymnController.php#38

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

630μsnossadevHymnController.php#38

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

490μsnossadevHymnController.php#38

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

7.62msnossadevHymnController.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 (2210)

1.99msnossadevHymnController.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` = 2210

3.19msnossadevHymn.php#143

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

3.79msnossadevHinario.php#42

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

700μsnossadevHinario.php#45

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

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

940μsnossadevModelWithTranslations.php#31

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

2.37msnossadevHinario.php#57

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

950μsnossadevHinario.php#60

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

7.42msnossadevHinario.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` = 2210

3.58msnossadevHymn.php#161

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

510μ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 (46)

320μsnossadevHymn.php#161

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

450μ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` = 2210 and `media_file_id` = 4847 limit 1

2.51msnossadevHymn.php#241

Bindings	0: 2210 1: 4847
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

1.3msnossadevHymn.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` = 79 and `is_portrait` = 1 limit 1

690μsnossadevPerson.php#28

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

1.21msnossadevPerson.php#32

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

1.31msnossadevPerson.php#28

Bindings	0: 79 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: 127
App\Models\Hymn: 3
App\Models\HymnTranslation: 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: h1AOx7CJwGDXejtMFnejUe1LkPG4RO12zaTtznCW
_previous: array:1 [ "url" => "https://dev.nossairmandade.com/hymn/2210/AveMaria" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/hymn/2210/AveMaria

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 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "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 => "Sun, 08 Jun 2025 12:57:17 GMT"
  ]
  "set-cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlZmWGZlS1M5Yjlra3UzSXMvYlNtNFE9PSIsInZhbHVlIjoiekpsY1JHSUxCR2RjTDRVbko3NWlYd1gvbWR5SStzaFM5MXphTFJGUngzOW9wKzM0akJTRGxrZGp3M1pPSGpPSXgvci80S3JNRVRPaE00YlFCTzNqM2RKajRkdFpyTnhNc1FHbzc2Qm5MQjByaExQWjdJdGw2RkE5akFmWVVwRUEiLCJtYWMiOiIwN2VlYTdjM2ExMjIyMDMwYmM3NDc2YWE5NjAxODRlMTcwMjU5YzIwZTYwOTc1ZGYyNmFmMGNjNjc2MzViMTI1IiwidGFnIjoiIn0%3D; expires=Sun, 08 Jun 2025 14:57:17 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IlZmWGZlS1M5Yjlra3UzSXMvYlNtNFE9PSIsInZhbHVlIjoiekpsY1JHSUxCR2RjTDRVbko3NWlYd1gvbWR5SStzaFM5MXphTFJGUngzOW9wKzM0akJTRGxrZGp3M1pPSGpPSXgvci80S ▶"
    1 => "laravel_session=eyJpdiI6IlZQcUlvMDBNZkdsTjdiY3FDMTlEdmc9PSIsInZhbHVlIjoiQ21mWEIzRmdDYlhZUllFNGN6Q2RHZHc3OE1OWHVnUmhvUmZWRi9yMm5hb0o4TFRDV3ladU1mQnk0VXRGczczOUxkSlRTUUd6VGt1SzBYbEtpWXc1WktpaUszSlNFbSt4d3VnN2hPYmJSM1YwT0Fmd1htZGhpWWZTV09jOGdaYzciLCJtYWMiOiJmNmNkNTMyNjcxNGE0ZGFjMzIyY2MwODVhMDA0YmRiYzMwOTZlNDA3OWVkNzBmYzhmZTRiYjk2NzBlNTI1YTQ2IiwidGFnIjoiIn0%3D; expires=Sun, 08 Jun 2025 14:57:17 GMT; Max-Age=7200; path=/; httponly ◀laravel_session=eyJpdiI6IlZQcUlvMDBNZkdsTjdiY3FDMTlEdmc9PSIsInZhbHVlIjoiQ21mWEIzRmdDYlhZUllFNGN6Q2RHZHc3OE1OWHVnUmhvUmZWRi9yMm5hb0o4TFRDV3ladU1mQnk0VXRGczczOUxk ▶"
    2 => "lid=eyJpdiI6Im5GUCt5OUgwdHI5djFxT2U2QmxuQkE9PSIsInZhbHVlIjoiNkhEa1ZLVTZpbGFuS2pxMFpJTWxnbE1DamE2RU1QbHhidGFHYmUwV0l3Vi9HTmpNNlQzaklrS05waFFIeGNTTCIsIm1hYyI6Ijc5MjViMmU0NDA1Yjc5ZTQ0OWMyYzBmZTUzZjBkN2UxYTI5MDA1NWM5OGM2NzAyMGM1ZDY2YjQ1ZWU4OGZjYjciLCJ0YWciOiIifQ%3D%3D; expires=Mon, 08 Jun 2026 12:57:17 GMT; Max-Age=31536000; path=/; httponly ◀lid=eyJpdiI6Im5GUCt5OUgwdHI5djFxT2U2QmxuQkE9PSIsInZhbHVlIjoiNkhEa1ZLVTZpbGFuS2pxMFpJTWxnbE1DamE2RU1QbHhidGFHYmUwV0l3Vi9HTmpNNlQzaklrS05waFFIeGNTTCIsIm1hYyI6Ijc5 ▶"
  ]
  "Set-Cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlZmWGZlS1M5Yjlra3UzSXMvYlNtNFE9PSIsInZhbHVlIjoiekpsY1JHSUxCR2RjTDRVbko3NWlYd1gvbWR5SStzaFM5MXphTFJGUngzOW9wKzM0akJTRGxrZGp3M1pPSGpPSXgvci80S3JNRVRPaE00YlFCTzNqM2RKajRkdFpyTnhNc1FHbzc2Qm5MQjByaExQWjdJdGw2RkE5akFmWVVwRUEiLCJtYWMiOiIwN2VlYTdjM2ExMjIyMDMwYmM3NDc2YWE5NjAxODRlMTcwMjU5YzIwZTYwOTc1ZGYyNmFmMGNjNjc2MzViMTI1IiwidGFnIjoiIn0%3D; expires=Sun, 08-Jun-2025 14:57:17 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IlZmWGZlS1M5Yjlra3UzSXMvYlNtNFE9PSIsInZhbHVlIjoiekpsY1JHSUxCR2RjTDRVbko3NWlYd1gvbWR5SStzaFM5MXphTFJGUngzOW9wKzM0akJTRGxrZGp3M1pPSGpPSXgvci80S ▶"
    1 => "laravel_session=eyJpdiI6IlZQcUlvMDBNZkdsTjdiY3FDMTlEdmc9PSIsInZhbHVlIjoiQ21mWEIzRmdDYlhZUllFNGN6Q2RHZHc3OE1OWHVnUmhvUmZWRi9yMm5hb0o4TFRDV3ladU1mQnk0VXRGczczOUxkSlRTUUd6VGt1SzBYbEtpWXc1WktpaUszSlNFbSt4d3VnN2hPYmJSM1YwT0Fmd1htZGhpWWZTV09jOGdaYzciLCJtYWMiOiJmNmNkNTMyNjcxNGE0ZGFjMzIyY2MwODVhMDA0YmRiYzMwOTZlNDA3OWVkNzBmYzhmZTRiYjk2NzBlNTI1YTQ2IiwidGFnIjoiIn0%3D; expires=Sun, 08-Jun-2025 14:57:17 GMT; path=/; httponly ◀laravel_session=eyJpdiI6IlZQcUlvMDBNZkdsTjdiY3FDMTlEdmc9PSIsInZhbHVlIjoiQ21mWEIzRmdDYlhZUllFNGN6Q2RHZHc3OE1OWHVnUmhvUmZWRi9yMm5hb0o4TFRDV3ladU1mQnk0VXRGczczOUxk ▶"
    2 => "lid=eyJpdiI6Im5GUCt5OUgwdHI5djFxT2U2QmxuQkE9PSIsInZhbHVlIjoiNkhEa1ZLVTZpbGFuS2pxMFpJTWxnbE1DamE2RU1QbHhidGFHYmUwV0l3Vi9HTmpNNlQzaklrS05waFFIeGNTTCIsIm1hYyI6Ijc5MjViMmU0NDA1Yjc5ZTQ0OWMyYzBmZTUzZjBkN2UxYTI5MDA1NWM5OGM2NzAyMGM1ZDY2YjQ1ZWU4OGZjYjciLCJ0YWciOiIifQ%3D%3D; expires=Mon, 08-Jun-2026 12:57:17 GMT; path=/; httponly ◀lid=eyJpdiI6Im5GUCt5OUgwdHI5djFxT2U2QmxuQkE9PSIsInZhbHVlIjoiNkhEa1ZLVTZpbGFuS2pxMFpJTWxnbE1DamE2RU1QbHhidGFHYmUwV0l3Vi9HTmpNNlQzaklrS05waFFIeGNTTCIsIm1hYyI6Ijc5 ▶"
  ]
]

session_attributes

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

1 x Application (78.74%)	97.35ms
1 x Booting (21.26%)	26.28ms