GET https://eclectis.eu/blog/posts/page/1

Query Metrics

16 Database Queries
10 Different statements
45.38 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
17.68 ms
(38.95%)
1
SELECT COUNT(*) FROM (SELECT p.id, p.title, p.cover, p.text, p.url, p.published, p.date, c.id AS category_id, c.name AS category_name, a.url AS author_url, a.name AS author_name, a.avatar AS author_avatar, (SELECT COUNT(m.id) FROM blog_post_comments m WHERE m.post_id = p.id) AS comments_count FROM blog_posts p INNER JOIN blog_categories c ON p.category_id = c.id INNER JOIN blog_authors a ON p.author_id = a.id WHERE p.published = ? ORDER BY date desc) tmp
Parameters:
[
  1
]
17.58 ms
(38.74%)
1
SELECT p.id, p.title, p.cover, p.text, p.url, p.published, p.date, c.id AS category_id, c.name AS category_name, a.url AS author_url, a.name AS author_name, a.avatar AS author_avatar, (SELECT COUNT(m.id) FROM blog_post_comments m WHERE m.post_id = p.id) AS comments_count FROM blog_posts p INNER JOIN blog_categories c ON p.category_id = c.id INNER JOIN blog_authors a ON p.author_id = a.id WHERE p.published = ? ORDER BY date desc LIMIT 10
Parameters:
[
  1
]
2.17 ms
(4.77%)
3
SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 2
Parameters:
[]
1.94 ms
(4.27%)
3
SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 1
Parameters:
[]
1.71 ms
(3.77%)
2
SELECT COUNT(`id`) FROM `published_blog_posts_ids`
Parameters:
[]
1.57 ms
(3.46%)
2
SELECT a.id, a.name, a.url FROM blog_authors a
Parameters:
[]
0.82 ms
(1.82%)
1
SELECT id, name FROM blog_tag_names ORDER BY RAND() ASC LIMIT 14
Parameters:
[]
0.70 ms
(1.55%)
1
SELECT p.url, p.title, p.cover, p.date, c.id AS category_id, c.name AS category_name, a.name AS author_name, a.url AS author_url, (SELECT COUNT(m.id) FROM blog_post_comments m WHERE m.post_id = p.id) AS comments_count FROM blog_posts p INNER JOIN blog_authors a ON p.author_id = a.id INNER JOIN blog_categories c ON p.category_id = c.id WHERE p.id IN(?, ?)
Parameters:
[
  1
  2
]
0.67 ms
(1.47%)
1
SELECT id, name FROM blog_categories
Parameters:
[]
0.54 ms
(1.20%)
1
SELECT p.url, p.title, p.cover, p.date, c.id AS category_id, c.name AS category_name, a.name AS author_name, a.url AS author_url, (SELECT COUNT(m.id) FROM blog_post_comments m WHERE m.post_id = p.id) AS comments_count FROM blog_posts p INNER JOIN blog_authors a ON p.author_id = a.id INNER JOIN blog_categories c ON p.category_id = c.id WHERE p.id IN(?)
Parameters:
[
  2
]

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\Model\Entity\User\Name No errors.
App\Model\Entity\User\Location No errors.
App\Model\Entity\User\User No errors.