https://share-nude.com/load-more-videos/2

Query Metrics

3 Database Queries
3 Different statements
140.77 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
64.14 ms
(45.57%)
1
SELECT DISTINCT v0_.id AS id_0, v0_.created_at AS created_at_1 FROM video v0_ INNER JOIN influencer i1_ ON v0_.influencer_id = i1_.id WHERE v0_.actif = ? ORDER BY v0_.created_at DESC LIMIT 22 OFFSET 22
Parameters:
[
  1
]
61.78 ms
(43.89%)
1
SELECT count(DISTINCT v0_.id) AS sclr_0 FROM video v0_ INNER JOIN influencer i1_ ON v0_.influencer_id = i1_.id WHERE v0_.actif = ?
Parameters:
[
  1
]
14.85 ms
(10.55%)
1
SELECT v0_.id AS id_0, v0_.slug AS slug_1, v0_.views AS views_2, v0_.created_at AS created_at_3, i1_.name AS name_4, i1_.slug AS slug_5, v0_.webp AS webp_6, v0_.preview_url AS preview_url_7 FROM video v0_ INNER JOIN influencer i1_ ON v0_.influencer_id = i1_.id WHERE v0_.actif = ? AND v0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY v0_.created_at DESC
Parameters:
[
  1
  11044
  11043
  11042
  11041
  11040
  11039
  11038
  11037
  11036
  11035
  11034
  11033
  11032
  11030
  11031
  11029
  11028
  11027
  11026
  11025
  11023
  11024
]

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\Video No 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.