GET https://preprod.postlab.fr/blog

Query Metrics

8 Database Queries
4 Different statements
2.66 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.00 ms
(37.58%)
3
SELECT t0.id AS id_1, t0.name AS name_2, t0.hide_description AS hide_description_3, t0.alt_text AS alt_text_4, t0.media_url AS media_url_5, t0.type AS type_6, t0.extension AS extension_7, t0.dimension AS dimension_8, t0.description AS description_9, t0.size AS size_10, t0.status AS status_11, t0.copyright AS copyright_12, t0.created_at AS created_at_13, t0.path AS path_14 FROM media t0 INNER JOIN media_article ON t0.id = media_article.media_id WHERE media_article.article_id = ?
Parameters:
[
  19
]
0.70 ms
(26.41%)
1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.status AS status_3, c0_.created_at AS created_at_4, a1_.id AS id_5, a1_.title AS title_6, a1_.content AS content_7, a1_.excerpt AS excerpt_8, a1_.created_at AS created_at_9, a1_.translation AS translation_10, a1_.slug AS slug_11, a1_.status AS status_12, a1_.subtitle AS subtitle_13, a1_.review AS review_14, a1_.front_image AS front_image_15, a1_.picture AS picture_16, c0_.parent_id AS parent_id_17, a1_.photo_auteur_id AS photo_auteur_id_18, a1_.image_avant_id AS image_avant_id_19 FROM category c0_ INNER JOIN category_article c2_ ON c0_.id = c2_.category_id INNER JOIN article a1_ ON a1_.id = c2_.article_id WHERE c0_.status = 'a:1:{s:9:\"published\";i:1;}'
Parameters:
[]
0.67 ms
(25.05%)
3
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.parent_id AS parent_id_6 FROM category t0 INNER JOIN category_article ON t0.id = category_article.category_id WHERE category_article.article_id = ?
Parameters:
[
  19
]
0.29 ms
(10.96%)
1
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.content AS content_2, a0_.excerpt AS excerpt_3, a0_.created_at AS created_at_4, a0_.translation AS translation_5, a0_.slug AS slug_6, a0_.status AS status_7, a0_.subtitle AS subtitle_8, a0_.review AS review_9, a0_.front_image AS front_image_10, a0_.picture AS picture_11, a0_.photo_auteur_id AS photo_auteur_id_12, a0_.image_avant_id AS image_avant_id_13 FROM article a0_ WHERE a0_.status = 'a:1:{s:9:\"published\";i:1;}'
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\Article No errors.
App\Entity\Media No errors.
App\Entity\Comment No errors.
App\Entity\User
  • The association App\Entity\User#calendars refers to the owning side field App\Entity\Calendar#user which does not exist.
  • The association App\Entity\User#events refers to the owning side field App\Entity\Calendar#users which does not exist.
  • The mappings App\Entity\User#owners and App\Entity\Calendar#owners are inconsistent with each other.
  • The mappings App\Entity\User#participants and App\Entity\Calendar#participants are inconsistent with each other.
App\Entity\Institution No errors.
App\Entity\Lab No errors.
App\Entity\License No errors.
App\Entity\Software No errors.
App\Entity\Training No errors.
App\Entity\Team No errors.
App\Entity\Page No errors.
App\Entity\Category No errors.
App\Entity\Keyword No errors.
App\Entity\Tag No errors.