Query Metrics

30 Database Queries
23 Different statements
29.60 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 2.89 ms
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:
[
  "3"
]
2 1.26 ms
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:
[
  7
]
3 2.84 ms
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"
]
4 1.01 ms
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
]
5 2.56 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, 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
  3
  null
  "en"
]
6 1.05 ms
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:
[]
7 0.76 ms
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:
[]
8 0.87 ms
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:
[]
9 0.42 ms
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
]
10 0.35 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3 FROM position_category t0 WHERE t0.id = ?
Parameters:
[
  5
]
11 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3 FROM position_category t0 WHERE t0.id = ?
Parameters:
[
  2
]
12 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3 FROM position_category t0 WHERE t0.id = ?
Parameters:
[
  4
]
13 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3 FROM position_category t0 WHERE t0.id = ?
Parameters:
[
  3
]
14 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3 FROM position_category t0 WHERE t0.id = ?
Parameters:
[
  999
]
15 0.55 ms
SELECT e0_.id AS id_0, e0_.name AS name_1 FROM english_level e0_ ORDER BY e0_.name ASC
Parameters:
[]
16 0.61 ms
SELECT e0_.id AS id_0, e0_.name AS name_1 FROM education_level e0_ ORDER BY e0_.name ASC
Parameters:
[]
17 0.79 ms
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:
[]
18 1.03 ms
SELECT m0_.id AS id_0, m0_.name AS name_1 FROM managerial_experience m0_ ORDER BY m0_.name ASC
Parameters:
[]
19 0.78 ms
SELECT p0_.id AS id_0, p0_.name AS name_1 FROM pedagogic_experience p0_ ORDER BY p0_.name ASC
Parameters:
[]
20 0.74 ms
SELECT a0_.id AS id_0, a0_.name AS name_1 FROM academic_program_level a0_ ORDER BY a0_.id ASC
Parameters:
[]
21 0.66 ms
SELECT e0_.id AS id_0, e0_.name AS name_1 FROM executive_education_target e0_ ORDER BY e0_.name ASC
Parameters:
[]
22 1.31 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
]
23 0.78 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:
[]
24 0.89 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:
[]
25 1.18 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"
]
26 1.38 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:
[
  "Contact"
  1
]
27 0.90 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
]
28 0.66 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"
]
29 1.09 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
]
30 1.11 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.

Entities Mapping

Class Mapping 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\User\User No errors.
App\Common\Entity\Form\Form No errors.
App\Common\Entity\Education\SubjectArea No errors.
App\Common\Entity\Employment\EmploymentType No errors.
App\Common\Entity\Education\Positions No errors.
App\Common\Entity\Education\PositionCategory No errors.
App\Common\Entity\Education\EnglishLevel No errors.
App\Common\Entity\Education\EducationLevel No errors.
App\Common\Entity\Country\Country 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\Payment\PaymentType No errors.
App\Common\Entity\Payment\PaymentGroup No errors.
App\Common\Entity\Article\ImageCategory No errors.
App\Common\Entity\Announcement\Announcement No errors.
App\Common\Entity\Academy\AcademicProgramDetail No errors.
App\Common\Entity\SiteSetting 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\User\UserGroup No errors.
App\Common\Entity\Language\Language2 No errors.
App\Common\Entity\Education\ManagerialExperienceDetail 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\Country\Nationality No errors.
App\Common\Entity\Payment\Payment No errors.
App\Common\Entity\Form\FormField No errors.
App\Common\Entity\SocialMedia\SocialNetworkFeed No errors.