Query Metrics
4
Database Queries
4
Different statements
2.79 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
0.91 ms (32.52%) |
1 |
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.text AS text_2, e0_.picture AS picture_3, e0_.picture_size AS picture_size_4, e0_.updated_at AS updated_at_5, e0_.date AS date_6, e0_.place AS place_7, e0_.restricted AS restricted_8, e0_.contact AS contact_9 FROM event e0_ WHERE e0_.date > ? AND e0_.restricted = 0 ORDER BY e0_.date ASC LIMIT 4
Parameters:
[
"2024-11-18 18:41:14"
]
|
0.68 ms (24.58%) |
1 |
SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.date AS date_2, c0_.text AS text_3, c0_.picture AS picture_4, c0_.picture_size AS picture_size_5, c0_.updated_at AS updated_at_6, c0_.writer AS writer_7, c0_.category_id AS category_id_8 FROM content c0_ WHERE c0_.date < ? ORDER BY c0_.date DESC LIMIT 4
Parameters:
[
"2024-11-18 18:41:14"
]
|
0.60 ms (21.65%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM category t0
Parameters:
[] |
0.59 ms (21.25%) |
1 |
SELECT t0.id AS id_1, t0.document AS document_2, t0.document_size AS document_size_3, t0.annex AS annex_4, t0.annex_size AS annex_size_5, t0.updated_at AS updated_at_6, t0.date AS date_7 FROM report t0 ORDER BY t0.date DESC LIMIT 1
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\Event | No errors. |
App\Entity\Content | No errors. |
App\Entity\Category | No errors. |
App\Entity\NewspaperSubject2 | No errors. |
App\Entity\Report | No errors. |
App\Entity\ReportSubject | No errors. |
App\Entity\Newspaper2 | No errors. |
App\Entity\NewsletterEmail | No errors. |
App\Entity\Partyroom | No errors. |
App\Entity\Newspaper | No errors. |
App\Entity\Teammate | No errors. |
App\Entity\Vcard | No errors. |
App\Entity\Restaurant | No errors. |
App\Entity\User | No errors. |
App\Entity\NewspaperSubject | No errors. |
Vich\UploaderBundle\Entity\File | No errors. |