Redirect 302 redirect from POST @supplier_book_slot (5b94bb)

Query Metrics

175 Database Queries
8 Different statements
40.35 ms Query time
0 Invalid entities
177 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
19.36 ms
(47.97%)
83
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:
[
  51
]
18.07 ms
(44.77%)
83
SELECT supplier_id, expires_at FROM shop_holds WHERE event_shop_id = ? AND expires_at > ?
Parameters:
[
  201
  "2026-11-10 17:24:20"
]
1.08 ms
(2.68%)
4
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:
[
  22919
]
0.42 ms
(1.05%)
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:
[
  103
]
0.41 ms
(1.01%)
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.37 ms
(0.92%)
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.event_id = ?
Parameters:
[
  b"\x01¡ÀõÙ¨v×›\x02õ©íÌ]"
]
0.35 ms
(0.86%)
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:
[
  103
  b"\x01¡ÀõÙ¨v×›\x02õ©íÌ]"
]
0.30 ms
(0.73%)
1
SELECT t0.id AS id_1, t0.start_time AS start_time_2, t0.created_at AS created_at_3, t0.event_id AS event_id_4, t0.slot_id AS slot_id_5, t0.supplier_id AS supplier_id_6 FROM appointments t0 WHERE t0.supplier_id = ?
Parameters:
[
  104
]

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\EventShop 83
App\Entity\Shop 83
App\Entity\Appointment 4
App\Entity\TimeSlot 4
App\Entity\User 1
App\Entity\SpeedDatingEvent 1
App\Entity\Supplier 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\Shop No errors.
App\Entity\TimeSlot No errors.