Query Metrics
33
Database Queries
10
Different statements
22.75 ms
Query time
1
Invalid entities
28
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.80 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:
[
"9"
]
|
| 2 | 0.47 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:
[
"44"
]
|
| 3 | 0.67 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:
[
"21"
]
|
| 4 | 0.29 ms |
"START TRANSACTION"
Parameters:
[] |
| 5 | 0.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 | 1.19 ms |
"COMMIT"
Parameters:
[] |
| 7 | 1.73 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:
[ 21 "cantidad" 1 ] |
| 8 | 1.18 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:
[ 21 1 ] |
| 9 | 1.57 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:
[
21
]
|
| 10 | 0.82 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.detalle_rel_id = ?
Parameters:
[
340
]
|
| 11 | 0.82 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.detalle_rel_id = ?
Parameters:
[
343
]
|
| 12 | 2.06 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.detalle_rel_id = ?
Parameters:
[
344
]
|
| 13 | 0.49 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.detalle_rel_id = ?
Parameters:
[
345
]
|
| 14 | 0.47 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.detalle_rel_id = ?
Parameters:
[
346
]
|
| 15 | 0.55 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.detalle_rel_id = ?
Parameters:
[
347
]
|
| 16 | 0.47 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.detalle_rel_id = ?
Parameters:
[
348
]
|
| 17 | 0.49 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.detalle_rel_id = ?
Parameters:
[
349
]
|
| 18 | 0.50 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.detalle_rel_id = ?
Parameters:
[
350
]
|
| 19 | 0.50 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.detalle_rel_id = ?
Parameters:
[
351
]
|
| 20 | 0.45 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.detalle_rel_id = ?
Parameters:
[
352
]
|
| 21 | 0.48 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.detalle_rel_id = ?
Parameters:
[
353
]
|
| 22 | 0.51 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.detalle_rel_id = ?
Parameters:
[
354
]
|
| 23 | 0.50 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.detalle_rel_id = ?
Parameters:
[
355
]
|
| 24 | 0.46 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.detalle_rel_id = ?
Parameters:
[
356
]
|
| 25 | 0.46 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.detalle_rel_id = ?
Parameters:
[
357
]
|
| 26 | 0.47 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.detalle_rel_id = ?
Parameters:
[
358
]
|
| 27 | 0.50 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.detalle_rel_id = ?
Parameters:
[
359
]
|
| 28 | 0.55 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.detalle_rel_id = ?
Parameters:
[
360
]
|
| 29 | 0.48 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.detalle_rel_id = ?
Parameters:
[
361
]
|
| 30 | 0.50 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.detalle_rel_id = ?
Parameters:
[
362
]
|
| 31 | 0.52 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.detalle_rel_id = ?
Parameters:
[
341
]
|
| 32 | 0.47 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.detalle_rel_id = ?
Parameters:
[
342
]
|
| 33 | 0.55 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.detalle_rel_id = ?
Parameters:
[
363
]
|
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 | 24 |
| 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. |