Query Metrics
7
Database Queries
7
Different statements
18.72 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 3.79 ms |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.image AS image_3, t0.description AS description_4, t0.date_publication AS date_publication_5, t0.nom_auteur AS nom_auteur_6, t0.contenu AS contenu_7, t0.statut AS statut_8, t0.metatitle AS metatitle_9, t0.metadescription AS metadescription_10, t0.auteur_id AS auteur_id_11, t0.categorie_id AS categorie_id_12 FROM blog t0 WHERE t0.id = ?
Parameters:
[
"57"
]
|
2 | 2.42 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:
[] |
3 | 2.57 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:
[] |
4 | 2.65 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_ WHERE b0_.statut <> 0 ORDER BY b0_.date_publication DESC LIMIT 5
Parameters:
[] |
5 | 2.03 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_ WHERE b0_.statut <> ? AND b0_.id <> ? ORDER BY b0_.date_publication DESC LIMIT 3
Parameters:
[ 0 57 ] |
6 | 2.53 ms |
SELECT t0.id AS id_1, t0.statut AS statut_2, t0.blog_id AS blog_id_3, t0.tag_id AS tag_id_4 FROM blog_tag_blog t0 WHERE t0.blog_id = ?
Parameters:
[
57
]
|
7 | 2.72 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
Class | Mapping errors |
---|---|
App\Entity\Blog | No errors. |
App\Entity\User | No errors. |
App\Entity\CategorieBlog | No errors. |
App\Entity\BlogTagBlog | No errors. |
App\Entity\TagBlog | No errors. |
App\Entity\Categorie | No errors. |
App\Entity\Prestation | No errors. |
App\Entity\OptionPrestation | No errors. |
App\Entity\PrestationTypeConsultation | No errors. |