Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.title_id AS title_id_2,
  t0.title AS title_3,
  t0.notes AS notes_4,
  t0.metadata_created AS metadata_created_5,
  t0.metadata_modified AS metadata_modified_6,
  t0.organization_id AS organization_id_7,
  t0.organization_name AS organization_name_8,
  t0.private AS private_9,
  t0.state AS state_10,
  t0.type AS type_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.div_id_id AS div_id_id_14,
  t0.kota_id AS kota_id_15
FROM
  t_ckan t0
WHERE
  t0.div_id_id = ?

SELECT t0.id AS id_1, t0.title_id AS title_id_2, t0.title AS title_3, t0.notes AS notes_4, t0.metadata_created AS metadata_created_5, t0.metadata_modified AS metadata_modified_6, t0.organization_id AS organization_id_7, t0.organization_name AS organization_name_8, t0.private AS private_9, t0.state AS state_10, t0.type AS type_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.div_id_id AS div_id_id_14, t0.kota_id AS kota_id_15 FROM t_ckan t0 WHERE t0.div_id_id = 6;

SELECT
  count(DISTINCT t0_.id) AS sclr_0
FROM
  t_infografik t0_
WHERE
  t0_.is_arsip = false
  AND LOWER(t0_.judul) LIKE LOWER(?)
  AND t0_.release_date >= ?
  AND t0_.release_date < ?

SELECT count(DISTINCT t0_.id) AS sclr_0 FROM t_infografik t0_ WHERE t0_.is_arsip = false AND LOWER(t0_.judul) LIKE LOWER('%%') AND t0_.release_date >= '2023-01-01 00:00:00' AND t0_.release_date < '2024-01-01 00:00:00';

SELECT
  t0_.id AS id_0,
  t0_.div_nama AS div_nama_1,
  t0_.div_icon AS div_icon_2,
  t0_.kode AS kode_3,
  t0_.created_at AS created_at_4,
  t0_.updated_at AS updated_at_5,
  t0_.bidang_id AS bidang_id_6
FROM
  t_div t0_

SELECT t0_.id AS id_0, t0_.div_nama AS div_nama_1, t0_.div_icon AS div_icon_2, t0_.kode AS kode_3, t0_.created_at AS created_at_4, t0_.updated_at AS updated_at_5, t0_.bidang_id AS bidang_id_6 FROM t_div t0_;

SELECT
  DISTINCT t0_.id AS id_0,
  t0_.release_date AS release_date_1
FROM
  t_infografik t0_
WHERE
  t0_.is_arsip = false
  AND LOWER(t0_.judul) LIKE LOWER(?)
  AND t0_.release_date >= ?
  AND t0_.release_date < ?
ORDER BY
  t0_.release_date DESC
LIMIT
  10

SELECT DISTINCT t0_.id AS id_0, t0_.release_date AS release_date_1 FROM t_infografik t0_ WHERE t0_.is_arsip = false AND LOWER(t0_.judul) LIKE LOWER('%%') AND t0_.release_date >= '2023-01-01 00:00:00' AND t0_.release_date < '2024-01-01 00:00:00' ORDER BY t0_.release_date DESC LIMIT 10;

SELECT
  t0_.id AS id_0,
  t0_.judul AS judul_1,
  t0_.deskripsi AS deskripsi_2,
  t0_.view AS view_3,
  t0_.created_at AS created_at_4,
  t0_.updated_at AS updated_at_5,
  t0_.sumber AS sumber_6,
  t0_.is_arsip AS is_arsip_7,
  t0_.release_date AS release_date_8,
  t0_.div_id AS div_id_9
FROM
  t_infografik t0_
WHERE
  t0_.is_arsip = false
  AND LOWER(t0_.judul) LIKE LOWER(?)
  AND t0_.release_date >= ?
  AND t0_.release_date < ?
  AND t0_.id IN (?)
ORDER BY
  t0_.release_date DESC

SELECT t0_.id AS id_0, t0_.judul AS judul_1, t0_.deskripsi AS deskripsi_2, t0_.view AS view_3, t0_.created_at AS created_at_4, t0_.updated_at AS updated_at_5, t0_.sumber AS sumber_6, t0_.is_arsip AS is_arsip_7, t0_.release_date AS release_date_8, t0_.div_id AS div_id_9 FROM t_infografik t0_ WHERE t0_.is_arsip = false AND LOWER(t0_.judul) LIKE LOWER('%%') AND t0_.release_date >= '2023-01-01 00:00:00' AND t0_.release_date < '2024-01-01 00:00:00' AND t0_.id IN (33, 27, 22) ORDER BY t0_.release_date DESC;