Query Metrics
11
Database Queries
8
Different statements
21.57 ms
Query time
0
Invalid entities
10
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
9.86 ms (45.72%) |
1 |
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM page p0_ INNER JOIN page_category p1_ ON p0_.category_id = p1_.id LEFT JOIN access_url a2_ ON p0_.access_url_id = a2_.id LEFT JOIN user u3_ ON p0_.creator_id = u3_.id WHERE p0_.id IN (SELECT p4_.id FROM page p4_ INNER JOIN page_category p5_ ON p4_.category_id = p5_.id WHERE p4_.access_url_id = ? AND p4_.enabled = 1 AND p5_.title NOT IN ('block-admin-users', 'block-admin-courses', 'block-admin-sessions', 'block-admin-gradebook', 'block-admin-skills', 'block-admin-privacy', 'block-admin-settings', 'block-admin-platform', 'block-admin-chamilo') AND p5_.title IN (?, ?, ?, ?, ?, ?) AND p5_.title LIKE CONCAT('%', ?, '%') AND p4_.locale = ? AND p4_.enabled = ?)
Parameters:
[ 1 "faq" "demo" "home" "public" "footer_public" "index" "index" "fr_FR" 1 ] |
|
5.40 ms (25.03%) |
2 |
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, l0_.parent_id AS parent_id_5 FROM language l0_ WHERE l0_.isocode = ? LIMIT 1
Parameters:
[
"fr_FR"
]
|
|
1.67 ms (7.76%) |
2 |
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
]
|
|
1.61 ms (7.48%) |
2 |
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://rnap.beeznest.com/"
]
|
|
1.40 ms (6.47%) |
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, t0.value_template_id AS value_template_id_14 FROM settings t0 WHERE t0.category = ? AND t0.access_url = ?
Parameters:
[ "tracking" 1 ] |
|
0.66 ms (3.08%) |
1 |
SELECT COUNT(*) FROM access_url t0
Parameters:
[] |
|
0.50 ms (2.33%) |
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.46 ms (2.14%) |
1 |
SELECT MIN(a0_.id) AS sclr_0 FROM access_url a0_
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 | 7 |
| Chamilo\CoreBundle\Entity\AccessUrl | 1 |
| Chamilo\CoreBundle\Entity\ResourceNode | 1 |
| Chamilo\CoreBundle\Entity\Language | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| Chamilo\CoreBundle\Entity\ResourceNode | No errors. |
| Chamilo\CoreBundle\Entity\AbstractResource | No errors. |
| Chamilo\CoreBundle\Entity\AccessUrl | No errors. |
| Chamilo\CoreBundle\Entity\AccessUrlRelCourse | No errors. |
| Chamilo\CoreBundle\Entity\AccessUrlRelSession | No errors. |
| Chamilo\CoreBundle\Entity\AccessUrlRelUser | No errors. |
| Chamilo\CoreBundle\Entity\SettingsCurrent | No errors. |
| Chamilo\CoreBundle\Entity\SessionCategory | No errors. |
| Chamilo\CoreBundle\Entity\AccessUrlRelCourseCategory | No errors. |
| Chamilo\CoreBundle\Entity\AccessUrlRelColorTheme | No errors. |
| Chamilo\CoreBundle\Entity\AccessUrlRelPlugin | No errors. |
| Chamilo\CoreBundle\Entity\Page | No errors. |
| Chamilo\CoreBundle\Entity\PageCategory | No errors. |
| Chamilo\CoreBundle\Entity\SettingsValueTemplate | No errors. |
| Chamilo\CoreBundle\Entity\User | No errors. |
| Chamilo\CoreBundle\Entity\Language | No errors. |