Query Metrics
10
Database Queries
4
Different statements
3.14 ms
Query time
0
Invalid entities
34
Managed entities
Queries
refuge connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.35 ms |
SELECT MAX(t0_.effective_from) AS sclr_0 FROM tarif t0_ WHERE t0_.effective_from <= ?
Parameters:
[
"2026-02-16 05:05:44"
]
|
| 2 | 0.31 ms |
SELECT MIN(t0_.effective_from) AS sclr_0 FROM tarif t0_ WHERE t0_.effective_from > ?
Parameters:
[
"2026-02-16 05:05:44"
]
|
| 3 | 0.29 ms |
SELECT t0.id AS id_1, t0.tarif_key AS tarif_key_2, t0.category AS category_3, t0.label AS label_4, t0.amount AS amount_5, t0.effective_from AS effective_from_6, t0.display_order AS display_order_7 FROM tarif t0 WHERE t0.effective_from = ? AND t0.category = ? ORDER BY t0.category ASC, t0.display_order ASC
Parameters:
[ "2026-01-29 00:00:00" "PUBLIC" ] |
| 4 | 0.19 ms |
SELECT t0.id AS id_1, t0.tarif_key AS tarif_key_2, t0.category AS category_3, t0.label AS label_4, t0.amount AS amount_5, t0.effective_from AS effective_from_6, t0.display_order AS display_order_7 FROM tarif t0 WHERE t0.effective_from = ? AND t0.category = ? ORDER BY t0.category ASC, t0.display_order ASC
Parameters:
[ "2026-01-29 00:00:00" "FFCAM" ] |
| 5 | 0.15 ms |
SELECT MAX(t0_.effective_from) AS sclr_0 FROM tarif t0_ WHERE t0_.effective_from <= ?
Parameters:
[
"2026-02-16 05:05:44"
]
|
| 6 | 0.18 ms |
SELECT DISTINCT t0_.effective_from AS effective_from_0 FROM tarif t0_ WHERE t0_.effective_from < ? ORDER BY t0_.effective_from DESC
Parameters:
[
"2026-01-29 00:00:00"
]
|
| 7 | 0.20 ms |
SELECT t0.id AS id_1, t0.tarif_key AS tarif_key_2, t0.category AS category_3, t0.label AS label_4, t0.amount AS amount_5, t0.effective_from AS effective_from_6, t0.display_order AS display_order_7 FROM tarif t0 WHERE t0.effective_from = ? AND t0.category = ? ORDER BY t0.category ASC, t0.display_order ASC
Parameters:
[ "2025-11-29 00:00:00" "PUBLIC" ] |
| 8 | 0.16 ms |
SELECT t0.id AS id_1, t0.tarif_key AS tarif_key_2, t0.category AS category_3, t0.label AS label_4, t0.amount AS amount_5, t0.effective_from AS effective_from_6, t0.display_order AS display_order_7 FROM tarif t0 WHERE t0.effective_from = ? AND t0.category = ? ORDER BY t0.category ASC, t0.display_order ASC
Parameters:
[ "2025-11-29 00:00:00" "FFCAM" ] |
| 9 | 0.16 ms |
SELECT t0.id AS id_1, t0.tarif_key AS tarif_key_2, t0.category AS category_3, t0.label AS label_4, t0.amount AS amount_5, t0.effective_from AS effective_from_6, t0.display_order AS display_order_7 FROM tarif t0 WHERE t0.effective_from = ? AND t0.category = ? ORDER BY t0.category ASC, t0.display_order ASC
Parameters:
[ "2025-01-01 00:00:00" "PUBLIC" ] |
| 10 | 0.16 ms |
SELECT t0.id AS id_1, t0.tarif_key AS tarif_key_2, t0.category AS category_3, t0.label AS label_4, t0.amount AS amount_5, t0.effective_from AS effective_from_6, t0.display_order AS display_order_7 FROM tarif t0 WHERE t0.effective_from = ? AND t0.category = ? ORDER BY t0.category ASC, t0.display_order ASC
Parameters:
[ "2025-01-01 00:00:00" "FFCAM" ] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| refuge | doctrine.dbal.refuge_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| refuge | doctrine.orm.refuge_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|
refuge entity manager
| Class | Amount of managed objects |
|---|---|
| App\Refuge\Entity\Tarif | 34 |
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Supervisor | No errors. |
refuge entity manager
| Class | Mapping errors |
|---|---|
| App\Refuge\Entity\Tarif | No errors. |