GET https://imprentareyes.pytlab.com/es/public/grupo/7/subgrupo/22/producto/61

Response
200 OK
IP
216.73.216.24
Profiled on
Token
5f1ddf

Query Metrics

18 Database Queries
10 Different statements
81.25 ms Query time
1 Invalid entities
15 Managed entities

Queries

Group similar statements

#▲ Time Info
1 12.16 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: 
[
  "7"
]
View formatted query    View runnable query    Explain query
2 11.00 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: 
[
  "22"
]
View formatted query    View runnable query    Explain query
3 1.07 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: 
[
  "61"
]
View formatted query    View runnable query    Explain query
4 18.85 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: 
[
  61
  "cantidad"
  1
]
View formatted query    View runnable query    Explain query
5 1.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.producto_id = ? AND t0.activo = ? ORDER BY t0.orden ASC
Parameters: 
[
  61
  1
]
View formatted query    View runnable query    Explain query
6 3.95 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: 
[
  61
]
View formatted query    View runnable query    Explain query
7 1.12 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: 
[
  1183
]
View formatted query    View runnable query    Explain query
8 8.85 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: 
[
  1184
]
View formatted query    View runnable query    Explain query
9 9.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: 
[
  1185
]
View formatted query    View runnable query    Explain query
10 1.28 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: 
[
  1186
]
View formatted query    View runnable query    Explain query
11 1.40 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: 
[
  1187
]
View formatted query    View runnable query    Explain query
12 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: 
[
  1188
]
View formatted query    View runnable query    Explain query
13 0.78 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.id = ?
Parameters: 
[
  853
]
View formatted query    View runnable query    Explain query
14 0.75 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: 
[
  1189
]
View formatted query    View runnable query    Explain query
15 0.77 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: 
[
  1190
]
View formatted query    View runnable query    Explain query
16 1.10 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: 
[
  1191
]
View formatted query    View runnable query    Explain query
17 2.06 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
]
View formatted query    View runnable query    Explain query
18 4.27 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
]
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 10
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
  • 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.