Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

4.01 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.26 ms
(56.30%)

SELECT w0_.id AS id_0, w0_.views AS views_1, w0_.comments AS comments_2, w0_.likes AS likes_3, w0_.name AS name_4, w0_.slug AS slug_5, w0_.photo AS photo_6, w0_.description AS description_7, w0_.datecreate AS datecreate_8, w0_.adstype AS adstype_9, w0_.url AS url_10, w0_.urlproduct AS urlproduct_11, w0_.urlsaved AS urlsaved_12, w0_.language AS language_13, w0_.similar_products AS similar_products_14, w0_.category AS category_15, w0_.video AS video_16, w0_.original AS original_17, w0_.user_id AS user_id_18 FROM winning w0_ WHERE w0_.datecreate BETWEEN ? AND ? ORDER BY CASE WHEN w0_.photo IS NOT NULL AND w0_.photo <> '' THEN 0 ELSE 1 END ASC, w0_.datecreate DESC LIMIT 21

Parameters:

[
  "2025-12-04 00:00:00"
  "2025-12-04 23:59:59"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  w0_.id AS id_0,
  w0_.views AS views_1,
  w0_.comments AS comments_2,
  w0_.likes AS likes_3,
  w0_.name AS name_4,
  w0_.slug AS slug_5,
  w0_.photo AS photo_6,
  w0_.description AS description_7,
  w0_.datecreate AS datecreate_8,
  w0_.adstype AS adstype_9,
  w0_.url AS url_10,
  w0_.urlproduct AS urlproduct_11,
  w0_.urlsaved AS urlsaved_12,
  w0_.language AS language_13,
  w0_.similar_products AS similar_products_14,
  w0_.category AS category_15,
  w0_.video AS video_16,
  w0_.original AS original_17,
  w0_.user_id AS user_id_18
FROM
  winning w0_
WHERE
  w0_.datecreate BETWEEN ?
  AND ?
ORDER BY
  CASE WHEN w0_.photo IS NOT NULL
  AND w0_.photo <> '' THEN 0 ELSE 1 END ASC,
  w0_.datecreate DESC
LIMIT
  21

SELECT w0_.id AS id_0, w0_.views AS views_1, w0_.comments AS comments_2, w0_.likes AS likes_3, w0_.name AS name_4, w0_.slug AS slug_5, w0_.photo AS photo_6, w0_.description AS description_7, w0_.datecreate AS datecreate_8, w0_.adstype AS adstype_9, w0_.url AS url_10, w0_.urlproduct AS urlproduct_11, w0_.urlsaved AS urlsaved_12, w0_.language AS language_13, w0_.similar_products AS similar_products_14, w0_.category AS category_15, w0_.video AS video_16, w0_.original AS original_17, w0_.user_id AS user_id_18 FROM winning w0_ WHERE w0_.datecreate BETWEEN '2025-12-04 00:00:00' AND '2025-12-04 23:59:59' ORDER BY CASE WHEN w0_.photo IS NOT NULL AND w0_.photo <> '' THEN 0 ELSE 1 END ASC, w0_.datecreate DESC LIMIT 21;

#	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 96)
7	App\Controller\WinnerController->index (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.77 ms
(19.30%)

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 IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

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 IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )

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 IN (119, 99, 75, 161, 105, 17, 46, 100, 97, 32, 31, 202, 45, 122, 150, 56, 222, 116, 61, 44);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 933)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 249)
4	App\Controller\WinnerController->getRandomFallbackProducts (line 104)
5	App\Controller\WinnerController->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)

0.51 ms
(12.85%)

SELECT w0_.id AS id_0, w0_.views AS views_1, w0_.comments AS comments_2, w0_.likes AS likes_3, w0_.name AS name_4, w0_.slug AS slug_5, w0_.photo AS photo_6, w0_.description AS description_7, w0_.datecreate AS datecreate_8, w0_.adstype AS adstype_9, w0_.url AS url_10, w0_.urlproduct AS urlproduct_11, w0_.urlsaved AS urlsaved_12, w0_.language AS language_13, w0_.similar_products AS similar_products_14, w0_.category AS category_15, w0_.video AS video_16, w0_.original AS original_17, w0_.user_id AS user_id_18 FROM winning w0_ ORDER BY w0_.datecreate DESC LIMIT 4

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  w0_.id AS id_0,
  w0_.views AS views_1,
  w0_.comments AS comments_2,
  w0_.likes AS likes_3,
  w0_.name AS name_4,
  w0_.slug AS slug_5,
  w0_.photo AS photo_6,
  w0_.description AS description_7,
  w0_.datecreate AS datecreate_8,
  w0_.adstype AS adstype_9,
  w0_.url AS url_10,
  w0_.urlproduct AS urlproduct_11,
  w0_.urlsaved AS urlsaved_12,
  w0_.language AS language_13,
  w0_.similar_products AS similar_products_14,
  w0_.category AS category_15,
  w0_.video AS video_16,
  w0_.original AS original_17,
  w0_.user_id AS user_id_18
FROM
  winning w0_
ORDER BY
  w0_.datecreate DESC
LIMIT
  4

SELECT w0_.id AS id_0, w0_.views AS views_1, w0_.comments AS comments_2, w0_.likes AS likes_3, w0_.name AS name_4, w0_.slug AS slug_5, w0_.photo AS photo_6, w0_.description AS description_7, w0_.datecreate AS datecreate_8, w0_.adstype AS adstype_9, w0_.url AS url_10, w0_.urlproduct AS urlproduct_11, w0_.urlsaved AS urlsaved_12, w0_.language AS language_13, w0_.similar_products AS similar_products_14, w0_.category AS category_15, w0_.video AS video_16, w0_.original AS original_17, w0_.user_id AS user_id_18 FROM winning w0_ ORDER BY w0_.datecreate DESC LIMIT 4;

#	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 271)
7	App\Controller\WinnerController->getRandomFallbackProducts (line 104)
8	App\Controller\WinnerController->index (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.46 ms
(11.55%)

SELECT MIN(w0_.id) AS sclr_0, MAX(w0_.id) AS sclr_1 FROM winning w0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  MIN(w0_.id) AS sclr_0,
  MAX(w0_.id) AS sclr_1
FROM
  winning w0_

SELECT MIN(w0_.id) AS sclr_0, MAX(w0_.id) AS sclr_1 FROM winning w0_;

#	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 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 230)
7	App\Controller\WinnerController->getRandomFallbackProducts (line 104)
8	App\Controller\WinnerController->index (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
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\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/?day=2025-12-04

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping