Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

11.30 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

9.82 ms
(86.90%)

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.email AS email_4, t0.password AS password_5, t0.roles AS roles_6, t0.position AS position_7, t0.last_online_at AS last_online_at_8, t0.status AS status_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.supplier_id AS supplier_id_12, t13.id AS id_14, t13.first_name AS first_name_15, t13.last_name AS last_name_16, t13.email AS email_17, t13.phone AS phone_18, t13.user_id AS user_id_19 FROM user t0 LEFT JOIN event_organiser t13 ON t13.user_id = t0.id WHERE t0.email = ? LIMIT 1

Parameters:

[
  "dev@digitalconcepts.mu"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.email AS email_4,
  t0.password AS password_5,
  t0.roles AS roles_6,
  t0.position AS position_7,
  t0.last_online_at AS last_online_at_8,
  t0.status AS status_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.supplier_id AS supplier_id_12,
  t13.id AS id_14,
  t13.first_name AS first_name_15,
  t13.last_name AS last_name_16,
  t13.email AS email_17,
  t13.phone AS phone_18,
  t13.user_id AS user_id_19
FROM
  user t0
  LEFT JOIN event_organiser t13 ON t13.user_id = t0.id
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.email AS email_4, t0.password AS password_5, t0.roles AS roles_6, t0.position AS position_7, t0.last_online_at AS last_online_at_8, t0.status AS status_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.supplier_id AS supplier_id_12, t13.id AS id_14, t13.first_name AS first_name_15, t13.last_name AS last_name_16, t13.email AS email_17, t13.phone AS phone_18, t13.user_id AS user_id_19 FROM user t0 LEFT JOIN event_organiser t13 ON t13.user_id = t0.id WHERE t0.email = 'dev@digitalconcepts.mu' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 54)
5	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 208)
6	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->loadUser (line 105)
7	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\{closure} (line 87)
8	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 56)
9	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 42)
10	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 115)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 180)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 158)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 140)
17	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 40)
18	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 68)
19	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
20	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
21	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 80)
22	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
23	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
24	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
25	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
26	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
27	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

0.81 ms
(7.14%)

SELECT count(DISTINCT t0_.id) AS sclr_0 FROM ticket t0_ INNER JOIN user u1_ ON t0_.created_by_id = u1_.id LEFT JOIN user u2_ ON t0_.assigned_to_id = u2_.id

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT t0_.id) AS sclr_0
FROM
  ticket t0_
  INNER JOIN user u1_ ON t0_.created_by_id = u1_.id
  LEFT JOIN user u2_ ON t0_.assigned_to_id = u2_.id

SELECT count(DISTINCT t0_.id) AS sclr_0 FROM ticket t0_ INNER JOIN user u1_ ON t0_.created_by_id = u1_.id LEFT JOIN user u2_ ON t0_.assigned_to_id = u2_.id;

#	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 69)
9	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getPaginationData (line 87)
10	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 53)
11	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 76)
12	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 49)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 150)
14	Symfony\Component\Serializer\Serializer->normalize (line 129)
15	Symfony\Component\Serializer\Serializer->serialize (line 43)
16	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 74)
17	ApiPlatform\State\Processor\SerializeProcessor->process (line 51)
18	ApiPlatform\State\Processor\WriteProcessor->process (line 112)
19	ApiPlatform\Symfony\Controller\MainController->__invoke (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.67 ms
(5.96%)

SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.description AS description_2, t0_.status AS status_3, t0_.priority AS priority_4, t0_.created_at AS created_at_5, t0_.updated_at AS updated_at_6, u1_.id AS id_7, u1_.first_name AS first_name_8, u1_.last_name AS last_name_9, u1_.email AS email_10, u1_.password AS password_11, u1_.roles AS roles_12, u1_.position AS position_13, u1_.last_online_at AS last_online_at_14, u1_.status AS status_15, u1_.created_at AS created_at_16, u1_.updated_at AS updated_at_17, u2_.id AS id_18, u2_.first_name AS first_name_19, u2_.last_name AS last_name_20, u2_.email AS email_21, u2_.password AS password_22, u2_.roles AS roles_23, u2_.position AS position_24, u2_.last_online_at AS last_online_at_25, u2_.status AS status_26, u2_.created_at AS created_at_27, u2_.updated_at AS updated_at_28, t0_.created_by_id AS created_by_id_29, t0_.assigned_to_id AS assigned_to_id_30, u1_.supplier_id AS supplier_id_31, u2_.supplier_id AS supplier_id_32 FROM ticket t0_ INNER JOIN user u1_ ON t0_.created_by_id = u1_.id LEFT JOIN user u2_ ON t0_.assigned_to_id = u2_.id ORDER BY t0_.updated_at DESC LIMIT 20

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.title AS title_1,
  t0_.description AS description_2,
  t0_.status AS status_3,
  t0_.priority AS priority_4,
  t0_.created_at AS created_at_5,
  t0_.updated_at AS updated_at_6,
  u1_.id AS id_7,
  u1_.first_name AS first_name_8,
  u1_.last_name AS last_name_9,
  u1_.email AS email_10,
  u1_.password AS password_11,
  u1_.roles AS roles_12,
  u1_.position AS position_13,
  u1_.last_online_at AS last_online_at_14,
  u1_.status AS status_15,
  u1_.created_at AS created_at_16,
  u1_.updated_at AS updated_at_17,
  u2_.id AS id_18,
  u2_.first_name AS first_name_19,
  u2_.last_name AS last_name_20,
  u2_.email AS email_21,
  u2_.password AS password_22,
  u2_.roles AS roles_23,
  u2_.position AS position_24,
  u2_.last_online_at AS last_online_at_25,
  u2_.status AS status_26,
  u2_.created_at AS created_at_27,
  u2_.updated_at AS updated_at_28,
  t0_.created_by_id AS created_by_id_29,
  t0_.assigned_to_id AS assigned_to_id_30,
  u1_.supplier_id AS supplier_id_31,
  u2_.supplier_id AS supplier_id_32
FROM
  ticket t0_
  INNER JOIN user u1_ ON t0_.created_by_id = u1_.id
  LEFT JOIN user u2_ ON t0_.assigned_to_id = u2_.id
ORDER BY
  t0_.updated_at DESC
LIMIT
  20

SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.description AS description_2, t0_.status AS status_3, t0_.priority AS priority_4, t0_.created_at AS created_at_5, t0_.updated_at AS updated_at_6, u1_.id AS id_7, u1_.first_name AS first_name_8, u1_.last_name AS last_name_9, u1_.email AS email_10, u1_.password AS password_11, u1_.roles AS roles_12, u1_.position AS position_13, u1_.last_online_at AS last_online_at_14, u1_.status AS status_15, u1_.created_at AS created_at_16, u1_.updated_at AS updated_at_17, u2_.id AS id_18, u2_.first_name AS first_name_19, u2_.last_name AS last_name_20, u2_.email AS email_21, u2_.password AS password_22, u2_.roles AS roles_23, u2_.position AS position_24, u2_.last_online_at AS last_online_at_25, u2_.status AS status_26, u2_.created_at AS created_at_27, u2_.updated_at AS updated_at_28, t0_.created_by_id AS created_by_id_29, t0_.assigned_to_id AS assigned_to_id_30, u1_.supplier_id AS supplier_id_31, u2_.supplier_id AS supplier_id_32 FROM ticket t0_ INNER JOIN user u1_ ON t0_.created_by_id = u1_.id LEFT JOIN user u2_ ON t0_.assigned_to_id = u2_.id ORDER BY t0_.updated_at DESC LIMIT 20;

#	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 88)
9	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 94)
10	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 53)
11	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 76)
12	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 49)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 150)
14	Symfony\Component\Serializer\Serializer->normalize (line 129)
15	Symfony\Component\Serializer\Serializer->serialize (line 43)
16	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 74)
17	ApiPlatform\State\Processor\SerializeProcessor->process (line 51)
18	ApiPlatform\State\Processor\WriteProcessor->process (line 112)
19	ApiPlatform\Symfony\Controller\MainController->__invoke (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (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.

Entities Mapping

Class	Mapping errors
App\Entity\User\User	No errors.
App\Entity\Supplier\Supplier	No errors.
App\Entity\EventOrganiser\EventOrganiser	No errors.
App\Entity\Content\Content	No errors.
App\Entity\Ticket\Ticket	No errors.
App\Entity\Ticket\TicketComment	No errors.

Symfony Profiler

GET https://admin.eventslab.africa/api/tickets?limit=20&page=1

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping