113.53 ms (33.56%)
|
1 |
SELECT SUM(h0_.hits) AS sclr_0, SUM(h0_.unique_views) AS sclr_1 FROM hit_counter h0_
SELECT SUM(h0_.hits) AS sclr_0, SUM(h0_.unique_views) AS sclr_1 FROM hit_counter h0_;
|
86.72 ms (25.64%)
|
1 |
SELECT SUM(h0_.hits) AS sclr_0, SUM(h0_.unique_views) AS sclr_1 FROM hit_counter h0_ WHERE h0_.date = ?
Parameters: [
"2026-03-22 00:00:00"
]
SELECT SUM(h0_.hits) AS sclr_0, SUM(h0_.unique_views) AS sclr_1 FROM hit_counter h0_ WHERE h0_.date = '2026-03-22 00:00:00';
|
53.55 ms (15.83%)
|
35 |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.file_type AS file_type_3, t0.file_data AS file_data_4, t0.is_primary AS is_primary_5, t0.old_id AS old_id_6, t0.search_tag AS search_tag_7, t0.image_size AS image_size_8, t0.caption AS caption_9, t0.gz_data AS gz_data_10, t0.news_code AS news_code_11, t0.news_id AS news_id_12 FROM image_store t0 WHERE t0.news_id = ? AND t0.is_primary = ? LIMIT 1
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.file_type AS file_type_3, t0.file_data AS file_data_4, t0.is_primary AS is_primary_5, t0.old_id AS old_id_6, t0.search_tag AS search_tag_7, t0.image_size AS image_size_8, t0.caption AS caption_9, t0.gz_data AS gz_data_10, t0.news_code AS news_code_11, t0.news_id AS news_id_12 FROM image_store t0 WHERE t0.news_id = 45052 AND t0.is_primary = 1 LIMIT 1;
|
18.37 ms (5.43%)
|
35 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.publish_date AS publish_date_5, t0.featured AS featured_6, t0.meta_title AS meta_title_7, t0.meta_keywords AS meta_keywords_8, t0.meta_description AS meta_description_9, t0.created_on AS created_on_10, t0.file_data AS file_data_11, t0.file_name AS file_name_12, t0.file_type AS file_type_13, t0.trending AS trending_14, t0.is_breaking AS is_breaking_15, t0.old_id AS old_id_16, t0.news_id AS news_id_17, t0.comment_status AS comment_status_18, t0.status AS status_19, t0.youtube_url AS youtube_url_20, t0.youtube_url_second AS youtube_url_second_21, t0.disclaimer AS disclaimer_22, t0.fact_box AS fact_box_23, t0.fact_box_size AS fact_box_size_24, t0.fact_box_placement AS fact_box_placement_25, t0.updated_at AS updated_at_26, t0.last_update_key AS last_update_key_27, t0.category_id AS category_id_28, t0.language_id AS language_id_29, t0.reporter_id AS reporter_id_30, t0.author_id AS author_id_31 FROM news t0 WHERE t0.id = ? LIMIT 1
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.publish_date AS publish_date_5, t0.featured AS featured_6, t0.meta_title AS meta_title_7, t0.meta_keywords AS meta_keywords_8, t0.meta_description AS meta_description_9, t0.created_on AS created_on_10, t0.file_data AS file_data_11, t0.file_name AS file_name_12, t0.file_type AS file_type_13, t0.trending AS trending_14, t0.is_breaking AS is_breaking_15, t0.old_id AS old_id_16, t0.news_id AS news_id_17, t0.comment_status AS comment_status_18, t0.status AS status_19, t0.youtube_url AS youtube_url_20, t0.youtube_url_second AS youtube_url_second_21, t0.disclaimer AS disclaimer_22, t0.fact_box AS fact_box_23, t0.fact_box_size AS fact_box_size_24, t0.fact_box_placement AS fact_box_placement_25, t0.updated_at AS updated_at_26, t0.last_update_key AS last_update_key_27, t0.category_id AS category_id_28, t0.language_id AS language_id_29, t0.reporter_id AS reporter_id_30, t0.author_id AS author_id_31 FROM news t0 WHERE t0.id = 45052 LIMIT 1;
|
14.78 ms (4.37%)
|
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 = ? 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 = 1 AND n0_.status = 'a' ORDER BY n0_.publish_date DESC LIMIT 4;
|
14.38 ms (4.25%)
|
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_.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 = 1 AND n0_.status = 'a' AND n0_.trending = 1 ORDER BY n0_.publish_date DESC LIMIT 10;
|
13.91 ms (4.11%)
|
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_ 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 = 1 AND n0_.status = 'a' ORDER BY n0_.publish_date DESC LIMIT 8;
|
7.39 ms (2.18%)
|
22 |
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters: [
"dharamika-rajaniti"
]
SELECT COUNT(*) FROM category t0 WHERE t0.slug = 'dharamika-rajaniti';
|
4.36 ms (1.29%)
|
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_ WHERE n0_.category_id = ? AND n0_.language_id = ? 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_.category_id = 2096 AND n0_.language_id = 1 LIMIT 4;
|
4.01 ms (1.18%)
|
8 |
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 = 'pa' LIMIT 1;
|
1.96 ms (0.58%)
|
5 |
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 = 2096 LIMIT 1;
|
1.48 ms (0.44%)
|
3 |
SELECT COUNT(a.id)
FROM advertisement a
WHERE a.location = ?
AND a.status = ?
AND a.start_date <= ?
AND a.end_date >= ?
Parameters: [
"header"
"active"
"2026-03-22"
"2026-03-22"
]
SELECT COUNT(a.id)
FROM advertisement a
WHERE a.location = 'header'
AND a.status = 'active'
AND a.start_date <= '2026-03-22'
AND a.end_date >= '2026-03-22';
|
1.20 ms (0.36%)
|
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 = ?
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 = 1045;
|
0.94 ms (0.28%)
|
2 |
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;
|
0.91 ms (0.27%)
|
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
Parameters: [
1
"mega-page"
]
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 = 1 AND t0.name = 'mega-page' LIMIT 1;
|
0.77 ms (0.23%)
|
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 = 1 AND c0_.parent_id IS NULL AND c0_.active = 1 ORDER BY c0_.sorting_rank ASC, c1_.sorting_rank ASC, c1_.name ASC;
|