GET https://to3-abnahme.tourone.de/backend/cms/layout?XDEBUG_SESSION_START=PHPSTORM&code=MC-Login-Intro

Query Metrics

27 Database Queries
22 Different statements
13.96 ms Query time
0 Invalid entities
62 Managed entities

Grouped Statements

Show all queries

default connection

Time▼ Count Info
2.32 ms
(16.64%)
4
SELECT t0.deleted_at AS deleted_at_1, t0.anlage_datum AS anlage_datum_2, t0.aenderung_datum AS aenderung_datum_3, t0.aktiv AS aktiv_4, t0.sb_name AS sb_name_5, t0.gruppe AS gruppe_6, t0.name AS name_7, t0.beschreibung AS beschreibung_8, t0.value AS value_9, t0.type AS type_10, t0.sb_user AS sb_user_11 FROM parameter t0 WHERE t0.name = ? AND t0.gruppe = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
  "ERLAUBTE_LAENDER"
  "Viator"
]
1.45 ms
(10.37%)
3
SELECT t0.id AS id_1, t0.allow_edit AS allow_edit_2, t0.allow_delete AS allow_delete_3, t0.right_id AS right_id_4, t0.role_id AS role_id_5 FROM role_right t0 WHERE t0.role_id = ?
Parameters:
[
  1
]
0.76 ms
(5.42%)
1
SELECT t0.deleted_at AS deleted_at_1, t0.anlage_datum AS anlage_datum_2, t0.aenderung_datum AS aenderung_datum_3, t0.aktiv AS aktiv_4, t0.sb_name AS sb_name_5, t0.tempFlag AS tempFlag_6, t0.deleteFlag AS deleteFlag_7, t0.id AS id_8, t0.username AS username_9, t0.vorname AS vorname_10, t0.nachname AS nachname_11, t0.password AS password_12, t0.email AS email_13, t0.to_user AS to_user_14, t0.auth_counter AS auth_counter_15, t0.auth_sperre AS auth_sperre_16, t0.telefonnummer AS telefonnummer_17, t0.kuerzel AS kuerzel_18, t0.veroeffentlichen AS veroeffentlichen_19, t0.geburtstag AS geburtstag_20, t0.letzter_login AS letzter_login_21, t0.letzte_passwort_aenderung AS letzte_passwort_aenderung_22, t0.text AS text_23, t0.signatur_email AS signatur_email_24, t0.token AS token_25, t0.to2_token AS to2_token_26, t0.langdock_api_key AS langdock_api_key_27, t0.website_user AS website_user_28, t0.sb_user AS sb_user_29, t0.geschlecht_id AS geschlecht_id_30, t0.sprache_id AS sprache_id_31, t0.abteilung_id AS abteilung_id_32 FROM user t0 WHERE t0.token = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
  "qkTJjXyKOG3D8Eqqn6RBf4Y9Mi0pfTnKDmOE9tKYSOYxMnoVe0KNkL9wGg3I9YtqNcxItOMrvtqdhqpWxsJRDCamzr7isg8njocvzpbK2YbmyUgsVUc2gR0RuhbbBxJUTYbsREHmKNpWBJwVoEwBLB4nAcWvK4PoyDWKiv3ZQVgsds46oQemyOU4lr4GcG8tsD1fy9iBoLRd70PAhFokd7Xs01M27vowCon5Ye9A0j3zE68Q3Gos2E4ckflyS37VdxsvDE4vt7kclunbm3PfIU55AIrGKCMwEtUuQNHoSBysdDHkBjmx6nUc6sF8c4eHJZOcyL6ZZ36qXeq1aM9ioL5aFCtpQvQQ4VSwjg8kNnn09hMAdhVTQgcxALM0TqeriusSjyVpkmxOa3231231"
]
0.64 ms
(4.56%)
1
SELECT t0.deleted_at AS deleted_at_1, t0.anlage_datum AS anlage_datum_2, t0.aenderung_datum AS aenderung_datum_3, t0.aktiv AS aktiv_4, t0.sb_name AS sb_name_5, t0.tempFlag AS tempFlag_6, t0.deleteFlag AS deleteFlag_7, t0.id AS id_8, t0.rang AS rang_9, t0.text AS text_10, t0.headline_level AS headline_level_11, t0.sb_user AS sb_user_12, t0.zeile_id AS zeile_id_13, t0.type_id AS type_id_14, t0.wac_template_id AS wac_template_id_15, t0.textbaustein_id AS textbaustein_id_16, t0.paket_id AS paket_id_17, t0.reiseobjekt_id AS reiseobjekt_id_18, t0.filter_regel_id AS filter_regel_id_19 FROM layout_bereich_zeile_element t0 WHERE t0.zeile_id = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.rang ASC
Parameters:
[
  132
]
0.64 ms
(4.55%)
1
SELECT t0.deleted_at AS deleted_at_1, t0.anlage_datum AS anlage_datum_2, t0.aenderung_datum AS aenderung_datum_3, t0.aktiv AS aktiv_4, t0.sb_name AS sb_name_5, t0.tempFlag AS tempFlag_6, t0.deleteFlag AS deleteFlag_7, t0.id AS id_8, t0.code AS code_9, t0.bezeichnung AS bezeichnung_10, t0.sb_user AS sb_user_11, t0.wac_template_id AS wac_template_id_12 FROM layout t0 WHERE t0.code = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
  "MC-Login-Intro"
]
0.62 ms
(4.43%)
1
SELECT t0.deleted_at AS deleted_at_1, t0.anlage_datum AS anlage_datum_2, t0.aenderung_datum AS aenderung_datum_3, t0.aktiv AS aktiv_4, t0.sb_name AS sb_name_5, t0.id AS id_6, t0.bezeichnung AS bezeichnung_7, t0.sb_user AS sb_user_8 FROM role t0 INNER JOIN role_user ON t0.id = role_user.role_id WHERE role_user.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  106
]
0.59 ms
(4.26%)
1
SELECT t0.id AS id_1, t0.layout_id AS layout_id_2, t0.cssKlasse_id AS cssKlasse_id_3 FROM layout_cssKlasse t0 WHERE t0.layout_id = ?
Parameters:
[
  51
]
0.58 ms
(4.15%)
1
SELECT t0.deleted_at AS deleted_at_1, t0.anlage_datum AS anlage_datum_2, t0.aenderung_datum AS aenderung_datum_3, t0.aktiv AS aktiv_4, t0.sb_name AS sb_name_5, t0.id AS id_6, t0.bereichname AS bereichname_7, t0.beschreibung AS beschreibung_8, t0.rang AS rang_9, t0.variable AS variable_10, t0.sb_user AS sb_user_11 FROM wac_layoutbereich t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  28
]
0.57 ms
(4.06%)
1
SELECT t0.deleted_at AS deleted_at_1, t0.anlage_datum AS anlage_datum_2, t0.aenderung_datum AS aenderung_datum_3, t0.aktiv AS aktiv_4, t0.sb_name AS sb_name_5, t0.tempFlag AS tempFlag_6, t0.deleteFlag AS deleteFlag_7, t0.id AS id_8, t0.username AS username_9, t0.vorname AS vorname_10, t0.nachname AS nachname_11, t0.password AS password_12, t0.email AS email_13, t0.to_user AS to_user_14, t0.auth_counter AS auth_counter_15, t0.auth_sperre AS auth_sperre_16, t0.telefonnummer AS telefonnummer_17, t0.kuerzel AS kuerzel_18, t0.veroeffentlichen AS veroeffentlichen_19, t0.geburtstag AS geburtstag_20, t0.letzter_login AS letzter_login_21, t0.letzte_passwort_aenderung AS letzte_passwort_aenderung_22, t0.text AS text_23, t0.signatur_email AS signatur_email_24, t0.token AS token_25, t0.to2_token AS to2_token_26, t0.langdock_api_key AS langdock_api_key_27, t0.website_user AS website_user_28, t0.sb_user AS sb_user_29, t0.geschlecht_id AS geschlecht_id_30, t0.sprache_id AS sprache_id_31, t0.abteilung_id AS abteilung_id_32 FROM user t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  73
]
0.55 ms
(3.91%)
1
SELECT t0.deleted_at AS deleted_at_1, t0.anlage_datum AS anlage_datum_2, t0.aenderung_datum AS aenderung_datum_3, t0.aktiv AS aktiv_4, t0.sb_name AS sb_name_5, t0.id AS id_6, t0.parent AS parent_7, t0.parent_property AS parent_property_8, t0.text AS text_9, t0.sb_user AS sb_user_10, t0.sprache_id AS sprache_id_11 FROM sprache_text t0 WHERE t0.parent = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "App\Entity\CMS\Textbaustein:84"
]
0.54 ms
(3.87%)
1
SELECT t0.deleted_at AS deleted_at_1, t0.anlage_datum AS anlage_datum_2, t0.aenderung_datum AS aenderung_datum_3, t0.aktiv AS aktiv_4, t0.sb_name AS sb_name_5, t0.id AS id_6, t0.code AS code_7, t0.name AS name_8, t0.funktionsbeschreibung AS funktionsbeschreibung_9, t0.types AS types_10, t0.sb_user AS sb_user_11, t0.gruppe_id AS gruppe_id_12, t0.metainfo_id AS metainfo_id_13 FROM tag t0 INNER JOIN layout_tag ON t0.id = layout_tag.tag_id WHERE layout_tag.layout_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  51
]
0.54 ms
(3.86%)
1
SELECT t0.deleted_at AS deleted_at_1, t0.anlage_datum AS anlage_datum_2, t0.aenderung_datum AS aenderung_datum_3, t0.aktiv AS aktiv_4, t0.sb_name AS sb_name_5, t0.id AS id_6, t0.code AS code_7, t0.bezeichnung AS bezeichnung_8, t0.is_default AS is_default_9, t0.sb_user AS sb_user_10 FROM sprache t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  1
]
0.53 ms
(3.78%)
1
SELECT t0.deleted_at AS deleted_at_1, t0.anlage_datum AS anlage_datum_2, t0.aenderung_datum AS aenderung_datum_3, t0.aktiv AS aktiv_4, t0.sb_name AS sb_name_5, t0.tempFlag AS tempFlag_6, t0.deleteFlag AS deleteFlag_7, t0.id AS id_8, t0.sb_user AS sb_user_9, t0.wac_layoutbereich_id AS wac_layoutbereich_id_10, t0.wac_template_id AS wac_template_id_11, t0.layout_id AS layout_id_12 FROM layout_bereich t0 WHERE t0.layout_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  51
]
0.50 ms
(3.62%)
1
SELECT t0.deleted_at AS deleted_at_1, t0.anlage_datum AS anlage_datum_2, t0.aenderung_datum AS aenderung_datum_3, t0.aktiv AS aktiv_4, t0.sb_name AS sb_name_5, t0.tempFlag AS tempFlag_6, t0.deleteFlag AS deleteFlag_7, t0.id AS id_8, t0.rang AS rang_9, t0.bezeichnung AS bezeichnung_10, t0.sb_user AS sb_user_11, t0.bereich_id AS bereich_id_12, t0.wac_template_id AS wac_template_id_13 FROM layout_bereich_zeile t0 WHERE t0.bereich_id = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.rang ASC
Parameters:
[
  198
]
0.47 ms
(3.40%)
1
SELECT t0.deleted_at AS deleted_at_1, t0.anlage_datum AS anlage_datum_2, t0.aenderung_datum AS aenderung_datum_3, t0.aktiv AS aktiv_4, t0.sb_name AS sb_name_5, t0.id AS id_6, t0.origin AS origin_7, t0.media_file_name AS media_file_name_8, t0.media_file_id AS media_file_id_9, t0.media_file_url AS media_file_url_10, t0.alt_text AS alt_text_11, t0.media_file_type AS media_file_type_12, t0.blur_hash AS blur_hash_13, t0.metadata AS metadata_14, t0.parent AS parent_15, t0.rang AS rang_16, t0.available AS available_17, t0.sb_user AS sb_user_18 FROM media t0 WHERE t0.parent = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "App\Entity\CMS\Textbaustein:84"
]
0.42 ms
(3.02%)
1
SELECT t0.id AS id_1, t0.layout_bereich_zeile_id AS layout_bereich_zeile_id_2, t0.cssKlasse_id AS cssKlasse_id_3 FROM layout_bereich_zeile_cssKlasse t0 WHERE t0.layout_bereich_zeile_id = ?
Parameters:
[
  132
]
0.41 ms
(2.94%)
1
SELECT t0.id AS id_1, t0.layout_bereich_id AS layout_bereich_id_2, t0.cssKlasse_id AS cssKlasse_id_3 FROM layout_bereich_cssKlasse t0 WHERE t0.layout_bereich_id = ?
Parameters:
[
  198
]
0.41 ms
(2.91%)
1
SELECT t0.deleted_at AS deleted_at_1, t0.anlage_datum AS anlage_datum_2, t0.aenderung_datum AS aenderung_datum_3, t0.aktiv AS aktiv_4, t0.sb_name AS sb_name_5, t0.tempFlag AS tempFlag_6, t0.deleteFlag AS deleteFlag_7, t0.id AS id_8, t0.code AS code_9, t0.bezeichnung AS bezeichnung_10, t0.ueberschrift_level AS ueberschrift_level_11, t0.codefeld AS codefeld_12, t0.unsichtbar_website AS unsichtbar_website_13, t0.anzeige_von AS anzeige_von_14, t0.anzeige_bis AS anzeige_bis_15, t0.sb_user AS sb_user_16 FROM textbaustein t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  84
]
0.39 ms
(2.79%)
1
SELECT t0.deleted_at AS deleted_at_1, t0.anlage_datum AS anlage_datum_2, t0.aenderung_datum AS aenderung_datum_3, t0.aktiv AS aktiv_4, t0.sb_name AS sb_name_5, t0.id AS id_6, t0.code AS code_7, t0.name AS name_8, t0.funktionsbeschreibung AS funktionsbeschreibung_9, t0.types AS types_10, t0.sb_user AS sb_user_11, t0.gruppe_id AS gruppe_id_12, t0.metainfo_id AS metainfo_id_13 FROM tag t0 INNER JOIN textbaustein_tag ON t0.id = textbaustein_tag.tag_id WHERE textbaustein_tag.textbaustein_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  84
]
0.37 ms
(2.64%)
1
SELECT t0.id AS id_1, t0.textbaustein_id AS textbaustein_id_2, t0.cssKlasse_id AS cssKlasse_id_3 FROM textbaustein_css_klasse t0 WHERE t0.textbaustein_id = ?
Parameters:
[
  84
]
0.35 ms
(2.51%)
1
SELECT t0.id AS id_1, t0.layout_bereich_zeile_element_id AS layout_bereich_zeile_element_id_2, t0.cssKlasse_id AS cssKlasse_id_3 FROM layout_bereich_zeile_element_cssKlasse t0 WHERE t0.layout_bereich_zeile_element_id = ?
Parameters:
[
  323
]
0.32 ms
(2.33%)
1
SELECT t0.deleted_at AS deleted_at_1, t0.anlage_datum AS anlage_datum_2, t0.aenderung_datum AS aenderung_datum_3, t0.aktiv AS aktiv_4, t0.sb_name AS sb_name_5, t0.id AS id_6, t0.label AS label_7, t0.bezeichnung AS bezeichnung_8, t0.bezeichnung_en AS bezeichnung_en_9, t0.sb_user AS sb_user_10 FROM key_wac_template_type t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "Textbaustein"
]

