Symfony Profiler

[
  "route" => "app_admin_stats"
  "route_parameters" => [
    "_route" => "app_admin_stats"
    "_controller" => "App\Controller\AdminController::stats"
    "insee_code" => "08122"
  ]
  "request_uri" => "https://osm-labo.cipherbliss.com/admin/stats/08122"
  "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 => "08122"
  ]
  "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 => 27309
  ]
  "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":"08122","nom":"08122"}"
    3 => "2026-07-13 00:48:29"
    4 => null
    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 => "08122"
  ]
  "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 => 27309
  ]
  "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 => "08122"
  ]
  "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 => "08122"
  ]
  "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 => "08122"
  ]
  "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.795128 50.128507,4.795281 50.128504,4.796426 50.126505,4.79656 50.126368,4.797049 50.126248,4.796882 50.126007,4.796531 50.125363,4.796266 50.124711,4.796069 50.123956,4.795965 50.123505,4.795832 50.122535,4.796003 50.121322,4.796135 50.120614,4.796432 50.119844,4.797192 50.118368,4.798006 50.116934,4.79847 50.116073,4.79926 50.116147,4.800573 50.115842,4.802045 50.11516,4.802282 50.115043,4.80251 50.114983,4.802757 50.114846,4.803106 50.114761,4.803648 50.114478,4.806971 50.113594,4.808069 50.112899,4.80885 50.112621,4.809131 50.112559,4.808683 50.112213,4.807972 50.111166,4.807733 50.110929,4.808901 50.110737,4.80915 50.110657,4.809059 50.110371,4.808325 50.108753,4.80839 50.108662,4.808663 50.108521,4.809273 50.108149,4.809574 50.107156,4.809968 50.106654,4.81041 50.10626,4.811189 50.10591,4.81117 50.105543,4.811788 50.105306,4.812117 50.104895,4.812264 50.104526,4.812574 50.104133,4.813173 50.104058,4.813674 50.103921,4.813996 50.103855,4.814363 50.103727,4.814575 50.103419,4.814943 50.102999,4.815379 50.102393,4.815588 50.101673,4.815307 50.101633,4.815301 50.101498,4.81555 50.100865,4.81618 50.100923,4.816391 50.100915,4.818106 50.100955,4.818961 50.099566,4.819141 50.099139,4.819314 50.097906,4.81909 50.097331,4.819124 50.096831,4.818903 50.095264,4.818939 50.093414,4.818103 50.093454,4.817335 50.093233,4.815542 50.092646,4.81523 50.09259,4.815814 50.092319,4.815815 50.090918,4.81606 50.090153,4.816441 50.089737,4.816789 50.08973,4.817207 50.089431,4.818384 50.088082,4.819307 50.088144,4.822182 50.088399,4.822031 50.088178,4.821233 50.087566,4.819073 50.086487,4.818787 50.086358,4.817917 50.085703,4.817257 50.084848,4.816889 50.083646,4.816153 50.082488,4.815355 50.081245,4.815069 50.080542,4.814533 50.080275,4.813794 50.080173,4.813783 50.07994,4.814111 50.079529,4.815126 50.07928,4.815203 50.078854,4.815111 50.078607,4.816688 50.078737,4.817174 50.078739,4.817352 50.078286,4.816601 50.07803,4.816081 50.077809,4.815635 50.077596,4.815233 50.077363,4.814876 50.07709,4.814591 50.076826,4.81444 50.07651,4.814402 50.076017,4.814723 50.075674,4.815192 50.075114,4.815523 50.074818,4.816019 50.074247,4.816492 50.073764,4.816704 50.073527,4.816713 50.07334,4.816624 50.073071,4.816509 50.0729,4.816327 50.072237,4.816205 50.071863,4.815626 50.071097,4.81546 50.070781,4.815447 50.070502,4.815538 50.07023,4.815657 50.06957,4.815402 50.068957,4.815372 50.068678,4.815561 50.068249,4.815941 50.06771,4.816187 50.067521,4.816565 50.067281,4.817127 50.067115,4.817433 50.066945,4.817749 50.066639,4.818232 50.066368,4.818685 50.066209,4.819664 50.066063,4.819262 50.066085,4.819152 50.066036,4.819884 50.065614,4.820344 50.065592,4.820931 50.065229,4.821855 50.064618,4.822125 50.064213,4.821903 50.063995,4.821646 50.063833,4.821221 50.063661,4.821171 50.063429,4.821264 50.063302,4.821256 50.063192,4.8211 50.06294,4.820912 50.06277,4.820629 50.062578,4.820234 50.062363,4.82013 50.062356,4.819729 50.062153,4.819635 50.061896,4.819466 50.061829,4.819143 50.06161,4.819084 50.061514,4.81905 50.061234,4.81928 50.060921,4.81954 50.060682,4.819675 50.060625,4.819255 50.060403,4.818991 50.06039,4.818748 50.060463,4.818214 50.060707,4.817669 50.060749,4.816946 50.060746,4.816598 50.060728,4.816 50.060666,4.815305 50.060649,4.815029 50.060659,4.814128 50.060645,4.812635 50.060684,4.811901 50.060599,4.811513 50.060525,4.810918 50.060346,4.810424 50.059971,4.810068 50.059637,4.80929 50.058958,4.808441 50.058566,4.807624 50.058236,4.806707 50.058015,4.806034 50.057889,4.805308 50.057794,4.804902 50.057775,4.80412 50.057564,4.803689 50.057428,4.803063 50.057148,4.802176 50.05663,4.801534 50.056368,4.801069 50.056197,4.800327 50.056835,4.79933 50.057067,4.799143 50.057214,4.798695 50.057323,4.798364 50.057546,4.798061 50.058012,4.797036 50.058437,4.795757 50.058535,4.79445 50.058748,4.793932 50.058736,4.793863 50.058946,4.793984 50.059461,4.794038 50.059614,4.794197 50.059893,4.794458 50.060171,4.795037 50.060898,4.795137 50.061093,4.795758 50.061799,4.795804 50.062555,4.795403 50.063486,4.795301 50.063751,4.795013 50.06423,4.79452 50.064839,4.793035 50.066529,4.792389 50.067619,4.792259 50.067801,4.791458 50.069712,4.791138 50.070303,4.790963 50.07098,4.790102 50.073377,4.789895 50.074872,4.789593 50.075698,4.789444 50.0764,4.789188 50.077116,4.78917 50.077353,4.788988 50.077745,4.787434 50.080832,4.786433 50.082393,4.786141 50.083198,4.786366 50.084627,4.786715 50.085146,4.786436 50.085259,4.785323 50.085828,4.783791 50.086849,4.78294 50.087704,4.781951 50.089119,4.781631 50.09002,4.781423 50.090917,4.781294 50.092012,4.781327 50.092909,4.781515 50.093712,4.782269 50.094436,4.783345 50.095085,4.784853 50.095695,4.78608 50.09647,4.786821 50.09734,4.78757 50.098422,4.788287 50.099251,4.789344 50.100251,4.7903 50.100858,4.790963 50.101334,4.79112 50.101577,4.791295 50.102308,4.791382 50.103632,4.791223 50.104939,4.792142 50.105317,4.793102 50.106419,4.793192 50.106822,4.793068 50.107139,4.792242 50.107494,4.792309 50.107637,4.7923 50.107954,4.792085 50.108319,4.791797 50.10866,4.791234 50.109177,4.790411 50.109686,4.789205 50.111167,4.786813 50.113407,4.785342 50.11441,4.785901 50.114854,4.785347 50.115178,4.78538 50.11537,4.785175 50.115775,4.784927 50.116344,4.784994 50.116677,4.783058 50.117468,4.782114 50.118366,4.780504 50.11965,4.7795 50.120574,4.779122 50.120455,4.77873 50.1203,4.778229 50.120191,4.777644 50.120121,4.77737 50.12006,4.777232 50.120088,4.777105 50.120265,4.777943 50.1207,4.778843 50.121062,4.780257 50.12162,4.782584 50.122473,4.783966 50.123148,4.785462 50.123942,4.786352 50.124341,4.78687 50.124639,4.787542 50.124906,4.78792 50.125098,4.790681 50.126552,4.791535 50.126833,4.793195 50.127558,4.795128 50.128507)))"
    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.795128 50.128507,4.795281 50.128504,4.796426 50.126505,4.79656 50.126368,4.797049 50.126248,4.796882 50.126007,4.796531 50.125363,4.796266 50.124711,4.796069 50.123956,4.795965 50.123505,4.795832 50.122535,4.796003 50.121322,4.796135 50.120614,4.796432 50.119844,4.797192 50.118368,4.798006 50.116934,4.79847 50.116073,4.79926 50.116147,4.800573 50.115842,4.802045 50.11516,4.802282 50.115043,4.80251 50.114983,4.802757 50.114846,4.803106 50.114761,4.803648 50.114478,4.806971 50.113594,4.808069 50.112899,4.80885 50.112621,4.809131 50.112559,4.808683 50.112213,4.807972 50.111166,4.807733 50.110929,4.808901 50.110737,4.80915 50.110657,4.809059 50.110371,4.808325 50.108753,4.80839 50.108662,4.808663 50.108521,4.809273 50.108149,4.809574 50.107156,4.809968 50.106654,4.81041 50.10626,4.811189 50.10591,4.81117 50.105543,4.811788 50.105306,4.812117 50.104895,4.812264 50.104526,4.812574 50.104133,4.813173 50.104058,4.813674 50.103921,4.813996 50.103855,4.814363 50.103727,4.814575 50.103419,4.814943 50.102999,4.815379 50.102393,4.815588 50.101673,4.815307 50.101633,4.815301 50.101498,4.81555 50.100865,4.81618 50.100923,4.816391 50.100915,4.818106 50.100955,4.818961 50.099566,4.819141 50.099139,4.819314 50.097906,4.81909 50.097331,4.819124 50.096831,4.818903 50.095264,4.818939 50.093414,4.818103 50.093454,4.817335 50.093233,4.815542 50.092646,4.81523 50.09259,4.815814 50.092319,4.815815 50.090918,4.81606 50.090153,4.816441 50.089737,4.816789 50.08973,4.817207 50.089431,4.818384 50.088082,4.819307 50.088144,4.822182 50.088399,4.822031 50.088178,4.821233 50.087566,4.819073 50.086487,4.818787 50.086358,4.817917 50.085703,4.817257 50.084848,4.816889 50.083646,4.816153 50.082488,4.815355 50.081245,4.815069 50.080542,4.814533 50.080275,4.813794 50.080173,4.813783 50.07994,4.814111 50.079529,4.815126 50.07928,4.815203 50.078854,4.815111 50.078607,4.816688 50.078737,4.817174 50.078739,4.817352 50.078286,4.816601 50.07803,4.816081 50.077809,4.815635 50.077596,4.815233 50.077363,4.814876 50.07709,4.814591 50.076826,4.81444 50.07651,4.814402 50.076017,4.814723 50.075674,4.815192 50.075114,4.815523 50.074818,4.816019 50.074247,4.816492 50.073764,4.816704 50.073527,4.816713 50.07334,4.816624 50.073071,4.816509 50.0729,4.816327 50.072237,4.816205 50.071863,4.815626 50.071097,4.81546 50.070781,4.815447 50.070502,4.815538 50.07023,4.815657 50.06957,4.815402 50.068957,4.815372 50.068678,4.815561 50.068249,4.815941 50.06771,4.816187 50.067521,4.816565 50.067281,4.817127 50.067115,4.817433 50.066945,4.817749 50.066639,4.818232 50.066368,4.818685 50.066209,4.819664 50.066063,4.819262 50.066085,4.819152 50.066036,4.819884 50.065614,4.820344 50.065592,4.820931 50.065229,4.821855 50.064618,4.822125 50.064213,4.821903 50.063995,4.821646 50.063833,4.821221 50.063661,4.821171 50.063429,4.821264 50.063302,4.821256 50.063192,4.8211 50.06294,4.820912 50.06277,4.820629 50.062578,4.820234 50.062363,4.82013 50.062356,4.819729 50.062153,4.819635 50.061896,4.819466 50.061829,4.819143 50.06161,4.819084 50.061514,4.81905 50.061234,4.81928 50.060921,4.81954 50.060682,4.819675 50.060625,4.819255 50.060403,4.818991 50.06039,4.818748 50.060463,4.818214 50.060707,4.817669 50.060749,4.816946 50.060746,4.816598 50.060728,4.816 50.060666,4.815305 50.060649,4.815029 50.060659,4.814128 50.060645,4.812635 50.060684,4.811901 50.060599,4.811513 50.060525,4.810918 50.060346,4.810424 50.059971,4.810068 50.059637,4.80929 50.058958,4.808441 50.058566,4.807624 50.058236,4.806707 50.058015,4.806034 50.057889,4.805308 50.057794,4.804902 50.057775,4.80412 50.057564,4.803689 50.057428,4.803063 50.057148,4.802176 50.05663,4.801534 50.056368,4.801069 50.056197,4.800327 50.056835,4.79933 50.057067,4.799143 50.057214,4.798695 50.057323,4.798364 50.057546,4.798061 50.058012,4.797036 50.058437,4.795757 50.058535,4.79445 50.058748,4.793932 50.058736,4.793863 50.058946,4.793984 50.059461,4.794038 50.059614,4.794197 50.059893,4.794458 50.060171,4.795037 50.060898,4.795137 50.061093,4.795758 50.061799,4.795804 50.062555,4.795403 50.063486,4.795301 50.063751,4.795013 50.06423,4.79452 50.064839,4.793035 50.066529,4.792389 50.067619,4.792259 50.067801,4.791458 50.069712,4.791138 50.070303,4.790963 50.07098,4.790102 50.073377,4.789895 50.074872,4.789593 50.075698,4.789444 50.0764,4.789188 50.077116,4.78917 50.077353,4.788988 50.077745,4.787434 50.080832,4.786433 50.082393,4.786141 50.083198,4.786366 50.084627,4.786715 50.085146,4.786436 50.085259,4.785323 50.085828,4.783791 50.086849,4.78294 50.087704,4.781951 50.089119,4.781631 50.09002,4.781423 50.090917,4.781294 50.092012,4.781327 50.092909,4.781515 50.093712,4.782269 50.094436,4.783345 50.095085,4.784853 50.095695,4.78608 50.09647,4.786821 50.09734,4.78757 50.098422,4.788287 50.099251,4.789344 50.100251,4.7903 50.100858,4.790963 50.101334,4.79112 50.101577,4.791295 50.102308,4.791382 50.103632,4.791223 50.104939,4.792142 50.105317,4.793102 50.106419,4.793192 50.106822,4.793068 50.107139,4.792242 50.107494,4.792309 50.107637,4.7923 50.107954,4.792085 50.108319,4.791797 50.10866,4.791234 50.109177,4.790411 50.109686,4.789205 50.111167,4.786813 50.113407,4.785342 50.11441,4.785901 50.114854,4.785347 50.115178,4.78538 50.11537,4.785175 50.115775,4.784927 50.116344,4.784994 50.116677,4.783058 50.117468,4.782114 50.118366,4.780504 50.11965,4.7795 50.120574,4.779122 50.120455,4.77873 50.1203,4.778229 50.120191,4.777644 50.120121,4.77737 50.12006,4.777232 50.120088,4.777105 50.120265,4.777943 50.1207,4.778843 50.121062,4.780257 50.12162,4.782584 50.122473,4.783966 50.123148,4.785462 50.123942,4.786352 50.124341,4.78687 50.124639,4.787542 50.124906,4.78792 50.125098,4.790681 50.126552,4.791535 50.126833,4.793195 50.127558,4.795128 50.128507)))"
  ]
  "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.795128 50.128507,4.795281 50.128504,4.796426 50.126505,4.79656 50.126368,4.797049 50.126248,4.796882 50.126007,4.796531 50.125363,4.796266 50.124711,4.796069 50.123956,4.795965 50.123505,4.795832 50.122535,4.796003 50.121322,4.796135 50.120614,4.796432 50.119844,4.797192 50.118368,4.798006 50.116934,4.79847 50.116073,4.79926 50.116147,4.800573 50.115842,4.802045 50.11516,4.802282 50.115043,4.80251 50.114983,4.802757 50.114846,4.803106 50.114761,4.803648 50.114478,4.806971 50.113594,4.808069 50.112899,4.80885 50.112621,4.809131 50.112559,4.808683 50.112213,4.807972 50.111166,4.807733 50.110929,4.808901 50.110737,4.80915 50.110657,4.809059 50.110371,4.808325 50.108753,4.80839 50.108662,4.808663 50.108521,4.809273 50.108149,4.809574 50.107156,4.809968 50.106654,4.81041 50.10626,4.811189 50.10591,4.81117 50.105543,4.811788 50.105306,4.812117 50.104895,4.812264 50.104526,4.812574 50.104133,4.813173 50.104058,4.813674 50.103921,4.813996 50.103855,4.814363 50.103727,4.814575 50.103419,4.814943 50.102999,4.815379 50.102393,4.815588 50.101673,4.815307 50.101633,4.815301 50.101498,4.81555 50.100865,4.81618 50.100923,4.816391 50.100915,4.818106 50.100955,4.818961 50.099566,4.819141 50.099139,4.819314 50.097906,4.81909 50.097331,4.819124 50.096831,4.818903 50.095264,4.818939 50.093414,4.818103 50.093454,4.817335 50.093233,4.815542 50.092646,4.81523 50.09259,4.815814 50.092319,4.815815 50.090918,4.81606 50.090153,4.816441 50.089737,4.816789 50.08973,4.817207 50.089431,4.818384 50.088082,4.819307 50.088144,4.822182 50.088399,4.822031 50.088178,4.821233 50.087566,4.819073 50.086487,4.818787 50.086358,4.817917 50.085703,4.817257 50.084848,4.816889 50.083646,4.816153 50.082488,4.815355 50.081245,4.815069 50.080542,4.814533 50.080275,4.813794 50.080173,4.813783 50.07994,4.814111 50.079529,4.815126 50.07928,4.815203 50.078854,4.815111 50.078607,4.816688 50.078737,4.817174 50.078739,4.817352 50.078286,4.816601 50.07803,4.816081 50.077809,4.815635 50.077596,4.815233 50.077363,4.814876 50.07709,4.814591 50.076826,4.81444 50.07651,4.814402 50.076017,4.814723 50.075674,4.815192 50.075114,4.815523 50.074818,4.816019 50.074247,4.816492 50.073764,4.816704 50.073527,4.816713 50.07334,4.816624 50.073071,4.816509 50.0729,4.816327 50.072237,4.816205 50.071863,4.815626 50.071097,4.81546 50.070781,4.815447 50.070502,4.815538 50.07023,4.815657 50.06957,4.815402 50.068957,4.815372 50.068678,4.815561 50.068249,4.815941 50.06771,4.816187 50.067521,4.816565 50.067281,4.817127 50.067115,4.817433 50.066945,4.817749 50.066639,4.818232 50.066368,4.818685 50.066209,4.819664 50.066063,4.819262 50.066085,4.819152 50.066036,4.819884 50.065614,4.820344 50.065592,4.820931 50.065229,4.821855 50.064618,4.822125 50.064213,4.821903 50.063995,4.821646 50.063833,4.821221 50.063661,4.821171 50.063429,4.821264 50.063302,4.821256 50.063192,4.8211 50.06294,4.820912 50.06277,4.820629 50.062578,4.820234 50.062363,4.82013 50.062356,4.819729 50.062153,4.819635 50.061896,4.819466 50.061829,4.819143 50.06161,4.819084 50.061514,4.81905 50.061234,4.81928 50.060921,4.81954 50.060682,4.819675 50.060625,4.819255 50.060403,4.818991 50.06039,4.818748 50.060463,4.818214 50.060707,4.817669 50.060749,4.816946 50.060746,4.816598 50.060728,4.816 50.060666,4.815305 50.060649,4.815029 50.060659,4.814128 50.060645,4.812635 50.060684,4.811901 50.060599,4.811513 50.060525,4.810918 50.060346,4.810424 50.059971,4.810068 50.059637,4.80929 50.058958,4.808441 50.058566,4.807624 50.058236,4.806707 50.058015,4.806034 50.057889,4.805308 50.057794,4.804902 50.057775,4.80412 50.057564,4.803689 50.057428,4.803063 50.057148,4.802176 50.05663,4.801534 50.056368,4.801069 50.056197,4.800327 50.056835,4.79933 50.057067,4.799143 50.057214,4.798695 50.057323,4.798364 50.057546,4.798061 50.058012,4.797036 50.058437,4.795757 50.058535,4.79445 50.058748,4.793932 50.058736,4.793863 50.058946,4.793984 50.059461,4.794038 50.059614,4.794197 50.059893,4.794458 50.060171,4.795037 50.060898,4.795137 50.061093,4.795758 50.061799,4.795804 50.062555,4.795403 50.063486,4.795301 50.063751,4.795013 50.06423,4.79452 50.064839,4.793035 50.066529,4.792389 50.067619,4.792259 50.067801,4.791458 50.069712,4.791138 50.070303,4.790963 50.07098,4.790102 50.073377,4.789895 50.074872,4.789593 50.075698,4.789444 50.0764,4.789188 50.077116,4.78917 50.077353,4.788988 50.077745,4.787434 50.080832,4.786433 50.082393,4.786141 50.083198,4.786366 50.084627,4.786715 50.085146,4.786436 50.085259,4.785323 50.085828,4.783791 50.086849,4.78294 50.087704,4.781951 50.089119,4.781631 50.09002,4.781423 50.090917,4.781294 50.092012,4.781327 50.092909,4.781515 50.093712,4.782269 50.094436,4.783345 50.095085,4.784853 50.095695,4.78608 50.09647,4.786821 50.09734,4.78757 50.098422,4.788287 50.099251,4.789344 50.100251,4.7903 50.100858,4.790963 50.101334,4.79112 50.101577,4.791295 50.102308,4.791382 50.103632,4.791223 50.104939,4.792142 50.105317,4.793102 50.106419,4.793192 50.106822,4.793068 50.107139,4.792242 50.107494,4.792309 50.107637,4.7923 50.107954,4.792085 50.108319,4.791797 50.10866,4.791234 50.109177,4.790411 50.109686,4.789205 50.111167,4.786813 50.113407,4.785342 50.11441,4.785901 50.114854,4.785347 50.115178,4.78538 50.11537,4.785175 50.115775,4.784927 50.116344,4.784994 50.116677,4.783058 50.117468,4.782114 50.118366,4.780504 50.11965,4.7795 50.120574,4.779122 50.120455,4.77873 50.1203,4.778229 50.120191,4.777644 50.120121,4.77737 50.12006,4.777232 50.120088,4.777105 50.120265,4.777943 50.1207,4.778843 50.121062,4.780257 50.12162,4.782584 50.122473,4.783966 50.123148,4.785462 50.123942,4.786352 50.124341,4.78687 50.124639,4.787542 50.124906,4.78792 50.125098,4.790681 50.126552,4.791535 50.126833,4.793195 50.127558,4.795128 50.128507)))"
  ]
  "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.795128 50.128507,4.795281 50.128504,4.796426 50.126505,4.79656 50.126368,4.797049 50.126248,4.796882 50.126007,4.796531 50.125363,4.796266 50.124711,4.796069 50.123956,4.795965 50.123505,4.795832 50.122535,4.796003 50.121322,4.796135 50.120614,4.796432 50.119844,4.797192 50.118368,4.798006 50.116934,4.79847 50.116073,4.79926 50.116147,4.800573 50.115842,4.802045 50.11516,4.802282 50.115043,4.80251 50.114983,4.802757 50.114846,4.803106 50.114761,4.803648 50.114478,4.806971 50.113594,4.808069 50.112899,4.80885 50.112621,4.809131 50.112559,4.808683 50.112213,4.807972 50.111166,4.807733 50.110929,4.808901 50.110737,4.80915 50.110657,4.809059 50.110371,4.808325 50.108753,4.80839 50.108662,4.808663 50.108521,4.809273 50.108149,4.809574 50.107156,4.809968 50.106654,4.81041 50.10626,4.811189 50.10591,4.81117 50.105543,4.811788 50.105306,4.812117 50.104895,4.812264 50.104526,4.812574 50.104133,4.813173 50.104058,4.813674 50.103921,4.813996 50.103855,4.814363 50.103727,4.814575 50.103419,4.814943 50.102999,4.815379 50.102393,4.815588 50.101673,4.815307 50.101633,4.815301 50.101498,4.81555 50.100865,4.81618 50.100923,4.816391 50.100915,4.818106 50.100955,4.818961 50.099566,4.819141 50.099139,4.819314 50.097906,4.81909 50.097331,4.819124 50.096831,4.818903 50.095264,4.818939 50.093414,4.818103 50.093454,4.817335 50.093233,4.815542 50.092646,4.81523 50.09259,4.815814 50.092319,4.815815 50.090918,4.81606 50.090153,4.816441 50.089737,4.816789 50.08973,4.817207 50.089431,4.818384 50.088082,4.819307 50.088144,4.822182 50.088399,4.822031 50.088178,4.821233 50.087566,4.819073 50.086487,4.818787 50.086358,4.817917 50.085703,4.817257 50.084848,4.816889 50.083646,4.816153 50.082488,4.815355 50.081245,4.815069 50.080542,4.814533 50.080275,4.813794 50.080173,4.813783 50.07994,4.814111 50.079529,4.815126 50.07928,4.815203 50.078854,4.815111 50.078607,4.816688 50.078737,4.817174 50.078739,4.817352 50.078286,4.816601 50.07803,4.816081 50.077809,4.815635 50.077596,4.815233 50.077363,4.814876 50.07709,4.814591 50.076826,4.81444 50.07651,4.814402 50.076017,4.814723 50.075674,4.815192 50.075114,4.815523 50.074818,4.816019 50.074247,4.816492 50.073764,4.816704 50.073527,4.816713 50.07334,4.816624 50.073071,4.816509 50.0729,4.816327 50.072237,4.816205 50.071863,4.815626 50.071097,4.81546 50.070781,4.815447 50.070502,4.815538 50.07023,4.815657 50.06957,4.815402 50.068957,4.815372 50.068678,4.815561 50.068249,4.815941 50.06771,4.816187 50.067521,4.816565 50.067281,4.817127 50.067115,4.817433 50.066945,4.817749 50.066639,4.818232 50.066368,4.818685 50.066209,4.819664 50.066063,4.819262 50.066085,4.819152 50.066036,4.819884 50.065614,4.820344 50.065592,4.820931 50.065229,4.821855 50.064618,4.822125 50.064213,4.821903 50.063995,4.821646 50.063833,4.821221 50.063661,4.821171 50.063429,4.821264 50.063302,4.821256 50.063192,4.8211 50.06294,4.820912 50.06277,4.820629 50.062578,4.820234 50.062363,4.82013 50.062356,4.819729 50.062153,4.819635 50.061896,4.819466 50.061829,4.819143 50.06161,4.819084 50.061514,4.81905 50.061234,4.81928 50.060921,4.81954 50.060682,4.819675 50.060625,4.819255 50.060403,4.818991 50.06039,4.818748 50.060463,4.818214 50.060707,4.817669 50.060749,4.816946 50.060746,4.816598 50.060728,4.816 50.060666,4.815305 50.060649,4.815029 50.060659,4.814128 50.060645,4.812635 50.060684,4.811901 50.060599,4.811513 50.060525,4.810918 50.060346,4.810424 50.059971,4.810068 50.059637,4.80929 50.058958,4.808441 50.058566,4.807624 50.058236,4.806707 50.058015,4.806034 50.057889,4.805308 50.057794,4.804902 50.057775,4.80412 50.057564,4.803689 50.057428,4.803063 50.057148,4.802176 50.05663,4.801534 50.056368,4.801069 50.056197,4.800327 50.056835,4.79933 50.057067,4.799143 50.057214,4.798695 50.057323,4.798364 50.057546,4.798061 50.058012,4.797036 50.058437,4.795757 50.058535,4.79445 50.058748,4.793932 50.058736,4.793863 50.058946,4.793984 50.059461,4.794038 50.059614,4.794197 50.059893,4.794458 50.060171,4.795037 50.060898,4.795137 50.061093,4.795758 50.061799,4.795804 50.062555,4.795403 50.063486,4.795301 50.063751,4.795013 50.06423,4.79452 50.064839,4.793035 50.066529,4.792389 50.067619,4.792259 50.067801,4.791458 50.069712,4.791138 50.070303,4.790963 50.07098,4.790102 50.073377,4.789895 50.074872,4.789593 50.075698,4.789444 50.0764,4.789188 50.077116,4.78917 50.077353,4.788988 50.077745,4.787434 50.080832,4.786433 50.082393,4.786141 50.083198,4.786366 50.084627,4.786715 50.085146,4.786436 50.085259,4.785323 50.085828,4.783791 50.086849,4.78294 50.087704,4.781951 50.089119,4.781631 50.09002,4.781423 50.090917,4.781294 50.092012,4.781327 50.092909,4.781515 50.093712,4.782269 50.094436,4.783345 50.095085,4.784853 50.095695,4.78608 50.09647,4.786821 50.09734,4.78757 50.098422,4.788287 50.099251,4.789344 50.100251,4.7903 50.100858,4.790963 50.101334,4.79112 50.101577,4.791295 50.102308,4.791382 50.103632,4.791223 50.104939,4.792142 50.105317,4.793102 50.106419,4.793192 50.106822,4.793068 50.107139,4.792242 50.107494,4.792309 50.107637,4.7923 50.107954,4.792085 50.108319,4.791797 50.10866,4.791234 50.109177,4.790411 50.109686,4.789205 50.111167,4.786813 50.113407,4.785342 50.11441,4.785901 50.114854,4.785347 50.115178,4.78538 50.11537,4.785175 50.115775,4.784927 50.116344,4.784994 50.116677,4.783058 50.117468,4.782114 50.118366,4.780504 50.11965,4.7795 50.120574,4.779122 50.120455,4.77873 50.1203,4.778229 50.120191,4.777644 50.120121,4.77737 50.12006,4.777232 50.120088,4.777105 50.120265,4.777943 50.1207,4.778843 50.121062,4.780257 50.12162,4.782584 50.122473,4.783966 50.123148,4.785462 50.123942,4.786352 50.124341,4.78687 50.124639,4.787542 50.124906,4.78792 50.125098,4.790681 50.126552,4.791535 50.126833,4.793195 50.127558,4.795128 50.128507)))"
  ]
  "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, 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 AND ST_Intersects(m.geom, ST_GeomFromText(?, 4326))\n
                AND (\n
                  (tags->'shop') = 'vacant'\n
                  OR EXISTS (SELECT 1 FROM unnest(akeys(tags)) k WHERE k LIKE 'was:%')\n
                )
    """
  "params" => [
    1 => "MULTIPOLYGON(((4.795128 50.128507,4.795281 50.128504,4.796426 50.126505,4.79656 50.126368,4.797049 50.126248,4.796882 50.126007,4.796531 50.125363,4.796266 50.124711,4.796069 50.123956,4.795965 50.123505,4.795832 50.122535,4.796003 50.121322,4.796135 50.120614,4.796432 50.119844,4.797192 50.118368,4.798006 50.116934,4.79847 50.116073,4.79926 50.116147,4.800573 50.115842,4.802045 50.11516,4.802282 50.115043,4.80251 50.114983,4.802757 50.114846,4.803106 50.114761,4.803648 50.114478,4.806971 50.113594,4.808069 50.112899,4.80885 50.112621,4.809131 50.112559,4.808683 50.112213,4.807972 50.111166,4.807733 50.110929,4.808901 50.110737,4.80915 50.110657,4.809059 50.110371,4.808325 50.108753,4.80839 50.108662,4.808663 50.108521,4.809273 50.108149,4.809574 50.107156,4.809968 50.106654,4.81041 50.10626,4.811189 50.10591,4.81117 50.105543,4.811788 50.105306,4.812117 50.104895,4.812264 50.104526,4.812574 50.104133,4.813173 50.104058,4.813674 50.103921,4.813996 50.103855,4.814363 50.103727,4.814575 50.103419,4.814943 50.102999,4.815379 50.102393,4.815588 50.101673,4.815307 50.101633,4.815301 50.101498,4.81555 50.100865,4.81618 50.100923,4.816391 50.100915,4.818106 50.100955,4.818961 50.099566,4.819141 50.099139,4.819314 50.097906,4.81909 50.097331,4.819124 50.096831,4.818903 50.095264,4.818939 50.093414,4.818103 50.093454,4.817335 50.093233,4.815542 50.092646,4.81523 50.09259,4.815814 50.092319,4.815815 50.090918,4.81606 50.090153,4.816441 50.089737,4.816789 50.08973,4.817207 50.089431,4.818384 50.088082,4.819307 50.088144,4.822182 50.088399,4.822031 50.088178,4.821233 50.087566,4.819073 50.086487,4.818787 50.086358,4.817917 50.085703,4.817257 50.084848,4.816889 50.083646,4.816153 50.082488,4.815355 50.081245,4.815069 50.080542,4.814533 50.080275,4.813794 50.080173,4.813783 50.07994,4.814111 50.079529,4.815126 50.07928,4.815203 50.078854,4.815111 50.078607,4.816688 50.078737,4.817174 50.078739,4.817352 50.078286,4.816601 50.07803,4.816081 50.077809,4.815635 50.077596,4.815233 50.077363,4.814876 50.07709,4.814591 50.076826,4.81444 50.07651,4.814402 50.076017,4.814723 50.075674,4.815192 50.075114,4.815523 50.074818,4.816019 50.074247,4.816492 50.073764,4.816704 50.073527,4.816713 50.07334,4.816624 50.073071,4.816509 50.0729,4.816327 50.072237,4.816205 50.071863,4.815626 50.071097,4.81546 50.070781,4.815447 50.070502,4.815538 50.07023,4.815657 50.06957,4.815402 50.068957,4.815372 50.068678,4.815561 50.068249,4.815941 50.06771,4.816187 50.067521,4.816565 50.067281,4.817127 50.067115,4.817433 50.066945,4.817749 50.066639,4.818232 50.066368,4.818685 50.066209,4.819664 50.066063,4.819262 50.066085,4.819152 50.066036,4.819884 50.065614,4.820344 50.065592,4.820931 50.065229,4.821855 50.064618,4.822125 50.064213,4.821903 50.063995,4.821646 50.063833,4.821221 50.063661,4.821171 50.063429,4.821264 50.063302,4.821256 50.063192,4.8211 50.06294,4.820912 50.06277,4.820629 50.062578,4.820234 50.062363,4.82013 50.062356,4.819729 50.062153,4.819635 50.061896,4.819466 50.061829,4.819143 50.06161,4.819084 50.061514,4.81905 50.061234,4.81928 50.060921,4.81954 50.060682,4.819675 50.060625,4.819255 50.060403,4.818991 50.06039,4.818748 50.060463,4.818214 50.060707,4.817669 50.060749,4.816946 50.060746,4.816598 50.060728,4.816 50.060666,4.815305 50.060649,4.815029 50.060659,4.814128 50.060645,4.812635 50.060684,4.811901 50.060599,4.811513 50.060525,4.810918 50.060346,4.810424 50.059971,4.810068 50.059637,4.80929 50.058958,4.808441 50.058566,4.807624 50.058236,4.806707 50.058015,4.806034 50.057889,4.805308 50.057794,4.804902 50.057775,4.80412 50.057564,4.803689 50.057428,4.803063 50.057148,4.802176 50.05663,4.801534 50.056368,4.801069 50.056197,4.800327 50.056835,4.79933 50.057067,4.799143 50.057214,4.798695 50.057323,4.798364 50.057546,4.798061 50.058012,4.797036 50.058437,4.795757 50.058535,4.79445 50.058748,4.793932 50.058736,4.793863 50.058946,4.793984 50.059461,4.794038 50.059614,4.794197 50.059893,4.794458 50.060171,4.795037 50.060898,4.795137 50.061093,4.795758 50.061799,4.795804 50.062555,4.795403 50.063486,4.795301 50.063751,4.795013 50.06423,4.79452 50.064839,4.793035 50.066529,4.792389 50.067619,4.792259 50.067801,4.791458 50.069712,4.791138 50.070303,4.790963 50.07098,4.790102 50.073377,4.789895 50.074872,4.789593 50.075698,4.789444 50.0764,4.789188 50.077116,4.78917 50.077353,4.788988 50.077745,4.787434 50.080832,4.786433 50.082393,4.786141 50.083198,4.786366 50.084627,4.786715 50.085146,4.786436 50.085259,4.785323 50.085828,4.783791 50.086849,4.78294 50.087704,4.781951 50.089119,4.781631 50.09002,4.781423 50.090917,4.781294 50.092012,4.781327 50.092909,4.781515 50.093712,4.782269 50.094436,4.783345 50.095085,4.784853 50.095695,4.78608 50.09647,4.786821 50.09734,4.78757 50.098422,4.788287 50.099251,4.789344 50.100251,4.7903 50.100858,4.790963 50.101334,4.79112 50.101577,4.791295 50.102308,4.791382 50.103632,4.791223 50.104939,4.792142 50.105317,4.793102 50.106419,4.793192 50.106822,4.793068 50.107139,4.792242 50.107494,4.792309 50.107637,4.7923 50.107954,4.792085 50.108319,4.791797 50.10866,4.791234 50.109177,4.790411 50.109686,4.789205 50.111167,4.786813 50.113407,4.785342 50.11441,4.785901 50.114854,4.785347 50.115178,4.78538 50.11537,4.785175 50.115775,4.784927 50.116344,4.784994 50.116677,4.783058 50.117468,4.782114 50.118366,4.780504 50.11965,4.7795 50.120574,4.779122 50.120455,4.77873 50.1203,4.778229 50.120191,4.777644 50.120121,4.77737 50.12006,4.777232 50.120088,4.777105 50.120265,4.777943 50.1207,4.778843 50.121062,4.780257 50.12162,4.782584 50.122473,4.783966 50.123148,4.785462 50.123942,4.786352 50.124341,4.78687 50.124639,4.787542 50.124906,4.78792 50.125098,4.790681 50.126552,4.791535 50.126833,4.793195 50.127558,4.795128 50.128507)))"
  ]
  "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 => 27309
  ]
  "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 => 27309
  ]
  "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.795128 50.128507,4.795281 50.128504,4.796426 50.126505,4.79656 50.126368,4.797049 50.126248,4.796882 50.126007,4.796531 50.125363,4.796266 50.124711,4.796069 50.123956,4.795965 50.123505,4.795832 50.122535,4.796003 50.121322,4.796135 50.120614,4.796432 50.119844,4.797192 50.118368,4.798006 50.116934,4.79847 50.116073,4.79926 50.116147,4.800573 50.115842,4.802045 50.11516,4.802282 50.115043,4.80251 50.114983,4.802757 50.114846,4.803106 50.114761,4.803648 50.114478,4.806971 50.113594,4.808069 50.112899,4.80885 50.112621,4.809131 50.112559,4.808683 50.112213,4.807972 50.111166,4.807733 50.110929,4.808901 50.110737,4.80915 50.110657,4.809059 50.110371,4.808325 50.108753,4.80839 50.108662,4.808663 50.108521,4.809273 50.108149,4.809574 50.107156,4.809968 50.106654,4.81041 50.10626,4.811189 50.10591,4.81117 50.105543,4.811788 50.105306,4.812117 50.104895,4.812264 50.104526,4.812574 50.104133,4.813173 50.104058,4.813674 50.103921,4.813996 50.103855,4.814363 50.103727,4.814575 50.103419,4.814943 50.102999,4.815379 50.102393,4.815588 50.101673,4.815307 50.101633,4.815301 50.101498,4.81555 50.100865,4.81618 50.100923,4.816391 50.100915,4.818106 50.100955,4.818961 50.099566,4.819141 50.099139,4.819314 50.097906,4.81909 50.097331,4.819124 50.096831,4.818903 50.095264,4.818939 50.093414,4.818103 50.093454,4.817335 50.093233,4.815542 50.092646,4.81523 50.09259,4.815814 50.092319,4.815815 50.090918,4.81606 50.090153,4.816441 50.089737,4.816789 50.08973,4.817207 50.089431,4.818384 50.088082,4.819307 50.088144,4.822182 50.088399,4.822031 50.088178,4.821233 50.087566,4.819073 50.086487,4.818787 50.086358,4.817917 50.085703,4.817257 50.084848,4.816889 50.083646,4.816153 50.082488,4.815355 50.081245,4.815069 50.080542,4.814533 50.080275,4.813794 50.080173,4.813783 50.07994,4.814111 50.079529,4.815126 50.07928,4.815203 50.078854,4.815111 50.078607,4.816688 50.078737,4.817174 50.078739,4.817352 50.078286,4.816601 50.07803,4.816081 50.077809,4.815635 50.077596,4.815233 50.077363,4.814876 50.07709,4.814591 50.076826,4.81444 50.07651,4.814402 50.076017,4.814723 50.075674,4.815192 50.075114,4.815523 50.074818,4.816019 50.074247,4.816492 50.073764,4.816704 50.073527,4.816713 50.07334,4.816624 50.073071,4.816509 50.0729,4.816327 50.072237,4.816205 50.071863,4.815626 50.071097,4.81546 50.070781,4.815447 50.070502,4.815538 50.07023,4.815657 50.06957,4.815402 50.068957,4.815372 50.068678,4.815561 50.068249,4.815941 50.06771,4.816187 50.067521,4.816565 50.067281,4.817127 50.067115,4.817433 50.066945,4.817749 50.066639,4.818232 50.066368,4.818685 50.066209,4.819664 50.066063,4.819262 50.066085,4.819152 50.066036,4.819884 50.065614,4.820344 50.065592,4.820931 50.065229,4.821855 50.064618,4.822125 50.064213,4.821903 50.063995,4.821646 50.063833,4.821221 50.063661,4.821171 50.063429,4.821264 50.063302,4.821256 50.063192,4.8211 50.06294,4.820912 50.06277,4.820629 50.062578,4.820234 50.062363,4.82013 50.062356,4.819729 50.062153,4.819635 50.061896,4.819466 50.061829,4.819143 50.06161,4.819084 50.061514,4.81905 50.061234,4.81928 50.060921,4.81954 50.060682,4.819675 50.060625,4.819255 50.060403,4.818991 50.06039,4.818748 50.060463,4.818214 50.060707,4.817669 50.060749,4.816946 50.060746,4.816598 50.060728,4.816 50.060666,4.815305 50.060649,4.815029 50.060659,4.814128 50.060645,4.812635 50.060684,4.811901 50.060599,4.811513 50.060525,4.810918 50.060346,4.810424 50.059971,4.810068 50.059637,4.80929 50.058958,4.808441 50.058566,4.807624 50.058236,4.806707 50.058015,4.806034 50.057889,4.805308 50.057794,4.804902 50.057775,4.80412 50.057564,4.803689 50.057428,4.803063 50.057148,4.802176 50.05663,4.801534 50.056368,4.801069 50.056197,4.800327 50.056835,4.79933 50.057067,4.799143 50.057214,4.798695 50.057323,4.798364 50.057546,4.798061 50.058012,4.797036 50.058437,4.795757 50.058535,4.79445 50.058748,4.793932 50.058736,4.793863 50.058946,4.793984 50.059461,4.794038 50.059614,4.794197 50.059893,4.794458 50.060171,4.795037 50.060898,4.795137 50.061093,4.795758 50.061799,4.795804 50.062555,4.795403 50.063486,4.795301 50.063751,4.795013 50.06423,4.79452 50.064839,4.793035 50.066529,4.792389 50.067619,4.792259 50.067801,4.791458 50.069712,4.791138 50.070303,4.790963 50.07098,4.790102 50.073377,4.789895 50.074872,4.789593 50.075698,4.789444 50.0764,4.789188 50.077116,4.78917 50.077353,4.788988 50.077745,4.787434 50.080832,4.786433 50.082393,4.786141 50.083198,4.786366 50.084627,4.786715 50.085146,4.786436 50.085259,4.785323 50.085828,4.783791 50.086849,4.78294 50.087704,4.781951 50.089119,4.781631 50.09002,4.781423 50.090917,4.781294 50.092012,4.781327 50.092909,4.781515 50.093712,4.782269 50.094436,4.783345 50.095085,4.784853 50.095695,4.78608 50.09647,4.786821 50.09734,4.78757 50.098422,4.788287 50.099251,4.789344 50.100251,4.7903 50.100858,4.790963 50.101334,4.79112 50.101577,4.791295 50.102308,4.791382 50.103632,4.791223 50.104939,4.792142 50.105317,4.793102 50.106419,4.793192 50.106822,4.793068 50.107139,4.792242 50.107494,4.792309 50.107637,4.7923 50.107954,4.792085 50.108319,4.791797 50.10866,4.791234 50.109177,4.790411 50.109686,4.789205 50.111167,4.786813 50.113407,4.785342 50.11441,4.785901 50.114854,4.785347 50.115178,4.78538 50.11537,4.785175 50.115775,4.784927 50.116344,4.784994 50.116677,4.783058 50.117468,4.782114 50.118366,4.780504 50.11965,4.7795 50.120574,4.779122 50.120455,4.77873 50.1203,4.778229 50.120191,4.777644 50.120121,4.77737 50.12006,4.777232 50.120088,4.777105 50.120265,4.777943 50.1207,4.778843 50.121062,4.780257 50.12162,4.782584 50.122473,4.783966 50.123148,4.785462 50.123942,4.786352 50.124341,4.78687 50.124639,4.787542 50.124906,4.78792 50.125098,4.790681 50.126552,4.791535 50.126833,4.793195 50.127558,4.795128 50.128507)))"
    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.795128 50.128507,4.795281 50.128504,4.796426 50.126505,4.79656 50.126368,4.797049 50.126248,4.796882 50.126007,4.796531 50.125363,4.796266 50.124711,4.796069 50.123956,4.795965 50.123505,4.795832 50.122535,4.796003 50.121322,4.796135 50.120614,4.796432 50.119844,4.797192 50.118368,4.798006 50.116934,4.79847 50.116073,4.79926 50.116147,4.800573 50.115842,4.802045 50.11516,4.802282 50.115043,4.80251 50.114983,4.802757 50.114846,4.803106 50.114761,4.803648 50.114478,4.806971 50.113594,4.808069 50.112899,4.80885 50.112621,4.809131 50.112559,4.808683 50.112213,4.807972 50.111166,4.807733 50.110929,4.808901 50.110737,4.80915 50.110657,4.809059 50.110371,4.808325 50.108753,4.80839 50.108662,4.808663 50.108521,4.809273 50.108149,4.809574 50.107156,4.809968 50.106654,4.81041 50.10626,4.811189 50.10591,4.81117 50.105543,4.811788 50.105306,4.812117 50.104895,4.812264 50.104526,4.812574 50.104133,4.813173 50.104058,4.813674 50.103921,4.813996 50.103855,4.814363 50.103727,4.814575 50.103419,4.814943 50.102999,4.815379 50.102393,4.815588 50.101673,4.815307 50.101633,4.815301 50.101498,4.81555 50.100865,4.81618 50.100923,4.816391 50.100915,4.818106 50.100955,4.818961 50.099566,4.819141 50.099139,4.819314 50.097906,4.81909 50.097331,4.819124 50.096831,4.818903 50.095264,4.818939 50.093414,4.818103 50.093454,4.817335 50.093233,4.815542 50.092646,4.81523 50.09259,4.815814 50.092319,4.815815 50.090918,4.81606 50.090153,4.816441 50.089737,4.816789 50.08973,4.817207 50.089431,4.818384 50.088082,4.819307 50.088144,4.822182 50.088399,4.822031 50.088178,4.821233 50.087566,4.819073 50.086487,4.818787 50.086358,4.817917 50.085703,4.817257 50.084848,4.816889 50.083646,4.816153 50.082488,4.815355 50.081245,4.815069 50.080542,4.814533 50.080275,4.813794 50.080173,4.813783 50.07994,4.814111 50.079529,4.815126 50.07928,4.815203 50.078854,4.815111 50.078607,4.816688 50.078737,4.817174 50.078739,4.817352 50.078286,4.816601 50.07803,4.816081 50.077809,4.815635 50.077596,4.815233 50.077363,4.814876 50.07709,4.814591 50.076826,4.81444 50.07651,4.814402 50.076017,4.814723 50.075674,4.815192 50.075114,4.815523 50.074818,4.816019 50.074247,4.816492 50.073764,4.816704 50.073527,4.816713 50.07334,4.816624 50.073071,4.816509 50.0729,4.816327 50.072237,4.816205 50.071863,4.815626 50.071097,4.81546 50.070781,4.815447 50.070502,4.815538 50.07023,4.815657 50.06957,4.815402 50.068957,4.815372 50.068678,4.815561 50.068249,4.815941 50.06771,4.816187 50.067521,4.816565 50.067281,4.817127 50.067115,4.817433 50.066945,4.817749 50.066639,4.818232 50.066368,4.818685 50.066209,4.819664 50.066063,4.819262 50.066085,4.819152 50.066036,4.819884 50.065614,4.820344 50.065592,4.820931 50.065229,4.821855 50.064618,4.822125 50.064213,4.821903 50.063995,4.821646 50.063833,4.821221 50.063661,4.821171 50.063429,4.821264 50.063302,4.821256 50.063192,4.8211 50.06294,4.820912 50.06277,4.820629 50.062578,4.820234 50.062363,4.82013 50.062356,4.819729 50.062153,4.819635 50.061896,4.819466 50.061829,4.819143 50.06161,4.819084 50.061514,4.81905 50.061234,4.81928 50.060921,4.81954 50.060682,4.819675 50.060625,4.819255 50.060403,4.818991 50.06039,4.818748 50.060463,4.818214 50.060707,4.817669 50.060749,4.816946 50.060746,4.816598 50.060728,4.816 50.060666,4.815305 50.060649,4.815029 50.060659,4.814128 50.060645,4.812635 50.060684,4.811901 50.060599,4.811513 50.060525,4.810918 50.060346,4.810424 50.059971,4.810068 50.059637,4.80929 50.058958,4.808441 50.058566,4.807624 50.058236,4.806707 50.058015,4.806034 50.057889,4.805308 50.057794,4.804902 50.057775,4.80412 50.057564,4.803689 50.057428,4.803063 50.057148,4.802176 50.05663,4.801534 50.056368,4.801069 50.056197,4.800327 50.056835,4.79933 50.057067,4.799143 50.057214,4.798695 50.057323,4.798364 50.057546,4.798061 50.058012,4.797036 50.058437,4.795757 50.058535,4.79445 50.058748,4.793932 50.058736,4.793863 50.058946,4.793984 50.059461,4.794038 50.059614,4.794197 50.059893,4.794458 50.060171,4.795037 50.060898,4.795137 50.061093,4.795758 50.061799,4.795804 50.062555,4.795403 50.063486,4.795301 50.063751,4.795013 50.06423,4.79452 50.064839,4.793035 50.066529,4.792389 50.067619,4.792259 50.067801,4.791458 50.069712,4.791138 50.070303,4.790963 50.07098,4.790102 50.073377,4.789895 50.074872,4.789593 50.075698,4.789444 50.0764,4.789188 50.077116,4.78917 50.077353,4.788988 50.077745,4.787434 50.080832,4.786433 50.082393,4.786141 50.083198,4.786366 50.084627,4.786715 50.085146,4.786436 50.085259,4.785323 50.085828,4.783791 50.086849,4.78294 50.087704,4.781951 50.089119,4.781631 50.09002,4.781423 50.090917,4.781294 50.092012,4.781327 50.092909,4.781515 50.093712,4.782269 50.094436,4.783345 50.095085,4.784853 50.095695,4.78608 50.09647,4.786821 50.09734,4.78757 50.098422,4.788287 50.099251,4.789344 50.100251,4.7903 50.100858,4.790963 50.101334,4.79112 50.101577,4.791295 50.102308,4.791382 50.103632,4.791223 50.104939,4.792142 50.105317,4.793102 50.106419,4.793192 50.106822,4.793068 50.107139,4.792242 50.107494,4.792309 50.107637,4.7923 50.107954,4.792085 50.108319,4.791797 50.10866,4.791234 50.109177,4.790411 50.109686,4.789205 50.111167,4.786813 50.113407,4.785342 50.11441,4.785901 50.114854,4.785347 50.115178,4.78538 50.11537,4.785175 50.115775,4.784927 50.116344,4.784994 50.116677,4.783058 50.117468,4.782114 50.118366,4.780504 50.11965,4.7795 50.120574,4.779122 50.120455,4.77873 50.1203,4.778229 50.120191,4.777644 50.120121,4.77737 50.12006,4.777232 50.120088,4.777105 50.120265,4.777943 50.1207,4.778843 50.121062,4.780257 50.12162,4.782584 50.122473,4.783966 50.123148,4.785462 50.123942,4.786352 50.124341,4.78687 50.124639,4.787542 50.124906,4.78792 50.125098,4.790681 50.126552,4.791535 50.126833,4.793195 50.127558,4.795128 50.128507)))"
  ]
  "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.795128 50.128507,4.795281 50.128504,4.796426 50.126505,4.79656 50.126368,4.797049 50.126248,4.796882 50.126007,4.796531 50.125363,4.796266 50.124711,4.796069 50.123956,4.795965 50.123505,4.795832 50.122535,4.796003 50.121322,4.796135 50.120614,4.796432 50.119844,4.797192 50.118368,4.798006 50.116934,4.79847 50.116073,4.79926 50.116147,4.800573 50.115842,4.802045 50.11516,4.802282 50.115043,4.80251 50.114983,4.802757 50.114846,4.803106 50.114761,4.803648 50.114478,4.806971 50.113594,4.808069 50.112899,4.80885 50.112621,4.809131 50.112559,4.808683 50.112213,4.807972 50.111166,4.807733 50.110929,4.808901 50.110737,4.80915 50.110657,4.809059 50.110371,4.808325 50.108753,4.80839 50.108662,4.808663 50.108521,4.809273 50.108149,4.809574 50.107156,4.809968 50.106654,4.81041 50.10626,4.811189 50.10591,4.81117 50.105543,4.811788 50.105306,4.812117 50.104895,4.812264 50.104526,4.812574 50.104133,4.813173 50.104058,4.813674 50.103921,4.813996 50.103855,4.814363 50.103727,4.814575 50.103419,4.814943 50.102999,4.815379 50.102393,4.815588 50.101673,4.815307 50.101633,4.815301 50.101498,4.81555 50.100865,4.81618 50.100923,4.816391 50.100915,4.818106 50.100955,4.818961 50.099566,4.819141 50.099139,4.819314 50.097906,4.81909 50.097331,4.819124 50.096831,4.818903 50.095264,4.818939 50.093414,4.818103 50.093454,4.817335 50.093233,4.815542 50.092646,4.81523 50.09259,4.815814 50.092319,4.815815 50.090918,4.81606 50.090153,4.816441 50.089737,4.816789 50.08973,4.817207 50.089431,4.818384 50.088082,4.819307 50.088144,4.822182 50.088399,4.822031 50.088178,4.821233 50.087566,4.819073 50.086487,4.818787 50.086358,4.817917 50.085703,4.817257 50.084848,4.816889 50.083646,4.816153 50.082488,4.815355 50.081245,4.815069 50.080542,4.814533 50.080275,4.813794 50.080173,4.813783 50.07994,4.814111 50.079529,4.815126 50.07928,4.815203 50.078854,4.815111 50.078607,4.816688 50.078737,4.817174 50.078739,4.817352 50.078286,4.816601 50.07803,4.816081 50.077809,4.815635 50.077596,4.815233 50.077363,4.814876 50.07709,4.814591 50.076826,4.81444 50.07651,4.814402 50.076017,4.814723 50.075674,4.815192 50.075114,4.815523 50.074818,4.816019 50.074247,4.816492 50.073764,4.816704 50.073527,4.816713 50.07334,4.816624 50.073071,4.816509 50.0729,4.816327 50.072237,4.816205 50.071863,4.815626 50.071097,4.81546 50.070781,4.815447 50.070502,4.815538 50.07023,4.815657 50.06957,4.815402 50.068957,4.815372 50.068678,4.815561 50.068249,4.815941 50.06771,4.816187 50.067521,4.816565 50.067281,4.817127 50.067115,4.817433 50.066945,4.817749 50.066639,4.818232 50.066368,4.818685 50.066209,4.819664 50.066063,4.819262 50.066085,4.819152 50.066036,4.819884 50.065614,4.820344 50.065592,4.820931 50.065229,4.821855 50.064618,4.822125 50.064213,4.821903 50.063995,4.821646 50.063833,4.821221 50.063661,4.821171 50.063429,4.821264 50.063302,4.821256 50.063192,4.8211 50.06294,4.820912 50.06277,4.820629 50.062578,4.820234 50.062363,4.82013 50.062356,4.819729 50.062153,4.819635 50.061896,4.819466 50.061829,4.819143 50.06161,4.819084 50.061514,4.81905 50.061234,4.81928 50.060921,4.81954 50.060682,4.819675 50.060625,4.819255 50.060403,4.818991 50.06039,4.818748 50.060463,4.818214 50.060707,4.817669 50.060749,4.816946 50.060746,4.816598 50.060728,4.816 50.060666,4.815305 50.060649,4.815029 50.060659,4.814128 50.060645,4.812635 50.060684,4.811901 50.060599,4.811513 50.060525,4.810918 50.060346,4.810424 50.059971,4.810068 50.059637,4.80929 50.058958,4.808441 50.058566,4.807624 50.058236,4.806707 50.058015,4.806034 50.057889,4.805308 50.057794,4.804902 50.057775,4.80412 50.057564,4.803689 50.057428,4.803063 50.057148,4.802176 50.05663,4.801534 50.056368,4.801069 50.056197,4.800327 50.056835,4.79933 50.057067,4.799143 50.057214,4.798695 50.057323,4.798364 50.057546,4.798061 50.058012,4.797036 50.058437,4.795757 50.058535,4.79445 50.058748,4.793932 50.058736,4.793863 50.058946,4.793984 50.059461,4.794038 50.059614,4.794197 50.059893,4.794458 50.060171,4.795037 50.060898,4.795137 50.061093,4.795758 50.061799,4.795804 50.062555,4.795403 50.063486,4.795301 50.063751,4.795013 50.06423,4.79452 50.064839,4.793035 50.066529,4.792389 50.067619,4.792259 50.067801,4.791458 50.069712,4.791138 50.070303,4.790963 50.07098,4.790102 50.073377,4.789895 50.074872,4.789593 50.075698,4.789444 50.0764,4.789188 50.077116,4.78917 50.077353,4.788988 50.077745,4.787434 50.080832,4.786433 50.082393,4.786141 50.083198,4.786366 50.084627,4.786715 50.085146,4.786436 50.085259,4.785323 50.085828,4.783791 50.086849,4.78294 50.087704,4.781951 50.089119,4.781631 50.09002,4.781423 50.090917,4.781294 50.092012,4.781327 50.092909,4.781515 50.093712,4.782269 50.094436,4.783345 50.095085,4.784853 50.095695,4.78608 50.09647,4.786821 50.09734,4.78757 50.098422,4.788287 50.099251,4.789344 50.100251,4.7903 50.100858,4.790963 50.101334,4.79112 50.101577,4.791295 50.102308,4.791382 50.103632,4.791223 50.104939,4.792142 50.105317,4.793102 50.106419,4.793192 50.106822,4.793068 50.107139,4.792242 50.107494,4.792309 50.107637,4.7923 50.107954,4.792085 50.108319,4.791797 50.10866,4.791234 50.109177,4.790411 50.109686,4.789205 50.111167,4.786813 50.113407,4.785342 50.11441,4.785901 50.114854,4.785347 50.115178,4.78538 50.11537,4.785175 50.115775,4.784927 50.116344,4.784994 50.116677,4.783058 50.117468,4.782114 50.118366,4.780504 50.11965,4.7795 50.120574,4.779122 50.120455,4.77873 50.1203,4.778229 50.120191,4.777644 50.120121,4.77737 50.12006,4.777232 50.120088,4.777105 50.120265,4.777943 50.1207,4.778843 50.121062,4.780257 50.12162,4.782584 50.122473,4.783966 50.123148,4.785462 50.123942,4.786352 50.124341,4.78687 50.124639,4.787542 50.124906,4.78792 50.125098,4.790681 50.126552,4.791535 50.126833,4.793195 50.127558,4.795128 50.128507)))"
  ]
  "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.795128 50.128507,4.795281 50.128504,4.796426 50.126505,4.79656 50.126368,4.797049 50.126248,4.796882 50.126007,4.796531 50.125363,4.796266 50.124711,4.796069 50.123956,4.795965 50.123505,4.795832 50.122535,4.796003 50.121322,4.796135 50.120614,4.796432 50.119844,4.797192 50.118368,4.798006 50.116934,4.79847 50.116073,4.79926 50.116147,4.800573 50.115842,4.802045 50.11516,4.802282 50.115043,4.80251 50.114983,4.802757 50.114846,4.803106 50.114761,4.803648 50.114478,4.806971 50.113594,4.808069 50.112899,4.80885 50.112621,4.809131 50.112559,4.808683 50.112213,4.807972 50.111166,4.807733 50.110929,4.808901 50.110737,4.80915 50.110657,4.809059 50.110371,4.808325 50.108753,4.80839 50.108662,4.808663 50.108521,4.809273 50.108149,4.809574 50.107156,4.809968 50.106654,4.81041 50.10626,4.811189 50.10591,4.81117 50.105543,4.811788 50.105306,4.812117 50.104895,4.812264 50.104526,4.812574 50.104133,4.813173 50.104058,4.813674 50.103921,4.813996 50.103855,4.814363 50.103727,4.814575 50.103419,4.814943 50.102999,4.815379 50.102393,4.815588 50.101673,4.815307 50.101633,4.815301 50.101498,4.81555 50.100865,4.81618 50.100923,4.816391 50.100915,4.818106 50.100955,4.818961 50.099566,4.819141 50.099139,4.819314 50.097906,4.81909 50.097331,4.819124 50.096831,4.818903 50.095264,4.818939 50.093414,4.818103 50.093454,4.817335 50.093233,4.815542 50.092646,4.81523 50.09259,4.815814 50.092319,4.815815 50.090918,4.81606 50.090153,4.816441 50.089737,4.816789 50.08973,4.817207 50.089431,4.818384 50.088082,4.819307 50.088144,4.822182 50.088399,4.822031 50.088178,4.821233 50.087566,4.819073 50.086487,4.818787 50.086358,4.817917 50.085703,4.817257 50.084848,4.816889 50.083646,4.816153 50.082488,4.815355 50.081245,4.815069 50.080542,4.814533 50.080275,4.813794 50.080173,4.813783 50.07994,4.814111 50.079529,4.815126 50.07928,4.815203 50.078854,4.815111 50.078607,4.816688 50.078737,4.817174 50.078739,4.817352 50.078286,4.816601 50.07803,4.816081 50.077809,4.815635 50.077596,4.815233 50.077363,4.814876 50.07709,4.814591 50.076826,4.81444 50.07651,4.814402 50.076017,4.814723 50.075674,4.815192 50.075114,4.815523 50.074818,4.816019 50.074247,4.816492 50.073764,4.816704 50.073527,4.816713 50.07334,4.816624 50.073071,4.816509 50.0729,4.816327 50.072237,4.816205 50.071863,4.815626 50.071097,4.81546 50.070781,4.815447 50.070502,4.815538 50.07023,4.815657 50.06957,4.815402 50.068957,4.815372 50.068678,4.815561 50.068249,4.815941 50.06771,4.816187 50.067521,4.816565 50.067281,4.817127 50.067115,4.817433 50.066945,4.817749 50.066639,4.818232 50.066368,4.818685 50.066209,4.819664 50.066063,4.819262 50.066085,4.819152 50.066036,4.819884 50.065614,4.820344 50.065592,4.820931 50.065229,4.821855 50.064618,4.822125 50.064213,4.821903 50.063995,4.821646 50.063833,4.821221 50.063661,4.821171 50.063429,4.821264 50.063302,4.821256 50.063192,4.8211 50.06294,4.820912 50.06277,4.820629 50.062578,4.820234 50.062363,4.82013 50.062356,4.819729 50.062153,4.819635 50.061896,4.819466 50.061829,4.819143 50.06161,4.819084 50.061514,4.81905 50.061234,4.81928 50.060921,4.81954 50.060682,4.819675 50.060625,4.819255 50.060403,4.818991 50.06039,4.818748 50.060463,4.818214 50.060707,4.817669 50.060749,4.816946 50.060746,4.816598 50.060728,4.816 50.060666,4.815305 50.060649,4.815029 50.060659,4.814128 50.060645,4.812635 50.060684,4.811901 50.060599,4.811513 50.060525,4.810918 50.060346,4.810424 50.059971,4.810068 50.059637,4.80929 50.058958,4.808441 50.058566,4.807624 50.058236,4.806707 50.058015,4.806034 50.057889,4.805308 50.057794,4.804902 50.057775,4.80412 50.057564,4.803689 50.057428,4.803063 50.057148,4.802176 50.05663,4.801534 50.056368,4.801069 50.056197,4.800327 50.056835,4.79933 50.057067,4.799143 50.057214,4.798695 50.057323,4.798364 50.057546,4.798061 50.058012,4.797036 50.058437,4.795757 50.058535,4.79445 50.058748,4.793932 50.058736,4.793863 50.058946,4.793984 50.059461,4.794038 50.059614,4.794197 50.059893,4.794458 50.060171,4.795037 50.060898,4.795137 50.061093,4.795758 50.061799,4.795804 50.062555,4.795403 50.063486,4.795301 50.063751,4.795013 50.06423,4.79452 50.064839,4.793035 50.066529,4.792389 50.067619,4.792259 50.067801,4.791458 50.069712,4.791138 50.070303,4.790963 50.07098,4.790102 50.073377,4.789895 50.074872,4.789593 50.075698,4.789444 50.0764,4.789188 50.077116,4.78917 50.077353,4.788988 50.077745,4.787434 50.080832,4.786433 50.082393,4.786141 50.083198,4.786366 50.084627,4.786715 50.085146,4.786436 50.085259,4.785323 50.085828,4.783791 50.086849,4.78294 50.087704,4.781951 50.089119,4.781631 50.09002,4.781423 50.090917,4.781294 50.092012,4.781327 50.092909,4.781515 50.093712,4.782269 50.094436,4.783345 50.095085,4.784853 50.095695,4.78608 50.09647,4.786821 50.09734,4.78757 50.098422,4.788287 50.099251,4.789344 50.100251,4.7903 50.100858,4.790963 50.101334,4.79112 50.101577,4.791295 50.102308,4.791382 50.103632,4.791223 50.104939,4.792142 50.105317,4.793102 50.106419,4.793192 50.106822,4.793068 50.107139,4.792242 50.107494,4.792309 50.107637,4.7923 50.107954,4.792085 50.108319,4.791797 50.10866,4.791234 50.109177,4.790411 50.109686,4.789205 50.111167,4.786813 50.113407,4.785342 50.11441,4.785901 50.114854,4.785347 50.115178,4.78538 50.11537,4.785175 50.115775,4.784927 50.116344,4.784994 50.116677,4.783058 50.117468,4.782114 50.118366,4.780504 50.11965,4.7795 50.120574,4.779122 50.120455,4.77873 50.1203,4.778229 50.120191,4.777644 50.120121,4.77737 50.12006,4.777232 50.120088,4.777105 50.120265,4.777943 50.1207,4.778843 50.121062,4.780257 50.12162,4.782584 50.122473,4.783966 50.123148,4.785462 50.123942,4.786352 50.124341,4.78687 50.124639,4.787542 50.124906,4.78792 50.125098,4.790681 50.126552,4.791535 50.126833,4.793195 50.127558,4.795128 50.128507)))"
    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"
]