Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

4.03 ms Query time

0 Invalid entities

4 Managed entities

Grouped Statements

Show all queries

rw connection

Time▼

Count

Info

1.93 ms
(47.84%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 433)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Service\ApiUsageLogger->persistLog (line 151)
4	App\Service\ApiUsageLogger->log (line 57)
5	App\EventSubscriber\ApiRateLimitSubscriber->onKernelResponse (line 120)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
10	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 216)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 204)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	require_once (line 5)

1.00 ms
(24.80%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.roles AS roles_4, t0.password AS password_5, t0.last_login AS last_login_6, t0.is_verified AS is_verified_7, t0.enabled AS enabled_8, t9.id AS id_10, t9.theme AS theme_11, t9.color_theme AS color_theme_12, t9.layout AS layout_13, t9.sidebar_type AS sidebar_type_14, t9.boxed_layout AS boxed_layout_15, t9.direction AS direction_16, t9.card_border AS card_border_17, t9.timezone AS timezone_18, t9.dashboard_weeks AS dashboard_weeks_19, t9.kpi_weeks AS kpi_weeks_20, t9.store_report_weeks AS store_report_weeks_21, t9.user_id AS user_id_22, t23.id AS id_24, t23.registrar_server AS registrar_server_25, t23.registrar_port AS registrar_port_26, t23.extension_username AS extension_username_27, t23.encrypted_password AS encrypted_password_28, t23.display_name AS display_name_29, t23.is_active AS is_active_30, t23.created_at AS created_at_31, t23.updated_at AS updated_at_32, t23.user_id AS user_id_33 FROM user t0 LEFT JOIN user_settings t9 ON t9.user_id = t0.id LEFT JOIN webphone_mapping t23 ON t23.user_id = t0.id WHERE t0.id = ?

Parameters:

[
  44
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.username AS username_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.last_login AS last_login_6,
  t0.is_verified AS is_verified_7,
  t0.enabled AS enabled_8,
  t9.id AS id_10,
  t9.theme AS theme_11,
  t9.color_theme AS color_theme_12,
  t9.layout AS layout_13,
  t9.sidebar_type AS sidebar_type_14,
  t9.boxed_layout AS boxed_layout_15,
  t9.direction AS direction_16,
  t9.card_border AS card_border_17,
  t9.timezone AS timezone_18,
  t9.dashboard_weeks AS dashboard_weeks_19,
  t9.kpi_weeks AS kpi_weeks_20,
  t9.store_report_weeks AS store_report_weeks_21,
  t9.user_id AS user_id_22,
  t23.id AS id_24,
  t23.registrar_server AS registrar_server_25,
  t23.registrar_port AS registrar_port_26,
  t23.extension_username AS extension_username_27,
  t23.encrypted_password AS encrypted_password_28,
  t23.display_name AS display_name_29,
  t23.is_active AS is_active_30,
  t23.created_at AS created_at_31,
  t23.updated_at AS updated_at_32,
  t23.user_id AS user_id_33
FROM
  user t0
  LEFT JOIN user_settings t9 ON t9.user_id = t0.id
  LEFT JOIN webphone_mapping t23 ON t23.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.roles AS roles_4, t0.password AS password_5, t0.last_login AS last_login_6, t0.is_verified AS is_verified_7, t0.enabled AS enabled_8, t9.id AS id_10, t9.theme AS theme_11, t9.color_theme AS color_theme_12, t9.layout AS layout_13, t9.sidebar_type AS sidebar_type_14, t9.boxed_layout AS boxed_layout_15, t9.direction AS direction_16, t9.card_border AS card_border_17, t9.timezone AS timezone_18, t9.dashboard_weeks AS dashboard_weeks_19, t9.kpi_weeks AS kpi_weeks_20, t9.store_report_weeks AS store_report_weeks_21, t9.user_id AS user_id_22, t23.id AS id_24, t23.registrar_server AS registrar_server_25, t23.registrar_port AS registrar_port_26, t23.extension_username AS extension_username_27, t23.encrypted_password AS encrypted_password_28, t23.display_name AS display_name_29, t23.is_active AS is_active_30, t23.created_at AS created_at_31, t23.updated_at AS updated_at_32, t23.user_id AS user_id_33 FROM user t0 LEFT JOIN user_settings t9 ON t9.user_id = t0.id LEFT JOIN webphone_mapping t23 ON t23.user_id = t0.id WHERE t0.id = 44;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 193)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 32)
22	require_once (line 5)

0.87 ms
(21.57%)

INSERT INTO api_usage_log (endpoint, method, ip_address, user_agent, response_status, latency_ms, rate_limit_profile_id, abuse_flag, created_at, api_key_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "/api/v1/timezones"
  "GET"
  "172.70.255.119"
  "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36"
  200
  0
  null
  "none"
  "2026-05-08 03:58:02"
  null
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO api_usage_log (
  endpoint, method, ip_address, user_agent,
  response_status, latency_ms, rate_limit_profile_id,
  abuse_flag, created_at, api_key_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO api_usage_log (endpoint, method, ip_address, user_agent, response_status, latency_ms, rate_limit_profile_id, abuse_flag, created_at, api_key_id) VALUES ('/api/v1/timezones', 'GET', '172.70.255.119', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 200, 0, NULL, 'none', '2026-05-08 03:58:02', NULL);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 133)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1060)
4	Doctrine\ORM\UnitOfWork->commit (line 403)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Service\ApiUsageLogger->persistLog (line 151)
7	App\Service\ApiUsageLogger->log (line 57)
8	App\EventSubscriber\ApiRateLimitSubscriber->onKernelResponse (line 120)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
13	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 216)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 204)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 193)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 32)
19	require_once (line 5)

0.23 ms
(5.79%)

"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 382)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Service\ApiUsageLogger->persistLog (line 151)
4	App\Service\ApiUsageLogger->log (line 57)
5	App\EventSubscriber\ApiRateLimitSubscriber->onKernelResponse (line 120)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
10	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 216)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 204)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	require_once (line 5)

Database Connections

Name	Service
rw	doctrine.dbal.rw_connection
ro	doctrine.dbal.ro_connection

Entity Managers

Name	Service
_defaults	doctrine.orm._defaults_entity_manager
rw	doctrine.orm.rw_entity_manager
ro	doctrine.orm.ro_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

_defaults entity manager

Class	Amount of managed objects

rw entity manager

Class	Amount of managed objects
App\Entity\RW\User	1
App\Entity\UserSettings	1
App\Entity\RW\WebPhoneMapping	1
App\Entity\RW\ApiUsageLog	1

ro entity manager

Class	Amount of managed objects

Entities Mapping

_defaults entity manager

No loaded entities.

rw entity manager

Class	Mapping errors
App\Entity\RW\User	No errors.
App\Entity\UserSettings	No errors.
App\Entity\RW\WebPhoneMapping	No errors.
App\Entity\RW\MajusData	No errors.
App\Entity\RW\TicketReplies	No errors.
App\Entity\RW\Ticket	No errors.
App\Entity\RW\StoreNote	No errors.
App\Entity\RW\ApiUsageLog	No errors.
App\Entity\RW\ApiKey	No errors.

ro entity manager

No loaded entities.

Symfony Profiler

GET https://staging.mm-4.net/api/v1/timezones

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

rw connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

_defaults entity manager

rw entity manager

ro entity manager

Entities Mapping

_defaults entity manager

rw entity manager

ro entity manager