209.52 ms
(48.14%)
|
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 IS NULL LIMIT 1
Parameters: [
"/r/2"
"2026-03-23"
]
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 = '/r/2' AND t0.date = '2026-03-23' AND t0.language_id IS NULL LIMIT 1;
|
116.94 ms
(26.87%)
|
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_;
|
95.91 ms
(22.04%)
|
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-23 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-23 00:00:00';
|
5.95 ms
(1.37%)
|
2 |
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.06 ms
(0.24%)
|
1 |
SELECT COUNT(n0_.id) AS sclr_0 FROM news n0_ WHERE n0_.reporter_id = ? AND n0_.status = ?
SELECT COUNT(n0_.id) AS sclr_0 FROM news n0_ WHERE n0_.reporter_id = 2 AND n0_.status = 'a';
|
1.00 ms
(0.23%)
|
2 |
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-23"
"2026-03-23"
]
SELECT COUNT(a.id)
FROM advertisement a
WHERE a.location = 'header'
AND a.status = 'active'
AND a.start_date <= '2026-03-23'
AND a.end_date >= '2026-03-23';
|
0.77 ms
(0.18%)
|
1 |
INSERT INTO hit_counter (path, uri, date, hits, unique_views, mime_type, language_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters: [
"/r/2"
"http://www.nazranatimes.com/r/2?lang=pa"
"2026-03-23"
1
1
"*/*"
null
]
INSERT INTO hit_counter (path, uri, date, hits, unique_views, mime_type, language_id) VALUES ('/r/2', 'http://www.nazranatimes.com/r/2?lang=pa', '2026-03-23', 1, 1, '*/*', NULL);
|
0.76 ms
(0.17%)
|
1 |
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_.created_on AS created_on_4, n0_.old_id AS old_id_5, c1_.name AS name_6, l2_.iso AS iso_7 FROM news n0_ INNER JOIN category c1_ ON n0_.category_id = c1_.id INNER JOIN language l2_ ON n0_.language_id = l2_.id WHERE n0_.reporter_id = ? AND n0_.status = ? ORDER BY n0_.publish_date DESC, n0_.id DESC LIMIT 10
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_.created_on AS created_on_4, n0_.old_id AS old_id_5, c1_.name AS name_6, l2_.iso AS iso_7 FROM news n0_ INNER JOIN category c1_ ON n0_.category_id = c1_.id INNER JOIN language l2_ ON n0_.language_id = l2_.id WHERE n0_.reporter_id = 2 AND n0_.status = 'a' ORDER BY n0_.publish_date DESC, n0_.id DESC LIMIT 10;
|
0.75 ms
(0.17%)
|
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.68 ms
(0.16%)
|
1 |
SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.email AS email_2 FROM reporter r0_ WHERE r0_.id = ?
SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.email AS email_2 FROM reporter r0_ WHERE r0_.id = 2;
|
0.62 ms
(0.14%)
|
1 |
"COMMIT"
|
0.51 ms
(0.12%)
|
1 |
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
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 (41139) GROUP BY i0_.news_id;
|
0.48 ms
(0.11%)
|
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;
|
0.28 ms
(0.06%)
|
1 |
"START TRANSACTION"
"START TRANSACTION";
|