Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

11.54 ms Query time

0 Invalid entities

2 Managed entities

Queries

Group similar statements

#▲

Time

Info

2.62 ms

SELECT u0_.email AS email_0, u0_.password AS password_1, u0_.name AS name_2, u0_.surname AS surname_3, u0_.phone AS phone_4, u0_.is_email_verified AS is_email_verified_5, u0_.login_at AS login_at_6, u0_.is_enabled AS is_enabled_7, u0_.id AS id_8, u0_.created_at AS created_at_9, u0_.updated_at AS updated_at_10, u0_.deleted_at AS deleted_at_11, u0_.role_id AS role_id_12 FROM "user" u0_ WHERE u0_.id = ? AND u0_.is_enabled = ?

Parameters:

[
  "019a9183-480f-73d6-878e-1f30fa75bf7e"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.email AS email_0,
  u0_.password AS password_1,
  u0_.name AS name_2,
  u0_.surname AS surname_3,
  u0_.phone AS phone_4,
  u0_.is_email_verified AS is_email_verified_5,
  u0_.login_at AS login_at_6,
  u0_.is_enabled AS is_enabled_7,
  u0_.id AS id_8,
  u0_.created_at AS created_at_9,
  u0_.updated_at AS updated_at_10,
  u0_.deleted_at AS deleted_at_11,
  u0_.role_id AS role_id_12
FROM
  "user" u0_
WHERE
  u0_.id = ?
  AND u0_.is_enabled = ?

SELECT u0_.email AS email_0, u0_.password AS password_1, u0_.name AS name_2, u0_.surname AS surname_3, u0_.phone AS phone_4, u0_.is_email_verified AS is_email_verified_5, u0_.login_at AS login_at_6, u0_.is_enabled AS is_enabled_7, u0_.id AS id_8, u0_.created_at AS created_at_9, u0_.updated_at AS updated_at_10, u0_.deleted_at AS deleted_at_11, u0_.role_id AS role_id_12 FROM "user" u0_ WHERE u0_.id = '019a9183-480f-73d6-878e-1f30fa75bf7e' AND u0_.is_enabled = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 51)
7	App\Repository\UserRepository->loadUserById (line 37)
8	App\Repository\UserRepository->loadUserByIdentifier (line 60)
9	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 208)
10	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->loadUser (line 105)
11	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\{closure} (line 101)
12	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 56)
13	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 40)
14	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 115)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 189)
19	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 167)
20	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 149)
21	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 38)
22	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 58)
23	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
24	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
25	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 91)
26	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
27	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
28	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
29	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
30	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
31	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
34	Symfony\Component\HttpKernel\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 5)

5.22 ms

SELECT count(DISTINCT s0_.id) AS sclr_0 FROM sgk_employment_action s0_ INNER JOIN client c1_ ON s0_.client_id = c1_.id LEFT JOIN city c2_ ON c1_.city_id = c2_.id INNER JOIN customer c3_ ON c1_.customer_id = c3_.id INNER JOIN tax_office t4_ ON c1_.tax_office_id = t4_.id INNER JOIN client_branch c5_ ON s0_.branch_id = c5_.id WHERE s0_.client_id = ?

Parameters:

[
  "019ae8bb-158f-71ea-b9b0-3e540de57ce6"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT s0_.id) AS sclr_0
FROM
  sgk_employment_action s0_
  INNER JOIN client c1_ ON s0_.client_id = c1_.id
  LEFT JOIN city c2_ ON c1_.city_id = c2_.id
  INNER JOIN customer c3_ ON c1_.customer_id = c3_.id
  INNER JOIN tax_office t4_ ON c1_.tax_office_id = t4_.id
  INNER JOIN client_branch c5_ ON s0_.branch_id = c5_.id
WHERE
  s0_.client_id = ?

SELECT count(DISTINCT s0_.id) AS sclr_0 FROM sgk_employment_action s0_ INNER JOIN client c1_ ON s0_.client_id = c1_.id LEFT JOIN city c2_ ON c1_.city_id = c2_.id INNER JOIN customer c3_ ON c1_.customer_id = c3_.id INNER JOIN tax_office t4_ ON c1_.tax_office_id = t4_.id INNER JOIN client_branch c5_ ON s0_.branch_id = c5_.id WHERE s0_.client_id = '019ae8bb-158f-71ea-b9b0-3e540de57ce6';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 96)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 49)
8	ApiPlatform\Doctrine\Orm\Paginator->getTotalItems (line 41)
9	ApiPlatform\Doctrine\Orm\Paginator->getLastPage (line 142)
10	ApiPlatform\Serializer\AbstractCollectionNormalizer->getPaginationConfig (line 34)
11	App\Serializer\Normalizer\JsonCollectionNormalizer->getPaginationData (line 102)
12	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 68)
13	App\Serializer\Normalizer\JsonCollectionNormalizer->normalize (line 50)
14	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
15	Symfony\Component\Serializer\Serializer->normalize (line 131)
16	Symfony\Component\Serializer\Serializer->serialize (line 44)
17	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 79)
18	ApiPlatform\State\Processor\SerializeProcessor->process (line 102)
19	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 115)
20	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
21	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
22	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
23	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

3.71 ms

SELECT s0_.action_id AS action_id_0, s0_.action AS action_1, s0_.tc_identity_number AS tc_identity_number_2, s0_.name AS name_3, s0_.exception_code AS exception_code_4, s0_.issued_at AS issued_at_5, s0_.id AS id_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, c1_.type AS type_9, c1_.ledger_type AS ledger_type_10, c1_.name AS name_11, c1_.title AS title_12, c1_.tax_number AS tax_number_13, c1_.tc_identity_number AS tc_identity_number_14, c1_.kep AS kep_15, c1_.phone AS phone_16, c1_.email AS email_17, c1_.address AS address_18, c1_.established_at AS established_at_19, c1_.terminated_at AS terminated_at_20, c1_.e_seal_expire_at AS e_seal_expire_at_21, c1_.id AS id_22, c1_.created_at AS created_at_23, c1_.updated_at AS updated_at_24, c1_.deleted_at AS deleted_at_25, c2_.name AS name_26, c2_.id AS id_27, c2_.is_enabled AS is_enabled_28, c3_.name AS name_29, c3_.title AS title_30, c3_.phone AS phone_31, c3_.email AS email_32, c3_.address AS address_33, c3_.tax_number AS tax_number_34, c3_.tc_identity_number AS tc_identity_number_35, c3_.status AS status_36, c3_.expires_at AS expires_at_37, c3_.id AS id_38, c3_.created_at AS created_at_39, c3_.updated_at AS updated_at_40, c3_.deleted_at AS deleted_at_41, t4_.code AS code_42, t4_.name AS name_43, t4_.id AS id_44, t4_.is_enabled AS is_enabled_45, c5_.name AS name_46, c5_.sgk_user AS sgk_user_47, c5_.sgk_code AS sgk_code_48, c5_.sgk_company AS sgk_company_49, c5_.sgk_password AS sgk_password_50, c5_.sgk_registration_number AS sgk_registration_number_51, c5_.established_at AS established_at_52, c5_.terminated_at AS terminated_at_53, c5_.id AS id_54, c5_.created_at AS created_at_55, c5_.updated_at AS updated_at_56, c5_.is_enabled AS is_enabled_57, s0_.client_id AS client_id_58, s0_.branch_id AS branch_id_59, c1_.nace_id AS nace_id_60, c1_.city_id AS city_id_61, c1_.customer_id AS customer_id_62, c1_.tax_office_id AS tax_office_id_63, c3_.tax_office_id AS tax_office_id_64, c3_.city_id AS city_id_65, t4_.city_id AS city_id_66, c5_.client_id AS client_id_67 FROM sgk_employment_action s0_ INNER JOIN client c1_ ON s0_.client_id = c1_.id LEFT JOIN city c2_ ON c1_.city_id = c2_.id INNER JOIN customer c3_ ON c1_.customer_id = c3_.id INNER JOIN tax_office t4_ ON c1_.tax_office_id = t4_.id INNER JOIN client_branch c5_ ON s0_.branch_id = c5_.id WHERE s0_.client_id = ? ORDER BY s0_.created_at DESC LIMIT 10

Parameters:

[
  "019ae8bb-158f-71ea-b9b0-3e540de57ce6"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.action_id AS action_id_0,
  s0_.action AS action_1,
  s0_.tc_identity_number AS tc_identity_number_2,
  s0_.name AS name_3,
  s0_.exception_code AS exception_code_4,
  s0_.issued_at AS issued_at_5,
  s0_.id AS id_6,
  s0_.created_at AS created_at_7,
  s0_.updated_at AS updated_at_8,
  c1_.type AS type_9,
  c1_.ledger_type AS ledger_type_10,
  c1_.name AS name_11,
  c1_.title AS title_12,
  c1_.tax_number AS tax_number_13,
  c1_.tc_identity_number AS tc_identity_number_14,
  c1_.kep AS kep_15,
  c1_.phone AS phone_16,
  c1_.email AS email_17,
  c1_.address AS address_18,
  c1_.established_at AS established_at_19,
  c1_.terminated_at AS terminated_at_20,
  c1_.e_seal_expire_at AS e_seal_expire_at_21,
  c1_.id AS id_22,
  c1_.created_at AS created_at_23,
  c1_.updated_at AS updated_at_24,
  c1_.deleted_at AS deleted_at_25,
  c2_.name AS name_26,
  c2_.id AS id_27,
  c2_.is_enabled AS is_enabled_28,
  c3_.name AS name_29,
  c3_.title AS title_30,
  c3_.phone AS phone_31,
  c3_.email AS email_32,
  c3_.address AS address_33,
  c3_.tax_number AS tax_number_34,
  c3_.tc_identity_number AS tc_identity_number_35,
  c3_.status AS status_36,
  c3_.expires_at AS expires_at_37,
  c3_.id AS id_38,
  c3_.created_at AS created_at_39,
  c3_.updated_at AS updated_at_40,
  c3_.deleted_at AS deleted_at_41,
  t4_.code AS code_42,
  t4_.name AS name_43,
  t4_.id AS id_44,
  t4_.is_enabled AS is_enabled_45,
  c5_.name AS name_46,
  c5_.sgk_user AS sgk_user_47,
  c5_.sgk_code AS sgk_code_48,
  c5_.sgk_company AS sgk_company_49,
  c5_.sgk_password AS sgk_password_50,
  c5_.sgk_registration_number AS sgk_registration_number_51,
  c5_.established_at AS established_at_52,
  c5_.terminated_at AS terminated_at_53,
  c5_.id AS id_54,
  c5_.created_at AS created_at_55,
  c5_.updated_at AS updated_at_56,
  c5_.is_enabled AS is_enabled_57,
  s0_.client_id AS client_id_58,
  s0_.branch_id AS branch_id_59,
  c1_.nace_id AS nace_id_60,
  c1_.city_id AS city_id_61,
  c1_.customer_id AS customer_id_62,
  c1_.tax_office_id AS tax_office_id_63,
  c3_.tax_office_id AS tax_office_id_64,
  c3_.city_id AS city_id_65,
  t4_.city_id AS city_id_66,
  c5_.client_id AS client_id_67
FROM
  sgk_employment_action s0_
  INNER JOIN client c1_ ON s0_.client_id = c1_.id
  LEFT JOIN city c2_ ON c1_.city_id = c2_.id
  INNER JOIN customer c3_ ON c1_.customer_id = c3_.id
  INNER JOIN tax_office t4_ ON c1_.tax_office_id = t4_.id
  INNER JOIN client_branch c5_ ON s0_.branch_id = c5_.id
WHERE
  s0_.client_id = ?
ORDER BY
  s0_.created_at DESC
LIMIT
  10

SELECT s0_.action_id AS action_id_0, s0_.action AS action_1, s0_.tc_identity_number AS tc_identity_number_2, s0_.name AS name_3, s0_.exception_code AS exception_code_4, s0_.issued_at AS issued_at_5, s0_.id AS id_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, c1_.type AS type_9, c1_.ledger_type AS ledger_type_10, c1_.name AS name_11, c1_.title AS title_12, c1_.tax_number AS tax_number_13, c1_.tc_identity_number AS tc_identity_number_14, c1_.kep AS kep_15, c1_.phone AS phone_16, c1_.email AS email_17, c1_.address AS address_18, c1_.established_at AS established_at_19, c1_.terminated_at AS terminated_at_20, c1_.e_seal_expire_at AS e_seal_expire_at_21, c1_.id AS id_22, c1_.created_at AS created_at_23, c1_.updated_at AS updated_at_24, c1_.deleted_at AS deleted_at_25, c2_.name AS name_26, c2_.id AS id_27, c2_.is_enabled AS is_enabled_28, c3_.name AS name_29, c3_.title AS title_30, c3_.phone AS phone_31, c3_.email AS email_32, c3_.address AS address_33, c3_.tax_number AS tax_number_34, c3_.tc_identity_number AS tc_identity_number_35, c3_.status AS status_36, c3_.expires_at AS expires_at_37, c3_.id AS id_38, c3_.created_at AS created_at_39, c3_.updated_at AS updated_at_40, c3_.deleted_at AS deleted_at_41, t4_.code AS code_42, t4_.name AS name_43, t4_.id AS id_44, t4_.is_enabled AS is_enabled_45, c5_.name AS name_46, c5_.sgk_user AS sgk_user_47, c5_.sgk_code AS sgk_code_48, c5_.sgk_company AS sgk_company_49, c5_.sgk_password AS sgk_password_50, c5_.sgk_registration_number AS sgk_registration_number_51, c5_.established_at AS established_at_52, c5_.terminated_at AS terminated_at_53, c5_.id AS id_54, c5_.created_at AS created_at_55, c5_.updated_at AS updated_at_56, c5_.is_enabled AS is_enabled_57, s0_.client_id AS client_id_58, s0_.branch_id AS branch_id_59, c1_.nace_id AS nace_id_60, c1_.city_id AS city_id_61, c1_.customer_id AS customer_id_62, c1_.tax_office_id AS tax_office_id_63, c3_.tax_office_id AS tax_office_id_64, c3_.city_id AS city_id_65, t4_.city_id AS city_id_66, c5_.client_id AS client_id_67 FROM sgk_employment_action s0_ INNER JOIN client c1_ ON s0_.client_id = c1_.id LEFT JOIN city c2_ ON c1_.city_id = c2_.id INNER JOIN customer c3_ ON c1_.customer_id = c3_.id INNER JOIN tax_office t4_ ON c1_.tax_office_id = t4_.id INNER JOIN client_branch c5_ ON s0_.branch_id = c5_.id WHERE s0_.client_id = '019ae8bb-158f-71ea-b9b0-3e540de57ce6' ORDER BY s0_.created_at DESC LIMIT 10;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 151)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 69)
8	ApiPlatform\Doctrine\Orm\AbstractPaginator->getIterator (line 124)
9	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalizeRawCollection (line 96)
10	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 63)
11	App\Serializer\Normalizer\JsonCollectionNormalizer->normalize (line 50)
12	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
13	Symfony\Component\Serializer\Serializer->normalize (line 57)
14	App\Serializer\Normalizer\JsonCollectionNormalizer->getItemsData (line 109)
15	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 68)
16	App\Serializer\Normalizer\JsonCollectionNormalizer->normalize (line 50)
17	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
18	Symfony\Component\Serializer\Serializer->normalize (line 131)
19	Symfony\Component\Serializer\Serializer->serialize (line 44)
20	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 79)
21	ApiPlatform\State\Processor\SerializeProcessor->process (line 102)
22	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 115)
23	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
26	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	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
App\Entity\Role	1

Entities Mapping

Class	Mapping errors
App\Entity\Integration\Sgk\EmploymentAction	No errors.
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken	No errors.
App\Entity\UserRefreshToken	No errors.
App\Entity\User	No errors.
App\Entity\Role	No errors.
App\Entity\Client	No errors.
App\Entity\Customer	No errors.
App\Entity\City	No errors.
App\Entity\TaxOffice	No errors.
App\Entity\ClientBranch	No errors.
App\Entity\Nace	No errors.

Symfony Profiler

GET https://api.istasyontech.test.rebase.software/v1/sgk/employment-actions?client=019ae8bb-158f-71ea-b9b0-3e540de57ce6&limit=10&page=1

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping