Symfony Profiler

Last 10 Latest Search

Method

Status

URL

Token

From

Until

Results

Profiler settings

Query Metrics

9 Database Queries

5 Different statements

2.99 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.47 ms
(49.25%)

SELECT * FROM manufacturing_batch_item
            WHERE id_manufacturing_batch IN (3503,3502,3501,3500,3499,3498,3497,3496,3495,3494,3493,3492,3491,3490,3489,3488,3486,3485,3483,3482,3481,3480,3479,3477,3476,3475,3474,3473,3472)

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  manufacturing_batch_item
WHERE
  id_manufacturing_batch IN (
    3503, 3502, 3501, 3500, 3499, 3498, 3497,
    3496, 3495, 3494, 3493, 3492, 3491,
    3490, 3489, 3488, 3486, 3485, 3483,
    3482, 3481, 3480, 3479, 3477, 3476,
    3475, 3474, 3473, 3472
  )

SELECT * FROM manufacturing_batch_item
            WHERE id_manufacturing_batch IN (3503,3502,3501,3500,3499,3498,3497,3496,3495,3494,3493,3492,3491,3490,3489,3488,3486,3485,3483,3482,3481,3480,3479,3477,3476,3475,3474,3473,3472)
        ;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 600)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 134)
3	App\Data\ManufacturingBatchManager->getBatches (line 37)
4	App\Controller\DairyManufacturingController->indexAction (line 178)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 13)

1.11 ms
(37.23%)

SELECT * FROM manufacturing_batch WHERE date >= '2026-02-24 00:00:00' AND date <= '2026-02-24 23:59:59' AND batch_type = 1
            ORDER BY sent_to_money ASC, id DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  manufacturing_batch
WHERE
  date >= '2026-02-24 00:00:00'
  AND date <= '2026-02-24 23:59:59'
  AND batch_type = 1
ORDER BY
  sent_to_money ASC,
  id DESC

SELECT * FROM manufacturing_batch WHERE date >= '2026-02-24 00:00:00' AND date <= '2026-02-24 23:59:59' AND batch_type = 1
            ORDER BY sent_to_money ASC, id DESC
        ;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 600)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 101)
3	App\Data\ManufacturingBatchManager->getBatches (line 37)
4	App\Controller\DairyManufacturingController->indexAction (line 178)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 13)

0.25 ms
(8.33%)

UPDATE system_session SET last_activity = NOW() WHERE identifier = ?

Parameters:

[
  "018ba8bf1f742a454d46584a8090c387af69e60213d01d1a196f97e23f4c0bd9"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  system_session
SET
  last_activity = NOW()
WHERE
  identifier = ?

UPDATE system_session SET last_activity = NOW() WHERE identifier = '018ba8bf1f742a454d46584a8090c387af69e60213d01d1a196f97e23f4c0bd9';

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 182)
2	App\Session\SessionHandler->updateSession (line 63)
3	App\EventSubscriber\AuthenticationSubscriber->onKernelController (line 116)
4	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
5	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
6	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
7	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 166)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 13)

0.12 ms
(3.98%)

SELECT * FROM system_session WHERE identifier = ?

Parameters:

[
  "018ba8bf1f742a454d46584a8090c387af69e60213d01d1a196f97e23f4c0bd9"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  system_session
WHERE
  identifier = ?

SELECT * FROM system_session WHERE identifier = '018ba8bf1f742a454d46584a8090c387af69e60213d01d1a196f97e23f4c0bd9';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 304)
2	Doctrine\DBAL\Connection->fetchAssociative (line 118)
3	App\Session\SessionHandler->getSessionData (line 84)
4	App\Session\SessionHandler->isLoggedAndValidSession (line 57)
5	App\EventSubscriber\AuthenticationSubscriber->onKernelController (line 116)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 166)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 13)

0.04 ms
(1.21%)

SELECT * FROM system_users

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  system_users

SELECT * FROM system_users;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 600)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 194)
3	App\Data\User->loadUsersIfNeeded (line 39)
4	App\Data\User->get (line 93)
5	App\Session\SessionHandler->isLoggedAndValidSession (line 57)
6	App\EventSubscriber\AuthenticationSubscriber->onKernelController (line 116)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 166)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 13)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

No managed entities.

Entities Mapping

No mapped entities.

Symfony Profiler

GET https://intranet.agrola.cz/dairy-manufacturing

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

Entities Mapping