Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1713608882,
                "last": 1713608882,
                "now": 1713608882
            },
            "token": "80Q22GfTKOAFjBJPGTZkCFo8Qz8T8DX8"
        },
        "registry": {
            "plg_system_eprivacy_non_eu": false
        },
        "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
        },
        "com_mailto": {
            "links": {
                "808a2e6c97ea011a72c8b9814745d0d25d7b5ecd": {
                    "link": "http:\/\/www.associazioneroveroni.it\/index.php\/component\/k2\/seo-for-ecommerce-sites-where-to-start?tmpl=component&print=1",
                    "expiry": 1713608883
                }
            }
        }
    }
}

Informazioni profilo

Utilizzo memoria

Query Database

53 query eseguite 41.37 ms

Tempo della query: 0.58 ms

SELECT `data`

  FROM `npcux_session`

  WHERE `session_id` = 'atl4bav8m24mr05h8a7ia72qs5'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	npcux_session	const	PRIMARY	PRIMARY	575	const	1

Profilo

Error
MySql have_profiling = off

Call Stack

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

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

Tempo della query: 0.40 ms Dopo l'ultima query: 7.97 ms

SELECT `session_id`

  FROM `npcux_session`

  WHERE `session_id` = 'atl4bav8m24mr05h8a7ia72qs5' 
  LIMIT 1

Explain

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

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
8	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
7	JDatabaseDriver->loadResult()	JROOT/libraries/src/Application/CMSApplication.php:178
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:833
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:133
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:415
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Tempo della query: 0.39 ms Dopo l'ultima query: 0.32 ms

INSERT INTO `npcux_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('atl4bav8m24mr05h8a7ia72qs5', 1, '1713608882', 0, '', 0)

Explain

EXPLAIN non possibile sulla query: INSERT INTO `npcux_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('atl4bav8m24mr05h8a7ia72qs5', 1, '1713608882', 0, '', 0)

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
7	JDatabaseDriverMysql->execute()	JROOT/libraries/src/Application/CMSApplication.php:218
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:833
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:133
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:415
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Tempo della query: 0.27 ms Dopo l'ultima query: 47.70 ms

SELECT id, rules

  FROM `npcux_viewlevels`

Explain

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

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

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

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

Tempo della query: 0.21 ms Dopo l'ultima query: 0.26 ms

SELECT b.id

  FROM npcux_usergroups AS a

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

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

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

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

Tempo della query: 0.61 ms Dopo l'ultima query: 97.55 ms

UPDATE `npcux_extensions`

  SET `params` = '{\"mediaversion\":\"98bd5f1d4be7c3527592c3140a241e04\"}'

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

Explain

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

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

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

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

Tempo della query: 0.39 ms Dopo l'ultima query: 92.56 ms

SELECT `lastupdate`

  FROM `npcux_ak_storage`

  WHERE `tag` = 'akeebaupdatecheck_lastrun'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	npcux_ak_storage	const	PRIMARY	PRIMARY	302	const	1

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
10	JDatabaseDriver->loadResult()	JROOT/plugins/system/akeebaupdatecheck/akeebaupdatecheck.php:116
9	plgSystemAkeebaupdatecheck->onAfterInitialise()	Chiamata uguale alla linea sottostante.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:686
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.70 ms Dopo l'ultima query: 119.83 ms

SELECT id 
  FROM npcux_k2_items 
  WHERE alias = 'seo-for-ecommerce-sites-
  where-to-start'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	npcux_k2_items	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	71	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
12	JDatabaseDriver->loadResult()	JROOT/components/com_k2/router.php:503
11	getItemId()	JROOT/components/com_k2/router.php:353
10	k2ParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1147
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.37 ms Dopo l'ultima query: 310.70 ms

SELECT * 
  FROM npcux_acymailing_config

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	npcux_acymailing_config	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	136

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
13	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:392
12	acymailing_config()	JROOT/administrator/components/com_acymailing/helpers/helper.php:1369
11	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:21
10	plgSystemRegacymailing->initAcy()	JROOT/plugins/system/regacymailing/regacymailing.php:32
9	plgSystemRegacymailing->onAfterRoute()	Chiamata uguale alla linea sottostante.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1156
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.34 ms Dopo l'ultima query: 18.14 ms

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

  FROM `npcux_assets`

  WHERE `name` IN ('root.1','com_acymailing','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_joomlaupdate','com_jvajax_searchpro','com_jvframework','com_jvpanel','com_jvportfolio','com_jvss','com_jvtestimonial','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osgallery','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_tcpdf','com_templates','com_users','com_virtuemart','com_virtuemart_allinone','com_weblinks','com_wrapper')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	npcux_assets	ALL	idx_asset_name	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	295	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
11	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
10	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
9	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
8	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
7	Joomla\CMS\User\User->authorise()	JROOT/components/com_k2/k2.php:16
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.50 ms Dopo l'ultima query: 64.55 ms

SELECT id 
  FROM npcux_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	npcux_k2_categories	range	category,published,access,trash	category	8	NULL	10	Using where; Using index

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1540
14	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/helpers/permissions.php:274
13	K2HelperPermissions::canAddItem()	JROOT/components/com_k2/views/item/view.html.php:36
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.46 ms Dopo l'ultima query: 0.43 ms

SELECT * 
  FROM npcux_k2_items 
  WHERE id=84 
  LIMIT 0, 1

Explain

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

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1652
14	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:35
13	K2ModelItem->getData()	JROOT/components/com_k2/views/item/view.html.php:42
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.93 ms Dopo l'ultima query: 3.95 ms

SHOW FULL COLUMNS 
  FROM `npcux_k2_categories`

Explain

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

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
20	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_k2/tables/k2category.php:36
15	TableK2Category->__construct()	JROOT/libraries/src/Table/Table.php:312
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_k2/models/item.php:72
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.44 ms Dopo l'ultima query: 6.78 ms

SELECT * 
  FROM npcux_k2_categories 
  WHERE id = '24'

Explain

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

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1455
15	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:67
14	TableK2Category->load()	JROOT/components/com_k2/models/item.php:73
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.48 ms Dopo l'ultima query: 10.77 ms

SELECT id, name,  parent	
  FROM npcux_k2_categories 
  WHERE published=1  
  AND trash=0 
  AND access IN(1,1,5) 
  ORDER BY parent

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	npcux_k2_categories	ref	category,published,access,trash	published	2	const	9	Using where; Using filesort

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/itemlist.php:1245
16	K2ModelItemlist->getCategoriesTree()	JROOT/components/com_k2/helpers/route.php:314
15	K2HelperRoute::_findItem()	JROOT/components/com_k2/helpers/route.php:58
14	K2HelperRoute::getCategoryRoute()	JROOT/components/com_k2/models/item.php:76
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.49 ms Dopo l'ultima query: 3.54 ms

SELECT tag.*
			
  FROM npcux_k2_tags AS tag
			JOIN npcux_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
			
  WHERE tag.published=1
			
  AND xref.itemID = 84 
  ORDER BY xref.id ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xref	ref	tagID,itemID	itemID	4	const	3	Using where
1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	113d3da5d_03dd5e.xref.tagID	1	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1387
14	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:107
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.48 ms Dopo l'ultima query: 3.47 ms

SELECT * 
  FROM npcux_k2_attachments 
  WHERE itemID=84

Explain

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

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1680
14	K2ModelItem->getItemAttachments()	JROOT/components/com_k2/models/item.php:188
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.40 ms Dopo l'ultima query: 0.22 ms

SELECT * 
  FROM npcux_k2_rating 
  WHERE itemID = 84

Explain

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

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1652
16	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1011
15	K2ModelItem->getRating()	JROOT/components/com_k2/models/item.php:1066
14	K2ModelItem->getVotesPercentage()	JROOT/components/com_k2/models/item.php:194
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.90 ms Dopo l'ultima query: 5.74 ms

SHOW FULL COLUMNS 
  FROM `npcux_users`

Explain

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

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
25	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
23	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
22	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
21	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:40
20	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:312
19	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
18	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:880
17	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
16	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
15	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
14	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:246
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 1.71 ms Dopo l'ultima query: 0.61 ms

SELECT *

  FROM `npcux_users`

  WHERE `id` = 683

Explain

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

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
20	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1455
19	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:86
18	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:883
17	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
16	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
15	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
14	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:246
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 1.09 ms Dopo l'ultima query: 9.01 ms

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM npcux_k2_users 
  WHERE userID=683

Explain

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

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1652
15	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1853
14	K2ModelItem->getUserProfile()	JROOT/components/com_k2/models/item.php:249
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.53 ms Dopo l'ultima query: 1.12 ms

SELECT COUNT(*) 
  FROM npcux_k2_comments 
  WHERE itemID=84 
  AND published=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	npcux_k2_comments	ref	itemID,published,latestComments,countComments	itemID	4	const	1	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
15	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1723
14	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:273
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.34 ms Dopo l'ultima query: 53.89 ms

SELECT * 
  FROM npcux_jv_typos 
  WHERE published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	npcux_jv_typos	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	28	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
24	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
23	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jvframework/framework/extensions/typo/typo.php:42
22	JVFrameworkExtensionTypo->getReplacement()	JROOT/plugins/system/jvframework/framework/extensions/typo/typo.php:30
21	JVFrameworkExtensionTypo->onContentPrepare()	Chiamata uguale alla linea sottostante.
20	call_user_func_array()	JROOT/plugins/system/jvframework/framework/libraries/framework.php:326
19	JV::call()	JROOT/plugins/system/jvframework/framework/libraries/helpers/event.php:68
18	JVFrameworkHelperEvent->fireEvent()	JROOT/plugins/system/jvframework/jvframework.php:135
17	plgSystemJVFramework->onContentPrepare()	Chiamata uguale alla linea sottostante.
16	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
14	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:669
13	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/item/view.html.php:54
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.80 ms Dopo l'ultima query: 21.44 ms

SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state

  FROM npcux_fields AS a

  LEFT JOIN `npcux_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN npcux_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN npcux_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN npcux_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN npcux_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `npcux_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_k2.item-media' 
  AND (fc.category_id IS NULL OR fc.category_id IN (24,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	21	113d3da5d_03dd5e.a.language	1
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	113d3da5d_03dd5e.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	113d3da5d_03dd5e.a.access	1
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	113d3da5d_03dd5e.a.created_user_id	1
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	113d3da5d_03dd5e.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	113d3da5d_03dd5e.a.id	1	Using where; Using index

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
23	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
20	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
18	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
17	PlgSystemFields->onContentPrepare()	Chiamata uguale alla linea sottostante.
16	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
14	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:669
13	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/item/view.html.php:54
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.72 ms Dopo l'ultima query: 13.74 ms

SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state

  FROM npcux_fields AS a

  LEFT JOIN `npcux_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN npcux_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN npcux_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN npcux_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN npcux_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `npcux_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_k2.item' 
  AND (fc.category_id IS NULL OR fc.category_id IN (24,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	21	113d3da5d_03dd5e.a.language	1
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	113d3da5d_03dd5e.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	113d3da5d_03dd5e.a.access	1
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	113d3da5d_03dd5e.a.created_user_id	1
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	113d3da5d_03dd5e.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	113d3da5d_03dd5e.a.id	1	Using where; Using index

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
23	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
20	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
18	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
17	PlgSystemFields->onContentPrepare()	Chiamata uguale alla linea sottostante.
16	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
14	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:738
13	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/item/view.html.php:54
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 1.35 ms Dopo l'ultima query: 18.06 ms

SHOW FULL COLUMNS 
  FROM `npcux_k2_items`

Explain

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

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
20	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_k2/tables/k2item.php:58
15	TableK2Item->__construct()	JROOT/libraries/src/Table/Table.php:312
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_k2/models/item.php:917
13	K2ModelItem->hit()	JROOT/components/com_k2/views/item/view.html.php:136
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.53 ms Dopo l'ultima query: 0.65 ms

UPDATE npcux_k2_items

  SET `hits` = (`hits` + 1)

  WHERE `id` = '84'

Explain

EXPLAIN non possibile sulla query: UPDATE npcux_k2_items SET `hits` = (`hits` + 1) WHERE `id` = '84'

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysql->execute()	JROOT/libraries/src/Table/Table.php:1241
14	Joomla\CMS\Table\Table->hit()	JROOT/components/com_k2/models/item.php:918
13	K2ModelItem->hit()	JROOT/components/com_k2/views/item/view.html.php:136
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 1.85 ms Dopo l'ultima query: 0.35 ms

SELECT i.*, c.alias as categoryalias 
  FROM npcux_k2_items as i
				
  LEFT JOIN npcux_k2_categories c 
  ON c.id = i.catid
				
  WHERE i.id != 84
				
  AND i.published = 1
				
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-04-20 10:28:03' )
				
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-04-20 10:28:03' )  
  AND i.access IN(1,1,5)  
  AND i.trash = 0
				
  AND i.created_by = 683
				
  AND i.created_by_alias=''
				
  AND c.published = 1  
  AND c.access IN(1,1,5)  
  AND c.trash = 0
				
  ORDER BY i.created DESC 
  LIMIT 0, 5

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	PRIMARY,category,published,access,trash	published	2	const	9	Using where; Using temporary; Using filesort
1	SIMPLE	i	ref	PRIMARY,item,catid,created_by	catid	4	113d3da5d_03dd5e.c.id	2	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/itemlist.php:871
13	K2ModelItemlist->getAuthorLatest()	JROOT/components/com_k2/views/item/view.html.php:291
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.57 ms Dopo l'ultima query: 14.02 ms

SELECT DISTINCT itemID 
  FROM npcux_k2_tags_xref 
  WHERE tagID IN (12,13) 
  AND itemID!=84

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	npcux_k2_tags_xref	range	tagID,itemID	tagID	4	NULL	12	Using where; Using temporary

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1540
14	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/models/itemlist.php:927
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:306
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.79 ms Dopo l'ultima query: 0.24 ms

SELECT i.*, c.alias as categoryalias 
  FROM npcux_k2_items as i
				
  LEFT JOIN npcux_k2_categories c 
  ON c.id = i.catid
				
  WHERE i.published = 1
				
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-04-20 10:28:03' )
				
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-04-20 10:28:03' )  
  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.id) IN (81,82,83,85,86)
				
  ORDER BY i.created DESC 
  LIMIT 0, 5

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	range	PRIMARY,item,catid	PRIMARY	4	NULL	5	Using where; Using filesort
1	SIMPLE	c	eq_ref	PRIMARY,category,published,access,trash	PRIMARY	4	113d3da5d_03dd5e.i.catid	1	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/itemlist.php:975
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:306
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.47 ms Dopo l'ultima query: 5.90 ms

SELECT COUNT(*) 
  FROM npcux_k2_comments 
  WHERE itemID=82 
  AND published=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	npcux_k2_comments	ref	itemID,published,latestComments,countComments	itemID	4	const	1	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
16	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1723
15	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:273
14	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:988
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:306
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.77 ms Dopo l'ultima query: 0.93 ms

SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state

  FROM npcux_fields AS a

  LEFT JOIN `npcux_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN npcux_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN npcux_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN npcux_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN npcux_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `npcux_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_k2.relatedByTag-media' 
  AND (fc.category_id IS NULL OR fc.category_id IN (24,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	21	113d3da5d_03dd5e.a.language	1
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	113d3da5d_03dd5e.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	113d3da5d_03dd5e.a.access	1
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	113d3da5d_03dd5e.a.created_user_id	1
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	113d3da5d_03dd5e.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	113d3da5d_03dd5e.a.id	1	Using where; Using index

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
24	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
19	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
18	PlgSystemFields->onContentPrepare()	Chiamata uguale alla linea sottostante.
17	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:669
14	K2ModelItem->execPlugins()	JROOT/components/com_k2/models/itemlist.php:989
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:306
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.66 ms Dopo l'ultima query: 0.85 ms

SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state

  FROM npcux_fields AS a

  LEFT JOIN `npcux_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN npcux_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN npcux_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN npcux_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN npcux_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `npcux_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_k2.relatedByTag' 
  AND (fc.category_id IS NULL OR fc.category_id IN (24,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	21	113d3da5d_03dd5e.a.language	1
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	113d3da5d_03dd5e.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	113d3da5d_03dd5e.a.access	1
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	113d3da5d_03dd5e.a.created_user_id	1
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	113d3da5d_03dd5e.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	113d3da5d_03dd5e.a.id	1	Using where; Using index

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
24	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
19	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
18	PlgSystemFields->onContentPrepare()	Chiamata uguale alla linea sottostante.
17	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:738
14	K2ModelItem->execPlugins()	JROOT/components/com_k2/models/itemlist.php:989
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:306
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.44 ms Dopo l'ultima query: 6.44 ms

SELECT COUNT(*) 
  FROM npcux_k2_comments 
  WHERE itemID=83 
  AND published=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	npcux_k2_comments	ref	itemID,published,latestComments,countComments	itemID	4	const	1	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
16	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1723
15	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:273
14	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:988
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:306
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.44 ms Dopo l'ultima query: 9.44 ms

SELECT COUNT(*) 
  FROM npcux_k2_comments 
  WHERE itemID=85 
  AND published=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	npcux_k2_comments	ref	itemID,published,latestComments,countComments	itemID	4	const	1	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
16	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1723
15	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:273
14	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:988
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:306
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.64 ms Dopo l'ultima query: 14.16 ms

SELECT COUNT(*) 
  FROM npcux_k2_comments 
  WHERE itemID=86 
  AND published=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	npcux_k2_comments	ref	itemID,published,latestComments,countComments	itemID	4	const	1	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
16	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1723
15	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:273
14	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:988
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:306
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 10.06 ms Dopo l'ultima query: 1.79 ms

SELECT * 
  FROM npcux_k2_items 
  WHERE id != 84 
  AND catid=24 
  AND ordering > 3 
  AND published=1 
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-04-20 10:28:03' ) 
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-04-20 10:28:03' )  
  AND access IN(1,1,5) 
  AND trash=0  
  ORDER BY ordering ASC 
  LIMIT 0, 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	npcux_k2_items	ref	PRIMARY,item,catid,ordering	catid	4	const	5	Using where; Using filesort

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1652
14	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1835
13	K2ModelItem->getNextItem()	JROOT/components/com_k2/views/item/view.html.php:323
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 1.25 ms Dopo l'ultima query: 1.09 ms

SELECT * 
  FROM npcux_k2_items 
  WHERE id != 84 
  AND catid=24 
  AND ordering < 3 
  AND published=1 
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-04-20 10:28:03' ) 
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-04-20 10:28:03' )  
  AND access IN(1,1,5) 
  AND trash=0  
  ORDER BY ordering DESC 
  LIMIT 0, 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	npcux_k2_items	ref	PRIMARY,item,catid,ordering	catid	4	const	5	Using where; Using filesort

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1652
14	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1791
13	K2ModelItem->getPreviousItem()	JROOT/components/com_k2/views/item/view.html.php:364
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 3.33 ms Dopo l'ultima query: 59.65 ms

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

  FROM npcux_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-04-20 10:28:03') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-20 10:28:03') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	published,newsfeeds	published	1	const	60	Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	113d3da5d_03dd5e.m.id	1	Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	113d3da5d_03dd5e.m.module,const	1	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jvframework/framework/libraries/helpers/position.php:229
16	JVFrameworkHelperPosition::_load()	JROOT/plugins/system/jvframework/framework/libraries/helpers/position.php:142
15	JVFrameworkHelperPosition->getModules()	JROOT/plugins/system/jvframework/framework/libraries/helpers/position.php:105
14	JVFrameworkHelperPosition->count()	JROOT/plugins/system/jvframework/framework/libraries/helpers/block.php:62
13	JVFrameworkHelperBlock->count()	JROOT/plugins/system/jvframework/framework/extensions/layout/layout.php:28
12	JVFrameworkExtensionLayout->beforeRender()	Chiamata uguale alla linea sottostante.
11	call_user_func_array()	JROOT/plugins/system/jvframework/framework/libraries/framework.php:326
10	JV::call()	JROOT/plugins/system/jvframework/framework/libraries/helpers/event.php:68
9	JVFrameworkHelperEvent->fireEvent()	JROOT/plugins/system/jvframework/framework/libraries/framework.php:95
8	JV->render()	JROOT/templates/jv-structure/component.php:25
7	require JROOT/templates/jv-structure/component.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1103
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.33 ms Dopo l'ultima query: 2.64 ms

SELECT menuid 
  FROM npcux_modules_menu 
  WHERE moduleid='324'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	npcux_modules_menu	ref	PRIMARY	PRIMARY	4	const	2	Using index

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
23	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jvframework/framework/extensions/module_assignment/module_assignment.php:188
21	JVFrameworkExtensionModule_assignment->getItemid()	JROOT/plugins/system/jvframework/framework/extensions/module_assignment/module_assignment.php:63
20	JVFrameworkExtensionModule_assignment->assigmentCheck()	JROOT/plugins/system/jvframework/framework/extensions/module_assignment/module_assignment.php:22
19	JVFrameworkExtensionModule_assignment->onGetModules()	Chiamata uguale alla linea sottostante.
18	call_user_func_array()	JROOT/plugins/system/jvframework/framework/libraries/framework.php:326
17	JV::call()	JROOT/plugins/system/jvframework/framework/libraries/helpers/event.php:68
16	JVFrameworkHelperEvent->fireEvent()	JROOT/plugins/system/jvframework/framework/libraries/helpers/position.php:165
15	JVFrameworkHelperPosition->getModules()	JROOT/plugins/system/jvframework/framework/libraries/helpers/position.php:105
14	JVFrameworkHelperPosition->count()	JROOT/plugins/system/jvframework/framework/libraries/helpers/block.php:62
13	JVFrameworkHelperBlock->count()	JROOT/plugins/system/jvframework/framework/extensions/layout/layout.php:28
12	JVFrameworkExtensionLayout->beforeRender()	Chiamata uguale alla linea sottostante.
11	call_user_func_array()	JROOT/plugins/system/jvframework/framework/libraries/framework.php:326
10	JV::call()	JROOT/plugins/system/jvframework/framework/libraries/helpers/event.php:68
9	JVFrameworkHelperEvent->fireEvent()	JROOT/plugins/system/jvframework/framework/libraries/framework.php:95
8	JV->render()	JROOT/templates/jv-structure/component.php:25
7	require JROOT/templates/jv-structure/component.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1103
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.27 ms Dopo l'ultima query: 0.61 ms

SELECT menuid 
  FROM npcux_modules_menu 
  WHERE moduleid='449'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	npcux_modules_menu	ref	PRIMARY	PRIMARY	4	const	2	Using index

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
23	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jvframework/framework/extensions/module_assignment/module_assignment.php:188
21	JVFrameworkExtensionModule_assignment->getItemid()	JROOT/plugins/system/jvframework/framework/extensions/module_assignment/module_assignment.php:63
20	JVFrameworkExtensionModule_assignment->assigmentCheck()	JROOT/plugins/system/jvframework/framework/extensions/module_assignment/module_assignment.php:22
19	JVFrameworkExtensionModule_assignment->onGetModules()	Chiamata uguale alla linea sottostante.
18	call_user_func_array()	JROOT/plugins/system/jvframework/framework/libraries/framework.php:326
17	JV::call()	JROOT/plugins/system/jvframework/framework/libraries/helpers/event.php:68
16	JVFrameworkHelperEvent->fireEvent()	JROOT/plugins/system/jvframework/framework/libraries/helpers/position.php:165
15	JVFrameworkHelperPosition->getModules()	JROOT/plugins/system/jvframework/framework/libraries/helpers/position.php:105
14	JVFrameworkHelperPosition->count()	JROOT/plugins/system/jvframework/framework/libraries/helpers/block.php:62
13	JVFrameworkHelperBlock->count()	JROOT/plugins/system/jvframework/framework/extensions/layout/layout.php:28
12	JVFrameworkExtensionLayout->beforeRender()	Chiamata uguale alla linea sottostante.
11	call_user_func_array()	JROOT/plugins/system/jvframework/framework/libraries/framework.php:326
10	JV::call()	JROOT/plugins/system/jvframework/framework/libraries/helpers/event.php:68
9	JVFrameworkHelperEvent->fireEvent()	JROOT/plugins/system/jvframework/framework/libraries/framework.php:95
8	JV->render()	JROOT/templates/jv-structure/component.php:25
7	require JROOT/templates/jv-structure/component.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1103
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.29 ms Dopo l'ultima query: 0.58 ms

SELECT menuid 
  FROM npcux_modules_menu 
  WHERE moduleid='361'

Explain

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

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
23	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jvframework/framework/extensions/module_assignment/module_assignment.php:188
21	JVFrameworkExtensionModule_assignment->getItemid()	JROOT/plugins/system/jvframework/framework/extensions/module_assignment/module_assignment.php:63
20	JVFrameworkExtensionModule_assignment->assigmentCheck()	JROOT/plugins/system/jvframework/framework/extensions/module_assignment/module_assignment.php:22
19	JVFrameworkExtensionModule_assignment->onGetModules()	Chiamata uguale alla linea sottostante.
18	call_user_func_array()	JROOT/plugins/system/jvframework/framework/libraries/framework.php:326
17	JV::call()	JROOT/plugins/system/jvframework/framework/libraries/helpers/event.php:68
16	JVFrameworkHelperEvent->fireEvent()	JROOT/plugins/system/jvframework/framework/libraries/helpers/position.php:165
15	JVFrameworkHelperPosition->getModules()	JROOT/plugins/system/jvframework/framework/libraries/helpers/position.php:105
14	JVFrameworkHelperPosition->count()	JROOT/plugins/system/jvframework/framework/libraries/helpers/block.php:62
13	JVFrameworkHelperBlock->count()	JROOT/plugins/system/jvframework/framework/extensions/layout/layout.php:28
12	JVFrameworkExtensionLayout->beforeRender()	Chiamata uguale alla linea sottostante.
11	call_user_func_array()	JROOT/plugins/system/jvframework/framework/libraries/framework.php:326
10	JV::call()	JROOT/plugins/system/jvframework/framework/libraries/helpers/event.php:68
9	JVFrameworkHelperEvent->fireEvent()	JROOT/plugins/system/jvframework/framework/libraries/framework.php:95
8	JV->render()	JROOT/templates/jv-structure/component.php:25
7	require JROOT/templates/jv-structure/component.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1103
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.24 ms Dopo l'ultima query: 0.48 ms

SELECT menuid 
  FROM npcux_modules_menu 
  WHERE moduleid='358'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	npcux_modules_menu	ref	PRIMARY	PRIMARY	4	const	6	Using index

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
23	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jvframework/framework/extensions/module_assignment/module_assignment.php:188
21	JVFrameworkExtensionModule_assignment->getItemid()	JROOT/plugins/system/jvframework/framework/extensions/module_assignment/module_assignment.php:63
20	JVFrameworkExtensionModule_assignment->assigmentCheck()	JROOT/plugins/system/jvframework/framework/extensions/module_assignment/module_assignment.php:22
19	JVFrameworkExtensionModule_assignment->onGetModules()	Chiamata uguale alla linea sottostante.
18	call_user_func_array()	JROOT/plugins/system/jvframework/framework/libraries/framework.php:326
17	JV::call()	JROOT/plugins/system/jvframework/framework/libraries/helpers/event.php:68
16	JVFrameworkHelperEvent->fireEvent()	JROOT/plugins/system/jvframework/framework/libraries/helpers/position.php:165
15	JVFrameworkHelperPosition->getModules()	JROOT/plugins/system/jvframework/framework/libraries/helpers/position.php:105
14	JVFrameworkHelperPosition->count()	JROOT/plugins/system/jvframework/framework/libraries/helpers/block.php:62
13	JVFrameworkHelperBlock->count()	JROOT/plugins/system/jvframework/framework/extensions/layout/layout.php:28
12	JVFrameworkExtensionLayout->beforeRender()	Chiamata uguale alla linea sottostante.
11	call_user_func_array()	JROOT/plugins/system/jvframework/framework/libraries/framework.php:326
10	JV::call()	JROOT/plugins/system/jvframework/framework/libraries/helpers/event.php:68
9	JVFrameworkHelperEvent->fireEvent()	JROOT/plugins/system/jvframework/framework/libraries/framework.php:95
8	JV->render()	JROOT/templates/jv-structure/component.php:25
7	require JROOT/templates/jv-structure/component.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1103
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.27 ms Dopo l'ultima query: 0.45 ms

SELECT menuid 
  FROM npcux_modules_menu 
  WHERE moduleid='438'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	npcux_modules_menu	ref	PRIMARY	PRIMARY	4	const	5	Using index

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
23	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jvframework/framework/extensions/module_assignment/module_assignment.php:188
21	JVFrameworkExtensionModule_assignment->getItemid()	JROOT/plugins/system/jvframework/framework/extensions/module_assignment/module_assignment.php:63
20	JVFrameworkExtensionModule_assignment->assigmentCheck()	JROOT/plugins/system/jvframework/framework/extensions/module_assignment/module_assignment.php:22
19	JVFrameworkExtensionModule_assignment->onGetModules()	Chiamata uguale alla linea sottostante.
18	call_user_func_array()	JROOT/plugins/system/jvframework/framework/libraries/framework.php:326
17	JV::call()	JROOT/plugins/system/jvframework/framework/libraries/helpers/event.php:68
16	JVFrameworkHelperEvent->fireEvent()	JROOT/plugins/system/jvframework/framework/libraries/helpers/position.php:165
15	JVFrameworkHelperPosition->getModules()	JROOT/plugins/system/jvframework/framework/libraries/helpers/position.php:105
14	JVFrameworkHelperPosition->count()	JROOT/plugins/system/jvframework/framework/libraries/helpers/block.php:62
13	JVFrameworkHelperBlock->count()	JROOT/plugins/system/jvframework/framework/extensions/layout/layout.php:28
12	JVFrameworkExtensionLayout->beforeRender()	Chiamata uguale alla linea sottostante.
11	call_user_func_array()	JROOT/plugins/system/jvframework/framework/libraries/framework.php:326
10	JV::call()	JROOT/plugins/system/jvframework/framework/libraries/helpers/event.php:68
9	JVFrameworkHelperEvent->fireEvent()	JROOT/plugins/system/jvframework/framework/libraries/framework.php:95
8	JV->render()	JROOT/templates/jv-structure/component.php:25
7	require JROOT/templates/jv-structure/component.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1103
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.32 ms Dopo l'ultima query: 0.51 ms

SELECT menuid 
  FROM npcux_modules_menu 
  WHERE moduleid='439'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	npcux_modules_menu	ref	PRIMARY	PRIMARY	4	const	10	Using index

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
23	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jvframework/framework/extensions/module_assignment/module_assignment.php:188
21	JVFrameworkExtensionModule_assignment->getItemid()	JROOT/plugins/system/jvframework/framework/extensions/module_assignment/module_assignment.php:63
20	JVFrameworkExtensionModule_assignment->assigmentCheck()	JROOT/plugins/system/jvframework/framework/extensions/module_assignment/module_assignment.php:22
19	JVFrameworkExtensionModule_assignment->onGetModules()	Chiamata uguale alla linea sottostante.
18	call_user_func_array()	JROOT/plugins/system/jvframework/framework/libraries/framework.php:326
17	JV::call()	JROOT/plugins/system/jvframework/framework/libraries/helpers/event.php:68
16	JVFrameworkHelperEvent->fireEvent()	JROOT/plugins/system/jvframework/framework/libraries/helpers/position.php:165
15	JVFrameworkHelperPosition->getModules()	JROOT/plugins/system/jvframework/framework/libraries/helpers/position.php:105
14	JVFrameworkHelperPosition->count()	JROOT/plugins/system/jvframework/framework/libraries/helpers/block.php:62
13	JVFrameworkHelperBlock->count()	JROOT/plugins/system/jvframework/framework/extensions/layout/layout.php:28
12	JVFrameworkExtensionLayout->beforeRender()	Chiamata uguale alla linea sottostante.
11	call_user_func_array()	JROOT/plugins/system/jvframework/framework/libraries/framework.php:326
10	JV::call()	JROOT/plugins/system/jvframework/framework/libraries/helpers/event.php:68
9	JVFrameworkHelperEvent->fireEvent()	JROOT/plugins/system/jvframework/framework/libraries/framework.php:95
8	JV->render()	JROOT/templates/jv-structure/component.php:25
7	require JROOT/templates/jv-structure/component.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1103
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.29 ms Dopo l'ultima query: 0.54 ms

SELECT menuid 
  FROM npcux_modules_menu 
  WHERE moduleid='359'

Explain

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

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
23	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jvframework/framework/extensions/module_assignment/module_assignment.php:188
21	JVFrameworkExtensionModule_assignment->getItemid()	JROOT/plugins/system/jvframework/framework/extensions/module_assignment/module_assignment.php:63
20	JVFrameworkExtensionModule_assignment->assigmentCheck()	JROOT/plugins/system/jvframework/framework/extensions/module_assignment/module_assignment.php:22
19	JVFrameworkExtensionModule_assignment->onGetModules()	Chiamata uguale alla linea sottostante.
18	call_user_func_array()	JROOT/plugins/system/jvframework/framework/libraries/framework.php:326
17	JV::call()	JROOT/plugins/system/jvframework/framework/libraries/helpers/event.php:68
16	JVFrameworkHelperEvent->fireEvent()	JROOT/plugins/system/jvframework/framework/libraries/helpers/position.php:165
15	JVFrameworkHelperPosition->getModules()	JROOT/plugins/system/jvframework/framework/libraries/helpers/position.php:105
14	JVFrameworkHelperPosition->count()	JROOT/plugins/system/jvframework/framework/libraries/helpers/block.php:62
13	JVFrameworkHelperBlock->count()	JROOT/plugins/system/jvframework/framework/extensions/layout/layout.php:28
12	JVFrameworkExtensionLayout->beforeRender()	Chiamata uguale alla linea sottostante.
11	call_user_func_array()	JROOT/plugins/system/jvframework/framework/libraries/framework.php:326
10	JV::call()	JROOT/plugins/system/jvframework/framework/libraries/helpers/event.php:68
9	JVFrameworkHelperEvent->fireEvent()	JROOT/plugins/system/jvframework/framework/libraries/framework.php:95
8	JV->render()	JROOT/templates/jv-structure/component.php:25
7	require JROOT/templates/jv-structure/component.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1103
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.19 ms Dopo l'ultima query: 0.40 ms

SELECT menuid 
  FROM npcux_modules_menu 
  WHERE moduleid='441'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	npcux_modules_menu	ref	PRIMARY	PRIMARY	4	const	5	Using index

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
23	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jvframework/framework/extensions/module_assignment/module_assignment.php:188
21	JVFrameworkExtensionModule_assignment->getItemid()	JROOT/plugins/system/jvframework/framework/extensions/module_assignment/module_assignment.php:63
20	JVFrameworkExtensionModule_assignment->assigmentCheck()	JROOT/plugins/system/jvframework/framework/extensions/module_assignment/module_assignment.php:22
19	JVFrameworkExtensionModule_assignment->onGetModules()	Chiamata uguale alla linea sottostante.
18	call_user_func_array()	JROOT/plugins/system/jvframework/framework/libraries/framework.php:326
17	JV::call()	JROOT/plugins/system/jvframework/framework/libraries/helpers/event.php:68
16	JVFrameworkHelperEvent->fireEvent()	JROOT/plugins/system/jvframework/framework/libraries/helpers/position.php:165
15	JVFrameworkHelperPosition->getModules()	JROOT/plugins/system/jvframework/framework/libraries/helpers/position.php:105
14	JVFrameworkHelperPosition->count()	JROOT/plugins/system/jvframework/framework/libraries/helpers/block.php:62
13	JVFrameworkHelperBlock->count()	JROOT/plugins/system/jvframework/framework/extensions/layout/layout.php:28
12	JVFrameworkExtensionLayout->beforeRender()	Chiamata uguale alla linea sottostante.
11	call_user_func_array()	JROOT/plugins/system/jvframework/framework/libraries/framework.php:326
10	JV::call()	JROOT/plugins/system/jvframework/framework/libraries/helpers/event.php:68
9	JVFrameworkHelperEvent->fireEvent()	JROOT/plugins/system/jvframework/framework/libraries/framework.php:95
8	JV->render()	JROOT/templates/jv-structure/component.php:25
7	require JROOT/templates/jv-structure/component.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1103
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.28 ms Dopo l'ultima query: 0.50 ms

SELECT menuid 
  FROM npcux_modules_menu 
  WHERE moduleid='442'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	npcux_modules_menu	ref	PRIMARY	PRIMARY	4	const	5	Using index

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
23	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jvframework/framework/extensions/module_assignment/module_assignment.php:188
21	JVFrameworkExtensionModule_assignment->getItemid()	JROOT/plugins/system/jvframework/framework/extensions/module_assignment/module_assignment.php:63
20	JVFrameworkExtensionModule_assignment->assigmentCheck()	JROOT/plugins/system/jvframework/framework/extensions/module_assignment/module_assignment.php:22
19	JVFrameworkExtensionModule_assignment->onGetModules()	Chiamata uguale alla linea sottostante.
18	call_user_func_array()	JROOT/plugins/system/jvframework/framework/libraries/framework.php:326
17	JV::call()	JROOT/plugins/system/jvframework/framework/libraries/helpers/event.php:68
16	JVFrameworkHelperEvent->fireEvent()	JROOT/plugins/system/jvframework/framework/libraries/helpers/position.php:165
15	JVFrameworkHelperPosition->getModules()	JROOT/plugins/system/jvframework/framework/libraries/helpers/position.php:105
14	JVFrameworkHelperPosition->count()	JROOT/plugins/system/jvframework/framework/libraries/helpers/block.php:62
13	JVFrameworkHelperBlock->count()	JROOT/plugins/system/jvframework/framework/extensions/layout/layout.php:28
12	JVFrameworkExtensionLayout->beforeRender()	Chiamata uguale alla linea sottostante.
11	call_user_func_array()	JROOT/plugins/system/jvframework/framework/libraries/framework.php:326
10	JV::call()	JROOT/plugins/system/jvframework/framework/libraries/helpers/event.php:68
9	JVFrameworkHelperEvent->fireEvent()	JROOT/plugins/system/jvframework/framework/libraries/framework.php:95
8	JV->render()	JROOT/templates/jv-structure/component.php:25
7	require JROOT/templates/jv-structure/component.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1103
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.26 ms Dopo l'ultima query: 0.49 ms

SELECT menuid 
  FROM npcux_modules_menu 
  WHERE moduleid='323'

Explain

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

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
23	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jvframework/framework/extensions/module_assignment/module_assignment.php:188
21	JVFrameworkExtensionModule_assignment->getItemid()	JROOT/plugins/system/jvframework/framework/extensions/module_assignment/module_assignment.php:63
20	JVFrameworkExtensionModule_assignment->assigmentCheck()	JROOT/plugins/system/jvframework/framework/extensions/module_assignment/module_assignment.php:22
19	JVFrameworkExtensionModule_assignment->onGetModules()	Chiamata uguale alla linea sottostante.
18	call_user_func_array()	JROOT/plugins/system/jvframework/framework/libraries/framework.php:326
17	JV::call()	JROOT/plugins/system/jvframework/framework/libraries/helpers/event.php:68
16	JVFrameworkHelperEvent->fireEvent()	JROOT/plugins/system/jvframework/framework/libraries/helpers/position.php:165
15	JVFrameworkHelperPosition->getModules()	JROOT/plugins/system/jvframework/framework/libraries/helpers/position.php:105
14	JVFrameworkHelperPosition->count()	JROOT/plugins/system/jvframework/framework/libraries/helpers/block.php:62
13	JVFrameworkHelperBlock->count()	JROOT/plugins/system/jvframework/framework/extensions/layout/layout.php:28
12	JVFrameworkExtensionLayout->beforeRender()	Chiamata uguale alla linea sottostante.
11	call_user_func_array()	JROOT/plugins/system/jvframework/framework/libraries/framework.php:326
10	JV::call()	JROOT/plugins/system/jvframework/framework/libraries/helpers/event.php:68
9	JVFrameworkHelperEvent->fireEvent()	JROOT/plugins/system/jvframework/framework/libraries/framework.php:95
8	JV->render()	JROOT/templates/jv-structure/component.php:25
7	require JROOT/templates/jv-structure/component.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1103
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.25 ms Dopo l'ultima query: 0.32 ms

SELECT menuid 
  FROM npcux_modules_menu 
  WHERE moduleid='332'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	npcux_modules_menu	ref	PRIMARY	PRIMARY	4	const	2	Using index

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
23	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jvframework/framework/extensions/module_assignment/module_assignment.php:188
21	JVFrameworkExtensionModule_assignment->getItemid()	JROOT/plugins/system/jvframework/framework/extensions/module_assignment/module_assignment.php:63
20	JVFrameworkExtensionModule_assignment->assigmentCheck()	JROOT/plugins/system/jvframework/framework/extensions/module_assignment/module_assignment.php:22
19	JVFrameworkExtensionModule_assignment->onGetModules()	Chiamata uguale alla linea sottostante.
18	call_user_func_array()	JROOT/plugins/system/jvframework/framework/libraries/framework.php:326
17	JV::call()	JROOT/plugins/system/jvframework/framework/libraries/helpers/event.php:68
16	JVFrameworkHelperEvent->fireEvent()	JROOT/plugins/system/jvframework/framework/libraries/helpers/position.php:165
15	JVFrameworkHelperPosition->getModules()	JROOT/plugins/system/jvframework/framework/libraries/helpers/position.php:105
14	JVFrameworkHelperPosition->count()	JROOT/plugins/system/jvframework/framework/libraries/helpers/block.php:62
13	JVFrameworkHelperBlock->count()	JROOT/plugins/system/jvframework/framework/extensions/layout/layout.php:28
12	JVFrameworkExtensionLayout->beforeRender()	Chiamata uguale alla linea sottostante.
11	call_user_func_array()	JROOT/plugins/system/jvframework/framework/libraries/framework.php:326
10	JV::call()	JROOT/plugins/system/jvframework/framework/libraries/helpers/event.php:68
9	JVFrameworkHelperEvent->fireEvent()	JROOT/plugins/system/jvframework/framework/libraries/framework.php:95
8	JV->render()	JROOT/templates/jv-structure/component.php:25
7	require JROOT/templates/jv-structure/component.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1103
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.30 ms Dopo l'ultima query: 0.31 ms

SELECT menuid 
  FROM npcux_modules_menu 
  WHERE moduleid='432'

Explain

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

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
23	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jvframework/framework/extensions/module_assignment/module_assignment.php:188
21	JVFrameworkExtensionModule_assignment->getItemid()	JROOT/plugins/system/jvframework/framework/extensions/module_assignment/module_assignment.php:63
20	JVFrameworkExtensionModule_assignment->assigmentCheck()	JROOT/plugins/system/jvframework/framework/extensions/module_assignment/module_assignment.php:22
19	JVFrameworkExtensionModule_assignment->onGetModules()	Chiamata uguale alla linea sottostante.
18	call_user_func_array()	JROOT/plugins/system/jvframework/framework/libraries/framework.php:326
17	JV::call()	JROOT/plugins/system/jvframework/framework/libraries/helpers/event.php:68
16	JVFrameworkHelperEvent->fireEvent()	JROOT/plugins/system/jvframework/framework/libraries/helpers/position.php:165
15	JVFrameworkHelperPosition->getModules()	JROOT/plugins/system/jvframework/framework/libraries/helpers/position.php:105
14	JVFrameworkHelperPosition->count()	JROOT/plugins/system/jvframework/framework/libraries/helpers/block.php:62
13	JVFrameworkHelperBlock->count()	JROOT/plugins/system/jvframework/framework/extensions/layout/layout.php:28
12	JVFrameworkExtensionLayout->beforeRender()	Chiamata uguale alla linea sottostante.
11	call_user_func_array()	JROOT/plugins/system/jvframework/framework/libraries/framework.php:326
10	JV::call()	JROOT/plugins/system/jvframework/framework/libraries/helpers/event.php:68
9	JVFrameworkHelperEvent->fireEvent()	JROOT/plugins/system/jvframework/framework/libraries/framework.php:95
8	JV->render()	JROOT/templates/jv-structure/component.php:25
7	require JROOT/templates/jv-structure/component.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1103
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.22 ms Dopo l'ultima query: 0.50 ms

SELECT menuid 
  FROM npcux_modules_menu 
  WHERE moduleid='326'

Explain

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

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
23	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jvframework/framework/extensions/module_assignment/module_assignment.php:188
21	JVFrameworkExtensionModule_assignment->getItemid()	JROOT/plugins/system/jvframework/framework/extensions/module_assignment/module_assignment.php:63
20	JVFrameworkExtensionModule_assignment->assigmentCheck()	JROOT/plugins/system/jvframework/framework/extensions/module_assignment/module_assignment.php:22
19	JVFrameworkExtensionModule_assignment->onGetModules()	Chiamata uguale alla linea sottostante.
18	call_user_func_array()	JROOT/plugins/system/jvframework/framework/libraries/framework.php:326
17	JV::call()	JROOT/plugins/system/jvframework/framework/libraries/helpers/event.php:68
16	JVFrameworkHelperEvent->fireEvent()	JROOT/plugins/system/jvframework/framework/libraries/helpers/position.php:165
15	JVFrameworkHelperPosition->getModules()	JROOT/plugins/system/jvframework/framework/libraries/helpers/position.php:105
14	JVFrameworkHelperPosition->count()	JROOT/plugins/system/jvframework/framework/libraries/helpers/block.php:62
13	JVFrameworkHelperBlock->count()	JROOT/plugins/system/jvframework/framework/extensions/layout/layout.php:28
12	JVFrameworkExtensionLayout->beforeRender()	Chiamata uguale alla linea sottostante.
11	call_user_func_array()	JROOT/plugins/system/jvframework/framework/libraries/framework.php:326
10	JV::call()	JROOT/plugins/system/jvframework/framework/libraries/helpers/event.php:68
9	JVFrameworkHelperEvent->fireEvent()	JROOT/plugins/system/jvframework/framework/libraries/framework.php:95
8	JV->render()	JROOT/templates/jv-structure/component.php:25
7	require JROOT/templates/jv-structure/component.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1103
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.22 ms Dopo l'ultima query: 0.74 ms

SELECT menuid 
  FROM npcux_modules_menu 
  WHERE moduleid='424'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	npcux_modules_menu	ref	PRIMARY	PRIMARY	4	const	7	Using index

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
23	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jvframework/framework/extensions/module_assignment/module_assignment.php:188
21	JVFrameworkExtensionModule_assignment->getItemid()	JROOT/plugins/system/jvframework/framework/extensions/module_assignment/module_assignment.php:63
20	JVFrameworkExtensionModule_assignment->assigmentCheck()	JROOT/plugins/system/jvframework/framework/extensions/module_assignment/module_assignment.php:22
19	JVFrameworkExtensionModule_assignment->onGetModules()	Chiamata uguale alla linea sottostante.
18	call_user_func_array()	JROOT/plugins/system/jvframework/framework/libraries/framework.php:326
17	JV::call()	JROOT/plugins/system/jvframework/framework/libraries/helpers/event.php:68
16	JVFrameworkHelperEvent->fireEvent()	JROOT/plugins/system/jvframework/framework/libraries/helpers/position.php:165
15	JVFrameworkHelperPosition->getModules()	JROOT/plugins/system/jvframework/framework/libraries/helpers/position.php:105
14	JVFrameworkHelperPosition->count()	JROOT/plugins/system/jvframework/framework/libraries/helpers/block.php:62
13	JVFrameworkHelperBlock->count()	JROOT/plugins/system/jvframework/framework/extensions/layout/layout.php:29
12	JVFrameworkExtensionLayout->beforeRender()	Chiamata uguale alla linea sottostante.
11	call_user_func_array()	JROOT/plugins/system/jvframework/framework/libraries/framework.php:326
10	JV::call()	JROOT/plugins/system/jvframework/framework/libraries/helpers/event.php:68
9	JVFrameworkHelperEvent->fireEvent()	JROOT/plugins/system/jvframework/framework/libraries/framework.php:95
8	JV->render()	JROOT/templates/jv-structure/component.php:25
7	require JROOT/templates/jv-structure/component.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1103
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

30 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

14 × SELECT menuid 
  FROM npcux_modules_menu

5 × SELECT COUNT(*) 
  FROM npcux_k2_comments

4 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state 
  FROM npcux_fields AS a 
  LEFT JOIN `npcux_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN npcux_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN npcux_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN npcux_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN npcux_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `npcux_fields_categories` AS fc 
  ON fc.field_id = a.id

```
3 × SELECT * 
  FROM npcux_k2_items
```

2 × SELECT i.*, c.alias as categoryalias 
  FROM npcux_k2_items as i     
  LEFT JOIN npcux_k2_categories c 
  ON c.id = i.catid

```
1 × SELECT * 
  FROM `npcux_users`
```
```
1 × SELECT * 
  FROM npcux_k2_rating
```

1 × SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM npcux_k2_users

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM npcux_modules AS m 
  LEFT JOIN npcux_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN npcux_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT * 
  FROM npcux_k2_attachments

```
1 × SELECT * 
  FROM npcux_jv_typos
```

1 × SELECT DISTINCT itemID 
  FROM npcux_k2_tags_xref

1 × SELECT id, name,  parent 
  FROM npcux_k2_categories

1 × SELECT `lastupdate` 
  FROM `npcux_ak_storage`

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

1 × SELECT id, rules 
  FROM `npcux_viewlevels

1 × SELECT `session_id` 
  FROM `npcux_session`

```
1 × SELECT id 
  FROM npcux_k2_items
```

1 × SELECT * 
  FROM npcux_acymailing_confi

1 × SELECT `data` 
  FROM `npcux_session`

1 × SELECT * 
  FROM npcux_k2_categories

1 × SELECT id 
  FROM npcux_k2_categories

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

1 × SELECT tag.*    
  FROM npcux_k2_tags AS tag    JOIN npcux_k2_tags_xref AS xref 
  ON tag.id = xref.tagID

ALTRE tabelle:

1 × SHOW FULL COLUMNS 
  FROM `npcux_k2_items

1 × UPDATE npcux_k2_items 
  SET `hits` = (`hits` + 1)

1 × SHOW FULL COLUMNS 
  FROM `npcux_users

1 × SHOW FULL COLUMNS 
  FROM `npcux_k2_categories

1 × UPDATE `npcux_extensions` 
  SET `params` = '{\"mediaversion\":\"98bd5f1d4be7c3527592c3140a241e04\"}'

1 × INSERT INTO `npcux_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('atl4bav8m24mr05h8a7ia72qs5', 1, '1713608882', 0, '', 0

Attenzione

Seo for eCommerce sites- where to start?

Latest from

Related items

Console Debug Joomla!

Sessione

Informazioni profilo

Tempo

Memoria

Utilizzo memoria

Query Database

53 query eseguite 41.37 ms

30 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

ALTRE tabelle: