Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

183.88 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

9.17 ms

SELECT COUNT(b0_.id) AS sclr_0 FROM bl_image b0_ LEFT JOIN bl_gallery b1_ ON (b1_.id = b0_.gallery_id) WHERE b1_.nsfw = 0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(b0_.id) AS sclr_0
FROM
  bl_image b0_
  LEFT JOIN bl_gallery b1_ ON (b1_.id = b0_.gallery_id)
WHERE
  b1_.nsfw = 0

SELECT COUNT(b0_.id) AS sclr_0 FROM bl_image b0_ LEFT JOIN bl_gallery b1_ ON (b1_.id = b0_.gallery_id) WHERE b1_.nsfw = 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 991)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 1020)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 212)
8	App\Repository\ImageRepository->countCustom (line 339)
9	App\Controller\BluvrController->home (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 6)

174.71 ms

SELECT b0_.height AS height_0, b0_.width AS width_1, b0_.size AS size_2, b0_.mime AS mime_3, b0_.filename AS filename_4, b0_.extension AS extension_5, b0_.tags AS tags_6, b0_.caption AS caption_7, b0_.date_added AS date_added_8, b0_.votes AS votes_9, b0_.id AS id_10 FROM bl_image b0_ INNER JOIN bl_gallery b1_ ON (b0_.gallery_id = b1_.id) WHERE b1_.nsfw = 0 ORDER BY b0_.date_added DESC LIMIT 38 OFFSET 76

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.height AS height_0,
  b0_.width AS width_1,
  b0_.size AS size_2,
  b0_.mime AS mime_3,
  b0_.filename AS filename_4,
  b0_.extension AS extension_5,
  b0_.tags AS tags_6,
  b0_.caption AS caption_7,
  b0_.date_added AS date_added_8,
  b0_.votes AS votes_9,
  b0_.id AS id_10
FROM
  bl_image b0_
  INNER JOIN bl_gallery b1_ ON (b0_.gallery_id = b1_.id)
WHERE
  b1_.nsfw = 0
ORDER BY
  b0_.date_added DESC
LIMIT
  38
OFFSET
  76

SELECT b0_.height AS height_0, b0_.width AS width_1, b0_.size AS size_2, b0_.mime AS mime_3, b0_.filename AS filename_4, b0_.extension AS extension_5, b0_.tags AS tags_6, b0_.caption AS caption_7, b0_.date_added AS date_added_8, b0_.votes AS votes_9, b0_.id AS id_10 FROM bl_image b0_ INNER JOIN bl_gallery b1_ ON (b0_.gallery_id = b1_.id) WHERE b1_.nsfw = 0 ORDER BY b0_.date_added DESC LIMIT 38 OFFSET 76;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 157)
7	App\Repository\ImageRepository->getImages (line 344)
8	App\Controller\BluvrController->home (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 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\Image	No errors.
App\Entity\Gallery	No errors.

Symfony Profiler

GET https://mizzium.com/bluvr/page/3

Configuration Settings

Theme