Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.username_canonical AS username_canonical_1,
  p0_.email AS email_2,
  p0_.email_canonical AS email_canonical_3,
  p0_.enabled AS enabled_4,
  p0_.salt AS salt_5,
  p0_.password AS password_6,
  p0_.last_login AS last_login_7,
  p0_.confirmation_token AS confirmation_token_8,
  p0_.password_requested_at AS password_requested_at_9,
  p0_.roles AS roles_10,
  p0_.username AS username_11,
  p0_.nom AS nom_12,
  p0_.prenom AS prenom_13,
  p0_.fonction AS fonction_14,
  p0_.tel AS tel_15,
  p0_.mobile AS mobile_16,
  p0_.activation AS activation_17,
  p0_.createdAt AS createdAt_18,
  p0_.updatedAt AS updatedAt_19,
  p0_.optin AS optin_20,
  p0_.dateActivation AS dateActivation_21,
  p0_.emailValidatedDateTime AS emailValidatedDateTime_22,
  p0_.emailCreatedDateTime AS emailCreatedDateTime_23,
  p0_.mobileCreatedDatetime AS mobileCreatedDatetime_24,
  p0_.sendEmail AS sendEmail_25,
  p0_.adresse AS adresse_26,
  p0_.adresse_complement AS adresse_complement_27,
  p0_.codepostal AS codepostal_28,
  p0_.ville AS ville_29,
  p0_.token AS token_30,
  p0_.emailRequested AS emailRequested_31,
  p0_.emailRequestedDate AS emailRequestedDate_32,
  p0_.inscriptionFromDemandeOffre AS inscriptionFromDemandeOffre_33,
  p0_.lastOffreDate AS lastOffreDate_34,
  p0_.tag AS tag_35,
  p0_.cdiscountGuid AS cdiscountGuid_36,
  p0_.cdiscountCdav AS cdiscountCdav_37,
  p0_.gender AS gender_38,
  p0_.exclusiveEnabled AS exclusiveEnabled_39,
  p0_.relanceSmsRegistration AS relanceSmsRegistration_40,
  p0_.dateRelanceSmsRegistration AS dateRelanceSmsRegistration_41,
  p0_.dateNaissance AS dateNaissance_42,
  p0_.workflow_id AS workflow_id_43,
  p0_.cas1_id AS cas1_id_44,
  p0_.identite_id AS identite_id_45,
  p0_.integrationModule_id AS integrationModule_id_46
FROM
  ParticulierUser p0_
  INNER JOIN IntegrationModule i1_ ON p0_.integrationModule_id = i1_.id
  INNER JOIN TeteReseau t2_ ON i1_.teteReseau_id = t2_.id
WHERE
  t2_.oblige_id = ?
  AND p0_.activation <> ?
  AND p0_.enabled = ?
  AND p0_.username = ?
LIMIT
  1

SELECT p0_.id AS id_0, p0_.username_canonical AS username_canonical_1, p0_.email AS email_2, p0_.email_canonical AS email_canonical_3, p0_.enabled AS enabled_4, p0_.salt AS salt_5, p0_.password AS password_6, p0_.last_login AS last_login_7, p0_.confirmation_token AS confirmation_token_8, p0_.password_requested_at AS password_requested_at_9, p0_.roles AS roles_10, p0_.username AS username_11, p0_.nom AS nom_12, p0_.prenom AS prenom_13, p0_.fonction AS fonction_14, p0_.tel AS tel_15, p0_.mobile AS mobile_16, p0_.activation AS activation_17, p0_.createdAt AS createdAt_18, p0_.updatedAt AS updatedAt_19, p0_.optin AS optin_20, p0_.dateActivation AS dateActivation_21, p0_.emailValidatedDateTime AS emailValidatedDateTime_22, p0_.emailCreatedDateTime AS emailCreatedDateTime_23, p0_.mobileCreatedDatetime AS mobileCreatedDatetime_24, p0_.sendEmail AS sendEmail_25, p0_.adresse AS adresse_26, p0_.adresse_complement AS adresse_complement_27, p0_.codepostal AS codepostal_28, p0_.ville AS ville_29, p0_.token AS token_30, p0_.emailRequested AS emailRequested_31, p0_.emailRequestedDate AS emailRequestedDate_32, p0_.inscriptionFromDemandeOffre AS inscriptionFromDemandeOffre_33, p0_.lastOffreDate AS lastOffreDate_34, p0_.tag AS tag_35, p0_.cdiscountGuid AS cdiscountGuid_36, p0_.cdiscountCdav AS cdiscountCdav_37, p0_.gender AS gender_38, p0_.exclusiveEnabled AS exclusiveEnabled_39, p0_.relanceSmsRegistration AS relanceSmsRegistration_40, p0_.dateRelanceSmsRegistration AS dateRelanceSmsRegistration_41, p0_.dateNaissance AS dateNaissance_42, p0_.workflow_id AS workflow_id_43, p0_.cas1_id AS cas1_id_44, p0_.identite_id AS identite_id_45, p0_.integrationModule_id AS integrationModule_id_46 FROM ParticulierUser p0_ INNER JOIN IntegrationModule i1_ ON p0_.integrationModule_id = i1_.id INNER JOIN TeteReseau t2_ ON i1_.teteReseau_id = t2_.id WHERE t2_.oblige_id = 6 AND p0_.activation <> 'pending' AND p0_.enabled = 1 AND p0_.username = '[email protected]' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.appKey AS appKey_2,
  t0.label AS label_3,
  t0.description AS description_4,
  t0.url AS url_5,
  t0.status AS status_6,
  t0.created_at AS created_at_7,
  t0.report_auto_email AS report_auto_email_8,
  t0.logo AS logo_9,
  t0.smartName AS smartName_10,
  t0.prefixEmail AS prefixEmail_11,
  t0.`lead` AS lead_12,
  t0.`leadUrl` AS leadUrl_13,
  t0.`leadLogin` AS leadLogin_14,
  t0.`leadPassword` AS leadPassword_15,
  t0.recommanderProDefault AS recommanderProDefault_16,
  t0.actif AS actif_17,
  t0.allowMultiSubscription AS allowMultiSubscription_18,
  t0.teteReseau_id AS teteReseau_id_19,
  t0.branding AS branding_20
FROM
  IntegrationModule t0
WHERE
  t0.appKey = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.appKey AS appKey_2, t0.label AS label_3, t0.description AS description_4, t0.url AS url_5, t0.status AS status_6, t0.created_at AS created_at_7, t0.report_auto_email AS report_auto_email_8, t0.logo AS logo_9, t0.smartName AS smartName_10, t0.prefixEmail AS prefixEmail_11, t0.`lead` AS lead_12, t0.`leadUrl` AS leadUrl_13, t0.`leadLogin` AS leadLogin_14, t0.`leadPassword` AS leadPassword_15, t0.recommanderProDefault AS recommanderProDefault_16, t0.actif AS actif_17, t0.allowMultiSubscription AS allowMultiSubscription_18, t0.teteReseau_id AS teteReseau_id_19, t0.branding AS branding_20 FROM IntegrationModule t0 WHERE t0.appKey = 'Tjp3' LIMIT 1;

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  CoupDePouce c0_
WHERE
  c0_.oblige_id = ?
  AND c0_.operation = ?
  AND c0_.version = ?
  AND c0_.CDPD = ?
  AND (
    c0_.disabledDate IS NULL
    OR (
      c0_.disabledDate > ?
      AND c0_.disabledDate IS NOT NULL
    )
  )
  AND c0_.type = ?

SELECT COUNT(c0_.id) AS sclr_0 FROM CoupDePouce c0_ WHERE c0_.oblige_id = 6 AND c0_.operation = 'BAR-TH-171' AND c0_.version = 9 AND c0_.CDPD = 1 AND (c0_.disabledDate IS NULL OR (c0_.disabledDate > '2026-08-26 11:28:51' AND c0_.disabledDate IS NOT NULL)) AND c0_.type = 'residentiel';

INSERT INTO AffectationOffre (
  offreProjet_id, obligeUser_id, obligeRole_id
)
VALUES
  (?, ?, ?)

INSERT INTO AffectationOffre (offreProjet_id, obligeUser_id, obligeRole_id) VALUES (453433, 44, 9);

SELECT
  t0.id AS id_1,
  t0.`key` AS key_2,
  t0.`value` AS value_3,
  t0.offreProjet_id AS offreProjet_id_4,
  t0.projet_id AS projet_id_5
FROM
  OffreProjetAdditionalInformation t0
WHERE
  t0.`key` = ?
  AND t0.offreProjet_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3, t0.offreProjet_id AS offreProjet_id_4, t0.projet_id AS projet_id_5 FROM OffreProjetAdditionalInformation t0 WHERE t0.`key` = 'classical_real_price' AND t0.offreProjet_id = 453433 LIMIT 1;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.`key` AS key_2,
  t0.`value` AS value_3,
  t0.`description` AS description_4,
  t0.object_id AS object_id_5,
  t0.object_class AS object_class_6,
  t0.is_default AS is_default_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  Configuration t0
WHERE
  t0.`key` = ?
  AND t0.object_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3, t0.`description` AS description_4, t0.object_id AS object_id_5, t0.object_class AS object_class_6, t0.is_default AS is_default_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM Configuration t0 WHERE t0.`key` = 'validite_signature_offre' AND t0.object_id = 70421 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.ensoleillement AS ensoleillement_3,
  t0.vent AS vent_4,
  t0.thermique AS thermique_5,
  t0.code AS code_6,
  t0.geo AS geo_7
FROM
  ZoneClimatique t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ensoleillement AS ensoleillement_3, t0.vent AS vent_4, t0.thermique AS thermique_5, t0.code AS code_6, t0.geo AS geo_7 FROM ZoneClimatique t0 WHERE t0.code = '33' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.complete AS complete_1,
  p0_.source AS source_2,
  p0_.target AS target_3,
  p0_.type AS type_4,
  p0_.paymentType AS paymentType_5,
  p0_.ceeSim AS ceeSim_6,
  p0_.ceeAuto AS ceeAuto_7,
  p0_.ceeMin AS ceeMin_8,
  p0_.ceeMax AS ceeMax_9,
  p0_.precaSim AS precaSim_10,
  p0_.precaAuto AS precaAuto_11,
  p0_.precaMin AS precaMin_12,
  p0_.precaMax AS precaMax_13,
  p0_.curseur AS curseur_14,
  p0_.minimumClient AS minimumClient_15,
  p0_.createdAt AS createdAt_16,
  p0_.updatedAt AS updatedAt_17,
  p0_.group_id AS group_id_18,
  p0_.simulateur_id AS simulateur_id_19
FROM
  Pricing p0_
  INNER JOIN PricingGroup p1_ ON p0_.group_id = p1_.id
WHERE
  p1_.active = ?
  AND p0_.simulateur_id IS NULL
  AND p1_.teteReseau_id = ?
  AND p0_.source = ?
  AND p0_.target = ?
LIMIT
  1

SELECT p0_.id AS id_0, p0_.complete AS complete_1, p0_.source AS source_2, p0_.target AS target_3, p0_.type AS type_4, p0_.paymentType AS paymentType_5, p0_.ceeSim AS ceeSim_6, p0_.ceeAuto AS ceeAuto_7, p0_.ceeMin AS ceeMin_8, p0_.ceeMax AS ceeMax_9, p0_.precaSim AS precaSim_10, p0_.precaAuto AS precaAuto_11, p0_.precaMin AS precaMin_12, p0_.precaMax AS precaMax_13, p0_.curseur AS curseur_14, p0_.minimumClient AS minimumClient_15, p0_.createdAt AS createdAt_16, p0_.updatedAt AS updatedAt_17, p0_.group_id AS group_id_18, p0_.simulateur_id AS simulateur_id_19 FROM Pricing p0_ INNER JOIN PricingGroup p1_ ON p0_.group_id = p1_.id WHERE p1_.active = 1 AND p0_.simulateur_id IS NULL AND p1_.teteReseau_id = 1169 AND p0_.source = 'pro' AND p0_.target = 'b2c' LIMIT 1;

SELECT
  e0_.id AS id_0,
  e0_.username_canonical AS username_canonical_1,
  e0_.email AS email_2,
  e0_.email_canonical AS email_canonical_3,
  e0_.enabled AS enabled_4,
  e0_.salt AS salt_5,
  e0_.password AS password_6,
  e0_.last_login AS last_login_7,
  e0_.confirmation_token AS confirmation_token_8,
  e0_.password_requested_at AS password_requested_at_9,
  e0_.roles AS roles_10,
  e0_.username AS username_11,
  e0_.nom AS nom_12,
  e0_.prenom AS prenom_13,
  e0_.fonction AS fonction_14,
  e0_.tel AS tel_15,
  e0_.mobile AS mobile_16,
  e0_.activation AS activation_17,
  e0_.createdAt AS createdAt_18,
  e0_.updatedAt AS updatedAt_19,
  e0_.optin AS optin_20,
  e0_.dateActivation AS dateActivation_21,
  e0_.emailValidatedDateTime AS emailValidatedDateTime_22,
  e0_.emailCreatedDateTime AS emailCreatedDateTime_23,
  e0_.mobileCreatedDatetime AS mobileCreatedDatetime_24,
  e0_.sendEmail AS sendEmail_25,
  e0_.emailRequested AS emailRequested_26,
  e0_.emailRequestedDate AS emailRequestedDate_27,
  e0_.lastOffreDate AS lastOffreDate_28,
  e0_.token AS token_29,
  e0_.inscriptionFromDemandeOffre AS inscriptionFromDemandeOffre_30,
  e0_.exclusiveEnabled AS exclusiveEnabled_31,
  e0_.relanceSmsRegistration AS relanceSmsRegistration_32,
  e0_.dateRelanceSmsRegistration AS dateRelanceSmsRegistration_33,
  e0_.company_id AS company_id_34,
  e0_.workflow_id AS workflow_id_35,
  e0_.integrationModule_id AS integrationModule_id_36,
  e0_.identite_id AS identite_id_37
FROM
  EntrepriseUser e0_
  INNER JOIN IntegrationModule i1_ ON e0_.integrationModule_id = i1_.id
  INNER JOIN TeteReseau t2_ ON i1_.teteReseau_id = t2_.id
WHERE
  t2_.oblige_id = ?
  AND e0_.activation <> ?
  AND e0_.enabled = ?
  AND e0_.username = ?
LIMIT
  1

SELECT e0_.id AS id_0, e0_.username_canonical AS username_canonical_1, e0_.email AS email_2, e0_.email_canonical AS email_canonical_3, e0_.enabled AS enabled_4, e0_.salt AS salt_5, e0_.password AS password_6, e0_.last_login AS last_login_7, e0_.confirmation_token AS confirmation_token_8, e0_.password_requested_at AS password_requested_at_9, e0_.roles AS roles_10, e0_.username AS username_11, e0_.nom AS nom_12, e0_.prenom AS prenom_13, e0_.fonction AS fonction_14, e0_.tel AS tel_15, e0_.mobile AS mobile_16, e0_.activation AS activation_17, e0_.createdAt AS createdAt_18, e0_.updatedAt AS updatedAt_19, e0_.optin AS optin_20, e0_.dateActivation AS dateActivation_21, e0_.emailValidatedDateTime AS emailValidatedDateTime_22, e0_.emailCreatedDateTime AS emailCreatedDateTime_23, e0_.mobileCreatedDatetime AS mobileCreatedDatetime_24, e0_.sendEmail AS sendEmail_25, e0_.emailRequested AS emailRequested_26, e0_.emailRequestedDate AS emailRequestedDate_27, e0_.lastOffreDate AS lastOffreDate_28, e0_.token AS token_29, e0_.inscriptionFromDemandeOffre AS inscriptionFromDemandeOffre_30, e0_.exclusiveEnabled AS exclusiveEnabled_31, e0_.relanceSmsRegistration AS relanceSmsRegistration_32, e0_.dateRelanceSmsRegistration AS dateRelanceSmsRegistration_33, e0_.company_id AS company_id_34, e0_.workflow_id AS workflow_id_35, e0_.integrationModule_id AS integrationModule_id_36, e0_.identite_id AS identite_id_37 FROM EntrepriseUser e0_ INNER JOIN IntegrationModule i1_ ON e0_.integrationModule_id = i1_.id INNER JOIN TeteReseau t2_ ON i1_.teteReseau_id = t2_.id WHERE t2_.oblige_id = 6 AND e0_.activation <> 'pending' AND e0_.enabled = 1 AND e0_.username = '[email protected]' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.`key` AS key_2,
  t0.`value` AS value_3,
  t0.offreProjet_id AS offreProjet_id_4,
  t0.projet_id AS projet_id_5
FROM
  OffreProjetAdditionalInformation t0
WHERE
  t0.`key` = ?
  AND t0.`value` = ?
  AND t0.projet_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3, t0.offreProjet_id AS offreProjet_id_4, t0.projet_id AS projet_id_5 FROM OffreProjetAdditionalInformation t0 WHERE t0.`key` = 'proprietaire_detail' AND t0.`value` = 'proprietaire_bailleur_du_logement' AND t0.projet_id = 1716586 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.obligeRole_id AS obligeRole_id_3,
  t4.id AS id_5,
  t4.role AS role_6,
  t4.title AS title_7,
  t4.scope AS scope_8,
  t4.position AS position_9,
  t4.definition AS definition_10,
  t4.cycle AS cycle_11,
  t4.only_consoneo_update AS only_consoneo_update_12,
  t0.teteReseau_id AS teteReseau_id_13
FROM
  RegleRole t0
  LEFT JOIN ObligeRole t4 ON t0.obligeRole_id = t4.id
  INNER JOIN RegleRole_ObligeUser ON t0.id = RegleRole_ObligeUser.regleRoleId
WHERE
  RegleRole_ObligeUser.userId = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.obligeRole_id AS obligeRole_id_3, t4.id AS id_5, t4.role AS role_6, t4.title AS title_7, t4.scope AS scope_8, t4.position AS position_9, t4.definition AS definition_10, t4.cycle AS cycle_11, t4.only_consoneo_update AS only_consoneo_update_12, t0.teteReseau_id AS teteReseau_id_13 FROM RegleRole t0 LEFT JOIN ObligeRole t4 ON t0.obligeRole_id = t4.id INNER JOIN RegleRole_ObligeUser ON t0.id = RegleRole_ObligeUser.regleRoleId WHERE RegleRole_ObligeUser.userId = 44;

SELECT
  t0.id AS id_1,
  t0.token AS token_2,
  t0.isValid AS isValid_3,
  t0.createdDateTime AS createdDateTime_4,
  t0.installateurUser_id AS installateurUser_id_5,
  t0.obligeUser_id AS obligeUser_id_6,
  t0.obligeRealUser_id AS obligeRealUser_id_7
FROM
  SignatureAuto t0
WHERE
  t0.installateurUser_id = ?
ORDER BY
  t0.createdDateTime DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.token AS token_2, t0.isValid AS isValid_3, t0.createdDateTime AS createdDateTime_4, t0.installateurUser_id AS installateurUser_id_5, t0.obligeUser_id AS obligeUser_id_6, t0.obligeRealUser_id AS obligeRealUser_id_7 FROM SignatureAuto t0 WHERE t0.installateurUser_id = 10570 ORDER BY t0.createdDateTime DESC LIMIT 1;

SELECT
  o0_.id AS id_0,
  o0_.nom AS nom_1,
  o0_.version AS version_2,
  o0_.code AS code_3,
  o0_.duree AS duree_4,
  o0_.auto_installation AS auto_installation_5,
  o0_.conditions AS conditions_6,
  o0_.conditionsRaw AS conditionsRaw_7,
  o0_.conditionsFormater AS conditionsFormater_8,
  o0_.documents_requis AS documents_requis_9,
  o0_.nombre_documents AS nombre_documents_10,
  o0_.nombre_conditions AS nombre_conditions_11,
  o0_.question_details_type AS question_details_type_12,
  o0_.question_details_value AS question_details_value_13,
  o0_.periode AS periode_14,
  o0_.informationTechnique AS informationTechnique_15,
  o0_.informationTechniqueRaw AS informationTechniqueRaw_16,
  o0_.informationTechniqueFormater AS informationTechniqueFormater_17,
  o0_.informationDocSupplementaire AS informationDocSupplementaire_18,
  o0_.informationDocSupplementaireRaw AS informationDocSupplementaireRaw_19,
  o0_.informationDocSupplementaireFormater AS informationDocSupplementaireFormater_20,
  o0_.informationfacture AS informationfacture_21,
  o0_.informationfactureRaw AS informationfactureRaw_22,
  o0_.informationfactureFormater AS informationfactureFormater_23,
  o0_.informationfacture2 AS informationfacture2_24,
  o0_.informationfacture2Raw AS informationfacture2Raw_25,
  o0_.informationfacture2Formater AS informationfacture2Formater_26,
  o0_.nbMateriau AS nbMateriau_27,
  o0_.materiauSubtitle AS materiauSubtitle_28,
  o0_.materiauTitle AS materiauTitle_29,
  o0_.textForm AS textForm_30,
  o0_.private AS private_31,
  o0_.campagne AS campagne_32,
  o0_.special AS special_33,
  o0_.abrogation_datetime AS abrogation_datetime_34,
  o0_.date_limite_depot_referencement AS date_limite_depot_referencement_35,
  o0_.end_zni_date AS end_zni_date_36,
  o0_.globalConfigurationHash AS globalConfigurationHash_37,
  o0_.zni AS zni_38,
  o0_.cdp_eligible AS cdp_eligible_39,
  o0_.simulateur_id AS simulateur_id_40,
  o0_.arrete_id AS arrete_id_41,
  o0_.certification_id AS certification_id_42,
  o0_.qualification_id AS qualification_id_43,
  o0_.formConfigEngine_id AS formConfigEngine_id_44
FROM
  Operation o0_
WHERE
  o0_.nom IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT o0_.id AS id_0, o0_.nom AS nom_1, o0_.version AS version_2, o0_.code AS code_3, o0_.duree AS duree_4, o0_.auto_installation AS auto_installation_5, o0_.conditions AS conditions_6, o0_.conditionsRaw AS conditionsRaw_7, o0_.conditionsFormater AS conditionsFormater_8, o0_.documents_requis AS documents_requis_9, o0_.nombre_documents AS nombre_documents_10, o0_.nombre_conditions AS nombre_conditions_11, o0_.question_details_type AS question_details_type_12, o0_.question_details_value AS question_details_value_13, o0_.periode AS periode_14, o0_.informationTechnique AS informationTechnique_15, o0_.informationTechniqueRaw AS informationTechniqueRaw_16, o0_.informationTechniqueFormater AS informationTechniqueFormater_17, o0_.informationDocSupplementaire AS informationDocSupplementaire_18, o0_.informationDocSupplementaireRaw AS informationDocSupplementaireRaw_19, o0_.informationDocSupplementaireFormater AS informationDocSupplementaireFormater_20, o0_.informationfacture AS informationfacture_21, o0_.informationfactureRaw AS informationfactureRaw_22, o0_.informationfactureFormater AS informationfactureFormater_23, o0_.informationfacture2 AS informationfacture2_24, o0_.informationfacture2Raw AS informationfacture2Raw_25, o0_.informationfacture2Formater AS informationfacture2Formater_26, o0_.nbMateriau AS nbMateriau_27, o0_.materiauSubtitle AS materiauSubtitle_28, o0_.materiauTitle AS materiauTitle_29, o0_.textForm AS textForm_30, o0_.private AS private_31, o0_.campagne AS campagne_32, o0_.special AS special_33, o0_.abrogation_datetime AS abrogation_datetime_34, o0_.date_limite_depot_referencement AS date_limite_depot_referencement_35, o0_.end_zni_date AS end_zni_date_36, o0_.globalConfigurationHash AS globalConfigurationHash_37, o0_.zni AS zni_38, o0_.cdp_eligible AS cdp_eligible_39, o0_.simulateur_id AS simulateur_id_40, o0_.arrete_id AS arrete_id_41, o0_.certification_id AS certification_id_42, o0_.qualification_id AS qualification_id_43, o0_.formConfigEngine_id AS formConfigEngine_id_44 FROM Operation o0_ WHERE o0_.nom IN ('BAR-TH-113', 'BAR-TH-143', 'BAR-TH-159', 'BAR-TH-112', 'BAR-TH-113', 'BAR-TH-143', 'BAR-TH-159', 'BAR-TH-112', 'BAR-TH-172', 'BAR-TH-171', 'BAR-TH-172', 'BAR-TH-112', 'BAR-TH-113', 'BAR-TH-143');

UPDATE
  OffreProjet
SET
  initiateCDP = ?,
  applicationFeesPrice = ?,
  attributes = ?,
  qualificationRecord_id = ?,
  signatureAuto_id = ?,
  updated_datetime = ?,
  qualificationRecordDate = ?
WHERE
  id = ?

UPDATE OffreProjet SET initiateCDP = 1, applicationFeesPrice = '0', attributes = '{\"history\":[{\"date\":\"2026-08-26\",\"datetime\":\"2026-08-26 11:28:46\",\"description\":\"simulation\"},{\"description\":\"demande_convention\",\"date\":\"2026-08-26\",\"datetime\":\"2026-08-26 11:28:51\"},{\"description\":\"non_retour_convention.close_projet\",\"date\":\"2026-09-25\",\"datetime\":\"2026-09-25 11:28:46\"}]}', qualificationRecord_id = 26309, signatureAuto_id = 1014, updated_datetime = '2026-08-26 11:28:52', qualificationRecordDate = '2026-08-26 11:28:52' WHERE id = 453433;

SELECT
  t0.id AS id_1,
  t0.`key` AS key_2,
  t0.`value` AS value_3,
  t0.`description` AS description_4,
  t0.object_id AS object_id_5,
  t0.object_class AS object_class_6,
  t0.is_default AS is_default_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  Configuration t0
WHERE
  t0.`key` = ?
  AND t0.object_id = ?
  AND t0.object_class = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3, t0.`description` AS description_4, t0.object_id AS object_id_5, t0.object_class AS object_class_6, t0.is_default AS is_default_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM Configuration t0 WHERE t0.`key` = 'type_rai' AND t0.object_id = 1169 AND t0.object_class = 'Consoneo\\Bundle\\UserBundle\\Entity\\TeteReseau' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  AffectationOffre a0_
WHERE
  a0_.offreProjet_id = ?
  AND a0_.obligeRole_id = ?
LIMIT
  1

SELECT COUNT(a0_.id) AS sclr_0 FROM AffectationOffre a0_ WHERE a0_.offreProjet_id = 453433 AND a0_.obligeRole_id = 9 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.`key` AS key_2,
  t0.`value` AS value_3,
  t0.`description` AS description_4,
  t0.object_id AS object_id_5,
  t0.object_class AS object_class_6,
  t0.is_default AS is_default_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  Configuration t0
WHERE
  t0.`key` = ?
  AND t0.object_id = ?
  AND t0.object_class = ?
  AND t0.is_default = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3, t0.`description` AS description_4, t0.object_id AS object_id_5, t0.object_class AS object_class_6, t0.is_default AS is_default_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM Configuration t0 WHERE t0.`key` = 'devis_auto_mandatory_BAR-TH-171' AND t0.object_id = 9598 AND t0.object_class = 'Consoneo\\Bundle\\UserBundle\\Entity\\Installateur' AND t0.is_default = 0 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.role AS role_2,
  t0.title AS title_3,
  t0.scope AS scope_4,
  t0.position AS position_5,
  t0.definition AS definition_6,
  t0.cycle AS cycle_7,
  t0.only_consoneo_update AS only_consoneo_update_8
FROM
  ObligeRole t0
WHERE
  t0.role = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.role AS role_2, t0.title AS title_3, t0.scope AS scope_4, t0.position AS position_5, t0.definition AS definition_6, t0.cycle AS cycle_7, t0.only_consoneo_update AS only_consoneo_update_8 FROM ObligeRole t0 WHERE t0.role = 'ROLE_OPERATEUR_CONTROLE_OFFRE_B2C' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.name AS name_3,
  t0.originalEmailName AS originalEmailName_4,
  t0.created_datetime AS created_datetime_5,
  t0.weight AS weight_6,
  t0.originalNeeded AS originalNeeded_7,
  t0.allowedUniverSign AS allowedUniverSign_8,
  t0.description AS description_9
