Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.template AS template_5,
  t0.map_engine_code AS map_engine_code_6,
  t0.persistent_view AS persistent_view_7,
  t0.splashscreen AS splashscreen_8,
  t0.screenshot AS screenshot_9,
  t0.extra_assets AS extra_assets_10,
  t0.updated AS updated_11,
  t0.custom_css AS custom_css_12
FROM
  mb_core_application t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.template AS template_5, t0.map_engine_code AS map_engine_code_6, t0.persistent_view AS persistent_view_7, t0.splashscreen AS splashscreen_8, t0.screenshot AS screenshot_9, t0.extra_assets AS extra_assets_10, t0.updated AS updated_11, t0.custom_css AS custom_css_12 FROM mb_core_application t0 WHERE t0.slug = 'mapbender_digitize_demo_db' LIMIT 1;

SELECT
  f0_.id AS id_0,
  f0_.subject_domain AS subject_domain_1,
  f0_.subject AS subject_2,
  f0_.resource_domain AS resource_domain_3,
  f0_.resource_ref AS resource_ref_4,
  f0_.action AS action_5,
  f0_.user_id AS user_id_6,
  f0_.group_id AS group_id_7,
  f0_.element_id AS element_id_8,
  f0_.application_id AS application_id_9
FROM
  fom_permission f0_
WHERE
  f0_.subject_domain = 'public'

SELECT f0_.id AS id_0, f0_.subject_domain AS subject_domain_1, f0_.subject AS subject_2, f0_.resource_domain AS resource_domain_3, f0_.resource_ref AS resource_ref_4, f0_.action AS action_5, f0_.user_id AS user_id_6, f0_.group_id AS group_id_7, f0_.element_id AS element_id_8, f0_.application_id AS application_id_9 FROM fom_permission f0_ WHERE f0_.subject_domain = 'public';

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.class AS class_3,
  t0.configuration AS configuration_4,
  t0.region AS region_5,
  t0.enabled AS enabled_6,
  t0.weight AS weight_7,
  t0.screenType AS screentype_8,
  t0.application_id AS application_id_9
FROM
  mb_core_element t0
WHERE
  (
    t0.id = ?
    AND t0.application_id = ?
  )
ORDER BY
  t0.weight ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.class AS class_3, t0.configuration AS configuration_4, t0.region AS region_5, t0.enabled AS enabled_6, t0.weight AS weight_7, t0.screenType AS screentype_8, t0.application_id AS application_id_9 FROM mb_core_element t0 WHERE (t0.id = 3861 AND t0.application_id = 122) ORDER BY t0.weight ASC;

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 3861 AND f0_.resource_domain = 'element');

SELECT
  f_geometry_column,
  srid,
  type
FROM
  "public"."geometry_columns"
WHERE
  f_table_name = ?
  AND "f_table_schema" = current_schema()

SELECT f_geometry_column, srid, type FROM "public"."geometry_columns" WHERE f_table_name = 'poi' AND "f_table_schema" = current_schema();

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
  n.nspname NOT IN (
    'pg_catalog', 'information_schema',
    'pg_toast'
  )
  AND c.relname = 'poi'
  AND n.nspname = ANY(
    current_schemas(false)
  )
  AND a.attnum > 0
  AND a.attrelid = c.oid
  AND a.atttypid = t.oid
  AND n.oid = c.relnamespace
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 n.nspname NOT IN ('pg_catalog', 'information_schema', 'pg_toast') AND c.relname = 'poi' AND n.nspname = ANY(current_schemas(false))
                        AND a.attnum > 0
                        AND a.attrelid = c.oid
                        AND a.atttypid = t.oid
                        AND n.oid = c.relnamespace
                    ORDER BY a.attnum;

SELECT
  "gid",
  "name",
  "type",
  "abstract",
  "public",
  "date_favorite",
  "title",
  "firstname",
  "lastname",
  "email",
  "interests",
  "user_name",
  "group_name",
  "modification_date",
  "my_type",
  "file_reference",
  "x",
  "y",
  "fontcolor",
  "year",
  "style",
  "symbol",
  "fill_color",
  "test1",
  "test1_array",
  "gemeinde",
  "gemarkung",
  "category",
  ST_AsEwkt(
    ST_TRANSFORM("geom", 25832)
  ) AS "geom"
FROM
  poi t
WHERE
  ("geom" IS NOT NULL)
  AND (
    (
      "geom" && ST_MakeValid(
        ST_Transform(
          ST_MakeValid(
            ST_GeomFromEWKT(
              'SRID=25832;POLYGON((365646.6115856495 5621881.092861571,366070.5349642153 5621881.092861571,366070.5349642153 5622078.923771569,365646.6115856495 5622078.923771569,365646.6115856495 5621881.092861571))'
            )
          ),
          4326
        )
      )
    )
  )
LIMIT
  500

SELECT "gid", "name", "type", "abstract", "public", "date_favorite", "title", "firstname", "lastname", "email", "interests", "user_name", "group_name", "modification_date", "my_type", "file_reference", "x", "y", "fontcolor", "year", "style", "symbol", "fill_color", "test1", "test1_array", "gemeinde", "gemarkung", "category", ST_AsEwkt(ST_TRANSFORM("geom", 25832)) AS "geom" FROM poi t WHERE ("geom" IS NOT NULL) AND (("geom" && ST_MakeValid(ST_Transform(ST_MakeValid(ST_GeomFromEWKT('SRID=25832;POLYGON((365646.6115856495 5621881.092861571,366070.5349642153 5621881.092861571,366070.5349642153 5622078.923771569,365646.6115856495 5622078.923771569,365646.6115856495 5621881.092861571))')), 4326)))) LIMIT 500;