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

Query Metrics

39 Database Queries
12 Different statements
131.76 ms Query time
1 Invalid entities
33 Managed entities

Grouped Statements

Show all queries

Time Count Info
46.21 ms
(35.07%)
28
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:
[
  364
]
17.00 ms
(12.90%)
1
INSERT INTO carro_compra (localizador, precio_total, importe_base, importe_impuestos, estado, fecha_pedido_int, num_pedido_int, estado_int, debug, cliente_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  null
  0.0
  0.0
  0.0
  0
  null
  null
  null
  null
  null
]
13.46 ms
(10.22%)
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:
[
  "3"
]
13.15 ms
(9.98%)
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:
[
  "7"
]
10.81 ms
(8.21%)
1
"START TRANSACTION"
Parameters:
[]
10.80 ms
(8.20%)
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:
[
  22
]
9.42 ms
(7.15%)
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:
[
  "22"
]
4.52 ms
(3.43%)
1
"COMMIT"
Parameters:
[]
2.92 ms
(2.22%)
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:
[
  22
]
2.04 ms
(1.55%)
1
SELECT t0.id AS id_1, t0.codigo AS codigo_2, t0.tasa AS tasa_3, t0.label_key AS label_key_4, t0.activo AS activo_5 FROM impuesto t0 WHERE t0.codigo = ? AND t0.activo = ? LIMIT 1
Parameters:
[
  "IGIC_GENERAL"
  1
]
0.75 ms
(0.57%)
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:
[
  22
  1
]
0.66 ms
(0.50%)
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:
[
  22
  "cantidad"
  1
]

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 28
App\Entity\GrupoProductos 1
App\Entity\SubGrupoProducto 1
App\Entity\Producto 1
App\Entity\Impuesto 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\ProductoImagen No errors.
App\Entity\Impuesto 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.