POST https://speeddating.scaouest.info/e/c36514850ac1437471b2d6e25a8209b8be3da21afdce0ecb/book/24663

Query Metrics

14 Database Queries
14 Different statements
8.53 ms Query time
0 Invalid entities
7 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
1.42 ms
(16.63%)
1
"COMMIT"
Parameters:
[]
0.68 ms
(8.00%)
1
SELECT a0_.id AS id_0, a0_.start_time AS start_time_1, a0_.created_at AS created_at_2, a0_.event_id AS event_id_3, a0_.slot_id AS slot_id_4, a0_.supplier_id AS supplier_id_5 FROM appointments a0_ INNER JOIN time_slots t1_ ON a0_.slot_id = t1_.id WHERE a0_.supplier_id = ? AND (t1_.start_time < ? AND t1_.end_time > ?)
Parameters:
[
  7
  "2026-11-17 14:28:00"
  "2026-11-17 14:20:00"
]
0.66 ms
(7.79%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM users t0 WHERE t0.id = ?
Parameters:
[
  6
]
0.65 ms
(7.66%)
1
SELECT t0.id AS id_1, t0.access_slug AS access_slug_2, t0.name AS name_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.default_slot_duration AS default_slot_duration_6, t0.status AS status_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.max_appointments_per_supplier AS max_appointments_per_supplier_10 FROM speed_dating_events t0 WHERE t0.access_slug = ? LIMIT 1
Parameters:
[
  "c36514850ac1437471b2d6e25a8209b8be3da21afdce0ecb"
]
0.62 ms
(7.32%)
1
SELECT a0_.id AS id_0, a0_.start_time AS start_time_1, a0_.created_at AS created_at_2, a0_.event_id AS event_id_3, a0_.slot_id AS slot_id_4, a0_.supplier_id AS supplier_id_5 FROM appointments a0_ INNER JOIN time_slots t1_ ON a0_.slot_id = t1_.id WHERE a0_.supplier_id = ? AND t1_.event_shop_id = ?
Parameters:
[
  7
  235
]
0.59 ms
(6.93%)
1
SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.initial_plain_password AS initial_plain_password_5, t0.event_id AS event_id_6, t0.user_id AS user_id_7 FROM suppliers t0 WHERE t0.user_id = ? AND t0.event_id = ? LIMIT 1
Parameters:
[
  6
  b"\x01¡ÀõÙ¨v×›\x02õ©íÌ]"
]
0.59 ms
(6.89%)
1
SELECT COUNT(a0_.id) AS sclr_0 FROM appointments a0_ WHERE a0_.supplier_id = ? AND a0_.event_id = ?
Parameters:
[
  7
  Symfony\Component\Uid\UuidV7 {#695
    __toString(): "01a1c0f5-d9a8-76d7-9b02-f5a9edcc5d81"
  }
]
0.53 ms
(6.20%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.user_id AS user_id_6 FROM shops t0 WHERE t0.id = ?
Parameters:
[
  85
]
0.51 ms
(6.02%)
1
DELETE FROM shop_holds WHERE event_shop_id = ? AND supplier_id = ?
Parameters:
[
  235
  7
]
0.49 ms
(5.73%)
1
INSERT INTO appointments (start_time, created_at, event_id, slot_id, supplier_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "2026-11-17 14:20:00"
  "2026-11-10 18:44:48"
  b"\x01¡ÀõÙ¨v×›\x02õ©íÌ]"
  24663
  7
]
0.48 ms
(5.63%)
1
SELECT t0.id AS id_1, t0.start_time AS start_time_2, t0.end_time AS end_time_3, t0.type AS type_4, t0.status AS status_5, t0.created_at AS created_at_6, t0.event_shop_id AS event_shop_id_7, t8.id AS id_9, t8.start_time AS start_time_10, t8.created_at AS created_at_11, t8.event_id AS event_id_12, t8.slot_id AS slot_id_13, t8.supplier_id AS supplier_id_14 FROM time_slots t0 LEFT JOIN appointments t8 ON t8.slot_id = t0.id WHERE t0.id = ?
Parameters:
[
  24663
]
0.46 ms
(5.44%)
1
SELECT t0.id AS id_1, t0.custom_slot_duration AS custom_slot_duration_2, t0.created_at AS created_at_3, t0.event_id AS event_id_4, t0.shop_id AS shop_id_5 FROM event_shops t0 WHERE t0.id = ?
Parameters:
[
  235
]
0.46 ms
(5.39%)
1
UPDATE time_slots SET status = ? WHERE id = ?
Parameters:
[
  "BOOKED"
  24663
]
0.37 ms
(4.36%)
1
"START TRANSACTION"
Parameters:
[]

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\User 1
App\Entity\SpeedDatingEvent 1
App\Entity\Supplier 1
App\Entity\TimeSlot 1
App\Entity\EventShop 1
App\Entity\Shop 1
App\Entity\Appointment 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\SpeedDatingEvent No errors.
App\Entity\EventShop No errors.
App\Entity\Supplier No errors.
App\Entity\EventDaySchedule No errors.
App\Entity\Appointment No errors.
App\Entity\TimeSlot No errors.
App\Entity\Shop No errors.