RunningConnect Media - KOP RUN BANGKOK 2019 PRESENTED BY AXA

Messages Timeline Exceptions Views4 Route Queries37 Models473 Mails Gate Session Request

7.4.33740ms40MBGET event/{slug}

Booting (124ms)
Application (616ms)
1 x Application (83.24%)
616ms
1 x Booting (16.75%)
124ms

4 templates were rendered

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


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

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

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

Params
0	`paginator`
1	`elements`

Params
0	`paginator`
1	`elements`

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


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

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

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

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

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

Metadata
Bindings	0. UHzStfha178PcGPRw5vrRqAKcNteqeRyRNvtczrh
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.31ms/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`670μ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;440μs/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239runningconnect

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

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

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

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

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

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

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

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

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

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

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

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

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

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

select * from `cache` where `key` = 'laravelTHEKOP2019:min_shot_at' limit 1610μs/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'3.84ms/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

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

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

insert into `cache` (`key`, `value`, `expiration`) values ('laravelTHEKOP2019:min_shot_at', 's:19:\"2019-10-04 11:43:21\";', 1744919972)

3.69ms/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. 1744919972
Backtrace	10. /vendor/laravel/framework/src/Illuminate/Cache/DatabaseStore.php:103 11. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:211 12. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 13. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 14. /app/Http/Controllers/Media/EventController.php:282

update `cache` set `value` = 's:19:\"2019-10-07 14:24:26\";', `expiration` = 1744919972 where `key` = 'laravelTHEKOP2019:max_shot_at'

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

Metadata
Bindings	0. s:19:"2019-10-07 14:24:26"; 1. 1744919972 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:283

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

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

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:356 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

Metadata

Bindings

0. 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:356
17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

select * from `cache` where `key` = 'laravelTHEKOP2019:count_completed' limit 1810μs/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'5.98ms/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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

3.88ms/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. 1744919972
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

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

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:457 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

select `media`.`type`, `media`.`original_deleted_at`, `media`.`user_id`, `media`.`width`, `media`.`height`, `media`.`preview_url`, `media`.`shot_at`, `media`.`media_price_id`, `media`.`event_id`, `media`.`medium_url`, `media`.`id` as `id` from `media` inner join (select `id` from `media` where `type` = 'image' and `media`.`status` = 'completed' and `is_approved` = 1 and `media`.`event_id` = 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

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

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:458 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

select * from `media_runner` where `media_runner`.`media_id` in (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

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

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

select * from `users` where `users`.`id` in (136498) and `users`.`deleted_at` is null800μs/app/Http/Controllers/Media/EventController.php:458runningconnect

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

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

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

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

820μs/app/Http/Controllers/Media/EventController.php:458runningconnect

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

select * from `photographers` where `photographers`.`user_id` = 136498 and `photographers`.`user_id` is not null and `photographers`.`deleted_at` is null limit 1

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

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

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

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

Metadata

Bindings

0. UHzStfha178PcGPRw5vrRqAKcNteqeRyRNvtczrh

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 ('YTozOntzOjY6Il90b2tlbiI7czo0MDoicmhoR3RYeGpIWk1uNmprRTdhTUdoNE43UzAxMEV1ZWpWRVFaano5TyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6ODU6Imh0dHBzOi8vYmV0YS1tZWRpYS5ydW5uaW5nY29ubmVjdC5jb20vZXZlbnQvVEhFS09QMjAxOT9wYWdlPTUmcT0lMkZldmVudCUyRlRIRUtPUDIwMTkiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1744919372, '', '172.31.36.200', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'UHzStfha178PcGPRw5vrRqAKcNteqeRyRNvtczrh')

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

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

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

Metadata
Bindings	0. UHzStfha178PcGPRw5vrRqAKcNteqeRyRNvtczrh
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: rhhGtXxjHZMn6jkE7aMGh4N7S010EuejVEQZjz9O
_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 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "x-amzn-trace-id" => array:1 [▶
    0 => "Root=1-68015b4c-7e87477f0e2afe33267d973d"
  ]
  "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.220.7.194"
  ]
  "content-length" => array:1 [▶
    0 => ""
  ]
  "content-type" => array:1 [▶
    0 => ""
  ]
]

request_server

  0 of 0   
array:45 [▶
  "USER" => "nginx"
  "HOME" => "/var/lib/nginx"
  "HTTP_PRIORITY" => "u=0, i"
  "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd"
  "HTTP_SEC_FETCH_DEST" => "document"
  "HTTP_SEC_FETCH_USER" => "?1"
  "HTTP_SEC_FETCH_MODE" => "navigate"
  "HTTP_SEC_FETCH_SITE" => "none"
  "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "HTTP_UPGRADE_INSECURE_REQUESTS" => "1"
  "HTTP_SEC_CH_UA_PLATFORM" => ""Windows""
  "HTTP_SEC_CH_UA_MOBILE" => "?0"
  "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_X_AMZN_TRACE_ID" => "Root=1-68015b4c-7e87477f0e2afe33267d973d"
  "HTTP_HOST" => "beta-media.runningconnect.com"
  "HTTP_X_FORWARDED_PORT" => "443"
  "HTTP_X_FORWARDED_PROTO" => "https"
  "HTTP_X_FORWARDED_FOR" => "18.220.7.194"
  "REDIRECT_STATUS" => "200"
  "SERVER_NAME" => "beta-www.runningconnect.com"
  "SERVER_PORT" => "443"
  "SERVER_ADDR" => "172.31.23.24"
  "REMOTE_PORT" => "62304"
  "REMOTE_ADDR" => "172.31.36.200"
  "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" => 1744919372.1874
  "REQUEST_TIME" => 1744919372
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▶
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Thu, 17 Apr 2025 19:49:32 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "locale=eyJpdiI6IkF1REwxcU51aFZuQ0cxT0Vwa25oMWc9PSIsInZhbHVlIjoiUkw1QUNFUGtrMjM5TjkzaXFUQTA1dz09IiwibWFjIjoiYzlmZTUzNzM1NzBiYmVkMGVkY2NiNzA4ODlmMzA5YzczMGI4ZTYxYzc0NTFkMDZkMDk5ZGVmYTlhMWYzNWMwMyJ9; expires=Tue, 16-Apr-2030 19:49:32 GMT; Max-Age=157680000; path=/; domain=runningconnect.com; httponly ◀locale=eyJpdiI6IkF1REwxcU51aFZuQ0cxT0Vwa25oMWc9PSIsInZhbHVlIjoiUkw1QUNFUGtrMjM5TjkzaXFUQTA1dz09IiwibWFjIjoiYzlmZTUzNzM1NzBiYmVkMGVkY2NiNzA4ODlmMzA5YzczMGI4ZTYxY ▶"
    1 => "laravel_session=eyJpdiI6IkpTWlwvWlYwcFYwenE5NXZJV0tmMGlRPT0iLCJ2YWx1ZSI6IlBVUVhVMEF5SkV1djRMQmF1d3FIK2xzb3hUblErbjVyRjJIYTNEYzdxZTZicWlYY280SkNYQnBNZDNUUDhVZ0JMY2dacUxXaXJLSzlQZGg4NkdrXC8xQT09IiwibWFjIjoiMDE0ZWRhMGMxOTQ5MzM2OGU2MjlkMjhlZjI1NGI5N2RkNDdlODhiNmYwN2IwMzA2MDgwMWMyYjcyN2IwOTAwOCJ9; expires=Thu, 17-Apr-2025 21:49:32 GMT; Max-Age=7200; path=/; domain=runningconnect.com; httponly ◀laravel_session=eyJpdiI6IkpTWlwvWlYwcFYwenE5NXZJV0tmMGlRPT0iLCJ2YWx1ZSI6IlBVUVhVMEF5SkV1djRMQmF1d3FIK2xzb3hUblErbjVyRjJIYTNEYzdxZTZicWlYY280SkNYQnBNZDNUUDhVZ0JM ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "locale=eyJpdiI6IkF1REwxcU51aFZuQ0cxT0Vwa25oMWc9PSIsInZhbHVlIjoiUkw1QUNFUGtrMjM5TjkzaXFUQTA1dz09IiwibWFjIjoiYzlmZTUzNzM1NzBiYmVkMGVkY2NiNzA4ODlmMzA5YzczMGI4ZTYxYzc0NTFkMDZkMDk5ZGVmYTlhMWYzNWMwMyJ9; expires=Tue, 16-Apr-2030 19:49:32 GMT; domain=runningconnect.com; path=/; httponly ◀locale=eyJpdiI6IkF1REwxcU51aFZuQ0cxT0Vwa25oMWc9PSIsInZhbHVlIjoiUkw1QUNFUGtrMjM5TjkzaXFUQTA1dz09IiwibWFjIjoiYzlmZTUzNzM1NzBiYmVkMGVkY2NiNzA4ODlmMzA5YzczMGI4ZTYxY ▶"
    1 => "laravel_session=eyJpdiI6IkpTWlwvWlYwcFYwenE5NXZJV0tmMGlRPT0iLCJ2YWx1ZSI6IlBVUVhVMEF5SkV1djRMQmF1d3FIK2xzb3hUblErbjVyRjJIYTNEYzdxZTZicWlYY280SkNYQnBNZDNUUDhVZ0JMY2dacUxXaXJLSzlQZGg4NkdrXC8xQT09IiwibWFjIjoiMDE0ZWRhMGMxOTQ5MzM2OGU2MjlkMjhlZjI1NGI5N2RkNDdlODhiNmYwN2IwMzA2MDgwMWMyYjcyN2IwOTAwOCJ9; expires=Thu, 17-Apr-2025 21:49:32 GMT; domain=runningconnect.com; path=/; httponly ◀laravel_session=eyJpdiI6IkpTWlwvWlYwcFYwenE5NXZJV0tmMGlRPT0iLCJ2YWx1ZSI6IlBVUVhVMEF5SkV1djRMQmF1d3FIK2xzb3hUblErbjVyRjJIYTNEYzdxZTZicWlYY280SkNYQnBNZDNUUDhVZ0JM ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▶
  "_token" => "rhhGtXxjHZMn6jkE7aMGh4N7S010EuejVEQZjz9O"
  "_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 (83.24%)	616ms
1 x Booting (16.75%)	124ms