Query Time: 0.34 ms Query memory: 0.003 MB Memory before query: 0.722 MB
DELETE
FROM `triholog_session`
WHERE `time` < '1791806977'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | DELETE | triholog_session | NULL | range | time | time | 45 | const | 3 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| init | 0.01 ms |
| System lock | 0.04 ms |
| updating | 0.14 ms |
| end | 0.01 ms |
| query end | 0.05 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 6 | JDatabaseDriverMysqli->execute() | JROOT/libraries/cms/application/cms.php:834 |
| 5 | JApplicationCms->loadSession() | JROOT/libraries/cms/application/cms.php:132 |
| 4 | JApplicationCms->__construct() | JROOT/libraries/cms/application/site.php:63 |
| 3 | JApplicationSite->__construct() | JROOT/libraries/cms/application/cms.php:420 |
| 2 | JApplicationCms::getInstance() | JROOT/libraries/joomla/factory.php:125 |
| 1 | JFactory::getApplication() | JROOT/index.php:46 |
Query Time: 0.13 ms After last query: 0.67 ms Query memory: 0.021 MB Memory before query: 0.739 MB Rows returned: 0
SELECT `session_id`
FROM `triholog_session`
WHERE `session_id` = '050464f675e9c6b10f568ad148574a8f'
LIMIT 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | triholog_session | NULL | const | PRIMARY | PRIMARY | 575 | const | 1 | 100.00 | Using index |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1720 |
| 7 | JDatabaseDriver->loadResult() | JROOT/libraries/cms/application/cms.php:177 |
| 6 | JApplicationCms->checkSession() | JROOT/libraries/cms/application/cms.php:843 |
| 5 | JApplicationCms->loadSession() | JROOT/libraries/cms/application/cms.php:132 |
| 4 | JApplicationCms->__construct() | JROOT/libraries/cms/application/site.php:63 |
| 3 | JApplicationSite->__construct() | JROOT/libraries/cms/application/cms.php:420 |
| 2 | JApplicationCms::getInstance() | JROOT/libraries/joomla/factory.php:125 |
| 1 | JFactory::getApplication() | JROOT/index.php:46 |
Query Time: 0.16 ms After last query: 0.08 ms Query memory: 0.003 MB Memory before query: 0.744 MB
INSERT INTO `triholog_session`
(`session_id`,`guest`,`time`,`userid`,`username`)
VALUES
('050464f675e9c6b10f568ad148574a8f', 1, '1791824977', 0, '')
EXPLAIN not possible on query: INSERT INTO `triholog_session`
(`session_id`,`guest`,`time`,`userid`,`username`) VALUES
('050464f675e9c6b10f568ad148574a8f', 1, '1791824977', 0, '')
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| update | 0.06 ms |
| end | 0.00 ms |
| query end | 0.03 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/cms/application/cms.php:217 |
| 6 | JApplicationCms->checkSession() | JROOT/libraries/cms/application/cms.php:843 |
| 5 | JApplicationCms->loadSession() | JROOT/libraries/cms/application/cms.php:132 |
| 4 | JApplicationCms->__construct() | JROOT/libraries/cms/application/site.php:63 |
| 3 | JApplicationSite->__construct() | JROOT/libraries/cms/application/cms.php:420 |
| 2 | JApplicationCms::getInstance() | JROOT/libraries/joomla/factory.php:125 |
| 1 | JFactory::getApplication() | JROOT/index.php:46 |
Query Time: 0.15 ms After last query: 1.55 ms Query memory: 0.023 MB Memory before query: 0.905 MB Rows returned: 5
SELECT id, rules
FROM `triholog_viewlevels`
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | triholog_viewlevels | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 5 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.00 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.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1486 |
| 9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/joomla/access/access.php:1061 |
| 8 | JAccess::getAuthorisedViewLevels() | JROOT/libraries/joomla/user/user.php:453 |
| 7 | JUser->getAuthorisedViewLevels() | JROOT/libraries/cms/plugin/helper.php:309 |
| 6 | JPluginHelper::load() | JROOT/libraries/cms/plugin/helper.php:86 |
| 5 | JPluginHelper::getPlugin() | JROOT/libraries/cms/plugin/helper.php:128 |
| 4 | JPluginHelper::isEnabled() | JROOT/libraries/cms/application/site.php:603 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:272 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.14 ms After last query: 0.08 ms Query memory: 0.022 MB Memory before query: 0.917 MB Rows returned: 0
SELECT b.id
FROM triholog_usergroups AS a
LEFT JOIN triholog_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 13
| id | 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.03 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1530 |
| 10 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/access/access.php:978 |
| 9 | JAccess::getGroupsByUser() | JROOT/libraries/joomla/access/access.php:1093 |
| 8 | JAccess::getAuthorisedViewLevels() | JROOT/libraries/joomla/user/user.php:453 |
| 7 | JUser->getAuthorisedViewLevels() | JROOT/libraries/cms/plugin/helper.php:309 |
| 6 | JPluginHelper::load() | JROOT/libraries/cms/plugin/helper.php:86 |
| 5 | JPluginHelper::getPlugin() | JROOT/libraries/cms/plugin/helper.php:128 |
| 4 | JPluginHelper::isEnabled() | JROOT/libraries/cms/application/site.php:603 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:272 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.14 ms After last query: 3.12 ms Query memory: 0.023 MB Memory before query: 1.241 MB Rows returned: 1
SELECT `path`
FROM triholog_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 | triholog_rsfirewall_ignored | 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.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1530 |
| 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:28 |
| 7 | plgSystemRSFirewall->__construct() | JROOT/libraries/cms/plugin/helper.php:271 |
| 6 | JPluginHelper::import() | JROOT/libraries/cms/plugin/helper.php:181 |
| 5 | JPluginHelper::importPlugin() | JROOT/libraries/cms/application/cms.php:695 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:685 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:272 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.12 ms After last query: 0.05 ms Query memory: 0.023 MB Memory before query: 1.247 MB Rows returned: 0
SELECT `file`
FROM triholog_rsfirewall_hashes
WHERE `type`='protect'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | triholog_rsfirewall_hashes | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 5 | 20.00 | Using where |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1530 |
| 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:28 |
| 7 | plgSystemRSFirewall->__construct() | JROOT/libraries/cms/plugin/helper.php:271 |
| 6 | JPluginHelper::import() | JROOT/libraries/cms/plugin/helper.php:181 |
| 5 | JPluginHelper::importPlugin() | JROOT/libraries/cms/application/cms.php:695 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:685 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:272 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.19 ms After last query: 0.04 ms Query memory: 0.028 MB Memory before query: 1.251 MB Rows returned: 52
SELECT *
FROM triholog_rsfirewall_configuration
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | triholog_rsfirewall_configuration | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 52 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.00 ms |
| preparing | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.06 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 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:28 |
| 7 | plgSystemRSFirewall->__construct() | JROOT/libraries/cms/plugin/helper.php:271 |
| 6 | JPluginHelper::import() | JROOT/libraries/cms/plugin/helper.php:181 |
| 5 | JPluginHelper::importPlugin() | JROOT/libraries/cms/application/cms.php:695 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:685 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:272 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.49 ms After last query: 2.36 ms Query memory: 0.028 MB Memory before query: 1.464 MB Rows returned: 10
SHOW FULL COLUMNS
FROM `triholog_rsfirewall_logs`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `triholog_rsfirewall_logs`
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.17 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Opening tables | 0.01 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending data | 0.05 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.04 ms |
| closing tables | 0.00 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:440 |
| 14 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/joomla/table/table.php:244 |
| 13 | JTable->getFields() | JROOT/libraries/joomla/table/table.php:163 |
| 12 | JTable->__construct() | JROOT/administrator/components/com_rsfirewall/tables/logs.php:36 |
| 11 | RSFirewallTableLogs->__construct() | JROOT/libraries/joomla/table/table.php:311 |
| 10 | JTable::getInstance() | JROOT/administrator/components/com_rsfirewall/helpers/log.php:23 |
| 9 | RSFirewallLogger->__construct() | JROOT/administrator/components/com_rsfirewall/helpers/log.php:57 |
| 8 | RSFirewallLogger::getInstance() | JROOT/plugins/system/rsfirewall/rsfirewall.php:50 |
| 7 | plgSystemRSFirewall->__construct() | JROOT/libraries/cms/plugin/helper.php:271 |
| 6 | JPluginHelper::import() | JROOT/libraries/cms/plugin/helper.php:181 |
| 5 | JPluginHelper::importPlugin() | JROOT/libraries/cms/application/cms.php:695 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:685 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:272 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.25 ms After last query: 6.21 ms Query memory: 0.024 MB Memory before query: 1.895 MB Rows returned: 1
SELECT COUNT(`extension_id`)
FROM `triholog_extensions`
WHERE `element` = 'com_advancedmodules'
AND `type` = 'component'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | triholog_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | 10.00 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.06 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.03 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1720 |
| 15 | JDatabaseDriver->loadResult() | JROOT/libraries/cms/component/helper.php:95 |
| 14 | JComponentHelper::isInstalled() | JROOT/libraries/regularlabs/src/Parameters.php:136 |
| 13 | RegularLabs\Library\Parameters->getComponentParams() | JROOT/plugins/system/advancedmodules/src/Params.php:29 |
| 12 | RegularLabs\Plugin\System\AdvancedModules\Params::get() | JROOT/plugins/system/advancedmodules/src/Helper.php:22 |
| 11 | RegularLabs\Plugin\System\AdvancedModules\Helper->onAfterInitialise() | Same as call in the line below. |
| 10 | call_user_func_array() | JROOT/plugins/system/advancedmodules/src/Plugin.php:97 |
| 9 | RegularLabs\Plugin\System\AdvancedModules\Plugin->run() | JROOT/plugins/system/advancedmodules/advancedmodules.php:59 |
| 8 | PlgSystemAdvancedModules->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:696 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:685 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:272 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.25 ms After last query: 5.55 ms Query memory: 0.036 MB Memory before query: 2.220 MB Rows returned: 1
SELECT `params`
FROM triholog_extensions
WHERE `element`='com_sh404sef'
AND `type`='component';
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | triholog_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | 10.00 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.06 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1720 |
| 15 | JDatabaseDriver->loadResult() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:662 |
| 14 | ShlDbClass->loadResult() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:333 |
| 13 | ShlDbClass->shlLoadResult() | JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:483 |
| 12 | ShlDbHelper::selectResult() | JROOT/administrator/components/com_sh404sef/helpers/general.php:111 |
| 11 | Sh404sefHelperGeneral::getComponentParams() | JROOT/administrator/components/com_sh404sef/classes/config.php:542 |
| 10 | Sh404sefClassConfig->__construct() | JROOT/administrator/components/com_sh404sef/sh404seffactory.php:119 |
| 9 | Sh404sefFactory::getConfig() | JROOT/plugins/system/sh404sef/sh404sef.php:52 |
| 8 | plgSystemSh404sef->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:696 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:685 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:272 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.22 ms After last query: 9.49 ms Query memory: 0.024 MB Memory before query: 3.066 MB Rows returned: 0
select `alias`,`newurl`
from `triholog_sh404sef_aliases`
where `alias` = 'filter/shampuni/dlya-oslablennykh-volos'
order by `alias` desc
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | triholog_sh404sef_aliases | NULL | ref | alias | alias | 767 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 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.00 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1642 |
| 13 | JDatabaseDriver->loadObject() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:605 |
| 12 | ShlDbClass->loadObject() | JROOT/administrator/components/com_sh404sef/classes/router.php:1104 |
| 11 | Sh404sefClassRouterInternal->_checkAliases() | JROOT/administrator/components/com_sh404sef/classes/router.php:104 |
| 10 | Sh404sefClassRouterInternal->parseRule() | JROOT/libraries/cms/router/router.php:597 |
| 9 | JRouter->processParseRules() | JROOT/libraries/cms/router/site.php:584 |
| 8 | JRouterSite->processParseRules() | JROOT/libraries/cms/router/router.php:571 |
| 7 | JRouter->_processParseRules() | JROOT/libraries/cms/router/router.php:225 |
| 6 | JRouter->parse() | JROOT/libraries/cms/router/site.php:133 |
| 5 | JRouterSite->parse() | JROOT/libraries/cms/application/cms.php:1158 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:272 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.26 ms After last query: 0.57 ms Query memory: 0.027 MB Memory before query: 3.085 MB Rows returned: 0
SELECT `oldurl`, `newurl`, `dateadd`
FROM triholog_sh404sef_urls
WHERE `oldurl`='filter/shampuni/dlya-oslablennykh-volos'
ORDER BY `rank`;
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | triholog_sh404sef_urls | NULL | ref | oldurl | oldurl | 767 | const | 1 | 100.00 | Using index condition; Using filesort |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| Sorting result | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.04 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1642 |
| 18 | JDatabaseDriver->loadObject() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:605 |
| 17 | ShlDbClass->loadObject() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:412 |
| 16 | ShlDbClass->shlLoadObject() | JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655 |
| 15 | ShlDbHelper::selectObject() | JROOT/administrator/components/com_sh404sef/models/sefurls.php:76 |
| 14 | Sh404sefModelSefurls->getNonSefUrlFromDatabase() | JROOT/administrator/components/com_sh404sef/classes/router.php:583 |
| 13 | Sh404sefClassRouterInternal->_lookupSef() | JROOT/administrator/components/com_sh404sef/classes/router.php:326 |
| 12 | Sh404sefClassRouterInternal->_parseSefRouteInternal() | JROOT/administrator/components/com_sh404sef/classes/router.php:1432 |
| 11 | Sh404sefClassRouter->_parseSefRoute() | JROOT/administrator/components/com_sh404sef/classes/router.php:110 |
| 10 | Sh404sefClassRouterInternal->parseRule() | JROOT/libraries/cms/router/router.php:597 |
| 9 | JRouter->processParseRules() | JROOT/libraries/cms/router/site.php:584 |
| 8 | JRouterSite->processParseRules() | JROOT/libraries/cms/router/router.php:571 |
| 7 | JRouter->_processParseRules() | JROOT/libraries/cms/router/router.php:225 |
| 6 | JRouter->parse() | JROOT/libraries/cms/router/site.php:133 |
| 5 | JRouterSite->parse() | JROOT/libraries/cms/application/cms.php:1158 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:272 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.18 ms After last query: 0.16 ms Query memory: 0.027 MB Memory before query: 3.094 MB Rows returned: 0
SELECT `oldurl`, `newurl`, `dateadd`
FROM triholog_sh404sef_urls
WHERE `oldurl`='filter/shampuni/dlya-oslablennykh-volos/'
ORDER BY `rank`;
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | triholog_sh404sef_urls | NULL | ref | oldurl | oldurl | 767 | const | 1 | 100.00 | Using index condition; Using filesort |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| Sorting result | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.00 ms |
| Creating sort index | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.02 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1642 |
| 19 | JDatabaseDriver->loadObject() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:605 |
| 18 | ShlDbClass->loadObject() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:412 |
| 17 | ShlDbClass->shlLoadObject() | JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655 |
| 16 | ShlDbHelper::selectObject() | JROOT/administrator/components/com_sh404sef/models/sefurls.php:76 |
| 15 | Sh404sefModelSefurls->getNonSefUrlFromDatabase() | JROOT/administrator/components/com_sh404sef/classes/router.php:583 |
| 14 | Sh404sefClassRouterInternal->_lookupSef() | JROOT/administrator/components/com_sh404sef/classes/router.php:1049 |
| 13 | Sh404sefClassRouterInternal->_checkTrailingSlash() | JROOT/administrator/components/com_sh404sef/classes/router.php:348 |
| 12 | Sh404sefClassRouterInternal->_parseSefRouteInternal() | JROOT/administrator/components/com_sh404sef/classes/router.php:1432 |
| 11 | Sh404sefClassRouter->_parseSefRoute() | JROOT/administrator/components/com_sh404sef/classes/router.php:110 |
| 10 | Sh404sefClassRouterInternal->parseRule() | JROOT/libraries/cms/router/router.php:597 |
| 9 | JRouter->processParseRules() | JROOT/libraries/cms/router/site.php:584 |
| 8 | JRouterSite->processParseRules() | JROOT/libraries/cms/router/router.php:571 |
| 7 | JRouter->_processParseRules() | JROOT/libraries/cms/router/router.php:225 |
| 6 | JRouter->parse() | JROOT/libraries/cms/router/site.php:133 |
| 5 | JRouterSite->parse() | JROOT/libraries/cms/application/cms.php:1158 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:272 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.13 ms After last query: 0.10 ms Query memory: 0.024 MB Memory before query: 3.103 MB Rows returned: 0
select `alias`,`newurl`
from `triholog_sh404sef_aliases`
where `alias` = 'filter/shampuni/dlya-oslablennykh-volos'
order by `alias` desc
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | triholog_sh404sef_aliases | NULL | ref | alias | alias | 767 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1642 |
| 15 | JDatabaseDriver->loadObject() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:605 |
| 14 | ShlDbClass->loadObject() | JROOT/administrator/components/com_sh404sef/classes/router.php:1104 |
| 13 | Sh404sefClassRouterInternal->_checkAliases() | JROOT/administrator/components/com_sh404sef/classes/router.php:351 |
| 12 | Sh404sefClassRouterInternal->_parseSefRouteInternal() | JROOT/administrator/components/com_sh404sef/classes/router.php:1432 |
| 11 | Sh404sefClassRouter->_parseSefRoute() | JROOT/administrator/components/com_sh404sef/classes/router.php:110 |
| 10 | Sh404sefClassRouterInternal->parseRule() | JROOT/libraries/cms/router/router.php:597 |
| 9 | JRouter->processParseRules() | JROOT/libraries/cms/router/site.php:584 |
| 8 | JRouterSite->processParseRules() | JROOT/libraries/cms/router/router.php:571 |
| 7 | JRouter->_processParseRules() | JROOT/libraries/cms/router/router.php:225 |
| 6 | JRouter->parse() | JROOT/libraries/cms/router/site.php:133 |
| 5 | JRouterSite->parse() | JROOT/libraries/cms/application/cms.php:1158 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:272 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 1.43 ms After last query: 0.72 ms Query memory: 0.054 MB Memory before query: 3.126 MB Rows returned: 140
SHOW FULL COLUMNS
FROM `triholog_jshopping_config`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `triholog_jshopping_config`
| Status | Duration |
|---|
| 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 |
| checking permissions | 0.00 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 |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.07 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.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 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 |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending data | 0.25 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.05 ms |
| closing tables | 0.00 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 25 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:440 |
| 24 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/joomla/table/table.php:244 |
| 23 | JTable->getFields() | JROOT/libraries/joomla/table/table.php:163 |
| 22 | JTable->__construct() | JROOT/components/com_jshopping/tables/config.php:14 |
| 21 | jshopConfig->__construct() | JROOT/components/com_jshopping/lib/factory.php:24 |
| 20 | JSFactory::getConfig() | JROOT/components/com_jshopping/lib/factory.php:146 |
| 19 | JSFactory::reloadConfigFieldTLF() | JROOT/components/com_jshopping/lib/factory.php:169 |
| 18 | JSFactory::loadLanguageFile() | JROOT/components/com_jshopping/lib/functions.php:1590 |
| 17 | initLoadJoomshoppingLanguageFile() | JROOT/components/com_jshopping/router.php:255 |
| 16 | jshoppingParseRoute() | JROOT/libraries/cms/component/router/legacy.php:104 |
| 15 | JComponentRouterLegacy->parse() | JROOT/libraries/cms/router/site.php:432 |
| 14 | JRouterSite->parseSefRoute() | JROOT/libraries/cms/router/router.php:483 |
| 13 | JRouter->_parseSefRoute() | JROOT/administrator/components/com_sh404sef/classes/router.php:362 |
| 12 | Sh404sefClassRouterInternal->_parseSefRouteInternal() | JROOT/administrator/components/com_sh404sef/classes/router.php:1432 |
| 11 | Sh404sefClassRouter->_parseSefRoute() | JROOT/administrator/components/com_sh404sef/classes/router.php:110 |
| 10 | Sh404sefClassRouterInternal->parseRule() | JROOT/libraries/cms/router/router.php:597 |
| 9 | JRouter->processParseRules() | JROOT/libraries/cms/router/site.php:584 |
| 8 | JRouterSite->processParseRules() | JROOT/libraries/cms/router/router.php:571 |
| 7 | JRouter->_processParseRules() | JROOT/libraries/cms/router/router.php:225 |
| 6 | JRouter->parse() | JROOT/libraries/cms/router/site.php:133 |
| 5 | JRouterSite->parse() | JROOT/libraries/cms/application/cms.php:1158 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:272 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.34 ms After last query: 1.04 ms Query memory: 0.077 MB Memory before query: 3.429 MB Rows returned: 1
SELECT *
FROM triholog_jshopping_config
WHERE `id` = '1'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | triholog_jshopping_config | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.02 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.06 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.11 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1445 |
| 22 | JDatabaseDriver->loadAssoc() | JROOT/libraries/joomla/table/table.php:729 |
| 21 | JTable->load() | JROOT/components/com_jshopping/lib/factory.php:30 |
| 20 | JSFactory::getConfig() | JROOT/components/com_jshopping/lib/factory.php:146 |
| 19 | JSFactory::reloadConfigFieldTLF() | JROOT/components/com_jshopping/lib/factory.php:169 |
| 18 | JSFactory::loadLanguageFile() | JROOT/components/com_jshopping/lib/functions.php:1590 |
| 17 | initLoadJoomshoppingLanguageFile() | JROOT/components/com_jshopping/router.php:255 |
| 16 | jshoppingParseRoute() | JROOT/libraries/cms/component/router/legacy.php:104 |
| 15 | JComponentRouterLegacy->parse() | JROOT/libraries/cms/router/site.php:432 |
| 14 | JRouterSite->parseSefRoute() | JROOT/libraries/cms/router/router.php:483 |
| 13 | JRouter->_parseSefRoute() | JROOT/administrator/components/com_sh404sef/classes/router.php:362 |
| 12 | Sh404sefClassRouterInternal->_parseSefRouteInternal() | JROOT/administrator/components/com_sh404sef/classes/router.php:1432 |
| 11 | Sh404sefClassRouter->_parseSefRoute() | JROOT/administrator/components/com_sh404sef/classes/router.php:110 |
| 10 | Sh404sefClassRouterInternal->parseRule() | JROOT/libraries/cms/router/router.php:597 |
| 9 | JRouter->processParseRules() | JROOT/libraries/cms/router/site.php:584 |
| 8 | JRouterSite->processParseRules() | JROOT/libraries/cms/router/router.php:571 |
| 7 | JRouter->_processParseRules() | JROOT/libraries/cms/router/router.php:225 |
| 6 | JRouter->parse() | JROOT/libraries/cms/router/site.php:133 |
| 5 | JRouterSite->parse() | JROOT/libraries/cms/application/cms.php:1158 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:272 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.34 ms After last query: 0.53 ms Query memory: 0.033 MB Memory before query: 3.435 MB Rows returned: 8
SHOW FULL COLUMNS
FROM `triholog_jshopping_currencies`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `triholog_jshopping_currencies`
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.09 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Opening tables | 0.01 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.02 ms |
| Sending data | 0.03 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.02 ms |
| closing tables | 0.00 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 30 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 29 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:440 |
| 28 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/joomla/table/table.php:244 |
| 27 | JTable->getFields() | JROOT/libraries/joomla/table/table.php:163 |
| 26 | JTable->__construct() | JROOT/components/com_jshopping/tables/currency.php:14 |
| 25 | jshopCurrency->__construct() | JROOT/libraries/joomla/table/table.php:311 |
| 24 | JTable::getInstance() | JROOT/components/com_jshopping/lib/factory.php:601 |
| 23 | JSFactory::getTable() | JROOT/components/com_jshopping/lib/factory.php:549 |
| 22 | JSFactory::getAllCurrency() | JROOT/components/com_jshopping/tables/config.php:53 |
| 21 | jshopConfig->loadCurrencyValue() | JROOT/components/com_jshopping/lib/factory.php:32 |
| 20 | JSFactory::getConfig() | JROOT/components/com_jshopping/lib/factory.php:146 |
| 19 | JSFactory::reloadConfigFieldTLF() | JROOT/components/com_jshopping/lib/factory.php:169 |
| 18 | JSFactory::loadLanguageFile() | JROOT/components/com_jshopping/lib/functions.php:1590 |
| 17 | initLoadJoomshoppingLanguageFile() | JROOT/components/com_jshopping/router.php:255 |
| 16 | jshoppingParseRoute() | JROOT/libraries/cms/component/router/legacy.php:104 |
| 15 | JComponentRouterLegacy->parse() | JROOT/libraries/cms/router/site.php:432 |
| 14 | JRouterSite->parseSefRoute() | JROOT/libraries/cms/router/router.php:483 |
| 13 | JRouter->_parseSefRoute() | JROOT/administrator/components/com_sh404sef/classes/router.php:362 |
| 12 | Sh404sefClassRouterInternal->_parseSefRouteInternal() | JROOT/administrator/components/com_sh404sef/classes/router.php:1432 |
| 11 | Sh404sefClassRouter->_parseSefRoute() | JROOT/administrator/components/com_sh404sef/classes/router.php:110 |
| 10 | Sh404sefClassRouterInternal->parseRule() | JROOT/libraries/cms/router/router.php:597 |
| 9 | JRouter->processParseRules() | JROOT/libraries/cms/router/site.php:584 |
| 8 | JRouterSite->processParseRules() | JROOT/libraries/cms/router/router.php:571 |
| 7 | JRouter->_processParseRules() | JROOT/libraries/cms/router/router.php:225 |
| 6 | JRouter->parse() | JROOT/libraries/cms/router/site.php:133 |
| 5 | JRouterSite->parse() | JROOT/libraries/cms/application/cms.php:1158 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:272 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.20 ms After last query: 0.09 ms Query memory: 0.029 MB Memory before query: 3.462 MB Rows returned: 1
SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value
FROM `triholog_jshopping_currencies`
WHERE currency_publish = '1'
ORDER BY currency_ordering
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | triholog_jshopping_currencies | NULL | ref | currency_publish | currency_publish | 1 | const | 1 | 100.00 | Using index condition; Using filesort |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| Sorting result | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.05 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 24 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/tables/currency.php:22 |
| 23 | jshopCurrency->getAllCurrencies() | JROOT/components/com_jshopping/lib/factory.php:550 |
| 22 | JSFactory::getAllCurrency() | JROOT/components/com_jshopping/tables/config.php:53 |
| 21 | jshopConfig->loadCurrencyValue() | JROOT/components/com_jshopping/lib/factory.php:32 |
| 20 | JSFactory::getConfig() | JROOT/components/com_jshopping/lib/factory.php:146 |
| 19 | JSFactory::reloadConfigFieldTLF() | JROOT/components/com_jshopping/lib/factory.php:169 |
| 18 | JSFactory::loadLanguageFile() | JROOT/components/com_jshopping/lib/functions.php:1590 |
| 17 | initLoadJoomshoppingLanguageFile() | JROOT/components/com_jshopping/router.php:255 |
| 16 | jshoppingParseRoute() | JROOT/libraries/cms/component/router/legacy.php:104 |
| 15 | JComponentRouterLegacy->parse() | JROOT/libraries/cms/router/site.php:432 |
| 14 | JRouterSite->parseSefRoute() | JROOT/libraries/cms/router/router.php:483 |
| 13 | JRouter->_parseSefRoute() | JROOT/administrator/components/com_sh404sef/classes/router.php:362 |
| 12 | Sh404sefClassRouterInternal->_parseSefRouteInternal() | JROOT/administrator/components/com_sh404sef/classes/router.php:1432 |
| 11 | Sh404sefClassRouter->_parseSefRoute() | JROOT/administrator/components/com_sh404sef/classes/router.php:110 |
| 10 | Sh404sefClassRouterInternal->parseRule() | JROOT/libraries/cms/router/router.php:597 |
| 9 | JRouter->processParseRules() | JROOT/libraries/cms/router/site.php:584 |
| 8 | JRouterSite->processParseRules() | JROOT/libraries/cms/router/router.php:571 |
| 7 | JRouter->_processParseRules() | JROOT/libraries/cms/router/router.php:225 |
| 6 | JRouter->parse() | JROOT/libraries/cms/router/site.php:133 |
| 5 | JRouterSite->parse() | JROOT/libraries/cms/application/cms.php:1158 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:272 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.30 ms After last query: 0.50 ms Query memory: 0.027 MB Memory before query: 3.477 MB Rows returned: 7
select manufacturer_id as id, `alias_ru-RU` as alias
from triholog_jshopping_manufacturers
where `alias_ru-RU`!=''
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | triholog_jshopping_manufacturers | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 8 | 87.50 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.10 ms |
| init | 0.01 ms |
| System lock | 0.00 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.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/lib/factory.php:266 |
| 17 | JSFactory::getAliasManufacturer() | JROOT/components/com_jshopping/router.php:273 |
| 16 | jshoppingParseRoute() | JROOT/libraries/cms/component/router/legacy.php:104 |
| 15 | JComponentRouterLegacy->parse() | JROOT/libraries/cms/router/site.php:432 |
| 14 | JRouterSite->parseSefRoute() | JROOT/libraries/cms/router/router.php:483 |
| 13 | JRouter->_parseSefRoute() | JROOT/administrator/components/com_sh404sef/classes/router.php:362 |
| 12 | Sh404sefClassRouterInternal->_parseSefRouteInternal() | JROOT/administrator/components/com_sh404sef/classes/router.php:1432 |
| 11 | Sh404sefClassRouter->_parseSefRoute() | JROOT/administrator/components/com_sh404sef/classes/router.php:110 |
| 10 | Sh404sefClassRouterInternal->parseRule() | JROOT/libraries/cms/router/router.php:597 |
| 9 | JRouter->processParseRules() | JROOT/libraries/cms/router/site.php:584 |
| 8 | JRouterSite->processParseRules() | JROOT/libraries/cms/router/router.php:571 |
| 7 | JRouter->_processParseRules() | JROOT/libraries/cms/router/router.php:225 |
| 6 | JRouter->parse() | JROOT/libraries/cms/router/site.php:133 |
| 5 | JRouterSite->parse() | JROOT/libraries/cms/application/cms.php:1158 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:272 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.37 ms After last query: 0.25 ms Query memory: 0.031 MB Memory before query: 3.491 MB Rows returned: 6
SHOW FULL COLUMNS
FROM `triholog_jshopping_products_extra_field_values`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `triholog_jshopping_products_extra_field_values`
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.10 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.00 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Opening tables | 0.07 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| Sending data | 0.03 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.02 ms |
| closing tables | 0.00 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 23 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:440 |
| 22 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/joomla/table/table.php:244 |
| 21 | JTable->getFields() | JROOT/libraries/joomla/table/table.php:163 |
| 20 | JTable->__construct() | JROOT/components/com_jshopping/tables/productfieldvalue.php:15 |
| 19 | jshopProductFieldValue->__construct() | JROOT/libraries/joomla/table/table.php:311 |
| 18 | JTable::getInstance() | JROOT/components/com_jshopping/lib/factory.php:601 |
| 17 | JSFactory::getTable() | JROOT/components/com_jshopping/router.php:281 |
| 16 | jshoppingParseRoute() | JROOT/libraries/cms/component/router/legacy.php:104 |
| 15 | JComponentRouterLegacy->parse() | JROOT/libraries/cms/router/site.php:432 |
| 14 | JRouterSite->parseSefRoute() | JROOT/libraries/cms/router/router.php:483 |
| 13 | JRouter->_parseSefRoute() | JROOT/administrator/components/com_sh404sef/classes/router.php:362 |
| 12 | Sh404sefClassRouterInternal->_parseSefRouteInternal() | JROOT/administrator/components/com_sh404sef/classes/router.php:1432 |
| 11 | Sh404sefClassRouter->_parseSefRoute() | JROOT/administrator/components/com_sh404sef/classes/router.php:110 |
| 10 | Sh404sefClassRouterInternal->parseRule() | JROOT/libraries/cms/router/router.php:597 |
| 9 | JRouter->processParseRules() | JROOT/libraries/cms/router/site.php:584 |
| 8 | JRouterSite->processParseRules() | JROOT/libraries/cms/router/router.php:571 |
| 7 | JRouter->_processParseRules() | JROOT/libraries/cms/router/router.php:225 |
| 6 | JRouter->parse() | JROOT/libraries/cms/router/site.php:133 |
| 5 | JRouterSite->parse() | JROOT/libraries/cms/application/cms.php:1158 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:272 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.27 ms After last query: 0.09 ms Query memory: 0.033 MB Memory before query: 3.513 MB Rows returned: 56
SELECT id, `name_ru-RU` as name, field_id, alias
FROM `triholog_jshopping_products_extra_field_values`
order by ordering
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | triholog_jshopping_products_extra_field_values | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 56 | 100.00 | Using filesort |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| Sorting result | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.14 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/tables/productfieldvalue.php:25 |
| 17 | jshopProductFieldValue->getAllList() | JROOT/components/com_jshopping/router.php:281 |
| 16 | jshoppingParseRoute() | JROOT/libraries/cms/component/router/legacy.php:104 |
| 15 | JComponentRouterLegacy->parse() | JROOT/libraries/cms/router/site.php:432 |
| 14 | JRouterSite->parseSefRoute() | JROOT/libraries/cms/router/router.php:483 |
| 13 | JRouter->_parseSefRoute() | JROOT/administrator/components/com_sh404sef/classes/router.php:362 |
| 12 | Sh404sefClassRouterInternal->_parseSefRouteInternal() | JROOT/administrator/components/com_sh404sef/classes/router.php:1432 |
| 11 | Sh404sefClassRouter->_parseSefRoute() | JROOT/administrator/components/com_sh404sef/classes/router.php:110 |
| 10 | Sh404sefClassRouterInternal->parseRule() | JROOT/libraries/cms/router/router.php:597 |
| 9 | JRouter->processParseRules() | JROOT/libraries/cms/router/site.php:584 |
| 8 | JRouterSite->processParseRules() | JROOT/libraries/cms/router/router.php:571 |
| 7 | JRouter->_processParseRules() | JROOT/libraries/cms/router/router.php:225 |
| 6 | JRouter->parse() | JROOT/libraries/cms/router/site.php:133 |
| 5 | JRouterSite->parse() | JROOT/libraries/cms/application/cms.php:1158 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:272 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.29 ms After last query: 0.44 ms Query memory: 0.030 MB Memory before query: 3.523 MB Rows returned: 56
SELECT id, `name_ru-RU` as name, field_id, alias
FROM `triholog_jshopping_products_extra_field_values`
order by ordering
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | triholog_jshopping_products_extra_field_values | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 56 | 100.00 | Using filesort |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| Sorting result | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.12 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/tables/productfieldvalue.php:25 |
| 11 | jshopProductFieldValue->getAllList() | JROOT/components/com_jshopping/router.php:281 |
| 10 | jshoppingParseRoute() | JROOT/libraries/cms/component/router/legacy.php:104 |
| 9 | JComponentRouterLegacy->parse() | JROOT/libraries/cms/router/site.php:432 |
| 8 | JRouterSite->parseSefRoute() | JROOT/libraries/cms/router/router.php:483 |
| 7 | JRouter->_parseSefRoute() | JROOT/libraries/cms/router/router.php:236 |
| 6 | JRouter->parse() | JROOT/libraries/cms/router/site.php:133 |
| 5 | JRouterSite->parse() | JROOT/libraries/cms/application/cms.php:1158 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:272 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.16 ms After last query: 0.34 ms Query memory: 0.023 MB Memory before query: 3.529 MB Rows returned: 0
SELECT *
FROM triholog_rsfirewall_hashes
WHERE (`type`='3.7.4' OR `type`='protect')
AND `flag`!='C'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | triholog_rsfirewall_hashes | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 5 | 28.80 | Using where |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 9 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rsfirewall/rsfirewall.php:949 |
| 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/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:1167 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:272 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.12 ms After last query: 0.20 ms Query memory: 0.023 MB Memory before query: 3.536 MB Rows returned: 0
SELECT *
FROM triholog_rsfirewall_snapshots
WHERE `type`='protect'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | triholog_rsfirewall_snapshots | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 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.00 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_rsfirewall/helpers/snapshot.php:47 |
| 9 | RSFirewallSnapshot::get() | JROOT/plugins/system/rsfirewall/rsfirewall.php:972 |
| 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/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:1167 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:272 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.17 ms After last query: 0.11 ms Query memory: 0.023 MB Memory before query: 3.542 MB Rows returned: 0
SELECT `ip`,`reason`
FROM triholog_rsfirewall_lists
WHERE (`ip`='216.73.217.94' 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 | triholog_rsfirewall_lists | NULL | ref | published,type | type | 1 | const | 1 | 36.79 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.00 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.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rsfirewall/rsfirewall.php:168 |
| 10 | plgSystemRSFirewall->isListed() | JROOT/plugins/system/rsfirewall/rsfirewall.php:147 |
| 9 | plgSystemRSFirewall->isWhitelisted() | JROOT/plugins/system/rsfirewall/rsfirewall.php:1000 |
| 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/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:1167 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:272 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.17 ms After last query: 0.10 ms Query memory: 0.023 MB Memory before query: 3.547 MB Rows returned: 0
SELECT `ip`,`reason`
FROM triholog_rsfirewall_lists
WHERE (`ip`='216.73.217.94' 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 | triholog_rsfirewall_lists | NULL | ALL | published,type | NO INDEX KEY COULD BE USED | NULL | NULL | 14 | 36.79 | Using where |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.03 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rsfirewall/rsfirewall.php:168 |
| 10 | plgSystemRSFirewall->isListed() | JROOT/plugins/system/rsfirewall/rsfirewall.php:137 |
| 9 | plgSystemRSFirewall->isBlacklisted() | JROOT/plugins/system/rsfirewall/rsfirewall.php:1004 |
| 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/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:1167 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:272 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.17 ms After last query: 0.57 ms Query memory: 0.025 MB Memory before query: 3.556 MB Rows returned: 0
SELECT *
FROM triholog_rsfirewall_exceptions
WHERE `published`='1'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | triholog_rsfirewall_exceptions | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rsfirewall/rsfirewall.php:642 |
| 9 | plgSystemRSFirewall->isException() | JROOT/plugins/system/rsfirewall/rsfirewall.php:1052 |
| 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/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:1167 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:272 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.63 ms After last query: 0.49 ms Query memory: 0.031 MB Memory before query: 3.566 MB Rows returned: 46
SELECT `id`,`name`,`rules`,`parent_id`
FROM `triholog_assets`
WHERE `name` IN ('root.1','com_acymailing','com_admin','com_advancedmodules','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_consult','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_jshopping','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_rsfirewall','com_rsform','com_search','com_sh404sef','com_tags','com_templates','com_users','com_weblinks','com_widgetkit','com_wrapper','com_xmap','com_zhyandexmap','com_zoo')
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | triholog_assets | NULL | ALL | idx_asset_name | NO INDEX KEY COULD BE USED | NULL | NULL | 188 | 25.00 | Using where |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.05 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.12 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.28 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/access/access.php:427 |
| 17 | JAccess::preloadComponents() | JROOT/libraries/joomla/access/access.php:211 |
| 16 | JAccess::preload() | JROOT/libraries/joomla/access/access.php:529 |
| 15 | JAccess::getAssetRules() | JROOT/libraries/joomla/access/access.php:181 |
| 14 | JAccess::check() | JROOT/libraries/joomla/user/user.php:393 |
| 13 | JUser->authorise() | JROOT/plugins/system/advancedmodules/src/Document.php:28 |
| 12 | RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript() | JROOT/plugins/system/advancedmodules/src/Helper.php:32 |
| 11 | RegularLabs\Plugin\System\AdvancedModules\Helper->onAfterRoute() | Same as call in the line below. |
| 10 | call_user_func_array() | JROOT/plugins/system/advancedmodules/src/Plugin.php:97 |
| 9 | RegularLabs\Plugin\System\AdvancedModules\Plugin->run() | JROOT/plugins/system/advancedmodules/advancedmodules.php:64 |
| 8 | PlgSystemAdvancedModules->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:1167 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:272 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.33 ms After last query: 1.47 ms Query memory: 0.005 MB Memory before query: 3.641 MB
UPDATE `triholog_extensions`
SET `params` = '{\"mediaversion\":\"40404b6408941480482705698678a3eb\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | UPDATE | triholog_extensions | NULL | range | element_clientid,element_folder_clientid,extension | extension | 364 | const,const | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.06 ms |
| updating | 0.05 ms |
| end | 0.00 ms |
| query end | 0.05 ms |
| closing tables | 0.03 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/cms/library/helper.php:116 |
| 9 | JLibraryHelper::saveParams() | JROOT/libraries/cms/version/version.php:321 |
| 8 | JVersion->setMediaVersion() | JROOT/libraries/cms/version/version.php:280 |
| 7 | JVersion->getMediaVersion() | JROOT/libraries/joomla/factory.php:760 |
| 6 | JFactory::createDocument() | JROOT/libraries/joomla/factory.php:216 |
| 5 | JFactory::getDocument() | JROOT/libraries/joomla/application/web.php:1023 |
| 4 | JApplicationWeb->loadDocument() | JROOT/libraries/cms/application/site.php:130 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:272 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.26 ms After last query: 4.85 ms Query memory: 0.024 MB Memory before query: 3.755 MB Rows returned: 2
select *
from triholog_jshopping_languages
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | triholog_jshopping_languages | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.08 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 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.02 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 9 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/lib/functions.php:290 |
| 8 | installNewLanguages() | JROOT/components/com_jshopping/loadparams.php:33 |
| 7 | require JROOT/components/com_jshopping/loadparams.php | JROOT/components/com_jshopping/jshopping.php:16 |
| 6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/cms/component/helper.php:389 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:364 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:272 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.48 ms After last query: 0.93 ms Query memory: 0.031 MB Memory before query: 3.782 MB Rows returned: 25
SHOW FULL COLUMNS
FROM `triholog_jshopping_categories`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `triholog_jshopping_categories`
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.10 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Opening tables | 0.03 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 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 |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 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 |
| checking permissions | 0.01 ms |
| Sending data | 0.05 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.02 ms |
| closing tables | 0.00 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:440 |
| 14 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/joomla/table/table.php:244 |
| 13 | JTable->getFields() | JROOT/libraries/joomla/table/table.php:163 |
| 12 | JTable->__construct() | JROOT/components/com_jshopping/tables/category.php:15 |
| 11 | jshopCategory->__construct() | JROOT/libraries/joomla/table/table.php:311 |
| 10 | JTable::getInstance() | JROOT/components/com_jshopping/lib/factory.php:601 |
| 9 | JSFactory::getTable() | JROOT/components/com_jshopping/controllers/category.php:56 |
| 8 | JshoppingControllerCategory->view() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
| 6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/cms/component/helper.php:389 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:364 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:272 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.25 ms After last query: 0.27 ms Query memory: 0.033 MB Memory before query: 3.843 MB Rows returned: 1
SELECT *
FROM triholog_jshopping_categories
WHERE `category_id` = '1'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | triholog_jshopping_categories | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.03 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1445 |
| 10 | JDatabaseDriver->loadAssoc() | JROOT/libraries/joomla/table/table.php:729 |
| 9 | JTable->load() | JROOT/components/com_jshopping/controllers/category.php:57 |
| 8 | JshoppingControllerCategory->view() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
| 6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/cms/component/helper.php:389 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:364 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:272 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.36 ms After last query: 1.87 ms Query memory: 0.031 MB Memory before query: 3.901 MB Rows returned: 10
SHOW FULL COLUMNS
FROM `triholog_jshopping_products_reviews`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `triholog_jshopping_products_reviews`
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.09 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.00 ms |
| executing | 0.01 ms |
| Opening tables | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending data | 0.03 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.02 ms |
| closing tables | 0.00 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:440 |
| 20 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/joomla/table/table.php:244 |
| 19 | JTable->getFields() | JROOT/libraries/joomla/table/table.php:163 |
| 18 | JTable->__construct() | JROOT/components/com_jshopping/tables/review.php:14 |
| 17 | jshopReview->__construct() | JROOT/libraries/joomla/table/table.php:311 |
| 16 | JTable::getInstance() | JROOT/plugins/content/jshopproductinsert/jshopproductinsert.php:37 |
| 15 | plgContentJshopProductInsert->_initJSConfig() | JROOT/plugins/content/jshopproductinsert/jshopproductinsert.php:120 |
| 14 | plgContentJshopProductInsert->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 13 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 12 | JEventDispatcher->trigger() | JROOT/components/com_jshopping/lib/functions.php:947 |
| 11 | changeDataUsePluginContent() | JROOT/components/com_jshopping/tables/category.php:257 |
| 10 | jshopCategory->preparePluginContent() | JROOT/components/com_jshopping/tables/category.php:66 |
| 9 | jshopCategory->getDescription() | JROOT/components/com_jshopping/controllers/category.php:58 |
| 8 | JshoppingControllerCategory->view() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
| 6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/cms/component/helper.php:389 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:364 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:272 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.89 ms After last query: 0.19 ms Query memory: 0.030 MB Memory before query: 3.930 MB Rows returned: 33
select id,link
from triholog_menu
where `type`='component'
and published=1
and link like '%option=com_jshopping%'
and client_id=0
and (language='*' or language='ru-RU')
and access IN (1,1)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | triholog_menu | NULL | ref | idx_client_id_parent_id_alias_language,idx_language | idx_client_id_parent_id_alias_language | 1 | const | 116 | 0.46 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.07 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 0.61 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 22 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/lib/shop_item_menu.php:136 |
| 21 | shopItemMenu->getList() | JROOT/components/com_jshopping/lib/shop_item_menu.php:46 |
| 20 | shopItemMenu->init() | JROOT/components/com_jshopping/lib/shop_item_menu.php:39 |
| 19 | shopItemMenu::getInstance() | JROOT/components/com_jshopping/lib/functions.php:396 |
| 18 | getShopMainPageItemid() | JROOT/components/com_jshopping/lib/functions.php:415 |
| 17 | getDefaultItemid() | JROOT/components/com_jshopping/lib/functions.php:488 |
| 16 | SEFLink() | JROOT/plugins/content/jshopproductinsert/jshopproductinsert.php:44 |
| 15 | plgContentJshopProductInsert->_initJSConfig() | JROOT/plugins/content/jshopproductinsert/jshopproductinsert.php:120 |
| 14 | plgContentJshopProductInsert->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 13 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 12 | JEventDispatcher->trigger() | JROOT/components/com_jshopping/lib/functions.php:947 |
| 11 | changeDataUsePluginContent() | JROOT/components/com_jshopping/tables/category.php:257 |
| 10 | jshopCategory->preparePluginContent() | JROOT/components/com_jshopping/tables/category.php:66 |
| 9 | jshopCategory->getDescription() | JROOT/components/com_jshopping/controllers/category.php:58 |
| 8 | JshoppingControllerCategory->view() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
| 6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/cms/component/helper.php:389 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:364 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:272 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.33 ms After last query: 0.87 ms Query memory: 0.025 MB Memory before query: 4.045 MB Rows returned: 0
SELECT `name_ru-RU` as name,`description_ru-RU` as description,`short_description_ru-RU` as short_description, category_id, category_publish, ordering, category_image
FROM `triholog_jshopping_categories`
WHERE category_parent_id = '1'
AND category_publish = '1'
AND access IN (1,1)
ORDER BY ordering asc
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | triholog_jshopping_categories | NULL | ref | category_parent_id,category_publish,access,category_publish_2 | category_parent_id | 4 | const | 1 | 58.06 | Using index condition; Using where; Using filesort |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.06 ms |
| preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.03 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/tables/category.php:34 |
| 10 | jshopCategory->getSubCategories() | JROOT/components/com_jshopping/tables/category.php:119 |
| 9 | jshopCategory->getChildCategories() | JROOT/components/com_jshopping/controllers/category.php:66 |
| 8 | JshoppingControllerCategory->view() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
| 6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/cms/component/helper.php:389 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:364 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:272 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.70 ms After last query: 0.77 ms Query memory: 0.037 MB Memory before query: 4.068 MB Rows returned: 31
SHOW FULL COLUMNS
FROM `triholog_jshopping_vendors`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `triholog_jshopping_vendors`
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.12 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Opening tables | 0.11 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 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.09 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.03 ms |
| closing tables | 0.00 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:440 |
| 18 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/joomla/table/table.php:244 |
| 17 | JTable->getFields() | JROOT/libraries/joomla/table/table.php:163 |
| 16 | JTable->__construct() | JROOT/components/com_jshopping/tables/vendor.php:15 |
| 15 | jshopVendor->__construct() | JROOT/libraries/joomla/table/table.php:311 |
| 14 | JTable::getInstance() | JROOT/components/com_jshopping/lib/factory.php:601 |
| 13 | JSFactory::getTable() | JROOT/components/com_jshopping/lib/factory.php:415 |
| 12 | JSFactory::getMainVendor() | JROOT/components/com_jshopping/lib/functions.php:1444 |
| 11 | getBuildFilterListProduct() | JROOT/components/com_jshopping/tables/category.php:310 |
| 10 | jshopCategory->getFilterListProduct() | JROOT/components/com_jshopping/models/productlist.php:168 |
| 9 | jshopProductList->load() | JROOT/components/com_jshopping/controllers/category.php:74 |
| 8 | JshoppingControllerCategory->view() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
| 6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/cms/component/helper.php:389 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:364 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:272 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.17 ms After last query: 0.24 ms Query memory: 0.024 MB Memory before query: 4.130 MB Rows returned: 1
SELECT id
FROM triholog_jshopping_vendors
WHERE `main`=1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | triholog_jshopping_vendors | NULL | ref | main | main | 1 | const | 1 | 100.00 | Using index |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1720 |
| 14 | JDatabaseDriver->loadResult() | JROOT/components/com_jshopping/tables/vendor.php:23 |
| 13 | jshopVendor->loadMain() | JROOT/components/com_jshopping/lib/factory.php:416 |
| 12 | JSFactory::getMainVendor() | JROOT/components/com_jshopping/lib/functions.php:1444 |
| 11 | getBuildFilterListProduct() | JROOT/components/com_jshopping/tables/category.php:310 |
| 10 | jshopCategory->getFilterListProduct() | JROOT/components/com_jshopping/models/productlist.php:168 |
| 9 | jshopProductList->load() | JROOT/components/com_jshopping/controllers/category.php:74 |
| 8 | JshoppingControllerCategory->view() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
| 6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/cms/component/helper.php:389 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:364 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:272 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.22 ms After last query: 0.14 ms Query memory: 0.037 MB Memory before query: 4.141 MB Rows returned: 1
SELECT *
FROM triholog_jshopping_vendors
WHERE `id` = '1'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | triholog_jshopping_vendors | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.03 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.03 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1445 |
| 15 | JDatabaseDriver->loadAssoc() | JROOT/libraries/joomla/table/table.php:729 |
| 14 | JTable->load() | JROOT/components/com_jshopping/tables/vendor.php:24 |
| 13 | jshopVendor->loadMain() | JROOT/components/com_jshopping/lib/factory.php:416 |
| 12 | JSFactory::getMainVendor() | JROOT/components/com_jshopping/lib/functions.php:1444 |
| 11 | getBuildFilterListProduct() | JROOT/components/com_jshopping/tables/category.php:310 |
| 10 | jshopCategory->getFilterListProduct() | JROOT/components/com_jshopping/models/productlist.php:168 |
| 9 | jshopProductList->load() | JROOT/components/com_jshopping/controllers/category.php:74 |
| 8 | JshoppingControllerCategory->view() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
| 6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/cms/component/helper.php:389 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:364 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:272 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.48 ms After last query: 0.32 ms Query memory: 0.031 MB Memory before query: 4.150 MB Rows returned: 11
SHOW FULL COLUMNS
FROM `triholog_jshopping_products_extra_fields`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `triholog_jshopping_products_extra_fields`
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.10 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Opening tables | 0.06 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending data | 0.05 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.03 ms |
| closing tables | 0.00 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:440 |
| 19 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/joomla/table/table.php:244 |
| 18 | JTable->getFields() | JROOT/libraries/joomla/table/table.php:163 |
| 17 | JTable->__construct() | JROOT/components/com_jshopping/tables/productfield.php:14 |
| 16 | jshopProductField->__construct() | JROOT/libraries/joomla/table/table.php:311 |
| 15 | JTable::getInstance() | JROOT/components/com_jshopping/lib/factory.php:601 |
| 14 | JSFactory::getTable() | JROOT/components/com_jshopping/lib/factory.php:476 |
| 13 | JSFactory::getAllProductExtraField() | JROOT/components/com_jshopping/lib/functions.php:1132 |
| 12 | getQueryListProductsExtraFields() | JROOT/components/com_jshopping/lib/jtableauto.php:37 |
| 11 | JTableAvto->getBuildQueryListProduct() | JROOT/components/com_jshopping/tables/category.php:177 |
| 10 | jshopCategory->getCountProducts() | JROOT/components/com_jshopping/models/productlist.php:172 |
| 9 | jshopProductList->load() | JROOT/components/com_jshopping/controllers/category.php:74 |
| 8 | JshoppingControllerCategory->view() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
| 6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/cms/component/helper.php:389 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:364 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:272 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.53 ms After last query: 0.12 ms Query memory: 0.029 MB Memory before query: 4.180 MB Rows returned: 11
SELECT F.id, F.`name_ru-RU` as name, F.`description_ru-RU` as description, F.allcats, F.type, F.cats, F.ordering, F.`
group`, G.`name_ru-RU` as groupname, multilist
FROM `triholog_jshopping_products_extra_fields` as F
left join `triholog_jshopping_products_extra_field_groups` as G
on G.id=F.
group
order by G.ordering, F.ordering
| 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 | 10 | 100.00 | Using temporary; Using filesort |
| 1 | SIMPLE | G | NULL | ALL | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where; Using join buffer (Block Nested Loop) |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.08 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.02 ms |
| Creating tmp table | 0.02 ms |
| Sorting result | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.11 ms |
| Creating sort index | 0.06 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| removing tmp table | 0.03 ms |
| query end | 0.00 ms |
| closing tables | 0.05 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/tables/productfield.php:48 |
| 14 | jshopProductField->getList() | JROOT/components/com_jshopping/lib/factory.php:477 |
| 13 | JSFactory::getAllProductExtraField() | JROOT/components/com_jshopping/lib/functions.php:1132 |
| 12 | getQueryListProductsExtraFields() | JROOT/components/com_jshopping/lib/jtableauto.php:37 |
| 11 | JTableAvto->getBuildQueryListProduct() | JROOT/components/com_jshopping/tables/category.php:177 |
| 10 | jshopCategory->getCountProducts() | JROOT/components/com_jshopping/models/productlist.php:172 |
| 9 | jshopProductList->load() | JROOT/components/com_jshopping/controllers/category.php:74 |
| 8 | JshoppingControllerCategory->view() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
| 6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/cms/component/helper.php:389 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:364 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:272 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.36 ms After last query: 0.32 ms Query memory: 0.030 MB Memory before query: 4.209 MB Rows returned: 3
SHOW FULL COLUMNS
FROM `triholog_jshopping_taxes`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `triholog_jshopping_taxes`
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.11 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.00 ms |
| executing | 0.01 ms |
| Opening tables | 0.06 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending data | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.02 ms |
| closing tables | 0.00 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:440 |
| 20 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/joomla/table/table.php:244 |
| 19 | JTable->getFields() | JROOT/libraries/joomla/table/table.php:163 |
| 18 | JTable->__construct() | JROOT/components/com_jshopping/tables/tax.php:14 |
| 17 | jshopTax->__construct() | JROOT/libraries/joomla/table/table.php:311 |
| 16 | JTable::getInstance() | JROOT/components/com_jshopping/lib/factory.php:601 |
| 15 | JSFactory::getTable() | JROOT/components/com_jshopping/lib/factory.php:349 |
| 14 | JSFactory::getAllTaxes() | JROOT/components/com_jshopping/lib/functions.php:988 |
| 13 | getCorrectedPriceForQueryFilter() | JROOT/components/com_jshopping/lib/jtableauto.php:101 |
| 12 | JTableAvto->getBuildQueryListProductFilterPrice() | JROOT/components/com_jshopping/lib/jtableauto.php:88 |
| 11 | JTableAvto->getBuildQueryListProduct() | JROOT/components/com_jshopping/tables/category.php:177 |
| 10 | jshopCategory->getCountProducts() | JROOT/components/com_jshopping/models/productlist.php:172 |
| 9 | jshopProductList->load() | JROOT/components/com_jshopping/controllers/category.php:74 |
| 8 | JshoppingControllerCategory->view() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
| 6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/cms/component/helper.php:389 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:364 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:272 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.12 ms After last query: 0.09 ms Query memory: 0.027 MB Memory before query: 4.226 MB Rows returned: 1
SELECT tax_id, tax_name, tax_value
FROM `triholog_jshopping_taxes`
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | triholog_jshopping_taxes | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/tables/tax.php:21 |
| 16 | jshopTax->getAllTaxes() | JROOT/components/com_jshopping/lib/factory.php:335 |
| 15 | JSFactory::getAllTaxesOriginal() | JROOT/components/com_jshopping/lib/factory.php:350 |
| 14 | JSFactory::getAllTaxes() | JROOT/components/com_jshopping/lib/functions.php:988 |
| 13 | getCorrectedPriceForQueryFilter() | JROOT/components/com_jshopping/lib/jtableauto.php:101 |
| 12 | JTableAvto->getBuildQueryListProductFilterPrice() | JROOT/components/com_jshopping/lib/jtableauto.php:88 |
| 11 | JTableAvto->getBuildQueryListProduct() | JROOT/components/com_jshopping/tables/category.php:177 |
| 10 | jshopCategory->getCountProducts() | JROOT/components/com_jshopping/models/productlist.php:172 |
| 9 | jshopProductList->load() | JROOT/components/com_jshopping/controllers/category.php:74 |
| 8 | JshoppingControllerCategory->view() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
| 6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/cms/component/helper.php:389 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:364 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:272 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.38 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 4.233 MB Rows returned: 1
SELECT count(*)
FROM `triholog_jshopping_products_to_categories` AS pr_cat
INNER JOIN `triholog_jshopping_products` AS prod
ON pr_cat.product_id = prod.product_id
WHERE pr_cat.category_id=1
AND prod.product_publish=1
AND prod.access IN (1,1)
AND ( find_in_set('11', prod.`extra_field_1`) )
AND ( find_in_set('49', prod.`extra_field_3`) )
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | prod | NULL | ref | PRIMARY,product_publish,access | product_publish | 1 | const | 13 | 100.00 | Using where |
| 1 | SIMPLE | pr_cat | NULL | eq_ref | PRIMARY,category_id,product_id,product_id_2 | PRIMARY | 8 | cy85373_triholog.prod.product_id,const | 1 | 100.00 | Using index |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.07 ms |
| init | 0.02 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.06 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.09 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.02 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1720 |
| 11 | JDatabaseDriver->loadResult() | JROOT/components/com_jshopping/tables/category.php:187 |
| 10 | jshopCategory->getCountProducts() | JROOT/components/com_jshopping/models/productlist.php:172 |
| 9 | jshopProductList->load() | JROOT/components/com_jshopping/controllers/category.php:74 |
| 8 | JshoppingControllerCategory->view() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
| 6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/cms/component/helper.php:389 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:364 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:272 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.28 ms After last query: 0.55 ms Query memory: 0.034 MB Memory before query: 4.245 MB Rows returned: 56
SELECT id, `name_ru-RU` as name, field_id, alias
FROM `triholog_jshopping_products_extra_field_values`
order by ordering
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | triholog_jshopping_products_extra_field_values | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 56 | 100.00 | Using filesort |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| Sorting result | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.13 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 20 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/tables/productfieldvalue.php:25 |
| 19 | jshopProductFieldValue->getAllList() | JROOT/components/com_jshopping/router.php:230 |
| 18 | jshoppingBuildRoute() | JROOT/libraries/cms/component/router/legacy.php:68 |
| 17 | JComponentRouterLegacy->build() | JROOT/libraries/cms/router/site.php:519 |
| 16 | JRouterSite->buildSefRoute() | JROOT/libraries/cms/router/site.php:489 |
| 15 | JRouterSite->_buildSefRoute() | JROOT/libraries/cms/router/router.php:282 |
| 14 | JRouter->build() | JROOT/libraries/cms/router/site.php:149 |
| 13 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 12 | JRoute::_() | JROOT/administrator/components/com_sh404sef/pagination_j3.php:917 |
| 11 | JPagination->_buildDataObject() | JROOT/administrator/components/com_sh404sef/pagination_j3.php:314 |
| 10 | JPagination->getPagesLinks() | JROOT/components/com_jshopping/models/productlist.php:181 |
| 9 | jshopProductList->load() | JROOT/components/com_jshopping/controllers/category.php:74 |
| 8 | JshoppingControllerCategory->view() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
| 6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/cms/component/helper.php:389 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:364 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:272 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.53 ms After last query: 0.41 ms Query memory: 0.031 MB Memory before query: 4.255 MB Rows returned: 0
SELECT prod.product_id, prod.product_primary_category, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.`extra_field_4` , prod.`extra_field_9` , prod.`extra_field_10` , prod.`extra_field_11`
FROM `triholog_jshopping_products` AS prod
LEFT JOIN `triholog_jshopping_products_to_categories` AS pr_cat USING (product_id)
WHERE pr_cat.category_id=1
AND prod.product_publish=1
AND prod.access IN (1,1)
AND ( find_in_set('11', prod.`extra_field_1`) )
AND ( find_in_set('49', prod.`extra_field_3`) )
ORDER BY pr_cat.product_ordering ASC
LIMIT 0, 15
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | prod | NULL | ref | PRIMARY,product_publish,access | product_publish | 1 | const | 13 | 100.00 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | pr_cat | NULL | eq_ref | PRIMARY,category_id,product_id,product_id_2 | PRIMARY | 8 | cy85373_triholog.prod.product_id,const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.07 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.06 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.06 ms |
| preparing | 0.02 ms |
| Creating tmp table | 0.04 ms |
| Sorting result | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.14 ms |
| Creating sort index | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| removing tmp table | 0.02 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/tables/category.php:169 |
| 10 | jshopCategory->getProducts() | JROOT/components/com_jshopping/models/productlist.php:186 |
| 9 | jshopProductList->load() | JROOT/components/com_jshopping/controllers/category.php:74 |
| 8 | JshoppingControllerCategory->view() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
| 6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/cms/component/helper.php:389 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:364 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:272 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.56 ms After last query: 0.27 ms Query memory: 0.038 MB Memory before query: 4.269 MB Rows returned: 53
SHOW FULL COLUMNS
FROM `triholog_jshopping_users`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `triholog_jshopping_users`
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.07 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.00 ms |
| executing | 0.01 ms |
| Opening tables | 0.03 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 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 |
| checking permissions | 0.02 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 |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 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 |
| 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 |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 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.01 ms |
| Sending data | 0.07 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.02 ms |
| closing tables | 0.00 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:440 |
| 17 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/joomla/table/table.php:244 |
| 16 | JTable->getFields() | JROOT/libraries/joomla/table/table.php:163 |
| 15 | JTable->__construct() | JROOT/components/com_jshopping/tables/usershopbase.php:14 |
| 14 | jshopUserShopBase->__construct() | JROOT/components/com_jshopping/tables/usershop.php:15 |
| 13 | jshopUserShop->__construct() | JROOT/components/com_jshopping/lib/factory.php:47 |
| 12 | JSFactory::getUserShop() | JROOT/components/com_jshopping/lib/functions.php:674 |
| 11 | listProductUpdateData() | JROOT/components/com_jshopping/tables/category.php:170 |
| 10 | jshopCategory->getProducts() | JROOT/components/com_jshopping/models/productlist.php:186 |
| 9 | jshopProductList->load() | JROOT/components/com_jshopping/controllers/category.php:74 |
| 8 | JshoppingControllerCategory->view() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
| 6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/cms/component/helper.php:389 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:364 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:272 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.21 ms After last query: 0.26 ms Query memory: 0.025 MB Memory before query: 4.373 MB Rows returned: 7
select manufacturer_id as id, `name_ru-RU` as name, manufacturer_logo, manufacturer_url
from triholog_jshopping_manufacturers
where manufacturer_publish='1'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | triholog_jshopping_manufacturers | NULL | ALL | manufacturer_publish | NO INDEX KEY COULD BE USED | NULL | NULL | 8 | 87.50 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.03 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/lib/factory.php:402 |
| 12 | JSFactory::getAllManufacturer() | JROOT/components/com_jshopping/lib/functions.php:677 |
| 11 | listProductUpdateData() | JROOT/components/com_jshopping/tables/category.php:170 |
| 10 | jshopCategory->getProducts() | JROOT/components/com_jshopping/models/productlist.php:186 |
| 9 | jshopProductList->load() | JROOT/components/com_jshopping/controllers/category.php:74 |
| 8 | JshoppingControllerCategory->view() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
| 6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/cms/component/helper.php:389 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:364 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:272 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.22 ms After last query: 3.01 ms Query memory: 0.024 MB Memory before query: 4.463 MB Rows returned: 1
SELECT params
FROM triholog_extensions AS e
WHERE e.element='com_widgetkit'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid | element_clientid | 302 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.04 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1720 |
| 14 | JDatabaseDriver->loadResult() | JROOT/administrator/components/com_widgetkit/helpers/system.php:254 |
| 13 | SystemWidgetkitHelper->_getParams() | JROOT/administrator/components/com_widgetkit/helpers/system.php:54 |
| 12 | SystemWidgetkitHelper->__construct() | JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:129 |
| 11 | Widgetkit->loadHelper() | JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:76 |
| 10 | Widgetkit->getHelper() | JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:137 |
| 9 | Widgetkit->offsetGet() | JROOT/administrator/components/com_widgetkit/widgetkit.php:17 |
| 8 | require_once JROOT/administrator/components/com_widgetkit/widgetkit.php | JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20 |
| 7 | plgSystemWidgetkit_System->onAfterDispatch() | JROOT/libraries/joomla/event/event.php:70 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 4 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/site.php:196 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:272 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.22 ms After last query: 6.55 ms Query memory: 0.029 MB Memory before query: 4.915 MB Rows returned: 0
SELECT `oldurl`, `dateadd`
FROM triholog_sh404sef_urls
WHERE `newurl`='index.php?option=com_widgetkit&format=raw&id=&lang=ru';
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | triholog_sh404sef_urls | NULL | ref | newurl | newurl | 767 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.04 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1642 |
| 25 | JDatabaseDriver->loadObject() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:605 |
| 24 | ShlDbClass->loadObject() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:412 |
| 23 | ShlDbClass->shlLoadObject() | JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655 |
| 22 | ShlDbHelper::selectObject() | JROOT/administrator/components/com_sh404sef/sh404sef.class.php:995 |
| 21 | getSefUrlFromDatabase() | JROOT/administrator/components/com_sh404sef/sh404sef.class.php:1022 |
| 20 | shGetSefURLFromCacheOrDB() | JROOT/administrator/components/com_sh404sef/sh404sef.class.php:1610 |
| 19 | shSefRelToAbs() | JROOT/administrator/components/com_sh404sef/classes/router.php:508 |
| 18 | Sh404sefClassRouterInternal->_buildSefRouteInternal() | JROOT/administrator/components/com_sh404sef/classes/router.php:1436 |
| 17 | Sh404sefClassRouter->_buildSefRoute() | JROOT/administrator/components/com_sh404sef/classes/router.php:248 |
| 16 | Sh404sefClassRouterInternal->buildRule() | JROOT/libraries/cms/router/router.php:639 |
| 15 | JRouter->processBuildRules() | JROOT/libraries/cms/router/site.php:645 |
| 14 | JRouterSite->processBuildRules() | JROOT/libraries/cms/router/router.php:615 |
| 13 | JRouter->_processBuildRules() | JROOT/libraries/cms/router/router.php:271 |
| 12 | JRouter->build() | JROOT/libraries/cms/router/site.php:149 |
| 11 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 10 | JRoute::_() | JROOT/administrator/components/com_widgetkit/helpers/system.php:162 |
| 9 | SystemWidgetkitHelper->init() | JROOT/administrator/components/com_widgetkit/widgetkit.php:17 |
| 8 | require_once JROOT/administrator/components/com_widgetkit/widgetkit.php | JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20 |
| 7 | plgSystemWidgetkit_System->onAfterDispatch() | JROOT/libraries/joomla/event/event.php:70 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 4 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/site.php:196 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:272 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.21 ms After last query: 7.31 ms Query memory: 0.006 MB Memory before query: 5.100 MB
DELETE
FROM `triholog_session`
WHERE `time` < '1791806977'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | DELETE | triholog_session | NULL | range | time | time | 45 | const | 3 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.03 ms |
| updating | 0.03 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/cms/application/cms.php:834 |
| 11 | JApplicationCms->loadSession() | JROOT/libraries/cms/application/cms.php:132 |
| 10 | JApplicationCms->__construct() | JROOT/libraries/cms/application/site.php:63 |
| 9 | JApplicationSite->__construct() | JROOT/templates/tpl_triholog/includes/head.php:7 |
| 8 | include JROOT/templates/tpl_triholog/includes/head.php | JROOT/templates/tpl_triholog/index.php:5 |
| 7 | require JROOT/templates/tpl_triholog/index.php | JROOT/libraries/joomla/document/html.php:653 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:715 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:530 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1114 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:278 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.14 ms After last query: 0.09 ms Query memory: 0.024 MB Memory before query: 5.108 MB Rows returned: 1
SELECT `session_id`
FROM `triholog_session`
WHERE `session_id` = '050464f675e9c6b10f568ad148574a8f'
LIMIT 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | triholog_session | NULL | const | PRIMARY | PRIMARY | 575 | const | 1 | 100.00 | Using index |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 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.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1720 |
| 13 | JDatabaseDriver->loadResult() | JROOT/libraries/cms/application/cms.php:177 |
| 12 | JApplicationCms->checkSession() | JROOT/libraries/cms/application/cms.php:843 |
| 11 | JApplicationCms->loadSession() | JROOT/libraries/cms/application/cms.php:132 |
| 10 | JApplicationCms->__construct() | JROOT/libraries/cms/application/site.php:63 |
| 9 | JApplicationSite->__construct() | JROOT/templates/tpl_triholog/includes/head.php:7 |
| 8 | include JROOT/templates/tpl_triholog/includes/head.php | JROOT/templates/tpl_triholog/index.php:5 |
| 7 | require JROOT/templates/tpl_triholog/index.php | JROOT/libraries/joomla/document/html.php:653 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:715 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:530 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1114 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:278 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 2.13 ms After last query: 0.30 ms Query memory: 0.138 MB Memory before query: 5.117 MB Rows returned: 71
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params as advancedparams, 0 as menuid, m.publish_up, m.publish_down
FROM triholog_modules AS m
LEFT JOIN triholog_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
LEFT JOIN triholog_advancedmodules as am
ON am.moduleid = m.id
WHERE m.published = 1
AND e.enabled = 1
AND m.access IN (1,1)
AND m.client_id = 0
ORDER BY m.position, m.ordering
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | ALL | published,newsfeeds | NO INDEX KEY COULD BE USED | NULL | NULL | 124 | 5.97 | Using where; Using filesort |
| 1 | SIMPLE | am | NULL | eq_ref | PRIMARY | PRIMARY | 4 | cy85373_triholog.m.id | 1 | 100.00 | Using where |
| 1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid | element_clientid | 303 | cy85373_triholog.m.module,const | 1 | 10.00 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.05 ms |
| preparing | 0.02 ms |
| Sorting result | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 1.81 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.02 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:404 |
| 15 | PlgSystemAdvancedModuleHelper->getModuleList() | JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:123 |
| 14 | PlgSystemAdvancedModuleHelper->onPrepareModuleList() | JROOT/libraries/joomla/event/dispatcher.php:165 |
| 13 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 12 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/module/helper.php:364 |
| 11 | JModuleHelper::load() | JROOT/libraries/cms/module/helper.php:84 |
| 10 | JModuleHelper::getModules() | JROOT/libraries/joomla/document/html.php:576 |
| 9 | JDocumentHtml->countModules() | JROOT/templates/tpl_triholog/includes/head.php:35 |
| 8 | include JROOT/templates/tpl_triholog/includes/head.php | JROOT/templates/tpl_triholog/index.php:5 |
| 7 | require JROOT/templates/tpl_triholog/index.php | JROOT/libraries/joomla/document/html.php:653 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:715 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:530 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1114 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:278 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.26 ms After last query: 18.45 ms Query memory: 0.032 MB Memory before query: 5.694 MB Rows returned: 1
SELECT *
FROM triholog_jshopping_categories
WHERE `category_id` = '1'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | triholog_jshopping_categories | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 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.00 ms |
| statistics | 0.03 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.02 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1445 |
| 12 | JDatabaseDriver->loadAssoc() | JROOT/libraries/joomla/table/table.php:729 |
| 11 | JTable->load() | JROOT/modules/mod_jshopping_filters/mod_jshopping_filters.php:50 |
| 10 | include JROOT/modules/mod_jshopping_filters/mod_jshopping_filters.php | JROOT/libraries/cms/module/helper.php:198 |
| 9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 8 | JDocumentRendererHtmlModule->render() | JROOT/libraries/joomla/document/renderer/html/modules.php:42 |
| 7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:486 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:777 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:552 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1128 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:278 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.79 ms After last query: 0.13 ms Query memory: 0.024 MB Memory before query: 5.701 MB Rows returned: 1
SELECT distinct man.manufacturer_id as id, man.`name_ru-RU` as name
FROM `triholog_jshopping_products` AS prod
LEFT JOIN `triholog_jshopping_products_to_categories` AS categ USING (product_id)
LEFT JOIN `triholog_jshopping_manufacturers` as man
on prod.product_manufacturer_id=man.manufacturer_id
WHERE
categ.category_id=1
AND
prod.product_publish=1
AND
prod.product_manufacturer_id!=0
AND prod.access IN (1,1)
AND
man.manufacturer_publish=1
ORDER BY man.ordering
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | prod | NULL | ref | PRIMARY,product_manufacturer_id,product_publish,access | product_publish | 1 | const | 13 | 100.00 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | man | NULL | eq_ref | PRIMARY,manufacturer_publish | PRIMARY | 4 | cy85373_triholog.prod.product_manufacturer_id | 1 | 50.00 | Using where |
| 1 | SIMPLE | categ | NULL | eq_ref | PRIMARY,category_id,product_id,product_id_2 | PRIMARY | 8 | cy85373_triholog.prod.product_id,const | 1 | 100.00 | Using index; Distinct |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| init | 0.05 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.11 ms |
| preparing | 0.01 ms |
| Creating tmp table | 0.02 ms |
| Sorting result | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.38 ms |
| Creating sort index | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| removing tmp table | 0.04 ms |
| query end | 0.00 ms |
| closing tables | 0.02 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/tables/category.php:233 |
| 11 | jshopCategory->getManufacturers() | JROOT/modules/mod_jshopping_filters/mod_jshopping_filters.php:55 |
| 10 | include JROOT/modules/mod_jshopping_filters/mod_jshopping_filters.php | JROOT/libraries/cms/module/helper.php:198 |
| 9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 8 | JDocumentRendererHtmlModule->render() | JROOT/libraries/joomla/document/renderer/html/modules.php:42 |
| 7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:486 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:777 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:552 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1128 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:278 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.27 ms After last query: 0.10 ms Query memory: 0.031 MB Memory before query: 5.710 MB Rows returned: 56
SELECT id, `name_ru-RU` as name, field_id, alias
FROM `triholog_jshopping_products_extra_field_values`
order by ordering
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | triholog_jshopping_products_extra_field_values | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 56 | 100.00 | Using filesort |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| Sorting result | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.13 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/tables/productfieldvalue.php:35 |
| 12 | jshopProductFieldValue->getAllList() | JROOT/components/com_jshopping/lib/factory.php:495 |
| 11 | JSFactory::getAllProductExtraFieldValueDetail() | JROOT/modules/mod_jshopping_filters/mod_jshopping_filters.php:77 |
| 10 | include JROOT/modules/mod_jshopping_filters/mod_jshopping_filters.php | JROOT/libraries/cms/module/helper.php:198 |
| 9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 8 | JDocumentRendererHtmlModule->render() | JROOT/libraries/joomla/document/renderer/html/modules.php:42 |
| 7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:486 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:777 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:552 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1128 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:278 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.66 ms After last query: 4.34 ms Query memory: 0.041 MB Memory before query: 5.874 MB Rows returned: 59
SHOW FULL COLUMNS
FROM `triholog_jshopping_products`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `triholog_jshopping_products`
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.14 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Opening tables | 0.01 ms |
| checking permissions | 0.04 ms |
| checking permissions | 0.00 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.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 |
| checking permissions | 0.00 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| Sending data | 0.09 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.03 ms |
| closing tables | 0.00 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:440 |
| 15 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/joomla/table/table.php:244 |
| 14 | JTable->getFields() | JROOT/libraries/joomla/table/table.php:163 |
| 13 | JTable->__construct() | JROOT/components/com_jshopping/tables/product.php:15 |
| 12 | jshopProduct->__construct() | JROOT/libraries/joomla/table/table.php:311 |
| 11 | JTable::getInstance() | JROOT/modules/mod_jshopping_cart_ajax_mini/mod_jshopping_cart_ajax_mini.php:28 |
| 10 | include JROOT/modules/mod_jshopping_cart_ajax_mini/mod_jshopping_cart_ajax_mini.php | JROOT/libraries/cms/module/helper.php:198 |
| 9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 8 | JDocumentRendererHtmlModule->render() | JROOT/libraries/joomla/document/renderer/html/modules.php:42 |
| 7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:486 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:777 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:552 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1128 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:278 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.64 ms After last query: 11.97 ms Query memory: 0.033 MB Memory before query: 6.228 MB Rows returned: 28
SHOW FULL COLUMNS
FROM `triholog_sh404sef_metas`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `triholog_sh404sef_metas`
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.12 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Opening tables | 0.02 ms |
| checking permissions | 0.03 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.09 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.03 ms |
| closing tables | 0.00 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:440 |
| 16 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/joomla/table/table.php:244 |
| 15 | JTable->getFields() | JROOT/libraries/joomla/table/table.php:163 |
| 14 | JTable->__construct() | JROOT/administrator/components/com_sh404sef/tables/metas.php:116 |
| 13 | Sh404sefTableMetas->__construct() | JROOT/libraries/joomla/table/table.php:311 |
| 12 | JTable::getInstance() | JROOT/components/com_sh404sef/shPageRewrite.full.php:252 |
| 11 | shGetCustomMetaData() | JROOT/components/com_sh404sef/shPageRewrite.full.php:329 |
| 10 | shDoTitleTags() | JROOT/components/com_sh404sef/shPageRewrite.full.php:917 |
| 9 | include_once JROOT/components/com_sh404sef/shPageRewrite.full.php | JROOT/components/com_sh404sef/shPageRewrite.php:15 |
| 8 | require_once JROOT/components/com_sh404sef/shPageRewrite.php | JROOT/plugins/system/sh404sef/sh404sef.php:292 |
| 7 | plgSystemSh404sef->onAfterRender() | JROOT/libraries/joomla/event/event.php:70 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 4 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:1134 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:278 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
Query Time: 0.22 ms After last query: 0.13 ms Query memory: 0.037 MB Memory before query: 6.284 MB Rows returned: 0
SELECT *
FROM triholog_sh404sef_metas
WHERE `newurl`='index.php&lang=ru';
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | triholog_sh404sef_metas | NULL | ref | newurl | newurl | 767 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.03 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 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.00 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1642 |
| 15 | JDatabaseDriver->loadObject() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:605 |
| 14 | ShlDbClass->loadObject() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:412 |
| 13 | ShlDbClass->shlLoadObject() | JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655 |
| 12 | ShlDbHelper::selectObject() | JROOT/components/com_sh404sef/shPageRewrite.full.php:256 |
| 11 | shGetCustomMetaData() | JROOT/components/com_sh404sef/shPageRewrite.full.php:329 |
| 10 | shDoTitleTags() | JROOT/components/com_sh404sef/shPageRewrite.full.php:917 |
| 9 | include_once JROOT/components/com_sh404sef/shPageRewrite.full.php | JROOT/components/com_sh404sef/shPageRewrite.php:15 |
| 8 | require_once JROOT/components/com_sh404sef/shPageRewrite.php | JROOT/plugins/system/sh404sef/sh404sef.php:292 |
| 7 | plgSystemSh404sef->onAfterRender() | JROOT/libraries/joomla/event/event.php:70 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 4 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:1134 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:278 |
| 1 | JApplicationCms->execute() | JROOT/index.php:51 |
4 × SELECT id, `name_ru-RU` as name, field_id, alias
FROM `triholog_jshopping_products_extra_field_values`
2 × SELECT `session_id`
FROM `triholog_session`
2 × select `alias`,`newurl`
from `triholog_sh404sef_aliases`
2 × SELECT `ip`,`reason`
FROM triholog_rsfirewall_lists
2 × SELECT *
FROM triholog_jshopping_categories
2 × SELECT `oldurl`, `newurl`, `dateadd`
FROM triholog_sh404sef_urls
1 × select manufacturer_id as id, `name_ru-RU` as name, manufacturer_logo, manufacturer_url
from triholog_jshopping_manufacturers
1 × SELECT prod.product_id, prod.product_primary_category, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.`extra_field_4` , prod.`extra_field_9` , prod.`extra_field_10` , prod.`extra_field_11`
FROM `triholog_jshopping_products` AS prod
LEFT JOIN `triholog_jshopping_products_to_categories` AS pr_cat USING (product_id)
1 × SELECT params
FROM triholog_extensions AS e
1 × SELECT `oldurl`, `dateadd`
FROM triholog_sh404sef_urls
1 × SELECT count(*)
FROM `triholog_jshopping_products_to_categories` AS pr_cat
INNER JOIN `triholog_jshopping_products` AS prod
ON pr_cat.product_id = prod.product_id
1 × SELECT tax_id, tax_name, tax_value
FROM `triholog_jshopping_taxes
1 × SELECT F.id, F.`name_ru-RU` as name, F.`description_ru-RU` as description, F.allcats, F.type, F.cats, F.ordering, F.`
group`, G.`name_ru-RU` as groupname, multilist
FROM `triholog_jshopping_products_extra_fields` as F
left join `triholog_jshopping_products_extra_field_groups` as G
on G.id=F.
group
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params as advancedparams, 0 as menuid, m.publish_up, m.publish_down
FROM triholog_modules AS m
LEFT JOIN triholog_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
LEFT JOIN triholog_advancedmodules as am
ON am.moduleid = m.id
1 × SELECT *
FROM triholog_jshopping_vendors
1 × SELECT id
FROM triholog_jshopping_vendors
1 × SELECT distinct man.manufacturer_id as id, man.`name_ru-RU` as name
FROM `triholog_jshopping_products` AS prod
LEFT JOIN `triholog_jshopping_products_to_categories` AS categ USING (product_id)
LEFT JOIN `triholog_jshopping_manufacturers` as man
on prod.product_manufacturer_id=man.manufacturer_id
1 × SELECT `name_ru-RU` as name,`description_ru-RU` as description,`short_description_ru-RU` as short_description, category_id, category_publish, ordering, category_image
FROM `triholog_jshopping_categories`
1 × select id,link
from triholog_menu
1 × SELECT *
FROM triholog_rsfirewall_exceptions
1 × select *
from triholog_jshopping_language
1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `triholog_assets`
1 × SELECT id, rules
FROM `triholog_viewlevels
1 × SELECT *
FROM triholog_rsfirewall_snapshots
1 × SELECT *
FROM triholog_rsfirewall_hashes
1 × select manufacturer_id as id, `alias_ru-RU` as alias
from triholog_jshopping_manufacturers
1 × SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value
FROM `triholog_jshopping_currencies`
1 × SELECT *
FROM triholog_jshopping_config
1 × SELECT `params`
FROM triholog_extensions
1 × SELECT COUNT(`extension_id`)
FROM `triholog_extensions`
1 × SELECT *
FROM triholog_rsfirewall_configuratio
1 × SELECT `file`
FROM triholog_rsfirewall_hashes
1 × SELECT `path`
FROM triholog_rsfirewall_ignored
1 × SELECT b.id
FROM triholog_usergroups AS a
LEFT JOIN triholog_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT *
FROM triholog_sh404sef_metas