Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

2.81 ms Query time

2 Invalid entities

Queries

Group similar statements

#▲

Time

Info

2.81 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 CASE WHEN w0_.photo IS NOT NULL AND w0_.photo <> '' THEN 0 ELSE 1 END ASC, w0_.datecreate DESC LIMIT 21

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

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/

Configuration Settings

Theme