Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

10.93 ms Query time

0 Invalid entities

87 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

10.17 ms
(93.01%)

SELECT DISTINCT n0_.id AS id_0, n0_.status AS status_1, n0_.highlighted AS highlighted_2, n0_.date AS date_3, n0_.title AS title_4, n0_.short_description AS short_description_5, n0_.youtube_video_code AS youtube_video_code_6, n0_.full_description AS full_description_7, n0_.image AS image_8, n0_.img_updated_at AS img_updated_at_9, n0_.language AS language_10, n0_.slug AS slug_11, n0_.wordpress_id AS wordpress_id_12, n0_.seo_title AS seo_title_13, n0_.seo_description AS seo_description_14, n0_.image_alt AS image_alt_15, n0_.canonical_url AS canonical_url_16, n0_.is_no_index AS is_no_index_17, n1_.id AS id_18, n1_.title AS title_19, n1_.language AS language_20 FROM news n0_ LEFT JOIN news_news_category n2_ ON n0_.id = n2_.news_id LEFT JOIN news_category n1_ ON n1_.id = n2_.news_category_id WHERE n0_.status = 1 AND n0_.language = ? AND n0_.date <= ? ORDER BY n0_.date DESC, n0_.id DESC

Parameters:

[
  1
  "2026-03-04 04:55:22"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT n0_.id AS id_0,
  n0_.status AS status_1,
  n0_.highlighted AS highlighted_2,
  n0_.date AS date_3,
  n0_.title AS title_4,
  n0_.short_description AS short_description_5,
  n0_.youtube_video_code AS youtube_video_code_6,
  n0_.full_description AS full_description_7,
  n0_.image AS image_8,
  n0_.img_updated_at AS img_updated_at_9,
  n0_.language AS language_10,
  n0_.slug AS slug_11,
  n0_.wordpress_id AS wordpress_id_12,
  n0_.seo_title AS seo_title_13,
  n0_.seo_description AS seo_description_14,
  n0_.image_alt AS image_alt_15,
  n0_.canonical_url AS canonical_url_16,
  n0_.is_no_index AS is_no_index_17,
  n1_.id AS id_18,
  n1_.title AS title_19,
  n1_.language AS language_20
FROM
  news n0_
  LEFT JOIN news_news_category n2_ ON n0_.id = n2_.news_id
  LEFT JOIN news_category n1_ ON n1_.id = n2_.news_category_id
WHERE
  n0_.status = 1
  AND n0_.language = ?
  AND n0_.date <= ?
ORDER BY
  n0_.date DESC,
  n0_.id DESC

SELECT DISTINCT n0_.id AS id_0, n0_.status AS status_1, n0_.highlighted AS highlighted_2, n0_.date AS date_3, n0_.title AS title_4, n0_.short_description AS short_description_5, n0_.youtube_video_code AS youtube_video_code_6, n0_.full_description AS full_description_7, n0_.image AS image_8, n0_.img_updated_at AS img_updated_at_9, n0_.language AS language_10, n0_.slug AS slug_11, n0_.wordpress_id AS wordpress_id_12, n0_.seo_title AS seo_title_13, n0_.seo_description AS seo_description_14, n0_.image_alt AS image_alt_15, n0_.canonical_url AS canonical_url_16, n0_.is_no_index AS is_no_index_17, n1_.id AS id_18, n1_.title AS title_19, n1_.language AS language_20 FROM news n0_ LEFT JOIN news_news_category n2_ ON n0_.id = n2_.news_id LEFT JOIN news_category n1_ ON n1_.id = n2_.news_category_id WHERE n0_.status = 1 AND n0_.language = 1 AND n0_.date <= '2026-03-04 04:55:22' ORDER BY n0_.date DESC, n0_.id 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\NewsRepository->searchActiveByLanguage (line 137)
7	App\Controller\Public\HomeController->news (line 142)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 197)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 7)

0.24 ms
(2.21%)

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_3e999262717bb2ce6768b61e1e5328dc->doDisplay (line 60)
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->news (line 180)
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.22 ms
(2.04%)

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_3e999262717bb2ce6768b61e1e5328dc->doDisplay (line 60)
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->news (line 180)
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.15 ms
(1.39%)

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_3e999262717bb2ce6768b61e1e5328dc->doDisplay (line 60)
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->news (line 180)
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.15 ms
(1.35%)

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)

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\News	65
App\Entity\ProductCategory	7
App\Entity\Product	7
App\Entity\NewsCategory	5
App\Entity\Page	1
App\Entity\GlobalTags	1
App\Entity\GeneralData	1

Entities Mapping

Class	Mapping errors
App\Entity\Page	No errors.
App\Entity\News	No errors.
App\Entity\NewsCategory	No errors.
App\Entity\NewsImage	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 http://novo.siatecbrasil.com.br/pt/noticias

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping