Query Metrics

48 Database Queries
13 Different statements
12.81 ms Query time
1 Invalid entities
232 Managed entities

Grouped Statements

Show all queries

Time Count Info
3.58 ms
(27.96%)
16
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.parent_property = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "App\Entity\Reise\Land:NA"
  "landBeschreibungTexte"
]
3.32 ms
(25.91%)
16
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.sb_user AS sb_user_7, t0.metainfo_id AS metainfo_id_8 FROM kontinent t0 INNER JOIN land_kontinent ON t0.id = land_kontinent.kontinent_id WHERE land_kontinent.land_alpha2 = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "NA"
]
1.80 ms
(14.08%)
5
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.alpha2 AS alpha2_6, t0.alpha3 AS alpha3_7, t0.numeric_code AS numeric_code_8, t0.prio AS prio_9, t0.currency AS currency_10, t0.currency_code AS currency_code_11, t0.currency_name AS currency_name_12, t0.top_level_domain AS top_level_domain_13, t0.calling_code AS calling_code_14, t0.sb_user AS sb_user_15, t16.alpha2 AS alpha2_17, t16.verbergen_im_frontend AS verbergen_im_frontend_18, t16.alpha2 AS alpha2_19, t0.metainfo_id AS metainfo_id_20 FROM land t0 LEFT JOIN land_eigenschaft t16 ON t16.alpha2 = t0.alpha2 INNER JOIN land_kontinent ON t0.alpha2 = land_kontinent.land_alpha2 WHERE land_kontinent.kontinent_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "AF"
]
0.91 ms
(7.12%)
2
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:
[
  "AUTH_TOKEN"
  "Pixxio"
]
0.41 ms
(3.23%)
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.sb_user AS sb_user_7, t0.metainfo_id AS metainfo_id_8 FROM kontinent t0 WHERE t0.id IN (?, ?, ?, ?, ?) AND ((t0.deleted_at IS NULL))
Parameters:
[
  "AF"
  "EU"
  "AS"
  "SA"
  "AN"
]
0.41 ms
(3.21%)
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.39 ms
(3.07%)
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.email = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
  "admin@tourone.de"
]
0.39 ms
(3.05%)
1
SELECT DISTINCT l0_.alpha2 AS alpha2_0 FROM paket p1_ INNER JOIN paket_land p2_ ON p1_.id = p2_.paket_id INNER JOIN land l0_ ON l0_.alpha2 = p2_.land_id AND (l0_.deleted_at IS NULL) WHERE (p1_.aktiv = ?) AND (p1_.deleted_at IS NULL)
Parameters:
[
  1
]
0.37 ms
(2.92%)
1
SELECT DISTINCT k0_.id AS id_0 FROM paket p1_ INNER JOIN paket_land p3_ ON p1_.id = p3_.paket_id INNER JOIN land l2_ ON l2_.alpha2 = p3_.land_id AND (l2_.deleted_at IS NULL) INNER JOIN land_kontinent l4_ ON l2_.alpha2 = l4_.land_alpha2 INNER JOIN kontinent k0_ ON k0_.id = l4_.kontinent_id AND (k0_.deleted_at IS NULL) WHERE (p1_.aktiv = ?) AND (p1_.deleted_at IS NULL)
Parameters:
[
  1
]
0.36 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.tempFlag AS tempFlag_6, t0.deleteFlag AS deleteFlag_7, t0.id AS id_8, t0.code AS code_9, t0.int_beschreibung AS int_beschreibung_10, t0.no_index AS no_index_11, t0.no_follow AS no_follow_12, t0.type AS type_13, t0.sb_user AS sb_user_14 FROM metainfo t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  7
]
0.34 ms
(2.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.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\Metainfo:7"
]
0.27 ms
(2.08%)
1
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
]
0.25 ms
(1.96%)
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
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Reise\Land 182
App\Entity\Administration\UserRight 19
App\Entity\Administration\Right 13
App\Entity\Reise\Kontinent 5
App\Entity\Texte\SpracheText 4
App\Entity\Administration\Parameter 2
App\Entity\Administration\User 2
App\Entity\CMS\Sprache 2
App\Entity\Key\KeyGeschlecht 1
App\Entity\Administration\Abteilung 1
App\Entity\CMS\Metainfo 1

Entities Mapping

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\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\Reise\Kontinent No errors.
App\Entity\Reise\Paket\Paket No errors.
App\Entity\Reise\Land
  • The field App\Entity\Reise\Land#eigenschaft is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Reise\LandEigenschaft#land does not contain the required 'inversedBy: "eigenschaft"' attribute.
App\Entity\CMS\Metainfo No errors.
App\Entity\Reise\LandEigenschaft No errors.
App\Entity\Texte\SpracheText No errors.
App\Entity\CMS\Sprache No errors.
App\Entity\Stammdaten\Tag No errors.
App\Entity\CMS\SeoObject No errors.
App\Entity\Reise\Reiseart No errors.
App\Entity\Reise\Reiseobjekt No errors.