Symfony Profiler

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          b0_.id AS id_0,
          b0_.kode AS kode_1,
          b0_.edisi AS edisi_2,
          b0_.nama AS nama_3,
          b0_.tanggal AS tanggal_4,
          b0_.tag AS tag_5
        FROM
          bulletin b0_
        WHERE
          b0_.id IS NOT NULL
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT b0_.id AS id_0, b0_.kode AS kode_1, b0_.edisi AS edisi_2, b0_.nama AS nama_3, b0_.tanggal AS tanggal_4, b0_.tag AS tag_5 FROM bulletin b0_ WHERE b0_.id IS NOT NULL) dctrn_result) dctrn_table;

SELECT
  d0_.id AS id_0,
  d0_.jenis AS jenis_1,
  d0_.path AS path_2,
  d0_.nama_file AS nama_file_3,
  d0_.type AS type_4,
  d0_.state AS state_5,
  d0_.created_at AS created_at_6,
  d0_.created_by AS created_by_7,
  d0_.reff_id AS reff_id_8,
  d0_.reff_name AS reff_name_9
FROM
  dokumentasi d0_
WHERE
  d0_.reff_id = ?
  AND d0_.state = ?
  AND d0_.jenis = ?
ORDER BY
  d0_.id ASC

SELECT d0_.id AS id_0, d0_.jenis AS jenis_1, d0_.path AS path_2, d0_.nama_file AS nama_file_3, d0_.type AS type_4, d0_.state AS state_5, d0_.created_at AS created_at_6, d0_.created_by AS created_by_7, d0_.reff_id AS reff_id_8, d0_.reff_name AS reff_name_9 FROM dokumentasi d0_ WHERE d0_.reff_id = 73 AND d0_.state = 0 AND d0_.jenis = 'BULLETIN' ORDER BY d0_.id ASC;

SELECT
  a0_.id AS id_0,
  a0_.judul AS judul_1,
  a0_.isi AS isi_2,
  a0_.penulis AS penulis_3,
  a0_.tanggal AS tanggal_4,
  a0_.created_at AS created_at_5,
  a0_.bulletin_id AS bulletin_id_6
FROM
  artikel a0_
WHERE
  a0_.bulletin_id = ?
ORDER BY
  a0_.id ASC

SELECT a0_.id AS id_0, a0_.judul AS judul_1, a0_.isi AS isi_2, a0_.penulis AS penulis_3, a0_.tanggal AS tanggal_4, a0_.created_at AS created_at_5, a0_.bulletin_id AS bulletin_id_6 FROM artikel a0_ WHERE a0_.bulletin_id = 73 ORDER BY a0_.id ASC;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      b0_.id AS id_0,
      b0_.kode AS kode_1,
      b0_.edisi AS edisi_2,
      b0_.nama AS nama_3,
      b0_.tanggal AS tanggal_4,
      b0_.tag AS tag_5
    FROM
      bulletin b0_
    WHERE
      b0_.id IS NOT NULL
  ) dctrn_result
LIMIT
  1

SELECT DISTINCT id_0 FROM (SELECT b0_.id AS id_0, b0_.kode AS kode_1, b0_.edisi AS edisi_2, b0_.nama AS nama_3, b0_.tanggal AS tanggal_4, b0_.tag AS tag_5 FROM bulletin b0_ WHERE b0_.id IS NOT NULL) dctrn_result LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.bulletin_id AS bulletin_id_2,
  t0.cabang_id AS cabang_id_3
FROM
  bulletin_cabang t0
WHERE
  t0.bulletin_id = ?

SELECT t0.id AS id_1, t0.bulletin_id AS bulletin_id_2, t0.cabang_id AS cabang_id_3 FROM bulletin_cabang t0 WHERE t0.bulletin_id = 73;

SELECT
  b0_.id AS id_0,
  b0_.kode AS kode_1,
  b0_.edisi AS edisi_2,
  b0_.nama AS nama_3,
  b0_.tanggal AS tanggal_4,
  b0_.tag AS tag_5
FROM
  bulletin b0_
WHERE
  b0_.id IS NOT NULL
  AND b0_.id IN (?)

SELECT b0_.id AS id_0, b0_.kode AS kode_1, b0_.edisi AS edisi_2, b0_.nama AS nama_3, b0_.tanggal AS tanggal_4, b0_.tag AS tag_5 FROM bulletin b0_ WHERE b0_.id IS NOT NULL AND b0_.id IN (73);