Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

3.31 ms Query time

2 Invalid entities

Queries

Group similar statements

#▲

Time

Info

2.25 ms

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-15 00:00:00"
  "2025-12-15 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-15 00:00:00' AND '2025-12-15 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.25 ms

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)

0.42 ms

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 (118, 145, 171, 13, 48, 94, 124, 121, 115, 35, 133, 200, 74, 22, 62, 51, 16, 54, 177, 141);

#	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.40 ms

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 11

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
  11

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 11;

#	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)

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-15

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping