Symfony Profiler

Query Metrics

135 Database Queries

24 Different statements

406.64 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

115.12 ms
(28.31%)

SELECT SUM(h0_.hits) AS sclr_0, SUM(h0_.unique_views) AS sclr_1 FROM hit_counter h0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  SUM(h0_.hits) AS sclr_0,
  SUM(h0_.unique_views) AS sclr_1
FROM
  hit_counter h0_

SELECT SUM(h0_.hits) AS sclr_0, SUM(h0_.unique_views) AS sclr_1 FROM hit_counter h0_;

#	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 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 80)
7	App\Service\HitCounterService->App\Service\{closure} (line 48)
8	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 111)
9	Symfony\Component\Cache\LockRegistry::compute (line 102)
10	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 85)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 53)
14	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 71)
15	App\Service\HitCounterService->getHitCounter (line 109)
16	App\Twig\Runtime\AppExtensionRuntime->getHitCounter (line 259)
17	__TwigTemplate_8c94056c31618e6557de2a053a15a5ec->doDisplay (line 387)
18	Twig\Template->yield (line 55)
19	__TwigTemplate_625e7186933bf9de519aa58a869c4265->doDisplay (line 387)
20	Twig\Template->yield (line 343)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 51)
23	Twig\TemplateWrapper->render (line 320)
24	Twig\Environment->render (line 448)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 232)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 191)
27	App\Controller\HomeController->langHome (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

101.41 ms
(24.94%)

SELECT SUM(h0_.hits) AS sclr_0, SUM(h0_.unique_views) AS sclr_1 FROM hit_counter h0_ WHERE h0_.date = ?

Parameters:

[
  "2026-03-22 00:00:00"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  SUM(h0_.hits) AS sclr_0,
  SUM(h0_.unique_views) AS sclr_1
FROM
  hit_counter h0_
WHERE
  h0_.date = ?

SELECT SUM(h0_.hits) AS sclr_0, SUM(h0_.unique_views) AS sclr_1 FROM hit_counter h0_ WHERE h0_.date = '2026-03-22 00:00:00';

#	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 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 87)
7	App\Service\HitCounterService->App\Service\{closure} (line 48)
8	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 111)
9	Symfony\Component\Cache\LockRegistry::compute (line 102)
10	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 85)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 53)
14	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 71)
15	App\Service\HitCounterService->getHitCounter (line 109)
16	App\Twig\Runtime\AppExtensionRuntime->getHitCounter (line 259)
17	__TwigTemplate_8c94056c31618e6557de2a053a15a5ec->doDisplay (line 387)
18	Twig\Template->yield (line 55)
19	__TwigTemplate_625e7186933bf9de519aa58a869c4265->doDisplay (line 387)
20	Twig\Template->yield (line 343)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 51)
23	Twig\TemplateWrapper->render (line 320)
24	Twig\Environment->render (line 448)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 232)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 191)
27	App\Controller\HomeController->langHome (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

87.58 ms
(21.54%)

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.file_type AS file_type_3, t0.file_data AS file_data_4, t0.is_primary AS is_primary_5, t0.old_id AS old_id_6, t0.search_tag AS search_tag_7, t0.image_size AS image_size_8, t0.caption AS caption_9, t0.gz_data AS gz_data_10, t0.news_code AS news_code_11, t0.news_id AS news_id_12 FROM image_store t0 WHERE t0.news_id = ? AND t0.is_primary = ? LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.file_name AS file_name_2,
  t0.file_type AS file_type_3,
  t0.file_data AS file_data_4,
  t0.is_primary AS is_primary_5,
  t0.old_id AS old_id_6,
  t0.search_tag AS search_tag_7,
  t0.image_size AS image_size_8,
  t0.caption AS caption_9,
  t0.gz_data AS gz_data_10,
  t0.news_code AS news_code_11,
  t0.news_id AS news_id_12
FROM
  image_store t0
WHERE
  t0.news_id = ?
  AND t0.is_primary = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.file_type AS file_type_3, t0.file_data AS file_data_4, t0.is_primary AS is_primary_5, t0.old_id AS old_id_6, t0.search_tag AS search_tag_7, t0.image_size AS image_size_8, t0.caption AS caption_9, t0.gz_data AS gz_data_10, t0.news_code AS news_code_11, t0.news_id AS news_id_12 FROM image_store t0 WHERE t0.news_id = 45052 AND t0.is_primary = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 372)
5	App\Twig\Runtime\AppExtensionRuntime->getPrimaryImage (line 240)
6	__TwigTemplate_625e7186933bf9de519aa58a869c4265->block_body (line 431)
7	Twig\Template->yieldBlock (line 184)
8	__TwigTemplate_8c94056c31618e6557de2a053a15a5ec->doDisplay (line 387)
9	Twig\Template->yield (line 55)
10	__TwigTemplate_625e7186933bf9de519aa58a869c4265->doDisplay (line 387)
11	Twig\Template->yield (line 343)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 320)
15	Twig\Environment->render (line 448)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 232)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 191)
18	App\Controller\HomeController->langHome (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

15.76 ms
(3.88%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.publish_date AS publish_date_5, t0.featured AS featured_6, t0.meta_title AS meta_title_7, t0.meta_keywords AS meta_keywords_8, t0.meta_description AS meta_description_9, t0.created_on AS created_on_10, t0.file_data AS file_data_11, t0.file_name AS file_name_12, t0.file_type AS file_type_13, t0.trending AS trending_14, t0.is_breaking AS is_breaking_15, t0.old_id AS old_id_16, t0.news_id AS news_id_17, t0.comment_status AS comment_status_18, t0.status AS status_19, t0.youtube_url AS youtube_url_20, t0.youtube_url_second AS youtube_url_second_21, t0.disclaimer AS disclaimer_22, t0.fact_box AS fact_box_23, t0.fact_box_size AS fact_box_size_24, t0.fact_box_placement AS fact_box_placement_25, t0.updated_at AS updated_at_26, t0.last_update_key AS last_update_key_27, t0.category_id AS category_id_28, t0.language_id AS language_id_29, t0.reporter_id AS reporter_id_30, t0.author_id AS author_id_31 FROM news t0 WHERE t0.id = ? LIMIT 1

Parameters:

[
  45052
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.content AS content_4,
  t0.publish_date AS publish_date_5,
  t0.featured AS featured_6,
  t0.meta_title AS meta_title_7,
  t0.meta_keywords AS meta_keywords_8,
  t0.meta_description AS meta_description_9,
  t0.created_on AS created_on_10,
  t0.file_data AS file_data_11,
  t0.file_name AS file_name_12,
  t0.file_type AS file_type_13,
  t0.trending AS trending_14,
  t0.is_breaking AS is_breaking_15,
  t0.old_id AS old_id_16,
  t0.news_id AS news_id_17,
  t0.comment_status AS comment_status_18,
  t0.status AS status_19,
  t0.youtube_url AS youtube_url_20,
  t0.youtube_url_second AS youtube_url_second_21,
  t0.disclaimer AS disclaimer_22,
  t0.fact_box AS fact_box_23,
  t0.fact_box_size AS fact_box_size_24,
  t0.fact_box_placement AS fact_box_placement_25,
  t0.updated_at AS updated_at_26,
  t0.last_update_key AS last_update_key_27,
  t0.category_id AS category_id_28,
  t0.language_id AS language_id_29,
  t0.reporter_id AS reporter_id_30,
  t0.author_id AS author_id_31
FROM
  news t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.publish_date AS publish_date_5, t0.featured AS featured_6, t0.meta_title AS meta_title_7, t0.meta_keywords AS meta_keywords_8, t0.meta_description AS meta_description_9, t0.created_on AS created_on_10, t0.file_data AS file_data_11, t0.file_name AS file_name_12, t0.file_type AS file_type_13, t0.trending AS trending_14, t0.is_breaking AS is_breaking_15, t0.old_id AS old_id_16, t0.news_id AS news_id_17, t0.comment_status AS comment_status_18, t0.status AS status_19, t0.youtube_url AS youtube_url_20, t0.youtube_url_second AS youtube_url_second_21, t0.disclaimer AS disclaimer_22, t0.fact_box AS fact_box_23, t0.fact_box_size AS fact_box_size_24, t0.fact_box_placement AS fact_box_placement_25, t0.updated_at AS updated_at_26, t0.last_update_key AS last_update_key_27, t0.category_id AS category_id_28, t0.language_id AS language_id_29, t0.reporter_id AS reporter_id_30, t0.author_id AS author_id_31 FROM news t0 WHERE t0.id = 45052 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 369)
5	App\Twig\Runtime\AppExtensionRuntime->getPrimaryImage (line 240)
6	__TwigTemplate_625e7186933bf9de519aa58a869c4265->block_body (line 431)
7	Twig\Template->yieldBlock (line 184)
8	__TwigTemplate_8c94056c31618e6557de2a053a15a5ec->doDisplay (line 387)
9	Twig\Template->yield (line 55)
10	__TwigTemplate_625e7186933bf9de519aa58a869c4265->doDisplay (line 387)
11	Twig\Template->yield (line 343)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 320)
15	Twig\Environment->render (line 448)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 232)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 191)
18	App\Controller\HomeController->langHome (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

14.36 ms
(3.53%)

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.content AS content_3, n0_.publish_date AS publish_date_4, n0_.featured AS featured_5, n0_.meta_title AS meta_title_6, n0_.meta_keywords AS meta_keywords_7, n0_.meta_description AS meta_description_8, n0_.created_on AS created_on_9, n0_.file_data AS file_data_10, n0_.file_name AS file_name_11, n0_.file_type AS file_type_12, n0_.trending AS trending_13, n0_.is_breaking AS is_breaking_14, n0_.old_id AS old_id_15, n0_.news_id AS news_id_16, n0_.comment_status AS comment_status_17, n0_.status AS status_18, n0_.youtube_url AS youtube_url_19, n0_.youtube_url_second AS youtube_url_second_20, n0_.disclaimer AS disclaimer_21, n0_.fact_box AS fact_box_22, n0_.fact_box_size AS fact_box_size_23, n0_.fact_box_placement AS fact_box_placement_24, n0_.updated_at AS updated_at_25, n0_.last_update_key AS last_update_key_26, n0_.category_id AS category_id_27, n0_.language_id AS language_id_28, n0_.reporter_id AS reporter_id_29, n0_.author_id AS author_id_30 FROM news n0_ INNER JOIN image_store i1_ ON n0_.id = i1_.news_id WHERE n0_.language_id = ? AND n0_.status = ? AND n0_.is_breaking = ? ORDER BY n0_.publish_date DESC LIMIT 2

Parameters:

[
  1
  "a"
  1
]

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_.publish_date AS publish_date_4,
  n0_.featured AS featured_5,
  n0_.meta_title AS meta_title_6,
  n0_.meta_keywords AS meta_keywords_7,
  n0_.meta_description AS meta_description_8,
  n0_.created_on AS created_on_9,
  n0_.file_data AS file_data_10,
  n0_.file_name AS file_name_11,
  n0_.file_type AS file_type_12,
  n0_.trending AS trending_13,
  n0_.is_breaking AS is_breaking_14,
  n0_.old_id AS old_id_15,
  n0_.news_id AS news_id_16,
  n0_.comment_status AS comment_status_17,
  n0_.status AS status_18,
  n0_.youtube_url AS youtube_url_19,
  n0_.youtube_url_second AS youtube_url_second_20,
  n0_.disclaimer AS disclaimer_21,
  n0_.fact_box AS fact_box_22,
  n0_.fact_box_size AS fact_box_size_23,
  n0_.fact_box_placement AS fact_box_placement_24,
  n0_.updated_at AS updated_at_25,
  n0_.last_update_key AS last_update_key_26,
  n0_.category_id AS category_id_27,
  n0_.language_id AS language_id_28,
  n0_.reporter_id AS reporter_id_29,
  n0_.author_id AS author_id_30
FROM
  news n0_
  INNER JOIN image_store i1_ ON n0_.id = i1_.news_id
WHERE
  n0_.language_id = ?
  AND n0_.status = ?
  AND n0_.is_breaking = ?
ORDER BY
  n0_.publish_date DESC
LIMIT
  2

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.content AS content_3, n0_.publish_date AS publish_date_4, n0_.featured AS featured_5, n0_.meta_title AS meta_title_6, n0_.meta_keywords AS meta_keywords_7, n0_.meta_description AS meta_description_8, n0_.created_on AS created_on_9, n0_.file_data AS file_data_10, n0_.file_name AS file_name_11, n0_.file_type AS file_type_12, n0_.trending AS trending_13, n0_.is_breaking AS is_breaking_14, n0_.old_id AS old_id_15, n0_.news_id AS news_id_16, n0_.comment_status AS comment_status_17, n0_.status AS status_18, n0_.youtube_url AS youtube_url_19, n0_.youtube_url_second AS youtube_url_second_20, n0_.disclaimer AS disclaimer_21, n0_.fact_box AS fact_box_22, n0_.fact_box_size AS fact_box_size_23, n0_.fact_box_placement AS fact_box_placement_24, n0_.updated_at AS updated_at_25, n0_.last_update_key AS last_update_key_26, n0_.category_id AS category_id_27, n0_.language_id AS language_id_28, n0_.reporter_id AS reporter_id_29, n0_.author_id AS author_id_30 FROM news n0_ INNER JOIN image_store i1_ ON n0_.id = i1_.news_id WHERE n0_.language_id = 1 AND n0_.status = 'a' AND n0_.is_breaking = 1 ORDER BY n0_.publish_date DESC LIMIT 2;

#	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 353)
7	App\Service\LayoutService->getDataForMegaPage (line 95)
8	App\Service\LayoutService->buildLayoutInfoAndData (line 40)
9	App\Service\LayoutService->getLayoutInfoAndData (line 53)
10	App\Controller\HomeController->App\Controller\{closure} (line 48)
11	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 111)
12	Symfony\Component\Cache\LockRegistry::compute (line 102)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
14	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 85)
15	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
16	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 53)
17	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 49)
18	App\Controller\HomeController->langHome (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

14.06 ms
(3.46%)

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.content AS content_3, n0_.publish_date AS publish_date_4, n0_.featured AS featured_5, n0_.meta_title AS meta_title_6, n0_.meta_keywords AS meta_keywords_7, n0_.meta_description AS meta_description_8, n0_.created_on AS created_on_9, n0_.file_data AS file_data_10, n0_.file_name AS file_name_11, n0_.file_type AS file_type_12, n0_.trending AS trending_13, n0_.is_breaking AS is_breaking_14, n0_.old_id AS old_id_15, n0_.news_id AS news_id_16, n0_.comment_status AS comment_status_17, n0_.status AS status_18, n0_.youtube_url AS youtube_url_19, n0_.youtube_url_second AS youtube_url_second_20, n0_.disclaimer AS disclaimer_21, n0_.fact_box AS fact_box_22, n0_.fact_box_size AS fact_box_size_23, n0_.fact_box_placement AS fact_box_placement_24, n0_.updated_at AS updated_at_25, n0_.last_update_key AS last_update_key_26, n0_.category_id AS category_id_27, n0_.language_id AS language_id_28, n0_.reporter_id AS reporter_id_29, n0_.author_id AS author_id_30 FROM news n0_ INNER JOIN image_store i1_ ON n0_.id = i1_.news_id WHERE n0_.language_id = ? AND n0_.status = ? ORDER BY n0_.publish_date DESC LIMIT 4

Parameters:

[
  1
  "a"
]

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_.publish_date AS publish_date_4,
  n0_.featured AS featured_5,
  n0_.meta_title AS meta_title_6,
  n0_.meta_keywords AS meta_keywords_7,
  n0_.meta_description AS meta_description_8,
  n0_.created_on AS created_on_9,
  n0_.file_data AS file_data_10,
  n0_.file_name AS file_name_11,
  n0_.file_type AS file_type_12,
  n0_.trending AS trending_13,
  n0_.is_breaking AS is_breaking_14,
  n0_.old_id AS old_id_15,
  n0_.news_id AS news_id_16,
  n0_.comment_status AS comment_status_17,
  n0_.status AS status_18,
  n0_.youtube_url AS youtube_url_19,
  n0_.youtube_url_second AS youtube_url_second_20,
  n0_.disclaimer AS disclaimer_21,
  n0_.fact_box AS fact_box_22,
  n0_.fact_box_size AS fact_box_size_23,
  n0_.fact_box_placement AS fact_box_placement_24,
  n0_.updated_at AS updated_at_25,
  n0_.last_update_key AS last_update_key_26,
  n0_.category_id AS category_id_27,
  n0_.language_id AS language_id_28,
  n0_.reporter_id AS reporter_id_29,
  n0_.author_id AS author_id_30
FROM
  news n0_
  INNER JOIN image_store i1_ ON n0_.id = i1_.news_id
WHERE
  n0_.language_id = ?
  AND n0_.status = ?
ORDER BY
  n0_.publish_date DESC
LIMIT
  4

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.content AS content_3, n0_.publish_date AS publish_date_4, n0_.featured AS featured_5, n0_.meta_title AS meta_title_6, n0_.meta_keywords AS meta_keywords_7, n0_.meta_description AS meta_description_8, n0_.created_on AS created_on_9, n0_.file_data AS file_data_10, n0_.file_name AS file_name_11, n0_.file_type AS file_type_12, n0_.trending AS trending_13, n0_.is_breaking AS is_breaking_14, n0_.old_id AS old_id_15, n0_.news_id AS news_id_16, n0_.comment_status AS comment_status_17, n0_.status AS status_18, n0_.youtube_url AS youtube_url_19, n0_.youtube_url_second AS youtube_url_second_20, n0_.disclaimer AS disclaimer_21, n0_.fact_box AS fact_box_22, n0_.fact_box_size AS fact_box_size_23, n0_.fact_box_placement AS fact_box_placement_24, n0_.updated_at AS updated_at_25, n0_.last_update_key AS last_update_key_26, n0_.category_id AS category_id_27, n0_.language_id AS language_id_28, n0_.reporter_id AS reporter_id_29, n0_.author_id AS author_id_30 FROM news n0_ INNER JOIN image_store i1_ ON n0_.id = i1_.news_id WHERE n0_.language_id = 1 AND n0_.status = 'a' ORDER BY n0_.publish_date DESC LIMIT 4;

#	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 105)
7	App\Controller\HomeController->App\Controller\{closure} (line 48)
8	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 111)
9	Symfony\Component\Cache\LockRegistry::compute (line 102)
10	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 85)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 53)
14	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 93)
15	App\Controller\HomeController->langHome (line 181)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

13.28 ms
(3.27%)

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.content AS content_3, n0_.publish_date AS publish_date_4, n0_.featured AS featured_5, n0_.meta_title AS meta_title_6, n0_.meta_keywords AS meta_keywords_7, n0_.meta_description AS meta_description_8, n0_.created_on AS created_on_9, n0_.file_data AS file_data_10, n0_.file_name AS file_name_11, n0_.file_type AS file_type_12, n0_.trending AS trending_13, n0_.is_breaking AS is_breaking_14, n0_.old_id AS old_id_15, n0_.news_id AS news_id_16, n0_.comment_status AS comment_status_17, n0_.status AS status_18, n0_.youtube_url AS youtube_url_19, n0_.youtube_url_second AS youtube_url_second_20, n0_.disclaimer AS disclaimer_21, n0_.fact_box AS fact_box_22, n0_.fact_box_size AS fact_box_size_23, n0_.fact_box_placement AS fact_box_placement_24, n0_.updated_at AS updated_at_25, n0_.last_update_key AS last_update_key_26, n0_.category_id AS category_id_27, n0_.language_id AS language_id_28, n0_.reporter_id AS reporter_id_29, n0_.author_id AS author_id_30 FROM news n0_ INNER JOIN image_store i1_ ON n0_.id = i1_.news_id WHERE n0_.language_id = ? AND n0_.status = ? AND n0_.trending = 1 ORDER BY n0_.publish_date DESC LIMIT 10

Parameters:

[
  1
  "a"
]

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_.publish_date AS publish_date_4,
  n0_.featured AS featured_5,
  n0_.meta_title AS meta_title_6,
  n0_.meta_keywords AS meta_keywords_7,
  n0_.meta_description AS meta_description_8,
  n0_.created_on AS created_on_9,
  n0_.file_data AS file_data_10,
  n0_.file_name AS file_name_11,
  n0_.file_type AS file_type_12,
  n0_.trending AS trending_13,
  n0_.is_breaking AS is_breaking_14,
  n0_.old_id AS old_id_15,
  n0_.news_id AS news_id_16,
  n0_.comment_status AS comment_status_17,
  n0_.status AS status_18,
  n0_.youtube_url AS youtube_url_19,
  n0_.youtube_url_second AS youtube_url_second_20,
  n0_.disclaimer AS disclaimer_21,
  n0_.fact_box AS fact_box_22,
  n0_.fact_box_size AS fact_box_size_23,
  n0_.fact_box_placement AS fact_box_placement_24,
  n0_.updated_at AS updated_at_25,
  n0_.last_update_key AS last_update_key_26,
  n0_.category_id AS category_id_27,
  n0_.language_id AS language_id_28,
  n0_.reporter_id AS reporter_id_29,
  n0_.author_id AS author_id_30
FROM
  news n0_
  INNER JOIN image_store i1_ ON n0_.id = i1_.news_id
WHERE
  n0_.language_id = ?
  AND n0_.status = ?
  AND n0_.trending = 1
ORDER BY
  n0_.publish_date DESC
LIMIT
  10

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.content AS content_3, n0_.publish_date AS publish_date_4, n0_.featured AS featured_5, n0_.meta_title AS meta_title_6, n0_.meta_keywords AS meta_keywords_7, n0_.meta_description AS meta_description_8, n0_.created_on AS created_on_9, n0_.file_data AS file_data_10, n0_.file_name AS file_name_11, n0_.file_type AS file_type_12, n0_.trending AS trending_13, n0_.is_breaking AS is_breaking_14, n0_.old_id AS old_id_15, n0_.news_id AS news_id_16, n0_.comment_status AS comment_status_17, n0_.status AS status_18, n0_.youtube_url AS youtube_url_19, n0_.youtube_url_second AS youtube_url_second_20, n0_.disclaimer AS disclaimer_21, n0_.fact_box AS fact_box_22, n0_.fact_box_size AS fact_box_size_23, n0_.fact_box_placement AS fact_box_placement_24, n0_.updated_at AS updated_at_25, n0_.last_update_key AS last_update_key_26, n0_.category_id AS category_id_27, n0_.language_id AS language_id_28, n0_.reporter_id AS reporter_id_29, n0_.author_id AS author_id_30 FROM news n0_ INNER JOIN image_store i1_ ON n0_.id = i1_.news_id WHERE n0_.language_id = 1 AND n0_.status = 'a' AND n0_.trending = 1 ORDER BY n0_.publish_date DESC LIMIT 10;

#	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	App\Controller\HomeController->App\Controller\{closure} (line 48)
8	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 111)
9	Symfony\Component\Cache\LockRegistry::compute (line 102)
10	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 85)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 53)
14	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 132)
15	App\Controller\HomeController->langHome (line 181)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

13.18 ms
(3.24%)

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.content AS content_3, n0_.publish_date AS publish_date_4, n0_.featured AS featured_5, n0_.meta_title AS meta_title_6, n0_.meta_keywords AS meta_keywords_7, n0_.meta_description AS meta_description_8, n0_.created_on AS created_on_9, n0_.file_data AS file_data_10, n0_.file_name AS file_name_11, n0_.file_type AS file_type_12, n0_.trending AS trending_13, n0_.is_breaking AS is_breaking_14, n0_.old_id AS old_id_15, n0_.news_id AS news_id_16, n0_.comment_status AS comment_status_17, n0_.status AS status_18, n0_.youtube_url AS youtube_url_19, n0_.youtube_url_second AS youtube_url_second_20, n0_.disclaimer AS disclaimer_21, n0_.fact_box AS fact_box_22, n0_.fact_box_size AS fact_box_size_23, n0_.fact_box_placement AS fact_box_placement_24, n0_.updated_at AS updated_at_25, n0_.last_update_key AS last_update_key_26, n0_.category_id AS category_id_27, n0_.language_id AS language_id_28, n0_.reporter_id AS reporter_id_29, n0_.author_id AS author_id_30 FROM news n0_ WHERE n0_.language_id = ? AND n0_.status = ? ORDER BY n0_.publish_date DESC LIMIT 8

Parameters:

[
  1
  "a"
]

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_.publish_date AS publish_date_4,
  n0_.featured AS featured_5,
  n0_.meta_title AS meta_title_6,
  n0_.meta_keywords AS meta_keywords_7,
  n0_.meta_description AS meta_description_8,
  n0_.created_on AS created_on_9,
  n0_.file_data AS file_data_10,
  n0_.file_name AS file_name_11,
  n0_.file_type AS file_type_12,
  n0_.trending AS trending_13,
  n0_.is_breaking AS is_breaking_14,
  n0_.old_id AS old_id_15,
  n0_.news_id AS news_id_16,
  n0_.comment_status AS comment_status_17,
  n0_.status AS status_18,
  n0_.youtube_url AS youtube_url_19,
  n0_.youtube_url_second AS youtube_url_second_20,
  n0_.disclaimer AS disclaimer_21,
  n0_.fact_box AS fact_box_22,
  n0_.fact_box_size AS fact_box_size_23,
  n0_.fact_box_placement AS fact_box_placement_24,
  n0_.updated_at AS updated_at_25,
  n0_.last_update_key AS last_update_key_26,
  n0_.category_id AS category_id_27,
  n0_.language_id AS language_id_28,
  n0_.reporter_id AS reporter_id_29,
  n0_.author_id AS author_id_30
FROM
  news n0_
WHERE
  n0_.language_id = ?
  AND n0_.status = ?
ORDER BY
  n0_.publish_date DESC
LIMIT
  8

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.content AS content_3, n0_.publish_date AS publish_date_4, n0_.featured AS featured_5, n0_.meta_title AS meta_title_6, n0_.meta_keywords AS meta_keywords_7, n0_.meta_description AS meta_description_8, n0_.created_on AS created_on_9, n0_.file_data AS file_data_10, n0_.file_name AS file_name_11, n0_.file_type AS file_type_12, n0_.trending AS trending_13, n0_.is_breaking AS is_breaking_14, n0_.old_id AS old_id_15, n0_.news_id AS news_id_16, n0_.comment_status AS comment_status_17, n0_.status AS status_18, n0_.youtube_url AS youtube_url_19, n0_.youtube_url_second AS youtube_url_second_20, n0_.disclaimer AS disclaimer_21, n0_.fact_box AS fact_box_22, n0_.fact_box_size AS fact_box_size_23, n0_.fact_box_placement AS fact_box_placement_24, n0_.updated_at AS updated_at_25, n0_.last_update_key AS last_update_key_26, n0_.category_id AS category_id_27, n0_.language_id AS language_id_28, n0_.reporter_id AS reporter_id_29, n0_.author_id AS author_id_30 FROM news n0_ WHERE n0_.language_id = 1 AND n0_.status = 'a' ORDER BY n0_.publish_date DESC LIMIT 8;

#	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 124)
7	App\Controller\HomeController->App\Controller\{closure} (line 48)
8	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 111)
9	Symfony\Component\Cache\LockRegistry::compute (line 102)
10	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 85)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 53)
14	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 113)
15	App\Controller\HomeController->langHome (line 181)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

7.43 ms
(1.83%)

SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?

Parameters:

[
  "dharamika-rajaniti"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  category t0
WHERE
  t0.slug = ?

SELECT COUNT(*) FROM category t0 WHERE t0.slug = 'dharamika-rajaniti';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 865)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->count (line 140)
3	Doctrine\ORM\EntityRepository->count (line 86)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->count (line 78)
5	App\Service\SlugService->slugExists (line 50)
6	App\Service\SlugService->createUniqueSlug (line 259)
7	App\Twig\Runtime\AppExtensionRuntime->createSlug (line 594)
8	__TwigTemplate_cc808ae27b3a6f5f189f75ee57fae35e->doDisplay (line 387)
9	Twig\Template->yield (line 343)
10	Twig\Template->display (line 358)
11	Twig\Template->render (line 51)
12	Twig\TemplateWrapper->render (line 320)
13	Twig\Environment->render (line 448)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 354)
17	App\Controller\WebsiteController->header (line 181)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
20	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
21	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
22	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
23	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
24	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 176)
25	__TwigTemplate_8c94056c31618e6557de2a053a15a5ec->doDisplay (line 387)
26	Twig\Template->yield (line 55)
27	__TwigTemplate_625e7186933bf9de519aa58a869c4265->doDisplay (line 387)
28	Twig\Template->yield (line 343)
29	Twig\Template->display (line 358)
30	Twig\Template->render (line 51)
31	Twig\TemplateWrapper->render (line 320)
32	Twig\Environment->render (line 448)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 232)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 191)
35	App\Controller\HomeController->langHome (line 181)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
38	Symfony\Component\HttpKernel\Kernel->handle (line 35)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
40	require_once (line 5)

4.26 ms
(1.05%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.iso AS iso_4, t0.color AS color_5, t0.domain AS domain_6, t0.name_in_language AS name_in_language_7, t0.writing_direction AS writing_direction_8, t0.time_zone AS time_zone_9 FROM language t0 WHERE t0.iso = ? LIMIT 1

Parameters:

[
  "pa"
]

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.iso AS iso_4,
  t0.color AS color_5,
  t0.domain AS domain_6,
  t0.name_in_language AS name_in_language_7,
  t0.writing_direction AS writing_direction_8,
  t0.time_zone AS time_zone_9
FROM
  language t0
WHERE
  t0.iso = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.iso AS iso_4, t0.color AS color_5, t0.domain AS domain_6, t0.name_in_language AS name_in_language_7, t0.writing_direction AS writing_direction_8, t0.time_zone AS time_zone_9 FROM language t0 WHERE t0.iso = 'pa' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 44)
5	App\EventSubscriber\HitCounterSubscriber->onKernelRequest (line 116)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

3.57 ms
(0.88%)

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.content AS content_3, n0_.publish_date AS publish_date_4, n0_.featured AS featured_5, n0_.meta_title AS meta_title_6, n0_.meta_keywords AS meta_keywords_7, n0_.meta_description AS meta_description_8, n0_.created_on AS created_on_9, n0_.file_data AS file_data_10, n0_.file_name AS file_name_11, n0_.file_type AS file_type_12, n0_.trending AS trending_13, n0_.is_breaking AS is_breaking_14, n0_.old_id AS old_id_15, n0_.news_id AS news_id_16, n0_.comment_status AS comment_status_17, n0_.status AS status_18, n0_.youtube_url AS youtube_url_19, n0_.youtube_url_second AS youtube_url_second_20, n0_.disclaimer AS disclaimer_21, n0_.fact_box AS fact_box_22, n0_.fact_box_size AS fact_box_size_23, n0_.fact_box_placement AS fact_box_placement_24, n0_.updated_at AS updated_at_25, n0_.last_update_key AS last_update_key_26, n0_.category_id AS category_id_27, n0_.language_id AS language_id_28, n0_.reporter_id AS reporter_id_29, n0_.author_id AS author_id_30 FROM news n0_ INNER JOIN image_store i1_ ON n0_.id = i1_.news_id WHERE n0_.language_id = ? AND n0_.status = ? AND n0_.category_id = ? ORDER BY n0_.publish_date DESC LIMIT 8

Parameters:

[
  1
  "a"
  1042
]

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_.publish_date AS publish_date_4,
  n0_.featured AS featured_5,
  n0_.meta_title AS meta_title_6,
  n0_.meta_keywords AS meta_keywords_7,
  n0_.meta_description AS meta_description_8,
  n0_.created_on AS created_on_9,
  n0_.file_data AS file_data_10,
  n0_.file_name AS file_name_11,
  n0_.file_type AS file_type_12,
  n0_.trending AS trending_13,
  n0_.is_breaking AS is_breaking_14,
  n0_.old_id AS old_id_15,
  n0_.news_id AS news_id_16,
  n0_.comment_status AS comment_status_17,
  n0_.status AS status_18,
  n0_.youtube_url AS youtube_url_19,
  n0_.youtube_url_second AS youtube_url_second_20,
  n0_.disclaimer AS disclaimer_21,
  n0_.fact_box AS fact_box_22,
  n0_.fact_box_size AS fact_box_size_23,
  n0_.fact_box_placement AS fact_box_placement_24,
  n0_.updated_at AS updated_at_25,
  n0_.last_update_key AS last_update_key_26,
  n0_.category_id AS category_id_27,
  n0_.language_id AS language_id_28,
  n0_.reporter_id AS reporter_id_29,
  n0_.author_id AS author_id_30
FROM
  news n0_
  INNER JOIN image_store i1_ ON n0_.id = i1_.news_id
WHERE
  n0_.language_id = ?
  AND n0_.status = ?
  AND n0_.category_id = ?
ORDER BY
  n0_.publish_date DESC
LIMIT
  8

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.content AS content_3, n0_.publish_date AS publish_date_4, n0_.featured AS featured_5, n0_.meta_title AS meta_title_6, n0_.meta_keywords AS meta_keywords_7, n0_.meta_description AS meta_description_8, n0_.created_on AS created_on_9, n0_.file_data AS file_data_10, n0_.file_name AS file_name_11, n0_.file_type AS file_type_12, n0_.trending AS trending_13, n0_.is_breaking AS is_breaking_14, n0_.old_id AS old_id_15, n0_.news_id AS news_id_16, n0_.comment_status AS comment_status_17, n0_.status AS status_18, n0_.youtube_url AS youtube_url_19, n0_.youtube_url_second AS youtube_url_second_20, n0_.disclaimer AS disclaimer_21, n0_.fact_box AS fact_box_22, n0_.fact_box_size AS fact_box_size_23, n0_.fact_box_placement AS fact_box_placement_24, n0_.updated_at AS updated_at_25, n0_.last_update_key AS last_update_key_26, n0_.category_id AS category_id_27, n0_.language_id AS language_id_28, n0_.reporter_id AS reporter_id_29, n0_.author_id AS author_id_30 FROM news n0_ INNER JOIN image_store i1_ ON n0_.id = i1_.news_id WHERE n0_.language_id = 1 AND n0_.status = 'a' AND n0_.category_id = 1042 ORDER BY n0_.publish_date DESC LIMIT 8;

#	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 401)
7	App\Service\LayoutService->getDataForMegaPage (line 95)
8	App\Service\LayoutService->buildLayoutInfoAndData (line 40)
9	App\Service\LayoutService->getLayoutInfoAndData (line 53)
10	App\Controller\HomeController->App\Controller\{closure} (line 48)
11	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 111)
12	Symfony\Component\Cache\LockRegistry::compute (line 102)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
14	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 85)
15	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
16	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 53)
17	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 49)
18	App\Controller\HomeController->langHome (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

3.45 ms
(0.85%)

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.content AS content_3, n0_.publish_date AS publish_date_4, n0_.featured AS featured_5, n0_.meta_title AS meta_title_6, n0_.meta_keywords AS meta_keywords_7, n0_.meta_description AS meta_description_8, n0_.created_on AS created_on_9, n0_.file_data AS file_data_10, n0_.file_name AS file_name_11, n0_.file_type AS file_type_12, n0_.trending AS trending_13, n0_.is_breaking AS is_breaking_14, n0_.old_id AS old_id_15, n0_.news_id AS news_id_16, n0_.comment_status AS comment_status_17, n0_.status AS status_18, n0_.youtube_url AS youtube_url_19, n0_.youtube_url_second AS youtube_url_second_20, n0_.disclaimer AS disclaimer_21, n0_.fact_box AS fact_box_22, n0_.fact_box_size AS fact_box_size_23, n0_.fact_box_placement AS fact_box_placement_24, n0_.updated_at AS updated_at_25, n0_.last_update_key AS last_update_key_26, n0_.category_id AS category_id_27, n0_.language_id AS language_id_28, n0_.reporter_id AS reporter_id_29, n0_.author_id AS author_id_30 FROM news n0_ WHERE n0_.category_id = ? AND n0_.language_id = ? LIMIT 4

Parameters:

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_.publish_date AS publish_date_4,
  n0_.featured AS featured_5,
  n0_.meta_title AS meta_title_6,
  n0_.meta_keywords AS meta_keywords_7,
  n0_.meta_description AS meta_description_8,
  n0_.created_on AS created_on_9,
  n0_.file_data AS file_data_10,
  n0_.file_name AS file_name_11,
  n0_.file_type AS file_type_12,
  n0_.trending AS trending_13,
  n0_.is_breaking AS is_breaking_14,
  n0_.old_id AS old_id_15,
  n0_.news_id AS news_id_16,
  n0_.comment_status AS comment_status_17,
  n0_.status AS status_18,
  n0_.youtube_url AS youtube_url_19,
  n0_.youtube_url_second AS youtube_url_second_20,
  n0_.disclaimer AS disclaimer_21,
  n0_.fact_box AS fact_box_22,
  n0_.fact_box_size AS fact_box_size_23,
  n0_.fact_box_placement AS fact_box_placement_24,
  n0_.updated_at AS updated_at_25,
  n0_.last_update_key AS last_update_key_26,
  n0_.category_id AS category_id_27,
  n0_.language_id AS language_id_28,
  n0_.reporter_id AS reporter_id_29,
  n0_.author_id AS author_id_30
FROM
  news n0_
WHERE
  n0_.category_id = ?
  AND n0_.language_id = ?
LIMIT
  4

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.content AS content_3, n0_.publish_date AS publish_date_4, n0_.featured AS featured_5, n0_.meta_title AS meta_title_6, n0_.meta_keywords AS meta_keywords_7, n0_.meta_description AS meta_description_8, n0_.created_on AS created_on_9, n0_.file_data AS file_data_10, n0_.file_name AS file_name_11, n0_.file_type AS file_type_12, n0_.trending AS trending_13, n0_.is_breaking AS is_breaking_14, n0_.old_id AS old_id_15, n0_.news_id AS news_id_16, n0_.comment_status AS comment_status_17, n0_.status AS status_18, n0_.youtube_url AS youtube_url_19, n0_.youtube_url_second AS youtube_url_second_20, n0_.disclaimer AS disclaimer_21, n0_.fact_box AS fact_box_22, n0_.fact_box_size AS fact_box_size_23, n0_.fact_box_placement AS fact_box_placement_24, n0_.updated_at AS updated_at_25, n0_.last_update_key AS last_update_key_26, n0_.category_id AS category_id_27, n0_.language_id AS language_id_28, n0_.reporter_id AS reporter_id_29, n0_.author_id AS author_id_30 FROM news n0_ WHERE n0_.category_id = 2096 AND n0_.language_id = 1 LIMIT 4;

#	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 240)
7	App\Twig\Runtime\AppExtensionRuntime->getNewsByCat (line 466)
8	__TwigTemplate_625e7186933bf9de519aa58a869c4265->block_body (line 431)
9	Twig\Template->yieldBlock (line 184)
10	__TwigTemplate_8c94056c31618e6557de2a053a15a5ec->doDisplay (line 387)
11	Twig\Template->yield (line 55)
12	__TwigTemplate_625e7186933bf9de519aa58a869c4265->doDisplay (line 387)
13	Twig\Template->yield (line 343)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 320)
17	Twig\Environment->render (line 448)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 232)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 191)
20	App\Controller\HomeController->langHome (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 5)

2.67 ms
(0.66%)

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.content AS content_3, n0_.publish_date AS publish_date_4, n0_.featured AS featured_5, n0_.meta_title AS meta_title_6, n0_.meta_keywords AS meta_keywords_7, n0_.meta_description AS meta_description_8, n0_.created_on AS created_on_9, n0_.file_data AS file_data_10, n0_.file_name AS file_name_11, n0_.file_type AS file_type_12, n0_.trending AS trending_13, n0_.is_breaking AS is_breaking_14, n0_.old_id AS old_id_15, n0_.news_id AS news_id_16, n0_.comment_status AS comment_status_17, n0_.status AS status_18, n0_.youtube_url AS youtube_url_19, n0_.youtube_url_second AS youtube_url_second_20, n0_.disclaimer AS disclaimer_21, n0_.fact_box AS fact_box_22, n0_.fact_box_size AS fact_box_size_23, n0_.fact_box_placement AS fact_box_placement_24, n0_.updated_at AS updated_at_25, n0_.last_update_key AS last_update_key_26, n0_.category_id AS category_id_27, n0_.language_id AS language_id_28, n0_.reporter_id AS reporter_id_29, n0_.author_id AS author_id_30 FROM news n0_ INNER JOIN image_store i1_ ON n0_.id = i1_.news_id WHERE n0_.language_id = ? AND n0_.status = ? AND n0_.category_id = ? ORDER BY n0_.publish_date DESC LIMIT 2

Parameters:

[
  1
  "a"
  1045
]

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_.publish_date AS publish_date_4,
  n0_.featured AS featured_5,
  n0_.meta_title AS meta_title_6,
  n0_.meta_keywords AS meta_keywords_7,
  n0_.meta_description AS meta_description_8,
  n0_.created_on AS created_on_9,
  n0_.file_data AS file_data_10,
  n0_.file_name AS file_name_11,
  n0_.file_type AS file_type_12,
  n0_.trending AS trending_13,
  n0_.is_breaking AS is_breaking_14,
  n0_.old_id AS old_id_15,
  n0_.news_id AS news_id_16,
  n0_.comment_status AS comment_status_17,
  n0_.status AS status_18,
  n0_.youtube_url AS youtube_url_19,
  n0_.youtube_url_second AS youtube_url_second_20,
  n0_.disclaimer AS disclaimer_21,
  n0_.fact_box AS fact_box_22,
  n0_.fact_box_size AS fact_box_size_23,
  n0_.fact_box_placement AS fact_box_placement_24,
  n0_.updated_at AS updated_at_25,
  n0_.last_update_key AS last_update_key_26,
  n0_.category_id AS category_id_27,
  n0_.language_id AS language_id_28,
  n0_.reporter_id AS reporter_id_29,
  n0_.author_id AS author_id_30
FROM
  news n0_
  INNER JOIN image_store i1_ ON n0_.id = i1_.news_id
WHERE
  n0_.language_id = ?
  AND n0_.status = ?
  AND n0_.category_id = ?
ORDER BY
  n0_.publish_date DESC
LIMIT
  2

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.content AS content_3, n0_.publish_date AS publish_date_4, n0_.featured AS featured_5, n0_.meta_title AS meta_title_6, n0_.meta_keywords AS meta_keywords_7, n0_.meta_description AS meta_description_8, n0_.created_on AS created_on_9, n0_.file_data AS file_data_10, n0_.file_name AS file_name_11, n0_.file_type AS file_type_12, n0_.trending AS trending_13, n0_.is_breaking AS is_breaking_14, n0_.old_id AS old_id_15, n0_.news_id AS news_id_16, n0_.comment_status AS comment_status_17, n0_.status AS status_18, n0_.youtube_url AS youtube_url_19, n0_.youtube_url_second AS youtube_url_second_20, n0_.disclaimer AS disclaimer_21, n0_.fact_box AS fact_box_22, n0_.fact_box_size AS fact_box_size_23, n0_.fact_box_placement AS fact_box_placement_24, n0_.updated_at AS updated_at_25, n0_.last_update_key AS last_update_key_26, n0_.category_id AS category_id_27, n0_.language_id AS language_id_28, n0_.reporter_id AS reporter_id_29, n0_.author_id AS author_id_30 FROM news n0_ INNER JOIN image_store i1_ ON n0_.id = i1_.news_id WHERE n0_.language_id = 1 AND n0_.status = 'a' AND n0_.category_id = 1045 ORDER BY n0_.publish_date DESC LIMIT 2;

#	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 375)
7	App\Service\LayoutService->getDataForMegaPage (line 95)
8	App\Service\LayoutService->buildLayoutInfoAndData (line 40)
9	App\Service\LayoutService->getLayoutInfoAndData (line 53)
10	App\Controller\HomeController->App\Controller\{closure} (line 48)
11	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 111)
12	Symfony\Component\Cache\LockRegistry::compute (line 102)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
14	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 85)
15	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
16	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 53)
17	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 49)
18	App\Controller\HomeController->langHome (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

2.10 ms
(0.52%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.slug AS slug_4, t0.sorting_rank AS sorting_rank_5, t0.language_id AS language_id_6, t0.parent_id AS parent_id_7 FROM category t0 WHERE t0.id = ? LIMIT 1

Parameters:

[
  1045
]

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.slug AS slug_4,
  t0.sorting_rank AS sorting_rank_5,
  t0.language_id AS language_id_6,
  t0.parent_id AS parent_id_7
FROM
  category t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.slug AS slug_4, t0.sorting_rank AS sorting_rank_5, t0.language_id AS language_id_6, t0.parent_id AS parent_id_7 FROM category t0 WHERE t0.id = 1045 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 358)
5	App\Service\LayoutService->getDataForMegaPage (line 95)
6	App\Service\LayoutService->buildLayoutInfoAndData (line 40)
7	App\Service\LayoutService->getLayoutInfoAndData (line 53)
8	App\Controller\HomeController->App\Controller\{closure} (line 48)
9	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 111)
10	Symfony\Component\Cache\LockRegistry::compute (line 102)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 85)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
14	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 53)
15	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 49)
16	App\Controller\HomeController->langHome (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

1.59 ms
(0.39%)

SELECT COUNT(a.id)
             FROM advertisement a
             WHERE a.location = ?
               AND a.status = ?
               AND a.start_date <= ?
               AND a.end_date >= ?

Parameters:

[
  "sidebar"
  "active"
  "2026-03-22"
  "2026-03-22"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(a.id)
FROM
  advertisement a
WHERE
  a.location = ?
  AND a.status = ?
  AND a.start_date <= ?
  AND a.end_date >= ?

SELECT COUNT(a.id)
             FROM advertisement a
             WHERE a.location = 'sidebar'
               AND a.status = 'active'
               AND a.start_date <= '2026-03-22'
               AND a.end_date >= '2026-03-22';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 622)
2	Doctrine\DBAL\Connection->fetchOne (line 32)
3	App\Repository\AdvertisementRepository->findRandomActiveForLocation (line 347)
4	App\Controller\BaseController->getAds (line 166)
5	App\Controller\HomeController->App\Controller\{closure} (line 48)
6	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 111)
7	Symfony\Component\Cache\LockRegistry::compute (line 102)
8	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
9	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 85)
10	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 53)
12	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 162)
13	App\Controller\HomeController->langHome (line 181)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	require_once (line 5)

