Query Metrics
14
Database Queries
13
Different statements
52.10 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 11.40 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:
[
9597
]
|
| 2 | 4.45 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 | 3.23 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 | 5.92 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:
[
13458
]
|
| 5 | 2.52 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.27 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 | 5.27 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"
]
|
| 8 | 1.05 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3 FROM country t0 WHERE t0.id = ?
Parameters:
[
45
]
|
| 9 | 3.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3 FROM subject_area t0 WHERE t0.id = ?
Parameters:
[
7
]
|
| 10 | 0.86 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3 FROM employment_type t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 11 | 1.29 ms |
SELECT dc.id, dc.name as category_name FROM document_category dc WHERE dc.id IN (?, ?, ?, ?) ORDER BY dc.ordering ASC
Parameters:
[ 5 6 7 8 ] |
| 12 | 2.95 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"
]
|
| 13 | 3.45 ms |
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.title_alt AS title_alt_2, a0_.status AS status_3, a0_.permalink AS permalink_4, a0_.lead_content AS lead_content_5, a0_.content AS content_6, a0_.meta_description AS meta_description_7, a0_.link AS link_8, a0_.link_text AS link_text_9, a0_.sort AS sort_10, a0_.target_blank AS target_blank_11, a0_.is_system AS is_system_12, a0_.system_name AS system_name_13, a0_.locale AS locale_14, a0_.form_position AS form_position_15, a0_.published_at AS published_at_16, a0_.updated_at AS updated_at_17, a0_.created_at AS created_at_18, a0_.category_id AS category_id_19, a0_.image_id AS image_id_20, a0_.layout_id AS layout_id_21, a0_.owner_id AS owner_id_22, a0_.updated_by_id AS updated_by_id_23, a0_.form_id AS form_id_24 FROM article a0_ LEFT JOIN article_category a1_ ON a0_.category_id = a1_.id WHERE a1_.name = ? AND a0_.status = ? LIMIT 1
Parameters:
[ "Menu footer small" 1 ] |
| 14 | 3.29 ms |
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.title_alt AS title_alt_2, a0_.status AS status_3, a0_.permalink AS permalink_4, a0_.lead_content AS lead_content_5, a0_.content AS content_6, a0_.meta_description AS meta_description_7, a0_.link AS link_8, a0_.link_text AS link_text_9, a0_.sort AS sort_10, a0_.target_blank AS target_blank_11, a0_.is_system AS is_system_12, a0_.system_name AS system_name_13, a0_.locale AS locale_14, a0_.form_position AS form_position_15, a0_.published_at AS published_at_16, a0_.updated_at AS updated_at_17, a0_.created_at AS created_at_18, a0_.category_id AS category_id_19, a0_.image_id AS image_id_20, a0_.layout_id AS layout_id_21, a0_.owner_id AS owner_id_22, a0_.updated_by_id AS updated_by_id_23, a0_.form_id AS form_id_24 FROM article a0_ LEFT JOIN article_category a1_ ON a0_.category_id = a1_.id WHERE a1_.name = ? AND a0_.status = ? ORDER BY a0_.sort ASC
Parameters:
[ "Menu footer" 1 ] |
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.