Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.color AS color_3,
  c0_.position AS position_4,
  COUNT(a1_.id) AS sclr_5
FROM
  category c0_
  INNER JOIN article a1_ ON c0_.id = a1_.category_id
  AND (a1_.deleted_at IS NULL)
WHERE
  a1_.published_at IS NOT NULL
  AND a1_.published_at <= ?
  AND a1_.status <> ?
GROUP BY
  c0_.id
ORDER BY
  c0_.position ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.color AS color_3, c0_.position AS position_4, COUNT(a1_.id) AS sclr_5 FROM category c0_ INNER JOIN article a1_ ON c0_.id = a1_.category_id AND (a1_.deleted_at IS NULL) WHERE a1_.published_at IS NOT NULL AND a1_.published_at <= '2026-08-07 02:56:39' AND a1_.status <> 'DRAFT' GROUP BY c0_.id ORDER BY c0_.position ASC;

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.slug AS slug_2,
  p0_.description AS description_3,
  p0_.kind AS kind_4,
  p0_.external_url AS external_url_5,
  p0_.duration_seconds AS duration_seconds_6,
  p0_.episode_number AS episode_number_7,
  p0_.status AS status_8,
  p0_.published_at AS published_at_9,
  p0_.play_count AS play_count_10,
  p0_.allow_download AS allow_download_11,
  p0_.created_at AS created_at_12,
  p0_.updated_at AS updated_at_13,
  p0_.deleted_at AS deleted_at_14,
  p1_.id AS id_15,
  p1_.name AS name_16,
  p1_.slug AS slug_17,
  p1_.description AS description_18,
  p1_.author AS author_19,
  p1_.is_active AS is_active_20,
  m2_.id AS id_21,
  m2_.original_name AS original_name_22,
  m2_.file_name AS file_name_23,
  m2_.mime_type AS mime_type_24,
  m2_.size AS size_25,
  m2_.width AS width_26,
  m2_.height AS height_27,
  m2_.duration_seconds AS duration_seconds_28,
  m2_.alt AS alt_29,
  m2_.created_at AS created_at_30,
  m2_.deleted_at AS deleted_at_31,
  p0_.series_id AS series_id_32,
  p0_.media_file_id AS media_file_id_33,
  p0_.cover_image_id AS cover_image_id_34,
  p1_.cover_image_id AS cover_image_id_35,
  m2_.uploaded_by_id AS uploaded_by_id_36
FROM
  podcast p0_
  LEFT JOIN podcast_series p1_ ON p0_.series_id = p1_.id
  LEFT JOIN media m2_ ON p0_.cover_image_id = m2_.id
  AND (m2_.deleted_at IS NULL)
WHERE
  (
    p0_.status IN (?, ?)
    AND p0_.published_at IS NOT NULL
    AND p0_.published_at <= ?
  )
  AND (p0_.deleted_at IS NULL)
ORDER BY
  p0_.published_at DESC
LIMIT
  1000

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.kind AS kind_4, p0_.external_url AS external_url_5, p0_.duration_seconds AS duration_seconds_6, p0_.episode_number AS episode_number_7, p0_.status AS status_8, p0_.published_at AS published_at_9, p0_.play_count AS play_count_10, p0_.allow_download AS allow_download_11, p0_.created_at AS created_at_12, p0_.updated_at AS updated_at_13, p0_.deleted_at AS deleted_at_14, p1_.id AS id_15, p1_.name AS name_16, p1_.slug AS slug_17, p1_.description AS description_18, p1_.author AS author_19, p1_.is_active AS is_active_20, m2_.id AS id_21, m2_.original_name AS original_name_22, m2_.file_name AS file_name_23, m2_.mime_type AS mime_type_24, m2_.size AS size_25, m2_.width AS width_26, m2_.height AS height_27, m2_.duration_seconds AS duration_seconds_28, m2_.alt AS alt_29, m2_.created_at AS created_at_30, m2_.deleted_at AS deleted_at_31, p0_.series_id AS series_id_32, p0_.media_file_id AS media_file_id_33, p0_.cover_image_id AS cover_image_id_34, p1_.cover_image_id AS cover_image_id_35, m2_.uploaded_by_id AS uploaded_by_id_36 FROM podcast p0_ LEFT JOIN podcast_series p1_ ON p0_.series_id = p1_.id LEFT JOIN media m2_ ON p0_.cover_image_id = m2_.id AND (m2_.deleted_at IS NULL) WHERE (p0_.status IN ('PUBLISHED', 'SCHEDULED') AND p0_.published_at IS NOT NULL AND p0_.published_at <= '2026-08-07 02:56:39') AND (p0_.deleted_at IS NULL) ORDER BY p0_.published_at DESC LIMIT 1000;

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.slug AS slug_2,
  a0_.excerpt AS excerpt_3,
  a0_.content AS content_4,
  a0_.status AS status_5,
  a0_.published_at AS published_at_6,
  a0_.view_count AS view_count_7,
  a0_.meta_title AS meta_title_8,
  a0_.meta_description AS meta_description_9,
  a0_.created_at AS created_at_10,
  a0_.updated_at AS updated_at_11,
  a0_.deleted_at AS deleted_at_12,
  c1_.id AS id_13,
  c1_.name AS name_14,
  c1_.slug AS slug_15,
  c1_.color AS color_16,
  c1_.position AS position_17,
  m2_.id AS id_18,
  m2_.original_name AS original_name_19,
  m2_.file_name AS file_name_20,
  m2_.mime_type AS mime_type_21,
  m2_.size AS size_22,
  m2_.width AS width_23,
  m2_.height AS height_24,
  m2_.duration_seconds AS duration_seconds_25,
  m2_.alt AS alt_26,
  m2_.created_at AS created_at_27,
  m2_.deleted_at AS deleted_at_28,
  a0_.cover_image_id AS cover_image_id_29,
  a0_.category_id AS category_id_30,
  a0_.author_id AS author_id_31,
  m2_.uploaded_by_id AS uploaded_by_id_32
FROM
  article a0_
  LEFT JOIN category c1_ ON a0_.category_id = c1_.id
  LEFT JOIN media m2_ ON a0_.cover_image_id = m2_.id
  AND (m2_.deleted_at IS NULL)
WHERE
  (
    a0_.status IN (?, ?)
    AND a0_.published_at IS NOT NULL
    AND a0_.published_at <= ?
  )
  AND (a0_.deleted_at IS NULL)
ORDER BY
  a0_.published_at DESC
LIMIT
  1000

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.excerpt AS excerpt_3, a0_.content AS content_4, a0_.status AS status_5, a0_.published_at AS published_at_6, a0_.view_count AS view_count_7, a0_.meta_title AS meta_title_8, a0_.meta_description AS meta_description_9, a0_.created_at AS created_at_10, a0_.updated_at AS updated_at_11, a0_.deleted_at AS deleted_at_12, c1_.id AS id_13, c1_.name AS name_14, c1_.slug AS slug_15, c1_.color AS color_16, c1_.position AS position_17, m2_.id AS id_18, m2_.original_name AS original_name_19, m2_.file_name AS file_name_20, m2_.mime_type AS mime_type_21, m2_.size AS size_22, m2_.width AS width_23, m2_.height AS height_24, m2_.duration_seconds AS duration_seconds_25, m2_.alt AS alt_26, m2_.created_at AS created_at_27, m2_.deleted_at AS deleted_at_28, a0_.cover_image_id AS cover_image_id_29, a0_.category_id AS category_id_30, a0_.author_id AS author_id_31, m2_.uploaded_by_id AS uploaded_by_id_32 FROM article a0_ LEFT JOIN category c1_ ON a0_.category_id = c1_.id LEFT JOIN media m2_ ON a0_.cover_image_id = m2_.id AND (m2_.deleted_at IS NULL) WHERE (a0_.status IN ('PUBLISHED', 'SCHEDULED') AND a0_.published_at IS NOT NULL AND a0_.published_at <= '2026-08-07 02:56:39') AND (a0_.deleted_at IS NULL) ORDER BY a0_.published_at DESC LIMIT 1000;

SELECT
  t0.id AS id_1,
  t0.setting_key AS setting_key_2,
  t0.value AS value_3,
  t0.type AS type_4,
  t0.setting_group AS setting_group_5,
  t0.label AS label_6,
  t0.help_text AS help_text_7,
  t0.position AS position_8
FROM
  site_setting t0

SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.value AS value_3, t0.type AS type_4, t0.setting_group AS setting_group_5, t0.label AS label_6, t0.help_text AS help_text_7, t0.position AS position_8 FROM site_setting t0;

SELECT
  e0_.id AS id_0,
  e0_.title AS title_1,
  e0_.slug AS slug_2,
  e0_.description AS description_3,
  e0_.starts_at AS starts_at_4,
  e0_.ends_at AS ends_at_5,
  e0_.venue AS venue_6,
  e0_.address AS address_7,
  e0_.price AS price_8,
  e0_.external_link AS external_link_9,
  e0_.status AS status_10,
  e0_.created_at AS created_at_11,
  e0_.updated_at AS updated_at_12,
  e0_.deleted_at AS deleted_at_13,
  m1_.id AS id_14,
  m1_.original_name AS original_name_15,
  m1_.file_name AS file_name_16,
  m1_.mime_type AS mime_type_17,
  m1_.size AS size_18,
  m1_.width AS width_19,
  m1_.height AS height_20,
  m1_.duration_seconds AS duration_seconds_21,
  m1_.alt AS alt_22,
  m1_.created_at AS created_at_23,
  m1_.deleted_at AS deleted_at_24,
  e0_.poster_id AS poster_id_25,
  m1_.uploaded_by_id AS uploaded_by_id_26
FROM
  event e0_
  LEFT JOIN media m1_ ON e0_.poster_id = m1_.id
  AND (m1_.deleted_at IS NULL)
WHERE
  (
    e0_.status = ?
    AND COALESCE(e0_.ends_at, e0_.starts_at) >= ?
  )
  AND (e0_.deleted_at IS NULL)
ORDER BY
  e0_.starts_at ASC
LIMIT
  500

SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.slug AS slug_2, e0_.description AS description_3, e0_.starts_at AS starts_at_4, e0_.ends_at AS ends_at_5, e0_.venue AS venue_6, e0_.address AS address_7, e0_.price AS price_8, e0_.external_link AS external_link_9, e0_.status AS status_10, e0_.created_at AS created_at_11, e0_.updated_at AS updated_at_12, e0_.deleted_at AS deleted_at_13, m1_.id AS id_14, m1_.original_name AS original_name_15, m1_.file_name AS file_name_16, m1_.mime_type AS mime_type_17, m1_.size AS size_18, m1_.width AS width_19, m1_.height AS height_20, m1_.duration_seconds AS duration_seconds_21, m1_.alt AS alt_22, m1_.created_at AS created_at_23, m1_.deleted_at AS deleted_at_24, e0_.poster_id AS poster_id_25, m1_.uploaded_by_id AS uploaded_by_id_26 FROM event e0_ LEFT JOIN media m1_ ON e0_.poster_id = m1_.id AND (m1_.deleted_at IS NULL) WHERE (e0_.status = 'PUBLISHED' AND COALESCE(e0_.ends_at, e0_.starts_at) >= '2026-08-07 02:56:39') AND (e0_.deleted_at IS NULL) ORDER BY e0_.starts_at ASC LIMIT 500;

SELECT
  e0_.id AS id_0,
  e0_.title AS title_1,
  e0_.slug AS slug_2,
  e0_.description AS description_3,
  e0_.starts_at AS starts_at_4,
  e0_.ends_at AS ends_at_5,
  e0_.venue AS venue_6,
  e0_.address AS address_7,
  e0_.price AS price_8,
  e0_.external_link AS external_link_9,
  e0_.status AS status_10,
  e0_.created_at AS created_at_11,
  e0_.updated_at AS updated_at_12,
  e0_.deleted_at AS deleted_at_13,
  m1_.id AS id_14,
  m1_.original_name AS original_name_15,
  m1_.file_name AS file_name_16,
  m1_.mime_type AS mime_type_17,
  m1_.size AS size_18,
  m1_.width AS width_19,
  m1_.height AS height_20,
  m1_.duration_seconds AS duration_seconds_21,
  m1_.alt AS alt_22,
  m1_.created_at AS created_at_23,
  m1_.deleted_at AS deleted_at_24,
  e0_.poster_id AS poster_id_25,
  m1_.uploaded_by_id AS uploaded_by_id_26
FROM
  event e0_
  LEFT JOIN media m1_ ON e0_.poster_id = m1_.id
  AND (m1_.deleted_at IS NULL)
WHERE
  (
    e0_.status = ?
    AND COALESCE(e0_.ends_at, e0_.starts_at) < ?
  )
  AND (e0_.deleted_at IS NULL)
ORDER BY
  e0_.starts_at DESC
LIMIT
  500

SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.slug AS slug_2, e0_.description AS description_3, e0_.starts_at AS starts_at_4, e0_.ends_at AS ends_at_5, e0_.venue AS venue_6, e0_.address AS address_7, e0_.price AS price_8, e0_.external_link AS external_link_9, e0_.status AS status_10, e0_.created_at AS created_at_11, e0_.updated_at AS updated_at_12, e0_.deleted_at AS deleted_at_13, m1_.id AS id_14, m1_.original_name AS original_name_15, m1_.file_name AS file_name_16, m1_.mime_type AS mime_type_17, m1_.size AS size_18, m1_.width AS width_19, m1_.height AS height_20, m1_.duration_seconds AS duration_seconds_21, m1_.alt AS alt_22, m1_.created_at AS created_at_23, m1_.deleted_at AS deleted_at_24, e0_.poster_id AS poster_id_25, m1_.uploaded_by_id AS uploaded_by_id_26 FROM event e0_ LEFT JOIN media m1_ ON e0_.poster_id = m1_.id AND (m1_.deleted_at IS NULL) WHERE (e0_.status = 'PUBLISHED' AND COALESCE(e0_.ends_at, e0_.starts_at) < '2026-08-07 02:56:39') AND (e0_.deleted_at IS NULL) ORDER BY e0_.starts_at DESC LIMIT 500;