TESTING. TESTING. ONE. TWO. THREE.
We always seem to be testing. :)
The Official Website for Westchester County Government
Defining Leadership
"Westchester County is a unique place. Our home county is fortunate to possess a wealth of talented, successful individuals; a strategic location adjacent to New York City; geography blessed by rolling hills, the mighty Hudson River and lovely L.I. Sound." Read the CE's welcome.
Playland Park Enjoys Record Attendance in 2019
This season’s strong amusement park attendance, topping over a half a million visitors, clearly demonstrates that our beautiful amusement park is once again a great destination. -- George Latimer, County Executive. Playland is rejuvenated.
Moving Forward in Westchester
#MyWestchester Youtube Video
#MyWestchester Youtube Video
Westchester County Working For You
Every County department is hard at work for the nearly one million people who call Westchester home. Seniors can dance and perform at the annual Golden Harvest Dance and Talent Show, Halloween is in full swing at Playland Park, and pets can receive an updated rabies vaccination – all here in Westchester County!
HEALTH DEPARTMENT
It's time for the seasonal flu shot. Individuals of all ages should consider getting one. Help prevent the spread of the flu: cover your mouth when coughing, stay home when ill, wash hands regularly, among other precautionary suggestions.
SENIOR PROGRAMS
The Senior Hall of Fame honors the acheivements of outstanding senior citizens from across Westchester County. This event, which began in 1983, showcases how senior citizens contribute to building Westchester.
WESTCHESTER PARKS FOUNDATION
The annual Westchester Winter Wonderland begins Friday, Nov. 29. Mark the date. Check the schedule for your favorite - as well as new - festivities. Tickets are on sale now.
Read. Log. Win. Sign up today for Westchester loves to read.Joomla! Debug Console
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1719479241,
"last": 1719479241,
"now": 1719479241
},
"token": "XcZgfhoSrVn0tQCCyacLho7D1dTG3udY"
},
"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
},
"com_mailto": {
"links": {
"3be06605a26d974442ab48a7bdf0bfb4a516af8c": {
"link": "https://joomlapatch.westchestergov.com/",
"expiry": 1719479241
}
}
}
}
}
Time
Memory
Time: 23.10 ms / 23.10 ms Memory: 1.690 MB / 2.10 MB Application: afterLoad
Time: 113.96 ms / 137.07 ms Memory: 6.824 MB / 8.92 MB Application: afterInitialise
Time: 58.91 ms / 195.98 ms Memory: 4.037 MB / 12.96 MB Application: afterRoute
Time: 1.68 ms / 197.65 ms Memory: 0.027 MB / 12.98 MB Application: beforeRenderComponent com_content
Time: 2.58 ms / 200.23 ms Memory: 0.184 MB / 13.17 MB Application: Before Access::preloadComponents (all components)
Time: 8.01 ms / 208.24 ms Memory: 0.063 MB / 13.23 MB Application: After Access::preloadComponents (all components)
Time: 0.03 ms / 208.26 ms Memory: -0.003 MB / 13.23 MB Application: Before Access::preloadPermissions (com_content)
Time: 6.43 ms / 214.69 ms Memory: 2.070 MB / 15.30 MB Application: After Access::preloadPermissions (com_content)
Time: 0.10 ms / 214.79 ms Memory: -0.128 MB / 15.17 MB Application: Before Access::getAssetRules (id:4173 name:com_content.article.7537)
Time: 0.55 ms / 215.35 ms Memory: 0.026 MB / 15.20 MB Application: After Access::getAssetRules (id:4173 name:com_content.article.7537)
Time: 85.09 ms / 300.43 ms Memory: 6.636 MB / 21.83 MB Application: afterRenderComponent com_content
Time: 1.71 ms / 302.14 ms Memory: 0.055 MB / 21.89 MB Application: afterDispatch
Time: 67.36 ms / 369.50 ms Memory: 1.290 MB / 23.18 MB Application: beforeRenderModule mod_custom (George Latimer)
Time: 1.10 ms / 370.59 ms Memory: 0.032 MB / 23.21 MB Application: afterRenderModule mod_custom (George Latimer)
Time: 0.10 ms / 370.69 ms Memory: -0.002 MB / 23.20 MB Application: beforeRenderModule mod_custom (Playland Park attendance)
Time: 0.27 ms / 370.97 ms Memory: 0.003 MB / 23.21 MB Application: afterRenderModule mod_custom (Playland Park attendance)
Time: 0.07 ms / 371.04 ms Memory: 0.001 MB / 23.21 MB Application: beforeRenderModule mod_custom (Moving Forward in Westchester)
Time: 0.19 ms / 371.23 ms Memory: 0.004 MB / 23.21 MB Application: afterRenderModule mod_custom (Moving Forward in Westchester)
Time: 0.06 ms / 371.29 ms Memory: 0.010 MB / 23.22 MB Application: beforeRenderModule mod_djmediatools (Moving Forward in Westchester)
Time: 10.10 ms / 381.39 ms Memory: 0.412 MB / 23.63 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Time: 0.06 ms / 381.45 ms Memory: 0.007 MB / 23.64 MB Application: After Access::getAssetRules (id:8 name:com_content)
Time: 11.18 ms / 392.63 ms Memory: 0.139 MB / 23.78 MB Application: afterRenderModule mod_djmediatools (Moving Forward in Westchester)
Time: 0.09 ms / 392.72 ms Memory: -0.073 MB / 23.71 MB Application: beforeRenderModule mod_djtabs (Home Page Video)
Time: 6.33 ms / 399.06 ms Memory: 0.172 MB / 23.88 MB Application: afterRenderModule mod_djtabs (Home Page Video)
Time: 0.06 ms / 399.12 ms Memory: -0.012 MB / 23.87 MB Application: beforeRenderModule mod_custom (#MyWestchester Youtube Video)
Time: 0.18 ms / 399.30 ms Memory: 0.003 MB / 23.87 MB Application: afterRenderModule mod_custom (#MyWestchester Youtube Video)
Time: 0.04 ms / 399.34 ms Memory: -0.001 MB / 23.87 MB Application: beforeRenderModule mod_custom (Westchester Working for You header)
Time: 0.18 ms / 399.52 ms Memory: 0.003 MB / 23.87 MB Application: afterRenderModule mod_custom (Westchester Working for You header)
Time: 0.07 ms / 399.59 ms Memory: 0.007 MB / 23.88 MB Application: beforeRenderModule mod_jm_team_profiles (Profiles - Westchester Working for You)
Time: 0.73 ms / 400.32 ms Memory: 0.044 MB / 23.93 MB Application: afterRenderModule mod_jm_team_profiles (Profiles - Westchester Working for You)
Time: 0.07 ms / 400.39 ms Memory: -0.037 MB / 23.89 MB Application: beforeRenderModule mod_custom (Promo - Reads)
Time: 0.21 ms / 400.60 ms Memory: 0.003 MB / 23.89 MB Application: afterRenderModule mod_custom (Promo - Reads)
Time: 0.16 ms / 400.77 ms Memory: 0.007 MB / 23.90 MB Application: beforeRenderModule mod_rsform_list (Parking Availability Information)
Time: 27.32 ms / 428.09 ms Memory: 1.156 MB / 25.05 MB Application: afterRenderModule mod_rsform_list (Parking Availability Information)
Time: 0.51 ms / 428.60 ms Memory: -0.031 MB / 25.02 MB Application: beforeRenderModule mod_custom (Subscribe)
Time: 0.23 ms / 428.83 ms Memory: 0.003 MB / 25.03 MB Application: afterRenderModule mod_custom (Subscribe)
Time: 6.47 ms / 435.30 ms Memory: 0.888 MB / 25.91 MB Application: beforeRenderModule mod_jm_social_icons (Social Media)
Time: 1.13 ms / 436.43 ms Memory: 0.037 MB / 25.95 MB Application: afterRenderModule mod_jm_social_icons (Social Media)
Time: 0.10 ms / 436.53 ms Memory: -0.025 MB / 25.93 MB Application: beforeRenderModule mod_custom (copyrights)
Time: 0.20 ms / 436.73 ms Memory: 0.003 MB / 25.93 MB Application: afterRenderModule mod_custom (copyrights)
Time: 0.10 ms / 436.84 ms Memory: 0.011 MB / 25.94 MB Application: beforeRenderModule mod_nobossnotices (No Boss Test)
Time: 9.20 ms / 446.04 ms Memory: 0.262 MB / 26.20 MB Application: afterRenderModule mod_nobossnotices (No Boss Test)
Time: 0.06 ms / 446.11 ms Memory: -0.034 MB / 26.17 MB Application: beforeRenderModule mod_djmediatools (Home Page Image Custom Item)
Time: 6.77 ms / 452.88 ms Memory: 0.073 MB / 26.24 MB Application: afterRenderModule mod_djmediatools (Home Page Image Custom Item)
Time: 0.10 ms / 452.98 ms Memory: -0.034 MB / 26.21 MB Application: beforeRenderModule mod_tabbed_offcanvas (Tabbed Offcanvas)
Time: 1.12 ms / 454.10 ms Memory: 0.121 MB / 26.33 MB Application: beforeRenderModule mod_djmegamenu (DJ-MegaMenu - Accordion)
Time: 16.64 ms / 470.74 ms Memory: 0.232 MB / 26.56 MB Application: afterRenderModule mod_djmegamenu (DJ-MegaMenu - Accordion)
Time: 0.29 ms / 471.03 ms Memory: -0.003 MB / 26.56 MB Application: beforeRenderModule mod_custom (Read all county news)
Time: 0.25 ms / 471.28 ms Memory: 0.003 MB / 26.56 MB Application: afterRenderModule mod_custom (Read all county news)
Time: 0.04 ms / 471.31 ms Memory: 0.005 MB / 26.57 MB Application: beforeRenderModule mod_jm_articles_category (Latest County News)
Time: 21.32 ms / 492.63 ms Memory: 0.321 MB / 26.89 MB Application: afterRenderModule mod_jm_articles_category (Latest County News)
Time: 0.10 ms / 492.73 ms Memory: -0.157 MB / 26.73 MB Application: afterRenderModule mod_tabbed_offcanvas (Tabbed Offcanvas)
Time: 0.08 ms / 492.82 ms Memory: -0.043 MB / 26.69 MB Application: beforeRenderModule mod_menu (Skipnav)
Time: 1.25 ms / 494.07 ms Memory: 0.010 MB / 26.70 MB Application: afterRenderModule mod_menu (Skipnav)
Time: 0.04 ms / 494.11 ms Memory: -0.005 MB / 26.69 MB Application: beforeRenderModule mod_custom (Google Translate all languages)
Time: 0.20 ms / 494.30 ms Memory: 0.003 MB / 26.70 MB Application: afterRenderModule mod_custom (Google Translate all languages)
Time: 18.70 ms / 513.00 ms Memory: 0.469 MB / 27.17 MB Application: afterRender
Database queries total: 180.09 ms
28.16 MB (29,530,072 Bytes)
70 Queries Logged 180.09 ms
- Query Time: 2.56 ms Query memory: 0.020 MB Memory before query: 3.689 MB Rows returned: 0
SELECT `session_id`
FROM `a3fsm_session`
WHERE `session_id` = X'73706835707467733838386235303875686f6170637534346d75'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a3fsm_session const PRIMARY PRIMARY 194 const 1 Using index Status Duration Starting 0.15 ms checking permissions 0.01 ms Opening tables 0.42 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.06 ms Preparing 0.01 ms Executing 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.01 ms Updating status 0.07 ms Reset for next command 0.01 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 1.93 ms After last query: 0.24 ms Query memory: 0.004 MB Memory before query: 3.695 MB
INSERT INTO `a3fsm_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'73706835707467733838386235303875686f6170637534346d75', 1, 1719479241, 0, '', 0)EXPLAIN not possible on query: INSERT INTO `a3fsm_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'73706835707467733838386235303875686f6170637534346d75', 1, 1719479241, 0, '', 0)Status Duration Starting 0.15 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 for update 0.02 ms Update 0.12 ms Waiting for query cache lock 0.01 ms Update 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.11 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.04 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.07 ms Reset for next command 0.01 ms # Caller File and line number 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 3.34 ms After last query: 2.64 ms Query memory: 0.025 MB Memory before query: 3.929 MB Rows returned: 46
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `a3fsm_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a3fsm_extensions ALL extension NO INDEX KEY COULD BE USED NULL NULL 1 Using where Status Duration Starting 0.16 ms checking permissions 0.01 ms Opening tables 0.09 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.05 ms Optimizing 0.04 ms Statistics 0.10 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.87 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.01 ms Updating status 0.08 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Same as call in the line below. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 2.13 ms After last query: 2.50 ms Query memory: 0.021 MB Memory before query: 4.112 MB Rows returned: 5
SELECT id, rules
FROM `a3fsm_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a3fsm_viewlevels ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Status Duration Starting 0.13 ms checking permissions 0.01 ms Opening tables 0.34 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.02 ms Preparing 0.07 ms Executing 0.01 ms Sending data 0.06 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.01 ms Updating status 0.08 ms Reset for next command 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.67 ms After last query: 0.14 ms Query memory: 0.021 MB Memory before query: 4.124 MB Rows returned: 2
SELECT b.id
FROM a3fsm_usergroups AS a
LEFT JOIN a3fsm_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 1 Using where; Using index Status Duration Starting 0.19 ms checking permissions 0.01 ms Opening tables 0.12 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.11 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.08 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.01 ms Updating status 0.07 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 2.57 ms After last query: 0.77 ms Query memory: 0.031 MB Memory before query: 4.190 MB Rows returned: 114
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM a3fsm_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a3fsm_extensions ALL extension NO INDEX KEY COULD BE USED NULL NULL 1 Using where; Using filesort Status Duration Starting 0.14 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.05 ms Optimizing 0.04 ms Statistics 0.08 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 1.18 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.00 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.06 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:351 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:356 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.80 ms After last query: 6.24 ms Query memory: 0.021 MB Memory before query: 4.877 MB Rows returned: 0
SELECT `path`
FROM a3fsm_rsfirewall_ignored
WHERE `type`='ignore_folder' OR `type`='ignore_file'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a3fsm_rsfirewall_ignored ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where Status Duration Starting 0.16 ms checking permissions 0.01 ms Opening tables 0.32 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.03 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.06 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.00 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.07 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 11 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_rsfirewall/helpers/config.php:55 10 RSFirewallConfig->load() JROOT/administrator/components/com_rsfirewall/helpers/config.php:21 9 RSFirewallConfig->__construct() JROOT/administrator/components/com_rsfirewall/helpers/config.php:163 8 RSFirewallConfig::getInstance() JROOT/plugins/system/rsfirewall/rsfirewall.php:37 7 plgSystemRsfirewall->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.75 ms After last query: 0.08 ms Query memory: 0.021 MB Memory before query: 4.883 MB Rows returned: 0
SELECT `file`
FROM a3fsm_rsfirewall_hashes
WHERE `type`='protect'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a3fsm_rsfirewall_hashes ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where Status Duration Starting 0.14 ms checking permissions 0.01 ms Opening tables 0.39 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.03 ms Preparing 0.06 ms Executing 0.01 ms Sending data 0.22 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.01 ms Updating status 0.07 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 11 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_rsfirewall/helpers/config.php:62 10 RSFirewallConfig->load() JROOT/administrator/components/com_rsfirewall/helpers/config.php:21 9 RSFirewallConfig->__construct() JROOT/administrator/components/com_rsfirewall/helpers/config.php:163 8 RSFirewallConfig::getInstance() JROOT/plugins/system/rsfirewall/rsfirewall.php:37 7 plgSystemRsfirewall->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.74 ms After last query: 0.05 ms Query memory: 0.027 MB Memory before query: 4.889 MB Rows returned: 67
SELECT *
FROM a3fsm_rsfirewall_configurationid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a3fsm_rsfirewall_configuration ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Status Duration Starting 0.13 ms checking permissions 0.01 ms Opening tables 0.36 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.22 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.01 ms Updating status 0.07 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_rsfirewall/helpers/config.php:70 10 RSFirewallConfig->load() JROOT/administrator/components/com_rsfirewall/helpers/config.php:21 9 RSFirewallConfig->__construct() JROOT/administrator/components/com_rsfirewall/helpers/config.php:163 8 RSFirewallConfig::getInstance() JROOT/plugins/system/rsfirewall/rsfirewall.php:37 7 plgSystemRsfirewall->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 2.82 ms After last query: 3.90 ms Query memory: 0.024 MB Memory before query: 5.266 MB Rows returned: 10
SHOW FULL COLUMNS
FROM `a3fsm_rsfirewall_logs`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `a3fsm_rsfirewall_logs`Status Duration Starting 0.13 ms checking permissions 0.01 ms closing tables 0.01 ms Opening tables 0.78 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.00 ms Filling schema table 0.01 ms Opening tables 0.28 ms After opening tables 0.01 ms checking permissions 0.12 ms closing tables 0.01 ms Executing 0.00 ms Sending data 0.06 ms End of update loop 0.04 ms Query end 0.01 ms Commit 0.00 ms closing tables 0.00 ms Removing tmp table 0.28 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.07 ms Reset for next command 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 12 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_rsfirewall/tables/logs.php:38 11 RsfirewallTableLogs->__construct() JROOT/libraries/src/Table/Table.php:328 10 Joomla\CMS\Table\Table::getInstance() JROOT/administrator/components/com_rsfirewall/helpers/log.php:28 9 RSFirewallLogger->__construct() JROOT/administrator/components/com_rsfirewall/helpers/log.php:82 8 RSFirewallLogger::getInstance() JROOT/plugins/system/rsfirewall/rsfirewall.php:62 7 plgSystemRsfirewall->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 2.30 ms After last query: 43.44 ms Query memory: 0.023 MB Memory before query: 8.911 MB Rows returned: 27
SELECT *
FROM a3fsm_rsform_configid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a3fsm_rsform_config ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Status Duration Starting 0.16 ms checking permissions 0.01 ms Opening tables 0.32 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.02 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.00 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.07 ms Reset for next command 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_rsform/helpers/config.php:50 11 RSFormProConfig->load() JROOT/administrator/components/com_rsform/helpers/config.php:17 10 RSFormProConfig->__construct() JROOT/administrator/components/com_rsform/helpers/config.php:102 9 RSFormProConfig::getInstance() JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php:26 8 plgSystemRsformdeletesubmissions->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 6.35 ms After last query: 2.18 ms Query memory: 0.391 MB Memory before query: 9.159 MB Rows returned: 260
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 a3fsm_menu AS m
LEFT JOIN a3fsm_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 Extra 1 SIMPLE m ALL idx_client_id_parent_id_alias_language NO INDEX KEY COULD BE USED NULL NULL 1 Using where; Using filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 joomlapatch.m.component_id 1 Using where Status Duration Starting 0.22 ms checking permissions 0.01 ms Opening tables 0.42 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 Statistics 0.14 ms Preparing 0.05 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.03 ms Creating sort index 3.89 ms End of update loop 0.03 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 17 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 14 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:78 13 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 12 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:142 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:417 10 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 9 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:65 8 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 7 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:533 6 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 5 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/libraries/src/Application/CMSApplication.php:1141 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.32 ms After last query: 8.56 ms Query memory: 0.021 MB Memory before query: 10.747 MB Rows returned: 4
SELECT *
FROM a3fsm_rsfirewall_hashes
WHERE (`type`='3.10.12' OR `type`='protect')
AND (`flag`!='C' OR `flag` IS NULL)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a3fsm_rsfirewall_hashes ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where Status Duration Starting 0.17 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.05 ms Optimizing 0.03 ms Statistics 0.03 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.23 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.06 ms Reset for next command 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/plugins/system/rsfirewall/rsfirewall.php:1065 8 plgSystemRsfirewall->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.22 ms After last query: 0.65 ms Query memory: 0.021 MB Memory before query: 10.783 MB Rows returned: 1
SELECT *
FROM a3fsm_rsfirewall_snapshots
WHERE `type`='protect'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a3fsm_rsfirewall_snapshots ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where Status Duration Starting 0.09 ms checking permissions 0.01 ms Opening tables 0.34 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.02 ms Preparing 0.02 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 Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.05 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_rsfirewall/helpers/snapshot.php:49 9 RSFirewallSnapshot::get() JROOT/plugins/system/rsfirewall/rsfirewall.php:1088 8 plgSystemRsfirewall->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.12 ms After last query: 0.08 ms Query memory: 0.021 MB Memory before query: 10.789 MB Rows returned: 1
SELECT *
FROM `a3fsm_users`
WHERE `id` = '372'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a3fsm_users const PRIMARY PRIMARY 4 const 1 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.05 ms Optimizing 0.02 ms Statistics 0.08 ms Preparing 0.01 ms Unlocking tables 0.02 ms Preparing 0.02 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.01 ms Updating status 0.07 ms Reset for next command 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 9 JDatabaseDriver->loadObject() JROOT/plugins/system/rsfirewall/rsfirewall.php:1103 8 plgSystemRsfirewall->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.15 ms After last query: 0.07 ms Query memory: 0.021 MB Memory before query: 10.797 MB Rows returned: 1
SELECT group_id
FROM a3fsm_user_usergroup_map
WHERE `user_id`=372id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a3fsm_user_usergroup_map ref PRIMARY PRIMARY 4 const 1 Using index Status Duration Starting 0.10 ms checking permissions 0.01 ms Opening tables 0.30 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.07 ms Preparing 0.03 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 Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.06 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_rsfirewall/helpers/snapshot.php:70 9 RSFirewallSnapshot::modified() JROOT/plugins/system/rsfirewall/rsfirewall.php:1108 8 plgSystemRsfirewall->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.40 ms After last query: 0.07 ms Query memory: 0.022 MB Memory before query: 10.805 MB Rows returned: 3
SELECT `ip`,`reason`
FROM a3fsm_rsfirewall_lists
WHERE (`ip`='13.59.88.212' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%')
AND `type`='1'
AND `published`='1'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a3fsm_rsfirewall_lists ref published,type,ip published 1 const 1 Using where Status Duration Starting 0.13 ms checking permissions 0.01 ms Opening tables 0.29 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.05 ms Optimizing 0.08 ms Statistics 0.10 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.09 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.00 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.06 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/rsfirewall/rsfirewall.php:171 10 plgSystemRsfirewall->isListed() JROOT/plugins/system/rsfirewall/rsfirewall.php:150 9 plgSystemRsfirewall->isWhitelisted() JROOT/plugins/system/rsfirewall/rsfirewall.php:1124 8 plgSystemRsfirewall->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.01 ms After last query: 0.11 ms Query memory: 0.021 MB Memory before query: 10.811 MB Rows returned: 0
SELECT `ip`,`reason`
FROM a3fsm_rsfirewall_lists
WHERE (`ip`='13.59.88.212' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%')
AND `type`='0'
AND `published`='1'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a3fsm_rsfirewall_lists ref published,type,ip published 1 const 1 Using where Status Duration Starting 0.15 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.04 ms Optimizing 0.03 ms Statistics 0.08 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.08 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.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.05 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/rsfirewall/rsfirewall.php:171 10 plgSystemRsfirewall->isListed() JROOT/plugins/system/rsfirewall/rsfirewall.php:140 9 plgSystemRsfirewall->isBlacklisted() JROOT/plugins/system/rsfirewall/rsfirewall.php:1128 8 plgSystemRsfirewall->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.82 ms After last query: 0.63 ms Query memory: 0.021 MB Memory before query: 10.844 MB Rows returned: 3
SELECT id, home, template, s.params
FROM a3fsm_template_styles as s
LEFT JOIN a3fsm_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 Extra 1 SIMPLE s ref idx_template,idx_client_id,idx_client_id_home idx_client_id 1 const 1 1 SIMPLE e range element_clientid,element_folder_clientid,extension extension 82 NULL 1 Using index condition; Using where; Using join buffer (flat, BNL join) Status Duration Starting 0.12 ms checking permissions 0.01 ms Opening tables 0.33 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.14 ms Preparing 0.10 ms Executing 0.01 ms Sending data 0.23 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.00 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.06 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 10 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:1018 9 plgSystemEF4_JMFramework->getTemplateName() JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:209 8 plgSystemEF4_JMFramework->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.35 ms After last query: 8.72 ms Query memory: 0.024 MB Memory before query: 11.707 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `a3fsm_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a3fsm_extensions ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 Using index condition; Using where Status Duration Starting 0.15 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.04 ms Optimizing 0.03 ms Statistics 0.14 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.15 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.00 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.07 ms Reset for next command 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 18 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 17 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 14 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 13 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 12 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:294 8 plgSystemEF4_JMFramework->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.12 ms After last query: 0.12 ms Query memory: 0.006 MB Memory before query: 11.699 MB
UPDATE `a3fsm_extensions`
SET `params` = '{\"mediaversion\":\"b16c7cbc730fa208b2c8c46a332a7669\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN not possible on query: UPDATE `a3fsm_extensions` SET `params` = '{\"mediaversion\":\"b16c7cbc730fa208b2c8c46a332a7669\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.10 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.12 ms Updating 0.20 ms End of update loop 0.01 ms Waiting for query cache lock 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.10 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.08 ms Reset for next command 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 13 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 12 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:294 8 plgSystemEF4_JMFramework->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 2.23 ms After last query: 10.12 ms Query memory: 0.030 MB Memory before query: 12.652 MB Rows returned: 157
SHOW TABLES
EXPLAIN not possible on query: SHOW TABLESStatus Duration Starting 0.08 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.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Filling schema table 0.01 ms checking permissions 0.95 ms Executing 0.01 ms Sending data 0.10 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.00 ms closing tables 0.00 ms Removing tmp table 0.01 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.06 ms Reset for next command 0.01 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 16 JDatabaseDriver->loadAssocList() JROOT/plugins/system/chronog3_plg/chronog3/libs/joomla/database_adapter.php:91 15 G3\L\Joomla\DatabaseAdapter->loadAssocList() JROOT/plugins/system/chronog3_plg/chronog3/libs/joomla/database_adapter.php:62 14 G3\L\Joomla\DatabaseAdapter->getTablesList() JROOT/plugins/system/chronog3_plg/chronog3/libs/joomla/database_adapter.php:42 13 G3\L\Joomla\DatabaseAdapter->__construct() JROOT/plugins/system/chronog3_plg/chronog3/libs/database_object.php:29 12 G3\L\DatabaseObject::getInstance() JROOT/plugins/system/chronog3_plg/chronog3/libs/database.php:48 11 G3\L\Database::getInstance() JROOT/plugins/system/chronog3_plg/chronog3/libs/model.php:38 10 G3\L\Model->__construct() JROOT/plugins/system/chronog3_plg/chronog3/libs/extension.php:61 9 G3\L\Extension->settings() JROOT/plugins/system/chronog3_plg/chronog3_plg.php:56 8 PlgSystemChronog3_Plg->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.64 ms After last query: 0.84 ms Query memory: 0.022 MB Memory before query: 12.679 MB Rows returned: 1
SELECT `Extension`.`id` AS `Extension.id`, `Extension`.`name` AS `Extension.name`, `Extension`.`enabled` AS `Extension.enabled`, `Extension`.`ordering` AS `Extension.ordering`, `Extension`.`settings` AS `Extension.settings`
FROM `a3fsm_chronog3_extensions` AS `Extension`
WHERE `Extension`.`name` = 'chronoforms';id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE Extension ref name name 767 const 1 Using index condition Status Duration Starting 0.18 ms checking permissions 0.01 ms Opening tables 0.36 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.03 ms Executing 0.01 ms Sending data 0.09 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.00 ms closing tables 0.03 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.10 ms Reset for next command 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 12 JDatabaseDriver->loadAssoc() JROOT/plugins/system/chronog3_plg/chronog3/libs/joomla/database_adapter.php:80 11 G3\L\Joomla\DatabaseAdapter->loadAssoc() JROOT/plugins/system/chronog3_plg/chronog3/libs/model.php:1007 10 G3\L\Model->select() JROOT/plugins/system/chronog3_plg/chronog3/libs/extension.php:62 9 G3\L\Extension->settings() JROOT/plugins/system/chronog3_plg/chronog3_plg.php:56 8 PlgSystemChronog3_Plg->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.40 ms After last query: 2.13 ms Query memory: 0.021 MB Memory before query: 12.846 MB Rows returned: 1
SELECT `id`, `name`,`alias`, `use_feedburner`, `uri`, `feed_type`
FROM `a3fsm_obrss`
WHERE `published` = 1
AND `feeded` = 1
ORDER BY `ordering`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a3fsm_obrss ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where; Using filesort Status Duration Starting 0.12 ms checking permissions 0.01 ms Opening tables 0.31 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.05 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 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.00 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.06 ms Reset for next command 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/plugins/system/obrss/obrss.php:40 8 plgSystemobrss->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.19 ms After last query: 1.73 ms Query memory: 0.020 MB Memory before query: 12.970 MB Rows returned: 3
SELECT *
FROM a3fsm_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a3fsm_languages ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where; Using filesort Status Duration Starting 0.08 ms checking permissions 0.01 ms Opening tables 0.27 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.02 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.09 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.05 ms Reset for next command 0.01 ms # Caller File and line number 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 6 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 5 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 4 Joomla\CMS\Application\SiteApplication->getParams() JROOT/libraries/src/Application/SiteApplication.php:138 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 7.83 ms After last query: 3.03 ms Query memory: 0.028 MB Memory before query: 13.172 MB Rows returned: 46
SELECT `id`,`name`,`rules`,`parent_id`
FROM `a3fsm_assets`
WHERE `name` IN ('root.1','com_mailto','com_wrapper','com_admin','com_banners','com_cache','com_categories','com_checkin','com_contact','com_cpanel','com_installer','com_languages','com_login','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_templates','com_content','com_config','com_redirect','com_users','com_joomlaupdate','com_tags','com_contenthistory','com_ajax','com_postinstall','com_fields','com_associations','com_privacy','com_actionlogs','com_djimageslider','com_jce','com_ose_firewall','com_rsfirewall','com_dmhelper','com_obrss','com_djmediatools','com_djtabs','com_redj','com_chronoforms6','com_nobossajax','com_chronoforms7','com_googlesearch_cse','com_rsform')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a3fsm_assets ALL idx_asset_name NO INDEX KEY COULD BE USED NULL NULL 1 Using where Status Duration Starting 0.18 ms checking permissions 0.01 ms Opening tables 0.30 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.11 ms Optimizing 0.02 ms Statistics 0.25 ms Preparing 0.02 ms Executing 0.00 ms Sending data 5.86 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.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.07 ms Reset for next command 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 16 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 4.07 ms After last query: 0.18 ms Query memory: 0.302 MB Memory before query: 13.227 MB Rows returned: 2352
SELECT `id`,`name`,`rules`,`parent_id`
FROM `a3fsm_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a3fsm_assets ALL idx_asset_name,idx_parent_id NO INDEX KEY COULD BE USED NULL NULL 1 Using where Status Duration Starting 0.15 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.04 ms Optimizing 0.03 ms Statistics 0.12 ms Preparing 0.03 ms Executing 0.01 ms Sending data 2.54 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.00 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 16 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.67 ms After last query: 3.60 ms Query memory: 0.031 MB Memory before query: 15.233 MB Rows returned: 31
SHOW FULL COLUMNS
FROM `a3fsm_content`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `a3fsm_content`Status Duration Starting 0.04 ms checking permissions 0.00 ms closing tables 0.00 ms Opening tables 0.43 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Filling schema table 0.01 ms Opening tables 0.20 ms After opening tables 0.00 ms checking permissions 0.15 ms closing tables 0.01 ms Executing 0.00 ms Sending data 0.05 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Removing tmp table 0.16 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.04 ms Reset for next command 0.00 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 12 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Content.php:39 11 Joomla\CMS\Table\Content->__construct() JROOT/libraries/src/Table/Table.php:328 10 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_content/models/article.php:253 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.71 ms After last query: 2.33 ms Query memory: 0.005 MB Memory before query: 15.508 MB
UPDATE a3fsm_content
SET `hits` = (`hits` + 1)
WHERE `id` = '7537'EXPLAIN not possible on query: UPDATE a3fsm_content SET `hits` = (`hits` + 1) WHERE `id` = '7537'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.00 ms table lock 0.00 ms init for update 0.06 ms Updating 0.06 ms End of update loop 0.00 ms Waiting for query cache lock 0.00 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.03 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.06 ms Reset for next command 0.00 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1264 10 Joomla\CMS\Table\Table->hit() JROOT/components/com_content/models/article.php:254 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.36 ms After last query: 1.39 ms Query memory: 0.023 MB Memory before query: 15.620 MB Rows returned: 1
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.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 a3fsm_content AS a
INNER JOIN a3fsm_categories AS c
on c.id = a.catid
LEFT JOIN a3fsm_users AS u
on u.id = a.created_by
LEFT JOIN a3fsm_categories as parent
ON parent.id = c.parent_id
LEFT JOIN a3fsm_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 7537
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-06-27 09:07:21')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-06-27 09:07:21')
AND (a.state = 1 OR a.state =2)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY,idx_state,idx_catid PRIMARY 4 const 1 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 1 SIMPLE u const PRIMARY PRIMARY 4 const 1 1 SIMPLE parent const PRIMARY PRIMARY 4 const 1 1 SIMPLE v const PRIMARY PRIMARY 4 const 0 Unique row not found Status Duration Starting 0.15 ms checking permissions 0.01 ms Opening tables 0.34 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.06 ms Optimizing 0.04 ms Statistics 0.10 ms Preparing 0.00 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:151 12 ContentModelArticle->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/article/view.html.php:42 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.70 ms After last query: 1.40 ms Query memory: 0.022 MB Memory before query: 15.708 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `a3fsm_contentitem_tag_map` AS m
INNER JOIN `a3fsm_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 7537
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type NO INDEX KEY COULD BE USED NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 joomlapatch.m.tag_id 1 Using where Status Duration Starting 0.16 ms checking permissions 0.01 ms Opening tables 0.67 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.08 ms Optimizing 0.05 ms Statistics 0.10 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.04 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.00 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 11 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/views/article/view.html.php:184 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 2.52 ms After last query: 55.11 ms Query memory: 0.026 MB Memory before query: 21.092 MB Rows returned: 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 `a3fsm_categories` AS `s`
INNER JOIN `a3fsm_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 229
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c range cat_idx,idx_access,idx_left_right idx_access 4 NULL 1 Using index condition; Using where; Using filesort Status Duration Starting 0.29 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.14 ms Optimizing 0.06 ms Statistics 0.23 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.12 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.06 ms Creating sort index 0.55 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.02 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.07 ms Reset for next command 0.01 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 19 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 18 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203 17 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:140 16 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:194 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 5.04 ms After last query: 0.56 ms Query memory: 0.026 MB Memory before query: 21.141 MB Rows returned: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM a3fsm_fields AS a
LEFT JOIN `a3fsm_languages` AS l
ON l.lang_code = a.language
LEFT JOIN a3fsm_users AS uc
ON uc.id=a.checked_out
LEFT JOIN a3fsm_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN a3fsm_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN a3fsm_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `a3fsm_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (229,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; Using filesort 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 joomlapatch.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 joomlapatch.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 joomlapatch.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 joomlapatch.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 joomlapatch.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 joomlapatch.a.id 1 Using where; Using index; Distinct Status Duration Starting 0.28 ms checking permissions 0.01 ms Opening tables 1.05 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.18 ms Optimizing 0.08 ms Statistics 0.22 ms Preparing 0.09 ms Creating tmp table 0.09 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 1.28 ms Creating sort index 0.10 ms Removing tmp table 0.23 ms Creating sort index 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.00 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.07 ms Reset for next command 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 16 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.79 ms After last query: 14.71 ms Query memory: 0.021 MB Memory before query: 22.142 MB Rows returned: 9
SELECT id
FROM a3fsm_template_styles
ORDER BY idid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a3fsm_template_styles index NULL PRIMARY 4 NULL 1 Using index 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.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.09 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.00 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.09 ms Reset for next command 0.03 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:329 9 JMFTemplate->setup() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:126 8 JMFTemplate->__construct() JROOT/templates/jm-education/index.php:18 7 require JROOT/templates/jm-education/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 44.81 ms After last query: 9.09 ms Query memory: 0.247 MB Memory before query: 23.006 MB Rows returned: 255
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM a3fsm_modules AS m
LEFT JOIN a3fsm_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN a3fsm_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-06-27 09:07:21')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-06-27 09:07:21')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 101 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mm index PRIMARY PRIMARY 8 NULL 1 Using where; Using index; Using temporary; Using filesort 1 SIMPLE m eq_ref PRIMARY,published,newsfeeds PRIMARY 4 joomlapatch.mm.moduleid 1 Using where 1 SIMPLE e ALL element_clientid,element_folder_clientid NO INDEX KEY COULD BE USED NULL NULL 1 Using where; Using join buffer (flat, BNL join) Status Duration Starting 0.26 ms checking permissions 0.01 ms Opening tables 0.61 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.09 ms Optimizing 0.09 ms Statistics 0.16 ms Preparing 0.09 ms Creating tmp table 0.05 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 39.89 ms Creating sort index 0.72 ms Removing tmp table 0.47 ms Creating sort index 0.03 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.06 ms Reset for next command 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() Same as call in the line below. 17 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 16 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 15 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 14 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 13 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:601 12 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:476 11 JMFTemplate->countModules() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:469 10 JMFTemplate->checkModules() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1711 9 JMFTemplate->getAllColumnsClasses() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:191 8 JMFTemplate->__construct() JROOT/templates/jm-education/index.php:18 7 require JROOT/templates/jm-education/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.87 ms After last query: 12.65 ms Query memory: 0.031 MB Memory before query: 23.340 MB Rows returned: 16
SHOW FULL COLUMNS
FROM `a3fsm_djmt_albums`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `a3fsm_djmt_albums`Status Duration Starting 0.07 ms checking permissions 0.01 ms closing tables 0.00 ms Opening tables 0.42 ms After opening tables 0.02 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.02 ms Executing 0.00 ms Filling schema table 0.01 ms Opening tables 0.17 ms After opening tables 0.00 ms checking permissions 0.09 ms closing tables 0.01 ms Executing 0.00 ms Sending data 0.04 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Removing tmp table 0.16 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.04 ms Reset for next command 0.00 ms # Caller File and line number 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 24 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 23 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 22 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 21 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_djmediatools/tables/categories.php:32 20 DJMediatoolsTableCategories->__construct() JROOT/libraries/src/Table/Table.php:328 19 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_djmediatools/models/categories.php:171 18 DJMediatoolsModelCategories->getItem() JROOT/components/com_djmediatools/models/categories.php:208 17 DJMediatoolsModelCategories->getParams() JROOT/modules/mod_djmediatools/mod_djmediatools.php:43 16 include JROOT/modules/mod_djmediatools/mod_djmediatools.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 14 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780 13 JMFTemplate->renderModules() JROOT/templates/jm-education/tpl/blocks/main.php:38 12 include JROOT/templates/jm-education/tpl/blocks/main.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 11 JMFTemplate->renderBlock() JROOT/templates/jm-education/tpl/default.php:202 10 include JROOT/templates/jm-education/tpl/default.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 9 JMFTemplate->renderBlock() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714 8 JMFTemplate->renderScheme() JROOT/templates/jm-education/index.php:19 7 require JROOT/templates/jm-education/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.79 ms After last query: 0.14 ms Query memory: 0.027 MB Memory before query: 23.371 MB Rows returned: 1
SELECT *
FROM a3fsm_djmt_albums
WHERE `id` = '2'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a3fsm_djmt_albums const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.05 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.00 ms Unlocking tables 0.02 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.00 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 20 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 19 Joomla\CMS\Table\Table->load() JROOT/components/com_djmediatools/models/categories.php:174 18 DJMediatoolsModelCategories->getItem() JROOT/components/com_djmediatools/models/categories.php:208 17 DJMediatoolsModelCategories->getParams() JROOT/modules/mod_djmediatools/mod_djmediatools.php:43 16 include JROOT/modules/mod_djmediatools/mod_djmediatools.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 14 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780 13 JMFTemplate->renderModules() JROOT/templates/jm-education/tpl/blocks/main.php:38 12 include JROOT/templates/jm-education/tpl/blocks/main.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 11 JMFTemplate->renderBlock() JROOT/templates/jm-education/tpl/default.php:202 10 include JROOT/templates/jm-education/tpl/default.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 9 JMFTemplate->renderBlock() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714 8 JMFTemplate->renderScheme() JROOT/templates/jm-education/index.php:19 7 require JROOT/templates/jm-education/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.05 ms After last query: 1.96 ms Query memory: 0.026 MB Memory before query: 23.457 MB Rows returned: 1
SELECT manifest_cache
FROM a3fsm_extensions
WHERE element='com_djmediatools'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a3fsm_extensions ref element_clientid,element_folder_clientid element_clientid 402 const 1 Using index condition Status Duration Starting 0.10 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.08 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.00 ms Freeing items 0.01 ms Updating status 0.06 ms Reset for next command 0.01 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 19 JDatabaseDriver->loadResult() JROOT/components/com_djmediatools/helpers/helper.php:86 18 DJMediatoolsLayoutHelper->__construct() JROOT/components/com_djmediatools/helpers/helper.php:71 17 DJMediatoolsLayoutHelper::getInstance() JROOT/modules/mod_djmediatools/mod_djmediatools.php:53 16 include JROOT/modules/mod_djmediatools/mod_djmediatools.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 14 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780 13 JMFTemplate->renderModules() JROOT/templates/jm-education/tpl/blocks/main.php:38 12 include JROOT/templates/jm-education/tpl/blocks/main.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 11 JMFTemplate->renderBlock() JROOT/templates/jm-education/tpl/default.php:202 10 include JROOT/templates/jm-education/tpl/default.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 9 JMFTemplate->renderBlock() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714 8 JMFTemplate->renderScheme() JROOT/templates/jm-education/index.php:19 7 require JROOT/templates/jm-education/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.22 ms After last query: 0.14 ms Query memory: 0.027 MB Memory before query: 23.532 MB Rows returned: 2
SELECT a.*
FROM a3fsm_djmt_items AS a, a3fsm_djmt_albums AS c
WHERE a.catid = 2
AND a.catid = c.id
AND c.published = 1
AND a.published = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-06-27 09:07:21')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-06-27 09:07:21')
ORDER BY a.ordering ASC,a.ordering ASC
LIMIT 2id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 1 SIMPLE a ref catid catid 5 const,const 1 Using where; Using filesort Status Duration Starting 0.08 ms checking permissions 0.00 ms Opening tables 0.17 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.13 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.00 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/components/com_djmediatools/helpers/helper.php:369 18 DJMediatoolsLayoutHelper->getImagesFromDJMediatools() JROOT/components/com_djmediatools/helpers/helper.php:165 17 DJMediatoolsLayoutHelper->getSlides() JROOT/modules/mod_djmediatools/mod_djmediatools.php:60 16 include JROOT/modules/mod_djmediatools/mod_djmediatools.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 14 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780 13 JMFTemplate->renderModules() JROOT/templates/jm-education/tpl/blocks/main.php:38 12 include JROOT/templates/jm-education/tpl/blocks/main.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 11 JMFTemplate->renderBlock() JROOT/templates/jm-education/tpl/default.php:202 10 include JROOT/templates/jm-education/tpl/default.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 9 JMFTemplate->renderBlock() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714 8 JMFTemplate->renderScheme() JROOT/templates/jm-education/index.php:19 7 require JROOT/templates/jm-education/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.84 ms After last query: 1.53 ms Query memory: 0.067 MB Memory before query: 23.645 MB Rows returned: 1
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 c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
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, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
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,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM a3fsm_content AS a
LEFT JOIN a3fsm_categories AS c
ON c.id = a.catid
LEFT JOIN a3fsm_users AS ua
ON ua.id = a.created_by
LEFT JOIN a3fsm_users AS uam
ON uam.id = a.modified_by
LEFT JOIN a3fsm_categories as parent
ON parent.id = c.parent_id
LEFT JOIN a3fsm_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND a.id = 8202
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-06-27 09:07:21')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-06-27 09:07:21')
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY,idx_access,idx_catid PRIMARY 4 const 1 1 SIMPLE c const PRIMARY,idx_access PRIMARY 4 const 1 1 SIMPLE ua const PRIMARY PRIMARY 4 const 1 1 SIMPLE uam const PRIMARY PRIMARY 4 const 1 1 SIMPLE parent const PRIMARY PRIMARY 4 const 1 1 SIMPLE v const PRIMARY PRIMARY 4 const 0 Unique row not found Status Duration Starting 0.38 ms checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.13 ms Optimizing 0.08 ms Statistics 0.15 ms Preparing 0.01 ms Unlocking tables 0.02 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.10 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 23 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 22 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 21 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_content/models/articles.php:576 20 ContentModelArticles->getItems() JROOT/components/com_djmediatools/helpers/helper.php:457 19 DJMediatoolsLayoutHelper->getSlideLink() JROOT/components/com_djmediatools/helpers/helper.php:373 18 DJMediatoolsLayoutHelper->getImagesFromDJMediatools() JROOT/components/com_djmediatools/helpers/helper.php:165 17 DJMediatoolsLayoutHelper->getSlides() JROOT/modules/mod_djmediatools/mod_djmediatools.php:60 16 include JROOT/modules/mod_djmediatools/mod_djmediatools.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 14 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780 13 JMFTemplate->renderModules() JROOT/templates/jm-education/tpl/blocks/main.php:38 12 include JROOT/templates/jm-education/tpl/blocks/main.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 11 JMFTemplate->renderBlock() JROOT/templates/jm-education/tpl/default.php:202 10 include JROOT/templates/jm-education/tpl/default.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 9 JMFTemplate->renderBlock() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714 8 JMFTemplate->renderScheme() JROOT/templates/jm-education/index.php:19 7 require JROOT/templates/jm-education/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.92 ms After last query: 0.23 ms Query memory: 0.027 MB Memory before query: 23.697 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `a3fsm_contentitem_tag_map` AS m
INNER JOIN `a3fsm_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 8202
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type NO INDEX KEY COULD BE USED NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 joomlapatch.m.tag_id 1 Using where Status Duration Starting 0.09 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.08 ms Preparing 0.03 ms Executing 0.00 ms Sending data 0.05 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.01 ms # Caller File and line number 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 21 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 20 ContentModelArticles->getItems() JROOT/components/com_djmediatools/helpers/helper.php:457 19 DJMediatoolsLayoutHelper->getSlideLink() JROOT/components/com_djmediatools/helpers/helper.php:373 18 DJMediatoolsLayoutHelper->getImagesFromDJMediatools() JROOT/components/com_djmediatools/helpers/helper.php:165 17 DJMediatoolsLayoutHelper->getSlides() JROOT/modules/mod_djmediatools/mod_djmediatools.php:60 16 include JROOT/modules/mod_djmediatools/mod_djmediatools.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 14 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780 13 JMFTemplate->renderModules() JROOT/templates/jm-education/tpl/blocks/main.php:38 12 include JROOT/templates/jm-education/tpl/blocks/main.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 11 JMFTemplate->renderBlock() JROOT/templates/jm-education/tpl/default.php:202 10 include JROOT/templates/jm-education/tpl/default.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 9 JMFTemplate->renderBlock() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714 8 JMFTemplate->renderScheme() JROOT/templates/jm-education/index.php:19 7 require JROOT/templates/jm-education/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.37 ms After last query: 0.19 ms Query memory: 0.033 MB Memory before query: 23.710 MB Rows returned: 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 `a3fsm_categories` AS `s`
INNER JOIN `a3fsm_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 74
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c range cat_idx,idx_access,idx_left_right idx_access 4 NULL 1 Using index condition; Using where; Using filesort Status Duration Starting 0.14 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.07 ms Optimizing 0.03 ms Statistics 0.12 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.04 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.29 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.02 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.01 ms # Caller File and line number 33 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 32 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 31 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 30 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 29 ContentRouter->getCategorySegment() Same as call in the line below. 28 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 27 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 26 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 25 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 24 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 23 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 22 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 21 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 20 Joomla\CMS\Router\Route::_() JROOT/components/com_djmediatools/helpers/helper.php:464 19 DJMediatoolsLayoutHelper->getSlideLink() JROOT/components/com_djmediatools/helpers/helper.php:373 18 DJMediatoolsLayoutHelper->getImagesFromDJMediatools() JROOT/components/com_djmediatools/helpers/helper.php:165 17 DJMediatoolsLayoutHelper->getSlides() JROOT/modules/mod_djmediatools/mod_djmediatools.php:60 16 include JROOT/modules/mod_djmediatools/mod_djmediatools.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 14 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780 13 JMFTemplate->renderModules() JROOT/templates/jm-education/tpl/blocks/main.php:38 12 include JROOT/templates/jm-education/tpl/blocks/main.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 11 JMFTemplate->renderBlock() JROOT/templates/jm-education/tpl/default.php:202 10 include JROOT/templates/jm-education/tpl/default.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 9 JMFTemplate->renderBlock() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714 8 JMFTemplate->renderScheme() JROOT/templates/jm-education/index.php:19 7 require JROOT/templates/jm-education/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.66 ms After last query: 0.32 ms Query memory: 0.044 MB Memory before query: 23.712 MB Rows returned: 1
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 c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
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, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
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,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM a3fsm_content AS a
LEFT JOIN a3fsm_categories AS c
ON c.id = a.catid
LEFT JOIN a3fsm_users AS ua
ON ua.id = a.created_by
LEFT JOIN a3fsm_users AS uam
ON uam.id = a.modified_by
LEFT JOIN a3fsm_categories as parent
ON parent.id = c.parent_id
LEFT JOIN a3fsm_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND a.id = 8188
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-06-27 09:07:21')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-06-27 09:07:21')
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY,idx_access,idx_catid PRIMARY 4 const 1 1 SIMPLE c const PRIMARY,idx_access PRIMARY 4 const 1 1 SIMPLE ua const PRIMARY PRIMARY 4 const 1 1 SIMPLE uam const PRIMARY PRIMARY 4 const 1 1 SIMPLE parent const PRIMARY PRIMARY 4 const 1 1 SIMPLE v const PRIMARY PRIMARY 4 const 0 Unique row not found Status Duration Starting 0.41 ms checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.11 ms Optimizing 0.05 ms Statistics 0.13 ms Preparing 0.01 ms Unlocking tables 0.05 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.05 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.01 ms # Caller File and line number 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 23 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 22 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 21 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_content/models/articles.php:576 20 ContentModelArticles->getItems() JROOT/components/com_djmediatools/helpers/helper.php:457 19 DJMediatoolsLayoutHelper->getSlideLink() JROOT/components/com_djmediatools/helpers/helper.php:373 18 DJMediatoolsLayoutHelper->getImagesFromDJMediatools() JROOT/components/com_djmediatools/helpers/helper.php:165 17 DJMediatoolsLayoutHelper->getSlides() JROOT/modules/mod_djmediatools/mod_djmediatools.php:60 16 include JROOT/modules/mod_djmediatools/mod_djmediatools.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 14 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780 13 JMFTemplate->renderModules() JROOT/templates/jm-education/tpl/blocks/main.php:38 12 include JROOT/templates/jm-education/tpl/blocks/main.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 11 JMFTemplate->renderBlock() JROOT/templates/jm-education/tpl/default.php:202 10 include JROOT/templates/jm-education/tpl/default.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 9 JMFTemplate->renderBlock() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714 8 JMFTemplate->renderScheme() JROOT/templates/jm-education/index.php:19 7 require JROOT/templates/jm-education/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.25 ms After last query: 0.18 ms Query memory: 0.027 MB Memory before query: 23.753 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `a3fsm_contentitem_tag_map` AS m
INNER JOIN `a3fsm_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 8188
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type NO INDEX KEY COULD BE USED NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 joomlapatch.m.tag_id 1 Using where Status Duration Starting 0.17 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.07 ms Optimizing 0.05 ms Statistics 0.12 ms Preparing 0.05 ms Executing 0.01 ms Sending data 0.08 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.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.06 ms Reset for next command 0.00 ms # Caller File and line number 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 21 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 20 ContentModelArticles->getItems() JROOT/components/com_djmediatools/helpers/helper.php:457 19 DJMediatoolsLayoutHelper->getSlideLink() JROOT/components/com_djmediatools/helpers/helper.php:373 18 DJMediatoolsLayoutHelper->getImagesFromDJMediatools() JROOT/components/com_djmediatools/helpers/helper.php:165 17 DJMediatoolsLayoutHelper->getSlides() JROOT/modules/mod_djmediatools/mod_djmediatools.php:60 16 include JROOT/modules/mod_djmediatools/mod_djmediatools.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 14 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780 13 JMFTemplate->renderModules() JROOT/templates/jm-education/tpl/blocks/main.php:38 12 include JROOT/templates/jm-education/tpl/blocks/main.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 11 JMFTemplate->renderBlock() JROOT/templates/jm-education/tpl/default.php:202 10 include JROOT/templates/jm-education/tpl/default.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 9 JMFTemplate->renderBlock() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714 8 JMFTemplate->renderScheme() JROOT/templates/jm-education/index.php:19 7 require JROOT/templates/jm-education/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.85 ms After last query: 5.49 ms Query memory: 0.026 MB Memory before query: 23.873 MB Rows returned: 1
SELECT *
FROM a3fsm_djtabs_items
WHERE group_id = 2
AND published=1
AND access IN (1,1,5)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a3fsm_djtabs_items ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where; Using filesort Status Duration Starting 0.16 ms checking permissions 0.01 ms Opening tables 0.27 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.08 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.05 ms Reset for next command 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/components/com_djtabs/models/tabs.php:35 17 DJTabsModelTabs::getTabs() JROOT/modules/mod_djtabs/mod_djtabs.php:47 16 include JROOT/modules/mod_djtabs/mod_djtabs.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 14 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780 13 JMFTemplate->renderModules() JROOT/templates/jm-education/tpl/blocks/main.php:38 12 include JROOT/templates/jm-education/tpl/blocks/main.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 11 JMFTemplate->renderBlock() JROOT/templates/jm-education/tpl/default.php:202 10 include JROOT/templates/jm-education/tpl/default.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 9 JMFTemplate->renderBlock() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714 8 JMFTemplate->renderScheme() JROOT/templates/jm-education/index.php:19 7 require JROOT/templates/jm-education/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.06 ms After last query: 0.42 ms Query memory: 0.026 MB Memory before query: 23.891 MB Rows returned: 1
SELECT *
FROM a3fsm_djtabs_themes
WHERE id = 5id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a3fsm_djtabs_themes const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.08 ms checking permissions 0.01 ms Opening tables 0.16 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.02 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.00 ms Unlocking tables 0.02 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 18 JDatabaseDriver->loadObject() JROOT/components/com_djtabs/helpers/helper.php:32 17 DjTabsHelper::addThemeCSS() JROOT/modules/mod_djtabs/mod_djtabs.php:55 16 include JROOT/modules/mod_djtabs/mod_djtabs.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 14 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780 13 JMFTemplate->renderModules() JROOT/templates/jm-education/tpl/blocks/main.php:38 12 include JROOT/templates/jm-education/tpl/blocks/main.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 11 JMFTemplate->renderBlock() JROOT/templates/jm-education/tpl/default.php:202 10 include JROOT/templates/jm-education/tpl/default.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 9 JMFTemplate->renderBlock() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714 8 JMFTemplate->renderScheme() JROOT/templates/jm-education/index.php:19 7 require JROOT/templates/jm-education/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 2.26 ms After last query: 3.76 ms Query memory: 0.026 MB Memory before query: 24.009 MB Rows returned: 1
SELECT `MultipleSeparator`
FROM `a3fsm_rsform_forms`
WHERE `FormId` = '3'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a3fsm_rsform_forms const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.11 ms checking permissions 0.01 ms Opening tables 0.26 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.01 ms Unlocking tables 0.04 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.06 ms Reset for next command 0.02 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 20 JDatabaseDriver->loadResult() JROOT/administrator/components/com_rsform/helpers/rsform.php:3298 19 RSFormProHelper::getDirectoryFormProperties() JROOT/modules/mod_rsform_list/helper.php:311 18 ModRSFormListHelper->getComponents() JROOT/modules/mod_rsform_list/helper.php:184 17 ModRSFormListHelper->getSubmissions() JROOT/modules/mod_rsform_list/mod_rsform_list.php:40 16 include JROOT/modules/mod_rsform_list/mod_rsform_list.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 14 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780 13 JMFTemplate->renderModules() JROOT/templates/jm-education/tpl/blocks/main.php:55 12 include JROOT/templates/jm-education/tpl/blocks/main.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 11 JMFTemplate->renderBlock() JROOT/templates/jm-education/tpl/default.php:202 10 include JROOT/templates/jm-education/tpl/default.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 9 JMFTemplate->renderBlock() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714 8 JMFTemplate->renderScheme() JROOT/templates/jm-education/index.php:19 7 require JROOT/templates/jm-education/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.52 ms After last query: 0.10 ms Query memory: 0.027 MB Memory before query: 24.021 MB Rows returned: 4
SELECT `ComponentId`,`ComponentTypeId`
FROM `a3fsm_rsform_components`
WHERE `FormId` = '3'
ORDER BY `
Order` ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a3fsm_rsform_components ref FormId FormId 4 const 1 Using where; Using filesort Status Duration Starting 0.12 ms checking permissions 0.01 ms Opening tables 0.27 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.06 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.09 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.08 ms Reset for next command 0.01 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_rsform/helpers/rsform.php:3311 19 RSFormProHelper::getDirectoryFormProperties() JROOT/modules/mod_rsform_list/helper.php:311 18 ModRSFormListHelper->getComponents() JROOT/modules/mod_rsform_list/helper.php:184 17 ModRSFormListHelper->getSubmissions() JROOT/modules/mod_rsform_list/mod_rsform_list.php:40 16 include JROOT/modules/mod_rsform_list/mod_rsform_list.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 14 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780 13 JMFTemplate->renderModules() JROOT/templates/jm-education/tpl/blocks/main.php:55 12 include JROOT/templates/jm-education/tpl/blocks/main.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 11 JMFTemplate->renderBlock() JROOT/templates/jm-education/tpl/default.php:202 10 include JROOT/templates/jm-education/tpl/default.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 9 JMFTemplate->renderBlock() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714 8 JMFTemplate->renderScheme() JROOT/templates/jm-education/index.php:19 7 require JROOT/templates/jm-education/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.59 ms After last query: 0.07 ms Query memory: 0.031 MB Memory before query: 24.037 MB Rows returned: 63
SELECT `PropertyName`,`PropertyValue`,`ComponentId`
FROM `a3fsm_rsform_properties`
WHERE `ComponentId` IN (24,36,26,23)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a3fsm_rsform_properties range ComponentId ComponentId 4 NULL 1 Using index condition Status Duration Starting 0.08 ms checking permissions 0.01 ms Opening tables 0.24 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.06 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.31 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.05 ms Reset for next command 0.01 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_rsform/helpers/rsform.php:694 20 RSFormProHelper::getComponentProperties() JROOT/administrator/components/com_rsform/helpers/rsform.php:3313 19 RSFormProHelper::getDirectoryFormProperties() JROOT/modules/mod_rsform_list/helper.php:311 18 ModRSFormListHelper->getComponents() JROOT/modules/mod_rsform_list/helper.php:184 17 ModRSFormListHelper->getSubmissions() JROOT/modules/mod_rsform_list/mod_rsform_list.php:40 16 include JROOT/modules/mod_rsform_list/mod_rsform_list.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 14 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780 13 JMFTemplate->renderModules() JROOT/templates/jm-education/tpl/blocks/main.php:55 12 include JROOT/templates/jm-education/tpl/blocks/main.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 11 JMFTemplate->renderBlock() JROOT/templates/jm-education/tpl/default.php:202 10 include JROOT/templates/jm-education/tpl/default.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 9 JMFTemplate->renderBlock() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714 8 JMFTemplate->renderScheme() JROOT/templates/jm-education/index.php:19 7 require JROOT/templates/jm-education/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.86 ms After last query: 0.23 ms Query memory: 0.027 MB Memory before query: 24.086 MB Rows returned: 1
SELECT `FormId`
FROM `a3fsm_rsform_components`
WHERE `ComponentId`='24'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a3fsm_rsform_components const ComponentId ComponentId 4 const 1 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.04 ms Preparing 0.01 ms Unlocking tables 0.02 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.12 ms Reset for next command 0.01 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 21 JDatabaseDriver->loadResult() JROOT/administrator/components/com_rsform/helpers/rsform.php:709 20 RSFormProHelper::getComponentProperties() JROOT/administrator/components/com_rsform/helpers/rsform.php:3313 19 RSFormProHelper::getDirectoryFormProperties() JROOT/modules/mod_rsform_list/helper.php:311 18 ModRSFormListHelper->getComponents() JROOT/modules/mod_rsform_list/helper.php:184 17 ModRSFormListHelper->getSubmissions() JROOT/modules/mod_rsform_list/mod_rsform_list.php:40 16 include JROOT/modules/mod_rsform_list/mod_rsform_list.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 14 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780 13 JMFTemplate->renderModules() JROOT/templates/jm-education/tpl/blocks/main.php:55 12 include JROOT/templates/jm-education/tpl/blocks/main.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 11 JMFTemplate->renderBlock() JROOT/templates/jm-education/tpl/default.php:202 10 include JROOT/templates/jm-education/tpl/default.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 9 JMFTemplate->renderBlock() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714 8 JMFTemplate->renderScheme() JROOT/templates/jm-education/index.php:19 7 require JROOT/templates/jm-education/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.79 ms After last query: 0.06 ms Query memory: 0.010 MB Memory before query: 24.060 MB
SET SQL_BIG_SELECTS=1EXPLAIN not possible on query: SET SQL_BIG_SELECTS=1Status Duration Starting 0.07 ms Opening tables 0.01 ms After opening tables 0.01 ms Query end 0.01 ms Commit 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.06 ms Reset for next command 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/modules/mod_rsform_list/helper.php:187 17 ModRSFormListHelper->getSubmissions() JROOT/modules/mod_rsform_list/mod_rsform_list.php:40 16 include JROOT/modules/mod_rsform_list/mod_rsform_list.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 14 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780 13 JMFTemplate->renderModules() JROOT/templates/jm-education/tpl/blocks/main.php:55 12 include JROOT/templates/jm-education/tpl/blocks/main.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 11 JMFTemplate->renderBlock() JROOT/templates/jm-education/tpl/default.php:202 10 include JROOT/templates/jm-education/tpl/default.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 9 JMFTemplate->renderBlock() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714 8 JMFTemplate->renderScheme() JROOT/templates/jm-education/index.php:19 7 require JROOT/templates/jm-education/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.19 ms After last query: 0.19 ms Query memory: 0.026 MB Memory before query: 24.069 MB Rows returned: 1
SELECT *
FROM `a3fsm_rsform_submissions` AS `s`
WHERE `s`.`FormId` = '3'
ORDER BY `s`.`DateSubmitted` DESC
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ref FormId FormId 4 const 1 Using where; Using filesort Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.28 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.03 ms Optimizing 0.01 ms Statistics 0.05 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.13 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/modules/mod_rsform_list/helper.php:192 17 ModRSFormListHelper->getSubmissions() JROOT/modules/mod_rsform_list/mod_rsform_list.php:40 16 include JROOT/modules/mod_rsform_list/mod_rsform_list.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 14 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780 13 JMFTemplate->renderModules() JROOT/templates/jm-education/tpl/blocks/main.php:55 12 include JROOT/templates/jm-education/tpl/blocks/main.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 11 JMFTemplate->renderBlock() JROOT/templates/jm-education/tpl/default.php:202 10 include JROOT/templates/jm-education/tpl/default.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 9 JMFTemplate->renderBlock() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714 8 JMFTemplate->renderScheme() JROOT/templates/jm-education/index.php:19 7 require JROOT/templates/jm-education/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.71 ms After last query: 0.10 ms Query memory: 0.026 MB Memory before query: 24.086 MB Rows returned: 1
SELECT COUNT(*)
FROM `a3fsm_rsform_submissions` AS `s`
WHERE `s`.`FormId` = '3'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ref FormId FormId 4 const 1 Using index Status Duration Starting 0.06 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.07 ms Reset for next command 0.00 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 19 JDatabaseDriver->loadResult() JROOT/modules/mod_rsform_list/helper.php:177 18 ModRSFormListHelper->_getListCount() JROOT/modules/mod_rsform_list/helper.php:194 17 ModRSFormListHelper->getSubmissions() JROOT/modules/mod_rsform_list/mod_rsform_list.php:40 16 include JROOT/modules/mod_rsform_list/mod_rsform_list.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 14 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780 13 JMFTemplate->renderModules() JROOT/templates/jm-education/tpl/blocks/main.php:55 12 include JROOT/templates/jm-education/tpl/blocks/main.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 11 JMFTemplate->renderBlock() JROOT/templates/jm-education/tpl/default.php:202 10 include JROOT/templates/jm-education/tpl/default.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 9 JMFTemplate->renderBlock() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714 8 JMFTemplate->renderScheme() JROOT/templates/jm-education/index.php:19 7 require JROOT/templates/jm-education/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.66 ms After last query: 0.19 ms Query memory: 0.026 MB Memory before query: 24.097 MB Rows returned: 1
SELECT `MultipleSeparator`,`TextareaNewLines`
FROM `a3fsm_rsform_forms`
WHERE `FormId` = '3'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a3fsm_rsform_forms const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.05 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.00 ms Unlocking tables 0.02 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.00 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 19 JDatabaseDriver->loadObject() JROOT/modules/mod_rsform_list/helper.php:108 18 ModRSFormListHelper->getForm() JROOT/modules/mod_rsform_list/helper.php:211 17 ModRSFormListHelper->getSubmissions() JROOT/modules/mod_rsform_list/mod_rsform_list.php:40 16 include JROOT/modules/mod_rsform_list/mod_rsform_list.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 14 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780 13 JMFTemplate->renderModules() JROOT/templates/jm-education/tpl/blocks/main.php:55 12 include JROOT/templates/jm-education/tpl/blocks/main.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 11 JMFTemplate->renderBlock() JROOT/templates/jm-education/tpl/default.php:202 10 include JROOT/templates/jm-education/tpl/default.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 9 JMFTemplate->renderBlock() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714 8 JMFTemplate->renderScheme() JROOT/templates/jm-education/index.php:19 7 require JROOT/templates/jm-education/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.93 ms After last query: 0.06 ms Query memory: 0.026 MB Memory before query: 24.107 MB Rows returned: 5
SELECT *
FROM `a3fsm_rsform_submission_values`
WHERE `SubmissionId` IN ('5')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a3fsm_rsform_submission_values ref SubmissionId SubmissionId 4 const 1 Status Duration Starting 0.05 ms checking permissions 0.00 ms Opening tables 0.17 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.06 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.04 ms Reset for next command 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/modules/mod_rsform_list/helper.php:220 17 ModRSFormListHelper->getSubmissions() JROOT/modules/mod_rsform_list/mod_rsform_list.php:40 16 include JROOT/modules/mod_rsform_list/mod_rsform_list.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 14 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780 13 JMFTemplate->renderModules() JROOT/templates/jm-education/tpl/blocks/main.php:55 12 include JROOT/templates/jm-education/tpl/blocks/main.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 11 JMFTemplate->renderBlock() JROOT/templates/jm-education/tpl/default.php:202 10 include JROOT/templates/jm-education/tpl/default.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 9 JMFTemplate->renderBlock() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714 8 JMFTemplate->renderScheme() JROOT/templates/jm-education/index.php:19 7 require JROOT/templates/jm-education/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 2.37 ms After last query: 1.36 ms Query memory: 0.026 MB Memory before query: 24.197 MB Rows returned: 4
SELECT `p`.`PropertyValue` AS `name`,`c`.`ComponentId`,`c`.`ComponentTypeId`,`ct`.`ComponentTypeName`,`c`.`
Order`
FROM `a3fsm_rsform_properties` AS `p`
LEFT JOIN `a3fsm_rsform_components` AS `c`
ON (`c`.`ComponentId` = `p`.`ComponentId`)
LEFT JOIN `a3fsm_rsform_component_types` AS `ct`
ON (`ct`.`ComponentTypeId` = `c`.`ComponentTypeId`)
WHERE `c`.`FormId` = '3'
AND `p`.`PropertyName` = 'NAME'
AND `c`.`Published` = '1'
ORDER BY `c`.`
Order` ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c ref ComponentId,FormId FormId 4 const 1 Using where; Using temporary; Using filesort 1 SIMPLE p ALL ComponentId NO INDEX KEY COULD BE USED NULL NULL 1 Using where; Using join buffer (flat, BNL join) 1 SIMPLE ct eq_ref PRIMARY PRIMARY 4 joomlapatch.c.ComponentTypeId 1 Status Duration Starting 0.15 ms checking permissions 0.01 ms Opening tables 0.28 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.10 ms Preparing 0.03 ms Creating tmp table 0.02 ms Sorting result 0.02 ms Executing 0.00 ms Sending data 0.80 ms Creating sort index 0.04 ms Removing tmp table 0.16 ms Creating sort index 0.03 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.01 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_rsform/helpers/rsform.php:2561 18 RSFormProHelper::getComponents() JROOT/modules/mod_rsform_list/helper.php:318 17 ModRSFormListHelper->getHeaders() JROOT/modules/mod_rsform_list/mod_rsform_list.php:42 16 include JROOT/modules/mod_rsform_list/mod_rsform_list.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 14 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780 13 JMFTemplate->renderModules() JROOT/templates/jm-education/tpl/blocks/main.php:55 12 include JROOT/templates/jm-education/tpl/blocks/main.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 11 JMFTemplate->renderBlock() JROOT/templates/jm-education/tpl/default.php:202 10 include JROOT/templates/jm-education/tpl/default.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 9 JMFTemplate->renderBlock() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714 8 JMFTemplate->renderScheme() JROOT/templates/jm-education/index.php:19 7 require JROOT/templates/jm-education/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 2.84 ms After last query: 1.68 ms Query memory: 0.032 MB Memory before query: 24.287 MB Rows returned: 17
SHOW FULL COLUMNS
FROM `a3fsm_users`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `a3fsm_users`Status Duration Starting 0.12 ms checking permissions 0.01 ms closing tables 0.01 ms Opening tables 0.82 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.02 ms Preparing 0.05 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.00 ms Sending data 0.05 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Removing tmp table 0.15 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.05 ms Reset for next command 0.00 ms # Caller File and line number 29 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 28 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 27 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 26 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 25 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/User.php:41 24 Joomla\CMS\Table\User->__construct() JROOT/libraries/src/Table/Table.php:328 23 Joomla\CMS\Table\Table::getInstance() JROOT/libraries/src/User/User.php:603 22 Joomla\CMS\User\User::getTable() JROOT/libraries/src/User/User.php:877 21 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 20 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 19 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 18 Joomla\CMS\Factory::getUser() JROOT/modules/mod_rsform_list/helper.php:293 17 ModRSFormListHelper->getReplacements() JROOT/modules/mod_rsform_list/mod_rsform_list.php:53 16 include JROOT/modules/mod_rsform_list/mod_rsform_list.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 14 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780 13 JMFTemplate->renderModules() JROOT/templates/jm-education/tpl/blocks/main.php:55 12 include JROOT/templates/jm-education/tpl/blocks/main.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 11 JMFTemplate->renderBlock() JROOT/templates/jm-education/tpl/default.php:202 10 include JROOT/templates/jm-education/tpl/default.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 9 JMFTemplate->renderBlock() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714 8 JMFTemplate->renderScheme() JROOT/templates/jm-education/index.php:19 7 require JROOT/templates/jm-education/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.46 ms After last query: 0.16 ms Query memory: 0.028 MB Memory before query: 24.320 MB Rows returned: 1
SELECT *
FROM `a3fsm_users`
WHERE `id` = 732id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a3fsm_users const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.10 ms checking permissions 0.01 ms Opening tables 0.06 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.06 ms Preparing 0.01 ms Unlocking tables 0.03 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.06 ms Reset for next command 0.01 ms # Caller File and line number 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 23 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/User.php:87 22 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:880 21 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 20 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 19 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 18 Joomla\CMS\Factory::getUser() JROOT/modules/mod_rsform_list/helper.php:293 17 ModRSFormListHelper->getReplacements() JROOT/modules/mod_rsform_list/mod_rsform_list.php:53 16 include JROOT/modules/mod_rsform_list/mod_rsform_list.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 14 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780 13 JMFTemplate->renderModules() JROOT/templates/jm-education/tpl/blocks/main.php:55 12 include JROOT/templates/jm-education/tpl/blocks/main.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 11 JMFTemplate->renderBlock() JROOT/templates/jm-education/tpl/default.php:202 10 include JROOT/templates/jm-education/tpl/default.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 9 JMFTemplate->renderBlock() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714 8 JMFTemplate->renderScheme() JROOT/templates/jm-education/index.php:19 7 require JROOT/templates/jm-education/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.43 ms After last query: 2.90 ms Query memory: 0.028 MB Memory before query: 25.077 MB Rows returned: 1
SELECT `g`.`id`,`g`.`title`
FROM `a3fsm_usergroups` AS g
INNER JOIN `a3fsm_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 732id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref PRIMARY PRIMARY 4 const 1 Using index 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 joomlapatch.m.group_id 1 Status Duration Starting 0.09 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.04 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.04 ms Reset for next command 0.02 ms # Caller File and line number 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 23 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Table/User.php:112 22 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:880 21 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 20 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 19 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 18 Joomla\CMS\Factory::getUser() JROOT/modules/mod_rsform_list/helper.php:293 17 ModRSFormListHelper->getReplacements() JROOT/modules/mod_rsform_list/mod_rsform_list.php:53 16 include JROOT/modules/mod_rsform_list/mod_rsform_list.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 14 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780 13 JMFTemplate->renderModules() JROOT/templates/jm-education/tpl/blocks/main.php:55 12 include JROOT/templates/jm-education/tpl/blocks/main.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 11 JMFTemplate->renderBlock() JROOT/templates/jm-education/tpl/default.php:202 10 include JROOT/templates/jm-education/tpl/default.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699 9 JMFTemplate->renderBlock() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714 8 JMFTemplate->renderScheme() JROOT/templates/jm-education/index.php:19 7 require JROOT/templates/jm-education/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 2.28 ms After last query: 11.82 ms Query memory: 0.022 MB Memory before query: 26.147 MB Rows returned: 0
SELECT manifest_cache
FROM `a3fsm_extensions`
WHERE element = "lib_noboss"id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a3fsm_extensions ref element_clientid,element_folder_clientid element_clientid 402 const 1 Using index condition Status Duration Starting 0.11 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.01 ms Statistics 0.07 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.06 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.08 ms Reset for next command 0.00 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/libraries/noboss/util/loadextensionassets.php:52 12 NoBossUtilLoadExtensionAssets::getExtensionVersion() JROOT/libraries/noboss/util/loadextensionassets.php:37 11 NoBossUtilLoadExtensionAssets->__construct() JROOT/modules/mod_nobossnotices/mod_nobossnotices.php:44 10 include JROOT/modules/mod_nobossnotices/mod_nobossnotices.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 2.16 ms After last query: 0.96 ms Query memory: 0.022 MB Memory before query: 26.269 MB Rows returned: 1
SELECT manifest_cache
FROM `a3fsm_extensions`
WHERE element = "mod_nobossnotices"id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a3fsm_extensions ref element_clientid,element_folder_clientid element_clientid 402 const 1 Using index condition 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.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.11 ms Preparing 0.03 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.00 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.07 ms Reset for next command 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/libraries/noboss/util/loadextensionassets.php:52 12 NoBossUtilLoadExtensionAssets::getExtensionVersion() JROOT/libraries/noboss/util/loadextensionassets.php:37 11 NoBossUtilLoadExtensionAssets->__construct() JROOT/modules/mod_nobossnotices/mod_nobossnotices.php:516 10 include JROOT/modules/mod_nobossnotices/mod_nobossnotices.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.88 ms After last query: 1.81 ms Query memory: 0.023 MB Memory before query: 26.217 MB Rows returned: 1
SELECT *
FROM a3fsm_djmt_albums
WHERE `id` = '1'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a3fsm_djmt_albums const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.16 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.04 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.01 ms Unlocking tables 0.03 ms Preparing 0.02 ms Executing 0.00 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.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.06 ms Reset for next command 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 14 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 13 Joomla\CMS\Table\Table->load() JROOT/components/com_djmediatools/models/categories.php:174 12 DJMediatoolsModelCategories->getItem() JROOT/components/com_djmediatools/models/categories.php:208 11 DJMediatoolsModelCategories->getParams() JROOT/modules/mod_djmediatools/mod_djmediatools.php:43 10 include JROOT/modules/mod_djmediatools/mod_djmediatools.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.82 ms After last query: 0.63 ms Query memory: 0.023 MB Memory before query: 26.239 MB Rows returned: 1
SELECT a.*
FROM a3fsm_djmt_items AS a, a3fsm_djmt_albums AS c
WHERE a.catid = 1
AND a.catid = c.id
AND c.published = 1
AND a.published = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-06-27 09:07:21')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-06-27 09:07:21')
ORDER BY a.ordering ASC,a.ordering ASC
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 1 SIMPLE a ref catid catid 5 const,const 1 Using where; Using filesort Status Duration Starting 0.22 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.06 ms Statistics 0.13 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.06 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.03 ms Creating sort index 0.13 ms End of update loop 0.01 ms Query end 0.04 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.02 ms Updating status 0.07 ms Reset for next command 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/components/com_djmediatools/helpers/helper.php:369 13 DJMediatoolsLayoutHelper->getImagesFromDJMediatools() JROOT/components/com_djmediatools/helpers/helper.php:165 12 DJMediatoolsLayoutHelper->getSlides() JROOT/components/com_djmediatools/layouts/mslider/helper.php:33 11 MsliderDJMediatoolsLayoutHelper->getSlides() JROOT/modules/mod_djmediatools/mod_djmediatools.php:60 10 include JROOT/modules/mod_djmediatools/mod_djmediatools.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.67 ms After last query: 6.37 ms Query memory: 0.028 MB Memory before query: 26.557 MB Rows returned: 1
SELECT manifest_cache
FROM a3fsm_extensions
WHERE element='mod_djmegamenu'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a3fsm_extensions ref element_clientid,element_folder_clientid element_clientid 402 const 1 Using index condition Status Duration Starting 0.10 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.03 ms Executing 0.01 ms Sending data 0.07 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.06 ms Reset for next command 0.01 ms # Caller File and line number 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 24 JDatabaseDriver->loadResult() JROOT/modules/mod_djmegamenu/helpers/helper.php:404 23 modDJMMHelper::getVersion() JROOT/modules/mod_djmegamenu/mod_djmegamenu.php:84 22 include JROOT/modules/mod_djmegamenu/mod_djmegamenu.php JROOT/libraries/src/Helper/ModuleHelper.php:200 21 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 20 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/content/loadmodule/loadmodule.php:175 19 PlgContentLoadmodule->_load() JROOT/plugins/content/loadmodule/loadmodule.php:81 18 PlgContentLoadmodule->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 17 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 16 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 15 JHtmlContent::prepare() Same as call in the line below. 14 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 13 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:111 12 Joomla\CMS\HTML\HTMLHelper::_() JROOT/modules/mod_tabbed_offcanvas/tmpl/default.php:118 11 require JROOT/modules/mod_tabbed_offcanvas/tmpl/default.php JROOT/modules/mod_tabbed_offcanvas/mod_tabbed_offcanvas.php:147 10 include JROOT/modules/mod_tabbed_offcanvas/mod_tabbed_offcanvas.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 11.38 ms After last query: 14.10 ms Query memory: 0.055 MB Memory before query: 26.748 MB Rows returned: 5
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 c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
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, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
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,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM a3fsm_content AS a
LEFT JOIN a3fsm_categories AS c
ON c.id = a.catid
LEFT JOIN a3fsm_users AS ua
ON ua.id = a.created_by
LEFT JOIN a3fsm_users AS uam
ON uam.id = a.modified_by
LEFT JOIN a3fsm_categories as parent
ON parent.id = c.parent_id
LEFT JOIN a3fsm_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.catid IN (74)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-06-27 09:07:21')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-06-27 09:07:21')
ORDER BY publish_up DESC
LIMIT 5id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY,idx_access PRIMARY 4 const 1 1 SIMPLE a ref idx_access,idx_state,idx_catid idx_state 1 const 1 Using where; Using filesort 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 joomlapatch.a.created_by 1 Using where 1 SIMPLE uam eq_ref PRIMARY PRIMARY 4 joomlapatch.a.modified_by 1 Using where 1 SIMPLE parent eq_ref PRIMARY PRIMARY 4 const 1 Using where 1 SIMPLE v eq_ref PRIMARY PRIMARY 4 joomlapatch.a.id 1 Using where Status Duration Starting 0.46 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.21 ms Optimizing 0.10 ms Statistics 0.25 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.08 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.05 ms Creating sort index 8.94 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.00 ms closing tables 0.02 ms Starting cleanup 0.00 ms Freeing items 0.02 ms Updating status 0.05 ms Reset for next command 0.01 ms # Caller File and line number 31 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 30 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 29 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 28 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_content/models/articles.php:576 27 ContentModelArticles->getItems() JROOT/modules/mod_jm_articles_category/helper.php:228 26 ModJMArticlesCategoryHelper::getList() Same as call in the line below. 25 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 24 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:566 23 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/modules/mod_jm_articles_category/mod_jm_articles_category.php:72 22 include JROOT/modules/mod_jm_articles_category/mod_jm_articles_category.php JROOT/libraries/src/Helper/ModuleHelper.php:200 21 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 20 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/content/loadmodule/loadmodule.php:175 19 PlgContentLoadmodule->_load() JROOT/plugins/content/loadmodule/loadmodule.php:81 18 PlgContentLoadmodule->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 17 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 16 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 15 JHtmlContent::prepare() Same as call in the line below. 14 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 13 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:111 12 Joomla\CMS\HTML\HTMLHelper::_() JROOT/modules/mod_tabbed_offcanvas/tmpl/default.php:118 11 require JROOT/modules/mod_tabbed_offcanvas/tmpl/default.php JROOT/modules/mod_tabbed_offcanvas/mod_tabbed_offcanvas.php:147 10 include JROOT/modules/mod_tabbed_offcanvas/mod_tabbed_offcanvas.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.15 ms After last query: 0.27 ms Query memory: 0.029 MB Memory before query: 26.822 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `a3fsm_contentitem_tag_map` AS m
INNER JOIN `a3fsm_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 8207
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type NO INDEX KEY COULD BE USED NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 joomlapatch.m.tag_id 1 Using where Status Duration Starting 0.09 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.04 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.06 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.00 ms # Caller File and line number 30 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 29 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 28 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 27 ContentModelArticles->getItems() JROOT/modules/mod_jm_articles_category/helper.php:228 26 ModJMArticlesCategoryHelper::getList() Same as call in the line below. 25 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 24 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:566 23 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/modules/mod_jm_articles_category/mod_jm_articles_category.php:72 22 include JROOT/modules/mod_jm_articles_category/mod_jm_articles_category.php JROOT/libraries/src/Helper/ModuleHelper.php:200 21 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 20 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/content/loadmodule/loadmodule.php:175 19 PlgContentLoadmodule->_load() JROOT/plugins/content/loadmodule/loadmodule.php:81 18 PlgContentLoadmodule->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 17 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 16 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 15 JHtmlContent::prepare() Same as call in the line below. 14 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 13 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:111 12 Joomla\CMS\HTML\HTMLHelper::_() JROOT/modules/mod_tabbed_offcanvas/tmpl/default.php:118 11 require JROOT/modules/mod_tabbed_offcanvas/tmpl/default.php JROOT/modules/mod_tabbed_offcanvas/mod_tabbed_offcanvas.php:147 10 include JROOT/modules/mod_tabbed_offcanvas/mod_tabbed_offcanvas.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.11 ms After last query: 0.48 ms Query memory: 0.029 MB Memory before query: 26.845 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `a3fsm_contentitem_tag_map` AS m
INNER JOIN `a3fsm_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 8206
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type NO INDEX KEY COULD BE USED NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 joomlapatch.m.tag_id 1 Using where Status Duration Starting 0.07 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.04 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.00 ms # Caller File and line number 30 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 29 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 28 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 27 ContentModelArticles->getItems() JROOT/modules/mod_jm_articles_category/helper.php:228 26 ModJMArticlesCategoryHelper::getList() Same as call in the line below. 25 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 24 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:566 23 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/modules/mod_jm_articles_category/mod_jm_articles_category.php:72 22 include JROOT/modules/mod_jm_articles_category/mod_jm_articles_category.php JROOT/libraries/src/Helper/ModuleHelper.php:200 21 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 20 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/content/loadmodule/loadmodule.php:175 19 PlgContentLoadmodule->_load() JROOT/plugins/content/loadmodule/loadmodule.php:81 18 PlgContentLoadmodule->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 17 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 16 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 15 JHtmlContent::prepare() Same as call in the line below. 14 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 13 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:111 12 Joomla\CMS\HTML\HTMLHelper::_() JROOT/modules/mod_tabbed_offcanvas/tmpl/default.php:118 11 require JROOT/modules/mod_tabbed_offcanvas/tmpl/default.php JROOT/modules/mod_tabbed_offcanvas/mod_tabbed_offcanvas.php:147 10 include JROOT/modules/mod_tabbed_offcanvas/mod_tabbed_offcanvas.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.96 ms After last query: 0.27 ms Query memory: 0.029 MB Memory before query: 26.869 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `a3fsm_contentitem_tag_map` AS m
INNER JOIN `a3fsm_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 8205
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type NO INDEX KEY COULD BE USED NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 joomlapatch.m.tag_id 1 Using where Status Duration Starting 0.07 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.04 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.00 ms # Caller File and line number 30 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 29 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 28 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 27 ContentModelArticles->getItems() JROOT/modules/mod_jm_articles_category/helper.php:228 26 ModJMArticlesCategoryHelper::getList() Same as call in the line below. 25 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 24 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:566 23 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/modules/mod_jm_articles_category/mod_jm_articles_category.php:72 22 include JROOT/modules/mod_jm_articles_category/mod_jm_articles_category.php JROOT/libraries/src/Helper/ModuleHelper.php:200 21 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 20 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/content/loadmodule/loadmodule.php:175 19 PlgContentLoadmodule->_load() JROOT/plugins/content/loadmodule/loadmodule.php:81 18 PlgContentLoadmodule->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 17 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 16 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 15 JHtmlContent::prepare() Same as call in the line below. 14 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 13 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:111 12 Joomla\CMS\HTML\HTMLHelper::_() JROOT/modules/mod_tabbed_offcanvas/tmpl/default.php:118 11 require JROOT/modules/mod_tabbed_offcanvas/tmpl/default.php JROOT/modules/mod_tabbed_offcanvas/mod_tabbed_offcanvas.php:147 10 include JROOT/modules/mod_tabbed_offcanvas/mod_tabbed_offcanvas.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.82 ms After last query: 0.26 ms Query memory: 0.029 MB Memory before query: 26.892 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `a3fsm_contentitem_tag_map` AS m
INNER JOIN `a3fsm_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 8204
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type NO INDEX KEY COULD BE USED NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 joomlapatch.m.tag_id 1 Using where Status Duration Starting 0.06 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.05 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.00 ms # Caller File and line number 30 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 29 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 28 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 27 ContentModelArticles->getItems() JROOT/modules/mod_jm_articles_category/helper.php:228 26 ModJMArticlesCategoryHelper::getList() Same as call in the line below. 25 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 24 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:566 23 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/modules/mod_jm_articles_category/mod_jm_articles_category.php:72 22 include JROOT/modules/mod_jm_articles_category/mod_jm_articles_category.php JROOT/libraries/src/Helper/ModuleHelper.php:200 21 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 20 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/content/loadmodule/loadmodule.php:175 19 PlgContentLoadmodule->_load() JROOT/plugins/content/loadmodule/loadmodule.php:81 18 PlgContentLoadmodule->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 17 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 16 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 15 JHtmlContent::prepare() Same as call in the line below. 14 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 13 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:111 12 Joomla\CMS\HTML\HTMLHelper::_() JROOT/modules/mod_tabbed_offcanvas/tmpl/default.php:118 11 require JROOT/modules/mod_tabbed_offcanvas/tmpl/default.php JROOT/modules/mod_tabbed_offcanvas/mod_tabbed_offcanvas.php:147 10 include JROOT/modules/mod_tabbed_offcanvas/mod_tabbed_offcanvas.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.91 ms After last query: 0.18 ms Query memory: 0.029 MB Memory before query: 26.916 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `a3fsm_contentitem_tag_map` AS m
INNER JOIN `a3fsm_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 8203
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type NO INDEX KEY COULD BE USED NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 joomlapatch.m.tag_id 1 Using where Status Duration Starting 0.07 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.05 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.04 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.00 ms # Caller File and line number 30 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 29 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 28 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 27 ContentModelArticles->getItems() JROOT/modules/mod_jm_articles_category/helper.php:228 26 ModJMArticlesCategoryHelper::getList() Same as call in the line below. 25 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 24 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:566 23 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/modules/mod_jm_articles_category/mod_jm_articles_category.php:72 22 include JROOT/modules/mod_jm_articles_category/mod_jm_articles_category.php JROOT/libraries/src/Helper/ModuleHelper.php:200 21 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 20 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/content/loadmodule/loadmodule.php:175 19 PlgContentLoadmodule->_load() JROOT/plugins/content/loadmodule/loadmodule.php:81 18 PlgContentLoadmodule->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 17 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 16 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 15 JHtmlContent::prepare() Same as call in the line below. 14 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 13 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:111 12 Joomla\CMS\HTML\HTMLHelper::_() JROOT/modules/mod_tabbed_offcanvas/tmpl/default.php:118 11 require JROOT/modules/mod_tabbed_offcanvas/tmpl/default.php JROOT/modules/mod_tabbed_offcanvas/mod_tabbed_offcanvas.php:147 10 include JROOT/modules/mod_tabbed_offcanvas/mod_tabbed_offcanvas.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
52 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
8 × SELECT `m`.`tag_id`,`t`.*
FROM `a3fsm_contentitem_tag_map` AS m
INNER JOIN `a3fsm_tags` AS t
ON `m`.`tag_id` = `t`.`id`3 × 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 c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
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, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
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,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM a3fsm_content AS a
LEFT JOIN a3fsm_categories AS c
ON c.id = a.catid
LEFT JOIN a3fsm_users AS ua
ON ua.id = a.created_by
LEFT JOIN a3fsm_users AS uam
ON uam.id = a.modified_by
LEFT JOIN a3fsm_categories as parent
ON parent.id = c.parent_id
LEFT JOIN a3fsm_content_rating AS v
ON a.id = v.content_id2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `a3fsm_extensions`2 × SELECT *
FROM `a3fsm_users`2 × SELECT `ip`,`reason`
FROM a3fsm_rsfirewall_lists2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `a3fsm_assets`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 `a3fsm_categories` AS `s`
INNER JOIN `a3fsm_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)2 × SELECT *
FROM a3fsm_djmt_albums2 × SELECT manifest_cache
FROM a3fsm_extensions2 × SELECT a.*
FROM a3fsm_djmt_items AS a, a3fsm_djmt_albums AS c2 × SELECT manifest_cache
FROM `a3fsm_extensions`1 × SELECT `session_id`
FROM `a3fsm_session`1 × SELECT id, rules
FROM `a3fsm_viewlevels1 × SELECT b.id
FROM a3fsm_usergroups AS a
LEFT JOIN a3fsm_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM a3fsm_extensions1 × SELECT `path`
FROM a3fsm_rsfirewall_ignored1 × SELECT `file`
FROM a3fsm_rsfirewall_hashes1 × SELECT *
FROM a3fsm_rsfirewall_configuratio1 × SELECT *
FROM a3fsm_rsform_confi1 × 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 a3fsm_menu AS m
LEFT JOIN a3fsm_extensions AS e
ON m.component_id = e.extension_id1 × SELECT *
FROM a3fsm_rsfirewall_hashes1 × SELECT *
FROM a3fsm_rsfirewall_snapshots1 × SELECT group_id
FROM a3fsm_user_usergroup_map1 × SELECT id, home, template, s.params
FROM a3fsm_template_styles as s
LEFT JOIN a3fsm_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT `Extension`.`id` AS `Extension.id`, `Extension`.`name` AS `Extension.name`, `Extension`.`enabled` AS `Extension.enabled`, `Extension`.`ordering` AS `Extension.ordering`, `Extension`.`settings` AS `Extension.settings`
FROM `a3fsm_chronog3_extensions` AS `Extension`1 × SELECT `id`, `name`,`alias`, `use_feedburner`, `uri`, `feed_type`
FROM `a3fsm_obrss`1 × SELECT *
FROM a3fsm_languages1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.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 a3fsm_content AS a
INNER JOIN a3fsm_categories AS c
on c.id = a.catid
LEFT JOIN a3fsm_users AS u
on u.id = a.created_by
LEFT JOIN a3fsm_categories as parent
ON parent.id = c.parent_id
LEFT JOIN a3fsm_content_rating AS v
ON a.id = v.content_id1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM a3fsm_fields AS a
LEFT JOIN `a3fsm_languages` AS l
ON l.lang_code = a.language
LEFT JOIN a3fsm_users AS uc
ON uc.id=a.checked_out
LEFT JOIN a3fsm_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN a3fsm_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN a3fsm_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `a3fsm_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT id
FROM a3fsm_template_styles1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM a3fsm_modules AS m
LEFT JOIN a3fsm_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN a3fsm_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT *
FROM a3fsm_djtabs_items1 × SELECT *
FROM a3fsm_djtabs_themes1 × SELECT `MultipleSeparator`
FROM `a3fsm_rsform_forms`1 × SELECT `ComponentId`,`ComponentTypeId`
FROM `a3fsm_rsform_components`1 × SELECT `PropertyName`,`PropertyValue`,`ComponentId`
FROM `a3fsm_rsform_properties`1 × SELECT `FormId`
FROM `a3fsm_rsform_components`1 × SELECT *
FROM `a3fsm_rsform_submissions` AS `s`1 × SELECT COUNT(*)
FROM `a3fsm_rsform_submissions` AS `s`1 × SELECT `MultipleSeparator`,`TextareaNewLines`
FROM `a3fsm_rsform_forms`1 × SELECT *
FROM `a3fsm_rsform_submission_values`1 × SELECT `p`.`PropertyValue` AS `name`,`c`.`ComponentId`,`c`.`ComponentTypeId`,`ct`.`ComponentTypeName`,`c`.`
Order`
FROM `a3fsm_rsform_properties` AS `p`
LEFT JOIN `a3fsm_rsform_components` AS `c`
ON (`c`.`ComponentId` = `p`.`ComponentId`)
LEFT JOIN `a3fsm_rsform_component_types` AS `ct`
ON (`ct`.`ComponentTypeId` = `c`.`ComponentTypeId`)1 × SELECT `g`.`id`,`g`.`title`
FROM `a3fsm_usergroups` AS g
INNER JOIN `a3fsm_user_usergroup_map` AS m
ON m.group_id = g.id
OTHER Tables:
1 × INSERT INTO `a3fsm_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'73706835707467733838386235303875686f6170637534346d75', 1, 1719479241, 0, '', 01 × SHOW FULL COLUMNS
FROM `a3fsm_rsfirewall_logs1 × UPDATE `a3fsm_extensions`
SET `params` = '{\"mediaversion\":\"b16c7cbc730fa208b2c8c46a332a7669\"}'1 × SHOW TABLE
1 × SHOW FULL COLUMNS
FROM `a3fsm_content1 × UPDATE a3fsm_content
SET `hits` = (`hits` + 1)1 × SHOW FULL COLUMNS
FROM `a3fsm_djmt_albums1 ×
SET SQL_BIG_SELECTS=1 × SHOW FULL COLUMNS
FROM `a3fsm_users