RunningConnect Media - Hatyai Marathon 2019

Messages Timeline Exceptions Views4 Route Queries37 Models595 Mails Gate Session Request

7.4.331.25s41MBGET event/{slug}

Booting (145ms)
Application (1.1s)
1 x Application (88.41%)
1.10s
1 x Booting (11.59%)
145ms

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-561

37 statements were executed, 9 of which were duplicated, 28 unique776ms

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

Metadata
Bindings	0. ZykfeygodcSJfQEjMWX8UGhcSnWykYrMG8fRJXca
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.91ms/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`540μ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;21.85ms/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` = 'HM2019' and `events`.`deleted_at` is null limit 127.61ms/app/Http/Controllers/Media/EventController.php:77runningconnect

Metadata
Bindings	0. HM2019
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` = 60 and `type` = 'media' and `tags`.`deleted_at` is null630μs/app/Http/Controllers/Media/EventController.php:89runningconnect

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

600μs/app/Http/Controllers/Media/EventController.php:237runningconnect

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

1.83ms/app/Http/Controllers/Media/EventController.php:257runningconnect

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

1.65ms/app/Http/Controllers/Media/EventController.php:259runningconnect

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

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

Metadata
Bindings	0. laravelHM2019: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` = 60 and `media`.`deleted_at` is null limit 1

195ms/app/Http/Controllers/Media/EventController.php:282runningconnect

Metadata
Bindings	0. completed 1. 60
Backtrace	15. /app/Http/Controllers/Media/EventController.php:282 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 ('laravelHM2019:min_shot_at', 's:19:\"2019-05-24 13:04:45\";', 1746462027)

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

Metadata
Bindings	0. laravelHM2019:min_shot_at 1. s:19:"2019-05-24 13:04:45"; 2. 1746462027
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:283

update `cache` set `value` = 's:19:\"2019-05-27 15:05:18\";', `expiration` = 1746462027 where `key` = 'laravelHM2019:max_shot_at'

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

Metadata
Bindings	0. s:19:"2019-05-27 15:05:18"; 1. 1746462027 2. laravelHM2019: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:284

select * from `media_price` where exists (select * from `media_setting` where `media_price`.`media_setting_id` = `media_setting`.`id` and `event_id` = 60 and `media_setting`.`deleted_at` is null) and `user_id` in (137866, 125612, 137280, 135907, 117128, 137758, 137843, 137225, 137846, 137813, 114056, 137721, 137869, 13625, 13604, 137203, 135128, 135127, 137765, 137350, 127048, 135155, 137738, 121665, 137749, 137874, 117280, 41956, 137724, 136495, 136221, 125283, 121785, 71539, 137729, 57202, 121663, 121763, 1867, 121874, 137754, 135140, 42825, 121756, 137842, 137871, 127177, 136223, 69658, 96358, 137684, 137826, 129131, 137731) and `media_price`.`deleted_at` is null

2.21ms/app/Http/Controllers/Media/EventController.php:357runningconnect

Metadata
Bindings	0. 60 1. 137866 2. 125612 3. 137280 4. 135907 5. 117128 6. 137758 7. 137843 8. 137225 9. 137846 10. 137813 11. 114056 12. 137721 13. 137869 14. 13625 15. 13604 16. 137203 17. 135128 18. 135127 19. 137765 20. 137350 21. 127048 22. 135155 23. 137738 24. 121665 25. 137749 26. 137874 27. 117280 28. 41956 29. 137724 30. 136495 31. 136221 32. 125283 33. 121785 34. 71539 35. 137729 36. 57202 37. 121663 38. 121763 39. 1867 40. 121874 41. 137754 42. 135140 43. 42825 44. 121756 45. 137842 46. 137871 47. 127177 48. 136223 49. 69658 50. 96358 51. 137684 52. 137826 53. 129131 54. 137731
Backtrace	14. /app/Http/Controllers/Media/EventController.php:357 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. 60
1. 137866
2. 125612
3. 137280
4. 135907
5. 117128
6. 137758
7. 137843
8. 137225
9. 137846
10. 137813
11. 114056
12. 137721
13. 137869
14. 13625
15. 13604
16. 137203
17. 135128
18. 135127
19. 137765
20. 137350
21. 127048
22. 135155
23. 137738
24. 121665
25. 137749
26. 137874
27. 117280
28. 41956
29. 137724
30. 136495
31. 136221
32. 125283
33. 121785
34. 71539
35. 137729
36. 57202
37. 121663
38. 121763
39. 1867
40. 121874
41. 137754
42. 135140
43. 42825
44. 121756
45. 137842
46. 137871
47. 127177
48. 136223
49. 69658
50. 96358
51. 137684
52. 137826
53. 129131
54. 137731

Backtrace

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

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

Metadata
Bindings	0. laravelHM2019: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` = 60 and `media`.`deleted_at` is null limit 1

900μs/app/Http/Controllers/Media/EventController.php:398runningconnect

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

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

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

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

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

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

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

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

138ms/app/Http/Controllers/Media/EventController.php:401runningconnect

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

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

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

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

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

select `id` from `events` where 0 = 1 and `events`.`deleted_at` is null2.22ms/app/Http/Controllers/Media/EventController.php:401runningconnect

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

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

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

Metadata
Bindings	0. laravelHM2019:count_completed 1. a:2:{s:6:"images";i:239704;s:6:"videos";i:0;} 2. 1746462027
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` = 60 and `media`.`deleted_at` is null limit 10 offset 23930) as m on `media`.`id` = `m`.`id` where `type` = 'video' and `media`.`status` = 'completed' and `is_approved` = 1 and `media`.`event_id` = 60 and `media`.`deleted_at` is null

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

Metadata
Bindings	0. video 1. completed 2. 1 3. 60 4. video 5. completed 6. 1 7. 60
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 `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` = 60 and `media`.`deleted_at` is null limit 100 offset 239300) as m on `media`.`id` = `m`.`id` where `type` = 'image' and `media`.`status` = 'completed' and `is_approved` = 1 and `media`.`event_id` = 60 and `media`.`deleted_at` is null

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

Metadata
Bindings	0. image 1. completed 2. 1 3. 60 4. image 5. completed 6. 1 7. 60
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 * from `media_runner` where `media_runner`.`media_id` in (3780163, 3780165, 3780168, 3780195, 3780207, 3780209, 3780211, 3780212, 3780214, 3780235, 3780254, 3780255, 3780256, 3780259, 3780260, 3780284, 3780298, 3780300, 3780301, 3780302, 3780304, 3780322, 3780332, 3780333, 3780335, 3780337, 3780340, 3780354, 3780362, 3780365, 3780366, 3780368, 3780369, 3780379, 3780386, 3780389, 3780392, 3780393, 3780394, 3780410, 3780417, 3780421, 3780425, 3780426, 3780428, 3780439, 3780445, 3780447, 3780449, 3780452, 3780454, 3780471, 3780477, 3780483, 3780485, 3780486, 3780487, 3780502, 3780503, 3780506, 3780508, 3780511, 3780512, 3780531, 3780533, 3780538, 3780541, 3780542, 3780546, 3780558, 3780563, 3780564, 3780565, 3780568, 3780569, 3780574, 3780576, 3780580, 3780583, 3780585, 3780588, 3780595, 3780596, 3780597, 3780599, 3780601, 3780602, 3780744, 3780745, 3780749, 3780750, 3780752, 3780753, 3780757, 3780760, 3780765, 3780767, 3780768, 3780769, 3780771) and `media_runner`.`deleted_at` is null

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

Metadata
Backtrace	19. /app/Http/Controllers/Media/EventController.php:459 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 (129131) and `users`.`deleted_at` is null480μs/app/Http/Controllers/Media/EventController.php:459runningconnect

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

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

880μs/app/Http/Controllers/Media/EventController.php:459runningconnect

Metadata
Bindings	0. 1
Backtrace	24. /app/Http/Controllers/Media/EventController.php:459 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 `photographers` where `photographers`.`user_id` = 129131 and `photographers`.`user_id` is not null and `photographers`.`deleted_at` is null limit 1

530μsview::media.event.show:192runningconnect

Metadata
Bindings	0. 129131
Backtrace	20. view::media.event.show:192 22. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 23. /vendor/laravel/framework/src/Illuminate/View/View.php:142 24. /vendor/laravel/framework/src/Illuminate/View/View.php:125 25. /vendor/laravel/framework/src/Illuminate/View/View.php:90

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

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

Metadata
Bindings	0. 60
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` = 'ZykfeygodcSJfQEjMWX8UGhcSnWykYrMG8fRJXca' limit 1830μs/vendor/laravel/framework/src/Illuminate/Session/DatabaseSessionHandler.php:91runningconnect

Metadata

Bindings

0. ZykfeygodcSJfQEjMWX8UGhcSnWykYrMG8fRJXca

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 ('YTozOntzOjY6Il90b2tlbiI7czo0MDoiWjZhbTI0WjFTQ1BSWUtjSlFqd3JneDNIVzkzem1HeGlJNVNVblc2VCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6ODA6Imh0dHBzOi8vYmV0YS1tZWRpYS5ydW5uaW5nY29ubmVjdC5jb20vZXZlbnQvSE0yMDE5P3BhZ2U9MjM5NCZxPSUyRmV2ZW50JTJGSE0yMDE5Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1746461428, '', '172.31.41.147', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'ZykfeygodcSJfQEjMWX8UGhcSnWykYrMG8fRJXca')

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

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

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` = 'ZykfeygodcSJfQEjMWX8UGhcSnWykYrMG8fRJXca' limit 1820μs/vendor/laravel/framework/src/Illuminate/Session/DatabaseSessionHandler.php:91runningconnect

Metadata
Bindings	0. ZykfeygodcSJfQEjMWX8UGhcSnWykYrMG8fRJXca
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\Photographer: 1
App\Models\MediaSetting: 5
App\Models\User: 1
App\Models\MediaRunner: 105
App\Models\MediaPrice: 270
App\Models\Media: 103
App\Models\EventPhotographer: 108
App\Models\Event: 2

