Symfony Profiler

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

Query Metrics

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

[
  "ad313f4f7e9404b1bd3076df5a1d1b8cab8398b990a6a31f2a29b57170e54691"
]

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

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

SELECT * FROM system_session WHERE identifier = ?

[
  "ad313f4f7e9404b1bd3076df5a1d1b8cab8398b990a6a31f2a29b57170e54691"
]

SELECT
  *
FROM
  system_session
WHERE
  identifier = ?

SELECT * FROM system_session WHERE identifier = 'ad313f4f7e9404b1bd3076df5a1d1b8cab8398b990a6a31f2a29b57170e54691';

INSERT INTO attendance_entries (user_id, start_at, source, created_at, updated_at) VALUES (?, ?, ?, ?, ?)

[
  105
  "2026-02-22 18:00:00"
  "manual"
  "2026-02-22 18:05:07"
  "2026-02-22 18:05:07"
]

INSERT INTO attendance_entries (
  user_id, start_at, source, created_at,
  updated_at
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO attendance_entries (user_id, start_at, source, created_at, updated_at) VALUES (105, '2026-02-22 18:00:00', 'manual', '2026-02-22 18:05:07', '2026-02-22 18:05:07');

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

[
  105
  "2026-02-22"
]

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

SELECT id FROM attendance_days WHERE user_id = 105 AND date = '2026-02-22';

INSERT INTO attendance_days (user_id, date, break_minutes, work_minutes_sum, created_at, updated_at) VALUES (?, ?, ?, ?, ?, ?)

[
  105
  "2026-02-22"
  0
  0
  "2026-02-22 18:05:08"
  "2026-02-22 18:05:08"
]

INSERT INTO attendance_days (
  user_id, date, break_minutes, work_minutes_sum,
  created_at, updated_at
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO attendance_days (user_id, date, break_minutes, work_minutes_sum, created_at, updated_at) VALUES (105, '2026-02-22', 0, 0, '2026-02-22 18:05:08', '2026-02-22 18:05:08');

SELECT user_id, permission FROM user_permissions

[]

SELECT
  user_id,
  permission
FROM
  user_permissions

SELECT user_id, permission FROM user_permissions;

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

[
  105
]

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 = 105 AND end_at IS NULL ORDER BY start_at DESC LIMIT 1;

SELECT 1 FROM attendance_month_locks WHERE month = ? LIMIT 1

[
  "2026-02"
]

SELECT
  1
FROM
  attendance_month_locks
WHERE
  month = ?
LIMIT
  1

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

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;