15
-2
-
Chuyên mục: Cây dược liệu
-
| Lượt xem: 8431
Thân cây bụi, cao 1,5-3m. Vỏ thân lúc non nhẵn, sau dày lên, có lớp bần màu xám trắng. Đường kính thân 2-4 cm. Gỗ thân và rễ có màu vàng. Lá kép lông chim
Đọc thêm
15
-2
-
Chuyên mục: Cây dược liệu
-
| Lượt xem: 9531
Là cây leo bằng thân cuốn. Cành non có lông mịn, thân già xoắn. Lá nguyên, mọc đối. Phiến lá hình trứng dài 4-7cm, rộng 2-4cm, cả hai mặt lá đều có lông mịn. Hoa mọc từng đôi một ở các nách lá
Đọc thêm
15
-2
-
Chuyên mục: Cây dược liệu
-
| Lượt xem: 8220
Là dây leo bằng thân quấn, dài 8-10m. Thân màu xám, lúc đầu có lông, sau nhẵn, có lỗ bì sần sùi. Lá mọc so le, hình tim, mặt trên nhẵn, mặt dưới có lông tơ, gân lá hình
Đọc thêm
15
-2
-
Chuyên mục: Cây dược liệu
-
| Lượt xem: 9273
Camellia
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | cdl_session | const | PRIMARY | PRIMARY | 602 | const | 1 |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/session/storage/database.php:46
JROOT/libraries/joomla/session/session.php:658
JROOT/libraries/joomla/session/session.php:596
JROOT/libraries/cms/application/cms.php:672
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:332
JROOT/libraries/joomla/factory.php:124
JROOT/index.php:48
Query Time: 0.16 ms After last query: 2.21 ms Query memory: 0.008 MB Memory before query: 2.442 MB
DELETE
FROM `cdl_session`
WHERE `time` < '1679334219'
EXPLAIN not possible on query: DELETE
FROM `cdl_session`
WHERE `time` < '1679334219'
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/cms/application/cms.php:689
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:332
JROOT/libraries/joomla/factory.php:124
JROOT/index.php:48
Query Time: 0.15 ms After last query: 0.14 ms Query memory: 0.012 MB Memory before query: 2.454 MB Rows returned: 0
SELECT `session_id`
FROM `cdl_session`
WHERE `session_id` = 'et0i6546sidg166r0b0mpj21c5'
LIMIT 0, 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | cdl_session | const | PRIMARY | PRIMARY | 602 | const | 1 | Using index |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/cms/application/cms.php:175
JROOT/libraries/cms/application/cms.php:698
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:332
JROOT/libraries/joomla/factory.php:124
JROOT/index.php:48
Query Time: 11.78 ms After last query: 0.15 ms Query memory: 0.009 MB Memory before query: 2.467 MB
INSERT INTO `cdl_session` (`session_id`, `client_id`, `time`)
VALUES ('et0i6546sidg166r0b0mpj21c5', 0, '1679336019')
EXPLAIN not possible on query: INSERT INTO `cdl_session`
(`session_id`, `client_id`, `time`) VALUES
('et0i6546sidg166r0b0mpj21c5', 0, '1679336019')
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/cms/application/cms.php:207
JROOT/libraries/cms/application/cms.php:698
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:332
JROOT/libraries/joomla/factory.php:124
JROOT/index.php:48
Query Time: 0.27 ms After last query: 4.11 ms Query memory: 0.015 MB Memory before query: 2.824 MB Rows returned: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM cdl_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | cdl_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:395
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/libraries/cms/application/site.php:539
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:53
Query Time: 0.21 ms After last query: 1.37 ms Query memory: 0.014 MB Memory before query: 2.929 MB Rows returned: 2
SELECT b.id
FROM cdl_usergroups AS a
LEFT JOIN cdl_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | b | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 3 | Using where; Using index |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
System lock | 0.0 ms |
init | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
logging slow query | 0.0 ms |
cleaning up | 0.0 ms |
JROOT/libraries/joomla/access/access.php:336
JROOT/libraries/joomla/access/access.php:405
JROOT/libraries/joomla/user/user.php:420
JROOT/libraries/cms/plugin/helper.php:298
JROOT/libraries/cms/plugin/helper.php:165
JROOT/libraries/cms/application/site.php:544
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:53
Query Time: 0.15 ms After last query: 0.60 ms Query memory: 0.013 MB Memory before query: 2.992 MB Rows returned: 4
SELECT id, rules
FROM `cdl_viewlevels`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | cdl_viewlevels | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 4 |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
System lock | 0.0 ms |
init | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
logging slow query | 0.0 ms |
cleaning up | 0.0 ms |
JROOT/libraries/joomla/access/access.php:422
JROOT/libraries/joomla/user/user.php:420
JROOT/libraries/cms/plugin/helper.php:298
JROOT/libraries/cms/plugin/helper.php:165
JROOT/libraries/cms/application/site.php:544
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:53
Query Time: 0.42 ms After last query: 0.19 ms Query memory: 0.013 MB Memory before query: 3.011 MB Rows returned: 43
SELECT folder AS type, element AS name, params
FROM cdl_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1,5)
ORDER BY ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | cdl_extensions | ref | extension | extension | 62 | const | 55 | Using where; Using filesort |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
System lock | 0.0 ms |
init | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Sorting result | 0.1 ms |
Sending data | 0.1 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
logging slow query | 0.0 ms |
cleaning up | 0.0 ms |
JROOT/libraries/cms/plugin/helper.php:312
JROOT/libraries/cms/plugin/helper.php:165
JROOT/libraries/cms/application/site.php:544
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:53
Query Time: 0.23 ms After last query: 0.29 ms Query memory: 0.014 MB Memory before query: 3.078 MB Rows returned: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM cdl_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | cdl_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
System lock | 0.0 ms |
init | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.1 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
logging slow query | 0.0 ms |
cleaning up | 0.0 ms |
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:395
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/libraries/cms/application/site.php:597
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:53
Query Time: 1.07 ms After last query: 22.03 ms Query memory: 0.039 MB Memory before query: 4.673 MB Rows returned: 103
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM cdl_menu AS m
LEFT JOIN cdl_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | ALL | idx_client_id_parent_id_alias_language | NO INDEX KEY COULD BE USED | NULL | NULL | 147 | Using where; Using filesort |
1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | cdl_db.m.component_id | 1 |
Status | Duration |
---|---|
starting | 0.1 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
System lock | 0.0 ms |
init | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Sorting result | 0.1 ms |
Sending data | 0.6 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
logging slow query | 0.0 ms |
cleaning up | 0.0 ms |
JROOT/libraries/cms/menu/site.php:47
JROOT/libraries/cms/menu/menu.php:64
JROOT/libraries/cms/menu/menu.php:118
JROOT/libraries/cms/application/cms.php:357
JROOT/libraries/cms/application/site.php:250
JROOT/libraries/cms/router/site.php:210
JROOT/libraries/cms/router/router.php:391
JROOT/libraries/cms/router/router.php:184
JROOT/libraries/cms/router/site.php:82
JROOT/libraries/cms/application/cms.php:1029
JROOT/libraries/cms/application/site.php:718
JROOT/libraries/cms/application/site.php:202
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:53
Query Time: 0.24 ms After last query: 5.89 ms Query memory: 0.021 MB Memory before query: 5.990 MB Rows returned: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM cdl_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | cdl_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
System lock | 0.0 ms |
init | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
logging slow query | 0.0 ms |
cleaning up | 0.0 ms |
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:395
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/components/com_content/router.php:259
JROOT/libraries/cms/router/site.php:384
JROOT/libraries/cms/router/router.php:391
JROOT/libraries/cms/router/router.php:184
JROOT/libraries/cms/router/site.php:82
JROOT/libraries/cms/application/cms.php:1029
JROOT/libraries/cms/application/site.php:718
JROOT/libraries/cms/application/site.php:202
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:53
Query Time: 1.30 ms After last query: 1.45 ms Query memory: 0.024 MB Memory before query: 6.113 MB Rows returned: 5
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM cdl_categories as c
LEFT JOIN cdl_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM cdl_categories AS cat JOIN cdl_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id=8
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
ORDER BY c.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | PRIMARY | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | Using temporary; Using filesort |
1 | PRIMARY | c | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 29 | Using where |
1 | PRIMARY | <derived2> | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where; Not exists |
2 | DERIVED | parent | range | cat_idx,idx_left_right | cat_idx | 153 | NULL | 2 | Using where; Using temporary; Using filesort |
2 | DERIVED | cat | index | idx_left_right | idx_left_right | 8 | NULL | 29 | Using where; Using index; Using join buffer |
Status | Duration |
---|---|
starting | 0.1 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
Creating tmp table | 0.0 ms |
executing | 0.0 ms |
Copying to tmp table | 0.1 ms |
Sorting result | 0.0 ms |
Sending data | 0.0 ms |
removing tmp table | 0.0 ms |
Sending data | 0.0 ms |
init | 0.1 ms |
optimizing | 0.0 ms |
statistics | 0.1 ms |
preparing | 0.0 ms |
Creating tmp table | 0.4 ms |
executing | 0.0 ms |
Copying to tmp table | 0.1 ms |
Sorting result | 0.0 ms |
Sending data | 0.0 ms |
end | 0.0 ms |
removing tmp table | 0.1 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
removing tmp table | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
logging slow query | 0.0 ms |
cleaning up | 0.0 ms |
JROOT/libraries/legacy/categories/categories.php:288
JROOT/libraries/legacy/categories/categories.php:181
JROOT/components/com_content/router.php:292
JROOT/libraries/cms/router/site.php:384
JROOT/libraries/cms/router/router.php:391
JROOT/libraries/cms/router/router.php:184
JROOT/libraries/cms/router/site.php:82
JROOT/libraries/cms/application/cms.php:1029
JROOT/libraries/cms/application/site.php:718
JROOT/libraries/cms/application/site.php:202
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:53
Query Time: 0.20 ms After last query: 0.75 ms Query memory: 0.024 MB Memory before query: 6.196 MB Rows returned: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM cdl_extensions
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | cdl_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 364 | const,const | 1 | Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
System lock | 0.0 ms |
init | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
logging slow query | 0.0 ms |
cleaning up | 0.0 ms |
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/library/helper.php:156
JROOT/libraries/cms/library/helper.php:47
JROOT/libraries/cms/library/helper.php:90
JROOT/libraries/cms/version/version.php:179
JROOT/libraries/joomla/factory.php:734
JROOT/libraries/joomla/factory.php:215
JROOT/plugins/system/sef/sef.php:30
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1038
JROOT/libraries/cms/application/site.php:718
JROOT/libraries/cms/application/site.php:202
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:53
Query Time: 19.94 ms After last query: 0.23 ms Query memory: 0.018 MB Memory before query: 6.204 MB
UPDATE `cdl_extensions`
SET `params` = '{\"mediaversion\":\"795bc52e7b53d290ce37e8abf3649312\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
EXPLAIN not possible on query: UPDATE `cdl_extensions`
SET `params` = '{\"mediaversion\":\"795bc52e7b53d290ce37e8abf3649312\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
System lock | 0.0 ms |
init | 0.0 ms |
Updating | 0.0 ms |
end | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
end | 0.0 ms |
query end | 19.7 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
logging slow query | 0.0 ms |
cleaning up | 0.0 ms |
JROOT/libraries/cms/library/helper.php:119
JROOT/libraries/cms/version/version.php:230
JROOT/libraries/cms/version/version.php:189
JROOT/libraries/joomla/factory.php:734
JROOT/libraries/joomla/factory.php:215
JROOT/plugins/system/sef/sef.php:30
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1038
JROOT/libraries/cms/application/site.php:718
JROOT/libraries/cms/application/site.php:202
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:53
Query Time: 0.38 ms After last query: 4.64 ms Query memory: 0.013 MB Memory before query: 6.474 MB Rows returned: 1
SELECT *
FROM cdl_languages
WHERE published=1
ORDER BY ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | cdl_languages | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where; Using filesort |
Status | Duration |
---|---|
starting | 0.1 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
System lock | 0.0 ms |
init | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Sorting result | 0.0 ms |
Sending data | 0.0 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
logging slow query | 0.0 ms |
cleaning up | 0.0 ms |
JROOT/libraries/joomla/language/helper.php:166
JROOT/libraries/cms/application/site.php:306
JROOT/libraries/cms/application/site.php:122
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:53
Query Time: 0.30 ms After last query: 0.46 ms Query memory: 0.010 MB Memory before query: 6.495 MB Rows returned: 2
SELECT id, home, template, s.params
FROM cdl_template_styles as s
LEFT JOIN cdl_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | s | ALL | idx_template | NO INDEX KEY COULD BE USED | NULL | NULL | 6 | Using where |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 303 | cdl_db.s.template,const | 1 | Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
System lock | 0.0 ms |
init | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.1 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
logging slow query | 0.0 ms |
cleaning up | 0.0 ms |
JROOT/libraries/cms/application/site.php:455
JROOT/libraries/cms/application/site.php:152
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:53
Query Time: 0.31 ms After last query: 57.75 ms Query memory: 0.024 MB Memory before query: 7.874 MB Rows returned: 1
SELECT a.rules
FROM cdl_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
starting | 0.1 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
System lock | 0.0 ms |
init | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
logging slow query | 0.0 ms |
cleaning up | 0.0 ms |
JROOT/libraries/joomla/access/access.php:250
JROOT/libraries/joomla/user/user.php:356
JROOT/components/com_content/models/category.php:129
JROOT/libraries/legacy/model/legacy.php:415
JROOT/libraries/legacy/view/legacy.php:398
JROOT/libraries/legacy/view/category.php:107
JROOT/components/com_content/views/category/view.html.php:72
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_content/controller.php:79
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_content/content.php:17
JROOT/libraries/cms/component/helper.php:351
JROOT/libraries/cms/component/helper.php:331
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:53
Query Time: 0.66 ms After last query: 0.85 ms Query memory: 0.025 MB Memory before query: 7.930 MB Rows returned: 2
SELECT b.rules
FROM cdl_assets AS a
LEFT JOIN cdl_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | const | idx_asset_name | idx_asset_name | 152 | const | 1 | Using temporary; Using filesort |
1 | SIMPLE | b | range | idx_lft_rgt | idx_lft_rgt | 4 | NULL | 15 | Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
System lock | 0.0 ms |
init | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.1 ms |
preparing | 0.0 ms |
Creating tmp table | 0.2 ms |
executing | 0.0 ms |
Copying to tmp table | 0.1 ms |
Sorting result | 0.0 ms |
Sending data | 0.0 ms |
end | 0.0 ms |
removing tmp table | 0.1 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
logging slow query | 0.0 ms |
cleaning up | 0.0 ms |
JROOT/libraries/joomla/access/access.php:250
JROOT/libraries/joomla/access/access.php:110
JROOT/libraries/joomla/user/user.php:365
JROOT/components/com_content/models/category.php:129
JROOT/libraries/legacy/model/legacy.php:415
JROOT/libraries/legacy/view/legacy.php:398
JROOT/libraries/legacy/view/category.php:107
JROOT/components/com_content/views/category/view.html.php:72
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_content/controller.php:79
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_content/content.php:17
JROOT/libraries/cms/component/helper.php:351
JROOT/libraries/cms/component/helper.php:331
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:53
Query Time: 1.79 ms After last query: 0.71 ms Query memory: 0.031 MB Memory before query: 7.970 MB Rows returned: 5
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems
FROM cdl_categories as c
LEFT JOIN cdl_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM cdl_categories AS cat JOIN cdl_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
LEFT JOIN `cdl_content` AS i
ON i.`catid` = c.id
AND i.state = 1
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id=8
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
ORDER BY c.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | PRIMARY | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | Using temporary; Using filesort |
1 | PRIMARY | c | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 29 | Using where |
1 | PRIMARY | <derived2> | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where; Not exists |
1 | PRIMARY | i | ref | idx_state,idx_catid | idx_catid | 4 | cdl_db.c.id | 4 | |
2 | DERIVED | parent | range | cat_idx,idx_left_right | cat_idx | 153 | NULL | 2 | Using where; Using temporary; Using filesort |
2 | DERIVED | cat | index | idx_left_right | idx_left_right | 8 | NULL | 29 | Using where; Using index; Using join buffer |
Status | Duration |
---|---|
starting | 0.1 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
Creating tmp table | 0.0 ms |
executing | 0.0 ms |
Copying to tmp table | 0.1 ms |
Sorting result | 0.0 ms |
Sending data | 0.0 ms |
removing tmp table | 0.0 ms |
Sending data | 0.0 ms |
init | 0.1 ms |
optimizing | 0.0 ms |
statistics | 0.1 ms |
preparing | 0.0 ms |
Creating tmp table | 0.3 ms |
executing | 0.0 ms |
Copying to tmp table | 0.7 ms |
Sorting result | 0.0 ms |
Sending data | 0.1 ms |
end | 0.0 ms |
removing tmp table | 0.1 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
removing tmp table | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
logging slow query | 0.0 ms |
cleaning up | 0.0 ms |
JROOT/libraries/legacy/categories/categories.php:288
JROOT/libraries/legacy/categories/categories.php:181
JROOT/components/com_content/models/category.php:326
JROOT/components/com_content/models/category.php:214
JROOT/libraries/legacy/view/legacy.php:398
JROOT/libraries/legacy/view/category.php:108
JROOT/components/com_content/views/category/view.html.php:72
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_content/controller.php:79
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_content/content.php:17
JROOT/libraries/cms/component/helper.php:351
JROOT/libraries/cms/component/helper.php:331
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:53
Query Time: 0.52 ms After last query: 0.41 ms Query memory: 0.025 MB Memory before query: 8.027 MB Rows returned: 3
SELECT b.rules
FROM cdl_assets AS a
LEFT JOIN cdl_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.category.8')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | const | idx_asset_name | idx_asset_name | 152 | const | 1 | Using temporary; Using filesort |
1 | SIMPLE | b | range | idx_lft_rgt | idx_lft_rgt | 4 | NULL | 17 | Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
System lock | 0.0 ms |
init | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
Creating tmp table | 0.1 ms |
executing | 0.0 ms |
Copying to tmp table | 0.1 ms |
Sorting result | 0.0 ms |
Sending data | 0.0 ms |
end | 0.0 ms |
removing tmp table | 0.1 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
logging slow query | 0.0 ms |
cleaning up | 0.0 ms |
JROOT/libraries/joomla/access/access.php:250
JROOT/libraries/joomla/access/access.php:110
JROOT/libraries/joomla/user/user.php:365
JROOT/components/com_content/models/category.php:335
JROOT/components/com_content/models/category.php:214
JROOT/libraries/legacy/view/legacy.php:398
JROOT/libraries/legacy/view/category.php:108
JROOT/components/com_content/views/category/view.html.php:72
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_content/controller.php:79
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_content/content.php:17
JROOT/libraries/cms/component/helper.php:351
JROOT/libraries/cms/component/helper.php:331
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:53
Query Time: 1.70 ms After last query: 1.78 ms Query memory: 0.051 MB Memory before query: 8.205 MB Rows returned: 8
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id
FROM cdl_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM cdl_content AS a
LEFT JOIN cdl_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN cdl_categories AS c
ON c.id = a.catid
LEFT JOIN cdl_users AS ua
ON ua.id = a.created_by
LEFT JOIN cdl_users AS uam
ON uam.id = a.modified_by
LEFT JOIN cdl_categories as parent
ON parent.id = c.parent_id
LEFT JOIN cdl_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM cdl_categories AS cat JOIN cdl_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid = 8
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-03-20 18:13:40')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-20 18:13:40')
ORDER BY c.lft,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | PRIMARY | a | ref | idx_catid | idx_catid | 4 | const | 9 | Using where; Using temporary; Using filesort |
1 | PRIMARY | fp | eq_ref | PRIMARY | PRIMARY | 4 | cdl_db.a.id | 1 | Using index |
1 | PRIMARY | c | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | PRIMARY | ua | eq_ref | PRIMARY | PRIMARY | 4 | cdl_db.a.created_by | 1 | |
1 | PRIMARY | uam | eq_ref | PRIMARY | PRIMARY | 4 | cdl_db.a.modified_by | 1 | |
1 | PRIMARY | parent | eq_ref | PRIMARY | PRIMARY | 4 | cdl_db.c.parent_id | 1 | |
1 | PRIMARY | v | eq_ref | PRIMARY | PRIMARY | 4 | cdl_db.a.id | 1 | |
1 | PRIMARY | <derived3> | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where |
3 | DERIVED | parent | range | cat_idx,idx_left_right | cat_idx | 153 | NULL | 2 | Using where; Using temporary; Using filesort |
3 | DERIVED | cat | index | idx_left_right | idx_left_right | 8 | NULL | 29 | Using where; Using index; Using join buffer |
2 | DEPENDENT SUBQUERY | contact | ref | idx_state | idx_state | 1 | const | 1 | Using where |
Status | Duration |
---|---|
starting | 0.1 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
Creating tmp table | 0.0 ms |
executing | 0.0 ms |
Copying to tmp table | 0.0 ms |
Sorting result | 0.0 ms |
Sending data | 0.0 ms |
removing tmp table | 0.0 ms |
Sending data | 0.0 ms |
init | 0.1 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
Creating tmp table | 0.3 ms |
executing | 0.0 ms |
Copying to tmp table | 0.1 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.1 ms |
Sorting result | 0.1 ms |
Sending data | 0.1 ms |
end | 0.0 ms |
removing tmp table | 0.1 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
removing tmp table | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
logging slow query | 0.0 ms |
cleaning up | 0.0 ms |
JROOT/libraries/legacy/model/legacy.php:301
JROOT/libraries/legacy/model/list.php:171
JROOT/components/com_content/models/articles.php:546
JROOT/components/com_content/models/category.php:234
JROOT/libraries/legacy/view/legacy.php:398
JROOT/libraries/legacy/view/category.php:108
JROOT/components/com_content/views/category/view.html.php:72
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_content/controller.php:79
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_content/content.php:17
JROOT/libraries/cms/component/helper.php:351
JROOT/libraries/cms/component/helper.php:331
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:53
Query Time: 0.23 ms After last query: 2.34 ms Query memory: 0.029 MB Memory before query: 8.582 MB Rows returned: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM cdl_extensions
WHERE `type` = 'component'
AND `element` = 'com_tags'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | cdl_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
System lock | 0.0 ms |
init | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
logging slow query | 0.0 ms |
cleaning up | 0.0 ms |
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:395
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/libraries/cms/helper/tags.php:396
JROOT/components/com_content/models/articles.php:672
JROOT/components/com_content/models/category.php:234
JROOT/libraries/legacy/view/legacy.php:398
JROOT/libraries/legacy/view/category.php:108
JROOT/components/com_content/views/category/view.html.php:72
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_content/controller.php:79
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_content/content.php:17
JROOT/libraries/cms/component/helper.php:351
JROOT/libraries/cms/component/helper.php:331
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:53
Query Time: 0.24 ms After last query: 0.19 ms Query memory: 0.029 MB Memory before query: 8.592 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `cdl_contentitem_tag_map` AS m
INNER JOIN `cdl_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 123
AND `t`.`published` = 1
AND t.access IN (1,1,5)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | ALL | idx_tag_type,idx_tag | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where |
1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | cdl_db.m.tag_id | 1 | Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
System lock | 0.0 ms |
init | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
logging slow query | 0.0 ms |
cleaning up | 0.0 ms |
JROOT/libraries/cms/helper/tags.php:416
JROOT/components/com_content/models/articles.php:672
JROOT/components/com_content/models/category.php:234
JROOT/libraries/legacy/view/legacy.php:398
JROOT/libraries/legacy/view/category.php:108
JROOT/components/com_content/views/category/view.html.php:72
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_content/controller.php:79
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_content/content.php:17
JROOT/libraries/cms/component/helper.php:351
JROOT/libraries/cms/component/helper.php:331
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:53
Query Time: 0.23 ms After last query: 0.43 ms Query memory: 0.029 MB Memory before query: 8.631 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `cdl_contentitem_tag_map` AS m
INNER JOIN `cdl_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 118
AND `t`.`published` = 1
AND t.access IN (1,1,5)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | ALL | idx_tag_type,idx_tag | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where |
1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | cdl_db.m.tag_id | 1 | Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
System lock | 0.0 ms |
init | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
logging slow query | 0.0 ms |
cleaning up | 0.0 ms |
JROOT/libraries/cms/helper/tags.php:416
JROOT/components/com_content/models/articles.php:672
JROOT/components/com_content/models/category.php:234
JROOT/libraries/legacy/view/legacy.php:398
JROOT/libraries/legacy/view/category.php:108
JROOT/components/com_content/views/category/view.html.php:72
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_content/controller.php:79
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_content/content.php:17
JROOT/libraries/cms/component/helper.php:351
JROOT/libraries/cms/component/helper.php:331
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:53
Query Time: 0.22 ms After last query: 0.37 ms Query memory: 0.029 MB Memory before query: 8.670 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `cdl_contentitem_tag_map` AS m
INNER JOIN `cdl_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 117
AND `t`.`published` = 1
AND t.access IN (1,1,5)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | ALL | idx_tag_type,idx_tag | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where |
1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | cdl_db.m.tag_id | 1 | Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
System lock | 0.0 ms |
init | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
logging slow query | 0.0 ms |
cleaning up | 0.0 ms |
JROOT/libraries/cms/helper/tags.php:416
JROOT/components/com_content/models/articles.php:672
JROOT/components/com_content/models/category.php:234
JROOT/libraries/legacy/view/legacy.php:398
JROOT/libraries/legacy/view/category.php:108
JROOT/components/com_content/views/category/view.html.php:72
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_content/controller.php:79
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_content/content.php:17
JROOT/libraries/cms/component/helper.php:351
JROOT/libraries/cms/component/helper.php:331
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:53
Query Time: 0.21 ms After last query: 0.36 ms Query memory: 0.029 MB Memory before query: 8.709 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `cdl_contentitem_tag_map` AS m
INNER JOIN `cdl_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 115
AND `t`.`published` = 1
AND t.access IN (1,1,5)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | ALL | idx_tag_type,idx_tag | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where |
1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | cdl_db.m.tag_id | 1 | Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
System lock | 0.0 ms |
init | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
logging slow query | 0.0 ms |
cleaning up | 0.0 ms |
JROOT/libraries/cms/helper/tags.php:416
JROOT/components/com_content/models/articles.php:672
JROOT/components/com_content/models/category.php:234
JROOT/libraries/legacy/view/legacy.php:398
JROOT/libraries/legacy/view/category.php:108
JROOT/components/com_content/views/category/view.html.php:72
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_content/controller.php:79
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_content/content.php:17
JROOT/libraries/cms/component/helper.php:351
JROOT/libraries/cms/component/helper.php:331
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:53
Query Time: 0.20 ms After last query: 0.36 ms Query memory: 0.029 MB Memory before query: 8.748 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `cdl_contentitem_tag_map` AS m
INNER JOIN `cdl_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 114
AND `t`.`published` = 1
AND t.access IN (1,1,5)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | ALL | idx_tag_type,idx_tag | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where |
1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | cdl_db.m.tag_id | 1 | Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
System lock | 0.0 ms |
init | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
logging slow query | 0.0 ms |
cleaning up | 0.0 ms |
JROOT/libraries/cms/helper/tags.php:416
JROOT/components/com_content/models/articles.php:672
JROOT/components/com_content/models/category.php:234
JROOT/libraries/legacy/view/legacy.php:398
JROOT/libraries/legacy/view/category.php:108
JROOT/components/com_content/views/category/view.html.php:72
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_content/controller.php:79
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_content/content.php:17
JROOT/libraries/cms/component/helper.php:351
JROOT/libraries/cms/component/helper.php:331
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:53
Query Time: 0.21 ms After last query: 0.38 ms Query memory: 0.029 MB Memory before query: 8.786 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `cdl_contentitem_tag_map` AS m
INNER JOIN `cdl_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 93
AND `t`.`published` = 1
AND t.access IN (1,1,5)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | ALL | idx_tag_type,idx_tag | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where |
1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | cdl_db.m.tag_id | 1 | Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
System lock | 0.0 ms |
init | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
logging slow query | 0.0 ms |
cleaning up | 0.0 ms |
JROOT/libraries/cms/helper/tags.php:416
JROOT/components/com_content/models/articles.php:672
JROOT/components/com_content/models/category.php:234
JROOT/libraries/legacy/view/legacy.php:398
JROOT/libraries/legacy/view/category.php:108
JROOT/components/com_content/views/category/view.html.php:72
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_content/controller.php:79
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_content/content.php:17
JROOT/libraries/cms/component/helper.php:351
JROOT/libraries/cms/component/helper.php:331
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:53
Query Time: 0.23 ms After last query: 0.35 ms Query memory: 0.029 MB Memory before query: 8.826 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `cdl_contentitem_tag_map` AS m
INNER JOIN `cdl_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 51
AND `t`.`published` = 1
AND t.access IN (1,1,5)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | ALL | idx_tag_type,idx_tag | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where |
1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | cdl_db.m.tag_id | 1 | Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
System lock | 0.0 ms |
init | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
logging slow query | 0.0 ms |
cleaning up | 0.0 ms |
JROOT/libraries/cms/helper/tags.php:416
JROOT/components/com_content/models/articles.php:672
JROOT/components/com_content/models/category.php:234
JROOT/libraries/legacy/view/legacy.php:398
JROOT/libraries/legacy/view/category.php:108
JROOT/components/com_content/views/category/view.html.php:72
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_content/controller.php:79
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_content/content.php:17
JROOT/libraries/cms/component/helper.php:351
JROOT/libraries/cms/component/helper.php:331
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:53
Query Time: 0.21 ms After last query: 0.35 ms Query memory: 0.029 MB Memory before query: 8.864 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `cdl_contentitem_tag_map` AS m
INNER JOIN `cdl_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 22
AND `t`.`published` = 1
AND t.access IN (1,1,5)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | ALL | idx_tag_type,idx_tag | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where |
1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | cdl_db.m.tag_id | 1 | Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
System lock | 0.0 ms |
init | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
logging slow query | 0.0 ms |
cleaning up | 0.0 ms |
JROOT/libraries/cms/helper/tags.php:416
JROOT/components/com_content/models/articles.php:672
JROOT/components/com_content/models/category.php:234
JROOT/libraries/legacy/view/legacy.php:398
JROOT/libraries/legacy/view/category.php:108
JROOT/components/com_content/views/category/view.html.php:72
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_content/controller.php:79
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_content/content.php:17
JROOT/libraries/cms/component/helper.php:351
JROOT/libraries/cms/component/helper.php:331
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:53
Query Time: 0.68 ms After last query: 1.29 ms Query memory: 0.024 MB Memory before query: 9.002 MB Rows returned: 1
SELECT COUNT(*)
FROM cdl_content AS a
LEFT JOIN cdl_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN cdl_categories AS c
ON c.id = a.catid
LEFT JOIN cdl_users AS ua
ON ua.id = a.created_by
LEFT JOIN cdl_users AS uam
ON uam.id = a.modified_by
LEFT JOIN cdl_categories as parent
ON parent.id = c.parent_id
LEFT JOIN cdl_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM cdl_categories AS cat JOIN cdl_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid = 8
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-03-20 18:13:40')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-20 18:13:40')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | PRIMARY | a | ref | idx_catid | idx_catid | 4 | const | 9 | Using where |
1 | PRIMARY | fp | eq_ref | PRIMARY | PRIMARY | 4 | cdl_db.a.id | 1 | Using index |
1 | PRIMARY | c | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | PRIMARY | ua | eq_ref | PRIMARY | PRIMARY | 4 | cdl_db.a.created_by | 1 | Using index |
1 | PRIMARY | uam | eq_ref | PRIMARY | PRIMARY | 4 | cdl_db.a.modified_by | 1 | Using index |
1 | PRIMARY | parent | eq_ref | PRIMARY | PRIMARY | 4 | cdl_db.c.parent_id | 1 | Using index |
1 | PRIMARY | v | eq_ref | PRIMARY | PRIMARY | 4 | cdl_db.a.id | 1 | Using index |
1 | PRIMARY | <derived2> | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where |
2 | DERIVED | parent | range | cat_idx,idx_left_right | cat_idx | 153 | NULL | 2 | Using where; Using temporary; Using filesort |
2 | DERIVED | cat | index | idx_left_right | idx_left_right | 8 | NULL | 29 | Using where; Using index; Using join buffer |
Status | Duration |
---|---|
starting | 0.1 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
Creating tmp table | 0.0 ms |
executing | 0.0 ms |
Copying to tmp table | 0.1 ms |
Sorting result | 0.0 ms |
Sending data | 0.0 ms |
removing tmp table | 0.0 ms |
Sending data | 0.0 ms |
init | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.1 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
removing tmp table | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
logging slow query | 0.0 ms |
cleaning up | 0.0 ms |
JROOT/libraries/legacy/model/legacy.php:327
JROOT/libraries/legacy/model/list.php:276
JROOT/libraries/legacy/model/list.php:221
JROOT/components/com_content/models/category.php:246
JROOT/libraries/legacy/view/legacy.php:398
JROOT/libraries/legacy/view/category.php:108
JROOT/components/com_content/views/category/view.html.php:72
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_content/controller.php:79
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_content/content.php:17
JROOT/libraries/cms/component/helper.php:351
JROOT/libraries/cms/component/helper.php:331
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:53
Query Time: 0.25 ms After last query: 0.53 ms Query memory: 0.025 MB Memory before query: 9.010 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `cdl_contentitem_tag_map` AS m
INNER JOIN `cdl_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.category'
AND `m`.`content_item_id` = 8
AND `t`.`published` = 1
AND t.access IN (1,1,5)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | ALL | idx_tag_type,idx_tag | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where |
1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | cdl_db.m.tag_id | 1 | Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
System lock | 0.0 ms |
init | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
logging slow query | 0.0 ms |
cleaning up | 0.0 ms |
JROOT/libraries/cms/helper/tags.php:416
JROOT/libraries/legacy/view/category.php:179
JROOT/components/com_content/views/category/view.html.php:72
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_content/controller.php:79
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_content/content.php:17
JROOT/libraries/cms/component/helper.php:351
JROOT/libraries/cms/component/helper.php:331
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:53
Query Time: 1.39 ms After last query: 52.97 ms Query memory: 0.025 MB Memory before query: 10.308 MB Rows returned: 28
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM cdl_modules AS m
LEFT JOIN cdl_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN cdl_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-03-20 18:13:40')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-03-20 18:13:40')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 573 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | ref | PRIMARY,published,newsfeeds | published | 1 | const | 73 | Using where; Using filesort |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 303 | cdl_db.m.module,const | 1 | Using where |
1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | cdl_db.m.id | 11 | Using where; Using index |
Status | Duration |
---|---|
starting | 0.1 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
System lock | 0.0 ms |
init | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.1 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Sorting result | 0.2 ms |
Sending data | 0.8 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
logging slow query | 0.0 ms |
cleaning up | 0.0 ms |
JROOT/libraries/cms/module/helper.php:362
JROOT/libraries/cms/module/helper.php:84
JROOT/libraries/joomla/document/html/html.php:502
JROOT/templates/sj_health30/includes/yt_renderxml.php:217
JROOT/templates/sj_health30/includes/yt_renderxml.php:108
JROOT/templates/sj_health30/includes/yt_renderxml.php:42
JROOT/templates/sj_health30/includes/frame_inc.php:71
JROOT/templates/sj_health30/index.php:22
JROOT/libraries/joomla/document/html/html.php:570
JROOT/libraries/joomla/document/html/html.php:628
JROOT/libraries/joomla/document/html/html.php:452
JROOT/libraries/cms/application/cms.php:985
JROOT/libraries/cms/application/site.php:700
JROOT/libraries/cms/application/cms.php:261
JROOT/index.php:53
Query Time: 0.19 ms After last query: 5.11 ms Query memory: 0.014 MB Memory before query: 10.447 MB Rows returned: 1
SELECT home
FROM cdl_menu
WHERE id=573
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | cdl_menu | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
System lock | 0.0 ms |
init | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
logging slow query | 0.0 ms |
cleaning up | 0.0 ms |
JROOT/templates/sj_health30/includes/yt_template.class.php:185
JROOT/templates/sj_health30/index.php:47
JROOT/libraries/joomla/document/html/html.php:570
JROOT/libraries/joomla/document/html/html.php:628
JROOT/libraries/joomla/document/html/html.php:452
JROOT/libraries/cms/application/cms.php:985
JROOT/libraries/cms/application/site.php:700
JROOT/libraries/cms/application/cms.php:261
JROOT/index.php:53
Query Time: 0.14 ms After last query: 0.05 ms Query memory: 0.014 MB Memory before query: 10.461 MB Rows returned: 1
SELECT home
FROM cdl_menu
WHERE id=573
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | cdl_menu | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
System lock | 0.0 ms |
init | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
logging slow query | 0.0 ms |
cleaning up | 0.0 ms |
JROOT/templates/sj_health30/includes/yt_template.class.php:186
JROOT/templates/sj_health30/index.php:47
JROOT/libraries/joomla/document/html/html.php:570
JROOT/libraries/joomla/document/html/html.php:628
JROOT/libraries/joomla/document/html/html.php:452
JROOT/libraries/cms/application/cms.php:985
JROOT/libraries/cms/application/site.php:700
JROOT/libraries/cms/application/cms.php:261
JROOT/index.php:53
Query Time: 0.19 ms After last query: 6.38 ms Query memory: 0.023 MB Memory before query: 10.861 MB Rows returned: 1
SELECT id,title,module,position,content,showtitle,params
FROM cdl_modules AS m
WHERE m.access IN (1,1,5)
AND m.published=1
AND m.id IN (166);
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | const | PRIMARY,published | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
System lock | 0.0 ms |
init | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
logging slow query | 0.0 ms |
cleaning up | 0.0 ms |
JROOT/templates/sj_health30/menusys/ytmenu.php:441
JROOT/templates/sj_health30/menusys/ytmenu.php:403
JROOT/templates/sj_health30/menusys/class/mega/tmpl/default.php:26
JROOT/templates/sj_health30/menusys/ytmenu.php:150
JROOT/templates/sj_health30/includes/yt_template.class.php:276
JROOT/templates/sj_health30/includes/yt_template.class.php:486
JROOT/templates/sj_health30/includes/yt_template.class.php:402
JROOT/templates/sj_health30/index.php:148
JROOT/libraries/joomla/document/html/html.php:570
JROOT/libraries/joomla/document/html/html.php:628
JROOT/libraries/joomla/document/html/html.php:452
JROOT/libraries/cms/application/cms.php:985
JROOT/libraries/cms/application/site.php:700
JROOT/libraries/cms/application/cms.php:261
JROOT/index.php:53
Query Time: 0.43 ms After last query: 6.55 ms Query memory: 0.042 MB Memory before query: 11.240 MB Rows returned: 14
SELECT *
FROM cdl_categories AS e
WHERE e.published IN (1)
AND e.extension = 'com_content'
AND e.parent_id > 0 -- Access condition
AND e.language IN ('vi-VN' , '*')
GROUP BY e.id
ORDER BY e.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | e | ref | cat_idx,idx_language | cat_idx | 153 | const,const | 14 | Using where; Using filesort |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
System lock | 0.0 ms |
init | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.1 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Sorting result | 0.1 ms |
Sending data | 0.1 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
logging slow query | 0.0 ms |
cleaning up | 0.0 ms |
JROOT/modules/mod_sj_basic_news/core/helper.php:340
JROOT/modules/mod_sj_basic_news/core/helper.php:187
JROOT/modules/mod_sj_basic_news/core/helper.php:229
JROOT/modules/mod_sj_basic_news/core/helper.php:33
JROOT/modules/mod_sj_basic_news/core/helper.php:25
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/module/helper.php:471
JROOT/modules/mod_sj_basic_news/mod_sj_basic_news.php:27
JROOT/libraries/cms/module/helper.php:177
JROOT/templates/sj_health30/menusys/class/mega/tmpl/default.php:257
JROOT/templates/sj_health30/menusys/ytmenu.php:150
JROOT/templates/sj_health30/menusys/class/mega/tmpl/default.php:29
JROOT/templates/sj_health30/menusys/ytmenu.php:150
JROOT/templates/sj_health30/includes/yt_template.class.php:276
JROOT/templates/sj_health30/includes/yt_template.class.php:486
JROOT/templates/sj_health30/includes/yt_template.class.php:402
JROOT/templates/sj_health30/index.php:148
JROOT/libraries/joomla/document/html/html.php:570
JROOT/libraries/joomla/document/html/html.php:628
JROOT/libraries/joomla/document/html/html.php:452
JROOT/libraries/cms/application/cms.php:985
JROOT/libraries/cms/application/site.php:700
JROOT/libraries/cms/application/cms.php:261
JROOT/index.php:53
Query Time: 0.45 ms After last query: 0.36 ms Query memory: 0.039 MB Memory before query: 11.350 MB Rows returned: 4
SELECT *
FROM cdl_content as e
WHERE e.state IN(1)
AND e.catid IN (9) -- Access condition
AND (e.publish_up = '0000-00-00 00:00:00' OR e.publish_up <= '2023-03-20 18:13:40')
AND (e.publish_down = '0000-00-00 00:00:00' OR e.publish_down >= '2023-03-20 18:13:40')
AND e.language IN ('vi-VN' , '*')
GROUP BY e.id
ORDER BY e.created DESC
LIMIT 0, 4
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | e | ref | idx_state,idx_catid,idx_language | idx_catid | 4 | const | 13 | Using where; Using filesort |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
System lock | 0.0 ms |
init | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Sorting result | 0.1 ms |
Sending data | 0.1 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
logging slow query | 0.0 ms |
cleaning up | 0.0 ms |
JROOT/modules/mod_sj_basic_news/core/helper.php:318
JROOT/modules/mod_sj_basic_news/core/helper.php:262
JROOT/modules/mod_sj_basic_news/core/helper.php:33
JROOT/modules/mod_sj_basic_news/core/helper.php:25
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/module/helper.php:471
JROOT/modules/mod_sj_basic_news/mod_sj_basic_news.php:27
JROOT/libraries/cms/module/helper.php:177
JROOT/templates/sj_health30/menusys/class/mega/tmpl/default.php:257
JROOT/templates/sj_health30/menusys/ytmenu.php:150
JROOT/templates/sj_health30/menusys/class/mega/tmpl/default.php:29
JROOT/templates/sj_health30/menusys/ytmenu.php:150
JROOT/templates/sj_health30/includes/yt_template.class.php:276
JROOT/templates/sj_health30/includes/yt_template.class.php:486
JROOT/templates/sj_health30/includes/yt_template.class.php:402
JROOT/templates/sj_health30/index.php:148
JROOT/libraries/joomla/document/html/html.php:570
JROOT/libraries/joomla/document/html/html.php:628
JROOT/libraries/joomla/document/html/html.php:452
JROOT/libraries/cms/application/cms.php:985
JROOT/libraries/cms/application/site.php:700
JROOT/libraries/cms/application/cms.php:261
JROOT/index.php:53
Query Time: 0.23 ms After last query: 0.15 ms Query memory: 0.040 MB Memory before query: 11.383 MB Rows returned: 4
SELECT *
FROM cdl_content AS e
WHERE e.id IN (113,32,35,36)
GROUP BY e.id;
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | e | range | PRIMARY | PRIMARY | 4 | NULL | 4 | Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
System lock | 0.0 ms |
init | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Sorting result | 0.0 ms |
Sending data | 0.1 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
logging slow query | 0.0 ms |
cleaning up | 0.0 ms |
JROOT/modules/mod_sj_basic_news/core/helper.php:276
JROOT/modules/mod_sj_basic_news/core/helper.php:155
JROOT/modules/mod_sj_basic_news/core/helper.php:264
JROOT/modules/mod_sj_basic_news/core/helper.php:33
JROOT/modules/mod_sj_basic_news/core/helper.php:25
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/module/helper.php:471
JROOT/modules/mod_sj_basic_news/mod_sj_basic_news.php:27
JROOT/libraries/cms/module/helper.php:177
JROOT/templates/sj_health30/menusys/class/mega/tmpl/default.php:257
JROOT/templates/sj_health30/menusys/ytmenu.php:150
JROOT/templates/sj_health30/menusys/class/mega/tmpl/default.php:29
JROOT/templates/sj_health30/menusys/ytmenu.php:150
JROOT/templates/sj_health30/includes/yt_template.class.php:276
JROOT/templates/sj_health30/includes/yt_template.class.php:486
JROOT/templates/sj_health30/includes/yt_template.class.php:402
JROOT/templates/sj_health30/index.php:148
JROOT/libraries/joomla/document/html/html.php:570
JROOT/libraries/joomla/document/html/html.php:628
JROOT/libraries/joomla/document/html/html.php:452
JROOT/libraries/cms/application/cms.php:985
JROOT/libraries/cms/application/site.php:700
JROOT/libraries/cms/application/cms.php:261
JROOT/index.php:53
Query Time: 0.14 ms After last query: 0.50 ms Query memory: 0.036 MB Memory before query: 11.483 MB Rows returned: 1
SELECT alias
FROM cdl_content
WHERE id=113
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | cdl_content | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
System lock | 0.0 ms |
init | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
logging slow query | 0.0 ms |
cleaning up | 0.0 ms |
JROOT/components/com_content/router.php:101
JROOT/libraries/cms/router/site.php:455
JROOT/libraries/cms/router/site.php:413
JROOT/libraries/cms/router/router.php:216
JROOT/libraries/cms/router/site.php:98
JROOT/libraries/joomla/application/route.php:62
JROOT/modules/mod_sj_basic_news/core/helper.php:47
JROOT/modules/mod_sj_basic_news/core/helper.php:25
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/module/helper.php:471
JROOT/modules/mod_sj_basic_news/mod_sj_basic_news.php:27
JROOT/libraries/cms/module/helper.php:177
JROOT/templates/sj_health30/menusys/class/mega/tmpl/default.php:257
JROOT/templates/sj_health30/menusys/ytmenu.php:150
JROOT/templates/sj_health30/menusys/class/mega/tmpl/default.php:29
JROOT/templates/sj_health30/menusys/ytmenu.php:150
JROOT/templates/sj_health30/includes/yt_template.class.php:276
JROOT/templates/sj_health30/includes/yt_template.class.php:486
JROOT/templates/sj_health30/includes/yt_template.class.php:402
JROOT/templates/sj_health30/index.php:148
JROOT/libraries/joomla/document/html/html.php:570
JROOT/libraries/joomla/document/html/html.php:628
JROOT/libraries/joomla/document/html/html.php:452
JROOT/libraries/cms/application/cms.php:985
JROOT/libraries/cms/application/site.php:700
JROOT/libraries/cms/application/cms.php:261
JROOT/index.php:53
Query Time: 0.17 ms After last query: 0.95 ms Query memory: 0.036 MB Memory before query: 11.524 MB Rows returned: 1
SELECT alias
FROM cdl_content
WHERE id=36
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | cdl_content | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
System lock | 0.0 ms |
init | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
logging slow query | 0.0 ms |
cleaning up | 0.0 ms |
JROOT/components/com_content/router.php:101
JROOT/libraries/cms/router/site.php:455
JROOT/libraries/cms/router/site.php:413
JROOT/libraries/cms/router/router.php:216
JROOT/libraries/cms/router/site.php:98
JROOT/libraries/joomla/application/route.php:62
JROOT/modules/mod_sj_basic_news/core/helper.php:47
JROOT/modules/mod_sj_basic_news/core/helper.php:25
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/module/helper.php:471
JROOT/modules/mod_sj_basic_news/mod_sj_basic_news.php:27
JROOT/libraries/cms/module/helper.php:177
JROOT/templates/sj_health30/menusys/class/mega/tmpl/default.php:257
JROOT/templates/sj_health30/menusys/ytmenu.php:150
JROOT/templates/sj_health30/menusys/class/mega/tmpl/default.php:29
JROOT/templates/sj_health30/menusys/ytmenu.php:150
JROOT/templates/sj_health30/includes/yt_template.class.php:276
JROOT/templates/sj_health30/includes/yt_template.class.php:486
JROOT/templates/sj_health30/includes/yt_template.class.php:402
JROOT/templates/sj_health30/index.php:148
JROOT/libraries/joomla/document/html/html.php:570
JROOT/libraries/joomla/document/html/html.php:628
JROOT/libraries/joomla/document/html/html.php:452
JROOT/libraries/cms/application/cms.php:985
JROOT/libraries/cms/application/site.php:700
JROOT/libraries/cms/application/cms.php:261
JROOT/index.php:53
Query Time: 0.31 ms After last query: 29.96 ms Query memory: 0.029 MB Memory before query: 12.909 MB Rows returned: 1
SELECT id,title,module,position,content,showtitle,params
FROM cdl_modules AS m
WHERE m.access IN (1,1,5)
AND m.published=1
AND m.id IN (157);
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | const | PRIMARY,published | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
starting | 0.1 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
System lock | 0.0 ms |
init | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
logging slow query | 0.0 ms |
cleaning up | 0.0 ms |
JROOT/templates/sj_health30/menusys/ytmenu.php:441
JROOT/templates/sj_health30/menusys/ytmenu.php:403
JROOT/templates/sj_health30/menusys/class/mega/tmpl/default_group.php:22
JROOT/templates/sj_health30/menusys/ytmenu.php:150
JROOT/templates/sj_health30/menusys/class/mega/tmpl/default.php:240
JROOT/templates/sj_health30/menusys/ytmenu.php:150
JROOT/templates/sj_health30/menusys/class/mega/tmpl/default.php:29
JROOT/templates/sj_health30/menusys/ytmenu.php:150
JROOT/templates/sj_health30/includes/yt_template.class.php:276
JROOT/templates/sj_health30/includes/yt_template.class.php:486
JROOT/templates/sj_health30/includes/yt_template.class.php:402
JROOT/templates/sj_health30/index.php:148
JROOT/libraries/joomla/document/html/html.php:570
JROOT/libraries/joomla/document/html/html.php:628
JROOT/libraries/joomla/document/html/html.php:452
JROOT/libraries/cms/application/cms.php:985
JROOT/libraries/cms/application/site.php:700
JROOT/libraries/cms/application/cms.php:261
JROOT/index.php:53
Query Time: 0.59 ms After last query: 2.32 ms Query memory: 0.041 MB Memory before query: 12.994 MB Rows returned: 1
SELECT *
FROM cdl_content as e
WHERE e.state IN(1)
AND e.catid IN (13) -- Access condition
AND (e.publish_up = '0000-00-00 00:00:00' OR e.publish_up <= '2023-03-20 18:13:40')
AND (e.publish_down = '0000-00-00 00:00:00' OR e.publish_down >= '2023-03-20 18:13:40')
AND e.language IN ('vi-VN' , '*')
GROUP BY e.id
ORDER BY e.hits DESC
LIMIT 0, 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | e | index_merge | idx_state,idx_catid,idx_language | idx_catid,idx_state | 4,1 | NULL | 4 | Using intersect(idx_catid,idx_state); Using where; Using filesort |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
System lock | 0.0 ms |
init | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.1 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Sorting result | 0.2 ms |
Sending data | 0.1 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
logging slow query | 0.0 ms |
cleaning up | 0.0 ms |
JROOT/modules/mod_sj_basic_news/core/helper.php:318
JROOT/modules/mod_sj_basic_news/core/helper.php:262
JROOT/modules/mod_sj_basic_news/core/helper.php:33
JROOT/modules/mod_sj_basic_news/core/helper.php:25
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/module/helper.php:471
JROOT/modules/mod_sj_basic_news/mod_sj_basic_news.php:27
JROOT/libraries/cms/module/helper.php:177
JROOT/templates/sj_health30/menusys/class/mega/tmpl/default_group.php:67
JROOT/templates/sj_health30/menusys/ytmenu.php:150
JROOT/templates/sj_health30/menusys/class/mega/tmpl/default.php:240
JROOT/templates/sj_health30/menusys/ytmenu.php:150
JROOT/templates/sj_health30/menusys/class/mega/tmpl/default.php:29
JROOT/templates/sj_health30/menusys/ytmenu.php:150
JROOT/templates/sj_health30/includes/yt_template.class.php:276
JROOT/templates/sj_health30/includes/yt_template.class.php:486
JROOT/templates/sj_health30/includes/yt_template.class.php:402
JROOT/templates/sj_health30/index.php:148
JROOT/libraries/joomla/document/html/html.php:570
JROOT/libraries/joomla/document/html/html.php:628
JROOT/libraries/joomla/document/html/html.php:452
JROOT/libraries/cms/application/cms.php:985
JROOT/libraries/cms/application/site.php:700
JROOT/libraries/cms/application/cms.php:261
JROOT/index.php:53
Query Time: 0.20 ms After last query: 0.11 ms Query memory: 0.043 MB Memory before query: 13.029 MB Rows returned: 1
SELECT *
FROM cdl_content AS e
WHERE e.id IN (92)
GROUP BY e.id;
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | e | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
System lock | 0.0 ms |
init | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
logging slow query | 0.0 ms |
cleaning up | 0.0 ms |
JROOT/modules/mod_sj_basic_news/core/helper.php:276
JROOT/modules/mod_sj_basic_news/core/helper.php:155
JROOT/modules/mod_sj_basic_news/core/helper.php:264
JROOT/modules/mod_sj_basic_news/core/helper.php:33
JROOT/modules/mod_sj_basic_news/core/helper.php:25
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/module/helper.php:471
JROOT/modules/mod_sj_basic_news/mod_sj_basic_news.php:27
JROOT/libraries/cms/module/helper.php:177
JROOT/templates/sj_health30/menusys/class/mega/tmpl/default_group.php:67
JROOT/templates/sj_health30/menusys/ytmenu.php:150
JROOT/templates/sj_health30/menusys/class/mega/tmpl/default.php:240
JROOT/templates/sj_health30/menusys/ytmenu.php:150
JROOT/templates/sj_health30/menusys/class/mega/tmpl/default.php:29
JROOT/templates/sj_health30/menusys/ytmenu.php:150
JROOT/templates/sj_health30/includes/yt_template.class.php:276
JROOT/templates/sj_health30/includes/yt_template.class.php:486
JROOT/templates/sj_health30/includes/yt_template.class.php:402
JROOT/templates/sj_health30/index.php:148
JROOT/libraries/joomla/document/html/html.php:570
JROOT/libraries/joomla/document/html/html.php:628
JROOT/libraries/joomla/document/html/html.php:452
JROOT/libraries/cms/application/cms.php:985
JROOT/libraries/cms/application/site.php:700
JROOT/libraries/cms/application/cms.php:261
JROOT/index.php:53
Query Time: 0.27 ms After last query: 9.34 ms Query memory: 0.028 MB Memory before query: 13.036 MB Rows returned: 1