GET https://testportal.netzb-w.de/

Query Metrics

46 Database Queries
8 Different statements
8.75 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.65 ms
SELECT t0.id AS id_1, t0.metakey AS metakey_2, t0.metavalue AS metavalue_3, t0.mandantenid AS mandantenid_4 FROM settings t0 WHERE t0.metakey = ? LIMIT 1
Parameters:
[
  "sessiontimeout"
]
2 0.20 ms
SELECT t0.id AS id_1, t0.metakey AS metakey_2, t0.metavalue AS metavalue_3, t0.mandantenid AS mandantenid_4 FROM settings t0 WHERE t0.metakey = ? LIMIT 1
Parameters:
[
  "portalonline"
]
3 0.16 ms
SELECT t0.id AS id_1, t0.metakey AS metakey_2, t0.metavalue AS metavalue_3, t0.mandantenid AS mandantenid_4 FROM settings t0 WHERE t0.metakey = ? LIMIT 1
Parameters:
[
  "wartungsarbeiten"
]
4 0.15 ms
SELECT t0.id AS id_1, t0.metakey AS metakey_2, t0.metavalue AS metavalue_3, t0.mandantenid AS mandantenid_4 FROM settings t0 WHERE t0.metakey = ? LIMIT 1
Parameters:
[
  "authentifizierung"
]
5 0.16 ms
SELECT t0.id AS id_1, t0.metakey AS metakey_2, t0.metavalue AS metavalue_3, t0.mandantenid AS mandantenid_4 FROM settings t0 WHERE t0.metakey = ? LIMIT 1
Parameters:
[
  "2fa"
]
6 0.16 ms
SELECT t0.id AS id_1, t0.metakey AS metakey_2, t0.metavalue AS metavalue_3, t0.mandantenid AS mandantenid_4 FROM settings t0 WHERE t0.metakey = ? LIMIT 1
Parameters:
[
  "portalvariante"
]
7 0.17 ms
SELECT t0.id AS id_1, t0.metakey AS metakey_2, t0.metavalue AS metavalue_3, t0.mandantenid AS mandantenid_4 FROM settings t0 WHERE t0.metakey = ? LIMIT 1
Parameters:
[
  "kuendigung"
]
8 0.16 ms
SELECT t0.id AS id_1, t0.metakey AS metakey_2, t0.metavalue AS metavalue_3, t0.mandantenid AS mandantenid_4 FROM settings t0 WHERE t0.metakey = ? LIMIT 1
Parameters:
[
  "tarifrechner"
]
9 0.16 ms
SELECT t0.id AS id_1, t0.metakey AS metakey_2, t0.metavalue AS metavalue_3, t0.mandantenid AS mandantenid_4 FROM settings t0 WHERE t0.metakey = ? LIMIT 1
Parameters:
[
  "zaehlerstandmelden_abgemeldet"
]
10 0.15 ms
SELECT t0.id AS id_1, t0.metakey AS metakey_2, t0.metavalue AS metavalue_3, t0.mandantenid AS mandantenid_4 FROM settings t0 WHERE t0.metakey = ? LIMIT 1
Parameters:
[
  "output"
]
11 0.18 ms
SELECT t0.id AS id_1, t0.metakey AS metakey_2, t0.beschreibung AS beschreibung_3, t0.metavalue AS metavalue_4, t0.type AS type_5, t0.mandantenid AS mandantenid_6 FROM portalsettings t0 WHERE t0.metakey = ? LIMIT 1
Parameters:
[
  "abmelden"
]
12 0.18 ms
SELECT t0.id AS id_1, t0.metakey AS metakey_2, t0.beschreibung AS beschreibung_3, t0.metavalue AS metavalue_4, t0.type AS type_5, t0.mandantenid AS mandantenid_6 FROM portalsettings t0 WHERE t0.metakey = ? LIMIT 1
Parameters:
[
  "zaehlerstandsmeldung_aktiv_text"
]
13 0.18 ms
SELECT t0.id AS id_1, t0.metakey AS metakey_2, t0.beschreibung AS beschreibung_3, t0.metavalue AS metavalue_4, t0.type AS type_5, t0.mandantenid AS mandantenid_6 FROM portalsettings t0 WHERE t0.metakey = ? LIMIT 1
Parameters:
[
  "zaehlerstandsmeldung_aktiv_startdatum"
]
14 0.18 ms
SELECT t0.id AS id_1, t0.metakey AS metakey_2, t0.beschreibung AS beschreibung_3, t0.metavalue AS metavalue_4, t0.type AS type_5, t0.mandantenid AS mandantenid_6 FROM portalsettings t0 WHERE t0.metakey = ? LIMIT 1
Parameters:
[
  "zaehlerstandsmeldung_aktiv_enddatum"
]
15 0.18 ms
SELECT t0.id AS id_1, t0.metakey AS metakey_2, t0.beschreibung AS beschreibung_3, t0.metavalue AS metavalue_4, t0.type AS type_5, t0.mandantenid AS mandantenid_6 FROM portalsettings t0 WHERE t0.metakey = ? LIMIT 1
Parameters:
[
  "logo"
]
16 0.21 ms
SELECT t0.id AS id_1, t0.metakey AS metakey_2, t0.beschreibung AS beschreibung_3, t0.metavalue AS metavalue_4, t0.type AS type_5, t0.mandantenid AS mandantenid_6 FROM portalsettings t0 WHERE t0.metakey = ? LIMIT 1
Parameters:
[
  "logo-graustufen"
]
17 0.18 ms
SELECT t0.id AS id_1, t0.metakey AS metakey_2, t0.beschreibung AS beschreibung_3, t0.metavalue AS metavalue_4, t0.type AS type_5, t0.mandantenid AS mandantenid_6 FROM portalsettings t0 WHERE t0.metakey = ? LIMIT 1
Parameters:
[
  "logo-schwarzweiss"
]
18 0.18 ms
SELECT t0.id AS id_1, t0.metakey AS metakey_2, t0.beschreibung AS beschreibung_3, t0.metavalue AS metavalue_4, t0.type AS type_5, t0.mandantenid AS mandantenid_6 FROM portalsettings t0 WHERE t0.metakey = ? LIMIT 1
Parameters:
[
  "logo-print"
]
19 0.19 ms
SELECT t0.id AS id_1, t0.metakey AS metakey_2, t0.beschreibung AS beschreibung_3, t0.metavalue AS metavalue_4, t0.type AS type_5, t0.mandantenid AS mandantenid_6 FROM portalsettings t0 WHERE t0.metakey = ? LIMIT 1
Parameters:
[
  "favicon"
]
20 0.17 ms
SELECT t0.id AS id_1, t0.metakey AS metakey_2, t0.beschreibung AS beschreibung_3, t0.metavalue AS metavalue_4, t0.type AS type_5, t0.mandantenid AS mandantenid_6 FROM portalsettings t0 WHERE t0.metakey = ? LIMIT 1
Parameters:
[
  "logo-position-startseite"
]
21 0.18 ms
SELECT t0.id AS id_1, t0.metakey AS metakey_2, t0.beschreibung AS beschreibung_3, t0.metavalue AS metavalue_4, t0.type AS type_5, t0.mandantenid AS mandantenid_6 FROM portalsettings t0 WHERE t0.metakey = ? LIMIT 1
Parameters:
[
  "link_logo"
]
22 0.17 ms
SELECT t0.id AS id_1, t0.metakey AS metakey_2, t0.beschreibung AS beschreibung_3, t0.metavalue AS metavalue_4, t0.type AS type_5, t0.mandantenid AS mandantenid_6 FROM portalsettings t0 WHERE t0.metakey = ? LIMIT 1
Parameters:
[
  "zustellarten_leeroption"
]
23 0.17 ms
SELECT t0.id AS id_1, t0.metakey AS metakey_2, t0.beschreibung AS beschreibung_3, t0.metavalue AS metavalue_4, t0.type AS type_5, t0.mandantenid AS mandantenid_6 FROM portalsettings t0 WHERE t0.metakey = ? LIMIT 1
Parameters:
[
  "zustellarten_standardoption"
]
24 0.18 ms
SELECT t0.id AS id_1, t0.metakey AS metakey_2, t0.betreff AS betreff_3, t0.inhalt AS inhalt_4, t0.absender AS absender_5, t0.mandantenid AS mandantenid_6 FROM mailtexte t0 WHERE t0.metakey = ? LIMIT 1
Parameters:
[
  "signatur_druckendialog"
]
25 0.17 ms
SELECT t0.id AS id_1, t0.metakey AS metakey_2, t0.metavalue AS metavalue_3, t0.mandantenid AS mandantenid_4 FROM texte t0
Parameters:
[]
26 0.18 ms
SELECT t0.id AS id_1, t0.metakey AS metakey_2, t0.metavalue AS metavalue_3, t0.type AS type_4, t0.active AS active_5, t0.mandantenid AS mandantenid_6 FROM auswahllisten t0 WHERE t0.type = ?
Parameters:
[
  "abschlagsaenderung"
]
27 0.15 ms
SELECT t0.id AS id_1, t0.metakey AS metakey_2, t0.metavalue AS metavalue_3, t0.mandantenid AS mandantenid_4 FROM settings t0 WHERE t0.metakey = ? LIMIT 1
Parameters:
[
  "wsurl"
]
28 0.16 ms
SELECT t0.id AS id_1, t0.metakey AS metakey_2, t0.metavalue AS metavalue_3, t0.mandantenid AS mandantenid_4 FROM settings t0 WHERE t0.metakey = ? LIMIT 1
Parameters:
[
  "mandant"
]
29 0.15 ms
SELECT t0.id AS id_1, t0.metakey AS metakey_2, t0.metavalue AS metavalue_3, t0.mandantenid AS mandantenid_4 FROM settings t0 WHERE t0.metakey = ? LIMIT 1
Parameters:
[
  "nutzer"
]
30 0.15 ms
SELECT t0.id AS id_1, t0.metakey AS metakey_2, t0.metavalue AS metavalue_3, t0.mandantenid AS mandantenid_4 FROM settings t0 WHERE t0.metakey = ? LIMIT 1
Parameters:
[
  "passwort"
]
31 0.39 ms
SELECT t0.id AS id_1, t0.metakey AS metakey_2, t0.metavalue AS metavalue_3, t0.mandantenid AS mandantenid_4 FROM settings t0 WHERE t0.metakey = ? LIMIT 1
Parameters:
[
  "wsurl"
]
32 0.15 ms
SELECT t0.id AS id_1, t0.metakey AS metakey_2, t0.metavalue AS metavalue_3, t0.mandantenid AS mandantenid_4 FROM settings t0 WHERE t0.metakey = ? LIMIT 1
Parameters:
[
  "mandant"
]
33 0.16 ms
SELECT t0.id AS id_1, t0.metakey AS metakey_2, t0.metavalue AS metavalue_3, t0.mandantenid AS mandantenid_4 FROM settings t0 WHERE t0.metakey = ? LIMIT 1
Parameters:
[
  "nutzer"
]
34 0.15 ms
SELECT t0.id AS id_1, t0.metakey AS metakey_2, t0.metavalue AS metavalue_3, t0.mandantenid AS mandantenid_4 FROM settings t0 WHERE t0.metakey = ? LIMIT 1
Parameters:
[
  "passwort"
]
35 0.44 ms
SELECT t0.id AS id_1, t0.produktcode AS produktcode_2, t0.bezeichnung AS bezeichnung_3, t0.link AS link_4, t0.datei AS datei_5, t0.mandantenid AS mandantenid_6 FROM links t0 WHERE t0.produktcode = ? AND t0.mandantenid IS NULL LIMIT 1
Parameters:
[
  "impressum"
]
36 0.17 ms
SELECT t0.id AS id_1, t0.produktcode AS produktcode_2, t0.bezeichnung AS bezeichnung_3, t0.link AS link_4, t0.datei AS datei_5, t0.mandantenid AS mandantenid_6 FROM links t0 WHERE t0.produktcode = ? LIMIT 1
Parameters:
[
  "impressum"
]
37 0.17 ms
SELECT t0.id AS id_1, t0.produktcode AS produktcode_2, t0.bezeichnung AS bezeichnung_3, t0.link AS link_4, t0.datei AS datei_5, t0.mandantenid AS mandantenid_6 FROM links t0 WHERE t0.produktcode = ? AND t0.mandantenid IS NULL LIMIT 1
Parameters:
[
  "datenschutz"
]
38 0.17 ms
SELECT t0.id AS id_1, t0.produktcode AS produktcode_2, t0.bezeichnung AS bezeichnung_3, t0.link AS link_4, t0.datei AS datei_5, t0.mandantenid AS mandantenid_6 FROM links t0 WHERE t0.produktcode = ? LIMIT 1
Parameters:
[
  "datenschutz"
]
39 0.16 ms
SELECT t0.id AS id_1, t0.produktcode AS produktcode_2, t0.bezeichnung AS bezeichnung_3, t0.link AS link_4, t0.datei AS datei_5, t0.mandantenid AS mandantenid_6 FROM links t0 WHERE t0.produktcode = ? AND t0.mandantenid IS NULL LIMIT 1
Parameters:
[
  "nutzungsbedingungen"
]
40 0.15 ms
SELECT t0.id AS id_1, t0.produktcode AS produktcode_2, t0.bezeichnung AS bezeichnung_3, t0.link AS link_4, t0.datei AS datei_5, t0.mandantenid AS mandantenid_6 FROM links t0 WHERE t0.produktcode = ? LIMIT 1
Parameters:
[
  "nutzungsbedingungen"
]
41 0.17 ms
SELECT t0.id AS id_1, t0.produktcode AS produktcode_2, t0.bezeichnung AS bezeichnung_3, t0.link AS link_4, t0.datei AS datei_5, t0.mandantenid AS mandantenid_6 FROM links t0 WHERE t0.produktcode = ? AND t0.mandantenid IS NULL LIMIT 1
Parameters:
[
  "barrierefreiheit"
]
42 0.17 ms
SELECT t0.id AS id_1, t0.produktcode AS produktcode_2, t0.bezeichnung AS bezeichnung_3, t0.link AS link_4, t0.datei AS datei_5, t0.mandantenid AS mandantenid_6 FROM links t0 WHERE t0.produktcode = ? LIMIT 1
Parameters:
[
  "barrierefreiheit"
]
43 0.16 ms
SELECT t0.id AS id_1, t0.produktcode AS produktcode_2, t0.bezeichnung AS bezeichnung_3, t0.link AS link_4, t0.datei AS datei_5, t0.mandantenid AS mandantenid_6 FROM links t0 WHERE t0.produktcode = ? AND t0.mandantenid IS NULL LIMIT 1
Parameters:
[
  "hilfe"
]
44 0.16 ms
SELECT t0.id AS id_1, t0.produktcode AS produktcode_2, t0.bezeichnung AS bezeichnung_3, t0.link AS link_4, t0.datei AS datei_5, t0.mandantenid AS mandantenid_6 FROM links t0 WHERE t0.produktcode = ? LIMIT 1
Parameters:
[
  "hilfe"
]
45 0.18 ms
SELECT t0.id AS id_1, t0.metakey AS metakey_2, t0.betreff AS betreff_3, t0.inhalt AS inhalt_4, t0.absender AS absender_5, t0.mandantenid AS mandantenid_6 FROM mailtexte t0 WHERE t0.metakey = ? AND t0.mandantenid IS NULL LIMIT 1
Parameters:
[
  "signatur"
]
46 0.16 ms
SELECT t0.id AS id_1, t0.metakey AS metakey_2, t0.betreff AS betreff_3, t0.inhalt AS inhalt_4, t0.absender AS absender_5, t0.mandantenid AS mandantenid_6 FROM mailtexte t0 WHERE t0.metakey = ? LIMIT 1
Parameters:
[
  "signatur"
]

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\Settings No errors.
App\Entity\Portalsettings No errors.
App\Entity\Mailtexte No errors.
App\Entity\Texte No errors.
App\Entity\Auswahllisten No errors.
App\Entity\Links No errors.