| 1 |
0.62 ms |
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;
|
| 2 |
0.35 ms |
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;
|
| 3 |
0.44 ms |
SELECT COUNT(a.id)
FROM advertisement a
WHERE a.location = ?
AND a.status = ?
AND a.start_date <= ?
AND a.end_date >= ?
Parameters: [
"sidebar"
"active"
"2026-03-24"
"2026-03-24"
]
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';
|
| 4 |
0.83 ms |
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 ?
Parameters: [
"sidebar"
"active"
"2026-03-24"
"2026-03-24"
0
]
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 0;
|
| 5 |
0.43 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2 FROM category c0_ WHERE c0_.id = ? AND c0_.language_id = ?
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2 FROM category c0_ WHERE c0_.id = 2093 AND c0_.language_id = 3;
|
| 6 |
10.43 ms |
SELECT COUNT(DISTINCT n0_.id) AS sclr_0 FROM news n0_ LEFT JOIN news_additional_categories n2_ ON n0_.id = n2_.news_id LEFT JOIN category c1_ ON c1_.id = n2_.category_id WHERE ((n0_.category_id = ? OR c1_.id = ?)) AND n0_.language_id = ? AND n0_.status = ?
Parameters: [
2093
2093
3
"a"
]
SELECT COUNT(DISTINCT n0_.id) AS sclr_0 FROM news n0_ LEFT JOIN news_additional_categories n2_ ON n0_.id = n2_.news_id LEFT JOIN category c1_ ON c1_.id = n2_.category_id WHERE ((n0_.category_id = 2093 OR c1_.id = 2093)) AND n0_.language_id = 3 AND n0_.status = 'a';
|
| 7 |
0.37 ms |
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;
|
| 8 |
0.62 ms |
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;
|
| 9 |
0.39 ms |
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-24"
"2026-03-24"
]
SELECT COUNT(a.id)
FROM advertisement a
WHERE a.location = 'header'
AND a.status = 'active'
AND a.start_date <= '2026-03-24'
AND a.end_date >= '2026-03-24';
|
| 10 |
0.35 ms |
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters: [
"samajika"
]
SELECT COUNT(*) FROM category t0 WHERE t0.slug = 'samajika';
|
| 11 |
0.32 ms |
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters: [
"intaranesanala"
]
SELECT COUNT(*) FROM category t0 WHERE t0.slug = 'intaranesanala';
|
| 12 |
0.40 ms |
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters: [
"teknolaji"
]
SELECT COUNT(*) FROM category t0 WHERE t0.slug = 'teknolaji';
|
| 13 |
0.33 ms |
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
SELECT COUNT(*) FROM category t0 WHERE t0.slug = 'kavita';
|
| 14 |
0.34 ms |
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters: [
"dharmika-rajaniti"
]
SELECT COUNT(*) FROM category t0 WHERE t0.slug = 'dharmika-rajaniti';
|
| 15 |
0.39 ms |
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters: [
"durghatana"
]
SELECT COUNT(*) FROM category t0 WHERE t0.slug = 'durghatana';
|
| 16 |
0.49 ms |
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters: [
"rajaniti"
]
SELECT COUNT(*) FROM category t0 WHERE t0.slug = 'rajaniti';
|
| 17 |
0.44 ms |
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters: [
"kanuna-kra-ima"
]
SELECT COUNT(*) FROM category t0 WHERE t0.slug = 'kanuna-kra-ima';
|
| 18 |
0.54 ms |
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters: [
"dharmika"
]
SELECT COUNT(*) FROM category t0 WHERE t0.slug = 'dharmika';
|
| 19 |
27.98 ms |
SELECT n0_.id AS id_0, n0_.news_id AS news_id_1, n0_.title AS title_2, n0_.publish_date AS publish_date_3, n0_.content AS content_4, n0_.old_id AS old_id_5 FROM news n0_ LEFT JOIN news_additional_categories n2_ ON n0_.id = n2_.news_id LEFT JOIN category c1_ ON c1_.id = n2_.category_id WHERE ((n0_.category_id = ? OR c1_.id = ?)) AND n0_.language_id = ? AND n0_.status = ? GROUP BY n0_.id, n0_.news_id, n0_.title, n0_.publish_date, n0_.content, n0_.old_id ORDER BY n0_.publish_date DESC, n0_.id DESC LIMIT 10
Parameters: [
2093
2093
3
"a"
]
SELECT n0_.id AS id_0, n0_.news_id AS news_id_1, n0_.title AS title_2, n0_.publish_date AS publish_date_3, n0_.content AS content_4, n0_.old_id AS old_id_5 FROM news n0_ LEFT JOIN news_additional_categories n2_ ON n0_.id = n2_.news_id LEFT JOIN category c1_ ON c1_.id = n2_.category_id WHERE ((n0_.category_id = 2093 OR c1_.id = 2093)) AND n0_.language_id = 3 AND n0_.status = 'a' GROUP BY n0_.id, n0_.news_id, n0_.title, n0_.publish_date, n0_.content, n0_.old_id ORDER BY n0_.publish_date DESC, n0_.id DESC LIMIT 10;
|
| 20 |
1.11 ms |
SELECT i0_.news_id AS sclr_0, MAX(i0_.id) AS sclr_1 FROM image_store i0_ WHERE i0_.is_primary = ? AND i0_.news_id IN (?, ?, ?) GROUP BY i0_.news_id
Parameters: [
1
45078
44874
42719
]
SELECT i0_.news_id AS sclr_0, MAX(i0_.id) AS sclr_1 FROM image_store i0_ WHERE i0_.is_primary = 1 AND i0_.news_id IN (45078, 44874, 42719) GROUP BY i0_.news_id;
|
| 21 |
0.46 ms |
SELECT COUNT(a.id)
FROM advertisement a
WHERE a.location = ?
AND a.status = ?
AND a.start_date <= ?
AND a.end_date >= ?
Parameters: [
"mega_footer"
"active"
"2026-03-24"
"2026-03-24"
]
SELECT COUNT(a.id)
FROM advertisement a
WHERE a.location = 'mega_footer'
AND a.status = 'active'
AND a.start_date <= '2026-03-24'
AND a.end_date >= '2026-03-24';
|
| 22 |
0.47 ms |
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;
|
| 23 |
125.40 ms |
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_;
|
| 24 |
110.01 ms |
SELECT SUM(h0_.hits) AS sclr_0, SUM(h0_.unique_views) AS sclr_1 FROM hit_counter h0_ WHERE h0_.date = ?
Parameters: [
"2026-03-24 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-24 00:00:00';
|