Query Metrics
25
Database Queries
20
Different statements
29.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
4.16 ms (14.09%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.title_alt AS title_alt_3, t0.status AS status_4, t0.permalink AS permalink_5, t0.lead_content AS lead_content_6, t0.content AS content_7, t0.meta_description AS meta_description_8, t0.link AS link_9, t0.link_text AS link_text_10, t0.sort AS sort_11, t0.target_blank AS target_blank_12, t0.is_system AS is_system_13, t0.system_name AS system_name_14, t0.locale AS locale_15, t0.form_position AS form_position_16, t0.published_at AS published_at_17, t0.updated_at AS updated_at_18, t0.created_at AS created_at_19, t0.category_id AS category_id_20, t0.image_id AS image_id_21, t0.layout_id AS layout_id_22, t0.owner_id AS owner_id_23, t0.updated_by_id AS updated_by_id_24, t0.form_id AS form_id_25 FROM article t0 WHERE t0.id = ?
Parameters:
[
"5"
]
|
|
3.53 ms (11.97%) |
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, i1_.id AS id_19, i1_.image_name AS image_name_20, i1_.original_filename AS original_filename_21, i1_.image_size AS image_size_22, i1_.alt AS alt_23, i1_.sort AS sort_24, a0_.category_id AS category_id_25, a0_.image_id AS image_id_26, a0_.layout_id AS layout_id_27, a0_.owner_id AS owner_id_28, a0_.updated_by_id AS updated_by_id_29, a0_.form_id AS form_id_30, i1_.category_id AS category_id_31 FROM article a0_ INNER JOIN article_category a2_ ON a0_.category_id = a2_.id LEFT JOIN image i1_ ON a0_.image_id = i1_.id WHERE a0_.status = ? AND a0_.id <> ? AND a0_.category_id = ? AND a0_.locale = ? ORDER BY a0_.sort ASC
Parameters:
[ 1 5 3 "en" ] |
|
3.04 ms (10.29%) |
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
]
|
|
2.85 ms (9.64%) |
1 |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.alias AS alias_3, p0_.price AS price_4, p0_.ordering AS ordering_5, p0_.payment_group_id AS payment_group_id_6 FROM payment_type p0_ LEFT JOIN payment_group p1_ ON p0_.payment_group_id = p1_.id WHERE p1_.id = ? AND p0_.alias <> ? ORDER BY p0_.ordering ASC
Parameters:
[ 1 "premiumjob" ] |
|
1.54 ms (5.23%) |
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.39 ms (4.72%) |
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:
[] |
|
1.35 ms (4.56%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.file_name AS file_name_3 FROM article_layout t0 WHERE t0.id = ?
Parameters:
[
3
]
|
|
1.30 ms (4.39%) |
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.27 ms (4.31%) |
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.12 ms (3.79%) |
1 |
SELECT m0_.id AS id_0, m0_.name AS name_1 FROM managerial_experience m0_ ORDER BY m0_.name ASC
Parameters:
[] |
|
1.05 ms (3.55%) |
1 |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.alias AS alias_3, p0_.price AS price_4, p0_.ordering AS ordering_5, p0_.payment_group_id AS payment_group_id_6 FROM payment_type p0_ LEFT JOIN payment_group p1_ ON p0_.payment_group_id = p1_.id WHERE p1_.id = ? ORDER BY p0_.ordering ASC
Parameters:
[
4
]
|
|
0.93 ms (3.14%) |
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:
[] |
|
0.89 ms (3.03%) |
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:
[] |
|
0.87 ms (2.95%) |
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.84 ms (2.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.82 ms (2.78%) |
1 |
SELECT p0_.id AS id_0, p0_.name AS name_1 FROM pedagogic_experience p0_ ORDER BY p0_.name ASC
Parameters:
[] |
|
0.71 ms (2.42%) |
1 |
SELECT e0_.id AS id_0, e0_.name AS name_1 FROM executive_education_target e0_ ORDER BY e0_.name ASC
Parameters:
[] |
|
0.66 ms (2.24%) |
1 |
SELECT a0_.id AS id_0, a0_.name AS name_1 FROM academic_program_level a0_ ORDER BY a0_.id ASC
Parameters:
[] |
|
0.64 ms (2.17%) |
1 |
SELECT e0_.id AS id_0, e0_.name AS name_1 FROM english_level e0_ ORDER BY e0_.name ASC
Parameters:
[] |
|
0.55 ms (1.87%) |
1 |
SELECT e0_.id AS id_0, e0_.name AS name_1 FROM education_level e0_ ORDER BY 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.