http://www.urnerwochenblatt.hostify2.webtech.ch/veranstaltungen/?d=29.11.2095&r=11

Query Metrics

6 Database Queries
4 Different statements
29.64 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
16.54 ms
(55.80%)
1
SELECT id FROM vs WHERE (status_id IN (3)) AND (rubrik_id IN (11)) AND ((typ_id =1 AND startdatum >='2095-11-29' AND startdatum <='2095-12-03')) ORDER BY startdatum asc, beginnzeit ASC
Parameters:
[]
10.36 ms
(34.95%)
1
SELECT id FROM vs WHERE (status_id IN (3)) AND (rubrik_id IN (11)) AND ((typ_id =2 AND startdatum <= '2095-12-03' AND enddatum >= '2095-11-29') OR (typ_id =3 AND startdatum <= '2095-12-03' AND enddatum >= '2095-11-29')) ORDER BY startdatum desc, beginnzeit ASC
Parameters:
[]
1.89 ms
(6.38%)
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.85 ms
(2.87%)
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.