Query Metrics
5
Database Queries
5
Different statements
130.33 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
61.99 ms (47.56%) |
1 |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.icon AS icon_2, c0_.teaser AS teaser_3, c0_.body AS body_4, c0_.published AS published_5, c0_.created_by AS created_by_6, c0_.priority AS priority_7, c0_.author AS author_8, c0_.published_from AS published_from_9, c0_.published_to AS published_to_10, c0_.slug AS slug_11, c0_.seo_title AS seo_title_12, c0_.metadata AS metadata_13, c0_.search AS search_14, c0_.category AS category_15, c0_.visibility AS visibility_16, c0_.created_at AS created_at_17, c0_.edited_at AS edited_at_18, c0_.last_check_at AS last_check_at_19, c0_.next_check_at AS next_check_at_20 FROM cms_article c0_ LEFT JOIN cms_site_items c1_ ON c0_.id = c1_.item_id AND c1_.item_type IN ('article') LEFT JOIN cms_language_info c2_ ON (c0_.id = c2_.entity_id AND c2_.entity_name = 'Article') WHERE c0_.slug = ? LIMIT 20
Parameters:
[
"vystupy-z-23-inspire-espus-skolenia-vizualizacie-ii-komunikacia"
]
|
56.16 ms (43.09%) |
1 |
SELECT to_char(created_at,'YYYY-MM') AS month_stat, COUNT(*) AS hits FROM cms_stat WHERE source_id = :source_id AND source_type = 'score_public_articles_detail' GROUP BY month_stat
Parameters:
[ "source_id" => "vystupy-z-23-inspire-espus-skolenia-vizualizacie-ii-komunikacia" ] |
4.64 ms (3.56%) |
1 |
SELECT t0.id AS id_1, t0.item_id AS item_id_2, t0.visibility AS visibility_3, t0.created_at AS created_at_4, t0.edited_at AS edited_at_5, t0.last_check_at AS last_check_at_6, t0.next_check_at AS next_check_at_7, t0.item_id AS item_id_8, t0.site_id AS site_id_9, t0.item_type FROM cms_site_items t0 WHERE t0.item_id = ? AND t0.item_type IN ('article')
Parameters:
[
397
]
|
4.30 ms (3.30%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.visibility AS visibility_4, t0.created_at AS created_at_5, t0.edited_at AS edited_at_6, t0.last_check_at AS last_check_at_7, t0.next_check_at AS next_check_at_8 FROM cms_site t0 WHERE t0.id = ?
Parameters:
[
1
]
|
3.25 ms (2.49%) |
1 |
SELECT COUNT(c0_.id) AS sclr_0 FROM cms_article c0_ LEFT JOIN cms_site_items c1_ ON c0_.id = c1_.item_id AND c1_.item_type IN ('article') LEFT JOIN cms_language_info c2_ ON (c0_.id = c2_.entity_id AND c2_.entity_name = 'Article') WHERE c0_.slug = ?
Parameters:
[
"vystupy-z-23-inspire-espus-skolenia-vizualizacie-ii-komunikacia"
]
|
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 |
---|---|
App\Entity\Api\Article | No errors. |
Score\CmsBundle\Entity\Article | No errors. |
Score\CmsBundle\Entity\Multisite\SiteItem | No errors. |
Score\CmsBundle\Entity\Multisite\SiteItemArticle | No errors. |
App\Entity\LanguageInfo | No errors. |
Score\CmsBundle\Entity\Multisite\Site | No errors. |
Score\CmsBundle\Entity\Stat | No errors. |