FROM
  DocumentType t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.originalEmailName AS originalEmailName_4, t0.created_datetime AS created_datetime_5, t0.weight AS weight_6, t0.originalNeeded AS originalNeeded_7, t0.allowedUniverSign AS allowedUniverSign_8, t0.description AS description_9 FROM DocumentType t0 WHERE t0.slug = 'rapport_de_lorganisme_dinspection' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.raison AS raison_2,
  t0.siret AS siret_3,
  t0.adresse AS adresse_4,
  t0.adresse_complement AS adresse_complement_5,
  t0.codepostal AS codepostal_6,
  t0.ville AS ville_7,
  t0.website AS website_8,
  t0.effectif AS effectif_9,
  t0.status AS status_10,
  t0.created_datetime AS created_datetime_11,
  t0.updated_datetime AS updated_datetime_12,
  t0.signature AS signature_13,
  t0.logo AS logo_14,
  t0.formation_installateur_doc AS formation_installateur_doc_15,
  t0.pres_marketing_installateur AS pres_marketing_installateur_16,
  t0.guide_utilisation_commerciaux AS guide_utilisation_commerciaux_17,
  t0.guidePerformanceEnergetiqueB2b AS guidePerformanceEnergetiqueB2b_18,
  t0.guidePerformanceEnergetiqueB2c AS guidePerformanceEnergetiqueB2c_19,
  t0.cgu AS cgu_20,
  t0.partenariatContract AS partenariatContract_21,
  t0.tel_beneficiaire_B2C AS tel_beneficiaire_B2C_22,
  t0.tel_beneficiaire_B2B AS tel_beneficiaire_B2B_23,
  t0.tel_installateur AS tel_installateur_24,
  t0.tel_support_intern AS tel_support_intern_25,
  t0.fax_beneficiaire AS fax_beneficiaire_26,
  t0.fax_installateur AS fax_installateur_27,
  t0.email_beneficiaire AS email_beneficiaire_28,
  t0.email_installateur AS email_installateur_29,
  t0.is_consoneo AS is_consoneo_30,
  t0.slug AS slug_31,
  t0.conventionElectronique AS conventionElectronique_32,
  t0.aftElectronique AS aftElectronique_33,
  t0.contratInstallateur AS contratInstallateur_34,
  t0.modeProBeneficiaireInscription AS modeProBeneficiaireInscription_35,
  t0.modeByPassSuperviseur AS modeByPassSuperviseur_36,
  t0.`lead` AS lead_37,
  t0.`leadUrl` AS leadUrl_38,
  t0.`leadLogin` AS leadLogin_39,
  t0.`leadPassword` AS leadPassword_40,
  t0.relanceConventionClientUn AS relanceConventionClientUn_41,
  t0.relanceConventionClientDeux AS relanceConventionClientDeux_42,
  t0.alertConventionClient AS alertConventionClient_43,
  t0.relanceConventionInstallateurUn AS relanceConventionInstallateurUn_44,
  t0.relanceConventionInstallateurDeux AS relanceConventionInstallateurDeux_45,
  t0.alertConventionInstallateur AS alertConventionInstallateur_46,
  t0.conventionFin AS conventionFin_47,
  t0.questionnaireAftRelanceUn AS questionnaireAftRelanceUn_48,
  t0.questionnaireAftRelanceDeux AS questionnaireAftRelanceDeux_49,
  t0.alertQuestionnaireAFT AS alertQuestionnaireAFT_50,
  t0.questionnaireAftFin AS questionnaireAftFin_51,
  t0.relanceAftFacture AS relanceAftFacture_52,
  t0.alertAftFacture AS alertAftFacture_53,
  t0.aftFactureFin AS aftFactureFin_54,
  t0.mentionCnil AS mentionCnil_55,
  t0.serviceType AS serviceType_56,
  t0.precariteMode AS precariteMode_57,
  t0.precariteModeProgram AS precariteModeProgram_58,
  t0.blocked AS blocked_59,
  t0.blockedSimulation AS blockedSimulation_60,
  t0.resiliation AS resiliation_61,
  t0.archivageAuto AS archivageAuto_62,
  t0.travauxPostDevis AS travauxPostDevis_63,
  t0.emailFacturationPro AS emailFacturationPro_64,
  t0.mandatoryInstallateurGenericContract AS mandatoryInstallateurGenericContract_65,
  t0.hiddenEmail AS hiddenEmail_66,
  t0.certificallCompanyId AS certificallCompanyId_67,
  t0.visibilityCommercials AS visibilityCommercials_68,
  t0.mandat AS mandat_69,
  t0.pricingMandatClassique AS pricingMandatClassique_70,
  t0.pricingMandatPreca AS pricingMandatPreca_71,
  t0.pricingPrimeMaximumMandatClassique AS pricingPrimeMaximumMandatClassique_72,
  t0.pricingPrimeMaximumMandatPreca AS pricingPrimeMaximumMandatPreca_73,
  t0.originauxAdresse AS originauxAdresse_74,
  t0.originauxAdresseComplement AS originauxAdresseComplement_75,
  t0.originauxCodepostal AS originauxCodepostal_76,
  t0.originauxVille AS originauxVille_77,
  t0.eligible AS eligible_78,
  t0.satisfactionSurvey AS satisfactionSurvey_79,
  t0.surveyConfiguration AS surveyConfiguration_80,
  t0.autoPayment AS autoPayment_81,
  t0.isAnnexeDechetQuestion AS isAnnexeDechetQuestion_82,
  t0.aiEnabled AS aiEnabled_83,
  t0.isSignatureAutoAhEnabled AS isSignatureAutoAhEnabled_84,
  t0.isSignatureAutoOtherDocumentsEnabled AS isSignatureAutoOtherDocumentsEnabled_85,
  t0.emailVersion AS emailVersion_86,
  t0.validateBackwards AS validateBackwards_87,
  t0.displayTelConsoneo AS displayTelConsoneo_88,
  t0.allowedUniverSign AS allowedUniverSign_89,
  t0.allowedApplicationFees AS allowedApplicationFees_90,
  t0.displayApplicationFees AS displayApplicationFees_91,
  t0.programAutoAllowed AS programAutoAllowed_92,
  t0.mpr AS mpr_93,
  t0.isRibActivated AS isRibActivated_94,
  t0.canonicalTeteReseau_id AS canonicalTeteReseau_id_95,
  t0.oblige_id AS oblige_id_96,
  t97.id AS id_98,
  t97.raison AS raison_99,
  t97.email AS email_100,
  t97.tel AS tel_101,
  t97.site_web AS site_web_102,
  t97.adresse AS adresse_103,
  t97.cp AS cp_104,
  t97.ville AS ville_105,
  t97.oblige_id AS oblige_id_106,
  t107.id AS id_108,
  t107.gender AS gender_109,
  t107.firstName AS firstName_110,
  t107.name AS name_111,
  t107.raison AS raison_112,
  t107.email AS email_113,
  t107.tel AS tel_114,
  t107.address AS address_115,
  t107.cp AS cp_116,
  t107.city AS city_117,
  t107.adminMandate AS adminMandate_118,
  t107.financialMandate AS financialMandate_119,
  t107.mixteMandate AS mixteMandate_120,
  t107.signature AS signature_121,
  t107.tutorial_admin AS tutorial_admin_122,
  t107.tutorial_mixte AS tutorial_mixte_123,
  t107.tutorial_financial AS tutorial_financial_124,
  t107.oblige_id AS oblige_id_125,
  t126.id AS id_127,
  t126.raison AS raison_128,
  t126.siret AS siret_129,
  t126.oblige_id AS oblige_id_130
FROM
  Oblige t0
  LEFT JOIN Mediateur t97 ON t97.oblige_id = t0.id
  LEFT JOIN MprConfig t107 ON t107.oblige_id = t0.id
  LEFT JOIN Mandataire t126 ON t126.oblige_id = t0.id
WHERE
  t0.id = ?