Query Metrics

7 Database Queries
7 Different statements
11.26 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 2.98 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:
[
  9653
]
2 1.43 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.89 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 1.97 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:
[
  18476
]
5 0.92 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 1.09 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 1.98 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.

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.