Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

4.11 ms Query time

0 Invalid entities

6 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.67 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	ContainerZ7Lhtts\App_KernelDevDebugContainer->getContextService (line 1056)
10	ContainerZ7Lhtts\App_KernelDevDebugContainer::getKernel2Service (line 1024)
11	ContainerZ7Lhtts\App_KernelDevDebugContainer::ContainerZ7Lhtts\{closure} (line 798)
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.61 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)

2.84 ms

SELECT t0.ip AS ip_1, t0.strike AS strike_2, t0.last_activity AS last_activity_3, t0.password AS password_4, t0.roles AS roles_5, t0.first_name AS first_name_6, t0.middle_name AS middle_name_7, t0.last_name AS last_name_8, t0.email AS email_9, t0.phone AS phone_10, t0.country AS country_11, t0.activity AS activity_12, t0.id AS id_13, t0.created AS created_14, t0.modified AS modified_15, t0.percentage AS percentage_16, t0.inside_percentage AS inside_percentage_17, t19.verified_email AS verified_email_18, t19.id AS id_20, t19.created AS created_21, t19.modified AS modified_22, t19.user_id AS user_id_23, t0.context_id AS context_id_24, t0.referral_id AS referral_id_25, t0.discr FROM users t0 LEFT JOIN kyc t19 ON t19.user_id = t0.id WHERE t0.email = ? AND t0.context_id = ? AND t0.discr IN ('user') LIMIT 1

Parameters:

[
  "reload.core@gmail.com"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.ip AS ip_1,
  t0.strike AS strike_2,
  t0.last_activity AS last_activity_3,
  t0.password AS password_4,
  t0.roles AS roles_5,
  t0.first_name AS first_name_6,
  t0.middle_name AS middle_name_7,
  t0.last_name AS last_name_8,
  t0.email AS email_9,
  t0.phone AS phone_10,
  t0.country AS country_11,
  t0.activity AS activity_12,
  t0.id AS id_13,
  t0.created AS created_14,
  t0.modified AS modified_15,
  t0.percentage AS percentage_16,
  t0.inside_percentage AS inside_percentage_17,
  t19.verified_email AS verified_email_18,
  t19.id AS id_20,
  t19.created AS created_21,
  t19.modified AS modified_22,
  t19.user_id AS user_id_23,
  t0.context_id AS context_id_24,
  t0.referral_id AS referral_id_25,
  t0.discr
FROM
  users t0
  LEFT JOIN kyc t19 ON t19.user_id = t0.id
WHERE
  t0.email = ?
  AND t0.context_id = ?
  AND t0.discr IN ('user')
LIMIT
  1

SELECT t0.ip AS ip_1, t0.strike AS strike_2, t0.last_activity AS last_activity_3, t0.password AS password_4, t0.roles AS roles_5, t0.first_name AS first_name_6, t0.middle_name AS middle_name_7, t0.last_name AS last_name_8, t0.email AS email_9, t0.phone AS phone_10, t0.country AS country_11, t0.activity AS activity_12, t0.id AS id_13, t0.created AS created_14, t0.modified AS modified_15, t0.percentage AS percentage_16, t0.inside_percentage AS inside_percentage_17, t19.verified_email AS verified_email_18, t19.id AS id_20, t19.created AS created_21, t19.modified AS modified_22, t19.user_id AS user_id_23, t0.context_id AS context_id_24, t0.referral_id AS referral_id_25, t0.discr FROM users t0 LEFT JOIN kyc t19 ON t19.user_id = t0.id WHERE t0.email = 'reload.core@gmail.com' AND t0.context_id = 1 AND t0.discr IN ('user') 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\Security\WhiteLabelAuthenticator->App\Security\{closure} (line 64)
5	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 97)
6	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 56)
7	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 40)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 189)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
15	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
16	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
17	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
18	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
19	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
20	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 193)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 32)
30	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\Abstracts\User	1
App\Entity\Kyc	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\Abstracts\User	No errors.
App\Entity\User	No errors.
App\Entity\Kyc	No errors.
App\Entity\Release	No errors.
App\Entity\PaymentInfo	No errors.

Symfony Profiler

POST https://dev.musicdistributions.com/login

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping