Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.27 ms Query time

0 Invalid entities

2 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.80 ms

SELECT a0_.id AS id_0, a0_.token AS token_1, a0_.name AS name_2, a0_.created_at AS created_at_3, a0_.updated_at AS updated_at_4, u1_.id AS id_5, u1_.username AS username_6, u1_.email AS email_7, u1_.name AS name_8, u1_.surname AS surname_9, u1_.roles AS roles_10, u1_.password AS password_11, u1_.totp_secret AS totp_secret_12, u1_.email_auth_enabled AS email_auth_enabled_13, u1_.auth_code AS auth_code_14, u1_.created_at AS created_at_15, u1_.updated_at AS updated_at_16, u1_.deleted_at AS deleted_at_17, o2_.id AS id_18, o2_.name AS name_19, o2_.form_id AS form_id_20, o2_.color AS color_21, o2_.background_color AS background_color_22, o2_.font_name AS font_name_23, o2_.container_style_embedded AS container_style_embedded_24, o2_.container_style_full_page AS container_style_full_page_25, o2_.url AS url_26, o2_.main_headline AS main_headline_27, o2_.cart_cancel AS cart_cancel_28, o2_.main_text AS main_text_29, o2_.footer AS footer_30, o2_.cart_additional AS cart_additional_31, o2_.terms_conditions AS terms_conditions_32, o2_.privacy_policy AS privacy_policy_33, o2_.cart_text AS cart_text_34, o2_.order_text AS order_text_35, o2_.links_text AS links_text_36, o2_.agreement_text AS agreement_text_37, o2_.view AS view_38, o2_.cancel_confirm_text AS cancel_confirm_text_39, o2_.origins AS origins_40, o2_.availability_from AS availability_from_41, o2_.availability_to AS availability_to_42, o2_.availability_max_days AS availability_max_days_43, o2_.availability_days AS availability_days_44, o2_.created_at AS created_at_45, o2_.updated_at AS updated_at_46, a0_.user_id AS user_id_47, a0_.created_by AS created_by_48, a0_.updated_by AS updated_by_49, u1_.form_id AS form_id_50, u1_.created_by AS created_by_51, u1_.updated_by AS updated_by_52, o2_.operator_id AS operator_id_53, o2_.created_by AS created_by_54, o2_.updated_by AS updated_by_55 FROM api_token a0_ INNER JOIN user u1_ ON a0_.user_id = u1_.id AND (u1_.deleted_at IS NULL) LEFT JOIN operator_form o2_ ON u1_.form_id = o2_.id WHERE a0_.token = ?

Parameters:

[
  "test"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.token AS token_1,
  a0_.name AS name_2,
  a0_.created_at AS created_at_3,
  a0_.updated_at AS updated_at_4,
  u1_.id AS id_5,
  u1_.username AS username_6,
  u1_.email AS email_7,
  u1_.name AS name_8,
  u1_.surname AS surname_9,
  u1_.roles AS roles_10,
  u1_.password AS password_11,
  u1_.totp_secret AS totp_secret_12,
  u1_.email_auth_enabled AS email_auth_enabled_13,
  u1_.auth_code AS auth_code_14,
  u1_.created_at AS created_at_15,
  u1_.updated_at AS updated_at_16,
  u1_.deleted_at AS deleted_at_17,
  o2_.id AS id_18,
  o2_.name AS name_19,
  o2_.form_id AS form_id_20,
  o2_.color AS color_21,
  o2_.background_color AS background_color_22,
  o2_.font_name AS font_name_23,
  o2_.container_style_embedded AS container_style_embedded_24,
  o2_.container_style_full_page AS container_style_full_page_25,
  o2_.url AS url_26,
  o2_.main_headline AS main_headline_27,
  o2_.cart_cancel AS cart_cancel_28,
  o2_.main_text AS main_text_29,
  o2_.footer AS footer_30,
  o2_.cart_additional AS cart_additional_31,
  o2_.terms_conditions AS terms_conditions_32,
  o2_.privacy_policy AS privacy_policy_33,
  o2_.cart_text AS cart_text_34,
  o2_.order_text AS order_text_35,
  o2_.links_text AS links_text_36,
  o2_.agreement_text AS agreement_text_37,
  o2_.view AS view_38,
  o2_.cancel_confirm_text AS cancel_confirm_text_39,
  o2_.origins AS origins_40,
  o2_.availability_from AS availability_from_41,
  o2_.availability_to AS availability_to_42,
  o2_.availability_max_days AS availability_max_days_43,
  o2_.availability_days AS availability_days_44,
  o2_.created_at AS created_at_45,
  o2_.updated_at AS updated_at_46,
  a0_.user_id AS user_id_47,
  a0_.created_by AS created_by_48,
  a0_.updated_by AS updated_by_49,
  u1_.form_id AS form_id_50,
  u1_.created_by AS created_by_51,
  u1_.updated_by AS updated_by_52,
  o2_.operator_id AS operator_id_53,
  o2_.created_by AS created_by_54,
  o2_.updated_by AS updated_by_55
FROM
  api_token a0_
  INNER JOIN user u1_ ON a0_.user_id = u1_.id
  AND (u1_.deleted_at IS NULL)
  LEFT JOIN operator_form o2_ ON u1_.form_id = o2_.id
WHERE
  a0_.token = ?

SELECT a0_.id AS id_0, a0_.token AS token_1, a0_.name AS name_2, a0_.created_at AS created_at_3, a0_.updated_at AS updated_at_4, u1_.id AS id_5, u1_.username AS username_6, u1_.email AS email_7, u1_.name AS name_8, u1_.surname AS surname_9, u1_.roles AS roles_10, u1_.password AS password_11, u1_.totp_secret AS totp_secret_12, u1_.email_auth_enabled AS email_auth_enabled_13, u1_.auth_code AS auth_code_14, u1_.created_at AS created_at_15, u1_.updated_at AS updated_at_16, u1_.deleted_at AS deleted_at_17, o2_.id AS id_18, o2_.name AS name_19, o2_.form_id AS form_id_20, o2_.color AS color_21, o2_.background_color AS background_color_22, o2_.font_name AS font_name_23, o2_.container_style_embedded AS container_style_embedded_24, o2_.container_style_full_page AS container_style_full_page_25, o2_.url AS url_26, o2_.main_headline AS main_headline_27, o2_.cart_cancel AS cart_cancel_28, o2_.main_text AS main_text_29, o2_.footer AS footer_30, o2_.cart_additional AS cart_additional_31, o2_.terms_conditions AS terms_conditions_32, o2_.privacy_policy AS privacy_policy_33, o2_.cart_text AS cart_text_34, o2_.order_text AS order_text_35, o2_.links_text AS links_text_36, o2_.agreement_text AS agreement_text_37, o2_.view AS view_38, o2_.cancel_confirm_text AS cancel_confirm_text_39, o2_.origins AS origins_40, o2_.availability_from AS availability_from_41, o2_.availability_to AS availability_to_42, o2_.availability_max_days AS availability_max_days_43, o2_.availability_days AS availability_days_44, o2_.created_at AS created_at_45, o2_.updated_at AS updated_at_46, a0_.user_id AS user_id_47, a0_.created_by AS created_by_48, a0_.updated_by AS updated_by_49, u1_.form_id AS form_id_50, u1_.created_by AS created_by_51, u1_.updated_by AS updated_by_52, o2_.operator_id AS operator_id_53, o2_.created_by AS created_by_54, o2_.updated_by AS updated_by_55 FROM api_token a0_ INNER JOIN user u1_ ON a0_.user_id = u1_.id AND (u1_.deleted_at IS NULL) LEFT JOIN operator_form o2_ ON u1_.form_id = o2_.id WHERE a0_.token = 'test';

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV3->execute (line 44)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
4	Doctrine\ORM\Query->_doExecute (line 330)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
6	Doctrine\ORM\AbstractQuery->execute (line 1167)
7	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 958)
8	App\Repository\User\ApiTokenRepository->findOneByTokenWithUserAndForm (line 50)
9	App\Security\ApiTokenHandler->App\Security\{closure} (line 37)
10	Symfony\Component\Cache\LockRegistry->compute (line 111)
11	Symfony\Component\Cache\Adapter\TagAwareAdapter::Symfony\Component\Cache\Traits\{closure} (line 102)
12	Symfony\Component\Cache\Adapter\TagAwareAdapter->contractsGet (line 64)
13	Symfony\Component\Cache\Adapter\TagAwareAdapter->doGet (line 85)
14	Symfony\Component\Cache\Adapter\TagAwareAdapter->get (line 30)
15	App\Security\ApiTokenHandler->getUserBadgeFrom (line 33)
16	Symfony\Component\Security\Http\Authenticator\AccessTokenAuthenticator->authenticate (line 61)
17	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 70)
18	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 176)
19	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 158)
20	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 140)
21	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 40)
22	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 68)
23	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
24	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 26)
25	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 83)
26	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 95)
27	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
28	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
29	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
30	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
33	Symfony\Component\HttpKernel\Kernel->handle (line 208)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
35	require_once (line 29)
36	require_once (line 5)

0.47 ms

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 1213)
9	Doctrine\ORM\AbstractQuery->execute (line 1167)
10	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 958)
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 208)
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\ApiToken	1
App\Entity\User	1

Entities Mapping

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

Symfony Profiler

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

Configuration Settings

Theme

Page Width