Vol. 52, No. 03 ......................... March 2025
* Club Meeting *
Tuesday Mar 11, 2025 7:00 PM CDT
Tangi EOC
114 N Laurel St. Amite Louisiana 70422
Meet & Greet Over Food & Drinks (5 PM to 7 PM)
LaCareta
122 SW Central Ave, Amite Louisiana 70422
Vol. 52, No. 02 ......................... February 2025
* Club Meeting *
Tuesday Feb 11, 2025 7:00 PM CDT
Location: Ponchatoula Community Center
300 N 5th St., Ponchatoula LA 70454
Meet & Greet Over Food & Drinks (5 PM to 7 PM)
Millside
810 SW Railroad ave. Ponchatoula Louisiana 70454
Vol. 52, No. 01 ......................... January 2025
* Club Meeting *
Tuesday Jan 14, 2025 7:00 PM CDT
Location: Ponchatoula Community Center
300 N 5th St., Ponchatoula LA 70454
May Meet & Greet Over Food & Drinks (5 PM to 7 PM)
Joes Italian
1625 US 51 Ponchatoula Louisiana 70454
Page 1 of 29
- You are here:
- Home
Older Posts
Popular Tags
Photo Gallery - Categories
Photo Albums
Most Read Posts
Joomla! Debug Console
{ "__default": { "session": { "counter": 1, "timer": { "start": 1743558127, "last": 1743558127, "now": 1743558127 }, "client": { "forwarded": "3.144.158.54" }, "token": "tIyytvhoGQ8L1SfOEOGn9pv3LA6I3mSe" }, "registry": { "com_attachments": { "current_url": "&return=aHR0cHM6Ly9jbXNkZXYuc2VsYXJjLm9yZy8%2F" } }, "user": { "id": 0, "name": null, "username": null, "email": null, "password": null, "password_clear": "", "block": null, "sendEmail": 0, "registerDate": null, "lastvisitDate": null, "activation": null, "params": null, "groups": [], "guest": 1, "lastResetTime": null, "resetCount": null, "requireReset": null, "aid": 0 } } }
Time
Memory
Time: 9.24 ms / 9.24 ms Memory: 0.403 MB / 0.74 MB Application: afterLoad
Time: 58.47 ms / 67.71 ms Memory: 1.154 MB / 1.89 MB Application: afterInitialise
Time: 13.94 ms / 81.64 ms Memory: 0.437 MB / 2.33 MB Application: Before Access::preloadComponents (all components)
Time: 3.13 ms / 84.77 ms Memory: 0.061 MB / 2.39 MB Application: After Access::preloadComponents (all components)
Time: 0.23 ms / 85.00 ms Memory: -0.002 MB / 2.39 MB Application: Before Access::getAssetRules (id:16 name:com_menus)
Time: 0.86 ms / 85.85 ms Memory: 0.011 MB / 2.40 MB Application: After Access::getAssetRules (id:16 name:com_menus)
Time: 0.14 ms / 86.00 ms Memory: -0.001 MB / 2.40 MB Application: afterRoute
Time: 6.52 ms / 92.52 ms Memory: 0.053 MB / 2.45 MB Application: beforeRenderComponent com_content
Time: 6.21 ms / 98.73 ms Memory: 0.188 MB / 2.64 MB Application: Before Access::preloadPermissions (com_content)
Time: 2.55 ms / 101.27 ms Memory: 0.143 MB / 2.78 MB Application: After Access::preloadPermissions (com_content)
Time: 0.06 ms / 101.34 ms Memory: -0.011 MB / 2.77 MB Application: Before Access::getAssetRules (id:35 name:com_content.category.9)
Time: 0.22 ms / 101.55 ms Memory: 0.009 MB / 2.78 MB Application: After Access::getAssetRules (id:35 name:com_content.category.9)
Time: 12.59 ms / 114.14 ms Memory: 0.068 MB / 2.85 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Time: 0.08 ms / 114.23 ms Memory: 0.002 MB / 2.85 MB Application: After Access::getAssetRules (id:8 name:com_content)
Time: 49.35 ms / 163.57 ms Memory: 0.658 MB / 3.51 MB Application: Before Access::getAssetRules (id:977 name:com_content.article.126)
Time: 0.05 ms / 163.62 ms Memory: 0.002 MB / 3.51 MB Application: After Access::getAssetRules (id:977 name:com_content.article.126)
Time: 0.92 ms / 164.54 ms Memory: 0.019 MB / 3.53 MB Application: Before Access::getAssetRules (id:58 name:com_attachments)
Time: 0.14 ms / 164.67 ms Memory: 0.010 MB / 3.54 MB Application: After Access::getAssetRules (id:58 name:com_attachments)
Time: 0.11 ms / 164.78 ms Memory: 0.001 MB / 3.54 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Time: 0.03 ms / 164.81 ms Memory: 0.002 MB / 3.54 MB Application: After Access::getAssetRules (id:1 name:root.1)
Time: 6.91 ms / 171.72 ms Memory: 0.039 MB / 3.58 MB Application: Before Access::getAssetRules (id:985 name:com_content.article.134)
Time: 0.07 ms / 171.79 ms Memory: 0.002 MB / 3.58 MB Application: After Access::getAssetRules (id:985 name:com_content.article.134)
Time: 6.66 ms / 178.45 ms Memory: 0.019 MB / 3.60 MB Application: Before Access::getAssetRules (id:984 name:com_content.article.133)
Time: 0.05 ms / 178.49 ms Memory: 0.002 MB / 3.60 MB Application: After Access::getAssetRules (id:984 name:com_content.article.133)
Time: 6.63 ms / 185.12 ms Memory: 0.019 MB / 3.62 MB Application: Before Access::getAssetRules (id:983 name:com_content.article.132)
Time: 0.05 ms / 185.17 ms Memory: 0.002 MB / 3.62 MB Application: After Access::getAssetRules (id:983 name:com_content.article.132)
Time: 10.73 ms / 195.90 ms Memory: 0.046 MB / 3.67 MB Application: Before Access::getAssetRules (id:980 name:com_content.article.129)
Time: 0.06 ms / 195.95 ms Memory: 0.002 MB / 3.67 MB Application: After Access::getAssetRules (id:980 name:com_content.article.129)
Time: 6.64 ms / 202.59 ms Memory: 0.025 MB / 3.70 MB Application: Before Access::getAssetRules (id:982 name:com_content.article.131)
Time: 0.05 ms / 202.64 ms Memory: 0.002 MB / 3.70 MB Application: After Access::getAssetRules (id:982 name:com_content.article.131)
Time: 16.30 ms / 218.94 ms Memory: 0.089 MB / 3.79 MB Application: Before Access::getAssetRules (id:61 name:com_content.article.9)
Time: 0.06 ms / 218.99 ms Memory: 0.002 MB / 3.79 MB Application: After Access::getAssetRules (id:61 name:com_content.article.9)
Time: 31.27 ms / 250.26 ms Memory: 0.091 MB / 3.88 MB Application: afterRenderComponent com_content
Time: 3.64 ms / 253.90 ms Memory: 0.015 MB / 3.90 MB Application: afterDispatch
Time: 45.56 ms / 299.46 ms Memory: 0.429 MB / 4.32 MB Application: afterRender
Database queries total: 70.77 ms
5.03 MB (5,270,528 Bytes)
46 Queries Logged 70.77 ms
- Query Time: 1.64 ms Query memory: 0.023 MB Memory before query: 1.024 MB Rows returned: 0
SELECT `data`
FROM `sjla_session`
WHERE `session_id` = X'323263616e73766e70396e337062666b70737474683133723133'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sjla_session const PRIMARY PRIMARY 194 const 1 Status Duration Starting 0.24 ms Checking permissions 0.01 ms Opening tables 0.20 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.30 ms Preparing 0.02 ms Executing 0.39 ms End of update loop 0.02 ms Query end 0.00 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.00 ms Closing tables 0.03 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 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Same as call in the line below. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:661 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:621 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:499 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:456 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:826 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: 0.83 ms After last query: 1.27 ms Query memory: 0.020 MB Memory before query: 1.039 MB Rows returned: 0
SELECT `session_id`
FROM `sjla_session`
WHERE `session_id` = X'323263616e73766e70396e337062666b70737474683133723133'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sjla_session const PRIMARY PRIMARY 194 const 1 Using index Status Duration Starting 0.21 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.07 ms Preparing 0.01 ms Executing 0.20 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.04 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 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: 3.36 ms After last query: 0.34 ms Query memory: 0.004 MB Memory before query: 1.044 MB
INSERT INTO `sjla_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'323263616e73766e70396e337062666b70737474683133723133', 1, 1743558127, 0, '', 0)EXPLAIN not possible on query: INSERT INTO `sjla_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'323263616e73766e70396e337062666b70737474683133723133', 1, 1743558127, 0, '', 0)Status Duration Starting 0.12 ms Checking permissions 0.03 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.01 ms Init for update 0.05 ms Update 0.65 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 2.25 ms Closing tables 0.02 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 2.26 ms Reset for next command 0.02 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: 0.87 ms After last query: 3.08 ms Query memory: 0.021 MB Memory before query: 1.187 MB Rows returned: 5
SELECT id, rules
FROM `sjla_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sjla_viewlevels ALL NULL NO INDEX KEY COULD BE USED NULL NULL 5 Status Duration Starting 0.07 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.03 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.29 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.02 ms Updating status 0.02 ms Reset for next command 0.00 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.01 ms After last query: 0.29 ms Query memory: 0.021 MB Memory before query: 1.199 MB Rows returned: 2
SELECT b.id
FROM sjla_usergroups AS a
LEFT JOIN sjla_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 index idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 8 NULL 9 Using where; Using index Status Duration Starting 0.11 ms Checking permissions 0.01 ms Opening tables 0.06 ms After opening tables 0.02 ms System lock 0.01 ms Table lock 0.01 ms Init 0.04 ms Optimizing 0.04 ms Statistics 0.28 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.05 ms Executing 0.01 ms Sending data 0.21 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.02 ms Reset for next command 0.00 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: 1.07 ms After last query: 13.64 ms Query memory: 0.021 MB Memory before query: 1.827 MB Rows returned: 1
SELECT `name`
FROM `sjla_extensions`
WHERE `type` = 'package'
AND `element` = 'pkg_eventgallery_full'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sjla_extensions ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 Using index condition; Using where Status Duration Starting 0.09 ms Checking permissions 0.01 ms Opening tables 0.13 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.03 ms Optimizing 0.05 ms Statistics 0.17 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.27 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.02 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.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 9 JDatabaseDriver->loadResult() JROOT/administrator/components/com_eventgallery/version.php:24 8 include_once JROOT/administrator/components/com_eventgallery/version.php JROOT/plugins/system/picasaupdater/picasaupdater.php:32 7 plgSystemPicasaupdater->__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.31 ms After last query: 32.60 ms Query memory: 0.027 MB Memory before query: 2.334 MB Rows returned: 40
SELECT `id`,`name`,`rules`,`parent_id`
FROM `sjla_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_advancedmodules','com_ajax','com_akeeba','com_associations','com_attachments','com_banners','com_breezingforms','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_eventgallery','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sjla_assets ALL idx_asset_name NO INDEX KEY COULD BE USED NULL NULL 239 Using where Status Duration Starting 0.13 ms Checking permissions 0.02 ms Opening tables 0.09 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.10 ms Optimizing 0.02 ms Statistics 0.20 ms Preparing 0.03 ms Executing 0.00 ms Sending data 1.35 ms End of update loop 0.02 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.03 ms Reset for next command 0.01 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 15 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 14 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 13 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 12 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 11 Joomla\CMS\User\User->authorise() JROOT/plugins/system/advancedmodules/src/Document.php:30 10 RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript() JROOT/plugins/system/advancedmodules/advancedmodules.php:95 9 PlgSystemAdvancedModules->handleOnAfterRoute() JROOT/libraries/regularlabs/src/SystemPlugin.php:191 8 RegularLabs\Library\SystemPlugin->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.17 ms After last query: 2.56 ms Query memory: 0.005 MB Memory before query: 2.402 MB
UPDATE `sjla_extensions`
SET `params` = '{\"mediaversion\":\"d80f8404f54f53ac526114b1e2a815a4\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN not possible on query: UPDATE `sjla_extensions` SET `params` = '{\"mediaversion\":\"d80f8404f54f53ac526114b1e2a815a4\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.11 ms Checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.02 ms Init for update 0.20 ms Updating 0.26 ms End of update loop 0.01 ms Waiting for query cache lock 0.00 ms End of update loop 0.02 ms Query end 0.01 ms Commit 1.18 ms Closing tables 0.02 ms Unlocking tables 0.01 ms Closing tables 0.06 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 9 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 8 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1137 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 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.39 ms After last query: 9.88 ms Query memory: 0.040 MB Memory before query: 2.642 MB Rows returned: 148
SELECT `id`,`name`,`rules`,`parent_id`
FROM `sjla_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 sjla_assets ALL idx_asset_name,idx_parent_id NO INDEX KEY COULD BE USED NULL NULL 239 Using where Status Duration Starting 0.12 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.04 ms Optimizing 0.04 ms Statistics 0.11 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.65 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.03 ms Reset for next command 0.00 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 19 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 18 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 17 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 16 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 15 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/category.php:139 14 ContentModelCategory->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 13 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/libraries/src/MVC/View/CategoryView.php:116 12 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 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: 4.84 ms After last query: 6.19 ms Query memory: 0.028 MB Memory before query: 2.783 MB Rows returned: 8
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,( SELECT COUNT(i.`id`)
FROM `sjla_content` AS `i`
WHERE i.`catid` = c.id
AND i.state = 1) AS numitems
FROM `sjla_categories` AS `s`
INNER JOIN `sjla_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.published = 1
AND s.id = 9
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 PRIMARY c ALL cat_idx,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 28 Using where; Using filesort 2 DEPENDENT SUBQUERY i ref idx_state,idx_catid idx_catid 4 jdb7971082.c.id 5 Using index condition; Using where Status Duration Starting 0.45 ms Checking permissions 0.02 ms Opening tables 0.26 ms After opening tables 0.02 ms System lock 0.01 ms Table lock 0.01 ms Init 0.39 ms Optimizing 0.07 ms Statistics 0.31 ms Preparing 0.02 ms Unlocking tables 0.00 ms Preparing 0.04 ms Optimizing 0.02 ms Statistics 0.07 ms Preparing 0.08 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.05 ms Creating sort index 0.35 ms Executing 0.01 ms Sending data 0.07 ms Executing 0.00 ms Sending data 0.03 ms Executing 0.00 ms Sending data 1.45 ms Executing 0.02 ms Sending data 0.06 ms Executing 0.00 ms Sending data 0.03 ms Executing 0.00 ms Sending data 0.06 ms Executing 0.00 ms Sending data 0.02 ms Executing 0.00 ms Sending data 0.23 ms End of update loop 0.02 ms Query end 0.00 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.00 ms Closing tables 0.03 ms Starting cleanup 0.00 ms Freeing items 0.02 ms Removing tmp table 0.01 ms Freeing items 0.03 ms Updating status 3.49 ms Reset for next command 0.03 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 16 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 15 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/models/category.php:355 14 ContentModelCategory->getCategory() JROOT/libraries/src/MVC/View/HtmlView.php:425 13 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:122 12 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 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: 3.96 ms After last query: 3.09 ms Query memory: 0.095 MB Memory before query: 2.846 MB Rows returned: 6
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
FROM sjla_content AS a
LEFT JOIN sjla_categories AS c
ON c.id = a.catid
LEFT JOIN sjla_users AS ua
ON ua.id = a.created_by
LEFT JOIN sjla_users AS uam
ON uam.id = a.modified_by
LEFT JOIN sjla_categories as parent
ON parent.id = c.parent_id
WHERE c.published = 1
AND a.state = 1
AND (a.catid = 9 OR a.catid IN ( SELECT sub.id
FROM sjla_categories as sub
INNER JOIN sjla_categories as this
ON sub.lft > this.lft
AND sub.rgt < this.rgt
WHERE this.id = 9
AND sub.level <= this.level + 1))
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-04-02 01:42:07')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-04-02 01:42:07')
ORDER BY
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created
LIMIT 6id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY a ref idx_state,idx_catid idx_state 1 const 116 Using where; Using filesort 1 PRIMARY c eq_ref PRIMARY PRIMARY 4 jdb7971082.a.catid 1 Using where 1 PRIMARY ua eq_ref PRIMARY PRIMARY 4 jdb7971082.a.created_by 1 Using where 1 PRIMARY uam eq_ref PRIMARY PRIMARY 4 jdb7971082.a.modified_by 1 Using where 1 PRIMARY parent eq_ref PRIMARY PRIMARY 4 jdb7971082.c.parent_id 1 Using where 2 MATERIALIZED this const PRIMARY,idx_left_right PRIMARY 4 const 1 2 MATERIALIZED sub ALL PRIMARY,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 28 Using where Status Duration Starting 0.38 ms Checking permissions 0.02 ms Opening tables 0.24 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.01 ms Init 0.24 ms Optimizing 0.12 ms Statistics 0.12 ms Preparing 0.05 ms Optimizing 0.05 ms Statistics 0.16 ms Preparing 0.05 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.04 ms Creating sort index 0.12 ms Executing 0.00 ms Sending data 1.34 ms End of update loop 0.02 ms Query end 0.00 ms Commit 0.53 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Removing tmp table 0.01 ms Freeing items 0.03 ms Removing tmp table 0.01 ms Freeing items 0.03 ms Updating status 1.75 ms Reset for next command 0.02 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/libraries/src/MVC/Model/ListModel.php:194 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_content/models/articles.php:576 15 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 14 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 13 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 12 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 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.21 ms After last query: 2.04 ms Query memory: 0.024 MB Memory before query: 2.960 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `sjla_contentitem_tag_map` AS m
INNER JOIN `sjla_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 126
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 jdb7971082.m.tag_id 1 Using where Status Duration Starting 0.12 ms Checking permissions 0.01 ms Opening tables 0.14 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.09 ms Optimizing 0.04 ms Statistics 0.14 ms Preparing 0.03 ms Executing 0.00 ms Sending data 0.23 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.18 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 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/Helper/TagsHelper.php:454 16 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 15 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 14 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 13 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 12 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 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: 0.83 ms After last query: 0.85 ms Query memory: 0.024 MB Memory before query: 2.978 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `sjla_contentitem_tag_map` AS m
INNER JOIN `sjla_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 134
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 jdb7971082.m.tag_id 1 Using where 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.00 ms Table lock 0.03 ms Init 0.07 ms Optimizing 0.04 ms Statistics 0.08 ms Preparing 0.03 ms Executing 0.00 ms Sending data 0.17 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.02 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/Helper/TagsHelper.php:454 16 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 15 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 14 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 13 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 12 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 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: 0.75 ms After last query: 0.74 ms Query memory: 0.024 MB Memory before query: 2.996 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `sjla_contentitem_tag_map` AS m
INNER JOIN `sjla_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 133
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 jdb7971082.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.01 ms System lock 0.02 ms Table lock 0.01 ms Init 0.07 ms Optimizing 0.04 ms Statistics 0.09 ms Preparing 0.04 ms Executing 0.00 ms Sending data 0.17 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.02 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/Helper/TagsHelper.php:454 16 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 15 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 14 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 13 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 12 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 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.37 ms After last query: 0.69 ms Query memory: 0.024 MB Memory before query: 3.014 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `sjla_contentitem_tag_map` AS m
INNER JOIN `sjla_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 132
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 jdb7971082.m.tag_id 1 Using where Status Duration Starting 0.08 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.04 ms Statistics 0.08 ms Preparing 0.04 ms Executing 0.00 ms Sending data 0.82 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.02 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/Helper/TagsHelper.php:454 16 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 15 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 14 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 13 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 12 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 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.78 ms Query memory: 0.024 MB Memory before query: 3.032 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `sjla_contentitem_tag_map` AS m
INNER JOIN `sjla_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 129
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 jdb7971082.m.tag_id 1 Using where Status Duration Starting 0.10 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.31 ms Init 0.08 ms Optimizing 0.04 ms Statistics 0.35 ms Preparing 0.06 ms Executing 0.01 ms Sending data 0.23 ms End of update loop 0.06 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.02 ms Reset for next command 0.02 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 16 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 15 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 14 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 13 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 12 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 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.45 ms After last query: 0.72 ms Query memory: 0.025 MB Memory before query: 3.052 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `sjla_contentitem_tag_map` AS m
INNER JOIN `sjla_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 131
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 jdb7971082.m.tag_id 1 Using where Status Duration Starting 0.09 ms Checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.07 ms Optimizing 0.35 ms Statistics 0.10 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.48 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.02 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/Helper/TagsHelper.php:454 16 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 15 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 14 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 13 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 12 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 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: 4.00 ms After last query: 1.63 ms Query memory: 0.025 MB Memory before query: 3.062 MB Rows returned: 1
SELECT COUNT(*)
FROM sjla_content AS a
LEFT JOIN sjla_categories AS c
ON c.id = a.catid
LEFT JOIN sjla_users AS ua
ON ua.id = a.created_by
LEFT JOIN sjla_users AS uam
ON uam.id = a.modified_by
LEFT JOIN sjla_categories as parent
ON parent.id = c.parent_id
WHERE c.published = 1
AND a.state = 1
AND (a.catid = 9 OR a.catid IN ( SELECT sub.id
FROM sjla_categories as sub
INNER JOIN sjla_categories as this
ON sub.lft > this.lft
AND sub.rgt < this.rgt
WHERE this.id = 9
AND sub.level <= this.level + 1))
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-04-02 01:42:07')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-04-02 01:42:07')id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY a ref idx_state,idx_catid idx_state 1 const 116 Using where 1 PRIMARY c eq_ref PRIMARY PRIMARY 4 jdb7971082.a.catid 1 Using where 2 MATERIALIZED this const PRIMARY,idx_left_right PRIMARY 4 const 1 2 MATERIALIZED sub ALL PRIMARY,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 28 Using where Status Duration Starting 0.18 ms Checking permissions 0.01 ms Opening tables 0.38 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.09 ms Optimizing 0.07 ms Statistics 0.12 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.04 ms Optimizing 0.02 ms Statistics 0.52 ms Preparing 0.26 ms Executing 0.00 ms Sending data 0.09 ms Executing 0.00 ms Sending data 1.08 ms End of update loop 0.02 ms Query end 0.00 ms Commit 0.52 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.03 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Removing tmp table 0.01 ms Freeing items 0.29 ms Removing tmp table 0.01 ms Freeing items 0.01 ms Updating status 2.85 ms Reset for next command 0.02 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 18 JDatabaseDriver->loadResult() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() JROOT/libraries/src/MVC/Model/ListModel.php:289 16 Joomla\CMS\MVC\Model\ListModel->getTotal() JROOT/libraries/src/MVC/Model/ListModel.php:239 15 Joomla\CMS\MVC\Model\ListModel->getPagination() JROOT/components/com_content/models/category.php:265 14 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 13 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 12 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 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.62 ms After last query: 2.35 ms Query memory: 0.023 MB Memory before query: 3.066 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `sjla_contentitem_tag_map` AS m
INNER JOIN `sjla_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.category'
AND `m`.`content_item_id` = 9
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 jdb7971082.m.tag_id 1 Using where Status Duration Starting 0.39 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.08 ms Optimizing 0.04 ms Statistics 0.10 ms Preparing 0.04 ms Executing 0.00 ms Sending data 0.22 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.02 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.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 13 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/libraries/src/MVC/View/CategoryView.php:229 12 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 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.26 ms After last query: 6.82 ms Query memory: 0.027 MB Memory before query: 3.323 MB Rows returned: 3
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 `sjla_categories` AS `s`
INNER JOIN `sjla_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 = 12
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 ALL cat_idx,idx_access,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 28 Using where; Using filesort Status Duration Starting 0.21 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.08 ms Optimizing 0.04 ms Statistics 0.19 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.03 ms Creating sort index 0.29 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.02 ms Updating status 0.02 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/libraries/src/Categories/Categories.php:324 20 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 19 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203 18 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:140 17 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:194 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 14 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 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.73 ms After last query: 0.50 ms Query memory: 0.025 MB Memory before query: 3.344 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 sjla_fields AS a
LEFT JOIN `sjla_languages` AS l
ON l.lang_code = a.language
LEFT JOIN sjla_users AS uc
ON uc.id=a.checked_out
LEFT JOIN sjla_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN sjla_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN sjla_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `sjla_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 (12,0,9))
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 jdb7971082.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 jdb7971082.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 jdb7971082.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 jdb7971082.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 jdb7971082.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 jdb7971082.a.id 1 Using where; Using index; Distinct Status Duration Starting 0.23 ms Checking permissions 0.01 ms Opening tables 0.42 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.01 ms Init 0.11 ms Optimizing 0.11 ms Statistics 0.23 ms Preparing 0.09 ms Creating tmp table 0.11 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.60 ms Creating sort index 0.06 ms Removing tmp table 0.11 ms Creating sort index 0.19 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.00 ms Closing tables 0.04 ms Starting cleanup 0.00 ms Freeing items 0.02 ms Updating status 0.03 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/libraries/src/MVC/Model/BaseDatabaseModel.php:322 18 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 17 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 14 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 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: 0.79 ms After last query: 8.77 ms Query memory: 0.024 MB Memory before query: 3.499 MB Rows returned: 1
SELECT created_by, catid
FROM sjla_content
WHERE id = 126id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sjla_content const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.09 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.03 ms Optimizing 0.02 ms Statistics 0.11 ms Preparing 0.01 ms Unlocking tables 0.16 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.02 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.02 ms Reset for next command 0.00 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:809 15 AttachmentsPlugin_Com_Content->attachmentsHiddenForParent() JROOT/plugins/content/attachments/attachments.php:202 14 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 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.15 ms After last query: 1.82 ms Query memory: 0.025 MB Memory before query: 3.540 MB Rows returned: 0
SELECT a.*, u.name as creator_name
FROM sjla_attachments AS a
LEFT JOIN sjla_users AS u
ON u.id = a.created_by
WHERE a.parent_id=126
AND a.state = 1
AND a.parent_type='com_content'
AND a.parent_entity='article'
AND a.access IN (1,5)
ORDER BY filenameid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL NULL NO INDEX KEY COULD BE USED NULL NULL 23 Using where; Using filesort 1 SIMPLE u eq_ref PRIMARY PRIMARY 4 jdb7971082.a.created_by 1 Status Duration Starting 0.13 ms Checking permissions 0.01 ms Opening tables 0.10 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.05 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.03 ms Creating sort index 0.33 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.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.02 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/components/com_attachments/models/attachments.php:436 18 AttachmentsModelAttachments->getAttachmentsList() JROOT/components/com_attachments/models/attachments.php:514 17 AttachmentsModelAttachments->someVisible() JROOT/components/com_attachments/controllers/attachments.php:98 16 AttachmentsControllerAttachments->displayString() JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911 15 AttachmentsPlugin->insertAttachmentsList() JROOT/plugins/content/attachments/attachments.php:218 14 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 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: 0.77 ms After last query: 4.40 ms Query memory: 0.024 MB Memory before query: 3.572 MB Rows returned: 1
SELECT created_by, catid
FROM sjla_content
WHERE id = 134id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sjla_content const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.10 ms Checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.07 ms Preparing 0.01 ms Unlocking tables 0.16 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.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.02 ms Reset for next command 0.00 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:809 15 AttachmentsPlugin_Com_Content->attachmentsHiddenForParent() JROOT/plugins/content/attachments/attachments.php:202 14 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 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.04 ms After last query: 1.21 ms Query memory: 0.025 MB Memory before query: 3.588 MB Rows returned: 0
SELECT a.*, u.name as creator_name
FROM sjla_attachments AS a
LEFT JOIN sjla_users AS u
ON u.id = a.created_by
WHERE a.parent_id=134
AND a.state = 1
AND a.parent_type='com_content'
AND a.parent_entity='article'
AND a.access IN (1,5)
ORDER BY filenameid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL NULL NO INDEX KEY COULD BE USED NULL NULL 23 Using where; Using filesort 1 SIMPLE u eq_ref PRIMARY PRIMARY 4 jdb7971082.a.created_by 1 Status Duration Starting 0.18 ms Checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.09 ms Optimizing 0.05 ms Statistics 0.04 ms Preparing 0.04 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.03 ms Creating sort index 0.25 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.02 ms Reset for next command 0.02 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/components/com_attachments/models/attachments.php:436 18 AttachmentsModelAttachments->getAttachmentsList() JROOT/components/com_attachments/models/attachments.php:514 17 AttachmentsModelAttachments->someVisible() JROOT/components/com_attachments/controllers/attachments.php:98 16 AttachmentsControllerAttachments->displayString() JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911 15 AttachmentsPlugin->insertAttachmentsList() JROOT/plugins/content/attachments/attachments.php:218 14 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 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: 0.68 ms After last query: 3.88 ms Query memory: 0.024 MB Memory before query: 3.593 MB Rows returned: 1
SELECT created_by, catid
FROM sjla_content
WHERE id = 133id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sjla_content const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.08 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.06 ms Preparing 0.00 ms Unlocking tables 0.14 ms Preparing 0.02 ms Executing 0.02 ms Sending data 0.02 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.02 ms Reset for next command 0.00 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:809 15 AttachmentsPlugin_Com_Content->attachmentsHiddenForParent() JROOT/plugins/content/attachments/attachments.php:202 14 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 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: 0.97 ms After last query: 1.14 ms Query memory: 0.025 MB Memory before query: 3.609 MB Rows returned: 0
SELECT a.*, u.name as creator_name
FROM sjla_attachments AS a
LEFT JOIN sjla_users AS u
ON u.id = a.created_by
WHERE a.parent_id=133
AND a.state = 1
AND a.parent_type='com_content'
AND a.parent_entity='article'
AND a.access IN (1,5)
ORDER BY filenameid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL NULL NO INDEX KEY COULD BE USED NULL NULL 23 Using where; Using filesort 1 SIMPLE u eq_ref PRIMARY PRIMARY 4 jdb7971082.a.created_by 1 Status Duration Starting 0.13 ms Checking permissions 0.09 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.09 ms Optimizing 0.05 ms Statistics 0.05 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.20 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.01 ms Freeing items 0.01 ms Updating status 0.02 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/components/com_attachments/models/attachments.php:436 18 AttachmentsModelAttachments->getAttachmentsList() JROOT/components/com_attachments/models/attachments.php:514 17 AttachmentsModelAttachments->someVisible() JROOT/components/com_attachments/controllers/attachments.php:98 16 AttachmentsControllerAttachments->displayString() JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911 15 AttachmentsPlugin->insertAttachmentsList() JROOT/plugins/content/attachments/attachments.php:218 14 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 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: 0.76 ms After last query: 3.86 ms Query memory: 0.024 MB Memory before query: 3.614 MB Rows returned: 1
SELECT created_by, catid
FROM sjla_content
WHERE id = 132id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sjla_content const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.09 ms Checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.08 ms Preparing 0.01 ms Unlocking tables 0.15 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.02 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.02 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:809 15 AttachmentsPlugin_Com_Content->attachmentsHiddenForParent() JROOT/plugins/content/attachments/attachments.php:202 14 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 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.09 ms After last query: 1.03 ms Query memory: 0.025 MB Memory before query: 3.630 MB Rows returned: 0
SELECT a.*, u.name as creator_name
FROM sjla_attachments AS a
LEFT JOIN sjla_users AS u
ON u.id = a.created_by
WHERE a.parent_id=132
AND a.state = 1
AND a.parent_type='com_content'
AND a.parent_entity='article'
AND a.access IN (1,5)
ORDER BY filenameid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL NULL NO INDEX KEY COULD BE USED NULL NULL 23 Using where; Using filesort 1 SIMPLE u eq_ref PRIMARY PRIMARY 4 jdb7971082.a.created_by 1 Status Duration Starting 0.12 ms Checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.12 ms Optimizing 0.04 ms Statistics 0.04 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.03 ms Creating sort index 0.28 ms End of update loop 0.01 ms Query end 0.02 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.02 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/components/com_attachments/models/attachments.php:436 18 AttachmentsModelAttachments->getAttachmentsList() JROOT/components/com_attachments/models/attachments.php:514 17 AttachmentsModelAttachments->someVisible() JROOT/components/com_attachments/controllers/attachments.php:98 16 AttachmentsControllerAttachments->displayString() JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911 15 AttachmentsPlugin->insertAttachmentsList() JROOT/plugins/content/attachments/attachments.php:218 14 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 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.32 ms After last query: 2.63 ms Query memory: 0.027 MB Memory before query: 3.645 MB Rows returned: 3
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 `sjla_categories` AS `s`
INNER JOIN `sjla_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 = 10
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 ALL cat_idx,idx_access,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 28 Using where; Using filesort Status Duration Starting 0.19 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.09 ms Optimizing 0.05 ms Statistics 0.20 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.04 ms Sorting result 0.02 ms Executing 0.00 ms Sending data 0.03 ms Creating sort index 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.02 ms Starting cleanup 0.00 ms Freeing items 0.02 ms Updating status 0.03 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/libraries/src/Categories/Categories.php:324 20 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 19 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203 18 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:140 17 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:194 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 14 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 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.15 ms After last query: 0.48 ms Query memory: 0.025 MB Memory before query: 3.651 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 sjla_fields AS a
LEFT JOIN `sjla_languages` AS l
ON l.lang_code = a.language
LEFT JOIN sjla_users AS uc
ON uc.id=a.checked_out
LEFT JOIN sjla_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN sjla_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN sjla_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `sjla_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 (10,0,9))
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 jdb7971082.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 jdb7971082.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 jdb7971082.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 jdb7971082.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 jdb7971082.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 jdb7971082.a.id 1 Using where; Using index; Distinct Status Duration Starting 0.20 ms Checking permissions 0.01 ms Opening tables 0.10 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.09 ms Optimizing 0.11 ms Statistics 0.16 ms Preparing 0.07 ms Creating tmp table 0.07 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.59 ms Creating sort index 0.06 ms Removing tmp table 0.13 ms Creating sort index 0.20 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.02 ms Starting cleanup 0.00 ms Freeing items 0.02 ms Updating status 0.03 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/libraries/src/MVC/Model/BaseDatabaseModel.php:322 18 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 17 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 14 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 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: 0.67 ms After last query: 1.32 ms Query memory: 0.024 MB Memory before query: 3.662 MB Rows returned: 1
SELECT created_by, catid
FROM sjla_content
WHERE id = 129id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sjla_content const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.08 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.07 ms Preparing 0.00 ms Unlocking tables 0.14 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.02 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 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:809 15 AttachmentsPlugin_Com_Content->attachmentsHiddenForParent() JROOT/plugins/content/attachments/attachments.php:202 14 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 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: 0.86 ms After last query: 1.16 ms Query memory: 0.026 MB Memory before query: 3.684 MB Rows returned: 0
SELECT a.*, u.name as creator_name
FROM sjla_attachments AS a
LEFT JOIN sjla_users AS u
ON u.id = a.created_by
WHERE a.parent_id=129
AND a.state = 1
AND a.parent_type='com_content'
AND a.parent_entity='article'
AND a.access IN (1,5)
ORDER BY filenameid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL NULL NO INDEX KEY COULD BE USED NULL NULL 23 Using where; Using filesort 1 SIMPLE u eq_ref PRIMARY PRIMARY 4 jdb7971082.a.created_by 1 Status Duration Starting 0.11 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.08 ms Optimizing 0.09 ms Statistics 0.03 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.03 ms Creating sort index 0.19 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.02 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_attachments/models/attachments.php:436 18 AttachmentsModelAttachments->getAttachmentsList() JROOT/components/com_attachments/models/attachments.php:514 17 AttachmentsModelAttachments->someVisible() JROOT/components/com_attachments/controllers/attachments.php:98 16 AttachmentsControllerAttachments->displayString() JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911 15 AttachmentsPlugin->insertAttachmentsList() JROOT/plugins/content/attachments/attachments.php:218 14 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 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: 0.75 ms After last query: 3.99 ms Query memory: 0.024 MB Memory before query: 3.689 MB Rows returned: 1
SELECT created_by, catid
FROM sjla_content
WHERE id = 131id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sjla_content const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.08 ms Checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.02 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.01 ms Unlocking tables 0.20 ms Preparing 0.07 ms Executing 0.01 ms Sending data 0.02 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.02 ms Reset for next command 0.00 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:809 15 AttachmentsPlugin_Com_Content->attachmentsHiddenForParent() JROOT/plugins/content/attachments/attachments.php:202 14 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 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: 0.86 ms After last query: 1.14 ms Query memory: 0.025 MB Memory before query: 3.704 MB Rows returned: 0
SELECT a.*, u.name as creator_name
FROM sjla_attachments AS a
LEFT JOIN sjla_users AS u
ON u.id = a.created_by
WHERE a.parent_id=131
AND a.state = 1
AND a.parent_type='com_content'
AND a.parent_entity='article'
AND a.access IN (1,5)
ORDER BY filenameid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL NULL NO INDEX KEY COULD BE USED NULL NULL 23 Using where; Using filesort 1 SIMPLE u eq_ref PRIMARY PRIMARY 4 jdb7971082.a.created_by 1 Status Duration Starting 0.11 ms Checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.02 ms Init 0.11 ms Optimizing 0.04 ms Statistics 0.03 ms Preparing 0.03 ms Sorting result 0.02 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.19 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.02 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_attachments/models/attachments.php:436 18 AttachmentsModelAttachments->getAttachmentsList() JROOT/components/com_attachments/models/attachments.php:514 17 AttachmentsModelAttachments->someVisible() JROOT/components/com_attachments/controllers/attachments.php:98 16 AttachmentsControllerAttachments->displayString() JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911 15 AttachmentsPlugin->insertAttachmentsList() JROOT/plugins/content/attachments/attachments.php:218 14 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 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.03 ms After last query: 5.53 ms Query memory: 0.027 MB Memory before query: 3.736 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 sjla_fields AS a
LEFT JOIN `sjla_languages` AS l
ON l.lang_code = a.language
LEFT JOIN sjla_users AS uc
ON uc.id=a.checked_out
LEFT JOIN sjla_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN sjla_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN sjla_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_content.categories'
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 jdb7971082.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 jdb7971082.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 jdb7971082.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 jdb7971082.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 jdb7971082.a.group_id 1 Using where Status Duration Starting 0.26 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.11 ms Optimizing 0.08 ms Statistics 0.28 ms Preparing 0.06 ms Creating tmp table 0.09 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.42 ms Creating sort index 0.05 ms Removing tmp table 0.08 ms Creating sort index 0.15 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.02 ms Starting cleanup 0.00 ms Freeing items 0.02 ms Updating status 0.02 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/administrator/components/com_fields/models/fields.php:333 21 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 20 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 19 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 18 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 17 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 16 JEventDispatcher->trigger() JROOT/components/com_content/views/category/tmpl/blog.php:19 15 include JROOT/components/com_content/views/category/tmpl/blog.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 13 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 12 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_content/views/category/view.html.php:250 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 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.21 ms After last query: 2.10 ms Query memory: 0.027 MB Memory before query: 3.764 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 sjla_fields AS a
LEFT JOIN `sjla_languages` AS l
ON l.lang_code = a.language
LEFT JOIN sjla_users AS uc
ON uc.id=a.checked_out
LEFT JOIN sjla_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN sjla_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN sjla_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `sjla_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.categories'
AND (fc.category_id IS NULL OR fc.category_id IN (9,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 jdb7971082.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 jdb7971082.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 jdb7971082.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 jdb7971082.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 jdb7971082.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 jdb7971082.a.id 1 Using where; Using index; Distinct Status Duration Starting 0.22 ms Checking permissions 0.01 ms Opening tables 0.08 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.13 ms Optimizing 0.06 ms Statistics 0.16 ms Preparing 0.06 ms Creating tmp table 0.07 ms Sorting result 0.02 ms Executing 0.00 ms Sending data 0.57 ms Creating sort index 0.06 ms Removing tmp table 0.10 ms Creating sort index 0.30 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.03 ms Starting cleanup 0.00 ms Freeing items 0.03 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller File and line number 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 24 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 23 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 22 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 21 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 20 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:404 19 PlgSystemFields->display() JROOT/plugins/system/fields/fields.php:324 18 PlgSystemFields->onContentAfterTitle() JROOT/libraries/joomla/event/event.php:70 17 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 16 JEventDispatcher->trigger() JROOT/components/com_content/views/category/tmpl/blog.php:22 15 include JROOT/components/com_content/views/category/tmpl/blog.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 13 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 12 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_content/views/category/view.html.php:250 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 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: 0.79 ms After last query: 1.50 ms Query memory: 0.026 MB Memory before query: 3.777 MB Rows returned: 1
SELECT created_by, catid
FROM sjla_content
WHERE id = 9id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sjla_content const PRIMARY PRIMARY 4 const 1 Status 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.03 ms Optimizing 0.02 ms Statistics 0.08 ms Preparing 0.01 ms Unlocking tables 0.15 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.02 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.02 ms Reset for next command 0.00 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:809 19 AttachmentsPlugin_Com_Content->attachmentsHiddenForParent() JROOT/plugins/content/attachments/attachments.php:319 18 plgContentAttachments->onContentBeforeDisplay() JROOT/libraries/joomla/event/event.php:70 17 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 16 JEventDispatcher->trigger() JROOT/components/com_content/views/category/tmpl/blog.php:25 15 include JROOT/components/com_content/views/category/tmpl/blog.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 13 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 12 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_content/views/category/view.html.php:250 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 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: 0.91 ms After last query: 1.38 ms Query memory: 0.027 MB Memory before query: 3.795 MB Rows returned: 0
SELECT a.*, u.name as creator_name
FROM sjla_attachments AS a
LEFT JOIN sjla_users AS u
ON u.id = a.created_by
WHERE a.parent_id=9
AND a.state = 1
AND a.parent_type='com_content'
AND a.parent_entity='article'
AND a.access IN (1,5)
ORDER BY filenameid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL NULL NO INDEX KEY COULD BE USED NULL NULL 23 Using where; Using filesort 1 SIMPLE u eq_ref PRIMARY PRIMARY 4 jdb7971082.a.created_by 1 Status Duration Starting 0.12 ms Checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.08 ms Optimizing 0.04 ms Statistics 0.04 ms Preparing 0.04 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.27 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.02 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/components/com_attachments/models/attachments.php:436 22 AttachmentsModelAttachments->getAttachmentsList() JROOT/components/com_attachments/models/attachments.php:514 21 AttachmentsModelAttachments->someVisible() JROOT/components/com_attachments/controllers/attachments.php:98 20 AttachmentsControllerAttachments->displayString() JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911 19 AttachmentsPlugin->insertAttachmentsList() JROOT/plugins/content/attachments/attachments.php:325 18 plgContentAttachments->onContentBeforeDisplay() JROOT/libraries/joomla/event/event.php:70 17 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 16 JEventDispatcher->trigger() JROOT/components/com_content/views/category/tmpl/blog.php:25 15 include JROOT/components/com_content/views/category/tmpl/blog.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 13 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 12 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_content/views/category/view.html.php:250 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 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.44 ms After last query: 16.57 ms Query memory: 0.031 MB Memory before query: 3.843 MB Rows returned: 3
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 `sjla_categories` AS `s`
INNER JOIN `sjla_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 = 32
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 ALL cat_idx,idx_access,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 28 Using where; Using filesort Status Duration Starting 0.25 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.16 ms Optimizing 0.05 ms Statistics 0.20 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.04 ms Creating sort index 0.30 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.02 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 31 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 30 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 29 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 28 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 27 ContentRouter->getCategorySegment() Same as call in the line below. 26 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 25 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 24 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 23 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 22 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 21 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 20 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 19 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 18 Joomla\CMS\Router\Route::_() JROOT/components/com_content/views/category/tmpl/blog_children.php:46 17 include JROOT/components/com_content/views/category/tmpl/blog_children.php JROOT/libraries/src/MVC/View/HtmlView.php:701 16 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_content/views/category/tmpl/blog.php:128 15 include JROOT/components/com_content/views/category/tmpl/blog.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 13 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 12 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_content/views/category/view.html.php:250 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 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.26 ms After last query: 0.88 ms Query memory: 0.031 MB Memory before query: 3.863 MB Rows returned: 3
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 `sjla_categories` AS `s`
INNER JOIN `sjla_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 = 33
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 ALL cat_idx,idx_access,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 28 Using where; Using filesort Status Duration Starting 0.22 ms Checking permissions 0.06 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.01 ms Init 0.08 ms Optimizing 0.05 ms Statistics 0.18 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.03 ms Creating sort index 0.30 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.02 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/Categories/Categories.php:324 29 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 28 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 27 ContentRouter->getCategorySegment() Same as call in the line below. 26 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 25 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 24 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 23 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 22 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 21 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 20 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 19 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 18 Joomla\CMS\Router\Route::_() JROOT/components/com_content/views/category/tmpl/blog_children.php:46 17 include JROOT/components/com_content/views/category/tmpl/blog_children.php JROOT/libraries/src/MVC/View/HtmlView.php:701 16 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_content/views/category/tmpl/blog.php:128 15 include JROOT/components/com_content/views/category/tmpl/blog.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 13 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 12 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_content/views/category/view.html.php:250 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 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.54 ms After last query: 0.93 ms Query memory: 0.031 MB Memory before query: 3.882 MB Rows returned: 3
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 `sjla_categories` AS `s`
INNER JOIN `sjla_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 = 34
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 ALL cat_idx,idx_access,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 28 Using where; Using filesort Status Duration Starting 0.20 ms Checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.01 ms Init 0.09 ms Optimizing 0.07 ms Statistics 0.28 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.04 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.03 ms Creating sort index 0.40 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.02 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 31 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 30 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 29 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 28 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 27 ContentRouter->getCategorySegment() Same as call in the line below. 26 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 25 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 24 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 23 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 22 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 21 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 20 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 19 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 18 Joomla\CMS\Router\Route::_() JROOT/components/com_content/views/category/tmpl/blog_children.php:46 17 include JROOT/components/com_content/views/category/tmpl/blog_children.php JROOT/libraries/src/MVC/View/HtmlView.php:701 16 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_content/views/category/tmpl/blog.php:128 15 include JROOT/components/com_content/views/category/tmpl/blog.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 13 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 12 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_content/views/category/view.html.php:250 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 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.17 ms After last query: 0.98 ms Query memory: 0.031 MB Memory before query: 3.902 MB Rows returned: 3
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 `sjla_categories` AS `s`
INNER JOIN `sjla_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 = 35
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 ALL cat_idx,idx_access,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 28 Using where; Using filesort Status Duration Starting 0.18 ms Checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.01 ms Init 0.07 ms Optimizing 0.04 ms Statistics 0.18 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.08 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.03 ms Creating sort index 0.26 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.02 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 31 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 30 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 29 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 28 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 27 ContentRouter->getCategorySegment() Same as call in the line below. 26 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 25 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 24 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 23 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 22 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 21 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 20 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 19 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 18 Joomla\CMS\Router\Route::_() JROOT/components/com_content/views/category/tmpl/blog_children.php:46 17 include JROOT/components/com_content/views/category/tmpl/blog_children.php JROOT/libraries/src/MVC/View/HtmlView.php:701 16 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_content/views/category/tmpl/blog.php:128 15 include JROOT/components/com_content/views/category/tmpl/blog.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 13 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 12 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_content/views/category/view.html.php:250 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 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.34 ms After last query: 5.42 ms Query memory: 0.020 MB Memory before query: 3.896 MB Rows returned: 0
SELECT folder.*
FROM `sjla_eventgallery_folder` AS folder
LEFT JOIN `sjla_eventgallery_file` AS file
ON folder.folder = file.folder
and file.published=1
and file.ismainimage=0
WHERE file.file IS NULL
AND (folder.foldertypeid=1 OR folder.foldertypeid=2 OR folder.foldertypeid=4)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE folder ALL NULL NO INDEX KEY COULD BE USED NULL NULL 28 Using where 1 SIMPLE file ref file,index_folder file 377 jdb7971082.folder.folder 3 Using where; Not exists Status Duration Starting 0.14 ms Checking permissions 0.01 ms Opening tables 0.13 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.11 ms Optimizing 0.04 ms Statistics 0.05 ms Preparing 0.04 ms Executing 0.00 ms Sending data 0.40 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.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.00 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 8 JDatabaseDriver->loadObjectList() JROOT/plugins/system/picasaupdater/picasaupdater.php:80 7 plgSystemPicasaupdater->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199 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.84 ms After last query: 3.87 ms Query memory: 0.043 MB Memory before query: 3.922 MB Rows returned: 19
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down
FROM sjla_modules AS m
LEFT JOIN sjla_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
LEFT JOIN sjla_advancedmodules as am
ON am.moduleid = m.id
WHERE m.published = 1
AND e.enabled = 1
AND m.access IN (1,1,5)
AND m.client_id = 0
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref published,newsfeeds published 1 const 22 Using index condition; Using where; Using filesort 1 SIMPLE am eq_ref PRIMARY PRIMARY 4 jdb7971082.m.id 1 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 jdb7971082.m.module,const 1 Using index condition; Using where Status Duration Starting 0.19 ms Checking permissions 0.02 ms Opening tables 0.08 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.07 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.02 ms Creating sort index 0.89 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.02 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 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/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:278 14 PlgSystemAdvancedModuleHelper->getModuleList() JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:60 13 PlgSystemAdvancedModuleHelper->onPrepareModuleList() JROOT/libraries/joomla/event/dispatcher.php:165 12 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 11 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Helper/ModuleHelper.php:366 10 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 9 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:601 8 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/templates/protostar/index.php:91 7 require JROOT/templates/protostar/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.01 ms After last query: 38.31 ms Query memory: 0.026 MB Memory before query: 4.317 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 `sjla_categories` AS `s`
INNER JOIN `sjla_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 = 2
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_left_right 4 NULL 2 Using index condition; Using where Status Duration Starting 0.35 ms Checking permissions 0.06 ms Opening tables 0.20 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.12 ms Optimizing 0.06 ms Statistics 0.27 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.05 ms Sorting result 0.02 ms Executing 0.00 ms Sending data 0.45 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.03 ms Starting cleanup 0.00 ms Freeing items 0.02 ms Updating status 0.03 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/components/com_content/router.php:72 17 ContentRouter->getCategorySegment() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 15 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 14 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 13 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 12 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 11 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 10 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 9 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 8 Joomla\CMS\Router\Route::_() JROOT/plugins/system/sef/sef.php:110 7 PlgSystemSef->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 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
19 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
7 × SELECT `m`.`tag_id`,`t`.*
FROM `sjla_contentitem_tag_map` AS m
INNER JOIN `sjla_tags` AS t
ON `m`.`tag_id` = `t`.`id`7 × 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 `sjla_categories` AS `s`
INNER JOIN `sjla_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)7 × SELECT created_by, catid
FROM sjla_content7 × SELECT a.*, u.name as creator_name
FROM sjla_attachments AS a
LEFT JOIN sjla_users AS u
ON u.id = a.created_by3 × 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 sjla_fields AS a
LEFT JOIN `sjla_languages` AS l
ON l.lang_code = a.language
LEFT JOIN sjla_users AS uc
ON uc.id=a.checked_out
LEFT JOIN sjla_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN sjla_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN sjla_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `sjla_fields_categories` AS fc
ON fc.field_id = a.id2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `sjla_assets`1 × SELECT `data`
FROM `sjla_session`1 × SELECT `session_id`
FROM `sjla_session`1 × SELECT id, rules
FROM `sjla_viewlevels1 × SELECT b.id
FROM sjla_usergroups AS a
LEFT JOIN sjla_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `name`
FROM `sjla_extensions`1 × 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,( SELECT COUNT(i.`id`)
FROM `sjla_content` AS `i`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
FROM sjla_content AS a
LEFT JOIN sjla_categories AS c
ON c.id = a.catid
LEFT JOIN sjla_users AS ua
ON ua.id = a.created_by
LEFT JOIN sjla_users AS uam
ON uam.id = a.modified_by
LEFT JOIN sjla_categories as parent
ON parent.id = c.parent_id1 × SELECT COUNT(*)
FROM sjla_content AS a
LEFT JOIN sjla_categories AS c
ON c.id = a.catid
LEFT JOIN sjla_users AS ua
ON ua.id = a.created_by
LEFT JOIN sjla_users AS uam
ON uam.id = a.modified_by
LEFT JOIN sjla_categories as parent
ON parent.id = c.parent_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 sjla_fields AS a
LEFT JOIN `sjla_languages` AS l
ON l.lang_code = a.language
LEFT JOIN sjla_users AS uc
ON uc.id=a.checked_out
LEFT JOIN sjla_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN sjla_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN sjla_fields_groups AS g
ON g.id = a.group_id1 × SELECT folder.*
FROM `sjla_eventgallery_folder` AS folder
LEFT JOIN `sjla_eventgallery_file` AS file
ON folder.folder = file.folder
and file.published=1
and file.ismainimage=01 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down
FROM sjla_modules AS m
LEFT JOIN sjla_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
LEFT JOIN sjla_advancedmodules as am
ON am.moduleid = m.id
OTHER Tables:
1 × INSERT INTO `sjla_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'323263616e73766e70396e337062666b70737474683133723133', 1, 1743558127, 0, '', 01 × UPDATE `sjla_extensions`
SET `params` = '{\"mediaversion\":\"d80f8404f54f53ac526114b1e2a815a4\"}'