Query Metrics

9 Database Queries
7 Different statements
6.39 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.27 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_current t0
Parameters:
[]
2 1.06 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_current t0 WHERE t0.category = ?
Parameters:
[
  "tracking"
]
3 0.32 ms
SELECT MIN(a0_.id) AS sclr_0 FROM access_url a0_
Parameters:
[]
4 1.20 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_current t0 WHERE t0.category = ?
Parameters:
[
  "tracking"
]
5 0.22 ms
SELECT MIN(a0_.id) AS sclr_0 FROM access_url a0_
Parameters:
[]
6 0.85 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.auth_source AS auth_source_29, t0.status AS status_30, t0.official_code AS official_code_31, t0.picture_uri AS picture_uri_32, t0.creator_id AS creator_id_33, t0.competences AS competences_34, t0.diplomas AS diplomas_35, t0.openarea AS openarea_36, t0.teach AS teach_37, t0.productions AS productions_38, t0.registration_date AS registration_date_39, t0.expiration_date AS expiration_date_40, t0.active AS active_41, t0.openid AS openid_42, t0.theme AS theme_43, t0.hr_dept_id AS hr_dept_id_44, t0.uuid AS uuid_45, t0.created_at AS created_at_46, t0.updated_at AS updated_at_47, t0.resource_node_id AS resource_node_id_48, t49.id AS id_50, t49.user_id AS user_id_51 FROM user t0 LEFT JOIN admin t49 ON t49.user_id = t0.id WHERE t0.status = ? ORDER BY t0.registration_date ASC LIMIT 1
Parameters:
[
  6
]
7 0.59 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:
[
  "23.22.35.162"
  3
]
8 0.50 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:
[]
9 0.39 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.variables AS variables_3, t0.slug AS slug_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM color_theme t0 WHERE t0.active = ? ORDER BY t0.created_at DESC LIMIT 1
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.

Entities Mapping

Class Mapping errors
Chamilo\CoreBundle\Entity\ResourceNode No errors.
Chamilo\CoreBundle\Entity\SettingsCurrent No errors.
Chamilo\CoreBundle\Entity\AbstractResource No errors.
Chamilo\CoreBundle\Entity\AccessUrl No errors.
Chamilo\CoreBundle\Entity\User No errors.
Chamilo\CoreBundle\Entity\TrackELogin No errors.
Chamilo\CoreBundle\Entity\Admin No errors.
Chamilo\CoreBundle\Entity\CourseRelUser No errors.
Chamilo\CoreBundle\Entity\UsergroupRelUser No errors.
Chamilo\CoreBundle\Entity\Group No errors.
Chamilo\CoreBundle\Entity\AccessUrlRelUser No errors.
Chamilo\CoreBundle\Entity\SessionRelCourseRelUser No errors.
Chamilo\CoreBundle\Entity\SessionRelUser No errors.
Chamilo\CoreBundle\Entity\SkillRelUser No errors.
Chamilo\CoreBundle\Entity\SkillRelUserComment No errors.
Chamilo\CoreBundle\Entity\GradebookCategory No errors.
Chamilo\CoreBundle\Entity\GradebookCertificate No errors.
Chamilo\CoreBundle\Entity\GradebookComment No errors.
Chamilo\CoreBundle\Entity\GradebookEvaluation No errors.
Chamilo\CoreBundle\Entity\GradebookLink No errors.
Chamilo\CoreBundle\Entity\GradebookResult No errors.
Chamilo\CoreBundle\Entity\GradebookResultLog No errors.
Chamilo\CoreBundle\Entity\GradebookScoreLog No errors.
Chamilo\CoreBundle\Entity\UserRelUser No errors.
Chamilo\CoreBundle\Entity\GradebookLinkevalLog No errors.
Chamilo\CoreBundle\Entity\SequenceValue No errors.
Chamilo\CoreBundle\Entity\TrackEExerciseConfirmation No errors.
Chamilo\CoreBundle\Entity\TrackEAccessComplete No errors.
Chamilo\CoreBundle\Entity\Templates No errors.
Chamilo\CoreBundle\Entity\TrackEAttempt No errors.
Chamilo\CoreBundle\Entity\TrackECourseAccess No errors.
Chamilo\CoreBundle\Entity\UserCourseCategory No errors.
Chamilo\CoreBundle\Entity\UserRelCourseVote No errors.
Chamilo\CoreBundle\Entity\UserRelTag No errors.
Chamilo\CourseBundle\Entity\CGroupRelUser No errors.
Chamilo\CourseBundle\Entity\CGroupRelTutor No errors.
Chamilo\CoreBundle\Entity\MessageTag No errors.
Chamilo\CoreBundle\Entity\Message No errors.
Chamilo\CoreBundle\Entity\MessageRelUser No errors.
Chamilo\CourseBundle\Entity\CSurveyInvitation No errors.
Chamilo\CoreBundle\Entity\SocialPost No errors.
Chamilo\CoreBundle\Entity\SocialPostFeedback No errors.
Chamilo\CoreBundle\Entity\Language No errors.
Chamilo\CoreBundle\Entity\ColorTheme No errors.