Query Metrics
5
Database Queries
5
Different statements
3.87 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1.51 ms |
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"
]
|
||||||||||||||||||||||||||||
2 | 0.94 ms |
SELECT t0.id AS id_1, t0.mensagem_cliente AS mensagem_cliente_2, t0.tipo_ativacao AS tipo_ativacao_3, t0.mensagem_resposta AS mensagem_resposta_4, t0.mensagem_resposta2 AS mensagem_resposta2_5, t0.acao_pos_envio AS acao_pos_envio_6, t0.ativo AS ativo_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.inbox_id AS inbox_id_10, t0.inbox_name AS inbox_name_11 FROM webhook_resposta t0 WHERE t0.ativo = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
3 | 0.20 ms |
"START TRANSACTION"
Parameters:
[]
|
||||||||||||||||||||||||||||
4 | 0.97 ms |
INSERT INTO webhook_events (event_type, payload, created_at, status) VALUES (?, ?, ?, ?)
Parameters:
[ "message_created" "{"account":{"id":3,"name":"Maandhoo"},"additional_attributes":[],"content_attributes":[],"content_type":"text","content":"Tem algum desconto ?","conversation":{"additional_attributes":[],"can_reply":true,"channel":"Channel::Api","contact_inbox":{"id":1430,"contact_id":799,"inbox_id":26,"source_id":"32f18745-5dbb-4c29-857d-84957a612c66","created_at":"2025-05-05T11:06:43.867Z","updated_at":"2025-05-05T11:06:43.867Z","hmac_verified":false,"pubsub_token":"RzKHm1LdbKWGkG58QWBVFpWp"},"id":650,"inbox_id":26,"messages":[{"id":5867,"content":"Tem algum desconto ?","account_id":3,"inbox_id":26,"conversation_id":650,"message_type":0,"created_at":1746443210,"updated_at":"2025-05-05T11:06:50.124Z","private":false,"status":"sent","source_id":"WAID:8FD5ACC2A12D6B37261E2FD5E4F46A6D","content_type":"text","content_attributes":[],"sender_type":"Contact","sender_id":799,"external_source_ids":[],"additional_attributes":[],"processed_message_content":"Tem algum desconto ?","sentiment":[],"conversation":{"assignee_id":7,"unread_count":2,"last_activity_at":1746443210,"contact_inbox":{"source_id":"32f18745-5dbb-4c29-857d-84957a612c66"}},"sender":{"additional_attributes":[],"custom_attributes":[],"email":null,"id":799,"identifier":"554791711426@s.whatsapp.net","name":"...","phone_number":"+554791711426","thumbnail":"","blocked":false,"type":"contact"}}],"labels":["maandhoo"],"meta":{"sender":{"additional_attributes":[],"custom_attributes":[],"email":null,"id":799,"identifier":"554791711426@s.whatsapp.net","name":"...","phone_number":"+554791711426","thumbnail":"","blocked":false,"type":"contact"},"assignee":{"id":7,"name":"Iago","available_name":"Iago","avatar_url":"","type":"user","availability_status":null,"thumbnail":""},"team":{"id":6,"name":"maandhoo"},"hmac_verified":false},"status":"open","custom_attributes":[],"snoozed_until":null,"unread_count":2,"first_reply_created_at":null,"priority":null,"waiting_since":1746443203,"agent_last_seen_at":0,"contact_last_seen_at":0,"last_activity_at":1746443210,"timestamp":1746443210,"created_at":1746443203,"updated_at":1746443210.1265227794647216796875},"created_at":"2025-05-05T11:06:50.124Z","id":5867,"inbox":{"id":26,"name":"99300283"},"message_type":"incoming","private":false,"sender":{"account":{"id":3,"name":"Maandhoo"},"additional_attributes":[],"avatar":"","custom_attributes":[],"email":null,"id":799,"identifier":"554791711426@s.whatsapp.net","name":"...","phone_number":"+554791711426","thumbnail":"","blocked":false},"source_id":"WAID:8FD5ACC2A12D6B37261E2FD5E4F46A6D","event":"message_created"}" "2025-05-05 08:06:50" "ignored" ]
|
||||||||||||||||||||||||||||
5 | 0.25 ms |
"COMMIT"
Parameters:
[]
|
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\WebhookResposta | No errors. |
App\Entity\WebhookEvent | No errors. |