selectcount(*) as aggregate from `series` leftjoin `event_types` on `series`.`event_type_id` = `event_types`.`id` leftjoin `visibilities` on `series`.`visibility_id` = `visibilities`.`id` leftjoin `occurrence_types` on `series`.`occurrence_type_id` = `occurrence_types`.`id` whereexists (select*from `tags` innerjoin `series_tag` on `tags`.`id` = `series_tag`.`tag_id` where `series`.`id` = `series_tag`.`series_id` and `slug` ='reggae')8.93ms/app/Http/Controllers/SeriesController.php:553dev_events_tracker
select `tags`.*, `series_tag`.`series_id` as `pivot_series_id`, `series_tag`.`tag_id` as `pivot_tag_id`, `series_tag`.`created_at` as `pivot_created_at`, `series_tag`.`updated_at` as `pivot_updated_at` from `tags` innerjoin `series_tag` on `tags`.`id` = `series_tag`.`tag_id` where `series_tag`.`series_id` in (56, 70)3.92ms/app/Http/Controllers/SeriesController.php:553dev_events_tracker
select `photos`.*, `photo_series`.`series_id` as `pivot_series_id`, `photo_series`.`photo_id` as `pivot_photo_id`, `photo_series`.`created_at` as `pivot_created_at`, `photo_series`.`updated_at` as `pivot_updated_at` from `photos` innerjoin `photo_series` on `photos`.`id` = `photo_series`.`photo_id` where `photo_series`.`series_id` =56and `photos`.`is_primary` ='1' limit 16.03ms/app/Models/Series.php:791dev_events_tracker
select `entities`.*, `entity_series`.`series_id` as `pivot_series_id`, `entity_series`.`entity_id` as `pivot_entity_id`, `entity_series`.`created_at` as `pivot_created_at`, `entity_series`.`updated_at` as `pivot_updated_at` from `entities` innerjoin `entity_series` on `entities`.`id` = `entity_series`.`entity_id` where `entity_series`.`series_id` =563.28msview::series.single:116dev_events_tracker
select `photos`.*, `photo_series`.`series_id` as `pivot_series_id`, `photo_series`.`photo_id` as `pivot_photo_id`, `photo_series`.`created_at` as `pivot_created_at`, `photo_series`.`updated_at` as `pivot_updated_at` from `photos` innerjoin `photo_series` on `photos`.`id` = `photo_series`.`photo_id` where `photo_series`.`series_id` =70and `photos`.`is_primary` ='1' limit 11.61ms/app/Models/Series.php:791dev_events_tracker
select `entities`.*, `entity_series`.`series_id` as `pivot_series_id`, `entity_series`.`entity_id` as `pivot_entity_id`, `entity_series`.`created_at` as `pivot_created_at`, `entity_series`.`updated_at` as `pivot_updated_at` from `entities` innerjoin `entity_series` on `entities`.`id` = `entity_series`.`entity_id` where `entity_series`.`series_id` =7010.59msview::series.single:116dev_events_tracker