Query Metrics
28
Database Queries
26
Different statements
14.36 ms
Query time
0
Invalid entities
151
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
3.10 ms (21.62%) |
3 |
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, t0.value_template_id AS value_template_id_14 FROM settings t0 WHERE t0.category = ?
Parameters:
[
"profile"
]
|
|
0.75 ms (5.22%) |
1 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.api_token AS api_token_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.website AS website_6, t0.biography AS biography_7, t0.locale AS locale_8, t0.password AS password_9, t0.username_canonical AS username_canonical_10, t0.timezone AS timezone_11, t0.email_canonical AS email_canonical_12, t0.email AS email_13, t0.locked AS locked_14, t0.expired AS expired_15, t0.credentials_expired AS credentials_expired_16, t0.credentials_expire_at AS credentials_expire_at_17, t0.date_of_birth AS date_of_birth_18, t0.expires_at AS expires_at_19, t0.phone AS phone_20, t0.address AS address_21, t0.salt AS salt_22, t0.gender AS gender_23, t0.last_login AS last_login_24, t0.confirmation_token AS confirmation_token_25, t0.password_requested_at AS password_requested_at_26, t0.roles AS roles_27, t0.profile_completed AS profile_completed_28, t0.status AS status_29, t0.official_code AS official_code_30, t0.picture_uri AS picture_uri_31, t0.creator_id AS creator_id_32, t0.competences AS competences_33, t0.diplomas AS diplomas_34, t0.openarea AS openarea_35, t0.teach AS teach_36, t0.productions AS productions_37, t0.expiration_date AS expiration_date_38, t0.active AS active_39, t0.openid AS openid_40, t0.theme AS theme_41, t0.hr_dept_id AS hr_dept_id_42, t0.uuid AS uuid_43, t0.mfa_enabled AS mfa_enabled_44, t0.mfa_service AS mfa_service_45, t0.mfa_secret AS mfa_secret_46, t0.mfa_backup_codes AS mfa_backup_codes_47, t0.mfa_last_used AS mfa_last_used_48, t0.password_updated_at AS password_updated_at_49, t0.created_at AS created_at_50, t0.updated_at AS updated_at_51, t0.resource_node_id AS resource_node_id_52, t53.id AS id_54, t53.user_id AS user_id_55 FROM user t0 LEFT JOIN admin t53 ON t53.user_id = t0.id WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.71 ms (4.98%) |
1 |
"COMMIT"
Parameters:
[] |
|
0.63 ms (4.36%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.level AS level_4, t0.path AS path_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.public AS public_8, t0.uuid AS uuid_9, t0.resource_type_id AS resource_type_id_10, t0.resource_format_id AS resource_format_id_11, t0.creator_id AS creator_id_12, t0.parent_id AS parent_id_13, t14.id AS id_15, t14.title AS title_16, t14.resource_node_id AS resource_node_id_17, t14.shortcut_node_id AS shortcut_node_id_18 FROM resource_node t0 LEFT JOIN c_shortcut t14 ON t14.shortcut_node_id = t0.id WHERE t0.title = ? AND t0.parent_id = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[ "messages-2025-11-04-log.html" 5 ] |
|
0.62 ms (4.30%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.level AS level_4, t0.path AS path_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.public AS public_8, t0.uuid AS uuid_9, t0.resource_type_id AS resource_type_id_10, t0.resource_format_id AS resource_format_id_11, t0.creator_id AS creator_id_12, t0.parent_id AS parent_id_13, t14.id AS id_15, t14.title AS title_16, t14.resource_node_id AS resource_node_id_17, t14.shortcut_node_id AS shortcut_node_id_18 FROM resource_node t0 LEFT JOIN c_shortcut t14 ON t14.shortcut_node_id = t0.id WHERE t0.slug = ? AND t0.parent_id = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[ "messages-2025-11-04-log-html" 5 ] |
|
0.58 ms (4.06%) |
1 |
SELECT t0.course_access_id AS course_access_id_1, t0.c_id AS c_id_2, t0.login_course_date AS login_course_date_3, t0.logout_course_date AS logout_course_date_4, t0.counter AS counter_5, t0.session_id AS session_id_6, t0.user_ip AS user_ip_7, t0.user_id AS user_id_8 FROM track_e_course_access t0 WHERE t0.user_id = ? AND t0.c_id = ? AND t0.session_id = ? LIMIT 1
Parameters:
[ 1 1 0 ] |
|
0.56 ms (3.91%) |
1 |
SELECT r0_.id AS id_0, r0_.title AS title_1, r0_.slug AS slug_2, r0_.level AS level_3, r0_.path AS path_4, r0_.created_at AS created_at_5, r0_.updated_at AS updated_at_6, r0_.public AS public_7, r0_.uuid AS uuid_8, r0_.resource_type_id AS resource_type_id_9, r0_.resource_format_id AS resource_format_id_10, r0_.creator_id AS creator_id_11, r0_.parent_id AS parent_id_12 FROM resource_node r1_, resource_node r0_ INNER JOIN resource_type r2_ ON r0_.resource_type_id = r2_.id INNER JOIN resource_file r3_ ON r0_.id = r3_.resource_node_id WHERE r0_.parent_id = ? AND r2_.title = ? LIMIT 1
Parameters:
[ 1 "illustrations" ] |
|
0.55 ms (3.82%) |
1 |
SELECT t0.iid AS iid_1, t0.c_id AS c_id_2, t0.variable AS variable_3, t0.subkey AS subkey_4, t0.type AS type_5, t0.category AS category_6, t0.value AS value_7, t0.title AS title_8, t0.comment AS comment_9, t0.subkeytext AS subkeytext_10 FROM c_course_setting t0 WHERE t0.c_id = ? AND t0.variable = ? LIMIT 1
Parameters:
[ 1 "show_course_in_user_language" ] |
|
0.54 ms (3.74%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.level AS level_4, t0.path AS path_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.public AS public_8, t0.uuid AS uuid_9, t0.resource_type_id AS resource_type_id_10, t0.resource_format_id AS resource_format_id_11, t0.creator_id AS creator_id_12, t0.parent_id AS parent_id_13, t14.id AS id_15, t14.title AS title_16, t14.resource_node_id AS resource_node_id_17, t14.shortcut_node_id AS shortcut_node_id_18 FROM resource_node t0 LEFT JOIN c_shortcut t14 ON t14.shortcut_node_id = t0.id WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.51 ms (3.52%) |
1 |
SELECT * FROM admin WHERE user_id = 1
Parameters:
[] |
|
0.48 ms (3.32%) |
1 |
SELECT COUNT(*) FROM resource_file t0 WHERE t0.resource_node_id = ?
Parameters:
[
1
]
|
|
0.47 ms (3.30%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.code AS code_3, t0.visual_code AS visual_code_4, t0.directory AS directory_5, t0.course_language AS course_language_6, t0.description AS description_7, t0.introduction AS introduction_8, t0.visibility AS visibility_9, t0.show_score AS show_score_10, t0.tutor_name AS tutor_name_11, t0.department_name AS department_name_12, t0.department_url AS department_url_13, t0.video_url AS video_url_14, t0.sticky AS sticky_15, t0.disk_quota AS disk_quota_16, t0.last_visit AS last_visit_17, t0.last_edit AS last_edit_18, t0.creation_date AS creation_date_19, t0.expiration_date AS expiration_date_20, t0.subscribe AS subscribe_21, t0.unsubscribe AS unsubscribe_22, t0.registration_code AS registration_code_23, t0.legal AS legal_24, t0.activate_legal AS activate_legal_25, t0.add_teachers_to_sessions_courses AS add_teachers_to_sessions_courses_26, t0.course_type_id AS course_type_id_27, t0.duration AS duration_28, t0.popularity AS popularity_29, t0.resource_node_id AS resource_node_id_30, t0.room_id AS room_id_31 FROM course t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.47 ms (3.27%) |
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.is_login_only AS is_login_only_18, t0.resource_node_id AS resource_node_id_19, t0.parent_id AS parent_id_20, t0.tree_root AS tree_root_21 FROM access_url t0 WHERE t0.url = ? LIMIT 1
Parameters:
[
"https://testing25.beeznest.com/"
]
|
|
0.44 ms (3.06%) |
1 |
SELECT c0_.iid AS iid_0, c0_.c_id AS c_id_1, c0_.session_id AS session_id_2, c0_.to_group_id AS to_group_id_3, c0_.user_id AS user_id_4, c0_.last_connection AS last_connection_5 FROM c_chat_connected c0_ WHERE c0_.user_id = ? AND c0_.c_id = ? AND c0_.session_id = 0
Parameters:
[ 1 1 ] |
|
0.43 ms (3.01%) |
1 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.title AS title_3, t0.roles AS roles_4 FROM fos_group t0 INNER JOIN fos_user_user_group ON t0.id = fos_user_user_group.group_id WHERE fos_user_user_group.user_id = ?
Parameters:
[
1
]
|
|
0.41 ms (2.88%) |
1 |
UPDATE c_chat_connected SET last_connection = ? WHERE iid = ?
Parameters:
[ "2025-11-04 21:15:56" 1 ] |
|
0.39 ms (2.69%) |
1 |
SELECT l0_.id AS id_0, l0_.original_name AS original_name_1, l0_.english_name AS english_name_2, l0_.isocode AS isocode_3, l0_.available AS available_4 FROM language l0_ WHERE l0_.available = ? ORDER BY l0_.english_name ASC
Parameters:
[
1
]
|
|
0.37 ms (2.57%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.tool_id AS tool_id_5 FROM resource_type t0 WHERE t0.id = ?
Parameters:
[
29
]
|
|
0.35 ms (2.44%) |
1 |
SELECT c0_.iid AS iid_0, c0_.c_id AS c_id_1, c0_.session_id AS session_id_2, c0_.to_group_id AS to_group_id_3, c0_.user_id AS user_id_4, c0_.last_connection AS last_connection_5 FROM c_chat_connected c0_ WHERE c0_.c_id = ? AND c0_.session_id = 0
Parameters:
[
1
]
|
|
0.35 ms (2.43%) |
1 |
SELECT t0.id AS id_1, t0.authentication AS authentication_2, t0.url_id AS url_id_3, t0.user_id AS user_id_4 FROM user_auth_source t0 WHERE t0.user_id = ?
Parameters:
[
1
]
|
|
0.34 ms (2.40%) |
1 |
SELECT COUNT(c0_.user_id) AS sclr_0 FROM c_chat_connected c0_ WHERE c0_.last_connection > ? AND c0_.c_id = ? AND c0_.session_id = 0
Parameters:
[ "2025-11-04 21:15:51" 1 ] |
|
0.33 ms (2.32%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2 FROM tool t0 WHERE t0.id = ?
Parameters:
[
16
]
|
|
0.31 ms (2.15%) |
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.is_login_only AS is_login_only_18, t0.resource_node_id AS resource_node_id_19, t0.parent_id AS parent_id_20, t0.tree_root AS tree_root_21 FROM access_url t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.27 ms (1.90%) |
1 |
SELECT COUNT(*) FROM access_url t0
Parameters:
[] |
|
0.22 ms (1.53%) |
1 |
SELECT MIN(a0_.id) AS sclr_0 FROM access_url a0_
Parameters:
[] |
|
0.18 ms (1.23%) |
1 |
"START TRANSACTION"
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| Chamilo\CoreBundle\Entity\SettingsCurrent | 126 |
| Chamilo\CoreBundle\Entity\SettingsValueTemplate | 13 |
| Chamilo\CoreBundle\Entity\ResourceNode | 3 |
| Chamilo\CoreBundle\Entity\AccessUrl | 1 |
| Chamilo\CoreBundle\Entity\User | 1 |
| Chamilo\CoreBundle\Entity\Admin | 1 |
| Chamilo\CoreBundle\Entity\UserAuthSource | 1 |
| Chamilo\CoreBundle\Entity\TrackECourseAccess | 1 |
| Chamilo\CoreBundle\Entity\Course | 1 |
| Chamilo\CoreBundle\Entity\ResourceType | 1 |
| Chamilo\CoreBundle\Entity\Tool | 1 |
| Chamilo\CourseBundle\Entity\CChatConnected | 1 |