GET https://admin.preprod-orion.dossier-c2e.fr/_fragment?_path=_format%3Dhtml%26_locale%3Dfr%26_controller%3DConsoneo%255CBundle%255CObligeBundle%255CController%255…

Response
200 OK
Browse referrer URL
IP
185.18.210.74
Profiled on
Token
fbf9ac

Query Metrics

80 Database Queries
49 Different statements
320.47 ms Query time
0 Invalid entities
245 Managed entities
0 Cache hits
0 Cache misses
0 Cache puts

Queries

Group similar statements

default connection

#▲ Time Info
1 1.53 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.enabled AS enabled_3, t0.salt AS salt_4, t0.password AS password_5, t0.last_login AS last_login_6, t0.confirmation_token AS confirmation_token_7, t0.password_requested_at AS password_requested_at_8, t0.roles AS roles_9, t0.username AS username_10, t0.nom AS nom_11, t0.prenom AS prenom_12, t0.fonction AS fonction_13, t0.tel AS tel_14, t0.mobile AS mobile_15, t0.activation AS activation_16, t0.createdAt AS createdAt_17, t0.updatedAt AS updatedAt_18, t0.optin AS optin_19, t0.dateActivation AS dateActivation_20, t0.emailValidatedDateTime AS emailValidatedDateTime_21, t0.emailCreatedDateTime AS emailCreatedDateTime_22, t0.mobileCreatedDatetime AS mobileCreatedDatetime_23, t0.sendEmail AS sendEmail_24, t0.scope AS scope_25, t0.isArchived AS isArchived_26, t0.import AS import_27, t0.neoSpaceEnabled AS neoSpaceEnabled_28, t0.email_canonical AS email_canonical_29, t0.username_canonical AS username_canonical_30, t0.oblige_id AS oblige_id_31 FROM ObligeUser t0 WHERE t0.id = ?
Parameters: 
[
  44
]
View formatted query    View runnable query    Explain query
2 4.61 ms 
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.token = ? LIMIT 1
Parameters: 
[
  "EfPdapGhtYgzhTWpsAnumX4v3diCIUTI69RPFekXvlM"
]
View formatted query    View runnable query    Explain query
3 1.08 ms 
SELECT t0.id AS id_1, t0.dataSimulation AS dataSimulation_2, t0.dataAH AS dataAH_3, t0.cumac AS cumac_4, t0.tauxActualise AS tauxActualise_5, t0.tauxAccumule AS tauxAccumule_6, t0.cumacMoyenne AS cumacMoyenne_7, t0.initiateCDP AS initiateCDP_8, t0.cofracData AS cofracData_9, t0.operation_id AS operation_id_10, t0.projet_id AS projet_id_11, t0.program_id AS program_id_12, t0.offreProjet_id AS offreProjet_id_13 FROM OperationRecord t0 WHERE t0.offreProjet_id = ?
Parameters: 
[
  1467
]
View formatted query    View runnable query    Explain query
4 1.17 ms 
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.version AS version_3, t0.code AS code_4, t0.duree AS duree_5, t0.auto_installation AS auto_installation_6, t0.conditions AS conditions_7, t0.conditionsRaw AS conditionsRaw_8, t0.conditionsFormater AS conditionsFormater_9, t0.documents_requis AS documents_requis_10, t0.nombre_documents AS nombre_documents_11, t0.nombre_conditions AS nombre_conditions_12, t0.question_details_type AS question_details_type_13, t0.question_details_value AS question_details_value_14, t0.periode AS periode_15, t0.informationTechnique AS informationTechnique_16, t0.informationTechniqueRaw AS informationTechniqueRaw_17, t0.informationTechniqueFormater AS informationTechniqueFormater_18, t0.informationDocSupplementaire AS informationDocSupplementaire_19, t0.informationDocSupplementaireRaw AS informationDocSupplementaireRaw_20, t0.informationDocSupplementaireFormater AS informationDocSupplementaireFormater_21, t0.informationfacture AS informationfacture_22, t0.informationfactureRaw AS informationfactureRaw_23, t0.informationfactureFormater AS informationfactureFormater_24, t0.informationfacture2 AS informationfacture2_25, t0.informationfacture2Raw AS informationfacture2Raw_26, t0.informationfacture2Formater AS informationfacture2Formater_27, t0.nbMateriau AS nbMateriau_28, t0.materiauSubtitle AS materiauSubtitle_29, t0.materiauTitle AS materiauTitle_30, t0.textForm AS textForm_31, t0.private AS private_32, t0.campagne AS campagne_33, t0.special AS special_34, t0.abrogation_datetime AS abrogation_datetime_35, t0.date_limite_depot_referencement AS date_limite_depot_referencement_36, t0.end_zni_date AS end_zni_date_37, t0.globalConfigurationHash AS globalConfigurationHash_38, t0.zni AS zni_39, t0.cdp_eligible AS cdp_eligible_40, t0.simulateur_id AS simulateur_id_41, t0.arrete_id AS arrete_id_42, t0.certification_id AS certification_id_43, t0.qualification_id AS qualification_id_44, t0.formConfigEngine_id AS formConfigEngine_id_45 FROM Operation t0 WHERE t0.id = ?
Parameters: 
[
  1084
]
View formatted query    View runnable query    Explain query
5 1.59 ms 
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.nom AS nom_3, t0.nom_cd AS nom_cd_4, t0.cdiscount AS cdiscount_5, t0.pretty_name AS pretty_name_6, t0.status AS status_7, t0.slug AS slug_8, t0.form_lead_id AS form_lead_id_9, t0.active_operation_id AS active_operation_id_10, t11.id AS id_12, t11.nom AS nom_13, t11.version AS version_14, t11.code AS code_15, t11.duree AS duree_16, t11.auto_installation AS auto_installation_17, t11.conditions AS conditions_18, t11.conditionsRaw AS conditionsRaw_19, t11.conditionsFormater AS conditionsFormater_20, t11.documents_requis AS documents_requis_21, t11.nombre_documents AS nombre_documents_22, t11.nombre_conditions AS nombre_conditions_23, t11.question_details_type AS question_details_type_24, t11.question_details_value AS question_details_value_25, t11.periode AS periode_26, t11.informationTechnique AS informationTechnique_27, t11.informationTechniqueRaw AS informationTechniqueRaw_28, t11.informationTechniqueFormater AS informationTechniqueFormater_29, t11.informationDocSupplementaire AS informationDocSupplementaire_30, t11.informationDocSupplementaireRaw AS informationDocSupplementaireRaw_31, t11.informationDocSupplementaireFormater AS informationDocSupplementaireFormater_32, t11.informationfacture AS informationfacture_33, t11.informationfactureRaw AS informationfactureRaw_34, t11.informationfactureFormater AS informationfactureFormater_35, t11.informationfacture2 AS informationfacture2_36, t11.informationfacture2Raw AS informationfacture2Raw_37, t11.informationfacture2Formater AS informationfacture2Formater_38, t11.nbMateriau AS nbMateriau_39, t11.materiauSubtitle AS materiauSubtitle_40, t11.materiauTitle AS materiauTitle_41, t11.textForm AS textForm_42, t11.private AS private_43, t11.campagne AS campagne_44, t11.special AS special_45, t11.abrogation_datetime AS abrogation_datetime_46, t11.date_limite_depot_referencement AS date_limite_depot_referencement_47, t11.end_zni_date AS end_zni_date_48, t11.globalConfigurationHash AS globalConfigurationHash_49, t11.zni AS zni_50, t11.cdp_eligible AS cdp_eligible_51, t11.simulateur_id AS simulateur_id_52, t11.arrete_id AS arrete_id_53, t11.certification_id AS certification_id_54, t11.qualification_id AS qualification_id_55, t11.formConfigEngine_id AS formConfigEngine_id_56, t0.secteur_id AS secteur_id_57, t0.categorie_id AS categorie_id_58, t0.categorieCd_id AS categorieCd_id_59, t0.type_operation_id AS type_operation_id_60, t0.operation_specifique_id AS operation_specifique_id_61, t62.id AS id_63, t62.mode AS mode_64, t62.targetType AS targetType_65, t62.classic AS classic_66, t62.preca AS preca_67, t62.enable AS enable_68, t62.raiType AS raiType_69, t62.contractSignedElectronically AS contractSignedElectronically_70, t62.pro_signature_mandatory_outlay AS pro_signature_mandatory_outlay_71, t62.obligeTarget_id AS obligeTarget_id_72, t62.teteReseau_id AS teteReseau_id_73, t62.simulateur_id AS simulateur_id_74, t62.installateurTarget_id AS installateurTarget_id_75, t62.beTarget_id AS beTarget_id_76 FROM Simulateur t0 LEFT JOIN Operation t11 ON t0.active_operation_id = t11.id LEFT JOIN AffectationConsoneoRule t62 ON t62.simulateur_id = t0.id WHERE t0.id = ?
Parameters: 
[
  455
]
View formatted query    View runnable query    Explain query
6 0.88 ms 
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 = ?
Parameters: 
[
  6
]
View formatted query    View runnable query    Explain query
7 0.85 ms 
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 = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
8 0.91 ms 
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 = ?
Parameters: 
[
  5
]
View formatted query    View runnable query    Explain query
9 2.36 ms 
SELECT a0_.id AS id_0, a0_.created_datetime AS created_datetime_1, a0_.reason AS reason_2, a0_.type AS type_3, a0_.burn AS burn_4, a0_.burn_datetime AS burn_datetime_5, a0_.target_state_choice AS target_state_choice_6, a0_.batch_choice AS batch_choice_7, a0_.answer AS answer_8, a0_.offreProjet_id AS offreProjet_id_9, a0_.asker_id AS asker_id_10, a0_.target_state AS target_state_11 FROM AskUpdateStateOffreProjet a0_ WHERE a0_.offreProjet_id = ? ORDER BY a0_.created_datetime DESC LIMIT 1
Parameters: 
[
  1467
]
View formatted query    View runnable query    Explain query
10 5.16 ms 
SELECT t0.state AS state_1, t0.prettyName AS prettyName_2, t0.prettyNameIsolvendeur AS prettyNameIsolvendeur_3, t0.prettyNameFront AS prettyNameFront_4, t0.nextStepBe AS nextStepBe_5, t0.nextStepBeneficiaire AS nextStepBeneficiaire_6, t0.ahPrettyName AS ahPrettyName_7, t0.preActif AS preActif_8, t0.actif AS actif_9, t0.validationFinal AS validationFinal_10, t0.postEditionAh AS postEditionAh_11, t0.postValidationFinal AS postValidationFinal_12, t0.preAh AS preAh_13, t0.preValidationFinal AS preValidationFinal_14, t0.inactif AS inactif_15, t0.uploadAvailable AS uploadAvailable_16, t0.uploadPostConvention AS uploadPostConvention_17, t0.noLinearState AS noLinearState_18, t0.EndState AS EndState_19 FROM OffreProjetState t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
11 1.69 ms 
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.alias AS alias_32, t0.conventionElectronique AS conventionElectronique_33, t0.aftElectronique AS aftElectronique_34, t0.contratInstallateur AS contratInstallateur_35, t0.modeProBeneficiaireInscription AS modeProBeneficiaireInscription_36, t0.modeByPassSuperviseur AS modeByPassSuperviseur_37, t0.`lead` AS lead_38, t0.`leadUrl` AS leadUrl_39, t0.`leadLogin` AS leadLogin_40, t0.`leadPassword` AS leadPassword_41, t0.relanceConventionClientUn AS relanceConventionClientUn_42, t0.relanceConventionClientDeux AS relanceConventionClientDeux_43, t0.alertConventionClient AS alertConventionClient_44, t0.relanceConventionInstallateurUn AS relanceConventionInstallateurUn_45, t0.relanceConventionInstallateurDeux AS relanceConventionInstallateurDeux_46, t0.alertConventionInstallateur AS alertConventionInstallateur_47, t0.conventionFin AS conventionFin_48, t0.questionnaireAftRelanceUn AS questionnaireAftRelanceUn_49, t0.questionnaireAftRelanceDeux AS questionnaireAftRelanceDeux_50, t0.alertQuestionnaireAFT AS alertQuestionnaireAFT_51, t0.questionnaireAftFin AS questionnaireAftFin_52, t0.relanceAftFacture AS relanceAftFacture_53, t0.alertAftFacture AS alertAftFacture_54, t0.aftFactureFin AS aftFactureFin_55, t0.mentionCnil AS mentionCnil_56, t0.serviceType AS serviceType_57, t0.precariteMode AS precariteMode_58, t0.precariteModeProgram AS precariteModeProgram_59, t0.blocked AS blocked_60, t0.blockedSimulation AS blockedSimulation_61, t0.resiliation AS resiliation_62, t0.archivageAuto AS archivageAuto_63, t0.travauxPostDevis AS travauxPostDevis_64, t0.emailFacturationPro AS emailFacturationPro_65, t0.mandatoryInstallateurGenericContract AS mandatoryInstallateurGenericContract_66, t0.hiddenEmail AS hiddenEmail_67, t0.certificallCompanyId AS certificallCompanyId_68, t0.visibilityCommercials AS visibilityCommercials_69, t0.mandat AS mandat_70, t0.pricingMandatClassique AS pricingMandatClassique_71, t0.pricingMandatPreca AS pricingMandatPreca_72, t0.pricingPrimeMaximumMandatClassique AS pricingPrimeMaximumMandatClassique_73, t0.pricingPrimeMaximumMandatPreca AS pricingPrimeMaximumMandatPreca_74, t0.originauxAdresse AS originauxAdresse_75, t0.originauxAdresseComplement AS originauxAdresseComplement_76, t0.originauxCodepostal AS originauxCodepostal_77, t0.originauxVille AS originauxVille_78, t0.eligible AS eligible_79, t0.satisfactionSurvey AS satisfactionSurvey_80, t0.surveyConfiguration AS surveyConfiguration_81, t0.autoPayment AS autoPayment_82, t0.isAnnexeDechetQuestion AS isAnnexeDechetQuestion_83, t0.aiEnabled AS aiEnabled_84, t0.isSignatureAutoAhEnabled AS isSignatureAutoAhEnabled_85, t0.isSignatureAutoOtherDocumentsEnabled AS isSignatureAutoOtherDocumentsEnabled_86, t0.emailVersion AS emailVersion_87, t0.validateBackwards AS validateBackwards_88, t0.displayTelConsoneo AS displayTelConsoneo_89, t0.allowedUniverSign AS allowedUniverSign_90, t0.allowedApplicationFees AS allowedApplicationFees_91, t0.displayApplicationFees AS displayApplicationFees_92, t0.programAutoAllowed AS programAutoAllowed_93, t0.mpr AS mpr_94, t0.isRibActivated AS isRibActivated_95, t0.canonicalTeteReseau_id AS canonicalTeteReseau_id_96, t0.oblige_id AS oblige_id_97, t98.id AS id_99, t98.raison AS raison_100, t98.email AS email_101, t98.tel AS tel_102, t98.site_web AS site_web_103, t98.adresse AS adresse_104, t98.cp AS cp_105, t98.ville AS ville_106, t98.oblige_id AS oblige_id_107, t108.id AS id_109, t108.gender AS gender_110, t108.firstName AS firstName_111, t108.name AS name_112, t108.raison AS raison_113, t108.email AS email_114, t108.tel AS tel_115, t108.address AS address_116, t108.cp AS cp_117, t108.city AS city_118, t108.adminMandate AS adminMandate_119, t108.financialMandate AS financialMandate_120, t108.mixteMandate AS mixteMandate_121, t108.signature AS signature_122, t108.tutorial_admin AS tutorial_admin_123, t108.tutorial_mixte AS tutorial_mixte_124, t108.tutorial_financial AS tutorial_financial_125, t108.oblige_id AS oblige_id_126, t127.id AS id_128, t127.raison AS raison_129, t127.siret AS siret_130, t127.oblige_id AS oblige_id_131 FROM Oblige t0 LEFT JOIN Mediateur t98 ON t98.oblige_id = t0.id LEFT JOIN MprConfig t108 ON t108.oblige_id = t0.id LEFT JOIN Mandataire t127 ON t127.oblige_id = t0.id WHERE t0.id = ?
Parameters: 
[
  6
]
View formatted query    View runnable query    Explain query
12 0.98 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.enabled AS enabled_3, t0.salt AS salt_4, t0.password AS password_5, t0.last_login AS last_login_6, t0.confirmation_token AS confirmation_token_7, t0.password_requested_at AS password_requested_at_8, t0.roles AS roles_9, t0.username AS username_10, t0.nom AS nom_11, t0.prenom AS prenom_12, t0.fonction AS fonction_13, t0.tel AS tel_14, t0.mobile AS mobile_15, t0.activation AS activation_16, t0.createdAt AS createdAt_17, t0.updatedAt AS updatedAt_18, t0.optin AS optin_19, t0.dateActivation AS dateActivation_20, t0.emailValidatedDateTime AS emailValidatedDateTime_21, t0.emailCreatedDateTime AS emailCreatedDateTime_22, t0.mobileCreatedDatetime AS mobileCreatedDatetime_23, t0.sendEmail AS sendEmail_24, t0.scope AS scope_25, t0.isArchived AS isArchived_26, t0.import AS import_27, t0.neoSpaceEnabled AS neoSpaceEnabled_28, t0.email_canonical AS email_canonical_29, t0.username_canonical AS username_canonical_30, t0.oblige_id AS oblige_id_31 FROM ObligeUser t0 WHERE t0.id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
13 1.77 ms 
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 = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
14 4.16 ms 
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
Parameters: 
[
  "validate_backwards"
  6
  "Consoneo\Bundle\UserBundle\Entity\Oblige"
]
View formatted query    View runnable query    Explain query
15 2.32 ms 
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
Parameters: 
[
  "allowed_all_operator_return"
  6
  "Consoneo\Bundle\UserBundle\Entity\Oblige"
]
View formatted query    View runnable query    Explain query
16 25.77 ms 
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
Parameters: 
[
  "operator-offer-update"
]
View formatted query    View runnable query    Explain query
17 1.19 ms 
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 = ?
Parameters: 
[
  44
]
View formatted query    View runnable query    Explain query
18 4.42 ms 
SELECT t0.id AS id_1, t0.username_canonical AS username_canonical_2, t0.email_canonical AS email_canonical_3, t0.enabled AS enabled_4, t0.salt AS salt_5, t0.password AS password_6, t0.last_login AS last_login_7, t0.confirmation_token AS confirmation_token_8, t0.password_requested_at AS password_requested_at_9, t0.roles AS roles_10, t0.nom AS nom_11, t0.prenom AS prenom_12, t0.fonction AS fonction_13, t0.tel AS tel_14, t0.mobile AS mobile_15, t0.activation AS activation_16, t0.createdAt AS createdAt_17, t0.updatedAt AS updatedAt_18, t0.optin AS optin_19, t0.dateActivation AS dateActivation_20, t0.emailValidatedDateTime AS emailValidatedDateTime_21, t0.emailCreatedDateTime AS emailCreatedDateTime_22, t0.mobileCreatedDatetime AS mobileCreatedDatetime_23, t0.sendEmail AS sendEmail_24, t0.dateEnvoiGuide AS dateEnvoiGuide_25, t0.token AS token_26, t0.emailJustificatifPreca AS emailJustificatifPreca_27, t0.adresse AS adresse_28, t0.adresse_complement AS adresse_complement_29, t0.codepostal AS codepostal_30, t0.ville AS ville_31, t0.formPrecaResponse AS formPrecaResponse_32, t0.gender AS gender_33, t0.stampFilename AS stampFilename_34, t0.email AS email_35, t0.username AS username_36, t0.cas1_id AS cas1_id_37, t38.id AS id_39, t38.type AS type_40, t38.detail AS detail_41, t38.token AS token_42, t38.installateur_id AS installateur_id_43, t38.particulierUser_id AS particulierUser_id_44, t38.entrepriseUser_id AS entrepriseUser_id_45, t38.particulierUserContact_id AS particulierUserContact_id_46, t38.entrepriseUserContact_id AS entrepriseUserContact_id_47, t0.identite_id AS identite_id_48, t0.integrationModule_id AS integrationModule_id_49 FROM ParticulierUserContact t0 LEFT JOIN PaymentMethod t38 ON t38.particulierUserContact_id = t0.id WHERE t0.id = ?
Parameters: 
[
  268
]
View formatted query    View runnable query    Explain query
19 1.78 ms 
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.alias AS alias_32, t0.conventionElectronique AS conventionElectronique_33, t0.aftElectronique AS aftElectronique_34, t0.contratInstallateur AS contratInstallateur_35, t0.modeProBeneficiaireInscription AS modeProBeneficiaireInscription_36, t0.modeByPassSuperviseur AS modeByPassSuperviseur_37, t0.`lead` AS lead_38, t0.`leadUrl` AS leadUrl_39, t0.`leadLogin` AS leadLogin_40, t0.`leadPassword` AS leadPassword_41, t0.relanceConventionClientUn AS relanceConventionClientUn_42, t0.relanceConventionClientDeux AS relanceConventionClientDeux_43, t0.alertConventionClient AS alertConventionClient_44, t0.relanceConventionInstallateurUn AS relanceConventionInstallateurUn_45, t0.relanceConventionInstallateurDeux AS relanceConventionInstallateurDeux_46, t0.alertConventionInstallateur AS alertConventionInstallateur_47, t0.conventionFin AS conventionFin_48, t0.questionnaireAftRelanceUn AS questionnaireAftRelanceUn_49, t0.questionnaireAftRelanceDeux AS questionnaireAftRelanceDeux_50, t0.alertQuestionnaireAFT AS alertQuestionnaireAFT_51, t0.questionnaireAftFin AS questionnaireAftFin_52, t0.relanceAftFacture AS relanceAftFacture_53, t0.alertAftFacture AS alertAftFacture_54, t0.aftFactureFin AS aftFactureFin_55, t0.mentionCnil AS mentionCnil_56, t0.serviceType AS serviceType_57, t0.precariteMode AS precariteMode_58, t0.precariteModeProgram AS precariteModeProgram_59, t0.blocked AS blocked_60, t0.blockedSimulation AS blockedSimulation_61, t0.resiliation AS resiliation_62, t0.archivageAuto AS archivageAuto_63, t0.travauxPostDevis AS travauxPostDevis_64, t0.emailFacturationPro AS emailFacturationPro_65, t0.mandatoryInstallateurGenericContract AS mandatoryInstallateurGenericContract_66, t0.hiddenEmail AS hiddenEmail_67, t0.certificallCompanyId AS certificallCompanyId_68, t0.visibilityCommercials AS visibilityCommercials_69, t0.mandat AS mandat_70, t0.pricingMandatClassique AS pricingMandatClassique_71, t0.pricingMandatPreca AS pricingMandatPreca_72, t0.pricingPrimeMaximumMandatClassique AS pricingPrimeMaximumMandatClassique_73, t0.pricingPrimeMaximumMandatPreca AS pricingPrimeMaximumMandatPreca_74, t0.originauxAdresse AS originauxAdresse_75, t0.originauxAdresseComplement AS originauxAdresseComplement_76, t0.originauxCodepostal AS originauxCodepostal_77, t0.originauxVille AS originauxVille_78, t0.eligible AS eligible_79, t0.satisfactionSurvey AS satisfactionSurvey_80, t0.surveyConfiguration AS surveyConfiguration_81, t0.autoPayment AS autoPayment_82, t0.isAnnexeDechetQuestion AS isAnnexeDechetQuestion_83, t0.aiEnabled AS aiEnabled_84, t0.isSignatureAutoAhEnabled AS isSignatureAutoAhEnabled_85, t0.isSignatureAutoOtherDocumentsEnabled AS isSignatureAutoOtherDocumentsEnabled_86, t0.emailVersion AS emailVersion_87, t0.validateBackwards AS validateBackwards_88, t0.displayTelConsoneo AS displayTelConsoneo_89, t0.allowedUniverSign AS allowedUniverSign_90, t0.allowedApplicationFees AS allowedApplicationFees_91, t0.displayApplicationFees AS displayApplicationFees_92, t0.programAutoAllowed AS programAutoAllowed_93, t0.mpr AS mpr_94, t0.isRibActivated AS isRibActivated_95, t0.canonicalTeteReseau_id AS canonicalTeteReseau_id_96, t0.oblige_id AS oblige_id_97, t98.id AS id_99, t98.raison AS raison_100, t98.email AS email_101, t98.tel AS tel_102, t98.site_web AS site_web_103, t98.adresse AS adresse_104, t98.cp AS cp_105, t98.ville AS ville_106, t98.oblige_id AS oblige_id_107, t108.id AS id_109, t108.gender AS gender_110, t108.firstName AS firstName_111, t108.name AS name_112, t108.raison AS raison_113, t108.email AS email_114, t108.tel AS tel_115, t108.address AS address_116, t108.cp AS cp_117, t108.city AS city_118, t108.adminMandate AS adminMandate_119, t108.financialMandate AS financialMandate_120, t108.mixteMandate AS mixteMandate_121, t108.signature AS signature_122, t108.tutorial_admin AS tutorial_admin_123, t108.tutorial_mixte AS tutorial_mixte_124, t108.tutorial_financial AS tutorial_financial_125, t108.oblige_id AS oblige_id_126, t127.id AS id_128, t127.raison AS raison_129, t127.siret AS siret_130, t127.oblige_id AS oblige_id_131 FROM Oblige t0 LEFT JOIN Mediateur t98 ON t98.oblige_id = t0.id LEFT JOIN MprConfig t108 ON t108.oblige_id = t0.id LEFT JOIN Mandataire t127 ON t127.oblige_id = t0.id WHERE t0.oblige_id = ?
Parameters: 
[
  6
]
View formatted query    View runnable query    Explain query
20 27.70 ms 
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 (?, ?, ?, ?, ?, ?)
Parameters: 
[
  6
  21
  23
  1467
  "[email protected]"
  "[email protected]"
  "[email protected]"
  "[email protected]"
  "TRA-EQ-117%"
  "TRA-EQ-117%"
  "demande_refuser"
  "dossier_aft_ineligible"
  "dossier_supprime_auto"
  "dossier_supprime_manuel_back"
  "dossier_supprime_manuel_front"
  "dossier_invalide_auto"
]
View formatted query    View runnable query    Explain query
21 4.72 ms 
SELECT a0_.id AS id_0, a0_.offreProjet_id AS offreProjet_id_1, a0_.obligeUser_id AS obligeUser_id_2, a0_.obligeRole_id AS obligeRole_id_3 FROM AffectationOffre a0_ INNER JOIN ObligeRole o1_ ON a0_.obligeRole_id = o1_.id WHERE a0_.offreProjet_id = ? AND o1_.role = ? LIMIT 1
Parameters: 
[
  1467
  "ROLE_OPERATEUR_PROJET_B2C"
]
View formatted query    View runnable query    Explain query
22 1.10 ms 
SELECT a0_.id AS id_0, a0_.offreProjet_id AS offreProjet_id_1, a0_.obligeUser_id AS obligeUser_id_2, a0_.obligeRole_id AS obligeRole_id_3 FROM AffectationOffre a0_ INNER JOIN ObligeRole o1_ ON a0_.obligeRole_id = o1_.id WHERE a0_.offreProjet_id = ? AND o1_.role = ? LIMIT 1
Parameters: 
[
  1467
  "ROLE_OPERATEUR_PROJET_B2C"
]
View formatted query    View runnable query    Explain query
23 1.17 ms 
SELECT a0_.id AS id_0, a0_.offreProjet_id AS offreProjet_id_1, a0_.obligeUser_id AS obligeUser_id_2, a0_.obligeRole_id AS obligeRole_id_3 FROM AffectationOffre a0_ INNER JOIN ObligeRole o1_ ON a0_.obligeRole_id = o1_.id WHERE a0_.offreProjet_id = ? AND o1_.role = ? LIMIT 1
Parameters: 
[
  1467
  "ROLE_MANAGER_TECH"
]
View formatted query    View runnable query    Explain query
24 9.95 ms 
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.offreProjet_id = ?
Parameters: 
[
  1467
]
View formatted query    View runnable query    Explain query
25 2.32 ms 
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
Parameters: 
[
  "justificatif_performance_energetique"
]
View formatted query    View runnable query    Explain query
26 5.07 ms 
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
Parameters: 
[
  1467
  418
]
View formatted query    View runnable query    Explain query
27 1.00 ms 
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.suffix AS suffix_2, a0_.effectiveDate AS effectiveDate_3 FROM Arrete a0_ WHERE a0_.effectiveDate <= ? ORDER BY a0_.effectiveDate DESC
Parameters: 
[
  "2026-09-16 17:16:55"
]
View formatted query    View runnable query    Explain query
28 9.51 ms 
SELECT t0.id AS id_1, t0.textInfo AS textInfo_2, t0.factureInfo AS factureInfo_3, t0.factureInfoCdp AS factureInfoCdp_4, t0.operation_id AS operation_id_5, t0.arrete_id AS arrete_id_6 FROM MoteurInfoArrete t0 WHERE t0.operation_id = ? AND t0.arrete_id = ? LIMIT 1
Parameters: 
[
  1084
  50
]
View formatted query    View runnable query    Explain query
29 0.88 ms 
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
Parameters: 
[
  "convention"
]
View formatted query    View runnable query    Explain query
30 5.50 ms 
SELECT d0_.dateSignatureConvention AS dateSignatureConvention_0, d0_.dateSignatureAhClient AS dateSignatureAhClient_1, d0_.dateSignatureAhPro AS dateSignatureAhPro_2, d0_.dateSignatureFacture AS dateSignatureFacture_3, d0_.datePrevisite AS datePrevisite_4, d0_.noQrDecode AS noQrDecode_5, d0_.id AS id_6, d0_.originalName AS originalName_7, d0_.optionalName AS optionalName_8, d0_.valid AS valid_9, d0_.process AS process_10, d0_.decoded AS decoded_11, d0_.disabled AS disabled_12, d0_.path AS path_13, d0_.validated_datetime AS validated_datetime_14, d0_.processed_datetime AS processed_datetime_15, d0_.created_datetime AS created_datetime_16, d0_.updated_datetime AS updated_datetime_17, d0_.signe AS signe_18, d0_.lisible AS lisible_19, d0_.electronic AS electronic_20, d0_.thumbnail AS thumbnail_21, d0_.reference AS reference_22, d0_.stockage AS stockage_23, d0_.iua AS iua_24, d0_.safeId AS safeId_25, d0_.serviceType AS serviceType_26, d0_.secondJustificatif AS secondJustificatif_27, d0_.imported AS imported_28, d0_.dateEditionDevis AS dateEditionDevis_29, d0_.ahProElectronic AS ahProElectronic_30, d0_.signataireName AS signataireName_31, d0_.signataireSurname AS signataireSurname_32, d0_.dateEmission AS dateEmission_33, d0_.expirationDate AS expirationDate_34, d0_.sienna_id AS sienna_id_35, d0_.offre_projets_group AS offre_projets_group_36, d0_.type_id AS type_id_37, d0_.offreProjet_id AS offreProjet_id_38, d0_.installateurUser_id AS installateurUser_id_39, d0_.justificatif_id AS justificatif_id_40, d0_.jpe_id AS jpe_id_41, d0_.obligeUser_id AS obligeUser_id_42, d0_.obligeUserReal_id AS obligeUserReal_id_43, d0_.factureDetail_id AS factureDetail_id_44, d0_.contract_id AS contract_id_45, d0_.geolocalisation_id AS geolocalisation_id_46, d0_.sousTraitant_id AS sousTraitant_id_47, d0_.certilink_id AS certilink_id_48 FROM Document d0_ WHERE d0_.valid = ? AND d0_.offreProjet_id = ? AND d0_.type_id = ? LIMIT 1
Parameters: 
[
  1
  1467
  1
]
View formatted query    View runnable query    Explain query
31 41.53 ms 
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 = ?
Parameters: 
[
  "[email protected]"
  "[email protected]"
  "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"
  1467
]
View formatted query    View runnable query    Explain query
32 10.58 ms 
SELECT o0_.id AS id_0, o0_.raison AS raison_1, o0_.siret AS siret_2, o0_.checkType AS checkType_3, o0_.batch_id AS batch_id_4, o0_.offreProjet_id AS offreProjet_id_5 FROM OrganismeControl o0_ WHERE o0_.offreProjet_id = ? AND o0_.checkType = ? AND o0_.batch_id IS NULL
Parameters: 
[
  1467
  "direct"
]
View formatted query    View runnable query    Explain query
33 2.41 ms 
SELECT o0_.id AS id_0, o0_.raison AS raison_1, o0_.siret AS siret_2, o0_.checkType AS checkType_3, o0_.batch_id AS batch_id_4, o0_.offreProjet_id AS offreProjet_id_5 FROM OrganismeControl o0_ WHERE o0_.offreProjet_id = ? AND o0_.checkType = ? AND o0_.batch_id IS NULL
Parameters: 
[
  1467
  "contact"
]
View formatted query    View runnable query    Explain query
34 3.28 ms 
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
Parameters: 
[
  "mode_debride_project_bundle"
  1467
]
View formatted query    View runnable query    Explain query
35 4.89 ms 
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.date_limite_depot_referencement AS date_limite_depot_referencement_88, t52.end_zni_date AS end_zni_date_89, t52.globalConfigurationHash AS globalConfigurationHash_90, t52.zni AS zni_91, t52.cdp_eligible AS cdp_eligible_92, t52.simulateur_id AS simulateur_id_93, t52.arrete_id AS arrete_id_94, t52.certification_id AS certification_id_95, t52.qualification_id AS qualification_id_96, t52.formConfigEngine_id AS formConfigEngine_id_97, t0.entrepriseUser_id AS entrepriseUser_id_98, t0.particulierUser_id AS particulierUser_id_99, t0.installateurUser_id AS installateurUser_id_100, t0.beUser_id AS beUser_id_101, t102.id AS id_103, t102.type AS type_104, t102.pricingType AS pricingType_105, t102.finalisationRequested AS finalisationRequested_106, t102.finalisationRequestDate AS finalisationRequestDate_107, t102.cofracSatisfyDate AS cofracSatisfyDate_108, t102.reference AS reference_109, t102.data AS data_110, t102.cofracData AS cofracData_111, t102.cofracEngineDocumentId AS cofracEngineDocumentId_112, t102.ip AS ip_113, t102.offre_auto_date AS offre_auto_date_114, t102.created_datetime AS created_datetime_115, t102.updated_datetime AS updated_datetime_116, t102.tel AS tel_117, t102.codepostal AS codepostal_118, t102.adresse AS adresse_119, t102.adresse_complement AS adresse_complement_120, t102.ville AS ville_121, t102.delai_souhaite AS delai_souhaite_122, t102.accept_recevoir_offre AS accept_recevoir_offre_123, t102.accept_recommandation AS accept_recommandation_124, t102.acceptLeadPromo AS acceptLeadPromo_125, t102.offre_cumac AS offre_cumac_126, t102.offre_cumac_client AS offre_cumac_client_127, t102.offre_cumac_precarite AS offre_cumac_precarite_128, t102.offre_cumac_client_precarite AS offre_cumac_client_precarite_129, t102.cumac AS cumac_130, t102.cumac_AFT AS cumac_AFT_131, t102.total_prime AS total_prime_132, t102.total_prime_AFT AS total_prime_AFT_133, t102.prime_pro AS prime_pro_134, t102.prime_pro_aft AS prime_pro_aft_135, t102.prime_client AS prime_client_136, t102.prime_client_aft AS prime_client_aft_137, t102.cumac_moyenne AS cumac_moyenne_138, t102.taux_actualise AS taux_actualise_139, t102.taux_accumule AS taux_accumule_140, t102.date_debut_chantier AS date_debut_chantier_141, t102.date_demande_offre AS date_demande_offre_142, t102.date_fin_chantier AS date_fin_chantier_143, t102.etat AS etat_144, t102.status AS status_145, t102.date_offre AS date_offre_146, t102.notification_date_chantier AS notification_date_chantier_147, t102.date_retour_conv AS date_retour_conv_148, t102.date_validation_conv AS date_validation_conv_149, t102.date_chantier_renseigne AS date_chantier_renseigne_150, t102.date_paiement AS date_paiement_151, t102.date_all_doc_valid AS date_all_doc_valid_152, t102.date_fin_chantier_repousse AS date_fin_chantier_repousse_153, t102.date_envoi_questionnaire AS date_envoi_questionnaire_154, t102.date_edition_questionnaire AS date_edition_questionnaire_155, t102.date_validation_final AS date_validation_final_156, t102.date_annulation AS date_annulation_157, t102.no_click_email_date_chantier AS no_click_email_date_chantier_158, t102.token AS token_159, t102.auto_installation AS auto_installation_160, t102.siret AS siret_161, t102.cancelReason AS cancelReason_162, t102.dateCommande AS dateCommande_163, t102.siteTravaux AS siteTravaux_164, t102.incitation AS incitation_165, t102.qualificationRecordDate AS qualificationRecordDate_166, t102.serviceType AS serviceType_167, t102.debutChantier AS debutChantier_168, t102.finChantier AS finChantier_169, t102.initiateCDP AS initiateCDP_170, t102.cdp AS cdp_171, t102.date_last_envoi_convention AS date_last_envoi_convention_172, t102.programStep AS programStep_173, t102.devisRestAPayer AS devisRestAPayer_174, t102.pricingMandatClassique AS pricingMandatClassique_175, t102.pricingMandatPreca AS pricingMandatPreca_176, t102.isCOFRAC AS isCOFRAC_177, t102.applicationFeesPrice AS applicationFeesPrice_178, t102.attributes AS attributes_179, t102.exclusive AS exclusive_180, t102.engineDocumentId AS engineDocumentId_181, t102.adresseTravaux AS adresseTravaux_182, t102.adresseTravauxCommentaire AS adresseTravauxCommentaire_183, t102.batchOffreProjet_id AS batchOffreProjet_id_184, t102.entrepriseUser_id AS entrepriseUser_id_185, t102.installateurUser_id AS installateurUser_id_186, t102.beUser_id AS beUser_id_187, t102.entrepriseUserContact_id AS entrepriseUserContact_id_188, t102.particulierUserContact_id AS particulierUserContact_id_189, t102.signataireEntreprise_id AS signataireEntreprise_id_190, t102.signataireInstallateur_id AS signataireInstallateur_id_191, t102.installateurUserContact_id AS installateurUserContact_id_192, t102.projet_id AS projet_id_193, t102.precariteCas2_id AS precariteCas2_id_194, t102.creditNoteContract_id AS creditNoteContract_id_195, t102.precarite_id AS precarite_id_196, t102.state_id AS state_id_197, t102.oblige_id AS oblige_id_198, t102.secteurActivite_id AS secteurActivite_id_199, t102.factureDetail_id AS factureDetail_id_200, t102.offreStatus_id AS offreStatus_id_201, t102.identiteBeneficiaire_id AS identiteBeneficiaire_id_202, t102.identiteInstallateur_id AS identiteInstallateur_id_203, t102.operation_id AS operation_id_204, t102.particulierUser_id AS particulierUser_id_205, t102.qualificationRecord_id AS qualificationRecord_id_206, t102.sousTraitant_id AS sousTraitant_id_207, t102.program_id AS program_id_208, t102.programCommercial_id AS programCommercial_id_209, t102.programManager_id AS programManager_id_210, t102.signatureAuto_id AS signatureAuto_id_211, t102.wasteCenter_id AS wasteCenter_id_212, t102.waste_id AS waste_id_213, t102.programAuto_id AS programAuto_id_214, t102.justificatif_id AS justificatif_id_215, t102.cappingRule_id AS cappingRule_id_216, t102.projectOwner_id AS projectOwner_id_217, t102.project_bundle_id AS project_bundle_id_218, t102.estate_id AS estate_id_219, t0.precarite_id AS precarite_id_220, t0.secteurActivite_id AS secteurActivite_id_221, t0.integrationModule_id AS integrationModule_id_222, t0.precariteCas2_id AS precariteCas2_id_223, t0.program_id AS program_id_224, t0.programCommercial_id AS programCommercial_id_225, t0.programManager_id AS programManager_id_226, t0.justificatif_id AS justificatif_id_227, t228.id AS id_229, t228.numero AS numero_230, t228.dateRealisation AS dateRealisation_231, t228.dateFinValidite AS dateFinValidite_232, t228.etiquetteBilan AS etiquetteBilan_233, t228.createdAt AS createdAt_234, t228.updatedAt AS updatedAt_235, t228.typeJustificatif AS typeJustificatif_236, t228.projet_id AS projet_id_237, t228.offreProjet_id AS offreProjet_id_238, t0.project_bundle_id AS project_bundle_id_239, t0.estate_id AS estate_id_240 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 t102 ON t102.projet_id = t0.id LEFT JOIN JustificatifPerformanceEnergetique t228 ON t228.projet_id = t0.id WHERE t0.id = ?
Parameters: 
[
  3875
]
View formatted query    View runnable query    Explain query
36 2.08 ms 
SELECT t0.id AS id_1, t0.dataSimulation AS dataSimulation_2, t0.dataAH AS dataAH_3, t0.cumac AS cumac_4, t0.tauxActualise AS tauxActualise_5, t0.tauxAccumule AS tauxAccumule_6, t0.cumacMoyenne AS cumacMoyenne_7, t0.initiateCDP AS initiateCDP_8, t0.cofracData AS cofracData_9, t0.operation_id AS operation_id_10, t0.projet_id AS projet_id_11, t0.program_id AS program_id_12, t0.offreProjet_id AS offreProjet_id_13 FROM OperationRecord t0 WHERE t0.projet_id = ?
Parameters: 
[
  3875
]
View formatted query    View runnable query    Explain query
37 5.32 ms 
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
Parameters: 
[
  "cofrac"
  1467
]
View formatted query    View runnable query    Explain query
38 1.70 ms 
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
Parameters: 
[
  "delay_cofrac"
  1467
]
View formatted query    View runnable query    Explain query
39 21.99 ms 
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 = ?
Parameters: 
[
  1467
]
View formatted query    View runnable query    Explain query
40 1.11 ms 
SELECT h0_.id AS id_0, h0_.emailId AS emailId_1, h0_.type AS type_2, h0_.saved AS saved_3, h0_.iua AS iua_4, h0_.backupMail AS backupMail_5, h0_.originalName AS originalName_6, h0_.ersIua AS ersIua_7, h0_.emailDate AS emailDate_8, h0_.retry AS retry_9, h0_.createdAt AS createdAt_10, h0_.updatedAt AS updatedAt_11, h0_.offreProjet_id AS offreProjet_id_12, h0_.contract_id AS contract_id_13 FROM Horodatage h0_ WHERE h0_.offreProjet_id = ? AND h0_.type IN ('convention', 'email', 'contribution') AND h0_.saved = ? ORDER BY h0_.updatedAt ASC LIMIT 1
Parameters: 
[
  1467
  1
]
View formatted query    View runnable query    Explain query
41 2.32 ms 
SELECT t0.id AS id_1, t0.step AS step_2, t0.type AS type_3, t0.reference AS reference_4, t0.code AS code_5, t0.dataMoteur AS dataMoteur_6, t0.primeDistributeur AS primeDistributeur_7, t0.nom AS nom_8, t0.marque AS marque_9, t0.url AS url_10, t0.emailPrefix AS emailPrefix_11, t0.is_active AS is_active_12, t0.nbKit AS nbKit_13, t0.dateFin AS dateFin_14, t0.contratDistributeurRaiDate AS contratDistributeurRaiDate_15, t0.contratDistributeurSignedDate AS contratDistributeurSignedDate_16, t0.contratDistributeurIua AS contratDistributeurIua_17, t0.contratDistributeurSignedIua AS contratDistributeurSignedIua_18, t0.username AS username_19, t0.password AS password_20, t0.commandeEquipmentIua AS commandeEquipmentIua_21, t0.ahIua AS ahIua_22, t0.ahSignedIua AS ahSignedIua_23, t0.dateAhSigned AS dateAhSigned_24, t0.consoneo AS consoneo_25, t0.cumac AS cumac_26, t0.supportPhone AS supportPhone_27, t0.pricingMode AS pricingMode_28, t0.pricingValue AS pricingValue_29, t0.complementaryDocs AS complementaryDocs_30, t0.serviceType AS serviceType_31, t0.safeId AS safeId_32, t0.operation_id AS operation_id_33, t0.oblige_id AS oblige_id_34, t0.integrationModule_id AS integrationModule_id_35, t0.installateurUser_id AS installateurUser_id_36, t0.identiteInstallateurUser_id AS identiteInstallateurUser_id_37, t0.horodatage_id AS horodatage_id_38 FROM Campagne t0 WHERE t0.horodatage_id = ?
Parameters: 
[
  1572
]
View formatted query    View runnable query    Explain query
42 11.14 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.created_datetime AS created_datetime_4, t0.iua AS iua_5, t0.safeId AS safeId_6, t0.serviceType AS serviceType_7, t0.stockage AS stockage_8, t0.offreProjetsGroup AS offreProjetsGroup_9, t0.offreProjet_id AS offreProjet_id_10, t0.installateurUser_id AS installateurUser_id_11 FROM DocumentStatic t0 WHERE t0.offreProjet_id = ?
Parameters: 
[
  1467
]
View formatted query    View runnable query    Explain query
43 0.89 ms 
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
Parameters: 
[
  "devis_offre"
]
View formatted query    View runnable query    Explain query
44 17.40 ms 
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
Parameters: 
[
  80
  1467
  268
]
View formatted query    View runnable query    Explain query
45 1.00 ms 
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
Parameters: 
[
  "devis_auto"
]
View formatted query    View runnable query    Explain query
46 0.99 ms 
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
Parameters: 
[
  140
  1467
  268
]
View formatted query    View runnable query    Explain query
47 0.74 ms 
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
Parameters: 
[
  "convention"
]
View formatted query    View runnable query    Explain query
48 0.94 ms 
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
Parameters: 
[
  1
  1467
  268
]
View formatted query    View runnable query    Explain query
49 0.74 ms 
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
Parameters: 
[
  "convention"
]
View formatted query    View runnable query    Explain query
50 0.93 ms 
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
Parameters: 
[
  1
  1467
  268
]
View formatted query    View runnable query    Explain query
51 0.72 ms 
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
Parameters: 
[
  "convention"
]
View formatted query    View runnable query    Explain query
52 0.97 ms 
SELECT d0_.dateSignatureConvention AS dateSignatureConvention_0, d0_.dateSignatureAhClient AS dateSignatureAhClient_1, d0_.dateSignatureAhPro AS dateSignatureAhPro_2, d0_.dateSignatureFacture AS dateSignatureFacture_3, d0_.datePrevisite AS datePrevisite_4, d0_.noQrDecode AS noQrDecode_5, d0_.id AS id_6, d0_.originalName AS originalName_7, d0_.optionalName AS optionalName_8, d0_.valid AS valid_9, d0_.process AS process_10, d0_.decoded AS decoded_11, d0_.disabled AS disabled_12, d0_.path AS path_13, d0_.validated_datetime AS validated_datetime_14, d0_.processed_datetime AS processed_datetime_15, d0_.created_datetime AS created_datetime_16, d0_.updated_datetime AS updated_datetime_17, d0_.signe AS signe_18, d0_.lisible AS lisible_19, d0_.electronic AS electronic_20, d0_.thumbnail AS thumbnail_21, d0_.reference AS reference_22, d0_.stockage AS stockage_23, d0_.iua AS iua_24, d0_.safeId AS safeId_25, d0_.serviceType AS serviceType_26, d0_.secondJustificatif AS secondJustificatif_27, d0_.imported AS imported_28, d0_.dateEditionDevis AS dateEditionDevis_29, d0_.ahProElectronic AS ahProElectronic_30, d0_.signataireName AS signataireName_31, d0_.signataireSurname AS signataireSurname_32, d0_.dateEmission AS dateEmission_33, d0_.expirationDate AS expirationDate_34, d0_.sienna_id AS sienna_id_35, d0_.offre_projets_group AS offre_projets_group_36, d0_.type_id AS type_id_37, d0_.offreProjet_id AS offreProjet_id_38, d0_.installateurUser_id AS installateurUser_id_39, d0_.justificatif_id AS justificatif_id_40, d0_.jpe_id AS jpe_id_41, d0_.obligeUser_id AS obligeUser_id_42, d0_.obligeUserReal_id AS obligeUserReal_id_43, d0_.factureDetail_id AS factureDetail_id_44, d0_.contract_id AS contract_id_45, d0_.geolocalisation_id AS geolocalisation_id_46, d0_.sousTraitant_id AS sousTraitant_id_47, d0_.certilink_id AS certilink_id_48 FROM Document d0_ WHERE d0_.valid = ? AND d0_.offreProjet_id = ? AND d0_.type_id = ? AND d0_.valid = ? AND d0_.signe = ? LIMIT 1
Parameters: 
[
  1
  1467
  1
  1
  1
]
View formatted query    View runnable query    Explain query
53 0.80 ms 
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_ WHERE d0_.offreProjet_id = ? AND d0_.type = ? ORDER BY d0_.id DESC LIMIT 1
Parameters: 
[
  1467
  "devis_offre"
]
View formatted query    View runnable query    Explain query
54 0.78 ms 
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_ WHERE d0_.offreProjet_id = ? AND d0_.type = ? ORDER BY d0_.id DESC LIMIT 1
Parameters: 
[
  1467
  "devis_auto"
]
View formatted query    View runnable query    Explain query
55 1.89 ms 
SELECT 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 WHERE d1_.slug IN ('devis_auto', 'devis_offre') AND o0_.offreProjet_id = ? AND o0_.satisfied = 1 LIMIT 1
Parameters: 
[
  1467
]
View formatted query    View runnable query    Explain query
56 1.07 ms 
SELECT d0_.dateSignatureConvention AS dateSignatureConvention_0, d0_.dateSignatureAhClient AS dateSignatureAhClient_1, d0_.dateSignatureAhPro AS dateSignatureAhPro_2, d0_.dateSignatureFacture AS dateSignatureFacture_3, d0_.datePrevisite AS datePrevisite_4, d0_.noQrDecode AS noQrDecode_5, d0_.id AS id_6, d0_.originalName AS originalName_7, d0_.optionalName AS optionalName_8, d0_.valid AS valid_9, d0_.process AS process_10, d0_.decoded AS decoded_11, d0_.disabled AS disabled_12, d0_.path AS path_13, d0_.validated_datetime AS validated_datetime_14, d0_.processed_datetime AS processed_datetime_15, d0_.created_datetime AS created_datetime_16, d0_.updated_datetime AS updated_datetime_17, d0_.signe AS signe_18, d0_.lisible AS lisible_19, d0_.electronic AS electronic_20, d0_.thumbnail AS thumbnail_21, d0_.reference AS reference_22, d0_.stockage AS stockage_23, d0_.iua AS iua_24, d0_.safeId AS safeId_25, d0_.serviceType AS serviceType_26, d0_.secondJustificatif AS secondJustificatif_27, d0_.imported AS imported_28, d0_.dateEditionDevis AS dateEditionDevis_29, d0_.ahProElectronic AS ahProElectronic_30, d0_.signataireName AS signataireName_31, d0_.signataireSurname AS signataireSurname_32, d0_.dateEmission AS dateEmission_33, d0_.expirationDate AS expirationDate_34, d0_.sienna_id AS sienna_id_35, d0_.offre_projets_group AS offre_projets_group_36, d0_.type_id AS type_id_37, d0_.offreProjet_id AS offreProjet_id_38, d0_.installateurUser_id AS installateurUser_id_39, d0_.justificatif_id AS justificatif_id_40, d0_.jpe_id AS jpe_id_41, d0_.obligeUser_id AS obligeUser_id_42, d0_.obligeUserReal_id AS obligeUserReal_id_43, d0_.factureDetail_id AS factureDetail_id_44, d0_.contract_id AS contract_id_45, d0_.geolocalisation_id AS geolocalisation_id_46, d0_.sousTraitant_id AS sousTraitant_id_47, d0_.certilink_id AS certilink_id_48 FROM Document d0_ INNER JOIN DocumentType d1_ ON d0_.type_id = d1_.id WHERE d0_.offreProjet_id = ? AND d1_.slug IN ('devis_auto', 'devis_offre') ORDER BY d0_.id DESC LIMIT 1
Parameters: 
[
  1467
]
View formatted query    View runnable query    Explain query
57 0.90 ms 
SELECT 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 WHERE d1_.slug IN ('devis_auto', 'devis_offre') AND o0_.offreProjet_id = ? LIMIT 1
Parameters: 
[
  1467
]
View formatted query    View runnable query    Explain query
58 0.87 ms 
SELECT 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 WHERE d1_.slug IN ('devis_auto', 'devis_offre') AND o0_.offreProjet_id = ? LIMIT 1
Parameters: 
[
  1467
]
View formatted query    View runnable query    Explain query
59 0.83 ms 
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 = ?
Parameters: 
[
  1467
]
View formatted query    View runnable query    Explain query
60 3.49 ms 
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.descriptionShort AS descriptionShort_3, t0.descriptionLong AS descriptionLong_4, t0.position AS position_5, t0.categorieNum AS categorieNum_6, t0.correspondance AS correspondance_7, t0.name AS name_8, t0.risName AS risName_9, t0.version AS version_10 FROM DomaineTravauxRGE t0 INNER JOIN OffreProjetDocumentObligatoire_DomaineTravaux ON t0.id = OffreProjetDocumentObligatoire_DomaineTravaux.domaineTravaux_id WHERE OffreProjetDocumentObligatoire_DomaineTravaux.offreProjetDocumentObligatoire_id = ?
Parameters: 
[
  7916
]
View formatted query    View runnable query    Explain query
61 0.84 ms 
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.descriptionShort AS descriptionShort_3, t0.descriptionLong AS descriptionLong_4, t0.position AS position_5, t0.categorieNum AS categorieNum_6, t0.correspondance AS correspondance_7, t0.name AS name_8, t0.risName AS risName_9, t0.version AS version_10 FROM DomaineTravauxRGE t0 INNER JOIN OffreProjetDocumentObligatoire_DomaineTravaux ON t0.id = OffreProjetDocumentObligatoire_DomaineTravaux.domaineTravaux_id WHERE OffreProjetDocumentObligatoire_DomaineTravaux.offreProjetDocumentObligatoire_id = ?
Parameters: 
[
  7917
]
View formatted query    View runnable query    Explain query
62 0.74 ms 
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.descriptionShort AS descriptionShort_3, t0.descriptionLong AS descriptionLong_4, t0.position AS position_5, t0.categorieNum AS categorieNum_6, t0.correspondance AS correspondance_7, t0.name AS name_8, t0.risName AS risName_9, t0.version AS version_10 FROM DomaineTravauxRGE t0 INNER JOIN OffreProjetDocumentObligatoire_DomaineTravaux ON t0.id = OffreProjetDocumentObligatoire_DomaineTravaux.domaineTravaux_id WHERE OffreProjetDocumentObligatoire_DomaineTravaux.offreProjetDocumentObligatoire_id = ?
Parameters: 
[
  7918
]
View formatted query    View runnable query    Explain query
63 0.74 ms 
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.descriptionShort AS descriptionShort_3, t0.descriptionLong AS descriptionLong_4, t0.position AS position_5, t0.categorieNum AS categorieNum_6, t0.correspondance AS correspondance_7, t0.name AS name_8, t0.risName AS risName_9, t0.version AS version_10 FROM DomaineTravauxRGE t0 INNER JOIN OffreProjetDocumentObligatoire_DomaineTravaux ON t0.id = OffreProjetDocumentObligatoire_DomaineTravaux.domaineTravaux_id WHERE OffreProjetDocumentObligatoire_DomaineTravaux.offreProjetDocumentObligatoire_id = ?
Parameters: 
[
  7919
]
View formatted query    View runnable query    Explain query
64 0.72 ms 
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.descriptionShort AS descriptionShort_3, t0.descriptionLong AS descriptionLong_4, t0.position AS position_5, t0.categorieNum AS categorieNum_6, t0.correspondance AS correspondance_7, t0.name AS name_8, t0.risName AS risName_9, t0.version AS version_10 FROM DomaineTravauxRGE t0 INNER JOIN OffreProjetDocumentObligatoire_DomaineTravaux ON t0.id = OffreProjetDocumentObligatoire_DomaineTravaux.domaineTravaux_id WHERE OffreProjetDocumentObligatoire_DomaineTravaux.offreProjetDocumentObligatoire_id = ?
Parameters: 
[
  7920
]
View formatted query    View runnable query    Explain query
65 0.73 ms 
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
Parameters: 
[
  "facture"
]
View formatted query    View runnable query    Explain query
66 2.97 ms 
SELECT d0_.dateSignatureConvention AS dateSignatureConvention_0, d0_.dateSignatureAhClient AS dateSignatureAhClient_1, d0_.dateSignatureAhPro AS dateSignatureAhPro_2, d0_.dateSignatureFacture AS dateSignatureFacture_3, d0_.datePrevisite AS datePrevisite_4, d0_.noQrDecode AS noQrDecode_5, d0_.id AS id_6, d0_.originalName AS originalName_7, d0_.optionalName AS optionalName_8, d0_.valid AS valid_9, d0_.process AS process_10, d0_.decoded AS decoded_11, d0_.disabled AS disabled_12, d0_.path AS path_13, d0_.validated_datetime AS validated_datetime_14, d0_.processed_datetime AS processed_datetime_15, d0_.created_datetime AS created_datetime_16, d0_.updated_datetime AS updated_datetime_17, d0_.signe AS signe_18, d0_.lisible AS lisible_19, d0_.electronic AS electronic_20, d0_.thumbnail AS thumbnail_21, d0_.reference AS reference_22, d0_.stockage AS stockage_23, d0_.iua AS iua_24, d0_.safeId AS safeId_25, d0_.serviceType AS serviceType_26, d0_.secondJustificatif AS secondJustificatif_27, d0_.imported AS imported_28, d0_.dateEditionDevis AS dateEditionDevis_29, d0_.ahProElectronic AS ahProElectronic_30, d0_.signataireName AS signataireName_31, d0_.signataireSurname AS signataireSurname_32, d0_.dateEmission AS dateEmission_33, d0_.expirationDate AS expirationDate_34, d0_.sienna_id AS sienna_id_35, d0_.offre_projets_group AS offre_projets_group_36, d0_.type_id AS type_id_37, d0_.offreProjet_id AS offreProjet_id_38, d0_.installateurUser_id AS installateurUser_id_39, d0_.justificatif_id AS justificatif_id_40, d0_.jpe_id AS jpe_id_41, d0_.obligeUser_id AS obligeUser_id_42, d0_.obligeUserReal_id AS obligeUserReal_id_43, d0_.factureDetail_id AS factureDetail_id_44, d0_.contract_id AS contract_id_45, d0_.geolocalisation_id AS geolocalisation_id_46, d0_.sousTraitant_id AS sousTraitant_id_47, d0_.certilink_id AS certilink_id_48 FROM Document d0_ WHERE d0_.valid = ? AND d0_.offreProjet_id = ? AND d0_.type_id = ? LIMIT 1
Parameters: 
[
  1
  1467
  4
]
View formatted query    View runnable query    Explain query
67 1.08 ms 
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 = ?
Parameters: 
[
  1467
  "ah"
]
View formatted query    View runnable query    Explain query
68 0.86 ms 
SELECT a0_.id AS id_0, a0_.created_datetime AS created_datetime_1, a0_.reason AS reason_2, a0_.type AS type_3, a0_.burn AS burn_4, a0_.burn_datetime AS burn_datetime_5, a0_.target_state_choice AS target_state_choice_6, a0_.batch_choice AS batch_choice_7, a0_.answer AS answer_8, a0_.offreProjet_id AS offreProjet_id_9, a0_.asker_id AS asker_id_10, a0_.target_state AS target_state_11 FROM AskUpdateStateOffreProjet a0_ WHERE a0_.offreProjet_id = ? AND a0_.burn = ? AND a0_.type = ?
Parameters: 
[
  1467
  1
  "retour en arrière"
]
View formatted query    View runnable query    Explain query
69 0.75 ms 
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
Parameters: 
[
  "aft"
]
View formatted query    View runnable query    Explain query
70 0.96 ms 
SELECT d0_.dateSignatureConvention AS dateSignatureConvention_0, d0_.dateSignatureAhClient AS dateSignatureAhClient_1, d0_.dateSignatureAhPro AS dateSignatureAhPro_2, d0_.dateSignatureFacture AS dateSignatureFacture_3, d0_.datePrevisite AS datePrevisite_4, d0_.noQrDecode AS noQrDecode_5, d0_.id AS id_6, d0_.originalName AS originalName_7, d0_.optionalName AS optionalName_8, d0_.valid AS valid_9, d0_.process AS process_10, d0_.decoded AS decoded_11, d0_.disabled AS disabled_12, d0_.path AS path_13, d0_.validated_datetime AS validated_datetime_14, d0_.processed_datetime AS processed_datetime_15, d0_.created_datetime AS created_datetime_16, d0_.updated_datetime AS updated_datetime_17, d0_.signe AS signe_18, d0_.lisible AS lisible_19, d0_.electronic AS electronic_20, d0_.thumbnail AS thumbnail_21, d0_.reference AS reference_22, d0_.stockage AS stockage_23, d0_.iua AS iua_24, d0_.safeId AS safeId_25, d0_.serviceType AS serviceType_26, d0_.secondJustificatif AS secondJustificatif_27, d0_.imported AS imported_28, d0_.dateEditionDevis AS dateEditionDevis_29, d0_.ahProElectronic AS ahProElectronic_30, d0_.signataireName AS signataireName_31, d0_.signataireSurname AS signataireSurname_32, d0_.dateEmission AS dateEmission_33, d0_.expirationDate AS expirationDate_34, d0_.sienna_id AS sienna_id_35, d0_.offre_projets_group AS offre_projets_group_36, d0_.type_id AS type_id_37, d0_.offreProjet_id AS offreProjet_id_38, d0_.installateurUser_id AS installateurUser_id_39, d0_.justificatif_id AS justificatif_id_40, d0_.jpe_id AS jpe_id_41, d0_.obligeUser_id AS obligeUser_id_42, d0_.obligeUserReal_id AS obligeUserReal_id_43, d0_.factureDetail_id AS factureDetail_id_44, d0_.contract_id AS contract_id_45, d0_.geolocalisation_id AS geolocalisation_id_46, d0_.sousTraitant_id AS sousTraitant_id_47, d0_.certilink_id AS certilink_id_48 FROM Document d0_ WHERE d0_.valid = ? AND d0_.offreProjet_id = ? AND d0_.type_id = ? LIMIT 1
Parameters: 
[
  1
  1467
  2
]
View formatted query    View runnable query    Explain query
71 0.80 ms 
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
Parameters: 
[
  "technique_produit"
]
View formatted query    View runnable query    Explain query
72 0.91 ms 
SELECT d0_.dateSignatureConvention AS dateSignatureConvention_0, d0_.dateSignatureAhClient AS dateSignatureAhClient_1, d0_.dateSignatureAhPro AS dateSignatureAhPro_2, d0_.dateSignatureFacture AS dateSignatureFacture_3, d0_.datePrevisite AS datePrevisite_4, d0_.noQrDecode AS noQrDecode_5, d0_.id AS id_6, d0_.originalName AS originalName_7, d0_.optionalName AS optionalName_8, d0_.valid AS valid_9, d0_.process AS process_10, d0_.decoded AS decoded_11, d0_.disabled AS disabled_12, d0_.path AS path_13, d0_.validated_datetime AS validated_datetime_14, d0_.processed_datetime AS processed_datetime_15, d0_.created_datetime AS created_datetime_16, d0_.updated_datetime AS updated_datetime_17, d0_.signe AS signe_18, d0_.lisible AS lisible_19, d0_.electronic AS electronic_20, d0_.thumbnail AS thumbnail_21, d0_.reference AS reference_22, d0_.stockage AS stockage_23, d0_.iua AS iua_24, d0_.safeId AS safeId_25, d0_.serviceType AS serviceType_26, d0_.secondJustificatif AS secondJustificatif_27, d0_.imported AS imported_28, d0_.dateEditionDevis AS dateEditionDevis_29, d0_.ahProElectronic AS ahProElectronic_30, d0_.signataireName AS signataireName_31, d0_.signataireSurname AS signataireSurname_32, d0_.dateEmission AS dateEmission_33, d0_.expirationDate AS expirationDate_34, d0_.sienna_id AS sienna_id_35, d0_.offre_projets_group AS offre_projets_group_36, d0_.type_id AS type_id_37, d0_.offreProjet_id AS offreProjet_id_38, d0_.installateurUser_id AS installateurUser_id_39, d0_.justificatif_id AS justificatif_id_40, d0_.jpe_id AS jpe_id_41, d0_.obligeUser_id AS obligeUser_id_42, d0_.obligeUserReal_id AS obligeUserReal_id_43, d0_.factureDetail_id AS factureDetail_id_44, d0_.contract_id AS contract_id_45, d0_.geolocalisation_id AS geolocalisation_id_46, d0_.sousTraitant_id AS sousTraitant_id_47, d0_.certilink_id AS certilink_id_48 FROM Document d0_ WHERE d0_.valid = ? AND d0_.offreProjet_id = ? AND d0_.type_id = ? LIMIT 1
Parameters: 
[
  1
  1467
  52
]
View formatted query    View runnable query    Explain query
73 2.31 ms 
SELECT t0.id AS id_1, t0.acompteDate AS acompteDate_2, t0.acompteReference AS acompteReference_3, t0.acomptePrice AS acomptePrice_4, t0.soldeDate AS soldeDate_5, t0.soldePrevisionnel AS soldePrevisionnel_6, t0.soldeReference AS soldeReference_7, t0.soldePrice AS soldePrice_8, t0.comeFrom AS comeFrom_9, t0.target AS target_10, t0.archive AS archive_11, t0.step AS step_12, t0.offreProjet_id AS offreProjet_id_13 FROM Payment t0 WHERE t0.offreProjet_id = ?
Parameters: 
[
  1467
]
View formatted query    View runnable query    Explain query
74 1.28 ms 
SELECT t0.id AS id_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.username AS username_12, t0.nom AS nom_13, t0.prenom AS prenom_14, t0.fonction AS fonction_15, t0.tel AS tel_16, t0.mobile AS mobile_17, t0.activation AS activation_18, t0.createdAt AS createdAt_19, t0.updatedAt AS updatedAt_20, t0.optin AS optin_21, t0.dateActivation AS dateActivation_22, t0.emailValidatedDateTime AS emailValidatedDateTime_23, t0.emailCreatedDateTime AS emailCreatedDateTime_24, t0.mobileCreatedDatetime AS mobileCreatedDatetime_25, t0.sendEmail AS sendEmail_26, t0.reference AS reference_27, t0.currentSubscriptionStep AS currentSubscriptionStep_28, t0.dateRetourContratPartenariat AS dateRetourContratPartenariat_29, t0.token AS token_30, t0.dateActivationStep2 AS dateActivationStep2_31, t0.dateActivationStep4 AS dateActivationStep4_32, t0.dateActivationStep5 AS dateActivationStep5_33, t0.dateRefused AS dateRefused_34, t0.emailRequested AS emailRequested_35, t0.emailRequestedDate AS emailRequestedDate_36, t0.attributes AS attributes_37, t0.lastOffreDate AS lastOffreDate_38, t0.quicklyTraited AS quicklyTraited_39, t0.proType AS proType_40, t0.system_facturation AS system_facturation_41, t0.signataireAh AS signataireAh_42, t0.inscription_step AS inscription_step_43, t0.import_status AS import_status_44, t0.token_thermor AS token_thermor_45, t0.exclusiveEnabled AS exclusiveEnabled_46, t0.relanceSmsRegistration AS relanceSmsRegistration_47, t0.dateRelanceSmsRegistration AS dateRelanceSmsRegistration_48, t0.company_id AS company_id_49, t0.workflow_id AS workflow_id_50, t0.obligeTarget_id AS obligeTarget_id_51, t0.identite_id AS identite_id_52, t0.integrationModule_id AS integrationModule_id_53 FROM InstallateurUser t0 WHERE t0.id = ?
Parameters: 
[
  14728
]
View formatted query    View runnable query    Explain query
75 0.97 ms 
SELECT t0.id AS id_1, t0.entrepriseUser_id AS entrepriseUser_id_2, t0.particulierUser_id AS particulierUser_id_3, t0.installateurUser_id AS installateurUser_id_4, t0.beUser_id AS beUser_id_5, t0.obligeUser_id AS obligeUser_id_6, t0.obligeRole_id AS obligeRole_id_7 FROM AffectationUser t0 WHERE t0.installateurUser_id IN (?)
Parameters: 
[
  14728
]
View formatted query    View runnable query    Explain query
76 1.71 ms 
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.id = ?
Parameters: 
[
  4791
]
View formatted query    View runnable query    Explain query
77 1.14 ms 
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.createdAt AS createdAt_3, t0.slug AS slug_4, t0.consoneoInstallateurPrixFixSimulation AS consoneoInstallateurPrixFixSimulation_5, t0.consoneoInstallateurPrixFixOffre AS consoneoInstallateurPrixFixOffre_6, t0.allow_curseur AS allow_curseur_7, t0.consoneoInstallateurVariableTranche1 AS consoneoInstallateurVariableTranche1_8, t0.consoneoInstallateurValeurTranche1 AS consoneoInstallateurValeurTranche1_9, t0.consoneoInstallateurVariableTranche2 AS consoneoInstallateurVariableTranche2_10, t0.consoneoInstallateurValeurTranche2 AS consoneoInstallateurValeurTranche2_11, t0.consoneoInstallateurVariableTranche3 AS consoneoInstallateurVariableTranche3_12, t0.consoneoInstallateurValeurTranche3 AS consoneoInstallateurValeurTranche3_13, t0.consoneoInstallateurVariableTranche4 AS consoneoInstallateurVariableTranche4_14, t0.consoneoInstallateurValeurTranche4 AS consoneoInstallateurValeurTranche4_15, t0.consoneoInstallateurValeurTrancheMax AS consoneoInstallateurValeurTrancheMax_16, t0.logo AS logo_17, t0.modePrime AS modePrime_18, t0.incitation AS incitation_19, t0.`lead` AS lead_20, t0.actif AS actif_21, t0.partenariatContract AS partenariatContract_22, t0.allowElectronicSign AS allowElectronicSign_23, t0.canonicalModuleInstallateur_id AS canonicalModuleInstallateur_id_24, t0.canonicalModuleEntreprise_id AS canonicalModuleEntreprise_id_25, t0.canonicalModuleParticulier_id AS canonicalModuleParticulier_id_26, t0.oblige_id AS oblige_id_27, t0.obligeTargetConsoneoPrixFix_id AS obligeTargetConsoneoPrixFix_id_28, t0.obligeTargetConsoneoPrixVariable_id AS obligeTargetConsoneoPrixVariable_id_29 FROM TeteReseau t0 WHERE t0.id = ?
Parameters: 
[
  1510
]
View formatted query    View runnable query    Explain query
78 2.40 ms 
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
Parameters: 
[
  "occupant_logement"
  1467
]
View formatted query    View runnable query    Explain query
79 2.73 ms 
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
Parameters: 
[
  "proprietaire_detail"
  1467
]
View formatted query    View runnable query    Explain query
80 18.40 ms 
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 = ?
Parameters: 
[
  12766
]
View formatted query    View runnable query    Explain query

Database Connections

Name Service
default doctrine.dbal.default_connection
read doctrine.dbal.read_connection
stats doctrine.dbal.stats_connection
qrdecode doctrine.dbal.qrdecode_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
read doctrine.orm.read_entity_manager
stats doctrine.orm.stats_entity_manager
qrdecode doctrine.orm.qrdecode_entity_manager

Second Level Cache

0 Hits
0 Misses
0 Puts

Managed Entities

default entity manager

Class Amount of managed objects
Consoneo\Bundle\ObligeBundle\Entity\Arrete 45
Consoneo\Bundle\UserBundle\Entity\RegleRole 39
Consoneo\Bundle\UserBundle\Entity\ObligeRole 19
Consoneo\Bundle\ObligeBundle\Entity\DocumentType 8
Consoneo\Bundle\UserBundle\Entity\TeteReseau 6
Consoneo\Bundle\ObligeBundle\Entity\OffreProjetDocumentObligatoire 5
Consoneo\Bundle\UserBundle\Entity\AffectationUser 5
Consoneo\Bundle\UserBundle\Entity\Oblige 4
Consoneo\Bundle\ObligeBundle\Entity\OffreProjetAdditionalInformation 4
Consoneo\Bundle\ObligeBundle\Entity\IntegrationModule 3
Consoneo\Bundle\ObligeBundle\Entity\DocumentStatic 3
Consoneo\Bundle\UserBundle\Entity\ObligeUser 2
Consoneo\Bundle\UserBundle\Entity\Identite 2
Consoneo\Bundle\ObligeBundle\Entity\Configuration 2
Consoneo\Bundle\ObligeBundle\Entity\OffreProjet 1
Consoneo\Bundle\UserBundle\Entity\InstallateurUser 1
Consoneo\Bundle\UserBundle\Entity\ParticulierUserContact 1
Consoneo\Bundle\ObligeBundle\Entity\Projet 1
Consoneo\Bundle\ObligeBundle\Entity\OffreProjetState 1
Consoneo\Bundle\SimulateurBundle\Entity\SecteurActivite 1
Consoneo\Bundle\ObligeBundle\Entity\OffreProjetStatus 1
Consoneo\Bundle\SimulateurBundle\Entity\Operation 1
Consoneo\Bundle\ObligeBundle\Entity\SignatureAuto 1
Consoneo\Bundle\UserBundle\Entity\ProjectOwner 1
Consoneo\Bundle\SimulateurBundle\Entity\Simulateur 1
Consoneo\Bundle\SimulateurBundle\Entity\Secteur 1
Consoneo\Bundle\SimulateurBundle\Entity\Categorie 1
Consoneo\Bundle\SimulateurBundle\Entity\TypeOperation 1
Consoneo\Bundle\UserBundle\Entity\AffectationOffre 1
Consoneo\Bundle\ObligeBundle\Entity\MoteurInfoArrete 1
Consoneo\Bundle\WorkflowBundle\Entity\Horodatage 1
Consoneo\Bundle\WorkflowBundle\Entity\SignatureRequest 1
Consoneo\Bundle\ObligeBundle\Entity\Document 1
Consoneo\Bundle\UserBundle\Entity\Installateur 1
Consoneo\Bundle\WorkflowBundle\Entity\Workflow 1
Consoneo\Bundle\WorkflowBundle\Entity\Branding 1
Consoneo\Bundle\ObligeBundle\Entity\PaymentMethod 1
Consoneo\Bundle\UserBundle\Entity\InstallateurCertificallConfig 1

read entity manager

Class Amount of managed objects
Consoneo\Bundle\ObligeBundle\Entity\Arrete 45
Consoneo\Bundle\ObligeBundle\Entity\OffreProjetState 27
Consoneo\Bundle\WorkflowBundle\Entity\Horodatage 1
Consoneo\Bundle\ObligeBundle\Entity\OffreProjet 1

stats entity manager

Class Amount of managed objects

qrdecode entity manager

Class Amount of managed objects

Entities Mapping

default entity manager

Class Mapping errors
Consoneo\Bundle\UserBundle\Entity\ObligeUser No errors.
Consoneo\Bundle\UserBundle\Entity\Oblige No errors.
Consoneo\Bundle\ObligeBundle\Entity\Reminder No errors.
Consoneo\Bundle\ObligeBundle\Entity\Comment No errors.
Consoneo\Bundle\ObligeBundle\Entity\Document No errors.
Consoneo\Bundle\UserBundle\Entity\TeteReseau No errors.
Consoneo\Bundle\WorkflowBundle\Entity\AlertRecord No errors.
Consoneo\Bundle\ObligeBundle\Entity\StatRecord No errors.
Consoneo\Bundle\UserBundle\Entity\AffectationUser No errors.
Consoneo\Bundle\UserBundle\Entity\AffectationOffre No errors.
Consoneo\Bundle\UserBundle\Entity\RegleRole No errors.
Consoneo\Bundle\ObligeBundle\Entity\Campagne No errors.
Consoneo\Bundle\ObligeBundle\Entity\OffreProjetMonitoring No errors.
Consoneo\Bundle\ObligeBundle\Entity\PaymentMethodOblige No errors.
Consoneo\Bundle\ObligeBundle\Entity\ControlStepHistory No errors.
Consoneo\Bundle\ObligeBundle\Entity\OffreProjetAdditionalInformation No errors.
Consoneo\Bundle\ObligeBundle\Entity\Configuration No errors.
Consoneo\Bundle\WorkflowBundle\Entity\EmailHistory No errors.
Consoneo\Bundle\SimulateurBundle\Entity\Operation No errors.
Consoneo\Bundle\ObligeBundle\Entity\MoteurInfoArrete No errors.
Consoneo\Bundle\ObligeBundle\Entity\Arrete No errors.
Consoneo\Bundle\ObligeBundle\Entity\Contract No errors.
Consoneo\Bundle\ObligeBundle\Entity\DocumentStatic No errors.
Consoneo\Bundle\ObligeBundle\Entity\DocumentType No errors.
Consoneo\Bundle\ObligeBundle\Entity\OffreProjetDocumentObligatoire No errors.
Consoneo\Bundle\ObligeBundle\Entity\OffreProjet No errors.
Consoneo\Bundle\ObligeBundle\Entity\SampleCofracOperation No errors.
Consoneo\Bundle\ObligeBundle\Entity\Batch No errors.
Consoneo\Bundle\WorkflowBundle\Entity\Email No errors.
C2eCoreBundle\Entity\Certificall\Certilink No errors.
Consoneo\Bundle\UserBundle\Entity\InstallateurCertificallConfig No errors.
Consoneo\Bundle\UserBundle\Entity\EntrepriseUser No errors.
Consoneo\Bundle\UserBundle\Entity\InstallateurUser No errors.
Consoneo\Bundle\UserBundle\Entity\BeUser No errors.
Consoneo\Bundle\UserBundle\Entity\EntrepriseUserContact No errors.
Consoneo\Bundle\UserBundle\Entity\ParticulierUserContact No errors.
Consoneo\Bundle\UserBundle\Entity\SignataireEntreprise No errors.
Consoneo\Bundle\UserBundle\Entity\SignataireInstallateur No errors.
Consoneo\Bundle\UserBundle\Entity\InstallateurUserContact No errors.
Consoneo\Bundle\ObligeBundle\Entity\Projet No errors.
Consoneo\Bundle\SimulateurBundle\Entity\PrecariteCas2 No errors.
Consoneo\Bundle\ObligeBundle\Entity\Precarite No errors.
Consoneo\Bundle\ObligeBundle\Entity\OffreProjetState No errors.
Consoneo\Bundle\ObligeBundle\Entity\OffreProjetValidation No errors.
Consoneo\Bundle\SimulateurBundle\Entity\SecteurActivite No errors.
Consoneo\Bundle\ObligeBundle\Entity\FactureDetail No errors.
Consoneo\Bundle\ObligeBundle\Entity\Lead No errors.
Consoneo\Bundle\ObligeBundle\Entity\IntegrationModule No errors.
Consoneo\Bundle\ObligeBundle\Entity\OffreProjetStatus No errors.
Consoneo\Bundle\UserBundle\Entity\Identite No errors.
Consoneo\Bundle\UserBundle\Entity\ParticulierUser No errors.
Consoneo\Bundle\UserBundle\Entity\QualificationRecord No errors.
Consoneo\Bundle\UserBundle\Entity\SousTraitantRGE No errors.
Consoneo\Bundle\WorkflowBundle\Entity\Program No errors.
Consoneo\Bundle\ObligeBundle\Entity\User\Program\Commercial No errors.
Consoneo\Bundle\ObligeBundle\Entity\User\Program\Manager No errors.
Consoneo\Bundle\ObligeBundle\Entity\SignatureAuto No errors.
Consoneo\Bundle\ObligeBundle\Entity\WasteCenter No errors.
Consoneo\Bundle\ObligeBundle\Entity\Waste No errors.
Consoneo\Bundle\WorkflowBundle\Entity\ProgramAuto No errors.
Consoneo\Bundle\UserBundle\Entity\Precarite\Justificatif No errors.
Consoneo\Bundle\ObligeBundle\Entity\CappingRule No errors.
Consoneo\Bundle\ObligeBundle\Entity\PaymentMpr No errors.
Consoneo\Bundle\ObligeBundle\Entity\BatchBankTransfer No errors.
Consoneo\Bundle\UserBundle\Entity\Installateur No errors.
Consoneo\Bundle\ObligeBundle\Entity\JustificatifPerformanceEnergetique No errors.
Consoneo\Bundle\UserBundle\Entity\ProjectOwner No errors.
C2eCoreBundle\Entity\Internal\ProjectBundle No errors.
C2eCoreBundle\Entity\Internal\Estate No errors.
Consoneo\Bundle\ObligeBundle\Entity\Recensement No errors.
Consoneo\Bundle\ObligeBundle\Entity\OffreProjetTag No errors.
Consoneo\Bundle\ObligeBundle\Entity\OffreProjetProduit No errors.
Consoneo\Bundle\ObligeBundle\Entity\AskUpdateStateOffreProjet No errors.
Consoneo\Bundle\WorkflowBundle\Entity\Sms No errors.
Consoneo\Bundle\WorkflowBundle\Entity\Horodatage No errors.
Consoneo\Bundle\ObligeBundle\Entity\Message No errors.
Consoneo\Bundle\ObligeBundle\Entity\Payment No errors.
Consoneo\Bundle\ObligeBundle\Entity\OperationRecord No errors.
Consoneo\Bundle\ObligeBundle\Entity\Program\StepHistory No errors.
Consoneo\Bundle\ObligeBundle\Entity\Control No errors.
Consoneo\Bundle\WorkflowBundle\Entity\OffreProjetProgramAutoData No errors.
Consoneo\Bundle\ObligeBundle\Entity\CofracDocument No errors.
Consoneo\Bundle\ObligeBundle\Entity\ControlMonitoringHistory No errors.
Consoneo\Bundle\SimulateurBundle\Entity\Simulateur No errors.
Consoneo\Bundle\ObligeBundle\Entity\Certification No errors.
Consoneo\Bundle\UserBundle\Entity\Qualification No errors.
Consoneo\Bundle\FormGeneratorBundle\Form\Domain\Model\FormConfig No errors.
Consoneo\Bundle\SimulateurBundle\Entity\OperationQuestionItem No errors.
Consoneo\Bundle\SimulateurBundle\Entity\DataQuestion No errors.
Consoneo\Bundle\UserBundle\Entity\DomaineTravauxRGE No errors.
Consoneo\Bundle\UserBundle\Entity\Be No errors.
Consoneo\Bundle\ObligeBundle\Entity\ObligeOperation No errors.
Consoneo\Bundle\ObligeBundle\Entity\Program\Isolant No errors.
C2eCoreBundle\Entity\Internal\ProjectBundleOperation No errors.
C2eCoreBundle\Entity\Engine\ConstraintRule No errors.
C2eCoreBundle\Entity\Engine\MatrixDefinition No errors.
C2eCoreBundle\Entity\Engine\Formula No errors.
Consoneo\Bundle\ObligeBundle\Entity\OperationDocumentConfig No errors.
Consoneo\Bundle\SimulateurBundle\Entity\Secteur No errors.
Consoneo\Bundle\SimulateurBundle\Entity\Categorie No errors.
Consoneo\Bundle\SimulateurBundle\Entity\TypeOperation No errors.
Consoneo\Bundle\SimulateurBundle\Entity\OperationSpecifique No errors.
Consoneo\Bundle\UserBundle\Entity\AffectationConsoneoRule No errors.
Consoneo\Bundle\UserBundle\Entity\ApplicationFees No errors.
Consoneo\Bundle\ObligeBundle\Entity\Mediateur No errors.
Consoneo\Bundle\ObligeBundle\Entity\MprConfig No errors.
Consoneo\Bundle\UserBundle\Entity\Mandataire No errors.
Consoneo\Bundle\ObligeBundle\Entity\PricingGroup No errors.
Consoneo\Bundle\ObligeBundle\Entity\ObligeBlockedTimetable No errors.
Consoneo\Bundle\WorkflowBundle\Entity\CoupDePouce No errors.
Consoneo\Bundle\ObligeBundle\Entity\EmailConfigurationRecord No errors.
Consoneo\Bundle\ObligeBundle\Entity\ConfigurationPaymentRecord No errors.
Consoneo\Bundle\UserBundle\Entity\ObligeDocumentTypeConfig No errors.
Consoneo\Bundle\ObligeBundle\Entity\Product\Product No errors.
Consoneo\Bundle\ObligeBundle\Entity\PrestataireEffacement No errors.
Consoneo\Bundle\UserBundle\Entity\ObligeRole No errors.
Consoneo\Bundle\ObligeBundle\Entity\Alert No errors.
Consoneo\Bundle\UserBundle\Entity\Precarite\Cas1 No errors.
Consoneo\Bundle\ObligeBundle\Entity\PaymentMethod No errors.
Consoneo\Bundle\ObligeBundle\Entity\MPRMonitoring No errors.
Consoneo\Bundle\WorkflowBundle\Entity\SignatureRequest No errors.
Consoneo\Bundle\ObligeBundle\Entity\Position\Geolocalisation No errors.
Consoneo\Bundle\ObligeBundle\Entity\UploadedDocument No errors.
Consoneo\Bundle\ObligeBundle\Entity\RefuseOffreProjet No errors.
Consoneo\Bundle\WorkflowBundle\Entity\AlertRecordJournal No errors.
Consoneo\Bundle\ObligeBundle\Entity\Stat No errors.
Consoneo\Bundle\ObligeBundle\Entity\CampagneBurnCode No errors.
Consoneo\Bundle\ObligeBundle\Entity\CampagneDistribution No errors.
Consoneo\Bundle\ObligeBundle\Entity\CampagneKpi No errors.
Consoneo\Bundle\ObligeBundle\Entity\CampagneUser No errors.
Consoneo\Bundle\UserBundle\Entity\InstallateurDocumentReference No errors.
Consoneo\Bundle\ObligeBundle\Entity\SampleCofracStepHistory No errors.
Consoneo\Bundle\ObligeBundle\Entity\BatchStateHistory No errors.
Consoneo\Bundle\ObligeBundle\Entity\OrganismeControl No errors.
Consoneo\Bundle\ObligeBundle\Entity\Cofrac No errors.
C2eCoreBundle\Entity\Certificall\CertilinkItem No errors.
Consoneo\Bundle\UserBundle\Entity\Entreprise No errors.
Consoneo\Bundle\WorkflowBundle\Entity\Workflow No errors.
Consoneo\Bundle\UserBundle\Entity\UserDocumentObligatoire No errors.
Consoneo\Bundle\UserBundle\Entity\EtudeMultiOp No errors.
Consoneo\Bundle\WorkflowBundle\Entity\InstallateurUserProgram No errors.
Consoneo\Bundle\UserBundle\Entity\EntrepriseContact No errors.
Consoneo\Bundle\UserBundle\Entity\InstallateurContact No errors.
Consoneo\Bundle\WorkflowBundle\Entity\Branding No errors.
Consoneo\Bundle\UserBundle\Entity\QualificationRGE No errors.
Consoneo\Bundle\ObligeBundle\Entity\Program\Thermostat\AbstractThermostatItem No errors.
Consoneo\Bundle\ObligeBundle\Entity\Program\ProgramProduct No errors.
Consoneo\Bundle\WorkflowBundle\Entity\ProgramAutoConfig No errors.
Consoneo\Bundle\UserBundle\Entity\Precarite\Declarant No errors.
Consoneo\Bundle\ObligeBundle\Entity\CappingRuleHistory No errors.
Consoneo\Bundle\ObligeBundle\Entity\PaymentStepHistory No errors.
Consoneo\Bundle\UserBundle\Entity\InstallateurProfilClient No errors.
Consoneo\Bundle\UserBundle\Entity\InstallateurCompetence No errors.
C2eCoreBundle\Entity\Internal\Address No errors.
Consoneo\Bundle\ObligeBundle\Entity\CertificationChoice No errors.
Consoneo\Bundle\ObligeBundle\Entity\CertificationChoiceCertification No errors.
Consoneo\Bundle\FormGeneratorBundle\Form\Domain\Model\Location No errors.
Consoneo\Bundle\SimulateurBundle\Entity\DataQuestionFieldItem No errors.
Consoneo\Bundle\SimulateurBundle\Entity\DataQuestionFieldGroup No errors.
Consoneo\Bundle\SimulateurBundle\Entity\DataQuestionField No errors.
Consoneo\Bundle\SimulateurBundle\Entity\DataQuestionValidator No errors.
C2eCoreBundle\Entity\Engine\MatrixEntry No errors.
Consoneo\Bundle\ObligeBundle\Entity\OperationDocumentConfigObligeOverride No errors.
Consoneo\Bundle\ObligeBundle\Entity\Pricing No errors.
Consoneo\Bundle\ObligeBundle\Entity\EmailConfiguration No errors.
Consoneo\Bundle\ObligeBundle\Entity\EmailTrigger No errors.
Consoneo\Bundle\ObligeBundle\Entity\PaymentTrigger No errors.
Consoneo\Bundle\ObligeBundle\Entity\Brand No errors.
Consoneo\Bundle\ObligeBundle\Entity\Product\Catalog No errors.
Consoneo\Bundle\ObligeBundle\Entity\AlertAction No errors.
Consoneo\Bundle\WorkflowBundle\Entity\SignatureTransactionHistory No errors.
Consoneo\Bundle\ObligeBundle\Entity\CofracStepHistory No errors.
Consoneo\Bundle\FormGeneratorBundle\Form\Domain\Model\Tag No errors.

read entity manager

Class Mapping errors
Consoneo\Bundle\SimulateurBundle\Entity\ZoneClimatique No errors.
Consoneo\Bundle\ObligeBundle\Entity\Configuration No errors.
Consoneo\Bundle\UserBundle\Entity\Oblige No errors.
Consoneo\Bundle\ObligeBundle\Entity\OffreProjet No errors.
Consoneo\Bundle\ObligeBundle\Entity\Arrete No errors.
Consoneo\Bundle\ObligeBundle\Entity\MoteurInfoArrete No errors.
Consoneo\Bundle\FormGeneratorBundle\Form\Domain\Model\FormConfig No errors.
Consoneo\Bundle\SimulateurBundle\Entity\Operation No errors.
Consoneo\Bundle\ObligeBundle\Entity\AskUpdateStateOffreProjet No errors.
Consoneo\Bundle\ObligeBundle\Entity\OffreProjetState No errors.
Consoneo\Bundle\UserBundle\Entity\ObligeUser No errors.
Consoneo\Bundle\ObligeBundle\Entity\User\Program\Commercial No errors.
Consoneo\Bundle\ObligeBundle\Entity\PaymentMethodOblige No errors.
Consoneo\Bundle\ObligeBundle\Entity\User\Program\Manager No errors.
Consoneo\Bundle\ObligeBundle\Entity\Batch No errors.
Consoneo\Bundle\UserBundle\Entity\TeteReseau No errors.
Consoneo\Bundle\ObligeBundle\Entity\PricingGroup No errors.
Consoneo\Bundle\ObligeBundle\Entity\ObligeOperation No errors.
Consoneo\Bundle\ObligeBundle\Entity\ObligeBlockedTimetable No errors.
Consoneo\Bundle\WorkflowBundle\Entity\CoupDePouce No errors.
Consoneo\Bundle\ObligeBundle\Entity\Contract No errors.
Consoneo\Bundle\ObligeBundle\Entity\EmailConfigurationRecord No errors.
Consoneo\Bundle\ObligeBundle\Entity\ConfigurationPaymentRecord No errors.
Consoneo\Bundle\ObligeBundle\Entity\Mediateur No errors.
Consoneo\Bundle\ObligeBundle\Entity\MprConfig No errors.
Consoneo\Bundle\WorkflowBundle\Entity\ProgramAuto No errors.
Consoneo\Bundle\UserBundle\Entity\AffectationConsoneoRule No errors.
Consoneo\Bundle\ObligeBundle\Entity\CappingRule No errors.
Consoneo\Bundle\UserBundle\Entity\ObligeDocumentTypeConfig No errors.
Consoneo\Bundle\ObligeBundle\Entity\Product\Product No errors.
Consoneo\Bundle\ObligeBundle\Entity\PrestataireEffacement No errors.
Consoneo\Bundle\UserBundle\Entity\Mandataire No errors.
Consoneo\Bundle\UserBundle\Entity\EntrepriseUser No errors.
Consoneo\Bundle\UserBundle\Entity\InstallateurUser No errors.
Consoneo\Bundle\UserBundle\Entity\BeUser No errors.
Consoneo\Bundle\UserBundle\Entity\EntrepriseUserContact No errors.
Consoneo\Bundle\UserBundle\Entity\ParticulierUserContact No errors.
Consoneo\Bundle\UserBundle\Entity\SignataireEntreprise No errors.
Consoneo\Bundle\UserBundle\Entity\SignataireInstallateur No errors.
Consoneo\Bundle\UserBundle\Entity\InstallateurUserContact No errors.
Consoneo\Bundle\ObligeBundle\Entity\Projet No errors.
Consoneo\Bundle\SimulateurBundle\Entity\PrecariteCas2 No errors.
Consoneo\Bundle\ObligeBundle\Entity\Comment No errors.
Consoneo\Bundle\ObligeBundle\Entity\OffreProjetTag No errors.
Consoneo\Bundle\ObligeBundle\Entity\OffreProjetProduit No errors.
Consoneo\Bundle\ObligeBundle\Entity\Document No errors.
Consoneo\Bundle\ObligeBundle\Entity\DocumentStatic No errors.
Consoneo\Bundle\ObligeBundle\Entity\OffreProjetDocumentObligatoire No errors.
Consoneo\Bundle\ObligeBundle\Entity\OffreProjetAdditionalInformation No errors.
Consoneo\Bundle\WorkflowBundle\Entity\Email No errors.
Consoneo\Bundle\WorkflowBundle\Entity\Sms No errors.
Consoneo\Bundle\ObligeBundle\Entity\Precarite No errors.
Consoneo\Bundle\WorkflowBundle\Entity\AlertRecord No errors.
Consoneo\Bundle\ObligeBundle\Entity\OffreProjetValidation No errors.
Consoneo\Bundle\UserBundle\Entity\AffectationOffre No errors.
Consoneo\Bundle\WorkflowBundle\Entity\Horodatage No errors.
Consoneo\Bundle\ObligeBundle\Entity\Message No errors.
Consoneo\Bundle\SimulateurBundle\Entity\SecteurActivite No errors.
Consoneo\Bundle\ObligeBundle\Entity\FactureDetail No errors.
Consoneo\Bundle\ObligeBundle\Entity\Lead No errors.
Consoneo\Bundle\ObligeBundle\Entity\OffreProjetStatus No errors.
Consoneo\Bundle\UserBundle\Entity\Identite No errors.
Consoneo\Bundle\UserBundle\Entity\ParticulierUser No errors.
Consoneo\Bundle\UserBundle\Entity\QualificationRecord No errors.
Consoneo\Bundle\UserBundle\Entity\SousTraitantRGE No errors.
Consoneo\Bundle\ObligeBundle\Entity\OffreProjetMonitoring No errors.
Consoneo\Bundle\WorkflowBundle\Entity\Program No errors.
Consoneo\Bundle\ObligeBundle\Entity\Payment No errors.
Consoneo\Bundle\ObligeBundle\Entity\OperationRecord No errors.
Consoneo\Bundle\ObligeBundle\Entity\Program\StepHistory No errors.
Consoneo\Bundle\ObligeBundle\Entity\SignatureAuto No errors.
Consoneo\Bundle\ObligeBundle\Entity\WasteCenter No errors.
Consoneo\Bundle\ObligeBundle\Entity\Waste No errors.
Consoneo\Bundle\ObligeBundle\Entity\Control No errors.
Consoneo\Bundle\UserBundle\Entity\Precarite\Justificatif No errors.
Consoneo\Bundle\WorkflowBundle\Entity\OffreProjetProgramAutoData No errors.
Consoneo\Bundle\ObligeBundle\Entity\CofracDocument No errors.
Consoneo\Bundle\ObligeBundle\Entity\ControlMonitoringHistory No errors.
Consoneo\Bundle\ObligeBundle\Entity\PaymentMpr No errors.
Consoneo\Bundle\ObligeBundle\Entity\JustificatifPerformanceEnergetique No errors.
Consoneo\Bundle\UserBundle\Entity\ProjectOwner No errors.
C2eCoreBundle\Entity\Internal\ProjectBundle No errors.
C2eCoreBundle\Entity\Internal\Estate No errors.
Consoneo\Bundle\ObligeBundle\Entity\Recensement No errors.
Consoneo\Bundle\FormGeneratorBundle\Form\Domain\Model\Location No errors.
Consoneo\Bundle\SimulateurBundle\Entity\Simulateur No errors.
Consoneo\Bundle\ObligeBundle\Entity\Certification No errors.
Consoneo\Bundle\UserBundle\Entity\Qualification No errors.
Consoneo\Bundle\SimulateurBundle\Entity\OperationQuestionItem No errors.
Consoneo\Bundle\SimulateurBundle\Entity\DataQuestion No errors.
Consoneo\Bundle\ObligeBundle\Entity\DocumentType No errors.
Consoneo\Bundle\UserBundle\Entity\DomaineTravauxRGE No errors.
Consoneo\Bundle\UserBundle\Entity\Installateur No errors.
Consoneo\Bundle\UserBundle\Entity\Be No errors.
Consoneo\Bundle\ObligeBundle\Entity\Program\Isolant No errors.
C2eCoreBundle\Entity\Internal\ProjectBundleOperation No errors.
C2eCoreBundle\Entity\Engine\ConstraintRule No errors.
C2eCoreBundle\Entity\Engine\MatrixDefinition No errors.
C2eCoreBundle\Entity\Engine\Formula No errors.
Consoneo\Bundle\ObligeBundle\Entity\OperationDocumentConfig No errors.
Consoneo\Bundle\ObligeBundle\Entity\Campagne No errors.
Consoneo\Bundle\ObligeBundle\Entity\IntegrationModule No errors.
Consoneo\Bundle\ObligeBundle\Entity\Reminder No errors.
Consoneo\Bundle\ObligeBundle\Entity\StatRecord No errors.
Consoneo\Bundle\UserBundle\Entity\AffectationUser No errors.
Consoneo\Bundle\UserBundle\Entity\RegleRole No errors.
Consoneo\Bundle\ObligeBundle\Entity\ControlStepHistory No errors.
Consoneo\Bundle\ObligeBundle\Entity\PaymentMethod No errors.
Consoneo\Bundle\ObligeBundle\Entity\CampagneUser No errors.
Consoneo\Bundle\ObligeBundle\Entity\BatchStateHistory No errors.
Consoneo\Bundle\ObligeBundle\Entity\SampleCofracOperation No errors.
Consoneo\Bundle\ObligeBundle\Entity\OrganismeControl No errors.
Consoneo\Bundle\ObligeBundle\Entity\Cofrac No errors.
Consoneo\Bundle\UserBundle\Entity\ApplicationFees No errors.
Consoneo\Bundle\ObligeBundle\Entity\Pricing No errors.
Consoneo\Bundle\ObligeBundle\Entity\EmailConfiguration No errors.
Consoneo\Bundle\ObligeBundle\Entity\EmailTrigger No errors.
Consoneo\Bundle\WorkflowBundle\Entity\Workflow No errors.
Consoneo\Bundle\ObligeBundle\Entity\PaymentTrigger No errors.
Consoneo\Bundle\WorkflowBundle\Entity\ProgramAutoConfig No errors.
Consoneo\Bundle\ObligeBundle\Entity\CappingRuleHistory No errors.
Consoneo\Bundle\ObligeBundle\Entity\Brand No errors.
Consoneo\Bundle\ObligeBundle\Entity\Product\Catalog No errors.
Consoneo\Bundle\ObligeBundle\Entity\Program\ProgramProduct No errors.
Consoneo\Bundle\UserBundle\Entity\Entreprise No errors.
Consoneo\Bundle\UserBundle\Entity\UserDocumentObligatoire No errors.
Consoneo\Bundle\UserBundle\Entity\InstallateurDocumentReference No errors.
Consoneo\Bundle\UserBundle\Entity\EtudeMultiOp No errors.
Consoneo\Bundle\WorkflowBundle\Entity\InstallateurUserProgram No errors.
Consoneo\Bundle\UserBundle\Entity\EntrepriseContact No errors.
Consoneo\Bundle\UserBundle\Entity\Precarite\Cas1 No errors.
Consoneo\Bundle\UserBundle\Entity\InstallateurContact No errors.
Consoneo\Bundle\ObligeBundle\Entity\MPRMonitoring No errors.
Consoneo\Bundle\ObligeBundle\Entity\CertificationChoice No errors.
Consoneo\Bundle\WorkflowBundle\Entity\SignatureRequest No errors.
Consoneo\Bundle\ObligeBundle\Entity\Position\Geolocalisation No errors.
Consoneo\Bundle\ObligeBundle\Entity\UploadedDocument No errors.
C2eCoreBundle\Entity\Certificall\Certilink No errors.
Consoneo\Bundle\WorkflowBundle\Entity\EmailHistory No errors.
Consoneo\Bundle\ObligeBundle\Entity\BatchBankTransfer No errors.
Consoneo\Bundle\ObligeBundle\Entity\Alert No errors.
Consoneo\Bundle\ObligeBundle\Entity\RefuseOffreProjet No errors.
Consoneo\Bundle\WorkflowBundle\Entity\AlertRecordJournal No errors.
Consoneo\Bundle\UserBundle\Entity\ObligeRole No errors.
Consoneo\Bundle\SimulateurBundle\Entity\Categorie No errors.
Consoneo\Bundle\UserBundle\Entity\QualificationRGE No errors.
Consoneo\Bundle\ObligeBundle\Entity\Program\Thermostat\AbstractThermostatItem No errors.
Consoneo\Bundle\ObligeBundle\Entity\PaymentStepHistory No errors.
Consoneo\Bundle\UserBundle\Entity\Precarite\Declarant No errors.
C2eCoreBundle\Entity\Internal\Address No errors.
Consoneo\Bundle\FormGeneratorBundle\Form\Domain\Model\Tag No errors.
Consoneo\Bundle\SimulateurBundle\Entity\Secteur No errors.
Consoneo\Bundle\SimulateurBundle\Entity\TypeOperation No errors.
Consoneo\Bundle\SimulateurBundle\Entity\OperationSpecifique No errors.
Consoneo\Bundle\ObligeBundle\Entity\CertificationChoiceCertification No errors.
Consoneo\Bundle\SimulateurBundle\Entity\DataQuestionFieldItem No errors.
Consoneo\Bundle\SimulateurBundle\Entity\DataQuestionFieldGroup No errors.
Consoneo\Bundle\SimulateurBundle\Entity\DataQuestionField No errors.
Consoneo\Bundle\SimulateurBundle\Entity\DataQuestionValidator No errors.
Consoneo\Bundle\UserBundle\Entity\InstallateurProfilClient No errors.
Consoneo\Bundle\UserBundle\Entity\InstallateurCompetence No errors.
Consoneo\Bundle\UserBundle\Entity\InstallateurCertificallConfig No errors.
C2eCoreBundle\Entity\Engine\MatrixEntry No errors.
Consoneo\Bundle\ObligeBundle\Entity\OperationDocumentConfigObligeOverride No errors.
Consoneo\Bundle\ObligeBundle\Entity\CampagneBurnCode No errors.
Consoneo\Bundle\ObligeBundle\Entity\CampagneDistribution No errors.
Consoneo\Bundle\ObligeBundle\Entity\CampagneKpi No errors.
Consoneo\Bundle\WorkflowBundle\Entity\Branding No errors.
Consoneo\Bundle\ObligeBundle\Entity\Stat No errors.
Consoneo\Bundle\ObligeBundle\Entity\SampleCofracStepHistory No errors.
Consoneo\Bundle\ObligeBundle\Entity\CofracStepHistory No errors.
Consoneo\Bundle\WorkflowBundle\Entity\SignatureTransactionHistory No errors.
C2eCoreBundle\Entity\Certificall\CertilinkItem No errors.
Consoneo\Bundle\ObligeBundle\Entity\AlertAction No errors.

stats entity manager

No loaded entities.

qrdecode entity manager

Class Mapping errors
C2eCoreBundle\Entity\DocumentQrDecode No errors.