Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

53.28 ms Query time

2 Invalid entities

13 Managed entities

Queries

Group similar statements

#▲

Time

Info

53.09 ms

SELECT a0_.id AS id_0, a0_.permalien AS permalien_1, a0_.titre AS titre_2, a0_.contenu AS contenu_3, a0_.date_creation AS date_creation_4, a0_.date_modification AS date_modification_5, a0_.visible AS visible_6, a0_.pdf AS pdf_7, a0_.video AS video_8, a0_.audio AS audio_9, a0_.fichier_pdf AS fichier_pdf_10, a0_.user_id AS user_id_11 FROM article a0_ WHERE a0_.video IS NOT NULL AND CHAR_LENGTH(TRIM(a0_.video)) > 0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.permalien AS permalien_1,
  a0_.titre AS titre_2,
  a0_.contenu AS contenu_3,
  a0_.date_creation AS date_creation_4,
  a0_.date_modification AS date_modification_5,
  a0_.visible AS visible_6,
  a0_.pdf AS pdf_7,
  a0_.video AS video_8,
  a0_.audio AS audio_9,
  a0_.fichier_pdf AS fichier_pdf_10,
  a0_.user_id AS user_id_11
FROM
  article a0_
WHERE
  a0_.video IS NOT NULL
  AND CHAR_LENGTH(
    TRIM(a0_.video)
  ) > 0

SELECT a0_.id AS id_0, a0_.permalien AS permalien_1, a0_.titre AS titre_2, a0_.contenu AS contenu_3, a0_.date_creation AS date_creation_4, a0_.date_modification AS date_modification_5, a0_.visible AS visible_6, a0_.pdf AS pdf_7, a0_.video AS video_8, a0_.audio AS audio_9, a0_.fichier_pdf AS fichier_pdf_10, a0_.user_id AS user_id_11 FROM article a0_ WHERE a0_.video IS NOT NULL AND CHAR_LENGTH(TRIM(a0_.video)) > 0;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\ArticleRepository->findVideo (line 66)
7	App\Controller\VideosController->index (line 20)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.18 ms

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.url AS url_4, t0.image_file_name AS image_file_name_5, t0.email AS email_6, t0.ville AS ville_7, t0.actif AS actif_8, t0.date AS date_9 FROM sponsors t0 WHERE t0.actif = ? ORDER BY t0.date DESC, t0.nom ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.description AS description_3,
  t0.url AS url_4,
  t0.image_file_name AS image_file_name_5,
  t0.email AS email_6,
  t0.ville AS ville_7,
  t0.actif AS actif_8,
  t0.date AS date_9
FROM
  sponsors t0
WHERE
  t0.actif = ?
ORDER BY
  t0.date DESC,
  t0.nom ASC

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.url AS url_4, t0.image_file_name AS image_file_name_5, t0.email AS email_6, t0.ville AS ville_7, t0.actif AS actif_8, t0.date AS date_9 FROM sponsors t0 WHERE t0.actif = 1 ORDER BY t0.date DESC, t0.nom ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Twig\SponsorsExtension->getActiveSponsors (line 31)
5	__TwigTemplate_1e274f1951f6bd0d54b8f1e4f598af56->doDisplay (line 69)
6	Twig\Template->yield (line 402)
7	__TwigTemplate_3f6e01daa718582fcbdacdf97f86f82b->doDisplay (line 262)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_06f98e9e271f7f0298e8b58dffe6c849->doDisplay (line 54)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_d6da9ce7e4312e7f755d077a87eb0183->doDisplay (line 55)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
20	App\Controller\VideosController->index (line 26)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Article	8
App\Entity\User	3
App\Entity\Sponsors	2

Entities Mapping

Class	Mapping errors
App\Entity\Article	The association App\Entity\Article#user refers to the inverse side field App\Entity\User#permalien which does not exist.
App\Entity\User	The mappings App\Entity\User#articles and App\Entity\Article#user are inconsistent with each other.
App\Entity\Tags	No errors.
App\Entity\Sponsors	No errors.

Symfony Profiler

GET https://lbe.webefy.fr/videos

Configuration Settings

Theme

Page Width