Query Metrics
14
Database Queries
12
Different statements
9.67 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
4.11 ms (42.51%) |
2 |
"COMMIT"
Parameters:
[] |
1.61 ms (16.66%) |
1 |
SELECT t0.id AS id_1, t0.nome AS nome_2, t0.extra_fields AS extra_fields_3, t0.end_modulo AS end_modulo_4, t0.end_estante AS end_estante_5, t0.end_pratileira AS end_pratileira_6, t0.end_fisico AS end_fisico_7, t0.conta AS conta_8, t0.conta1 AS conta1_9, t0.conta2 AS conta2_10, t0.created_at AS created_at_11 FROM caixa t0 INNER JOIN caixa_cliente ON t0.id = caixa_cliente.cliente_id WHERE caixa_cliente.caixa_id = ?
Parameters:
[
117
]
|
0.86 ms (8.90%) |
1 |
INSERT INTO documento (nome, conteiner, estado, qtd, assunto, situacao, posse_data, posse_observacao, data_documento, vencimento_documento, extra_fields, keywords, image, created_at, updated_at, index_at, movimentacao, anexo, anexo1, anexo2, anexo3, anexo4, anexo5, anexo6, anexo7, anexo8, qtd1, qtd2, qtd3, qtd4, qtd5, qtd6, qtd7, qtd8, qtd9, qtd10, cliente_id, caixa_id, user_id, posse_user_id, categoria_id, classificacao_id, tipo_id, protocolo_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "1621" null "Documento Ativo" 16 "ANA RODRIGUES GONCALVES" "Arquivado" null null null null "" "" "838c2829-27b2-4371-8017-dc0ae6372ab9.pdf" "2024-09-23 10:31:01" null null null null null null null null null null null null 16 null null null null null null null null null 117 90883 490 null 1 1 165 null ] |
0.84 ms (8.69%) |
1 |
SELECT t0.id AS id_1, t0.nome AS nome_2, t0.extra_fields AS extra_fields_3, t0.tipo_acesso AS tipo_acesso_4, t0.image AS image_5 FROM user t0 WHERE t0.id = ?
Parameters:
[
"490"
]
|
0.51 ms (5.24%) |
1 |
SELECT t0.id AS id_1, t0.nome AS nome_2, t0.extra_fields AS extra_fields_3, t0.fase_corrente AS fase_corrente_4, t0.fase_intermediaria AS fase_intermediaria_5, t0.destinacao_final AS destinacao_final_6, t0.observacoes AS observacoes_7, t0.cliente_id AS cliente_id_8 FROM classificacao t0 WHERE t0.cliente_id = ?
Parameters:
[
"117"
]
|
0.32 ms (3.34%) |
1 |
INSERT INTO registro (operacao, data, user, cliente) VALUES (?, ?, ?, ?)
Parameters:
[ "Documento feito pelo formulario com Assinador" "2024-09-23 10:31:09" 490 117 ] |
0.32 ms (3.27%) |
1 |
SELECT t0.id AS id_1, t0.nome AS nome_2, t0.extra_fields AS extra_fields_3, t0.end_modulo AS end_modulo_4, t0.end_estante AS end_estante_5, t0.end_pratileira AS end_pratileira_6, t0.end_fisico AS end_fisico_7, t0.conta AS conta_8, t0.conta1 AS conta1_9, t0.conta2 AS conta2_10, t0.created_at AS created_at_11 FROM caixa t0 WHERE t0.id = ?
Parameters:
[
"90883"
]
|
0.28 ms (2.93%) |
1 |
SELECT t0.id AS id_1, t0.nome AS nome_2, t0.extra_fields AS extra_fields_3 FROM categoria t0
Parameters:
[] |
0.24 ms (2.51%) |
2 |
"START TRANSACTION"
Parameters:
[] |
0.22 ms (2.25%) |
1 |
SELECT t0.id AS id_1, t0.nome AS nome_2, t0.extra_fields AS extra_fields_3, t0.cliente_id AS cliente_id_4 FROM tipo t0 WHERE t0.cliente_id = ?
Parameters:
[
"117"
]
|
0.19 ms (1.94%) |
1 |
SELECT t0.id AS id_1, t0.nome AS nome_2, t0.extra_fields AS extra_fields_3, t0.fase_corrente AS fase_corrente_4, t0.fase_intermediaria AS fase_intermediaria_5, t0.destinacao_final AS destinacao_final_6, t0.observacoes AS observacoes_7, t0.cliente_id AS cliente_id_8 FROM classificacao t0 WHERE t0.id = ?
Parameters:
[
1
]
|
0.17 ms (1.76%) |
1 |
SELECT t0.id AS id_1, t0.nome AS nome_2, t0.extra_fields AS extra_fields_3 FROM cliente t0 WHERE t0.id = ?
Parameters:
[
117
]
|
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\User | No errors. |
App\Entity\Documento | No errors. |
App\Entity\Conteiner | No errors. |
App\Entity\ConteinerResp | No errors. |
App\Entity\Cliente | No errors. |
App\Entity\Classificacao | No errors. |
App\Entity\Tipo | No errors. |
App\Entity\ProtocoloTipo | No errors. |
App\Entity\Caixa | No errors. |
App\Entity\Categoria | No errors. |
App\Entity\Protocolo | No errors. |
App\Entity\Registro | No errors. |