Symfony Profiler

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          c0_.id AS id_0,
          c0_.nama AS nama_1,
          c0_.alamat AS alamat_2,
          c0_.telepon AS telepon_3,
          c0_.icon AS icon_4,
          c0_.url_map AS url_map_5
        FROM
          cabang c0_
        WHERE
          c0_.id IS NOT NULL
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT c0_.id AS id_0, c0_.nama AS nama_1, c0_.alamat AS alamat_2, c0_.telepon AS telepon_3, c0_.icon AS icon_4, c0_.url_map AS url_map_5 FROM cabang c0_ WHERE c0_.id IS NOT NULL) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      c0_.id AS id_0,
      c0_.nama AS nama_1,
      c0_.alamat AS alamat_2,
      c0_.telepon AS telepon_3,
      c0_.icon AS icon_4,
      c0_.url_map AS url_map_5
    FROM
      cabang c0_
    WHERE
      c0_.id IS NOT NULL
  ) dctrn_result
LIMIT
  10

SELECT DISTINCT id_0 FROM (SELECT c0_.id AS id_0, c0_.nama AS nama_1, c0_.alamat AS alamat_2, c0_.telepon AS telepon_3, c0_.icon AS icon_4, c0_.url_map AS url_map_5 FROM cabang c0_ WHERE c0_.id IS NOT NULL) dctrn_result LIMIT 10;

SELECT
  c0_.id AS id_0,
  c0_.nama AS nama_1,
  c0_.alamat AS alamat_2,
  c0_.telepon AS telepon_3,
  c0_.icon AS icon_4,
  c0_.url_map AS url_map_5
FROM
  cabang c0_
WHERE
  c0_.id IS NOT NULL
  AND c0_.id IN (?, ?, ?, ?, ?)

SELECT c0_.id AS id_0, c0_.nama AS nama_1, c0_.alamat AS alamat_2, c0_.telepon AS telepon_3, c0_.icon AS icon_4, c0_.url_map AS url_map_5 FROM cabang c0_ WHERE c0_.id IS NOT NULL AND c0_.id IN (1, 3, 5, 4, 2);

SELECT
  t0.id AS id_1,
  t0.nama AS nama_2,
  t0.keterangan AS keterangan_3,
  t0.tipe AS tipe_4,
  t0.created_at AS created_at_5,
  t0.cabang_id AS cabang_id_6
FROM
  cabang_type t0
WHERE
  t0.cabang_id = ?

SELECT t0.id AS id_1, t0.nama AS nama_2, t0.keterangan AS keterangan_3, t0.tipe AS tipe_4, t0.created_at AS created_at_5, t0.cabang_id AS cabang_id_6 FROM cabang_type t0 WHERE t0.cabang_id = 2;

SELECT
  t0.id AS id_1,
  t0.nama AS nama_2,
  t0.keterangan AS keterangan_3,
  t0.tipe AS tipe_4,
  t0.created_at AS created_at_5,
  t0.cabang_id AS cabang_id_6
FROM
  cabang_type t0
WHERE
  t0.cabang_id = ?

SELECT t0.id AS id_1, t0.nama AS nama_2, t0.keterangan AS keterangan_3, t0.tipe AS tipe_4, t0.created_at AS created_at_5, t0.cabang_id AS cabang_id_6 FROM cabang_type t0 WHERE t0.cabang_id = 4;

SELECT
  t0.id AS id_1,
  t0.nama AS nama_2,
  t0.keterangan AS keterangan_3,
  t0.tipe AS tipe_4,
  t0.created_at AS created_at_5,
  t0.cabang_id AS cabang_id_6
FROM
  cabang_type t0
WHERE
  t0.cabang_id = ?

SELECT t0.id AS id_1, t0.nama AS nama_2, t0.keterangan AS keterangan_3, t0.tipe AS tipe_4, t0.created_at AS created_at_5, t0.cabang_id AS cabang_id_6 FROM cabang_type t0 WHERE t0.cabang_id = 5;

SELECT
  t0.id AS id_1,
  t0.nama AS nama_2,
  t0.keterangan AS keterangan_3,
  t0.tipe AS tipe_4,
  t0.created_at AS created_at_5,
  t0.cabang_id AS cabang_id_6
FROM
  cabang_type t0
WHERE
  t0.cabang_id = ?

SELECT t0.id AS id_1, t0.nama AS nama_2, t0.keterangan AS keterangan_3, t0.tipe AS tipe_4, t0.created_at AS created_at_5, t0.cabang_id AS cabang_id_6 FROM cabang_type t0 WHERE t0.cabang_id = 1;

SELECT
  t0.id AS id_1,
  t0.nama AS nama_2,
  t0.keterangan AS keterangan_3,
  t0.tipe AS tipe_4,
  t0.created_at AS created_at_5,
  t0.cabang_id AS cabang_id_6
FROM
  cabang_type t0
WHERE
  t0.cabang_id = ?

SELECT t0.id AS id_1, t0.nama AS nama_2, t0.keterangan AS keterangan_3, t0.tipe AS tipe_4, t0.created_at AS created_at_5, t0.cabang_id AS cabang_id_6 FROM cabang_type t0 WHERE t0.cabang_id = 3;