Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

5.56 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

3.70 ms

SELECT count(DISTINCT h0_.id) AS sclr_0 FROM home h0_ LEFT JOIN blockchain b1_ ON h0_.id = b1_.home_id LEFT JOIN image i2_ ON b1_.image_id = i2_.id LEFT JOIN faq f3_ ON h0_.id = f3_.home_id LEFT JOIN how_it_work h4_ ON h0_.id = h4_.home_id

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT h0_.id) AS sclr_0
FROM
  home h0_
  LEFT JOIN blockchain b1_ ON h0_.id = b1_.home_id
  LEFT JOIN image i2_ ON b1_.image_id = i2_.id
  LEFT JOIN faq f3_ ON h0_.id = f3_.home_id
  LEFT JOIN how_it_work h4_ ON h0_.id = h4_.home_id

SELECT count(DISTINCT h0_.id) AS sclr_0 FROM home h0_ LEFT JOIN blockchain b1_ ON h0_.id = b1_.home_id LEFT JOIN image i2_ ON b1_.image_id = i2_.id LEFT JOIN faq f3_ ON h0_.id = f3_.home_id LEFT JOIN how_it_work h4_ ON h0_.id = h4_.home_id;

#	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 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 96)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 49)
8	ApiPlatform\Doctrine\Orm\Paginator->getTotalItems (line 69)
9	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getPaginationData (line 87)
10	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 53)
11	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 76)
12	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 50)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 150)
14	Symfony\Component\Serializer\Serializer->normalize (line 129)
15	Symfony\Component\Serializer\Serializer->serialize (line 44)
16	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 74)
17	ApiPlatform\State\Processor\SerializeProcessor->process (line 51)
18	ApiPlatform\State\Processor\WriteProcessor->process (line 112)
19	ApiPlatform\Symfony\Controller\MainController->__invoke (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 30)
24	require_once (line 5)

0.91 ms

SELECT DISTINCT h0_.id AS id_0, h0_.id AS id_1 FROM home h0_ LEFT JOIN blockchain b1_ ON h0_.id = b1_.home_id LEFT JOIN image i2_ ON b1_.image_id = i2_.id LEFT JOIN faq f3_ ON h0_.id = f3_.home_id LEFT JOIN how_it_work h4_ ON h0_.id = h4_.home_id ORDER BY h0_.id ASC LIMIT 30

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT h0_.id AS id_0,
  h0_.id AS id_1
FROM
  home h0_
  LEFT JOIN blockchain b1_ ON h0_.id = b1_.home_id
  LEFT JOIN image i2_ ON b1_.image_id = i2_.id
  LEFT JOIN faq f3_ ON h0_.id = f3_.home_id
  LEFT JOIN how_it_work h4_ ON h0_.id = h4_.home_id
ORDER BY
  h0_.id ASC
LIMIT
  30

SELECT DISTINCT h0_.id AS id_0, h0_.id AS id_1 FROM home h0_ LEFT JOIN blockchain b1_ ON h0_.id = b1_.home_id LEFT JOIN image i2_ ON b1_.image_id = i2_.id LEFT JOIN faq f3_ ON h0_.id = f3_.home_id LEFT JOIN how_it_work h4_ ON h0_.id = h4_.home_id ORDER BY h0_.id ASC LIMIT 30;

#	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 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 127)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 69)
8	ApiPlatform\Doctrine\Orm\AbstractPaginator->getIterator (line 88)
9	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 94)
10	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 53)
11	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 76)
12	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 50)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 150)
14	Symfony\Component\Serializer\Serializer->normalize (line 129)
15	Symfony\Component\Serializer\Serializer->serialize (line 44)
16	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 74)
17	ApiPlatform\State\Processor\SerializeProcessor->process (line 51)
18	ApiPlatform\State\Processor\WriteProcessor->process (line 112)
19	ApiPlatform\Symfony\Controller\MainController->__invoke (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 30)
24	require_once (line 5)

0.95 ms

SELECT h0_.id AS id_0, h0_.hero_title AS hero_title_1, h0_.hero_subtitle AS hero_subtitle_2, h0_.hero_text AS hero_text_3, h0_.link_text AS link_text_4, h0_.blockchain_title AS blockchain_title_5, h0_.hoe_it_works_title AS hoe_it_works_title_6, h0_.faq_title AS faq_title_7, b1_.id AS id_8, b1_.name AS name_9, b1_.content AS content_10, i2_.id AS id_11, i2_.name AS name_12, i2_.filename AS filename_13, i2_.updated_at AS updated_at_14, f3_.id AS id_15, f3_.title AS title_16, f3_.content AS content_17, h4_.id AS id_18, h4_.title AS title_19, h4_.content AS content_20, b1_.image_id AS image_id_21, b1_.home_id AS home_id_22, f3_.home_id AS home_id_23, h4_.home_id AS home_id_24 FROM home h0_ LEFT JOIN blockchain b1_ ON h0_.id = b1_.home_id LEFT JOIN image i2_ ON b1_.image_id = i2_.id LEFT JOIN faq f3_ ON h0_.id = f3_.home_id LEFT JOIN how_it_work h4_ ON h0_.id = h4_.home_id WHERE h0_.id IN (?) ORDER BY h0_.id ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  h0_.id AS id_0,
  h0_.hero_title AS hero_title_1,
  h0_.hero_subtitle AS hero_subtitle_2,
  h0_.hero_text AS hero_text_3,
  h0_.link_text AS link_text_4,
  h0_.blockchain_title AS blockchain_title_5,
  h0_.hoe_it_works_title AS hoe_it_works_title_6,
  h0_.faq_title AS faq_title_7,
  b1_.id AS id_8,
  b1_.name AS name_9,
  b1_.content AS content_10,
  i2_.id AS id_11,
  i2_.name AS name_12,
  i2_.filename AS filename_13,
  i2_.updated_at AS updated_at_14,
  f3_.id AS id_15,
  f3_.title AS title_16,
  f3_.content AS content_17,
  h4_.id AS id_18,
  h4_.title AS title_19,
  h4_.content AS content_20,
  b1_.image_id AS image_id_21,
  b1_.home_id AS home_id_22,
  f3_.home_id AS home_id_23,
  h4_.home_id AS home_id_24
FROM
  home h0_
  LEFT JOIN blockchain b1_ ON h0_.id = b1_.home_id
  LEFT JOIN image i2_ ON b1_.image_id = i2_.id
  LEFT JOIN faq f3_ ON h0_.id = f3_.home_id
  LEFT JOIN how_it_work h4_ ON h0_.id = h4_.home_id
WHERE
  h0_.id IN (?)
ORDER BY
  h0_.id ASC

SELECT h0_.id AS id_0, h0_.hero_title AS hero_title_1, h0_.hero_subtitle AS hero_subtitle_2, h0_.hero_text AS hero_text_3, h0_.link_text AS link_text_4, h0_.blockchain_title AS blockchain_title_5, h0_.hoe_it_works_title AS hoe_it_works_title_6, h0_.faq_title AS faq_title_7, b1_.id AS id_8, b1_.name AS name_9, b1_.content AS content_10, i2_.id AS id_11, i2_.name AS name_12, i2_.filename AS filename_13, i2_.updated_at AS updated_at_14, f3_.id AS id_15, f3_.title AS title_16, f3_.content AS content_17, h4_.id AS id_18, h4_.title AS title_19, h4_.content AS content_20, b1_.image_id AS image_id_21, b1_.home_id AS home_id_22, f3_.home_id AS home_id_23, h4_.home_id AS home_id_24 FROM home h0_ LEFT JOIN blockchain b1_ ON h0_.id = b1_.home_id LEFT JOIN image i2_ ON b1_.image_id = i2_.id LEFT JOIN faq f3_ ON h0_.id = f3_.home_id LEFT JOIN how_it_work h4_ ON h0_.id = h4_.home_id WHERE h0_.id IN (1) ORDER BY h0_.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 145)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 69)
8	ApiPlatform\Doctrine\Orm\AbstractPaginator->getIterator (line 88)
9	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 94)
10	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 53)
11	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 76)
12	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 50)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 150)
14	Symfony\Component\Serializer\Serializer->normalize (line 129)
15	Symfony\Component\Serializer\Serializer->serialize (line 44)
16	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 74)
17	ApiPlatform\State\Processor\SerializeProcessor->process (line 51)
18	ApiPlatform\State\Processor\WriteProcessor->process (line 112)
19	ApiPlatform\Symfony\Controller\MainController->__invoke (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 30)
24	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\Home	No errors.
App\Entity\Blockchain	No errors.
App\Entity\Image	No errors.
App\Entity\Faq	No errors.
App\Entity\HowItWork	No errors.

Symfony Profiler

GET https://ezmynt.com/api/homes

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping