Symfony Profiler

Query Metrics

67 Database Queries

13 Different statements

29.60 ms Query time

0 Invalid entities

241 Managed entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

7.01 ms
(23.66%)

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"
]

View formatted query View runnable query Explain query View query backtrace

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)
  )

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 = 'App\\Entity\\Reise\\Land:NA' AND t0.parent_property = 'landBeschreibungTexte' AND ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 800)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
3	Doctrine\ORM\EntityRepository->findBy (line 111)
4	App\Entity\ToProxyCollection->initialize (line 108)
5	App\Entity\ToProxyCollection->getCollection (line 36)
6	App\Entity\AbstractToEntity->jsonSerialize (line 415)
7	App\Entity\Reise\Land->jsonSerialize (line 312)
8	App\Service\Helper\JsonSerializeHelper->serialize (line 54)
9	App\Service\Helper\JsonSerializeHelper->serialize (line 59)
10	App\Service\Helper\JsonSerializeHelper->serialize (line 59)
11	App\Service\Helper\JsonSerializeHelper->serialize (line 54)
12	App\Service\Helper\JsonSerializeHelper->serialize (line 59)
13	App\Controller\AbstractToController->json (line 388)
14	App\Controller\Backend\Reise\KontinentController->listApi (line 38)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 200)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 80)
17	Symfony\Component\HttpKernel\Kernel->handle (line 155)
18	handle (line 25)

6.30 ms
(21.30%)

SELECT t0.id AS id_1, t0.bundesland_key AS bundesland_key_2, t0.bezeichnung AS bezeichnung_3, t0.land_alpha2 AS land_alpha2_4 FROM bundesland t0 WHERE t0.land_alpha2 = ?

Parameters:

[
  "NA"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.bundesland_key AS bundesland_key_2,
  t0.bezeichnung AS bezeichnung_3,
  t0.land_alpha2 AS land_alpha2_4
FROM
  bundesland t0
WHERE
  t0.land_alpha2 = ?

SELECT t0.id AS id_1, t0.bundesland_key AS bundesland_key_2, t0.bezeichnung AS bezeichnung_3, t0.land_alpha2 AS land_alpha2_4 FROM bundesland t0 WHERE t0.land_alpha2 = 'NA';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 800)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1876)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1821)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 2928)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 629)
6	Doctrine\ORM\PersistentCollection->initialize (line 188)
7	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 128)
8	App\Entity\AbstractToEntity->jsonSerialize (line 420)
9	App\Entity\Reise\Land->jsonSerialize (line 312)
10	App\Service\Helper\JsonSerializeHelper->serialize (line 54)
11	App\Service\Helper\JsonSerializeHelper->serialize (line 59)
12	App\Service\Helper\JsonSerializeHelper->serialize (line 59)
13	App\Service\Helper\JsonSerializeHelper->serialize (line 54)
14	App\Service\Helper\JsonSerializeHelper->serialize (line 59)
15	App\Controller\AbstractToController->json (line 388)
16	App\Controller\Backend\Reise\KontinentController->listApi (line 38)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 200)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 80)
19	Symfony\Component\HttpKernel\Kernel->handle (line 155)
20	handle (line 25)

6.10 ms
(20.60%)

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"
]

View formatted query View runnable query Explain query View query backtrace

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)
  )

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 = 'NA' AND ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 800)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 2932)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 629)
6	Doctrine\ORM\PersistentCollection->initialize (line 188)
7	Doctrine\Common\Collections\AbstractLazyCollection->map (line 208)
8	App\Entity\Reise\Land->jsonSerialize (line 314)
9	App\Service\Helper\JsonSerializeHelper->serialize (line 54)
10	App\Service\Helper\JsonSerializeHelper->serialize (line 59)
11	App\Service\Helper\JsonSerializeHelper->serialize (line 59)
12	App\Service\Helper\JsonSerializeHelper->serialize (line 54)
13	App\Service\Helper\JsonSerializeHelper->serialize (line 59)
14	App\Controller\AbstractToController->json (line 388)
15	App\Controller\Backend\Reise\KontinentController->listApi (line 38)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 200)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 80)
18	Symfony\Component\HttpKernel\Kernel->handle (line 155)
19	handle (line 25)

3.45 ms
(11.66%)

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.verbergen_im_frontend AS verbergen_im_frontend_15, t0.sb_user AS sb_user_16, t0.metainfo_id AS metainfo_id_17 FROM land t0 INNER JOIN land_kontinent ON t0.alpha2 = land_kontinent.land_alpha2 WHERE land_kontinent.kontinent_id = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  "AF"
]

View formatted query View runnable query Explain query View query backtrace

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.verbergen_im_frontend AS verbergen_im_frontend_15,
  t0.sb_user AS sb_user_16,
  t0.metainfo_id AS metainfo_id_17
FROM
  land t0
  INNER JOIN land_kontinent ON t0.alpha2 = land_kontinent.land_alpha2
WHERE
  land_kontinent.kontinent_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

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.verbergen_im_frontend AS verbergen_im_frontend_15, t0.sb_user AS sb_user_16, t0.metainfo_id AS metainfo_id_17 FROM land t0 INNER JOIN land_kontinent ON t0.alpha2 = land_kontinent.land_alpha2 WHERE land_kontinent.kontinent_id = 'AF' AND ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 800)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 2932)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 629)
6	Doctrine\ORM\PersistentCollection->initialize (line 188)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 253)
8	App\Controller\Backend\Reise\KontinentController->getKontinenteByPaket (line 99)
9	App\Controller\Backend\Reise\KontinentController->listApi (line 38)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 200)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 80)
12	Symfony\Component\HttpKernel\Kernel->handle (line 155)
13	handle (line 25)

1.58 ms
(5.33%)

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
]

View formatted query View runnable query Explain query View query backtrace

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 = ?

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 = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 800)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1876)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1821)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 2928)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 629)
6	Doctrine\ORM\PersistentCollection->initialize (line 188)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 253)
8	App\Entity\Administration\User->getRights (line 550)
9	App\Entity\Administration\User->getRoles (line 542)
10	Symfony\Component\Security\Http\Authenticator\AbstractAuthenticator->createToken (line 31)
11	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->createToken (line 82)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 200)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 160)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 142)
15	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
16	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
17	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
18	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 64)
19	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
20	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 174)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 80)
27	Symfony\Component\HttpKernel\Kernel->handle (line 155)
28	handle (line 25)

0.83 ms
(2.79%)

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
]

View formatted query View runnable query Explain query View query backtrace

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)

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 = 1) AND (p1_.deleted_at IS NULL);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 800)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
3	Doctrine\ORM\Query->_doExecute (line 296)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
5	Doctrine\ORM\AbstractQuery->execute (line 886)
6	Doctrine\ORM\AbstractQuery->getArrayResult (line 700)
7	App\Controller\Backend\Reise\KontinentController->getKontinenteByPaket (line 93)
8	App\Controller\Backend\Reise\KontinentController->listApi (line 38)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 200)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 80)
11	Symfony\Component\HttpKernel\Kernel->handle (line 155)
12	handle (line 25)

0.78 ms
(2.65%)

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
]

View formatted query View runnable query Explain query View query backtrace

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)

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 = 1) AND (p1_.deleted_at IS NULL);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 800)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
3	Doctrine\ORM\Query->_doExecute (line 296)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
5	Doctrine\ORM\AbstractQuery->execute (line 886)
6	Doctrine\ORM\AbstractQuery->getArrayResult (line 700)
7	App\Controller\Backend\Reise\KontinentController->getKontinenteByPaket (line 81)
8	App\Controller\Backend\Reise\KontinentController->listApi (line 38)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 200)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 80)
11	Symfony\Component\HttpKernel\Kernel->handle (line 155)
12	handle (line 25)

0.74 ms
(2.51%)

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"
]

View formatted query View runnable query Explain query View query backtrace

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

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 = 'qkTJjXyKOG3D8Eqqn6RBf4Y9Mi0pfTnKDmOE9tKYSOYxMnoVe0KNkL9wGg3I9YtqNcxItOMrvtqdhqpWxsJRDCamzr7isg8njocvzpbK2YbmyUgsVUc2gR0RuhbbBxJUTYbsREHmKNpWBJwVoEwBLB4nAcWvK4PoyDWKiv3ZQVgsds46oQemyOU4lr4GcG8tsD1fy9iBoLRd70PAhFokd7Xs01M27vowCon5Ye9A0j3zE68Q3Gos2E4ckflyS37VdxsvDE4vt7kclunbm3PfIU55AIrGKCMwEtUuQNHoSBysdDHkBjmx6nUc6sF8c4eHJZOcyL6ZZ36qXeq1aM9ioL5aFCtpQvQQ4VSwjg8kNnn09hMAdhVTQgcxALM0TqeriusSjyVpkmxOa3231231' AND ((t0.deleted_at IS NULL)) LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 800)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
3	Doctrine\ORM\EntityRepository->findOneBy (line 126)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findOneBy (line 94)
5	App\Security\SecurityHelper->getUserByApiToken (line 26)
6	App\Security\ApiKeyAuthenticator->authenticate (line 51)
7	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 72)
8	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 178)
9	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 160)
10	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 142)
11	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
12	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
13	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
14	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 64)
15	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
16	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
17	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
18	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
19	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
20	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 174)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 80)
23	Symfony\Component\HttpKernel\Kernel->handle (line 155)
24	handle (line 25)

0.73 ms
(2.45%)

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"
]

View formatted query View runnable query Explain query View query backtrace

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)
  )

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 ('AF', 'EU', 'AS', 'SA', 'AN') AND ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 800)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
3	Doctrine\ORM\EntityRepository->findBy (line 111)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 86)
5	App\Controller\Backend\Reise\KontinentController->getKontinenteByPaket (line 83)
6	App\Controller\Backend\Reise\KontinentController->listApi (line 38)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 200)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 80)
9	Symfony\Component\HttpKernel\Kernel->handle (line 155)
10	handle (line 25)

0.72 ms
(2.43%)

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
]

View formatted query View runnable query Explain query View query backtrace

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)
  )

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 = 106 AND ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 800)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 2932)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 629)
6	Doctrine\ORM\PersistentCollection->initialize (line 188)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 253)
8	App\Entity\Administration\User->getRoles (line 537)
9	Symfony\Component\Security\Http\Authenticator\AbstractAuthenticator->createToken (line 31)
10	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->createToken (line 82)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 200)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 160)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 142)
14	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
15	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
16	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
17	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 64)
18	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
19	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
20	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
21	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
22	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
23	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 174)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 80)
26	Symfony\Component\HttpKernel\Kernel->handle (line 155)
27	handle (line 25)

0.58 ms
(1.97%)

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"
]

View formatted query View runnable query Explain query View query backtrace

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)
  )

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 = 'App\\Entity\\CMS\\Metainfo:7' AND ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 800)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
3	Doctrine\ORM\EntityRepository->findBy (line 111)
4	App\Entity\Extension\TOAttribute\TranslatableDbSubscriber->translateEntity (line 162)
5	App\Entity\Extension\TOAttribute\TranslatableDbSubscriber->postLoad (line 109)
6	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 56)
7	Doctrine\ORM\Event\ListenersInvoker->invoke (line 95)
8	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 55)
9	Doctrine\ORM\UnitOfWork->hydrationComplete (line 3462)
10	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->cleanup (line 51)
11	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 178)
12	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 748)
13	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
14	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():259} (line 265)
15	App\Entity\CMS\Metainfo::jsonSerialize (line 321)
16	App\Service\Helper\JsonSerializeHelper->serialize (line 54)
17	App\Service\Helper\JsonSerializeHelper->serialize (line 59)
18	App\Service\Helper\JsonSerializeHelper->serialize (line 54)
19	App\Service\Helper\JsonSerializeHelper->serialize (line 59)
20	App\Service\Helper\JsonSerializeHelper->serialize (line 59)
21	App\Service\Helper\JsonSerializeHelper->serialize (line 54)
22	App\Service\Helper\JsonSerializeHelper->serialize (line 59)
23	App\Controller\AbstractToController->json (line 388)
24	App\Controller\Backend\Reise\KontinentController->listApi (line 38)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 200)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 80)
27	Symfony\Component\HttpKernel\Kernel->handle (line 155)
28	handle (line 25)

0.44 ms
(1.48%)

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
]

View formatted query View runnable query Explain query View query backtrace

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)
  )

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 = 1 AND ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 800)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
4	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():259} (line 265)
5	App\Entity\CMS\Sprache::getCode (line 65)
6	App\Entity\CMS\Metainfo->{closure:App\Entity\Texte\SpracheTextTrait::getLocalizedProperty():61} (line 61)
7	Doctrine\Common\Collections\ArrayCollection->{closure:Doctrine\Common\Collections\ArrayCollection::findFirst():335} (line 335)
8	array_find (line 333)
9	Doctrine\Common\Collections\ArrayCollection::findFirst (line 333)
10	App\Entity\CMS\Metainfo->getLocalizedProperty (line 61)
11	App\Entity\CMS\Metainfo->getLocalizedPropertyText (line 71)
12	App\Entity\CMS\Metainfo->jsonSerialize (line 327)
13	App\Service\Helper\JsonSerializeHelper->serialize (line 54)
14	App\Service\Helper\JsonSerializeHelper->serialize (line 59)
15	App\Service\Helper\JsonSerializeHelper->serialize (line 54)
16	App\Service\Helper\JsonSerializeHelper->serialize (line 59)
17	App\Service\Helper\JsonSerializeHelper->serialize (line 59)
18	App\Service\Helper\JsonSerializeHelper->serialize (line 54)
19	App\Service\Helper\JsonSerializeHelper->serialize (line 59)
20	App\Controller\AbstractToController->json (line 388)
21	App\Controller\Backend\Reise\KontinentController->listApi (line 38)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 200)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 80)
24	Symfony\Component\HttpKernel\Kernel->handle (line 155)
25	handle (line 25)

0.34 ms
(1.15%)

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
]

View formatted query View runnable query Explain query View query backtrace

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)
  )

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 = 7 AND ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 800)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
4	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():259} (line 265)
5	App\Entity\CMS\Metainfo::jsonSerialize (line 321)
6	App\Service\Helper\JsonSerializeHelper->serialize (line 54)
7	App\Service\Helper\JsonSerializeHelper->serialize (line 59)
8	App\Service\Helper\JsonSerializeHelper->serialize (line 54)
9	App\Service\Helper\JsonSerializeHelper->serialize (line 59)
10	App\Service\Helper\JsonSerializeHelper->serialize (line 59)
11	App\Service\Helper\JsonSerializeHelper->serialize (line 54)
12	App\Service\Helper\JsonSerializeHelper->serialize (line 59)
13	App\Controller\AbstractToController->json (line 388)
14	App\Controller\Backend\Reise\KontinentController->listApi (line 38)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 200)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 80)
17	Symfony\Component\HttpKernel\Kernel->handle (line 155)
18	handle (line 25)

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\Reise\Land	182
App\Entity\Administration\RoleRight	21
App\Entity\Administration\Right	16
App\Entity\Reise\Kontinent	5
App\Entity\Administration\User	4
App\Entity\Texte\SpracheText	4
App\Entity\Administration\Role	3
App\Entity\CMS\Sprache	2
App\Entity\Key\KeyGeschlecht	1
App\Entity\Stammdaten\SpracheAPI	1
App\Entity\Administration\Abteilung	1
App\Entity\CMS\Metainfo	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\Reise\Kontinent	No errors.
App\Entity\Reise\Paket\Paket	No errors.
App\Entity\Reise\Land	No errors.
App\Entity\CMS\Metainfo	No errors.
App\Entity\CRM\Bundesland	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.

external entity manager

No loaded entities.

GET https://to3-abnahme.tourone.de/backend/reise/kontinente?XDEBUG_SESSION_START=PHPSTORM&inklusiveLaender=1&nurAktiveReisen=1

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

external entity manager

Entities Mapping

default entity manager

external entity manager