Query Metrics

17 Database Queries
14 Different statements
67.53 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
10.37 ms
(15.36%)
2
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:
[
  10916
]
8.53 ms
(12.63%)
2
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"
]
6.69 ms
(9.91%)
1
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
]
5.81 ms
(8.60%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3 FROM country t0 WHERE t0.id = ?
Parameters:
[
  176
]
5.33 ms
(7.89%)
1
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:
[
  9671
]
4.21 ms
(6.23%)
1
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_ WHERE a0_.id IN (?) AND a0_.status = ? AND a0_.deleted = ? AND a0_.expire >= ? AND a0_.id <> ?
Parameters:
[
  "9665"
  1
  0
  "2026-03-10 13:24:46"
  9671
]
4.12 ms
(6.10%)
1
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
]
3.74 ms
(5.54%)
1
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.35 ms
(4.96%)
1
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
]
3.35 ms
(4.96%)
1
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:
[]
3.26 ms
(4.83%)
1
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
]
3.18 ms
(4.70%)
1
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
]
2.99 ms
(4.43%)
1
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:
[]
2.61 ms
(3.86%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3 FROM subject_area t0 WHERE t0.id = ?
Parameters:
[
  13
]

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

Class Mapping errors
App\Common\Entity\Announcement\Announcement No errors.
App\Common\Entity\User\User No errors.
App\Common\Entity\Employment\EmploymentType No errors.
App\Common\Entity\Country\Country No errors.
App\Common\Entity\Education\Positions No errors.
App\Common\Entity\Education\SubjectArea No errors.
App\Common\Entity\SocialMedia\SocialNetworkFeed No errors.
App\Common\Entity\SiteSetting No errors.
App\Common\Entity\Education\PositionCategory No errors.
App\Common\Entity\User\UserGroup No errors.
App\Common\Entity\Education\EnglishLevel No errors.
App\Common\Entity\Education\EducationLevel No errors.
App\Common\Entity\Employment\ManagerialExperience No errors.
App\Common\Entity\Education\PedagogicExperience No errors.
App\Common\Entity\Academy\AcademicProgramLevel No errors.
App\Common\Entity\Education\ExecutiveEducationTarget No errors.
App\Common\Entity\Country\Nationality No errors.
App\Common\Entity\Language\Language2 No errors.
App\Common\Entity\Education\ManagerialExperienceDetail No errors.
App\Common\Entity\Academy\AcademicProgramDetail No errors.
App\Common\Entity\Article\ArticleDetail No errors.
App\Common\Entity\Education\ExecutiveEducationDetail No errors.
App\Common\Entity\Book\BookDetail No errors.
App\Common\Entity\Payment\Payment No errors.
App\Common\Entity\Cookie No errors.
App\Common\Entity\Article\Menu No errors.
App\Common\Entity\Setting\Setting No errors.
App\Common\Entity\Setting\SettingSection No errors.
App\Common\Entity\Setting\SettingType No errors.
App\Common\Entity\SocialMedia\SocialNetwork No errors.
App\Common\Entity\User\Role No errors.
App\Common\Entity\Education\ManagerialExperiencePosition No errors.
App\Common\Entity\Article\ArticleJournal No errors.
App\Common\Entity\Payment\PaymentType No errors.
App\Common\Entity\Article\Article No errors.
App\Common\Entity\Article\ArticleCategory No errors.
App\Common\Entity\Article\Image No errors.
App\Common\Entity\Article\ArticleLayout No errors.
App\Common\Entity\Form\Form No errors.