http://cms.stage.geocloud.sk/api/statistics

Query Metrics

1 Database Queries
1 Different statements
1828.61 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1828.61 ms
(100.00%)
1
SELECT s.source_title , s.source_type, s.source_id, a.id AS article_id, e.id AS event_id, p.id AS page_id, to_char(s.created_at,'YYYY-MM') AS month_stat, COUNT(*) AS hits
        FROM cms_stat s
        LEFT JOIN cms_article a ON s.source_id  =  a.slug AND s.source_type = 'score_public_articles_detail'
        LEFT JOIN cms_event e ON s.source_id  =  e.slug AND s.source_type = 'score_public_events_detail'
        LEFT JOIN cms_page p ON s.source_id  =  p.seo_id  AND s.source_type = 'subpage'
        GROUP BY month_stat,s.source_type, s.source_id,s.source_title, article_id, event_id, page_id
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
App\Entity\Api\Statistic No errors.
Score\CmsBundle\Entity\Stat No errors.