Query Metrics

34 Database Queries
10 Different statements
55.90 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.81 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
Parameters:
[
  "pa"
]
2 0.40 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
Parameters:
[
  "pa"
]
3 0.43 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
Parameters:
[]
4 14.78 ms
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_ INNER JOIN image_store i1_ ON n0_.id = i1_.news_id WHERE n0_.language_id = ? AND n0_.status = ? ORDER BY n0_.publish_date DESC LIMIT 4
Parameters:
[
  1
  "a"
]
5 13.91 ms
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 = ? AND n0_.status = ? ORDER BY n0_.publish_date DESC LIMIT 8
Parameters:
[
  1
  "a"
]
6 14.38 ms
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_ INNER JOIN image_store i1_ ON n0_.id = i1_.news_id WHERE n0_.language_id = ? AND n0_.status = ? AND n0_.trending = 1 ORDER BY n0_.publish_date DESC LIMIT 10
Parameters:
[
  1
  "a"
]
7 0.91 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.config AS config_3, t0.language_id AS language_id_4 FROM home_page_config t0 WHERE t0.language_id = ? AND t0.name = ? LIMIT 1
Parameters:
[
  1
  "mega-page"
]
8 0.79 ms
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 = ?
Parameters:
[
  1045
]
9 0.42 ms
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 = ?
Parameters:
[
  1042
]
10 0.44 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
Parameters:
[
  "pa"
]
11 0.77 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
Parameters:
[
  1
]
12 0.49 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-22"
  "2026-03-22"
]
13 0.38 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "dharamika-rajaniti"
]
14 0.40 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "atararasatari"
]
15 0.33 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "gurabani-itihasa"
]
16 0.32 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "archived"
]
17 0.31 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "religeus"
]
18 0.34 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "aparadha"
]
19 0.36 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "sapadaki"
]
20 0.32 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "samaja-seva"
]
21 0.32 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "sikhi-a-vigi-ana"
]
22 0.31 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "soga-dukha-da-pragatava"
]
23 0.33 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "kahani"
]
24 0.32 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "kanuna"
]
25 0.35 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "kavita"
]
26 0.32 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "karobara"
]
27 0.36 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "kheda"
]
28 0.31 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "conam"
]
29 0.32 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "jivana-saili"
]
30 0.33 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "taikanoloji"
]
31 0.32 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "rasatari"
]
32 0.36 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "manorajana"
]
33 0.31 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "rajaniti"
]
34 0.36 ms
SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?
Parameters:
[
  "vana-suvana"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping