Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

49.89 ms Query time

0 Invalid entities

40 Managed entities

Queries

Group similar statements

#▲

Time

Info

23.01 ms

SELECT count(DISTINCT b0_.id) AS sclr_0 FROM bt_users b0_ WHERE b0_.enabled = 1 AND LOWER(b0_.username_canonical) LIKE ?

Parameters:

[
  "r%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT b0_.id) AS sclr_0
FROM
  bt_users b0_
WHERE
  b0_.enabled = 1
  AND LOWER(b0_.username_canonical) LIKE ?

SELECT count(DISTINCT b0_.id) AS sclr_0 FROM bt_users b0_ WHERE b0_.enabled = 1 AND LOWER(b0_.username_canonical) LIKE 'r%';

#	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 1)
8	count (line 43)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerZvGhuxt\PaginatorProxyBa079e5->paginate (line 56)
16	App\Controller\DefaultController->memberlist (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

20.98 ms

SELECT DISTINCT b0_.id AS id_0, b0_.username_canonical AS username_canonical_1 FROM bt_users b0_ WHERE b0_.enabled = 1 AND LOWER(b0_.username_canonical) LIKE ? ORDER BY b0_.username_canonical ASC LIMIT 40

Parameters:

[
  "r%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT b0_.id AS id_0,
  b0_.username_canonical AS username_canonical_1
FROM
  bt_users b0_
WHERE
  b0_.enabled = 1
  AND LOWER(b0_.username_canonical) LIKE ?
ORDER BY
  b0_.username_canonical ASC
LIMIT
  40

SELECT DISTINCT b0_.id AS id_0, b0_.username_canonical AS username_canonical_1 FROM bt_users b0_ WHERE b0_.enabled = 1 AND LOWER(b0_.username_canonical) LIKE 'r%' ORDER BY b0_.username_canonical ASC LIMIT 40;

#	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 127)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerZvGhuxt\PaginatorProxyBa079e5->paginate (line 56)
16	App\Controller\DefaultController->memberlist (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

1.73 ms

SELECT b0_.id AS id_0, b0_.username AS username_1, b0_.username_canonical AS username_canonical_2, b0_.old_username_canonical AS old_username_canonical_3, b0_.email AS email_4, b0_.email_canonical AS email_canonical_5, b0_.enabled AS enabled_6, b0_.salt AS salt_7, b0_.password AS password_8, b0_.last_login AS last_login_9, b0_.confirmation_token AS confirmation_token_10, b0_.password_requested_at AS password_requested_at_11, b0_.star AS star_12, b0_.roles AS roles_13, b0_.user_avatar AS user_avatar_14, b0_.user_regdate AS user_regdate_15, b0_.user_phone AS user_phone_16, b0_.user_trocs AS user_trocs_17, b0_.user_products AS user_products_18, b0_.user_moyenne AS user_moyenne_19, b0_.user_name AS user_name_20, b0_.user_first_name AS user_first_name_21, b0_.user_address AS user_address_22, b0_.user_complementary_address AS user_complementary_address_23, b0_.user_cp AS user_cp_24, b0_.user_city AS user_city_25, b0_.biography AS biography_26, b0_.facebook_id AS facebook_id_27, b0_.facebook_access_token AS facebook_access_token_28, b0_.twitter_id AS twitter_id_29, b0_.twitter_access_token AS twitter_access_token_30, b0_.wallet AS wallet_31, b0_.latitude AS latitude_32, b0_.longitude AS longitude_33 FROM bt_users b0_ WHERE b0_.enabled = 1 AND LOWER(b0_.username_canonical) LIKE ? AND b0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY b0_.username_canonical ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.username AS username_1,
  b0_.username_canonical AS username_canonical_2,
  b0_.old_username_canonical AS old_username_canonical_3,
  b0_.email AS email_4,
  b0_.email_canonical AS email_canonical_5,
  b0_.enabled AS enabled_6,
  b0_.salt AS salt_7,
  b0_.password AS password_8,
  b0_.last_login AS last_login_9,
  b0_.confirmation_token AS confirmation_token_10,
  b0_.password_requested_at AS password_requested_at_11,
  b0_.star AS star_12,
  b0_.roles AS roles_13,
  b0_.user_avatar AS user_avatar_14,
  b0_.user_regdate AS user_regdate_15,
  b0_.user_phone AS user_phone_16,
  b0_.user_trocs AS user_trocs_17,
  b0_.user_products AS user_products_18,
  b0_.user_moyenne AS user_moyenne_19,
  b0_.user_name AS user_name_20,
  b0_.user_first_name AS user_first_name_21,
  b0_.user_address AS user_address_22,
  b0_.user_complementary_address AS user_complementary_address_23,
  b0_.user_cp AS user_cp_24,
  b0_.user_city AS user_city_25,
  b0_.biography AS biography_26,
  b0_.facebook_id AS facebook_id_27,
  b0_.facebook_access_token AS facebook_access_token_28,
  b0_.twitter_id AS twitter_id_29,
  b0_.twitter_access_token AS twitter_access_token_30,
  b0_.wallet AS wallet_31,
  b0_.latitude AS latitude_32,
  b0_.longitude AS longitude_33
FROM
  bt_users b0_
WHERE
  b0_.enabled = 1
  AND LOWER(b0_.username_canonical) LIKE ?
  AND b0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  b0_.username_canonical ASC

SELECT b0_.id AS id_0, b0_.username AS username_1, b0_.username_canonical AS username_canonical_2, b0_.old_username_canonical AS old_username_canonical_3, b0_.email AS email_4, b0_.email_canonical AS email_canonical_5, b0_.enabled AS enabled_6, b0_.salt AS salt_7, b0_.password AS password_8, b0_.last_login AS last_login_9, b0_.confirmation_token AS confirmation_token_10, b0_.password_requested_at AS password_requested_at_11, b0_.star AS star_12, b0_.roles AS roles_13, b0_.user_avatar AS user_avatar_14, b0_.user_regdate AS user_regdate_15, b0_.user_phone AS user_phone_16, b0_.user_trocs AS user_trocs_17, b0_.user_products AS user_products_18, b0_.user_moyenne AS user_moyenne_19, b0_.user_name AS user_name_20, b0_.user_first_name AS user_first_name_21, b0_.user_address AS user_address_22, b0_.user_complementary_address AS user_complementary_address_23, b0_.user_cp AS user_cp_24, b0_.user_city AS user_city_25, b0_.biography AS biography_26, b0_.facebook_id AS facebook_id_27, b0_.facebook_access_token AS facebook_access_token_28, b0_.twitter_id AS twitter_id_29, b0_.twitter_access_token AS twitter_access_token_30, b0_.wallet AS wallet_31, b0_.latitude AS latitude_32, b0_.longitude AS longitude_33 FROM bt_users b0_ WHERE b0_.enabled = 1 AND LOWER(b0_.username_canonical) LIKE 'r%' AND b0_.id IN (7482, 6636, 5979, 6555, 5012, 4808, 5755, 2777, 8469, 1032, 1154, 6953, 6922, 3107, 6822, 7478, 2232, 5920, 8041, 1004, 1476, 6933, 1831, 998, 7712, 341, 6994, 8276, 4857, 183, 6984, 991, 1938, 6718, 7376, 5110, 4049, 6816, 6425, 7431) ORDER BY b0_.username_canonical 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 145)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerZvGhuxt\PaginatorProxyBa079e5->paginate (line 56)
16	App\Controller\DefaultController->memberlist (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

4.17 ms

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.lft AS lft_2, b0_.lvl AS lvl_3, b0_.rgt AS rgt_4, b0_.slug AS slug_5, b0_.nb_products AS nb_products_6 FROM bt_categories b0_ ORDER BY b0_.root_id ASC, b0_.lft ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.title AS title_1,
  b0_.lft AS lft_2,
  b0_.lvl AS lvl_3,
  b0_.rgt AS rgt_4,
  b0_.slug AS slug_5,
  b0_.nb_products AS nb_products_6
FROM
  bt_categories b0_
ORDER BY
  b0_.root_id ASC,
  b0_.lft ASC

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.lft AS lft_2, b0_.lvl AS lvl_3, b0_.rgt AS rgt_4, b0_.slug AS slug_5, b0_.nb_products AS nb_products_6 FROM bt_categories b0_ ORDER BY b0_.root_id ASC, b0_.lft 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 701)
6	Doctrine\ORM\AbstractQuery->getArrayResult (line 1084)
7	Gedmo\Tree\Entity\Repository\NestedTreeRepository->getNodesHierarchy (line 88)
8	Gedmo\Tree\RepositoryUtils->childrenHierarchy (line 138)
9	Gedmo\Tree\Entity\Repository\AbstractTreeRepository->childrenHierarchy (line 25)
10	App\Controller\IncludesController->menu (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
13	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
14	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
15	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
16	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
17	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 194)
18	__TwigTemplate_86a39c94f5100e54fda29fd7a5dfe4e3->doDisplay (line 388)
19	Twig\Template->yield (line 54)
20	__TwigTemplate_fed9039dd3fe6d3279bc4aa8e6bfc4a7->doDisplay (line 388)
21	Twig\Template->yield (line 344)
22	Twig\Template->display (line 359)
23	Twig\Template->render (line 51)
24	Twig\TemplateWrapper->render (line 334)
25	Twig\Environment->render (line 431)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 62)
29	App\Controller\DefaultController->memberlist (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	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	40

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Product	No errors.
App\Entity\Evaluation	No errors.
App\Entity\Favorite	No errors.
App\Entity\Transaction	No errors.
App\Entity\NotificationType	No errors.
App\Entity\Category	No errors.
App\Entity\Brand	No errors.
App\Entity\TrocProduct	No errors.
App\Entity\Image	No errors.
App\Entity\Box	No errors.
App\Entity\Troc	No errors.
App\Entity\Message	No errors.
App\Entity\Department	No errors.
App\Entity\Notification	No errors.
Gedmo\Tree\Entity\MappedSuperclass\AbstractClosure	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://area51.beautytroc.fr/_fragment?_path=_format%3Dhtml%26_locale%3Dfr%26_controller%3DApp%255CController%255CIncludesController%253A%253Aloginform

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping