Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

2.36 ms Query time

0 Invalid entities

5 Managed entities

Queries

Group similar statements

#▲

Time

Info

2.36 ms

SELECT u0_.name AS name_0, u0_.email AS email_1, u0_.password AS password_2, u0_.last_active AS last_active_3, u0_.avatar AS avatar_4, u0_.archived AS archived_5, u0_.sidebar_collapsed AS sidebar_collapsed_6, u0_.id AS id_7, u0_.uuid AS uuid_8, u0_.created AS created_9, u0_.modified AS modified_10, u0_.role_id AS role_id_11, u0_.location_id AS location_id_12 FROM users_user u0_ LEFT JOIN users_role u1_ ON u0_.role_id = u1_.id WHERE u0_.archived IS NULL AND u0_.archived IS NULL ORDER BY u0_.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.name AS name_0,
  u0_.email AS email_1,
  u0_.password AS password_2,
  u0_.last_active AS last_active_3,
  u0_.avatar AS avatar_4,
  u0_.archived AS archived_5,
  u0_.sidebar_collapsed AS sidebar_collapsed_6,
  u0_.id AS id_7,
  u0_.uuid AS uuid_8,
  u0_.created AS created_9,
  u0_.modified AS modified_10,
  u0_.role_id AS role_id_11,
  u0_.location_id AS location_id_12
FROM
  users_user u0_
  LEFT JOIN users_role u1_ ON u0_.role_id = u1_.id
WHERE
  u0_.archived IS NULL
  AND u0_.archived IS NULL
ORDER BY
  u0_.name ASC

SELECT u0_.name AS name_0, u0_.email AS email_1, u0_.password AS password_2, u0_.last_active AS last_active_3, u0_.avatar AS avatar_4, u0_.archived AS archived_5, u0_.sidebar_collapsed AS sidebar_collapsed_6, u0_.id AS id_7, u0_.uuid AS uuid_8, u0_.created AS created_9, u0_.modified AS modified_10, u0_.role_id AS role_id_11, u0_.location_id AS location_id_12 FROM users_user u0_ LEFT JOIN users_role u1_ ON u0_.role_id = u1_.id WHERE u0_.archived IS NULL AND u0_.archived IS NULL ORDER BY u0_.name ASC;

#	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 84)
7	WelshDev\Doctrix\BaseRepository->fetch (line 20)
8	App\Twig\AppExtension->getGlobals (line 359)
9	Twig\ExtensionSet->getGlobals (line 900)
10	Twig\Environment->getGlobals (line 398)
11	Twig\Template->yield (line 358)
12	Twig\Template->display (line 373)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 333)
15	Twig\Environment->render (line 459)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 39)
19	App\Controller\App\Auth\AuthController->login (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 11)

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\Users\User	3
App\Entity\Users\Role	1
App\Entity\Locations\Location	1

Entities Mapping

Class	Mapping errors
App\Entity\Users\User	No errors.
App\Entity\Users\Role	No errors.
App\Entity\Locations\Location	No errors.

Symfony Profiler

GET https://hudsonrose.cwd-mm.com/app/login

Configuration Settings

Theme

Page Width