Query Metrics

4 Database Queries
4 Different statements
78.95 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 20.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.locale AS locale_4, t0.parent_id AS parent_id_5 FROM categorie t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "journee"
  "fr"
]
2 21.19 ms
SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.summary AS summary_3, n0_.content AS content_4, n0_.content2 AS content2_5, n0_.nm AS nm_6, n0_.locale AS locale_7, n0_.aside AS aside_8, n0_.notes AS notes_9, n0_.mindate AS mindate_10, n0_.published_at AS published_at_11, n0_.active AS active_12, n0_.illustration AS illustration_13, n0_.illustration2 AS illustration2_14, n0_.illustration3 AS illustration3_15, c1_.id AS id_16, c1_.name AS name_17, c1_.slug AS slug_18, c1_.locale AS locale_19, n0_.user_id_id AS user_id_id_20, c1_.parent_id AS parent_id_21 FROM news_post n0_ INNER JOIN newsposts_categories n2_ ON n0_.id = n2_.news_post_id INNER JOIN categorie c1_ ON c1_.id = n2_.categorie_id WHERE c1_.slug = ? AND n0_.locale = ?
Parameters:
[
  "journee"
  "fr"
]
3 18.14 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.locale AS locale_4, t0.parent_id AS parent_id_5 FROM categorie t0 WHERE t0.locale = ?
Parameters:
[
  "fr"
]
4 19.21 ms
SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.summary AS summary_3, n0_.content AS content_4, n0_.content2 AS content2_5, n0_.nm AS nm_6, n0_.locale AS locale_7, n0_.aside AS aside_8, n0_.notes AS notes_9, n0_.mindate AS mindate_10, n0_.published_at AS published_at_11, n0_.active AS active_12, n0_.illustration AS illustration_13, n0_.illustration2 AS illustration2_14, n0_.illustration3 AS illustration3_15, n0_.user_id_id AS user_id_id_16 FROM news_post n0_ WHERE n0_.active = ? AND n0_.locale = ? ORDER BY n0_.nm DESC LIMIT 2
Parameters:
[
  1
  "fr"
]

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\Post No errors.
App\Entity\NewsPost No errors.
App\Entity\User No errors.