Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1574052764,
                "last": 1574052764,
                "now": 1574052764
            },
            "token": "CyplIaJwQlqSRJ3gPWhUh8Vxf7NPlpdS"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Informazioni profilo

Tempo

Memoria

Tempo: 9.73 ms / 9.73 ms Memoria: 0.513 MB / 0.85 MB Application: afterLoad

Tempo: 92.94 ms / 102.66 ms Memoria: 5.035 MB / 5.88 MB Application: afterInitialise

Tempo: 74.92 ms / 177.59 ms Memoria: 0.995 MB / 6.88 MB Application: afterRoute

Tempo: 0.44 ms / 178.03 ms Memoria: 0.030 MB / 6.91 MB Application: beforeRenderComponent com_k2

Tempo: 8.68 ms / 186.71 ms Memoria: 0.389 MB / 7.30 MB Application: Start JAccess::getAssetRules Old (1)

Tempo: 1.32 ms / 188.04 ms Memoria: 0.031 MB / 7.33 MB Application: Finish JAccess::getAssetRules Old (1)

Tempo: 0.10 ms / 188.14 ms Memoria: 0.000 MB / 7.32 MB Application: Start JAccess::preload(components)

Tempo: 3.35 ms / 191.49 ms Memoria: 0.226 MB / 7.55 MB Application: Finish JAccess::preload(components)

Tempo: 65.33 ms / 256.82 ms Memoria: 2.943 MB / 10.49 MB Application: afterRenderComponent com_k2

Tempo: 4.45 ms / 261.26 ms Memoria: 0.185 MB / 10.68 MB Application: afterDispatch

Tempo: 5.42 ms / 266.69 ms Memoria: 0.170 MB / 10.85 MB Application: beforeRenderModule mod_custom (dati...)

Tempo: 1.11 ms / 267.80 ms Memoria: 0.036 MB / 10.88 MB Application: afterRenderModule mod_custom (dati...)

Tempo: 0.09 ms / 267.89 ms Memoria: 0.001 MB / 10.89 MB Application: beforeRenderModule mod_menu (News e leggi)

Tempo: 2.51 ms / 270.40 ms Memoria: 0.043 MB / 10.93 MB Application: afterRenderModule mod_menu (News e leggi)

Tempo: 0.05 ms / 270.46 ms Memoria: 0.000 MB / 10.93 MB Application: beforeRenderModule mod_custom (La Scuola e la sua storia)

Tempo: 0.30 ms / 270.75 ms Memoria: 0.004 MB / 10.93 MB Application: afterRenderModule mod_custom (La Scuola e la sua storia)

Tempo: 0.06 ms / 270.81 ms Memoria: 0.004 MB / 10.93 MB Application: beforeRenderModule mod_k2_content (Docenti )

Tempo: 12.17 ms / 282.99 ms Memoria: 0.626 MB / 11.56 MB Application: afterRenderModule mod_k2_content (Docenti )

Tempo: 0.09 ms / 283.08 ms Memoria: 0.000 MB / 11.14 MB Application: beforeRenderModule mod_menu (Tesi)

Tempo: 2.20 ms / 285.27 ms Memoria: 0.015 MB / 11.15 MB Application: afterRenderModule mod_menu (Tesi)

Tempo: 0.05 ms / 285.32 ms Memoria: 0.000 MB / 11.15 MB Application: beforeRenderModule mod_custom (Agopuntura Veterinaria)

Tempo: 0.26 ms / 285.58 ms Memoria: 0.003 MB / 11.15 MB Application: afterRenderModule mod_custom (Agopuntura Veterinaria)

Tempo: 0.05 ms / 285.63 ms Memoria: 0.003 MB / 11.16 MB Application: beforeRenderModule mod_acymailing (Iscriviti alla newsletter )

Tempo: 11.93 ms / 297.56 ms Memoria: 0.917 MB / 12.07 MB Application: afterRenderModule mod_acymailing (Iscriviti alla newsletter )

Tempo: 0.07 ms / 297.62 ms Memoria: 0.000 MB / 11.98 MB Application: beforeRenderModule mod_custom (Shinystat)

Tempo: 0.28 ms / 297.90 ms Memoria: 0.003 MB / 11.98 MB Application: afterRenderModule mod_custom (Shinystat)

Tempo: 0.08 ms / 297.98 ms Memoria: 0.000 MB / 11.98 MB Application: beforeRenderModule mod_menu (Corsi)

Tempo: 3.49 ms / 301.46 ms Memoria: 0.028 MB / 12.01 MB Application: afterRenderModule mod_menu (Corsi)

Tempo: 0.05 ms / 301.52 ms Memoria: 0.000 MB / 12.01 MB Application: beforeRenderModule mod_menu (Iscrizioni e regolamento)

Tempo: 1.57 ms / 303.08 ms Memoria: 0.011 MB / 12.02 MB Application: afterRenderModule mod_menu (Iscrizioni e regolamento)

Tempo: 0.05 ms / 303.13 ms Memoria: 0.000 MB / 12.02 MB Application: beforeRenderModule mod_custom (TIROCINIO FORMATIVO )

Tempo: 0.25 ms / 303.38 ms Memoria: 0.003 MB / 12.02 MB Application: afterRenderModule mod_custom (TIROCINIO FORMATIVO )

Tempo: 0.04 ms / 303.42 ms Memoria: 0.003 MB / 12.03 MB Application: beforeRenderModule mod_custom (Stage Ospedale Pitigliano, Manciano, Grosseto)

Tempo: 0.24 ms / 303.66 ms Memoria: 0.006 MB / 12.03 MB Application: afterRenderModule mod_custom (Stage Ospedale Pitigliano, Manciano, Grosseto)

Tempo: 0.04 ms / 303.70 ms Memoria: 0.000 MB / 12.03 MB Application: beforeRenderModule mod_custom (CREDITI ECM REGIONE TOSCANA)

Tempo: 0.24 ms / 303.94 ms Memoria: 0.003 MB / 12.04 MB Application: afterRenderModule mod_custom (CREDITI ECM REGIONE TOSCANA)

Tempo: 0.04 ms / 303.97 ms Memoria: 0.000 MB / 12.03 MB Application: beforeRenderModule mod_custom (Gli amici della scuola)

Tempo: 0.23 ms / 304.20 ms Memoria: 0.003 MB / 12.04 MB Application: afterRenderModule mod_custom (Gli amici della scuola)

Tempo: 0.04 ms / 304.24 ms Memoria: 0.000 MB / 12.04 MB Application: beforeRenderModule mod_custom (Franco Cracolici)

Tempo: 0.23 ms / 304.46 ms Memoria: 0.003 MB / 12.04 MB Application: afterRenderModule mod_custom (Franco Cracolici)

Tempo: 0.03 ms / 304.50 ms Memoria: 0.000 MB / 12.04 MB Application: beforeRenderModule mod_custom (Social)

Tempo: 0.22 ms / 304.72 ms Memoria: 0.003 MB / 12.04 MB Application: afterRenderModule mod_custom (Social)

Tempo: 0.05 ms / 304.77 ms Memoria: 0.003 MB / 12.04 MB Application: beforeRenderModule mod_login (Area Riservata)

Tempo: 5.02 ms / 309.79 ms Memoria: 0.204 MB / 12.25 MB Application: afterRenderModule mod_login (Area Riservata)

Tempo: 0.07 ms / 309.86 ms Memoria: 0.000 MB / 12.25 MB Application: beforeRenderModule mod_menu (Menu Principale)

Tempo: 3.25 ms / 313.11 ms Memoria: 0.027 MB / 12.27 MB Application: afterRenderModule mod_menu (Menu Principale)

Tempo: 0.07 ms / 313.18 ms Memoria: 0.000 MB / 12.27 MB Application: beforeRenderModule mod_smartslider3 (Appartenenza Scuola a Organismi scientifici e istituzionali)

Tempo: 0.17 ms / 313.36 ms Memoria: 0.005 MB / 12.28 MB Application: afterRenderModule mod_smartslider3 (Appartenenza Scuola a Organismi scientifici e istituzionali)

Tempo: 356.05 ms / 669.41 ms Memoria: 6.012 MB / 18.29 MB Application: afterRender

Query totali del database: 117.40 ms

Utilizzo memoria

Query Database

66 query eseguite 117.40 ms

Trovati 18 duplicati!

3 duplicati: #26 #33 #36

3 duplicati: #27 #34 #37

6 duplicati: #54 #56 #58 #60 #62 #64

6 duplicati: #55 #57 #59 #61 #63 #65

Tempo della query: 0.39 ms Memoria query: 0.026 MB memoria prima della query: 2.334 MB Righe restituite: 0

SELECT `data`

  FROM `nuvrj_session`

  WHERE `session_id` = '4dlf6d4ptnk4f4lin2cer13rv3'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nuvrj_session	const	PRIMARY	PRIMARY	766	const	1

Profilo

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

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
12	JSessionStorageDatabase->read()	Chiamata uguale alla linea sottostante.
11	session_start()	JROOT/libraries/joomla/session/handler/native.php:259
10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
6	JSession->start()	JROOT/libraries/cms/application/cms.php:773
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::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.32 ms Dopo l'ultima query: 1.67 ms Memoria query: 0.023 MB memoria prima della query: 2.471 MB Righe restituite: 0

SELECT `session_id`

  FROM `nuvrj_session`

  WHERE `session_id` = '4dlf6d4ptnk4f4lin2cer13rv3' 
  LIMIT 1

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::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: 25.11 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.005 MB memoria prima della query: 2.478 MB

INSERT INTO `nuvrj_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('4dlf6d4ptnk4f4lin2cer13rv3', 0, 1, '1574052764', 0, '')

Explain

EXPLAIN non possibile sulla query: INSERT INTO `nuvrj_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('4dlf6d4ptnk4f4lin2cer13rv3', 0, 1, '1574052764', 0, '')

Profilo

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
update	0.11 ms
end	0.01 ms
query end	24.73 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.03 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:212
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::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.79 ms Dopo l'ultima query: 2.77 ms Memoria query: 0.040 MB memoria prima della query: 2.644 MB Righe restituite: 37

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

  FROM `nuvrj_extensions`

  WHERE `type` = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nuvrj_extensions	ref	extension	extension	82	const	37	Using index condition

Profilo

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

Call Stack

#	Caller	File e numero di linea
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
8	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:152
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:589
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.51 ms Dopo l'ultima query: 2.54 ms Memoria query: 0.025 MB memoria prima della query: 2.789 MB Righe restituite: 2

SELECT b.id

  FROM nuvrj_usergroups AS a

  LEFT JOIN nuvrj_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.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.01 ms
Unlocking tables	0.03 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:835
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:904
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.38 ms Dopo l'ultima query: 0.97 ms Memoria query: 0.025 MB memoria prima della query: 2.837 MB Righe restituite: 5

SELECT id, rules

  FROM `nuvrj_viewlevels`

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:921
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.23 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.036 MB memoria prima della query: 2.847 MB Righe restituite: 93

SELECT folder AS type, element AS name, params

  FROM nuvrj_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	nuvrj_extensions	ref	extension	extension	82	const	93	Using index condition; 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.01 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.06 ms
preparing	0.04 ms
executing	0.01 ms
Sorting result	0.53 ms
Sending data	0.26 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
7	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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: 0.91 ms Memoria query: 0.026 MB memoria prima della query: 2.935 MB Righe restituite: 2

SELECT *

  FROM nuvrj_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
5	JLanguageHelper::getLanguages()	JROOT/libraries/joomla/language/helper.php:85
4	JLanguageHelper::detectLanguage()	JROOT/libraries/cms/application/site.php:648
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.46 ms Dopo l'ultima query: 22.55 ms Memoria query: 0.024 MB memoria prima della query: 4.686 MB Righe restituite: 2

SELECT element

  FROM nuvrj_extensions

  WHERE type = 'language' 
  AND client_id = 0 
  AND enabled = 1

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/multilang.php:90
8	JLanguageMultilang::getSiteLangs()	JROOT/plugins/system/languagefilter/languagefilter.php:108
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.21 ms Dopo l'ultima query: 11.22 ms Memoria query: 0.057 MB memoria prima della query: 5.372 MB Righe restituite: 46

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

  LEFT JOIN nuvrj_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	49	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	agopuntura_db1.m.component_id	1	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
18	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
17	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
16	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
15	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
14	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
13	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
12	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
11	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
10	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
9	JApplicationSite::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:130
8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.49 ms Dopo l'ultima query: 12.81 ms Memoria query: 0.029 MB memoria prima della query: 6.412 MB Righe restituite: 1

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

  FROM `nuvrj_extensions`

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

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
16	JDatabaseDriver->loadObject()	JROOT/libraries/joomla/cache/controller/callback.php:152
15	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
14	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
13	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
12	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
11	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:754
10	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
9	JFactory::getDocument()	JROOT/plugins/system/k2/k2.php:460
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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: 55.37 ms Dopo l'ultima query: 0.22 ms Memoria query: 0.009 MB memoria prima della query: 6.408 MB

UPDATE `nuvrj_extensions`

  SET `params` = '{\"mediaversion\":\"2817062fe9b2235a5e6ac8af90794858\"}'

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

Explain

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

Profilo

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.12 ms
updating	0.08 ms
end	0.01 ms
query end	54.87 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
13	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
12	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
11	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:754
10	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
9	JFactory::getDocument()	JROOT/plugins/system/k2/k2.php:460
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.67 ms Dopo l'ultima query: 8.29 ms Memoria query: 0.031 MB memoria prima della query: 6.851 MB Righe restituite: 3

SELECT id, home, template, s.params

  FROM nuvrj_template_styles as s

  LEFT JOIN nuvrj_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.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.04 ms
optimizing	0.04 ms
statistics	0.09 ms
preparing	0.06 ms
executing	0.01 ms
Sending data	0.13 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
17	JApplicationSite->getTemplate()	JROOT/libraries/cms/html/html.php:339
16	JHtml::includeRelativeFiles()	JROOT/libraries/cms/html/html.php:684
15	JHtml::script()	JROOT/libraries/cms/html/html.php:237
14	JHtml::call()	JROOT/libraries/cms/html/html.php:139
13	JHtml::_()	JROOT/libraries/cms/html/jquery.php:53
12	JHtmlJquery::framework()	JROOT/libraries/cms/html/html.php:237
11	JHtml::call()	JROOT/libraries/cms/html/html.php:139
10	JHtml::_()	JROOT/administrator/components/com_k2/helpers/html.php:82
9	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:478
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.30 ms Dopo l'ultima query: 7.19 ms Memoria query: 0.031 MB memoria prima della query: 7.253 MB Righe restituite: 8

SHOW FULL COLUMNS 
  FROM `nuvrj_assets`

Explain

EXPLAIN non possibile sulla query: SHOW FULL COLUMNS FROM `nuvrj_assets`

Profilo

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

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
12	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
11	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
10	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
9	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
8	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
7	JUser->authorise()	JROOT/components/com_k2/k2.php:16
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.93 ms Memoria query: 0.027 MB memoria prima della query: 7.294 MB Righe restituite: 1

SELECT *

  FROM nuvrj_assets

  WHERE `id` = '1'

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
10	JTable->load()	JROOT/libraries/joomla/access/access.php:697
9	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
8	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
7	JUser->authorise()	JROOT/components/com_k2/k2.php:16
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.45 ms Dopo l'ultima query: 0.20 ms Memoria query: 0.024 MB memoria prima della query: 7.300 MB Righe restituite: 1

SELECT a.rules

  FROM nuvrj_assets AS a

  WHERE (a.id = 1 OR a.name = 'root.1')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	Using union(PRIMARY,idx_asset_name); Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
9	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
8	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
7	JUser->authorise()	JROOT/components/com_k2/k2.php:16
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.61 ms Dopo l'ultima query: 0.97 ms Memoria query: 0.029 MB memoria prima della query: 7.327 MB Righe restituite: 37

SELECT element

  FROM nuvrj_extensions

  WHERE type = 'component' 
  AND enabled = '1'

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
11	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:413
10	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
9	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
8	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
7	JUser->authorise()	JROOT/components/com_k2/k2.php:16
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.00 ms Dopo l'ultima query: 0.20 ms Memoria query: 0.029 MB memoria prima della query: 7.342 MB Righe restituite: 37

SELECT a.name, a.rules

  FROM nuvrj_assets AS a

  WHERE (a.name IN ('com_acymailing','com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_finder','com_icagenda','com_installer','com_jce','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_nextend2','com_plugins','com_postinstall','com_proforms','com_redirect','com_search','com_smartslider3','com_tags','com_templates','com_users','com_wrapper') OR a.name = 'root.1')

Explain

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

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.01 ms
Table lock	0.01 ms
init	0.07 ms
optimizing	0.03 ms
statistics	0.20 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.38 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
11	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
10	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
9	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
8	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
7	JUser->authorise()	JROOT/components/com_k2/k2.php:16
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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: 15.67 ms Memoria query: 0.029 MB memoria prima della query: 8.341 MB Righe restituite: 30

SELECT id 
  FROM nuvrj_k2_categories 
  WHERE published=1 
  AND trash=0 
  AND access IN(1,1,5)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nuvrj_k2_categories	range	category,published,access,trash	category	8	NULL	31	Using where; Using index

Profilo

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

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
13	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/helpers/permissions.php:274
12	K2HelperPermissions::canAddItem()	JROOT/components/com_k2/views/itemlist/view.html.php:29
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.83 ms Dopo l'ultima query: 1.00 ms Memoria query: 0.027 MB memoria prima della query: 8.380 MB Righe restituite: 0

SELECT id
						
  FROM nuvrj_k2_categories
						
  WHERE parent IN (13,14,44)
						
  AND id NOT IN (13,14,44) 
								
  AND published=1
								
  AND trash=0 
  AND access IN(1,1,5) 
  AND language IN('it-IT', '*')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nuvrj_k2_categories	ref	PRIMARY,category,parent,published,access,trash,language	trash	2	const	27	Using index condition; Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
14	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/models/itemlist.php:648
13	K2ModelItemlist->getCategoryTree()	JROOT/components/com_k2/models/itemlist.php:263
12	K2ModelItemlist->getData()	JROOT/components/com_k2/views/itemlist/view.html.php:391
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.25 ms Dopo l'ultima query: 0.46 ms Memoria query: 0.060 MB memoria prima della query: 8.394 MB Righe restituite: 3

SELECT i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams 
  FROM nuvrj_k2_items as i RIGHT JOIN nuvrj_k2_categories AS c 
  ON c.id = i.catid 
  WHERE i.published = 1 
  AND i.access IN(1,1,5) 
  AND i.trash = 0 
  AND c.published = 1 
  AND c.access IN(1,1,5) 
  AND c.trash = 0 
  AND c.language IN ('it-IT','*')
						
  AND i.language IN ('it-IT','*') 
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2019-11-18 04:52:45' ) 
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2019-11-18 04:52:45' ) 
  AND c.id IN (13,14,44) 
  AND i.featured = 1 
  ORDER BY i.created DESC 
  LIMIT 0, 28

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	ref	item,catid,featured,language	featured	2	const	17	Using where; Using filesort
1	SIMPLE	c	eq_ref	PRIMARY,category,published,access,trash,language	PRIMARY	4	agopuntura_db1.i.catid	1	Using where

Profilo

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.08 ms
optimizing	0.06 ms
statistics	0.26 ms
preparing	0.07 ms
executing	0.01 ms
Sorting result	0.18 ms
Sending data	0.26 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.02 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/itemlist.php:360
12	K2ModelItemlist->getData()	JROOT/components/com_k2/views/itemlist/view.html.php:391
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.21 ms Dopo l'ultima query: 0.40 ms Memoria query: 0.026 MB memoria prima della query: 8.466 MB Righe restituite: 1

SELECT COUNT(*) 
  FROM nuvrj_k2_items as i RIGHT JOIN nuvrj_k2_categories c 
  ON c.id = i.catid 
  WHERE i.published = 1 
  AND i.access IN(1,1,5) 
  AND i.trash = 0 
  AND c.published = 1 
  AND c.access IN(1,1,5) 
  AND c.trash = 0 
  AND c.language IN ('it-IT','*')
						
  AND i.language IN ('it-IT','*') 
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2019-11-18 04:52:45' ) 
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2019-11-18 04:52:45' ) 
  AND c.id IN (13,14,44) 
  AND i.featured = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	range	PRIMARY,category,published,access,trash,language	PRIMARY	4	NULL	3	Using where
1	SIMPLE	i	ref	item,catid,featured,language	catid	4	agopuntura_db1.c.id	5	Using index condition; Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/itemlist.php:598
12	K2ModelItemlist->getTotal()	JROOT/components/com_k2/views/itemlist/view.html.php:415
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.10 ms Dopo l'ultima query: 2.40 ms Memoria query: 0.034 MB memoria prima della query: 8.584 MB Righe restituite: 14

SHOW FULL COLUMNS 
  FROM `nuvrj_k2_categories`

Explain

EXPLAIN non possibile sulla query: SHOW FULL COLUMNS FROM `nuvrj_k2_categories`

Profilo

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

Call Stack

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
15	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
14	JTable->__construct()	JROOT/administrator/components/com_k2/tables/k2category.php:36
13	TableK2Category->__construct()	JROOT/libraries/joomla/table/table.php:308
12	JTable::getInstance()	JROOT/components/com_k2/views/itemlist/view.html.php:460
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.36 ms Dopo l'ultima query: 0.35 ms Memoria query: 0.033 MB memoria prima della query: 8.636 MB Righe restituite: 1

SELECT * 
  FROM nuvrj_k2_categories 
  WHERE id = '44'

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
16	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:67
15	TableK2Category->load()	JROOT/components/com_k2/models/item.php:73
14	K2ModelItem->prepareItem()	JROOT/libraries/joomla/cache/controller/callback.php:152
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:464
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.36 ms Dopo l'ultima query: 2.58 ms Memoria query: 0.033 MB memoria prima della query: 8.758 MB Righe restituite: 1

SELECT * 
  FROM nuvrj_k2_categories 
  WHERE id = '13'

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
16	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:67
15	TableK2Category->load()	JROOT/components/com_k2/models/item.php:94
14	K2ModelItem->prepareItem()	JROOT/libraries/joomla/cache/controller/callback.php:152
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:464
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.56 ms Memoria query: 0.029 MB memoria prima della query: 8.790 MB Righe restituite: 1

Query duplicate: #33 #36

SELECT extraFieldsGroup 
  FROM nuvrj_k2_categories 
  WHERE id=44

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
16	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1426
15	K2ModelItem->getItemExtraFields()	JROOT/components/com_k2/models/item.php:182
14	K2ModelItem->prepareItem()	JROOT/libraries/joomla/cache/controller/callback.php:152
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:464
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.53 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.032 MB memoria prima della query: 8.802 MB Righe restituite: 9

Query duplicate: #34 #37

SELECT * 
  FROM nuvrj_k2_extra_fields 
  WHERE `
  group` = 1 
  AND published=1 
  AND (id IN (1,2,3,4,5,6,7,8,16) OR `type` = 'header') 
  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nuvrj_k2_extra_fields	ALL	PRIMARY,group,published	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	17	Using where; Using filesort

Profilo

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

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1430
15	K2ModelItem->getItemExtraFields()	JROOT/components/com_k2/models/item.php:182
14	K2ModelItem->prepareItem()	JROOT/libraries/joomla/cache/controller/callback.php:152
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:464
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.81 ms Memoria query: 0.030 MB memoria prima della query: 8.940 MB Righe restituite: 1

SELECT * 
  FROM nuvrj_k2_attachments 
  WHERE itemID=272

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nuvrj_k2_attachments	ref	itemID	itemID	4	const	1

Profilo

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

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1680
15	K2ModelItem->getItemAttachments()	JROOT/components/com_k2/models/item.php:188
14	K2ModelItem->prepareItem()	JROOT/libraries/joomla/cache/controller/callback.php:152
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:464
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.13 ms Dopo l'ultima query: 2.83 ms Memoria query: 0.039 MB memoria prima della query: 9.099 MB Righe restituite: 16

SHOW FULL COLUMNS 
  FROM `nuvrj_users`

Explain

EXPLAIN non possibile sulla query: SHOW FULL COLUMNS FROM `nuvrj_users`

Profilo

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

Call Stack

#	Caller	File e numero di linea
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
24	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
23	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
22	JTable->__construct()	JROOT/libraries/joomla/table/user.php:39
21	JTableUser->__construct()	JROOT/libraries/joomla/table/table.php:308
20	JTable::getInstance()	JROOT/libraries/joomla/user/user.php:583
19	JUser::getTable()	JROOT/libraries/joomla/user/user.php:861
18	JUser->load()	JROOT/libraries/joomla/user/user.php:243
17	JUser->__construct()	JROOT/libraries/joomla/user/user.php:296
16	JUser::getInstance()	JROOT/libraries/joomla/factory.php:248
15	JFactory::getUser()	JROOT/components/com_k2/models/item.php:246
14	K2ModelItem->prepareItem()	JROOT/libraries/joomla/cache/controller/callback.php:152
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:464
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.24 ms Memoria query: 0.035 MB memoria prima della query: 9.146 MB Righe restituite: 1

SELECT *

  FROM `nuvrj_users`

  WHERE `id` = 44

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nuvrj_users	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.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
20	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/user.php:85
19	JTableUser->load()	JROOT/libraries/joomla/user/user.php:864
18	JUser->load()	JROOT/libraries/joomla/user/user.php:243
17	JUser->__construct()	JROOT/libraries/joomla/user/user.php:296
16	JUser::getInstance()	JROOT/libraries/joomla/factory.php:248
15	JFactory::getUser()	JROOT/components/com_k2/models/item.php:246
14	K2ModelItem->prepareItem()	JROOT/libraries/joomla/cache/controller/callback.php:152
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:464
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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: 5.30 ms Memoria query: 0.031 MB memoria prima della query: 9.899 MB Righe restituite: 1

