GET https://femboyparadise.com/post/uwu-3

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
16.75 ms
(92.13%)
1
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:
[
  "uwu-3"
]
0.24 ms
(1.34%)
1
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:
[
  "2025-12-21 19:19:36"
]
0.20 ms
(1.09%)
1
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:
[
  "2025-12-21 19:19:36"
]
0.16 ms
(0.86%)
1
UPDATE post SET views = ? WHERE id = ?
Parameters:
[
  425
  15
]
0.16 ms
(0.85%)
1
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:
[
  15
]
0.14 ms
(0.79%)
1
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
]
0.14 ms
(0.78%)
1
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:
[
  15
]
0.13 ms
(0.72%)
1
SELECT COUNT(f0_.id) AS sclr_0 FROM follow f0_ WHERE f0_.type = ? AND f0_.target_id = ?
Parameters:
[
  "user"
  5
]
0.10 ms
(0.58%)
1
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:
[
  15
]
0.09 ms
(0.48%)
1
"START TRANSACTION"
Parameters:
[]
0.07 ms
(0.38%)
1
"COMMIT"
Parameters:
[]

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.