Symfony Profiler

SELECT
  *
FROM
  system_session
WHERE
  identifier = ?

SELECT * FROM system_session WHERE identifier = 'e319aaab4bb7e087375a26f8a83e9a5952b9bb9a4dbe98b8dd0174e3b884da89';

SELECT
  *
FROM
  system_users

SELECT * FROM system_users;

SELECT
  *
FROM
  system_session
WHERE
  identifier = ?

SELECT * FROM system_session WHERE identifier = 'e319aaab4bb7e087375a26f8a83e9a5952b9bb9a4dbe98b8dd0174e3b884da89';

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

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

SELECT
  *
FROM
  system_session
WHERE
  identifier = ?

SELECT * FROM system_session WHERE identifier = 'e319aaab4bb7e087375a26f8a83e9a5952b9bb9a4dbe98b8dd0174e3b884da89';

SELECT
  user_id,
  permission
FROM
  user_permissions

SELECT user_id, permission FROM user_permissions;

CREATE TABLE IF NOT EXISTS timesheets (
  id INT AUTO_INCREMENT PRIMARY KEY,
  user_id INT NOT NULL,
  user_name VARCHAR(255) NOT NULL,
  from_date DATE NOT NULL,
  to_date DATE NOT NULL,
  total_hours DECIMAL(10, 2) NOT NULL DEFAULT 0,
  created_at DATETIME NOT NULL,
  INDEX idx_user_created (user_id, created_at)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci

CREATE TABLE IF NOT EXISTS timesheets (
                    id INT AUTO_INCREMENT PRIMARY KEY,
                    user_id INT NOT NULL,
                    user_name VARCHAR(255) NOT NULL,
                    from_date DATE NOT NULL,
                    to_date DATE NOT NULL,
                    total_hours DECIMAL(10,2) NOT NULL DEFAULT 0,
                    created_at DATETIME NOT NULL,
                    INDEX idx_user_created (user_id, created_at)
                ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS timesheet_rows (
  id INT AUTO_INCREMENT PRIMARY KEY,
  timesheet_id INT NOT NULL,
  date DATE NOT NULL,
  hours DECIMAL(10, 2) NOT NULL DEFAULT 0,
  note VARCHAR(255) NULL,
  time_from TIME NULL,
  time_to TIME NULL,
  INDEX idx_sheet (timesheet_id),
  INDEX idx_date (date),
  CONSTRAINT fk_ts_rows FOREIGN KEY (timesheet_id) REFERENCES timesheets(id) ON DELETE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci

CREATE TABLE IF NOT EXISTS timesheet_rows (
                    id INT AUTO_INCREMENT PRIMARY KEY,
                    timesheet_id INT NOT NULL,
                    date DATE NOT NULL,
                    hours DECIMAL(10,2) NOT NULL DEFAULT 0,
                    note VARCHAR(255) NULL,
                    time_from TIME NULL,
                    time_to TIME NULL,
                    INDEX idx_sheet (timesheet_id),
                    INDEX idx_date (date),
                    CONSTRAINT fk_ts_rows FOREIGN KEY (timesheet_id) REFERENCES timesheets(id) ON DELETE CASCADE
                ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

ALTER TABLE
  timesheet_rows
ADD
  COLUMN time_from TIME NULL

ALTER TABLE timesheet_rows ADD COLUMN time_from TIME NULL;

ALTER TABLE
  timesheet_rows
ADD
  COLUMN time_to TIME NULL

ALTER TABLE timesheet_rows ADD COLUMN time_to TIME NULL;

SELECT
  *
FROM
  timesheets
WHERE
  id = ?

SELECT * FROM timesheets WHERE id = 168;

SELECT
  date,
  hours,
  note,
  time_from,
  time_to
FROM
  timesheet_rows
WHERE
  timesheet_id = ?
ORDER BY
  date ASC,
  time_from ASC

SELECT date, hours, note, time_from, time_to FROM timesheet_rows WHERE timesheet_id = 168 ORDER BY date ASC, time_from ASC;

SELECT
  *
FROM
  system_session
WHERE
  identifier = ?

SELECT * FROM system_session WHERE identifier = 'e319aaab4bb7e087375a26f8a83e9a5952b9bb9a4dbe98b8dd0174e3b884da89';