SELECT `g`.`id`,`g`.`title`

  FROM `nuvrj_usergroups` AS g

  INNER JOIN `nuvrj_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 44

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	agopuntura_db1.m.group_id	1

Profilo

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

Call Stack

#	Caller	File e numero di linea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
20	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/table/user.php:110
19	JTableUser->load()	JROOT/libraries/joomla/user/user.php:864
18	JUser->load()	JROOT/libraries/joomla/user/user.php:243
17	JUser->__construct()	JROOT/libraries/joomla/user/user.php:296
16	JUser::getInstance()	JROOT/libraries/joomla/factory.php:248
15	JFactory::getUser()	JROOT/components/com_k2/models/item.php:246
14	K2ModelItem->prepareItem()	JROOT/libraries/joomla/cache/controller/callback.php:152
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:464
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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: 0.99 ms Memoria query: 0.030 MB memoria prima della query: 9.910 MB Righe restituite: 1

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM nuvrj_k2_users 
  WHERE userID=44

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nuvrj_k2_users	ref	userID	userID	4	const	1

Profilo

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

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
16	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1853
15	K2ModelItem->getUserProfile()	JROOT/components/com_k2/models/item.php:249
14	K2ModelItem->prepareItem()	JROOT/libraries/joomla/cache/controller/callback.php:152
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:464
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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: 8.32 ms Memoria query: 0.030 MB memoria prima della query: 10.242 MB Righe restituite: 1

Query duplicate: #26 #36

SELECT extraFieldsGroup 
  FROM nuvrj_k2_categories 
  WHERE id=44

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
16	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1426
15	K2ModelItem->getItemExtraFields()	JROOT/components/com_k2/models/item.php:182
14	K2ModelItem->prepareItem()	JROOT/libraries/joomla/cache/controller/callback.php:152
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:464
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.50 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.032 MB memoria prima della query: 10.255 MB Righe restituite: 9

Query duplicate: #27 #37

SELECT * 
  FROM nuvrj_k2_extra_fields 
  WHERE `
  group` = 1 
  AND published=1 
  AND (id IN (1,2,3,4,5,6,7,8,16) OR `type` = 'header') 
  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nuvrj_k2_extra_fields	ALL	PRIMARY,group,published	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	17	Using where; Using filesort

Profilo

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

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1430
15	K2ModelItem->getItemExtraFields()	JROOT/components/com_k2/models/item.php:182
14	K2ModelItem->prepareItem()	JROOT/libraries/joomla/cache/controller/callback.php:152
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:464
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.31 ms Dopo l'ultima query: 0.39 ms Memoria query: 0.030 MB memoria prima della query: 10.264 MB Righe restituite: 0

SELECT * 
  FROM nuvrj_k2_attachments 
  WHERE itemID=270

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nuvrj_k2_attachments	ref	itemID	itemID	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.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1680
15	K2ModelItem->getItemAttachments()	JROOT/components/com_k2/models/item.php:188
14	K2ModelItem->prepareItem()	JROOT/libraries/joomla/cache/controller/callback.php:152
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:464
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.46 ms Memoria query: 0.029 MB memoria prima della query: 10.334 MB Righe restituite: 1

Query duplicate: #26 #33

SELECT extraFieldsGroup 
  FROM nuvrj_k2_categories 
  WHERE id=44

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
16	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1426
15	K2ModelItem->getItemExtraFields()	JROOT/components/com_k2/models/item.php:182
14	K2ModelItem->prepareItem()	JROOT/libraries/joomla/cache/controller/callback.php:152
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:464
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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: 0.07 ms Memoria query: 0.032 MB memoria prima della query: 10.346 MB Righe restituite: 9

Query duplicate: #27 #34

SELECT * 
  FROM nuvrj_k2_extra_fields 
  WHERE `
  group` = 1 
  AND published=1 
  AND (id IN (1,2,3,4,5,6,7,8,16) OR `type` = 'header') 
  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nuvrj_k2_extra_fields	ALL	PRIMARY,group,published	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	17	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.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.01 ms
Sorting result	0.05 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1430
15	K2ModelItem->getItemExtraFields()	JROOT/components/com_k2/models/item.php:182
14	K2ModelItem->prepareItem()	JROOT/libraries/joomla/cache/controller/callback.php:152
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:464
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.29 ms Memoria query: 0.030 MB memoria prima della query: 10.354 MB Righe restituite: 1

SELECT * 
  FROM nuvrj_k2_attachments 
  WHERE itemID=267

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nuvrj_k2_attachments	ref	itemID	itemID	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.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1680
15	K2ModelItem->getItemAttachments()	JROOT/components/com_k2/models/item.php:188
14	K2ModelItem->prepareItem()	JROOT/libraries/joomla/cache/controller/callback.php:152
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:464
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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: 8.67 ms Memoria query: 0.024 MB memoria prima della query: 10.501 MB Righe restituite: 1

SELECT language,id

  FROM `nuvrj_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	nuvrj_menu	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	50	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/multilang.php:121
8	JLanguageMultilang::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:697
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.46 ms Dopo l'ultima query: 1.12 ms Memoria query: 0.025 MB memoria prima della query: 10.614 MB Righe restituite: 0

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

  FROM `nuvrj_menu` AS `c`

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

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

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

  WHERE c.id = 162

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profilo

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

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/associations.php:101
9	JLanguageAssociations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:284
8	MenusHelper::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:714
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.50 ms Dopo l'ultima query: 4.16 ms Memoria query: 0.034 MB memoria prima della query: 10.861 MB Righe restituite: 27

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

  FROM nuvrj_modules AS m

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

  LEFT JOIN nuvrj_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 <= '2019-11-18 04:52:45') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-11-18 04:52:45') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 162 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	33	Using index condition; Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	agopuntura_db1.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	agopuntura_db1.m.module,const	1	Using index condition; Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:152
12	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:425
11	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:361
10	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
9	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
8	JDocumentHtml->countModules()	JROOT/templates/agos/index.php:245
7	require JROOT/templates/agos/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->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.82 ms Dopo l'ultima query: 7.77 ms Memoria query: 0.301 MB memoria prima della query: 11.048 MB Righe restituite: 24

SELECT DISTINCT i.*,c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams 
  FROM nuvrj_k2_items as i RIGHT JOIN nuvrj_k2_categories c 
  ON c.id = i.catid 
  WHERE i.published = 1 
  AND i.access IN(1,1,5) 
  AND i.trash = 0 
  AND c.published = 1 
  AND c.access IN(1,1,5)  
  AND c.trash = 0 
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2019-11-18 04:52:45' ) 
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2019-11-18 04:52:45' ) 
  AND i.catid IN(17) 
  AND c.language IN ('it-IT', '*') 
  AND i.language IN ('it-IT', '*') 
  ORDER BY i.title 
  LIMIT 0, 50

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,category,published,access,trash,language	PRIMARY	4	const	1	Using filesort
1	SIMPLE	i	ref	item,catid,language	catid	4	const	35	Using where

Profilo

Status	Duration
starting	0.10 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.07 ms
optimizing	0.05 ms
statistics	0.14 ms
preparing	0.01 ms
Unlocking tables	0.05 ms
executing	0.01 ms
Sorting result	0.27 ms
Sending data	0.93 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.02 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_k2_content/helper.php:286
11	modK2ContentHelper::getItems()	JROOT/modules/mod_k2_content/mod_k2_content.php:70
10	include JROOT/modules/mod_k2_content/mod_k2_content.php	JROOT/libraries/cms/module/helper.php:199
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->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: 17.35 ms Memoria query: 0.038 MB memoria prima della query: 11.784 MB Righe restituite: 123

SELECT * 
  FROM nuvrj_acymailing_config

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:33
13	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:907
12	acymailing_config()	JROOT/administrator/components/com_acymailing/helpers/helper.php:2257
11	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/modules/mod_acymailing/mod_acymailing.php:23
10	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/libraries/cms/module/helper.php:199
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->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.60 ms Dopo l'ultima query: 3.34 ms Memoria query: 0.040 MB memoria prima della query: 12.051 MB Righe restituite: 26

SELECT * 
  FROM nuvrj_acymailing_list 
  WHERE type = 'list'  
  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nuvrj_acymailing_list	ALL	typeorderingindex,typeuseridindex	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	26	Using where; Using filesort

Profilo

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.01 ms
Sorting result	0.07 ms
Sending data	0.19 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking 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
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/classes/list.php:57
11	listClass->getLists()	JROOT/modules/mod_acymailing/mod_acymailing.php:241
10	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/libraries/cms/module/helper.php:199
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->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: 25.14 ms Memoria query: 0.035 MB memoria prima della query: 13.003 MB Righe restituite: 0

SELECT `id`,`referencekey`,`value`,`system`,`editable`

  FROM `nuvrj_nextend2_section_storage`

  WHERE `application` = 'system' 
  AND `section` = 'global'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nuvrj_nextend2_section_storage	ref	application,application_2	application	160	const,const	1	Using index condition

Profilo

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

Call Stack

#	Caller	File e numero di linea
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
24	JDatabaseDriver->loadAssocList()	JROOT/libraries/nextend2/nextend/joomla/libraries/mvc/db.php:243
23	N2DBConnector->findAllByAttributes()	JROOT/libraries/nextend2/nextend/library/libraries/storage/section.php:133
22	N2StorageSectionAdmin::getAll()	JROOT/libraries/nextend2/nextend/library/settings.php:43
21	N2Settings::init()	JROOT/libraries/nextend2/nextend/library/settings.php:115
20	require_once JROOT/libraries/nextend2/nextend/library/settings.php	JROOT/libraries/nextend2/nextend/library/loader.php:89
19	N2Loader::importPath()	JROOT/libraries/nextend2/nextend/library/loader.php:45
18	N2Loader::import()	JROOT/libraries/nextend2/nextend/library/library.php:69
17	require_once JROOT/libraries/nextend2/nextend/library/library.php	JROOT/libraries/nextend2/nextend/joomla/library.php:35
16	include_once JROOT/libraries/nextend2/nextend/joomla/library.php	JROOT/libraries/loader.php:219
15	JLoader::import()	JROOT/libraries/loader.php:682
14	jimport()	JROOT/plugins/system/nextendsmartslider3/nextendsmartslider3.php:115
13	nextend_smartslider3()	JROOT/plugins/system/nextendsmartslider3/nextendsmartslider3.php:89
12	plgSystemNextendSmartslider3::prepare()	Chiamata uguale alla linea sottostante.
11	preg_replace_callback()	JROOT/plugins/system/nextendsmartslider3/nextendsmartslider3.php:61
10	plgSystemNextendSmartslider3->onNextendBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:69
9	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
8	JEventDispatcher->trigger()	JROOT/plugins/system/nextend2/nextend2.php:57
7	plgSystemNextend2->onAfterRender()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->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: 36.32 ms Memoria query: 0.036 MB memoria prima della query: 16.192 MB Righe restituite: 0

SELECT `id`,`referencekey`,`value`,`system`,`editable`

  FROM `nuvrj_nextend2_section_storage`

  WHERE `application` = 'system' 
  AND `section` = 'fonts'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nuvrj_nextend2_section_storage	ref	application,application_2	application	160	const,const	1	Using index condition

Profilo

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

Call Stack

#	Caller	File e numero di linea
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
27	JDatabaseDriver->loadAssocList()	JROOT/libraries/nextend2/nextend/joomla/libraries/mvc/db.php:243
26	N2DBConnector->findAllByAttributes()	JROOT/libraries/nextend2/nextend/library/libraries/storage/section.php:133
25	N2StorageSectionAdmin::getAll()	JROOT/libraries/nextend2/nextend/library/libraries/fonts/fonts.php:33
24	N2Fonts::loadSettings()	JROOT/libraries/nextend2/nextend/library/libraries/fonts/fonts.php:93
23	require_once JROOT/libraries/nextend2/nextend/library/libraries/fonts/fonts.php	JROOT/libraries/nextend2/nextend/library/loader.php:89
22	N2Loader::importPath()	JROOT/libraries/nextend2/nextend/library/loader.php:45
21	N2Loader::import()	JROOT/libraries/nextend2/nextend/library/libraries/assets/predefined.php:101
20	N2AssetsPredefined::frontend()	JROOT/libraries/nextend2/nextend/library/libraries/mvc/controller.php:75
19	N2ControllerAbstract->initialize()	JROOT/libraries/nextend2/smartslider/smartslider/widget/controllers/Home.php:13
18	N2SmartSliderWidgetHomeController->initialize()	JROOT/libraries/nextend2/nextend/library/libraries/mvc/controller.php:59
17	N2ControllerAbstract->__construct()	JROOT/libraries/nextend2/nextend/library/libraries/mvc/application/type.php:345
16	N2ApplicationType->createControllerObject()	JROOT/libraries/nextend2/nextend/library/libraries/mvc/application/type.php:185
15	N2ApplicationType->run()	JROOT/libraries/nextend2/nextend/library/libraries/mvc/application/type.php:367
14	N2ApplicationType->render()	JROOT/plugins/system/nextendsmartslider3/nextendsmartslider3.php:135
13	nextend_smartslider3()	JROOT/plugins/system/nextendsmartslider3/nextendsmartslider3.php:89
12	plgSystemNextendSmartslider3::prepare()	Chiamata uguale alla linea sottostante.
11	preg_replace_callback()	JROOT/plugins/system/nextendsmartslider3/nextendsmartslider3.php:61
10	plgSystemNextendSmartslider3->onNextendBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:69
9	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
8	JEventDispatcher->trigger()	JROOT/plugins/system/nextend2/nextend2.php:57
7	plgSystemNextend2->onAfterRender()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->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.50 ms Dopo l'ultima query: 9.89 ms Memoria query: 0.041 MB memoria prima della query: 17.180 MB Righe restituite: 1

SELECT *

  FROM `nuvrj_nextend2_section_storage`

  WHERE `application` = 'smartslider' 
  AND `section` = 'sliderChanged' 
  AND `referencekey` = 13

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nuvrj_nextend2_section_storage	ref	application,application_2	application	160	const,const	11	Using index condition

Profilo

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

Call Stack

#	Caller	File e numero di linea
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
33	JDatabaseDriver->loadAssoc()	JROOT/libraries/nextend2/nextend/joomla/libraries/mvc/db.php:145
32	N2DBConnector->findByAttributes()	JROOT/libraries/nextend2/nextend/library/libraries/storage/section.php:365
31	N2StorageSection->get()	JROOT/libraries/nextend2/smartslider/smartslider/libraries/slider/helper.php:53
30	N2SmartSliderHelper->isSliderChanged()	JROOT/libraries/nextend2/smartslider/smartslider/libraries/slider/cache/slider.php:47
29	N2CacheManifestSlider->isCacheValid()	JROOT/libraries/nextend2/nextend/library/libraries/cache/manifest.php:65
28	N2CacheManifest->isCached()	JROOT/libraries/nextend2/nextend/library/libraries/cache/manifest.php:27
27	N2CacheManifest->makeCache()	JROOT/libraries/nextend2/smartslider/smartslider/libraries/slider/cache/slider.php:35
26	N2CacheManifestSlider->makeCache()	JROOT/libraries/nextend2/smartslider/smartslider/libraries/slider/manager.php:87
25	N2SmartSliderManager->cacheSlider()	JROOT/libraries/nextend2/smartslider/smartslider/libraries/slider/manager.php:69
24	N2SmartSliderManager->render()	JROOT/libraries/nextend2/smartslider/smartslider/widget/views/home/joomla.phtml:7
23	include JROOT/libraries/nextend2/smartslider/smartslider/widget/views/home/joomla.phtml	JROOT/libraries/nextend2/nextend/library/libraries/mvc/view.php:109
22	N2View->renderInline()	JROOT/libraries/nextend2/nextend/library/libraries/mvc/layout.php:161
21	N2Layout->renderFragmentBlock()	JROOT/libraries/nextend2/smartslider/smartslider/widget/layouts/default.phtml:7
20	include JROOT/libraries/nextend2/smartslider/smartslider/widget/layouts/default.phtml	JROOT/libraries/nextend2/nextend/library/libraries/mvc/layout.php:105
19	N2Layout->renderLayout()	JROOT/libraries/nextend2/nextend/library/libraries/mvc/layout.php:143
18	N2Layout->render()	JROOT/libraries/nextend2/nextend/library/libraries/mvc/controller.php:137
17	N2ControllerAbstract->render()	JROOT/libraries/nextend2/smartslider/smartslider/widget/controllers/Home.php:51
16	N2SmartSliderWidgetHomeController->actionJoomla()	JROOT/libraries/nextend2/nextend/library/libraries/mvc/application/type.php:191
15	N2ApplicationType->run()	JROOT/libraries/nextend2/nextend/library/libraries/mvc/application/type.php:367
14	N2ApplicationType->render()	JROOT/plugins/system/nextendsmartslider3/nextendsmartslider3.php:135
13	nextend_smartslider3()	JROOT/plugins/system/nextendsmartslider3/nextendsmartslider3.php:89
12	plgSystemNextendSmartslider3::prepare()	Chiamata uguale alla linea sottostante.
11	preg_replace_callback()	JROOT/plugins/system/nextendsmartslider3/nextendsmartslider3.php:61
10	plgSystemNextendSmartslider3->onNextendBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:69
9	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
8	JEventDispatcher->trigger()	JROOT/plugins/system/nextend2/nextend2.php:57
7	plgSystemNextend2->onAfterRender()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->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.38 ms Dopo l'ultima query: 0.26 ms Memoria query: 0.041 MB memoria prima della query: 17.200 MB Righe restituite: 1

SELECT * 
  FROM nuvrj_nextend2_smartslider3_sliders 
  WHERE id = 13

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
33	JDatabaseDriver->loadAssoc()	JROOT/libraries/nextend2/nextend/joomla/libraries/mvc/db.php:281
32	N2DBConnector->queryRow()	JROOT/libraries/nextend2/smartslider/smartslider/models/Sliders.php:27
31	N2SmartsliderSlidersModel->get()	JROOT/libraries/nextend2/smartslider/smartslider/libraries/slider/abstract.php:287
30	N2SmartSliderAbstract->loadSlider()	JROOT/libraries/nextend2/smartslider/smartslider/libraries/slider/abstract.php:365
29	N2SmartSliderAbstract->render()	JROOT/libraries/nextend2/smartslider/smartslider/libraries/slider/manager.php:117
28	N2SmartSliderManager->renderCachedSlider()	JROOT/libraries/nextend2/nextend/library/libraries/cache/manifest.php:31
27	N2CacheManifest->makeCache()	JROOT/libraries/nextend2/smartslider/smartslider/libraries/slider/cache/slider.php:35
26	N2CacheManifestSlider->makeCache()	JROOT/libraries/nextend2/smartslider/smartslider/libraries/slider/manager.php:87
25	N2SmartSliderManager->cacheSlider()	JROOT/libraries/nextend2/smartslider/smartslider/libraries/slider/manager.php:69
24	N2SmartSliderManager->render()	JROOT/libraries/nextend2/smartslider/smartslider/widget/views/home/joomla.phtml:7
23	include JROOT/libraries/nextend2/smartslider/smartslider/widget/views/home/joomla.phtml	JROOT/libraries/nextend2/nextend/library/libraries/mvc/view.php:109
22	N2View->renderInline()	JROOT/libraries/nextend2/nextend/library/libraries/mvc/layout.php:161
21	N2Layout->renderFragmentBlock()	JROOT/libraries/nextend2/smartslider/smartslider/widget/layouts/default.phtml:7
20	include JROOT/libraries/nextend2/smartslider/smartslider/widget/layouts/default.phtml	JROOT/libraries/nextend2/nextend/library/libraries/mvc/layout.php:105
19	N2Layout->renderLayout()	JROOT/libraries/nextend2/nextend/library/libraries/mvc/layout.php:143
18	N2Layout->render()	JROOT/libraries/nextend2/nextend/library/libraries/mvc/controller.php:137
17	N2ControllerAbstract->render()	JROOT/libraries/nextend2/smartslider/smartslider/widget/controllers/Home.php:51
16	N2SmartSliderWidgetHomeController->actionJoomla()	JROOT/libraries/nextend2/nextend/library/libraries/mvc/application/type.php:191
15	N2ApplicationType->run()	JROOT/libraries/nextend2/nextend/library/libraries/mvc/application/type.php:367
14	N2ApplicationType->render()	JROOT/plugins/system/nextendsmartslider3/nextendsmartslider3.php:135
13	nextend_smartslider3()	JROOT/plugins/system/nextendsmartslider3/nextendsmartslider3.php:89
12	plgSystemNextendSmartslider3::prepare()	Chiamata uguale alla linea sottostante.
11	preg_replace_callback()	JROOT/plugins/system/nextendsmartslider3/nextendsmartslider3.php:61
10	plgSystemNextendSmartslider3->onNextendBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:69
9	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
8	JEventDispatcher->trigger()	JROOT/plugins/system/nextend2/nextend2.php:57
7	plgSystemNextend2->onAfterRender()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->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: 0.47 ms Memoria query: 0.044 MB memoria prima della query: 17.349 MB Righe restituite: 1

SELECT *

  FROM `nuvrj_nextend2_section_storage`

  WHERE `application` = 'smartslider' 
  AND `section` = 'settings'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nuvrj_nextend2_section_storage	ref	application,application_2	application	160	const,const	1	Using index condition

Profilo

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking 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
38	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
37	JDatabaseDriver->loadAssoc()	JROOT/libraries/nextend2/nextend/joomla/libraries/mvc/db.php:145
36	N2DBConnector->findByAttributes()	JROOT/libraries/nextend2/nextend/library/libraries/storage/section.php:365
35	N2StorageSection->get()	JROOT/libraries/nextend2/smartslider/smartslider/libraries/settings/settings.php:23
34	N2SmartSliderSettings::getAll()	JROOT/libraries/nextend2/smartslider/smartslider/libraries/settings/settings.php:37
33	N2SmartSliderSettings::get()	JROOT/libraries/nextend2/smartslider/smartslider/libraries/slider/features/responsive.php:163
32	N2SmartSliderFeatureResponsive->__construct()	JROOT/libraries/nextend2/smartslider/smartslider/libraries/slider/features/features.php:161
31	N2SmartSliderFeatures->__construct()	JROOT/libraries/nextend2/smartslider/smartslider/libraries/slider/abstract.php:331
30	N2SmartSliderAbstract->loadSlider()	JROOT/libraries/nextend2/smartslider/smartslider/libraries/slider/abstract.php:365
29	N2SmartSliderAbstract->render()	JROOT/libraries/nextend2/smartslider/smartslider/libraries/slider/manager.php:117
28	N2SmartSliderManager->renderCachedSlider()	JROOT/libraries/nextend2/nextend/library/libraries/cache/manifest.php:31
27	N2CacheManifest->makeCache()	JROOT/libraries/nextend2/smartslider/smartslider/libraries/slider/cache/slider.php:35
26	N2CacheManifestSlider->makeCache()	JROOT/libraries/nextend2/smartslider/smartslider/libraries/slider/manager.php:87
25	N2SmartSliderManager->cacheSlider()	JROOT/libraries/nextend2/smartslider/smartslider/libraries/slider/manager.php:69
24	N2SmartSliderManager->render()	JROOT/libraries/nextend2/smartslider/smartslider/widget/views/home/joomla.phtml:7
23	include JROOT/libraries/nextend2/smartslider/smartslider/widget/views/home/joomla.phtml	JROOT/libraries/nextend2/nextend/library/libraries/mvc/view.php:109
22	N2View->renderInline()	JROOT/libraries/nextend2/nextend/library/libraries/mvc/layout.php:161
21	N2Layout->renderFragmentBlock()	JROOT/libraries/nextend2/smartslider/smartslider/widget/layouts/default.phtml:7
20	include JROOT/libraries/nextend2/smartslider/smartslider/widget/layouts/default.phtml	JROOT/libraries/nextend2/nextend/library/libraries/mvc/layout.php:105
19	N2Layout->renderLayout()	JROOT/libraries/nextend2/nextend/library/libraries/mvc/layout.php:143
18	N2Layout->render()	JROOT/libraries/nextend2/nextend/library/libraries/mvc/controller.php:137
17	N2ControllerAbstract->render()	JROOT/libraries/nextend2/smartslider/smartslider/widget/controllers/Home.php:51
16	N2SmartSliderWidgetHomeController->actionJoomla()	JROOT/libraries/nextend2/nextend/library/libraries/mvc/application/type.php:191
15	N2ApplicationType->run()	JROOT/libraries/nextend2/nextend/library/libraries/mvc/application/type.php:367
14	N2ApplicationType->render()	JROOT/plugins/system/nextendsmartslider3/nextendsmartslider3.php:135
13	nextend_smartslider3()	JROOT/plugins/system/nextendsmartslider3/nextendsmartslider3.php:89
12	plgSystemNextendSmartslider3::prepare()	Chiamata uguale alla linea sottostante.
11	preg_replace_callback()	JROOT/plugins/system/nextendsmartslider3/nextendsmartslider3.php:61
10	plgSystemNextendSmartslider3->onNextendBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:69
9	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
8	JEventDispatcher->trigger()	JROOT/plugins/system/nextend2/nextend2.php:57
7	plgSystemNextend2->onAfterRender()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->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.18 ms Memoria query: 0.045 MB memoria prima della query: 17.384 MB Righe restituite: 1

SELECT * 
  FROM nuvrj_nextend2_smartslider3_slides 
  WHERE slider = 13  
  AND published = 1  
  ORDER BY ordering

Appartenenza Scuola a Organismi scientifici e istituzionali

Federazione Italiana Società di Agopuntura

Franco Cracolici, Vicepresidente FISA

Federazione Italiana Scuole Tuina e Qigong

Franco Cracolici, Presidente FISTQ

World Federation of Acupuncture-Moxibustion Societies

Franco Cracolici, Membro esecutivo WFAS

Associazione per la ricerca di terapie oncologiche integrate

Franco Cracolici, Resp. tavolo agopuntura

Società italiana psico neuroendocrino-immunologia

Franco Cracolici, Coord. Regione Toscana

Unione Medicina Non Convenzionale Veterinaria

...

CORSO DI FITONUTRIZIONE, NUTRACEUTICA E DIETETICA CINESE

NUOVI CORSI 2019/2020

SEMINARI DI ALTA FORMAZIONE IN AGOPUNTURA

Console Debug Joomla!

Sessione

Informazioni profilo

Tempo

Memoria

Utilizzo memoria

Query Database

66 query eseguite 117.40 ms

Trovati 18 duplicati!