GET https://interface-bourg.1055.fr/reservations?all_days=1&direction=desc&page=5&sort=r.date_resa

Query Metrics

23 Database Queries
5 Different statements
15.02 ms Query time
0 Invalid entities

Queries

Group similar statements

reservation connection

# Time Info
1 0.47 ms
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
]
2 5.38 ms
SELECT COUNT(DISTINCT r0_.id) AS sclr_0 FROM `reservation` r0_ WHERE r0_.date_resa >= ?
Parameters:
[
  "2026-03-17 00:00:00"
]
3 5.65 ms
SELECT DISTINCT r0_.id AS id_0, r0_.date_resa AS date_resa_1 FROM `reservation` r0_ WHERE r0_.date_resa >= ? ORDER BY r0_.date_resa DESC LIMIT 19 OFFSET 76
Parameters:
[
  "2026-03-17 00:00:00"
]
4 0.56 ms
SELECT r0_.id AS id_0, r0_.customer_id AS customer_id_1, r0_.customer_number AS customer_number_2, r0_.formule AS formule_3, r0_.formule_code AS formule_code_4, r0_.firstname AS firstname_5, r0_.lastname AS lastname_6, r0_.company AS company_7, r0_.email AS email_8, r0_.phone AS phone_9, r0_.phone_mobile AS phone_mobile_10, r0_.billing_address AS billing_address_11, r0_.comment AS comment_12, r0_.date_add AS date_add_13, r0_.date_resa AS date_resa_14, r0_.numero_resa AS numero_resa_15, r0_.invoice_number AS invoice_number_16, r0_.sstotal_ht AS sstotal_ht_17, r0_.tva AS tva_18, r0_.total_ttc AS total_ttc_19, r0_.history AS history_20, r0_.date_upd AS date_upd_21, r0_.statut AS statut_22, r0_.active AS active_23, r0_.confirmation AS confirmation_24, r0_.deleted AS deleted_25, r0_.composted AS composted_26, r0_.ip AS ip_27, r0_.payment_id AS payment_id_28, r0_.child_name AS child_name_29, r0_.child_birthday AS child_birthday_30, r0_.child_age AS child_age_31, r0_.birthday_customer_comment AS birthday_customer_comment_32 FROM `reservation` r0_ WHERE r0_.date_resa >= ? AND r0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY r0_.date_resa DESC
Parameters:
[
  "2026-03-17 00:00:00"
  30841
  30807
  30870
  30777
  30846
  30544
  30799
  30756
  30787
  30812
  30845
  30869
  30622
  30542
  30828
  30351
  30711
  30699
  30783
]
5 0.29 ms
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:
[
  30807
]
6 0.21 ms
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:
[
  30841
]
7 0.21 ms
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:
[
  30777
]
8 0.21 ms
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:
[
  30870
]
9 0.21 ms
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:
[
  30756
]
10 0.16 ms
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:
[
  30787
]
11 0.17 ms
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:
[
  30542
]
12 0.16 ms
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:
[
  30799
]
13 0.10 ms
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:
[
  30544
]
14 0.12 ms
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:
[
  30812
]
15 0.09 ms
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:
[
  30845
]
16 0.15 ms
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:
[
  30846
]
17 0.15 ms
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:
[
  30869
]
18 0.16 ms
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:
[
  30622
]
19 0.16 ms
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:
[
  30828
]
20 0.16 ms
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:
[
  30351
]
21 0.09 ms
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:
[
  30699
]
22 0.09 ms
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:
[
  30711
]
23 0.09 ms
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:
[
  30783
]

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.