Время запроса: 0.18 ms Память запроса: 0.025 MB Память до запроса: 1.142 MB Выбрано строк: 0
SELECT `data`
FROM `r5k2d_session`
WHERE `session_id` = '22f5e500ed00e8f4ebabbc26731b75a8'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | r5k2d_session | NULL | const | PRIMARY | PRIMARY | 575 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.02 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.04 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 |
# | Вызывающий объект | Файл и номер строки |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
15 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:45 |
14 | JSessionStorageDatabase->read() | Так же, как вызов в строке ниже. |
13 | session_start() | JROOT/libraries/joomla/session/handler/native.php:260 |
12 | JSessionHandlerNative->doSessionStart() | JROOT/libraries/joomla/session/handler/native.php:50 |
11 | JSessionHandlerNative->start() | JROOT/libraries/joomla/session/handler/joomla.php:88 |
10 | JSessionHandlerJoomla->start() | JROOT/libraries/src/Session/Session.php:660 |
9 | Joomla\CMS\Session\Session->_start() | JROOT/libraries/src/Session/Session.php:620 |
8 | Joomla\CMS\Session\Session->start() | JROOT/libraries/src/Session/Session.php:498 |
7 | Joomla\CMS\Session\Session->get() | JROOT/libraries/src/Session/Session.php:455 |
6 | Joomla\CMS\Session\Session->isNew() | JROOT/libraries/src/Application/CMSApplication.php:762 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:350 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Время запроса: 0.13 ms После последнего запроса: 0.43 ms Память запроса: 0.022 MB Память до запроса: 1.157 MB Выбрано строк: 0
SELECT `session_id`
FROM `r5k2d_session`
WHERE `session_id` = '22f5e500ed00e8f4ebabbc26731b75a8'
LIMIT 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | r5k2d_session | NULL | const | PRIMARY | PRIMARY | 575 | const | 1 | 100.00 | Using index |
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.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 |
# | Вызывающий объект | Файл и номер строки |
---|
9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:153 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:764 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:350 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Время запроса: 0.21 ms После последнего запроса: 0.08 ms Память запроса: 0.004 MB Память до запроса: 1.163 MB
INSERT INTO `r5k2d_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
('22f5e500ed00e8f4ebabbc26731b75a8', 1, '1728243409', 0, '', 0)
EXPLAIN не доступен для запроса: INSERT INTO `r5k2d_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
('22f5e500ed00e8f4ebabbc26731b75a8', 1, '1728243409', 0, '', 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.07 ms |
end | 0.00 ms |
query end | 0.05 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|
8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Session/MetadataManager.php:116 |
7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:153 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:764 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:350 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Время запроса: 0.19 ms После последнего запроса: 1.63 ms Память запроса: 0.023 MB Память до запроса: 1.311 MB Выбрано строк: 5
SELECT id, rules
FROM `r5k2d_viewlevels`
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | r5k2d_viewlevels | NULL | ALL | NULL | Индекс не используется | NULL | NULL | 5 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.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.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1496 |
9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Access/Access.php:1063 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:310 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:606 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.32 ms После последнего запроса: 0.08 ms Память запроса: 0.022 MB Память до запроса: 1.323 MB Выбрано строк: 2
SELECT b.id
FROM r5k2d_usergroups AS a
LEFT JOIN r5k2d_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | b | NULL | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 2 | 100.00 | Using where; Using index |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.06 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.03 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1540 |
10 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:980 |
9 | Joomla\CMS\Access\Access::getGroupsByUser() | JROOT/libraries/src/Access/Access.php:1095 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:310 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:606 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.44 ms После последнего запроса: 15.52 ms Память запроса: 0.005 MB Память до запроса: 2.822 MB
UPDATE `r5k2d_extensions`
SET `params` = '{\"mediaversion\":\"1b87b90ec1063d49efdfc3cd2843a07a\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | UPDATE | r5k2d_extensions | NULL | range | element_clientid,element_folder_clientid,extension | extension | 364 | const,const | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.03 ms |
System lock | 0.09 ms |
updating | 0.08 ms |
end | 0.01 ms |
query end | 0.06 ms |
closing tables | 0.02 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
9 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
8 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
7 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
6 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
5 | Joomla\CMS\Factory::getDocument() | JROOT/libraries/src/Application/WebApplication.php:1113 |
4 | Joomla\CMS\Application\WebApplication->loadDocument() | JROOT/libraries/src/Application/SiteApplication.php:133 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 1.76 ms После последнего запроса: 1.59 ms Память запроса: 0.052 MB Память до запроса: 2.896 MB Выбрано строк: 140
SHOW FULL COLUMNS
FROM `r5k2d_jshopping_config`
EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `r5k2d_jshopping_config`
Status | Duration |
---|
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.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.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.08 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.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.03 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
Sending data | 0.29 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.01 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:430 |
15 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
14 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
13 | Joomla\CMS\Table\Table->__construct() | JROOT/components/com_jshopping/tables/config.php:14 |
12 | jshopConfig->__construct() | JROOT/components/com_jshopping/lib/factory.php:24 |
11 | JSFactory::getConfig() | JROOT/components/com_jshopping/lib/factory.php:143 |
10 | JSFactory::reloadConfigFieldTLF() | JROOT/components/com_jshopping/lib/factory.php:166 |
9 | JSFactory::loadLanguageFile() | JROOT/components/com_jshopping/lib/functions.php:1571 |
8 | initLoadJoomshoppingLanguageFile() | JROOT/components/com_jshopping/loadparams.php:15 |
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/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.64 ms После последнего запроса: 1.04 ms Память запроса: 0.080 MB Память до запроса: 3.196 MB Выбрано строк: 1
SELECT *
FROM r5k2d_jshopping_config
WHERE `id` = '1'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | r5k2d_jshopping_config | 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.09 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.08 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.16 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 |
# | Вызывающий объект | Файл и номер строки |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1455 |
13 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:731 |
12 | Joomla\CMS\Table\Table->load() | JROOT/components/com_jshopping/lib/factory.php:30 |
11 | JSFactory::getConfig() | JROOT/components/com_jshopping/lib/factory.php:143 |
10 | JSFactory::reloadConfigFieldTLF() | JROOT/components/com_jshopping/lib/factory.php:166 |
9 | JSFactory::loadLanguageFile() | JROOT/components/com_jshopping/lib/functions.php:1571 |
8 | initLoadJoomshoppingLanguageFile() | JROOT/components/com_jshopping/loadparams.php:15 |
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/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.42 ms После последнего запроса: 0.42 ms Память запроса: 0.031 MB Память до запроса: 3.207 MB Выбрано строк: 8
SHOW FULL COLUMNS
FROM `r5k2d_jshopping_currencies`
EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `r5k2d_jshopping_currencies`
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.11 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.02 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.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 |
# | Вызывающий объект | Файл и номер строки |
---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:430 |
19 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
18 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
17 | Joomla\CMS\Table\Table->__construct() | JROOT/components/com_jshopping/tables/currency.php:14 |
16 | jshopCurrency->__construct() | JROOT/libraries/src/Table/Table.php:312 |
15 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_jshopping/lib/factory.php:621 |
14 | JSFactory::getTable() | JROOT/components/com_jshopping/lib/factory.php:569 |
13 | JSFactory::getAllCurrency() | JROOT/components/com_jshopping/tables/config.php:53 |
12 | jshopConfig->loadCurrencyValue() | JROOT/components/com_jshopping/lib/factory.php:32 |
11 | JSFactory::getConfig() | JROOT/components/com_jshopping/lib/factory.php:143 |
10 | JSFactory::reloadConfigFieldTLF() | JROOT/components/com_jshopping/lib/factory.php:166 |
9 | JSFactory::loadLanguageFile() | JROOT/components/com_jshopping/lib/functions.php:1571 |
8 | initLoadJoomshoppingLanguageFile() | JROOT/components/com_jshopping/loadparams.php:15 |
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/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.33 ms После последнего запроса: 0.08 ms Память запроса: 0.026 MB Память до запроса: 3.232 MB Выбрано строк: 1
SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value
FROM `r5k2d_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 | r5k2d_jshopping_currencies | NULL | ref | currency_publish | currency_publish | 1 | const | 1 | 100.00 | Using index condition; Используется filesort |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.01 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
Creating sort index | 0.06 ms |
end | 0.00 ms |
query end | 0.03 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
15 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/tables/currency.php:22 |
14 | jshopCurrency->getAllCurrencies() | JROOT/components/com_jshopping/lib/factory.php:570 |
13 | JSFactory::getAllCurrency() | JROOT/components/com_jshopping/tables/config.php:53 |
12 | jshopConfig->loadCurrencyValue() | JROOT/components/com_jshopping/lib/factory.php:32 |
11 | JSFactory::getConfig() | JROOT/components/com_jshopping/lib/factory.php:143 |
10 | JSFactory::reloadConfigFieldTLF() | JROOT/components/com_jshopping/lib/factory.php:166 |
9 | JSFactory::loadLanguageFile() | JROOT/components/com_jshopping/lib/functions.php:1571 |
8 | initLoadJoomshoppingLanguageFile() | JROOT/components/com_jshopping/loadparams.php:15 |
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/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.18 ms После последнего запроса: 2.37 ms Память запроса: 0.024 MB Память до запроса: 3.236 MB Выбрано строк: 2
select *
from r5k2d_jshopping_languages
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | r5k2d_jshopping_languages | NULL | ALL | NULL | Индекс не используется | NULL | NULL | 2 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.00 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.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 |
# | Вызывающий объект | Файл и номер строки |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
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/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.65 ms После последнего запроса: 2.56 ms Память запроса: 0.031 MB Память до запроса: 3.370 MB Выбрано строк: 24
SHOW FULL COLUMNS
FROM `r5k2d_jshopping_categories`
EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `r5k2d_jshopping_categories`
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.13 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 |
Sending data | 0.10 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 |
# | Вызывающий объект | Файл и номер строки |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:430 |
14 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
13 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
12 | Joomla\CMS\Table\Table->__construct() | JROOT/components/com_jshopping/tables/category.php:15 |
11 | jshopCategory->__construct() | JROOT/libraries/src/Table/Table.php:312 |
10 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_jshopping/lib/factory.php:621 |
9 | JSFactory::getTable() | JROOT/components/com_jshopping/controllers/category.php:56 |
8 | JshoppingControllerCategory->view() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.23 ms После последнего запроса: 0.20 ms Память запроса: 0.031 MB Память до запроса: 3.423 MB Выбрано строк: 1
SELECT *
FROM r5k2d_jshopping_categories
WHERE `category_id` = '26'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | r5k2d_jshopping_categories | NULL | const | PRIMARY | PRIMARY | 4 | 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.01 ms |
optimizing | 0.01 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.02 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1455 |
10 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:731 |
9 | Joomla\CMS\Table\Table->load() | JROOT/components/com_jshopping/controllers/category.php:57 |
8 | JshoppingControllerCategory->view() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.33 ms После последнего запроса: 0.16 ms Память запроса: 0.025 MB Память до запроса: 3.436 MB Выбрано строк: 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 `r5k2d_jshopping_categories`
WHERE category_parent_id = '26'
AND category_publish = '1'
AND access IN (1,1,5)
ORDER BY ordering asc
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | r5k2d_jshopping_categories | NULL | ref | category_parent_id,category_publish,access,category_publish_2 | category_parent_id | 4 | const | 1 | 100.00 | Using index condition; Using where; Используется filesort |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.07 ms |
preparing | 0.02 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.02 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.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
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/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 1.06 ms После последнего запроса: 0.16 ms Память запроса: 0.025 MB Память до запроса: 3.507 MB Выбрано строк: 8
select id,link
from r5k2d_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,5)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | r5k2d_menu | NULL | ref | idx_client_id_parent_id_alias_language,idx_language | idx_client_id_parent_id_alias_language | 1 | const | 111 | 0.66 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.08 ms |
preparing | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.75 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 |
# | Вызывающий объект | Файл и номер строки |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/lib/shop_item_menu.php:136 |
13 | shopItemMenu->getList() | JROOT/components/com_jshopping/lib/shop_item_menu.php:46 |
12 | shopItemMenu->init() | JROOT/components/com_jshopping/lib/shop_item_menu.php:39 |
11 | shopItemMenu::getInstance() | JROOT/components/com_jshopping/lib/functions.php:396 |
10 | getShopMainPageItemid() | JROOT/components/com_jshopping/helpers/metadata.php:52 |
9 | JshopHelpersMetadata::category() | JROOT/components/com_jshopping/controllers/category.php:69 |
8 | JshoppingControllerCategory->view() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.70 ms После последнего запроса: 0.60 ms Память запроса: 0.037 MB Память до запроса: 3.538 MB Выбрано строк: 31
SHOW FULL COLUMNS
FROM `r5k2d_jshopping_vendors`
EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `r5k2d_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.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 |
checking permissions | 0.02 ms |
Sending data | 0.12 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.03 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:430 |
18 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
17 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
16 | Joomla\CMS\Table\Table->__construct() | JROOT/components/com_jshopping/tables/vendor.php:15 |
15 | jshopVendor->__construct() | JROOT/libraries/src/Table/Table.php:312 |
14 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_jshopping/lib/factory.php:621 |
13 | JSFactory::getTable() | JROOT/components/com_jshopping/lib/factory.php:435 |
12 | JSFactory::getMainVendor() | JROOT/components/com_jshopping/lib/functions.php:1425 |
11 | getBuildFilterListProduct() | JROOT/components/com_jshopping/tables/category.php:304 |
10 | jshopCategory->getFilterListProduct() | JROOT/components/com_jshopping/models/productlist.php:168 |
9 | jshopProductList->load() | JROOT/components/com_jshopping/controllers/category.php:73 |
8 | JshoppingControllerCategory->view() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.19 ms После последнего запроса: 0.15 ms Память запроса: 0.025 MB Память до запроса: 3.602 MB Выбрано строк: 1
SELECT id
FROM r5k2d_jshopping_vendors
WHERE `main`=1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | r5k2d_jshopping_vendors | NULL | ref | main | main | 1 | const | 1 | 100.00 | Using index |
Status | Duration |
---|
starting | 0.03 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.03 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
14 | JDatabaseDriver->loadResult() | JROOT/components/com_jshopping/tables/vendor.php:23 |
13 | jshopVendor->loadMain() | JROOT/components/com_jshopping/lib/factory.php:436 |
12 | JSFactory::getMainVendor() | JROOT/components/com_jshopping/lib/functions.php:1425 |
11 | getBuildFilterListProduct() | JROOT/components/com_jshopping/tables/category.php:304 |
10 | jshopCategory->getFilterListProduct() | JROOT/components/com_jshopping/models/productlist.php:168 |
9 | jshopProductList->load() | JROOT/components/com_jshopping/controllers/category.php:73 |
8 | JshoppingControllerCategory->view() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.24 ms После последнего запроса: 0.09 ms Память запроса: 0.037 MB Память до запроса: 3.613 MB Выбрано строк: 1
SELECT *
FROM r5k2d_jshopping_vendors
WHERE `id` = '1'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | r5k2d_jshopping_vendors | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.03 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.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 |
# | Вызывающий объект | Файл и номер строки |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1455 |
15 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:731 |
14 | Joomla\CMS\Table\Table->load() | JROOT/components/com_jshopping/tables/vendor.php:24 |
13 | jshopVendor->loadMain() | JROOT/components/com_jshopping/lib/factory.php:436 |
12 | JSFactory::getMainVendor() | JROOT/components/com_jshopping/lib/functions.php:1425 |
11 | getBuildFilterListProduct() | JROOT/components/com_jshopping/tables/category.php:304 |
10 | jshopCategory->getFilterListProduct() | JROOT/components/com_jshopping/models/productlist.php:168 |
9 | jshopProductList->load() | JROOT/components/com_jshopping/controllers/category.php:73 |
8 | JshoppingControllerCategory->view() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.42 ms После последнего запроса: 0.19 ms Память запроса: 0.031 MB Память до запроса: 3.623 MB Выбрано строк: 11
SHOW FULL COLUMNS
FROM `r5k2d_jshopping_products_extra_fields`
EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `r5k2d_jshopping_products_extra_fields`
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
Opening tables | 0.08 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.01 ms |
checking permissions | 0.02 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 |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
Sending data | 0.06 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 |
# | Вызывающий объект | Файл и номер строки |
---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:430 |
19 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
18 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
17 | Joomla\CMS\Table\Table->__construct() | JROOT/components/com_jshopping/tables/productfield.php:14 |
16 | jshopProductField->__construct() | JROOT/libraries/src/Table/Table.php:312 |
15 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_jshopping/lib/factory.php:621 |
14 | JSFactory::getTable() | JROOT/components/com_jshopping/lib/factory.php:496 |
13 | JSFactory::getAllProductExtraField() | JROOT/components/com_jshopping/lib/functions.php:1113 |
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:73 |
8 | JshoppingControllerCategory->view() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.60 ms После последнего запроса: 0.10 ms Память запроса: 0.030 MB Память до запроса: 3.652 MB Выбрано строк: 15
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 `r5k2d_jshopping_products_extra_fields` as F
left join `r5k2d_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 | Индекс не используется | NULL | NULL | 15 | 100.00 | Using temporary; Используется filesort |
1 | SIMPLE | G | NULL | ALL | PRIMARY | Индекс не используется | 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.02 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 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.18 ms |
Creating sort index | 0.09 ms |
end | 0.00 ms |
query end | 0.03 ms |
removing tmp table | 0.02 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
15 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/tables/productfield.php:48 |
14 | jshopProductField->getList() | JROOT/components/com_jshopping/lib/factory.php:497 |
13 | JSFactory::getAllProductExtraField() | JROOT/components/com_jshopping/lib/functions.php:1113 |
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:73 |
8 | JshoppingControllerCategory->view() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.38 ms После последнего запроса: 0.25 ms Память запроса: 0.030 MB Память до запроса: 3.687 MB Выбрано строк: 3
SHOW FULL COLUMNS
FROM `r5k2d_jshopping_taxes`
EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `r5k2d_jshopping_taxes`
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
Opening tables | 0.11 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.02 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.03 ms |
closing tables | 0.00 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Вызывающий объект | Файл и номер строки |
---|
22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:430 |
20 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
19 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
18 | Joomla\CMS\Table\Table->__construct() | JROOT/components/com_jshopping/tables/tax.php:14 |
17 | jshopTax->__construct() | JROOT/libraries/src/Table/Table.php:312 |
16 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_jshopping/lib/factory.php:621 |
15 | JSFactory::getTable() | JROOT/components/com_jshopping/lib/factory.php:369 |
14 | JSFactory::getAllTaxes() | JROOT/components/com_jshopping/lib/functions.php:969 |
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:73 |
8 | JshoppingControllerCategory->view() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.14 ms После последнего запроса: 0.06 ms Память запроса: 0.027 MB Память до запроса: 3.705 MB Выбрано строк: 1
SELECT tax_id, tax_name, tax_value
FROM `r5k2d_jshopping_taxes`
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | r5k2d_jshopping_taxes | NULL | ALL | NULL | Индекс не используется | 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.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.01 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
17 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/tables/tax.php:21 |
16 | jshopTax->getAllTaxes() | JROOT/components/com_jshopping/lib/factory.php:355 |
15 | JSFactory::getAllTaxesOriginal() | JROOT/components/com_jshopping/lib/factory.php:370 |
14 | JSFactory::getAllTaxes() | JROOT/components/com_jshopping/lib/functions.php:969 |
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:73 |
8 | JshoppingControllerCategory->view() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.41 ms После последнего запроса: 0.07 ms Память запроса: 0.023 MB Память до запроса: 3.711 MB Выбрано строк: 1
SELECT count(*)
FROM `r5k2d_jshopping_products_to_categories` AS pr_cat
INNER JOIN `r5k2d_jshopping_products` AS prod
ON pr_cat.product_id = prod.product_id
WHERE pr_cat.category_id=26
AND prod.product_publish=1
AND prod.access IN (1,1,5)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | pr_cat | NULL | ref | PRIMARY,category_id,product_id,product_id_2 | category_id | 4 | const | 5 | 100.00 | Using index |
1 | SIMPLE | prod | NULL | eq_ref | PRIMARY,product_publish,access | PRIMARY | 4 | cc05556_fuelman.pr_cat.product_id | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.03 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.10 ms |
preparing | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.05 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.03 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
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:73 |
8 | JshoppingControllerCategory->view() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.94 ms После последнего запроса: 0.95 ms Память запроса: 0.039 MB Память до запроса: 3.726 MB Выбрано строк: 5
SELECT prod.product_id, 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_1` , prod.`extra_field_2` , prod.`extra_field_6` , prod.`extra_field_3` , prod.`extra_field_4` , prod.`extra_field_7` , prod.`extra_field_8` , prod.`extra_field_9` , prod.`extra_field_11` , prod.`extra_field_12` , prod.`extra_field_13` , prod.`extra_field_14`
FROM `r5k2d_jshopping_products` AS prod
LEFT JOIN `r5k2d_jshopping_products_to_categories` AS pr_cat USING (product_id)
WHERE pr_cat.category_id=26
AND prod.product_publish=1
AND prod.access IN (1,1,5)
ORDER BY name ASC
LIMIT 0, 12
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | pr_cat | NULL | ref | PRIMARY,category_id,product_id,product_id_2 | category_id | 4 | const | 5 | 100.00 | Using where; Using index; Using temporary; Используется filesort |
1 | SIMPLE | prod | NULL | eq_ref | PRIMARY,product_publish,access | PRIMARY | 4 | cc05556_fuelman.pr_cat.product_id | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.11 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.11 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.09 ms |
preparing | 0.02 ms |
Creating tmp table | 0.04 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.24 ms |
Creating sort index | 0.12 ms |
end | 0.00 ms |
query end | 0.01 ms |
removing tmp table | 0.03 ms |
query end | 0.00 ms |
closing tables | 0.02 ms |
freeing items | 0.03 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
11 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/tables/category.php:169 |
10 | jshopCategory->getProducts() | JROOT/components/com_jshopping/models/productlist.php:185 |
9 | jshopProductList->load() | JROOT/components/com_jshopping/controllers/category.php:73 |
8 | JshoppingControllerCategory->view() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.80 ms После последнего запроса: 0.23 ms Память запроса: 0.038 MB Память до запроса: 3.786 MB Выбрано строк: 53
SHOW FULL COLUMNS
FROM `r5k2d_jshopping_users`
EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `r5k2d_jshopping_users`
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.11 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.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.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.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.08 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
removing tmp table | 0.03 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:430 |
17 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
16 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
15 | Joomla\CMS\Table\Table->__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:655 |
11 | listProductUpdateData() | JROOT/components/com_jshopping/tables/category.php:170 |
10 | jshopCategory->getProducts() | JROOT/components/com_jshopping/models/productlist.php:185 |
9 | jshopProductList->load() | JROOT/components/com_jshopping/controllers/category.php:73 |
8 | JshoppingControllerCategory->view() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.39 ms После последнего запроса: 0.22 ms Память запроса: 0.035 MB Память до запроса: 3.890 MB Выбрано строк: 91
select manufacturer_id as id, `name_ru-RU` as name, manufacturer_logo, manufacturer_url
from r5k2d_jshopping_manufacturers
where manufacturer_publish='1'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | r5k2d_jshopping_manufacturers | NULL | ALL | manufacturer_publish | Индекс не используется | NULL | NULL | 91 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 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.16 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Вызывающий объект | Файл и номер строки |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/lib/factory.php:422 |
12 | JSFactory::getAllManufacturer() | JROOT/components/com_jshopping/lib/functions.php:658 |
11 | listProductUpdateData() | JROOT/components/com_jshopping/tables/category.php:170 |
10 | jshopCategory->getProducts() | JROOT/components/com_jshopping/models/productlist.php:185 |
9 | jshopProductList->load() | JROOT/components/com_jshopping/controllers/category.php:73 |
8 | JshoppingControllerCategory->view() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.41 ms После последнего запроса: 0.48 ms Память запроса: 0.030 MB Память до запроса: 3.958 MB Выбрано строк: 5
SHOW FULL COLUMNS
FROM `r5k2d_jshopping_products_extra_field_values`
EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `r5k2d_jshopping_products_extra_field_values`
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.11 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.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 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 |
# | Вызывающий объект | Файл и номер строки |
---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:430 |
19 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
18 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
17 | Joomla\CMS\Table\Table->__construct() | JROOT/components/com_jshopping/tables/productfieldvalue.php:15 |
16 | jshopProductFieldValue->__construct() | JROOT/libraries/src/Table/Table.php:312 |
15 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_jshopping/lib/factory.php:621 |
14 | JSFactory::getTable() | JROOT/components/com_jshopping/lib/factory.php:505 |
13 | JSFactory::getAllProductExtraFieldValue() | JROOT/components/com_jshopping/lib/functions.php:801 |
12 | getProductExtraFieldForProduct() | JROOT/components/com_jshopping/lib/functions.php:726 |
11 | listProductUpdateData() | JROOT/components/com_jshopping/tables/category.php:170 |
10 | jshopCategory->getProducts() | JROOT/components/com_jshopping/models/productlist.php:185 |
9 | jshopProductList->load() | JROOT/components/com_jshopping/controllers/category.php:73 |
8 | JshoppingControllerCategory->view() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.56 ms После последнего запроса: 0.06 ms Память запроса: 0.025 MB Память до запроса: 3.977 MB Выбрано строк: 0
SELECT id, `name_ru-RU` as name, field_id
FROM `r5k2d_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 | r5k2d_jshopping_products_extra_field_values | NULL | ALL | NULL | Индекс не используется | NULL | NULL | 1 | 100.00 | Используется filesort |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 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.03 ms |
end | 0.00 ms |
query end | 0.34 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
15 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/tables/productfieldvalue.php:26 |
14 | jshopProductFieldValue->getAllList() | JROOT/components/com_jshopping/lib/factory.php:506 |
13 | JSFactory::getAllProductExtraFieldValue() | JROOT/components/com_jshopping/lib/functions.php:801 |
12 | getProductExtraFieldForProduct() | JROOT/components/com_jshopping/lib/functions.php:726 |
11 | listProductUpdateData() | JROOT/components/com_jshopping/tables/category.php:170 |
10 | jshopCategory->getProducts() | JROOT/components/com_jshopping/models/productlist.php:185 |
9 | jshopProductList->load() | JROOT/components/com_jshopping/controllers/category.php:73 |
8 | JshoppingControllerCategory->view() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 1.73 ms После последнего запроса: 0.39 ms Память запроса: 0.126 MB Память до запроса: 3.998 MB Выбрано строк: 1111
select product_id as id, `alias_ru-RU` as alias
from r5k2d_jshopping_products
where `alias_ru-RU`!=''
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | r5k2d_jshopping_products | NULL | ALL | NULL | Индекс не используется | NULL | NULL | 1072 | 90.00 | 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.01 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 1.55 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 |
# | Вызывающий объект | Файл и номер строки |
---|
22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
21 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/lib/factory.php:303 |
20 | JSFactory::getAliasProduct() | JROOT/components/com_jshopping/router.php:72 |
19 | jshoppingBuildRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:69 |
18 | Joomla\CMS\Component\Router\RouterLegacy->build() | JROOT/libraries/src/Router/SiteRouter.php:528 |
17 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:498 |
16 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
15 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
14 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:66 |
13 | Joomla\CMS\Router\Route::_() | JROOT/components/com_jshopping/lib/functions.php:488 |
12 | SEFLink() | JROOT/components/com_jshopping/lib/functions.php:438 |
11 | addLinkToProducts() | JROOT/components/com_jshopping/tables/category.php:171 |
10 | jshopCategory->getProducts() | JROOT/components/com_jshopping/models/productlist.php:185 |
9 | jshopProductList->load() | JROOT/components/com_jshopping/controllers/category.php:73 |
8 | JshoppingControllerCategory->view() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.25 ms После последнего запроса: 1.70 ms Память запроса: 0.029 MB Память до запроса: 4.147 MB Выбрано строк: 26
select category_id as id, `alias_ru-RU` as alias
from r5k2d_jshopping_categories
where `alias_ru-RU`!=''
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | r5k2d_jshopping_categories | NULL | ALL | NULL | Индекс не используется | NULL | NULL | 26 | 90.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.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.08 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|
22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
21 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/lib/factory.php:255 |
20 | JSFactory::getAliasCategory() | JROOT/components/com_jshopping/router.php:73 |
19 | jshoppingBuildRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:69 |
18 | Joomla\CMS\Component\Router\RouterLegacy->build() | JROOT/libraries/src/Router/SiteRouter.php:528 |
17 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:498 |
16 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
15 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
14 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:66 |
13 | Joomla\CMS\Router\Route::_() | JROOT/components/com_jshopping/lib/functions.php:488 |
12 | SEFLink() | JROOT/components/com_jshopping/lib/functions.php:438 |
11 | addLinkToProducts() | JROOT/components/com_jshopping/tables/category.php:171 |
10 | jshopCategory->getProducts() | JROOT/components/com_jshopping/models/productlist.php:185 |
9 | jshopProductList->load() | JROOT/components/com_jshopping/controllers/category.php:73 |
8 | JshoppingControllerCategory->view() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.59 ms После последнего запроса: 1.32 ms Память запроса: 0.023 MB Память до запроса: 4.227 MB Выбрано строк: 1
SELECT distinct man.manufacturer_id as id, man.`name_ru-RU` as name
FROM `r5k2d_jshopping_products` AS prod
LEFT JOIN `r5k2d_jshopping_products_to_categories` AS categ USING (product_id)
LEFT JOIN `r5k2d_jshopping_manufacturers` as man
on prod.product_manufacturer_id=man.manufacturer_id
WHERE categ.category_id=26
AND prod.product_publish=1
AND prod.product_manufacturer_id!=0
AND prod.access IN (1,1,5)
order by man.ordering
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | categ | NULL | ref | PRIMARY,category_id,product_id,product_id_2 | category_id | 4 | const | 5 | 100.00 | Using where; Using index; Using temporary; Используется filesort |
1 | SIMPLE | prod | NULL | eq_ref | PRIMARY,product_manufacturer_id,product_publish,access | PRIMARY | 4 | cc05556_fuelman.categ.product_id | 1 | 72.85 | Using where |
1 | SIMPLE | man | NULL | eq_ref | PRIMARY | PRIMARY | 4 | cc05556_fuelman.prod.product_manufacturer_id | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 ms |
init | 0.09 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.13 ms |
preparing | 0.02 ms |
Creating tmp table | 0.02 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.10 ms |
Creating sort index | 0.02 ms |
end | 0.00 ms |
query end | 0.01 ms |
removing tmp table | 0.01 ms |
query end | 0.00 ms |
closing tables | 0.02 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
11 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/tables/category.php:227 |
10 | jshopCategory->getManufacturers() | JROOT/components/com_jshopping/models/productlist.php:205 |
9 | jshopProductList->getHtmlSelectFilterManufacturer() | JROOT/components/com_jshopping/controllers/category.php:86 |
8 | JshoppingControllerCategory->view() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.49 ms После последнего запроса: 0.18 ms Память запроса: 0.029 MB Память до запроса: 4.237 MB Выбрано строк: 10
SHOW FULL COLUMNS
FROM `r5k2d_jshopping_products_reviews`
EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `r5k2d_jshopping_products_reviews`
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.14 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 |
Sending data | 0.06 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
removing tmp table | 0.03 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:430 |
15 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
14 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
13 | Joomla\CMS\Table\Table->__construct() | JROOT/components/com_jshopping/tables/review.php:14 |
12 | jshopReview->__construct() | JROOT/libraries/src/Table/Table.php:312 |
11 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_jshopping/lib/factory.php:621 |
10 | JSFactory::getTable() | JROOT/components/com_jshopping/models/productlist.php:252 |
9 | jshopProductList->getAllowReview() | JROOT/components/com_jshopping/controllers/category.php:87 |
8 | JshoppingControllerCategory->view() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.40 ms После последнего запроса: 1.17 ms Память запроса: 0.028 MB Память до запроса: 4.299 MB Выбрано строк: 5
SELECT DISTINCT extra_field_7
FROM r5k2d_jshopping_products AS prod
INNER JOIN `r5k2d_jshopping_products_to_categories` AS cat
ON cat.product_id = prod.product_id
LEFT JOIN `r5k2d_jshopping_categories` AS ct
ON cat.category_id = ct.category_id
WHERE ct.category_id=26
AND prod.extra_field_7 !=''
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | ct | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using index; Using temporary |
1 | SIMPLE | cat | NULL | ref | PRIMARY,category_id,product_id,product_id_2 | category_id | 4 | const | 5 | 100.00 | Using index |
1 | SIMPLE | prod | NULL | eq_ref | PRIMARY | PRIMARY | 4 | cc05556_fuelman.cat.product_id | 1 | 90.00 | 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.01 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.07 ms |
preparing | 0.01 ms |
Creating tmp table | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.07 ms |
end | 0.00 ms |
query end | 0.01 ms |
removing tmp table | 0.03 ms |
query end | 0.00 ms |
closing tables | 0.02 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
16 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/tables/productfieldvalue.php:62 |
15 | jshopProductFieldValue::getAllValue() | JROOT/components/com_jshopping/templates/claire/list_products/form_filters.php:33 |
14 | include JROOT/components/com_jshopping/templates/claire/list_products/form_filters.php | JROOT/components/com_jshopping/templates/claire/category/products.php:15 |
13 | include JROOT/components/com_jshopping/templates/claire/category/products.php | JROOT/components/com_jshopping/templates/default/category/category_claire.php:77 |
12 | include JROOT/components/com_jshopping/templates/default/category/category_claire.php | JROOT/libraries/src/MVC/View/HtmlView.php:695 |
11 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
10 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/components/com_jshopping/views/category/view.html.php:13 |
9 | JshoppingViewCategory->display() | JROOT/components/com_jshopping/controllers/category.php:122 |
8 | JshoppingControllerCategory->view() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 2.04 ms После последнего запроса: 2.01 ms Память запроса: 0.040 MB Память до запроса: 4.344 MB Выбрано строк: 14
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM r5k2d_modules AS m
LEFT JOIN r5k2d_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN r5k2d_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-10-06 19:36:49')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-10-06 19:36:49')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 139 OR mm.menuid <= 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 | PRIMARY,published,newsfeeds | Индекс не используется | NULL | NULL | 67 | 1.49 | Using where; Используется filesort |
1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid | element_clientid | 303 | cc05556_fuelman.m.module,const | 1 | 10.00 | Using index condition; Using where |
1 | SIMPLE | mm | NULL | ref | PRIMARY | PRIMARY | 4 | cc05556_fuelman.m.id | 1 | 40.00 | Using where; Using index |
Status | Duration |
---|
starting | 0.09 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.05 ms |
init | 0.06 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.10 ms |
preparing | 0.03 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.01 ms |
Creating sort index | 1.56 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.04 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
14 | JDatabaseDriver->loadObjectList() | Так же, как вызов в строке ниже. |
13 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
12 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:442 |
11 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:372 |
10 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 |
9 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:581 |
8 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/templates/claire/index.php:95 |
7 | require JROOT/templates/claire/index.php | JROOT/libraries/src/Document/HtmlDocument.php:658 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:720 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:535 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1034 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:208 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.87 ms После последнего запроса: 9.40 ms Память запроса: 0.042 MB Память до запроса: 4.622 MB Выбрано строк: 62
SHOW FULL COLUMNS
FROM `r5k2d_jshopping_products`
EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `r5k2d_jshopping_products`
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.13 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.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 |
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 |
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.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.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.01 ms |
# | Вызывающий объект | Файл и номер строки |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:430 |
18 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
17 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
16 | Joomla\CMS\Table\Table->__construct() | JROOT/components/com_jshopping/tables/product.php:15 |
15 | jshopProduct->__construct() | JROOT/libraries/src/Table/Table.php:312 |
14 | Joomla\CMS\Table\Table::getInstance() | JROOT/modules/mod_jshopping_cart_ajax_mini/mod_jshopping_cart_ajax_mini.php:28 |
13 | include JROOT/modules/mod_jshopping_cart_ajax_mini/mod_jshopping_cart_ajax_mini.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
12 | Joomla\CMS\Helper\ModuleHelper::renderModule() | Так же, как вызов в строке ниже. |
11 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
10 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:630 |
9 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1048 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:208 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.40 ms После последнего запроса: 1.36 ms Память запроса: 0.029 MB Память до запроса: 4.756 MB Выбрано строк: 26
SELECT `name_ru-RU` as name, category_id, category_parent_id, category_publish
FROM `r5k2d_jshopping_categories`
where category_publish = '1'
and access IN (1,1,5)
ORDER BY category_parent_id, ordering
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | r5k2d_jshopping_categories | NULL | ALL | category_publish,access,category_publish_2 | Индекс не используется | NULL | NULL | 26 | 100.00 | Using where; Используется filesort |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.06 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.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
16 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/tables/category.php:115 |
15 | jshopCategory->getAllCategories() | JROOT/components/com_jshopping/lib/functions.php:342 |
14 | buildTreeCategory() | JROOT/modules/mod_jshopping_ajaxsearch/mod_jshopping_ajaxsearch.php:25 |
13 | include JROOT/modules/mod_jshopping_ajaxsearch/mod_jshopping_ajaxsearch.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
12 | Joomla\CMS\Helper\ModuleHelper::renderModule() | Так же, как вызов в строке ниже. |
11 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
10 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:630 |
9 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1048 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:208 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.22 ms После последнего запроса: 2.29 ms Память запроса: 0.025 MB Память до запроса: 4.795 MB Выбрано строк: 0
SELECT name, alias, app_id, app_secret, auth, token, userinfo
FROM r5k2d_offlajn_oauths
WHERE published = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | r5k2d_offlajn_oauths | NULL | ALL | NULL | Индекс не используется | NULL | NULL | 6 | 16.67 | Using where |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.04 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
11 | JDatabaseDriver->loadObjectList() | JROOT/modules/mod_improved_ajax_login/mod_improved_ajax_login.php:100 |
10 | include JROOT/modules/mod_improved_ajax_login/mod_improved_ajax_login.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1048 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:208 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.59 ms После последнего запроса: 0.47 ms Память запроса: 0.024 MB Память до запроса: 4.873 MB Выбрано строк: 1
SELECT enabled, params, custom_data
FROM r5k2d_extensions
WHERE name = 'plg_captcha_recaptcha'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | r5k2d_extensions | NULL | ALL | NULL | Индекс не используется | NULL | NULL | 191 | 10.00 | Using where |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.39 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 |
# | Вызывающий объект | Файл и номер строки |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
11 | JDatabaseDriver->loadObject() | JROOT/modules/mod_improved_ajax_login/mod_improved_ajax_login.php:175 |
10 | include JROOT/modules/mod_improved_ajax_login/mod_improved_ajax_login.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1048 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:208 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.24 ms После последнего запроса: 2.54 ms Память запроса: 0.025 MB Память до запроса: 4.930 MB Выбрано строк: 1
SELECT fields, props
FROM r5k2d_offlajn_forms
WHERE state=1
AND type='registration'
AND (id < 99 OR language = 'ru-RU')
ORDER BY id
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | r5k2d_offlajn_forms | NULL | index | PRIMARY | PRIMARY | 4 | NULL | 6 | 16.67 | 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.01 ms |
preparing | 0.01 ms |
Sorting result | 0.00 ms |
executing | 0.00 ms |
Sending data | 0.07 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 |
# | Вызывающий объект | Файл и номер строки |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
13 | JDatabaseDriver->loadObjectList() | JROOT/modules/mod_improved_ajax_login/themes/elegant/tmpls/reg25.php:38 |
12 | require JROOT/modules/mod_improved_ajax_login/themes/elegant/tmpls/reg25.php | JROOT/modules/mod_improved_ajax_login/themes/elegant/tmpls/tmpl25.php:69 |
11 | include JROOT/modules/mod_improved_ajax_login/themes/elegant/tmpls/tmpl25.php | JROOT/modules/mod_improved_ajax_login/mod_improved_ajax_login.php:378 |
10 | include JROOT/modules/mod_improved_ajax_login/mod_improved_ajax_login.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1048 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:208 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.21 ms После последнего запроса: 8.38 ms Память запроса: 0.026 MB Память до запроса: 5.182 MB Выбрано строк: 1
SELECT folder AS type, element AS name, params, extension_id
FROM r5k2d_extensions
WHERE element = 'jch_optimize'
AND type = 'plugin'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | r5k2d_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.02 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.05 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 |
# | Вызывающий объект | Файл и номер строки |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
17 | JDatabaseDriver->loadObject() | JROOT/plugins/system/jch_optimize/platform/plugin.php:73 |
16 | JchPlatformPlugin::loadjch() | JROOT/plugins/system/jch_optimize/platform/plugin.php:45 |
15 | JchPlatformPlugin::getPlugin() | JROOT/plugins/system/jch_optimize/platform/plugin.php:90 |
14 | JchPlatformPlugin::getPluginParams() | JROOT/plugins/system/jch_optimize/platform/cache.php:131 |
13 | JchPlatformCache::getLifetime() | JROOT/plugins/system/jch_optimize/platform/cache.php:117 |
12 | JchPlatformCache::getCacheObject() | JROOT/plugins/system/jch_optimize/platform/cache.php:37 |
11 | JchPlatformCache::getCache() | JROOT/plugins/system/jch_optimize/jchoptimize/parser.php:79 |
10 | JchOptimizeParser->__construct() | JROOT/plugins/system/jch_optimize/jchoptimize/jchoptimize.php:53 |
9 | JchOptimize->process() | JROOT/plugins/system/jch_optimize/jchoptimize/jchoptimize.php:107 |
8 | JchOptimize::optimize() | JROOT/plugins/system/jch_optimize/jch_optimize.php:102 |
7 | plgSystemJCH_Optimize->onAfterRender() | JROOT/libraries/joomla/event/event.php:70 |
6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1054 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:208 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
1 × SELECT `data`
FROM `r5k2d_session`
1 × SELECT prod.product_id, 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_1` , prod.`extra_field_2` , prod.`extra_field_6` , prod.`extra_field_3` , prod.`extra_field_4` , prod.`extra_field_7` , prod.`extra_field_8` , prod.`extra_field_9` , prod.`extra_field_11` , prod.`extra_field_12` , prod.`extra_field_13` , prod.`extra_field_14`
FROM `r5k2d_jshopping_products` AS prod
LEFT JOIN `r5k2d_jshopping_products_to_categories` AS pr_cat USING (product_id)
1 × SELECT fields, props
FROM r5k2d_offlajn_forms
1 × SELECT enabled, params, custom_data
FROM r5k2d_extensions
1 × SELECT name, alias, app_id, app_secret, auth, token, userinfo
FROM r5k2d_offlajn_oauths
1 × SELECT `name_ru-RU` as name, category_id, category_parent_id, category_publish
FROM `r5k2d_jshopping_categories`
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM r5k2d_modules AS m
LEFT JOIN r5k2d_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN r5k2d_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT DISTINCT extra_field_7
FROM r5k2d_jshopping_products AS prod
INNER JOIN `r5k2d_jshopping_products_to_categories` AS cat
ON cat.product_id = prod.product_id
LEFT JOIN `r5k2d_jshopping_categories` AS ct
ON cat.category_id = ct.category_id
1 × SELECT distinct man.manufacturer_id as id, man.`name_ru-RU` as name
FROM `r5k2d_jshopping_products` AS prod
LEFT JOIN `r5k2d_jshopping_products_to_categories` AS categ USING (product_id)
LEFT JOIN `r5k2d_jshopping_manufacturers` as man
on prod.product_manufacturer_id=man.manufacturer_id
1 × select category_id as id, `alias_ru-RU` as alias
from r5k2d_jshopping_categories
1 × select product_id as id, `alias_ru-RU` as alias
from r5k2d_jshopping_products
1 × SELECT id, `name_ru-RU` as name, field_id
FROM `r5k2d_jshopping_products_extra_field_values`
1 × select manufacturer_id as id, `name_ru-RU` as name, manufacturer_logo, manufacturer_url
from r5k2d_jshopping_manufacturers
1 × SELECT count(*)
FROM `r5k2d_jshopping_products_to_categories` AS pr_cat
INNER JOIN `r5k2d_jshopping_products` AS prod
ON pr_cat.product_id = prod.product_id
1 × SELECT `session_id`
FROM `r5k2d_session`
1 × SELECT tax_id, tax_name, tax_value
FROM `r5k2d_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 `r5k2d_jshopping_products_extra_fields` as F
left join `r5k2d_jshopping_products_extra_field_groups` as G
on G.id=F.
group
1 × SELECT *
FROM r5k2d_jshopping_vendors
1 × SELECT id
FROM r5k2d_jshopping_vendors
1 × select id,link
from r5k2d_menu
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 `r5k2d_jshopping_categories`
1 × SELECT *
FROM r5k2d_jshopping_categories
1 × select *
from r5k2d_jshopping_language
1 × SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value
FROM `r5k2d_jshopping_currencies`
1 × SELECT *
FROM r5k2d_jshopping_config
1 × SELECT b.id
FROM r5k2d_usergroups AS a
LEFT JOIN r5k2d_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, rules
FROM `r5k2d_viewlevels
1 × SELECT folder AS type, element AS name, params, extension_id
FROM r5k2d_extensions