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
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
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. |