Query Metrics
11
Database Queries
5
Different statements
4.42 ms
Query time
0
Invalid entities
99
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.45 ms (55.44%) |
1 |
SELECT t0.id AS id_1, t0.year AS year_2, t0.date AS date_3, t0.heureDebut AS heureDebut_4, t0.duree AS duree_5, t0.heureFin AS heureFin_6, t0.type AS type_7, t0.jour AS jour_8, t0.complet AS complet_9, t0.caveau_id AS caveau_id_10, t0.chauffeur_id AS chauffeur_id_11 FROM dates_horaires t0 WHERE t0.type = ? AND t0.year = ? ORDER BY t0.date ASC, t0.heureDebut ASC
Parameters:
[ "Caveau" 2026 ] |
|
0.75 ms (17.02%) |
1 |
SELECT t0.id AS id_1, t0.year AS year_2, t0.low_start AS low_start_3, t0.low_end AS low_end_4, t0.high_start AS high_start_5, t0.high_end AS high_end_6, t0.caveau_start AS caveau_start_7, t0.caveau_end AS caveau_end_8, t0.day_low_lutry1 AS day_low_lutry1_9, t0.day_low_lutry2 AS day_low_lutry2_10, t0.day_high_lutry AS day_high_lutry_11, t0.day_low_cully AS day_low_cully_12, t0.day_high_cully1 AS day_high_cully1_13, t0.day_high_cully2 AS day_high_cully2_14, t0.day_caveau1 AS day_caveau1_15, t0.day_caveau2 AS day_caveau2_16, t0.day_caveau3 AS day_caveau3_17, t0.day_special_lutry AS day_special_lutry_18, t0.day_special_cully AS day_special_cully_19, t0.time_caveau AS time_caveau_20, t0.marche_start AS marche_start_21, t0.marche_end AS marche_end_22, t0.day_marche1 AS day_marche1_23, t0.time_marche AS time_marche_24, t0.marcheVillageois_start AS marcheVillageois_start_25, t0.marcheVillageois_end AS marcheVillageois_end_26, t0.day_marche_villageois AS day_marche_villageois_27, t0.time_marche_villageois AS time_marche_villageois_28, t0.apero_start AS apero_start_29, t0.apero_end AS apero_end_30, t0.day_apero AS day_apero_31, t0.time_apero AS time_apero_32 FROM seasons t0 WHERE t0.year = ? LIMIT 1
Parameters:
[
2026
]
|
|
0.57 ms (12.94%) |
3 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.type AS type_4 FROM options t0 WHERE t0.type = ?
Parameters:
[
"prix"
]
|
|
0.48 ms (10.89%) |
5 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3 FROM caveaux t0 WHERE t0.id = ?
Parameters:
[
7
]
|
|
0.16 ms (3.71%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.type AS type_4 FROM options t0 WHERE t0.name = ? AND t0.type = ? LIMIT 1
Parameters:
[ "public" "memo" ] |
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\DateHoraire | 58 |
| App\Entity\Parameter | 23 |
| App\Entity\User | 12 |
| App\Entity\Caveau | 5 |
| App\Entity\Season | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Season | No errors. |
| App\Entity\DateHoraire | No errors. |
| App\Entity\Caveau | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Parameter | No errors. |
| App\Entity\UserCategory | No errors. |
| App\Entity\UsefulLink | No errors. |
| App\Entity\Event | No errors. |
| App\Entity\Remuneration | No errors. |
| App\Entity\Member | No errors. |
| App\Entity\Question | No errors. |
| App\Entity\ResetPasswordRequest | No errors. |
| App\Entity\RemunerationCode | No errors. |
| App\Entity\Gallery | No errors. |
| App\Entity\Codes | No errors. |
| App\Entity\Reservation | No errors. |
| App\Entity\ReservationHoraire | No errors. |
| App\Entity\MailConfirmation | No errors. |
| App\Entity\Availability | No errors. |
| App\Entity\RemunerationLine | No errors. |
| App\Entity\PlanningLine | No errors. |
| App\Entity\PlanningLineUserRemuneration | No errors. |
| App\Entity\ReservationSpeciale | No errors. |
| App\Entity\DailyPlanning | No errors. |
| App\Entity\Photo | No errors. |
| Vich\UploaderBundle\Entity\File | No errors. |