Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

0.68 ms Query time

1 Invalid entities

5 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.21 ms

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.date_creation AS date_creation_7, t0.reset_password_token AS reset_password_token_8, t0.date_request_reset_password AS date_request_reset_password_9, t0.need_to_reset_password AS need_to_reset_password_10, t0.image_name AS image_name_11, t0.phone_number AS phone_number_12, t0.anonymous AS anonymous_13, t0.email_auth_code AS email_auth_code_14, t0.is_email_auth_enabled AS is_email_auth_enabled_15, t0.ignore_read AS ignore_read_16, t0.token AS token_17, t0.active AS active_18, t0.public_uuid AS public_uuid_19 FROM mew_user t0 WHERE t0.email = ? LIMIT 1

Parameters:

[
  "joachim@cupani.dev"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.date_creation AS date_creation_7,
  t0.reset_password_token AS reset_password_token_8,
  t0.date_request_reset_password AS date_request_reset_password_9,
  t0.need_to_reset_password AS need_to_reset_password_10,
  t0.image_name AS image_name_11,
  t0.phone_number AS phone_number_12,
  t0.anonymous AS anonymous_13,
  t0.email_auth_code AS email_auth_code_14,
  t0.is_email_auth_enabled AS is_email_auth_enabled_15,
  t0.ignore_read AS ignore_read_16,
  t0.token AS token_17,
  t0.active AS active_18,
  t0.public_uuid AS public_uuid_19
FROM
  mew_user t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.date_creation AS date_creation_7, t0.reset_password_token AS reset_password_token_8, t0.date_request_reset_password AS date_request_reset_password_9, t0.need_to_reset_password AS need_to_reset_password_10, t0.image_name AS image_name_11, t0.phone_number AS phone_number_12, t0.anonymous AS anonymous_13, t0.email_auth_code AS email_auth_code_14, t0.is_email_auth_enabled AS is_email_auth_enabled_15, t0.ignore_read AS ignore_read_16, t0.token AS token_17, t0.active AS active_18, t0.public_uuid AS public_uuid_19 FROM mew_user t0 WHERE t0.email = 'joachim@cupani.dev' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 54)
5	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 208)
6	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->loadUser (line 105)
7	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\{closure} (line 91)
8	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 56)
9	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 40)
10	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 115)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 178)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 156)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 138)
17	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 38)
18	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 58)
19	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
20	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
21	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 91)
22	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
23	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
24	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
25	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
26	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
27	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 7)

0.22 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.image_name AS image_name_3, t0.import_has_header AS import_has_header_4, t0.parameter_separator AS parameter_separator_5, t0.ftp_server AS ftp_server_6, t0.ftp_user AS ftp_user_7, t0.ftp_password AS ftp_password_8, t0.ftp_path AS ftp_path_9, t0.ftp_active AS ftp_active_10, t0.sftp_private_key AS sftp_private_key_11, t0.is_sftp AS is_sftp_12, t0.ftp_port AS ftp_port_13, t0.ftp_hours AS ftp_hours_14, t0.ftp_message AS ftp_message_15, t0.ftp_channel_type AS ftp_channel_type_16, t0.ftp_reminder1_active AS ftp_reminder1_active_17, t0.ftp_reminder1_message AS ftp_reminder1_message_18, t0.ftp_reminder1_hours AS ftp_reminder1_hours_19, t0.ftp_reminder2_active AS ftp_reminder2_active_20, t0.ftp_reminder2_message AS ftp_reminder2_message_21, t0.ftp_reminder2_hours AS ftp_reminder2_hours_22, t0.is_single_campaign_only AS is_single_campaign_only_23, t0.language AS language_24, t0.is_filter_active AS is_filter_active_25, t0.messages_condition AS messages_condition_26, t0.token AS token_27, t0.active AS active_28, t0.public_uuid AS public_uuid_29, t0.source_origin_id AS source_origin_id_30, t0.favorite_phone_number_id AS favorite_phone_number_id_31 FROM mew_source t0 WHERE t0.token = ? LIMIT 1

Parameters:

[
  "SIKBJOWBYZYE"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image_name AS image_name_3,
  t0.import_has_header AS import_has_header_4,
  t0.parameter_separator AS parameter_separator_5,
  t0.ftp_server AS ftp_server_6,
  t0.ftp_user AS ftp_user_7,
  t0.ftp_password AS ftp_password_8,
  t0.ftp_path AS ftp_path_9,
  t0.ftp_active AS ftp_active_10,
  t0.sftp_private_key AS sftp_private_key_11,
  t0.is_sftp AS is_sftp_12,
  t0.ftp_port AS ftp_port_13,
  t0.ftp_hours AS ftp_hours_14,
  t0.ftp_message AS ftp_message_15,
  t0.ftp_channel_type AS ftp_channel_type_16,
  t0.ftp_reminder1_active AS ftp_reminder1_active_17,
  t0.ftp_reminder1_message AS ftp_reminder1_message_18,
  t0.ftp_reminder1_hours AS ftp_reminder1_hours_19,
  t0.ftp_reminder2_active AS ftp_reminder2_active_20,
  t0.ftp_reminder2_message AS ftp_reminder2_message_21,
  t0.ftp_reminder2_hours AS ftp_reminder2_hours_22,
  t0.is_single_campaign_only AS is_single_campaign_only_23,
  t0.language AS language_24,
  t0.is_filter_active AS is_filter_active_25,
  t0.messages_condition AS messages_condition_26,
  t0.token AS token_27,
  t0.active AS active_28,
  t0.public_uuid AS public_uuid_29,
  t0.source_origin_id AS source_origin_id_30,
  t0.favorite_phone_number_id AS favorite_phone_number_id_31
FROM
  mew_source t0
WHERE
  t0.token = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.image_name AS image_name_3, t0.import_has_header AS import_has_header_4, t0.parameter_separator AS parameter_separator_5, t0.ftp_server AS ftp_server_6, t0.ftp_user AS ftp_user_7, t0.ftp_password AS ftp_password_8, t0.ftp_path AS ftp_path_9, t0.ftp_active AS ftp_active_10, t0.sftp_private_key AS sftp_private_key_11, t0.is_sftp AS is_sftp_12, t0.ftp_port AS ftp_port_13, t0.ftp_hours AS ftp_hours_14, t0.ftp_message AS ftp_message_15, t0.ftp_channel_type AS ftp_channel_type_16, t0.ftp_reminder1_active AS ftp_reminder1_active_17, t0.ftp_reminder1_message AS ftp_reminder1_message_18, t0.ftp_reminder1_hours AS ftp_reminder1_hours_19, t0.ftp_reminder2_active AS ftp_reminder2_active_20, t0.ftp_reminder2_message AS ftp_reminder2_message_21, t0.ftp_reminder2_hours AS ftp_reminder2_hours_22, t0.is_single_campaign_only AS is_single_campaign_only_23, t0.language AS language_24, t0.is_filter_active AS is_filter_active_25, t0.messages_condition AS messages_condition_26, t0.token AS token_27, t0.active AS active_28, t0.public_uuid AS public_uuid_29, t0.source_origin_id AS source_origin_id_30, t0.favorite_phone_number_id AS favorite_phone_number_id_31 FROM mew_source t0 WHERE t0.token = 'SIKBJOWBYZYE' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 69)
5	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
7	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 33)
8	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 175)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 7)

0.15 ms

SELECT t0.id AS id_1, t0.active AS active_2, t0.public_uuid AS public_uuid_3, t0.company_division_id AS company_division_id_4, t0.source_id AS source_id_5 FROM mew_company_division_source t0 WHERE t0.source_id = ?

Parameters:

[
  37
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.active AS active_2,
  t0.public_uuid AS public_uuid_3,
  t0.company_division_id AS company_division_id_4,
  t0.source_id AS source_id_5
FROM
  mew_company_division_source t0
WHERE
  t0.source_id = ?

SELECT t0.id AS id_1, t0.active AS active_2, t0.public_uuid AS public_uuid_3, t0.company_division_id AS company_division_id_4, t0.source_id AS source_id_5 FROM mew_company_division_source t0 WHERE t0.source_id = 37;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 251)
8	App\Controller\Api\ApiSourceController->getDataApiList (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 7)

0.10 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.active_export_lead_by_mail AS active_export_lead_by_mail_3, t0.mail_export_lead_by_mail AS mail_export_lead_by_mail_4, t0.object_export_lead_by_mail AS object_export_lead_by_mail_5, t0.api_lead_connector AS api_lead_connector_6, t0.api_lead_connector_source AS api_lead_connector_source_7, t0.api_lead_connector_usage AS api_lead_connector_usage_8, t0.api_lead_connector_context AS api_lead_connector_context_9, t0.reference AS reference_10, t0.token AS token_11, t0.public_uuid AS public_uuid_12, t0.company_id AS company_id_13 FROM mew_company_division t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active_export_lead_by_mail AS active_export_lead_by_mail_3,
  t0.mail_export_lead_by_mail AS mail_export_lead_by_mail_4,
  t0.object_export_lead_by_mail AS object_export_lead_by_mail_5,
  t0.api_lead_connector AS api_lead_connector_6,
  t0.api_lead_connector_source AS api_lead_connector_source_7,
  t0.api_lead_connector_usage AS api_lead_connector_usage_8,
  t0.api_lead_connector_context AS api_lead_connector_context_9,
  t0.reference AS reference_10,
  t0.token AS token_11,
  t0.public_uuid AS public_uuid_12,
  t0.company_id AS company_id_13
FROM
  mew_company_division t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.active_export_lead_by_mail AS active_export_lead_by_mail_3, t0.mail_export_lead_by_mail AS mail_export_lead_by_mail_4, t0.object_export_lead_by_mail AS object_export_lead_by_mail_5, t0.api_lead_connector AS api_lead_connector_6, t0.api_lead_connector_source AS api_lead_connector_source_7, t0.api_lead_connector_usage AS api_lead_connector_usage_8, t0.api_lead_connector_context AS api_lead_connector_context_9, t0.reference AS reference_10, t0.token AS token_11, t0.public_uuid AS public_uuid_12, t0.company_id AS company_id_13 FROM mew_company_division t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\CompanyDivision::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\CompanyDivision->__get (line 40)
8	App\Entity\CompanyDivision->getToken (line 252)
9	App\Controller\Api\ApiSourceController->getDataApiList (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 7)

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\User	1
App\Entity\Source	1
App\Entity\CompanyDivisionSource	1
App\Entity\CompanyDivision	1
App\Entity\Company	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Source	No errors.
App\Entity\Message	No errors.
App\Entity\SourceOrigin	No errors.
App\Entity\PhoneNumber	No errors.
App\Entity\TemplateMessage	No errors.
App\Entity\Campaign	No errors.
App\Entity\Stack	No errors.
App\Entity\Tag	No errors.
App\Entity\SourceParameter	No errors.
App\Entity\Contact	No errors.
App\Entity\Reminder	No errors.
App\Entity\BlackListGroup	No errors.
App\Entity\BlackListContact	No errors.
App\Entity\CompanyDivisionSource	No errors.
App\Entity\UnmatchedContact	No errors.
App\Entity\ImportFilterStats	No errors.
App\Entity\SourceFilterItem	No errors.
App\Entity\ContactApi	No errors.
App\Entity\CompanyDivision	The field App\Entity\CompanyDivision#sourceFilterItems is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SourceFilterItem#companyDivision does not contain the required 'inversedBy="sourceFilterItems"' attribute.
App\Entity\Company	No errors.
App\Entity\CompanyDivisionContact	No errors.

Symfony Profiler

GET https://test-git.tchatbooster.com/api/source/get-data-api-list/SIKBJOWBYZYE

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping