Symfony Profiler

Query Metrics

11 Database Queries

7 Different statements

24.75 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

14.96 ms
(60.44%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1423)
2	Doctrine\DBAL\Connection->commit (line 429)
3	Doctrine\ORM\UnitOfWork->commit (line 259)
4	Doctrine\ORM\EntityManager->flush (line 27)
5	App\Service\HwLoggerService->writeLog (line 28)
6	App\Controller\LnaController->index (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

4.65 ms
(18.78%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.visible AS visible_3, t0.parent_id AS parent_id_4, t0.sort_index AS sort_index_5, t0.type AS type_6, t0.content_id AS content_id_7, t0.lang AS lang_8, t0.external_url AS external_url_9 FROM menu t0 WHERE t0.lang = ? AND t0.parent_id = ? AND t0.visible = ? ORDER BY t0.sort_index ASC

Parameters:

[
  "en"
  0
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.visible AS visible_3,
  t0.parent_id AS parent_id_4,
  t0.sort_index AS sort_index_5,
  t0.type AS type_6,
  t0.content_id AS content_id_7,
  t0.lang AS lang_8,
  t0.external_url AS external_url_9
FROM
  menu t0
WHERE
  t0.lang = ?
  AND t0.parent_id = ?
  AND t0.visible = ?
ORDER BY
  t0.sort_index ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.visible AS visible_3, t0.parent_id AS parent_id_4, t0.sort_index AS sort_index_5, t0.type AS type_6, t0.content_id AS content_id_7, t0.lang AS lang_8, t0.external_url AS external_url_9 FROM menu t0 WHERE t0.lang = 'en' AND t0.parent_id = 0 AND t0.visible = 1 ORDER BY t0.sort_index ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 933)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 32)
5	App\Controller\LnaController->index (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

2.09 ms
(8.44%)

INSERT INTO hw_log (request_time, request_body, response_time, response_body, url) VALUES (?, ?, ?, ?, ?)

Parameters:

[
  "2025-12-06 05:45:55"
  "Testing testing"
  "2025-12-06 05:45:55"
  "Reponseee"
  "app_lna"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO hw_log (
  request_time, request_body, response_time,
  response_body, url
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO hw_log (request_time, request_body, response_time, response_body, url) VALUES ('2025-12-06 05:45:55', 'Testing testing', '2025-12-06 05:45:55', 'Reponseee', 'app_lna');

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 249)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1048)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 399)
5	Doctrine\ORM\UnitOfWork->commit (line 259)
6	Doctrine\ORM\EntityManager->flush (line 27)
7	App\Service\HwLoggerService->writeLog (line 28)
8	App\Controller\LnaController->index (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.97 ms
(3.91%)

SELECT t0.id AS id_1, t0.active_date_from AS active_date_from_2, t0.active_date_till AS active_date_till_3, t0.message AS message_4, t0.addresses AS addresses_5, t0.lang AS lang_6 FROM service_outage t0 WHERE t0.lang = ? ORDER BY t0.active_date_from DESC LIMIT 5

Parameters:

[
  "en"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.active_date_from AS active_date_from_2,
  t0.active_date_till AS active_date_till_3,
  t0.message AS message_4,
  t0.addresses AS addresses_5,
  t0.lang AS lang_6
FROM
  service_outage t0
WHERE
  t0.lang = ?
ORDER BY
  t0.active_date_from DESC
LIMIT
  5

SELECT t0.id AS id_1, t0.active_date_from AS active_date_from_2, t0.active_date_till AS active_date_till_3, t0.message AS message_4, t0.addresses AS addresses_5, t0.lang AS lang_6 FROM service_outage t0 WHERE t0.lang = 'en' ORDER BY t0.active_date_from DESC LIMIT 5;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 933)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 72)
5	App\Controller\LnaController->index (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.81 ms
(3.29%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.created AS created_3, t0.modified AS modified_4, t0.lang AS lang_5, t0.status AS status_6, t0.title_image AS title_image_7, t0.intro AS intro_8, t0.body AS body_9, t0.title_image_aria_label AS title_image_aria_label_10, t0.title_image_alt_tag AS title_image_alt_tag_11 FROM news t0 WHERE t0.lang = ? AND t0.status = ? ORDER BY t0.modified DESC LIMIT 4

Parameters:

[
  "en"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.created AS created_3,
  t0.modified AS modified_4,
  t0.lang AS lang_5,
  t0.status AS status_6,
  t0.title_image AS title_image_7,
  t0.intro AS intro_8,
  t0.body AS body_9,
  t0.title_image_aria_label AS title_image_aria_label_10,
  t0.title_image_alt_tag AS title_image_alt_tag_11
FROM
  news t0
WHERE
  t0.lang = ?
  AND t0.status = ?
ORDER BY
  t0.modified DESC
LIMIT
  4

SELECT t0.id AS id_1, t0.title AS title_2, t0.created AS created_3, t0.modified AS modified_4, t0.lang AS lang_5, t0.status AS status_6, t0.title_image AS title_image_7, t0.intro AS intro_8, t0.body AS body_9, t0.title_image_aria_label AS title_image_aria_label_10, t0.title_image_alt_tag AS title_image_alt_tag_11 FROM news t0 WHERE t0.lang = 'en' AND t0.status = 1 ORDER BY t0.modified DESC LIMIT 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 933)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 69)
5	App\Controller\LnaController->index (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.70 ms
(2.82%)

SELECT 
            l.*,
            m.content_id
          FROM link l 
          LEFT JOIN menu m ON m.id=l.navigation_id 
          WHERE l.lang='en' 
          ORDER BY l.sort_index ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l.*,
  m.content_id
FROM
  link l
  LEFT JOIN menu m ON m.id = l.navigation_id
WHERE
  l.lang = 'en'
ORDER BY
  l.sort_index ASC

SELECT 
            l.*,
            m.content_id
          FROM link l 
          LEFT JOIN menu m ON m.id=l.navigation_id 
          WHERE l.lang='en' 
          ORDER BY l.sort_index ASC;

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 224)
2	Doctrine\DBAL\Statement->executeQuery (line 83)
3	App\Controller\LnaController->index (line 183)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
6	Symfony\Component\HttpKernel\Kernel->handle (line 35)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
8	require_once (line 5)

0.58 ms
(2.32%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 380)
2	Doctrine\ORM\UnitOfWork->commit (line 259)
3	Doctrine\ORM\EntityManager->flush (line 27)
4	App\Service\HwLoggerService->writeLog (line 28)
5	App\Controller\LnaController->index (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	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\HwLog	No errors.
App\Entity\Menu	No errors.
App\Entity\News	No errors.
App\Entity\ServiceOutage	No errors.

Symfony Profiler

GET https://www-tst.lna.lv/en/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping