Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

0.96 ms Query time

0 Invalid entities

5 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.30 ms

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.path AS path_3, t0.image_collection_id AS image_collection_id_4 FROM image t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.path AS path_3,
  t0.image_collection_id AS image_collection_id_4
FROM
  image t0

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.path AS path_3, t0.image_collection_id AS image_collection_id_4 FROM image t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 22)
6	App\Controller\MediasController->index (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)

0.66 ms

SELECT i0_.filename AS filename_0, i0_.path AS path_1, i1_.name AS name_2, i2_.name AS name_3, i1_.slug AS slug_4, i2_.slug AS slug_5 FROM image i0_ INNER JOIN image_collection i1_ ON i0_.image_collection_id = i1_.id INNER JOIN image_category i2_ ON i1_.image_category_id = i2_.id WHERE i0_.filename IS NOT NULL GROUP BY i1_.id ORDER BY i0_.id ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  i0_.filename AS filename_0,
  i0_.path AS path_1,
  i1_.name AS name_2,
  i2_.name AS name_3,
  i1_.slug AS slug_4,
  i2_.slug AS slug_5
FROM
  image i0_
  INNER JOIN image_collection i1_ ON i0_.image_collection_id = i1_.id
  INNER JOIN image_category i2_ ON i1_.image_category_id = i2_.id
WHERE
  i0_.filename IS NOT NULL
GROUP BY
  i1_.id
ORDER BY
  i0_.id ASC

SELECT i0_.filename AS filename_0, i0_.path AS path_1, i1_.name AS name_2, i2_.name AS name_3, i1_.slug AS slug_4, i2_.slug AS slug_5 FROM image i0_ INNER JOIN image_collection i1_ ON i0_.image_collection_id = i1_.id INNER JOIN image_category i2_ ON i1_.image_category_id = i2_.id WHERE i0_.filename IS NOT NULL GROUP BY i1_.id ORDER BY i0_.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
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 32)
7	App\Repository\ImageRepository->findFirstImage (line 23)
8	App\Controller\MediasController->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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Image	4
App\Entity\ImageCollection	1

Entities Mapping

Class	Mapping errors
App\Entity\Image	No errors.
App\Entity\ImageCollection	No errors.
App\Entity\ImageCategory	No errors.

Symfony Profiler

GET https://cyclo-teloche.victorlecomte.fr/medias/

Configuration Settings

Theme

Page Width