Query Metrics
3
Database Queries
3
Different statements
8.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
4.17 ms (51.27%) |
1 |
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.00 ms (24.55%) |
1 |
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:
[
"zoznam-vyradenych-projektovych-zamerov-zvf-6-2024-pdf"
]
|
|
1.97 ms (24.18%) |
1 |
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:
[
184
]
|
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. |