Query Metrics
6
Database Queries
6
Different statements
15.15 ms
Query time
0
Invalid entities
Grouped Statements
reservation connection
| Time▼ | Count | Info |
|---|---|---|
|
14.13 ms (93.26%) |
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:
[
"DKGZEP"
]
|
|
0.25 ms (1.68%) |
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.22 ms (1.45%) |
1 |
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.forfait AS forfait_3, t0.formule AS formule_4, t0.code_activity AS code_activity_5, t0.date AS date_6, t0.creneau AS creneau_7, t0.nbre_parties AS nbre_parties_8, t0.quantity AS quantity_9, t0.pu_ttc AS pu_ttc_10, t0.taux_TVA AS taux_TVA_11, t0.total_ht AS total_ht_12, t0.montant_tva AS montant_tva_13, t0.total_ttc AS total_ttc_14, t0.reservation_id AS reservation_id_15 FROM `booked_activity` t0 WHERE t0.reservation_id = ? ORDER BY t0.creneau ASC
Parameters:
[
28389
]
|
|
0.22 ms (1.43%) |
1 |
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.code_activity AS code_activity_3, t0.date AS date_4, t0.creneau AS creneau_5, t0.quantity AS quantity_6, t0.pu_ttc AS pu_ttc_7, t0.taux_TVA AS taux_TVA_8, t0.total_ht AS total_ht_9, t0.montant_tva AS montant_tva_10, t0.total_ttc AS total_ttc_11, t0.reservation_id AS reservation_id_12, t0.parent_id AS parent_id_13 FROM `reservation_details` t0 WHERE t0.reservation_id = ?
Parameters:
[
28389
]
|
|
0.17 ms (1.10%) |
1 |
SELECT t0.id AS id_1, t0.customer_id AS customer_id_2, t0.date AS date_3, t0.information AS information_4, t0.mouvement AS mouvement_5, t0.reservation_id AS reservation_id_6 FROM `history` t0 WHERE t0.reservation_id = ?
Parameters:
[
28389
]
|
customer connection
| Time▼ | Count | Info |
|---|---|---|
|
0.16 ms (1.08%) |
1 |
SELECT t0.id AS id_1, t0.roles AS roles_2, t0.password AS password_3, t0.company AS company_4, t0.customer_number AS customer_number_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.email AS email_8, t0.phone AS phone_9, t0.phone_mobile AS phone_mobile_10, t0.address1 AS address1_11, t0.address2 AS address2_12, t0.postcode AS postcode_13, t0.city AS city_14, t0.country AS country_15, t0.birthday AS birthday_16, t0.solde AS solde_17, t0.date_add AS date_add_18, t0.date_upd AS date_upd_19, t0.comment AS comment_20, t0.statut AS statut_21, t0.active AS active_22, t0.deleted AS deleted_23, t0.reset_token AS reset_token_24 FROM `customer` t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
65281
]
|
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\ReservationDetails | No errors. |
| App\Entity\Main\BookedActivity | No errors. |
| App\Entity\Main\History | No errors. |
| App\Entity\Main\BookedActivityOptions | No errors. |
customer entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Customer\Customer | No errors. |