Symfony Profiler

Query Metrics

16 Database Queries

9 Different statements

11.88 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.96 ms
(24.94%)

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 202)
4	App\Controller\DefaultController->proyecto (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.75 ms
(14.71%)

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:

[
  18
]

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

#	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 167)
7	Doctrine\Common\Collections\AbstractLazyCollection->first (line 182)
8	App\Controller\DefaultController->proyecto (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.51 ms
(12.72%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.resume AS resume_4, t0.date AS date_5, t0.principal_image AS principal_image_6, t0.top AS top_7, t0.user_id_id AS user_id_id_8 FROM projects t0 WHERE t0.id = ?

Parameters:

[
  "18"
]

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,
  t0.resume AS resume_4,
  t0.date AS date_5,
  t0.principal_image AS principal_image_6,
  t0.top AS top_7,
  t0.user_id_id AS user_id_id_8
FROM
  projects t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.resume AS resume_4, t0.date AS date_5, t0.principal_image AS principal_image_6, t0.top AS top_7, t0.user_id_id AS user_id_id_8 FROM projects t0 WHERE t0.id = '18';

#	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 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 116)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 60)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 90)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

1.42 ms
(11.93%)

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 179)
4	App\Controller\DefaultController->proyecto (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.13 ms
(9.48%)

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 180)
8	App\Controller\DefaultController->proyecto (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.00 ms
(8.46%)

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

Parameters:

[
  18
]

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.project_id_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.project_id_id = 18;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1886)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1827)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3166)
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 137)
8	__TwigTemplate_79b608aa03f4c397c32d9cbe8ffe315b->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_79b608aa03f4c397c32d9cbe8ffe315b->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 221)
21	App\Controller\DefaultController->proyecto (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)

0.82 ms
(6.88%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.resume AS resume_4, t0.date AS date_5, t0.principal_image AS principal_image_6, t0.top AS top_7, t0.user_id_id AS user_id_id_8 FROM projects t0 INNER JOIN projects_tags ON t0.id = projects_tags.projects_id WHERE projects_tags.tags_id = ?

Parameters:

[
  3
]

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,
  t0.resume AS resume_4,
  t0.date AS date_5,
  t0.principal_image AS principal_image_6,
  t0.top AS top_7,
  t0.user_id_id AS user_id_id_8
FROM
  projects t0
  INNER JOIN projects_tags ON t0.id = projects_tags.projects_id
WHERE
  projects_tags.tags_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.resume AS resume_4, t0.date AS date_5, t0.principal_image AS principal_image_6, t0.top AS top_7, t0.user_id_id AS user_id_id_8 FROM projects t0 INNER JOIN projects_tags ON t0.id = projects_tags.projects_id WHERE projects_tags.tags_id = 3;

#	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 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 458)
8	Doctrine\ORM\PersistentCollection->count (line 1274)
9	twig_test_empty (line 221)
10	__TwigTemplate_79b608aa03f4c397c32d9cbe8ffe315b->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_79b608aa03f4c397c32d9cbe8ffe315b->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 221)
23	App\Controller\DefaultController->proyecto (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)

0.75 ms
(6.30%)

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 551)
10	__TwigTemplate_b902027f532d4fac168ec3cdd207c0dc->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 50)
13	__TwigTemplate_79b608aa03f4c397c32d9cbe8ffe315b->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 221)
21	App\Controller\DefaultController->proyecto (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)

0.54 ms
(4.58%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3 FROM tags t0 WHERE t0.id = ? LIMIT 1

Parameters:

[
  3
]

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
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3 FROM tags t0 WHERE t0.id = 3 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 183)
4	App\Controller\DefaultController->proyecto (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)

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\Projects	No errors.
App\Entity\Users	No errors.
App\Entity\Tags	No errors.
App\Entity\Photos	No errors.
App\Entity\Pages	No errors.
App\Entity\Posts	No errors.
App\Entity\Btags	No errors.
App\Entity\Fields	No errors.

Symfony Profiler

GET https://rynekconstructora.com/proyectos/18/detalle

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping