Symfony Profiler

[
  "route" => "app_public_zone_places_history"
  "route_parameters" => [
    "_route" => "app_public_zone_places_history"
    "_controller" => "App\Controller\PublicController::zonePlacesHistory"
    "insee_code" => "01044"
  ]
  "request_uri" => "https://osm-labo.cipherbliss.com/city/01044/zone-places-history"
  "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 t0.id AS id_1, t0.zone AS zone_2, t0.completion_percent AS completion_percent_3, t0.places_count AS places_count_4, t0.avec_horaires AS avec_horaires_5, t0.avec_adresse AS avec_adresse_6, t0.avec_site AS avec_site_7, t0.avec_accessibilite AS avec_accessibilite_8, t0.avec_note AS avec_note_9, t0.name AS name_10, t0.population AS population_11, t0.siren AS siren_12, t0.code_epci AS code_epci_13, t0.codes_postaux AS codes_postaux_14, t0.date_created AS date_created_15, t0.date_modified AS date_modified_16, t0.avec_siret AS avec_siret_17, t0.avec_name AS avec_name_18, t0.avec_email AS avec_email_19, t0.osm_data_date_min AS osm_data_date_min_20, t0.osm_data_date_avg AS osm_data_date_avg_21, t0.osm_data_date_max AS osm_data_date_max_22, t0.budget_annuel AS budget_annuel_23, t0.lat AS lat_24, t0.lon AS lon_25, t0.date_labourage_requested AS date_labourage_requested_26, t0.date_labourage_done AS date_labourage_done_27, t0.kind AS kind_28 FROM stats t0 WHERE t0.zone = ? LIMIT 1"
  "params" => [
    1 => "01044"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#629
      +name: "STRING"
    }
  ]
]

[
  "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 {#629
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#629}
  ]
]

[
  "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 {#629
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#629}
  ]
]

[
  "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 => "01044"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#629
      +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 {#629
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#629}
  ]
]

[
  "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 => "01044"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#629
      +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 => "01044"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#629
      +name: "STRING"
    }
  ]
]

[
  "sql" => """
    SELECT h.osm_type, h.osm_id::text AS osm_id, h.version,\n
           h.tags::jsonb AS tags_json,\n
           h.valid_from AS osm_timestamp,\n
           h.changeset, h.osm_user, h.uid::bigint AS uid\n
    FROM osm_object_history h\n
    WHERE h.visible = true\n
      AND h.geom IS NOT NULL\n
      AND ST_Intersects(h.geom, ST_GeomFromText(?, 4326))\n
      AND h.valid_from >= ?::timestamptz\n
    ORDER BY h.valid_from DESC\n
    LIMIT ?
    """
  "params" => [
    1 => "MULTIPOLYGON(((5.720699 46.077825,5.71484 46.092867,5.716078 46.093416,5.717558 46.093856,5.718882 46.094017,5.719643 46.094007,5.720675 46.093721,5.721537 46.09328,5.721969 46.093073,5.722485 46.09299,5.724447 46.09302,5.724633 46.092074,5.726701 46.092095,5.727799 46.092074,5.730723 46.092029,5.731712 46.092442,5.732549 46.092949,5.733224 46.092707,5.733622 46.09264,5.733931 46.092852,5.73438 46.092741,5.734396 46.0918,5.736577 46.091936,5.737368 46.091704,5.738539 46.091972,5.739866 46.091663,5.740904 46.091991,5.742528 46.092666,5.744706 46.0935,5.746028 46.093287,5.746183 46.092183,5.74649 46.091677,5.749011 46.091177,5.750787 46.090584,5.751231 46.090399,5.751684 46.090048,5.752488 46.089973,5.753499 46.090897,5.756645 46.090691,5.757741 46.090675,5.75857 46.090757,5.758931 46.090731,5.759772 46.09073,5.759972 46.090767,5.761407 46.090774,5.762497 46.090402,5.763942 46.089972,5.764126 46.090208,5.770789 46.089459,5.771388 46.089572,5.771434 46.089107,5.771777 46.089166,5.771666 46.08977,5.771997 46.089809,5.772289 46.08924,5.773934 46.089107,5.774164 46.088922,5.774366 46.088804,5.775003 46.088605,5.775696 46.088173,5.776025 46.088003,5.776356 46.087668,5.776362 46.087572,5.776591 46.087221,5.776906 46.086978,5.777057 46.086903,5.777289 46.086668,5.777553 46.086458,5.778098 46.086095,5.778577 46.085494,5.778714 46.085271,5.779458 46.085005,5.779714 46.084844,5.780158 46.084694,5.780999 46.084531,5.781487 46.084427,5.781729 46.084313,5.781867 46.084168,5.782158 46.084042,5.783026 46.083853,5.783568 46.083709,5.783885 46.083594,5.784142 46.083433,5.784511 46.083279,5.785089 46.08322,5.7856 46.08323,5.786328 46.083208,5.786793 46.083167,5.787096 46.083084,5.787543 46.083092,5.788043 46.083162,5.788449 46.083201,5.788802 46.083165,5.789079 46.083066,5.789518 46.082968,5.790167 46.08288,5.790836 46.082828,5.791704 46.082738,5.792298 46.082694,5.79297 46.082677,5.793363 46.082756,5.793701 46.082756,5.79432 46.082552,5.794643 46.082537,5.794893 46.082564,5.795383 46.082663,5.79575 46.082808,5.79599 46.08294,5.796246 46.083164,5.796675 46.083304,5.797618 46.083696,5.798193 46.084002,5.798662 46.084388,5.799132 46.084543,5.799253 46.084012,5.800073 46.084152,5.800886 46.084397,5.801891 46.084967,5.802603 46.084759,5.803235 46.084773,5.803424 46.084197,5.804047 46.083809,5.804798 46.082404,5.805034 46.082027,5.805633 46.081786,5.805319 46.081406,5.806535 46.080429,5.807024 46.079985,5.807877 46.079148,5.808342 46.078763,5.808658 46.078545,5.809772 46.078679,5.810511 46.078701,5.811238 46.078517,5.811086 46.07797,5.811193 46.077294,5.811462 46.076484,5.811573 46.075875,5.811576 46.075329,5.811453 46.07489,5.811116 46.074506,5.81061 46.074193,5.810334 46.073528,5.810359 46.072822,5.81028 46.072178,5.809613 46.070489,5.809207 46.069083,5.808775 46.067747,5.808278 46.066098,5.807935 46.064977,5.807922 46.061968,5.806094 46.061659,5.805326 46.061877,5.805069 46.061932,5.804634 46.061973,5.804217 46.061978,5.803099 46.062164,5.802374 46.062794,5.801114 46.062716,5.800076 46.062538,5.799683 46.062698,5.79866 46.06315,5.797382 46.063285,5.795433 46.063421,5.795235 46.063558,5.794753 46.063621,5.794215 46.063658,5.793874 46.063783,5.79335 46.063823,5.792833 46.063915,5.79254 46.063998,5.792392 46.064117,5.792089 46.064568,5.791681 46.064781,5.791372 46.064889,5.791345 46.064752,5.791391 46.064145,5.791352 46.06391,5.790901 46.063939,5.789855 46.063618,5.789928 46.063489,5.788158 46.062913,5.787936 46.063569,5.787911 46.063783,5.787791 46.063933,5.787542 46.064163,5.787418 46.064483,5.787199 46.064729,5.787061 46.065049,5.786842 46.065731,5.786741 46.066187,5.786773 46.066503,5.787008 46.067126,5.787082 46.067426,5.787078 46.067544,5.786218 46.067765,5.786011 46.067797,5.785066 46.067837,5.782196 46.068058,5.780802 46.068021,5.778078 46.067489,5.778064 46.068152,5.775501 46.068317,5.775748 46.0688,5.77525 46.068925,5.774614 46.06881,5.773794 46.069114,5.773186 46.069351,5.77227 46.069566,5.772219 46.069792,5.772102 46.069976,5.771007 46.070055,5.770246 46.070303,5.768388 46.070475,5.768473 46.071056,5.768054 46.071115,5.768032 46.071527,5.767077 46.071706,5.76655 46.071792,5.766417 46.071623,5.765994 46.071628,5.765446 46.071724,5.765045 46.071947,5.764076 46.071976,5.763893 46.072163,5.761324 46.07248,5.758552 46.072982,5.758232 46.07251,5.757552 46.072626,5.757526 46.072816,5.757017 46.072973,5.756904 46.072717,5.756659 46.072769,5.755879 46.073118,5.755695 46.07288,5.75509 46.073254,5.754529 46.073562,5.754113 46.072999,5.753583 46.073299,5.752917 46.073508,5.751816 46.073676,5.751602 46.073145,5.750234 46.073313,5.746442 46.073751,5.743653 46.074396,5.742385 46.074794,5.741447 46.075318,5.740001 46.075993,5.738021 46.076412,5.736808 46.076772,5.736065 46.077062,5.735419 46.07721,5.734455 46.07733,5.73342 46.077316,5.729929 46.07674,5.729656 46.076741,5.729087 46.076645,5.728559 46.076607,5.728002 46.076492,5.727627 46.076535,5.727237 46.076556,5.726599 46.076637,5.724196 46.076737,5.72127 46.077545,5.720699 46.077825)))"
    2 => "2026-04-12 23:36:24+00:00"
    3 => 20001
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#629
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#629}
    3 => Doctrine\DBAL\ParameterType {#629}
  ]
]

[
  "sql" => """
    WITH zone AS (SELECT ST_GeomFromText(?, 4326) AS g),\n
    in_zone_prev AS (\n
      SELECT h.osm_type, h.osm_id, h.version, h.tags::jsonb AS tags_json\n
      FROM osm_object_history h, zone z\n
      WHERE h.geom IS NOT NULL AND ST_Intersects(h.geom, z.g)\n
    )\n
    SELECT del.osm_type, del.osm_id::text AS osm_id, del.version,\n
           prev.tags_json AS tags_json,\n
           del.valid_from AS osm_timestamp,\n
           del.changeset, del.osm_user, del.uid::bigint AS uid\n
    FROM osm_object_history del\n
    JOIN in_zone_prev 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 >= ?::timestamptz\n
    ORDER BY del.valid_from DESC\n
    LIMIT ?
    """
  "params" => [
    1 => "MULTIPOLYGON(((5.720699 46.077825,5.71484 46.092867,5.716078 46.093416,5.717558 46.093856,5.718882 46.094017,5.719643 46.094007,5.720675 46.093721,5.721537 46.09328,5.721969 46.093073,5.722485 46.09299,5.724447 46.09302,5.724633 46.092074,5.726701 46.092095,5.727799 46.092074,5.730723 46.092029,5.731712 46.092442,5.732549 46.092949,5.733224 46.092707,5.733622 46.09264,5.733931 46.092852,5.73438 46.092741,5.734396 46.0918,5.736577 46.091936,5.737368 46.091704,5.738539 46.091972,5.739866 46.091663,5.740904 46.091991,5.742528 46.092666,5.744706 46.0935,5.746028 46.093287,5.746183 46.092183,5.74649 46.091677,5.749011 46.091177,5.750787 46.090584,5.751231 46.090399,5.751684 46.090048,5.752488 46.089973,5.753499 46.090897,5.756645 46.090691,5.757741 46.090675,5.75857 46.090757,5.758931 46.090731,5.759772 46.09073,5.759972 46.090767,5.761407 46.090774,5.762497 46.090402,5.763942 46.089972,5.764126 46.090208,5.770789 46.089459,5.771388 46.089572,5.771434 46.089107,5.771777 46.089166,5.771666 46.08977,5.771997 46.089809,5.772289 46.08924,5.773934 46.089107,5.774164 46.088922,5.774366 46.088804,5.775003 46.088605,5.775696 46.088173,5.776025 46.088003,5.776356 46.087668,5.776362 46.087572,5.776591 46.087221,5.776906 46.086978,5.777057 46.086903,5.777289 46.086668,5.777553 46.086458,5.778098 46.086095,5.778577 46.085494,5.778714 46.085271,5.779458 46.085005,5.779714 46.084844,5.780158 46.084694,5.780999 46.084531,5.781487 46.084427,5.781729 46.084313,5.781867 46.084168,5.782158 46.084042,5.783026 46.083853,5.783568 46.083709,5.783885 46.083594,5.784142 46.083433,5.784511 46.083279,5.785089 46.08322,5.7856 46.08323,5.786328 46.083208,5.786793 46.083167,5.787096 46.083084,5.787543 46.083092,5.788043 46.083162,5.788449 46.083201,5.788802 46.083165,5.789079 46.083066,5.789518 46.082968,5.790167 46.08288,5.790836 46.082828,5.791704 46.082738,5.792298 46.082694,5.79297 46.082677,5.793363 46.082756,5.793701 46.082756,5.79432 46.082552,5.794643 46.082537,5.794893 46.082564,5.795383 46.082663,5.79575 46.082808,5.79599 46.08294,5.796246 46.083164,5.796675 46.083304,5.797618 46.083696,5.798193 46.084002,5.798662 46.084388,5.799132 46.084543,5.799253 46.084012,5.800073 46.084152,5.800886 46.084397,5.801891 46.084967,5.802603 46.084759,5.803235 46.084773,5.803424 46.084197,5.804047 46.083809,5.804798 46.082404,5.805034 46.082027,5.805633 46.081786,5.805319 46.081406,5.806535 46.080429,5.807024 46.079985,5.807877 46.079148,5.808342 46.078763,5.808658 46.078545,5.809772 46.078679,5.810511 46.078701,5.811238 46.078517,5.811086 46.07797,5.811193 46.077294,5.811462 46.076484,5.811573 46.075875,5.811576 46.075329,5.811453 46.07489,5.811116 46.074506,5.81061 46.074193,5.810334 46.073528,5.810359 46.072822,5.81028 46.072178,5.809613 46.070489,5.809207 46.069083,5.808775 46.067747,5.808278 46.066098,5.807935 46.064977,5.807922 46.061968,5.806094 46.061659,5.805326 46.061877,5.805069 46.061932,5.804634 46.061973,5.804217 46.061978,5.803099 46.062164,5.802374 46.062794,5.801114 46.062716,5.800076 46.062538,5.799683 46.062698,5.79866 46.06315,5.797382 46.063285,5.795433 46.063421,5.795235 46.063558,5.794753 46.063621,5.794215 46.063658,5.793874 46.063783,5.79335 46.063823,5.792833 46.063915,5.79254 46.063998,5.792392 46.064117,5.792089 46.064568,5.791681 46.064781,5.791372 46.064889,5.791345 46.064752,5.791391 46.064145,5.791352 46.06391,5.790901 46.063939,5.789855 46.063618,5.789928 46.063489,5.788158 46.062913,5.787936 46.063569,5.787911 46.063783,5.787791 46.063933,5.787542 46.064163,5.787418 46.064483,5.787199 46.064729,5.787061 46.065049,5.786842 46.065731,5.786741 46.066187,5.786773 46.066503,5.787008 46.067126,5.787082 46.067426,5.787078 46.067544,5.786218 46.067765,5.786011 46.067797,5.785066 46.067837,5.782196 46.068058,5.780802 46.068021,5.778078 46.067489,5.778064 46.068152,5.775501 46.068317,5.775748 46.0688,5.77525 46.068925,5.774614 46.06881,5.773794 46.069114,5.773186 46.069351,5.77227 46.069566,5.772219 46.069792,5.772102 46.069976,5.771007 46.070055,5.770246 46.070303,5.768388 46.070475,5.768473 46.071056,5.768054 46.071115,5.768032 46.071527,5.767077 46.071706,5.76655 46.071792,5.766417 46.071623,5.765994 46.071628,5.765446 46.071724,5.765045 46.071947,5.764076 46.071976,5.763893 46.072163,5.761324 46.07248,5.758552 46.072982,5.758232 46.07251,5.757552 46.072626,5.757526 46.072816,5.757017 46.072973,5.756904 46.072717,5.756659 46.072769,5.755879 46.073118,5.755695 46.07288,5.75509 46.073254,5.754529 46.073562,5.754113 46.072999,5.753583 46.073299,5.752917 46.073508,5.751816 46.073676,5.751602 46.073145,5.750234 46.073313,5.746442 46.073751,5.743653 46.074396,5.742385 46.074794,5.741447 46.075318,5.740001 46.075993,5.738021 46.076412,5.736808 46.076772,5.736065 46.077062,5.735419 46.07721,5.734455 46.07733,5.73342 46.077316,5.729929 46.07674,5.729656 46.076741,5.729087 46.076645,5.728559 46.076607,5.728002 46.076492,5.727627 46.076535,5.727237 46.076556,5.726599 46.076637,5.724196 46.076737,5.72127 46.077545,5.720699 46.077825)))"
    2 => "2026-04-12 23:36:24+00:00"
    3 => 20001
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#629
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#629}
    3 => Doctrine\DBAL\ParameterType {#629}
  ]
]

[
  "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 => 26604
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#651
      +name: "INTEGER"
    }
  ]
]

[
  "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"
]