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 = 'pa' LIMIT 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

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/news-AdfQbf' AND t0.date = '2026-03-21' AND t0.language_id = 1 LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  hit_counter
SET
  uri = ?,
  hits = ?,
  unique_views = ?,
  mime_type = ?
WHERE
  id = ?

UPDATE hit_counter SET uri = 'http://www.nazranatimes.com/pa/news-AdfQbf', hits = 2, unique_views = 2, mime_type = 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8' WHERE id = 246292;

"COMMIT"

"COMMIT";

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;

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_.old_id AS old_id_4,
  n0_.meta_title AS meta_title_5,
  n0_.meta_description AS meta_description_6,
  n0_.content AS content_7,
  n0_.meta_keywords AS meta_keywords_8,
  c1_.name AS name_9,
  c1_.id AS id_10,
  n0_.youtube_url AS youtube_url_11,
  n0_.youtube_url_second AS youtube_url_second_12,
  r2_.id AS id_13,
  r2_.name AS name_14,
  l3_.iso AS iso_15,
  n0_.comment_status AS comment_status_16,
  n0_.disclaimer AS disclaimer_17,
  a4_.id AS id_18,
  a4_.name AS name_19,
  a4_.email AS email_20,
  a4_.mobile AS mobile_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
FROM
  news n0_
  LEFT JOIN reporter r2_ ON n0_.reporter_id = r2_.id
  INNER JOIN category c1_ ON n0_.category_id = c1_.id
  INNER JOIN language l3_ ON n0_.language_id = l3_.id
  LEFT JOIN author a4_ ON n0_.author_id = a4_.id
WHERE
  n0_.news_id = ?
  AND n0_.language_id = ?
  AND n0_.status = ?

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_.old_id AS old_id_4, n0_.meta_title AS meta_title_5, n0_.meta_description AS meta_description_6, n0_.content AS content_7, n0_.meta_keywords AS meta_keywords_8, c1_.name AS name_9, c1_.id AS id_10, n0_.youtube_url AS youtube_url_11, n0_.youtube_url_second AS youtube_url_second_12, r2_.id AS id_13, r2_.name AS name_14, l3_.iso AS iso_15, n0_.comment_status AS comment_status_16, n0_.disclaimer AS disclaimer_17, a4_.id AS id_18, a4_.name AS name_19, a4_.email AS email_20, a4_.mobile AS mobile_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 FROM news n0_ LEFT JOIN reporter r2_ ON n0_.reporter_id = r2_.id INNER JOIN category c1_ ON n0_.category_id = c1_.id INNER JOIN language l3_ ON n0_.language_id = l3_.id LEFT JOIN author a4_ ON n0_.author_id = a4_.id WHERE n0_.news_id = 'AdfQbf' AND n0_.language_id = 1 AND n0_.status = 'a';

SELECT
  i0_.id AS id_0,
  i0_.image_size AS image_size_1,
  i0_.file_name AS file_name_2
FROM
  image_store i0_
WHERE
  i0_.news_id = ?
  AND i0_.is_primary = ?
ORDER BY
  i0_.id DESC
LIMIT
  1

SELECT i0_.id AS id_0, i0_.image_size AS image_size_1, i0_.file_name AS file_name_2 FROM image_store i0_ WHERE i0_.news_id = 40831 AND i0_.is_primary = 1 ORDER BY i0_.id DESC LIMIT 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,
  MAX(i1_.id) AS sclr_4
FROM
  news n0_
  LEFT JOIN image_store i1_ ON n0_.id = i1_.news_id
  AND (i1_.is_primary = ?)
WHERE
  n0_.language_id = ?
  AND n0_.status = ?
  AND n0_.id <> ?
  AND (
    (
      n0_.publish_date < ?
      OR (
        n0_.publish_date = ?
        AND n0_.id < ?
      )
    )
  )
GROUP BY
  n0_.id,
  n0_.news_id,
  n0_.title,
  n0_.publish_date
ORDER BY
  n0_.publish_date DESC,
  n0_.id DESC
LIMIT
  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, MAX(i1_.id) AS sclr_4 FROM news n0_ LEFT JOIN image_store i1_ ON n0_.id = i1_.news_id AND (i1_.is_primary = 1) WHERE n0_.language_id = 1 AND n0_.status = 'a' AND n0_.id <> 40831 AND ((n0_.publish_date < '2025-01-20 05:30:00' OR (n0_.publish_date = '2025-01-20 05:30:00' AND n0_.id < 40831))) GROUP BY n0_.id, n0_.news_id, n0_.title, n0_.publish_date ORDER BY n0_.publish_date DESC, n0_.id DESC LIMIT 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,
  MAX(i1_.id) AS sclr_4
FROM
  news n0_
  LEFT JOIN image_store i1_ ON n0_.id = i1_.news_id
  AND (i1_.is_primary = ?)
WHERE
  n0_.language_id = ?
  AND n0_.status = ?
  AND n0_.id <> ?
  AND (
    (
      n0_.publish_date > ?
      OR (
        n0_.publish_date = ?
        AND n0_.id > ?
      )
    )
  )
GROUP BY
  n0_.id,
  n0_.news_id,
  n0_.title,
  n0_.publish_date
ORDER BY
  n0_.publish_date ASC,
  n0_.id ASC
LIMIT
  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, MAX(i1_.id) AS sclr_4 FROM news n0_ LEFT JOIN image_store i1_ ON n0_.id = i1_.news_id AND (i1_.is_primary = 1) WHERE n0_.language_id = 1 AND n0_.status = 'a' AND n0_.id <> 40831 AND ((n0_.publish_date > '2025-01-20 05:30:00' OR (n0_.publish_date = '2025-01-20 05:30:00' AND n0_.id > 40831))) GROUP BY n0_.id, n0_.news_id, n0_.title, n0_.publish_date ORDER BY n0_.publish_date ASC, n0_.id ASC LIMIT 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,
  MAX(i1_.id) AS sclr_4
FROM
  news n0_
  INNER JOIN image_store i1_ ON n0_.id = i1_.news_id
  AND (i1_.is_primary = ?)
WHERE
  n0_.language_id = ?
  AND n0_.category_id = ?
  AND n0_.status = ?
  AND n0_.id <> ?
  AND n0_.id NOT IN (?, ?)
GROUP BY
  n0_.id,
  n0_.news_id,
  n0_.title,
  n0_.publish_date
ORDER BY
  n0_.publish_date DESC,
  n0_.id DESC
LIMIT
  3

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, MAX(i1_.id) AS sclr_4 FROM news n0_ INNER JOIN image_store i1_ ON n0_.id = i1_.news_id AND (i1_.is_primary = 1) WHERE n0_.language_id = 1 AND n0_.category_id = 1042 AND n0_.status = 'a' AND n0_.id <> 40831 AND n0_.id NOT IN (41027, 41030) GROUP BY n0_.id, n0_.news_id, n0_.title, n0_.publish_date ORDER BY n0_.publish_date DESC, n0_.id DESC LIMIT 3;

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 = 'under_news'
               AND a.status = 'active'
               AND a.start_date <= '2026-03-21'
               AND a.end_date >= '2026-03-21';

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 = 'under_news'
               AND a.status = 'active'
               AND a.start_date <= '2026-03-21'
               AND a.end_date >= '2026-03-21'
             ORDER BY a.id ASC
             LIMIT 1 OFFSET 0;

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-21'
               AND a.end_date >= '2026-03-21';

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-21'
               AND a.end_date >= '2026-03-21'
             ORDER BY a.id ASC
             LIMIT 1 OFFSET 1;

SELECT
  b0_.id AS id_0,
  b0_.type AS type_1,
  b0_.file_name AS file_name_2,
  b0_.file_type AS file_type_3,
  l1_.iso AS iso_4
FROM
  branding_image b0_
  LEFT JOIN language l1_ ON b0_.language_id = l1_.id
WHERE
  b0_.type = ?
  AND l1_.iso = ?
ORDER BY
  b0_.id DESC
LIMIT
  1

SELECT b0_.id AS id_0, b0_.type AS type_1, b0_.file_name AS file_name_2, b0_.file_type AS file_type_3, l1_.iso AS iso_4 FROM branding_image b0_ LEFT JOIN language l1_ ON b0_.language_id = l1_.id WHERE b0_.type = 'social' AND l1_.iso = 'pa' ORDER BY b0_.id DESC 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 = 'pa' 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 = 1 AND c0_.parent_id IS NULL AND c0_.active = 1 ORDER BY c0_.sorting_rank ASC, c1_.sorting_rank ASC, c1_.name ASC;

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 = 'header'
               AND a.status = 'active'
               AND a.start_date <= '2026-03-21'
               AND a.end_date >= '2026-03-21';

SELECT
  COUNT(*)
FROM
  category t0
WHERE
  t0.slug = ?

SELECT COUNT(*) FROM category t0 WHERE t0.slug = 'dharamika-rajaniti';

SELECT
  COUNT(*)
FROM
  category t0
WHERE
  t0.slug = ?

SELECT COUNT(*) FROM category t0 WHERE t0.slug = 'atararasatari';