select `posts`.*, (selectcount(*) from `post_seasons` where `posts`.`id` = `post_seasons`.`post_id`) as `seasons_count` from `posts` where `slug` ='your-friendly-neighborhood-spider-man'and `status` ='publish'and `type` ='tv' limit 1
select `genres`.*, `post_genres`.`post_id` as `pivot_post_id`, `post_genres`.`genre_id` as `pivot_genre_id` from `genres` innerjoin `post_genres` on `genres`.`id` = `post_genres`.`genre_id` where `post_genres`.`post_id` =44566
select `peoples`.*, `post_peoples`.`post_id` as `pivot_post_id`, `post_peoples`.`people_id` as `pivot_people_id` from `peoples` innerjoin `post_peoples` on `peoples`.`id` = `post_peoples`.`people_id` where `post_peoples`.`post_id` =44566
selectcount(*) as aggregate from `reactions` where `reactions`.`reactable_type` ='App\\Models\\Post'and `reactions`.`reactable_id` =44566and `reactions`.`reactable_id` isnotnulland `reaction` ='like'
selectcount(*) as aggregate from `reactions` where `reactions`.`reactable_type` ='App\\Models\\Post'and `reactions`.`reactable_id` =44566and `reactions`.`reactable_id` isnotnulland `reaction` ='dislike'
select `tags`.*, `post_tags`.`post_id` as `pivot_post_id`, `post_tags`.`tagged_id` as `pivot_tagged_id` from `tags` innerjoin `post_tags` on `tags`.`id` = `post_tags`.`tagged_id` where `post_tags`.`post_id` =44566
select `genres`.*, `post_genres`.`post_id` as `pivot_post_id`, `post_genres`.`genre_id` as `pivot_genre_id` from `genres` innerjoin `post_genres` on `genres`.`id` = `post_genres`.`genre_id` where `post_genres`.`post_id` =44546
select `genres`.*, `post_genres`.`post_id` as `pivot_post_id`, `post_genres`.`genre_id` as `pivot_genre_id` from `genres` innerjoin `post_genres` on `genres`.`id` = `post_genres`.`genre_id` where `post_genres`.`post_id` =42489
select `genres`.*, `post_genres`.`post_id` as `pivot_post_id`, `post_genres`.`genre_id` as `pivot_genre_id` from `genres` innerjoin `post_genres` on `genres`.`id` = `post_genres`.`genre_id` where `post_genres`.`post_id` =42469
select `genres`.*, `post_genres`.`post_id` as `pivot_post_id`, `post_genres`.`genre_id` as `pivot_genre_id` from `genres` innerjoin `post_genres` on `genres`.`id` = `post_genres`.`genre_id` where `post_genres`.`post_id` =40521
select `genres`.*, `post_genres`.`post_id` as `pivot_post_id`, `post_genres`.`genre_id` as `pivot_genre_id` from `genres` innerjoin `post_genres` on `genres`.`id` = `post_genres`.`genre_id` where `post_genres`.`post_id` =41881
select `genres`.*, `post_genres`.`post_id` as `pivot_post_id`, `post_genres`.`genre_id` as `pivot_genre_id` from `genres` innerjoin `post_genres` on `genres`.`id` = `post_genres`.`genre_id` where `post_genres`.`post_id` =39442
select `genres`.*, `post_genres`.`post_id` as `pivot_post_id`, `post_genres`.`genre_id` as `pivot_genre_id` from `genres` innerjoin `post_genres` on `genres`.`id` = `post_genres`.`genre_id` where `post_genres`.`post_id` =39955
select `genres`.*, `post_genres`.`post_id` as `pivot_post_id`, `post_genres`.`genre_id` as `pivot_genre_id` from `genres` innerjoin `post_genres` on `genres`.`id` = `post_genres`.`genre_id` where `post_genres`.`post_id` =43643