Here is small selection of our existing clients :
Clients
-
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": 1725764027,
"last": 1725764027,
"now": 1725764027
}
},
"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: 3.24 ms / 3.24 ms Memory: 0.183 MB / 0.40 MB Application: afterLoad
Time: 17.95 ms / 21.19 ms Memory: 1.370 MB / 1.77 MB Application: afterInitialise
Time: 7.96 ms / 29.15 ms Memory: 0.685 MB / 2.46 MB Application: afterRoute
Time: 1.34 ms / 30.49 ms Memory: 0.052 MB / 2.51 MB Application: beforeRenderComponent com_content
Time: 4.14 ms / 34.63 ms Memory: 0.292 MB / 2.80 MB Application: Start JAccess::getAssetRules Old (1)
Time: 0.84 ms / 35.47 ms Memory: 0.036 MB / 2.84 MB Application: Finish JAccess::getAssetRules Old (1)
Time: 0.04 ms / 35.51 ms Memory: 0.000 MB / 2.83 MB Application: Start JAccess::preload(components)
Time: 2.65 ms / 38.16 ms Memory: 0.276 MB / 3.11 MB Application: Finish JAccess::preload(components)
Time: 11.89 ms / 50.05 ms Memory: 0.586 MB / 3.70 MB Application: afterRenderComponent com_content
Time: 1.48 ms / 51.53 ms Memory: 0.074 MB / 3.77 MB Application: afterDispatch
Time: 6.84 ms / 58.37 ms Memory: 0.307 MB / 4.08 MB Application: beforeRenderModule mod_custom (Telephone)
Time: 0.54 ms / 58.91 ms Memory: 0.012 MB / 4.09 MB Application: afterRenderModule mod_custom (Telephone)
Time: 0.07 ms / 58.98 ms Memory: 0.000 MB / 4.09 MB Application: beforeRenderModule mod_custom (popout)
Time: 0.19 ms / 59.17 ms Memory: 0.007 MB / 4.09 MB Application: afterRenderModule mod_custom (popout)
Time: 0.09 ms / 59.25 ms Memory: 0.000 MB / 4.09 MB Application: beforeRenderModule mod_custom (Footer Address/social meda)
Time: 0.21 ms / 59.47 ms Memory: 0.007 MB / 4.10 MB Application: afterRenderModule mod_custom (Footer Address/social meda)
Time: 0.06 ms / 59.53 ms Memory: 0.000 MB / 4.10 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 0.74 ms / 60.27 ms Memory: 0.021 MB / 4.12 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 0.07 ms / 60.34 ms Memory: 0.000 MB / 4.11 MB Application: beforeRenderModule mod_search (Search)
Time: 0.59 ms / 60.92 ms Memory: 0.024 MB / 4.14 MB Application: afterRenderModule mod_search (Search)
Time: 0.07 ms / 60.99 ms Memory: 0.000 MB / 4.13 MB Application: beforeRenderModule mod_menu (Main Menu)
Time: 4.95 ms / 65.94 ms Memory: 0.100 MB / 4.23 MB Application: afterRenderModule mod_menu (Main Menu)
Time: 0.14 ms / 66.08 ms Memory: 0.019 MB / 4.25 MB Application: beforeRenderModule mod_zentools (Testimonials Top)
Time: 7.20 ms / 73.27 ms Memory: 0.231 MB / 4.48 MB Application: afterRenderModule mod_zentools (Testimonials Top)
Time: 0.16 ms / 73.44 ms Memory: 0.000 MB / 4.37 MB Application: beforeRenderModule mod_custom (LOGO)
Time: 0.23 ms / 73.67 ms Memory: 0.007 MB / 4.38 MB Application: afterRenderModule mod_custom (LOGO)
Time: 14.73 ms / 88.40 ms Memory: 0.086 MB / 4.46 MB Application: afterRender
Database queries total: 20.36 ms
4.91 MB (5,144,912 Bytes)
28 Queries Logged 20.36 ms
- Query Time: 0.63 ms
SELECT `data`
FROM `d6eu4_session`
WHERE `session_id` = 'enqflh3dijsr43sis5gk03nl11'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.67 ms After last query: 0.81 ms
DELETE
FROM `d6eu4_session`
WHERE `time` < '1725763127'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE d6eu4_session range time time 59 NULL 1 100.00 Using where No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 6 JDatabaseDriverMysql->execute() JROOT/libraries/cms/application/cms.php:797 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.35 ms After last query: 0.09 ms
SELECT `session_id`
FROM `d6eu4_session`
WHERE `session_id` = 'enqflh3dijsr43sis5gk03nl11'
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.40 ms After last query: 0.11 ms
INSERT INTO `d6eu4_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`)
VALUES ('enqflh3dijsr43sis5gk03nl11', 0, 1, '1725764027', 0, '')EXPLAIN not possible on query: INSERT INTO `d6eu4_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('enqflh3dijsr43sis5gk03nl11', 0, 1, '1725764027', 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.52 ms After last query: 0.59 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.50 ms After last query: 0.52 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.37 ms After last query: 0.16 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.60 ms After last query: 0.12 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 159 44.03 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: 0.78 ms After last query: 5.40 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 45.33 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.74 ms After last query: 3.58 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.47 ms After last query: 0.67 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.64 ms After last query: 0.20 ms
UPDATE `d6eu4_extensions`
SET `params` = '{\"mediaversion\":\"ed7c6e4449347bedb7456c184dcaba8a\"}'
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.41 ms After last query: 0.93 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: 0.96 ms After last query: 2.51 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 21 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1689 20 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:440 19 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/joomla/table/table.php:241 18 JTable->getFields() JROOT/libraries/joomla/table/table.php:162 17 JTable->__construct() JROOT/libraries/joomla/table/asset.php:60 16 JTableAsset->__construct() JROOT/libraries/joomla/table/table.php:308 15 JTable::getInstance() JROOT/libraries/joomla/access/access.php:696 14 JAccess::getExtensionNameFromAsset() JROOT/libraries/joomla/access/access.php:555 13 JAccess::getAssetRules() JROOT/libraries/joomla/user/user.php:385 12 JUser->authorise() JROOT/components/com_content/models/article.php:55 11 ContentModelArticle->populateState() JROOT/libraries/legacy/model/legacy.php:435 10 JModelLegacy->getState() JROOT/components/com_content/models/article.php:262 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 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.48 ms After last query: 0.50 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 Status Duration Starting 0.08 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.02 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 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 17 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1453 16 JDatabaseDriver->loadAssoc() JROOT/libraries/joomla/table/table.php:719 15 JTable->load() JROOT/libraries/joomla/access/access.php:697 14 JAccess::getExtensionNameFromAsset() JROOT/libraries/joomla/access/access.php:555 13 JAccess::getAssetRules() JROOT/libraries/joomla/user/user.php:385 12 JUser->authorise() JROOT/components/com_content/models/article.php:55 11 ContentModelArticle->populateState() JROOT/libraries/legacy/model/legacy.php:435 10 JModelLegacy->getState() JROOT/components/com_content/models/article.php:262 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 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.50 ms After last query: 0.19 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.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.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.05 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 15 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1538 14 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:652 13 JAccess::getAssetRules() JROOT/libraries/joomla/user/user.php:385 12 JUser->authorise() JROOT/components/com_content/models/article.php:55 11 ContentModelArticle->populateState() JROOT/libraries/legacy/model/legacy.php:435 10 JModelLegacy->getState() JROOT/components/com_content/models/article.php:262 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 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.51 ms After last query: 0.37 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.07 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.12 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 17 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1538 16 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:413 15 JAccess::preloadComponents() JROOT/libraries/joomla/access/access.php:213 14 JAccess::preload() JROOT/libraries/joomla/access/access.php:168 13 JAccess::check() JROOT/libraries/joomla/user/user.php:394 12 JUser->authorise() JROOT/components/com_content/models/article.php:55 11 ContentModelArticle->populateState() JROOT/libraries/legacy/model/legacy.php:435 10 JModelLegacy->getState() JROOT/components/com_content/models/article.php:262 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 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.63 ms After last query: 0.17 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.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.03 ms Optimizing 0.02 ms Statistics 0.09 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.19 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 17 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1494 16 JDatabaseDriver->loadAssocList() JROOT/libraries/joomla/access/access.php:441 15 JAccess::preloadComponents() JROOT/libraries/joomla/access/access.php:213 14 JAccess::preload() JROOT/libraries/joomla/access/access.php:168 13 JAccess::check() JROOT/libraries/joomla/user/user.php:394 12 JUser->authorise() JROOT/components/com_content/models/article.php:55 11 ContentModelArticle->populateState() JROOT/libraries/legacy/model/legacy.php:435 10 JModelLegacy->getState() JROOT/components/com_content/models/article.php:262 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 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.82 ms After last query: 1.60 ms
SHOW FULL COLUMNS
FROM `d6eu4_content`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `d6eu4_content`Status Duration Starting 0.05 ms checking permissions 0.01 ms closing tables 0.01 ms Opening tables 0.23 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms checking permissions 0.11 ms closing tables 0.01 ms Executing 0.01 ms Sending data 0.05 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.08 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 16 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1689 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:440 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/joomla/table/table.php:241 13 JTable->getFields() JROOT/libraries/joomla/table/table.php:162 12 JTable->__construct() JROOT/libraries/legacy/table/content.php:31 11 JTableContent->__construct() JROOT/libraries/joomla/table/table.php:308 10 JTable::getInstance() JROOT/components/com_content/models/article.php:264 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 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: 0.92 ms
SELECT *
FROM d6eu4_content
WHERE `id` = '19'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE d6eu4_content const PRIMARY PRIMARY 4 const 1 100.00 Status Duration Starting 0.04 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.01 ms Statistics 0.10 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 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 12 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1453 11 JDatabaseDriver->loadAssoc() JROOT/libraries/joomla/table/table.php:719 10 JTable->load() JROOT/components/com_content/models/article.php:265 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 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.51 ms After last query: 0.15 ms
UPDATE d6eu4_content
SET `hits` = (`hits` + 1)
WHERE `id` = '19'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE d6eu4_content range PRIMARY PRIMARY 4 NULL 1 100.00 Using where Status Duration Starting 0.06 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 for update 0.04 ms Updating 0.09 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.15 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 11 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/table/table.php:1228 10 JTable->hit() JROOT/components/com_content/models/article.php:266 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 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.01 ms After last query: 0.72 ms
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, 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, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,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
FROM d6eu4_content AS a
LEFT JOIN d6eu4_categories AS c
on c.id = a.catid
LEFT JOIN d6eu4_users AS u
on u.id = a.created_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 <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.id = 19
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-09-08 02:53:47')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-09-08 02:53:47')
AND (a.state = 1 OR a.state =2)id select_type table type possible_keys key key_len ref rows filtered Extra 1 PRIMARY a const PRIMARY,idx_state PRIMARY 4 const 1 100.00 1 PRIMARY c const PRIMARY PRIMARY 4 const 1 100.00 1 PRIMARY u const PRIMARY PRIMARY 4 const 1 100.00 1 PRIMARY parent const PRIMARY PRIMARY 4 const 1 100.00 1 PRIMARY v const PRIMARY PRIMARY 4 const 0 0.00 Unique row not found 1 PRIMARY <derived2> ref key0 key0 5 const 0 0.00 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 14 40.00 Using index condition; Using where Status Duration Starting 0.18 ms checking permissions 0.01 ms Opening tables 0.07 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.08 ms Optimizing 0.04 ms Optimizing 0.02 ms Statistics 0.05 ms Statistics 0.11 ms Preparing 0.03 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.03 ms Executing 0.01 ms Sending data 0.11 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.02 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.01 ms Reset for next command 0.01 ms # Caller File and line number 14 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1650 13 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:159 12 ContentModelArticle->getItem() JROOT/libraries/legacy/view/legacy.php:408 11 JViewLegacy->get() JROOT/components/com_content/views/article/view.html.php:42 10 ContentViewArticle->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.56 ms After last query: 1.01 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=2
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.19 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.08 ms Optimizing 0.03 ms Optimizing 0.01 ms Statistics 0.05 ms Statistics 0.08 ms Preparing 0.02 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.06 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.03 ms Executing 0.01 ms Sending data 0.13 ms Creating sort index 0.03 ms Removing tmp table 0.01 ms Creating sort index 0.29 ms Creating sort index 0.05 ms Removing tmp table 0.07 ms Creating sort index 0.02 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.02 ms closing tables 0.02 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.01 ms # Caller File and line number 15 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1689 14 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:309 13 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:184 12 JCategories->get() JROOT/components/com_content/helpers/route.php:44 11 ContentHelperRoute::getArticleRoute() JROOT/components/com_content/views/article/view.html.php:71 10 ContentViewArticle->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.61 ms After last query: 0.78 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` = 19
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.12 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.04 ms Optimizing 0.02 ms Statistics 0.08 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.04 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 13 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1689 12 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/helper/tags.php:435 11 JHelperTags->getItemTags() JROOT/components/com_content/views/article/view.html.php:156 10 ContentViewArticle->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.50 ms After last query: 6.06 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 <= '2024-09-08 02:53:47')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-09-08 02:53:47')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 119 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 81.71 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.23 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.06 ms Optimizing 0.04 ms Statistics 0.11 ms Preparing 0.05 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.73 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 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.68 ms After last query: 12.67 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 <= '2024-09-08 02:53:47')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-09-08 02:53:47')
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 67.59 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.47 ms checking permissions 0.02 ms Opening tables 0.10 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.16 ms Optimizing 0.06 ms Optimizing 0.02 ms Statistics 0.11 ms Statistics 0.14 ms Preparing 0.05 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.03 ms Creating sort index 0.09 ms Executing 0.01 ms Sending data 0.11 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/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.62 ms After last query: 0.47 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.04 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.07 ms Optimizing 0.03 ms Optimizing 0.01 ms Statistics 0.04 ms Statistics 0.07 ms Preparing 0.03 ms Creating tmp table 0.03 ms Sorting result 0.02 ms Preparing 0.03 ms Unlocking tables 0.02 ms Preparing 0.03 ms Creating tmp table 0.04 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.03 ms Executing 0.01 ms Sending data 0.13 ms Creating sort index 0.02 ms Removing tmp table 0.01 ms Creating sort index 0.40 ms Creating sort index 0.06 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.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 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.44 ms After last query: 0.82 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
25 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
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`2 × SELECT `m`.`tag_id`,`t`.*
FROM `d6eu4_contentitem_tag_map` AS m
INNER JOIN `d6eu4_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT a.name, a.rules
FROM d6eu4_assets AS a1 × SELECT element
FROM d6eu4_extensions1 × SELECT *
FROM d6eu4_content1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, 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, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,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
FROM d6eu4_content AS a
LEFT JOIN d6eu4_categories AS c
on c.id = a.catid
LEFT JOIN d6eu4_users AS u
on u.id = a.created_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 a.rules
FROM d6eu4_assets AS a1 × 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.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 *
FROM d6eu4_assets1 × 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_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_content1 × UPDATE d6eu4_content
SET `hits` = (`hits` + 1)1 × SHOW FULL COLUMNS
FROM `d6eu4_assets1 × UPDATE `d6eu4_extensions`
SET `params` = '{\"mediaversion\":\"ed7c6e4449347bedb7456c184dcaba8a\"}'1 × INSERT INTO `d6eu4_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`)
VALUES ('enqflh3dijsr43sis5gk03nl11', 0, 1, '1725764027', 0, ''1 × DELETE
FROM `d6eu4_session`