http://www.urnerwochenblatt.hostify2.webtech.ch/veranstaltungen/?d=26.08.2095&r=14

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
11.06 ms
(52.96%)
1
SELECT id FROM vs WHERE (status_id IN (3)) AND (rubrik_id IN (14)) AND ((typ_id =1 AND startdatum >='2095-08-26' AND startdatum <='2095-08-30')) ORDER BY startdatum asc, beginnzeit ASC
Parameters:
[]
7.55 ms
(36.17%)
1
SELECT id FROM vs WHERE (status_id IN (3)) AND (rubrik_id IN (14)) AND ((typ_id =2 AND startdatum <= '2095-08-30' AND enddatum >= '2095-08-26') OR (typ_id =3 AND startdatum <= '2095-08-30' AND enddatum >= '2095-08-26')) ORDER BY startdatum desc, beginnzeit ASC
Parameters:
[]
1.64 ms
(7.83%)
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.63 ms
(3.03%)
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.