Symfony Profiler

SELECT
  e0_.id AS id_0,
  e0_.emailAdress AS emailAdress_1,
  e0_.event AS event_2,
  e0_.date AS date_3,
  e0_.createdAt AS createdAt_4,
  e0_.updatedAt AS updatedAt_5,
  e0_.email_id AS email_id_6
FROM
  EmailHistory e0_
  INNER JOIN Email e1_ ON e0_.email_id = e1_.id
  INNER JOIN OffreProjet o2_ ON e1_.offreProjet_id = o2_.id
WHERE
  e0_.emailAdress NOT IN (?, ?)
  AND e1_.name IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  AND o2_.id = ?

SELECT e0_.id AS id_0, e0_.emailAdress AS emailAdress_1, e0_.event AS event_2, e0_.date AS date_3, e0_.createdAt AS createdAt_4, e0_.updatedAt AS updatedAt_5, e0_.email_id AS email_id_6 FROM EmailHistory e0_ INNER JOIN Email e1_ ON e0_.email_id = e1_.id INNER JOIN OffreProjet o2_ ON e1_.offreProjet_id = o2_.id WHERE e0_.emailAdress NOT IN ('[email protected]', '[email protected]') AND e1_.name IN ('p4.027.full_elec_sign', 'p4.027.full_offer_elec_sign', 'p4.027.full_no_elec_sign', 'p4.027.offer_elec_sign', 'p4.027.offer_no_elec_sign', 'convention', 'convention.devis', 'benef.previsit.thermostat', 'p4.005.no_elec_sign', 'p4.005.elec_sign', '026.Convention') AND o2_.id = 1467;

SELECT
  o0_.id AS id_0,
  o0_.type AS type_1,
  o0_.pricingType AS pricingType_2,
  o0_.finalisationRequested AS finalisationRequested_3,
  o0_.finalisationRequestDate AS finalisationRequestDate_4,
  o0_.cofracSatisfyDate AS cofracSatisfyDate_5,
  o0_.reference AS reference_6,
  o0_.data AS data_7,
  o0_.cofracData AS cofracData_8,
  o0_.cofracEngineDocumentId AS cofracEngineDocumentId_9,
  o0_.ip AS ip_10,
  o0_.offre_auto_date AS offre_auto_date_11,
  o0_.created_datetime AS created_datetime_12,
  o0_.updated_datetime AS updated_datetime_13,
  o0_.tel AS tel_14,
  o0_.codepostal AS codepostal_15,
  o0_.adresse AS adresse_16,
  o0_.adresse_complement AS adresse_complement_17,
  o0_.ville AS ville_18,
  o0_.delai_souhaite AS delai_souhaite_19,
  o0_.accept_recevoir_offre AS accept_recevoir_offre_20,
  o0_.accept_recommandation AS accept_recommandation_21,
  o0_.acceptLeadPromo AS acceptLeadPromo_22,
  o0_.offre_cumac AS offre_cumac_23,
  o0_.offre_cumac_client AS offre_cumac_client_24,
  o0_.offre_cumac_precarite AS offre_cumac_precarite_25,
  o0_.offre_cumac_client_precarite AS offre_cumac_client_precarite_26,
  o0_.cumac AS cumac_27,
  o0_.cumac_AFT AS cumac_AFT_28,
  o0_.total_prime AS total_prime_29,
  o0_.total_prime_AFT AS total_prime_AFT_30,
  o0_.prime_pro AS prime_pro_31,
  o0_.prime_pro_aft AS prime_pro_aft_32,
  o0_.prime_client AS prime_client_33,
  o0_.prime_client_aft AS prime_client_aft_34,
  o0_.cumac_moyenne AS cumac_moyenne_35,
  o0_.taux_actualise AS taux_actualise_36,
  o0_.taux_accumule AS taux_accumule_37,
  o0_.date_debut_chantier AS date_debut_chantier_38,
  o0_.date_demande_offre AS date_demande_offre_39,
  o0_.date_fin_chantier AS date_fin_chantier_40,
  o0_.etat AS etat_41,
  o0_.status AS status_42,
  o0_.date_offre AS date_offre_43,
  o0_.notification_date_chantier AS notification_date_chantier_44,
  o0_.date_retour_conv AS date_retour_conv_45,
  o0_.date_validation_conv AS date_validation_conv_46,
  o0_.date_chantier_renseigne AS date_chantier_renseigne_47,
  o0_.date_paiement AS date_paiement_48,
  o0_.date_all_doc_valid AS date_all_doc_valid_49,
  o0_.date_fin_chantier_repousse AS date_fin_chantier_repousse_50,
  o0_.date_envoi_questionnaire AS date_envoi_questionnaire_51,
  o0_.date_edition_questionnaire AS date_edition_questionnaire_52,
  o0_.date_validation_final AS date_validation_final_53,
  o0_.date_annulation AS date_annulation_54,
  o0_.no_click_email_date_chantier AS no_click_email_date_chantier_55,
  o0_.token AS token_56,
  o0_.auto_installation AS auto_installation_57,
  o0_.siret AS siret_58,
  o0_.cancelReason AS cancelReason_59,
  o0_.dateCommande AS dateCommande_60,
  o0_.siteTravaux AS siteTravaux_61,
  o0_.incitation AS incitation_62,
  o0_.qualificationRecordDate AS qualificationRecordDate_63,
  o0_.serviceType AS serviceType_64,
  o0_.debutChantier AS debutChantier_65,
  o0_.finChantier AS finChantier_66,
  o0_.initiateCDP AS initiateCDP_67,
  o0_.cdp AS cdp_68,
  o0_.date_last_envoi_convention AS date_last_envoi_convention_69,
  o0_.programStep AS programStep_70,
  o0_.devisRestAPayer AS devisRestAPayer_71,
  o0_.pricingMandatClassique AS pricingMandatClassique_72,
  o0_.pricingMandatPreca AS pricingMandatPreca_73,
  o0_.isCOFRAC AS isCOFRAC_74,
  o0_.applicationFeesPrice AS applicationFeesPrice_75,
  o0_.attributes AS attributes_76,
  o0_.exclusive AS exclusive_77,
  o0_.engineDocumentId AS engineDocumentId_78,
  o0_.adresseTravaux AS adresseTravaux_79,
  o0_.adresseTravauxCommentaire AS adresseTravauxCommentaire_80,
  o0_.batchOffreProjet_id AS batchOffreProjet_id_81,
  o0_.entrepriseUser_id AS entrepriseUser_id_82,
  o0_.installateurUser_id AS installateurUser_id_83,
  o0_.beUser_id AS beUser_id_84,
  o0_.entrepriseUserContact_id AS entrepriseUserContact_id_85,
  o0_.particulierUserContact_id AS particulierUserContact_id_86,
  o0_.signataireEntreprise_id AS signataireEntreprise_id_87,
  o0_.signataireInstallateur_id AS signataireInstallateur_id_88,
  o0_.installateurUserContact_id AS installateurUserContact_id_89,
  o0_.projet_id AS projet_id_90,
  o0_.precariteCas2_id AS precariteCas2_id_91,
  o0_.creditNoteContract_id AS creditNoteContract_id_92,
  o0_.precarite_id AS precarite_id_93,
  o0_.state_id AS state_id_94,
  o0_.oblige_id AS oblige_id_95,
  o0_.secteurActivite_id AS secteurActivite_id_96,
  o0_.factureDetail_id AS factureDetail_id_97,
  o0_.offreStatus_id AS offreStatus_id_98,
  o0_.identiteBeneficiaire_id AS identiteBeneficiaire_id_99,
  o0_.identiteInstallateur_id AS identiteInstallateur_id_100,
  o0_.operation_id AS operation_id_101,
  o0_.particulierUser_id AS particulierUser_id_102,
  o0_.qualificationRecord_id AS qualificationRecord_id_103,
  o0_.sousTraitant_id AS sousTraitant_id_104,
  o0_.program_id AS program_id_105,
  o0_.programCommercial_id AS programCommercial_id_106,
  o0_.programManager_id AS programManager_id_107,
  o0_.signatureAuto_id AS signatureAuto_id_108,
  o0_.wasteCenter_id AS wasteCenter_id_109,
  o0_.waste_id AS waste_id_110,
  o0_.programAuto_id AS programAuto_id_111,
  o0_.justificatif_id AS justificatif_id_112,
  o0_.cappingRule_id AS cappingRule_id_113,
  o0_.projectOwner_id AS projectOwner_id_114,
  o0_.project_bundle_id AS project_bundle_id_115,
  o0_.estate_id AS estate_id_116
FROM
  OffreProjet o0_
  LEFT JOIN EntrepriseUserContact e1_ ON o0_.entrepriseUserContact_id = e1_.id
  LEFT JOIN ParticulierUserContact p2_ ON o0_.particulierUserContact_id = p2_.id
  LEFT JOIN EntrepriseUser e3_ ON o0_.entrepriseUser_id = e3_.id
  LEFT JOIN ParticulierUser p4_ ON o0_.particulierUser_id = p4_.id
  LEFT JOIN OperationRecord o5_ ON o0_.id = o5_.offreProjet_id
  LEFT JOIN Operation o6_ ON o5_.operation_id = o6_.id
  LEFT JOIN Operation o7_ ON o0_.operation_id = o7_.id
WHERE
  o0_.oblige_id IN (?, ?, ?)
  AND o0_.id <> ?
  AND (
    e1_.username = ?
    OR p2_.username = ?
    OR e3_.username = ?
    OR p4_.username = ?
  )
  AND (
    o7_.nom LIKE ?
    OR o6_.nom LIKE ?
  )
  AND o0_.etat NOT IN (?, ?, ?, ?, ?, ?)

SELECT o0_.id AS id_0, o0_.type AS type_1, o0_.pricingType AS pricingType_2, o0_.finalisationRequested AS finalisationRequested_3, o0_.finalisationRequestDate AS finalisationRequestDate_4, o0_.cofracSatisfyDate AS cofracSatisfyDate_5, o0_.reference AS reference_6, o0_.data AS data_7, o0_.cofracData AS cofracData_8, o0_.cofracEngineDocumentId AS cofracEngineDocumentId_9, o0_.ip AS ip_10, o0_.offre_auto_date AS offre_auto_date_11, o0_.created_datetime AS created_datetime_12, o0_.updated_datetime AS updated_datetime_13, o0_.tel AS tel_14, o0_.codepostal AS codepostal_15, o0_.adresse AS adresse_16, o0_.adresse_complement AS adresse_complement_17, o0_.ville AS ville_18, o0_.delai_souhaite AS delai_souhaite_19, o0_.accept_recevoir_offre AS accept_recevoir_offre_20, o0_.accept_recommandation AS accept_recommandation_21, o0_.acceptLeadPromo AS acceptLeadPromo_22, o0_.offre_cumac AS offre_cumac_23, o0_.offre_cumac_client AS offre_cumac_client_24, o0_.offre_cumac_precarite AS offre_cumac_precarite_25, o0_.offre_cumac_client_precarite AS offre_cumac_client_precarite_26, o0_.cumac AS cumac_27, o0_.cumac_AFT AS cumac_AFT_28, o0_.total_prime AS total_prime_29, o0_.total_prime_AFT AS total_prime_AFT_30, o0_.prime_pro AS prime_pro_31, o0_.prime_pro_aft AS prime_pro_aft_32, o0_.prime_client AS prime_client_33, o0_.prime_client_aft AS prime_client_aft_34, o0_.cumac_moyenne AS cumac_moyenne_35, o0_.taux_actualise AS taux_actualise_36, o0_.taux_accumule AS taux_accumule_37, o0_.date_debut_chantier AS date_debut_chantier_38, o0_.date_demande_offre AS date_demande_offre_39, o0_.date_fin_chantier AS date_fin_chantier_40, o0_.etat AS etat_41, o0_.status AS status_42, o0_.date_offre AS date_offre_43, o0_.notification_date_chantier AS notification_date_chantier_44, o0_.date_retour_conv AS date_retour_conv_45, o0_.date_validation_conv AS date_validation_conv_46, o0_.date_chantier_renseigne AS date_chantier_renseigne_47, o0_.date_paiement AS date_paiement_48, o0_.date_all_doc_valid AS date_all_doc_valid_49, o0_.date_fin_chantier_repousse AS date_fin_chantier_repousse_50, o0_.date_envoi_questionnaire AS date_envoi_questionnaire_51, o0_.date_edition_questionnaire AS date_edition_questionnaire_52, o0_.date_validation_final AS date_validation_final_53, o0_.date_annulation AS date_annulation_54, o0_.no_click_email_date_chantier AS no_click_email_date_chantier_55, o0_.token AS token_56, o0_.auto_installation AS auto_installation_57, o0_.siret AS siret_58, o0_.cancelReason AS cancelReason_59, o0_.dateCommande AS dateCommande_60, o0_.siteTravaux AS siteTravaux_61, o0_.incitation AS incitation_62, o0_.qualificationRecordDate AS qualificationRecordDate_63, o0_.serviceType AS serviceType_64, o0_.debutChantier AS debutChantier_65, o0_.finChantier AS finChantier_66, o0_.initiateCDP AS initiateCDP_67, o0_.cdp AS cdp_68, o0_.date_last_envoi_convention AS date_last_envoi_convention_69, o0_.programStep AS programStep_70, o0_.devisRestAPayer AS devisRestAPayer_71, o0_.pricingMandatClassique AS pricingMandatClassique_72, o0_.pricingMandatPreca AS pricingMandatPreca_73, o0_.isCOFRAC AS isCOFRAC_74, o0_.applicationFeesPrice AS applicationFeesPrice_75, o0_.attributes AS attributes_76, o0_.exclusive AS exclusive_77, o0_.engineDocumentId AS engineDocumentId_78, o0_.adresseTravaux AS adresseTravaux_79, o0_.adresseTravauxCommentaire AS adresseTravauxCommentaire_80, o0_.batchOffreProjet_id AS batchOffreProjet_id_81, o0_.entrepriseUser_id AS entrepriseUser_id_82, o0_.installateurUser_id AS installateurUser_id_83, o0_.beUser_id AS beUser_id_84, o0_.entrepriseUserContact_id AS entrepriseUserContact_id_85, o0_.particulierUserContact_id AS particulierUserContact_id_86, o0_.signataireEntreprise_id AS signataireEntreprise_id_87, o0_.signataireInstallateur_id AS signataireInstallateur_id_88, o0_.installateurUserContact_id AS installateurUserContact_id_89, o0_.projet_id AS projet_id_90, o0_.precariteCas2_id AS precariteCas2_id_91, o0_.creditNoteContract_id AS creditNoteContract_id_92, o0_.precarite_id AS precarite_id_93, o0_.state_id AS state_id_94, o0_.oblige_id AS oblige_id_95, o0_.secteurActivite_id AS secteurActivite_id_96, o0_.factureDetail_id AS factureDetail_id_97, o0_.offreStatus_id AS offreStatus_id_98, o0_.identiteBeneficiaire_id AS identiteBeneficiaire_id_99, o0_.identiteInstallateur_id AS identiteInstallateur_id_100, o0_.operation_id AS operation_id_101, o0_.particulierUser_id AS particulierUser_id_102, o0_.qualificationRecord_id AS qualificationRecord_id_103, o0_.sousTraitant_id AS sousTraitant_id_104, o0_.program_id AS program_id_105, o0_.programCommercial_id AS programCommercial_id_106, o0_.programManager_id AS programManager_id_107, o0_.signatureAuto_id AS signatureAuto_id_108, o0_.wasteCenter_id AS wasteCenter_id_109, o0_.waste_id AS waste_id_110, o0_.programAuto_id AS programAuto_id_111, o0_.justificatif_id AS justificatif_id_112, o0_.cappingRule_id AS cappingRule_id_113, o0_.projectOwner_id AS projectOwner_id_114, o0_.project_bundle_id AS project_bundle_id_115, o0_.estate_id AS estate_id_116 FROM OffreProjet o0_ LEFT JOIN EntrepriseUserContact e1_ ON o0_.entrepriseUserContact_id = e1_.id LEFT JOIN ParticulierUserContact p2_ ON o0_.particulierUserContact_id = p2_.id LEFT JOIN EntrepriseUser e3_ ON o0_.entrepriseUser_id = e3_.id LEFT JOIN ParticulierUser p4_ ON o0_.particulierUser_id = p4_.id LEFT JOIN OperationRecord o5_ ON o0_.id = o5_.offreProjet_id LEFT JOIN Operation o6_ ON o5_.operation_id = o6_.id LEFT JOIN Operation o7_ ON o0_.operation_id = o7_.id WHERE o0_.oblige_id IN (6, 21, 23) AND o0_.id <> 1467 AND (e1_.username = '[email protected]' OR p2_.username = '[email protected]' OR e3_.username = '[email protected]' OR p4_.username = '[email protected]') AND (o7_.nom LIKE 'TRA-EQ-117%' OR o6_.nom LIKE 'TRA-EQ-117%') AND o0_.etat NOT IN ('demande_refuser', 'dossier_aft_ineligible', 'dossier_supprime_auto', 'dossier_supprime_manuel_back', 'dossier_supprime_manuel_front', 'dossier_invalide_auto');

SELECT
  t0.id AS id_1,
  t0.moment AS moment_2,
  t0.displayOrder AS displayOrder_3,
  t0.certifical AS certifical_4,
  t0.certificallOnly AS certificallOnly_5,
  t0.apply_condition AS apply_condition_6,
  t0.frameId AS frameId_7,
  t0.multipleDocuments AS multipleDocuments_8,
  t0.multiplierProperty AS multiplierProperty_9,
  t0.multiplierType AS multiplierType_10,
  t0.itemIdentifierProperty AS itemIdentifierProperty_11,
  t0.operation_id AS operation_id_12,
  t0.document_type_id AS document_type_id_13
FROM
  operation_document_config t0
WHERE
  t0.operation_id = ?

SELECT t0.id AS id_1, t0.moment AS moment_2, t0.displayOrder AS displayOrder_3, t0.certifical AS certifical_4, t0.certificallOnly AS certificallOnly_5, t0.apply_condition AS apply_condition_6, t0.frameId AS frameId_7, t0.multipleDocuments AS multipleDocuments_8, t0.multiplierProperty AS multiplierProperty_9, t0.multiplierType AS multiplierType_10, t0.itemIdentifierProperty AS itemIdentifierProperty_11, t0.operation_id AS operation_id_12, t0.document_type_id AS document_type_id_13 FROM operation_document_config t0 WHERE t0.operation_id = 1084;

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
WHERE
  t0.nom = ?
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 WHERE t0.nom = 'operator-offer-update' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.emailId AS emailId_2,
  t0.type AS type_3,
  t0.saved AS saved_4,
  t0.iua AS iua_5,
  t0.backupMail AS backupMail_6,
  t0.originalName AS originalName_7,
  t0.ersIua AS ersIua_8,
  t0.emailDate AS emailDate_9,
  t0.retry AS retry_10,
  t0.createdAt AS createdAt_11,
  t0.updatedAt AS updatedAt_12,
  t0.offreProjet_id AS offreProjet_id_13,
  t14.id AS id_15,
  t14.step AS step_16,
  t14.type AS type_17,
  t14.reference AS reference_18,
  t14.code AS code_19,
  t14.dataMoteur AS dataMoteur_20,
  t14.primeDistributeur AS primeDistributeur_21,
  t14.nom AS nom_22,
  t14.marque AS marque_23,
  t14.url AS url_24,
  t14.emailPrefix AS emailPrefix_25,
  t14.is_active AS is_active_26,
  t14.nbKit AS nbKit_27,
  t14.dateFin AS dateFin_28,
  t14.contratDistributeurRaiDate AS contratDistributeurRaiDate_29,
  t14.contratDistributeurSignedDate AS contratDistributeurSignedDate_30,
  t14.contratDistributeurIua AS contratDistributeurIua_31,
  t14.contratDistributeurSignedIua AS contratDistributeurSignedIua_32,
  t14.username AS username_33,
  t14.password AS password_34,
  t14.commandeEquipmentIua AS commandeEquipmentIua_35,
  t14.ahIua AS ahIua_36,
  t14.ahSignedIua AS ahSignedIua_37,
  t14.dateAhSigned AS dateAhSigned_38,
  t14.consoneo AS consoneo_39,
  t14.cumac AS cumac_40,
  t14.supportPhone AS supportPhone_41,
  t14.pricingMode AS pricingMode_42,
  t14.pricingValue AS pricingValue_43,
  t14.complementaryDocs AS complementaryDocs_44,
  t14.serviceType AS serviceType_45,
  t14.safeId AS safeId_46,
  t14.operation_id AS operation_id_47,
  t14.oblige_id AS oblige_id_48,
  t14.integrationModule_id AS integrationModule_id_49,
  t14.installateurUser_id AS installateurUser_id_50,
  t14.identiteInstallateurUser_id AS identiteInstallateurUser_id_51,
  t14.horodatage_id AS horodatage_id_52,
  t0.contract_id AS contract_id_53
FROM
  Horodatage t0
  LEFT JOIN Campagne t14 ON t14.horodatage_id = t0.id
WHERE
  t0.offreProjet_id = ?

SELECT t0.id AS id_1, t0.emailId AS emailId_2, t0.type AS type_3, t0.saved AS saved_4, t0.iua AS iua_5, t0.backupMail AS backupMail_6, t0.originalName AS originalName_7, t0.ersIua AS ersIua_8, t0.emailDate AS emailDate_9, t0.retry AS retry_10, t0.createdAt AS createdAt_11, t0.updatedAt AS updatedAt_12, t0.offreProjet_id AS offreProjet_id_13, t14.id AS id_15, t14.step AS step_16, t14.type AS type_17, t14.reference AS reference_18, t14.code AS code_19, t14.dataMoteur AS dataMoteur_20, t14.primeDistributeur AS primeDistributeur_21, t14.nom AS nom_22, t14.marque AS marque_23, t14.url AS url_24, t14.emailPrefix AS emailPrefix_25, t14.is_active AS is_active_26, t14.nbKit AS nbKit_27, t14.dateFin AS dateFin_28, t14.contratDistributeurRaiDate AS contratDistributeurRaiDate_29, t14.contratDistributeurSignedDate AS contratDistributeurSignedDate_30, t14.contratDistributeurIua AS contratDistributeurIua_31, t14.contratDistributeurSignedIua AS contratDistributeurSignedIua_32, t14.username AS username_33, t14.password AS password_34, t14.commandeEquipmentIua AS commandeEquipmentIua_35, t14.ahIua AS ahIua_36, t14.ahSignedIua AS ahSignedIua_37, t14.dateAhSigned AS dateAhSigned_38, t14.consoneo AS consoneo_39, t14.cumac AS cumac_40, t14.supportPhone AS supportPhone_41, t14.pricingMode AS pricingMode_42, t14.pricingValue AS pricingValue_43, t14.complementaryDocs AS complementaryDocs_44, t14.serviceType AS serviceType_45, t14.safeId AS safeId_46, t14.operation_id AS operation_id_47, t14.oblige_id AS oblige_id_48, t14.integrationModule_id AS integrationModule_id_49, t14.installateurUser_id AS installateurUser_id_50, t14.identiteInstallateurUser_id AS identiteInstallateurUser_id_51, t14.horodatage_id AS horodatage_id_52, t0.contract_id AS contract_id_53 FROM Horodatage t0 LEFT JOIN Campagne t14 ON t14.horodatage_id = t0.id WHERE t0.offreProjet_id = 1467;

SELECT
  s0_.id AS id_0,
  s0_.signed AS signed_1,
  s0_.signed_date AS signed_date_2,
  s0_.signing_ip AS signing_ip_3,
  s0_.reference AS reference_4,
  s0_.transaction_id AS transaction_id_5,
  s0_.state AS state_6,
  s0_.documentAvailable AS documentAvailable_7,
  s0_.document_id AS document_id_8,
  s0_.entrepriseUserContact_id AS entrepriseUserContact_id_9,
  s0_.installateurUser_id AS installateurUser_id_10,
  s0_.installateurUserContact_id AS installateurUserContact_id_11,
  s0_.signataireEntreprise_id AS signataireEntreprise_id_12,
  s0_.particulierUser_id AS particulierUser_id_13,
  s0_.particulierUserContact_id AS particulierUserContact_id_14,
  s0_.campagneUser_id AS campagneUser_id_15
FROM
  SignatureRequest s0_
  INNER JOIN Document d1_ ON s0_.document_id = d1_.id
WHERE
  d1_.type_id = ?
  AND d1_.offreProjet_id = ?
  AND s0_.particulierUserContact_id = ?
ORDER BY
  s0_.id DESC

SELECT s0_.id AS id_0, s0_.signed AS signed_1, s0_.signed_date AS signed_date_2, s0_.signing_ip AS signing_ip_3, s0_.reference AS reference_4, s0_.transaction_id AS transaction_id_5, s0_.state AS state_6, s0_.documentAvailable AS documentAvailable_7, s0_.document_id AS document_id_8, s0_.entrepriseUserContact_id AS entrepriseUserContact_id_9, s0_.installateurUser_id AS installateurUser_id_10, s0_.installateurUserContact_id AS installateurUserContact_id_11, s0_.signataireEntreprise_id AS signataireEntreprise_id_12, s0_.particulierUser_id AS particulierUser_id_13, s0_.particulierUserContact_id AS particulierUserContact_id_14, s0_.campagneUser_id AS campagneUser_id_15 FROM SignatureRequest s0_ INNER JOIN Document d1_ ON s0_.document_id = d1_.id WHERE d1_.type_id = 80 AND d1_.offreProjet_id = 1467 AND s0_.particulierUserContact_id = 268 ORDER BY s0_.id DESC;

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.chantiersParMois AS chantiersParMois_13,
  t0.data AS data_14,
  t0.programmeValorisation AS programmeValorisation_15,
  t0.apartientProgrammeValorisation AS apartientProgrammeValorisation_16,
  t0.cgu AS cgu_17,
  t0.oldContract AS oldContract_18,
  t0.lastLogin AS lastLogin_19,
  t0.lastDemande AS lastDemande_20,
  t0.qualificationsRequested AS qualificationsRequested_21,
  t0.qualificationRequestDate AS qualificationRequestDate_22,
  t0.bd AS bd_23,
  t0.stationService AS stationService_24,
  t0.nbKit AS nbKit_25,
  t0.registreCommerceVille AS registreCommerceVille_26,
  t0.light AS light_27,
  t0.curseur AS curseur_28,
  t0.curseurMinClient AS curseurMinClient_29,
  t0.sendMailCEEValidated AS sendMailCEEValidated_30,
  t0.surveyAverage AS surveyAverage_31,
  t0.external_client_code AS external_client_code_32,
  t0.interestedByFinancialMpr AS interestedByFinancialMpr_33,
  t0.interestedByCreditNote AS interestedByCreditNote_34,
  t0.financialMpr AS financialMpr_35,
  t0.mprAcceptFunding AS mprAcceptFunding_36,
  t0.sienna_id AS sienna_id_37,
  t0.logoFileName AS logoFileName_38,
  t0.cachetFileName AS cachetFileName_39,
  t0.tvaNumber AS tvaNumber_40,
  t0.decennalResponsibility AS decennalResponsibility_41,
  t0.acronyme AS acronyme_42,
  t0.companyStatus AS companyStatus_43,
  t0.codeApe AS codeApe_44,
  t0.capital AS capital_45,
  t46.id AS id_47,
  t46.type AS type_48,
  t46.detail AS detail_49,
  t46.token AS token_50,
  t46.installateur_id AS installateur_id_51,
  t46.particulierUser_id AS particulierUser_id_52,
  t46.entrepriseUser_id AS entrepriseUser_id_53,
  t46.particulierUserContact_id AS particulierUserContact_id_54,
  t46.entrepriseUserContact_id AS entrepriseUserContact_id_55,
  t0.user_id AS user_id_56,
  t57.id AS id_58,
  t57.tel AS tel_59,
  t57.mobile AS mobile_60,
  t57.username AS username_61,
  t57.fonction AS fonction_62,
  t57.nom AS nom_63,
  t57.prenom AS prenom_64,
  t57.company_id AS company_id_65,
  t66.id AS id_67,
  t66.mode AS mode_68,
  t66.targetType AS targetType_69,
  t66.classic AS classic_70,
  t66.preca AS preca_71,
  t66.enable AS enable_72,
  t66.raiType AS raiType_73,
  t66.contractSignedElectronically AS contractSignedElectronically_74,
  t66.pro_signature_mandatory_outlay AS pro_signature_mandatory_outlay_75,
  t66.obligeTarget_id AS obligeTarget_id_76,
  t66.teteReseau_id AS teteReseau_id_77,
  t66.simulateur_id AS simulateur_id_78,
  t66.installateurTarget_id AS installateurTarget_id_79,
  t66.beTarget_id AS beTarget_id_80,
  t81.id AS id_82,
  t81.createdAt AS createdAt_83,
  t81.updatedAt AS updatedAt_84,
  t81.installateur_id AS installateur_id_85,
  t0.prestataireEffacement_id AS prestataireEffacement_id_86
FROM
  Installateur t0
  LEFT JOIN PaymentMethod t46 ON t46.installateur_id = t0.id
  LEFT JOIN SignataireInstallateur t57 ON t57.company_id = t0.id
  LEFT JOIN AffectationConsoneoRule t66 ON t66.installateurTarget_id = t0.id
  LEFT JOIN installateur_certificall_config t81 ON t81.installateur_id = t0.id
WHERE
  t0.id = ?

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.chantiersParMois AS chantiersParMois_13, t0.data AS data_14, t0.programmeValorisation AS programmeValorisation_15, t0.apartientProgrammeValorisation AS apartientProgrammeValorisation_16, t0.cgu AS cgu_17, t0.oldContract AS oldContract_18, t0.lastLogin AS lastLogin_19, t0.lastDemande AS lastDemande_20, t0.qualificationsRequested AS qualificationsRequested_21, t0.qualificationRequestDate AS qualificationRequestDate_22, t0.bd AS bd_23, t0.stationService AS stationService_24, t0.nbKit AS nbKit_25, t0.registreCommerceVille AS registreCommerceVille_26, t0.light AS light_27, t0.curseur AS curseur_28, t0.curseurMinClient AS curseurMinClient_29, t0.sendMailCEEValidated AS sendMailCEEValidated_30, t0.surveyAverage AS surveyAverage_31, t0.external_client_code AS external_client_code_32, t0.interestedByFinancialMpr AS interestedByFinancialMpr_33, t0.interestedByCreditNote AS interestedByCreditNote_34, t0.financialMpr AS financialMpr_35, t0.mprAcceptFunding AS mprAcceptFunding_36, t0.sienna_id AS sienna_id_37, t0.logoFileName AS logoFileName_38, t0.cachetFileName AS cachetFileName_39, t0.tvaNumber AS tvaNumber_40, t0.decennalResponsibility AS decennalResponsibility_41, t0.acronyme AS acronyme_42, t0.companyStatus AS companyStatus_43, t0.codeApe AS codeApe_44, t0.capital AS capital_45, t46.id AS id_47, t46.type AS type_48, t46.detail AS detail_49, t46.token AS token_50, t46.installateur_id AS installateur_id_51, t46.particulierUser_id AS particulierUser_id_52, t46.entrepriseUser_id AS entrepriseUser_id_53, t46.particulierUserContact_id AS particulierUserContact_id_54, t46.entrepriseUserContact_id AS entrepriseUserContact_id_55, t0.user_id AS user_id_56, t57.id AS id_58, t57.tel AS tel_59, t57.mobile AS mobile_60, t57.username AS username_61, t57.fonction AS fonction_62, t57.nom AS nom_63, t57.prenom AS prenom_64, t57.company_id AS company_id_65, t66.id AS id_67, t66.mode AS mode_68, t66.targetType AS targetType_69, t66.classic AS classic_70, t66.preca AS preca_71, t66.enable AS enable_72, t66.raiType AS raiType_73, t66.contractSignedElectronically AS contractSignedElectronically_74, t66.pro_signature_mandatory_outlay AS pro_signature_mandatory_outlay_75, t66.obligeTarget_id AS obligeTarget_id_76, t66.teteReseau_id AS teteReseau_id_77, t66.simulateur_id AS simulateur_id_78, t66.installateurTarget_id AS installateurTarget_id_79, t66.beTarget_id AS beTarget_id_80, t81.id AS id_82, t81.createdAt AS createdAt_83, t81.updatedAt AS updatedAt_84, t81.installateur_id AS installateur_id_85, t0.prestataireEffacement_id AS prestataireEffacement_id_86 FROM Installateur t0 LEFT JOIN PaymentMethod t46 ON t46.installateur_id = t0.id LEFT JOIN SignataireInstallateur t57 ON t57.company_id = t0.id LEFT JOIN AffectationConsoneoRule t66 ON t66.installateurTarget_id = t0.id LEFT JOIN installateur_certificall_config t81 ON t81.installateur_id = t0.id WHERE t0.id = 12766;

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 = 'justificatif_performance_energetique' 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.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` = 'mode_debride_project_bundle' AND t0.offreProjet_id = 1467 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.offreProjet_id = ?
  AND t0.type_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.offreProjet_id = 1467 AND t0.type_id = 418 LIMIT 1;