Query Metrics
35
Database Queries
20
Different statements
21.11 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.66 ms |
SELECT t0.identifier AS identifier_1, t0.expiry AS expiry_2, t0.user_identifier AS user_identifier_3, t0.scopes AS scopes_4, t0.revoked AS revoked_5, t0.client AS client_6 FROM oauth2_access_token t0 WHERE t0.identifier = ?
Parameters:
[
"bbd7a079767067574fca5fe92ea51b12b20c24a4b567c1e22ac10730f263ce0f9a3e85dc1b96fa03"
]
|
2 | 1.61 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.username AS username_3, t0.password AS password_4, t0.email AS email_5, t0.is_active AS is_active_6, t0.created_at AS created_at_7, t0.last_login AS last_login_8, t9.id AS id_10, t9.created_at AS created_at_11, t9.user_id AS user_id_12, t9.media_id AS media_id_13, t14.id AS id_15, t14.created_at AS created_at_16, t14.changed_at AS changed_at_17, t14.user_id AS user_id_18, t14.selected_user_role_id AS selected_user_role_id_19, t20.id AS id_21, t20.changed_at AS changed_at_22, t20.user_id AS user_id_23, t20.person_id AS person_id_24, t20.address_id AS address_id_25, t20.communication_id AS communication_id_26 FROM user t0 LEFT JOIN user_avatar t9 ON t9.user_id = t0.id LEFT JOIN user_setting t14 ON t14.user_id = t0.id LEFT JOIN user_data t20 ON t20.user_id = t0.id WHERE t0.uuid = ? LIMIT 1
Parameters:
[
"257ff1d7-a670-11ef-aa4e-dd9e82b1ee96"
]
|
3 | 0.55 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.sex AS sex_4, t0.birthday AS birthday_5 FROM person t0 WHERE t0.id IN (?)
Parameters:
[
2
]
|
4 | 0.73 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM user_role t0 INNER JOIN user_role_mapping ON t0.id = user_role_mapping.user_role_id WHERE user_role_mapping.user_id = ?
Parameters:
[
2
]
|
5 | 0.73 ms |
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.is_selected AS is_selected_3, t0.created_at AS created_at_4, t0.company_profile_id AS company_profile_id_5, t0.user_id AS user_id_6 FROM company_profile_mapping t0 WHERE t0.user_id = ?
Parameters:
[
2
]
|
6 | 1.01 ms |
SELECT j0_.id AS id_0, j0_.name AS name_1, j0_.number_of_positions AS number_of_positions_2, j0_.start_date AS start_date_3, j0_.apply_until AS apply_until_4, j0_.description AS description_5, j0_.requirements AS requirements_6, j0_.salary AS salary_7, j0_.details AS details_8, j0_.open_date AS open_date_9, j0_.closed_date AS closed_date_10, j0_.url AS url_11, j0_.additional_info AS additional_info_12, j0_.view_count AS view_count_13, j0_.application_count AS application_count_14, j0_.media_id AS media_id_15, j0_.custom_advertisment_media_id AS custom_advertisment_media_id_16, j0_.contact_id AS contact_id_17, j0_.job_market_position_type_id AS job_market_position_type_id_18, j0_.job_market_apply_type_id AS job_market_apply_type_id_19, j0_.job_market_start_type_id AS job_market_start_type_id_20, j0_.company_profile_id AS company_profile_id_21, j0_.user_id AS user_id_22, j0_.job_market_state_id AS job_market_state_id_23 FROM job_market j0_ LEFT JOIN company_profile c1_ ON j0_.company_profile_id = c1_.id WHERE c1_.id = ? ORDER BY j0_.name ASC
Parameters:
[
1
]
|
7 | 0.46 ms |
SELECT t0.id AS id_1, t0.employee_position AS employee_position_2, t0.created_at AS created_at_3, t0.person_id AS person_id_4, t0.communication_id AS communication_id_5, t0.profile_picture_id AS profile_picture_id_6 FROM contact t0 WHERE t0.id = ?
Parameters:
[
2603
]
|
8 | 0.30 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.sex AS sex_4, t0.birthday AS birthday_5 FROM person t0 WHERE t0.id = ?
Parameters:
[
6258
]
|
9 | 0.53 ms |
SELECT t0.id AS id_1, t0.description AS description_2, t0.short_name AS short_name_3, t0.title_type_id AS title_type_id_4 FROM title t0 INNER JOIN person_title_mapping ON t0.id = person_title_mapping.title_id WHERE person_title_mapping.person_id = ?
Parameters:
[
6258
]
|
10 | 0.26 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2 FROM communication t0 WHERE t0.id = ?
Parameters:
[
3927
]
|
11 | 0.34 ms |
SELECT t0.id AS id_1, t0.entry_value AS entry_value_2, t0.change_date AS change_date_3, t0.created_at AS created_at_4, t0.communication_id AS communication_id_5, t0.communication_type_id AS communication_type_id_6 FROM communication_entry t0 WHERE t0.communication_id = ?
Parameters:
[
3927
]
|
12 | 0.24 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.visible AS visible_4 FROM communication_type t0 WHERE t0.id = ?
Parameters:
[
4
]
|
13 | 0.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.visible AS visible_4 FROM communication_type t0 WHERE t0.id = ?
Parameters:
[
6
]
|
14 | 0.27 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.position AS position_4 FROM job_market_position_type t0 WHERE t0.id = ?
Parameters:
[
2
]
|
15 | 0.54 ms |
SELECT t0.id AS id_1, t0.street AS street_2, t0.number AS number_3, t0.floor AS floor_4, t0.stair AS stair_5, t6.id AS id_7, t6.lat AS lat_8, t6.lon AS lon_9, t6.address_id AS address_id_10, t0.address_type_id AS address_type_id_11, t0.address_city_id AS address_city_id_12 FROM address t0 LEFT JOIN address_lat_lon t6 ON t6.address_id = t0.id INNER JOIN job_market_address_mapping ON t0.id = job_market_address_mapping.address_id WHERE job_market_address_mapping.job_market_id = ?
Parameters:
[
3597
]
|
16 | 2.69 ms |
SELECT t0.id AS id_1, t0.bic_id AS bic_id_2, t0.name AS name_3, t0.description AS description_4, t0.is_scholastic_professsion AS is_scholastic_professsion_5, t0.lbrnr AS lbrnr_6, t0.mlbrnr AS mlbrnr_7, t0.operations_and_tasks AS operations_and_tasks_8, t0.self_employed AS self_employed_9, t0.bic_anforderungen AS bic_anforderungen_10, t0.bic_alternativen AS bic_alternativen_11, t0.bic_lehre_matura AS bic_lehre_matura_12, t0.bic_ausbildung_berufschule AS bic_ausbildung_berufschule_13, t0.bic_moeglichkeiten AS bic_moeglichkeiten_14, t0.update_at AS update_at_15, t0.show_school_subjects AS show_school_subjects_16, t0.job_image_id AS job_image_id_17, t18.id AS id_19, t18.filename AS filename_20, t18.job_id AS job_id_21, t18.file_path_id AS file_path_id_22, t0.job_teaser_image_id AS job_teaser_image_id_23, t0.job_gallery_id AS job_gallery_id_24, t25.id AS id_26, t25.ams_id AS ams_id_27, t25.created_at AS created_at_28, t25.job_id AS job_id_29, t0.job_scholastic_duration_id AS job_scholastic_duration_id_30 FROM job t0 LEFT JOIN job_pdf t18 ON t18.job_id = t0.id LEFT JOIN job_salary t25 ON t25.job_id = t0.id INNER JOIN job_market_job_mapping ON t0.id = job_market_job_mapping.job_id WHERE job_market_job_mapping.job_market_id = ? ORDER BY t0.name ASC
Parameters:
[
3597
]
|
17 | 0.80 ms |
SELECT t0.id AS id_1, t0.interest_name AS interest_name_2, t0.sub_heading AS sub_heading_3 FROM interest_field t0 INNER JOIN job_interest_field_mapping ON t0.id = job_interest_field_mapping.interest_field_id WHERE job_interest_field_mapping.job_id = ?
Parameters:
[
1218
]
|
18 | 1.40 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.wknr AS wknr_4, t0.is_flexi_profile AS is_flexi_profile_5, t0.description AS description_6, t0.training_information AS training_information_7, t0.certificate_information AS certificate_information_8, t0.url AS url_9, t0.founded AS founded_10, t0.no_of_trainees AS no_of_trainees_11, t0.click_count AS click_count_12, t0.is_visible AS is_visible_13, t0.logo_style AS logo_style_14, t0.communication_id AS communication_id_15, t0.gallery_id AS gallery_id_16, t17.id AS id_18, t17.context AS context_19, t17.name AS name_20, t17.default_format AS default_format_21, t17.enabled AS enabled_22, t17.updated_at AS updated_at_23, t17.created_at AS created_at_24, t17.owner_id AS owner_id_25, t17.media_gallery_category_id AS media_gallery_category_id_26, t0.video_gallery_id AS video_gallery_id_27, t28.id AS id_29, t28.context AS context_30, t28.name AS name_31, t28.default_format AS default_format_32, t28.enabled AS enabled_33, t28.updated_at AS updated_at_34, t28.created_at AS created_at_35, t28.owner_id AS owner_id_36, t28.media_gallery_category_id AS media_gallery_category_id_37, t0.document_gallery_id AS document_gallery_id_38, t39.id AS id_40, t39.context AS context_41, t39.name AS name_42, t39.default_format AS default_format_43, t39.enabled AS enabled_44, t39.updated_at AS updated_at_45, t39.created_at AS created_at_46, t39.owner_id AS owner_id_47, t39.media_gallery_category_id AS media_gallery_category_id_48, t0.contact_gallery_id AS contact_gallery_id_49, t50.id AS id_51, t50.is_visible AS is_visible_52, t0.company_size_id AS company_size_id_53, t0.profile_picture_id AS profile_picture_id_54, t55.id AS id_56, t55.name AS name_57, t55.copyright AS copyright_58, t55.provider_name AS provider_name_59, t55.provider_reference AS provider_reference_60, t55.provider_metadata AS provider_metadata_61, t55.content_type AS content_type_62, t55.context AS context_63, t55.updated_at AS updated_at_64, t55.created_at AS created_at_65, t55.owner_id AS owner_id_66, t55.document_type AS document_type_67, t0.header_picture_id AS header_picture_id_68, t69.id AS id_70, t69.name AS name_71, t69.copyright AS copyright_72, t69.provider_name AS provider_name_73, t69.provider_reference AS provider_reference_74, t69.provider_metadata AS provider_metadata_75, t69.content_type AS content_type_76, t69.context AS context_77, t69.updated_at AS updated_at_78, t69.created_at AS created_at_79, t69.owner_id AS owner_id_80, t69.document_type AS document_type_81, t0.profile_link_id AS profile_link_id_82 FROM company_profile t0 LEFT JOIN media__gallery t17 ON t0.gallery_id = t17.id LEFT JOIN media__gallery t28 ON t0.video_gallery_id = t28.id LEFT JOIN media__gallery t39 ON t0.document_gallery_id = t39.id LEFT JOIN contact_gallery t50 ON t0.contact_gallery_id = t50.id LEFT JOIN media__media t55 ON t0.profile_picture_id = t55.id LEFT JOIN media__media t69 ON t0.header_picture_id = t69.id WHERE t0.id = ?
Parameters:
[
1
]
|
19 | 0.63 ms |
SELECT t0.id AS id_1, t0.position AS position_2, t0.enabled AS enabled_3, t0.updated_at AS updated_at_4, t0.created_at AS created_at_5, t0.gallery_id AS gallery_id_6, t0.media_id AS media_id_7 FROM media__gallery_media t0 WHERE t0.gallery_id = ? ORDER BY t0.position ASC
Parameters:
[
6691
]
|
20 | 0.49 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.copyright AS copyright_3, t0.provider_name AS provider_name_4, t0.provider_reference AS provider_reference_5, t0.provider_metadata AS provider_metadata_6, t0.content_type AS content_type_7, t0.context AS context_8, t0.updated_at AS updated_at_9, t0.created_at AS created_at_10, t0.owner_id AS owner_id_11, t0.document_type AS document_type_12 FROM media__media t0 WHERE t0.id = ?
Parameters:
[
21652
]
|
21 | 0.40 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.copyright AS copyright_3, t0.provider_name AS provider_name_4, t0.provider_reference AS provider_reference_5, t0.provider_metadata AS provider_metadata_6, t0.content_type AS content_type_7, t0.context AS context_8, t0.updated_at AS updated_at_9, t0.created_at AS created_at_10, t0.owner_id AS owner_id_11, t0.document_type AS document_type_12 FROM media__media t0 WHERE t0.id = ?
Parameters:
[
21762
]
|
22 | 0.34 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.copyright AS copyright_3, t0.provider_name AS provider_name_4, t0.provider_reference AS provider_reference_5, t0.provider_metadata AS provider_metadata_6, t0.content_type AS content_type_7, t0.context AS context_8, t0.updated_at AS updated_at_9, t0.created_at AS created_at_10, t0.owner_id AS owner_id_11, t0.document_type AS document_type_12 FROM media__media t0 WHERE t0.id = ?
Parameters:
[
21803
]
|
23 | 0.44 ms |
SELECT t0.id AS id_1, t0.position AS position_2, t0.enabled AS enabled_3, t0.updated_at AS updated_at_4, t0.created_at AS created_at_5, t0.gallery_id AS gallery_id_6, t0.media_id AS media_id_7 FROM media__gallery_media t0 WHERE t0.gallery_id = ? ORDER BY t0.position ASC
Parameters:
[
6692
]
|
24 | 0.32 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.copyright AS copyright_3, t0.provider_name AS provider_name_4, t0.provider_reference AS provider_reference_5, t0.provider_metadata AS provider_metadata_6, t0.content_type AS content_type_7, t0.context AS context_8, t0.updated_at AS updated_at_9, t0.created_at AS created_at_10, t0.owner_id AS owner_id_11, t0.document_type AS document_type_12 FROM media__media t0 WHERE t0.id = ?
Parameters:
[
21782
]
|
25 | 0.34 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.copyright AS copyright_3, t0.provider_name AS provider_name_4, t0.provider_reference AS provider_reference_5, t0.provider_metadata AS provider_metadata_6, t0.content_type AS content_type_7, t0.context AS context_8, t0.updated_at AS updated_at_9, t0.created_at AS created_at_10, t0.owner_id AS owner_id_11, t0.document_type AS document_type_12 FROM media__media t0 WHERE t0.id = ?
Parameters:
[
21780
]
|
26 | 0.40 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.copyright AS copyright_3, t0.provider_name AS provider_name_4, t0.provider_reference AS provider_reference_5, t0.provider_metadata AS provider_metadata_6, t0.content_type AS content_type_7, t0.context AS context_8, t0.updated_at AS updated_at_9, t0.created_at AS created_at_10, t0.owner_id AS owner_id_11, t0.document_type AS document_type_12 FROM media__media t0 WHERE t0.id = ?
Parameters:
[
21774
]
|
27 | 0.35 ms |
SELECT t0.id AS id_1, t0.employee_position AS employee_position_2, t0.created_at AS created_at_3, t0.person_id AS person_id_4, t0.communication_id AS communication_id_5, t0.profile_picture_id AS profile_picture_id_6 FROM contact t0 WHERE t0.id = ?
Parameters:
[
2659
]
|
28 | 0.33 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.sex AS sex_4, t0.birthday AS birthday_5 FROM person t0 WHERE t0.id = ?
Parameters:
[
6332
]
|
29 | 0.38 ms |
SELECT t0.id AS id_1, t0.description AS description_2, t0.short_name AS short_name_3, t0.title_type_id AS title_type_id_4 FROM title t0 INNER JOIN person_title_mapping ON t0.id = person_title_mapping.title_id WHERE person_title_mapping.person_id = ?
Parameters:
[
6332
]
|
30 | 0.31 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.copyright AS copyright_3, t0.provider_name AS provider_name_4, t0.provider_reference AS provider_reference_5, t0.provider_metadata AS provider_metadata_6, t0.content_type AS content_type_7, t0.context AS context_8, t0.updated_at AS updated_at_9, t0.created_at AS created_at_10, t0.owner_id AS owner_id_11, t0.document_type AS document_type_12 FROM media__media t0 WHERE t0.id = ?
Parameters:
[
21804
]
|
31 | 0.30 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2 FROM communication t0 WHERE t0.id = ?
Parameters:
[
3983
]
|
32 | 0.36 ms |
SELECT t0.id AS id_1, t0.entry_value AS entry_value_2, t0.change_date AS change_date_3, t0.created_at AS created_at_4, t0.communication_id AS communication_id_5, t0.communication_type_id AS communication_type_id_6 FROM communication_entry t0 WHERE t0.communication_id = ?
Parameters:
[
3983
]
|
33 | 0.44 ms |
SELECT t0.id AS id_1, t0.street AS street_2, t0.number AS number_3, t0.floor AS floor_4, t0.stair AS stair_5, t6.id AS id_7, t6.lat AS lat_8, t6.lon AS lon_9, t6.address_id AS address_id_10, t0.address_type_id AS address_type_id_11, t0.address_city_id AS address_city_id_12 FROM address t0 LEFT JOIN address_lat_lon t6 ON t6.address_id = t0.id INNER JOIN job_market_address_mapping ON t0.id = job_market_address_mapping.address_id WHERE job_market_address_mapping.job_market_id = ?
Parameters:
[
3603
]
|
34 | 0.50 ms |
SELECT t0.id AS id_1, t0.bic_id AS bic_id_2, t0.name AS name_3, t0.description AS description_4, t0.is_scholastic_professsion AS is_scholastic_professsion_5, t0.lbrnr AS lbrnr_6, t0.mlbrnr AS mlbrnr_7, t0.operations_and_tasks AS operations_and_tasks_8, t0.self_employed AS self_employed_9, t0.bic_anforderungen AS bic_anforderungen_10, t0.bic_alternativen AS bic_alternativen_11, t0.bic_lehre_matura AS bic_lehre_matura_12, t0.bic_ausbildung_berufschule AS bic_ausbildung_berufschule_13, t0.bic_moeglichkeiten AS bic_moeglichkeiten_14, t0.update_at AS update_at_15, t0.show_school_subjects AS show_school_subjects_16, t0.job_image_id AS job_image_id_17, t18.id AS id_19, t18.filename AS filename_20, t18.job_id AS job_id_21, t18.file_path_id AS file_path_id_22, t0.job_teaser_image_id AS job_teaser_image_id_23, t0.job_gallery_id AS job_gallery_id_24, t25.id AS id_26, t25.ams_id AS ams_id_27, t25.created_at AS created_at_28, t25.job_id AS job_id_29, t0.job_scholastic_duration_id AS job_scholastic_duration_id_30 FROM job t0 LEFT JOIN job_pdf t18 ON t18.job_id = t0.id LEFT JOIN job_salary t25 ON t25.job_id = t0.id INNER JOIN job_market_job_mapping ON t0.id = job_market_job_mapping.job_id WHERE job_market_job_mapping.job_market_id = ? ORDER BY t0.name ASC
Parameters:
[
3603
]
|
35 | 0.46 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM company_benefit t0 INNER JOIN company_profile_benefit_mapping ON t0.id = company_profile_benefit_mapping.company_benefit_id WHERE company_profile_benefit_mapping.company_profile_id = ?
Parameters:
[
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.