Symfony Profiler

Query Metrics

10 Database Queries

2 Different statements

133.64 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

132.34 ms
(99.02%)

SELECT t0.height AS height_1, t0.width AS width_2, t0.size AS size_3, t0.mime AS mime_4, t0.filename AS filename_5, t0.extension AS extension_6, t0.tags AS tags_7, t0.caption AS caption_8, t0.date_added AS date_added_9, t0.votes AS votes_10, t0.id AS id_11, t0.gallery_id AS gallery_id_12 FROM bl_image t0 WHERE t0.gallery_id = ?

Parameters:

[
  9
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.height AS height_1,
  t0.width AS width_2,
  t0.size AS size_3,
  t0.mime AS mime_4,
  t0.filename AS filename_5,
  t0.extension AS extension_6,
  t0.tags AS tags_7,
  t0.caption AS caption_8,
  t0.date_added AS date_added_9,
  t0.votes AS votes_10,
  t0.id AS id_11,
  t0.gallery_id AS gallery_id_12
FROM
  bl_image t0
WHERE
  t0.gallery_id = ?

SELECT t0.height AS height_1, t0.width AS width_2, t0.size AS size_3, t0.mime AS mime_4, t0.filename AS filename_5, t0.extension AS extension_6, t0.tags AS tags_7, t0.caption AS caption_8, t0.date_added AS date_added_9, t0.votes AS votes_10, t0.id AS id_11, t0.gallery_id AS gallery_id_12 FROM bl_image t0 WHERE t0.gallery_id = 9;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1916)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1857)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 108)
7	Doctrine\Common\Collections\AbstractLazyCollection->containsKey (line 412)
8	Doctrine\ORM\PersistentCollection->containsKey (line 496)
9	Doctrine\ORM\PersistentCollection->offsetExists (line 1595)
10	Twig\Extension\CoreExtension::getAttribute (line 205)
11	__TwigTemplate_85c596d3ee76f34dec741ee4c43ae0dc->block_body (line 437)
12	Twig\Template->yieldBlock (line 313)
13	__TwigTemplate_832973cb6e78fd143361e3641eeb6e69->block_wrapper (line 437)
14	Twig\Template->yieldBlock (line 123)
15	__TwigTemplate_832973cb6e78fd143361e3641eeb6e69->doDisplay (line 393)
16	Twig\Template->yield (line 56)
17	__TwigTemplate_85c596d3ee76f34dec741ee4c43ae0dc->doDisplay (line 393)
18	Twig\Template->yield (line 349)
19	Twig\Template->display (line 364)
20	Twig\Template->render (line 35)
21	Twig\TemplateWrapper->render (line 306)
22	Twig\Environment->render (line 59)
23	Symfony\Bridge\Twig\EventListener\TemplateAttributeListener->onKernelView (line 115)
24	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
25	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
26	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
27	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 6)

1.30 ms
(0.98%)

SELECT t0.title AS title_1, t0.dir AS dir_2, t0.description AS description_3, t0.thumbnail AS thumbnail_4, t0.updated_on AS updated_on_5, t0.path AS path_6, t0.default_tags AS default_tags_7, t0.id AS id_8, t0.nsfw AS nsfw_9 FROM bl_gallery t0 ORDER BY t0.nsfw ASC, t0.title ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.title AS title_1,
  t0.dir AS dir_2,
  t0.description AS description_3,
  t0.thumbnail AS thumbnail_4,
  t0.updated_on AS updated_on_5,
  t0.path AS path_6,
  t0.default_tags AS default_tags_7,
  t0.id AS id_8,
  t0.nsfw AS nsfw_9
FROM
  bl_gallery t0
ORDER BY
  t0.nsfw ASC,
  t0.title ASC

SELECT t0.title AS title_1, t0.dir AS dir_2, t0.description AS description_3, t0.thumbnail AS thumbnail_4, t0.updated_on AS updated_on_5, t0.path AS path_6, t0.default_tags AS default_tags_7, t0.id AS id_8, t0.nsfw AS nsfw_9 FROM bl_gallery t0 ORDER BY t0.nsfw ASC, t0.title ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 969)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 27)
4	App\Repository\GalleryRepository->findAll (line 319)
5	App\Controller\BluvrController->list (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 6)

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\Gallery	No errors.
App\Entity\Image	No errors.
App\Entity\CommentBluvr	No errors.

Symfony Profiler

GET https://mizzium.com/bluvr/galleries

Configuration Settings

Theme