GET https://admin.preprod-orion.dossier-c2e.fr/installateur/assistance-offre-modal/14728

Query Metrics

5 Database Queries
5 Different statements
43.71 ms Query time
0 Invalid entities
21 Managed entities
0 Cache hits
0 Cache misses
0 Cache puts

Queries

Group similar statements

default connection

# Time Info
1 1.29 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.enabled AS enabled_3, t0.salt AS salt_4, t0.password AS password_5, t0.last_login AS last_login_6, t0.confirmation_token AS confirmation_token_7, t0.password_requested_at AS password_requested_at_8, t0.roles AS roles_9, t0.username AS username_10, t0.nom AS nom_11, t0.prenom AS prenom_12, t0.fonction AS fonction_13, t0.tel AS tel_14, t0.mobile AS mobile_15, t0.activation AS activation_16, t0.createdAt AS createdAt_17, t0.updatedAt AS updatedAt_18, t0.optin AS optin_19, t0.dateActivation AS dateActivation_20, t0.emailValidatedDateTime AS emailValidatedDateTime_21, t0.emailCreatedDateTime AS emailCreatedDateTime_22, t0.mobileCreatedDatetime AS mobileCreatedDatetime_23, t0.sendEmail AS sendEmail_24, t0.scope AS scope_25, t0.isArchived AS isArchived_26, t0.import AS import_27, t0.email_canonical AS email_canonical_28, t0.username_canonical AS username_canonical_29, t0.oblige_id AS oblige_id_30 FROM ObligeUser t0 WHERE t0.id = ?
Parameters:
[
  44
]
2 10.77 ms
SELECT t0.id AS id_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.username AS username_12, t0.nom AS nom_13, t0.prenom AS prenom_14, t0.fonction AS fonction_15, t0.tel AS tel_16, t0.mobile AS mobile_17, t0.activation AS activation_18, t0.createdAt AS createdAt_19, t0.updatedAt AS updatedAt_20, t0.optin AS optin_21, t0.dateActivation AS dateActivation_22, t0.emailValidatedDateTime AS emailValidatedDateTime_23, t0.emailCreatedDateTime AS emailCreatedDateTime_24, t0.mobileCreatedDatetime AS mobileCreatedDatetime_25, t0.sendEmail AS sendEmail_26, t0.reference AS reference_27, t0.currentSubscriptionStep AS currentSubscriptionStep_28, t0.dateRetourContratPartenariat AS dateRetourContratPartenariat_29, t0.token AS token_30, t0.dateActivationStep2 AS dateActivationStep2_31, t0.dateActivationStep4 AS dateActivationStep4_32, t0.dateActivationStep5 AS dateActivationStep5_33, t0.dateRefused AS dateRefused_34, t0.emailRequested AS emailRequested_35, t0.emailRequestedDate AS emailRequestedDate_36, t0.attributes AS attributes_37, t0.lastOffreDate AS lastOffreDate_38, t0.quicklyTraited AS quicklyTraited_39, t0.proType AS proType_40, t0.system_facturation AS system_facturation_41, t0.signataireAh AS signataireAh_42, t0.inscription_step AS inscription_step_43, t0.import_status AS import_status_44, t0.token_thermor AS token_thermor_45, t0.exclusiveEnabled AS exclusiveEnabled_46, t0.relanceSmsRegistration AS relanceSmsRegistration_47, t0.dateRelanceSmsRegistration AS dateRelanceSmsRegistration_48, t0.company_id AS company_id_49, t0.workflow_id AS workflow_id_50, t0.obligeTarget_id AS obligeTarget_id_51, t0.identite_id AS identite_id_52, t0.integrationModule_id AS integrationModule_id_53 FROM InstallateurUser t0 WHERE t0.id = ?
Parameters:
[
  "14728"
]
3 3.00 ms
SELECT t0.id AS id_1, t0.entrepriseUser_id AS entrepriseUser_id_2, t0.particulierUser_id AS particulierUser_id_3, t0.installateurUser_id AS installateurUser_id_4, t0.beUser_id AS beUser_id_5, t0.obligeUser_id AS obligeUser_id_6, t0.obligeRole_id AS obligeRole_id_7 FROM AffectationUser t0 WHERE t0.installateurUser_id IN (?)
Parameters:
[
  14728
]
4 0.87 ms
SELECT t0.id AS id_1, t0.appKey AS appKey_2, t0.label AS label_3, t0.description AS description_4, t0.url AS url_5, t0.status AS status_6, t0.created_at AS created_at_7, t0.report_auto_email AS report_auto_email_8, t0.logo AS logo_9, t0.smartName AS smartName_10, t0.prefixEmail AS prefixEmail_11, t0.`lead` AS lead_12, t0.`leadUrl` AS leadUrl_13, t0.`leadLogin` AS leadLogin_14, t0.`leadPassword` AS leadPassword_15, t0.recommanderProDefault AS recommanderProDefault_16, t0.actif AS actif_17, t0.allowMultiSubscription AS allowMultiSubscription_18, t0.teteReseau_id AS teteReseau_id_19, t0.branding AS branding_20 FROM IntegrationModule t0 WHERE t0.id = ?
Parameters:
[
  4791
]
5 27.78 ms
SELECT t0.id AS id_1, t0.raison AS raison_2, t0.siret AS siret_3, t0.adresse AS adresse_4, t0.adresse_complement AS adresse_complement_5, t0.codepostal AS codepostal_6, t0.ville AS ville_7, t0.website AS website_8, t0.effectif AS effectif_9, t0.status AS status_10, t0.created_datetime AS created_datetime_11, t0.updated_datetime AS updated_datetime_12, t0.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:
[
  12766
]

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\UserBundle\Entity\ObligeUser 1
Consoneo\Bundle\UserBundle\Entity\Oblige 1
Consoneo\Bundle\UserBundle\Entity\InstallateurUser 1
Consoneo\Bundle\UserBundle\Entity\Installateur 1
Consoneo\Bundle\WorkflowBundle\Entity\Workflow 1
Consoneo\Bundle\UserBundle\Entity\Identite 1
Consoneo\Bundle\ObligeBundle\Entity\IntegrationModule 1
Consoneo\Bundle\UserBundle\Entity\TeteReseau 1
Consoneo\Bundle\WorkflowBundle\Entity\Branding 1
Consoneo\Bundle\ObligeBundle\Entity\PaymentMethod 1
Consoneo\Bundle\UserBundle\Entity\InstallateurCertificallConfig 1

read entity manager

Class Amount of managed objects

stats entity manager

Class Amount of managed objects

qrdecode entity manager

Class Amount of managed objects

Entities Mapping

default entity manager

Class Mapping errors
Consoneo\Bundle\UserBundle\Entity\ObligeUser No errors.
Consoneo\Bundle\UserBundle\Entity\Oblige No errors.
Consoneo\Bundle\ObligeBundle\Entity\Reminder No errors.
Consoneo\Bundle\ObligeBundle\Entity\Comment No errors.
Consoneo\Bundle\ObligeBundle\Entity\Document No errors.
Consoneo\Bundle\UserBundle\Entity\TeteReseau No errors.
Consoneo\Bundle\WorkflowBundle\Entity\AlertRecord No errors.
Consoneo\Bundle\ObligeBundle\Entity\StatRecord No errors.
Consoneo\Bundle\UserBundle\Entity\AffectationUser No errors.
Consoneo\Bundle\UserBundle\Entity\AffectationOffre No errors.
Consoneo\Bundle\UserBundle\Entity\RegleRole No errors.
Consoneo\Bundle\ObligeBundle\Entity\Campagne No errors.
Consoneo\Bundle\ObligeBundle\Entity\OffreProjetMonitoring No errors.
Consoneo\Bundle\ObligeBundle\Entity\PaymentMethodOblige No errors.
Consoneo\Bundle\ObligeBundle\Entity\ControlStepHistory No errors.
Consoneo\Bundle\ObligeBundle\Entity\OffreProjetAdditionalInformation No errors.
Consoneo\Bundle\ObligeBundle\Entity\Configuration No errors.
Consoneo\Bundle\WorkflowBundle\Entity\EmailHistory No errors.
Consoneo\Bundle\SimulateurBundle\Entity\Operation No errors.
Consoneo\Bundle\ObligeBundle\Entity\MoteurInfoArrete No errors.
Consoneo\Bundle\ObligeBundle\Entity\Arrete No errors.
Consoneo\Bundle\ObligeBundle\Entity\Contract No errors.
Consoneo\Bundle\ObligeBundle\Entity\DocumentStatic No errors.
Consoneo\Bundle\ObligeBundle\Entity\DocumentType No errors.
Consoneo\Bundle\ObligeBundle\Entity\OffreProjetDocumentObligatoire No errors.
Consoneo\Bundle\ObligeBundle\Entity\OffreProjet No errors.
Consoneo\Bundle\ObligeBundle\Entity\SampleCofracOperation No errors.
Consoneo\Bundle\ObligeBundle\Entity\Batch No errors.
Consoneo\Bundle\WorkflowBundle\Entity\Email No errors.
Consoneo\Bundle\UserBundle\Entity\InstallateurCertificallConfig No errors.
C2eCoreBundle\Entity\Certificall\Certilink No errors.
Consoneo\Bundle\UserBundle\Entity\InstallateurUser No errors.
Consoneo\Bundle\UserBundle\Entity\Installateur No errors.
Consoneo\Bundle\WorkflowBundle\Entity\Workflow No errors.
Consoneo\Bundle\UserBundle\Entity\Identite No errors.
Consoneo\Bundle\ObligeBundle\Entity\IntegrationModule No errors.
Consoneo\Bundle\ObligeBundle\Entity\Projet No errors.
Consoneo\Bundle\ObligeBundle\Entity\Message No errors.
Consoneo\Bundle\UserBundle\Entity\UserDocumentObligatoire No errors.
Consoneo\Bundle\WorkflowBundle\Entity\Sms No errors.
Consoneo\Bundle\UserBundle\Entity\InstallateurDocumentReference No errors.
Consoneo\Bundle\UserBundle\Entity\EtudeMultiOp No errors.
Consoneo\Bundle\WorkflowBundle\Entity\InstallateurUserProgram No errors.
Consoneo\Bundle\WorkflowBundle\Entity\Program No errors.
C2eCoreBundle\Entity\Internal\ProjectBundle No errors.
Consoneo\Bundle\UserBundle\Entity\EntrepriseUser No errors.
Consoneo\Bundle\UserBundle\Entity\ParticulierUser No errors.
Consoneo\Bundle\UserBundle\Entity\BeUser No errors.
Consoneo\Bundle\UserBundle\Entity\ObligeRole No errors.
Consoneo\Bundle\WorkflowBundle\Entity\Branding No errors.
Consoneo\Bundle\SimulateurBundle\Entity\SecteurActivite No errors.
Consoneo\Bundle\ObligeBundle\Entity\Lead No errors.
Consoneo\Bundle\ObligeBundle\Entity\PaymentMethod No errors.
Consoneo\Bundle\UserBundle\Entity\ParticulierUserContact No errors.
Consoneo\Bundle\UserBundle\Entity\EntrepriseUserContact No errors.
Consoneo\Bundle\UserBundle\Entity\SignataireInstallateur No errors.
Consoneo\Bundle\UserBundle\Entity\AffectationConsoneoRule No errors.
Consoneo\Bundle\SimulateurBundle\Entity\Simulateur No errors.
Consoneo\Bundle\UserBundle\Entity\Be No errors.
Consoneo\Bundle\ObligeBundle\Entity\PrestataireEffacement No errors.
Consoneo\Bundle\UserBundle\Entity\InstallateurProfilClient No errors.
Consoneo\Bundle\UserBundle\Entity\InstallateurCompetence No errors.
Consoneo\Bundle\UserBundle\Entity\QualificationRecord No errors.
Consoneo\Bundle\UserBundle\Entity\SousTraitantRGE No errors.
Consoneo\Bundle\UserBundle\Entity\ApplicationFees No errors.
Consoneo\Bundle\WorkflowBundle\Entity\ProgramAuto No errors.
Consoneo\Bundle\ObligeBundle\Entity\CappingRule No errors.
Consoneo\Bundle\ObligeBundle\Entity\PaymentMpr No errors.
Consoneo\Bundle\ObligeBundle\Entity\User\Program\Manager No errors.
Consoneo\Bundle\ObligeBundle\Entity\User\Program\Commercial No errors.

read entity manager

Class Mapping errors
Consoneo\Bundle\SimulateurBundle\Entity\ZoneClimatique No errors.
Consoneo\Bundle\ObligeBundle\Entity\Configuration No errors.
Consoneo\Bundle\UserBundle\Entity\Oblige No errors.
Consoneo\Bundle\ObligeBundle\Entity\OffreProjet No errors.

stats entity manager

No loaded entities.

qrdecode entity manager

Class Mapping errors
C2eCoreBundle\Entity\DocumentQrDecode No errors.