Query Metrics

5 Database Queries
5 Different statements
1.64 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.35 ms
SELECT m0_.id AS id_0, m0_.start_time AS start_time_1, m0_.end_time AS end_time_2, m0_.description AS description_3, m0_.is_active AS is_active_4 FROM maintenance_schedule m0_ WHERE m0_.is_active = ? AND m0_.start_time <= ? AND m0_.end_time >= ? ORDER BY m0_.end_time DESC LIMIT 1
Parameters:
[
  1
  "2026-02-15 09:22:38"
  "2026-02-15 09:22:38"
]
2 0.23 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.logo_path AS logo_path_3, t0.active AS active_4 FROM magasin t0
Parameters:
[]
3 0.22 ms
SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.tax AS tax_2 FROM category c0_
Parameters:
[]
4 0.56 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.product_name AS product_name_1, p0_.qtt AS qtt_2, p0_.prix AS prix_3, p0_.publish_item AS publish_item_4, p0_.promo AS promo_5, p0_.description AS description_6, p0_.publish_date AS publish_date_7, p0_.sale_price AS sale_price_8, p0_.cost_price AS cost_price_9, p0_.date_production AS date_production_10, p0_.date_expiration AS date_expiration_11, c1_.id AS id_12, c1_.nom AS nom_13, c1_.tax AS tax_14 FROM produit p0_ INNER JOIN category c1_ ON p0_.category_id = c1_.id WHERE p0_.publish_item = 1 OR ? = 1) dctrn_result) dctrn_table
Parameters:
[
  0
]
5 0.27 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.tax AS tax_3 FROM category t0 ORDER BY t0.nom ASC
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\MaintenanceSchedule No errors.
App\Entity\Category No errors.
App\Entity\Produit No errors.
App\Entity\Magasin No errors.
App\Entity\MagasinUser No errors.