Query Metrics

25 Database Queries
20 Different statements
23.45 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
3.30 ms
(14.06%)
6
SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3 FROM position_category t0 WHERE t0.id = ?
Parameters:
[
  1
]
1.91 ms
(8.14%)
1
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.requested AS requested_2, p0_.ordering AS ordering_3, p0_.position_category_id AS position_category_id_4 FROM positions p0_ LEFT JOIN position_category p1_ ON p0_.position_category_id = p1_.id ORDER BY p1_.ordering ASC, p0_.name ASC
Parameters:
[]
1.84 ms
(7.83%)
1
SELECT e0_.id AS id_0, e0_.name AS name_1 FROM english_level e0_ ORDER BY e0_.name ASC
Parameters:
[]
1.72 ms
(7.32%)
1
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"
]
1.60 ms
(6.82%)
1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.ordering AS ordering_2 FROM country c0_ ORDER BY c0_.name ASC
Parameters:
[]
1.45 ms
(6.19%)
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
]
1.23 ms
(5.26%)
1
SELECT n0_.id AS id_0, n0_.name AS name_1 FROM nationality n0_ ORDER BY n0_.name ASC
Parameters:
[]
1.12 ms
(4.78%)
1
SELECT l0_.id AS id_0, l0_.name AS name_1 FROM language_2 l0_ ORDER BY l0_.name ASC
Parameters:
[]
1.00 ms
(4.29%)
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:
[]
0.97 ms
(4.14%)
1
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.requested AS requested_2, p0_.ordering AS ordering_3, p0_.position_category_id AS position_category_id_4 FROM positions p0_ LEFT JOIN position_category p1_ ON p0_.position_category_id = p1_.id WHERE p1_.id <> ? ORDER BY p1_.ordering ASC, p0_.name ASC
Parameters:
[
  4
]
0.97 ms
(4.12%)
1
SELECT e0_.id AS id_0, e0_.name AS name_1 FROM education_level e0_ ORDER BY e0_.name ASC
Parameters:
[]
0.91 ms
(3.86%)
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:
[]
0.83 ms
(3.53%)
1
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.ordering AS ordering_2 FROM subject_area s0_ ORDER BY s0_.ordering ASC, s0_.name ASC
Parameters:
[]
0.82 ms
(3.51%)
1
SELECT m0_.id AS id_0, m0_.name AS name_1 FROM managerial_experience_position m0_ ORDER BY m0_.name ASC
Parameters:
[]
0.73 ms
(3.13%)
1
SELECT a0_.id AS id_0, a0_.name AS name_1 FROM article_journal a0_ ORDER BY a0_.id ASC
Parameters:
[]
0.73 ms
(3.10%)
1
SELECT m0_.id AS id_0, m0_.name AS name_1 FROM managerial_experience m0_ ORDER BY m0_.name ASC
Parameters:
[]
0.68 ms
(2.88%)
1
SELECT a0_.id AS id_0, a0_.name AS name_1 FROM academic_program_level a0_ ORDER BY a0_.id ASC
Parameters:
[]
0.63 ms
(2.68%)
1
SELECT e0_.id AS id_0, e0_.name AS name_1 FROM executive_education_target e0_ ORDER BY e0_.id ASC
Parameters:
[]
0.54 ms
(2.29%)
1
SELECT p0_.id AS id_0, p0_.name AS name_1 FROM pedagogic_experience p0_ ORDER BY p0_.name ASC
Parameters:
[]
0.49 ms
(2.07%)
1
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.ordering AS ordering_2 FROM employment_type e0_ ORDER BY e0_.ordering ASC, e0_.name ASC
Parameters:
[]

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.