‹ ›

Foto

Parja

Vis

Sidrišče

Podatki

GPS	43° 4' N , 16° 10' E
Bencinska črpalka	2 nmi Vis
Globina vode	1,5 - 5 m
Kraj	otok Vis
Obratovalni čas	1.1. - 31.12.
Št. Privezov	0 (Sidranje na lastnem sidru)

Info

Sidrišče Parja je zahodno od vhoda v luko Vis na otoku Vis. Sidrišče je dobro zaščiteno pred vsemi vetrovi razen vzhodnimi. Sidramo lahko na globinah med 1,5 in 5m. Dno je peščeno in sidro dobro drži. Skrajni zahodni del zaliva je plitev. Globina morja pade pod 1m . Na severni strani zaliva je podzemno skrivališče v katerem so v času Jugoslavije skrivali vojaške podmornice. Južno od zaliva Parja je majhna luka in zaliv Rogačič. Najbližja restavracija je v trdnjavi Sv. Juraj, vzhodno od zaliva, več pa jih je v luki Vis, kjer je tudi bencinska črpalka.

Ponudba

- zapuščen bunker za vojaške podmornice

Zaščita pred vetrovi/Vreme

Danes

Jutri

Nedelja

V bližini

Stonca Luka 0.68 nmi
Stonca Svetilnik 0.7 nmi
Veli Volić Svetilnik 0.75 nmi

Zaščiteno

6,1,12,1,12,1,12,1,12,1,12,1,12,1,12,1,6
Stonca Luka 0.68 nmi
6,1,12,1,12,1,12,1,12,1,12,1,12,1,12,1,6
Budikovac Sidrišče 4.03 nmi
6,1,12,1,12,1,12,1,12,1,12,1,12,1,12,1,6
Komiža Luka 4.58 nmi

Cene

19.10.2018

0,00 HRK/dan

Za dodajanje cene se morate prijaviti!

Komentarji

Skippermaki

Tunel odlično zavetišče za prenočiti. Lahko se bočno vežejo do 4 jadrnice. Zaenkrat še brezplačno.

Sun | 21 Oct | 2018

Joomla! Konzola razhroščevanja

Seja

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1620414447,
                "last": 1620414447,
                "now": 1620414447
            }
        },
        "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: 20.93 ms / 20.93 ms Spomin: 0.565 MB / 0.95 MB Application: afterLoad

Čas: 63.51 ms / 84.44 ms Spomin: 1.431 MB / 2.38 MB Application: afterInitialise

Čas: 29.51 ms / 113.94 ms Spomin: 0.705 MB / 3.08 MB Application: afterRoute

Čas: 1.20 ms / 115.14 ms Spomin: 0.104 MB / 3.19 MB Application: beforeRenderComponent com_vodnikpojadranu

Čas: 77.08 ms / 192.22 ms Spomin: 0.476 MB / 3.66 MB Application: afterRenderComponent com_vodnikpojadranu

Čas: 7.71 ms / 199.93 ms Spomin: 0.018 MB / 3.68 MB Application: afterDispatch

Čas: 9.89 ms / 209.81 ms Spomin: 0.150 MB / 3.83 MB Application: beforeRenderModule mod_banners (Banner bottom)

Čas: 11.46 ms / 221.27 ms Spomin: 0.059 MB / 3.89 MB Application: afterRenderModule mod_banners (Banner bottom)

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

Čas: 4.09 ms / 225.49 ms Spomin: 0.030 MB / 3.91 MB Application: afterRenderModule mod_banners (Banner top)

Čas: 0.09 ms / 225.59 ms Spomin: 0.000 MB / 3.91 MB Application: beforeRenderModule mod_languages (Language switcher)

Čas: 5.92 ms / 231.51 ms Spomin: 0.038 MB / 3.95 MB Application: afterRenderModule mod_languages (Language switcher)

Čas: 0.10 ms / 231.60 ms Spomin: 0.000 MB / 3.94 MB Application: beforeRenderModule mod_menu (Main Menu)

Čas: 6.79 ms / 238.40 ms Spomin: 0.137 MB / 4.08 MB Application: afterRenderModule mod_menu (Main Menu)

