Symfony Profiler

• Request / Response
• Performance
• Exception
• Logs 1
• Events
• Routing
• Cache
• Twig
• Doctrine
• Emails
• Configuration

Query Metrics

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

[
  46
  "attendance_geofence_bypass"
]

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 system_session SET last_activity = NOW() WHERE identifier = ?

[
  "576eb0c703a889cde1f8ae4555f2ba14a4264ff2d87fafe3f684b7cb23ad5446"
]

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

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

SELECT 1 FROM attendance_month_locks WHERE month = ? LIMIT 1

[
  "2026-04"
]

SELECT
  1
FROM
  attendance_month_locks
WHERE
  month = ?
LIMIT
  1

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

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

[
  508
  30
  "2026-04-23 17:11:31"
  46
  "2026-04-23"
]

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 = ?

[
  "576eb0c703a889cde1f8ae4555f2ba14a4264ff2d87fafe3f684b7cb23ad5446"
]

SELECT
  *
FROM
  system_session
WHERE
  identifier = ?

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

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

[
  "2026-04-23 17:11:31"
  49.9981221
  15.9530092
  100.0
  "2026-04-23 17:11:31"
  61359
]

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 user_id, permission FROM user_permissions

[]

SELECT
  user_id,
  permission
FROM
  user_permissions

SELECT user_id, permission FROM user_permissions;

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 >= ?)

[
  46
  "2026-04-30"
  "2026-04-01"
]

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');

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

[
  46
  "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 * FROM attendance_entries WHERE user_id = ? AND end_at IS NULL ORDER BY start_at DESC LIMIT 1

[
  46
]

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 id FROM attendance_days WHERE user_id = ? AND date = ?

[
  46
  "2026-04-23"
]

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

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

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

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 * FROM system_users

[]

SELECT
  *
FROM
  system_users

SELECT * FROM system_users;