6.39 ms (32.18%)
|
20 |
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 = 22556;
|
6.23 ms (31.36%)
|
20 |
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 = 228;
|
5.86 ms (29.52%)
|
20 |
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 = 78;
|
0.37 ms (1.87%)
|
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.36 ms (1.80%)
|
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 = 77;
|
0.33 ms (1.67%)
|
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 = ?
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 = 78;
|
0.32 ms (1.60%)
|
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: [
77
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 = 77 AND t0.event_id = 0x01A1C0F5D9A876D79B02F5A9EDCC5D81 LIMIT 1;
|