RunningConnect Media - The Perfect Shot by Thailand by UTMB 2021

Messages Timeline Exceptions Views4 Route Queries35 Models496 Mails Gate Session Request

7.4.33506ms40MBGET event/{slug}

Booting (239ms)
Application (268ms)
1 x Application (52.91%)
268ms
1 x Booting (47.09%)
239ms

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:70-562

35 statements were executed, 13 of which were duplicated, 22 unique157ms

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

Metadata
Bindings	0. 0pagQrHfY7YxgyHSc28sW0PPp4Uf4A8PVKjxM4KW
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` = 13.53ms/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`740μ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;230μ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:72 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` = 'TUTMB2021_PERFECTSHOT' and `events`.`deleted_at` is null limit 12.46ms/app/Http/Controllers/Media/EventController.php:77runningconnect

Metadata
Bindings	0. TUTMB2021_PERFECTSHOT
Backtrace	15. /app/Http/Controllers/Media/EventController.php:77 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` = 144 and `type` = 'media' and `tags`.`deleted_at` is null840μs/app/Http/Controllers/Media/EventController.php:90runningconnect

Metadata
Bindings	0. 144 1. media
Backtrace	14. /app/Http/Controllers/Media/EventController.php:90 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` = 144 and `has_personal_video` = 1 and `event_category`.`deleted_at` is null limit 1

780μs/app/Http/Controllers/Media/EventController.php:238runningconnect

Metadata
Bindings	0. 144 1. 1
Backtrace	15. /app/Http/Controllers/Media/EventController.php:238 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` = 144 and `status` = 'approved' and `event_photographers`.`deleted_at` is null order by `display_name` asc

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

Metadata
Bindings	0. 144 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 *, `event_photographers`.`id` as `id` from `event_photographers` inner join `photographers` on `photographers`.`user_id` = `event_photographers`.`user_id` where `event_id` = 144 and `status` = 'approved' and `event_photographers`.`deleted_at` is null order by `display_name` asc

1.94ms/app/Http/Controllers/Media/EventController.php:260runningconnect

Metadata
Bindings	0. 144 1. approved
Backtrace	14. /app/Http/Controllers/Media/EventController.php:260 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` = 'laravelTUTMB2021_PERFECTSHOT:min_shot_at' limit 1980μs/vendor/laravel/framework/src/Illuminate/Cache/DatabaseStore.php:63runningconnect

Metadata
Bindings	0. laravelTUTMB2021_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

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

Metadata
Bindings	0. laravelTUTMB2021_PERFECTSHOT:max_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

select * from `cache` where `key` = 'laravelTUTMB2021_PERFECTSHOT:min_shot_at' limit 12.24ms/vendor/laravel/framework/src/Illuminate/Cache/DatabaseStore.php:63runningconnect

Metadata
Bindings	0. laravelTUTMB2021_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/CacheManager.php:357 16. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 17. /app/Http/Controllers/Media/EventController.php:289

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

Metadata
Bindings	0. laravelTUTMB2021_PERFECTSHOT:max_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/CacheManager.php:357 16. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 17. /app/Http/Controllers/Media/EventController.php:290

select * from `media_price` where exists (select * from `media_setting` where `media_price`.`media_setting_id` = `media_setting`.`id` and `event_id` = 144 and `media_setting`.`deleted_at` is null) and `user_id` in (28500, 3616, 123427, 94471, 227988, 5888, 120979, 43736, 168073, 172756, 8, 102067, 137856, 179827, 93568, 71196, 7085, 261629, 130044, 136074, 61844, 97815, 117193, 123727, 6528, 237157, 12875, 130183, 208300, 37075, 123955, 123008, 5654, 206440, 139293, 168175, 136421, 78020, 121785, 20864, 164024, 121663, 259800, 1867, 136520, 121874, 136065, 24262, 137842, 200921, 164305) and `media_price`.`deleted_at` is null

4.18ms/app/Http/Controllers/Media/EventController.php:358runningconnect

Metadata
Bindings	0. 144 1. 28500 2. 3616 3. 123427 4. 94471 5. 227988 6. 5888 7. 120979 8. 43736 9. 168073 10. 172756 11. 8 12. 102067 13. 137856 14. 179827 15. 93568 16. 71196 17. 7085 18. 261629 19. 130044 20. 136074 21. 61844 22. 97815 23. 117193 24. 123727 25. 6528 26. 237157 27. 12875 28. 130183 29. 208300 30. 37075 31. 123955 32. 123008 33. 5654 34. 206440 35. 139293 36. 168175 37. 136421 38. 78020 39. 121785 40. 20864 41. 164024 42. 121663 43. 259800 44. 1867 45. 136520 46. 121874 47. 136065 48. 24262 49. 137842 50. 200921 51. 164305
Backtrace	14. /app/Http/Controllers/Media/EventController.php:358 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. 144
1. 28500
2. 3616
3. 123427
4. 94471
5. 227988
6. 5888
7. 120979
8. 43736
9. 168073
10. 172756
11. 8
12. 102067
13. 137856
14. 179827
15. 93568
16. 71196
17. 7085
18. 261629
19. 130044
20. 136074
21. 61844
22. 97815
23. 117193
24. 123727
25. 6528
26. 237157
27. 12875
28. 130183
29. 208300
30. 37075
31. 123955
32. 123008
33. 5654
34. 206440
35. 139293
36. 168175
37. 136421
38. 78020
39. 121785
40. 20864
41. 164024
42. 121663
43. 259800
44. 1867
45. 136520
46. 121874
47. 136065
48. 24262
49. 137842
50. 200921
51. 164305

Backtrace

14. /app/Http/Controllers/Media/EventController.php:358
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` = 'laravelTUTMB2021_PERFECTSHOT:count_completed' limit 1860μs/vendor/laravel/framework/src/Illuminate/Cache/DatabaseStore.php:63runningconnect

Metadata
Bindings	0. laravelTUTMB2021_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` = 'laravelTUTMB2021_PERFECTSHOT:count_completed'5.45ms/vendor/laravel/framework/src/Illuminate/Cache/DatabaseStore.php:216runningconnect

Metadata
Bindings	0. laravelTUTMB2021_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` = 144 and `media`.`deleted_at` is null order by shot_at desc limit 1

1.3ms/app/Http/Controllers/Media/EventController.php:399runningconnect

Metadata
Bindings	0. video 1. completed 2. 1 3. 144
Backtrace	15. /app/Http/Controllers/Media/EventController.php:399 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:405

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

Metadata
Backtrace	20. /app/Http/Controllers/Media/EventController.php:399 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:405

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

Metadata
Backtrace	20. /app/Http/Controllers/Media/EventController.php:399 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:405

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

Metadata
Backtrace	20. /app/Http/Controllers/Media/EventController.php:399 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:405

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

62.41ms/app/Http/Controllers/Media/EventController.php:402runningconnect

Metadata
Bindings	0. image 1. completed 2. 1 3. 144
Backtrace	15. /app/Http/Controllers/Media/EventController.php:402 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:405

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

Metadata
Backtrace	20. /app/Http/Controllers/Media/EventController.php:402 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:405

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

Metadata
Backtrace	20. /app/Http/Controllers/Media/EventController.php:402 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:405

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

Metadata
Backtrace	20. /app/Http/Controllers/Media/EventController.php:402 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:405

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

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

Metadata
Bindings	0. laravelTUTMB2021_PERFECTSHOT:count_completed 1. a:2:{s:6:"images";i:15722;s:6:"videos";i:0;} 2. 1751729199
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` = 144 and `media`.`deleted_at` is null order by shot_at desc limit 10 offset 80) as m on `media`.`id` = `m`.`id` where `type` = 'video' and `media`.`status` = 'completed' and `is_approved` = 1 and `media`.`event_id` = 144 and `media`.`deleted_at` is null order by shot_at desc

1.8ms/app/Http/Controllers/Media/EventController.php:459runningconnect

Metadata
Bindings	0. video 1. completed 2. 1 3. 144 4. video 5. completed 6. 1 7. 144
Backtrace	14. /app/Http/Controllers/Media/EventController.php:459 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` = 144 and `media`.`deleted_at` is null order by shot_at desc limit 100 offset 800) as m on `media`.`id` = `m`.`id` where `type` = 'image' and `media`.`status` = 'completed' and `is_approved` = 1 and `media`.`event_id` = 144 and `media`.`deleted_at` is null order by shot_at desc

19.73ms/app/Http/Controllers/Media/EventController.php:460runningconnect

Metadata
Bindings	0. image 1. completed 2. 1 3. 144 4. image 5. completed 6. 1 7. 144
Backtrace	14. /app/Http/Controllers/Media/EventController.php:460 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 (15889416, 15890577, 15890579, 15890580, 15890583, 15890584, 15890587, 15891083, 15891084, 15891085, 15891088, 15891955, 15891956, 15891957, 15891958, 15891959, 15891960, 15891961, 15891962, 15891963, 15891964, 15891965, 15891966, 15891967, 15891968, 15891969, 15891970, 15891971, 15891972, 15891973, 15891974, 15891975, 15891976, 15891977, 15891978, 15891979, 15891980, 15891981, 15891982, 15891983, 15891984, 15891985, 15891986, 15891987, 15891988, 15891989, 15891990, 15891991, 15891992, 15891993, 15891994, 15891995, 15891996, 15891997, 15891998, 15891999, 15892000, 15892001, 15892002, 15892003, 15892004, 15892005, 15892006, 15892007, 15892008, 15892009, 15892010, 15892011, 15892555, 15892559, 15892560, 15894085, 15894086, 15894087, 15894088, 15894089, 15894090, 15894091, 15894092, 15894093, 15894094, 15894680, 15895039, 15895040, 15895042, 15895043, 15895495, 15896944, 15896946, 15896947, 15897207, 15897581, 15897582, 15897583, 15898514, 15898516, 15898517, 15898518, 15898519, 15898520) and `media_runner`.`deleted_at` is null

8.88ms/app/Http/Controllers/Media/EventController.php:460runningconnect

Metadata
Backtrace	19. /app/Http/Controllers/Media/EventController.php:460 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 (78020, 93568, 102067, 121785, 123008, 130044, 137856, 164024, 164305, 168073, 172756, 208300) and `users`.`deleted_at` is null

840μs/app/Http/Controllers/Media/EventController.php:460runningconnect

Metadata
Backtrace	19. /app/Http/Controllers/Media/EventController.php:460 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 (144) and `events`.`deleted_at` is null560μs/app/Http/Controllers/Media/EventController.php:460runningconnect

Metadata
Backtrace	19. /app/Http/Controllers/Media/EventController.php:460 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 (144) and `is_buyable` = 1 and `media_setting`.`deleted_at` is null order by `media_setting`.`height` desc

510μs/app/Http/Controllers/Media/EventController.php:460runningconnect

Metadata
Bindings	0. 1
Backtrace	24. /app/Http/Controllers/Media/EventController.php:460 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` = 144 and `custom_field`.`event_id` is not null and `custom_field`.`deleted_at` is null

870μs/app/Models/Event.php:561runningconnect

Metadata
Bindings	0. 144
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` = '0pagQrHfY7YxgyHSc28sW0PPp4Uf4A8PVKjxM4KW' limit 13.23ms/vendor/laravel/framework/src/Illuminate/Session/DatabaseSessionHandler.php:91runningconnect

Metadata

Bindings

0. 0pagQrHfY7YxgyHSc28sW0PPp4Uf4A8PVKjxM4KW

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 ('YTozOntzOjY6Il90b2tlbiI7czo0MDoiVHBRWVZYYks2dWpCMlNXbXdhNHJsTVZkY01BVzlPQmNSZUkzOGt6YiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTA3OiJodHRwczovL2JldGEtbWVkaWEucnVubmluZ2Nvbm5lY3QuY29tL2V2ZW50L1RVVE1CMjAyMV9QRVJGRUNUU0hPVD9wYWdlPTkmcT0lMkZldmVudCUyRlRVVE1CMjAyMV9QRVJGRUNUU0hPVCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1751728600, '', '172.31.30.168', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '0pagQrHfY7YxgyHSc28sW0PPp4Uf4A8PVKjxM4KW')

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

Metadata
Bindings	0. YTozOntzOjY6Il90b2tlbiI7czo0MDoiVHBRWVZYYks2dWpCMlNXbXdhNHJsTVZkY01BVzlPQmNSZUkzOGt6YiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTA3OiJodHRwczovL2JldGEtbWVkaWEucnVubmluZ2Nvbm5lY3QuY29tL2V2ZW50L1RVVE1CMjAyMV9QRVJGRUNUU0hPVD9wYWdlPTkmcT0lMkZldmVudCUyRlRVVE1CMjAyMV9QRVJGRUNUU0hPVCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0= 1. 1751728600 2. 3. 172.31.30.168 4. Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) 5. 0pagQrHfY7YxgyHSc28sW0PPp4Uf4A8PVKjxM4KW
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. YTozOntzOjY6Il90b2tlbiI7czo0MDoiVHBRWVZYYks2dWpCMlNXbXdhNHJsTVZkY01BVzlPQmNSZUkzOGt6YiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTA3OiJodHRwczovL2JldGEtbWVkaWEucnVubmluZ2Nvbm5lY3QuY29tL2V2ZW50L1RVVE1CMjAyMV9QRVJGRUNUU0hPVD9wYWdlPTkmcT0lMkZldmVudCUyRlRVVE1CMjAyMV9QRVJGRUNUU0hPVCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=
1. 1751728600
2.
3. 172.31.30.168
4. Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
5. 0pagQrHfY7YxgyHSc28sW0PPp4Uf4A8PVKjxM4KW

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` = '0pagQrHfY7YxgyHSc28sW0PPp4Uf4A8PVKjxM4KW' limit 12.11ms/vendor/laravel/framework/src/Illuminate/Session/DatabaseSessionHandler.php:91runningconnect

Metadata
Bindings	0. 0pagQrHfY7YxgyHSc28sW0PPp4Uf4A8PVKjxM4KW
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: 12
App\Models\MediaRunner: 18
App\Models\Media: 102
App\Models\MediaPrice: 255
App\Models\EventPhotographer: 102
App\Models\Event: 2

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

path_info

/event/TUTMB2021_PERFECTSHOT

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:2 [▶
  "q" => "/event/TUTMB2021_PERFECTSHOT"
  "page" => "9"
]

request_request

  0 of 0   
array:2 [▶
  "q" => "/event/TUTMB2021_PERFECTSHOT"
  "page" => "9"
]

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 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "x-amzn-trace-id" => array:1 [▶
    0 => "Root=1-686941d7-5c6d0d3d6a55d856278e7c91"
  ]
  "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 => "216.73.216.137"
  ]
  "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" => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_X_AMZN_TRACE_ID" => "Root=1-686941d7-5c6d0d3d6a55d856278e7c91"
  "HTTP_HOST" => "beta-media.runningconnect.com"
  "HTTP_X_FORWARDED_PORT" => "443"
  "HTTP_X_FORWARDED_PROTO" => "https"
  "HTTP_X_FORWARDED_FOR" => "216.73.216.137"
  "REDIRECT_STATUS" => "200"
  "SERVER_NAME" => "beta-www.runningconnect.com"
  "SERVER_PORT" => "443"
  "SERVER_ADDR" => "172.31.23.24"
  "REMOTE_PORT" => "43212"
  "REMOTE_ADDR" => "172.31.30.168"
  "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/TUTMB2021_PERFECTSHOT?page=9"
  "SCRIPT_NAME" => "/index.php"
  "CONTENT_LENGTH" => ""
  "CONTENT_TYPE" => ""
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => "q=/event/TUTMB2021_PERFECTSHOT&page=9"
  "SCRIPT_FILENAME" => "/usr/share/nginx/html/RunningConnectBeta/public/index.php"
  "FCGI_ROLE" => "RESPONDER"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1751728599.5464
  "REQUEST_TIME" => 1751728599
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▶
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Sat, 05 Jul 2025 15:16:39 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "locale=eyJpdiI6IldNNmJyR29mWEFlSlJkcVJqZXNTN0E9PSIsInZhbHVlIjoiZGJoSFRYMW5zZjI4M2dwQUNXZE40QT09IiwibWFjIjoiNDZhNTVkMmVlMGEzMTZlMjEwMTI0MGQxOTk2NjVjMDk4ODY5YjI5NGFjMTkzMzIxMDQwMDY1NjFhMzAyOGRjYSJ9; expires=Thu, 04-Jul-2030 15:16:40 GMT; Max-Age=157680000; path=/; domain=runningconnect.com; httponly ◀locale=eyJpdiI6IldNNmJyR29mWEFlSlJkcVJqZXNTN0E9PSIsInZhbHVlIjoiZGJoSFRYMW5zZjI4M2dwQUNXZE40QT09IiwibWFjIjoiNDZhNTVkMmVlMGEzMTZlMjEwMTI0MGQxOTk2NjVjMDk4ODY5YjI5N ▶"
    1 => "laravel_session=eyJpdiI6InA2ZG1wSVArcENOd1psWVRPWkRnUWc9PSIsInZhbHVlIjoiXC9KTExiOFwvVkhadll0d1Y0QU1vQTBkK1I4SGdwcXlZdHZ5TlNWK3BsK2MxYVV3cktJeXF4ejZNU3VMS09aVXllNldoc3RWREhhd1RTdEo0S0FBaXI0dz09IiwibWFjIjoiYzgyM2FkZTY2ODMyYTY3MzIzYTNlOWVkZjE0ZjRjYTQ1N2RjMDgxNzk0YWI0NmNiNjNlN2MyODA5MWZlNGM2YiJ9; expires=Sat, 05-Jul-2025 17:16:40 GMT; Max-Age=7200; path=/; domain=runningconnect.com; httponly ◀laravel_session=eyJpdiI6InA2ZG1wSVArcENOd1psWVRPWkRnUWc9PSIsInZhbHVlIjoiXC9KTExiOFwvVkhadll0d1Y0QU1vQTBkK1I4SGdwcXlZdHZ5TlNWK3BsK2MxYVV3cktJeXF4ejZNU3VMS09aVXll ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "locale=eyJpdiI6IldNNmJyR29mWEFlSlJkcVJqZXNTN0E9PSIsInZhbHVlIjoiZGJoSFRYMW5zZjI4M2dwQUNXZE40QT09IiwibWFjIjoiNDZhNTVkMmVlMGEzMTZlMjEwMTI0MGQxOTk2NjVjMDk4ODY5YjI5NGFjMTkzMzIxMDQwMDY1NjFhMzAyOGRjYSJ9; expires=Thu, 04-Jul-2030 15:16:40 GMT; domain=runningconnect.com; path=/; httponly ◀locale=eyJpdiI6IldNNmJyR29mWEFlSlJkcVJqZXNTN0E9PSIsInZhbHVlIjoiZGJoSFRYMW5zZjI4M2dwQUNXZE40QT09IiwibWFjIjoiNDZhNTVkMmVlMGEzMTZlMjEwMTI0MGQxOTk2NjVjMDk4ODY5YjI5N ▶"
    1 => "laravel_session=eyJpdiI6InA2ZG1wSVArcENOd1psWVRPWkRnUWc9PSIsInZhbHVlIjoiXC9KTExiOFwvVkhadll0d1Y0QU1vQTBkK1I4SGdwcXlZdHZ5TlNWK3BsK2MxYVV3cktJeXF4ejZNU3VMS09aVXllNldoc3RWREhhd1RTdEo0S0FBaXI0dz09IiwibWFjIjoiYzgyM2FkZTY2ODMyYTY3MzIzYTNlOWVkZjE0ZjRjYTQ1N2RjMDgxNzk0YWI0NmNiNjNlN2MyODA5MWZlNGM2YiJ9; expires=Sat, 05-Jul-2025 17:16:40 GMT; domain=runningconnect.com; path=/; httponly ◀laravel_session=eyJpdiI6InA2ZG1wSVArcENOd1psWVRPWkRnUWc9PSIsInZhbHVlIjoiXC9KTExiOFwvVkhadll0d1Y0QU1vQTBkK1I4SGdwcXlZdHZ5TlNWK3BsK2MxYVV3cktJeXF4ejZNU3VMS09aVXll ▶"
  ]
]

session_attributes

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

1 x Application (52.91%)	268ms
1 x Booting (47.09%)	239ms