Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.29 ms Query time

0 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

shared connection

Time▼

Count

Info

0.29 ms
(100.00%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.host AS host_2, c0_.dbUser AS dbUser_3, c0_.dbPassword AS dbPassword_4, c0_.dbUrl AS dbUrl_5, c0_.dbPort AS dbPort_6, c0_.dbName AS dbName_7, c0_.dbVersion AS dbVersion_8, c0_.shopUrl AS shopUrl_9 FROM company c0_ WHERE c0_.host = ?

Parameters:

[
  "api.preprod.macantine.ideelgarden.com"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.host AS host_2,
  c0_.dbUser AS dbUser_3,
  c0_.dbPassword AS dbPassword_4,
  c0_.dbUrl AS dbUrl_5,
  c0_.dbPort AS dbPort_6,
  c0_.dbName AS dbName_7,
  c0_.dbVersion AS dbVersion_8,
  c0_.shopUrl AS shopUrl_9
FROM
  company c0_
WHERE
  c0_.host = ?

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.host AS host_2, c0_.dbUser AS dbUser_3, c0_.dbPassword AS dbPassword_4, c0_.dbUrl AS dbUrl_5, c0_.dbPort AS dbPort_6, c0_.dbName AS dbName_7, c0_.dbVersion AS dbVersion_8, c0_.shopUrl AS shopUrl_9 FROM company c0_ WHERE c0_.host = 'api.preprod.macantine.ideelgarden.com';

#	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	Shared\Repository\CompanyRepository->findByHost (line 28)
7	Shared\Service\TenantResolver->getCurrentCompany (line 38)
8	Shared\EventSubscriber\TenantDetectionSubscriber->onKernelRequest (line 41)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 193)
16	{closure:/data/www/preprod_digitiz_api/apps/api/public/index.php:8} (line 11)
17	Symfony\Component\Runtime\Resolver\DebugClosureResolver::{closure:Symfony\Component\Runtime\Resolver\DebugClosureResolver::resolve():24} (line 25)
18	require_once (line 27)
19	require_once (line 6)

Database Connections

Name	Service
shared	doctrine.dbal.shared_connection
tenant	doctrine.dbal.tenant_connection

Entity Managers

Name	Service
shared	doctrine.orm.shared_entity_manager
tenant	doctrine.orm.tenant_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

shared entity manager

Class	Amount of managed objects
Shared\Entity\Company	1

tenant entity manager

Class	Amount of managed objects

Entities Mapping

shared entity manager

Class	Mapping errors
Shared\Entity\Company	No errors.

tenant entity manager

No loaded entities.

Symfony Profiler

HEAD https://api.preprod.macantine.ideelgarden.com/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

shared connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

shared entity manager

tenant entity manager

Entities Mapping

shared entity manager

tenant entity manager