506.27 ms (91.56%)
|
1 |
SELECT t0.id AS id_1, t0.path AS path_2, t0.uri AS uri_3, t0.date AS date_4, t0.hits AS hits_5, t0.unique_views AS unique_views_6, t0.mime_type AS mime_type_7, t0.language_id AS language_id_8 FROM hit_counter t0 WHERE t0.path = ? AND t0.date = ? AND t0.language_id = ? LIMIT 1
Parameters: [
"/pa/category/1041/taikanoloji"
"2026-03-26"
1
]
SELECT t0.id AS id_1, t0.path AS path_2, t0.uri AS uri_3, t0.date AS date_4, t0.hits AS hits_5, t0.unique_views AS unique_views_6, t0.mime_type AS mime_type_7, t0.language_id AS language_id_8 FROM hit_counter t0 WHERE t0.path = '/pa/category/1041/taikanoloji' AND t0.date = '2026-03-26' AND t0.language_id = 1 LIMIT 1;
|
19.35 ms (3.50%)
|
1 |
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: [
1041
1041
1
"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 = 1041 OR c1_.id = 1041)) AND n0_.language_id = 1 AND n0_.status = 'a';
|
6.84 ms (1.24%)
|
1 |
"COMMIT"
|
5.59 ms (1.01%)
|
1 |
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-26"
"2026-03-26"
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-26'
AND a.end_date >= '2026-03-26'
ORDER BY a.id ASC
LIMIT 1 OFFSET 0;
|
5.36 ms (0.97%)
|
22 |
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters: [
"dharamika-rajaniti"
]
SELECT COUNT(*) FROM category t0 WHERE t0.slug = 'dharamika-rajaniti';
|
1.91 ms (0.35%)
|
1 |
"START TRANSACTION"
"START TRANSACTION";
|
1.39 ms (0.25%)
|
2 |
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.url AS url_2, e0_.target AS target_3, e0_.is_active AS is_active_4, e0_.location AS location_5, e0_.icon AS icon_6, e0_.sorting_order AS sorting_order_7, e1_.id AS id_8, e1_.name AS name_9, e1_.url AS url_10, e1_.target AS target_11, e1_.is_active AS is_active_12, e1_.location AS location_13, e1_.icon AS icon_14, e1_.sorting_order AS sorting_order_15, e0_.parent_id AS parent_id_16, e1_.parent_id AS parent_id_17 FROM extra_nav e0_ LEFT JOIN extra_nav e1_ ON e0_.parent_id = e1_.id WHERE e0_.location = ? AND e0_.is_active = ? ORDER BY e0_.sorting_order ASC, e0_.id ASC
Parameters: [
"bottom"
1
]
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.url AS url_2, e0_.target AS target_3, e0_.is_active AS is_active_4, e0_.location AS location_5, e0_.icon AS icon_6, e0_.sorting_order AS sorting_order_7, e1_.id AS id_8, e1_.name AS name_9, e1_.url AS url_10, e1_.target AS target_11, e1_.is_active AS is_active_12, e1_.location AS location_13, e1_.icon AS icon_14, e1_.sorting_order AS sorting_order_15, e0_.parent_id AS parent_id_16, e1_.parent_id AS parent_id_17 FROM extra_nav e0_ LEFT JOIN extra_nav e1_ ON e0_.parent_id = e1_.id WHERE e0_.location = 'bottom' AND e0_.is_active = 1 ORDER BY e0_.sorting_order ASC, e0_.id ASC;
|
1.29 ms (0.23%)
|
3 |
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.00 ms (0.18%)
|
2 |
SELECT i0_.text_value AS text_value_0 FROM includs_in_web i0_ WHERE i0_.location = ? AND i0_.active = ? ORDER BY i0_.sorting_rank ASC, i0_.id DESC
Parameters: [
"inHead"
1
]
SELECT i0_.text_value AS text_value_0 FROM includs_in_web i0_ WHERE i0_.location = 'inHead' AND i0_.active = 1 ORDER BY i0_.sorting_rank ASC, i0_.id DESC;
|
0.73 ms (0.13%)
|
1 |
SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.slug AS slug_2, w0_.url AS url_3, w0_.location AS location_4, w0_.sorting_rank AS sorting_rank_5, w0_.is_home AS is_home_6 FROM web_page w0_ WHERE w0_.is_published = ? ORDER BY w0_.sorting_rank ASC
SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.slug AS slug_2, w0_.url AS url_3, w0_.location AS location_4, w0_.sorting_rank AS sorting_rank_5, w0_.is_home AS is_home_6 FROM web_page w0_ WHERE w0_.is_published = 1 ORDER BY w0_.sorting_rank ASC;
|
0.72 ms (0.13%)
|
2 |
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-26"
"2026-03-26"
]
SELECT COUNT(a.id)
FROM advertisement a
WHERE a.location = 'sidebar'
AND a.status = 'active'
AND a.start_date <= '2026-03-26'
AND a.end_date >= '2026-03-26';
|
0.65 ms (0.12%)
|
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;
|
0.64 ms (0.12%)
|
1 |
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 = 1041 AND c0_.language_id = 1;
|
0.63 ms (0.11%)
|
1 |
UPDATE hit_counter SET uri = ?, hits = ?, unique_views = ?, mime_type = ? WHERE id = ?
Parameters: [
"http://nazranatimes.com/public/pa/category/1041/taikanoloji"
3
3
"*/*"
267416
]
UPDATE hit_counter SET uri = 'http://nazranatimes.com/public/pa/category/1041/taikanoloji', hits = 3, unique_views = 3, mime_type = '*/*' WHERE id = 267416;
|
0.59 ms (0.11%)
|
1 |
SELECT l0_.name AS name_0, l0_.value AS value_1 FROM layout_setting l0_
SELECT l0_.name AS name_0, l0_.value AS value_1 FROM layout_setting l0_;
|