Crystaline Light - nossairmandade.com

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

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

Booting (230ms)time
Application (179ms)time
1 x Booting (56.18%)
230ms
1 x Application (43.82%)
179ms

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 duplicated76.03ms

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

940μsnossadevHymnController.php#38

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

1.96msnossadevHymnController.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 ('')

2.1msnossadevHymnController.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 (4153)

10.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 * from `hymn_hinarios` where `hymn_hinarios`.`hymn_id` in (4153)

2.22msnossadevHymnController.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` = 4153

3.24msnossadevHymn.php#143

Bindings	0: 4153
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

3.56msnossadevHinario.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` = 4152 and `hymns`.`id` is not null limit 1

2.9msnossadevHinario.php#45

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

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

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

2.48msnossadevHinario.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` = 4154 and `hymns`.`id` is not null limit 1

450μsnossadevHinario.php#60

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

10.64msnossadevHinario.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` = 4153

2.47msnossadevHymn.php#161

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

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 (108)

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

570μ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` = 4153 and `media_file_id` = 4910 limit 1

3.62msnossadevHymn.php#241

Bindings	0: 4153 1: 4910
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

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

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

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

480μ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: 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: kOPREP2u7B7VTVASkaR3XmsbPEoV26TZqv9kYMQh
_previous: array:1 [ "url" => "https://dev.nossairmandade.com/hymn/4153/CrystalineLight" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/hymn/4153/CrystalineLight

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 => "Tue, 15 Apr 2025 20:51:03 GMT"
  ]
  "set-cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ilc4MnNGbFkzMThxN2lWbEx2ZTF2Mnc9PSIsInZhbHVlIjoia096QU1YWVFVZHV2eWo0MTdCZTUxbDVUZHo4b0ZqMndYWWUvbXk2eGduTDF6bUdLZEdNSGZOREZncHEyNGZLcXRWS3lyQzhTY3d2cEduM3c4WCtiNVBrVjZBZVc4L2NzbDA2VjVLUjhPMzV1YmppZzQxRGx4M09MMWt5eTlQV2giLCJtYWMiOiI1ODBiMTNiMDIzN2Q4NjYxZGY0ZGExMDNmMjJkZDNjZTFjNDBhMTI3ODkzYWZkYWRlMWM2YWJjN2U1YTJiYWY5IiwidGFnIjoiIn0%3D; expires=Tue, 15 Apr 2025 22:51:03 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6Ilc4MnNGbFkzMThxN2lWbEx2ZTF2Mnc9PSIsInZhbHVlIjoia096QU1YWVFVZHV2eWo0MTdCZTUxbDVUZHo4b0ZqMndYWWUvbXk2eGduTDF6bUdLZEdNSGZOREZncHEyNGZLcXRWS3lyQ ▶"
    1 => "laravel_session=eyJpdiI6IjB6UWdLNW91NWdQdDJydG03aDRuUUE9PSIsInZhbHVlIjoiNURCOEtiZUhYemlQdmhoZnpUdzVPRTY1bW1uSTdodFFjUlZjQStuOXJTUWZ5MDAzQmRuYTM1MEh3TXRHZ29hU2ltd2VtNVZrdjA5S2xCdW5MOW83VklqVzNOalhaVmt4d3JZWlNnWlJqcnJZc1ZVbmZNbUFWSWdjOEpob3NyMkkiLCJtYWMiOiI5MjJiZTBjNTg0ZjgxNzAyYTNjNzJjMmFjOTA0MDZjNzVlMWFhYTk1MzRmN2YxYTM1OWFmN2I3NTYxZWVhMDViIiwidGFnIjoiIn0%3D; expires=Tue, 15 Apr 2025 22:51:03 GMT; Max-Age=7200; path=/; httponly ◀laravel_session=eyJpdiI6IjB6UWdLNW91NWdQdDJydG03aDRuUUE9PSIsInZhbHVlIjoiNURCOEtiZUhYemlQdmhoZnpUdzVPRTY1bW1uSTdodFFjUlZjQStuOXJTUWZ5MDAzQmRuYTM1MEh3TXRHZ29hU2lt ▶"
    2 => "lid=eyJpdiI6ImxVL2ZOM285eXRVTG5wRXMvVG1HVFE9PSIsInZhbHVlIjoiOUhhZWQ4ZXRvZmtmVjhFaVUvK1lmMEFjYnFQVmQ3Y2ZJNDhpemR1OHRnUjQwaU90Zi9OSXYwUGo3YmtUYlRoMyIsIm1hYyI6IjMxNTI4YmZiMTZhODRlZGEzYWIxNTQwN2YwNDE5NTc0N2E3MDM5YjVlZjMxOGJmNzZmNzM1N2Q3NDUyMDI4YmEiLCJ0YWciOiIifQ%3D%3D; expires=Wed, 15 Apr 2026 20:51:03 GMT; Max-Age=31536000; path=/; httponly ◀lid=eyJpdiI6ImxVL2ZOM285eXRVTG5wRXMvVG1HVFE9PSIsInZhbHVlIjoiOUhhZWQ4ZXRvZmtmVjhFaVUvK1lmMEFjYnFQVmQ3Y2ZJNDhpemR1OHRnUjQwaU90Zi9OSXYwUGo3YmtUYlRoMyIsIm1hYyI6IjMx ▶"
  ]
  "Set-Cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ilc4MnNGbFkzMThxN2lWbEx2ZTF2Mnc9PSIsInZhbHVlIjoia096QU1YWVFVZHV2eWo0MTdCZTUxbDVUZHo4b0ZqMndYWWUvbXk2eGduTDF6bUdLZEdNSGZOREZncHEyNGZLcXRWS3lyQzhTY3d2cEduM3c4WCtiNVBrVjZBZVc4L2NzbDA2VjVLUjhPMzV1YmppZzQxRGx4M09MMWt5eTlQV2giLCJtYWMiOiI1ODBiMTNiMDIzN2Q4NjYxZGY0ZGExMDNmMjJkZDNjZTFjNDBhMTI3ODkzYWZkYWRlMWM2YWJjN2U1YTJiYWY5IiwidGFnIjoiIn0%3D; expires=Tue, 15-Apr-2025 22:51:03 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Ilc4MnNGbFkzMThxN2lWbEx2ZTF2Mnc9PSIsInZhbHVlIjoia096QU1YWVFVZHV2eWo0MTdCZTUxbDVUZHo4b0ZqMndYWWUvbXk2eGduTDF6bUdLZEdNSGZOREZncHEyNGZLcXRWS3lyQ ▶"
    1 => "laravel_session=eyJpdiI6IjB6UWdLNW91NWdQdDJydG03aDRuUUE9PSIsInZhbHVlIjoiNURCOEtiZUhYemlQdmhoZnpUdzVPRTY1bW1uSTdodFFjUlZjQStuOXJTUWZ5MDAzQmRuYTM1MEh3TXRHZ29hU2ltd2VtNVZrdjA5S2xCdW5MOW83VklqVzNOalhaVmt4d3JZWlNnWlJqcnJZc1ZVbmZNbUFWSWdjOEpob3NyMkkiLCJtYWMiOiI5MjJiZTBjNTg0ZjgxNzAyYTNjNzJjMmFjOTA0MDZjNzVlMWFhYTk1MzRmN2YxYTM1OWFmN2I3NTYxZWVhMDViIiwidGFnIjoiIn0%3D; expires=Tue, 15-Apr-2025 22:51:03 GMT; path=/; httponly ◀laravel_session=eyJpdiI6IjB6UWdLNW91NWdQdDJydG03aDRuUUE9PSIsInZhbHVlIjoiNURCOEtiZUhYemlQdmhoZnpUdzVPRTY1bW1uSTdodFFjUlZjQStuOXJTUWZ5MDAzQmRuYTM1MEh3TXRHZ29hU2lt ▶"
    2 => "lid=eyJpdiI6ImxVL2ZOM285eXRVTG5wRXMvVG1HVFE9PSIsInZhbHVlIjoiOUhhZWQ4ZXRvZmtmVjhFaVUvK1lmMEFjYnFQVmQ3Y2ZJNDhpemR1OHRnUjQwaU90Zi9OSXYwUGo3YmtUYlRoMyIsIm1hYyI6IjMxNTI4YmZiMTZhODRlZGEzYWIxNTQwN2YwNDE5NTc0N2E3MDM5YjVlZjMxOGJmNzZmNzM1N2Q3NDUyMDI4YmEiLCJ0YWciOiIifQ%3D%3D; expires=Wed, 15-Apr-2026 20:51:03 GMT; path=/; httponly ◀lid=eyJpdiI6ImxVL2ZOM285eXRVTG5wRXMvVG1HVFE9PSIsInZhbHVlIjoiOUhhZWQ4ZXRvZmtmVjhFaVUvK1lmMEFjYnFQVmQ3Y2ZJNDhpemR1OHRnUjQwaU90Zi9OSXYwUGo3YmtUYlRoMyIsIm1hYyI6IjMx ▶"
  ]
]

session_attributes

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

1 x Booting (56.18%)	230ms
1 x Application (43.82%)	179ms