Symfony Profiler

Query Metrics

5 Database Queries

4 Different statements

3.31 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.24 ms
(37.54%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.icon AS icon_4 FROM classified_category 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.description AS description_3,
  t0.icon AS icon_4
FROM
  classified_category t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.icon AS icon_4 FROM classified_category 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 29)
6	App\Controller\PublicClassifiedController->classifiedAds (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.89 ms
(27.04%)

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.description AS description_2, c0_.full_description AS full_description_3, c0_.start_time AS start_time_4, c0_.end_time AS end_time_5, c0_.classified_category_id AS classified_category_id_6 FROM classified c0_ WHERE c0_.start_time <= ? AND c0_.end_time >= ? AND c0_.classified_category_id = ? ORDER BY c0_.id DESC

Parameters:

[
  "2026-03-24 19:19:35"
  "2026-03-24 19:19:35"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.description AS description_2,
  c0_.full_description AS full_description_3,
  c0_.start_time AS start_time_4,
  c0_.end_time AS end_time_5,
  c0_.classified_category_id AS classified_category_id_6
FROM
  classified c0_
WHERE
  c0_.start_time <= ?
  AND c0_.end_time >= ?
  AND c0_.classified_category_id = ?
ORDER BY
  c0_.id DESC

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.description AS description_2, c0_.full_description AS full_description_3, c0_.start_time AS start_time_4, c0_.end_time AS end_time_5, c0_.classified_category_id AS classified_category_id_6 FROM classified c0_ WHERE c0_.start_time <= '2026-03-24 19:19:35' AND c0_.end_time >= '2026-03-24 19:19:35' AND c0_.classified_category_id = 1 ORDER BY c0_.id DESC;

#	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 48)
7	App\Controller\PublicClassifiedController->classifiedAds (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.59 ms
(17.88%)

SELECT c0_.name AS name_0, c0_.value AS value_1 FROM color_theme c0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.name AS name_0,
  c0_.value AS value_1
FROM
  color_theme c0_

SELECT c0_.name AS name_0, c0_.value AS value_1 FROM color_theme c0_;

#	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 701)
6	Doctrine\ORM\AbstractQuery->getArrayResult (line 629)
7	App\Twig\Runtime\AppExtensionRuntime->App\Twig\Runtime\{closure} (line 64)
8	App\Twig\Runtime\AppExtensionRuntime->App\Twig\Runtime\{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 62)
16	App\Twig\Runtime\AppExtensionRuntime->remember (line 625)
17	App\Twig\Runtime\AppExtensionRuntime->getColorSetting (line 50)
18	__TwigTemplate_2bb7266d334b5e2ec4c31b72d18db47c->doDisplay (line 387)
19	Twig\Template->yield (line 343)
20	Twig\Template->display (line 358)
21	Twig\Template->render (line 51)
22	Twig\TemplateWrapper->render (line 320)
23	Twig\Environment->render (line 448)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 368)
27	App\Controller\WebsiteController->headerForClassified (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
30	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
31	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
32	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
33	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
34	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 176)
35	__TwigTemplate_5bc6e740c50a45949211ba0782011104->doDisplay (line 387)
36	Twig\Template->yield (line 54)
37	__TwigTemplate_eae83f379aae21e1f7c76a516add4fe6->doDisplay (line 387)
38	Twig\Template->yield (line 343)
39	Twig\Template->display (line 358)
40	Twig\Template->render (line 51)
41	Twig\TemplateWrapper->render (line 320)
42	Twig\Environment->render (line 448)
43	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
44	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
45	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 50)
46	App\Controller\PublicClassifiedController->classifiedAds (line 181)
47	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
48	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
49	Symfony\Component\HttpKernel\Kernel->handle (line 35)
50	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
51	require_once (line 5)

0.58 ms
(17.55%)

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

Parameters:

[
  "mega_footer"
  "active"
  "2026-03-24"
  "2026-03-24"
]

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 = 'mega_footer'
               AND a.status = 'active'
               AND a.start_date <= '2026-03-24'
               AND a.end_date >= '2026-03-24';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 622)
2	Doctrine\DBAL\Connection->fetchOne (line 32)
3	App\Repository\AdvertisementRepository->findRandomActiveForLocation (line 602)
4	App\Twig\Runtime\AppExtensionRuntime->getAds (line 192)
5	__TwigTemplate_5bc6e740c50a45949211ba0782011104->doDisplay (line 387)
6	Twig\Template->yield (line 54)
7	__TwigTemplate_eae83f379aae21e1f7c76a516add4fe6->doDisplay (line 387)
8	Twig\Template->yield (line 343)
9	Twig\Template->display (line 358)
10	Twig\Template->render (line 51)
11	Twig\TemplateWrapper->render (line 320)
12	Twig\Environment->render (line 448)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 50)
16	App\Controller\PublicClassifiedController->classifiedAds (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)

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\ClassifiedCategory	No errors.
App\Entity\Classified	No errors.
App\Entity\ColorTheme	No errors.
App\Entity\Advertisement	No errors.

Symfony Profiler

GET http://nazranatimes.com/public/classified/ads?category=1

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping