Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

4.20 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.47 ms
(58.63%)

SELECT t0.id AS id_1, t0.path AS path_2, t0.winning_id AS winning_id_3 FROM winning_image t0 WHERE t0.winning_id = ?

Parameters:

[
  54
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.path AS path_2,
  t0.winning_id AS winning_id_3
FROM
  winning_image t0
WHERE
  t0.winning_id = ?

SELECT t0.id AS id_1, t0.path AS path_2, t0.winning_id AS winning_id_3 FROM winning_image t0 WHERE t0.winning_id = 54;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1828)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1773)
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 73)
9	__TwigTemplate_723be066cd1397cc395bf1773092f85a->doDisplay (line 393)
10	Twig\Template->yield (line 349)
11	Twig\Template->display (line 364)
12	Twig\Template->render (line 35)
13	Twig\TemplateWrapper->render (line 306)
14	Twig\Environment->render (line 431)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 310)
18	App\Controller\WinnerController->show (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

1.74 ms
(41.37%)

SELECT t0.id AS id_1, t0.views AS views_2, t0.comments AS comments_3, t0.likes AS likes_4, t0.name AS name_5, t0.slug AS slug_6, t0.photo AS photo_7, t0.description AS description_8, t0.datecreate AS datecreate_9, t0.adstype AS adstype_10, t0.url AS url_11, t0.urlproduct AS urlproduct_12, t0.urlsaved AS urlsaved_13, t0.language AS language_14, t0.similar_products AS similar_products_15, t0.category AS category_16, t0.video AS video_17, t0.original AS original_18, t0.user_id AS user_id_19 FROM winning t0 WHERE t0.id = ?

Parameters:

[
  54
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.views AS views_2,
  t0.comments AS comments_3,
  t0.likes AS likes_4,
  t0.name AS name_5,
  t0.slug AS slug_6,
  t0.photo AS photo_7,
  t0.description AS description_8,
  t0.datecreate AS datecreate_9,
  t0.adstype AS adstype_10,
  t0.url AS url_11,
  t0.urlproduct AS urlproduct_12,
  t0.urlsaved AS urlsaved_13,
  t0.language AS language_14,
  t0.similar_products AS similar_products_15,
  t0.category AS category_16,
  t0.video AS video_17,
  t0.original AS original_18,
  t0.user_id AS user_id_19
FROM
  winning t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.views AS views_2, t0.comments AS comments_3, t0.likes AS likes_4, t0.name AS name_5, t0.slug AS slug_6, t0.photo AS photo_7, t0.description AS description_8, t0.datecreate AS datecreate_9, t0.adstype AS adstype_10, t0.url AS url_11, t0.urlproduct AS urlproduct_12, t0.urlsaved AS urlsaved_13, t0.language AS language_14, t0.similar_products AS similar_products_15, t0.category AS category_16, t0.video AS video_17, t0.original AS original_18, t0.user_id AS user_id_19 FROM winning t0 WHERE t0.id = 54;

#	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 357)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 304)
6	App\Controller\WinnerController->show (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\Winning	The association App\Entity\Winning#user refers to the inverse side field App\Entity\User#ads which does not exist.
App\Entity\User	The field 'App\Entity\User#photoFile' has the property type 'App\Entity\UploadedFile' that differs from the metadata field type 'string' returned by the 'string' DBAL type. The association App\Entity\User#school refers to the inverse side field App\Entity\School#lessons which does not exist. The association App\Entity\User#currentSchool refers to the inverse side field App\Entity\School#lessons which does not exist.
App\Entity\WinningImage	No errors.

Symfony Profiler

GET https://www.ledenicheurgagnant.com/winning-product/54-daniel-l-abrams-md

Configuration Settings

Theme