ජනවාරිය තවම කළු යි 2020
මාධ්යවේදීන්ගේ ආරක්ෂාව සඳහා සාමුහිකව පෙරට
ජනවාරි 28 පස්වරු 3ට
සංවාදාත්මක කතිකාව
ශ්රී ලංකා පුවත්පත් ආයතන ශ්රවණාගාරයේ දී....
අතන මෙතන
ජනවාරිය තවම කළු යි 2020....
-
Category
අතන මෙතන -
Hits
1755 times
අතන මෙතන
Joomla! Debug Console
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1685312142,
"last": 1685312142,
"now": 1685312142
},
"token": "1v0eJdcSKEeHNsItt4WooPxFqJcG5UAX"
},
"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
},
"plg_system_languagefilter": {
"language": "en-GB"
}
}
}
Time
Memory
Time: 2.17 ms / 2.17 ms Memory: 0.424 MB / 0.75 MB Application: afterLoad
Time: 24.48 ms / 26.65 ms Memory: 1.615 MB / 2.36 MB Application: afterInitialise
Time: 14.09 ms / 40.74 ms Memory: 0.556 MB / 2.92 MB Application: afterRoute
Time: 0.85 ms / 41.59 ms Memory: 0.096 MB / 3.02 MB Application: beforeRenderComponent com_content
Time: 0.54 ms / 42.13 ms Memory: 0.043 MB / 3.06 MB Application: Before Access::preloadComponents (all components)
Time: 1.20 ms / 43.33 ms Memory: 0.065 MB / 3.12 MB Application: After Access::preloadComponents (all components)
Time: 0.02 ms / 43.35 ms Memory: -0.004 MB / 3.12 MB Application: Before Access::preloadPermissions (com_content)
Time: 18.14 ms / 61.50 ms Memory: 5.502 MB / 8.62 MB Application: After Access::preloadPermissions (com_content)
Time: 0.23 ms / 61.72 ms Memory: -0.253 MB / 8.37 MB Application: Before Access::getAssetRules (id:6819 name:com_content.article.6286)
Time: 0.23 ms / 61.95 ms Memory: 0.017 MB / 8.39 MB Application: After Access::getAssetRules (id:6819 name:com_content.article.6286)
Time: 44.86 ms / 106.82 ms Memory: 0.792 MB / 9.18 MB Application: afterRenderComponent com_content
Time: 1.65 ms / 108.46 ms Memory: 0.027 MB / 9.21 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Time: 0.10 ms / 108.57 ms Memory: 0.007 MB / 9.21 MB Application: After Access::getAssetRules (id:8 name:com_content)
Time: 0.98 ms / 109.55 ms Memory: 0.019 MB / 9.23 MB Application: afterDispatch
Time: 36.72 ms / 146.27 ms Memory: 0.311 MB / 9.54 MB Application: beforeRenderModule mod_syndicate (RSS)
Time: 0.39 ms / 146.66 ms Memory: 0.007 MB / 9.55 MB Application: afterRenderModule mod_syndicate (RSS)
Time: 0.05 ms / 146.72 ms Memory: 0.000 MB / 9.55 MB Application: beforeRenderModule mod_pagescrollbuttons (Page scroll buttons)
Time: 0.34 ms / 147.05 ms Memory: 0.018 MB / 9.57 MB Application: afterRenderModule mod_pagescrollbuttons (Page scroll buttons)
Time: 0.49 ms / 147.54 ms Memory: 0.018 MB / 9.59 MB Application: beforeRenderModule mod_ghgtlikebox (Ghgt Facebook Likebox)
Time: 0.09 ms / 147.63 ms Memory: 0.006 MB / 9.59 MB Application: afterRenderModule mod_ghgtlikebox (Ghgt Facebook Likebox)
Time: 5.05 ms / 152.68 ms Memory: 0.592 MB / 10.18 MB Application: afterRender
Database queries total: 48.79 ms
10.70 MB (11,218,584 Bytes)
50 Queries Logged 48.79 ms
- Query Time: 0.29 ms Query memory: 0.020 MB Memory before query: 1.039 MB Rows returned: 0
SELECT `session_id`
FROM `x1nkc_session`
WHERE `session_id` = X'6364323066346333363132633966363635653165353038386134303265623865'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x1nkc_session NULL const PRIMARY PRIMARY 194 const 1 100.00 Using index Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms executing 0.02 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 0.56 ms After last query: 0.07 ms Query memory: 0.004 MB Memory before query: 1.044 MB
INSERT INTO `x1nkc_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6364323066346333363132633966363635653165353038386134303265623865', 1, 1685312142, 0, '', 0)EXPLAIN not possible on query: INSERT INTO `x1nkc_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6364323066346333363132633966363635653165353038386134303265623865', 1, 1685312142, 0, '', 0)Status Duration starting 0.03 ms checking permissions 0.02 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms update 0.08 ms Waiting for query cache lock 0.01 ms update 0.00 ms end 0.00 ms query end 0.32 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 0.20 ms After last query: 0.87 ms Query memory: 0.021 MB Memory before query: 1.188 MB Rows returned: 5
SELECT id, rules
FROM `x1nkc_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x1nkc_viewlevels NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 5 100.00 NULL Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.28 ms After last query: 0.07 ms Query memory: 0.021 MB Memory before query: 1.200 MB Rows returned: 1
SELECT b.id
FROM x1nkc_usergroups AS a
LEFT JOIN x1nkc_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1id 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 1 100.00 Using where; Using index Status Duration starting 0.04 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.28 ms After last query: 1.78 ms Query memory: 0.021 MB Memory before query: 1.515 MB Rows returned: 6
SELECT `path`
FROM x1nkc_rsfirewall_ignored
WHERE `type`='ignore_folder' OR `type`='ignore_file'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x1nkc_rsfirewall_ignored NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 6 30.56 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 11 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_rsfirewall/helpers/config.php:53 10 RSFirewallConfig->load() JROOT/administrator/components/com_rsfirewall/helpers/config.php:19 9 RSFirewallConfig->__construct() JROOT/administrator/components/com_rsfirewall/helpers/config.php:161 8 RSFirewallConfig::getInstance() JROOT/plugins/system/rsfirewall/rsfirewall.php:29 7 plgSystemRsfirewall->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.27 ms After last query: 0.06 ms Query memory: 0.021 MB Memory before query: 1.522 MB Rows returned: 0
SELECT `file`
FROM x1nkc_rsfirewall_hashes
WHERE `type`='protect'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x1nkc_rsfirewall_hashes NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 60 10.00 Using where Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.11 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 11 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_rsfirewall/helpers/config.php:60 10 RSFirewallConfig->load() JROOT/administrator/components/com_rsfirewall/helpers/config.php:19 9 RSFirewallConfig->__construct() JROOT/administrator/components/com_rsfirewall/helpers/config.php:161 8 RSFirewallConfig::getInstance() JROOT/plugins/system/rsfirewall/rsfirewall.php:29 7 plgSystemRsfirewall->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.31 ms After last query: 0.04 ms Query memory: 0.026 MB Memory before query: 1.526 MB Rows returned: 66
SELECT *
FROM x1nkc_rsfirewall_configurationid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x1nkc_rsfirewall_configuration NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 62 100.00 NULL Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.14 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_rsfirewall/helpers/config.php:68 10 RSFirewallConfig->load() JROOT/administrator/components/com_rsfirewall/helpers/config.php:19 9 RSFirewallConfig->__construct() JROOT/administrator/components/com_rsfirewall/helpers/config.php:161 8 RSFirewallConfig::getInstance() JROOT/plugins/system/rsfirewall/rsfirewall.php:29 7 plgSystemRsfirewall->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.59 ms After last query: 1.55 ms Query memory: 0.024 MB Memory before query: 1.709 MB Rows returned: 10
SHOW FULL COLUMNS
FROM `x1nkc_rsfirewall_logs`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `x1nkc_rsfirewall_logs`Status Duration starting 0.03 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.17 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Opening tables 0.02 ms checking permissions 0.04 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.00 ms removing tmp table 0.04 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 12 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_rsfirewall/tables/logs.php:36 11 RsfirewallTableLogs->__construct() JROOT/libraries/src/Table/Table.php:328 10 Joomla\CMS\Table\Table::getInstance() JROOT/administrator/components/com_rsfirewall/helpers/log.php:23 9 RSFirewallLogger->__construct() JROOT/administrator/components/com_rsfirewall/helpers/log.php:77 8 RSFirewallLogger::getInstance() JROOT/plugins/system/rsfirewall/rsfirewall.php:56 7 plgSystemRsfirewall->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.48 ms After last query: 7.20 ms Query memory: 0.021 MB Memory before query: 2.199 MB Rows returned: 1
SELECT `template`
FROM `x1nkc_template_styles`
WHERE `client_id` = 0
AND `home` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x1nkc_template_styles NULL ref idx_client_id,idx_client_id_home idx_client_id 1 const 4 16.67 Using where Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.02 ms executing 0.00 ms Sending data 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 10 JDatabaseDriver->loadObject() JROOT/plugins/system/helix3/helix3.php:240 9 plgSystemHelix3->getTemplateName() JROOT/plugins/system/helix3/helix3.php:38 8 plgSystemHelix3->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: 0.56 ms After last query: 4.18 ms Query memory: 0.022 MB Memory before query: 2.527 MB Rows returned: 0
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 `x1nkc_categories` AS `s`
INNER JOIN `x1nkc_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('en-GB','*')) 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)
AND c.published = 1
AND s.id = 6286
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL no matching row in const table Status Duration starting 0.17 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.07 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms executing 0.03 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 12 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 11 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/helpers/legacyrouter.php:350 10 ContentRouterRulesLegacy->parse() JROOT/libraries/src/Component/Router/RouterView.php:266 9 Joomla\CMS\Component\Router\RouterView->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1142 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.21 ms After last query: 0.07 ms Query memory: 0.021 MB Memory before query: 2.532 MB Rows returned: 1
SELECT `alias`,`catid`
FROM `x1nkc_content`
WHERE `id` = 6286id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x1nkc_content NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 11 JDatabaseDriver->loadObject() JROOT/components/com_content/helpers/legacyrouter.php:366 10 ContentRouterRulesLegacy->parse() JROOT/libraries/src/Component/Router/RouterView.php:266 9 Joomla\CMS\Component\Router\RouterView->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1142 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.29 ms After last query: 0.11 ms Query memory: 0.020 MB Memory before query: 2.537 MB Rows returned: 0
SELECT *
FROM x1nkc_rsfirewall_hashes
WHERE (`type`='3.10.11' OR `type`='protect')
AND `flag`!='C'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x1nkc_rsfirewall_hashes NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 60 17.10 Using where Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.11 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/plugins/system/rsfirewall/rsfirewall.php:1068 8 plgSystemRsfirewall->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.20 ms After last query: 0.08 ms Query memory: 0.021 MB Memory before query: 2.544 MB Rows returned: 0
SELECT *
FROM x1nkc_rsfirewall_snapshots
WHERE `type`='protect'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x1nkc_rsfirewall_snapshots NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.02 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_rsfirewall/helpers/snapshot.php:47 9 RSFirewallSnapshot::get() JROOT/plugins/system/rsfirewall/rsfirewall.php:1091 8 plgSystemRsfirewall->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.27 ms After last query: 0.07 ms Query memory: 0.021 MB Memory before query: 2.550 MB Rows returned: 0
SELECT `ip`,`reason`
FROM x1nkc_rsfirewall_lists
WHERE (`ip`='3.239.8.7' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%')
AND `type`='1'
AND `published`='1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x1nkc_rsfirewall_lists NULL ref published,type,ip type 1 const 1 36.79 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/rsfirewall/rsfirewall.php:174 10 plgSystemRsfirewall->isListed() JROOT/plugins/system/rsfirewall/rsfirewall.php:153 9 plgSystemRsfirewall->isWhitelisted() JROOT/plugins/system/rsfirewall/rsfirewall.php:1127 8 plgSystemRsfirewall->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.34 ms After last query: 0.06 ms Query memory: 0.021 MB Memory before query: 2.555 MB Rows returned: 0
SELECT `ip`,`reason`
FROM x1nkc_rsfirewall_lists
WHERE (`ip`='3.239.8.7' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%')
AND `type`='0'
AND `published`='1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x1nkc_rsfirewall_lists NULL ALL published,type,ip NO INDEX KEY COULD BE USED NULL NULL 35 36.79 Using where Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms executing 0.00 ms Sending data 0.09 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/rsfirewall/rsfirewall.php:174 10 plgSystemRsfirewall->isListed() JROOT/plugins/system/rsfirewall/rsfirewall.php:143 9 plgSystemRsfirewall->isBlacklisted() JROOT/plugins/system/rsfirewall/rsfirewall.php:1131 8 plgSystemRsfirewall->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.22 ms After last query: 0.22 ms Query memory: 0.021 MB Memory before query: 2.561 MB Rows returned: 0
SELECT *
FROM x1nkc_rsfirewall_exceptions
WHERE `published`='1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x1nkc_rsfirewall_exceptions NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/plugins/system/rsfirewall/rsfirewall.php:719 9 plgSystemRsfirewall->isException() JROOT/plugins/system/rsfirewall/rsfirewall.php:1262 8 plgSystemRsfirewall->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.62 ms After last query: 4.98 ms Query memory: 0.007 MB Memory before query: 2.740 MB
UPDATE `x1nkc_extensions`
SET `params` = '{\"mediaversion\":\"b135ded651cfee8e4245e71560f64599\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE x1nkc_extensions NULL range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.08 ms updating 0.11 ms end 0.01 ms Waiting for query cache lock 0.00 ms end 0.01 ms query end 0.26 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 13 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 12 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/sbsynchronizer/sbsynchronizer.php:90 8 PlgSystemSBSynchronizer->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: 0.47 ms After last query: 0.87 ms Query memory: 0.027 MB Memory before query: 2.797 MB Rows returned: 4
SHOW FULL COLUMNS
FROM `x1nkc_socialbacklinks_configs`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `x1nkc_socialbacklinks_configs`Status Duration starting 0.02 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.13 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Opening tables 0.01 ms checking permissions 0.03 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Sending data 0.04 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.06 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 24 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 23 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 22 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 21 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_socialbacklinks/tables/config.php:35 20 SBTablesConfig->__construct() JROOT/libraries/src/Table/Table.php:328 19 Joomla\CMS\Table\Table::getInstance() JROOT/libraries/src/MVC/Factory/LegacyFactory.php:110 18 Joomla\CMS\MVC\Factory\LegacyFactory->createTable() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:392 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_createTable() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:485 16 Joomla\CMS\MVC\Model\BaseDatabaseModel->getTable() JROOT/administrator/components/com_socialbacklinks/models/base.php:168 15 SBModelsBase->getTable() JROOT/administrator/components/com_socialbacklinks/models/base.php:226 14 SBModelsBase->buildSelect() JROOT/administrator/components/com_socialbacklinks/models/base.php:341 13 SBModelsBase->getList() JROOT/administrator/components/com_socialbacklinks/helpers/config.php:69 12 SBHelpersConfig::getData() JROOT/administrator/components/com_socialbacklinks/helpers/config.php:215 11 SBHelpersConfig::getCategory() JROOT/administrator/components/com_socialbacklinks/helpers/config.php:253 10 SBHelpersConfig::getBasicConfig() JROOT/administrator/components/com_socialbacklinks/helpers/config.php:302 9 SBHelpersConfig::getBasicConfigElem() JROOT/plugins/system/sbsynchronizer/sbsynchronizer.php:92 8 PlgSystemSBSynchronizer->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: 0.18 ms After last query: 0.07 ms Query memory: 0.024 MB Memory before query: 2.874 MB Rows returned: 15
SELECT DISTINCT *
FROM x1nkc_socialbacklinks_configsid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x1nkc_socialbacklinks_configs NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 15 100.00 NULL Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.04 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 14 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_socialbacklinks/models/base.php:345 13 SBModelsBase->getList() JROOT/administrator/components/com_socialbacklinks/helpers/config.php:69 12 SBHelpersConfig::getData() JROOT/administrator/components/com_socialbacklinks/helpers/config.php:215 11 SBHelpersConfig::getCategory() JROOT/administrator/components/com_socialbacklinks/helpers/config.php:253 10 SBHelpersConfig::getBasicConfig() JROOT/administrator/components/com_socialbacklinks/helpers/config.php:302 9 SBHelpersConfig::getBasicConfigElem() JROOT/plugins/system/sbsynchronizer/sbsynchronizer.php:92 8 PlgSystemSBSynchronizer->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: 0.27 ms After last query: 0.13 ms Query memory: 0.022 MB Memory before query: 2.888 MB Rows returned: 1
SELECT *
FROM `x1nkc_extensions`
WHERE `element` = 'sbsynchronizer'
AND `type` = 'plugin'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x1nkc_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 10.00 Using where Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms executing 0.00 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_socialbacklinks/helpers/requirements.php:123 11 SBHelpersRequirements::getPluginsStatusList() JROOT/administrator/components/com_socialbacklinks/helpers/config.php:256 10 SBHelpersConfig::getBasicConfig() JROOT/administrator/components/com_socialbacklinks/helpers/config.php:302 9 SBHelpersConfig::getBasicConfigElem() JROOT/plugins/system/sbsynchronizer/sbsynchronizer.php:92 8 PlgSystemSBSynchronizer->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: 0.25 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 2.893 MB Rows returned: 1
SELECT *
FROM `x1nkc_extensions`
WHERE `element` = 'sbsynchronizer'
AND `type` = 'plugin'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x1nkc_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 10.00 Using where Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.00 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_socialbacklinks/helpers/requirements.php:123 11 SBHelpersRequirements::getPluginsStatusList() JROOT/administrator/components/com_socialbacklinks/helpers/config.php:256 10 SBHelpersConfig::getBasicConfig() JROOT/administrator/components/com_socialbacklinks/helpers/config.php:302 9 SBHelpersConfig::getBasicConfigElem() JROOT/plugins/system/sbsynchronizer/sbsynchronizer.php:141 8 PlgSystemSBSynchronizer->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: 0.18 ms After last query: 0.18 ms Query memory: 0.022 MB Memory before query: 2.907 MB Rows returned: 1
SELECT *
FROM x1nkc_socialbacklinks_configs
WHERE `section` = 'basic'
AND `name` = 'last_sync'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x1nkc_socialbacklinks_configs NULL const section_name section_name 388 const,const 1 100.00 NULL Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 13 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 12 Joomla\CMS\Table\Table->load() JROOT/administrator/components/com_socialbacklinks/models/base.php:359 11 SBModelsBase->getItem() JROOT/administrator/components/com_socialbacklinks/helpers/sync.php:149 10 SBHelpersSync::getLastSyncDate() JROOT/administrator/components/com_socialbacklinks/helpers/sync.php:105 9 SBHelpersSync::isNeedSync() JROOT/plugins/system/sbsynchronizer/sbsynchronizer.php:153 8 PlgSystemSBSynchronizer->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: 0.17 ms After last query: 0.14 ms Query memory: 0.022 MB Memory before query: 2.914 MB Rows returned: 1
SELECT *
FROM x1nkc_socialbacklinks_configs
WHERE `section` = 'basic'
AND `name` = 'sync_periodicity'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x1nkc_socialbacklinks_configs NULL const section_name section_name 388 const,const 1 100.00 NULL Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 12 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 11 Joomla\CMS\Table\Table->load() JROOT/administrator/components/com_socialbacklinks/models/base.php:359 10 SBModelsBase->getItem() JROOT/administrator/components/com_socialbacklinks/helpers/sync.php:110 9 SBHelpersSync::isNeedSync() JROOT/plugins/system/sbsynchronizer/sbsynchronizer.php:153 8 PlgSystemSBSynchronizer->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: 0.25 ms After last query: 0.07 ms Query memory: 0.022 MB Memory before query: 2.914 MB Rows returned: 1
SELECT *
FROM `x1nkc_extensions`
WHERE `element` = 'sbsynchronizer'
AND `type` = 'plugin'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x1nkc_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 10.00 Using where Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.00 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_socialbacklinks/helpers/requirements.php:123 11 SBHelpersRequirements::getPluginsStatusList() JROOT/administrator/components/com_socialbacklinks/helpers/config.php:256 10 SBHelpersConfig::getBasicConfig() JROOT/administrator/components/com_socialbacklinks/helpers/config.php:302 9 SBHelpersConfig::getBasicConfigElem() JROOT/plugins/system/sbsynchronizer/sbsynchronizer.php:157 8 PlgSystemSBSynchronizer->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.06 ms After last query: 1.68 ms Query memory: 0.028 MB Memory before query: 3.066 MB Rows returned: 45
SELECT `id`,`name`,`rules`,`parent_id`
FROM `x1nkc_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_ajax','com_associations','com_banners','com_bt_media','com_cache','com_categories','com_checkin','com_comment','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_jmap','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_rsfirewall','com_search','com_sigpro','com_socialbacklinks','com_speasyimagegallery','com_sppagebuilder','com_sppolls','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 x1nkc_assets NULL range idx_asset_name idx_asset_name 202 NULL 46 100.00 Using index condition Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.12 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.18 ms preparing 0.01 ms executing 0.00 ms Sending data 0.56 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 16 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 11.07 ms After last query: 0.14 ms Query memory: 1.243 MB Memory before query: 3.121 MB Rows returned: 6466
SELECT `id`,`name`,`rules`,`parent_id`
FROM `x1nkc_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 x1nkc_assets NULL ALL idx_asset_name,idx_parent_id NO INDEX KEY COULD BE USED NULL NULL 6977 22.67 Using where Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.01 ms executing 0.00 ms Sending data 10.70 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php: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: 0.90 ms After last query: 7.69 ms Query memory: 0.031 MB Memory before query: 8.389 MB Rows returned: 31
SHOW FULL COLUMNS
FROM `x1nkc_content`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `x1nkc_content`Status Duration starting 0.06 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.18 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.02 ms executing 0.01 ms Opening tables 0.02 ms checking permissions 0.04 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms Sending data 0.10 ms end 0.00 ms query end 0.01 ms closing tables 0.00 ms removing tmp table 0.04 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 12 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Content.php:39 11 Joomla\CMS\Table\Content->__construct() JROOT/libraries/src/Table/Table.php:328 10 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_content/models/article.php:253 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.58 ms After last query: 0.62 ms Query memory: 0.005 MB Memory before query: 8.437 MB
UPDATE x1nkc_content
SET `hits` = (`hits` + 1)
WHERE `id` = '6286'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE x1nkc_content NULL range PRIMARY PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.05 ms updating 0.08 ms end 0.01 ms Waiting for query cache lock 0.00 ms end 0.01 ms query end 0.28 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 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: 0.60 ms After last query: 0.69 ms Query memory: 0.023 MB Memory before query: 8.479 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 x1nkc_content AS a
INNER JOIN x1nkc_categories AS c
on c.id = a.catid
LEFT JOIN x1nkc_users AS u
on u.id = a.created_by
LEFT JOIN x1nkc_categories as parent
ON parent.id = c.parent_id
LEFT JOIN x1nkc_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 6286
AND c.published > 0
AND a.language in ('en-GB','*')
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-05-28 22:15:42')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-05-28 22:15:42')
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,idx_language 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.15 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.07 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.13 ms preparing 0.02 ms executing 0.00 ms Sending data 0.04 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:151 13 ContentModelArticle->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/article/view.html.php:42 11 ContentViewArticle->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.56 ms After last query: 0.69 ms Query memory: 0.028 MB Memory before query: 8.574 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 `x1nkc_categories` AS `s`
INNER JOIN `x1nkc_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('en-GB','*')) 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)
AND c.published = 1
AND s.id = 89
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 Using filesort 1 SIMPLE c NULL ALL cat_idx,idx_access,idx_left_right,idx_language NO INDEX KEY COULD BE USED NULL NULL 63 3.00 Using where Status Duration starting 0.08 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.04 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.12 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.13 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 24 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 23 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 22 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 21 ContentRouter->getCategorySegment() Same as call in the line below. 20 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 19 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 18 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 17 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 16 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 15 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 14 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 13 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 12 Joomla\CMS\Router\Route::_() JROOT/components/com_content/views/article/view.html.php:71 11 ContentViewArticle->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.34 ms After last query: 0.33 ms Query memory: 0.022 MB Memory before query: 8.599 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `x1nkc_contentitem_tag_map` AS m
INNER JOIN `x1nkc_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 6286
AND `t`.`published` = 1
AND t.access IN (1,1)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 114 1.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 mirrora2.m.tag_id 1 100.00 Using where Status Duration starting 0.03 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.00 ms Sending data 0.08 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 12 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/views/article/view.html.php:184 11 ContentViewArticle->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.25 ms After last query: 1.07 ms Query memory: 0.024 MB Memory before query: 8.647 MB Rows returned: 1
SELECT `enabled`
FROM `x1nkc_extensions`
WHERE (`element`='com_sppagebuilder')
AND (`type`='component')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x1nkc_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 10.00 Using where Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 16 JDatabaseDriver->loadResult() JROOT/plugins/content/sppagebuilder/sppagebuilder.php:218 15 PlgContentSppagebuilder->isSppagebuilderEnabled() JROOT/plugins/content/sppagebuilder/sppagebuilder.php:46 14 PlgContentSppagebuilder->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 13 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 12 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/components/com_content/views/article/view.html.php:192 11 ContentViewArticle->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.87 ms Query memory: 0.026 MB Memory before query: 8.694 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 x1nkc_fields AS a
LEFT JOIN `x1nkc_languages` AS l
ON l.lang_code = a.language
LEFT JOIN x1nkc_users AS uc
ON uc.id=a.checked_out
LEFT JOIN x1nkc_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN x1nkc_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN x1nkc_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `x1nkc_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 (89,0))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_state,idx_access,idx_context idx_state 1 const 1 100.00 Using index condition; Using where; Using temporary; Using filesort 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 mirrora2.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 mirrora2.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 mirrora2.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 mirrora2.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 mirrora2.a.group_id 1 100.00 Using where 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 mirrora2.a.id 1 100.00 Using where; Using index; Distinct Status Duration starting 0.10 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.03 ms Creating tmp table 0.05 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.15 ms Creating sort index 0.03 ms end 0.01 ms query end 0.01 ms removing tmp table 0.03 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 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/article/view.html.php:193 11 ContentViewArticle->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: 12.45 ms After last query: 0.45 ms Query memory: 0.024 MB Memory before query: 8.790 MB Rows returned: 0
SELECT *
FROM `x1nkc_sppagebuilder`
WHERE `extension` = 'com_content'
AND `extension_view` = 'article'
AND `view_id` = '6286'
AND `active` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x1nkc_sppagebuilder NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 5927 0.02 Using where Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 12.22 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 17 JDatabaseDriver->loadObject() JROOT/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:307 16 SppagebuilderHelper::getPageContent() JROOT/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:261 15 SppagebuilderHelper::onIntegrationPrepareContent() JROOT/plugins/content/sppagebuilder/sppagebuilder.php:124 14 PlgContentSppagebuilder->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/article/view.html.php:193 11 ContentViewArticle->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.39 ms After last query: 0.11 ms Query memory: 0.024 MB Memory before query: 8.799 MB Rows returned: 1
SELECT MAX(contact.id) AS contactid, contact.alias, contact.catid, contact.webpage, contact.email_to
FROM `x1nkc_contact_details` AS `contact`
WHERE contact.published = 1
AND contact.user_id = 898
AND (contact.language in ('en-GB','*') OR contact.language IS NULL)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE contact NULL ALL idx_state,idx_language NO INDEX KEY COULD BE USED NULL NULL 8 12.50 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.02 ms executing 0.00 ms Sending data 0.05 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 16 JDatabaseDriver->loadObject() JROOT/plugins/content/contact/contact.php:125 15 PlgContentContact->getContactData() JROOT/plugins/content/contact/contact.php:66 14 PlgContentContact->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/article/view.html.php:193 11 ContentViewArticle->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: 5.43 ms After last query: 0.46 ms Query memory: 0.117 MB Memory before query: 8.821 MB Rows returned: 416
SELECT a.id, a.title, a.catid, a.language,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
FROM x1nkc_content AS a
LEFT JOIN x1nkc_categories AS cc
ON cc.id = a.catid
WHERE a.catid = 89
AND a.state = 1
AND a.access IN (1,1)
AND (a.state = 1 OR a.state = -1)
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2023-05-28 22:15:42')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-05-28 22:15:42')
AND a.language in ('en-GB','*')
ORDER BY
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_access,idx_state,idx_catid,idx_language idx_catid 4 const 422 16.00 Using index condition; Using where; Using filesort 1 SIMPLE cc NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.09 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.14 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 4.95 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/plugins/content/pagenavigation/pagenavigation.php:161 14 PlgContentPagenavigation->onContentBeforeDisplay() 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/article/view.html.php:199 11 ContentViewArticle->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.35 ms After last query: 2.28 ms Query memory: 0.025 MB Memory before query: 8.833 MB Rows returned: 1
SELECT *
FROM `x1nkc_extensions`
WHERE `element` = 'sbsynchronizer'
AND `type` = 'plugin'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x1nkc_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 10.00 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms executing 0.00 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_socialbacklinks/helpers/requirements.php:123 17 SBHelpersRequirements::getPluginsStatusList() JROOT/administrator/components/com_socialbacklinks/helpers/config.php:256 16 SBHelpersConfig::getBasicConfig() JROOT/administrator/components/com_socialbacklinks/helpers/config.php:302 15 SBHelpersConfig::getBasicConfigElem() JROOT/plugins/content/sbtrigger/sbtrigger.php:83 14 PlgContentSBTrigger->onContentAfterDisplay() 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/article/view.html.php:202 11 ContentViewArticle->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.21 ms After last query: 0.79 ms Query memory: 0.025 MB Memory before query: 8.857 MB Rows returned: 1
SELECT *
FROM `x1nkc_comment_setting`
WHERE `component`='com_content'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x1nkc_comment_setting NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 19 JDatabaseDriver->loadObject() JROOT/administrator/components/com_comment/library/config.php:84 18 ccommentConfig::_createConfig() JROOT/administrator/components/com_comment/library/config.php:55 17 ccommentConfig::getConfig() JROOT/administrator/components/com_comment/plugins/com_content/content.php:27 16 CcommentComponentContentPlugin->isEnabled() JROOT/components/com_comment/helpers/utils.php:92 15 CcommentHelperUtils::commentInit() JROOT/plugins/content/joscomment/joscomment.php:126 14 PlgContentJoscomment->onContentAfterDisplay() 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/article/view.html.php:202 11 ContentViewArticle->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.01 ms After last query: 1.84 ms Query memory: 0.025 MB Memory before query: 8.936 MB Rows returned: 5
SELECT *
FROM x1nkc_comment_queue
WHERE status = 0
ORDER BY created ASC
LIMIT 5id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x1nkc_comment_queue NULL ref status status 1 const 1589 100.00 Using index condition; Using filesort Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 2.77 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/components/com_comment/helpers/queue.php:40 16 CcommentHelperQueue::send() JROOT/components/com_comment/helpers/utils.php:104 15 CcommentHelperUtils::commentInit() JROOT/plugins/content/joscomment/joscomment.php:126 14 PlgContentJoscomment->onContentAfterDisplay() 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/article/view.html.php:202 11 ContentViewArticle->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.24 ms After last query: 0.83 ms Query memory: 0.025 MB Memory before query: 8.969 MB Rows returned: 1
SELECT COUNT(*)
FROM x1nkc_comment
WHERE contentid='6286'
AND component='com_content'
AND published=1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x1nkc_comment NULL ref com_contentid com_contentid 156 const,const 1 10.00 Using where Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 18 JDatabaseDriver->loadResult() JROOT/components/com_comment/models/comment.php:145 17 CcommentModelComment->countComments() JROOT/components/com_comment/helpers/utils.php:208 16 CcommentHelperUtils::loadSingleView() JROOT/components/com_comment/helpers/utils.php:107 15 CcommentHelperUtils::commentInit() JROOT/plugins/content/joscomment/joscomment.php:126 14 PlgContentJoscomment->onContentAfterDisplay() 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/article/view.html.php:202 11 ContentViewArticle->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.22 ms After last query: 0.25 ms Query memory: 0.025 MB Memory before query: 8.999 MB Rows returned: 0
SELECT *
FROM x1nkc_compojoom_customfields as f
WHERE `f`.`show`='all'
AND `f`.`enabled` = '1'
AND `f`.`component` = 'com_comment'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE f NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/compojoom/model/customfieldsconfig.php:50 18 CompojoomModelCustomfieldsconfig->getFields() JROOT/components/com_comment/views/comments/view.html.php:28 17 ccommentViewComments->display() JROOT/components/com_comment/helpers/utils.php:220 16 CcommentHelperUtils::loadSingleView() JROOT/components/com_comment/helpers/utils.php:107 15 CcommentHelperUtils::commentInit() JROOT/plugins/content/joscomment/joscomment.php:126 14 PlgContentJoscomment->onContentAfterDisplay() 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/article/view.html.php:202 11 ContentViewArticle->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.24 ms After last query: 0.11 ms Query memory: 0.025 MB Memory before query: 9.009 MB Rows returned: 0
SELECT f.*
FROM x1nkc_compojoom_customfields AS f
INNER JOIN x1nkc_compojoom_customfields_cats AS c
ON f.id = c.compojoom_customfields_id
WHERE `f`.`show`='category'
AND `c`.`catid` IN ('1')
AND `f`.`enabled` = '1'
AND `f`.`component` = 'com_comment'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE f NULL ALL PRIMARY NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where 1 SIMPLE c NULL eq_ref PRIMARY PRIMARY 8 mirrora2.f.id,const 1 100.00 Using where; Using index Status Duration starting 0.04 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/compojoom/model/customfieldsconfig.php:69 18 CompojoomModelCustomfieldsconfig->getFields() JROOT/components/com_comment/views/comments/view.html.php:28 17 ccommentViewComments->display() JROOT/components/com_comment/helpers/utils.php:220 16 CcommentHelperUtils::loadSingleView() JROOT/components/com_comment/helpers/utils.php:107 15 CcommentHelperUtils::commentInit() JROOT/plugins/content/joscomment/joscomment.php:126 14 PlgContentJoscomment->onContentAfterDisplay() 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/article/view.html.php:202 11 ContentViewArticle->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.41 ms After last query: 6.93 ms Query memory: 0.021 MB Memory before query: 9.180 MB Rows returned: 2
SELECT language,id
FROM `x1nkc_menu`
WHERE home = 1
AND published = 1
AND client_id = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x1nkc_menu NULL ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 36 1.00 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.03 ms executing 0.00 ms Sending data 0.11 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/Multilanguage.php:107 8 Joomla\CMS\Language\Multilanguage::getSiteHomePages() JROOT/plugins/system/languagefilter/languagefilter.php:751 7 PlgSystemLanguageFilter->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: 0.19 ms After last query: 0.19 ms Query memory: 0.024 MB Memory before query: 9.189 MB Rows returned: 1
SELECT `alias`
FROM `x1nkc_content`
WHERE id = '6286'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x1nkc_content NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 18 JDatabaseDriver->loadResult() JROOT/components/com_content/router.php:125 17 ContentRouter->getArticleSegment() 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/languagefilter/languagefilter.php:763 7 PlgSystemLanguageFilter->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: 0.16 ms After last query: 0.08 ms Query memory: 0.024 MB Memory before query: 9.197 MB Rows returned: 1
SELECT alias
FROM x1nkc_content
WHERE id=6286id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x1nkc_content NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 16 JDatabaseDriver->loadResult() JROOT/components/com_content/helpers/legacyrouter.php:140 15 ContentRouterRulesLegacy->build() JROOT/libraries/src/Component/Router/RouterView.php:244 14 Joomla\CMS\Component\Router\RouterView->build() JROOT/libraries/src/Router/SiteRouter.php:532 13 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 12 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 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/languagefilter/languagefilter.php:763 7 PlgSystemLanguageFilter->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: 0.50 ms After last query: 0.75 ms Query memory: 0.021 MB Memory before query: 9.226 MB Rows returned: 0
SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
FROM `x1nkc_content` AS `c`
INNER JOIN `x1nkc_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_content.item'
INNER JOIN `x1nkc_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `x1nkc_content` AS `c2`
ON a2.id = c2.`id`
INNER JOIN `x1nkc_categories` AS `ca`
ON `c2`.`catid` = ca.id
AND ca.extension = 'com_content'
WHERE c.id = 6286
AND c2.access IN (1,1)
AND c2.language != 'en-GB'
AND (c2.publish_up = '0000-00-00 00:00:00' OR c2.publish_up <= '2023-05-28 22:15:42')
AND (c2.publish_down = '0000-00-00 00:00:00' OR c2.publish_down >= '2023-05-28 22:15:42')
AND c2.state = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL no matching row in const table Status Duration starting 0.10 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.18 ms executing 0.01 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/Associations.php:115 9 Joomla\CMS\Language\Associations::getAssociations() JROOT/components/com_content/helpers/association.php:76 8 ContentHelperAssociation::getAssociations() JROOT/plugins/system/languagefilter/languagefilter.php:783 7 PlgSystemLanguageFilter->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: 0.44 ms After last query: 38.96 ms Query memory: 0.022 MB Memory before query: 9.593 MB Rows returned: 0
SELECT *
FROM x1nkc_jmap_metainfo
WHERE `linkurl` = 'https://www.mirrorarts.lk/events/6286-january-200123'
AND `published` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x1nkc_jmap_metainfo NULL ref published published 1 const 1 100.00 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.08 ms preparing 0.02 ms executing 0.00 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/plugins/system/jmap/jmap.php:529 12 plgSystemJMap->onBeforeCompileHead() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 9 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 8 Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 7 Joomla\CMS\Document\Renderer\Html\HeadRenderer->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.17 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 9.599 MB Rows returned: 0
SELECT *
FROM x1nkc_jmap_canonicals
WHERE `linkurl` = 'https://www.mirrorarts.lk/events/6286-january-200123'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x1nkc_jmap_canonicals NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/plugins/system/jmap/jmap.php:608 12 plgSystemJMap->onBeforeCompileHead() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 9 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 8 Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 7 Joomla\CMS\Document\Renderer\Html\HeadRenderer->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.33 ms After last query: 1.06 ms Query memory: 0.027 MB Memory before query: 9.689 MB Rows returned: 88
SELECT *
FROM x1nkc_acymailing_configid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x1nkc_acymailing_config NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 88 100.00 NULL Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.17 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_acymailing/compat/joomla.php:481 13 acymailing_loadObjectList() JROOT/administrator/components/com_acymailing/classes/cpanel.php:17 12 cpanelClass->load() JROOT/administrator/components/com_acymailing/helpers/helper.php:438 11 acymailing_config() JROOT/administrator/components/com_acymailing/compat/joomla.php:822 10 include_once JROOT/administrator/components/com_acymailing/compat/joomla.php JROOT/administrator/components/com_acymailing/helpers/helper.php:22 9 include_once JROOT/administrator/components/com_acymailing/helpers/helper.php JROOT/plugins/system/regacymailing/regacymailing.php:22 8 plgSystemRegacymailing->initAcy() JROOT/plugins/system/regacymailing/regacymailing.php:146 7 plgSystemRegacymailing->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 - Query Time: 0.19 ms After last query: 1.82 ms Query memory: 0.020 MB Memory before query: 10.180 MB Rows returned: 0
SELECT *
FROM x1nkc_jmap_headings
WHERE `linkurl` = 'https://www.mirrorarts.lk/events/6286-january-200123'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x1nkc_jmap_headings NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 8 JDatabaseDriver->loadObject() JROOT/plugins/system/jmap/jmap.php:924 7 plgSystemJMap->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
43 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
4 × SELECT *
FROM `x1nkc_extensions`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 `x1nkc_categories` AS `s`
INNER JOIN `x1nkc_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('en-GB','*')) OR (c.lft <= s.lft
AND s.rgt <= c.rgt)2 × SELECT `ip`,`reason`
FROM x1nkc_rsfirewall_lists2 × SELECT *
FROM x1nkc_socialbacklinks_configs2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `x1nkc_assets`1 × SELECT `session_id`
FROM `x1nkc_session`1 × SELECT id, rules
FROM `x1nkc_viewlevels1 × SELECT b.id
FROM x1nkc_usergroups AS a
LEFT JOIN x1nkc_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `path`
FROM x1nkc_rsfirewall_ignored1 × SELECT `file`
FROM x1nkc_rsfirewall_hashes1 × SELECT *
FROM x1nkc_rsfirewall_configuratio1 × SELECT `template`
FROM `x1nkc_template_styles`1 × SELECT `alias`,`catid`
FROM `x1nkc_content`1 × SELECT *
FROM x1nkc_rsfirewall_hashes1 × SELECT *
FROM x1nkc_rsfirewall_snapshots1 × SELECT *
FROM x1nkc_rsfirewall_exceptions1 × SELECT DISTINCT *
FROM x1nkc_socialbacklinks_config1 × 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 x1nkc_content AS a
INNER JOIN x1nkc_categories AS c
on c.id = a.catid
LEFT JOIN x1nkc_users AS u
on u.id = a.created_by
LEFT JOIN x1nkc_categories as parent
ON parent.id = c.parent_id
LEFT JOIN x1nkc_content_rating AS v
ON a.id = v.content_id1 × SELECT `m`.`tag_id`,`t`.*
FROM `x1nkc_contentitem_tag_map` AS m
INNER JOIN `x1nkc_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT `enabled`
FROM `x1nkc_extensions`1 × 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 x1nkc_fields AS a
LEFT JOIN `x1nkc_languages` AS l
ON l.lang_code = a.language
LEFT JOIN x1nkc_users AS uc
ON uc.id=a.checked_out
LEFT JOIN x1nkc_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN x1nkc_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN x1nkc_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `x1nkc_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT *
FROM `x1nkc_sppagebuilder`1 × SELECT MAX(contact.id) AS contactid, contact.alias, contact.catid, contact.webpage, contact.email_to
FROM `x1nkc_contact_details` AS `contact`1 × SELECT a.id, a.title, a.catid, a.language,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
FROM x1nkc_content AS a
LEFT JOIN x1nkc_categories AS cc
ON cc.id = a.catid1 × SELECT *
FROM `x1nkc_comment_setting`1 × SELECT *
FROM x1nkc_comment_queue1 × SELECT COUNT(*)
FROM x1nkc_comment1 × SELECT *
FROM x1nkc_compojoom_customfields as f1 × SELECT f.*
FROM x1nkc_compojoom_customfields AS f
INNER JOIN x1nkc_compojoom_customfields_cats AS c
ON f.id = c.compojoom_customfields_id1 × SELECT language,id
FROM `x1nkc_menu`1 × SELECT `alias`
FROM `x1nkc_content`1 × SELECT alias
FROM x1nkc_content1 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
FROM `x1nkc_content` AS `c`
INNER JOIN `x1nkc_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_content.item'
INNER JOIN `x1nkc_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `x1nkc_content` AS `c2`
ON a2.id = c2.`id`
INNER JOIN `x1nkc_categories` AS `ca`
ON `c2`.`catid` = ca.id
AND ca.extension = 'com_content'1 × SELECT *
FROM x1nkc_jmap_metainfo1 × SELECT *
FROM x1nkc_jmap_canonicals1 × SELECT *
FROM x1nkc_acymailing_confi1 × SELECT *
FROM x1nkc_jmap_headings
OTHER Tables:
1 × INSERT INTO `x1nkc_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6364323066346333363132633966363635653165353038386134303265623865', 1, 1685312142, 0, '', 01 × SHOW FULL COLUMNS
FROM `x1nkc_rsfirewall_logs1 × UPDATE `x1nkc_extensions`
SET `params` = '{\"mediaversion\":\"b135ded651cfee8e4245e71560f64599\"}'1 × SHOW FULL COLUMNS
FROM `x1nkc_socialbacklinks_configs1 × SHOW FULL COLUMNS
FROM `x1nkc_content1 × UPDATE x1nkc_content
SET `hits` = (`hits` + 1)