Symfony Profiler

SELECT
  DISTINCT o0_.id AS id_0,
  o0_.property AS property_1,
  o0_.satisfied AS satisfied_2,
  o0_.satisfied_datetime AS satisfied_datetime_3,
  o0_.created_datetime AS created_datetime_4,
  o0_.updated_datetime AS updated_datetime_5,
  o0_.propositionElectronique AS propositionElectronique_6,
  o0_.firstUpload AS firstUpload_7,
  o0_.offreProjetsGroup AS offreProjetsGroup_8,
  o0_.offreProjet_id AS offreProjet_id_9,
  o0_.type_id AS type_id_10,
  o0_.certification_id AS certification_id_11,
  o0_.qualification_id AS qualification_id_12,
  o0_.document_id AS document_id_13
FROM
  OffreProjetDocumentObligatoire o0_
  INNER JOIN DocumentType d1_ ON o0_.type_id = d1_.id
  INNER JOIN OffreProjet o2_ ON o0_.offreProjet_id = o2_.id
  LEFT JOIN ParticulierUser p3_ ON o2_.particulierUser_id = p3_.id
  LEFT JOIN Cas1 c4_ ON p3_.cas1_id = c4_.id
  LEFT JOIN Justificatif j5_ ON c4_.id = j5_.cas1_id
  LEFT JOIN ParticulierUserContact p6_ ON o2_.particulierUserContact_id = p6_.id
  LEFT JOIN Cas1 c7_ ON p6_.cas1_id = c7_.id
  LEFT JOIN Justificatif j8_ ON c7_.id = j8_.cas1_id
  LEFT JOIN Justificatif j9_ ON o2_.justificatif_id = j9_.id
WHERE
  o0_.satisfied = ?
  AND d1_.slug = ?
  AND (
    j5_.id = ?
    OR j8_.id = ?
    OR j9_.id = ?
  )
  AND (
    (
      o2_.dateCommande IS NOT NULL
      AND YEAR(o2_.dateCommande) IN (?, ?)
    )
    OR (
      o2_.dateCommande IS NULL
      AND YEAR(o2_.created_datetime) IN (?, ?)
    )
  )

SELECT DISTINCT o0_.id AS id_0, o0_.property AS property_1, o0_.satisfied AS satisfied_2, o0_.satisfied_datetime AS satisfied_datetime_3, o0_.created_datetime AS created_datetime_4, o0_.updated_datetime AS updated_datetime_5, o0_.propositionElectronique AS propositionElectronique_6, o0_.firstUpload AS firstUpload_7, o0_.offreProjetsGroup AS offreProjetsGroup_8, o0_.offreProjet_id AS offreProjet_id_9, o0_.type_id AS type_id_10, o0_.certification_id AS certification_id_11, o0_.qualification_id AS qualification_id_12, o0_.document_id AS document_id_13 FROM OffreProjetDocumentObligatoire o0_ INNER JOIN DocumentType d1_ ON o0_.type_id = d1_.id INNER JOIN OffreProjet o2_ ON o0_.offreProjet_id = o2_.id LEFT JOIN ParticulierUser p3_ ON o2_.particulierUser_id = p3_.id LEFT JOIN Cas1 c4_ ON p3_.cas1_id = c4_.id LEFT JOIN Justificatif j5_ ON c4_.id = j5_.cas1_id LEFT JOIN ParticulierUserContact p6_ ON o2_.particulierUserContact_id = p6_.id LEFT JOIN Cas1 c7_ ON p6_.cas1_id = c7_.id LEFT JOIN Justificatif j8_ ON c7_.id = j8_.cas1_id LEFT JOIN Justificatif j9_ ON o2_.justificatif_id = j9_.id WHERE o0_.satisfied = 0 AND d1_.slug = 'avis_imposition' AND (j5_.id = 361 OR j8_.id = 361 OR j9_.id = 361) AND ((o2_.dateCommande IS NOT NULL AND YEAR(o2_.dateCommande) IN (2026, 2027)) OR (o2_.dateCommande IS NULL AND YEAR(o2_.created_datetime) IN (2026, 2027)));

UPDATE
  ParticulierUserContact
