http://cms.stage.geocloud.sk/api/articles?slug=vystupy-z-23-inspire-espus-skolenia-vizualizacie-ii-komunikacia

Query Metrics

5 Database Queries
5 Different statements
130.33 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

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.