Query Metrics
5
Database Queries
5
Different statements
1.64 ms
Query time
0
Invalid entities
Queries
| #▲ | 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. |