Database Connections

Name Service
default doctrine.dbal.default_connection
external doctrine.dbal.external_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
external doctrine.orm.external_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Administration\RoleRight 21
App\Entity\Administration\Right 16
App\Entity\Administration\User 5
App\Entity\Administration\Parameter 4
App\Entity\Administration\Role 3
App\Entity\Texte\SpracheText 2
App\Entity\Key\KeyGeschlecht 1
App\Entity\Stammdaten\SpracheAPI 1
App\Entity\Administration\Abteilung 1
App\Entity\CMS\Layout 1
App\Entity\CMS\LayoutBereich 1
App\Entity\Administration\WebsiteAusgabeConfig_Layoutbereich 1
App\Entity\CMS\LayoutBereichZeile 1
App\Entity\CMS\LayoutBereichZeileElement 1
App\Entity\Key\KeyWebsiteAusgabeConfig_TemplateType 1
App\Entity\CMS\Textbaustein 1
App\Entity\CMS\Sprache 1

external entity manager

Class Amount of managed objects

Entities Mapping

default entity manager

Class Mapping errors
App\Entity\AbstractToEntity No errors.
App\Entity\Administration\Parameter No errors.
App\Entity\AbstractTemporableToEntity No errors.
App\Entity\Administration\User No errors.
App\Entity\Key\KeyGeschlecht No errors.
App\Entity\Stammdaten\SpracheAPI No errors.
App\Entity\Administration\Abteilung No errors.
App\Entity\Administration\Datensatzsperre No errors.
App\Entity\CRM\Kunde No errors.
App\Entity\Administration\UserTable No errors.
App\Entity\Reise\Paket\PaketUser No errors.
App\Entity\Administration\UserFilter No errors.
App\Entity\Administration\Role No errors.
App\Entity\Administration\RoleRight No errors.
App\Entity\Administration\Right No errors.
App\Entity\CMS\Layout No errors.
App\Entity\Administration\WebsiteAusgabeConfig_Template No errors.
App\Entity\Stammdaten\Tag No errors.
App\Entity\CMS\LayoutBereich No errors.
App\Entity\CMS\LayoutCSSKlasse No errors.
App\Entity\CMS\SeoDomain No errors.
App\Entity\Administration\WebsiteAusgabeConfig_Layoutbereich No errors.
App\Entity\CMS\LayoutBereichCSSKlasse No errors.
App\Entity\CMS\LayoutBereichZeile No errors.
App\Entity\CMS\LayoutBereichZeileElement No errors.
App\Entity\CMS\LayoutBereichZeileCSSKlasse No errors.
App\Entity\Key\KeyWebsiteAusgabeConfig_TemplateType No errors.
App\Entity\CMS\Textbaustein No errors.
App\Entity\Reise\Paket\Paket No errors.
App\Entity\Reise\Reiseobjekt No errors.
App\Entity\Administration\ListenFilterRegel No errors.
App\Entity\CMS\LayoutBereichZeileElementCSSKlasse No errors.
App\Entity\Administration\WebsiteAusgabeConfig_CssKlasse No errors.
App\Entity\Stammdaten\TagGruppe No errors.
App\Entity\CMS\Metainfo No errors.
App\Entity\CMS\TextbausteinCssKlasse No errors.
App\Entity\Texte\SpracheText No errors.
App\Entity\CMS\Sprache No errors.
App\Entity\CMS\Media No errors.

external entity manager

No loaded entities.