Symfony Profiler

[
  "route" => "app_public_zone_places_history"
  "route_parameters" => [
    "_route" => "app_public_zone_places_history"
    "_controller" => "App\Controller\PublicController::zonePlacesHistory"
    "insee_code" => "02118"
  ]
  "request_uri" => "https://osm-labo.cipherbliss.com/city/02118/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 => "02118"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#635
      +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 {#635
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#635}
  ]
]

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

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

[
  "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 => "02118"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#635
      +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 => "02118"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#635
      +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(((3.390405 49.421333,3.388772 49.42064,3.388326 49.422324,3.381462 49.420474,3.381348 49.420596,3.38046 49.420271,3.380196 49.420131,3.380677 49.419754,3.378427 49.418081,3.376614 49.415971,3.372461 49.417248,3.368794 49.418063,3.363348 49.418771,3.366686 49.421341,3.368897 49.424205,3.369358 49.423975,3.369827 49.423881,3.370073 49.423884,3.370862 49.42408,3.371379 49.424282,3.371548 49.424405,3.371665 49.424549,3.371648 49.424846,3.371673 49.424996,3.371815 49.425186,3.372392 49.425067,3.372319 49.425213,3.372299 49.425375,3.372328 49.425733,3.372932 49.42621,3.373217 49.426366,3.373062 49.426888,3.372953 49.426883,3.372733 49.427308,3.373276 49.427501,3.373486 49.427509,3.373746 49.42747,3.374405 49.427526,3.374694 49.427519,3.376151 49.427696,3.376033 49.428137,3.376219 49.428181,3.376257 49.428497,3.376954 49.428467,3.37737 49.428419,3.377693 49.428103,3.37792 49.428001,3.378344 49.428016,3.37859 49.428071,3.378905 49.428181,3.379765 49.426708,3.380027 49.426753,3.380109 49.426695,3.380291 49.426811,3.380519 49.426781,3.380826 49.426829,3.381218 49.426623,3.381372 49.426693,3.381438 49.426581,3.38162 49.426611,3.381675 49.426511,3.381644 49.426323,3.381511 49.426218,3.381585 49.426122,3.381988 49.426172,3.382117 49.426286,3.38224 49.426212,3.382545 49.426287,3.38287 49.426439,3.383365 49.426596,3.383437 49.426719,3.38361 49.42671,3.383876 49.426839,3.383791 49.426988,3.384253 49.42705,3.384418 49.427194,3.384651 49.427213,3.384946 49.427391,3.385614 49.427201,3.385901 49.427027,3.385853 49.426975,3.38649 49.42672,3.387024 49.426373,3.387972 49.425641,3.390405 49.421333)))"
    2 => "2026-04-16 00:20:53+00:00"
    3 => 20001
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#635
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#635}
    3 => Doctrine\DBAL\ParameterType {#635}
  ]
]

[
  "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(((3.390405 49.421333,3.388772 49.42064,3.388326 49.422324,3.381462 49.420474,3.381348 49.420596,3.38046 49.420271,3.380196 49.420131,3.380677 49.419754,3.378427 49.418081,3.376614 49.415971,3.372461 49.417248,3.368794 49.418063,3.363348 49.418771,3.366686 49.421341,3.368897 49.424205,3.369358 49.423975,3.369827 49.423881,3.370073 49.423884,3.370862 49.42408,3.371379 49.424282,3.371548 49.424405,3.371665 49.424549,3.371648 49.424846,3.371673 49.424996,3.371815 49.425186,3.372392 49.425067,3.372319 49.425213,3.372299 49.425375,3.372328 49.425733,3.372932 49.42621,3.373217 49.426366,3.373062 49.426888,3.372953 49.426883,3.372733 49.427308,3.373276 49.427501,3.373486 49.427509,3.373746 49.42747,3.374405 49.427526,3.374694 49.427519,3.376151 49.427696,3.376033 49.428137,3.376219 49.428181,3.376257 49.428497,3.376954 49.428467,3.37737 49.428419,3.377693 49.428103,3.37792 49.428001,3.378344 49.428016,3.37859 49.428071,3.378905 49.428181,3.379765 49.426708,3.380027 49.426753,3.380109 49.426695,3.380291 49.426811,3.380519 49.426781,3.380826 49.426829,3.381218 49.426623,3.381372 49.426693,3.381438 49.426581,3.38162 49.426611,3.381675 49.426511,3.381644 49.426323,3.381511 49.426218,3.381585 49.426122,3.381988 49.426172,3.382117 49.426286,3.38224 49.426212,3.382545 49.426287,3.38287 49.426439,3.383365 49.426596,3.383437 49.426719,3.38361 49.42671,3.383876 49.426839,3.383791 49.426988,3.384253 49.42705,3.384418 49.427194,3.384651 49.427213,3.384946 49.427391,3.385614 49.427201,3.385901 49.427027,3.385853 49.426975,3.38649 49.42672,3.387024 49.426373,3.387972 49.425641,3.390405 49.421333)))"
    2 => "2026-04-16 00:20:53+00:00"
    3 => 20001
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#635
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#635}
    3 => Doctrine\DBAL\ParameterType {#635}
  ]
]

[
  "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 => 27177
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#657
      +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"
]