Symfony Profiler

Query Metrics

6 Database Queries

4 Different statements

1.64 ms Query time

0 Invalid entities

195 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.62 ms
(37.79%)

SELECT a0_.id AS id_0, a0_.setting_key AS setting_key_1, a0_.value AS value_2, a0_.tenant_id AS tenant_id_3 FROM app_setting a0_ WHERE (a0_.tenant_id = ?) AND (a0_.tenant_id = '1') ORDER BY a0_.setting_key ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.setting_key AS setting_key_1,
  a0_.value AS value_2,
  a0_.tenant_id AS tenant_id_3
FROM
  app_setting a0_
WHERE
  (a0_.tenant_id = ?)
  AND (a0_.tenant_id = '1')
ORDER BY
  a0_.setting_key ASC

SELECT a0_.id AS id_0, a0_.setting_key AS setting_key_1, a0_.value AS value_2, a0_.tenant_id AS tenant_id_3 FROM app_setting a0_ WHERE (a0_.tenant_id = 1) AND (a0_.tenant_id = '1') ORDER BY a0_.setting_key ASC;

#	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\AppSettingRepository->getAllAsArray (line 34)
7	App\Twig\AppSettingExtension->getGlobals (line 27)
8	Twig\ExtensionSet->getGlobals (line 365)
9	Twig\Environment->getGlobals (line 908)
10	Twig\Template->yield (line 398)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
18	App\Controller\AppAuthenticatorController->login (line 21)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 191)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 32)
24	require_once (line 5)

0.43 ms
(26.55%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.address_line1 AS address_line1_4, t0.address_line2 AS address_line2_5, t0.postal_code AS postal_code_6, t0.city AS city_7, t0.country AS country_8, t0.siret AS siret_9, t0.vat_number AS vat_number_10, t0.invoice_footer AS invoice_footer_11, t0.domains AS domains_12, t0.is_active AS is_active_13, t0.created_at AS created_at_14 FROM tenant t0 WHERE t0.slug = ? AND t0.is_active = ? LIMIT 1

Parameters:

[
  "accomplus"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.address_line1 AS address_line1_4,
  t0.address_line2 AS address_line2_5,
  t0.postal_code AS postal_code_6,
  t0.city AS city_7,
  t0.country AS country_8,
  t0.siret AS siret_9,
  t0.vat_number AS vat_number_10,
  t0.invoice_footer AS invoice_footer_11,
  t0.domains AS domains_12,
  t0.is_active AS is_active_13,
  t0.created_at AS created_at_14
FROM
  tenant t0
WHERE
  t0.slug = ?
  AND t0.is_active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.address_line1 AS address_line1_4, t0.address_line2 AS address_line2_5, t0.postal_code AS postal_code_6, t0.city AS city_7, t0.country AS country_8, t0.siret AS siret_9, t0.vat_number AS vat_number_10, t0.invoice_footer AS invoice_footer_11, t0.domains AS domains_12, t0.is_active AS is_active_13, t0.created_at AS created_at_14 FROM tenant t0 WHERE t0.slug = 'accomplus' AND t0.is_active = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findOneBy (line 86)
4	App\Repository\TenantRepository->findDefault (line 35)
5	App\EventSubscriber\TenantRequestSubscriber->onKernelController (line 45)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 191)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

0.31 ms
(18.81%)

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.slug AS slug_2, t0_.address_line1 AS address_line1_3, t0_.address_line2 AS address_line2_4, t0_.postal_code AS postal_code_5, t0_.city AS city_6, t0_.country AS country_7, t0_.siret AS siret_8, t0_.vat_number AS vat_number_9, t0_.invoice_footer AS invoice_footer_10, t0_.domains AS domains_11, t0_.is_active AS is_active_12, t0_.created_at AS created_at_13 FROM tenant t0_ WHERE t0_.is_active = ? AND t0_.domains LIKE ? LIMIT 1

Parameters:

[
  1
  "%"dep.accomplus.fr"%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.slug AS slug_2,
  t0_.address_line1 AS address_line1_3,
  t0_.address_line2 AS address_line2_4,
  t0_.postal_code AS postal_code_5,
  t0_.city AS city_6,
  t0_.country AS country_7,
  t0_.siret AS siret_8,
  t0_.vat_number AS vat_number_9,
  t0_.invoice_footer AS invoice_footer_10,
  t0_.domains AS domains_11,
  t0_.is_active AS is_active_12,
  t0_.created_at AS created_at_13
FROM
  tenant t0_
WHERE
  t0_.is_active = ?
  AND t0_.domains LIKE ?
LIMIT
  1

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.slug AS slug_2, t0_.address_line1 AS address_line1_3, t0_.address_line2 AS address_line2_4, t0_.postal_code AS postal_code_5, t0_.city AS city_6, t0_.country AS country_7, t0_.siret AS siret_8, t0_.vat_number AS vat_number_9, t0_.invoice_footer AS invoice_footer_10, t0_.domains AS domains_11, t0_.is_active AS is_active_12, t0_.created_at AS created_at_13 FROM tenant t0_ WHERE t0_.is_active = 1 AND t0_.domains LIKE '%\"dep.accomplus.fr\"%' LIMIT 1;

#	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->getOneOrNullResult (line 737)
6	App\Repository\TenantRepository->findOneByDomain (line 30)
7	App\EventSubscriber\TenantRequestSubscriber->onKernelController (line 44)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 191)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 32)
17	require_once (line 5)

0.28 ms
(16.84%)

SELECT value FROM app_setting WHERE tenant_id = ? AND setting_key = ? LIMIT 1

Parameters:

[
  1
  "admin_logo"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  value
FROM
  app_setting
WHERE
  tenant_id = ?
  AND setting_key = ?
LIMIT
  1

SELECT value FROM app_setting WHERE tenant_id = 1 AND setting_key = 'admin_logo' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	App\Repository\AppSettingRepository->getRawForTenantId (line 58)
3	App\Twig\AppSettingExtension->getGlobals (line 40)
4	Twig\ExtensionSet->getGlobals (line 365)
5	Twig\Environment->getGlobals (line 908)
6	Twig\Template->yield (line 398)
7	Twig\Template->display (line 358)
8	Twig\Template->render (line 373)
9	Twig\TemplateWrapper->render (line 51)
10	Twig\Environment->render (line 333)
11	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
12	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
14	App\Controller\AppAuthenticatorController->login (line 21)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 191)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
19	require_once (line 32)
20	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\AppSetting	194
App\Entity\Tenant	1

Entities Mapping

Class	Mapping errors
App\Entity\Tenant	No errors.
App\Entity\AppSetting	No errors.

Symfony Profiler

GET http://dep.accomplus.fr/login

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping