Query Metrics
5
Database Queries
4
Different statements
159.04 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
100.53 ms (63.21%) |
1 |
SELECT count(DISTINCT m0_.id) AS sclr_0 FROM magazines m0_
Parameters:
[] |
25.64 ms (16.12%) |
1 |
SELECT DISTINCT m0_.id AS id_0, m0_.id AS id_1 FROM magazines m0_ ORDER BY m0_.id ASC LIMIT 20
Parameters:
[] |
18.40 ms (11.57%) |
2 |
SELECT t0.id AS id_1, t0.number AS number_2, t0.title AS title_3, t0.slug AS slug_4, t0.description AS description_5, t0.month AS month_6, t0.year AS year_7, t0.pages AS pages_8, t0.price AS price_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.magazine_id AS magazine_id_12, t0.created_by AS created_by_13, t0.updated_by AS updated_by_14 FROM magazine_issues t0 WHERE t0.magazine_id = ?
Parameters:
[
1
]
|
14.47 ms (9.10%) |
1 |
SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.slug AS slug_2, m0_.description AS description_3, m0_.year AS year_4, m0_.orientation AS orientation_5, m0_.dimensions AS dimensions_6, m0_.weight AS weight_7, m0_.created_at AS created_at_8, m0_.updated_at AS updated_at_9, m0_.created_by AS created_by_10, m0_.updated_by AS updated_by_11 FROM magazines m0_ WHERE m0_.id IN (?, ?) ORDER BY m0_.id ASC
Parameters:
[ 1 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\Entity\Magazine | No errors. |
App\Entity\User | No errors. |
App\Entity\MagazineLink | No errors. |
App\Entity\MagazineImage | No errors. |
App\Entity\MagazineIssue | No errors. |
App\Entity\MagazineIssueLink | No errors. |
App\Entity\MagazineIssueImage | No errors. |