https://webservice.homelocker.harpya.pm.pr.gov.br/api/dispositivo/jd8Prwkardqj/package_context

Query Metrics

6 Database Queries
6 Different statements
8.87 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 2.64 ms
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:
[
  "jd8Prwkardqj"
]
2 3.03 ms
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:
[
  "jd8Prwkardqj"
]
3 0.68 ms
SELECT t0.id AS id_1, t0.nome AS nome_2 FROM package_sistema t0
Parameters:
[]
4 0.79 ms
SELECT t0.id AS id_1, t0.codigo AS codigo_2, t0.limite AS limite_3, t0.selector AS selector_4, t0.created_at AS created_at_5, t0.aprovado_automaticamente AS aprovado_automaticamente_6, t0.cliente_id AS cliente_id_7 FROM contrato t0 WHERE t0.id = ?
Parameters:
[
  61
]
5 1.04 ms
SELECT t0.id AS id_1, t0.nome AS nome_2, t0.selector AS selector_3, t0.contrato_id AS contrato_id_4 FROM package_contrato t0 WHERE t0.contrato_id = ?
Parameters:
[
  61
]
6 0.69 ms
SELECT t0.id AS id_1, t0.nome AS nome_2, t0.selector AS selector_3, t0.dispositivo_id AS dispositivo_id_4 FROM package_dispositivo t0 WHERE t0.dispositivo_id = ?
Parameters:
[
  3211
]

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.
App\Entity\PackageSistema No errors.
App\Entity\DispositivoPreAprovado No errors.
App\Entity\PackageContrato No errors.