Query Metrics

5 Database Queries
5 Different statements
91.17 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 85.86 ms
SELECT a0_.id AS id_0, a0_.description AS description_1, a0_.city AS city_2, a0_.contact AS contact_3, a0_.add_date AS add_date_4, a0_.expire AS expire_5, a0_.status AS status_6, a0_.newsletter AS newsletter_7, a0_.position_other AS position_other_8, a0_.discipline_other AS discipline_other_9, a0_.notification_date AS notification_date_10, a0_.location_other AS location_other_11, a0_.employment_type_other AS employment_type_other_12, a0_.newsletter_name AS newsletter_name_13, a0_.newsletter_company AS newsletter_company_14, a0_.newsletter_city AS newsletter_city_15, a0_.main_page AS main_page_16, a0_.logo AS logo_17, a0_.premium AS premium_18, a0_.email_reminder1 AS email_reminder1_19, a0_.name_reminder1 AS name_reminder1_20, a0_.email_reminder2 AS email_reminder2_21, a0_.name_reminder2 AS name_reminder2_22, a0_.email_reminder3 AS email_reminder3_23, a0_.name_reminder3 AS name_reminder3_24, a0_.reminder_send AS reminder_send_25, a0_.notification_send AS notification_send_26, a0_.pdf AS pdf_27, a0_.deleted AS deleted_28, a0_.user_id AS user_id_29, a0_.employment_type_id AS employment_type_id_30, a0_.country_id AS country_id_31, a0_.position_id AS position_id_32, a0_.subject_area_id AS subject_area_id_33 FROM announcement a0_ LEFT JOIN country c1_ ON a0_.country_id = c1_.id LEFT JOIN "user" u2_ ON a0_.user_id = u2_.id LEFT JOIN positions p3_ ON a0_.position_id = p3_.id LEFT JOIN employment_type e4_ ON a0_.employment_type_id = e4_.id LEFT JOIN subject_area s5_ ON a0_.subject_area_id = s5_.id WHERE a0_.status = ? AND a0_.deleted = ? AND a0_.expire >= ? ORDER BY a0_.premium DESC, a0_.add_date DESC
Parameters:
[
  1
  0
  "2026-03-10 12:29:56"
]
2 1.82 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.meta_description AS meta_description_3, t0.keywords AS keywords_4, t0.author AS author_5, t0.copyright AS copyright_6, t0.logo_name AS logo_name_7, t0.social_media_logo_name AS social_media_logo_name_8, t0.banner_name AS banner_name_9, t0.map_iframe AS map_iframe_10, t0.company_name AS company_name_11, t0.address AS address_12, t0.post_code AS post_code_13, t0.city AS city_14, t0.phone AS phone_15, t0.phone2 AS phone2_16, t0.email AS email_17, t0.nip AS nip_18, t0.facebook_url AS facebook_url_19, t0.instagram_url AS instagram_url_20, t0.twitter_url AS twitter_url_21, t0.linkedin_url AS linkedin_url_22, t0.you_tube_url AS you_tube_url_23, t0.pinterest_url AS pinterest_url_24, t0.code_head AS code_head_25, t0.code_body AS code_body_26, t0.contact_form_email AS contact_form_email_27, t0.favicon_name AS favicon_name_28, t0.tik_tok_url AS tik_tok_url_29 FROM site_setting t0 WHERE t0.id = ?
Parameters:
[
  1
]
3 0.83 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.code AS code_2, c0_.active AS active_3 FROM cookie c0_
Parameters:
[]
4 0.87 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.link AS link_3, t0.position_type AS position_type_4, t0.sort AS sort_5, t0.locale AS locale_6 FROM menu t0 ORDER BY t0.sort ASC
Parameters:
[]
5 1.78 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.alias AS alias_2, s0_.ordering AS ordering_3, s0_.status AS status_4, s0_.value AS value_5, s0_.setting_section_id AS setting_section_id_6, s0_.setting_type_id AS setting_type_id_7 FROM setting s0_ INNER JOIN setting_section s1_ ON s0_.setting_section_id = s1_.id WHERE s1_.alias = ?
Parameters:
[
  "social"
]

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.