Symfony Profiler

SELECT 
  e0_.id AS id_0, 
  e0_.name AS name_1, 
  e0_.url AS url_2 
FROM 
  eemce_podcast_items e0_ 
WHERE 
  e0_.podcast_id = ? 
  AND (
    e0_.name LIKE ? 
    OR e0_.name LIKE ? 
    OR e0_.name LIKE ?
  )

SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.url AS url_2 FROM eemce_podcast_items e0_ WHERE e0_.podcast_id = 2 AND (e0_.name LIKE '%Apple%' OR e0_.name LIKE '%Spotify%' OR e0_.name LIKE '%Google%');

SELECT 
  a0_.id AS id_0, 
  a0_.slug AS slug_1, 
  a0_.upload_path AS upload_path_2, 
  a0_.title AS title_3, 
  a0_.excerpt AS excerpt_4, 
  a0_.date_start AS date_start_5, 
  b1_.title AS title_6, 
  MIN(c2_.id) AS sclr_7, 
  a0_.thumbnail AS thumbnail_8 
FROM 
  broadcast_has_article b3_ 
  LEFT JOIN articles a0_ ON (b3_.article_id = a0_.id) 
  LEFT JOIN broadcast b1_ ON (b3_.broadcast_id = b1_.id) 
  LEFT JOIN category_has_article c4_ ON (c4_.article_id = a0_.id) 
  LEFT JOIN categories c2_ ON (c4_.category_id = c2_.id) 
WHERE 
  b3_.broadcast_id = ? 
  AND a0_.status = true 
  AND a0_.date_start <= ? 
  AND (
    a0_.date_end >= ? 
    OR a0_.date_end IS NULL
  ) 
GROUP BY 
  a0_.id, 
  a0_.slug, 
  a0_.upload_path, 
  a0_.title, 
  a0_.excerpt, 
  a0_.date_start, 
  b1_.title 
ORDER BY 
  a0_.sticky DESC, 
  a0_.date_start DESC 
LIMIT 
  5

SELECT a0_.id AS id_0, a0_.slug AS slug_1, a0_.upload_path AS upload_path_2, a0_.title AS title_3, a0_.excerpt AS excerpt_4, a0_.date_start AS date_start_5, b1_.title AS title_6, MIN(c2_.id) AS sclr_7, a0_.thumbnail AS thumbnail_8 FROM broadcast_has_article b3_ LEFT JOIN articles a0_ ON (b3_.article_id = a0_.id) LEFT JOIN broadcast b1_ ON (b3_.broadcast_id = b1_.id) LEFT JOIN category_has_article c4_ ON (c4_.article_id = a0_.id) LEFT JOIN categories c2_ ON (c4_.category_id = c2_.id) WHERE b3_.broadcast_id = 2 AND a0_.status = true AND a0_.date_start <= '2025-07-11 11:07:13' AND (a0_.date_end >= '2025-07-11 11:07:13' OR a0_.date_end IS NULL) GROUP BY a0_.id, a0_.slug, a0_.upload_path, a0_.title, a0_.excerpt, a0_.date_start, b1_.title ORDER BY a0_.sticky DESC, a0_.date_start DESC LIMIT 5;

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.description AS description_3, 
  t0.subtitle AS subtitle_4, 
  t0.audio_file AS audio_file_5, 
  t0.guid AS guid_6, 
  t0.air_date AS air_date_7, 
  t0.url AS url_8, 
  t0.upload_path AS upload_path_9, 
  t0.sort AS sort_10, 
  t0.badge AS badge_11, 
  t0.uses_webp AS uses_webp_12, 
  t0.duration AS duration_13, 
  t0.podcast_id AS podcast_id_14 
FROM 
  eemce_podcast_items t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.subtitle AS subtitle_4, t0.audio_file AS audio_file_5, t0.guid AS guid_6, t0.air_date AS air_date_7, t0.url AS url_8, t0.upload_path AS upload_path_9, t0.sort AS sort_10, t0.badge AS badge_11, t0.uses_webp AS uses_webp_12, t0.duration AS duration_13, t0.podcast_id AS podcast_id_14 FROM eemce_podcast_items t0 WHERE t0.id = 869;

SELECT 
  m0_.id AS id_0, 
  m0_.parent AS parent_1, 
  m0_.menu AS menu_2, 
  m0_.item AS item_3, 
  m0_.title AS title_4, 
  m0_.url AS url_5, 
  m0_.type AS type_6, 
  m0_.target AS target_7, 
  m0_.rel AS rel_8, 
  m0_.class_selector AS class_selector_9, 
  m0_.date_start AS date_start_10, 
  m0_.date_end AS date_end_11, 
  m0_.status AS status_12, 
  m0_.sort AS sort_13 
FROM 
  menu_items m0_ 
WHERE 
  m0_.status = true 
  AND m0_.date_start <= ? 
  AND (
    m0_.date_end >= ? 
    OR m0_.date_end IS NULL
  ) 
  AND m0_.menu = ? 
  AND m0_.parent = ? 
ORDER BY 
  m0_.sort ASC

SELECT m0_.id AS id_0, m0_.parent AS parent_1, m0_.menu AS menu_2, m0_.item AS item_3, m0_.title AS title_4, m0_.url AS url_5, m0_.type AS type_6, m0_.target AS target_7, m0_.rel AS rel_8, m0_.class_selector AS class_selector_9, m0_.date_start AS date_start_10, m0_.date_end AS date_end_11, m0_.status AS status_12, m0_.sort AS sort_13 FROM menu_items m0_ WHERE m0_.status = true AND m0_.date_start <= '2025-07-11 11:00:00' AND (m0_.date_end >= '2025-07-11 11:00:00' OR m0_.date_end IS NULL) AND m0_.menu = 1 AND m0_.parent = 0 ORDER BY m0_.sort ASC;

SELECT 
  a0_.id AS id_0, 
  a0_.slug AS slug_1, 
  a0_.upload_path AS upload_path_2, 
  a0_.title AS title_3, 
  a0_.excerpt AS excerpt_4, 
  a0_.date_start AS date_start_5, 
  a0_.thumbnail AS thumbnail_6, 
  c1_.title AS title_7 
FROM 
  category_has_article c2_ 
  LEFT JOIN articles a0_ ON (c2_.article_id = a0_.id) 
  LEFT JOIN categories c1_ ON (c2_.category_id = c1_.id) 
WHERE 
  c2_.category_id = ? 
  AND a0_.status = true 
  AND a0_.date_start <= ? 
  AND (
    a0_.date_end >= ? 
    OR a0_.date_end IS NULL
  ) 
ORDER BY 
  a0_.sticky DESC, 
  a0_.date_start DESC 
LIMIT 
  12

SELECT a0_.id AS id_0, a0_.slug AS slug_1, a0_.upload_path AS upload_path_2, a0_.title AS title_3, a0_.excerpt AS excerpt_4, a0_.date_start AS date_start_5, a0_.thumbnail AS thumbnail_6, c1_.title AS title_7 FROM category_has_article c2_ LEFT JOIN articles a0_ ON (c2_.article_id = a0_.id) LEFT JOIN categories c1_ ON (c2_.category_id = c1_.id) WHERE c2_.category_id = 202 AND a0_.status = true AND a0_.date_start <= '2025-07-11 11:07:12' AND (a0_.date_end >= '2025-07-11 11:07:12' OR a0_.date_end IS NULL) ORDER BY a0_.sticky DESC, a0_.date_start DESC LIMIT 12;

SELECT 
  c0_.id AS id_0, 
  c0_.title AS title_1, 
  c0_.slug AS slug_2 
FROM 
  categories c0_ 
WHERE 
  c0_.id IN (?)

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.slug AS slug_2 FROM categories c0_ WHERE c0_.id IN (202, 200, 59, 2095, 201);

SELECT 
  t0.id AS id_1, 
  t0.title AS title_2, 
  t0.slug AS slug_3, 
  t0.image AS image_4, 
  t0.color AS color_5, 
  t0.description AS description_6, 
  t0.author AS author_7, 
  t0.author_avatar AS author_avatar_8, 
  t0.author_bio AS author_bio_9, 
  t0.video AS video_10, 
  t0.video_poster AS video_poster_11, 
  t0.video_description AS video_description_12, 
  t0.upload_path AS upload_path_13, 
  t0.status AS status_14, 
  t0.seo_title AS seo_title_15, 
  t0.seo_description AS seo_description_16, 
  t0.creation_date AS creation_date_17, 
  t0.gemius_code AS gemius_code_18, 
  t0.sort AS sort_19, 
  t0.uses_webp AS uses_webp_20 
FROM 
  broadcast t0 
WHERE 
  t0.id = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.image AS image_4, t0.color AS color_5, t0.description AS description_6, t0.author AS author_7, t0.author_avatar AS author_avatar_8, t0.author_bio AS author_bio_9, t0.video AS video_10, t0.video_poster AS video_poster_11, t0.video_description AS video_description_12, t0.upload_path AS upload_path_13, t0.status AS status_14, t0.seo_title AS seo_title_15, t0.seo_description AS seo_description_16, t0.creation_date AS creation_date_17, t0.gemius_code AS gemius_code_18, t0.sort AS sort_19, t0.uses_webp AS uses_webp_20 FROM broadcast t0 WHERE t0.id = 7 LIMIT 1;

SELECT 
  a0_.id AS id_0, 
  a0_.slug AS slug_1, 
  a0_.upload_path AS upload_path_2, 
  a0_.title AS title_3, 
  a0_.excerpt AS excerpt_4, 
  a0_.date_start AS date_start_5, 
  b1_.title AS title_6, 
  MIN(c2_.id) AS sclr_7, 
  a0_.thumbnail AS thumbnail_8 
FROM 
  broadcast_has_article b3_ 
  LEFT JOIN articles a0_ ON (b3_.article_id = a0_.id) 
  LEFT JOIN broadcast b1_ ON (b3_.broadcast_id = b1_.id) 
  LEFT JOIN category_has_article c4_ ON (c4_.article_id = a0_.id) 
  LEFT JOIN categories c2_ ON (c4_.category_id = c2_.id) 
WHERE 
  b3_.broadcast_id = ? 
  AND a0_.status = true 
  AND a0_.date_start <= ? 
  AND (
    a0_.date_end >= ? 
    OR a0_.date_end IS NULL
  ) 
GROUP BY 
  a0_.id, 
  a0_.slug, 
  a0_.upload_path, 
  a0_.title, 
  a0_.excerpt, 
  a0_.date_start, 
  b1_.title 
ORDER BY 
  a0_.sticky DESC, 
  a0_.date_start DESC 
LIMIT 
  12

SELECT a0_.id AS id_0, a0_.slug AS slug_1, a0_.upload_path AS upload_path_2, a0_.title AS title_3, a0_.excerpt AS excerpt_4, a0_.date_start AS date_start_5, b1_.title AS title_6, MIN(c2_.id) AS sclr_7, a0_.thumbnail AS thumbnail_8 FROM broadcast_has_article b3_ LEFT JOIN articles a0_ ON (b3_.article_id = a0_.id) LEFT JOIN broadcast b1_ ON (b3_.broadcast_id = b1_.id) LEFT JOIN category_has_article c4_ ON (c4_.article_id = a0_.id) LEFT JOIN categories c2_ ON (c4_.category_id = c2_.id) WHERE b3_.broadcast_id = 7 AND a0_.status = true AND a0_.date_start <= '2025-07-11 11:07:12' AND (a0_.date_end >= '2025-07-11 11:07:12' OR a0_.date_end IS NULL) GROUP BY a0_.id, a0_.slug, a0_.upload_path, a0_.title, a0_.excerpt, a0_.date_start, b1_.title ORDER BY a0_.sticky DESC, a0_.date_start DESC LIMIT 12;

SELECT 
  e0_.id AS id_0, 
  e0_.name AS name_1, 
  e0_.description AS description_2, 
  e0_.air_date AS air_date_3, 
  e0_.badge AS badge_4, 
  e0_.audio_file AS audio_file_5, 
  e0_.duration AS duration_6, 
  e1_.id AS id_7, 
  e1_.name AS name_8, 
  e1_.upload_path AS upload_path_9, 
  e1_.custom_show_image AS custom_show_image_10, 
  e1_.show_image_url AS show_image_url_11 
FROM 
  eemce_podcast_items e0_ 
  INNER JOIN eemce_podcasts e1_ ON e0_.podcast_id = e1_.id 
WHERE 
  e0_.air_date IS NOT NULL 
  AND e1_.id = ? 
ORDER BY 
  e0_.air_date DESC 
LIMIT 
  10

SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.description AS description_2, e0_.air_date AS air_date_3, e0_.badge AS badge_4, e0_.audio_file AS audio_file_5, e0_.duration AS duration_6, e1_.id AS id_7, e1_.name AS name_8, e1_.upload_path AS upload_path_9, e1_.custom_show_image AS custom_show_image_10, e1_.show_image_url AS show_image_url_11 FROM eemce_podcast_items e0_ INNER JOIN eemce_podcasts e1_ ON e0_.podcast_id = e1_.id WHERE e0_.air_date IS NOT NULL AND e1_.id = 2 ORDER BY e0_.air_date DESC LIMIT 10;

SELECT 
  t0.id AS id_1, 
  t0.title AS title_2, 
  t0.location AS location_3 
FROM 
  menus t0 
WHERE 
  t0.location = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.location AS location_3 FROM menus t0 WHERE t0.location = 'header' LIMIT 1;

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.feed_url AS feed_url_3, 
  t0.show_image_url AS show_image_url_4, 
  t0.custom_show_image AS custom_show_image_5, 
  t0.instagram_app_id AS instagram_app_id_6, 
  t0.instagram_app_secret AS instagram_app_secret_7, 
  t0.instagram_access_token AS instagram_access_token_8, 
  t0.meta_seo_title AS meta_seo_title_9, 
  t0.meta_seo_description AS meta_seo_description_10, 
  t0.description AS description_11, 
  t0.color_theme AS color_theme_12, 
  t0.upload_path AS upload_path_13, 
  t0.moderators AS moderators_14, 
  t0.sort AS sort_15, 
  t0.uses_webp AS uses_webp_16 
FROM 
  eemce_podcasts t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.feed_url AS feed_url_3, t0.show_image_url AS show_image_url_4, t0.custom_show_image AS custom_show_image_5, t0.instagram_app_id AS instagram_app_id_6, t0.instagram_app_secret AS instagram_app_secret_7, t0.instagram_access_token AS instagram_access_token_8, t0.meta_seo_title AS meta_seo_title_9, t0.meta_seo_description AS meta_seo_description_10, t0.description AS description_11, t0.color_theme AS color_theme_12, t0.upload_path AS upload_path_13, t0.moderators AS moderators_14, t0.sort AS sort_15, t0.uses_webp AS uses_webp_16 FROM eemce_podcasts t0 WHERE t0.id = 2;

SELECT 
  c0_.id AS id_0, 
  c0_.title AS title_1, 
  c0_.slug AS slug_2, 
  c0_.date_start AS date_start_3, 
  c0_.date_end AS date_end_4, 
  c0_.status AS status_5, 
  c0_.pinned AS pinned_6, 
  c0_.excerpt AS excerpt_7, 
  c0_.upload_path AS upload_path_8, 
  c0_.thumbnail AS thumbnail_9, 
  c0_.thumbnail_title AS thumbnail_title_10, 
  c0_.thumbnail_description AS thumbnail_description_11, 
  c0_.seo_title AS seo_title_12, 
  c0_.seo_description AS seo_description_13, 
  c0_.creation_date AS creation_date_14, 
  c0_.gemius_code AS gemius_code_15, 
  c0_.custom_js AS custom_js_16, 
  c0_.uses_webp AS uses_webp_17 
FROM 
  categories c0_ 
WHERE 
  c0_.slug = ?

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.slug AS slug_2, c0_.date_start AS date_start_3, c0_.date_end AS date_end_4, c0_.status AS status_5, c0_.pinned AS pinned_6, c0_.excerpt AS excerpt_7, c0_.upload_path AS upload_path_8, c0_.thumbnail AS thumbnail_9, c0_.thumbnail_title AS thumbnail_title_10, c0_.thumbnail_description AS thumbnail_description_11, c0_.seo_title AS seo_title_12, c0_.seo_description AS seo_description_13, c0_.creation_date AS creation_date_14, c0_.gemius_code AS gemius_code_15, c0_.custom_js AS custom_js_16, c0_.uses_webp AS uses_webp_17 FROM categories c0_ WHERE c0_.slug = 'rozhovory';

SELECT 
  c0_.id AS id_0, 
  c0_.title AS title_1, 
  c0_.slug AS slug_2 
FROM 
  broadcast_has_category b1_ 
  LEFT JOIN categories c0_ ON (b1_.category_id = c0_.id) 
WHERE 
  b1_.broadcast_id = ?

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.slug AS slug_2 FROM broadcast_has_category b1_ LEFT JOIN categories c0_ ON (b1_.category_id = c0_.id) WHERE b1_.broadcast_id = 7;

SELECT 
  o0_.id AS id_0, 
  o0_.key AS key_1, 
  o0_.value AS value_2 
FROM 
  options o0_

SELECT o0_.id AS id_0, o0_.key AS key_1, o0_.value AS value_2 FROM options o0_;

SELECT 
  b0_.id AS id_0, 
  b0_.slug AS slug_1, 
  b0_.title AS title_2, 
  b0_.description AS description_3, 
  b0_.author_bio AS author_bio_4, 
  b0_.upload_path AS upload_path_5, 
  b0_.gemius_code AS gemius_code_6 
FROM 
  broadcast b0_ 
WHERE 
  b0_.id = ?

SELECT b0_.id AS id_0, b0_.slug AS slug_1, b0_.title AS title_2, b0_.description AS description_3, b0_.author_bio AS author_bio_4, b0_.upload_path AS upload_path_5, b0_.gemius_code AS gemius_code_6 FROM broadcast b0_ WHERE b0_.id = 7;

SELECT 
  s0_.id AS id_0, 
  s0_.title AS title_1, 
  s0_.slug AS slug_2, 
  s0_.is_default AS is_default_3, 
  s0_.sort AS sort_4, 
  s0_.date_start AS date_start_5, 
  s0_.date_end AS date_end_6, 
  s0_.stream_ad_uri AS stream_ad_uri_7, 
  s0_.stream_64k_mp3_uri AS stream_64k_mp3_uri_8, 
  s0_.stream_128k_mp3_uri AS stream_128k_mp3_uri_9, 
  s0_.stream_192k_mp3_uri AS stream_192k_mp3_uri_10, 
  s0_.gemius_code AS gemius_code_11, 
  s0_.seo_description AS seo_description_12, 
  s0_.seo_keywords AS seo_keywords_13, 
  s0_.logo AS logo_14, 
  s0_.logo_hover AS logo_hover_15, 
  s0_.upload_path AS upload_path_16 
FROM 
  sepia_stream s0_ 
WHERE 
  s0_.date_start <= CURRENT_TIMESTAMP 
  AND (
    s0_.date_end >= CURRENT_TIMESTAMP 
    OR s0_.date_end IS NULL
  ) 
ORDER BY 
  s0_.is_default DESC, 
  s0_.sort ASC

SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.slug AS slug_2, s0_.is_default AS is_default_3, s0_.sort AS sort_4, s0_.date_start AS date_start_5, s0_.date_end AS date_end_6, s0_.stream_ad_uri AS stream_ad_uri_7, s0_.stream_64k_mp3_uri AS stream_64k_mp3_uri_8, s0_.stream_128k_mp3_uri AS stream_128k_mp3_uri_9, s0_.stream_192k_mp3_uri AS stream_192k_mp3_uri_10, s0_.gemius_code AS gemius_code_11, s0_.seo_description AS seo_description_12, s0_.seo_keywords AS seo_keywords_13, s0_.logo AS logo_14, s0_.logo_hover AS logo_hover_15, s0_.upload_path AS upload_path_16 FROM sepia_stream s0_ WHERE s0_.date_start <= CURRENT_TIMESTAMP AND (s0_.date_end >= CURRENT_TIMESTAMP OR s0_.date_end IS NULL) ORDER BY s0_.is_default DESC, s0_.sort ASC;

SELECT 
  e0_.id AS id_0, 
  e0_.name AS name_1, 
  e0_.show_image_url AS show_image_url_2, 
  e0_.custom_show_image AS custom_show_image_3, 
  e0_.meta_seo_title AS meta_seo_title_4, 
  e0_.meta_seo_description AS meta_seo_description_5, 
  e0_.description AS description_6, 
  e0_.upload_path AS upload_path_7, 
  e0_.sort AS sort_8 
FROM 
  eemce_podcasts e0_ 
ORDER BY 
  e0_.sort ASC

SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.show_image_url AS show_image_url_2, e0_.custom_show_image AS custom_show_image_3, e0_.meta_seo_title AS meta_seo_title_4, e0_.meta_seo_description AS meta_seo_description_5, e0_.description AS description_6, e0_.upload_path AS upload_path_7, e0_.sort AS sort_8 FROM eemce_podcasts e0_ ORDER BY e0_.sort ASC;

SELECT 
  c0_.id AS id_0, 
  c0_.title AS title_1, 
  c0_.slug AS slug_2, 
  c0_.date_start AS date_start_3, 
  c0_.date_end AS date_end_4, 
  c0_.status AS status_5, 
  c0_.pinned AS pinned_6, 
  c0_.excerpt AS excerpt_7, 
  c0_.upload_path AS upload_path_8, 
  c0_.thumbnail AS thumbnail_9, 
  c0_.thumbnail_title AS thumbnail_title_10, 
  c0_.thumbnail_description AS thumbnail_description_11, 
  c0_.seo_title AS seo_title_12, 
  c0_.seo_description AS seo_description_13, 
  c0_.creation_date AS creation_date_14, 
  c0_.gemius_code AS gemius_code_15, 
  c0_.custom_js AS custom_js_16, 
  c0_.uses_webp AS uses_webp_17 
FROM 
  categories c0_ 
WHERE 
  c0_.id = ?

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.slug AS slug_2, c0_.date_start AS date_start_3, c0_.date_end AS date_end_4, c0_.status AS status_5, c0_.pinned AS pinned_6, c0_.excerpt AS excerpt_7, c0_.upload_path AS upload_path_8, c0_.thumbnail AS thumbnail_9, c0_.thumbnail_title AS thumbnail_title_10, c0_.thumbnail_description AS thumbnail_description_11, c0_.seo_title AS seo_title_12, c0_.seo_description AS seo_description_13, c0_.creation_date AS creation_date_14, c0_.gemius_code AS gemius_code_15, c0_.custom_js AS custom_js_16, c0_.uses_webp AS uses_webp_17 FROM categories c0_ WHERE c0_.id = 650;