Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

8.38 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.26 ms
(50.88%)

SELECT o0_.id AS id_0, o0_.organization_id AS organization_id_1, o0_.domain AS domain_2, o0_.verified AS verified_3, o0_.created_at AS created_at_4, o0_.status AS status_5, o0_.dns_ready AS dns_ready_6, o0_.status_detail AS status_detail_7, o0_.verification_token AS verification_token_8, o0_.status_changed_at AS status_changed_at_9 FROM organization_domains o0_ WHERE o0_.domain = ?

Parameters:

[
  "tokii.fr"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  o0_.id AS id_0,
  o0_.organization_id AS organization_id_1,
  o0_.domain AS domain_2,
  o0_.verified AS verified_3,
  o0_.created_at AS created_at_4,
  o0_.status AS status_5,
  o0_.dns_ready AS dns_ready_6,
  o0_.status_detail AS status_detail_7,
  o0_.verification_token AS verification_token_8,
  o0_.status_changed_at AS status_changed_at_9
FROM
  organization_domains o0_
WHERE
  o0_.domain = ?

SELECT o0_.id AS id_0, o0_.organization_id AS organization_id_1, o0_.domain AS domain_2, o0_.verified AS verified_3, o0_.created_at AS created_at_4, o0_.status AS status_5, o0_.dns_ready AS dns_ready_6, o0_.status_detail AS status_detail_7, o0_.verification_token AS verification_token_8, o0_.status_changed_at AS status_changed_at_9 FROM organization_domains o0_ WHERE o0_.domain = 'tokii.fr';

#	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\Identity\Infrastructure\Persistence\Doctrine\DoctrineOrganizationDomainRepository->findByHost (line 39)
7	App\Identity\Application\Query\GetOrganizationByDomain\GetOrganizationByDomainHandler->__invoke (line 48)
8	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 148)
9	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 90)
10	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 75)
11	Symfony\Component\Messenger\Middleware\DeduplicateMiddleware->handle (line 28)
12	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
13	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
14	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
15	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 35)
16	Symfony\Component\Messenger\Middleware\AddDefaultStampsMiddleware->handle (line 33)
17	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 36)
18	Symfony\Component\Messenger\MessageBus->dispatch (line 69)
19	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 42)
20	App\SharedKernel\Infrastructure\Bus\MessengerQueryBus->ask (line 22)
21	App\UI\Http\Listener\WhiteLabelResolverListener->{closure:App\UI\Http\Listener\WhiteLabelResolverListener::__invoke():89} (line 93)
22	Symfony\Component\Cache\Adapter\TraceableAdapter->{closure:Symfony\Component\Cache\Adapter\TraceableAdapter::get():54} (line 57)
23	Symfony\Component\Cache\LockRegistry->compute (line 112)
24	Symfony\Component\Cache\Adapter\AbstractAdapter::{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 102)
25	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 64)
26	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 85)
27	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
28	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
29	App\UI\Http\Listener\WhiteLabelResolverListener->__invoke (line 89)
30	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
31	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
32	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
33	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
36	Symfony\Component\HttpKernel\Kernel->handle (line 191)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
38	require_once (line 32)
39	require_once (line 5)

2.43 ms
(29.00%)

SELECT timezone FROM users WHERE id = ? AND account_type IN ('group', 'organization')

Parameters:

[
  "01a154cc-beb0-72dd-8312-040cb8716c73"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  timezone
FROM
  users
WHERE
  id = ?
  AND account_type IN ('group', 'organization')

SELECT timezone FROM users WHERE id = '01a154cc-beb0-72dd-8312-040cb8716c73' AND account_type IN ('group', 'organization');

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	App\Identity\Infrastructure\Adapter\DbalOrganizationTimeZones->read (line 74)
3	App\Identity\Infrastructure\Adapter\DbalOrganizationTimeZones->of (line 35)
4	App\Identity\Infrastructure\Adapter\DbalOrganizationTimeZones->ofConversation (line 46)
5	App\UI\Http\Listener\DisplayTimeZoneListener->zoneOf (line 67)
6	App\UI\Http\Listener\DisplayTimeZoneListener->__invoke (line 43)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 191)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	require_once (line 5)

1.41 ms
(16.85%)

SELECT group_id FROM channels WHERE id = ?

Parameters:

[
  "01a154d0-2c4c-78d1-a730-4ba0dee6cad0"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  group_id
FROM
  channels
WHERE
  id = ?

SELECT group_id FROM channels WHERE id = '01a154d0-2c4c-78d1-a730-4ba0dee6cad0';

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	App\Identity\Infrastructure\Adapter\DbalOrganizationTimeZones->ofConversation (line 44)
3	App\UI\Http\Listener\DisplayTimeZoneListener->zoneOf (line 67)
4	App\UI\Http\Listener\DisplayTimeZoneListener->__invoke (line 43)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 191)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

0.27 ms
(3.26%)

SET TIME ZONE 'UTC'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SET
  TIME ZONE 'UTC'

SET TIME ZONE 'UTC';

#	File/Call
1	Doctrine\DBAL\Connection->connect (line 222)
2	Doctrine\DBAL\Connection->executeQuery (line 792)
3	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
4	Doctrine\ORM\Query->_doExecute (line 296)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
6	Doctrine\ORM\AbstractQuery->execute (line 886)
7	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
8	App\Identity\Infrastructure\Persistence\Doctrine\DoctrineOrganizationDomainRepository->findByHost (line 39)
9	App\Identity\Application\Query\GetOrganizationByDomain\GetOrganizationByDomainHandler->__invoke (line 48)
10	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 148)
11	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 90)
12	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 75)
13	Symfony\Component\Messenger\Middleware\DeduplicateMiddleware->handle (line 28)
14	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
15	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
16	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
17	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 35)
18	Symfony\Component\Messenger\Middleware\AddDefaultStampsMiddleware->handle (line 33)
19	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 36)
20	Symfony\Component\Messenger\MessageBus->dispatch (line 69)
21	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 42)
22	App\SharedKernel\Infrastructure\Bus\MessengerQueryBus->ask (line 22)
23	App\UI\Http\Listener\WhiteLabelResolverListener->{closure:App\UI\Http\Listener\WhiteLabelResolverListener::__invoke():89} (line 93)
24	Symfony\Component\Cache\Adapter\TraceableAdapter->{closure:Symfony\Component\Cache\Adapter\TraceableAdapter::get():54} (line 57)
25	Symfony\Component\Cache\LockRegistry->compute (line 112)
26	Symfony\Component\Cache\Adapter\AbstractAdapter::{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 102)
27	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 64)
28	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 85)
29	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
30	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
31	App\UI\Http\Listener\WhiteLabelResolverListener->__invoke (line 89)
32	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
33	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
34	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
35	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
38	Symfony\Component\HttpKernel\Kernel->handle (line 191)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
40	require_once (line 32)
41	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

Entities Mapping

Class	Mapping errors
App\Identity\Domain\Model\OrganizationDomain	No errors.

GET https://tokii.fr/chat/01a154d0-2c4c-78d1-a730-4ba0dee6cad0

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping