Here I Am - nossairmandade.com

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

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

Booting (302ms)time
Application (150ms)time
1 x Booting (66.71%)
302ms
1 x Application (33.29%)
150ms

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 duplicated50ms

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

790μsnossadevHymnController.php#38

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

590μ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 ('')

850μ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 (1599)

8.93msnossadevHymnController.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 (1599)

2.25msnossadevHymnController.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` = 1599

4.82msnossadevHymn.php#143

Bindings	0: 1599
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.17msnossadevHinario.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` = 1598 and `hymns`.`id` is not null limit 1

430μsnossadevHinario.php#45

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

5.12msnossadevHinario.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

910μ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.98msnossadevHinario.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` = 1600 and `hymns`.`id` is not null limit 1

450μsnossadevHinario.php#60

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

4.6msnossadevHinario.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` = 1599

3.67msnossadevHymn.php#161

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

910μ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)

440μsnossadevHymn.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)

720μ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` = 1599 and `media_file_id` = 4321 limit 1

3.96msnossadevHymn.php#241

Bindings	0: 1599 1: 4321
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

720μ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

700μ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

950μsnossadevPerson.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

1.04msnossadevPerson.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\HymnTranslation: 4
App\Models\Hymn: 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: BmNwXdOodZfuBRX2dsJ0fJnZ0uRvSfaS3gmfYTD9
_previous: array:1 [ "url" => "https://dev.nossairmandade.com/hymn/1599/HereIAm" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/hymn/1599/HereIAm

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 13:37:18 GMT"
  ]
  "set-cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InlERjBXS1pDbTNqZDNFQ2tuOTd6MVE9PSIsInZhbHVlIjoiTEdqbjB6ejRYMlhtYnhNZmM4TlprOGNybDhjejZLa0x1bWtUS1d5OXg1U0YxQ0lJcDdsL1c4Y2FlSWxjRzF6UDViVC8rV2JEREFFTlBTUzlCZjBSQnc0WXF4T2JoRmZtMUx6WUZNVFViNEY3eVY3dkhyT2FLcXFBUHZYL09XekoiLCJtYWMiOiI0OWY5ZDU0OGNmNmQyOTZiMjE1ZmYwOWI3NWM1YWNhMWIyZTZlNzc4YjM1ODA1YzU3YTViMmFlODg4YjNlZmI4IiwidGFnIjoiIn0%3D; expires=Mon, 14 Apr 2025 15:37:18 GMT; Max-Age=7199; path=/ ◀XSRF-TOKEN=eyJpdiI6InlERjBXS1pDbTNqZDNFQ2tuOTd6MVE9PSIsInZhbHVlIjoiTEdqbjB6ejRYMlhtYnhNZmM4TlprOGNybDhjejZLa0x1bWtUS1d5OXg1U0YxQ0lJcDdsL1c4Y2FlSWxjRzF6UDViVC8rV ▶"
    1 => "laravel_session=eyJpdiI6IkRuSXF0c1VnVXhzVkd6OXZTb1BqK2c9PSIsInZhbHVlIjoiZ0dqUEpJMHlVOU43NW56eWI5aWl6bE4vQUppYUgvSlBoS2tZZEx4NkRRMkFHZ1dlNis1bCtZRTRBUVZFWUFCbmd6MVdldExIREtuazNhQzRlTnlsZWZFOHByaW0xS1hENklOUmw0UXZ4R3NzalQ0dDZ4ZHhWZ0Fab0t2aGhEOHgiLCJtYWMiOiI3MjlhNDI2MmQ4YzA3ODljM2U2MTMwZjNmY2QyMjViMDA1OTYxNmVhY2FlYTg1NTYzNjg1NjBjNWFjZjE1OWRhIiwidGFnIjoiIn0%3D; expires=Mon, 14 Apr 2025 15:37:18 GMT; Max-Age=7199; path=/; httponly ◀laravel_session=eyJpdiI6IkRuSXF0c1VnVXhzVkd6OXZTb1BqK2c9PSIsInZhbHVlIjoiZ0dqUEpJMHlVOU43NW56eWI5aWl6bE4vQUppYUgvSlBoS2tZZEx4NkRRMkFHZ1dlNis1bCtZRTRBUVZFWUFCbmd6 ▶"
    2 => "lid=eyJpdiI6IlBPNG1lbFVMeTFuOUFoNndsUlF1N3c9PSIsInZhbHVlIjoiOWQwRlJZNUJQd1MvS1lJS2RlRC9qWm0wbW1lR1NrOTZzbWNWSVJTbjBZQ0dTSzA4UlFqcEozVzkzckk1RnhYQSIsIm1hYyI6IjRiZmYwNTkxZmFlNTE0ZGQ5NjI0ZjkwYzVmODk2ZWZkNDA0ZmFmM2ZhYzkyNzdiM2M2MmJiYjdiNDczYjc2ZDciLCJ0YWciOiIifQ%3D%3D; expires=Tue, 14 Apr 2026 13:37:18 GMT; Max-Age=31535999; path=/; httponly ◀lid=eyJpdiI6IlBPNG1lbFVMeTFuOUFoNndsUlF1N3c9PSIsInZhbHVlIjoiOWQwRlJZNUJQd1MvS1lJS2RlRC9qWm0wbW1lR1NrOTZzbWNWSVJTbjBZQ0dTSzA4UlFqcEozVzkzckk1RnhYQSIsIm1hYyI6IjRi ▶"
  ]
  "Set-Cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InlERjBXS1pDbTNqZDNFQ2tuOTd6MVE9PSIsInZhbHVlIjoiTEdqbjB6ejRYMlhtYnhNZmM4TlprOGNybDhjejZLa0x1bWtUS1d5OXg1U0YxQ0lJcDdsL1c4Y2FlSWxjRzF6UDViVC8rV2JEREFFTlBTUzlCZjBSQnc0WXF4T2JoRmZtMUx6WUZNVFViNEY3eVY3dkhyT2FLcXFBUHZYL09XekoiLCJtYWMiOiI0OWY5ZDU0OGNmNmQyOTZiMjE1ZmYwOWI3NWM1YWNhMWIyZTZlNzc4YjM1ODA1YzU3YTViMmFlODg4YjNlZmI4IiwidGFnIjoiIn0%3D; expires=Mon, 14-Apr-2025 15:37:18 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InlERjBXS1pDbTNqZDNFQ2tuOTd6MVE9PSIsInZhbHVlIjoiTEdqbjB6ejRYMlhtYnhNZmM4TlprOGNybDhjejZLa0x1bWtUS1d5OXg1U0YxQ0lJcDdsL1c4Y2FlSWxjRzF6UDViVC8rV ▶"
    1 => "laravel_session=eyJpdiI6IkRuSXF0c1VnVXhzVkd6OXZTb1BqK2c9PSIsInZhbHVlIjoiZ0dqUEpJMHlVOU43NW56eWI5aWl6bE4vQUppYUgvSlBoS2tZZEx4NkRRMkFHZ1dlNis1bCtZRTRBUVZFWUFCbmd6MVdldExIREtuazNhQzRlTnlsZWZFOHByaW0xS1hENklOUmw0UXZ4R3NzalQ0dDZ4ZHhWZ0Fab0t2aGhEOHgiLCJtYWMiOiI3MjlhNDI2MmQ4YzA3ODljM2U2MTMwZjNmY2QyMjViMDA1OTYxNmVhY2FlYTg1NTYzNjg1NjBjNWFjZjE1OWRhIiwidGFnIjoiIn0%3D; expires=Mon, 14-Apr-2025 15:37:18 GMT; path=/; httponly ◀laravel_session=eyJpdiI6IkRuSXF0c1VnVXhzVkd6OXZTb1BqK2c9PSIsInZhbHVlIjoiZ0dqUEpJMHlVOU43NW56eWI5aWl6bE4vQUppYUgvSlBoS2tZZEx4NkRRMkFHZ1dlNis1bCtZRTRBUVZFWUFCbmd6 ▶"
    2 => "lid=eyJpdiI6IlBPNG1lbFVMeTFuOUFoNndsUlF1N3c9PSIsInZhbHVlIjoiOWQwRlJZNUJQd1MvS1lJS2RlRC9qWm0wbW1lR1NrOTZzbWNWSVJTbjBZQ0dTSzA4UlFqcEozVzkzckk1RnhYQSIsIm1hYyI6IjRiZmYwNTkxZmFlNTE0ZGQ5NjI0ZjkwYzVmODk2ZWZkNDA0ZmFmM2ZhYzkyNzdiM2M2MmJiYjdiNDczYjc2ZDciLCJ0YWciOiIifQ%3D%3D; expires=Tue, 14-Apr-2026 13:37:18 GMT; path=/; httponly ◀lid=eyJpdiI6IlBPNG1lbFVMeTFuOUFoNndsUlF1N3c9PSIsInZhbHVlIjoiOWQwRlJZNUJQd1MvS1lJS2RlRC9qWm0wbW1lR1NrOTZzbWNWSVJTbjBZQ0dTSzA4UlFqcEozVzkzckk1RnhYQSIsIm1hYyI6IjRi ▶"
  ]
]

session_attributes

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

1 x Booting (66.71%)	302ms
1 x Application (33.29%)	150ms