Symfony Profiler

SELECT
  t0.uuid AS uuid_1,
  t0.lastname AS lastname_2,
  t0.firstname AS firstname_3,
  t0.phone AS phone_4,
  t0.address AS address_5,
  t0.city AS city_6,
  t0.postal_code AS postal_code_7,
  t0.country AS country_8,
  t0.email AS email_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.sales_rep_uuid AS sales_rep_uuid_12,
  t0.telemarketer_uuid AS telemarketer_uuid_13
FROM
  customer t0
WHERE
  t0.uuid = ?

SELECT t0.uuid AS uuid_1, t0.lastname AS lastname_2, t0.firstname AS firstname_3, t0.phone AS phone_4, t0.address AS address_5, t0.city AS city_6, t0.postal_code AS postal_code_7, t0.country AS country_8, t0.email AS email_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.sales_rep_uuid AS sales_rep_uuid_12, t0.telemarketer_uuid AS telemarketer_uuid_13 FROM customer t0 WHERE t0.uuid = 0x019C7A627B917331A52D5B056AA12A1E;

SELECT
  t0.uuid AS uuid_1,
  t0.comment AS comment_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.appointment_uuid AS appointment_uuid_5
FROM
  appointment_signed t0
WHERE
  t0.appointment_uuid = ?

SELECT t0.uuid AS uuid_1, t0.comment AS comment_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.appointment_uuid AS appointment_uuid_5 FROM appointment_signed t0 WHERE t0.appointment_uuid = 0x019C8A05FAF3701FB0C1A1B5565C3098;

SELECT
  t0.uuid AS uuid_1,
  t0.comment AS comment_2,
  t0.date_start AS date_start_3,
  t0.date_end AS date_end_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.status AS status_7,
  t0.address AS address_8,
  t0.postal_code AS postal_code_9,
  t0.city AS city_10,
  t0.country AS country_11,
  t0.appointment_uuid AS appointment_uuid_12,
  t13.uuid AS uuid_14,
  t13.reason AS reason_15,
  t13.created_at AS created_at_16,
  t13.updated_at AS updated_at_17,
  t13.appointment_technical_visit_uuid AS appointment_technical_visit_uuid_18
FROM
  appointment_technical_visit t0
  LEFT JOIN appointment_technical_visit_cancelled t13 ON t13.appointment_technical_visit_uuid = t0.uuid
WHERE
  t0.appointment_uuid = ?

SELECT t0.uuid AS uuid_1, t0.comment AS comment_2, t0.date_start AS date_start_3, t0.date_end AS date_end_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.status AS status_7, t0.address AS address_8, t0.postal_code AS postal_code_9, t0.city AS city_10, t0.country AS country_11, t0.appointment_uuid AS appointment_uuid_12, t13.uuid AS uuid_14, t13.reason AS reason_15, t13.created_at AS created_at_16, t13.updated_at AS updated_at_17, t13.appointment_technical_visit_uuid AS appointment_technical_visit_uuid_18 FROM appointment_technical_visit t0 LEFT JOIN appointment_technical_visit_cancelled t13 ON t13.appointment_technical_visit_uuid = t0.uuid WHERE t0.appointment_uuid = 0x019C8A05FAF3701FB0C1A1B5565C3098;

SELECT
  t0.uuid AS uuid_1,
  t0.reason AS reason_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.appointment_uuid AS appointment_uuid_5,
  t0.appointment_technical_visit_uuid AS appointment_technical_visit_uuid_6
FROM
  appointment_cancelled t0
WHERE
  t0.appointment_uuid = ?

SELECT t0.uuid AS uuid_1, t0.reason AS reason_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.appointment_uuid AS appointment_uuid_5, t0.appointment_technical_visit_uuid AS appointment_technical_visit_uuid_6 FROM appointment_cancelled t0 WHERE t0.appointment_uuid = 0x019C8A05FAF3701FB0C1A1B5565C3098;

SELECT
  t0.uuid AS uuid_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.note_start_display AS note_start_display_9,
  t0.display_previous_notes AS display_previous_notes_10,
  t0.calendar_color AS calendar_color_11
FROM
  `user` t0
WHERE
  t0.uuid = ?

SELECT t0.uuid AS uuid_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.note_start_display AS note_start_display_9, t0.display_previous_notes AS display_previous_notes_10, t0.calendar_color AS calendar_color_11 FROM `user` t0 WHERE t0.uuid = 0x019C15D782C572CA8210B33FD39B71B9;

SELECT
  a0_.uuid AS uuid_0,
  a0_.date_start AS date_start_1,
  a0_.date_end AS date_end_2,
  a0_.description AS description_3,
  a0_.address AS address_4,
  a0_.postal_code AS postal_code_5,
  a0_.city AS city_6,
  a0_.country AS country_7,
  a0_.status AS status_8,
  a0_.customer_uuid AS customer_uuid_9,
  a0_.lead_uuid AS lead_uuid_10,
  a0_.sale_rep_uuid AS sale_rep_uuid_11,
  a0_.created_by_uuid AS created_by_uuid_12,
  a0_.assigned_to_uuid AS assigned_to_uuid_13
FROM
  appointment a0_
  INNER JOIN `user` u1_ ON a0_.sale_rep_uuid = u1_.uuid
WHERE
  a0_.status NOT IN (?, ?, ?)
  AND u1_.uuid = ?
  AND (
    a0_.date_start BETWEEN ?
    AND ?
  )

SELECT a0_.uuid AS uuid_0, a0_.date_start AS date_start_1, a0_.date_end AS date_end_2, a0_.description AS description_3, a0_.address AS address_4, a0_.postal_code AS postal_code_5, a0_.city AS city_6, a0_.country AS country_7, a0_.status AS status_8, a0_.customer_uuid AS customer_uuid_9, a0_.lead_uuid AS lead_uuid_10, a0_.sale_rep_uuid AS sale_rep_uuid_11, a0_.created_by_uuid AS created_by_uuid_12, a0_.assigned_to_uuid AS assigned_to_uuid_13 FROM appointment a0_ INNER JOIN `user` u1_ ON a0_.sale_rep_uuid = u1_.uuid WHERE a0_.status NOT IN ('aborded', 'postponed', 'cancelled') AND u1_.uuid = 0x019C15D782C572CA8210B33FD39B71B9 AND (a0_.date_start BETWEEN '2026-03-23 00:00:00' AND '2026-03-30 00:00:00');

SELECT
  a0_.uuid AS uuid_0,
  a0_.comment AS comment_1,
  a0_.date_start AS date_start_2,
  a0_.date_end AS date_end_3,
  a0_.created_at AS created_at_4,
  a0_.updated_at AS updated_at_5,
  a0_.status AS status_6,
  a0_.address AS address_7,
  a0_.postal_code AS postal_code_8,
  a0_.city AS city_9,
  a0_.country AS country_10,
  a0_.appointment_uuid AS appointment_uuid_11
FROM
  appointment_technical_visit a0_
  INNER JOIN appointment a1_ ON a0_.appointment_uuid = a1_.uuid
  INNER JOIN `user` u2_ ON a1_.sale_rep_uuid = u2_.uuid
WHERE
  a0_.date_start IS NOT NULL
  AND a0_.date_end IS NOT NULL
  AND a0_.status NOT IN (?, ?)
  AND u2_.uuid = ?
  AND (
    a0_.date_start BETWEEN ?
    AND ?
  )

SELECT a0_.uuid AS uuid_0, a0_.comment AS comment_1, a0_.date_start AS date_start_2, a0_.date_end AS date_end_3, a0_.created_at AS created_at_4, a0_.updated_at AS updated_at_5, a0_.status AS status_6, a0_.address AS address_7, a0_.postal_code AS postal_code_8, a0_.city AS city_9, a0_.country AS country_10, a0_.appointment_uuid AS appointment_uuid_11 FROM appointment_technical_visit a0_ INNER JOIN appointment a1_ ON a0_.appointment_uuid = a1_.uuid INNER JOIN `user` u2_ ON a1_.sale_rep_uuid = u2_.uuid WHERE a0_.date_start IS NOT NULL AND a0_.date_end IS NOT NULL AND a0_.status NOT IN ('aborded', 'postponed') AND u2_.uuid = 0x019C15D782C572CA8210B33FD39B71B9 AND (a0_.date_start BETWEEN '2026-03-23 00:00:00' AND '2026-03-30 00:00:00');