Symfony Profiler

Query Metrics

929 Database Queries

5 Different statements

174.05 ms Query time

0 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

63.20 ms
(36.31%)

232

SELECT m.* FROM messenger_messages m WHERE (m.queue_name = ?) AND (m.delivered_at is null OR m.delivered_at < ?) AND (m.available_at <= ?) ORDER BY available_at ASC LIMIT 1 FOR UPDATE

Parameters:

[
  "high"
  "2025-12-06 03:55:00"
  "2025-12-06 04:55:00"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m.*
FROM
  messenger_messages m
WHERE
  (m.queue_name = ?)
  AND (
    m.delivered_at is null
    OR m.delivered_at < ?
  )
  AND (m.available_at <= ?)
ORDER BY
  available_at ASC
LIMIT
  1 FOR
UPDATE

SELECT m.* FROM messenger_messages m WHERE (m.queue_name = 'high') AND (m.delivered_at is null OR m.delivered_at < '2025-12-06 03:55:00') AND (m.available_at <= '2025-12-06 04:55:00') ORDER BY available_at ASC LIMIT 1 FOR UPDATE;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV3->execute (line 44)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->executeQuery (line 425)
4	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->get (line 229)
5	Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineReceiver->get (line 45)
6	Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineTransport->get (line 42)
7	Symfony\Component\Messenger\Worker->run (line 101)
8	Symfony\Component\Messenger\Command\ConsumeMessagesCommand->execute (line 244)
9	Symfony\Component\Console\Command\Command->run (line 326)
10	Symfony\Component\Console\Application->doRunCommand (line 1096)
11	Symfony\Bundle\FrameworkBundle\Console\Application->doRunCommand (line 126)
12	Symfony\Component\Console\Application->doRun (line 324)
13	Symfony\Bundle\FrameworkBundle\Console\Application->doRun (line 80)
14	Symfony\Component\Console\Application->run (line 175)
15	App\Controller\Api\CronController->sendQueue (line 94)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 197)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

60.94 ms
(35.01%)

232

DELETE FROM messenger_messages WHERE delivered_at = ?

Parameters:

[
  "9999-12-31 23:59:59"
]

View formatted query View runnable query Explain query View query backtrace

DELETE FROM
  messenger_messages
WHERE
  delivered_at = ?

DELETE FROM messenger_messages WHERE delivered_at = '9999-12-31 23:59:59';

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV3->execute (line 44)
2	Doctrine\DBAL\Connection->executeStatement (line 1212)
3	Doctrine\DBAL\Connection->delete (line 703)
4	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->get (line 167)
5	Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineReceiver->get (line 45)
6	Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineTransport->get (line 42)
7	Symfony\Component\Messenger\Worker->run (line 101)
8	Symfony\Component\Messenger\Command\ConsumeMessagesCommand->execute (line 244)
9	Symfony\Component\Console\Command\Command->run (line 326)
10	Symfony\Component\Console\Application->doRunCommand (line 1096)
11	Symfony\Bundle\FrameworkBundle\Console\Application->doRunCommand (line 126)
12	Symfony\Component\Console\Application->doRun (line 324)
13	Symfony\Bundle\FrameworkBundle\Console\Application->doRun (line 80)
14	Symfony\Component\Console\Application->run (line 175)
15	App\Controller\Api\CronController->sendQueue (line 94)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 197)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

25.11 ms
(14.43%)

232

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV2V3->traceFunction (line 236)
2	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV2V3->commit (line 156)
3	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingServerInfoAwareDriverConnection->commit (line 93)
4	Doctrine\DBAL\Connection->doCommit (line 1502)
5	Doctrine\DBAL\Connection->commit (line 1454)
6	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->get (line 237)
7	Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineReceiver->get (line 45)
8	Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineTransport->get (line 42)
9	Symfony\Component\Messenger\Worker->run (line 101)
10	Symfony\Component\Messenger\Command\ConsumeMessagesCommand->execute (line 244)
11	Symfony\Component\Console\Command\Command->run (line 326)
12	Symfony\Component\Console\Application->doRunCommand (line 1096)
13	Symfony\Bundle\FrameworkBundle\Console\Application->doRunCommand (line 126)
14	Symfony\Component\Console\Application->doRun (line 324)
15	Symfony\Bundle\FrameworkBundle\Console\Application->doRun (line 80)
16	Symfony\Component\Console\Application->run (line 175)
17	App\Controller\Api\CronController->sendQueue (line 94)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 197)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 29)
23	require_once (line 5)

