Symfony Profiler

SELECT
  t0.quantitenature AS quantitenature_1,
  t0.date_arc AS date_arc_2,
  t0.commentaire AS commentaire_3,
  t0.collisage AS collisage_4,
  t0.tempsalloue AS tempsalloue_5,
  t0.delaifournisseur AS delaifournisseur_6,
  t0.quantitearticle AS quantitearticle_7,
  t0.demandestatus AS demandestatus_8,
  t0.early AS early_9,
  t0.num_arc AS num_arc_10,
  t0.id AS id_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.chantier_id AS chantier_id_14,
  t0.statusmarchandise_id AS statusmarchandise_id_15,
  t0.fournisseur_id AS fournisseur_id_16,
  t0.article_id AS article_id_17,
  t0.statemarchandise_id AS statemarchandise_id_18,
  t0.segmentationmarchandise_id AS segmentationmarchandise_id_19,
  t0.control_id AS control_id_20
FROM
  marchandise t0
  INNER JOIN marchandise_rvintervention ON t0.id = marchandise_rvintervention.marchandise_id
WHERE
  marchandise_rvintervention.rvintervention_id = ?

SELECT t0.quantitenature AS quantitenature_1, t0.date_arc AS date_arc_2, t0.commentaire AS commentaire_3, t0.collisage AS collisage_4, t0.tempsalloue AS tempsalloue_5, t0.delaifournisseur AS delaifournisseur_6, t0.quantitearticle AS quantitearticle_7, t0.demandestatus AS demandestatus_8, t0.early AS early_9, t0.num_arc AS num_arc_10, t0.id AS id_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.chantier_id AS chantier_id_14, t0.statusmarchandise_id AS statusmarchandise_id_15, t0.fournisseur_id AS fournisseur_id_16, t0.article_id AS article_id_17, t0.statemarchandise_id AS statemarchandise_id_18, t0.segmentationmarchandise_id AS segmentationmarchandise_id_19, t0.control_id AS control_id_20 FROM marchandise t0 INNER JOIN marchandise_rvintervention ON t0.id = marchandise_rvintervention.marchandise_id WHERE marchandise_rvintervention.rvintervention_id = 15010;

SELECT
  t0.id AS id_1,
  t0.daterv AS daterv_2,
  t0.com AS com_3,
  t0.duree AS duree_4,
  t0.address AS address_5,
  t0.cp AS cp_6,
  t0.town AS town_7,
  t0.libre AS libre_8,
  t0.tempseffectif AS tempseffectif_9,
  t0.datevoulueclientde AS datevoulueclientde_10,
  t0.datevoulueclienta AS datevoulueclienta_11,
  t0.precisionsvouluesclient AS precisionsvouluesclient_12,
  t0.dispos AS dispos_13,
  t0.tempsfacture AS tempsfacture_14,
  t0.statusrv AS statusrv_15,
  t0.label AS label_16,
  t0.gps AS gps_17,
  t0.drive AS drive_18,
  t0.nb_intervenants AS nb_intervenants_19,
  t0.nb_intervenants_mandatory AS nb_intervenants_mandatory_20,
  t0.datervfin AS datervfin_21,
  t0.allday AS allday_22,
  t0.sum_rafs AS sum_rafs_23,
  t0.date_validated_with_client AS date_validated_with_client_24,
  t0.modified_by_solver AS modified_by_solver_25,
  t0.date_proposed_to_client AS date_proposed_to_client_26,
  t0.updated_at AS updated_at_27,
  t0.created_at AS created_at_28,
  t0.chantier_id AS chantier_id_29,
  t0.lieu_id AS lieu_id_30,
  t0.typeintervention_id AS typeintervention_id_31,
  t0.control_id AS control_id_32,
  t0.access_ask_id AS access_ask_id_33,
  t0.criticity_id AS criticity_id_34,
  t0.meteo_id AS meteo_id_35,
  t0.parking_id AS parking_id_36,
  t0.last_user_modified_id AS last_user_modified_id_37
FROM
  rvintervention t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.daterv AS daterv_2, t0.com AS com_3, t0.duree AS duree_4, t0.address AS address_5, t0.cp AS cp_6, t0.town AS town_7, t0.libre AS libre_8, t0.tempseffectif AS tempseffectif_9, t0.datevoulueclientde AS datevoulueclientde_10, t0.datevoulueclienta AS datevoulueclienta_11, t0.precisionsvouluesclient AS precisionsvouluesclient_12, t0.dispos AS dispos_13, t0.tempsfacture AS tempsfacture_14, t0.statusrv AS statusrv_15, t0.label AS label_16, t0.gps AS gps_17, t0.drive AS drive_18, t0.nb_intervenants AS nb_intervenants_19, t0.nb_intervenants_mandatory AS nb_intervenants_mandatory_20, t0.datervfin AS datervfin_21, t0.allday AS allday_22, t0.sum_rafs AS sum_rafs_23, t0.date_validated_with_client AS date_validated_with_client_24, t0.modified_by_solver AS modified_by_solver_25, t0.date_proposed_to_client AS date_proposed_to_client_26, t0.updated_at AS updated_at_27, t0.created_at AS created_at_28, t0.chantier_id AS chantier_id_29, t0.lieu_id AS lieu_id_30, t0.typeintervention_id AS typeintervention_id_31, t0.control_id AS control_id_32, t0.access_ask_id AS access_ask_id_33, t0.criticity_id AS criticity_id_34, t0.meteo_id AS meteo_id_35, t0.parking_id AS parking_id_36, t0.last_user_modified_id AS last_user_modified_id_37 FROM rvintervention t0 WHERE t0.id = 15010 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.username AS username_5,
  t0.color AS color_6,
  t0.tel AS tel_7,
  t0.status AS status_8,
  t0.ref_tech AS ref_tech_9,
  t0.updated_at AS updated_at_10,
  t0.created_at AS created_at_11,
  t0.typeuser_id AS typeuser_id_12
FROM
  user t0
  INNER JOIN user_rvintervention ON t0.id = user_rvintervention.user_id
WHERE
  user_rvintervention.rvintervention_id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.username AS username_5, t0.color AS color_6, t0.tel AS tel_7, t0.status AS status_8, t0.ref_tech AS ref_tech_9, t0.updated_at AS updated_at_10, t0.created_at AS created_at_11, t0.typeuser_id AS typeuser_id_12 FROM user t0 INNER JOIN user_rvintervention ON t0.id = user_rvintervention.user_id WHERE user_rvintervention.rvintervention_id = 15010;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.username AS username_5,
  t0.color AS color_6,
  t0.tel AS tel_7,
  t0.status AS status_8,
  t0.ref_tech AS ref_tech_9,
  t0.updated_at AS updated_at_10,
  t0.created_at AS created_at_11,
  t0.typeuser_id AS typeuser_id_12
FROM
  user t0
  INNER JOIN rvinterventions_recommanded ON t0.id = rvinterventions_recommanded.user_id
WHERE
  rvinterventions_recommanded.rvintervention_id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.username AS username_5, t0.color AS color_6, t0.tel AS tel_7, t0.status AS status_8, t0.ref_tech AS ref_tech_9, t0.updated_at AS updated_at_10, t0.created_at AS created_at_11, t0.typeuser_id AS typeuser_id_12 FROM user t0 INNER JOIN rvinterventions_recommanded ON t0.id = rvinterventions_recommanded.user_id WHERE rvinterventions_recommanded.rvintervention_id = 15010;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.username AS username_5,
  t0.color AS color_6,
  t0.tel AS tel_7,
  t0.status AS status_8,
  t0.ref_tech AS ref_tech_9,
  t0.updated_at AS updated_at_10,
  t0.created_at AS created_at_11,
  t0.typeuser_id AS typeuser_id_12
FROM
  user t0
  INNER JOIN rvintervention_user ON t0.id = rvintervention_user.user_id
WHERE
  rvintervention_user.rvintervention_id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.username AS username_5, t0.color AS color_6, t0.tel AS tel_7, t0.status AS status_8, t0.ref_tech AS ref_tech_9, t0.updated_at AS updated_at_10, t0.created_at AS created_at_11, t0.typeuser_id AS typeuser_id_12 FROM user t0 INNER JOIN rvintervention_user ON t0.id = rvintervention_user.user_id WHERE rvintervention_user.rvintervention_id = 15010;

SELECT
  t0.numchantier AS numchantier_1,
  t0.infos_app AS infos_app_2,
  t0.jours_homme AS jours_homme_3,
  t0.infos_prepa AS infos_prepa_4,
  t0.observation AS observation_5,
  t0.deleted AS deleted_6,
  t0.adresse AS adresse_7,
  t0.ville AS ville_8,
  t0.codepostal AS codepostal_9,
  t0.gps AS gps_10,
  t0.drive AS drive_11,
  t0.access_code AS access_code_12,
  t0.id AS id_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.client_id AS client_id_16,
  t0.segmentationchantier_id AS segmentationchantier_id_17,
  t0.modereglement_id AS modereglement_id_18,
  t0.user_id AS user_id_19,
  t0.tech_id AS tech_id_20
FROM
  chantier t0
WHERE
  t0.id = ?

SELECT t0.numchantier AS numchantier_1, t0.infos_app AS infos_app_2, t0.jours_homme AS jours_homme_3, t0.infos_prepa AS infos_prepa_4, t0.observation AS observation_5, t0.deleted AS deleted_6, t0.adresse AS adresse_7, t0.ville AS ville_8, t0.codepostal AS codepostal_9, t0.gps AS gps_10, t0.drive AS drive_11, t0.access_code AS access_code_12, t0.id AS id_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.client_id AS client_id_16, t0.segmentationchantier_id AS segmentationchantier_id_17, t0.modereglement_id AS modereglement_id_18, t0.user_id AS user_id_19, t0.tech_id AS tech_id_20 FROM chantier t0 WHERE t0.id = 7056;

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.content AS content_3,
  t0.tempsalloue AS tempsalloue_4,
  t0.chantier_id AS chantier_id_5,
  t0.user_id AS user_id_6
FROM
  chantier_raf t0
  INNER JOIN chantier_raf_rvintervention ON t0.id = chantier_raf_rvintervention.chantier_raf_id
WHERE
  chantier_raf_rvintervention.rvintervention_id = ?

SELECT t0.id AS id_1, t0.status AS status_2, t0.content AS content_3, t0.tempsalloue AS tempsalloue_4, t0.chantier_id AS chantier_id_5, t0.user_id AS user_id_6 FROM chantier_raf t0 INNER JOIN chantier_raf_rvintervention ON t0.id = chantier_raf_rvintervention.chantier_raf_id WHERE chantier_raf_rvintervention.rvintervention_id = 15010;

SELECT
  r0_.id AS id_0,
  r0_.daterv AS daterv_1,
  r0_.com AS com_2,
  r0_.duree AS duree_3,
  r0_.address AS address_4,
  r0_.cp AS cp_5,
  r0_.town AS town_6,
  r0_.libre AS libre_7,
  r0_.tempseffectif AS tempseffectif_8,
  r0_.datevoulueclientde AS datevoulueclientde_9,
  r0_.datevoulueclienta AS datevoulueclienta_10,
  r0_.precisionsvouluesclient AS precisionsvouluesclient_11,
  r0_.dispos AS dispos_12,
  r0_.tempsfacture AS tempsfacture_13,
  r0_.statusrv AS statusrv_14,
  r0_.label AS label_15,
  r0_.gps AS gps_16,
  r0_.drive AS drive_17,
  r0_.nb_intervenants AS nb_intervenants_18,
  r0_.nb_intervenants_mandatory AS nb_intervenants_mandatory_19,
  r0_.datervfin AS datervfin_20,
  r0_.allday AS allday_21,
  r0_.sum_rafs AS sum_rafs_22,
  r0_.date_validated_with_client AS date_validated_with_client_23,
  r0_.modified_by_solver AS modified_by_solver_24,
  r0_.date_proposed_to_client AS date_proposed_to_client_25,
  r0_.updated_at AS updated_at_26,
  r0_.created_at AS created_at_27,
  r0_.chantier_id AS chantier_id_28,
  r0_.lieu_id AS lieu_id_29,
  r0_.typeintervention_id AS typeintervention_id_30,
  r0_.control_id AS control_id_31,
  r0_.access_ask_id AS access_ask_id_32,
  r0_.criticity_id AS criticity_id_33,
  r0_.meteo_id AS meteo_id_34,
  r0_.parking_id AS parking_id_35,
  r0_.last_user_modified_id AS last_user_modified_id_36
FROM
  rvintervention r0_
  LEFT JOIN marchandise_rvintervention m2_ ON r0_.id = m2_.rvintervention_id
  LEFT JOIN marchandise m1_ ON m1_.id = m2_.marchandise_id
  LEFT JOIN user_rvintervention u4_ ON r0_.id = u4_.rvintervention_id
  LEFT JOIN user u3_ ON u3_.id = u4_.user_id
  LEFT JOIN chantier c5_ ON r0_.chantier_id = c5_.id
WHERE
  1 = 1
  AND (
    (
      r0_.daterv >= ?
      AND r0_.daterv <= ?
      OR (
        r0_.datervfin >= ?
        AND r0_.datervfin <= ?
      )
      OR (
        r0_.daterv < ?
        AND r0_.datervfin > ?
      )
    )
  )
  AND u3_.id IN (?, ?, ?, ?, ?, ?, ?, ?)

SELECT r0_.id AS id_0, r0_.daterv AS daterv_1, r0_.com AS com_2, r0_.duree AS duree_3, r0_.address AS address_4, r0_.cp AS cp_5, r0_.town AS town_6, r0_.libre AS libre_7, r0_.tempseffectif AS tempseffectif_8, r0_.datevoulueclientde AS datevoulueclientde_9, r0_.datevoulueclienta AS datevoulueclienta_10, r0_.precisionsvouluesclient AS precisionsvouluesclient_11, r0_.dispos AS dispos_12, r0_.tempsfacture AS tempsfacture_13, r0_.statusrv AS statusrv_14, r0_.label AS label_15, r0_.gps AS gps_16, r0_.drive AS drive_17, r0_.nb_intervenants AS nb_intervenants_18, r0_.nb_intervenants_mandatory AS nb_intervenants_mandatory_19, r0_.datervfin AS datervfin_20, r0_.allday AS allday_21, r0_.sum_rafs AS sum_rafs_22, r0_.date_validated_with_client AS date_validated_with_client_23, r0_.modified_by_solver AS modified_by_solver_24, r0_.date_proposed_to_client AS date_proposed_to_client_25, r0_.updated_at AS updated_at_26, r0_.created_at AS created_at_27, r0_.chantier_id AS chantier_id_28, r0_.lieu_id AS lieu_id_29, r0_.typeintervention_id AS typeintervention_id_30, r0_.control_id AS control_id_31, r0_.access_ask_id AS access_ask_id_32, r0_.criticity_id AS criticity_id_33, r0_.meteo_id AS meteo_id_34, r0_.parking_id AS parking_id_35, r0_.last_user_modified_id AS last_user_modified_id_36 FROM rvintervention r0_ LEFT JOIN marchandise_rvintervention m2_ ON r0_.id = m2_.rvintervention_id LEFT JOIN marchandise m1_ ON m1_.id = m2_.marchandise_id LEFT JOIN user_rvintervention u4_ ON r0_.id = u4_.rvintervention_id LEFT JOIN user u3_ ON u3_.id = u4_.user_id LEFT JOIN chantier c5_ ON r0_.chantier_id = c5_.id WHERE 1 = 1 AND ((r0_.daterv >= '2025-06-16 00:00:00' AND r0_.daterv <= '2025-06-22 00:00:00' OR (r0_.datervfin >= '2025-06-16 00:00:00' AND r0_.datervfin <= '2025-06-22 00:00:00') OR (r0_.daterv < '2025-06-16 00:00:00' AND r0_.datervfin > '2025-06-22 00:00:00'))) AND u3_.id IN ('28', '86', '36', '22', '19', '24', '38', '70');

SELECT
  t0.content AS content_1,
  t0.id AS id_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.rvintervention_id AS rvintervention_id_5,
  t0.user_id AS user_id_6
FROM
  rvintervention_logs t0
WHERE
  t0.rvintervention_id = ?

SELECT t0.content AS content_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.rvintervention_id AS rvintervention_id_5, t0.user_id AS user_id_6 FROM rvintervention_logs t0 WHERE t0.rvintervention_id = 15010;

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.content AS content_3,
  t0.tempsalloue AS tempsalloue_4,
  t0.chantier_id AS chantier_id_5,
  t0.user_id AS user_id_6
FROM
  chantier_raf t0
WHERE
  t0.chantier_id = ?

SELECT t0.id AS id_1, t0.status AS status_2, t0.content AS content_3, t0.tempsalloue AS tempsalloue_4, t0.chantier_id AS chantier_id_5, t0.user_id AS user_id_6 FROM chantier_raf t0 WHERE t0.chantier_id = 7056;

SELECT
  t0.id AS id_1,
  t0.number AS number_2,
  t0.link AS link_3,
  t0.sms AS sms_4,
  t0.email AS email_5,
  t0.client_id AS client_id_6
FROM
  client_contact t0
WHERE
  t0.client_id = ?

SELECT t0.id AS id_1, t0.number AS number_2, t0.link AS link_3, t0.sms AS sms_4, t0.email AS email_5, t0.client_id AS client_id_6 FROM client_contact t0 WHERE t0.client_id = 4992;

SELECT
  t0.fullname AS fullname_1,
  t0.telfixe AS telfixe_2,
  t0.telmobile AS telmobile_3,
  t0.email AS email_4,
  t0.deleted AS deleted_5,
  t0.id AS id_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8
FROM
  client t0
WHERE
  t0.id = ?

SELECT t0.fullname AS fullname_1, t0.telfixe AS telfixe_2, t0.telmobile AS telmobile_3, t0.email AS email_4, t0.deleted AS deleted_5, t0.id AS id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM client t0 WHERE t0.id = 4992;

SELECT
  t0.nom AS nom_1,
  t0.delaifournisseur AS delaifournisseur_2,
  t0.id AS id_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  fournisseur t0
WHERE
  t0.id = ?

SELECT t0.nom AS nom_1, t0.delaifournisseur AS delaifournisseur_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM fournisseur t0 WHERE t0.id = 101;

SELECT
  t0.label AS label_1,
  t0.stock AS stock_2,
  t0.id AS id_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.category_id AS category_id_6
FROM
  article t0
WHERE
  t0.id = ?

SELECT t0.label AS label_1, t0.stock AS stock_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.category_id AS category_id_6 FROM article t0 WHERE t0.id = 50;

SELECT
  t0.nom AS nom_1,
  t0.color AS color_2,
  t0.css_class AS css_class_3,
  t0.place AS place_4,
  t0.typemarchandise AS typemarchandise_5,
  t0.id AS id_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8
FROM
  statusmarchandise t0
WHERE
  t0.id = ?

SELECT t0.nom AS nom_1, t0.color AS color_2, t0.css_class AS css_class_3, t0.place AS place_4, t0.typemarchandise AS typemarchandise_5, t0.id AS id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM statusmarchandise t0 WHERE t0.id = 7;

SELECT
  t0.nom AS nom_1,
  t0.id AS id_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4
FROM
  typeintervention t0
WHERE
  t0.id = ?

SELECT t0.nom AS nom_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM typeintervention t0 WHERE t0.id = 9;

SELECT
  t0.nom AS nom_1,
  t0.description AS description_2,
  t0.id AS id_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  segmentationchantier t0
WHERE
  t0.id = ?

SELECT t0.nom AS nom_1, t0.description AS description_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM segmentationchantier t0 WHERE t0.id = 3;

SELECT
  t0.name AS name_1,
  t0.id AS id_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4
FROM
  marchandise_state t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM marchandise_state t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.username AS username_5,
  t0.color AS color_6,
  t0.tel AS tel_7,
  t0.status AS status_8,
  t0.ref_tech AS ref_tech_9,
  t0.updated_at AS updated_at_10,
  t0.created_at AS created_at_11,
  t0.typeuser_id AS typeuser_id_12
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.username AS username_5, t0.color AS color_6, t0.tel AS tel_7, t0.status AS status_8, t0.ref_tech AS ref_tech_9, t0.updated_at AS updated_at_10, t0.created_at AS created_at_11, t0.typeuser_id AS typeuser_id_12 FROM user t0 WHERE t0.id = 28;