Lovačko oružje

Naslov oglasa	Kategorija	Cena	Postavljen
Lovačka puška	Lovačko oružje	400e RSD	2021-12-16 17:02:21
Vazdusne puske	Lovačko oružje	6000 RSD	2021-12-13 18:27:23
Lovacki karabin 300 wincester magnum	Lovačko oružje	1.00 RSD	2021-12-05 13:50:31
Lovacki karabin 300 wincester magnum	Lovačko oružje	1.00 RSD	2021-12-05 13:47:42
Lovacki karabin 300 wincester magnum	Lovačko oružje	1.00 RSD	2021-12-05 13:39:31
Prodajem lovačku pušku ZCZ 16x70	Lovačko oružje	7.000 RSD	2021-12-02 12:28:37

Lovački oglasi

Upiši svoj oglas

Lovački oglasi

Lovacki karabin 300 wincester magnum

Lovačka kamera HC801M fotoklopka kamera za lov

Garnitura HUBERTUS

Kamera za praćenje divljači lovacka kamera HC-300M

Lovacka kamera NOVIJI model 330M- kamera za lovce fotoklopka

Joomla! Debug Console

Sesija

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1642503336,
                "last": 1642503336,
                "now": 1642503336
            },
            "token": "paOQSTaMhUM50nQG6nJd9rgLBM5PdLWV"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Informacije profila

Iskorišćenost memorije

Upiti baze podataka

91 upita 55.64 ms

59 duplikata pronađeno!

3 duplikata: #16 #24 #27

2 duplikata: #28 #55

27 duplikata: #29 #31 #33 #35 #37 #39 #41 #43 #45 #47 #49 #51 #59 #61 #63 #65 #67 #69 #71 #73 #75 #77 #79 #81 #83 #85 #87

27 duplikata: #30 #32 #34 #36 #38 #40 #42 #44 #46 #48 #50 #52 #60 #62 #64 #66 #68 #70 #72 #74 #76 #78 #80 #82 #84 #86 #88

Vreme upita: 0.31 ms Memorija za upit: 0.023 MB memorije pre upita: 1.259 MB Kolona: 0

SELECT `data`

  FROM `j17_session`

  WHERE `session_id` = 'bd3127c9d2e2981bbc9e698b210730e0'

Objašnjenje

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j17_session	const	PRIMARY	PRIMARY	194	const	1

Profil

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.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.02 ms
cleaning up	0.01 ms

Call Stack

#	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

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vreme upita: 0.27 ms Nakon poslednjeg upita: 0.54 ms Memorija za upit: 0.020 MB memorije pre upita: 1.274 MB Kolona: 0

SELECT `session_id`

  FROM `j17_session`

  WHERE `session_id` = 'bd3127c9d2e2981bbc9e698b210730e0' 
  LIMIT 1

Objašnjenje

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

Profil

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.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.02 ms
cleaning up	0.01 ms

Call Stack

#	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

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vreme upita: 0.70 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 
('bd3127c9d2e2981bbc9e698b210730e0', 1, 1642503336, 0, '', 0)

Objašnjenje

