GET http://elisebisschop.fr/fr/news/category/journee

Query Metrics

4 Database Queries
4 Different statements
78.95 ms Query time
1 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.
App\Entity\Keyword No errors.
App\Entity\Comment
  • The field App\Entity\Comment#comments is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Comment#comments does not contain the required 'mappedBy="comments"' attribute.
  • If association App\Entity\Comment#comments is many-to-one, then the inversed side App\Entity\Comment#comments has to be one-to-many.
App\Entity\JoinImagePost No errors.