‹ ›

Foto

Lavsa N

Lavsa

Sidrišče

Objavil(a) eNavtika

, 26.04.2021

Podatki

GPS	43° 45' N , 15° 22' E
Št. Privezov	0
Globina vode	2 - 6 m
Obratovalni čas	1.1. - 31.12.
Bencinska črpalka	17 nmi Zaglav
Kraj	Lavsa (Kornati)

Info

Majhen otok Lavsa leži v južnem delu narodnega parka Kornati. Zaliv v severozahodnem delu otoka nudi dobro zaščito pred vsemi vetrovi, razen pred burjo. Sidramo lahko na globinah med 2 in 6 m. Dno je peščeno in sidro drži dobro. V zalivu južno je gostilna.

Otok Lavsa je v nacionalnem parku Kornati. Kupiti je treba vstopnico. Vstopnice so v predprodaji na spletu cenejše. Nakup je treba opraviti vsaj en dan vnaprej.

Zaščita pred vetrovi/Vreme

Danes

Jutri

Sobota

V bližini

Lavsa Sidrišče 0.3 nmi
Pricololonca Sidrišče 0.59 nmi
Studenjak Sidrišče 0.63 nmi

Zaščiteno

6,1,12,1,12,1,12,1,12,1,12,1,12,1,12,1,6
Studenjak Sidrišče 0.63 nmi
6,1,12,1,12,1,12,1,12,1,12,1,12,1,12,1,6
Piškera Marina 0.97 nmi
6,1,12,1,12,1,12,1,12,1,12,1,12,1,12,1,6
Piškera Luka 1.1 nmi

Cene

26.04.2021	0-11m - 300 HRK/dan
26.04.2021	11-18m - 500 HRK/dan
26.04.2021	18-25m - 900 HRK/dan

Za dodajanje cene se morate prijaviti!

Komentarji

Joomla! Konzola razhroščevanja

Seja

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1733365598,
                "last": 1733365598,
                "now": 1733365598
            }
        },
        "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: 17.59 ms / 17.59 ms Spomin: 0.409 MB / 0.75 MB Application: afterLoad

Čas: 69.51 ms / 87.11 ms Spomin: 1.293 MB / 2.05 MB Application: afterInitialise

Čas: 20.49 ms / 107.60 ms Spomin: 0.211 MB / 2.26 MB Application: afterRoute

Čas: 1.12 ms / 108.71 ms Spomin: 0.113 MB / 2.37 MB Application: beforeRenderComponent com_vodnikpojadranu

Čas: 785.33 ms / 894.05 ms Spomin: 1.685 MB / 4.06 MB Application: afterRenderComponent com_vodnikpojadranu

Čas: 6.22 ms / 900.26 ms Spomin: 0.020 MB / 4.08 MB Application: afterDispatch

Čas: 5.78 ms / 906.05 ms Spomin: 0.150 MB / 4.23 MB Application: beforeRenderModule mod_banners (Banner bottom)

Čas: 7.99 ms / 914.04 ms Spomin: 0.041 MB / 4.27 MB Application: afterRenderModule mod_banners (Banner bottom)

Čas: 0.07 ms / 914.11 ms Spomin: -0.004 MB / 4.26 MB Application: beforeRenderModule mod_banners (Banner top)

Čas: 2.84 ms / 916.95 ms Spomin: 0.029 MB / 4.29 MB Application: afterRenderModule mod_banners (Banner top)

Čas: 0.05 ms / 917.00 ms Spomin: -0.005 MB / 4.29 MB Application: beforeRenderModule mod_languages (Language switcher)

Čas: 6.24 ms / 923.24 ms Spomin: 0.031 MB / 4.32 MB Application: afterRenderModule mod_languages (Language switcher)

Čas: 0.05 ms / 923.29 ms Spomin: -0.003 MB / 4.31 MB Application: beforeRenderModule mod_menu (Main Menu)

Čas: 5.78 ms / 929.08 ms Spomin: 0.147 MB / 4.46 MB Application: afterRenderModule mod_menu (Main Menu)

Čas: 0.03 ms / 929.11 ms Spomin: -0.005 MB / 4.46 MB Application: beforeRenderModule mod_menu (English menu)

Čas: 0.41 ms / 929.52 ms Spomin: 0.004 MB / 4.46 MB Application: afterRenderModule mod_menu (English menu)

Čas: 5.03 ms / 934.55 ms Spomin: 0.061 MB / 4.52 MB Application: Before Access::preloadComponents (all components)

Čas: 0.94 ms / 935.49 ms Spomin: 0.057 MB / 4.58 MB Application: After Access::preloadComponents (all components)

Čas: 0.03 ms / 935.53 ms Spomin: -0.003 MB / 4.58 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Čas: 0.73 ms / 936.25 ms Spomin: 0.008 MB / 4.58 MB Application: After Access::getAssetRules (id:1 name:root.1)

Čas: 2.89 ms / 939.14 ms Spomin: 0.062 MB / 4.65 MB Application: afterRender

Baza podatkov poizvedbe skupaj: 71.93 ms

Uporaba pomnilnika

Baza podatkov poizvedbe

58 poizvedb zabeleženo 71.93 ms

14 podvajanj najdenih

3 podvajanj: #9 #15 #57

2 podvajanj: #13 #16

2 podvajanj: #19 #22

5 podvajanj: #34 #36 #37 #38 #39

2 podvajanj: #50 #53

Čas poizvedbe: 0.33 ms Poizvedba pomnilnika: 0.020 MB Spomin pred poizvedbi:1.039 MB Vrstic vrnil: 0

SELECT `session_id`

  FROM `nov_session`

  WHERE `session_id` = X'743334366469736e6861346939377134383176367239696a3335' 
  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.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.00 ms
After table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.00 ms
executing	0.01 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
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:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
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:386
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.28 ms Po zadnji poizvedbi: 0.12 ms Poizvedba pomnilnika: 0.004 MB Spomin pred poizvedbi:1.045 MB

INSERT INTO `nov_session`
(`session_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
(X'743334366469736e6861346939377134383176367239696a3335', 1, 1733365598, 0, '')

Pojasnilo

Pojasnilo ni na voljo za poizvedbo: INSERT INTO `nov_session` (`session_id`,`guest`,`time`,`userid`,`username`) VALUES (X'743334366469736e6861346939377134383176367239696a3335', 1, 1733365598, 0, '')

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
update	0.07 ms
end	0.00 ms
query end	0.03 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
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
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:386
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.47 ms Po zadnji poizvedbi: 2.27 ms Poizvedba pomnilnika: 0.024 MB Spomin pred poizvedbi:1.076 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.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.02 ms
optimizing	0.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.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:225
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: 2.25 ms Poizvedba pomnilnika: 0.021 MB Spomin pred poizvedbi:1.101 MB Vrstic vrnil: 5

SELECT id, rules

  FROM `nov_viewlevels`

Pojasnilo

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

Profil

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.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.02 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:318
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:225
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.10 ms Poizvedba pomnilnika: 0.021 MB Spomin pred poizvedbi:1.114 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.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.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 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:318
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:225
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.79 ms Po zadnji poizvedbi: 0.13 ms Poizvedba pomnilnika: 0.030 MB Spomin pred poizvedbi:1.135 MB Vrstic vrnil: 108

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	ALL	extension	NO INDEX KLJUČ SE LAHKO UPORABLJA	NULL	NULL	263	Using where; Uporabi filesort

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.20 ms
Sending data	0.30 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
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
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:356
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:225
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: 10.57 ms Poizvedba pomnilnika: 0.024 MB Spomin pred poizvedbi:1.617 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.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.02 ms
System lock	0.00 ms
Table lock	0.02 ms
After table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.05 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.01 ms
updating status	0.04 ms
cleaning up	0.00 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
16	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Enako kot klic v vrstici spodaj.
15	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
13	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
12	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
11	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
10	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
9	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
8	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jomclassifiedslocationmanager/jomclassifiedslocationmanager.php:18
7	plgSystemJomclassifiedsLocationManager->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
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:667
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:225
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.18 ms Poizvedba pomnilnika: 0.006 MB Spomin pred poizvedbi:1.610 MB

UPDATE `nov_extensions`

  SET `params` = '{\"mediaversion\":\"5c94d502ae61c818239bcf17557a0757\"}'

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

Pojasnilo

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

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.04 ms
Updating	0.04 ms
end	0.01 ms
query end	0.03 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:280
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:667
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:225
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.27 ms Poizvedba pomnilnika: 0.031 MB Spomin pred poizvedbi:1.627 MB Vrstic vrnil: 133

Podvojene poizvedbe: #15 #57

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.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.01 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.02 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:280
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:667
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:225
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: 2.34 ms Poizvedba pomnilnika: 0.021 MB Spomin pred poizvedbi:1.671 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.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.01 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.03 ms
Sending data	0.03 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
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
8	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:96
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
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:667
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:225
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.021 MB Spomin pred poizvedbi:1.680 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.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.04 ms
end	0.00 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
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:280
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:667
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:225
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.92 ms Po zadnji poizvedbi: 9.22 ms Poizvedba pomnilnika: 0.089 MB Spomin pred poizvedbi:1.750 MB Vrstic vrnil: 53

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	54	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.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.17 ms
Sending data	0.40 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
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:78
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:142
14	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
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:668
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:225
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.86 ms Poizvedba pomnilnika: 0.022 MB Spomin pred poizvedbi:2.015 MB Vrstic vrnil: 3

Podvojene poizvedbe: #16

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.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.02 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.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:668
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:225
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: 14.95 ms Poizvedba pomnilnika: 0.021 MB Spomin pred poizvedbi:2.147 MB Vrstic vrnil: 0

SELECT *

  FROM `nov_location_types_migrirana`

  WHERE `slug`='sidrisce:lavsa-n-lavsa' 
  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.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.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.02 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:5166
11	LocationType::findByAlias()	JROOT/components/com_vodnikpojadranu/router.php:90
10	vodnikpojadranuParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
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:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
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:225
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: 2.50 ms Poizvedba pomnilnika: 0.031 MB Spomin pred poizvedbi:2.232 MB Vrstic vrnil: 133

Podvojene poizvedbe: #9 #57

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.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.01 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.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/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:1190
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:225
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.31 ms Poizvedba pomnilnika: 0.025 MB Spomin pred poizvedbi:2.265 MB Vrstic vrnil: 3

Podvojene poizvedbe: #13

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.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.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
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:1190
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:225
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: 35.81 ms Poizvedba pomnilnika: 0.022 MB Spomin pred poizvedbi:3.166 MB Vrstic vrnil: 1

SELECT *

  FROM `nov_locations`

  WHERE `id`=2986 
  LIMIT 1

Pojasnilo

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

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.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/components/com_vodnikpojadranu/models/vodnikpojadranu.php:4509
10	Location::find()	JROOT/components/com_vodnikpojadranu/classes/LocationModel.php:81
9	LocationModel->asLegacyLocation()	JROOT/components/com_vodnikpojadranu/controller.php:507
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:39
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Čas poizvedbe: 0.36 ms Po zadnji poizvedbi: 0.38 ms Poizvedba pomnilnika: 0.021 MB Spomin pred poizvedbi:3.176 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` = 2986 
  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	11	Using where
1	SIMPLE	dt	eq_ref	PRIMARY	PRIMARY	4	enavtika_db.d.type	1	Using where

Profil

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.02 ms
Sending data	0.08 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:4433
9	Location->getWind()	JROOT/components/com_vodnikpojadranu/controller.php:516
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:39
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:225
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.21 ms Po zadnji poizvedbi: 1.40 ms Poizvedba pomnilnika: 0.022 MB Spomin pred poizvedbi:3.192 MB Vrstic vrnil: 1

Podvojene poizvedbe: #22

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.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
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:5166
10	LocationType::findByAlias()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:611
9	VodnikPoJadranuModelVodnikPoJadranu->getNearbyLocations()	JROOT/components/com_vodnikpojadranu/controller.php:524
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:39
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:225
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.21 ms Po zadnji poizvedbi: 0.20 ms Poizvedba pomnilnika: 0.022 MB Spomin pred poizvedbi:3.204 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	79	Using where

Profil

Status	Duration
starting	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.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.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:5043
10	DataType::FindByOutput()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:627
9	VodnikPoJadranuModelVodnikPoJadranu->getNearbyLocations()	JROOT/components/com_vodnikpojadranu/controller.php:524
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:39
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:225
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: 13.57 ms Po zadnji poizvedbi: 0.11 ms Poizvedba pomnilnika: 0.022 MB Spomin pred poizvedbi:3.211 MB Vrstic vrnil: 3

SELECT DISTINCT l.*,(6371 * acos(cos(radians(43.756982567)) * cos(radians(l.lat)) * cos(radians(l.lng) - radians(15.367820739)) + sin(radians(43.756982567)) * 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 >= '2024-12-05 03:26:38')) 
  AND l.lat != 43.756982567 
  AND l.lng != 15.367820739 
  AND d.value REGEXP '([0-1]{6}11)'

  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	1302	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.08 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.08 ms
optimizing	0.03 ms
statistics	0.05 ms
preparing	0.03 ms
executing	0.00 ms
Creating tmp table	0.30 ms
Copying to tmp table	12.14 ms
Sorting result	0.38 ms
Sending data	0.07 ms
end	0.01 ms
removing tmp table	0.17 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.00 ms
closing tables	0.00 ms
removing tmp table	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
updating status	0.04 ms
cleaning up	0.01 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:678
9	VodnikPoJadranuModelVodnikPoJadranu->getNearbyLocations()	JROOT/components/com_vodnikpojadranu/controller.php:524
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:39
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:225
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.27 ms Poizvedba pomnilnika: 0.022 MB Spomin pred poizvedbi:3.221 MB Vrstic vrnil: 1

Podvojene poizvedbe: #19

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

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:5166
10	LocationType::findByAlias()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:611
9	VodnikPoJadranuModelVodnikPoJadranu->getNearbyLocations()	JROOT/components/com_vodnikpojadranu/controller.php:525
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:39
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:225
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: 31.80 ms Po zadnji poizvedbi: 0.14 ms Poizvedba pomnilnika: 0.022 MB Spomin pred poizvedbi:3.230 MB Vrstic vrnil: 3

SELECT DISTINCT l.*,(6371 * acos(cos(radians(43.756982567)) * cos(radians(l.lat)) * cos(radians(l.lng) - radians(15.367820739)) + sin(radians(43.756982567)) * 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 >= '2024-12-05 03:26:38')) 
  AND l.lat != 43.756982567 
  AND l.lng != 15.367820739

  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	2000	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.07 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.06 ms
optimizing	0.03 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.00 ms
Creating tmp table	0.27 ms
Copying to tmp table	29.74 ms
Sorting result	1.01 ms
Sending data	0.07 ms
end	0.00 ms
removing tmp table	0.29 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.01 ms
updating status	0.32 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:525
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:39
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:225
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.39 ms Po zadnji poizvedbi: 0.20 ms Poizvedba pomnilnika: 0.022 MB Spomin pred poizvedbi:3.243 MB Vrstic vrnil: 3

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

  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	11	Using where; 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.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.05 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.23 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:4755
9	Price::findManyByLocation()	JROOT/components/com_vodnikpojadranu/controller.php:529
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:39
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Čas poizvedbe: 0.32 ms Po zadnji poizvedbi: 0.14 ms Poizvedba pomnilnika: 0.022 MB Spomin pred poizvedbi:3.250 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	79	Using where

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.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.06 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.00 ms
updating status	0.26 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:189
9	VodnikPoJadranuModelVodnikPoJadranu->getDataTypes()	JROOT/components/com_vodnikpojadranu/controller.php:530
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:39
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:225
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.14 ms Poizvedba pomnilnika: 0.021 MB Spomin pred poizvedbi:3.257 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	79	Using where

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.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.01 ms
freeing items	0.00 ms
updating status	0.16 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:189
9	VodnikPoJadranuModelVodnikPoJadranu->getDataTypes()	JROOT/components/com_vodnikpojadranu/controller.php:531
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:39
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:225
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.08 ms Poizvedba pomnilnika: 0.022 MB Spomin pred poizvedbi:3.263 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	79	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.06 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.00 ms
updating status	0.21 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:189
9	VodnikPoJadranuModelVodnikPoJadranu->getDataTypes()	JROOT/components/com_vodnikpojadranu/controller.php:532
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:39
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Čas poizvedbe: 0.33 ms Po zadnji poizvedbi: 0.09 ms Poizvedba pomnilnika: 0.023 MB Spomin pred poizvedbi:3.269 MB Vrstic vrnil: 18

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	18	Uporabi filesort

Profil

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.03 ms
Sending data	0.10 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.00 ms
updating status	0.85 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:162
9	VodnikPoJadranuModelVodnikPoJadranu->getLocationTypes()	JROOT/components/com_vodnikpojadranu/controller.php:533
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:39
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:225
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.72 ms Po zadnji poizvedbi: 0.76 ms Poizvedba pomnilnika: 0.023 MB Spomin pred poizvedbi:3.305 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` = 2986 
  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	11	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.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.07 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.20 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()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:3979
13	Location->getHTMLData()	JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php:10
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:534
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:39
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:225
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: 0.10 ms Poizvedba pomnilnika: 0.024 MB Spomin pred poizvedbi:3.314 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` = 2986 
  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	11	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.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.03 ms
preparing	0.01 ms
executing	0.00 ms
Creating tmp table	0.19 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.19 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()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:3920
13	Location->getTableData()	JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php:11
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:534
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:39
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:225
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.10 ms Poizvedba pomnilnika: 0.023 MB Spomin pred poizvedbi:3.324 MB Vrstic vrnil: 3

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

Pojasnilo

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

Profil

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

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php:29
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:534
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:39
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:225
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.335 MB Vrstic vrnil: 1

SELECT *

  FROM `nov_galleries`

  WHERE `id`=3268 
  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.01 ms
freeing items	0.00 ms
updating status	0.95 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()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:4297
13	Location->gallery()	JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php:35
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:534
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:39
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:225
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.75 ms Po zadnji poizvedbi: 675.02 ms Poizvedba pomnilnika: 0.025 MB Spomin pred poizvedbi:3.402 MB Vrstic vrnil: 0

SELECT *

  FROM `nov_gallery_items`

  WHERE `galleryid`=3268 
  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	709	Using where

Profil

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After table lock	0.01 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.03 ms
preparing	0.04 ms
executing	0.01 ms
Sorting result	0.01 ms
Sending data	1.09 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.09 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:1394
14	Gallery->youtube()	JROOT/components/com_vodnikpojadranu/views/location/tmpl/gallery.php:43
13	require JROOT/components/com_vodnikpojadranu/views/location/tmpl/gallery.php	JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php:57
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:534
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:39
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:225
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: 0.21 ms Poizvedba pomnilnika: 0.023 MB Spomin pred poizvedbi:3.410 MB Vrstic vrnil: 1

Podvojene poizvedbe: #36 #37 #38 #39

SELECT *

  FROM `nov_location_types_migrirana`

  WHERE `id` = 3

Pojasnilo

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

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.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.02 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.05 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()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:4183
13	Location->getLocationType()	JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php:95
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:534
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:39
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:225
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.81 ms Po zadnji poizvedbi: 12.57 ms Poizvedba pomnilnika: 0.023 MB Spomin pred poizvedbi:3.928 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` = 2986 
  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	11	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.11 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.04 ms
optimizing	0.04 ms
statistics	0.09 ms
preparing	0.04 ms
executing	0.01 ms
Creating tmp table	1.34 ms
Copying to tmp table	0.28 ms
Sorting result	0.05 ms
Sending data	0.03 ms
end	0.01 ms
removing tmp table	0.42 ms
end	0.01 ms
query end	0.04 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.10 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()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:3949
13	Location->getAutocompleteData()	JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php:210
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:534
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:39
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:225
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.56 ms Poizvedba pomnilnika: 0.024 MB Spomin pred poizvedbi:3.935 MB Vrstic vrnil: 1

Podvojene poizvedbe: #34 #37 #38 #39

SELECT *

  FROM `nov_location_types_migrirana`

  WHERE `id` = 3

Pojasnilo

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

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.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.02 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.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:4183
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:256
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:534
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:39
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:225
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.02 ms Poizvedba pomnilnika: 0.024 MB Spomin pred poizvedbi:3.945 MB Vrstic vrnil: 1

Podvojene poizvedbe: #34 #36 #38 #39

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.01 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:4183
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:256
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:534
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:39
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:225
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.21 ms Poizvedba pomnilnika: 0.024 MB Spomin pred poizvedbi:3.954 MB Vrstic vrnil: 1

Podvojene poizvedbe: #34 #36 #37 #39

SELECT *

  FROM `nov_location_types_migrirana`

  WHERE `id` = 3

Pojasnilo

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

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.00 ms
updating status	0.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:4183
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:256
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:534
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:39
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:225
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.19 ms Poizvedba pomnilnika: 0.024 MB Spomin pred poizvedbi:3.963 MB Vrstic vrnil: 1

Podvojene poizvedbe: #34 #36 #37 #38

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.01 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:4183
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:256
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:534
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:39
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:225
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.13 ms Poizvedba pomnilnika: 0.024 MB Spomin pred poizvedbi:3.987 MB Vrstic vrnil: 1

SELECT *

  FROM `nov_location_types_migrirana`

  WHERE `id` = 1

Pojasnilo

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

Profil

Status	Duration
starting	0.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.01 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:4183
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:256
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:534
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:39
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:225
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.17 ms Poizvedba pomnilnika: 0.024 MB Spomin pred poizvedbi:3.996 MB Vrstic vrnil: 1

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.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.01 ms
freeing items	0.01 ms
updating status	0.04 ms
cleaning up	0.02 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:4183
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:256
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:534
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:39
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:225
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.95 ms Po zadnji poizvedbi: 0.45 ms Poizvedba pomnilnika: 0.024 MB Spomin pred poizvedbi:4.009 MB Vrstic vrnil: 0

SELECT l.*, e.*, (6371 * acos(cos(radians(43.756982567)) * cos(radians(l.lat)) * cos(radians(l.lng) - radians(15.367820739)) + sin(radians(43.756982567)) * 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.756982567)) * cos(radians(l.lat)) * cos(radians(l.lng) - radians(15.367820739)) + sin(radians(43.756982567)) * sin(radians(l.lat)))) < 35 
  AND l.published = 1 
  AND e.start <= '2024-12-05 03:26:38' 
  AND e.end >= '2024-12-05 03:26:38'

  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	60	Using where; Using temporary; Uporabi filesort
1	SIMPLE	l	eq_ref	PRIMARY	PRIMARY	4	enavtika_db.e.locationid	1	Using where

Profil

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

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:3732
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:257
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:534
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:39
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:225
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.12 ms Poizvedba pomnilnika: 0.024 MB Spomin pred poizvedbi:4.018 MB Vrstic vrnil: 0

SELECT l.*, e.*, (6371 * acos(cos(radians(43.756982567)) * cos(radians(l.lat)) * cos(radians(l.lng) - radians(15.367820739)) + sin(radians(43.756982567)) * 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.756982567)) * cos(radians(l.lat)) * cos(radians(l.lng) - radians(15.367820739)) + sin(radians(43.756982567)) * sin(radians(l.lat)))) < 35 
  AND l.published = 1 
  AND e.start >= '2024-12-05 03:26:38'

  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	60	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.07 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.03 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.00 ms
Creating tmp table	0.28 ms
Copying to tmp table	0.12 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:3732
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:257
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:534
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:39
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:225
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.73 ms Poizvedba pomnilnika: 0.024 MB Spomin pred poizvedbi:4.023 MB Vrstic vrnil: 0

SELECT *

  FROM `nov_jcomments`

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

  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.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 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.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:4320
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:268
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:534
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:39
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Čas poizvedbe: 0.37 ms Po zadnji poizvedbi: 0.14 ms Poizvedba pomnilnika: 0.023 MB Spomin pred poizvedbi:4.031 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` = 1588 
  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	11	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.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.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:4433
13	Location->getWind()	JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php:347
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:534
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:39
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:225
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.60 ms Po zadnji poizvedbi: 0.10 ms Poizvedba pomnilnika: 0.023 MB Spomin pred poizvedbi:4.038 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` = 164 
  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.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.33 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.00 ms

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:4433
13	Location->getWind()	JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php:347
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:534
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:39
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Čas poizvedbe: 0.33 ms Po zadnji poizvedbi: 0.10 ms Poizvedba pomnilnika: 0.023 MB Spomin pred poizvedbi:4.045 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` = 3006 
  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	11	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.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.07 ms
end	0.00 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
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:4433
13	Location->getWind()	JROOT/components/com_vodnikpojadranu/views/location/tmpl/default.php:347
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:534
8	VodnikPoJadranuController->getLocation()	JROOT/components/com_vodnikpojadranu/controller.php:39
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:225
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: 1.17 ms Poizvedba pomnilnika: 0.021 MB Spomin pred poizvedbi:4.089 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	55	Using where

Profil

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

Sklad klica

#	Klicatelj	Datoteka in številka vrsstice
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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: 6.11 ms Poizvedba pomnilnika: 0.024 MB Spomin pred poizvedbi:4.116 MB Vrstic vrnil: 11

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 <= '2024-12-05 02:26:39') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-12-05 02:26:39') 
  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	27	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.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.00 ms
Sorting result	0.13 ms
Sending data	0.23 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()	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:441
11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
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:601
8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/enavtika/index.php:121
7	require JROOT/templates/enavtika/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
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:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Čas poizvedbe: 0.32 ms Po zadnji poizvedbi: 6.33 ms Poizvedba pomnilnika: 0.022 MB Spomin pred poizvedbi:4.249 MB Vrstic vrnil: 0

Podvojene poizvedbe: #53

SELECT *

  FROM nov_banners

  WHERE '2024-12-05 02:26:39' >= '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.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.01 ms
init	0.03 ms
optimizing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.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/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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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.10 ms Po zadnji poizvedbi: 1.91 ms Poizvedba pomnilnika: 0.023 MB Spomin pred poizvedbi:4.268 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 <= '2024-12-05 02:26:39') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-05 02:26:39') 
  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	35	Using where; Using temporary; Uporabi filesort
1	SIMPLE	cl	eq_ref	PRIMARY	PRIMARY	4	enavtika_db.a.cid	1

Profil

Status	Duration
starting	0.07 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.06 ms
preparing	0.02 ms
executing	0.00 ms
Creating tmp table	0.24 ms
Copying to tmp table	0.30 ms
Sorting result	0.03 ms
Sending data	0.02 ms
end	0.01 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.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:322
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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.23 ms Poizvedba pomnilnika: 0.006 MB Spomin pred poizvedbi:4.281 MB

UPDATE nov_banners

  SET impmade = (impmade + 1)

  WHERE id IN (47)

Pojasnilo

Pojasnilo ni na voljo za poizvedbo: UPDATE nov_banners SET impmade = (impmade + 1) WHERE id IN (47)

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.03 ms
Updating	0.04 ms
end	0.01 ms
query end	0.03 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/components/com_banners/models/banners.php:268
12	BannersModelBanners->impress()	JROOT/modules/mod_banners/helper.php:54
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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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: 2.05 ms Poizvedba pomnilnika: 0.022 MB Spomin pred poizvedbi:4.284 MB Vrstic vrnil: 0

Podvojene poizvedbe: #50

SELECT *

  FROM nov_banners

  WHERE '2024-12-05 02:26:39' >= '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.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.01 ms
init	0.02 ms
optimizing	0.01 ms
executing	0.03 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/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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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: 0.14 ms Poizvedba pomnilnika: 0.023 MB Spomin pred poizvedbi:4.295 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 <= '2024-12-05 02:26:39') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-05 02:26:39') 
  AND (a.imptotal = 0 OR a.impmade < a.imptotal) 
  AND a.catid IN (25,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	35	Using where; Using temporary; Uporabi filesort
1	SIMPLE	cl	eq_ref	PRIMARY	PRIMARY	4	enavtika_db.a.cid	1

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.03 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.00 ms
Creating tmp table	0.22 ms
Copying to tmp table	0.26 ms
Sorting result	0.03 ms
Sending data	0.03 ms
end	0.01 ms
removing tmp table	0.11 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.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/libraries/src/MVC/Model/BaseDatabaseModel.php:322
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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.10 ms Poizvedba pomnilnika: 0.006 MB Spomin pred poizvedbi:4.307 MB

UPDATE nov_banners

  SET impmade = (impmade + 1)

  WHERE id IN (243)

Pojasnilo

Pojasnilo ni na voljo za poizvedbo: UPDATE nov_banners SET impmade = (impmade + 1) WHERE id IN (243)

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.03 ms
Updating	0.03 ms
end	0.01 ms
query end	0.02 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/components/com_banners/models/banners.php:268
12	BannersModelBanners->impress()	JROOT/modules/mod_banners/helper.php:54
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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Čas poizvedbe: 0.37 ms Po zadnji poizvedbi: 2.34 ms Poizvedba pomnilnika: 0.023 MB Spomin pred poizvedbi:4.318 MB Vrstic vrnil: 3

SELECT `c2`.`language`,`c2`.`id`

  FROM `nov_menu` AS `c`

  INNER JOIN `nov_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item'

  INNER JOIN `nov_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key`

  INNER JOIN `nov_menu` AS `c2` 
  ON a2.id = c2.`id`

  WHERE c.id = 116

Pojasnilo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	a	const	PRIMARY,idx_key	PRIMARY	206	const,const	1
1	SIMPLE	a2	ref	idx_key	idx_key	128	const	3	Using index
1	SIMPLE	c2	eq_ref	PRIMARY	PRIMARY	4	enavtika_db.a2.id	1

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.00 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.02 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 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.01 ms
updating status	0.05 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/libraries/src/Language/Associations.php:115
13	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
12	MenusHelper::getAssociations()	JROOT/modules/mod_languages/helper.php:58
11	ModLanguagesHelper::getList()	JROOT/modules/mod_languages/mod_languages.php:17
10	include JROOT/modules/mod_languages/mod_languages.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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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: 6.01 ms Poizvedba pomnilnika: 0.036 MB Spomin pred poizvedbi:4.459 MB Vrstic vrnil: 133

Podvojene poizvedbe: #9 #15

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.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.01 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.08 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
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/components/com_jomclassifieds/etc/utils.php:109
20	JomclUtils::getCfg()	JROOT/components/com_jomclassifieds/router.php:72
19	JomClassifiedsBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
18	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_menu/helper.php:139
11	ModMenuHelper::getList()	JROOT/modules/mod_menu/mod_menu.php:15
10	include JROOT/modules/mod_menu/mod_menu.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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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.75 ms Po zadnji poizvedbi: 9.27 ms Poizvedba pomnilnika: 0.027 MB Spomin pred poizvedbi:4.530 MB Vrstic vrnil: 36

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `nov_assets`

  WHERE `name` IN ('root.1','com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_helloworld','com_hikashop','com_installer','com_jcomments','com_jomclassifieds','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_vodnikpojadranu','com_wrapper')

Pojasnilo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nov_assets	range	idx_asset_name	idx_asset_name	202	NULL	37	Using index condition

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.06 ms
optimizing	0.01 ms
statistics	0.11 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.34 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
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/sourcerer/src/Params.php:42
11	RegularLabs\Sourcerer\Params::get()	JROOT/plugins/system/sourcerer/src/Helper.php:91
10	RegularLabs\Sourcerer\Helper->onAfterRender()	Enako kot klic v vrstici spodaj.
9	call_user_func_array()	JROOT/plugins/system/sourcerer/src/Plugin.php:105
8	RegularLabs\Sourcerer\Plugin->run()	JROOT/plugins/system/sourcerer/src/Plugin.php:82
7	RegularLabs\Sourcerer\Plugin->onAfterRender()	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/CMSApplication.php:1118
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:231
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]

34 vrste poizvedbe prijavljen, razvrščenih po pojavov.

IZBERI tabele:

10 × SELECT * 
  FROM `nov_location_types_migrirana`

4 × SELECT * 
  FROM `nov_data` AS d 
  LEFT JOIN nov_data_types AS dt 
  ON dt.id = d.type

3 × SELECT id as datatypeid, name as datatypename 
  FROM `nov_data_types`

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

3 × SELECT name,value 
  FROM nov_jomcl_option

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `nov_extensions`

2 × SELECT l.*, e.*, (6371 * acos(cos(radians(43.756982567)) * cos(radians(l.lat)) * cos(radians(l.lng) - radians(15.367820739)) + sin(radians(43.756982567)) * sin(radians(l.lat)))) AS distance 
  FROM nov_locations AS l 
  LEFT JOIN nov_events AS e 
  ON l.id = e.locationid

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

```
2 × SELECT * 
  FROM nov_banners 
```

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

```
1 × SELECT * 
  FROM `nov_jcomments` 
```

1 × SELECT language,id 
  FROM `nov_menu`

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

1 × SELECT * 
  FROM `nov_gallery_items`

```
1 × SELECT * 
  FROM `nov_galleries` 
```

1 × SELECT `c2`.`language`,`c2`.`id` 
  FROM `nov_menu` AS `c` 
  INNER JOIN `nov_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item' 
  INNER JOIN `nov_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key` 
  INNER JOIN `nov_menu` AS `c2` 
  ON a2.id = c2.`id`

1 × SELECT lang_code, title_native, image 
  FROM nov_languages

1 × SELECT `session_id` 
  FROM `nov_session`

1 × SELECT DISTINCT l.*,(6371 * acos(cos(radians(43.756982567)) * cos(radians(l.lat)) * cos(radians(l.lng) - radians(15.367820739)) + sin(radians(43.756982567)) * sin(radians(l.lat)))) AS distance 
  FROM nov_locations AS l 
  LEFT JOIN (SELECT * 
  FROM nov_events) AS e 
  ON l.id = e.locationid

1 × SELECT * 
  FROM `nov_location_types_migrirana` AS lt

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

1 × SELECT DISTINCT l.*,(6371 * acos(cos(radians(43.756982567)) * cos(radians(l.lat)) * cos(radians(l.lng) - radians(15.367820739)) + sin(radians(43.756982567)) * 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

1 × SELECT * 
  FROM `nov_data_types`

```
1 × SELECT * 
  FROM `nov_locations` 
```

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

1 × SELECT `element`,`name`,`client_id`,`extension_id` 
  FROM `nov_extensions`

```
1 × SELECT * 
  FROM nov_languages 
```

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM nov_extensions

1 × SELECT b.id 
  FROM nov_usergroups AS a 
  LEFT JOIN nov_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT id, rules 
  FROM `nov_viewlevels

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `nov_assets`

OSTALE tabele:

2 × UPDATE nov_banners 
  SET impmade = (impmade + 1)

1 × INSERT INTO `nov_session` (`session_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  (X'743334366469736e6861346939377134383176367239696a3335', 1, 1733365598, 0, ''

1 × UPDATE `nov_extensions` 
  SET `params` = '{\"mediaversion\":\"5c94d502ae61c818239bcf17557a0757\"}'