Query Metrics
6
Database Queries
6
Different statements
25.12 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 2.63 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:
[
"ttA1xn.GU4wV"
]
|
2 | 6.32 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:
[
"ttA1xn.GU4wV"
]
|
3 | 3.59 ms |
SELECT t0.id AS id_1, t0.nome AS nome_2 FROM package_sistema t0
Parameters:
[] |
4 | 4.47 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 | 4.62 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 | 3.50 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:
[
3190
]
|
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. |