Symfony Profiler

SELECT
  count(DISTINCT t0_.id) AS sclr_0
FROM
  t_infografik t0_
WHERE
  t0_.is_arsip = false
  AND LOWER(t0_.judul) LIKE LOWER('%%')

SELECT count(DISTINCT t0_.id) AS sclr_0 FROM t_infografik t0_ WHERE t0_.is_arsip = false AND LOWER(t0_.judul) LIKE LOWER('%%');

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('%%')
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('%%') 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_.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_.id IN (19, 33, 27, 22, 21, 24, 31, 29) ORDER BY t0_.release_date DESC;

SELECT
  t0_.id AS id_0,
  t0_.nama AS nama_1,
  t0_.path AS path_2,
  t0_.deskripsi AS deskripsi_3,
  t0_.reff_id AS reff_id_4,
  t0_.created_at AS created_at_5,
  t0_.updated_at AS updated_at_6,
  t0_.reff_name AS reff_name_7,
  t0_.file_type AS file_type_8
FROM
  t_dokumen t0_
WHERE
  t0_.reff_id = ?
  AND t0_.reff_name = ?
  AND t0_.file_type <> ?

SELECT t0_.id AS id_0, t0_.nama AS nama_1, t0_.path AS path_2, t0_.deskripsi AS deskripsi_3, t0_.reff_id AS reff_id_4, t0_.created_at AS created_at_5, t0_.updated_at AS updated_at_6, t0_.reff_name AS reff_name_7, t0_.file_type AS file_type_8 FROM t_dokumen t0_ WHERE t0_.reff_id = 19 AND t0_.reff_name = 'INFOGRAFIK' AND t0_.file_type <> 'pdf';

SELECT
  quote_ident(table_name) AS table_name,
  table_schema AS schema_name
FROM
  information_schema.tables
WHERE
  table_schema NOT LIKE 'pg\_%'
  AND table_schema != 'information_schema'
  AND table_name != 'geometry_columns'
  AND table_name != 'spatial_ref_sys'
  AND table_type != 'VIEW'

SELECT quote_ident(table_name) AS table_name,
                       table_schema AS schema_name
                FROM   information_schema.tables
                WHERE  table_schema NOT LIKE 'pg\_%'
                AND    table_schema != 'information_schema'
                AND    table_name != 'geometry_columns'
                AND    table_name != 'spatial_ref_sys'
                AND    table_type != 'VIEW';

SELECT
  nspname
FROM
  pg_namespace
WHERE
  nspname ! ~ '^pg_.*'
  AND nspname != 'information_schema'

SELECT nspname FROM pg_namespace WHERE nspname !~ '^pg_.*' AND nspname != 'information_schema';

SHOW search_path

SHOW search_path;