| 1 |
3.77 ms
|
UPDATE attendance SET clock_out = auto_out, auto_closed = 1 WHERE clock_out IS NULL AND auto_out IS NOT NULL AND auto_out <= ?
Parameters: [
"2026-10-19 13:55:10"
]
UPDATE attendance SET clock_out = auto_out, auto_closed = 1 WHERE clock_out IS NULL AND auto_out IS NOT NULL AND auto_out <= '2026-10-19 13:55:10';
|
| 2 |
4.55 ms
|
SELECT t0.id AS id_1, t0.name AS name_2, t0.avatar AS avatar_3, t0.bio AS bio_4, t0.hue AS hue_5, t0.auto_out AS auto_out_6 FROM moderator t0 ORDER BY t0.id ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.avatar AS avatar_3, t0.bio AS bio_4, t0.hue AS hue_5, t0.auto_out AS auto_out_6 FROM moderator t0 ORDER BY t0.id ASC;
|
| 3 |
4.45 ms
|
SELECT a0_.id AS id_0, a0_.day AS day_1, a0_.clock_in AS clock_in_2, a0_.clock_out AS clock_out_3, a0_.auto_out AS auto_out_4, a0_.auto_closed AS auto_closed_5, m1_.id AS id_6, m1_.name AS name_7, m1_.avatar AS avatar_8, m1_.bio AS bio_9, m1_.hue AS hue_10, m1_.auto_out AS auto_out_11, a0_.moderator_id AS moderator_id_12 FROM attendance a0_ INNER JOIN moderator m1_ ON a0_.moderator_id = m1_.id WHERE a0_.day LIKE ?
SELECT a0_.id AS id_0, a0_.day AS day_1, a0_.clock_in AS clock_in_2, a0_.clock_out AS clock_out_3, a0_.auto_out AS auto_out_4, a0_.auto_closed AS auto_closed_5, m1_.id AS id_6, m1_.name AS name_7, m1_.avatar AS avatar_8, m1_.bio AS bio_9, m1_.hue AS hue_10, m1_.auto_out AS auto_out_11, a0_.moderator_id AS moderator_id_12 FROM attendance a0_ INNER JOIN moderator m1_ ON a0_.moderator_id = m1_.id WHERE a0_.day LIKE '2026-%';
|
| 4 |
3.42 ms
|
SELECT d0_.id AS id_0, d0_.day AS day_1, d0_.note AS note_2, m1_.id AS id_3, m1_.name AS name_4, m1_.avatar AS avatar_5, m1_.bio AS bio_6, m1_.hue AS hue_7, m1_.auto_out AS auto_out_8, d0_.moderator_id AS moderator_id_9 FROM day_off d0_ INNER JOIN moderator m1_ ON d0_.moderator_id = m1_.id WHERE d0_.day LIKE ?
SELECT d0_.id AS id_0, d0_.day AS day_1, d0_.note AS note_2, m1_.id AS id_3, m1_.name AS name_4, m1_.avatar AS avatar_5, m1_.bio AS bio_6, m1_.hue AS hue_7, m1_.auto_out AS auto_out_8, d0_.moderator_id AS moderator_id_9 FROM day_off d0_ INNER JOIN moderator m1_ ON d0_.moderator_id = m1_.id WHERE d0_.day LIKE '2026-%';
|
| 5 |
2.16 ms
|
SELECT t0.id AS id_1, t0.day AS day_2, t0.clock_in AS clock_in_3, t0.clock_out AS clock_out_4, t0.auto_out AS auto_out_5, t0.auto_closed AS auto_closed_6, t0.moderator_id AS moderator_id_7 FROM attendance t0 WHERE t0.moderator_id = ? AND t0.clock_out IS NULL LIMIT 1
SELECT t0.id AS id_1, t0.day AS day_2, t0.clock_in AS clock_in_3, t0.clock_out AS clock_out_4, t0.auto_out AS auto_out_5, t0.auto_closed AS auto_closed_6, t0.moderator_id AS moderator_id_7 FROM attendance t0 WHERE t0.moderator_id = 11 AND t0.clock_out IS NULL LIMIT 1;
|
| 6 |
1.74 ms
|
SELECT t0.id AS id_1, t0.name AS name_2, t0.avatar AS avatar_3, t0.bio AS bio_4, t0.hue AS hue_5, t0.auto_out AS auto_out_6 FROM moderator t0 ORDER BY t0.id ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.avatar AS avatar_3, t0.bio AS bio_4, t0.hue AS hue_5, t0.auto_out AS auto_out_6 FROM moderator t0 ORDER BY t0.id ASC;
|