Symfony Profiler

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          v0_.id AS id_0,
          v0_.npwp AS npwp_1,
          v0_.no_pengukuhan_npwp AS no_pengukuhan_npwp_2,
          v0_.email AS email_3,
          v0_.nama_perusahaan AS nama_perusahaan_4,
          v0_.alamat_perusahaan AS alamat_perusahaan_5,
          v0_.kode_pos AS kode_pos_6,
          v0_.telepon AS telepon_7,
          v0_.fax AS fax_8,
          v0_.hp AS hp_9,
          v0_.website AS website_10,
          v0_.kantor_cabang AS kantor_cabang_11,
          v0_.deskripsi AS deskripsi_12,
          v0_.kode_pendaftaran AS kode_pendaftaran_13,
          v0_.status AS status_14,
          v0_.is_validate AS is_validate_15,
          v0_.is_black_list AS is_black_list_16
        FROM
          vendor v0_
        WHERE
          v0_.is_black_list = ?
      ) dctrn_result_inner
    ORDER BY
      id_0 DESC
  ) dctrn_result
LIMIT
  10

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT v0_.id AS id_0, v0_.npwp AS npwp_1, v0_.no_pengukuhan_npwp AS no_pengukuhan_npwp_2, v0_.email AS email_3, v0_.nama_perusahaan AS nama_perusahaan_4, v0_.alamat_perusahaan AS alamat_perusahaan_5, v0_.kode_pos AS kode_pos_6, v0_.telepon AS telepon_7, v0_.fax AS fax_8, v0_.hp AS hp_9, v0_.website AS website_10, v0_.kantor_cabang AS kantor_cabang_11, v0_.deskripsi AS deskripsi_12, v0_.kode_pendaftaran AS kode_pendaftaran_13, v0_.status AS status_14, v0_.is_validate AS is_validate_15, v0_.is_black_list AS is_black_list_16 FROM vendor v0_ WHERE v0_.is_black_list = 1) dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 10;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          v0_.id AS id_0,
          v0_.npwp AS npwp_1,
          v0_.no_pengukuhan_npwp AS no_pengukuhan_npwp_2,
          v0_.email AS email_3,
          v0_.nama_perusahaan AS nama_perusahaan_4,
          v0_.alamat_perusahaan AS alamat_perusahaan_5,
          v0_.kode_pos AS kode_pos_6,
          v0_.telepon AS telepon_7,
          v0_.fax AS fax_8,
          v0_.hp AS hp_9,
          v0_.website AS website_10,
          v0_.kantor_cabang AS kantor_cabang_11,
          v0_.deskripsi AS deskripsi_12,
          v0_.kode_pendaftaran AS kode_pendaftaran_13,
          v0_.status AS status_14,
          v0_.is_validate AS is_validate_15,
          v0_.is_black_list AS is_black_list_16
        FROM
          vendor v0_
        WHERE
          v0_.is_black_list = ?
        ORDER BY
          v0_.id DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT v0_.id AS id_0, v0_.npwp AS npwp_1, v0_.no_pengukuhan_npwp AS no_pengukuhan_npwp_2, v0_.email AS email_3, v0_.nama_perusahaan AS nama_perusahaan_4, v0_.alamat_perusahaan AS alamat_perusahaan_5, v0_.kode_pos AS kode_pos_6, v0_.telepon AS telepon_7, v0_.fax AS fax_8, v0_.hp AS hp_9, v0_.website AS website_10, v0_.kantor_cabang AS kantor_cabang_11, v0_.deskripsi AS deskripsi_12, v0_.kode_pendaftaran AS kode_pendaftaran_13, v0_.status AS status_14, v0_.is_validate AS is_validate_15, v0_.is_black_list AS is_black_list_16 FROM vendor v0_ WHERE v0_.is_black_list = 1 ORDER BY v0_.id DESC) dctrn_result) dctrn_table;