Symfony Profiler

SELECT
  COUNT(b0_.id) AS sclr_0
FROM
  blog_post b0_
WHERE
  b0_.is_published = ?

SELECT COUNT(b0_.id) AS sclr_0 FROM blog_post b0_ WHERE b0_.is_published = 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 = ?
  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 = 'blog_index_sidebar' AND p0_.status = 'active' LIMIT 1;

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.slug AS slug_2,
  b0_.sort_order AS sort_order_3,
  COUNT(b1_.id) AS sclr_4
FROM
  blog_category b0_
  LEFT JOIN blog_post b1_ ON b0_.id = b1_.category_id
  AND (b1_.is_published = ?)
GROUP BY
  b0_.id
ORDER BY
  b0_.sort_order ASC,
  b0_.name ASC

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.slug AS slug_2, b0_.sort_order AS sort_order_3, COUNT(b1_.id) AS sclr_4 FROM blog_category b0_ LEFT JOIN blog_post b1_ ON b0_.id = b1_.category_id AND (b1_.is_published = 1) GROUP BY b0_.id ORDER BY b0_.sort_order ASC, b0_.name ASC;

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.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;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        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
        FROM
          blog_post b0_
        WHERE
          b0_.is_published = ?
        ORDER BY
          b0_.created_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (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 FROM blog_post b0_ WHERE b0_.is_published = 1 ORDER BY b0_.created_at DESC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      created_at_4
    FROM
      (
        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
        FROM
          blog_post b0_
        WHERE
          b0_.is_published = ?
      ) dctrn_result_inner
    ORDER BY
      created_at_4 DESC
  ) dctrn_result
LIMIT
  6
OFFSET
  78

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, created_at_4 FROM (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 FROM blog_post b0_ WHERE b0_.is_published = 1) dctrn_result_inner ORDER BY created_at_4 DESC) dctrn_result LIMIT 6 OFFSET 78;

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 = ?
  AND b0_.id IN (?, ?, ?, ?, ?, ?)
ORDER BY
  b0_.created_at DESC

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 AND b0_.id IN (71, 70, 69, 68, 67, 66) ORDER BY b0_.created_at DESC;