Symfony Profiler

Query Metrics

2 Database Queries

1 Different statements

0.39 ms Query time

0 Invalid entities

1 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.21 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.seo_title AS seo_title_4, t0.seo_description AS seo_description_5, t0.slug AS slug_6 FROM state t0 WHERE t0.active = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3,
  t0.seo_title AS seo_title_4,
  t0.seo_description AS seo_description_5,
  t0.slug AS slug_6
FROM
  state t0
WHERE
  t0.active = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.seo_title AS seo_title_4, t0.seo_description AS seo_description_5, t0.slug AS slug_6 FROM state t0 WHERE t0.active = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	App\Service\StatesLocation->getActiveStates (line 12)
5	Twig\Extension\CoreExtension->getAttribute (line 1919)
6	__TwigTemplate_629711159f4ea039f78587534fb445c4::doDisplay (line 171)
7	Twig\Template->yield (line 402)
8	__TwigTemplate_f7a4491a765d1b10f2498d40aab13f47->doDisplay (line 102)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_ff8d4476d6a67e9ba975c6a80d47d7a5->doDisplay (line 54)
11	Twig\Template->yield (line 402)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 373)
14	Twig\TemplateWrapper->render (line 51)
15	Twig\Environment->render (line 333)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
19	App\Controller\HomeController->whyprestolink (line 44)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 191)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 32)
25	require_once (line 5)

0.18 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.seo_title AS seo_title_4, t0.seo_description AS seo_description_5, t0.slug AS slug_6 FROM state t0 WHERE t0.active = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3,
  t0.seo_title AS seo_title_4,
  t0.seo_description AS seo_description_5,
  t0.slug AS slug_6
FROM
  state t0
WHERE
  t0.active = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.seo_title AS seo_title_4, t0.seo_description AS seo_description_5, t0.slug AS slug_6 FROM state t0 WHERE t0.active = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	App\Service\StatesLocation->getActiveStates (line 12)
5	Twig\Extension\CoreExtension->getAttribute (line 1919)
6	__TwigTemplate_629711159f4ea039f78587534fb445c4::doDisplay (line 324)
7	Twig\Template->yield (line 402)
8	__TwigTemplate_f7a4491a765d1b10f2498d40aab13f47->doDisplay (line 102)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_ff8d4476d6a67e9ba975c6a80d47d7a5->doDisplay (line 54)
11	Twig\Template->yield (line 402)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 373)
14	Twig\TemplateWrapper->render (line 51)
15	Twig\Environment->render (line 333)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
19	App\Controller\HomeController->whyprestolink (line 44)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 191)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 32)
25	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\State	1

Entities Mapping

Class	Mapping errors
App\Entity\State	No errors.
App\Entity\City	No errors.

Symfony Profiler

GET https://prestopackersmovers.com/why-choose-us

Configuration Settings

Theme

Page Width