Query Metrics
6
Database Queries
5
Different statements
16.52 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
8.40 ms (50.83%) |
2 |
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.contrato_id = ?
Parameters:
[
30
]
|
4.62 ms (27.94%) |
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:
[
"2"
]
|
1.34 ms (8.14%) |
1 |
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:
[
30
]
|
1.33 ms (8.07%) |
1 |
SELECT t0.id AS id_1, t0.nome AS nome_2, t0.selector AS selector_3 FROM cliente t0 WHERE t0.id = ?
Parameters:
[
3
]
|
0.83 ms (5.02%) |
1 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.excluido AS excluido_5, t0.selector AS selector_6, t0.nome AS nome_7, t0.cliente_id AS cliente_id_8, t0.contrato_id AS contrato_id_9 FROM usuario t0 WHERE t0.id = ?
Parameters:
[
7085
]
|
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\DispositivoPreAprovado | No errors. |
App\Entity\PackageContrato | No errors. |