Query Metrics
6
Database Queries
6
Different statements
9.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.79 ms (28.70%) |
1 |
INSERT INTO cms_stat (id, created_at, browser, source_type, stat_type, source_id, referer, source_url, source_title, session_id, visibility, isDeleted, edited_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 167094 "2026-10-24 08:58:20" "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; Amazonbot/0.1; +https://developer.amazon.com/support/amazonbot) Chrome/119.0.6045.214 Safari/537.36" "score_public_articles_list" "request" "" null "/clanky/?amp=&p=1%3D" "" null 1 0 "2026-10-24 08:58:20" ] |
|
2.27 ms (23.37%) |
1 |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT ID_14 FROM (SELECT c0_.name AS NAME_0, c0_.icon AS ICON_1, c0_.teaser AS TEASER_2, c0_.body AS BODY_3, c0_.published AS PUBLISHED_4, c0_.created_by AS CREATED_BY_5, c0_.priority AS PRIORITY_6, c0_.author AS AUTHOR_7, c0_.published_from AS PUBLISHED_FROM_8, c0_.published_to AS PUBLISHED_TO_9, c0_.slug AS SLUG_10, c0_.seo_title AS SEO_TITLE_11, c0_.metadata AS METADATA_12, c0_.search AS SEARCH_13, c0_.id AS ID_14, c0_.visibility AS VISIBILITY_15, c0_.isDeleted AS ISDELETED_16, c0_.created_at AS CREATED_AT_17, c0_.edited_at AS EDITED_AT_18 FROM cms_article c0_ WHERE c0_.published = ? AND (c0_.isDeleted = 0 OR c0_.isDeleted IS NULL) AND ((c0_.published_from < ? OR c0_.published_from IS NULL) AND (c0_.published_to > ? OR c0_.published_to IS NULL)) ORDER BY c0_.priority DESC, c0_.published_from DESC, c0_.name ASC) dctrn_result) dctrn_table
Parameters:
[ 1 "2026-10-24 08:58:21" "2026-10-24 08:58:21" ] |
|
1.69 ms (17.40%) |
1 |
"COMMIT"
Parameters:
[] |
|
1.60 ms (16.41%) |
1 |
SELECT cms_stat_id_seq.nextval FROM DUAL
Parameters:
[] |
|
1.25 ms (12.86%) |
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:
[] |
|
0.12 ms (1.25%) |
1 |
"START TRANSACTION"
Parameters:
[] |
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\Article\Article | No errors. |
| Score\CmsBundle\Entity\Multisite\SiteItem | No errors. |
| Score\CmsBundle\Entity\Multisite\SiteItemArticle | No errors. |
| Score\CmsBundle\Entity\Article\ArticleCategory | No errors. |
| Score\CmsBundle\Entity\Access\Access | No errors. |
| Score\CmsBundle\Entity\Access\AccessArticle | No errors. |
| Score\CmsBundle\Entity\Block\BlockJoint | No errors. |
| Score\CmsBundle\Entity\Block\BlockJointArticle | No errors. |
| Score\CmsBundle\Entity\Metatag\Metatag | No errors. |
| Score\CmsBundle\Entity\Metatag\MetatagArticle | No errors. |