Symfony Profiler

[
  "route" => "app_admin_stats"
  "route_parameters" => [
    "_route" => "app_admin_stats"
    "_controller" => "App\Controller\AdminController::stats"
    "insee_code" => "37161"
  ]
  "request_uri" => "https://osm-labo.cipherbliss.com/admin/stats/37161"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 0
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventSubscriber\WikiRedirectSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsCsrfTokenValidAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\Controller\ArgumentResolver\RequestPayloadValueResolver::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "sf"
    "password" => "<redacted>"
    "driverOptions" => [
      1002 => "SET NAMES utf8mb4"
      1000 => true
      "PDO::ATTR_TIMEOUT" => 300
      "PDO::ATTR_PERSISTENT" => false
      "PDO::MYSQL_ATTR_USE_BUFFERED_QUERY" => true
      "PDO::MYSQL_ATTR_INIT_COMMAND" => "SET SESSION wait_timeout=300, interactive_timeout=300"
    ]
    "defaultTableOptions" => []
    "dbname" => "osm_my_commerce"
    "serverVersion" => "15"
    "charset" => "utf8"
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.zone AS zone_1, s0_.completion_percent AS completion_percent_2, s0_.places_count AS places_count_3, s0_.avec_horaires AS avec_horaires_4, s0_.avec_adresse AS avec_adresse_5, s0_.avec_site AS avec_site_6, s0_.avec_accessibilite AS avec_accessibilite_7, s0_.avec_note AS avec_note_8, s0_.name AS name_9, s0_.population AS population_10, s0_.siren AS siren_11, s0_.code_epci AS code_epci_12, s0_.codes_postaux AS codes_postaux_13, s0_.date_created AS date_created_14, s0_.date_modified AS date_modified_15, s0_.avec_siret AS avec_siret_16, s0_.avec_name AS avec_name_17, s0_.avec_email AS avec_email_18, s0_.osm_data_date_min AS osm_data_date_min_19, s0_.osm_data_date_avg AS osm_data_date_avg_20, s0_.osm_data_date_max AS osm_data_date_max_21, s0_.budget_annuel AS budget_annuel_22, s0_.lat AS lat_23, s0_.lon AS lon_24, s0_.date_labourage_requested AS date_labourage_requested_25, s0_.date_labourage_done AS date_labourage_done_26, s0_.kind AS kind_27 FROM stats s0_ WHERE s0_.zone = ? ORDER BY s0_.id ASC LIMIT 1"
  "params" => [
    1 => "37161"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#588
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.measure AS measure_3, t0.date AS date_4, t0.stats_id AS stats_id_5 FROM city_follow_up t0 WHERE t0.stats_id = ?"
  "params" => [
    1 => 26610
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#709
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO action_log (type, data, created_at, from_url, who) VALUES (?, ?, ?, ?, ?)"
  "params" => [
    1 => "stats_de_ville"
    2 => "{"insee_code":"37161","nom":"37161"}"
    3 => "2026-07-15 04:11:12"
    4 => "https://osm-labo.cipherbliss.com/admin/labourer/37161?deleteMissing=1&disableFollowUpCleanup=1"
    5 => null
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#588
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#588}
    3 => Doctrine\DBAL\ParameterType {#588}
    4 => Doctrine\DBAL\ParameterType {#588}
    5 => Doctrine\DBAL\ParameterType {#588}
  ]
]

[
  "sql" => "SELECT COUNT(*) FROM osm_object t0 WHERE t0.zone = ?"
  "params" => [
    1 => "37161"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#588
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.places_count AS places_count_1, s0_.emails_count AS emails_count_2, s0_.completion_percent AS completion_percent_3, s0_.emails_sent AS emails_sent_4, s0_.date AS date_5, s0_.names_count AS names_count_6, s0_.opening_hours_count AS opening_hours_count_7, s0_.website_count AS website_count_8, s0_.address_count AS address_count_9, s0_.siret_count AS siret_count_10, s0_.stats_id AS stats_id_11 FROM stats_history s0_ WHERE s0_.stats_id = ? ORDER BY s0_.id DESC LIMIT 100"
  "params" => [
    1 => 26610
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#709
      +name: "INTEGER"
    }
  ]
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_pgsql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 5432
    "user" => "osmpgsql"
    "password" => "<redacted>"
    "driverOptions" => [
      1002 => "SET NAMES utf8mb4"
      "PDO::ATTR_TIMEOUT" => 600
      "PDO::ATTR_PERSISTENT" => false
    ]
    "defaultTableOptions" => []
    "dbname" => "osmpgsql"
    "serverVersion" => "16"
    "charset" => "utf8"
  ]
]

[
  "sql" => "SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'osm_object_history'"
]

[
  "sql" => "SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = ? AND table_name = ?"
  "params" => [
    1 => "public"
    2 => "osm_object_meta"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#588
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#588}
  ]
]

[
  "sql" => "SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = ? AND table_name = ?"
  "params" => [
    1 => "public"
    2 => "osm_object_history"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#588
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#588}
  ]
]

[
  "sql" => """
    SELECT COUNT(*) FROM osm_object_meta WHERE osm_type = 'relation'\n
                      AND geom IS NOT NULL\n
                      AND (tags->'admin_level') = '8'\n
                      AND (tags->'boundary') = 'administrative'\n
                      AND (tags->'ref:INSEE') IS NOT NULL
    """
]

[
  "sql" => """
    INSERT INTO osm_object_meta (\n
        osm_type, osm_id, geom, tags, version, osm_timestamp, changeset, osm_user, uid\n
    )\n
    SELECT\n
        'relation',\n
        latest.osm_id,\n
        latest.geom,\n
        latest.tags,\n
        latest.version,\n
        to_char(latest.valid_from AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS"Z"'),\n
        latest.changeset,\n
        latest.osm_user,\n
        latest.uid\n
    FROM (\n
        SELECT DISTINCT ON (h.osm_id)\n
            h.osm_id,\n
            h.geom,\n
            h.tags,\n
            h.version,\n
            h.valid_from,\n
            h.changeset,\n
            h.osm_user,\n
            h.uid\n
        FROM osm_object_history h\n
        WHERE h.osm_type = 'relation'\n
          AND h.visible = true\n
          AND h.geom IS NOT NULL\n
          AND (h.tags->'boundary') = 'administrative'\n
          AND (h.tags->'admin_level') = '8'\n
          AND (h.tags->'ref:INSEE') IS NOT NULL\n
        ORDER BY h.osm_id, h.version DESC, h.valid_from DESC\n
    ) AS latest\n
    WHERE NOT EXISTS (\n
        SELECT 1 FROM osm_object_meta m\n
        WHERE m.osm_type = 'relation' AND m.osm_id = latest.osm_id\n
    )
    """
]

[
  "sql" => """
    SELECT ST_AsText(ST_Multi(geom)) AS wkt\n
    FROM osm_object_meta m\n
    WHERE osm_type = 'relation'\n
      AND geom IS NOT NULL\n
      AND (tags->'ref:INSEE') = ?\n
      AND (tags->'admin_level') = '8'\n
      AND (tags->'boundary') = 'administrative'\n
    ORDER BY ST_Area(geom::geography) DESC NULLS LAST\n
    LIMIT 1
    """
  "params" => [
    1 => "37161"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#588
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = ? AND table_name = ?"
  "params" => [
    1 => "public"
    2 => "osm_object_history"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#588
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#588}
  ]
]

[
  "sql" => """
    SELECT ST_AsText(ST_Multi(geom)) AS wkt\n
    FROM (\n
        SELECT DISTINCT ON (h.osm_id)\n
            h.geom\n
        FROM osm_object_history h\n
        WHERE h.osm_type = 'relation'\n
          AND h.visible = true\n
          AND h.geom IS NOT NULL\n
          AND (h.tags->'ref:INSEE') = ?\n
          AND (h.tags->'admin_level') = '8'\n
          AND (h.tags->'boundary') = 'administrative'\n
        ORDER BY h.osm_id, h.version DESC, h.valid_from DESC\n
    ) latest\n
    ORDER BY ST_Area(geom::geography) DESC NULLS LAST\n
    LIMIT 1
    """
  "params" => [
    1 => "37161"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#588
      +name: "STRING"
    }
  ]
]

[
  "sql" => """
    CREATE TABLE IF NOT EXISTS zone_polygon (\n
                        insee_code TEXT PRIMARY KEY,\n
                        geom geometry(MultiPolygon, 4326) NOT NULL,\n
                        source TEXT NOT NULL,\n
                        updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()\n
                    )
    """
]

[
  "sql" => "CREATE INDEX IF NOT EXISTS zone_polygon_geom_idx ON zone_polygon USING GIST (geom)"
]

[
  "sql" => "SELECT ST_AsText(ST_Multi(geom)) FROM zone_polygon WHERE insee_code = ?"
  "params" => [
    1 => "37161"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#588
      +name: "STRING"
    }
  ]
]

[
  "sql" => """
    WITH zone AS (SELECT ST_GeomFromText(?, 4326) AS g),\n
    in_zone AS (\n
      SELECT h.osm_type, h.osm_id, h.version, h.valid_from, h.visible\n
      FROM osm_object_history h, zone z\n
      WHERE h.geom IS NOT NULL AND ST_Intersects(h.geom, z.g)\n
    ),\n
    creations AS (\n
      SELECT (valid_from AT TIME ZONE 'UTC')::date AS d\n
      FROM in_zone\n
      WHERE version = 1 AND visible = true AND valid_from >= NOW() - (? || ' days')::interval\n
    ),\n
    deletions AS (\n
      SELECT (del.valid_from AT TIME ZONE 'UTC')::date AS d\n
      FROM osm_object_history del\n
      JOIN in_zone prev\n
        ON prev.osm_type = del.osm_type\n
       AND prev.osm_id   = del.osm_id\n
       AND prev.version  = del.version - 1\n
      WHERE del.visible = false\n
        AND del.valid_from >= NOW() - (? || ' days')::interval\n
    )\n
    SELECT d::text AS date,\n
           SUM(n_creations)::int AS creations,\n
           SUM(n_deletions)::int AS deletions\n
    FROM (\n
      SELECT d, COUNT(*) AS n_creations, 0 AS n_deletions FROM creations GROUP BY d\n
      UNION ALL\n
      SELECT d, 0, COUNT(*) FROM deletions GROUP BY d\n
    ) u\n
    GROUP BY d\n
    ORDER BY d
    """
  "params" => [
    1 => "MULTIPOLYGON(((1.087111 47.46182,1.08909 47.462246,1.092332 47.462641,1.092727 47.462735,1.097419 47.463505,1.098936 47.463881,1.101506 47.464276,1.101781 47.464271,1.102317 47.464316,1.103111 47.464445,1.104379 47.464635,1.105454 47.464751,1.106391 47.464808,1.107206 47.464936,1.10826 47.465189,1.110461 47.465728,1.112817 47.466109,1.113381 47.464294,1.113513 47.464126,1.113964 47.463055,1.114071 47.462741,1.113794 47.462605,1.114473 47.46203,1.114903 47.46173,1.114985 47.461732,1.115472 47.461593,1.115968 47.46138,1.116321 47.461159,1.116928 47.460452,1.117042 47.4604,1.11704 47.460282,1.116933 47.460044,1.116965 47.459839,1.116925 47.459778,1.117368 47.459246,1.117443 47.459017,1.118027 47.458908,1.118495 47.458767,1.11939 47.458349,1.119656 47.458289,1.120199 47.4582,1.120415 47.458111,1.120719 47.457884,1.120875 47.457655,1.120873 47.45734,1.120651 47.456797,1.121194 47.455606,1.121927 47.454859,1.122425 47.454412,1.122927 47.45403,1.123357 47.453679,1.123952 47.453131,1.124907 47.452293,1.125089 47.452157,1.126006 47.451518,1.126377 47.451269,1.126896 47.451069,1.127978 47.450724,1.128017 47.450683,1.128967 47.449939,1.12957 47.449631,1.130637 47.449417,1.131571 47.449112,1.132834 47.44899,1.133466 47.448979,1.13331 47.448543,1.133039 47.448055,1.132811 47.447101,1.13236 47.446467,1.131789 47.445381,1.131124 47.445418,1.130411 47.444737,1.129368 47.443916,1.129203 47.443688,1.128268 47.442735,1.126571 47.441548,1.125731 47.441028,1.124897 47.440526,1.123783 47.439797,1.123311 47.439447,1.122901 47.439026,1.12218 47.438219,1.121841 47.437749,1.121621 47.43737,1.1215 47.436836,1.121392 47.436568,1.121113 47.435443,1.120921 47.435084,1.120785 47.434901,1.119945 47.433588,1.119338 47.432567,1.119076 47.432165,1.11867 47.431598,1.118387 47.431275,1.118186 47.431098,1.117132 47.430316,1.116901 47.430117,1.116291 47.429483,1.115839 47.429127,1.115521 47.428979,1.115232 47.428888,1.114677 47.428629,1.113787 47.428168,1.11365 47.428024,1.112005 47.42916,1.110264 47.429861,1.10822 47.430323,1.107946 47.43041,1.105716 47.431461,1.105221 47.431668,1.105049 47.431665,1.104811 47.43131,1.10449 47.430874,1.104162 47.430485,1.103967 47.430341,1.103558 47.430251,1.103088 47.43024,1.102223 47.430253,1.097606 47.429535,1.095524 47.429232,1.093631 47.428931,1.093506 47.428922,1.090873 47.429263,1.087938 47.429606,1.086315 47.429787,1.085493 47.429886,1.085249 47.429865,1.084904 47.429694,1.084535 47.429396,1.083925 47.428869,1.082447 47.427648,1.082039 47.427881,1.08165 47.428165,1.080755 47.428852,1.080411 47.429103,1.080311 47.429151,1.079566 47.429379,1.078468 47.429727,1.078376 47.429776,1.076567 47.431017,1.075953 47.431466,1.075591 47.431866,1.075091 47.43223,1.074834 47.432567,1.073985 47.433577,1.073837 47.433703,1.073026 47.434645,1.072682 47.435507,1.072429 47.436065,1.072193 47.436546,1.07203 47.436825,1.071874 47.437291,1.071604 47.437838,1.071569 47.437982,1.071088 47.438199,1.070643 47.439024,1.070472 47.439412,1.070304 47.439734,1.069874 47.440495,1.069744 47.440877,1.069643 47.441083,1.069412 47.441448,1.068678 47.442464,1.068271 47.442968,1.067894 47.443303,1.067609 47.443622,1.067599 47.443697,1.067368 47.443992,1.067125 47.444379,1.067073 47.444497,1.066874 47.444554,1.066175 47.445276,1.06593 47.445481,1.065741 47.445559,1.065297 47.445543,1.064968 47.445835,1.064745 47.445961,1.06432 47.446425,1.064119 47.446776,1.064069 47.447061,1.063974 47.447117,1.06396 47.448416,1.06447 47.449312,1.06497 47.449758,1.065375 47.450039,1.065811 47.450291,1.066453 47.450745,1.066905 47.451022,1.067203 47.451177,1.068428 47.451881,1.068973 47.452164,1.069937 47.452832,1.070654 47.453151,1.071011 47.453193,1.071369 47.453047,1.075437 47.455225,1.07856 47.457054,1.080347 47.458204,1.083111 47.460008,1.083558 47.460205,1.085007 47.461078,1.086781 47.461771,1.087111 47.46182)))"
    2 => "30"
    3 => "30"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#588
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#588}
    3 => Doctrine\DBAL\ParameterType {#588}
  ]
]

[
  "sql" => """
    SELECT to_char(qstart, 'YYYY') || '-Q' || EXTRACT(QUARTER FROM qstart)::int AS k,\n
           n\n
    FROM (\n
      SELECT date_trunc('quarter', valid_from) AS qstart, COUNT(*) AS n\n
      FROM osm_object_history h\n
      WHERE h.geom IS NOT NULL AND ST_Intersects(h.geom, ST_GeomFromText(?, 4326))\n
      GROUP BY 1\n
    ) t\n
    ORDER BY qstart
    """
  "params" => [
    1 => "MULTIPOLYGON(((1.087111 47.46182,1.08909 47.462246,1.092332 47.462641,1.092727 47.462735,1.097419 47.463505,1.098936 47.463881,1.101506 47.464276,1.101781 47.464271,1.102317 47.464316,1.103111 47.464445,1.104379 47.464635,1.105454 47.464751,1.106391 47.464808,1.107206 47.464936,1.10826 47.465189,1.110461 47.465728,1.112817 47.466109,1.113381 47.464294,1.113513 47.464126,1.113964 47.463055,1.114071 47.462741,1.113794 47.462605,1.114473 47.46203,1.114903 47.46173,1.114985 47.461732,1.115472 47.461593,1.115968 47.46138,1.116321 47.461159,1.116928 47.460452,1.117042 47.4604,1.11704 47.460282,1.116933 47.460044,1.116965 47.459839,1.116925 47.459778,1.117368 47.459246,1.117443 47.459017,1.118027 47.458908,1.118495 47.458767,1.11939 47.458349,1.119656 47.458289,1.120199 47.4582,1.120415 47.458111,1.120719 47.457884,1.120875 47.457655,1.120873 47.45734,1.120651 47.456797,1.121194 47.455606,1.121927 47.454859,1.122425 47.454412,1.122927 47.45403,1.123357 47.453679,1.123952 47.453131,1.124907 47.452293,1.125089 47.452157,1.126006 47.451518,1.126377 47.451269,1.126896 47.451069,1.127978 47.450724,1.128017 47.450683,1.128967 47.449939,1.12957 47.449631,1.130637 47.449417,1.131571 47.449112,1.132834 47.44899,1.133466 47.448979,1.13331 47.448543,1.133039 47.448055,1.132811 47.447101,1.13236 47.446467,1.131789 47.445381,1.131124 47.445418,1.130411 47.444737,1.129368 47.443916,1.129203 47.443688,1.128268 47.442735,1.126571 47.441548,1.125731 47.441028,1.124897 47.440526,1.123783 47.439797,1.123311 47.439447,1.122901 47.439026,1.12218 47.438219,1.121841 47.437749,1.121621 47.43737,1.1215 47.436836,1.121392 47.436568,1.121113 47.435443,1.120921 47.435084,1.120785 47.434901,1.119945 47.433588,1.119338 47.432567,1.119076 47.432165,1.11867 47.431598,1.118387 47.431275,1.118186 47.431098,1.117132 47.430316,1.116901 47.430117,1.116291 47.429483,1.115839 47.429127,1.115521 47.428979,1.115232 47.428888,1.114677 47.428629,1.113787 47.428168,1.11365 47.428024,1.112005 47.42916,1.110264 47.429861,1.10822 47.430323,1.107946 47.43041,1.105716 47.431461,1.105221 47.431668,1.105049 47.431665,1.104811 47.43131,1.10449 47.430874,1.104162 47.430485,1.103967 47.430341,1.103558 47.430251,1.103088 47.43024,1.102223 47.430253,1.097606 47.429535,1.095524 47.429232,1.093631 47.428931,1.093506 47.428922,1.090873 47.429263,1.087938 47.429606,1.086315 47.429787,1.085493 47.429886,1.085249 47.429865,1.084904 47.429694,1.084535 47.429396,1.083925 47.428869,1.082447 47.427648,1.082039 47.427881,1.08165 47.428165,1.080755 47.428852,1.080411 47.429103,1.080311 47.429151,1.079566 47.429379,1.078468 47.429727,1.078376 47.429776,1.076567 47.431017,1.075953 47.431466,1.075591 47.431866,1.075091 47.43223,1.074834 47.432567,1.073985 47.433577,1.073837 47.433703,1.073026 47.434645,1.072682 47.435507,1.072429 47.436065,1.072193 47.436546,1.07203 47.436825,1.071874 47.437291,1.071604 47.437838,1.071569 47.437982,1.071088 47.438199,1.070643 47.439024,1.070472 47.439412,1.070304 47.439734,1.069874 47.440495,1.069744 47.440877,1.069643 47.441083,1.069412 47.441448,1.068678 47.442464,1.068271 47.442968,1.067894 47.443303,1.067609 47.443622,1.067599 47.443697,1.067368 47.443992,1.067125 47.444379,1.067073 47.444497,1.066874 47.444554,1.066175 47.445276,1.06593 47.445481,1.065741 47.445559,1.065297 47.445543,1.064968 47.445835,1.064745 47.445961,1.06432 47.446425,1.064119 47.446776,1.064069 47.447061,1.063974 47.447117,1.06396 47.448416,1.06447 47.449312,1.06497 47.449758,1.065375 47.450039,1.065811 47.450291,1.066453 47.450745,1.066905 47.451022,1.067203 47.451177,1.068428 47.451881,1.068973 47.452164,1.069937 47.452832,1.070654 47.453151,1.071011 47.453193,1.071369 47.453047,1.075437 47.455225,1.07856 47.457054,1.080347 47.458204,1.083111 47.460008,1.083558 47.460205,1.085007 47.461078,1.086781 47.461771,1.087111 47.46182)))"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#588
      +name: "STRING"
    }
  ]
]

[
  "sql" => """
    WITH last_versions AS (\n
      SELECT DISTINCT ON (osm_type, osm_id) osm_type, osm_id, valid_from, visible, geom\n
      FROM osm_object_history h\n
      WHERE h.geom IS NOT NULL\n
        AND ST_Intersects(h.geom, ST_GeomFromText(?, 4326))\n
      ORDER BY osm_type, osm_id, valid_from DESC\n
    )\n
    SELECT TO_TIMESTAMP(AVG(EXTRACT(EPOCH FROM valid_from))) AS avg_ts,\n
           COUNT(*) AS n\n
    FROM last_versions\n
    WHERE visible = true
    """
  "params" => [
    1 => "MULTIPOLYGON(((1.087111 47.46182,1.08909 47.462246,1.092332 47.462641,1.092727 47.462735,1.097419 47.463505,1.098936 47.463881,1.101506 47.464276,1.101781 47.464271,1.102317 47.464316,1.103111 47.464445,1.104379 47.464635,1.105454 47.464751,1.106391 47.464808,1.107206 47.464936,1.10826 47.465189,1.110461 47.465728,1.112817 47.466109,1.113381 47.464294,1.113513 47.464126,1.113964 47.463055,1.114071 47.462741,1.113794 47.462605,1.114473 47.46203,1.114903 47.46173,1.114985 47.461732,1.115472 47.461593,1.115968 47.46138,1.116321 47.461159,1.116928 47.460452,1.117042 47.4604,1.11704 47.460282,1.116933 47.460044,1.116965 47.459839,1.116925 47.459778,1.117368 47.459246,1.117443 47.459017,1.118027 47.458908,1.118495 47.458767,1.11939 47.458349,1.119656 47.458289,1.120199 47.4582,1.120415 47.458111,1.120719 47.457884,1.120875 47.457655,1.120873 47.45734,1.120651 47.456797,1.121194 47.455606,1.121927 47.454859,1.122425 47.454412,1.122927 47.45403,1.123357 47.453679,1.123952 47.453131,1.124907 47.452293,1.125089 47.452157,1.126006 47.451518,1.126377 47.451269,1.126896 47.451069,1.127978 47.450724,1.128017 47.450683,1.128967 47.449939,1.12957 47.449631,1.130637 47.449417,1.131571 47.449112,1.132834 47.44899,1.133466 47.448979,1.13331 47.448543,1.133039 47.448055,1.132811 47.447101,1.13236 47.446467,1.131789 47.445381,1.131124 47.445418,1.130411 47.444737,1.129368 47.443916,1.129203 47.443688,1.128268 47.442735,1.126571 47.441548,1.125731 47.441028,1.124897 47.440526,1.123783 47.439797,1.123311 47.439447,1.122901 47.439026,1.12218 47.438219,1.121841 47.437749,1.121621 47.43737,1.1215 47.436836,1.121392 47.436568,1.121113 47.435443,1.120921 47.435084,1.120785 47.434901,1.119945 47.433588,1.119338 47.432567,1.119076 47.432165,1.11867 47.431598,1.118387 47.431275,1.118186 47.431098,1.117132 47.430316,1.116901 47.430117,1.116291 47.429483,1.115839 47.429127,1.115521 47.428979,1.115232 47.428888,1.114677 47.428629,1.113787 47.428168,1.11365 47.428024,1.112005 47.42916,1.110264 47.429861,1.10822 47.430323,1.107946 47.43041,1.105716 47.431461,1.105221 47.431668,1.105049 47.431665,1.104811 47.43131,1.10449 47.430874,1.104162 47.430485,1.103967 47.430341,1.103558 47.430251,1.103088 47.43024,1.102223 47.430253,1.097606 47.429535,1.095524 47.429232,1.093631 47.428931,1.093506 47.428922,1.090873 47.429263,1.087938 47.429606,1.086315 47.429787,1.085493 47.429886,1.085249 47.429865,1.084904 47.429694,1.084535 47.429396,1.083925 47.428869,1.082447 47.427648,1.082039 47.427881,1.08165 47.428165,1.080755 47.428852,1.080411 47.429103,1.080311 47.429151,1.079566 47.429379,1.078468 47.429727,1.078376 47.429776,1.076567 47.431017,1.075953 47.431466,1.075591 47.431866,1.075091 47.43223,1.074834 47.432567,1.073985 47.433577,1.073837 47.433703,1.073026 47.434645,1.072682 47.435507,1.072429 47.436065,1.072193 47.436546,1.07203 47.436825,1.071874 47.437291,1.071604 47.437838,1.071569 47.437982,1.071088 47.438199,1.070643 47.439024,1.070472 47.439412,1.070304 47.439734,1.069874 47.440495,1.069744 47.440877,1.069643 47.441083,1.069412 47.441448,1.068678 47.442464,1.068271 47.442968,1.067894 47.443303,1.067609 47.443622,1.067599 47.443697,1.067368 47.443992,1.067125 47.444379,1.067073 47.444497,1.066874 47.444554,1.066175 47.445276,1.06593 47.445481,1.065741 47.445559,1.065297 47.445543,1.064968 47.445835,1.064745 47.445961,1.06432 47.446425,1.064119 47.446776,1.064069 47.447061,1.063974 47.447117,1.06396 47.448416,1.06447 47.449312,1.06497 47.449758,1.065375 47.450039,1.065811 47.450291,1.066453 47.450745,1.066905 47.451022,1.067203 47.451177,1.068428 47.451881,1.068973 47.452164,1.069937 47.452832,1.070654 47.453151,1.071011 47.453193,1.071369 47.453047,1.075437 47.455225,1.07856 47.457054,1.080347 47.458204,1.083111 47.460008,1.083558 47.460205,1.085007 47.461078,1.086781 47.461771,1.087111 47.46182)))"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#588
      +name: "STRING"
    }
  ]
]

[
  "sql" => """
    WITH zone AS (SELECT ST_GeomFromText(?, 4326) AS g),\n
    in_zone AS (\n
      SELECT h.osm_type, h.osm_id, h.version, h.visible\n
      FROM osm_object_history h, zone z\n
      WHERE h.geom IS NOT NULL AND ST_Intersects(h.geom, z.g)\n
    ),\n
    deletions AS (\n
      SELECT 1 AS one\n
      FROM osm_object_history del\n
      JOIN in_zone prev\n
        ON prev.osm_type = del.osm_type\n
       AND prev.osm_id   = del.osm_id\n
       AND prev.version  = del.version - 1\n
      WHERE del.visible = false\n
    )\n
    SELECT\n
      (SELECT COUNT(*) FROM in_zone WHERE version = 1 AND visible = true) AS creations_total,\n
      (SELECT COUNT(*) FROM deletions)                                    AS deletions_total,\n
      (SELECT COUNT(*) FROM in_zone)                                      AS versions_total
    """
  "params" => [
    1 => "MULTIPOLYGON(((1.087111 47.46182,1.08909 47.462246,1.092332 47.462641,1.092727 47.462735,1.097419 47.463505,1.098936 47.463881,1.101506 47.464276,1.101781 47.464271,1.102317 47.464316,1.103111 47.464445,1.104379 47.464635,1.105454 47.464751,1.106391 47.464808,1.107206 47.464936,1.10826 47.465189,1.110461 47.465728,1.112817 47.466109,1.113381 47.464294,1.113513 47.464126,1.113964 47.463055,1.114071 47.462741,1.113794 47.462605,1.114473 47.46203,1.114903 47.46173,1.114985 47.461732,1.115472 47.461593,1.115968 47.46138,1.116321 47.461159,1.116928 47.460452,1.117042 47.4604,1.11704 47.460282,1.116933 47.460044,1.116965 47.459839,1.116925 47.459778,1.117368 47.459246,1.117443 47.459017,1.118027 47.458908,1.118495 47.458767,1.11939 47.458349,1.119656 47.458289,1.120199 47.4582,1.120415 47.458111,1.120719 47.457884,1.120875 47.457655,1.120873 47.45734,1.120651 47.456797,1.121194 47.455606,1.121927 47.454859,1.122425 47.454412,1.122927 47.45403,1.123357 47.453679,1.123952 47.453131,1.124907 47.452293,1.125089 47.452157,1.126006 47.451518,1.126377 47.451269,1.126896 47.451069,1.127978 47.450724,1.128017 47.450683,1.128967 47.449939,1.12957 47.449631,1.130637 47.449417,1.131571 47.449112,1.132834 47.44899,1.133466 47.448979,1.13331 47.448543,1.133039 47.448055,1.132811 47.447101,1.13236 47.446467,1.131789 47.445381,1.131124 47.445418,1.130411 47.444737,1.129368 47.443916,1.129203 47.443688,1.128268 47.442735,1.126571 47.441548,1.125731 47.441028,1.124897 47.440526,1.123783 47.439797,1.123311 47.439447,1.122901 47.439026,1.12218 47.438219,1.121841 47.437749,1.121621 47.43737,1.1215 47.436836,1.121392 47.436568,1.121113 47.435443,1.120921 47.435084,1.120785 47.434901,1.119945 47.433588,1.119338 47.432567,1.119076 47.432165,1.11867 47.431598,1.118387 47.431275,1.118186 47.431098,1.117132 47.430316,1.116901 47.430117,1.116291 47.429483,1.115839 47.429127,1.115521 47.428979,1.115232 47.428888,1.114677 47.428629,1.113787 47.428168,1.11365 47.428024,1.112005 47.42916,1.110264 47.429861,1.10822 47.430323,1.107946 47.43041,1.105716 47.431461,1.105221 47.431668,1.105049 47.431665,1.104811 47.43131,1.10449 47.430874,1.104162 47.430485,1.103967 47.430341,1.103558 47.430251,1.103088 47.43024,1.102223 47.430253,1.097606 47.429535,1.095524 47.429232,1.093631 47.428931,1.093506 47.428922,1.090873 47.429263,1.087938 47.429606,1.086315 47.429787,1.085493 47.429886,1.085249 47.429865,1.084904 47.429694,1.084535 47.429396,1.083925 47.428869,1.082447 47.427648,1.082039 47.427881,1.08165 47.428165,1.080755 47.428852,1.080411 47.429103,1.080311 47.429151,1.079566 47.429379,1.078468 47.429727,1.078376 47.429776,1.076567 47.431017,1.075953 47.431466,1.075591 47.431866,1.075091 47.43223,1.074834 47.432567,1.073985 47.433577,1.073837 47.433703,1.073026 47.434645,1.072682 47.435507,1.072429 47.436065,1.072193 47.436546,1.07203 47.436825,1.071874 47.437291,1.071604 47.437838,1.071569 47.437982,1.071088 47.438199,1.070643 47.439024,1.070472 47.439412,1.070304 47.439734,1.069874 47.440495,1.069744 47.440877,1.069643 47.441083,1.069412 47.441448,1.068678 47.442464,1.068271 47.442968,1.067894 47.443303,1.067609 47.443622,1.067599 47.443697,1.067368 47.443992,1.067125 47.444379,1.067073 47.444497,1.066874 47.444554,1.066175 47.445276,1.06593 47.445481,1.065741 47.445559,1.065297 47.445543,1.064968 47.445835,1.064745 47.445961,1.06432 47.446425,1.064119 47.446776,1.064069 47.447061,1.063974 47.447117,1.06396 47.448416,1.06447 47.449312,1.06497 47.449758,1.065375 47.450039,1.065811 47.450291,1.066453 47.450745,1.066905 47.451022,1.067203 47.451177,1.068428 47.451881,1.068973 47.452164,1.069937 47.452832,1.070654 47.453151,1.071011 47.453193,1.071369 47.453047,1.075437 47.455225,1.07856 47.457054,1.080347 47.458204,1.083111 47.460008,1.083558 47.460205,1.085007 47.461078,1.086781 47.461771,1.087111 47.46182)))"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#588
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT p0_.osm_user AS osm_user_0, COUNT(p0_.id) AS sclr_1, AVG((CASE WHEN p0_.has_opening_hours = 1 THEN 1 ELSE 0 END) + (CASE WHEN p0_.has_address = 1 THEN 1 ELSE 0 END) + (CASE WHEN p0_.has_website = 1 THEN 1 ELSE 0 END) + (CASE WHEN p0_.has_wheelchair = 1 THEN 1 ELSE 0 END) + (CASE WHEN p0_.has_note = 1 THEN 1 ELSE 0 END)) / 5 * 100 AS sclr_2 FROM place p0_ WHERE p0_.osm_user IS NOT NULL AND p0_.osm_user <> '' AND p0_.stats_id = ? GROUP BY p0_.osm_user ORDER BY sclr_1 DESC LIMIT 100"
  "params" => [
    1 => 26610
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#709
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.disappeared_list AS disappeared_list_2, t0.current_list AS current_list_3, t0.theme AS theme_4, t0.stats_id AS stats_id_5 FROM zone_places t0 WHERE t0.stats_id = ?"
  "params" => [
    1 => 26610
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#709
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT 1"
]

[
  "sql" => "SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'osm_object_meta'"
]

[
  "sql" => """
    \n
    SELECT osm_type, osm_id::text AS osm_id,\n
           ST_Y(ST_Centroid(m.geom)) AS lat, ST_X(ST_Centroid(m.geom)) AS lon,\n
           tags::jsonb AS tags_json, version, osm_timestamp, changeset, osm_user, uid::bigint AS uid,\n
           ST_AsGeoJSON(ST_Force2D(m.geom), 6, 0) AS geom_geojson,\n
           COALESCE(ST_Length(ST_Intersection(ST_MakeValid(m.geom), bufc.buf)::geography), 0) AS length_m,\n
           CASE\n
             WHEN (tags->'highway') = 'proposed' AND exist(tags, 'proposed') AND (tags->'proposed') = 'cycleway' THEN 'proposed_cycleway'\n
             WHEN (tags->'highway') = 'cycleway' THEN 'separated'\n
             WHEN (tags->'highway') = 'busway' THEN 'separated'\n
             WHEN (tags->'cycleway:both') IN ('track', 'opposite_track', 'separate')\n
                  AND exist(tags, 'highway')\n
                  AND (tags->'highway') IS NOT NULL AND (tags->'highway') NOT IN ('cycleway', 'busway') THEN 'separated'\n
             WHEN EXISTS (SELECT 1 FROM unnest(akeys(tags)) k WHERE k = 'cycleway' OR k LIKE 'cycleway:%') AND exist(tags, 'highway')\n
                  AND (tags->'highway') IS NOT NULL AND (tags->'highway') NOT IN ('cycleway', 'busway') THEN 'lane'\n
             WHEN (exist(tags, 'bicycle') AND (tags->'bicycle') IS NOT NULL AND (tags->'bicycle') <> 'no') AND exist(tags, 'highway')\n
                  AND (tags->'highway') IS NOT NULL AND (tags->'highway') NOT IN ('cycleway', 'busway')\n
                  AND NOT (EXISTS (SELECT 1 FROM unnest(akeys(tags)) k WHERE k = 'cycleway' OR k LIKE 'cycleway:%')) THEN 'designated'\n
             ELSE NULL\n
           END AS cycleway_category\n
    FROM osm_object_meta m\n
    CROSS JOIN (SELECT ST_MakeValid(ST_SetSRID(ST_GeomFromText(?), 4326)) AS poly) z\n
    CROSS JOIN LATERAL (SELECT ST_Buffer(z.poly::geography, ?)::geometry AS buf) bufc\n
    WHERE m.geom IS NOT NULL\n
      AND m.osm_type IN ('way', 'relation')\n
      AND ST_Intersects(m.geom, bufc.buf)\n
      AND (\n
        (tags->'highway') = 'proposed' AND exist(tags, 'proposed') AND (tags->'proposed') = 'cycleway'\n
        OR (tags->'highway') IN ('cycleway', 'busway')\n
        OR (EXISTS (SELECT 1 FROM unnest(akeys(tags)) k WHERE k = 'cycleway' OR k LIKE 'cycleway:%') AND exist(tags, 'highway')\n
            AND (tags->'highway') IS NOT NULL AND (tags->'highway') NOT IN ('cycleway', 'busway'))\n
        OR ((exist(tags, 'bicycle') AND (tags->'bicycle') IS NOT NULL AND (tags->'bicycle') <> 'no') AND exist(tags, 'highway')\n
            AND (tags->'highway') IS NOT NULL AND (tags->'highway') NOT IN ('cycleway', 'busway'))\n
      )\n
    """
  "params" => [
    1 => "MULTIPOLYGON(((1.087111 47.46182,1.08909 47.462246,1.092332 47.462641,1.092727 47.462735,1.097419 47.463505,1.098936 47.463881,1.101506 47.464276,1.101781 47.464271,1.102317 47.464316,1.103111 47.464445,1.104379 47.464635,1.105454 47.464751,1.106391 47.464808,1.107206 47.464936,1.10826 47.465189,1.110461 47.465728,1.112817 47.466109,1.113381 47.464294,1.113513 47.464126,1.113964 47.463055,1.114071 47.462741,1.113794 47.462605,1.114473 47.46203,1.114903 47.46173,1.114985 47.461732,1.115472 47.461593,1.115968 47.46138,1.116321 47.461159,1.116928 47.460452,1.117042 47.4604,1.11704 47.460282,1.116933 47.460044,1.116965 47.459839,1.116925 47.459778,1.117368 47.459246,1.117443 47.459017,1.118027 47.458908,1.118495 47.458767,1.11939 47.458349,1.119656 47.458289,1.120199 47.4582,1.120415 47.458111,1.120719 47.457884,1.120875 47.457655,1.120873 47.45734,1.120651 47.456797,1.121194 47.455606,1.121927 47.454859,1.122425 47.454412,1.122927 47.45403,1.123357 47.453679,1.123952 47.453131,1.124907 47.452293,1.125089 47.452157,1.126006 47.451518,1.126377 47.451269,1.126896 47.451069,1.127978 47.450724,1.128017 47.450683,1.128967 47.449939,1.12957 47.449631,1.130637 47.449417,1.131571 47.449112,1.132834 47.44899,1.133466 47.448979,1.13331 47.448543,1.133039 47.448055,1.132811 47.447101,1.13236 47.446467,1.131789 47.445381,1.131124 47.445418,1.130411 47.444737,1.129368 47.443916,1.129203 47.443688,1.128268 47.442735,1.126571 47.441548,1.125731 47.441028,1.124897 47.440526,1.123783 47.439797,1.123311 47.439447,1.122901 47.439026,1.12218 47.438219,1.121841 47.437749,1.121621 47.43737,1.1215 47.436836,1.121392 47.436568,1.121113 47.435443,1.120921 47.435084,1.120785 47.434901,1.119945 47.433588,1.119338 47.432567,1.119076 47.432165,1.11867 47.431598,1.118387 47.431275,1.118186 47.431098,1.117132 47.430316,1.116901 47.430117,1.116291 47.429483,1.115839 47.429127,1.115521 47.428979,1.115232 47.428888,1.114677 47.428629,1.113787 47.428168,1.11365 47.428024,1.112005 47.42916,1.110264 47.429861,1.10822 47.430323,1.107946 47.43041,1.105716 47.431461,1.105221 47.431668,1.105049 47.431665,1.104811 47.43131,1.10449 47.430874,1.104162 47.430485,1.103967 47.430341,1.103558 47.430251,1.103088 47.43024,1.102223 47.430253,1.097606 47.429535,1.095524 47.429232,1.093631 47.428931,1.093506 47.428922,1.090873 47.429263,1.087938 47.429606,1.086315 47.429787,1.085493 47.429886,1.085249 47.429865,1.084904 47.429694,1.084535 47.429396,1.083925 47.428869,1.082447 47.427648,1.082039 47.427881,1.08165 47.428165,1.080755 47.428852,1.080411 47.429103,1.080311 47.429151,1.079566 47.429379,1.078468 47.429727,1.078376 47.429776,1.076567 47.431017,1.075953 47.431466,1.075591 47.431866,1.075091 47.43223,1.074834 47.432567,1.073985 47.433577,1.073837 47.433703,1.073026 47.434645,1.072682 47.435507,1.072429 47.436065,1.072193 47.436546,1.07203 47.436825,1.071874 47.437291,1.071604 47.437838,1.071569 47.437982,1.071088 47.438199,1.070643 47.439024,1.070472 47.439412,1.070304 47.439734,1.069874 47.440495,1.069744 47.440877,1.069643 47.441083,1.069412 47.441448,1.068678 47.442464,1.068271 47.442968,1.067894 47.443303,1.067609 47.443622,1.067599 47.443697,1.067368 47.443992,1.067125 47.444379,1.067073 47.444497,1.066874 47.444554,1.066175 47.445276,1.06593 47.445481,1.065741 47.445559,1.065297 47.445543,1.064968 47.445835,1.064745 47.445961,1.06432 47.446425,1.064119 47.446776,1.064069 47.447061,1.063974 47.447117,1.06396 47.448416,1.06447 47.449312,1.06497 47.449758,1.065375 47.450039,1.065811 47.450291,1.066453 47.450745,1.066905 47.451022,1.067203 47.451177,1.068428 47.451881,1.068973 47.452164,1.069937 47.452832,1.070654 47.453151,1.071011 47.453193,1.071369 47.453047,1.075437 47.455225,1.07856 47.457054,1.080347 47.458204,1.083111 47.460008,1.083558 47.460205,1.085007 47.461078,1.086781 47.461771,1.087111 47.46182)))"
    2 => 2000.0
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#588
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#588}
  ]
]

[
  "sql" => "SELECT 1"
]

[
  "sql" => "SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'osm_object_meta'"
]

[
  "sql" => """
    \n
    SELECT osm_type, osm_id::text AS osm_id,\n
           ST_Y(ST_Centroid(m.geom)) AS lat, ST_X(ST_Centroid(m.geom)) AS lon,\n
           tags::jsonb AS tags_json, version, osm_timestamp, changeset, osm_user, uid::bigint AS uid,\n
           ST_AsGeoJSON(ST_Force2D(m.geom), 6, 0) AS geom_geojson,\n
           COALESCE(ST_Length(ST_Intersection(ST_MakeValid(m.geom), z.poly)::geography), 0) AS length_m\n
    FROM osm_object_meta m\n
    CROSS JOIN (SELECT ST_MakeValid(ST_SetSRID(ST_GeomFromText(?), 4326)) AS poly) z\n
    WHERE m.geom IS NOT NULL\n
      AND m.osm_type IN ('way', 'relation')\n
      AND ST_Intersects(m.geom, z.poly)\n
      AND exist(tags, 'highway')\n
      AND (tags->'highway') NOT IN (\n
        'motorway', 'motorway_link', 'trunk', 'trunk_link',\n
        'footway', 'steps', 'pedestrian', 'bridleway', 'raceway',\n
        'cycleway', 'busway', 'construction', 'proposed'\n
      )\n
      AND (tags->'oneway') IN ('yes', '-1', '1')\n
      AND NOT ( (tags->'highway') IN ('cycleway', 'busway')\n
        OR (EXISTS (SELECT 1 FROM unnest(akeys(tags)) k WHERE k = 'cycleway' OR k LIKE 'cycleway:%') AND exist(tags, 'highway') AND (tags->'highway') IS NOT NULL AND (tags->'highway') NOT IN ('cycleway', 'busway'))\n
        OR ((exist(tags, 'bicycle') AND (tags->'bicycle') IS NOT NULL AND (tags->'bicycle') <> 'no') AND exist(tags, 'highway') AND (tags->'highway') IS NOT NULL AND (tags->'highway') NOT IN ('cycleway', 'busway') AND NOT (EXISTS (SELECT 1 FROM unnest(akeys(tags)) k WHERE k = 'cycleway' OR k LIKE 'cycleway:%'))))\n
      AND NOT ((tags->'oneway:bicycle') = 'no')\n
    """
  "params" => [
    1 => "MULTIPOLYGON(((1.087111 47.46182,1.08909 47.462246,1.092332 47.462641,1.092727 47.462735,1.097419 47.463505,1.098936 47.463881,1.101506 47.464276,1.101781 47.464271,1.102317 47.464316,1.103111 47.464445,1.104379 47.464635,1.105454 47.464751,1.106391 47.464808,1.107206 47.464936,1.10826 47.465189,1.110461 47.465728,1.112817 47.466109,1.113381 47.464294,1.113513 47.464126,1.113964 47.463055,1.114071 47.462741,1.113794 47.462605,1.114473 47.46203,1.114903 47.46173,1.114985 47.461732,1.115472 47.461593,1.115968 47.46138,1.116321 47.461159,1.116928 47.460452,1.117042 47.4604,1.11704 47.460282,1.116933 47.460044,1.116965 47.459839,1.116925 47.459778,1.117368 47.459246,1.117443 47.459017,1.118027 47.458908,1.118495 47.458767,1.11939 47.458349,1.119656 47.458289,1.120199 47.4582,1.120415 47.458111,1.120719 47.457884,1.120875 47.457655,1.120873 47.45734,1.120651 47.456797,1.121194 47.455606,1.121927 47.454859,1.122425 47.454412,1.122927 47.45403,1.123357 47.453679,1.123952 47.453131,1.124907 47.452293,1.125089 47.452157,1.126006 47.451518,1.126377 47.451269,1.126896 47.451069,1.127978 47.450724,1.128017 47.450683,1.128967 47.449939,1.12957 47.449631,1.130637 47.449417,1.131571 47.449112,1.132834 47.44899,1.133466 47.448979,1.13331 47.448543,1.133039 47.448055,1.132811 47.447101,1.13236 47.446467,1.131789 47.445381,1.131124 47.445418,1.130411 47.444737,1.129368 47.443916,1.129203 47.443688,1.128268 47.442735,1.126571 47.441548,1.125731 47.441028,1.124897 47.440526,1.123783 47.439797,1.123311 47.439447,1.122901 47.439026,1.12218 47.438219,1.121841 47.437749,1.121621 47.43737,1.1215 47.436836,1.121392 47.436568,1.121113 47.435443,1.120921 47.435084,1.120785 47.434901,1.119945 47.433588,1.119338 47.432567,1.119076 47.432165,1.11867 47.431598,1.118387 47.431275,1.118186 47.431098,1.117132 47.430316,1.116901 47.430117,1.116291 47.429483,1.115839 47.429127,1.115521 47.428979,1.115232 47.428888,1.114677 47.428629,1.113787 47.428168,1.11365 47.428024,1.112005 47.42916,1.110264 47.429861,1.10822 47.430323,1.107946 47.43041,1.105716 47.431461,1.105221 47.431668,1.105049 47.431665,1.104811 47.43131,1.10449 47.430874,1.104162 47.430485,1.103967 47.430341,1.103558 47.430251,1.103088 47.43024,1.102223 47.430253,1.097606 47.429535,1.095524 47.429232,1.093631 47.428931,1.093506 47.428922,1.090873 47.429263,1.087938 47.429606,1.086315 47.429787,1.085493 47.429886,1.085249 47.429865,1.084904 47.429694,1.084535 47.429396,1.083925 47.428869,1.082447 47.427648,1.082039 47.427881,1.08165 47.428165,1.080755 47.428852,1.080411 47.429103,1.080311 47.429151,1.079566 47.429379,1.078468 47.429727,1.078376 47.429776,1.076567 47.431017,1.075953 47.431466,1.075591 47.431866,1.075091 47.43223,1.074834 47.432567,1.073985 47.433577,1.073837 47.433703,1.073026 47.434645,1.072682 47.435507,1.072429 47.436065,1.072193 47.436546,1.07203 47.436825,1.071874 47.437291,1.071604 47.437838,1.071569 47.437982,1.071088 47.438199,1.070643 47.439024,1.070472 47.439412,1.070304 47.439734,1.069874 47.440495,1.069744 47.440877,1.069643 47.441083,1.069412 47.441448,1.068678 47.442464,1.068271 47.442968,1.067894 47.443303,1.067609 47.443622,1.067599 47.443697,1.067368 47.443992,1.067125 47.444379,1.067073 47.444497,1.066874 47.444554,1.066175 47.445276,1.06593 47.445481,1.065741 47.445559,1.065297 47.445543,1.064968 47.445835,1.064745 47.445961,1.06432 47.446425,1.064119 47.446776,1.064069 47.447061,1.063974 47.447117,1.06396 47.448416,1.06447 47.449312,1.06497 47.449758,1.065375 47.450039,1.065811 47.450291,1.066453 47.450745,1.066905 47.451022,1.067203 47.451177,1.068428 47.451881,1.068973 47.452164,1.069937 47.452832,1.070654 47.453151,1.071011 47.453193,1.071369 47.453047,1.075437 47.455225,1.07856 47.457054,1.080347 47.458204,1.083111 47.460008,1.083558 47.460205,1.085007 47.461078,1.086781 47.461771,1.087111 47.46182)))"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#588
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT 1"
]

[
  "sql" => "SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'osm_object_meta'"
]

[
  "sql" => """
    SELECT osm_type, osm_id::text AS osm_id,\n
           ST_Y(ST_Centroid(geom)) AS lat, ST_X(ST_Centroid(geom)) AS lon,\n
           tags::jsonb AS tags_json, version, osm_timestamp, changeset, osm_user, uid::bigint AS uid\n
    FROM osm_object_meta m\n
    WHERE geom IS NOT NULL\n
      AND ST_Intersects(m.geom, ST_GeomFromText(?, 4326))\n
      AND (tags->'man_made') = 'monitoring_station'\n
      AND (tags->'monitoring:bicycle') = 'yes'
    """
  "params" => [
    1 => "MULTIPOLYGON(((1.087111 47.46182,1.08909 47.462246,1.092332 47.462641,1.092727 47.462735,1.097419 47.463505,1.098936 47.463881,1.101506 47.464276,1.101781 47.464271,1.102317 47.464316,1.103111 47.464445,1.104379 47.464635,1.105454 47.464751,1.106391 47.464808,1.107206 47.464936,1.10826 47.465189,1.110461 47.465728,1.112817 47.466109,1.113381 47.464294,1.113513 47.464126,1.113964 47.463055,1.114071 47.462741,1.113794 47.462605,1.114473 47.46203,1.114903 47.46173,1.114985 47.461732,1.115472 47.461593,1.115968 47.46138,1.116321 47.461159,1.116928 47.460452,1.117042 47.4604,1.11704 47.460282,1.116933 47.460044,1.116965 47.459839,1.116925 47.459778,1.117368 47.459246,1.117443 47.459017,1.118027 47.458908,1.118495 47.458767,1.11939 47.458349,1.119656 47.458289,1.120199 47.4582,1.120415 47.458111,1.120719 47.457884,1.120875 47.457655,1.120873 47.45734,1.120651 47.456797,1.121194 47.455606,1.121927 47.454859,1.122425 47.454412,1.122927 47.45403,1.123357 47.453679,1.123952 47.453131,1.124907 47.452293,1.125089 47.452157,1.126006 47.451518,1.126377 47.451269,1.126896 47.451069,1.127978 47.450724,1.128017 47.450683,1.128967 47.449939,1.12957 47.449631,1.130637 47.449417,1.131571 47.449112,1.132834 47.44899,1.133466 47.448979,1.13331 47.448543,1.133039 47.448055,1.132811 47.447101,1.13236 47.446467,1.131789 47.445381,1.131124 47.445418,1.130411 47.444737,1.129368 47.443916,1.129203 47.443688,1.128268 47.442735,1.126571 47.441548,1.125731 47.441028,1.124897 47.440526,1.123783 47.439797,1.123311 47.439447,1.122901 47.439026,1.12218 47.438219,1.121841 47.437749,1.121621 47.43737,1.1215 47.436836,1.121392 47.436568,1.121113 47.435443,1.120921 47.435084,1.120785 47.434901,1.119945 47.433588,1.119338 47.432567,1.119076 47.432165,1.11867 47.431598,1.118387 47.431275,1.118186 47.431098,1.117132 47.430316,1.116901 47.430117,1.116291 47.429483,1.115839 47.429127,1.115521 47.428979,1.115232 47.428888,1.114677 47.428629,1.113787 47.428168,1.11365 47.428024,1.112005 47.42916,1.110264 47.429861,1.10822 47.430323,1.107946 47.43041,1.105716 47.431461,1.105221 47.431668,1.105049 47.431665,1.104811 47.43131,1.10449 47.430874,1.104162 47.430485,1.103967 47.430341,1.103558 47.430251,1.103088 47.43024,1.102223 47.430253,1.097606 47.429535,1.095524 47.429232,1.093631 47.428931,1.093506 47.428922,1.090873 47.429263,1.087938 47.429606,1.086315 47.429787,1.085493 47.429886,1.085249 47.429865,1.084904 47.429694,1.084535 47.429396,1.083925 47.428869,1.082447 47.427648,1.082039 47.427881,1.08165 47.428165,1.080755 47.428852,1.080411 47.429103,1.080311 47.429151,1.079566 47.429379,1.078468 47.429727,1.078376 47.429776,1.076567 47.431017,1.075953 47.431466,1.075591 47.431866,1.075091 47.43223,1.074834 47.432567,1.073985 47.433577,1.073837 47.433703,1.073026 47.434645,1.072682 47.435507,1.072429 47.436065,1.072193 47.436546,1.07203 47.436825,1.071874 47.437291,1.071604 47.437838,1.071569 47.437982,1.071088 47.438199,1.070643 47.439024,1.070472 47.439412,1.070304 47.439734,1.069874 47.440495,1.069744 47.440877,1.069643 47.441083,1.069412 47.441448,1.068678 47.442464,1.068271 47.442968,1.067894 47.443303,1.067609 47.443622,1.067599 47.443697,1.067368 47.443992,1.067125 47.444379,1.067073 47.444497,1.066874 47.444554,1.066175 47.445276,1.06593 47.445481,1.065741 47.445559,1.065297 47.445543,1.064968 47.445835,1.064745 47.445961,1.06432 47.446425,1.064119 47.446776,1.064069 47.447061,1.063974 47.447117,1.06396 47.448416,1.06447 47.449312,1.06497 47.449758,1.065375 47.450039,1.065811 47.450291,1.066453 47.450745,1.066905 47.451022,1.067203 47.451177,1.068428 47.451881,1.068973 47.452164,1.069937 47.452832,1.070654 47.453151,1.071011 47.453193,1.071369 47.453047,1.075437 47.455225,1.07856 47.457054,1.080347 47.458204,1.083111 47.460008,1.083558 47.460205,1.085007 47.461078,1.086781 47.461771,1.087111 47.46182)))"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#588
      +name: "STRING"
    }
  ]
]

[
  "sql" => """
    SELECT osm_type, osm_id::text AS osm_id,\n
                    ST_Y(ST_Centroid(geom)) AS lat, ST_X(ST_Centroid(geom)) AS lon,\n
                    tags::jsonb AS tags_json, version, osm_timestamp, changeset, osm_user, uid::bigint AS uid,\n
                    ST_AsGeoJSON(ST_Force2D(geom), 6, 0) AS geom_geojson\n
                FROM osm_object_meta m\n
                WHERE geom IS NOT NULL AND ST_Intersects(m.geom, ST_GeomFromText(?, 4326))\n
                  AND osm_type IN ('way', 'relation')\n
                  AND (tags->'highway') IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
    """
  "params" => [
    1 => "MULTIPOLYGON(((1.087111 47.46182,1.08909 47.462246,1.092332 47.462641,1.092727 47.462735,1.097419 47.463505,1.098936 47.463881,1.101506 47.464276,1.101781 47.464271,1.102317 47.464316,1.103111 47.464445,1.104379 47.464635,1.105454 47.464751,1.106391 47.464808,1.107206 47.464936,1.10826 47.465189,1.110461 47.465728,1.112817 47.466109,1.113381 47.464294,1.113513 47.464126,1.113964 47.463055,1.114071 47.462741,1.113794 47.462605,1.114473 47.46203,1.114903 47.46173,1.114985 47.461732,1.115472 47.461593,1.115968 47.46138,1.116321 47.461159,1.116928 47.460452,1.117042 47.4604,1.11704 47.460282,1.116933 47.460044,1.116965 47.459839,1.116925 47.459778,1.117368 47.459246,1.117443 47.459017,1.118027 47.458908,1.118495 47.458767,1.11939 47.458349,1.119656 47.458289,1.120199 47.4582,1.120415 47.458111,1.120719 47.457884,1.120875 47.457655,1.120873 47.45734,1.120651 47.456797,1.121194 47.455606,1.121927 47.454859,1.122425 47.454412,1.122927 47.45403,1.123357 47.453679,1.123952 47.453131,1.124907 47.452293,1.125089 47.452157,1.126006 47.451518,1.126377 47.451269,1.126896 47.451069,1.127978 47.450724,1.128017 47.450683,1.128967 47.449939,1.12957 47.449631,1.130637 47.449417,1.131571 47.449112,1.132834 47.44899,1.133466 47.448979,1.13331 47.448543,1.133039 47.448055,1.132811 47.447101,1.13236 47.446467,1.131789 47.445381,1.131124 47.445418,1.130411 47.444737,1.129368 47.443916,1.129203 47.443688,1.128268 47.442735,1.126571 47.441548,1.125731 47.441028,1.124897 47.440526,1.123783 47.439797,1.123311 47.439447,1.122901 47.439026,1.12218 47.438219,1.121841 47.437749,1.121621 47.43737,1.1215 47.436836,1.121392 47.436568,1.121113 47.435443,1.120921 47.435084,1.120785 47.434901,1.119945 47.433588,1.119338 47.432567,1.119076 47.432165,1.11867 47.431598,1.118387 47.431275,1.118186 47.431098,1.117132 47.430316,1.116901 47.430117,1.116291 47.429483,1.115839 47.429127,1.115521 47.428979,1.115232 47.428888,1.114677 47.428629,1.113787 47.428168,1.11365 47.428024,1.112005 47.42916,1.110264 47.429861,1.10822 47.430323,1.107946 47.43041,1.105716 47.431461,1.105221 47.431668,1.105049 47.431665,1.104811 47.43131,1.10449 47.430874,1.104162 47.430485,1.103967 47.430341,1.103558 47.430251,1.103088 47.43024,1.102223 47.430253,1.097606 47.429535,1.095524 47.429232,1.093631 47.428931,1.093506 47.428922,1.090873 47.429263,1.087938 47.429606,1.086315 47.429787,1.085493 47.429886,1.085249 47.429865,1.084904 47.429694,1.084535 47.429396,1.083925 47.428869,1.082447 47.427648,1.082039 47.427881,1.08165 47.428165,1.080755 47.428852,1.080411 47.429103,1.080311 47.429151,1.079566 47.429379,1.078468 47.429727,1.078376 47.429776,1.076567 47.431017,1.075953 47.431466,1.075591 47.431866,1.075091 47.43223,1.074834 47.432567,1.073985 47.433577,1.073837 47.433703,1.073026 47.434645,1.072682 47.435507,1.072429 47.436065,1.072193 47.436546,1.07203 47.436825,1.071874 47.437291,1.071604 47.437838,1.071569 47.437982,1.071088 47.438199,1.070643 47.439024,1.070472 47.439412,1.070304 47.439734,1.069874 47.440495,1.069744 47.440877,1.069643 47.441083,1.069412 47.441448,1.068678 47.442464,1.068271 47.442968,1.067894 47.443303,1.067609 47.443622,1.067599 47.443697,1.067368 47.443992,1.067125 47.444379,1.067073 47.444497,1.066874 47.444554,1.066175 47.445276,1.06593 47.445481,1.065741 47.445559,1.065297 47.445543,1.064968 47.445835,1.064745 47.445961,1.06432 47.446425,1.064119 47.446776,1.064069 47.447061,1.063974 47.447117,1.06396 47.448416,1.06447 47.449312,1.06497 47.449758,1.065375 47.450039,1.065811 47.450291,1.066453 47.450745,1.066905 47.451022,1.067203 47.451177,1.068428 47.451881,1.068973 47.452164,1.069937 47.452832,1.070654 47.453151,1.071011 47.453193,1.071369 47.453047,1.075437 47.455225,1.07856 47.457054,1.080347 47.458204,1.083111 47.460008,1.083558 47.460205,1.085007 47.461078,1.086781 47.461771,1.087111 47.46182)))"
    2 => "motorway"
    3 => "trunk"
    4 => "primary"
    5 => "secondary"
    6 => "tertiary"
    7 => "unclassified"
    8 => "residential"
    9 => "living_street"
    10 => "motorway_link"
    11 => "trunk_link"
    12 => "primary_link"
    13 => "secondary_link"
    14 => "tertiary_link"
    15 => "service"
    16 => "road"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#588
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#588}
    3 => Doctrine\DBAL\ParameterType {#588}
    4 => Doctrine\DBAL\ParameterType {#588}
    5 => Doctrine\DBAL\ParameterType {#588}
    6 => Doctrine\DBAL\ParameterType {#588}
    7 => Doctrine\DBAL\ParameterType {#588}
    8 => Doctrine\DBAL\ParameterType {#588}
    9 => Doctrine\DBAL\ParameterType {#588}
    10 => Doctrine\DBAL\ParameterType {#588}
    11 => Doctrine\DBAL\ParameterType {#588}
    12 => Doctrine\DBAL\ParameterType {#588}
    13 => Doctrine\DBAL\ParameterType {#588}
    14 => Doctrine\DBAL\ParameterType {#588}
    15 => Doctrine\DBAL\ParameterType {#588}
    16 => Doctrine\DBAL\ParameterType {#588}
  ]
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Csrf\SameOriginCsrfTokenManager::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\WebpackEncoreBundle\EventListener\ResetAssetsEventListener::resetAssets"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]