Symfony Profiler

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.id = ?

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.id = '7';

SELECT
  b0_.id AS id_0,
  b0_.titulo AS titulo_1,
  b0_.created_at AS created_at_2
FROM
  blog b0_
WHERE
  b0_.created_at <= ?
  AND b0_.id <> 7
ORDER BY
  b0_.created_at DESC
LIMIT
  1

SELECT b0_.id AS id_0, b0_.titulo AS titulo_1, b0_.created_at AS created_at_2 FROM blog b0_ WHERE b0_.created_at <= '2021-08-07 23:45:43' AND b0_.id <> 7 ORDER BY b0_.created_at DESC LIMIT 1;

SELECT
  b0_.id AS id_0,
  b0_.titulo AS titulo_1
FROM
  blog b0_
WHERE
  b0_.created_at >= ?
  AND b0_.id <> 7
ORDER BY
  b0_.created_at ASC
LIMIT
  1

SELECT b0_.id AS id_0, b0_.titulo AS titulo_1 FROM blog b0_ WHERE b0_.created_at >= '2021-08-07 23:45:43' AND b0_.id <> 7 ORDER BY b0_.created_at ASC LIMIT 1;

SELECT
  count(l0_.id) AS sclr_0
FROM
  `like` l0_
  LEFT JOIN blog b1_ ON l0_.blog_id = b1_.id
WHERE
  b1_.id = 7

SELECT count(l0_.id) AS sclr_0 FROM `like` l0_ LEFT JOIN blog b1_ ON l0_.blog_id = b1_.id WHERE b1_.id = 7;

SELECT
  c0_.id AS id_0,
  c0_.comentario AS comentario_1,
  c0_.created_at AS created_at_2,
  CONCAT(f1_.nombre, ' ', f1_.apellido) AS sclr_3
FROM
  comentario_blog c0_
  LEFT JOIN blog b2_ ON c0_.blog_id = b2_.id
  LEFT JOIN fos_user f1_ ON c0_.usuario_id = f1_.id
  LEFT JOIN posadmin p3_ ON f1_.id = p3_.id
WHERE
  b2_.id = 7

SELECT c0_.id AS id_0, c0_.comentario AS comentario_1, c0_.created_at AS created_at_2, CONCAT(f1_.nombre, ' ', f1_.apellido) AS sclr_3 FROM comentario_blog c0_ LEFT JOIN blog b2_ ON c0_.blog_id = b2_.id LEFT JOIN fos_user f1_ ON c0_.usuario_id = f1_.id LEFT JOIN posadmin p3_ ON f1_.id = p3_.id WHERE b2_.id = 7;

SELECT
  f0_.username AS username_0,
  f0_.username_canonical AS username_canonical_1,
  f0_.email AS email_2,
  f0_.email_canonical AS email_canonical_3,
  f0_.enabled AS enabled_4,
  f0_.salt AS salt_5,
  f0_.password AS password_6,
  f0_.last_login AS last_login_7,
  f0_.confirmation_token AS confirmation_token_8,
  f0_.password_requested_at AS password_requested_at_9,
  f0_.roles AS roles_10,
  f0_.id AS id_11,
  f0_.nombre AS nombre_12,
  f0_.apellido AS apellido_13,
  f0_.fecha_nacimiento AS fecha_nacimiento_14,
  f0_.celular AS celular_15,
  f0_.uid AS uid_16,
  f0_.provider_data AS provider_data_17,
  f0_.created_at AS created_at_18,
  f0_.documento AS documento_19,
  f0_.anonimo AS anonimo_20,
  f0_.contactoid_clientify AS contactoid_clientify_21,
  f0_.discr AS discr_22,
  f0_.convenio_id AS convenio_id_23,
  p1_.tienda_id AS tienda_id_24
FROM
  fos_user f0_
  LEFT JOIN posadmin p1_ ON f0_.id = p1_.id

SELECT f0_.username AS username_0, f0_.username_canonical AS username_canonical_1, f0_.email AS email_2, f0_.email_canonical AS email_canonical_3, f0_.enabled AS enabled_4, f0_.salt AS salt_5, f0_.password AS password_6, f0_.last_login AS last_login_7, f0_.confirmation_token AS confirmation_token_8, f0_.password_requested_at AS password_requested_at_9, f0_.roles AS roles_10, f0_.id AS id_11, f0_.nombre AS nombre_12, f0_.apellido AS apellido_13, f0_.fecha_nacimiento AS fecha_nacimiento_14, f0_.celular AS celular_15, f0_.uid AS uid_16, f0_.provider_data AS provider_data_17, f0_.created_at AS created_at_18, f0_.documento AS documento_19, f0_.anonimo AS anonimo_20, f0_.contactoid_clientify AS contactoid_clientify_21, f0_.discr AS discr_22, f0_.convenio_id AS convenio_id_23, p1_.tienda_id AS tienda_id_24 FROM fos_user f0_ LEFT JOIN posadmin p1_ ON f0_.id = p1_.id;

SELECT
  b0_.id AS id_0,
  b0_.titulo AS titulo_1,
  b0_.resumen AS resumen_2,
  b0_.imagen_grande AS imagen_grande_3,
  b0_.imagen_listado AS imagen_listado_4,
  b0_.imagen_home AS imagen_home_5,
  b0_.destacado AS destacado_6,
  b0_.fecha AS fecha_7,
  b0_.visible AS visible_8,
  b0_.contenido AS contenido_9,
  b0_.created_at AS created_at_10,
  b0_.categoria_id AS categoria_id_11
FROM
  blog b0_

SELECT b0_.id AS id_0, b0_.titulo AS titulo_1, b0_.resumen AS resumen_2, b0_.imagen_grande AS imagen_grande_3, b0_.imagen_listado AS imagen_listado_4, b0_.imagen_home AS imagen_home_5, b0_.destacado AS destacado_6, b0_.fecha AS fecha_7, b0_.visible AS visible_8, b0_.contenido AS contenido_9, b0_.created_at AS created_at_10, b0_.categoria_id AS categoria_id_11 FROM blog b0_;

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;

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
  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 = 2 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 = 2 GROUP BY c0_.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 = 3 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 = 3 GROUP BY c0_.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 = 4 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 = 4 GROUP BY c0_.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 = 6 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_.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
  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
  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
  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
  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.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 = 1;

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;