Query Metrics
3
Database Queries
3
Different statements
7.22 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 3.08 ms |
ALTER SESSION SET NLS_TIME_FORMAT = 'HH24:MI:SS' NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH24:MI:SS TZH:TZM' NLS_NUMERIC_CHARACTERS = '.,' NLS_SORT = 'XSLOVAK' NLS_LENGTH_SEMANTICS = 'CHAR'
Parameters:
[] |
| 2 | 1.99 ms |
SELECT a.* FROM (SELECT t0.d_name AS D_NAME_1, t0.d_full_name AS D_FULL_NAME_2, t0.d_teaser AS D_TEASER_3, t0.d_description AS D_DESCRIPTION_4, t0.d_has_detail AS D_HAS_DETAIL_5, t0.d_public AS D_PUBLIC_6, t0.d_search AS D_SEARCH_7, t0.d_version AS D_VERSION_8, t0.d_code AS D_CODE_9, t0.d_seoId AS D_SEOID_10, t0.d_year AS D_YEAR_11, t0.d_icon AS D_ICON_12, t0.d_params AS D_PARAMS_13, t0.id AS ID_14, t0.visibility AS VISIBILITY_15, t0.isDeleted AS ISDELETED_16, t0.created_at AS CREATED_AT_17, t0.edited_at AS EDITED_AT_18 FROM cms_document t0 WHERE t0.d_seoId = ?) a WHERE ROWNUM <= 1
Parameters:
[
"i-monitorovacia-sprava-zo-zvf-5-2023"
]
|
| 3 | 2.15 ms |
SELECT t0.d_is_external AS D_IS_EXTERNAL_1, t0.d_url AS D_URL_2, t0.d_filename AS D_FILENAME_3, t0.d_size AS D_SIZE_4, t0.d_type AS D_TYPE_5, t0.d_language AS D_LANGUAGE_6, t0.d_info AS D_INFO_7, t0.d_is_current AS D_IS_CURRENT_8, t0.d_code AS D_CODE_9, t0.d_extension AS D_EXTENSION_10, t0.id AS ID_11, t0.visibility AS VISIBILITY_12, t0.isDeleted AS ISDELETED_13, t0.created_at AS CREATED_AT_14, t0.edited_at AS EDITED_AT_15, t0.document_id AS DOCUMENT_ID_16 FROM cms_document_file t0 WHERE t0.document_id = ? ORDER BY t0.created_at ASC
Parameters:
[
202
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
| Class | Mapping errors |
|---|---|
| Score\CmsBundle\Entity\Stat | No errors. |
| Score\CmsBundle\Entity\Document\Document | No errors. |
| Score\CmsBundle\Entity\Document\DocumentLevel | No errors. |
| Score\CmsBundle\Entity\Document\DocumentCategory | No errors. |
| Score\CmsBundle\Entity\Document\DocumentDescription | No errors. |
| Score\CmsBundle\Entity\Document\DocumentFile | No errors. |
| Score\CmsBundle\Entity\Access\Access | No errors. |
| Score\CmsBundle\Entity\Access\AccessDocument | No errors. |
| Score\CmsBundle\Entity\Block\BlockJoint | No errors. |
| Score\CmsBundle\Entity\Block\BlockJointDocument | No errors. |
| Score\CmsBundle\Entity\Metatag\Metatag | No errors. |
| Score\CmsBundle\Entity\Metatag\MetatagDocument | No errors. |