1.73 ms (21.11%)
|
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 = ?
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 = 6;
|
1.59 ms (19.42%)
|
1 |
"COMMIT"
|
0.66 ms (8.00%)
|
1 |
INSERT INTO appointments (start_time, created_at, event_id, slot_id, supplier_id) VALUES (?, ?, ?, ?, ?)
Parameters: [
"2026-11-17 11:16:00"
"2026-11-10 18:45:31"
b"\x01¡ÀõÙ¨v×›\x02õ©íÌ]"
22737
7
]
INSERT INTO appointments (start_time, created_at, event_id, slot_id, supplier_id) VALUES ('2026-11-17 11:16:00', '2026-11-10 18:45:31', 0x01A1C0F5D9A876D79B02F5A9EDCC5D81, 22737, 7);
|
0.47 ms (5.71%)
|
1 |
SELECT COUNT(a0_.id) AS sclr_0 FROM appointments a0_ WHERE a0_.supplier_id = ? AND a0_.event_id = ?
SELECT COUNT(a0_.id) AS sclr_0 FROM appointments a0_ WHERE a0_.supplier_id = 7 AND a0_.event_id = '01a1c0f5-d9a8-76d7-9b02-f5a9edcc5d81';
|
0.46 ms (5.60%)
|
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"
]
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 = 'c36514850ac1437471b2d6e25a8209b8be3da21afdce0ecb' LIMIT 1;
|
0.45 ms (5.53%)
|
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 11:24:00"
"2026-11-17 11:16:00"
]
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 = 7 AND (t1_.start_time < '2026-11-17 11:24:00' AND t1_.end_time > '2026-11-17 11:16:00');
|
0.45 ms (5.50%)
|
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 = ?
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 = 7 AND t1_.event_shop_id = 241;
|
0.41 ms (5.02%)
|
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 = ?
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 = 241;
|
0.41 ms (4.95%)
|
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õ©íÌ]"
]
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 = 6 AND t0.event_id = 0x01A1C0F5D9A876D79B02F5A9EDCC5D81 LIMIT 1;
|
0.37 ms (4.46%)
|
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 = ?
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 = 22737;
|
0.36 ms (4.34%)
|
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 = ?
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 = 91;
|
0.31 ms (3.80%)
|
1 |
UPDATE time_slots SET status = ? WHERE id = ?
Parameters: [
"BOOKED"
22737
]
UPDATE time_slots SET status = 'BOOKED' WHERE id = 22737;
|
0.29 ms (3.52%)
|
1 |
DELETE FROM shop_holds WHERE event_shop_id = ? AND supplier_id = ?
DELETE FROM shop_holds WHERE event_shop_id = 241 AND supplier_id = 7;
|
0.25 ms (3.04%)
|
1 |
"START TRANSACTION"
"START TRANSACTION";
|