Czas zapytania: 0.51 ms Pamięć zapytania: 0.003 MB Pamięć przed zapytaniem: 1.449 MB
DELETE
FROM `saf6i_session`
WHERE `time` < '1695348243'
Polecenie EXPLAIN niemożliwe w zapytaniu: DELETE
FROM `saf6i_session`
WHERE `time` < '1695348243'
| Status | Duration |
|---|
| Starting | 0.16 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.01 ms |
| init for update | 0.05 ms |
| Updating | 0.03 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.05 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Wywołujący | Plik i numer linii |
|---|
| 6 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Application/CMSApplication.php:824 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:133 |
| 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:415 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Czas zapytania: 0.35 ms Po ostatnim zapytaniu: 0.30 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 1.457 MB Zwróconych wierszy: 0
SELECT `data`
FROM `saf6i_session`
WHERE `session_id` = '4a417ebfe53a3c3fca29afb1b19df4af'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | saf6i_session | const | PRIMARY | PRIMARY | 766 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.01 ms |
| Executing | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.02 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.04 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Wywołujący | Plik i numer linii |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 15 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:45 |
| 14 | JSessionStorageDatabase->read() | Identyczny z wywołaniem linii niżej. |
| 13 | session_start() | JROOT/libraries/joomla/session/handler/native.php:260 |
| 12 | JSessionHandlerNative->doSessionStart() | JROOT/libraries/joomla/session/handler/native.php:50 |
| 11 | JSessionHandlerNative->start() | JROOT/libraries/joomla/session/handler/joomla.php:88 |
| 10 | JSessionHandlerJoomla->start() | JROOT/libraries/src/Session/Session.php:660 |
| 9 | Joomla\CMS\Session\Session->_start() | JROOT/libraries/src/Session/Session.php:620 |
| 8 | Joomla\CMS\Session\Session->start() | JROOT/libraries/src/Session/Session.php:498 |
| 7 | Joomla\CMS\Session\Session->get() | JROOT/libraries/src/Session/Session.php:455 |
| 6 | Joomla\CMS\Session\Session->isNew() | JROOT/libraries/src/Application/CMSApplication.php:831 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:133 |
| 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:415 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Czas zapytania: 0.31 ms Po ostatnim zapytaniu: 1.45 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 1.472 MB Zwróconych wierszy: 0
SELECT `session_id`
FROM `saf6i_session`
WHERE `session_id` = '4a417ebfe53a3c3fca29afb1b19df4af'
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | saf6i_session | const | PRIMARY | PRIMARY | 766 | const | 1 | Using index |
| Status | Duration |
|---|
| Starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.01 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.02 ms |
| Preparing | 0.01 ms |
| Executing | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Wywołujący | Plik i numer linii |
|---|
| 8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 7 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Application/CMSApplication.php:178 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:833 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:133 |
| 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:415 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Czas zapytania: 0.42 ms Po ostatnim zapytaniu: 0.05 ms Pamięć zapytania: 0.003 MB Pamięć przed zapytaniem: 1.477 MB
INSERT INTO `saf6i_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
('4a417ebfe53a3c3fca29afb1b19df4af', 1, '1695349143', 0, '', 0)
Polecenie EXPLAIN niemożliwe w zapytaniu: INSERT INTO `saf6i_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
('4a417ebfe53a3c3fca29afb1b19df4af', 1, '1695349143', 0, '', 0)
| Status | Duration |
|---|
| Starting | 0.07 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init for update | 0.01 ms |
| Update | 0.07 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.10 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.04 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Wywołujący | Plik i numer linii |
|---|
| 7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Application/CMSApplication.php:218 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:833 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:133 |
| 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:415 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Czas zapytania: 0.36 ms Po ostatnim zapytaniu: 8.63 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 1.697 MB Zwróconych wierszy: 5
SELECT id, rules
FROM `saf6i_viewlevels`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | saf6i_viewlevels | ALL | NULL | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 5 | |
| Status | Duration |
|---|
| Starting | 0.07 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.01 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Wywołujący | Plik i numer linii |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1496 |
| 9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Access/Access.php:1063 |
| 8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
| 7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:310 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:606 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.34 ms Po ostatnim zapytaniu: 0.05 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 1.709 MB Zwróconych wierszy: 2
SELECT b.id
FROM saf6i_usergroups AS a
LEFT JOIN saf6i_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | b | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 2 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.01 ms |
| Unlocking tables | 0.01 ms |
| Preparing | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.02 ms |
| # | Wywołujący | Plik i numer linii |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1540 |
| 10 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:980 |
| 9 | Joomla\CMS\Access\Access::getGroupsByUser() | JROOT/libraries/src/Access/Access.php:1095 |
| 8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
| 7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:310 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:606 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.74 ms Po ostatnim zapytaniu: 1.34 ms Pamięć zapytania: 0.037 MB Pamięć przed zapytaniem: 1.735 MB Zwróconych wierszy: 83
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM saf6i_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | saf6i_extensions | ALL | extension | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 223 | Using where; Uruchomiono metodę filesort |
| Status | Duration |
|---|
| Starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.04 ms |
| Preparing | 0.01 ms |
| Sorting result | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.33 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.04 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Wywołujący | Plik i numer linii |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php:343 |
| 9 | Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() | Identyczny z wywołaniem linii niżej. |
| 8 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 7 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Plugin/PluginHelper.php:348 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:606 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.46 ms Po ostatnim zapytaniu: 37.91 ms Pamięć zapytania: 0.006 MB Pamięć przed zapytaniem: 2.495 MB
UPDATE `saf6i_extensions`
SET `params` = '{\"mediaversion\":\"eb3ce110167e590493d232166e68091d\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
Polecenie EXPLAIN niemożliwe w zapytaniu: UPDATE `saf6i_extensions`
SET `params` = '{\"mediaversion\":\"eb3ce110167e590493d232166e68091d\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
| Status | Duration |
|---|
| Starting | 0.08 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init for update | 0.05 ms |
| Updating | 0.04 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.10 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.01 ms |
| Reset for next command | 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/djjquerymonster/djjquerymonster.php:58 |
| 8 | plgSystemDJjQueryMonster->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:1156 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.40 ms Po ostatnim zapytaniu: 31.01 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 3.244 MB Zwróconych wierszy: 5
SELECT a.id
FROM saf6i_viewlevels AS a
ORDER BY a.ordering ASC, a.id ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | ALL | NULL | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 5 | Uruchomiono metodę filesort |
| Status | Duration |
|---|
| Starting | 0.07 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.05 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Wywołujący | Plik i numer linii |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 14 | JDatabaseDriver->loadResult() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:53 |
| 13 | Djc2CategoryNode->__construct() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:168 |
| 12 | Djc2Categories->__construct() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:207 |
| 11 | Djc2Categories::getInstance() | JROOT/components/com_djcatalog2/helpers/djcatalog2.php:70 |
| 10 | Djcatalog2Helper::getParams() | JROOT/components/com_djcatalog2/helpers/theme.php:39 |
| 9 | DJCatalog2ThemeHelper::setThemeAssets() | JROOT/components/com_djcatalog2/controller.php:59 |
| 8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:60 |
| 6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.44 ms Po ostatnim zapytaniu: 0.03 ms Pamięć zapytania: 0.063 MB Pamięć przed zapytaniem: 3.250 MB Zwróconych wierszy: 8
SELECT c.*
FROM saf6i_djc2_categories AS c
WHERE c.published=1
AND c.access IN (1,5)
ORDER BY c.parent_id ASC, c.ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | c | ref | idx_published,idx_published_parent_ordering,idx_access | idx_published_parent_ordering | 4 | const | 8 | Using where |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.03 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.04 ms |
| Preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.10 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Wywołujący | Plik i numer linii |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:298 |
| 13 | Djc2Categories->getCategories() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:169 |
| 12 | Djc2Categories->__construct() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:207 |
| 11 | Djc2Categories::getInstance() | JROOT/components/com_djcatalog2/helpers/djcatalog2.php:70 |
| 10 | Djcatalog2Helper::getParams() | JROOT/components/com_djcatalog2/helpers/theme.php:39 |
| 9 | DJCatalog2ThemeHelper::setThemeAssets() | JROOT/components/com_djcatalog2/controller.php:59 |
| 8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:60 |
| 6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.87 ms Po ostatnim zapytaniu: 0.05 ms Pamięć zapytania: 0.026 MB Pamięć przed zapytaniem: 3.328 MB Zwróconych wierszy: 11
SELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath
FROM saf6i_djc2_categories as i
INNER JOIN saf6i_djc2_images as img
on img.id=(select id
from saf6i_djc2_images
where type='category'
and item_id=i.id
order by ordering asc
limit 1)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | i | index | NULL | idx_parent_id | 4 | NULL | 14 | Using index |
| 1 | PRIMARY | img | eq_ref | PRIMARY | PRIMARY | 4 | func | 1 | Using where |
| 2 | DEPENDENT SUBQUERY | saf6i_djc2_images | ref | idx_type_item,idx_item_type,idx_item_type_ordering | idx_item_type_ordering | 198 | bil2013_sch.i.id,const | 1 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.04 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Wywołujący | Plik i numer linii |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:305 |
| 13 | Djc2Categories->getCategories() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:169 |
| 12 | Djc2Categories->__construct() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:207 |
| 11 | Djc2Categories::getInstance() | JROOT/components/com_djcatalog2/helpers/djcatalog2.php:70 |
| 10 | Djcatalog2Helper::getParams() | JROOT/components/com_djcatalog2/helpers/theme.php:39 |
| 9 | DJCatalog2ThemeHelper::setThemeAssets() | JROOT/components/com_djcatalog2/controller.php:59 |
| 8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:60 |
| 6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.42 ms Po ostatnim zapytaniu: 6.72 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 3.434 MB Zwróconych wierszy: 0
select alias
from saf6i_djc2_items_extra_fields
where type='checkbox' or type='radio' or type='select'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | saf6i_djc2_items_extra_fields | range | idx_type | idx_type | 767 | NULL | 1 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.08 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.04 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Wywołujący | Plik i numer linii |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1540 |
| 9 | JDatabaseDriver->loadColumn() | JROOT/components/com_djcatalog2/controller.php:98 |
| 8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:60 |
| 6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.74 ms Po ostatnim zapytaniu: 10.51 ms Pamięć zapytania: 0.032 MB Pamięć przed zapytaniem: 3.561 MB Zwróconych wierszy: 35
SELECT `id`,`name`,`rules`,`parent_id`
FROM `saf6i_assets`
WHERE `name` IN ('root.1','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djcatalog2','com_djmediatools','com_djtabs','com_fields','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | saf6i_assets | range | idx_asset_name | idx_asset_name | 152 | NULL | 37 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.11 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.02 ms |
| table lock | 0.01 ms |
| init | 0.06 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.11 ms |
| Preparing | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.17 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.05 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Wywołujący | Plik i numer linii |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
| 21 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
| 20 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
| 19 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
| 18 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
| 17 | Joomla\CMS\User\User->authorise() | JROOT/components/com_djcatalog2/models/items.php:716 |
| 16 | DJCatalog2ModelItems->_buildContentWhere() | JROOT/components/com_djcatalog2/models/items.php:268 |
| 15 | DJCatalog2ModelItems->buildQuery() | JROOT/components/com_djcatalog2/models/items.php:235 |
| 14 | DJCatalog2ModelItems->getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:133 |
| 13 | Joomla\CMS\MVC\Model\ListModel->_getListQuery() | JROOT/components/com_djcatalog2/models/items.php:215 |
| 12 | DJCatalog2ModelItems->getItems() | JROOT/components/com_djcatalog2/views/items/view.html.php:118 |
| 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:663 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:108 |
| 8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:60 |
| 6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.59 ms Po ostatnim zapytaniu: 0.77 ms Pamięć zapytania: 0.031 MB Pamięć przed zapytaniem: 3.623 MB Zwróconych wierszy: 0
SELECT f.*, g.name as group_name, g.label as group_label, g.id as fgroup_id
FROM saf6i_djc2_items_extra_fields as f
LEFT JOIN saf6i_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 | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | f | ref | idx_published | idx_published | 4 | const | 1 | Using temporary; Uruchomiono metodę filesort |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | bil2013_sch.f.group_id | 1 | |
| Status | Duration |
|---|
| Starting | 0.08 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.03 ms |
| Preparing | 0.02 ms |
| Creating tmp table | 0.06 ms |
| Sorting result | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.07 ms |
| Creating sort index | 0.04 ms |
| Removing tmp table | 0.01 ms |
| Creating sort index | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.05 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Wywołujący | Plik i numer linii |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djcatalog2/models/items.php:877 |
| 16 | DJCatalog2ModelItems->getAttributes() | JROOT/components/com_djcatalog2/models/items.php:270 |
| 15 | DJCatalog2ModelItems->buildQuery() | JROOT/components/com_djcatalog2/models/items.php:235 |
| 14 | DJCatalog2ModelItems->getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:133 |
| 13 | Joomla\CMS\MVC\Model\ListModel->_getListQuery() | JROOT/components/com_djcatalog2/models/items.php:215 |
| 12 | DJCatalog2ModelItems->getItems() | JROOT/components/com_djcatalog2/views/items/view.html.php:118 |
| 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:663 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:108 |
| 8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:60 |
| 6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.36 ms Po ostatnim zapytaniu: 0.03 ms Pamięć zapytania: 0.026 MB Pamięć przed zapytaniem: 3.634 MB Zwróconych wierszy: 0
SELECT o.id, o.field_id
FROM saf6i_djc2_items_extra_fields_options AS o
ORDER BY o.field_id asc, o.ordering asc
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | o | ALL | NULL | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 1 | Uruchomiono metodę filesort |
| Status | Duration |
|---|
| Starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.01 ms |
| Sorting result | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.03 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.04 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Wywołujący | Plik i numer linii |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djcatalog2/models/items.php:887 |
| 16 | DJCatalog2ModelItems->getAttributes() | JROOT/components/com_djcatalog2/models/items.php:270 |
| 15 | DJCatalog2ModelItems->buildQuery() | JROOT/components/com_djcatalog2/models/items.php:235 |
| 14 | DJCatalog2ModelItems->getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:133 |
| 13 | Joomla\CMS\MVC\Model\ListModel->_getListQuery() | JROOT/components/com_djcatalog2/models/items.php:215 |
| 12 | DJCatalog2ModelItems->getItems() | JROOT/components/com_djcatalog2/views/items/view.html.php:118 |
| 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:663 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:108 |
| 8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:60 |
| 6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 1.58 ms Po ostatnim zapytaniu: 0.06 ms Pamięć zapytania: 0.038 MB Pamięć przed zapytaniem: 3.643 MB Zwróconych wierszy: 0
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,countries.country_name,states.name as state_name
FROM saf6i_djc2_items as i
INNER JOIN (SELECT ic.item_id
FROM saf6i_djc2_items_categories AS ic
INNER JOIN saf6i_djc2_categories AS c
ON c.id=ic.category_id
WHERE c.published = 1
AND c.access IN (1,1,5)
AND ic.category_id =12) as category_filter
ON i.id = category_filter.item_id
LEFT JOIN saf6i_djc2_categories AS c
ON c.id = i.cat_id
LEFT JOIN saf6i_djc2_producers AS p
ON p.id = i.producer_id
LEFT JOIN saf6i_users AS ua
ON ua.id = i.created_by
LEFT JOIN saf6i_djc2_countries AS countries
ON countries.id = i.country
LEFT JOIN saf6i_djc2_countries_states AS states
ON states.id = i.state
WHERE (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2023-09-22 02:19:03')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-09-22 02:19:03')
AND i.published = 1
AND i.access IN (1,1,5)
AND i.parent_id=0
ORDER BY i.name asc , i.ordering, c.ordering
LIMIT 10
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | c | const | PRIMARY,idx_published,idx_published_parent_ordering,idx_access | PRIMARY | 4 | const | 1 | Using temporary; Uruchomiono metodę filesort |
| 1 | SIMPLE | ic | ref | PRIMARY,item_category | PRIMARY | 4 | const | 1 | Using index |
| 1 | SIMPLE | i | eq_ref | PRIMARY,idx_parent_id,idx_published,idx_access | PRIMARY | 4 | bil2013_sch.ic.item_id | 1 | Using where |
| 1 | SIMPLE | c | eq_ref | PRIMARY | PRIMARY | 4 | bil2013_sch.i.cat_id | 1 | |
| 1 | SIMPLE | p | eq_ref | PRIMARY | PRIMARY | 4 | bil2013_sch.i.producer_id | 1 | |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | bil2013_sch.i.created_by | 1 | |
| 1 | SIMPLE | countries | eq_ref | PRIMARY | PRIMARY | 2 | bil2013_sch.i.country | 1 | Using where |
| 1 | SIMPLE | states | eq_ref | PRIMARY | PRIMARY | 4 | bil2013_sch.i.state | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.15 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.10 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.23 ms |
| Preparing | 0.01 ms |
| Unlocking tables | 0.01 ms |
| Preparing | 0.04 ms |
| Creating tmp table | 0.07 ms |
| Sorting result | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.41 ms |
| Creating sort index | 0.06 ms |
| Removing tmp table | 0.08 ms |
| Creating sort index | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Removing tmp table | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.05 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Wywołujący | Plik i numer linii |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djcatalog2/models/items.php:199 |
| 13 | DJCatalog2ModelItems->_getList() | JROOT/components/com_djcatalog2/models/items.php:217 |
| 12 | DJCatalog2ModelItems->getItems() | JROOT/components/com_djcatalog2/views/items/view.html.php:118 |
| 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:663 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:108 |
| 8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:60 |
| 6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.68 ms Po ostatnim zapytaniu: 1.47 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 3.669 MB Zwróconych wierszy: 1
SELECT COUNT(distinct (i.id))
FROM saf6i_djc2_items as i
INNER JOIN (SELECT ic.item_id
FROM saf6i_djc2_items_categories AS ic
INNER JOIN saf6i_djc2_categories AS c
ON c.id=ic.category_id
WHERE c.published = 1
AND c.access IN (1,1,5)
AND ic.category_id =12) as category_filter
ON i.id = category_filter.item_id
LEFT JOIN saf6i_djc2_categories AS c
ON c.id = i.cat_id
LEFT JOIN saf6i_djc2_producers AS p
ON p.id = i.producer_id
LEFT JOIN saf6i_users AS ua
ON ua.id = i.created_by
LEFT JOIN saf6i_djc2_countries AS countries
ON countries.id = i.country
LEFT JOIN saf6i_djc2_countries_states AS states
ON states.id = i.state
WHERE (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2023-09-22 02:19:03')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-09-22 02:19:03')
AND i.published = 1
AND i.access IN (1,1,5)
AND i.parent_id=0
LIMIT 10
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | c | const | PRIMARY,idx_published,idx_published_parent_ordering,idx_access | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | ic | ref | PRIMARY,item_category | PRIMARY | 4 | const | 1 | Using index |
| 1 | SIMPLE | i | eq_ref | PRIMARY,idx_parent_id,idx_published,idx_access | PRIMARY | 4 | bil2013_sch.ic.item_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.12 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.08 ms |
| Preparing | 0.01 ms |
| Unlocking tables | 0.01 ms |
| Preparing | 0.05 ms |
| Executing | 0.01 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.02 ms |
| Removing tmp table | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Removing tmp table | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.05 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.02 ms |
| # | Wywołujący | Plik i numer linii |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 15 | JDatabaseDriver->loadResult() | JROOT/components/com_djcatalog2/models/items.php:248 |
| 14 | DJCatalog2ModelItems->_getListCount() | JROOT/libraries/src/MVC/Model/ListModel.php:282 |
| 13 | Joomla\CMS\MVC\Model\ListModel->getTotal() | JROOT/libraries/src/MVC/Model/ListModel.php:232 |
| 12 | Joomla\CMS\MVC\Model\ListModel->getPagination() | JROOT/components/com_djcatalog2/views/items/view.html.php:120 |
| 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:663 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:108 |
| 8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:60 |
| 6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.48 ms Po ostatnim zapytaniu: 2.28 ms Pamięć zapytania: 0.056 MB Pamięć przed zapytaniem: 3.676 MB Zwróconych wierszy: 8
SELECT c.*
FROM saf6i_djc2_categories AS c
WHERE c.published=1
ORDER BY c.parent_id ASC, c.ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | c | ref | idx_published,idx_published_parent_ordering | idx_published_parent_ordering | 4 | const | 8 | Using where |
| Status | Duration |
|---|
| Starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.04 ms |
| Preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.12 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.04 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.02 ms |
| # | Wywołujący | Plik i numer linii |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:298 |
| 15 | Djc2Categories->getCategories() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:169 |
| 14 | Djc2Categories->__construct() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:207 |
| 13 | Djc2Categories::getInstance() | JROOT/components/com_djcatalog2/models/items.php:1039 |
| 12 | DJCatalog2ModelItems->getProducers() | JROOT/components/com_djcatalog2/views/items/view.html.php:168 |
| 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:663 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:108 |
| 8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:60 |
| 6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 1.00 ms Po ostatnim zapytaniu: 0.04 ms Pamięć zapytania: 0.028 MB Pamięć przed zapytaniem: 3.747 MB Zwróconych wierszy: 11
SELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath
FROM saf6i_djc2_categories as i
INNER JOIN saf6i_djc2_images as img
on img.id=(select id
from saf6i_djc2_images
where type='category'
and item_id=i.id
order by ordering asc
limit 1)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | i | index | NULL | idx_parent_id | 4 | NULL | 14 | Using index |
| 1 | PRIMARY | img | eq_ref | PRIMARY | PRIMARY | 4 | func | 1 | Using where |
| 2 | DEPENDENT SUBQUERY | saf6i_djc2_images | ref | idx_type_item,idx_item_type,idx_item_type_ordering | idx_item_type_ordering | 198 | bil2013_sch.i.id,const | 1 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.07 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.02 ms |
| Sorting result | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.05 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Wywołujący | Plik i numer linii |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:305 |
| 15 | Djc2Categories->getCategories() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:169 |
| 14 | Djc2Categories->__construct() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:207 |
| 13 | Djc2Categories::getInstance() | JROOT/components/com_djcatalog2/models/items.php:1039 |
| 12 | DJCatalog2ModelItems->getProducers() | JROOT/components/com_djcatalog2/views/items/view.html.php:168 |
| 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:663 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:108 |
| 8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:60 |
| 6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.73 ms Po ostatnim zapytaniu: 0.09 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 3.769 MB Zwróconych wierszy: 0
SELECT DISTINCT a.id, a.name as text
FROM saf6i_djc2_producers as a
INNER JOIN saf6i_djc2_items AS i
ON a.id = i.producer_id
AND i.published = 1
INNER JOIN saf6i_djc2_items_categories AS c
ON c.item_id = i.id
WHERE c.category_id IN (12,9,15,16,17,19)
AND a.published=1
GROUP BY a.id, a.name
ORDER BY a.name asc
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | ref | PRIMARY,idx_published | idx_published | 4 | const | 2 | Using where; Using temporary; Uruchomiono metodę filesort |
| 1 | SIMPLE | i | ref | PRIMARY,idx_producer_id,idx_published | idx_producer_id | 4 | bil2013_sch.a.id | 3 | Using where |
| 1 | SIMPLE | c | ref | PRIMARY,item_category | item_category | 4 | bil2013_sch.i.id | 1 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.07 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.06 ms |
| Preparing | 0.02 ms |
| Creating tmp table | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.21 ms |
| Creating sort index | 0.04 ms |
| Removing tmp table | 0.01 ms |
| Creating sort index | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.05 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Wywołujący | Plik i numer linii |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djcatalog2/models/items.php:1058 |
| 12 | DJCatalog2ModelItems->getProducers() | JROOT/components/com_djcatalog2/views/items/view.html.php:168 |
| 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:663 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:108 |
| 8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:60 |
| 6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.55 ms Po ostatnim zapytaniu: 10.31 ms Pamięć zapytania: 0.029 MB Pamięć przed zapytaniem: 3.880 MB Zwróconych wierszy: 0
SELECT f.*, g.name as group_name, g.label as group_label, g.id as fgroup_id
FROM saf6i_djc2_items_extra_fields as f
LEFT JOIN saf6i_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 | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | f | ref | idx_published | idx_published | 4 | const | 1 | Using where; Using temporary; Uruchomiono metodę filesort |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | bil2013_sch.f.group_id | 1 | |
| Status | Duration |
|---|
| Starting | 0.09 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.03 ms |
| Preparing | 0.02 ms |
| Creating tmp table | 0.05 ms |
| Sorting result | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.04 ms |
| Creating sort index | 0.03 ms |
| Removing tmp table | 0.01 ms |
| Creating sort index | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.04 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Wywołujący | Plik i numer linii |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djcatalog2/models/items.php:877 |
| 12 | DJCatalog2ModelItems->getAttributes() | JROOT/components/com_djcatalog2/views/items/view.html.php:210 |
| 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:663 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:108 |
| 8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:60 |
| 6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.30 ms Po ostatnim zapytaniu: 0.02 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 3.889 MB Zwróconych wierszy: 0
SELECT o.id, o.field_id
FROM saf6i_djc2_items_extra_fields_options AS o
ORDER BY o.field_id asc, o.ordering asc
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | o | ALL | NULL | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 1 | Uruchomiono metodę filesort |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Sorting result | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.03 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Wywołujący | Plik i numer linii |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djcatalog2/models/items.php:887 |
| 12 | DJCatalog2ModelItems->getAttributes() | JROOT/components/com_djcatalog2/views/items/view.html.php:210 |
| 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:663 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:108 |
| 8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:60 |
| 6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.44 ms Po ostatnim zapytaniu: 0.12 ms Pamięć zapytania: 0.057 MB Pamięć przed zapytaniem: 3.895 MB Zwróconych wierszy: 8
SELECT c.*
FROM saf6i_djc2_categories AS c
WHERE c.published=1
AND c.access IN (1,1,5)
ORDER BY c.parent_id ASC, c.ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | c | ref | idx_published,idx_published_parent_ordering,idx_access | idx_published_parent_ordering | 4 | const | 8 | Using where |
| Status | Duration |
|---|
| Starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.05 ms |
| Preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.10 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Wywołujący | Plik i numer linii |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:298 |
| 17 | Djc2Categories->getCategories() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:169 |
| 16 | Djc2Categories->__construct() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:207 |
| 15 | Djc2Categories::getInstance() | JROOT/components/com_djcatalog2/models/items.php:731 |
| 14 | DJCatalog2ModelItems->_buildContentWhere() | JROOT/components/com_djcatalog2/models/items.php:268 |
| 13 | DJCatalog2ModelItems->buildQuery() | JROOT/components/com_djcatalog2/models/items.php:1265 |
| 12 | DJCatalog2ModelItems->getFieldGroups() | JROOT/components/com_djcatalog2/views/items/view.html.php:211 |
| 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:663 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:108 |
| 8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:60 |
| 6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.85 ms Po ostatnim zapytaniu: 0.04 ms Pamięć zapytania: 0.028 MB Pamięć przed zapytaniem: 3.967 MB Zwróconych wierszy: 11
SELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath
FROM saf6i_djc2_categories as i
INNER JOIN saf6i_djc2_images as img
on img.id=(select id
from saf6i_djc2_images
where type='category'
and item_id=i.id
order by ordering asc
limit 1)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | i | index | NULL | idx_parent_id | 4 | NULL | 14 | Using index |
| 1 | PRIMARY | img | eq_ref | PRIMARY | PRIMARY | 4 | func | 1 | Using where |
| 2 | DEPENDENT SUBQUERY | saf6i_djc2_images | ref | idx_type_item,idx_item_type,idx_item_type_ordering | idx_item_type_ordering | 198 | bil2013_sch.i.id,const | 1 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.01 ms |
| Sorting result | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.04 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Wywołujący | Plik i numer linii |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:305 |
| 17 | Djc2Categories->getCategories() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:169 |
| 16 | Djc2Categories->__construct() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:207 |
| 15 | Djc2Categories::getInstance() | JROOT/components/com_djcatalog2/models/items.php:731 |
| 14 | DJCatalog2ModelItems->_buildContentWhere() | JROOT/components/com_djcatalog2/models/items.php:268 |
| 13 | DJCatalog2ModelItems->buildQuery() | JROOT/components/com_djcatalog2/models/items.php:1265 |
| 12 | DJCatalog2ModelItems->getFieldGroups() | JROOT/components/com_djcatalog2/views/items/view.html.php:211 |
| 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:663 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:108 |
| 8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:60 |
| 6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.90 ms Po ostatnim zapytaniu: 0.15 ms Pamięć zapytania: 0.028 MB Pamięć przed zapytaniem: 3.999 MB Zwróconych wierszy: 0
SELECT f.*
FROM saf6i_djc2_items_extra_fields as f
INNER JOIN saf6i_djc2_items_groups as i
on i.group_id = f.group_id
INNER JOIN (
SELECT distinct i.id
FROM saf6i_djc2_items as i
INNER JOIN (SELECT ic.item_id
FROM saf6i_djc2_items_categories AS ic
INNER JOIN saf6i_djc2_categories AS c
ON c.id=ic.category_id
WHERE c.published = 1
AND c.access IN (1,1,5)
AND ic.category_id IN (12,9,15,16,17,19)) as category_filter
ON i.id = category_filter.item_id
LEFT JOIN saf6i_djc2_categories AS c
ON c.id = i.cat_id
LEFT JOIN saf6i_djc2_producers AS p
ON p.id = i.producer_id
LEFT JOIN saf6i_users AS ua
ON ua.id = i.created_by
LEFT JOIN saf6i_djc2_countries AS countries
ON countries.id = i.country
LEFT JOIN saf6i_djc2_countries_states AS states
ON states.id = i.state
WHERE (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2023-09-22 02:19:03')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-09-22 02:19:03')
AND i.published = 1
AND i.access IN (1,1,5)
AND i.parent_id=0
ORDER BY i.id asc , i.ordering, c.ordering ) 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 | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | f | ref | idx_published,idx_separate_column,idx_group_id | idx_published | 4 | const | 1 | Using where; Using temporary; Uruchomiono metodę filesort |
| 1 | PRIMARY | i | ref | PRIMARY,item_group | PRIMARY | 4 | bil2013_sch.f.group_id | 9 | Using index |
| 1 | PRIMARY | <derived2> | ref | key0 | key0 | 4 | bil2013_sch.i.item_id | 1 | |
| 2 | DERIVED | c | range | PRIMARY,idx_published,idx_published_parent_ordering,idx_access | idx_published | 8 | NULL | 6 | Using index condition; Using where; Using temporary; Uruchomiono metodę filesort |
| 2 | DERIVED | ic | ref | PRIMARY,item_category | PRIMARY | 4 | bil2013_sch.c.id | 1 | Using index |
| 2 | DERIVED | i | eq_ref | PRIMARY,idx_parent_id,idx_published,idx_access | PRIMARY | 4 | bil2013_sch.ic.item_id | 1 | Using where |
| 2 | DERIVED | c | eq_ref | PRIMARY | PRIMARY | 4 | bil2013_sch.i.cat_id | 1 | |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.07 ms |
| Optimizing | 0.02 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.14 ms |
| Preparing | 0.03 ms |
| Creating tmp table | 0.02 ms |
| Sorting result | 0.01 ms |
| Statistics | 0.04 ms |
| Preparing | 0.02 ms |
| Creating tmp table | 0.03 ms |
| Sorting result | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.04 ms |
| Creating sort index | 0.03 ms |
| Removing tmp table | 0.01 ms |
| Creating sort index | 0.01 ms |
| Removing tmp table | 0.01 ms |
| Creating sort index | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Removing tmp table | 0.01 ms |
| closing tables | 0.01 ms |
| Removing tmp table | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.04 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.02 ms |
| # | Wywołujący | Plik i numer linii |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djcatalog2/models/items.php:1277 |
| 12 | DJCatalog2ModelItems->getFieldGroups() | JROOT/components/com_djcatalog2/views/items/view.html.php:211 |
| 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:663 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:108 |
| 8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:60 |
| 6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.85 ms Po ostatnim zapytaniu: 0.12 ms Pamięć zapytania: 0.028 MB Pamięć przed zapytaniem: 4.007 MB Zwróconych wierszy: 0
SELECT f.*
FROM saf6i_djc2_items_extra_fields as f
INNER JOIN saf6i_djc2_items_groups as i
on i.group_id = f.group_id
INNER JOIN (
SELECT distinct i.id
FROM saf6i_djc2_items as i
INNER JOIN (SELECT ic.item_id
FROM saf6i_djc2_items_categories AS ic
INNER JOIN saf6i_djc2_categories AS c
ON c.id=ic.category_id
WHERE c.published = 1
AND c.access IN (1,1,5)
AND ic.category_id IN (12,9,15,16,17,19)) as category_filter
ON i.id = category_filter.item_id
LEFT JOIN saf6i_djc2_categories AS c
ON c.id = i.cat_id
LEFT JOIN saf6i_djc2_producers AS p
ON p.id = i.producer_id
LEFT JOIN saf6i_users AS ua
ON ua.id = i.created_by
LEFT JOIN saf6i_djc2_countries AS countries
ON countries.id = i.country
LEFT JOIN saf6i_djc2_countries_states AS states
ON states.id = i.state
WHERE (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2023-09-22 02:19:03')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-09-22 02:19:03')
AND i.published = 1
AND i.access IN (1,1,5)
AND i.parent_id=0
ORDER BY i.id asc , i.ordering, c.ordering ) 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 | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | f | ref | idx_published,idx_type,idx_group_id | idx_published | 4 | const | 1 | Using where; Using temporary; Uruchomiono metodę filesort |
| 1 | PRIMARY | i | ref | PRIMARY,item_group | PRIMARY | 4 | bil2013_sch.f.group_id | 9 | Using index |
| 1 | PRIMARY | <derived2> | ref | key0 | key0 | 4 | bil2013_sch.i.item_id | 1 | |
| 2 | DERIVED | c | range | PRIMARY,idx_published,idx_published_parent_ordering,idx_access | idx_published | 8 | NULL | 6 | Using index condition; Using where; Using temporary; Uruchomiono metodę filesort |
| 2 | DERIVED | ic | ref | PRIMARY,item_category | PRIMARY | 4 | bil2013_sch.c.id | 1 | Using index |
| 2 | DERIVED | i | eq_ref | PRIMARY,idx_parent_id,idx_published,idx_access | PRIMARY | 4 | bil2013_sch.ic.item_id | 1 | Using where |
| 2 | DERIVED | c | eq_ref | PRIMARY | PRIMARY | 4 | bil2013_sch.i.cat_id | 1 | |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.06 ms |
| Optimizing | 0.02 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.15 ms |
| Preparing | 0.03 ms |
| Creating tmp table | 0.01 ms |
| Sorting result | 0.01 ms |
| Statistics | 0.04 ms |
| Preparing | 0.03 ms |
| Creating tmp table | 0.03 ms |
| Sorting result | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.02 ms |
| Creating sort index | 0.03 ms |
| Removing tmp table | 0.01 ms |
| Creating sort index | 0.01 ms |
| Removing tmp table | 0.01 ms |
| Creating sort index | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Removing tmp table | 0.01 ms |
| closing tables | 0.01 ms |
| Removing tmp table | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.04 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.02 ms |
| # | Wywołujący | Plik i numer linii |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djcatalog2/models/items.php:1317 |
| 12 | DJCatalog2ModelItems->getSortables() | JROOT/components/com_djcatalog2/views/items/view.html.php:212 |
| 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:663 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:108 |
| 8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:60 |
| 6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.40 ms Po ostatnim zapytaniu: 5.31 ms Pamięć zapytania: 0.027 MB Pamięć przed zapytaniem: 4.143 MB Zwróconych wierszy: 0
SELECT *
FROM saf6i_djc2_images
WHERE item_id=12
AND type='category'
AND exclude=0
ORDER BY ordering ASC, name ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | saf6i_djc2_images | ref | idx_type_item,idx_item_type,idx_item_type_ordering | idx_type_item | 198 | const,const | 1 | Using index condition; Using where; Uruchomiono metodę filesort |
| Status | Duration |
|---|
| Starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.04 ms |
| Preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.02 ms |
| Creating sort index | 0.03 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.02 ms |
| # | Wywołujący | Plik i numer linii |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djcatalog2/helpers/image.php:93 |
| 13 | DJCatalog2ImageHelper::getImages() | JROOT/components/com_djcatalog2/views/items/view.html.php:396 |
| 12 | DJCatalog2ViewItems->_prepareDocument() | JROOT/components/com_djcatalog2/views/items/view.html.php:213 |
| 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:663 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:108 |
| 8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:60 |
| 6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.40 ms Po ostatnim zapytaniu: 3.76 ms Pamięć zapytania: 0.032 MB Pamięć przed zapytaniem: 4.254 MB Zwróconych wierszy: 0
SELECT f.*, g.name as group_name, g.label as group_label
FROM saf6i_djc2_items_extra_fields as f
LEFT JOIN saf6i_djc2_items_extra_fields_groups as g
ON g.id=f.group_id
WHERE f.published = 1
and f.filterable = 1
and (f.type = 'checkbox' or f.type = 'radio' or f.type = 'select' or f.type = 'text')
and (g.id in (1))
GROUP BY f.id
ORDER BY IFNULL(g.ordering,0) asc, g.ordering asc, f.ordering asc
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.08 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.05 ms |
| Preparing | 0.01 ms |
| Executing | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Wywołujący | Plik i numer linii |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/modules/mod_djc2filters/helper.php:179 |
| 18 | DJC2FiltersModuleHelper::getAttributes() | JROOT/modules/mod_djc2filters/helper.php:42 |
| 17 | DJC2FiltersModuleHelper::getData() | JROOT/modules/mod_djc2filters/mod_djc2filters.php:64 |
| 16 | include JROOT/modules/mod_djc2filters/mod_djc2filters.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 15 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/components/com_djcatalog2/views/items/tmpl/default.php:35 |
| 14 | include JROOT/components/com_djcatalog2/views/items/tmpl/default.php | JROOT/libraries/src/MVC/View/HtmlView.php:695 |
| 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:215 |
| 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:663 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:108 |
| 8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:60 |
| 6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.87 ms Po ostatnim zapytaniu: 0.22 ms Pamięć zapytania: 0.028 MB Pamięć przed zapytaniem: 4.296 MB Zwróconych wierszy: 0
SELECT ef.id as field_id, ef.name as field_name, opt.id as option_id, opt.value as option_value, count(fv.item_id) as item_count
FROM saf6i_djc2_items_extra_fields_values_int as fv
INNER JOIN saf6i_djc2_items_extra_fields as ef
on ef.id=fv.field_id
INNER JOIN saf6i_djc2_items_extra_fields_options as opt
on opt.field_id=ef.id
and opt.id=fv.value
INNER JOIN (
SELECT distinct i.id
FROM saf6i_djc2_items as i
INNER JOIN (SELECT ic.item_id
FROM saf6i_djc2_items_categories AS ic
INNER JOIN saf6i_djc2_categories AS c
ON c.id=ic.category_id
WHERE c.published = 1
AND c.access IN (1,1,5)
AND ic.category_id IN (12,9,15,16,17,19)) as category_filter
ON i.id = category_filter.item_id
LEFT JOIN saf6i_djc2_categories AS c
ON c.id = i.cat_id
LEFT JOIN saf6i_djc2_producers AS p
ON p.id = i.producer_id
LEFT JOIN saf6i_users AS ua
ON ua.id = i.created_by
LEFT JOIN saf6i_djc2_countries AS countries
ON countries.id = i.country
LEFT JOIN saf6i_djc2_countries_states AS states
ON states.id = i.state
WHERE (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2023-09-22 02:19:03')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-09-22 02:19:03')
AND i.published = 1
AND i.access IN (1,1,5)
AND i.parent_id=0
ORDER BY i.id asc , i.ordering, c.ordering ) as item_ids
on fv.item_id = item_ids.id
GROUP BY ef.id, opt.value
ORDER BY ef.name asc
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | fv | ALL | idx_item_field,idx_value | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 1 | Using temporary; Uruchomiono metodę filesort |
| 1 | PRIMARY | ef | eq_ref | PRIMARY | PRIMARY | 4 | bil2013_sch.fv.field_id | 1 | |
| 1 | PRIMARY | opt | eq_ref | PRIMARY,idx_field_id | PRIMARY | 4 | bil2013_sch.fv.value | 1 | Using where |
| 1 | PRIMARY | <derived2> | ref | key0 | key0 | 4 | bil2013_sch.fv.item_id | 1 | |
| 2 | DERIVED | c | range | PRIMARY,idx_published,idx_published_parent_ordering,idx_access | idx_published | 8 | NULL | 6 | Using index condition; Using where; Using temporary; Uruchomiono metodę filesort |
| 2 | DERIVED | ic | ref | PRIMARY,item_category | PRIMARY | 4 | bil2013_sch.c.id | 1 | Using index |
| 2 | DERIVED | i | eq_ref | PRIMARY,idx_parent_id,idx_published,idx_access | PRIMARY | 4 | bil2013_sch.ic.item_id | 1 | Using where |
| 2 | DERIVED | c | eq_ref | PRIMARY | PRIMARY | 4 | bil2013_sch.i.cat_id | 1 | |
| Status | Duration |
|---|
| Starting | 0.11 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.06 ms |
| Optimizing | 0.02 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.12 ms |
| Preparing | 0.04 ms |
| Creating tmp table | 0.02 ms |
| Sorting result | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.02 ms |
| Creating tmp table | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.03 ms |
| Creating sort index | 0.04 ms |
| Removing tmp table | 0.01 ms |
| Creating sort index | 0.01 ms |
| Removing tmp table | 0.01 ms |
| Creating sort index | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Removing tmp table | 0.01 ms |
| closing tables | 0.01 ms |
| Removing tmp table | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.04 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.02 ms |
| # | Wywołujący | Plik i numer linii |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/modules/mod_djc2filters/helper.php:357 |
| 18 | DJC2FiltersModuleHelper::getCountersApprox() | JROOT/modules/mod_djc2filters/helper.php:43 |
| 17 | DJC2FiltersModuleHelper::getData() | JROOT/modules/mod_djc2filters/mod_djc2filters.php:64 |
| 16 | include JROOT/modules/mod_djc2filters/mod_djc2filters.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 15 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/components/com_djcatalog2/views/items/tmpl/default.php:35 |
| 14 | include JROOT/components/com_djcatalog2/views/items/tmpl/default.php | JROOT/libraries/src/MVC/View/HtmlView.php:695 |
| 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:215 |
| 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:663 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:108 |
| 8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:60 |
| 6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.78 ms Po ostatnim zapytaniu: 0.03 ms Pamięć zapytania: 0.028 MB Pamięć przed zapytaniem: 4.307 MB Zwróconych wierszy: 0
SELECT ef.id as field_id, ef.name as field_name, "" as option_id, "" as option_value, count(fv.item_id) as item_count
FROM saf6i_djc2_items_extra_fields_values_text as fv
INNER JOIN saf6i_djc2_items_extra_fields as ef
on ef.id=fv.field_id
AND ef.filterable = 1
INNER JOIN (
SELECT distinct i.id
FROM saf6i_djc2_items as i
INNER JOIN (SELECT ic.item_id
FROM saf6i_djc2_items_categories AS ic
INNER JOIN saf6i_djc2_categories AS c
ON c.id=ic.category_id
WHERE c.published = 1
AND c.access IN (1,1,5)
AND ic.category_id IN (12,9,15,16,17,19)) as category_filter
ON i.id = category_filter.item_id
LEFT JOIN saf6i_djc2_categories AS c
ON c.id = i.cat_id
LEFT JOIN saf6i_djc2_producers AS p
ON p.id = i.producer_id
LEFT JOIN saf6i_users AS ua
ON ua.id = i.created_by
LEFT JOIN saf6i_djc2_countries AS countries
ON countries.id = i.country
LEFT JOIN saf6i_djc2_countries_states AS states
ON states.id = i.state
WHERE (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2023-09-22 02:19:03')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-09-22 02:19:03')
AND i.published = 1
AND i.access IN (1,1,5)
AND i.parent_id=0
ORDER BY i.id asc , i.ordering, c.ordering ) as item_ids
on fv.item_id = item_ids.id
GROUP BY ef.id
ORDER BY ef.name asc
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | fv | index | idx_item_field | idx_item_field | 8 | NULL | 1 | Using index; Using temporary; Uruchomiono metodę filesort |
| 1 | PRIMARY | ef | eq_ref | PRIMARY,idx_filterable | PRIMARY | 4 | bil2013_sch.fv.field_id | 1 | Using where |
| 1 | PRIMARY | <derived2> | ref | key0 | key0 | 4 | bil2013_sch.fv.item_id | 1 | |
| 2 | DERIVED | c | range | PRIMARY,idx_published,idx_published_parent_ordering,idx_access | idx_published | 8 | NULL | 6 | Using index condition; Using where; Using temporary; Uruchomiono metodę filesort |
| 2 | DERIVED | ic | ref | PRIMARY,item_category | PRIMARY | 4 | bil2013_sch.c.id | 1 | Using index |
| 2 | DERIVED | i | eq_ref | PRIMARY,idx_parent_id,idx_published,idx_access | PRIMARY | 4 | bil2013_sch.ic.item_id | 1 | Using where |
| 2 | DERIVED | c | eq_ref | PRIMARY | PRIMARY | 4 | bil2013_sch.i.cat_id | 1 | |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.05 ms |
| Optimizing | 0.02 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.11 ms |
| Preparing | 0.03 ms |
| Creating tmp table | 0.01 ms |
| Sorting result | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.02 ms |
| Creating tmp table | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.03 ms |
| Creating sort index | 0.02 ms |
| Removing tmp table | 0.01 ms |
| Creating sort index | 0.01 ms |
| Removing tmp table | 0.01 ms |
| Creating sort index | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Removing tmp table | 0.01 ms |
| closing tables | 0.01 ms |
| Removing tmp table | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.04 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Wywołujący | Plik i numer linii |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/modules/mod_djc2filters/helper.php:368 |
| 18 | DJC2FiltersModuleHelper::getCountersApprox() | JROOT/modules/mod_djc2filters/helper.php:43 |
| 17 | DJC2FiltersModuleHelper::getData() | JROOT/modules/mod_djc2filters/mod_djc2filters.php:64 |
| 16 | include JROOT/modules/mod_djc2filters/mod_djc2filters.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 15 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/components/com_djcatalog2/views/items/tmpl/default.php:35 |
| 14 | include JROOT/components/com_djcatalog2/views/items/tmpl/default.php | JROOT/libraries/src/MVC/View/HtmlView.php:695 |
| 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:215 |
| 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:663 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:108 |
| 8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:60 |
| 6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Czas zapytania: 0.34 ms Po ostatnim zapytaniu: 7.63 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 4.368 MB Zwróconych wierszy: 8
SELECT id
FROM saf6i_template_styles
ORDER BY id
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | saf6i_template_styles | index | NULL | PRIMARY | 4 | NULL | 8 | Using index |
| Status | Duration |
|---|
| Starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Sorting result | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Wywołujący | Plik i numer linii |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1540 |
| 10 | JDatabaseDriver->loadColumn() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:314 |
| 9 | JMFTemplate->setup() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:126 |
| 8 | JMFTemplate->__construct() | JROOT/templates/jm-apartments/index.php:18 |
| 7 | require JROOT/templates/jm-apartments/index.php | JROOT/libraries/src/Document/HtmlDocument.php:658 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:720 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:535 |
| 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1103 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:273 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
3 × SELECT c.*
FROM saf6i_djc2_categories AS c
3 × SELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath
FROM saf6i_djc2_categories as i
INNER JOIN saf6i_djc2_images as img
on img.id=(select id
from saf6i_djc2_images
2 × SELECT f.*, g.name as group_name, g.label as group_label, g.id as fgroup_id
FROM saf6i_djc2_items_extra_fields as f
LEFT JOIN saf6i_djc2_items_extra_fields_groups as g
ON g.id=f.group_id
2 × SELECT o.id, o.field_id
FROM saf6i_djc2_items_extra_fields_options AS o
2 × SELECT f.*
FROM saf6i_djc2_items_extra_fields as f
INNER JOIN saf6i_djc2_items_groups as i
on i.group_id = f.group_id
INNER JOIN ( SELECT distinct i.id
FROM saf6i_djc2_items as i
INNER JOIN (SELECT ic.item_id
FROM saf6i_djc2_items_categories AS ic
INNER JOIN saf6i_djc2_categories AS c
ON c.id=ic.category_id
1 × SELECT ef.id as field_id, ef.name as field_name, "" as option_id, "" as option_value, count(fv.item_id) as item_count
FROM saf6i_djc2_items_extra_fields_values_text as fv
INNER JOIN saf6i_djc2_items_extra_fields as ef
on ef.id=fv.field_id
AND ef.filterable = 1
INNER JOIN ( SELECT distinct i.id
FROM saf6i_djc2_items as i
INNER JOIN (SELECT ic.item_id
FROM saf6i_djc2_items_categories AS ic
INNER JOIN saf6i_djc2_categories AS c
ON c.id=ic.category_id
1 × SELECT ef.id as field_id, ef.name as field_name, opt.id as option_id, opt.value as option_value, count(fv.item_id) as item_count
FROM saf6i_djc2_items_extra_fields_values_int as fv
INNER JOIN saf6i_djc2_items_extra_fields as ef
on ef.id=fv.field_id
INNER JOIN saf6i_djc2_items_extra_fields_options as opt
on opt.field_id=ef.id
and opt.id=fv.value
INNER JOIN ( SELECT distinct i.id
FROM saf6i_djc2_items as i
INNER JOIN (SELECT ic.item_id
FROM saf6i_djc2_items_categories AS ic
INNER JOIN saf6i_djc2_categories AS c
ON c.id=ic.category_id
1 × SELECT f.*, g.name as group_name, g.label as group_label
FROM saf6i_djc2_items_extra_fields as f
LEFT JOIN saf6i_djc2_items_extra_fields_groups as g
ON g.id=f.group_id
1 × SELECT *
FROM saf6i_djc2_images
1 × SELECT DISTINCT a.id, a.name as text
FROM saf6i_djc2_producers as a
INNER JOIN saf6i_djc2_items AS i
ON a.id = i.producer_id
AND i.published = 1
INNER JOIN saf6i_djc2_items_categories AS c
ON c.item_id = i.id
1 × SELECT COUNT(distinct (i.id))
FROM saf6i_djc2_items as i
INNER JOIN (SELECT ic.item_id
FROM saf6i_djc2_items_categories AS ic
INNER JOIN saf6i_djc2_categories AS c
ON c.id=ic.category_id
1 × SELECT `data`
FROM `saf6i_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,countries.country_name,states.name as state_name
FROM saf6i_djc2_items as i
INNER JOIN (SELECT ic.item_id
FROM saf6i_djc2_items_categories AS ic
INNER JOIN saf6i_djc2_categories AS c
ON c.id=ic.category_id
1 × SELECT `session_id`
FROM `saf6i_session`
1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `saf6i_assets`
1 × select alias
from saf6i_djc2_items_extra_fields
1 × SELECT a.id
FROM saf6i_viewlevels AS a
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM saf6i_extensions
1 × SELECT b.id
FROM saf6i_usergroups AS a
LEFT JOIN saf6i_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, rules
FROM `saf6i_viewlevels
1 × SELECT id
FROM saf6i_template_styles
Schischek Polska Sp. z o.o.
Adres biura
