Czas zapytania: 0.63 ms Pamięć zapytania: 0.020 MB Pamięć przed zapytaniem: 4.213 MB Zwróconych wierszy: 0
SELECT `session_id`
FROM `j25_session`
WHERE `session_id` = X'3738306366303535613834353835343662333963626335356235613731616134'
LIMIT 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | j25_session | NULL | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | Using index |
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.01 ms |
Opening tables | 0.17 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.06 ms |
executing | 0.02 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Wywołujący | Plik i numer linii |
---|
9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:154 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:828 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Czas zapytania: 0.41 ms Po ostatnim zapytaniu: 0.06 ms Pamięć zapytania: 0.004 MB Pamięć przed zapytaniem: 4.218 MB
INSERT INTO `j25_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
(X'3738306366303535613834353835343662333963626335356235613731616134', 1, 1656680696, 0, '', 0)
Polecenie EXPLAIN niemożliwe w zapytaniu: INSERT INTO `j25_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'3738306366303535613834353835343662333963626335356235613731616134', 1, 1656680696, 0, '', 0)
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.01 ms |
update | 0.12 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Wywołujący | Plik i numer linii |
---|
8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Session/MetadataManager.php:116 |
7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:154 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:828 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Czas zapytania: 0.51 ms Po ostatnim zapytaniu: 3.39 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 4.841 MB Zwróconych wierszy: 5
SELECT id, rules
FROM `j25_viewlevels`
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | j25_viewlevels | NULL | ALL | NULL | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 5 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 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.06 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
logging slow query | 0.10 ms |
cleaning up | 0.01 ms |
# | Wywołujący | Plik i numer linii |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Access/Access.php:1063 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.50 ms Po ostatnim zapytaniu: 0.05 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 4.853 MB Zwróconych wierszy: 2
SELECT b.id
FROM j25_usergroups AS a
LEFT JOIN j25_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.06 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 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.03 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Wywołujący | Plik i numer linii |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
10 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:980 |
9 | Joomla\CMS\Access\Access::getGroupsByUser() | JROOT/libraries/src/Access/Access.php:1095 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.54 ms Po ostatnim zapytaniu: 4.50 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 5.669 MB Zwróconych wierszy: 0
SELECT `path`
FROM j25_rsfirewall_ignored
WHERE `type`='ignore_folder' OR `type`='ignore_file'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | j25_rsfirewall_ignored | NULL | ALL | NULL | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.03 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
logging slow query | 0.09 ms |
cleaning up | 0.01 ms |
# | Wywołujący | Plik i numer linii |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
11 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:53 |
10 | RSFirewallConfig->load() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:19 |
9 | RSFirewallConfig->__construct() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:161 |
8 | RSFirewallConfig::getInstance() | JROOT/plugins/system/rsfirewall/rsfirewall.php:27 |
7 | plgSystemRsfirewall->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.44 ms Po ostatnim zapytaniu: 0.03 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 5.675 MB Zwróconych wierszy: 0
SELECT `file`
FROM j25_rsfirewall_hashes
WHERE `type`='protect'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | j25_rsfirewall_hashes | NULL | ALL | NULL | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 52 | 10.00 | Using where |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.13 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.02 ms |
logging slow query | 0.00 ms |
logging slow query | 0.12 ms |
cleaning up | 0.01 ms |
# | Wywołujący | Plik i numer linii |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
11 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:60 |
10 | RSFirewallConfig->load() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:19 |
9 | RSFirewallConfig->__construct() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:161 |
8 | RSFirewallConfig::getInstance() | JROOT/plugins/system/rsfirewall/rsfirewall.php:27 |
7 | plgSystemRsfirewall->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.54 ms Po ostatnim zapytaniu: 0.02 ms Pamięć zapytania: 0.026 MB Pamięć przed zapytaniem: 5.680 MB Zwróconych wierszy: 65
SELECT *
FROM j25_rsfirewall_configuration
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | j25_rsfirewall_configuration | NULL | ALL | NULL | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 65 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.01 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.23 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.02 ms |
logging slow query | 0.00 ms |
logging slow query | 0.07 ms |
cleaning up | 0.01 ms |
# | Wywołujący | Plik i numer linii |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:68 |
10 | RSFirewallConfig->load() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:19 |
9 | RSFirewallConfig->__construct() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:161 |
8 | RSFirewallConfig::getInstance() | JROOT/plugins/system/rsfirewall/rsfirewall.php:27 |
7 | plgSystemRsfirewall->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 1.14 ms Po ostatnim zapytaniu: 2.95 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 6.243 MB Zwróconych wierszy: 10
SHOW FULL COLUMNS
FROM `j25_rsfirewall_logs`
Polecenie EXPLAIN niemożliwe w zapytaniu: SHOW FULL COLUMNS FROM `j25_rsfirewall_logs`
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.23 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.00 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Opening tables | 0.03 ms |
checking permissions | 0.06 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.02 ms |
Sending data | 0.08 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.00 ms |
removing tmp table | 0.05 ms |
closing tables | 0.00 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Wywołujący | Plik i numer linii |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
14 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:261 |
13 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:180 |
12 | Joomla\CMS\Table\Table->__construct() | JROOT/administrator/components/com_rsfirewall/tables/logs.php:36 |
11 | RsfirewallTableLogs->__construct() | JROOT/libraries/src/Table/Table.php:328 |
10 | Joomla\CMS\Table\Table::getInstance() | JROOT/administrator/components/com_rsfirewall/helpers/log.php:23 |
9 | RSFirewallLogger->__construct() | JROOT/administrator/components/com_rsfirewall/helpers/log.php:77 |
8 | RSFirewallLogger::getInstance() | JROOT/plugins/system/rsfirewall/rsfirewall.php:47 |
7 | plgSystemRsfirewall->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.82 ms Po ostatnim zapytaniu: 18.53 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 8.962 MB Zwróconych wierszy: 1
SELECT `params`
FROM `j25_extensions`
WHERE `type` = 'component'
AND `element` = 'com_jchoptimize'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | j25_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | 10.00 | Using where |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.12 ms |
preparing | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.06 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Wywołujący | Plik i numer linii |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
13 | JDatabaseDriver->loadResult() | JROOT/libraries/fof40/Params/Params.php:55 |
12 | FOF40\Params\Params->reload() | JROOT/libraries/fof40/Params/Params.php:40 |
11 | FOF40\Params\Params->__construct() | JROOT/libraries/fof40/Container/Container.php:281 |
10 | FOF40\Container\Container->FOF40\Container\{closure}() | JROOT/libraries/fof40/Pimple/Container.php:115 |
9 | FOF40\Pimple\Container->offsetGet() | JROOT/libraries/fof40/Container/ContainerBase.php:27 |
8 | FOF40\Container\ContainerBase->__get() | JROOT/plugins/system/jchoptimize/jchoptimize.php:123 |
7 | plgSystemJchoptimize->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.58 ms Po ostatnim zapytaniu: 5.16 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 9.844 MB Zwróconych wierszy: 31
SELECT *
FROM j25_rsform_config
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | j25_rsform_config | NULL | ALL | NULL | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 26 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.00 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.12 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.03 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
logging slow query | 0.09 ms |
cleaning up | 0.01 ms |
# | Wywołujący | Plik i numer linii |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_rsform/helpers/config.php:50 |
11 | RSFormProConfig->load() | JROOT/administrator/components/com_rsform/helpers/config.php:17 |
10 | RSFormProConfig->__construct() | JROOT/administrator/components/com_rsform/helpers/config.php:102 |
9 | RSFormProConfig::getInstance() | JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php:26 |
8 | plgSystemRsformdeletesubmissions->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.86 ms Po ostatnim zapytaniu: 10.50 ms Pamięć zapytania: 0.020 MB Pamięć przed zapytaniem: 12.432 MB Zwróconych wierszy: 0
SELECT *
FROM j25_rsfirewall_hashes
WHERE (`type`='3.10.10' OR `type`='protect')
AND `flag`!='C'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | j25_rsfirewall_hashes | NULL | ALL | NULL | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 52 | 17.10 | Using where |
Status | Duration |
---|
starting | 0.08 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.15 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
logging slow query | 0.13 ms |
cleaning up | 0.02 ms |
# | Wywołujący | Plik i numer linii |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
9 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rsfirewall/rsfirewall.php:1049 |
8 | plgSystemRsfirewall->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.36 ms Po ostatnim zapytaniu: 0.37 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 12.469 MB Zwróconych wierszy: 0
SELECT *
FROM j25_rsfirewall_snapshots
WHERE `type`='protect'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | j25_rsfirewall_snapshots | NULL | ALL | NULL | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 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.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
logging slow query | 0.00 ms |
logging slow query | 0.07 ms |
cleaning up | 0.01 ms |
# | Wywołujący | Plik i numer linii |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
10 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_rsfirewall/helpers/snapshot.php:47 |
9 | RSFirewallSnapshot::get() | JROOT/plugins/system/rsfirewall/rsfirewall.php:1072 |
8 | plgSystemRsfirewall->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.48 ms Po ostatnim zapytaniu: 0.05 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 12.475 MB Zwróconych wierszy: 0
SELECT `ip`,`reason`
FROM j25_rsfirewall_lists
WHERE (`ip`='44.192.65.228' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%')
AND `type`='1'
AND `published`='1'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | j25_rsfirewall_lists | NULL | ref | published,type,ip | published | 1 | const | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 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.04 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.03 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Wywołujący | Plik i numer linii |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rsfirewall/rsfirewall.php:165 |
10 | plgSystemRsfirewall->isListed() | JROOT/plugins/system/rsfirewall/rsfirewall.php:144 |
9 | plgSystemRsfirewall->isWhitelisted() | JROOT/plugins/system/rsfirewall/rsfirewall.php:1108 |
8 | plgSystemRsfirewall->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.40 ms Po ostatnim zapytaniu: 0.03 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 12.480 MB Zwróconych wierszy: 0
SELECT `ip`,`reason`
FROM j25_rsfirewall_lists
WHERE (`ip`='44.192.65.228' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%')
AND `type`='0'
AND `published`='1'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | j25_rsfirewall_lists | NULL | ref | published,type,ip | published | 1 | const | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.05 ms |
preparing | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.03 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Wywołujący | Plik i numer linii |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rsfirewall/rsfirewall.php:165 |
10 | plgSystemRsfirewall->isListed() | JROOT/plugins/system/rsfirewall/rsfirewall.php:134 |
9 | plgSystemRsfirewall->isBlacklisted() | JROOT/plugins/system/rsfirewall/rsfirewall.php:1112 |
8 | plgSystemRsfirewall->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.32 ms Po ostatnim zapytaniu: 0.41 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 12.531 MB Zwróconych wierszy: 0
SELECT *
FROM j25_rsfirewall_exceptions
WHERE `published`='1'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | j25_rsfirewall_exceptions | NULL | ALL | NULL | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.03 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.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 |
logging slow query | 0.00 ms |
logging slow query | 0.08 ms |
cleaning up | 0.01 ms |
# | Wywołujący | Plik i numer linii |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
10 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rsfirewall/rsfirewall.php:700 |
9 | plgSystemRsfirewall->isException() | JROOT/plugins/system/rsfirewall/rsfirewall.php:1243 |
8 | plgSystemRsfirewall->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.77 ms Po ostatnim zapytaniu: 5.19 ms Pamięć zapytania: 0.006 MB Pamięć przed zapytaniem: 13.449 MB
UPDATE `j25_extensions`
SET `params` = '{\"mediaversion\":\"6173924219a1ee1427b6a3f2a0951556\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | UPDATE | j25_extensions | NULL | range | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.08 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.03 ms |
System lock | 0.11 ms |
updating | 0.14 ms |
end | 0.01 ms |
query end | 0.03 ms |
closing tables | 0.02 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Wywołujący | Plik i numer linii |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
13 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
12 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
11 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
10 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
9 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:294 |
8 | plgSystemEF4_JMFramework->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 2.19 ms Po ostatnim zapytaniu: 14.70 ms Pamięć zapytania: 0.380 MB Pamięć przed zapytaniem: 16.237 MB Zwróconych wierszy: 81
SELECT c.*
FROM j25_djc2_categories AS c
WHERE c.published=1
AND c.access IN (1,4)
AND (c.language = 'pl-PL' OR c.language = '*')
ORDER BY c.parent_id ASC, c.ordering ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | c | NULL | ref | idx_published,idx_access,idx_published_parent_ordering | idx_published_parent_ordering | 4 | const | 81 | 19.00 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.10 ms |
checking permissions | 0.01 ms |
Opening tables | 0.05 ms |
init | 0.06 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.12 ms |
preparing | 0.03 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 1.23 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.03 ms |
freeing items | 0.03 ms |
cleaning up | 0.02 ms |
# | Wywołujący | Plik i numer linii |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:343 |
12 | Djc2Categories->getCategories() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:204 |
11 | Djc2Categories->__construct() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:242 |
10 | Djc2Categories::getInstance() | JROOT/components/com_djcatalog2/helpers/djcatalog2.php:65 |
9 | Djcatalog2Helper::getParams() | JROOT/components/com_djcatalog2/controller.php:36 |
8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:57 |
6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 5.84 ms Po ostatnim zapytaniu: 0.21 ms Pamięć zapytania: 0.032 MB Pamięć przed zapytaniem: 16.709 MB Zwróconych wierszy: 100
SELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath
FROM j25_djc2_categories as i
INNER JOIN j25_djc2_images as img
on img.id=(select id
from j25_djc2_images
where type='category'
and item_id=i.id
order by ordering asc
limit 1)
WHERE (i.language = 'pl-PL' OR i.language = '*')
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | PRIMARY | i | NULL | ALL | NULL | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 97 | 19.00 | Using where |
1 | PRIMARY | img | NULL | eq_ref | PRIMARY | PRIMARY | 4 | func | 1 | 100.00 | Using where |
2 | DEPENDENT SUBQUERY | j25_djc2_images | NULL | ref | idx_type_item,idx_item_type,idx_item_type_ordering | idx_item_type_ordering | 262 | 01158718_educarium18.i.id,const | 3 | 100.00 | Using where; Using index; Uruchomiono metodę filesort |
Status | Duration |
---|
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.06 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
logging slow query | 0.41 ms |
cleaning up | 0.02 ms |
# | Wywołujący | Plik i numer linii |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:356 |
12 | Djc2Categories->getCategories() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:204 |
11 | Djc2Categories->__construct() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:242 |
10 | Djc2Categories::getInstance() | JROOT/components/com_djcatalog2/helpers/djcatalog2.php:65 |
9 | Djcatalog2Helper::getParams() | JROOT/components/com_djcatalog2/controller.php:36 |
8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:57 |
6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.72 ms Po ostatnim zapytaniu: 3.24 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 17.462 MB Zwróconych wierszy: 3
select alias
from j25_djc2_items_extra_fields
where type='checkbox' or type='radio' or type='select'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | j25_djc2_items_extra_fields | NULL | ALL | idx_type | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 11 | 36.36 | Using where |
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.03 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.08 ms |
preparing | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.07 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
logging slow query | 0.09 ms |
cleaning up | 0.01 ms |
# | Wywołujący | Plik i numer linii |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
9 | JDatabaseDriver->loadColumn() | JROOT/components/com_djcatalog2/controller.php:127 |
8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:57 |
6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 2.40 ms Po ostatnim zapytaniu: 3.07 ms Pamięć zapytania: 0.030 MB Pamięć przed zapytaniem: 18.027 MB Zwróconych wierszy: 45
SELECT `id`,`name`,`rules`,`parent_id`
FROM `j25_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_convertforms','com_cpanel','com_djcatalog2','com_djmediatools','com_fields','com_finder','com_installer','com_jce','com_jchoptimize','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocacommander','com_plugins','com_postinstall','com_privacy','com_redirect','com_rsfirewall','com_rsform','com_rstbox','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | j25_assets | NULL | ALL | idx_asset_name | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 329 | 13.98 | Using where |
Status | Duration |
---|
starting | 0.12 ms |
checking permissions | 0.01 ms |
Opening tables | 0.14 ms |
init | 0.09 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.28 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 1.30 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.03 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
logging slow query | 0.09 ms |
cleaning up | 0.01 ms |
# | Wywołujący | Plik i numer linii |
---|
25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
24 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
23 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
22 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
21 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
20 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
19 | Joomla\CMS\User\User->authorise() | JROOT/components/com_djcatalog2/helpers/user.php:302 |
18 | Djcatalog2HelperUser::getUserProfile() | JROOT/components/com_djcatalog2/helpers/djcatalog2.php:134 |
17 | Djcatalog2Helper::getUser() | JROOT/components/com_djcatalog2/helpers/djcatalog2.php:253 |
16 | Djcatalog2Helper::getUserProfile() | JROOT/components/com_djcatalog2/models/items.php:66 |
15 | DJCatalog2ModelItems->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 |
14 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/components/com_djcatalog2/models/items.php:224 |
13 | DJCatalog2ModelItems->getStoreId() | JROOT/components/com_djcatalog2/models/items.php:293 |
12 | DJCatalog2ModelItems->getItems() | JROOT/components/com_djcatalog2/views/items/view.html.php:103 |
11 | DJCatalog2ViewItems->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:137 |
8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:57 |
6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.72 ms Po ostatnim zapytaniu: 1.72 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 18.260 MB Zwróconych wierszy: 0
SELECT id
FROM j25_djc2_customer_groups
WHERE (user_group IN (1,9) OR is_default=1)
ORDER BY ordering DESC
LIMIT 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | j25_djc2_customer_groups | NULL | ALL | user_group | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 1 | 100.00 | Using where; Uruchomiono metodę filesort |
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.01 ms |
Opening tables | 0.15 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
preparing | 0.02 ms |
Sorting result | 0.00 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
Creating sort index | 0.04 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
logging slow query | 0.13 ms |
cleaning up | 0.02 ms |
# | Wywołujący | Plik i numer linii |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
19 | JDatabaseDriver->loadResult() | JROOT/components/com_djcatalog2/helpers/user.php:356 |
18 | Djcatalog2HelperUser::getUserProfile() | JROOT/components/com_djcatalog2/helpers/djcatalog2.php:134 |
17 | Djcatalog2Helper::getUser() | JROOT/components/com_djcatalog2/helpers/djcatalog2.php:253 |
16 | Djcatalog2Helper::getUserProfile() | JROOT/components/com_djcatalog2/models/items.php:66 |
15 | DJCatalog2ModelItems->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 |
14 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/components/com_djcatalog2/models/items.php:224 |
13 | DJCatalog2ModelItems->getStoreId() | JROOT/components/com_djcatalog2/models/items.php:293 |
12 | DJCatalog2ModelItems->getItems() | JROOT/components/com_djcatalog2/views/items/view.html.php:103 |
11 | DJCatalog2ViewItems->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:137 |
8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:57 |
6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.70 ms Po ostatnim zapytaniu: 0.03 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 18.269 MB Zwróconych wierszy: 0
select *
from j25_djc2_countries
where is_default=1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | j25_djc2_countries | NULL | ALL | NULL | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 250 | 10.00 | Using where |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.11 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.27 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.02 ms |
logging slow query | 0.00 ms |
logging slow query | 0.07 ms |
cleaning up | 0.01 ms |
# | Wywołujący | Plik i numer linii |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
19 | JDatabaseDriver->loadObject() | JROOT/components/com_djcatalog2/helpers/user.php:416 |
18 | Djcatalog2HelperUser::getUserProfile() | JROOT/components/com_djcatalog2/helpers/djcatalog2.php:134 |
17 | Djcatalog2Helper::getUser() | JROOT/components/com_djcatalog2/helpers/djcatalog2.php:253 |
16 | Djcatalog2Helper::getUserProfile() | JROOT/components/com_djcatalog2/models/items.php:66 |
15 | DJCatalog2ModelItems->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 |
14 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/components/com_djcatalog2/models/items.php:224 |
13 | DJCatalog2ModelItems->getStoreId() | JROOT/components/com_djcatalog2/models/items.php:293 |
12 | DJCatalog2ModelItems->getItems() | JROOT/components/com_djcatalog2/views/items/view.html.php:103 |
11 | DJCatalog2ViewItems->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:137 |
8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:57 |
6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.97 ms Po ostatnim zapytaniu: 0.03 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 18.283 MB Zwróconych wierszy: 0
SELECT vrul.id as rule_id, vrul.name, vrat.*
FROM j25_djc2_vat_rules AS vrul
INNER JOIN j25_djc2_vat_rules_xref AS vx
ON vx.rule_id = vrul.id
INNER JOIN j25_djc2_vat_rates AS vrat
ON vx.rate_id = vrat.id
WHERE vrat.country_id=0
AND vrat.state_id=0
AND (vrat.client_type='A' OR vrat.client_type='R')
ORDER BY vrat.client_type ASC, vrat.country_id ASC, vrat.state_id ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | vrul | NULL | ALL | PRIMARY | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 1 | 100.00 | Using temporary; Uruchomiono metodę filesort |
1 | SIMPLE | vx | NULL | ref | idx_rule_rate | idx_rule_rate | 4 | 01158718_educarium18.vrul.id | 1 | 100.00 | Using index |
1 | SIMPLE | vrat | NULL | eq_ref | PRIMARY,idx_country_client | PRIMARY | 4 | 01158718_educarium18.vx.rate_id | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.09 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.27 ms |
init | 0.05 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.12 ms |
preparing | 0.03 ms |
Creating tmp table | 0.04 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.03 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.01 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
logging slow query | 0.13 ms |
cleaning up | 0.02 ms |
# | Wywołujący | Plik i numer linii |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
19 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djcatalog2/helpers/user.php:488 |
18 | Djcatalog2HelperUser::getUserProfile() | JROOT/components/com_djcatalog2/helpers/djcatalog2.php:134 |
17 | Djcatalog2Helper::getUser() | JROOT/components/com_djcatalog2/helpers/djcatalog2.php:253 |
16 | Djcatalog2Helper::getUserProfile() | JROOT/components/com_djcatalog2/models/items.php:66 |
15 | DJCatalog2ModelItems->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 |
14 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/components/com_djcatalog2/models/items.php:224 |
13 | DJCatalog2ModelItems->getStoreId() | JROOT/components/com_djcatalog2/models/items.php:293 |
12 | DJCatalog2ModelItems->getItems() | JROOT/components/com_djcatalog2/views/items/view.html.php:103 |
11 | DJCatalog2ViewItems->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:137 |
8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:57 |
6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 1.35 ms Po ostatnim zapytaniu: 0.06 ms Pamięć zapytania: 0.033 MB Pamięć przed zapytaniem: 18.289 MB Zwróconych wierszy: 11
SELECT f.*, g.name as group_name, g.label as group_label, g.id as fgroup_id
FROM j25_djc2_items_extra_fields as f
LEFT JOIN j25_djc2_items_extra_fields_groups as g
ON g.id=f.group_id
WHERE f.published = 1
ORDER BY IFNULL(g.ordering,0) asc, g.ordering asc, f.ordering asc
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | f | NULL | ALL | idx_published | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 11 | 100.00 | Using where; Using temporary; Uruchomiono metodę filesort |
1 | SIMPLE | g | NULL | ALL | PRIMARY | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 1 | 100.00 | Using where; Using join buffer (Block Nested Loop) |
Status | Duration |
---|
starting | 0.09 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.11 ms |
init | 0.05 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.05 ms |
preparing | 0.03 ms |
Creating tmp table | 0.06 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.38 ms |
Creating sort index | 0.15 ms |
end | 0.01 ms |
query end | 0.01 ms |
removing tmp table | 0.05 ms |
query end | 0.01 ms |
closing tables | 0.05 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
logging slow query | 0.10 ms |
cleaning up | 0.02 ms |
# | Wywołujący | Plik i numer linii |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
17 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djcatalog2/models/items.php:1100 |
16 | DJCatalog2ModelItems->getAttributes() | JROOT/components/com_djcatalog2/models/items.php:108 |
15 | DJCatalog2ModelItems->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 |
14 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/components/com_djcatalog2/models/items.php:224 |
13 | DJCatalog2ModelItems->getStoreId() | JROOT/components/com_djcatalog2/models/items.php:293 |
12 | DJCatalog2ModelItems->getItems() | JROOT/components/com_djcatalog2/views/items/view.html.php:103 |
11 | DJCatalog2ViewItems->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:137 |
8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:57 |
6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.51 ms Po ostatnim zapytaniu: 0.04 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 18.317 MB Zwróconych wierszy: 23
SELECT o.id, o.field_id
FROM j25_djc2_items_extra_fields_options AS o
ORDER BY o.field_id asc, o.ordering asc
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | o | NULL | ALL | NULL | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 23 | 100.00 | Uruchomiono metodę filesort |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.10 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 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.09 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.03 ms |
freeing items | 0.02 ms |
logging slow query | 0.00 ms |
logging slow query | 0.11 ms |
cleaning up | 0.01 ms |
# | Wywołujący | Plik i numer linii |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
17 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djcatalog2/models/items.php:1110 |
16 | DJCatalog2ModelItems->getAttributes() | JROOT/components/com_djcatalog2/models/items.php:108 |
15 | DJCatalog2ModelItems->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 |
14 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/components/com_djcatalog2/models/items.php:224 |
13 | DJCatalog2ModelItems->getStoreId() | JROOT/components/com_djcatalog2/models/items.php:293 |
12 | DJCatalog2ModelItems->getItems() | JROOT/components/com_djcatalog2/views/items/view.html.php:103 |
11 | DJCatalog2ViewItems->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:137 |
8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:57 |
6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 1.73 ms Po ostatnim zapytaniu: 0.09 ms Pamięć zapytania: 0.382 MB Pamięć przed zapytaniem: 18.327 MB Zwróconych wierszy: 81
SELECT c.*
FROM j25_djc2_categories AS c
WHERE c.published=1
AND c.access IN (1,1,4)
AND (c.language = 'pl-PL' OR c.language = '*')
ORDER BY c.parent_id ASC, c.ordering ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | c | NULL | ref | idx_published,idx_access,idx_published_parent_ordering | idx_published_parent_ordering | 4 | const | 81 | 19.00 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.05 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.08 ms |
preparing | 0.03 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 1.11 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Wywołujący | Plik i numer linii |
---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
20 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:343 |
19 | Djc2Categories->getCategories() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:204 |
18 | Djc2Categories->__construct() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:242 |
17 | Djc2Categories::getInstance() | JROOT/components/com_djcatalog2/models/items.php:904 |
16 | DJCatalog2ModelItems->_buildContentWhere() | JROOT/components/com_djcatalog2/models/items.php:354 |
15 | DJCatalog2ModelItems->buildQuery() | JROOT/components/com_djcatalog2/models/items.php:321 |
14 | DJCatalog2ModelItems->getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:140 |
13 | Joomla\CMS\MVC\Model\ListModel->_getListQuery() | JROOT/components/com_djcatalog2/models/items.php:301 |
12 | DJCatalog2ModelItems->getItems() | JROOT/components/com_djcatalog2/views/items/view.html.php:103 |
11 | DJCatalog2ViewItems->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:137 |
8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:57 |
6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 6.16 ms Po ostatnim zapytaniu: 0.25 ms Pamięć zapytania: 0.035 MB Pamięć przed zapytaniem: 18.801 MB Zwróconych wierszy: 100
SELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath
FROM j25_djc2_categories as i
INNER JOIN j25_djc2_images as img
on img.id=(select id
from j25_djc2_images
where type='category'
and item_id=i.id
order by ordering asc
limit 1)
WHERE (i.language = 'pl-PL' OR i.language = '*')
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | PRIMARY | i | NULL | ALL | NULL | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 97 | 19.00 | Using where |
1 | PRIMARY | img | NULL | eq_ref | PRIMARY | PRIMARY | 4 | func | 1 | 100.00 | Using where |
2 | DEPENDENT SUBQUERY | j25_djc2_images | NULL | ref | idx_type_item,idx_item_type,idx_item_type_ordering | idx_item_type_ordering | 262 | 01158718_educarium18.i.id,const | 3 | 100.00 | Using where; Using index; Uruchomiono metodę filesort |
Status | Duration |
---|
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.03 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.03 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.03 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
logging slow query | 0.35 ms |
cleaning up | 0.02 ms |
# | Wywołujący | Plik i numer linii |
---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
20 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:356 |
19 | Djc2Categories->getCategories() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:204 |
18 | Djc2Categories->__construct() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:242 |
17 | Djc2Categories::getInstance() | JROOT/components/com_djcatalog2/models/items.php:904 |
16 | DJCatalog2ModelItems->_buildContentWhere() | JROOT/components/com_djcatalog2/models/items.php:354 |
15 | DJCatalog2ModelItems->buildQuery() | JROOT/components/com_djcatalog2/models/items.php:321 |
14 | DJCatalog2ModelItems->getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:140 |
13 | Joomla\CMS\MVC\Model\ListModel->_getListQuery() | JROOT/components/com_djcatalog2/models/items.php:301 |
12 | DJCatalog2ModelItems->getItems() | JROOT/components/com_djcatalog2/views/items/view.html.php:103 |
11 | DJCatalog2ViewItems->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:137 |
8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:57 |
6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 13.85 ms Po ostatnim zapytaniu: 0.75 ms Pamięć zapytania: 0.197 MB Pamięć przed zapytaniem: 18.969 MB Zwróconych wierszy: 47
SELECT distinct i.*,
CASE WHEN (i.special_price > 0.0
AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price,c.id as _category_id, c.name as category, c.published as publish_category, c.alias as category_alias,p.id as _producer_id, p.name as producer, p.published as publish_producer, p.alias as producer_alias,ua.name AS author, ua.email AS author_email,gc.price as group_price, gc.available as group_available,countries.country_name, countries.id as item_country_id,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count,states.name as state_name,combinations.combo_count
FROM j25_djc2_items as i
INNER JOIN (SELECT ic.item_id
FROM j25_djc2_items_categories AS ic
INNER JOIN j25_djc2_categories AS c
ON c.id=ic.category_id
WHERE c.published = 1
AND c.access IN (1,1,4)
AND ic.category_id IN (30)) as category_filter
ON i.id = category_filter.item_id
LEFT JOIN j25_djc2_categories AS c
ON c.id = i.cat_id
LEFT JOIN j25_djc2_producers AS p
ON p.id = i.producer_id
LEFT JOIN j25_users AS ua
ON ua.id = i.created_by
LEFT JOIN j25_djc2_prices AS gc
ON gc.item_id = i.id
AND gc.group_id=0
LEFT JOIN j25_djc2_countries AS countries
ON countries.id = i.country
LEFT JOIN j25_djc2_item_rating AS v
ON i.id = v.item_id
LEFT JOIN j25_djc2_countries_states AS states
ON states.id = i.state
LEFT JOIN (SELECT item_id, COUNT(*) as combo_count
FROM j25_djc2_items_combinations
GROUP BY item_id) AS combinations
ON combinations.item_id = i.id
WHERE (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2022-07-01 13:04:56')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2022-07-01 13:04:56')
AND i.published = 1
AND i.access IN (1,1,4)
AND i.parent_id=0
AND (i.language = 'pl-PL' OR i.language = '*')
ORDER BY c.parent_id asc, c.ordering asc, i.ordering asc
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | PRIMARY | c | NULL | const | PRIMARY,idx_published,idx_access,idx_published_parent_ordering | PRIMARY | 4 | const | 1 | 100.00 | Using temporary; Uruchomiono metodę filesort |
1 | PRIMARY | ic | NULL | ref | PRIMARY,item_category | PRIMARY | 4 | const | 49 | 100.00 | Using index |
1 | PRIMARY | i | NULL | eq_ref | PRIMARY,idx_parent_id,idx_published,idx_access | PRIMARY | 4 | 01158718_educarium18.ic.item_id | 1 | 5.00 | Using where |
1 | PRIMARY | c | NULL | eq_ref | PRIMARY | PRIMARY | 4 | 01158718_educarium18.i.cat_id | 1 | 100.00 | NULL |
1 | PRIMARY | p | NULL | eq_ref | PRIMARY | PRIMARY | 4 | 01158718_educarium18.i.producer_id | 1 | 100.00 | NULL |
1 | PRIMARY | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | 01158718_educarium18.i.created_by | 1 | 100.00 | NULL |
1 | PRIMARY | gc | NULL | eq_ref | item_group,group_item | item_group | 8 | 01158718_educarium18.ic.item_id,const | 1 | 100.00 | NULL |
1 | PRIMARY | countries | NULL | eq_ref | PRIMARY | PRIMARY | 2 | 01158718_educarium18.i.country | 1 | 100.00 | Using where |
1 | PRIMARY | v | NULL | ALL | PRIMARY | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 1 | 100.00 | Using where; Using join buffer (Block Nested Loop) |
1 | PRIMARY | states | NULL | eq_ref | PRIMARY | PRIMARY | 4 | 01158718_educarium18.i.state | 1 | 100.00 | NULL |
1 | PRIMARY | <derived3> | NULL | ref | <auto_key0> | <auto_key0> | 4 | 01158718_educarium18.ic.item_id | 2 | 100.00 | NULL |
3 | DERIVED | j25_djc2_items_combinations | NULL | ALL | NULL | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 1 | 100.00 | Using temporary; Uruchomiono metodę filesort |
Status | Duration |
---|
starting | 0.36 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.78 ms |
init | 0.27 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
optimizing | 0.00 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
Creating tmp table | 0.02 ms |
Sorting result | 0.05 ms |
statistics | 0.97 ms |
preparing | 0.07 ms |
Creating tmp table | 0.14 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 1.61 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
Creating sort index | 6.68 ms |
Creating sort index | 2.09 ms |
end | 0.01 ms |
query end | 0.01 ms |
removing tmp table | 0.10 ms |
query end | 0.01 ms |
removing tmp table | 0.01 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
removing tmp table | 0.01 ms |
closing tables | 0.11 ms |
freeing items | 0.07 ms |
logging slow query | 0.00 ms |
logging slow query | 0.22 ms |
cleaning up | 0.03 ms |
# | Wywołujący | Plik i numer linii |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djcatalog2/models/items.php:285 |
13 | DJCatalog2ModelItems->_getList() | JROOT/components/com_djcatalog2/models/items.php:303 |
12 | DJCatalog2ModelItems->getItems() | JROOT/components/com_djcatalog2/views/items/view.html.php:103 |
11 | DJCatalog2ViewItems->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:137 |
8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:57 |
6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 1.65 ms Po ostatnim zapytaniu: 0.29 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 19.574 MB Zwróconych wierszy: 0
SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, fieldoptions.id as option_id, fieldoptions.value, fieldoptions.params as option_params
FROM j25_djc2_items_extra_fields_values_int as fieldvalues
INNER JOIN j25_djc2_items as items
on items.id=fieldvalues.item_id
INNER JOIN j25_djc2_items_extra_fields as fields
ON fields.id = fieldvalues.field_id
LEFT JOIN j25_djc2_items_extra_fields_options as fieldoptions
ON fieldoptions.id = fieldvalues.value
AND fieldoptions.field_id = fields.id
WHERE fieldvalues.item_id IN (2849,2130,2076,2125,2073,2077,2169,2170,2171,2072,1569,1568,1571,2074,1570,1572,2075,1574,1573,1461,1459,1460,1443,1329,1442,1357,1323,1358,1324,1354,1327,1355,1328,1356,13,1326,730,729,11,12,14,15,732,733,731,734,2126)
AND fields.cart_variant = 2
AND fields.published = 1
ORDER BY fieldvalues.field_id asc, fields.ordering asc, fieldoptions.ordering asc
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | fields | NULL | ALL | PRIMARY,idx_published | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 11 | 10.00 | Using where; Using temporary; Uruchomiono metodę filesort |
1 | SIMPLE | fieldvalues | NULL | range | idx_item_field | idx_item_field | 4 | NULL | 47 | 10.00 | Using index condition; Using where; Using join buffer (Block Nested Loop) |
1 | SIMPLE | fieldoptions | NULL | eq_ref | PRIMARY,idx_field_id | PRIMARY | 4 | 01158718_educarium18.fieldvalues.value | 1 | 100.00 | Using where |
1 | SIMPLE | items | NULL | eq_ref | PRIMARY | PRIMARY | 4 | 01158718_educarium18.fieldvalues.item_id | 1 | 100.00 | Using index |
Status | Duration |
---|
starting | 0.16 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.12 ms |
init | 0.07 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.56 ms |
preparing | 0.05 ms |
Creating tmp table | 0.06 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.17 ms |
Creating sort index | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
removing tmp table | 0.03 ms |
query end | 0.00 ms |
closing tables | 0.02 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
logging slow query | 0.11 ms |
cleaning up | 0.02 ms |
# | Wywołujący | Plik i numer linii |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djcatalog2/models/items.php:1220 |
13 | DJCatalog2ModelItems->bindAttributes() | JROOT/components/com_djcatalog2/models/items.php:315 |
12 | DJCatalog2ModelItems->getItems() | JROOT/components/com_djcatalog2/views/items/view.html.php:103 |
11 | DJCatalog2ViewItems->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:137 |
8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:57 |
6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 1.63 ms Po ostatnim zapytaniu: 0.07 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 19.581 MB Zwróconych wierszy: 0
SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, fieldoptions.id as option_id, fieldoptions.value, fieldoptions.params as option_params
FROM j25_djc2_items_extra_fields_values_int as fieldvalues
INNER JOIN j25_djc2_items as items
on items.id=fieldvalues.item_id
INNER JOIN j25_djc2_items_extra_fields as fields
ON fields.id = fieldvalues.field_id
LEFT JOIN j25_djc2_items_extra_fields_options as fieldoptions
ON fieldoptions.id = fieldvalues.value
AND fieldoptions.field_id = fields.id
WHERE fieldvalues.item_id IN (2849,2130,2076,2125,2073,2077,2169,2170,2171,2072,1569,1568,1571,2074,1570,1572,2075,1574,1573,1461,1459,1460,1443,1329,1442,1357,1323,1358,1324,1354,1327,1355,1328,1356,13,1326,730,729,11,12,14,15,732,733,731,734,2126)
AND (fields.visibility = 2 OR fields.visibility = 3)
AND fields.published = 1
ORDER BY fieldvalues.field_id asc, fields.ordering asc, fieldoptions.ordering asc
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | fieldvalues | NULL | range | idx_item_field | idx_item_field | 4 | NULL | 47 | 100.00 | Using index condition; Using temporary; Uruchomiono metodę filesort |
1 | SIMPLE | fields | NULL | ALL | PRIMARY,idx_published | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 11 | 9.09 | Using where; Using join buffer (Block Nested Loop) |
1 | SIMPLE | fieldoptions | NULL | eq_ref | PRIMARY,idx_field_id | PRIMARY | 4 | 01158718_educarium18.fieldvalues.value | 1 | 100.00 | Using where |
1 | SIMPLE | items | NULL | eq_ref | PRIMARY | PRIMARY | 4 | 01158718_educarium18.fieldvalues.item_id | 1 | 100.00 | Using index |
Status | Duration |
---|
starting | 0.16 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 ms |
init | 0.06 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.53 ms |
preparing | 0.06 ms |
Creating tmp table | 0.03 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.29 ms |
Creating sort index | 0.03 ms |
end | 0.00 ms |
query end | 0.01 ms |
removing tmp table | 0.03 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
logging slow query | 0.14 ms |
cleaning up | 0.02 ms |
# | Wywołujący | Plik i numer linii |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djcatalog2/models/items.php:1223 |
13 | DJCatalog2ModelItems->bindAttributes() | JROOT/components/com_djcatalog2/models/items.php:315 |
12 | DJCatalog2ModelItems->getItems() | JROOT/components/com_djcatalog2/views/items/view.html.php:103 |
11 | DJCatalog2ViewItems->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:137 |
8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:57 |
6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 1.55 ms Po ostatnim zapytaniu: 0.06 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 19.589 MB Zwróconych wierszy: 0
SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, 0 as option_id, fieldvalues.value
FROM j25_djc2_items_extra_fields_values_text as fieldvalues
INNER JOIN j25_djc2_items as items
on items.id=fieldvalues.item_id
INNER JOIN j25_djc2_items_extra_fields as fields
ON fields.id = fieldvalues.field_id
WHERE fieldvalues.item_id IN (2849,2130,2076,2125,2073,2077,2169,2170,2171,2072,1569,1568,1571,2074,1570,1572,2075,1574,1573,1461,1459,1460,1443,1329,1442,1357,1323,1358,1324,1354,1327,1355,1328,1356,13,1326,730,729,11,12,14,15,732,733,731,734,2126)
AND (fields.visibility = 2 OR fields.visibility = 3)
AND fields.published = 1
ORDER BY fieldvalues.field_id asc, fields.ordering asc
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | fieldvalues | NULL | range | idx_item_field | idx_item_field | 4 | NULL | 47 | 100.00 | Using index condition; Using temporary; Uruchomiono metodę filesort |
1 | SIMPLE | fields | NULL | ALL | PRIMARY,idx_published | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 11 | 9.09 | Using where; Using join buffer (Block Nested Loop) |
1 | SIMPLE | items | NULL | eq_ref | PRIMARY | PRIMARY | 4 | 01158718_educarium18.fieldvalues.item_id | 1 | 100.00 | Using index |
Status | Duration |
---|
starting | 0.14 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.10 ms |
init | 0.06 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.53 ms |
preparing | 0.05 ms |
Creating tmp table | 0.03 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.28 ms |
Creating sort index | 0.03 ms |
end | 0.00 ms |
query end | 0.01 ms |
removing tmp table | 0.03 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
logging slow query | 0.13 ms |
cleaning up | 0.02 ms |
# | Wywołujący | Plik i numer linii |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djcatalog2/models/items.php:1226 |
13 | DJCatalog2ModelItems->bindAttributes() | JROOT/components/com_djcatalog2/models/items.php:315 |
12 | DJCatalog2ModelItems->getItems() | JROOT/components/com_djcatalog2/views/items/view.html.php:103 |
11 | DJCatalog2ViewItems->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:137 |
8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:57 |
6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 1.04 ms Po ostatnim zapytaniu: 0.05 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 19.597 MB Zwróconych wierszy: 0
SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, 0 as option_id, fieldvalues.value
FROM j25_djc2_items_extra_fields_values_date as fieldvalues
INNER JOIN j25_djc2_items as items
on items.id=fieldvalues.item_id
INNER JOIN j25_djc2_items_extra_fields as fields
ON fields.id = fieldvalues.field_id
WHERE fieldvalues.item_id IN (2849,2130,2076,2125,2073,2077,2169,2170,2171,2072,1569,1568,1571,2074,1570,1572,2075,1574,1573,1461,1459,1460,1443,1329,1442,1357,1323,1358,1324,1354,1327,1355,1328,1356,13,1326,730,729,11,12,14,15,732,733,731,734,2126)
AND (fields.visibility = 2 OR fields.visibility = 3)
AND fields.published = 1
ORDER BY fieldvalues.field_id asc, fields.ordering asc
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | fieldvalues | NULL | ALL | item_field | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 1 | 100.00 | Using where; Uruchomiono metodę filesort |
1 | SIMPLE | fields | NULL | eq_ref | PRIMARY,idx_published | PRIMARY | 4 | 01158718_educarium18.fieldvalues.field_id | 1 | 19.00 | Using where |
1 | SIMPLE | items | NULL | eq_ref | PRIMARY | PRIMARY | 4 | 01158718_educarium18.fieldvalues.item_id | 1 | 100.00 | Using index |
Status | Duration |
---|
starting | 0.14 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
Opening tables | 0.12 ms |
init | 0.06 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.30 ms |
preparing | 0.03 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.03 ms |
logging slow query | 0.00 ms |
logging slow query | 0.09 ms |
cleaning up | 0.02 ms |
# | Wywołujący | Plik i numer linii |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djcatalog2/models/items.php:1229 |
13 | DJCatalog2ModelItems->bindAttributes() | JROOT/components/com_djcatalog2/models/items.php:315 |
12 | DJCatalog2ModelItems->getItems() | JROOT/components/com_djcatalog2/views/items/view.html.php:103 |
11 | DJCatalog2ViewItems->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:137 |
8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:57 |
6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 1.12 ms Po ostatnim zapytaniu: 0.10 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 19.610 MB Zwróconych wierszy: 0
SELECT l.*, li.item_id
FROM j25_djc2_labels as l
INNER JOIN j25_djc2_labels_items AS li
ON li.label_id=l.id
WHERE li.item_id IN (2849,2130,2076,2125,2073,2077,2169,2170,2171,2072,1569,1568,1571,2074,1570,1572,2075,1574,1573,1461,1459,1460,1443,1329,1442,1357,1323,1358,1324,1354,1327,1355,1328,1356,13,1326,730,729,11,12,14,15,732,733,731,734,2126)
AND l.published = 1
ORDER BY l.ordering
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | l | NULL | ALL | PRIMARY | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 1 | 100.00 | Using where; Using temporary; Uruchomiono metodę filesort |
1 | SIMPLE | li | NULL | index | PRIMARY | PRIMARY | 8 | NULL | 1 | 100.00 | Using where; Using index; Using join buffer (Block Nested Loop) |
Status | Duration |
---|
starting | 0.10 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
Opening tables | 0.23 ms |
init | 0.05 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.21 ms |
preparing | 0.03 ms |
Creating tmp table | 0.03 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.13 ms |
Creating sort index | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
removing tmp table | 0.03 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
logging slow query | 0.12 ms |
cleaning up | 0.02 ms |
# | Wywołujący | Plik i numer linii |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djcatalog2/models/items.php:1232 |
13 | DJCatalog2ModelItems->bindAttributes() | JROOT/components/com_djcatalog2/models/items.php:315 |
12 | DJCatalog2ModelItems->getItems() | JROOT/components/com_djcatalog2/views/items/view.html.php:103 |
11 | DJCatalog2ViewItems->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:137 |
8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:57 |
6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.84 ms Po ostatnim zapytaniu: 0.06 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 19.619 MB Zwróconych wierszy: 0
SELECT cg.*, p.item_id, p.available, p.price
FROM j25_djc2_customer_groups AS cg
INNER JOIN j25_djc2_prices AS p
ON p.group_id=cg.id
WHERE p.item_id IN (2849, 2130, 2076, 2125, 2073, 2077, 2169, 2170, 2171, 2072, 1569, 1568, 1571, 2074, 1570, 1572, 2075, 1574, 1573, 1461, 1459, 1460, 1443, 1329, 1442, 1357, 1323, 1358, 1324, 1354, 1327, 1355, 1328, 1356, 13, 1326, 730, 729, 11, 12, 14, 15, 732, 733, 731, 734, 2126)
AND (p.available = 1 OR p.price > 0.0)
ORDER BY cg.ordering
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | cg | NULL | ALL | PRIMARY | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 1 | 100.00 | Uruchomiono metodę filesort |
1 | SIMPLE | p | NULL | ref | item_group,group_item | group_item | 4 | 01158718_educarium18.cg.id | 1 | 100.00 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.11 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 ms |
init | 0.05 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.26 ms |
preparing | 0.03 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
Creating sort index | 0.03 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
logging slow query | 0.09 ms |
cleaning up | 0.02 ms |
# | Wywołujący | Plik i numer linii |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djcatalog2/models/items.php:1235 |
13 | DJCatalog2ModelItems->bindAttributes() | JROOT/components/com_djcatalog2/models/items.php:315 |
12 | DJCatalog2ModelItems->getItems() | JROOT/components/com_djcatalog2/views/items/view.html.php:103 |
11 | DJCatalog2ViewItems->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:137 |
8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:57 |
6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 5.43 ms Po ostatnim zapytaniu: 0.09 ms Pamięć zapytania: 0.027 MB Pamięć przed zapytaniem: 19.629 MB Zwróconych wierszy: 47
SELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath
FROM j25_djc2_items as i
INNER JOIN j25_djc2_images as img
on img.id=(select id
from j25_djc2_images
where type='item'
and item_id=i.id
order by ordering asc
limit 1)
WHERE i.id IN (2849,2130,2076,2125,2073,2077,2169,2170,2171,2072,1569,1568,1571,2074,1570,1572,2075,1574,1573,1461,1459,1460,1443,1329,1442,1357,1323,1358,1324,1354,1327,1355,1328,1356,13,1326,730,729,11,12,14,15,732,733,731,734,2126)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | PRIMARY | i | NULL | range | PRIMARY | PRIMARY | 4 | NULL | 47 | 100.00 | Using where; Using index |
1 | PRIMARY | img | NULL | eq_ref | PRIMARY | PRIMARY | 4 | func | 1 | 100.00 | Using where |
2 | DEPENDENT SUBQUERY | j25_djc2_images | NULL | ref | idx_type_item,idx_item_type,idx_item_type_ordering | idx_item_type_ordering | 262 | 01158718_educarium18.i.id,const | 3 | 100.00 | Using where; Using index; Uruchomiono metodę filesort |
Status | Duration |
---|
Sending data | 0.00 ms |
Creating sort index | 0.04 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.04 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.04 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.04 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.03 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.04 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.04 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.04 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.06 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.06 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.04 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.04 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.03 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.03 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.10 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.09 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.10 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.10 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.05 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.05 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.08 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.08 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.08 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.08 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.07 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.07 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.06 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.06 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.04 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.11 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.05 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.05 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.03 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Wywołujący | Plik i numer linii |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djcatalog2/models/items.php:1325 |
13 | DJCatalog2ModelItems->bindAttributes() | JROOT/components/com_djcatalog2/models/items.php:315 |
12 | DJCatalog2ModelItems->getItems() | JROOT/components/com_djcatalog2/views/items/view.html.php:103 |
11 | DJCatalog2ViewItems->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:137 |
8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:57 |
6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 1.72 ms Po ostatnim zapytaniu: 0.39 ms Pamięć zapytania: 0.381 MB Pamięć przed zapytaniem: 19.669 MB Zwróconych wierszy: 81
SELECT c.*
FROM j25_djc2_categories AS c
WHERE c.published=1
AND c.access IN (1,1,4)
AND (c.language = 'pl-PL' OR c.language = '*')
ORDER BY c.parent_id ASC, c.ordering ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | c | NULL | ref | idx_published,idx_access,idx_published_parent_ordering | idx_published_parent_ordering | 4 | const | 81 | 19.00 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.08 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.05 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.08 ms |
preparing | 0.03 ms |
Sorting result | 0.00 ms |
executing | 0.00 ms |
Sending data | 1.09 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Wywołujący | Plik i numer linii |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
17 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:343 |
16 | Djc2Categories->getCategories() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:204 |
15 | Djc2Categories->__construct() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:242 |
14 | Djc2Categories::getInstance() | JROOT/components/com_djcatalog2/models/items.php:1332 |
13 | DJCatalog2ModelItems->bindAttributes() | JROOT/components/com_djcatalog2/models/items.php:315 |
12 | DJCatalog2ModelItems->getItems() | JROOT/components/com_djcatalog2/views/items/view.html.php:103 |
11 | DJCatalog2ViewItems->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:137 |
8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:57 |
6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 5.45 ms Po ostatnim zapytaniu: 0.37 ms Pamięć zapytania: 0.034 MB Pamięć przed zapytaniem: 20.142 MB Zwróconych wierszy: 100
SELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath
FROM j25_djc2_categories as i
INNER JOIN j25_djc2_images as img
on img.id=(select id
from j25_djc2_images
where type='category'
and item_id=i.id
order by ordering asc
limit 1)
WHERE (i.language = 'pl-PL' OR i.language = '*')
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | PRIMARY | i | NULL | ALL | NULL | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 97 | 19.00 | Using where |
1 | PRIMARY | img | NULL | eq_ref | PRIMARY | PRIMARY | 4 | func | 1 | 100.00 | Using where |
2 | DEPENDENT SUBQUERY | j25_djc2_images | NULL | ref | idx_type_item,idx_item_type,idx_item_type_ordering | idx_item_type_ordering | 262 | 01158718_educarium18.i.id,const | 3 | 100.00 | Using where; Using index; Uruchomiono metodę filesort |
Status | Duration |
---|
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.00 ms |
Creating sort index | 0.03 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.03 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
logging slow query | 0.38 ms |
cleaning up | 0.02 ms |
# | Wywołujący | Plik i numer linii |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
17 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:356 |
16 | Djc2Categories->getCategories() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:204 |
15 | Djc2Categories->__construct() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:242 |
14 | Djc2Categories::getInstance() | JROOT/components/com_djcatalog2/models/items.php:1332 |
13 | DJCatalog2ModelItems->bindAttributes() | JROOT/components/com_djcatalog2/models/items.php:315 |
12 | DJCatalog2ModelItems->getItems() | JROOT/components/com_djcatalog2/views/items/view.html.php:103 |
11 | DJCatalog2ViewItems->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:137 |
8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:57 |
6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.68 ms Po ostatnim zapytaniu: 0.46 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 20.310 MB Zwróconych wierszy: 0
SELECT *
FROM j25_djc2_price_rules
WHERE published=1
AND (start_date = '0000-00-00 00:00:00' OR start_date <= '2022-07-01 13:04:56')
AND (expire_date = '0000-00-00 00:00:00' OR expire_date >= '2022-07-01 13:04:56')
ORDER BY ordering
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | j25_djc2_price_rules | NULL | ALL | NULL | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 1 | 100.00 | Using where; Uruchomiono metodę filesort |
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.01 ms |
Opening tables | 0.13 ms |
init | 0.05 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.02 ms |
preparing | 0.02 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.03 ms |
Creating sort index | 0.05 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
logging slow query | 0.10 ms |
cleaning up | 0.02 ms |
# | Wywołujący | Plik i numer linii |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
16 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djcatalog2/helpers/price.php:413 |
15 | Djcatalog2HelperPrice::getPriceRules() | JROOT/components/com_djcatalog2/helpers/price.php:190 |
14 | Djcatalog2HelperPrice::applyPriceRules() | JROOT/components/com_djcatalog2/models/items.php:1363 |
13 | DJCatalog2ModelItems->bindAttributes() | JROOT/components/com_djcatalog2/models/items.php:315 |
12 | DJCatalog2ModelItems->getItems() | JROOT/components/com_djcatalog2/views/items/view.html.php:103 |
11 | DJCatalog2ViewItems->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:137 |
8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:57 |
6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 2.83 ms Po ostatnim zapytaniu: 1.41 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 20.336 MB Zwróconych wierszy: 1
SELECT COUNT(distinct (i.id))
FROM j25_djc2_items as i
INNER JOIN (SELECT ic.item_id
FROM j25_djc2_items_categories AS ic
INNER JOIN j25_djc2_categories AS c
ON c.id=ic.category_id
WHERE c.published = 1
AND c.access IN (1,1,4)
AND ic.category_id IN (30)) as category_filter
ON i.id = category_filter.item_id
LEFT JOIN j25_djc2_categories AS c
ON c.id = i.cat_id
LEFT JOIN j25_djc2_producers AS p
ON p.id = i.producer_id
LEFT JOIN j25_users AS ua
ON ua.id = i.created_by
LEFT JOIN j25_djc2_prices AS gc
ON gc.item_id = i.id
AND gc.group_id=0
LEFT JOIN j25_djc2_countries AS countries
ON countries.id = i.country
LEFT JOIN j25_djc2_item_rating AS v
ON i.id = v.item_id
LEFT JOIN j25_djc2_countries_states AS states
ON states.id = i.state
LEFT JOIN (SELECT item_id, COUNT(*) as combo_count
FROM j25_djc2_items_combinations
GROUP BY item_id) AS combinations
ON combinations.item_id = i.id
WHERE (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2022-07-01 13:04:56')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2022-07-01 13:04:56')
AND i.published = 1
AND i.access IN (1,1,4)
AND i.parent_id=0
AND (i.language = 'pl-PL' OR i.language = '*')
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | PRIMARY | c | NULL | const | PRIMARY,idx_published,idx_access,idx_published_parent_ordering | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | PRIMARY | ic | NULL | ref | PRIMARY,item_category | PRIMARY | 4 | const | 49 | 100.00 | Using index |
1 | PRIMARY | i | NULL | eq_ref | PRIMARY,idx_parent_id,idx_published,idx_access | PRIMARY | 4 | 01158718_educarium18.ic.item_id | 1 | 5.00 | Using where |
1 | PRIMARY | c | NULL | eq_ref | PRIMARY | PRIMARY | 4 | 01158718_educarium18.i.cat_id | 1 | 100.00 | Using index |
1 | PRIMARY | p | NULL | eq_ref | PRIMARY | PRIMARY | 4 | 01158718_educarium18.i.producer_id | 1 | 100.00 | Using index |
1 | PRIMARY | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | 01158718_educarium18.i.created_by | 1 | 100.00 | Using index |
1 | PRIMARY | gc | NULL | eq_ref | item_group,group_item | item_group | 8 | 01158718_educarium18.ic.item_id,const | 1 | 100.00 | Using index |
1 | PRIMARY | countries | NULL | eq_ref | PRIMARY | PRIMARY | 2 | 01158718_educarium18.i.country | 1 | 100.00 | Using where; Using index |
1 | PRIMARY | v | NULL | eq_ref | PRIMARY | PRIMARY | 4 | 01158718_educarium18.ic.item_id | 1 | 100.00 | Using index |
1 | PRIMARY | states | NULL | eq_ref | PRIMARY | PRIMARY | 4 | 01158718_educarium18.i.state | 1 | 100.00 | Using index |
1 | PRIMARY | <derived3> | NULL | ref | <auto_key0> | <auto_key0> | 4 | 01158718_educarium18.ic.item_id | 2 | 100.00 | NULL |
3 | DERIVED | j25_djc2_items_combinations | NULL | ALL | NULL | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 1 | 100.00 | Using temporary; Uruchomiono metodę filesort |
Status | Duration |
---|
starting | 0.24 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
Opening tables | 0.05 ms |
init | 0.15 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
optimizing | 0.00 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
Creating tmp table | 0.02 ms |
Sorting result | 0.04 ms |
statistics | 0.30 ms |
preparing | 0.07 ms |
executing | 0.01 ms |
Sending data | 0.10 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
Creating sort index | 1.32 ms |
end | 0.01 ms |
query end | 0.01 ms |
removing tmp table | 0.01 ms |
query end | 0.00 ms |
removing tmp table | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
removing tmp table | 0.00 ms |
closing tables | 0.05 ms |
freeing items | 0.04 ms |
logging slow query | 0.00 ms |
logging slow query | 0.19 ms |
cleaning up | 0.02 ms |
# | Wywołujący | Plik i numer linii |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
15 | JDatabaseDriver->loadResult() | JROOT/components/com_djcatalog2/models/items.php:334 |
14 | DJCatalog2ModelItems->_getListCount() | JROOT/libraries/src/MVC/Model/ListModel.php:289 |
13 | Joomla\CMS\MVC\Model\ListModel->getTotal() | JROOT/libraries/src/MVC/Model/ListModel.php:239 |
12 | Joomla\CMS\MVC\Model\ListModel->getPagination() | JROOT/components/com_djcatalog2/views/items/view.html.php:105 |
11 | DJCatalog2ViewItems->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:137 |
8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:57 |
6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 2.33 ms Po ostatnim zapytaniu: 0.87 ms Pamięć zapytania: 0.381 MB Pamięć przed zapytaniem: 20.462 MB Zwróconych wierszy: 81
SELECT c.*
FROM j25_djc2_categories AS c
WHERE c.published=1
AND (c.language = 'pl-PL' OR c.language = '*')
ORDER BY c.parent_id ASC, c.ordering ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | c | NULL | ref | idx_published,idx_published_parent_ordering | idx_published_parent_ordering | 4 | const | 81 | 19.00 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.09 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.06 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.08 ms |
preparing | 0.03 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 1.54 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.04 ms |
freeing items | 0.04 ms |
cleaning up | 0.02 ms |
# | Wywołujący | Plik i numer linii |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
16 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:343 |
15 | Djc2Categories->getCategories() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:204 |
14 | Djc2Categories->__construct() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:242 |
13 | Djc2Categories::getInstance() | JROOT/components/com_djcatalog2/models/items.php:1387 |
12 | DJCatalog2ModelItems->getProducers() | JROOT/components/com_djcatalog2/views/items/view.html.php:159 |
11 | DJCatalog2ViewItems->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:137 |
8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:57 |
6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 5.89 ms Po ostatnim zapytaniu: 0.26 ms Pamięć zapytania: 0.034 MB Pamięć przed zapytaniem: 20.935 MB Zwróconych wierszy: 100
SELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath
FROM j25_djc2_categories as i
INNER JOIN j25_djc2_images as img
on img.id=(select id
from j25_djc2_images
where type='category'
and item_id=i.id
order by ordering asc
limit 1)
WHERE (i.language = 'pl-PL' OR i.language = '*')
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | PRIMARY | i | NULL | ALL | NULL | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 97 | 19.00 | Using where |
1 | PRIMARY | img | NULL | eq_ref | PRIMARY | PRIMARY | 4 | func | 1 | 100.00 | Using where |
2 | DEPENDENT SUBQUERY | j25_djc2_images | NULL | ref | idx_type_item,idx_item_type,idx_item_type_ordering | idx_item_type_ordering | 262 | 01158718_educarium18.i.id,const | 3 | 100.00 | Using where; Using index; Uruchomiono metodę filesort |
Status | Duration |
---|
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.03 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.03 ms |
freeing items | 0.04 ms |
logging slow query | 0.00 ms |
logging slow query | 0.38 ms |
cleaning up | 0.01 ms |
# | Wywołujący | Plik i numer linii |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
16 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:356 |
15 | Djc2Categories->getCategories() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:204 |
14 | Djc2Categories->__construct() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:242 |
13 | Djc2Categories::getInstance() | JROOT/components/com_djcatalog2/models/items.php:1387 |
12 | DJCatalog2ModelItems->getProducers() | JROOT/components/com_djcatalog2/views/items/view.html.php:159 |
11 | DJCatalog2ViewItems->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:137 |
8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:57 |
6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.99 ms Po ostatnim zapytaniu: 0.41 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 21.093 MB Zwróconych wierszy: 0
SELECT DISTINCT a.id, a.name as text
FROM j25_djc2_producers as a
INNER JOIN j25_djc2_items AS i
ON a.id = i.producer_id
AND i.published = 1
INNER JOIN j25_djc2_items_categories AS c
ON c.item_id = i.id
WHERE c.category_id IN (30)
AND a.published=1
GROUP BY a.id, a.name
ORDER BY a.ordering asc
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | c | NULL | ref | PRIMARY,item_category | PRIMARY | 4 | const | 49 | 100.00 | Using index; Using temporary; Uruchomiono metodę filesort |
1 | SIMPLE | i | NULL | eq_ref | PRIMARY,idx_producer_id,idx_published | PRIMARY | 4 | 01158718_educarium18.c.item_id | 1 | 100.00 | Using where |
1 | SIMPLE | a | NULL | eq_ref | PRIMARY,idx_published | PRIMARY | 4 | 01158718_educarium18.i.producer_id | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.10 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.14 ms |
preparing | 0.02 ms |
Creating tmp table | 0.03 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.28 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.03 ms |
cleaning up | 0.02 ms |
# | Wywołujący | Plik i numer linii |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djcatalog2/models/items.php:1406 |
12 | DJCatalog2ModelItems->getProducers() | JROOT/components/com_djcatalog2/views/items/view.html.php:159 |
11 | DJCatalog2ViewItems->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:137 |
8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:57 |
6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 1.30 ms Po ostatnim zapytaniu: 4.66 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 21.732 MB Zwróconych wierszy: 3
SELECT f.*, g.name as group_name, g.label as group_label, g.id as fgroup_id
FROM j25_djc2_items_extra_fields as f
LEFT JOIN j25_djc2_items_extra_fields_groups as g
ON g.id=f.group_id
WHERE (f.visibility = 2 or f.visibility = 3)
and f.published = 1
ORDER BY IFNULL(g.ordering,0) asc, g.ordering asc, f.ordering asc
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | f | NULL | ALL | idx_published | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 11 | 19.00 | Using where; Using temporary; Uruchomiono metodę filesort |
1 | SIMPLE | g | NULL | ALL | PRIMARY | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 1 | 100.00 | Using where; Using join buffer (Block Nested Loop) |
Status | Duration |
---|
starting | 0.11 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 ms |
init | 0.05 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.06 ms |
preparing | 0.04 ms |
Creating tmp table | 0.06 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.33 ms |
Creating sort index | 0.08 ms |
end | 0.01 ms |
query end | 0.01 ms |
removing tmp table | 0.04 ms |
query end | 0.01 ms |
closing tables | 0.03 ms |
freeing items | 0.04 ms |
logging slow query | 0.00 ms |
logging slow query | 0.11 ms |
cleaning up | 0.02 ms |
# | Wywołujący | Plik i numer linii |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djcatalog2/models/items.php:1100 |
12 | DJCatalog2ModelItems->getAttributes() | JROOT/components/com_djcatalog2/views/items/view.html.php:260 |
11 | DJCatalog2ViewItems->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:137 |
8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:57 |
6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 2.15 ms Po ostatnim zapytaniu: 0.23 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 21.758 MB Zwróconych wierszy: 0
SELECT f.*
FROM j25_djc2_items_extra_fields as f
INNER JOIN j25_djc2_items_groups as i
on i.group_id = f.group_id
INNER JOIN (
SELECT distinct i.id
FROM j25_djc2_items as i
INNER JOIN (SELECT ic.item_id
FROM j25_djc2_items_categories AS ic
INNER JOIN j25_djc2_categories AS c
ON c.id=ic.category_id
WHERE c.published = 1
AND c.access IN (1,1,4)
AND ic.category_id IN (30)) as category_filter
ON i.id = category_filter.item_id
LEFT JOIN j25_djc2_categories AS c
ON c.id = i.cat_id
LEFT JOIN j25_djc2_producers AS p
ON p.id = i.producer_id
LEFT JOIN j25_users AS ua
ON ua.id = i.created_by
LEFT JOIN j25_djc2_prices AS gc
ON gc.item_id = i.id
AND gc.group_id=0
LEFT JOIN j25_djc2_countries AS countries
ON countries.id = i.country
LEFT JOIN j25_djc2_item_rating AS v
ON i.id = v.item_id
LEFT JOIN j25_djc2_countries_states AS states
ON states.id = i.state
WHERE (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2022-07-01 13:04:56')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2022-07-01 13:04:56')
AND i.published = 1
AND i.access IN (1,1,4)
AND i.parent_id=0
AND (i.language = 'pl-PL' OR i.language = '*')
ORDER BY i.id asc) as iq
on iq.id = i.item_id
WHERE (f.visibility = 2 or f.visibility = 3)
and f.published = 1
and f.separate_column = 1
GROUP BY f.name, f.alias, f.id, f.group_id
ORDER BY f.group_id asc, f.ordering asc
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | PRIMARY | f | NULL | ref | idx_published,idx_separate_column,idx_group_id | idx_separate_column | 4 | const | 1 | 19.00 | Using where; Using temporary; Uruchomiono metodę filesort |
1 | PRIMARY | <derived2> | NULL | ALL | NULL | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 2 | 100.00 | Using join buffer (Block Nested Loop) |
1 | PRIMARY | i | NULL | eq_ref | PRIMARY,item_group | PRIMARY | 8 | 01158718_educarium18.f.group_id,iq.id | 1 | 100.00 | Using index |
2 | DERIVED | c | NULL | const | PRIMARY,idx_published,idx_access,idx_published_parent_ordering | PRIMARY | 4 | const | 1 | 100.00 | Using temporary; Uruchomiono metodę filesort |
2 | DERIVED | ic | NULL | ref | PRIMARY,item_category | PRIMARY | 4 | const | 49 | 100.00 | Using index |
2 | DERIVED | i | NULL | eq_ref | PRIMARY,idx_cat_id,idx_parent_id,idx_group_id,idx_producer_id,idx_published,idx_access,idx_featured,idx_ordering,idx_created_by,idx_country,idx_state,idx_latitude,idx_longitude | PRIMARY | 4 | 01158718_educarium18.ic.item_id | 1 | 5.00 | Using where |
2 | DERIVED | c | NULL | eq_ref | PRIMARY | PRIMARY | 4 | 01158718_educarium18.i.cat_id | 1 | 100.00 | Using index; Distinct |
2 | DERIVED | p | NULL | eq_ref | PRIMARY | PRIMARY | 4 | 01158718_educarium18.i.producer_id | 1 | 100.00 | Using index; Distinct |
2 | DERIVED | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | 01158718_educarium18.i.created_by | 1 | 100.00 | Using index; Distinct |
2 | DERIVED | gc | NULL | eq_ref | item_group,group_item | item_group | 8 | 01158718_educarium18.ic.item_id,const | 1 | 100.00 | Using index; Distinct |
2 | DERIVED | countries | NULL | eq_ref | PRIMARY | PRIMARY | 2 | 01158718_educarium18.i.country | 1 | 100.00 | Using where; Using index; Distinct |
2 | DERIVED | v | NULL | eq_ref | PRIMARY | PRIMARY | 4 | 01158718_educarium18.ic.item_id | 1 | 100.00 | Using index; Distinct |
2 | DERIVED | states | NULL | eq_ref | PRIMARY | PRIMARY | 4 | 01158718_educarium18.i.state | 1 | 100.00 | Using index; Distinct |
Status | Duration |
---|
starting | 0.25 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
Opening tables | 0.39 ms |
init | 0.19 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
optimizing | 0.04 ms |
statistics | 0.27 ms |
preparing | 0.05 ms |
Creating tmp table | 0.02 ms |
Sorting result | 0.02 ms |
statistics | 0.09 ms |
preparing | 0.03 ms |
Creating tmp table | 0.05 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.25 ms |
Creating sort index | 0.04 ms |
end | 0.01 ms |
query end | 0.01 ms |
removing tmp table | 0.04 ms |
query end | 0.01 ms |
removing tmp table | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
removing tmp table | 0.00 ms |
closing tables | 0.03 ms |
freeing items | 0.05 ms |
logging slow query | 0.00 ms |
logging slow query | 0.21 ms |
cleaning up | 0.02 ms |
# | Wywołujący | Plik i numer linii |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djcatalog2/models/items.php:1664 |
12 | DJCatalog2ModelItems->getFieldGroups() | JROOT/components/com_djcatalog2/views/items/view.html.php:261 |
11 | DJCatalog2ViewItems->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:137 |
8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:57 |
6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 3.43 ms Po ostatnim zapytaniu: 0.25 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 21.766 MB Zwróconych wierszy: 0
SELECT f.*
FROM j25_djc2_items_extra_fields as f
INNER JOIN j25_djc2_items_groups as i
on i.group_id = f.group_id
INNER JOIN (
SELECT distinct i.id
FROM j25_djc2_items as i
INNER JOIN (SELECT ic.item_id
FROM j25_djc2_items_categories AS ic
INNER JOIN j25_djc2_categories AS c
ON c.id=ic.category_id
WHERE c.published = 1
AND c.access IN (1,1,4)
AND ic.category_id IN (30)) as category_filter
ON i.id = category_filter.item_id
LEFT JOIN j25_djc2_categories AS c
ON c.id = i.cat_id
LEFT JOIN j25_djc2_producers AS p
ON p.id = i.producer_id
LEFT JOIN j25_users AS ua
ON ua.id = i.created_by
LEFT JOIN j25_djc2_prices AS gc
ON gc.item_id = i.id
AND gc.group_id=0
LEFT JOIN j25_djc2_countries AS countries
ON countries.id = i.country
LEFT JOIN j25_djc2_item_rating AS v
ON i.id = v.item_id
LEFT JOIN j25_djc2_countries_states AS states
ON states.id = i.state
WHERE (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2022-07-01 13:04:56')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2022-07-01 13:04:56')
AND i.published = 1
AND i.access IN (1,1,4)
AND i.parent_id=0
AND (i.language = 'pl-PL' OR i.language = '*')
ORDER BY i.id asc) as iq
on iq.id = i.item_id
WHERE f.published = 1
and f.sortable = 1
and (f.type = 'text' OR f.type = 'radio' OR f.type = 'select' OR f.type = 'calendar')
GROUP BY f.name, f.alias, f.id, f.group_id
ORDER BY f.group_id asc, f.ordering asc
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | PRIMARY | <derived2> | NULL | ALL | NULL | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 2 | 100.00 | Using temporary; Uruchomiono metodę filesort |
1 | PRIMARY | i | NULL | ref | PRIMARY,item_group | item_group | 4 | iq.id | 1 | 100.00 | Using index |
1 | PRIMARY | f | NULL | ALL | idx_published,idx_type,idx_group_id | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 11 | 10.00 | Using where; Using join buffer (Block Nested Loop) |
2 | DERIVED | c | NULL | const | PRIMARY,idx_published,idx_access,idx_published_parent_ordering | PRIMARY | 4 | const | 1 | 100.00 | Using temporary; Uruchomiono metodę filesort |
2 | DERIVED | ic | NULL | ref | PRIMARY,item_category | PRIMARY | 4 | const | 49 | 100.00 | Using index |
2 | DERIVED | i | NULL | eq_ref | PRIMARY,idx_cat_id,idx_parent_id,idx_group_id,idx_producer_id,idx_published,idx_access,idx_featured,idx_ordering,idx_created_by,idx_country,idx_state,idx_latitude,idx_longitude | PRIMARY | 4 | 01158718_educarium18.ic.item_id | 1 | 5.00 | Using where |
2 | DERIVED | c | NULL | eq_ref | PRIMARY | PRIMARY | 4 | 01158718_educarium18.i.cat_id | 1 | 100.00 | Using index; Distinct |
2 | DERIVED | p | NULL | eq_ref | PRIMARY | PRIMARY | 4 | 01158718_educarium18.i.producer_id | 1 | 100.00 | Using index; Distinct |
2 | DERIVED | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | 01158718_educarium18.i.created_by | 1 | 100.00 | Using index; Distinct |
2 | DERIVED | gc | NULL | eq_ref | item_group,group_item | item_group | 8 | 01158718_educarium18.ic.item_id,const | 1 | 100.00 | Using index; Distinct |
2 | DERIVED | countries | NULL | eq_ref | PRIMARY | PRIMARY | 2 | 01158718_educarium18.i.country | 1 | 100.00 | Using where; Using index; Distinct |
2 | DERIVED | v | NULL | eq_ref | PRIMARY | PRIMARY | 4 | 01158718_educarium18.ic.item_id | 1 | 100.00 | Using index; Distinct |
2 | DERIVED | states | NULL | eq_ref | PRIMARY | PRIMARY | 4 | 01158718_educarium18.i.state | 1 | 100.00 | Using index; Distinct |
Status | Duration |
---|
starting | 0.25 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
Opening tables | 0.05 ms |
init | 0.18 ms |
System lock | 0.01 ms |
optimizing | 0.00 ms |
optimizing | 0.04 ms |
statistics | 0.25 ms |
preparing | 0.04 ms |
Creating tmp table | 0.02 ms |
Sorting result | 0.02 ms |
statistics | 0.13 ms |
preparing | 0.07 ms |
Creating tmp table | 0.04 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
executing | 0.00 ms |
Sending data | 1.28 ms |
Creating sort index | 0.43 ms |
Creating sort index | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
removing tmp table | 0.04 ms |
query end | 0.01 ms |
removing tmp table | 0.01 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
removing tmp table | 0.00 ms |
closing tables | 0.08 ms |
freeing items | 0.05 ms |
logging slow query | 0.00 ms |
logging slow query | 0.20 ms |
cleaning up | 0.02 ms |
# | Wywołujący | Plik i numer linii |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djcatalog2/models/items.php:1704 |
12 | DJCatalog2ModelItems->getSortables() | JROOT/components/com_djcatalog2/views/items/view.html.php:262 |
11 | DJCatalog2ViewItems->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:137 |
8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:57 |
6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 1.59 ms Po ostatnim zapytaniu: 0.87 ms Pamięć zapytania: 0.381 MB Pamięć przed zapytaniem: 21.792 MB Zwróconych wierszy: 81
SELECT c.*
FROM j25_djc2_categories AS c
WHERE c.published=1
AND c.access IN (1,4)
ORDER BY c.parent_id ASC, c.ordering ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | c | NULL | ref | idx_published,idx_access,idx_published_parent_ordering | idx_published_parent_ordering | 4 | const | 81 | 100.00 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.07 ms |
preparing | 0.02 ms |
Sorting result | 0.00 ms |
executing | 0.00 ms |
Sending data | 0.98 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.03 ms |
cleaning up | 0.02 ms |
# | Wywołujący | Plik i numer linii |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
17 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:343 |
16 | Djc2Categories->getCategories() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:204 |
15 | Djc2Categories->__construct() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:242 |
14 | Djc2Categories::getInstance() | JROOT/components/com_djcatalog2/helpers/route.php:236 |
13 | DJCatalogHelperRoute::getCategoryRoute() | JROOT/components/com_djcatalog2/views/items/view.html.php:392 |
12 | DJCatalog2ViewItems->_prepareDocument() | JROOT/components/com_djcatalog2/views/items/view.html.php:263 |
11 | DJCatalog2ViewItems->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:137 |
8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:57 |
6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 5.40 ms Po ostatnim zapytaniu: 0.27 ms Pamięć zapytania: 0.034 MB Pamięć przed zapytaniem: 22.281 MB Zwróconych wierszy: 100
SELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath
FROM j25_djc2_categories as i
INNER JOIN j25_djc2_images as img
on img.id=(select id
from j25_djc2_images
where type='category'
and item_id=i.id
order by ordering asc
limit 1)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | PRIMARY | i | NULL | index | NULL | idx_parent_id | 4 | NULL | 97 | 100.00 | Using index |
1 | PRIMARY | img | NULL | eq_ref | PRIMARY | PRIMARY | 4 | func | 1 | 100.00 | Using where |
2 | DEPENDENT SUBQUERY | j25_djc2_images | NULL | ref | idx_type_item,idx_item_type,idx_item_type_ordering | idx_item_type_ordering | 262 | 01158718_educarium18.i.id,const | 3 | 100.00 | Using where; Using index; Uruchomiono metodę filesort |
Status | Duration |
---|
Sending data | 0.00 ms |
Creating sort index | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.03 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Wywołujący | Plik i numer linii |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
17 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:356 |
16 | Djc2Categories->getCategories() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:204 |
15 | Djc2Categories->__construct() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:242 |
14 | Djc2Categories::getInstance() | JROOT/components/com_djcatalog2/helpers/route.php:236 |
13 | DJCatalogHelperRoute::getCategoryRoute() | JROOT/components/com_djcatalog2/views/items/view.html.php:392 |
12 | DJCatalog2ViewItems->_prepareDocument() | JROOT/components/com_djcatalog2/views/items/view.html.php:263 |
11 | DJCatalog2ViewItems->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:137 |
8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:57 |
6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.75 ms Po ostatnim zapytaniu: 3.06 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 22.835 MB Zwróconych wierszy: 0
SELECT *
FROM j25_djc2_images
WHERE item_id=30
AND type='category'
AND exclude=0
ORDER BY ordering ASC, name ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | j25_djc2_images | NULL | ref | idx_type_item,idx_item_type,idx_item_type_ordering | idx_type_item | 262 | const,const | 1 | 10.00 | Using index condition; Using where; Uruchomiono metodę filesort |
Status | Duration |
---|
starting | 0.09 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.13 ms |
preparing | 0.03 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
Creating sort index | 0.06 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Wywołujący | Plik i numer linii |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djcatalog2/helpers/image.php:77 |
13 | DJCatalog2ImageHelper::getImages() | JROOT/components/com_djcatalog2/views/items/view.html.php:450 |
12 | DJCatalog2ViewItems->_prepareDocument() | JROOT/components/com_djcatalog2/views/items/view.html.php:263 |
11 | DJCatalog2ViewItems->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:137 |
8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:57 |
6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 2.38 ms Po ostatnim zapytaniu: 1.98 ms Pamięć zapytania: 0.028 MB Pamięć przed zapytaniem: 23.034 MB Zwróconych wierszy: 18
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM j25_modules AS m
LEFT JOIN j25_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN j25_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 <= '2022-07-01 13:04:56')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-07-01 13:04:56')
AND m.access IN (1,1,4)
AND m.client_id = 0
AND (mm.menuid = 87 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 | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 108 | 0.93 | Using where; Uruchomiono metodę filesort |
1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid | element_clientid | 403 | 01158718_educarium18.m.module,const | 1 | 10.00 | Using index condition; Using where |
1 | SIMPLE | mm | NULL | ref | PRIMARY | PRIMARY | 4 | 01158718_educarium18.m.id | 4 | 40.00 | Using where; Using index |
Status | Duration |
---|
starting | 0.15 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
Opening tables | 0.22 ms |
init | 0.08 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.13 ms |
preparing | 0.07 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
Creating sort index | 1.18 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.05 ms |
freeing items | 0.04 ms |
logging slow query | 0.00 ms |
logging slow query | 0.11 ms |
cleaning up | 0.02 ms |
# | Wywołujący | Plik i numer linii |
---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
20 | JDatabaseDriver->loadObjectList() | Identyczny z wywołaniem linii niżej. |
19 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
18 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:441 |
17 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:371 |
16 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 |
15 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/components/com_djcatalog2/views/items/tmpl/default.php:13 |
14 | include JROOT/components/com_djcatalog2/views/items/tmpl/default.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
13 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
12 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/components/com_djcatalog2/views/items/view.html.php:266 |
11 | DJCatalog2ViewItems->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:137 |
8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:57 |
6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 1.99 ms Po ostatnim zapytaniu: 9.93 ms Pamięć zapytania: 0.028 MB Pamięć przed zapytaniem: 23.247 MB Zwróconych wierszy: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM j25_fields AS a
LEFT JOIN `j25_languages` AS l
ON l.lang_code = a.language
LEFT JOIN j25_users AS uc
ON uc.id=a.checked_out
LEFT JOIN j25_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN j25_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN j25_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_djcatalog2.category.description'
AND a.access IN (1,1,4)
AND (a.group_id = 0 OR g.access IN (1,1,4))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | 100.00 | Using index condition; Using where; Using temporary; Uruchomiono metodę filesort |
1 | SIMPLE | l | NULL | eq_ref | idx_langcode | idx_langcode | 28 | 01158718_educarium18.a.language | 1 | 100.00 | Using where |
1 | SIMPLE | uc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | 01158718_educarium18.a.checked_out | 1 | 100.00 | NULL |
1 | SIMPLE | ag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | 01158718_educarium18.a.access | 1 | 100.00 | Using where |
1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | 01158718_educarium18.a.created_user_id | 1 | 100.00 | Using where |
1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | 01158718_educarium18.a.group_id | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.19 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 |
Opening tables | 0.44 ms |
init | 0.09 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.19 ms |
preparing | 0.04 ms |
Creating tmp table | 0.07 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.27 ms |
Creating sort index | 0.05 ms |
end | 0.01 ms |
query end | 0.01 ms |
removing tmp table | 0.05 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.04 ms |
cleaning up | 0.02 ms |
# | Wywołujący | Plik i numer linii |
---|
27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
26 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
25 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
24 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
23 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
22 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
21 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
20 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
19 | JEventDispatcher->trigger() | JROOT/libraries/cms/html/content.php:41 |
18 | JHtmlContent::prepare() | Identyczny z wywołaniem linii niżej. |
17 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
16 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:146 |
15 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/components/com_djcatalog2/views/items/tmpl/default.php:110 |
14 | include JROOT/components/com_djcatalog2/views/items/tmpl/default.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
13 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
12 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/components/com_djcatalog2/views/items/view.html.php:266 |
11 | DJCatalog2ViewItems->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:137 |
8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:57 |
6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 8.52 ms Po ostatnim zapytaniu: 0.79 ms Pamięć zapytania: 0.135 MB Pamięć przed zapytaniem: 23.378 MB Zwróconych wierszy: 1935
select id, producer_id
from j25_djc2_items
where published=1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | j25_djc2_items | NULL | ref | idx_published | idx_published | 4 | const | 1935 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.05 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 7.93 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.04 ms |
cleaning up | 0.01 ms |
# | Wywołujący | Plik i numer linii |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
18 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djcatalog2/helpers/route.php:73 |
17 | DJCatalogHelperRoute::getItemRoute() | JROOT/components/com_djcatalog2/views/items/tmpl/default_items.php:27 |
16 | include JROOT/components/com_djcatalog2/views/items/tmpl/default_items.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
15 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/components/com_djcatalog2/views/items/tmpl/default.php:228 |
14 | include JROOT/components/com_djcatalog2/views/items/tmpl/default.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
13 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
12 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/components/com_djcatalog2/views/items/view.html.php:266 |
11 | DJCatalog2ViewItems->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:137 |
8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:57 |
6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.76 ms Po ostatnim zapytaniu: 35.81 ms Pamięć zapytania: 0.020 MB Pamięć przed zapytaniem: 23.392 MB Zwróconych wierszy: 0
SELECT `id`
FROM `j25_rstbox`
WHERE `published` = 1
AND `testmode` = 0
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | j25_rstbox | NULL | ALL | NULL | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.08 ms |
checking permissions | 0.01 ms |
Opening tables | 0.14 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.03 ms |
preparing | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.04 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.04 ms |
logging slow query | 0.00 ms |
logging slow query | 0.20 ms |
cleaning up | 0.02 ms |
# | Wywołujący | Plik i numer linii |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
9 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_rstbox/EngageBox/Boxes.php:41 |
8 | EngageBox\Boxes::render() | JROOT/plugins/system/rstbox/rstbox.php:68 |
7 | PlgSystemRstBox->onAfterDispatch() | JROOT/libraries/joomla/event/event.php:70 |
6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/SiteApplication.php:199 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.71 ms Po ostatnim zapytaniu: 1.38 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 23.625 MB Zwróconych wierszy: 8
SELECT id
FROM j25_template_styles
ORDER BY id
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | j25_template_styles | NULL | index | NULL | PRIMARY | 4 | NULL | 8 | 100.00 | Using index |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.15 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.02 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.08 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.03 ms |
cleaning up | 0.02 ms |
# | Wywołujący | Plik i numer linii |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
10 | JDatabaseDriver->loadColumn() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:329 |
9 | JMFTemplate->setup() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:126 |
8 | JMFTemplate->__construct() | JROOT/templates/educarium-2/index.php:18 |
7 | require JROOT/templates/educarium-2/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.81 ms Po ostatnim zapytaniu: 118.97 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 26.122 MB Zwróconych wierszy: 1
SELECT manifest_cache
FROM j25_extensions
WHERE element='mod_djmegamenu'
LIMIT 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | j25_extensions | NULL | ref | element_clientid,element_folder_clientid | element_clientid | 402 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.09 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.12 ms |
preparing | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.06 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.03 ms |
freeing items | 0.03 ms |
cleaning up | 0.02 ms |
# | Wywołujący | Plik i numer linii |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
15 | JDatabaseDriver->loadResult() | JROOT/modules/mod_djmegamenu/helper.php:398 |
14 | modDJMMHelper::getVersion() | JROOT/modules/mod_djmegamenu/mod_djmegamenu.php:84 |
13 | include JROOT/modules/mod_djmegamenu/mod_djmegamenu.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
12 | Joomla\CMS\Helper\ModuleHelper::renderModule() | Identyczny z wywołaniem linii niżej. |
11 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
10 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:628 |
9 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
5 × SELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath
FROM j25_djc2_categories as i
INNER JOIN j25_djc2_images as img
on img.id=(select id
from j25_djc2_images
5 × SELECT c.*
FROM j25_djc2_categories AS c
2 × SELECT f.*, g.name as group_name, g.label as group_label, g.id as fgroup_id
FROM j25_djc2_items_extra_fields as f
LEFT JOIN j25_djc2_items_extra_fields_groups as g
ON g.id=f.group_id
2 × SELECT f.*
FROM j25_djc2_items_extra_fields as f
INNER JOIN j25_djc2_items_groups as i
on i.group_id = f.group_id
INNER JOIN ( SELECT distinct i.id
FROM j25_djc2_items as i
INNER JOIN (SELECT ic.item_id
FROM j25_djc2_items_categories AS ic
INNER JOIN j25_djc2_categories AS c
ON c.id=ic.category_id
2 × SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, fieldoptions.id as option_id, fieldoptions.value, fieldoptions.params as option_params
FROM j25_djc2_items_extra_fields_values_int as fieldvalues
INNER JOIN j25_djc2_items as items
on items.id=fieldvalues.item_id
INNER JOIN j25_djc2_items_extra_fields as fields
ON fields.id = fieldvalues.field_id
LEFT JOIN j25_djc2_items_extra_fields_options as fieldoptions
ON fieldoptions.id = fieldvalues.value
AND fieldoptions.field_id = fields.id
2 × SELECT `ip`,`reason`
FROM j25_rsfirewall_lists
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM j25_modules AS m
LEFT JOIN j25_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN j25_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT *
FROM j25_djc2_images
1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM j25_fields AS a
LEFT JOIN `j25_languages` AS l
ON l.lang_code = a.language
LEFT JOIN j25_users AS uc
ON uc.id=a.checked_out
LEFT JOIN j25_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN j25_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN j25_fields_groups AS g
ON g.id = a.group_id
1 × SELECT DISTINCT a.id, a.name as text
FROM j25_djc2_producers as a
INNER JOIN j25_djc2_items AS i
ON a.id = i.producer_id
AND i.published = 1
INNER JOIN j25_djc2_items_categories AS c
ON c.item_id = i.id
1 × select id, producer_id
from j25_djc2_items
1 × SELECT COUNT(distinct (i.id))
FROM j25_djc2_items as i
INNER JOIN (SELECT ic.item_id
FROM j25_djc2_items_categories AS ic
INNER JOIN j25_djc2_categories AS c
ON c.id=ic.category_id
1 × SELECT `id`
FROM `j25_rstbox`
1 × SELECT id
FROM j25_template_styles
1 × SELECT *
FROM j25_djc2_price_rules
1 × SELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath
FROM j25_djc2_items as i
INNER JOIN j25_djc2_images as img
on img.id=(select id
from j25_djc2_images
1 × SELECT cg.*, p.item_id, p.available, p.price
FROM j25_djc2_customer_groups AS cg
INNER JOIN j25_djc2_prices AS p
ON p.group_id=cg.id
1 × SELECT l.*, li.item_id
FROM j25_djc2_labels as l
INNER JOIN j25_djc2_labels_items AS li
ON li.label_id=l.id
1 × SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, 0 as option_id, fieldvalues.value
FROM j25_djc2_items_extra_fields_values_date as fieldvalues
INNER JOIN j25_djc2_items as items
on items.id=fieldvalues.item_id
INNER JOIN j25_djc2_items_extra_fields as fields
ON fields.id = fieldvalues.field_id
1 × SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, 0 as option_id, fieldvalues.value
FROM j25_djc2_items_extra_fields_values_text as fieldvalues
INNER JOIN j25_djc2_items as items
on items.id=fieldvalues.item_id
INNER JOIN j25_djc2_items_extra_fields as fields
ON fields.id = fieldvalues.field_id
1 × SELECT `session_id`
FROM `j25_session`
1 × SELECT distinct i.*,
CASE WHEN (i.special_price > 0.0
AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price,c.id as _category_id, c.name as category, c.published as publish_category, c.alias as category_alias,p.id as _producer_id, p.name as producer, p.published as publish_producer, p.alias as producer_alias,ua.name AS author, ua.email AS author_email,gc.price as group_price, gc.available as group_available,countries.country_name, countries.id as item_country_id,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count,states.name as state_name,combinations.combo_count
FROM j25_djc2_items as i
INNER JOIN (SELECT ic.item_id
FROM j25_djc2_items_categories AS ic
INNER JOIN j25_djc2_categories AS c
ON c.id=ic.category_id
1 × SELECT *
FROM j25_rsfirewall_hashes
1 × SELECT b.id
FROM j25_usergroups AS a
LEFT JOIN j25_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `path`
FROM j25_rsfirewall_ignored
1 × SELECT `file`
FROM j25_rsfirewall_hashes
1 × SELECT *
FROM j25_rsfirewall_configuratio
1 × SELECT `params`
FROM `j25_extensions`
1 × SELECT *
FROM j25_rsform_confi
1 × SELECT *
FROM j25_rsfirewall_snapshots
1 × SELECT o.id, o.field_id
FROM j25_djc2_items_extra_fields_options AS o
1 × SELECT *
FROM j25_rsfirewall_exceptions
1 × select alias
from j25_djc2_items_extra_fields
1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `j25_assets`
1 × SELECT id
FROM j25_djc2_customer_groups
1 × select *
from j25_djc2_countries
1 × SELECT vrul.id as rule_id, vrul.name, vrat.*
FROM j25_djc2_vat_rules AS vrul
INNER JOIN j25_djc2_vat_rules_xref AS vx
ON vx.rule_id = vrul.id
INNER JOIN j25_djc2_vat_rates AS vrat
ON vx.rate_id = vrat.id
1 × SELECT id, rules
FROM `j25_viewlevels
1 × SELECT manifest_cache
FROM j25_extensions