Symfony Profiler

SELECT
  t0_.id AS id_0,
  t0_.nombre AS nombre_1,
  t0_.codigo AS codigo_2,
  t0_.descripcion AS descripcion_3,
  t0_.link AS link_4,
  t0_.path_interno AS path_interno_5,
  t0_.es_path_interno AS es_path_interno_6,
  t0_.tiene_ficha AS tiene_ficha_7,
  t0_.destacado AS destacado_8,
  t0_.posicion_destacado AS posicion_destacado_9,
  t0_.id_drupal AS id_drupal_10,
  t0_.url_tad AS url_tad_11,
  t0_.modalidad_online AS modalidad_online_12,
  t0_.modalidad_presencial AS modalidad_presencial_13,
  t0_.pago AS pago_14,
  t0_.activo AS activo_15,
  t0_.posicion AS posicion_16,
  t0_.created_at AS created_at_17,
  t0_.updated_at AS updated_at_18,
  t0_.deleted_at AS deleted_at_19,
  c1_.id AS id_20,
  c1_.nombre AS nombre_21,
  c1_.descripcion AS descripcion_22,
  c1_.icono AS icono_23,
  c1_.url AS url_24,
  c1_.etiqueta AS etiqueta_25,
  c1_.color AS color_26,
  c1_.activo AS activo_27,
  c1_.posicion AS posicion_28,
  c1_.created_at AS created_at_29,
  c1_.updated_at AS updated_at_30,
  c1_.deleted_at AS deleted_at_31,
  g2_.id AS id_32,
  g2_.nombre AS nombre_33,
  g2_.descripcion AS descripcion_34,
  g2_.activo AS activo_35,
  g2_.posicion AS posicion_36,
  g2_.created_at AS created_at_37,
  g2_.updated_at AS updated_at_38,
  g2_.deleted_at AS deleted_at_39,
  c1_.categoria_id AS categoria_id_40,
  c1_.tipo_categoria_id AS tipo_categoria_id_41,
  g2_.categoria_id AS categoria_id_42
FROM
  tramite t0_
  LEFT JOIN tramites_categorias t3_ ON t0_.id = t3_.tramite_id
  LEFT JOIN categoria c1_ ON c1_.id = t3_.categoria_id
  AND (c1_.deleted_at IS NULL)
  LEFT JOIN tramites_grupos t4_ ON t0_.id = t4_.tramite_id
  LEFT JOIN grupo g2_ ON g2_.id = t4_.grupo_id
  AND (g2_.deleted_at IS NULL)
WHERE
  (
    t0_.activo = 1
    AND t0_.deleted_at IS NULL
  )
  AND (t0_.deleted_at IS NULL)
ORDER BY
  t0_.id ASC

SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.codigo AS codigo_2, t0_.descripcion AS descripcion_3, t0_.link AS link_4, t0_.path_interno AS path_interno_5, t0_.es_path_interno AS es_path_interno_6, t0_.tiene_ficha AS tiene_ficha_7, t0_.destacado AS destacado_8, t0_.posicion_destacado AS posicion_destacado_9, t0_.id_drupal AS id_drupal_10, t0_.url_tad AS url_tad_11, t0_.modalidad_online AS modalidad_online_12, t0_.modalidad_presencial AS modalidad_presencial_13, t0_.pago AS pago_14, t0_.activo AS activo_15, t0_.posicion AS posicion_16, t0_.created_at AS created_at_17, t0_.updated_at AS updated_at_18, t0_.deleted_at AS deleted_at_19, c1_.id AS id_20, c1_.nombre AS nombre_21, c1_.descripcion AS descripcion_22, c1_.icono AS icono_23, c1_.url AS url_24, c1_.etiqueta AS etiqueta_25, c1_.color AS color_26, c1_.activo AS activo_27, c1_.posicion AS posicion_28, c1_.created_at AS created_at_29, c1_.updated_at AS updated_at_30, c1_.deleted_at AS deleted_at_31, g2_.id AS id_32, g2_.nombre AS nombre_33, g2_.descripcion AS descripcion_34, g2_.activo AS activo_35, g2_.posicion AS posicion_36, g2_.created_at AS created_at_37, g2_.updated_at AS updated_at_38, g2_.deleted_at AS deleted_at_39, c1_.categoria_id AS categoria_id_40, c1_.tipo_categoria_id AS tipo_categoria_id_41, g2_.categoria_id AS categoria_id_42 FROM tramite t0_ LEFT JOIN tramites_categorias t3_ ON t0_.id = t3_.tramite_id LEFT JOIN categoria c1_ ON c1_.id = t3_.categoria_id AND (c1_.deleted_at IS NULL) LEFT JOIN tramites_grupos t4_ ON t0_.id = t4_.tramite_id LEFT JOIN grupo g2_ ON g2_.id = t4_.grupo_id AND (g2_.deleted_at IS NULL) WHERE (t0_.activo = 1 AND t0_.deleted_at IS NULL) AND (t0_.deleted_at IS NULL) ORDER BY t0_.id ASC;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.categoria_id AS categoria_id_3,
  t4.id AS id_5,
  t4.nombre AS nombre_6,
  t4.descripcion AS descripcion_7,
  t4.icono AS icono_8,
  t4.url AS url_9,
  t4.etiqueta AS etiqueta_10,
  t4.color AS color_11,
  t4.activo AS activo_12,
  t4.posicion AS posicion_13,
  t4.created_at AS created_at_14,
  t4.updated_at AS updated_at_15,
  t4.deleted_at AS deleted_at_16,
  t4.categoria_id AS categoria_id_17,
  t4.tipo_categoria_id AS tipo_categoria_id_18
FROM
  tipo_destacado t0
  LEFT JOIN categoria t4 ON t0.categoria_id = t4.id
  AND (
    (t4.deleted_at IS NULL)
  )
WHERE
  t0.nombre = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.categoria_id AS categoria_id_3, t4.id AS id_5, t4.nombre AS nombre_6, t4.descripcion AS descripcion_7, t4.icono AS icono_8, t4.url AS url_9, t4.etiqueta AS etiqueta_10, t4.color AS color_11, t4.activo AS activo_12, t4.posicion AS posicion_13, t4.created_at AS created_at_14, t4.updated_at AS updated_at_15, t4.deleted_at AS deleted_at_16, t4.categoria_id AS categoria_id_17, t4.tipo_categoria_id AS tipo_categoria_id_18 FROM tipo_destacado t0 LEFT JOIN categoria t4 ON t0.categoria_id = t4.id AND ((t4.deleted_at IS NULL)) WHERE t0.nombre = 'home' LIMIT 1;

WITH
  RECURSIVE enlaces AS (
    SELECT
      id,
      categoria_id,
      id AS raiz
    FROM
      categoria
    WHERE
      activo = 1
    UNION ALL
    SELECT
      c.id,
      c.categoria_id,
      e.raiz
    FROM
      categoria AS c
      JOIN enlaces AS e ON c.categoria_id = e.id
    WHERE
      activo = 1
  )
SELECT
  id AS categoria,
  MIN(raiz) AS padre_principal
FROM
  enlaces
GROUP BY
  id

WITH RECURSIVE enlaces AS (
                            SELECT id, categoria_id, id AS raiz
                            FROM categoria
                            WHERE activo = 1
                            UNION ALL
                            SELECT c.id, c.categoria_id, e.raiz
                            FROM categoria AS c
                            JOIN enlaces AS e ON c.categoria_id = e.id
                            WHERE activo = 1
                        )
                        SELECT id AS categoria, MIN(raiz) AS padre_principal
                        FROM enlaces
                        GROUP BY id;

SELECT
  t.*,
  IFNULL(tt.icono, '') AS icono
FROM
  destacado d
  INNER JOIN tipo_destacado td ON d.tipo_destacado_id = td.id
  INNER JOIN tramite t ON d.tramite_id = t.id
  LEFT JOIN (
    SELECT
      t.id,
      MAX(
        IFNULL(c.icono, cc.icono)
      ) AS icono
    FROM
      tramite t
      LEFT JOIN tramites_grupos tg ON t.id = tg.tramite_id
      LEFT JOIN grupo g ON tg.grupo_id = g.id
      LEFT JOIN categoria c ON g.categoria_id = c.id
      LEFT JOIN tramites_categorias tc ON t.id = tc.tramite_id
      LEFT JOIN categoria cc ON tc.categoria_id = cc.id
    WHERE
      (c.id, cc.id) NOT IN (
        WITH
          RECURSIVE enlaces AS (
            SELECT
              id,
              categoria_id,
              id AS raiz
            FROM
              categoria
            WHERE
              activo = 1
            UNION ALL
            SELECT
              c.id,
              c.categoria_id,
              e.raiz
            FROM
              categoria AS c
              JOIN enlaces AS e ON c.categoria_id = e.id
            WHERE
              activo = 1
          )
        SELECT
          MIN(raiz) AS padre_principal,
          MIN(raiz) AS padre_principal
        FROM
          enlaces
        GROUP BY
          id
      )
      AND IFNULL(c.icono, cc.icono) <> 'NO_IMAGE_ICON'
      AND IFNULL(c.icono, cc.icono) NOT LIKE '%.svg%'
    GROUP BY
      t.id
  ) tt ON tt.id = t.id
WHERE
  td.nombre = 'home'
  AND t.activo = 1
ORDER BY
  d.posicion;

SELECT t.*, IFNULL(tt.icono, '') AS icono FROM destacado d
                INNER JOIN tipo_destacado td ON d.tipo_destacado_id = td.id
                INNER JOIN tramite t ON d.tramite_id = t.id
                LEFT JOIN (SELECT t.id,MAX(IFNULL(c.icono, cc.icono)) AS icono
                                FROM tramite t
                                LEFT JOIN tramites_grupos tg ON t.id = tg.tramite_id
                                LEFT JOIN grupo g ON tg.grupo_id = g.id
                                LEFT JOIN categoria c ON g.categoria_id = c.id
                                LEFT JOIN tramites_categorias tc ON t.id = tc.tramite_id
                                LEFT JOIN categoria cc ON tc.categoria_id = cc.id
                            WHERE (c.id, cc.id) NOT IN (WITH RECURSIVE enlaces AS (
                                                    SELECT id, categoria_id, id AS raiz
                                                    FROM   categoria
                                                    WHERE activo = 1
                                                    UNION ALL
                            
                                                    SELECT c.id, c.categoria_id, e.raiz
                                                    FROM   categoria  AS c
                                                    JOIN   enlaces    AS e ON c.categoria_id = e.id
                                                    WHERE activo = 1
                                                )
                                                SELECT MIN(raiz)          AS padre_principal,
                                                       MIN(raiz)          AS padre_principal
                                                FROM   enlaces
                                                GROUP  BY id)
                            AND IFNULL(c.icono, cc.icono) <> 'NO_IMAGE_ICON'
                            AND IFNULL(c.icono, cc.icono) NOT LIKE '%.svg%'
                              GROUP BY t.id) tt ON tt.id = t.id
                WHERE td.nombre = 'home'
                AND t.activo = 1
                ORDER BY d.posicion;;