Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3,
  t0.iso AS iso_4,
  t0.color AS color_5,
  t0.domain AS domain_6,
  t0.name_in_language AS name_in_language_7,
  t0.writing_direction AS writing_direction_8,
  t0.time_zone AS time_zone_9
FROM
  language t0
WHERE
  t0.iso = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.iso AS iso_4, t0.color AS color_5, t0.domain AS domain_6, t0.name_in_language AS name_in_language_7, t0.writing_direction AS writing_direction_8, t0.time_zone AS time_zone_9 FROM language t0 WHERE t0.iso = 'hi' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3,
  t0.iso AS iso_4,
  t0.color AS color_5,
  t0.domain AS domain_6,
  t0.name_in_language AS name_in_language_7,
  t0.writing_direction AS writing_direction_8,
  t0.time_zone AS time_zone_9
FROM
  language t0
WHERE
  t0.iso = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.iso AS iso_4, t0.color AS color_5, t0.domain AS domain_6, t0.name_in_language AS name_in_language_7, t0.writing_direction AS writing_direction_8, t0.time_zone AS time_zone_9 FROM language t0 WHERE t0.iso = 'hi' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.type AS type_4,
  t0.options AS options_5,
  t0.dev AS dev_6
FROM
  setting t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.type AS type_4, t0.options AS options_5, t0.dev AS dev_6 FROM setting t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3,
  t0.iso AS iso_4,
  t0.color AS color_5,
  t0.domain AS domain_6,
  t0.name_in_language AS name_in_language_7,
  t0.writing_direction AS writing_direction_8,
  t0.time_zone AS time_zone_9
FROM
  language t0
WHERE
  t0.iso = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.iso AS iso_4, t0.color AS color_5, t0.domain AS domain_6, t0.name_in_language AS name_in_language_7, t0.writing_direction AS writing_direction_8, t0.time_zone AS time_zone_9 FROM language t0 WHERE t0.iso = 'hi' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.config AS config_3,
  t0.language_id AS language_id_4
FROM
  home_page_config t0
WHERE
  t0.language_id = ?
  AND t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.config AS config_3, t0.language_id AS language_id_4 FROM home_page_config t0 WHERE t0.language_id = 3 AND t0.name = 'mega-page' LIMIT 1;

SELECT
  n0_.id AS id_0,
  n0_.title AS title_1,
  n0_.slug AS slug_2,
  n0_.content AS content_3,
  n0_.publish_date AS publish_date_4,
  n0_.featured AS featured_5,
  n0_.meta_title AS meta_title_6,
  n0_.meta_keywords AS meta_keywords_7,
  n0_.meta_description AS meta_description_8,
  n0_.created_on AS created_on_9,
  n0_.file_data AS file_data_10,
  n0_.file_name AS file_name_11,
  n0_.file_type AS file_type_12,
  n0_.trending AS trending_13,
  n0_.is_breaking AS is_breaking_14,
  n0_.old_id AS old_id_15,
  n0_.news_id AS news_id_16,
  n0_.comment_status AS comment_status_17,
  n0_.status AS status_18,
  n0_.youtube_url AS youtube_url_19,
  n0_.youtube_url_second AS youtube_url_second_20,
  n0_.disclaimer AS disclaimer_21,
  n0_.fact_box AS fact_box_22,
  n0_.fact_box_size AS fact_box_size_23,
  n0_.fact_box_placement AS fact_box_placement_24,
  n0_.updated_at AS updated_at_25,
  n0_.last_update_key AS last_update_key_26,
  n0_.category_id AS category_id_27,
  n0_.language_id AS language_id_28,
  n0_.reporter_id AS reporter_id_29,
  n0_.author_id AS author_id_30
FROM
  news n0_
  INNER JOIN image_store i1_ ON n0_.id = i1_.news_id
WHERE
  n0_.language_id = ?
  AND n0_.status = ?
  AND n0_.is_breaking = ?
ORDER BY
  n0_.publish_date DESC
LIMIT
  2

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.content AS content_3, n0_.publish_date AS publish_date_4, n0_.featured AS featured_5, n0_.meta_title AS meta_title_6, n0_.meta_keywords AS meta_keywords_7, n0_.meta_description AS meta_description_8, n0_.created_on AS created_on_9, n0_.file_data AS file_data_10, n0_.file_name AS file_name_11, n0_.file_type AS file_type_12, n0_.trending AS trending_13, n0_.is_breaking AS is_breaking_14, n0_.old_id AS old_id_15, n0_.news_id AS news_id_16, n0_.comment_status AS comment_status_17, n0_.status AS status_18, n0_.youtube_url AS youtube_url_19, n0_.youtube_url_second AS youtube_url_second_20, n0_.disclaimer AS disclaimer_21, n0_.fact_box AS fact_box_22, n0_.fact_box_size AS fact_box_size_23, n0_.fact_box_placement AS fact_box_placement_24, n0_.updated_at AS updated_at_25, n0_.last_update_key AS last_update_key_26, n0_.category_id AS category_id_27, n0_.language_id AS language_id_28, n0_.reporter_id AS reporter_id_29, n0_.author_id AS author_id_30 FROM news n0_ INNER JOIN image_store i1_ ON n0_.id = i1_.news_id WHERE n0_.language_id = 3 AND n0_.status = 'a' AND n0_.is_breaking = 1 ORDER BY n0_.publish_date DESC LIMIT 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3,
  t0.slug AS slug_4,
  t0.sorting_rank AS sorting_rank_5,
  t0.language_id AS language_id_6,
  t0.parent_id AS parent_id_7
FROM
  category t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.slug AS slug_4, t0.sorting_rank AS sorting_rank_5, t0.language_id AS language_id_6, t0.parent_id AS parent_id_7 FROM category t0 WHERE t0.id = 0 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3,
  t0.slug AS slug_4,
  t0.sorting_rank AS sorting_rank_5,
  t0.language_id AS language_id_6,
  t0.parent_id AS parent_id_7
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.slug AS slug_4, t0.sorting_rank AS sorting_rank_5, t0.language_id AS language_id_6, t0.parent_id AS parent_id_7 FROM category t0 WHERE t0.id = 0;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.active AS active_2,
  c0_.slug AS slug_3,
  c0_.sorting_rank AS sorting_rank_4,
  c0_.language_id AS language_id_5,
  c0_.parent_id AS parent_id_6
FROM
  category c0_
WHERE
  c0_.language_id = ?
ORDER BY
  c0_.id DESC
LIMIT
  5

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.active AS active_2, c0_.slug AS slug_3, c0_.sorting_rank AS sorting_rank_4, c0_.language_id AS language_id_5, c0_.parent_id AS parent_id_6 FROM category c0_ WHERE c0_.language_id = 3 ORDER BY c0_.id DESC LIMIT 5;

SELECT
  n0_.id AS id_0,
  n0_.title AS title_1,
  n0_.slug AS slug_2,
  n0_.content AS content_3,
  n0_.publish_date AS publish_date_4,
  n0_.featured AS featured_5,
  n0_.meta_title AS meta_title_6,
  n0_.meta_keywords AS meta_keywords_7,
  n0_.meta_description AS meta_description_8,
  n0_.created_on AS created_on_9,
  n0_.file_data AS file_data_10,
  n0_.file_name AS file_name_11,
  n0_.file_type AS file_type_12,
  n0_.trending AS trending_13,
  n0_.is_breaking AS is_breaking_14,
  n0_.old_id AS old_id_15,
  n0_.news_id AS news_id_16,
  n0_.comment_status AS comment_status_17,
  n0_.status AS status_18,
  n0_.youtube_url AS youtube_url_19,
  n0_.youtube_url_second AS youtube_url_second_20,
  n0_.disclaimer AS disclaimer_21,
  n0_.fact_box AS fact_box_22,
  n0_.fact_box_size AS fact_box_size_23,
  n0_.fact_box_placement AS fact_box_placement_24,
  n0_.updated_at AS updated_at_25,
  n0_.last_update_key AS last_update_key_26,
  n0_.category_id AS category_id_27,
  n0_.language_id AS language_id_28,
  n0_.reporter_id AS reporter_id_29,
  n0_.author_id AS author_id_30
FROM
  news n0_
  INNER JOIN image_store i1_ ON n0_.id = i1_.news_id
WHERE
  n0_.language_id = ?
  AND n0_.status = ?
ORDER BY
  n0_.publish_date DESC
LIMIT
  4

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.content AS content_3, n0_.publish_date AS publish_date_4, n0_.featured AS featured_5, n0_.meta_title AS meta_title_6, n0_.meta_keywords AS meta_keywords_7, n0_.meta_description AS meta_description_8, n0_.created_on AS created_on_9, n0_.file_data AS file_data_10, n0_.file_name AS file_name_11, n0_.file_type AS file_type_12, n0_.trending AS trending_13, n0_.is_breaking AS is_breaking_14, n0_.old_id AS old_id_15, n0_.news_id AS news_id_16, n0_.comment_status AS comment_status_17, n0_.status AS status_18, n0_.youtube_url AS youtube_url_19, n0_.youtube_url_second AS youtube_url_second_20, n0_.disclaimer AS disclaimer_21, n0_.fact_box AS fact_box_22, n0_.fact_box_size AS fact_box_size_23, n0_.fact_box_placement AS fact_box_placement_24, n0_.updated_at AS updated_at_25, n0_.last_update_key AS last_update_key_26, n0_.category_id AS category_id_27, n0_.language_id AS language_id_28, n0_.reporter_id AS reporter_id_29, n0_.author_id AS author_id_30 FROM news n0_ INNER JOIN image_store i1_ ON n0_.id = i1_.news_id WHERE n0_.language_id = 3 AND n0_.status = 'a' ORDER BY n0_.publish_date DESC LIMIT 4;

SELECT
  n0_.id AS id_0,
  n0_.title AS title_1,
  n0_.slug AS slug_2,
  n0_.content AS content_3,
  n0_.publish_date AS publish_date_4,
  n0_.featured AS featured_5,
  n0_.meta_title AS meta_title_6,
  n0_.meta_keywords AS meta_keywords_7,
  n0_.meta_description AS meta_description_8,
  n0_.created_on AS created_on_9,
  n0_.file_data AS file_data_10,
  n0_.file_name AS file_name_11,
  n0_.file_type AS file_type_12,
  n0_.trending AS trending_13,
  n0_.is_breaking AS is_breaking_14,
  n0_.old_id AS old_id_15,
  n0_.news_id AS news_id_16,
  n0_.comment_status AS comment_status_17,
  n0_.status AS status_18,
  n0_.youtube_url AS youtube_url_19,
  n0_.youtube_url_second AS youtube_url_second_20,
  n0_.disclaimer AS disclaimer_21,
  n0_.fact_box AS fact_box_22,
  n0_.fact_box_size AS fact_box_size_23,
  n0_.fact_box_placement AS fact_box_placement_24,
  n0_.updated_at AS updated_at_25,
  n0_.last_update_key AS last_update_key_26,
  n0_.category_id AS category_id_27,
  n0_.language_id AS language_id_28,
  n0_.reporter_id AS reporter_id_29,
  n0_.author_id AS author_id_30
FROM
  news n0_
WHERE
  n0_.language_id = ?
  AND n0_.status = ?
ORDER BY
  n0_.publish_date DESC
LIMIT
  8

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.content AS content_3, n0_.publish_date AS publish_date_4, n0_.featured AS featured_5, n0_.meta_title AS meta_title_6, n0_.meta_keywords AS meta_keywords_7, n0_.meta_description AS meta_description_8, n0_.created_on AS created_on_9, n0_.file_data AS file_data_10, n0_.file_name AS file_name_11, n0_.file_type AS file_type_12, n0_.trending AS trending_13, n0_.is_breaking AS is_breaking_14, n0_.old_id AS old_id_15, n0_.news_id AS news_id_16, n0_.comment_status AS comment_status_17, n0_.status AS status_18, n0_.youtube_url AS youtube_url_19, n0_.youtube_url_second AS youtube_url_second_20, n0_.disclaimer AS disclaimer_21, n0_.fact_box AS fact_box_22, n0_.fact_box_size AS fact_box_size_23, n0_.fact_box_placement AS fact_box_placement_24, n0_.updated_at AS updated_at_25, n0_.last_update_key AS last_update_key_26, n0_.category_id AS category_id_27, n0_.language_id AS language_id_28, n0_.reporter_id AS reporter_id_29, n0_.author_id AS author_id_30 FROM news n0_ WHERE n0_.language_id = 3 AND n0_.status = 'a' ORDER BY n0_.publish_date DESC LIMIT 8;

SELECT
  n0_.id AS id_0,
  n0_.title AS title_1,
  n0_.slug AS slug_2,
  n0_.content AS content_3,
  n0_.publish_date AS publish_date_4,
  n0_.featured AS featured_5,
  n0_.meta_title AS meta_title_6,
  n0_.meta_keywords AS meta_keywords_7,
  n0_.meta_description AS meta_description_8,
  n0_.created_on AS created_on_9,
  n0_.file_data AS file_data_10,
  n0_.file_name AS file_name_11,
  n0_.file_type AS file_type_12,
  n0_.trending AS trending_13,
  n0_.is_breaking AS is_breaking_14,
  n0_.old_id AS old_id_15,
  n0_.news_id AS news_id_16,
  n0_.comment_status AS comment_status_17,
  n0_.status AS status_18,
  n0_.youtube_url AS youtube_url_19,
  n0_.youtube_url_second AS youtube_url_second_20,
  n0_.disclaimer AS disclaimer_21,
  n0_.fact_box AS fact_box_22,
  n0_.fact_box_size AS fact_box_size_23,
  n0_.fact_box_placement AS fact_box_placement_24,
  n0_.updated_at AS updated_at_25,
  n0_.last_update_key AS last_update_key_26,
  n0_.category_id AS category_id_27,
  n0_.language_id AS language_id_28,
  n0_.reporter_id AS reporter_id_29,
  n0_.author_id AS author_id_30
FROM
  news n0_
  INNER JOIN image_store i1_ ON n0_.id = i1_.news_id
WHERE
  n0_.language_id = ?
  AND n0_.status = ?
  AND n0_.trending = 1
ORDER BY
  n0_.publish_date DESC
LIMIT
  10

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.content AS content_3, n0_.publish_date AS publish_date_4, n0_.featured AS featured_5, n0_.meta_title AS meta_title_6, n0_.meta_keywords AS meta_keywords_7, n0_.meta_description AS meta_description_8, n0_.created_on AS created_on_9, n0_.file_data AS file_data_10, n0_.file_name AS file_name_11, n0_.file_type AS file_type_12, n0_.trending AS trending_13, n0_.is_breaking AS is_breaking_14, n0_.old_id AS old_id_15, n0_.news_id AS news_id_16, n0_.comment_status AS comment_status_17, n0_.status AS status_18, n0_.youtube_url AS youtube_url_19, n0_.youtube_url_second AS youtube_url_second_20, n0_.disclaimer AS disclaimer_21, n0_.fact_box AS fact_box_22, n0_.fact_box_size AS fact_box_size_23, n0_.fact_box_placement AS fact_box_placement_24, n0_.updated_at AS updated_at_25, n0_.last_update_key AS last_update_key_26, n0_.category_id AS category_id_27, n0_.language_id AS language_id_28, n0_.reporter_id AS reporter_id_29, n0_.author_id AS author_id_30 FROM news n0_ INNER JOIN image_store i1_ ON n0_.id = i1_.news_id WHERE n0_.language_id = 3 AND n0_.status = 'a' AND n0_.trending = 1 ORDER BY n0_.publish_date DESC LIMIT 10;

SELECT
  y0_.id AS id_0,
  y0_.title AS title_1,
  y0_.description AS description_2,
  y0_.url AS url_3
FROM
  yt_gallery y0_
ORDER BY
  y0_.id DESC
LIMIT
  5

SELECT y0_.id AS id_0, y0_.title AS title_1, y0_.description AS description_2, y0_.url AS url_3 FROM yt_gallery y0_ ORDER BY y0_.id DESC LIMIT 5;

SELECT
  COUNT(a.id)
FROM
  advertisement a
WHERE
  a.location = ?
  AND a.status = ?
  AND a.start_date <= ?
  AND a.end_date >= ?

SELECT COUNT(a.id)
             FROM advertisement a
             WHERE a.location = 'sidebar'
               AND a.status = 'active'
               AND a.start_date <= '2026-03-24'
               AND a.end_date >= '2026-03-24';

SELECT
  a.id,
  a.location,
  a.banner_size,
  a.url
FROM
  advertisement a
WHERE
  a.location = ?
  AND a.status = ?
  AND a.start_date <= ?
  AND a.end_date >= ?
ORDER BY
  a.id ASC
LIMIT
  1
OFFSET
  ?

SELECT a.id, a.location, a.banner_size, a.url
             FROM advertisement a
             WHERE a.location = 'sidebar'
               AND a.status = 'active'
               AND a.start_date <= '2026-03-24'
               AND a.end_date >= '2026-03-24'
             ORDER BY a.id ASC
             LIMIT 1 OFFSET 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.config AS config_3,
  t0.language_id AS language_id_4
FROM
  home_page_config t0
WHERE
  t0.language_id = ?
  AND t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.config AS config_3, t0.language_id AS language_id_4 FROM home_page_config t0 WHERE t0.language_id = 3 AND t0.name = 'mega-page' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3,
  t0.iso AS iso_4,
  t0.color AS color_5,
  t0.domain AS domain_6,
  t0.name_in_language AS name_in_language_7,
  t0.writing_direction AS writing_direction_8,
  t0.time_zone AS time_zone_9
FROM
  language t0
WHERE
  t0.iso = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.iso AS iso_4, t0.color AS color_5, t0.domain AS domain_6, t0.name_in_language AS name_in_language_7, t0.writing_direction AS writing_direction_8, t0.time_zone AS time_zone_9 FROM language t0 WHERE t0.iso = 'hi' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.active AS active_2,
  c0_.slug AS slug_3,
  c0_.sorting_rank AS sorting_rank_4,
  c1_.id AS id_5,
  c1_.name AS name_6,
  c1_.active AS active_7,
  c1_.slug AS slug_8,
  c1_.sorting_rank AS sorting_rank_9,
  c0_.language_id AS language_id_10,
  c0_.parent_id AS parent_id_11,
  c1_.language_id AS language_id_12,
  c1_.parent_id AS parent_id_13
FROM
  category c0_
  LEFT JOIN category c1_ ON c0_.id = c1_.parent_id
  AND (c1_.active = 1)
WHERE
  c0_.language_id = ?
  AND c0_.parent_id IS NULL
  AND c0_.active = 1
ORDER BY
  c0_.sorting_rank ASC,
  c1_.sorting_rank ASC,
  c1_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.active AS active_2, c0_.slug AS slug_3, c0_.sorting_rank AS sorting_rank_4, c1_.id AS id_5, c1_.name AS name_6, c1_.active AS active_7, c1_.slug AS slug_8, c1_.sorting_rank AS sorting_rank_9, c0_.language_id AS language_id_10, c0_.parent_id AS parent_id_11, c1_.language_id AS language_id_12, c1_.parent_id AS parent_id_13 FROM category c0_ LEFT JOIN category c1_ ON c0_.id = c1_.parent_id AND (c1_.active = 1) WHERE c0_.language_id = 3 AND c0_.parent_id IS NULL AND c0_.active = 1 ORDER BY c0_.sorting_rank ASC, c1_.sorting_rank ASC, c1_.name ASC;