SET
  cas1_id = ?,
  updatedAt = ?
WHERE
  id = ?

UPDATE ParticulierUserContact SET cas1_id = 288, updatedAt = '2026-09-16 17:18:08' WHERE id = 268;

SELECT
  s0_.id AS id_0,
  s0_.type AS type_1,
  s0_.step AS step_2,
  s0_.satisfied AS satisfied_3,
  s0_.controlComment AS controlComment_4,
  s0_.origin AS origin_5,
  s0_.overrideControl AS overrideControl_6,
  s0_.overrideControlReason AS overrideControlReason_7,
  s0_.created_at AS created_at_8,
  s0_.updated_at AS updated_at_9,
  s0_.batch_id AS batch_id_10,
  s0_.offreProjet_id AS offreProjet_id_11,
  s0_.operationRecord_id AS operationRecord_id_12,
  s0_.obligeUser_id AS obligeUser_id_13
FROM
  SampleCofracOperation s0_
WHERE
  s0_.offreProjet_id = ?
  AND s0_.step <> ?

SELECT s0_.id AS id_0, s0_.type AS type_1, s0_.step AS step_2, s0_.satisfied AS satisfied_3, s0_.controlComment AS controlComment_4, s0_.origin AS origin_5, s0_.overrideControl AS overrideControl_6, s0_.overrideControlReason AS overrideControlReason_7, s0_.created_at AS created_at_8, s0_.updated_at AS updated_at_9, s0_.batch_id AS batch_id_10, s0_.offreProjet_id AS offreProjet_id_11, s0_.operationRecord_id AS operationRecord_id_12, s0_.obligeUser_id AS obligeUser_id_13 FROM SampleCofracOperation s0_ WHERE s0_.offreProjet_id = 1467 AND s0_.step <> 'not_sampled';

SELECT
  j0_.id AS id_0,
  j0_.token AS token_1,
  j0_.type AS type_2,
  j0_.source AS source_3,
  j0_.choice AS choice_4,
  j0_.declared_year AS declared_year_5,
  j0_.declared_tax_income AS declared_tax_income_6,
  j0_.nb_people_declared AS nb_people_declared_7,
  j0_.tax_year AS tax_year_8,
  j0_.address AS address_9,
  j0_.zip_code AS zip_code_10,
  j0_.city AS city_11,
  j0_.country AS country_12,
  j0_.nb_dependents AS nb_dependents_13,
  j0_.reference_tax_income AS reference_tax_income_14,
  j0_.nb_tax_parts AS nb_tax_parts_15,
  j0_.address_supplement AS address_supplement_16,
  j0_.doc_iua AS doc_iua_17,
  j0_.createdAt AS createdAt_18,
  j0_.updatedAt AS updatedAt_19,
  j0_.cas1_id AS cas1_id_20,
  j0_.main_declarant_id AS main_declarant_id_21,
  j0_.secondAvis_id AS secondAvis_id_22,
  j0_.campagneUser_id AS campagneUser_id_23
FROM
  Justificatif j0_
  INNER JOIN Cas1 c1_ ON j0_.cas1_id = c1_.id
WHERE
  c1_.id = ?
  AND (
    (
      j0_.tax_year IS NOT NULL
      AND j0_.tax_year IN (2025, 2026)
    )
    OR (
      j0_.declared_year IS NOT NULL
      AND j0_.declared_year IN (2025, 2026)
    )
  )
ORDER BY
  j0_.tax_year DESC,
  j0_.declared_year DESC,
  j0_.createdAt DESC

SELECT j0_.id AS id_0, j0_.token AS token_1, j0_.type AS type_2, j0_.source AS source_3, j0_.choice AS choice_4, j0_.declared_year AS declared_year_5, j0_.declared_tax_income AS declared_tax_income_6, j0_.nb_people_declared AS nb_people_declared_7, j0_.tax_year AS tax_year_8, j0_.address AS address_9, j0_.zip_code AS zip_code_10, j0_.city AS city_11, j0_.country AS country_12, j0_.nb_dependents AS nb_dependents_13, j0_.reference_tax_income AS reference_tax_income_14, j0_.nb_tax_parts AS nb_tax_parts_15, j0_.address_supplement AS address_supplement_16, j0_.doc_iua AS doc_iua_17, j0_.createdAt AS createdAt_18, j0_.updatedAt AS updatedAt_19, j0_.cas1_id AS cas1_id_20, j0_.main_declarant_id AS main_declarant_id_21, j0_.secondAvis_id AS secondAvis_id_22, j0_.campagneUser_id AS campagneUser_id_23 FROM Justificatif j0_ INNER JOIN Cas1 c1_ ON j0_.cas1_id = c1_.id WHERE c1_.id = 288 AND ((j0_.tax_year IS NOT NULL AND j0_.tax_year IN (2025, 2026)) OR (j0_.declared_year IS NOT NULL AND j0_.declared_year IN (2025, 2026))) ORDER BY j0_.tax_year DESC, j0_.declared_year DESC, j0_.createdAt DESC;

INSERT INTO OffreProjetDocumentObligatoire (
  property, satisfied, satisfied_datetime,
  created_datetime, updated_datetime,
  propositionElectronique, firstUpload,
  offreProjetsGroup, offreProjet_id,
  type_id, certification_id, qualification_id,
  document_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO OffreProjetDocumentObligatoire (property, satisfied, satisfied_datetime, created_datetime, updated_datetime, propositionElectronique, firstUpload, offreProjetsGroup, offreProjet_id, type_id, certification_id, qualification_id, document_id) VALUES (NULL, 0, NULL, '2026-09-16 17:18:08', '2026-09-16 17:18:08', 0, 0, NULL, 1467, 390, NULL, NULL, NULL);

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 = 1467 LIMIT 1;

"COMMIT"

"COMMIT";

INSERT INTO jms_jobs (
  state, queue, priority, createdAt,
  startedAt, checkedAt, workerName,
  executeAfter, closedAt, command,
  args, output, errorOutput, exitCode,
  maxRuntime, maxRetries, stackTrace,
  runtime, memoryUsage, memoryUsageReal,
  retry, originalJob_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?
  )

INSERT INTO jms_jobs (state, queue, priority, createdAt, startedAt, checkedAt, workerName, executeAfter, closedAt, command, args, output, errorOutput, exitCode, maxRuntime, maxRetries, stackTrace, runtime, memoryUsage, memoryUsageReal, retry, originalJob_id) VALUES ('pending', 'default', 0, '2026-09-16 17:18:09', NULL, NULL, NULL, '2026-09-16 17:18:08', NULL, 'consoneo:fiscal:mandatory-doc', '[\"f4zj0YFK79sJEXgtDBhmkSXTIY97aUbU11qNFlG0MFk\"]', NULL, NULL, NULL, 0, 0, 'N;', NULL, NULL, NULL, 0, NULL);

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.type AS type_2,
  d0_.created_datetime AS created_datetime_3,
  d0_.iua AS iua_4,
  d0_.safeId AS safeId_5,
  d0_.serviceType AS serviceType_6,
  d0_.stockage AS stockage_7,
  d0_.offreProjetsGroup AS offreProjetsGroup_8,
  d0_.offreProjet_id AS offreProjet_id_9,
  d0_.installateurUser_id AS installateurUser_id_10
FROM
  DocumentStatic d0_
  INNER JOIN OffreProjet o1_ ON d0_.offreProjet_id = o1_.id
WHERE
  d0_.offreProjet_id = ?
  AND d0_.type = ?

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.type AS type_2, d0_.created_datetime AS created_datetime_3, d0_.iua AS iua_4, d0_.safeId AS safeId_5, d0_.serviceType AS serviceType_6, d0_.stockage AS stockage_7, d0_.offreProjetsGroup AS offreProjetsGroup_8, d0_.offreProjet_id AS offreProjet_id_9, d0_.installateurUser_id AS installateurUser_id_10 FROM DocumentStatic d0_ INNER JOIN OffreProjet o1_ ON d0_.offreProjet_id = o1_.id WHERE d0_.offreProjet_id = 1467 AND d0_.type = 'ah';

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 = 'avis_imposition' LIMIT 1;

UPDATE
  Document
SET
  originalName = ?,
  valid = ?,
  process = ?,
  path = ?,
  validated_datetime = ?,
  processed_datetime = ?,
  updated_datetime = ?
WHERE
  id = ?

UPDATE Document SET originalName = 'minfi-361', valid = 1, process = 1, path = 's3://dossier-c2e-dev/entity/Justificatif/minfi-361', validated_datetime = '2026-09-16 17:18:09', processed_datetime = '2026-09-16 17:18:09', updated_datetime = '2026-09-16 17:18:09' WHERE id = 2796072;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.pricingType AS pricingType_3,
  t0.finalisationRequested AS finalisationRequested_4,
  t0.finalisationRequestDate AS finalisationRequestDate_5,
  t0.cofracSatisfyDate AS cofracSatisfyDate_6,
  t0.reference AS reference_7,
  t0.data AS data_8,
  t0.cofracData AS cofracData_9,
  t0.cofracEngineDocumentId AS cofracEngineDocumentId_10,
  t0.ip AS ip_11,
  t0.offre_auto_date AS offre_auto_date_12,
  t0.created_datetime AS created_datetime_13,
  t0.updated_datetime AS updated_datetime_14,
  t0.tel AS tel_15,
  t0.codepostal AS codepostal_16,
  t0.adresse AS adresse_17,
  t0.adresse_complement AS adresse_complement_18,
  t0.ville AS ville_19,
  t0.delai_souhaite AS delai_souhaite_20,
  t0.accept_recevoir_offre AS accept_recevoir_offre_21,
  t0.accept_recommandation AS accept_recommandation_22,
  t0.acceptLeadPromo AS acceptLeadPromo_23,
  t0.offre_cumac AS offre_cumac_24,
  t0.offre_cumac_client AS offre_cumac_client_25,
  t0.offre_cumac_precarite AS offre_cumac_precarite_26,
  t0.offre_cumac_client_precarite AS offre_cumac_client_precarite_27,
  t0.cumac AS cumac_28,
  t0.cumac_AFT AS cumac_AFT_29,
  t0.total_prime AS total_prime_30,
  t0.total_prime_AFT AS total_prime_AFT_31,
  t0.prime_pro AS prime_pro_32,
  t0.prime_pro_aft AS prime_pro_aft_33,
  t0.prime_client AS prime_client_34,
  t0.prime_client_aft AS prime_client_aft_35,
  t0.cumac_moyenne AS cumac_moyenne_36,
  t0.taux_actualise AS taux_actualise_37,
  t0.taux_accumule AS taux_accumule_38,
  t0.date_debut_chantier AS date_debut_chantier_39,
  t0.date_demande_offre AS date_demande_offre_40,
  t0.date_fin_chantier AS date_fin_chantier_41,
  t0.etat AS etat_42,
  t0.status AS status_43,
  t0.date_offre AS date_offre_44,
  t0.notification_date_chantier AS notification_date_chantier_45,
  t0.date_retour_conv AS date_retour_conv_46,
  t0.date_validation_conv AS date_validation_conv_47,
  t0.date_chantier_renseigne AS date_chantier_renseigne_48,
  t0.date_paiement AS date_paiement_49,
  t0.date_all_doc_valid AS date_all_doc_valid_50,
  t0.date_fin_chantier_repousse AS date_fin_chantier_repousse_51,
  t0.date_envoi_questionnaire AS date_envoi_questionnaire_52,
  t0.date_edition_questionnaire AS date_edition_questionnaire_53,
  t0.date_validation_final AS date_validation_final_54,
  t0.date_annulation AS date_annulation_55,
  t0.no_click_email_date_chantier AS no_click_email_date_chantier_56,
  t0.token AS token_57,
  t0.auto_installation AS auto_installation_58,
  t0.siret AS siret_59,
  t0.cancelReason AS cancelReason_60,
  t0.dateCommande AS dateCommande_61,
  t0.siteTravaux AS siteTravaux_62,
  t0.incitation AS incitation_63,
  t0.qualificationRecordDate AS qualificationRecordDate_64,
  t0.serviceType AS serviceType_65,
  t0.debutChantier AS debutChantier_66,
  t0.finChantier AS finChantier_67,
  t0.initiateCDP AS initiateCDP_68,
  t0.cdp AS cdp_69,
  t0.date_last_envoi_convention AS date_last_envoi_convention_70,
  t0.programStep AS programStep_71,
  t0.devisRestAPayer AS devisRestAPayer_72,
  t0.pricingMandatClassique AS pricingMandatClassique_73,
  t0.pricingMandatPreca AS pricingMandatPreca_74,
  t0.isCOFRAC AS isCOFRAC_75,
  t0.applicationFeesPrice AS applicationFeesPrice_76,
  t0.attributes AS attributes_77,
  t0.exclusive AS exclusive_78,
  t0.engineDocumentId AS engineDocumentId_79,
  t0.adresseTravaux AS adresseTravaux_80,
  t0.adresseTravauxCommentaire AS adresseTravauxCommentaire_81,
  t0.batchOffreProjet_id AS batchOffreProjet_id_82,
  t0.entrepriseUser_id AS entrepriseUser_id_83,
  t0.installateurUser_id AS installateurUser_id_84,
  t0.beUser_id AS beUser_id_85,
  t0.entrepriseUserContact_id AS entrepriseUserContact_id_86,
  t0.particulierUserContact_id AS particulierUserContact_id_87,
  t0.signataireEntreprise_id AS signataireEntreprise_id_88,
  t0.signataireInstallateur_id AS signataireInstallateur_id_89,
  t0.installateurUserContact_id AS installateurUserContact_id_90,
  t0.projet_id AS projet_id_91,
  t0.precariteCas2_id AS precariteCas2_id_92,
  t0.creditNoteContract_id AS creditNoteContract_id_93,
  t0.precarite_id AS precarite_id_94,
  t0.state_id AS state_id_95,
  t96.id AS id_97,
  t96.created_datetime AS created_datetime_98,
  t96.convention AS convention_99,
  t96.aft AS aft_100,
  t96.facture AS facture_101,
  t96.beneficiaire AS beneficiaire_102,
  t96.installateur AS installateur_103,
  t96.doc_obligatoire AS doc_obligatoire_104,
  t96.coherence_dossier AS coherence_dossier_105,
  t96.offre_id AS offre_id_106,
  t0.oblige_id AS oblige_id_107,
  t0.secteurActivite_id AS secteurActivite_id_108,
  t0.factureDetail_id AS factureDetail_id_109,
  t110.id AS id_111,
  t110.reference AS reference_112,
  t110.type AS type_113,
  t110.result AS result_114,
  t110.errors AS errors_115,
  t110.message AS message_116,
  t110.created_datetime AS created_datetime_117,
  t110.integrationModule_id AS integrationModule_id_118,
  t110.offre_id AS offre_id_119,
  t0.offreStatus_id AS offreStatus_id_120,
  t0.identiteBeneficiaire_id AS identiteBeneficiaire_id_121,
  t0.identiteInstallateur_id AS identiteInstallateur_id_122,
  t0.operation_id AS operation_id_123,
  t0.particulierUser_id AS particulierUser_id_124,
  t0.qualificationRecord_id AS qualificationRecord_id_125,
  t0.sousTraitant_id AS sousTraitant_id_126,
  t0.program_id AS program_id_127,
  t0.programCommercial_id AS programCommercial_id_128,
  t0.programManager_id AS programManager_id_129,
  t0.signatureAuto_id AS signatureAuto_id_130,
  t0.wasteCenter_id AS wasteCenter_id_131,
  t0.waste_id AS waste_id_132,
  t0.programAuto_id AS programAuto_id_133,
  t0.justificatif_id AS justificatif_id_134,
  t0.cappingRule_id AS cappingRule_id_135,
  t136.id AS id_137,
  t136.mprUuid AS mprUuid_138,
  t136.mprReference AS mprReference_139,
  t136.paymentDate AS paymentDate_140,
  t136.invoiceReference AS invoiceReference_141,
  t136.invoiceDate AS invoiceDate_142,
  t136.amount AS amount_143,
  t136.archive AS archive_144,
  t136.step AS step_145,
  t136.offreProjet_id AS offreProjet_id_146,
  t136.batchBankTransfer_id AS batchBankTransfer_id_147,
  t136.installateur_id AS installateur_id_148,
  t136.particulierUser_id AS particulierUser_id_149,
  t150.id AS id_151,
  t150.numero AS numero_152,
  t150.dateRealisation AS dateRealisation_153,
  t150.dateFinValidite AS dateFinValidite_154,
  t150.etiquetteBilan AS etiquetteBilan_155,
  t150.createdAt AS createdAt_156,
  t150.updatedAt AS updatedAt_157,
  t150.typeJustificatif AS typeJustificatif_158,
  t150.projet_id AS projet_id_159,
  t150.offreProjet_id AS offreProjet_id_160,
  t0.projectOwner_id AS projectOwner_id_161,
  t0.project_bundle_id AS project_bundle_id_162,
  t0.estate_id AS estate_id_163,
  t164.id AS id_165,
  t164.`value` AS value_166,
  t164.offreProjet_id AS offreProjet_id_167,
  t164.operation_id AS operation_id_168,
  t164.oblige_id AS oblige_id_169
FROM
  OffreProjet t0
  LEFT JOIN OffreProjetValidation t96 ON t96.offre_id = t0.id
  LEFT JOIN `Lead` t110 ON t110.offre_id = t0.id
  LEFT JOIN PaymentMpr t136 ON t136.offreProjet_id = t0.id
  LEFT JOIN JustificatifPerformanceEnergetique t150 ON t150.offreProjet_id = t0.id
  LEFT JOIN Recensement t164 ON t164.offreProjet_id = t0.id
WHERE
  t0.particulierUserContact_id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.pricingType AS pricingType_3, t0.finalisationRequested AS finalisationRequested_4, t0.finalisationRequestDate AS finalisationRequestDate_5, t0.cofracSatisfyDate AS cofracSatisfyDate_6, t0.reference AS reference_7, t0.data AS data_8, t0.cofracData AS cofracData_9, t0.cofracEngineDocumentId AS cofracEngineDocumentId_10, t0.ip AS ip_11, t0.offre_auto_date AS offre_auto_date_12, t0.created_datetime AS created_datetime_13, t0.updated_datetime AS updated_datetime_14, t0.tel AS tel_15, t0.codepostal AS codepostal_16, t0.adresse AS adresse_17, t0.adresse_complement AS adresse_complement_18, t0.ville AS ville_19, t0.delai_souhaite AS delai_souhaite_20, t0.accept_recevoir_offre AS accept_recevoir_offre_21, t0.accept_recommandation AS accept_recommandation_22, t0.acceptLeadPromo AS acceptLeadPromo_23, t0.offre_cumac AS offre_cumac_24, t0.offre_cumac_client AS offre_cumac_client_25, t0.offre_cumac_precarite AS offre_cumac_precarite_26, t0.offre_cumac_client_precarite AS offre_cumac_client_precarite_27, t0.cumac AS cumac_28, t0.cumac_AFT AS cumac_AFT_29, t0.total_prime AS total_prime_30, t0.total_prime_AFT AS total_prime_AFT_31, t0.prime_pro AS prime_pro_32, t0.prime_pro_aft AS prime_pro_aft_33, t0.prime_client AS prime_client_34, t0.prime_client_aft AS prime_client_aft_35, t0.cumac_moyenne AS cumac_moyenne_36, t0.taux_actualise AS taux_actualise_37, t0.taux_accumule AS taux_accumule_38, t0.date_debut_chantier AS date_debut_chantier_39, t0.date_demande_offre AS date_demande_offre_40, t0.date_fin_chantier AS date_fin_chantier_41, t0.etat AS etat_42, t0.status AS status_43, t0.date_offre AS date_offre_44, t0.notification_date_chantier AS notification_date_chantier_45, t0.date_retour_conv AS date_retour_conv_46, t0.date_validation_conv AS date_validation_conv_47, t0.date_chantier_renseigne AS date_chantier_renseigne_48, t0.date_paiement AS date_paiement_49, t0.date_all_doc_valid AS date_all_doc_valid_50, t0.date_fin_chantier_repousse AS date_fin_chantier_repousse_51, t0.date_envoi_questionnaire AS date_envoi_questionnaire_52, t0.date_edition_questionnaire AS date_edition_questionnaire_53, t0.date_validation_final AS date_validation_final_54, t0.date_annulation AS date_annulation_55, t0.no_click_email_date_chantier AS no_click_email_date_chantier_56, t0.token AS token_57, t0.auto_installation AS auto_installation_58, t0.siret AS siret_59, t0.cancelReason AS cancelReason_60, t0.dateCommande AS dateCommande_61, t0.siteTravaux AS siteTravaux_62, t0.incitation AS incitation_63, t0.qualificationRecordDate AS qualificationRecordDate_64, t0.serviceType AS serviceType_65, t0.debutChantier AS debutChantier_66, t0.finChantier AS finChantier_67, t0.initiateCDP AS initiateCDP_68, t0.cdp AS cdp_69, t0.date_last_envoi_convention AS date_last_envoi_convention_70, t0.programStep AS programStep_71, t0.devisRestAPayer AS devisRestAPayer_72, t0.pricingMandatClassique AS pricingMandatClassique_73, t0.pricingMandatPreca AS pricingMandatPreca_74, t0.isCOFRAC AS isCOFRAC_75, t0.applicationFeesPrice AS applicationFeesPrice_76, t0.attributes AS attributes_77, t0.exclusive AS exclusive_78, t0.engineDocumentId AS engineDocumentId_79, t0.adresseTravaux AS adresseTravaux_80, t0.adresseTravauxCommentaire AS adresseTravauxCommentaire_81, t0.batchOffreProjet_id AS batchOffreProjet_id_82, t0.entrepriseUser_id AS entrepriseUser_id_83, t0.installateurUser_id AS installateurUser_id_84, t0.beUser_id AS beUser_id_85, t0.entrepriseUserContact_id AS entrepriseUserContact_id_86, t0.particulierUserContact_id AS particulierUserContact_id_87, t0.signataireEntreprise_id AS signataireEntreprise_id_88, t0.signataireInstallateur_id AS signataireInstallateur_id_89, t0.installateurUserContact_id AS installateurUserContact_id_90, t0.projet_id AS projet_id_91, t0.precariteCas2_id AS precariteCas2_id_92, t0.creditNoteContract_id AS creditNoteContract_id_93, t0.precarite_id AS precarite_id_94, t0.state_id AS state_id_95, t96.id AS id_97, t96.created_datetime AS created_datetime_98, t96.convention AS convention_99, t96.aft AS aft_100, t96.facture AS facture_101, t96.beneficiaire AS beneficiaire_102, t96.installateur AS installateur_103, t96.doc_obligatoire AS doc_obligatoire_104, t96.coherence_dossier AS coherence_dossier_105, t96.offre_id AS offre_id_106, t0.oblige_id AS oblige_id_107, t0.secteurActivite_id AS secteurActivite_id_108, t0.factureDetail_id AS factureDetail_id_109, t110.id AS id_111, t110.reference AS reference_112, t110.type AS type_113, t110.result AS result_114, t110.errors AS errors_115, t110.message AS message_116, t110.created_datetime AS created_datetime_117, t110.integrationModule_id AS integrationModule_id_118, t110.offre_id AS offre_id_119, t0.offreStatus_id AS offreStatus_id_120, t0.identiteBeneficiaire_id AS identiteBeneficiaire_id_121, t0.identiteInstallateur_id AS identiteInstallateur_id_122, t0.operation_id AS operation_id_123, t0.particulierUser_id AS particulierUser_id_124, t0.qualificationRecord_id AS qualificationRecord_id_125, t0.sousTraitant_id AS sousTraitant_id_126, t0.program_id AS program_id_127, t0.programCommercial_id AS programCommercial_id_128, t0.programManager_id AS programManager_id_129, t0.signatureAuto_id AS signatureAuto_id_130, t0.wasteCenter_id AS wasteCenter_id_131, t0.waste_id AS waste_id_132, t0.programAuto_id AS programAuto_id_133, t0.justificatif_id AS justificatif_id_134, t0.cappingRule_id AS cappingRule_id_135, t136.id AS id_137, t136.mprUuid AS mprUuid_138, t136.mprReference AS mprReference_139, t136.paymentDate AS paymentDate_140, t136.invoiceReference AS invoiceReference_141, t136.invoiceDate AS invoiceDate_142, t136.amount AS amount_143, t136.archive AS archive_144, t136.step AS step_145, t136.offreProjet_id AS offreProjet_id_146, t136.batchBankTransfer_id AS batchBankTransfer_id_147, t136.installateur_id AS installateur_id_148, t136.particulierUser_id AS particulierUser_id_149, t150.id AS id_151, t150.numero AS numero_152, t150.dateRealisation AS dateRealisation_153, t150.dateFinValidite AS dateFinValidite_154, t150.etiquetteBilan AS etiquetteBilan_155, t150.createdAt AS createdAt_156, t150.updatedAt AS updatedAt_157, t150.typeJustificatif AS typeJustificatif_158, t150.projet_id AS projet_id_159, t150.offreProjet_id AS offreProjet_id_160, t0.projectOwner_id AS projectOwner_id_161, t0.project_bundle_id AS project_bundle_id_162, t0.estate_id AS estate_id_163, t164.id AS id_165, t164.`value` AS value_166, t164.offreProjet_id AS offreProjet_id_167, t164.operation_id AS operation_id_168, t164.oblige_id AS oblige_id_169 FROM OffreProjet t0 LEFT JOIN OffreProjetValidation t96 ON t96.offre_id = t0.id LEFT JOIN `Lead` t110 ON t110.offre_id = t0.id LEFT JOIN PaymentMpr t136 ON t136.offreProjet_id = t0.id LEFT JOIN JustificatifPerformanceEnergetique t150 ON t150.offreProjet_id = t0.id LEFT JOIN Recensement t164 ON t164.offreProjet_id = t0.id WHERE t0.particulierUserContact_id = 268;

SELECT
  t0.id AS id_1,
  t0.property AS property_2,
  t0.satisfied AS satisfied_3,
  t0.satisfied_datetime AS satisfied_datetime_4,
  t0.created_datetime AS created_datetime_5,
  t0.updated_datetime AS updated_datetime_6,
  t0.propositionElectronique AS propositionElectronique_7,
  t0.firstUpload AS firstUpload_8,
  t0.offreProjetsGroup AS offreProjetsGroup_9,
  t0.offreProjet_id AS offreProjet_id_10,
  t0.type_id AS type_id_11,
  t0.certification_id AS certification_id_12,
  t0.qualification_id AS qualification_id_13,
  t0.document_id AS document_id_14
FROM
  OffreProjetDocumentObligatoire t0
WHERE
  t0.type_id = ?
  AND t0.offreProjet_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.property AS property_2, t0.satisfied AS satisfied_3, t0.satisfied_datetime AS satisfied_datetime_4, t0.created_datetime AS created_datetime_5, t0.updated_datetime AS updated_datetime_6, t0.propositionElectronique AS propositionElectronique_7, t0.firstUpload AS firstUpload_8, t0.offreProjetsGroup AS offreProjetsGroup_9, t0.offreProjet_id AS offreProjet_id_10, t0.type_id AS type_id_11, t0.certification_id AS certification_id_12, t0.qualification_id AS qualification_id_13, t0.document_id AS document_id_14 FROM OffreProjetDocumentObligatoire t0 WHERE t0.type_id = 62 AND t0.offreProjet_id = 1467 LIMIT 1;

UPDATE
  Justificatif
SET
  nb_people_declared = ?,
  tax_year = ?,
  address = ?,
  zip_code = ?,
  city = ?,
  nb_dependents = ?,
  reference_tax_income = ?,
  cas1_id = ?,
  updatedAt = ?
WHERE
  id = ?

UPDATE Justificatif SET nb_people_declared = 1, tax_year = 2026, address = '9 RUE F', zip_code = '33000', city = 'BORDEAUX', nb_dependents = 0, reference_tax_income = 100, cas1_id = 288, updatedAt = '2026-09-16 17:18:08' WHERE id = 361;