1.48 ms (14.46%)
|
1 |
"COMMIT"
|
1.44 ms (14.09%)
|
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: [
18
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 = 18 AND t0.event_id = 0x01A1C0F5D9A876D79B02F5A9EDCC5D81 LIMIT 1;
|
0.89 ms (8.74%)
|
1 |
UPDATE time_slots SET status = ? WHERE id = ?
Parameters: [
"BOOKED"
21977
]
UPDATE time_slots SET status = 'BOOKED' WHERE id = 21977;
|
0.75 ms (7.32%)
|
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 = 19 AND a0_.event_id = '01a1c0f5-d9a8-76d7-9b02-f5a9edcc5d81';
|
0.73 ms (7.10%)
|
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 = 21977;
|
0.71 ms (6.94%)
|
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: [
19
"2026-11-17 10:12:00"
"2026-11-17 10:04: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 = 19 AND (t1_.start_time < '2026-11-17 10:12:00' AND t1_.end_time > '2026-11-17 10:04:00');
|
0.65 ms (6.36%)
|
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 = 19 AND t1_.event_shop_id = 237;
|
0.62 ms (6.04%)
|
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 = 18;
|
0.60 ms (5.85%)
|
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.55 ms (5.36%)
|
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 = 87;
|
0.52 ms (5.10%)
|
1 |
INSERT INTO appointments (start_time, created_at, event_id, slot_id, supplier_id) VALUES (?, ?, ?, ?, ?)
Parameters: [
"2026-11-17 10:04:00"
"2026-11-10 20:37:01"
b"\x01¡ÀõÙ¨v×›\x02õ©íÌ]"
21977
19
]
INSERT INTO appointments (start_time, created_at, event_id, slot_id, supplier_id) VALUES ('2026-11-17 10:04:00', '2026-11-10 20:37:01', 0x01A1C0F5D9A876D79B02F5A9EDCC5D81, 21977, 19);
|
0.46 ms (4.54%)
|
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 = 237;
|
0.46 ms (4.47%)
|
1 |
DELETE FROM shop_holds WHERE event_shop_id = ? AND supplier_id = ?
DELETE FROM shop_holds WHERE event_shop_id = 237 AND supplier_id = 19;
|
0.37 ms (3.62%)
|
1 |
"START TRANSACTION"
"START TRANSACTION";
|