Symfony Profiler

Query Metrics

99 Database Queries

5 Different statements

23.63 ms Query time

4 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

15.80 ms
(66.85%)

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

Parameters:

[
  36
  "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 = 36 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 124)
5	App\Controller\HomeController->bestDeals (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.90 ms
(12.26%)

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:

[
  66
]

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

#	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 218)
10	__TwigTemplate_b347bdb342977caea7f7b74a7fb4de2f->block_body (line 430)
11	Twig\Template->yieldBlock (line 299)
12	__TwigTemplate_a86ef6b95c80d7f1552db3a158b287a8->doDisplay (line 360)
13	Twig\Template->yield (line 51)
14	__TwigTemplate_b347bdb342977caea7f7b74a7fb4de2f->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 143)
22	App\Controller\HomeController->bestDeals (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)

2.27 ms
(9.59%)

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:

[
  66
]

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

#	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 274)
10	__TwigTemplate_b347bdb342977caea7f7b74a7fb4de2f->block_body (line 430)
11	Twig\Template->yieldBlock (line 299)
12	__TwigTemplate_a86ef6b95c80d7f1552db3a158b287a8->doDisplay (line 360)
13	Twig\Template->yield (line 51)
14	__TwigTemplate_b347bdb342977caea7f7b74a7fb4de2f->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 143)
22	App\Controller\HomeController->bestDeals (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.88 ms
(7.97%)

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:

[
  51
]

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

#	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 249)
10	__TwigTemplate_b347bdb342977caea7f7b74a7fb4de2f->block_body (line 430)
11	Twig\Template->yieldBlock (line 299)
12	__TwigTemplate_a86ef6b95c80d7f1552db3a158b287a8->doDisplay (line 360)
13	Twig\Template->yield (line 51)
14	__TwigTemplate_b347bdb342977caea7f7b74a7fb4de2f->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 143)
22	App\Controller\HomeController->bestDeals (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.79 ms
(3.33%)

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 121)
6	App\Controller\HomeController->bestDeals (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://82.66.25.12:8081/best-deals?page=3

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping