Home

Porti turistici

Ovca Ancoraggio

Vrulje N Ancoraggio

Lavsa N Ancoraggio

Ristoranti / Servizi / Segnali

Mir Attrazione

Servizio Luxury Marine, TBM Infinitum, Blaž Koščak s.p.

Luxury Marine, TBM Infinitum, Blaž Koščak s.p. Servizio

Stal MAR d.o.o. Servizio

Eventi

08.05.2021 - 08.05.2021	Izolanka PS, PSO	Izola
08.05.2021 - 08.05.2021	Testne plove Saxdor 200 Sport	Portorož
15.05.2021 - 15.05.2021	Regata Marinada	Izola
15.05.2021 - 16.05.2021	Portorož - Novi grad (ali Poreč) – Portorož Portorož- Novi grad(Poreč)	Portorož
19.05.2021 - 23.05.2021	Portorož 44 Cup Piran	Portorož

Ultimo dal eShop

39.95€

888 pristanov in zalivov, sedaj v barvah in z novimi, dopolnjenimi podatki. Knjiga je prenovljena in tekoče ažurirana. V njej so prikazani detajli zalivov in pristanišč s kratkimi opisi in oznakami za možnost priveza ter simboli za nevarne, ali pa neugodne vetrove, ki povzročijo na privezu samo neprijetno bibavico. V njem je tudi obilo ostalih uporabnih podatkov, kot so podatki o odpiralnih časih na bencinskih črpalkah, vse pomembne telefonske številke (kapitanij, marin zdravstvenih domov, …..)

O knjigi:

izdaja: 7. dopolnjena izdaja
avtor: Karl-H. Bestandig
slovenska izdaja: Gorazd Cizej
strani: 120

888 pristanov in zalivov

Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1620413969,
                "last": 1620413969,
                "now": 1620413969
            }
        },
        "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": "it-IT"
        }
    }
}

Informazioni profilo

Tempo

Memoria

Tempo: 22.53 ms / 22.53 ms Memoria: 0.565 MB / 0.95 MB Application: afterLoad

Tempo: 80.81 ms / 103.34 ms Memoria: 1.431 MB / 2.38 MB Application: afterInitialise

Tempo: 30.60 ms / 133.94 ms Memoria: 0.694 MB / 3.07 MB Application: afterRoute

Tempo: 1.12 ms / 135.06 ms Memoria: 0.104 MB / 3.17 MB Application: beforeRenderComponent com_vodnikpojadranu

Tempo: 260.81 ms / 395.87 ms Memoria: 0.615 MB / 3.79 MB Application: afterRenderComponent com_vodnikpojadranu

Tempo: 6.52 ms / 402.39 ms Memoria: 0.045 MB / 3.83 MB Application: afterDispatch

Tempo: 1.78 ms / 404.18 ms Memoria: 0.031 MB / 3.87 MB Application: beforeRenderModule mod_banners (Banner bottom)

Tempo: 9.09 ms / 413.27 ms Memoria: 0.133 MB / 4.00 MB Application: afterRenderModule mod_banners (Banner bottom)

Tempo: 0.13 ms / 413.40 ms Memoria: 0.000 MB / 3.99 MB Application: beforeRenderModule mod_banners (Banner top)

Tempo: 4.98 ms / 418.38 ms Memoria: 0.057 MB / 4.05 MB Application: afterRenderModule mod_banners (Banner top)

Tempo: 0.10 ms / 418.48 ms Memoria: 0.000 MB / 4.04 MB Application: beforeRenderModule mod_languages (Language switcher)

Tempo: 4.49 ms / 422.96 ms Memoria: 0.014 MB / 4.06 MB Application: afterRenderModule mod_languages (Language switcher)

Tempo: 0.10 ms / 423.06 ms Memoria: 0.000 MB / 4.06 MB Application: beforeRenderModule mod_menu (Main Menu)

Tempo: 1.40 ms / 424.46 ms Memoria: 0.033 MB / 4.09 MB Application: afterRenderModule mod_menu (Main Menu)

Tempo: 0.04 ms / 424.50 ms Memoria: 0.000 MB / 4.09 MB Application: beforeRenderModule mod_menu (English menu)

Tempo: 0.51 ms / 425.01 ms Memoria: 0.004 MB / 4.09 MB Application: afterRenderModule mod_menu (English menu)

Tempo: 0.03 ms / 425.05 ms Memoria: 0.000 MB / 4.09 MB Application: beforeRenderModule mod_menu (Italian menu)

Tempo: 5.63 ms / 430.68 ms Memoria: 0.108 MB / 4.20 MB Application: afterRenderModule mod_menu (Italian menu)

Tempo: 6.62 ms / 437.30 ms Memoria: 0.067 MB / 4.26 MB Application: Before Access::preloadComponents (all components)

Tempo: 1.80 ms / 439.09 ms Memoria: 0.056 MB / 4.32 MB Application: After Access::preloadComponents (all components)

Tempo: 0.06 ms / 439.15 ms Memoria: 0.000 MB / 4.31 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Tempo: 1.28 ms / 440.43 ms Memoria: 0.009 MB / 4.32 MB Application: After Access::getAssetRules (id:1 name:root.1)

Tempo: 5.31 ms / 445.73 ms Memoria: 0.151 MB / 4.48 MB Application: afterRender

Query totali del database: 190.81 ms

Utilizzo memoria

Query Database

67 query eseguite 190.81 ms

Trovati 14 duplicati!

3 duplicati: #11 #15 #66

2 duplicati: #14 #16

2 duplicati: #31 #38

2 duplicati: #48 #50

3 duplicati: #49 #51 #52

2 duplicati: #56 #61

Tempo della query: 0.55 ms Memoria query: 0.025 MB memoria prima della query: 1.219 MB Righe restituite: 0

SELECT `data`

  FROM `nov_session`

  WHERE `session_id` = X'63617168766a326b7368676a376a646c626168376d746461316e'

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Chiamata uguale alla linea sottostante.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.36 ms Dopo l'ultima query: 1.96 ms Memoria query: 0.022 MB memoria prima della query: 1.297 MB Righe restituite: 0

SELECT `session_id`

  FROM `nov_session`

  WHERE `session_id` = X'63617168766a326b7368676a376a646c626168376d746461316e' 
  LIMIT 1

Explain

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

Profilo

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.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

Call Stack

#	Caller	File e numero di linea
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.78 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.004 MB memoria prima della query: 1.302 MB

INSERT INTO `nov_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'63617168766a326b7368676a376a646c626168376d746461316e', 1, 1620413969, 0, '', 0)

Explain

EXPLAIN non possibile sulla query: INSERT INTO `nov_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'63617168766a326b7368676a376a646c626168376d746461316e', 1, 1620413969, 0, '', 0)

Profilo

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.01 ms
After table lock	0.00 ms
init	0.02 ms
update	0.06 ms
end	0.00 ms
query end	0.31 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.61 ms Dopo l'ultima query: 4.03 ms Memoria query: 0.029 MB memoria prima della query: 1.338 MB Righe restituite: 36

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

  FROM `nov_extensions`

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

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
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}()	Chiamata uguale alla linea sottostante.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.30 ms Dopo l'ultima query: 3.27 ms Memoria query: 0.023 MB memoria prima della query: 1.369 MB Righe restituite: 5

SELECT id, rules

  FROM `nov_viewlevels`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nov_viewlevels	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	5

Profilo

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
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.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.33 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.022 MB memoria prima della query: 1.381 MB Righe restituite: 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

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.14 ms Dopo l'ultima query: 0.18 ms Memoria query: 0.034 MB memoria prima della query: 1.402 MB Righe restituite: 105

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

  FROM nov_extensions

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

  ORDER BY ordering

Explain

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

Profilo

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.04 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.53 ms
Sending data	0.25 ms
end	0.01 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

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Chiamata uguale alla linea sottostante.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.34 ms Dopo l'ultima query: 1.03 ms Memoria query: 0.025 MB memoria prima della query: 1.458 MB Righe restituite: 3

SELECT *

  FROM nov_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nov_languages	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	3	Using where; Using filesort

Profilo

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

Call Stack

#	Caller	File e numero di linea
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Language/LanguageHelper.php:67
4	Joomla\CMS\Language\LanguageHelper::detectLanguage()	JROOT/libraries/src/Application/SiteApplication.php:653
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.48 ms Dopo l'ultima query: 11.80 ms Memoria query: 0.027 MB memoria prima della query: 1.891 MB Righe restituite: 1

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

  FROM `nov_extensions`

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

Explain

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

Profilo

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.07 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

Call Stack

#	Caller	File e numero di linea
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}()	Chiamata uguale alla linea sottostante.
15	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
13	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
12	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
11	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
10	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
9	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
8	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jomclassifiedslocationmanager/jomclassifiedslocationmanager.php:18
7	plgSystemJomclassifiedsLocationManager->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.75 ms Dopo l'ultima query: 0.22 ms Memoria query: 0.006 MB memoria prima della query: 1.884 MB

UPDATE `nov_extensions`

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

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

Explain

EXPLAIN non possibile sulla query: UPDATE `nov_extensions` SET `params` = '{\"mediaversion\":\"e5056dfe7105ec8e1f07d2f1f627ad5b\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profilo

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.06 ms
Updating	0.05 ms
end	0.01 ms
query end	0.33 ms
closing tables	0.03 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.00 ms

Call Stack

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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.34 ms Dopo l'ultima query: 1.27 ms Memoria query: 0.034 MB memoria prima della query: 1.967 MB Righe restituite: 133

Query duplicate: #15 #66

SELECT name,value 
  FROM nov_jomcl_options

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nov_jomcl_options	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	133

Profilo

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

Call Stack

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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.44 ms Dopo l'ultima query: 2.75 ms Memoria query: 0.023 MB memoria prima della query: 2.009 MB Righe restituite: 6

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

  FROM `nov_extensions`

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

Explain

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

Profilo

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.06 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

Call Stack

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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.70 ms Dopo l'ultima query: 9.80 ms Memoria query: 0.083 MB memoria prima della query: 2.079 MB Righe restituite: 50

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM nov_menu AS m

  LEFT JOIN nov_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	51	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	enavtika_db.m.component_id	1	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
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}()	Chiamata uguale alla linea sottostante.
19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
17	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
16	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
15	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
14	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
13	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
12	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:434
11	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/mvcoverride/mvcoverride.php:999
10	PlgSystemMVCOverride->_getIncludePaths()	JROOT/plugins/system/mvcoverride/mvcoverride.php:474
9	PlgSystemMVCOverride->_autoOverride()	JROOT/plugins/system/mvcoverride/mvcoverride.php:146
8	PlgSystemMVCOverride->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.56 ms Dopo l'ultima query: 1.65 ms Memoria query: 0.024 MB memoria prima della query: 2.272 MB Righe restituite: 3

Query duplicate: #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

Explain

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	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	5	Using where; Using join buffer (flat, BNL join)

Profilo

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

Call Stack

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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.42 ms Dopo l'ultima query: 31.99 ms Memoria query: 0.035 MB memoria prima della query: 3.040 MB Righe restituite: 133

Query duplicate: #11 #66

SELECT name,value 
  FROM nov_jomcl_options

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nov_jomcl_options	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	133

Profilo

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

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jomclassifiedslocationmanager/jomclassifiedslocationmanager.php:398
9	plgSystemJomclassifiedsLocationManager->getCfg()	JROOT/plugins/system/jomclassifiedslocationmanager/jomclassifiedslocationmanager.php:111
8	plgSystemJomclassifiedsLocationManager->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.43 ms Dopo l'ultima query: 2.61 ms Memoria query: 0.027 MB memoria prima della query: 3.077 MB Righe restituite: 3

Query duplicate: #14

SELECT id, home, template, s.params

  FROM nov_template_styles as s

  LEFT JOIN nov_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explain

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	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	5	Using where; Using join buffer (flat, BNL join)

Profilo

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.01 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.00 ms
updating status	0.04 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
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()	Chiamata uguale alla linea sottostante.
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()	Chiamata uguale alla linea sottostante.
11	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
10	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
9	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/plugins/system/jomclassifiedslocationmanager/jomclassifiedslocationmanager.php:117
8	plgSystemJomclassifiedsLocationManager->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.33 ms Dopo l'ultima query: 10.05 ms Memoria query: 0.028 MB memoria prima della query: 3.310 MB Righe restituite: 17

SELECT *

  FROM `nov_location_types_migrirana`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nov_location_types_migrirana	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	17

Profilo

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

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:5060
9	LocationType::allToArray()	JROOT/components/com_vodnikpojadranu/controller.php:2051
8	VodnikPoJadranuController->getFront()	JROOT/components/com_vodnikpojadranu/controller.php:131
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.45 ms Dopo l'ultima query: 0.17 ms Memoria query: 0.028 MB memoria prima della query: 3.320 MB Righe restituite: 3

SELECT l.*, t.name as typename, t.slug as typeslug

  FROM `nov_locations` AS `l`

  LEFT JOIN nov_location_types_migrirana AS t 
  ON t.id = l.type

  WHERE `l`.`published` = 1 
  AND `l`.`type` IN (1, 3, 2)

  ORDER BY created DESC 
  LIMIT 3

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	l	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1903	Using where; Using filesort
1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	enavtika_db.l.type	1

Profilo

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	1.05 ms
Sending data	0.05 ms
end	0.01 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

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:3786
9	Location::findMany()	JROOT/components/com_vodnikpojadranu/controller.php:2058
8	VodnikPoJadranuController->getFront()	JROOT/components/com_vodnikpojadranu/controller.php:131
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.26 ms Dopo l'ultima query: 0.97 ms Memoria query: 0.025 MB memoria prima della query: 3.342 MB Righe restituite: 1

SELECT *

  FROM `nov_galleries`

  WHERE `id`=3271 
  LIMIT 1

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:4261
10	Location->gallery()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:3794
9	Location::findMany()	JROOT/components/com_vodnikpojadranu/controller.php:2058
8	VodnikPoJadranuController->getFront()	JROOT/components/com_vodnikpojadranu/controller.php:131
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.27 ms Dopo l'ultima query: 0.59 ms Memoria query: 0.025 MB memoria prima della query: 3.353 MB Righe restituite: 1

SELECT *

  FROM `nov_galleries`

  WHERE `id`=3269 
  LIMIT 1

Explain

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

Profilo

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.02 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:4261
10	Location->gallery()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:3794
9	Location::findMany()	JROOT/components/com_vodnikpojadranu/controller.php:2058
8	VodnikPoJadranuController->getFront()	JROOT/components/com_vodnikpojadranu/controller.php:131
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.23 ms Dopo l'ultima query: 0.46 ms Memoria query: 0.025 MB memoria prima della query: 3.364 MB Righe restituite: 1

SELECT *

  FROM `nov_galleries`

  WHERE `id`=3268 
  LIMIT 1

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:4261
10	Location->gallery()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:3794
9	Location::findMany()	JROOT/components/com_vodnikpojadranu/controller.php:2058
8	VodnikPoJadranuController->getFront()	JROOT/components/com_vodnikpojadranu/controller.php:131
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.47 ms Dopo l'ultima query: 0.36 ms Memoria query: 0.028 MB memoria prima della query: 3.360 MB Righe restituite: 3

SELECT l.*, t.name as typename, t.slug as typeslug

  FROM `nov_locations` AS `l`

  LEFT JOIN nov_location_types_migrirana AS t 
  ON t.id = l.type

  WHERE `l`.`published` = 1 
  AND `l`.`type` IN (4, 5, 6, 7, 8, 9, 11, 14, 16, 17, 18, 19, 21)

  ORDER BY created DESC 
  LIMIT 3

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	l	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1903	Using where; Using filesort
1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	enavtika_db.l.type	1

Profilo

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	1.11 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

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:3786
9	Location::findMany()	JROOT/components/com_vodnikpojadranu/controller.php:2065
8	VodnikPoJadranuController->getFront()	JROOT/components/com_vodnikpojadranu/controller.php:131
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.26 ms Dopo l'ultima query: 0.24 ms Memoria query: 0.025 MB memoria prima della query: 3.381 MB Righe restituite: 1

SELECT *

  FROM `nov_galleries`

  WHERE `id`=3270 
  LIMIT 1

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:4261
10	Location->gallery()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:3794
9	Location::findMany()	JROOT/components/com_vodnikpojadranu/controller.php:2065
8	VodnikPoJadranuController->getFront()	JROOT/components/com_vodnikpojadranu/controller.php:131
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.25 ms Dopo l'ultima query: 0.47 ms Memoria query: 0.025 MB memoria prima della query: 3.391 MB Righe restituite: 1

SELECT *

  FROM `nov_galleries`

  WHERE `id`=3237 
  LIMIT 1

Explain

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

Profilo

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.02 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:4261
10	Location->gallery()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:3794
9	Location::findMany()	JROOT/components/com_vodnikpojadranu/controller.php:2065
8	VodnikPoJadranuController->getFront()	JROOT/components/com_vodnikpojadranu/controller.php:131
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.25 ms Dopo l'ultima query: 0.45 ms Memoria query: 0.025 MB memoria prima della query: 3.402 MB Righe restituite: 1

SELECT *

  FROM `nov_galleries`

  WHERE `id`=3236 
  LIMIT 1

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:4261
10	Location->gallery()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:3794
9	Location::findMany()	JROOT/components/com_vodnikpojadranu/controller.php:2065
8	VodnikPoJadranuController->getFront()	JROOT/components/com_vodnikpojadranu/controller.php:131
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.40 ms Dopo l'ultima query: 0.52 ms Memoria query: 0.029 MB memoria prima della query: 3.401 MB Righe restituite: 5

SELECT *

  FROM `nov_events`

  WHERE `status` = 1 
  AND `start` >= '2021-05-07 20:59:29'

  ORDER BY start ASC 
  LIMIT 5

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nov_events	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	38	Using where; Using filesort

Profilo

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.06 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

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:2659
9	Event::all()	JROOT/components/com_vodnikpojadranu/controller.php:2070
8	VodnikPoJadranuController->getFront()	JROOT/components/com_vodnikpojadranu/controller.php:131
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.59 ms Dopo l'ultima query: 0.28 ms Memoria query: 0.031 MB memoria prima della query: 3.422 MB Righe restituite: 2

SELECT news.id,news.title,news.alias,news.introtext,news.catid,news.publish_up,news.images,categories.title AS category_title,categories.id AS category_id

  FROM nov_content AS news

  LEFT JOIN nov_categories AS categories 
  ON categories.id = news.catid

  WHERE publish_up <= '2021-05-07 18:59:29' 
  AND categories.parent_id = 11 
  AND news.state = 1 
  AND news.language = 'it-IT'

  ORDER BY publish_up DESC 
  LIMIT 2

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	news	ref	idx_state,idx_catid,idx_language	idx_language	28	const	9	Using index condition; Using where; Using filesort
1	SIMPLE	categories	eq_ref	PRIMARY	PRIMARY	4	enavtika_db.news.catid	1	Using where

Profilo

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.03 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.13 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/repositories/LatestNewsRepository.php:49
10	LatestNewsRepository->latestNews()	JROOT/components/com_vodnikpojadranu/repositories/LatestNewsRepository.php:14
9	LatestNewsRepository->getNewsByCategory()	JROOT/components/com_vodnikpojadranu/controller.php:2071
8	VodnikPoJadranuController->getFront()	JROOT/components/com_vodnikpojadranu/controller.php:131
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.59 ms Dopo l'ultima query: 0.26 ms Memoria query: 0.025 MB memoria prima della query: 3.442 MB Righe restituite: 0

SELECT news.id,news.title,news.alias,news.introtext,news.catid,news.publish_up,news.images,categories.title AS category_title,categories.id AS category_id

  FROM nov_content AS news

  LEFT JOIN nov_categories AS categories 
  ON categories.id = news.catid

  WHERE publish_up <= '2021-05-07 18:59:29' 
  AND categories.parent_id = 11 
  AND news.state = 1 
  AND news.language = 'it-IT' 
  AND categories.id = 31 
  AND news.id NOT IN (7097,7060)

  ORDER BY publish_up DESC 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	categories	const	PRIMARY	PRIMARY	4	const	1	Using filesort
1	SIMPLE	news	index_merge	PRIMARY,idx_state,idx_catid,idx_language	idx_language,idx_catid,PRIMARY	28,4,4	NULL	1	Using intersect(idx_language,idx_catid,PRIMARY); Using where

Profilo

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.14 ms
preparing	0.03 ms
executing	0.00 ms
Sorting result	0.13 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

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/repositories/LatestNewsRepository.php:42
10	LatestNewsRepository->latestFromCategory()	JROOT/components/com_vodnikpojadranu/repositories/LatestNewsRepository.php:18
9	LatestNewsRepository->getNewsByCategory()	JROOT/components/com_vodnikpojadranu/controller.php:2071
8	VodnikPoJadranuController->getFront()	JROOT/components/com_vodnikpojadranu/controller.php:131
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.55 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.025 MB memoria prima della query: 3.448 MB Righe restituite: 1

SELECT news.id,news.title,news.alias,news.introtext,news.catid,news.publish_up,news.images,categories.title AS category_title,categories.id AS category_id

  FROM nov_content AS news

  LEFT JOIN nov_categories AS categories 
  ON categories.id = news.catid

  WHERE publish_up <= '2021-05-07 18:59:29' 
  AND categories.parent_id = 11 
  AND news.state = 1 
  AND news.language = 'it-IT' 
  AND categories.id = 19 
  AND news.id NOT IN (7097,7060)

  ORDER BY publish_up DESC 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	categories	const	PRIMARY	PRIMARY	4	const	1	Using filesort
1	SIMPLE	news	index_merge	PRIMARY,idx_state,idx_catid,idx_language	idx_language,idx_catid,PRIMARY	28,4,4	NULL	1	Using intersect(idx_language,idx_catid,PRIMARY); Using where

Profilo

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.11 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

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/repositories/LatestNewsRepository.php:42
10	LatestNewsRepository->latestFromCategory()	JROOT/components/com_vodnikpojadranu/repositories/LatestNewsRepository.php:19
9	LatestNewsRepository->getNewsByCategory()	JROOT/components/com_vodnikpojadranu/controller.php:2071
8	VodnikPoJadranuController->getFront()	JROOT/components/com_vodnikpojadranu/controller.php:131
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.54 ms Dopo l'ultima query: 0.17 ms Memoria query: 0.025 MB memoria prima della query: 3.459 MB Righe restituite: 1

SELECT news.id,news.title,news.alias,news.introtext,news.catid,news.publish_up,news.images,categories.title AS category_title,categories.id AS category_id

  FROM nov_content AS news

  LEFT JOIN nov_categories AS categories 
  ON categories.id = news.catid

  WHERE publish_up <= '2021-05-07 18:59:29' 
  AND categories.parent_id = 11 
  AND news.state = 1 
  AND news.language = 'it-IT' 
  AND categories.id = 32 
  AND news.id NOT IN (7097,7060)

  ORDER BY publish_up DESC 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	categories	const	PRIMARY	PRIMARY	4	const	1	Using filesort
1	SIMPLE	news	index_merge	PRIMARY,idx_state,idx_catid,idx_language	idx_language,idx_catid,PRIMARY	28,4,4	NULL	1	Using intersect(idx_language,idx_catid,PRIMARY); Using where

Profilo

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.14 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

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/repositories/LatestNewsRepository.php:42
10	LatestNewsRepository->latestFromCategory()	JROOT/components/com_vodnikpojadranu/repositories/LatestNewsRepository.php:20
9	LatestNewsRepository->getNewsByCategory()	JROOT/components/com_vodnikpojadranu/controller.php:2071
8	VodnikPoJadranuController->getFront()	JROOT/components/com_vodnikpojadranu/controller.php:131
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.83 ms Dopo l'ultima query: 0.19 ms Memoria query: 0.028 MB memoria prima della query: 3.482 MB Righe restituite: 1

Query duplicate: #38

SELECT *

  FROM `nov_galleries`

  WHERE `alias` LIKE 'alfastreet-28-cabin' 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nov_galleries	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	3511	Using where

Profilo

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	1.58 ms
end	0.01 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

Call Stack

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:1113
16	Gallery::findByAlias()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:2213
15	Article->gallery()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:2281
14	Article->cover()	JROOT/components/com_vodnikpojadranu/repositories/LatestNewsRepository.php:95
13	LatestNewsRepository->{closure}()	Chiamata uguale alla linea sottostante.
12	array_map()	JROOT/components/com_vodnikpojadranu/repositories/LatestNewsRepository.php:104
11	LatestNewsRepository->buildArticles()	JROOT/components/com_vodnikpojadranu/repositories/LatestNewsRepository.php:42
10	LatestNewsRepository->latestFromCategory()	JROOT/components/com_vodnikpojadranu/repositories/LatestNewsRepository.php:20
9	LatestNewsRepository->getNewsByCategory()	JROOT/components/com_vodnikpojadranu/controller.php:2071
8	VodnikPoJadranuController->getFront()	JROOT/components/com_vodnikpojadranu/controller.php:131
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.57 ms Dopo l'ultima query: 2.23 ms Memoria query: 0.025 MB memoria prima della query: 3.480 MB Righe restituite: 0

SELECT news.id,news.title,news.alias,news.introtext,news.catid,news.publish_up,news.images,categories.title AS category_title,categories.id AS category_id

  FROM nov_content AS news

  LEFT JOIN nov_categories AS categories 
  ON categories.id = news.catid

  WHERE publish_up <= '2021-05-07 18:59:29' 
  AND categories.parent_id = 11 
  AND news.state = 1 
  AND news.language = 'it-IT' 
  AND categories.id = 33 
  AND news.id NOT IN (7097,7060)

  ORDER BY publish_up DESC 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	categories	const	PRIMARY	PRIMARY	4	const	1	Using filesort
1	SIMPLE	news	index_merge	PRIMARY,idx_state,idx_catid,idx_language	idx_language,idx_catid,PRIMARY	28,4,4	NULL	1	Using intersect(idx_language,idx_catid,PRIMARY); Using where

Profilo

Status	Duration
starting	0.08 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.01 ms
After table lock	0.00 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.10 ms
Sending data	0.03 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

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/repositories/LatestNewsRepository.php:42
10	LatestNewsRepository->latestFromCategory()	JROOT/components/com_vodnikpojadranu/repositories/LatestNewsRepository.php:21
9	LatestNewsRepository->getNewsByCategory()	JROOT/components/com_vodnikpojadranu/controller.php:2071
8	VodnikPoJadranuController->getFront()	JROOT/components/com_vodnikpojadranu/controller.php:131
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.63 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.027 MB memoria prima della query: 3.493 MB Righe restituite: 1

SELECT news.id,news.title,news.alias,news.introtext,news.catid,news.publish_up,news.images,categories.title AS category_title,categories.id AS category_id

  FROM nov_content AS news

  LEFT JOIN nov_categories AS categories 
  ON categories.id = news.catid

  WHERE publish_up <= '2021-05-07 18:59:29' 
  AND categories.parent_id = 11 
  AND news.state = 1 
  AND news.language = 'it-IT' 
  AND categories.id = 34 
  AND news.id NOT IN (7097,7060)

  ORDER BY publish_up DESC 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	categories	const	PRIMARY	PRIMARY	4	const	1	Using filesort
1	SIMPLE	news	index_merge	PRIMARY,idx_state,idx_catid,idx_language	idx_language,idx_catid,PRIMARY	28,4,4	NULL	1	Using intersect(idx_language,idx_catid,PRIMARY); Using where

Profilo

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.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.11 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.20 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

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/repositories/LatestNewsRepository.php:42
10	LatestNewsRepository->latestFromCategory()	JROOT/components/com_vodnikpojadranu/repositories/LatestNewsRepository.php:22
9	LatestNewsRepository->getNewsByCategory()	JROOT/components/com_vodnikpojadranu/controller.php:2071
8	VodnikPoJadranuController->getFront()	JROOT/components/com_vodnikpojadranu/controller.php:131
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.54 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.025 MB memoria prima della query: 3.504 MB Righe restituite: 1

SELECT news.id,news.title,news.alias,news.introtext,news.catid,news.publish_up,news.images,categories.title AS category_title,categories.id AS category_id

  FROM nov_content AS news

  LEFT JOIN nov_categories AS categories 
  ON categories.id = news.catid

  WHERE publish_up <= '2021-05-07 18:59:29' 
  AND categories.parent_id = 11 
  AND news.state = 1 
  AND news.language = 'it-IT' 
  AND categories.id = 18 
  AND news.id NOT IN (7097,7060)

  ORDER BY publish_up DESC 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	categories	const	PRIMARY	PRIMARY	4	const	1	Using filesort
1	SIMPLE	news	index_merge	PRIMARY,idx_state,idx_catid,idx_language	idx_language,PRIMARY	28,4	NULL	6	Using intersect(idx_language,PRIMARY); Using where

Profilo

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.06 ms
executing	0.00 ms
Sorting result	0.07 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.01 ms

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/repositories/LatestNewsRepository.php:42
10	LatestNewsRepository->latestFromCategory()	JROOT/components/com_vodnikpojadranu/repositories/LatestNewsRepository.php:23
9	LatestNewsRepository->getNewsByCategory()	JROOT/components/com_vodnikpojadranu/controller.php:2071
8	VodnikPoJadranuController->getFront()	JROOT/components/com_vodnikpojadranu/controller.php:131
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 2.95 ms Dopo l'ultima query: 0.17 ms Memoria query: 0.025 MB memoria prima della query: 3.515 MB Righe restituite: 1

SELECT tax.tax_rate, product_id AS id, product_alias AS alias, product_name AS name, price_value AS price, product_msrp AS price_tax, file_path AS image, product_description AS description

  FROM `nov_hikashop_product` AS product

  LEFT JOIN nov_hikashop_category AS cat 
  ON cat.category_id = product.product_tax_id

  LEFT JOIN nov_hikashop_taxation AS taxation 
  ON taxation.category_namekey = cat.category_namekey

  LEFT JOIN nov_hikashop_tax AS tax 
  ON tax.tax_namekey = taxation.tax_namekey

  LEFT JOIN nov_hikashop_price AS p 
  ON p.price_product_id = product.product_id

  LEFT JOIN nov_hikashop_file AS f 
  ON f.file_ref_id = product.product_id

  WHERE product_published = 1

  ORDER BY id DESC 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	product	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	41	Using where; Using temporary; Using filesort
1	SIMPLE	cat	eq_ref	PRIMARY	PRIMARY	4	enavtika_db.product.product_tax_id	1
1	SIMPLE	taxation	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	2	Using where; Using join buffer (flat, BNL join)
1	SIMPLE	tax	eq_ref	PRIMARY	PRIMARY	767	enavtika_db.taxation.tax_namekey	1	Using where
1	SIMPLE	p	ref	price_product_id	price_product_id	4	enavtika_db.product.product_id	4
1	SIMPLE	f	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	106	Using where; Using join buffer (flat, BNL join)

Profilo

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.04 ms
executing	0.00 ms
Creating tmp table	0.34 ms
Copying to tmp table	1.97 ms
Sorting result	0.08 ms
Sending data	0.02 ms
end	0.00 ms
removing tmp table	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.04 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:1021
9	Product::getLastShoppingItem()	JROOT/components/com_vodnikpojadranu/controller.php:2072
8	VodnikPoJadranuController->getFront()	JROOT/components/com_vodnikpojadranu/controller.php:131
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.09 ms Dopo l'ultima query: 62.94 ms Memoria query: 0.025 MB memoria prima della query: 3.523 MB Righe restituite: 0

SELECT content.id, content.title, content.alias, content.catid, content.introtext, content.hits, content.images, content.language

  FROM `nov_content` AS content

  LEFT JOIN nov_categories AS c 
  ON c.id = content.catid

  WHERE `state` = 1 
  AND (c.id = 11 OR parent_id = 11) 
  AND created >= '2021-04-07 18:59:29' 
  AND `content`.`language` = 'it-IT'

  ORDER BY hits DESC 
  LIMIT 3

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	content	ref	idx_state,idx_catid,idx_language	idx_language	28	const	9	Using index condition; Using where; Using filesort
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	enavtika_db.content.catid	1	Using where

Profilo

Status	Duration
starting	0.15 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.00 ms
After table lock	0.01 ms
init	0.05 ms
optimizing	0.04 ms
statistics	0.12 ms
preparing	0.04 ms
executing	0.01 ms
Sorting result	0.17 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.06 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:2086
9	Article::mostRead()	JROOT/components/com_vodnikpojadranu/controller.php:2073
8	VodnikPoJadranuController->getFront()	JROOT/components/com_vodnikpojadranu/controller.php:131
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 145.05 ms Dopo l'ultima query: 0.26 ms Memoria query: 0.039 MB memoria prima della query: 3.527 MB Righe restituite: 2

SELECT *

  FROM `nov_content`

  WHERE state = 1 
  AND `language` = 'it-IT' 
  AND `introtext` LIKE '%{gallery}%' OR`introtext` LIKE '%{vsig}%'

  ORDER BY publish_up DESC 
  LIMIT 3

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nov_content	ALL	idx_state,idx_language	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	4929	Using where; Using filesort

Profilo

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

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:2351
10	Article::all()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:584
9	VodnikPoJadranuModelVodnikPoJadranu->getFrontGallery()	JROOT/components/com_vodnikpojadranu/controller.php:2074
8	VodnikPoJadranuController->getFront()	JROOT/components/com_vodnikpojadranu/controller.php:131
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.86 ms Dopo l'ultima query: 0.24 ms Memoria query: 0.026 MB memoria prima della query: 3.557 MB Righe restituite: 1

Query duplicate: #31

SELECT *

  FROM `nov_galleries`

  WHERE `alias` LIKE 'alfastreet-28-cabin' 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nov_galleries	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	3511	Using where

Profilo

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	1.50 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.01 ms

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:1113
12	Gallery::findByAlias()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:2213
11	Article->gallery()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:2281
10	Article->cover()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:587
9	VodnikPoJadranuModelVodnikPoJadranu->getFrontGallery()	JROOT/components/com_vodnikpojadranu/controller.php:2074
8	VodnikPoJadranuController->getFront()	JROOT/components/com_vodnikpojadranu/controller.php:131
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.77 ms Dopo l'ultima query: 0.98 ms Memoria query: 0.026 MB memoria prima della query: 3.569 MB Righe restituite: 1

SELECT *

  FROM `nov_galleries`

  WHERE `alias` LIKE 'solaris-power-48-open' 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nov_galleries	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	3511	Using where

Profilo

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	1.46 ms
end	0.01 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

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:1113
12	Gallery::findByAlias()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:2213
11	Article->gallery()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:2281
10	Article->cover()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:587
9	VodnikPoJadranuModelVodnikPoJadranu->getFrontGallery()	JROOT/components/com_vodnikpojadranu/controller.php:2074
8	VodnikPoJadranuController->getFront()	JROOT/components/com_vodnikpojadranu/controller.php:131
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.58 ms Dopo l'ultima query: 2.05 ms Memoria query: 0.025 MB memoria prima della query: 3.576 MB Righe restituite: 1

SELECT *

  FROM `nov_gallery_items`

  ORDER BY created DESC 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nov_gallery_items	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	416	Using filesort

Profilo

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.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.26 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.00 ms
updating status	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:1172
9	Gallery::lastYoutube()	JROOT/components/com_vodnikpojadranu/controller.php:2075
8	VodnikPoJadranuController->getFront()	JROOT/components/com_vodnikpojadranu/controller.php:131
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 2.35 ms Dopo l'ultima query: 0.21 ms Memoria query: 0.036 MB memoria prima della query: 3.585 MB Righe restituite: 5

SELECT jcomments.*, IF(jcomments.object_group = 'com_content', c.language, 'it-IT') AS language

  FROM `nov_jcomments` AS jcomments

  LEFT JOIN `nov_content` AS `c` 
  ON jcomments.object_id = c.id 
  AND jcomments.object_group = 'com_content'

  WHERE jcomments.comment IS NOT NULL

  HAVING `language` = 'it-IT'

  ORDER BY jcomments.date DESC 
  LIMIT 5

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jcomments	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1799	Using where; Using filesort
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	enavtika_db.jcomments.object_id	1	Using where

Profilo

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	1.52 ms
Sending data	0.40 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

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:3358
9	Comment::all()	JROOT/components/com_vodnikpojadranu/controller.php:2076
8	VodnikPoJadranuController->getFront()	JROOT/components/com_vodnikpojadranu/controller.php:131
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.37 ms Dopo l'ultima query: 0.22 ms Memoria query: 0.028 MB memoria prima della query: 3.609 MB Righe restituite: 1

SELECT *

  FROM `nov_locations`

  WHERE `id`=2939 
  LIMIT 1

Explain

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

Profilo

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.01 ms
init	0.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

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:4473
10	Location::find()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:3373
9	Comment::all()	JROOT/components/com_vodnikpojadranu/controller.php:2076
8	VodnikPoJadranuController->getFront()	JROOT/components/com_vodnikpojadranu/controller.php:131
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.35 ms Dopo l'ultima query: 0.41 ms Memoria query: 0.028 MB memoria prima della query: 3.620 MB Righe restituite: 1

SELECT *

  FROM `nov_locations`

  WHERE `id`=44 
  LIMIT 1

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:4473
10	Location::find()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:3373
9	Comment::all()	JROOT/components/com_vodnikpojadranu/controller.php:2076
8	VodnikPoJadranuController->getFront()	JROOT/components/com_vodnikpojadranu/controller.php:131
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.32 ms Dopo l'ultima query: 0.33 ms Memoria query: 0.028 MB memoria prima della query: 3.628 MB Righe restituite: 1

SELECT *

  FROM `nov_locations`

  WHERE `id`=376 
  LIMIT 1

Explain

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

Profilo

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.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.00 ms
updating status	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:4473
10	Location::find()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:3373
9	Comment::all()	JROOT/components/com_vodnikpojadranu/controller.php:2076
8	VodnikPoJadranuController->getFront()	JROOT/components/com_vodnikpojadranu/controller.php:131
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.24 ms Dopo l'ultima query: 0.25 ms Memoria query: 0.028 MB memoria prima della query: 3.636 MB Righe restituite: 1

SELECT *

  FROM `nov_locations`

  WHERE `id`=482 
  LIMIT 1

Explain

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

Profilo

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.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

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:4473
10	Location::find()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:3373
9	Comment::all()	JROOT/components/com_vodnikpojadranu/controller.php:2076
8	VodnikPoJadranuController->getFront()	JROOT/components/com_vodnikpojadranu/controller.php:131
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.24 ms Dopo l'ultima query: 0.25 ms Memoria query: 0.028 MB memoria prima della query: 3.644 MB Righe restituite: 1

SELECT *

  FROM `nov_locations`

  WHERE `id`=710 
  LIMIT 1

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:4473
10	Location::find()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:3373
9	Comment::all()	JROOT/components/com_vodnikpojadranu/controller.php:2076
8	VodnikPoJadranuController->getFront()	JROOT/components/com_vodnikpojadranu/controller.php:131
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.89 ms Dopo l'ultima query: 2.84 ms Memoria query: 0.030 MB memoria prima della query: 3.673 MB Righe restituite: 9

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

  FROM nov_modules AS m

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

  LEFT JOIN nov_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2021-05-07 18:59:29') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-05-07 18:59:29') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 236 OR mm.menuid <= 0) 
  AND m.language IN ('it-IT','*')

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds,idx_language	published	1	const	25	Using index condition; Using where; Using 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

Profilo

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

Call Stack

#	Caller	File e numero di linea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	Chiamata uguale alla linea sottostante.
18	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
17	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
16	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
15	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
14	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:45
13	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/components/com_vodnikpojadranu/views/front/tmpl/default.php:10
12	include JROOT/components/com_vodnikpojadranu/views/front/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/front/view.html.php:9
9	VodnikPoJadranuViewFront->display()	JROOT/components/com_vodnikpojadranu/controller.php:2078
8	VodnikPoJadranuController->getFront()	JROOT/components/com_vodnikpojadranu/controller.php:131
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.33 ms Dopo l'ultima query: 1.81 ms Memoria query: 0.029 MB memoria prima della query: 3.693 MB Righe restituite: 1

Query duplicate: #50

SELECT *

  FROM `nov_locations`

  WHERE `id`=138

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:2472
13	Event->location()	JROOT/components/com_vodnikpojadranu/views/front/tmpl/default.php:109
12	include JROOT/components/com_vodnikpojadranu/views/front/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/front/view.html.php:9
9	VodnikPoJadranuViewFront->display()	JROOT/components/com_vodnikpojadranu/controller.php:2078
8	VodnikPoJadranuController->getFront()	JROOT/components/com_vodnikpojadranu/controller.php:131
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.24 ms Dopo l'ultima query: 0.28 ms Memoria query: 0.029 MB memoria prima della query: 3.703 MB Righe restituite: 1

Query duplicate: #51 #52

SELECT *

  FROM `nov_locations`

  WHERE `id`=167

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:2472
13	Event->location()	JROOT/components/com_vodnikpojadranu/views/front/tmpl/default.php:109
12	include JROOT/components/com_vodnikpojadranu/views/front/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/front/view.html.php:9
9	VodnikPoJadranuViewFront->display()	JROOT/components/com_vodnikpojadranu/controller.php:2078
8	VodnikPoJadranuController->getFront()	JROOT/components/com_vodnikpojadranu/controller.php:131
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.25 ms Dopo l'ultima query: 0.27 ms Memoria query: 0.029 MB memoria prima della query: 3.714 MB Righe restituite: 1

Query duplicate: #48

SELECT *

  FROM `nov_locations`

  WHERE `id`=138

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:2472
13	Event->location()	JROOT/components/com_vodnikpojadranu/views/front/tmpl/default.php:109
12	include JROOT/components/com_vodnikpojadranu/views/front/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/front/view.html.php:9
9	VodnikPoJadranuViewFront->display()	JROOT/components/com_vodnikpojadranu/controller.php:2078
8	VodnikPoJadranuController->getFront()	JROOT/components/com_vodnikpojadranu/controller.php:131
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.24 ms Dopo l'ultima query: 0.24 ms Memoria query: 0.029 MB memoria prima della query: 3.725 MB Righe restituite: 1

Query duplicate: #49 #52

SELECT *

  FROM `nov_locations`

  WHERE `id`=167

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:2472
13	Event->location()	JROOT/components/com_vodnikpojadranu/views/front/tmpl/default.php:109
12	include JROOT/components/com_vodnikpojadranu/views/front/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/front/view.html.php:9
9	VodnikPoJadranuViewFront->display()	JROOT/components/com_vodnikpojadranu/controller.php:2078
8	VodnikPoJadranuController->getFront()	JROOT/components/com_vodnikpojadranu/controller.php:131
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.24 ms Dopo l'ultima query: 0.23 ms Memoria query: 0.029 MB memoria prima della query: 3.735 MB Righe restituite: 1

Query duplicate: #49 #51

SELECT *

  FROM `nov_locations`

  WHERE `id`=167

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:2472
13	Event->location()	JROOT/components/com_vodnikpojadranu/views/front/tmpl/default.php:109
12	include JROOT/components/com_vodnikpojadranu/views/front/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/front/view.html.php:9
9	VodnikPoJadranuViewFront->display()	JROOT/components/com_vodnikpojadranu/controller.php:2078
8	VodnikPoJadranuController->getFront()	JROOT/components/com_vodnikpojadranu/controller.php:131
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.29 ms Dopo l'ultima query: 1.12 ms Memoria query: 0.031 MB memoria prima della query: 3.752 MB Righe restituite: 1

SELECT *

  FROM `nov_locations`

  WHERE `galleryid`=1160 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nov_locations	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1903	Using where

Profilo

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	1.04 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

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:4490
15	Location::findByGallery()	JROOT/components/com_vodnikpojadranu/models/vodnikpojadranu.php:1722
14	GalleryYoutube->location()	JROOT/components/com_vodnikpojadranu/views/front/tmpl/leftside.php:53
13	require JROOT/components/com_vodnikpojadranu/views/front/tmpl/leftside.php	JROOT/components/com_vodnikpojadranu/views/front/tmpl/default.php:134
12	include JROOT/components/com_vodnikpojadranu/views/front/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/front/view.html.php:9
9	VodnikPoJadranuViewFront->display()	JROOT/components/com_vodnikpojadranu/controller.php:2078
8	VodnikPoJadranuController->getFront()	JROOT/components/com_vodnikpojadranu/controller.php:131
7	VodnikPoJadranuController->execute()	JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php:10
6	require_once JROOT/components/com_vodnikpojadranu/vodnikpojadranu.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.39 ms Dopo l'ultima query: 1.85 ms Memoria query: 0.022 MB memoria prima della query: 3.836 MB Righe restituite: 3

SELECT language,id

  FROM `nov_menu`

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

Explain

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

Profilo

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.04 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.10 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

Call Stack

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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.39 ms Dopo l'ultima query: 1.14 ms Memoria query: 0.023 MB memoria prima della query: 3.848 MB Righe restituite: 3

Porti turistici

Ristoranti / Servizi / Segnali

Eventi

Ultimo dal eShop

Ultimo video

Ultima galleria delle foto

Alfastreet Marine: Funzionalità senza compromessi

Solaris Power 48 - Barca dell'anno 2020

Ultimo commento

Ban

Enavtika

Klauzarj

Msisko

Msisko

Console Debug Joomla!

Sessione

Informazioni profilo

Tempo

Memoria

Utilizzo memoria

Query Database

67 query eseguite 190.81 ms

Trovati 14 duplicati!

Porti turistici

Ristoranti / Servizi / Segnali

Eventi

Ultimo dal eShop

Ultimo video

Ultima galleria delle foto

Alfastreet Marine: Funzionalità senza compromessi

Solaris Power 48 - Barca dell'anno 2020

Top novità

Ultimo commento

Ban

Enavtika

Klauzarj

Msisko

Msisko

Console Debug Joomla!

Sessione

Informazioni profilo

Tempo

Memoria

Utilizzo memoria

Query Database

67 query eseguite 190.81 ms

Trovati 14 duplicati!