Symfony Profiler

Query Metrics

31 Database Queries

7 Different statements

78.08 ms Query time

0 Invalid entities

Queries


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 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 <= ? 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 <= ? 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 <= ? 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 <= ? 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 <= ? 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 <= ? 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 <= ? 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 <= ? 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 <= ? 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 <= ? 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 <= ? 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 <= ? 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 <= ? 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 <= ? 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 <= ? AND (m0_.date_end >= ? OR m0_.date_end IS NULL) AND m0_.menu = ? AND m0_.parent = ? ORDER BY m0_.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 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 <= ? 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 <= ? AND (m0_.date_end >= ? OR m0_.date_end IS NULL) AND m0_.menu = ? AND m0_.parent = ? ORDER BY m0_.sort ASC
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 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 c0_.id AS id_0, c0_.title AS title_1, c0_.slug AS slug_2 FROM categories c0_ WHERE c0_.id IN (?)
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 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 c0_.id AS id_0, c0_.title AS title_1, c0_.slug AS slug_2 FROM categories c0_ WHERE c0_.id IN (?)
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 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 c0_.id AS id_0, c0_.title AS title_1, c0_.slug AS slug_2 FROM categories c0_ WHERE c0_.id IN (?)
SELECT o0_.id AS id_0, o0_.key AS key_1, o0_.value AS value_2 FROM options o0_

#▲	Time	Info
1	2.06 ms	SELECT t0.id AS id_1, t0.title AS title_2, t0.location AS location_3 FROM menus t0 WHERE t0.location = ? LIMIT 1 Parameters: [`"header"`] View formatted query View runnable query Explain query 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;
2	1.62 ms	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 Parameters: [`"2025-07-11 16:15:00" "2025-07-11 16:15:00" 1 0`] View formatted query View runnable query Explain query 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 16:15:00' AND (m0_.date_end >= '2025-07-11 16:15:00' OR m0_.date_end IS NULL) AND m0_.menu = 1 AND m0_.parent = 0 ORDER BY m0_.sort ASC;
3	0.67 ms	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 Parameters: [`"2025-07-11 16:15:00" "2025-07-11 16:15:00" 1 44`] View formatted query View runnable query Explain query 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 16:15:00' AND (m0_.date_end >= '2025-07-11 16:15:00' OR m0_.date_end IS NULL) AND m0_.menu = 1 AND m0_.parent = 44 ORDER BY m0_.sort ASC;
4	0.55 ms	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 Parameters: [`"2025-07-11 16:15:00" "2025-07-11 16:15:00" 1 3`] View formatted query View runnable query Explain query 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 16:15:00' AND (m0_.date_end >= '2025-07-11 16:15:00' OR m0_.date_end IS NULL) AND m0_.menu = 1 AND m0_.parent = 3 ORDER BY m0_.sort ASC;
5	0.54 ms	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 Parameters: [`"2025-07-11 16:15:00" "2025-07-11 16:15:00" 1 27`] View formatted query View runnable query Explain query 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 16:15:00' AND (m0_.date_end >= '2025-07-11 16:15:00' OR m0_.date_end IS NULL) AND m0_.menu = 1 AND m0_.parent = 27 ORDER BY m0_.sort ASC;
6	0.34 ms	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 Parameters: [`"2025-07-11 16:15:00" "2025-07-11 16:15:00" 1 28`] View formatted query View runnable query Explain query 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 16:15:00' AND (m0_.date_end >= '2025-07-11 16:15:00' OR m0_.date_end IS NULL) AND m0_.menu = 1 AND m0_.parent = 28 ORDER BY m0_.sort ASC;
7	0.32 ms	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 Parameters: [`"2025-07-11 16:15:00" "2025-07-11 16:15:00" 1 29`] View formatted query View runnable query Explain query 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 16:15:00' AND (m0_.date_end >= '2025-07-11 16:15:00' OR m0_.date_end IS NULL) AND m0_.menu = 1 AND m0_.parent = 29 ORDER BY m0_.sort ASC;
8	0.31 ms	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 Parameters: [`"2025-07-11 16:15:00" "2025-07-11 16:15:00" 1 30`] View formatted query View runnable query Explain query 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 16:15:00' AND (m0_.date_end >= '2025-07-11 16:15:00' OR m0_.date_end IS NULL) AND m0_.menu = 1 AND m0_.parent = 30 ORDER BY m0_.sort ASC;
9	0.31 ms	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 Parameters: [`"2025-07-11 16:15:00" "2025-07-11 16:15:00" 1 55`] View formatted query View runnable query Explain query 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 16:15:00' AND (m0_.date_end >= '2025-07-11 16:15:00' OR m0_.date_end IS NULL) AND m0_.menu = 1 AND m0_.parent = 55 ORDER BY m0_.sort ASC;
10	0.36 ms	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 Parameters: [`"2025-07-11 16:15:00" "2025-07-11 16:15:00" 1 31`] View formatted query View runnable query Explain query 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 16:15:00' AND (m0_.date_end >= '2025-07-11 16:15:00' OR m0_.date_end IS NULL) AND m0_.menu = 1 AND m0_.parent = 31 ORDER BY m0_.sort ASC;
11	0.34 ms	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 Parameters: [`"2025-07-11 16:15:00" "2025-07-11 16:15:00" 1 32`] View formatted query View runnable query Explain query 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 16:15:00' AND (m0_.date_end >= '2025-07-11 16:15:00' OR m0_.date_end IS NULL) AND m0_.menu = 1 AND m0_.parent = 32 ORDER BY m0_.sort ASC;
12	0.43 ms	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 Parameters: [`"2025-07-11 16:15:00" "2025-07-11 16:15:00" 1 33`] View formatted query View runnable query Explain query 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 16:15:00' AND (m0_.date_end >= '2025-07-11 16:15:00' OR m0_.date_end IS NULL) AND m0_.menu = 1 AND m0_.parent = 33 ORDER BY m0_.sort ASC;
13	0.37 ms	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 Parameters: [`"2025-07-11 16:15:00" "2025-07-11 16:15:00" 1 56`] View formatted query View runnable query Explain query 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 16:15:00' AND (m0_.date_end >= '2025-07-11 16:15:00' OR m0_.date_end IS NULL) AND m0_.menu = 1 AND m0_.parent = 56 ORDER BY m0_.sort ASC;
14	0.31 ms	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 Parameters: [`"2025-07-11 16:15:00" "2025-07-11 16:15:00" 1 60`] View formatted query View runnable query Explain query 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 16:15:00' AND (m0_.date_end >= '2025-07-11 16:15:00' OR m0_.date_end IS NULL) AND m0_.menu = 1 AND m0_.parent = 60 ORDER BY m0_.sort ASC;
15	0.40 ms	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 Parameters: [`"2025-07-11 16:15:00" "2025-07-11 16:15:00" 1 43`] View formatted query View runnable query Explain query 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 16:15:00' AND (m0_.date_end >= '2025-07-11 16:15:00' OR m0_.date_end IS NULL) AND m0_.menu = 1 AND m0_.parent = 43 ORDER BY m0_.sort ASC;
16	0.44 ms	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 Parameters: [`"2025-07-11 16:15:00" "2025-07-11 16:15:00" 1 69`] View formatted query View runnable query Explain query 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 16:15:00' AND (m0_.date_end >= '2025-07-11 16:15:00' OR m0_.date_end IS NULL) AND m0_.menu = 1 AND m0_.parent = 69 ORDER BY m0_.sort ASC;
17	0.42 ms	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 Parameters: [`"2025-07-11 16:15:00" "2025-07-11 16:15:00" 1 70`] View formatted query View runnable query Explain query 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 16:15:00' AND (m0_.date_end >= '2025-07-11 16:15:00' OR m0_.date_end IS NULL) AND m0_.menu = 1 AND m0_.parent = 70 ORDER BY m0_.sort ASC;
18	0.85 ms	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 = ? Parameters: [`650`] View formatted query View runnable query Explain query 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;
19	0.47 ms	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 Parameters: [`"2025-07-11 16:15:00" "2025-07-11 16:15:00" 1 34`] View formatted query View runnable query Explain query 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 16:15:00' AND (m0_.date_end >= '2025-07-11 16:15:00' OR m0_.date_end IS NULL) AND m0_.menu = 1 AND m0_.parent = 34 ORDER BY m0_.sort ASC;
20	0.42 ms	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 Parameters: [`"2025-07-11 16:15:00" "2025-07-11 16:15:00" 1 4`] View formatted query View runnable query Explain query 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 16:15:00' AND (m0_.date_end >= '2025-07-11 16:15:00' OR m0_.date_end IS NULL) AND m0_.menu = 1 AND m0_.parent = 4 ORDER BY m0_.sort ASC;
21	0.32 ms	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 Parameters: [`"2025-07-11 16:15:00" "2025-07-11 16:15:00" 1 64`] View formatted query View runnable query Explain query 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 16:15:00' AND (m0_.date_end >= '2025-07-11 16:15:00' OR m0_.date_end IS NULL) AND m0_.menu = 1 AND m0_.parent = 64 ORDER BY m0_.sort ASC;
22	0.66 ms	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 Parameters: [`2`] View formatted query View runnable query Explain query 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 = 2 LIMIT 1;
23	25.23 ms	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 Parameters: [`2 "2025-07-11 16:13:25" "2025-07-11 16:13:25"`] View formatted query View runnable query Explain query 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 16:13:25' AND (a0_.date_end >= '2025-07-11 16:13:25' 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;
24	0.58 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.slug AS slug_2 FROM categories c0_ WHERE c0_.id IN (?) Parameters: [`[ 2094 ]`] View formatted query View runnable query Explain query 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 (2094);
25	0.47 ms	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 Parameters: [`3`] View formatted query View runnable query Explain query 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 = 3 LIMIT 1;
26	6.68 ms	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 Parameters: [`3 "2025-07-11 16:13:25" "2025-07-11 16:13:25"`] View formatted query View runnable query Explain query 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 = 3 AND a0_.status = true AND a0_.date_start <= '2025-07-11 16:13:25' AND (a0_.date_end >= '2025-07-11 16:13:25' 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;
27	0.62 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.slug AS slug_2 FROM categories c0_ WHERE c0_.id IN (?) Parameters: [`[ 58 2054 10 2112 2089 ]`] View formatted query View runnable query Explain query 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 (58, 2054, 10, 2112, 2089);
28	0.40 ms	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 Parameters: [`4`] View formatted query View runnable query Explain query 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 = 4 LIMIT 1;
29	29.96 ms	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 Parameters: [`4 "2025-07-11 16:13:25" "2025-07-11 16:13:25"`] View formatted query View runnable query Explain query 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 = 4 AND a0_.status = true AND a0_.date_start <= '2025-07-11 16:13:25' AND (a0_.date_end >= '2025-07-11 16:13:25' 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;
30	0.68 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.slug AS slug_2 FROM categories c0_ WHERE c0_.id IN (?) Parameters: [`[ 0 => 10 3 => 50 4 => 800 ]`] View formatted query View runnable query Explain query 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 (10, 50, 800);
31	0.94 ms	SELECT o0_.id AS id_0, o0_.key AS key_1, o0_.value AS value_2 FROM options o0_ Parameters: [] View formatted query View runnable query Explain query 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_;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
AppBundle\Entity\Podcast	No errors.
AppBundle\Entity\PodcastItem	No errors.
AppBundle\Entity\Category	No errors.
AppBundle\Entity\Menu	No errors.
AppBundle\Entity\MenuItem	No errors.
AppBundle\Entity\Article	No errors.
AppBundle\Entity\Broadcast	No errors.
AppBundle\Entity\Option	No errors.
AppBundle\Entity\Content	No errors.
AppBundle\Entity\CategoryHasArticle	No errors.
AppBundle\Entity\BroadcastHasArticle	No errors.
Bait\PollBundle\Entity\Poll	No errors.
AppBundle\Entity\AirNow	No errors.
AppBundle\Entity\Board	No errors.
Bait\PollBundle\Entity\Question	No errors.
Bait\PollBundle\Entity\Result	No errors.
Bait\PollBundle\Entity\UserAnswerGroup	No errors.
AppBundle\Entity\AirNowModerator	No errors.

Symfony Profiler

https://funradio.dev.eemce.eu/app_dev.php/esi/anonymous/header/menu/

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping