POST https://aimee.sysbar.com.br/whatsapp/disparador/1/janela-disparo

Query Metrics

9 Database Queries
9 Different statements
9.30 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.71 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.72 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_active AS is_active_5, t0.usergroup AS usergroup_6 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  17
]
3 1.70 ms
SELECT t0.usergroup_id AS usergroup_id_1, t0.usergroup_name AS usergroup_name_2, t0.role_id AS role_id_3 FROM usergroup t0 WHERE t0.usergroup_id = ?
Parameters:
[
  27
]
4 1.50 ms
SELECT t0.role_id AS role_id_1, t0.role_name AS role_name_2, t0.role_description AS role_description_3 FROM role t0 WHERE t0.role_id = ?
Parameters:
[
  1
]
5 0.88 ms
SELECT t0.role_id AS role_id_1, t0.role_name AS role_name_2, t0.role_description AS role_description_3 FROM role t0 INNER JOIN usergroup_role ON t0.role_id = usergroup_role.role_id WHERE usergroup_role.usergroup_id = ?
Parameters:
[
  27
]
6 0.62 ms
SELECT t0.id AS id_1, t0.mensagem_id AS mensagem_id_2, t0.inbox_id AS inbox_id_3, t0.status AS status_4, t0.criado_em AS criado_em_5, t0.atualizado_em AS atualizado_em_6, t0.modo_disparo AS modo_disparo_7 FROM disparador_trabalho t0 WHERE t0.id = ?
Parameters:
[
  1
]
7 1.88 ms
SELECT intervalo_disparo_seg, horario_inicial, horario_final, max_mensagens_dia FROM whatsapp_inbox_bar WHERE inbox_id = ?
Parameters:
[
  23
]
8 0.81 ms
SELECT count(d0_.id) AS sclr_0 FROM disparador_destinatario d0_ WHERE d0_.trabalho_id = ? AND d0_.status = ? AND d0_.enviado_em >= ? AND d0_.enviado_em < ?
Parameters:
[
  1
  "enviado"
  "2025-05-05 00:00:00"
  "2025-05-06 00:00:00"
]
9 0.48 ms
SELECT t0.id AS id_1, t0.nome AS nome_2, t0.telefone AS telefone_3, t0.status AS status_4, t0.enviado_em AS enviado_em_5, t0.erro_msg AS erro_msg_6, t0.trabalho_id AS trabalho_id_7 FROM disparador_destinatario t0 WHERE t0.trabalho_id = ? AND t0.status = ? LIMIT 1
Parameters:
[
  1
  "pendente"
]

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\User No errors.
App\Entity\Usergroup No errors.
App\Entity\Role No errors.
App\Entity\DisparadorTrabalho No errors.
App\Entity\DisparadorDestinatario No errors.
App\Entity\DisparoMensagem No errors.