Symfony Profiler

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 >= ?

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 'basic-1h_sunmoon%' AND w0_.timestamp >= '2026-07-18 02:48:35';

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 = ?

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 = 47.2692 AND l0_.lon = 11.4041 AND l0_.asl = 574;

UPDATE
  paid_banner
SET
  view_count = view_count + 1,
  updated_at = ?
WHERE
  id = ?

UPDATE paid_banner SET view_count = view_count + 1, updated_at = '2026-07-18 04:48:35' WHERE id = 1;

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

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 = 1 ORDER BY b0_.created_at DESC LIMIT 3;

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

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 = 'published' AND (c0_.expires_at IS NULL OR c0_.expires_at > '2026-07-18 04:48:35') ORDER BY c0_.published_at DESC LIMIT 3;

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

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 = 1 AND p0_.is_publicly_bookable = 1 ORDER BY p0_.sort_order ASC;

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

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 = 'homepage_leaderboard' AND p0_.status = 'active' LIMIT 1;

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 = ?

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 = 1;

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 = ?

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 = 1;

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 = ?

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 = 1;

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 = ?

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 = 1;