GET https://femboyparadise.com/user/UwUGurl

Query Metrics

19 Database Queries
7 Different statements
5.56 ms Query time
1 Invalid entities
29 Managed entities

Grouped Statements

Show all queries

Time Count Info
3.16 ms
(56.91%)
13
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:
[
  11
]
0.70 ms
(12.53%)
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, t1_.id AS id_15, t1_.name AS name_16, t1_.slug AS slug_17, t1_.popularity AS popularity_18, t1_.last_used_at AS last_used_at_19, p0_.user_id AS user_id_20, t1_.category_id AS category_id_21 FROM post p0_ LEFT JOIN post_tag p2_ ON p0_.id = p2_.post_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.user_id = ? AND p0_.deleted_date IS NULL ORDER BY p0_.upload_date DESC
Parameters:
[
  5
]
0.45 ms
(8.01%)
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.username = ? LIMIT 1
Parameters:
[
  "UwUGurl"
]
0.44 ms
(7.97%)
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.user_id = ?
Parameters:
[
  5
]
0.30 ms
(5.33%)
1
SELECT COUNT(f0_.id) AS sclr_0 FROM follow f0_ WHERE f0_.follower_id = ?
Parameters:
[
  5
]
0.29 ms
(5.29%)
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.user_id = ?
Parameters:
[
  5
]
0.22 ms
(3.96%)
1
SELECT COUNT(f0_.id) AS sclr_0 FROM follow f0_ WHERE f0_.type = ? AND f0_.target_id = ?
Parameters:
[
  "user"
  5
]

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 13
App\Entity\PostLike 8
App\Entity\Tag 5
App\Entity\User 2
App\Entity\Rank 1

Entities Mapping

Class Mapping 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\Rank No errors.
App\Entity\Post No errors.
App\Entity\PostLike No errors.
App\Entity\Tag No errors.
App\Entity\TagCategory No errors.
App\Entity\Comment No errors.
App\Entity\Follow No errors.