Čas: 0.05 ms / 238.45 ms Spomin: 0.000 MB / 4.08 MB Application: beforeRenderModule mod_menu (English menu)

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

Čas: 5.77 ms / 244.75 ms Spomin: 0.142 MB / 4.22 MB Application: Before Access::preloadComponents (all components)

Čas: 1.20 ms / 245.95 ms Spomin: 0.057 MB / 4.28 MB Application: After Access::preloadComponents (all components)

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

Čas: 0.86 ms / 246.85 ms Spomin: 0.009 MB / 4.29 MB Application: After Access::getAssetRules (id:1 name:root.1)

Čas: 3.52 ms / 250.38 ms Spomin: 0.069 MB / 4.36 MB Application: afterRender

Baza podatkov poizvedbe skupaj: 76.53 ms

Uporaba pomnilnika

Baza podatkov poizvedbe

63 poizvedb zabeleženo 76.53 ms

16 podvajanj najdenih

3 podvajanj: #11 #17 #62

2 podvajanj: #14 #18

2 podvajanj: #21 #24

2 podvajanj: #36 #42

3 podvajanj: #38 #41 #43

2 podvajanj: #39 #40

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'6f66383273646762766138723834356863653739333173356974'

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.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.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.24 ms Po zadnji poizvedbi: 1.58 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'6f66383273646762766138723834356863653739333173356974' 
  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.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.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
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: 0.66 ms Po zadnji poizvedbi: 0.12 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'6f66383273646762766138723834356863653739333173356974', 1, 1620414447, 0, '', 0)

Pojasnilo

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

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
update	0.06 ms
end	0.00 ms
query end	0.35 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
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.53 ms Po zadnji poizvedbi: 3.55 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.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.05 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.14 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
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.24 ms Po zadnji poizvedbi: 2.77 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.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.03 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: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.28 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.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: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.03 ms Po zadnji poizvedbi: 0.19 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.48 ms
Sending data	0.22 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
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.30 ms Po zadnji poizvedbi: 0.90 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.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.02 ms
Sending data	0.03 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.44 ms Po zadnji poizvedbi: 11.25 ms Poizvedba pomnilnika: 0.027 MB Spomin pred poizvedbi:1.892 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.01 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.01 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.00 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.71 ms Po zadnji poizvedbi: 0.22 ms Poizvedba pomnilnika: 0.006 MB Spomin pred poizvedbi:1.884 MB

UPDATE `nov_extensions`

  SET `params` = '{\"mediaversion\":\"56582587ef9bcbc6a856941f87038f11\"}'

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

Pojasnilo

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

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.05 ms
Updating	0.04 ms
end	0.00 ms
query end	0.34 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/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.31 ms Po zadnji poizvedbi: 1.21 ms Poizvedba pomnilnika: 0.034 MB Spomin pred poizvedbi:1.967 MB Vrstic vrnil: 133

Podvojene poizvedbe: #17 #62

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.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.07 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
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.38 ms Po zadnji poizvedbi: 2.47 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.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.02 ms
init	0.01 ms
optimizing	0.02 ms
statistics	0.03 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.00 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/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: 0.98 ms Po zadnji poizvedbi: 9.14 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.06 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.02 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.16 ms
Sending data	0.41 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.00 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.40 ms Po zadnji poizvedbi: 1.08 ms Poizvedba pomnilnika: 0.024 MB Spomin pred poizvedbi:2.273 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.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
Sending data	0.06 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
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.41 ms Po zadnji poizvedbi: 23.26 ms Poizvedba pomnilnika: 0.025 MB Spomin pred poizvedbi:3.020 MB Vrstic vrnil: 0

SELECT *

  FROM `nov_location_types_migrirana`

  WHERE `slug`='sidrisce:parja-vis' 
  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.05 ms
checking permissions	0.01 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.01 ms
statistics	0.04 ms
preparing	0.00 ms
executing	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
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: 1.12 ms Po zadnji poizvedbi: 0.13 ms Poizvedba pomnilnika: 0.028 MB Spomin pred poizvedbi:3.025 MB Vrstic vrnil: 1

SELECT *

  FROM `nov_locations`

  WHERE `alias`='sidrisce-parja-vis' 
  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.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.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.85 ms
end	0.01 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
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.41 ms Po zadnji poizvedbi: 2.74 ms Poizvedba pomnilnika: 0.035 MB Spomin pred poizvedbi:3.051 MB Vrstic vrnil: 133

Podvojene poizvedbe: #11 #62

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.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.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
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.46 ms Po zadnji poizvedbi: 2.50 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.06 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.02 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.07 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
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: 3.24 ms Po zadnji poizvedbi: 8.78 ms Poizvedba pomnilnika: 0.028 MB Spomin pred poizvedbi:3.310 MB Vrstic vrnil: 1

SELECT *

  FROM `nov_locations`

  WHERE `alias` LIKE '%sidrisce-parja-vis%' 
  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.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.00 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	2.80 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.06 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.47 ms Po zadnji poizvedbi: 0.21 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` = 1260 
  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	9	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.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.02 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 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.01 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: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.29 ms Po zadnji poizvedbi: 1.44 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.04 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.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: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.26 ms Po zadnji poizvedbi: 0.26 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.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.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 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: 8.80 ms Po zadnji poizvedbi: 0.13 ms Poizvedba pomnilnika: 0.028 MB Spomin pred poizvedbi:3.353 MB Vrstic vrnil: 3

SELECT DISTINCT l.*,(6371 * acos(cos(radians(43.077524388)) * cos(radians(l.lat)) * cos(radians(l.lng) - radians(16.180822849)) + sin(radians(43.077524388)) * 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 21:07:27')) 
  AND l.lat != 43.077524388 
  AND l.lng != 16.180822849 
  AND d.value REGEXP '([0-1]{5}111)'

  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.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.10 ms
optimizing	0.05 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.00 ms
Creating tmp table	0.38 ms
Copying to tmp table	7.30 ms
Sorting result	0.23 ms
Sending data	0.07 ms
end	0.01 ms
removing tmp table	0.16 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.02 ms
freeing items	0.02 ms
updating status	0.05 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: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.34 ms Po zadnji poizvedbi: 0.25 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.05 ms
checking permissions	0.01 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.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.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: 30.83 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.077524388)) * cos(radians(l.lat)) * cos(radians(l.lng) - radians(16.180822849)) + sin(radians(43.077524388)) * 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 21:07:27')) 
  AND l.lat != 43.077524388 
  AND l.lng != 16.180822849

  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.01 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.03 ms
preparing	0.02 ms
executing	0.00 ms
Creating tmp table	0.35 ms
Copying to tmp table	28.48 ms
Sorting result	0.95 ms
Sending data	0.09 ms
end	0.01 ms
removing tmp table	0.34 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.08 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.51 ms Po zadnji poizvedbi: 0.25 ms Poizvedba pomnilnika: 0.024 MB Spomin pred poizvedbi:3.384 MB Vrstic vrnil: 1

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` = 1260

  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	9	Using where; 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.00 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.04 ms
Sending data	0.06 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.14 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.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.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.24 ms Po zadnji poizvedbi: 0.11 ms Poizvedba pomnilnika: 0.023 MB Spomin pred poizvedbi:3.397 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.24 ms Po zadnji poizvedbi: 0.08 ms Poizvedba pomnilnika: 0.024 MB Spomin pred poizvedbi:3.403 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.35 ms Po zadnji poizvedbi: 0.09 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.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.05 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.80 ms Poizvedba pomnilnika: 0.027 MB Spomin pred poizvedbi:3.444 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` = 1260 
  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	9	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.09 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.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
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: 0.70 ms Po zadnji poizvedbi: 0.11 ms Poizvedba pomnilnika: 0.027 MB Spomin pred poizvedbi:3.453 MB Vrstic vrnil: 5

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` = 1260 
  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	9	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.01 ms
executing	0.00 ms
Creating tmp table	0.22 ms
Copying to tmp table	0.08 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: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.24 ms Po zadnji poizvedbi: 0.11 ms Poizvedba pomnilnika: 0.026 MB Spomin pred poizvedbi:3.470 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.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.01 ms
After table lock	0.01 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.02 ms
cleaning up	0.00 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.23 ms Po zadnji poizvedbi: 0.12 ms Poizvedba pomnilnika: 0.027 MB Spomin pred poizvedbi:3.482 MB Vrstic vrnil: 1

SELECT *

  FROM `nov_galleries`

  WHERE `id`=908 
  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.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
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.65 ms Po zadnji poizvedbi: 5.49 ms Poizvedba pomnilnika: 0.028 MB Spomin pred poizvedbi:3.495 MB Vrstic vrnil: 0

SELECT *

  FROM `nov_gallery_items`

  WHERE `galleryid`=908 
  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.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.00 ms
Sending data	0.29 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
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.27 ms Po zadnji poizvedbi: 0.13 ms Poizvedba pomnilnika: 0.026 MB Spomin pred poizvedbi:3.502 MB Vrstic vrnil: 1

Podvojene poizvedbe: #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.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
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: 0.87 ms Po zadnji poizvedbi: 0.94 ms Poizvedba pomnilnika: 0.027 MB Spomin pred poizvedbi:3.512 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` = 1260 
  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	9	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.01 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.30 ms
Copying to tmp table	0.09 ms
Sorting result	0.02 ms
Sending data	0.02 ms
end	0.00 ms
removing tmp table	0.09 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: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.31 ms Po zadnji poizvedbi: 0.80 ms Poizvedba pomnilnika: 0.027 MB Spomin pred poizvedbi:3.536 MB Vrstic vrnil: 1

Podvojene poizvedbe: #41 #43

SELECT *

  FROM `nov_location_types_migrirana`

  WHERE `id` = 2

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: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: 1.01 ms Poizvedba pomnilnika: 0.027 MB Spomin pred poizvedbi:3.547 MB Vrstic vrnil: 1

Podvojene poizvedbe: #40

SELECT *

  FROM `nov_location_types_migrirana`

  WHERE `id` = 8

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: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.25 ms Po zadnji poizvedbi: 0.23 ms Poizvedba pomnilnika: 0.027 MB Spomin pred poizvedbi:3.556 MB Vrstic vrnil: 1

Podvojene poizvedbe: #39

SELECT *

  FROM `nov_location_types_migrirana`

  WHERE `id` = 8

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: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.22 ms Po zadnji poizvedbi: 0.21 ms Poizvedba pomnilnika: 0.027 MB Spomin pred poizvedbi:3.565 MB Vrstic vrnil: 1

Podvojene poizvedbe: #38 #43

SELECT *

  FROM `nov_location_types_migrirana`

  WHERE `id` = 2

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.23 ms Po zadnji poizvedbi: 0.15 ms Poizvedba pomnilnika: 0.027 MB Spomin pred poizvedbi:3.573 MB Vrstic vrnil: 1

Podvojene poizvedbe: #36

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.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.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.23 ms Po zadnji poizvedbi: 0.23 ms Poizvedba pomnilnika: 0.027 MB Spomin pred poizvedbi:3.582 MB Vrstic vrnil: 1

Podvojene poizvedbe: #38 #41

SELECT *

  FROM `nov_location_types_migrirana`

  WHERE `id` = 2

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: 1.05 ms Po zadnji poizvedbi: 0.60 ms Poizvedba pomnilnika: 0.036 MB Spomin pred poizvedbi:3.596 MB Vrstic vrnil: 0

SELECT l.*, e.*, (6371 * acos(cos(radians(43.077524388)) * cos(radians(l.lat)) * cos(radians(l.lng) - radians(16.180822849)) + sin(radians(43.077524388)) * 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.077524388)) * cos(radians(l.lat)) * cos(radians(l.lng) - radians(16.180822849)) + sin(radians(43.077524388)) * sin(radians(l.lat)))) < 35 
  AND l.published = 1 
  AND e.start <= '2021-05-07 21:07:27' 
  AND e.end >= '2021-05-07 21:07:27'

  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.10 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.04 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.00 ms
Creating tmp table	0.37 ms
Copying to tmp table	0.11 ms
Sorting result	0.01 ms
Sending data	0.03 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
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.07 ms Po zadnji poizvedbi: 0.39 ms Poizvedba pomnilnika: 0.036 MB Spomin pred poizvedbi:3.605 MB Vrstic vrnil: 0

SELECT l.*, e.*, (6371 * acos(cos(radians(43.077524388)) * cos(radians(l.lat)) * cos(radians(l.lng) - radians(16.180822849)) + sin(radians(43.077524388)) * 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.077524388)) * cos(radians(l.lat)) * cos(radians(l.lng) - radians(16.180822849)) + sin(radians(43.077524388)) * sin(radians(l.lat)))) < 35 
  AND l.published = 1 
  AND e.start >= '2021-05-07 21:07:27'

  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.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.02 ms
preparing	0.02 ms
executing	0.00 ms
Creating tmp table	0.26 ms
Copying to tmp table	0.17 ms
Sorting result	0.01 ms
Sending data	0.03 ms
end	0.00 ms
removing tmp table	0.06 ms
end	0.00 ms
query end	0.00 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: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: 0.80 ms Po zadnji poizvedbi: 0.47 ms Poizvedba pomnilnika: 0.027 MB Spomin pred poizvedbi:3.611 MB Vrstic vrnil: 0

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` = 1260 
  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	9	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.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.02 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.00 ms
Creating tmp table	0.23 ms
Copying to tmp table	0.06 ms
Sorting result	0.02 ms
Sending data	0.01 ms
end	0.00 ms
removing tmp table	0.09 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.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: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.54 ms Po zadnji poizvedbi: 1.65 ms Poizvedba pomnilnika: 0.036 MB Spomin pred poizvedbi:3.618 MB Vrstic vrnil: 1

SELECT *

  FROM `nov_jcomments`

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

  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	1	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.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.02 ms
executing	0.00 ms
Sorting result	0.04 ms
Sending data	0.06 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
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.49 ms Po zadnji poizvedbi: 0.32 ms Poizvedba pomnilnika: 0.029 MB Spomin pred poizvedbi:3.628 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` = 1400 
  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.01 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.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.46 ms Po zadnji poizvedbi: 0.17 ms Poizvedba pomnilnika: 0.029 MB Spomin pred poizvedbi:3.635 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` = 2885 
  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	9	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.04 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.08 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.50 ms Po zadnji poizvedbi: 0.16 ms Poizvedba pomnilnika: 0.029 MB Spomin pred poizvedbi:3.642 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` = 38 
  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	23	Using where
1	SIMPLE	dt	eq_ref	PRIMARY	PRIMARY	4	enavtika_db.d.type	1	Using where

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.01 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
Sending data	0.14 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: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.52 ms Po zadnji poizvedbi: 1.83 ms Poizvedba pomnilnika: 0.022 MB Spomin pred poizvedbi:3.700 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.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.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.14 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.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/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: 2.10 ms Po zadnji poizvedbi: 6.82 ms Poizvedba pomnilnika: 0.033 MB Spomin pred poizvedbi:3.798 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 19:07:27') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-05-07 19:07:27') 
  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.17 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After table lock	0.01 ms
init	0.09 ms
optimizing	0.09 ms
statistics	0.21 ms
preparing	0.14 ms
executing	0.01 ms
Sorting result	0.26 ms
Sending data	0.55 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.04 ms
updating status	0.09 ms
cleaning up	0.01 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.62 ms Po zadnji poizvedbi: 9.35 ms Poizvedba pomnilnika: 0.035 MB Spomin pred poizvedbi:3.858 MB Vrstic vrnil: 0

Podvojene poizvedbe: #58

SELECT *

  FROM nov_banners

  WHERE '2021-05-07 19:07:27' >= '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.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.00 ms
After table lock	0.01 ms
init	0.05 ms
optimizing	0.03 ms
executing	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.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/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: 2.05 ms Po zadnji poizvedbi: 2.29 ms Poizvedba pomnilnika: 0.027 MB Spomin pred poizvedbi:3.877 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 19:07:27') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-05-07 19:07:27') 
  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.14 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After table lock	0.01 ms
init	0.06 ms
optimizing	0.04 ms
statistics	0.14 ms
preparing	0.04 ms
executing	0.00 ms
Creating tmp table	0.44 ms
Copying to tmp table	0.57 ms
Sorting result	0.07 ms
Sending data	0.04 ms
end	0.01 ms
removing tmp table	0.16 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
updating status	0.06 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	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: 0.83 ms Po zadnji poizvedbi: 0.18 ms Poizvedba pomnilnika: 0.006 MB Spomin pred poizvedbi:3.890 MB