Objašnjenje nije moguće u upitu: INSERT INTO `j17_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('bd3127c9d2e2981bbc9e698b210730e0', 1, 1642503336, 0, '', 0)

Profil

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.46 ms
closing tables	0.02 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	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

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vreme upita: 0.48 ms Nakon poslednjeg upita: 1.01 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

Objašnjenje

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

Profil

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.19 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

Call Stack

#	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

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vreme upita: 0.22 ms Nakon poslednjeg upita: 0.97 ms Memorija za upit: 0.021 MB memorije pre upita: 1.431 MB Kolona: 3

SELECT id, rules

  FROM `j17_viewlevels`

Objašnjenje

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

Profil

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.01 ms
cleaning up	0.01 ms

Call Stack

#	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

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vreme upita: 0.26 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

Objašnjenje

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

Profil

Status	Duration
starting	0.02 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.03 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

Call Stack

#	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

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vreme upita: 0.65 ms Nakon poslednjeg upita: 0.23 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

Objašnjenje

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

Profil

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.03 ms
preparing	0.02 ms
executing	0.01 ms
Sorting result	0.26 ms
Sending data	0.10 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

Call Stack

#	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

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vreme upita: 0.77 ms Nakon poslednjeg upita: 17.88 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

Objašnjenje

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

Profil

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.02 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.01 ms
Sorting result	0.19 ms
Sending data	0.15 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

Call Stack

#	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

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vreme upita: 0.43 ms Nakon poslednjeg upita: 3.22 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'

Objašnjenje

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

Profil

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.06 ms
preparing	0.02 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.05 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	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

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vreme upita: 0.66 ms Nakon poslednjeg upita: 0.11 ms Memorija za upit: 0.006 MB memorije pre upita: 2.653 MB

UPDATE `j17_extensions`

  SET `params` = '{\"mediaversion\":\"dc3e5daf103e4fd788470f62541d0e39\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Objašnjenje

Objašnjenje nije moguće u upitu: UPDATE `j17_extensions` SET `params` = '{\"mediaversion\":\"dc3e5daf103e4fd788470f62541d0e39\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profil

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.04 ms
updating	0.04 ms
end	0.01 ms
Waiting for query cache lock	0.01 ms
end	0.01 ms
query end	0.39 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	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

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vreme upita: 0.29 ms Nakon poslednjeg upita: 0.59 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

Objašnjenje

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

Profil

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
Sorting result	0.03 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

Call Stack

#	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

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vreme upita: 0.34 ms Nakon poslednjeg upita: 0.87 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

Objašnjenje

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

Profil

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.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 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.01 ms
cleaning up	0.01 ms

Call Stack

#	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

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vreme upita: 0.39 ms Nakon poslednjeg upita: 5.50 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

Objašnjenje

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

Profil

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.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.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

Call Stack

#	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

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vreme upita: 0.31 ms Nakon poslednjeg upita: 5.61 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 11:55:36' 
  AND updated=0 
  GROUP BY item_id

Objašnjenje

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

Profil

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.02 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

Call Stack

#	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

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vreme upita: 0.59 ms Nakon poslednjeg upita: 0.91 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

Objašnjenje

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

Profil

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.09 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.07 ms
cleaning up	0.01 ms

Call Stack

#	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

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vreme upita: 0.37 ms Nakon poslednjeg upita: 0.33 ms Memorija za upit: 0.022 MB memorije pre upita: 3.882 MB Kolona: 0

Dupli upiti: #24 #27

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 11:00:00' 
  GROUP BY ic.cat_id

Objašnjenje

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

Profil

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.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

Call Stack

#	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

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vreme upita: 1.74 ms Nakon poslednjeg upita: 0.17 ms Memorija za upit: 0.046 MB memorije pre upita: 3.895 MB Kolona: 6

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 (2,2) 
  GROUP BY item_id ) mc 
  ON i.id=mc.item_id 
  WHERE i.date_exp > '2022-01-18 11:55:36' 
  AND i.published=1 
  AND i.blocked=0 
  AND c.published=1  
  AND (i.cat_id IN (2,2) 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

Objašnjenje

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

Profil

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
checking permissions	0.01 ms
Opening tables	0.03 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.08 ms
optimizing	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.03 ms
statistics	0.08 ms
preparing	0.04 ms
executing	0.01 ms
Copying to tmp table	0.35 ms
Copying to tmp table	0.55 ms
Sorting result	0.03 ms
Sending data	0.06 ms
end	0.01 ms
removing tmp table	0.07 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
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	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

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vreme upita: 0.53 ms Nakon poslednjeg upita: 0.05 ms Memorija za upit: 0.021 MB memorije pre upita: 3.925 MB Kolona: 0

SELECT fv.item_id, fv.field_id, fv.value, fv.value_date, fv.value_date_to, f.label, f.type 
  FROM j17_djcf_fields_values fv,j17_djcf_fields f 
  WHERE fv.item_id IN (529,527,525,524,523,522) 
  AND f.id=fv.field_id 
  AND (f.in_table>0 OR f.in_blog=1) 
  AND f.access=0 
  AND f.published=1 
  ORDER BY fv.item_id,f.ordering, f.label

Objašnjenje

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	f	ref	PRIMARY,published	published	4	const	2	Using where; Using temporary; Using filesort
1	SIMPLE	fv	ref	field_id,type_id	field_id	4	dmaricn_lovackenovo.f.id	58	Using where

Profil

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.02 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Copying to tmp table	0.11 ms
Copying to tmp table	0.03 ms
Sorting result	0.02 ms
Sending data	0.01 ms
end	0.01 ms
removing tmp table	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.01 ms
cleaning up	0.01 ms

Call Stack

#	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:368
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

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vreme upita: 0.41 ms Nakon poslednjeg upita: 0.03 ms Memorija za upit: 0.024 MB memorije pre upita: 3.931 MB Kolona: 11

SELECT img.* 
  FROM j17_djcf_images img 
  WHERE img.item_id IN (529,527,525,524,523,522) 
  AND img.type='item' 
  ORDER BY img.item_id, img.ordering

Objašnjenje

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	img	range	item_id,type	item_id	4	NULL	21	Using index condition; Using where; Using filesort

Profil

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.05 ms
preparing	0.02 ms
executing	0.01 ms
Sorting result	0.07 ms
Sending data	0.06 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

Call Stack

#	Poziv	Datoteka i broj linije
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djimage.php:427
11	DJClassifiedsImage::getAdsImages()	JROOT/components/com_djclassifieds/models/items.php:371
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

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vreme upita: 0.28 ms Nakon poslednjeg upita: 0.04 ms Memorija za upit: 0.021 MB memorije pre upita: 3.953 MB Kolona: 0

SELECT ic.item_id, ic.cat_id, c.name, c.alias 
  FROM j17_djcf_items_categories ic, j17_djcf_categories c 
  WHERE c.id=ic.cat_id 
  AND ic.item_id IN (529,527,525,524,523,522)  
  ORDER BY ic.item_id,ic.ordering

Objašnjenje

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

Profil

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.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.02 ms
cleaning up	0.01 ms

Call Stack

#	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:379
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

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vreme upita: 0.84 ms Nakon poslednjeg upita: 0.10 ms Memorija za upit: 0.022 MB memorije pre upita: 3.992 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 (2,2) 
  GROUP BY item_id ) mc 
  ON i.id=mc.item_id 
  WHERE i.date_exp > '2022-01-18 11:55:36' 
  AND i.published=1 
  AND i.blocked=0 
  AND c.published=1  
  AND (i.cat_id IN (2,2) OR mc.mcat_c>0)  
  AND c.access_view IN (0,1,1)  ) as i

Objašnjenje

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

Profil

Status	Duration
starting	0.05 ms
checking 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.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
init	0.04 ms
optimizing	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.03 ms
statistics	0.05 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.38 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.02 ms
closing tables	0.01 ms
removing tmp table	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	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

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vreme upita: 0.26 ms Nakon poslednjeg upita: 0.05 ms Memorija za upit: 0.022 MB memorije pre upita: 3.996 MB Kolona: 1

SELECT * 
  FROM j17_djcf_categories 
  WHERE id=2 
  AND access_view IN (1,1)  
  LIMIT 1

Objašnjenje

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j17_djcf_categories	const	PRIMARY	PRIMARY	4	const	1

Profil

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.02 ms
preparing	0.01 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

Call Stack

#	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

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vreme upita: 0.32 ms Nakon poslednjeg upita: 0.47 ms Memorija za upit: 0.025 MB memorije pre upita: 4.012 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

Objašnjenje

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

Profil

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.02 ms
preparing	0.02 ms
executing	0.01 ms
Sorting result	0.02 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.01 ms
cleaning up	0.01 ms

Call Stack

#	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

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vreme upita: 0.24 ms Nakon poslednjeg upita: 0.03 ms Memorija za upit: 0.022 MB memorije pre upita: 4.031 MB Kolona: 0

Dupli upiti: #16 #27

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 11:00:00' 
  GROUP BY ic.cat_id

Objašnjenje

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

Profil

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.02 ms
optimizing	0.02 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

Call Stack

#	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

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vreme upita: 0.32 ms Nakon poslednjeg upita: 0.43 ms Memorija za upit: 0.022 MB memorije pre upita: 4.047 MB Kolona: 0

SELECT * 
  FROM j17_djcf_fields 
  WHERE published=1 
  AND (in_table>0 OR in_blog=1) 
  ORDER BY name

Objašnjenje

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

Profil

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.02 ms
preparing	0.02 ms
executing	0.01 ms
Sorting result	0.03 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

Call Stack

#	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

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vreme upita: 0.28 ms Nakon poslednjeg upita: 0.08 ms Memorija za upit: 0.026 MB memorije pre upita: 4.054 MB Kolona: 9

SELECT c.* 
  FROM j17_djcf_categories c 
  ORDER BY c.parent_id, c.ordering

Objašnjenje

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

Profil

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
Sorting result	0.02 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.01 ms
cleaning up	0.01 ms

Call Stack

#	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

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vreme upita: 0.24 ms Nakon poslednjeg upita: 0.03 ms Memorija za upit: 0.021 MB memorije pre upita: 4.074 MB Kolona: 0

Dupli upiti: #16 #24

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 11:00:00' 
  GROUP BY ic.cat_id

Objašnjenje

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

Profil

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.02 ms
optimizing	0.02 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

Call Stack

#	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

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vreme upita: 0.83 ms Nakon poslednjeg upita: 0.61 ms Memorija za upit: 0.027 MB memorije pre upita: 4.152 MB Kolona: 12

Dupli upiti: #55

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 10:55:36') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-01-18 10:55:36') 
  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

Objašnjenje

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

Profil

Status	Duration
starting	0.05 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.05 ms
preparing	0.04 ms
executing	0.01 ms
Sorting result	0.27 ms
Sending data	0.18 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

Call Stack

#	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

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vreme upita: 0.22 ms Nakon poslednjeg upita: 0.41 ms Memorija za upit: 0.024 MB memorije pre upita: 4.166 MB Kolona: 0

Dupli upiti: #31 #33 #35 #37 #39 #41 #43 #45 #47 #49 #51 #59 #61 #63 #65 #67 #69 #71 #73 #75 #77 #79 #81 #83 #85 #87

SELECT r.* 
  FROM j17_djcf_regions r 
  ORDER BY r.parent_id, r.name COLLATE utf8_polish_ci

Objašnjenje

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

Profil

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.01 ms
cleaning up	0.01 ms

Call Stack

#	Poziv	Datoteka i broj linije
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:432
15	DJClassifiedsRegion::getRegions()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:337
14	DJClassifiedsRegion::getSEOParentPath()	JROOT/administrator/components/com_djclassifieds/lib/djseo.php:84
13	DJClassifiedsSEO::getItemRoute()	JROOT/components/com_djclassifieds/views/items/tmpl/default.php:359
12	include JROOT/components/com_djclassifieds/views/items/tmpl/default.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:427
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

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vreme upita: 1.14 ms Nakon poslednjeg upita: 0.03 ms Memorija za upit: 0.024 MB memorije pre upita: 4.174 MB Kolona: 1

Dupli upiti: #32 #34 #36 #38 #40 #42 #44 #46 #48 #50 #52 #60 #62 #64 #66 #68 #70 #72 #74 #76 #78 #80 #82 #84 #86 #88

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 11:55:36' 
  GROUP BY i.region_id

Objašnjenje

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

Profil

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.02 ms
preparing	0.02 ms
executing	0.01 ms
Copying to tmp table	0.02 ms
Copying to tmp table	0.83 ms
Sorting result	0.02 ms
Sending data	0.01 ms
end	0.01 ms
removing tmp table	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

Call Stack

#	Poziv	Datoteka i broj linije
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:437
15	DJClassifiedsRegion::getRegions()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:337
14	DJClassifiedsRegion::getSEOParentPath()	JROOT/administrator/components/com_djclassifieds/lib/djseo.php:84
13	DJClassifiedsSEO::getItemRoute()	JROOT/components/com_djclassifieds/views/items/tmpl/default.php:359
12	include JROOT/components/com_djclassifieds/views/items/tmpl/default.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:427
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

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vreme upita: 0.20 ms Nakon poslednjeg upita: 0.07 ms Memorija za upit: 0.024 MB memorije pre upita: 4.183 MB Kolona: 0

Dupli upiti: #29 #33 #35 #37 #39 #41 #43 #45 #47 #49 #51 #59 #61 #63 #65 #67 #69 #71 #73 #75 #77 #79 #81 #83 #85 #87

SELECT r.* 
  FROM j17_djcf_regions r 
  ORDER BY r.parent_id, r.name COLLATE utf8_polish_ci

Objašnjenje

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

Profil

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.01 ms
cleaning up	0.01 ms

Call Stack

#	Poziv	Datoteka i broj linije
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:432
15	DJClassifiedsRegion::getRegions()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:337
14	DJClassifiedsRegion::getSEOParentPath()	JROOT/administrator/components/com_djclassifieds/lib/djseo.php:84
13	DJClassifiedsSEO::getItemRoute()	JROOT/components/com_djclassifieds/views/items/tmpl/default.php:387
12	include JROOT/components/com_djclassifieds/views/items/tmpl/default.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:427
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

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vreme upita: 1.13 ms Nakon poslednjeg upita: 0.02 ms Memorija za upit: 0.024 MB memorije pre upita: 4.192 MB Kolona: 1

Dupli upiti: #30 #34 #36 #38 #40 #42 #44 #46 #48 #50 #52 #60 #62 #64 #66 #68 #70 #72 #74 #76 #78 #80 #82 #84 #86 #88

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 11:55:36' 
  GROUP BY i.region_id

Objašnjenje

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

Profil

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.02 ms
preparing	0.02 ms
executing	0.01 ms
Copying to tmp table	0.02 ms
Copying to tmp table	0.81 ms
Sorting result	0.01 ms
Sending data	0.01 ms
end	0.01 ms
removing tmp table	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

Call Stack

#	Poziv	Datoteka i broj linije
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:437
15	DJClassifiedsRegion::getRegions()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:337
14	DJClassifiedsRegion::getSEOParentPath()	JROOT/administrator/components/com_djclassifieds/lib/djseo.php:84
13	DJClassifiedsSEO::getItemRoute()	JROOT/components/com_djclassifieds/views/items/tmpl/default.php:387
12	include JROOT/components/com_djclassifieds/views/items/tmpl/default.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:427
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

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vreme upita: 0.21 ms Nakon poslednjeg upita: 0.23 ms Memorija za upit: 0.025 MB memorije pre upita: 4.208 MB Kolona: 0

Dupli upiti: #29 #31 #35 #37 #39 #41 #43 #45 #47 #49 #51 #59 #61 #63 #65 #67 #69 #71 #73 #75 #77 #79 #81 #83 #85 #87

SELECT r.* 
  FROM j17_djcf_regions r 
  ORDER BY r.parent_id, r.name COLLATE utf8_polish_ci

Objašnjenje

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

Profil

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
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

Call Stack

#	Poziv	Datoteka i broj linije
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:432
15	DJClassifiedsRegion::getRegions()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:337
14	DJClassifiedsRegion::getSEOParentPath()	JROOT/administrator/components/com_djclassifieds/lib/djseo.php:84
13	DJClassifiedsSEO::getItemRoute()	JROOT/components/com_djclassifieds/views/items/tmpl/default.php:359
12	include JROOT/components/com_djclassifieds/views/items/tmpl/default.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:427
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

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vreme upita: 1.11 ms Nakon poslednjeg upita: 0.02 ms Memorija za upit: 0.024 MB memorije pre upita: 4.218 MB Kolona: 1

Dupli upiti: #30 #32 #36 #38 #40 #42 #44 #46 #48 #50 #52 #60 #62 #64 #66 #68 #70 #72 #74 #76 #78 #80 #82 #84 #86 #88

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 11:55:36' 
  GROUP BY i.region_id

Objašnjenje

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

Profil

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.02 ms
preparing	0.02 ms
executing	0.01 ms
Copying to tmp table	0.02 ms
Copying to tmp table	0.81 ms
Sorting result	0.01 ms
Sending data	0.01 ms
end	0.01 ms
removing tmp table	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

Call Stack

#	Poziv	Datoteka i broj linije
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:437
15	DJClassifiedsRegion::getRegions()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:337
14	DJClassifiedsRegion::getSEOParentPath()	JROOT/administrator/components/com_djclassifieds/lib/djseo.php:84
13	DJClassifiedsSEO::getItemRoute()	JROOT/components/com_djclassifieds/views/items/tmpl/default.php:359
12	include JROOT/components/com_djclassifieds/views/items/tmpl/default.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:427
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

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vreme upita: 0.21 ms Nakon poslednjeg upita: 0.07 ms Memorija za upit: 0.024 MB memorije pre upita: 4.226 MB Kolona: 0

Dupli upiti: #29 #31 #33 #37 #39 #41 #43 #45 #47 #49 #51 #59 #61 #63 #65 #67 #69 #71 #73 #75 #77 #79 #81 #83 #85 #87

SELECT r.* 
  FROM j17_djcf_regions r 
  ORDER BY r.parent_id, r.name COLLATE utf8_polish_ci

Objašnjenje

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

Profil

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.01 ms
cleaning up	0.01 ms

Call Stack

#	Poziv	Datoteka i broj linije
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:432
15	DJClassifiedsRegion::getRegions()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:337
14	DJClassifiedsRegion::getSEOParentPath()	JROOT/administrator/components/com_djclassifieds/lib/djseo.php:84
13	DJClassifiedsSEO::getItemRoute()	JROOT/components/com_djclassifieds/views/items/tmpl/default.php:387
12	include JROOT/components/com_djclassifieds/views/items/tmpl/default.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:427
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

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vreme upita: 1.13 ms Nakon poslednjeg upita: 0.02 ms Memorija za upit: 0.024 MB memorije pre upita: 4.235 MB Kolona: 1

Dupli upiti: #30 #32 #34 #38 #40 #42 #44 #46 #48 #50 #52 #60 #62 #64 #66 #68 #70 #72 #74 #76 #78 #80 #82 #84 #86 #88

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 11:55:36' 
  GROUP BY i.region_id

Objašnjenje

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

Profil

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.02 ms
preparing	0.02 ms
executing	0.01 ms
Copying to tmp table	0.02 ms
Copying to tmp table	0.81 ms
Sorting result	0.01 ms
Sending data	0.01 ms
end	0.01 ms
removing tmp table	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

Call Stack

#	Poziv	Datoteka i broj linije
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:437
15	DJClassifiedsRegion::getRegions()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:337
14	DJClassifiedsRegion::getSEOParentPath()	JROOT/administrator/components/com_djclassifieds/lib/djseo.php:84
13	DJClassifiedsSEO::getItemRoute()	JROOT/components/com_djclassifieds/views/items/tmpl/default.php:387
12	include JROOT/components/com_djclassifieds/views/items/tmpl/default.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:427
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

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vreme upita: 0.21 ms Nakon poslednjeg upita: 0.13 ms Memorija za upit: 0.024 MB memorije pre upita: 4.244 MB Kolona: 0

Dupli upiti: #29 #31 #33 #35 #39 #41 #43 #45 #47 #49 #51 #59 #61 #63 #65 #67 #69 #71 #73 #75 #77 #79 #81 #83 #85 #87

SELECT r.* 
  FROM j17_djcf_regions r 
  ORDER BY r.parent_id, r.name COLLATE utf8_polish_ci

Objašnjenje

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

Profil

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.01 ms
cleaning up	0.01 ms

Call Stack

#	Poziv	Datoteka i broj linije
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:432
15	DJClassifiedsRegion::getRegions()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:337
14	DJClassifiedsRegion::getSEOParentPath()	JROOT/administrator/components/com_djclassifieds/lib/djseo.php:84
13	DJClassifiedsSEO::getItemRoute()	JROOT/components/com_djclassifieds/views/items/tmpl/default.php:359
12	include JROOT/components/com_djclassifieds/views/items/tmpl/default.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:427
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

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vreme upita: 1.10 ms Nakon poslednjeg upita: 0.03 ms Memorija za upit: 0.024 MB memorije pre upita: 4.253 MB Kolona: 1

Dupli upiti: #30 #32 #34 #36 #40 #42 #44 #46 #48 #50 #52 #60 #62 #64 #66 #68 #70 #72 #74 #76 #78 #80 #82 #84 #86 #88

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 11:55:36' 
  GROUP BY i.region_id

Objašnjenje

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

Profil

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.02 ms
preparing	0.02 ms
executing	0.01 ms
Copying to tmp table	0.02 ms
Copying to tmp table	0.80 ms
Sorting result	0.02 ms
Sending data	0.01 ms
end	0.01 ms
removing tmp table	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

Call Stack

#	Poziv	Datoteka i broj linije
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:437
15	DJClassifiedsRegion::getRegions()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:337
14	DJClassifiedsRegion::getSEOParentPath()	JROOT/administrator/components/com_djclassifieds/lib/djseo.php:84
13	DJClassifiedsSEO::getItemRoute()	JROOT/components/com_djclassifieds/views/items/tmpl/default.php:359
12	include JROOT/components/com_djclassifieds/views/items/tmpl/default.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:427
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

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vreme upita: 0.20 ms Nakon poslednjeg upita: 0.06 ms Memorija za upit: 0.024 MB memorije pre upita: 4.262 MB Kolona: 0

Dupli upiti: #29 #31 #33 #35 #37 #41 #43 #45 #47 #49 #51 #59 #61 #63 #65 #67 #69 #71 #73 #75 #77 #79 #81 #83 #85 #87

SELECT r.* 
  FROM j17_djcf_regions r 
  ORDER BY r.parent_id, r.name COLLATE utf8_polish_ci

Objašnjenje

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

Profil

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.01 ms
cleaning up	0.01 ms

Call Stack

#	Poziv	Datoteka i broj linije
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:432
15	DJClassifiedsRegion::getRegions()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:337
14	DJClassifiedsRegion::getSEOParentPath()	JROOT/administrator/components/com_djclassifieds/lib/djseo.php:84
13	DJClassifiedsSEO::getItemRoute()	JROOT/components/com_djclassifieds/views/items/tmpl/default.php:387
12	include JROOT/components/com_djclassifieds/views/items/tmpl/default.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:427
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

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vreme upita: 1.10 ms Nakon poslednjeg upita: 0.02 ms Memorija za upit: 0.024 MB memorije pre upita: 4.270 MB Kolona: 1

Dupli upiti: #30 #32 #34 #36 #38 #42 #44 #46 #48 #50 #52 #60 #62 #64 #66 #68 #70 #72 #74 #76 #78 #80 #82 #84 #86 #88

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 11:55:36' 
  GROUP BY i.region_id

Objašnjenje

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

Profil

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.03 ms
preparing	0.02 ms
executing	0.01 ms
Copying to tmp table	0.02 ms
Copying to tmp table	0.78 ms
Sorting result	0.01 ms
Sending data	0.01 ms
end	0.01 ms
removing tmp table	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

Call Stack

#	Poziv	Datoteka i broj linije
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:437
15	DJClassifiedsRegion::getRegions()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:337
14	DJClassifiedsRegion::getSEOParentPath()	JROOT/administrator/components/com_djclassifieds/lib/djseo.php:84
13	DJClassifiedsSEO::getItemRoute()	JROOT/components/com_djclassifieds/views/items/tmpl/default.php:387
12	include JROOT/components/com_djclassifieds/views/items/tmpl/default.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:427
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

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vreme upita: 0.20 ms Nakon poslednjeg upita: 0.13 ms Memorija za upit: 0.024 MB memorije pre upita: 4.279 MB Kolona: 0

Dupli upiti: #29 #31 #33 #35 #37 #39 #43 #45 #47 #49 #51 #59 #61 #63 #65 #67 #69 #71 #73 #75 #77 #79 #81 #83 #85 #87

SELECT r.* 
  FROM j17_djcf_regions r 
  ORDER BY r.parent_id, r.name COLLATE utf8_polish_ci

Objašnjenje

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

Profil

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

Call Stack

#	Poziv	Datoteka i broj linije
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:432
15	DJClassifiedsRegion::getRegions()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:337
14	DJClassifiedsRegion::getSEOParentPath()	JROOT/administrator/components/com_djclassifieds/lib/djseo.php:84
13	DJClassifiedsSEO::getItemRoute()	JROOT/components/com_djclassifieds/views/items/tmpl/default.php:359
12	include JROOT/components/com_djclassifieds/views/items/tmpl/default.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:427
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

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vreme upita: 1.18 ms Nakon poslednjeg upita: 0.03 ms Memorija za upit: 0.024 MB memorije pre upita: 4.288 MB Kolona: 1

Lovačko oružje

Lovačka puška

Vazdusne puske

Lovacki karabin 300 wincester magnum

Lovacki karabin 300 wincester magnum

Lovacki karabin 300 wincester magnum

Prodajem lovačku pušku ZCZ 16x70

Lovački oglasi

Lovački oglasi

Joomla! Debug Console

Sesija

Informacije profila

Vreme

Memorija

Iskorišćenost memorije

Upiti baze podataka

91 upita 55.64 ms

59 duplikata pronađeno!