Symfony Profiler

Query Metrics

9 Database Queries

7 Different statements

110.77 ms Query time

0 Invalid entities

6 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

107.85 ms
(97.37%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->commit (line 1454)
2	Doctrine\ORM\UnitOfWork->commit (line 432)
3	Doctrine\ORM\EntityManager->flush (line 268)
4	App\State\Timings\TimingsProvider->provide (line 47)
5	ApiPlatform\State\CallableProvider->provide (line 43)
6	ApiPlatform\State\Provider\ReadProvider->provide (line 84)
7	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 50)
8	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 62)
9	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 50)
10	ApiPlatform\State\Provider\DeserializeProvider->provide (line 60)
11	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 62)
12	ApiPlatform\Symfony\Validator\State\ValidateProvider->provide (line 32)
13	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 62)
14	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 101)
15	ApiPlatform\State\Provider\ParameterProvider->provide (line 102)
16	ApiPlatform\State\Provider\ContentNegotiationProvider->provide (line 56)
17	ApiPlatform\Symfony\Controller\MainController->__invoke (line 94)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 182)
21	Runtime\FrankenPhpSymfony\Runner->Runtime\FrankenPhpSymfony\{closure} (line 38)
22	frankenphp_handle_request (line 45)
23	Runtime\FrankenPhpSymfony\Runner::run (line 45)
24	require_once (line 29)
25	require_once (line 5)

0.88 ms
(0.80%)

SELECT t0.id AS id_1, t0.type AS type_2, t0.days_of_week AS days_of_week_3, t0.date_from AS date_from_4, t0.date_to AS date_to_5, t0.turn_on_time AS turn_on_time_6, t0.turn_off_time AS turn_off_time_7, t0.is_active AS is_active_8, t0.name AS name_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.terminal_group_id AS terminal_group_id_12 FROM schedules t0 WHERE t0.terminal_group_id = ?

Parameters:

[
  26
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.days_of_week AS days_of_week_3,
  t0.date_from AS date_from_4,
  t0.date_to AS date_to_5,
  t0.turn_on_time AS turn_on_time_6,
  t0.turn_off_time AS turn_off_time_7,
  t0.is_active AS is_active_8,
  t0.name AS name_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.terminal_group_id AS terminal_group_id_12
FROM
  schedules t0
WHERE
  t0.terminal_group_id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.days_of_week AS days_of_week_3, t0.date_from AS date_from_4, t0.date_to AS date_to_5, t0.turn_on_time AS turn_on_time_6, t0.turn_off_time AS turn_off_time_7, t0.is_active AS is_active_8, t0.name AS name_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.terminal_group_id AS terminal_group_id_12 FROM schedules t0 WHERE t0.terminal_group_id = 26;

#	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 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	App\Service\TerminalSchedulePlanningService->resolveSchedulesForGroupOnFlush (line 651)
8	App\Service\TerminalSchedulePlanningService->buildWeeklyPlanOnFlush (line 522)
9	App\Service\TerminalSchedulePlanningService->ensureCurrentVersionOnFlush (line 198)
10	App\EventListener\TerminalScheduleVersionListener->onFlush (line 82)
11	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 56)
12	Doctrine\ORM\UnitOfWork->dispatchOnFlushEvent (line 3146)
13	Doctrine\ORM\UnitOfWork->commit (line 378)
14	Doctrine\ORM\EntityManager->flush (line 268)
15	App\State\Timings\TimingsProvider->provide (line 47)
16	ApiPlatform\State\CallableProvider->provide (line 43)
17	ApiPlatform\State\Provider\ReadProvider->provide (line 84)
18	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 50)
19	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 62)
20	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 50)
21	ApiPlatform\State\Provider\DeserializeProvider->provide (line 60)
22	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 62)
23	ApiPlatform\Symfony\Validator\State\ValidateProvider->provide (line 32)
24	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 62)
25	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 101)
26	ApiPlatform\State\Provider\ParameterProvider->provide (line 102)
27	ApiPlatform\State\Provider\ContentNegotiationProvider->provide (line 56)
28	ApiPlatform\Symfony\Controller\MainController->__invoke (line 94)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 182)
32	Runtime\FrankenPhpSymfony\Runner->Runtime\FrankenPhpSymfony\{closure} (line 38)
33	frankenphp_handle_request (line 45)
34	Runtime\FrankenPhpSymfony\Runner::run (line 45)
35	require_once (line 29)
36	require_once (line 5)

0.67 ms
(0.60%)

SELECT t0.id AS id_1, t0.ulid AS ulid_2, t0.name AS name_3, t0.type AS type_4, t0.last_sync_at AS last_sync_at_5, t0.last_seen AS last_seen_6, t0.description AS description_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.info_center_calls AS info_center_calls_10, t0.security_control_calls AS security_control_calls_11, t0.ip_address AS ip_address_12, t0.offline_alert_latched AS offline_alert_latched_13, t0.location AS location_14, t0.floor AS floor_15, t0.anydesk AS anydesk_16, t0.anydesk_password AS anydesk_password_17, t0.assistant AS assistant_18, t0.assistant_password AS assistant_password_19, t0.os_password AS os_password_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t23.id AS id_24, t23.openweathermap_api_key AS openweathermap_api_key_25, t23.openweathermap_city AS openweathermap_city_26, t23.tomtom_api_key AS tomtom_api_key_27, t23.tomtom_point AS tomtom_point_28, t23.widget_update_interval AS widget_update_interval_29, t23.navigation_timeout AS navigation_timeout_30, t23.zero_bearing AS zero_bearing_31, t23.created_at AS created_at_32, t23.updated_at AS updated_at_33, t23.terminal_id AS terminal_id_34, t23.calibration_video_id AS calibration_video_id_35, t23.fallback_video_id AS fallback_video_id_36 FROM terminals t0 LEFT JOIN fluger_terminal_settings t23 ON t23.terminal_id = t0.id WHERE t0.ulid = ? LIMIT 1

Parameters:

[
  b"\x01™\“Y\x13I—\x0Eß\x1AXŒõæ©"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.ulid AS ulid_2,
  t0.name AS name_3,
  t0.type AS type_4,
  t0.last_sync_at AS last_sync_at_5,
  t0.last_seen AS last_seen_6,
  t0.description AS description_7,
  t0.latitude AS latitude_8,
  t0.longitude AS longitude_9,
  t0.info_center_calls AS info_center_calls_10,
  t0.security_control_calls AS security_control_calls_11,
  t0.ip_address AS ip_address_12,
  t0.offline_alert_latched AS offline_alert_latched_13,
  t0.location AS location_14,
  t0.floor AS floor_15,
  t0.anydesk AS anydesk_16,
  t0.anydesk_password AS anydesk_password_17,
  t0.assistant AS assistant_18,
  t0.assistant_password AS assistant_password_19,
  t0.os_password AS os_password_20,
  t0.created_at AS created_at_21,
  t0.updated_at AS updated_at_22,
  t23.id AS id_24,
  t23.openweathermap_api_key AS openweathermap_api_key_25,
  t23.openweathermap_city AS openweathermap_city_26,
  t23.tomtom_api_key AS tomtom_api_key_27,
  t23.tomtom_point AS tomtom_point_28,
  t23.widget_update_interval AS widget_update_interval_29,
  t23.navigation_timeout AS navigation_timeout_30,
  t23.zero_bearing AS zero_bearing_31,
  t23.created_at AS created_at_32,
  t23.updated_at AS updated_at_33,
  t23.terminal_id AS terminal_id_34,
  t23.calibration_video_id AS calibration_video_id_35,
  t23.fallback_video_id AS fallback_video_id_36
FROM
  terminals t0
  LEFT JOIN fluger_terminal_settings t23 ON t23.terminal_id = t0.id
WHERE
  t0.ulid = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.ulid AS ulid_2, t0.name AS name_3, t0.type AS type_4, t0.last_sync_at AS last_sync_at_5, t0.last_seen AS last_seen_6, t0.description AS description_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.info_center_calls AS info_center_calls_10, t0.security_control_calls AS security_control_calls_11, t0.ip_address AS ip_address_12, t0.offline_alert_latched AS offline_alert_latched_13, t0.location AS location_14, t0.floor AS floor_15, t0.anydesk AS anydesk_16, t0.anydesk_password AS anydesk_password_17, t0.assistant AS assistant_18, t0.assistant_password AS assistant_password_19, t0.os_password AS os_password_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t23.id AS id_24, t23.openweathermap_api_key AS openweathermap_api_key_25, t23.openweathermap_city AS openweathermap_city_26, t23.tomtom_api_key AS tomtom_api_key_27, t23.tomtom_point AS tomtom_point_28, t23.widget_update_interval AS widget_update_interval_29, t23.navigation_timeout AS navigation_timeout_30, t23.zero_bearing AS zero_bearing_31, t23.created_at AS created_at_32, t23.updated_at AS updated_at_33, t23.terminal_id AS terminal_id_34, t23.calibration_video_id AS calibration_video_id_35, t23.fallback_video_id AS fallback_video_id_36 FROM terminals t0 LEFT JOIN fluger_terminal_settings t23 ON t23.terminal_id = t0.id WHERE t0.ulid = 0x01995C93591349970EDF1A588CF5E6A9 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\State\Timings\TimingsProvider->provide (line 41)
5	ApiPlatform\State\CallableProvider->provide (line 43)
6	ApiPlatform\State\Provider\ReadProvider->provide (line 84)
7	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 50)
8	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 62)
9	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 50)
10	ApiPlatform\State\Provider\DeserializeProvider->provide (line 60)
11	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 62)
12	ApiPlatform\Symfony\Validator\State\ValidateProvider->provide (line 32)
13	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 62)
14	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 101)
15	ApiPlatform\State\Provider\ParameterProvider->provide (line 102)
16	ApiPlatform\State\Provider\ContentNegotiationProvider->provide (line 56)
17	ApiPlatform\Symfony\Controller\MainController->__invoke (line 94)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 182)
21	Runtime\FrankenPhpSymfony\Runner->Runtime\FrankenPhpSymfony\{closure} (line 38)
22	frankenphp_handle_request (line 45)
23	Runtime\FrankenPhpSymfony\Runner::run (line 45)
24	require_once (line 29)
25	require_once (line 5)

0.41 ms
(0.37%)

SELECT t0.id AS id_1, t0.valid_from AS valid_from_2, t0.valid_to AS valid_to_3, t0.payload AS payload_4, t0.payload_hash AS payload_hash_5, t0.created_at AS created_at_6, t0.terminal_id AS terminal_id_7 FROM terminal_schedule_versions t0 WHERE t0.terminal_id = ? AND t0.valid_to IS NULL ORDER BY t0.valid_from DESC LIMIT 1

Parameters:

[
  37
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.valid_from AS valid_from_2,
  t0.valid_to AS valid_to_3,
  t0.payload AS payload_4,
  t0.payload_hash AS payload_hash_5,
  t0.created_at AS created_at_6,
  t0.terminal_id AS terminal_id_7
FROM
  terminal_schedule_versions t0
WHERE
  t0.terminal_id = ?
  AND t0.valid_to IS NULL
ORDER BY
  t0.valid_from DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.valid_from AS valid_from_2, t0.valid_to AS valid_to_3, t0.payload AS payload_4, t0.payload_hash AS payload_hash_5, t0.created_at AS created_at_6, t0.terminal_id AS terminal_id_7 FROM terminal_schedule_versions t0 WHERE t0.terminal_id = 37 AND t0.valid_to IS NULL ORDER BY t0.valid_from DESC LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Service\TerminalSchedulePlanningService->ensureCurrentVersionOnFlush (line 205)
5	App\EventListener\TerminalScheduleVersionListener->onFlush (line 82)
6	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 56)
7	Doctrine\ORM\UnitOfWork->dispatchOnFlushEvent (line 3146)
8	Doctrine\ORM\UnitOfWork->commit (line 378)
9	Doctrine\ORM\EntityManager->flush (line 268)
10	App\State\Timings\TimingsProvider->provide (line 47)
11	ApiPlatform\State\CallableProvider->provide (line 43)
12	ApiPlatform\State\Provider\ReadProvider->provide (line 84)
13	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 50)
14	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 62)
15	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 50)
16	ApiPlatform\State\Provider\DeserializeProvider->provide (line 60)
17	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 62)
18	ApiPlatform\Symfony\Validator\State\ValidateProvider->provide (line 32)
19	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 62)
20	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 101)
21	ApiPlatform\State\Provider\ParameterProvider->provide (line 102)
22	ApiPlatform\State\Provider\ContentNegotiationProvider->provide (line 56)
23	ApiPlatform\Symfony\Controller\MainController->__invoke (line 94)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 182)
27	Runtime\FrankenPhpSymfony\Runner->Runtime\FrankenPhpSymfony\{closure} (line 38)
28	frankenphp_handle_request (line 45)
29	Runtime\FrankenPhpSymfony\Runner::run (line 45)
30	require_once (line 29)
31	require_once (line 5)

0.40 ms
(0.36%)

UPDATE terminals SET last_sync_at = ?, updated_at = ? WHERE id = ?

Parameters:

[
  "2026-04-18 13:04:52"
  "2026-04-18 13:04:52"
  37
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  terminals
SET
  last_sync_at = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE terminals SET last_sync_at = '2026-04-18 13:04:52', updated_at = '2026-04-18 13:04:52' WHERE id = 37;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 494)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 378)
3	Doctrine\ORM\UnitOfWork->executeUpdates (line 1139)
4	Doctrine\ORM\UnitOfWork->commit (line 407)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\State\Timings\TimingsProvider->provide (line 47)
7	ApiPlatform\State\CallableProvider->provide (line 43)
8	ApiPlatform\State\Provider\ReadProvider->provide (line 84)
9	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 50)
10	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 62)
11	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 50)
12	ApiPlatform\State\Provider\DeserializeProvider->provide (line 60)
13	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 62)
14	ApiPlatform\Symfony\Validator\State\ValidateProvider->provide (line 32)
15	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 62)
16	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 101)
17	ApiPlatform\State\Provider\ParameterProvider->provide (line 102)
18	ApiPlatform\State\Provider\ContentNegotiationProvider->provide (line 56)
19	ApiPlatform\Symfony\Controller\MainController->__invoke (line 94)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 182)
23	Runtime\FrankenPhpSymfony\Runner->Runtime\FrankenPhpSymfony\{closure} (line 38)
24	frankenphp_handle_request (line 45)
25	Runtime\FrankenPhpSymfony\Runner::run (line 45)
26	require_once (line 29)
27	require_once (line 5)

0.38 ms
(0.35%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM terminal_groups t0 INNER JOIN terminal_group_terminals ON t0.id = terminal_group_terminals.terminal_group_id WHERE terminal_group_terminals.terminal_id = ?

Parameters:

[
  37
]

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.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  terminal_groups t0
  INNER JOIN terminal_group_terminals ON t0.id = terminal_group_terminals.terminal_group_id
WHERE
  terminal_group_terminals.terminal_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM terminal_groups t0 INNER JOIN terminal_group_terminals ON t0.id = terminal_group_terminals.terminal_group_id WHERE terminal_group_terminals.terminal_id = 37;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2726)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	App\Service\TerminalSchedulePlanningService->resolveTerminalGroupsOnFlush (line 592)
8	App\Service\TerminalSchedulePlanningService->buildWeeklyPlanOnFlush (line 516)
9	App\Service\TerminalSchedulePlanningService->ensureCurrentVersionOnFlush (line 198)
10	App\EventListener\TerminalScheduleVersionListener->onFlush (line 82)
11	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 56)
12	Doctrine\ORM\UnitOfWork->dispatchOnFlushEvent (line 3146)
13	Doctrine\ORM\UnitOfWork->commit (line 378)
14	Doctrine\ORM\EntityManager->flush (line 268)
15	App\State\Timings\TimingsProvider->provide (line 47)
16	ApiPlatform\State\CallableProvider->provide (line 43)
17	ApiPlatform\State\Provider\ReadProvider->provide (line 84)
18	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 50)
19	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 62)
20	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 50)
21	ApiPlatform\State\Provider\DeserializeProvider->provide (line 60)
22	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 62)
23	ApiPlatform\Symfony\Validator\State\ValidateProvider->provide (line 32)
24	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 62)
25	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 101)
26	ApiPlatform\State\Provider\ParameterProvider->provide (line 102)
27	ApiPlatform\State\Provider\ContentNegotiationProvider->provide (line 56)
28	ApiPlatform\Symfony\Controller\MainController->__invoke (line 94)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 182)
32	Runtime\FrankenPhpSymfony\Runner->Runtime\FrankenPhpSymfony\{closure} (line 38)
33	frankenphp_handle_request (line 45)
34	Runtime\FrankenPhpSymfony\Runner::run (line 45)
35	require_once (line 29)
36	require_once (line 5)

0.17 ms
(0.16%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 381)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\State\Timings\TimingsProvider->provide (line 47)
4	ApiPlatform\State\CallableProvider->provide (line 43)
5	ApiPlatform\State\Provider\ReadProvider->provide (line 84)
6	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 50)
7	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 62)
8	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 50)
9	ApiPlatform\State\Provider\DeserializeProvider->provide (line 60)
10	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 62)
11	ApiPlatform\Symfony\Validator\State\ValidateProvider->provide (line 32)
12	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 62)
13	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 101)
14	ApiPlatform\State\Provider\ParameterProvider->provide (line 102)
15	ApiPlatform\State\Provider\ContentNegotiationProvider->provide (line 56)
16	ApiPlatform\Symfony\Controller\MainController->__invoke (line 94)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 182)
20	Runtime\FrankenPhpSymfony\Runner->Runtime\FrankenPhpSymfony\{closure} (line 38)
21	frankenphp_handle_request (line 45)
22	Runtime\FrankenPhpSymfony\Runner::run (line 45)
23	require_once (line 29)
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\TerminalGroup	3
App\Entity\Terminal	1
App\Entity\Schedule	1
App\Entity\TerminalScheduleVersion	1

Entities Mapping

Class	Mapping errors
App\Entity\AvatarCategory	No errors.
App\Entity\FlugerZeroPoint	No errors.
App\Entity\RussPassImage	No errors.
App\Entity\Session	No errors.
App\Entity\AvatarVideo	No errors.
App\Entity\Poi	No errors.
App\Entity\Schedule	No errors.
App\Entity\Log	No errors.
App\Entity\TerminalStatistic	No errors.
App\Entity\SearchQuery	No errors.
App\Entity\Settings	No errors.
App\Entity\RussPassBaseObject	No errors.
App\Entity\RussPassRestaurant	No errors.
App\Entity\ObjectCategory	No errors.
App\Entity\ObjectCategoryTranslation	No errors.
App\Entity\TerminalReportScale	No errors.
App\Entity\FlugerProgram	No errors.
App\Entity\ContentGroup	No errors.
App\Entity\FlugerClipBlade	No errors.
App\Entity\TerminalReportPeriod	No errors.
App\Entity\PanoramaPoint	No errors.
App\Entity\SearchSuggestion	No errors.
App\Entity\AvatarVideoTranslation	No errors.
App\Entity\User	No errors.
App\Entity\FlugerClip	No errors.
App\Entity\SearchClickThrough	No errors.
App\Entity\StaticMedia	No errors.
App\Entity\Panorama	No errors.
App\Entity\FlugerWidgetVideo	No errors.
App\Entity\ContentItem	No errors.
App\Entity\Bugs	No errors.
App\Entity\Terminal	No errors.
App\Entity\RussPassEvent	No errors.
App\Entity\Feedback	No errors.
App\Entity\FlugerVideo	No errors.
App\Entity\FlugerTerminalSettings	No errors.
App\Entity\TerminalWork	No errors.
App\Entity\Building	No errors.
App\Entity\ContactInfo	No errors.
App\Entity\Instruction	No errors.
App\Entity\TerminalScheduleVersion	No errors.
App\Entity\Event	No errors.
App\Entity\EventTranslation	No errors.
App\Entity\FlugerTerminalProgram	No errors.
App\Entity\Camera	No errors.
App\Entity\Map	No errors.
App\Entity\RussPassTag	No errors.
App\Entity\TerminalGroup	No errors.
App\Entity\EventImage	No errors.
App\Entity\EventRouteLog	No errors.
App\Entity\TerminalStatusEvent	No errors.
App\Entity\MapImage	No errors.
App\Entity\PanoramaImage	No errors.
App\Entity\TransitionCategory	No errors.
App\Entity\PoiTranslation	No errors.
App\Entity\ScheduleContent	No errors.
App\Entity\ContentGroupPosition	No errors.
App\Entity\InformationVideo	No errors.
App\Entity\Media	No errors.
App\Entity\ShortRoad	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://new-back-navi.test.itlabs.top/api/get_timings/01K5E96P8K96BGXQRTB26FBSN9

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping