Symfony Profiler

Query Metrics

7 Database Queries

3 Different statements

0.88 ms Query time

0 Invalid entities

37 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.50 ms
(57.25%)

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.id = ?

Parameters:

[
  79
]

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.id = ?

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.id = 79;

#	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\Source::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\Source->__get (line 40)
8	App\Entity\Source->getToken (line 288)
9	App\Controller\Api\ApiMessageController->getNbToRead (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)

0.19 ms
(21.89%)

SELECT m0_.id AS id_0, m0_.phone AS phone_1, m0_.state AS state_2, m0_.comment AS comment_3, m0_.stop_list AS stop_list_4, m0_.full_name AS full_name_5, m0_.delete_list AS delete_list_6, m0_.delete_list_date AS delete_list_date_7, m0_.stop_list_date AS stop_list_date_8, m0_.created_at AS created_at_9, m0_.token AS token_10, m0_.public_uuid AS public_uuid_11, m0_.source_id AS source_id_12, m0_.phone_tchat_id AS phone_tchat_id_13 FROM mew_contact m0_ INNER JOIN mew_message m1_ ON m0_.id = m1_.contact_id WHERE m1_.seen = 0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.phone AS phone_1,
  m0_.state AS state_2,
  m0_.comment AS comment_3,
  m0_.stop_list AS stop_list_4,
  m0_.full_name AS full_name_5,
  m0_.delete_list AS delete_list_6,
  m0_.delete_list_date AS delete_list_date_7,
  m0_.stop_list_date AS stop_list_date_8,
  m0_.created_at AS created_at_9,
  m0_.token AS token_10,
  m0_.public_uuid AS public_uuid_11,
  m0_.source_id AS source_id_12,
  m0_.phone_tchat_id AS phone_tchat_id_13
FROM
  mew_contact m0_
  INNER JOIN mew_message m1_ ON m0_.id = m1_.contact_id
WHERE
  m1_.seen = 0

SELECT m0_.id AS id_0, m0_.phone AS phone_1, m0_.state AS state_2, m0_.comment AS comment_3, m0_.stop_list AS stop_list_4, m0_.full_name AS full_name_5, m0_.delete_list AS delete_list_6, m0_.delete_list_date AS delete_list_date_7, m0_.stop_list_date AS stop_list_date_8, m0_.created_at AS created_at_9, m0_.token AS token_10, m0_.public_uuid AS public_uuid_11, m0_.source_id AS source_id_12, m0_.phone_tchat_id AS phone_tchat_id_13 FROM mew_contact m0_ INNER JOIN mew_message m1_ ON m0_.id = m1_.contact_id WHERE m1_.seen = 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 457)
7	App\Repository\ContactRepository->findNotRead (line 286)
8	App\Controller\Api\ApiMessageController->getNbToRead (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.18 ms
(20.86%)

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)

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\Contact	20
App\Entity\PhoneNumber	11
App\Entity\Source	5
App\Entity\User	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Source	No errors.
App\Entity\Message	No errors.
App\Entity\Contact	No errors.
App\Entity\PhoneNumber	No errors.
App\Entity\Tag	No errors.
App\Entity\Reminder	No errors.
App\Entity\ContactCampaign	No errors.
App\Entity\MessageQueue	No errors.
App\Entity\SourceOrigin	No errors.
App\Entity\TemplateMessage	No errors.
App\Entity\Campaign	No errors.
App\Entity\Stack	No errors.
App\Entity\SourceParameter	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.

Symfony Profiler

GET https://test-git.tchatbooster.com/api/message/get-nb-to-read

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping