Symfony Profiler

Query Metrics

11 Database Queries

5 Different statements

14.12 ms Query time

0 Invalid entities

181 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

12.08 ms
(85.53%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.attachment_path AS attachment_path_5, t0.is_pinned AS is_pinned_6, t0.is_locked AS is_locked_7, t0.status AS status_8, t0.view_count AS view_count_9, t0.reply_count AS reply_count_10, t0.last_reply_at AS last_reply_at_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.category_id AS category_id_14, t0.user_id AS user_id_15 FROM forum_topic t0 WHERE t0.category_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.content AS content_4,
  t0.attachment_path AS attachment_path_5,
  t0.is_pinned AS is_pinned_6,
  t0.is_locked AS is_locked_7,
  t0.status AS status_8,
  t0.view_count AS view_count_9,
  t0.reply_count AS reply_count_10,
  t0.last_reply_at AS last_reply_at_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.category_id AS category_id_14,
  t0.user_id AS user_id_15
FROM
  forum_topic t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.attachment_path AS attachment_path_5, t0.is_pinned AS is_pinned_6, t0.is_locked AS is_locked_7, t0.status AS status_8, t0.view_count AS view_count_9, t0.reply_count AS reply_count_10, t0.last_reply_at AS last_reply_at_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.category_id AS category_id_14, t0.user_id AS user_id_15 FROM forum_topic t0 WHERE t0.category_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->length (line 1278)
9	__TwigTemplate_e439e892982772d83a566e20447f9184::block_body (line 147)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_4b91e7862eacca308ae84b7f29bacf98->doDisplay (line 832)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_e439e892982772d83a566e20447f9184->doDisplay (line 54)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
22	App\Controller\ForumController->index (line 26)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

1.31 ms
(9.25%)

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.position AS position_2, b0_.image_path AS image_path_3, b0_.link_url AS link_url_4, b0_.start_date AS start_date_5, b0_.end_date AS end_date_6, b0_.is_active AS is_active_7, b0_.click_count AS click_count_8, b0_.view_count AS view_count_9, b0_.sort_order AS sort_order_10, b0_.created_at AS created_at_11 FROM banner b0_ WHERE b0_.is_active = 1 AND ((b0_.start_date IS NULL OR b0_.start_date <= ?)) AND ((b0_.end_date IS NULL OR b0_.end_date >= ?)) AND b0_.position = ? ORDER BY b0_.sort_order ASC

Parameters:

[
  1780477058
  1780477058
  "header"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.position AS position_2,
  b0_.image_path AS image_path_3,
  b0_.link_url AS link_url_4,
  b0_.start_date AS start_date_5,
  b0_.end_date AS end_date_6,
  b0_.is_active AS is_active_7,
  b0_.click_count AS click_count_8,
  b0_.view_count AS view_count_9,
  b0_.sort_order AS sort_order_10,
  b0_.created_at AS created_at_11
FROM
  banner b0_
WHERE
  b0_.is_active = 1
  AND (
    (
      b0_.start_date IS NULL
      OR b0_.start_date <= ?
    )
  )
  AND (
    (
      b0_.end_date IS NULL
      OR b0_.end_date >= ?
    )
  )
  AND b0_.position = ?
ORDER BY
  b0_.sort_order ASC

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.position AS position_2, b0_.image_path AS image_path_3, b0_.link_url AS link_url_4, b0_.start_date AS start_date_5, b0_.end_date AS end_date_6, b0_.is_active AS is_active_7, b0_.click_count AS click_count_8, b0_.view_count AS view_count_9, b0_.sort_order AS sort_order_10, b0_.created_at AS created_at_11 FROM banner b0_ WHERE b0_.is_active = 1 AND ((b0_.start_date IS NULL OR b0_.start_date <= 1780477058)) AND ((b0_.end_date IS NULL OR b0_.end_date >= 1780477058)) AND b0_.position = 'header' ORDER BY b0_.sort_order ASC;

#	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	App\Repository\BannerRepository->findActiveBanners (line 34)
7	App\Twig\BannerExtension->getBannersByPosition (line 35)
8	__TwigTemplate_6be6bcd2514a3e3eaca0fde70ca983c8->doDisplay (line 48)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_4b91e7862eacca308ae84b7f29bacf98->doDisplay (line 468)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_e439e892982772d83a566e20447f9184->doDisplay (line 54)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
21	App\Controller\ForumController->index (line 26)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 193)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 32)
27	require_once (line 5)

0.26 ms
(1.84%)

SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.slug AS slug_2, f0_.description AS description_3, f0_.sort_order AS sort_order_4, f0_.is_active AS is_active_5 FROM forum_category f0_ WHERE f0_.is_active = 1 ORDER BY f0_.sort_order ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.name AS name_1,
  f0_.slug AS slug_2,
  f0_.description AS description_3,
  f0_.sort_order AS sort_order_4,
  f0_.is_active AS is_active_5
FROM
  forum_category f0_
WHERE
  f0_.is_active = 1
ORDER BY
  f0_.sort_order ASC

SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.slug AS slug_2, f0_.description AS description_3, f0_.sort_order AS sort_order_4, f0_.is_active AS is_active_5 FROM forum_category f0_ WHERE f0_.is_active = 1 ORDER BY f0_.sort_order ASC;

#	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	App\Repository\ForumCategoryRepository->findActiveCategories (line 26)
7	App\Controller\ForumController->index (line 24)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.24 ms
(1.72%)

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.created_at AS created_at_3, s0_.updated_at AS updated_at_4 FROM service s0_ ORDER BY s0_.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.slug AS slug_2,
  s0_.created_at AS created_at_3,
  s0_.updated_at AS updated_at_4
FROM
  service s0_
ORDER BY
  s0_.name ASC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.created_at AS created_at_3, s0_.updated_at AS updated_at_4 FROM service s0_ ORDER BY s0_.name ASC;

#	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	App\Repository\ServiceRepository->findAllOrdered (line 34)
7	App\Twig\AppExtension->getGlobals (line 39)
8	Twig\ExtensionSet->getGlobals (line 365)
9	Twig\Environment->getGlobals (line 908)
10	Twig\Template->yield (line 398)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
18	App\Controller\ForumController->index (line 26)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 193)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 32)
24	require_once (line 5)

0.23 ms
(1.66%)

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.created_at AS created_at_3, a0_.updated_at AS updated_at_4 FROM area a0_ ORDER BY a0_.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.slug AS slug_2,
  a0_.created_at AS created_at_3,
  a0_.updated_at AS updated_at_4
FROM
  area a0_
ORDER BY
  a0_.name ASC

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.created_at AS created_at_3, a0_.updated_at AS updated_at_4 FROM area a0_ ORDER BY a0_.name ASC;

#	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	App\Repository\AreaRepository->findAllOrdered (line 37)
7	App\Twig\AppExtension->getGlobals (line 38)
8	Twig\ExtensionSet->getGlobals (line 365)
9	Twig\Environment->getGlobals (line 908)
10	Twig\Template->yield (line 398)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
18	App\Controller\ForumController->index (line 26)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 193)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 32)
24	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Area	76
App\Entity\ForumTopic	68
App\Entity\User	27
App\Entity\ForumCategory	6
App\Entity\Service	4

Entities Mapping

Class	Mapping errors
App\Entity\ForumCategory	No errors.
App\Entity\ForumTopic	No errors.
App\Entity\Area	No errors.
App\Entity\ProfileArea	No errors.
App\Entity\Service	No errors.
App\Entity\ProfileService	No errors.
App\Entity\Banner	No errors.
App\Entity\User	No errors.
App\Entity\ForumReply	No errors.

Symfony Profiler

GET https://beta.pretoriaescorts.co.za/forum

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping