Query Metrics
5
Database Queries
5
Different statements
35.45 ms
Query time
0
Invalid entities
Grouped Statements
reservation connection
| Time▼ | Count | Info |
|---|---|---|
|
19.41 ms (54.76%) |
1 |
SELECT t0.id AS id_1, t0.customer_id AS customer_id_2, t0.customer_number AS customer_number_3, t0.formule AS formule_4, t0.formule_code AS formule_code_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.company AS company_8, t0.email AS email_9, t0.phone AS phone_10, t0.phone_mobile AS phone_mobile_11, t0.billing_address AS billing_address_12, t0.comment AS comment_13, t0.date_add AS date_add_14, t0.date_resa AS date_resa_15, t0.numero_resa AS numero_resa_16, t0.invoice_number AS invoice_number_17, t0.sstotal_ht AS sstotal_ht_18, t0.tva AS tva_19, t0.total_ttc AS total_ttc_20, t0.history AS history_21, t0.date_upd AS date_upd_22, t0.statut AS statut_23, t0.active AS active_24, t0.confirmation AS confirmation_25, t0.deleted AS deleted_26, t0.composted AS composted_27, t0.ip AS ip_28, t0.payment_id AS payment_id_29, t0.child_name AS child_name_30, t0.child_birthday AS child_birthday_31, t0.child_age AS child_age_32, t0.birthday_customer_comment AS birthday_customer_comment_33 FROM `reservation` t0 WHERE t0.numero_resa = ? LIMIT 1
Parameters:
[
"EQEJES"
]
|
|
13.48 ms (38.02%) |
1 |
"COMMIT"
Parameters:
[] |
|
1.94 ms (5.48%) |
1 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
9
]
|
|
0.49 ms (1.40%) |
1 |
UPDATE `reservation` SET history = ?, date_upd = ?, statut = ?, composted = ? WHERE id = ?
Parameters:
[
"""
Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0\n
--------------------------\n
17/04/2026 09:31:14 : Transaction créée (pay_4tuQhV0lUKrUaLgBTEn3QX)\n
17/04/2026 09:32:05 : Transaction réussie de 159,60 € (pay_4tuQhV0lUKrUaLgBTEn3QX)\n
17/04/2026 17:16:59 : Réservation confirmée\n
18/04/2026 14:43:33 : Réservation compostée\n
"""
"2026-04-18 14:43:33"
"Compostée"
1
30272
]
|
|
0.12 ms (0.34%) |
1 |
"START TRANSACTION"
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| reservation | doctrine.dbal.reservation_connection |
| customer | doctrine.dbal.customer_connection |
Entity Managers
| Name | Service |
|---|---|
| main | doctrine.orm.main_entity_manager |
| customer | doctrine.orm.customer_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
main entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Main\User | No errors. |
| App\Entity\Main\Reservation | No errors. |
| App\Entity\Main\History | No errors. |
| App\Entity\Main\ReservationDetails | No errors. |
| App\Entity\Main\BookedActivity | No errors. |
customer entity manager
No loaded entities.