Query Metrics
1
Database Queries
1
Different statements
1.95 ms
Query time
4
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.95 ms |
SELECT e0_.id AS id_0, e0_.nome AS nome_1, e0_.prazo AS prazo_2, e0_.updated_at AS updated_at_3, e0_.ordem AS ordem_4, e0_.obs AS obs_5, f1_.id AS id_6, f1_.nome AS nome_7, f1_.created_at AS created_at_8, f1_.obs AS obs_9, c2_.id AS id_10, c2_.nome AS nome_11, c2_.extra_fields AS extra_fields_12, e0_.user_id AS user_id_13, e0_.documento_id AS documento_id_14, e0_.fluxo_id AS fluxo_id_15, e0_.registro_id AS registro_id_16, e0_.prompt_id AS prompt_id_17, f1_.user_id AS user_id_18, f1_.cliente_id AS cliente_id_19, c2_.cliente_all_id AS cliente_all_id_20 FROM etapa e0_ INNER JOIN fluxo f1_ ON e0_.fluxo_id = f1_.id INNER JOIN cliente c2_ ON f1_.cliente_id = c2_.id WHERE e0_.user_id = ? AND e0_.prompt_id IS NOT NULL AND EXISTS (SELECT 1 AS sclr_21 FROM documento d3_ INNER JOIN caixa c4_ ON d3_.caixa_id = c4_.id WHERE c4_.fluxo_id = f1_.id AND d3_.tipo_id IS NULL) ORDER BY e0_.ordem ASC LIMIT 1
Parameters:
[
115
]
|
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\Etapa | No errors. |
| App\Entity\Fluxo | No errors. |
| App\Entity\Cliente |
|
| App\Entity\Documento | No errors. |
| App\Entity\Caixa | No errors. |
| App\Entity\User |
|
| App\Entity\Registro |
|
| App\Entity\Prompt |
|
| App\Entity\ClienteAll | No errors. |