Query Metrics

6 Database Queries
6 Different statements
5.07 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.54 ms
(30.45%)
1
SELECT t0.id AS id_1, t0.variable AS variable_2, t0.subkey AS subkey_3, t0.type AS type_4, t0.category AS category_5, t0.selected_value AS selected_value_6, t0.title AS title_7, t0.comment AS comment_8, t0.scope AS scope_9, t0.subkeytext AS subkeytext_10, t0.access_url_changeable AS access_url_changeable_11, t0.access_url_locked AS access_url_locked_12, t0.access_url AS access_url_13 FROM settings t0
Parameters:
[]
1.32 ms
(26.05%)
1
SELECT c0_.iid AS iid_0, c0_.title AS title_1, c0_.content AS content_2, c0_.start_date AS start_date_3, c0_.end_date AS end_date_4, c0_.all_day AS all_day_5, c0_.comment AS comment_6, c0_.color AS color_7, c0_.invitation_type AS invitation_type_8, c0_.collective AS collective_9, c0_.subscription_visibility AS subscription_visibility_10, c0_.subscription_item_id AS subscription_item_id_11, c0_.max_attendees AS max_attendees_12, r1_.id AS id_13, r1_.title AS title_14, r1_.slug AS slug_15, r1_.level AS level_16, r1_.path AS path_17, r1_.created_at AS created_at_18, r1_.updated_at AS updated_at_19, r1_.public AS public_20, r1_.uuid AS uuid_21, r2_.id AS id_22, r2_.title AS title_23, r2_.created_at AS created_at_24, r2_.updated_at AS updated_at_25, u3_.id AS id_26, u3_.username AS username_27, u3_.api_token AS api_token_28, u3_.firstname AS firstname_29, u3_.lastname AS lastname_30, u3_.website AS website_31, u3_.biography AS biography_32, u3_.locale AS locale_33, u3_.password AS password_34, u3_.username_canonical AS username_canonical_35, u3_.timezone AS timezone_36, u3_.email_canonical AS email_canonical_37, u3_.email AS email_38, u3_.locked AS locked_39, u3_.expired AS expired_40, u3_.credentials_expired AS credentials_expired_41, u3_.credentials_expire_at AS credentials_expire_at_42, u3_.date_of_birth AS date_of_birth_43, u3_.expires_at AS expires_at_44, u3_.phone AS phone_45, u3_.address AS address_46, u3_.salt AS salt_47, u3_.gender AS gender_48, u3_.last_login AS last_login_49, u3_.confirmation_token AS confirmation_token_50, u3_.password_requested_at AS password_requested_at_51, u3_.roles AS roles_52, u3_.profile_completed AS profile_completed_53, u3_.auth_source AS auth_source_54, u3_.status AS status_55, u3_.official_code AS official_code_56, u3_.picture_uri AS picture_uri_57, u3_.creator_id AS creator_id_58, u3_.competences AS competences_59, u3_.diplomas AS diplomas_60, u3_.openarea AS openarea_61, u3_.teach AS teach_62, u3_.productions AS productions_63, u3_.registration_date AS registration_date_64, u3_.expiration_date AS expiration_date_65, u3_.active AS active_66, u3_.openid AS openid_67, u3_.theme AS theme_68, u3_.hr_dept_id AS hr_dept_id_69, u3_.uuid AS uuid_70, u3_.created_at AS created_at_71, u3_.updated_at AS updated_at_72, r4_.id AS id_73, r4_.title AS title_74, r4_.slug AS slug_75, r4_.level AS level_76, r4_.path AS path_77, r4_.created_at AS created_at_78, r4_.updated_at AS updated_at_79, r4_.public AS public_80, r4_.uuid AS uuid_81, c0_.resource_node_id AS resource_node_id_82, c0_.parent_event_id AS parent_event_id_83, c0_.room_id AS room_id_84, c0_.career_id AS career_id_85, c0_.promotion_id AS promotion_id_86, r1_.resource_type_id AS resource_type_id_87, r1_.resource_format_id AS resource_format_id_88, r1_.creator_id AS creator_id_89, r1_.parent_id AS parent_id_90, r2_.tool_id AS tool_id_91, u3_.resource_node_id AS resource_node_id_92, r4_.resource_type_id AS resource_type_id_93, r4_.resource_format_id AS resource_format_id_94, r4_.creator_id AS creator_id_95, r4_.parent_id AS parent_id_96 FROM c_calendar_event c0_ INNER JOIN resource_node r1_ ON c0_.resource_node_id = r1_.id LEFT JOIN resource_link r5_ ON r1_.id = r5_.resource_node_id AND (r5_.deleted_at IS NULL) INNER JOIN resource_type r2_ ON r1_.resource_type_id = r2_.id LEFT JOIN user u3_ ON r1_.creator_id = u3_.id LEFT JOIN resource_node r4_ ON r1_.parent_id = r4_.id ORDER BY c0_.iid ASC
Parameters:
[]
1.24 ms
(24.53%)
1
SELECT t0.id AS id_1, t0.variable AS variable_2, t0.subkey AS subkey_3, t0.type AS type_4, t0.category AS category_5, t0.selected_value AS selected_value_6, t0.title AS title_7, t0.comment AS comment_8, t0.scope AS scope_9, t0.subkeytext AS subkeytext_10, t0.access_url_changeable AS access_url_changeable_11, t0.access_url_locked AS access_url_locked_12, t0.access_url AS access_url_13 FROM settings t0 WHERE t0.category = ?
Parameters:
[
  "tracking"
]
0.43 ms
(8.45%)
1
SELECT t0.id AS id_1, t0.lft AS lft_2, t0.lvl AS lvl_3, t0.rgt AS rgt_4, t0.url AS url_5, t0.description AS description_6, t0.active AS active_7, t0.created_by AS created_by_8, t0.tms AS tms_9, t0.url_type AS url_type_10, t0.limit_courses AS limit_courses_11, t0.limit_active_courses AS limit_active_courses_12, t0.limit_sessions AS limit_sessions_13, t0.limit_users AS limit_users_14, t0.limit_teachers AS limit_teachers_15, t0.limit_disk_space AS limit_disk_space_16, t0.email AS email_17, t0.resource_node_id AS resource_node_id_18, t0.parent_id AS parent_id_19, t0.tree_root AS tree_root_20 FROM access_url t0 WHERE t0.url = ? LIMIT 1
Parameters:
[
  "https://testing25.beeznest.com/"
]
0.33 ms
(6.55%)
1
SELECT MIN(a0_.id) AS sclr_0 FROM access_url a0_
Parameters:
[]
0.20 ms
(3.97%)
1
SELECT COUNT(*) FROM access_url t0
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.