Symfony Profiler

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 = 74 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 = 74 ORDER BY a0_.id ASC;

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.created_at AS created_at_3,
  t0.bulletin_id AS bulletin_id_4,
  t0.kmj_user_id AS kmj_user_id_5,
  t0.user_donasi_id AS user_donasi_id_6
FROM
  user_bulletin t0
WHERE
  t0.kmj_user_id = ?
  AND t0.bulletin_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.status AS status_2, t0.created_at AS created_at_3, t0.bulletin_id AS bulletin_id_4, t0.kmj_user_id AS kmj_user_id_5, t0.user_donasi_id AS user_donasi_id_6 FROM user_bulletin t0 WHERE t0.kmj_user_id = '1f09a9e2-9629-63ba-8db2-d3a1c9ed65a4' AND t0.bulletin_id = 74 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 = 74;

SELECT
  t0.id AS id_2,
  t0.username AS username_3,
  t0.name AS name_4,
  t0.password AS password_5,
  t0.roles AS roles_6,
  t0.is_active AS is_active_7,
  t0.type
FROM
  kmj_user t0
  LEFT JOIN kmj_default_user t1 ON t0.id = t1.id
WHERE
  t0.username = ?
LIMIT
  1

SELECT t0.id AS id_2, t0.username AS username_3, t0.name AS name_4, t0.password AS password_5, t0.roles AS roles_6, t0.is_active AS is_active_7, t0.type FROM kmj_user t0 LEFT JOIN kmj_default_user t1 ON t0.id = t1.id WHERE t0.username = 'chuludnuraini@gmail.com' LIMIT 1;

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
          AND LOWER(b0_.kode) LIKE '%%'
          AND LOWER(b0_.nama) LIKE '%%'
          AND LOWER(b0_.edisi) LIKE '%%'
      ) 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 AND LOWER(b0_.kode) LIKE '%%' AND LOWER(b0_.nama) LIKE '%%' AND LOWER(b0_.edisi) LIKE '%%') dctrn_result) dctrn_table;

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 LOWER(b0_.kode) LIKE '%%'
  AND LOWER(b0_.nama) LIKE '%%'
  AND LOWER(b0_.edisi) LIKE '%%'
  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 LOWER(b0_.kode) LIKE '%%' AND LOWER(b0_.nama) LIKE '%%' AND LOWER(b0_.edisi) LIKE '%%' AND b0_.id IN (75, 98, 91, 73, 103, 116, 99, 87, 74, 121, 117, 88, 82, 119, 113, 96, 80, 83, 90, 105, 120, 100, 107, 79, 86, 84, 85, 95, 78, 92, 81, 101, 93, 89, 77, 94, 115, 114, 102, 97, 112, 109, 108, 118, 76, 106, 104, 111, 110);

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
      AND LOWER(b0_.kode) LIKE '%%'
      AND LOWER(b0_.nama) LIKE '%%'
      AND LOWER(b0_.edisi) LIKE '%%'
  ) dctrn_result
LIMIT
  100

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 AND LOWER(b0_.kode) LIKE '%%' AND LOWER(b0_.nama) LIKE '%%' AND LOWER(b0_.edisi) LIKE '%%') dctrn_result LIMIT 100;

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_.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 = 12 AND d0_.jenis = 'document' ORDER BY d0_.id ASC;