Symfony Profiler

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          s0_.id AS id_0,
          s0_.judul AS judul_1,
          s0_.deskripsi AS deskripsi_2,
          s0_.urutan AS urutan_3,
          s0_.aktif AS aktif_4
        FROM
          slide s0_
        WHERE
          s0_.id IS NOT NULL
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT s0_.id AS id_0, s0_.judul AS judul_1, s0_.deskripsi AS deskripsi_2, s0_.urutan AS urutan_3, s0_.aktif AS aktif_4 FROM slide s0_ WHERE s0_.id IS NOT NULL) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      s0_.id AS id_0,
      s0_.judul AS judul_1,
      s0_.deskripsi AS deskripsi_2,
      s0_.urutan AS urutan_3,
      s0_.aktif AS aktif_4
    FROM
      slide s0_
    WHERE
      s0_.id IS NOT NULL
  ) dctrn_result
LIMIT
  10

SELECT DISTINCT id_0 FROM (SELECT s0_.id AS id_0, s0_.judul AS judul_1, s0_.deskripsi AS deskripsi_2, s0_.urutan AS urutan_3, s0_.aktif AS aktif_4 FROM slide s0_ WHERE s0_.id IS NOT NULL) dctrn_result LIMIT 10;

SELECT
  s0_.id AS id_0,
  s0_.judul AS judul_1,
  s0_.deskripsi AS deskripsi_2,
  s0_.urutan AS urutan_3,
  s0_.aktif AS aktif_4
FROM
  slide s0_
WHERE
  s0_.id IS NOT NULL
  AND s0_.id IN (?, ?)

SELECT s0_.id AS id_0, s0_.judul AS judul_1, s0_.deskripsi AS deskripsi_2, s0_.urutan AS urutan_3, s0_.aktif AS aktif_4 FROM slide s0_ WHERE s0_.id IS NOT NULL AND s0_.id IN (2, 3);

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 = ?
  AND d0_.reff_name = ?
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 = 3 AND d0_.jenis = 'slide' AND d0_.reff_name = 'SLIDE' 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 = ?
  AND d0_.jenis = ?
  AND d0_.reff_name = ?
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 = 2 AND d0_.jenis = 'slide' AND d0_.reff_name = 'SLIDE' ORDER BY d0_.id ASC;