_token: Z6am24Z1SCPRYKcJQjwrgx3HW93zmGxiI5SUnW6T
_previous: array:1 [ "url" => "https://beta-media.runningconnect.com/event/HM2019?page=2394&q=%2Fevent%2FHM20...
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/event/HM2019

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:2 [▶
  "q" => "/event/HM2019"
  "page" => "2394"
]

request_request

  0 of 0   
array:2 [▶
  "q" => "/event/HM2019"
  "page" => "2394"
]

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-6818e2f2-1c8dd9da4e2ab28f195ef9bf"
  ]
  "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.116.61.169"
  ]
  "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-6818e2f2-1c8dd9da4e2ab28f195ef9bf"
  "HTTP_HOST" => "beta-media.runningconnect.com"
  "HTTP_X_FORWARDED_PORT" => "443"
  "HTTP_X_FORWARDED_PROTO" => "https"
  "HTTP_X_FORWARDED_FOR" => "18.116.61.169"
  "REDIRECT_STATUS" => "200"
  "SERVER_NAME" => "beta-www.runningconnect.com"
  "SERVER_PORT" => "443"
  "SERVER_ADDR" => "172.31.23.24"
  "REMOTE_PORT" => "32554"
  "REMOTE_ADDR" => "172.31.41.147"
  "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/HM2019?page=2394"
  "SCRIPT_NAME" => "/index.php"
  "CONTENT_LENGTH" => ""
  "CONTENT_TYPE" => ""
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => "q=/event/HM2019&page=2394"
  "SCRIPT_FILENAME" => "/usr/share/nginx/html/RunningConnectBeta/public/index.php"
  "FCGI_ROLE" => "RESPONDER"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1746461426.9144
  "REQUEST_TIME" => 1746461426
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▶
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Mon, 05 May 2025 16:10:28 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "locale=eyJpdiI6InVuRkY2cGJLYkhzNzk5SUNvMHpoZFE9PSIsInZhbHVlIjoiaERMdTZwTkVWWTJ0Y0lRalNPOHg1UT09IiwibWFjIjoiMzA0MDUyMmIxZWYzMjNlNGU5NjIxMzM2YzA2MjNiOThlNzI5YzZhNDliMTg0NzA0MGEyZjBmM2ZkNmE0MjYxMiJ9; expires=Sat, 04-May-2030 16:10:28 GMT; Max-Age=157680000; path=/; domain=runningconnect.com; httponly ◀locale=eyJpdiI6InVuRkY2cGJLYkhzNzk5SUNvMHpoZFE9PSIsInZhbHVlIjoiaERMdTZwTkVWWTJ0Y0lRalNPOHg1UT09IiwibWFjIjoiMzA0MDUyMmIxZWYzMjNlNGU5NjIxMzM2YzA2MjNiOThlNzI5YzZhN ▶"
    1 => "laravel_session=eyJpdiI6ImZDYzVBa0xTbXRvOFlaclwvZDZqdXF3PT0iLCJ2YWx1ZSI6Im1xRCtuaE5SN3oxcmNjOG55SlF1XC9nQm1tQURJQjc4TXdkUGdQeW9CaUpZK1JvMnFjWVd3ZWNTWGFXdXpZVVBHOWgxVFVCXC9WdHpZa1N6U00yN1g0bXc9PSIsIm1hYyI6IjdhNTQ1ODViODU4MjhkYjFkZTk0MzNiOWRjYzRjODM3ZDQ2MGI0ZjM1ZDBiYmJkZDI4MDBiYzEyNmJjYTNiMTIifQ%3D%3D; expires=Mon, 05-May-2025 18:10:28 GMT; Max-Age=7200; path=/; domain=runningconnect.com; httponly ◀laravel_session=eyJpdiI6ImZDYzVBa0xTbXRvOFlaclwvZDZqdXF3PT0iLCJ2YWx1ZSI6Im1xRCtuaE5SN3oxcmNjOG55SlF1XC9nQm1tQURJQjc4TXdkUGdQeW9CaUpZK1JvMnFjWVd3ZWNTWGFXdXpZVVBH ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "locale=eyJpdiI6InVuRkY2cGJLYkhzNzk5SUNvMHpoZFE9PSIsInZhbHVlIjoiaERMdTZwTkVWWTJ0Y0lRalNPOHg1UT09IiwibWFjIjoiMzA0MDUyMmIxZWYzMjNlNGU5NjIxMzM2YzA2MjNiOThlNzI5YzZhNDliMTg0NzA0MGEyZjBmM2ZkNmE0MjYxMiJ9; expires=Sat, 04-May-2030 16:10:28 GMT; domain=runningconnect.com; path=/; httponly ◀locale=eyJpdiI6InVuRkY2cGJLYkhzNzk5SUNvMHpoZFE9PSIsInZhbHVlIjoiaERMdTZwTkVWWTJ0Y0lRalNPOHg1UT09IiwibWFjIjoiMzA0MDUyMmIxZWYzMjNlNGU5NjIxMzM2YzA2MjNiOThlNzI5YzZhN ▶"
    1 => "laravel_session=eyJpdiI6ImZDYzVBa0xTbXRvOFlaclwvZDZqdXF3PT0iLCJ2YWx1ZSI6Im1xRCtuaE5SN3oxcmNjOG55SlF1XC9nQm1tQURJQjc4TXdkUGdQeW9CaUpZK1JvMnFjWVd3ZWNTWGFXdXpZVVBHOWgxVFVCXC9WdHpZa1N6U00yN1g0bXc9PSIsIm1hYyI6IjdhNTQ1ODViODU4MjhkYjFkZTk0MzNiOWRjYzRjODM3ZDQ2MGI0ZjM1ZDBiYmJkZDI4MDBiYzEyNmJjYTNiMTIifQ%3D%3D; expires=Mon, 05-May-2025 18:10:28 GMT; domain=runningconnect.com; path=/; httponly ◀laravel_session=eyJpdiI6ImZDYzVBa0xTbXRvOFlaclwvZDZqdXF3PT0iLCJ2YWx1ZSI6Im1xRCtuaE5SN3oxcmNjOG55SlF1XC9nQm1tQURJQjc4TXdkUGdQeW9CaUpZK1JvMnFjWVd3ZWNTWGFXdXpZVVBH ▶"
  ]
]

session_attributes

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

1 x Application (88.41%)	1.10s
1 x Booting (11.59%)	145ms