Vreme upita: 0.28 ms Memorija za upit: 0.023 MB memorije pre upita: 1.259 MB Kolona: 0
SELECT `data`
FROM `j17_session`
WHERE `session_id` = 'e0b2399ba92598030fd8652f37f88e81'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | j17_session | const | PRIMARY | PRIMARY | 194 | const | 1 | |
| 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 |
| After opening tables | 0.01 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Poziv | Datoteka i broj linije |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
| 15 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:45 |
| 14 | JSessionStorageDatabase->read() | Isti kao poziv u liniji ispod. |
| 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:758 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
| 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
| 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:344 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Vreme upita: 0.24 ms Nakon poslednjeg upita: 0.52 ms Memorija za upit: 0.020 MB memorije pre upita: 1.274 MB Kolona: 0
SELECT `session_id`
FROM `j17_session`
WHERE `session_id` = 'e0b2399ba92598030fd8652f37f88e81'
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | j17_session | const | PRIMARY | PRIMARY | 194 | const | 1 | Using index |
| Status | Duration |
|---|
| starting | 0.02 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 |
| After opening tables | 0.01 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Poziv | Datoteka i broj linije |
|---|
| 9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
| 8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
| 7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:153 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:760 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
| 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
| 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:344 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Vreme upita: 0.65 ms Nakon poslednjeg upita: 0.11 ms Memorija za upit: 0.004 MB memorije pre upita: 1.280 MB
INSERT INTO `j17_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
('e0b2399ba92598030fd8652f37f88e81', 1, 1642504007, 0, '', 0)
Objašnjenje nije moguće u upitu: INSERT INTO `j17_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
('e0b2399ba92598030fd8652f37f88e81', 1, 1642504007, 0, '', 0)
| Status | Duration |
|---|
| starting | 0.03 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 |
| After opening tables | 0.01 ms |
| init | 0.01 ms |
| update | 0.05 ms |
| Waiting for query cache lock | 0.01 ms |
| update | 0.01 ms |
| end | 0.01 ms |
| query end | 0.42 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Poziv | Datoteka i broj linije |
|---|
| 8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Session/MetadataManager.php:116 |
| 7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:153 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:760 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
| 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
| 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:344 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Vreme upita: 0.48 ms Nakon poslednjeg upita: 1.03 ms Memorija za upit: 0.040 MB memorije pre upita: 1.315 MB Kolona: 41
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `j17_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | j17_extensions | ref | extension | extension | 82 | const | 43 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.03 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 |
| After opening tables | 0.01 ms |
| init | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.04 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.17 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Poziv | Datoteka i broj linije |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Component/ComponentHelper.php:445 |
| 10 | Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() | Isti kao poziv u liniji ispod. |
| 9 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 8 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Component/ComponentHelper.php:453 |
| 7 | Joomla\CMS\Component\ComponentHelper::load() | JROOT/libraries/src/Component/ComponentHelper.php:519 |
| 6 | Joomla\CMS\Component\ComponentHelper::getComponents() | JROOT/libraries/src/Component/ComponentHelper.php:44 |
| 5 | Joomla\CMS\Component\ComponentHelper::getComponent() | JROOT/libraries/src/Component/ComponentHelper.php:103 |
| 4 | Joomla\CMS\Component\ComponentHelper::getParams() | JROOT/libraries/src/Application/SiteApplication.php:594 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Vreme upita: 0.25 ms Nakon poslednjeg upita: 0.99 ms Memorija za upit: 0.021 MB memorije pre upita: 1.431 MB Kolona: 3
SELECT id, rules
FROM `j17_viewlevels`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | j17_viewlevels | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 3 | |
| Status | Duration |
|---|
| starting | 0.02 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 |
| After opening tables | 0.01 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.03 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Poziv | Datoteka i broj linije |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1500 |
| 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:321 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Vreme upita: 0.28 ms Nakon poslednjeg upita: 0.09 ms Memorija za upit: 0.021 MB memorije pre upita: 1.442 MB Kolona: 1
SELECT b.id
FROM j17_usergroups AS a
LEFT JOIN j17_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
| 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 | index | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 8 | NULL | 8 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.01 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 |
| After opening tables | 0.01 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.02 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Poziv | Datoteka i broj linije |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1544 |
| 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:321 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Vreme upita: 0.70 ms Nakon poslednjeg upita: 0.24 ms Memorija za upit: 0.030 MB memorije pre upita: 1.465 MB Kolona: 93
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM j17_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | j17_extensions | ref | extension | extension | 82 | const | 107 | Using index condition; Using where; Using filesort |
| Status | Duration |
|---|
| starting | 0.03 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 |
| After opening tables | 0.01 ms |
| init | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.03 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sorting result | 0.29 ms |
| Sending data | 0.11 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Poziv | Datoteka i broj linije |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php:354 |
| 9 | Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() | Isti kao poziv u liniji ispod. |
| 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:359 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Vreme upita: 0.78 ms Nakon poslednjeg upita: 17.84 ms Memorija za upit: 0.056 MB memorije pre upita: 2.301 MB Kolona: 44
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM j17_menu AS m
LEFT JOIN j17_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 55 | Using index condition; Using where; Using filesort |
| 1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | dmaricn_lovackenovo.m.component_id | 1 | Using where |
| Status | Duration |
|---|
| starting | 0.09 ms |
| checking permissions | 0.01 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 |
| After opening tables | 0.01 ms |
| init | 0.03 ms |
| optimizing | 0.03 ms |
| statistics | 0.05 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| Sorting result | 0.19 ms |
| Sending data | 0.16 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Poziv | Datoteka i broj linije |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
| 17 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | Isti kao poziv u liniji ispod. |
| 16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
| 14 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:76 |
| 13 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
| 12 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:131 |
| 11 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:375 |
| 10 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 |
| 9 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/libraries/src/Router/SiteRouter.php:64 |
| 8 | Joomla\CMS\Router\SiteRouter->__construct() | JROOT/libraries/src/Router/Router.php:189 |
| 7 | Joomla\CMS\Router\Router::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:491 |
| 6 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:403 |
| 5 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/libraries/src/Application/CMSApplication.php:1073 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Vreme upita: 0.49 ms Nakon poslednjeg upita: 4.96 ms Memorija za upit: 0.025 MB memorije pre upita: 2.661 MB Kolona: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `j17_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | j17_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using index condition |
| 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 |
| After opening tables | 0.01 ms |
| init | 0.03 ms |
| optimizing | 0.02 ms |
| statistics | 0.07 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| Sending data | 0.05 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Poziv | Datoteka i broj linije |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1656 |
| 18 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 |
| 17 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | Isti kao poziv u liniji ispod. |
| 16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 |
| 14 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
| 13 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
| 12 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
| 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/k2/k2.php:52 |
| 8 | plgSystemK2->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:1122 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Vreme upita: 0.65 ms Nakon poslednjeg upita: 0.16 ms Memorija za upit: 0.006 MB memorije pre upita: 2.653 MB
UPDATE `j17_extensions`
SET `params` = '{\"mediaversion\":\"af6ce93272228d542516d17e89fbea59\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
Objašnjenje nije moguće u upitu: UPDATE `j17_extensions`
SET `params` = '{\"mediaversion\":\"af6ce93272228d542516d17e89fbea59\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
| Status | Duration |
|---|
| starting | 0.03 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 |
| After opening tables | 0.01 ms |
| init | 0.05 ms |
| updating | 0.05 ms |
| end | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| end | 0.01 ms |
| query end | 0.33 ms |
| closing tables | 0.02 ms |
| freeing items | 0.01 ms |
| updating status | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Poziv | Datoteka i broj linije |
|---|
| 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/k2/k2.php:52 |
| 8 | plgSystemK2->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:1122 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Vreme upita: 0.52 ms Nakon poslednjeg upita: 0.86 ms Memorija za upit: 0.022 MB memorije pre upita: 2.696 MB Kolona: 1
SELECT *
FROM j17_languages
WHERE published=1
ORDER BY ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | j17_languages | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where; Using filesort |
| 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 |
| After opening tables | 0.02 ms |
| init | 0.03 ms |
| optimizing | 0.02 ms |
| statistics | 0.02 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| Sorting result | 0.04 ms |
| Sending data | 0.06 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.01 ms |
| updating status | 0.02 ms |
| cleaning up | 0.02 ms |
| # | Poziv | Datoteka i broj linije |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 |
| 12 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/libraries/src/Application/SiteApplication.php:330 |
| 11 | Joomla\CMS\Application\SiteApplication->getParams() | JROOT/components/com_k2/helpers/utilities.php:315 |
| 10 | K2HelperUtilities::getParams() | JROOT/administrator/components/com_k2/helpers/html.php:56 |
| 9 | K2HelperHTML::loadjQuery() | JROOT/plugins/system/k2/k2.php:55 |
| 8 | plgSystemK2->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:1122 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Vreme upita: 0.43 ms Nakon poslednjeg upita: 1.31 ms Memorija za upit: 0.025 MB memorije pre upita: 2.782 MB Kolona: 3
SELECT id, home, template, s.params
FROM j17_template_styles as s
LEFT JOIN j17_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | ALL | idx_template | NO INDEX KEY COULD BE USED | NULL | NULL | 6 | Using where |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | dmaricn_lovackenovo.s.template,const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.01 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 |
| After opening tables | 0.01 ms |
| init | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.05 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| Sending data | 0.07 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Poziv | Datoteka i broj linije |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:486 |
| 19 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/libraries/src/HTML/HTMLHelper.php:365 |
| 18 | Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles() | JROOT/libraries/src/HTML/HTMLHelper.php:712 |
| 17 | Joomla\CMS\HTML\HTMLHelper::script() | Isti kao poziv u liniji ispod. |
| 16 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
| 15 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:146 |
| 14 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/libraries/cms/html/behavior.php:63 |
| 13 | JHtmlBehavior::framework() | Isti kao poziv u liniji ispod. |
| 12 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
| 11 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:146 |
| 10 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/administrator/components/com_k2/helpers/html.php:76 |
| 9 | K2HelperHTML::loadjQuery() | JROOT/plugins/system/k2/k2.php:55 |
| 8 | plgSystemK2->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:1122 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Vreme upita: 0.48 ms Nakon poslednjeg upita: 8.03 ms Memorija za upit: 0.023 MB memorije pre upita: 3.151 MB Kolona: 1
SELECT s.id, s.template, s.home, s.title AS long_title, s.params
FROM j17_template_styles AS s
WHERE s.client_id = 0
AND s.template = 'g5_hydrogen'
ORDER BY s.id
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | ref | idx_template | idx_template | 202 | const | 1 | Using index condition; Using where |
| 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 |
| After opening tables | 0.01 ms |
| init | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.04 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| Sorting result | 0.01 ms |
| Sending data | 0.05 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Poziv | Datoteka i broj linije |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69 |
| 14 | Gantry\Joomla\StyleHelper::loadStyles() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Assignments.php:63 |
| 13 | Gantry\Framework\Assignments->loadAssignments() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Assignments/AbstractAssignments.php:301 |
| 12 | Gantry\Component\Assignments\AbstractAssignments->init() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Assignments/AbstractAssignments.php:99 |
| 11 | Gantry\Component\Assignments\AbstractAssignments->scores() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Assignments/AbstractAssignments.php:86 |
| 10 | Gantry\Component\Assignments\AbstractAssignments->select() | JROOT/plugins/system/gantry5/gantry5.php:315 |
| 9 | plgSystemGantry5->onAfterRouteSite() | JROOT/plugins/system/gantry5/gantry5.php:108 |
| 8 | plgSystemGantry5->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:1122 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Vreme upita: 0.39 ms Nakon poslednjeg upita: 8.47 ms Memorija za upit: 0.020 MB memorije pre upita: 3.757 MB Kolona: 0
SELECT item_id
FROM j17_djcf_items_promotions
WHERE date_exp <= '2022-01-18 12:06:47'
AND updated=0
GROUP BY item_id
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| 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 |
| After opening tables | 0.01 ms |
| init | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.02 ms |
| end | 0.01 ms |
| query end | 0.02 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Poziv | Datoteka i broj linije |
|---|
| 9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 8 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djpayment.php:890 |
| 7 | DJClassifiedsPayment::updatePromotions() | JROOT/components/com_djclassifieds/djclassifieds.php:103 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Vreme upita: 0.50 ms Nakon poslednjeg upita: 1.26 ms Memorija za upit: 0.025 MB memorije pre upita: 3.791 MB Kolona: 8
SELECT c.*
FROM j17_djcf_categories c
WHERE c.published=1
AND c.access_view IN (1,1)
ORDER BY c.parent_id, c.ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | c | ALL | published | NO INDEX KEY COULD BE USED | NULL | NULL | 9 | Using where; Using filesort |
| 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 |
| After opening tables | 0.01 ms |
| init | 0.03 ms |
| optimizing | 0.02 ms |
| statistics | 0.04 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| Sorting result | 0.05 ms |
| Sending data | 0.07 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.02 ms |
| cleaning up | 0.02 ms |
| # | Poziv | Datoteka i broj linije |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:610 |
| 11 | DJClassifiedsCategory::getCategoriesSortParent() | JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:201 |
| 10 | DJClassifiedsCategory::getSubCatIemsCount() | JROOT/components/com_djclassifieds/views/items/view.html.php:87 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:132 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Vreme upita: 0.37 ms Nakon poslednjeg upita: 0.42 ms Memorija za upit: 0.022 MB memorije pre upita: 3.882 MB Kolona: 0
SELECT ic.cat_id, count(ic.item_id) as items_count
FROM j17_djcf_items_categories ic, j17_djcf_items i
WHERE ic.item_id=i.id
AND i.published=1
AND i.blocked=0
AND i.date_exp > '2022-01-18 12:00:00'
GROUP BY ic.cat_id
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.01 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 |
| After opening tables | 0.01 ms |
| init | 0.03 ms |
| optimizing | 0.02 ms |
| statistics | 0.05 ms |
| preparing | 0.01 ms |
| executing | 0.02 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Poziv | Datoteka i broj linije |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:631 |
| 11 | DJClassifiedsCategory::getCategoriesSortParent() | JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:201 |
| 10 | DJClassifiedsCategory::getSubCatIemsCount() | JROOT/components/com_djclassifieds/views/items/view.html.php:87 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:132 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Vreme upita: 1.49 ms Nakon poslednjeg upita: 0.24 ms Memorija za upit: 0.023 MB memorije pre upita: 3.895 MB Kolona: 0
SELECT i.*, c.name AS c_name,c.alias AS c_alias, c.id as c_id, c.rev_group_id, r.name as r_name, r.id as r_id
FROM j17_djcf_items i
LEFT JOIN j17_djcf_categories c
ON i.cat_id = c.id
LEFT JOIN j17_djcf_regions r
ON i.region_id = r.id
LEFT JOIN j17_users u
ON i.user_id = u.id
LEFT JOIN ( SELECT item_id, count(id) as mcat_c
FROM j17_djcf_items_categories
WHERE cat_id IN (7,7)
GROUP BY item_id ) mc
ON i.id=mc.item_id
WHERE i.date_exp > '2022-01-18 12:06:47'
AND i.published=1
AND i.blocked=0
AND c.published=1
AND (i.cat_id IN (7,7) OR mc.mcat_c>0)
AND c.access_view IN (0,1,1)
ORDER BY i.special DESC, i.date_exp DESC
LIMIT 0, 15
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | r | system | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 0 | const row not found; Using temporary; Using filesort |
| 1 | PRIMARY | <derived2> | system | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 0 | const row not found |
| 1 | PRIMARY | c | range | PRIMARY,published | PRIMARY | 4 | NULL | 1 | Using index condition; Using where |
| 1 | PRIMARY | i | ref | cat_id,published,blocked | cat_id | 4 | dmaricn_lovackenovo.c.id | 7 | Using where |
| 2 | DERIVED | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|
| starting | 0.09 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| Table lock | 0.01 ms |
| After opening tables | 0.01 ms |
| init | 0.07 ms |
| optimizing | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.02 ms |
| executing | 0.03 ms |
| statistics | 0.07 ms |
| preparing | 0.04 ms |
| executing | 0.01 ms |
| Copying to tmp table | 0.35 ms |
| Copying to tmp table | 0.28 ms |
| Sorting result | 0.03 ms |
| Sending data | 0.04 ms |
| end | 0.01 ms |
| removing tmp table | 0.08 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| removing tmp table | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.02 ms |
| updating status | 0.02 ms |
| cleaning up | 0.02 ms |
| # | Poziv | Datoteka i broj linije |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
| 11 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/components/com_djclassifieds/models/items.php:348 |
| 10 | DjclassifiedsModelItems->getItems() | JROOT/components/com_djclassifieds/views/items/view.html.php:109 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:132 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Vreme upita: 0.86 ms Nakon poslednjeg upita: 0.13 ms Memorija za upit: 0.022 MB memorije pre upita: 3.902 MB Kolona: 1
SELECT count(i.id)
FROM (SELECT i.id
FROM j17_djcf_items i
LEFT JOIN j17_djcf_categories c
ON i.cat_id = c.id
LEFT JOIN j17_djcf_regions r
ON i.region_id = r.id
LEFT JOIN j17_users u
ON i.user_id = u.id
LEFT JOIN ( SELECT item_id, count(id) as mcat_c
FROM j17_djcf_items_categories
WHERE cat_id IN (7,7)
GROUP BY item_id ) mc
ON i.id=mc.item_id
WHERE i.date_exp > '2022-01-18 12:06:47'
AND i.published=1
AND i.blocked=0
AND c.published=1
AND (i.cat_id IN (7,7) OR mc.mcat_c>0)
AND c.access_view IN (0,1,1) ) as i
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | r | system | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 0 | const row not found |
| 1 | PRIMARY | <derived3> | system | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 0 | const row not found |
| 1 | PRIMARY | c | range | PRIMARY,published | PRIMARY | 4 | NULL | 1 | Using index condition; Using where |
| 1 | PRIMARY | i | ref | cat_id,published,blocked | cat_id | 4 | dmaricn_lovackenovo.c.id | 7 | Using where |
| 3 | DERIVED | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|
| starting | 0.07 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.02 ms |
| Table lock | 0.01 ms |
| After opening tables | 0.01 ms |
| init | 0.05 ms |
| optimizing | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.05 ms |
| statistics | 0.06 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| Sending data | 0.24 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| removing tmp table | 0.01 ms |
| closing tables | 0.01 ms |
| removing tmp table | 0.02 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Poziv | Datoteka i broj linije |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
| 11 | JDatabaseDriver->loadResult() | JROOT/components/com_djclassifieds/models/items.php:724 |
| 10 | DjclassifiedsModelItems->getCountItems() | JROOT/components/com_djclassifieds/views/items/view.html.php:110 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:132 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Vreme upita: 0.32 ms Nakon poslednjeg upita: 0.07 ms Memorija za upit: 0.022 MB memorije pre upita: 3.906 MB Kolona: 1
SELECT *
FROM j17_djcf_categories
WHERE id=7
AND access_view IN (1,1)
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | j17_djcf_categories | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| starting | 0.03 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 |
| After opening tables | 0.01 ms |
| init | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.03 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.03 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Poziv | Datoteka i broj linije |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1656 |
| 11 | JDatabaseDriver->loadObject() | JROOT/components/com_djclassifieds/models/items.php:756 |
| 10 | DjclassifiedsModelItems->getMainCat() | JROOT/components/com_djclassifieds/views/items/view.html.php:138 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:132 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Vreme upita: 0.48 ms Nakon poslednjeg upita: 0.65 ms Memorija za upit: 0.025 MB memorije pre upita: 3.922 MB Kolona: 8
SELECT c.*
FROM j17_djcf_categories c
WHERE c.published=1
AND c.access_view IN (1,1)
ORDER BY c.parent_id, c.ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | c | ALL | published | NO INDEX KEY COULD BE USED | NULL | NULL | 9 | Using where; Using filesort |
| Status | Duration |
|---|
| starting | 0.03 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 |
| After opening tables | 0.01 ms |
| init | 0.03 ms |
| optimizing | 0.02 ms |
| statistics | 0.03 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| Sorting result | 0.03 ms |
| Sending data | 0.08 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.03 ms |
| cleaning up | 0.01 ms |
| # | Poziv | Datoteka i broj linije |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:469 |
| 12 | DJClassifiedsCategory::getCategories() | JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:285 |
| 11 | DJClassifiedsCategory::getSEOParentPath() | JROOT/administrator/components/com_djclassifieds/lib/djseo.php:132 |
| 10 | DJClassifiedsSEO::getCategoryRoute() | JROOT/components/com_djclassifieds/views/items/view.html.php:285 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:132 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Vreme upita: 0.35 ms Nakon poslednjeg upita: 0.06 ms Memorija za upit: 0.022 MB memorije pre upita: 3.941 MB Kolona: 0
SELECT ic.cat_id, count(ic.item_id) as items_count
FROM j17_djcf_items_categories ic, j17_djcf_items i
WHERE ic.item_id=i.id
AND i.published=1
AND i.blocked=0
AND i.date_exp > '2022-01-18 12:00:00'
GROUP BY ic.cat_id
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.01 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 |
| After opening tables | 0.02 ms |
| init | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.04 ms |
| preparing | 0.01 ms |
| executing | 0.02 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Poziv | Datoteka i broj linije |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:488 |
| 12 | DJClassifiedsCategory::getCategories() | JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:285 |
| 11 | DJClassifiedsCategory::getSEOParentPath() | JROOT/administrator/components/com_djclassifieds/lib/djseo.php:132 |
| 10 | DJClassifiedsSEO::getCategoryRoute() | JROOT/components/com_djclassifieds/views/items/view.html.php:285 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:132 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Vreme upita: 0.42 ms Nakon poslednjeg upita: 0.63 ms Memorija za upit: 0.022 MB memorije pre upita: 3.954 MB Kolona: 0
SELECT *
FROM j17_djcf_fields
WHERE published=1
AND (in_table>0 OR in_blog=1)
ORDER BY name
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | j17_djcf_fields | ref | published | published | 4 | const | 2 | Using where; Using filesort |
| Status | Duration |
|---|
| starting | 0.03 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 |
| After opening tables | 0.01 ms |
| init | 0.03 ms |
| optimizing | 0.02 ms |
| statistics | 0.03 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sorting result | 0.04 ms |
| Sending data | 0.03 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Poziv | Datoteka i broj linije |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djclassifieds/models/items.php:1092 |
| 10 | DjclassifiedsModelItems->getCustomFields() | JROOT/components/com_djclassifieds/views/items/view.html.php:346 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:132 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Vreme upita: 0.37 ms Nakon poslednjeg upita: 0.19 ms Memorija za upit: 0.026 MB memorije pre upita: 3.961 MB Kolona: 9
SELECT c.*
FROM j17_djcf_categories c
ORDER BY c.parent_id, c.ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | c | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 9 | Using filesort |
| Status | Duration |
|---|
| starting | 0.03 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 |
| After opening tables | 0.01 ms |
| init | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sorting result | 0.03 ms |
| Sending data | 0.06 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Poziv | Datoteka i broj linije |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:469 |
| 10 | DJClassifiedsCategory::getCategories() | JROOT/components/com_djclassifieds/views/items/view.html.php:362 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:132 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Vreme upita: 0.31 ms Nakon poslednjeg upita: 0.06 ms Memorija za upit: 0.021 MB memorije pre upita: 3.981 MB Kolona: 0
SELECT ic.cat_id, count(ic.item_id) as items_count
FROM j17_djcf_items_categories ic, j17_djcf_items i
WHERE ic.item_id=i.id
AND i.published=1
AND i.blocked=0
AND i.date_exp > '2022-01-18 12:00:00'
GROUP BY ic.cat_id
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.01 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 |
| After opening tables | 0.01 ms |
| init | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.04 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Poziv | Datoteka i broj linije |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:488 |
| 10 | DJClassifiedsCategory::getCategories() | JROOT/components/com_djclassifieds/views/items/view.html.php:362 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:132 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Vreme upita: 0.91 ms Nakon poslednjeg upita: 1.15 ms Memorija za upit: 0.027 MB memorije pre upita: 4.060 MB Kolona: 12
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM j17_modules AS m
LEFT JOIN j17_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN j17_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2022-01-18 11:06:47')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-01-18 11:06:47')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 522 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ref | PRIMARY,published,newsfeeds | published | 1 | const | 21 | Using index condition; Using where; Using filesort |
| 1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | dmaricn_lovackenovo.m.id | 1 | Using where; Using index |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | dmaricn_lovackenovo.m.module,const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 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 |
| After opening tables | 0.01 ms |
| init | 0.03 ms |
| optimizing | 0.03 ms |
| statistics | 0.06 ms |
| preparing | 0.05 ms |
| executing | 0.01 ms |
| Sorting result | 0.21 ms |
| Sending data | 0.23 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Poziv | Datoteka i broj linije |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 18 | JDatabaseDriver->loadObjectList() | Isti kao poziv u liniji ispod. |
| 17 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 16 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:432 |
| 15 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:362 |
| 14 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 |
| 13 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/components/com_djclassifieds/views/items/tmpl/default_cat.php:116 |
| 12 | include JROOT/components/com_djclassifieds/views/items/tmpl/default_cat.php | JROOT/libraries/src/MVC/View/HtmlView.php:697 |
| 11 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
| 10 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/components/com_djclassifieds/views/items/view.html.php:426 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:132 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Vreme upita: 0.37 ms Nakon poslednjeg upita: 14.65 ms Memorija za upit: 0.035 MB memorije pre upita: 4.728 MB Kolona: 3
SELECT `a`.`menutype`,`a`.`title`
FROM `j17_menu_types` AS `a`
WHERE `a`.`client_id` = 0
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 3 | Using where |
| 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 |
| After opening tables | 0.01 ms |
| init | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.02 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.04 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Poziv | Datoteka i broj linije |
|---|
| 44 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1500 |
| 43 | JDatabaseDriver->loadAssocList() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:109 |
| 42 | Gantry\Framework\Menu->getMenuOptions() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:86 |
| 41 | Gantry\Framework\Menu->getMenus() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Menu/AbstractMenu.php:273 |
| 40 | Gantry\Component\Menu\AbstractMenu->instance() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 |
| 39 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_hydrogen/twig/20/2071f4c8531132f9c186b2802e1bf1d7b3e1433076930758fb368e90e78537dc.php:32 |
| 38 | __TwigTemplate_7a7c04b7784d03db2316ca1c413a1066d6a9e5be6da01376da918ebd821e1641->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 37 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 36 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/89/89cab3b7f82794ea7e5bc1b2a7d320501c1f255e5f731dc98eb31860810d35f3.php:85 |
| 35 | __TwigTemplate_3bf7e7e65120c3ffaedeba27ca14f795d5e1741736b5513d73d1d75c9cce7d70->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 34 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 33 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:432 |
| 32 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
| 31 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
| 30 | Twig\Environment->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:175 |
| 29 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:825 |
| 28 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:718 |
| 27 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:643 |
| 26 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:468 |
| 22 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:700 |
| 21 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_hydrogen/twig/c4/c43e6df7d3488cf6c992b572b7667791163a650f93625b6362a1d1347073a270.php:47 |
| 20 | __TwigTemplate_32a18d6b73f3f68466b107fbc333ce33be6c6a5a1476f56bb0c2974b891e9b3b->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 19 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 18 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/86/86c497c686427cec7cc1347ed0037951f3303206be29c972c1432a2ae3680338.php:35 |
| 17 | __TwigTemplate_18ced7c049c64bb00cc216eb8b5f05265e45e0c6b4226abf2d565c015333ab96->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 16 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 15 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/49/497811926cefd51a3a841dc52eb2ce6159c53c908a505da54fb0e5da8b4abd94.php:35 |
| 14 | __TwigTemplate_d3a66e30f0688277c24669e78234639217d187eb67156c8465facc1bde1d43f7->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 13 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 12 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:432 |
| 11 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
| 10 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
| 9 | Twig\Environment->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:175 |
| 8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/g5_hydrogen/index.php:35 |
| 7 | require JROOT/templates/g5_hydrogen/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:1030 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Vreme upita: 0.62 ms Nakon poslednjeg upita: 0.29 ms Memorija za upit: 0.038 MB memorije pre upita: 4.820 MB Kolona: 30
SELECT m.id, m.alias, m.path AS route, m.level, m.parent_id
FROM j17_menu AS m
WHERE m.menutype = 'mainmenu'
AND m.parent_id > 0
AND m.client_id = 0
AND m.published >= 0
ORDER BY m.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ref | idx_client_id_parent_id_alias_language,idx_menutype | idx_menutype | 98 | const | 37 | Using index condition; Using where; Using filesort |
| Status | Duration |
|---|
| starting | 0.03 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 |
| After opening tables | 0.01 ms |
| init | 0.03 ms |
| optimizing | 0.02 ms |
| statistics | 0.07 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| Sorting result | 0.19 ms |
| Sending data | 0.07 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Poziv | Datoteka i broj linije |
|---|
| 45 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1500 |
| 44 | JDatabaseDriver->loadAssocList() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:757 |
| 43 | Gantry\Framework\Menu->getMenuItemIds() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:276 |
| 42 | Gantry\Framework\Menu->getItemsFromPlatform() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:719 |
| 41 | Gantry\Framework\Menu->getList() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Menu/AbstractMenu.php:315 |
| 40 | Gantry\Component\Menu\AbstractMenu->instance() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 |
| 39 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_hydrogen/twig/20/2071f4c8531132f9c186b2802e1bf1d7b3e1433076930758fb368e90e78537dc.php:32 |
| 38 | __TwigTemplate_7a7c04b7784d03db2316ca1c413a1066d6a9e5be6da01376da918ebd821e1641->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 37 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 36 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/89/89cab3b7f82794ea7e5bc1b2a7d320501c1f255e5f731dc98eb31860810d35f3.php:85 |
| 35 | __TwigTemplate_3bf7e7e65120c3ffaedeba27ca14f795d5e1741736b5513d73d1d75c9cce7d70->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 34 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 33 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:432 |
| 32 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
| 31 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
| 30 | Twig\Environment->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:175 |
| 29 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:825 |
| 28 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:718 |
| 27 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:643 |
| 26 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:468 |
| 22 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:700 |
| 21 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_hydrogen/twig/c4/c43e6df7d3488cf6c992b572b7667791163a650f93625b6362a1d1347073a270.php:47 |
| 20 | __TwigTemplate_32a18d6b73f3f68466b107fbc333ce33be6c6a5a1476f56bb0c2974b891e9b3b->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 19 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 18 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/86/86c497c686427cec7cc1347ed0037951f3303206be29c972c1432a2ae3680338.php:35 |
| 17 | __TwigTemplate_18ced7c049c64bb00cc216eb8b5f05265e45e0c6b4226abf2d565c015333ab96->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 16 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 15 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/49/497811926cefd51a3a841dc52eb2ce6159c53c908a505da54fb0e5da8b4abd94.php:35 |
| 14 | __TwigTemplate_d3a66e30f0688277c24669e78234639217d187eb67156c8465facc1bde1d43f7->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 13 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 12 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:432 |
| 11 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
| 10 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
| 9 | Twig\Environment->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:175 |
| 8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/g5_hydrogen/index.php:35 |
| 7 | require JROOT/templates/g5_hydrogen/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:1030 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Vreme upita: 0.83 ms Nakon poslednjeg upita: 8.26 ms Memorija za upit: 0.039 MB memorije pre upita: 5.099 MB Kolona: 12
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM j17_modules AS m
LEFT JOIN j17_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN j17_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2022-01-18 11:06:47')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-01-18 11:06:47')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 522 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ref | PRIMARY,published,newsfeeds | published | 1 | const | 21 | Using index condition; Using where; Using filesort |
| 1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | dmaricn_lovackenovo.m.id | 1 | Using where; Using index |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | dmaricn_lovackenovo.m.module,const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| Table lock | 0.01 ms |
| After opening tables | 0.01 ms |
| init | 0.03 ms |
| optimizing | 0.03 ms |
| statistics | 0.07 ms |
| preparing | 0.04 ms |
| executing | 0.01 ms |
| Sorting result | 0.13 ms |
| Sending data | 0.21 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Poziv | Datoteka i broj linije |
|---|
| 52 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 51 | JDatabaseDriver->loadObjectList() | Isti kao poziv u liniji ispod. |
| 50 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 49 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:432 |
| 48 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:404 |
| 47 | Gantry\Framework\Platform->getModuleList() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:394 |
| 46 | Gantry\Framework\Platform->getModule() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:279 |
| 45 | Gantry\Framework\Platform->displayModule() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 |
| 44 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_hydrogen/twig/45/45352a8cc083109749e5ede18e781b75e6bb93acbf09123d10653b1390bf6248.php:43 |
| 43 | __TwigTemplate_b9e35ddf32ea4744ccb671053a945da31cc870af32abf855fc5d3abce1f759f6->block_particle() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:214 |
| 42 | Twig\Template->displayBlock() | JROOT/cache/gantry5/g5_hydrogen/twig/83/831096d1887e9ddcf83905f1c4ff307b9fa8528a8d530b36794ee63ef439d1b7.php:73 |
| 41 | __TwigTemplate_e75433e82790f0952cada3a14651ed35d8582623c54034cade9327f1f96125f6->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 40 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 39 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/45/45352a8cc083109749e5ede18e781b75e6bb93acbf09123d10653b1390bf6248.php:35 |
| 38 | __TwigTemplate_b9e35ddf32ea4744ccb671053a945da31cc870af32abf855fc5d3abce1f759f6->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 37 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 36 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/3b/3b47c348791aabe1d7948ba0911c900b012c9d0665a44058c3268b4208486486.php:53 |
| 35 | __TwigTemplate_08098a182edc9cec17574f3ef7e1acadb36b6f36afd20151e14399b37e9b89fb->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 34 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 33 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:432 |
| 32 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
| 31 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
| 30 | Twig\Environment->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:175 |
| 29 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:825 |
| 28 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:718 |
| 27 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:643 |
| 26 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:468 |
| 22 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:700 |
| 21 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_hydrogen/twig/c4/c43e6df7d3488cf6c992b572b7667791163a650f93625b6362a1d1347073a270.php:47 |
| 20 | __TwigTemplate_32a18d6b73f3f68466b107fbc333ce33be6c6a5a1476f56bb0c2974b891e9b3b->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 19 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 18 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/86/86c497c686427cec7cc1347ed0037951f3303206be29c972c1432a2ae3680338.php:35 |
| 17 | __TwigTemplate_18ced7c049c64bb00cc216eb8b5f05265e45e0c6b4226abf2d565c015333ab96->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 16 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 15 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/49/497811926cefd51a3a841dc52eb2ce6159c53c908a505da54fb0e5da8b4abd94.php:35 |
| 14 | __TwigTemplate_d3a66e30f0688277c24669e78234639217d187eb67156c8465facc1bde1d43f7->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 13 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 12 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:432 |
| 11 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
| 10 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
| 9 | Twig\Environment->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:175 |
| 8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/g5_hydrogen/index.php:35 |
| 7 | require JROOT/templates/g5_hydrogen/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:1030 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Vreme upita: 2.96 ms Nakon poslednjeg upita: 5.06 ms Memorija za upit: 0.062 MB memorije pre upita: 5.212 MB Kolona: 5
SELECT i.*,c.id as c_id, c.name as c_name,c.alias as c_alias,c.icon_url as c_icon_url, r.id as r_id, r.name as r_name
FROM j17_djcf_categories c, j17_djcf_items i
LEFT JOIN ( SELECT COUNT(img.id) as img_c, img.item_id
FROM j17_djcf_images img
WHERE img.type='item'
GROUP BY item_id ) img
ON i.id=img.item_id
LEFT JOIN j17_djcf_regions r
ON r.id=i.region_id
WHERE i.date_exp > '2022-01-18 12:06:47'
AND i.published = 1
AND i.blocked=0
AND c.published = 1
AND i.cat_id=c.id
AND img.img_c>0
AND c.access_view IN (0,1,1)
AND c.restriction_18=0
ORDER BY rand()
limit 5
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | r | system | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 0 | const row not found; Using temporary; Using filesort |
| 1 | PRIMARY | c | range | PRIMARY,published | published | 4 | NULL | 7 | Using index condition; Using where |
| 1 | PRIMARY | i | ref | PRIMARY,cat_id,published,blocked | cat_id | 4 | dmaricn_lovackenovo.c.id | 7 | Using where |
| 1 | PRIMARY | <derived2> | ref | key0 | key0 | 5 | dmaricn_lovackenovo.i.id | 10 | Using where |
| 2 | DERIVED | img | ALL | type | NO INDEX KEY COULD BE USED | NULL | NULL | 541 | Using where; Using temporary; Using filesort |
| Status | Duration |
|---|
| starting | 0.08 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 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 |
| After opening tables | 0.01 ms |
| init | 0.07 ms |
| optimizing | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.06 ms |
| preparing | 0.05 ms |
| statistics | 0.08 ms |
| preparing | 0.04 ms |
| executing | 0.01 ms |
| Copying to tmp table | 0.31 ms |
| Copying to tmp table | 0.21 ms |
| executing | 0.01 ms |
| Copying to tmp table | 0.02 ms |
| Copying to tmp table | 0.34 ms |
| Sorting result | 0.04 ms |
| Sending data | 0.06 ms |
| removing tmp table | 0.05 ms |
| Sending data | 0.94 ms |
| Sorting result | 0.04 ms |
| Sending data | 0.09 ms |
| end | 0.01 ms |
| removing tmp table | 0.08 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| removing tmp table | 0.03 ms |
| closing tables | 0.02 ms |
| freeing items | 0.02 ms |
| updating status | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Poziv | Datoteka i broj linije |
|---|
| 52 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 51 | JDatabaseDriver->loadObjectList() | JROOT/modules/mod_djclassifieds_items/helper.php:267 |
| 50 | modDjClassifiedsItems::getItems() | JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php:50 |
| 49 | include JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 48 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 47 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:294 |
| 46 | Gantry\Framework\Platform->displayModule() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:342 |
| 45 | Gantry\Framework\Platform->displayModules() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 |
| 44 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_hydrogen/twig/fc/fce7f14566477d9e07e75a4d06b566c6c55317f2a19b3b547ca7e3c3d8f33922.php:43 |
| 43 | __TwigTemplate_d6daf405ba3f502ba11eb49ba78ac8defca00af7e4d9b301c97b92d1ff07edb8->block_particle() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:214 |
| 42 | Twig\Template->displayBlock() | JROOT/cache/gantry5/g5_hydrogen/twig/83/831096d1887e9ddcf83905f1c4ff307b9fa8528a8d530b36794ee63ef439d1b7.php:73 |
| 41 | __TwigTemplate_e75433e82790f0952cada3a14651ed35d8582623c54034cade9327f1f96125f6->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 40 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 39 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/fc/fce7f14566477d9e07e75a4d06b566c6c55317f2a19b3b547ca7e3c3d8f33922.php:35 |
| 38 | __TwigTemplate_d6daf405ba3f502ba11eb49ba78ac8defca00af7e4d9b301c97b92d1ff07edb8->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 37 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 36 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/3b/3b47c348791aabe1d7948ba0911c900b012c9d0665a44058c3268b4208486486.php:53 |
| 35 | __TwigTemplate_08098a182edc9cec17574f3ef7e1acadb36b6f36afd20151e14399b37e9b89fb->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 34 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 33 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:432 |
| 32 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
| 31 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
| 30 | Twig\Environment->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:175 |
| 29 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:825 |
| 28 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:718 |
| 27 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:643 |
| 26 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:468 |
| 22 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:700 |
| 21 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_hydrogen/twig/c4/c43e6df7d3488cf6c992b572b7667791163a650f93625b6362a1d1347073a270.php:47 |
| 20 | __TwigTemplate_32a18d6b73f3f68466b107fbc333ce33be6c6a5a1476f56bb0c2974b891e9b3b->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 19 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 18 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/86/86c497c686427cec7cc1347ed0037951f3303206be29c972c1432a2ae3680338.php:35 |
| 17 | __TwigTemplate_18ced7c049c64bb00cc216eb8b5f05265e45e0c6b4226abf2d565c015333ab96->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 16 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 15 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/49/497811926cefd51a3a841dc52eb2ce6159c53c908a505da54fb0e5da8b4abd94.php:35 |
| 14 | __TwigTemplate_d3a66e30f0688277c24669e78234639217d187eb67156c8465facc1bde1d43f7->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 13 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 12 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:432 |
| 11 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
| 10 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
| 9 | Twig\Environment->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:175 |
| 8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/g5_hydrogen/index.php:35 |
| 7 | require JROOT/templates/g5_hydrogen/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:1030 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Vreme upita: 0.60 ms Nakon poslednjeg upita: 0.08 ms Memorija za upit: 0.042 MB memorije pre upita: 5.255 MB Kolona: 20
SELECT img.*
FROM j17_djcf_images img
WHERE img.item_id IN (526,476,529,524,525)
AND img.type='item'
ORDER BY img.item_id, img.ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | img | range | item_id,type | item_id | 4 | NULL | 29 | Using index condition; Using where; Using filesort |
| Status | Duration |
|---|
| starting | 0.03 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 |
| After opening tables | 0.01 ms |
| init | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.07 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sorting result | 0.14 ms |
| Sending data | 0.13 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Poziv | Datoteka i broj linije |
|---|
| 53 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 52 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djimage.php:427 |
| 51 | DJClassifiedsImage::getAdsImages() | JROOT/modules/mod_djclassifieds_items/helper.php:280 |
| 50 | modDjClassifiedsItems::getItems() | JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php:50 |
| 49 | include JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 48 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 47 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:294 |
| 46 | Gantry\Framework\Platform->displayModule() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:342 |
| 45 | Gantry\Framework\Platform->displayModules() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 |
| 44 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_hydrogen/twig/fc/fce7f14566477d9e07e75a4d06b566c6c55317f2a19b3b547ca7e3c3d8f33922.php:43 |
| 43 | __TwigTemplate_d6daf405ba3f502ba11eb49ba78ac8defca00af7e4d9b301c97b92d1ff07edb8->block_particle() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:214 |
| 42 | Twig\Template->displayBlock() | JROOT/cache/gantry5/g5_hydrogen/twig/83/831096d1887e9ddcf83905f1c4ff307b9fa8528a8d530b36794ee63ef439d1b7.php:73 |
| 41 | __TwigTemplate_e75433e82790f0952cada3a14651ed35d8582623c54034cade9327f1f96125f6->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 40 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 39 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/fc/fce7f14566477d9e07e75a4d06b566c6c55317f2a19b3b547ca7e3c3d8f33922.php:35 |
| 38 | __TwigTemplate_d6daf405ba3f502ba11eb49ba78ac8defca00af7e4d9b301c97b92d1ff07edb8->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 37 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 36 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/3b/3b47c348791aabe1d7948ba0911c900b012c9d0665a44058c3268b4208486486.php:53 |
| 35 | __TwigTemplate_08098a182edc9cec17574f3ef7e1acadb36b6f36afd20151e14399b37e9b89fb->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 34 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 33 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:432 |
| 32 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
| 31 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
| 30 | Twig\Environment->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:175 |
| 29 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:825 |
| 28 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:718 |
| 27 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:643 |
| 26 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:468 |
| 22 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:700 |
| 21 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_hydrogen/twig/c4/c43e6df7d3488cf6c992b572b7667791163a650f93625b6362a1d1347073a270.php:47 |
| 20 | __TwigTemplate_32a18d6b73f3f68466b107fbc333ce33be6c6a5a1476f56bb0c2974b891e9b3b->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 19 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 18 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/86/86c497c686427cec7cc1347ed0037951f3303206be29c972c1432a2ae3680338.php:35 |
| 17 | __TwigTemplate_18ced7c049c64bb00cc216eb8b5f05265e45e0c6b4226abf2d565c015333ab96->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 16 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 15 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/49/497811926cefd51a3a841dc52eb2ce6159c53c908a505da54fb0e5da8b4abd94.php:35 |
| 14 | __TwigTemplate_d3a66e30f0688277c24669e78234639217d187eb67156c8465facc1bde1d43f7->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 13 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 12 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:432 |
| 11 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
| 10 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
| 9 | Twig\Environment->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:175 |
| 8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/g5_hydrogen/index.php:35 |
| 7 | require JROOT/templates/g5_hydrogen/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:1030 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Vreme upita: 0.27 ms Nakon poslednjeg upita: 0.11 ms Memorija za upit: 0.039 MB memorije pre upita: 5.332 MB Kolona: 4
SELECT *
FROM j17_djcf_types
WHERE published=1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | j17_djcf_types | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 4 | Using where |
| Status | Duration |
|---|
| starting | 0.02 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 |
| After opening tables | 0.01 ms |
| init | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.03 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Poziv | Datoteka i broj linije |
|---|
| 52 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 51 | JDatabaseDriver->loadObjectList() | JROOT/modules/mod_djclassifieds_items/helper.php:319 |
| 50 | modDjClassifiedsItems::getTypes() | JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php:56 |
| 49 | include JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 48 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 47 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:294 |
| 46 | Gantry\Framework\Platform->displayModule() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:342 |
| 45 | Gantry\Framework\Platform->displayModules() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 |
| 44 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_hydrogen/twig/fc/fce7f14566477d9e07e75a4d06b566c6c55317f2a19b3b547ca7e3c3d8f33922.php:43 |
| 43 | __TwigTemplate_d6daf405ba3f502ba11eb49ba78ac8defca00af7e4d9b301c97b92d1ff07edb8->block_particle() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:214 |
| 42 | Twig\Template->displayBlock() | JROOT/cache/gantry5/g5_hydrogen/twig/83/831096d1887e9ddcf83905f1c4ff307b9fa8528a8d530b36794ee63ef439d1b7.php:73 |
| 41 | __TwigTemplate_e75433e82790f0952cada3a14651ed35d8582623c54034cade9327f1f96125f6->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 40 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 39 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/fc/fce7f14566477d9e07e75a4d06b566c6c55317f2a19b3b547ca7e3c3d8f33922.php:35 |
| 38 | __TwigTemplate_d6daf405ba3f502ba11eb49ba78ac8defca00af7e4d9b301c97b92d1ff07edb8->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 37 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 36 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/3b/3b47c348791aabe1d7948ba0911c900b012c9d0665a44058c3268b4208486486.php:53 |
| 35 | __TwigTemplate_08098a182edc9cec17574f3ef7e1acadb36b6f36afd20151e14399b37e9b89fb->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 34 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 33 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:432 |
| 32 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
| 31 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
| 30 | Twig\Environment->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:175 |
| 29 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:825 |
| 28 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:718 |
| 27 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:643 |
| 26 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:468 |
| 22 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:700 |
| 21 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_hydrogen/twig/c4/c43e6df7d3488cf6c992b572b7667791163a650f93625b6362a1d1347073a270.php:47 |
| 20 | __TwigTemplate_32a18d6b73f3f68466b107fbc333ce33be6c6a5a1476f56bb0c2974b891e9b3b->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 19 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 18 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/86/86c497c686427cec7cc1347ed0037951f3303206be29c972c1432a2ae3680338.php:35 |
| 17 | __TwigTemplate_18ced7c049c64bb00cc216eb8b5f05265e45e0c6b4226abf2d565c015333ab96->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 16 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 15 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/49/497811926cefd51a3a841dc52eb2ce6159c53c908a505da54fb0e5da8b4abd94.php:35 |
| 14 | __TwigTemplate_d3a66e30f0688277c24669e78234639217d187eb67156c8465facc1bde1d43f7->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 13 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 12 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:432 |
| 11 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
| 10 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
| 9 | Twig\Environment->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:175 |
| 8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/g5_hydrogen/index.php:35 |
| 7 | require JROOT/templates/g5_hydrogen/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:1030 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Vreme upita: 0.26 ms Nakon poslednjeg upita: 0.19 ms Memorija za upit: 0.039 MB memorije pre upita: 5.367 MB Kolona: 0
SELECT r.*
FROM j17_djcf_regions r
ORDER BY r.parent_id, r.name COLLATE utf8_polish_ci
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | r | system | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 0 | const row not found |
| Status | Duration |
|---|
| starting | 0.02 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 |
| After opening tables | 0.01 ms |
| init | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| end | 0.01 ms |
| query end | 0.02 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Poziv | Datoteka i broj linije |
|---|
| 55 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 54 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:432 |
| 53 | DJClassifiedsRegion::getRegions() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:337 |
| 52 | DJClassifiedsRegion::getSEOParentPath() | JROOT/administrator/components/com_djclassifieds/lib/djseo.php:84 |
| 51 | DJClassifiedsSEO::getItemRoute() | JROOT/modules/mod_djclassifieds_items/tmpl/default.php:78 |
| 50 | require JROOT/modules/mod_djclassifieds_items/tmpl/default.php | JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php:86 |
| 49 | include JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 48 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 47 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:294 |
| 46 | Gantry\Framework\Platform->displayModule() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:342 |
| 45 | Gantry\Framework\Platform->displayModules() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 |
| 44 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_hydrogen/twig/fc/fce7f14566477d9e07e75a4d06b566c6c55317f2a19b3b547ca7e3c3d8f33922.php:43 |
| 43 | __TwigTemplate_d6daf405ba3f502ba11eb49ba78ac8defca00af7e4d9b301c97b92d1ff07edb8->block_particle() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:214 |
| 42 | Twig\Template->displayBlock() | JROOT/cache/gantry5/g5_hydrogen/twig/83/831096d1887e9ddcf83905f1c4ff307b9fa8528a8d530b36794ee63ef439d1b7.php:73 |
| 41 | __TwigTemplate_e75433e82790f0952cada3a14651ed35d8582623c54034cade9327f1f96125f6->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 40 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 39 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/fc/fce7f14566477d9e07e75a4d06b566c6c55317f2a19b3b547ca7e3c3d8f33922.php:35 |
| 38 | __TwigTemplate_d6daf405ba3f502ba11eb49ba78ac8defca00af7e4d9b301c97b92d1ff07edb8->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 37 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 36 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/3b/3b47c348791aabe1d7948ba0911c900b012c9d0665a44058c3268b4208486486.php:53 |
| 35 | __TwigTemplate_08098a182edc9cec17574f3ef7e1acadb36b6f36afd20151e14399b37e9b89fb->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 34 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 33 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:432 |
| 32 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
| 31 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
| 30 | Twig\Environment->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:175 |
| 29 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:825 |
| 28 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:718 |
| 27 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:643 |
| 26 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:468 |
| 22 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:700 |
| 21 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_hydrogen/twig/c4/c43e6df7d3488cf6c992b572b7667791163a650f93625b6362a1d1347073a270.php:47 |
| 20 | __TwigTemplate_32a18d6b73f3f68466b107fbc333ce33be6c6a5a1476f56bb0c2974b891e9b3b->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 19 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 18 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/86/86c497c686427cec7cc1347ed0037951f3303206be29c972c1432a2ae3680338.php:35 |
| 17 | __TwigTemplate_18ced7c049c64bb00cc216eb8b5f05265e45e0c6b4226abf2d565c015333ab96->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 16 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 15 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/49/497811926cefd51a3a841dc52eb2ce6159c53c908a505da54fb0e5da8b4abd94.php:35 |
| 14 | __TwigTemplate_d3a66e30f0688277c24669e78234639217d187eb67156c8465facc1bde1d43f7->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 13 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 12 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:432 |
| 11 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
| 10 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
| 9 | Twig\Environment->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:175 |
| 8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/g5_hydrogen/index.php:35 |
| 7 | require JROOT/templates/g5_hydrogen/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:1030 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Vreme upita: 1.35 ms Nakon poslednjeg upita: 0.06 ms Memorija za upit: 0.041 MB memorije pre upita: 5.398 MB Kolona: 1
SELECT i.region_id, count(i.id) as items_count
FROM j17_djcf_items i
WHERE i.published=1
AND i.date_exp > '2022-01-18 12:06:47'
GROUP BY i.region_id
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | i | ref | published | published | 4 | const | 177 | Using where; Using temporary; Using filesort |
| Status | Duration |
|---|
| starting | 0.03 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 |
| After opening tables | 0.01 ms |
| init | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.03 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Copying to tmp table | 0.02 ms |
| Copying to tmp table | 0.96 ms |
| Sorting result | 0.02 ms |
| Sending data | 0.01 ms |
| end | 0.01 ms |
| removing tmp table | 0.03 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Poziv | Datoteka i broj linije |
|---|
| 55 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 54 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:437 |
| 53 | DJClassifiedsRegion::getRegions() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:337 |
| 52 | DJClassifiedsRegion::getSEOParentPath() | JROOT/administrator/components/com_djclassifieds/lib/djseo.php:84 |
| 51 | DJClassifiedsSEO::getItemRoute() | JROOT/modules/mod_djclassifieds_items/tmpl/default.php:78 |
| 50 | require JROOT/modules/mod_djclassifieds_items/tmpl/default.php | JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php:86 |
| 49 | include JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 48 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 47 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:294 |
| 46 | Gantry\Framework\Platform->displayModule() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:342 |
| 45 | Gantry\Framework\Platform->displayModules() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 |
| 44 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_hydrogen/twig/fc/fce7f14566477d9e07e75a4d06b566c6c55317f2a19b3b547ca7e3c3d8f33922.php:43 |
| 43 | __TwigTemplate_d6daf405ba3f502ba11eb49ba78ac8defca00af7e4d9b301c97b92d1ff07edb8->block_particle() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:214 |
| 42 | Twig\Template->displayBlock() | JROOT/cache/gantry5/g5_hydrogen/twig/83/831096d1887e9ddcf83905f1c4ff307b9fa8528a8d530b36794ee63ef439d1b7.php:73 |
| 41 | __TwigTemplate_e75433e82790f0952cada3a14651ed35d8582623c54034cade9327f1f96125f6->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 40 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 39 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/fc/fce7f14566477d9e07e75a4d06b566c6c55317f2a19b3b547ca7e3c3d8f33922.php:35 |
| 38 | __TwigTemplate_d6daf405ba3f502ba11eb49ba78ac8defca00af7e4d9b301c97b92d1ff07edb8->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 37 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 36 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/3b/3b47c348791aabe1d7948ba0911c900b012c9d0665a44058c3268b4208486486.php:53 |
| 35 | __TwigTemplate_08098a182edc9cec17574f3ef7e1acadb36b6f36afd20151e14399b37e9b89fb->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 34 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 33 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:432 |
| 32 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
| 31 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
| 30 | Twig\Environment->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:175 |
| 29 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:825 |
| 28 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:718 |
| 27 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:643 |
| 26 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:468 |
| 22 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:700 |
| 21 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_hydrogen/twig/c4/c43e6df7d3488cf6c992b572b7667791163a650f93625b6362a1d1347073a270.php:47 |
| 20 | __TwigTemplate_32a18d6b73f3f68466b107fbc333ce33be6c6a5a1476f56bb0c2974b891e9b3b->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 19 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 18 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/86/86c497c686427cec7cc1347ed0037951f3303206be29c972c1432a2ae3680338.php:35 |
| 17 | __TwigTemplate_18ced7c049c64bb00cc216eb8b5f05265e45e0c6b4226abf2d565c015333ab96->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 16 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 15 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/49/497811926cefd51a3a841dc52eb2ce6159c53c908a505da54fb0e5da8b4abd94.php:35 |
| 14 | __TwigTemplate_d3a66e30f0688277c24669e78234639217d187eb67156c8465facc1bde1d43f7->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 13 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 12 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:432 |
| 11 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
| 10 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
| 9 | Twig\Environment->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:175 |
| 8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/g5_hydrogen/index.php:35 |
| 7 | require JROOT/templates/g5_hydrogen/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:1030 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Vreme upita: 0.25 ms Nakon poslednjeg upita: 0.19 ms Memorija za upit: 0.039 MB memorije pre upita: 5.424 MB Kolona: 0
SELECT r.*
FROM j17_djcf_regions r
ORDER BY r.parent_id, r.name COLLATE utf8_polish_ci
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | r | system | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 0 | const row not found |
| Status | Duration |
|---|
| starting | 0.03 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 |
| After opening tables | 0.01 ms |
| init | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Poziv | Datoteka i broj linije |
|---|
| 55 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 54 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:432 |
| 53 | DJClassifiedsRegion::getRegions() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:337 |
| 52 | DJClassifiedsRegion::getSEOParentPath() | JROOT/administrator/components/com_djclassifieds/lib/djseo.php:84 |
| 51 | DJClassifiedsSEO::getItemRoute() | JROOT/modules/mod_djclassifieds_items/tmpl/default.php:113 |
| 50 | require JROOT/modules/mod_djclassifieds_items/tmpl/default.php | JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php:86 |
| 49 | include JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 48 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 47 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:294 |
| 46 | Gantry\Framework\Platform->displayModule() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:342 |
| 45 | Gantry\Framework\Platform->displayModules() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 |
| 44 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_hydrogen/twig/fc/fce7f14566477d9e07e75a4d06b566c6c55317f2a19b3b547ca7e3c3d8f33922.php:43 |
| 43 | __TwigTemplate_d6daf405ba3f502ba11eb49ba78ac8defca00af7e4d9b301c97b92d1ff07edb8->block_particle() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:214 |
| 42 | Twig\Template->displayBlock() | JROOT/cache/gantry5/g5_hydrogen/twig/83/831096d1887e9ddcf83905f1c4ff307b9fa8528a8d530b36794ee63ef439d1b7.php:73 |
| 41 | __TwigTemplate_e75433e82790f0952cada3a14651ed35d8582623c54034cade9327f1f96125f6->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 40 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 39 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/fc/fce7f14566477d9e07e75a4d06b566c6c55317f2a19b3b547ca7e3c3d8f33922.php:35 |
| 38 | __TwigTemplate_d6daf405ba3f502ba11eb49ba78ac8defca00af7e4d9b301c97b92d1ff07edb8->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 37 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 36 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/3b/3b47c348791aabe1d7948ba0911c900b012c9d0665a44058c3268b4208486486.php:53 |
| 35 | __TwigTemplate_08098a182edc9cec17574f3ef7e1acadb36b6f36afd20151e14399b37e9b89fb->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 34 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 33 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:432 |
| 32 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
| 31 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
| 30 | Twig\Environment->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:175 |
| 29 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:825 |
| 28 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:718 |
| 27 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:643 |
| 26 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:468 |
| 22 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:700 |
| 21 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_hydrogen/twig/c4/c43e6df7d3488cf6c992b572b7667791163a650f93625b6362a1d1347073a270.php:47 |
| 20 | __TwigTemplate_32a18d6b73f3f68466b107fbc333ce33be6c6a5a1476f56bb0c2974b891e9b3b->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 19 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 18 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/86/86c497c686427cec7cc1347ed0037951f3303206be29c972c1432a2ae3680338.php:35 |
| 17 | __TwigTemplate_18ced7c049c64bb00cc216eb8b5f05265e45e0c6b4226abf2d565c015333ab96->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 16 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 15 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/49/497811926cefd51a3a841dc52eb2ce6159c53c908a505da54fb0e5da8b4abd94.php:35 |
| 14 | __TwigTemplate_d3a66e30f0688277c24669e78234639217d187eb67156c8465facc1bde1d43f7->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 13 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 12 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:432 |
| 11 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
| 10 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
| 9 | Twig\Environment->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:175 |
| 8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/g5_hydrogen/index.php:35 |
| 7 | require JROOT/templates/g5_hydrogen/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:1030 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Vreme upita: 1.30 ms Nakon poslednjeg upita: 0.04 ms Memorija za upit: 0.039 MB memorije pre upita: 5.448 MB Kolona: 1
SELECT i.region_id, count(i.id) as items_count
FROM j17_djcf_items i
WHERE i.published=1
AND i.date_exp > '2022-01-18 12:06:47'
GROUP BY i.region_id
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | i | ref | published | published | 4 | const | 177 | Using where; Using temporary; Using filesort |
| Status | Duration |
|---|
| starting | 0.02 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 |
| After opening tables | 0.01 ms |
| init | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.03 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Copying to tmp table | 0.02 ms |
| Copying to tmp table | 0.95 ms |
| Sorting result | 0.02 ms |
| Sending data | 0.01 ms |
| end | 0.01 ms |
| removing tmp table | 0.03 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Poziv | Datoteka i broj linije |
|---|
| 55 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 54 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:437 |
| 53 | DJClassifiedsRegion::getRegions() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:337 |
| 52 | DJClassifiedsRegion::getSEOParentPath() | JROOT/administrator/components/com_djclassifieds/lib/djseo.php:84 |
| 51 | DJClassifiedsSEO::getItemRoute() | JROOT/modules/mod_djclassifieds_items/tmpl/default.php:113 |
| 50 | require JROOT/modules/mod_djclassifieds_items/tmpl/default.php | JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php:86 |
| 49 | include JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 48 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 47 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:294 |
| 46 | Gantry\Framework\Platform->displayModule() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:342 |
| 45 | Gantry\Framework\Platform->displayModules() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 |
| 44 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_hydrogen/twig/fc/fce7f14566477d9e07e75a4d06b566c6c55317f2a19b3b547ca7e3c3d8f33922.php:43 |
| 43 | __TwigTemplate_d6daf405ba3f502ba11eb49ba78ac8defca00af7e4d9b301c97b92d1ff07edb8->block_particle() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:214 |
| 42 | Twig\Template->displayBlock() | JROOT/cache/gantry5/g5_hydrogen/twig/83/831096d1887e9ddcf83905f1c4ff307b9fa8528a8d530b36794ee63ef439d1b7.php:73 |
| 41 | __TwigTemplate_e75433e82790f0952cada3a14651ed35d8582623c54034cade9327f1f96125f6->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 40 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 39 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/fc/fce7f14566477d9e07e75a4d06b566c6c55317f2a19b3b547ca7e3c3d8f33922.php:35 |
| 38 | __TwigTemplate_d6daf405ba3f502ba11eb49ba78ac8defca00af7e4d9b301c97b92d1ff07edb8->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 37 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 36 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/3b/3b47c348791aabe1d7948ba0911c900b012c9d0665a44058c3268b4208486486.php:53 |
| 35 | __TwigTemplate_08098a182edc9cec17574f3ef7e1acadb36b6f36afd20151e14399b37e9b89fb->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 34 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 33 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:432 |
| 32 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
| 31 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
| 30 | Twig\Environment->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:175 |
| 29 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:825 |
| 28 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:718 |
| 27 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:643 |
| 26 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:468 |
| 22 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:700 |
| 21 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_hydrogen/twig/c4/c43e6df7d3488cf6c992b572b7667791163a650f93625b6362a1d1347073a270.php:47 |
| 20 | __TwigTemplate_32a18d6b73f3f68466b107fbc333ce33be6c6a5a1476f56bb0c2974b891e9b3b->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 19 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 18 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/86/86c497c686427cec7cc1347ed0037951f3303206be29c972c1432a2ae3680338.php:35 |
| 17 | __TwigTemplate_18ced7c049c64bb00cc216eb8b5f05265e45e0c6b4226abf2d565c015333ab96->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 16 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 15 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/49/497811926cefd51a3a841dc52eb2ce6159c53c908a505da54fb0e5da8b4abd94.php:35 |
| 14 | __TwigTemplate_d3a66e30f0688277c24669e78234639217d187eb67156c8465facc1bde1d43f7->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 13 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 12 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:432 |
| 11 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
| 10 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
| 9 | Twig\Environment->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:175 |
| 8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/g5_hydrogen/index.php:35 |
| 7 | require JROOT/templates/g5_hydrogen/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:1030 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Vreme upita: 0.23 ms Nakon poslednjeg upita: 0.11 ms Memorija za upit: 0.039 MB memorije pre upita: 5.468 MB Kolona: 0
SELECT r.*
FROM j17_djcf_regions r
ORDER BY r.parent_id, r.name COLLATE utf8_polish_ci
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | r | system | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 0 | const row not found |
| Status | Duration |
|---|
| starting | 0.02 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 |
| After opening tables | 0.01 ms |
| init | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Poziv | Datoteka i broj linije |
|---|
| 55 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 54 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:432 |
| 53 | DJClassifiedsRegion::getRegions() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:337 |
| 52 | DJClassifiedsRegion::getSEOParentPath() | JROOT/administrator/components/com_djclassifieds/lib/djseo.php:157 |
| 51 | DJClassifiedsSEO::getRegionRoute() | JROOT/modules/mod_djclassifieds_items/tmpl/default.php:161 |
| 50 | require JROOT/modules/mod_djclassifieds_items/tmpl/default.php | JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php:86 |
| 49 | include JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 48 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 47 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:294 |
| 46 | Gantry\Framework\Platform->displayModule() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:342 |
| 45 | Gantry\Framework\Platform->displayModules() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 |
| 44 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_hydrogen/twig/fc/fce7f14566477d9e07e75a4d06b566c6c55317f2a19b3b547ca7e3c3d8f33922.php:43 |
| 43 | __TwigTemplate_d6daf405ba3f502ba11eb49ba78ac8defca00af7e4d9b301c97b92d1ff07edb8->block_particle() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:214 |
| 42 | Twig\Template->displayBlock() | JROOT/cache/gantry5/g5_hydrogen/twig/83/831096d1887e9ddcf83905f1c4ff307b9fa8528a8d530b36794ee63ef439d1b7.php:73 |
| 41 | __TwigTemplate_e75433e82790f0952cada3a14651ed35d8582623c54034cade9327f1f96125f6->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 40 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 39 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/fc/fce7f14566477d9e07e75a4d06b566c6c55317f2a19b3b547ca7e3c3d8f33922.php:35 |
| 38 | __TwigTemplate_d6daf405ba3f502ba11eb49ba78ac8defca00af7e4d9b301c97b92d1ff07edb8->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 37 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 36 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/3b/3b47c348791aabe1d7948ba0911c900b012c9d0665a44058c3268b4208486486.php:53 |
| 35 | __TwigTemplate_08098a182edc9cec17574f3ef7e1acadb36b6f36afd20151e14399b37e9b89fb->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 34 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 33 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:432 |
| 32 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
| 31 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
| 30 | Twig\Environment->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:175 |
| 29 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:825 |
| 28 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:718 |
| 27 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:643 |
| 26 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:468 |
| 22 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:700 |
| 21 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_hydrogen/twig/c4/c43e6df7d3488cf6c992b572b7667791163a650f93625b6362a1d1347073a270.php:47 |
| 20 | __TwigTemplate_32a18d6b73f3f68466b107fbc333ce33be6c6a5a1476f56bb0c2974b891e9b3b->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 19 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 18 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/86/86c497c686427cec7cc1347ed0037951f3303206be29c972c1432a2ae3680338.php:35 |
| 17 | __TwigTemplate_18ced7c049c64bb00cc216eb8b5f05265e45e0c6b4226abf2d565c015333ab96->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 16 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 15 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/49/497811926cefd51a3a841dc52eb2ce6159c53c908a505da54fb0e5da8b4abd94.php:35 |
| 14 | __TwigTemplate_d3a66e30f0688277c24669e78234639217d187eb67156c8465facc1bde1d43f7->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 13 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 12 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:432 |
| 11 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
| 10 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
| 9 | Twig\Environment->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:175 |
| 8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/g5_hydrogen/index.php:35 |
| 7 | require JROOT/templates/g5_hydrogen/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:1030 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Vreme upita: 1.32 ms Nakon poslednjeg upita: 0.04 ms Memorija za upit: 0.039 MB memorije pre upita: 5.492 MB Kolona: 1
SELECT i.region_id, count(i.id) as items_count
FROM j17_djcf_items i
WHERE i.published=1
AND i.date_exp > '2022-01-18 12:06:47'
GROUP BY i.region_id
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | i | ref | published | published | 4 | const | 177 | Using where; Using temporary; Using filesort |
| Status | Duration |
|---|
| starting | 0.02 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 |
| After opening tables | 0.01 ms |
| init | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.03 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Copying to tmp table | 0.02 ms |
| Copying to tmp table | 0.95 ms |
| Sorting result | 0.02 ms |
| Sending data | 0.01 ms |
| end | 0.01 ms |
| removing tmp table | 0.03 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Poziv | Datoteka i broj linije |
|---|
| 55 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 54 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:437 |
| 53 | DJClassifiedsRegion::getRegions() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:337 |
| 52 | DJClassifiedsRegion::getSEOParentPath() | JROOT/administrator/components/com_djclassifieds/lib/djseo.php:157 |
| 51 | DJClassifiedsSEO::getRegionRoute() | JROOT/modules/mod_djclassifieds_items/tmpl/default.php:161 |
| 50 | require JROOT/modules/mod_djclassifieds_items/tmpl/default.php | JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php:86 |
| 49 | include JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 48 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 47 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:294 |
| 46 | Gantry\Framework\Platform->displayModule() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:342 |
| 45 | Gantry\Framework\Platform->displayModules() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 |
| 44 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_hydrogen/twig/fc/fce7f14566477d9e07e75a4d06b566c6c55317f2a19b3b547ca7e3c3d8f33922.php:43 |
| 43 | __TwigTemplate_d6daf405ba3f502ba11eb49ba78ac8defca00af7e4d9b301c97b92d1ff07edb8->block_particle() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:214 |
| 42 | Twig\Template->displayBlock() | JROOT/cache/gantry5/g5_hydrogen/twig/83/831096d1887e9ddcf83905f1c4ff307b9fa8528a8d530b36794ee63ef439d1b7.php:73 |
| 41 | __TwigTemplate_e75433e82790f0952cada3a14651ed35d8582623c54034cade9327f1f96125f6->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 40 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 39 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/fc/fce7f14566477d9e07e75a4d06b566c6c55317f2a19b3b547ca7e3c3d8f33922.php:35 |
| 38 | __TwigTemplate_d6daf405ba3f502ba11eb49ba78ac8defca00af7e4d9b301c97b92d1ff07edb8->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 37 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 36 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/3b/3b47c348791aabe1d7948ba0911c900b012c9d0665a44058c3268b4208486486.php:53 |
| 35 | __TwigTemplate_08098a182edc9cec17574f3ef7e1acadb36b6f36afd20151e14399b37e9b89fb->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 34 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 33 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:432 |
| 32 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
| 31 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
| 30 | Twig\Environment->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:175 |
| 29 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:825 |
| 28 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:718 |
| 27 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:643 |
| 26 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:468 |
| 22 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:700 |
| 21 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_hydrogen/twig/c4/c43e6df7d3488cf6c992b572b7667791163a650f93625b6362a1d1347073a270.php:47 |
| 20 | __TwigTemplate_32a18d6b73f3f68466b107fbc333ce33be6c6a5a1476f56bb0c2974b891e9b3b->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 19 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 18 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/86/86c497c686427cec7cc1347ed0037951f3303206be29c972c1432a2ae3680338.php:35 |
| 17 | __TwigTemplate_18ced7c049c64bb00cc216eb8b5f05265e45e0c6b4226abf2d565c015333ab96->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 16 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 15 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/49/497811926cefd51a3a841dc52eb2ce6159c53c908a505da54fb0e5da8b4abd94.php:35 |
| 14 | __TwigTemplate_d3a66e30f0688277c24669e78234639217d187eb67156c8465facc1bde1d43f7->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 13 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 12 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:432 |
| 11 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
| 10 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
| 9 | Twig\Environment->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:175 |
| 8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/g5_hydrogen/index.php:35 |
| 7 | require JROOT/templates/g5_hydrogen/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:1030 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Vreme upita: 0.24 ms Nakon poslednjeg upita: 0.09 ms Memorija za upit: 0.039 MB memorije pre upita: 5.519 MB Kolona: 0
SELECT r.*
FROM j17_djcf_regions r
ORDER BY r.parent_id, r.name COLLATE utf8_polish_ci
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | r | system | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 0 | const row not found |
| Status | Duration |
|---|
| starting | 0.03 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 |
| After opening tables | 0.01 ms |
| init | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Poziv | Datoteka i broj linije |
|---|
| 55 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 54 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:432 |
| 53 | DJClassifiedsRegion::getRegions() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:337 |
| 52 | DJClassifiedsRegion::getSEOParentPath() | JROOT/administrator/components/com_djclassifieds/lib/djseo.php:84 |
| 51 | DJClassifiedsSEO::getItemRoute() | JROOT/modules/mod_djclassifieds_items/tmpl/default.php:78 |
| 50 | require JROOT/modules/mod_djclassifieds_items/tmpl/default.php | JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php:86 |
| 49 | include JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 48 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 47 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:294 |
| 46 | Gantry\Framework\Platform->displayModule() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:342 |
| 45 | Gantry\Framework\Platform->displayModules() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 |
| 44 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_hydrogen/twig/fc/fce7f14566477d9e07e75a4d06b566c6c55317f2a19b3b547ca7e3c3d8f33922.php:43 |
| 43 | __TwigTemplate_d6daf405ba3f502ba11eb49ba78ac8defca00af7e4d9b301c97b92d1ff07edb8->block_particle() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:214 |
| 42 | Twig\Template->displayBlock() | JROOT/cache/gantry5/g5_hydrogen/twig/83/831096d1887e9ddcf83905f1c4ff307b9fa8528a8d530b36794ee63ef439d1b7.php:73 |
| 41 | __TwigTemplate_e75433e82790f0952cada3a14651ed35d8582623c54034cade9327f1f96125f6->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 40 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 39 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/fc/fce7f14566477d9e07e75a4d06b566c6c55317f2a19b3b547ca7e3c3d8f33922.php:35 |
| 38 | __TwigTemplate_d6daf405ba3f502ba11eb49ba78ac8defca00af7e4d9b301c97b92d1ff07edb8->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 37 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 36 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/3b/3b47c348791aabe1d7948ba0911c900b012c9d0665a44058c3268b4208486486.php:53 |
| 35 | __TwigTemplate_08098a182edc9cec17574f3ef7e1acadb36b6f36afd20151e14399b37e9b89fb->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 34 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 33 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:432 |
| 32 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
| 31 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
| 30 | Twig\Environment->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:175 |
| 29 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:825 |
| 28 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:718 |
| 27 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:643 |
| 26 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:468 |
| 22 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:700 |
| 21 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_hydrogen/twig/c4/c43e6df7d3488cf6c992b572b7667791163a650f93625b6362a1d1347073a270.php:47 |
| 20 | __TwigTemplate_32a18d6b73f3f68466b107fbc333ce33be6c6a5a1476f56bb0c2974b891e9b3b->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 19 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 18 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/86/86c497c686427cec7cc1347ed0037951f3303206be29c972c1432a2ae3680338.php:35 |
| 17 | __TwigTemplate_18ced7c049c64bb00cc216eb8b5f05265e45e0c6b4226abf2d565c015333ab96->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 16 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 15 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/49/497811926cefd51a3a841dc52eb2ce6159c53c908a505da54fb0e5da8b4abd94.php:35 |
| 14 | __TwigTemplate_d3a66e30f0688277c24669e78234639217d187eb67156c8465facc1bde1d43f7->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 13 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 12 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:432 |
| 11 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
| 10 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
| 9 | Twig\Environment->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:175 |
| 8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/g5_hydrogen/index.php:35 |
| 7 | require JROOT/templates/g5_hydrogen/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:1030 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Vreme upita: 1.35 ms Nakon poslednjeg upita: 0.04 ms Memorija za upit: 0.039 MB memorije pre upita: 5.543 MB Kolona: 1
SELECT i.region_id, count(i.id) as items_count
FROM j17_djcf_items i
WHERE i.published=1
AND i.date_exp > '2022-01-18 12:06:47'
GROUP BY i.region_id
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | i | ref | published | published | 4 | const | 177 | Using where; Using temporary; Using filesort |
| Status | Duration |
|---|
| starting | 0.03 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 |
| After opening tables | 0.01 ms |
| init | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.03 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Copying to tmp table | 0.02 ms |
| Copying to tmp table | 0.96 ms |
| Sorting result | 0.02 ms |
| Sending data | 0.01 ms |
| end | 0.01 ms |
| removing tmp table | 0.03 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Poziv | Datoteka i broj linije |
|---|
| 55 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 54 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:437 |
| 53 | DJClassifiedsRegion::getRegions() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:337 |
| 52 | DJClassifiedsRegion::getSEOParentPath() | JROOT/administrator/components/com_djclassifieds/lib/djseo.php:84 |
| 51 | DJClassifiedsSEO::getItemRoute() | JROOT/modules/mod_djclassifieds_items/tmpl/default.php:78 |
| 50 | require JROOT/modules/mod_djclassifieds_items/tmpl/default.php | JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php:86 |
| 49 | include JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 48 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 47 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:294 |
| 46 | Gantry\Framework\Platform->displayModule() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:342 |
| 45 | Gantry\Framework\Platform->displayModules() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 |
| 44 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_hydrogen/twig/fc/fce7f14566477d9e07e75a4d06b566c6c55317f2a19b3b547ca7e3c3d8f33922.php:43 |
| 43 | __TwigTemplate_d6daf405ba3f502ba11eb49ba78ac8defca00af7e4d9b301c97b92d1ff07edb8->block_particle() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:214 |
| 42 | Twig\Template->displayBlock() | JROOT/cache/gantry5/g5_hydrogen/twig/83/831096d1887e9ddcf83905f1c4ff307b9fa8528a8d530b36794ee63ef439d1b7.php:73 |
| 41 | __TwigTemplate_e75433e82790f0952cada3a14651ed35d8582623c54034cade9327f1f96125f6->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 40 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 39 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/fc/fce7f14566477d9e07e75a4d06b566c6c55317f2a19b3b547ca7e3c3d8f33922.php:35 |
| 38 | __TwigTemplate_d6daf405ba3f502ba11eb49ba78ac8defca00af7e4d9b301c97b92d1ff07edb8->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 37 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 36 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/3b/3b47c348791aabe1d7948ba0911c900b012c9d0665a44058c3268b4208486486.php:53 |
| 35 | __TwigTemplate_08098a182edc9cec17574f3ef7e1acadb36b6f36afd20151e14399b37e9b89fb->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 34 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 33 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:432 |
| 32 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
| 31 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
| 30 | Twig\Environment->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:175 |
| 29 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:825 |
| 28 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:718 |
| 27 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:643 |
| 26 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:468 |
| 22 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:700 |
| 21 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_hydrogen/twig/c4/c43e6df7d3488cf6c992b572b7667791163a650f93625b6362a1d1347073a270.php:47 |
| 20 | __TwigTemplate_32a18d6b73f3f68466b107fbc333ce33be6c6a5a1476f56bb0c2974b891e9b3b->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 19 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 18 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/86/86c497c686427cec7cc1347ed0037951f3303206be29c972c1432a2ae3680338.php:35 |
| 17 | __TwigTemplate_18ced7c049c64bb00cc216eb8b5f05265e45e0c6b4226abf2d565c015333ab96->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 16 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 15 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/49/497811926cefd51a3a841dc52eb2ce6159c53c908a505da54fb0e5da8b4abd94.php:35 |
| 14 | __TwigTemplate_d3a66e30f0688277c24669e78234639217d187eb67156c8465facc1bde1d43f7->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 13 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 12 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:432 |
| 11 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
| 10 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
| 9 | Twig\Environment->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:175 |
| 8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/g5_hydrogen/index.php:35 |
| 7 | require JROOT/templates/g5_hydrogen/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:1030 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Vreme upita: 0.24 ms Nakon poslednjeg upita: 0.17 ms Memorija za upit: 0.039 MB memorije pre upita: 5.567 MB Kolona: 0
SELECT r.*
FROM j17_djcf_regions r
ORDER BY r.parent_id, r.name COLLATE utf8_polish_ci
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | r | system | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 0 | const row not found |
| Status | Duration |
|---|
| starting | 0.02 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 |
| After opening tables | 0.01 ms |
| init | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Poziv | Datoteka i broj linije |
|---|
| 55 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 54 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:432 |
| 53 | DJClassifiedsRegion::getRegions() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:337 |
| 52 | DJClassifiedsRegion::getSEOParentPath() | JROOT/administrator/components/com_djclassifieds/lib/djseo.php:84 |
| 51 | DJClassifiedsSEO::getItemRoute() | JROOT/modules/mod_djclassifieds_items/tmpl/default.php:113 |
| 50 | require JROOT/modules/mod_djclassifieds_items/tmpl/default.php | JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php:86 |
| 49 | include JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 48 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 47 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:294 |
| 46 | Gantry\Framework\Platform->displayModule() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:342 |
| 45 | Gantry\Framework\Platform->displayModules() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 |
| 44 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_hydrogen/twig/fc/fce7f14566477d9e07e75a4d06b566c6c55317f2a19b3b547ca7e3c3d8f33922.php:43 |
| 43 | __TwigTemplate_d6daf405ba3f502ba11eb49ba78ac8defca00af7e4d9b301c97b92d1ff07edb8->block_particle() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:214 |
| 42 | Twig\Template->displayBlock() | JROOT/cache/gantry5/g5_hydrogen/twig/83/831096d1887e9ddcf83905f1c4ff307b9fa8528a8d530b36794ee63ef439d1b7.php:73 |
| 41 | __TwigTemplate_e75433e82790f0952cada3a14651ed35d8582623c54034cade9327f1f96125f6->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 40 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 39 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/fc/fce7f14566477d9e07e75a4d06b566c6c55317f2a19b3b547ca7e3c3d8f33922.php:35 |
| 38 | __TwigTemplate_d6daf405ba3f502ba11eb49ba78ac8defca00af7e4d9b301c97b92d1ff07edb8->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 37 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 36 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/3b/3b47c348791aabe1d7948ba0911c900b012c9d0665a44058c3268b4208486486.php:53 |
| 35 | __TwigTemplate_08098a182edc9cec17574f3ef7e1acadb36b6f36afd20151e14399b37e9b89fb->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 34 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 33 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:432 |
| 32 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
| 31 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
| 30 | Twig\Environment->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:175 |
| 29 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:825 |
| 28 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:718 |
| 27 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:643 |
| 26 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:468 |
| 22 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:700 |
| 21 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_hydrogen/twig/c4/c43e6df7d3488cf6c992b572b7667791163a650f93625b6362a1d1347073a270.php:47 |
| 20 | __TwigTemplate_32a18d6b73f3f68466b107fbc333ce33be6c6a5a1476f56bb0c2974b891e9b3b->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 19 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 18 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/86/86c497c686427cec7cc1347ed0037951f3303206be29c972c1432a2ae3680338.php:35 |
| 17 | __TwigTemplate_18ced7c049c64bb00cc216eb8b5f05265e45e0c6b4226abf2d565c015333ab96->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 16 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 15 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/49/497811926cefd51a3a841dc52eb2ce6159c53c908a505da54fb0e5da8b4abd94.php:35 |
| 14 | __TwigTemplate_d3a66e30f0688277c24669e78234639217d187eb67156c8465facc1bde1d43f7->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 13 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 12 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:432 |
| 11 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
| 10 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
| 9 | Twig\Environment->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:175 |
| 8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/g5_hydrogen/index.php:35 |
| 7 | require JROOT/templates/g5_hydrogen/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:1030 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Vreme upita: 1.32 ms Nakon poslednjeg upita: 0.04 ms Memorija za upit: 0.039 MB memorije pre upita: 5.591 MB Kolona: 1
SELECT i.region_id, count(i.id) as items_count
FROM j17_djcf_items i
WHERE i.published=1
AND i.date_exp > '2022-01-18 12:06:47'
GROUP BY i.region_id
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | i | ref | published | published | 4 | const | 177 | Using where; Using temporary; Using filesort |
| Status | Duration |
|---|
| starting | 0.03 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 |
| After opening tables | 0.01 ms |
| init | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.03 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Copying to tmp table | 0.02 ms |
| Copying to tmp table | 0.95 ms |
| Sorting result | 0.02 ms |
| Sending data | 0.01 ms |
| end | 0.01 ms |
| removing tmp table | 0.03 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Poziv | Datoteka i broj linije |
|---|
| 55 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 54 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:437 |
| 53 | DJClassifiedsRegion::getRegions() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:337 |
| 52 | DJClassifiedsRegion::getSEOParentPath() | JROOT/administrator/components/com_djclassifieds/lib/djseo.php:84 |
| 51 | DJClassifiedsSEO::getItemRoute() | JROOT/modules/mod_djclassifieds_items/tmpl/default.php:113 |
| 50 | require JROOT/modules/mod_djclassifieds_items/tmpl/default.php | JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php:86 |
| 49 | include JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 48 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 47 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:294 |
| 46 | Gantry\Framework\Platform->displayModule() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:342 |
| 45 | Gantry\Framework\Platform->displayModules() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 |
| 44 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_hydrogen/twig/fc/fce7f14566477d9e07e75a4d06b566c6c55317f2a19b3b547ca7e3c3d8f33922.php:43 |
| 43 | __TwigTemplate_d6daf405ba3f502ba11eb49ba78ac8defca00af7e4d9b301c97b92d1ff07edb8->block_particle() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:214 |
| 42 | Twig\Template->displayBlock() | JROOT/cache/gantry5/g5_hydrogen/twig/83/831096d1887e9ddcf83905f1c4ff307b9fa8528a8d530b36794ee63ef439d1b7.php:73 |
| 41 | __TwigTemplate_e75433e82790f0952cada3a14651ed35d8582623c54034cade9327f1f96125f6->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 40 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 39 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/fc/fce7f14566477d9e07e75a4d06b566c6c55317f2a19b3b547ca7e3c3d8f33922.php:35 |
| 38 | __TwigTemplate_d6daf405ba3f502ba11eb49ba78ac8defca00af7e4d9b301c97b92d1ff07edb8->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 37 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 36 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/3b/3b47c348791aabe1d7948ba0911c900b012c9d0665a44058c3268b4208486486.php:53 |
| 35 | __TwigTemplate_08098a182edc9cec17574f3ef7e1acadb36b6f36afd20151e14399b37e9b89fb->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 34 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 33 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:432 |
| 32 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
| 31 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
| 30 | Twig\Environment->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:175 |
| 29 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:825 |
| 28 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:718 |
| 27 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:643 |
| 26 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:468 |
| 22 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:700 |
| 21 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_hydrogen/twig/c4/c43e6df7d3488cf6c992b572b7667791163a650f93625b6362a1d1347073a270.php:47 |
| 20 | __TwigTemplate_32a18d6b73f3f68466b107fbc333ce33be6c6a5a1476f56bb0c2974b891e9b3b->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 19 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 18 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/86/86c497c686427cec7cc1347ed0037951f3303206be29c972c1432a2ae3680338.php:35 |
| 17 | __TwigTemplate_18ced7c049c64bb00cc216eb8b5f05265e45e0c6b4226abf2d565c015333ab96->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 16 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 15 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/49/497811926cefd51a3a841dc52eb2ce6159c53c908a505da54fb0e5da8b4abd94.php:35 |
| 14 | __TwigTemplate_d3a66e30f0688277c24669e78234639217d187eb67156c8465facc1bde1d43f7->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 13 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 12 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:432 |
| 11 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
| 10 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
| 9 | Twig\Environment->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:175 |
| 8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/g5_hydrogen/index.php:35 |
| 7 | require JROOT/templates/g5_hydrogen/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:1030 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Vreme upita: 0.23 ms Nakon poslednjeg upita: 0.08 ms Memorija za upit: 0.039 MB memorije pre upita: 5.612 MB Kolona: 0
SELECT r.*
FROM j17_djcf_regions r
ORDER BY r.parent_id, r.name COLLATE utf8_polish_ci
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | r | system | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 0 | const row not found |
| Status | Duration |
|---|
| starting | 0.02 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 |
| After opening tables | 0.01 ms |
| init | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Poziv | Datoteka i broj linije |
|---|
| 55 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 54 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:432 |
| 53 | DJClassifiedsRegion::getRegions() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:337 |
| 52 | DJClassifiedsRegion::getSEOParentPath() | JROOT/administrator/components/com_djclassifieds/lib/djseo.php:157 |
| 51 | DJClassifiedsSEO::getRegionRoute() | JROOT/modules/mod_djclassifieds_items/tmpl/default.php:161 |
| 50 | require JROOT/modules/mod_djclassifieds_items/tmpl/default.php | JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php:86 |
| 49 | include JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 48 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 47 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:294 |
| 46 | Gantry\Framework\Platform->displayModule() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:342 |
| 45 | Gantry\Framework\Platform->displayModules() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 |
| 44 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_hydrogen/twig/fc/fce7f14566477d9e07e75a4d06b566c6c55317f2a19b3b547ca7e3c3d8f33922.php:43 |
| 43 | __TwigTemplate_d6daf405ba3f502ba11eb49ba78ac8defca00af7e4d9b301c97b92d1ff07edb8->block_particle() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:214 |
| 42 | Twig\Template->displayBlock() | JROOT/cache/gantry5/g5_hydrogen/twig/83/831096d1887e9ddcf83905f1c4ff307b9fa8528a8d530b36794ee63ef439d1b7.php:73 |
| 41 | __TwigTemplate_e75433e82790f0952cada3a14651ed35d8582623c54034cade9327f1f96125f6->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 40 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 39 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/fc/fce7f14566477d9e07e75a4d06b566c6c55317f2a19b3b547ca7e3c3d8f33922.php:35 |
| 38 | __TwigTemplate_d6daf405ba3f502ba11eb49ba78ac8defca00af7e4d9b301c97b92d1ff07edb8->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 37 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 36 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/3b/3b47c348791aabe1d7948ba0911c900b012c9d0665a44058c3268b4208486486.php:53 |
| 35 | __TwigTemplate_08098a182edc9cec17574f3ef7e1acadb36b6f36afd20151e14399b37e9b89fb->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 34 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 33 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:432 |
| 32 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
| 31 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
| 30 | Twig\Environment->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:175 |
| 29 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:825 |
| 28 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:718 |
| 27 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:643 |
| 26 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:468 |
| 22 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:700 |
| 21 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_hydrogen/twig/c4/c43e6df7d3488cf6c992b572b7667791163a650f93625b6362a1d1347073a270.php:47 |
| 20 | __TwigTemplate_32a18d6b73f3f68466b107fbc333ce33be6c6a5a1476f56bb0c2974b891e9b3b->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 19 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 18 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/86/86c497c686427cec7cc1347ed0037951f3303206be29c972c1432a2ae3680338.php:35 |
| 17 | __TwigTemplate_18ced7c049c64bb00cc216eb8b5f05265e45e0c6b4226abf2d565c015333ab96->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 16 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 15 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/49/497811926cefd51a3a841dc52eb2ce6159c53c908a505da54fb0e5da8b4abd94.php:35 |
| 14 | __TwigTemplate_d3a66e30f0688277c24669e78234639217d187eb67156c8465facc1bde1d43f7->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 13 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 12 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:432 |
| 11 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
| 10 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
| 9 | Twig\Environment->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:175 |
| 8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/g5_hydrogen/index.php:35 |
| 7 | require JROOT/templates/g5_hydrogen/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:1030 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Vreme upita: 1.32 ms Nakon poslednjeg upita: 0.05 ms Memorija za upit: 0.039 MB memorije pre upita: 5.636 MB Kolona: 1
SELECT i.region_id, count(i.id) as items_count
FROM j17_djcf_items i
WHERE i.published=1
AND i.date_exp > '2022-01-18 12:06:47'
GROUP BY i.region_id
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | i | ref | published | published | 4 | const | 177 | Using where; Using temporary; Using filesort |
| Status | Duration |
|---|
| starting | 0.02 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 |
| After opening tables | 0.01 ms |
| init | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.03 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Copying to tmp table | 0.02 ms |
| Copying to tmp table | 0.95 ms |
| Sorting result | 0.02 ms |
| Sending data | 0.01 ms |
| end | 0.01 ms |
| removing tmp table | 0.04 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Poziv | Datoteka i broj linije |
|---|
| 55 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 54 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:437 |
| 53 | DJClassifiedsRegion::getRegions() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:337 |
| 52 | DJClassifiedsRegion::getSEOParentPath() | JROOT/administrator/components/com_djclassifieds/lib/djseo.php:157 |
| 51 | DJClassifiedsSEO::getRegionRoute() | JROOT/modules/mod_djclassifieds_items/tmpl/default.php:161 |
| 50 | require JROOT/modules/mod_djclassifieds_items/tmpl/default.php | JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php:86 |
| 49 | include JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 48 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 47 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:294 |
| 46 | Gantry\Framework\Platform->displayModule() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:342 |
| 45 | Gantry\Framework\Platform->displayModules() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 |
| 44 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_hydrogen/twig/fc/fce7f14566477d9e07e75a4d06b566c6c55317f2a19b3b547ca7e3c3d8f33922.php:43 |
| 43 | __TwigTemplate_d6daf405ba3f502ba11eb49ba78ac8defca00af7e4d9b301c97b92d1ff07edb8->block_particle() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:214 |
| 42 | Twig\Template->displayBlock() | JROOT/cache/gantry5/g5_hydrogen/twig/83/831096d1887e9ddcf83905f1c4ff307b9fa8528a8d530b36794ee63ef439d1b7.php:73 |
| 41 | __TwigTemplate_e75433e82790f0952cada3a14651ed35d8582623c54034cade9327f1f96125f6->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 40 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 39 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/fc/fce7f14566477d9e07e75a4d06b566c6c55317f2a19b3b547ca7e3c3d8f33922.php:35 |
| 38 | __TwigTemplate_d6daf405ba3f502ba11eb49ba78ac8defca00af7e4d9b301c97b92d1ff07edb8->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 37 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 36 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/3b/3b47c348791aabe1d7948ba0911c900b012c9d0665a44058c3268b4208486486.php:53 |
| 35 | __TwigTemplate_08098a182edc9cec17574f3ef7e1acadb36b6f36afd20151e14399b37e9b89fb->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 34 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 33 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:432 |
| 32 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
| 31 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
| 30 | Twig\Environment->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:175 |
| 29 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:825 |
| 28 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:718 |
| 27 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:643 |
| 26 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:468 |
| 22 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:700 |
| 21 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_hydrogen/twig/c4/c43e6df7d3488cf6c992b572b7667791163a650f93625b6362a1d1347073a270.php:47 |
| 20 | __TwigTemplate_32a18d6b73f3f68466b107fbc333ce33be6c6a5a1476f56bb0c2974b891e9b3b->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 19 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 18 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/86/86c497c686427cec7cc1347ed0037951f3303206be29c972c1432a2ae3680338.php:35 |
| 17 | __TwigTemplate_18ced7c049c64bb00cc216eb8b5f05265e45e0c6b4226abf2d565c015333ab96->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 16 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 15 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/49/497811926cefd51a3a841dc52eb2ce6159c53c908a505da54fb0e5da8b4abd94.php:35 |
| 14 | __TwigTemplate_d3a66e30f0688277c24669e78234639217d187eb67156c8465facc1bde1d43f7->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 13 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 12 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:432 |
| 11 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
| 10 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
| 9 | Twig\Environment->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:175 |
| 8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/g5_hydrogen/index.php:35 |
| 7 | require JROOT/templates/g5_hydrogen/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:1030 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Vreme upita: 0.23 ms Nakon poslednjeg upita: 0.09 ms Memorija za upit: 0.039 MB memorije pre upita: 5.662 MB Kolona: 0
SELECT r.*
FROM j17_djcf_regions r
ORDER BY r.parent_id, r.name COLLATE utf8_polish_ci
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | r | system | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 0 | const row not found |
| Status | Duration |
|---|
| starting | 0.02 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 |
| After opening tables | 0.01 ms |
| init | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Poziv | Datoteka i broj linije |
|---|
| 55 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 54 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:432 |
| 53 | DJClassifiedsRegion::getRegions() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:337 |
| 52 | DJClassifiedsRegion::getSEOParentPath() | JROOT/administrator/components/com_djclassifieds/lib/djseo.php:84 |
| 51 | DJClassifiedsSEO::getItemRoute() | JROOT/modules/mod_djclassifieds_items/tmpl/default.php:78 |
| 50 | require JROOT/modules/mod_djclassifieds_items/tmpl/default.php | JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php:86 |
| 49 | include JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 48 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 47 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:294 |
| 46 | Gantry\Framework\Platform->displayModule() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:342 |
| 45 | Gantry\Framework\Platform->displayModules() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 |
| 44 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_hydrogen/twig/fc/fce7f14566477d9e07e75a4d06b566c6c55317f2a19b3b547ca7e3c3d8f33922.php:43 |
| 43 | __TwigTemplate_d6daf405ba3f502ba11eb49ba78ac8defca00af7e4d9b301c97b92d1ff07edb8->block_particle() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:214 |
| 42 | Twig\Template->displayBlock() | JROOT/cache/gantry5/g5_hydrogen/twig/83/831096d1887e9ddcf83905f1c4ff307b9fa8528a8d530b36794ee63ef439d1b7.php:73 |
| 41 | __TwigTemplate_e75433e82790f0952cada3a14651ed35d8582623c54034cade9327f1f96125f6->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 40 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 39 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/fc/fce7f14566477d9e07e75a4d06b566c6c55317f2a19b3b547ca7e3c3d8f33922.php:35 |
| 38 | __TwigTemplate_d6daf405ba3f502ba11eb49ba78ac8defca00af7e4d9b301c97b92d1ff07edb8->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 37 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 36 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/3b/3b47c348791aabe1d7948ba0911c900b012c9d0665a44058c3268b4208486486.php:53 |
| 35 | __TwigTemplate_08098a182edc9cec17574f3ef7e1acadb36b6f36afd20151e14399b37e9b89fb->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 34 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 33 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:432 |
| 32 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
| 31 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
| 30 | Twig\Environment->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:175 |
| 29 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:825 |
| 28 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:718 |
| 27 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:643 |
| 26 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:468 |
| 22 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:700 |
| 21 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_hydrogen/twig/c4/c43e6df7d3488cf6c992b572b7667791163a650f93625b6362a1d1347073a270.php:47 |
| 20 | __TwigTemplate_32a18d6b73f3f68466b107fbc333ce33be6c6a5a1476f56bb0c2974b891e9b3b->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 19 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 18 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/86/86c497c686427cec7cc1347ed0037951f3303206be29c972c1432a2ae3680338.php:35 |
| 17 | __TwigTemplate_18ced7c049c64bb00cc216eb8b5f05265e45e0c6b4226abf2d565c015333ab96->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 16 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 15 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/49/497811926cefd51a3a841dc52eb2ce6159c53c908a505da54fb0e5da8b4abd94.php:35 |
| 14 | __TwigTemplate_d3a66e30f0688277c24669e78234639217d187eb67156c8465facc1bde1d43f7->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 13 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 12 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:432 |
| 11 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
| 10 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
| 9 | Twig\Environment->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:175 |
| 8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/g5_hydrogen/index.php:35 |
| 7 | require JROOT/templates/g5_hydrogen/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:1030 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Vreme upita: 1.27 ms Nakon poslednjeg upita: 0.06 ms Memorija za upit: 0.039 MB memorije pre upita: 5.686 MB Kolona: 1
SELECT i.region_id, count(i.id) as items_count
FROM j17_djcf_items i
WHERE i.published=1
AND i.date_exp > '2022-01-18 12:06:47'
GROUP BY i.region_id
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | i | ref | published | published | 4 | const | 177 | Using where; Using temporary; Using filesort |
| Status | Duration |
|---|
| starting | 0.02 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 |
| After opening tables | 0.01 ms |
| init | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.02 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Copying to tmp table | 0.02 ms |
| Copying to tmp table | 0.92 ms |
| Sorting result | 0.02 ms |
| Sending data | 0.01 ms |
| end | 0.01 ms |
| removing tmp table | 0.03 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.02 ms |
| cleaning up | 0.02 ms |
| # | Poziv | Datoteka i broj linije |
|---|
| 55 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 54 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:437 |
| 53 | DJClassifiedsRegion::getRegions() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:337 |
| 52 | DJClassifiedsRegion::getSEOParentPath() | JROOT/administrator/components/com_djclassifieds/lib/djseo.php:84 |
| 51 | DJClassifiedsSEO::getItemRoute() | JROOT/modules/mod_djclassifieds_items/tmpl/default.php:78 |
| 50 | require JROOT/modules/mod_djclassifieds_items/tmpl/default.php | JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php:86 |
| 49 | include JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 48 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 47 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:294 |
| 46 | Gantry\Framework\Platform->displayModule() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:342 |
| 45 | Gantry\Framework\Platform->displayModules() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 |
| 44 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_hydrogen/twig/fc/fce7f14566477d9e07e75a4d06b566c6c55317f2a19b3b547ca7e3c3d8f33922.php:43 |
| 43 | __TwigTemplate_d6daf405ba3f502ba11eb49ba78ac8defca00af7e4d9b301c97b92d1ff07edb8->block_particle() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:214 |
| 42 | Twig\Template->displayBlock() | JROOT/cache/gantry5/g5_hydrogen/twig/83/831096d1887e9ddcf83905f1c4ff307b9fa8528a8d530b36794ee63ef439d1b7.php:73 |
| 41 | __TwigTemplate_e75433e82790f0952cada3a14651ed35d8582623c54034cade9327f1f96125f6->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 40 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 39 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/fc/fce7f14566477d9e07e75a4d06b566c6c55317f2a19b3b547ca7e3c3d8f33922.php:35 |
| 38 | __TwigTemplate_d6daf405ba3f502ba11eb49ba78ac8defca00af7e4d9b301c97b92d1ff07edb8->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 37 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 36 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/3b/3b47c348791aabe1d7948ba0911c900b012c9d0665a44058c3268b4208486486.php:53 |
| 35 | __TwigTemplate_08098a182edc9cec17574f3ef7e1acadb36b6f36afd20151e14399b37e9b89fb->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 34 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 33 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:432 |
| 32 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
| 31 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
| 30 | Twig\Environment->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:175 |
| 29 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:825 |
| 28 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:718 |
| 27 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:643 |
| 26 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
| 23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:468 |
| 22 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:700 |
| 21 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_hydrogen/twig/c4/c43e6df7d3488cf6c992b572b7667791163a650f93625b6362a1d1347073a270.php:47 |
| 20 | __TwigTemplate_32a18d6b73f3f68466b107fbc333ce33be6c6a5a1476f56bb0c2974b891e9b3b->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 19 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 18 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/86/86c497c686427cec7cc1347ed0037951f3303206be29c972c1432a2ae3680338.php:35 |
| 17 | __TwigTemplate_18ced7c049c64bb00cc216eb8b5f05265e45e0c6b4226abf2d565c015333ab96->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 16 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 15 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/49/497811926cefd51a3a841dc52eb2ce6159c53c908a505da54fb0e5da8b4abd94.php:35 |
| 14 | __TwigTemplate_d3a66e30f0688277c24669e78234639217d187eb67156c8465facc1bde1d43f7->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
| 13 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
| 12 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:432 |
| 11 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
| 10 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
| 9 | Twig\Environment->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:175 |
| 8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/g5_hydrogen/index.php:35 |
| 7 | require JROOT/templates/g5_hydrogen/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:1030 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Vreme upita: 0.24 ms Nakon poslednjeg upita: 0.18 ms Memorija za upit: 0.039 MB memorije pre upita: 5.711 MB Kolona: 0
SELECT r.*
FROM j17_djcf_regions r
ORDER BY r.parent_id, r.name COLLATE utf8_polish_ci
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | r | system | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 0 | const row not found |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.01 ms |
| System lock | 0.02 ms |
| Table lock | 0.01 ms |
| After opening tables | 0.01 ms |
| init | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Poziv | Datoteka i broj linije |
|---|
| 55 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 54 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:432 |
| 53 | DJClassifiedsRegion::getRegions() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:337 |
| 52 | DJClassifiedsRegion::getSEOParentPath() | JROOT/administrator/components/com_djclassifieds/lib/djseo.php:84 |
| 51 | DJClassifiedsSEO::getItemRoute() | JROOT/modules/mod_djclassifieds_items/tmpl/default.php:113 |
| 50 | require JROOT/modules/mod_djclassifieds_items/tmpl/default.php | JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php:86 |
| 49 | include JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 48 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 47 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:294 |
| 46 | Gantry\Framework\Platform->displayModule() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:342 |
| 45 | Gantry\Framework\Platform->displayModules() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 |
| 44 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_hydrogen/twig/fc/fce7f14566477d9e07e75a4d06b566c6c55317f2a19b3b547ca7e3c3d8f33922.php:43 |
| 43 | __TwigTemplate_d6 |
