Query Metrics
25
Database Queries
16
Different statements
50.30 ms
Query time
0
Invalid entities
94
Managed entities
0
Cache hits
0
Cache misses
0
Cache puts
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
26.90 ms (53.48%) |
5 |
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"
]
|
|
3.97 ms (7.88%) |
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.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:
[
"g3Wc0jphETj2Wrb6RM1grBYk3csyxIM_oa9XMpqxIJI"
]
|
|
3.22 ms (6.39%) |
2 |
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
]
|
|
2.25 ms (4.47%) |
2 |
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:
[ "display_logo_in_header" 6 "Consoneo\Bundle\UserBundle\Entity\Oblige" ] |
|
2.04 ms (4.05%) |
2 |
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:
[
1169
]
|
|
1.78 ms (3.54%) |
2 |
SELECT t0.branding AS branding_1, t0.title AS title_2 FROM Branding t0 WHERE t0.branding = ? LIMIT 1
Parameters:
[
"i"
]
|
|
1.31 ms (2.61%) |
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.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:
[
440
]
|
|
1.11 ms (2.20%) |
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:
[
10570
]
|
|
1.05 ms (2.10%) |
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.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:
[
1054
]
|
|
1.05 ms (2.08%) |
1 |
SELECT t0.mode AS mode_1, t0.consoneo AS consoneo_2 FROM Workflow t0 WHERE t0.mode = ?
Parameters:
[
"installateur"
]
|
|
1.01 ms (2.01%) |
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:
[
10570
]
|
|
0.97 ms (1.93%) |
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.96 ms (1.91%) |
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:
[
453433
]
|
|
0.96 ms (1.90%) |
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.87 ms (1.73%) |
1 |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.originalEmailName AS originalEmailName_4, t0.created_datetime AS created_datetime_5, t0.weight AS weight_6, t0.originalNeeded AS originalNeeded_7, t0.allowedUniverSign AS allowedUniverSign_8, t0.description AS description_9 FROM DocumentType t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"convention"
]
|
|
0.86 ms (1.72%) |
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:
[
1
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| read | doctrine.dbal.read_connection |
| stats | doctrine.dbal.stats_connection |
| qrdecode | doctrine.dbal.qrdecode_connection |
| archive | doctrine.dbal.archive_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| read | doctrine.orm.read_entity_manager |
| stats | doctrine.orm.stats_entity_manager |
| archive | doctrine.orm.archive_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\IntegrationModule | 3 |
| Consoneo\Bundle\UserBundle\Entity\TeteReseau | 2 |
| Consoneo\Bundle\UserBundle\Entity\ObligeUser | 2 |
| 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\OffreProjetStatus | 1 |
| Consoneo\Bundle\SimulateurBundle\Entity\Operation | 1 |
| Consoneo\Bundle\UserBundle\Entity\QualificationRecord | 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\ObligeBundle\Entity\MprConfig | 1 |
| Consoneo\Bundle\ObligeBundle\Entity\DocumentType | 1 |
| Consoneo\Bundle\UserBundle\Entity\Installateur | 1 |
| Consoneo\Bundle\WorkflowBundle\Entity\Workflow | 1 |
| Consoneo\Bundle\UserBundle\Entity\Identite | 1 |
read entity manager
| Class | Amount of managed objects |
|---|---|
| Consoneo\Bundle\ObligeBundle\Entity\Arrete | 46 |
| Consoneo\Bundle\ObligeBundle\Entity\IntegrationModule | 3 |
| Consoneo\Bundle\UserBundle\Entity\TeteReseau | 2 |
| Consoneo\Bundle\ObligeBundle\Entity\Configuration | 1 |
| Consoneo\Bundle\WorkflowBundle\Entity\Branding | 1 |
| Consoneo\Bundle\UserBundle\Entity\Oblige | 1 |
| Consoneo\Bundle\ObligeBundle\Entity\MprConfig | 1 |
stats entity manager
| Class | Amount of managed objects |
|---|
archive entity manager
| Class | Amount of managed objects |
|---|
qrdecode entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
default entity manager
read entity manager
stats entity manager
No loaded entities.
archive entity manager
No loaded entities.
qrdecode entity manager
| Class | Mapping errors |
|---|---|
| C2eCoreBundle\Entity\DocumentQrDecode | No errors. |