https://edigital.aditecec.com/fe/inventarios/trae-inventario-by-producto Return to referer URL

Query Metrics

2 Database Queries
2 Different statements
1.36 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

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
  • The mappings App\Entity\FeComercios#parametros and App\Entity\FeParametros#comercios are inconsistent with each other.
App\Entity\FeSucursales No errors.
App\Entity\FeInventarios
  • The association App\Entity\FeInventarios#movimientos refers to the owning side field App\Entity\FeInvMovimientos#invemtarios which does not exist.
App\Entity\FeProductos No errors.