Symfony Profiler

Query Metrics

123 Database Queries

9 Different statements

24.45 ms Query time

4 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

16.54 ms
(67.62%)

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = ? AND t0.type_vote = ?

Parameters:

[
  62
  "upvote"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 62 AND t0.type_vote = 'upvote';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 838)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->count (line 139)
3	Doctrine\ORM\EntityRepository->count (line 86)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->count (line 45)
5	App\Controller\HomeController->index (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

2.43 ms
(9.93%)

SELECT t0.id AS id_1, t0.name_category AS name_category_2, t0.categories_id AS categories_id_3 FROM category t0 INNER JOIN deal_category ON t0.id = deal_category.category_id WHERE deal_category.deal_id = ?

Parameters:

[
  62
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name_category AS name_category_2,
  t0.categories_id AS categories_id_3
FROM
  category t0
  INNER JOIN deal_category ON t0.id = deal_category.category_id
WHERE
  deal_category.deal_id = ?

SELECT t0.id AS id_1, t0.name_category AS name_category_2, t0.categories_id AS categories_id_3 FROM category t0 INNER JOIN deal_category ON t0.id = deal_category.category_id WHERE deal_category.deal_id = 62;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1051)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 980)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2709)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 1137)
9	Twig\Extension\CoreExtension::length (line 251)
10	__TwigTemplate_186472bedf22535f3500e8844a52e1d3->block_body (line 430)
11	Twig\Template->yieldBlock (line 299)
12	__TwigTemplate_a86ef6b95c80d7f1552db3a158b287a8->doDisplay (line 360)
13	Twig\Template->yield (line 51)
14	__TwigTemplate_186472bedf22535f3500e8844a52e1d3->doDisplay (line 360)
15	Twig\Template->yield (line 335)
16	Twig\Template->render (line 38)
17	Twig\TemplateWrapper->render (line 307)
18	Twig\Environment->render (line 431)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 73)
22	App\Controller\HomeController->index (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

1.98 ms
(8.09%)

SELECT t0.id AS id_1, t0.content AS content_2, t0.comment_time AS comment_time_3, t0.user_id AS user_id_4, t0.deal_id AS deal_id_5, t0.parent_id AS parent_id_6 FROM COMMENT t0 WHERE t0.deal_id = ?

Parameters:

[
  62
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.comment_time AS comment_time_3,
  t0.user_id AS user_id_4,
  t0.deal_id AS deal_id_5,
  t0.parent_id AS parent_id_6
FROM
  COMMENT t0
WHERE
  t0.deal_id = ?

SELECT t0.id AS id_1, t0.content AS content_2, t0.comment_time AS comment_time_3, t0.user_id AS user_id_4, t0.deal_id AS deal_id_5, t0.parent_id AS parent_id_6 FROM COMMENT t0 WHERE t0.deal_id = 62;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1803)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1748)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2705)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 1137)
9	Twig\Extension\CoreExtension::length (line 307)
10	__TwigTemplate_186472bedf22535f3500e8844a52e1d3->block_body (line 430)
11	Twig\Template->yieldBlock (line 299)
12	__TwigTemplate_a86ef6b95c80d7f1552db3a158b287a8->doDisplay (line 360)
13	Twig\Template->yield (line 51)
14	__TwigTemplate_186472bedf22535f3500e8844a52e1d3->doDisplay (line 360)
15	Twig\Template->yield (line 335)
16	Twig\Template->render (line 38)
17	Twig\TemplateWrapper->render (line 307)
18	Twig\Environment->render (line 431)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 73)
22	App\Controller\HomeController->index (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

1.51 ms
(6.16%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.inscription_time AS inscription_time_7, t0.username AS username_8 FROM user t0 WHERE t0.id = ?

Parameters:

[
  45
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.firstname AS firstname_5,
  t0.lastname AS lastname_6,
  t0.inscription_time AS inscription_time_7,
  t0.username AS username_8
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.inscription_time AS inscription_time_7, t0.username AS username_8 FROM user t0 WHERE t0.id = 45;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\User::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 129)
7	Proxies\__CG__\App\Entity\User->__get (line 277)
8	App\Entity\User->getUsername (line 1629)
9	Twig\Extension\CoreExtension::getAttribute (line 282)
10	__TwigTemplate_186472bedf22535f3500e8844a52e1d3->block_body (line 430)
11	Twig\Template->yieldBlock (line 299)
12	__TwigTemplate_a86ef6b95c80d7f1552db3a158b287a8->doDisplay (line 360)
13	Twig\Template->yield (line 51)
14	__TwigTemplate_186472bedf22535f3500e8844a52e1d3->doDisplay (line 360)
15	Twig\Template->yield (line 335)
16	Twig\Template->render (line 38)
17	Twig\TemplateWrapper->render (line 307)
18	Twig\Environment->render (line 431)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 73)
22	App\Controller\HomeController->index (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.65 ms
(2.66%)

SELECT COUNT(DISTINCT d0_.id) AS sclr_0 FROM deal d0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT d0_.id) AS sclr_0
FROM
  deal d0_

SELECT COUNT(DISTINCT d0_.id) AS sclr_0 FROM deal d0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 96)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 1)
8	count (line 43)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 98)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerZJA2Onf\PaginatorProxyBa079e5->paginate (line 37)
16	App\Controller\HomeController->index (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.46 ms
(1.86%)

SELECT d0_.id AS id_0, d0_.title AS title_1, d0_.description AS description_2, d0_.initialprice AS initialprice_3, d0_.reduceprice AS reduceprice_4, d0_.publicationdate AS publicationdate_5, d0_.link AS link_6, d0_.delivery AS delivery_7, d0_.image_filename AS image_filename_8, d0_.is_active AS is_active_9, d0_.is_published AS is_published_10, d0_.user_id AS user_id_11 FROM deal d0_ WHERE d0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY d0_.publicationdate DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id AS id_0,
  d0_.title AS title_1,
  d0_.description AS description_2,
  d0_.initialprice AS initialprice_3,
  d0_.reduceprice AS reduceprice_4,
  d0_.publicationdate AS publicationdate_5,
  d0_.link AS link_6,
  d0_.delivery AS delivery_7,
  d0_.image_filename AS image_filename_8,
  d0_.is_active AS is_active_9,
  d0_.is_published AS is_published_10,
  d0_.user_id AS user_id_11
FROM
  deal d0_
WHERE
  d0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  d0_.publicationdate DESC

SELECT d0_.id AS id_0, d0_.title AS title_1, d0_.description AS description_2, d0_.initialprice AS initialprice_3, d0_.reduceprice AS reduceprice_4, d0_.publicationdate AS publicationdate_5, d0_.link AS link_6, d0_.delivery AS delivery_7, d0_.image_filename AS image_filename_8, d0_.is_active AS is_active_9, d0_.is_published AS is_published_10, d0_.user_id AS user_id_11 FROM deal d0_ WHERE d0_.id IN (62, 51, 65, 63, 36, 67, 53, 58, 64, 55) ORDER BY d0_.publicationdate DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 145)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 98)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerZJA2Onf\PaginatorProxyBa079e5->paginate (line 37)
16	App\Controller\HomeController->index (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.34 ms
(1.40%)

SELECT t0.id AS id_1, t0.name_category AS name_category_2, t0.categories_id AS categories_id_3 FROM category t0 WHERE t0.categories_id IS NULL

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name_category AS name_category_2,
  t0.categories_id AS categories_id_3
FROM
  category t0
WHERE
  t0.categories_id IS NULL

SELECT t0.id AS id_1, t0.name_category AS name_category_2, t0.categories_id AS categories_id_3 FROM category t0 WHERE t0.categories_id IS NULL;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 16)
5	App\Service\CategoryService->get1stLevelCategories (line 26)
6	App\Twig\AppExtension->get1stLevelCategories (line 100)
7	__TwigTemplate_186472bedf22535f3500e8844a52e1d3->block_body (line 430)
8	Twig\Template->yieldBlock (line 299)
9	__TwigTemplate_a86ef6b95c80d7f1552db3a158b287a8->doDisplay (line 360)
10	Twig\Template->yield (line 51)
11	__TwigTemplate_186472bedf22535f3500e8844a52e1d3->doDisplay (line 360)
12	Twig\Template->yield (line 335)
13	Twig\Template->render (line 38)
14	Twig\TemplateWrapper->render (line 307)
15	Twig\Environment->render (line 431)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 73)
19	App\Controller\HomeController->index (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.32 ms
(1.30%)

SELECT DISTINCT d0_.id AS id_0, d0_.publicationdate AS publicationdate_1 FROM deal d0_ ORDER BY d0_.publicationdate DESC LIMIT 10

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT d0_.id AS id_0,
  d0_.publicationdate AS publicationdate_1
FROM
  deal d0_
ORDER BY
  d0_.publicationdate DESC
LIMIT
  10

SELECT DISTINCT d0_.id AS id_0, d0_.publicationdate AS publicationdate_1 FROM deal d0_ ORDER BY d0_.publicationdate DESC LIMIT 10;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 127)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 98)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerZJA2Onf\PaginatorProxyBa079e5->paginate (line 37)
16	App\Controller\HomeController->index (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.24 ms
(0.97%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.initialprice AS initialprice_4, t0.reduceprice AS reduceprice_5, t0.publicationdate AS publicationdate_6, t0.link AS link_7, t0.delivery AS delivery_8, t0.image_filename AS image_filename_9, t0.is_active AS is_active_10, t0.is_published AS is_published_11, t0.user_id AS user_id_12 FROM deal 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,
  t0.initialprice AS initialprice_4,
  t0.reduceprice AS reduceprice_5,
  t0.publicationdate AS publicationdate_6,
  t0.link AS link_7,
  t0.delivery AS delivery_8,
  t0.image_filename AS image_filename_9,
  t0.is_active AS is_active_10,
  t0.is_published AS is_published_11,
  t0.user_id AS user_id_12
FROM
  deal t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.initialprice AS initialprice_4, t0.reduceprice AS reduceprice_5, t0.publicationdate AS publicationdate_6, t0.link AS link_7, t0.delivery AS delivery_8, t0.image_filename AS image_filename_9, t0.is_active AS is_active_10, t0.is_published AS is_published_11, t0.user_id AS user_id_12 FROM deal t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 55)
6	App\Controller\HomeController->index (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	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\Deal	The mappings App\Entity\Deal#user and App\Entity\User#deals are inconsistent with each other.
App\Entity\User	The association App\Entity\User#deals refers to the owning side field App\Entity\Deal#idUser which does not exist. The association App\Entity\User#comments refers to the owning side field App\Entity\Comment#User which does not exist. The association App\Entity\User#votes refers to the owning side field App\Entity\Vote#User which does not exist.
App\Entity\Comment	The mappings App\Entity\Comment#user and App\Entity\User#comments are inconsistent with each other.
App\Entity\Vote	The mappings App\Entity\Vote#user and App\Entity\User#votes are inconsistent with each other.
App\Entity\Category	No errors.

Symfony Profiler

GET http://localhost:8081/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping