Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

517.52 ms Query time

0 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

460.61 ms
(89.00%)

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_.source_id AS source_id_11, m0_.phone_tchat_id AS phone_tchat_id_12 FROM mew_contact m0_ LEFT JOIN mew_contact_campaign m1_ ON m0_.id = m1_.contact_id LEFT JOIN mew_campaign m2_ ON m1_.campaign_id = m2_.id LEFT JOIN mew_source m3_ ON m2_.source_id = m3_.id LEFT JOIN mew_message m4_ ON m0_.id = m4_.contact_id WHERE m4_.date >= ? AND m3_.token = ? AND m2_.token = ? AND (EXISTS (SELECT 1 AS sclr_13 FROM mew_message m5_ WHERE m5_.contact_id = m0_.id AND m5_.sender = ?)) ORDER BY m4_.date DESC

Parameters:

[
  "2026-04-01 16:58:03"
  "T1F01DCH98Z4"
  "1GB6O8AKQP8D"
  "contact"
]

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_.source_id AS source_id_11,
  m0_.phone_tchat_id AS phone_tchat_id_12
FROM
  mew_contact m0_
  LEFT JOIN mew_contact_campaign m1_ ON m0_.id = m1_.contact_id
  LEFT JOIN mew_campaign m2_ ON m1_.campaign_id = m2_.id
  LEFT JOIN mew_source m3_ ON m2_.source_id = m3_.id
  LEFT JOIN mew_message m4_ ON m0_.id = m4_.contact_id
WHERE
  m4_.date >= ?
  AND m3_.token = ?
  AND m2_.token = ?
  AND (
    EXISTS (
      SELECT
        1 AS sclr_13
      FROM
        mew_message m5_
      WHERE
        m5_.contact_id = m0_.id
        AND m5_.sender = ?
    )
  )
ORDER BY
  m4_.date DESC

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_.source_id AS source_id_11, m0_.phone_tchat_id AS phone_tchat_id_12 FROM mew_contact m0_ LEFT JOIN mew_contact_campaign m1_ ON m0_.id = m1_.contact_id LEFT JOIN mew_campaign m2_ ON m1_.campaign_id = m2_.id LEFT JOIN mew_source m3_ ON m2_.source_id = m3_.id LEFT JOIN mew_message m4_ ON m0_.id = m4_.contact_id WHERE m4_.date >= '2026-04-01 16:58:03' AND m3_.token = 'T1F01DCH98Z4' AND m2_.token = '1GB6O8AKQP8D' AND (EXISTS (SELECT 1 AS sclr_13 FROM mew_message m5_ WHERE m5_.contact_id = m0_.id AND m5_.sender = 'contact')) ORDER BY m4_.date DESC;

#	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 151)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 169)
8	Symfony\Component\Serializer\Serializer->normalize (line 131)
9	Symfony\Component\Serializer\Serializer->serialize (line 44)
10	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 204)
11	App\Controller\Api\ApiMessageController->getLast (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 7)

56.72 ms
(10.96%)

SELECT m0_.id AS id_0, m0_.text AS text_1, m0_.information AS information_2, m0_.date AS date_3, m0_.sender AS sender_4, m0_.seen AS seen_5, m0_.seen_date AS seen_date_6, m0_.date_received AS date_received_7, m0_.error_details AS error_details_8, m0_.error_number AS error_number_9, m0_.scheduled_date AS scheduled_date_10, m0_.udh AS udh_11, m0_.token AS token_12, m0_.contact_id AS contact_id_13, m0_.user_id AS user_id_14, m0_.seen_user_id AS seen_user_id_15, m0_.campaign_id AS campaign_id_16, m0_.reminder_id AS reminder_id_17 FROM mew_message m0_ LEFT JOIN mew_contact m1_ ON m0_.contact_id = m1_.id LEFT JOIN mew_contact_campaign m2_ ON m1_.id = m2_.contact_id LEFT JOIN mew_campaign m3_ ON m2_.campaign_id = m3_.id LEFT JOIN mew_source m4_ ON m1_.source_id = m4_.id LEFT JOIN mew_tag m5_ ON m4_.id = m5_.source_id WHERE m0_.sender = ? AND m0_.date_received >= ? AND m1_.token = ?

Parameters:

[
  "user"
  "2026-04-01 16:58:03"
  "7XTYUP5X72K6"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.text AS text_1,
  m0_.information AS information_2,
  m0_.date AS date_3,
  m0_.sender AS sender_4,
  m0_.seen AS seen_5,
  m0_.seen_date AS seen_date_6,
  m0_.date_received AS date_received_7,
  m0_.error_details AS error_details_8,
  m0_.error_number AS error_number_9,
  m0_.scheduled_date AS scheduled_date_10,
  m0_.udh AS udh_11,
  m0_.token AS token_12,
  m0_.contact_id AS contact_id_13,
  m0_.user_id AS user_id_14,
  m0_.seen_user_id AS seen_user_id_15,
  m0_.campaign_id AS campaign_id_16,
  m0_.reminder_id AS reminder_id_17
FROM
  mew_message m0_
  LEFT JOIN mew_contact m1_ ON m0_.contact_id = m1_.id
  LEFT JOIN mew_contact_campaign m2_ ON m1_.id = m2_.contact_id
  LEFT JOIN mew_campaign m3_ ON m2_.campaign_id = m3_.id
  LEFT JOIN mew_source m4_ ON m1_.source_id = m4_.id
  LEFT JOIN mew_tag m5_ ON m4_.id = m5_.source_id
WHERE
  m0_.sender = ?
  AND m0_.date_received >= ?
  AND m1_.token = ?

SELECT m0_.id AS id_0, m0_.text AS text_1, m0_.information AS information_2, m0_.date AS date_3, m0_.sender AS sender_4, m0_.seen AS seen_5, m0_.seen_date AS seen_date_6, m0_.date_received AS date_received_7, m0_.error_details AS error_details_8, m0_.error_number AS error_number_9, m0_.scheduled_date AS scheduled_date_10, m0_.udh AS udh_11, m0_.token AS token_12, m0_.contact_id AS contact_id_13, m0_.user_id AS user_id_14, m0_.seen_user_id AS seen_user_id_15, m0_.campaign_id AS campaign_id_16, m0_.reminder_id AS reminder_id_17 FROM mew_message m0_ LEFT JOIN mew_contact m1_ ON m0_.contact_id = m1_.id LEFT JOIN mew_contact_campaign m2_ ON m1_.id = m2_.contact_id LEFT JOIN mew_campaign m3_ ON m2_.campaign_id = m3_.id LEFT JOIN mew_source m4_ ON m1_.source_id = m4_.id LEFT JOIN mew_tag m5_ ON m4_.id = m5_.source_id WHERE m0_.sender = 'user' AND m0_.date_received >= '2026-04-01 16:58:03' AND m1_.token = '7XTYUP5X72K6';

#	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 216)
7	App\Repository\MessageRepository->findFromFilters (line 216)
8	App\Controller\Api\ApiMessageController->getLast (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.19 ms
(0.04%)

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 FROM mew_user t0 WHERE t0.email = ? LIMIT 1

Parameters:

[
  "noel.lotito@tchatbooster.com"
]

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
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 FROM mew_user t0 WHERE t0.email = 'noel.lotito@tchatbooster.com' 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\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\ContactCampaign	No errors.
App\Entity\Campaign	No errors.
App\Entity\PhoneNumber	No errors.
App\Entity\Tag	No errors.
App\Entity\Reminder	No errors.

Symfony Profiler

POST https://sms-dev.tchatbooster.com/api/message/get-last

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping