‹ ›

Foto

Žut

Marina

Podatki

GPS	43° 52' N , 15° 17' E
Št. Privezov	120
Globina vode	1.0 - 8.0 m
Tel.	+ 385 22 786 0278
Fax	+ 385 22 786 0279
Obratovalni čas	15.3. - 30.10.
e-mail	m.zut@aci-club.hr
web	www.aci-marinas.com
Bencinska črpalka	8 NM Zaglav

Info

Marina se nahaja na SV obali otoka v zalivu Podražanj, ki je del zaliva Žut. Ob močni burji priporočamo privez na severnem kraku pomola v marini, ob južnem vetru pa so najbolj ugodni privezi na južnem delu pomola. Ker so zaloge vode omejene, je možna le nujna oskrba z vodo. V kolikor v marini ne najdete praznih privezov, lahko v neposredni bližini tudi sidrate. Dno dobro drži. Priporočamo privez plovila s krmo na obalo. V primeru južnega vetra priporočamo sidranje v južnem delu zaliva.

Ponudba

restavracija

recepcija

menjalnica

telefon

Samopostrežna trgovina

WC in tuš

Zaščita pred vetrovi/Vreme

Danes

Jutri

Nedelja

V bližini

Fešta Gostilna 0.24 nmi
Žešnja Sidrišče 0.67 nmi
Bodovac Sidrišče 0.83 nmi

Zaščiteno

6,1,12,1,12,1,12,1,12,1,12,1,12,1,12,1,6
Žešnja Sidrišče 0.67 nmi
6,1,12,1,12,1,12,1,12,1,12,1,12,1,12,1,6
Pinizel donji Sidrišče 1.07 nmi
6,1,12,1,12,1,12,1,12,1,12,1,12,1,12,1,6
Vela Svršata North Sidrišče 1.36 nmi

Rezervacija priveza

Rezerviraj

Cene

24.07.2013	480/marina HRK /dan
12.07.2012	300/boja kuna

Za dodajanje cene se morate prijaviti!

Komentarji

0908

Res je ni potrebe da rinemo v aci marino,vendar se zaston vezemo v bliznih dveh gostilnah ce pri njih jemo. Z cenami hrane in pijace pa nas ubijejo

Tue | 11 Aug | 2020

0908

V gostilni Festa 1x kava z mlekom 1x bela kava 1x sok marelica,voda pri kavi avtomacko flasirana jana ze odprta steklenica skupaj 124 kun - v gostilni Sandra cene pijace malo bol normalne Cene hrane pa ubijejo v obeh za 100% visje kot drugot

Tue | 11 Aug | 2020

PikiPoki

Ni potrebno, da vsi rinemo v drago Marino Žut, na njihove boje, ali da iščemo kako "luknjo", da ne bi plačali sidrenja ali bivanja v tem lepem zalivu. V Gostilni Sandra, med Gostilno Fešta in Marino Žut, je privez zastonj, cca. 20 mooringov, voda 4 m, malo vode, če je velika nuja in zvečer elektrika, ko vklopijo generator. Čista stranišča, odprta tudi ponoči. Nekaj pa seveda moramo pojesti. Saj smo na dopustu in vseskozi lačni dobrega! In gazda Damir, edini še ta pravi ribič na tem koncu in daleč naokoli je že zjutraj nazaj s svežimi ribami. Speče tisto, kar ulovi. Imajo še nekaj malenkosti kot so blitva, krompir, školjke, sladica, palačinke, ... Cena normalna, kvaliteta "prva liga". Pa še svež kruh ti lahko zjutraj speče šefica za na pot. Vsekakor mnogo bolje od vsega "umetnega in iz daljnih krajev" (beri zmrznjenih starih atlantskih, maroških rib, ...) daleč naokoli.

Mon | 03 Sep | 2012

Vinko Faladore

Del praznega prostora primernega za sidranje, je ACI opremil z bojami, ki so najdražje na Jadranu. Za sidranje je ostalo tik pred obalo mogoče za 4 plovila, ki pa jih poznavalci razmer hitro zasedejo. Preostane samo sredina zaliva, pa še to po novi zakonodaji kar precej daleč od meja s koncesijo pridobljenih pravic. Izjemno lepo, vendar izjemno drago, od piva dalje.n5

Fri | 31 Aug | 2012

Joomla! Konzola razhroščevanja

Seja

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1620417907,
                "last": 1620417907,
                "now": 1620417907
            }
        },
        "registry": {
            "location_state": {
                "address": null,
                "country_name": null,
                "state_name": null,
                "city_name": null,
                "area_name": null,
                "country_id": null,
                "state_id": null,
                "city_id": null,
                "area_id": null,
                "postalcode": null,
                "latitude": null,
                "longitude": null,
                "user_request": null,
                "active_location": null,
                "active_location_name": null,
                "active_location_ids": null,
                "iscapture_radius": "0",
                "geostatus": "0"
            }
        },
        "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
        },
        "plg_system_languagefilter": {
            "language": "sl-SI"
        }
    }
}

Podatki o profilu

Čas

Spomin

Čas: 28.69 ms / 28.69 ms Spomin: 0.565 MB / 0.95 MB Application: afterLoad

Čas: 80.68 ms / 109.37 ms Spomin: 1.431 MB / 2.38 MB Application: afterInitialise

Čas: 39.64 ms / 149.01 ms Spomin: 0.705 MB / 3.08 MB Application: afterRoute

Čas: 1.09 ms / 150.10 ms Spomin: 0.104 MB / 3.19 MB Application: beforeRenderComponent com_vodnikpojadranu

Čas: 80.22 ms / 230.32 ms Spomin: 0.501 MB / 3.69 MB Application: afterRenderComponent com_vodnikpojadranu

Čas: 5.86 ms / 236.18 ms Spomin: 0.018 MB / 3.71 MB Application: afterDispatch

Čas: 5.25 ms / 241.43 ms Spomin: 0.150 MB / 3.86 MB Application: beforeRenderModule mod_banners (Banner bottom)

Čas: 9.02 ms / 250.44 ms Spomin: 0.059 MB / 3.91 MB Application: afterRenderModule mod_banners (Banner bottom)

Čas: 0.13 ms / 250.58 ms Spomin: 0.000 MB / 3.91 MB Application: beforeRenderModule mod_banners (Banner top)

Čas: 5.18 ms / 255.76 ms Spomin: 0.037 MB / 3.95 MB Application: afterRenderModule mod_banners (Banner top)

Čas: 0.13 ms / 255.89 ms Spomin: 0.000 MB / 3.94 MB Application: beforeRenderModule mod_languages (Language switcher)

Čas: 6.13 ms / 262.02 ms Spomin: 0.038 MB / 3.98 MB Application: afterRenderModule mod_languages (Language switcher)

Čas: 0.11 ms / 262.13 ms Spomin: 0.000 MB / 3.98 MB Application: beforeRenderModule mod_menu (Main Menu)

Čas: 8.05 ms / 270.18 ms Spomin: 0.137 MB / 4.11 MB Application: afterRenderModule mod_menu (Main Menu)

Čas: 0.06 ms / 270.25 ms Spomin: 0.000 MB / 4.11 MB Application: beforeRenderModule mod_menu (English menu)

Čas: 0.53 ms / 270.78 ms Spomin: 0.004 MB / 4.11 MB Application: afterRenderModule mod_menu (English menu)

Čas: 6.40 ms / 277.18 ms Spomin: 0.149 MB / 4.26 MB Application: Before Access::preloadComponents (all components)

Čas: 1.19 ms / 278.37 ms Spomin: 0.057 MB / 4.32 MB Application: After Access::preloadComponents (all components)

Čas: 0.04 ms / 278.41 ms Spomin: 0.000 MB / 4.32 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Čas: 0.93 ms / 279.34 ms Spomin: 0.009 MB / 4.32 MB Application: After Access::getAssetRules (id:1 name:root.1)

Čas: 4.01 ms / 283.35 ms Spomin: 0.077 MB / 4.40 MB Application: afterRender

Baza podatkov poizvedbe skupaj: 79.15 ms

Uporaba pomnilnika

Baza podatkov poizvedbe

64 poizvedb zabeleženo 79.15 ms

14 podvajanj najdenih

3 podvajanj: #11 #17 #63

2 podvajanj: #14 #18

2 podvajanj: #21 #24

5 podvajanj: #39 #40 #41 #42 #43

2 podvajanj: #53 #58

Čas poizvedbe: 0.31 ms Poizvedba pomnilnika: 0.025 MB Spomin pred poizvedbi:1.219 MB Vrstic vrnil: 0

SELECT `data`

  FROM `nov_session`

  WHERE `session_id` = X'30336461696a61706c666272676c636434307238396e33317576'

Pojasnilo

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

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.00 ms
updating status	0.03 ms
cleaning up	0.00 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Enako kot klic v vrstici spodaj.
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

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 0.31 ms Po zadnji poizvedbi: 1.59 ms Poizvedba pomnilnika: 0.022 MB Spomin pred poizvedbi:1.297 MB Vrstic vrnil: 0

SELECT `session_id`

  FROM `nov_session`

  WHERE `session_id` = X'30336461696a61706c666272676c636434307238396e33317576' 
  LIMIT 1

Pojasnilo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nov_session	const	PRIMARY	PRIMARY	194	const	1	Using index

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.03 ms
cleaning up	0.00 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php: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

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 2.21 ms Po zadnji poizvedbi: 0.13 ms Poizvedba pomnilnika: 0.004 MB Spomin pred poizvedbi:1.302 MB

INSERT INTO `nov_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'30336461696a61706c666272676c636434307238396e33317576', 1, 1620417907, 0, '', 0)

Pojasnilo

Pojasnilo ni na voljo za poizvedbo: INSERT INTO `nov_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'30336461696a61706c666272676c636434307238396e33317576', 1, 1620417907, 0, '', 0)

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
update	0.05 ms
end	0.00 ms
query end	1.87 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.05 ms
cleaning up	0.00 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
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

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 0.69 ms Po zadnji poizvedbi: 4.76 ms Poizvedba pomnilnika: 0.029 MB Spomin pred poizvedbi:1.338 MB Vrstic vrnil: 36

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `nov_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Pojasnilo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nov_extensions	ref	extension	extension	82	const	38	Using index condition; Using where

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.19 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.05 ms
cleaning up	0.01 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Enako kot klic v vrstici spodaj.
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

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 0.28 ms Po zadnji poizvedbi: 3.22 ms Poizvedba pomnilnika: 0.023 MB Spomin pred poizvedbi:1.369 MB Vrstic vrnil: 5

SELECT id, rules

  FROM `nov_viewlevels`

Pojasnilo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nov_viewlevels	ALL	NULL	NO INDEX KLJUČ SE LAHKO UPORABLJA	NULL	NULL	5

Profil

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.00 ms
updating status	0.03 ms
cleaning up	0.01 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php: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

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 0.30 ms Po zadnji poizvedbi: 0.13 ms Poizvedba pomnilnika: 0.022 MB Spomin pred poizvedbi:1.381 MB Vrstic vrnil: 2

SELECT b.id

  FROM nov_usergroups AS a

  LEFT JOIN nov_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9

Pojasnilo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	3	Using where; Using index

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.00 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php: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

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 1.14 ms Po zadnji poizvedbi: 0.17 ms Poizvedba pomnilnika: 0.034 MB Spomin pred poizvedbi:1.402 MB Vrstic vrnil: 105

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM nov_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,5)

  ORDER BY ordering

Pojasnilo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nov_extensions	ref	extension	extension	82	const	201	Using index condition; Using where; Uporabi filesort

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.55 ms
Sending data	0.27 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.00 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Enako kot klic v vrstici spodaj.
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

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 0.32 ms Po zadnji poizvedbi: 0.93 ms Poizvedba pomnilnika: 0.025 MB Spomin pred poizvedbi:1.458 MB Vrstic vrnil: 3

SELECT *

  FROM nov_languages

  WHERE published=1

  ORDER BY ordering ASC

Pojasnilo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nov_languages	ALL	NULL	NO INDEX KLJUČ SE LAHKO UPORABLJA	NULL	NULL	3	Using where; Uporabi filesort

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.02 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.03 ms
cleaning up	0.00 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Language/LanguageHelper.php:67
4	Joomla\CMS\Language\LanguageHelper::detectLanguage()	JROOT/libraries/src/Application/SiteApplication.php:653
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

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 0.48 ms Po zadnji poizvedbi: 12.74 ms Poizvedba pomnilnika: 0.027 MB Spomin pred poizvedbi:1.891 MB Vrstic vrnil: 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `nov_extensions`

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

Pojasnilo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nov_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using index condition

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.02 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.04 ms
cleaning up	0.00 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
16	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Enako kot klic v vrstici spodaj.
15	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
13	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
12	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
11	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
10	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
9	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
8	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jomclassifiedslocationmanager/jomclassifiedslocationmanager.php:18
7	plgSystemJomclassifiedsLocationManager->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 0.82 ms Po zadnji poizvedbi: 0.23 ms Poizvedba pomnilnika: 0.006 MB Spomin pred poizvedbi:1.884 MB

UPDATE `nov_extensions`

  SET `params` = '{\"mediaversion\":\"120e9b411f2e6b23944d30d4de40f25c\"}'

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

Pojasnilo

Pojasnilo ni na voljo za poizvedbo: UPDATE `nov_extensions` SET `params` = '{\"mediaversion\":\"120e9b411f2e6b23944d30d4de40f25c\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.06 ms
Updating	0.04 ms
end	0.01 ms
query end	0.38 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.00 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
12	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
11	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
10	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
9	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
8	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jomclassifiedslocationmanager/jomclassifiedslocationmanager.php:18
7	plgSystemJomclassifiedsLocationManager->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 0.33 ms Po zadnji poizvedbi: 1.22 ms Poizvedba pomnilnika: 0.034 MB Spomin pred poizvedbi:1.967 MB Vrstic vrnil: 133

Podvojene poizvedbe: #17 #63

SELECT name,value 
  FROM nov_jomcl_options

Pojasnilo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nov_jomcl_options	ALL	NULL	NO INDEX KLJUČ SE LAHKO UPORABLJA	NULL	NULL	133

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.07 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.00 ms
updating status	0.03 ms
cleaning up	0.00 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jomclassifiedslocationmanager/jomclassifiedslocationmanager.php:398
8	plgSystemJomclassifiedsLocationManager->getCfg()	JROOT/plugins/system/jomclassifiedslocationmanager/jomclassifiedslocationmanager.php:19
7	plgSystemJomclassifiedsLocationManager->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 0.93 ms Po zadnji poizvedbi: 2.51 ms Poizvedba pomnilnika: 0.023 MB Spomin pred poizvedbi:2.010 MB Vrstic vrnil: 6

SELECT `element`,`name`,`client_id`,`extension_id`

  FROM `nov_extensions`

  WHERE `type` = 'language' 
  AND `state` = 0 
  AND `enabled` = 1

Pojasnilo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nov_extensions	ref	extension	extension	82	const	6	Using index condition; Using where

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After table lock	0.01 ms
init	0.04 ms
optimizing	0.04 ms
statistics	0.09 ms
preparing	0.05 ms
executing	0.02 ms
Sending data	0.16 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.08 ms
cleaning up	0.01 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:209
8	Joomla\CMS\Language\LanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:110
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 1.08 ms Po zadnji poizvedbi: 16.78 ms Poizvedba pomnilnika: 0.083 MB Spomin pred poizvedbi:2.079 MB Vrstic vrnil: 50

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 nov_menu AS m

  LEFT JOIN nov_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

Pojasnilo

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	51	Using index condition; Using where; Uporabi filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	enavtika_db.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.02 ms
After table lock	0.00 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.18 ms
Sending data	0.39 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
20	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Enako kot klic v vrstici spodaj.
19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
17	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
16	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
15	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
14	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
13	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
12	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:434
11	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/mvcoverride/mvcoverride.php:999
10	PlgSystemMVCOverride->_getIncludePaths()	JROOT/plugins/system/mvcoverride/mvcoverride.php:474
9	PlgSystemMVCOverride->_autoOverride()	JROOT/plugins/system/mvcoverride/mvcoverride.php:146
8	PlgSystemMVCOverride->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 0.43 ms Po zadnji poizvedbi: 1.08 ms Poizvedba pomnilnika: 0.024 MB Spomin pred poizvedbi:2.272 MB Vrstic vrnil: 3

Podvojene poizvedbe: #18

SELECT id, home, template, s.params

  FROM nov_template_styles as s

  LEFT JOIN nov_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

Pojasnilo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	Using index condition; Using where
1	SIMPLE	s	ALL	idx_template	NO INDEX KLJUČ SE LAHKO UPORABLJA	NULL	NULL	5	Using where; Using join buffer (flat, BNL join)

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.00 ms
updating status	0.03 ms
cleaning up	0.00 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
11	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/mvcoverride/mvcoverride.php:999
10	PlgSystemMVCOverride->_getIncludePaths()	JROOT/plugins/system/mvcoverride/mvcoverride.php:474
9	PlgSystemMVCOverride->_autoOverride()	JROOT/plugins/system/mvcoverride/mvcoverride.php:146
8	PlgSystemMVCOverride->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 0.59 ms Po zadnji poizvedbi: 33.91 ms Poizvedba pomnilnika: 0.025 MB Spomin pred poizvedbi:3.019 MB Vrstic vrnil: 0

SELECT *

  FROM `nov_location_types_migrirana`

  WHERE `slug`='marina:zut-zut' 
  LIMIT 1

Pojasnilo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KLJUČ SE LAHKO UPORABLJA	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.00 ms
After table lock	0.01 ms
init	0.03 ms
optimizing	0.04 ms
statistics	0.05 ms
preparing	0.00 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.05 ms
cleaning up	0.01 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:5110
11	LocationType::findByAlias()	JROOT/components/com_vodnikpojadranu/router.php:80
10	vodnikpojadranuParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
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

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 0.58 ms Po zadnji poizvedbi: 0.19 ms Poizvedba pomnilnika: 0.028 MB Spomin pred poizvedbi:3.025 MB Vrstic vrnil: 1

SELECT *

  FROM `nov_locations`

  WHERE `alias`='marina-zut-zut' 
  LIMIT 1

Pojasnilo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nov_locations	ALL	NULL	NO INDEX KLJUČ SE LAHKO UPORABLJA	NULL	NULL	1903	Using where

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.25 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.00 ms
updating status	0.03 ms
cleaning up	0.00 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:3731
11	Location::findByAlias()	JROOT/components/com_vodnikpojadranu/router.php:86
10	vodnikpojadranuParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
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

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 0.50 ms Po zadnji poizvedbi: 2.74 ms Poizvedba pomnilnika: 0.035 MB Spomin pred poizvedbi:3.051 MB Vrstic vrnil: 133

Podvojene poizvedbe: #11 #63

SELECT name,value 
  FROM nov_jomcl_options

Pojasnilo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nov_jomcl_options	ALL	NULL	NO INDEX KLJUČ SE LAHKO UPORABLJA	NULL	NULL	133

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.07 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.04 ms
cleaning up	0.00 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jomclassifiedslocationmanager/jomclassifiedslocationmanager.php:398
9	plgSystemJomclassifiedsLocationManager->getCfg()	JROOT/plugins/system/jomclassifiedslocationmanager/jomclassifiedslocationmanager.php:111
8	plgSystemJomclassifiedsLocationManager->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

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 0.47 ms Po zadnji poizvedbi: 2.55 ms Poizvedba pomnilnika: 0.027 MB Spomin pred poizvedbi:3.089 MB Vrstic vrnil: 3

Podvojene poizvedbe: #14

SELECT id, home, template, s.params

  FROM nov_template_styles as s

  LEFT JOIN nov_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

Pojasnilo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	Using index condition; Using where
1	SIMPLE	s	ALL	idx_template	NO INDEX KLJUČ SE LAHKO UPORABLJA	NULL	NULL	5	Using where; Using join buffer (flat, BNL join)

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.02 ms
optimizing	0.03 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.07 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.00 ms
updating status	0.03 ms
cleaning up	0.00 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
18	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/HTML/HTMLHelper.php:365
17	Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles()	JROOT/libraries/src/HTML/HTMLHelper.php:712
16	Joomla\CMS\HTML\HTMLHelper::script()	Enako kot klic v vrstici spodaj.
15	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
14	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
13	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/jquery.php:52
12	JHtmlJquery::framework()	Enako kot klic v vrstici spodaj.
11	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
10	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
9	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/plugins/system/jomclassifiedslocationmanager/jomclassifiedslocationmanager.php:117
8	plgSystemJomclassifiedsLocationManager->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

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 2.96 ms Po zadnji poizvedbi: 8.49 ms Poizvedba pomnilnika: 0.028 MB Spomin pred poizvedbi:3.310 MB Vrstic vrnil: 1

SELECT *

  FROM `nov_locations`

  WHERE `alias` LIKE '%marina-zut-zut%' 
  AND `published` = 1

Pojasnilo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nov_locations	ALL	NULL	NO INDEX KLJUČ SE LAHKO UPORABLJA	NULL	NULL	1903	Using where

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	2.61 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.04 ms
cleaning up	0.00 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:146
9	VodnikPoJadranuModelVodnikPoJadranu->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:496
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:36
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.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

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 0.45 ms Po zadnji poizvedbi: 0.16 ms Poizvedba pomnilnika: 0.028 MB Spomin pred poizvedbi:3.319 MB Vrstic vrnil: 1

SELECT *

  FROM `nov_data` AS d

  LEFT JOIN nov_data_types AS dt 
  ON dt.id = d.type

  WHERE `d`.`location` = 257 
  AND `dt`.`output`=6

Pojasnilo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	d	ref	type,location	location	5	const	20	Using where
1	SIMPLE	dt	eq_ref	PRIMARY	PRIMARY	4	enavtika_db.d.type	1	Using where

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.11 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.00 ms
updating status	0.03 ms
cleaning up	0.00 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:4397
9	Location->getWind()	JROOT/components/com_vodnikpojadranu/controller.php:501
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:36
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.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

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 0.27 ms Po zadnji poizvedbi: 1.37 ms Poizvedba pomnilnika: 0.025 MB Spomin pred poizvedbi:3.334 MB Vrstic vrnil: 1

Podvojene poizvedbe: #24

SELECT *

  FROM `nov_location_types_migrirana`

  WHERE `slug`='dogodek' 
  LIMIT 1

Pojasnilo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nov_location_types_migrirana	const	slug	slug	767	const	1

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.02 ms
cleaning up	0.00 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:5110
10	LocationType::findByAlias()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:611
9	VodnikPoJadranuModelVodnikPoJadranu->getNearbyLocations()	JROOT/components/com_vodnikpojadranu/controller.php:508
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:36
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.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

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 0.24 ms Po zadnji poizvedbi: 0.27 ms Poizvedba pomnilnika: 0.025 MB Spomin pred poizvedbi:3.346 MB Vrstic vrnil: 1

SELECT *

  FROM `nov_data_types`

  WHERE `output`=6 
  LIMIT 1

Pojasnilo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nov_data_types	ALL	NULL	NO INDEX KLJUČ SE LAHKO UPORABLJA	NULL	NULL	78	Using where

Profil

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.02 ms
cleaning up	0.00 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:4987
10	DataType::FindByOutput()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:627
9	VodnikPoJadranuModelVodnikPoJadranu->getNearbyLocations()	JROOT/components/com_vodnikpojadranu/controller.php:508
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:36
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.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

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 10.62 ms Po zadnji poizvedbi: 0.12 ms Poizvedba pomnilnika: 0.028 MB Spomin pred poizvedbi:3.353 MB Vrstic vrnil: 3

SELECT DISTINCT l.*,(6371 * acos(cos(radians(43.882923)) * cos(radians(l.lat)) * cos(radians(l.lng) - radians(15.284858)) + sin(radians(43.882923)) * sin(radians(l.lat)))) AS distance

  FROM nov_locations AS l

  LEFT JOIN (SELECT * 
  FROM nov_events) AS e 
  ON l.id = e.locationid

  LEFT JOIN (SELECT location, value 
  FROM nov_data 
  WHERE type = 1) AS d 
  ON l.id = d.location

  WHERE `l`.`published` = 1 
  AND ((l.type != 10) OR (e.status = 1 
  AND e.end >= '2021-05-07 22:05:07')) 
  AND l.lat != 43.882923 
  AND l.lng != 15.284858 
  AND d.value REGEXP '([0-1]{4}111[0-1]{1})'

  ORDER BY distance ASC 
  LIMIT 3

Pojasnilo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nov_data	ref	type,location	type	5	const	1141	Using where; Using temporary; Uporabi filesort
1	SIMPLE	l	eq_ref	PRIMARY	PRIMARY	4	enavtika_db.nov_data.location	1	Using where
1	SIMPLE	nov_events	ref	locationid	locationid	4	enavtika_db.nov_data.location	1	Using where; Distinct

Profil

Status	Duration
starting	0.10 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.11 ms
optimizing	0.03 ms
statistics	0.06 ms
preparing	0.04 ms
executing	0.00 ms
Creating tmp table	0.36 ms
Copying to tmp table	9.08 ms
Sorting result	0.32 ms
Sending data	0.08 ms
end	0.00 ms
removing tmp table	0.19 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.00 ms
closing tables	0.00 ms
removing tmp table	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
updating status	0.04 ms
cleaning up	0.01 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:678
9	VodnikPoJadranuModelVodnikPoJadranu->getNearbyLocations()	JROOT/components/com_vodnikpojadranu/controller.php:508
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:36
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.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

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 0.30 ms Po zadnji poizvedbi: 0.22 ms Poizvedba pomnilnika: 0.025 MB Spomin pred poizvedbi:3.363 MB Vrstic vrnil: 1

Podvojene poizvedbe: #21

SELECT *

  FROM `nov_location_types_migrirana`

  WHERE `slug`='dogodek' 
  LIMIT 1

Pojasnilo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nov_location_types_migrirana	const	slug	slug	767	const	1

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.03 ms
cleaning up	0.00 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:5110
10	LocationType::findByAlias()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:611
9	VodnikPoJadranuModelVodnikPoJadranu->getNearbyLocations()	JROOT/components/com_vodnikpojadranu/controller.php:509
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:36
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.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

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 29.13 ms Po zadnji poizvedbi: 0.16 ms Poizvedba pomnilnika: 0.028 MB Spomin pred poizvedbi:3.371 MB Vrstic vrnil: 3

SELECT DISTINCT l.*,(6371 * acos(cos(radians(43.882923)) * cos(radians(l.lat)) * cos(radians(l.lng) - radians(15.284858)) + sin(radians(43.882923)) * sin(radians(l.lat)))) AS distance

  FROM nov_locations AS l

  LEFT JOIN (SELECT * 
  FROM nov_events) AS e 
  ON l.id = e.locationid

  WHERE `l`.`published` = 1 
  AND ((l.type != 10) OR (e.status = 1 
  AND e.end >= '2021-05-07 22:05:07')) 
  AND l.lat != 43.882923 
  AND l.lng != 15.284858

  ORDER BY distance ASC 
  LIMIT 3

Pojasnilo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	l	ALL	NULL	NO INDEX KLJUČ SE LAHKO UPORABLJA	NULL	NULL	1903	Using where; Using temporary; Uporabi filesort
1	SIMPLE	nov_events	ref	locationid	locationid	4	enavtika_db.l.id	1	Using where; Distinct

Profil

Status	Duration
starting	0.09 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.07 ms
optimizing	0.03 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.00 ms
Creating tmp table	0.30 ms
Copying to tmp table	26.92 ms
Sorting result	0.98 ms
Sending data	0.08 ms
end	0.01 ms
removing tmp table	0.32 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
updating status	0.05 ms
cleaning up	0.01 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:678
9	VodnikPoJadranuModelVodnikPoJadranu->getNearbyLocations()	JROOT/components/com_vodnikpojadranu/controller.php:509
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:36
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.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

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 0.54 ms Po zadnji poizvedbi: 0.28 ms Poizvedba pomnilnika: 0.025 MB Spomin pred poizvedbi:3.384 MB Vrstic vrnil: 2

SELECT d.id, d.value, t.name AS unit, d.type, d.created, d.created_by, d.location

  FROM nov_data AS d

  LEFT JOIN nov_data_types AS t 
  ON t.id = d.type

  WHERE `t`.`output` = 5 
  AND `d`.`location` = 257

  ORDER BY d.created DESC 
  LIMIT 3

Pojasnilo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	d	ref	type,location	location	5	const	20	Using where; Uporabi filesort
1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	enavtika_db.d.type	1	Using where

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.06 ms
Sending data	0.07 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.00 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:4717
9	Price::findManyByLocation()	JROOT/components/com_vodnikpojadranu/controller.php:513
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:36
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.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

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 0.29 ms Po zadnji poizvedbi: 0.17 ms Poizvedba pomnilnika: 0.024 MB Spomin pred poizvedbi:3.390 MB Vrstic vrnil: 20

SELECT id as datatypeid, name as datatypename

  FROM `nov_data_types`

  WHERE `output` = 1

  GROUP BY id

Pojasnilo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nov_data_types	index	NULL	PRIMARY	4	NULL	78	Using where

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.00 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.02 ms
cleaning up	0.00 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:189
9	VodnikPoJadranuModelVodnikPoJadranu->getDataTypes()	JROOT/components/com_vodnikpojadranu/controller.php:514
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:36
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.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

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 0.23 ms Po zadnji poizvedbi: 0.11 ms Poizvedba pomnilnika: 0.023 MB Spomin pred poizvedbi:3.398 MB Vrstic vrnil: 1

SELECT id as datatypeid, name as datatypename

  FROM `nov_data_types`

  WHERE `output` = 3

  GROUP BY id

Pojasnilo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nov_data_types	index	NULL	PRIMARY	4	NULL	78	Using where

Profil

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.02 ms
cleaning up	0.00 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:189
9	VodnikPoJadranuModelVodnikPoJadranu->getDataTypes()	JROOT/components/com_vodnikpojadranu/controller.php:515
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:36
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.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

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 0.23 ms Po zadnji poizvedbi: 0.08 ms Poizvedba pomnilnika: 0.024 MB Spomin pred poizvedbi:3.404 MB Vrstic vrnil: 9

SELECT id as datatypeid, name as datatypename

  FROM `nov_data_types`

  WHERE `output` = 2

  GROUP BY id

Pojasnilo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nov_data_types	index	NULL	PRIMARY	4	NULL	78	Using where

Profil

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.02 ms
cleaning up	0.00 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:189
9	VodnikPoJadranuModelVodnikPoJadranu->getDataTypes()	JROOT/components/com_vodnikpojadranu/controller.php:516
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:36
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.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

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 0.27 ms Po zadnji poizvedbi: 0.10 ms Poizvedba pomnilnika: 0.027 MB Spomin pred poizvedbi:3.409 MB Vrstic vrnil: 17

SELECT *

  FROM `nov_location_types_migrirana` AS lt

  ORDER BY lt.
  order ASC

Pojasnilo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	lt	ALL	NULL	NO INDEX KLJUČ SE LAHKO UPORABLJA	NULL	NULL	17	Uporabi filesort

Profil

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.03 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.03 ms
cleaning up	0.00 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:162
9	VodnikPoJadranuModelVodnikPoJadranu->getLocationTypes()	JROOT/components/com_vodnikpojadranu/controller.php:517
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:36
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.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

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 0.82 ms Po zadnji poizvedbi: 0.79 ms Poizvedba pomnilnika: 0.027 MB Spomin pred poizvedbi:3.445 MB Vrstic vrnil: 1

SELECT d.id as dataid, d.type as datatypeid, d.type as datatypeid,  d.value as value, t.alias as alias, t.name as datatype, t.output, t.ordering

  FROM nov_data as d

  LEFT JOIN nov_data_types AS t 
  ON t.id = d.type

  WHERE `d`.`location` = 257 
  AND `t`.`output` = 3 
  AND `d`.`lang` = 'sl-SI'

  ORDER BY t.ordering ASC

Pojasnilo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	d	ref	type,location	location	5	const	20	Using where; Using temporary; Uporabi filesort
1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	enavtika_db.d.type	1	Using where

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.00 ms
Creating tmp table	0.28 ms
Copying to tmp table	0.10 ms
Sorting result	0.02 ms
Sending data	0.02 ms
end	0.00 ms
removing tmp table	0.07 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.00 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:3943
13	Location->getHTMLData()	JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php:7
12	include JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
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_vodnikpojadranu/views/location/view.html.php:16
9	VodnikPoJadranuViewLocation->display()	JROOT/components/com_vodnikpojadranu/controller.php:518
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:36
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.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

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 1.46 ms Po zadnji poizvedbi: 0.13 ms Poizvedba pomnilnika: 0.028 MB Spomin pred poizvedbi:3.454 MB Vrstic vrnil: 8

SELECT d.id as dataid, d.type as datatypeid, d.type as datatypeid,  d.value as value, t.alias as alias, t.name as datatype, t.output, t.ordering

  FROM nov_data as d

  LEFT JOIN nov_data_types AS t 
  ON t.id = d.type

  WHERE `d`.`location` = 257 
  AND `t`.`output` = 1

  ORDER BY t.ordering ASC

Pojasnilo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	d	ref	type,location	location	5	const	20	Using where; Using temporary; Uporabi filesort
1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	enavtika_db.d.type	1	Using where

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 ms
Creating tmp table	0.22 ms
Copying to tmp table	0.11 ms
Sorting result	0.02 ms
Sending data	0.02 ms
end	0.00 ms
removing tmp table	0.79 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.00 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:3884
13	Location->getTableData()	JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php:8
12	include JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
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_vodnikpojadranu/views/location/view.html.php:16
9	VodnikPoJadranuViewLocation->display()	JROOT/components/com_vodnikpojadranu/controller.php:518
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:36
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.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

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 0.28 ms Po zadnji poizvedbi: 0.13 ms Poizvedba pomnilnika: 0.026 MB Spomin pred poizvedbi:3.472 MB Vrstic vrnil: 3

SELECT lang_code, title_native, image 
  FROM nov_languages 
  ORDER BY sef ASC

Pojasnilo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nov_languages	ALL	NULL	NO INDEX KLJUČ SE LAHKO UPORABLJA	NULL	NULL	3	Uporabi filesort

Profil

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.02 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.03 ms
cleaning up	0.01 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php:26
12	include JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
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_vodnikpojadranu/views/location/view.html.php:16
9	VodnikPoJadranuViewLocation->display()	JROOT/components/com_vodnikpojadranu/controller.php:518
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:36
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.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

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 0.24 ms Po zadnji poizvedbi: 0.16 ms Poizvedba pomnilnika: 0.027 MB Spomin pred poizvedbi:3.484 MB Vrstic vrnil: 1

SELECT *

  FROM `nov_galleries`

  WHERE `id`=247 
  LIMIT 1

Pojasnilo

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

Profil

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.02 ms
cleaning up	0.00 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:4261
13	Location->gallery()	JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php:43
12	include JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
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_vodnikpojadranu/views/location/view.html.php:16
9	VodnikPoJadranuViewLocation->display()	JROOT/components/com_vodnikpojadranu/controller.php:518
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:36
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.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

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 0.80 ms Po zadnji poizvedbi: 6.81 ms Poizvedba pomnilnika: 0.028 MB Spomin pred poizvedbi:3.499 MB Vrstic vrnil: 0

SELECT *

  FROM `nov_gallery_items`

  WHERE `galleryid`=247 
  AND `type`= 'youtube'

  ORDER BY id ASC

Pojasnilo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nov_gallery_items	index	NULL	PRIMARY	4	NULL	416	Using where

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.01 ms
Sending data	0.44 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.04 ms
cleaning up	0.00 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:1386
14	Gallery->youtube()	JROOT/components/com_vodnikpojadranu/views/location/tmpl/gallery.php:33
13	require JROOT/components/com_vodnikpojadranu/views/location/tmpl/gallery.php	JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php:46
12	include JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
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_vodnikpojadranu/views/location/view.html.php:16
9	VodnikPoJadranuViewLocation->display()	JROOT/components/com_vodnikpojadranu/controller.php:518
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:36
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.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

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 0.36 ms Po zadnji poizvedbi: 0.18 ms Poizvedba pomnilnika: 0.026 MB Spomin pred poizvedbi:3.506 MB Vrstic vrnil: 1

SELECT *

  FROM `nov_location_types_migrirana`

  WHERE `id` = 1

Pojasnilo

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

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.00 ms
updating status	0.03 ms
cleaning up	0.00 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:4147
13	Location->getLocationType()	JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php:50
12	include JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
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_vodnikpojadranu/views/location/view.html.php:16
9	VodnikPoJadranuViewLocation->display()	JROOT/components/com_vodnikpojadranu/controller.php:518
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:36
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.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

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 1.12 ms Po zadnji poizvedbi: 1.02 ms Poizvedba pomnilnika: 0.027 MB Spomin pred poizvedbi:3.531 MB Vrstic vrnil: 6

SELECT d.id as dataid, d.type as datatypeid, d.type as datatypeid,  d.value as value, t.alias as alias, t.name as datatype, t.output, t.ordering

  FROM nov_data as d

  LEFT JOIN nov_data_types AS t 
  ON t.id = d.type

  WHERE `d`.`location` = 257 
  AND `t`.`output` = 2 
  AND `d`.`lang` = 'sl-SI'

  ORDER BY t.ordering ASC

Pojasnilo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	d	ref	type,location	location	5	const	20	Using where; Using temporary; Uporabi filesort
1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	enavtika_db.d.type	1	Using where

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.00 ms
Creating tmp table	0.34 ms
Copying to tmp table	0.15 ms
Sorting result	0.03 ms
Sending data	0.02 ms
end	0.00 ms
removing tmp table	0.07 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.04 ms
cleaning up	0.00 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:3913
13	Location->getAutocompleteData()	JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php:181
12	include JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
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_vodnikpojadranu/views/location/view.html.php:16
9	VodnikPoJadranuViewLocation->display()	JROOT/components/com_vodnikpojadranu/controller.php:518
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:36
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.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

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 0.29 ms Po zadnji poizvedbi: 1.08 ms Poizvedba pomnilnika: 0.027 MB Spomin pred poizvedbi:3.543 MB Vrstic vrnil: 1

SELECT *

  FROM `nov_location_types_migrirana`

  WHERE `id` = 4

Pojasnilo

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

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.00 ms
updating status	0.03 ms
cleaning up	0.00 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:4147
14	Location->getLocationType()	JROOT/components/com_vodnikpojadranu/views/location/tmpl/nearby_locations.php:7
13	require JROOT/components/com_vodnikpojadranu/views/location/tmpl/nearby_locations.php	JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php:227
12	include JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
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_vodnikpojadranu/views/location/view.html.php:16
9	VodnikPoJadranuViewLocation->display()	JROOT/components/com_vodnikpojadranu/controller.php:518
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:36
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.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

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 0.31 ms Po zadnji poizvedbi: 1.05 ms Poizvedba pomnilnika: 0.027 MB Spomin pred poizvedbi:3.553 MB Vrstic vrnil: 1

Podvojene poizvedbe: #40 #41 #42 #43

SELECT *

  FROM `nov_location_types_migrirana`

  WHERE `id` = 3

Pojasnilo

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

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:4147
14	Location->getLocationType()	JROOT/components/com_vodnikpojadranu/views/location/tmpl/nearby_locations.php:7
13	require JROOT/components/com_vodnikpojadranu/views/location/tmpl/nearby_locations.php	JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php:227
12	include JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
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_vodnikpojadranu/views/location/view.html.php:16
9	VodnikPoJadranuViewLocation->display()	JROOT/components/com_vodnikpojadranu/controller.php:518
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:36
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.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

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 0.35 ms Po zadnji poizvedbi: 0.33 ms Poizvedba pomnilnika: 0.027 MB Spomin pred poizvedbi:3.562 MB Vrstic vrnil: 1

Podvojene poizvedbe: #39 #41 #42 #43

SELECT *

  FROM `nov_location_types_migrirana`

  WHERE `id` = 3

Pojasnilo

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

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:4147
14	Location->getLocationType()	JROOT/components/com_vodnikpojadranu/views/location/tmpl/nearby_locations.php:7
13	require JROOT/components/com_vodnikpojadranu/views/location/tmpl/nearby_locations.php	JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php:227
12	include JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
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_vodnikpojadranu/views/location/view.html.php:16
9	VodnikPoJadranuViewLocation->display()	JROOT/components/com_vodnikpojadranu/controller.php:518
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:36
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.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

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 0.24 ms Po zadnji poizvedbi: 0.29 ms Poizvedba pomnilnika: 0.027 MB Spomin pred poizvedbi:3.572 MB Vrstic vrnil: 1

Podvojene poizvedbe: #39 #40 #42 #43

SELECT *

  FROM `nov_location_types_migrirana`

  WHERE `id` = 3

Pojasnilo

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

Profil

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.02 ms
cleaning up	0.00 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:4147
14	Location->getLocationType()	JROOT/components/com_vodnikpojadranu/views/location/tmpl/nearby_locations.php:32
13	require JROOT/components/com_vodnikpojadranu/views/location/tmpl/nearby_locations.php	JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php:227
12	include JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
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_vodnikpojadranu/views/location/view.html.php:16
9	VodnikPoJadranuViewLocation->display()	JROOT/components/com_vodnikpojadranu/controller.php:518
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:36
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.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

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 0.22 ms Po zadnji poizvedbi: 0.15 ms Poizvedba pomnilnika: 0.027 MB Spomin pred poizvedbi:3.580 MB Vrstic vrnil: 1

Podvojene poizvedbe: #39 #40 #41 #43

SELECT *

  FROM `nov_location_types_migrirana`

  WHERE `id` = 3

Pojasnilo

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

Profil

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.03 ms
cleaning up	0.00 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:4147
14	Location->getLocationType()	JROOT/components/com_vodnikpojadranu/views/location/tmpl/nearby_locations.php:32
13	require JROOT/components/com_vodnikpojadranu/views/location/tmpl/nearby_locations.php	JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php:227
12	include JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
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_vodnikpojadranu/views/location/view.html.php:16
9	VodnikPoJadranuViewLocation->display()	JROOT/components/com_vodnikpojadranu/controller.php:518
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:36
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.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

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 0.28 ms Po zadnji poizvedbi: 0.23 ms Poizvedba pomnilnika: 0.027 MB Spomin pred poizvedbi:3.589 MB Vrstic vrnil: 1

Podvojene poizvedbe: #39 #40 #41 #42

SELECT *

  FROM `nov_location_types_migrirana`

  WHERE `id` = 3

Pojasnilo

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

Profil

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.00 ms
updating status	0.03 ms
cleaning up	0.00 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:4147
14	Location->getLocationType()	JROOT/components/com_vodnikpojadranu/views/location/tmpl/nearby_locations.php:32
13	require JROOT/components/com_vodnikpojadranu/views/location/tmpl/nearby_locations.php	JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php:227
12	include JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
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_vodnikpojadranu/views/location/view.html.php:16
9	VodnikPoJadranuViewLocation->display()	JROOT/components/com_vodnikpojadranu/controller.php:518
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:36
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.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

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 1.14 ms Po zadnji poizvedbi: 0.69 ms Poizvedba pomnilnika: 0.036 MB Spomin pred poizvedbi:3.603 MB Vrstic vrnil: 0

SELECT l.*, e.*, (6371 * acos(cos(radians(43.882923)) * cos(radians(l.lat)) * cos(radians(l.lng) - radians(15.284858)) + sin(radians(43.882923)) * sin(radians(l.lat)))) AS distance

  FROM nov_locations AS l

  LEFT JOIN nov_events AS e 
  ON l.id = e.locationid

  WHERE (6371 * acos(cos(radians(43.882923)) * cos(radians(l.lat)) * cos(radians(l.lng) - radians(15.284858)) + sin(radians(43.882923)) * sin(radians(l.lat)))) < 35 
  AND l.published = 1 
  AND e.start <= '2021-05-07 22:05:07' 
  AND e.end >= '2021-05-07 22:05:07'

  GROUP BY locationid

  ORDER BY e.start ASC 
  LIMIT 6

Pojasnilo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	e	ALL	locationid	NO INDEX KLJUČ SE LAHKO UPORABLJA	NULL	NULL	38	Using where; Using temporary; Uporabi filesort
1	SIMPLE	l	eq_ref	PRIMARY	PRIMARY	4	enavtika_db.e.locationid	1	Using where

Profil

Status	Duration
starting	0.09 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.05 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 ms
Creating tmp table	0.35 ms
Copying to tmp table	0.12 ms
Sorting result	0.02 ms
Sending data	0.07 ms
end	0.01 ms
removing tmp table	0.10 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
updating status	0.05 ms
cleaning up	0.01 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:3686
14	Location->getNearbyEvents()	JROOT/components/com_vodnikpojadranu/views/location/tmpl/events.php:2
13	require JROOT/components/com_vodnikpojadranu/views/location/tmpl/events.php	JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php:228
12	include JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
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_vodnikpojadranu/views/location/view.html.php:16
9	VodnikPoJadranuViewLocation->display()	JROOT/components/com_vodnikpojadranu/controller.php:518
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:36
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.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

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 1.02 ms Po zadnji poizvedbi: 0.20 ms Poizvedba pomnilnika: 0.036 MB Spomin pred poizvedbi:3.612 MB Vrstic vrnil: 0

SELECT l.*, e.*, (6371 * acos(cos(radians(43.882923)) * cos(radians(l.lat)) * cos(radians(l.lng) - radians(15.284858)) + sin(radians(43.882923)) * sin(radians(l.lat)))) AS distance

  FROM nov_locations AS l

  LEFT JOIN nov_events AS e 
  ON l.id = e.locationid

  WHERE (6371 * acos(cos(radians(43.882923)) * cos(radians(l.lat)) * cos(radians(l.lng) - radians(15.284858)) + sin(radians(43.882923)) * sin(radians(l.lat)))) < 35 
  AND l.published = 1 
  AND e.start >= '2021-05-07 22:05:07'

  GROUP BY locationid

  ORDER BY e.start ASC 
  LIMIT 6

Pojasnilo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	e	ALL	locationid	NO INDEX KLJUČ SE LAHKO UPORABLJA	NULL	NULL	38	Using where; Using temporary; Uporabi filesort
1	SIMPLE	l	eq_ref	PRIMARY	PRIMARY	4	enavtika_db.e.locationid	1	Using where

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
After table lock	0.00 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.00 ms
Creating tmp table	0.32 ms
Copying to tmp table	0.16 ms
Sorting result	0.01 ms
Sending data	0.03 ms
end	0.00 ms
removing tmp table	0.08 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.00 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:3686
14	Location->getNearbyEvents()	JROOT/components/com_vodnikpojadranu/views/location/tmpl/events.php:62
13	require JROOT/components/com_vodnikpojadranu/views/location/tmpl/events.php	JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php:228
12	include JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
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_vodnikpojadranu/views/location/view.html.php:16
9	VodnikPoJadranuViewLocation->display()	JROOT/components/com_vodnikpojadranu/controller.php:518
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:36
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.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

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 1.00 ms Po zadnji poizvedbi: 0.52 ms Poizvedba pomnilnika: 0.027 MB Spomin pred poizvedbi:3.618 MB Vrstic vrnil: 1

SELECT d.id as dataid, d.type as datatypeid, d.type as datatypeid,  d.value as value, t.alias as alias, t.name as datatype, t.output, t.ordering

  FROM nov_data as d

  LEFT JOIN nov_data_types AS t 
  ON t.id = d.type

  WHERE `d`.`location` = 257 
  AND `t`.`output` = 7

  ORDER BY t.ordering ASC

Pojasnilo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	d	ref	type,location	location	5	const	20	Using where; Using temporary; Uporabi filesort
1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	enavtika_db.d.type	1	Using where

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.00 ms
Creating tmp table	0.30 ms
Copying to tmp table	0.14 ms
Sorting result	0.03 ms
Sending data	0.03 ms
end	0.01 ms
removing tmp table	0.10 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.05 ms
cleaning up	0.01 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:3557
14	Location->booking()	JROOT/components/com_vodnikpojadranu/views/location/tmpl/booking.php:1
13	require JROOT/components/com_vodnikpojadranu/views/location/tmpl/booking.php	JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php:232
12	include JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
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_vodnikpojadranu/views/location/view.html.php:16
9	VodnikPoJadranuViewLocation->display()	JROOT/components/com_vodnikpojadranu/controller.php:518
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:36
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.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

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 0.67 ms Po zadnji poizvedbi: 1.47 ms Poizvedba pomnilnika: 0.038 MB Spomin pred poizvedbi:3.626 MB Vrstic vrnil: 4

SELECT *

  FROM `nov_jcomments`

  WHERE `object_group`='com_vodnikpojadranu' 
  AND `object_id`=257

  ORDER BY date DESC

Pojasnilo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nov_jcomments	ref	idx_object	idx_object	771	const,const	4	Using index condition; Using where; Uporabi filesort

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.01 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.03 ms
executing	0.01 ms
Sorting result	0.06 ms
Sending data	0.12 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.04 ms
cleaning up	0.00 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:4284
14	Location->comments()	JROOT/components/com_vodnikpojadranu/views/location/tmpl/comments.php:21
13	require JROOT/components/com_vodnikpojadranu/views/location/tmpl/comments.php	JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php:240
12	include JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
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_vodnikpojadranu/views/location/view.html.php:16
9	VodnikPoJadranuViewLocation->display()	JROOT/components/com_vodnikpojadranu/controller.php:518
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:36
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.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

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 0.54 ms Po zadnji poizvedbi: 0.40 ms Poizvedba pomnilnika: 0.029 MB Spomin pred poizvedbi:3.655 MB Vrstic vrnil: 1

SELECT *

  FROM `nov_data` AS d

  LEFT JOIN nov_data_types AS dt 
  ON dt.id = d.type

  WHERE `d`.`location` = 599 
  AND `dt`.`output`=6

Pojasnilo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	d	ref	type,location	location	5	const	8	Using where
1	SIMPLE	dt	eq_ref	PRIMARY	PRIMARY	4	enavtika_db.d.type	1	Using where

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.01 ms
updating status	0.04 ms
cleaning up	0.00 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:4397
13	Location->getWind()	JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php:318
12	include JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
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_vodnikpojadranu/views/location/view.html.php:16
9	VodnikPoJadranuViewLocation->display()	JROOT/components/com_vodnikpojadranu/controller.php:518
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:36
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.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

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 0.48 ms Po zadnji poizvedbi: 0.18 ms Poizvedba pomnilnika: 0.029 MB Spomin pred poizvedbi:3.663 MB Vrstic vrnil: 1

SELECT *

  FROM `nov_data` AS d

  LEFT JOIN nov_data_types AS dt 
  ON dt.id = d.type

  WHERE `d`.`location` = 1433 
  AND `dt`.`output`=6

Pojasnilo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	d	ref	type,location	location	5	const	14	Using where
1	SIMPLE	dt	eq_ref	PRIMARY	PRIMARY	4	enavtika_db.d.type	1	Using where

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.04 ms
cleaning up	0.00 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:4397
13	Location->getWind()	JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php:318
12	include JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
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_vodnikpojadranu/views/location/view.html.php:16
9	VodnikPoJadranuViewLocation->display()	JROOT/components/com_vodnikpojadranu/controller.php:518
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:36
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.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

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 0.37 ms Po zadnji poizvedbi: 0.15 ms Poizvedba pomnilnika: 0.029 MB Spomin pred poizvedbi:3.670 MB Vrstic vrnil: 1

SELECT *

  FROM `nov_data` AS d

  LEFT JOIN nov_data_types AS dt 
  ON dt.id = d.type

  WHERE `d`.`location` = 2022 
  AND `dt`.`output`=6

Pojasnilo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	d	ref	type,location	location	5	const	10	Using where
1	SIMPLE	dt	eq_ref	PRIMARY	PRIMARY	4	enavtika_db.d.type	1	Using where

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.00 ms
updating status	0.04 ms
cleaning up	0.00 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:4397
13	Location->getWind()	JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php:318
12	include JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
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_vodnikpojadranu/views/location/view.html.php:16
9	VodnikPoJadranuViewLocation->display()	JROOT/components/com_vodnikpojadranu/controller.php:518
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:36
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.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

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 0.40 ms Po zadnji poizvedbi: 1.34 ms Poizvedba pomnilnika: 0.022 MB Spomin pred poizvedbi:3.732 MB Vrstic vrnil: 3

SELECT language,id

  FROM `nov_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0

Pojasnilo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nov_menu	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	52	Using where

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.11 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.00 ms
updating status	0.03 ms
cleaning up	0.00 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 0.87 ms Po zadnji poizvedbi: 5.67 ms Poizvedba pomnilnika: 0.033 MB Spomin pred poizvedbi:3.822 MB Vrstic vrnil: 10

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM nov_modules AS m

  LEFT JOIN nov_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN nov_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 <= '2021-05-07 20:05:07') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-05-07 20:05:07') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 116 OR mm.menuid <= 0) 
  AND m.language IN ('sl-SI','*')

  ORDER BY m.position, m.ordering

Pojasnilo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds,idx_language	published	1	const	25	Using index condition; Using where; Uporabi filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	enavtika_db.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	enavtika_db.m.module,const	1	Using index condition; Using where

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.04 ms
optimizing	0.04 ms
statistics	0.10 ms
preparing	0.04 ms
executing	0.00 ms
Sorting result	0.13 ms
Sending data	0.21 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.00 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	Enako kot klic v vrstici spodaj.
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/enavtika/index.php:142
7	require JROOT/templates/enavtika/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 0.37 ms Po zadnji poizvedbi: 5.01 ms Poizvedba pomnilnika: 0.035 MB Spomin pred poizvedbi:3.883 MB Vrstic vrnil: 0

Podvojene poizvedbe: #58

SELECT *

  FROM nov_banners

  WHERE '2021-05-07 20:05:07' >= 'reset' 
  AND `reset` != '0000-00-00 00:00:00' 
  AND `reset`!= NULL 
  AND (`checked_out` = 0 OR `checked_out` = 0)

Pojasnilo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KLJUČ SE LAHKO UPORABLJA	NULL	NULL	NULL	Impossible WHERE

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
executing	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.00 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_banners/helpers/banners.php:79
11	BannersHelper::updateReset()	JROOT/modules/mod_banners/mod_banners.php:19
10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj direktivo xdebug.file_link_format na vaš php.ini datoteke, da imajo povezave za datoteke]

Čas poizvedbe: 1.50 ms Po zadnji poizvedbi: 1.74 ms Poizvedba pomnilnika: 0.027 MB Spomin pred poizvedbi:3.902 MB Vrstic vrnil: 1

SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions

  FROM nov_banners as a

  LEFT JOIN nov_banner_clients AS cl 
  ON cl.id = a.cid

  WHERE a.state=1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-05-07 20:05:07') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-05-07 20:05:07') 
  AND (a.imptotal = 0 OR a.impmade <= a.imptotal) 
  AND a.catid IN (26,30) 
  AND a.language in ('sl-SI','*')

  ORDER BY a.sticky DESC, RAND()  
  LIMIT 1

Pojasnilo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_banner_catid,idx_language	idx_state	1	const	56	Using where; Using temporary; Uporabi filesort
1	SIMPLE	cl	eq_ref	PRIMARY	PRIMARY	4	enavtika_db.a.cid	1

Profil

Status	Duration
starting	0.09 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.11 ms
preparing	0.03 ms
executing	0.00 ms
Creating tmp table	0.36 ms
Copying to tmp table	0.39 ms
Sorting result	0.04 ms
Sending data	0.02 ms
end	0.01 ms
removing tmp table	0.11 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.04 ms
cleaning up	0.01 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_banners/models/banners.php:222
12	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:48
11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joo