GET https://boschecommerce.blubear.io/shop/producto?id=21961

Query Metrics

32 Database Queries
25 Different statements
75.78 ms Query time
2 Invalid entities
44 Managed entities

Grouped Statements

Show all queries

Time Count Info
15.85 ms
(20.92%)
1
SELECT DISTINCT e0_.Nombres AS nombres_0, e0_.id AS id_1 FROM estructura_ecommerce_es e0_, producto_es p1_ WHERE e0_.Status = 1 AND p1_.cat1 = e0_.id AND p1_.status_eCommerce = 1 AND p1_.status_infor = 1 ORDER BY e0_.Nombres ASC
Parameters:
[]
5.30 ms
(6.99%)
3
SELECT t0.id AS id_1, t0.tipo AS tipo_2, t0.seccion AS seccion_3, t0.estado AS estado_4, t0.fecha_creacion AS fecha_creacion_5, t0.fecha_actualizacion AS fecha_actualizacion_6 FROM banner t0 WHERE t0.seccion = ? AND t0.estado = ?
Parameters:
[
  "PRINCIPAL"
  "A"
]
5.24 ms
(6.91%)
4
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.url AS url_3, t0.tipoAperturaUrl AS tipoaperturaurl_4, t0.footer_column_id AS footer_column_id_5 FROM footer_column_texto t0 WHERE t0.footer_column_id = ?
Parameters:
[
  2
]
4.99 ms
(6.59%)
1
SELECT a0_.id AS id_0, t1_.id AS id_1, a0_.Url AS url_2, a0_.Alt_text AS alt_text_3, a0_.nombre AS nombre_4, a0_.target_blank AS target_blank_5 FROM producto p2_ INNER JOIN adjuntos a0_ ON p2_.id = a0_.id_producto INNER JOIN tipo_documento t1_ ON a0_.id_tipo = t1_.id WHERE a0_.id_producto = ?
Parameters:
[
  "21961"
]
4.16 ms
(5.49%)
1
SELECT p0_.id AS id_0, p0_.Idinfor AS idinfor_1, p0_.Pvp AS pvp_2, p0_.Descripcion AS descripcion_3, p0_.Descripcion_corta AS descripcion_corta_4, p0_.Descripcion_larga AS descripcion_larga_5, p0_.url_foto AS url_foto_6, m1_.nombre AS nombre_7, p0_.Idfamilia AS idfamilia_8, f2_.Nombre AS nombre_9 FROM producto p0_ LEFT JOIN marca m1_ ON p0_.marca = m1_.id LEFT JOIN familia f2_ ON (f2_.Id_infor = p0_.Idfamilia) WHERE p0_.status_eCommerce = 1 AND p0_.id IN (SELECT DISTINCT d3_.id_producto_relacionado FROM detalle_producto_tipo_relacion d3_ WHERE d3_.id_producto = 21961 ORDER BY d3_.id_producto_relacionado ASC)
Parameters:
[]
4.12 ms
(5.43%)
2
SELECT t0.id AS id_1, t0.imagen_desktop AS imagen_desktop_2, t0.imagen_tablet AS imagen_tablet_3, t0.imagen_movil AS imagen_movil_4, t0.nombre_original_desktop AS nombre_original_desktop_5, t0.nombre_original_tablet AS nombre_original_tablet_6, t0.nombre_original_movil AS nombre_original_movil_7, t0.nombre_alterno AS nombre_alterno_8, t0.posicion AS posicion_9, t0.url_redirect AS url_redirect_10, t0.estado AS estado_11, t0.banner_id AS banner_id_12 FROM imagen t0 WHERE t0.banner_id = ? ORDER BY t0.posicion ASC
Parameters:
[
  15
]
3.12 ms
(4.12%)
1
SELECT c0_.id AS id_0, c0_.Nombre AS nombre_1, c1_.id AS id_2, c1_.valor AS valor_3 FROM producto p2_, familia f3_, caracteristica c0_, caracteristica_valor c1_, detalle_familia_caracteristica d4_ WHERE p2_.Idfamilia = f3_.Id_infor AND c0_.id = c1_.id_caracteristica AND c0_.id = d4_.id_caracteristica AND d4_.id_familia = f3_.id AND p2_.id = c1_.id_producto AND p2_.id = 21961 ORDER BY d4_.posicion ASC
Parameters:
[]
2.44 ms
(3.21%)
2
SELECT t0.id AS id_1, t0.imgNombreServidor AS imgnombreservidor_2, t0.imgNombreAlternativo AS imgnombrealternativo_3, t0.url AS url_4, t0.tipoAperturaUrl AS tipoaperturaurl_5, t0.texto_alternativo_imagen AS texto_alternativo_imagen_6, t0.footer_column_id AS footer_column_id_7 FROM footer_column_imagen t0 WHERE t0.footer_column_id = ?
Parameters:
[
  5
]
2.43 ms
(3.21%)
1
SELECT DISTINCT e0_.Nombres AS nombres_0, e0_.id AS id_1 FROM estructura_ecommerce_es e0_, producto_es p1_ WHERE e0_.Status = 1 AND e0_.Nivel = 2 AND p1_.cat1 = 199 AND p1_.cat2 = e0_.id ORDER BY e0_.Nombres ASC
Parameters:
[]
2.33 ms
(3.07%)
1
SELECT p0_.id AS id_0, p0_.Idinfor AS idinfor_1, p0_.Pvp AS pvp_2, p0_.Descripcion AS descripcion_3, p0_.Descripcion_corta AS descripcion_corta_4, p0_.Descripcion_larga AS descripcion_larga_5, p0_.url_foto AS url_foto_6, m1_.nombre AS nombre_7, p0_.Idfamilia AS idfamilia_8, f2_.Nombre AS nombre_9, p0_.estado_btc AS estado_btc_10, p0_.valor_descuento_bateria AS valor_descuento_bateria_11, p0_.descuento_bateria AS descuento_bateria_12 FROM producto p0_ LEFT JOIN marca m1_ ON p0_.marca = m1_.id LEFT JOIN familia f2_ ON (f2_.Id_infor = p0_.Idfamilia) WHERE p0_.id = ?
Parameters:
[
  "21961"
]
2.25 ms
(2.97%)
1
SELECT a0_.marca AS marca_0, a0_.modelo AS modelo_1, a0_.tipo AS sclr_2, e1_.nombre AS nombre_3 FROM detalle_producto_aplicacion d2_, aplicacion a0_, estructura_aplicacion e1_ WHERE 21961 = d2_.id_producto AND d2_.id_aplicacion = a0_.id AND e1_.id = a0_.tipo AND a0_.status = 1 GROUP BY a0_.marca, a0_.modelo, a0_.tipo, e1_.nombre ORDER BY a0_.marca ASC
Parameters:
[]
2.11 ms
(2.78%)
1
SELECT DISTINCT e0_.Nombres AS nombres_0, e0_.id AS id_1 FROM estructura_ecommerce_es e0_, producto_es p1_ WHERE e0_.Status = 1 AND e0_.Nivel = 2 AND p1_.cat1 = 198 AND p1_.cat2 = e0_.id ORDER BY e0_.Nombres ASC
Parameters:
[]
2.09 ms
(2.76%)
1
SELECT p0_.id AS id_0, p0_.Descripcion AS descripcion_1, p0_.Idinfor AS idinfor_2, p0_.Descripcion_corta AS descripcion_corta_3, p0_.Idfamilia AS idfamilia_4, c1_.Nombre AS nombre_5, c1_.id AS id_6, c2_.valor AS valor_7, p0_.url_foto AS url_foto_8, d3_.posicion AS posicion_9 FROM producto p0_, caracteristica_valor c2_, caracteristica c1_, familia f4_, detalle_familia_caracteristica d3_ WHERE d3_.id_caracteristica = c1_.id AND p0_.status_infor = 1 AND p0_.status_eCommerce = 1 AND p0_.marca IS NOT NULL AND p0_.Idfamilia = f4_.Id_infor AND d3_.id_familia = f4_.id AND c2_.id_producto = p0_.id AND c1_.id = c2_.id_caracteristica AND f4_.Comparar = 1 AND p0_.id = 21961
Parameters:
[]
2.06 ms
(2.71%)
1
SELECT DISTINCT e0_.Nombres AS nombres_0, e0_.id AS id_1 FROM estructura_ecommerce_es e0_, producto_es p1_ WHERE e0_.Status = 1 AND e0_.Nivel = 2 AND p1_.cat1 = 200 AND p1_.cat2 = e0_.id ORDER BY e0_.Nombres ASC
Parameters:
[]
1.94 ms
(2.56%)
1
SELECT p0_.id AS id_0, p0_.Descripcion AS descripcion_1, p0_.Descripcion_corta AS descripcion_corta_2, p0_.Idfamilia AS idfamilia_3, c1_.Nombre AS nombre_4, c1_.id AS id_5, '' AS sclr_6, p0_.url_foto AS url_foto_7, d2_.posicion AS posicion_8, f3_.Comparar AS comparar_9 FROM detalle_familia_caracteristica d2_, caracteristica c1_, producto p0_, familia f3_ WHERE d2_.id_caracteristica = c1_.id AND f3_.Id_infor = (SELECT f4_.Id_infor FROM familia f4_ WHERE f4_.Id_infor = p0_.Idfamilia) AND p0_.id = 21961 AND d2_.id_familia = f3_.id AND d2_.id_caracteristica NOT IN (SELECT c5_.id_caracteristica AS sclr_10 FROM caracteristica_valor c5_ WHERE c5_.id_producto = 21961)
Parameters:
[]
1.87 ms
(2.47%)
1
SELECT count(f0_.id) AS sclr_0 FROM footer_column f0_ WHERE f0_.estado = ? AND f0_.tipoColumna <> 'C' AND f0_.mostrar = ?
Parameters:
[
  "A"
  1
]
1.78 ms
(2.35%)
1
SELECT DISTINCT e0_.Nombres AS nombres_0, e0_.id AS id_1 FROM estructura_ecommerce_es e0_, producto_es p1_ WHERE e0_.Status = 1 AND e0_.Nivel = 2 AND p1_.cat1 = 201 AND p1_.cat2 = e0_.id ORDER BY e0_.Nombres ASC
Parameters:
[]
1.72 ms
(2.26%)
1
SELECT p0_.id AS id_0 FROM producto p0_ WHERE p0_.status_infor = 1 AND p0_.status_eCommerce = 1 AND p0_.marca IS NOT NULL AND p0_.id = 21961
Parameters:
[]
1.68 ms
(2.21%)
1
SELECT t0.id AS id_1, t0.Idinfor AS idinfor_2, t0.Descripcion AS descripcion_3, t0.Inventario AS inventario_4, t0.Pvp AS pvp_5, t0.Ultima_actualizacion AS ultima_actualizacion_6, t0.status_infor AS status_infor_7, t0.status_eCommerce AS status_ecommerce_8, t0.Idfamilia AS idfamilia_9, t0.Value_linea_de_producto AS value_linea_de_producto_10, t0.Value_grupo_estadistico AS value_grupo_estadistico_11, t0.Id_estructura_ecommerce AS id_estructura_ecommerce_12, t0.Descripcion_comercial AS descripcion_comercial_13, t0.Descripcion_corta AS descripcion_corta_14, t0.Descripcion_larga AS descripcion_larga_15, t0.Aplicaciones_relacionadas AS aplicaciones_relacionadas_16, t0.url_foto AS url_foto_17, t0.sesion AS sesion_18, t0.tiene_despiece AS tiene_despiece_19, t0.estado_btc AS estado_btc_20, t0.descuento_bateria AS descuento_bateria_21, t0.valor_descuento_bateria AS valor_descuento_bateria_22, t0.otros_productos AS otros_productos_23, t0.promocion_vigente AS promocion_vigente_24, t0.slogan AS slogan_25, t0.tipo_uso AS tipo_uso_26, t0.marca AS marca_27 FROM producto t0 WHERE t0.id = ?
Parameters:
[
  "21961"
]
1.63 ms
(2.15%)
1
SELECT DISTINCT e0_.Nombres AS nombres_0, e0_.id AS id_1 FROM estructura_ecommerce_es e0_, producto_es p1_ WHERE e0_.Status = 1 AND e0_.Nivel = 2 AND p1_.cat1 = 212 AND p1_.cat2 = e0_.id ORDER BY e0_.Nombres ASC
Parameters:
[]
1.52 ms
(2.01%)
1
SELECT c0_.id AS id_0, c0_.cross_reference AS cross_reference_1, c0_.marca AS marca_2, c0_.publico AS publico_3, c0_.activo AS activo_4, c0_.id_producto AS id_producto_5 FROM cross_references c0_ WHERE c0_.id_producto = ? AND c0_.publico = true
Parameters:
[
  21961
]
1.45 ms
(1.91%)
1
SELECT f0_.id AS id_0, f0_.posicion AS posicion_1, f0_.mostrar AS mostrar_2, f0_.nombreColumna AS nombrecolumna_3, f0_.estado AS estado_4, f0_.fechaCreacion AS fechacreacion_5, f0_.fechaActualizacion AS fechaactualizacion_6, f0_.tipoColumna AS tipocolumna_7 FROM footer_column f0_ WHERE f0_.estado = ? AND f0_.tipoColumna = ? AND f0_.mostrar = ?
Parameters:
[
  "A"
  "C"
  1
]
1.34 ms
(1.76%)
1
SELECT f0_.id AS id_0, f0_.posicion AS posicion_1, f0_.mostrar AS mostrar_2, f0_.nombreColumna AS nombrecolumna_3, f0_.estado AS estado_4, f0_.fechaCreacion AS fechacreacion_5, f0_.fechaActualizacion AS fechaactualizacion_6, f0_.tipoColumna AS tipocolumna_7 FROM footer_column f0_ WHERE f0_.estado = ? AND f0_.tipoColumna <> 'C' AND f0_.mostrar = ? ORDER BY f0_.posicion ASC
Parameters:
[
  "A"
  1
]
1.26 ms
(1.66%)
1
SELECT p0_.id AS id_0, p0_.Descripcion AS descripcion_1, p0_.Pvp AS pvp_2, p0_.Descripcion_larga AS descripcion_larga_3, p0_.url_foto AS url_foto_4 FROM producto p0_ WHERE p0_.id = 21961
Parameters:
[]
1.12 ms
(1.48%)
1
SELECT p0_.id AS id_0 FROM producto p0_ WHERE p0_.sesion = true AND p0_.id = 21961
Parameters:
[]

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\FooterColumnTexto 22
App\Entity\Imagen 6
App\Entity\FooterColumn 6
App\Entity\FooterColumnImagen 6
App\Entity\Banner 2
App\Entity\Producto 1
App\Entity\Marca 1

Entities Mapping

Class Mapping errors
App\Entity\Banner No errors.
App\Entity\Imagen No errors.
App\Entity\ClickBanner No errors.
App\Entity\Producto No errors.
App\Entity\DetalleProductoTipoRelacion No errors.
App\Entity\Users No errors.
App\Entity\User_frontend No errors.
App\Entity\Marca No errors.
App\Entity\Adjuntos No errors.
App\Entity\CrossReferences No errors.
App\Entity\Caracteristica_valor No errors.
App\Entity\DetalleProductoAplicacion No errors.
App\Entity\shopping_cart No errors.
App\Entity\DetalleOrden No errors.
App\Entity\Familia No errors.
App\Entity\TipoDocumento No errors.
App\Entity\Caracteristica No errors.
App\Entity\DetalleFamiliaCaracteristica No errors.
App\Entity\Aplicacion No errors.
App\Entity\EstructuraAplicacion No errors.
App\Entity\Estructura_ecommerce_ES No errors.
App\Entity\Producto_ES
  • The mappings App\Entity\Producto_ES#crossreferenceses and App\Entity\CrossReferences_ES#producto are inconsistent with each other.
App\Entity\FooterColumn No errors.
App\Entity\FooterColumnTexto No errors.
App\Entity\FooterColumnImagen No errors.
App\Entity\MarcaItemHome No errors.
App\Entity\Orden No errors.
App\Entity\Grupo No errors.
App\Entity\Marca_ES No errors.
App\Entity\Familia_ES No errors.
App\Entity\CrossReferences_ES
  • The association App\Entity\CrossReferences_ES#producto refers to the inverse side field App\Entity\Producto_ES#crossReferences which does not exist.
App\Entity\DetalleProductoAplicacion_ES No errors.
App\Entity\DetalleProductoTipoRelacion_ES No errors.
App\Entity\DetalleValorMarca_ES No errors.
App\Entity\Caracteristica_valor_ES No errors.
App\Entity\User_ecommerce No errors.
App\Entity\DatosFacturacion No errors.
App\Entity\DatosEntrega No errors.
App\Entity\TipoServicio No errors.
App\Entity\PuntoVenta No errors.
App\Entity\Pago No errors.
App\Entity\CanalContacto No errors.
App\Entity\EstadoOrden No errors.
App\Entity\EstadoServicio No errors.
App\Entity\DetalleFamiliaCaracteristica_ES No errors.
App\Entity\Aplicacion_ES No errors.
App\Entity\Caracteristica_ES No errors.