https://www.staging.lacabaneacoudre.fr/patrons?category=2&level=difficile

Query Metrics

5 Database Queries
4 Different statements
1.83 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.87 ms
(47.68%)
2
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.level AS level_2, s0_.price_ht AS price_ht_3, s0_.tva AS tva_4, s0_.description AS description_5, s0_.picture AS picture_6, s0_.picture_alt AS picture_alt_7, s0_.published AS published_8, s0_.date_publication AS date_publication_9, s0_.file AS file_10, s0_.is_on_homepage AS is_on_homepage_11, s0_.is_physical AS is_physical_12, s0_.is_quantity AS is_quantity_13, s0_.category_id AS category_id_14 FROM sewing s0_ LEFT JOIN sewing_category s1_ ON s0_.category_id = s1_.id WHERE s0_.published = 1 AND s0_.date_publication <= CURRENT_DATE AND s1_.id = ? AND s0_.level = ?
Parameters:
[
  "2"
  3
]
0.61 ms
(33.43%)
1
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.level AS level_2, s0_.price_ht AS price_ht_3, s0_.tva AS tva_4, s0_.description AS description_5, s0_.picture AS picture_6, s0_.picture_alt AS picture_alt_7, s0_.published AS published_8, s0_.date_publication AS date_publication_9, s0_.file AS file_10, s0_.is_on_homepage AS is_on_homepage_11, s0_.is_physical AS is_physical_12, s0_.is_quantity AS is_quantity_13, s0_.category_id AS category_id_14 FROM sewing s0_ LEFT JOIN sewing_category s1_ ON s0_.category_id = s1_.id WHERE s0_.published = 1 AND s0_.date_publication <= CURRENT_DATE AND s1_.id = ? AND s0_.level = ? ORDER BY s0_.id DESC LIMIT 9
Parameters:
[
  "2"
  3
]
0.20 ms
(10.70%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.meta_description AS meta_description_3 FROM sewing_category t0
Parameters:
[]
0.15 ms
(8.19%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.published AS published_4, t0.date_publication AS date_publication_5 FROM notification t0 WHERE t0.published = ? ORDER BY t0.date_publication DESC
Parameters:
[
  1
]

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\Notification No errors.
App\Entity\User No errors.
App\Entity\Sewing No errors.
App\Entity\SewingCategory No errors.