Symfony Profiler

Query Metrics

176 Database Queries

11 Different statements

54.03 ms Query time

0 Invalid entities

158 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

23.46 ms
(43.42%)

SELECT w0_.entity AS entity_0, w0_.controller AS controller_1, w0_.bundle AS bundle_2, w0_.action AS action_3, w0_.id AS id_4 FROM web_module w0_ WHERE w0_.entity LIKE ?

Parameters:

[
  "%Page"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  w0_.entity AS entity_0,
  w0_.controller AS controller_1,
  w0_.bundle AS bundle_2,
  w0_.action AS action_3,
  w0_.id AS id_4
FROM
  web_module w0_
WHERE
  w0_.entity LIKE ?

SELECT w0_.entity AS entity_0, w0_.controller AS controller_1, w0_.bundle AS bundle_2, w0_.action AS action_3, w0_.id AS id_4 FROM web_module w0_ WHERE w0_.entity LIKE '%Page';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 958)
6	NexCRM\WebBundle\Routing\FrontLoader->load (line 91)
7	Symfony\Component\Config\Loader\FileLoader->doImport (line 159)
8	Symfony\Component\Config\Loader\FileLoader->import (line 111)
9	Symfony\Component\Routing\Loader\YamlFileLoader->parseImport (line 214)
10	Symfony\Component\Routing\Loader\YamlFileLoader->load (line 99)
11	Symfony\Component\Config\Loader\FileLoader->doImport (line 180)
12	Symfony\Component\Config\Loader\FileLoader->import (line 97)
13	Symfony\Component\Routing\Loader\Configurator\RoutingConfigurator->import (line 45)
14	App\Kernel->configureRoutes (line 51)
15	App\Kernel->loadRoutes (line 213)
16	Symfony\Component\Routing\Loader\ObjectLoader->load (line 55)
17	Symfony\Component\Config\Loader\DelegatingLoader->load (line 37)
18	Symfony\Bundle\FrameworkBundle\Routing\DelegatingLoader->load (line 67)
19	Symfony\Bundle\FrameworkBundle\Routing\Router->getRouteCollection (line 65)
20	FOS\JsRoutingBundle\Extractor\ExposedRoutesExtractor->getRoutes (line 52)
21	FOS\JsRoutingBundle\Controller\Controller->indexAction (line 63)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 208)
25	handle (line 42)

11.22 ms
(20.77%)

SELECT t0.title AS title_1, t0.description AS description_2, t0.keywords AS keywords_3, t0.name AS name_4, t0.url AS url_5, t0.is_generated AS is_generated_6, t0.id AS id_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM web_seo_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  21
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.title AS title_1,
  t0.description AS description_2,
  t0.keywords AS keywords_3,
  t0.name AS name_4,
  t0.url AS url_5,
  t0.is_generated AS is_generated_6,
  t0.id AS id_7,
  t0.locale AS locale_8,
  t0.translatable_id AS translatable_id_9
FROM
  web_seo_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.title AS title_1, t0.description AS description_2, t0.keywords AS keywords_3, t0.name AS name_4, t0.url AS url_5, t0.is_generated AS is_generated_6, t0.id AS id_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM web_seo_translation t0 WHERE t0.translatable_id = 21;

#	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->getIterator (line 315)
7	NexCRM\WebBundle\Routing\FrontLoader->load (line 56)
8	Symfony\Component\Config\Loader\FileLoader->doImport (line 159)
9	Symfony\Component\Config\Loader\FileLoader->import (line 111)
10	Symfony\Component\Routing\Loader\YamlFileLoader->parseImport (line 214)
11	Symfony\Component\Routing\Loader\YamlFileLoader->load (line 99)
12	Symfony\Component\Config\Loader\FileLoader->doImport (line 180)
13	Symfony\Component\Config\Loader\FileLoader->import (line 97)
14	Symfony\Component\Routing\Loader\Configurator\RoutingConfigurator->import (line 45)
15	App\Kernel->configureRoutes (line 51)
16	App\Kernel->loadRoutes (line 213)
17	Symfony\Component\Routing\Loader\ObjectLoader->load (line 55)
18	Symfony\Component\Config\Loader\DelegatingLoader->load (line 37)
19	Symfony\Bundle\FrameworkBundle\Routing\DelegatingLoader->load (line 67)
20	Symfony\Bundle\FrameworkBundle\Routing\Router->getRouteCollection (line 65)
21	FOS\JsRoutingBundle\Extractor\ExposedRoutesExtractor->getRoutes (line 52)
22	FOS\JsRoutingBundle\Controller\Controller->indexAction (line 63)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 208)
26	handle (line 42)

