Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.shortname AS shortname_2,
  c0_.create_at AS create_at_3,
  c0_.update_at AS update_at_4,
  p1_.id AS id_5,
  p1_.vorname AS vorname_6,
  p1_.name AS name_7,
  p1_.customer_number AS customer_number_8,
  p1_.supplier_number AS supplier_number_9,
  p1_.form AS form_10,
  c0_.pds_person_id AS pds_person_id_11,
  c0_.creator_id AS creator_id_12,
  c0_.updater_id AS updater_id_13
FROM
  customer c0_
  LEFT JOIN pds_person p1_ ON c0_.pds_person_id = p1_.id
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.shortname AS shortname_2, c0_.create_at AS create_at_3, c0_.update_at AS update_at_4, p1_.id AS id_5, p1_.vorname AS vorname_6, p1_.name AS name_7, p1_.customer_number AS customer_number_8, p1_.supplier_number AS supplier_number_9, p1_.form AS form_10, c0_.pds_person_id AS pds_person_id_11, c0_.creator_id AS creator_id_12, c0_.updater_id AS updater_id_13 FROM customer c0_ LEFT JOIN pds_person p1_ ON c0_.pds_person_id = p1_.id ORDER BY c0_.name ASC;

"COMMIT"

"COMMIT";

INSERT INTO project_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 project_audit (type, object_id, discriminator, transaction_hash, diffs, blame_id, blame_user, blame_user_fqdn, blame_user_firewall, ip, created_at) VALUES ('insert', '2005', NULL, '5bca703a7029ed2f56ba927ff6421a7136086c63', '{\"@source\":{\"id\":2005,\"class\":\"App\\\\Entity\\\\PMS\\\\Project\",\"label\":\"Viega Kirkel Neues Werk ELT (260302078)\",\"table\":\"project\"},\"projectnumber\":{\"new\":260302078,\"old\":null},\"name\":{\"new\":\"Viega Kirkel Neues Werk ELT\",\"old\":null},\"value\":{\"new\":450000000,\"old\":null},\"msa\":{\"new\":false,\"old\":null},\"colorBackground\":{\"new\":\"#000000\",\"old\":null},\"colorForeground\":{\"new\":\"#ffff00\",\"old\":null},\"archive\":{\"new\":false,\"old\":null},\"creditsum\":{\"new\":0,\"old\":null},\"debitsum\":{\"new\":0,\"old\":null},\"matsum\":{\"new\":0,\"old\":null},\"writeoffsum\":{\"new\":0,\"old\":null},\"subsum\":{\"new\":0,\"old\":null},\"feesum\":{\"new\":0,\"old\":null},\"rentsum\":{\"new\":0,\"old\":null},\"leader\":{\"new\":{\"id\":1,\"class\":\"App\\\\Entity\\\\PMS\\\\Leader\",\"label\":\"Alexander Atzrodt AA\",\"table\":\"leader\"},\"old\":null},\"customer\":{\"new\":{\"id\":290,\"class\":\"App\\\\Entity\\\\PMS\\\\Customer\",\"label\":\"Viega Supply Chain GmbH & Co.KG (Viega Supply)\",\"table\":\"customer\"},\"old\":null},\"status\":{\"new\":{\"id\":1,\"class\":\"App\\\\Entity\\\\PMS\\\\ProjectStatus\",\"label\":\"offen\",\"table\":\"project_status\"},\"old\":null}}', '1', 'aatzrodt', 'DH\\Auditor\\User\\User', 'main', '192.168.2.10', '2026-03-01 10:40:03.048574');

INSERT INTO project (
  projectnumber, name, starttime, finishtime,
  value, msa, planbar_id, color_background,
  color_foreground, update_at, create_at,
  balance, matbalance, archive, creditsum,
  debitsum, matsum, writeoffsum, subsum,
  feesum, rentsum, expensessum, pds_id,
  leader_id, customer_id, status_id,
  creator_id, updater_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO project (projectnumber, name, starttime, finishtime, value, msa, planbar_id, color_background, color_foreground, update_at, create_at, balance, matbalance, archive, creditsum, debitsum, matsum, writeoffsum, subsum, feesum, rentsum, expensessum, pds_id, leader_id, customer_id, status_id, creator_id, updater_id) VALUES (260302078, 'Viega Kirkel Neues Werk ELT', NULL, NULL, 450000000, 0, NULL, '#000000', '#ffff00', NULL, '2026-03-01 10:40:03', NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 1, 290, 1, 1, NULL);

SELECT
  l0_.id AS id_0,
  l0_.number AS number_1,
  l0_.shortname AS shortname_2,
  l0_.enabled AS enabled_3,
  u1_.id AS id_4,
  u1_.firstname AS firstname_5,
  u1_.lastname AS lastname_6,
  u1_.username AS username_7,
  u1_.employeenumber AS employeenumber_8,
  u1_.mobile_number AS mobile_number_9,
  u1_.roles AS roles_10,
  u1_.email AS email_11,
  u1_.create_at AS create_at_12,
  u1_.update_at AS update_at_13,
  u1_.exit_date AS exit_date_14,
  u1_.breaktime AS breaktime_15,
  u1_.external_employee AS external_employee_16,
  u1_.weekly_working_time AS weekly_working_time_17,
  u1_.paypercent AS paypercent_18,
  u1_.incentive_wage AS incentive_wage_19,
  u1_.salary AS salary_20,
  u1_.user_project_group_sort_order AS user_project_group_sort_order_21,
  u1_.nextcloud_sync AS nextcloud_sync_22,
  u1_.driver_license_serial_number AS driver_license_serial_number_23,
  u1_.pds_id AS pds_id_24,
  l0_.user_id AS user_id_25,
  u1_.creator_id AS creator_id_26,
  u1_.updater_id AS updater_id_27,
  u1_.user_project_group_id AS user_project_group_id_28,
  u1_.paystub_wagetype_id AS paystub_wagetype_id_29
FROM
  leader l0_
  INNER JOIN user u1_ ON l0_.user_id = u1_.id
WHERE
  l0_.enabled = 1
  AND (
    u1_.exit_date IS NULL
    OR u1_.exit_date > ?
  )
ORDER BY
  u1_.lastname ASC

SELECT l0_.id AS id_0, l0_.number AS number_1, l0_.shortname AS shortname_2, l0_.enabled AS enabled_3, u1_.id AS id_4, u1_.firstname AS firstname_5, u1_.lastname AS lastname_6, u1_.username AS username_7, u1_.employeenumber AS employeenumber_8, u1_.mobile_number AS mobile_number_9, u1_.roles AS roles_10, u1_.email AS email_11, u1_.create_at AS create_at_12, u1_.update_at AS update_at_13, u1_.exit_date AS exit_date_14, u1_.breaktime AS breaktime_15, u1_.external_employee AS external_employee_16, u1_.weekly_working_time AS weekly_working_time_17, u1_.paypercent AS paypercent_18, u1_.incentive_wage AS incentive_wage_19, u1_.salary AS salary_20, u1_.user_project_group_sort_order AS user_project_group_sort_order_21, u1_.nextcloud_sync AS nextcloud_sync_22, u1_.driver_license_serial_number AS driver_license_serial_number_23, u1_.pds_id AS pds_id_24, l0_.user_id AS user_id_25, u1_.creator_id AS creator_id_26, u1_.updater_id AS updater_id_27, u1_.user_project_group_id AS user_project_group_id_28, u1_.paystub_wagetype_id AS paystub_wagetype_id_29 FROM leader l0_ INNER JOIN user u1_ ON l0_.user_id = u1_.id WHERE l0_.enabled = 1 AND (u1_.exit_date IS NULL OR u1_.exit_date > '2026-03-01 10:40:02') ORDER BY u1_.lastname ASC;

SELECT
  u0_.id AS id_0,
  u0_.firstname AS firstname_1,
  u0_.lastname AS lastname_2,
  u0_.username AS username_3,
  u0_.employeenumber AS employeenumber_4,
  u0_.mobile_number AS mobile_number_5,
  u0_.roles AS roles_6,
  u0_.email AS email_7,
  u0_.create_at AS create_at_8,
  u0_.update_at AS update_at_9,
  u0_.exit_date AS exit_date_10,
  u0_.breaktime AS breaktime_11,
  u0_.external_employee AS external_employee_12,
  u0_.weekly_working_time AS weekly_working_time_13,
  u0_.paypercent AS paypercent_14,
  u0_.incentive_wage AS incentive_wage_15,
  u0_.salary AS salary_16,
  u0_.user_project_group_sort_order AS user_project_group_sort_order_17,
  u0_.nextcloud_sync AS nextcloud_sync_18,
  u0_.driver_license_serial_number AS driver_license_serial_number_19,
  u0_.pds_id AS pds_id_20,
  u0_.creator_id AS creator_id_21,
  u0_.updater_id AS updater_id_22,
  u0_.user_project_group_id AS user_project_group_id_23,
  u0_.paystub_wagetype_id AS paystub_wagetype_id_24
FROM
  user u0_
WHERE
  u0_.username = ?

SELECT u0_.id AS id_0, u0_.firstname AS firstname_1, u0_.lastname AS lastname_2, u0_.username AS username_3, u0_.employeenumber AS employeenumber_4, u0_.mobile_number AS mobile_number_5, u0_.roles AS roles_6, u0_.email AS email_7, u0_.create_at AS create_at_8, u0_.update_at AS update_at_9, u0_.exit_date AS exit_date_10, u0_.breaktime AS breaktime_11, u0_.external_employee AS external_employee_12, u0_.weekly_working_time AS weekly_working_time_13, u0_.paypercent AS paypercent_14, u0_.incentive_wage AS incentive_wage_15, u0_.salary AS salary_16, u0_.user_project_group_sort_order AS user_project_group_sort_order_17, u0_.nextcloud_sync AS nextcloud_sync_18, u0_.driver_license_serial_number AS driver_license_serial_number_19, u0_.pds_id AS pds_id_20, u0_.creator_id AS creator_id_21, u0_.updater_id AS updater_id_22, u0_.user_project_group_id AS user_project_group_id_23, u0_.paystub_wagetype_id AS paystub_wagetype_id_24 FROM user u0_ WHERE u0_.username = 'aatzrodt';

"START TRANSACTION"

"START TRANSACTION";

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.pds_id AS pds_id_3
FROM
  project_status t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.pds_id AS pds_id_3 FROM project_status t0;

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 = 1;