GET https://interface-bourg.1055.fr/reservation/comfirm/MORKSW

Query Metrics

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

Grouped Statements

Show all queries

reservation connection

Time Count Info
14.71 ms
(48.05%)
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:
[
  "MORKSW"
]
13.04 ms
(42.59%)
1
"COMMIT"
Parameters:
[]
2.28 ms
(7.45%)
1
UPDATE `reservation` SET history = ?, date_upd = ?, statut = ?, confirmation = ? WHERE id = ?
Parameters:
[
  """
    \n
    --------------------------\n
    18/04/2026 08:31:59 : Demande de paiement par Carte 10 55\n
    18/04/2026 15:31:34 : Réservation confirmée\n
    """
  "2026-04-18 15:31:34"
  "Confirmée"
  1
  30284
]
0.46 ms
(1.51%)
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:
[
  14
]
0.12 ms
(0.40%)
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.