Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.judul AS judul_2,
  t0.tipe AS tipe_3,
  t0.axis_x AS axis_x_4,
  t0.axis_y AS axis_y_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.is_show AS is_show_8,
  t0.axis_y_ids AS axis_y_ids_9,
  t0.pub_id AS pub_id_10
FROM
  t_grafik t0
WHERE
  t0.pub_id = ?

SELECT t0.id AS id_1, t0.judul AS judul_2, t0.tipe AS tipe_3, t0.axis_x AS axis_x_4, t0.axis_y AS axis_y_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.is_show AS is_show_8, t0.axis_y_ids AS axis_y_ids_9, t0.pub_id AS pub_id_10 FROM t_grafik t0 WHERE t0.pub_id = 3837;

SELECT
  t0_.id AS id_0,
  t0_.judul AS judul_1,
  t0_.sumber AS sumber_2,
  t0_.satuan AS satuan_3,
  t0_.tahun AS tahun_4,
  t0_.deskripsi AS deskripsi_5,
  t0_.kode AS kode_6,
  t0_.dimensi AS dimensi_7,
  t0_.keyword AS keyword_8,
  t0_.konsep AS konsep_9,
  t0_.rumus AS rumus_10,
  t0_.kegunaan AS kegunaan_11,
  t0_.intepretasi AS intepretasi_12,
  t0_.metodologi AS metodologi_13,
  t0_.created_at AS created_at_14,
  t0_.updated_at AS updated_at_15,
  t0_.view AS view_16,
  t0_.reff_id AS reff_id_17,
  t0_.tipe AS tipe_18,
  t0_.jenis AS jenis_19,
  t0_.jumlah_download AS jumlah_download_20,
  t0_.periode_id AS periode_id_21,
  t0_.status_id AS status_id_22,
  t0_.wilayah_id AS wilayah_id_23,
  t0_.div_id AS div_id_24,
  t0_.urusan_id AS urusan_id_25,
  t0_.sektor_id AS sektor_id_26
FROM
  t_publikasi t0_
WHERE
  t0_.status_id = 3

SELECT t0_.id AS id_0, t0_.judul AS judul_1, t0_.sumber AS sumber_2, t0_.satuan AS satuan_3, t0_.tahun AS tahun_4, t0_.deskripsi AS deskripsi_5, t0_.kode AS kode_6, t0_.dimensi AS dimensi_7, t0_.keyword AS keyword_8, t0_.konsep AS konsep_9, t0_.rumus AS rumus_10, t0_.kegunaan AS kegunaan_11, t0_.intepretasi AS intepretasi_12, t0_.metodologi AS metodologi_13, t0_.created_at AS created_at_14, t0_.updated_at AS updated_at_15, t0_.view AS view_16, t0_.reff_id AS reff_id_17, t0_.tipe AS tipe_18, t0_.jenis AS jenis_19, t0_.jumlah_download AS jumlah_download_20, t0_.periode_id AS periode_id_21, t0_.status_id AS status_id_22, t0_.wilayah_id AS wilayah_id_23, t0_.div_id AS div_id_24, t0_.urusan_id AS urusan_id_25, t0_.sektor_id AS sektor_id_26 FROM t_publikasi t0_ WHERE t0_.status_id = 3;

SELECT
  t0.id AS id_1,
  t0.reff_id AS reff_id_2,
  t0.reff_name AS reff_name_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.kategori_id AS kategori_id_6
FROM
  m_kategori_detail t0
WHERE
  t0.reff_id = ?
  AND t0.reff_name = ?
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.reff_id AS reff_id_2, t0.reff_name AS reff_name_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.kategori_id AS kategori_id_6 FROM m_kategori_detail t0 WHERE t0.reff_id = 4216 AND t0.reff_name = 'PUBLIKASI' ORDER BY t0.id ASC LIMIT 1;

SELECT
  DISTINCT t0_.id AS id_0
FROM
  t_div t0_
  LEFT JOIN t_publikasi t1_ ON t0_.id = t1_.div_id
WHERE
  t1_.status_id = 3

SELECT DISTINCT t0_.id AS id_0 FROM t_div t0_ LEFT JOIN t_publikasi t1_ ON t0_.id = t1_.div_id WHERE t1_.status_id = 3;

SELECT
  id,
  judul,
  'INFOGRAFIK' : :text as tipe,
  created_at as tanggal,
  'detail_infografik' as link
FROM
  t_infografik
WHERE
  is_arsip is false
UNION ALL
SELECT
  id,
  judul,
  'DATASET' : :text as tipe,
  updated_at as tanggal,
  'dataset_detail' as link
FROM
  t_publikasi
WHERE
  status_id = 3
ORDER BY
  tanggal DESC
LIMIT
  5

SELECT id, judul, 'INFOGRAFIK'::text as tipe, created_at as tanggal, 'detail_infografik' as link FROM t_infografik
                WHERE is_arsip is false
                UNION ALL
                SELECT id, judul, 'DATASET'::text as tipe, updated_at as tanggal, 'dataset_detail' as link FROM t_publikasi
                WHERE status_id = 3
                ORDER BY
                tanggal DESC
                LIMIT 5
                ;

SELECT
  t0.id AS id_1,
  t0.judul AS judul_2,
  t0.deskripsi AS deskripsi_3,
  t0.view AS view_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.sumber AS sumber_7,
  t0.is_arsip AS is_arsip_8,
  t0.release_date AS release_date_9,
  t0.div_id AS div_id_10
FROM
  t_infografik t0

SELECT t0.id AS id_1, t0.judul AS judul_2, t0.deskripsi AS deskripsi_3, t0.view AS view_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.sumber AS sumber_7, t0.is_arsip AS is_arsip_8, t0.release_date AS release_date_9, t0.div_id AS div_id_10 FROM t_infografik t0;

SELECT
  t0.id AS id_1,
  t0.kode AS kode_2,
  t0.nama AS nama_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.icon AS icon_6,
  t0.urusan_id AS urusan_id_7
FROM
  m_sektor t0

SELECT t0.id AS id_1, t0.kode AS kode_2, t0.nama AS nama_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.icon AS icon_6, t0.urusan_id AS urusan_id_7 FROM m_sektor t0;

SELECT
  t0.id AS id_1,
  t0.nama AS nama_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.icon AS icon_5
FROM
  m_kategori t0
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.nama AS nama_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.icon AS icon_5 FROM m_kategori t0 ORDER BY t0.id ASC;