GET https://femboyparadise.com/post/chastity

Query Metrics

11 Database Queries
11 Different statements
8.28 ms Query time
1 Invalid entities
5 Managed entities

Queries

Group similar statements

# Time Info
1 6.50 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.caption AS caption_4, t0.upload_date AS upload_date_5, t0.deleted_date AS deleted_date_6, t0.views AS views_7, t0.type AS type_8, t0.video_guid AS video_guid_9, t0.video_duration AS video_duration_10, t0.video_thumbnail AS video_thumbnail_11, t0.likes AS likes_12, t0.slug AS slug_13, t0.redgif_id AS redgif_id_14, t0.rating AS rating_15, t0.user_id AS user_id_16 FROM post t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "chastity"
]
2 0.11 ms
"START TRANSACTION"
Parameters:
[]
3 0.22 ms
UPDATE post SET views = ? WHERE id = ?
Parameters:
[
  22
  25
]
4 0.09 ms
"COMMIT"
Parameters:
[]
5 0.29 ms
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.image AS image_2, p0_.caption AS caption_3, p0_.upload_date AS upload_date_4, p0_.deleted_date AS deleted_date_5, p0_.views AS views_6, p0_.type AS type_7, p0_.video_guid AS video_guid_8, p0_.video_duration AS video_duration_9, p0_.video_thumbnail AS video_thumbnail_10, p0_.likes AS likes_11, p0_.slug AS slug_12, p0_.redgif_id AS redgif_id_13, p0_.rating AS rating_14, p0_.user_id AS user_id_15 FROM post p0_ LEFT JOIN `user` u1_ ON p0_.user_id = u1_.id WHERE p0_.upload_date < ? AND p0_.deleted_date IS NULL AND u1_.is_active = 1 ORDER BY p0_.upload_date DESC LIMIT 1
Parameters:
[
  "2026-04-09 21:11:24"
]
6 0.24 ms
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.image AS image_2, p0_.caption AS caption_3, p0_.upload_date AS upload_date_4, p0_.deleted_date AS deleted_date_5, p0_.views AS views_6, p0_.type AS type_7, p0_.video_guid AS video_guid_8, p0_.video_duration AS video_duration_9, p0_.video_thumbnail AS video_thumbnail_10, p0_.likes AS likes_11, p0_.slug AS slug_12, p0_.redgif_id AS redgif_id_13, p0_.rating AS rating_14, p0_.user_id AS user_id_15 FROM post p0_ LEFT JOIN `user` u1_ ON p0_.user_id = u1_.id WHERE p0_.upload_date > ? AND p0_.deleted_date IS NULL AND u1_.is_active = 1 ORDER BY p0_.upload_date ASC LIMIT 1
Parameters:
[
  "2026-04-09 21:11:24"
]
7 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.popularity AS popularity_4, t0.last_used_at AS last_used_at_5, t0.category_id AS category_id_6 FROM tag t0 INNER JOIN post_tag ON t0.id = post_tag.tag_id WHERE post_tag.post_id = ?
Parameters:
[
  25
]
8 0.17 ms
SELECT COUNT(f0_.id) AS sclr_0 FROM follow f0_ WHERE f0_.type = ? AND f0_.target_id = ?
Parameters:
[
  "user"
  5
]
9 0.19 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.username AS username_5, t0.is_verified AS is_verified_6, t0.avatar AS avatar_7, t0.banner AS banner_8, t0.bio AS bio_9, t0.location AS location_10, t0.is_active AS is_active_11, t0.premium_until AS premium_until_12, t0.points AS points_13, t0.rank_id AS rank_id_14 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  5
]
10 0.16 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.post_id AS post_id_3, t0.user_id AS user_id_4 FROM post_like t0 WHERE t0.post_id = ?
Parameters:
[
  25
]
11 0.12 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.post_id AS post_id_4, t0.user_id AS user_id_5 FROM comment t0 WHERE t0.post_id = ?
Parameters:
[
  25
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Post 3
App\Entity\User 1
App\Entity\Rank 1

Entities Mapping

Class Mapping errors
App\Entity\Post No errors.
App\Entity\User
  • The field App\Entity\User#likedPostsCollection is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\PostLike#user does not contain the required 'inversedBy: "likedPostsCollection"' attribute.
App\Entity\PostLike No errors.
App\Entity\Comment No errors.
App\Entity\Tag No errors.
App\Entity\TagCategory No errors.
App\Entity\Follow No errors.
App\Entity\Rank No errors.