| 1 |
2.66 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.pin_code AS pin_code_6, t0.full_name AS full_name_7, t0.user_profile_id AS user_profile_id_8, t0.settings_id AS settings_id_9, t10.id AS id_11, t10.work AS work_12, t10.weekend AS weekend_13, t10.vacation_days AS vacation_days_14, t10.contract_hours AS contract_hours_15, t10.user_id AS user_id_16 FROM user t0 LEFT JOIN settings t10 ON t10.user_id = t0.id
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.pin_code AS pin_code_6, t0.full_name AS full_name_7, t0.user_profile_id AS user_profile_id_8, t0.settings_id AS settings_id_9, t10.id AS id_11, t10.work AS work_12, t10.weekend AS weekend_13, t10.vacation_days AS vacation_days_14, t10.contract_hours AS contract_hours_15, t10.user_id AS user_id_16 FROM user t0 LEFT JOIN settings t10 ON t10.user_id = t0.id;
|
| 2 |
0.84 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.pin_code AS pin_code_6, t0.full_name AS full_name_7, t0.user_profile_id AS user_profile_id_8, t0.settings_id AS settings_id_9, t10.id AS id_11, t10.work AS work_12, t10.weekend AS weekend_13, t10.vacation_days AS vacation_days_14, t10.contract_hours AS contract_hours_15, t10.user_id AS user_id_16 FROM user t0 LEFT JOIN settings t10 ON t10.user_id = t0.id WHERE t0.settings_id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.pin_code AS pin_code_6, t0.full_name AS full_name_7, t0.user_profile_id AS user_profile_id_8, t0.settings_id AS settings_id_9, t10.id AS id_11, t10.work AS work_12, t10.weekend AS weekend_13, t10.vacation_days AS vacation_days_14, t10.contract_hours AS contract_hours_15, t10.user_id AS user_id_16 FROM user t0 LEFT JOIN settings t10 ON t10.user_id = t0.id WHERE t0.settings_id = 1;
|
| 3 |
0.32 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.pin_code AS pin_code_6, t0.full_name AS full_name_7, t0.user_profile_id AS user_profile_id_8, t0.settings_id AS settings_id_9, t10.id AS id_11, t10.work AS work_12, t10.weekend AS weekend_13, t10.vacation_days AS vacation_days_14, t10.contract_hours AS contract_hours_15, t10.user_id AS user_id_16 FROM user t0 LEFT JOIN settings t10 ON t10.user_id = t0.id WHERE t0.settings_id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.pin_code AS pin_code_6, t0.full_name AS full_name_7, t0.user_profile_id AS user_profile_id_8, t0.settings_id AS settings_id_9, t10.id AS id_11, t10.work AS work_12, t10.weekend AS weekend_13, t10.vacation_days AS vacation_days_14, t10.contract_hours AS contract_hours_15, t10.user_id AS user_id_16 FROM user t0 LEFT JOIN settings t10 ON t10.user_id = t0.id WHERE t0.settings_id = 3;
|
| 4 |
0.45 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.pin_code AS pin_code_6, t0.full_name AS full_name_7, t0.user_profile_id AS user_profile_id_8, t0.settings_id AS settings_id_9, t10.id AS id_11, t10.work AS work_12, t10.weekend AS weekend_13, t10.vacation_days AS vacation_days_14, t10.contract_hours AS contract_hours_15, t10.user_id AS user_id_16 FROM user t0 LEFT JOIN settings t10 ON t10.user_id = t0.id WHERE t0.settings_id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.pin_code AS pin_code_6, t0.full_name AS full_name_7, t0.user_profile_id AS user_profile_id_8, t0.settings_id AS settings_id_9, t10.id AS id_11, t10.work AS work_12, t10.weekend AS weekend_13, t10.vacation_days AS vacation_days_14, t10.contract_hours AS contract_hours_15, t10.user_id AS user_id_16 FROM user t0 LEFT JOIN settings t10 ON t10.user_id = t0.id WHERE t0.settings_id = 4;
|
| 5 |
0.39 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.pin_code AS pin_code_6, t0.full_name AS full_name_7, t0.user_profile_id AS user_profile_id_8, t0.settings_id AS settings_id_9, t10.id AS id_11, t10.work AS work_12, t10.weekend AS weekend_13, t10.vacation_days AS vacation_days_14, t10.contract_hours AS contract_hours_15, t10.user_id AS user_id_16 FROM user t0 LEFT JOIN settings t10 ON t10.user_id = t0.id WHERE t0.pin_code = ? LIMIT 1
Parameters: [
"550605510735"
]
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.pin_code AS pin_code_6, t0.full_name AS full_name_7, t0.user_profile_id AS user_profile_id_8, t0.settings_id AS settings_id_9, t10.id AS id_11, t10.work AS work_12, t10.weekend AS weekend_13, t10.vacation_days AS vacation_days_14, t10.contract_hours AS contract_hours_15, t10.user_id AS user_id_16 FROM user t0 LEFT JOIN settings t10 ON t10.user_id = t0.id WHERE t0.pin_code = '550605510735' LIMIT 1;
|
| 6 |
1.50 ms |
SELECT t0_.id AS id_0, t0_.start_time AS start_time_1, t0_.end_time AS end_time_2, t0_.date AS date_3, t0_.day_id AS day_id_4, t0_.user_id AS user_id_5 FROM time t0_ WHERE t0_.user_id = ? AND t0_.date = ?
Parameters: [
4
"05-09-2026"
]
SELECT t0_.id AS id_0, t0_.start_time AS start_time_1, t0_.end_time AS end_time_2, t0_.date AS date_3, t0_.day_id AS day_id_4, t0_.user_id AS user_id_5 FROM time t0_ WHERE t0_.user_id = 4 AND t0_.date = '05-09-2026';
|
| 7 |
0.35 ms |
SELECT s0_.id AS id_0, s0_.work AS work_1, s0_.weekend AS weekend_2, s0_.vacation_days AS vacation_days_3, s0_.contract_hours AS contract_hours_4, s0_.user_id AS user_id_5 FROM settings s0_ WHERE s0_.user_id = ?
SELECT s0_.id AS id_0, s0_.work AS work_1, s0_.weekend AS weekend_2, s0_.vacation_days AS vacation_days_3, s0_.contract_hours AS contract_hours_4, s0_.user_id AS user_id_5 FROM settings s0_ WHERE s0_.user_id = 4;
|
| 8 |
0.25 ms |
SELECT s0_.id AS id_0, s0_.work AS work_1, s0_.weekend AS weekend_2, s0_.vacation_days AS vacation_days_3, s0_.contract_hours AS contract_hours_4, s0_.user_id AS user_id_5 FROM settings s0_ WHERE s0_.user_id = ?
SELECT s0_.id AS id_0, s0_.work AS work_1, s0_.weekend AS weekend_2, s0_.vacation_days AS vacation_days_3, s0_.contract_hours AS contract_hours_4, s0_.user_id AS user_id_5 FROM settings s0_ WHERE s0_.user_id = 4;
|
| 9 |
0.29 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 10 |
0.73 ms |
UPDATE time SET end_time = ? WHERE id = ?
Parameters: [
"15:15:54"
347
]
UPDATE time SET end_time = '15:15:54' WHERE id = 347;
|
| 11 |
0.98 ms |
"COMMIT"
|
| 12 |
0.87 ms |
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.street AS street_4, t0.house_number AS house_number_5, t0.zip_code AS zip_code_6, t0.city AS city_7, t0.phone_number AS phone_number_8, t9.id AS id_10, t9.email AS email_11, t9.roles AS roles_12, t9.password AS password_13, t9.is_verified AS is_verified_14, t9.pin_code AS pin_code_15, t9.full_name AS full_name_16, t9.user_profile_id AS user_profile_id_17, t9.settings_id AS settings_id_18 FROM user_profile t0 LEFT JOIN user t9 ON t9.user_profile_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.street AS street_4, t0.house_number AS house_number_5, t0.zip_code AS zip_code_6, t0.city AS city_7, t0.phone_number AS phone_number_8, t9.id AS id_10, t9.email AS email_11, t9.roles AS roles_12, t9.password AS password_13, t9.is_verified AS is_verified_14, t9.pin_code AS pin_code_15, t9.full_name AS full_name_16, t9.user_profile_id AS user_profile_id_17, t9.settings_id AS settings_id_18 FROM user_profile t0 LEFT JOIN user t9 ON t9.user_profile_id = t0.id WHERE t0.id = 3;
|
| 13 |
1.88 ms |
SELECT t0_.id AS id_0, t0_.start_time AS start_time_1, t0_.end_time AS end_time_2, t0_.date AS date_3, t0_.day_id AS day_id_4, t0_.user_id AS user_id_5 FROM time t0_ INNER JOIN user u1_ ON t0_.user_id = u1_.id WHERE t0_.date = ?
Parameters: [
"05-09-2026"
]
SELECT t0_.id AS id_0, t0_.start_time AS start_time_1, t0_.end_time AS end_time_2, t0_.date AS date_3, t0_.day_id AS day_id_4, t0_.user_id AS user_id_5 FROM time t0_ INNER JOIN user u1_ ON t0_.user_id = u1_.id WHERE t0_.date = '05-09-2026';
|