Symfony Profiler

Query Metrics

11 Database Queries

5 Different statements

7.50 ms Query time

0 Invalid entities

554 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.28 ms
(43.69%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.updated_at AS updated_at_3, t0.headquarter AS headquarter_4, t0.ico AS ico_5, t0.dic AS dic_6, t0.bank_no AS bank_no_7, t0.correspondece AS correspondece_8, t0.approved AS approved_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.nationwide AS nationwide_12, t0.slug AS slug_13, t0.changes_md_sum AS changes_md_sum_14, t0.approved_by_id AS approved_by_id_15, t0.owner_id AS owner_id_16, t0.logo_id AS logo_id_17 FROM company t0 WHERE t0.approved = ? ORDER BY t0.name ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.updated_at AS updated_at_3,
  t0.headquarter AS headquarter_4,
  t0.ico AS ico_5,
  t0.dic AS dic_6,
  t0.bank_no AS bank_no_7,
  t0.correspondece AS correspondece_8,
  t0.approved AS approved_9,
  t0.latitude AS latitude_10,
  t0.longitude AS longitude_11,
  t0.nationwide AS nationwide_12,
  t0.slug AS slug_13,
  t0.changes_md_sum AS changes_md_sum_14,
  t0.approved_by_id AS approved_by_id_15,
  t0.owner_id AS owner_id_16,
  t0.logo_id AS logo_id_17
FROM
  company t0
WHERE
  t0.approved = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.updated_at AS updated_at_3, t0.headquarter AS headquarter_4, t0.ico AS ico_5, t0.dic AS dic_6, t0.bank_no AS bank_no_7, t0.correspondece AS correspondece_8, t0.approved AS approved_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.nationwide AS nationwide_12, t0.slug AS slug_13, t0.changes_md_sum AS changes_md_sum_14, t0.approved_by_id AS approved_by_id_15, t0.owner_id AS owner_id_16, t0.logo_id AS logo_id_17 FROM company t0 WHERE t0.approved = 1 ORDER BY t0.name ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\IndexController->index (line 29)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

2.33 ms
(31.08%)

SELECT t0.id AS id_1, t0.file AS file_2, t0.updated_at AS updated_at_3 FROM uploaded t0 WHERE t0.id = ?

Parameters:

[
  473
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.file AS file_2,
  t0.updated_at AS updated_at_3
FROM
  uploaded t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.file AS file_2, t0.updated_at AS updated_at_3 FROM uploaded t0 WHERE t0.id = 473;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\Uploaded::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 59)
6	Proxies\__CG__\App\Entity\Uploaded->__get (line 129)
7	App\Entity\Uploaded->getFile (line 51)
8	Twig\Extension\CoreExtension->getAttribute (line 1909)
9	__TwigTemplate_a346f205fcce284499a62bf4205fe9fb::doDisplay (line 260)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_53369f3157bed95ec28f8e4b2db8582b->doDisplay (line 109)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_a229f0aad3a4925574b04ec2cedd430c->doDisplay (line 55)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
22	App\Controller\IndexController->index (line 32)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

1.07 ms
(14.33%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_approved AS is_approved_3, t0.updated_at AS updated_at_4, t0.fonticon AS fonticon_5, t0.poradi AS poradi_6, t0.approved_by_id AS approved_by_id_7, t0.icon_id AS icon_id_8 FROM category_company t0 WHERE t0.is_approved = ? ORDER BY t0.name ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_approved AS is_approved_3,
  t0.updated_at AS updated_at_4,
  t0.fonticon AS fonticon_5,
  t0.poradi AS poradi_6,
  t0.approved_by_id AS approved_by_id_7,
  t0.icon_id AS icon_id_8
FROM
  category_company t0
WHERE
  t0.is_approved = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_approved AS is_approved_3, t0.updated_at AS updated_at_4, t0.fonticon AS fonticon_5, t0.poradi AS poradi_6, t0.approved_by_id AS approved_by_id_7, t0.icon_id AS icon_id_8 FROM category_company t0 WHERE t0.is_approved = 1 ORDER BY t0.name ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\IndexController->index (line 30)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

0.42 ms
(5.59%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.general_partner AS general_partner_3, t0.web_url AS web_url_4, t0.poradi AS poradi_5, t0.logo_id AS logo_id_6 FROM partners t0 ORDER BY t0.poradi ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.general_partner AS general_partner_3,
  t0.web_url AS web_url_4,
  t0.poradi AS poradi_5,
  t0.logo_id AS logo_id_6
FROM
  partners t0
ORDER BY
  t0.poradi ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.general_partner AS general_partner_3, t0.web_url AS web_url_4, t0.poradi AS poradi_5, t0.logo_id AS logo_id_6 FROM partners t0 ORDER BY t0.poradi ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Twig\Extension\PartnerGlobalExtension->getGlobals (line 25)
5	Twig\ExtensionSet->getGlobals (line 359)
6	Twig\Environment->getGlobals (line 900)
7	Twig\Template->yield (line 398)
8	Twig\Template->display (line 358)
9	Twig\Template->render (line 373)
10	Twig\TemplateWrapper->render (line 51)
11	Twig\Environment->render (line 333)
12	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
15	App\Controller\IndexController->index (line 32)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 182)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

0.40 ms
(5.32%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.active AS active_4, t0.poradi AS poradi_5 FROM main_menu_items t0 WHERE t0.active = ? ORDER BY t0.poradi ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.active AS active_4,
  t0.poradi AS poradi_5
FROM
  main_menu_items t0
WHERE
  t0.active = ?
ORDER BY
  t0.poradi ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.active AS active_4, t0.poradi AS poradi_5 FROM main_menu_items t0 WHERE t0.active = 1 ORDER BY t0.poradi ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Twig\Extension\PartnerGlobalExtension->getGlobals (line 26)
5	Twig\ExtensionSet->getGlobals (line 359)
6	Twig\Environment->getGlobals (line 900)
7	Twig\Template->yield (line 398)
8	Twig\Template->display (line 358)
9	Twig\Template->render (line 373)
10	Twig\TemplateWrapper->render (line 51)
11	Twig\Environment->render (line 333)
12	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
15	App\Controller\IndexController->index (line 32)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 182)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

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\Company	256
App\Entity\Uploaded	256
App\Entity\User	19
App\Entity\CategoryCompany	10
App\Entity\Partners	7
App\Entity\MainMenuItems	6

Entities Mapping

Class	Mapping errors
App\Entity\Company	No errors.
App\Entity\User	No errors.
App\Entity\Uploaded	No errors.
App\Entity\Events	No errors.
App\Entity\Banners	No errors.
App\Entity\CategoryCompany	No errors.
App\Entity\Contacts	No errors.
App\Entity\TagsCompany	No errors.
App\Entity\EventContent	No errors.
App\Entity\Partners	No errors.
App\Entity\MainMenuItems	No errors.

Symfony Profiler

GET https://xkodev.dot11.cz/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping