Symfony Profiler

SELECT
  *
FROM
  system_session
WHERE
  identifier = ?

SELECT * FROM system_session WHERE identifier = '576eb0c703a889cde1f8ae4555f2ba14a4264ff2d87fafe3f684b7cb23ad5446';

SELECT
  *
FROM
  system_users

SELECT * FROM system_users;

SELECT
  *
FROM
  system_session
WHERE
  identifier = ?

SELECT * FROM system_session WHERE identifier = '576eb0c703a889cde1f8ae4555f2ba14a4264ff2d87fafe3f684b7cb23ad5446';

UPDATE
  system_session
SET
  last_activity = NOW()
WHERE
  identifier = ?

UPDATE system_session SET last_activity = NOW() WHERE identifier = '576eb0c703a889cde1f8ae4555f2ba14a4264ff2d87fafe3f684b7cb23ad5446';

SELECT
  *
FROM
  system_session
WHERE
  identifier = ?

SELECT * FROM system_session WHERE identifier = '576eb0c703a889cde1f8ae4555f2ba14a4264ff2d87fafe3f684b7cb23ad5446';

SELECT
  user_id,
  permission
FROM
  user_permissions

SELECT user_id, permission FROM user_permissions;

CREATE TABLE IF NOT EXISTS attendance_month_locks (
  month VARCHAR(7) NOT NULL PRIMARY KEY,
  -- format 'YYYY-MM'

  locked_at DATETIME NOT NULL,
  locked_by INT NULL,
  created_at DATETIME NOT NULL
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci

CREATE TABLE IF NOT EXISTS attendance_month_locks (
                    month VARCHAR(7) NOT NULL PRIMARY KEY, -- format 'YYYY-MM'

                    locked_at DATETIME NOT NULL,
                    locked_by INT NULL,
                    created_at DATETIME NOT NULL
                ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

SELECT
  1
FROM
  attendance_month_locks
WHERE
  month = ?
LIMIT
  1

SELECT 1 FROM attendance_month_locks WHERE month = '2026-04' LIMIT 1;

SELECT
  *
FROM
  attendance_entries
WHERE
  user_id = ?
  AND end_at IS NULL
ORDER BY
  start_at DESC
LIMIT
  1

SELECT * FROM attendance_entries WHERE user_id = 46 AND end_at IS NULL ORDER BY start_at DESC LIMIT 1;

SELECT
  1
FROM
  user_permissions
WHERE
  user_id = ?
  AND permission = ?
LIMIT
  1

SELECT 1 FROM user_permissions WHERE user_id = 46 AND permission = 'attendance_geofence_bypass' LIMIT 1;

UPDATE
  attendance_entries
SET
  end_at = ?,
  latitude_end = ?,
  longitude_end = ?,
  accuracy_end = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE attendance_entries SET end_at = '2026-04-23 17:11:31', latitude_end = 49.9981221, longitude_end = 15.9530092, accuracy_end = 100, updated_at = '2026-04-23 17:11:31' WHERE id = 61359;

SELECT
  id
FROM
  attendance_days
WHERE
  user_id = ?
  AND date = ?

SELECT id FROM attendance_days WHERE user_id = 46 AND date = '2026-04-23';

SELECT
  start_at,
  end_at,
  source,
  kind
FROM
  attendance_entries
WHERE
  user_id = ?
  AND DATE(start_at) = ?
  AND end_at IS NOT NULL

SELECT start_at, end_at, source, kind FROM attendance_entries WHERE user_id = 46 AND DATE(start_at) = '2026-04-23' AND end_at IS NOT NULL;

SELECT
  kind,
  minutes_per_day,
  valid_from,
  valid_to
FROM
  user_contracts
WHERE
  user_id = ?
  AND valid_from <= ?
  AND (
    valid_to IS NULL
    OR valid_to = ''
    OR valid_to < '1900-01-01'
    OR valid_to >= ?
  )

SELECT kind, minutes_per_day, valid_from, valid_to
             FROM user_contracts
             WHERE user_id = 46 AND valid_from <= '2026-04-30' AND (valid_to IS NULL OR valid_to = '' OR valid_to < '1900-01-01' OR valid_to >= '2026-04-01');

UPDATE
  attendance_days
SET
  work_minutes_sum = ?,
  break_minutes = ?,
  updated_at = ?
WHERE
  user_id = ?
  AND date = ?

UPDATE attendance_days SET work_minutes_sum = 508, break_minutes = 30, updated_at = '2026-04-23 17:11:31' WHERE user_id = 46 AND date = '2026-04-23';

SELECT
  *
FROM
  system_session
WHERE
  identifier = ?

SELECT * FROM system_session WHERE identifier = '576eb0c703a889cde1f8ae4555f2ba14a4264ff2d87fafe3f684b7cb23ad5446';