RunningConnect Media - KOP RUN BANGKOK 2019 PRESENTED BY AXA

Messages Timeline Exceptions Views4 Route Queries37 Models473 Mails Gate Session Request

7.4.331.5s40MBGET event/{slug}

Booting (560ms)
Application (939ms)
1 x Application (62.64%)
939ms
1 x Booting (37.36%)
560ms

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 unique727ms

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

Metadata
Bindings	0. Y9dziGaDvR8m8MLip82FsU3O1jvOMLOc59FpaAs3
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` = 15.76ms/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`10.82ms/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;17.12ms/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` = 'THEKOP2019' and `events`.`deleted_at` is null limit 128.85ms/app/Http/Controllers/Media/EventController.php:77runningconnect

Metadata
Bindings	0. THEKOP2019
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` = 110 and `type` = 'media' and `tags`.`deleted_at` is null10.6ms/app/Http/Controllers/Media/EventController.php:90runningconnect

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

19.53ms/app/Http/Controllers/Media/EventController.php:242runningconnect

Metadata
Bindings	0. 110 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` = 110 and `status` = 'approved' and `event_photographers`.`deleted_at` is null order by `display_name` asc

19.75ms/app/Http/Controllers/Media/EventController.php:262runningconnect

Metadata
Bindings	0. 110 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` = 110 and `status` = 'approved' and `event_photographers`.`deleted_at` is null order by `display_name` asc

19.66ms/app/Http/Controllers/Media/EventController.php:264runningconnect

Metadata
Bindings	0. 110 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` = 'laravelTHEKOP2019:min_shot_at' limit 18.58ms/vendor/laravel/framework/src/Illuminate/Cache/DatabaseStore.php:63runningconnect

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

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

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

Metadata
Bindings	0. completed 1. 110
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 ('laravelTHEKOP2019:min_shot_at', 's:19:\"2019-10-04 11:43:21\";', 1753950695)

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

Metadata
Bindings	0. laravelTHEKOP2019:min_shot_at 1. s:19:"2019-10-04 11:43:21"; 2. 1753950695
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-10-07 14:24:26\";', `expiration` = 1753950695 where `key` = 'laravelTHEKOP2019:max_shot_at'

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

Metadata
Bindings	0. s:19:"2019-10-07 14:24:26"; 1. 1753950695 2. laravelTHEKOP2019: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` = 110 and `media_setting`.`deleted_at` is null) and `user_id` in (212581, 121752, 25427, 24024, 191980, 212254, 136498, 161594, 172880, 135911, 168073, 158365, 80176, 181462, 22024, 136333, 64335, 212398, 196377, 102600, 6736, 122065, 121665, 139889, 62047, 134990, 214820, 121772, 211897, 212118, 139943, 214819, 166328, 180635, 71727, 1867, 121874, 21914, 95786, 121756, 212285, 68730, 97209, 200921, 102227) and `media_price`.`deleted_at` is null

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

Metadata
Bindings	0. 110 1. 212581 2. 121752 3. 25427 4. 24024 5. 191980 6. 212254 7. 136498 8. 161594 9. 172880 10. 135911 11. 168073 12. 158365 13. 80176 14. 181462 15. 22024 16. 136333 17. 64335 18. 212398 19. 196377 20. 102600 21. 6736 22. 122065 23. 121665 24. 139889 25. 62047 26. 134990 27. 214820 28. 121772 29. 211897 30. 212118 31. 139943 32. 214819 33. 166328 34. 180635 35. 71727 36. 1867 37. 121874 38. 21914 39. 95786 40. 121756 41. 212285 42. 68730 43. 97209 44. 200921 45. 102227
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. 110
1. 212581
2. 121752
3. 25427
4. 24024
5. 191980
6. 212254
7. 136498
8. 161594
9. 172880
10. 135911
11. 168073
12. 158365
13. 80176
14. 181462
15. 22024
16. 136333
17. 64335
18. 212398
19. 196377
20. 102600
21. 6736
22. 122065
23. 121665
24. 139889
25. 62047
26. 134990
27. 214820
28. 121772
29. 211897
30. 212118
31. 139943
32. 214819
33. 166328
34. 180635
35. 71727
36. 1867
37. 121874
38. 21914
39. 95786
40. 121756
41. 212285
42. 68730
43. 97209
44. 200921
45. 102227

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` = 'laravelTHEKOP2019:count_completed' limit 12.17ms/vendor/laravel/framework/src/Illuminate/Cache/DatabaseStore.php:63runningconnect

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

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

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

Metadata
Bindings	0. video 1. completed 2. 1 3. 110
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 null12.8ms/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 null980μ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 null6.41ms/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` = 110 and `media`.`deleted_at` is null limit 1

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

Metadata
Bindings	0. image 1. completed 2. 1 3. 110
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 null880μ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 null540μ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 null2.43ms/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 ('laravelTHEKOP2019:count_completed', 'a:2:{s:6:\"images\";i:161618;s:6:\"videos\";i:0;}', 1753950695)

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

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

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

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

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

Metadata
Bindings	0. image 1. completed 2. 1 3. 110 4. image 5. completed 6. 1 7. 110
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 (5859492, 5859494, 5859498, 5859499, 5859500, 5859501, 5859502, 5859503, 5859504, 5859505, 5859506, 5859507, 5859508, 5859509, 5859510, 5859511, 5859512, 5859513, 5859514, 5859515, 5859516, 5859517, 5859518, 5859519, 5859520, 5859521, 5859522, 5859523, 5859524, 5859525, 5859526, 5859527, 5859528, 5859529, 5859530, 5859531, 5859532, 5859533, 5859534, 5859535, 5859536, 5859537, 5859538, 5859539, 5859540, 5859541, 5859542, 5859543, 5859544, 5859545, 5859546, 5859547, 5859548, 5859549, 5859550, 5859551, 5859552, 5859553, 5859554, 5859555, 5859556, 5859557, 5859558, 5859559, 5859560, 5859561, 5859562, 5859563, 5859564, 5859565, 5859566, 5859567, 5859568, 5859569, 5859570, 5859571, 5859572, 5859573, 5859574, 5859575, 5859576, 5859577, 5859578, 5859579, 5859580, 5859581, 5859582, 5859583, 5859584, 5859585, 5859586, 5859587, 5859588, 5859589, 5859590, 5859591, 5859592, 5859593, 5859594, 5859595) and `media_runner`.`deleted_at` is null

12.93ms/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 (136498) and `users`.`deleted_at` is null560μ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 (110) and `events`.`deleted_at` is null640μ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 (110) and `is_buyable` = 1 and `media_setting`.`deleted_at` is null order by `media_setting`.`height` desc

690μ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` = 136498 and `photographers`.`user_id` is not null and `photographers`.`deleted_at` is null limit 1

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

Metadata
Bindings	0. 136498
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` = 110 and `custom_field`.`event_id` is not null and `custom_field`.`deleted_at` is null

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

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

Metadata

Bindings

0. Y9dziGaDvR8m8MLip82FsU3O1jvOMLOc59FpaAs3

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 ('YTozOntzOjY6Il90b2tlbiI7czo0MDoidlh5VVhxTDVmc1R0R2dqRng3MWZ4YzNVZUJONE1Xc0dGRExxUGw4TiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6ODU6Imh0dHBzOi8vYmV0YS1tZWRpYS5ydW5uaW5nY29ubmVjdC5jb20vZXZlbnQvVEhFS09QMjAxOT9wYWdlPTUmcT0lMkZldmVudCUyRlRIRUtPUDIwMTkiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1753950095, '', '172.31.43.100', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'Y9dziGaDvR8m8MLip82FsU3O1jvOMLOc59FpaAs3')

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

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

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

Metadata
Bindings	0. Y9dziGaDvR8m8MLip82FsU3O1jvOMLOc59FpaAs3
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: 46
App\Models\MediaPrice: 225
App\Models\Media: 103
App\Models\EventPhotographer: 90
App\Models\Event: 2

_token: vXyUXqL5fsTtGgjFx71fxc3UeBN4MWsGFDLqPl8N
_previous: array:1 [ "url" => "https://beta-media.runningconnect.com/event/THEKOP2019?page=5&q=%2Fevent%2FTHE...
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/event/THEKOP2019

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:2 [▶
  "q" => "/event/THEKOP2019"
  "page" => "5"
]

request_request

  0 of 0   
array:2 [▶
  "q" => "/event/THEKOP2019"
  "page" => "5"
]

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-688b278e-66193c7e710714412c82cb79"
  ]
  "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.77"
  ]
  "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-688b278e-66193c7e710714412c82cb79"
  "HTTP_HOST" => "beta-media.runningconnect.com"
  "HTTP_X_FORWARDED_PORT" => "443"
  "HTTP_X_FORWARDED_PROTO" => "https"
  "HTTP_X_FORWARDED_FOR" => "216.73.216.77"
  "REDIRECT_STATUS" => "200"
  "SERVER_NAME" => "beta-www.runningconnect.com"
  "SERVER_PORT" => "443"
  "SERVER_ADDR" => "172.31.23.24"
  "REMOTE_PORT" => "9502"
  "REMOTE_ADDR" => "172.31.43.100"
  "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/THEKOP2019?page=5"
  "SCRIPT_NAME" => "/index.php"
  "CONTENT_LENGTH" => ""
  "CONTENT_TYPE" => ""
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => "q=/event/THEKOP2019&page=5"
  "SCRIPT_FILENAME" => "/usr/share/nginx/html/RunningConnectBeta/public/index.php"
  "FCGI_ROLE" => "RESPONDER"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1753950094.434
  "REQUEST_TIME" => 1753950094
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▶
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Thu, 31 Jul 2025 08:21:35 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "locale=eyJpdiI6InNjVWlwWmJ4N1RoNUpGMk1PUlwvUkdBPT0iLCJ2YWx1ZSI6InNMdDZQOUkrejFcL1hNbEFaVHg5b1hBPT0iLCJtYWMiOiI5ODg5ZjI0YjJhMDE5YzZlZTMxYzllZjNlOTA0OTcwOWQwZDJmNDE0MWJjZDZiNTczMWIwMTllNzM3Y2MyYjQzIn0%3D; expires=Tue, 30-Jul-2030 08:21:35 GMT; Max-Age=157680000; path=/; domain=runningconnect.com; httponly ◀locale=eyJpdiI6InNjVWlwWmJ4N1RoNUpGMk1PUlwvUkdBPT0iLCJ2YWx1ZSI6InNMdDZQOUkrejFcL1hNbEFaVHg5b1hBPT0iLCJtYWMiOiI5ODg5ZjI0YjJhMDE5YzZlZTMxYzllZjNlOTA0OTcwOWQwZDJmN ▶"
    1 => "laravel_session=eyJpdiI6IjJHU2tMNXZVbUY4ZFBDNU5aN3Zmb3c9PSIsInZhbHVlIjoiZ05cL0pRVDBORkVTaHBGQUF2OHI5TGJ0SnZkK1pnSTJ4UmZuSXdmY0orRlUxaGc4YXJoXC82T3lKc3BzK3pkemozMVoxU0hkS2pTc3BrOXNncXhnU241Zz09IiwibWFjIjoiNTllZWZjOTc2NWVkN2NiNTU2Y2U4MDUzNjliMmNmNGEzYWZiZTJkNjQxMWQ4ODJmNjQyMjZjNjM4NzA0YjMxYiJ9; expires=Thu, 31-Jul-2025 10:21:35 GMT; Max-Age=7200; path=/; domain=runningconnect.com; httponly ◀laravel_session=eyJpdiI6IjJHU2tMNXZVbUY4ZFBDNU5aN3Zmb3c9PSIsInZhbHVlIjoiZ05cL0pRVDBORkVTaHBGQUF2OHI5TGJ0SnZkK1pnSTJ4UmZuSXdmY0orRlUxaGc4YXJoXC82T3lKc3BzK3pkemoz ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "locale=eyJpdiI6InNjVWlwWmJ4N1RoNUpGMk1PUlwvUkdBPT0iLCJ2YWx1ZSI6InNMdDZQOUkrejFcL1hNbEFaVHg5b1hBPT0iLCJtYWMiOiI5ODg5ZjI0YjJhMDE5YzZlZTMxYzllZjNlOTA0OTcwOWQwZDJmNDE0MWJjZDZiNTczMWIwMTllNzM3Y2MyYjQzIn0%3D; expires=Tue, 30-Jul-2030 08:21:35 GMT; domain=runningconnect.com; path=/; httponly ◀locale=eyJpdiI6InNjVWlwWmJ4N1RoNUpGMk1PUlwvUkdBPT0iLCJ2YWx1ZSI6InNMdDZQOUkrejFcL1hNbEFaVHg5b1hBPT0iLCJtYWMiOiI5ODg5ZjI0YjJhMDE5YzZlZTMxYzllZjNlOTA0OTcwOWQwZDJmN ▶"
    1 => "laravel_session=eyJpdiI6IjJHU2tMNXZVbUY4ZFBDNU5aN3Zmb3c9PSIsInZhbHVlIjoiZ05cL0pRVDBORkVTaHBGQUF2OHI5TGJ0SnZkK1pnSTJ4UmZuSXdmY0orRlUxaGc4YXJoXC82T3lKc3BzK3pkemozMVoxU0hkS2pTc3BrOXNncXhnU241Zz09IiwibWFjIjoiNTllZWZjOTc2NWVkN2NiNTU2Y2U4MDUzNjliMmNmNGEzYWZiZTJkNjQxMWQ4ODJmNjQyMjZjNjM4NzA0YjMxYiJ9; expires=Thu, 31-Jul-2025 10:21:35 GMT; domain=runningconnect.com; path=/; httponly ◀laravel_session=eyJpdiI6IjJHU2tMNXZVbUY4ZFBDNU5aN3Zmb3c9PSIsInZhbHVlIjoiZ05cL0pRVDBORkVTaHBGQUF2OHI5TGJ0SnZkK1pnSTJ4UmZuSXdmY0orRlUxaGc4YXJoXC82T3lKc3BzK3pkemoz ▶"
  ]
]

session_attributes

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

1 x Application (62.64%)	939ms
1 x Booting (37.36%)	560ms