Symfony Profiler

[
  "route" => "app_admin_stats"
  "route_parameters" => [
    "_route" => "app_admin_stats"
    "_controller" => "App\Controller\AdminController::stats"
    "insee_code" => "42105"
  ]
  "request_uri" => "https://osm-labo.cipherbliss.com/admin/stats/42105"
  "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 => "42105"
  ]
  "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 => 27657
  ]
  "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":"42105","nom":"42105"}"
    3 => "2026-07-13 02:11:21"
    4 => "https://osm-labo.cipherbliss.com/admin/labourer/42105?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 => "42105"
  ]
  "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 => 27657
  ]
  "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 => "42105"
  ]
  "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 => "42105"
  ]
  "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 => "42105"
  ]
  "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(((4.181985 45.621233,4.180794 45.616369,4.180143 45.614048,4.180151 45.613937,4.177391 45.607977,4.176916 45.606948,4.173256 45.599639,4.172889 45.598909,4.172552 45.598869,4.172192 45.598802,4.172146 45.598841,4.171514 45.598967,4.171161 45.599091,4.170782 45.599289,4.170036 45.599626,4.169769 45.599729,4.167339 45.599676,4.167184 45.599756,4.166762 45.599762,4.166475 45.599667,4.166423 45.600162,4.166458 45.600417,4.165762 45.600659,4.165197 45.600814,4.164234 45.601217,4.164059 45.601238,4.163527 45.601557,4.16308 45.601898,4.162671 45.602285,4.162204 45.602694,4.162019 45.6028,4.161824 45.602857,4.16144 45.60292,4.160677 45.603012,4.159917 45.603116,4.159451 45.603168,4.159121 45.603186,4.157042 45.60317,4.156076 45.603157,4.155531 45.60317,4.155436 45.603248,4.154515 45.60314,4.153291 45.603021,4.152262 45.602961,4.150884 45.602779,4.149777 45.602716,4.14935 45.602701,4.149019 45.602712,4.148198 45.602797,4.148033 45.602803,4.147418 45.602911,4.146795 45.60306,4.146312 45.603153,4.145669 45.603246,4.145413 45.603304,4.144474 45.603474,4.143754 45.603548,4.14331 45.603653,4.142719 45.60383,4.142267 45.603982,4.141987 45.60401,4.140823 45.604071,4.138158 45.604354,4.137261 45.604493,4.136888 45.604565,4.136536 45.60461,4.136319 45.604595,4.137986 45.605796,4.138371 45.606048,4.139578 45.606929,4.140212 45.607411,4.140726 45.607878,4.141563 45.608742,4.141441 45.608731,4.140878 45.608608,4.138758 45.608365,4.138216 45.608322,4.13711 45.608264,4.136143 45.608148,4.135753 45.608145,4.134868 45.60819,4.134234 45.608282,4.133837 45.608378,4.133328 45.608425,4.131164 45.608562,4.130215 45.60861,4.129971 45.608607,4.12843 45.608549,4.124499 45.608376,4.123585 45.608343,4.121795 45.60826,4.121462 45.608254,4.121744 45.608713,4.122323 45.609611,4.122344 45.60973,4.123637 45.611456,4.123832 45.611519,4.124504 45.612535,4.124526 45.612644,4.124815 45.613055,4.125179 45.614242,4.125574 45.615627,4.12565 45.615825,4.125874 45.616553,4.126295 45.617675,4.126371 45.617947,4.126679 45.61883,4.126847 45.619195,4.12694 45.619625,4.126991 45.62012,4.127177 45.620943,4.127242 45.621153,4.127577 45.62202,4.12776 45.62228,4.128054 45.622388,4.129952 45.622941,4.13051 45.62305,4.130816 45.623289,4.132152 45.623478,4.132247 45.623468,4.13279 45.623542,4.134136 45.623695,4.136645 45.624042,4.13777 45.62421,4.138184 45.624242,4.138429 45.62424,4.138506 45.624315,4.139025 45.624343,4.139412 45.624382,4.139914 45.624397,4.140262 45.624443,4.140626 45.624545,4.140824 45.624561,4.140843 45.624618,4.141103 45.624796,4.1436 45.626752,4.143983 45.626953,4.144672 45.627441,4.144873 45.627549,4.145505 45.627698,4.145868 45.627708,4.146205 45.627693,4.147339 45.627311,4.148546 45.627952,4.148874 45.628039,4.149096 45.628029,4.149908 45.627861,4.150402 45.627725,4.150868 45.627643,4.151287 45.627491,4.151348 45.627088,4.151428 45.626784,4.152095 45.626779,4.152564 45.626892,4.152806 45.626899,4.153617 45.626988,4.153822 45.627032,4.154078 45.627196,4.15496 45.627272,4.155846 45.627378,4.156527 45.627435,4.156907 45.627431,4.156981 45.627314,4.157194 45.6271,4.157257 45.626989,4.160184 45.62799,4.165082 45.628523,4.165242 45.628577,4.165376 45.628357,4.165724 45.627932,4.16582 45.627761,4.16816 45.628345,4.171678 45.629237,4.174723 45.630005,4.174576 45.629661,4.174442 45.629187,4.174322 45.628649,4.173884 45.627042,4.173674 45.626203,4.174084 45.626251,4.174074 45.625405,4.174444 45.625382,4.174593 45.623257,4.175932 45.623022,4.176257 45.622076,4.178251 45.621972,4.181985 45.621233)))"
    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(((4.181985 45.621233,4.180794 45.616369,4.180143 45.614048,4.180151 45.613937,4.177391 45.607977,4.176916 45.606948,4.173256 45.599639,4.172889 45.598909,4.172552 45.598869,4.172192 45.598802,4.172146 45.598841,4.171514 45.598967,4.171161 45.599091,4.170782 45.599289,4.170036 45.599626,4.169769 45.599729,4.167339 45.599676,4.167184 45.599756,4.166762 45.599762,4.166475 45.599667,4.166423 45.600162,4.166458 45.600417,4.165762 45.600659,4.165197 45.600814,4.164234 45.601217,4.164059 45.601238,4.163527 45.601557,4.16308 45.601898,4.162671 45.602285,4.162204 45.602694,4.162019 45.6028,4.161824 45.602857,4.16144 45.60292,4.160677 45.603012,4.159917 45.603116,4.159451 45.603168,4.159121 45.603186,4.157042 45.60317,4.156076 45.603157,4.155531 45.60317,4.155436 45.603248,4.154515 45.60314,4.153291 45.603021,4.152262 45.602961,4.150884 45.602779,4.149777 45.602716,4.14935 45.602701,4.149019 45.602712,4.148198 45.602797,4.148033 45.602803,4.147418 45.602911,4.146795 45.60306,4.146312 45.603153,4.145669 45.603246,4.145413 45.603304,4.144474 45.603474,4.143754 45.603548,4.14331 45.603653,4.142719 45.60383,4.142267 45.603982,4.141987 45.60401,4.140823 45.604071,4.138158 45.604354,4.137261 45.604493,4.136888 45.604565,4.136536 45.60461,4.136319 45.604595,4.137986 45.605796,4.138371 45.606048,4.139578 45.606929,4.140212 45.607411,4.140726 45.607878,4.141563 45.608742,4.141441 45.608731,4.140878 45.608608,4.138758 45.608365,4.138216 45.608322,4.13711 45.608264,4.136143 45.608148,4.135753 45.608145,4.134868 45.60819,4.134234 45.608282,4.133837 45.608378,4.133328 45.608425,4.131164 45.608562,4.130215 45.60861,4.129971 45.608607,4.12843 45.608549,4.124499 45.608376,4.123585 45.608343,4.121795 45.60826,4.121462 45.608254,4.121744 45.608713,4.122323 45.609611,4.122344 45.60973,4.123637 45.611456,4.123832 45.611519,4.124504 45.612535,4.124526 45.612644,4.124815 45.613055,4.125179 45.614242,4.125574 45.615627,4.12565 45.615825,4.125874 45.616553,4.126295 45.617675,4.126371 45.617947,4.126679 45.61883,4.126847 45.619195,4.12694 45.619625,4.126991 45.62012,4.127177 45.620943,4.127242 45.621153,4.127577 45.62202,4.12776 45.62228,4.128054 45.622388,4.129952 45.622941,4.13051 45.62305,4.130816 45.623289,4.132152 45.623478,4.132247 45.623468,4.13279 45.623542,4.134136 45.623695,4.136645 45.624042,4.13777 45.62421,4.138184 45.624242,4.138429 45.62424,4.138506 45.624315,4.139025 45.624343,4.139412 45.624382,4.139914 45.624397,4.140262 45.624443,4.140626 45.624545,4.140824 45.624561,4.140843 45.624618,4.141103 45.624796,4.1436 45.626752,4.143983 45.626953,4.144672 45.627441,4.144873 45.627549,4.145505 45.627698,4.145868 45.627708,4.146205 45.627693,4.147339 45.627311,4.148546 45.627952,4.148874 45.628039,4.149096 45.628029,4.149908 45.627861,4.150402 45.627725,4.150868 45.627643,4.151287 45.627491,4.151348 45.627088,4.151428 45.626784,4.152095 45.626779,4.152564 45.626892,4.152806 45.626899,4.153617 45.626988,4.153822 45.627032,4.154078 45.627196,4.15496 45.627272,4.155846 45.627378,4.156527 45.627435,4.156907 45.627431,4.156981 45.627314,4.157194 45.6271,4.157257 45.626989,4.160184 45.62799,4.165082 45.628523,4.165242 45.628577,4.165376 45.628357,4.165724 45.627932,4.16582 45.627761,4.16816 45.628345,4.171678 45.629237,4.174723 45.630005,4.174576 45.629661,4.174442 45.629187,4.174322 45.628649,4.173884 45.627042,4.173674 45.626203,4.174084 45.626251,4.174074 45.625405,4.174444 45.625382,4.174593 45.623257,4.175932 45.623022,4.176257 45.622076,4.178251 45.621972,4.181985 45.621233)))"
  ]
  "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(((4.181985 45.621233,4.180794 45.616369,4.180143 45.614048,4.180151 45.613937,4.177391 45.607977,4.176916 45.606948,4.173256 45.599639,4.172889 45.598909,4.172552 45.598869,4.172192 45.598802,4.172146 45.598841,4.171514 45.598967,4.171161 45.599091,4.170782 45.599289,4.170036 45.599626,4.169769 45.599729,4.167339 45.599676,4.167184 45.599756,4.166762 45.599762,4.166475 45.599667,4.166423 45.600162,4.166458 45.600417,4.165762 45.600659,4.165197 45.600814,4.164234 45.601217,4.164059 45.601238,4.163527 45.601557,4.16308 45.601898,4.162671 45.602285,4.162204 45.602694,4.162019 45.6028,4.161824 45.602857,4.16144 45.60292,4.160677 45.603012,4.159917 45.603116,4.159451 45.603168,4.159121 45.603186,4.157042 45.60317,4.156076 45.603157,4.155531 45.60317,4.155436 45.603248,4.154515 45.60314,4.153291 45.603021,4.152262 45.602961,4.150884 45.602779,4.149777 45.602716,4.14935 45.602701,4.149019 45.602712,4.148198 45.602797,4.148033 45.602803,4.147418 45.602911,4.146795 45.60306,4.146312 45.603153,4.145669 45.603246,4.145413 45.603304,4.144474 45.603474,4.143754 45.603548,4.14331 45.603653,4.142719 45.60383,4.142267 45.603982,4.141987 45.60401,4.140823 45.604071,4.138158 45.604354,4.137261 45.604493,4.136888 45.604565,4.136536 45.60461,4.136319 45.604595,4.137986 45.605796,4.138371 45.606048,4.139578 45.606929,4.140212 45.607411,4.140726 45.607878,4.141563 45.608742,4.141441 45.608731,4.140878 45.608608,4.138758 45.608365,4.138216 45.608322,4.13711 45.608264,4.136143 45.608148,4.135753 45.608145,4.134868 45.60819,4.134234 45.608282,4.133837 45.608378,4.133328 45.608425,4.131164 45.608562,4.130215 45.60861,4.129971 45.608607,4.12843 45.608549,4.124499 45.608376,4.123585 45.608343,4.121795 45.60826,4.121462 45.608254,4.121744 45.608713,4.122323 45.609611,4.122344 45.60973,4.123637 45.611456,4.123832 45.611519,4.124504 45.612535,4.124526 45.612644,4.124815 45.613055,4.125179 45.614242,4.125574 45.615627,4.12565 45.615825,4.125874 45.616553,4.126295 45.617675,4.126371 45.617947,4.126679 45.61883,4.126847 45.619195,4.12694 45.619625,4.126991 45.62012,4.127177 45.620943,4.127242 45.621153,4.127577 45.62202,4.12776 45.62228,4.128054 45.622388,4.129952 45.622941,4.13051 45.62305,4.130816 45.623289,4.132152 45.623478,4.132247 45.623468,4.13279 45.623542,4.134136 45.623695,4.136645 45.624042,4.13777 45.62421,4.138184 45.624242,4.138429 45.62424,4.138506 45.624315,4.139025 45.624343,4.139412 45.624382,4.139914 45.624397,4.140262 45.624443,4.140626 45.624545,4.140824 45.624561,4.140843 45.624618,4.141103 45.624796,4.1436 45.626752,4.143983 45.626953,4.144672 45.627441,4.144873 45.627549,4.145505 45.627698,4.145868 45.627708,4.146205 45.627693,4.147339 45.627311,4.148546 45.627952,4.148874 45.628039,4.149096 45.628029,4.149908 45.627861,4.150402 45.627725,4.150868 45.627643,4.151287 45.627491,4.151348 45.627088,4.151428 45.626784,4.152095 45.626779,4.152564 45.626892,4.152806 45.626899,4.153617 45.626988,4.153822 45.627032,4.154078 45.627196,4.15496 45.627272,4.155846 45.627378,4.156527 45.627435,4.156907 45.627431,4.156981 45.627314,4.157194 45.6271,4.157257 45.626989,4.160184 45.62799,4.165082 45.628523,4.165242 45.628577,4.165376 45.628357,4.165724 45.627932,4.16582 45.627761,4.16816 45.628345,4.171678 45.629237,4.174723 45.630005,4.174576 45.629661,4.174442 45.629187,4.174322 45.628649,4.173884 45.627042,4.173674 45.626203,4.174084 45.626251,4.174074 45.625405,4.174444 45.625382,4.174593 45.623257,4.175932 45.623022,4.176257 45.622076,4.178251 45.621972,4.181985 45.621233)))"
  ]
  "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(((4.181985 45.621233,4.180794 45.616369,4.180143 45.614048,4.180151 45.613937,4.177391 45.607977,4.176916 45.606948,4.173256 45.599639,4.172889 45.598909,4.172552 45.598869,4.172192 45.598802,4.172146 45.598841,4.171514 45.598967,4.171161 45.599091,4.170782 45.599289,4.170036 45.599626,4.169769 45.599729,4.167339 45.599676,4.167184 45.599756,4.166762 45.599762,4.166475 45.599667,4.166423 45.600162,4.166458 45.600417,4.165762 45.600659,4.165197 45.600814,4.164234 45.601217,4.164059 45.601238,4.163527 45.601557,4.16308 45.601898,4.162671 45.602285,4.162204 45.602694,4.162019 45.6028,4.161824 45.602857,4.16144 45.60292,4.160677 45.603012,4.159917 45.603116,4.159451 45.603168,4.159121 45.603186,4.157042 45.60317,4.156076 45.603157,4.155531 45.60317,4.155436 45.603248,4.154515 45.60314,4.153291 45.603021,4.152262 45.602961,4.150884 45.602779,4.149777 45.602716,4.14935 45.602701,4.149019 45.602712,4.148198 45.602797,4.148033 45.602803,4.147418 45.602911,4.146795 45.60306,4.146312 45.603153,4.145669 45.603246,4.145413 45.603304,4.144474 45.603474,4.143754 45.603548,4.14331 45.603653,4.142719 45.60383,4.142267 45.603982,4.141987 45.60401,4.140823 45.604071,4.138158 45.604354,4.137261 45.604493,4.136888 45.604565,4.136536 45.60461,4.136319 45.604595,4.137986 45.605796,4.138371 45.606048,4.139578 45.606929,4.140212 45.607411,4.140726 45.607878,4.141563 45.608742,4.141441 45.608731,4.140878 45.608608,4.138758 45.608365,4.138216 45.608322,4.13711 45.608264,4.136143 45.608148,4.135753 45.608145,4.134868 45.60819,4.134234 45.608282,4.133837 45.608378,4.133328 45.608425,4.131164 45.608562,4.130215 45.60861,4.129971 45.608607,4.12843 45.608549,4.124499 45.608376,4.123585 45.608343,4.121795 45.60826,4.121462 45.608254,4.121744 45.608713,4.122323 45.609611,4.122344 45.60973,4.123637 45.611456,4.123832 45.611519,4.124504 45.612535,4.124526 45.612644,4.124815 45.613055,4.125179 45.614242,4.125574 45.615627,4.12565 45.615825,4.125874 45.616553,4.126295 45.617675,4.126371 45.617947,4.126679 45.61883,4.126847 45.619195,4.12694 45.619625,4.126991 45.62012,4.127177 45.620943,4.127242 45.621153,4.127577 45.62202,4.12776 45.62228,4.128054 45.622388,4.129952 45.622941,4.13051 45.62305,4.130816 45.623289,4.132152 45.623478,4.132247 45.623468,4.13279 45.623542,4.134136 45.623695,4.136645 45.624042,4.13777 45.62421,4.138184 45.624242,4.138429 45.62424,4.138506 45.624315,4.139025 45.624343,4.139412 45.624382,4.139914 45.624397,4.140262 45.624443,4.140626 45.624545,4.140824 45.624561,4.140843 45.624618,4.141103 45.624796,4.1436 45.626752,4.143983 45.626953,4.144672 45.627441,4.144873 45.627549,4.145505 45.627698,4.145868 45.627708,4.146205 45.627693,4.147339 45.627311,4.148546 45.627952,4.148874 45.628039,4.149096 45.628029,4.149908 45.627861,4.150402 45.627725,4.150868 45.627643,4.151287 45.627491,4.151348 45.627088,4.151428 45.626784,4.152095 45.626779,4.152564 45.626892,4.152806 45.626899,4.153617 45.626988,4.153822 45.627032,4.154078 45.627196,4.15496 45.627272,4.155846 45.627378,4.156527 45.627435,4.156907 45.627431,4.156981 45.627314,4.157194 45.6271,4.157257 45.626989,4.160184 45.62799,4.165082 45.628523,4.165242 45.628577,4.165376 45.628357,4.165724 45.627932,4.16582 45.627761,4.16816 45.628345,4.171678 45.629237,4.174723 45.630005,4.174576 45.629661,4.174442 45.629187,4.174322 45.628649,4.173884 45.627042,4.173674 45.626203,4.174084 45.626251,4.174074 45.625405,4.174444 45.625382,4.174593 45.623257,4.175932 45.623022,4.176257 45.622076,4.178251 45.621972,4.181985 45.621233)))"
  ]
  "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 => 27657
  ]
  "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 => 27657
  ]
  "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(((4.181985 45.621233,4.180794 45.616369,4.180143 45.614048,4.180151 45.613937,4.177391 45.607977,4.176916 45.606948,4.173256 45.599639,4.172889 45.598909,4.172552 45.598869,4.172192 45.598802,4.172146 45.598841,4.171514 45.598967,4.171161 45.599091,4.170782 45.599289,4.170036 45.599626,4.169769 45.599729,4.167339 45.599676,4.167184 45.599756,4.166762 45.599762,4.166475 45.599667,4.166423 45.600162,4.166458 45.600417,4.165762 45.600659,4.165197 45.600814,4.164234 45.601217,4.164059 45.601238,4.163527 45.601557,4.16308 45.601898,4.162671 45.602285,4.162204 45.602694,4.162019 45.6028,4.161824 45.602857,4.16144 45.60292,4.160677 45.603012,4.159917 45.603116,4.159451 45.603168,4.159121 45.603186,4.157042 45.60317,4.156076 45.603157,4.155531 45.60317,4.155436 45.603248,4.154515 45.60314,4.153291 45.603021,4.152262 45.602961,4.150884 45.602779,4.149777 45.602716,4.14935 45.602701,4.149019 45.602712,4.148198 45.602797,4.148033 45.602803,4.147418 45.602911,4.146795 45.60306,4.146312 45.603153,4.145669 45.603246,4.145413 45.603304,4.144474 45.603474,4.143754 45.603548,4.14331 45.603653,4.142719 45.60383,4.142267 45.603982,4.141987 45.60401,4.140823 45.604071,4.138158 45.604354,4.137261 45.604493,4.136888 45.604565,4.136536 45.60461,4.136319 45.604595,4.137986 45.605796,4.138371 45.606048,4.139578 45.606929,4.140212 45.607411,4.140726 45.607878,4.141563 45.608742,4.141441 45.608731,4.140878 45.608608,4.138758 45.608365,4.138216 45.608322,4.13711 45.608264,4.136143 45.608148,4.135753 45.608145,4.134868 45.60819,4.134234 45.608282,4.133837 45.608378,4.133328 45.608425,4.131164 45.608562,4.130215 45.60861,4.129971 45.608607,4.12843 45.608549,4.124499 45.608376,4.123585 45.608343,4.121795 45.60826,4.121462 45.608254,4.121744 45.608713,4.122323 45.609611,4.122344 45.60973,4.123637 45.611456,4.123832 45.611519,4.124504 45.612535,4.124526 45.612644,4.124815 45.613055,4.125179 45.614242,4.125574 45.615627,4.12565 45.615825,4.125874 45.616553,4.126295 45.617675,4.126371 45.617947,4.126679 45.61883,4.126847 45.619195,4.12694 45.619625,4.126991 45.62012,4.127177 45.620943,4.127242 45.621153,4.127577 45.62202,4.12776 45.62228,4.128054 45.622388,4.129952 45.622941,4.13051 45.62305,4.130816 45.623289,4.132152 45.623478,4.132247 45.623468,4.13279 45.623542,4.134136 45.623695,4.136645 45.624042,4.13777 45.62421,4.138184 45.624242,4.138429 45.62424,4.138506 45.624315,4.139025 45.624343,4.139412 45.624382,4.139914 45.624397,4.140262 45.624443,4.140626 45.624545,4.140824 45.624561,4.140843 45.624618,4.141103 45.624796,4.1436 45.626752,4.143983 45.626953,4.144672 45.627441,4.144873 45.627549,4.145505 45.627698,4.145868 45.627708,4.146205 45.627693,4.147339 45.627311,4.148546 45.627952,4.148874 45.628039,4.149096 45.628029,4.149908 45.627861,4.150402 45.627725,4.150868 45.627643,4.151287 45.627491,4.151348 45.627088,4.151428 45.626784,4.152095 45.626779,4.152564 45.626892,4.152806 45.626899,4.153617 45.626988,4.153822 45.627032,4.154078 45.627196,4.15496 45.627272,4.155846 45.627378,4.156527 45.627435,4.156907 45.627431,4.156981 45.627314,4.157194 45.6271,4.157257 45.626989,4.160184 45.62799,4.165082 45.628523,4.165242 45.628577,4.165376 45.628357,4.165724 45.627932,4.16582 45.627761,4.16816 45.628345,4.171678 45.629237,4.174723 45.630005,4.174576 45.629661,4.174442 45.629187,4.174322 45.628649,4.173884 45.627042,4.173674 45.626203,4.174084 45.626251,4.174074 45.625405,4.174444 45.625382,4.174593 45.623257,4.175932 45.623022,4.176257 45.622076,4.178251 45.621972,4.181985 45.621233)))"
    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(((4.181985 45.621233,4.180794 45.616369,4.180143 45.614048,4.180151 45.613937,4.177391 45.607977,4.176916 45.606948,4.173256 45.599639,4.172889 45.598909,4.172552 45.598869,4.172192 45.598802,4.172146 45.598841,4.171514 45.598967,4.171161 45.599091,4.170782 45.599289,4.170036 45.599626,4.169769 45.599729,4.167339 45.599676,4.167184 45.599756,4.166762 45.599762,4.166475 45.599667,4.166423 45.600162,4.166458 45.600417,4.165762 45.600659,4.165197 45.600814,4.164234 45.601217,4.164059 45.601238,4.163527 45.601557,4.16308 45.601898,4.162671 45.602285,4.162204 45.602694,4.162019 45.6028,4.161824 45.602857,4.16144 45.60292,4.160677 45.603012,4.159917 45.603116,4.159451 45.603168,4.159121 45.603186,4.157042 45.60317,4.156076 45.603157,4.155531 45.60317,4.155436 45.603248,4.154515 45.60314,4.153291 45.603021,4.152262 45.602961,4.150884 45.602779,4.149777 45.602716,4.14935 45.602701,4.149019 45.602712,4.148198 45.602797,4.148033 45.602803,4.147418 45.602911,4.146795 45.60306,4.146312 45.603153,4.145669 45.603246,4.145413 45.603304,4.144474 45.603474,4.143754 45.603548,4.14331 45.603653,4.142719 45.60383,4.142267 45.603982,4.141987 45.60401,4.140823 45.604071,4.138158 45.604354,4.137261 45.604493,4.136888 45.604565,4.136536 45.60461,4.136319 45.604595,4.137986 45.605796,4.138371 45.606048,4.139578 45.606929,4.140212 45.607411,4.140726 45.607878,4.141563 45.608742,4.141441 45.608731,4.140878 45.608608,4.138758 45.608365,4.138216 45.608322,4.13711 45.608264,4.136143 45.608148,4.135753 45.608145,4.134868 45.60819,4.134234 45.608282,4.133837 45.608378,4.133328 45.608425,4.131164 45.608562,4.130215 45.60861,4.129971 45.608607,4.12843 45.608549,4.124499 45.608376,4.123585 45.608343,4.121795 45.60826,4.121462 45.608254,4.121744 45.608713,4.122323 45.609611,4.122344 45.60973,4.123637 45.611456,4.123832 45.611519,4.124504 45.612535,4.124526 45.612644,4.124815 45.613055,4.125179 45.614242,4.125574 45.615627,4.12565 45.615825,4.125874 45.616553,4.126295 45.617675,4.126371 45.617947,4.126679 45.61883,4.126847 45.619195,4.12694 45.619625,4.126991 45.62012,4.127177 45.620943,4.127242 45.621153,4.127577 45.62202,4.12776 45.62228,4.128054 45.622388,4.129952 45.622941,4.13051 45.62305,4.130816 45.623289,4.132152 45.623478,4.132247 45.623468,4.13279 45.623542,4.134136 45.623695,4.136645 45.624042,4.13777 45.62421,4.138184 45.624242,4.138429 45.62424,4.138506 45.624315,4.139025 45.624343,4.139412 45.624382,4.139914 45.624397,4.140262 45.624443,4.140626 45.624545,4.140824 45.624561,4.140843 45.624618,4.141103 45.624796,4.1436 45.626752,4.143983 45.626953,4.144672 45.627441,4.144873 45.627549,4.145505 45.627698,4.145868 45.627708,4.146205 45.627693,4.147339 45.627311,4.148546 45.627952,4.148874 45.628039,4.149096 45.628029,4.149908 45.627861,4.150402 45.627725,4.150868 45.627643,4.151287 45.627491,4.151348 45.627088,4.151428 45.626784,4.152095 45.626779,4.152564 45.626892,4.152806 45.626899,4.153617 45.626988,4.153822 45.627032,4.154078 45.627196,4.15496 45.627272,4.155846 45.627378,4.156527 45.627435,4.156907 45.627431,4.156981 45.627314,4.157194 45.6271,4.157257 45.626989,4.160184 45.62799,4.165082 45.628523,4.165242 45.628577,4.165376 45.628357,4.165724 45.627932,4.16582 45.627761,4.16816 45.628345,4.171678 45.629237,4.174723 45.630005,4.174576 45.629661,4.174442 45.629187,4.174322 45.628649,4.173884 45.627042,4.173674 45.626203,4.174084 45.626251,4.174074 45.625405,4.174444 45.625382,4.174593 45.623257,4.175932 45.623022,4.176257 45.622076,4.178251 45.621972,4.181985 45.621233)))"
  ]
  "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(((4.181985 45.621233,4.180794 45.616369,4.180143 45.614048,4.180151 45.613937,4.177391 45.607977,4.176916 45.606948,4.173256 45.599639,4.172889 45.598909,4.172552 45.598869,4.172192 45.598802,4.172146 45.598841,4.171514 45.598967,4.171161 45.599091,4.170782 45.599289,4.170036 45.599626,4.169769 45.599729,4.167339 45.599676,4.167184 45.599756,4.166762 45.599762,4.166475 45.599667,4.166423 45.600162,4.166458 45.600417,4.165762 45.600659,4.165197 45.600814,4.164234 45.601217,4.164059 45.601238,4.163527 45.601557,4.16308 45.601898,4.162671 45.602285,4.162204 45.602694,4.162019 45.6028,4.161824 45.602857,4.16144 45.60292,4.160677 45.603012,4.159917 45.603116,4.159451 45.603168,4.159121 45.603186,4.157042 45.60317,4.156076 45.603157,4.155531 45.60317,4.155436 45.603248,4.154515 45.60314,4.153291 45.603021,4.152262 45.602961,4.150884 45.602779,4.149777 45.602716,4.14935 45.602701,4.149019 45.602712,4.148198 45.602797,4.148033 45.602803,4.147418 45.602911,4.146795 45.60306,4.146312 45.603153,4.145669 45.603246,4.145413 45.603304,4.144474 45.603474,4.143754 45.603548,4.14331 45.603653,4.142719 45.60383,4.142267 45.603982,4.141987 45.60401,4.140823 45.604071,4.138158 45.604354,4.137261 45.604493,4.136888 45.604565,4.136536 45.60461,4.136319 45.604595,4.137986 45.605796,4.138371 45.606048,4.139578 45.606929,4.140212 45.607411,4.140726 45.607878,4.141563 45.608742,4.141441 45.608731,4.140878 45.608608,4.138758 45.608365,4.138216 45.608322,4.13711 45.608264,4.136143 45.608148,4.135753 45.608145,4.134868 45.60819,4.134234 45.608282,4.133837 45.608378,4.133328 45.608425,4.131164 45.608562,4.130215 45.60861,4.129971 45.608607,4.12843 45.608549,4.124499 45.608376,4.123585 45.608343,4.121795 45.60826,4.121462 45.608254,4.121744 45.608713,4.122323 45.609611,4.122344 45.60973,4.123637 45.611456,4.123832 45.611519,4.124504 45.612535,4.124526 45.612644,4.124815 45.613055,4.125179 45.614242,4.125574 45.615627,4.12565 45.615825,4.125874 45.616553,4.126295 45.617675,4.126371 45.617947,4.126679 45.61883,4.126847 45.619195,4.12694 45.619625,4.126991 45.62012,4.127177 45.620943,4.127242 45.621153,4.127577 45.62202,4.12776 45.62228,4.128054 45.622388,4.129952 45.622941,4.13051 45.62305,4.130816 45.623289,4.132152 45.623478,4.132247 45.623468,4.13279 45.623542,4.134136 45.623695,4.136645 45.624042,4.13777 45.62421,4.138184 45.624242,4.138429 45.62424,4.138506 45.624315,4.139025 45.624343,4.139412 45.624382,4.139914 45.624397,4.140262 45.624443,4.140626 45.624545,4.140824 45.624561,4.140843 45.624618,4.141103 45.624796,4.1436 45.626752,4.143983 45.626953,4.144672 45.627441,4.144873 45.627549,4.145505 45.627698,4.145868 45.627708,4.146205 45.627693,4.147339 45.627311,4.148546 45.627952,4.148874 45.628039,4.149096 45.628029,4.149908 45.627861,4.150402 45.627725,4.150868 45.627643,4.151287 45.627491,4.151348 45.627088,4.151428 45.626784,4.152095 45.626779,4.152564 45.626892,4.152806 45.626899,4.153617 45.626988,4.153822 45.627032,4.154078 45.627196,4.15496 45.627272,4.155846 45.627378,4.156527 45.627435,4.156907 45.627431,4.156981 45.627314,4.157194 45.6271,4.157257 45.626989,4.160184 45.62799,4.165082 45.628523,4.165242 45.628577,4.165376 45.628357,4.165724 45.627932,4.16582 45.627761,4.16816 45.628345,4.171678 45.629237,4.174723 45.630005,4.174576 45.629661,4.174442 45.629187,4.174322 45.628649,4.173884 45.627042,4.173674 45.626203,4.174084 45.626251,4.174074 45.625405,4.174444 45.625382,4.174593 45.623257,4.175932 45.623022,4.176257 45.622076,4.178251 45.621972,4.181985 45.621233)))"
  ]
  "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(((4.181985 45.621233,4.180794 45.616369,4.180143 45.614048,4.180151 45.613937,4.177391 45.607977,4.176916 45.606948,4.173256 45.599639,4.172889 45.598909,4.172552 45.598869,4.172192 45.598802,4.172146 45.598841,4.171514 45.598967,4.171161 45.599091,4.170782 45.599289,4.170036 45.599626,4.169769 45.599729,4.167339 45.599676,4.167184 45.599756,4.166762 45.599762,4.166475 45.599667,4.166423 45.600162,4.166458 45.600417,4.165762 45.600659,4.165197 45.600814,4.164234 45.601217,4.164059 45.601238,4.163527 45.601557,4.16308 45.601898,4.162671 45.602285,4.162204 45.602694,4.162019 45.6028,4.161824 45.602857,4.16144 45.60292,4.160677 45.603012,4.159917 45.603116,4.159451 45.603168,4.159121 45.603186,4.157042 45.60317,4.156076 45.603157,4.155531 45.60317,4.155436 45.603248,4.154515 45.60314,4.153291 45.603021,4.152262 45.602961,4.150884 45.602779,4.149777 45.602716,4.14935 45.602701,4.149019 45.602712,4.148198 45.602797,4.148033 45.602803,4.147418 45.602911,4.146795 45.60306,4.146312 45.603153,4.145669 45.603246,4.145413 45.603304,4.144474 45.603474,4.143754 45.603548,4.14331 45.603653,4.142719 45.60383,4.142267 45.603982,4.141987 45.60401,4.140823 45.604071,4.138158 45.604354,4.137261 45.604493,4.136888 45.604565,4.136536 45.60461,4.136319 45.604595,4.137986 45.605796,4.138371 45.606048,4.139578 45.606929,4.140212 45.607411,4.140726 45.607878,4.141563 45.608742,4.141441 45.608731,4.140878 45.608608,4.138758 45.608365,4.138216 45.608322,4.13711 45.608264,4.136143 45.608148,4.135753 45.608145,4.134868 45.60819,4.134234 45.608282,4.133837 45.608378,4.133328 45.608425,4.131164 45.608562,4.130215 45.60861,4.129971 45.608607,4.12843 45.608549,4.124499 45.608376,4.123585 45.608343,4.121795 45.60826,4.121462 45.608254,4.121744 45.608713,4.122323 45.609611,4.122344 45.60973,4.123637 45.611456,4.123832 45.611519,4.124504 45.612535,4.124526 45.612644,4.124815 45.613055,4.125179 45.614242,4.125574 45.615627,4.12565 45.615825,4.125874 45.616553,4.126295 45.617675,4.126371 45.617947,4.126679 45.61883,4.126847 45.619195,4.12694 45.619625,4.126991 45.62012,4.127177 45.620943,4.127242 45.621153,4.127577 45.62202,4.12776 45.62228,4.128054 45.622388,4.129952 45.622941,4.13051 45.62305,4.130816 45.623289,4.132152 45.623478,4.132247 45.623468,4.13279 45.623542,4.134136 45.623695,4.136645 45.624042,4.13777 45.62421,4.138184 45.624242,4.138429 45.62424,4.138506 45.624315,4.139025 45.624343,4.139412 45.624382,4.139914 45.624397,4.140262 45.624443,4.140626 45.624545,4.140824 45.624561,4.140843 45.624618,4.141103 45.624796,4.1436 45.626752,4.143983 45.626953,4.144672 45.627441,4.144873 45.627549,4.145505 45.627698,4.145868 45.627708,4.146205 45.627693,4.147339 45.627311,4.148546 45.627952,4.148874 45.628039,4.149096 45.628029,4.149908 45.627861,4.150402 45.627725,4.150868 45.627643,4.151287 45.627491,4.151348 45.627088,4.151428 45.626784,4.152095 45.626779,4.152564 45.626892,4.152806 45.626899,4.153617 45.626988,4.153822 45.627032,4.154078 45.627196,4.15496 45.627272,4.155846 45.627378,4.156527 45.627435,4.156907 45.627431,4.156981 45.627314,4.157194 45.6271,4.157257 45.626989,4.160184 45.62799,4.165082 45.628523,4.165242 45.628577,4.165376 45.628357,4.165724 45.627932,4.16582 45.627761,4.16816 45.628345,4.171678 45.629237,4.174723 45.630005,4.174576 45.629661,4.174442 45.629187,4.174322 45.628649,4.173884 45.627042,4.173674 45.626203,4.174084 45.626251,4.174074 45.625405,4.174444 45.625382,4.174593 45.623257,4.175932 45.623022,4.176257 45.622076,4.178251 45.621972,4.181985 45.621233)))"
    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"
]