Symfony Profiler

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

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;

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:03') ORDER BY u1_.lastname 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

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
  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
  p0_.id AS id_0,
  p0_.projectnumber AS projectnumber_1,
  p0_.name AS name_2,
  p0_.starttime AS starttime_3,
  p0_.finishtime AS finishtime_4,
  p0_.value AS value_5,
  p0_.msa AS msa_6,
  p0_.planbar_id AS planbar_id_7,
  p0_.color_background AS color_background_8,
  p0_.color_foreground AS color_foreground_9,
  p0_.update_at AS update_at_10,
  p0_.create_at AS create_at_11,
  p0_.balance AS balance_12,
  p0_.matbalance AS matbalance_13,
  p0_.archive AS archive_14,
  p0_.creditsum AS creditsum_15,
  p0_.debitsum AS debitsum_16,
  p0_.matsum AS matsum_17,
  p0_.writeoffsum AS writeoffsum_18,
  p0_.subsum AS subsum_19,
  p0_.feesum AS feesum_20,
  p0_.rentsum AS rentsum_21,
  p0_.expensessum AS expensessum_22,
  p0_.pds_id AS pds_id_23,
  c1_.id AS id_24,
  c1_.name AS name_25,
  c1_.shortname AS shortname_26,
  c1_.create_at AS create_at_27,
  c1_.update_at AS update_at_28,
  p2_.id AS id_29,
  p2_.vorname AS vorname_30,
  p2_.name AS name_31,
  p2_.customer_number AS customer_number_32,
  p2_.supplier_number AS supplier_number_33,
  p2_.form AS form_34,
  p0_.leader_id AS leader_id_35,
  p0_.customer_id AS customer_id_36,
  p0_.status_id AS status_id_37,
  p0_.creator_id AS creator_id_38,
  p0_.updater_id AS updater_id_39,
  c1_.pds_person_id AS pds_person_id_40,
  c1_.creator_id AS creator_id_41,
  c1_.updater_id AS updater_id_42
FROM
  project p0_
  LEFT JOIN customer c1_ ON p0_.customer_id = c1_.id
  LEFT JOIN pds_person p2_ ON c1_.pds_person_id = p2_.id
ORDER BY
  p0_.name ASC

SELECT p0_.id AS id_0, p0_.projectnumber AS projectnumber_1, p0_.name AS name_2, p0_.starttime AS starttime_3, p0_.finishtime AS finishtime_4, p0_.value AS value_5, p0_.msa AS msa_6, p0_.planbar_id AS planbar_id_7, p0_.color_background AS color_background_8, p0_.color_foreground AS color_foreground_9, p0_.update_at AS update_at_10, p0_.create_at AS create_at_11, p0_.balance AS balance_12, p0_.matbalance AS matbalance_13, p0_.archive AS archive_14, p0_.creditsum AS creditsum_15, p0_.debitsum AS debitsum_16, p0_.matsum AS matsum_17, p0_.writeoffsum AS writeoffsum_18, p0_.subsum AS subsum_19, p0_.feesum AS feesum_20, p0_.rentsum AS rentsum_21, p0_.expensessum AS expensessum_22, p0_.pds_id AS pds_id_23, c1_.id AS id_24, c1_.name AS name_25, c1_.shortname AS shortname_26, c1_.create_at AS create_at_27, c1_.update_at AS update_at_28, p2_.id AS id_29, p2_.vorname AS vorname_30, p2_.name AS name_31, p2_.customer_number AS customer_number_32, p2_.supplier_number AS supplier_number_33, p2_.form AS form_34, p0_.leader_id AS leader_id_35, p0_.customer_id AS customer_id_36, p0_.status_id AS status_id_37, p0_.creator_id AS creator_id_38, p0_.updater_id AS updater_id_39, c1_.pds_person_id AS pds_person_id_40, c1_.creator_id AS creator_id_41, c1_.updater_id AS updater_id_42 FROM project p0_ LEFT JOIN customer c1_ ON p0_.customer_id = c1_.id LEFT JOIN pds_person p2_ ON c1_.pds_person_id = p2_.id ORDER BY p0_.name ASC;

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
  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:03') ORDER BY u1_.lastname ASC;