Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

36.77 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

3.28 ms

SELECT i0_.id AS id_0, i0_.visibility AS visibility_1, i0_.number AS number_2, i0_.image_name AS image_name_3, i0_.image_size AS image_size_4, i0_.updated_at AS updated_at_5, i0_.name AS name_6, i0_.description AS description_7 FROM image i0_ INNER JOIN image_engraving_galleries i2_ ON i0_.id = i2_.image_id INNER JOIN engraving_galleries e1_ ON e1_.id = i2_.engraving_galleries_id WHERE i0_.visibility = ? AND e1_.name = ?

Parameters:

[
  1
  "Meeting"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  i0_.id AS id_0,
  i0_.visibility AS visibility_1,
  i0_.number AS number_2,
  i0_.image_name AS image_name_3,
  i0_.image_size AS image_size_4,
  i0_.updated_at AS updated_at_5,
  i0_.name AS name_6,
  i0_.description AS description_7
FROM
  image i0_
  INNER JOIN image_engraving_galleries i2_ ON i0_.id = i2_.image_id
  INNER JOIN engraving_galleries e1_ ON e1_.id = i2_.engraving_galleries_id
WHERE
  i0_.visibility = ?
  AND e1_.name = ?

SELECT i0_.id AS id_0, i0_.visibility AS visibility_1, i0_.number AS number_2, i0_.image_name AS image_name_3, i0_.image_size AS image_size_4, i0_.updated_at AS updated_at_5, i0_.name AS name_6, i0_.description AS description_7 FROM image i0_ INNER JOIN image_engraving_galleries i2_ ON i0_.id = i2_.image_id INNER JOIN engraving_galleries e1_ ON e1_.id = i2_.engraving_galleries_id WHERE i0_.visibility = 1 AND e1_.name = 'Meeting';

#	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 57)
7	App\Repository\ImageRepository->findMeeting (line 17)
8	App\Controller\HomeController->index (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

15.00 ms

SELECT i0_.id AS id_0, i0_.visibility AS visibility_1, i0_.number AS number_2, i0_.image_name AS image_name_3, i0_.image_size AS image_size_4, i0_.updated_at AS updated_at_5, i0_.name AS name_6, i0_.description AS description_7 FROM image i0_ INNER JOIN image_engraving_galleries i2_ ON i0_.id = i2_.image_id INNER JOIN engraving_galleries e1_ ON e1_.id = i2_.engraving_galleries_id WHERE i0_.visibility = ? AND e1_.name = ?

Parameters:

[
  1
  "My Works"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  i0_.id AS id_0,
  i0_.visibility AS visibility_1,
  i0_.number AS number_2,
  i0_.image_name AS image_name_3,
  i0_.image_size AS image_size_4,
  i0_.updated_at AS updated_at_5,
  i0_.name AS name_6,
  i0_.description AS description_7
FROM
  image i0_
  INNER JOIN image_engraving_galleries i2_ ON i0_.id = i2_.image_id
  INNER JOIN engraving_galleries e1_ ON e1_.id = i2_.engraving_galleries_id
WHERE
  i0_.visibility = ?
  AND e1_.name = ?

SELECT i0_.id AS id_0, i0_.visibility AS visibility_1, i0_.number AS number_2, i0_.image_name AS image_name_3, i0_.image_size AS image_size_4, i0_.updated_at AS updated_at_5, i0_.name AS name_6, i0_.description AS description_7 FROM image i0_ INNER JOIN image_engraving_galleries i2_ ON i0_.id = i2_.image_id INNER JOIN engraving_galleries e1_ ON e1_.id = i2_.engraving_galleries_id WHERE i0_.visibility = 1 AND e1_.name = 'My Works';

#	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 69)
7	App\Repository\ImageRepository->findMyWork (line 18)
8	App\Controller\HomeController->index (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

18.49 ms

SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.visibility AS visibility_2, e0_.description AS description_3 FROM engraving_galleries e0_ WHERE e0_.visibility = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.name AS name_1,
  e0_.visibility AS visibility_2,
  e0_.description AS description_3
FROM
  engraving_galleries e0_
WHERE
  e0_.visibility = ?

SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.visibility AS visibility_2, e0_.description AS description_3 FROM engraving_galleries e0_ WHERE e0_.visibility = 1;

#	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 54)
7	App\Repository\EngravingGalleriesRepository->findVisible (line 21)
8	App\Service\HeaderDataService->getHeaderData (line 1629)
9	Twig\Extension\CoreExtension::getAttribute (line 82)
10	__TwigTemplate_859f466bcdbc90c93c659e648a956dd0->doDisplay (line 360)
11	Twig\Template->yield (line 108)
12	__TwigTemplate_e96abf7b3adba4ec1a97587b781b987a->doDisplay (line 360)
13	Twig\Template->yield (line 50)
14	__TwigTemplate_1a9dd9616fb144c78558a670c263897d->doDisplay (line 360)
15	Twig\Template->yield (line 335)
16	Twig\Template->render (line 38)
17	Twig\TemplateWrapper->render (line 307)
18	Twig\Environment->render (line 431)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 21)
22	App\Controller\HomeController->index (line 178)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	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\Image	No errors.
App\Entity\EngravingGalleries	No errors.

Symfony Profiler

POST http://163.172.41.212/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping