Query Metrics
1
Database Queries
1
Different statements
1828.61 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1828.61 ms |
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. |