Query Metrics
37
Database Queries
30
Different statements
85.95 ms
Query time
0
Invalid entities
101
Managed entities
0
Cache hits
0
Cache misses
0
Cache puts
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
11.96 ms (13.91%) |
1 |
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 Operation_DomaineTravaux ON t0.id = Operation_DomaineTravaux.domaineTravaux_id WHERE Operation_DomaineTravaux.operation_id = ?
Parameters:
[
871
]
|
|
10.98 ms (12.77%) |
2 |
SELECT t0.id AS id_1, t0.appKey AS appKey_2, t0.label AS label_3, t0.description AS description_4, t0.url AS url_5, t0.status AS status_6, t0.created_at AS created_at_7, t0.report_auto_email AS report_auto_email_8, t0.logo AS logo_9, t0.smartName AS smartName_10, t0.prefixEmail AS prefixEmail_11, t0.`lead` AS lead_12, t0.`leadUrl` AS leadUrl_13, t0.`leadLogin` AS leadLogin_14, t0.`leadPassword` AS leadPassword_15, t0.recommanderProDefault AS recommanderProDefault_16, t0.actif AS actif_17, t0.allowMultiSubscription AS allowMultiSubscription_18, t0.teteReseau_id AS teteReseau_id_19, t0.branding AS branding_20 FROM IntegrationModule t0 WHERE t0.appKey = ? LIMIT 1
Parameters:
[
"Tjp3"
]
|
|
8.73 ms (10.16%) |
1 |
SELECT t0.id AS id_1, t0.nbFoyerFiscal AS nbFoyerFiscal_2, t0.codePostal AS codePostal_3, t0.situation AS situation_4, t0.createdAt AS createdAt_5, t0.updatedAt AS updatedAt_6, t7.id AS id_8, t7.username_canonical AS username_canonical_9, t7.email AS email_10, t7.email_canonical AS email_canonical_11, t7.enabled AS enabled_12, t7.salt AS salt_13, t7.password AS password_14, t7.last_login AS last_login_15, t7.confirmation_token AS confirmation_token_16, t7.password_requested_at AS password_requested_at_17, t7.roles AS roles_18, t7.username AS username_19, t7.nom AS nom_20, t7.prenom AS prenom_21, t7.fonction AS fonction_22, t7.tel AS tel_23, t7.mobile AS mobile_24, t7.activation AS activation_25, t7.createdAt AS createdAt_26, t7.updatedAt AS updatedAt_27, t7.optin AS optin_28, t7.dateActivation AS dateActivation_29, t7.emailValidatedDateTime AS emailValidatedDateTime_30, t7.emailCreatedDateTime AS emailCreatedDateTime_31, t7.mobileCreatedDatetime AS mobileCreatedDatetime_32, t7.sendEmail AS sendEmail_33, t7.adresse AS adresse_34, t7.adresse_complement AS adresse_complement_35, t7.codepostal AS codepostal_36, t7.ville AS ville_37, t7.token AS token_38, t7.emailRequested AS emailRequested_39, t7.emailRequestedDate AS emailRequestedDate_40, t7.inscriptionFromDemandeOffre AS inscriptionFromDemandeOffre_41, t7.lastOffreDate AS lastOffreDate_42, t7.tag AS tag_43, t7.cdiscountGuid AS cdiscountGuid_44, t7.cdiscountCdav AS cdiscountCdav_45, t7.gender AS gender_46, t7.exclusiveEnabled AS exclusiveEnabled_47, t7.relanceSmsRegistration AS relanceSmsRegistration_48, t7.dateRelanceSmsRegistration AS dateRelanceSmsRegistration_49, t7.workflow_id AS workflow_id_50, t7.cas1_id AS cas1_id_51, t7.identite_id AS identite_id_52, t7.integrationModule_id AS integrationModule_id_53, t54.id AS id_55, t54.username_canonical AS username_canonical_56, t54.email_canonical AS email_canonical_57, t54.enabled AS enabled_58, t54.salt AS salt_59, t54.password AS password_60, t54.last_login AS last_login_61, t54.confirmation_token AS confirmation_token_62, t54.password_requested_at AS password_requested_at_63, t54.roles AS roles_64, t54.nom AS nom_65, t54.prenom AS prenom_66, t54.fonction AS fonction_67, t54.tel AS tel_68, t54.mobile AS mobile_69, t54.activation AS activation_70, t54.createdAt AS createdAt_71, t54.updatedAt AS updatedAt_72, t54.optin AS optin_73, t54.dateActivation AS dateActivation_74, t54.emailValidatedDateTime AS emailValidatedDateTime_75, t54.emailCreatedDateTime AS emailCreatedDateTime_76, t54.mobileCreatedDatetime AS mobileCreatedDatetime_77, t54.sendEmail AS sendEmail_78, t54.dateEnvoiGuide AS dateEnvoiGuide_79, t54.token AS token_80, t54.emailJustificatifPreca AS emailJustificatifPreca_81, t54.adresse AS adresse_82, t54.adresse_complement AS adresse_complement_83, t54.codepostal AS codepostal_84, t54.ville AS ville_85, t54.formPrecaResponse AS formPrecaResponse_86, t54.gender AS gender_87, t54.stampFilename AS stampFilename_88, t54.email AS email_89, t54.username AS username_90, t54.cas1_id AS cas1_id_91, t54.identite_id AS identite_id_92, t54.integrationModule_id AS integrationModule_id_93, t94.id AS id_95, t94.activation AS activation_96, t94.step AS step_97, t94.prenom AS prenom_98, t94.nom AS nom_99, t94.tel AS tel_100, t94.mobile AS mobile_101, t94.username AS username_102, t94.logement AS logement_103, t94.adresse AS adresse_104, t94.adresseComplement AS adresseComplement_105, t94.codePostal AS codePostal_106, t94.ville AS ville_107, t94.proprietaire AS proprietaire_108, t94.energieChauffage AS energieChauffage_109, t94.token AS token_110, t94.confirmationToken AS confirmationToken_111, t94.optin AS optin_112, t94.optinSms AS optinSms_113, t94.emailValidatedDateTime AS emailValidatedDateTime_114, t94.created AS created_115, t94.reference AS reference_116, t94.ahIua AS ahIua_117, t94.idCardIua AS idCardIua_118, t94.signatureIua AS signatureIua_119, t94.lettreEngagementIua AS lettreEngagementIua_120, t94.preuveRetraitIua AS preuveRetraitIua_121, t94.preuveRetraitIuaFail AS preuveRetraitIuaFail_122, t94.bonLivraisonIua AS bonLivraisonIua_123, t94.bonLivraisonIuaFail AS bonLivraisonIuaFail_124, t94.preuveDistributionIua AS preuveDistributionIua_125, t94.lettreRefus AS lettreRefus_126, t94.lettreEngagement AS lettreEngagement_127, t94.codeSms1Iua AS codeSms1Iua_128, t94.codeSms2Iua AS codeSms2Iua_129, t94.codeSmsRecover1Iua AS codeSmsRecover1Iua_130, t94.codeSmsRecover2Iua AS codeSmsRecover2Iua_131, t94.nbCodeSmsRecover AS nbCodeSmsRecover_132, t94.nbCodeSmsSign AS nbCodeSmsSign_133, t94.nbEmailOptin AS nbEmailOptin_134, t94.ahSignedClientIua AS ahSignedClientIua_135, t94.ahSignedProIua AS ahSignedProIua_136, t94.dateSignatureClient AS dateSignatureClient_137, t94.dateSignaturePro AS dateSignaturePro_138, t94.dateBonLivraison AS dateBonLivraison_139, t94.echec AS echec_140, t94.operateurDeviceType AS operateurDeviceType_141, t94.dateValidationOperateur AS dateValidationOperateur_142, t94.askDeletion AS askDeletion_143, t94.reason AS reason_144, t94.askDeletionDate AS askDeletionDate_145, t94.backup AS backup_146, t94.choosenCap AS choosenCap_147, t94.campagne_id AS campagne_id_148, t94.batch_id AS batch_id_149, t94.cas1_id AS cas1_id_150, t94.askDeletionObligeUser_id AS askDeletionObligeUser_id_151, t94.identite_id AS identite_id_152 FROM Cas1 t0 LEFT JOIN ParticulierUser t7 ON t7.cas1_id = t0.id LEFT JOIN ParticulierUserContact t54 ON t54.cas1_id = t0.id LEFT JOIN CampagneUser t94 ON t94.cas1_id = t0.id WHERE t0.id = ?
Parameters:
[
397969
]
|
|
5.04 ms (5.86%) |
1 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.reference AS reference_3, t0.offre_cumac AS offre_cumac_4, t0.offre_cumac_precarite AS offre_cumac_precarite_5, t0.offre_cumac_client AS offre_cumac_client_6, t0.offre_cumac_client_precarite AS offre_cumac_client_precarite_7, t0.cumac AS cumac_8, t0.total_prime AS total_prime_9, t0.cumac_moyenne AS cumac_moyenne_10, t0.taux_actualise AS taux_actualise_11, t0.taux_accumule AS taux_accumule_12, t0.data AS data_13, t0.ip AS ip_14, t0.created_datetime AS created_datetime_15, t0.prime_pro AS prime_pro_16, t0.prime_client AS prime_client_17, t0.raison AS raison_18, t0.codepostal AS codepostal_19, t0.adresse AS adresse_20, t0.adresse_complement AS adresse_complement_21, t0.ville AS ville_22, t0.delai_souhaite AS delai_souhaite_23, t0.accept_recevoir_offre AS accept_recevoir_offre_24, t0.accept_recommandation AS accept_recommandation_25, t0.status AS status_26, t0.zone AS zone_27, t0.devisValue AS devisValue_28, t0.addressSituation AS addressSituation_29, t0.programStep AS programStep_30, t0.createdAt AS createdAt_31, t0.updatedAt AS updatedAt_32, t0.engineDocumentId AS engineDocumentId_33, t0.simulateur_id AS simulateur_id_34, t35.id AS id_36, t35.reference AS reference_37, t35.nom AS nom_38, t35.nom_cd AS nom_cd_39, t35.cdiscount AS cdiscount_40, t35.pretty_name AS pretty_name_41, t35.status AS status_42, t35.slug AS slug_43, t35.form_lead_id AS form_lead_id_44, t35.active_operation_id AS active_operation_id_45, t35.secteur_id AS secteur_id_46, t35.categorie_id AS categorie_id_47, t35.categorieCd_id AS categorieCd_id_48, t35.type_operation_id AS type_operation_id_49, t35.operation_specifique_id AS operation_specifique_id_50, t0.operation_id AS operation_id_51, t52.id AS id_53, t52.nom AS nom_54, t52.version AS version_55, t52.code AS code_56, t52.duree AS duree_57, t52.auto_installation AS auto_installation_58, t52.conditions AS conditions_59, t52.conditionsRaw AS conditionsRaw_60, t52.conditionsFormater AS conditionsFormater_61, t52.documents_requis AS documents_requis_62, t52.nombre_documents AS nombre_documents_63, t52.nombre_conditions AS nombre_conditions_64, t52.question_details_type AS question_details_type_65, t52.question_details_value AS question_details_value_66, t52.periode AS periode_67, t52.informationTechnique AS informationTechnique_68, t52.informationTechniqueRaw AS informationTechniqueRaw_69, t52.informationTechniqueFormater AS informationTechniqueFormater_70, t52.informationDocSupplementaire AS informationDocSupplementaire_71, t52.informationDocSupplementaireRaw AS informationDocSupplementaireRaw_72, t52.informationDocSupplementaireFormater AS informationDocSupplementaireFormater_73, t52.informationfacture AS informationfacture_74, t52.informationfactureRaw AS informationfactureRaw_75, t52.informationfactureFormater AS informationfactureFormater_76, t52.informationfacture2 AS informationfacture2_77, t52.informationfacture2Raw AS informationfacture2Raw_78, t52.informationfacture2Formater AS informationfacture2Formater_79, t52.nbMateriau AS nbMateriau_80, t52.materiauSubtitle AS materiauSubtitle_81, t52.materiauTitle AS materiauTitle_82, t52.textForm AS textForm_83, t52.private AS private_84, t52.campagne AS campagne_85, t52.special AS special_86, t52.abrogation_datetime AS abrogation_datetime_87, t52.end_zni_date AS end_zni_date_88, t52.globalConfigurationHash AS globalConfigurationHash_89, t52.zni AS zni_90, t52.cdp_eligible AS cdp_eligible_91, t52.simulateur_id AS simulateur_id_92, t52.arrete_id AS arrete_id_93, t52.certification_id AS certification_id_94, t52.qualification_id AS qualification_id_95, t52.formConfigEngine_id AS formConfigEngine_id_96, t0.entrepriseUser_id AS entrepriseUser_id_97, t0.particulierUser_id AS particulierUser_id_98, t0.installateurUser_id AS installateurUser_id_99, t0.beUser_id AS beUser_id_100, t101.id AS id_102, t101.type AS type_103, t101.pricingType AS pricingType_104, t101.finalisationRequested AS finalisationRequested_105, t101.finalisationRequestDate AS finalisationRequestDate_106, t101.reference AS reference_107, t101.data AS data_108, t101.cofracData AS cofracData_109, t101.ip AS ip_110, t101.offre_auto_date AS offre_auto_date_111, t101.created_datetime AS created_datetime_112, t101.updated_datetime AS updated_datetime_113, t101.tel AS tel_114, t101.codepostal AS codepostal_115, t101.adresse AS adresse_116, t101.adresse_complement AS adresse_complement_117, t101.ville AS ville_118, t101.delai_souhaite AS delai_souhaite_119, t101.accept_recevoir_offre AS accept_recevoir_offre_120, t101.accept_recommandation AS accept_recommandation_121, t101.acceptLeadPromo AS acceptLeadPromo_122, t101.offre_cumac AS offre_cumac_123, t101.offre_cumac_client AS offre_cumac_client_124, t101.offre_cumac_precarite AS offre_cumac_precarite_125, t101.offre_cumac_client_precarite AS offre_cumac_client_precarite_126, t101.cumac AS cumac_127, t101.cumac_AFT AS cumac_AFT_128, t101.total_prime AS total_prime_129, t101.total_prime_AFT AS total_prime_AFT_130, t101.prime_pro AS prime_pro_131, t101.prime_pro_aft AS prime_pro_aft_132, t101.prime_client AS prime_client_133, t101.prime_client_aft AS prime_client_aft_134, t101.cumac_moyenne AS cumac_moyenne_135, t101.taux_actualise AS taux_actualise_136, t101.taux_accumule AS taux_accumule_137, t101.date_debut_chantier AS date_debut_chantier_138, t101.date_demande_offre AS date_demande_offre_139, t101.date_fin_chantier AS date_fin_chantier_140, t101.etat AS etat_141, t101.status AS status_142, t101.date_offre AS date_offre_143, t101.notification_date_chantier AS notification_date_chantier_144, t101.date_retour_conv AS date_retour_conv_145, t101.date_validation_conv AS date_validation_conv_146, t101.date_chantier_renseigne AS date_chantier_renseigne_147, t101.date_paiement AS date_paiement_148, t101.date_all_doc_valid AS date_all_doc_valid_149, t101.date_fin_chantier_repousse AS date_fin_chantier_repousse_150, t101.date_envoi_questionnaire AS date_envoi_questionnaire_151, t101.date_edition_questionnaire AS date_edition_questionnaire_152, t101.date_validation_final AS date_validation_final_153, t101.date_annulation AS date_annulation_154, t101.no_click_email_date_chantier AS no_click_email_date_chantier_155, t101.token AS token_156, t101.auto_installation AS auto_installation_157, t101.siret AS siret_158, t101.cancelReason AS cancelReason_159, t101.dateCommande AS dateCommande_160, t101.siteTravaux AS siteTravaux_161, t101.incitation AS incitation_162, t101.qualificationRecordDate AS qualificationRecordDate_163, t101.serviceType AS serviceType_164, t101.debutChantier AS debutChantier_165, t101.finChantier AS finChantier_166, t101.initiateCDP AS initiateCDP_167, t101.cdp AS cdp_168, t101.date_last_envoi_convention AS date_last_envoi_convention_169, t101.programStep AS programStep_170, t101.devisRestAPayer AS devisRestAPayer_171, t101.pricingMandatClassique AS pricingMandatClassique_172, t101.pricingMandatPreca AS pricingMandatPreca_173, t101.isCOFRAC AS isCOFRAC_174, t101.applicationFeesPrice AS applicationFeesPrice_175, t101.attributes AS attributes_176, t101.exclusive AS exclusive_177, t101.engineDocumentId AS engineDocumentId_178, t101.batchOffreProjet_id AS batchOffreProjet_id_179, t101.entrepriseUser_id AS entrepriseUser_id_180, t101.installateurUser_id AS installateurUser_id_181, t101.beUser_id AS beUser_id_182, t101.entrepriseUserContact_id AS entrepriseUserContact_id_183, t101.particulierUserContact_id AS particulierUserContact_id_184, t101.signataireEntreprise_id AS signataireEntreprise_id_185, t101.signataireInstallateur_id AS signataireInstallateur_id_186, t101.installateurUserContact_id AS installateurUserContact_id_187, t101.projet_id AS projet_id_188, t101.precariteCas2_id AS precariteCas2_id_189, t101.precarite_id AS precarite_id_190, t101.state_id AS state_id_191, t101.oblige_id AS oblige_id_192, t101.secteurActivite_id AS secteurActivite_id_193, t101.factureDetail_id AS factureDetail_id_194, t101.offreStatus_id AS offreStatus_id_195, t101.identiteBeneficiaire_id AS identiteBeneficiaire_id_196, t101.identiteInstallateur_id AS identiteInstallateur_id_197, t101.operation_id AS operation_id_198, t101.particulierUser_id AS particulierUser_id_199, t101.qualificationRecord_id AS qualificationRecord_id_200, t101.sousTraitant_id AS sousTraitant_id_201, t101.program_id AS program_id_202, t101.programCommercial_id AS programCommercial_id_203, t101.programManager_id AS programManager_id_204, t101.signatureAuto_id AS signatureAuto_id_205, t101.wasteCenter_id AS wasteCenter_id_206, t101.waste_id AS waste_id_207, t101.programAuto_id AS programAuto_id_208, t101.justificatif_id AS justificatif_id_209, t101.cappingRule_id AS cappingRule_id_210, t101.projectOwner_id AS projectOwner_id_211, t101.project_bundle_id AS project_bundle_id_212, t101.estate_id AS estate_id_213, t0.precarite_id AS precarite_id_214, t0.secteurActivite_id AS secteurActivite_id_215, t0.integrationModule_id AS integrationModule_id_216, t0.precariteCas2_id AS precariteCas2_id_217, t0.program_id AS program_id_218, t0.programCommercial_id AS programCommercial_id_219, t0.programManager_id AS programManager_id_220, t0.justificatif_id AS justificatif_id_221, t222.id AS id_223, t222.numero AS numero_224, t222.dateRealisation AS dateRealisation_225, t222.dateFinValidite AS dateFinValidite_226, t222.etiquetteBilan AS etiquetteBilan_227, t222.createdAt AS createdAt_228, t222.updatedAt AS updatedAt_229, t222.typeJustificatif AS typeJustificatif_230, t222.projet_id AS projet_id_231, t222.offreProjet_id AS offreProjet_id_232, t0.project_bundle_id AS project_bundle_id_233, t0.estate_id AS estate_id_234 FROM Projet t0 LEFT JOIN Simulateur t35 ON t0.simulateur_id = t35.id LEFT JOIN Operation t52 ON t0.operation_id = t52.id LEFT JOIN OffreProjet t101 ON t101.projet_id = t0.id LEFT JOIN JustificatifPerformanceEnergetique t222 ON t222.projet_id = t0.id WHERE t0.id = ?
Parameters:
[
1716303
]
|
|
4.22 ms (4.91%) |
2 |
SELECT j0_.id AS id_0, j0_.token AS token_1, j0_.type AS type_2, j0_.source AS source_3, j0_.choice AS choice_4, j0_.declared_year AS declared_year_5, j0_.declared_tax_income AS declared_tax_income_6, j0_.nb_people_declared AS nb_people_declared_7, j0_.tax_year AS tax_year_8, j0_.address AS address_9, j0_.zip_code AS zip_code_10, j0_.city AS city_11, j0_.country AS country_12, j0_.nb_dependents AS nb_dependents_13, j0_.reference_tax_income AS reference_tax_income_14, j0_.address_supplement AS address_supplement_15, j0_.doc_iua AS doc_iua_16, j0_.createdAt AS createdAt_17, j0_.updatedAt AS updatedAt_18, j0_.cas1_id AS cas1_id_19, j0_.main_declarant_id AS main_declarant_id_20, j0_.secondAvis_id AS secondAvis_id_21, j0_.campagneUser_id AS campagneUser_id_22 FROM Justificatif j0_ INNER JOIN Cas1 c1_ ON j0_.cas1_id = c1_.id WHERE c1_.id = ? AND ((j0_.tax_year IS NOT NULL AND j0_.tax_year IN (2025, 2026)) OR (j0_.declared_year IS NOT NULL AND j0_.declared_year IN (2025, 2026))) ORDER BY j0_.tax_year DESC, j0_.declared_year DESC, j0_.createdAt DESC
Parameters:
[
397969
]
|
|
4.21 ms (4.89%) |
2 |
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.reference AS reference_6, t0.data AS data_7, t0.cofracData AS cofracData_8, t0.ip AS ip_9, t0.offre_auto_date AS offre_auto_date_10, t0.created_datetime AS created_datetime_11, t0.updated_datetime AS updated_datetime_12, t0.tel AS tel_13, t0.codepostal AS codepostal_14, t0.adresse AS adresse_15, t0.adresse_complement AS adresse_complement_16, t0.ville AS ville_17, t0.delai_souhaite AS delai_souhaite_18, t0.accept_recevoir_offre AS accept_recevoir_offre_19, t0.accept_recommandation AS accept_recommandation_20, t0.acceptLeadPromo AS acceptLeadPromo_21, t0.offre_cumac AS offre_cumac_22, t0.offre_cumac_client AS offre_cumac_client_23, t0.offre_cumac_precarite AS offre_cumac_precarite_24, t0.offre_cumac_client_precarite AS offre_cumac_client_precarite_25, t0.cumac AS cumac_26, t0.cumac_AFT AS cumac_AFT_27, t0.total_prime AS total_prime_28, t0.total_prime_AFT AS total_prime_AFT_29, t0.prime_pro AS prime_pro_30, t0.prime_pro_aft AS prime_pro_aft_31, t0.prime_client AS prime_client_32, t0.prime_client_aft AS prime_client_aft_33, t0.cumac_moyenne AS cumac_moyenne_34, t0.taux_actualise AS taux_actualise_35, t0.taux_accumule AS taux_accumule_36, t0.date_debut_chantier AS date_debut_chantier_37, t0.date_demande_offre AS date_demande_offre_38, t0.date_fin_chantier AS date_fin_chantier_39, t0.etat AS etat_40, t0.status AS status_41, t0.date_offre AS date_offre_42, t0.notification_date_chantier AS notification_date_chantier_43, t0.date_retour_conv AS date_retour_conv_44, t0.date_validation_conv AS date_validation_conv_45, t0.date_chantier_renseigne AS date_chantier_renseigne_46, t0.date_paiement AS date_paiement_47, t0.date_all_doc_valid AS date_all_doc_valid_48, t0.date_fin_chantier_repousse AS date_fin_chantier_repousse_49, t0.date_envoi_questionnaire AS date_envoi_questionnaire_50, t0.date_edition_questionnaire AS date_edition_questionnaire_51, t0.date_validation_final AS date_validation_final_52, t0.date_annulation AS date_annulation_53, t0.no_click_email_date_chantier AS no_click_email_date_chantier_54, t0.token AS token_55, t0.auto_installation AS auto_installation_56, t0.siret AS siret_57, t0.cancelReason AS cancelReason_58, t0.dateCommande AS dateCommande_59, t0.siteTravaux AS siteTravaux_60, t0.incitation AS incitation_61, t0.qualificationRecordDate AS qualificationRecordDate_62, t0.serviceType AS serviceType_63, t0.debutChantier AS debutChantier_64, t0.finChantier AS finChantier_65, t0.initiateCDP AS initiateCDP_66, t0.cdp AS cdp_67, t0.date_last_envoi_convention AS date_last_envoi_convention_68, t0.programStep AS programStep_69, t0.devisRestAPayer AS devisRestAPayer_70, t0.pricingMandatClassique AS pricingMandatClassique_71, t0.pricingMandatPreca AS pricingMandatPreca_72, t0.isCOFRAC AS isCOFRAC_73, t0.applicationFeesPrice AS applicationFeesPrice_74, t0.attributes AS attributes_75, t0.exclusive AS exclusive_76, t0.engineDocumentId AS engineDocumentId_77, t0.batchOffreProjet_id AS batchOffreProjet_id_78, t0.entrepriseUser_id AS entrepriseUser_id_79, t0.installateurUser_id AS installateurUser_id_80, t0.beUser_id AS beUser_id_81, t0.entrepriseUserContact_id AS entrepriseUserContact_id_82, t0.particulierUserContact_id AS particulierUserContact_id_83, t0.signataireEntreprise_id AS signataireEntreprise_id_84, t0.signataireInstallateur_id AS signataireInstallateur_id_85, t0.installateurUserContact_id AS installateurUserContact_id_86, t0.projet_id AS projet_id_87, t0.precariteCas2_id AS precariteCas2_id_88, t0.precarite_id AS precarite_id_89, t0.state_id AS state_id_90, t91.id AS id_92, t91.created_datetime AS created_datetime_93, t91.convention AS convention_94, t91.aft AS aft_95, t91.facture AS facture_96, t91.beneficiaire AS beneficiaire_97, t91.installateur AS installateur_98, t91.doc_obligatoire AS doc_obligatoire_99, t91.coherence_dossier AS coherence_dossier_100, t91.offre_id AS offre_id_101, t0.oblige_id AS oblige_id_102, t0.secteurActivite_id AS secteurActivite_id_103, t0.factureDetail_id AS factureDetail_id_104, t105.id AS id_106, t105.reference AS reference_107, t105.type AS type_108, t105.result AS result_109, t105.errors AS errors_110, t105.message AS message_111, t105.created_datetime AS created_datetime_112, t105.integrationModule_id AS integrationModule_id_113, t105.offre_id AS offre_id_114, t0.offreStatus_id AS offreStatus_id_115, t0.identiteBeneficiaire_id AS identiteBeneficiaire_id_116, t0.identiteInstallateur_id AS identiteInstallateur_id_117, t0.operation_id AS operation_id_118, t0.particulierUser_id AS particulierUser_id_119, t0.qualificationRecord_id AS qualificationRecord_id_120, t0.sousTraitant_id AS sousTraitant_id_121, t0.program_id AS program_id_122, t0.programCommercial_id AS programCommercial_id_123, t0.programManager_id AS programManager_id_124, t0.signatureAuto_id AS signatureAuto_id_125, t0.wasteCenter_id AS wasteCenter_id_126, t0.waste_id AS waste_id_127, t0.programAuto_id AS programAuto_id_128, t0.justificatif_id AS justificatif_id_129, t0.cappingRule_id AS cappingRule_id_130, t131.id AS id_132, t131.mprUuid AS mprUuid_133, t131.mprReference AS mprReference_134, t131.paymentDate AS paymentDate_135, t131.invoiceReference AS invoiceReference_136, t131.invoiceDate AS invoiceDate_137, t131.amount AS amount_138, t131.archive AS archive_139, t131.step AS step_140, t131.offreProjet_id AS offreProjet_id_141, t131.batchBankTransfer_id AS batchBankTransfer_id_142, t131.installateur_id AS installateur_id_143, t131.particulierUser_id AS particulierUser_id_144, t145.id AS id_146, t145.numero AS numero_147, t145.dateRealisation AS dateRealisation_148, t145.dateFinValidite AS dateFinValidite_149, t145.etiquetteBilan AS etiquetteBilan_150, t145.createdAt AS createdAt_151, t145.updatedAt AS updatedAt_152, t145.typeJustificatif AS typeJustificatif_153, t145.projet_id AS projet_id_154, t145.offreProjet_id AS offreProjet_id_155, t0.projectOwner_id AS projectOwner_id_156, t0.project_bundle_id AS project_bundle_id_157, t0.estate_id AS estate_id_158, t159.id AS id_160, t159.`value` AS value_161, t159.offreProjet_id AS offreProjet_id_162, t159.operation_id AS operation_id_163, t159.oblige_id AS oblige_id_164 FROM OffreProjet t0 LEFT JOIN OffreProjetValidation t91 ON t91.offre_id = t0.id LEFT JOIN `Lead` t105 ON t105.offre_id = t0.id LEFT JOIN PaymentMpr t131 ON t131.offreProjet_id = t0.id LEFT JOIN JustificatifPerformanceEnergetique t145 ON t145.offreProjet_id = t0.id LEFT JOIN Recensement t159 ON t159.offreProjet_id = t0.id WHERE t0.token = ? LIMIT 1
Parameters:
[
"rJQCEnl5IIkpeaQ4C8XkP2rOTpSLLimAVnFDVpYEt0Q"
]
|
|
4.19 ms (4.88%) |
1 |
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:
[
235450
]
|
|
3.66 ms (4.25%) |
4 |
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"
]
|
|
3.50 ms (4.07%) |
1 |
SELECT t0.id AS id_1, t0.montant_total_ttc AS montant_total_ttc_2, t0.montant_total_ht AS montant_total_ht_3, t0.montant_materiaux_ht AS montant_materiaux_ht_4, t0.montant_services_ht AS montant_services_ht_5, t0.montant_tva AS montant_tva_6, t0.facture_numero AS facture_numero_7, t0.created_datetime AS created_datetime_8, t0.dateEmission AS dateEmission_9, t10.dateSignatureConvention AS dateSignatureConvention_11, t10.dateSignatureAhClient AS dateSignatureAhClient_12, t10.dateSignatureAhPro AS dateSignatureAhPro_13, t10.dateSignatureFacture AS dateSignatureFacture_14, t10.datePrevisite AS datePrevisite_15, t10.noQrDecode AS noQrDecode_16, t10.id AS id_17, t10.originalName AS originalName_18, t10.optionalName AS optionalName_19, t10.valid AS valid_20, t10.process AS process_21, t10.decoded AS decoded_22, t10.disabled AS disabled_23, t10.path AS path_24, t10.validated_datetime AS validated_datetime_25, t10.processed_datetime AS processed_datetime_26, t10.created_datetime AS created_datetime_27, t10.updated_datetime AS updated_datetime_28, t10.signe AS signe_29, t10.lisible AS lisible_30, t10.electronic AS electronic_31, t10.thumbnail AS thumbnail_32, t10.reference AS reference_33, t10.stockage AS stockage_34, t10.iua AS iua_35, t10.safeId AS safeId_36, t10.serviceType AS serviceType_37, t10.secondJustificatif AS secondJustificatif_38, t10.imported AS imported_39, t10.dateEditionDevis AS dateEditionDevis_40, t10.ahProElectronic AS ahProElectronic_41, t10.signataireName AS signataireName_42, t10.signataireSurname AS signataireSurname_43, t10.dateEmission AS dateEmission_44, t10.expirationDate AS expirationDate_45, t10.sienna_id AS sienna_id_46, t10.offre_projets_group AS offre_projets_group_47, t10.type_id AS type_id_48, t10.offreProjet_id AS offreProjet_id_49, t10.installateurUser_id AS installateurUser_id_50, t10.justificatif_id AS justificatif_id_51, t10.jpe_id AS jpe_id_52, t10.obligeUser_id AS obligeUser_id_53, t10.obligeUserReal_id AS obligeUserReal_id_54, t10.factureDetail_id AS factureDetail_id_55, t10.contract_id AS contract_id_56, t10.geolocalisation_id AS geolocalisation_id_57, t10.sousTraitant_id AS sousTraitant_id_58, t10.certilink_id AS certilink_id_59, t60.id AS id_61, t60.type AS type_62, t60.pricingType AS pricingType_63, t60.finalisationRequested AS finalisationRequested_64, t60.finalisationRequestDate AS finalisationRequestDate_65, t60.reference AS reference_66, t60.data AS data_67, t60.cofracData AS cofracData_68, t60.ip AS ip_69, t60.offre_auto_date AS offre_auto_date_70, t60.created_datetime AS created_datetime_71, t60.updated_datetime AS updated_datetime_72, t60.tel AS tel_73, t60.codepostal AS codepostal_74, t60.adresse AS adresse_75, t60.adresse_complement AS adresse_complement_76, t60.ville AS ville_77, t60.delai_souhaite AS delai_souhaite_78, t60.accept_recevoir_offre AS accept_recevoir_offre_79, t60.accept_recommandation AS accept_recommandation_80, t60.acceptLeadPromo AS acceptLeadPromo_81, t60.offre_cumac AS offre_cumac_82, t60.offre_cumac_client AS offre_cumac_client_83, t60.offre_cumac_precarite AS offre_cumac_precarite_84, t60.offre_cumac_client_precarite AS offre_cumac_client_precarite_85, t60.cumac AS cumac_86, t60.cumac_AFT AS cumac_AFT_87, t60.total_prime AS total_prime_88, t60.total_prime_AFT AS total_prime_AFT_89, t60.prime_pro AS prime_pro_90, t60.prime_pro_aft AS prime_pro_aft_91, t60.prime_client AS prime_client_92, t60.prime_client_aft AS prime_client_aft_93, t60.cumac_moyenne AS cumac_moyenne_94, t60.taux_actualise AS taux_actualise_95, t60.taux_accumule AS taux_accumule_96, t60.date_debut_chantier AS date_debut_chantier_97, t60.date_demande_offre AS date_demande_offre_98, t60.date_fin_chantier AS date_fin_chantier_99, t60.etat AS etat_100, t60.status AS status_101, t60.date_offre AS date_offre_102, t60.notification_date_chantier AS notification_date_chantier_103, t60.date_retour_conv AS date_retour_conv_104, t60.date_validation_conv AS date_validation_conv_105, t60.date_chantier_renseigne AS date_chantier_renseigne_106, t60.date_paiement AS date_paiement_107, t60.date_all_doc_valid AS date_all_doc_valid_108, t60.date_fin_chantier_repousse AS date_fin_chantier_repousse_109, t60.date_envoi_questionnaire AS date_envoi_questionnaire_110, t60.date_edition_questionnaire AS date_edition_questionnaire_111, t60.date_validation_final AS date_validation_final_112, t60.date_annulation AS date_annulation_113, t60.no_click_email_date_chantier AS no_click_email_date_chantier_114, t60.token AS token_115, t60.auto_installation AS auto_installation_116, t60.siret AS siret_117, t60.cancelReason AS cancelReason_118, t60.dateCommande AS dateCommande_119, t60.siteTravaux AS siteTravaux_120, t60.incitation AS incitation_121, t60.qualificationRecordDate AS qualificationRecordDate_122, t60.serviceType AS serviceType_123, t60.debutChantier AS debutChantier_124, t60.finChantier AS finChantier_125, t60.initiateCDP AS initiateCDP_126, t60.cdp AS cdp_127, t60.date_last_envoi_convention AS date_last_envoi_convention_128, t60.programStep AS programStep_129, t60.devisRestAPayer AS devisRestAPayer_130, t60.pricingMandatClassique AS pricingMandatClassique_131, t60.pricingMandatPreca AS pricingMandatPreca_132, t60.isCOFRAC AS isCOFRAC_133, t60.applicationFeesPrice AS applicationFeesPrice_134, t60.attributes AS attributes_135, t60.exclusive AS exclusive_136, t60.engineDocumentId AS engineDocumentId_137, t60.batchOffreProjet_id AS batchOffreProjet_id_138, t60.entrepriseUser_id AS entrepriseUser_id_139, t60.installateurUser_id AS installateurUser_id_140, t60.beUser_id AS beUser_id_141, t60.entrepriseUserContact_id AS entrepriseUserContact_id_142, t60.particulierUserContact_id AS particulierUserContact_id_143, t60.signataireEntreprise_id AS signataireEntreprise_id_144, t60.signataireInstallateur_id AS signataireInstallateur_id_145, t60.installateurUserContact_id AS installateurUserContact_id_146, t60.projet_id AS projet_id_147, t60.precariteCas2_id AS precariteCas2_id_148, t60.precarite_id AS precarite_id_149, t60.state_id AS state_id_150, t60.oblige_id AS oblige_id_151, t60.secteurActivite_id AS secteurActivite_id_152, t60.factureDetail_id AS factureDetail_id_153, t60.offreStatus_id AS offreStatus_id_154, t60.identiteBeneficiaire_id AS identiteBeneficiaire_id_155, t60.identiteInstallateur_id AS identiteInstallateur_id_156, t60.operation_id AS operation_id_157, t60.particulierUser_id AS particulierUser_id_158, t60.qualificationRecord_id AS qualificationRecord_id_159, t60.sousTraitant_id AS sousTraitant_id_160, t60.program_id AS program_id_161, t60.programCommercial_id AS programCommercial_id_162, t60.programManager_id AS programManager_id_163, t60.signatureAuto_id AS signatureAuto_id_164, t60.wasteCenter_id AS wasteCenter_id_165, t60.waste_id AS waste_id_166, t60.programAuto_id AS programAuto_id_167, t60.justificatif_id AS justificatif_id_168, t60.cappingRule_id AS cappingRule_id_169, t60.projectOwner_id AS projectOwner_id_170, t60.project_bundle_id AS project_bundle_id_171, t60.estate_id AS estate_id_172 FROM FactureDetail t0 LEFT JOIN Document t10 ON t10.factureDetail_id = t0.id LEFT JOIN OffreProjet t60 ON t60.factureDetail_id = t0.id WHERE t0.id = ?
Parameters:
[
219192
]
|
|
3.44 ms (4.00%) |
1 |
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:
[ 453208 "ah" ] |
|
2.56 ms (2.98%) |
1 |
SELECT t0.id AS id_1, t0.raison AS raison_2, t0.siret AS siret_3, t0.adresse AS adresse_4, t0.adresse_complement AS adresse_complement_5, t0.codepostal AS codepostal_6, t0.ville AS ville_7, t0.website AS website_8, t0.effectif AS effectif_9, t0.status AS status_10, t0.created_datetime AS created_datetime_11, t0.updated_datetime AS updated_datetime_12, t0.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.financialMpr AS financialMpr_34, t0.mprAcceptFunding AS mprAcceptFunding_35, t0.sienna_id AS sienna_id_36, t0.logoFileName AS logoFileName_37, t0.cachetFileName AS cachetFileName_38, t0.tvaNumber AS tvaNumber_39, t0.decennalResponsibility AS decennalResponsibility_40, t0.companyStatus AS companyStatus_41, t0.codeApe AS codeApe_42, t0.capital AS capital_43, t44.id AS id_45, t44.type AS type_46, t44.detail AS detail_47, t44.token AS token_48, t44.installateur_id AS installateur_id_49, t44.particulierUser_id AS particulierUser_id_50, t44.entrepriseUser_id AS entrepriseUser_id_51, t44.particulierUserContact_id AS particulierUserContact_id_52, t44.entrepriseUserContact_id AS entrepriseUserContact_id_53, t0.user_id AS user_id_54, t55.id AS id_56, t55.tel AS tel_57, t55.mobile AS mobile_58, t55.username AS username_59, t55.fonction AS fonction_60, t55.nom AS nom_61, t55.prenom AS prenom_62, t55.company_id AS company_id_63, t64.id AS id_65, t64.mode AS mode_66, t64.targetType AS targetType_67, t64.classic AS classic_68, t64.preca AS preca_69, t64.enable AS enable_70, t64.raiType AS raiType_71, t64.contractSignedElectronically AS contractSignedElectronically_72, t64.pro_signature_mandatory_outlay AS pro_signature_mandatory_outlay_73, t64.obligeTarget_id AS obligeTarget_id_74, t64.teteReseau_id AS teteReseau_id_75, t64.simulateur_id AS simulateur_id_76, t64.installateurTarget_id AS installateurTarget_id_77, t64.beTarget_id AS beTarget_id_78, t79.id AS id_80, t79.createdAt AS createdAt_81, t79.updatedAt AS updatedAt_82, t79.installateur_id AS installateur_id_83, t0.prestataireEffacement_id AS prestataireEffacement_id_84 FROM Installateur t0 LEFT JOIN PaymentMethod t44 ON t44.installateur_id = t0.id LEFT JOIN SignataireInstallateur t55 ON t55.company_id = t0.id LEFT JOIN AffectationConsoneoRule t64 ON t64.installateurTarget_id = t0.id LEFT JOIN installateur_certificall_config t79 ON t79.installateur_id = t0.id WHERE t0.id = ?
Parameters:
[
19412
]
|
|
2.29 ms (2.67%) |
1 |
SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3, t0.offreProjet_id AS offreProjet_id_4, t0.projet_id AS projet_id_5 FROM OffreProjetAdditionalInformation t0 WHERE t0.`key` = ? AND t0.`value` = ? AND t0.projet_id = ? LIMIT 1
Parameters:
[ "proprietaire_detail" "proprietaire_bailleur_du_logement" 1716303 ] |
|
2.21 ms (2.57%) |
1 |
SELECT t0.branding AS branding_1, t0.title AS title_2 FROM Branding t0 WHERE t0.branding = ? LIMIT 1
Parameters:
[
"i"
]
|
|
1.98 ms (2.31%) |
2 |
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.offreProjet_id AS offreProjet_id_9, t0.type_id AS type_id_10, t0.certification_id AS certification_id_11, t0.qualification_id AS qualification_id_12, t0.document_id AS document_id_13 FROM OffreProjetDocumentObligatoire t0 WHERE t0.offreProjet_id = ? AND t0.type_id = ? LIMIT 1
Parameters:
[ 453208 1 ] |
|
1.84 ms (2.15%) |
1 |
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_.electronic = ? AND d0_.type_id = ? LIMIT 1
Parameters:
[ 1 453208 1 4 ] |
|
1.66 ms (1.93%) |
1 |
SELECT t0.id AS id_1, t0.raison AS raison_2, t0.siret AS siret_3, t0.adresse AS adresse_4, t0.adresse_complement AS adresse_complement_5, t0.codepostal AS codepostal_6, t0.ville AS ville_7, t0.website AS website_8, t0.effectif AS effectif_9, t0.status AS status_10, t0.created_datetime AS created_datetime_11, t0.updated_datetime AS updated_datetime_12, t0.signature AS signature_13, t0.logo AS logo_14, t0.formation_installateur_doc AS formation_installateur_doc_15, t0.pres_marketing_installateur AS pres_marketing_installateur_16, t0.guide_utilisation_commerciaux AS guide_utilisation_commerciaux_17, t0.guidePerformanceEnergetiqueB2b AS guidePerformanceEnergetiqueB2b_18, t0.guidePerformanceEnergetiqueB2c AS guidePerformanceEnergetiqueB2c_19, t0.cgu AS cgu_20, t0.partenariatContract AS partenariatContract_21, t0.tel_beneficiaire_B2C AS tel_beneficiaire_B2C_22, t0.tel_beneficiaire_B2B AS tel_beneficiaire_B2B_23, t0.tel_installateur AS tel_installateur_24, t0.tel_support_intern AS tel_support_intern_25, t0.fax_beneficiaire AS fax_beneficiaire_26, t0.fax_installateur AS fax_installateur_27, t0.email_beneficiaire AS email_beneficiaire_28, t0.email_installateur AS email_installateur_29, t0.is_consoneo AS is_consoneo_30, t0.slug AS slug_31, t0.conventionElectronique AS conventionElectronique_32, t0.aftElectronique AS aftElectronique_33, t0.contratInstallateur AS contratInstallateur_34, t0.modeProBeneficiaireInscription AS modeProBeneficiaireInscription_35, t0.modeByPassSuperviseur AS modeByPassSuperviseur_36, t0.`lead` AS lead_37, t0.`leadUrl` AS leadUrl_38, t0.`leadLogin` AS leadLogin_39, t0.`leadPassword` AS leadPassword_40, t0.relanceConventionClientUn AS relanceConventionClientUn_41, t0.relanceConventionClientDeux AS relanceConventionClientDeux_42, t0.alertConventionClient AS alertConventionClient_43, t0.relanceConventionInstallateurUn AS relanceConventionInstallateurUn_44, t0.relanceConventionInstallateurDeux AS relanceConventionInstallateurDeux_45, t0.alertConventionInstallateur AS alertConventionInstallateur_46, t0.conventionFin AS conventionFin_47, t0.questionnaireAftRelanceUn AS questionnaireAftRelanceUn_48, t0.questionnaireAftRelanceDeux AS questionnaireAftRelanceDeux_49, t0.alertQuestionnaireAFT AS alertQuestionnaireAFT_50, t0.questionnaireAftFin AS questionnaireAftFin_51, t0.relanceAftFacture AS relanceAftFacture_52, t0.alertAftFacture AS alertAftFacture_53, t0.aftFactureFin AS aftFactureFin_54, t0.mentionCnil AS mentionCnil_55, t0.serviceType AS serviceType_56, t0.precariteMode AS precariteMode_57, t0.precariteModeProgram AS precariteModeProgram_58, t0.blocked AS blocked_59, t0.blockedSimulation AS blockedSimulation_60, t0.resiliation AS resiliation_61, t0.archivageAuto AS archivageAuto_62, t0.travauxPostDevis AS travauxPostDevis_63, t0.emailFacturationPro AS emailFacturationPro_64, t0.mandatoryInstallateurGenericContract AS mandatoryInstallateurGenericContract_65, t0.hiddenEmail AS hiddenEmail_66, t0.certificallCompanyId AS certificallCompanyId_67, t0.visibilityCommercials AS visibilityCommercials_68, t0.mandat AS mandat_69, t0.pricingMandatClassique AS pricingMandatClassique_70, t0.pricingMandatPreca AS pricingMandatPreca_71, t0.pricingPrimeMaximumMandatClassique AS pricingPrimeMaximumMandatClassique_72, t0.pricingPrimeMaximumMandatPreca AS pricingPrimeMaximumMandatPreca_73, t0.originauxAdresse AS originauxAdresse_74, t0.originauxAdresseComplement AS originauxAdresseComplement_75, t0.originauxCodepostal AS originauxCodepostal_76, t0.originauxVille AS originauxVille_77, t0.eligible AS eligible_78, t0.satisfactionSurvey AS satisfactionSurvey_79, t0.surveyConfiguration AS surveyConfiguration_80, t0.autoPayment AS autoPayment_81, t0.isAnnexeDechetQuestion AS isAnnexeDechetQuestion_82, t0.aiEnabled AS aiEnabled_83, t0.isSignatureAutoAhEnabled AS isSignatureAutoAhEnabled_84, t0.isSignatureAutoOtherDocumentsEnabled AS isSignatureAutoOtherDocumentsEnabled_85, t0.emailVersion AS emailVersion_86, t0.validateBackwards AS validateBackwards_87, t0.displayTelConsoneo AS displayTelConsoneo_88, t0.allowedUniverSign AS allowedUniverSign_89, t0.allowedApplicationFees AS allowedApplicationFees_90, t0.displayApplicationFees AS displayApplicationFees_91, t0.programAutoAllowed AS programAutoAllowed_92, t0.mpr AS mpr_93, t0.isRibActivated AS isRibActivated_94, t0.canonicalTeteReseau_id AS canonicalTeteReseau_id_95, t0.oblige_id AS oblige_id_96, t97.id AS id_98, t97.raison AS raison_99, t97.email AS email_100, t97.tel AS tel_101, t97.site_web AS site_web_102, t97.adresse AS adresse_103, t97.cp AS cp_104, t97.ville AS ville_105, t97.oblige_id AS oblige_id_106, t107.id AS id_108, t107.gender AS gender_109, t107.firstName AS firstName_110, t107.name AS name_111, t107.raison AS raison_112, t107.email AS email_113, t107.tel AS tel_114, t107.address AS address_115, t107.cp AS cp_116, t107.city AS city_117, t107.adminMandate AS adminMandate_118, t107.financialMandate AS financialMandate_119, t107.mixteMandate AS mixteMandate_120, t107.signature AS signature_121, t107.tutorial_admin AS tutorial_admin_122, t107.tutorial_mixte AS tutorial_mixte_123, t107.tutorial_financial AS tutorial_financial_124, t107.oblige_id AS oblige_id_125, t126.id AS id_127, t126.raison AS raison_128, t126.siret AS siret_129, t126.oblige_id AS oblige_id_130 FROM Oblige t0 LEFT JOIN Mediateur t97 ON t97.oblige_id = t0.id LEFT JOIN MprConfig t107 ON t107.oblige_id = t0.id LEFT JOIN Mandataire t126 ON t126.oblige_id = t0.id WHERE t0.id = ?
Parameters:
[
6
]
|
|
1.40 ms (1.63%) |
1 |
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.end_zni_date AS end_zni_date_47, t11.globalConfigurationHash AS globalConfigurationHash_48, t11.zni AS zni_49, t11.cdp_eligible AS cdp_eligible_50, t11.simulateur_id AS simulateur_id_51, t11.arrete_id AS arrete_id_52, t11.certification_id AS certification_id_53, t11.qualification_id AS qualification_id_54, t11.formConfigEngine_id AS formConfigEngine_id_55, t0.secteur_id AS secteur_id_56, t0.categorie_id AS categorie_id_57, t0.categorieCd_id AS categorieCd_id_58, t0.type_operation_id AS type_operation_id_59, t0.operation_specifique_id AS operation_specifique_id_60, t61.id AS id_62, t61.mode AS mode_63, t61.targetType AS targetType_64, t61.classic AS classic_65, t61.preca AS preca_66, t61.enable AS enable_67, t61.raiType AS raiType_68, t61.contractSignedElectronically AS contractSignedElectronically_69, t61.pro_signature_mandatory_outlay AS pro_signature_mandatory_outlay_70, t61.obligeTarget_id AS obligeTarget_id_71, t61.teteReseau_id AS teteReseau_id_72, t61.simulateur_id AS simulateur_id_73, t61.installateurTarget_id AS installateurTarget_id_74, t61.beTarget_id AS beTarget_id_75 FROM Simulateur t0 LEFT JOIN Operation t11 ON t0.active_operation_id = t11.id LEFT JOIN AffectationConsoneoRule t61 ON t61.simulateur_id = t0.id WHERE t0.id = ?
Parameters:
[
243
]
|
|
1.14 ms (1.33%) |
1 |
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.end_zni_date AS end_zni_date_36, t0.globalConfigurationHash AS globalConfigurationHash_37, t0.zni AS zni_38, t0.cdp_eligible AS cdp_eligible_39, t0.simulateur_id AS simulateur_id_40, t0.arrete_id AS arrete_id_41, t0.certification_id AS certification_id_42, t0.qualification_id AS qualification_id_43, t0.formConfigEngine_id AS formConfigEngine_id_44 FROM Operation t0 WHERE t0.id = ?
Parameters:
[
871
]
|
|
1.05 ms (1.22%) |
1 |
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:
[ 0 453208 4 ] |
|
1.03 ms (1.20%) |
1 |
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:
[
453208
]
|
|
1.00 ms (1.17%) |
1 |
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:
[
21970
]
|
|
0.99 ms (1.15%) |
1 |
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:
[
21970
]
|
|
0.91 ms (1.06%) |
1 |
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:
[
1716303
]
|
|
0.91 ms (1.06%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.status AS status_4 FROM Secteur t0 WHERE t0.id = ?
Parameters:
[
2
]
|
|
0.90 ms (1.05%) |
1 |
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_.offreProjet_id AS offreProjet_id_8, o0_.type_id AS type_id_9, o0_.certification_id AS certification_id_10, o0_.qualification_id AS qualification_id_11, o0_.document_id AS document_id_12 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:
[
453208
]
|
|
0.87 ms (1.01%) |
1 |
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 LIMIT 1
Parameters:
[
"2026-06-15 15:39:07"
]
|
|
0.85 ms (0.99%) |
1 |
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-06-15 15:39:07"
]
|
|
0.84 ms (0.98%) |
1 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.description AS description_4, t0.status AS status_5, t0.slug AS slug_6, t0.human_title AS human_title_7, t0.position AS position_8 FROM SecteurActivite t0 WHERE t0.id = ?
Parameters:
[
9
]
|
|
0.84 ms (0.98%) |
1 |
SELECT t0.id AS id_1, t0.lastname AS lastname_2, t0.firstname AS firstname_3, t0.justificatif_id AS justificatif_id_4 FROM Declarant t0 WHERE t0.justificatif_id = ?
Parameters:
[
341242
]
|
|
0.74 ms (0.86%) |
1 |
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:
[
5
]
|
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\UserBundle\Entity\AffectationUser | 5 |
| Consoneo\Bundle\UserBundle\Entity\ObligeRole | 5 |
| Consoneo\Bundle\ObligeBundle\Entity\DocumentType | 4 |
| Consoneo\Bundle\UserBundle\Entity\DomaineTravauxRGE | 4 |
| Consoneo\Bundle\ObligeBundle\Entity\OffreProjetDocumentObligatoire | 3 |
| Consoneo\Bundle\UserBundle\Entity\TeteReseau | 2 |
| Consoneo\Bundle\UserBundle\Entity\Identite | 2 |
| Consoneo\Bundle\SimulateurBundle\Entity\Categorie | 2 |
| Consoneo\Bundle\ObligeBundle\Entity\PaymentMethod | 2 |
| Consoneo\Bundle\UserBundle\Entity\Precarite\Justificatif | 2 |
| Consoneo\Bundle\ObligeBundle\Entity\DocumentStatic | 2 |
| Consoneo\Bundle\UserBundle\Entity\ObligeUser | 2 |
| Consoneo\Bundle\ObligeBundle\Entity\IntegrationModule | 1 |
| Consoneo\Bundle\WorkflowBundle\Entity\Branding | 1 |
| 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\UserBundle\Entity\Oblige | 1 |
| Consoneo\Bundle\SimulateurBundle\Entity\SecteurActivite | 1 |
| Consoneo\Bundle\ObligeBundle\Entity\FactureDetail | 1 |
| Consoneo\Bundle\ObligeBundle\Entity\OffreProjetStatus | 1 |
| Consoneo\Bundle\SimulateurBundle\Entity\Operation | 1 |
| Consoneo\Bundle\UserBundle\Entity\QualificationRecord | 1 |
| Consoneo\Bundle\UserBundle\Entity\ProjectOwner | 1 |
| Consoneo\Bundle\SimulateurBundle\Entity\Simulateur | 1 |
| Consoneo\Bundle\SimulateurBundle\Entity\Secteur | 1 |
| Consoneo\Bundle\SimulateurBundle\Entity\TypeOperation | 1 |
| Consoneo\Bundle\ObligeBundle\Entity\MprConfig | 1 |
| Consoneo\Bundle\UserBundle\Entity\Precarite\Cas1 | 1 |
| Consoneo\Bundle\UserBundle\Entity\Precarite\Declarant | 1 |
| Consoneo\Bundle\UserBundle\Entity\Installateur | 1 |
| Consoneo\Bundle\WorkflowBundle\Entity\Workflow | 1 |
| Consoneo\Bundle\UserBundle\Entity\InstallateurCertificallConfig | 1 |
read entity manager
| Class | Amount of managed objects |
|---|---|
| Consoneo\Bundle\ObligeBundle\Entity\Arrete | 43 |
stats entity manager
| Class | Amount of managed objects |
|---|
qrdecode entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
default entity manager
read entity manager
| Class | Mapping errors |
|---|---|
| Consoneo\Bundle\ObligeBundle\Entity\Configuration | No errors. |
| Consoneo\Bundle\UserBundle\Entity\Oblige | No errors. |
| Consoneo\Bundle\ObligeBundle\Entity\OffreProjet | No errors. |
| Consoneo\Bundle\SimulateurBundle\Entity\ZoneClimatique | 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. |
stats entity manager
No loaded entities.
qrdecode entity manager
| Class | Mapping errors |
|---|---|
| C2eCoreBundle\Entity\DocumentQrDecode | No errors. |