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` ='pop')2.42ms/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 (58, 68)4.47ms/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` =68and `photos`.`is_primary` ='1' limit 14.45ms/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` =682.75msview::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` =58and `photos`.`is_primary` ='1' limit 14.77ms/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` =583.41msview::series.single:116dev_events_tracker