Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.64 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

1.04 ms

SELECT t0.id AS id_1, t0.three_cx_id AS three_cx_id_2, t0.number AS number_3, t0.email AS email_4, t0.o365id AS o365id_5, t0.should_sync AS should_sync_6, t0.first_sync_at AS first_sync_at_7, t0.last_sync_at AS last_sync_at_8, t0.is_in_teams_call AS is_in_teams_call_9, t0.last_three_cx_status AS last_three_cx_status_10, t0.is_in_three_cx_call AS is_in_three_cx_call_11, t0.last_teams_status AS last_teams_status_12, t0.collaboration_id AS collaboration_id_13 FROM three_cx_account t0 WHERE t0.o365id = ? LIMIT 1

Parameters:

[
  "8894340f-301d-4938-8f13-11acfd794f5a"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.three_cx_id AS three_cx_id_2,
  t0.number AS number_3,
  t0.email AS email_4,
  t0.o365id AS o365id_5,
  t0.should_sync AS should_sync_6,
  t0.first_sync_at AS first_sync_at_7,
  t0.last_sync_at AS last_sync_at_8,
  t0.is_in_teams_call AS is_in_teams_call_9,
  t0.last_three_cx_status AS last_three_cx_status_10,
  t0.is_in_three_cx_call AS is_in_three_cx_call_11,
  t0.last_teams_status AS last_teams_status_12,
  t0.collaboration_id AS collaboration_id_13
FROM
  three_cx_account t0
WHERE
  t0.o365id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.three_cx_id AS three_cx_id_2, t0.number AS number_3, t0.email AS email_4, t0.o365id AS o365id_5, t0.should_sync AS should_sync_6, t0.first_sync_at AS first_sync_at_7, t0.last_sync_at AS last_sync_at_8, t0.is_in_teams_call AS is_in_teams_call_9, t0.last_three_cx_status AS last_three_cx_status_10, t0.is_in_three_cx_call AS is_in_three_cx_call_11, t0.last_teams_status AS last_teams_status_12, t0.collaboration_id AS collaboration_id_13 FROM three_cx_account t0 WHERE t0.o365id = '8894340f-301d-4938-8f13-11acfd794f5a' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 114)
4	App\Controller\O365Controller->handleSubscription (line 49)
5	App\Controller\O365Controller->o365subscriber (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.60 ms

SELECT t0.id AS id_1, t0.three_cx_fqdn AS three_cx_fqdn_2, t0.three_cx_username AS three_cx_username_3, t0.three_cx_password AS three_cx_password_4, t0.o365client_id AS o365client_id_5, t0.o365client_secret AS o365client_secret_6, t0.o365tenand_id AS o365tenand_id_7, t0.respect_in_ameeting AS respect_in_ameeting_8, t0.enabled AS enabled_9, t0.user_id AS user_id_10, t0.o_auth_token_id AS o_auth_token_id_11 FROM collaboration t0 WHERE t0.id = ?

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.three_cx_fqdn AS three_cx_fqdn_2,
  t0.three_cx_username AS three_cx_username_3,
  t0.three_cx_password AS three_cx_password_4,
  t0.o365client_id AS o365client_id_5,
  t0.o365client_secret AS o365client_secret_6,
  t0.o365tenand_id AS o365tenand_id_7,
  t0.respect_in_ameeting AS respect_in_ameeting_8,
  t0.enabled AS enabled_9,
  t0.user_id AS user_id_10,
  t0.o_auth_token_id AS o_auth_token_id_11
FROM
  collaboration t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.three_cx_fqdn AS three_cx_fqdn_2, t0.three_cx_username AS three_cx_username_3, t0.three_cx_password AS three_cx_password_4, t0.o365client_id AS o365client_id_5, t0.o365client_secret AS o365client_secret_6, t0.o365tenand_id AS o365tenand_id_7, t0.respect_in_ameeting AS respect_in_ameeting_8, t0.enabled AS enabled_9, t0.user_id AS user_id_10, t0.o_auth_token_id AS o_auth_token_id_11 FROM collaboration t0 WHERE t0.id = 7;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Collaboration::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\Collaboration->__get (line 68)
8	App\Entity\Collaboration->getThreeCxFqdn (line 18)
9	App\Services\ThreeCX->__construct (line 119)
10	App\Controller\O365Controller->handleSubscription (line 49)
11	App\Controller\O365Controller->o365subscriber (line 181)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	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.

Entities Mapping

Class	Mapping errors
App\Entity\ThreeCxAccount	No errors.
App\Entity\Collaboration	No errors.
App\Entity\User	No errors.
App\Entity\OAuthToken	No errors.
App\Entity\O365Subscription	No errors.

Symfony Profiler

POST https://testing.api.conbri.cloud/o365/subscriber

Configuration Settings

Theme