RunningConnect Media - The Perfect Shot Gen.2

Messages Timeline Exceptions Views4 Route Queries36 Models452 Mails Gate Session Request

7.4.33712ms40MBGET event/{slug}

Booting (190ms)
Application (522ms)
1 x Application (73.31%)
522ms
1 x Booting (26.69%)
190ms

4 templates were rendered

media.event.show (resources/views/media/event/show.blade.php)22blade


videos
images
event
search_method
search
threshold
isEmbed
current_page
prices
approvedPhotographers
searchPhotographersIds
dateLimit
dateInput
isAllPhotographer
media_search
cert_flag
enable_flatrate
tags
is_search
cart_ids
has_personal_video
has_flatrate

vendor.pagination.bootstrap-4 (resources/views/vendor/pagination/bootstrap-4.blade.php)2blade
Params
0
paginator
1
elements
vendor.pagination.bootstrap-4 (resources/views/vendor/pagination/bootstrap-4.blade.php)2blade
Params
0
paginator
1
elements

Params
0	`videos`
1	`images`
2	`event`
3	`search_method`
4	`search`
5	`threshold`
6	`isEmbed`
7	`current_page`
8	`prices`
9	`approvedPhotographers`
10	`searchPhotographersIds`
11	`dateLimit`
12	`dateInput`
13	`isAllPhotographer`
14	`media_search`
15	`cert_flag`
16	`enable_flatrate`
17	`tags`
18	`is_search`
19	`cart_ids`
20	`has_personal_video`
21	`has_flatrate`

Params
0	`paginator`
1	`elements`

Params
0	`paginator`
1	`elements`

layouts.media.default (resources/views/layouts/media/default.blade.php)38blade


obLevel
__env
app
errors
sentinelCheck
sentinelUser
projectVariables
cookieCategories
videos
images
event
search_method
search
threshold
isEmbed
current_page
prices
approvedPhotographers
searchPhotographersIds
dateLimit
dateInput
isAllPhotographer
media_search
cert_flag
enable_flatrate
tags
is_search
cart_ids
has_personal_video
has_flatrate
__currentLoopData
loop
eventPhotographer
medias
appendList
unwantedList
unwanted
media

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`sentinelCheck`
5	`sentinelUser`
6	`projectVariables`
7	`cookieCategories`
8	`videos`
9	`images`
10	`event`
11	`search_method`
12	`search`
13	`threshold`
14	`isEmbed`
15	`current_page`
16	`prices`
17	`approvedPhotographers`
18	`searchPhotographersIds`
19	`dateLimit`
20	`dateInput`
21	`isAllPhotographer`
22	`media_search`
23	`cert_flag`
24	`enable_flatrate`
25	`tags`
26	`is_search`
27	`cart_ids`
28	`has_personal_video`
29	`has_flatrate`
30	`__currentLoopData`
31	`loop`
32	`eventPhotographer`
33	`medias`
34	`appendList`
35	`unwantedList`
36	`unwanted`
37	`media`

uri: GET event/{slug}
middleware: web
domain: beta-media.runningconnect.com
controller: App\Http\Controllers\Media\EventController@show
as: media.event.show
namespace: App\Http\Controllers
prefix: /event
where
file: app/Http/Controllers/Media/EventController.php:69-560

36 statements were executed, 9 of which were duplicated, 27 unique416ms

select * from `sessions` where `id` = 'QyJOssQQqcVFRQWBcfC4UrPVHe6YYMLcZLOXsY9I' limit 14.93ms/vendor/laravel/framework/src/Illuminate/Session/DatabaseSessionHandler.php:91runningconnect

Metadata
Bindings	0. QyJOssQQqcVFRQWBcfC4UrPVHe6YYMLcZLOXsY9I
Backtrace	14. /vendor/laravel/framework/src/Illuminate/Session/DatabaseSessionHandler.php:91 15. /vendor/laravel/framework/src/Illuminate/Session/Store.php:97 16. /vendor/laravel/framework/src/Illuminate/Session/Store.php:87 17. /vendor/laravel/framework/src/Illuminate/Session/Store.php:71 18. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:81

select * from `project_variable` where `is_shared_view` = 14.02ms/app/Http/Middleware/ShareProjectVariables.php:20runningconnect

Metadata
Bindings	0. 1
Backtrace	12. /app/Http/Middleware/ShareProjectVariables.php:20 13. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 14. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 15. /app/Http/Middleware/ShareAuthFromSentinel.php:29 16. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163

select * from `cookie_consent_category`730μs/app/Http/Middleware/ShareProjectVariables.php:21runningconnect

Metadata
Backtrace	12. /app/Http/Middleware/ShareProjectVariables.php:21 13. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 14. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 15. /app/Http/Middleware/ShareAuthFromSentinel.php:29 16. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163

SET session wait_timeout=30;490μs/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239runningconnect

Metadata
Backtrace	9. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 10. /app/Http/Controllers/Media/EventController.php:71 13. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 14. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 15. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

select * from `events` where `slug` = 'DITUTMB2022_PERFECTSHOT' and `events`.`deleted_at` is null limit 14.19ms/app/Http/Controllers/Media/EventController.php:76runningconnect

Metadata
Bindings	0. DITUTMB2022_PERFECTSHOT
Backtrace	15. /app/Http/Controllers/Media/EventController.php:76 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

select * from `tags` where `event_id` = 160 and `type` = 'media' and `tags`.`deleted_at` is null890μs/app/Http/Controllers/Media/EventController.php:88runningconnect

Metadata
Bindings	0. 160 1. media
Backtrace	14. /app/Http/Controllers/Media/EventController.php:88 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

select * from `event_category` where `event_id` = 160 and `has_personal_video` = 1 and `event_category`.`deleted_at` is null limit 1

800μs/app/Http/Controllers/Media/EventController.php:236runningconnect

Metadata
Bindings	0. 160 1. 1
Backtrace	15. /app/Http/Controllers/Media/EventController.php:236 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

select *, `event_photographers`.`id` as `id` from `event_photographers` inner join `photographers` on `photographers`.`user_id` = `event_photographers`.`user_id` where `event_id` = 160 and `status` = 'approved' and `event_photographers`.`deleted_at` is null order by `display_name` asc

3.81ms/app/Http/Controllers/Media/EventController.php:256runningconnect

Metadata
Bindings	0. 160 1. approved
Backtrace	14. /app/Http/Controllers/Media/EventController.php:256 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

select *, `event_photographers`.`id` as `id` from `event_photographers` inner join `photographers` on `photographers`.`user_id` = `event_photographers`.`user_id` where `event_id` = 160 and `status` = 'approved' and `event_photographers`.`deleted_at` is null order by `display_name` asc

1.93ms/app/Http/Controllers/Media/EventController.php:258runningconnect

Metadata
Bindings	0. 160 1. approved
Backtrace	14. /app/Http/Controllers/Media/EventController.php:258 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

select * from `cache` where `key` = 'laravelDITUTMB2022_PERFECTSHOT:min_shot_at' limit 1640μs/vendor/laravel/framework/src/Illuminate/Cache/DatabaseStore.php:63runningconnect

Metadata
Bindings	0. laravelDITUTMB2022_PERFECTSHOT:min_shot_at
Backtrace	13. /vendor/laravel/framework/src/Illuminate/Cache/DatabaseStore.php:63 14. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:97 15. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:70 16. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 17. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239

delete from `cache` where `key` = 'laravelDITUTMB2022_PERFECTSHOT:min_shot_at'4ms/vendor/laravel/framework/src/Illuminate/Cache/DatabaseStore.php:216runningconnect

Metadata
Bindings	0. laravelDITUTMB2022_PERFECTSHOT:min_shot_at
Backtrace	10. /vendor/laravel/framework/src/Illuminate/Cache/DatabaseStore.php:216 11. /vendor/laravel/framework/src/Illuminate/Cache/DatabaseStore.php:78 12. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:97 13. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:70 14. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357

select MIN(shot_at) as min_date, MAX(shot_at) as max_date from `media` where `status` = 'completed' and `event_id` = 160 and `media`.`deleted_at` is null limit 1

193ms/app/Http/Controllers/Media/EventController.php:281runningconnect

Metadata
Bindings	0. completed 1. 160
Backtrace	15. /app/Http/Controllers/Media/EventController.php:281 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

insert into `cache` (`key`, `value`, `expiration`) values ('laravelDITUTMB2022_PERFECTSHOT:min_shot_at', 's:19:\"2022-06-20 16:57:39\";', 1744377954)

10.76ms/vendor/laravel/framework/src/Illuminate/Cache/DatabaseStore.php:103runningconnect

Metadata
Bindings	0. laravelDITUTMB2022_PERFECTSHOT:min_shot_at 1. s:19:"2022-06-20 16:57:39"; 2. 1744377954
Backtrace	10. /vendor/laravel/framework/src/Illuminate/Cache/DatabaseStore.php:103 11. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:211 12. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 13. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 14. /app/Http/Controllers/Media/EventController.php:282

update `cache` set `value` = 's:19:\"2022-07-25 22:44:53\";', `expiration` = 1744377954 where `key` = 'laravelDITUTMB2022_PERFECTSHOT:max_shot_at'

6.09ms/vendor/laravel/framework/src/Illuminate/Cache/DatabaseStore.php:105runningconnect

Metadata
Bindings	0. s:19:"2022-07-25 22:44:53"; 1. 1744377954 2. laravelDITUTMB2022_PERFECTSHOT:max_shot_at
Backtrace	10. /vendor/laravel/framework/src/Illuminate/Cache/DatabaseStore.php:105 11. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:211 12. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 13. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 14. /app/Http/Controllers/Media/EventController.php:283

select * from `media_price` where exists (select * from `media_setting` where `media_price`.`media_setting_id` = `media_setting`.`id` and `event_id` = 160 and `media_setting`.`deleted_at` is null) and `user_id` in (163256, 122322, 123427, 269042, 7956, 227988, 5888, 168073, 226504, 102067, 135269, 135918, 3570, 7085, 130044, 3753, 132513, 137793, 97815, 123727, 221268, 237157, 12875, 56178, 130183, 229770, 37075, 89698, 5654, 1, 136421, 136495, 78020, 270676, 228423, 20864, 259800, 1867, 136520, 121874, 202381, 135916, 137842, 128512, 4668, 79497, 164305, 209135) and `media_price`.`deleted_at` is null

13.37ms/app/Http/Controllers/Media/EventController.php:356runningconnect

Metadata
Bindings	0. 160 1. 163256 2. 122322 3. 123427 4. 269042 5. 7956 6. 227988 7. 5888 8. 168073 9. 226504 10. 102067 11. 135269 12. 135918 13. 3570 14. 7085 15. 130044 16. 3753 17. 132513 18. 137793 19. 97815 20. 123727 21. 221268 22. 237157 23. 12875 24. 56178 25. 130183 26. 229770 27. 37075 28. 89698 29. 5654 30. 1 31. 136421 32. 136495 33. 78020 34. 270676 35. 228423 36. 20864 37. 259800 38. 1867 39. 136520 40. 121874 41. 202381 42. 135916 43. 137842 44. 128512 45. 4668 46. 79497 47. 164305 48. 209135
Backtrace	14. /app/Http/Controllers/Media/EventController.php:356 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

Metadata

Bindings

0. 160
1. 163256
2. 122322
3. 123427
4. 269042
5. 7956
6. 227988
7. 5888
8. 168073
9. 226504
10. 102067
11. 135269
12. 135918
13. 3570
14. 7085
15. 130044
16. 3753
17. 132513
18. 137793
19. 97815
20. 123727
21. 221268
22. 237157
23. 12875
24. 56178
25. 130183
26. 229770
27. 37075
28. 89698
29. 5654
30. 1
31. 136421
32. 136495
33. 78020
34. 270676
35. 228423
36. 20864
37. 259800
38. 1867
39. 136520
40. 121874
41. 202381
42. 135916
43. 137842
44. 128512
45. 4668
46. 79497
47. 164305
48. 209135

Backtrace

14. /app/Http/Controllers/Media/EventController.php:356
17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

select * from `cache` where `key` = 'laravelDITUTMB2022_PERFECTSHOT:count_completed' limit 1760μs/vendor/laravel/framework/src/Illuminate/Cache/DatabaseStore.php:63runningconnect

Metadata
Bindings	0. laravelDITUTMB2022_PERFECTSHOT:count_completed
Backtrace	13. /vendor/laravel/framework/src/Illuminate/Cache/DatabaseStore.php:63 14. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:97 15. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:374 16. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 17. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239

delete from `cache` where `key` = 'laravelDITUTMB2022_PERFECTSHOT:count_completed'13.38ms/vendor/laravel/framework/src/Illuminate/Cache/DatabaseStore.php:216runningconnect

Metadata
Bindings	0. laravelDITUTMB2022_PERFECTSHOT:count_completed
Backtrace	10. /vendor/laravel/framework/src/Illuminate/Cache/DatabaseStore.php:216 11. /vendor/laravel/framework/src/Illuminate/Cache/DatabaseStore.php:78 12. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:97 13. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:374 14. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357

select COUNT(*) AS c from `media` where `type` = 'video' and `media`.`status` = 'completed' and `is_approved` = 1 and `media`.`event_id` = 160 and `media`.`deleted_at` is null limit 1

1.46ms/app/Http/Controllers/Media/EventController.php:397runningconnect

Metadata
Bindings	0. video 1. completed 2. 1 3. 160
Backtrace	15. /app/Http/Controllers/Media/EventController.php:397 16. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:383 17. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 18. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 19. /app/Http/Controllers/Media/EventController.php:403

select * from `media_runner` where `media_runner`.`media_id` in (0) and `media_runner`.`deleted_at` is null1.39ms/app/Http/Controllers/Media/EventController.php:397runningconnect

Metadata
Backtrace	20. /app/Http/Controllers/Media/EventController.php:397 21. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:383 22. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 23. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 24. /app/Http/Controllers/Media/EventController.php:403

select * from `users` where 0 = 1 and `users`.`deleted_at` is null1.29ms/app/Http/Controllers/Media/EventController.php:397runningconnect

Metadata
Backtrace	20. /app/Http/Controllers/Media/EventController.php:397 21. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:383 22. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 23. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 24. /app/Http/Controllers/Media/EventController.php:403

select * from `events` where 0 = 1 and `events`.`deleted_at` is null890μs/app/Http/Controllers/Media/EventController.php:397runningconnect

Metadata
Backtrace	20. /app/Http/Controllers/Media/EventController.php:397 21. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:383 22. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 23. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 24. /app/Http/Controllers/Media/EventController.php:403

select COUNT(*) AS c from `media` where `type` = 'image' and `media`.`status` = 'completed' and `is_approved` = 1 and `media`.`event_id` = 160 and `media`.`deleted_at` is null limit 1

91.09ms/app/Http/Controllers/Media/EventController.php:400runningconnect

Metadata
Bindings	0. image 1. completed 2. 1 3. 160
Backtrace	15. /app/Http/Controllers/Media/EventController.php:400 16. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:383 17. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 18. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 19. /app/Http/Controllers/Media/EventController.php:403

select * from `media_runner` where `media_runner`.`media_id` in (0) and `media_runner`.`deleted_at` is null860μs/app/Http/Controllers/Media/EventController.php:400runningconnect

Metadata
Backtrace	20. /app/Http/Controllers/Media/EventController.php:400 21. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:383 22. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 23. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 24. /app/Http/Controllers/Media/EventController.php:403

select * from `users` where 0 = 1 and `users`.`deleted_at` is null630μs/app/Http/Controllers/Media/EventController.php:400runningconnect

Metadata
Backtrace	20. /app/Http/Controllers/Media/EventController.php:400 21. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:383 22. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 23. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 24. /app/Http/Controllers/Media/EventController.php:403

select `id` from `events` where 0 = 1 and `events`.`deleted_at` is null770μs/app/Http/Controllers/Media/EventController.php:400runningconnect

Metadata
Backtrace	20. /app/Http/Controllers/Media/EventController.php:400 21. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:383 22. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 23. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 24. /app/Http/Controllers/Media/EventController.php:403

insert into `cache` (`key`, `value`, `expiration`) values ('laravelDITUTMB2022_PERFECTSHOT:count_completed', 'a:2:{s:6:\"images\";i:19728;s:6:\"videos\";i:0;}', 1744377955)

7.29ms/vendor/laravel/framework/src/Illuminate/Cache/DatabaseStore.php:103runningconnect

Metadata
Bindings	0. laravelDITUTMB2022_PERFECTSHOT:count_completed 1. a:2:{s:6:"images";i:19728;s:6:"videos";i:0;} 2. 1744377955
Backtrace	10. /vendor/laravel/framework/src/Illuminate/Cache/DatabaseStore.php:103 11. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:211 12. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:383 13. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 14. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239

select `media`.`type`, `media`.`original_deleted_at`, `media`.`user_id`, `media`.`width`, `media`.`height`, `media`.`preview_url`, `media`.`shot_at`, `media`.`media_price_id`, `media`.`event_id`, `media`.`medium_url`, `media`.`id` as `id` from `media` inner join (select `id` from `media` where `type` = 'video' and `media`.`status` = 'completed' and `is_approved` = 1 and `media`.`event_id` = 160 and `media`.`deleted_at` is null limit 10 offset 20) as m on `media`.`id` = `m`.`id` where `type` = 'video' and `media`.`status` = 'completed' and `is_approved` = 1 and `media`.`event_id` = 160 and `media`.`deleted_at` is null

1.78ms/app/Http/Controllers/Media/EventController.php:457runningconnect

Metadata
Bindings	0. video 1. completed 2. 1 3. 160 4. video 5. completed 6. 1 7. 160
Backtrace	14. /app/Http/Controllers/Media/EventController.php:457 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

select `media`.`type`, `media`.`original_deleted_at`, `media`.`user_id`, `media`.`width`, `media`.`height`, `media`.`preview_url`, `media`.`shot_at`, `media`.`media_price_id`, `media`.`event_id`, `media`.`medium_url`, `media`.`id` as `id` from `media` inner join (select `id` from `media` where `type` = 'image' and `media`.`status` = 'completed' and `is_approved` = 1 and `media`.`event_id` = 160 and `media`.`deleted_at` is null limit 100 offset 200) as m on `media`.`id` = `m`.`id` where `type` = 'image' and `media`.`status` = 'completed' and `is_approved` = 1 and `media`.`event_id` = 160 and `media`.`deleted_at` is null

17.91ms/app/Http/Controllers/Media/EventController.php:458runningconnect

Metadata
Bindings	0. image 1. completed 2. 1 3. 160 4. image 5. completed 6. 1 7. 160
Backtrace	14. /app/Http/Controllers/Media/EventController.php:458 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

select * from `media_runner` where `media_runner`.`media_id` in (18460221, 18460223, 18460224, 18461302, 18461303, 18461304, 18461305, 18461335, 18461336, 18461337, 18461338, 18461339, 18462555, 18462556, 18462557, 18462558, 18462559, 18462560, 18462561, 18462562, 18462563, 18462564, 18462565, 18462569, 18462570, 18463268, 18463269, 18463270, 18463271, 18463272, 18463273, 18463274, 18463275, 18463276, 18463277, 18463278, 18463279, 18463280, 18463281, 18463282, 18463283, 18463284, 18463285, 18463286, 18463287, 18463288, 18463289, 18463290, 18463291, 18463292, 18463293, 18463294, 18463295, 18463296, 18463297, 18463298, 18463299, 18463300, 18463301, 18463302, 18463303, 18463304, 18463401, 18463402, 18463403, 18463404, 18463405, 18463406, 18463407, 18463408, 18463409, 18463410, 18463411, 18463412, 18463413, 18463414, 18463415, 18463416, 18463417, 18463418, 18463419, 18463420, 18463421, 18463422, 18463423, 18463424, 18463425, 18463426, 18463427, 18463428, 18463429, 18463430, 18463431, 18463432, 18463433, 18463434, 18463435, 18463438, 18463439, 18463440) and `media_runner`.`deleted_at` is null

6.61ms/app/Http/Controllers/Media/EventController.php:458runningconnect

Metadata
Backtrace	19. /app/Http/Controllers/Media/EventController.php:458 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 25. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

select * from `users` where `users`.`id` in (1867, 5888, 78020, 137842, 237157, 270676) and `users`.`deleted_at` is null810μs/app/Http/Controllers/Media/EventController.php:458runningconnect

Metadata
Backtrace	19. /app/Http/Controllers/Media/EventController.php:458 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 25. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

select `id` from `events` where `events`.`id` in (160) and `events`.`deleted_at` is null890μs/app/Http/Controllers/Media/EventController.php:458runningconnect

Metadata
Backtrace	19. /app/Http/Controllers/Media/EventController.php:458 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 25. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

select `id`, `is_watermark`, `event_id`, `height`, `is_frame` from `media_setting` where `media_setting`.`event_id` in (160) and `is_buyable` = 1 and `media_setting`.`deleted_at` is null order by `media_setting`.`height` desc

7.18ms/app/Http/Controllers/Media/EventController.php:458runningconnect

Metadata
Bindings	0. 1
Backtrace	24. /app/Http/Controllers/Media/EventController.php:458 27. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 28. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 30. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

select * from `custom_field` where `custom_field`.`event_id` = 160 and `custom_field`.`event_id` is not null and `custom_field`.`deleted_at` is null

6.17ms/app/Models/Event.php:561runningconnect

Metadata
Bindings	0. 160
Backtrace	19. /app/Models/Event.php:561 26. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946 29. /vendor/laravel/framework/src/Illuminate/Pagination/LengthAwarePaginator.php:167 30. /vendor/laravel/framework/src/Illuminate/Pagination/LengthAwarePaginator.php:188 31. /vendor/laravel/framework/src/Illuminate/Pagination/LengthAwarePaginator.php:199

select * from `sessions` where `id` = 'QyJOssQQqcVFRQWBcfC4UrPVHe6YYMLcZLOXsY9I' limit 1830μs/vendor/laravel/framework/src/Illuminate/Session/DatabaseSessionHandler.php:91runningconnect

Metadata

Bindings

0. QyJOssQQqcVFRQWBcfC4UrPVHe6YYMLcZLOXsY9I

Backtrace

14. /vendor/laravel/framework/src/Illuminate/Session/DatabaseSessionHandler.php:91
15. /vendor/laravel/framework/src/Illuminate/Session/DatabaseSessionHandler.php:128
16. /vendor/laravel/framework/src/Illuminate/Session/Store.php:129
17. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:170
18. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:65

insert into `sessions` (`payload`, `last_activity`, `user_id`, `ip_address`, `user_agent`, `id`) values ('YTozOntzOjY6Il90b2tlbiI7czo0MDoid2x0Sm5PWG1tcFJPcEpCV0dna1NMd2xxNXVQUUlXeUl0VDU2c2hMVyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTExOiJodHRwczovL2JldGEtbWVkaWEucnVubmluZ2Nvbm5lY3QuY29tL2V2ZW50L0RJVFVUTUIyMDIyX1BFUkZFQ1RTSE9UP3BhZ2U9MyZxPSUyRmV2ZW50JTJGRElUVVRNQjIwMjJfUEVSRkVDVFNIT1QiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1744377355, '', '172.31.26.3', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'QyJOssQQqcVFRQWBcfC4UrPVHe6YYMLcZLOXsY9I')

3.44ms/vendor/laravel/framework/src/Illuminate/Session/DatabaseSessionHandler.php:150runningconnect

Metadata
Bindings	0. YTozOntzOjY6Il90b2tlbiI7czo0MDoid2x0Sm5PWG1tcFJPcEpCV0dna1NMd2xxNXVQUUlXeUl0VDU2c2hMVyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTExOiJodHRwczovL2JldGEtbWVkaWEucnVubmluZ2Nvbm5lY3QuY29tL2V2ZW50L0RJVFVUTUIyMDIyX1BFUkZFQ1RTSE9UP3BhZ2U9MyZxPSUyRmV2ZW50JTJGRElUVVRNQjIwMjJfUEVSRkVDVFNIT1QiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19 1. 1744377355 2. 3. 172.31.26.3 4. Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) 5. QyJOssQQqcVFRQWBcfC4UrPVHe6YYMLcZLOXsY9I
Backtrace	10. /vendor/laravel/framework/src/Illuminate/Session/DatabaseSessionHandler.php:150 11. /vendor/laravel/framework/src/Illuminate/Session/DatabaseSessionHandler.php:134 12. /vendor/laravel/framework/src/Illuminate/Session/Store.php:129 13. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:170 14. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:65

Metadata

Bindings

0. YTozOntzOjY6Il90b2tlbiI7czo0MDoid2x0Sm5PWG1tcFJPcEpCV0dna1NMd2xxNXVQUUlXeUl0VDU2c2hMVyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTExOiJodHRwczovL2JldGEtbWVkaWEucnVubmluZ2Nvbm5lY3QuY29tL2V2ZW50L0RJVFVUTUIyMDIyX1BFUkZFQ1RTSE9UP3BhZ2U9MyZxPSUyRmV2ZW50JTJGRElUVVRNQjIwMjJfUEVSRkVDVFNIT1QiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19
1. 1744377355
2.
3. 172.31.26.3
4. Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
5. QyJOssQQqcVFRQWBcfC4UrPVHe6YYMLcZLOXsY9I

Backtrace

10. /vendor/laravel/framework/src/Illuminate/Session/DatabaseSessionHandler.php:150
11. /vendor/laravel/framework/src/Illuminate/Session/DatabaseSessionHandler.php:134
12. /vendor/laravel/framework/src/Illuminate/Session/Store.php:129
13. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:170
14. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:65

select * from `sessions` where `id` = 'QyJOssQQqcVFRQWBcfC4UrPVHe6YYMLcZLOXsY9I' limit 1740μs/vendor/laravel/framework/src/Illuminate/Session/DatabaseSessionHandler.php:91runningconnect

Metadata
Bindings	0. QyJOssQQqcVFRQWBcfC4UrPVHe6YYMLcZLOXsY9I
Backtrace	14. /vendor/laravel/framework/src/Illuminate/Session/DatabaseSessionHandler.php:91 15. /vendor/laravel/framework/src/Illuminate/Session/Store.php:97 16. /vendor/laravel/framework/src/Illuminate/Session/Store.php:87 17. /vendor/laravel/framework/src/Illuminate/Session/Store.php:71 18. /vendor/laravel/framework/src/Illuminate/Support/Manager.php:146

App\Models\MediaSetting: 5
App\Models\User: 6
App\Models\MediaPrice: 240
App\Models\Media: 103
App\Models\EventPhotographer: 96
App\Models\Event: 2

_token: wltJnOXmmpROpJBWGgkSLwlq5uPQIWyItT56shLW
_previous: array:1 [ "url" => "https://beta-media.runningconnect.com/event/DITUTMB2022_PERFECTSHOT?page=3&q=%...
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/event/DITUTMB2022_PERFECTSHOT

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:2 [▶
  "q" => "/event/DITUTMB2022_PERFECTSHOT"
  "page" => "3"
]

request_request

  0 of 0   
array:2 [▶
  "q" => "/event/DITUTMB2022_PERFECTSHOT"
  "page" => "3"
]

request_headers

  0 of 0   
array:21 [▶
  "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"
  ]
  "x-amzn-trace-id" => array:1 [▶
    0 => "Root=1-67f9160a-18bc41f427ae4d80294f674d"
  ]
  "host" => array:1 [▶
    0 => "beta-media.runningconnect.com"
  ]
  "x-forwarded-port" => array:1 [▶
    0 => "443"
  ]
  "x-forwarded-proto" => array:1 [▶
    0 => "https"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "18.224.15.154"
  ]
  "content-length" => array:1 [▶
    0 => ""
  ]
  "content-type" => array:1 [▶
    0 => ""
  ]
]

request_server

  0 of 0   
array:45 [▶
  "USER" => "nginx"
  "HOME" => "/var/lib/nginx"
  "HTTP_PRIORITY" => "u=0, i"
  "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd"
  "HTTP_SEC_FETCH_DEST" => "document"
  "HTTP_SEC_FETCH_USER" => "?1"
  "HTTP_SEC_FETCH_MODE" => "navigate"
  "HTTP_SEC_FETCH_SITE" => "none"
  "HTTP_ACCEPT" => "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"
  "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "HTTP_UPGRADE_INSECURE_REQUESTS" => "1"
  "HTTP_SEC_CH_UA_PLATFORM" => ""Windows""
  "HTTP_SEC_CH_UA_MOBILE" => "?0"
  "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_X_AMZN_TRACE_ID" => "Root=1-67f9160a-18bc41f427ae4d80294f674d"
  "HTTP_HOST" => "beta-media.runningconnect.com"
  "HTTP_X_FORWARDED_PORT" => "443"
  "HTTP_X_FORWARDED_PROTO" => "https"
  "HTTP_X_FORWARDED_FOR" => "18.224.15.154"
  "REDIRECT_STATUS" => "200"
  "SERVER_NAME" => "beta-www.runningconnect.com"
  "SERVER_PORT" => "443"
  "SERVER_ADDR" => "172.31.23.24"
  "REMOTE_PORT" => "23928"
  "REMOTE_ADDR" => "172.31.26.3"
  "SERVER_SOFTWARE" => "nginx/1.21.3"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "HTTPS" => "on"
  "REQUEST_SCHEME" => "https"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "DOCUMENT_ROOT" => "/usr/share/nginx/html/RunningConnectBeta/public"
  "DOCUMENT_URI" => "/index.php"
  "REQUEST_URI" => "/event/DITUTMB2022_PERFECTSHOT?page=3"
  "SCRIPT_NAME" => "/index.php"
  "CONTENT_LENGTH" => ""
  "CONTENT_TYPE" => ""
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => "q=/event/DITUTMB2022_PERFECTSHOT&page=3"
  "SCRIPT_FILENAME" => "/usr/share/nginx/html/RunningConnectBeta/public/index.php"
  "FCGI_ROLE" => "RESPONDER"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1744377354.4576
  "REQUEST_TIME" => 1744377354
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▶
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Fri, 11 Apr 2025 13:15:55 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "locale=eyJpdiI6IjlWV2VFT2ZxMmlmRjZhbmhuQU9rYkE9PSIsInZhbHVlIjoiRG9zQUpyV1pSOTFhR3gwOU1GVXNsZz09IiwibWFjIjoiOGFjOWE3MzBjZjkyNzYwZjNmZTE3OGI3MTcwY2Q4NTBmYTkzNjQzM2RmNzY5ZmM4YmUyNThkNWU1NmRhZTVhOSJ9; expires=Wed, 10-Apr-2030 13:15:55 GMT; Max-Age=157680000; path=/; domain=runningconnect.com; httponly ◀locale=eyJpdiI6IjlWV2VFT2ZxMmlmRjZhbmhuQU9rYkE9PSIsInZhbHVlIjoiRG9zQUpyV1pSOTFhR3gwOU1GVXNsZz09IiwibWFjIjoiOGFjOWE3MzBjZjkyNzYwZjNmZTE3OGI3MTcwY2Q4NTBmYTkzNjQzM ▶"
    1 => "laravel_session=eyJpdiI6IkhiNTJlMFVrQmR0ZTVCWWRZU2VKemc9PSIsInZhbHVlIjoiV3RKUWRDOHBSa25Idm11Q0NlMWJzbHI3T2daUllqd3pWNXkzZzNHT09xaEphN3ZDTDZReXRcL1Y4Z2R6TTl3MGxtcUlrV055SGFXZlZNRWw0eDJwa1N3PT0iLCJtYWMiOiI3MTkwYzQ0NjllMmNhMTkxZWI0ZjM2MDY5M2EyOGI1YWUxYTc5NWJjYmEwZjMxZGY1MDYzOGFmMTc5ZDg3NzcxIn0%3D; expires=Fri, 11-Apr-2025 15:15:55 GMT; Max-Age=7200; path=/; domain=runningconnect.com; httponly ◀laravel_session=eyJpdiI6IkhiNTJlMFVrQmR0ZTVCWWRZU2VKemc9PSIsInZhbHVlIjoiV3RKUWRDOHBSa25Idm11Q0NlMWJzbHI3T2daUllqd3pWNXkzZzNHT09xaEphN3ZDTDZReXRcL1Y4Z2R6TTl3MGxt ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "locale=eyJpdiI6IjlWV2VFT2ZxMmlmRjZhbmhuQU9rYkE9PSIsInZhbHVlIjoiRG9zQUpyV1pSOTFhR3gwOU1GVXNsZz09IiwibWFjIjoiOGFjOWE3MzBjZjkyNzYwZjNmZTE3OGI3MTcwY2Q4NTBmYTkzNjQzM2RmNzY5ZmM4YmUyNThkNWU1NmRhZTVhOSJ9; expires=Wed, 10-Apr-2030 13:15:55 GMT; domain=runningconnect.com; path=/; httponly ◀locale=eyJpdiI6IjlWV2VFT2ZxMmlmRjZhbmhuQU9rYkE9PSIsInZhbHVlIjoiRG9zQUpyV1pSOTFhR3gwOU1GVXNsZz09IiwibWFjIjoiOGFjOWE3MzBjZjkyNzYwZjNmZTE3OGI3MTcwY2Q4NTBmYTkzNjQzM ▶"
    1 => "laravel_session=eyJpdiI6IkhiNTJlMFVrQmR0ZTVCWWRZU2VKemc9PSIsInZhbHVlIjoiV3RKUWRDOHBSa25Idm11Q0NlMWJzbHI3T2daUllqd3pWNXkzZzNHT09xaEphN3ZDTDZReXRcL1Y4Z2R6TTl3MGxtcUlrV055SGFXZlZNRWw0eDJwa1N3PT0iLCJtYWMiOiI3MTkwYzQ0NjllMmNhMTkxZWI0ZjM2MDY5M2EyOGI1YWUxYTc5NWJjYmEwZjMxZGY1MDYzOGFmMTc5ZDg3NzcxIn0%3D; expires=Fri, 11-Apr-2025 15:15:55 GMT; domain=runningconnect.com; path=/; httponly ◀laravel_session=eyJpdiI6IkhiNTJlMFVrQmR0ZTVCWWRZU2VKemc9PSIsInZhbHVlIjoiV3RKUWRDOHBSa25Idm11Q0NlMWJzbHI3T2daUllqd3pWNXkzZzNHT09xaEphN3ZDTDZReXRcL1Y4Z2R6TTl3MGxt ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▶
  "_token" => "wltJnOXmmpROpJBWGgkSLwlq5uPQIWyItT56shLW"
  "_previous" => array:1 [▶
    "url" => "https://beta-media.runningconnect.com/event/DITUTMB2022_PERFECTSHOT?page=3&q=%2Fevent%2FDITUTMB2022_PERFECTSHOT"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

1 x Application (73.31%)	522ms
1 x Booting (26.69%)	190ms