Symfony Profiler

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_.address_supplement AS address_supplement_15,
  j0_.doc_iua AS doc_iua_16,
  j0_.createdAt AS createdAt_17,
  j0_.updatedAt AS updatedAt_18,
  j0_.cas1_id AS cas1_id_19,
  j0_.secondAvis_id AS secondAvis_id_20,
  j0_.campagneUser_id AS campagneUser_id_21
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_.address_supplement AS address_supplement_15, j0_.doc_iua AS doc_iua_16, j0_.createdAt AS createdAt_17, j0_.updatedAt AS updatedAt_18, j0_.cas1_id AS cas1_id_19, j0_.secondAvis_id AS secondAvis_id_20, j0_.campagneUser_id AS campagneUser_id_21 FROM Justificatif j0_ INNER JOIN Cas1 c1_ ON j0_.cas1_id = c1_.id WHERE c1_.id = 227 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
  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-02-27 23:38:07' AND c0_.disabledDate IS NOT NULL)) AND c0_.type = 'residentiel';

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` = 'ecretement_mpr' AND t0.object_id = 6 AND t0.object_class = 'Consoneo\\Bundle\\UserBundle\\Entity\\Oblige' LIMIT 1;

SELECT
  p0_.type AS type_0
FROM
  Pricing p0_
  INNER JOIN PricingGroup p1_ ON p0_.group_id = p1_.id
WHERE
  p1_.teteReseau_id = ?
  AND p1_.active = ?
  AND p0_.target = ?
  AND p0_.source = ?

SELECT p0_.type AS type_0 FROM Pricing p0_ INNER JOIN PricingGroup p1_ ON p0_.group_id = p1_.id WHERE p1_.teteReseau_id = 28 AND p1_.active = 1 AND p0_.target = 'b2c' AND p0_.source = 'b2c';

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

SELECT
  t0.id AS id_1,
  t0.nbFoyerFiscal AS nbFoyerFiscal_2,
  t0.codePostal AS codePostal_3,
  t0.situation AS situation_4,
  t0.createdAt AS createdAt_5,
  t0.updatedAt AS updatedAt_6,
  t7.username AS username_8,
  t7.email AS email_9,
  t7.enabled AS enabled_10,
  t7.salt AS salt_11,
  t7.last_login AS last_login_12,
  t7.confirmation_token AS confirmation_token_13,
  t7.password_requested_at AS password_requested_at_14,
  t7.roles AS roles_15,
  t7.email_canonical AS email_canonical_16,
  t7.username_canonical AS username_canonical_17,
  t7.password AS password_18,
  t7.adresse AS adresse_19,
  t7.adresse_complement AS adresse_complement_20,
  t7.codepostal AS codepostal_21,
  t7.ville AS ville_22,
  t7.token AS token_23,
  t7.emailRequested AS emailRequested_24,
  t7.emailRequestedDate AS emailRequestedDate_25,
  t7.inscriptionFromDemandeOffre AS inscriptionFromDemandeOffre_26,
  t7.lastOffreDate AS lastOffreDate_27,
  t7.tag AS tag_28,
  t7.emailValidatedDateTime AS emailValidatedDateTime_29,
  t7.emailCreatedDateTime AS emailCreatedDateTime_30,
  t7.mobileCreatedDatetime AS mobileCreatedDatetime_31,
  t7.cdiscountGuid AS cdiscountGuid_32,
  t7.cdiscountCdav AS cdiscountCdav_33,
  t7.gender AS gender_34,
  t7.relanceSmsRegistration AS relanceSmsRegistration_35,
  t7.dateRelanceSmsRegistration AS dateRelanceSmsRegistration_36,
  t7.id AS id_37,
  t7.nom AS nom_38,
  t7.prenom AS prenom_39,
  t7.fonction AS fonction_40,
  t7.tel AS tel_41,
  t7.mobile AS mobile_42,
  t7.activation AS activation_43,
  t7.createdAt AS createdAt_44,
  t7.updatedAt AS updatedAt_45,
  t7.optin AS optin_46,
  t7.dateActivation AS dateActivation_47,
  t7.sendEmail AS sendEmail_48,
  t7.workflow_id AS workflow_id_49,
  t7.cas1_id AS cas1_id_50,
  t7.identite_id AS identite_id_51,
  t7.integrationModule_id AS integrationModule_id_52,
  t53.enabled AS enabled_54,
  t53.salt AS salt_55,
  t53.last_login AS last_login_56,
  t53.confirmation_token AS confirmation_token_57,
  t53.password_requested_at AS password_requested_at_58,
  t53.roles AS roles_59,
  t53.email_canonical AS email_canonical_60,
  t53.username_canonical AS username_canonical_61,
  t53.password AS password_62,
  t53.dateEnvoiGuide AS dateEnvoiGuide_63,
  t53.token AS token_64,
  t53.emailJustificatifPreca AS emailJustificatifPreca_65,
  t53.adresse AS adresse_66,
  t53.adresse_complement AS adresse_complement_67,
  t53.codepostal AS codepostal_68,
  t53.ville AS ville_69,
  t53.formPrecaResponse AS formPrecaResponse_70,
  t53.gender AS gender_71,
  t53.stampFilename AS stampFilename_72,
  t53.id AS id_73,
  t53.nom AS nom_74,
  t53.prenom AS prenom_75,
  t53.fonction AS fonction_76,
  t53.tel AS tel_77,
  t53.mobile AS mobile_78,
  t53.activation AS activation_79,
  t53.createdAt AS createdAt_80,
  t53.updatedAt AS updatedAt_81,
  t53.optin AS optin_82,
  t53.dateActivation AS dateActivation_83,
  t53.emailValidatedDateTime AS emailValidatedDateTime_84,
  t53.emailCreatedDateTime AS emailCreatedDateTime_85,
  t53.mobileCreatedDatetime AS mobileCreatedDatetime_86,
  t53.sendEmail AS sendEmail_87,
  t53.email AS email_88,
  t53.username AS username_89,
  t53.cas1_id AS cas1_id_90,
  t53.identite_id AS identite_id_91,
  t53.integrationModule_id AS integrationModule_id_92,
  t93.id AS id_94,
  t93.activation AS activation_95,
  t93.step AS step_96,
  t93.prenom AS prenom_97,
  t93.nom AS nom_98,
  t93.tel AS tel_99,
  t93.mobile AS mobile_100,
  t93.username AS username_101,
  t93.logement AS logement_102,
  t93.adresse AS adresse_103,
  t93.adresseComplement AS adresseComplement_104,
  t93.codePostal AS codePostal_105,
  t93.ville AS ville_106,
  t93.proprietaire AS proprietaire_107,
  t93.energieChauffage AS energieChauffage_108,
  t93.token AS token_109,
  t93.confirmationToken AS confirmationToken_110,
  t93.optin AS optin_111,
  t93.optinSms AS optinSms_112,
  t93.emailValidatedDateTime AS emailValidatedDateTime_113,
  t93.created AS created_114,
  t93.reference AS reference_115,
  t93.ahIua AS ahIua_116,
  t93.idCardIua AS idCardIua_117,
  t93.signatureIua AS signatureIua_118,
  t93.lettreEngagementIua AS lettreEngagementIua_119,
  t93.preuveRetraitIua AS preuveRetraitIua_120,
  t93.preuveRetraitIuaFail AS preuveRetraitIuaFail_121,
  t93.bonLivraisonIua AS bonLivraisonIua_122,
  t93.bonLivraisonIuaFail AS bonLivraisonIuaFail_123,
  t93.preuveDistributionIua AS preuveDistributionIua_124,
  t93.lettreRefus AS lettreRefus_125,
  t93.lettreEngagement AS lettreEngagement_126,
  t93.codeSms1Iua AS codeSms1Iua_127,
  t93.codeSms2Iua AS codeSms2Iua_128,
  t93.codeSmsRecover1Iua AS codeSmsRecover1Iua_129,
  t93.codeSmsRecover2Iua AS codeSmsRecover2Iua_130,
  t93.nbCodeSmsRecover AS nbCodeSmsRecover_131,
  t93.nbCodeSmsSign AS nbCodeSmsSign_132,
  t93.nbEmailOptin AS nbEmailOptin_133,
  t93.ahSignedClientIua AS ahSignedClientIua_134,
  t93.ahSignedProIua AS ahSignedProIua_135,
  t93.dateSignatureClient AS dateSignatureClient_136,
  t93.dateSignaturePro AS dateSignaturePro_137,
  t93.dateBonLivraison AS dateBonLivraison_138,
  t93.echec AS echec_139,
  t93.operateurDeviceType AS operateurDeviceType_140,
  t93.dateValidationOperateur AS dateValidationOperateur_141,
  t93.askDeletion AS askDeletion_142,
  t93.reason AS reason_143,
  t93.askDeletionDate AS askDeletionDate_144,
  t93.backup AS backup_145,
  t93.choosenCap AS choosenCap_146,
  t93.campagne_id AS campagne_id_147,
  t93.batch_id AS batch_id_148,
  t93.cas1_id AS cas1_id_149,
  t93.askDeletionObligeUser_id AS askDeletionObligeUser_id_150,
  t93.identite_id AS identite_id_151
FROM
  Cas1 t0
  LEFT JOIN ParticulierUser t7 ON t7.cas1_id = t0.id
  LEFT JOIN ParticulierUserContact t53 ON t53.cas1_id = t0.id
  LEFT JOIN CampagneUser t93 ON t93.cas1_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nbFoyerFiscal AS nbFoyerFiscal_2, t0.codePostal AS codePostal_3, t0.situation AS situation_4, t0.createdAt AS createdAt_5, t0.updatedAt AS updatedAt_6, t7.username AS username_8, t7.email AS email_9, t7.enabled AS enabled_10, t7.salt AS salt_11, t7.last_login AS last_login_12, t7.confirmation_token AS confirmation_token_13, t7.password_requested_at AS password_requested_at_14, t7.roles AS roles_15, t7.email_canonical AS email_canonical_16, t7.username_canonical AS username_canonical_17, t7.password AS password_18, t7.adresse AS adresse_19, t7.adresse_complement AS adresse_complement_20, t7.codepostal AS codepostal_21, t7.ville AS ville_22, t7.token AS token_23, t7.emailRequested AS emailRequested_24, t7.emailRequestedDate AS emailRequestedDate_25, t7.inscriptionFromDemandeOffre AS inscriptionFromDemandeOffre_26, t7.lastOffreDate AS lastOffreDate_27, t7.tag AS tag_28, t7.emailValidatedDateTime AS emailValidatedDateTime_29, t7.emailCreatedDateTime AS emailCreatedDateTime_30, t7.mobileCreatedDatetime AS mobileCreatedDatetime_31, t7.cdiscountGuid AS cdiscountGuid_32, t7.cdiscountCdav AS cdiscountCdav_33, t7.gender AS gender_34, t7.relanceSmsRegistration AS relanceSmsRegistration_35, t7.dateRelanceSmsRegistration AS dateRelanceSmsRegistration_36, t7.id AS id_37, t7.nom AS nom_38, t7.prenom AS prenom_39, t7.fonction AS fonction_40, t7.tel AS tel_41, t7.mobile AS mobile_42, t7.activation AS activation_43, t7.createdAt AS createdAt_44, t7.updatedAt AS updatedAt_45, t7.optin AS optin_46, t7.dateActivation AS dateActivation_47, t7.sendEmail AS sendEmail_48, t7.workflow_id AS workflow_id_49, t7.cas1_id AS cas1_id_50, t7.identite_id AS identite_id_51, t7.integrationModule_id AS integrationModule_id_52, t53.enabled AS enabled_54, t53.salt AS salt_55, t53.last_login AS last_login_56, t53.confirmation_token AS confirmation_token_57, t53.password_requested_at AS password_requested_at_58, t53.roles AS roles_59, t53.email_canonical AS email_canonical_60, t53.username_canonical AS username_canonical_61, t53.password AS password_62, t53.dateEnvoiGuide AS dateEnvoiGuide_63, t53.token AS token_64, t53.emailJustificatifPreca AS emailJustificatifPreca_65, t53.adresse AS adresse_66, t53.adresse_complement AS adresse_complement_67, t53.codepostal AS codepostal_68, t53.ville AS ville_69, t53.formPrecaResponse AS formPrecaResponse_70, t53.gender AS gender_71, t53.stampFilename AS stampFilename_72, t53.id AS id_73, t53.nom AS nom_74, t53.prenom AS prenom_75, t53.fonction AS fonction_76, t53.tel AS tel_77, t53.mobile AS mobile_78, t53.activation AS activation_79, t53.createdAt AS createdAt_80, t53.updatedAt AS updatedAt_81, t53.optin AS optin_82, t53.dateActivation AS dateActivation_83, t53.emailValidatedDateTime AS emailValidatedDateTime_84, t53.emailCreatedDateTime AS emailCreatedDateTime_85, t53.mobileCreatedDatetime AS mobileCreatedDatetime_86, t53.sendEmail AS sendEmail_87, t53.email AS email_88, t53.username AS username_89, t53.cas1_id AS cas1_id_90, t53.identite_id AS identite_id_91, t53.integrationModule_id AS integrationModule_id_92, t93.id AS id_94, t93.activation AS activation_95, t93.step AS step_96, t93.prenom AS prenom_97, t93.nom AS nom_98, t93.tel AS tel_99, t93.mobile AS mobile_100, t93.username AS username_101, t93.logement AS logement_102, t93.adresse AS adresse_103, t93.adresseComplement AS adresseComplement_104, t93.codePostal AS codePostal_105, t93.ville AS ville_106, t93.proprietaire AS proprietaire_107, t93.energieChauffage AS energieChauffage_108, t93.token AS token_109, t93.confirmationToken AS confirmationToken_110, t93.optin AS optin_111, t93.optinSms AS optinSms_112, t93.emailValidatedDateTime AS emailValidatedDateTime_113, t93.created AS created_114, t93.reference AS reference_115, t93.ahIua AS ahIua_116, t93.idCardIua AS idCardIua_117, t93.signatureIua AS signatureIua_118, t93.lettreEngagementIua AS lettreEngagementIua_119, t93.preuveRetraitIua AS preuveRetraitIua_120, t93.preuveRetraitIuaFail AS preuveRetraitIuaFail_121, t93.bonLivraisonIua AS bonLivraisonIua_122, t93.bonLivraisonIuaFail AS bonLivraisonIuaFail_123, t93.preuveDistributionIua AS preuveDistributionIua_124, t93.lettreRefus AS lettreRefus_125, t93.lettreEngagement AS lettreEngagement_126, t93.codeSms1Iua AS codeSms1Iua_127, t93.codeSms2Iua AS codeSms2Iua_128, t93.codeSmsRecover1Iua AS codeSmsRecover1Iua_129, t93.codeSmsRecover2Iua AS codeSmsRecover2Iua_130, t93.nbCodeSmsRecover AS nbCodeSmsRecover_131, t93.nbCodeSmsSign AS nbCodeSmsSign_132, t93.nbEmailOptin AS nbEmailOptin_133, t93.ahSignedClientIua AS ahSignedClientIua_134, t93.ahSignedProIua AS ahSignedProIua_135, t93.dateSignatureClient AS dateSignatureClient_136, t93.dateSignaturePro AS dateSignaturePro_137, t93.dateBonLivraison AS dateBonLivraison_138, t93.echec AS echec_139, t93.operateurDeviceType AS operateurDeviceType_140, t93.dateValidationOperateur AS dateValidationOperateur_141, t93.askDeletion AS askDeletion_142, t93.reason AS reason_143, t93.askDeletionDate AS askDeletionDate_144, t93.backup AS backup_145, t93.choosenCap AS choosenCap_146, t93.campagne_id AS campagne_id_147, t93.batch_id AS batch_id_148, t93.cas1_id AS cas1_id_149, t93.askDeletionObligeUser_id AS askDeletionObligeUser_id_150, t93.identite_id AS identite_id_151 FROM Cas1 t0 LEFT JOIN ParticulierUser t7 ON t7.cas1_id = t0.id LEFT JOIN ParticulierUserContact t53 ON t53.cas1_id = t0.id LEFT JOIN CampagneUser t93 ON t93.cas1_id = t0.id WHERE t0.id = 227;

SELECT
  c0_.id AS id_0,
  c0_.disabled AS disabled_1,
  c0_.threshold AS threshold_2,
  c0_.current AS current_3,
  c0_.expirationDate AS expirationDate_4,
  c0_.beginningDate AS beginningDate_5,
  c0_.messageAdmin AS messageAdmin_6,
  c0_.messageInstallateur AS messageInstallateur_7,
  c0_.messageBeneficiaire AS messageBeneficiaire_8,
  c0_.unit AS unit_9,
  c0_.type AS type_10,
  c0_.oblige_id AS oblige_id_11,
  c0_.teteReseau_id AS teteReseau_id_12,
  c0_.mandataire_id AS mandataire_id_13,
  c0_.installateur_id AS installateur_id_14
FROM
  CappingRule c0_
WHERE
  c0_.disabled = ?
  AND c0_.teteReseau_id = ?
  AND DATE(?) > c0_.beginningDate

SELECT c0_.id AS id_0, c0_.disabled AS disabled_1, c0_.threshold AS threshold_2, c0_.current AS current_3, c0_.expirationDate AS expirationDate_4, c0_.beginningDate AS beginningDate_5, c0_.messageAdmin AS messageAdmin_6, c0_.messageInstallateur AS messageInstallateur_7, c0_.messageBeneficiaire AS messageBeneficiaire_8, c0_.unit AS unit_9, c0_.type AS type_10, c0_.oblige_id AS oblige_id_11, c0_.teteReseau_id AS teteReseau_id_12, c0_.mandataire_id AS mandataire_id_13, c0_.installateur_id AS installateur_id_14 FROM CappingRule c0_ WHERE c0_.disabled = 0 AND c0_.teteReseau_id = 28 AND DATE('2026-02-27 23:38:07') > c0_.beginningDate;

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

SELECT
  t0.id AS id_1,
  t0.token AS token_2,
  t0.type AS type_3,
  t0.source AS source_4,
  t0.choice AS choice_5,
  t0.declared_year AS declared_year_6,
  t0.declared_tax_income AS declared_tax_income_7,
  t0.nb_people_declared AS nb_people_declared_8,
  t0.tax_year AS tax_year_9,
  t0.address AS address_10,
  t0.zip_code AS zip_code_11,
  t0.city AS city_12,
  t0.country AS country_13,
  t0.nb_dependents AS nb_dependents_14,
  t0.reference_tax_income AS reference_tax_income_15,
  t0.address_supplement AS address_supplement_16,
  t0.doc_iua AS doc_iua_17,
  t0.createdAt AS createdAt_18,
  t0.updatedAt AS updatedAt_19,
  t0.cas1_id AS cas1_id_20,
  t0.secondAvis_id AS secondAvis_id_21,
  t0.campagneUser_id AS campagneUser_id_22
FROM
  Justificatif t0
WHERE
  t0.token = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.token AS token_2, t0.type AS type_3, t0.source AS source_4, t0.choice AS choice_5, t0.declared_year AS declared_year_6, t0.declared_tax_income AS declared_tax_income_7, t0.nb_people_declared AS nb_people_declared_8, t0.tax_year AS tax_year_9, t0.address AS address_10, t0.zip_code AS zip_code_11, t0.city AS city_12, t0.country AS country_13, t0.nb_dependents AS nb_dependents_14, t0.reference_tax_income AS reference_tax_income_15, t0.address_supplement AS address_supplement_16, t0.doc_iua AS doc_iua_17, t0.createdAt AS createdAt_18, t0.updatedAt AS updatedAt_19, t0.cas1_id AS cas1_id_20, t0.secondAvis_id AS secondAvis_id_21, t0.campagneUser_id AS campagneUser_id_22 FROM Justificatif t0 WHERE t0.token = 'fYHj6XuqxPJtg8lYUp2QfILah1QXzC2PI8N-mhVD8t8' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.status AS status_4
FROM
  Secteur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.status AS status_4 FROM Secteur t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.status AS status_4
FROM
  TypeOperation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.status AS status_4 FROM TypeOperation t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.status AS status_5,
  t0.slug AS slug_6,
  t0.human_title AS human_title_7,
  t0.position AS position_8
FROM
  SecteurActivite t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.description AS description_4, t0.status AS status_5, t0.slug AS slug_6, t0.human_title AS human_title_7, t0.position AS position_8 FROM SecteurActivite t0 WHERE t0.id = 9;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.reference AS reference_3,
  t0.offre_cumac AS offre_cumac_4,
  t0.offre_cumac_precarite AS offre_cumac_precarite_5,
  t0.offre_cumac_client AS offre_cumac_client_6,
  t0.offre_cumac_client_precarite AS offre_cumac_client_precarite_7,
  t0.cumac AS cumac_8,
  t0.total_prime AS total_prime_9,
  t0.cumac_moyenne AS cumac_moyenne_10,
  t0.taux_actualise AS taux_actualise_11,
  t0.taux_accumule AS taux_accumule_12,
  t0.data AS data_13,
  t0.ip AS ip_14,
  t0.created_datetime AS created_datetime_15,
  t0.prime_pro AS prime_pro_16,
  t0.prime_client AS prime_client_17,
  t0.raison AS raison_18,
  t0.codepostal AS codepostal_19,
  t0.adresse AS adresse_20,
  t0.adresse_complement AS adresse_complement_21,
  t0.ville AS ville_22,
  t0.delai_souhaite AS delai_souhaite_23,
  t0.accept_recevoir_offre AS accept_recevoir_offre_24,
  t0.accept_recommandation AS accept_recommandation_25,
  t0.status AS status_26,
  t0.zone AS zone_27,
  t0.devisValue AS devisValue_28,
  t0.addressSituation AS addressSituation_29,
  t0.programStep AS programStep_30,
  t0.createdAt AS createdAt_31,
  t0.updatedAt AS updatedAt_32,
  t0.engineDocumentId AS engineDocumentId_33,
  t0.simulateur_id AS simulateur_id_34,
  t35.id AS id_36,
  t35.reference AS reference_37,
  t35.nom AS nom_38,
  t35.nom_cd AS nom_cd_39,
  t35.cdiscount AS cdiscount_40,
  t35.pretty_name AS pretty_name_41,
  t35.status AS status_42,
  t35.slug AS slug_43,
  t35.form_lead_id AS form_lead_id_44,
  t35.active_operation_id AS active_operation_id_45,
  t35.secteur_id AS secteur_id_46,
  t35.categorie_id AS categorie_id_47,
  t35.categorieCd_id AS categorieCd_id_48,
  t35.type_operation_id AS type_operation_id_49,
  t35.operation_specifique_id AS operation_specifique_id_50,
  t0.operation_id AS operation_id_51,
  t52.id AS id_53,
  t52.nom AS nom_54,
  t52.version AS version_55,
  t52.code AS code_56,
  t52.duree AS duree_57,
  t52.auto_installation AS auto_installation_58,
  t52.conditions AS conditions_59,
  t52.conditionsRaw AS conditionsRaw_60,
  t52.conditionsFormater AS conditionsFormater_61,
  t52.documents_requis AS documents_requis_62,
  t52.nombre_documents AS nombre_documents_63,
  t52.nombre_conditions AS nombre_conditions_64,
  t52.question_details_type AS question_details_type_65,
  t52.question_details_value AS question_details_value_66,
  t52.periode AS periode_67,
  t52.informationTechnique AS informationTechnique_68,
  t52.informationTechniqueRaw AS informationTechniqueRaw_69,
  t52.informationTechniqueFormater AS informationTechniqueFormater_70,
  t52.informationDocSupplementaire AS informationDocSupplementaire_71,
  t52.informationDocSupplementaireRaw AS informationDocSupplementaireRaw_72,
  t52.informationDocSupplementaireFormater AS informationDocSupplementaireFormater_73,
  t52.informationfacture AS informationfacture_74,
  t52.informationfactureRaw AS informationfactureRaw_75,
  t52.informationfactureFormater AS informationfactureFormater_76,
  t52.informationfacture2 AS informationfacture2_77,
  t52.informationfacture2Raw AS informationfacture2Raw_78,
  t52.informationfacture2Formater AS informationfacture2Formater_79,
  t52.nbMateriau AS nbMateriau_80,
  t52.materiauSubtitle AS materiauSubtitle_81,
  t52.materiauTitle AS materiauTitle_82,
  t52.textForm AS textForm_83,
  t52.private AS private_84,
  t52.campagne AS campagne_85,
  t52.special AS special_86,
  t52.abrogation_datetime AS abrogation_datetime_87,
  t52.end_zni_date AS end_zni_date_88,
  t52.globalConfigurationHash AS globalConfigurationHash_89,
  t52.zni AS zni_90,
  t52.cdp_eligible AS cdp_eligible_91,
  t52.simulateur_id AS simulateur_id_92,
  t52.arrete_id AS arrete_id_93,
  t52.certification_id AS certification_id_94,
  t52.qualification_id AS qualification_id_95,
  t52.formConfigEngine_id AS formConfigEngine_id_96,
  t0.entrepriseUser_id AS entrepriseUser_id_97,
  t0.particulierUser_id AS particulierUser_id_98,
  t0.installateurUser_id AS installateurUser_id_99,
  t0.beUser_id AS beUser_id_100,
  t101.id AS id_102,
  t101.type AS type_103,
  t101.pricingType AS pricingType_104,
  t101.finalisationRequested AS finalisationRequested_105,
  t101.finalisationRequestDate AS finalisationRequestDate_106,
  t101.reference AS reference_107,
  t101.data AS data_108,
  t101.cofracData AS cofracData_109,
  t101.ip AS ip_110,
  t101.offre_auto_date AS offre_auto_date_111,
  t101.created_datetime AS created_datetime_112,
  t101.updated_datetime AS updated_datetime_113,
  t101.tel AS tel_114,
  t101.codepostal AS codepostal_115,
  t101.adresse AS adresse_116,
  t101.adresse_complement AS adresse_complement_117,
  t101.ville AS ville_118,
  t101.delai_souhaite AS delai_souhaite_119,
  t101.accept_recevoir_offre AS accept_recevoir_offre_120,
  t101.accept_recommandation AS accept_recommandation_121,
  t101.acceptLeadPromo AS acceptLeadPromo_122,
  t101.offre_cumac AS offre_cumac_123,
  t101.offre_cumac_client AS offre_cumac_client_124,
  t101.offre_cumac_precarite AS offre_cumac_precarite_125,
  t101.offre_cumac_client_precarite AS offre_cumac_client_precarite_126,
  t101.cumac AS cumac_127,
  t101.cumac_AFT AS cumac_AFT_128,
  t101.total_prime AS total_prime_129,
  t101.total_prime_AFT AS total_prime_AFT_130,
  t101.prime_pro AS prime_pro_131,
  t101.prime_pro_aft AS prime_pro_aft_132,
  t101.prime_client AS prime_client_133,
  t101.prime_client_aft AS prime_client_aft_134,
  t101.cumac_moyenne AS cumac_moyenne_135,
  t101.taux_actualise AS taux_actualise_136,
  t101.taux_accumule AS taux_accumule_137,
  t101.date_debut_chantier AS date_debut_chantier_138,
  t101.date_demande_offre AS date_demande_offre_139,
  t101.date_fin_chantier AS date_fin_chantier_140,
  t101.etat AS etat_141,
  t101.status AS status_142,
  t101.date_offre AS date_offre_143,
  t101.notification_date_chantier AS notification_date_chantier_144,
  t101.date_retour_conv AS date_retour_conv_145,
  t101.date_validation_conv AS date_validation_conv_146,
  t101.date_chantier_renseigne AS date_chantier_renseigne_147,
  t101.date_paiement AS date_paiement_148,
  t101.date_all_doc_valid AS date_all_doc_valid_149,
  t101.date_fin_chantier_repousse AS date_fin_chantier_repousse_150,
  t101.date_envoi_questionnaire AS date_envoi_questionnaire_151,
  t101.date_edition_questionnaire AS date_edition_questionnaire_152,
  t101.date_validation_final AS date_validation_final_153,
  t101.date_annulation AS date_annulation_154,
  t101.no_click_email_date_chantier AS no_click_email_date_chantier_155,
  t101.token AS token_156,
  t101.auto_installation AS auto_installation_157,
  t101.siret AS siret_158,
  t101.cancelReason AS cancelReason_159,
  t101.dateCommande AS dateCommande_160,
  t101.siteTravaux AS siteTravaux_161,
  t101.incitation AS incitation_162,
  t101.qualificationRecordDate AS qualificationRecordDate_163,
  t101.serviceType AS serviceType_164,
  t101.debutChantier AS debutChantier_165,
  t101.finChantier AS finChantier_166,
  t101.initiateCDP AS initiateCDP_167,
  t101.cdp AS cdp_168,
  t101.date_last_envoi_convention AS date_last_envoi_convention_169,
  t101.programStep AS programStep_170,
  t101.devisRestAPayer AS devisRestAPayer_171,
  t101.pricingMandatClassique AS pricingMandatClassique_172,
  t101.pricingMandatPreca AS pricingMandatPreca_173,
  t101.isCOFRAC AS isCOFRAC_174,
  t101.applicationFeesPrice AS applicationFeesPrice_175,
  t101.attributes AS attributes_176,
  t101.engineDocumentId AS engineDocumentId_177,
  t101.batchOffreProjet_id AS batchOffreProjet_id_178,
  t101.entrepriseUser_id AS entrepriseUser_id_179,
  t101.installateurUser_id AS installateurUser_id_180,
  t101.beUser_id AS beUser_id_181,
  t101.entrepriseUserContact_id AS entrepriseUserContact_id_182,
  t101.particulierUserContact_id AS particulierUserContact_id_183,
  t101.signataireEntreprise_id AS signataireEntreprise_id_184,
  t101.signataireInstallateur_id AS signataireInstallateur_id_185,
  t101.installateurUserContact_id AS installateurUserContact_id_186,
  t101.projet_id AS projet_id_187,
  t101.precariteCas2_id AS precariteCas2_id_188,
  t101.precarite_id AS precarite_id_189,
  t101.state_id AS state_id_190,
  t101.oblige_id AS oblige_id_191,
  t101.secteurActivite_id AS secteurActivite_id_192,
  t101.factureDetail_id AS factureDetail_id_193,
  t101.offreStatus_id AS offreStatus_id_194,
  t101.identiteBeneficiaire_id AS identiteBeneficiaire_id_195,
  t101.identiteInstallateur_id AS identiteInstallateur_id_196,
  t101.operation_id AS operation_id_197,
  t101.particulierUser_id AS particulierUser_id_198,
  t101.qualificationRecord_id AS qualificationRecord_id_199,
  t101.sousTraitant_id AS sousTraitant_id_200,
  t101.program_id AS program_id_201,
  t101.programCommercial_id AS programCommercial_id_202,
  t101.programManager_id AS programManager_id_203,
  t101.signatureAuto_id AS signatureAuto_id_204,
  t101.wasteCenter_id AS wasteCenter_id_205,
  t101.waste_id AS waste_id_206,
  t101.programAuto_id AS programAuto_id_207,
  t101.justificatif_id AS justificatif_id_208,
  t101.cappingRule_id AS cappingRule_id_209,
  t101.projectOwner_id AS projectOwner_id_210,
  t101.project_bundle_id AS project_bundle_id_211,
  t101.estate_id AS estate_id_212,
  t0.precarite_id AS precarite_id_213,
  t0.secteurActivite_id AS secteurActivite_id_214,
  t0.integrationModule_id AS integrationModule_id_215,
  t0.precariteCas2_id AS precariteCas2_id_216,
  t0.program_id AS program_id_217,
  t0.programCommercial_id AS programCommercial_id_218,
  t0.programManager_id AS programManager_id_219,
  t0.justificatif_id AS justificatif_id_220,
  t221.id AS id_222,
  t221.numero AS numero_223,
  t221.dateRealisation AS dateRealisation_224,
  t221.dateFinValidite AS dateFinValidite_225,
  t221.etiquetteBilan AS etiquetteBilan_226,
  t221.createdAt AS createdAt_227,
  t221.updatedAt AS updatedAt_228,
  t221.typeJustificatif AS typeJustificatif_229,
  t221.projet_id AS projet_id_230,
  t221.offreProjet_id AS offreProjet_id_231,
  t0.project_bundle_id AS project_bundle_id_232,
  t0.estate_id AS estate_id_233
FROM
  Projet t0
  LEFT JOIN Simulateur t35 ON t0.simulateur_id = t35.id
  LEFT JOIN Operation t52 ON t0.operation_id = t52.id
  LEFT JOIN OffreProjet t101 ON t101.projet_id = t0.id
  LEFT JOIN JustificatifPerformanceEnergetique t221 ON t221.projet_id = t0.id
WHERE
  t0.reference = ?
LIMIT
  1