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

"START TRANSACTION"

"START TRANSACTION";

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

UPDATE hit_counter SET uri = 'http://www.nazranatimes.com/en/news/amp-jrh8m5p', hits = 3, unique_views = 3 WHERE id = 245187;

"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 = 'en' 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.news_id = ?
  AND t0.language_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.news_id = 'jrh8m5p' AND t0.language_id = 2 LIMIT 1;

SELECT
  count(n0_.id) AS sclr_0,
  c1_.name AS name_1,
  c1_.id AS id_2
FROM
  news n0_
  INNER JOIN category c1_ ON n0_.category_id = c1_.id
WHERE
  n0_.language_id = ?
  AND c1_.language_id = ?
GROUP BY
  n0_.category_id

SELECT count(n0_.id) AS sclr_0, c1_.name AS name_1, c1_.id AS id_2 FROM news n0_ INNER JOIN category c1_ ON n0_.category_id = c1_.id WHERE n0_.language_id = 2 AND c1_.language_id = 2 GROUP BY n0_.category_id;

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 = ?
ORDER BY
  n0_.id 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_ WHERE n0_.language_id = 2 ORDER BY n0_.id DESC LIMIT 10;

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 = 45012 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 = ?
  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 = 45012 AND t0.is_primary = 1 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 = ?

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 = 2095;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2
FROM
  category c0_
  INNER JOIN language l1_ ON c0_.language_id = l1_.id
WHERE
  l1_.iso = ?
  AND c0_.active = 1
  AND c0_.parent_id IS NULL
ORDER BY
  c0_.sorting_rank ASC
LIMIT
  2

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2 FROM category c0_ INNER JOIN language l1_ ON c0_.language_id = l1_.id WHERE l1_.iso = 'en' AND c0_.active = 1 AND c0_.parent_id IS NULL ORDER BY c0_.sorting_rank ASC LIMIT 2;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.is_active AS is_active_6,
  t0.father_name AS father_name_7,
  t0.mother_name AS mother_name_8,
  t0.gender AS gender_9,
  t0.blood_group AS blood_group_10,
  t0.marital_status AS marital_status_11,
  t0.dob AS dob_12,
  t0.birth_place AS birth_place_13,
  t0.address1 AS address1_14,
  t0.address2 AS address2_15,
  t0.city AS city_16,
  t0.state AS state_17,
  t0.phone AS phone_18,
  t0.mobile AS mobile_19,
  t0.media_experience AS media_experience_20,
  t0.family AS family_21,
  t0.camera_type AS camera_type_22,
  t0.pan AS pan_23,
  t0.aadhar AS aadhar_24,
  t0.occupation AS occupation_25,
  t0.expity_date AS expity_date_26,
  t0.status AS status_27,
  t0.pincode AS pincode_28,
  t0.photo AS photo_29,
  t0.is_photo_ok AS is_photo_ok_30,
  t0.joining_date AS joining_date_31,
  t0.sys AS sys_32,
  t0.ip AS ip_33,
  t0.designation AS designation_34,
  t0.parent_id AS parent_id_35,
  t0.country AS country_36,
  t0.file_data AS file_data_37,
  t0.file_type AS file_type_38,
  t0.file_name AS file_name_39,
  t0.is_image_verified AS is_image_verified_40,
  t0.old_id AS old_id_41,
  t0.r_key AS r_key_42,
  t0.qualification AS qualification_43,
  t0.password_reset_key AS password_reset_key_44,
  t0.auto_login_key AS auto_login_key_45,
  t0.document_uploaded AS document_uploaded_46,
  t0.json AS json_47
FROM
  reporter t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.is_active AS is_active_6, t0.father_name AS father_name_7, t0.mother_name AS mother_name_8, t0.gender AS gender_9, t0.blood_group AS blood_group_10, t0.marital_status AS marital_status_11, t0.dob AS dob_12, t0.birth_place AS birth_place_13, t0.address1 AS address1_14, t0.address2 AS address2_15, t0.city AS city_16, t0.state AS state_17, t0.phone AS phone_18, t0.mobile AS mobile_19, t0.media_experience AS media_experience_20, t0.family AS family_21, t0.camera_type AS camera_type_22, t0.pan AS pan_23, t0.aadhar AS aadhar_24, t0.occupation AS occupation_25, t0.expity_date AS expity_date_26, t0.status AS status_27, t0.pincode AS pincode_28, t0.photo AS photo_29, t0.is_photo_ok AS is_photo_ok_30, t0.joining_date AS joining_date_31, t0.sys AS sys_32, t0.ip AS ip_33, t0.designation AS designation_34, t0.parent_id AS parent_id_35, t0.country AS country_36, t0.file_data AS file_data_37, t0.file_type AS file_type_38, t0.file_name AS file_name_39, t0.is_image_verified AS is_image_verified_40, t0.old_id AS old_id_41, t0.r_key AS r_key_42, t0.qualification AS qualification_43, t0.password_reset_key AS password_reset_key_44, t0.auto_login_key AS auto_login_key_45, t0.document_uploaded AS document_uploaded_46, t0.json AS json_47 FROM reporter t0 WHERE t0.id = 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 = ?
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 = 45055 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 = ?
  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 = 45055 AND t0.is_primary = 1 LIMIT 1;