GET https://preprod.citizenj7-music.fr/shorts/catalogue?direction=desc&page=2

Query Metrics

7 Database Queries
5 Different statements
2.88 ms Query time
0 Invalid entities
23 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.50 ms
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.site_email AS site_email_3, t0.site_logo AS site_logo_4, t0.site_url AS site_url_5, t0.site_urlfull AS site_urlfull_6, t0.site_adresse AS site_adresse_7, t0.site_cp AS site_cp_8, t0.site_ville AS site_ville_9, t0.site_phone AS site_phone_10, t0.site_youtube AS site_youtube_11, t0.site_verset AS site_verset_12, t0.site_versetverse AS site_versetverse_13, t0.site_presentation AS site_presentation_14, t0.site_facebook AS site_facebook_15, t0.site_apropos AS site_apropos_16 FROM setting t0 LIMIT 1
Parameters:
[]
2 0.66 ms
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.path AS path_3, p0_.is_published AS is_published_4, b1_.id AS id_5, b1_.type AS type_6, b1_.content AS content_7, b1_.image AS image_8, b1_.section AS section_9, b1_.position AS position_10, b1_.page_id AS page_id_11 FROM page p0_ LEFT JOIN block b1_ ON p0_.id = b1_.page_id WHERE p0_.path = ? ORDER BY b1_.position ASC
Parameters:
[
  "/shorts/catalogue"
]
3 0.27 ms
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.site_email AS site_email_3, t0.site_logo AS site_logo_4, t0.site_url AS site_url_5, t0.site_urlfull AS site_urlfull_6, t0.site_adresse AS site_adresse_7, t0.site_cp AS site_cp_8, t0.site_ville AS site_ville_9, t0.site_phone AS site_phone_10, t0.site_youtube AS site_youtube_11, t0.site_verset AS site_verset_12, t0.site_versetverse AS site_versetverse_13, t0.site_presentation AS site_presentation_14, t0.site_facebook AS site_facebook_15, t0.site_apropos AS site_apropos_16 FROM setting t0 LIMIT 1
Parameters:
[]
4 0.33 ms
SELECT count(DISTINCT v0_.id) AS sclr_0 FROM video v0_ WHERE v0_.is_published = ? AND v0_.is_short = ?
Parameters:
[
  1
  1
]
5 0.35 ms
SELECT DISTINCT v0_.id AS id_0, v0_.youtube_published_at AS youtube_published_at_1 FROM video v0_ WHERE v0_.is_published = ? AND v0_.is_short = ? ORDER BY v0_.youtube_published_at DESC LIMIT 12 OFFSET 12
Parameters:
[
  1
  1
]
6 0.46 ms
SELECT v0_.id AS id_0, v0_.youtube_id AS youtube_id_1, v0_.title AS title_2, v0_.slug AS slug_3, v0_.description AS description_4, v0_.excerpt AS excerpt_5, v0_.youtube_published_at AS youtube_published_at_6, v0_.created_at AS created_at_7, v0_.updated_at AS updated_at_8, v0_.duration AS duration_9, v0_.is_published AS is_published_10, v0_.is_featured AS is_featured_11, v0_.video_type AS video_type_12, v0_.is_short AS is_short_13, v0_.music_style AS music_style_14, v0_.thumbnail_url AS thumbnail_url_15, v0_.view_count AS view_count_16, v0_.category_id AS category_id_17, v0_.parent_video_id AS parent_video_id_18, v0_.chant_id AS chant_id_19 FROM video v0_ WHERE v0_.is_published = ? AND v0_.is_short = ? AND v0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY v0_.youtube_published_at DESC
Parameters:
[
  1
  1
  59
  31
  18
  13
  9
  10
  11
  12
  14
  15
  41
  60
]
7 0.30 ms
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.site_email AS site_email_3, t0.site_logo AS site_logo_4, t0.site_url AS site_url_5, t0.site_urlfull AS site_urlfull_6, t0.site_adresse AS site_adresse_7, t0.site_cp AS site_cp_8, t0.site_ville AS site_ville_9, t0.site_phone AS site_phone_10, t0.site_youtube AS site_youtube_11, t0.site_verset AS site_verset_12, t0.site_versetverse AS site_versetverse_13, t0.site_presentation AS site_presentation_14, t0.site_facebook AS site_facebook_15, t0.site_apropos AS site_apropos_16 FROM setting t0 LIMIT 1
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\Video 15
App\Entity\Block 2
App\Entity\Category 2
App\Entity\Chant 2
App\Entity\Setting 1
App\Entity\Page 1

Entities Mapping

Class Mapping errors
App\Entity\Setting No errors.
App\Entity\Page No errors.
App\Entity\Block No errors.
App\Entity\Video No errors.
App\Entity\Category No errors.
App\Entity\Chant No errors.
App\Entity\Newsletter No errors.