Symfony Profiler

Query Metrics

26 Database Queries

9 Different statements

43.93 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

25.30 ms
(57.60%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.type AS type_4, t0.project_id_id AS project_id_id_5 FROM photos t0 WHERE t0.id = ?

Parameters:

[
  16
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.url AS url_3,
  t0.type AS type_4,
  t0.project_id_id AS project_id_id_5
FROM
  photos t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.type AS type_4, t0.project_id_id AS project_id_id_5 FROM photos t0 WHERE t0.id = 16;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 248)
4	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 134)
5	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 97)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 176)
7	Proxies\__CG__\App\Entity\Photos->__get (line 110)
8	App\Entity\Photos->__toString (line 115)
9	__TwigTemplate_87d1119ccdfc79de25e4573b532ed699->block_body (line 171)
10	Twig\Template->displayBlock (line 431)
11	__TwigTemplate_b902027f532d4fac168ec3cdd207c0dc->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 50)
14	__TwigTemplate_87d1119ccdfc79de25e4573b532ed699->doDisplay (line 394)
15	Twig\Template->displayWithErrorHandling (line 367)
16	Twig\Template->display (line 379)
17	Twig\Template->render (line 40)
18	Twig\TemplateWrapper->render (line 280)
19	Twig\Environment->render (line 243)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 77)
22	App\Controller\DefaultController->index (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

5.31 ms
(12.09%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3 FROM tags t0 INNER JOIN projects_tags ON t0.id = projects_tags.tags_id WHERE projects_tags.projects_id = ?

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3
FROM
  tags t0
  INNER JOIN projects_tags ON t0.id = projects_tags.tags_id
WHERE
  projects_tags.projects_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3 FROM tags t0 INNER JOIN projects_tags ON t0.id = projects_tags.tags_id WHERE projects_tags.projects_id = 5;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1087)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1009)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3170)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 640)
8	__TwigTemplate_87d1119ccdfc79de25e4573b532ed699->block_body (line 171)
9	Twig\Template->displayBlock (line 431)
10	__TwigTemplate_b902027f532d4fac168ec3cdd207c0dc->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 50)
13	__TwigTemplate_87d1119ccdfc79de25e4573b532ed699->doDisplay (line 394)
14	Twig\Template->displayWithErrorHandling (line 367)
15	Twig\Template->display (line 379)
16	Twig\Template->render (line 40)
17	Twig\TemplateWrapper->render (line 280)
18	Twig\Environment->render (line 243)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 77)
21	App\Controller\DefaultController->index (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

3.47 ms
(7.90%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.information AS information_4, t0.principal AS principal_5 FROM fields t0 WHERE t0.id = ? LIMIT 1

Parameters:

[
  6
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.type AS type_3,
  t0.information AS information_4,
  t0.principal AS principal_5
FROM
  fields t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.information AS information_4, t0.principal AS principal_5 FROM fields t0 WHERE t0.id = 6 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 56)
4	App\Controller\DefaultController->index (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

3.03 ms
(6.90%)

SELECT t0.id AS id_1, t0.page AS page_2, t0.type AS type_3, t0.content AS content_4, t0.image_id AS image_id_5 FROM pages t0 WHERE t0.type = ? LIMIT 1

Parameters:

[
  "headerfooter"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.page AS page_2,
  t0.type AS type_3,
  t0.content AS content_4,
  t0.image_id AS image_id_5
FROM
  pages t0
WHERE
  t0.type = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.page AS page_2, t0.type AS type_3, t0.content AS content_4, t0.image_id AS image_id_5 FROM pages t0 WHERE t0.type = 'headerfooter' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 29)
4	App\Controller\DefaultController->index (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

1.74 ms
(3.97%)

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.description AS description_2, p0_.resume AS resume_3, p0_.date AS date_4, p0_.principal_image AS principal_image_5, p0_.top AS top_6, p0_.user_id_id AS user_id_id_7 FROM projects p0_ ORDER BY p0_.date ASC LIMIT 9

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.description AS description_2,
  p0_.resume AS resume_3,
  p0_.date AS date_4,
  p0_.principal_image AS principal_image_5,
  p0_.top AS top_6,
  p0_.user_id_id AS user_id_id_7
FROM
  projects p0_
ORDER BY
  p0_.date ASC
LIMIT
  9

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.description AS description_2, p0_.resume AS resume_3, p0_.date AS date_4, p0_.principal_image AS principal_image_5, p0_.top AS top_6, p0_.user_id_id AS user_id_id_7 FROM projects p0_ ORDER BY p0_.date ASC LIMIT 9;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 33)
7	App\Repository\ProjectsRepository->findLastQuantity (line 32)
8	App\Controller\DefaultController->index (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

1.65 ms
(3.75%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3 FROM tags t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3
FROM
  tags t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3 FROM tags t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 31)
5	App\Controller\DefaultController->index (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

1.42 ms
(3.23%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5 FROM users t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.email AS email_5
FROM
  users t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5 FROM users t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 248)
4	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 134)
5	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 97)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 176)
7	Proxies\__CG__\App\Entity\Users->__get (line 58)
8	App\Entity\Users->getUsername (line 1637)
9	twig_get_attribute (line 1051)
10	__TwigTemplate_87d1119ccdfc79de25e4573b532ed699->block_body (line 171)
11	Twig\Template->displayBlock (line 431)
12	__TwigTemplate_b902027f532d4fac168ec3cdd207c0dc->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 50)
15	__TwigTemplate_87d1119ccdfc79de25e4573b532ed699->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 379)
18	Twig\Template->render (line 40)
19	Twig\TemplateWrapper->render (line 280)
20	Twig\Environment->render (line 243)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 77)
23	App\Controller\DefaultController->index (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

1.21 ms
(2.75%)

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.created AS created_2, p0_.description AS description_3, p0_.resume AS resume_4, p0_.image AS image_5, p0_.date AS date_6, p0_.user_id_id AS user_id_id_7 FROM posts p0_ ORDER BY p0_.date ASC LIMIT 4

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.created AS created_2,
  p0_.description AS description_3,
  p0_.resume AS resume_4,
  p0_.image AS image_5,
  p0_.date AS date_6,
  p0_.user_id_id AS user_id_id_7
FROM
  posts p0_
ORDER BY
  p0_.date ASC
LIMIT
  4

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.created AS created_2, p0_.description AS description_3, p0_.resume AS resume_4, p0_.image AS image_5, p0_.date AS date_6, p0_.user_id_id AS user_id_id_7 FROM posts p0_ ORDER BY p0_.date ASC LIMIT 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 33)
7	App\Repository\PostsRepository->findLastFour (line 33)
8	App\Controller\DefaultController->index (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.80 ms
(1.81%)

SELECT p0_.id AS id_0, p0_.page AS page_1, p0_.type AS type_2, p0_.content AS content_3, p0_.image_id AS image_id_4 FROM pages p0_ WHERE p0_.page = ? ORDER BY p0_.type ASC

Parameters:

[
  "Home"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.page AS page_1,
  p0_.type AS type_2,
  p0_.content AS content_3,
  p0_.image_id AS image_id_4
FROM
  pages p0_
WHERE
  p0_.page = ?
ORDER BY
  p0_.type ASC

SELECT p0_.id AS id_0, p0_.page AS page_1, p0_.type AS type_2, p0_.content AS content_3, p0_.image_id AS image_id_4 FROM pages p0_ WHERE p0_.page = 'Home' ORDER BY p0_.type ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 34)
7	App\Repository\PagesRepository->findAllByPage (line 30)
8	App\Controller\DefaultController->index (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	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.

Entities Mapping

Class	Mapping errors
App\Entity\Pages	No errors.
App\Entity\Photos	No errors.
App\Entity\Tags	No errors.
App\Entity\Projects	No errors.
App\Entity\Users	No errors.
App\Entity\Posts	No errors.
App\Entity\Btags	No errors.
App\Entity\Fields	No errors.

Symfony Profiler

GET https://rynekconstructora.com/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping