Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

5.89 ms Query time

0 Invalid entities

4 Managed entities

0 Cache hits

0 Cache misses

0 Cache puts

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

2.84 ms
(48.12%)

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.content AS content_3, n0_.meta_title AS meta_title_4, n0_.meta_description AS meta_description_5, n1_.id AS id_6, n1_.published AS published_7, n1_.published_at AS published_at_8, n1_.notification_queued_at AS notification_queued_at_9, n1_.notification_sent_at AS notification_sent_at_10, n1_.notification_last_user_id AS notification_last_user_id_11, n1_.notifications_created AS notifications_created_12, n1_.date_add AS date_add_13, n1_.date_upd AS date_upd_14, l2_.id AS id_15, l2_.name AS name_16, l2_.active AS active_17, l2_.iso_code AS iso_code_18, l2_.language_code AS language_code_19, l2_.locale AS locale_20, l2_.is_rtl AS is_rtl_21, n0_.news_id AS news_id_22, n0_.language_id AS language_id_23, n1_.created_by_id AS created_by_id_24 FROM news_lang n0_ INNER JOIN news n1_ ON n0_.news_id = n1_.id INNER JOIN lang l2_ ON n0_.language_id = l2_.id WHERE n1_.published = 1 AND l2_.iso_code = ? ORDER BY n1_.published_at DESC, n1_.id DESC LIMIT 12

Parameters:

[
  "en"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0_.id AS id_0,
  n0_.title AS title_1,
  n0_.slug AS slug_2,
  n0_.content AS content_3,
  n0_.meta_title AS meta_title_4,
  n0_.meta_description AS meta_description_5,
  n1_.id AS id_6,
  n1_.published AS published_7,
  n1_.published_at AS published_at_8,
  n1_.notification_queued_at AS notification_queued_at_9,
  n1_.notification_sent_at AS notification_sent_at_10,
  n1_.notification_last_user_id AS notification_last_user_id_11,
  n1_.notifications_created AS notifications_created_12,
  n1_.date_add AS date_add_13,
  n1_.date_upd AS date_upd_14,
  l2_.id AS id_15,
  l2_.name AS name_16,
  l2_.active AS active_17,
  l2_.iso_code AS iso_code_18,
  l2_.language_code AS language_code_19,
  l2_.locale AS locale_20,
  l2_.is_rtl AS is_rtl_21,
  n0_.news_id AS news_id_22,
  n0_.language_id AS language_id_23,
  n1_.created_by_id AS created_by_id_24
FROM
  news_lang n0_
  INNER JOIN news n1_ ON n0_.news_id = n1_.id
  INNER JOIN lang l2_ ON n0_.language_id = l2_.id
WHERE
  n1_.published = 1
  AND l2_.iso_code = ?
ORDER BY
  n1_.published_at DESC,
  n1_.id DESC
LIMIT
  12

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.content AS content_3, n0_.meta_title AS meta_title_4, n0_.meta_description AS meta_description_5, n1_.id AS id_6, n1_.published AS published_7, n1_.published_at AS published_at_8, n1_.notification_queued_at AS notification_queued_at_9, n1_.notification_sent_at AS notification_sent_at_10, n1_.notification_last_user_id AS notification_last_user_id_11, n1_.notifications_created AS notifications_created_12, n1_.date_add AS date_add_13, n1_.date_upd AS date_upd_14, l2_.id AS id_15, l2_.name AS name_16, l2_.active AS active_17, l2_.iso_code AS iso_code_18, l2_.language_code AS language_code_19, l2_.locale AS locale_20, l2_.is_rtl AS is_rtl_21, n0_.news_id AS news_id_22, n0_.language_id AS language_id_23, n1_.created_by_id AS created_by_id_24 FROM news_lang n0_ INNER JOIN news n1_ ON n0_.news_id = n1_.id INNER JOIN lang l2_ ON n0_.language_id = l2_.id WHERE n1_.published = 1 AND l2_.iso_code = 'en' ORDER BY n1_.published_at DESC, n1_.id DESC LIMIT 12;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 151)
7	iterator_to_array (line 42)
8	App\Repository\NewsLangRepository::findPublishedPaginated (line 42)
9	App\Controller\Front\NewsController->index (line 45)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 208)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

1.99 ms
(33.71%)

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.content AS content_3, n0_.meta_title AS meta_title_4, n0_.meta_description AS meta_description_5, n1_.id AS id_6, n1_.published AS published_7, n1_.published_at AS published_at_8, n1_.notification_queued_at AS notification_queued_at_9, n1_.notification_sent_at AS notification_sent_at_10, n1_.notification_last_user_id AS notification_last_user_id_11, n1_.notifications_created AS notifications_created_12, n1_.date_add AS date_add_13, n1_.date_upd AS date_upd_14, l2_.id AS id_15, l2_.name AS name_16, l2_.active AS active_17, l2_.iso_code AS iso_code_18, l2_.language_code AS language_code_19, l2_.locale AS locale_20, l2_.is_rtl AS is_rtl_21 FROM news_lang n0_ INNER JOIN news n1_ ON n0_.news_id = n1_.id INNER JOIN lang l2_ ON n0_.language_id = l2_.id WHERE n1_.published = 1 AND l2_.iso_code = ? ORDER BY n1_.published_at DESC, n1_.id DESC) dctrn_result) dctrn_table

Parameters:

[
  "en"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          n0_.id AS id_0,
          n0_.title AS title_1,
          n0_.slug AS slug_2,
          n0_.content AS content_3,
          n0_.meta_title AS meta_title_4,
          n0_.meta_description AS meta_description_5,
          n1_.id AS id_6,
          n1_.published AS published_7,
          n1_.published_at AS published_at_8,
          n1_.notification_queued_at AS notification_queued_at_9,
          n1_.notification_sent_at AS notification_sent_at_10,
          n1_.notification_last_user_id AS notification_last_user_id_11,
          n1_.notifications_created AS notifications_created_12,
          n1_.date_add AS date_add_13,
          n1_.date_upd AS date_upd_14,
          l2_.id AS id_15,
          l2_.name AS name_16,
          l2_.active AS active_17,
          l2_.iso_code AS iso_code_18,
          l2_.language_code AS language_code_19,
          l2_.locale AS locale_20,
          l2_.is_rtl AS is_rtl_21
        FROM
          news_lang n0_
          INNER JOIN news n1_ ON n0_.news_id = n1_.id
          INNER JOIN lang l2_ ON n0_.language_id = l2_.id
        WHERE
          n1_.published = 1
          AND l2_.iso_code = ?
        ORDER BY
          n1_.published_at DESC,
          n1_.id DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.content AS content_3, n0_.meta_title AS meta_title_4, n0_.meta_description AS meta_description_5, n1_.id AS id_6, n1_.published AS published_7, n1_.published_at AS published_at_8, n1_.notification_queued_at AS notification_queued_at_9, n1_.notification_sent_at AS notification_sent_at_10, n1_.notification_last_user_id AS notification_last_user_id_11, n1_.notifications_created AS notifications_created_12, n1_.date_add AS date_add_13, n1_.date_upd AS date_upd_14, l2_.id AS id_15, l2_.name AS name_16, l2_.active AS active_17, l2_.iso_code AS iso_code_18, l2_.language_code AS language_code_19, l2_.locale AS locale_20, l2_.is_rtl AS is_rtl_21 FROM news_lang n0_ INNER JOIN news n1_ ON n0_.news_id = n1_.id INNER JOIN lang l2_ ON n0_.language_id = l2_.id WHERE n1_.published = 1 AND l2_.iso_code = 'en' ORDER BY n1_.published_at DESC, n1_.id DESC) dctrn_result) dctrn_table;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
7	App\Repository\NewsLangRepository->findPublishedPaginated (line 43)
8	App\Controller\Front\NewsController->index (line 45)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 208)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

1.07 ms
(18.17%)

SELECT c0_.id AS id_0 FROM call_for_artists c0_ WHERE c0_.starts_at <= ? AND c0_.ends_at >= ? LIMIT 1

Parameters:

[
  "2026-11-02 13:01:17"
  "2026-11-02 13:01:17"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0
FROM
  call_for_artists c0_
WHERE
  c0_.starts_at <= ?
  AND c0_.ends_at >= ?
LIMIT
  1

SELECT c0_.id AS id_0 FROM call_for_artists c0_ WHERE c0_.starts_at <= '2026-11-02 13:01:17' AND c0_.ends_at >= '2026-11-02 13:01:17' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Repository\CallForArtistsRepository->hasOpen (line 44)
7	App\Twig\CallForArtistsExtension->hasOpenCallForArtists (line 35)
8	__TwigTemplate_743077446d456b9c74aef0d9b14b2b7f->doDisplay (line 50)
9	Twig\Template->yield (line 411)
10	Twig\Template->display (line 366)
11	Twig\Template->render (line 381)
12	Twig\TemplateWrapper->render (line 51)
13	Twig\Extension\CoreExtension->include (line 1522)
14	__TwigTemplate_60621318d0f6da167c01caf001b6c4f4::block_header (line 194)
15	Twig\Template->yieldBlock (line 456)
16	__TwigTemplate_908fe77b0e1f5923906edfd8c2ecbfe6->doDisplay (line 171)
17	Twig\Template->yield (line 411)
18	__TwigTemplate_60621318d0f6da167c01caf001b6c4f4->doDisplay (line 59)
19	Twig\Template->yield (line 411)
20	Twig\Template->display (line 366)
21	Twig\Template->render (line 381)
22	Twig\TemplateWrapper->render (line 51)
23	Twig\Environment->render (line 333)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
27	App\Controller\Front\NewsController->index (line 47)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 208)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (line 29)
33	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
messenger	doctrine.dbal.messenger_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

0 Hits

0 Misses

0 Puts

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\NewsLang	1
App\Entity\News	1
App\Entity\Admin\Employee	1
App\Entity\Lang	1

Entities Mapping

Class	Mapping errors
App\Entity\NewsLang	No errors.
App\Entity\News	No errors.
App\Entity\Lang	No errors.
App\Entity\Admin\Employee	No errors.
App\Entity\NewsComment	No errors.
App\Entity\CallForArtists	No errors.

Symfony Profiler

GET https://app.dev.localero.it/news

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping