Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

10.15 ms Query time

0 Invalid entities

4 Managed entities

Queries

Group similar statements

#▲

Time

Info

9.51 ms

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.65 ms

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)

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

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.

Symfony Profiler

GET https://dev.musicdistributions.com/

Configuration Settings

Theme

Page Width