Query Metrics
5
Database Queries
5
Different statements
2.53 ms
Query time
0
Invalid entities
36
Managed entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
0.63 ms (24.84%) |
1 |
SELECT p0_.id AS id_0, p0_.friendly_url AS friendly_url_1, p0_.is_default AS is_default_2, p0_.rang AS rang_3, p0_.paket_id AS paket_id_4, p0_.domain_id AS domain_id_5 FROM paket_friendlyUrl p0_ INNER JOIN paket p1_ ON p0_.paket_id = p1_.id AND (p1_.deleted_at IS NULL) INNER JOIN domain d2_ ON (p0_.domain_id = d2_.id) AND (d2_.deleted_at IS NULL) WHERE p1_.deleted_at IS NULL AND p0_.friendly_url IS NOT NULL AND p0_.friendly_url <> ? AND d2_.domain = ?
Parameters:
[
""
"to3-abnahme.tourone.de"
]
|
|
0.57 ms (22.32%) |
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.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"
]
|
|
0.52 ms (20.61%) |
1 |
SELECT s0_.deleted_at AS deleted_at_0, s0_.anlage_datum AS anlage_datum_1, s0_.aenderung_datum AS aenderung_datum_2, s0_.aktiv AS aktiv_3, s0_.sb_name AS sb_name_4, s0_.id AS id_5, s0_.friendly_url AS friendly_url_6, s0_.sb_user AS sb_user_7, s0_.layout_id AS layout_id_8, s0_.domain_id AS domain_id_9, s0_.seo_id AS seo_id_10 FROM seo_domain s0_ INNER JOIN seo_object s1_ ON s0_.seo_id = s1_.id AND (s1_.deleted_at IS NULL) INNER JOIN domain d2_ ON (s0_.domain_id = d2_.id) AND (d2_.deleted_at IS NULL) WHERE (s1_.deleted_at IS NULL AND s0_.friendly_url IS NOT NULL AND s0_.friendly_url <> ? AND d2_.domain = ?) AND (s0_.deleted_at IS NULL)
Parameters:
[
""
"to3-abnahme.tourone.de"
]
|
|
0.42 ms (16.71%) |
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:
[
54
]
|
|
0.39 ms (15.52%) |
1 |
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:
[
7
]
|
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 | 15 |
| App\Entity\Administration\Right | 15 |
| App\Entity\Administration\User | 2 |
| App\Entity\Key\KeyGeschlecht | 1 |
| App\Entity\Stammdaten\SpracheAPI | 1 |
| App\Entity\Administration\Abteilung | 1 |
| App\Entity\Administration\Role | 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\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\SeoObject | No errors. |
| App\Entity\Reise\Paket\PaketFriendlyUrl | No errors. |
| App\Entity\Reise\Paket\Paket | No errors. |
| App\Entity\Administration\Domain | No errors. |
| App\Entity\CMS\SeoDomain | No errors. |
| App\Entity\CMS\Layout | No errors. |
external entity manager
No loaded entities.