GET https://eclectis.eu/index.php/blog/posts/category/general%20solar%20and%20storage%20news

Query Metrics

13 Database Queries
10 Different statements
7.55 ms Query time
0 Invalid entities
1 Managed entities

Grouped Statements

Show all queries

Time Count Info
1.10 ms
(14.52%)
2
SELECT a.id, a.name, a.url FROM blog_authors a
Parameters:
[]
1.04 ms
(13.79%)
2
SELECT COUNT(`id`) FROM `blog_posts_published_ids`
Parameters:
[]
0.89 ms
(11.75%)
2
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 AND m.approved = 1) 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(NULL)
Parameters:
[]
0.81 ms
(10.80%)
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 AND m.approved = 1) AS comments_count, (SELECT COUNT(i.id) FROM blog_post_images i WHERE i.post_id = p.id) AS images_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 (c.id = ?) AND (p.published = ?)) tmp
Parameters:
[
  3
  1
]
0.77 ms
(10.23%)
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 AND m.approved = 1) AS comments_count, (SELECT COUNT(i.id) FROM blog_post_images i WHERE i.post_id = p.id) AS images_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 (c.id = ?) AND (p.published = ?) ORDER BY p.priority, date desc LIMIT 10
Parameters:
[
  3
  1
]
0.67 ms
(8.83%)
1
SELECT id, name FROM blog_tag_names ORDER BY RAND() ASC LIMIT 19
Parameters:
[]
0.63 ms
(8.32%)
1
SELECT id FROM blog_posts WHERE (published = 1) AND (priority = 1) ORDER BY RAND() ASC LIMIT 7
Parameters:
[]
0.60 ms
(7.94%)
1
SELECT id FROM blog_posts WHERE (published = 1) AND (priority = 1) ORDER BY RAND() ASC LIMIT 2
Parameters:
[]
0.55 ms
(7.30%)
1
SELECT id, name FROM blog_categories
Parameters:
[]
0.49 ms
(6.52%)
1
SELECT t0.id AS id_1, t0.name AS name_2 FROM blog_categories t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "general solar and storage news"
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Model\Blog\Entity\Category\Category 1