Statistiche

{
    "__default": {
        "session": {
            "counter": 2,
            "timer": {
                "start": 1746076294,
                "last": 1746076294,
                "now": 1746076303
            },
            "token": "fY7qNf8MXLqWqnR8zYhSmOdpEMqpfCDr"
        },
        "registry": {
            "com_kunena": {
                "user0_read": {
                    "2": 2,
                    "54": 54,
                    "36": 36,
                    "24": 24,
                    "1": 1,
                    "14": 14,
                    "12": 12,
                    "73": 73,
                    "30": 30,
                    "32": 32,
                    "8": 8,
                    "60": 60,
                    "10": 10,
                    "59": 59,
                    "5": 5,
                    "74": 74,
                    "17": 17,
                    "13": 13,
                    "50": 50,
                    "28": 28,
                    "22": 22,
                    "6": 6,
                    "76": 76,
                    "33": 33,
                    "18": 18,
                    "7": 7,
                    "25": 25,
                    "51": 51,
                    "31": 31,
                    "9": 9,
                    "19": 19,
                    "11": 11,
                    "52": 52,
                    "61": 61,
                    "4": 4,
                    "35": 35,
                    "44": 44,
                    "53": 53,
                    "67": 67,
                    "49": 49,
                    "65": 65,
                    "75": 75,
                    "39": 39,
                    "66": 66,
                    "16": 16,
                    "64": 64,
                    "29": 29
                }
            }
        },
        "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
        }
    }
}

Tempo

Memoria

44 query eseguite 145.48 ms

1. Tempo della query: 0.52 ms Memoria query: 0.023 MB memoria prima della query: 1.016 MB Righe restituite: 1

   SELECT `data`
   
     FROM `jos3_session`
   
     WHERE `session_id` = 'db33urlu0n6npe4f62ubv5cmad'

   Explain

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

   Profilo

   Status	Duration
   Starting	0.06 ms
   checking permissions	0.01 ms
   Opening tables	0.04 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.05 ms
   Optimizing	0.02 ms
   Statistics	0.10 ms
   Preparing	0.00 ms
   Unlocking tables	0.01 ms
   Preparing	0.02 ms
   Executing	0.01 ms
   Sending data	0.01 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Query end	0.01 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.03 ms
   Reset for next command	0.00 ms

   Call Stack

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

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

   ---

2. Tempo della query: 0.70 ms Dopo l'ultima query: 1.12 ms Memoria query: 0.024 MB memoria prima della query: 1.061 MB Righe restituite: 37

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `jos3_extensions`
   
     WHERE `type` = 'component' 
     AND `state` = 0 
     AND `enabled` = 1

   Explain

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

   Profilo

   Status	Duration
   Starting	0.07 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.03 ms
   Optimizing	0.03 ms
   Statistics	0.09 ms
   Preparing	0.03 ms
   Executing	0.00 ms
   Sending data	0.17 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.01 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.05 ms
   Reset for next command	0.00 ms

   Call Stack

   #	Caller	File e numero di linea
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
   11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
   10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Chiamata uguale alla linea sottostante.
   9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
   7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
   6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
   5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
   4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

3. Tempo della query: 0.32 ms Dopo l'ultima query: 0.78 ms Memoria query: 0.021 MB memoria prima della query: 1.087 MB Righe restituite: 10

   SELECT id, rules
   
     FROM `jos3_viewlevels`

   Explain

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

   Profilo

   Status	Duration
   Starting	0.02 ms
   checking permissions	0.01 ms
   Opening tables	0.04 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.00 ms
   init	0.03 ms
   Optimizing	0.01 ms
   Statistics	0.01 ms
   Preparing	0.01 ms
   Executing	0.00 ms
   Sending data	0.04 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.00 ms
   Query end	0.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.00 ms
   Updating status	0.01 ms
   Reset for next command	0.00 ms

   Call Stack

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

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

   ---

4. Tempo della query: 0.45 ms Dopo l'ultima query: 0.18 ms Memoria query: 0.021 MB memoria prima della query: 1.101 MB Righe restituite: 1

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

   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	1	Using where; Using index

   Profilo

   Status	Duration
   Starting	0.04 ms
   checking permissions	0.00 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.00 ms
   table lock	0.01 ms
   init	0.02 ms
   Optimizing	0.02 ms
   Statistics	0.08 ms
   Preparing	0.00 ms
   Unlocking tables	0.00 ms
   Preparing	0.03 ms
   Executing	0.00 ms
   Sending data	0.03 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.01 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.02 ms
   Query end	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.02 ms
   Reset for next command	0.00 ms

   Call Stack

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

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

   ---

5. Tempo della query: 0.93 ms Dopo l'ultima query: 0.25 ms Memoria query: 0.030 MB memoria prima della query: 1.123 MB Righe restituite: 103

   SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   
     FROM jos3_extensions
   
     WHERE enabled = 1 
     AND type = 'plugin' 
     AND state IN (0,1) 
     AND access IN (1,1)
   
     ORDER BY ordering

   Explain

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

   Profilo

   Status	Duration
   Starting	0.06 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.00 ms
   table lock	0.01 ms
   init	0.03 ms
   Optimizing	0.03 ms
   Statistics	0.04 ms
   Preparing	0.02 ms
   Sorting result	0.01 ms
   Executing	0.01 ms
   Sending data	0.01 ms
   Creating sort index	0.50 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.00 ms
   Query end	0.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.03 ms
   Reset for next command	0.00 ms

   Call Stack

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

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

   ---

6. Tempo della query: 1.13 ms Dopo l'ultima query: 4.40 ms Memoria query: 0.112 MB memoria prima della query: 1.614 MB Righe restituite: 68
   Query duplicate: #41

   SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
   
     FROM jos3_menu AS m
   
     LEFT JOIN jos3_extensions AS e 
     ON m.component_id = e.extension_id
   
     WHERE m.published = 1 
     AND m.parent_id > 0 
     AND m.client_id = 0
   
     ORDER BY m.lft

   Explain

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

   Profilo

   Status	Duration
   Starting	0.10 ms
   checking permissions	0.01 ms
   Opening tables	0.04 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.04 ms
   Optimizing	0.03 ms
   Statistics	0.07 ms
   Preparing	0.03 ms
   Sorting result	0.01 ms
   Executing	0.00 ms
   Sending data	0.02 ms
   Creating sort index	0.62 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.00 ms
   Query end	0.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.01 ms
   Reset for next command	0.00 ms

   Call Stack

   #	Caller	File e numero di linea
   22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
   21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
   20	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Chiamata uguale alla linea sottostante.
   19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
   17	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
   16	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
   15	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
   14	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
   13	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
   12	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
   11	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
   10	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
   9	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
   8	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/wbamp/wbamp.php:210
   7	plgSystemWbamp->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

7. Tempo della query: 7.23 ms Dopo l'ultima query: 21.58 ms Memoria query: 0.025 MB memoria prima della query: 2.240 MB Righe restituite: 1

   SELECT *
   
     FROM `jos3_kunena_configuration`
   
     WHERE `id`=1

   Explain

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

   Profilo

   Status	Duration
   Starting	0.10 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   After opening tables	0.01 ms
   System lock	0.00 ms
   table lock	0.01 ms
   init	0.03 ms
   Optimizing	0.02 ms
   Statistics	0.07 ms
   Preparing	0.00 ms
   Unlocking tables	0.01 ms
   Preparing	0.02 ms
   Executing	0.00 ms
   Sending data	0.03 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Query end	0.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.03 ms
   Reset for next command	0.00 ms

   Call Stack

   #	Caller	File e numero di linea
   20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
   19	JDatabaseDriver->loadAssoc()	JROOT/libraries/kunena/config.php:1393
   18	KunenaConfig->load()	JROOT/libraries/kunena/config.php:1366
   17	KunenaConfig::getInstance()	JROOT/libraries/kunena/factory.php:237
   16	KunenaFactory::getConfig()	JROOT/libraries/kunena/route/route.php:967
   15	KunenaRoute::initialize()	JROOT/libraries/kunena/route/route.php:21
   14	include_once JROOT/libraries/kunena/route/route.php	JROOT/libraries/loader.php:759
   13	JLoader::_load()	JROOT/libraries/loader.php:707
   12	JLoader::_autoload()	Chiamata uguale alla linea sottostante.
   11	spl_autoload_call()	JROOT/components/com_kunena/router.php:301
   10	KunenaParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
   9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
   8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
   7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
   6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
   5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
   4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
   3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

8. Tempo della query: 0.74 ms Dopo l'ultima query: 1.80 ms Memoria query: 0.022 MB memoria prima della query: 2.335 MB Righe restituite: 1

   SELECT * 
     FROM jos3_kunena_aliases 
     WHERE alias LIKE 'statistics%'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	jos3_kunena_aliases	range	alias	alias	767	NULL	1	Using where

   Profilo

   Status	Duration
   Starting	0.11 ms
   checking permissions	0.01 ms
   Opening tables	0.08 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.04 ms
   Optimizing	0.02 ms
   Statistics	0.09 ms
   Preparing	0.03 ms
   Executing	0.00 ms
   Sending data	0.07 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.00 ms
   Query end	0.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.03 ms
   Reset for next command	0.00 ms

   Call Stack

   #	Caller	File e numero di linea
   13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
   12	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/route/route.php:934
   11	KunenaRoute::resolveAlias()	JROOT/components/com_kunena/router.php:316
   10	KunenaParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
   9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
   8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
   7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
   6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
   5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
   4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
   3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

9. Tempo della query: 0.48 ms Dopo l'ultima query: 0.35 ms Memoria query: 0.025 MB memoria prima della query: 2.362 MB Righe restituite: 1

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `jos3_extensions`
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explain

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

   Profilo

   Status	Duration
   Starting	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.00 ms
   init	0.03 ms
   Optimizing	0.02 ms
   Statistics	0.12 ms
   Preparing	0.02 ms
   Executing	0.00 ms
   Sending data	0.06 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Query end	0.00 ms
   closing tables	0.01 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Query end	0.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.02 ms
   Reset for next command	0.00 ms

   Call Stack

   #	Caller	File e numero di linea
   19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
   18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
   17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Chiamata uguale alla linea sottostante.
   16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
   14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
   13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
   12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
   11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
   10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
   9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/wbamp/wbamp.php:404
   8	plgSystemWbamp->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
   4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
   3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

10. Tempo della query: 1.23 ms Dopo l'ultima query: 0.17 ms Memoria query: 0.006 MB memoria prima della query: 2.355 MB

    UPDATE `jos3_extensions`
    
      SET `params` = '{\"mediaversion\":\"90967fdce10f4094756540b9f4d4c0bd\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

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

    Profilo

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init for update	0.10 ms
    Updating	0.10 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.71 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.05 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.11 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/wbamp/wbamp.php:404
    8	plgSystemWbamp->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

11. Tempo della query: 15.29 ms Dopo l'ultima query: 0.80 ms Memoria query: 0.019 MB memoria prima della query: 2.393 MB Righe restituite: 2

    SELECT *
    
      FROM jos3_languages
    
      WHERE published=1
    
      ORDER BY ordering ASC

    Explain

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

    Profilo

    Status	Duration
    Starting	0.08 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	5.17 ms
    Optimizing	0.08 ms
    Statistics	0.08 ms
    Preparing	0.06 ms
    Sorting result	0.02 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    Creating sort index	0.29 ms
    End of update loop	0.01 ms
    Query end	0.02 ms
    Commit	0.01 ms
    Query end	1.45 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	7.57 ms
    Query end	0.02 ms
    Starting cleanup	0.00 ms
    Freeing items	0.03 ms
    Updating status	0.06 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
    5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
    4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

12. Tempo della query: 0.96 ms Dopo l'ultima query: 0.80 ms Memoria query: 0.019 MB memoria prima della query: 2.403 MB Righe restituite: 1

    SELECT id, home, template, s.params
    
      FROM jos3_template_styles as s
    
      LEFT JOIN jos3_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id
    
      WHERE s.client_id = 0 
      AND e.enabled = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	3	Using index condition; Using where
    1	SIMPLE	s	ALL	idx_template	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	3	Using where; Using join buffer (flat, BNL join)

    Profilo

    Status	Duration
    Starting	0.27 ms
    checking permissions	0.01 ms
    Opening tables	0.06 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.02 ms
    init	0.05 ms
    Optimizing	0.05 ms
    Statistics	0.13 ms
    Preparing	0.06 ms
    Executing	0.00 ms
    Sending data	0.10 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
    4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

13. Tempo della query: 1.43 ms Dopo l'ultima query: 6.16 ms Memoria query: 0.025 MB memoria prima della query: 2.813 MB Righe restituite: 5

    SHOW FULL COLUMNS 
      FROM `jos3_kunena_sessions`

    Explain

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

    Profilo

    Status	Duration
    Starting	0.10 ms
    checking permissions	0.01 ms
    closing tables	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.50 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Filling schema table	0.01 ms
    Opening tables	0.07 ms
    After opening tables	0.01 ms
    checking permissions	0.25 ms
    closing tables	0.03 ms
    checking permissions	0.01 ms
    Executing	0.00 ms
    Sending data	0.06 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Removing tmp table	0.13 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    15	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    14	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/kunena/tables/kunenasessions.php:75
    13	TableKunenaSessions->__construct()	JROOT/libraries/src/Table/Table.php:312
    12	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/kunena/session.php:128
    11	KunenaSession->getTable()	JROOT/libraries/kunena/session.php:86
    10	KunenaSession->load()	JROOT/libraries/kunena/session.php:52
    9	KunenaSession->__construct()	JROOT/libraries/kunena/session.php:144
    8	KunenaSession::getInstance()	JROOT/libraries/kunena/factory.php:101
    7	KunenaFactory::getSession()	JROOT/components/com_kunena/kunena.php:61
    6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

14. Tempo della query: 1.44 ms Dopo l'ultima query: 20.85 ms Memoria query: 0.035 MB memoria prima della query: 3.693 MB Righe restituite: 51

    SHOW FULL COLUMNS 
      FROM `jos3_kunena_users`

    Explain

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

    Profilo

    Status	Duration
    Starting	0.08 ms
    checking permissions	0.02 ms
    closing tables	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.34 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.05 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Filling schema table	0.01 ms
    Opening tables	0.10 ms
    After opening tables	0.00 ms
    checking permissions	0.24 ms
    closing tables	0.01 ms
    checking permissions	0.01 ms
    Executing	0.00 ms
    Sending data	0.12 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Removing tmp table	0.13 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    20	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    19	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/kunena/tables/kunenausers.php:445
    18	TableKunenaUsers->__construct()	JROOT/libraries/src/Table/Table.php:312
    17	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/kunena/user/user.php:230
    16	KunenaUser->getTable()	JROOT/libraries/kunena/user/user.php:189
    15	KunenaUser->load()	JROOT/libraries/kunena/user/user.php:164
    14	KunenaUser->__construct()	JROOT/libraries/kunena/user/helper.php:91
    13	KunenaUserHelper::initialize()	JROOT/libraries/kunena/user/helper.php:13
    12	include_once JROOT/libraries/kunena/user/helper.php	JROOT/libraries/loader.php:738
    11	JLoader::_load()	JROOT/libraries/loader.php:707
    10	JLoader::_autoload()	Chiamata uguale alla linea sottostante.
    9	spl_autoload_call()	JROOT/libraries/kunena/controller/application/display.php:237
    8	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:76
    7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
    6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

15. Tempo della query: 6.52 ms Dopo l'ultima query: 10.94 ms Memoria query: 0.028 MB memoria prima della query: 4.494 MB Righe restituite: 37

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `jos3_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','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_jce','com_joomlaupdate','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_uddeim','com_users','com_wrapper')

    Explain

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

    Profilo

    Status	Duration
    Starting	0.17 ms
    checking permissions	0.03 ms
    Opening tables	0.05 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.08 ms
    Optimizing	0.03 ms
    Statistics	0.20 ms
    Preparing	0.04 ms
    Executing	0.00 ms
    Sending data	0.53 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Query end	0.00 ms
    closing tables	0.03 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    17	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    16	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    15	Joomla\CMS\Access\Access::getAssetRules()	JROOT/plugins/kunena/joomla/access.php:461
    14	KunenaAccessJoomla->getAuthorisedUsers()	JROOT/plugins/kunena/joomla/access.php:233
    13	KunenaAccessJoomla->loadCategoryRoles()	JROOT/libraries/kunena/access.php:151
    12	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:123
    11	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:237
    10	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:384
    9	KunenaUser->isAdmin()	JROOT/libraries/kunena/controller/application/display.php:243
    8	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:76
    7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
    6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

16. Tempo della query: 3.06 ms Dopo l'ultima query: 0.47 ms Memoria query: 0.024 MB memoria prima della query: 4.559 MB Righe restituite: 2

    SELECT DISTINCT(user_id)
    
      FROM jos3_usergroups as ug1
    
      INNER JOIN jos3_usergroups AS ug2 
      ON ug2.lft>=ug1.lft 
      AND ug1.rgt>=ug2.rgt
    
      INNER JOIN jos3_user_usergroup_map AS m 
      ON ug2.id=m.group_id
    
      WHERE ug1.id IN (8)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	ug1	const	PRIMARY,idx_usergroup_nested_set_lookup	PRIMARY	4	const	1	Using temporary
    1	SIMPLE	ug2	range	PRIMARY,idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	1	Using where; Using index
    1	SIMPLE	m	index	NULL	PRIMARY	8	NULL	3252	Using where; Using index; Using join buffer (flat, BNL join)

    Profilo

    Status	Duration
    Starting	0.16 ms
    checking permissions	0.01 ms
    Opening tables	0.09 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.13 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.03 ms
    Creating tmp table	0.05 ms
    Executing	0.00 ms
    Sending data	2.23 ms
    Removing tmp table	0.02 ms
    Sending data	0.01 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.02 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    16	JDatabaseDriver->loadColumn()	JROOT/plugins/kunena/joomla/access.php:441
    15	KunenaAccessJoomla->getUsersByGroup()	JROOT/plugins/kunena/joomla/access.php:492
    14	KunenaAccessJoomla->getAuthorisedUsers()	JROOT/plugins/kunena/joomla/access.php:233
    13	KunenaAccessJoomla->loadCategoryRoles()	JROOT/libraries/kunena/access.php:151
    12	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:123
    11	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:237
    10	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:384
    9	KunenaUser->isAdmin()	JROOT/libraries/kunena/controller/application/display.php:243
    8	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:76
    7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
    6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

17. Tempo della query: 2.18 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.024 MB memoria prima della query: 4.569 MB Righe restituite: 0

    SELECT DISTINCT(user_id)
    
      FROM jos3_usergroups as ug1
    
      INNER JOIN jos3_usergroups AS ug2 
      ON ug2.lft>=ug1.lft 
      AND ug1.rgt>=ug2.rgt
    
      INNER JOIN jos3_user_usergroup_map AS m 
      ON ug2.id=m.group_id
    
      WHERE ug1.id IN (7)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	ug1	const	PRIMARY,idx_usergroup_nested_set_lookup	PRIMARY	4	const	1	Using temporary
    1	SIMPLE	m	index	NULL	PRIMARY	8	NULL	3252	Using index
    1	SIMPLE	ug2	eq_ref	PRIMARY,idx_usergroup_nested_set_lookup	PRIMARY	4	prepper.m.group_id	1	Using where; Distinct

    Profilo

    Status	Duration
    Starting	0.10 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.06 ms
    Optimizing	0.03 ms
    Statistics	0.09 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.02 ms
    Creating tmp table	0.03 ms
    Executing	0.00 ms
    Sending data	1.66 ms
    Removing tmp table	0.01 ms
    Sending data	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    16	JDatabaseDriver->loadColumn()	JROOT/plugins/kunena/joomla/access.php:441
    15	KunenaAccessJoomla->getUsersByGroup()	JROOT/plugins/kunena/joomla/access.php:492
    14	KunenaAccessJoomla->getAuthorisedUsers()	JROOT/plugins/kunena/joomla/access.php:233
    13	KunenaAccessJoomla->loadCategoryRoles()	JROOT/libraries/kunena/access.php:151
    12	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:123
    11	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:237
    10	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:384
    9	KunenaUser->isAdmin()	JROOT/libraries/kunena/controller/application/display.php:243
    8	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:76
    7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
    6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

18. Tempo della query: 0.36 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.023 MB memoria prima della query: 4.578 MB Righe restituite: 10

    SELECT `user_id`,`category_id`,`role`
    
      FROM `jos3_kunena_user_categories`
    
      WHERE `role` IN (1,2)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos3_kunena_user_categories	range	role	role	1	NULL	11	Using where; Using index

    Profilo

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.00 ms
    Opening tables	0.05 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.06 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/access.php:165
    12	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:123
    11	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:237
    10	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:384
    9	KunenaUser->isAdmin()	JROOT/libraries/kunena/controller/application/display.php:243
    8	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:76
    7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
    6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

19. Tempo della query: 2.10 ms Dopo l'ultima query: 3.61 ms Memoria query: 0.025 MB memoria prima della query: 4.721 MB Righe restituite: 1

    SELECT COUNT(*), MAX(id)
    
      FROM `jos3_users`
    
      WHERE (block=0 OR activation="")

    Explain

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

    Profilo

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    After opening tables	0.00 ms
    System lock	0.01 ms
    table lock	0.00 ms
    init	0.04 ms
    Optimizing	0.02 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	1.77 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1767
    18	JDatabaseDriver->loadRow()	JROOT/libraries/kunena/user/helper.php:323
    17	KunenaUserHelper::getTotalCount()	JROOT/libraries/kunena/forum/statistics.php:246
    16	KunenaForumStatistics->loadMemberCount()	JROOT/libraries/kunena/forum/statistics.php:230
    15	KunenaForumStatistics->loadGeneral()	JROOT/libraries/kunena/forum/statistics.php:211
    14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
    13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:125
    12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:119
    11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kay/pages/statistics/default/default.php:13
    10	include JROOT/components/com_kunena/template/nts_kay/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:167
    9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
    8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:116
    7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
    6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

20. Tempo della query: 0.76 ms Dopo l'ultima query: 2.13 ms Memoria query: 0.099 MB memoria prima della query: 4.832 MB Righe restituite: 71

    SELECT * 
      FROM jos3_kunena_categories 
      ORDER BY ordering, name

    Explain

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

    Profilo

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.47 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/forum/category/helper.php:85
    22	KunenaForumCategoryHelper::loadCategories()	JROOT/libraries/kunena/forum/category/helper.php:58
    21	KunenaForumCategoryHelper::initialize()	JROOT/libraries/kunena/forum/category/helper.php:1048
    20	include_once JROOT/libraries/kunena/forum/category/helper.php	JROOT/libraries/loader.php:738
    19	JLoader::_load()	JROOT/libraries/loader.php:707
    18	JLoader::_autoload()	Chiamata uguale alla linea sottostante.
    17	spl_autoload_call()	JROOT/libraries/kunena/forum/statistics.php:275
    16	KunenaForumStatistics->loadCategoryCount()	JROOT/libraries/kunena/forum/statistics.php:232
    15	KunenaForumStatistics->loadGeneral()	JROOT/libraries/kunena/forum/statistics.php:211
    14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
    13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:125
    12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:119
    11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kay/pages/statistics/default/default.php:13
    10	include JROOT/components/com_kunena/template/nts_kay/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:167
    9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
    8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:116
    7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
    6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

21. Tempo della query: 1.84 ms Dopo l'ultima query: 3.17 ms Memoria query: 0.025 MB memoria prima della query: 5.485 MB Righe restituite: 1

    SELECT
    				SUM(time>=1746057600 
      AND parent=0) AS todayTopicCount,
    				SUM(time>=1746057600 
      AND parent>0) AS todayReplyCount,
    				SUM(time>=1745971200 
      AND time<1746057600 
      AND parent=0) AS yesterdayTopicCount,
    				SUM(time>=1745971200 
      AND time<1746057600 
      AND parent>0) AS yesterdayReplyCount
    				
      FROM jos3_kunena_messages 
      WHERE time>=1745971200 
      AND hold=0

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos3_kunena_messages	range	time_hold,hold	time_hold	5	NULL	1	Using index condition

    Profilo

    Status	Duration
    Starting	0.08 ms
    checking permissions	0.00 ms
    Opening tables	0.05 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.04 ms
    Optimizing	0.02 ms
    Statistics	0.16 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    17	JDatabaseDriver->loadObject()	JROOT/libraries/kunena/forum/statistics.php:320
    16	KunenaForumStatistics->loadLastDays()	JROOT/libraries/kunena/forum/statistics.php:233
    15	KunenaForumStatistics->loadGeneral()	JROOT/libraries/kunena/forum/statistics.php:211
    14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
    13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:125
    12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:119
    11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kay/pages/statistics/default/default.php:13
    10	include JROOT/components/com_kunena/template/nts_kay/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:167
    9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
    8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:116
    7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
    6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

22. Tempo della query: 62.15 ms Dopo l'ultima query: 0.74 ms Memoria query: 0.025 MB memoria prima della query: 5.555 MB Righe restituite: 1

    SELECT COUNT(*) 
      FROM jos3_kunena_topics AS tt 
      WHERE tt.hold IN (0) 
      AND tt.category_id IN (2,54,36,24,14,12,73,30,32,8,60,10,59,5,74,17,13,50,28,22,6,76,33,18,7,25,51,31,9,19,52,61,35,44,53,67,65,75,39,66,64)    
      AND tt.moved_id='0'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	tt	ALL	category_id,hold	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	3042	Using where

    Profilo

    Status	Duration
    Starting	0.08 ms
    checking permissions	0.00 ms
    Opening tables	0.04 ms
    After opening tables	0.00 ms
    System lock	0.01 ms
    table lock	0.00 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.29 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	61.37 ms
    End of update loop	0.02 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    18	JDatabaseDriver->loadResult()	JROOT/libraries/kunena/forum/topic/helper.php:372
    17	KunenaForumTopicHelper::getLatestTopics()	JROOT/libraries/kunena/forum/statistics.php:387
    16	KunenaForumStatistics->loadTopTopics()	JROOT/libraries/kunena/forum/statistics.php:353
    15	KunenaForumStatistics->loadTopicStats()	JROOT/libraries/kunena/forum/statistics.php:212
    14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
    13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:125
    12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:119
    11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kay/pages/statistics/default/default.php:13
    10	include JROOT/components/com_kunena/template/nts_kay/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:167
    9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
    8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:116
    7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
    6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

23. Tempo della query: 1.92 ms Dopo l'ultima query: 0.24 ms Memoria query: 0.028 MB memoria prima della query: 5.565 MB Righe restituite: 5

    SELECT tt.*, ut.posts AS myposts, ut.last_post_id AS my_last_post_id, ut.favorite, tt.last_post_id AS lastread, 0 AS unread
    				
      FROM jos3_kunena_topics AS tt
    				
      LEFT JOIN jos3_kunena_user_topics AS ut 
      ON tt.id=ut.topic_id 
      AND ut.user_id='0'
    				
      WHERE tt.hold IN (0) 
      AND tt.category_id IN (2,54,36,24,14,12,73,30,32,8,60,10,59,5,74,17,13,50,28,22,6,76,33,18,7,25,51,31,9,19,52,61,35,44,53,67,65,75,39,66,64)    
      AND tt.moved_id='0' 
      ORDER BY posts DESC 
      LIMIT 0, 5

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	tt	index	category_id,hold	posts	4	NULL	6	Using where
    1	SIMPLE	ut	eq_ref	user_topic_id,topic_id	user_topic_id	8	const,prepper.tt.id	1

    Profilo

    Status	Duration
    Starting	0.13 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.06 ms
    Optimizing	0.03 ms
    Statistics	0.27 ms
    Preparing	0.26 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.88 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
    18	JDatabaseDriver->loadAssocList()	JROOT/libraries/kunena/forum/topic/helper.php:414
    17	KunenaForumTopicHelper::getLatestTopics()	JROOT/libraries/kunena/forum/statistics.php:387
    16	KunenaForumStatistics->loadTopTopics()	JROOT/libraries/kunena/forum/statistics.php:353
    15	KunenaForumStatistics->loadTopicStats()	JROOT/libraries/kunena/forum/statistics.php:212
    14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
    13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:125
    12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:119
    11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kay/pages/statistics/default/default.php:13
    10	include JROOT/components/com_kunena/template/nts_kay/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:167
    9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
    8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:116
    7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
    6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

24. Tempo della query: 0.72 ms Dopo l'ultima query: 9.23 ms Memoria query: 0.025 MB memoria prima della query: 5.972 MB Righe restituite: 0

    SELECT poll.threadid AS id, SUM(opt.votes) AS count
    					
      FROM jos3_kunena_polls_options AS opt
    					
      INNER JOIN jos3_kunena_polls AS poll 
      ON poll.id=opt.pollid
    					
      GROUP BY pollid
    					
      HAVING count > 0
    					
      ORDER BY count DESC 
      LIMIT 0, 5

    Explain

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

    Profilo

    Status	Duration
    Starting	0.14 ms
    checking permissions	0.01 ms
    Opening tables	0.14 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.07 ms
    Optimizing	0.03 ms
    Statistics	0.07 ms
    Preparing	0.01 ms
    Executing	0.02 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/forum/statistics.php:436
    16	KunenaForumStatistics->loadTopPolls()	JROOT/libraries/kunena/forum/statistics.php:363
    15	KunenaForumStatistics->loadTopicStats()	JROOT/libraries/kunena/forum/statistics.php:212
    14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
    13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:125
    12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:119
    11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kay/pages/statistics/default/default.php:13
    10	include JROOT/components/com_kunena/template/nts_kay/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:167
    9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
    8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:116
    7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
    6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

25. Tempo della query: 0.67 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.025 MB memoria prima della query: 5.985 MB Righe restituite: 5

    SELECT `u`.`id`,`ku`.`posts` AS `count`
    
      FROM `jos3_kunena_users` AS `ku`
    
      INNER JOIN `jos3_users` AS `u` 
      ON `u`.`id` = `ku`.`userid`
    
      WHERE `ku`.`posts`>0
    
      ORDER BY `ku`.`posts` DESC 
      LIMIT 5

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	ku	range	PRIMARY,posts	posts	5	NULL	734	Using where
    1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	prepper.ku.userid	1	Using index

    Profilo

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.04 ms
    Optimizing	0.02 ms
    Statistics	0.12 ms
    Preparing	0.06 ms
    Sorting result	0.02 ms
    Executing	0.00 ms
    Sending data	0.16 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/user/helper.php:365
    17	KunenaUserHelper::getTopPosters()	JROOT/libraries/kunena/forum/statistics.php:519
    16	KunenaForumStatistics->loadTopPosters()	JROOT/libraries/kunena/forum/statistics.php:480
    15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:213
    14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
    13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:125
    12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:119
    11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kay/pages/statistics/default/default.php:13
    10	include JROOT/components/com_kunena/template/nts_kay/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:167
    9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
    8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:116
    7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
    6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

26. Tempo della query: 0.73 ms Dopo l'ultima query: 4.21 ms Memoria query: 0.028 MB memoria prima della query: 6.004 MB Righe restituite: 1

    SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*
    			
      FROM jos3_users AS u
    			
      LEFT JOIN jos3_kunena_users AS ku 
      ON u.id = ku.userid
    			
      WHERE u.id = 42

    Explain

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

    Profilo

    Status	Duration
    Starting	0.09 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.08 ms
    Optimizing	0.02 ms
    Statistics	0.17 ms
    Preparing	0.00 ms
    Unlocking tables	0.01 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.06 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.04 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    21	JDatabaseDriver->loadAssoc()	JROOT/libraries/kunena/tables/kunenausers.php:490
    20	TableKunenaUsers->load()	JROOT/libraries/kunena/user/user.php:194
    19	KunenaUser->load()	JROOT/libraries/kunena/user/user.php:164
    18	KunenaUser->__construct()	JROOT/libraries/kunena/user/helper.php:186
    17	KunenaUserHelper::get()	JROOT/libraries/kunena/forum/statistics.php:535
    16	KunenaForumStatistics->loadTopPosters()	JROOT/libraries/kunena/forum/statistics.php:480
    15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:213
    14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
    13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:125
    12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:119
    11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kay/pages/statistics/default/default.php:13
    10	include JROOT/components/com_kunena/template/nts_kay/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:167
    9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
    8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:116
    7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
    6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

27. Tempo della query: 0.48 ms Dopo l'ultima query: 1.12 ms Memoria query: 0.028 MB memoria prima della query: 6.046 MB Righe restituite: 1

    SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*
    			
      FROM jos3_users AS u
    			
      LEFT JOIN jos3_kunena_users AS ku 
      ON u.id = ku.userid
    			
      WHERE u.id = 147

    Explain

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

    Profilo

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.05 ms
    Optimizing	0.02 ms
    Statistics	0.07 ms
    Preparing	0.00 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.05 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    21	JDatabaseDriver->loadAssoc()	JROOT/libraries/kunena/tables/kunenausers.php:490
    20	TableKunenaUsers->load()	JROOT/libraries/kunena/user/user.php:194
    19	KunenaUser->load()	JROOT/libraries/kunena/user/user.php:164
    18	KunenaUser->__construct()	JROOT/libraries/kunena/user/helper.php:186
    17	KunenaUserHelper::get()	JROOT/libraries/kunena/forum/statistics.php:535
    16	KunenaForumStatistics->loadTopPosters()	JROOT/libraries/kunena/forum/statistics.php:480
    15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:213
    14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
    13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:125
    12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:119
    11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kay/pages/statistics/default/default.php:13
    10	include JROOT/components/com_kunena/template/nts_kay/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:167
    9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
    8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:116
    7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
    6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

28. Tempo della query: 0.45 ms Dopo l'ultima query: 0.41 ms Memoria query: 0.028 MB memoria prima della query: 6.068 MB Righe restituite: 1

    SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*
    			
      FROM jos3_users AS u
    			
      LEFT JOIN jos3_kunena_users AS ku 
      ON u.id = ku.userid
    			
      WHERE u.id = 95

    Explain

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

    Profilo

    Status	Duration
    Starting	0.08 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.04 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.00 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.05 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    21	JDatabaseDriver->loadAssoc()	JROOT/libraries/kunena/tables/kunenausers.php:490
    20	TableKunenaUsers->load()	JROOT/libraries/kunena/user/user.php:194
    19	KunenaUser->load()	JROOT/libraries/kunena/user/user.php:164
    18	KunenaUser->__construct()	JROOT/libraries/kunena/user/helper.php:186
    17	KunenaUserHelper::get()	JROOT/libraries/kunena/forum/statistics.php:535
    16	KunenaForumStatistics->loadTopPosters()	JROOT/libraries/kunena/forum/statistics.php:480
    15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:213
    14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
    13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:125
    12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:119
    11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kay/pages/statistics/default/default.php:13
    10	include JROOT/components/com_kunena/template/nts_kay/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:167
    9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
    8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:116
    7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
    6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

29. Tempo della query: 0.44 ms Dopo l'ultima query: 0.37 ms Memoria query: 0.028 MB memoria prima della query: 6.090 MB Righe restituite: 1

    SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*
    			
      FROM jos3_users AS u
    			
      LEFT JOIN jos3_kunena_users AS ku 
      ON u.id = ku.userid
    			
      WHERE u.id = 54

    Explain

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

    Profilo

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.04 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.00 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.07 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.06 ms

    Call Stack

    #	Caller	File e numero di linea
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    21	JDatabaseDriver->loadAssoc()	JROOT/libraries/kunena/tables/kunenausers.php:490
    20	TableKunenaUsers->load()	JROOT/libraries/kunena/user/user.php:194
    19	KunenaUser->load()	JROOT/libraries/kunena/user/user.php:164
    18	KunenaUser->__construct()	JROOT/libraries/kunena/user/helper.php:186
    17	KunenaUserHelper::get()	JROOT/libraries/kunena/forum/statistics.php:535
    16	KunenaForumStatistics->loadTopPosters()	JROOT/libraries/kunena/forum/statistics.php:480
    15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:213
    14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
    13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:125
    12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:119
    11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kay/pages/statistics/default/default.php:13
    10	include JROOT/components/com_kunena/template/nts_kay/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:167
    9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
    8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:116
    7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
    6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

30. Tempo della query: 0.44 ms Dopo l'ultima query: 0.36 ms Memoria query: 0.028 MB memoria prima della query: 6.111 MB Righe restituite: 1

    SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*
    			
      FROM jos3_users AS u
    			
      LEFT JOIN jos3_kunena_users AS ku 
      ON u.id = ku.userid
    			
      WHERE u.id = 83

    Explain

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

    Profilo

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.04 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.00 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.05 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    21	JDatabaseDriver->loadAssoc()	JROOT/libraries/kunena/tables/kunenausers.php:490
    20	TableKunenaUsers->load()	JROOT/libraries/kunena/user/user.php:194
    19	KunenaUser->load()	JROOT/libraries/kunena/user/user.php:164
    18	KunenaUser->__construct()	JROOT/libraries/kunena/user/helper.php:186
    17	KunenaUserHelper::get()	JROOT/libraries/kunena/forum/statistics.php:535
    16	KunenaForumStatistics->loadTopPosters()	JROOT/libraries/kunena/forum/statistics.php:480
    15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:213
    14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
    13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:125
    12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:119
    11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kay/pages/statistics/default/default.php:13
    10	include JROOT/components/com_kunena/template/nts_kay/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:167
    9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
    8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:116
    7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
    6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

31. Tempo della query: 0.50 ms Dopo l'ultima query: 0.39 ms Memoria query: 0.026 MB memoria prima della query: 6.127 MB Righe restituite: 5

    SELECT `u`.`id`,`ku`.`uhits` AS `count`
    
      FROM `jos3_kunena_users` AS `ku`
    
      INNER JOIN `jos3_users` AS `u` 
      ON `u`.`id` = `ku`.`userid`
    
      WHERE `ku`.`uhits`>0
    
      ORDER BY `ku`.`uhits` DESC 
      LIMIT 5

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	ku	range	PRIMARY,uhits	uhits	5	NULL	2216	Using where
    1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	prepper.ku.userid	1	Using index

    Profilo

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.08 ms
    Preparing	0.05 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.10 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    19	JDatabaseDriver->loadObjectList()	JROOT/plugins/kunena/kunena/profile.php:118
    18	KunenaProfileKunena->_getTopHits()	JROOT/libraries/kunena/integration/profile.php:76
    17	KunenaProfile->getTopHits()	JROOT/libraries/kunena/forum/statistics.php:556
    16	KunenaForumStatistics->loadTopProfiles()	JROOT/libraries/kunena/forum/statistics.php:487
    15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:213
    14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
    13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:125
    12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:119
    11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kay/pages/statistics/default/default.php:13
    10	include JROOT/components/com_kunena/template/nts_kay/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:167
    9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
    8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:116
    7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
    6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

32. Tempo della query: 0.43 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.028 MB memoria prima della query: 6.146 MB Righe restituite: 1

    SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*
    			
      FROM jos3_users AS u
    			
      LEFT JOIN jos3_kunena_users AS ku 
      ON u.id = ku.userid
    			
      WHERE u.id = 455

    Explain

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

    Profilo

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.04 ms
    Optimizing	0.02 ms
    Statistics	0.06 ms
    Preparing	0.00 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.05 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    21	JDatabaseDriver->loadAssoc()	JROOT/libraries/kunena/tables/kunenausers.php:490
    20	TableKunenaUsers->load()	JROOT/libraries/kunena/user/user.php:194
    19	KunenaUser->load()	JROOT/libraries/kunena/user/user.php:164
    18	KunenaUser->__construct()	JROOT/libraries/kunena/user/helper.php:186
    17	KunenaUserHelper::get()	JROOT/libraries/kunena/forum/statistics.php:572
    16	KunenaForumStatistics->loadTopProfiles()	JROOT/libraries/kunena/forum/statistics.php:487
    15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:213
    14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
    13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:125
    12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:119
    11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kay/pages/statistics/default/default.php:13
    10	include JROOT/components/com_kunena/template/nts_kay/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:167
    9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
    8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:116
    7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
    6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

33. Tempo della query: 4.01 ms Dopo l'ultima query: 0.37 ms Memoria query: 0.026 MB memoria prima della query: 6.167 MB Righe restituite: 5

    SELECT `t`.`targetuserid` AS `id`,COUNT(t.targetuserid) AS count
    
      FROM `jos3_kunena_thankyou` AS `t`
    
      INNER JOIN `jos3_users` AS `u` 
      ON `u`.`id` = `t`.`targetuserid`
    
      GROUP BY `t`.`targetuserid`
    
      ORDER BY `count` DESC 
      LIMIT 5

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	t	index	targetuserid	targetuserid	4	NULL	8748	Using index; Using temporary; Using filesort
    1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	prepper.t.targetuserid	1	Using index

    Profilo

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.00 ms
    Opening tables	0.06 ms
    After opening tables	0.00 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Creating tmp table	0.02 ms
    Sorting for group	0.01 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	3.57 ms
    Creating sort index	0.06 ms
    Removing tmp table	0.00 ms
    Creating sort index	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/forum/statistics.php:611
    16	KunenaForumStatistics->loadTopThankyous()	JROOT/libraries/kunena/forum/statistics.php:497
    15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:213
    14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
    13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:125
    12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:119
    11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kay/pages/statistics/default/default.php:13
    10	include JROOT/components/com_kunena/template/nts_kay/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:167
    9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
    8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:116
    7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
    6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

34. Tempo della query: 0.33 ms Dopo l'ultima query: 0.20 ms Memoria query: 0.028 MB memoria prima della query: 6.191 MB Righe restituite: 1

    SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*
    			
      FROM jos3_users AS u
    			
      LEFT JOIN jos3_kunena_users AS ku 
      ON u.id = ku.userid
    			
      WHERE u.id = 431

    Explain

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

    Profilo

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.04 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    21	JDatabaseDriver->loadAssoc()	JROOT/libraries/kunena/tables/kunenausers.php:490
    20	TableKunenaUsers->load()	JROOT/libraries/kunena/user/user.php:194
    19	KunenaUser->load()	JROOT/libraries/kunena/user/user.php:164
    18	KunenaUser->__construct()	JROOT/libraries/kunena/user/helper.php:186
    17	KunenaUserHelper::get()	JROOT/libraries/kunena/forum/statistics.php:632
    16	KunenaForumStatistics->loadTopThankyous()	JROOT/libraries/kunena/forum/statistics.php:497
    15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:213
    14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
    13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:125
    12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:119
    11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kay/pages/statistics/default/default.php:13
    10	include JROOT/components/com_kunena/template/nts_kay/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:167
    9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
    8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:116
    7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
    6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

35. Tempo della query: 0.32 ms Dopo l'ultima query: 0.40 ms Memoria query: 0.027 MB memoria prima della query: 6.209 MB Righe restituite: 1

    SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*
    			
      FROM jos3_users AS u
    			
      LEFT JOIN jos3_kunena_users AS ku 
      ON u.id = ku.userid
    			
      WHERE u.id = 3463

    Explain

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

    Profilo

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.04 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.02 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    19	JDatabaseDriver->loadAssoc()	JROOT/libraries/kunena/tables/kunenausers.php:490
    18	TableKunenaUsers->load()	JROOT/libraries/kunena/user/user.php:194
    17	KunenaUser->load()	JROOT/libraries/kunena/user/user.php:164
    16	KunenaUser->__construct()	JROOT/libraries/kunena/user/helper.php:186
    15	KunenaUserHelper::get()	JROOT/libraries/kunena/factory.php:83
    14	KunenaFactory::getUser()	JROOT/components/com_kunena/controller/statistics/general/display.php:49
    13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:125
    12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:119
    11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kay/pages/statistics/default/default.php:13
    10	include JROOT/components/com_kunena/template/nts_kay/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:167
    9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
    8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:116
    7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
    6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

36. Tempo della query: 6.59 ms Dopo l'ultima query: 11.64 ms Memoria query: 0.031 MB memoria prima della query: 7.021 MB Righe restituite: 4

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM jos3_modules AS m
    
      LEFT JOIN jos3_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN jos3_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 <= '2025-05-01 05:11:43') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-05-01 05:11:43') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 118 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	PRIMARY,published,newsfeeds	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	46	Using where; Using filesort
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	prepper.m.module,const	1	Using index condition; Using where
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	prepper.m.id	2	Using where; Using index

    Profilo

    Status	Duration
    Starting	0.20 ms
    checking permissions	0.01 ms
    Opening tables	0.14 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.07 ms
    Optimizing	0.06 ms
    Statistics	0.10 ms
    Preparing	0.05 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.33 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    31	JDatabaseDriver->loadObjectList()	Chiamata uguale alla linea sottostante.
    30	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    29	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
    28	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
    27	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    26	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
    25	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/components/com_kunena/layout/widget/module.php:33
    24	KunenaLayoutWidgetModule->renderPosition()	JROOT/components/com_kunena/template/nts_kay/layouts/widget/module/default.php:13
    23	include JROOT/components/com_kunena/template/nts_kay/layouts/widget/module/default.php	JROOT/libraries/kunena/layout/base.php:167
    22	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
    21	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:118
    20	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/nts_kay/layouts/widget/login/login/default.php:69
    19	include JROOT/components/com_kunena/template/nts_kay/layouts/widget/login/login/default.php	JROOT/libraries/kunena/layout/base.php:167
    18	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
    17	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:118
    16	KunenaLayoutBase->__toString()	JROOT/libraries/kunena/controller/display.php:109
    15	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kay/layouts/widget/menubar/default.php:17
    14	include JROOT/components/com_kunena/template/nts_kay/layouts/widget/menubar/default.php	JROOT/libraries/kunena/layout/base.php:167
    13	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
    12	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:118
    11	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/nts_kay/layouts/page/default.php:20
    10	include JROOT/components/com_kunena/template/nts_kay/layouts/page/default.php	JROOT/libraries/kunena/layout/base.php:167
    9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
    8	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:118
    7	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/kunena.php:131
    6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

37. Tempo della query: 0.51 ms Dopo l'ultima query: 2.36 ms Memoria query: 0.023 MB memoria prima della query: 6.978 MB Righe restituite: 0

    SELECT *
    
      FROM jos3_kunena_announcement
    
      WHERE (published = 1) 
      AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2025-05-01 05:11:43') 
      AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-05-01 05:11:43')
    
      ORDER BY id DESC 
      LIMIT 1

    Explain

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

    Profilo

    Status	Duration
    Starting	0.11 ms
    checking permissions	0.01 ms
    Opening tables	0.07 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.07 ms
    Optimizing	0.03 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Executing	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
    15	JDatabaseDriver->loadAssocList()	JROOT/libraries/kunena/forum/announcement/helper.php:141
    14	KunenaForumAnnouncementHelper::getAnnouncements()	JROOT/components/com_kunena/controller/widget/announcement/display.php:40
    13	ComponentKunenaControllerWidgetAnnouncementDisplay->before()	JROOT/libraries/kunena/controller/display.php:125
    12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:75
    11	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kay/layouts/page/default.php:35
    10	include JROOT/components/com_kunena/template/nts_kay/layouts/page/default.php	JROOT/libraries/kunena/layout/base.php:167
    9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
    8	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:118
    7	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/kunena.php:131
    6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

38. Tempo della query: 5.06 ms Dopo l'ultima query: 2.01 ms Memoria query: 0.022 MB memoria prima della query: 6.976 MB Righe restituite: 1

    SELECT * 
      FROM jos3_template_styles 
      WHERE template = 'shape5_vertex';

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos3_template_styles	ref	idx_template	idx_template	202	const	1	Using index condition

    Profilo

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.06 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.04 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
    10	JDatabaseDriver->loadAssocList()	JROOT/templates/shape5_vertex/vertex/parameters.php:19
    9	getTemplateName()	JROOT/templates/shape5_vertex/vertex/parameters.php:165
    8	require JROOT/templates/shape5_vertex/vertex/parameters.php	JROOT/templates/shape5_vertex/index.php:21
    7	require JROOT/templates/shape5_vertex/index.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:1030
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

39. Tempo della query: 0.84 ms Dopo l'ultima query: 0.18 ms Memoria query: 0.021 MB memoria prima della query: 6.984 MB Righe restituite: 0

    SELECT * 
      FROM jos3_menu 
      WHERE template_style_id IN (9) 
      AND alias = 'forum'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos3_menu	ref	idx_alias	idx_alias	402	const	1	Using where

    Profilo

    Status	Duration
    Starting	0.11 ms
    checking permissions	0.01 ms
    Opening tables	0.09 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.06 ms
    Optimizing	0.03 ms
    Statistics	0.13 ms
    Preparing	0.04 ms
    Executing	0.00 ms
    Sending data	0.09 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
    10	JDatabaseDriver->loadAssocList()	JROOT/templates/shape5_vertex/vertex/parameters.php:40
    9	getTemplateName()	JROOT/templates/shape5_vertex/vertex/parameters.php:165
    8	require JROOT/templates/shape5_vertex/vertex/parameters.php	JROOT/templates/shape5_vertex/index.php:21
    7	require JROOT/templates/shape5_vertex/index.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:1030
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

40. Tempo della query: 5.74 ms Dopo l'ultima query: 13.24 ms Memoria query: 0.021 MB memoria prima della query: 7.073 MB Righe restituite: 0

    SELECT menutype  
      FROM  jos3_menu 
      WHERE language = 'it-IT' 
      AND home = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos3_menu	ref	idx_language	idx_language	28	const	1	Using index condition; Using where

    Profilo

    Status	Duration
    Starting	0.12 ms
    checking permissions	0.01 ms
    Opening tables	0.06 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.06 ms
    Optimizing	0.09 ms
    Statistics	0.11 ms
    Preparing	0.05 ms
    Executing	0.00 ms
    Sending data	0.04 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.04 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    9	JDatabaseDriver->loadResult()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/default.php:45
    8	include JROOT/templates/shape5_vertex/vertex/s5flex_menu/default.php	JROOT/templates/shape5_vertex/index.php:158
    7	require JROOT/templates/shape5_vertex/index.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:1030
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

41. Tempo della query: 1.07 ms Dopo l'ultima query: 0.49 ms Memoria query: 0.112 MB memoria prima della query: 7.103 MB Righe restituite: 68
    Query duplicate: #6

    SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
    
      FROM jos3_menu AS m
    
      LEFT JOIN jos3_extensions AS e 
      ON m.component_id = e.extension_id
    
      WHERE m.published = 1 
      AND m.parent_id > 0 
      AND m.client_id = 0
    
      ORDER BY m.lft

    Explain

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

    Profilo

    Status	Duration
    Starting	0.11 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.05 ms
    Optimizing	0.03 ms
    Statistics	0.07 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.51 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
    16	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Chiamata uguale alla linea sottostante.
    15	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
    13	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
    12	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
    11	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/helpers.php:57
    10	S5modMainMenuHelper::getList()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/helpers.php:153
    9	S5modMainMenuHelper::S5buildXML()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/default.php:54
    8	include JROOT/templates/shape5_vertex/vertex/s5flex_menu/default.php	JROOT/templates/shape5_vertex/index.php:158
    7	require JROOT/templates/shape5_vertex/index.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:1030
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

42. Tempo della query: 0.75 ms Dopo l'ultima query: 29.98 ms Memoria query: 0.025 MB memoria prima della query: 7.182 MB Righe restituite: 1

    SELECT `extension_id`,`name`,`enabled`,`params`
    
      FROM jos3_extensions
    
      WHERE `type` = 'plugin' 
      AND `element` = 'osyoutube' 
      AND `folder` = 'content'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos3_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

    Profilo

    Status	Duration
    Starting	0.12 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.11 ms
    Optimizing	0.04 ms
    Statistics	0.12 ms
    Preparing	0.03 ms
    Executing	0.00 ms
    Sending data	0.06 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    20	JDatabaseDriver->loadObject()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/Generic.php:152
    19	Alledia\Framework\Joomla\Extension\Generic->getDataFromDatabase()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/Generic.php:122
    18	Alledia\Framework\Joomla\Extension\Generic->__construct()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/Licensed.php:51
    17	Alledia\Framework\Joomla\Extension\Licensed->__construct()	JROOT/libraries/allediaframework/Framework/Factory.php:38
    16	Alledia\Framework\Factory::getExtension()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/AbstractPlugin.php:73
    15	Alledia\Framework\Joomla\Extension\AbstractPlugin->loadExtension()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/AbstractPlugin.php:44
    14	Alledia\Framework\Joomla\Extension\AbstractPlugin->init()	JROOT/plugins/content/osyoutube/library/BasePlugin.php:33
    13	Alledia\OSYouTube\BasePlugin->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
    12	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
    11	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/templates/shape5_vertex/html/modules.php:17
    10	include_once JROOT/templates/shape5_vertex/html/modules.php	JROOT/libraries/src/Helper/ModuleHelper.php:218
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

43. Tempo della query: 0.82 ms Dopo l'ultima query: 9.34 ms Memoria query: 0.022 MB memoria prima della query: 7.335 MB Righe restituite: 6

    SELECT `name`,`element`
    
      FROM `jos3_extensions`
    
      WHERE `type` = 'plugin' 
      AND `folder` = 'finder' 
      AND `enabled` = 1

    Explain

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

    Profilo

    Status	Duration
    Starting	0.09 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.07 ms
    Preparing	0.03 ms
    Executing	0.00 ms
    Sending data	0.24 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_finder/helpers/language.php:126
    11	FinderHelperLanguage::loadPluginLanguage()	JROOT/modules/mod_finder/mod_finder.php:51
    10	include JROOT/modules/mod_finder/mod_finder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

44. Tempo della query: 0.82 ms Dopo l'ultima query: 2.08 ms Memoria query: 0.023 MB memoria prima della query: 7.355 MB Righe restituite: 4

    SELECT `title`
    
      FROM `jos3_finder_taxonomy`
    
      WHERE `parent_id` = 1 
      AND `state` = 1 
      AND `access` IN (1,1)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos3_finder_taxonomy	ref	parent_id,state,access,idx_parent_published	parent_id	4	const	4	Using where

    Profilo

    Status	Duration
    Starting	0.08 ms
    checking permissions	0.01 ms
    Opening tables	0.09 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.05 ms
    Optimizing	0.03 ms
    Statistics	0.16 ms
    Preparing	0.05 ms
    Executing	0.00 ms
    Sending data	0.11 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    15	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_finder/helpers/indexer/taxonomy.php:258
    14	FinderIndexerTaxonomy::getBranchTitles()	JROOT/administrator/components/com_finder/helpers/indexer/query.php:750
    13	FinderIndexerQuery->processString()	JROOT/administrator/components/com_finder/helpers/indexer/query.php:236
    12	FinderIndexerQuery->__construct()	JROOT/modules/mod_finder/helper.php:84
    11	ModFinderHelper::getQuery()	JROOT/modules/mod_finder/mod_finder.php:54
    10	include JROOT/modules/mod_finder/mod_finder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---