Symfony Profiler

Query Metrics

118 Database Queries

9 Different statements

985.95 ms Query time

0 Invalid entities

502 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

576.14 ms
(58.43%)

SELECT t0.name AS name_1, t0.menu AS menu_2, t0.iso_2 AS iso_2_3, t0.iso_3 AS iso_3_4, t0.default_lang AS default_lang_5, t0.active AS active_6, t0.id AS id_7, t0.country AS country_8 FROM lang t0 WHERE t0.active = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.menu AS menu_2,
  t0.iso_2 AS iso_2_3,
  t0.iso_3 AS iso_3_4,
  t0.default_lang AS default_lang_5,
  t0.active AS active_6,
  t0.id AS id_7,
  t0.country AS country_8
FROM
  lang t0
WHERE
  t0.active = ?

SELECT t0.name AS name_1, t0.menu AS menu_2, t0.iso_2 AS iso_2_3, t0.iso_3 AS iso_3_4, t0.default_lang AS default_lang_5, t0.active AS active_6, t0.id AS id_7, t0.country AS country_8 FROM lang t0 WHERE t0.active = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 995)
2	Doctrine\ORM\EntityRepository->findBy (line 224)
3	NexCRM\BaseBundle\EventListener\LocaleListener->onKernelRequest (line 29)
4	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
5	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
6	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
7	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 197)
11	handle (line 42)

216.71 ms
(21.98%)

SELECT t0.name AS name_1, t0.category AS category_2, t0.domain AS domain_3, t0.alias AS alias_4, t0.code AS code_5, t0.active AS active_6, t0.api AS api_7, t0.expired AS expired_8, t0.id AS id_9, t0.sort AS sort_10 FROM web_cookie t0 WHERE t0.name = ? AND t0.alias = ? AND t0.api = ? LIMIT 1

Parameters:

[
  "cookieConsent"
  "cookie_banner"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.category AS category_2,
  t0.domain AS domain_3,
  t0.alias AS alias_4,
  t0.code AS code_5,
  t0.active AS active_6,
  t0.api AS api_7,
  t0.expired AS expired_8,
  t0.id AS id_9,
  t0.sort AS sort_10
FROM
  web_cookie t0
WHERE
  t0.name = ?
  AND t0.alias = ?
  AND t0.api = ?
LIMIT
  1

SELECT t0.name AS name_1, t0.category AS category_2, t0.domain AS domain_3, t0.alias AS alias_4, t0.code AS code_5, t0.active AS active_6, t0.api AS api_7, t0.expired AS expired_8, t0.id AS id_9, t0.sort AS sort_10 FROM web_cookie t0 WHERE t0.name = 'cookieConsent' AND t0.alias = 'cookie_banner' AND t0.api = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	NexCRM\WebBundle\Service\MarketingService->syncMarketing (line 257)
4	NexCRM\WebBundle\Controller\CronController->marketing (line 19)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 197)
8	handle (line 42)

108.70 ms
(11.02%)

SELECT t0.text AS text_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM web_cookie_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.text AS text_1,
  t0.id AS id_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  web_cookie_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.text AS text_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM web_cookie_translation t0 WHERE t0.translatable_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1956)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1897)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 3318)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 706)
5	Doctrine\ORM\PersistentCollection->initialize (line 218)
6	Doctrine\Common\Collections\AbstractLazyCollection->get (line 118)
7	Doctrine\ORM\PersistentCollection->get (line 445)
8	NexCRM\WebBundle\Entity\Cookie->findTranslationByLocale (line 190)
9	NexCRM\WebBundle\Entity\Cookie->doTranslate (line 138)
10	NexCRM\WebBundle\Entity\Cookie->translate (line 75)
11	NexCRM\WebBundle\Service\MarketingService->syncMarketing (line 273)
12	NexCRM\WebBundle\Controller\CronController->marketing (line 19)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 197)
16	handle (line 42)

29.46 ms
(2.99%)

SELECT t0.name AS name_1, t0.code1 AS code1_2, t0.code2 AS code2_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM web_code_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.code1 AS code1_2,
  t0.code2 AS code2_3,
  t0.id AS id_4,
  t0.locale AS locale_5,
  t0.translatable_id AS translatable_id_6
FROM
  web_code_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.name AS name_1, t0.code1 AS code1_2, t0.code2 AS code2_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM web_code_translation t0 WHERE t0.translatable_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1956)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1897)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 3318)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 706)
5	Doctrine\ORM\PersistentCollection->initialize (line 218)
6	Doctrine\Common\Collections\AbstractLazyCollection->get (line 118)
7	Doctrine\ORM\PersistentCollection->get (line 445)
8	NexCRM\WebBundle\Entity\Code->findTranslationByLocale (line 190)
9	NexCRM\WebBundle\Entity\Code->doTranslate (line 138)
10	NexCRM\WebBundle\Entity\Code->translate (line 75)
11	NexCRM\WebBundle\Service\MarketingService->syncMarketing (line 231)
12	NexCRM\WebBundle\Controller\CronController->marketing (line 19)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 197)
16	handle (line 42)

18.90 ms
(1.92%)

SELECT t0.name AS name_1, t0.menu AS menu_2, t0.iso_2 AS iso_2_3, t0.iso_3 AS iso_3_4, t0.default_lang AS default_lang_5, t0.active AS active_6, t0.id AS id_7, t0.country AS country_8 FROM lang t0 WHERE t0.default_lang = ? LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.menu AS menu_2,
  t0.iso_2 AS iso_2_3,
  t0.iso_3 AS iso_3_4,
  t0.default_lang AS default_lang_5,
  t0.active AS active_6,
  t0.id AS id_7,
  t0.country AS country_8
FROM
  lang t0
WHERE
  t0.default_lang = ?
LIMIT
  1

SELECT t0.name AS name_1, t0.menu AS menu_2, t0.iso_2 AS iso_2_3, t0.iso_3 AS iso_3_4, t0.default_lang AS default_lang_5, t0.active AS active_6, t0.id AS id_7, t0.country AS country_8 FROM lang t0 WHERE t0.default_lang = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	NexCRM\BaseBundle\EventListener\LocaleListener->onKernelRequest (line 31)
4	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
5	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
6	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
7	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 197)
11	handle (line 42)

13.70 ms
(1.39%)

SELECT t0.name AS name_1, t0.menu AS menu_2, t0.iso_2 AS iso_2_3, t0.iso_3 AS iso_3_4, t0.default_lang AS default_lang_5, t0.active AS active_6, t0.id AS id_7, t0.country AS country_8 FROM lang t0 WHERE t0.iso_2 = ? LIMIT 1

Parameters:

[
  "cs"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.menu AS menu_2,
  t0.iso_2 AS iso_2_3,
  t0.iso_3 AS iso_3_4,
  t0.default_lang AS default_lang_5,
  t0.active AS active_6,
  t0.id AS id_7,
  t0.country AS country_8
FROM
  lang t0
WHERE
  t0.iso_2 = ?
LIMIT
  1

SELECT t0.name AS name_1, t0.menu AS menu_2, t0.iso_2 AS iso_2_3, t0.iso_3 AS iso_3_4, t0.default_lang AS default_lang_5, t0.active AS active_6, t0.id AS id_7, t0.country AS country_8 FROM lang t0 WHERE t0.iso_2 = 'cs' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	NexCRM\BaseBundle\EventListener\LocaleListener->onKernelRequest (line 45)
4	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
5	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
6	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
7	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 197)
11	handle (line 42)

11.53 ms
(1.17%)

SELECT t0.alias AS alias_1, t0.active AS active_2, t0.api AS api_3, t0.display AS display_4, t0.script AS script_5, t0.category AS category_6, t0.position AS position_7, t0.code1 AS code1_8, t0.code2 AS code2_9, t0.id AS id_10, t0.sort AS sort_11 FROM web_code t0 WHERE t0.alias = ? AND t0.api = ? LIMIT 1

Parameters:

[
  "default_setting"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.alias AS alias_1,
  t0.active AS active_2,
  t0.api AS api_3,
  t0.display AS display_4,
  t0.script AS script_5,
  t0.category AS category_6,
  t0.position AS position_7,
  t0.code1 AS code1_8,
  t0.code2 AS code2_9,
  t0.id AS id_10,
  t0.sort AS sort_11
FROM
  web_code t0
WHERE
  t0.alias = ?
  AND t0.api = ?
LIMIT
  1

SELECT t0.alias AS alias_1, t0.active AS active_2, t0.api AS api_3, t0.display AS display_4, t0.script AS script_5, t0.category AS category_6, t0.position AS position_7, t0.code1 AS code1_8, t0.code2 AS code2_9, t0.id AS id_10, t0.sort AS sort_11 FROM web_code t0 WHERE t0.alias = 'default_setting' AND t0.api = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	NexCRM\WebBundle\Service\MarketingService->syncMarketing (line 216)
4	NexCRM\WebBundle\Controller\CronController->marketing (line 19)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 197)
8	handle (line 42)

