Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

26.53 ms Query time

0 Invalid entities

4 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

15.41 ms
(58.11%)

SELECT a0_.id AS id_0, a0_.filename AS filename_1, a0_.mime_type AS mime_type_2, a0_.titre AS titre_3, a0_.description AS description_4, a0_.date_upload AS date_upload_5, a0_.storage_url AS storage_url_6, a0_.flickr AS flickr_7, a0_.storage_url_bdef AS storage_url_bdef_8, a0_.port AS port_9, a0_.ipad AS ipad_10, a0_.ordi AS ordi_11, a0_.user_proprio_id AS user_proprio_id_12 FROM album_docs a0_ LEFT JOIN album_categorie_album_docs a2_ ON a0_.id = a2_.album_docs_id LEFT JOIN album_categorie a1_ ON a1_.id = a2_.album_categorie_id LEFT JOIN mod_user m3_ ON a0_.user_proprio_id = m3_.id ORDER BY a0_.date_upload DESC LIMIT 12

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.filename AS filename_1,
  a0_.mime_type AS mime_type_2,
  a0_.titre AS titre_3,
  a0_.description AS description_4,
  a0_.date_upload AS date_upload_5,
  a0_.storage_url AS storage_url_6,
  a0_.flickr AS flickr_7,
  a0_.storage_url_bdef AS storage_url_bdef_8,
  a0_.port AS port_9,
  a0_.ipad AS ipad_10,
  a0_.ordi AS ordi_11,
  a0_.user_proprio_id AS user_proprio_id_12
FROM
  album_docs a0_
  LEFT JOIN album_categorie_album_docs a2_ ON a0_.id = a2_.album_docs_id
  LEFT JOIN album_categorie a1_ ON a1_.id = a2_.album_categorie_id
  LEFT JOIN mod_user m3_ ON a0_.user_proprio_id = m3_.id
ORDER BY
  a0_.date_upload DESC
LIMIT
  12

SELECT a0_.id AS id_0, a0_.filename AS filename_1, a0_.mime_type AS mime_type_2, a0_.titre AS titre_3, a0_.description AS description_4, a0_.date_upload AS date_upload_5, a0_.storage_url AS storage_url_6, a0_.flickr AS flickr_7, a0_.storage_url_bdef AS storage_url_bdef_8, a0_.port AS port_9, a0_.ipad AS ipad_10, a0_.ordi AS ordi_11, a0_.user_proprio_id AS user_proprio_id_12 FROM album_docs a0_ LEFT JOIN album_categorie_album_docs a2_ ON a0_.id = a2_.album_docs_id LEFT JOIN album_categorie a1_ ON a1_.id = a2_.album_categorie_id LEFT JOIN mod_user m3_ ON a0_.user_proprio_id = m3_.id ORDER BY a0_.date_upload DESC LIMIT 12;

#	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->getResult (line 688)
6	App\Repository\Album\AlbumDocsRepository->findFilteredAndSorted (line 194)
7	App\Controller\Album\DropboxController->admin_dropbox_newPage (line 603)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

9.77 ms
(36.84%)

SELECT a0_.id AS id_0, a0_.filename AS filename_1, a0_.mime_type AS mime_type_2, a0_.titre AS titre_3, a0_.description AS description_4, a0_.date_upload AS date_upload_5, a0_.storage_url AS storage_url_6, a0_.flickr AS flickr_7, a0_.storage_url_bdef AS storage_url_bdef_8, a0_.port AS port_9, a0_.ipad AS ipad_10, a0_.ordi AS ordi_11, a0_.user_proprio_id AS user_proprio_id_12 FROM album_docs a0_ LEFT JOIN album_categorie_album_docs a2_ ON a0_.id = a2_.album_docs_id LEFT JOIN album_categorie a1_ ON a1_.id = a2_.album_categorie_id LEFT JOIN mod_user m3_ ON a0_.user_proprio_id = m3_.id ORDER BY a0_.date_upload DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.filename AS filename_1,
  a0_.mime_type AS mime_type_2,
  a0_.titre AS titre_3,
  a0_.description AS description_4,
  a0_.date_upload AS date_upload_5,
  a0_.storage_url AS storage_url_6,
  a0_.flickr AS flickr_7,
  a0_.storage_url_bdef AS storage_url_bdef_8,
  a0_.port AS port_9,
  a0_.ipad AS ipad_10,
  a0_.ordi AS ordi_11,
  a0_.user_proprio_id AS user_proprio_id_12
FROM
  album_docs a0_
  LEFT JOIN album_categorie_album_docs a2_ ON a0_.id = a2_.album_docs_id
  LEFT JOIN album_categorie a1_ ON a1_.id = a2_.album_categorie_id
  LEFT JOIN mod_user m3_ ON a0_.user_proprio_id = m3_.id
ORDER BY
  a0_.date_upload DESC

SELECT a0_.id AS id_0, a0_.filename AS filename_1, a0_.mime_type AS mime_type_2, a0_.titre AS titre_3, a0_.description AS description_4, a0_.date_upload AS date_upload_5, a0_.storage_url AS storage_url_6, a0_.flickr AS flickr_7, a0_.storage_url_bdef AS storage_url_bdef_8, a0_.port AS port_9, a0_.ipad AS ipad_10, a0_.ordi AS ordi_11, a0_.user_proprio_id AS user_proprio_id_12 FROM album_docs a0_ LEFT JOIN album_categorie_album_docs a2_ ON a0_.id = a2_.album_docs_id LEFT JOIN album_categorie a1_ ON a1_.id = a2_.album_categorie_id LEFT JOIN mod_user m3_ ON a0_.user_proprio_id = m3_.id ORDER BY a0_.date_upload DESC;

#	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->getResult (line 688)
6	App\Repository\Album\AlbumDocsRepository->findFilteredAndSorted (line 194)
7	App\Controller\Album\DropboxController->admin_dropbox_newPage (line 599)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

1.34 ms
(5.04%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.telephone AS telephone_6, t0.cgu AS cgu_7, t0.actif AS actif_8, t0.date_crea AS date_crea_9, t0.date_modif AS date_modif_10, t0.code_verif AS code_verif_11, t0.prenom AS prenom_12, t0.nom AS nom_13, t0.societe AS societe_14 FROM mod_user t0 WHERE t0.id = ?

Parameters:

[
  615
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.email AS email_5,
  t0.telephone AS telephone_6,
  t0.cgu AS cgu_7,
  t0.actif AS actif_8,
  t0.date_crea AS date_crea_9,
  t0.date_modif AS date_modif_10,
  t0.code_verif AS code_verif_11,
  t0.prenom AS prenom_12,
  t0.nom AS nom_13,
  t0.societe AS societe_14
FROM
  mod_user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.telephone AS telephone_6, t0.cgu AS cgu_7, t0.actif AS actif_8, t0.date_crea AS date_crea_9, t0.date_modif AS date_modif_10, t0.code_verif AS code_verif_11, t0.prenom AS prenom_12, t0.nom AS nom_13, t0.societe AS societe_14 FROM mod_user t0 WHERE t0.id = 615;

#	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->__invoke (line 61)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 91)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 92)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 182)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	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\Album\AlbumDocs	3
App\Entity\ModUser	1

Entities Mapping

Class	Mapping errors
App\Entity\ModUser	No errors.
App\Entity\Album\AlbumDocs	No errors.
App\Entity\Album\AlbumCategorie	No errors.

Symfony Profiler

GET https://webgiciel.com/membre/dropbox/newPage?categorie=&page=1&query=&sort=&type=&user=

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping