Symfony Profiler

SELECT
  u0_.id AS id_0,
  u0_.username AS username_1,
  u0_.firstname AS firstname_2,
  u0_.employeenumber AS employeenumber_3,
  u0_.lastname AS lastname_4,
  u0_.email AS email_5,
  u0_.roles AS roles_6,
  u0_.breaktime AS breaktime_7,
  u0_.external_employee AS external_employee_8,
  u0_.exit_date AS exit_date_9,
  u0_.driver_license_serial_number AS driver_license_serial_number_10
FROM
  user u0_
WHERE
  u0_.username = ?

SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.firstname AS firstname_2, u0_.employeenumber AS employeenumber_3, u0_.lastname AS lastname_4, u0_.email AS email_5, u0_.roles AS roles_6, u0_.breaktime AS breaktime_7, u0_.external_employee AS external_employee_8, u0_.exit_date AS exit_date_9, u0_.driver_license_serial_number AS driver_license_serial_number_10 FROM user u0_ WHERE u0_.username = 'pgothe';

SELECT
  t0.id AS id_1,
  t0.number AS number_2,
  t0.shortname AS shortname_3,
  t0.enabled AS enabled_4,
  t0.user_id AS user_id_5
FROM
  leader t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.number AS number_2, t0.shortname AS shortname_3, t0.enabled AS enabled_4, t0.user_id AS user_id_5 FROM leader t0 WHERE t0.user_id = 34;

SELECT
  COUNT(*)
FROM
  reca_item t0
WHERE
  (
    t0.user_id = ?
    AND t0.status = ?
  )

SELECT COUNT(*) FROM reca_item t0 WHERE (t0.user_id = 34 AND t0.status = 'überfällig');

SELECT
  COUNT(*)
FROM
  timesheet t0
WHERE
  (
    (
      t0.user_id = ?
      AND t0.duration = ?
    )
    AND t0.end_time >= ?
  )

SELECT COUNT(*) FROM timesheet t0 WHERE ((t0.user_id = 34 AND t0.duration = 60) AND t0.end_time >= '2026-03-02 00:00:00');

SELECT
  t0_.id AS id_0,
  t0_.duration AS duration_1,
  t0_.description AS description_2,
  t0_.start_time AS start_time_3,
  t0_.end_time AS end_time_4,
  t0_.requested_start_time AS requested_start_time_5,
  t0_.requested_end_time AS requested_end_time_6,
  t0_.state AS state_7,
  t0_.category AS category_8,
  t0_.gps_start_acc AS gps_start_acc_9,
  t0_.gps_start_lat AS gps_start_lat_10,
  t0_.gps_start_long AS gps_start_long_11,
  t0_.gps_stop_acc AS gps_stop_acc_12,
  t0_.gps_stop_lat AS gps_stop_lat_13,
  t0_.gps_stop_long AS gps_stop_long_14,
  t0_.gps_start_location AS gps_start_location_15,
  t0_.gps_stop_location AS gps_stop_location_16,
  t0_.activity_id AS activity_id_17,
  t0_.requested_teamlead_id AS requested_teamlead_id_18,
  t0_.user_id AS user_id_19,
  t0_.project_id AS project_id_20
FROM
  timesheet t0_
WHERE
  t0_.category = ?
  AND t0_.user_id = ?
  AND t0_.end_time IS NULL
ORDER BY
  t0_.start_time DESC

SELECT t0_.id AS id_0, t0_.duration AS duration_1, t0_.description AS description_2, t0_.start_time AS start_time_3, t0_.end_time AS end_time_4, t0_.requested_start_time AS requested_start_time_5, t0_.requested_end_time AS requested_end_time_6, t0_.state AS state_7, t0_.category AS category_8, t0_.gps_start_acc AS gps_start_acc_9, t0_.gps_start_lat AS gps_start_lat_10, t0_.gps_start_long AS gps_start_long_11, t0_.gps_stop_acc AS gps_stop_acc_12, t0_.gps_stop_lat AS gps_stop_lat_13, t0_.gps_stop_long AS gps_stop_long_14, t0_.gps_start_location AS gps_start_location_15, t0_.gps_stop_location AS gps_stop_location_16, t0_.activity_id AS activity_id_17, t0_.requested_teamlead_id AS requested_teamlead_id_18, t0_.user_id AS user_id_19, t0_.project_id AS project_id_20 FROM timesheet t0_ WHERE t0_.category = 'work' AND t0_.user_id = '34' AND t0_.end_time IS NULL ORDER BY t0_.start_time DESC;

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.color AS color_2,
  a0_.shortcut AS shortcut_3,
  a0_.teamlead_approval AS teamlead_approval_4,
  a0_.category AS category_5,
  a0_.timesheet_option AS timesheet_option_6
FROM
  activity a0_
WHERE
  a0_.name = ?

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.color AS color_2, a0_.shortcut AS shortcut_3, a0_.teamlead_approval AS teamlead_approval_4, a0_.category AS category_5, a0_.timesheet_option AS timesheet_option_6 FROM activity a0_ WHERE a0_.name = 'Arbeit';

SELECT
  p0_.id AS id_0,
  p0_.projectnumber AS projectnumber_1,
  p0_.customer_id AS customer_id_2,
  p0_.name AS name_3,
  p0_.finishtime AS finishtime_4,
  p0_.status_id AS status_id_5
FROM
  project p0_
WHERE
  p0_.id = ?

SELECT p0_.id AS id_0, p0_.projectnumber AS projectnumber_1, p0_.customer_id AS customer_id_2, p0_.name AS name_3, p0_.finishtime AS finishtime_4, p0_.status_id AS status_id_5 FROM project p0_ WHERE p0_.id = '1759';

SELECT
  t0_.id AS id_0,
  t0_.duration AS duration_1,
  t0_.description AS description_2,
  t0_.start_time AS start_time_3,
  t0_.end_time AS end_time_4,
  t0_.requested_start_time AS requested_start_time_5,
  t0_.requested_end_time AS requested_end_time_6,
  t0_.state AS state_7,
  t0_.category AS category_8,
  t0_.gps_start_acc AS gps_start_acc_9,
  t0_.gps_start_lat AS gps_start_lat_10,
  t0_.gps_start_long AS gps_start_long_11,
  t0_.gps_stop_acc AS gps_stop_acc_12,
  t0_.gps_stop_lat AS gps_stop_lat_13,
  t0_.gps_stop_long AS gps_stop_long_14,
  t0_.gps_start_location AS gps_start_location_15,
  t0_.gps_stop_location AS gps_stop_location_16,
  t0_.activity_id AS activity_id_17,
  t0_.requested_teamlead_id AS requested_teamlead_id_18,
  t0_.user_id AS user_id_19,
  t0_.project_id AS project_id_20
FROM
  timesheet t0_
WHERE
  t0_.category = ?
  AND t0_.user_id = ?
  AND t0_.end_time IS NULL
ORDER BY
  t0_.start_time DESC

SELECT t0_.id AS id_0, t0_.duration AS duration_1, t0_.description AS description_2, t0_.start_time AS start_time_3, t0_.end_time AS end_time_4, t0_.requested_start_time AS requested_start_time_5, t0_.requested_end_time AS requested_end_time_6, t0_.state AS state_7, t0_.category AS category_8, t0_.gps_start_acc AS gps_start_acc_9, t0_.gps_start_lat AS gps_start_lat_10, t0_.gps_start_long AS gps_start_long_11, t0_.gps_stop_acc AS gps_stop_acc_12, t0_.gps_stop_lat AS gps_stop_lat_13, t0_.gps_stop_long AS gps_stop_long_14, t0_.gps_start_location AS gps_start_location_15, t0_.gps_stop_location AS gps_stop_location_16, t0_.activity_id AS activity_id_17, t0_.requested_teamlead_id AS requested_teamlead_id_18, t0_.user_id AS user_id_19, t0_.project_id AS project_id_20 FROM timesheet t0_ WHERE t0_.category = 'work' AND t0_.user_id = 34 AND t0_.end_time IS NULL ORDER BY t0_.start_time DESC;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO timesheet (
  duration, description, start_time,
  end_time, requested_start_time,
  requested_end_time, state, category,
  gps_start_acc, gps_start_lat, gps_start_long,
  gps_stop_acc, gps_stop_lat, gps_stop_long,
  gps_start_location, gps_stop_location,
  activity_id, requested_teamlead_id,
  user_id, project_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )

INSERT INTO timesheet (duration, description, start_time, end_time, requested_start_time, requested_end_time, state, category, gps_start_acc, gps_start_lat, gps_start_long, gps_stop_acc, gps_stop_lat, gps_stop_long, gps_start_location, gps_stop_location, activity_id, requested_teamlead_id, user_id, project_id) VALUES (NULL, '', '2026-04-01 08:51:00', NULL, NULL, NULL, 0, 'work', 15, 51.054609879911, 11.710668838961, NULL, NULL, NULL, NULL, NULL, 1, NULL, 34, 1759);

UPDATE
  project
SET
  projectnumber = ?
WHERE
  id = ?

UPDATE project SET projectnumber = '250301892' WHERE id = 1759;

INSERT INTO timesheet_audit (
  type, object_id, discriminator, transaction_hash,
  diffs, blame_id, blame_user, blame_user_fqdn,
  blame_user_firewall, ip, created_at
)
VALUES
  (
    :type, :object_id, :discriminator,
    :transaction_hash, :diffs, :blame_id,
    :blame_user, :blame_user_fqdn, :blame_user_firewall,
    :ip, :created_at
  )

INSERT INTO timesheet_audit (type, object_id, discriminator, transaction_hash, diffs, blame_id, blame_user, blame_user_fqdn, blame_user_firewall, ip, created_at) VALUES ('insert', '81849', NULL, 'f14b6ea751b975fad3c8aa48a5576b7436083e08', '{\"@source\":{\"id\":81849,\"class\":\"App\\\\Entity\\\\Timesheet\",\"label\":\"App\\\\Entity\\\\Timesheet#81849\",\"table\":\"timesheet\"},\"description\":{\"new\":\"\",\"old\":null},\"start_time\":{\"new\":\"2026-04-01 08:51:00\",\"old\":null},\"state\":{\"new\":0,\"old\":null},\"activity\":{\"new\":{\"id\":1,\"class\":\"App\\\\Entity\\\\Activity\",\"label\":\"App\\\\Entity\\\\Activity#1\",\"table\":\"activity\"},\"old\":null},\"user\":{\"new\":{\"id\":34,\"class\":\"App\\\\Entity\\\\User\",\"label\":\"Paul Gothe\",\"table\":\"user\"},\"old\":null},\"project\":{\"new\":{\"id\":1759,\"class\":\"App\\\\Entity\\\\Project\",\"label\":\"App\\\\Entity\\\\Project#1759\",\"table\":\"project\"},\"old\":null}}', '34', 'pgothe', 'DH\\Auditor\\User\\User', 'main', '192.168.2.10', '2026-04-01 08:51:35.092843');

"COMMIT"

"COMMIT";