Open Source Content Management
Nav view search
Navigation
- ACASA
- MASURI DE FINANTARE
- CALENDAR DE SESIUNI
- ANIMARE
- APELURI DE SELECTIE
- DOCUMENTE IN CONSULTARE
- PROIECTE
- UTILE
Search
Joomla! Debug Console
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1714658367,
"last": 1714658367,
"now": 1714658367
},
"token": "KoLJRNxC0xotcXJ8u3xVe7ClxhC0RZup"
},
"registry": {},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
},
"vvisit_counter": {
"lastlog": 1714658400
}
}
}
Time
Memory
Time: 19.84 ms / 19.84 ms Memory: 2.016 MB / 2.39 MB Application: afterLoad
Time: 64.88 ms / 84.72 ms Memory: 4.518 MB / 6.91 MB Application: afterInitialise
Time: 18.52 ms / 103.23 ms Memory: 1.504 MB / 8.41 MB Application: afterRoute
Time: 9.50 ms / 112.73 ms Memory: 0.368 MB / 8.78 MB Application: beforeRenderComponent com_content
Time: 5.25 ms / 117.97 ms Memory: 0.455 MB / 9.24 MB Application: Before Access::preloadComponents (all components)
Time: 2.63 ms / 120.60 ms Memory: 0.057 MB / 9.29 MB Application: After Access::preloadComponents (all components)
Time: 0.03 ms / 120.63 ms Memory: -0.003 MB / 9.29 MB Application: Before Access::preloadPermissions (com_content)
Time: 1.82 ms / 122.45 ms Memory: 0.183 MB / 9.47 MB Application: After Access::preloadPermissions (com_content)
Time: 0.03 ms / 122.48 ms Memory: -0.011 MB / 9.46 MB Application: Before Access::getAssetRules (id:301 name:com_content.article.56)
Time: 0.50 ms / 122.98 ms Memory: 0.027 MB / 9.49 MB Application: After Access::getAssetRules (id:301 name:com_content.article.56)
Time: 34.66 ms / 157.64 ms Memory: 1.723 MB / 11.21 MB Application: afterRenderComponent com_content
Time: 5.55 ms / 163.20 ms Memory: 0.195 MB / 11.41 MB Application: afterDispatch
Time: 7.94 ms / 171.14 ms Memory: 0.213 MB / 11.62 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Time: 0.04 ms / 171.18 ms Memory: 0.007 MB / 11.63 MB Application: After Access::getAssetRules (id:1 name:root.1)
Time: 0.83 ms / 172.01 ms Memory: 0.056 MB / 11.68 MB Application: beforeRenderModule mod_accordeonck (Left cat (2))
Time: 12.94 ms / 184.95 ms Memory: 0.541 MB / 12.22 MB Application: afterRenderModule mod_accordeonck (Left cat (2))
Time: 0.04 ms / 185.00 ms Memory: -0.050 MB / 12.17 MB Application: beforeRenderModule mod_search (Search)
Time: 0.85 ms / 185.85 ms Memory: 0.018 MB / 12.19 MB Application: afterRenderModule mod_search (Search)
Time: 0.03 ms / 185.88 ms Memory: 0.007 MB / 12.20 MB Application: beforeRenderModule mod_custom (Video Info)
Time: 0.39 ms / 186.27 ms Memory: 0.006 MB / 12.21 MB Application: afterRenderModule mod_custom (Video Info)
Time: 0.04 ms / 186.31 ms Memory: 0.002 MB / 12.21 MB Application: beforeRenderModule mod_vvisit_counter (Total Vizitatori)
Time: 5.17 ms / 191.48 ms Memory: 0.258 MB / 12.47 MB Application: afterRenderModule mod_vvisit_counter (Total Vizitatori)
Time: 0.04 ms / 191.52 ms Memory: -0.010 MB / 12.46 MB Application: beforeRenderModule mod_articles_archive (ARHIVA ARTICOLE)
Time: 1.67 ms / 193.19 ms Memory: 0.027 MB / 12.48 MB Application: afterRenderModule mod_articles_archive (ARHIVA ARTICOLE)
Time: 0.04 ms / 193.23 ms Memory: 0.003 MB / 12.49 MB Application: beforeRenderModule mod_articles_category (ULTIMELE ARTICOLE ADAUGATE)
Time: 3.33 ms / 196.56 ms Memory: 0.276 MB / 12.76 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Time: 0.05 ms / 196.61 ms Memory: 0.007 MB / 12.77 MB Application: After Access::getAssetRules (id:8 name:com_content)
Time: 7.93 ms / 204.55 ms Memory: 0.048 MB / 12.82 MB Application: afterRenderModule mod_articles_category (ULTIMELE ARTICOLE ADAUGATE)
Time: 0.12 ms / 204.66 ms Memory: -0.087 MB / 12.73 MB Application: beforeRenderModule mod_menu (Main Menu)
Time: 30.13 ms / 234.79 ms Memory: 0.807 MB / 13.54 MB Application: afterRenderModule mod_menu (Main Menu)
Time: 7.57 ms / 242.36 ms Memory: 0.241 MB / 13.78 MB Application: afterRender
Database queries total: 39.95 ms
14.06 MB (14,747,528 Bytes)
27 Queries Logged 39.95 ms
- Query Time: 1.16 ms Query memory: 0.023 MB Memory before query: 4.164 MB Rows returned: 0
SELECT `data`
FROM `p6r8n_session`
WHERE `session_id` = X'736f673865306d697376713237706c3664723365747168317638'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE p6r8n_session NULL const PRIMARY PRIMARY 575 const 1 100.00 NULL Status Duration starting 0.18 ms checking permissions 0.03 ms Opening tables 0.05 ms init 0.04 ms System lock 0.03 ms optimizing 0.03 ms statistics 0.08 ms executing 0.49 ms end 0.03 ms query end 0.03 ms closing tables 0.03 ms freeing items 0.09 ms cleaning up 0.03 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.55 ms After last query: 1.44 ms Query memory: 0.020 MB Memory before query: 4.260 MB Rows returned: 0
SELECT `session_id`
FROM `p6r8n_session`
WHERE `session_id` = X'736f673865306d697376713237706c3664723365747168317638'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE p6r8n_session NULL const PRIMARY PRIMARY 575 const 1 100.00 Using index Status Duration starting 0.12 ms checking permissions 0.03 ms Opening tables 0.03 ms init 0.03 ms System lock 0.03 ms optimizing 0.04 ms statistics 0.05 ms executing 0.03 ms end 0.02 ms query end 0.02 ms closing tables 0.03 ms freeing items 0.09 ms cleaning up 0.03 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: 0.62 ms After last query: 0.10 ms Query memory: 0.004 MB Memory before query: 4.265 MB
INSERT INTO `p6r8n_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'736f673865306d697376713237706c3664723365747168317638', 1, 1714658367, 0, '', 0)EXPLAIN not possible on query: INSERT INTO `p6r8n_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'736f673865306d697376713237706c3664723365747168317638', 1, 1714658367, 0, '', 0)Status Duration starting 0.12 ms checking permissions 0.03 ms Opening tables 0.03 ms init 0.03 ms System lock 0.04 ms update 0.11 ms Waiting for query cache lock 0.02 ms update 0.02 ms end 0.02 ms query end 0.03 ms closing tables 0.03 ms freeing items 0.08 ms cleaning up 0.03 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: 1.47 ms After last query: 2.54 ms Query memory: 0.025 MB Memory before query: 4.515 MB Rows returned: 41
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `p6r8n_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE p6r8n_extensions NULL ref extension extension 62 const 41 1.00 Using where Status Duration starting 0.60 ms checking permissions 0.03 ms Opening tables 0.04 ms init 0.04 ms System lock 0.03 ms optimizing 0.03 ms statistics 0.08 ms preparing 0.03 ms executing 0.02 ms Sending data 0.26 ms end 0.02 ms query end 0.02 ms closing tables 0.03 ms freeing items 0.09 ms cleaning up 0.03 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Same as call in the line below. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.60 ms After last query: 2.71 ms Query memory: 0.021 MB Memory before query: 4.706 MB Rows returned: 5
SELECT id, rules
FROM `p6r8n_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE p6r8n_viewlevels NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 5 100.00 NULL Status Duration starting 0.11 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.03 ms System lock 0.03 ms optimizing 0.02 ms statistics 0.03 ms preparing 0.03 ms executing 0.02 ms Sending data 0.06 ms end 0.03 ms query end 0.03 ms closing tables 0.03 ms freeing items 0.09 ms cleaning up 0.03 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: 0.74 ms After last query: 0.09 ms Query memory: 0.021 MB Memory before query: 4.718 MB Rows returned: 2
SELECT b.id
FROM p6r8n_usergroups AS a
LEFT JOIN p6r8n_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE b NULL range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 2 100.00 Using where; Using index Status Duration starting 0.13 ms checking permissions 0.02 ms checking permissions 0.02 ms Opening tables 0.04 ms init 0.04 ms System lock 0.03 ms optimizing 0.03 ms statistics 0.09 ms preparing 0.03 ms executing 0.02 ms Sending data 0.05 ms end 0.02 ms query end 0.03 ms closing tables 0.03 ms freeing items 0.09 ms cleaning up 0.03 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.33 ms After last query: 0.72 ms Query memory: 0.026 MB Memory before query: 4.786 MB Rows returned: 62
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM p6r8n_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE p6r8n_extensions NULL ref extension extension 62 const 85 0.60 Using index condition; Using where; Using filesort Status Duration starting 0.14 ms checking permissions 0.02 ms Opening tables 0.04 ms init 0.05 ms System lock 0.03 ms optimizing 0.03 ms statistics 0.07 ms preparing 0.04 ms Sorting result 0.03 ms executing 0.02 ms Sending data 0.03 ms Creating sort index 0.55 ms end 0.03 ms query end 0.03 ms closing tables 0.03 ms freeing items 0.10 ms cleaning up 0.03 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:351 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:356 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.96 ms After last query: 27.10 ms Query memory: 0.005 MB Memory before query: 6.906 MB
UPDATE p6r8n_vvisit_counter
SET visits=visits+1 , guests=guests+1
WHERE time=1714658400id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE p6r8n_vvisit_counter NULL range PRIMARY,time PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.12 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.03 ms System lock 0.05 ms updating 0.35 ms end 0.03 ms Waiting for query cache lock 0.03 ms end 0.03 ms query end 0.05 ms closing tables 0.03 ms freeing items 0.11 ms cleaning up 0.03 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/plugins/system/vvisit_counter/vvisit_counter.php:109 10 plgSystemVVisit_Counter::_updateRecord() JROOT/plugins/system/vvisit_counter/vvisit_counter.php:75 9 plgSystemVVisit_Counter::_insertRecord() JROOT/plugins/system/vvisit_counter/vvisit_counter.php:43 8 plgSystemVVisit_Counter->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 4.12 ms After last query: 2.23 ms Query memory: 0.232 MB Memory before query: 7.097 MB Rows returned: 203
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM p6r8n_menu AS m
LEFT JOIN p6r8n_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_client_id_parent_id_alias_language NO INDEX KEY COULD BE USED NULL NULL 335 8.48 Using where; Using filesort 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 galtin42_simpli.m.component_id 1 100.00 Using where Status Duration starting 0.16 ms checking permissions 0.02 ms checking permissions 0.02 ms Opening tables 0.04 ms init 0.05 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.10 ms preparing 0.05 ms Sorting result 0.03 ms executing 0.03 ms Sending data 0.05 ms Creating sort index 3.31 ms end 0.03 ms query end 0.02 ms closing tables 0.03 ms freeing items 0.08 ms cleaning up 0.04 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 17 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 14 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:78 13 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 12 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:142 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:417 10 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 9 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:65 8 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 7 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:533 6 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 5 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/libraries/src/Application/CMSApplication.php:1141 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.81 ms After last query: 12.59 ms Query memory: 0.022 MB Memory before query: 8.509 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `p6r8n_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE p6r8n_extensions NULL ref element_clientid,element_folder_clientid,extension extension 364 const,const 1 100.00 NULL Status Duration starting 0.15 ms checking permissions 0.03 ms Opening tables 0.03 ms init 0.04 ms System lock 0.03 ms optimizing 0.03 ms statistics 0.11 ms preparing 0.03 ms executing 0.02 ms Sending data 0.06 ms end 0.02 ms query end 0.03 ms closing tables 0.03 ms freeing items 0.10 ms cleaning up 0.03 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 13 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Same as call in the line below. 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 10 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 9 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 8 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 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: 0.64 ms After last query: 0.41 ms Query memory: 0.005 MB Memory before query: 8.500 MB
UPDATE `p6r8n_extensions`
SET `params` = '{\"mediaversion\":\"aa3296279a8bb8c0a4f0bb4198ac51f9\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE p6r8n_extensions NULL range element_clientid,element_folder_clientid,extension extension 364 const,const 1 100.00 Using where Status Duration starting 0.12 ms checking permissions 0.03 ms Opening tables 0.04 ms init 0.03 ms System lock 0.07 ms updating 0.07 ms end 0.02 ms Waiting for query cache lock 0.02 ms end 0.02 ms query end 0.03 ms closing tables 0.03 ms freeing items 0.08 ms cleaning up 0.03 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: 0.76 ms After last query: 2.59 ms Query memory: 0.019 MB Memory before query: 8.681 MB Rows returned: 1
SELECT *
FROM p6r8n_languages
WHERE published=1
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE p6r8n_languages NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where; Using filesort Status Duration starting 0.11 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.04 ms System lock 0.02 ms optimizing 0.04 ms statistics 0.03 ms preparing 0.03 ms Sorting result 0.02 ms executing 0.02 ms Sending data 0.04 ms Creating sort index 0.08 ms end 0.03 ms query end 0.03 ms closing tables 0.03 ms freeing items 0.10 ms cleaning up 0.03 ms # Caller File and line number 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 6 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 5 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 4 Joomla\CMS\Application\SiteApplication->getParams() JROOT/libraries/src/Application/SiteApplication.php:138 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.13 ms After last query: 1.53 ms Query memory: 0.067 MB Memory before query: 8.692 MB Rows returned: 13
SELECT id, home, template, s.params
FROM p6r8n_template_styles as s
LEFT JOIN p6r8n_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e NULL ref element_clientid,element_folder_clientid,extension extension 62 const 5 1.00 Using index condition; Using where 1 SIMPLE s NULL ref idx_template idx_template 152 galtin42_simpli.e.element 3 10.00 Using index condition; Using where Status Duration starting 0.13 ms checking permissions 0.02 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.04 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.07 ms preparing 0.04 ms executing 0.02 ms Sending data 0.50 ms end 0.03 ms query end 0.02 ms closing tables 0.03 ms freeing items 0.08 ms cleaning up 0.03 ms # Caller File and line number 6 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 5 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 4 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/Application/SiteApplication.php:168 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.42 ms After last query: 6.62 ms Query memory: 0.028 MB Memory before query: 9.240 MB Rows returned: 41
SELECT `id`,`name`,`rules`,`parent_id`
FROM `p6r8n_assets`
WHERE `name` IN ('root.1','com_admin','com_aimysitemap','com_ajax','com_akeeba','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_creativecontactform','com_djimageslider','com_eventgallery','com_finder','com_installer','com_jabuilder','com_jaextmanager','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_nextend2','com_plugins','com_postinstall','com_redirect','com_search','com_sitemapgenerator','com_smartslider3','com_tags','com_templates','com_users','com_wrapper')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE p6r8n_assets NULL ALL idx_asset_name NO INDEX KEY COULD BE USED NULL NULL 397 10.58 Using where Status Duration starting 0.18 ms checking permissions 0.03 ms Opening tables 0.03 ms init 0.09 ms System lock 0.03 ms optimizing 0.03 ms statistics 0.13 ms preparing 0.03 ms executing 0.02 ms Sending data 1.61 ms end 0.03 ms query end 0.02 ms closing tables 0.03 ms freeing items 0.09 ms cleaning up 0.03 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 16 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.30 ms After last query: 0.18 ms Query memory: 0.070 MB Memory before query: 9.291 MB Rows returned: 178
SELECT `id`,`name`,`rules`,`parent_id`
FROM `p6r8n_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE p6r8n_assets NULL ALL idx_asset_name,idx_parent_id NO INDEX KEY COULD BE USED NULL NULL 397 23.64 Using where Status Duration starting 0.10 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.04 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.07 ms preparing 0.25 ms executing 0.02 ms Sending data 0.51 ms end 0.02 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.08 ms cleaning up 0.03 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 16 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.85 ms After last query: 1.68 ms Query memory: 0.031 MB Memory before query: 9.530 MB Rows returned: 30
SHOW FULL COLUMNS
FROM `p6r8n_content`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `p6r8n_content`Status Duration starting 0.11 ms checking permissions 0.02 ms checking permissions 0.02 ms Opening tables 0.22 ms init 0.03 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.03 ms preparing 0.03 ms executing 0.03 ms Opening tables 0.04 ms checking permissions 0.06 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms Sending data 0.13 ms end 0.02 ms query end 0.02 ms closing tables 0.02 ms removing tmp table 0.06 ms closing tables 0.03 ms freeing items 0.09 ms cleaning up 0.03 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 12 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Content.php:39 11 Joomla\CMS\Table\Content->__construct() JROOT/libraries/src/Table/Table.php:328 10 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_content/models/article.php:253 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.49 ms After last query: 3.09 ms Query memory: 0.006 MB Memory before query: 9.768 MB
UPDATE p6r8n_content
SET `hits` = (`hits` + 1)
WHERE `id` = '56'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE p6r8n_content NULL range PRIMARY PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.13 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.03 ms System lock 0.06 ms updating 0.09 ms end 0.86 ms Waiting for query cache lock 0.02 ms end 0.03 ms query end 0.04 ms closing tables 0.03 ms freeing items 0.09 ms cleaning up 0.03 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1264 10 Joomla\CMS\Table\Table->hit() JROOT/components/com_content/models/article.php:254 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.32 ms After last query: 1.88 ms Query memory: 0.023 MB Memory before query: 9.891 MB Rows returned: 1
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM p6r8n_content AS a
INNER JOIN p6r8n_categories AS c
on c.id = a.catid
LEFT JOIN p6r8n_users AS u
on u.id = a.created_by
LEFT JOIN p6r8n_categories as parent
ON parent.id = c.parent_id
LEFT JOIN p6r8n_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 56
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-05-02 13:59:27')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-02 13:59:27')
AND (a.state = 1 OR a.state =2)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY,idx_state,idx_catid PRIMARY 4 const 1 100.00 NULL 1 SIMPLE c NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE u NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE parent NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE v NULL const PRIMARY PRIMARY 4 const 0 0.00 unique row not found Status Duration starting 0.47 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms Opening tables 0.05 ms init 0.09 ms System lock 0.03 ms optimizing 0.04 ms statistics 0.14 ms preparing 0.03 ms executing 0.02 ms Sending data 0.09 ms end 0.02 ms query end 0.02 ms closing tables 0.03 ms freeing items 0.09 ms cleaning up 0.03 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:151 12 ContentModelArticle->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/article/view.html.php:42 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.97 ms After last query: 2.84 ms Query memory: 0.028 MB Memory before query: 10.112 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 `p6r8n_categories` AS `s`
INNER JOIN `p6r8n_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 = 27
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 NULL 1 SIMPLE c NULL range cat_idx,idx_access,idx_left_right idx_left_right 4 NULL 3 30.77 Using index condition; Using where Status Duration starting 0.20 ms checking permissions 0.02 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.07 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.14 ms preparing 0.04 ms Sorting result 0.02 ms executing 0.02 ms Sending data 0.10 ms end 0.02 ms query end 0.02 ms closing tables 0.03 ms freeing items 0.10 ms cleaning up 0.03 ms # Caller File and line number 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 23 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 22 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 21 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 20 ContentRouter->getCategorySegment() Same as call in the line below. 19 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 18 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 17 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 16 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 15 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 14 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 13 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 12 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 11 Joomla\CMS\Router\Route::_() JROOT/components/com_content/views/article/view.html.php:71 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.04 ms After last query: 0.84 ms Query memory: 0.022 MB Memory before query: 10.164 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `p6r8n_contentitem_tag_map` AS m
INNER JOIN `p6r8n_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 56
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type NO INDEX KEY COULD BE USED NULL NULL 20 5.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 galtin42_simpli.m.tag_id 1 100.00 Using where Status Duration starting 0.35 ms checking permissions 0.02 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.06 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.09 ms preparing 0.03 ms executing 0.02 ms Sending data 0.09 ms end 0.02 ms query end 0.02 ms closing tables 0.03 ms freeing items 0.08 ms cleaning up 0.03 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 11 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/views/article/view.html.php:184 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.35 ms After last query: 9.72 ms Query memory: 0.023 MB Memory before query: 10.800 MB Rows returned: 1
SELECT MAX(contact.id) AS contactid, contact.alias, contact.catid, contact.webpage, contact.email_to
FROM `p6r8n_contact_details` AS `contact`
WHERE contact.published = 1
AND contact.user_id = 42id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE contact NULL ref idx_state idx_state 1 const 1 100.00 Using where Status Duration starting 0.13 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.06 ms System lock 0.03 ms optimizing 0.67 ms statistics 0.06 ms preparing 0.03 ms executing 0.02 ms Sending data 0.05 ms end 0.02 ms query end 0.02 ms closing tables 0.03 ms freeing items 0.09 ms cleaning up 0.03 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 15 JDatabaseDriver->loadObject() JROOT/plugins/content/contact/contact.php:125 14 PlgContentContact->getContactData() JROOT/plugins/content/contact/contact.php:66 13 PlgContentContact->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.72 ms After last query: 8.11 ms Query memory: 0.020 MB Memory before query: 11.225 MB Rows returned: 0
SELECT folder.*
FROM `p6r8n_eventgallery_folder` AS folder
LEFT JOIN `p6r8n_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=2id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE folder NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where 1 SIMPLE file NULL ALL file,index_folder NO INDEX KEY COULD BE USED NULL NULL 60 100.00 Using where; Using join buffer (Block Nested Loop) Status Duration starting 0.16 ms checking permissions 0.03 ms checking permissions 0.03 ms Opening tables 0.04 ms init 0.07 ms System lock 0.03 ms optimizing 0.04 ms statistics 0.06 ms preparing 0.07 ms executing 0.03 ms Sending data 0.09 ms end 0.03 ms query end 0.03 ms closing tables 0.03 ms freeing items 0.11 ms cleaning up 1.06 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:66 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: 2.30 ms After last query: 4.95 ms Query memory: 0.040 MB Memory before query: 11.549 MB Rows returned: 14
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM p6r8n_modules AS m
LEFT JOIN p6r8n_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN p6r8n_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-05-02 13:59:27')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-02 13:59:27')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 405 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL range PRIMARY,published,newsfeeds published 5 NULL 68 1.60 Using index condition; Using where; Using filesort 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 303 galtin42_simpli.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 galtin42_simpli.m.id 2 40.00 Using where; Using index Status Duration starting 0.20 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms Opening tables 0.05 ms init 0.08 ms System lock 0.03 ms optimizing 0.04 ms statistics 0.14 ms preparing 0.06 ms Sorting result 0.03 ms executing 0.02 ms Sending data 0.03 ms Creating sort index 1.34 ms end 0.03 ms query end 0.03 ms closing tables 0.03 ms freeing items 0.11 ms cleaning up 0.03 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 12 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 11 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 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/beez3/index.php:18 7 require JROOT/templates/beez3/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.37 ms After last query: 8.72 ms Query memory: 0.125 MB Memory before query: 12.023 MB Rows returned: 79
SELECT *
FROM p6r8n_modules
WHERE published=1
ORDER BY id ;id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE p6r8n_modules NULL ref published published 1 const 79 100.00 Using index condition; Using filesort Status Duration starting 0.15 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.04 ms System lock 0.03 ms optimizing 0.03 ms statistics 0.05 ms preparing 0.03 ms Sorting result 0.03 ms executing 0.02 ms Sending data 0.04 ms Creating sort index 0.67 ms end 0.03 ms query end 0.03 ms closing tables 0.03 ms freeing items 0.09 ms cleaning up 0.03 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/modules/mod_accordeonck/helper.php:251 12 modAccordeonckHelper::CreateModulesList() JROOT/modules/mod_accordeonck/helper.php:45 11 modAccordeonckHelper::GetItems() JROOT/modules/mod_accordeonck/mod_accordeonck.php:21 10 include JROOT/modules/mod_accordeonck/mod_accordeonck.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.73 ms After last query: 10.96 ms Query memory: 0.022 MB Memory before query: 12.347 MB Rows returned: 1
SELECT SUM(visits) AS visits
FROM p6r8n_vvisit_counter
WHERE time > 1714608000id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE p6r8n_vvisit_counter NULL range PRIMARY,time PRIMARY 4 NULL 53 100.00 Using where Status Duration starting 0.12 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.03 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.03 ms executing 0.03 ms Sending data 0.09 ms end 0.02 ms query end 0.03 ms closing tables 0.03 ms freeing items 0.10 ms cleaning up 0.03 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 12 JDatabaseDriver->loadResult() JROOT/plugins/system/vvisit_counter/helper/vvisit_counter.php:153 11 plgVVisitCounterHelper::getVisitsByType() JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:138 10 include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.98 ms After last query: 3.09 ms Query memory: 0.022 MB Memory before query: 12.493 MB Rows returned: 0
SELECT MONTH(`created`) AS created_month,MIN(`created`) AS created,YEAR(`created`) AS created_year
FROM p6r8n_content
WHERE state = 2
GROUP BY YEAR(`created`), MONTH(`created`)
ORDER BY YEAR(`created`) DESC, MONTH(`created`) DESC
LIMIT 10id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE p6r8n_content NULL ref idx_state idx_state 1 const 1 100.00 Using index condition; Using temporary; Using filesort Status Duration starting 0.17 ms checking permissions 0.03 ms Opening tables 0.03 ms init 0.05 ms System lock 0.03 ms optimizing 0.03 ms statistics 0.07 ms preparing 0.04 ms Creating tmp table 0.05 ms Sorting result 0.03 ms executing 0.02 ms Sending data 0.05 ms Creating sort index 0.04 ms end 0.02 ms query end 0.03 ms removing tmp table 0.03 ms query end 0.02 ms closing tables 0.03 ms freeing items 0.10 ms cleaning up 0.03 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/modules/mod_articles_archive/helper.php:51 11 ModArchiveHelper::getList() JROOT/modules/mod_articles_archive/mod_articles_archive.php:17 10 include JROOT/modules/mod_articles_archive/mod_articles_archive.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 6.25 ms After last query: 3.71 ms Query memory: 0.044 MB Memory before query: 12.767 MB Rows returned: 5
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM p6r8n_content AS a
LEFT JOIN p6r8n_categories AS c
ON c.id = a.catid
LEFT JOIN p6r8n_users AS ua
ON ua.id = a.created_by
LEFT JOIN p6r8n_users AS uam
ON uam.id = a.modified_by
LEFT JOIN p6r8n_categories as parent
ON parent.id = c.parent_id
LEFT JOIN p6r8n_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.catid IN (27)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-05-02 13:59:27')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-02 13:59:27')
ORDER BY a.title ASC
LIMIT 5id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL const PRIMARY,idx_access PRIMARY 4 const 1 100.00 Using temporary; Using filesort 1 SIMPLE a NULL ref idx_access,idx_state,idx_catid idx_state 1 const 107 13.89 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 galtin42_simpli.a.created_by 1 100.00 Using where 1 SIMPLE uam NULL eq_ref PRIMARY PRIMARY 4 galtin42_simpli.a.modified_by 1 100.00 Using where 1 SIMPLE parent NULL const PRIMARY PRIMARY 4 const 1 100.00 Using where 1 SIMPLE v NULL ALL PRIMARY NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where; Using join buffer (Block Nested Loop) Status Duration starting 0.36 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms Opening tables 0.05 ms init 0.15 ms System lock 0.03 ms optimizing 0.04 ms statistics 0.16 ms preparing 0.06 ms Creating tmp table 0.09 ms Sorting result 0.02 ms executing 0.02 ms Sending data 4.40 ms Creating sort index 0.27 ms end 0.02 ms query end 0.02 ms removing tmp table 0.14 ms query end 0.02 ms closing tables 0.03 ms freeing items 0.10 ms cleaning up 0.03 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/modules/mod_articles_category/helper.php:224 14 ModArticlesCategoryHelper::getList() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 12 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:566 11 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/modules/mod_articles_category/mod_articles_category.php:61 10 include JROOT/modules/mod_articles_category/mod_articles_category.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
25 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `p6r8n_extensions`2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `p6r8n_assets`1 × SELECT `data`
FROM `p6r8n_session`1 × SELECT `session_id`
FROM `p6r8n_session`1 × SELECT id, rules
FROM `p6r8n_viewlevels1 × SELECT b.id
FROM p6r8n_usergroups AS a
LEFT JOIN p6r8n_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM p6r8n_extensions1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM p6r8n_menu AS m
LEFT JOIN p6r8n_extensions AS e
ON m.component_id = e.extension_id1 × SELECT *
FROM p6r8n_languages1 × SELECT id, home, template, s.params
FROM p6r8n_template_styles as s
LEFT JOIN p6r8n_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM p6r8n_content AS a
INNER JOIN p6r8n_categories AS c
on c.id = a.catid
LEFT JOIN p6r8n_users AS u
on u.id = a.created_by
LEFT JOIN p6r8n_categories as parent
ON parent.id = c.parent_id
LEFT JOIN p6r8n_content_rating AS v
ON a.id = v.content_id1 × 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 `p6r8n_categories` AS `s`
INNER JOIN `p6r8n_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)1 × SELECT `m`.`tag_id`,`t`.*
FROM `p6r8n_contentitem_tag_map` AS m
INNER JOIN `p6r8n_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT MAX(contact.id) AS contactid, contact.alias, contact.catid, contact.webpage, contact.email_to
FROM `p6r8n_contact_details` AS `contact`1 × SELECT folder.*
FROM `p6r8n_eventgallery_folder` AS folder
LEFT JOIN `p6r8n_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, mm.menuid
FROM p6r8n_modules AS m
LEFT JOIN p6r8n_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN p6r8n_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT *
FROM p6r8n_modules1 × SELECT SUM(visits) AS visits
FROM p6r8n_vvisit_counter1 × SELECT MONTH(`created`) AS created_month,MIN(`created`) AS created,YEAR(`created`) AS created_year
FROM p6r8n_content1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM p6r8n_content AS a
LEFT JOIN p6r8n_categories AS c
ON c.id = a.catid
LEFT JOIN p6r8n_users AS ua
ON ua.id = a.created_by
LEFT JOIN p6r8n_users AS uam
ON uam.id = a.modified_by
LEFT JOIN p6r8n_categories as parent
ON parent.id = c.parent_id
LEFT JOIN p6r8n_content_rating AS v
ON a.id = v.content_id
OTHER Tables:
1 × INSERT INTO `p6r8n_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'736f673865306d697376713237706c3664723365747168317638', 1, 1714658367, 0, '', 01 × UPDATE p6r8n_vvisit_counter
SET visits=visits+1 , guests=guests+11 × UPDATE `p6r8n_extensions`
SET `params` = '{\"mediaversion\":\"aa3296279a8bb8c0a4f0bb4198ac51f9\"}'1 × SHOW FULL COLUMNS
FROM `p6r8n_content1 × UPDATE p6r8n_content
SET `hits` = (`hits` + 1)