Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.middle_name AS middle_name_3,
  t0.last_name AS last_name_4,
  t0.gender AS gender_5,
  t0.location AS location_6,
  t0.phone AS phone_7,
  t0.login AS login_8,
  t0.password AS password_9,
  t0.roles AS roles_10,
  t0.created_at AS created_at_11,
  t0.status AS status_12,
  t0.city_id AS city_id_13,
  t0.parking_id AS parking_id_14
FROM
  user t0
WHERE
  t0.login = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.middle_name AS middle_name_3, t0.last_name AS last_name_4, t0.gender AS gender_5, t0.location AS location_6, t0.phone AS phone_7, t0.login AS login_8, t0.password AS password_9, t0.roles AS roles_10, t0.created_at AS created_at_11, t0.status AS status_12, t0.city_id AS city_id_13, t0.parking_id AS parking_id_14 FROM user t0 WHERE t0.login = '0899843151' LIMIT 1;

SELECT
  b0_.created_by_id AS sclr_0,
  COUNT(b0_.id) AS sclr_1,
  COALESCE(
    SUM(b0_.amount),
    0
  ) AS sclr_2,
  COALESCE(b0_.parking_id, t1_.parking_id) AS sclr_3,
  MAX(
    COALESCE(p2_.name, p3_.name)
  ) AS sclr_4
FROM
  billet b0_
  INNER JOIN user u4_ ON b0_.created_by_id = u4_.id
  LEFT JOIN terminal t1_ ON b0_.terminal_id = t1_.id
  LEFT JOIN parking p2_ ON b0_.parking_id = p2_.id
  LEFT JOIN parking p3_ ON t1_.parking_id = p3_.id
WHERE
  b0_.created_at >= ?
  AND b0_.created_at < ?
GROUP BY
  u4_.id,
  p2_.id,
  p3_.id

SELECT b0_.created_by_id AS sclr_0, COUNT(b0_.id) AS sclr_1, COALESCE(SUM(b0_.amount), 0) AS sclr_2, COALESCE(b0_.parking_id, t1_.parking_id) AS sclr_3, MAX(COALESCE(p2_.name, p3_.name)) AS sclr_4 FROM billet b0_ INNER JOIN user u4_ ON b0_.created_by_id = u4_.id LEFT JOIN terminal t1_ ON b0_.terminal_id = t1_.id LEFT JOIN parking p2_ ON b0_.parking_id = p2_.id LEFT JOIN parking p3_ ON t1_.parking_id = p3_.id WHERE b0_.created_at >= '2026-07-02 00:00:00' AND b0_.created_at < '2026-07-03 00:00:00' GROUP BY u4_.id, p2_.id, p3_.id;

SELECT
  b0_.created_by_id AS sclr_0,
  t1_.code AS code_1,
  t1_.label AS label_2
FROM
  billet b0_
  LEFT JOIN terminal t1_ ON b0_.terminal_id = t1_.id
  LEFT JOIN parking p2_ ON b0_.parking_id = p2_.id
  LEFT JOIN parking p3_ ON t1_.parking_id = p3_.id
WHERE
  b0_.created_at >= ?
  AND b0_.created_at < ?
ORDER BY
  b0_.created_at DESC

SELECT b0_.created_by_id AS sclr_0, t1_.code AS code_1, t1_.label AS label_2 FROM billet b0_ LEFT JOIN terminal t1_ ON b0_.terminal_id = t1_.id LEFT JOIN parking p2_ ON b0_.parking_id = p2_.id LEFT JOIN parking p3_ ON t1_.parking_id = p3_.id WHERE b0_.created_at >= '2026-07-02 00:00:00' AND b0_.created_at < '2026-07-03 00:00:00' ORDER BY b0_.created_at DESC;

SELECT
  d0_.id AS id_0,
  d0_.report_date AS report_date_1,
  d0_.expected_amount AS expected_amount_2,
  d0_.reported_amount AS reported_amount_3,
  d0_.difference_amount AS difference_amount_4,
  d0_.ticket_count AS ticket_count_5,
  d0_.status AS status_6,
  d0_.workflow_status AS workflow_status_7,
  d0_.submitted_at AS submitted_at_8,
  d0_.notes AS notes_9,
  d0_.created_at AS created_at_10,
  d0_.updated_at AS updated_at_11,
  u1_.id AS id_12,
  u1_.first_name AS first_name_13,
  u1_.middle_name AS middle_name_14,
  u1_.last_name AS last_name_15,
  u1_.gender AS gender_16,
  u1_.location AS location_17,
  u1_.phone AS phone_18,
  u1_.login AS login_19,
  u1_.password AS password_20,
  u1_.roles AS roles_21,
  u1_.created_at AS created_at_22,
  u1_.status AS status_23,
  p2_.id AS id_24,
  p2_.code AS code_25,
  p2_.visible_roles AS visible_roles_26,
  p2_.name AS name_27,
  p2_.created_at AS created_at_28,
  d0_.agent_id AS agent_id_29,
  d0_.parking_id AS parking_id_30,
  u1_.city_id AS city_id_31,
  u1_.parking_id AS parking_id_32,
  p2_.created_by_id AS created_by_id_33,
  p2_.city_id AS city_id_34
FROM
  daily_report d0_
  LEFT JOIN user u1_ ON d0_.agent_id = u1_.id
  LEFT JOIN parking p2_ ON d0_.parking_id = p2_.id
WHERE
  d0_.report_date >= ?
  AND d0_.report_date < ?
ORDER BY
  p2_.name ASC,
  u1_.first_name ASC,
  u1_.last_name ASC

SELECT d0_.id AS id_0, d0_.report_date AS report_date_1, d0_.expected_amount AS expected_amount_2, d0_.reported_amount AS reported_amount_3, d0_.difference_amount AS difference_amount_4, d0_.ticket_count AS ticket_count_5, d0_.status AS status_6, d0_.workflow_status AS workflow_status_7, d0_.submitted_at AS submitted_at_8, d0_.notes AS notes_9, d0_.created_at AS created_at_10, d0_.updated_at AS updated_at_11, u1_.id AS id_12, u1_.first_name AS first_name_13, u1_.middle_name AS middle_name_14, u1_.last_name AS last_name_15, u1_.gender AS gender_16, u1_.location AS location_17, u1_.phone AS phone_18, u1_.login AS login_19, u1_.password AS password_20, u1_.roles AS roles_21, u1_.created_at AS created_at_22, u1_.status AS status_23, p2_.id AS id_24, p2_.code AS code_25, p2_.visible_roles AS visible_roles_26, p2_.name AS name_27, p2_.created_at AS created_at_28, d0_.agent_id AS agent_id_29, d0_.parking_id AS parking_id_30, u1_.city_id AS city_id_31, u1_.parking_id AS parking_id_32, p2_.created_by_id AS created_by_id_33, p2_.city_id AS city_id_34 FROM daily_report d0_ LEFT JOIN user u1_ ON d0_.agent_id = u1_.id LEFT JOIN parking p2_ ON d0_.parking_id = p2_.id WHERE d0_.report_date >= '2026-07-02 00:00:00' AND d0_.report_date < '2026-07-03 00:00:00' ORDER BY p2_.name ASC, u1_.first_name ASC, u1_.last_name ASC;

SELECT
  d0_.id AS id_0,
  d0_.report_date AS report_date_1,
  d0_.expected_amount AS expected_amount_2,
  d0_.reported_amount AS reported_amount_3,
  d0_.difference_amount AS difference_amount_4,
  d0_.ticket_count AS ticket_count_5,
  d0_.status AS status_6,
  d0_.workflow_status AS workflow_status_7,
  d0_.submitted_at AS submitted_at_8,
  d0_.notes AS notes_9,
  d0_.created_at AS created_at_10,
  d0_.updated_at AS updated_at_11,
  u1_.id AS id_12,
  u1_.first_name AS first_name_13,
  u1_.middle_name AS middle_name_14,
  u1_.last_name AS last_name_15,
  u1_.gender AS gender_16,
  u1_.location AS location_17,
  u1_.phone AS phone_18,
  u1_.login AS login_19,
  u1_.password AS password_20,
  u1_.roles AS roles_21,
  u1_.created_at AS created_at_22,
  u1_.status AS status_23,
  p2_.id AS id_24,
  p2_.code AS code_25,
  p2_.visible_roles AS visible_roles_26,
  p2_.name AS name_27,
  p2_.created_at AS created_at_28,
  d0_.agent_id AS agent_id_29,
  d0_.parking_id AS parking_id_30,
  u1_.city_id AS city_id_31,
  u1_.parking_id AS parking_id_32,
  p2_.created_by_id AS created_by_id_33,
  p2_.city_id AS city_id_34
FROM
  daily_report d0_
  LEFT JOIN user u1_ ON d0_.agent_id = u1_.id
  LEFT JOIN parking p2_ ON d0_.parking_id = p2_.id
WHERE
  d0_.report_date >= ?
  AND d0_.report_date < ?
ORDER BY
  p2_.name ASC,
  u1_.first_name ASC,
  u1_.last_name ASC

SELECT d0_.id AS id_0, d0_.report_date AS report_date_1, d0_.expected_amount AS expected_amount_2, d0_.reported_amount AS reported_amount_3, d0_.difference_amount AS difference_amount_4, d0_.ticket_count AS ticket_count_5, d0_.status AS status_6, d0_.workflow_status AS workflow_status_7, d0_.submitted_at AS submitted_at_8, d0_.notes AS notes_9, d0_.created_at AS created_at_10, d0_.updated_at AS updated_at_11, u1_.id AS id_12, u1_.first_name AS first_name_13, u1_.middle_name AS middle_name_14, u1_.last_name AS last_name_15, u1_.gender AS gender_16, u1_.location AS location_17, u1_.phone AS phone_18, u1_.login AS login_19, u1_.password AS password_20, u1_.roles AS roles_21, u1_.created_at AS created_at_22, u1_.status AS status_23, p2_.id AS id_24, p2_.code AS code_25, p2_.visible_roles AS visible_roles_26, p2_.name AS name_27, p2_.created_at AS created_at_28, d0_.agent_id AS agent_id_29, d0_.parking_id AS parking_id_30, u1_.city_id AS city_id_31, u1_.parking_id AS parking_id_32, p2_.created_by_id AS created_by_id_33, p2_.city_id AS city_id_34 FROM daily_report d0_ LEFT JOIN user u1_ ON d0_.agent_id = u1_.id LEFT JOIN parking p2_ ON d0_.parking_id = p2_.id WHERE d0_.report_date >= '2026-07-02 00:00:00' AND d0_.report_date < '2026-07-03 00:00:00' ORDER BY p2_.name ASC, u1_.first_name ASC, u1_.last_name ASC;

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.middle_name AS middle_name_3,
  t0.last_name AS last_name_4,
  t0.gender AS gender_5,
  t0.location AS location_6,
  t0.phone AS phone_7,
  t0.login AS login_8,
  t0.password AS password_9,
  t0.roles AS roles_10,
  t0.created_at AS created_at_11,
  t0.status AS status_12,
  t0.city_id AS city_id_13,
  t0.parking_id AS parking_id_14
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.middle_name AS middle_name_3, t0.last_name AS last_name_4, t0.gender AS gender_5, t0.location AS location_6, t0.phone AS phone_7, t0.login AS login_8, t0.password AS password_9, t0.roles AS roles_10, t0.created_at AS created_at_11, t0.status AS status_12, t0.city_id AS city_id_13, t0.parking_id AS parking_id_14 FROM user t0 WHERE t0.id = 12;

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.middle_name AS middle_name_3,
  t0.last_name AS last_name_4,
  t0.gender AS gender_5,
  t0.location AS location_6,
  t0.phone AS phone_7,
  t0.login AS login_8,
  t0.password AS password_9,
  t0.roles AS roles_10,
  t0.created_at AS created_at_11,
  t0.status AS status_12,
  t0.city_id AS city_id_13,
  t0.parking_id AS parking_id_14
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.middle_name AS middle_name_3, t0.last_name AS last_name_4, t0.gender AS gender_5, t0.location AS location_6, t0.phone AS phone_7, t0.login AS login_8, t0.password AS password_9, t0.roles AS roles_10, t0.created_at AS created_at_11, t0.status AS status_12, t0.city_id AS city_id_13, t0.parking_id AS parking_id_14 FROM user t0 WHERE t0.id = 14;

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.middle_name AS middle_name_3,
  t0.last_name AS last_name_4,
  t0.gender AS gender_5,
  t0.location AS location_6,
  t0.phone AS phone_7,
  t0.login AS login_8,
  t0.password AS password_9,
  t0.roles AS roles_10,
  t0.created_at AS created_at_11,
  t0.status AS status_12,
  t0.city_id AS city_id_13,
  t0.parking_id AS parking_id_14
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.middle_name AS middle_name_3, t0.last_name AS last_name_4, t0.gender AS gender_5, t0.location AS location_6, t0.phone AS phone_7, t0.login AS login_8, t0.password AS password_9, t0.roles AS roles_10, t0.created_at AS created_at_11, t0.status AS status_12, t0.city_id AS city_id_13, t0.parking_id AS parking_id_14 FROM user t0 WHERE t0.id = 16;

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.middle_name AS middle_name_3,
  t0.last_name AS last_name_4,
  t0.gender AS gender_5,
  t0.location AS location_6,
  t0.phone AS phone_7,
  t0.login AS login_8,
  t0.password AS password_9,
  t0.roles AS roles_10,
  t0.created_at AS created_at_11,
  t0.status AS status_12,
  t0.city_id AS city_id_13,
  t0.parking_id AS parking_id_14
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.middle_name AS middle_name_3, t0.last_name AS last_name_4, t0.gender AS gender_5, t0.location AS location_6, t0.phone AS phone_7, t0.login AS login_8, t0.password AS password_9, t0.roles AS roles_10, t0.created_at AS created_at_11, t0.status AS status_12, t0.city_id AS city_id_13, t0.parking_id AS parking_id_14 FROM user t0 WHERE t0.id = 17;

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.middle_name AS middle_name_3,
  t0.last_name AS last_name_4,
  t0.gender AS gender_5,
  t0.location AS location_6,
  t0.phone AS phone_7,
  t0.login AS login_8,
  t0.password AS password_9,
  t0.roles AS roles_10,
  t0.created_at AS created_at_11,
  t0.status AS status_12,
  t0.city_id AS city_id_13,
  t0.parking_id AS parking_id_14
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.middle_name AS middle_name_3, t0.last_name AS last_name_4, t0.gender AS gender_5, t0.location AS location_6, t0.phone AS phone_7, t0.login AS login_8, t0.password AS password_9, t0.roles AS roles_10, t0.created_at AS created_at_11, t0.status AS status_12, t0.city_id AS city_id_13, t0.parking_id AS parking_id_14 FROM user t0 WHERE t0.id = 18;

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.middle_name AS middle_name_3,
  t0.last_name AS last_name_4,
  t0.gender AS gender_5,
  t0.location AS location_6,
  t0.phone AS phone_7,
  t0.login AS login_8,
  t0.password AS password_9,
  t0.roles AS roles_10,
  t0.created_at AS created_at_11,
  t0.status AS status_12,
  t0.city_id AS city_id_13,
  t0.parking_id AS parking_id_14
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.middle_name AS middle_name_3, t0.last_name AS last_name_4, t0.gender AS gender_5, t0.location AS location_6, t0.phone AS phone_7, t0.login AS login_8, t0.password AS password_9, t0.roles AS roles_10, t0.created_at AS created_at_11, t0.status AS status_12, t0.city_id AS city_id_13, t0.parking_id AS parking_id_14 FROM user t0 WHERE t0.id = 20;

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.middle_name AS middle_name_3,
  t0.last_name AS last_name_4,
  t0.gender AS gender_5,
  t0.location AS location_6,
  t0.phone AS phone_7,
  t0.login AS login_8,
  t0.password AS password_9,
  t0.roles AS roles_10,
  t0.created_at AS created_at_11,
  t0.status AS status_12,
  t0.city_id AS city_id_13,
  t0.parking_id AS parking_id_14
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.middle_name AS middle_name_3, t0.last_name AS last_name_4, t0.gender AS gender_5, t0.location AS location_6, t0.phone AS phone_7, t0.login AS login_8, t0.password AS password_9, t0.roles AS roles_10, t0.created_at AS created_at_11, t0.status AS status_12, t0.city_id AS city_id_13, t0.parking_id AS parking_id_14 FROM user t0 WHERE t0.id = 21;

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.middle_name AS middle_name_3,
  t0.last_name AS last_name_4,
  t0.gender AS gender_5,
  t0.location AS location_6,
  t0.phone AS phone_7,
  t0.login AS login_8,
  t0.password AS password_9,
  t0.roles AS roles_10,
  t0.created_at AS created_at_11,
  t0.status AS status_12,
  t0.city_id AS city_id_13,
  t0.parking_id AS parking_id_14
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.middle_name AS middle_name_3, t0.last_name AS last_name_4, t0.gender AS gender_5, t0.location AS location_6, t0.phone AS phone_7, t0.login AS login_8, t0.password AS password_9, t0.roles AS roles_10, t0.created_at AS created_at_11, t0.status AS status_12, t0.city_id AS city_id_13, t0.parking_id AS parking_id_14 FROM user t0 WHERE t0.id = 22;

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.middle_name AS middle_name_3,
  t0.last_name AS last_name_4,
  t0.gender AS gender_5,
  t0.location AS location_6,
  t0.phone AS phone_7,
  t0.login AS login_8,
  t0.password AS password_9,
  t0.roles AS roles_10,
  t0.created_at AS created_at_11,
  t0.status AS status_12,
  t0.city_id AS city_id_13,
  t0.parking_id AS parking_id_14
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.middle_name AS middle_name_3, t0.last_name AS last_name_4, t0.gender AS gender_5, t0.location AS location_6, t0.phone AS phone_7, t0.login AS login_8, t0.password AS password_9, t0.roles AS roles_10, t0.created_at AS created_at_11, t0.status AS status_12, t0.city_id AS city_id_13, t0.parking_id AS parking_id_14 FROM user t0 WHERE t0.id = 24;

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.middle_name AS middle_name_3,
  t0.last_name AS last_name_4,
  t0.gender AS gender_5,
  t0.location AS location_6,
  t0.phone AS phone_7,
  t0.login AS login_8,
  t0.password AS password_9,
  t0.roles AS roles_10,
  t0.created_at AS created_at_11,
  t0.status AS status_12,
  t0.city_id AS city_id_13,
  t0.parking_id AS parking_id_14
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.middle_name AS middle_name_3, t0.last_name AS last_name_4, t0.gender AS gender_5, t0.location AS location_6, t0.phone AS phone_7, t0.login AS login_8, t0.password AS password_9, t0.roles AS roles_10, t0.created_at AS created_at_11, t0.status AS status_12, t0.city_id AS city_id_13, t0.parking_id AS parking_id_14 FROM user t0 WHERE t0.id = 25;

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.middle_name AS middle_name_3,
  t0.last_name AS last_name_4,
  t0.gender AS gender_5,
  t0.location AS location_6,
  t0.phone AS phone_7,
  t0.login AS login_8,
  t0.password AS password_9,
  t0.roles AS roles_10,
  t0.created_at AS created_at_11,
  t0.status AS status_12,
  t0.city_id AS city_id_13,
  t0.parking_id AS parking_id_14
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.middle_name AS middle_name_3, t0.last_name AS last_name_4, t0.gender AS gender_5, t0.location AS location_6, t0.phone AS phone_7, t0.login AS login_8, t0.password AS password_9, t0.roles AS roles_10, t0.created_at AS created_at_11, t0.status AS status_12, t0.city_id AS city_id_13, t0.parking_id AS parking_id_14 FROM user t0 WHERE t0.id = 26;