GET https://bbernier.devlogiciel.com/actualites/categorie/1-Cat1%20label

Query Metrics

5 Database Queries
5 Different statements
3.23 ms Query time
0 Invalid entities
6 Managed entities

Queries

Group similar statements

# Time Info
1 1.36 ms
SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.title AS title_2, p0_.description AS description_3, p0_.content AS content_4, p0_.publication_date AS publication_date_5, p0_.visits_count AS visits_count_6, p0_.video_url AS video_url_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9, p0_.deleted_at AS deleted_at_10, p0_.deleted AS deleted_11, p0_.category AS category_12 FROM article_category a1_, page p0_ INNER JOIN article_category a2_ ON p0_.category = a2_.id WHERE a2_.id = ? ORDER BY p0_.publication_date DESC LIMIT 5
Parameters:
[
  1
]
2 0.51 ms
SELECT p0_.id AS id_0, p0_.is_enabled AS is_enabled_1, p0_.is_default AS is_default_2, p0_.created_at AS created_at_3, p0_.updated_at AS updated_at_4, p0_.deleted_at AS deleted_at_5, p0_.deleted AS deleted_6, p0_.original_filename AS original_filename_7, p0_.path AS path_8, p0_.mime_type AS mime_type_9, p0_.alt AS alt_10, p0_.size AS size_11, p0_.file_updated_at AS file_updated_at_12, p0_.page_id AS page_id_13 FROM page p1_, page_media p0_ WHERE p0_.page_id = ? AND p0_.is_enabled = true AND p0_.is_default = true LIMIT 1
Parameters:
[
  9
]
3 0.64 ms
SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.title AS title_2, p0_.description AS description_3, p0_.content AS content_4, p0_.publication_date AS publication_date_5, p0_.visits_count AS visits_count_6, p0_.video_url AS video_url_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9, p0_.deleted_at AS deleted_at_10, p0_.deleted AS deleted_11, p0_.category AS category_12 FROM page p0_ WHERE p0_.type = ? ORDER BY p0_.created_at DESC LIMIT 5
Parameters:
[
  "article"
]
4 0.45 ms
SELECT a0_.id AS id_0, a0_.label AS label_1, a0_.created_at AS created_at_2, a0_.updated_at AS updated_at_3, a0_.deleted_at AS deleted_at_4, a0_.deleted AS deleted_5, a0_.parent_category AS parent_category_6 FROM article_category a0_ WHERE a0_.parent_category IS NULL AND LOWER(a0_.label) <> ? ORDER BY a0_.label ASC
Parameters:
[
  "autre"
]
5 0.26 ms
SELECT a0_.id AS id_0, a0_.label AS label_1, a0_.created_at AS created_at_2, a0_.updated_at AS updated_at_3, a0_.deleted_at AS deleted_at_4, a0_.deleted AS deleted_5, a0_.parent_category AS parent_category_6 FROM article_category a0_ WHERE LOWER(a0_.label) = ? LIMIT 1
Parameters:
[
  "autre"
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Page\Page 3
App\Entity\Page\ArticleCategory 2
App\Entity\Page\Media 1

Entities Mapping

Class Mapping errors
App\Entity\Page\ArticleCategory No errors.
App\Entity\Page\Page No errors.
App\Entity\Page\Media No errors.