Symfony Profiler

[
  "route" => "app_admin_stats"
  "route_parameters" => [
    "_route" => "app_admin_stats"
    "_controller" => "App\Controller\AdminController::stats"
    "insee_code" => "38546"
  ]
  "request_uri" => "https://osm-labo.cipherbliss.com/admin/stats/38546"
  "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 => "38546"
  ]
  "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 => 27667
  ]
  "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":"38546","nom":"38546"}"
    3 => "2026-07-13 03:19:35"
    4 => "https://osm-labo.cipherbliss.com/admin/labourer/38546?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 => "38546"
  ]
  "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 => 27667
  ]
  "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 => "38546"
  ]
  "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 => "38546"
  ]
  "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 => "38546"
  ]
  "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(((5.420565 45.614562,5.420375 45.614671,5.419863 45.614764,5.419596 45.614867,5.419266 45.615027,5.418362 45.615634,5.417838 45.615955,5.417511 45.616071,5.417132 45.616142,5.416728 45.616275,5.416347 45.616427,5.415145 45.616812,5.414641 45.616911,5.414128 45.616921,5.413567 45.617017,5.412859 45.617051,5.412614 45.617465,5.412418 45.617656,5.41205 45.617864,5.41182 45.618043,5.411466 45.618442,5.411255 45.618719,5.410993 45.618975,5.41064 45.619184,5.410236 45.619396,5.410038 45.619521,5.409487 45.619962,5.409287 45.620157,5.409158 45.620335,5.408659 45.621495,5.408274 45.621583,5.407126 45.621906,5.406982 45.621909,5.406721 45.621814,5.406624 45.621823,5.406213 45.622024,5.405741 45.622126,5.405449 45.622132,5.404775 45.622321,5.404548 45.622458,5.403735 45.622761,5.403332 45.62285,5.403114 45.622827,5.402849 45.622749,5.402176 45.622596,5.401873 45.622562,5.40133 45.622548,5.400607 45.622423,5.400154 45.622426,5.400316 45.62321,5.400467 45.623696,5.400742 45.624464,5.400881 45.624657,5.401132 45.624898,5.401387 45.625104,5.401772 45.625374,5.402131 45.62589,5.402341 45.626074,5.402545 45.62617,5.402856 45.626192,5.402908 45.626237,5.402602 45.626656,5.402017 45.627313,5.401804 45.627517,5.40164 45.627721,5.401438 45.628115,5.401222 45.62844,5.40094 45.628718,5.400657 45.628964,5.400429 45.629218,5.400302 45.629477,5.400266 45.629693,5.400303 45.629935,5.400115 45.63042,5.400003 45.63065,5.399677 45.631004,5.399255 45.631353,5.399034 45.63157,5.398847 45.631684,5.398947 45.631826,5.398745 45.632085,5.398566 45.632442,5.398135 45.6329,5.399824 45.63443,5.403718 45.643374,5.405668 45.64719,5.406224 45.648805,5.406734 45.648694,5.407077 45.648587,5.407546 45.648413,5.407916 45.648249,5.408792 45.647923,5.409679 45.647575,5.410251 45.647376,5.411541 45.647103,5.412496 45.646859,5.413345 45.646484,5.413733 45.646323,5.414066 45.646228,5.414799 45.646086,5.41585 45.645844,5.416888 45.645695,5.418213 45.645464,5.419154 45.645315,5.420672 45.645039,5.421617 45.645022,5.422057 45.645004,5.422743 45.644945,5.424083 45.644782,5.425059 45.644703,5.426188 45.644596,5.42732 45.644581,5.428349 45.644494,5.428602 45.64443,5.428895 45.644223,5.429016 45.644184,5.42963 45.644089,5.430107 45.643991,5.430519 45.643968,5.431112 45.643965,5.431898 45.643986,5.432043 45.643985,5.432216 45.643923,5.432711 45.644123,5.432726 45.644065,5.433115 45.643806,5.43326 45.643663,5.433363 45.643453,5.433403 45.64321,5.433499 45.643109,5.434854 45.64256,5.435223 45.642293,5.43544 45.643083,5.436284 45.643264,5.436385 45.643243,5.436854 45.642895,5.43684 45.64281,5.43715 45.642779,5.437376 45.642796,5.437845 45.642972,5.438355 45.642913,5.444535 45.640986,5.44663 45.64044,5.446532 45.640119,5.446357 45.639445,5.446176 45.638829,5.446062 45.638369,5.447182 45.637851,5.447177 45.637761,5.446972 45.637542,5.445848 45.635817,5.445215 45.635534,5.445033 45.635307,5.444211 45.634723,5.443331 45.634032,5.443048 45.633828,5.439855 45.635345,5.438927 45.63544,5.438725 45.635471,5.438549 45.635395,5.438286 45.634999,5.43772 45.634484,5.437385 45.634243,5.437109 45.634021,5.436863 45.633856,5.436298 45.633527,5.436143 45.633421,5.436098 45.633257,5.436282 45.632772,5.436377 45.63259,5.436835 45.631564,5.436906 45.631335,5.436926 45.630885,5.436855 45.630385,5.436923 45.630227,5.436729 45.629986,5.43674 45.629349,5.43678 45.628448,5.436584 45.628151,5.436382 45.627704,5.436547 45.62746,5.436511 45.627194,5.436615 45.626845,5.436785 45.626539,5.436817 45.625818,5.436988 45.62502,5.437299 45.62504,5.438091 45.625124,5.438331 45.625113,5.438382 45.624256,5.438397 45.623406,5.437986 45.623371,5.437654 45.622327,5.437034 45.621366,5.437593 45.620836,5.438035 45.620554,5.438852 45.620099,5.438836 45.61841,5.43925 45.618253,5.439134 45.618136,5.438635 45.617534,5.438513 45.617318,5.438472 45.617177,5.438449 45.616501,5.438345 45.616046,5.438323 45.615832,5.438236 45.61557,5.437845 45.615181,5.437524 45.615182,5.436354 45.615082,5.435862 45.615046,5.434343 45.614986,5.433453 45.614959,5.432877 45.614887,5.432238 45.614784,5.431832 45.614723,5.431579 45.614719,5.431085 45.614748,5.430544 45.614797,5.430003 45.614874,5.42964 45.614907,5.429293 45.614897,5.42879 45.614849,5.427512 45.614769,5.425718 45.614421,5.424453 45.614162,5.424189 45.614122,5.423701 45.614124,5.422922 45.614222,5.422234 45.614336,5.421165 45.614469,5.420565 45.614562)))"
    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(((5.420565 45.614562,5.420375 45.614671,5.419863 45.614764,5.419596 45.614867,5.419266 45.615027,5.418362 45.615634,5.417838 45.615955,5.417511 45.616071,5.417132 45.616142,5.416728 45.616275,5.416347 45.616427,5.415145 45.616812,5.414641 45.616911,5.414128 45.616921,5.413567 45.617017,5.412859 45.617051,5.412614 45.617465,5.412418 45.617656,5.41205 45.617864,5.41182 45.618043,5.411466 45.618442,5.411255 45.618719,5.410993 45.618975,5.41064 45.619184,5.410236 45.619396,5.410038 45.619521,5.409487 45.619962,5.409287 45.620157,5.409158 45.620335,5.408659 45.621495,5.408274 45.621583,5.407126 45.621906,5.406982 45.621909,5.406721 45.621814,5.406624 45.621823,5.406213 45.622024,5.405741 45.622126,5.405449 45.622132,5.404775 45.622321,5.404548 45.622458,5.403735 45.622761,5.403332 45.62285,5.403114 45.622827,5.402849 45.622749,5.402176 45.622596,5.401873 45.622562,5.40133 45.622548,5.400607 45.622423,5.400154 45.622426,5.400316 45.62321,5.400467 45.623696,5.400742 45.624464,5.400881 45.624657,5.401132 45.624898,5.401387 45.625104,5.401772 45.625374,5.402131 45.62589,5.402341 45.626074,5.402545 45.62617,5.402856 45.626192,5.402908 45.626237,5.402602 45.626656,5.402017 45.627313,5.401804 45.627517,5.40164 45.627721,5.401438 45.628115,5.401222 45.62844,5.40094 45.628718,5.400657 45.628964,5.400429 45.629218,5.400302 45.629477,5.400266 45.629693,5.400303 45.629935,5.400115 45.63042,5.400003 45.63065,5.399677 45.631004,5.399255 45.631353,5.399034 45.63157,5.398847 45.631684,5.398947 45.631826,5.398745 45.632085,5.398566 45.632442,5.398135 45.6329,5.399824 45.63443,5.403718 45.643374,5.405668 45.64719,5.406224 45.648805,5.406734 45.648694,5.407077 45.648587,5.407546 45.648413,5.407916 45.648249,5.408792 45.647923,5.409679 45.647575,5.410251 45.647376,5.411541 45.647103,5.412496 45.646859,5.413345 45.646484,5.413733 45.646323,5.414066 45.646228,5.414799 45.646086,5.41585 45.645844,5.416888 45.645695,5.418213 45.645464,5.419154 45.645315,5.420672 45.645039,5.421617 45.645022,5.422057 45.645004,5.422743 45.644945,5.424083 45.644782,5.425059 45.644703,5.426188 45.644596,5.42732 45.644581,5.428349 45.644494,5.428602 45.64443,5.428895 45.644223,5.429016 45.644184,5.42963 45.644089,5.430107 45.643991,5.430519 45.643968,5.431112 45.643965,5.431898 45.643986,5.432043 45.643985,5.432216 45.643923,5.432711 45.644123,5.432726 45.644065,5.433115 45.643806,5.43326 45.643663,5.433363 45.643453,5.433403 45.64321,5.433499 45.643109,5.434854 45.64256,5.435223 45.642293,5.43544 45.643083,5.436284 45.643264,5.436385 45.643243,5.436854 45.642895,5.43684 45.64281,5.43715 45.642779,5.437376 45.642796,5.437845 45.642972,5.438355 45.642913,5.444535 45.640986,5.44663 45.64044,5.446532 45.640119,5.446357 45.639445,5.446176 45.638829,5.446062 45.638369,5.447182 45.637851,5.447177 45.637761,5.446972 45.637542,5.445848 45.635817,5.445215 45.635534,5.445033 45.635307,5.444211 45.634723,5.443331 45.634032,5.443048 45.633828,5.439855 45.635345,5.438927 45.63544,5.438725 45.635471,5.438549 45.635395,5.438286 45.634999,5.43772 45.634484,5.437385 45.634243,5.437109 45.634021,5.436863 45.633856,5.436298 45.633527,5.436143 45.633421,5.436098 45.633257,5.436282 45.632772,5.436377 45.63259,5.436835 45.631564,5.436906 45.631335,5.436926 45.630885,5.436855 45.630385,5.436923 45.630227,5.436729 45.629986,5.43674 45.629349,5.43678 45.628448,5.436584 45.628151,5.436382 45.627704,5.436547 45.62746,5.436511 45.627194,5.436615 45.626845,5.436785 45.626539,5.436817 45.625818,5.436988 45.62502,5.437299 45.62504,5.438091 45.625124,5.438331 45.625113,5.438382 45.624256,5.438397 45.623406,5.437986 45.623371,5.437654 45.622327,5.437034 45.621366,5.437593 45.620836,5.438035 45.620554,5.438852 45.620099,5.438836 45.61841,5.43925 45.618253,5.439134 45.618136,5.438635 45.617534,5.438513 45.617318,5.438472 45.617177,5.438449 45.616501,5.438345 45.616046,5.438323 45.615832,5.438236 45.61557,5.437845 45.615181,5.437524 45.615182,5.436354 45.615082,5.435862 45.615046,5.434343 45.614986,5.433453 45.614959,5.432877 45.614887,5.432238 45.614784,5.431832 45.614723,5.431579 45.614719,5.431085 45.614748,5.430544 45.614797,5.430003 45.614874,5.42964 45.614907,5.429293 45.614897,5.42879 45.614849,5.427512 45.614769,5.425718 45.614421,5.424453 45.614162,5.424189 45.614122,5.423701 45.614124,5.422922 45.614222,5.422234 45.614336,5.421165 45.614469,5.420565 45.614562)))"
  ]
  "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(((5.420565 45.614562,5.420375 45.614671,5.419863 45.614764,5.419596 45.614867,5.419266 45.615027,5.418362 45.615634,5.417838 45.615955,5.417511 45.616071,5.417132 45.616142,5.416728 45.616275,5.416347 45.616427,5.415145 45.616812,5.414641 45.616911,5.414128 45.616921,5.413567 45.617017,5.412859 45.617051,5.412614 45.617465,5.412418 45.617656,5.41205 45.617864,5.41182 45.618043,5.411466 45.618442,5.411255 45.618719,5.410993 45.618975,5.41064 45.619184,5.410236 45.619396,5.410038 45.619521,5.409487 45.619962,5.409287 45.620157,5.409158 45.620335,5.408659 45.621495,5.408274 45.621583,5.407126 45.621906,5.406982 45.621909,5.406721 45.621814,5.406624 45.621823,5.406213 45.622024,5.405741 45.622126,5.405449 45.622132,5.404775 45.622321,5.404548 45.622458,5.403735 45.622761,5.403332 45.62285,5.403114 45.622827,5.402849 45.622749,5.402176 45.622596,5.401873 45.622562,5.40133 45.622548,5.400607 45.622423,5.400154 45.622426,5.400316 45.62321,5.400467 45.623696,5.400742 45.624464,5.400881 45.624657,5.401132 45.624898,5.401387 45.625104,5.401772 45.625374,5.402131 45.62589,5.402341 45.626074,5.402545 45.62617,5.402856 45.626192,5.402908 45.626237,5.402602 45.626656,5.402017 45.627313,5.401804 45.627517,5.40164 45.627721,5.401438 45.628115,5.401222 45.62844,5.40094 45.628718,5.400657 45.628964,5.400429 45.629218,5.400302 45.629477,5.400266 45.629693,5.400303 45.629935,5.400115 45.63042,5.400003 45.63065,5.399677 45.631004,5.399255 45.631353,5.399034 45.63157,5.398847 45.631684,5.398947 45.631826,5.398745 45.632085,5.398566 45.632442,5.398135 45.6329,5.399824 45.63443,5.403718 45.643374,5.405668 45.64719,5.406224 45.648805,5.406734 45.648694,5.407077 45.648587,5.407546 45.648413,5.407916 45.648249,5.408792 45.647923,5.409679 45.647575,5.410251 45.647376,5.411541 45.647103,5.412496 45.646859,5.413345 45.646484,5.413733 45.646323,5.414066 45.646228,5.414799 45.646086,5.41585 45.645844,5.416888 45.645695,5.418213 45.645464,5.419154 45.645315,5.420672 45.645039,5.421617 45.645022,5.422057 45.645004,5.422743 45.644945,5.424083 45.644782,5.425059 45.644703,5.426188 45.644596,5.42732 45.644581,5.428349 45.644494,5.428602 45.64443,5.428895 45.644223,5.429016 45.644184,5.42963 45.644089,5.430107 45.643991,5.430519 45.643968,5.431112 45.643965,5.431898 45.643986,5.432043 45.643985,5.432216 45.643923,5.432711 45.644123,5.432726 45.644065,5.433115 45.643806,5.43326 45.643663,5.433363 45.643453,5.433403 45.64321,5.433499 45.643109,5.434854 45.64256,5.435223 45.642293,5.43544 45.643083,5.436284 45.643264,5.436385 45.643243,5.436854 45.642895,5.43684 45.64281,5.43715 45.642779,5.437376 45.642796,5.437845 45.642972,5.438355 45.642913,5.444535 45.640986,5.44663 45.64044,5.446532 45.640119,5.446357 45.639445,5.446176 45.638829,5.446062 45.638369,5.447182 45.637851,5.447177 45.637761,5.446972 45.637542,5.445848 45.635817,5.445215 45.635534,5.445033 45.635307,5.444211 45.634723,5.443331 45.634032,5.443048 45.633828,5.439855 45.635345,5.438927 45.63544,5.438725 45.635471,5.438549 45.635395,5.438286 45.634999,5.43772 45.634484,5.437385 45.634243,5.437109 45.634021,5.436863 45.633856,5.436298 45.633527,5.436143 45.633421,5.436098 45.633257,5.436282 45.632772,5.436377 45.63259,5.436835 45.631564,5.436906 45.631335,5.436926 45.630885,5.436855 45.630385,5.436923 45.630227,5.436729 45.629986,5.43674 45.629349,5.43678 45.628448,5.436584 45.628151,5.436382 45.627704,5.436547 45.62746,5.436511 45.627194,5.436615 45.626845,5.436785 45.626539,5.436817 45.625818,5.436988 45.62502,5.437299 45.62504,5.438091 45.625124,5.438331 45.625113,5.438382 45.624256,5.438397 45.623406,5.437986 45.623371,5.437654 45.622327,5.437034 45.621366,5.437593 45.620836,5.438035 45.620554,5.438852 45.620099,5.438836 45.61841,5.43925 45.618253,5.439134 45.618136,5.438635 45.617534,5.438513 45.617318,5.438472 45.617177,5.438449 45.616501,5.438345 45.616046,5.438323 45.615832,5.438236 45.61557,5.437845 45.615181,5.437524 45.615182,5.436354 45.615082,5.435862 45.615046,5.434343 45.614986,5.433453 45.614959,5.432877 45.614887,5.432238 45.614784,5.431832 45.614723,5.431579 45.614719,5.431085 45.614748,5.430544 45.614797,5.430003 45.614874,5.42964 45.614907,5.429293 45.614897,5.42879 45.614849,5.427512 45.614769,5.425718 45.614421,5.424453 45.614162,5.424189 45.614122,5.423701 45.614124,5.422922 45.614222,5.422234 45.614336,5.421165 45.614469,5.420565 45.614562)))"
  ]
  "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(((5.420565 45.614562,5.420375 45.614671,5.419863 45.614764,5.419596 45.614867,5.419266 45.615027,5.418362 45.615634,5.417838 45.615955,5.417511 45.616071,5.417132 45.616142,5.416728 45.616275,5.416347 45.616427,5.415145 45.616812,5.414641 45.616911,5.414128 45.616921,5.413567 45.617017,5.412859 45.617051,5.412614 45.617465,5.412418 45.617656,5.41205 45.617864,5.41182 45.618043,5.411466 45.618442,5.411255 45.618719,5.410993 45.618975,5.41064 45.619184,5.410236 45.619396,5.410038 45.619521,5.409487 45.619962,5.409287 45.620157,5.409158 45.620335,5.408659 45.621495,5.408274 45.621583,5.407126 45.621906,5.406982 45.621909,5.406721 45.621814,5.406624 45.621823,5.406213 45.622024,5.405741 45.622126,5.405449 45.622132,5.404775 45.622321,5.404548 45.622458,5.403735 45.622761,5.403332 45.62285,5.403114 45.622827,5.402849 45.622749,5.402176 45.622596,5.401873 45.622562,5.40133 45.622548,5.400607 45.622423,5.400154 45.622426,5.400316 45.62321,5.400467 45.623696,5.400742 45.624464,5.400881 45.624657,5.401132 45.624898,5.401387 45.625104,5.401772 45.625374,5.402131 45.62589,5.402341 45.626074,5.402545 45.62617,5.402856 45.626192,5.402908 45.626237,5.402602 45.626656,5.402017 45.627313,5.401804 45.627517,5.40164 45.627721,5.401438 45.628115,5.401222 45.62844,5.40094 45.628718,5.400657 45.628964,5.400429 45.629218,5.400302 45.629477,5.400266 45.629693,5.400303 45.629935,5.400115 45.63042,5.400003 45.63065,5.399677 45.631004,5.399255 45.631353,5.399034 45.63157,5.398847 45.631684,5.398947 45.631826,5.398745 45.632085,5.398566 45.632442,5.398135 45.6329,5.399824 45.63443,5.403718 45.643374,5.405668 45.64719,5.406224 45.648805,5.406734 45.648694,5.407077 45.648587,5.407546 45.648413,5.407916 45.648249,5.408792 45.647923,5.409679 45.647575,5.410251 45.647376,5.411541 45.647103,5.412496 45.646859,5.413345 45.646484,5.413733 45.646323,5.414066 45.646228,5.414799 45.646086,5.41585 45.645844,5.416888 45.645695,5.418213 45.645464,5.419154 45.645315,5.420672 45.645039,5.421617 45.645022,5.422057 45.645004,5.422743 45.644945,5.424083 45.644782,5.425059 45.644703,5.426188 45.644596,5.42732 45.644581,5.428349 45.644494,5.428602 45.64443,5.428895 45.644223,5.429016 45.644184,5.42963 45.644089,5.430107 45.643991,5.430519 45.643968,5.431112 45.643965,5.431898 45.643986,5.432043 45.643985,5.432216 45.643923,5.432711 45.644123,5.432726 45.644065,5.433115 45.643806,5.43326 45.643663,5.433363 45.643453,5.433403 45.64321,5.433499 45.643109,5.434854 45.64256,5.435223 45.642293,5.43544 45.643083,5.436284 45.643264,5.436385 45.643243,5.436854 45.642895,5.43684 45.64281,5.43715 45.642779,5.437376 45.642796,5.437845 45.642972,5.438355 45.642913,5.444535 45.640986,5.44663 45.64044,5.446532 45.640119,5.446357 45.639445,5.446176 45.638829,5.446062 45.638369,5.447182 45.637851,5.447177 45.637761,5.446972 45.637542,5.445848 45.635817,5.445215 45.635534,5.445033 45.635307,5.444211 45.634723,5.443331 45.634032,5.443048 45.633828,5.439855 45.635345,5.438927 45.63544,5.438725 45.635471,5.438549 45.635395,5.438286 45.634999,5.43772 45.634484,5.437385 45.634243,5.437109 45.634021,5.436863 45.633856,5.436298 45.633527,5.436143 45.633421,5.436098 45.633257,5.436282 45.632772,5.436377 45.63259,5.436835 45.631564,5.436906 45.631335,5.436926 45.630885,5.436855 45.630385,5.436923 45.630227,5.436729 45.629986,5.43674 45.629349,5.43678 45.628448,5.436584 45.628151,5.436382 45.627704,5.436547 45.62746,5.436511 45.627194,5.436615 45.626845,5.436785 45.626539,5.436817 45.625818,5.436988 45.62502,5.437299 45.62504,5.438091 45.625124,5.438331 45.625113,5.438382 45.624256,5.438397 45.623406,5.437986 45.623371,5.437654 45.622327,5.437034 45.621366,5.437593 45.620836,5.438035 45.620554,5.438852 45.620099,5.438836 45.61841,5.43925 45.618253,5.439134 45.618136,5.438635 45.617534,5.438513 45.617318,5.438472 45.617177,5.438449 45.616501,5.438345 45.616046,5.438323 45.615832,5.438236 45.61557,5.437845 45.615181,5.437524 45.615182,5.436354 45.615082,5.435862 45.615046,5.434343 45.614986,5.433453 45.614959,5.432877 45.614887,5.432238 45.614784,5.431832 45.614723,5.431579 45.614719,5.431085 45.614748,5.430544 45.614797,5.430003 45.614874,5.42964 45.614907,5.429293 45.614897,5.42879 45.614849,5.427512 45.614769,5.425718 45.614421,5.424453 45.614162,5.424189 45.614122,5.423701 45.614124,5.422922 45.614222,5.422234 45.614336,5.421165 45.614469,5.420565 45.614562)))"
  ]
  "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 => 27667
  ]
  "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 => 27667
  ]
  "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(((5.420565 45.614562,5.420375 45.614671,5.419863 45.614764,5.419596 45.614867,5.419266 45.615027,5.418362 45.615634,5.417838 45.615955,5.417511 45.616071,5.417132 45.616142,5.416728 45.616275,5.416347 45.616427,5.415145 45.616812,5.414641 45.616911,5.414128 45.616921,5.413567 45.617017,5.412859 45.617051,5.412614 45.617465,5.412418 45.617656,5.41205 45.617864,5.41182 45.618043,5.411466 45.618442,5.411255 45.618719,5.410993 45.618975,5.41064 45.619184,5.410236 45.619396,5.410038 45.619521,5.409487 45.619962,5.409287 45.620157,5.409158 45.620335,5.408659 45.621495,5.408274 45.621583,5.407126 45.621906,5.406982 45.621909,5.406721 45.621814,5.406624 45.621823,5.406213 45.622024,5.405741 45.622126,5.405449 45.622132,5.404775 45.622321,5.404548 45.622458,5.403735 45.622761,5.403332 45.62285,5.403114 45.622827,5.402849 45.622749,5.402176 45.622596,5.401873 45.622562,5.40133 45.622548,5.400607 45.622423,5.400154 45.622426,5.400316 45.62321,5.400467 45.623696,5.400742 45.624464,5.400881 45.624657,5.401132 45.624898,5.401387 45.625104,5.401772 45.625374,5.402131 45.62589,5.402341 45.626074,5.402545 45.62617,5.402856 45.626192,5.402908 45.626237,5.402602 45.626656,5.402017 45.627313,5.401804 45.627517,5.40164 45.627721,5.401438 45.628115,5.401222 45.62844,5.40094 45.628718,5.400657 45.628964,5.400429 45.629218,5.400302 45.629477,5.400266 45.629693,5.400303 45.629935,5.400115 45.63042,5.400003 45.63065,5.399677 45.631004,5.399255 45.631353,5.399034 45.63157,5.398847 45.631684,5.398947 45.631826,5.398745 45.632085,5.398566 45.632442,5.398135 45.6329,5.399824 45.63443,5.403718 45.643374,5.405668 45.64719,5.406224 45.648805,5.406734 45.648694,5.407077 45.648587,5.407546 45.648413,5.407916 45.648249,5.408792 45.647923,5.409679 45.647575,5.410251 45.647376,5.411541 45.647103,5.412496 45.646859,5.413345 45.646484,5.413733 45.646323,5.414066 45.646228,5.414799 45.646086,5.41585 45.645844,5.416888 45.645695,5.418213 45.645464,5.419154 45.645315,5.420672 45.645039,5.421617 45.645022,5.422057 45.645004,5.422743 45.644945,5.424083 45.644782,5.425059 45.644703,5.426188 45.644596,5.42732 45.644581,5.428349 45.644494,5.428602 45.64443,5.428895 45.644223,5.429016 45.644184,5.42963 45.644089,5.430107 45.643991,5.430519 45.643968,5.431112 45.643965,5.431898 45.643986,5.432043 45.643985,5.432216 45.643923,5.432711 45.644123,5.432726 45.644065,5.433115 45.643806,5.43326 45.643663,5.433363 45.643453,5.433403 45.64321,5.433499 45.643109,5.434854 45.64256,5.435223 45.642293,5.43544 45.643083,5.436284 45.643264,5.436385 45.643243,5.436854 45.642895,5.43684 45.64281,5.43715 45.642779,5.437376 45.642796,5.437845 45.642972,5.438355 45.642913,5.444535 45.640986,5.44663 45.64044,5.446532 45.640119,5.446357 45.639445,5.446176 45.638829,5.446062 45.638369,5.447182 45.637851,5.447177 45.637761,5.446972 45.637542,5.445848 45.635817,5.445215 45.635534,5.445033 45.635307,5.444211 45.634723,5.443331 45.634032,5.443048 45.633828,5.439855 45.635345,5.438927 45.63544,5.438725 45.635471,5.438549 45.635395,5.438286 45.634999,5.43772 45.634484,5.437385 45.634243,5.437109 45.634021,5.436863 45.633856,5.436298 45.633527,5.436143 45.633421,5.436098 45.633257,5.436282 45.632772,5.436377 45.63259,5.436835 45.631564,5.436906 45.631335,5.436926 45.630885,5.436855 45.630385,5.436923 45.630227,5.436729 45.629986,5.43674 45.629349,5.43678 45.628448,5.436584 45.628151,5.436382 45.627704,5.436547 45.62746,5.436511 45.627194,5.436615 45.626845,5.436785 45.626539,5.436817 45.625818,5.436988 45.62502,5.437299 45.62504,5.438091 45.625124,5.438331 45.625113,5.438382 45.624256,5.438397 45.623406,5.437986 45.623371,5.437654 45.622327,5.437034 45.621366,5.437593 45.620836,5.438035 45.620554,5.438852 45.620099,5.438836 45.61841,5.43925 45.618253,5.439134 45.618136,5.438635 45.617534,5.438513 45.617318,5.438472 45.617177,5.438449 45.616501,5.438345 45.616046,5.438323 45.615832,5.438236 45.61557,5.437845 45.615181,5.437524 45.615182,5.436354 45.615082,5.435862 45.615046,5.434343 45.614986,5.433453 45.614959,5.432877 45.614887,5.432238 45.614784,5.431832 45.614723,5.431579 45.614719,5.431085 45.614748,5.430544 45.614797,5.430003 45.614874,5.42964 45.614907,5.429293 45.614897,5.42879 45.614849,5.427512 45.614769,5.425718 45.614421,5.424453 45.614162,5.424189 45.614122,5.423701 45.614124,5.422922 45.614222,5.422234 45.614336,5.421165 45.614469,5.420565 45.614562)))"
    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(((5.420565 45.614562,5.420375 45.614671,5.419863 45.614764,5.419596 45.614867,5.419266 45.615027,5.418362 45.615634,5.417838 45.615955,5.417511 45.616071,5.417132 45.616142,5.416728 45.616275,5.416347 45.616427,5.415145 45.616812,5.414641 45.616911,5.414128 45.616921,5.413567 45.617017,5.412859 45.617051,5.412614 45.617465,5.412418 45.617656,5.41205 45.617864,5.41182 45.618043,5.411466 45.618442,5.411255 45.618719,5.410993 45.618975,5.41064 45.619184,5.410236 45.619396,5.410038 45.619521,5.409487 45.619962,5.409287 45.620157,5.409158 45.620335,5.408659 45.621495,5.408274 45.621583,5.407126 45.621906,5.406982 45.621909,5.406721 45.621814,5.406624 45.621823,5.406213 45.622024,5.405741 45.622126,5.405449 45.622132,5.404775 45.622321,5.404548 45.622458,5.403735 45.622761,5.403332 45.62285,5.403114 45.622827,5.402849 45.622749,5.402176 45.622596,5.401873 45.622562,5.40133 45.622548,5.400607 45.622423,5.400154 45.622426,5.400316 45.62321,5.400467 45.623696,5.400742 45.624464,5.400881 45.624657,5.401132 45.624898,5.401387 45.625104,5.401772 45.625374,5.402131 45.62589,5.402341 45.626074,5.402545 45.62617,5.402856 45.626192,5.402908 45.626237,5.402602 45.626656,5.402017 45.627313,5.401804 45.627517,5.40164 45.627721,5.401438 45.628115,5.401222 45.62844,5.40094 45.628718,5.400657 45.628964,5.400429 45.629218,5.400302 45.629477,5.400266 45.629693,5.400303 45.629935,5.400115 45.63042,5.400003 45.63065,5.399677 45.631004,5.399255 45.631353,5.399034 45.63157,5.398847 45.631684,5.398947 45.631826,5.398745 45.632085,5.398566 45.632442,5.398135 45.6329,5.399824 45.63443,5.403718 45.643374,5.405668 45.64719,5.406224 45.648805,5.406734 45.648694,5.407077 45.648587,5.407546 45.648413,5.407916 45.648249,5.408792 45.647923,5.409679 45.647575,5.410251 45.647376,5.411541 45.647103,5.412496 45.646859,5.413345 45.646484,5.413733 45.646323,5.414066 45.646228,5.414799 45.646086,5.41585 45.645844,5.416888 45.645695,5.418213 45.645464,5.419154 45.645315,5.420672 45.645039,5.421617 45.645022,5.422057 45.645004,5.422743 45.644945,5.424083 45.644782,5.425059 45.644703,5.426188 45.644596,5.42732 45.644581,5.428349 45.644494,5.428602 45.64443,5.428895 45.644223,5.429016 45.644184,5.42963 45.644089,5.430107 45.643991,5.430519 45.643968,5.431112 45.643965,5.431898 45.643986,5.432043 45.643985,5.432216 45.643923,5.432711 45.644123,5.432726 45.644065,5.433115 45.643806,5.43326 45.643663,5.433363 45.643453,5.433403 45.64321,5.433499 45.643109,5.434854 45.64256,5.435223 45.642293,5.43544 45.643083,5.436284 45.643264,5.436385 45.643243,5.436854 45.642895,5.43684 45.64281,5.43715 45.642779,5.437376 45.642796,5.437845 45.642972,5.438355 45.642913,5.444535 45.640986,5.44663 45.64044,5.446532 45.640119,5.446357 45.639445,5.446176 45.638829,5.446062 45.638369,5.447182 45.637851,5.447177 45.637761,5.446972 45.637542,5.445848 45.635817,5.445215 45.635534,5.445033 45.635307,5.444211 45.634723,5.443331 45.634032,5.443048 45.633828,5.439855 45.635345,5.438927 45.63544,5.438725 45.635471,5.438549 45.635395,5.438286 45.634999,5.43772 45.634484,5.437385 45.634243,5.437109 45.634021,5.436863 45.633856,5.436298 45.633527,5.436143 45.633421,5.436098 45.633257,5.436282 45.632772,5.436377 45.63259,5.436835 45.631564,5.436906 45.631335,5.436926 45.630885,5.436855 45.630385,5.436923 45.630227,5.436729 45.629986,5.43674 45.629349,5.43678 45.628448,5.436584 45.628151,5.436382 45.627704,5.436547 45.62746,5.436511 45.627194,5.436615 45.626845,5.436785 45.626539,5.436817 45.625818,5.436988 45.62502,5.437299 45.62504,5.438091 45.625124,5.438331 45.625113,5.438382 45.624256,5.438397 45.623406,5.437986 45.623371,5.437654 45.622327,5.437034 45.621366,5.437593 45.620836,5.438035 45.620554,5.438852 45.620099,5.438836 45.61841,5.43925 45.618253,5.439134 45.618136,5.438635 45.617534,5.438513 45.617318,5.438472 45.617177,5.438449 45.616501,5.438345 45.616046,5.438323 45.615832,5.438236 45.61557,5.437845 45.615181,5.437524 45.615182,5.436354 45.615082,5.435862 45.615046,5.434343 45.614986,5.433453 45.614959,5.432877 45.614887,5.432238 45.614784,5.431832 45.614723,5.431579 45.614719,5.431085 45.614748,5.430544 45.614797,5.430003 45.614874,5.42964 45.614907,5.429293 45.614897,5.42879 45.614849,5.427512 45.614769,5.425718 45.614421,5.424453 45.614162,5.424189 45.614122,5.423701 45.614124,5.422922 45.614222,5.422234 45.614336,5.421165 45.614469,5.420565 45.614562)))"
  ]
  "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(((5.420565 45.614562,5.420375 45.614671,5.419863 45.614764,5.419596 45.614867,5.419266 45.615027,5.418362 45.615634,5.417838 45.615955,5.417511 45.616071,5.417132 45.616142,5.416728 45.616275,5.416347 45.616427,5.415145 45.616812,5.414641 45.616911,5.414128 45.616921,5.413567 45.617017,5.412859 45.617051,5.412614 45.617465,5.412418 45.617656,5.41205 45.617864,5.41182 45.618043,5.411466 45.618442,5.411255 45.618719,5.410993 45.618975,5.41064 45.619184,5.410236 45.619396,5.410038 45.619521,5.409487 45.619962,5.409287 45.620157,5.409158 45.620335,5.408659 45.621495,5.408274 45.621583,5.407126 45.621906,5.406982 45.621909,5.406721 45.621814,5.406624 45.621823,5.406213 45.622024,5.405741 45.622126,5.405449 45.622132,5.404775 45.622321,5.404548 45.622458,5.403735 45.622761,5.403332 45.62285,5.403114 45.622827,5.402849 45.622749,5.402176 45.622596,5.401873 45.622562,5.40133 45.622548,5.400607 45.622423,5.400154 45.622426,5.400316 45.62321,5.400467 45.623696,5.400742 45.624464,5.400881 45.624657,5.401132 45.624898,5.401387 45.625104,5.401772 45.625374,5.402131 45.62589,5.402341 45.626074,5.402545 45.62617,5.402856 45.626192,5.402908 45.626237,5.402602 45.626656,5.402017 45.627313,5.401804 45.627517,5.40164 45.627721,5.401438 45.628115,5.401222 45.62844,5.40094 45.628718,5.400657 45.628964,5.400429 45.629218,5.400302 45.629477,5.400266 45.629693,5.400303 45.629935,5.400115 45.63042,5.400003 45.63065,5.399677 45.631004,5.399255 45.631353,5.399034 45.63157,5.398847 45.631684,5.398947 45.631826,5.398745 45.632085,5.398566 45.632442,5.398135 45.6329,5.399824 45.63443,5.403718 45.643374,5.405668 45.64719,5.406224 45.648805,5.406734 45.648694,5.407077 45.648587,5.407546 45.648413,5.407916 45.648249,5.408792 45.647923,5.409679 45.647575,5.410251 45.647376,5.411541 45.647103,5.412496 45.646859,5.413345 45.646484,5.413733 45.646323,5.414066 45.646228,5.414799 45.646086,5.41585 45.645844,5.416888 45.645695,5.418213 45.645464,5.419154 45.645315,5.420672 45.645039,5.421617 45.645022,5.422057 45.645004,5.422743 45.644945,5.424083 45.644782,5.425059 45.644703,5.426188 45.644596,5.42732 45.644581,5.428349 45.644494,5.428602 45.64443,5.428895 45.644223,5.429016 45.644184,5.42963 45.644089,5.430107 45.643991,5.430519 45.643968,5.431112 45.643965,5.431898 45.643986,5.432043 45.643985,5.432216 45.643923,5.432711 45.644123,5.432726 45.644065,5.433115 45.643806,5.43326 45.643663,5.433363 45.643453,5.433403 45.64321,5.433499 45.643109,5.434854 45.64256,5.435223 45.642293,5.43544 45.643083,5.436284 45.643264,5.436385 45.643243,5.436854 45.642895,5.43684 45.64281,5.43715 45.642779,5.437376 45.642796,5.437845 45.642972,5.438355 45.642913,5.444535 45.640986,5.44663 45.64044,5.446532 45.640119,5.446357 45.639445,5.446176 45.638829,5.446062 45.638369,5.447182 45.637851,5.447177 45.637761,5.446972 45.637542,5.445848 45.635817,5.445215 45.635534,5.445033 45.635307,5.444211 45.634723,5.443331 45.634032,5.443048 45.633828,5.439855 45.635345,5.438927 45.63544,5.438725 45.635471,5.438549 45.635395,5.438286 45.634999,5.43772 45.634484,5.437385 45.634243,5.437109 45.634021,5.436863 45.633856,5.436298 45.633527,5.436143 45.633421,5.436098 45.633257,5.436282 45.632772,5.436377 45.63259,5.436835 45.631564,5.436906 45.631335,5.436926 45.630885,5.436855 45.630385,5.436923 45.630227,5.436729 45.629986,5.43674 45.629349,5.43678 45.628448,5.436584 45.628151,5.436382 45.627704,5.436547 45.62746,5.436511 45.627194,5.436615 45.626845,5.436785 45.626539,5.436817 45.625818,5.436988 45.62502,5.437299 45.62504,5.438091 45.625124,5.438331 45.625113,5.438382 45.624256,5.438397 45.623406,5.437986 45.623371,5.437654 45.622327,5.437034 45.621366,5.437593 45.620836,5.438035 45.620554,5.438852 45.620099,5.438836 45.61841,5.43925 45.618253,5.439134 45.618136,5.438635 45.617534,5.438513 45.617318,5.438472 45.617177,5.438449 45.616501,5.438345 45.616046,5.438323 45.615832,5.438236 45.61557,5.437845 45.615181,5.437524 45.615182,5.436354 45.615082,5.435862 45.615046,5.434343 45.614986,5.433453 45.614959,5.432877 45.614887,5.432238 45.614784,5.431832 45.614723,5.431579 45.614719,5.431085 45.614748,5.430544 45.614797,5.430003 45.614874,5.42964 45.614907,5.429293 45.614897,5.42879 45.614849,5.427512 45.614769,5.425718 45.614421,5.424453 45.614162,5.424189 45.614122,5.423701 45.614124,5.422922 45.614222,5.422234 45.614336,5.421165 45.614469,5.420565 45.614562)))"
  ]
  "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(((5.420565 45.614562,5.420375 45.614671,5.419863 45.614764,5.419596 45.614867,5.419266 45.615027,5.418362 45.615634,5.417838 45.615955,5.417511 45.616071,5.417132 45.616142,5.416728 45.616275,5.416347 45.616427,5.415145 45.616812,5.414641 45.616911,5.414128 45.616921,5.413567 45.617017,5.412859 45.617051,5.412614 45.617465,5.412418 45.617656,5.41205 45.617864,5.41182 45.618043,5.411466 45.618442,5.411255 45.618719,5.410993 45.618975,5.41064 45.619184,5.410236 45.619396,5.410038 45.619521,5.409487 45.619962,5.409287 45.620157,5.409158 45.620335,5.408659 45.621495,5.408274 45.621583,5.407126 45.621906,5.406982 45.621909,5.406721 45.621814,5.406624 45.621823,5.406213 45.622024,5.405741 45.622126,5.405449 45.622132,5.404775 45.622321,5.404548 45.622458,5.403735 45.622761,5.403332 45.62285,5.403114 45.622827,5.402849 45.622749,5.402176 45.622596,5.401873 45.622562,5.40133 45.622548,5.400607 45.622423,5.400154 45.622426,5.400316 45.62321,5.400467 45.623696,5.400742 45.624464,5.400881 45.624657,5.401132 45.624898,5.401387 45.625104,5.401772 45.625374,5.402131 45.62589,5.402341 45.626074,5.402545 45.62617,5.402856 45.626192,5.402908 45.626237,5.402602 45.626656,5.402017 45.627313,5.401804 45.627517,5.40164 45.627721,5.401438 45.628115,5.401222 45.62844,5.40094 45.628718,5.400657 45.628964,5.400429 45.629218,5.400302 45.629477,5.400266 45.629693,5.400303 45.629935,5.400115 45.63042,5.400003 45.63065,5.399677 45.631004,5.399255 45.631353,5.399034 45.63157,5.398847 45.631684,5.398947 45.631826,5.398745 45.632085,5.398566 45.632442,5.398135 45.6329,5.399824 45.63443,5.403718 45.643374,5.405668 45.64719,5.406224 45.648805,5.406734 45.648694,5.407077 45.648587,5.407546 45.648413,5.407916 45.648249,5.408792 45.647923,5.409679 45.647575,5.410251 45.647376,5.411541 45.647103,5.412496 45.646859,5.413345 45.646484,5.413733 45.646323,5.414066 45.646228,5.414799 45.646086,5.41585 45.645844,5.416888 45.645695,5.418213 45.645464,5.419154 45.645315,5.420672 45.645039,5.421617 45.645022,5.422057 45.645004,5.422743 45.644945,5.424083 45.644782,5.425059 45.644703,5.426188 45.644596,5.42732 45.644581,5.428349 45.644494,5.428602 45.64443,5.428895 45.644223,5.429016 45.644184,5.42963 45.644089,5.430107 45.643991,5.430519 45.643968,5.431112 45.643965,5.431898 45.643986,5.432043 45.643985,5.432216 45.643923,5.432711 45.644123,5.432726 45.644065,5.433115 45.643806,5.43326 45.643663,5.433363 45.643453,5.433403 45.64321,5.433499 45.643109,5.434854 45.64256,5.435223 45.642293,5.43544 45.643083,5.436284 45.643264,5.436385 45.643243,5.436854 45.642895,5.43684 45.64281,5.43715 45.642779,5.437376 45.642796,5.437845 45.642972,5.438355 45.642913,5.444535 45.640986,5.44663 45.64044,5.446532 45.640119,5.446357 45.639445,5.446176 45.638829,5.446062 45.638369,5.447182 45.637851,5.447177 45.637761,5.446972 45.637542,5.445848 45.635817,5.445215 45.635534,5.445033 45.635307,5.444211 45.634723,5.443331 45.634032,5.443048 45.633828,5.439855 45.635345,5.438927 45.63544,5.438725 45.635471,5.438549 45.635395,5.438286 45.634999,5.43772 45.634484,5.437385 45.634243,5.437109 45.634021,5.436863 45.633856,5.436298 45.633527,5.436143 45.633421,5.436098 45.633257,5.436282 45.632772,5.436377 45.63259,5.436835 45.631564,5.436906 45.631335,5.436926 45.630885,5.436855 45.630385,5.436923 45.630227,5.436729 45.629986,5.43674 45.629349,5.43678 45.628448,5.436584 45.628151,5.436382 45.627704,5.436547 45.62746,5.436511 45.627194,5.436615 45.626845,5.436785 45.626539,5.436817 45.625818,5.436988 45.62502,5.437299 45.62504,5.438091 45.625124,5.438331 45.625113,5.438382 45.624256,5.438397 45.623406,5.437986 45.623371,5.437654 45.622327,5.437034 45.621366,5.437593 45.620836,5.438035 45.620554,5.438852 45.620099,5.438836 45.61841,5.43925 45.618253,5.439134 45.618136,5.438635 45.617534,5.438513 45.617318,5.438472 45.617177,5.438449 45.616501,5.438345 45.616046,5.438323 45.615832,5.438236 45.61557,5.437845 45.615181,5.437524 45.615182,5.436354 45.615082,5.435862 45.615046,5.434343 45.614986,5.433453 45.614959,5.432877 45.614887,5.432238 45.614784,5.431832 45.614723,5.431579 45.614719,5.431085 45.614748,5.430544 45.614797,5.430003 45.614874,5.42964 45.614907,5.429293 45.614897,5.42879 45.614849,5.427512 45.614769,5.425718 45.614421,5.424453 45.614162,5.424189 45.614122,5.423701 45.614124,5.422922 45.614222,5.422234 45.614336,5.421165 45.614469,5.420565 45.614562)))"
    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"
]