Symfony Profiler

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

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

SELECT
  a.attnum,
  quote_ident(a.attname) AS field,
  t.typname AS type,
  format_type(a.atttypid, a.atttypmod) AS complete_type,
  (
    SELECT
      tc.collcollate
    FROM
      pg_catalog.pg_collation tc
    WHERE
      tc.oid = a.attcollation
  ) AS collation,
  (
    SELECT
      t1.typname
    FROM
      pg_catalog.pg_type t1
    WHERE
      t1.oid = t.typbasetype
  ) AS domain_type,
  (
    SELECT
      format_type(t2.typbasetype, t2.typtypmod)
    FROM
      pg_catalog.pg_type t2
    WHERE
      t2.typtype = 'd'
      AND t2.oid = a.atttypid
  ) AS domain_complete_type,
  a.attnotnull AS isnotnull,
  (
    SELECT
      't'
    FROM
      pg_index
    WHERE
      c.oid = pg_index.indrelid
      AND pg_index.indkey[0] = a.attnum
      AND pg_index.indisprimary = 't'
  ) AS pri,
  (
    SELECT
      pg_get_expr(adbin, adrelid)
    FROM
      pg_attrdef
    WHERE
      c.oid = pg_attrdef.adrelid
      AND pg_attrdef.adnum = a.attnum
  ) AS default,
  (
    SELECT
      pg_description.description
    FROM
      pg_description
    WHERE
      pg_description.objoid = c.oid
      AND a.attnum = pg_description.objsubid
  ) AS comment
FROM
  pg_attribute a,
  pg_class c,
  pg_type t,
  pg_namespace n
WHERE
  a.attnum > 0
  AND a.attrelid = c.oid
  AND a.atttypid = t.oid
  AND n.oid = c.relnamespace
  AND c.relkind = 'r'
  AND c.relname = 'doctrine_migration_versions'
  AND n.nspname = ANY(
    current_schemas(false)
  )
  AND n.nspname NOT IN (
    'pg_catalog', 'information_schema',
    'pg_toast'
  )
ORDER BY
  a.attnum

SELECT            a.attnum,
            quote_ident(a.attname) AS field,
            t.typname AS type,
            format_type(a.atttypid, a.atttypmod) AS complete_type,
            (SELECT tc.collcollate FROM pg_catalog.pg_collation tc WHERE tc.oid = a.attcollation) AS collation,
            (SELECT t1.typname FROM pg_catalog.pg_type t1 WHERE t1.oid = t.typbasetype) AS domain_type,
            (SELECT format_type(t2.typbasetype, t2.typtypmod) FROM
              pg_catalog.pg_type t2 WHERE t2.typtype = 'd' AND t2.oid = a.atttypid) AS domain_complete_type,
            a.attnotnull AS isnotnull,
            (SELECT 't'
             FROM pg_index
             WHERE c.oid = pg_index.indrelid
                AND pg_index.indkey[0] = a.attnum
                AND pg_index.indisprimary = 't'
            ) AS pri,
            (SELECT pg_get_expr(adbin, adrelid)
             FROM pg_attrdef
             WHERE c.oid = pg_attrdef.adrelid
                AND pg_attrdef.adnum=a.attnum
            ) AS default,
            (SELECT pg_description.description
                FROM pg_description WHERE pg_description.objoid = c.oid AND a.attnum = pg_description.objsubid
            ) AS comment
            FROM pg_attribute a, pg_class c, pg_type t, pg_namespace n WHERE a.attnum > 0 AND a.attrelid = c.oid AND a.atttypid = t.oid AND n.oid = c.relnamespace AND c.relkind = 'r' AND c.relname = 'doctrine_migration_versions' AND n.nspname = ANY(current_schemas(false)) AND n.nspname NOT IN ('pg_catalog', 'information_schema', 'pg_toast') ORDER BY a.attnum;

SELECT
  CURRENT_DATABASE()

SELECT CURRENT_DATABASE();

SELECT
  f0_.id AS id_0,
  f0_.frequency AS frequency_1,
  f0_.sd_stream AS sd_stream_2,
  f0_.hd_stream AS hd_stream_3,
  r1_.id AS id_4,
  r1_.title AS title_5,
  r1_.is_global AS is_global_6,
  r1_.is_main AS is_main_7,
  r1_.sort AS sort_8,
  f0_.region_id AS region_id_9,
  f0_.radio_id AS radio_id_10
FROM
  frequency f0_
  INNER JOIN region r1_ ON f0_.region_id = r1_.id
WHERE
  f0_.id = ?

SELECT f0_.id AS id_0, f0_.frequency AS frequency_1, f0_.sd_stream AS sd_stream_2, f0_.hd_stream AS hd_stream_3, r1_.id AS id_4, r1_.title AS title_5, r1_.is_global AS is_global_6, r1_.is_main AS is_main_7, r1_.sort AS sort_8, f0_.region_id AS region_id_9, f0_.radio_id AS radio_id_10 FROM frequency f0_ INNER JOIN region r1_ ON f0_.region_id = r1_.id WHERE f0_.id = 255;

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '3' AND e0_.locale = 'ru' AND e0_.object_class = 'App\\Entity\\Region';

SELECT
  quote_ident(relname) AS relname,
  pg_index.indisunique,
  pg_index.indisprimary,
  pg_index.indkey,
  pg_index.indrelid,
  pg_get_expr(indpred, indrelid) AS
where
FROM
  pg_class,
  pg_index
WHERE
  oid IN (
    SELECT
      indexrelid
    FROM
      pg_index i,
      pg_class c,
      pg_namespace n
    WHERE
      c.oid = i.indrelid
      AND c.relnamespace = n.oid
      AND c.relname = 'doctrine_migration_versions'
      AND n.nspname = ANY(
        current_schemas(false)
      )
      AND n.nspname NOT IN (
        'pg_catalog', 'information_schema',
        'pg_toast'
      )
  )
  AND pg_index.indexrelid = oid

SELECT                   quote_ident(relname) AS relname,
                   pg_index.indisunique,
                   pg_index.indisprimary,
                   pg_index.indkey,
                   pg_index.indrelid,
                   pg_get_expr(indpred, indrelid) AS where
              FROM pg_class, pg_index
             WHERE oid IN (
                SELECT indexrelid
                FROM pg_index i, pg_class c, pg_namespace n WHERE c.oid = i.indrelid AND c.relnamespace = n.oid AND c.relname = 'doctrine_migration_versions' AND n.nspname = ANY(current_schemas(false)) AND n.nspname NOT IN ('pg_catalog', 'information_schema', 'pg_toast')) AND pg_index.indexrelid = oid;

SELECT
  c.relname,
  obj_description(c.oid, 'pg_class') AS comment
FROM
  pg_class c
  INNER JOIN pg_namespace n ON n.oid = c.relnamespace
WHERE
  c.relkind = 'r'
  AND c.relname = 'doctrine_migration_versions'
  AND n.nspname = ANY(
    current_schemas(false)
  )
  AND n.nspname NOT IN (
    'pg_catalog', 'information_schema',
    'pg_toast'
  )

SELECT c.relname,
       obj_description(c.oid, 'pg_class') AS comment
FROM pg_class c
     INNER JOIN pg_namespace n
         ON n.oid = c.relnamespace WHERE c.relkind = 'r' AND c.relname = 'doctrine_migration_versions' AND n.nspname = ANY(current_schemas(false)) AND n.nspname NOT IN ('pg_catalog', 'information_schema', 'pg_toast');

SELECT
  quote_ident(r.conname) as conname,
  pg_catalog.pg_get_constraintdef(r.oid, true) as condef
FROM
  pg_catalog.pg_constraint r
WHERE
  r.conrelid IN (
    SELECT
      c.oid
    FROM
      pg_catalog.pg_class c,
      pg_catalog.pg_namespace n
    WHERE
      n.oid = c.relnamespace
      AND c.relname = 'doctrine_migration_versions'
      AND n.nspname = ANY(
        current_schemas(false)
      )
      AND n.nspname NOT IN (
        'pg_catalog', 'information_schema',
        'pg_toast'
      )
  )
  AND r.contype = 'f'

SELECT                  quote_ident(r.conname) as conname, pg_catalog.pg_get_constraintdef(r.oid, true) as condef
                  FROM pg_catalog.pg_constraint r
                  WHERE r.conrelid IN
                  (
                      SELECT c.oid
                      FROM pg_catalog.pg_class c, pg_catalog.pg_namespace n WHERE n.oid = c.relnamespace AND c.relname = 'doctrine_migration_versions' AND n.nspname = ANY(current_schemas(false)) AND n.nspname NOT IN ('pg_catalog', 'information_schema', 'pg_toast')) AND r.contype = 'f';

SELECT
  schema_name
FROM
  information_schema.schemata
WHERE
  schema_name NOT LIKE 'pg\_%'
  AND schema_name != 'information_schema'

SELECT schema_name
FROM   information_schema.schemata
WHERE  schema_name NOT LIKE 'pg\_%'
AND    schema_name != 'information_schema';

SELECT
  attnum,
  attname
FROM
  pg_attribute
WHERE
  attrelid = 16413
  AND attnum IN (1)
ORDER BY
  attnum ASC

SELECT attnum, attname FROM pg_attribute WHERE attrelid=16413 AND attnum IN (1) ORDER BY attnum ASC;

SELECT
  *
FROM
  doctrine_migration_versions

SELECT * FROM doctrine_migration_versions;

SHOW search_path

SHOW search_path;