Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 30
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine 1
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

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 = ?

[
  "mhollitzer"
]

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

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 = ?

[
  93
]

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

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

[
  93
  "überfällig"
]

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

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

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

[
  93
  60
  "2026-01-06 00:00:00"
]

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 = 93 AND t0.duration = 60) AND t0.end_time >= '2026-01-06 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, p1_.id AS id_17, p1_.projectnumber AS projectnumber_18, p1_.customer_id AS customer_id_19, p1_.name AS name_20, p1_.finishtime AS finishtime_21, p1_.status_id AS status_id_22, t0_.activity_id AS activity_id_23, t0_.requested_teamlead_id AS requested_teamlead_id_24, t0_.user_id AS user_id_25, t0_.project_id AS project_id_26 FROM timesheet t0_ LEFT JOIN project p1_ ON t0_.project_id = p1_.id WHERE ((t0_.user_id = ? AND (t0_.start_time >= ? OR t0_.end_time >= ?)) AND (t0_.start_time <= ? OR t0_.end_time <= ?)) AND t0_.category IN (?, ?) ORDER BY t0_.start_time ASC

[
  93
  "2026-04-01 00:00:00"
  "2026-04-01 00:00:00"
  "2026-04-25 23:59:59"
  "2026-04-25 23:59:59"
  "planning"
  "standby"
]

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,
  p1_.id AS id_17,
  p1_.projectnumber AS projectnumber_18,
  p1_.customer_id AS customer_id_19,
  p1_.name AS name_20,
  p1_.finishtime AS finishtime_21,
  p1_.status_id AS status_id_22,
  t0_.activity_id AS activity_id_23,
  t0_.requested_teamlead_id AS requested_teamlead_id_24,
  t0_.user_id AS user_id_25,
  t0_.project_id AS project_id_26
FROM
  timesheet t0_
  LEFT JOIN project p1_ ON t0_.project_id = p1_.id
WHERE
  (
    (
      t0_.user_id = ?
      AND (
        t0_.start_time >= ?
        OR t0_.end_time >= ?
      )
    )
    AND (
      t0_.start_time <= ?
      OR t0_.end_time <= ?
    )
  )
  AND t0_.category IN (?, ?)
ORDER BY
  t0_.start_time ASC

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, p1_.id AS id_17, p1_.projectnumber AS projectnumber_18, p1_.customer_id AS customer_id_19, p1_.name AS name_20, p1_.finishtime AS finishtime_21, p1_.status_id AS status_id_22, t0_.activity_id AS activity_id_23, t0_.requested_teamlead_id AS requested_teamlead_id_24, t0_.user_id AS user_id_25, t0_.project_id AS project_id_26 FROM timesheet t0_ LEFT JOIN project p1_ ON t0_.project_id = p1_.id WHERE ((t0_.user_id = 93 AND (t0_.start_time >= '2026-04-01 00:00:00' OR t0_.end_time >= '2026-04-01 00:00:00')) AND (t0_.start_time <= '2026-04-25 23:59:59' OR t0_.end_time <= '2026-04-25 23:59:59')) AND t0_.category IN ('planning', 'standby') ORDER BY t0_.start_time ASC;