Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

0.61 ms Query time

0 Invalid entities

18 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.18 ms
(28.94%)

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.description AS description_2, p0_.language AS language_3, p0_.content_html AS content_html_4, p0_.slug AS slug_5, p0_.meta_description AS meta_description_6, p0_.meta_keywords AS meta_keywords_7, p0_.is_published AS is_published_8, p0_.published_at AS published_at_9, p0_.updated_at AS updated_at_10 FROM page p0_ WHERE p0_.language = ? AND p0_.is_published = 1 ORDER BY p0_.published_at DESC, p0_.updated_at DESC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.description AS description_2,
  p0_.language AS language_3,
  p0_.content_html AS content_html_4,
  p0_.slug AS slug_5,
  p0_.meta_description AS meta_description_6,
  p0_.meta_keywords AS meta_keywords_7,
  p0_.is_published AS is_published_8,
  p0_.published_at AS published_at_9,
  p0_.updated_at AS updated_at_10
FROM
  page p0_
WHERE
  p0_.language = ?
  AND p0_.is_published = 1
ORDER BY
  p0_.published_at DESC,
  p0_.updated_at DESC

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.description AS description_2, p0_.language AS language_3, p0_.content_html AS content_html_4, p0_.slug AS slug_5, p0_.meta_description AS meta_description_6, p0_.meta_keywords AS meta_keywords_7, p0_.is_published AS is_published_8, p0_.published_at AS published_at_9, p0_.updated_at AS updated_at_10 FROM page p0_ WHERE p0_.language = 1 AND p0_.is_published = 1 ORDER BY p0_.published_at DESC, p0_.updated_at DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	App\Repository\PageRepository->findPublishedForListing (line 51)
7	App\Controller\Public\BaseController->__construct (line 25)
8	ContainerXIuDLOR\getHomeControllerService->do (line 25)
9	ContainerXIuDLOR\App_KernelDevDebugContainer::load (line 511)
10	Symfony\Component\DependencyInjection\Container->make (line 229)
11	Symfony\Component\DependencyInjection\Container::get (line 211)
12	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 40)
13	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 26)
14	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 128)
15	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 96)
16	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 36)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 164)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 197)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 7)

0.12 ms
(19.88%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.short_description AS short_description_3, t0.full_description AS full_description_4, t0.status AS status_5, t0.highlighted AS highlighted_6, t0.position AS position_7, t0.image AS image_8, t0.img_updated_at AS img_updated_at_9, t0.language AS language_10, t0.slug AS slug_11, t0.subtitle AS subtitle_12, t0.features AS features_13 FROM service t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "Reforma-de-equipamentos-3"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.short_description AS short_description_3,
  t0.full_description AS full_description_4,
  t0.status AS status_5,
  t0.highlighted AS highlighted_6,
  t0.position AS position_7,
  t0.image AS image_8,
  t0.img_updated_at AS img_updated_at_9,
  t0.language AS language_10,
  t0.slug AS slug_11,
  t0.subtitle AS subtitle_12,
  t0.features AS features_13
FROM
  service t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.short_description AS short_description_3, t0.full_description AS full_description_4, t0.status AS status_5, t0.highlighted AS highlighted_6, t0.position AS position_7, t0.image AS image_8, t0.img_updated_at AS img_updated_at_9, t0.language AS language_10, t0.slug AS slug_11, t0.subtitle AS subtitle_12, t0.features AS features_13 FROM service t0 WHERE t0.slug = 'Reforma-de-equipamentos-3' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\Public\HomeController->service (line 269)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 197)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 7)

0.11 ms
(17.61%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.img_updated_at AS img_updated_at_4, t0.language AS language_5, t0.features AS features_6, t0.short_description AS short_description_7, t0.subtitle AS subtitle_8, t0.position AS position_9, t0.product_highlight_id AS product_highlight_id_10 FROM product_category t0 WHERE t0.language = ? ORDER BY t0.title ASC

Parameters:

[
  "1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.image AS image_3,
  t0.img_updated_at AS img_updated_at_4,
  t0.language AS language_5,
  t0.features AS features_6,
  t0.short_description AS short_description_7,
  t0.subtitle AS subtitle_8,
  t0.position AS position_9,
  t0.product_highlight_id AS product_highlight_id_10
FROM
  product_category t0
WHERE
  t0.language = ?
ORDER BY
  t0.title ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.img_updated_at AS img_updated_at_4, t0.language AS language_5, t0.features AS features_6, t0.short_description AS short_description_7, t0.subtitle AS subtitle_8, t0.position AS position_9, t0.product_highlight_id AS product_highlight_id_10 FROM product_category t0 WHERE t0.language = '1' ORDER BY t0.title ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Service\TemplateService->prodCategories (line 30)
5	Twig\Extension\CoreExtension->getAttribute (line 1909)
6	__TwigTemplate_4e0d5eaa5390d7f28fc0da55e78c2290::doDisplay (line 434)
7	Twig\Template->yield (line 402)
8	__TwigTemplate_681e5d4773c2e3646b687b052c6cc39c->doDisplay (line 56)
9	Twig\Template->yield (line 402)
10	Twig\Template->display (line 358)
11	Twig\Template->render (line 373)
12	Twig\TemplateWrapper->render (line 51)
13	Twig\Environment->render (line 333)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 448)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 453)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 253)
17	App\Controller\Public\BaseController->render (line 35)
18	App\Controller\Public\HomeController->service (line 274)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 197)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
24	require_once (line 7)

0.11 ms
(17.45%)

SELECT t0.id AS id_1, t0.phone AS phone_2, t0.email AS email_3, t0.address AS address_4, t0.whatsapp AS whatsapp_5 FROM general_data t0 ORDER BY t0.id DESC LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.phone AS phone_2,
  t0.email AS email_3,
  t0.address AS address_4,
  t0.whatsapp AS whatsapp_5
FROM
  general_data t0
ORDER BY
  t0.id DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.phone AS phone_2, t0.email AS email_3, t0.address AS address_4, t0.whatsapp AS whatsapp_5 FROM general_data t0 ORDER BY t0.id DESC LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Service\TemplateService->generalData (line 46)
5	Twig\Extension\CoreExtension->getAttribute (line 1909)
6	__TwigTemplate_4e0d5eaa5390d7f28fc0da55e78c2290::doDisplay (line 512)
7	Twig\Template->yield (line 402)
8	__TwigTemplate_681e5d4773c2e3646b687b052c6cc39c->doDisplay (line 56)
9	Twig\Template->yield (line 402)
10	Twig\Template->display (line 358)
11	Twig\Template->render (line 373)
12	Twig\TemplateWrapper->render (line 51)
13	Twig\Environment->render (line 333)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 448)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 453)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 253)
17	App\Controller\Public\BaseController->render (line 35)
18	App\Controller\Public\HomeController->service (line 274)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 197)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
24	require_once (line 7)

0.10 ms
(16.12%)

SELECT t0.id AS id_1, t0.ga4 AS ga4_2, t0.tags_google_ads AS tags_google_ads_3, t0.pixel_meta_ads AS pixel_meta_ads_4 FROM global_tags t0 ORDER BY t0.id DESC LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.ga4 AS ga4_2,
  t0.tags_google_ads AS tags_google_ads_3,
  t0.pixel_meta_ads AS pixel_meta_ads_4
FROM
  global_tags t0
ORDER BY
  t0.id DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.ga4 AS ga4_2, t0.tags_google_ads AS tags_google_ads_3, t0.pixel_meta_ads AS pixel_meta_ads_4 FROM global_tags t0 ORDER BY t0.id DESC LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Service\TemplateService->globalTags (line 34)
5	Twig\Extension\CoreExtension->getAttribute (line 1909)
6	__TwigTemplate_4e0d5eaa5390d7f28fc0da55e78c2290::doDisplay (line 63)
7	Twig\Template->yield (line 402)
8	__TwigTemplate_681e5d4773c2e3646b687b052c6cc39c->doDisplay (line 56)
9	Twig\Template->yield (line 402)
10	Twig\Template->display (line 358)
11	Twig\Template->render (line 373)
12	Twig\TemplateWrapper->render (line 51)
13	Twig\Environment->render (line 333)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 448)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 453)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 253)
17	App\Controller\Public\BaseController->render (line 35)
18	App\Controller\Public\HomeController->service (line 274)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 197)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
24	require_once (line 7)

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\ProductCategory	7
App\Entity\Product	7
App\Entity\Page	1
App\Entity\Service	1
App\Entity\GlobalTags	1
App\Entity\GeneralData	1

Entities Mapping

Class	Mapping errors
App\Entity\Page	No errors.
App\Entity\Service	No errors.
App\Entity\GlobalTags	No errors.
App\Entity\ProductCategory	No errors.
App\Entity\Product	No errors.
App\Entity\GeneralData	No errors.

Symfony Profiler

GET https://siatecbrasil.com.br/pt/servico/Reforma-de-equipamentos-3

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping