Query Metrics
6
Database Queries
5
Different statements
38.78 ms
Query time
0
Invalid entities
8
Managed entities
0
Cache hits
0
Cache misses
0
Cache puts
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
19.42 ms (50.07%) |
1 |
SELECT t0.signature AS signature_1, t0.logo AS logo_2, t0.formation_installateur_doc AS formation_installateur_doc_3, t0.pres_marketing_installateur AS pres_marketing_installateur_4, t0.guide_utilisation_commerciaux AS guide_utilisation_commerciaux_5, t0.guidePerformanceEnergetiqueB2b AS guidePerformanceEnergetiqueB2b_6, t0.guidePerformanceEnergetiqueB2c AS guidePerformanceEnergetiqueB2c_7, t0.cgu AS cgu_8, t0.partenariatContract AS partenariatContract_9, t0.tel_beneficiaire_B2C AS tel_beneficiaire_B2C_10, t0.tel_beneficiaire_B2B AS tel_beneficiaire_B2B_11, t0.tel_installateur AS tel_installateur_12, t0.tel_support_intern AS tel_support_intern_13, t0.fax_beneficiaire AS fax_beneficiaire_14, t0.fax_installateur AS fax_installateur_15, t0.adresse AS adresse_16, t0.adresse_complement AS adresse_complement_17, t0.codepostal AS codepostal_18, t0.ville AS ville_19, t0.email_beneficiaire AS email_beneficiaire_20, t0.email_installateur AS email_installateur_21, t0.is_consoneo AS is_consoneo_22, t0.slug AS slug_23, t0.conventionElectronique AS conventionElectronique_24, t0.aftElectronique AS aftElectronique_25, t0.contratInstallateur AS contratInstallateur_26, t0.modeProBeneficiaireInscription AS modeProBeneficiaireInscription_27, t0.modeByPassSuperviseur AS modeByPassSuperviseur_28, t0.`lead` AS lead_29, t0.`leadUrl` AS leadUrl_30, t0.`leadLogin` AS leadLogin_31, t0.`leadPassword` AS leadPassword_32, t0.relanceConventionClientUn AS relanceConventionClientUn_33, t0.relanceConventionClientDeux AS relanceConventionClientDeux_34, t0.alertConventionClient AS alertConventionClient_35, t0.relanceConventionInstallateurUn AS relanceConventionInstallateurUn_36, t0.relanceConventionInstallateurDeux AS relanceConventionInstallateurDeux_37, t0.alertConventionInstallateur AS alertConventionInstallateur_38, t0.conventionFin AS conventionFin_39, t0.questionnaireAftRelanceUn AS questionnaireAftRelanceUn_40, t0.questionnaireAftRelanceDeux AS questionnaireAftRelanceDeux_41, t0.alertQuestionnaireAFT AS alertQuestionnaireAFT_42, t0.questionnaireAftFin AS questionnaireAftFin_43, t0.relanceAftFacture AS relanceAftFacture_44, t0.alertAftFacture AS alertAftFacture_45, t0.aftFactureFin AS aftFactureFin_46, t0.mentionCnil AS mentionCnil_47, t0.serviceType AS serviceType_48, t0.precariteMode AS precariteMode_49, t0.precariteModeProgram AS precariteModeProgram_50, t0.blocked AS blocked_51, t0.blockedSimulation AS blockedSimulation_52, t0.resiliation AS resiliation_53, t0.archivageAuto AS archivageAuto_54, t0.travauxPostDevis AS travauxPostDevis_55, t0.emailFacturationPro AS emailFacturationPro_56, t0.mandatoryInstallateurGenericContract AS mandatoryInstallateurGenericContract_57, t0.hiddenEmail AS hiddenEmail_58, t0.visibilityCommercials AS visibilityCommercials_59, t0.mandat AS mandat_60, t0.pricingMandatClassique AS pricingMandatClassique_61, t0.pricingMandatPreca AS pricingMandatPreca_62, t0.pricingPrimeMaximumMandatClassique AS pricingPrimeMaximumMandatClassique_63, t0.pricingPrimeMaximumMandatPreca AS pricingPrimeMaximumMandatPreca_64, t0.originauxAdresse AS originauxAdresse_65, t0.originauxAdresseComplement AS originauxAdresseComplement_66, t0.originauxCodepostal AS originauxCodepostal_67, t0.originauxVille AS originauxVille_68, t0.eligible AS eligible_69, t0.satisfactionSurvey AS satisfactionSurvey_70, t0.surveyConfiguration AS surveyConfiguration_71, t0.autoPayment AS autoPayment_72, t0.isAnnexeDechetQuestion AS isAnnexeDechetQuestion_73, t0.aiEnabled AS aiEnabled_74, t0.isSignatureAutoAhEnabled AS isSignatureAutoAhEnabled_75, t0.isSignatureAutoOtherDocumentsEnabled AS isSignatureAutoOtherDocumentsEnabled_76, t0.emailVersion AS emailVersion_77, t0.validateBackwards AS validateBackwards_78, t0.displayTelConsoneo AS displayTelConsoneo_79, t0.allowedUniverSign AS allowedUniverSign_80, t0.allowedApplicationFees AS allowedApplicationFees_81, t0.displayApplicationFees AS displayApplicationFees_82, t0.programAutoAllowed AS programAutoAllowed_83, t0.mpr AS mpr_84, t0.isRibActivated AS isRibActivated_85, t0.id AS id_86, t0.raison AS raison_87, t0.siret AS siret_88, t0.website AS website_89, t0.effectif AS effectif_90, t0.status AS status_91, t0.created_datetime AS created_datetime_92, t0.updated_datetime AS updated_datetime_93, t0.canonicalTeteReseau_id AS canonicalTeteReseau_id_94, t0.oblige_id AS oblige_id_95, t96.id AS id_97, t96.raison AS raison_98, t96.email AS email_99, t96.tel AS tel_100, t96.site_web AS site_web_101, t96.adresse AS adresse_102, t96.cp AS cp_103, t96.ville AS ville_104, t96.oblige_id AS oblige_id_105, t106.id AS id_107, t106.gender AS gender_108, t106.firstName AS firstName_109, t106.name AS name_110, t106.raison AS raison_111, t106.email AS email_112, t106.tel AS tel_113, t106.address AS address_114, t106.cp AS cp_115, t106.city AS city_116, t106.adminMandate AS adminMandate_117, t106.financialMandate AS financialMandate_118, t106.mixteMandate AS mixteMandate_119, t106.signature AS signature_120, t106.tutorial_admin AS tutorial_admin_121, t106.tutorial_mixte AS tutorial_mixte_122, t106.tutorial_financial AS tutorial_financial_123, t106.oblige_id AS oblige_id_124, t125.id AS id_126, t125.raison AS raison_127, t125.siret AS siret_128, t125.oblige_id AS oblige_id_129 FROM Oblige t0 LEFT JOIN Mediateur t96 ON t96.oblige_id = t0.id LEFT JOIN MprConfig t106 ON t106.oblige_id = t0.id LEFT JOIN Mandataire t125 ON t125.oblige_id = t0.id WHERE t0.id = ?
Parameters:
[
2
]
|
|
6.68 ms (17.23%) |
1 |
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:
[
2
]
|
|
6.48 ms (16.71%) |
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.zni AS zni_89, t52.simulateur_id AS simulateur_id_90, t52.arrete_id AS arrete_id_91, t52.certification_id AS certification_id_92, t52.qualification_id AS qualification_id_93, t52.formConfigEngine_id AS formConfigEngine_id_94, t0.entrepriseUser_id AS entrepriseUser_id_95, t0.particulierUser_id AS particulierUser_id_96, t0.installateurUser_id AS installateurUser_id_97, t0.beUser_id AS beUser_id_98, t99.id AS id_100, t99.type AS type_101, t99.pricingType AS pricingType_102, t99.finalisationRequested AS finalisationRequested_103, t99.finalisationRequestDate AS finalisationRequestDate_104, t99.reference AS reference_105, t99.data AS data_106, t99.cofracData AS cofracData_107, t99.ip AS ip_108, t99.offre_auto_date AS offre_auto_date_109, t99.created_datetime AS created_datetime_110, t99.updated_datetime AS updated_datetime_111, t99.tel AS tel_112, t99.codepostal AS codepostal_113, t99.adresse AS adresse_114, t99.adresse_complement AS adresse_complement_115, t99.ville AS ville_116, t99.delai_souhaite AS delai_souhaite_117, t99.accept_recevoir_offre AS accept_recevoir_offre_118, t99.accept_recommandation AS accept_recommandation_119, t99.acceptLeadPromo AS acceptLeadPromo_120, t99.offre_cumac AS offre_cumac_121, t99.offre_cumac_client AS offre_cumac_client_122, t99.offre_cumac_precarite AS offre_cumac_precarite_123, t99.offre_cumac_client_precarite AS offre_cumac_client_precarite_124, t99.cumac AS cumac_125, t99.cumac_AFT AS cumac_AFT_126, t99.total_prime AS total_prime_127, t99.total_prime_AFT AS total_prime_AFT_128, t99.prime_pro AS prime_pro_129, t99.prime_pro_aft AS prime_pro_aft_130, t99.prime_client AS prime_client_131, t99.prime_client_aft AS prime_client_aft_132, t99.cumac_moyenne AS cumac_moyenne_133, t99.taux_actualise AS taux_actualise_134, t99.taux_accumule AS taux_accumule_135, t99.date_debut_chantier AS date_debut_chantier_136, t99.date_demande_offre AS date_demande_offre_137, t99.date_fin_chantier AS date_fin_chantier_138, t99.etat AS etat_139, t99.status AS status_140, t99.date_offre AS date_offre_141, t99.notification_date_chantier AS notification_date_chantier_142, t99.date_retour_conv AS date_retour_conv_143, t99.date_validation_conv AS date_validation_conv_144, t99.date_chantier_renseigne AS date_chantier_renseigne_145, t99.date_paiement AS date_paiement_146, t99.date_all_doc_valid AS date_all_doc_valid_147, t99.date_fin_chantier_repousse AS date_fin_chantier_repousse_148, t99.date_envoi_questionnaire AS date_envoi_questionnaire_149, t99.date_edition_questionnaire AS date_edition_questionnaire_150, t99.date_validation_final AS date_validation_final_151, t99.date_annulation AS date_annulation_152, t99.no_click_email_date_chantier AS no_click_email_date_chantier_153, t99.token AS token_154, t99.auto_installation AS auto_installation_155, t99.siret AS siret_156, t99.cancelReason AS cancelReason_157, t99.dateCommande AS dateCommande_158, t99.siteTravaux AS siteTravaux_159, t99.incitation AS incitation_160, t99.qualificationRecordDate AS qualificationRecordDate_161, t99.serviceType AS serviceType_162, t99.debutChantier AS debutChantier_163, t99.finChantier AS finChantier_164, t99.initiateCDP AS initiateCDP_165, t99.cdp AS cdp_166, t99.date_last_envoi_convention AS date_last_envoi_convention_167, t99.programStep AS programStep_168, t99.devisRestAPayer AS devisRestAPayer_169, t99.pricingMandatClassique AS pricingMandatClassique_170, t99.pricingMandatPreca AS pricingMandatPreca_171, t99.isCOFRAC AS isCOFRAC_172, t99.applicationFeesPrice AS applicationFeesPrice_173, t99.attributes AS attributes_174, t99.engineDocumentId AS engineDocumentId_175, t99.batchOffreProjet_id AS batchOffreProjet_id_176, t99.entrepriseUser_id AS entrepriseUser_id_177, t99.installateurUser_id AS installateurUser_id_178, t99.beUser_id AS beUser_id_179, t99.entrepriseUserContact_id AS entrepriseUserContact_id_180, t99.particulierUserContact_id AS particulierUserContact_id_181, t99.signataireEntreprise_id AS signataireEntreprise_id_182, t99.signataireInstallateur_id AS signataireInstallateur_id_183, t99.installateurUserContact_id AS installateurUserContact_id_184, t99.projet_id AS projet_id_185, t99.precariteCas2_id AS precariteCas2_id_186, t99.precarite_id AS precarite_id_187, t99.state_id AS state_id_188, t99.oblige_id AS oblige_id_189, t99.secteurActivite_id AS secteurActivite_id_190, t99.factureDetail_id AS factureDetail_id_191, t99.offreStatus_id AS offreStatus_id_192, t99.identiteBeneficiaire_id AS identiteBeneficiaire_id_193, t99.identiteInstallateur_id AS identiteInstallateur_id_194, t99.operation_id AS operation_id_195, t99.particulierUser_id AS particulierUser_id_196, t99.qualificationRecord_id AS qualificationRecord_id_197, t99.sousTraitant_id AS sousTraitant_id_198, t99.program_id AS program_id_199, t99.programCommercial_id AS programCommercial_id_200, t99.programManager_id AS programManager_id_201, t99.signatureAuto_id AS signatureAuto_id_202, t99.wasteCenter_id AS wasteCenter_id_203, t99.waste_id AS waste_id_204, t99.programAuto_id AS programAuto_id_205, t99.justificatif_id AS justificatif_id_206, t99.cappingRule_id AS cappingRule_id_207, t99.projectOwner_id AS projectOwner_id_208, t99.project_bundle_id AS project_bundle_id_209, t99.estate_id AS estate_id_210, t0.precarite_id AS precarite_id_211, t0.secteurActivite_id AS secteurActivite_id_212, t0.integrationModule_id AS integrationModule_id_213, t0.precariteCas2_id AS precariteCas2_id_214, t0.program_id AS program_id_215, t0.programCommercial_id AS programCommercial_id_216, t0.programManager_id AS programManager_id_217, t0.justificatif_id AS justificatif_id_218, t219.id AS id_220, t219.numero AS numero_221, t219.dateRealisation AS dateRealisation_222, t219.dateFinValidite AS dateFinValidite_223, t219.etiquetteBilan AS etiquetteBilan_224, t219.createdAt AS createdAt_225, t219.updatedAt AS updatedAt_226, t219.typeJustificatif AS typeJustificatif_227, t219.projet_id AS projet_id_228, t219.offreProjet_id AS offreProjet_id_229, t0.project_bundle_id AS project_bundle_id_230, t0.estate_id AS estate_id_231 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 t99 ON t99.projet_id = t0.id LEFT JOIN JustificatifPerformanceEnergetique t219 ON t219.projet_id = t0.id WHERE t0.reference IS NULL LIMIT 1
Parameters:
[] |
|
5.25 ms (13.54%) |
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:
[
"1234"
]
|
|
0.95 ms (2.45%) |
1 |
SELECT t0.branding AS branding_1, t0.title AS title_2 FROM Branding t0 WHERE t0.branding = ? LIMIT 1
Parameters:
[
"i"
]
|
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\IntegrationModule | 3 |
| Consoneo\Bundle\WorkflowBundle\Entity\Branding | 2 |
| Consoneo\Bundle\UserBundle\Entity\TeteReseau | 1 |
| Consoneo\Bundle\UserBundle\Entity\Oblige | 1 |
| Consoneo\Bundle\ObligeBundle\Entity\MprConfig | 1 |
read entity manager
| Class | Amount of managed objects |
|---|
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\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. |
stats entity manager
No loaded entities.
qrdecode entity manager
| Class | Mapping errors |
|---|---|
| C2eCoreBundle\Entity\DocumentQrDecode | No errors. |