http://www.urnerwochenblatt.hostify2.webtech.ch/veranstaltungen/?d=11.08.2095&r=10

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
8.97 ms
(55.64%)
1
SELECT id FROM vs WHERE (status_id IN (3)) AND (rubrik_id IN (10)) AND ((typ_id =1 AND startdatum >='2095-08-11' AND startdatum <='2095-08-15')) ORDER BY startdatum asc, beginnzeit ASC
Parameters:
[]
5.06 ms
(31.39%)
1
SELECT id FROM vs WHERE (status_id IN (3)) AND (rubrik_id IN (10)) AND ((typ_id =2 AND startdatum <= '2095-08-15' AND enddatum >= '2095-08-11') OR (typ_id =3 AND startdatum <= '2095-08-15' AND enddatum >= '2095-08-11')) ORDER BY startdatum desc, beginnzeit ASC
Parameters:
[]
1.60 ms
(9.94%)
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.49 ms
(3.04%)
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.