Query Metrics
8
Database Queries
8
Different statements
5.42 ms
Query time
0
Invalid entities
39
Managed entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.45 ms |
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.sb_user AS sb_user_27, t0.geschlecht_id AS geschlecht_id_28, t0.sprache_id AS sprache_id_29, t0.abteilung_id AS abteilung_id_30 FROM user t0 WHERE t0.token = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
"qkTJjXyKOG3D8Eqqn6RBf4Y9Mi0pfTnKDmOE9tKYSOYxMnoVe0KNkL9wGg3I9YtqNcxItOMrvtqdhqpWxsJRDCamzr7isg8njocvzpbK2YbmyUgsVUc2gR0RuhbbBxJUTYbsREHmKNpWBJwVoEwBLB4nAcWvK4PoyDWKiv3ZQVgsds46oQemyOU4lr4GcG8tsD1fy9iBoLRd70PAhFokd7Xs01M27vowCon5Ye9A0j3zE68Q3Gos2E4ckflyS37VdxsvDE4vt7kclunbm3PfIU55AIrGKCMwEtUuQNHoSBysdDHkBjmx6nUc6sF8c4eHJZOcyL6ZZ36qXeq1aM9ioL5aFCtpQvQQ4VSwjg8kNnn09hMAdhVTQgcxALM0TqeriusSjyVpkmxOa3231231"
]
|
| 2 | 0.36 ms |
SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.right_id AS right_id_3 FROM user_right t0 WHERE t0.user_id = ?
Parameters:
[
54
]
|
| 3 | 0.71 ms |
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-Outro"
]
|
| 4 | 0.30 ms |
"START TRANSACTION"
Parameters:
[] |
| 5 | 0.53 ms |
INSERT INTO layout (deleted_at, anlage_datum, aenderung_datum, aktiv, sb_name, sb_user, tempFlag, deleteFlag, code, bezeichnung, wac_template_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ null "2026-06-06 02:10:21" "2026-06-06 02:10:21" 1 "" 54 1 0 null null null ] |
| 6 | 0.37 ms |
INSERT INTO ext_log_entries (action, data, version, logged_at, username, object_class, object_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "create" "{"deletedAt":null,"anlageDatum":{"date":"2026-06-06 02:10:21.326098","timezone_type":3,"timezone":"Europe\/Berlin"},"aktiv":true,"sbName":"","temp":true,"delete":false,"code":null,"bezeichnung":null}" 1 "2026-06-06 02:10:21" null "App\Entity\CMS\Layout" null ] |
| 7 | 2.05 ms |
UPDATE ext_log_entries SET object_id = ? WHERE id = ?
Parameters:
[ "94" 27829194 ] |
| 8 | 0.65 ms |
"COMMIT"
Parameters:
[] |
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\UserRight | 20 |
| App\Entity\Administration\Right | 14 |
| App\Entity\Administration\User | 1 |
| App\Entity\Key\KeyGeschlecht | 1 |
| App\Entity\Administration\Abteilung | 1 |
| App\Entity\CMS\Layout | 1 |
| App\Entity\Extension\LogEntry | 1 |
external entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\AbstractToEntity | 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\Administration\UserRight | 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\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\Extension\AbstractLogEntry | No errors. |
| App\Entity\Extension\LogEntry | No errors. |
external entity manager
No loaded entities.