7.21 ms
(13.34%)

SELECT t0.url AS url_1, t0.name AS name_2, t0.id AS id_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM web_module_translation t0 WHERE t0.url = ? LIMIT 1

Parameters:

[
  "stitek"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.url AS url_1,
  t0.name AS name_2,
  t0.id AS id_3,
  t0.locale AS locale_4,
  t0.translatable_id AS translatable_id_5
FROM
  web_module_translation t0
WHERE
  t0.url = ?
LIMIT
  1

SELECT t0.url AS url_1, t0.name AS name_2, t0.id AS id_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM web_module_translation t0 WHERE t0.url = 'stitek' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	NexCRM\WebBundle\Routing\FrontLoader->load (line 65)
4	Symfony\Component\Config\Loader\FileLoader->doImport (line 159)
5	Symfony\Component\Config\Loader\FileLoader->import (line 111)
6	Symfony\Component\Routing\Loader\YamlFileLoader->parseImport (line 214)
7	Symfony\Component\Routing\Loader\YamlFileLoader->load (line 99)
8	Symfony\Component\Config\Loader\FileLoader->doImport (line 180)
9	Symfony\Component\Config\Loader\FileLoader->import (line 97)
10	Symfony\Component\Routing\Loader\Configurator\RoutingConfigurator->import (line 45)
11	App\Kernel->configureRoutes (line 51)
12	App\Kernel->loadRoutes (line 213)
13	Symfony\Component\Routing\Loader\ObjectLoader->load (line 55)
14	Symfony\Component\Config\Loader\DelegatingLoader->load (line 37)
15	Symfony\Bundle\FrameworkBundle\Routing\DelegatingLoader->load (line 67)
16	Symfony\Bundle\FrameworkBundle\Routing\Router->getRouteCollection (line 65)
17	FOS\JsRoutingBundle\Extractor\ExposedRoutesExtractor->getRoutes (line 52)
18	FOS\JsRoutingBundle\Controller\Controller->indexAction (line 63)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 208)
22	handle (line 42)

4.29 ms
(7.94%)

SELECT t0.entity AS entity_1, t0.controller AS controller_2, t0.bundle AS bundle_3, t0.action AS action_4, t0.id AS id_5 FROM web_module t0 WHERE t0.id = ? LIMIT 1

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.entity AS entity_1,
  t0.controller AS controller_2,
  t0.bundle AS bundle_3,
  t0.action AS action_4,
  t0.id AS id_5
FROM
  web_module t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.entity AS entity_1, t0.controller AS controller_2, t0.bundle AS bundle_3, t0.action AS action_4, t0.id AS id_5 FROM web_module t0 WHERE t0.id = 3 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	NexCRM\WebBundle\Routing\FrontLoader->load (line 69)
4	Symfony\Component\Config\Loader\FileLoader->doImport (line 159)
5	Symfony\Component\Config\Loader\FileLoader->import (line 111)
6	Symfony\Component\Routing\Loader\YamlFileLoader->parseImport (line 214)
7	Symfony\Component\Routing\Loader\YamlFileLoader->load (line 99)
8	Symfony\Component\Config\Loader\FileLoader->doImport (line 180)
9	Symfony\Component\Config\Loader\FileLoader->import (line 97)
10	Symfony\Component\Routing\Loader\Configurator\RoutingConfigurator->import (line 45)
11	App\Kernel->configureRoutes (line 51)
12	App\Kernel->loadRoutes (line 213)
13	Symfony\Component\Routing\Loader\ObjectLoader->load (line 55)
14	Symfony\Component\Config\Loader\DelegatingLoader->load (line 37)
15	Symfony\Bundle\FrameworkBundle\Routing\DelegatingLoader->load (line 67)
16	Symfony\Bundle\FrameworkBundle\Routing\Router->getRouteCollection (line 65)
17	FOS\JsRoutingBundle\Extractor\ExposedRoutesExtractor->getRoutes (line 52)
18	FOS\JsRoutingBundle\Controller\Controller->indexAction (line 63)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 208)
22	handle (line 42)

3.78 ms
(6.99%)

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:

[
  "68183758a6_6a8e722c528f84.67382634"
]

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 = '68183758a6_6a8e722c528f84.67382634';

#	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 142)
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 208)
12	handle (line 42)

1.16 ms
(2.14%)

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 142)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 208)
11	handle (line 42)

0.96 ms
(1.77%)

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 142)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 208)
11	handle (line 42)

0.55 ms
(1.01%)

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 142)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 208)
11	handle (line 42)

0.53 ms
(0.98%)

SELECT t0.alias AS alias_1, t0.value AS value_2, t0.id AS id_3 FROM setting t0 WHERE t0.alias = ? LIMIT 1

Parameters:

[
  "webbundle_seo_noindex_route"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.alias AS alias_1,
  t0.value AS value_2,
  t0.id AS id_3
FROM
  setting t0
WHERE
  t0.alias = ?
LIMIT
  1

SELECT t0.alias AS alias_1, t0.value AS value_2, t0.id AS id_3 FROM setting t0 WHERE t0.alias = 'webbundle_seo_noindex_route' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	NexCRM\WebBundle\Routing\FrontLoader->load (line 43)
4	Symfony\Component\Config\Loader\FileLoader->doImport (line 159)
5	Symfony\Component\Config\Loader\FileLoader->import (line 111)
6	Symfony\Component\Routing\Loader\YamlFileLoader->parseImport (line 214)
7	Symfony\Component\Routing\Loader\YamlFileLoader->load (line 99)
8	Symfony\Component\Config\Loader\FileLoader->doImport (line 180)
9	Symfony\Component\Config\Loader\FileLoader->import (line 97)
10	Symfony\Component\Routing\Loader\Configurator\RoutingConfigurator->import (line 45)
11	App\Kernel->configureRoutes (line 51)
12	App\Kernel->loadRoutes (line 213)
13	Symfony\Component\Routing\Loader\ObjectLoader->load (line 55)
14	Symfony\Component\Config\Loader\DelegatingLoader->load (line 37)
15	Symfony\Bundle\FrameworkBundle\Routing\DelegatingLoader->load (line 67)
16	Symfony\Bundle\FrameworkBundle\Routing\Router->getRouteCollection (line 65)
17	FOS\JsRoutingBundle\Extractor\ExposedRoutesExtractor->getRoutes (line 52)
18	FOS\JsRoutingBundle\Controller\Controller->indexAction (line 63)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 208)
22	handle (line 42)

0.48 ms
(0.89%)

SELECT t0.disabled AS disabled_1, t0.noindex AS noindex_2, t0.module AS module_3, t0.anchor AS anchor_4, t0.suffix AS suffix_5, t0.entity AS entity_6, t0.id AS id_7 FROM web_seo t0 WHERE t0.noindex = ? AND t0.disabled = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.disabled AS disabled_1,
  t0.noindex AS noindex_2,
  t0.module AS module_3,
  t0.anchor AS anchor_4,
  t0.suffix AS suffix_5,
  t0.entity AS entity_6,
  t0.id AS id_7
FROM
  web_seo t0
WHERE
  t0.noindex = ?
  AND t0.disabled = ?

SELECT t0.disabled AS disabled_1, t0.noindex AS noindex_2, t0.module AS module_3, t0.anchor AS anchor_4, t0.suffix AS suffix_5, t0.entity AS entity_6, t0.id AS id_7 FROM web_seo t0 WHERE t0.noindex = 0 AND t0.disabled = 0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 995)
2	Doctrine\ORM\EntityRepository->findBy (line 224)
3	NexCRM\WebBundle\Routing\FrontLoader->load (line 48)
4	Symfony\Component\Config\Loader\FileLoader->doImport (line 159)
5	Symfony\Component\Config\Loader\FileLoader->import (line 111)
6	Symfony\Component\Routing\Loader\YamlFileLoader->parseImport (line 214)
7	Symfony\Component\Routing\Loader\YamlFileLoader->load (line 99)
8	Symfony\Component\Config\Loader\FileLoader->doImport (line 180)
9	Symfony\Component\Config\Loader\FileLoader->import (line 97)
10	Symfony\Component\Routing\Loader\Configurator\RoutingConfigurator->import (line 45)
11	App\Kernel->configureRoutes (line 51)
12	App\Kernel->loadRoutes (line 213)
13	Symfony\Component\Routing\Loader\ObjectLoader->load (line 55)
14	Symfony\Component\Config\Loader\DelegatingLoader->load (line 37)
15	Symfony\Bundle\FrameworkBundle\Routing\DelegatingLoader->load (line 67)
16	Symfony\Bundle\FrameworkBundle\Routing\Router->getRouteCollection (line 65)
17	FOS\JsRoutingBundle\Extractor\ExposedRoutesExtractor->getRoutes (line 52)
18	FOS\JsRoutingBundle\Controller\Controller->indexAction (line 63)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 208)
22	handle (line 42)

0.41 ms
(0.75%)

SELECT t0.homepage AS homepage_1, t0.doc_files_order AS doc_files_order_2, t0.id AS id_3, t0.sort AS sort_4, t0.img_files_order AS img_files_order_5, t0.dms_img_updated AS dms_img_updated_6, t0.parent AS parent_7, t0.seo_id AS seo_id_8, t0.template_id AS template_id_9, t0.img_file_id AS img_file_id_10, t0.doc_file_id AS doc_file_id_11 FROM web_page t0 WHERE t0.homepage = ? LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.homepage AS homepage_1,
  t0.doc_files_order AS doc_files_order_2,
  t0.id AS id_3,
  t0.sort AS sort_4,
  t0.img_files_order AS img_files_order_5,
  t0.dms_img_updated AS dms_img_updated_6,
  t0.parent AS parent_7,
  t0.seo_id AS seo_id_8,
  t0.template_id AS template_id_9,
  t0.img_file_id AS img_file_id_10,
  t0.doc_file_id AS doc_file_id_11
FROM
  web_page t0
WHERE
  t0.homepage = ?
LIMIT
  1

SELECT t0.homepage AS homepage_1, t0.doc_files_order AS doc_files_order_2, t0.id AS id_3, t0.sort AS sort_4, t0.img_files_order AS img_files_order_5, t0.dms_img_updated AS dms_img_updated_6, t0.parent AS parent_7, t0.seo_id AS seo_id_8, t0.template_id AS template_id_9, t0.img_file_id AS img_file_id_10, t0.doc_file_id AS doc_file_id_11 FROM web_page t0 WHERE t0.homepage = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	NexCRM\WebBundle\Routing\FrontLoader->load (line 51)
4	Symfony\Component\Config\Loader\FileLoader->doImport (line 159)
5	Symfony\Component\Config\Loader\FileLoader->import (line 111)
6	Symfony\Component\Routing\Loader\YamlFileLoader->parseImport (line 214)
7	Symfony\Component\Routing\Loader\YamlFileLoader->load (line 99)
8	Symfony\Component\Config\Loader\FileLoader->doImport (line 180)
9	Symfony\Component\Config\Loader\FileLoader->import (line 97)
10	Symfony\Component\Routing\Loader\Configurator\RoutingConfigurator->import (line 45)
11	App\Kernel->configureRoutes (line 51)
12	App\Kernel->loadRoutes (line 213)
13	Symfony\Component\Routing\Loader\ObjectLoader->load (line 55)
14	Symfony\Component\Config\Loader\DelegatingLoader->load (line 37)
15	Symfony\Bundle\FrameworkBundle\Routing\DelegatingLoader->load (line 67)
16	Symfony\Bundle\FrameworkBundle\Routing\Router->getRouteCollection (line 65)
17	FOS\JsRoutingBundle\Extractor\ExposedRoutesExtractor->getRoutes (line 52)
18	FOS\JsRoutingBundle\Controller\Controller->indexAction (line 63)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 208)
22	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\SEOTranslation	108
NexCRM\WebBundle\Entity\SEO	36
NexCRM\BaseBundle\Entity\Lang	3
NexCRM\BaseBundle\Entity\Country	3
NexCRM\WebBundle\Entity\Module	3
NexCRM\WebBundle\Entity\ModuleTranslation	3
NexCRM\BaseBundle\Entity\Setting	1
NexCRM\WebBundle\Entity\Page	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\BaseBundle\Entity\SettingTranslation	No errors.
NexCRM\WebBundle\Entity\SEO	No errors.
NexCRM\WebBundle\Entity\SEOTranslation	No errors.
NexCRM\WebBundle\Entity\Page	No errors.
NexCRM\WebBundle\Entity\Template	No errors.
NexCRM\DMSBundle\Entity\File	No errors.
NexCRM\WebBundle\Entity\Content	No errors.
NexCRM\WebBundle\Entity\PageTranslation	No errors.
NexCRM\WebBundle\Entity\Module	No errors.
NexCRM\WebBundle\Entity\ModuleTranslation	No errors.
NexCRM\BaseBundle\Entity\MediaOrderRecord	No errors.

Symfony Profiler

GET https://dev69.nexgen.cz/js/routing?callback=fos.Router.setData

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping