Query Metrics
31
Database Queries
11
Different statements
18.00 ms
Query time
1
Invalid entities
27
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
10.45 ms (58.07%) |
21 |
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.detalle_rel_id = ?
Parameters:
[
1162
]
|
|
1.19 ms (6.62%) |
1 |
SELECT t0.id AS id_1, t0.ruta AS ruta_2, t0.orden AS orden_3, t0.producto_id AS producto_id_4 FROM producto_imagen t0 WHERE t0.producto_id = ? ORDER BY t0.orden ASC
Parameters:
[
60
]
|
|
1.13 ms (6.26%) |
1 |
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:
[
60
]
|
|
0.89 ms (4.96%) |
1 |
SELECT t0.id AS id_1, t0.localizador AS localizador_2, t0.precio_total AS precio_total_3, t0.importe_base AS importe_base_4, t0.importe_impuestos AS importe_impuestos_5, t0.estado AS estado_6, t0.fecha_pedido_int AS fecha_pedido_int_7, t0.num_pedido_int AS num_pedido_int_8, t0.estado_int AS estado_int_9, t0.debug AS debug_10, t0.cliente_id AS cliente_id_11 FROM carro_compra t0 WHERE t0.id = ?
Parameters:
[
2500
]
|
|
0.79 ms (4.40%) |
1 |
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:
[ 60 1 ] |
|
0.76 ms (4.21%) |
1 |
SELECT t0.id AS id_1, t0.cantidad AS cantidad_2, t0.precio_unitario AS precio_unitario_3, t0.observacion AS observacion_4, t0.localizador AS localizador_5, t0.suplemento_diseno AS suplemento_diseno_6, t0.producto_id AS producto_id_7, t0.carro_compra_id AS carro_compra_id_8 FROM item_carro_compra t0 WHERE t0.carro_compra_id = ?
Parameters:
[
2500
]
|
|
0.67 ms (3.72%) |
1 |
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:
[
"7"
]
|
|
0.63 ms (3.51%) |
1 |
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:
[ 60 "cantidad" 1 ] |
|
0.63 ms (3.49%) |
1 |
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.faq AS faq_13, t0.activo AS activo_14, t0.descripcion_corta AS descripcion_corta_15, t0.tipo_pedido AS tipo_pedido_16, t0.job_template_code AS job_template_code_17, t0.sub_grupo_producto_id AS sub_grupo_producto_id_18 FROM producto t0 WHERE t0.id = ?
Parameters:
[
"60"
]
|
|
0.46 ms (2.54%) |
1 |
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.id = ?
Parameters:
[
853
]
|
|
0.40 ms (2.24%) |
1 |
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:
[
"22"
]
|
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\DetalleProducto | 22 |
| App\Entity\Producto | 2 |
| App\Entity\GrupoProductos | 1 |
| App\Entity\SubGrupoProducto | 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\ProductoImagen | No errors. |
| App\Entity\AbstractCarroCompra | No errors. |
| App\Entity\CarroCompra | No errors. |
| App\Entity\Cliente | No errors. |
| App\Entity\AbstractItemCarroCompra | No errors. |
| App\Entity\ItemCarroCompra | No errors. |