Query Metrics
5
Database Queries
5
Different statements
5.49 ms
Query time
6
Invalid entities
6
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.68 ms |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.is_active AS is_active_4, t0.costo AS costo_5, t0.urlimagen AS urlimagen_6, t0.urlvideo AS urlvideo_7, t0.visible AS visible_8, t0.carrounico AS carrounico_9, t0.requiere_agenda AS requiere_agenda_10, t0.marca_id AS marca_id_11, t0.categoriaproducto_id AS categoriaproducto_id_12, t0.tipoproducto_id AS tipoproducto_id_13, t0.subtipoproducto_id AS subtipoproducto_id_14 FROM productos t0 WHERE t0.id = ?
Parameters:
[
"99"
]
|
| 2 | 1.37 ms |
SELECT c0_.id AS id_0, c0_.clave AS clave_1, c0_.valor AS valor_2, c0_.descripcion AS descripcion_3, c0_.fecha_creacion AS fecha_creacion_4, c0_.fecha_modificacion AS fecha_modificacion_5, c0_.grupo_listas_precios_id AS grupo_listas_precios_id_6 FROM configuracion_general c0_ WHERE c0_.clave = ?
Parameters:
[
"grupo_lista_precios_productos"
]
|
| 3 | 0.57 ms |
SELECT t0.id AS id_1, t0.nombre AS nombre_2 FROM grupo_listas_precios t0 WHERE t0.id = ?
Parameters:
[
5
]
|
| 4 | 1.16 ms |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.is_active AS is_active_4 FROM catalogoprecio t0 INNER JOIN grupo_listas_precios_catalogoprecio ON t0.id = grupo_listas_precios_catalogoprecio.catalogoprecio_id WHERE grupo_listas_precios_catalogoprecio.grupo_listas_precios_id = ?
Parameters:
[
5
]
|
| 5 | 0.72 ms |
SELECT t0.id AS id_1, t0.precio AS precio_2, t0.codigointegracion AS codigointegracion_3, t0.catalogoprecio_id AS catalogoprecio_id_4, t0.productos_id AS productos_id_5, t0.paqueteproducto_id AS paqueteproducto_id_6, t0.condicionesvariante_id AS condicionesvariante_id_7 FROM catalogoprecio_producto t0 WHERE t0.catalogoprecio_id = ? AND t0.productos_id = ? LIMIT 1
Parameters:
[ 18 99 ] |
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Productos | 1 |
| App\Entity\Categoriaproducto | 1 |
| App\Entity\Tipoproducto | 1 |
| App\Entity\GrupoListasPrecios | 1 |
| App\Entity\Catalogoprecio | 1 |
| App\Entity\CatalogoprecioProducto | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Productos | No errors. |
| App\Entity\Marcaproducto | No errors. |
| App\Entity\Categoriaproducto | No errors. |
| App\Entity\Tipoproducto | No errors. |
| App\Entity\Subtipoproducto | No errors. |
| App\Entity\Paqueteproducto | No errors. |
| App\Entity\CatalogoprecioProducto |
|
| App\Entity\Solicitudcobertura |
|
| App\Entity\TipoclienteProducto | No errors. |
| App\Entity\Servicio |
|
| App\Entity\Pedido |
|
| App\Entity\CitaProducto |
|
| App\Entity\ConfiguracionGeneral | No errors. |
| App\Entity\GrupoListasPrecios | No errors. |
| App\Entity\Catalogoprecio | No errors. |
| App\Entity\Persona |
|
| App\Entity\ConfigPaqueteVar | No errors. |