Rate Card and Locations
Rates given below for your consideration
Harshika R Rajapaksha
Marketing Manager
Mobile: +94 77 0400 286
Fixed Line: +94 11 454 6362
දැන්වීම්
දැන්වීම්
User Rating: 1 / 5
-
Category
Uncategorised -
Hits
43386 times
කොටුවෙන් එළියට යන සායාගේ "කොටු"
20-03-2023 විශේෂාංග
Joomla! Debug Console
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1685318467,
"last": 1685318467,
"now": 1685318467
},
"token": "yt6YxJ6woUstH8vcLBTVU0XsY1KliGsP"
},
"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.58 ms / 2.58 ms Memory: 0.424 MB / 0.75 MB Application: afterLoad
Time: 32.66 ms / 35.24 ms Memory: 1.615 MB / 2.36 MB Application: afterInitialise
Time: 15.61 ms / 50.85 ms Memory: 0.539 MB / 2.90 MB Application: afterRoute
Time: 1.05 ms / 51.90 ms Memory: 0.090 MB / 2.99 MB Application: beforeRenderComponent com_content
Time: 0.56 ms / 52.46 ms Memory: 0.043 MB / 3.04 MB Application: Before Access::preloadComponents (all components)
Time: 1.37 ms / 53.83 ms Memory: 0.065 MB / 3.10 MB Application: After Access::preloadComponents (all components)
Time: 0.02 ms / 53.86 ms Memory: -0.004 MB / 3.10 MB Application: Before Access::preloadPermissions (com_content)
Time: 16.92 ms / 70.78 ms Memory: 5.502 MB / 8.60 MB Application: After Access::preloadPermissions (com_content)
Time: 0.23 ms / 71.01 ms Memory: -0.253 MB / 8.35 MB Application: Before Access::getAssetRules (id:1016 name:com_content.article.635)
Time: 0.23 ms / 71.24 ms Memory: 0.010 MB / 8.36 MB Application: After Access::getAssetRules (id:1016 name:com_content.article.635)
Time: 45.33 ms / 116.58 ms Memory: 0.809 MB / 9.17 MB Application: afterRenderComponent com_content
Time: 1.64 ms / 118.21 ms Memory: 0.027 MB / 9.19 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Time: 0.05 ms / 118.26 ms Memory: 0.007 MB / 9.20 MB Application: After Access::getAssetRules (id:8 name:com_content)
Time: 0.87 ms / 119.12 ms Memory: 0.008 MB / 9.21 MB Application: afterDispatch
Time: 38.48 ms / 157.60 ms Memory: 0.326 MB / 9.53 MB Application: beforeRenderModule mod_search (Search)
Time: 0.64 ms / 158.25 ms Memory: 0.016 MB / 9.55 MB Application: afterRenderModule mod_search (Search)
Time: 0.42 ms / 158.66 ms Memory: -0.001 MB / 9.55 MB Application: beforeRenderModule mod_menu (Off Canvas Menu)
Time: 1.74 ms / 160.41 ms Memory: 0.028 MB / 9.58 MB Application: afterRenderModule mod_menu (Off Canvas Menu)
Time: 3.90 ms / 164.30 ms Memory: -0.019 MB / 9.56 MB Application: beforeRenderModule mod_syndicate (RSS)
Time: 0.42 ms / 164.72 ms Memory: 0.006 MB / 9.56 MB Application: afterRenderModule mod_syndicate (RSS)
Time: 0.37 ms / 165.09 ms Memory: 0.064 MB / 9.63 MB Application: beforeRenderModule mod_news_pro_gk5 (Latest News)
Time: 60.96 ms / 226.05 ms Memory: 0.507 MB / 10.13 MB Application: afterRenderModule mod_news_pro_gk5 (Latest News)
Time: 0.85 ms / 226.90 ms Memory: -0.146 MB / 9.99 MB Application: beforeRenderModule mod_sp_social (SP Social)
Time: 0.43 ms / 227.33 ms Memory: 0.010 MB / 10.00 MB Application: afterRenderModule mod_sp_social (SP Social)
Time: 0.45 ms / 227.78 ms Memory: 0.009 MB / 10.01 MB Application: beforeRenderModule mod_search (Search-top)
Time: 0.19 ms / 227.98 ms Memory: 0.007 MB / 10.01 MB Application: afterRenderModule mod_search (Search-top)
Time: 5.02 ms / 232.99 ms Memory: 0.390 MB / 10.40 MB Application: afterRender
Database queries total: 92.73 ms
11.00 MB (11,531,024 Bytes)
55 Queries Logged 92.73 ms
- Query Time: 0.52 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'3630393634333231363138393261363733333738356636633464316335663637'
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.08 ms checking permissions 0.01 ms Opening tables 0.12 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms executing 0.03 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 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.63 ms After last query: 0.09 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'3630393634333231363138393261363733333738356636633464316335663637', 1, 1685318467, 0, '', 0)EXPLAIN not possible on query: INSERT INTO `x1nkc_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3630393634333231363138393261363733333738356636633464316335663637', 1, 1685318467, 0, '', 0)Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms update 0.12 ms Waiting for query cache lock 0.01 ms update 0.01 ms end 0.01 ms query end 0.30 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.36 ms After last query: 1.02 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.04 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.01 ms Sending data 0.06 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: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.42 ms After last query: 0.09 ms Query memory: 0.021 MB Memory before query: 1.199 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.05 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.08 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.09 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 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.46 ms After last query: 2.06 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.06 ms checking permissions 0.01 ms Opening tables 0.08 ms init 0.04 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.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 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.34 ms After last query: 0.07 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.03 ms checking permissions 0.01 ms Opening tables 0.05 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.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 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.43 ms After last query: 0.05 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.05 ms init 0.02 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.18 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.75 ms After last query: 1.75 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.05 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.19 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.02 ms Opening tables 0.06 ms checking permissions 0.05 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.06 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.54 ms After last query: 9.03 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.10 ms checking permissions 0.01 ms Opening tables 0.08 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.02 ms executing 0.00 ms Sending data 0.06 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.60 ms After last query: 4.36 ms Query memory: 0.020 MB Memory before query: 2.520 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.11 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.03 ms preparing 0.03 ms executing 0.00 ms Sending data 0.18 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/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.27 ms After last query: 0.10 ms Query memory: 0.021 MB Memory before query: 2.527 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.03 ms checking permissions 0.01 ms Opening tables 0.07 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.02 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: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.34 ms After last query: 0.07 ms Query memory: 0.021 MB Memory before query: 2.533 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.05 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.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/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.32 ms After last query: 0.09 ms Query memory: 0.021 MB Memory before query: 2.539 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.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.04 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.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: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.26 ms After last query: 0.24 ms Query memory: 0.021 MB Memory before query: 2.544 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.03 ms checking permissions 0.01 ms Opening tables 0.05 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.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: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.77 ms After last query: 5.72 ms Query memory: 0.006 MB Memory before query: 2.721 MB
UPDATE `x1nkc_extensions`
SET `params` = '{\"mediaversion\":\"e7689a5967e6f0ced8dabb32da9044d4\"}'
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.06 ms checking permissions 0.01 ms Opening tables 0.08 ms init 0.03 ms System lock 0.10 ms updating 0.11 ms end 0.01 ms Waiting for query cache lock 0.00 ms end 0.01 ms query end 0.27 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.69 ms After last query: 1.23 ms Query memory: 0.027 MB Memory before query: 2.778 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.04 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.16 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.01 ms Opening tables 0.16 ms checking permissions 0.04 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Sending data 0.04 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 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.21 ms After last query: 0.10 ms Query memory: 0.024 MB Memory before query: 2.794 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.32 ms After last query: 0.19 ms Query memory: 0.022 MB Memory before query: 2.808 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.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.07 ms preparing 0.01 ms executing 0.00 ms Sending data 0.06 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.27 ms After last query: 0.09 ms Query memory: 0.022 MB Memory before query: 2.814 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.20 ms After last query: 0.25 ms Query memory: 0.022 MB Memory before query: 2.890 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.03 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.19 ms After last query: 0.21 ms Query memory: 0.022 MB Memory before query: 2.897 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.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.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 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.27 ms After last query: 0.10 ms Query memory: 0.022 MB Memory before query: 2.897 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: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.21 ms After last query: 2.03 ms Query memory: 0.028 MB Memory before query: 3.043 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.07 ms checking permissions 0.01 ms Opening tables 0.07 ms init 0.13 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.18 ms preparing 0.01 ms executing 0.00 ms Sending data 0.61 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: 10.27 ms After last query: 0.16 ms Query memory: 1.243 MB Memory before query: 3.098 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.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.07 ms preparing 0.01 ms executing 0.01 ms Sending data 9.89 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.97 ms After last query: 7.34 ms Query memory: 0.031 MB Memory before query: 8.366 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.19 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.01 ms Opening tables 0.08 ms checking permissions 0.05 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.01 ms Sending data 0.10 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/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.62 ms After last query: 0.70 ms Query memory: 0.005 MB Memory before query: 8.414 MB
UPDATE x1nkc_content
SET `hits` = (`hits` + 1)
WHERE `id` = '635'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.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.05 ms updating 0.09 ms end 0.01 ms Waiting for query cache lock 0.00 ms end 0.01 ms query end 0.30 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.77 ms After last query: 0.71 ms Query memory: 0.023 MB Memory before query: 8.457 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 = 635
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-29 00:01:07')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-05-29 00:01:07')
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 1 100.00 NULL 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.17 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.03 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.46 ms After last query: 0.82 ms Query memory: 0.022 MB Memory before query: 8.561 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` = 635
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.04 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.08 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.08 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: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.30 ms After last query: 1.06 ms Query memory: 0.024 MB Memory before query: 8.610 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.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 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 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.49 ms After last query: 1.01 ms Query memory: 0.027 MB Memory before query: 8.655 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 = 9
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 NULL 1 SIMPLE c NULL range cat_idx,idx_access,idx_left_right,idx_language idx_left_right 4 NULL 3 12.59 Using index condition; Using where Status Duration starting 0.10 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.05 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.10 ms preparing 0.03 ms Sorting result 0.01 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 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 20 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 19 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203 18 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:140 17 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:194 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 14 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/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.95 ms After last query: 0.17 ms Query memory: 0.025 MB Memory before query: 8.676 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 (9,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.09 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.20 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.17 ms Creating sort index 0.04 ms end 0.01 ms query end 0.01 ms removing tmp table 0.04 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 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.49 ms After last query: 0.44 ms Query memory: 0.024 MB Memory before query: 8.771 MB Rows returned: 0
SELECT *
FROM `x1nkc_sppagebuilder`
WHERE `extension` = 'com_content'
AND `extension_view` = 'article'
AND `view_id` = '635'
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.05 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.19 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 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.45 ms After last query: 0.17 ms Query memory: 0.025 MB Memory before query: 8.787 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 = 890
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.06 ms checking permissions 0.01 ms Opening tables 0.07 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms executing 0.00 ms Sending data 0.06 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: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: 0.80 ms After last query: 0.49 ms Query memory: 0.024 MB Memory before query: 8.809 MB Rows returned: 7
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 = 9
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-29 00:01:07')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-05-29 00:01:07')
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 25 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.10 ms checking permissions 0.01 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.15 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.30 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.32 ms After last query: 1.90 ms Query memory: 0.025 MB Memory before query: 8.821 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.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.07 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 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.24 ms After last query: 0.85 ms Query memory: 0.025 MB Memory before query: 8.845 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.02 ms checking permissions 0.01 ms Opening tables 0.05 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.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 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.07 ms After last query: 1.86 ms Query memory: 0.025 MB Memory before query: 8.925 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.05 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 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.31 ms After last query: 0.82 ms Query memory: 0.025 MB Memory before query: 8.958 MB Rows returned: 1
SELECT COUNT(*)
FROM x1nkc_comment
WHERE contentid='635'
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.04 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.00 ms Sending data 0.02 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: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.26 ms After last query: 0.26 ms Query memory: 0.025 MB Memory before query: 8.988 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.05 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.28 ms After last query: 0.11 ms Query memory: 0.025 MB Memory before query: 8.998 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.01 ms checking permissions 0.00 ms Opening tables 0.05 ms init 0.03 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: 1.36 ms After last query: 0.94 ms Query memory: 0.046 MB Memory before query: 9.054 MB Rows returned: 21
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM x1nkc_modules AS m
LEFT JOIN x1nkc_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN x1nkc_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-05-29 00:01:07')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-05-29 00:01:07')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 677 OR mm.menuid <= 0)
AND m.language IN ('en-GB','*')
ORDER BY m.position, m.orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ref PRIMARY,published,newsfeeds,idx_language published 1 const 52 0.95 Using index condition; Using where; Using filesort 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 403 mirrora2.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 mirrora2.m.id 6 40.00 Using where; Using index Status Duration starting 0.08 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.08 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.87 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 26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 25 JDatabaseDriver->loadObjectList() Same as call in the line below. 24 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 23 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 22 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 21 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 20 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/components/com_comment/templates/default/default.php:20 19 include JROOT/components/com_comment/templates/default/default.php JROOT/libraries/src/MVC/View/HtmlView.php:701 18 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_comment/views/comments/view.html.php:49 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.45 ms After last query: 8.79 ms Query memory: 0.021 MB Memory before query: 9.166 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.06 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 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.34 ms After last query: 0.30 ms Query memory: 0.021 MB Memory before query: 9.178 MB Rows returned: 0
SELECT `c2`.`language`,`c2`.`id`
FROM `x1nkc_menu` AS `c`
INNER JOIN `x1nkc_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `x1nkc_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `x1nkc_menu` AS `c2`
ON a2.id = c2.`id`
WHERE c.id = 677id 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.05 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.09 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 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/administrator/components/com_menus/helpers/menus.php:321 8 MenusHelper::getAssociations() JROOT/plugins/system/languagefilter/languagefilter.php:768 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.47 ms Query memory: 0.021 MB Memory before query: 9.201 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 = 635
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-29 00:01:07')
AND (c2.publish_down = '0000-00-00 00:00:00' OR c2.publish_down >= '2023-05-29 00:01:07')
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.08 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.06 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.17 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: 3.83 ms After last query: 47.45 ms Query memory: 0.274 MB Memory before query: 9.964 MB Rows returned: 6422
SELECT c.id AS CID
FROM x1nkc_categories AS c
LEFT JOIN x1nkc_content AS content
ON c.id = content.catid
WHERE 1=1
AND ( c.id = 85 OR c.id = 102 OR c.id = 104 OR c.id = 105 OR c.id = 106 OR c.id = 107 OR c.id = 113 OR c.id = 86 OR c.id = 87 OR c.id = 88 OR c.id = 89 OR c.id = 91 OR c.id = 92 OR c.id = 94 OR c.id = 112)
AND c.extension = 'com_content'
AND c.published = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL ref PRIMARY,cat_idx cat_idx 203 const,const 16 23.81 Using where; Using index 1 SIMPLE content NULL ref idx_catid idx_catid 4 mirrora2.c.id 291 100.00 Using where; Using index Status Duration starting 0.15 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.05 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.14 ms preparing 0.03 ms executing 0.01 ms Sending data 2.92 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 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/modules/mod_news_pro_gk5/data_sources/com_content/model.php:85 15 NSP_GK5_com_content_Model::getSources() JROOT/modules/mod_news_pro_gk5/helper.php:100 14 NSP_GK5_Helper->getDatas() JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:27 13 include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php JROOT/libraries/src/Helper/ModuleHelper.php:200 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Same as call in the line below. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:628 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 38.31 ms After last query: 9.93 ms Query memory: 0.024 MB Memory before query: 9.976 MB Rows returned: 12
SELECT content.id AS iid
FROM x1nkc_content AS content
WHERE content.state = 1
AND content.access IN (1,1)
AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2023-05-29 01:01:07' )
AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2023-05-29 01:01:07' )
AND ( content.catid = 85 OR content.catid = 86 OR content.catid = 87 OR content.catid = 88 OR content.catid = 89 OR content.catid = 91 OR content.catid = 92 OR content.catid = 94 OR content.catid = 102 OR content.catid = 104 OR content.catid = 105 OR content.catid = 106 OR content.catid = 107 OR content.catid = 112 OR content.catid = 113 )
AND content.language in ('en-GB','*')
ORDER BY content.created DESC
LIMIT 0,12;id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE content NULL ref idx_access,idx_state,idx_catid,idx_language idx_state 1 const 6295 16.00 Using index condition; Using where; Using filesort Status Duration starting 0.14 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.25 ms preparing 0.04 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 37.50 ms end 0.02 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.05 ms cleaning up 0.01 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 16 JDatabaseDriver->loadAssocList() JROOT/modules/mod_news_pro_gk5/data_sources/com_content/model.php:268 15 NSP_GK5_com_content_Model::getArticles() JROOT/modules/mod_news_pro_gk5/helper.php:114 14 NSP_GK5_Helper->getDatas() JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:27 13 include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php JROOT/libraries/src/Helper/ModuleHelper.php:200 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Same as call in the line below. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:628 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.95 ms After last query: 0.13 ms Query memory: 0.044 MB Memory before query: 9.994 MB Rows returned: 12
SELECT content.id AS iid, content.title AS title, content.introtext AS text, content.created AS date, content.publish_up AS date_publish, content.hits AS hits, content.images AS images, content.featured AS frontpage, content.access AS access, content.language AS lang, categories.title AS catname, users.email AS author_email, content.created_by_alias AS author_alias, users.name AS author_username, content_rating.rating_sum AS rating_sum, content_rating.rating_count AS rating_count,
CASE WHEN CHAR_LENGTH(content.alias) THEN CONCAT_WS(":", content.id, content.alias) ELSE content.id END as id,
CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS(":", categories.id, categories.alias) ELSE categories.id END as cid
FROM x1nkc_content AS content
LEFT JOIN x1nkc_categories AS categories
ON categories.id = content.catid
LEFT JOIN x1nkc_users AS users
ON users.id = content.created_by
LEFT JOIN x1nkc_content_rating AS content_rating
ON content_rating.content_id = content.id
LEFT JOIN x1nkc_content_frontpage AS content_frontpage
ON content_frontpage.content_id = content.id
WHERE 1=1
AND ( content.id = 6626 OR content.id = 6625 OR content.id = 6624 OR content.id = 6623 OR content.id = 6622 OR content.id = 6621 OR content.id = 6620 OR content.id = 6619 OR content.id = 6618 OR content.id = 6617 OR content.id = 6616 OR content.id = 6615)
ORDER BY content.created DESCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE content NULL range PRIMARY PRIMARY 4 NULL 12 100.00 Using where; Using filesort 1 SIMPLE categories NULL eq_ref PRIMARY PRIMARY 4 mirrora2.content.catid 1 100.00 Using where 1 SIMPLE users NULL eq_ref PRIMARY PRIMARY 4 mirrora2.content.created_by 1 100.00 Using where 1 SIMPLE content_rating NULL eq_ref PRIMARY PRIMARY 4 mirrora2.content.id 1 100.00 Using where 1 SIMPLE content_frontpage NULL eq_ref PRIMARY PRIMARY 4 mirrora2.content.id 1 100.00 Using where; Using index Status Duration starting 0.17 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.08 ms init 0.07 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.34 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:1506 16 JDatabaseDriver->loadAssocList() JROOT/modules/mod_news_pro_gk5/data_sources/com_content/model.php:332 15 NSP_GK5_com_content_Model::getArticles() JROOT/modules/mod_news_pro_gk5/helper.php:114 14 NSP_GK5_Helper->getDatas() JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:27 13 include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php JROOT/libraries/src/Helper/ModuleHelper.php:200 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Same as call in the line below. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:628 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.62 ms After last query: 0.48 ms Query memory: 0.030 MB Memory before query: 10.041 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 = 87
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 2.60 Using where Status Duration starting 0.12 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.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.03 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 32 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 31 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 30 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 29 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 28 ContentRouter->getCategorySegment() Same as call in the line below. 27 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 26 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 25 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 24 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 23 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 22 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 21 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 20 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 19 Joomla\CMS\Router\Route::_() JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:189 18 NSP_GK5_com_content_View::itemLink() JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:22 17 NSP_GK5_com_content_View::image() JROOT/modules/mod_news_pro_gk5/tmpl/view.php:25 16 NSP_GK5_View::header() JROOT/modules/mod_news_pro_gk5/data_sources/com_content/controller.php:41 15 NSP_GK5_com_content_Controller->initialize() JROOT/modules/mod_news_pro_gk5/helper.php:180 14 NSP_GK5_Helper->renderLayout() JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:28 13 include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php JROOT/libraries/src/Helper/ModuleHelper.php:200 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Same as call in the line below. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:628 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.50 ms After last query: 0.53 ms Query memory: 0.030 MB Memory before query: 10.064 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 = 94
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.60 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.09 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.12 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 32 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 31 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 30 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 29 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 28 ContentRouter->getCategorySegment() Same as call in the line below. 27 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 26 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 25 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 24 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 23 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 22 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 21 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 20 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 19 Joomla\CMS\Router\Route::_() JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:189 18 NSP_GK5_com_content_View::itemLink() JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:22 17 NSP_GK5_com_content_View::image() JROOT/modules/mod_news_pro_gk5/tmpl/view.php:25 16 NSP_GK5_View::header() JROOT/modules/mod_news_pro_gk5/data_sources/com_content/controller.php:41 15 NSP_GK5_com_content_Controller->initialize() JROOT/modules/mod_news_pro_gk5/helper.php:180 14 NSP_GK5_Helper->renderLayout() JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:28 13 include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php JROOT/libraries/src/Helper/ModuleHelper.php:200 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Same as call in the line below. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:628 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.47 ms After last query: 0.78 ms Query memory: 0.031 MB Memory before query: 10.090 MB Rows returned: 3
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `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 = 107
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 NULL 1 SIMPLE c NULL range cat_idx,idx_access,idx_left_right,idx_language idx_left_right 4 NULL 9 12.59 Using index condition; Using where Status Duration starting 0.09 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.09 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.08 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 32 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 31 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 30 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 29 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 28 ContentRouter->getCategorySegment() Same as call in the line below. 27 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 26 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 25 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 24 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 23 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 22 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 21 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 20 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 19 Joomla\CMS\Router\Route::_() JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:189 18 NSP_GK5_com_content_View::itemLink() JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:22 17 NSP_GK5_com_content_View::image() JROOT/modules/mod_news_pro_gk5/tmpl/view.php:25 16 NSP_GK5_View::header() JROOT/modules/mod_news_pro_gk5/data_sources/com_content/controller.php:41 15 NSP_GK5_com_content_Controller->initialize() JROOT/modules/mod_news_pro_gk5/helper.php:180 14 NSP_GK5_Helper->renderLayout() JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:28 13 include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php JROOT/libraries/src/Helper/ModuleHelper.php:200 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Same as call in the line below. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:628 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.65 ms After last query: 1.62 ms Query memory: 0.030 MB Memory before query: 10.125 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 = 91
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.20 Using where Status Duration starting 0.10 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 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.19 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 32 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 31 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 30 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 29 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 28 ContentRouter->getCategorySegment() Same as call in the line below. 27 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 26 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 25 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 24 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 23 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 22 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 21 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 20 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 19 Joomla\CMS\Router\Route::_() JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:189 18 NSP_GK5_com_content_View::itemLink() JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:22 17 NSP_GK5_com_content_View::image() JROOT/modules/mod_news_pro_gk5/tmpl/view.php:25 16 NSP_GK5_View::header() JROOT/modules/mod_news_pro_gk5/data_sources/com_content/controller.php:41 15 NSP_GK5_com_content_Controller->initialize() JROOT/modules/mod_news_pro_gk5/helper.php:180 14 NSP_GK5_Helper->renderLayout() JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:28 13 include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php JROOT/libraries/src/Helper/ModuleHelper.php:200 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Same as call in the line below. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:628 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.45 ms After last query: 3.28 ms Query memory: 0.022 MB Memory before query: 9.987 MB Rows returned: 0
SELECT *
FROM x1nkc_jmap_metainfo
WHERE `linkurl` = 'https://www.mirrorarts.lk/advertising'
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.05 ms checking permissions 0.02 ms Opening tables 0.08 ms init 0.03 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.09 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.26 ms After last query: 0.05 ms Query memory: 0.022 MB Memory before query: 9.994 MB Rows returned: 0
SELECT *
FROM x1nkc_jmap_canonicals
WHERE `linkurl` = 'https://www.mirrorarts.lk/advertising'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.08 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.02 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: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.38 ms After last query: 1.07 ms Query memory: 0.027 MB Memory before query: 10.134 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.05 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.16 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 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.24 ms After last query: 1.78 ms Query memory: 0.020 MB Memory before query: 10.400 MB Rows returned: 0
SELECT *
FROM x1nkc_jmap_headings
WHERE `linkurl` = 'https://www.mirrorarts.lk/advertising'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.03 ms checking permissions 0.01 ms Opening tables 0.05 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.02 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 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
45 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
5 × 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)4 × SELECT *
FROM `x1nkc_extensions`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 *
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 m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM x1nkc_modules AS m
LEFT JOIN x1nkc_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN x1nkc_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT language,id
FROM `x1nkc_menu`1 × SELECT `c2`.`language`,`c2`.`id`
FROM `x1nkc_menu` AS `c`
INNER JOIN `x1nkc_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `x1nkc_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `x1nkc_menu` AS `c2`
ON a2.id = c2.`id`1 × 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 c.id AS CID
FROM x1nkc_categories AS c
LEFT JOIN x1nkc_content AS content
ON c.id = content.catid1 × SELECT content.id AS iid
FROM x1nkc_content AS content1 × SELECT content.id AS iid, content.title AS title, content.introtext AS text, content.created AS date, content.publish_up AS date_publish, content.hits AS hits, content.images AS images, content.featured AS frontpage, content.access AS access, content.language AS lang, categories.title AS catname, users.email AS author_email, content.created_by_alias AS author_alias, users.name AS author_username, content_rating.rating_sum AS rating_sum, content_rating.rating_count AS rating_count,
CASE WHEN CHAR_LENGTH(content.alias) THEN CONCAT_WS(":", content.id, content.alias) ELSE content.id END as id,
CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS(":", categories.id, categories.alias) ELSE categories.id END as cid
FROM x1nkc_content AS content
LEFT JOIN x1nkc_categories AS categories
ON categories.id = content.catid
LEFT JOIN x1nkc_users AS users
ON users.id = content.created_by
LEFT JOIN x1nkc_content_rating AS content_rating
ON content_rating.content_id = content.id
LEFT JOIN x1nkc_content_frontpage AS content_frontpage
ON content_frontpage.content_id = content.id1 × 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'3630393634333231363138393261363733333738356636633464316335663637', 1, 1685318467, 0, '', 01 × SHOW FULL COLUMNS
FROM `x1nkc_rsfirewall_logs1 × UPDATE `x1nkc_extensions`
SET `params` = '{\"mediaversion\":\"e7689a5967e6f0ced8dabb32da9044d4\"}'1 × SHOW FULL COLUMNS
FROM `x1nkc_socialbacklinks_configs1 × SHOW FULL COLUMNS
FROM `x1nkc_content1 × UPDATE x1nkc_content
SET `hits` = (`hits` + 1)