Query Metrics
6
Database Queries
4
Different statements
27.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
15.39 ms (55.01%) |
1 |
SELECT id FROM vs WHERE (status_id IN (3)) AND (rubrik_id IN (11)) AND ((typ_id =1 AND startdatum >='2095-07-22' AND startdatum <='2095-07-26')) ORDER BY startdatum asc, beginnzeit ASC
Parameters:
[] |
|
10.30 ms (36.82%) |
1 |
SELECT id FROM vs WHERE (status_id IN (3)) AND (rubrik_id IN (11)) AND ((typ_id =2 AND startdatum <= '2095-07-26' AND enddatum >= '2095-07-22') OR (typ_id =3 AND startdatum <= '2095-07-26' AND enddatum >= '2095-07-22')) ORDER BY startdatum desc, beginnzeit ASC
Parameters:
[] |
|
1.68 ms (6.02%) |
3 |
SELECT t0.code AS code_1, t0.contentHtml AS contentHtml_2, t0.content_html_editable AS content_html_editable_3, t0.content_text AS content_text_4, t0.content_text_editable AS content_text_editable_5, t0.content_description AS content_description_6, t0.content_image AS content_image_7, t0.content_image_editable AS content_image_editable_8, t0.edit_sysadmin_only AS edit_sysadmin_only_9, t0.is_visible_on_frontend AS is_visible_on_frontend_10, t0.edit_at AS edit_at_11, t0.id AS id_12 FROM content t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"ACCORDION_VERANSTALTUNGEN"
]
|
|
0.60 ms (2.16%) |
1 |
SELECT t0.id AS id_1, t0.rubrikname AS rubrikname_2, t0.beschreibung AS beschreibung_3 FROM vsrubrik t0 ORDER BY t0.rubrikname ASC
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\Vs\VsRubrik | No errors. |
| App\Entity\Vs\Vs | No errors. |
| App\Entity\Content\Content | No errors. |