23.98 ms
(13.78%)

232

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV2V3->traceFunction (line 236)
2	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV2V3->beginTransaction (line 146)
3	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingServerInfoAwareDriverConnection->beginTransaction (line 85)
4	Doctrine\DBAL\Connection->beginTransaction (line 1391)
5	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->get (line 178)
6	Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineReceiver->get (line 45)
7	Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineTransport->get (line 42)
8	Symfony\Component\Messenger\Worker->run (line 101)
9	Symfony\Component\Messenger\Command\ConsumeMessagesCommand->execute (line 244)
10	Symfony\Component\Console\Command\Command->run (line 326)
11	Symfony\Component\Console\Application->doRunCommand (line 1096)
12	Symfony\Bundle\FrameworkBundle\Console\Application->doRunCommand (line 126)
13	Symfony\Component\Console\Application->doRun (line 324)
14	Symfony\Bundle\FrameworkBundle\Console\Application->doRun (line 80)
15	Symfony\Component\Console\Application->run (line 175)
16	App\Controller\Api\CronController->sendQueue (line 94)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 197)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 5)

0.82 ms
(0.47%)

SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.email AS email_2, u0_.name AS name_3, u0_.surname AS surname_4, u0_.roles AS roles_5, u0_.password AS password_6, u0_.totp_secret AS totp_secret_7, u0_.email_auth_enabled AS email_auth_enabled_8, u0_.auth_code AS auth_code_9, u0_.created_at AS created_at_10, u0_.updated_at AS updated_at_11, u0_.deleted_at AS deleted_at_12, o1_.id AS id_13, o1_.name AS name_14, o1_.form_id AS form_id_15, o1_.color AS color_16, o1_.background_color AS background_color_17, o1_.font_name AS font_name_18, o1_.container_style_embedded AS container_style_embedded_19, o1_.container_style_full_page AS container_style_full_page_20, o1_.url AS url_21, o1_.main_headline AS main_headline_22, o1_.cart_cancel AS cart_cancel_23, o1_.main_text AS main_text_24, o1_.footer AS footer_25, o1_.cart_additional AS cart_additional_26, o1_.terms_conditions AS terms_conditions_27, o1_.privacy_policy AS privacy_policy_28, o1_.cart_text AS cart_text_29, o1_.order_text AS order_text_30, o1_.links_text AS links_text_31, o1_.agreement_text AS agreement_text_32, o1_.view AS view_33, o1_.cancel_confirm_text AS cancel_confirm_text_34, o1_.origins AS origins_35, o1_.availability_from AS availability_from_36, o1_.availability_to AS availability_to_37, o1_.availability_max_days AS availability_max_days_38, o1_.availability_days AS availability_days_39, o1_.created_at AS created_at_40, o1_.updated_at AS updated_at_41, u0_.form_id AS form_id_42, u0_.created_by AS created_by_43, u0_.updated_by AS updated_by_44, o1_.operator_id AS operator_id_45, o1_.created_by AS created_by_46, o1_.updated_by AS updated_by_47 FROM user u0_ LEFT JOIN operator_form o1_ ON u0_.form_id = o1_.id WHERE (u0_.id = ?) AND (u0_.deleted_at IS NULL)

Parameters:

[
  "6"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.username AS username_1,
  u0_.email AS email_2,
  u0_.name AS name_3,
  u0_.surname AS surname_4,
  u0_.roles AS roles_5,
  u0_.password AS password_6,
  u0_.totp_secret AS totp_secret_7,
  u0_.email_auth_enabled AS email_auth_enabled_8,
  u0_.auth_code AS auth_code_9,
  u0_.created_at AS created_at_10,
  u0_.updated_at AS updated_at_11,
  u0_.deleted_at AS deleted_at_12,
  o1_.id AS id_13,
  o1_.name AS name_14,
  o1_.form_id AS form_id_15,
  o1_.color AS color_16,
  o1_.background_color AS background_color_17,
  o1_.font_name AS font_name_18,
  o1_.container_style_embedded AS container_style_embedded_19,
  o1_.container_style_full_page AS container_style_full_page_20,
  o1_.url AS url_21,
  o1_.main_headline AS main_headline_22,
  o1_.cart_cancel AS cart_cancel_23,
  o1_.main_text AS main_text_24,
  o1_.footer AS footer_25,
  o1_.cart_additional AS cart_additional_26,
  o1_.terms_conditions AS terms_conditions_27,
  o1_.privacy_policy AS privacy_policy_28,
  o1_.cart_text AS cart_text_29,
  o1_.order_text AS order_text_30,
  o1_.links_text AS links_text_31,
  o1_.agreement_text AS agreement_text_32,
  o1_.view AS view_33,
  o1_.cancel_confirm_text AS cancel_confirm_text_34,
  o1_.origins AS origins_35,
  o1_.availability_from AS availability_from_36,
  o1_.availability_to AS availability_to_37,
  o1_.availability_max_days AS availability_max_days_38,
  o1_.availability_days AS availability_days_39,
  o1_.created_at AS created_at_40,
  o1_.updated_at AS updated_at_41,
  u0_.form_id AS form_id_42,
  u0_.created_by AS created_by_43,
  u0_.updated_by AS updated_by_44,
  o1_.operator_id AS operator_id_45,
  o1_.created_by AS created_by_46,
  o1_.updated_by AS updated_by_47
FROM
  user u0_
  LEFT JOIN operator_form o1_ ON u0_.form_id = o1_.id
WHERE
  (u0_.id = ?)
  AND (u0_.deleted_at IS NULL)

SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.email AS email_2, u0_.name AS name_3, u0_.surname AS surname_4, u0_.roles AS roles_5, u0_.password AS password_6, u0_.totp_secret AS totp_secret_7, u0_.email_auth_enabled AS email_auth_enabled_8, u0_.auth_code AS auth_code_9, u0_.created_at AS created_at_10, u0_.updated_at AS updated_at_11, u0_.deleted_at AS deleted_at_12, o1_.id AS id_13, o1_.name AS name_14, o1_.form_id AS form_id_15, o1_.color AS color_16, o1_.background_color AS background_color_17, o1_.font_name AS font_name_18, o1_.container_style_embedded AS container_style_embedded_19, o1_.container_style_full_page AS container_style_full_page_20, o1_.url AS url_21, o1_.main_headline AS main_headline_22, o1_.cart_cancel AS cart_cancel_23, o1_.main_text AS main_text_24, o1_.footer AS footer_25, o1_.cart_additional AS cart_additional_26, o1_.terms_conditions AS terms_conditions_27, o1_.privacy_policy AS privacy_policy_28, o1_.cart_text AS cart_text_29, o1_.order_text AS order_text_30, o1_.links_text AS links_text_31, o1_.agreement_text AS agreement_text_32, o1_.view AS view_33, o1_.cancel_confirm_text AS cancel_confirm_text_34, o1_.origins AS origins_35, o1_.availability_from AS availability_from_36, o1_.availability_to AS availability_to_37, o1_.availability_max_days AS availability_max_days_38, o1_.availability_days AS availability_days_39, o1_.created_at AS created_at_40, o1_.updated_at AS updated_at_41, u0_.form_id AS form_id_42, u0_.created_by AS created_by_43, u0_.updated_by AS updated_by_44, o1_.operator_id AS operator_id_45, o1_.created_by AS created_by_46, o1_.updated_by AS updated_by_47 FROM user u0_ LEFT JOIN operator_form o1_ ON u0_.form_id = o1_.id WHERE (u0_.id = '6') AND (u0_.deleted_at IS NULL);

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV3->execute (line 44)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\DBAL\Connection->fetchAllAssociative (line 907)
4	Doctrine\DBAL\Connection->executeCacheQuery (line 1157)
5	Doctrine\DBAL\Connection->executeQuery (line 1084)
6	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
7	Doctrine\ORM\Query->_doExecute (line 330)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1218)
9	Doctrine\ORM\AbstractQuery->execute (line 1172)
10	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 959)
11	App\Repository\UserRepository->findOneByIdCache (line 68)
12	App\Security\ApiTokenHandler->App\Security\{closure} (line 83)
13	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 87)
14	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 56)
15	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 42)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
20	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 180)
21	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 158)
22	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 140)
23	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 40)
24	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 68)
25	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
26	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 26)
27	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 83)
28	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 95)
29	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
30	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
31	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
32	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
35	Symfony\Component\HttpKernel\Kernel->handle (line 197)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
37	require_once (line 29)
38	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\User	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Operator\Form	No errors.
App\Entity\Operator	No errors.
App\Entity\User\ApiToken	No errors.
App\Entity\Operator\User	No errors.

Symfony Profiler

GET https://api.tikitio.iview.cz/system/cron/messages

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping