Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

11.85 ms Query time

0 Invalid entities

6 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

5.00 ms
(42.23%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 382)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Controller\SuperAdmin\WebhookController->index (line 97)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 193)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 32)
9	require_once (line 5)

4.28 ms
(36.11%)

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)

0.77 ms
(6.53%)

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.77 ms
(6.53%)

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.75 ms
(6.31%)

INSERT INTO support_chat_messages (sender_type, text, file, file_name, created, chat_id) VALUES (?, ?, ?, ?, ?, ?)

Parameters:

[
  "user"
  ""
  "https://api.telegram.org/file/bot8174554772:AAGjXqV0r_a2I0GkOn_B3ItPLOJk5lntXV8/music/file_6.mp3"
  null
  "2025-12-10 09:46:19"
  2
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO support_chat_messages (
  sender_type, text, file, file_name,
  created, chat_id
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO support_chat_messages (sender_type, text, file, file_name, created, chat_id) VALUES ('user', '', 'https://api.telegram.org/file/bot8174554772:AAGjXqV0r_a2I0GkOn_B3ItPLOJk5lntXV8/music/file_6.mp3', NULL, '2025-12-10 09:46:19', 2);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 133)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1060)
4	Doctrine\ORM\UnitOfWork->commit (line 403)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Controller\SuperAdmin\WebhookController->index (line 97)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 193)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 5)

0.27 ms
(2.30%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 433)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Controller\SuperAdmin\WebhookController->index (line 97)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 193)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 32)
9	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
App\Entity\SupportChatMessage	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.
App\Entity\SupportChatMessage	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