Query Metrics
2
Database Queries
2
Different statements
1.36 ms
Query time
2
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.81 ms (59.66%) |
1 |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.usu_nombres AS usu_nombres_13, t0.usu_apellidos AS usu_apellidos_14, t0.menu AS menu_15, t0.comercio_id AS comercio_id_16, t0.sucursal_id AS sucursal_id_17 FROM users t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
2
]
|
|
0.55 ms (40.34%) |
1 |
SELECT f0_.id AS id_0, f1_.id AS id_1, f0_.pro_codigo AS pro_codigo_2, f0_.pro_nombre AS pro_nombre_3, f0_.pro_descripcion AS pro_descripcion_4, f0_.pro_estado AS pro_estado_5, f0_.pro_tipo AS pro_tipo_6, f1_.inv_can_disponible AS inv_can_disponible_7, f1_.inv_atributos AS inv_atributos_8, (CASE WHEN f1_.inv_can_disponible < 1 THEN 'VENDIDO' ELSE 'DISPONIBLE' END) AS sclr_9 FROM feinventarios f1_, feproductos f0_ WHERE f1_.productos_id = f0_.id AND f0_.id = ?
Parameters:
[
"7169"
]
|
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 |
|---|---|
| FOS\UserBundle\Model\User | No errors. |
| App\Entity\Users | No errors. |
| App\Entity\FeComercios |
|
| App\Entity\FeSucursales | No errors. |
| App\Entity\FeInventarios |
|
| App\Entity\FeProductos | No errors. |