Query Metrics
4
Database Queries
4
Different statements
3.26 ms
Query time
0
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
1.09 ms (33.27%) |
1 |
SELECT c0_.id AS id_0, c0_.nombre AS nombre_1, c0_.descripcion AS descripcion_2, c0_.icono AS icono_3, c0_.url AS url_4, c0_.etiqueta AS etiqueta_5, c0_.color AS color_6, c0_.activo AS activo_7, c0_.posicion AS posicion_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, c0_.deleted_at AS deleted_at_11, c0_.categoria_id AS categoria_id_12, c0_.tipo_categoria_id AS tipo_categoria_id_13 FROM categoria c0_ WHERE (c0_.activo = 1 AND c0_.tipo_categoria_id = ? AND c0_.categoria_id IS NULL) AND (c0_.deleted_at IS NULL) ORDER BY c0_.posicion ASC
Parameters:
[
1
]
|
|
0.81 ms (24.90%) |
1 |
SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.name AS name_2, p0_.value AS value_3, p0_.description AS description_4, p0_.help AS help_5, p0_.created_at AS created_at_6, p0_.updated_at AS updated_at_7 FROM parameter p0_ WHERE p0_.name = ?
Parameters:
[
"encendido_manual_seccion_que_necesitas"
]
|
|
0.75 ms (23.14%) |
1 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3 FROM tipo_categoria t0 WHERE t0.nombre = ? LIMIT 1
Parameters:
[
"Que necesitas"
]
|
|
0.61 ms (18.70%) |
1 |
SELECT t0.id AS id_1, t0.titulo AS titulo_2, t0.descripcion AS descripcion_3, t0.tipo_categoria AS tipo_categoria_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7 FROM componente_titulo t0 WHERE t0.tipo_categoria = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
"Que necesitas"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| api | doctrine.dbal.api_connection |
| log | doctrine.dbal.log_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| api | doctrine.orm.api_entity_manager |
| log | doctrine.orm.log_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\App\TipoCategoria | No errors. |
| App\Entity\App\Categoria | No errors. |
| App\Entity\App\Parameter | No errors. |
| App\Entity\App\Grupo | No errors. |
| App\Entity\App\MaterialRecurso | No errors. |
| App\Entity\App\Tramite | No errors. |
| App\Entity\App\ComponenteTitulo | No errors. |
api entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\App\Categoria | No errors. |
| App\Entity\App\ComponenteTitulo | No errors. |
log entity manager
No loaded entities.