Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

4.74 ms Query time

0 Invalid entities

1 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.62 ms

SELECT u0_.id AS id_0, u0_.firstname AS firstname_1, u0_.lastname AS lastname_2, u0_.email AS email_3, u0_.phone AS phone_4, u0_.password AS password_5, u0_.account_name AS account_name_6, u0_.iban AS iban_7, u0_.bank_bic AS bank_bic_8, u0_.created_at AS created_at_9, u0_.last_login AS last_login_10, u0_.flags AS flags_11, u0_.roles AS roles_12, u0_.code AS code_13, u0_.locale AS locale_14, u0_.revolut_counterparty_id AS revolut_counterparty_id_15, u0_.accept_terms_at AS accept_terms_at_16 FROM user u0_ WHERE u0_.email = ?

Parameters:

[
  "marius.gherasie@machteamsoft.ro"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.firstname AS firstname_1,
  u0_.lastname AS lastname_2,
  u0_.email AS email_3,
  u0_.phone AS phone_4,
  u0_.password AS password_5,
  u0_.account_name AS account_name_6,
  u0_.iban AS iban_7,
  u0_.bank_bic AS bank_bic_8,
  u0_.created_at AS created_at_9,
  u0_.last_login AS last_login_10,
  u0_.flags AS flags_11,
  u0_.roles AS roles_12,
  u0_.code AS code_13,
  u0_.locale AS locale_14,
  u0_.revolut_counterparty_id AS revolut_counterparty_id_15,
  u0_.accept_terms_at AS accept_terms_at_16
FROM
  user u0_
WHERE
  u0_.email = ?

SELECT u0_.id AS id_0, u0_.firstname AS firstname_1, u0_.lastname AS lastname_2, u0_.email AS email_3, u0_.phone AS phone_4, u0_.password AS password_5, u0_.account_name AS account_name_6, u0_.iban AS iban_7, u0_.bank_bic AS bank_bic_8, u0_.created_at AS created_at_9, u0_.last_login AS last_login_10, u0_.flags AS flags_11, u0_.roles AS roles_12, u0_.code AS code_13, u0_.locale AS locale_14, u0_.revolut_counterparty_id AS revolut_counterparty_id_15, u0_.accept_terms_at AS accept_terms_at_16 FROM user u0_ WHERE u0_.email = 'marius.gherasie@machteamsoft.ro';

#	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 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 182)
7	App\Repository\UserRepository->loadUserByIdentifier (line 168)
8	App\Repository\UserRepository->refreshUser (line 82)
9	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 212)
10	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 129)
11	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
12	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
13	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 91)
14	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
15	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
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 14)

1.68 ms

SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.url AS url_2, w0_.domain AS domain_3, w0_.path AS path_4, w0_.locale AS locale_5, w0_.amount AS amount_6, w0_.currency AS currency_7, w0_.type AS type_8, w0_.status AS status_9, w0_.custom_css AS custom_css_10, w0_.background_image AS background_image_11, w0_.header_image AS header_image_12, w0_.created_at AS created_at_13, w0_.updated_at AS updated_at_14 FROM whitelabel_domain w0_ ORDER BY w0_.id DESC LIMIT 10

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  w0_.id AS id_0,
  w0_.name AS name_1,
  w0_.url AS url_2,
  w0_.domain AS domain_3,
  w0_.path AS path_4,
  w0_.locale AS locale_5,
  w0_.amount AS amount_6,
  w0_.currency AS currency_7,
  w0_.type AS type_8,
  w0_.status AS status_9,
  w0_.custom_css AS custom_css_10,
  w0_.background_image AS background_image_11,
  w0_.header_image AS header_image_12,
  w0_.created_at AS created_at_13,
  w0_.updated_at AS updated_at_14
FROM
  whitelabel_domain w0_
ORDER BY
  w0_.id DESC
LIMIT
  10

SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.url AS url_2, w0_.domain AS domain_3, w0_.path AS path_4, w0_.locale AS locale_5, w0_.amount AS amount_6, w0_.currency AS currency_7, w0_.type AS type_8, w0_.status AS status_9, w0_.custom_css AS custom_css_10, w0_.background_image AS background_image_11, w0_.header_image AS header_image_12, w0_.created_at AS created_at_13, w0_.updated_at AS updated_at_14 FROM whitelabel_domain w0_ ORDER BY w0_.id DESC LIMIT 10;

#	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 40)
7	App\Repository\Whitelabel\DomainsRepository->retrieveItems (line 38)
8	App\Controller\Admin\WhitelabelController->retrieveItems (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 14)

1.45 ms

SELECT COUNT(w0_.id) AS sclr_0 FROM whitelabel_domain w0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(w0_.id) AS sclr_0
FROM
  whitelabel_domain w0_

SELECT COUNT(w0_.id) AS sclr_0 FROM whitelabel_domain w0_;

#	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 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 25)
8	App\Repository\Whitelabel\DomainsRepository->retrieveItemsCount (line 47)
9	App\Controller\Admin\WhitelabelController->retrieveItems (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 14)

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	No errors.
App\Entity\UserCredentials	No errors.
App\Entity\TicketImport	No errors.
App\Entity\Order	No errors.
App\Entity\UserEmail	No errors.
App\Entity\MoneyTransfer	No errors.
App\Entity\LogEmail	No errors.
App\Entity\Whitelabel\Domain	No errors.

Symfony Profiler

GET https://marius.dabilet.machteam.ro/admin/whitelabel/custom-fields/retrieve?limit=10&offset=0

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping