GET https://imprentareyes.pytlab.com/es/public/grupo/11/subgrupo/38/producto/20

Query Metrics

38 Database Queries
9 Different statements
51.34 ms Query time
1 Invalid entities
34 Managed entities

Queries

Group similar statements

# Time Info
1 5.63 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:
[
  "11"
]
2 3.35 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:
[
  "38"
]
3 14.24 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:
[
  "20"
]
4 1.96 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:
[
  20
  "cantidad"
  1
]
5 3.17 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:
[
  20
  1
]
6 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 = ? ORDER BY t0.orden ASC
Parameters:
[
  20
]
7 1.16 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:
[
  787
]
8 0.65 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:
[
  788
]
9 0.61 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:
[
  789
]
10 0.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.detalle_rel_id = ?
Parameters:
[
  790
]
11 0.72 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:
[
  791
]
12 0.99 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:
[
  794
]
13 0.65 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:
[
  795
]
14 0.71 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:
[
  796
]
15 0.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.detalle_rel_id = ?
Parameters:
[
  797
]
16 0.70 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:
[
  798
]
17 0.86 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:
[
  799
]
18 1.17 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:
[
  800
]
19 0.63 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:
[
  801
]
20 0.54 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:
[
  802
]
21 0.53 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:
[
  803
]
22 0.54 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:
[
  804
]
23 0.58 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:
[
  805
]
24 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:
[
  806
]
25 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:
[
  807
]
26 0.58 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:
[
  808
]
27 0.53 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:
[
  809
]
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:
[
  810
]
29 0.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.detalle_rel_id = ?
Parameters:
[
  811
]
30 0.69 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:
[
  812
]
31 0.65 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:
[
  815
]
32 0.61 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:
[
  792
]
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:
[
  793
]
34 0.62 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:
[
  816
]
35 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:
[
  813
]
36 0.66 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:
[
  814
]
37 0.99 ms
SELECT t0.id AS id_1, t0.localizador AS localizador_2, t0.precio_total AS precio_total_3, t0.estado AS estado_4, t0.fecha_pedido_int AS fecha_pedido_int_5, t0.num_pedido_int AS num_pedido_int_6, t0.estado_int AS estado_int_7, t0.debug AS debug_8, t0.cliente_id AS cliente_id_9 FROM carro_compra t0 WHERE t0.id = ?
Parameters:
[
  2055
]
38 0.56 ms
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.producto_id AS producto_id_6, t0.carro_compra_id AS carro_compra_id_7 FROM item_carro_compra t0 WHERE t0.carro_compra_id = ?
Parameters:
[
  2055
]

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 30
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
  • The association App\Entity\Producto#presupuestos refers to the owning side field App\Entity\Presupuesto#producto which does not exist.
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\Cliente No errors.
App\Entity\AbstractItemCarroCompra No errors.
App\Entity\ItemCarroCompra No errors.