RunningConnect Media - Hatyai Marathon 2019

Messages Timeline Exceptions Views4 Route Queries37 Models518 Mails Gate Session Request

7.4.33960ms41MBGET event/{slug}

Booting (188ms)
Application (772ms)
1 x Application (80.4%)
772ms
1 x Booting (19.6%)
188ms

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

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

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

Metadata
Bindings	0. qxzyO7TVHoqbjGc36sA7hHQIXcvp3JLkAFLN22za
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.55ms/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`430μ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;450μ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` = 'HM2019' and `events`.`deleted_at` is null limit 13.87ms/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 null600μs/app/Http/Controllers/Media/EventController.php:90runningconnect

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

590μs/app/Http/Controllers/Media/EventController.php:242runningconnect

Metadata
Bindings	0. 60 1. 1
Backtrace	15. /app/Http/Controllers/Media/EventController.php:242 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.9ms/app/Http/Controllers/Media/EventController.php:262runningconnect

Metadata
Bindings	0. 60 1. approved
Backtrace	14. /app/Http/Controllers/Media/EventController.php:262 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.66ms/app/Http/Controllers/Media/EventController.php:264runningconnect

Metadata
Bindings	0. 60 1. approved
Backtrace	14. /app/Http/Controllers/Media/EventController.php:264 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 1420μ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'3.47ms/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

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

Metadata
Bindings	0. completed 1. 60
Backtrace	15. /app/Http/Controllers/Media/EventController.php:287 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\";', 1753520818)

3.46ms/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. 1753520818
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:288

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

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

Metadata
Bindings	0. s:19:"2019-05-27 15:05:18"; 1. 1753520818 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:289

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

9.48ms/app/Http/Controllers/Media/EventController.php:362runningconnect

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:362 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:362
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 18.68ms/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'11.88ms/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

1.07ms/app/Http/Controllers/Media/EventController.php:403runningconnect

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

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

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

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

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

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

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

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

220ms/app/Http/Controllers/Media/EventController.php:406runningconnect

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

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

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

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

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

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

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

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

3.68ms/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. 1753520819
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 90) 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

2.65ms/app/Http/Controllers/Media/EventController.php:463runningconnect

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:463 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 900) 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

27.52ms/app/Http/Controllers/Media/EventController.php:464runningconnect

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:464 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 (3527625, 3527629, 3528178, 3528187, 3528190, 3528196, 3528203, 3528213, 3528216, 3528217, 3528225, 3528238, 3528240, 3528245, 3528251, 3528253, 3528257, 3528259, 3528267, 3528270, 3528275, 3528276, 3528280, 3528282, 3528290, 3528294, 3528298, 3528303, 3528304, 3528319, 3528320, 3528321, 3528322, 3528331, 3528336, 3528345, 3528351, 3528355, 3528360, 3528371, 3528373, 3528374, 3528375, 3528380, 3528383, 3528389, 3528401, 3528403, 3528407, 3528409, 3528411, 3528413, 3528430, 3528434, 3528436, 3528441, 3528446, 3528449, 3528452, 3528453, 3528465, 3528467, 3528470, 3528471, 3528475, 3528479, 3528480, 3528485, 3528487, 3528499, 3528504, 3528507, 3528508, 3528514, 3528516, 3528520, 3528527, 3528528, 3528530, 3528537, 3528538, 3528541, 3528543, 3528549, 3528554, 3528562, 3528575, 3528579, 3528580, 3528581, 3528589, 3528593, 3528594, 3528605, 3528610, 3528611, 3528613, 3528624, 3528626, 3528627) and `media_runner`.`deleted_at` is null

17.87ms/app/Http/Controllers/Media/EventController.php:464runningconnect

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

Metadata
Backtrace	19. /app/Http/Controllers/Media/EventController.php:464 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:464runningconnect

Metadata
Backtrace	19. /app/Http/Controllers/Media/EventController.php:464 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

760μs/app/Http/Controllers/Media/EventController.php:464runningconnect

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

580μsview::media.event.show:195runningconnect

Metadata
Bindings	0. 136221
Backtrace	20. view::media.event.show:195 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

820μs/app/Models/Event.php:566runningconnect

Metadata
Bindings	0. 60
Backtrace	19. /app/Models/Event.php:566 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` = 'qxzyO7TVHoqbjGc36sA7hHQIXcvp3JLkAFLN22za' limit 1760μs/vendor/laravel/framework/src/Illuminate/Session/DatabaseSessionHandler.php:91runningconnect

Metadata

Bindings

0. qxzyO7TVHoqbjGc36sA7hHQIXcvp3JLkAFLN22za

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 ('YTozOntzOjY6Il90b2tlbiI7czo0MDoiS3ZuYUVTa2NWV0V6Q1lycHJSYzBrS1puQVFseWFDakZ5ZUViVFpyOSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Nzg6Imh0dHBzOi8vYmV0YS1tZWRpYS5ydW5uaW5nY29ubmVjdC5jb20vZXZlbnQvSE0yMDE5P3BhZ2U9MTAmcT0lMkZldmVudCUyRkhNMjAxOSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1753520219, '', '172.31.21.226', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'qxzyO7TVHoqbjGc36sA7hHQIXcvp3JLkAFLN22za')

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

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

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

Metadata
Bindings	0. qxzyO7TVHoqbjGc36sA7hHQIXcvp3JLkAFLN22za
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: 28
App\Models\MediaPrice: 270
App\Models\Media: 103
App\Models\EventPhotographer: 108
App\Models\Event: 2

_token: KvnaESkcVWEzCYrprRc0kKZnAQlyaCjFyeEbTZr9
_previous: array:1 [ "url" => "https://beta-media.runningconnect.com/event/HM2019?page=10&q=%2Fevent%2FHM2019...
_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" => "10"
]

request_request

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

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-6884985a-0f723be80eeb71d101455059"
  ]
  "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.188"
  ]
  "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-6884985a-0f723be80eeb71d101455059"
  "HTTP_HOST" => "beta-media.runningconnect.com"
  "HTTP_X_FORWARDED_PORT" => "443"
  "HTTP_X_FORWARDED_PROTO" => "https"
  "HTTP_X_FORWARDED_FOR" => "216.73.216.188"
  "REDIRECT_STATUS" => "200"
  "SERVER_NAME" => "beta-www.runningconnect.com"
  "SERVER_PORT" => "443"
  "SERVER_ADDR" => "172.31.23.24"
  "REMOTE_PORT" => "31378"
  "REMOTE_ADDR" => "172.31.21.226"
  "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=10"
  "SCRIPT_NAME" => "/index.php"
  "CONTENT_LENGTH" => ""
  "CONTENT_TYPE" => ""
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => "q=/event/HM2019&page=10"
  "SCRIPT_FILENAME" => "/usr/share/nginx/html/RunningConnectBeta/public/index.php"
  "FCGI_ROLE" => "RESPONDER"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1753520218.2473
  "REQUEST_TIME" => 1753520218
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▶
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Sat, 26 Jul 2025 08:56:59 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "locale=eyJpdiI6IlVXN3h3WGlCMFVBb2VGRVQ3RlFxVnc9PSIsInZhbHVlIjoibThZWDA3SDhHUUg0TjhLNXp4b3ZsQT09IiwibWFjIjoiYTliYjA3MmNlOTgwNGI4Yzk0ZTdlOTZjYmVmMzIyODRiMzQzOTczNmViMGNlMDI5MjU2ODY0MmY3ODEwYWYxOSJ9; expires=Thu, 25-Jul-2030 08:56:59 GMT; Max-Age=157680000; path=/; domain=runningconnect.com; httponly ◀locale=eyJpdiI6IlVXN3h3WGlCMFVBb2VGRVQ3RlFxVnc9PSIsInZhbHVlIjoibThZWDA3SDhHUUg0TjhLNXp4b3ZsQT09IiwibWFjIjoiYTliYjA3MmNlOTgwNGI4Yzk0ZTdlOTZjYmVmMzIyODRiMzQzOTczN ▶"
    1 => "laravel_session=eyJpdiI6ImNkVHNuZWtkQkplVDg0OXFDaGdWZHc9PSIsInZhbHVlIjoiZ05XTVIwaHBNWTlMT01iY1B3TjdTQ1BNNzIyRTFtTldDR1V5WjQyZGlSYmRRcVZlOGNrWXArTHo1b0xqK01aME5WS0hqU1dmdnF3dVBydkFJSVB6TlE9PSIsIm1hYyI6IjIwMDFjZjgzMWIwMjFiYWY2N2M4YzcyNTk2MWIwYzRiMGM2OWQ5N2UwZWZhMTI5NTM4ZjY3MmJiY2E0YzEzOGIifQ%3D%3D; expires=Sat, 26-Jul-2025 10:56:59 GMT; Max-Age=7200; path=/; domain=runningconnect.com; httponly ◀laravel_session=eyJpdiI6ImNkVHNuZWtkQkplVDg0OXFDaGdWZHc9PSIsInZhbHVlIjoiZ05XTVIwaHBNWTlMT01iY1B3TjdTQ1BNNzIyRTFtTldDR1V5WjQyZGlSYmRRcVZlOGNrWXArTHo1b0xqK01aME5W ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "locale=eyJpdiI6IlVXN3h3WGlCMFVBb2VGRVQ3RlFxVnc9PSIsInZhbHVlIjoibThZWDA3SDhHUUg0TjhLNXp4b3ZsQT09IiwibWFjIjoiYTliYjA3MmNlOTgwNGI4Yzk0ZTdlOTZjYmVmMzIyODRiMzQzOTczNmViMGNlMDI5MjU2ODY0MmY3ODEwYWYxOSJ9; expires=Thu, 25-Jul-2030 08:56:59 GMT; domain=runningconnect.com; path=/; httponly ◀locale=eyJpdiI6IlVXN3h3WGlCMFVBb2VGRVQ3RlFxVnc9PSIsInZhbHVlIjoibThZWDA3SDhHUUg0TjhLNXp4b3ZsQT09IiwibWFjIjoiYTliYjA3MmNlOTgwNGI4Yzk0ZTdlOTZjYmVmMzIyODRiMzQzOTczN ▶"
    1 => "laravel_session=eyJpdiI6ImNkVHNuZWtkQkplVDg0OXFDaGdWZHc9PSIsInZhbHVlIjoiZ05XTVIwaHBNWTlMT01iY1B3TjdTQ1BNNzIyRTFtTldDR1V5WjQyZGlSYmRRcVZlOGNrWXArTHo1b0xqK01aME5WS0hqU1dmdnF3dVBydkFJSVB6TlE9PSIsIm1hYyI6IjIwMDFjZjgzMWIwMjFiYWY2N2M4YzcyNTk2MWIwYzRiMGM2OWQ5N2UwZWZhMTI5NTM4ZjY3MmJiY2E0YzEzOGIifQ%3D%3D; expires=Sat, 26-Jul-2025 10:56:59 GMT; domain=runningconnect.com; path=/; httponly ◀laravel_session=eyJpdiI6ImNkVHNuZWtkQkplVDg0OXFDaGdWZHc9PSIsInZhbHVlIjoiZ05XTVIwaHBNWTlMT01iY1B3TjdTQ1BNNzIyRTFtTldDR1V5WjQyZGlSYmRRcVZlOGNrWXArTHo1b0xqK01aME5W ▶"
  ]
]

session_attributes

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

1 x Application (80.4%)	772ms
1 x Booting (19.6%)	188ms