Symfony Profiler

[
  "route" => "frontend_start"
  "route_parameters" => [
    "_route" => "frontend_start"
    "_controller" => "App\Controller\HomepageController::index"
  ]
  "request_uri" => "https://stripe.wetter.allgaeu-webmarketing.de/"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 2
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\UX\Turbo\Request\RequestListener::__invoke"
]

[
  "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\EventListener\ErrorListener::onControllerArguments"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "c10dbuser"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "c10wetter_allgaeu_webmarketing_de"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT w0_.id AS id_0, w0_.lat AS lat_1, w0_.lon AS lon_2, w0_.asl AS asl_3, w0_.request_type AS request_type_4, w0_.request_params AS request_params_5, w0_.response_data AS response_data_6, w0_.timestamp AS timestamp_7, w0_.place_name AS place_name_8 FROM weather_cache w0_ WHERE w0_.request_type LIKE ? AND w0_.timestamp >= ?"
  "params" => [
    1 => "basic-1h_sunmoon%"
    2 => "2026-07-18 02:48:35"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.lat AS lat_2, l0_.lon AS lon_3, l0_.asl AS asl_4, l0_.country AS country_5, l0_.iso2 AS iso2_6, l0_.admin1 AS admin1_7, l0_.postcodes AS postcodes_8, l0_.timezone AS timezone_9, l0_.population AS population_10, l0_.feature_class AS feature_class_11, l0_.feature_code AS feature_code_12, l0_.url AS url_13, l0_.external_id AS external_id_14, l0_.emma_id AS emma_id_15, l0_.emma_fallback AS emma_fallback_16 FROM location l0_ WHERE l0_.lat = ? AND l0_.lon = ? AND l0_.asl = ?"
  "params" => [
    1 => 47.2692
    2 => 11.4041
    3 => 574
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.content AS content_3, b0_.created_at AS created_at_4, b0_.image AS image_5, b0_.is_published AS is_published_6, b0_.meta_description AS meta_description_7, b0_.seo_keyword AS seo_keyword_8, b0_.article_type AS article_type_9, b0_.facebook_text AS facebook_text_10, b0_.instagram_caption AS instagram_caption_11, b0_.published_facebook AS published_facebook_12, b0_.facebook_published_at AS facebook_published_at_13, b0_.facebook_post_id AS facebook_post_id_14, b0_.published_instagram AS published_instagram_15, b0_.instagram_published_at AS instagram_published_at_16, b0_.instagram_post_id AS instagram_post_id_17, b0_.category_id AS category_id_18 FROM blog_post b0_ WHERE b0_.is_published = ? ORDER BY b0_.created_at DESC LIMIT 3"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 5
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.subtitle AS subtitle_3, p0_.monthly_price AS monthly_price_4, p0_.yearly_price AS yearly_price_5, p0_.currency AS currency_6, p0_.teaser AS teaser_7, p0_.update_interval_minutes AS update_interval_minutes_8, p0_.bullet_points AS bullet_points_9, p0_.is_active AS is_active_10, p0_.is_publicly_bookable AS is_publicly_bookable_11, p0_.sort_order AS sort_order_12, p0_.created_at AS created_at_13, p0_.attribute_values AS attribute_values_14, p0_.stripe_product_id AS stripe_product_id_15, p0_.stripe_price_monthly_id AS stripe_price_monthly_id_16, p0_.stripe_price_yearly_id AS stripe_price_yearly_id_17, p0_.request_type AS request_type_18 FROM package p0_ WHERE p0_.is_active = ? AND p0_.is_publicly_bookable = ? ORDER BY p0_.sort_order ASC"
  "params" => [
    1 => 1
    2 => 1
  ]
  "types" => [
    1 => 5
    2 => 5
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.category AS category_1, c0_.description AS description_2, c0_.image_path AS image_path_3, c0_.lat AS lat_4, c0_.lon AS lon_5, c0_.place AS place_6, c0_.region AS region_7, c0_.status AS status_8, c0_.created_at AS created_at_9, c0_.published_at AS published_at_10, c0_.expires_at AS expires_at_11, c0_.moderated_at AS moderated_at_12, c0_.reject_reason AS reject_reason_13, c0_.user_id AS user_id_14, c0_.moderated_by_id AS moderated_by_id_15 FROM community_weather_report c0_ WHERE c0_.status = ? AND (c0_.expires_at IS NULL OR c0_.expires_at > ?) ORDER BY c0_.published_at DESC LIMIT 3"
  "params" => [
    1 => "published"
    2 => "2026-07-18 04:48:35"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.client_name AS client_name_2, p0_.image_path AS image_path_3, p0_.target_url AS target_url_4, p0_.placement AS placement_5, p0_.width AS width_6, p0_.height AS height_7, p0_.limit_type AS limit_type_8, p0_.max_views AS max_views_9, p0_.max_clicks AS max_clicks_10, p0_.starts_at AS starts_at_11, p0_.ends_at AS ends_at_12, p0_.view_count AS view_count_13, p0_.click_count AS click_count_14, p0_.status AS status_15, p0_.created_at AS created_at_16, p0_.updated_at AS updated_at_17 FROM paid_banner p0_ WHERE p0_.placement = ? AND p0_.status = ? LIMIT 1"
  "params" => [
    1 => "homepage_leaderboard"
    2 => "active"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "UPDATE paid_banner SET view_count = view_count + 1, updated_at = ? WHERE id = ?"
  "params" => [
    1 => "2026-07-18 04:48:35"
    2 => 1
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.client_name AS client_name_3, t0.image_path AS image_path_4, t0.target_url AS target_url_5, t0.placement AS placement_6, t0.width AS width_7, t0.height AS height_8, t0.limit_type AS limit_type_9, t0.max_views AS max_views_10, t0.max_clicks AS max_clicks_11, t0.starts_at AS starts_at_12, t0.ends_at AS ends_at_13, t0.view_count AS view_count_14, t0.click_count AS click_count_15, t0.status AS status_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18 FROM paid_banner t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "key" => "homepage_content_v1"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.content AS content_2, t0.updated_at AS updated_at_3 FROM homepage_content t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "key" => "email_template_settings_v3"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.brand_name AS brand_name_2, t0.header_badge_text AS header_badge_text_3, t0.header_kicker AS header_kicker_4, t0.impressum_url AS impressum_url_5, t0.datenschutz_url AS datenschutz_url_6, t0.footer_html AS footer_html_7, t0.snippets AS snippets_8, t0.updated_at AS updated_at_9 FROM email_template_settings t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.tokens AS tokens_2, t0.updated_at AS updated_at_3 FROM app_theme_settings t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "key" => "app_theme_settings_v2"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "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\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\RememberMe\ResponseListener::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\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]