Lovački oglasi >>Lovacke-Price.com

Kategorije

Lovački psi (0)

Lovačko oružje (6)

Lovačka oprema (1)

Lovačka odeća i obuća (0)

Terenski automobili (0)

Optika, dvogledi (0)

Lovačke lampe (0)

Ostalo (3)

Naslov oglasa	Kategorija	Cena	Postavljen
Lovačka kamera HC801M fotoklopka kamera za lov	Ostalo	13300 RSD	2020-12-17 23:10:12
Kamera za praćenje divljači lovacka kamera HC-300M	Ostalo	11400 RSD	2017-12-01 19:07:19
Lovačka puška	Lovačko oružje	400e RSD	2021-12-16 17:02:21
Lovacka kamera NOVIJI model 330M- kamera za lovce fotoklopka	Ostalo	12700 RSD	2021-12-14 15:54:42
Vazdusne puske	Lovačko oružje	6000 RSD	2021-12-13 18:27:23
Garnitura HUBERTUS	Lovačka oprema	1.00 RSD	2021-12-05 19:41:52
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

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

Lovacka kamera NOVIJI model 330M- kamera za lovce fotoklopka

Garnitura HUBERTUS

Lovačka puška

Lovačka kamera HC801M fotoklopka kamera za lov

Joomla! Debug Console

Sesija

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1642502390,
                "last": 1642502390,
                "now": 1642502390
            },
            "token": "WgOYCYY3fDyRk1Tx1W5ehvqbkYhSKrii"
        },
        "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

106 upita 109.96 ms

75 duplikata pronađeno!

3 duplikata: #16 #23 #26

2 duplikata: #27 #70

35 duplikata: #28 #30 #32 #34 #36 #38 #40 #42 #44 #46 #48 #50 #52 #54 #56 #58 #60 #62 #64 #66 #74 #76 #78 #80 #82 #84 #86 #88 #90 #92 #94 #96 #98 #100 #102

35 duplikata: #29 #31 #33 #35 #37 #39 #41 #43 #45 #47 #49 #51 #53 #55 #57 #59 #61 #63 #65 #67 #75 #77 #79 #81 #83 #85 #87 #89 #91 #93 #95 #97 #99 #101 #103

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

SELECT `data`

  FROM `j17_session`

  WHERE `session_id` = 'eb734534b09a5e4c48a478ea86130cd3'

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

nema: prikaži profil (mogući razlog je da ima više od 100 upita)

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.34 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` = 'eb734534b09a5e4c48a478ea86130cd3' 
  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

nema: prikaži profil (mogući razlog je da ima više od 100 upita)

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.94 ms Nakon poslednjeg upita: 0.11 ms Memorija za upit: 0.004 MB memorije pre upita: 1.279 MB

INSERT INTO `j17_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('eb734534b09a5e4c48a478ea86130cd3', 1, 1642502390, 0, '', 0)

Objašnjenje

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

Profil

nema: prikaži profil (mogući razlog je da ima više od 100 upita)

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.68 ms Nakon poslednjeg upita: 0.91 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

nema: prikaži profil (mogući razlog je da ima više od 100 upita)

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.36 ms Nakon poslednjeg upita: 0.84 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

nema: prikaži profil (mogući razlog je da ima više od 100 upita)

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

nema: prikaži profil (mogući razlog je da ima više od 100 upita)

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

nema: prikaži profil (mogući razlog je da ima više od 100 upita)

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.98 ms Nakon poslednjeg upita: 15.70 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.08 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.02 ms
statistics	0.05 ms
preparing	0.04 ms
executing	0.01 ms
Sorting result	0.24 ms
Sending data	0.26 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
cleaning up	0.02 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.44 ms Nakon poslednjeg upita: 4.11 ms Memorija za upit: 0.025 MB memorije pre upita: 2.628 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.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.02 ms
After opening tables	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.03 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.02 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.76 ms Nakon poslednjeg upita: 0.14 ms Memorija za upit: 0.006 MB memorije pre upita: 2.621 MB

UPDATE `j17_extensions`

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

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

Objašnjenje

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

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.06 ms
updating	0.06 ms
end	0.01 ms
Waiting for query cache lock	0.01 ms
end	0.03 ms
query end	0.38 ms
closing tables	0.03 ms
freeing items	0.01 ms
updating status	0.02 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.46 ms Nakon poslednjeg upita: 0.76 ms Memorija za upit: 0.022 MB memorije pre upita: 2.664 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.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.02 ms
preparing	0.02 ms
executing	0.01 ms
Sorting result	0.04 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.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.54 ms Nakon poslednjeg upita: 1.18 ms Memorija za upit: 0.025 MB memorije pre upita: 2.750 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.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.11 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 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.46 ms Nakon poslednjeg upita: 7.27 ms Memorija za upit: 0.023 MB memorije pre upita: 3.119 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.05 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
init	0.03 ms
optimizing	0.03 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.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 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.38 ms Nakon poslednjeg upita: 7.64 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:39:50' 
  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.05 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.01 ms
After opening tables	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 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.73 ms Nakon poslednjeg upita: 1.19 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.07 ms
checking permissions	0.06 ms
Opening tables	0.03 ms
After opening tables	0.03 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.02 ms
init	0.03 ms
optimizing	0.04 ms
statistics	0.04 ms
preparing	0.03 ms
executing	0.01 ms
Sorting result	0.04 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.07 ms
updating status	0.03 ms
cleaning up	0.02 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:139
10	DJClassifiedsCategory::getCatAllItemsCount()	JROOT/components/com_djclassifieds/views/items/view.html.php:93
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.45 ms Nakon poslednjeg upita: 0.39 ms Memorija za upit: 0.022 MB memorije pre upita: 3.882 MB Kolona: 0

Dupli upiti: #23 #26

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.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 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:139
10	DJClassifiedsCategory::getCatAllItemsCount()	JROOT/components/com_djclassifieds/views/items/view.html.php:93
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.78 ms Nakon poslednjeg upita: 0.07 ms Memorija za upit: 0.023 MB memorije pre upita: 3.893 MB Kolona: 8

SELECT * 
  FROM j17_djcf_images 
  WHERE type='category' 
  AND item_id IN (1,2,3,4,6,7,8,9) 
  GROUP BY item_id

Objašnjenje

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j17_djcf_images	ref	item_id,type	type	167	const	7	Using index condition; Using where; Using temporary; 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.11 ms
preparing	0.04 ms
executing	0.01 ms
Copying to tmp table	0.03 ms
Copying to tmp table	0.13 ms
Sorting result	0.03 ms
Sending data	0.03 ms
end	0.01 ms
removing tmp table	0.07 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 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:1101
10	DjclassifiedsModelItems->getCatImages()	JROOT/components/com_djclassifieds/views/items/view.html.php:105
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: 2.84 ms Nakon poslednjeg upita: 0.20 ms Memorija za upit: 0.049 MB memorije pre upita: 3.912 MB Kolona: 10

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 
  WHERE i.date_exp > '2022-01-18 11:39:50' 
  AND i.published=1 
  AND i.blocked=0 
  AND c.published=1  
  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	SIMPLE	r	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	0	const row not found; Using temporary; Using filesort
1	SIMPLE	c	ALL	PRIMARY,published	NO INDEX KEY COULD BE USED	NULL	NULL	9	Using where
1	SIMPLE	i	ref	cat_id,published,blocked	cat_id	4	dmaricn_lovackenovo.c.id	7	Using where

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
After opening tables	0.01 ms
init	0.07 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.05 ms
executing	0.01 ms
Copying to tmp table	0.36 ms
Copying to tmp table	1.46 ms
Sorting result	0.06 ms
Sending data	0.24 ms
end	0.02 ms
removing tmp table	0.10 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 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.82 ms Nakon poslednjeg upita: 0.11 ms Memorija za upit: 0.021 MB memorije pre upita: 3.968 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 (476,1,529,528,527,526,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.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.05 ms
executing	0.01 ms
Copying to tmp table	0.18 ms
Copying to tmp table	0.04 ms
Sorting result	0.03 ms
Sending data	0.02 ms
end	0.01 ms
removing tmp table	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 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: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.94 ms Nakon poslednjeg upita: 0.04 ms Memorija za upit: 0.030 MB memorije pre upita: 3.974 MB Kolona: 31

SELECT img.* 
  FROM j17_djcf_images img 
  WHERE img.item_id IN (476,1,529,528,527,526,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	48	Using index condition; 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.07 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.03 ms
executing	0.01 ms
Sorting result	0.24 ms
Sending data	0.21 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.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: 1.81 ms Nakon poslednjeg upita: 0.19 ms Memorija za upit: 0.022 MB memorije pre upita: 4.077 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 
  WHERE i.date_exp > '2022-01-18 11:39:50' 
  AND i.published=1 
  AND i.blocked=0 
  AND c.published=1  
  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	SIMPLE	r	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	0	const row not found
1	SIMPLE	c	ALL	PRIMARY,published	NO INDEX KEY COULD BE USED	NULL	NULL	9	Using where
1	SIMPLE	i	ref	cat_id,published,blocked	cat_id	4	dmaricn_lovackenovo.c.id	7	Using where

Profil

Status	Duration
starting	0.06 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.05 ms
optimizing	0.04 ms
statistics	0.06 ms
preparing	0.05 ms
executing	0.02 ms
Sending data	1.27 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
cleaning up	0.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.50 ms Nakon poslednjeg upita: 0.27 ms Memorija za upit: 0.025 MB memorije pre upita: 4.085 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.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.01 ms
Sorting result	0.03 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

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.38 ms Nakon poslednjeg upita: 0.04 ms Memorija za upit: 0.022 MB memorije pre upita: 4.105 MB Kolona: 0

Dupli upiti: #16 #26

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.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.02 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.01 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.02 ms

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.55 ms Nakon poslednjeg upita: 0.63 ms Memorija za upit: 0.022 MB memorije pre upita: 4.123 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.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.06 ms
optimizing	0.04 ms
statistics	0.04 ms
preparing	0.03 ms
executing	0.02 ms
Sorting result	0.05 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 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: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.44 ms Nakon poslednjeg upita: 0.10 ms Memorija za upit: 0.026 MB memorije pre upita: 4.130 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.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sorting result	0.03 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.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/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.38 ms Nakon poslednjeg upita: 0.04 ms Memorija za upit: 0.021 MB memorije pre upita: 4.150 MB Kolona: 0

Dupli upiti: #16 #23

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.02 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.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: 1.24 ms Nakon poslednjeg upita: 0.72 ms Memorija za upit: 0.027 MB memorije pre upita: 4.226 MB Kolona: 12

Dupli upiti: #70

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:39:50') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-01-18 10:39:50') 
  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.07 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.02 ms
init	0.04 ms
optimizing	0.04 ms
statistics	0.07 ms
preparing	0.05 ms
executing	0.01 ms
Sorting result	0.38 ms
Sending data	0.28 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 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.41 ms Nakon poslednjeg upita: 0.68 ms Memorija za upit: 0.024 MB memorije pre upita: 4.240 MB Kolona: 0

Dupli upiti: #30 #32 #34 #36 #38 #40 #42 #44 #46 #48 #50 #52 #54 #56 #58 #60 #62 #64 #66 #74 #76 #78 #80 #82 #84 #86 #88 #90 #92 #94 #96 #98 #100 #102

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.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.02 ms
end	0.06 ms
query end	0.01 ms
closing tables	0.02 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.78 ms Nakon poslednjeg upita: 0.05 ms Memorija za upit: 0.024 MB memorije pre upita: 4.249 MB Kolona: 1

Dupli upiti: #31 #33 #35 #37 #39 #41 #43 #45 #47 #49 #51 #53 #55 #57 #59 #61 #63 #65 #67 #75 #77 #79 #81 #83 #85 #87 #89 #91 #93 #95 #97 #99 #101 #103

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:39:50' 
  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.02 ms
After opening tables	0.01 ms
System lock	0.03 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
Copying to tmp table	0.03 ms
Copying to tmp table	1.25 ms
Sorting result	0.02 ms
Sending data	0.02 ms
end	0.01 ms
removing tmp table	0.05 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 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.31 ms Nakon poslednjeg upita: 0.09 ms Memorija za upit: 0.024 MB memorije pre upita: 4.257 MB Kolona: 0

Dupli upiti: #28 #32 #34 #36 #38 #40 #42 #44 #46 #48 #50 #52 #54 #56 #58 #60 #62 #64 #66 #74 #76 #78 #80 #82 #84 #86 #88 #90 #92 #94 #96 #98 #100 #102

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.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.02 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

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.74 ms Nakon poslednjeg upita: 0.03 ms Memorija za upit: 0.024 MB memorije pre upita: 4.266 MB Kolona: 1

Dupli upiti: #29 #33 #35 #37 #39 #41 #43 #45 #47 #49 #51 #53 #55 #57 #59 #61 #63 #65 #67 #75 #77 #79 #81 #83 #85 #87 #89 #91 #93 #95 #97 #99 #101 #103

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:39:50' 
  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.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.01 ms
Copying to tmp table	0.03 ms
Copying to tmp table	1.26 ms
Sorting result	0.03 ms
Sending data	0.02 ms
end	0.01 ms
removing tmp table	0.04 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 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.35 ms Nakon poslednjeg upita: 0.31 ms Memorija za upit: 0.024 MB memorije pre upita: 4.276 MB Kolona: 0

Dupli upiti: #28 #30 #34 #36 #38 #40 #42 #44 #46 #48 #50 #52 #54 #56 #58 #60 #62 #64 #66 #74 #76 #78 #80 #82 #84 #86 #88 #90 #92 #94 #96 #98 #100 #102

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.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.04 ms
System lock	0.01 ms
Table lock	0.02 ms
After opening tables	0.01 ms
init	0.03 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
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.72 ms Nakon poslednjeg upita: 0.03 ms Memorija za upit: 0.026 MB memorije pre upita: 4.291 MB Kolona: 1

Dupli upiti: #29 #31 #35 #37 #39 #41 #43 #45 #47 #49 #51 #53 #55 #57 #59 #61 #63 #65 #67 #75 #77 #79 #81 #83 #85 #87 #89 #91 #93 #95 #97 #99 #101 #103

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:39:50' 
  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.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.02 ms
Table lock	0.01 ms
After opening tables	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.01 ms
Copying to tmp table	0.03 ms
Copying to tmp table	1.21 ms
Sorting result	0.02 ms
Sending data	0.02 ms
end	0.01 ms
removing tmp table	0.04 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
updating status	0.06 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.32 ms Nakon poslednjeg upita: 0.06 ms Memorija za upit: 0.024 MB memorije pre upita: 4.301 MB Kolona: 0

Dupli upiti: #28 #30 #32 #36 #38 #40 #42 #44 #46 #48 #50 #52 #54 #56 #58 #60 #62 #64 #66 #74 #76 #78 #80 #82 #84 #86 #88 #90 #92 #94 #96 #98 #100 #102

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.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.02 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 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: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.74 ms Nakon poslednjeg upita: 0.03 ms Memorija za upit: 0.024 MB memorije pre upita: 4.310 MB Kolona: 1

Dupli upiti: #29 #31 #33 #37 #39 #41 #43 #45 #47 #49 #51 #53 #55 #57 #59 #61 #63 #65 #67 #75 #77 #79 #81 #83 #85 #87 #89 #91 #93 #95 #97 #99 #101 #103

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:39:50' 
  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.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.01 ms
Copying to tmp table	0.03 ms
Copying to tmp table	1.26 ms
Sorting result	0.03 ms
Sending data	0.02 ms
end	0.01 ms
removing tmp table	0.04 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 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.32 ms Nakon poslednjeg upita: 0.16 ms Memorija za upit: 0.024 MB memorije pre upita: 4.318 MB Kolona: 0

Dupli upiti: #28 #30 #32 #34 #38 #40 #42 #44 #46 #48 #50 #52 #54 #56 #58 #60 #62 #64 #66 #74 #76 #78 #80 #82 #84 #86 #88 #90 #92 #94 #96 #98 #100 #102

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.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.03 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
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.68 ms Nakon poslednjeg upita: 0.03 ms Memorija za upit: 0.024 MB memorije pre upita: 4.327 MB Kolona: 1
Dupli upiti: #29 #31 #33 #35 #39