https://tsiory-portfolio-ailesdorees.karama.io/blog/

Query Metrics

5 Database Queries
5 Different statements
3.20 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
1.02 ms
(31.74%)
1
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:
[]
0.76 ms
(23.78%)
1
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:
[]
0.59 ms
(18.29%)
1
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
Parameters:
[]
0.45 ms
(13.99%)
1
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:
[]
0.39 ms
(12.20%)
1
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:
[]

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\CategorieBlog No errors.
App\Entity\TagBlog No errors.
App\Entity\Blog No errors.
App\Entity\User No errors.
App\Entity\Categorie No errors.
App\Entity\BlogTagBlog No errors.
App\Entity\Prestation No errors.