Query Metrics
7
Database Queries
7
Different statements
7.92 ms
Query time
0
Invalid entities
696
Managed entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 2.22 ms |
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:
[] |
2 | 0.45 ms |
SELECT MIN(a0_.id) AS sclr_0 FROM access_url a0_
Parameters:
[] |
3 | 0.59 ms |
SELECT COUNT(*) FROM access_url t0
Parameters:
[] |
4 | 1.19 ms |
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.created_at AS created_at_49, t0.updated_at AS updated_at_50, t0.resource_node_id AS resource_node_id_51, t52.id AS id_53, t52.user_id AS user_id_54 FROM user t0 LEFT JOIN admin t52 ON t52.user_id = t0.id WHERE t0.status = ? ORDER BY t0.created_at ASC LIMIT 1
Parameters:
[
6
]
|
5 | 2.27 ms |
SELECT t0.login_id AS login_id_1, t0.login_date AS login_date_2, t0.user_ip AS user_ip_3, t0.logout_date AS logout_date_4, t0.login_user_id AS login_user_id_5 FROM track_e_login t0 WHERE t0.user_ip = ? AND t0.login_user_id = ? LIMIT 1
Parameters:
[ "45.148.10.235" 2 ] |
6 | 0.63 ms |
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.url_id = ? AND t0.user_id = ?)
Parameters:
[ 1 2 ] |
7 | 0.57 ms |
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 = 1
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 | 691 |
Chamilo\CoreBundle\Entity\AccessUrl | 1 |
Chamilo\CoreBundle\Entity\User | 1 |
Chamilo\CoreBundle\Entity\ResourceNode | 1 |
Chamilo\CoreBundle\Entity\TrackELogin | 1 |
Chamilo\CoreBundle\Entity\UserAuthSource | 1 |