Query Metrics
5
Database Queries
5
Different statements
6.89 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2.22 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 | 2.73 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.24 ms |
"START TRANSACTION"
Parameters:
[]
|
||||||||||||||||||||||||||||
4 | 1.42 ms |
INSERT INTO webhook_events (event_type, payload, created_at, status) VALUES (?, ?, ?, ?)
Parameters:
[ "message_created" "{"account":{"id":3,"name":"Maandhoo"},"additional_attributes":[],"content_attributes":{"in_reply_to":5193,"in_reply_to_external_id":"WAID:9B62DA6A1707231FCF42779794F5961F"},"content_type":"text","content":"tem algum beneficio para aniversariante para esse dia?","conversation":{"additional_attributes":[],"can_reply":true,"channel":"Channel::Api","contact_inbox":{"id":1311,"contact_id":722,"inbox_id":25,"source_id":"1fea2a61-1196-4812-8f0e-cd27491bac5e","created_at":"2025-05-04T00:03:37.327Z","updated_at":"2025-05-04T00:03:37.327Z","hmac_verified":false,"pubsub_token":"ZKKhZJ52Z5478Rn6SFWrvLDa"},"id":570,"inbox_id":25,"messages":[{"id":6456,"content":"tem algum beneficio para aniversariante para esse dia?","account_id":3,"inbox_id":25,"conversation_id":570,"message_type":0,"created_at":1746468073,"updated_at":"2025-05-05T18:01:13.839Z","private":false,"status":"sent","source_id":"WAID:3EB08CB338BB679794DC47","content_type":"text","content_attributes":{"in_reply_to":5193,"in_reply_to_external_id":"WAID:9B62DA6A1707231FCF42779794F5961F"},"sender_type":"Contact","sender_id":722,"external_source_ids":[],"additional_attributes":[],"processed_message_content":"tem algum beneficio para aniversariante para esse dia?","sentiment":[],"conversation":{"assignee_id":null,"unread_count":2,"last_activity_at":1746468073,"contact_inbox":{"source_id":"1fea2a61-1196-4812-8f0e-cd27491bac5e"}},"sender":{"additional_attributes":[],"custom_attributes":[],"email":null,"id":722,"identifier":"554799780045@s.whatsapp.net","name":"Manfro","phone_number":"+554799780045","thumbnail":"https:\/\/chatwoot.makeacademia.chat\/rails\/active_storage\/representations\/redirect\/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBckVGIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--756cd7e9989235e37e987a8054640ae7a2ace58a\/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaDdCem9MWm05eWJXRjBTU0lJYW5CbkJqb0dSVlE2RTNKbGMybDZaVjkwYjE5bWFXeHNXd2RwQWZvdyIsImV4cCI6bnVsbCwicHVyIjoidmFyaWF0aW9uIn19--76ce3f568a0080121942f031e551f9eaf0e62113\/390346795_1491457124761265_4810348387191807358_n.jpg","blocked":false,"type":"contact"}}],"labels":["maandhoo"],"meta":{"sender":{"additional_attributes":[],"custom_attributes":[],"email":null,"id":722,"identifier":"554799780045@s.whatsapp.net","name":"Manfro","phone_number":"+554799780045","thumbnail":"https:\/\/chatwoot.makeacademia.chat\/rails\/active_storage\/representations\/redirect\/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBckVGIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--756cd7e9989235e37e987a8054640ae7a2ace58a\/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaDdCem9MWm05eWJXRjBTU0lJYW5CbkJqb0dSVlE2RTNKbGMybDZaVjkwYjE5bWFXeHNXd2RwQWZvdyIsImV4cCI6bnVsbCwicHVyIjoidmFyaWF0aW9uIn19--76ce3f568a0080121942f031e551f9eaf0e62113\/390346795_1491457124761265_4810348387191807358_n.jpg","blocked":false,"type":"contact"},"assignee":null,"team":{"id":6,"name":"maandhoo"},"hmac_verified":false},"status":"open","custom_attributes":[],"snoozed_until":null,"unread_count":2,"first_reply_created_at":"2025-05-04T00:21:04.222Z","priority":null,"waiting_since":0,"agent_last_seen_at":1746321026,"contact_last_seen_at":0,"last_activity_at":1746468073,"timestamp":1746468073,"created_at":1746317017,"updated_at":1746468073.841782093048095703125},"created_at":"2025-05-05T18:01:13.839Z","id":6456,"inbox":{"id":25,"name":"97151002"},"message_type":"incoming","private":false,"sender":{"account":{"id":3,"name":"Maandhoo"},"additional_attributes":[],"avatar":"https:\/\/chatwoot.makeacademia.chat\/rails\/active_storage\/representations\/redirect\/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBckVGIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--756cd7e9989235e37e987a8054640ae7a2ace58a\/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaDdCem9MWm05eWJXRjBTU0lJYW5CbkJqb0dSVlE2RTNKbGMybDZaVjkwYjE5bWFXeHNXd2RwQWZvdyIsImV4cCI6bnVsbCwicHVyIjoidmFyaWF0aW9uIn19--76ce3f568a0080121942f031e551f9eaf0e62113\/390346795_1491457124761265_4810348387191807358_n.jpg","custom_attributes":[],"email":null,"id":722,"identifier":"554799780045@s.whatsapp.net","name":"Manfro","phone_number":"+554799780045","thumbnail":"https:\/\/chatwoot.makeacademia.chat\/rails\/active_storage\/representations\/redirect\/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBckVGIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--756cd7e9989235e37e987a8054640ae7a2ace58a\/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaDdCem9MWm05eWJXRjBTU0lJYW5CbkJqb0dSVlE2RTNKbGMybDZaVjkwYjE5bWFXeHNXd2RwQWZvdyIsImV4cCI6bnVsbCwicHVyIjoidmFyaWF0aW9uIn19--76ce3f568a0080121942f031e551f9eaf0e62113\/390346795_1491457124761265_4810348387191807358_n.jpg","blocked":false},"source_id":"WAID:3EB08CB338BB679794DC47","event":"message_created"}" "2025-05-05 15:01:14" "ignored" ]
|
||||||||||||||||||||||||||||
5 | 0.28 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. |