GET https://imprentareyes.pytlab.com/es/public/grupo/12/subgrupo/27/producto/56

Response
200 OK
IP
216.73.216.24
Profiled on
Token
c7d495

Query Metrics

40 Database Queries
9 Different statements
31.78 ms Query time
1 Invalid entities
36 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
17.31 ms
(54.45%) 		32 
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: 
[
  969
]
View formatted query    View runnable query    Explain query
5.37 ms
(16.89%) 		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: 
[
  56
  "cantidad"
  1
]
View formatted query    View runnable query    Explain query
2.52 ms
(7.93%) 		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.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: 
[
  "56"
]
View formatted query    View runnable query    Explain query
1.41 ms
(4.43%) 		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: 
[
  56
  1
]
View formatted query    View runnable query    Explain query
1.36 ms
(4.29%) 		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: 
[
  56
]
View formatted query    View runnable query    Explain query
1.26 ms
(3.96%) 		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: 
[
  "12"
]
View formatted query    View runnable query    Explain query
0.95 ms
(2.97%) 		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.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
]
View formatted query    View runnable query    Explain query
0.94 ms
(2.95%) 		1 
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
]
View formatted query    View runnable query    Explain query
0.68 ms
(2.13%) 		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: 
[
  "27"
]
View formatted query    View runnable query    Explain query

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 32
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.