Symfony Profiler

[
  "route" => "app_admin_stats"
  "route_parameters" => [
    "_route" => "app_admin_stats"
    "_controller" => "App\Controller\AdminController::stats"
    "insee_code" => "13061"
  ]
  "request_uri" => "https://osm-labo.cipherbliss.com/admin/stats/13061"
  "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 => "13061"
  ]
  "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 => 27642
  ]
  "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":"13061","nom":"13061"}"
    3 => "2026-07-14 03:24:39"
    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 => "13061"
  ]
  "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 => 27642
  ]
  "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 => "13061"
  ]
  "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 => "13061"
  ]
  "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 => "13061"
  ]
  "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.666667 43.847229,4.666594 43.847402,4.666403 43.847987,4.666322 43.84842,4.666186 43.848795,4.666088 43.84915,4.666012 43.849582,4.665979 43.849884,4.665862 43.850155,4.665709 43.850442,4.665566 43.850655,4.665285 43.850974,4.664797 43.851381,4.664446 43.851611,4.664006 43.851873,4.662984 43.852444,4.662277 43.852732,4.661957 43.852818,4.661589 43.852835,4.661344 43.852895,4.660817 43.853095,4.660522 43.853177,4.659904 43.853267,4.659385 43.8533,4.658798 43.853312,4.658134 43.853271,4.657473 43.853204,4.656801 43.853059,4.655926 43.852797,4.65519 43.852533,4.654565 43.852295,4.653878 43.852349,4.653059 43.852393,4.65229 43.852424,4.651584 43.852423,4.651071 43.852289,4.649648 43.85188,4.649061 43.851717,4.648291 43.851453,4.647637 43.851201,4.646975 43.850896,4.646212 43.850525,4.64616 43.850424,4.646047 43.850398,4.645202 43.849944,4.644953 43.849884,4.644557 43.850003,4.644019 43.850194,4.642026 43.850848,4.641256 43.851107,4.641335 43.851245,4.642742 43.854016,4.642862 43.85422,4.64304 43.854598,4.643241 43.854624,4.644004 43.854827,4.644725 43.85517,4.645217 43.855472,4.64604 43.856153,4.646267 43.85628,4.647068 43.856613,4.647311 43.856753,4.647449 43.856895,4.647614 43.857183,4.647751 43.85752,4.647879 43.858125,4.64797 43.858379,4.648379 43.859014,4.648351 43.859303,4.648283 43.859533,4.648057 43.860051,4.647713 43.860551,4.647594 43.860668,4.647147 43.860946,4.644663 43.862039,4.644466 43.862149,4.644126 43.862385,4.643649 43.862774,4.643226 43.863152,4.643077 43.863346,4.643054 43.863441,4.643081 43.863751,4.643217 43.864189,4.643239 43.864386,4.643207 43.864558,4.643115 43.864755,4.64293 43.86497,4.642558 43.865249,4.642365 43.865445,4.64232 43.865556,4.642214 43.865544,4.642076 43.866301,4.642155 43.866552,4.642112 43.866949,4.642076 43.867525,4.64286 43.867897,4.643642 43.868282,4.644419 43.868424,4.645857 43.868673,4.647479 43.868912,4.648511 43.869022,4.650528 43.869799,4.650746 43.870174,4.651701 43.87077,4.652205 43.870955,4.652273 43.87104,4.652195 43.871296,4.652244 43.87145,4.652971 43.871891,4.653522 43.872187,4.6544 43.872738,4.654668 43.872874,4.654875 43.872938,4.655151 43.873103,4.655549 43.873458,4.655732 43.873571,4.656047 43.873698,4.656183 43.873801,4.656331 43.874038,4.656523 43.874539,4.656743 43.874802,4.657087 43.874986,4.657664 43.875267,4.658117 43.875444,4.659057 43.875749,4.659503 43.875869,4.660013 43.875974,4.660545 43.875977,4.66074 43.875918,4.66236 43.87084,4.662379 43.870781,4.662578 43.870771,4.663285 43.868624,4.663357 43.868595,4.663933 43.868598,4.664261 43.867763,4.664634 43.866897,4.665187 43.865768,4.66543 43.865104,4.665536 43.864903,4.665672 43.864519,4.665818 43.864205,4.666088 43.863512,4.666294 43.863111,4.667458 43.860996,4.667756 43.860966,4.669916 43.860818,4.670474 43.860775,4.671024 43.860701,4.671563 43.860602,4.672194 43.860458,4.673221 43.860178,4.673503 43.860085,4.673406 43.859933,4.673963 43.859743,4.674254 43.859608,4.672856 43.857644,4.669182 43.849869,4.668112 43.8476,4.668106 43.847539,4.668012 43.847567,4.667664 43.847569,4.667267 43.847501,4.666788 43.847308,4.666667 43.847229)))"
    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.666667 43.847229,4.666594 43.847402,4.666403 43.847987,4.666322 43.84842,4.666186 43.848795,4.666088 43.84915,4.666012 43.849582,4.665979 43.849884,4.665862 43.850155,4.665709 43.850442,4.665566 43.850655,4.665285 43.850974,4.664797 43.851381,4.664446 43.851611,4.664006 43.851873,4.662984 43.852444,4.662277 43.852732,4.661957 43.852818,4.661589 43.852835,4.661344 43.852895,4.660817 43.853095,4.660522 43.853177,4.659904 43.853267,4.659385 43.8533,4.658798 43.853312,4.658134 43.853271,4.657473 43.853204,4.656801 43.853059,4.655926 43.852797,4.65519 43.852533,4.654565 43.852295,4.653878 43.852349,4.653059 43.852393,4.65229 43.852424,4.651584 43.852423,4.651071 43.852289,4.649648 43.85188,4.649061 43.851717,4.648291 43.851453,4.647637 43.851201,4.646975 43.850896,4.646212 43.850525,4.64616 43.850424,4.646047 43.850398,4.645202 43.849944,4.644953 43.849884,4.644557 43.850003,4.644019 43.850194,4.642026 43.850848,4.641256 43.851107,4.641335 43.851245,4.642742 43.854016,4.642862 43.85422,4.64304 43.854598,4.643241 43.854624,4.644004 43.854827,4.644725 43.85517,4.645217 43.855472,4.64604 43.856153,4.646267 43.85628,4.647068 43.856613,4.647311 43.856753,4.647449 43.856895,4.647614 43.857183,4.647751 43.85752,4.647879 43.858125,4.64797 43.858379,4.648379 43.859014,4.648351 43.859303,4.648283 43.859533,4.648057 43.860051,4.647713 43.860551,4.647594 43.860668,4.647147 43.860946,4.644663 43.862039,4.644466 43.862149,4.644126 43.862385,4.643649 43.862774,4.643226 43.863152,4.643077 43.863346,4.643054 43.863441,4.643081 43.863751,4.643217 43.864189,4.643239 43.864386,4.643207 43.864558,4.643115 43.864755,4.64293 43.86497,4.642558 43.865249,4.642365 43.865445,4.64232 43.865556,4.642214 43.865544,4.642076 43.866301,4.642155 43.866552,4.642112 43.866949,4.642076 43.867525,4.64286 43.867897,4.643642 43.868282,4.644419 43.868424,4.645857 43.868673,4.647479 43.868912,4.648511 43.869022,4.650528 43.869799,4.650746 43.870174,4.651701 43.87077,4.652205 43.870955,4.652273 43.87104,4.652195 43.871296,4.652244 43.87145,4.652971 43.871891,4.653522 43.872187,4.6544 43.872738,4.654668 43.872874,4.654875 43.872938,4.655151 43.873103,4.655549 43.873458,4.655732 43.873571,4.656047 43.873698,4.656183 43.873801,4.656331 43.874038,4.656523 43.874539,4.656743 43.874802,4.657087 43.874986,4.657664 43.875267,4.658117 43.875444,4.659057 43.875749,4.659503 43.875869,4.660013 43.875974,4.660545 43.875977,4.66074 43.875918,4.66236 43.87084,4.662379 43.870781,4.662578 43.870771,4.663285 43.868624,4.663357 43.868595,4.663933 43.868598,4.664261 43.867763,4.664634 43.866897,4.665187 43.865768,4.66543 43.865104,4.665536 43.864903,4.665672 43.864519,4.665818 43.864205,4.666088 43.863512,4.666294 43.863111,4.667458 43.860996,4.667756 43.860966,4.669916 43.860818,4.670474 43.860775,4.671024 43.860701,4.671563 43.860602,4.672194 43.860458,4.673221 43.860178,4.673503 43.860085,4.673406 43.859933,4.673963 43.859743,4.674254 43.859608,4.672856 43.857644,4.669182 43.849869,4.668112 43.8476,4.668106 43.847539,4.668012 43.847567,4.667664 43.847569,4.667267 43.847501,4.666788 43.847308,4.666667 43.847229)))"
  ]
  "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.666667 43.847229,4.666594 43.847402,4.666403 43.847987,4.666322 43.84842,4.666186 43.848795,4.666088 43.84915,4.666012 43.849582,4.665979 43.849884,4.665862 43.850155,4.665709 43.850442,4.665566 43.850655,4.665285 43.850974,4.664797 43.851381,4.664446 43.851611,4.664006 43.851873,4.662984 43.852444,4.662277 43.852732,4.661957 43.852818,4.661589 43.852835,4.661344 43.852895,4.660817 43.853095,4.660522 43.853177,4.659904 43.853267,4.659385 43.8533,4.658798 43.853312,4.658134 43.853271,4.657473 43.853204,4.656801 43.853059,4.655926 43.852797,4.65519 43.852533,4.654565 43.852295,4.653878 43.852349,4.653059 43.852393,4.65229 43.852424,4.651584 43.852423,4.651071 43.852289,4.649648 43.85188,4.649061 43.851717,4.648291 43.851453,4.647637 43.851201,4.646975 43.850896,4.646212 43.850525,4.64616 43.850424,4.646047 43.850398,4.645202 43.849944,4.644953 43.849884,4.644557 43.850003,4.644019 43.850194,4.642026 43.850848,4.641256 43.851107,4.641335 43.851245,4.642742 43.854016,4.642862 43.85422,4.64304 43.854598,4.643241 43.854624,4.644004 43.854827,4.644725 43.85517,4.645217 43.855472,4.64604 43.856153,4.646267 43.85628,4.647068 43.856613,4.647311 43.856753,4.647449 43.856895,4.647614 43.857183,4.647751 43.85752,4.647879 43.858125,4.64797 43.858379,4.648379 43.859014,4.648351 43.859303,4.648283 43.859533,4.648057 43.860051,4.647713 43.860551,4.647594 43.860668,4.647147 43.860946,4.644663 43.862039,4.644466 43.862149,4.644126 43.862385,4.643649 43.862774,4.643226 43.863152,4.643077 43.863346,4.643054 43.863441,4.643081 43.863751,4.643217 43.864189,4.643239 43.864386,4.643207 43.864558,4.643115 43.864755,4.64293 43.86497,4.642558 43.865249,4.642365 43.865445,4.64232 43.865556,4.642214 43.865544,4.642076 43.866301,4.642155 43.866552,4.642112 43.866949,4.642076 43.867525,4.64286 43.867897,4.643642 43.868282,4.644419 43.868424,4.645857 43.868673,4.647479 43.868912,4.648511 43.869022,4.650528 43.869799,4.650746 43.870174,4.651701 43.87077,4.652205 43.870955,4.652273 43.87104,4.652195 43.871296,4.652244 43.87145,4.652971 43.871891,4.653522 43.872187,4.6544 43.872738,4.654668 43.872874,4.654875 43.872938,4.655151 43.873103,4.655549 43.873458,4.655732 43.873571,4.656047 43.873698,4.656183 43.873801,4.656331 43.874038,4.656523 43.874539,4.656743 43.874802,4.657087 43.874986,4.657664 43.875267,4.658117 43.875444,4.659057 43.875749,4.659503 43.875869,4.660013 43.875974,4.660545 43.875977,4.66074 43.875918,4.66236 43.87084,4.662379 43.870781,4.662578 43.870771,4.663285 43.868624,4.663357 43.868595,4.663933 43.868598,4.664261 43.867763,4.664634 43.866897,4.665187 43.865768,4.66543 43.865104,4.665536 43.864903,4.665672 43.864519,4.665818 43.864205,4.666088 43.863512,4.666294 43.863111,4.667458 43.860996,4.667756 43.860966,4.669916 43.860818,4.670474 43.860775,4.671024 43.860701,4.671563 43.860602,4.672194 43.860458,4.673221 43.860178,4.673503 43.860085,4.673406 43.859933,4.673963 43.859743,4.674254 43.859608,4.672856 43.857644,4.669182 43.849869,4.668112 43.8476,4.668106 43.847539,4.668012 43.847567,4.667664 43.847569,4.667267 43.847501,4.666788 43.847308,4.666667 43.847229)))"
  ]
  "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.666667 43.847229,4.666594 43.847402,4.666403 43.847987,4.666322 43.84842,4.666186 43.848795,4.666088 43.84915,4.666012 43.849582,4.665979 43.849884,4.665862 43.850155,4.665709 43.850442,4.665566 43.850655,4.665285 43.850974,4.664797 43.851381,4.664446 43.851611,4.664006 43.851873,4.662984 43.852444,4.662277 43.852732,4.661957 43.852818,4.661589 43.852835,4.661344 43.852895,4.660817 43.853095,4.660522 43.853177,4.659904 43.853267,4.659385 43.8533,4.658798 43.853312,4.658134 43.853271,4.657473 43.853204,4.656801 43.853059,4.655926 43.852797,4.65519 43.852533,4.654565 43.852295,4.653878 43.852349,4.653059 43.852393,4.65229 43.852424,4.651584 43.852423,4.651071 43.852289,4.649648 43.85188,4.649061 43.851717,4.648291 43.851453,4.647637 43.851201,4.646975 43.850896,4.646212 43.850525,4.64616 43.850424,4.646047 43.850398,4.645202 43.849944,4.644953 43.849884,4.644557 43.850003,4.644019 43.850194,4.642026 43.850848,4.641256 43.851107,4.641335 43.851245,4.642742 43.854016,4.642862 43.85422,4.64304 43.854598,4.643241 43.854624,4.644004 43.854827,4.644725 43.85517,4.645217 43.855472,4.64604 43.856153,4.646267 43.85628,4.647068 43.856613,4.647311 43.856753,4.647449 43.856895,4.647614 43.857183,4.647751 43.85752,4.647879 43.858125,4.64797 43.858379,4.648379 43.859014,4.648351 43.859303,4.648283 43.859533,4.648057 43.860051,4.647713 43.860551,4.647594 43.860668,4.647147 43.860946,4.644663 43.862039,4.644466 43.862149,4.644126 43.862385,4.643649 43.862774,4.643226 43.863152,4.643077 43.863346,4.643054 43.863441,4.643081 43.863751,4.643217 43.864189,4.643239 43.864386,4.643207 43.864558,4.643115 43.864755,4.64293 43.86497,4.642558 43.865249,4.642365 43.865445,4.64232 43.865556,4.642214 43.865544,4.642076 43.866301,4.642155 43.866552,4.642112 43.866949,4.642076 43.867525,4.64286 43.867897,4.643642 43.868282,4.644419 43.868424,4.645857 43.868673,4.647479 43.868912,4.648511 43.869022,4.650528 43.869799,4.650746 43.870174,4.651701 43.87077,4.652205 43.870955,4.652273 43.87104,4.652195 43.871296,4.652244 43.87145,4.652971 43.871891,4.653522 43.872187,4.6544 43.872738,4.654668 43.872874,4.654875 43.872938,4.655151 43.873103,4.655549 43.873458,4.655732 43.873571,4.656047 43.873698,4.656183 43.873801,4.656331 43.874038,4.656523 43.874539,4.656743 43.874802,4.657087 43.874986,4.657664 43.875267,4.658117 43.875444,4.659057 43.875749,4.659503 43.875869,4.660013 43.875974,4.660545 43.875977,4.66074 43.875918,4.66236 43.87084,4.662379 43.870781,4.662578 43.870771,4.663285 43.868624,4.663357 43.868595,4.663933 43.868598,4.664261 43.867763,4.664634 43.866897,4.665187 43.865768,4.66543 43.865104,4.665536 43.864903,4.665672 43.864519,4.665818 43.864205,4.666088 43.863512,4.666294 43.863111,4.667458 43.860996,4.667756 43.860966,4.669916 43.860818,4.670474 43.860775,4.671024 43.860701,4.671563 43.860602,4.672194 43.860458,4.673221 43.860178,4.673503 43.860085,4.673406 43.859933,4.673963 43.859743,4.674254 43.859608,4.672856 43.857644,4.669182 43.849869,4.668112 43.8476,4.668106 43.847539,4.668012 43.847567,4.667664 43.847569,4.667267 43.847501,4.666788 43.847308,4.666667 43.847229)))"
  ]
  "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.666667 43.847229,4.666594 43.847402,4.666403 43.847987,4.666322 43.84842,4.666186 43.848795,4.666088 43.84915,4.666012 43.849582,4.665979 43.849884,4.665862 43.850155,4.665709 43.850442,4.665566 43.850655,4.665285 43.850974,4.664797 43.851381,4.664446 43.851611,4.664006 43.851873,4.662984 43.852444,4.662277 43.852732,4.661957 43.852818,4.661589 43.852835,4.661344 43.852895,4.660817 43.853095,4.660522 43.853177,4.659904 43.853267,4.659385 43.8533,4.658798 43.853312,4.658134 43.853271,4.657473 43.853204,4.656801 43.853059,4.655926 43.852797,4.65519 43.852533,4.654565 43.852295,4.653878 43.852349,4.653059 43.852393,4.65229 43.852424,4.651584 43.852423,4.651071 43.852289,4.649648 43.85188,4.649061 43.851717,4.648291 43.851453,4.647637 43.851201,4.646975 43.850896,4.646212 43.850525,4.64616 43.850424,4.646047 43.850398,4.645202 43.849944,4.644953 43.849884,4.644557 43.850003,4.644019 43.850194,4.642026 43.850848,4.641256 43.851107,4.641335 43.851245,4.642742 43.854016,4.642862 43.85422,4.64304 43.854598,4.643241 43.854624,4.644004 43.854827,4.644725 43.85517,4.645217 43.855472,4.64604 43.856153,4.646267 43.85628,4.647068 43.856613,4.647311 43.856753,4.647449 43.856895,4.647614 43.857183,4.647751 43.85752,4.647879 43.858125,4.64797 43.858379,4.648379 43.859014,4.648351 43.859303,4.648283 43.859533,4.648057 43.860051,4.647713 43.860551,4.647594 43.860668,4.647147 43.860946,4.644663 43.862039,4.644466 43.862149,4.644126 43.862385,4.643649 43.862774,4.643226 43.863152,4.643077 43.863346,4.643054 43.863441,4.643081 43.863751,4.643217 43.864189,4.643239 43.864386,4.643207 43.864558,4.643115 43.864755,4.64293 43.86497,4.642558 43.865249,4.642365 43.865445,4.64232 43.865556,4.642214 43.865544,4.642076 43.866301,4.642155 43.866552,4.642112 43.866949,4.642076 43.867525,4.64286 43.867897,4.643642 43.868282,4.644419 43.868424,4.645857 43.868673,4.647479 43.868912,4.648511 43.869022,4.650528 43.869799,4.650746 43.870174,4.651701 43.87077,4.652205 43.870955,4.652273 43.87104,4.652195 43.871296,4.652244 43.87145,4.652971 43.871891,4.653522 43.872187,4.6544 43.872738,4.654668 43.872874,4.654875 43.872938,4.655151 43.873103,4.655549 43.873458,4.655732 43.873571,4.656047 43.873698,4.656183 43.873801,4.656331 43.874038,4.656523 43.874539,4.656743 43.874802,4.657087 43.874986,4.657664 43.875267,4.658117 43.875444,4.659057 43.875749,4.659503 43.875869,4.660013 43.875974,4.660545 43.875977,4.66074 43.875918,4.66236 43.87084,4.662379 43.870781,4.662578 43.870771,4.663285 43.868624,4.663357 43.868595,4.663933 43.868598,4.664261 43.867763,4.664634 43.866897,4.665187 43.865768,4.66543 43.865104,4.665536 43.864903,4.665672 43.864519,4.665818 43.864205,4.666088 43.863512,4.666294 43.863111,4.667458 43.860996,4.667756 43.860966,4.669916 43.860818,4.670474 43.860775,4.671024 43.860701,4.671563 43.860602,4.672194 43.860458,4.673221 43.860178,4.673503 43.860085,4.673406 43.859933,4.673963 43.859743,4.674254 43.859608,4.672856 43.857644,4.669182 43.849869,4.668112 43.8476,4.668106 43.847539,4.668012 43.847567,4.667664 43.847569,4.667267 43.847501,4.666788 43.847308,4.666667 43.847229)))"
  ]
  "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 => 27642
  ]
  "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 => 27642
  ]
  "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.666667 43.847229,4.666594 43.847402,4.666403 43.847987,4.666322 43.84842,4.666186 43.848795,4.666088 43.84915,4.666012 43.849582,4.665979 43.849884,4.665862 43.850155,4.665709 43.850442,4.665566 43.850655,4.665285 43.850974,4.664797 43.851381,4.664446 43.851611,4.664006 43.851873,4.662984 43.852444,4.662277 43.852732,4.661957 43.852818,4.661589 43.852835,4.661344 43.852895,4.660817 43.853095,4.660522 43.853177,4.659904 43.853267,4.659385 43.8533,4.658798 43.853312,4.658134 43.853271,4.657473 43.853204,4.656801 43.853059,4.655926 43.852797,4.65519 43.852533,4.654565 43.852295,4.653878 43.852349,4.653059 43.852393,4.65229 43.852424,4.651584 43.852423,4.651071 43.852289,4.649648 43.85188,4.649061 43.851717,4.648291 43.851453,4.647637 43.851201,4.646975 43.850896,4.646212 43.850525,4.64616 43.850424,4.646047 43.850398,4.645202 43.849944,4.644953 43.849884,4.644557 43.850003,4.644019 43.850194,4.642026 43.850848,4.641256 43.851107,4.641335 43.851245,4.642742 43.854016,4.642862 43.85422,4.64304 43.854598,4.643241 43.854624,4.644004 43.854827,4.644725 43.85517,4.645217 43.855472,4.64604 43.856153,4.646267 43.85628,4.647068 43.856613,4.647311 43.856753,4.647449 43.856895,4.647614 43.857183,4.647751 43.85752,4.647879 43.858125,4.64797 43.858379,4.648379 43.859014,4.648351 43.859303,4.648283 43.859533,4.648057 43.860051,4.647713 43.860551,4.647594 43.860668,4.647147 43.860946,4.644663 43.862039,4.644466 43.862149,4.644126 43.862385,4.643649 43.862774,4.643226 43.863152,4.643077 43.863346,4.643054 43.863441,4.643081 43.863751,4.643217 43.864189,4.643239 43.864386,4.643207 43.864558,4.643115 43.864755,4.64293 43.86497,4.642558 43.865249,4.642365 43.865445,4.64232 43.865556,4.642214 43.865544,4.642076 43.866301,4.642155 43.866552,4.642112 43.866949,4.642076 43.867525,4.64286 43.867897,4.643642 43.868282,4.644419 43.868424,4.645857 43.868673,4.647479 43.868912,4.648511 43.869022,4.650528 43.869799,4.650746 43.870174,4.651701 43.87077,4.652205 43.870955,4.652273 43.87104,4.652195 43.871296,4.652244 43.87145,4.652971 43.871891,4.653522 43.872187,4.6544 43.872738,4.654668 43.872874,4.654875 43.872938,4.655151 43.873103,4.655549 43.873458,4.655732 43.873571,4.656047 43.873698,4.656183 43.873801,4.656331 43.874038,4.656523 43.874539,4.656743 43.874802,4.657087 43.874986,4.657664 43.875267,4.658117 43.875444,4.659057 43.875749,4.659503 43.875869,4.660013 43.875974,4.660545 43.875977,4.66074 43.875918,4.66236 43.87084,4.662379 43.870781,4.662578 43.870771,4.663285 43.868624,4.663357 43.868595,4.663933 43.868598,4.664261 43.867763,4.664634 43.866897,4.665187 43.865768,4.66543 43.865104,4.665536 43.864903,4.665672 43.864519,4.665818 43.864205,4.666088 43.863512,4.666294 43.863111,4.667458 43.860996,4.667756 43.860966,4.669916 43.860818,4.670474 43.860775,4.671024 43.860701,4.671563 43.860602,4.672194 43.860458,4.673221 43.860178,4.673503 43.860085,4.673406 43.859933,4.673963 43.859743,4.674254 43.859608,4.672856 43.857644,4.669182 43.849869,4.668112 43.8476,4.668106 43.847539,4.668012 43.847567,4.667664 43.847569,4.667267 43.847501,4.666788 43.847308,4.666667 43.847229)))"
    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.666667 43.847229,4.666594 43.847402,4.666403 43.847987,4.666322 43.84842,4.666186 43.848795,4.666088 43.84915,4.666012 43.849582,4.665979 43.849884,4.665862 43.850155,4.665709 43.850442,4.665566 43.850655,4.665285 43.850974,4.664797 43.851381,4.664446 43.851611,4.664006 43.851873,4.662984 43.852444,4.662277 43.852732,4.661957 43.852818,4.661589 43.852835,4.661344 43.852895,4.660817 43.853095,4.660522 43.853177,4.659904 43.853267,4.659385 43.8533,4.658798 43.853312,4.658134 43.853271,4.657473 43.853204,4.656801 43.853059,4.655926 43.852797,4.65519 43.852533,4.654565 43.852295,4.653878 43.852349,4.653059 43.852393,4.65229 43.852424,4.651584 43.852423,4.651071 43.852289,4.649648 43.85188,4.649061 43.851717,4.648291 43.851453,4.647637 43.851201,4.646975 43.850896,4.646212 43.850525,4.64616 43.850424,4.646047 43.850398,4.645202 43.849944,4.644953 43.849884,4.644557 43.850003,4.644019 43.850194,4.642026 43.850848,4.641256 43.851107,4.641335 43.851245,4.642742 43.854016,4.642862 43.85422,4.64304 43.854598,4.643241 43.854624,4.644004 43.854827,4.644725 43.85517,4.645217 43.855472,4.64604 43.856153,4.646267 43.85628,4.647068 43.856613,4.647311 43.856753,4.647449 43.856895,4.647614 43.857183,4.647751 43.85752,4.647879 43.858125,4.64797 43.858379,4.648379 43.859014,4.648351 43.859303,4.648283 43.859533,4.648057 43.860051,4.647713 43.860551,4.647594 43.860668,4.647147 43.860946,4.644663 43.862039,4.644466 43.862149,4.644126 43.862385,4.643649 43.862774,4.643226 43.863152,4.643077 43.863346,4.643054 43.863441,4.643081 43.863751,4.643217 43.864189,4.643239 43.864386,4.643207 43.864558,4.643115 43.864755,4.64293 43.86497,4.642558 43.865249,4.642365 43.865445,4.64232 43.865556,4.642214 43.865544,4.642076 43.866301,4.642155 43.866552,4.642112 43.866949,4.642076 43.867525,4.64286 43.867897,4.643642 43.868282,4.644419 43.868424,4.645857 43.868673,4.647479 43.868912,4.648511 43.869022,4.650528 43.869799,4.650746 43.870174,4.651701 43.87077,4.652205 43.870955,4.652273 43.87104,4.652195 43.871296,4.652244 43.87145,4.652971 43.871891,4.653522 43.872187,4.6544 43.872738,4.654668 43.872874,4.654875 43.872938,4.655151 43.873103,4.655549 43.873458,4.655732 43.873571,4.656047 43.873698,4.656183 43.873801,4.656331 43.874038,4.656523 43.874539,4.656743 43.874802,4.657087 43.874986,4.657664 43.875267,4.658117 43.875444,4.659057 43.875749,4.659503 43.875869,4.660013 43.875974,4.660545 43.875977,4.66074 43.875918,4.66236 43.87084,4.662379 43.870781,4.662578 43.870771,4.663285 43.868624,4.663357 43.868595,4.663933 43.868598,4.664261 43.867763,4.664634 43.866897,4.665187 43.865768,4.66543 43.865104,4.665536 43.864903,4.665672 43.864519,4.665818 43.864205,4.666088 43.863512,4.666294 43.863111,4.667458 43.860996,4.667756 43.860966,4.669916 43.860818,4.670474 43.860775,4.671024 43.860701,4.671563 43.860602,4.672194 43.860458,4.673221 43.860178,4.673503 43.860085,4.673406 43.859933,4.673963 43.859743,4.674254 43.859608,4.672856 43.857644,4.669182 43.849869,4.668112 43.8476,4.668106 43.847539,4.668012 43.847567,4.667664 43.847569,4.667267 43.847501,4.666788 43.847308,4.666667 43.847229)))"
  ]
  "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.666667 43.847229,4.666594 43.847402,4.666403 43.847987,4.666322 43.84842,4.666186 43.848795,4.666088 43.84915,4.666012 43.849582,4.665979 43.849884,4.665862 43.850155,4.665709 43.850442,4.665566 43.850655,4.665285 43.850974,4.664797 43.851381,4.664446 43.851611,4.664006 43.851873,4.662984 43.852444,4.662277 43.852732,4.661957 43.852818,4.661589 43.852835,4.661344 43.852895,4.660817 43.853095,4.660522 43.853177,4.659904 43.853267,4.659385 43.8533,4.658798 43.853312,4.658134 43.853271,4.657473 43.853204,4.656801 43.853059,4.655926 43.852797,4.65519 43.852533,4.654565 43.852295,4.653878 43.852349,4.653059 43.852393,4.65229 43.852424,4.651584 43.852423,4.651071 43.852289,4.649648 43.85188,4.649061 43.851717,4.648291 43.851453,4.647637 43.851201,4.646975 43.850896,4.646212 43.850525,4.64616 43.850424,4.646047 43.850398,4.645202 43.849944,4.644953 43.849884,4.644557 43.850003,4.644019 43.850194,4.642026 43.850848,4.641256 43.851107,4.641335 43.851245,4.642742 43.854016,4.642862 43.85422,4.64304 43.854598,4.643241 43.854624,4.644004 43.854827,4.644725 43.85517,4.645217 43.855472,4.64604 43.856153,4.646267 43.85628,4.647068 43.856613,4.647311 43.856753,4.647449 43.856895,4.647614 43.857183,4.647751 43.85752,4.647879 43.858125,4.64797 43.858379,4.648379 43.859014,4.648351 43.859303,4.648283 43.859533,4.648057 43.860051,4.647713 43.860551,4.647594 43.860668,4.647147 43.860946,4.644663 43.862039,4.644466 43.862149,4.644126 43.862385,4.643649 43.862774,4.643226 43.863152,4.643077 43.863346,4.643054 43.863441,4.643081 43.863751,4.643217 43.864189,4.643239 43.864386,4.643207 43.864558,4.643115 43.864755,4.64293 43.86497,4.642558 43.865249,4.642365 43.865445,4.64232 43.865556,4.642214 43.865544,4.642076 43.866301,4.642155 43.866552,4.642112 43.866949,4.642076 43.867525,4.64286 43.867897,4.643642 43.868282,4.644419 43.868424,4.645857 43.868673,4.647479 43.868912,4.648511 43.869022,4.650528 43.869799,4.650746 43.870174,4.651701 43.87077,4.652205 43.870955,4.652273 43.87104,4.652195 43.871296,4.652244 43.87145,4.652971 43.871891,4.653522 43.872187,4.6544 43.872738,4.654668 43.872874,4.654875 43.872938,4.655151 43.873103,4.655549 43.873458,4.655732 43.873571,4.656047 43.873698,4.656183 43.873801,4.656331 43.874038,4.656523 43.874539,4.656743 43.874802,4.657087 43.874986,4.657664 43.875267,4.658117 43.875444,4.659057 43.875749,4.659503 43.875869,4.660013 43.875974,4.660545 43.875977,4.66074 43.875918,4.66236 43.87084,4.662379 43.870781,4.662578 43.870771,4.663285 43.868624,4.663357 43.868595,4.663933 43.868598,4.664261 43.867763,4.664634 43.866897,4.665187 43.865768,4.66543 43.865104,4.665536 43.864903,4.665672 43.864519,4.665818 43.864205,4.666088 43.863512,4.666294 43.863111,4.667458 43.860996,4.667756 43.860966,4.669916 43.860818,4.670474 43.860775,4.671024 43.860701,4.671563 43.860602,4.672194 43.860458,4.673221 43.860178,4.673503 43.860085,4.673406 43.859933,4.673963 43.859743,4.674254 43.859608,4.672856 43.857644,4.669182 43.849869,4.668112 43.8476,4.668106 43.847539,4.668012 43.847567,4.667664 43.847569,4.667267 43.847501,4.666788 43.847308,4.666667 43.847229)))"
  ]
  "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.666667 43.847229,4.666594 43.847402,4.666403 43.847987,4.666322 43.84842,4.666186 43.848795,4.666088 43.84915,4.666012 43.849582,4.665979 43.849884,4.665862 43.850155,4.665709 43.850442,4.665566 43.850655,4.665285 43.850974,4.664797 43.851381,4.664446 43.851611,4.664006 43.851873,4.662984 43.852444,4.662277 43.852732,4.661957 43.852818,4.661589 43.852835,4.661344 43.852895,4.660817 43.853095,4.660522 43.853177,4.659904 43.853267,4.659385 43.8533,4.658798 43.853312,4.658134 43.853271,4.657473 43.853204,4.656801 43.853059,4.655926 43.852797,4.65519 43.852533,4.654565 43.852295,4.653878 43.852349,4.653059 43.852393,4.65229 43.852424,4.651584 43.852423,4.651071 43.852289,4.649648 43.85188,4.649061 43.851717,4.648291 43.851453,4.647637 43.851201,4.646975 43.850896,4.646212 43.850525,4.64616 43.850424,4.646047 43.850398,4.645202 43.849944,4.644953 43.849884,4.644557 43.850003,4.644019 43.850194,4.642026 43.850848,4.641256 43.851107,4.641335 43.851245,4.642742 43.854016,4.642862 43.85422,4.64304 43.854598,4.643241 43.854624,4.644004 43.854827,4.644725 43.85517,4.645217 43.855472,4.64604 43.856153,4.646267 43.85628,4.647068 43.856613,4.647311 43.856753,4.647449 43.856895,4.647614 43.857183,4.647751 43.85752,4.647879 43.858125,4.64797 43.858379,4.648379 43.859014,4.648351 43.859303,4.648283 43.859533,4.648057 43.860051,4.647713 43.860551,4.647594 43.860668,4.647147 43.860946,4.644663 43.862039,4.644466 43.862149,4.644126 43.862385,4.643649 43.862774,4.643226 43.863152,4.643077 43.863346,4.643054 43.863441,4.643081 43.863751,4.643217 43.864189,4.643239 43.864386,4.643207 43.864558,4.643115 43.864755,4.64293 43.86497,4.642558 43.865249,4.642365 43.865445,4.64232 43.865556,4.642214 43.865544,4.642076 43.866301,4.642155 43.866552,4.642112 43.866949,4.642076 43.867525,4.64286 43.867897,4.643642 43.868282,4.644419 43.868424,4.645857 43.868673,4.647479 43.868912,4.648511 43.869022,4.650528 43.869799,4.650746 43.870174,4.651701 43.87077,4.652205 43.870955,4.652273 43.87104,4.652195 43.871296,4.652244 43.87145,4.652971 43.871891,4.653522 43.872187,4.6544 43.872738,4.654668 43.872874,4.654875 43.872938,4.655151 43.873103,4.655549 43.873458,4.655732 43.873571,4.656047 43.873698,4.656183 43.873801,4.656331 43.874038,4.656523 43.874539,4.656743 43.874802,4.657087 43.874986,4.657664 43.875267,4.658117 43.875444,4.659057 43.875749,4.659503 43.875869,4.660013 43.875974,4.660545 43.875977,4.66074 43.875918,4.66236 43.87084,4.662379 43.870781,4.662578 43.870771,4.663285 43.868624,4.663357 43.868595,4.663933 43.868598,4.664261 43.867763,4.664634 43.866897,4.665187 43.865768,4.66543 43.865104,4.665536 43.864903,4.665672 43.864519,4.665818 43.864205,4.666088 43.863512,4.666294 43.863111,4.667458 43.860996,4.667756 43.860966,4.669916 43.860818,4.670474 43.860775,4.671024 43.860701,4.671563 43.860602,4.672194 43.860458,4.673221 43.860178,4.673503 43.860085,4.673406 43.859933,4.673963 43.859743,4.674254 43.859608,4.672856 43.857644,4.669182 43.849869,4.668112 43.8476,4.668106 43.847539,4.668012 43.847567,4.667664 43.847569,4.667267 43.847501,4.666788 43.847308,4.666667 43.847229)))"
    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"
]