https://share-nude.com/i/chelxie

Query Metrics

8 Database Queries
8 Different statements
129.09 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
19.10 ms
(14.80%)
1
SELECT DISTINCT p0_.id AS id_0, p0_.created_at AS created_at_1 FROM photo p0_ INNER JOIN influencer i1_ ON p0_.influencer_id = i1_.id WHERE p0_.actif = ? AND i1_.id = ? GROUP BY p0_.id ORDER BY p0_.created_at DESC LIMIT 33
Parameters:
[
  1
  334
]
18.93 ms
(14.66%)
1
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.created_at AS created_at_3, t0.actif AS actif_4, t0.views AS views_5, t0.webp AS webp_6, t0.webp_large AS webp_large_7, t0.ip AS ip_8, t0.influencer_id AS influencer_id_9, t0.user_id AS user_id_10 FROM photo t0 WHERE t0.influencer_id = ?
Parameters:
[
  334
]
15.73 ms
(12.18%)
1
SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.views AS views_2, p0_.created_at AS created_at_3, p0_.webp AS webp_4, i1_.slug AS slug_5, i1_.name AS name_6 FROM photo p0_ INNER JOIN influencer i1_ ON p0_.influencer_id = i1_.id WHERE p0_.actif = ? AND i1_.id = ? AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY p0_.id ORDER BY p0_.created_at DESC
Parameters:
[
  1
  334
  32729
  29993
  42133
  40447
  39225
  38044
  36499
  36498
  36497
  32730
  30578
  30534
  29742
  29609
  28789
  28788
  28790
  28616
  26650
  26479
  26480
  26441
  24909
  24910
  23790
  23787
  23743
  23060
  23061
  21736
  21740
  21737
  21738
]
15.51 ms
(12.01%)
1
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM photo p0_ INNER JOIN influencer i1_ ON p0_.influencer_id = i1_.id WHERE p0_.actif = ? AND i1_.id = ? GROUP BY p0_.id
Parameters:
[
  1
  334
]
15.28 ms
(11.83%)
1
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.embed AS embed_3, t0.actif AS actif_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.description AS description_7, t0.views AS views_8, t0.uploaded AS uploaded_9, t0.filecode AS filecode_10, t0.webp AS webp_11, t0.preview_url AS preview_url_12, t0.ip AS ip_13, t0.influencer_id AS influencer_id_14, t0.user_id AS user_id_15 FROM video t0 WHERE t0.influencer_id = ?
Parameters:
[
  334
]
15.25 ms
(11.81%)
1
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.created_at AS created_at_3, t0.actif AS actif_4, t0.views AS views_5, t0.webp AS webp_6, t0.webp_large AS webp_large_7, t0.ip AS ip_8, t0.influencer_id AS influencer_id_9, t0.user_id AS user_id_10 FROM photo t0 WHERE t0.id = ?
Parameters:
[
  1399
]
14.84 ms
(11.50%)
1
SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.influencer_id AS influencer_id_3 FROM influencer_follower t0 WHERE t0.influencer_id = ?
Parameters:
[
  334
]
14.46 ms
(11.20%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.age AS age_5, t0.country AS country_6, t0.instagram AS instagram_7, t0.onlyfans AS onlyfans_8, t0.mym AS mym_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.actif AS actif_12, t0.chaturbate AS chaturbate_13, t0.stripchat AS stripchat_14, t0.fansly AS fansly_15, t0.patreon AS patreon_16, t0.swame AS swame_17, t0.main_photo_id AS main_photo_id_18 FROM influencer t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "chelxie"
]

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.

Entities Mapping

Class Mapping errors
App\Entity\Influencer
  • The association App\Entity\Influencer#comments refers to the owning side field App\Entity\Comment#influencer_id which does not exist.
App\Entity\Photo No errors.
App\Entity\InfluencerFollower No errors.
App\Entity\Comment
  • The mappings App\Entity\Comment#influencer and App\Entity\Influencer#comments are inconsistent with each other.
App\Entity\Video No errors.
App\Entity\User No errors.
App\Entity\PhotoLike No errors.