6.05 ms
(0.61%)

SELECT t0.entity_class AS entity_class_1, t0.request_id AS request_id_2, t0.property AS property_3, t0.media_order AS media_order_4, t0.created AS created_5, t0.entity_id AS entity_id_6, t0.id AS id_7 FROM media_order_record t0 WHERE t0.request_id = ?

Parameters:

[
  "47b05f0def_6983cf77846875.37193002"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.entity_class AS entity_class_1,
  t0.request_id AS request_id_2,
  t0.property AS property_3,
  t0.media_order AS media_order_4,
  t0.created AS created_5,
  t0.entity_id AS entity_id_6,
  t0.id AS id_7
FROM
  media_order_record t0
WHERE
  t0.request_id = ?

SELECT t0.entity_class AS entity_class_1, t0.request_id AS request_id_2, t0.property AS property_3, t0.media_order AS media_order_4, t0.created AS created_5, t0.entity_id AS entity_id_6, t0.id AS id_7 FROM media_order_record t0 WHERE t0.request_id = '47b05f0def_6983cf77846875.37193002';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 995)
2	Doctrine\ORM\EntityRepository->findBy (line 224)
3	NexCRM\BaseBundle\EventListener\ResponseListener->onKernelResponse (line 27)
4	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
5	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
6	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
7	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
8	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 214)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 202)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 197)
12	handle (line 42)

4.77 ms
(0.48%)

SELECT s0_.alias AS alias_0, s0_.value AS value_1, s0_.id AS id_2 FROM setting s0_ WHERE s0_.alias = ?

Parameters:

[
  "default_base_log"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.alias AS alias_0,
  s0_.value AS value_1,
  s0_.id AS id_2
FROM
  setting s0_
WHERE
  s0_.alias = ?

SELECT s0_.alias AS alias_0, s0_.value AS value_1, s0_.id AS id_2 FROM setting s0_ WHERE s0_.alias = 'default_base_log';

#	File/Call
1	Doctrine\DBAL\Connection->fetchAllAssociative (line 907)
2	Doctrine\DBAL\Connection->executeCacheQuery (line 1157)
3	Doctrine\DBAL\Connection->executeQuery (line 1084)
4	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
5	Doctrine\ORM\Query->_doExecute (line 330)
6	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
7	Doctrine\ORM\AbstractQuery->execute (line 1167)
8	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 958)
9	NexCRM\BaseBundle\Repository\SettingRepository->findValueCached (line 47)
10	NexCRM\BaseBundle\EventListener\LogSubscriber->onFlush (line 42)
11	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 63)
12	Doctrine\ORM\UnitOfWork->dispatchOnFlushEvent (line 3825)
13	Doctrine\ORM\UnitOfWork->commit (line 411)
14	Doctrine\ORM\EntityManager->flush (line 414)
15	NexCRM\WebBundle\Service\MarketingService->syncMarketing (line 248)
16	NexCRM\WebBundle\Controller\CronController->marketing (line 19)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 197)
20	handle (line 42)

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
NexCRM\WebBundle\Entity\CookieTranslation	368
NexCRM\WebBundle\Entity\CodeTranslation	72
NexCRM\WebBundle\Entity\Cookie	46
NexCRM\WebBundle\Entity\Code	9
NexCRM\BaseBundle\Entity\Lang	3
NexCRM\BaseBundle\Entity\Country	3
NexCRM\BaseBundle\Entity\Setting	1

Entities Mapping

Class	Mapping errors
NexCRM\BaseBundle\Entity\Lang	No errors.
NexCRM\BaseBundle\Entity\Country	No errors.
NexCRM\BaseBundle\Entity\Setting	No errors.
NexCRM\WebBundle\Entity\Code	No errors.
NexCRM\WebBundle\Entity\CodeTranslation	No errors.
NexCRM\BaseBundle\Entity\SettingTranslation	No errors.
NexCRM\WebBundle\Entity\Cookie	No errors.
NexCRM\WebBundle\Entity\CookieTranslation	No errors.
NexCRM\BaseBundle\Entity\MediaOrderRecord	No errors.

Symfony Profiler

GET http://dev69.nexgen.cz/admin/web/cron/marketing

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping