http://ancien.ailes-dorees.com/blog/?page=5

Query Metrics

7 Database Queries
7 Different statements
46.59 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 31.83 ms
SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.statut AS statut_2 FROM categorie_blog c0_ WHERE c0_.statut <> 0
Parameters:
[]
2 1.93 ms
SELECT t0_.id AS id_0, t0_.nom AS nom_1, t0_.statut AS statut_2 FROM tag_blog t0_ WHERE t0_.statut <> 0
Parameters:
[]
3 7.83 ms
SELECT count(DISTINCT b0_.id) AS sclr_0 FROM blog b0_ INNER JOIN categorie_blog c1_ ON b0_.categorie_id = c1_.id INNER JOIN user u2_ ON b0_.auteur_id = u2_.id WHERE 1 < 2 AND b0_.statut <> 0
Parameters:
[]
4 1.05 ms
SELECT DISTINCT b0_.id AS id_0, b0_.date_publication AS date_publication_1 FROM blog b0_ INNER JOIN categorie_blog c1_ ON b0_.categorie_id = c1_.id INNER JOIN user u2_ ON b0_.auteur_id = u2_.id WHERE 1 < 2 AND b0_.statut <> 0 ORDER BY b0_.date_publication DESC LIMIT 9 OFFSET 36
Parameters:
[]
5 1.55 ms
SELECT b0_.id AS id_0, b0_.titre AS titre_1, b0_.image AS image_2, b0_.description AS description_3, b0_.date_publication AS date_publication_4, b0_.nom_auteur AS nom_auteur_5, b0_.contenu AS contenu_6, b0_.statut AS statut_7, b0_.metatitle AS metatitle_8, b0_.metadescription AS metadescription_9, b0_.auteur_id AS auteur_id_10, b0_.categorie_id AS categorie_id_11 FROM blog b0_ INNER JOIN categorie_blog c1_ ON b0_.categorie_id = c1_.id INNER JOIN user u2_ ON b0_.auteur_id = u2_.id WHERE 1 < 2 AND b0_.statut <> 0 AND b0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY b0_.date_publication DESC
Parameters:
[
  67
  66
  65
  64
  63
  62
  61
  60
  59
]
6 0.39 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.statut AS statut_3 FROM categorie_blog t0 WHERE t0.id = ?
Parameters:
[
  1
]
7 2.00 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.statut AS statut_3, t0.notes AS notes_4, t0.details AS details_5 FROM categorie t0
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.

Entities Mapping