https://webservice.homelocker.harpya.pm.pr.gov.br/api/dispositivo/vfTA4GxUbRsQ/status/bloqueio

Query Metrics

3 Database Queries
3 Different statements
16.15 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
8.54 ms
(52.88%)
1
SELECT t0.id AS id_1, t0.descricao AS descricao_2, t0.bloqueio AS bloqueio_3, t0.created_at AS created_at_4, t0.selector AS selector_5, t0.dispositivo_id AS dispositivo_id_6 FROM dispositivo_historico_acao t0 WHERE (t0.bloqueio = ? AND t0.dispositivo_id = ?) ORDER BY t0.created_at DESC LIMIT 1
Parameters:
[
  1
  3891
]
3.95 ms
(24.47%)
1
SELECT t0.id AS id_1, t0.identificador AS identificador_2, t0.marca AS marca_3, t0.modelo AS modelo_4, t0.selector AS selector_5, t0.status AS status_6, t0.bloqueio AS bloqueio_7, t0.informacao_complementar AS informacao_complementar_8, t0.firebase_identificador AS firebase_identificador_9, t0.senha AS senha_10, t0.identificador_propaganda AS identificador_propaganda_11, t0.firebase_token AS firebase_token_12, t0.contrato_id AS contrato_id_13, t0.usuario_id AS usuario_id_14 FROM dispositivo t0 WHERE t0.selector = ? LIMIT 1
Parameters:
[
  "vfTA4GxUbRsQ"
]
3.66 ms
(22.65%)
1
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.excluido AS excluido_4, u0_.selector AS selector_5, u0_.nome AS nome_6, u0_.cliente_id AS cliente_id_7, u0_.contrato_id AS contrato_id_8 FROM usuario u0_ WHERE u0_.username = ? AND u0_.excluido = 0
Parameters:
[
  "vfTA4GxUbRsQ"
]

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\Usuario No errors.
App\Entity\Cliente No errors.
App\Entity\Contrato No errors.
App\Entity\Dispositivo No errors.
App\Entity\Solicitacao No errors.
App\Entity\PackageDispositivo No errors.
App\Entity\DispositivoHistoricoAcao No errors.