1.48 ms
(0.36%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.config AS config_3, t0.language_id AS language_id_4 FROM home_page_config t0 WHERE t0.language_id = ? AND t0.name = ? LIMIT 1

Parameters:

[
  1
  "mega-page"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.config AS config_3,
  t0.language_id AS language_id_4
FROM
  home_page_config t0
WHERE
  t0.language_id = ?
  AND t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.config AS config_3, t0.language_id AS language_id_4 FROM home_page_config t0 WHERE t0.language_id = 1 AND t0.name = 'mega-page' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 316)
5	App\Service\LayoutService->getDataForMegaPage (line 95)
6	App\Service\LayoutService->buildLayoutInfoAndData (line 40)
7	App\Service\LayoutService->getLayoutInfoAndData (line 53)
8	App\Controller\HomeController->App\Controller\{closure} (line 48)
9	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 111)
10	Symfony\Component\Cache\LockRegistry::compute (line 102)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 85)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
14	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 53)
15	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 49)
16	App\Controller\HomeController->langHome (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

1.10 ms
(0.27%)

SELECT y0_.id AS id_0, y0_.title AS title_1, y0_.description AS description_2, y0_.url AS url_3 FROM yt_gallery y0_ ORDER BY y0_.id DESC LIMIT 5

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  y0_.id AS id_0,
  y0_.title AS title_1,
  y0_.description AS description_2,
  y0_.url AS url_3
FROM
  yt_gallery y0_
ORDER BY
  y0_.id DESC
LIMIT
  5

SELECT y0_.id AS id_0, y0_.title AS title_1, y0_.description AS description_2, y0_.url AS url_3 FROM yt_gallery y0_ ORDER BY y0_.id DESC LIMIT 5;

#	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 158)
7	App\Controller\HomeController->App\Controller\{closure} (line 48)
8	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 111)
9	Symfony\Component\Cache\LockRegistry::compute (line 102)
10	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 85)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 53)
14	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 149)
15	App\Controller\HomeController->langHome (line 181)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

0.94 ms
(0.23%)

SELECT t0.id AS id_1, t0.caption AS caption_2, t0.filepath AS filepath_3, t0.created_at AS created_at_4, t0.guid AS guid_5, t0.gallery_id AS gallery_id_6 FROM photo_gallery_item t0 WHERE t0.gallery_id = ? ORDER BY t0.created_at DESC, t0.id DESC LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.caption AS caption_2,
  t0.filepath AS filepath_3,
  t0.created_at AS created_at_4,
  t0.guid AS guid_5,
  t0.gallery_id AS gallery_id_6
FROM
  photo_gallery_item t0
WHERE
  t0.gallery_id = ?
ORDER BY
  t0.created_at DESC,
  t0.id DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.caption AS caption_2, t0.filepath AS filepath_3, t0.created_at AS created_at_4, t0.guid AS guid_5, t0.gallery_id AS gallery_id_6 FROM photo_gallery_item t0 WHERE t0.gallery_id = 1 ORDER BY t0.created_at DESC, t0.id DESC LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 142)
5	App\Twig\Runtime\AppExtensionRuntime->App\Twig\Runtime\{closure} (line 64)
6	App\Twig\Runtime\AppExtensionRuntime->App\Twig\Runtime\{closure} (line 48)
7	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 111)
8	Symfony\Component\Cache\LockRegistry::compute (line 102)
9	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
10	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 85)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 53)
13	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
14	App\Twig\Runtime\AppExtensionRuntime->remember (line 136)
15	App\Twig\Runtime\AppExtensionRuntime->getPhotoGalleryWidget (line 644)
16	__TwigTemplate_625e7186933bf9de519aa58a869c4265->block_body (line 431)
17	Twig\Template->yieldBlock (line 184)
18	__TwigTemplate_8c94056c31618e6557de2a053a15a5ec->doDisplay (line 387)
19	Twig\Template->yield (line 55)
20	__TwigTemplate_625e7186933bf9de519aa58a869c4265->doDisplay (line 387)
21	Twig\Template->yield (line 343)
22	Twig\Template->display (line 358)
23	Twig\Template->render (line 51)
24	Twig\TemplateWrapper->render (line 320)
25	Twig\Environment->render (line 448)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 232)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 191)
28	App\Controller\HomeController->langHome (line 181)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 5)

0.85 ms
(0.21%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.type AS type_4, t0.options AS options_5, t0.dev AS dev_6 FROM setting t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.type AS type_4,
  t0.options AS options_5,
  t0.dev AS dev_6
FROM
  setting t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.type AS type_4, t0.options AS options_5, t0.dev AS dev_6 FROM setting t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 56)
6	App\Service\SettingProvider->loadFromDatabase (line 25)
7	App\Service\SettingProvider->getSetting (line 39)
8	App\Service\SettingProvider->getSettingOneByName (line 46)
9	App\Controller\HomeController->langHome (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.74 ms
(0.18%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.active AS active_2, c0_.slug AS slug_3, c0_.sorting_rank AS sorting_rank_4, c1_.id AS id_5, c1_.name AS name_6, c1_.active AS active_7, c1_.slug AS slug_8, c1_.sorting_rank AS sorting_rank_9, c0_.language_id AS language_id_10, c0_.parent_id AS parent_id_11, c1_.language_id AS language_id_12, c1_.parent_id AS parent_id_13 FROM category c0_ LEFT JOIN category c1_ ON c0_.id = c1_.parent_id AND (c1_.active = 1) WHERE c0_.language_id = ? AND c0_.parent_id IS NULL AND c0_.active = 1 ORDER BY c0_.sorting_rank ASC, c1_.sorting_rank ASC, c1_.name ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.active AS active_2,
  c0_.slug AS slug_3,
  c0_.sorting_rank AS sorting_rank_4,
  c1_.id AS id_5,
  c1_.name AS name_6,
  c1_.active AS active_7,
  c1_.slug AS slug_8,
  c1_.sorting_rank AS sorting_rank_9,
  c0_.language_id AS language_id_10,
  c0_.parent_id AS parent_id_11,
  c1_.language_id AS language_id_12,
  c1_.parent_id AS parent_id_13
FROM
  category c0_
  LEFT JOIN category c1_ ON c0_.id = c1_.parent_id
  AND (c1_.active = 1)
WHERE
  c0_.language_id = ?
  AND c0_.parent_id IS NULL
  AND c0_.active = 1
ORDER BY
  c0_.sorting_rank ASC,
  c1_.sorting_rank ASC,
  c1_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.active AS active_2, c0_.slug AS slug_3, c0_.sorting_rank AS sorting_rank_4, c1_.id AS id_5, c1_.name AS name_6, c1_.active AS active_7, c1_.slug AS slug_8, c1_.sorting_rank AS sorting_rank_9, c0_.language_id AS language_id_10, c0_.parent_id AS parent_id_11, c1_.language_id AS language_id_12, c1_.parent_id AS parent_id_13 FROM category c0_ LEFT JOIN category c1_ ON c0_.id = c1_.parent_id AND (c1_.active = 1) WHERE c0_.language_id = 1 AND c0_.parent_id IS NULL AND c0_.active = 1 ORDER BY c0_.sorting_rank ASC, c1_.sorting_rank ASC, c1_.name 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 351)
7	App\Controller\WebsiteController->header (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
10	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
11	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
12	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
13	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
14	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 176)
15	__TwigTemplate_8c94056c31618e6557de2a053a15a5ec->doDisplay (line 387)
16	Twig\Template->yield (line 55)
17	__TwigTemplate_625e7186933bf9de519aa58a869c4265->doDisplay (line 387)
18	Twig\Template->yield (line 343)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 51)
21	Twig\TemplateWrapper->render (line 320)
22	Twig\Environment->render (line 448)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 232)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 191)
25	App\Controller\HomeController->langHome (line 181)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

0.60 ms
(0.15%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.sorting_order AS sorting_order_3, t0.is_home AS is_home_4, t0.created_at AS created_at_5, t0.guid AS guid_6 FROM photo_gallery t0 WHERE t0.is_home = ? LIMIT 1

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.sorting_order AS sorting_order_3,
  t0.is_home AS is_home_4,
  t0.created_at AS created_at_5,
  t0.guid AS guid_6
FROM
  photo_gallery t0
WHERE
  t0.is_home = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.sorting_order AS sorting_order_3, t0.is_home AS is_home_4, t0.created_at AS created_at_5, t0.guid AS guid_6 FROM photo_gallery t0 WHERE t0.is_home = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 137)
5	App\Twig\Runtime\AppExtensionRuntime->App\Twig\Runtime\{closure} (line 64)
6	App\Twig\Runtime\AppExtensionRuntime->App\Twig\Runtime\{closure} (line 48)
7	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 111)
8	Symfony\Component\Cache\LockRegistry::compute (line 102)
9	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
10	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 85)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 53)
13	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
14	App\Twig\Runtime\AppExtensionRuntime->remember (line 136)
15	App\Twig\Runtime\AppExtensionRuntime->getPhotoGalleryWidget (line 644)
16	__TwigTemplate_625e7186933bf9de519aa58a869c4265->block_body (line 431)
17	Twig\Template->yieldBlock (line 184)
18	__TwigTemplate_8c94056c31618e6557de2a053a15a5ec->doDisplay (line 387)
19	Twig\Template->yield (line 55)
20	__TwigTemplate_625e7186933bf9de519aa58a869c4265->doDisplay (line 387)
21	Twig\Template->yield (line 343)
22	Twig\Template->display (line 358)
23	Twig\Template->render (line 51)
24	Twig\TemplateWrapper->render (line 320)
25	Twig\Environment->render (line 448)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 232)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 191)
28	App\Controller\HomeController->langHome (line 181)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 5)

0.42 ms
(0.10%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.active AS active_2, c0_.slug AS slug_3, c0_.sorting_rank AS sorting_rank_4, c0_.language_id AS language_id_5, c0_.parent_id AS parent_id_6 FROM category c0_ WHERE c0_.language_id = ? ORDER BY c0_.id DESC LIMIT 5

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.active AS active_2,
  c0_.slug AS slug_3,
  c0_.sorting_rank AS sorting_rank_4,
  c0_.language_id AS language_id_5,
  c0_.parent_id AS parent_id_6
FROM
  category c0_
WHERE
  c0_.language_id = ?
ORDER BY
  c0_.id DESC
LIMIT
  5

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.active AS active_2, c0_.slug AS slug_3, c0_.sorting_rank AS sorting_rank_4, c0_.language_id AS language_id_5, c0_.parent_id AS parent_id_6 FROM category c0_ WHERE c0_.language_id = 1 ORDER BY c0_.id DESC LIMIT 5;

#	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 85)
7	App\Controller\HomeController->App\Controller\{closure} (line 48)
8	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 111)
9	Symfony\Component\Cache\LockRegistry::compute (line 102)
10	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 85)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 53)
14	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 74)
15	App\Controller\HomeController->langHome (line 181)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

0.35 ms
(0.09%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.slug AS slug_4, t0.sorting_rank AS sorting_rank_5, t0.language_id AS language_id_6, t0.parent_id AS parent_id_7 FROM category t0 WHERE t0.id = ?

Parameters:

[
  1042
]

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.slug AS slug_4,
  t0.sorting_rank AS sorting_rank_5,
  t0.language_id AS language_id_6,
  t0.parent_id AS parent_id_7
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.slug AS slug_4, t0.sorting_rank AS sorting_rank_5, t0.language_id AS language_id_6, t0.parent_id AS parent_id_7 FROM category t0 WHERE t0.id = 1042;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Category::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\Category->__get (line 70)
8	App\Entity\Category->getName (line 223)
9	App\Controller\HomeController->resolveHomeColumnLabel (line 185)
10	App\Controller\HomeController->langHome (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.33 ms
(0.08%)

SELECT a.id, a.location, a.banner_size, a.url
             FROM advertisement a
             WHERE a.location = ?
               AND a.status = ?
               AND a.start_date <= ?
               AND a.end_date >= ?
             ORDER BY a.id ASC
             LIMIT 1 OFFSET ?

Parameters:

[
  "sidebar"
  "active"
  "2026-03-22"
  "2026-03-22"
  0
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a.id,
  a.location,
  a.banner_size,
  a.url
FROM
  advertisement a
WHERE
  a.location = ?
  AND a.status = ?
  AND a.start_date <= ?
  AND a.end_date >= ?
ORDER BY
  a.id ASC
LIMIT
  1
OFFSET
  ?

SELECT a.id, a.location, a.banner_size, a.url
             FROM advertisement a
             WHERE a.location = 'sidebar'
               AND a.status = 'active'
               AND a.start_date <= '2026-03-22'
               AND a.end_date >= '2026-03-22'
             ORDER BY a.id ASC
             LIMIT 1 OFFSET 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 588)
2	Doctrine\DBAL\Connection->fetchAssociative (line 48)
3	App\Repository\AdvertisementRepository->findRandomActiveForLocation (line 347)
4	App\Controller\BaseController->getAds (line 166)
5	App\Controller\HomeController->App\Controller\{closure} (line 48)
6	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 111)
7	Symfony\Component\Cache\LockRegistry::compute (line 102)
8	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
9	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 85)
10	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 53)
12	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 162)
13	App\Controller\HomeController->langHome (line 181)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	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\Language	No errors.
App\Entity\Category	No errors.
App\Entity\News	No errors.
App\Entity\BrandingImage	No errors.
App\Entity\Setting	No errors.
App\Entity\HomePageConfig	No errors.
App\Entity\ImageStore	No errors.
App\Entity\Reporter	No errors.
App\Entity\Author	No errors.
App\Entity\Comment	No errors.
App\Entity\ImageNewsMapper	No errors.
App\Entity\AdditionalImage	No errors.
App\Entity\NewsStat	No errors.
App\Entity\YtGallery	No errors.
App\Entity\Advertisement	No errors.
App\Entity\ReporterDocs	No errors.
App\Entity\User	No errors.
App\Entity\PhotoGallery	No errors.
App\Entity\PhotoGalleryItem	No errors.
App\Entity\HitCounter	No errors.

Symfony Profiler

GET http://www.nazranatimes.com/pa

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping