Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

3.65 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.08 ms
(57.12%)

SELECT t0.bar_id AS bar_id_1, t0.bar_name AS bar_name_2, t0.color AS color_3, t0.bar_fullname AS bar_fullname_4 FROM bar t0 WHERE t0.bar_id = ?

Parameters:

[
  "2"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.bar_id AS bar_id_1,
  t0.bar_name AS bar_name_2,
  t0.color AS color_3,
  t0.bar_fullname AS bar_fullname_4
FROM
  bar t0
WHERE
  t0.bar_id = ?

SELECT t0.bar_id AS bar_id_1, t0.bar_name AS bar_name_2, t0.color AS color_3, t0.bar_fullname AS bar_fullname_4 FROM bar t0 WHERE t0.bar_id = '2';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 733)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 751)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 358)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 29)
7	App\Service\BarService->getCurrentBar (line 35)
8	App\EventListener\BarRequestListener->onKernelRequest (line 116)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 154)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

1.02 ms
(28.02%)

INSERT INTO webhook_events (event_type, payload, created_at, status) VALUES (?, ?, ?, ?)

Parameters:

[
  "conversation_created"
  "{"additional_attributes":[],"can_reply":true,"channel":"Channel::Api","contact_inbox":{"id":1555,"contact_id":875,"inbox_id":26,"source_id":"d00351c9-92a7-4bf2-b55f-e2e57f0e5a3a","created_at":"2025-05-05T23:08:07.624Z","updated_at":"2025-05-05T23:08:07.624Z","hmac_verified":false,"pubsub_token":"atgG3tLdhfZHJ8HvXwscp5gj"},"id":693,"inbox_id":26,"messages":[{"id":6854,"content":"Boa noite","account_id":3,"inbox_id":26,"conversation_id":693,"message_type":0,"created_at":1746486487,"updated_at":"2025-05-05T23:08:07.695Z","private":false,"status":"sent","source_id":"WAID:3799D84DFEA703BB583983283A73AF8D","content_type":"text","content_attributes":[],"sender_type":"Contact","sender_id":875,"external_source_ids":[],"additional_attributes":[],"processed_message_content":"Boa noite","sentiment":[],"conversation":{"assignee_id":null,"unread_count":1,"last_activity_at":1746486487,"contact_inbox":{"source_id":"d00351c9-92a7-4bf2-b55f-e2e57f0e5a3a"}},"sender":{"additional_attributes":[],"custom_attributes":[],"email":null,"id":875,"identifier":"556781419765@s.whatsapp.net","name":"Dhio","phone_number":"+556781419765","thumbnail":"","blocked":false,"type":"contact"}}],"labels":["maandhoo"],"meta":{"sender":{"additional_attributes":[],"custom_attributes":[],"email":null,"id":875,"identifier":"556781419765@s.whatsapp.net","name":"Dhio","phone_number":"+556781419765","thumbnail":"","blocked":false,"type":"contact"},"assignee":null,"team":{"id":6,"name":"maandhoo"},"hmac_verified":false},"status":"open","custom_attributes":[],"snoozed_until":null,"unread_count":1,"first_reply_created_at":null,"priority":null,"waiting_since":1746486487,"agent_last_seen_at":0,"contact_last_seen_at":0,"last_activity_at":1746486487,"timestamp":1746486487,"created_at":1746486487,"updated_at":1746486487.9917953014373779296875,"event":"conversation_created"}"
  "2025-05-05 20:08:08"
  "ignored"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO webhook_events (
  event_type, payload, created_at, status
)
VALUES
  (?, ?, ?, ?)

INSERT INTO webhook_events (event_type, payload, created_at, status) VALUES ('conversation_created', '{\"additional_attributes\":[],\"can_reply\":true,\"channel\":\"Channel::Api\",\"contact_inbox\":{\"id\":1555,\"contact_id\":875,\"inbox_id\":26,\"source_id\":\"d00351c9-92a7-4bf2-b55f-e2e57f0e5a3a\",\"created_at\":\"2025-05-05T23:08:07.624Z\",\"updated_at\":\"2025-05-05T23:08:07.624Z\",\"hmac_verified\":false,\"pubsub_token\":\"atgG3tLdhfZHJ8HvXwscp5gj\"},\"id\":693,\"inbox_id\":26,\"messages\":[{\"id\":6854,\"content\":\"Boa noite\",\"account_id\":3,\"inbox_id\":26,\"conversation_id\":693,\"message_type\":0,\"created_at\":1746486487,\"updated_at\":\"2025-05-05T23:08:07.695Z\",\"private\":false,\"status\":\"sent\",\"source_id\":\"WAID:3799D84DFEA703BB583983283A73AF8D\",\"content_type\":\"text\",\"content_attributes\":[],\"sender_type\":\"Contact\",\"sender_id\":875,\"external_source_ids\":[],\"additional_attributes\":[],\"processed_message_content\":\"Boa noite\",\"sentiment\":[],\"conversation\":{\"assignee_id\":null,\"unread_count\":1,\"last_activity_at\":1746486487,\"contact_inbox\":{\"source_id\":\"d00351c9-92a7-4bf2-b55f-e2e57f0e5a3a\"}},\"sender\":{\"additional_attributes\":[],\"custom_attributes\":[],\"email\":null,\"id\":875,\"identifier\":\"556781419765@s.whatsapp.net\",\"name\":\"Dhio\",\"phone_number\":\"+556781419765\",\"thumbnail\":\"\",\"blocked\":false,\"type\":\"contact\"}}],\"labels\":[\"maandhoo\"],\"meta\":{\"sender\":{\"additional_attributes\":[],\"custom_attributes\":[],\"email\":null,\"id\":875,\"identifier\":\"556781419765@s.whatsapp.net\",\"name\":\"Dhio\",\"phone_number\":\"+556781419765\",\"thumbnail\":\"\",\"blocked\":false,\"type\":\"contact\"},\"assignee\":null,\"team\":{\"id\":6,\"name\":\"maandhoo\"},\"hmac_verified\":false},\"status\":\"open\",\"custom_attributes\":[],\"snoozed_until\":null,\"unread_count\":1,\"first_reply_created_at\":null,\"priority\":null,\"waiting_since\":1746486487,\"agent_last_seen_at\":0,\"contact_last_seen_at\":0,\"last_activity_at\":1746486487,\"timestamp\":1746486487,\"created_at\":1746486487,\"updated_at\":1746486487.9917953014373779296875,\"event\":\"conversation_created\"}', '2025-05-05 20:08:08', 'ignored');

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 248)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1048)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 399)
5	Doctrine\ORM\UnitOfWork->commit (line 260)
6	Doctrine\ORM\EntityManager->flush (line 43)
7	App\Service\WebhookService->handleEvent (line 61)
8	App\Controller\WebhookController->receiveWebhook (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.28 ms
(7.65%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 380)
2	Doctrine\ORM\UnitOfWork->commit (line 260)
3	Doctrine\ORM\EntityManager->flush (line 43)
4	App\Service\WebhookService->handleEvent (line 61)
5	App\Controller\WebhookController->receiveWebhook (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.26 ms
(7.21%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1427)
2	Doctrine\DBAL\Connection->commit (line 429)
3	Doctrine\ORM\UnitOfWork->commit (line 260)
4	Doctrine\ORM\EntityManager->flush (line 43)
5	App\Service\WebhookService->handleEvent (line 61)
6	App\Controller\WebhookController->receiveWebhook (line 178)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	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.

Entities Mapping

Class	Mapping errors
App\Entity\Bar	No errors.
App\Entity\Evento	No errors.
App\Entity\WebhookEvent	No errors.

Symfony Profiler

POST https://aimee.sysbar.com.br/service/webhook

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping