Query Metrics

18 Database Queries
7 Different statements
18.52 ms Query time
0 Invalid entities
27 Managed entities
0 Cache hits
0 Cache misses
0 Cache puts

Queries

Group similar statements

default connection

# Time Info
1 1.44 ms
SELECT t0.username AS username_1, t0.email AS email_2, t0.enabled AS enabled_3, t0.salt AS salt_4, t0.last_login AS last_login_5, t0.confirmation_token AS confirmation_token_6, t0.password_requested_at AS password_requested_at_7, t0.roles AS roles_8, t0.password AS password_9, t0.scope AS scope_10, t0.isArchived AS isArchived_11, t0.import AS import_12, t0.id AS id_13, t0.nom AS nom_14, t0.prenom AS prenom_15, t0.fonction AS fonction_16, t0.tel AS tel_17, t0.mobile AS mobile_18, t0.activation AS activation_19, t0.createdAt AS createdAt_20, t0.updatedAt AS updatedAt_21, t0.optin AS optin_22, t0.dateActivation AS dateActivation_23, t0.emailValidatedDateTime AS emailValidatedDateTime_24, t0.emailCreatedDateTime AS emailCreatedDateTime_25, t0.mobileCreatedDatetime AS mobileCreatedDatetime_26, t0.sendEmail AS sendEmail_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:
[
  420
]
2 1.24 ms
SELECT DISTINCT o0_.id AS id_0, o0_.operation_id AS sclr_1, o0_.displayOrder AS displayOrder_2 FROM operation_document_config o0_ LEFT JOIN Operation o1_ ON o0_.operation_id = o1_.id ORDER BY o0_.operation_id ASC, o0_.displayOrder ASC LIMIT 30
Parameters:
[]
3 1.05 ms
SELECT o0_.id AS id_0, o0_.moment AS moment_1, o0_.displayOrder AS displayOrder_2, o0_.certifical AS certifical_3, o0_.certificallOnly AS certificallOnly_4, o0_.frameId AS frameId_5, o0_.multipleDocuments AS multipleDocuments_6, o0_.multiplierProperty AS multiplierProperty_7, o0_.multiplierType AS multiplierType_8, o0_.itemIdentifierProperty AS itemIdentifierProperty_9, o0_.operation_id AS operation_id_10, o0_.document_type_id AS document_type_id_11 FROM operation_document_config o0_ LEFT JOIN Operation o1_ ON o0_.operation_id = o1_.id WHERE o0_.id IN (?, ?, ?, ?, ?) ORDER BY o0_.operation_id ASC, o0_.displayOrder ASC
Parameters:
[
  5
  6
  4
  2
  3
]
4 1.01 ms
SELECT count(DISTINCT o0_.id) AS sclr_0 FROM operation_document_config o0_ LEFT JOIN Operation o1_ ON o0_.operation_id = o1_.id
Parameters:
[]
5 1.09 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.version AS version_3, t0.code AS code_4, t0.duree AS duree_5, t0.auto_installation AS auto_installation_6, t0.conditions AS conditions_7, t0.conditionsRaw AS conditionsRaw_8, t0.conditionsFormater AS conditionsFormater_9, t0.documents_requis AS documents_requis_10, t0.nombre_documents AS nombre_documents_11, t0.nombre_conditions AS nombre_conditions_12, t0.question_details_type AS question_details_type_13, t0.question_details_value AS question_details_value_14, t0.periode AS periode_15, t0.informationTechnique AS informationTechnique_16, t0.informationTechniqueRaw AS informationTechniqueRaw_17, t0.informationTechniqueFormater AS informationTechniqueFormater_18, t0.informationDocSupplementaire AS informationDocSupplementaire_19, t0.informationDocSupplementaireRaw AS informationDocSupplementaireRaw_20, t0.informationDocSupplementaireFormater AS informationDocSupplementaireFormater_21, t0.informationfacture AS informationfacture_22, t0.informationfactureRaw AS informationfactureRaw_23, t0.informationfactureFormater AS informationfactureFormater_24, t0.informationfacture2 AS informationfacture2_25, t0.informationfacture2Raw AS informationfacture2Raw_26, t0.informationfacture2Formater AS informationfacture2Formater_27, t0.nbMateriau AS nbMateriau_28, t0.materiauSubtitle AS materiauSubtitle_29, t0.materiauTitle AS materiauTitle_30, t0.textForm AS textForm_31, t0.private AS private_32, t0.campagne AS campagne_33, t0.special AS special_34, t0.abrogation_datetime AS abrogation_datetime_35, t0.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:
[
  1054
]
6 0.95 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.originalEmailName AS originalEmailName_4, t0.created_datetime AS created_datetime_5, t0.weight AS weight_6, t0.originalNeeded AS originalNeeded_7, t0.allowedUniverSign AS allowedUniverSign_8, t0.description AS description_9 FROM DocumentType t0 WHERE t0.id = ?
Parameters:
[
  88
]
7 0.94 ms
SELECT t0.id AS id_1, t0.frameId AS frameId_2, t0.operation_document_config_id AS operation_document_config_id_3, t0.oblige_id AS oblige_id_4 FROM operation_document_config_oblige_override t0 WHERE t0.operation_document_config_id = ?
Parameters:
[
  5
]
8 0.81 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.originalEmailName AS originalEmailName_4, t0.created_datetime AS created_datetime_5, t0.weight AS weight_6, t0.originalNeeded AS originalNeeded_7, t0.allowedUniverSign AS allowedUniverSign_8, t0.description AS description_9 FROM DocumentType t0 WHERE t0.id = ?
Parameters:
[
  222
]
9 0.72 ms
SELECT t0.id AS id_1, t0.frameId AS frameId_2, t0.operation_document_config_id AS operation_document_config_id_3, t0.oblige_id AS oblige_id_4 FROM operation_document_config_oblige_override t0 WHERE t0.operation_document_config_id = ?
Parameters:
[
  6
]
10 0.95 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.version AS version_3, t0.code AS code_4, t0.duree AS duree_5, t0.auto_installation AS auto_installation_6, t0.conditions AS conditions_7, t0.conditionsRaw AS conditionsRaw_8, t0.conditionsFormater AS conditionsFormater_9, t0.documents_requis AS documents_requis_10, t0.nombre_documents AS nombre_documents_11, t0.nombre_conditions AS nombre_conditions_12, t0.question_details_type AS question_details_type_13, t0.question_details_value AS question_details_value_14, t0.periode AS periode_15, t0.informationTechnique AS informationTechnique_16, t0.informationTechniqueRaw AS informationTechniqueRaw_17, t0.informationTechniqueFormater AS informationTechniqueFormater_18, t0.informationDocSupplementaire AS informationDocSupplementaire_19, t0.informationDocSupplementaireRaw AS informationDocSupplementaireRaw_20, t0.informationDocSupplementaireFormater AS informationDocSupplementaireFormater_21, t0.informationfacture AS informationfacture_22, t0.informationfactureRaw AS informationfactureRaw_23, t0.informationfactureFormater AS informationfactureFormater_24, t0.informationfacture2 AS informationfacture2_25, t0.informationfacture2Raw AS informationfacture2Raw_26, t0.informationfacture2Formater AS informationfacture2Formater_27, t0.nbMateriau AS nbMateriau_28, t0.materiauSubtitle AS materiauSubtitle_29, t0.materiauTitle AS materiauTitle_30, t0.textForm AS textForm_31, t0.private AS private_32, t0.campagne AS campagne_33, t0.special AS special_34, t0.abrogation_datetime AS abrogation_datetime_35, t0.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:
[
  1064
]
11 0.83 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.originalEmailName AS originalEmailName_4, t0.created_datetime AS created_datetime_5, t0.weight AS weight_6, t0.originalNeeded AS originalNeeded_7, t0.allowedUniverSign AS allowedUniverSign_8, t0.description AS description_9 FROM DocumentType t0 WHERE t0.id = ?
Parameters:
[
  473
]
12 0.82 ms
SELECT t0.id AS id_1, t0.frameId AS frameId_2, t0.operation_document_config_id AS operation_document_config_id_3, t0.oblige_id AS oblige_id_4 FROM operation_document_config_oblige_override t0 WHERE t0.operation_document_config_id = ?
Parameters:
[
  4
]
13 0.99 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.version AS version_3, t0.code AS code_4, t0.duree AS duree_5, t0.auto_installation AS auto_installation_6, t0.conditions AS conditions_7, t0.conditionsRaw AS conditionsRaw_8, t0.conditionsFormater AS conditionsFormater_9, t0.documents_requis AS documents_requis_10, t0.nombre_documents AS nombre_documents_11, t0.nombre_conditions AS nombre_conditions_12, t0.question_details_type AS question_details_type_13, t0.question_details_value AS question_details_value_14, t0.periode AS periode_15, t0.informationTechnique AS informationTechnique_16, t0.informationTechniqueRaw AS informationTechniqueRaw_17, t0.informationTechniqueFormater AS informationTechniqueFormater_18, t0.informationDocSupplementaire AS informationDocSupplementaire_19, t0.informationDocSupplementaireRaw AS informationDocSupplementaireRaw_20, t0.informationDocSupplementaireFormater AS informationDocSupplementaireFormater_21, t0.informationfacture AS informationfacture_22, t0.informationfactureRaw AS informationfactureRaw_23, t0.informationfactureFormater AS informationfactureFormater_24, t0.informationfacture2 AS informationfacture2_25, t0.informationfacture2Raw AS informationfacture2Raw_26, t0.informationfacture2Formater AS informationfacture2Formater_27, t0.nbMateriau AS nbMateriau_28, t0.materiauSubtitle AS materiauSubtitle_29, t0.materiauTitle AS materiauTitle_30, t0.textForm AS textForm_31, t0.private AS private_32, t0.campagne AS campagne_33, t0.special AS special_34, t0.abrogation_datetime AS abrogation_datetime_35, t0.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:
[
  1073
]
14 0.88 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.originalEmailName AS originalEmailName_4, t0.created_datetime AS created_datetime_5, t0.weight AS weight_6, t0.originalNeeded AS originalNeeded_7, t0.allowedUniverSign AS allowedUniverSign_8, t0.description AS description_9 FROM DocumentType t0 WHERE t0.id = ?
Parameters:
[
  471
]
15 0.76 ms
SELECT t0.id AS id_1, t0.frameId AS frameId_2, t0.operation_document_config_id AS operation_document_config_id_3, t0.oblige_id AS oblige_id_4 FROM operation_document_config_oblige_override t0 WHERE t0.operation_document_config_id = ?
Parameters:
[
  2
]
16 0.93 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.version AS version_3, t0.code AS code_4, t0.duree AS duree_5, t0.auto_installation AS auto_installation_6, t0.conditions AS conditions_7, t0.conditionsRaw AS conditionsRaw_8, t0.conditionsFormater AS conditionsFormater_9, t0.documents_requis AS documents_requis_10, t0.nombre_documents AS nombre_documents_11, t0.nombre_conditions AS nombre_conditions_12, t0.question_details_type AS question_details_type_13, t0.question_details_value AS question_details_value_14, t0.periode AS periode_15, t0.informationTechnique AS informationTechnique_16, t0.informationTechniqueRaw AS informationTechniqueRaw_17, t0.informationTechniqueFormater AS informationTechniqueFormater_18, t0.informationDocSupplementaire AS informationDocSupplementaire_19, t0.informationDocSupplementaireRaw AS informationDocSupplementaireRaw_20, t0.informationDocSupplementaireFormater AS informationDocSupplementaireFormater_21, t0.informationfacture AS informationfacture_22, t0.informationfactureRaw AS informationfactureRaw_23, t0.informationfactureFormater AS informationfactureFormater_24, t0.informationfacture2 AS informationfacture2_25, t0.informationfacture2Raw AS informationfacture2Raw_26, t0.informationfacture2Formater AS informationfacture2Formater_27, t0.nbMateriau AS nbMateriau_28, t0.materiauSubtitle AS materiauSubtitle_29, t0.materiauTitle AS materiauTitle_30, t0.textForm AS textForm_31, t0.private AS private_32, t0.campagne AS campagne_33, t0.special AS special_34, t0.abrogation_datetime AS abrogation_datetime_35, t0.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:
[
  1075
]
17 0.77 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.originalEmailName AS originalEmailName_4, t0.created_datetime AS created_datetime_5, t0.weight AS weight_6, t0.originalNeeded AS originalNeeded_7, t0.allowedUniverSign AS allowedUniverSign_8, t0.description AS description_9 FROM DocumentType t0 WHERE t0.id = ?
Parameters:
[
  71
]
18 2.34 ms
SELECT t0.id AS id_1, t0.frameId AS frameId_2, t0.operation_document_config_id AS operation_document_config_id_3, t0.oblige_id AS oblige_id_4 FROM operation_document_config_oblige_override t0 WHERE t0.operation_document_config_id = ?
Parameters:
[
  3
]

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\OperationDocumentConfig 5
Consoneo\Bundle\ObligeBundle\Entity\DocumentType 5
Consoneo\Bundle\SimulateurBundle\Entity\Operation 4
Consoneo\Bundle\SimulateurBundle\Entity\Simulateur 4
Consoneo\Bundle\UserBundle\Entity\Oblige 2
Consoneo\Bundle\ObligeBundle\Entity\OperationDocumentConfigObligeOverride 2
Consoneo\Bundle\ObligeBundle\Entity\Arrete 2
Consoneo\Bundle\FormGeneratorBundle\Form\Domain\Model\FormConfig 2
Consoneo\Bundle\UserBundle\Entity\ObligeUser 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.
C2eCoreBundle\Entity\Certificall\Certilink No errors.
Consoneo\Bundle\UserBundle\Entity\InstallateurCertificallConfig No errors.
Consoneo\Bundle\ObligeBundle\Entity\OperationDocumentConfig No errors.
Consoneo\Bundle\ObligeBundle\Entity\OperationDocumentConfigObligeOverride No errors.
Consoneo\Bundle\SimulateurBundle\Entity\Simulateur No errors.
Consoneo\Bundle\ObligeBundle\Entity\Certification No errors.
Consoneo\Bundle\UserBundle\Entity\Qualification No errors.
Consoneo\Bundle\FormGeneratorBundle\Form\Domain\Model\FormConfig No errors.
Consoneo\Bundle\SimulateurBundle\Entity\OperationQuestionItem No errors.
Consoneo\Bundle\SimulateurBundle\Entity\DataQuestion No errors.
Consoneo\Bundle\SimulateurBundle\Entity\SecteurActivite No errors.
Consoneo\Bundle\UserBundle\Entity\DomaineTravauxRGE No errors.
Consoneo\Bundle\UserBundle\Entity\Installateur No errors.
Consoneo\Bundle\UserBundle\Entity\Be No errors.
Consoneo\Bundle\ObligeBundle\Entity\ObligeOperation No errors.
Consoneo\Bundle\ObligeBundle\Entity\Program\Isolant No errors.
C2eCoreBundle\Entity\Internal\ProjectBundleOperation No errors.
C2eCoreBundle\Entity\Engine\ConstraintRule No errors.
C2eCoreBundle\Entity\Engine\MatrixDefinition No errors.
C2eCoreBundle\Entity\Engine\Formula No errors.
Consoneo\Bundle\UserBundle\Entity\InstallateurDocumentReference No errors.
Consoneo\Bundle\UserBundle\Entity\ObligeDocumentTypeConfig No errors.

read entity manager

Class Mapping errors
Consoneo\Bundle\UserBundle\Entity\ObligeUser No 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.