-
Built on solid foundations, McGuigan Builders, a company that delivers on quality, reliability, dependability and customer satisfaction.
Address
Carrickaderry,
Clontibret,
Co. Monaghan.
Phone: + 353 47 80047
Fax: + 353 47 80114
Mobile: + 353 86 2590995
Web: www.mcguiganbuilders.ie
Email: info@mcguiganbuilders.ie
Office Hours
Monday-Friday: 9:00am-5:30pm
Lunch: 1.00-2:00 pm
Joomla! Debug Console
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1701792280,
"last": 1701792280,
"now": 1701792280
}
},
"registry": {},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
}
}
}
Time
Memory
Time: 4.13 ms / 4.13 ms Memory: 0.183 MB / 0.40 MB Application: afterLoad
Time: 39.89 ms / 44.02 ms Memory: 5.234 MB / 5.64 MB Application: afterInitialise
Time: 13.86 ms / 57.88 ms Memory: 1.526 MB / 7.16 MB Application: afterRoute
Time: 1.77 ms / 59.66 ms Memory: 0.081 MB / 7.24 MB Application: beforeRenderComponent com_content
Time: 12.93 ms / 72.59 ms Memory: 1.578 MB / 8.82 MB Application: Start JAccess::getAssetRules Old (1)
Time: 1.11 ms / 73.70 ms Memory: 0.066 MB / 8.89 MB Application: Finish JAccess::getAssetRules Old (1)
Time: 0.05 ms / 73.75 ms Memory: 0.000 MB / 8.88 MB Application: New JAccess Preloading Process(com_content.category)
Time: 1.26 ms / 75.01 ms Memory: 0.116 MB / 9.00 MB Application: After preloadPermissionsParentIdMapping (com_content.category)
Time: 1.55 ms / 76.56 ms Memory: 0.190 MB / 9.19 MB Application: After preloadPermissions (com_content.category)
Time: 0.01 ms / 76.57 ms Memory: 0.002 MB / 9.19 MB Application: End New JAccess Preloading Process(com_content.category)
Time: 0.02 ms / 76.59 ms Memory: 0.002 MB / 9.19 MB Application: Start JAccess::getAssetRules New (com_content.category.8)
Time: 0.10 ms / 76.68 ms Memory: 0.010 MB / 9.20 MB Application: Finish JAccess::getAssetRules New (com_content.category.8)
Time: 5.66 ms / 82.34 ms Memory: 0.416 MB / 9.62 MB Application: Start JAccess::preload(components)
Time: 3.30 ms / 85.64 ms Memory: 0.284 MB / 9.90 MB Application: Finish JAccess::preload(components)
Time: 23.01 ms / 108.65 ms Memory: 2.265 MB / 12.17 MB Application: afterRenderComponent com_content
Time: 0.77 ms / 109.42 ms Memory: 0.018 MB / 12.19 MB Application: afterDispatch
Time: 9.19 ms / 118.61 ms Memory: 0.586 MB / 12.77 MB Application: beforeRenderModule mod_custom (Telephone)
Time: 0.80 ms / 119.41 ms Memory: 0.075 MB / 12.85 MB Application: afterRenderModule mod_custom (Telephone)
Time: 0.07 ms / 119.48 ms Memory: 0.000 MB / 12.84 MB Application: beforeRenderModule mod_custom (popout)
Time: 0.23 ms / 119.71 ms Memory: 0.007 MB / 12.85 MB Application: afterRenderModule mod_custom (popout)
Time: 0.09 ms / 119.80 ms Memory: 0.000 MB / 12.85 MB Application: beforeRenderModule mod_custom (Footer Address/social meda)
Time: 0.22 ms / 120.02 ms Memory: 0.007 MB / 12.86 MB Application: afterRenderModule mod_custom (Footer Address/social meda)
Time: 0.06 ms / 120.08 ms Memory: 0.000 MB / 12.85 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 0.83 ms / 120.91 ms Memory: 0.037 MB / 12.89 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 0.07 ms / 120.98 ms Memory: 0.000 MB / 12.88 MB Application: beforeRenderModule mod_search (Search)
Time: 0.68 ms / 121.67 ms Memory: 0.026 MB / 12.91 MB Application: afterRenderModule mod_search (Search)
Time: 0.07 ms / 121.73 ms Memory: 0.000 MB / 12.90 MB Application: beforeRenderModule mod_menu (Main Menu)
Time: 6.73 ms / 128.47 ms Memory: 0.148 MB / 13.05 MB Application: afterRenderModule mod_menu (Main Menu)
Time: 0.13 ms / 128.60 ms Memory: 0.018 MB / 13.07 MB Application: beforeRenderModule mod_zentools (Testimonials Top)
Time: 9.90 ms / 138.50 ms Memory: 0.436 MB / 13.50 MB Application: afterRenderModule mod_zentools (Testimonials Top)
Time: 0.18 ms / 138.68 ms Memory: 0.000 MB / 13.39 MB Application: beforeRenderModule mod_custom (LOGO)
Time: 0.24 ms / 138.93 ms Memory: 0.007 MB / 13.40 MB Application: afterRenderModule mod_custom (LOGO)
Time: 14.50 ms / 153.43 ms Memory: 0.397 MB / 13.80 MB Application: afterRender
Database queries total: 25.81 ms
14.29 MB (14,982,824 Bytes)
28 Queries Logged 25.81 ms
- Query Time: 0.57 ms
SELECT `data`
FROM `d6eu4_session`
WHERE `session_id` = '6bfame9i6dg4jp5osgg7jcmit4'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE d6eu4_session const PRIMARY PRIMARY 766 const 1 100.00 No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 14 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1728 13 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:44 12 JSessionStorageDatabase->read() Same as call in the line below. 11 session_start() JROOT/libraries/joomla/session/handler/native.php:259 10 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:49 9 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:81 8 JSessionHandlerJoomla->start() JROOT/libraries/joomla/session/session.php:636 7 JSession->_start() JROOT/libraries/joomla/session/session.php:596 6 JSession->start() JROOT/libraries/cms/application/cms.php:780 5 JApplicationCms->loadSession() JROOT/libraries/cms/application/cms.php:132 4 JApplicationCms->__construct() JROOT/libraries/cms/application/site.php:63 3 JApplicationSite->__construct() JROOT/libraries/cms/application/cms.php:415 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:46 - Query Time: 0.36 ms After last query: 1.68 ms
SELECT `session_id`
FROM `d6eu4_session`
WHERE `session_id` = '6bfame9i6dg4jp5osgg7jcmit4'
LIMIT 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE d6eu4_session const PRIMARY PRIMARY 766 const 1 100.00 Using index No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 8 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1728 7 JDatabaseDriver->loadResult() JROOT/libraries/cms/application/cms.php:177 6 JApplicationCms->checkSession() JROOT/libraries/cms/application/cms.php:806 5 JApplicationCms->loadSession() JROOT/libraries/cms/application/cms.php:132 4 JApplicationCms->__construct() JROOT/libraries/cms/application/site.php:63 3 JApplicationSite->__construct() JROOT/libraries/cms/application/cms.php:415 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:46 - Query Time: 0.51 ms After last query: 0.10 ms
INSERT INTO `d6eu4_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`)
VALUES ('6bfame9i6dg4jp5osgg7jcmit4', 0, 1, '1701792280', 0, '')EXPLAIN not possible on query: INSERT INTO `d6eu4_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('6bfame9i6dg4jp5osgg7jcmit4', 0, 1, '1701792280', 0, '')No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 7 JDatabaseDriverMysql->execute() JROOT/libraries/cms/application/cms.php:213 6 JApplicationCms->checkSession() JROOT/libraries/cms/application/cms.php:806 5 JApplicationCms->loadSession() JROOT/libraries/cms/application/cms.php:132 4 JApplicationCms->__construct() JROOT/libraries/cms/application/site.php:63 3 JApplicationSite->__construct() JROOT/libraries/cms/application/cms.php:415 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:46 - Query Time: 0.59 ms After last query: 1.90 ms
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `d6eu4_extensions`
WHERE `type` = 'component'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE d6eu4_extensions ref extension extension 82 const 33 100.00 Using index condition No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 10 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1689 9 JDatabaseDriver->loadObjectList() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:152 7 JCacheControllerCallback->get() JROOT/libraries/cms/component/helper.php:448 6 JComponentHelper::load() JROOT/libraries/cms/component/helper.php:43 5 JComponentHelper::getComponent() JROOT/libraries/cms/component/helper.php:120 4 JComponentHelper::getParams() JROOT/libraries/cms/application/site.php:589 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:268 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.51 ms After last query: 1.34 ms
SELECT b.id
FROM d6eu4_usergroups AS a
LEFT JOIN d6eu4_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 100.00 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 1 100.00 Using where; Using index No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 11 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1538 10 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:835 9 JAccess::getGroupsByUser() JROOT/libraries/joomla/access/access.php:904 8 JAccess::getAuthorisedViewLevels() JROOT/libraries/joomla/user/user.php:454 7 JUser->getAuthorisedViewLevels() JROOT/libraries/cms/plugin/helper.php:296 6 JPluginHelper::load() JROOT/libraries/cms/plugin/helper.php:86 5 JPluginHelper::getPlugin() JROOT/libraries/cms/plugin/helper.php:128 4 JPluginHelper::isEnabled() JROOT/libraries/cms/application/site.php:599 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:268 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.34 ms After last query: 0.49 ms
SELECT id, rules
FROM `d6eu4_viewlevels`id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE d6eu4_viewlevels ALL NULL NO INDEX KEY COULD BE USED NULL NULL 5 100.00 No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 10 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1494 9 JDatabaseDriver->loadAssocList() JROOT/libraries/joomla/access/access.php:921 8 JAccess::getAuthorisedViewLevels() JROOT/libraries/joomla/user/user.php:454 7 JUser->getAuthorisedViewLevels() JROOT/libraries/cms/plugin/helper.php:296 6 JPluginHelper::load() JROOT/libraries/cms/plugin/helper.php:86 5 JPluginHelper::getPlugin() JROOT/libraries/cms/plugin/helper.php:128 4 JPluginHelper::isEnabled() JROOT/libraries/cms/application/site.php:599 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:268 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.75 ms After last query: 0.11 ms
SELECT folder AS type, element AS name, params
FROM d6eu4_extensions
WHERE enabled = 1
AND type ='plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE d6eu4_extensions ALL extension NO INDEX KEY COULD BE USED NULL NULL 183 38.25 Using where; Using filesort No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 8 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1689 7 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/plugin/helper.php:310 6 JPluginHelper::load() JROOT/libraries/cms/plugin/helper.php:86 5 JPluginHelper::getPlugin() JROOT/libraries/cms/plugin/helper.php:128 4 JPluginHelper::isEnabled() JROOT/libraries/cms/application/site.php:599 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:268 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 1.08 ms After last query: 13.79 ms
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 d6eu4_menu AS m
LEFT JOIN d6eu4_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.lftid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 34 79.07 Using index condition; Using where; Using filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 aurainte_mcgbuild.m.component_id 1 100.00 Using where No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 16 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1689 15 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/menu/site.php:86 14 JMenuSite->load() JROOT/libraries/cms/menu/menu.php:74 13 JMenu->__construct() JROOT/libraries/cms/menu/site.php:57 12 JMenuSite->__construct() JROOT/libraries/cms/menu/menu.php:145 11 JMenu::getInstance() JROOT/libraries/cms/application/cms.php:446 10 JApplicationCms->getMenu() JROOT/libraries/cms/application/site.php:272 9 JApplicationSite->getMenu() JROOT/libraries/cms/router/site.php:57 8 JRouterSite->__construct() JROOT/libraries/cms/router/router.php:197 7 JRouter::getInstance() JROOT/libraries/cms/application/cms.php:542 6 JApplicationCms::getRouter() JROOT/libraries/cms/application/site.php:407 5 JApplicationSite::getRouter() JROOT/libraries/cms/application/cms.php:1122 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:791 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:268 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.78 ms After last query: 6.34 ms
SELECT id, home, template, s.params
FROM d6eu4_template_styles as s
LEFT JOIN d6eu4_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 = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e ref element_clientid,element_folder_clientid,extension extension 82 const 3 100.00 Using index condition; Using where 1 SIMPLE s ALL idx_template NO INDEX KEY COULD BE USED NULL NULL 3 100.00 Using where; Using join buffer (flat, BNL join) No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 13 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1689 12 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/application/site.php:484 11 JApplicationSite->getTemplate() JROOT/plugins/system/t3/includes/core/t3.php:310 10 T3::detect() JROOT/plugins/system/t3/t3.php:81 9 plgSystemT3->onAfterRoute() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:159 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:1132 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:791 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:268 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.53 ms After last query: 0.79 ms
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `d6eu4_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE d6eu4_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using index condition No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 19 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1650 18 JDatabaseDriver->loadObject() Same as call in the line below. 17 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:152 16 JCacheControllerCallback->get() JROOT/libraries/cms/library/helper.php:156 15 JLibraryHelper::_load() JROOT/libraries/cms/library/helper.php:47 14 JLibraryHelper::getLibrary() JROOT/libraries/cms/library/helper.php:90 13 JLibraryHelper::getParams() JROOT/libraries/cms/version/version.php:274 12 JVersion->getMediaVersion() JROOT/libraries/joomla/factory.php:755 11 JFactory::createDocument() JROOT/libraries/joomla/factory.php:216 10 JFactory::getDocument() JROOT/plugins/system/zenshortcodes/zenshortcodes.php:30 9 plgSystemzenshortcodes->onAfterRoute() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:159 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:1132 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:791 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:268 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.67 ms After last query: 0.19 ms
UPDATE `d6eu4_extensions`
SET `params` = '{\"mediaversion\":\"1b46d711d1a1d793cb1b2e5c1acedddd\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE d6eu4_extensions range element_clientid,element_folder_clientid,extension extension 484 NULL 1 100.00 Using where No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 15 JDatabaseDriverMysql->execute() JROOT/libraries/cms/library/helper.php:119 14 JLibraryHelper::saveParams() JROOT/libraries/cms/version/version.php:325 13 JVersion->setMediaVersion() JROOT/libraries/cms/version/version.php:284 12 JVersion->getMediaVersion() JROOT/libraries/joomla/factory.php:755 11 JFactory::createDocument() JROOT/libraries/joomla/factory.php:216 10 JFactory::getDocument() JROOT/plugins/system/zenshortcodes/zenshortcodes.php:30 9 plgSystemzenshortcodes->onAfterRoute() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:159 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:1132 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:791 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:268 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.52 ms After last query: 2.31 ms
SELECT *
FROM d6eu4_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE d6eu4_languages ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where; Using filesort No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 7 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1689 6 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/language/helper.php:164 5 JLanguageHelper::getLanguages() JROOT/libraries/cms/application/site.php:329 4 JApplicationSite->getParams() JROOT/libraries/cms/application/site.php:135 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:268 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 1.10 ms After last query: 10.88 ms
SHOW FULL COLUMNS
FROM `d6eu4_assets`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `d6eu4_assets`No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 24 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1689 23 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:440 22 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/joomla/table/table.php:241 21 JTable->getFields() JROOT/libraries/joomla/table/table.php:162 20 JTable->__construct() JROOT/libraries/joomla/table/asset.php:60 19 JTableAsset->__construct() JROOT/libraries/joomla/table/table.php:308 18 JTable::getInstance() JROOT/libraries/joomla/access/access.php:696 17 JAccess::getExtensionNameFromAsset() JROOT/libraries/joomla/access/access.php:555 16 JAccess::getAssetRules() JROOT/libraries/joomla/user/user.php:385 15 JUser->authorise() JROOT/components/com_content/models/category.php:142 14 ContentModelCategory->populateState() JROOT/libraries/legacy/model/legacy.php:435 13 JModelLegacy->getState() JROOT/libraries/legacy/view/legacy.php:408 12 JViewLegacy->get() JROOT/libraries/legacy/view/category.php:114 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:664 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:268 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.45 ms After last query: 1.01 ms
SELECT *
FROM d6eu4_assets
WHERE `id` = '1'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE d6eu4_assets const PRIMARY PRIMARY 4 const 1 100.00 No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 20 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1453 19 JDatabaseDriver->loadAssoc() JROOT/libraries/joomla/table/table.php:719 18 JTable->load() JROOT/libraries/joomla/access/access.php:697 17 JAccess::getExtensionNameFromAsset() JROOT/libraries/joomla/access/access.php:555 16 JAccess::getAssetRules() JROOT/libraries/joomla/user/user.php:385 15 JUser->authorise() JROOT/components/com_content/models/category.php:142 14 ContentModelCategory->populateState() JROOT/libraries/legacy/model/legacy.php:435 13 JModelLegacy->getState() JROOT/libraries/legacy/view/legacy.php:408 12 JViewLegacy->get() JROOT/libraries/legacy/view/category.php:114 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:664 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:268 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.56 ms After last query: 0.21 ms
SELECT a.rules
FROM d6eu4_assets AS a
WHERE (a.id = 1 OR a.name = 'root.1')id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a index_merge PRIMARY,idx_asset_name PRIMARY,idx_asset_name 4,202 NULL 2 100.00 Using union(PRIMARY,idx_asset_name); Using where Status Duration Starting 0.09 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.10 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.06 ms Updating status 0.02 ms Reset for next command 0.03 ms # Caller File and line number 18 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1538 17 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:652 16 JAccess::getAssetRules() JROOT/libraries/joomla/user/user.php:385 15 JUser->authorise() JROOT/components/com_content/models/category.php:142 14 ContentModelCategory->populateState() JROOT/libraries/legacy/model/legacy.php:435 13 JModelLegacy->getState() JROOT/libraries/legacy/view/legacy.php:408 12 JViewLegacy->get() JROOT/libraries/legacy/view/category.php:114 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:664 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:268 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.94 ms After last query: 0.57 ms
SELECT a.id, a.parent_id
FROM d6eu4_assets AS a
WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a ALL PRIMARY,idx_asset_name NO INDEX KEY COULD BE USED NULL NULL 293 100.00 Using where Status Duration Starting 0.08 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.48 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.05 ms Updating status 0.02 ms Reset for next command 0.02 ms # Caller File and line number 20 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1689 19 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/access/access.php:332 18 JAccess::preloadPermissionsParentIdMapping() JROOT/libraries/joomla/access/access.php:240 17 JAccess::preload() JROOT/libraries/joomla/access/access.php:168 16 JAccess::check() JROOT/libraries/joomla/user/user.php:394 15 JUser->authorise() JROOT/components/com_content/models/category.php:142 14 ContentModelCategory->populateState() JROOT/libraries/legacy/model/legacy.php:435 13 JModelLegacy->getState() JROOT/libraries/legacy/view/legacy.php:408 12 JViewLegacy->get() JROOT/libraries/legacy/view/category.php:114 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:664 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:268 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.72 ms After last query: 0.61 ms
SELECT a.id, a.name, a.rules
FROM d6eu4_assets AS a
WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1 )id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a ALL PRIMARY,idx_asset_name NO INDEX KEY COULD BE USED NULL NULL 293 100.00 Using where Status Duration Starting 0.08 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.27 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.05 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 20 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1255 19 JDatabaseDriver->getIterator() JROOT/libraries/joomla/access/access.php:373 18 JAccess::preloadPermissions() JROOT/libraries/joomla/access/access.php:243 17 JAccess::preload() JROOT/libraries/joomla/access/access.php:168 16 JAccess::check() JROOT/libraries/joomla/user/user.php:394 15 JUser->authorise() JROOT/components/com_content/models/category.php:142 14 ContentModelCategory->populateState() JROOT/libraries/legacy/model/legacy.php:435 13 JModelLegacy->getState() JROOT/libraries/legacy/view/legacy.php:408 12 JViewLegacy->get() JROOT/libraries/legacy/view/category.php:114 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:664 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:268 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 2.19 ms After last query: 2.10 ms
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 d6eu4_categories as c
LEFT JOIN (SELECT cat.id as id
FROM d6eu4_categories AS cat JOIN d6eu4_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 d6eu4_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 `d6eu4_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)
AND c.published = 1
AND badcats.id is null
AND s.id=8
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.lftid select_type table type possible_keys key key_len ref rows filtered Extra 1 PRIMARY s const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 Using temporary; Using filesort 1 PRIMARY c ALL cat_idx,idx_access,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 35 45.71 Using where 1 PRIMARY i ref|filter idx_state,idx_catid idx_catid|idx_state 4|1 aurainte_mcgbuild.c.id 2 (84%) 84.09 Using where; Using rowid filter 1 PRIMARY <derived2> ref key0 key0 5 aurainte_mcgbuild.c.id 10 100.00 Using where 2 DERIVED parent ref cat_idx,idx_left_right cat_idx 202 const 15 42.86 Using index condition; Using temporary; Using filesort 2 DERIVED cat index PRIMARY,idx_left_right idx_left_right 8 NULL 35 100.00 Using where; Using index; Using join buffer (flat, BNL join) Status Duration Starting 0.25 ms checking permissions 0.02 ms Opening tables 0.07 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.14 ms Optimizing 0.04 ms Optimizing 0.02 ms Statistics 0.06 ms Statistics 0.13 ms Preparing 0.02 ms Creating tmp table 0.03 ms Sorting result 0.02 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.04 ms Creating tmp table 0.08 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.12 ms Executing 0.01 ms Sending data 0.16 ms Creating sort index 0.04 ms Removing tmp table 0.01 ms Creating sort index 0.45 ms Creating sort index 0.05 ms Removing tmp table 0.12 ms Creating sort index 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Removing tmp table 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.05 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 17 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1689 16 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:309 15 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:184 14 JCategories->get() JROOT/components/com_content/models/category.php:354 13 ContentModelCategory->getCategory() JROOT/libraries/legacy/view/legacy.php:408 12 JViewLegacy->get() JROOT/libraries/legacy/view/category.php:115 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:664 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:268 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.56 ms After last query: 2.07 ms
SELECT element
FROM d6eu4_extensions
WHERE type = 'component'
AND enabled = '1'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE d6eu4_extensions ref extension extension 82 const 33 100.00 Using index condition; Using where Status Duration Starting 0.09 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.13 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.05 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 23 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1538 22 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:413 21 JAccess::preloadComponents() JROOT/libraries/joomla/access/access.php:213 20 JAccess::preload() JROOT/libraries/joomla/access/access.php:168 19 JAccess::check() JROOT/libraries/joomla/user/user.php:394 18 JUser->authorise() JROOT/components/com_content/models/articles.php:466 17 ContentModelArticles->getListQuery() JROOT/libraries/legacy/model/list.php:129 16 JModelList->_getListQuery() JROOT/libraries/legacy/model/list.php:183 15 JModelList->getItems() JROOT/components/com_content/models/articles.php:565 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/legacy/view/legacy.php:408 12 JViewLegacy->get() JROOT/libraries/legacy/view/category.php:128 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:664 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:268 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.68 ms After last query: 0.22 ms
SELECT a.name, a.rules
FROM d6eu4_assets AS a
WHERE (a.name IN ('com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_finder','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_proforms','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper') OR a.name = 'root.1')id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a range idx_asset_name idx_asset_name 202 NULL 34 100.00 Using index condition Status Duration Starting 0.08 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.10 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.20 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.04 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 23 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1494 22 JDatabaseDriver->loadAssocList() JROOT/libraries/joomla/access/access.php:441 21 JAccess::preloadComponents() JROOT/libraries/joomla/access/access.php:213 20 JAccess::preload() JROOT/libraries/joomla/access/access.php:168 19 JAccess::check() JROOT/libraries/joomla/user/user.php:394 18 JUser->authorise() JROOT/components/com_content/models/articles.php:466 17 ContentModelArticles->getListQuery() JROOT/libraries/legacy/model/list.php:129 16 JModelList->_getListQuery() JROOT/libraries/legacy/model/list.php:183 15 JModelList->getItems() JROOT/components/com_content/models/articles.php:565 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/legacy/view/legacy.php:408 12 JViewLegacy->get() JROOT/libraries/legacy/view/category.php:128 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:664 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:268 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 1.33 ms After last query: 1.89 ms
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, a.language, 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,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 d6eu4_content AS a
LEFT JOIN d6eu4_categories AS c
ON c.id = a.catid
LEFT JOIN d6eu4_users AS ua
ON ua.id = a.created_by
LEFT JOIN d6eu4_users AS uam
ON uam.id = a.modified_by
LEFT JOIN d6eu4_categories as parent
ON parent.id = c.parent_id
LEFT JOIN d6eu4_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM d6eu4_categories AS cat JOIN d6eu4_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 a.access IN (1,1)
AND c.access IN (1,1)
AND
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-12-05 16:04:40')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-12-05 16:04: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
LIMIT 12id select_type table type possible_keys key key_len ref rows filtered Extra 1 PRIMARY c const PRIMARY,idx_access PRIMARY 4 const 1 100.00 1 PRIMARY a ref idx_access,idx_catid idx_catid 4 const 2 100.00 Using where; Using filesort 1 PRIMARY ua eq_ref PRIMARY PRIMARY 4 aurainte_mcgbuild.a.created_by 1 100.00 Using where 1 PRIMARY uam eq_ref PRIMARY PRIMARY 4 aurainte_mcgbuild.a.modified_by 1 100.00 Using where 1 PRIMARY parent eq_ref PRIMARY PRIMARY 4 const 1 100.00 Using where 1 PRIMARY v eq_ref PRIMARY PRIMARY 4 aurainte_mcgbuild.a.id 1 100.00 Using where 1 PRIMARY <derived2> ref key0 key0 5 const 0 0.00 Using where 2 LATERAL DERIVED cat const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 2 LATERAL DERIVED parent ref cat_idx,idx_left_right cat_idx 202 const 15 42.86 Using index condition; Using where Status Duration Starting 0.22 ms checking permissions 0.01 ms Opening tables 0.07 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.10 ms Optimizing 0.04 ms Optimizing 0.01 ms Statistics 0.05 ms Statistics 0.12 ms Preparing 0.03 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.04 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.08 ms Executing 0.01 ms Sending data 0.11 ms Executing 0.01 ms Sending data 0.07 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Removing tmp table 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.06 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 18 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1689 17 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/model/legacy.php:310 16 JModelLegacy->_getList() JROOT/libraries/legacy/model/list.php:183 15 JModelList->getItems() JROOT/components/com_content/models/articles.php:565 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/legacy/view/legacy.php:408 12 JViewLegacy->get() JROOT/libraries/legacy/view/category.php:128 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:664 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:268 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.99 ms After last query: 1.76 ms
SELECT COUNT(*)
FROM d6eu4_content AS a
LEFT JOIN d6eu4_categories AS c
ON c.id = a.catid
LEFT JOIN d6eu4_users AS ua
ON ua.id = a.created_by
LEFT JOIN d6eu4_users AS uam
ON uam.id = a.modified_by
LEFT JOIN d6eu4_categories as parent
ON parent.id = c.parent_id
LEFT JOIN d6eu4_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM d6eu4_categories AS cat JOIN d6eu4_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 a.access IN (1,1)
AND c.access IN (1,1)
AND
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-12-05 16:04:40')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-12-05 16:04:40')id select_type table type possible_keys key key_len ref rows filtered Extra 1 PRIMARY c const PRIMARY,idx_access PRIMARY 4 const 1 100.00 1 PRIMARY a ref idx_access,idx_catid idx_catid 4 const 2 100.00 Using where 1 PRIMARY <derived2> ref key0 key0 5 const 0 0.00 Using where 2 LATERAL DERIVED cat const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 2 LATERAL DERIVED parent ref cat_idx,idx_left_right cat_idx 202 const 15 42.86 Using index condition; Using where Status Duration Starting 0.11 ms checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.05 ms Optimizing 0.06 ms Optimizing 0.02 ms Statistics 0.05 ms Statistics 0.09 ms Preparing 0.03 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.03 ms Executing 0.01 ms Sending data 0.10 ms Executing 0.01 ms Sending data 0.10 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.02 ms closing tables 0.01 ms Removing tmp table 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.05 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 18 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1728 17 JDatabaseDriver->loadResult() JROOT/libraries/legacy/model/legacy.php:337 16 JModelLegacy->_getListCount() JROOT/libraries/legacy/model/list.php:278 15 JModelList->getTotal() JROOT/libraries/legacy/model/list.php:228 14 JModelList->getPagination() JROOT/components/com_content/models/category.php:265 13 ContentModelCategory->getItems() JROOT/libraries/legacy/view/legacy.php:408 12 JViewLegacy->get() JROOT/libraries/legacy/view/category.php:128 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:664 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:268 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.56 ms After last query: 1.77 ms
SELECT `m`.`tag_id`,`t`.*
FROM `d6eu4_contentitem_tag_map` AS m
INNER JOIN `d6eu4_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)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ALL idx_tag_type NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 aurainte_mcgbuild.m.tag_id 1 100.00 Using where Status Duration Starting 0.11 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.05 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 14 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1689 13 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/helper/tags.php:435 12 JHelperTags->getItemTags() JROOT/libraries/legacy/view/category.php:217 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:664 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:268 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 2.65 ms After last query: 12.65 ms
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 d6eu4_categories as c
LEFT JOIN (SELECT cat.id as id
FROM d6eu4_categories AS cat JOIN d6eu4_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 d6eu4_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND badcats.id is null
AND s.id=8
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.lftid select_type table type possible_keys key key_len ref rows filtered Extra 1 PRIMARY s const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 Using temporary; Using filesort 1 PRIMARY c ALL cat_idx,idx_access,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 35 45.71 Using where 1 PRIMARY <derived2> ref key0 key0 5 aurainte_mcgbuild.c.id 10 100.00 Using where 2 DERIVED parent ref cat_idx,idx_left_right cat_idx 202 const 15 42.86 Using index condition; Using temporary; Using filesort 2 DERIVED cat index PRIMARY,idx_left_right idx_left_right 8 NULL 35 100.00 Using where; Using index; Using join buffer (flat, BNL join) Status Duration Starting 0.51 ms checking permissions 0.02 ms Opening tables 0.07 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.15 ms Optimizing 0.05 ms Optimizing 0.02 ms Statistics 0.12 ms Statistics 0.14 ms Preparing 0.03 ms Creating tmp table 0.02 ms Sorting result 0.02 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.03 ms Creating tmp table 0.07 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.05 ms Executing 0.01 ms Sending data 0.21 ms Creating sort index 0.04 ms Removing tmp table 0.01 ms Creating sort index 0.47 ms Creating sort index 0.08 ms Removing tmp table 0.14 ms Creating sort index 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.02 ms closing tables 0.01 ms Removing tmp table 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.06 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 24 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1689 23 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:309 22 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:184 21 JCategories->get() JROOT/components/com_content/helpers/route.php:44 20 ContentHelperRoute::getArticleRoute() JROOT/templates/rasa2/html/layouts/joomla/content/item_title.php:20 19 include JROOT/templates/rasa2/html/layouts/joomla/content/item_title.php JROOT/libraries/cms/layout/file.php:121 18 JLayoutFile->render() JROOT/libraries/cms/layout/helper.php:72 17 JLayoutHelper::render() JROOT/templates/rasa2/html/com_content/category/blog_item.php:41 16 include JROOT/templates/rasa2/html/com_content/category/blog_item.php JROOT/libraries/legacy/view/legacy.php:677 15 JViewLegacy->loadTemplate() JROOT/templates/rasa2/html/com_content/category/blog.php:85 14 include JROOT/templates/rasa2/html/com_content/category/blog.php JROOT/libraries/legacy/view/legacy.php:677 13 JViewLegacy->loadTemplate() JROOT/libraries/legacy/view/legacy.php:216 12 JViewLegacy->display() JROOT/libraries/legacy/view/category.php:233 11 JViewCategory->display() JROOT/components/com_content/views/category/view.html.php:258 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:664 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:268 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 2.19 ms After last query: 4.45 ms
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM d6eu4_modules AS m
LEFT JOIN d6eu4_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN d6eu4_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-12-05 16:04:40')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-12-05 16:04:40')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 105 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ref PRIMARY,published,newsfeeds published 1 const 67 57.26 Using index condition; Using where; Using filesort 1 SIMPLE mm ref PRIMARY PRIMARY 4 aurainte_mcgbuild.m.id 1 100.00 Using where; Using index 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 aurainte_mcgbuild.m.module,const 1 100.00 Using index condition; Using where Status Duration Starting 0.25 ms checking permissions 0.02 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.05 ms Optimizing 0.05 ms Statistics 0.08 ms Preparing 0.05 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 1.38 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.05 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 19 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1689 18 JDatabaseDriver->loadObjectList() Same as call in the line below. 17 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:152 16 JCacheControllerCallback->get() JROOT/libraries/cms/module/helper.php:434 15 JModuleHelper::getModuleList() JROOT/libraries/cms/module/helper.php:370 14 JModuleHelper::load() JROOT/libraries/cms/module/helper.php:84 13 JModuleHelper::getModules() JROOT/libraries/joomla/document/html.php:501 12 JDocumentHtml->countModules() JROOT/templates/rasa2/zengrid/zen.php:253 11 Zen4->checkSpotlight() JROOT/templates/rasa2/tpls/blocks/top.php:15 10 include JROOT/templates/rasa2/tpls/blocks/top.php JROOT/templates/rasa2/zengrid/zen.php:277 9 Zen4->loadBlock() JROOT/templates/rasa2/tpls/default.php:24 8 include JROOT/templates/rasa2/tpls/default.php JROOT/templates/rasa2/index.php:22 7 require JROOT/templates/rasa2/index.php JROOT/libraries/joomla/document/html.php:578 6 JDocumentHtml->_loadTemplate() JROOT/libraries/joomla/document/html.php:640 5 JDocumentHtml->_fetchTemplate() JROOT/libraries/joomla/document/html.php:455 4 JDocumentHtml->parse() JROOT/libraries/cms/application/cms.php:1079 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:773 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:274 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 1.41 ms After last query: 16.93 ms
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, a.language, 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,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 d6eu4_content AS a
LEFT JOIN d6eu4_categories AS c
ON c.id = a.catid
LEFT JOIN d6eu4_users AS ua
ON ua.id = a.created_by
LEFT JOIN d6eu4_users AS uam
ON uam.id = a.modified_by
LEFT JOIN d6eu4_categories as parent
ON parent.id = c.parent_id
LEFT JOIN d6eu4_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM d6eu4_categories AS cat JOIN d6eu4_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 a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid IN (35)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-12-05 16:04:40')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-12-05 16:04:40')
ORDER BY a.ordering ASC
LIMIT 3id select_type table type possible_keys key key_len ref rows filtered Extra 1 PRIMARY c const PRIMARY,idx_access PRIMARY 4 const 1 100.00 1 PRIMARY a ref idx_access,idx_catid idx_catid 4 const 1 100.00 Using where; Using filesort 1 PRIMARY ua eq_ref PRIMARY PRIMARY 4 aurainte_mcgbuild.a.created_by 1 100.00 Using where 1 PRIMARY uam eq_ref PRIMARY PRIMARY 4 aurainte_mcgbuild.a.modified_by 1 100.00 Using where 1 PRIMARY parent eq_ref PRIMARY PRIMARY 4 const 1 100.00 Using where 1 PRIMARY v eq_ref PRIMARY PRIMARY 4 aurainte_mcgbuild.a.id 1 100.00 Using where 1 PRIMARY <derived2> ref key0 key0 5 const 0 0.00 Using where 2 LATERAL DERIVED cat const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 2 LATERAL DERIVED parent ref cat_idx,idx_left_right cat_idx 202 const 15 42.86 Using index condition; Using where Status Duration Starting 0.31 ms checking permissions 0.02 ms Opening tables 0.07 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.12 ms Optimizing 0.05 ms Optimizing 0.02 ms Statistics 0.06 ms Statistics 0.13 ms Preparing 0.03 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.03 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.08 ms Executing 0.01 ms Sending data 0.15 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Removing tmp table 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.05 ms Updating status 0.02 ms Reset for next command 0.02 ms # Caller File and line number 16 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1689 15 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/model/legacy.php:310 14 JModelLegacy->_getList() JROOT/libraries/legacy/model/list.php:183 13 JModelList->getItems() JROOT/components/com_content/models/articles.php:565 12 ContentModelArticles->getItems() JROOT/modules/mod_zentools/includes/zenj17contenthelper.php:135 11 ModZentoolsHelper::getList() JROOT/modules/mod_zentools/mod_zentools.php:337 10 include JROOT/modules/mod_zentools/mod_zentools.php JROOT/libraries/cms/module/helper.php:199 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:702 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1093 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:773 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:274 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 1.79 ms After last query: 0.45 ms
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 d6eu4_categories as c
LEFT JOIN (SELECT cat.id as id
FROM d6eu4_categories AS cat JOIN d6eu4_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 d6eu4_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND badcats.id is null
AND s.id=35
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.lftid select_type table type possible_keys key key_len ref rows filtered Extra 1 PRIMARY s const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 Using temporary; Using filesort 1 PRIMARY c ALL cat_idx,idx_access,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 35 45.71 Using where 1 PRIMARY <derived2> ref key0 key0 5 aurainte_mcgbuild.c.id 10 100.00 Using where 2 DERIVED parent ref cat_idx,idx_left_right cat_idx 202 const 15 42.86 Using index condition; Using temporary; Using filesort 2 DERIVED cat index PRIMARY,idx_left_right idx_left_right 8 NULL 35 100.00 Using where; Using index; Using join buffer (flat, BNL join) Status Duration Starting 0.14 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init 0.10 ms Optimizing 0.04 ms Optimizing 0.02 ms Statistics 0.04 ms Statistics 0.09 ms Preparing 0.03 ms Creating tmp table 0.02 ms Sorting result 0.02 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.03 ms Creating tmp table 0.05 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.03 ms Executing 0.01 ms Sending data 0.18 ms Creating sort index 0.03 ms Removing tmp table 0.01 ms Creating sort index 0.44 ms Creating sort index 0.06 ms Removing tmp table 0.11 ms Creating sort index 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Removing tmp table 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.06 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 16 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1689 15 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:309 14 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:184 13 JCategories->get() JROOT/components/com_content/helpers/route.php:44 12 ContentHelperRoute::getArticleRoute() JROOT/modules/mod_zentools/includes/zenj17contenthelper.php:295 11 ModZentoolsHelper::getList() JROOT/modules/mod_zentools/mod_zentools.php:337 10 include JROOT/modules/mod_zentools/mod_zentools.php JROOT/libraries/cms/module/helper.php:199 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:702 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1093 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:773 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:274 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.47 ms After last query: 0.71 ms
SELECT `m`.`tag_id`,`t`.*
FROM `d6eu4_contentitem_tag_map` AS m
INNER JOIN `d6eu4_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 30
AND `t`.`published` = 1
AND t.access IN (1,1)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ALL idx_tag_type NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 aurainte_mcgbuild.m.tag_id 1 100.00 Using where Status Duration Starting 0.07 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.04 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 14 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1689 13 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/helper/tags.php:435 12 JHelperTags->getItemTags() JROOT/modules/mod_zentools/includes/zenj17contenthelper.php:463 11 ModZentoolsHelper::getList() JROOT/modules/mod_zentools/mod_zentools.php:337 10 include JROOT/modules/mod_zentools/mod_zentools.php JROOT/libraries/cms/module/helper.php:199 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:702 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1093 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:773 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:274 1 JApplicationCms->execute() JROOT/index.php:49
24 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
2 × 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, a.language, 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,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 d6eu4_content AS a
LEFT JOIN d6eu4_categories AS c
ON c.id = a.catid
LEFT JOIN d6eu4_users AS ua
ON ua.id = a.created_by
LEFT JOIN d6eu4_users AS uam
ON uam.id = a.modified_by
LEFT JOIN d6eu4_categories as parent
ON parent.id = c.parent_id
LEFT JOIN d6eu4_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM d6eu4_categories AS cat JOIN d6eu4_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt2 × SELECT `m`.`tag_id`,`t`.*
FROM `d6eu4_contentitem_tag_map` AS m
INNER JOIN `d6eu4_tags` AS t
ON `m`.`tag_id` = `t`.`id`2 × 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 d6eu4_categories as c
LEFT JOIN (SELECT cat.id as id
FROM d6eu4_categories AS cat JOIN d6eu4_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `d6eu4_extensions`1 × SELECT a.id, a.name, a.rules
FROM d6eu4_assets AS a1 × 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 d6eu4_categories as c
LEFT JOIN (SELECT cat.id as id
FROM d6eu4_categories AS cat JOIN d6eu4_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt1 × SELECT element
FROM d6eu4_extensions1 × SELECT COUNT(*)
FROM d6eu4_content AS a
LEFT JOIN d6eu4_categories AS c
ON c.id = a.catid
LEFT JOIN d6eu4_users AS ua
ON ua.id = a.created_by
LEFT JOIN d6eu4_users AS uam
ON uam.id = a.modified_by
LEFT JOIN d6eu4_categories as parent
ON parent.id = c.parent_id
LEFT JOIN d6eu4_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM d6eu4_categories AS cat JOIN d6eu4_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM d6eu4_modules AS m
LEFT JOIN d6eu4_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN d6eu4_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT a.id, a.parent_id
FROM d6eu4_assets AS a1 × SELECT a.name, a.rules
FROM d6eu4_assets AS a1 × SELECT a.rules
FROM d6eu4_assets AS a1 × SELECT id, rules
FROM `d6eu4_viewlevels1 × SELECT b.id
FROM d6eu4_usergroups AS a
LEFT JOIN d6eu4_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `session_id`
FROM `d6eu4_session`1 × SELECT folder AS type, element AS name, params
FROM d6eu4_extensions1 × 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 d6eu4_menu AS m
LEFT JOIN d6eu4_extensions AS e
ON m.component_id = e.extension_id1 × SELECT *
FROM d6eu4_assets1 × SELECT *
FROM d6eu4_languages1 × SELECT id, home, template, s.params
FROM d6eu4_template_styles as s
LEFT JOIN d6eu4_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT `data`
FROM `d6eu4_session`
OTHER Tables:
1 × SHOW FULL COLUMNS
FROM `d6eu4_assets1 × UPDATE `d6eu4_extensions`
SET `params` = '{\"mediaversion\":\"1b46d711d1a1d793cb1b2e5c1acedddd\"}'1 × INSERT INTO `d6eu4_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`)
VALUES ('6bfame9i6dg4jp5osgg7jcmit4', 0, 1, '1701792280', 0, ''