Query Metrics
9
Database Queries
9
Different statements
14.88 ms
Query time
1
Invalid entities
4
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.27 ms |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.imagen AS imagen_3, t0.descripcion AS descripcion_4, t0.activo AS activo_5 FROM grupo_productos t0 WHERE t0.id = ?
Parameters:
[
"20"
]
|
| 2 | 0.94 ms |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.imagen AS imagen_3, t0.tipo_pedido AS tipo_pedido_4, t0.plantilla AS plantilla_5, t0.activo AS activo_6, t0.grupo_producto_id AS grupo_producto_id_7 FROM sub_grupo_producto t0 WHERE t0.id = ?
Parameters:
[
"23"
]
|
| 3 | 1.79 ms |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.imagen AS imagen_4, t0.cod_product AS cod_product_5, t0.cantidad AS cantidad_6, t0.cantidad_max AS cantidad_max_7, t0.sku AS sku_8, t0.oferta AS oferta_9, t0.descarga AS descarga_10, t0.diseno AS diseno_11, t0.entrega AS entrega_12, t0.activo AS activo_13, t0.descripcion_corta AS descripcion_corta_14, t0.tipo_pedido AS tipo_pedido_15, t0.job_template_code AS job_template_code_16, t0.sub_grupo_producto_id AS sub_grupo_producto_id_17 FROM producto t0 WHERE t0.id = ?
Parameters:
[
"63"
]
|
| 4 | 1.20 ms |
"START TRANSACTION"
Parameters:
[] |
| 5 | 1.78 ms |
INSERT INTO carro_compra (localizador, precio_total, estado, fecha_pedido_int, num_pedido_int, estado_int, debug, cliente_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ null 0.0 0 null null null null null ] |
| 6 | 2.09 ms |
"COMMIT"
Parameters:
[] |
| 7 | 1.56 ms |
SELECT t0.id AS id_1, t0.input_code AS input_code_2, t0.input_type AS input_type_3, t0.input_label AS input_label_4, t0.obligatorio AS obligatorio_5, t0.activo AS activo_6, t0.visible AS visible_7, t0.input_default AS input_default_8, t0.orden AS orden_9, t0.api_type AS api_type_10, t0.value AS value_11, t0.attribute AS attribute_12, t0.producto_id AS producto_id_13, t0.detalle_rel_id AS detalle_rel_id_14 FROM detalle_producto t0 WHERE t0.producto_id = ? AND t0.input_code = ? AND t0.activo = ? LIMIT 1
Parameters:
[ 63 "cantidad" 1 ] |
| 8 | 1.91 ms |
SELECT t0.id AS id_1, t0.input_code AS input_code_2, t0.input_type AS input_type_3, t0.input_label AS input_label_4, t0.obligatorio AS obligatorio_5, t0.activo AS activo_6, t0.visible AS visible_7, t0.input_default AS input_default_8, t0.orden AS orden_9, t0.api_type AS api_type_10, t0.value AS value_11, t0.attribute AS attribute_12, t0.producto_id AS producto_id_13, t0.detalle_rel_id AS detalle_rel_id_14 FROM detalle_producto t0 WHERE t0.producto_id = ? AND t0.activo = ? ORDER BY t0.orden ASC
Parameters:
[ 63 1 ] |
| 9 | 2.35 ms |
SELECT t0.id AS id_1, t0.input_code AS input_code_2, t0.input_type AS input_type_3, t0.input_label AS input_label_4, t0.obligatorio AS obligatorio_5, t0.activo AS activo_6, t0.visible AS visible_7, t0.input_default AS input_default_8, t0.orden AS orden_9, t0.api_type AS api_type_10, t0.value AS value_11, t0.attribute AS attribute_12, t0.producto_id AS producto_id_13, t0.detalle_rel_id AS detalle_rel_id_14 FROM detalle_producto t0 WHERE t0.producto_id = ? ORDER BY t0.orden ASC
Parameters:
[
63
]
|
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\GrupoProductos | 1 |
| App\Entity\SubGrupoProducto | 1 |
| App\Entity\Producto | 1 |
| App\Entity\CarroCompra | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\GrupoProductos | No errors. |
| App\Entity\SubGrupoProducto | No errors. |
| App\Entity\Producto |
|
| App\Entity\AbstractPresupuesto | No errors. |
| App\Entity\Presupuesto | No errors. |
| App\Entity\DetalleProducto | No errors. |
| App\Entity\AbstractCarroCompra | No errors. |
| App\Entity\CarroCompra | No errors. |
| App\Entity\AbstractItemCarroCompra | No errors. |
| App\Entity\ItemCarroCompra | No errors. |
| App\Entity\Cliente | No errors. |