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

Query Metrics

5 Database Queries
5 Different statements
8.21 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 2.06 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.60 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 1.09 ms
"START TRANSACTION"
Parameters:
[]
4 2.09 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_external_id":null},"content_type":"text","content":"J\u00e1 ta em qual lote?","conversation":{"additional_attributes":[],"can_reply":true,"channel":"Channel::Instagram","contact_inbox":{"id":1505,"contact_id":844,"inbox_id":20,"source_id":"1668687337142247","created_at":"2025-05-05T18:36:14.963Z","updated_at":"2025-05-05T18:36:14.963Z","hmac_verified":false,"pubsub_token":"3mAqjfX1XpecpboZvrBDfTuK"},"id":673,"inbox_id":20,"messages":[{"id":6516,"content":"J\u00e1 ta em qual lote?","account_id":3,"inbox_id":20,"conversation_id":673,"message_type":0,"created_at":1746471986,"updated_at":"2025-05-05T19:06:26.110Z","private":false,"status":"sent","source_id":"aWdfZAG1faXRlbToxOklHTWVzc2FnZAUlEOjE3ODQxNDUzNjU1NTg0Mzg4OjM0MDI4MjM2Njg0MTcxMDMwMTI0NDI1OTg0MDA5OTIxODY0MDY5NjozMjIxNjcyMTczNzU0ODk0MzcyODk1MjE0ODUyNTg0MjQzMgZDZD","content_type":"text","content_attributes":{"in_reply_to_external_id":null},"sender_type":"Contact","sender_id":844,"external_source_ids":[],"additional_attributes":[],"processed_message_content":"J\u00e1 ta em qual lote?","sentiment":[],"conversation":{"assignee_id":null,"unread_count":5,"last_activity_at":1746471986,"contact_inbox":{"source_id":"1668687337142247"}},"sender":{"additional_attributes":{"social_profiles":{"instagram":"_evelinsousaa"},"social_instagram_user_name":"_evelinsousaa","social_instagram_follower_count":564,"social_instagram_is_verified_user":false,"social_instagram_is_business_follow_user":false,"social_instagram_is_user_follow_business":true},"custom_attributes":[],"email":null,"id":844,"identifier":null,"name":"\u2728\ud835\uddd8\ud835\ude03\ud835\uddf2\ud835\uddf9\ud835\uddf6\ud835\uddfb\u2728","phone_number":null,"thumbnail":"https:\/\/chatwoot.makeacademia.chat\/rails\/active_storage\/representations\/redirect\/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBc2NIIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--2320b162c4be1bacef88ec4a8e0e70433bcc6d50\/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaDdCem9MWm05eWJXRjBTU0lJYW5CbkJqb0dSVlE2RTNKbGMybDZaVjkwYjE5bWFXeHNXd2RwQWZvdyIsImV4cCI6bnVsbCwicHVyIjoidmFyaWF0aW9uIn19--76ce3f568a0080121942f031e551f9eaf0e62113\/489717145_1391109192064473_4105809942303960461_n.jpg","blocked":false,"type":"contact"}}],"labels":["maandhoo"],"meta":{"sender":{"additional_attributes":{"social_profiles":{"instagram":"_evelinsousaa"},"social_instagram_user_name":"_evelinsousaa","social_instagram_follower_count":564,"social_instagram_is_verified_user":false,"social_instagram_is_business_follow_user":false,"social_instagram_is_user_follow_business":true},"custom_attributes":[],"email":null,"id":844,"identifier":null,"name":"\u2728\ud835\uddd8\ud835\ude03\ud835\uddf2\ud835\uddf9\ud835\uddf6\ud835\uddfb\u2728","phone_number":null,"thumbnail":"https:\/\/chatwoot.makeacademia.chat\/rails\/active_storage\/representations\/redirect\/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBc2NIIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--2320b162c4be1bacef88ec4a8e0e70433bcc6d50\/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaDdCem9MWm05eWJXRjBTU0lJYW5CbkJqb0dSVlE2RTNKbGMybDZaVjkwYjE5bWFXeHNXd2RwQWZvdyIsImV4cCI6bnVsbCwicHVyIjoidmFyaWF0aW9uIn19--76ce3f568a0080121942f031e551f9eaf0e62113\/489717145_1391109192064473_4105809942303960461_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":5,"first_reply_created_at":null,"priority":null,"waiting_since":1746470175,"agent_last_seen_at":0,"contact_last_seen_at":0,"last_activity_at":1746471986,"timestamp":1746471986,"created_at":1746470175,"updated_at":1746471986.112062931060791015625},"created_at":"2025-05-05T19:06:26.110Z","id":6516,"inbox":{"id":20,"name":"Insta Maandhoo"},"message_type":"incoming","private":false,"sender":{"account":{"id":3,"name":"Maandhoo"},"additional_attributes":{"social_profiles":{"instagram":"_evelinsousaa"},"social_instagram_user_name":"_evelinsousaa","social_instagram_follower_count":564,"social_instagram_is_verified_user":false,"social_instagram_is_business_follow_user":false,"social_instagram_is_user_follow_business":true},"avatar":"https:\/\/chatwoot.makeacademia.chat\/rails\/active_storage\/representations\/redirect\/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBc2NIIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--2320b162c4be1bacef88ec4a8e0e70433bcc6d50\/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaDdCem9MWm05eWJXRjBTU0lJYW5CbkJqb0dSVlE2RTNKbGMybDZaVjkwYjE5bWFXeHNXd2RwQWZvdyIsImV4cCI6bnVsbCwicHVyIjoidmFyaWF0aW9uIn19--76ce3f568a0080121942f031e551f9eaf0e62113\/489717145_1391109192064473_4105809942303960461_n.jpg","custom_attributes":[],"email":null,"id":844,"identifier":null,"name":"\u2728\ud835\uddd8\ud835\ude03\ud835\uddf2\ud835\uddf9\ud835\uddf6\ud835\uddfb\u2728","phone_number":null,"thumbnail":"https:\/\/chatwoot.makeacademia.chat\/rails\/active_storage\/representations\/redirect\/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBc2NIIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--2320b162c4be1bacef88ec4a8e0e70433bcc6d50\/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaDdCem9MWm05eWJXRjBTU0lJYW5CbkJqb0dSVlE2RTNKbGMybDZaVjkwYjE5bWFXeHNXd2RwQWZvdyIsImV4cCI6bnVsbCwicHVyIjoidmFyaWF0aW9uIn19--76ce3f568a0080121942f031e551f9eaf0e62113\/489717145_1391109192064473_4105809942303960461_n.jpg","blocked":false},"source_id":"aWdfZAG1faXRlbToxOklHTWVzc2FnZAUlEOjE3ODQxNDUzNjU1NTg0Mzg4OjM0MDI4MjM2Njg0MTcxMDMwMTI0NDI1OTg0MDA5OTIxODY0MDY5NjozMjIxNjcyMTczNzU0ODk0MzcyODk1MjE0ODUyNTg0MjQzMgZDZD","event":"message_created"}"
  "2025-05-05 16:06:26"
  "ignored"
]
5 2.37 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.