{
    "__default": {
        "session": {
            "counter": 2,
            "timer": {
                "start": 1746780962,
                "last": 1746780962,
                "now": 1746780971
            },
            "token": "eDxuMc0TUvyMtwxHs1MQsPcoks1h9ygn"
        },
        "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
                },
                "topic": {
                    "lasthit": 5315
                }
            }
        },
        "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

48 query eseguite 82.41 ms

1. Tempo della query: 6.42 ms Memoria query: 0.023 MB memoria prima della query: 1.018 MB Righe restituite: 1

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

   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.02 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.05 ms
   Preparing	0.01 ms
   Unlocking tables	0.01 ms
   Preparing	0.01 ms
   Executing	0.00 ms
   Sending data	0.01 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	4.15 ms
   Reset for next command	0.02 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.91 ms Dopo l'ultima query: 0.53 ms Memoria query: 0.024 MB memoria prima della query: 1.068 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.08 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.05 ms
   Optimizing	0.03 ms
   Statistics	0.08 ms
   Preparing	0.03 ms
   Executing	0.00 ms
   Sending data	0.25 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.02 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.04 ms
   Updating status	0.04 ms
   Reset for next command	0.01 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.41 ms Dopo l'ultima query: 0.72 ms Memoria query: 0.021 MB memoria prima della query: 1.094 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.06 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.02 ms
   Optimizing	0.01 ms
   Statistics	0.02 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.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.00 ms
   Updating status	0.02 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.47 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.021 MB memoria prima della query: 1.108 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.06 ms
   checking permissions	0.02 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.02 ms
   Statistics	0.07 ms
   Preparing	0.00 ms
   Unlocking tables	0.00 ms
   Preparing	0.05 ms
   Executing	0.00 ms
   Sending data	0.03 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.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
   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: 1.04 ms Dopo l'ultima query: 0.17 ms Memoria query: 0.030 MB memoria prima della query: 1.130 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.00 ms
   System lock	0.00 ms
   table lock	0.01 ms
   init	0.03 ms
   Optimizing	0.03 ms
   Statistics	0.05 ms
   Preparing	0.02 ms
   Sorting result	0.02 ms
   Executing	0.00 ms
   Sending data	0.01 ms
   Creating sort index	0.59 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.00 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: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: 4.40 ms Dopo l'ultima query: 11.30 ms Memoria query: 0.112 MB memoria prima della query: 1.621 MB Righe restituite: 68
   Query duplicate: #45

   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.15 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.08 ms
   Optimizing	0.04 ms
   Statistics	0.12 ms
   Preparing	0.06 ms
   Sorting result	0.02 ms
   Executing	0.00 ms
   Sending data	0.04 ms
   Creating sort index	0.98 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.01 ms
   Freeing items	0.01 ms
   Updating status	0.02 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: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: 0.71 ms Dopo l'ultima query: 11.89 ms Memoria query: 0.025 MB memoria prima della query: 2.249 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.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.05 ms
   Optimizing	0.02 ms
   Statistics	0.05 ms
   Preparing	0.00 ms
   Unlocking tables	0.01 ms
   Preparing	0.02 ms
   Executing	0.00 ms
   Sending data	0.05 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.16 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
   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.93 ms Dopo l'ultima query: 7.51 ms Memoria query: 0.022 MB memoria prima della query: 2.344 MB Righe restituite: 1

   SELECT * 
     FROM jos3_kunena_aliases 
     WHERE alias LIKE '54-comunicazioni-radio-e-i-p-r-n%'

   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.06 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.06 ms
   Optimizing	0.02 ms
   Statistics	0.14 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.02 ms
   Query end	0.01 ms
   closing tables	0.02 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.15 ms
   Reset for next command	0.01 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.86 ms Dopo l'ultima query: 0.57 ms Memoria query: 0.025 MB memoria prima della query: 2.370 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.12 ms
   checking permissions	0.01 ms
   Opening tables	0.12 ms
   After opening tables	0.01 ms
   System lock	0.02 ms
   table lock	0.01 ms
   init	0.04 ms
   Optimizing	0.03 ms
   Statistics	0.12 ms
   Preparing	0.04 ms
   Executing	0.01 ms
   Sending data	0.06 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.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.07 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.22 ms Dopo l'ultima query: 0.26 ms Memoria query: 0.006 MB memoria prima della query: 2.363 MB

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

    Explain

    EXPLAIN non possibile sulla query: UPDATE `jos3_extensions` SET `params` = '{\"mediaversion\":\"a7aa075e6d9e67a34c8a5c428fa7caa0\"}' 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.00 ms
    init for update	0.15 ms
    Updating	0.10 ms
    End of update loop	0.01 ms
    Query end	0.03 ms
    Commit	0.69 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
    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: 0.63 ms Dopo l'ultima query: 0.88 ms Memoria query: 0.019 MB memoria prima della query: 2.401 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.07 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.03 ms
    Optimizing	0.02 ms
    Statistics	0.02 ms
    Preparing	0.10 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.09 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 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.04 ms
    Reset for next command	0.02 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.73 ms Dopo l'ultima query: 0.35 ms Memoria query: 0.019 MB memoria prima della query: 2.411 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.15 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.03 ms
    Optimizing	0.04 ms
    Statistics	0.08 ms
    Preparing	0.05 ms
    Executing	0.00 ms
    Sending data	0.07 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
    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.15 ms Dopo l'ultima query: 5.00 ms Memoria query: 0.025 MB memoria prima della query: 2.821 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.07 ms
    checking permissions	0.01 ms
    closing tables	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.45 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Filling schema table	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.00 ms
    checking permissions	0.09 ms
    closing tables	0.01 ms
    checking permissions	0.01 ms
    Executing	0.00 ms
    Sending data	0.08 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.00 ms
    Removing tmp table	0.12 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: 6.68 ms Dopo l'ultima query: 20.61 ms Memoria query: 0.035 MB memoria prima della query: 3.701 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.33 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.08 ms
    Optimizing	0.06 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Filling schema table	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.00 ms
    checking permissions	0.20 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.01 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Removing tmp table	0.12 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: 1.44 ms Dopo l'ultima query: 20.28 ms Memoria query: 0.028 MB memoria prima della query: 4.499 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.15 ms
    checking permissions	0.01 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.25 ms
    Preparing	0.03 ms
    Executing	0.00 ms
    Sending data	0.50 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.05 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: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: 2.91 ms Dopo l'ultima query: 0.41 ms Memoria query: 0.024 MB memoria prima della query: 4.563 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.10 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.10 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.15 ms
    Removing tmp table	0.02 ms
    Sending data	0.01 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.06 ms
    Reset for next command	0.01 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: 3.17 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.024 MB memoria prima della query: 4.574 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.09 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.03 ms
    Statistics	0.10 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.03 ms
    Creating tmp table	0.04 ms
    Executing	0.00 ms
    Sending data	2.58 ms
    Removing tmp table	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.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]

    ---

18. Tempo della query: 1.74 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.023 MB memoria prima della query: 4.582 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.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.05 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.02 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: 0.67 ms Dopo l'ultima query: 4.43 ms Memoria query: 0.099 MB memoria prima della query: 4.802 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.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.04 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.40 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.00 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:1695
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/forum/category/helper.php:85
    20	KunenaForumCategoryHelper::loadCategories()	JROOT/libraries/kunena/forum/category/helper.php:58
    19	KunenaForumCategoryHelper::initialize()	JROOT/libraries/kunena/forum/category/helper.php:1048
    18	include_once JROOT/libraries/kunena/forum/category/helper.php	JROOT/libraries/loader.php:738
    17	JLoader::_load()	JROOT/libraries/loader.php:707
    16	JLoader::_autoload()	Chiamata uguale alla linea sottostante.
    15	spl_autoload_call()	JROOT/libraries/kunena/access.php:584
    14	KunenaAccess->getAllowedCategories()	JROOT/components/com_kunena/controller/topic/item/display.php:71
    13	ComponentKunenaControllerTopicItemDisplay->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/topic/default/default.php:13
    10	include JROOT/components/com_kunena/template/nts_kay/pages/topic/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: 1.41 ms Dopo l'ultima query: 7.07 ms Memoria query: 0.037 MB memoria prima della query: 5.521 MB Righe restituite: 35

    SHOW FULL COLUMNS 
      FROM `jos3_kunena_categories`

    Explain

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

    Profilo

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.01 ms
    closing tables	0.00 ms
    checking permissions	0.01 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.02 ms
    After opening tables	0.00 ms
    checking permissions	0.22 ms
    closing tables	0.01 ms
    checking permissions	0.01 ms
    Executing	0.00 ms
    Sending data	0.11 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Removing tmp table	0.17 ms
    closing tables	0.01 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
    28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    27	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    26	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    25	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    24	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/kunena/tables/kunenacategories.php:241
    23	TableKunenaCategories->__construct()	JROOT/libraries/src/Table/Table.php:312
    22	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/kunena/database/object.php:223
    21	KunenaDatabaseObject->getTable()	JROOT/libraries/kunena/database/object.php:242
    20	KunenaDatabaseObject->load()	JROOT/libraries/kunena/forum/category/category.php:1152
    19	KunenaForumCategory->load()	JROOT/libraries/kunena/forum/category/helper.php:633
    18	KunenaForumCategoryHelper::get()	JROOT/libraries/kunena/html/html/kunenaforum.php:84
    17	JHtmlKunenaForum::categorylist()	Chiamata uguale alla linea sottostante.
    16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_kunena/controller/topic/item/display.php:82
    13	ComponentKunenaControllerTopicItemDisplay->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/topic/default/default.php:13
    10	include JROOT/components/com_kunena/template/nts_kay/pages/topic/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: 0.95 ms Dopo l'ultima query: 7.77 ms Memoria query: 0.032 MB memoria prima della query: 5.851 MB Righe restituite: 25

    SHOW FULL COLUMNS 
      FROM `jos3_kunena_topics`

    Explain

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

    Profilo

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.00 ms
    closing tables	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.32 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Filling schema table	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.00 ms
    checking permissions	0.12 ms
    closing tables	0.01 ms
    checking permissions	0.01 ms
    Executing	0.00 ms
    Sending data	0.07 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Removing tmp table	0.10 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
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    25	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    24	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    23	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    22	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/kunena/tables/kunenatopics.php:169
    21	TableKunenaTopics->__construct()	JROOT/libraries/src/Table/Table.php:312
    20	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/kunena/database/object.php:223
    19	KunenaDatabaseObject->getTable()	JROOT/libraries/kunena/database/object.php:242
    18	KunenaDatabaseObject->load()	JROOT/libraries/kunena/forum/topic/topic.php:1471
    17	KunenaForumTopic->load()	JROOT/libraries/kunena/database/object.php:80
    16	KunenaDatabaseObject->__construct()	JROOT/libraries/kunena/forum/topic/topic.php:170
    15	KunenaForumTopic->__construct()	JROOT/libraries/kunena/forum/topic/helper.php:52
    14	KunenaForumTopicHelper::get()	JROOT/components/com_kunena/controller/topic/item/display.php:95
    13	ComponentKunenaControllerTopicItemDisplay->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/topic/default/default.php:13
    10	include JROOT/components/com_kunena/template/nts_kay/pages/topic/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: 0.42 ms Dopo l'ultima query: 0.18 ms Memoria query: 0.026 MB memoria prima della query: 5.893 MB Righe restituite: 1

    SELECT *
    
      FROM `jos3_kunena_topics`
    
      WHERE `id`=5315

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos3_kunena_topics	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.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.11 ms
    Preparing	0.00 ms
    Unlocking tables	0.01 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.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.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:1459
    18	JDatabaseDriver->loadAssoc()	JROOT/libraries/kunena/tables/kunenatopics.php:214
    17	TableKunenaTopics->load()	JROOT/libraries/kunena/database/object.php:247
    16	KunenaDatabaseObject->load()	JROOT/libraries/kunena/forum/topic/topic.php:1471
    15	KunenaForumTopic->load()	JROOT/libraries/kunena/forum/topic/helper.php:55
    14	KunenaForumTopicHelper::get()	JROOT/components/com_kunena/controller/topic/item/display.php:95
    13	ComponentKunenaControllerTopicItemDisplay->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/topic/default/default.php:13
    10	include JROOT/components/com_kunena/template/nts_kay/pages/topic/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: 3.90 ms Dopo l'ultima query: 2.89 ms Memoria query: 0.031 MB memoria prima della query: 6.158 MB Righe restituite: 19

    SHOW FULL COLUMNS 
      FROM `jos3_kunena_messages`

    Explain

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

    Profilo

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.00 ms
    closing tables	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.25 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Filling schema table	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    checking permissions	0.09 ms
    closing tables	0.01 ms
    checking permissions	0.00 ms
    Executing	0.00 ms
    Sending data	0.05 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Removing tmp table	0.08 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
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    25	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    24	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    23	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    22	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/kunena/tables/kunenamessages.php:158
    21	TableKunenaMessages->__construct()	JROOT/libraries/src/Table/Table.php:312
    20	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/kunena/database/object.php:223
    19	KunenaDatabaseObject->getTable()	JROOT/libraries/kunena/database/object.php:242
    18	KunenaDatabaseObject->load()	JROOT/libraries/kunena/forum/message/message.php:1357
    17	KunenaForumMessage->load()	JROOT/libraries/kunena/database/object.php:80
    16	KunenaDatabaseObject->__construct()	JROOT/libraries/kunena/forum/message/message.php:141
    15	KunenaForumMessage->__construct()	JROOT/libraries/kunena/forum/message/helper.php:478
    14	KunenaForumMessageHelper::get()	JROOT/components/com_kunena/controller/topic/item/display.php:96
    13	ComponentKunenaControllerTopicItemDisplay->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/topic/default/default.php:13
    10	include JROOT/components/com_kunena/template/nts_kay/pages/topic/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.50 ms Dopo l'ultima query: 0.17 ms Memoria query: 0.025 MB memoria prima della query: 6.193 MB Righe restituite: 1

    SELECT m.*,t.message
    
      FROM `jos3_kunena_messages` AS `m`
    
      INNER JOIN `jos3_kunena_messages_text` AS `t` 
      ON `m`.`id` = `t`.`mesid`
    
      WHERE `m`.`id`=420

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	t	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.00 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.12 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    End of update loop	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.01 ms

    Call Stack

    #	Caller	File e numero di linea
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    18	JDatabaseDriver->loadAssoc()	JROOT/libraries/kunena/tables/kunenamessages.php:206
    17	TableKunenaMessages->load()	JROOT/libraries/kunena/database/object.php:247
    16	KunenaDatabaseObject->load()	JROOT/libraries/kunena/forum/message/message.php:1357
    15	KunenaForumMessage->load()	JROOT/libraries/kunena/forum/message/helper.php:481
    14	KunenaForumMessageHelper::get()	JROOT/components/com_kunena/controller/topic/item/display.php:96
    13	ComponentKunenaControllerTopicItemDisplay->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/topic/default/default.php:13
    10	include JROOT/components/com_kunena/template/nts_kay/pages/topic/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: 2.26 ms Dopo l'ultima query: 1.75 ms Memoria query: 0.023 MB memoria prima della query: 6.379 MB Righe restituite: 1

    SELECT COUNT(*)
    
      FROM jos3_kunena_messages AS a
    
      WHERE `thread` = '5315' 
      AND a.moved=0 
      AND a.hold IN (0)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	thread,hold	thread	5	const	399	Using where

    Profilo

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.03 ms
    Statistics	0.11 ms
    Preparing	0.03 ms
    Executing	0.00 ms
    Sending data	1.82 ms
    End of update loop	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.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
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    15	JDatabaseDriver->loadResult()	JROOT/libraries/kunena/database/object/finder.php:270
    14	KunenaDatabaseObjectFinder->count()	JROOT/components/com_kunena/controller/topic/item/display.php:133
    13	ComponentKunenaControllerTopicItemDisplay->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/topic/default/default.php:13
    10	include JROOT/components/com_kunena/template/nts_kay/pages/topic/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: 1.81 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.025 MB memoria prima della query: 6.389 MB Righe restituite: 10

    SELECT a.id
    
      FROM jos3_kunena_messages AS a
    
      WHERE `thread` = '5315' 
      AND a.moved=0 
      AND a.hold IN (0)
    
      ORDER BY a.`time` ASC 
      LIMIT 60, 10

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	thread,hold	thread	5	const	399	Using where; Using filesort

    Profilo

    Status	Duration
    Starting	0.06 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.05 ms
    Optimizing	0.02 ms
    Statistics	0.08 ms
    Preparing	0.03 ms
    Sorting result	0.02 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	1.37 ms
    End of update loop	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.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/libraries/kunena/database/object/finder.php:222
    15	KunenaDatabaseObjectFinder->find()	JROOT/libraries/kunena/forum/message/finder.php:227
    14	KunenaForumMessageFinder->find()	JROOT/components/com_kunena/controller/topic/item/display.php:139
    13	ComponentKunenaControllerTopicItemDisplay->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/topic/default/default.php:13
    10	include JROOT/components/com_kunena/template/nts_kay/pages/topic/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: 3.69 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.044 MB memoria prima della query: 6.394 MB Righe restituite: 10

    SELECT m.*, t.message 
      FROM jos3_kunena_messages AS m 
      INNER JOIN jos3_kunena_messages_text AS t 
      ON m.id=t.mesid 
      WHERE m.id IN (5626,5627,5628,5629,5632,5634,5636,5640,5643,5655)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	range	PRIMARY	PRIMARY	4	NULL	10	Using index condition
    1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	prepper.m.id	1

    Profilo

    Status	Duration
    Starting	0.05 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.03 ms
    Optimizing	0.02 ms
    Statistics	0.09 ms
    Preparing	0.03 ms
    Executing	0.00 ms
    Sending data	3.24 ms
    End of update loop	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
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
    17	JDatabaseDriver->loadAssocList()	JROOT/libraries/kunena/forum/message/helper.php:104
    16	KunenaForumMessageHelper::loadMessages()	JROOT/libraries/kunena/forum/message/helper.php:57
    15	KunenaForumMessageHelper::getMessages()	JROOT/libraries/kunena/forum/message/finder.php:229
    14	KunenaForumMessageFinder->find()	JROOT/components/com_kunena/controller/topic/item/display.php:139
    13	ComponentKunenaControllerTopicItemDisplay->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/topic/default/default.php:13
    10	include JROOT/components/com_kunena/template/nts_kay/pages/topic/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.29 ms Dopo l'ultima query: 0.98 ms Memoria query: 0.025 MB memoria prima della query: 6.490 MB Righe restituite: 0

    SELECT *
    				
      FROM jos3_kunena_thankyou
    				
      WHERE postid IN (5626,5627,5628,5629,5632,5634,5636,5640,5643,5655)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos3_kunena_thankyou	range	postid	postid	4	NULL	10	Using index condition

    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.02 ms
    Optimizing	0.01 ms
    Statistics	0.07 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
    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
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/forum/message/thankyou/helper.php:106
    16	KunenaForumMessageThankyouHelper::loadMessages()	JROOT/libraries/kunena/forum/message/thankyou/helper.php:399
    15	KunenaForumMessageThankyouHelper::getByMessage()	JROOT/components/com_kunena/controller/topic/item/display.php:199
    14	ComponentKunenaControllerTopicItemDisplay->prepareMessages()	JROOT/components/com_kunena/controller/topic/item/display.php:141
    13	ComponentKunenaControllerTopicItemDisplay->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/topic/default/default.php:13
    10	include JROOT/components/com_kunena/template/nts_kay/pages/topic/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.47 ms Dopo l'ultima query: 0.49 ms Memoria query: 0.028 MB memoria prima della query: 6.524 MB Righe restituite: 3

    SELECT u.name, u.username, u.email, u.block AS blocked, u.registerDate, u.lastvisitDate, ku.*, u.id AS userid
    
      FROM `jos3_users`AS u
    
      LEFT JOIN `jos3_kunena_users` AS ku 
      ON u.id = ku.userid
    
      WHERE u.id IN (185,150,138,42)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	u	range	PRIMARY	PRIMARY	4	NULL	4	Using where
    1	SIMPLE	ku	eq_ref	PRIMARY	PRIMARY	4	prepper.u.id	1

    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.00 ms
    init	0.04 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.13 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
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
    16	JDatabaseDriver->loadAssocList()	JROOT/libraries/kunena/user/helper.php:236
    15	KunenaUserHelper::loadUsers()	JROOT/components/com_kunena/controller/topic/item/display.php:254
    14	ComponentKunenaControllerTopicItemDisplay->prepareMessages()	JROOT/components/com_kunena/controller/topic/item/display.php:141
    13	ComponentKunenaControllerTopicItemDisplay->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/topic/default/default.php:13
    10	include JROOT/components/com_kunena/template/nts_kay/pages/topic/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.35 ms Dopo l'ultima query: 1.04 ms Memoria query: 0.025 MB memoria prima della query: 6.598 MB Righe restituite: 0

    SELECT * 
      FROM jos3_kunena_attachments 
      WHERE mesid IN (5626,5627,5628,5629,5632,5634,5636,5640,5643,5655)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos3_kunena_attachments	range	mesid	mesid	4	NULL	10	Using index condition

    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.02 ms
    Optimizing	0.01 ms
    Statistics	0.05 ms
    Preparing	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
    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.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/attachment/helper.php:229
    16	KunenaAttachmentHelper::loadByMessage()	JROOT/libraries/kunena/attachment/helper.php:293
    15	KunenaAttachmentHelper::getByMessage()	JROOT/components/com_kunena/controller/topic/item/display.php:257
    14	ComponentKunenaControllerTopicItemDisplay->prepareMessages()	JROOT/components/com_kunena/controller/topic/item/display.php:141
    13	ComponentKunenaControllerTopicItemDisplay->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/topic/default/default.php:13
    10	include JROOT/components/com_kunena/template/nts_kay/pages/topic/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.27 ms Dopo l'ultima query: 1.84 ms Memoria query: 0.025 MB memoria prima della query: 6.718 MB Righe restituite: 0

    SELECT * 
      FROM jos3_kunena_user_topics 
      WHERE user_id='0' 
      AND topic_id IN (5315)

    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.04 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.00 ms
    Executing	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.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
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
    18	JDatabaseDriver->loadAssocList()	JROOT/libraries/kunena/forum/topic/user/helper.php:146
    17	KunenaForumTopicUserHelper::loadTopics()	JROOT/libraries/kunena/forum/topic/user/helper.php:99
    16	KunenaForumTopicUserHelper::getTopics()	JROOT/libraries/kunena/forum/topic/user/helper.php:61
    15	KunenaForumTopicUserHelper::get()	JROOT/libraries/kunena/forum/topic/topic.php:224
    14	KunenaForumTopic->getUserTopic()	JROOT/components/com_kunena/controller/topic/item/display.php:183
    13	ComponentKunenaControllerTopicItemDisplay->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/topic/default/default.php:13
    10	include JROOT/components/com_kunena/template/nts_kay/pages/topic/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: 3.16 ms Dopo l'ultima query: 0.65 ms Memoria query: 0.029 MB memoria prima della query: 6.757 MB Righe restituite: 9

    SHOW FULL COLUMNS 
      FROM `jos3_kunena_user_topics`

    Explain

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

    Profilo

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.00 ms
    closing tables	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.22 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.01 ms
    Optimizing	0.00 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Filling schema table	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    checking permissions	0.05 ms
    closing tables	0.00 ms
    checking permissions	0.00 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
    Removing tmp table	0.08 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
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    25	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    24	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    23	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    22	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/kunena/tables/kunenausertopics.php:85
    21	TableKunenaUserTopics->__construct()	JROOT/libraries/src/Table/Table.php:312
    20	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/kunena/forum/topic/user/user.php:90
    19	KunenaForumTopicUser->getTable()	JROOT/libraries/kunena/forum/topic/user/user.php:59
    18	KunenaForumTopicUser->__construct()	JROOT/libraries/kunena/forum/topic/user/helper.php:164
    17	KunenaForumTopicUserHelper::loadTopics()	JROOT/libraries/kunena/forum/topic/user/helper.php:99
    16	KunenaForumTopicUserHelper::getTopics()	JROOT/libraries/kunena/forum/topic/user/helper.php:61
    15	KunenaForumTopicUserHelper::get()	JROOT/libraries/kunena/forum/topic/topic.php:224
    14	KunenaForumTopic->getUserTopic()	JROOT/components/com_kunena/controller/topic/item/display.php:183
    13	ComponentKunenaControllerTopicItemDisplay->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/topic/default/default.php:13
    10	include JROOT/components/com_kunena/template/nts_kay/pages/topic/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: 0.49 ms Dopo l'ultima query: 0.83 ms Memoria query: 0.029 MB memoria prima della query: 6.826 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.06 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.07 ms
    Optimizing	0.02 ms
    Statistics	0.08 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 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.01 ms
    Updating status	0.02 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:1459
    22	JDatabaseDriver->loadAssoc()	JROOT/libraries/kunena/tables/kunenausers.php:490
    21	TableKunenaUsers->load()	JROOT/libraries/kunena/user/user.php:194
    20	KunenaUser->load()	JROOT/libraries/kunena/user/user.php:164
    19	KunenaUser->__construct()	JROOT/libraries/kunena/user/helper.php:186
    18	KunenaUserHelper::get()	JROOT/libraries/kunena/user/helper.php:120
    17	KunenaUserHelper::getAuthor()	JROOT/libraries/kunena/forum/topic/topic.php:815
    16	KunenaForumTopic->getAuthor()	JROOT/components/com_kunena/controller/topic/item/display.php:383
    15	ComponentKunenaControllerTopicItemDisplay->prepareDocument()	JROOT/libraries/kunena/controller/display.php:224
    14	KunenaControllerDisplay->after()	JROOT/components/com_kunena/controller/topic/item/display.php:360
    13	ComponentKunenaControllerTopicItemDisplay->after()	JROOT/libraries/kunena/controller/display.php:138
    12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:119
    11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kay/pages/topic/default/default.php:13
    10	include JROOT/components/com_kunena/template/nts_kay/pages/topic/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: 5.12 ms Dopo l'ultima query: 13.63 ms Memoria query: 0.029 MB memoria prima della query: 7.834 MB Righe restituite: 68

    SELECT code, location 
      FROM jos3_kunena_smileys

    Explain

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

    Profilo

    Status	Duration
    Starting	0.08 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.00 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
    Sending data	0.07 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
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/bbcode/bbcode.php:1136
    19	KunenaBbcodeLibrary->__construct()	JROOT/libraries/kunena/bbcode/bbcode.php:56
    18	KunenaBbcode->__construct()	JROOT/libraries/kunena/bbcode/bbcode.php:91
    17	KunenaBbcode::getInstance()	JROOT/libraries/kunena/html/parser.php:260
    16	KunenaHtmlParser::stripBBCode()	JROOT/components/com_kunena/controller/topic/item/display.php:467
    15	ComponentKunenaControllerTopicItemDisplay->prepareDocument()	JROOT/libraries/kunena/controller/display.php:224
    14	KunenaControllerDisplay->after()	JROOT/components/com_kunena/controller/topic/item/display.php:360
    13	ComponentKunenaControllerTopicItemDisplay->after()	JROOT/libraries/kunena/controller/display.php:138
    12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:119
    11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kay/pages/topic/default/default.php:13
    10	include JROOT/components/com_kunena/template/nts_kay/pages/topic/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: 1.04 ms Dopo l'ultima query: 0.74 ms Memoria query: 0.008 MB memoria prima della query: 7.873 MB

    UPDATE jos3_kunena_topics
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '5315'

    Explain

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

    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.00 ms
    table lock	0.01 ms
    init for update	0.08 ms
    Updating	0.14 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.49 ms
    Query end	0.01 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
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1245
    15	Joomla\CMS\Table\Table->hit()	JROOT/libraries/kunena/forum/topic/topic.php:847
    14	KunenaForumTopic->hit()	JROOT/components/com_kunena/controller/topic/item/display.php:362
    13	ComponentKunenaControllerTopicItemDisplay->after()	JROOT/libraries/kunena/controller/display.php:138
    12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:119
    11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kay/pages/topic/default/default.php:13
    10	include JROOT/components/com_kunena/template/nts_kay/pages/topic/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: 1.27 ms Dopo l'ultima query: 18.25 ms Memoria query: 0.029 MB memoria prima della query: 8.251 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-09 08:56:11') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-05-09 08:56:11') 
      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.18 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.08 ms
    Optimizing	0.07 ms
    Statistics	0.13 ms
    Preparing	0.07 ms
    Sorting result	0.02 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.38 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.02 ms
    Updating status	0.03 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    26	JDatabaseDriver->loadObjectList()	Chiamata uguale alla linea sottostante.
    25	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    24	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
    23	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
    22	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    21	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
    20	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/components/com_kunena/layout/widget/module.php:33
    19	KunenaLayoutWidgetModule->renderPosition()	JROOT/components/com_kunena/template/nts_kay/layouts/widget/module/default.php:13
    18	include JROOT/components/com_kunena/template/nts_kay/layouts/widget/module/default.php	JROOT/libraries/kunena/layout/base.php:167
    17	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
    16	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:118
    15	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/nts_kay/layouts/topic/item/default.php:94
    14	include JROOT/components/com_kunena/template/nts_kay/layouts/topic/item/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/pages/topic/default/default.php:35
    10	include JROOT/components/com_kunena/template/nts_kay/pages/topic/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]

    ---

37. Tempo della query: 0.36 ms Dopo l'ultima query: 2.07 ms Memoria query: 0.028 MB memoria prima della query: 8.345 MB Righe restituite: 12

    SELECT *
    
      FROM `jos3_kunena_ranks`

    Explain

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

    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.01 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
    Sending data	0.04 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.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.02 ms
    Updating status	6.31 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/user/user.php:1352
    21	KunenaUser->getRank()	JROOT/libraries/kunena/user/user.php:1286
    20	KunenaUser->getSideProfile()	JROOT/components/com_kunena/template/nts_kay/layouts/topic/item/message/default.php:15
    19	include JROOT/components/com_kunena/template/nts_kay/layouts/topic/item/message/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/topic/item/default.php:109
    14	include JROOT/components/com_kunena/template/nts_kay/layouts/topic/item/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/pages/topic/default/default.php:35
    10	include JROOT/components/com_kunena/template/nts_kay/pages/topic/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]

    ---

38. Tempo della query: 0.50 ms Dopo l'ultima query: 6.62 ms Memoria query: 0.031 MB memoria prima della query: 8.456 MB Righe restituite: 0

    SELECT userid, MAX(time) AS time
    
      FROM `jos3_session`
    
      WHERE 
    (`client_id`=0) 
      AND 
    (`userid`>0)
    
      GROUP BY `userid`
    
      ORDER BY time DESC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos3_session	range	userid	userid	5	NULL	1	Using index condition; Using where; Using temporary; Using filesort

    Profilo

    Status	Duration
    Starting	0.08 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.04 ms
    Optimizing	0.02 ms
    Statistics	0.07 ms
    Preparing	0.02 ms
    Creating tmp table	0.02 ms
    Sorting for group	0.00 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.07 ms
    Creating sort index	0.01 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.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
    32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    31	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/user/helper.php:543
    30	KunenaUserHelper::getOnlineUsers()	JROOT/libraries/kunena/user/helper.php:581
    29	KunenaUserHelper::getStatus()	JROOT/libraries/kunena/user/user.php:501
    28	KunenaUser->getStatus()	JROOT/components/com_kunena/template/nts_kay/layouts/user/item/status/default.php:14
    27	include JROOT/components/com_kunena/template/nts_kay/layouts/user/item/status/default.php	JROOT/libraries/kunena/layout/base.php:167
    26	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
    25	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:118
    24	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/nts_kay/layouts/user/profile/default.php:55
    23	include JROOT/components/com_kunena/template/nts_kay/layouts/user/profile/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/topic/item/message/default.php:20
    19	include JROOT/components/com_kunena/template/nts_kay/layouts/topic/item/message/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/topic/item/default.php:109
    14	include JROOT/components/com_kunena/template/nts_kay/layouts/topic/item/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/pages/topic/default/default.php:35
    10	include JROOT/components/com_kunena/template/nts_kay/pages/topic/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]

    ---

39. Tempo della query: 0.59 ms Dopo l'ultima query: 11.48 ms Memoria query: 0.028 MB memoria prima della query: 8.580 MB Righe restituite: 0

    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 = 150

    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.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.06 ms
    Optimizing	0.02 ms
    Statistics	0.09 ms
    Preparing	0.01 ms
    Executing	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.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
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    24	JDatabaseDriver->loadAssoc()	JROOT/libraries/kunena/tables/kunenausers.php:490
    23	TableKunenaUsers->load()	JROOT/libraries/kunena/user/user.php:194
    22	KunenaUser->load()	JROOT/libraries/kunena/user/user.php:164
    21	KunenaUser->__construct()	JROOT/libraries/kunena/user/helper.php:186
    20	KunenaUserHelper::get()	JROOT/libraries/kunena/user/helper.php:120
    19	KunenaUserHelper::getAuthor()	JROOT/libraries/kunena/forum/message/message.php:1028
    18	KunenaForumMessage->getAuthor()	JROOT/components/com_kunena/controller/topic/item/message/display.php:57
    17	ComponentKunenaControllerTopicItemMessageDisplay->before()	JROOT/libraries/kunena/controller/display.php:125
    16	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:75
    15	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kay/layouts/topic/item/default.php:109
    14	include JROOT/components/com_kunena/template/nts_kay/layouts/topic/item/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/pages/topic/default/default.php:35
    10	include JROOT/components/com_kunena/template/nts_kay/pages/topic/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]

    ---

40. Tempo della query: 0.46 ms Dopo l'ultima query: 89.27 ms Memoria query: 0.023 MB memoria prima della query: 9.259 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-09 08:56:11') 
      AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-05-09 08:56:11')
    
      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.04 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.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.01 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]

    ---

41. Tempo della query: 0.46 ms Dopo l'ultima query: 8.33 ms Memoria query: 0.022 MB memoria prima della query: 9.260 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.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.02 ms
    Statistics	0.07 ms
    Preparing	0.03 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.01 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]

    ---

42. Tempo della query: 0.28 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.021 MB memoria prima della query: 9.267 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.03 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.03 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.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
    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]

    ---

43. Tempo della query: 0.48 ms Dopo l'ultima query: 18.62 ms Memoria query: 0.023 MB memoria prima della query: 9.336 MB Righe restituite: 0
    Query duplicate: #44

    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.08 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.03 ms
    Statistics	0.06 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.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
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    11	JDatabaseDriver->loadResult()	JROOT/templates/shape5_vertex/vertex/responsive/responsive_mobile_menu.php:139
    10	include JROOT/templates/shape5_vertex/vertex/responsive/responsive_mobile_menu.php	JROOT/templates/shape5_vertex/vertex/responsive/responsive_mobile_top_bar.php:75
    9	require JROOT/templates/shape5_vertex/vertex/responsive/responsive_mobile_top_bar.php	JROOT/templates/shape5_vertex/vertex/includes/vertex_includes_top.php:3
    8	require JROOT/templates/shape5_vertex/vertex/includes/vertex_includes_top.php	JROOT/templates/shape5_vertex/index.php:126
    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]

    ---

44. Tempo della query: 0.53 ms Dopo l'ultima query: 10.92 ms Memoria query: 0.021 MB memoria prima della query: 9.643 MB Righe restituite: 0
    Query duplicate: #43

    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.11 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.04 ms
    Optimizing	0.03 ms
    Statistics	0.09 ms
    Preparing	0.03 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.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: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]

    ---

45. Tempo della query: 7.24 ms Dopo l'ultima query: 0.44 ms Memoria query: 0.112 MB memoria prima della query: 9.672 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.08 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.03 ms
    Optimizing	0.02 ms
    Statistics	0.06 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.68 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	6.17 ms
    Reset for next command	0.03 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]

    ---

46. Tempo della query: 1.04 ms Dopo l'ultima query: 12.78 ms Memoria query: 0.025 MB memoria prima della query: 9.775 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.13 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.06 ms
    Optimizing	0.04 ms
    Statistics	0.26 ms
    Preparing	0.05 ms
    Executing	0.00 ms
    Sending data	0.08 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.04 ms
    Reset for next command	0.01 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]

    ---

47. Tempo della query: 1.04 ms Dopo l'ultima query: 7.72 ms Memoria query: 0.022 MB memoria prima della query: 9.929 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.11 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.16 ms
    Optimizing	0.04 ms
    Statistics	0.10 ms
    Preparing	0.03 ms
    Executing	0.00 ms
    Sending data	0.27 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.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
    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]

    ---

48. Tempo della query: 5.53 ms Dopo l'ultima query: 2.05 ms Memoria query: 0.023 MB memoria prima della query: 9.949 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.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.15 ms
    Preparing	0.03 ms
    Executing	0.00 ms
    Sending data	0.05 ms
    End of update loop	0.00 ms
    Query end	0.01 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
    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]

    ---