Symfony Profiler

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 galeria g1_ ON i0_.galeria_id = g1_.id
WHERE
  g1_.llave = ?
  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 galeria g1_ ON i0_.galeria_id = g1_.id WHERE g1_.llave = 'home-banner' AND i0_.visible = 1 ORDER BY i0_.orden ASC;

SELECT
  t0.id AS id_1,
  t0.titulo AS titulo_2,
  t0.resumen AS resumen_3,
  t0.imagen_grande AS imagen_grande_4,
  t0.imagen_listado AS imagen_listado_5,
  t0.imagen_home AS imagen_home_6,
  t0.destacado AS destacado_7,
  t0.fecha AS fecha_8,
  t0.visible AS visible_9,
  t0.contenido AS contenido_10,
  t0.created_at AS created_at_11,
  t0.categoria_id AS categoria_id_12
FROM
  blog t0
WHERE
  t0.visible = ?
  AND t0.destacado = ?
ORDER BY
  t0.created_at DESC

SELECT t0.id AS id_1, t0.titulo AS titulo_2, t0.resumen AS resumen_3, t0.imagen_grande AS imagen_grande_4, t0.imagen_listado AS imagen_listado_5, t0.imagen_home AS imagen_home_6, t0.destacado AS destacado_7, t0.fecha AS fecha_8, t0.visible AS visible_9, t0.contenido AS contenido_10, t0.created_at AS created_at_11, t0.categoria_id AS categoria_id_12 FROM blog t0 WHERE t0.visible = 1 AND t0.destacado = 1 ORDER BY t0.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.direccion AS direccion_3,
  t0.telefono AS telefono_4,
  t0.orden AS orden_5,
  t0.horarios_text AS horarios_text_6,
  t0.domicilios AS domicilios_7,
  t0.lat AS lat_8,
  t0.lng AS lng_9,
  t0.visible AS visible_10,
  t0.kml_id AS kml_id_11,
  t0.updated_at AS updated_at_12,
  t0.store_id_mu AS store_id_mu_13,
  t0.email AS email_14,
  t0.imagen AS imagen_15,
  t0.productosfull AS productosfull_16,
  t0.radio_cobertura AS radio_cobertura_17,
  t0.costo_domicilio AS costo_domicilio_18,
  t0.pedido_minimo AS pedido_minimo_19,
  t0.whatsapp AS whatsapp_20,
  t0.ciudad_id AS ciudad_id_21
FROM
  tienda t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.direccion AS direccion_3, t0.telefono AS telefono_4, t0.orden AS orden_5, t0.horarios_text AS horarios_text_6, t0.domicilios AS domicilios_7, t0.lat AS lat_8, t0.lng AS lng_9, t0.visible AS visible_10, t0.kml_id AS kml_id_11, t0.updated_at AS updated_at_12, t0.store_id_mu AS store_id_mu_13, t0.email AS email_14, t0.imagen AS imagen_15, t0.productosfull AS productosfull_16, t0.radio_cobertura AS radio_cobertura_17, t0.costo_domicilio AS costo_domicilio_18, t0.pedido_minimo AS pedido_minimo_19, t0.whatsapp AS whatsapp_20, t0.ciudad_id AS ciudad_id_21 FROM tienda t0 WHERE t0.id = 'BOGML138' LIMIT 1;

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 = '90078113';

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.visible = ?
  AND t0.destacado = ?
  AND t0.principal = ?
ORDER BY
  t0.orden ASC
LIMIT
  4

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.visible = 1 AND t0.destacado = 1 AND t0.principal = 1 ORDER BY t0.orden ASC LIMIT 4;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2
FROM
  categoria_blog t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2 FROM categoria_blog t0 WHERE t0.id = 2;

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;

SELECT
  c0_.id AS id_0,
  c0_.nombre AS nombre_1,
  c0_.orden AS orden_2,
  c0_.clasificacion_id AS clasificacion_id_3,
  c0_.categoria_id AS categoria_id_4
FROM
  clasifconcateg c0_
  LEFT JOIN categoria c1_ ON c0_.categoria_id = c1_.id
WHERE
  c1_.id = ?
GROUP BY
  c0_.id
ORDER BY
  c0_.orden ASC

SELECT c0_.id AS id_0, c0_.nombre AS nombre_1, c0_.orden AS orden_2, c0_.clasificacion_id AS clasificacion_id_3, c0_.categoria_id AS categoria_id_4 FROM clasifconcateg c0_ LEFT JOIN categoria c1_ ON c0_.categoria_id = c1_.id WHERE c1_.id = 1 GROUP BY c0_.id ORDER BY c0_.orden ASC;

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 = '90075349' 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.visible = ?
  AND t0.home = ?
ORDER BY
  t0.orden ASC

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.visible = 1 AND t0.home = 1 ORDER BY t0.orden ASC;

SELECT
  s0_.id AS id_0,
  s0_.url AS url_1,
  s0_.titulo AS titulo_2,
  s0_.descripcion AS descripcion_3,
  s0_.imagen AS imagen_4,
  s0_.producto_id AS producto_id_5
FROM
  seo s0_
WHERE
  s0_.url = ?
ORDER BY
  s0_.id DESC
LIMIT
  1

SELECT s0_.id AS id_0, s0_.url AS url_1, s0_.titulo AS titulo_2, s0_.descripcion AS descripcion_3, s0_.imagen AS imagen_4, s0_.producto_id AS producto_id_5 FROM seo s0_ WHERE s0_.url = '/' ORDER BY s0_.id DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.x AS x_2,
  t0.y AS y_3,
  t0.numero AS numero_4,
  t0.titulo AS titulo_5,
  t0.resumen AS resumen_6,
  t0.direccion AS direccion_7,
  t0.imagen_id AS imagen_id_8,
  t0.producto_id AS producto_id_9,
  t0.directo_id AS directo_id_10
FROM
  punto t0
WHERE
  t0.imagen_id = ?

SELECT t0.id AS id_1, t0.x AS x_2, t0.y AS y_3, t0.numero AS numero_4, t0.titulo AS titulo_5, t0.resumen AS resumen_6, t0.direccion AS direccion_7, t0.imagen_id AS imagen_id_8, t0.producto_id AS producto_id_9, t0.directo_id AS directo_id_10 FROM punto t0 WHERE t0.imagen_id = 142;

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
  m0_.id AS id_0,
  m0_.nombre AS nombre_1,
  m0_.referencia AS referencia_2,
  m0_.icono AS icono_3
FROM
  medidas m0_
  LEFT JOIN producto p1_ ON m0_.id = p1_.medidas_id
  LEFT JOIN categoria c2_ ON m0_.categoria_id = c2_.id
WHERE
  c2_.id = ?
  AND m0_.visible = 1
  AND p1_.visible = 1
GROUP BY
  m0_.id
ORDER BY
  m0_.orden ASC

SELECT m0_.id AS id_0, m0_.nombre AS nombre_1, m0_.referencia AS referencia_2, m0_.icono AS icono_3 FROM medidas m0_ LEFT JOIN producto p1_ ON m0_.id = p1_.medidas_id LEFT JOIN categoria c2_ ON m0_.categoria_id = c2_.id WHERE c2_.id = 1 AND m0_.visible = 1 AND p1_.visible = 1 GROUP BY m0_.id ORDER BY m0_.orden ASC;

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.home = ?
  AND t0.visible = ?
ORDER BY
  t0.orden ASC

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.home = 1 AND t0.visible = 1 ORDER BY t0.orden ASC;

SELECT
  m0_.id AS id_0,
  m0_.nombre AS nombre_1,
  m0_.referencia AS referencia_2,
  m0_.icono AS icono_3
FROM
  material m0_
  LEFT JOIN producto p1_ ON m0_.id = p1_.material_id
  LEFT JOIN categoria c2_ ON m0_.categoria_id = c2_.id
WHERE
  c2_.id = ?
  AND m0_.visible = 1
  AND p1_.visible = 1
GROUP BY
  m0_.id
ORDER BY
  m0_.orden ASC

SELECT m0_.id AS id_0, m0_.nombre AS nombre_1, m0_.referencia AS referencia_2, m0_.icono AS icono_3 FROM material m0_ LEFT JOIN producto p1_ ON m0_.id = p1_.material_id LEFT JOIN categoria c2_ ON m0_.categoria_id = c2_.id WHERE c2_.id = 1 AND m0_.visible = 1 AND p1_.visible = 1 GROUP BY m0_.id ORDER BY m0_.orden ASC;

SELECT
  DISTINCT p0_.maestro AS maestro_0,
  p0_.id AS id_1,
  p0_.nombre AS nombre_2,
  p0_.imagen AS imagen_3,
  p0_.resumen AS resumen_4,
  p0_.orden AS orden_5,
  p0_.descuento AS descuento_6,
  p0_.nuevo AS nuevo_7
FROM
  producto p0_
  LEFT JOIN subcategoria s1_ ON p0_.subcategoria_id = s1_.id
  LEFT JOIN categoria c2_ ON s1_.categoria_id = c2_.id
WHERE
  c2_.id = ?
  AND p0_.visible = 1
ORDER BY
  p0_.orden ASC
LIMIT
  5

SELECT DISTINCT p0_.maestro AS maestro_0, p0_.id AS id_1, p0_.nombre AS nombre_2, p0_.imagen AS imagen_3, p0_.resumen AS resumen_4, p0_.orden AS orden_5, p0_.descuento AS descuento_6, p0_.nuevo AS nuevo_7 FROM producto p0_ LEFT JOIN subcategoria s1_ ON p0_.subcategoria_id = s1_.id LEFT JOIN categoria c2_ ON s1_.categoria_id = c2_.id WHERE c2_.id = 1 AND p0_.visible = 1 ORDER BY p0_.orden ASC LIMIT 5;

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
  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
  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_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;