Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

2.11 ms Query time

0 Invalid entities

5 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.76 ms
(35.97%)

SELECT d0_.domain AS domain_0, d0_.activity AS activity_1, d0_.id AS id_2, d0_.created AS created_3, d0_.modified AS modified_4, d0_.company_name AS company_name_5, d0_.company_address AS company_address_6, d0_.primary_email AS primary_email_7, d0_.support_email AS support_email_8, d0_.sales_email AS sales_email_9, d0_.telegram AS telegram_10, d0_.vk AS vk_11, d0_.contact_person AS contact_person_12, d0_.contract_no AS contract_no_13, d0_.label_name AS label_name_14, d0_.label_country AS label_country_15, d0_.personal_percentage AS personal_percentage_16, d0_.percentage AS percentage_17, d0_.inside_percentage AS inside_percentage_18, d0_.type AS type_19, d0_.policies_id AS policies_id_20, d0_.terms_id AS terms_id_21, d0_.privacy_id AS privacy_id_22 FROM domains d0_ WHERE (d0_.domain = ?) AND d0_.type IN ('CUSTOM_DOMAIN', 'LABEL_DOMAIN')

Parameters:

[
  "dev.musicdistributions.com"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.domain AS domain_0,
  d0_.activity AS activity_1,
  d0_.id AS id_2,
  d0_.created AS created_3,
  d0_.modified AS modified_4,
  d0_.company_name AS company_name_5,
  d0_.company_address AS company_address_6,
  d0_.primary_email AS primary_email_7,
  d0_.support_email AS support_email_8,
  d0_.sales_email AS sales_email_9,
  d0_.telegram AS telegram_10,
  d0_.vk AS vk_11,
  d0_.contact_person AS contact_person_12,
  d0_.contract_no AS contract_no_13,
  d0_.label_name AS label_name_14,
  d0_.label_country AS label_country_15,
  d0_.personal_percentage AS personal_percentage_16,
  d0_.percentage AS percentage_17,
  d0_.inside_percentage AS inside_percentage_18,
  d0_.type AS type_19,
  d0_.policies_id AS policies_id_20,
  d0_.terms_id AS terms_id_21,
  d0_.privacy_id AS privacy_id_22
FROM
  domains d0_
WHERE
  (d0_.domain = ?)
  AND d0_.type IN ('CUSTOM_DOMAIN', 'LABEL_DOMAIN')

SELECT d0_.domain AS domain_0, d0_.activity AS activity_1, d0_.id AS id_2, d0_.created AS created_3, d0_.modified AS modified_4, d0_.company_name AS company_name_5, d0_.company_address AS company_address_6, d0_.primary_email AS primary_email_7, d0_.support_email AS support_email_8, d0_.sales_email AS sales_email_9, d0_.telegram AS telegram_10, d0_.vk AS vk_11, d0_.contact_person AS contact_person_12, d0_.contract_no AS contract_no_13, d0_.label_name AS label_name_14, d0_.label_country AS label_country_15, d0_.personal_percentage AS personal_percentage_16, d0_.percentage AS percentage_17, d0_.inside_percentage AS inside_percentage_18, d0_.type AS type_19, d0_.policies_id AS policies_id_20, d0_.terms_id AS terms_id_21, d0_.privacy_id AS privacy_id_22 FROM domains d0_ WHERE (d0_.domain = 'dev.musicdistributions.com') AND d0_.type IN ('CUSTOM_DOMAIN', 'LABEL_DOMAIN');

#	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\DomainRepository->findDomain (line 34)
7	App\Service\Context\ContextFactory->createInstance (line 58)
8	App\Service\Context\ContextFactory->getInstance (line 42)
9	ContainerDVD6AUz\App_KernelDevDebugContainer->getContextService (line 1057)
10	ContainerDVD6AUz\App_KernelDevDebugContainer::getKernel2Service (line 1025)
11	ContainerDVD6AUz\App_KernelDevDebugContainer::ContainerDVD6AUz\{closure} (line 799)
12	Symfony\Component\EventDispatcher\EventDispatcher::sortListeners (line 221)
13	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 70)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 256)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 120)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 193)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 32)
21	require_once (line 5)

0.69 ms
(32.80%)

SELECT d0_.domain AS domain_0, d0_.activity AS activity_1, d0_.id AS id_2, d0_.created AS created_3, d0_.modified AS modified_4, d0_.company_name AS company_name_5, d0_.company_address AS company_address_6, d0_.primary_email AS primary_email_7, d0_.support_email AS support_email_8, d0_.sales_email AS sales_email_9, d0_.telegram AS telegram_10, d0_.vk AS vk_11, d0_.contact_person AS contact_person_12, d0_.contract_no AS contract_no_13, d0_.label_name AS label_name_14, d0_.label_country AS label_country_15, d0_.personal_percentage AS personal_percentage_16, d0_.percentage AS percentage_17, d0_.inside_percentage AS inside_percentage_18, d0_.type AS type_19, d0_.policies_id AS policies_id_20, d0_.terms_id AS terms_id_21, d0_.privacy_id AS privacy_id_22 FROM domains d0_ WHERE (d0_.activity = 1 AND d0_.domain = ?) AND d0_.type IN ('LABEL_DOMAIN')

Parameters:

[
  "dev.musicdistributions.com"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.domain AS domain_0,
  d0_.activity AS activity_1,
  d0_.id AS id_2,
  d0_.created AS created_3,
  d0_.modified AS modified_4,
  d0_.company_name AS company_name_5,
  d0_.company_address AS company_address_6,
  d0_.primary_email AS primary_email_7,
  d0_.support_email AS support_email_8,
  d0_.sales_email AS sales_email_9,
  d0_.telegram AS telegram_10,
  d0_.vk AS vk_11,
  d0_.contact_person AS contact_person_12,
  d0_.contract_no AS contract_no_13,
  d0_.label_name AS label_name_14,
  d0_.label_country AS label_country_15,
  d0_.personal_percentage AS personal_percentage_16,
  d0_.percentage AS percentage_17,
  d0_.inside_percentage AS inside_percentage_18,
  d0_.type AS type_19,
  d0_.policies_id AS policies_id_20,
  d0_.terms_id AS terms_id_21,
  d0_.privacy_id AS privacy_id_22
FROM
  domains d0_
WHERE
  (
    d0_.activity = 1
    AND d0_.domain = ?
  )
  AND d0_.type IN ('LABEL_DOMAIN')

SELECT d0_.domain AS domain_0, d0_.activity AS activity_1, d0_.id AS id_2, d0_.created AS created_3, d0_.modified AS modified_4, d0_.company_name AS company_name_5, d0_.company_address AS company_address_6, d0_.primary_email AS primary_email_7, d0_.support_email AS support_email_8, d0_.sales_email AS sales_email_9, d0_.telegram AS telegram_10, d0_.vk AS vk_11, d0_.contact_person AS contact_person_12, d0_.contract_no AS contract_no_13, d0_.label_name AS label_name_14, d0_.label_country AS label_country_15, d0_.personal_percentage AS personal_percentage_16, d0_.percentage AS percentage_17, d0_.inside_percentage AS inside_percentage_18, d0_.type AS type_19, d0_.policies_id AS policies_id_20, d0_.terms_id AS terms_id_21, d0_.privacy_id AS privacy_id_22 FROM domains d0_ WHERE (d0_.activity = 1 AND d0_.domain = 'dev.musicdistributions.com') AND d0_.type IN ('LABEL_DOMAIN');

#	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\Domain\WhiteLabelRepository->findDomain (line 38)
7	App\Service\Context\LabelContext->domain (line 49)
8	App\EventSubscriber\Kernel->checkDomain (line 77)
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	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 32)
18	require_once (line 5)

0.66 ms
(31.23%)

SELECT t0.telegram_user_id AS telegram_user_id_1, t0.username AS username_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.id AS id_5 FROM support_chats t0 WHERE t0.telegram_user_id = ? LIMIT 1

Parameters:

[
  473669895
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.telegram_user_id AS telegram_user_id_1,
  t0.username AS username_2,
  t0.first_name AS first_name_3,
  t0.last_name AS last_name_4,
  t0.id AS id_5
FROM
  support_chats t0
WHERE
  t0.telegram_user_id = ?
LIMIT
  1

SELECT t0.telegram_user_id AS telegram_user_id_1, t0.username AS username_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.id AS id_5 FROM support_chats t0 WHERE t0.telegram_user_id = 473669895 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\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\SuperAdmin\WebhookController->index (line 40)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	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\GeneratedDoc	3
App\Entity\Abstracts\Domain	1
App\Entity\SupportChat	1

Entities Mapping

Class	Mapping errors
App\Entity\Abstracts\Domain	No errors.
App\Entity\Domain\CustomDomain	No errors.
App\Entity\Domain\WhiteLabel	No errors.
App\Entity\GeneratedDoc	No errors.
App\Entity\Balance	No errors.
App\Entity\SupportChat	No errors.

Symfony Profiler

POST https://dev.musicdistributions.com/webhook/telegram

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping