Symfony Profiler

SELECT
  *
from
  (
    select
      distinct on (x.tipe, x.id) b.nama as kategori,
      x.*
    from
      m_kategori_detail a
      join m_kategori b on a.kategori_id = b.id
      right join (
        select
          *
        from
          (
            -- select 'DATASET'::text as tipe, a.id as id, a.judul as judul, a.deskripsi as deskripsi, c.nama as urusan, d.nama as sektor, b.div_nama as div, a.updated_at as tanggal
            select
              'DATASET' : :text as tipe,
              a.id as id,
              a.judul as judul,
              a.deskripsi as deskripsi,
              b.div_nama as div,
              a.updated_at as tanggal
            from
              t_publikasi a
              join t_div b on a.div_id = b.id -- join m_urusan c
              -- on a.urusan_id = c.id
              -- join m_sektor d
              -- on a.sektor_id = d.id
            where
              a.status_id = 3
            UNION ALL
              -- select 'INFOGRAFIK'::text as tipe, a.id as id, a.judul as judul, a.deskripsi as deskripsi, ''::text as urusan, ''::text as sektor, a.sumber::text as div, a.created_at as tanggal
            select
              'INFOGRAFIK' : :text as tipe,
              a.id as id,
              a.judul as judul,
              a.deskripsi as deskripsi,
              a.sumber : :text as div,
              a.created_at as tanggal
            from
              t_infografik a
            where
              a.is_arsip = false
          ) as search
      ) as x on a.reff_id = x.id
      and a.reff_name = x.tipe
  ) as fix -- where judul ilike '%%' or tipe ilike '%%' or deskripsi ilike '%%' or urusan ilike '%%' or sektor ilike '%%' or div ilike '%%'
where
  judul ilike '%%'
  or tipe ilike '%%'
  or deskripsi ilike '%%'
  or div ilike '%%'
order by
  tanggal desc
limit
  5

SELECT * from
            (
                select distinct on (x.tipe, x.id) b.nama as kategori, x.*
                from m_kategori_detail a
                join m_kategori b
                on a.kategori_id = b.id
                right join
                (
                    select * from (
                        -- select 'DATASET'::text as tipe, a.id as id, a.judul as judul, a.deskripsi as deskripsi, c.nama as urusan, d.nama as sektor, b.div_nama as div, a.updated_at as tanggal
                        select 'DATASET'::text as tipe, a.id as id, a.judul as judul, a.deskripsi as deskripsi, b.div_nama as div, a.updated_at as tanggal
                        from t_publikasi a
                        join t_div b
                        on a.div_id = b.id
                        -- join m_urusan c
                        -- on a.urusan_id = c.id
                        -- join m_sektor d
                        -- on a.sektor_id = d.id
                        where a.status_id = 3

                        UNION ALL

                        -- select 'INFOGRAFIK'::text as tipe, a.id as id, a.judul as judul, a.deskripsi as deskripsi, ''::text as urusan, ''::text as sektor, a.sumber::text as div, a.created_at as tanggal
                        select 'INFOGRAFIK'::text as tipe, a.id as id, a.judul as judul, a.deskripsi as deskripsi, a.sumber::text as div, a.created_at as tanggal
                        from t_infografik a
                        where a.is_arsip = false
                    ) as search
                ) as x
                on a.reff_id = x.id and a.reff_name = x.tipe 
            ) as fix
            -- where judul ilike '%%' or tipe ilike '%%' or deskripsi ilike '%%' or urusan ilike '%%' or sektor ilike '%%' or div ilike '%%'
            where judul ilike '%%' or tipe ilike '%%' or deskripsi ilike '%%' or div ilike '%%'
            order by tanggal desc
            limit 5;