Query Metrics
8
Database Queries
5
Different statements
0.75 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.28 ms |
SELECT DISTINCT s0_.id AS id_0, s0_.id AS id_1 FROM symfony_demo_comment s0_ ORDER BY s0_.id DESC LIMIT 20 OFFSET 60
Parameters:
[] |
| 2 | 0.08 ms |
SELECT s0_.id AS id_0, s0_.content AS content_1, s0_.published_at AS published_at_2, s0_.post_id AS post_id_3, s0_.author_id AS author_id_4 FROM symfony_demo_comment s0_ WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY s0_.id DESC
Parameters:
[ 90 89 88 87 86 85 84 83 82 81 80 79 78 77 76 75 74 73 72 71 ] |
| 3 | 0.09 ms |
SELECT count(s0_.id) AS sclr_0 FROM symfony_demo_comment s0_
Parameters:
[] |
| 4 | 0.05 ms |
SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.roles AS roles_6 FROM symfony_demo_user t0 WHERE t0.id = ?
Parameters:
[
3
]
|
| 5 | 0.08 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.summary AS summary_4, t0.content AS content_5, t0.published_at AS published_at_6, t0.author_id AS author_id_7 FROM symfony_demo_post t0 WHERE t0.id = ?
Parameters:
[
18
]
|
| 6 | 0.06 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.summary AS summary_4, t0.content AS content_5, t0.published_at AS published_at_6, t0.author_id AS author_id_7 FROM symfony_demo_post t0 WHERE t0.id = ?
Parameters:
[
17
]
|
| 7 | 0.06 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.summary AS summary_4, t0.content AS content_5, t0.published_at AS published_at_6, t0.author_id AS author_id_7 FROM symfony_demo_post t0 WHERE t0.id = ?
Parameters:
[
16
]
|
| 8 | 0.05 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.summary AS summary_4, t0.content AS content_5, t0.published_at AS published_at_6, t0.author_id AS author_id_7 FROM symfony_demo_post t0 WHERE t0.id = ?
Parameters:
[
15
]
|
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\Comment | No errors. |
| App\Entity\Post | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Tag | No errors. |