selectMIN(shot_at) as min_date, MAX(shot_at) as max_date from `media` where `status` ='completed'and `event_id` =43and `media`.`deleted_at` isnull limit 158.14ms/app/Http/Controllers/Media/EventController.php:287runningconnect
select*from `media_price` whereexists (select*from `media_setting` where `media_price`.`media_setting_id` = `media_setting`.`id` and `event_id` =43and `media_setting`.`deleted_at` isnull) and `user_id` in (1984, 1, 1987, 117131) and `media_price`.`deleted_at` isnull6.72ms/app/Http/Controllers/Media/EventController.php:362runningconnect
deletefrom `cache` where `key` ='laravelTNT2018:count_completed'5.31ms/vendor/laravel/framework/src/Illuminate/Cache/DatabaseStore.php:216runningconnect
selectCOUNT(*) AS c from `media` where `type` ='video'and `media`.`status` ='completed'and `is_approved` =1and `media`.`event_id` =43and `media`.`deleted_at` isnull limit 11.62ms/app/Http/Controllers/Media/EventController.php:403runningconnect
select*from `media_runner` where `media_runner`.`media_id` in (0) and `media_runner`.`deleted_at` isnull1.07ms/app/Http/Controllers/Media/EventController.php:403runningconnect
selectCOUNT(*) AS c from `media` where `type` ='image'and `media`.`status` ='completed'and `is_approved` =1and `media`.`event_id` =43and `media`.`deleted_at` isnull limit 1141ms/app/Http/Controllers/Media/EventController.php:406runningconnect
select*from `media_runner` where `media_runner`.`media_id` in (0) and `media_runner`.`deleted_at` isnull830μs/app/Http/Controllers/Media/EventController.php:406runningconnect
select*from `users` where `users`.`id` in (1987) and `users`.`deleted_at` isnull1.01ms/app/Http/Controllers/Media/EventController.php:464runningconnect
select `id` from `events` where `events`.`id` in (43) and `events`.`deleted_at` isnull490μs/app/Http/Controllers/Media/EventController.php:464runningconnect
select `id`, `is_watermark`, `event_id`, `height`, `is_frame` from `media_setting` where `media_setting`.`event_id` in (43) and `is_buyable` =1and `media_setting`.`deleted_at` isnullorderby `media_setting`.`height` desc510μs/app/Http/Controllers/Media/EventController.php:464runningconnect