Symfony Profiler

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

Query Metrics

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

[
  50
  "2026-02-26 00:00:00"
  "2026-02-26 00:00:00"
  "2026-03-31 23:59:59"
  "2026-03-31 23:59:59"
  "absence"
  "work"
]

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 = 50 AND (t0_.start_time >= '2026-02-26 00:00:00' OR t0_.end_time >= '2026-02-26 00:00:00')) AND (t0_.start_time <= '2026-03-31 23:59:59' OR t0_.end_time <= '2026-03-31 23:59:59')) AND t0_.category IN ('absence', 'work') ORDER BY t0_.start_time ASC;

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

[
  50
  60
  "2026-03-02 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 = 50 AND t0.duration = 60) AND t0.end_time >= '2026-03-02 00:00:00');

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

[
  "Pause"
]

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

SELECT c0_.id AS id_0, c0_.name AS name_1 FROM customer c0_ WHERE c0_.id = ?

[
  "66"
]

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1
FROM
  customer c0_
WHERE
  c0_.id = ?

SELECT c0_.id AS id_0, c0_.name AS name_1 FROM customer c0_ WHERE c0_.id = '66';

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

[
  "rpaschy"
]

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

SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.shortcut AS shortcut_4, t0.teamlead_approval AS teamlead_approval_5, t0.category AS category_6, t0.timesheet_option AS timesheet_option_7 FROM activity t0 WHERE t0.id = ?

[
  2
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.color AS color_3,
  t0.shortcut AS shortcut_4,
  t0.teamlead_approval AS teamlead_approval_5,
  t0.category AS category_6,
  t0.timesheet_option AS timesheet_option_7
FROM
  activity t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.shortcut AS shortcut_4, t0.teamlead_approval AS teamlead_approval_5, t0.category AS category_6, t0.timesheet_option AS timesheet_option_7 FROM activity t0 WHERE t0.id = 2;

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

[
  50
  "ü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 = 50 AND t0.status = 'überfällig');

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

[
  50
]

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