Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

0.69 ms Query time

1 Invalid entities

1 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.30 ms

SELECT t0.id AS id_1, t0.email AS email_2, t0.status AS status_3, t0.tip AS tip_4, t0.roles AS roles_5, t0.settings AS settings_6, t0.password AS password_7, t0.confirmation_token AS confirmation_token_8, t0.password_requested_at AS password_requested_at_9, t0.last_activity_at AS last_activity_at_10, t0.last_login_at AS last_login_at_11, t0.termen_limita AS termen_limita_12, t0.file_avatar_name AS file_avatar_name_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM user t0 WHERE t0.id = ?

Parameters:

[
  48
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.status AS status_3,
  t0.tip AS tip_4,
  t0.roles AS roles_5,
  t0.settings AS settings_6,
  t0.password AS password_7,
  t0.confirmation_token AS confirmation_token_8,
  t0.password_requested_at AS password_requested_at_9,
  t0.last_activity_at AS last_activity_at_10,
  t0.last_login_at AS last_login_at_11,
  t0.termen_limita AS termen_limita_12,
  t0.file_avatar_name AS file_avatar_name_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.status AS status_3, t0.tip AS tip_4, t0.roles AS roles_5, t0.settings AS settings_6, t0.password AS password_7, t0.confirmation_token AS confirmation_token_8, t0.password_requested_at AS password_requested_at_9, t0.last_activity_at AS last_activity_at_10, t0.last_login_at AS last_login_at_11, t0.termen_limita AS termen_limita_12, t0.file_avatar_name AS file_avatar_name_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM user t0 WHERE t0.id = 48;

#	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->{closure:Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext::authenticate():80} (line 83)
11	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage::getToken (line 34)
12	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 42)
13	App\Twig\Extension->getUser (line 2599)
14	App\Service\ActivityListener->onCoreController (line 45)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 193)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 32)
24	require_once (line 5)

0.39 ms

SELECT n0_.id AS id_0, n0_.titlu AS titlu_1, n0_.descriere AS descriere_2, n0_.citit AS citit_3, n0_.created_at AS created_at_4, n0_.updated_at AS updated_at_5 FROM notificare n0_ WHERE n0_.user_id = ? ORDER BY n0_.updated_at DESC LIMIT 20

Parameters:

[
  48
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0_.id AS id_0,
  n0_.titlu AS titlu_1,
  n0_.descriere AS descriere_2,
  n0_.citit AS citit_3,
  n0_.created_at AS created_at_4,
  n0_.updated_at AS updated_at_5
FROM
  notificare n0_
WHERE
  n0_.user_id = ?
ORDER BY
  n0_.updated_at DESC
LIMIT
  20

SELECT n0_.id AS id_0, n0_.titlu AS titlu_1, n0_.descriere AS descriere_2, n0_.citit AS citit_3, n0_.created_at AS created_at_4, n0_.updated_at AS updated_at_5 FROM notificare n0_ WHERE n0_.user_id = 48 ORDER BY n0_.updated_at DESC LIMIT 20;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getArrayResult (line 700)
6	App\Repository\NotificareRepository->getNotificari (line 27)
7	App\Controller\GeneralController->panel_API (line 48362)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	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	The mappings App\Entity\User#plati and App\Entity\Contract#user are inconsistent with each other.
App\Entity\Ticket	No errors.
App\Entity\Mesaj	No errors.
App\Entity\Solicitare	No errors.
App\Entity\Contract	No errors.
App\Entity\Pagina	No errors.
App\Entity\Profil	No errors.
App\Entity\Notificare	No errors.
App\Entity\Audit	No errors.
App\Entity\Vehicul	No errors.

Symfony Profiler

GET https://parcari.apulum.ro/panel/api?tip=notificari_mini_list

Configuration Settings

Theme

Page Width