Symfony Profiler

SELECT
  info.event AS category_event,
  info.url AS category_url,
  info.counter AS category_counter,
  product_category.id AS category_id,
  product_category_event.parent AS category_parent,
  product_category_trans.name AS category_name,
  product_category_landing.header AS category_header,
  product_category_landing.bottom AS category_bottom,
  parent_product_category_trans.name AS parent_category_name,
  parent_product_category_info.url AS parent_category_url,
  parent_product_category_info.counter AS parent_category_counter,
  JSON_AGG (
    DISTINCT JSONB_BUILD_OBJECT (
      '0',
      parent_category_event.sort,
      'parent_category_url',
      parent_category_info.url,
      'parent_category_counter',
      parent_category_info.counter,
      'parent_category_cover_name',
      CASE WHEN parent_category_cover.name IS NOT NULL THEN
        CONCAT (
          '/upload/product_category_cover',
          '/', parent_category_cover.name
        )
      ELSE
        NULL
      END,
      'parent_category_cover_ext',
      parent_category_cover.ext,
      'parent_category_cover_cdn',
      parent_category_cover.cdn,
      'parent_category_event',
      parent_category_event.id,
      'parent_category_name',
      parent_category_trans.name
    )
  ) AS parent_category,
  CASE WHEN category_cover.name IS NOT NULL THEN
    CONCAT (
      '/upload/product_category_cover',
      '/', category_cover.name
    )
  ELSE
    NULL
  END AS category_cover_path,
  category_cover.ext AS category_cover_ext,
  category_cover.cdn AS category_cover_cdn
FROM
  product_category_info info
  INNER JOIN product_category product_category ON product_category.event = info.event
  LEFT JOIN product_category_event product_category_event ON product_category_event.id = product_category.event
  LEFT JOIN product_category_trans product_category_trans ON product_category_trans.event = product_category_event.id
  AND product_category_trans.local = ?
  LEFT JOIN product_category_landing product_category_landing ON product_category_landing.event = product_category_event.id
  AND product_category_landing.local = ?
  LEFT JOIN product_category_event parent_category_event ON parent_category_event.parent = product_category.id
  LEFT JOIN product_category_cover category_cover ON category_cover.event = product_category.event
  LEFT JOIN product_category parent_product_category ON parent_product_category.id = product_category_event.parent
  LEFT JOIN product_category_trans parent_product_category_trans ON parent_product_category_trans.event = parent_product_category.event
  AND parent_product_category_trans.local = ?
  LEFT JOIN product_category_info parent_product_category_info ON parent_product_category_info.event = parent_product_category.event
  LEFT JOIN product_category_info parent_category_info ON parent_category_info.event = parent_category_event.id
  LEFT JOIN product_category_cover parent_category_cover ON parent_category_cover.event = parent_category_event.id
  LEFT JOIN product_category_trans parent_category_trans ON parent_category_trans.event = parent_category_event.id
  AND parent_category_trans.local = ?
WHERE
  (info.url = ?)
  AND (info.active = true)
GROUP BY
  info.event,
  info.url,
  info.counter,
  product_category.id,
  product_category_event.parent,
  product_category_trans.name,
  product_category_landing.header,
  product_category_landing.bottom,
  parent_product_category_trans.name,
  parent_product_category_info.url,
  parent_product_category_info.counter,
  category_cover.name,
  category_cover.ext,
  category_cover.cdn

SELECT info.event AS category_event, info.url AS category_url, info.counter AS category_counter, product_category.id AS category_id, product_category_event.parent AS category_parent, product_category_trans.name AS category_name, product_category_landing.header AS category_header, product_category_landing.bottom AS category_bottom, parent_product_category_trans.name AS parent_category_name, parent_product_category_info.url AS parent_category_url, parent_product_category_info.counter AS parent_category_counter, JSON_AGG
		( DISTINCT
			
				JSONB_BUILD_OBJECT
				(
					'0', parent_category_event.sort,
					
					'parent_category_url', parent_category_info.url,
					'parent_category_counter', parent_category_info.counter,
					
					'parent_category_cover_name', 
					CASE
					    WHEN parent_category_cover.name IS NOT NULL 
					    THEN CONCAT ( '/upload/product_category_cover' , '/', parent_category_cover.name)
					    ELSE NULL
                    END,
					
					'parent_category_cover_ext', parent_category_cover.ext,
					'parent_category_cover_cdn', parent_category_cover.cdn,
		
					'parent_category_event', parent_category_event.id,
					'parent_category_name', parent_category_trans.name
				)
		)
			AS parent_category, 
			CASE
			   WHEN category_cover.name IS NOT NULL 
			   THEN CONCAT ( '/upload/product_category_cover' , '/', category_cover.name)
			   ELSE NULL
			END AS category_cover_path
		, category_cover.ext AS category_cover_ext, category_cover.cdn AS category_cover_cdn FROM product_category_info info INNER JOIN product_category product_category ON product_category.event = info.event LEFT JOIN product_category_event product_category_event ON product_category_event.id = product_category.event LEFT JOIN product_category_trans product_category_trans ON product_category_trans.event = product_category_event.id  AND product_category_trans.local = 'ru' LEFT JOIN product_category_landing product_category_landing ON product_category_landing.event = product_category_event.id  AND product_category_landing.local = 'ru' LEFT JOIN product_category_event parent_category_event ON parent_category_event.parent = product_category.id LEFT JOIN product_category_cover category_cover ON category_cover.event = product_category.event LEFT JOIN product_category parent_product_category ON parent_product_category.id = product_category_event.parent LEFT JOIN product_category_trans parent_product_category_trans ON parent_product_category_trans.event = parent_product_category.event AND parent_product_category_trans.local = 'ru' LEFT JOIN product_category_info parent_product_category_info ON parent_product_category_info.event = parent_product_category.event  LEFT JOIN product_category_info parent_category_info ON parent_category_info.event = parent_category_event.id LEFT JOIN product_category_cover parent_category_cover ON parent_category_cover.event = parent_category_event.id LEFT JOIN product_category_trans parent_category_trans ON parent_category_trans.event = parent_category_event.id  AND parent_category_trans.local = 'ru' WHERE (info.url = 'komplekt_printer_i_sushka') AND (info.active = true) GROUP BY info.event, info.url, info.counter, product_category.id, product_category_event.parent, product_category_trans.name, product_category_landing.header, product_category_landing.bottom, parent_product_category_trans.name, parent_product_category_info.url, parent_product_category_info.counter, category_cover.name, category_cover.ext, category_cover.cdn;

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'
ORDER BY
  quote_ident(table_name)

SELECT quote_ident(table_name) AS table_name,
       table_schema AS schema_name
FROM information_schema.tables
WHERE table_catalog = 'tires'
  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'
ORDER BY
  quote_ident(table_name);

SELECT
  quote_ident(n.nspname) AS schema_name,
  quote_ident(c.relname) AS table_name,
  quote_ident(a.attname) AS field,
  t.typname AS type,
  format_type(a.atttypid, a.atttypmod) AS complete_type,
  bt.typname AS domain_type,
  format_type(bt.oid, t.typtypmod) AS domain_complete_type,
  a.attnotnull AS isnotnull,
  a.attidentity,
  (
    SELECT
      CASE WHEN a.attgenerated = 's' THEN
        NULL
      ELSE
        pg_get_expr(adbin, adrelid)
      END
    FROM
      pg_attrdef
    WHERE
      c.oid = pg_attrdef.adrelid
      AND pg_attrdef.adnum = a.attnum
  ) AS "default",
  dsc.description AS comment,
  CASE WHEN coll.collprovider = 'c' THEN
    coll.collcollate
  WHEN coll.collprovider = 'd' THEN
    NULL
  ELSE
    coll.collname
  END AS collation
FROM
  pg_attribute a
  JOIN pg_class c ON c.oid = a.attrelid
  JOIN pg_namespace n ON n.oid = c.relnamespace
  JOIN pg_type t ON t.oid = a.atttypid
  LEFT JOIN pg_type bt ON t.typtype = 'd'
  AND bt.oid = t.typbasetype
  LEFT JOIN pg_collation coll ON coll.oid = a.attcollation
  LEFT JOIN pg_depend dep ON dep.objid = c.oid
  AND dep.deptype = 'e'
  AND dep.classid = (
    SELECT
      oid
    FROM
      pg_class
    WHERE
      relname = 'pg_class'
  )
  LEFT JOIN pg_description dsc ON dsc.objoid = c.oid
  AND dsc.objsubid = a.attnum
  LEFT JOIN pg_inherits i ON i.inhrelid = c.oid
  LEFT JOIN pg_class p ON i.inhparent = p.oid
  AND p.relkind = 'p'
WHERE
  n.nspname = ANY(
    current_schemas(false)
  )
  AND c.relname = ?
  AND n.nspname NOT IN (
    'pg_catalog', 'information_schema',
    'pg_toast'
  ) -- 'r' for regular tables - 'p' for partitioned tables
  AND c.relkind IN ('r', 'p')
  AND a.attnum > 0
  AND dep.refobjid IS NULL -- exclude partitions (tables that inherit from partitioned tables)
  AND p.oid IS NULL
ORDER BY
  n.nspname,
  c.relname,
  a.attnum

SELECT quote_ident(n.nspname)               AS schema_name,
       quote_ident(c.relname)               AS table_name,
       quote_ident(a.attname)               AS field,
       t.typname                            AS type,
       format_type(a.atttypid, a.atttypmod) AS complete_type,
       bt.typname                           AS domain_type,
       format_type(bt.oid, t.typtypmod)     AS domain_complete_type,
       a.attnotnull                         AS isnotnull,
       a.attidentity,
       (    SELECT
        CASE
            WHEN a.attgenerated = 's' THEN NULL
            ELSE pg_get_expr(adbin, adrelid)
        END
     FROM pg_attrdef
     WHERE c.oid = pg_attrdef.adrelid
        AND pg_attrdef.adnum=a.attnum)                                 AS "default",
       dsc.description                      AS comment,
       CASE
           WHEN coll.collprovider = 'c'
               THEN coll.collcollate
           WHEN coll.collprovider = 'd'
               THEN NULL
           ELSE coll.collname
           END                              AS collation
FROM pg_attribute a
         JOIN pg_class c
              ON c.oid = a.attrelid
         JOIN pg_namespace n
              ON n.oid = c.relnamespace
         JOIN pg_type t
              ON t.oid = a.atttypid
         LEFT JOIN pg_type bt
                   ON t.typtype = 'd'
                       AND bt.oid = t.typbasetype
         LEFT JOIN pg_collation coll
                   ON coll.oid = a.attcollation
         LEFT JOIN pg_depend dep
                   ON dep.objid = c.oid
                       AND dep.deptype = 'e'
                       AND dep.classid = (SELECT oid FROM pg_class WHERE relname = 'pg_class')
         LEFT JOIN pg_description dsc
                   ON dsc.objoid = c.oid AND dsc.objsubid = a.attnum
         LEFT JOIN pg_inherits i
                   ON i.inhrelid = c.oid
         LEFT JOIN pg_class p
                   ON i.inhparent = p.oid
                       AND p.relkind = 'p'
WHERE n.nspname = ANY(current_schemas(false)) AND c.relname = 'doctrine_migration_versions' AND n.nspname NOT IN ('pg_catalog', 'information_schema', 'pg_toast')
  -- 'r' for regular tables - 'p' for partitioned tables
  AND c.relkind IN ('r', 'p')
  AND a.attnum > 0
  AND dep.refobjid IS NULL
  -- exclude partitions (tables that inherit from partitioned tables)
  AND p.oid IS NULL
ORDER BY n.nspname,
    c.relname,
    a.attnum;

SELECT
  quote_ident(n.nspname) AS schema_name,
  quote_ident(c.relname) AS table_name,
  quote_ident(ic.relname) AS relname,
  i.indisunique,
  i.indisprimary,
  i.indkey,
  i.indrelid,
  pg_get_expr(indpred, indrelid) AS "where",
  quote_ident(attname) AS attname
FROM
  pg_index i
  JOIN pg_class AS c ON c.oid = i.indrelid
  JOIN pg_namespace n ON n.oid = c.relnamespace
  JOIN pg_class AS ic ON ic.oid = i.indexrelid
  JOIN LATERAL UNNEST(i.indkey)
WITH
  ORDINALITY AS keys(attnum, ord) ON TRUE
  JOIN pg_attribute a ON a.attrelid = c.oid
  AND a.attnum = keys.attnum
WHERE
  n.nspname = ANY(
    current_schemas(false)
  )
  AND c.relname = ?
  AND n.nspname NOT IN (
    'pg_catalog', 'information_schema',
    'pg_toast'
  )
ORDER BY
  1,
  2,
  keys.ord;

SELECT
       quote_ident(n.nspname) AS schema_name,
       quote_ident(c.relname) AS table_name,
       quote_ident(ic.relname) AS relname,
       i.indisunique,
       i.indisprimary,
       i.indkey,
       i.indrelid,
       pg_get_expr(indpred, indrelid) AS "where",
       quote_ident(attname) AS attname
  FROM pg_index i
       JOIN pg_class AS c ON c.oid = i.indrelid
       JOIN pg_namespace n ON n.oid = c.relnamespace
       JOIN pg_class AS ic ON ic.oid = i.indexrelid
       JOIN LATERAL UNNEST(i.indkey) WITH ORDINALITY AS keys(attnum, ord)
            ON TRUE
       JOIN pg_attribute a
            ON a.attrelid = c.oid
                AND a.attnum = keys.attnum
 WHERE n.nspname = ANY(current_schemas(false)) AND c.relname = 'doctrine_migration_versions' AND n.nspname NOT IN ('pg_catalog', 'information_schema', 'pg_toast')
 ORDER BY 1, 2, keys.ord;;

SELECT
  CURRENT_DATABASE()

SELECT CURRENT_DATABASE();

SELECT
  quote_ident(tn.nspname) AS schema_name,
  quote_ident(tc.relname) AS table_name,
  quote_ident(r.conname) as conname,
  pg_get_constraintdef(r.oid, true) as condef,
  r.condeferrable,
  r.condeferred
FROM
  pg_constraint r
  JOIN pg_class AS tc ON tc.oid = r.conrelid
  JOIN pg_namespace tn ON tn.oid = tc.relnamespace
WHERE
  r.conrelid IN (
    SELECT
      c.oid
    FROM
      pg_class c
      JOIN pg_namespace n ON n.oid = c.relnamespace
    WHERE
      n.nspname = ANY(
        current_schemas(false)
      )
      AND c.relname = ?
      AND n.nspname NOT IN (
        'pg_catalog', 'information_schema',
        'pg_toast'
      )
  )
  AND r.contype = 'f'
ORDER BY
  1,
  2

SELECT
          quote_ident(tn.nspname) AS schema_name,
          quote_ident(tc.relname) AS table_name,
          quote_ident(r.conname) as conname,
          pg_get_constraintdef(r.oid, true) as condef,
          r.condeferrable,
          r.condeferred
          FROM pg_constraint r
              JOIN pg_class AS tc ON tc.oid = r.conrelid
              JOIN pg_namespace tn ON tn.oid = tc.relnamespace
          WHERE r.conrelid IN
          (
              SELECT c.oid
              FROM pg_class c
                JOIN pg_namespace n
                    ON n.oid = c.relnamespace
                WHERE n.nspname = ANY(current_schemas(false)) AND c.relname = 'doctrine_migration_versions' AND n.nspname NOT IN ('pg_catalog', 'information_schema', 'pg_toast'))
          AND r.contype = 'f'
          ORDER BY 1, 2;

SELECT
  quote_ident(n.nspname) AS schema_name,
  quote_ident(c.relname) AS table_name,
  CASE c.relpersistence
  WHEN 'u' THEN
    true
  ELSE
    false
  END as unlogged,
  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 n.nspname = ANY(
    current_schemas(false)
  )
  AND c.relname = ?
  AND n.nspname NOT IN (
    'pg_catalog', 'information_schema',
    'pg_toast'
  )

SELECT quote_ident(n.nspname) AS schema_name,
       quote_ident(c.relname) AS table_name,
       CASE c.relpersistence WHEN 'u' THEN true ELSE false END as unlogged,
       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 n.nspname = ANY(current_schemas(false)) AND c.relname = 'doctrine_migration_versions' AND n.nspname NOT IN ('pg_catalog', 'information_schema', 'pg_toast');

SELECT
  *
FROM
  doctrine_migration_versions

SELECT * FROM doctrine_migration_versions;

SELECT
  current_schema()

SELECT current_schema();