GET https://cookbook.ekaterinalecam.com/categories/4

Query Metrics

8 Database Queries
5 Different statements
70.81 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 69.32 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM categorie t0 WHERE t0.id = ?
Parameters:
[
  "4"
]
2 0.29 ms
SELECT COUNT(DISTINCT r0_.id) AS sclr_0 FROM recette r0_ WHERE r0_.categorie_id = ?
Parameters:
[
  4
]
3 0.25 ms
SELECT DISTINCT r0_.id AS id_0 FROM recette r0_ WHERE r0_.categorie_id = ? LIMIT 10
Parameters:
[
  4
]
4 0.29 ms
SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.preparation AS preparation_2, r0_.cuisson AS cuisson_3, r0_.repos AS repos_4, r0_.pays AS pays_5, r0_.instruction AS instruction_6, r0_.brouillon AS brouillon_7, r0_.image AS image_8, r0_.created_at AS created_at_9, r0_.updated_at AS updated_at_10, r0_.slug AS slug_11, r0_.portion AS portion_12, r0_.categorie_id AS categorie_id_13 FROM recette r0_ WHERE r0_.categorie_id = ? AND r0_.id IN (?, ?, ?, ?)
Parameters:
[
  4
  1
  6
  7
  8
]
5 0.22 ms
SELECT t0.id AS id_1, t0.etoile AS etoile_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.recette_id AS recette_id_5, t0.auteur_id AS auteur_id_6 FROM note t0 WHERE t0.recette_id = ?
Parameters:
[
  1
]
6 0.17 ms
SELECT t0.id AS id_1, t0.etoile AS etoile_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.recette_id AS recette_id_5, t0.auteur_id AS auteur_id_6 FROM note t0 WHERE t0.recette_id = ?
Parameters:
[
  6
]
7 0.14 ms
SELECT t0.id AS id_1, t0.etoile AS etoile_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.recette_id AS recette_id_5, t0.auteur_id AS auteur_id_6 FROM note t0 WHERE t0.recette_id = ?
Parameters:
[
  7
]
8 0.14 ms
SELECT t0.id AS id_1, t0.etoile AS etoile_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.recette_id AS recette_id_5, t0.auteur_id AS auteur_id_6 FROM note t0 WHERE t0.recette_id = ?
Parameters:
[
  8
]

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\Categorie No errors.
App\Entity\Recette No errors.
App\Entity\Note No errors.
App\Entity\Commentaire No errors.
App\Entity\Ingredient No errors.
App\Entity\Mesure No errors.
App\Entity\Utilisateur No errors.