Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

1.84 ms Query time

0 Invalid entities

6 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.66 ms
(35.78%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.lastconection AS lastconection_4, t0.roles AS roles_5, t0.password AS password_6, t0.google_id AS google_id_7, t0.google_access_token AS google_access_token_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.is_verified AS is_verified_11, t0.def_menu AS def_menu_12, t0.akademikoak_fiels AS akademikoak_fiels_13, t0.pertsonalak_fields AS pertsonalak_fields_14 FROM user t0 WHERE t0.id = ? LIMIT 1

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.username AS username_3,
  t0.lastconection AS lastconection_4,
  t0.roles AS roles_5,
  t0.password AS password_6,
  t0.google_id AS google_id_7,
  t0.google_access_token AS google_access_token_8,
  t0.facebook_id AS facebook_id_9,
  t0.facebook_access_token AS facebook_access_token_10,
  t0.is_verified AS is_verified_11,
  t0.def_menu AS def_menu_12,
  t0.akademikoak_fiels AS akademikoak_fiels_13,
  t0.pertsonalak_fields AS pertsonalak_fields_14
FROM
  user t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.lastconection AS lastconection_4, t0.roles AS roles_5, t0.password AS password_6, t0.google_id AS google_id_7, t0.google_access_token AS google_access_token_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.is_verified AS is_verified_11, t0.def_menu AS def_menu_12, t0.akademikoak_fiels AS akademikoak_fiels_13, t0.pertsonalak_fields AS pertsonalak_fields_14 FROM user t0 WHERE t0.id = 2 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 157)
5	App\Security\MyEntityUserProvider->findUser (line 139)
6	App\Security\MyEntityUserProvider->refreshUser (line 212)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 129)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
10	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 61)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 91)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.59 ms
(32.24%)

SELECT t0.ID_baimena AS ID_baimena_1, t0.kodea AS kodea_2, t0.multxoa AS multxoa_3, t0.ordena AS ordena_4, t0.azalpena AS azalpena_5, t0.descripcion AS descripcion_6, t0.baimendutakorolak AS baimendutakorolak_7, t0.langilerola AS langilerola_8, t0.ID_menuitem AS ID_menuitem_9, t10.ID_menuitem AS ID_menuitem_11, t10.ordena AS ordena_12, t10.tagId AS tagId_13, t10.izena AS izena_14, t10.nombre AS nombre_15, t10.path AS path_16, t10.itxura AS itxura_17, t10.fontawesome AS fontawesome_18, t10.target AS target_19, t10.parentmenu AS parentmenu_20, t10.gutxienekobaimena AS gutxienekobaimena_21 FROM baimena t0 LEFT JOIN menuitem t10 ON t10.gutxienekobaimena = t0.ID_baimena WHERE t0.kodea = ? LIMIT 1

Parameters:

[
  "Jar_jarBe"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.ID_baimena AS ID_baimena_1,
  t0.kodea AS kodea_2,
  t0.multxoa AS multxoa_3,
  t0.ordena AS ordena_4,
  t0.azalpena AS azalpena_5,
  t0.descripcion AS descripcion_6,
  t0.baimendutakorolak AS baimendutakorolak_7,
  t0.langilerola AS langilerola_8,
  t0.ID_menuitem AS ID_menuitem_9,
  t10.ID_menuitem AS ID_menuitem_11,
  t10.ordena AS ordena_12,
  t10.tagId AS tagId_13,
  t10.izena AS izena_14,
  t10.nombre AS nombre_15,
  t10.path AS path_16,
  t10.itxura AS itxura_17,
  t10.fontawesome AS fontawesome_18,
  t10.target AS target_19,
  t10.parentmenu AS parentmenu_20,
  t10.gutxienekobaimena AS gutxienekobaimena_21
FROM
  baimena t0
  LEFT JOIN menuitem t10 ON t10.gutxienekobaimena = t0.ID_baimena
WHERE
  t0.kodea = ?
LIMIT
  1

SELECT t0.ID_baimena AS ID_baimena_1, t0.kodea AS kodea_2, t0.multxoa AS multxoa_3, t0.ordena AS ordena_4, t0.azalpena AS azalpena_5, t0.descripcion AS descripcion_6, t0.baimendutakorolak AS baimendutakorolak_7, t0.langilerola AS langilerola_8, t0.ID_menuitem AS ID_menuitem_9, t10.ID_menuitem AS ID_menuitem_11, t10.ordena AS ordena_12, t10.tagId AS tagId_13, t10.izena AS izena_14, t10.nombre AS nombre_15, t10.path AS path_16, t10.itxura AS itxura_17, t10.fontawesome AS fontawesome_18, t10.target AS target_19, t10.parentmenu AS parentmenu_20, t10.gutxienekobaimena AS gutxienekobaimena_21 FROM baimena t0 LEFT JOIN menuitem t10 ON t10.gutxienekobaimena = t0.ID_baimena WHERE t0.kodea = 'Jar_jarBe' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 235)
4	Doctrine\ORM\EntityRepository->resolveMagicCall (line 158)
5	Doctrine\ORM\EntityRepository->__call (line 95)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->__call (line 25)
7	App\Service\BaimenaService->isAuthorized (line 25)
8	App\Controller\AppBaseController->baimenaEgiaztatu (line 268)
9	App\Controller\JarraipenaController->gordeetxekolanaajaxAction (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.59 ms
(31.97%)

SELECT t0.ID_etxekolana AS ID_etxekolana_1, t0.izenburua AS izenburua_2, t0.oharra AS oharra_3, t0.databidalita AS databidalita_4, t0.datagainditua AS datagainditua_5, t0.beroketa AS beroketa_6, t0.emanaldirako AS emanaldirako_7, t0.gainditua AS gainditua_8, t0.ID_akademikoa AS ID_akademikoa_9, t0.ID_eskeintza AS ID_eskeintza_10, t0.ID_ikasgaia AS ID_ikasgaia_11, t0.ID_ikaslea AS ID_ikaslea_12, t0.ID_lana AS ID_lana_13 FROM etxekolana t0 WHERE t0.ID_etxekolana = ?

Parameters:

[
  "591"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.ID_etxekolana AS ID_etxekolana_1,
  t0.izenburua AS izenburua_2,
  t0.oharra AS oharra_3,
  t0.databidalita AS databidalita_4,
  t0.datagainditua AS datagainditua_5,
  t0.beroketa AS beroketa_6,
  t0.emanaldirako AS emanaldirako_7,
  t0.gainditua AS gainditua_8,
  t0.ID_akademikoa AS ID_akademikoa_9,
  t0.ID_eskeintza AS ID_eskeintza_10,
  t0.ID_ikasgaia AS ID_ikasgaia_11,
  t0.ID_ikaslea AS ID_ikaslea_12,
  t0.ID_lana AS ID_lana_13
FROM
  etxekolana t0
WHERE
  t0.ID_etxekolana = ?

SELECT t0.ID_etxekolana AS ID_etxekolana_1, t0.izenburua AS izenburua_2, t0.oharra AS oharra_3, t0.databidalita AS databidalita_4, t0.datagainditua AS datagainditua_5, t0.beroketa AS beroketa_6, t0.emanaldirako AS emanaldirako_7, t0.gainditua AS gainditua_8, t0.ID_akademikoa AS ID_akademikoa_9, t0.ID_eskeintza AS ID_eskeintza_10, t0.ID_ikasgaia AS ID_ikasgaia_11, t0.ID_ikaslea AS ID_ikaslea_12, t0.ID_lana AS ID_lana_13 FROM etxekolana t0 WHERE t0.ID_etxekolana = '591';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 758)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 366)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 270)
7	App\Controller\JarraipenaController->gordeetxekolanaajaxAction (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	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\Baimena	1
App\Entity\MenuItem	1
App\Entity\Etxekolana	1
App\Entity\Ikasgaia	1
App\Entity\Ikaslea	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Baimena	No errors.
App\Entity\MenuItem	No errors.
App\Entity\Etxekolana	No errors.
App\Entity\Akademikoa	No errors.
App\Entity\Eskeintza	No errors.
App\Entity\Ikasgaia	No errors.
App\Entity\Ikaslea	No errors.
App\Entity\Lana	No errors.
App\Entity\Kontzertua	No errors.

Symfony Profiler

POST https://dumde.roberto.eus/eu_ES/langilea/langilea/jarraipena/gordeetxekolanaajax

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping