Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.message AS message_2,
  t0.firstname AS firstname_3,
  t0.lastname AS lastname_4,
  t0.created AS created_5,
  t0.updated AS updated_6,
  t0.leave_id AS leave_id_7
FROM
  notification t0
WHERE
  t0.leave_id = ?

SELECT t0.id AS id_1, t0.message AS message_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.created AS created_5, t0.updated AS updated_6, t0.leave_id AS leave_id_7 FROM notification t0 WHERE t0.leave_id = 2596;

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.image_size AS image_size_3,
  t0.updated AS updated_4,
  t0.leave_id AS leave_id_5
FROM
  certificates t0
WHERE
  t0.leave_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.updated AS updated_4, t0.leave_id AS leave_id_5 FROM certificates t0 WHERE t0.leave_id = 2596;

SELECT
  e0_.id AS id_0,
  e0_.firstname AS firstname_1,
  e0_.lastname AS lastname_2,
  e0_.email AS email_3,
  e0_.username AS username_4,
  e0_.fingerprintid AS fingerprintid_5,
  e0_.fingerprintname AS fingerprintname_6,
  e0_.password AS password_7,
  e0_.phone AS phone_8,
  e0_.fixedline AS fixedline_9,
  e0_.roles AS roles_10,
  e0_.status AS status_11,
  e0_.is_vacation_allowed AS is_vacation_allowed_12,
  e0_.schedule_used AS schedule_used_13,
  e0_.casual_used AS casual_used_14,
  e0_.vacation_used AS vacation_used_15,
  e0_.wfh_used AS wfh_used_16,
  e0_.past_schedule_used AS past_schedule_used_17,
  e0_.past_casual_used AS past_casual_used_18,
  e0_.last_year_schedule_used AS last_year_schedule_used_19,
  e0_.last_year_casual_used AS last_year_casual_used_20,
  e0_.schedule_remaining AS schedule_remaining_21,
  e0_.casual_remaining AS casual_remaining_22,
  e0_.vacation_remaining AS vacation_remaining_23,
  e0_.total_schedule_used AS total_schedule_used_24,
  e0_.total_casual_used AS total_casual_used_25,
  e0_.total_schedule AS total_schedule_26,
  e0_.total_casual AS total_casual_27,
  e0_.created AS created_28,
  e0_.updated AS updated_29,
  e0_.slug AS slug_30,
  l1_.id AS id_31,
  l1_.start_date AS start_date_32,
  l1_.end_date AS end_date_33,
  l1_.count AS count_34,
  l1_.approved_start_date AS approved_start_date_35,
  l1_.approved_end_date AS approved_end_date_36,
  l1_.approved_count AS approved_count_37,
  l1_.reason AS reason_38,
  l1_.reject_reason AS reject_reason_39,
  l1_.is_half_day AS is_half_day_40,
  l1_.is_schedule_leave AS is_schedule_leave_41,
  l1_.category AS category_42,
  l1_.is_active AS is_active_43,
  l1_.type AS type_44,
  l1_.certificate AS certificate_45,
  l1_.status AS status_46,
  l1_.is_manager_added AS is_manager_added_47,
  l1_.is_ceo_added AS is_ceo_added_48,
  l1_.is_fingerprint_leave AS is_fingerprint_leave_49,
  l1_.created AS created_50,
  l1_.updated AS updated_51,
  l1_.slug AS slug_52,
  e0_.team_id AS team_id_53,
  l1_.emp_id AS emp_id_54,
  l1_.approver_id AS approver_id_55
FROM
  employee e0_
  INNER JOIN leaves l1_ ON e0_.id = l1_.emp_id
  AND (
    (
      (
        l1_.start_date >= ?
        OR l1_.end_date >= ?
      )
      AND (
        (
          l1_.status BETWEEN 1
          AND 2
        )
        OR (
          l1_.status BETWEEN 5
          AND 7
        )
      )
    )
    OR (
      (
        l1_.start_date >= ?
        OR l1_.end_date >= ?
      )
      AND (
        (
          l1_.status BETWEEN 1
          AND 2
        )
        OR (
          l1_.status BETWEEN 5
          AND 7
        )
      )
    )
  )
WHERE
  e0_.roles NOT LIKE ?
  AND e0_.roles NOT LIKE ?

SELECT e0_.id AS id_0, e0_.firstname AS firstname_1, e0_.lastname AS lastname_2, e0_.email AS email_3, e0_.username AS username_4, e0_.fingerprintid AS fingerprintid_5, e0_.fingerprintname AS fingerprintname_6, e0_.password AS password_7, e0_.phone AS phone_8, e0_.fixedline AS fixedline_9, e0_.roles AS roles_10, e0_.status AS status_11, e0_.is_vacation_allowed AS is_vacation_allowed_12, e0_.schedule_used AS schedule_used_13, e0_.casual_used AS casual_used_14, e0_.vacation_used AS vacation_used_15, e0_.wfh_used AS wfh_used_16, e0_.past_schedule_used AS past_schedule_used_17, e0_.past_casual_used AS past_casual_used_18, e0_.last_year_schedule_used AS last_year_schedule_used_19, e0_.last_year_casual_used AS last_year_casual_used_20, e0_.schedule_remaining AS schedule_remaining_21, e0_.casual_remaining AS casual_remaining_22, e0_.vacation_remaining AS vacation_remaining_23, e0_.total_schedule_used AS total_schedule_used_24, e0_.total_casual_used AS total_casual_used_25, e0_.total_schedule AS total_schedule_26, e0_.total_casual AS total_casual_27, e0_.created AS created_28, e0_.updated AS updated_29, e0_.slug AS slug_30, l1_.id AS id_31, l1_.start_date AS start_date_32, l1_.end_date AS end_date_33, l1_.count AS count_34, l1_.approved_start_date AS approved_start_date_35, l1_.approved_end_date AS approved_end_date_36, l1_.approved_count AS approved_count_37, l1_.reason AS reason_38, l1_.reject_reason AS reject_reason_39, l1_.is_half_day AS is_half_day_40, l1_.is_schedule_leave AS is_schedule_leave_41, l1_.category AS category_42, l1_.is_active AS is_active_43, l1_.type AS type_44, l1_.certificate AS certificate_45, l1_.status AS status_46, l1_.is_manager_added AS is_manager_added_47, l1_.is_ceo_added AS is_ceo_added_48, l1_.is_fingerprint_leave AS is_fingerprint_leave_49, l1_.created AS created_50, l1_.updated AS updated_51, l1_.slug AS slug_52, e0_.team_id AS team_id_53, l1_.emp_id AS emp_id_54, l1_.approver_id AS approver_id_55 FROM employee e0_ INNER JOIN leaves l1_ ON e0_.id = l1_.emp_id AND (((l1_.start_date >= '2025-01-11' OR l1_.end_date >= '2025-01-11') AND ((l1_.status BETWEEN 1 AND 2) OR (l1_.status BETWEEN 5 AND 7))) OR ((l1_.start_date >= '2025-01-11' OR l1_.end_date >= '2025-01-11') AND ((l1_.status BETWEEN 1 AND 2) OR (l1_.status BETWEEN 5 AND 7)))) WHERE e0_.roles NOT LIKE '%\"ROLE_CEO\"%' AND e0_.roles NOT LIKE '%\"ROLE_ADMIN\"%';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.email AS email_3,
  t0.password AS password_4,
  t0.created AS created_5,
  t0.updated AS updated_6,
  t0.slug AS slug_7,
  t0.employ_id AS employ_id_8,
  t0.inviter_id AS inviter_id_9
FROM
  invite t0
WHERE
  t0.employ_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.password AS password_4, t0.created AS created_5, t0.updated AS updated_6, t0.slug AS slug_7, t0.employ_id AS employ_id_8, t0.inviter_id AS inviter_id_9 FROM invite t0 WHERE t0.employ_id = 57;

SELECT
  e0_.id AS id_0,
  e0_.firstname AS firstname_1,
  e0_.lastname AS lastname_2,
  e0_.email AS email_3,
  e0_.username AS username_4,
  e0_.fingerprintid AS fingerprintid_5,
  e0_.fingerprintname AS fingerprintname_6,
  e0_.password AS password_7,
  e0_.phone AS phone_8,
  e0_.fixedline AS fixedline_9,
  e0_.roles AS roles_10,
  e0_.status AS status_11,
  e0_.is_vacation_allowed AS is_vacation_allowed_12,
  e0_.schedule_used AS schedule_used_13,
  e0_.casual_used AS casual_used_14,
  e0_.vacation_used AS vacation_used_15,
  e0_.wfh_used AS wfh_used_16,
  e0_.past_schedule_used AS past_schedule_used_17,
  e0_.past_casual_used AS past_casual_used_18,
  e0_.last_year_schedule_used AS last_year_schedule_used_19,
  e0_.last_year_casual_used AS last_year_casual_used_20,
  e0_.schedule_remaining AS schedule_remaining_21,
  e0_.casual_remaining AS casual_remaining_22,
  e0_.vacation_remaining AS vacation_remaining_23,
  e0_.total_schedule_used AS total_schedule_used_24,
  e0_.total_casual_used AS total_casual_used_25,
  e0_.total_schedule AS total_schedule_26,
  e0_.total_casual AS total_casual_27,
  e0_.created AS created_28,
  e0_.updated AS updated_29,
  e0_.slug AS slug_30,
  l1_.id AS id_31,
  l1_.start_date AS start_date_32,
  l1_.end_date AS end_date_33,
  l1_.count AS count_34,
  l1_.approved_start_date AS approved_start_date_35,
  l1_.approved_end_date AS approved_end_date_36,
  l1_.approved_count AS approved_count_37,
  l1_.reason AS reason_38,
  l1_.reject_reason AS reject_reason_39,
  l1_.is_half_day AS is_half_day_40,
  l1_.is_schedule_leave AS is_schedule_leave_41,
  l1_.category AS category_42,
  l1_.is_active AS is_active_43,
  l1_.type AS type_44,
  l1_.certificate AS certificate_45,
  l1_.status AS status_46,
  l1_.is_manager_added AS is_manager_added_47,
  l1_.is_ceo_added AS is_ceo_added_48,
  l1_.is_fingerprint_leave AS is_fingerprint_leave_49,
  l1_.created AS created_50,
  l1_.updated AS updated_51,
  l1_.slug AS slug_52,
  e0_.team_id AS team_id_53,
  l1_.emp_id AS emp_id_54,
  l1_.approver_id AS approver_id_55
FROM
  employee e0_
  INNER JOIN grp_team g2_ ON e0_.team_id = g2_.id
  AND (g2_.id = 13)
  INNER JOIN leaves l1_ ON e0_.id = l1_.emp_id
  AND (
    (
      (
        l1_.start_date >= ?
        OR l1_.end_date >= ?
      )
      AND (
        (
          l1_.status BETWEEN 1
          AND 2
        )
        OR (
          l1_.status BETWEEN 5
          AND 7
        )
      )
    )
    OR (
      (
        l1_.start_date >= ?
        OR l1_.end_date >= ?
      )
      AND (
        (
          l1_.status BETWEEN 1
          AND 2
        )
        OR (
          l1_.status BETWEEN 5
          AND 7
        )
      )
    )
  )
WHERE
  e0_.roles NOT LIKE ?
  AND e0_.roles NOT LIKE ?

SELECT e0_.id AS id_0, e0_.firstname AS firstname_1, e0_.lastname AS lastname_2, e0_.email AS email_3, e0_.username AS username_4, e0_.fingerprintid AS fingerprintid_5, e0_.fingerprintname AS fingerprintname_6, e0_.password AS password_7, e0_.phone AS phone_8, e0_.fixedline AS fixedline_9, e0_.roles AS roles_10, e0_.status AS status_11, e0_.is_vacation_allowed AS is_vacation_allowed_12, e0_.schedule_used AS schedule_used_13, e0_.casual_used AS casual_used_14, e0_.vacation_used AS vacation_used_15, e0_.wfh_used AS wfh_used_16, e0_.past_schedule_used AS past_schedule_used_17, e0_.past_casual_used AS past_casual_used_18, e0_.last_year_schedule_used AS last_year_schedule_used_19, e0_.last_year_casual_used AS last_year_casual_used_20, e0_.schedule_remaining AS schedule_remaining_21, e0_.casual_remaining AS casual_remaining_22, e0_.vacation_remaining AS vacation_remaining_23, e0_.total_schedule_used AS total_schedule_used_24, e0_.total_casual_used AS total_casual_used_25, e0_.total_schedule AS total_schedule_26, e0_.total_casual AS total_casual_27, e0_.created AS created_28, e0_.updated AS updated_29, e0_.slug AS slug_30, l1_.id AS id_31, l1_.start_date AS start_date_32, l1_.end_date AS end_date_33, l1_.count AS count_34, l1_.approved_start_date AS approved_start_date_35, l1_.approved_end_date AS approved_end_date_36, l1_.approved_count AS approved_count_37, l1_.reason AS reason_38, l1_.reject_reason AS reject_reason_39, l1_.is_half_day AS is_half_day_40, l1_.is_schedule_leave AS is_schedule_leave_41, l1_.category AS category_42, l1_.is_active AS is_active_43, l1_.type AS type_44, l1_.certificate AS certificate_45, l1_.status AS status_46, l1_.is_manager_added AS is_manager_added_47, l1_.is_ceo_added AS is_ceo_added_48, l1_.is_fingerprint_leave AS is_fingerprint_leave_49, l1_.created AS created_50, l1_.updated AS updated_51, l1_.slug AS slug_52, e0_.team_id AS team_id_53, l1_.emp_id AS emp_id_54, l1_.approver_id AS approver_id_55 FROM employee e0_ INNER JOIN grp_team g2_ ON e0_.team_id = g2_.id AND (g2_.id = 13) INNER JOIN leaves l1_ ON e0_.id = l1_.emp_id AND (((l1_.start_date >= '2025-01-11' OR l1_.end_date >= '2025-01-11') AND ((l1_.status BETWEEN 1 AND 2) OR (l1_.status BETWEEN 5 AND 7))) OR ((l1_.start_date >= '2025-01-11' OR l1_.end_date >= '2025-01-11') AND ((l1_.status BETWEEN 1 AND 2) OR (l1_.status BETWEEN 5 AND 7)))) WHERE e0_.roles NOT LIKE '%\"ROLE_CEO\"%' AND e0_.roles NOT LIKE '%\"ROLE_ADMIN\"%';

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.email AS email_4,
  t0.username AS username_5,
  t0.fingerprintid AS fingerprintid_6,
  t0.fingerprintname AS fingerprintname_7,
  t0.password AS password_8,
  t0.phone AS phone_9,
  t0.fixedline AS fixedline_10,
  t0.roles AS roles_11,
  t0.status AS status_12,
  t0.is_vacation_allowed AS is_vacation_allowed_13,
  t0.schedule_used AS schedule_used_14,
  t0.casual_used AS casual_used_15,
  t0.vacation_used AS vacation_used_16,
  t0.wfh_used AS wfh_used_17,
  t0.past_schedule_used AS past_schedule_used_18,
  t0.past_casual_used AS past_casual_used_19,
  t0.last_year_schedule_used AS last_year_schedule_used_20,
  t0.last_year_casual_used AS last_year_casual_used_21,
  t0.schedule_remaining AS schedule_remaining_22,
  t0.casual_remaining AS casual_remaining_23,
  t0.vacation_remaining AS vacation_remaining_24,
  t0.total_schedule_used AS total_schedule_used_25,
  t0.total_casual_used AS total_casual_used_26,
  t0.total_schedule AS total_schedule_27,
  t0.total_casual AS total_casual_28,
  t0.created AS created_29,
  t0.updated AS updated_30,
  t0.slug AS slug_31,
  t0.team_id AS team_id_32,
  t33.id AS id_34,
  t33.name AS name_35,
  t33.email AS email_36,
  t33.password AS password_37,
  t33.created AS created_38,
  t33.updated AS updated_39,
  t33.slug AS slug_40,
  t33.employ_id AS employ_id_41,
  t33.inviter_id AS inviter_id_42
FROM
  employee t0
  LEFT JOIN invite t33 ON t33.employ_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.username AS username_5, t0.fingerprintid AS fingerprintid_6, t0.fingerprintname AS fingerprintname_7, t0.password AS password_8, t0.phone AS phone_9, t0.fixedline AS fixedline_10, t0.roles AS roles_11, t0.status AS status_12, t0.is_vacation_allowed AS is_vacation_allowed_13, t0.schedule_used AS schedule_used_14, t0.casual_used AS casual_used_15, t0.vacation_used AS vacation_used_16, t0.wfh_used AS wfh_used_17, t0.past_schedule_used AS past_schedule_used_18, t0.past_casual_used AS past_casual_used_19, t0.last_year_schedule_used AS last_year_schedule_used_20, t0.last_year_casual_used AS last_year_casual_used_21, t0.schedule_remaining AS schedule_remaining_22, t0.casual_remaining AS casual_remaining_23, t0.vacation_remaining AS vacation_remaining_24, t0.total_schedule_used AS total_schedule_used_25, t0.total_casual_used AS total_casual_used_26, t0.total_schedule AS total_schedule_27, t0.total_casual AS total_casual_28, t0.created AS created_29, t0.updated AS updated_30, t0.slug AS slug_31, t0.team_id AS team_id_32, t33.id AS id_34, t33.name AS name_35, t33.email AS email_36, t33.password AS password_37, t33.created AS created_38, t33.updated AS updated_39, t33.slug AS slug_40, t33.employ_id AS employ_id_41, t33.inviter_id AS inviter_id_42 FROM employee t0 LEFT JOIN invite t33 ON t33.employ_id = t0.id WHERE t0.id = 1;

SELECT
  e0_.id AS id_0,
  e0_.firstname AS firstname_1,
  e0_.lastname AS lastname_2,
  e0_.email AS email_3,
  e0_.username AS username_4,
  e0_.fingerprintid AS fingerprintid_5,
  e0_.fingerprintname AS fingerprintname_6,
  e0_.password AS password_7,
  e0_.phone AS phone_8,
  e0_.fixedline AS fixedline_9,
  e0_.roles AS roles_10,
  e0_.status AS status_11,
  e0_.is_vacation_allowed AS is_vacation_allowed_12,
  e0_.schedule_used AS schedule_used_13,
  e0_.casual_used AS casual_used_14,
  e0_.vacation_used AS vacation_used_15,
  e0_.wfh_used AS wfh_used_16,
  e0_.past_schedule_used AS past_schedule_used_17,
  e0_.past_casual_used AS past_casual_used_18,
  e0_.last_year_schedule_used AS last_year_schedule_used_19,
  e0_.last_year_casual_used AS last_year_casual_used_20,
  e0_.schedule_remaining AS schedule_remaining_21,
  e0_.casual_remaining AS casual_remaining_22,
  e0_.vacation_remaining AS vacation_remaining_23,
  e0_.total_schedule_used AS total_schedule_used_24,
  e0_.total_casual_used AS total_casual_used_25,
  e0_.total_schedule AS total_schedule_26,
  e0_.total_casual AS total_casual_27,
  e0_.created AS created_28,
  e0_.updated AS updated_29,
  e0_.slug AS slug_30,
  e0_.team_id AS team_id_31
FROM
  employee e0_
WHERE
  e0_.username = ?
  OR e0_.email = ?

SELECT e0_.id AS id_0, e0_.firstname AS firstname_1, e0_.lastname AS lastname_2, e0_.email AS email_3, e0_.username AS username_4, e0_.fingerprintid AS fingerprintid_5, e0_.fingerprintname AS fingerprintname_6, e0_.password AS password_7, e0_.phone AS phone_8, e0_.fixedline AS fixedline_9, e0_.roles AS roles_10, e0_.status AS status_11, e0_.is_vacation_allowed AS is_vacation_allowed_12, e0_.schedule_used AS schedule_used_13, e0_.casual_used AS casual_used_14, e0_.vacation_used AS vacation_used_15, e0_.wfh_used AS wfh_used_16, e0_.past_schedule_used AS past_schedule_used_17, e0_.past_casual_used AS past_casual_used_18, e0_.last_year_schedule_used AS last_year_schedule_used_19, e0_.last_year_casual_used AS last_year_casual_used_20, e0_.schedule_remaining AS schedule_remaining_21, e0_.casual_remaining AS casual_remaining_22, e0_.vacation_remaining AS vacation_remaining_23, e0_.total_schedule_used AS total_schedule_used_24, e0_.total_casual_used AS total_casual_used_25, e0_.total_schedule AS total_schedule_26, e0_.total_casual AS total_casual_27, e0_.created AS created_28, e0_.updated AS updated_29, e0_.slug AS slug_30, e0_.team_id AS team_id_31 FROM employee e0_ WHERE e0_.username = 'Sonia' OR e0_.email = 'Sonia';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created AS created_3,
  t0.updated AS updated_4,
  t0.slug AS slug_5,
  t0.agency_id AS agency_id_6,
  t0.manager_id AS manager_id_7
FROM
  grp_team t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.created AS created_3, t0.updated AS updated_4, t0.slug AS slug_5, t0.agency_id AS agency_id_6, t0.manager_id AS manager_id_7 FROM grp_team t0 WHERE t0.id = 13;