Query Metrics
7
Database Queries
7
Different statements
24.73 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 5.92 ms |
SELECT t0.id AS id_1, t0.description AS description_2, t0.city AS city_3, t0.contact AS contact_4, t0.add_date AS add_date_5, t0.expire AS expire_6, t0.status AS status_7, t0.newsletter AS newsletter_8, t0.position_other AS position_other_9, t0.discipline_other AS discipline_other_10, t0.notification_date AS notification_date_11, t0.location_other AS location_other_12, t0.employment_type_other AS employment_type_other_13, t0.newsletter_name AS newsletter_name_14, t0.newsletter_company AS newsletter_company_15, t0.newsletter_city AS newsletter_city_16, t0.main_page AS main_page_17, t0.logo AS logo_18, t0.premium AS premium_19, t0.email_reminder1 AS email_reminder1_20, t0.name_reminder1 AS name_reminder1_21, t0.email_reminder2 AS email_reminder2_22, t0.name_reminder2 AS name_reminder2_23, t0.email_reminder3 AS email_reminder3_24, t0.name_reminder3 AS name_reminder3_25, t0.reminder_send AS reminder_send_26, t0.notification_send AS notification_send_27, t0.pdf AS pdf_28, t0.deleted AS deleted_29, t0.user_id AS user_id_30, t0.employment_type_id AS employment_type_id_31, t0.country_id AS country_id_32, t0.position_id AS position_id_33, t0.subject_area_id AS subject_area_id_34 FROM announcement t0 WHERE t0.id = ?
Parameters:
[
9610
]
|
| 2 | 1.20 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 | 5.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.requested AS requested_3, t0.ordering AS ordering_4, t0.position_category_id AS position_category_id_5 FROM positions t0 WHERE t0.id = ?
Parameters:
[
40
]
|
| 4 | 2.90 ms |
SELECT t0.id AS id_1, t0.add_date AS add_date_2, t0.status AS status_3, t0.login AS login_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.city AS city_8, t0.street AS street_9, t0.post_code AS post_code_10, t0.phone AS phone_11, t0.mobile_phone AS mobile_phone_12, t0.company_name AS company_name_13, t0.job_title AS job_title_14, t0.black_list AS black_list_15, t0.black_list_description AS black_list_description_16, t0.prefix AS prefix_17, t0.website AS website_18, t0.date_birth AS date_birth_19, t0.current_employer1 AS current_employer1_20, t0.current_employer2 AS current_employer2_21, t0.current_employer3 AS current_employer3_22, t0.phd_supervisor AS phd_supervisor_23, t0.phd_supervisor_number AS phd_supervisor_number_24, t0.engineering_pedagogy AS engineering_pedagogy_25, t0.books_number AS books_number_26, t0.books_chapter_number AS books_chapter_number_27, t0.articles_financial_times_number AS articles_financial_times_number_28, t0.article_peer_reviewed_journal_number AS article_peer_reviewed_journal_number_29, t0.article_professional_journal_number AS article_professional_journal_number_30, t0.available_from AS available_from_31, t0.description AS description_32, t0.jid AS jid_33, t0.gg AS gg_34, t0.remind_password_date AS remind_password_date_35, t0.remind_password_code AS remind_password_code_36, t0.cv_file AS cv_file_37, t0.autologin_key AS autologin_key_38, t0.email_confirmed AS email_confirmed_39, t0.education_level_year AS education_level_year_40, t0.education_level_name AS education_level_name_41, t0.corporate_consulting AS corporate_consulting_42, t0.full_access_expire_date AS full_access_expire_date_43, t0.logo AS logo_44, t0.logo_list AS logo_list_45, t0.logo_content AS logo_content_46, t0.user_group_id AS user_group_id_47, t0.country_id AS country_id_48, t0.english_level_id AS english_level_id_49, t0.education_level_id AS education_level_id_50, t0.managerial_experience_id AS managerial_experience_id_51, t0.pedagogic_experience_id AS pedagogic_experience_id_52, t0.employment_type_id AS employment_type_id_53, t0.academic_program_level_id AS academic_program_level_id_54, t0.executive_education_target_id AS executive_education_target_id_55, t0.nationality_id AS nationality_id_56 FROM "user" t0 WHERE t0.id = ?
Parameters:
[
668
]
|
| 5 | 2.44 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:
[] |
| 6 | 3.69 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:
[] |
| 7 | 3.47 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.