Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.resumen AS resumen_3,
  t0.thumbnail AS thumbnail_4,
  t0.imagen AS imagen_5,
  t0.costo AS costo_6,
  t0.precio AS precio_7,
  t0.destacado AS destacado_8,
  t0.orden AS orden_9,
  t0.visible AS visible_10,
  t0.updated_at AS updated_at_11,
  t0.pum AS pum_12,
  t0.iva AS iva_13,
  t0.registro_invima AS registro_invima_14,
  t0.precio_sin_descuento AS precio_sin_descuento_15,
  t0.es_promo AS es_promo_16,
  t0.destacado_categoria AS destacado_categoria_17,
  t0.nombre_comercial AS nombre_comercial_18,
  t0.referencia AS referencia_19,
  t0.descuento AS descuento_20,
  t0.ean AS ean_21,
  t0.medida AS medida_22,
  t0.precio_sin_inva AS precio_sin_inva_23,
  t0.descripcion AS descripcion_24,
  t0.tela AS tela_25,
  t0.peso AS peso_26,
  t0.productos_incluidos AS productos_incluidos_27,
  t0.alternativa AS alternativa_28,
  t0.productos_no_incluidos AS productos_no_incluidos_29,
  t0.recomendaciones AS recomendaciones_30,
  t0.garantia AS garantia_31,
  t0.peso_a_soportar AS peso_a_soportar_32,
  t0.color_texto AS color_texto_33,
  t0.tecnologia AS tecnologia_34,
  t0.tipologia AS tipologia_35,
  t0.adaptabilidad AS adaptabilidad_36,
  t0.independencia AS independencia_37,
  t0.gamma AS gamma_38,
  t0.maestro AS maestro_39,
  t0.materiales AS materiales_40,
  t0.ficha_tecnica AS ficha_tecnica_41,
  t0.imagen_beneficios AS imagen_beneficios_42,
  t0.calidad AS calidad_43,
  t0.responsabilidad AS responsabilidad_44,
  t0.detalles AS detalles_45,
  t0.imagen_puntos AS imagen_puntos_46,
  t0.imagen_firmeza AS imagen_firmeza_47,
  t0.imagen_puntos_extendida AS imagen_puntos_extendida_48,
  t0.gif_puntos AS gif_puntos_49,
  t0.video AS video_50,
  t0.nuevo AS nuevo_51,
  t0.etiqueta AS etiqueta_52,
  t0.alt AS alt_53,
  t0.principal AS principal_54,
  t0.slug AS slug_55,
  t0.descripcion_seo AS descripcion_seo_56,
  t0.tamanio AS tamanio_57,
  t0.imgcalidad AS imgcalidad_58,
  t0.imgresponsabilidad AS imgresponsabilidad_59,
  t0.imgtecnologia AS imgtecnologia_60,
  t0.incarrito AS incarrito_61,
  t0.dctoic AS dctoic_62,
  t0.titulo_seo AS titulo_seo_63,
  t0.etiquetaprodtext AS etiquetaprodtext_64,
  t0.etiquetaprodimg AS etiquetaprodimg_65,
  t0.padre_id AS padre_id_66,
  t0.material_id AS material_id_67,
  t0.subcategoria_id AS subcategoria_id_68,
  t0.medidas_id AS medidas_id_69,
  t0.rotulo_id AS rotulo_id_70
FROM
  producto t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.resumen AS resumen_3, t0.thumbnail AS thumbnail_4, t0.imagen AS imagen_5, t0.costo AS costo_6, t0.precio AS precio_7, t0.destacado AS destacado_8, t0.orden AS orden_9, t0.visible AS visible_10, t0.updated_at AS updated_at_11, t0.pum AS pum_12, t0.iva AS iva_13, t0.registro_invima AS registro_invima_14, t0.precio_sin_descuento AS precio_sin_descuento_15, t0.es_promo AS es_promo_16, t0.destacado_categoria AS destacado_categoria_17, t0.nombre_comercial AS nombre_comercial_18, t0.referencia AS referencia_19, t0.descuento AS descuento_20, t0.ean AS ean_21, t0.medida AS medida_22, t0.precio_sin_inva AS precio_sin_inva_23, t0.descripcion AS descripcion_24, t0.tela AS tela_25, t0.peso AS peso_26, t0.productos_incluidos AS productos_incluidos_27, t0.alternativa AS alternativa_28, t0.productos_no_incluidos AS productos_no_incluidos_29, t0.recomendaciones AS recomendaciones_30, t0.garantia AS garantia_31, t0.peso_a_soportar AS peso_a_soportar_32, t0.color_texto AS color_texto_33, t0.tecnologia AS tecnologia_34, t0.tipologia AS tipologia_35, t0.adaptabilidad AS adaptabilidad_36, t0.independencia AS independencia_37, t0.gamma AS gamma_38, t0.maestro AS maestro_39, t0.materiales AS materiales_40, t0.ficha_tecnica AS ficha_tecnica_41, t0.imagen_beneficios AS imagen_beneficios_42, t0.calidad AS calidad_43, t0.responsabilidad AS responsabilidad_44, t0.detalles AS detalles_45, t0.imagen_puntos AS imagen_puntos_46, t0.imagen_firmeza AS imagen_firmeza_47, t0.imagen_puntos_extendida AS imagen_puntos_extendida_48, t0.gif_puntos AS gif_puntos_49, t0.video AS video_50, t0.nuevo AS nuevo_51, t0.etiqueta AS etiqueta_52, t0.alt AS alt_53, t0.principal AS principal_54, t0.slug AS slug_55, t0.descripcion_seo AS descripcion_seo_56, t0.tamanio AS tamanio_57, t0.imgcalidad AS imgcalidad_58, t0.imgresponsabilidad AS imgresponsabilidad_59, t0.imgtecnologia AS imgtecnologia_60, t0.incarrito AS incarrito_61, t0.dctoic AS dctoic_62, t0.titulo_seo AS titulo_seo_63, t0.etiquetaprodtext AS etiquetaprodtext_64, t0.etiquetaprodimg AS etiquetaprodimg_65, t0.padre_id AS padre_id_66, t0.material_id AS material_id_67, t0.subcategoria_id AS subcategoria_id_68, t0.medidas_id AS medidas_id_69, t0.rotulo_id AS rotulo_id_70 FROM producto t0 WHERE t0.id = '90077875';

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.orden AS orden_3,
  t0.visible AS visible_4,
  t0.icono AS icono_5,
  t0.imagen AS imagen_6,
  t0.descripcion AS descripcion_7,
  t0.home AS home_8,
  t0.referencia AS referencia_9,
  t0.icono_blanco AS icono_blanco_10,
  t0.slug AS slug_11,
  t0.avatar AS avatar_12,
  t0.categoria_id AS categoria_id_13
FROM
  subcategoria t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.orden AS orden_3, t0.visible AS visible_4, t0.icono AS icono_5, t0.imagen AS imagen_6, t0.descripcion AS descripcion_7, t0.home AS home_8, t0.referencia AS referencia_9, t0.icono_blanco AS icono_blanco_10, t0.slug AS slug_11, t0.avatar AS avatar_12, t0.categoria_id AS categoria_id_13 FROM subcategoria t0 WHERE t0.id = 301 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.resumen AS resumen_3,
  t0.imagen AS imagen_4,
  t0.orden AS orden_5,
  t0.visible AS visible_6,
  t0.home AS home_7,
  t0.referencia AS referencia_8,
  t0.imagen_desplegable AS imagen_desplegable_9,
  t0.product_destac AS product_destac_10,
  t0.desplegable AS desplegable_11,
  t0.slug AS slug_12,
  t0.img_banner AS img_banner_13,
  t0.img_banner_mobile AS img_banner_mobile_14,
  t0.segmento_id AS segmento_id_15
FROM
  categoria t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.resumen AS resumen_3, t0.imagen AS imagen_4, t0.orden AS orden_5, t0.visible AS visible_6, t0.home AS home_7, t0.referencia AS referencia_8, t0.imagen_desplegable AS imagen_desplegable_9, t0.product_destac AS product_destac_10, t0.desplegable AS desplegable_11, t0.slug AS slug_12, t0.img_banner AS img_banner_13, t0.img_banner_mobile AS img_banner_mobile_14, t0.segmento_id AS segmento_id_15 FROM categoria t0 WHERE t0.id = 3;

SELECT
  s0_.id AS id_0,
  s0_.nombre AS nombre_1,
  s0_.referencia AS referencia_2,
  s0_.icono_blanco AS icono_blanco_3,
  s0_.icono AS icono_4,
  s0_.slug AS slug_5,
  c1_.nombre AS nombre_6,
  s0_.descripcion AS descripcion_7,
  s0_.imagen AS imagen_8,
  s0_.avatar AS avatar_9,
  v2_.idyoutube AS idyoutube_10
FROM
  producto p3_
  LEFT JOIN subcategoria s0_ ON p3_.subcategoria_id = s0_.id
  LEFT JOIN video v2_ ON s0_.id = v2_.subcategoria_id
  LEFT JOIN categoria c1_ ON s0_.categoria_id = c1_.id
WHERE
  c1_.id = ?
  AND s0_.visible = 1
GROUP BY
  s0_.id
ORDER BY
  s0_.orden ASC

SELECT s0_.id AS id_0, s0_.nombre AS nombre_1, s0_.referencia AS referencia_2, s0_.icono_blanco AS icono_blanco_3, s0_.icono AS icono_4, s0_.slug AS slug_5, c1_.nombre AS nombre_6, s0_.descripcion AS descripcion_7, s0_.imagen AS imagen_8, s0_.avatar AS avatar_9, v2_.idyoutube AS idyoutube_10 FROM producto p3_ LEFT JOIN subcategoria s0_ ON p3_.subcategoria_id = s0_.id LEFT JOIN video v2_ ON s0_.id = v2_.subcategoria_id LEFT JOIN categoria c1_ ON s0_.categoria_id = c1_.id WHERE c1_.id = 3 AND s0_.visible = 1 GROUP BY s0_.id ORDER BY s0_.orden ASC;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.icono AS icono_3,
  t0.referencia AS referencia_4,
  t0.orden AS orden_5,
  t0.visible AS visible_6,
  t0.categoria_id AS categoria_id_7
FROM
  material t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.icono AS icono_3, t0.referencia AS referencia_4, t0.orden AS orden_5, t0.visible AS visible_6, t0.categoria_id AS categoria_id_7 FROM material t0 WHERE t0.id = 1757 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.codigo AS codigo_3
FROM
  lista_precios t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo AS codigo_3 FROM lista_precios t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.precio AS precio_2,
  t0.precio_sin_iva AS precio_sin_iva_3,
  t0.precio_sin_descuento AS precio_sin_descuento_4,
  t0.descuento AS descuento_5,
  t0.producto_id AS producto_id_6,
  t0.lista_id AS lista_id_7
FROM
  lista_precio_item t0
WHERE
  t0.lista_id = ?
  AND t0.producto_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.precio AS precio_2, t0.precio_sin_iva AS precio_sin_iva_3, t0.precio_sin_descuento AS precio_sin_descuento_4, t0.descuento AS descuento_5, t0.producto_id AS producto_id_6, t0.lista_id AS lista_id_7 FROM lista_precio_item t0 WHERE t0.lista_id = 1 AND t0.producto_id = '90077875' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.nombre AS nombre_1,
  p0_.tamanio AS tamanio_2,
  p0_.maestro AS maestro_3,
  p0_.tipologia AS tipologia_4,
  p0_.materiales AS materiales_5,
  m1_.nombre AS nombre_6,
  m2_.nombre AS nombre_7,
  m1_.id AS id_8,
  m1_.orden AS orden_9
FROM
  producto p0_
  LEFT JOIN medidas m1_ ON p0_.medidas_id = m1_.id
  LEFT JOIN material m2_ ON p0_.material_id = m2_.id
WHERE
  p0_.maestro = ?
ORDER BY
  orden_9 ASC

SELECT p0_.id AS id_0, p0_.nombre AS nombre_1, p0_.tamanio AS tamanio_2, p0_.maestro AS maestro_3, p0_.tipologia AS tipologia_4, p0_.materiales AS materiales_5, m1_.nombre AS nombre_6, m2_.nombre AS nombre_7, m1_.id AS id_8, m1_.orden AS orden_9 FROM producto p0_ LEFT JOIN medidas m1_ ON p0_.medidas_id = m1_.id LEFT JOIN material m2_ ON p0_.material_id = m2_.id WHERE p0_.maestro = 28 ORDER BY orden_9 ASC;

SELECT
  i0_.id AS id_0,
  i0_.image AS image_1,
  i0_.orden AS orden_2,
  i0_.visible AS visible_3,
  i0_.updated_at AS updated_at_4,
  i0_.titulo AS titulo_5,
  i0_.descripcion AS descripcion_6,
  i0_.ver_mas AS ver_mas_7,
  i0_.llave AS llave_8,
  i0_.link AS link_9,
  i0_.alt AS alt_10,
  i0_.fechaini AS fechaini_11,
  i0_.fechafin AS fechafin_12,
  i0_.galeria_id AS galeria_id_13,
  i0_.producto_id AS producto_id_14,
  i0_.tienda_id AS tienda_id_15
FROM
  image i0_
  LEFT JOIN producto p1_ ON i0_.producto_id = p1_.id
WHERE
  p1_.id = 90077875
  AND i0_.visible = 1
ORDER BY
  i0_.orden ASC

SELECT i0_.id AS id_0, i0_.image AS image_1, i0_.orden AS orden_2, i0_.visible AS visible_3, i0_.updated_at AS updated_at_4, i0_.titulo AS titulo_5, i0_.descripcion AS descripcion_6, i0_.ver_mas AS ver_mas_7, i0_.llave AS llave_8, i0_.link AS link_9, i0_.alt AS alt_10, i0_.fechaini AS fechaini_11, i0_.fechafin AS fechafin_12, i0_.galeria_id AS galeria_id_13, i0_.producto_id AS producto_id_14, i0_.tienda_id AS tienda_id_15 FROM image i0_ LEFT JOIN producto p1_ ON i0_.producto_id = p1_.id WHERE p1_.id = 90077875 AND i0_.visible = 1 ORDER BY i0_.orden ASC;

SELECT
  p0_.id AS id_0,
  p0_.nombre AS nombre_1,
  p0_.resumen AS resumen_2,
  p0_.thumbnail AS thumbnail_3,
  p0_.imagen AS imagen_4,
  p0_.costo AS costo_5,
  p0_.precio AS precio_6,
  p0_.destacado AS destacado_7,
  p0_.orden AS orden_8,
  p0_.visible AS visible_9,
  p0_.updated_at AS updated_at_10,
  p0_.pum AS pum_11,
  p0_.iva AS iva_12,
  p0_.registro_invima AS registro_invima_13,
  p0_.precio_sin_descuento AS precio_sin_descuento_14,
  p0_.es_promo AS es_promo_15,
  p0_.destacado_categoria AS destacado_categoria_16,
  p0_.nombre_comercial AS nombre_comercial_17,
  p0_.referencia AS referencia_18,
  p0_.descuento AS descuento_19,
  p0_.ean AS ean_20,
  p0_.medida AS medida_21,
  p0_.precio_sin_inva AS precio_sin_inva_22,
  p0_.descripcion AS descripcion_23,
  p0_.tela AS tela_24,
  p0_.peso AS peso_25,
  p0_.productos_incluidos AS productos_incluidos_26,
  p0_.alternativa AS alternativa_27,
  p0_.productos_no_incluidos AS productos_no_incluidos_28,
  p0_.recomendaciones AS recomendaciones_29,
  p0_.garantia AS garantia_30,
  p0_.peso_a_soportar AS peso_a_soportar_31,
  p0_.color_texto AS color_texto_32,
  p0_.tecnologia AS tecnologia_33,
  p0_.tipologia AS tipologia_34,
  p0_.adaptabilidad AS adaptabilidad_35,
  p0_.independencia AS independencia_36,
  p0_.gamma AS gamma_37,
  p0_.maestro AS maestro_38,
  p0_.materiales AS materiales_39,
  p0_.ficha_tecnica AS ficha_tecnica_40,
  p0_.imagen_beneficios AS imagen_beneficios_41,
  p0_.calidad AS calidad_42,
  p0_.responsabilidad AS responsabilidad_43,
  p0_.detalles AS detalles_44,
  p0_.imagen_puntos AS imagen_puntos_45,
  p0_.imagen_firmeza AS imagen_firmeza_46,
  p0_.imagen_puntos_extendida AS imagen_puntos_extendida_47,
  p0_.gif_puntos AS gif_puntos_48,
  p0_.video AS video_49,
  p0_.nuevo AS nuevo_50,
  p0_.etiqueta AS etiqueta_51,
  p0_.alt AS alt_52,
  p0_.principal AS principal_53,
  p0_.slug AS slug_54,
  p0_.descripcion_seo AS descripcion_seo_55,
  p0_.tamanio AS tamanio_56,
  p0_.imgcalidad AS imgcalidad_57,
  p0_.imgresponsabilidad AS imgresponsabilidad_58,
  p0_.imgtecnologia AS imgtecnologia_59,
  p0_.incarrito AS incarrito_60,
  p0_.dctoic AS dctoic_61,
  p0_.titulo_seo AS titulo_seo_62,
  p0_.etiquetaprodtext AS etiquetaprodtext_63,
  p0_.etiquetaprodimg AS etiquetaprodimg_64,
  b1_.id AS id_65,
  b1_.nombre AS nombre_66,
  b1_.icono AS icono_67,
  b1_.resumen AS resumen_68,
  b1_.orden AS orden_69,
  b1_.visible AS visible_70,
  p2_.id AS id_71,
  p2_.x AS x_72,
  p2_.y AS y_73,
  p2_.numero AS numero_74,
  p2_.titulo AS titulo_75,
  p2_.resumen AS resumen_76,
  p2_.direccion AS direccion_77,
  p3_.id AS id_78,
  p3_.nombre AS nombre_79,
  p3_.resumen AS resumen_80,
  p3_.thumbnail AS thumbnail_81,
  p3_.imagen AS imagen_82,
  p3_.costo AS costo_83,
  p3_.precio AS precio_84,
  p3_.destacado AS destacado_85,
  p3_.orden AS orden_86,
  p3_.visible AS visible_87,
  p3_.updated_at AS updated_at_88,
  p3_.pum AS pum_89,
  p3_.iva AS iva_90,
  p3_.registro_invima AS registro_invima_91,
  p3_.precio_sin_descuento AS precio_sin_descuento_92,
  p3_.es_promo AS es_promo_93,
  p3_.destacado_categoria AS destacado_categoria_94,
  p3_.nombre_comercial AS nombre_comercial_95,
  p3_.referencia AS referencia_96,
  p3_.descuento AS descuento_97,
  p3_.ean AS ean_98,
  p3_.medida AS medida_99,
  p3_.precio_sin_inva AS precio_sin_inva_100,
  p3_.descripcion AS descripcion_101,
  p3_.tela AS tela_102,
  p3_.peso AS peso_103,
  p3_.productos_incluidos AS productos_incluidos_104,
  p3_.alternativa AS alternativa_105,
  p3_.productos_no_incluidos AS productos_no_incluidos_106,
  p3_.recomendaciones AS recomendaciones_107,
  p3_.garantia AS garantia_108,
  p3_.peso_a_soportar AS peso_a_soportar_109,
  p3_.color_texto AS color_texto_110,
  p3_.tecnologia AS tecnologia_111,
  p3_.tipologia AS tipologia_112,
  p3_.adaptabilidad AS adaptabilidad_113,
  p3_.independencia AS independencia_114,
  p3_.gamma AS gamma_115,
  p3_.maestro AS maestro_116,
  p3_.materiales AS materiales_117,
  p3_.ficha_tecnica AS ficha_tecnica_118,
  p3_.imagen_beneficios AS imagen_beneficios_119,
  p3_.calidad AS calidad_120,
  p3_.responsabilidad AS responsabilidad_121,
  p3_.detalles AS detalles_122,
  p3_.imagen_puntos AS imagen_puntos_123,
  p3_.imagen_firmeza AS imagen_firmeza_124,
  p3_.imagen_puntos_extendida AS imagen_puntos_extendida_125,
  p3_.gif_puntos AS gif_puntos_126,
  p3_.video AS video_127,
  p3_.nuevo AS nuevo_128,
  p3_.etiqueta AS etiqueta_129,
  p3_.alt AS alt_130,
  p3_.principal AS principal_131,
  p3_.slug AS slug_132,
  p3_.descripcion_seo AS descripcion_seo_133,
  p3_.tamanio AS tamanio_134,
  p3_.imgcalidad AS imgcalidad_135,
  p3_.imgresponsabilidad AS imgresponsabilidad_136,
  p3_.imgtecnologia AS imgtecnologia_137,
  p3_.incarrito AS incarrito_138,
  p3_.dctoic AS dctoic_139,
  p3_.titulo_seo AS titulo_seo_140,
  p3_.etiquetaprodtext AS etiquetaprodtext_141,
  p3_.etiquetaprodimg AS etiquetaprodimg_142
FROM
  producto p0_
  LEFT JOIN producto_beneficio p4_ ON p0_.id = p4_.producto_id
  LEFT JOIN beneficio b1_ ON b1_.id = p4_.beneficio_id
  LEFT JOIN punto p2_ ON p0_.id = p2_.directo_id
  LEFT JOIN producto_producto p5_ ON p0_.id = p5_.producto_source
  LEFT JOIN producto p3_ ON p3_.id = p5_.producto_target
WHERE
  p0_.maestro = ?

SELECT p0_.id AS id_0, p0_.nombre AS nombre_1, p0_.resumen AS resumen_2, p0_.thumbnail AS thumbnail_3, p0_.imagen AS imagen_4, p0_.costo AS costo_5, p0_.precio AS precio_6, p0_.destacado AS destacado_7, p0_.orden AS orden_8, p0_.visible AS visible_9, p0_.updated_at AS updated_at_10, p0_.pum AS pum_11, p0_.iva AS iva_12, p0_.registro_invima AS registro_invima_13, p0_.precio_sin_descuento AS precio_sin_descuento_14, p0_.es_promo AS es_promo_15, p0_.destacado_categoria AS destacado_categoria_16, p0_.nombre_comercial AS nombre_comercial_17, p0_.referencia AS referencia_18, p0_.descuento AS descuento_19, p0_.ean AS ean_20, p0_.medida AS medida_21, p0_.precio_sin_inva AS precio_sin_inva_22, p0_.descripcion AS descripcion_23, p0_.tela AS tela_24, p0_.peso AS peso_25, p0_.productos_incluidos AS productos_incluidos_26, p0_.alternativa AS alternativa_27, p0_.productos_no_incluidos AS productos_no_incluidos_28, p0_.recomendaciones AS recomendaciones_29, p0_.garantia AS garantia_30, p0_.peso_a_soportar AS peso_a_soportar_31, p0_.color_texto AS color_texto_32, p0_.tecnologia AS tecnologia_33, p0_.tipologia AS tipologia_34, p0_.adaptabilidad AS adaptabilidad_35, p0_.independencia AS independencia_36, p0_.gamma AS gamma_37, p0_.maestro AS maestro_38, p0_.materiales AS materiales_39, p0_.ficha_tecnica AS ficha_tecnica_40, p0_.imagen_beneficios AS imagen_beneficios_41, p0_.calidad AS calidad_42, p0_.responsabilidad AS responsabilidad_43, p0_.detalles AS detalles_44, p0_.imagen_puntos AS imagen_puntos_45, p0_.imagen_firmeza AS imagen_firmeza_46, p0_.imagen_puntos_extendida AS imagen_puntos_extendida_47, p0_.gif_puntos AS gif_puntos_48, p0_.video AS video_49, p0_.nuevo AS nuevo_50, p0_.etiqueta AS etiqueta_51, p0_.alt AS alt_52, p0_.principal AS principal_53, p0_.slug AS slug_54, p0_.descripcion_seo AS descripcion_seo_55, p0_.tamanio AS tamanio_56, p0_.imgcalidad AS imgcalidad_57, p0_.imgresponsabilidad AS imgresponsabilidad_58, p0_.imgtecnologia AS imgtecnologia_59, p0_.incarrito AS incarrito_60, p0_.dctoic AS dctoic_61, p0_.titulo_seo AS titulo_seo_62, p0_.etiquetaprodtext AS etiquetaprodtext_63, p0_.etiquetaprodimg AS etiquetaprodimg_64, b1_.id AS id_65, b1_.nombre AS nombre_66, b1_.icono AS icono_67, b1_.resumen AS resumen_68, b1_.orden AS orden_69, b1_.visible AS visible_70, p2_.id AS id_71, p2_.x AS x_72, p2_.y AS y_73, p2_.numero AS numero_74, p2_.titulo AS titulo_75, p2_.resumen AS resumen_76, p2_.direccion AS direccion_77, p3_.id AS id_78, p3_.nombre AS nombre_79, p3_.resumen AS resumen_80, p3_.thumbnail AS thumbnail_81, p3_.imagen AS imagen_82, p3_.costo AS costo_83, p3_.precio AS precio_84, p3_.destacado AS destacado_85, p3_.orden AS orden_86, p3_.visible AS visible_87, p3_.updated_at AS updated_at_88, p3_.pum AS pum_89, p3_.iva AS iva_90, p3_.registro_invima AS registro_invima_91, p3_.precio_sin_descuento AS precio_sin_descuento_92, p3_.es_promo AS es_promo_93, p3_.destacado_categoria AS destacado_categoria_94, p3_.nombre_comercial AS nombre_comercial_95, p3_.referencia AS referencia_96, p3_.descuento AS descuento_97, p3_.ean AS ean_98, p3_.medida AS medida_99, p3_.precio_sin_inva AS precio_sin_inva_100, p3_.descripcion AS descripcion_101, p3_.tela AS tela_102, p3_.peso AS peso_103, p3_.productos_incluidos AS productos_incluidos_104, p3_.alternativa AS alternativa_105, p3_.productos_no_incluidos AS productos_no_incluidos_106, p3_.recomendaciones AS recomendaciones_107, p3_.garantia AS garantia_108, p3_.peso_a_soportar AS peso_a_soportar_109, p3_.color_texto AS color_texto_110, p3_.tecnologia AS tecnologia_111, p3_.tipologia AS tipologia_112, p3_.adaptabilidad AS adaptabilidad_113, p3_.independencia AS independencia_114, p3_.gamma AS gamma_115, p3_.maestro AS maestro_116, p3_.materiales AS materiales_117, p3_.ficha_tecnica AS ficha_tecnica_118, p3_.imagen_beneficios AS imagen_beneficios_119, p3_.calidad AS calidad_120, p3_.responsabilidad AS responsabilidad_121, p3_.detalles AS detalles_122, p3_.imagen_puntos AS imagen_puntos_123, p3_.imagen_firmeza AS imagen_firmeza_124, p3_.imagen_puntos_extendida AS imagen_puntos_extendida_125, p3_.gif_puntos AS gif_puntos_126, p3_.video AS video_127, p3_.nuevo AS nuevo_128, p3_.etiqueta AS etiqueta_129, p3_.alt AS alt_130, p3_.principal AS principal_131, p3_.slug AS slug_132, p3_.descripcion_seo AS descripcion_seo_133, p3_.tamanio AS tamanio_134, p3_.imgcalidad AS imgcalidad_135, p3_.imgresponsabilidad AS imgresponsabilidad_136, p3_.imgtecnologia AS imgtecnologia_137, p3_.incarrito AS incarrito_138, p3_.dctoic AS dctoic_139, p3_.titulo_seo AS titulo_seo_140, p3_.etiquetaprodtext AS etiquetaprodtext_141, p3_.etiquetaprodimg AS etiquetaprodimg_142 FROM producto p0_ LEFT JOIN producto_beneficio p4_ ON p0_.id = p4_.producto_id LEFT JOIN beneficio b1_ ON b1_.id = p4_.beneficio_id LEFT JOIN punto p2_ ON p0_.id = p2_.directo_id LEFT JOIN producto_producto p5_ ON p0_.id = p5_.producto_source LEFT JOIN producto p3_ ON p3_.id = p5_.producto_target WHERE p0_.maestro = 28;

SELECT
  i0_.id AS id_0,
  i0_.image AS image_1,
  i0_.orden AS orden_2,
  i0_.visible AS visible_3,
  i0_.updated_at AS updated_at_4,
  i0_.titulo AS titulo_5,
  i0_.descripcion AS descripcion_6,
  i0_.ver_mas AS ver_mas_7,
  i0_.llave AS llave_8,
  i0_.link AS link_9,
  i0_.alt AS alt_10,
  i0_.fechaini AS fechaini_11,
  i0_.fechafin AS fechafin_12
FROM
  image i0_
WHERE
  i0_.llave IS NOT NULL

SELECT i0_.id AS id_0, i0_.image AS image_1, i0_.orden AS orden_2, i0_.visible AS visible_3, i0_.updated_at AS updated_at_4, i0_.titulo AS titulo_5, i0_.descripcion AS descripcion_6, i0_.ver_mas AS ver_mas_7, i0_.llave AS llave_8, i0_.link AS link_9, i0_.alt AS alt_10, i0_.fechaini AS fechaini_11, i0_.fechafin AS fechafin_12 FROM image i0_ WHERE i0_.llave IS NOT NULL;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.value AS value_2,
  s0_.updated_at AS updated_at_3
FROM
  setting s0_
WHERE
  s0_.name IS NOT NULL

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.updated_at AS updated_at_3 FROM setting s0_ WHERE s0_.name IS NOT NULL;

SELECT
  t0_.id AS id_0,
  t0_.llave AS llave_1,
  t0_.valor_es AS valor_es_2,
  t0_.valor_en AS valor_en_3,
  t0_.valor_fr AS valor_fr_4,
  t0_.valor AS valor_5
FROM
  texto t0_
WHERE
  t0_.llave IS NOT NULL

SELECT t0_.id AS id_0, t0_.llave AS llave_1, t0_.valor_es AS valor_es_2, t0_.valor_en AS valor_en_3, t0_.valor_fr AS valor_fr_4, t0_.valor AS valor_5 FROM texto t0_ WHERE t0_.llave IS NOT NULL;

SELECT
  c0_.id AS id_0,
  c0_.nombre AS nombre_1,
  c0_.imagen AS imagen_2,
  c0_.imagen_desplegable AS imagen_desplegable_3,
  c0_.slug AS slug_4,
  c0_.desplegable AS desplegable_5,
  c0_.orden AS orden_6
FROM
  categoria c0_
  LEFT JOIN producto_categoria p2_ ON c0_.id = p2_.categoria_id
  LEFT JOIN producto p1_ ON p1_.id = p2_.producto_id
WHERE
  c0_.visible = 1
GROUP BY
  c0_.id,
  c0_.nombre,
  c0_.resumen,
  c0_.imagen,
  c0_.orden,
  c0_.visible,
  c0_.home,
  c0_.referencia,
  c0_.imagen_desplegable,
  c0_.product_destac,
  c0_.desplegable,
  c0_.slug,
  c0_.img_banner,
  c0_.img_banner_mobile,
  c0_.segmento_id
ORDER BY
  c0_.orden ASC

SELECT c0_.id AS id_0, c0_.nombre AS nombre_1, c0_.imagen AS imagen_2, c0_.imagen_desplegable AS imagen_desplegable_3, c0_.slug AS slug_4, c0_.desplegable AS desplegable_5, c0_.orden AS orden_6 FROM categoria c0_ LEFT JOIN producto_categoria p2_ ON c0_.id = p2_.categoria_id LEFT JOIN producto p1_ ON p1_.id = p2_.producto_id WHERE c0_.visible = 1 GROUP BY c0_.id, c0_.nombre, c0_.resumen, c0_.imagen, c0_.orden, c0_.visible, c0_.home, c0_.referencia, c0_.imagen_desplegable, c0_.product_destac, c0_.desplegable, c0_.slug, c0_.img_banner, c0_.img_banner_mobile, c0_.segmento_id ORDER BY c0_.orden ASC;

SELECT
  s0_.id AS id_0,
  s0_.nombre AS nombre_1,
  s0_.referencia AS referencia_2,
  s0_.icono_blanco AS icono_blanco_3,
  s0_.icono AS icono_4,
  s0_.slug AS slug_5,
  c1_.nombre AS nombre_6,
  s0_.descripcion AS descripcion_7,
  s0_.imagen AS imagen_8,
  s0_.avatar AS avatar_9,
  v2_.idyoutube AS idyoutube_10
FROM
  producto p3_
  LEFT JOIN subcategoria s0_ ON p3_.subcategoria_id = s0_.id
  LEFT JOIN video v2_ ON s0_.id = v2_.subcategoria_id
  LEFT JOIN categoria c1_ ON s0_.categoria_id = c1_.id
WHERE
  c1_.id = ?
  AND s0_.visible = 1
GROUP BY
  s0_.id
ORDER BY
  s0_.orden ASC

SELECT s0_.id AS id_0, s0_.nombre AS nombre_1, s0_.referencia AS referencia_2, s0_.icono_blanco AS icono_blanco_3, s0_.icono AS icono_4, s0_.slug AS slug_5, c1_.nombre AS nombre_6, s0_.descripcion AS descripcion_7, s0_.imagen AS imagen_8, s0_.avatar AS avatar_9, v2_.idyoutube AS idyoutube_10 FROM producto p3_ LEFT JOIN subcategoria s0_ ON p3_.subcategoria_id = s0_.id LEFT JOIN video v2_ ON s0_.id = v2_.subcategoria_id LEFT JOIN categoria c1_ ON s0_.categoria_id = c1_.id WHERE c1_.id = 1 AND s0_.visible = 1 GROUP BY s0_.id ORDER BY s0_.orden ASC;