Scorte alimentari: voi come le fate?

Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1732390582,
                "last": 1732390582,
                "now": 1732390582
            },
            "token": "LGdbbQTAQhcxpzaicN4GG22vTCPGVyZj"
        },
        "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": 664
                }
            }
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Informazioni profilo

Utilizzo memoria

Query Database

49 query eseguite 73.62 ms

Trovati 4 duplicati!

2 duplicati: #8 #46

2 duplicati: #44 #45

Tempo della query: 0.31 ms Memoria query: 0.023 MB memoria prima della query: 1.017 MB Righe restituite: 0

SELECT `data`

  FROM `jos3_session`

  WHERE `session_id` = '01s6mlc24v3ea79kfpeovfgiqo'

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.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 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
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]

Tempo della query: 0.22 ms Dopo l'ultima query: 0.28 ms Memoria query: 0.020 MB memoria prima della query: 1.031 MB Righe restituite: 0

SELECT `session_id`

  FROM `jos3_session`

  WHERE `session_id` = '01s6mlc24v3ea79kfpeovfgiqo' 
  LIMIT 1

Explain

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

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.01 ms
Optimizing	0.01 ms
Statistics	0.02 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	2.35 ms
Reset for next command	0.02 ms

Call Stack

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

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

Tempo della query: 1.86 ms Dopo l'ultima query: 2.48 ms Memoria query: 0.004 MB memoria prima della query: 1.036 MB

INSERT INTO `jos3_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('01s6mlc24v3ea79kfpeovfgiqo', 1, 1732390582, 0, '', 0)

Explain

EXPLAIN non possibile sulla query: INSERT INTO `jos3_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('01s6mlc24v3ea79kfpeovfgiqo', 1, 1732390582, 0, '', 0)

Profilo

Status	Duration
Starting	0.11 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.00 ms
init for update	0.02 ms
Update	0.21 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	1.29 ms
Query end	0.01 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.02 ms
Reset for next command	0.00 ms

Call Stack

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

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

Tempo della query: 0.56 ms Dopo l'ultima query: 0.50 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.06 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.00 ms
init	0.02 ms
Optimizing	0.04 ms
Statistics	0.08 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.14 ms
End of update loop	0.00 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.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.44 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]

Tempo della query: 0.22 ms Dopo l'ultima query: 0.35 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.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.01 ms
Optimizing	0.00 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.04 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

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

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

Tempo della query: 0.28 ms Dopo l'ultima query: 0.09 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.03 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.02 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.00 ms
Unlocking tables	0.00 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: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]

Tempo della query: 0.71 ms Dopo l'ultima query: 0.14 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.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.05 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.01 ms
Sorting result	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.41 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.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: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]

Tempo della query: 1.45 ms Dopo l'ultima query: 10.88 ms Memoria query: 0.112 MB memoria prima della query: 1.621 MB Righe restituite: 68

Query duplicate: #46

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

  FROM 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.13 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.94 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	4.62 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]

Tempo della query: 0.44 ms Dopo l'ultima query: 18.14 ms Memoria query: 0.025 MB memoria prima della query: 2.250 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.07 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 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
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]

Tempo della query: 4.51 ms Dopo l'ultima query: 1.55 ms Memoria query: 0.022 MB memoria prima della query: 2.345 MB Righe restituite: 1

SELECT * 
  FROM jos3_kunena_aliases 
  WHERE alias LIKE '13-scorte-e-checklist%'

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.07 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.02 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.06 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.04 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

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

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

Tempo della query: 0.48 ms Dopo l'ultima query: 0.32 ms Memoria query: 0.024 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.06 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.03 ms
Optimizing	0.02 ms
Statistics	0.09 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.06 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.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: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]

Tempo della query: 0.30 ms Dopo l'ultima query: 0.22 ms Memoria query: 0.006 MB memoria prima della query: 2.363 MB

UPDATE `jos3_extensions`

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

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

Explain

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

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.00 ms
init for update	0.07 ms
Updating	0.05 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.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/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]

Tempo della query: 0.35 ms Dopo l'ultima query: 0.74 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.04 ms
checking permissions	0.00 ms
Opening tables	0.04 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.01 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.06 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.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
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]

Tempo della query: 0.46 ms Dopo l'ultima query: 0.28 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.06 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.00 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.06 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.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
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]

Tempo della query: 0.92 ms Dopo l'ultima query: 8.13 ms Memoria query: 0.025 MB memoria prima della query: 2.685 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.06 ms
checking permissions	0.00 ms
closing tables	0.00 ms
checking permissions	0.00 ms
Opening tables	0.32 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 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.11 ms
closing tables	0.02 ms
checking permissions	0.00 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
Removing tmp table	0.11 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
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]

Tempo della query: 5.02 ms Dopo l'ultima query: 3.31 ms Memoria query: 0.035 MB memoria prima della query: 2.968 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.04 ms
checking permissions	0.00 ms
closing tables	0.00 ms
checking permissions	0.00 ms
Opening tables	0.21 ms
After opening tables	0.00 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	4.13 ms
After opening tables	0.01 ms
checking permissions	0.17 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.11 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
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]

Tempo della query: 0.85 ms Dopo l'ultima query: 3.31 ms Memoria query: 0.028 MB memoria prima della query: 3.065 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.08 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.01 ms
Statistics	0.10 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.30 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
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]

Tempo della query: 2.44 ms Dopo l'ultima query: 0.55 ms Memoria query: 0.024 MB memoria prima della query: 3.131 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	3284	Using where; Using index; Using join buffer (flat, BNL join)

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.00 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.09 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.03 ms
Creating tmp table	0.08 ms
Executing	0.01 ms
Sending data	1.83 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.02 ms
Reset for next command	0.02 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]

Tempo della query: 5.58 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.024 MB memoria prima della query: 3.140 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	3284	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.25 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.10 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.03 ms
Creating tmp table	0.06 ms
Executing	0.00 ms
Sending data	2.56 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]

Tempo della query: 0.37 ms Dopo l'ultima query: 0.20 ms Memoria query: 0.023 MB memoria prima della query: 3.148 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.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.06 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.04 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File e numero di linea
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]

Tempo della query: 0.99 ms Dopo l'ultima query: 0.78 ms Memoria query: 0.098 MB memoria prima della query: 3.182 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.02 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.00 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Sorting result	0.00 ms
Executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.47 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.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]

Tempo della query: 1.86 ms Dopo l'ultima query: 3.16 ms Memoria query: 0.037 MB memoria prima della query: 3.522 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.05 ms
checking permissions	0.00 ms
closing tables	0.00 ms
checking permissions	0.00 ms
Opening tables	0.23 ms
After opening tables	0.00 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.02 ms
After opening tables	0.00 ms
checking permissions	0.12 ms
closing tables	0.00 ms
checking permissions	0.00 ms
Executing	0.00 ms
Sending data	0.06 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.11 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
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]

Tempo della query: 0.63 ms Dopo l'ultima query: 1.29 ms Memoria query: 0.032 MB memoria prima della query: 3.649 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.03 ms
checking permissions	0.00 ms
closing tables	0.00 ms
checking permissions	0.00 ms
Opening tables	0.16 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.04 ms
After opening tables	0.00 ms
checking permissions	0.07 ms
closing tables	0.01 ms
checking permissions	0.00 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
Removing tmp table	0.06 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
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]

Tempo della query: 0.37 ms Dopo l'ultima query: 0.20 ms Memoria query: 0.025 MB memoria prima della query: 3.691 MB Righe restituite: 1

SELECT *

  FROM `jos3_kunena_topics`

  WHERE `id`=664

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.08 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 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
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]

Tempo della query: 1.12 ms Dopo l'ultima query: 0.34 ms Memoria query: 0.031 MB memoria prima della query: 3.713 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.36 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.08 ms
After opening tables	0.00 ms
checking permissions	0.11 ms
closing tables	0.02 ms
checking permissions	0.01 ms
Executing	0.00 ms
Sending data	0.09 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.11 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.04 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]

Tempo della query: 0.59 ms Dopo l'ultima query: 0.22 ms Memoria query: 0.025 MB memoria prima della query: 3.748 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`=664

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.00 ms
Opening tables	0.04 ms
After opening tables	0.00 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.21 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	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.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/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]

Tempo della query: 1.59 ms Dopo l'ultima query: 0.42 ms Memoria query: 0.023 MB memoria prima della query: 3.771 MB Righe restituite: 1

SELECT COUNT(*)

  FROM jos3_kunena_messages AS a

  WHERE `thread` = '664' 
  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	315	Using where

Profilo

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.13 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	1.21 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
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]

Tempo della query: 1.56 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.025 MB memoria prima della query: 3.781 MB Righe restituite: 10

SELECT a.id

  FROM jos3_kunena_messages AS a

  WHERE `thread` = '664' 
  AND a.moved=0 
  AND a.hold IN (0)

  ORDER BY a.`time` ASC 
  LIMIT 80, 10

Explain

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

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.00 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.11 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	1.16 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.03 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/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]

Tempo della query: 0.86 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.029 MB memoria prima della query: 3.787 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 (8371,8378,8383,8384,8386,8387,8388,8393,8395,8398)

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.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.13 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.31 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.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: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]

Tempo della query: 0.44 ms Dopo l'ultima query: 0.52 ms Memoria query: 0.025 MB memoria prima della query: 3.851 MB Righe restituite: 0

SELECT *
				
  FROM jos3_kunena_thankyou
				
  WHERE postid IN (8371,8378,8383,8384,8386,8387,8388,8393,8395,8398)

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.04 ms
checking permissions	0.00 ms
Opening tables	0.04 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.12 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.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]

Tempo della query: 0.81 ms Dopo l'ultima query: 0.20 ms Memoria query: 0.028 MB memoria prima della query: 3.867 MB Righe restituite: 4

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 (147,95,51,149)

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.05 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.32 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.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
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]

Tempo della query: 0.46 ms Dopo l'ultima query: 0.29 ms Memoria query: 0.025 MB memoria prima della query: 3.908 MB Righe restituite: 0

SELECT * 
  FROM jos3_kunena_attachments 
  WHERE mesid IN (8371,8378,8383,8384,8386,8387,8388,8393,8395,8398)

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.04 ms
checking permissions	0.00 ms
Opening tables	0.08 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.08 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.00 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
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]

Tempo della query: 0.41 ms Dopo l'ultima query: 0.23 ms Memoria query: 0.026 MB memoria prima della query: 3.927 MB Righe restituite: 0

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

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.05 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.09 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.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File e numero di linea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
18	JDatabaseDriver->loadAssocList()	JROOT/libraries/kunena/forum/topic/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]

Tempo della query: 0.93 ms Dopo l'ultima query: 0.26 ms Memoria query: 0.029 MB memoria prima della query: 3.945 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.31 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
checking permissions	0.13 ms
closing tables	0.01 ms
checking permissions	0.01 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
Removing tmp table	0.20 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/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]

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

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

Explain

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

Profilo

Status	Duration
Starting	0.05 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.04 ms
Optimizing	0.01 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.09 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.09 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: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]

Tempo della query: 0.67 ms Dopo l'ultima query: 3.31 ms Memoria query: 0.029 MB memoria prima della query: 4.197 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.05 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.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.11 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
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]

Tempo della query: 0.99 ms Dopo l'ultima query: 0.75 ms Memoria query: 0.008 MB memoria prima della query: 4.237 MB

UPDATE jos3_kunena_topics

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

  WHERE `id` = '664'

Explain

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

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.00 ms
init for update	0.09 ms
Updating	0.19 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.46 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.02 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]

Tempo della query: 2.60 ms Dopo l'ultima query: 5.62 ms Memoria query: 0.029 MB memoria prima della query: 4.359 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 <= '2024-11-23 19:36:22') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-23 19:36:22') 
  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.24 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.06 ms
Optimizing	0.14 ms
Statistics	0.14 ms
Preparing	0.07 ms
Sorting result	0.02 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.41 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.03 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
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]

Tempo della query: 0.33 ms Dopo l'ultima query: 1.10 ms Memoria query: 0.028 MB memoria prima della query: 4.398 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.03 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.04 ms
End of update loop	0.00 ms
Query end	0.00 ms
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
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]

Tempo della query: 0.70 ms Dopo l'ultima query: 9.77 ms Memoria query: 0.031 MB memoria prima della query: 4.458 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.11 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.06 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.03 ms
Creating tmp table	0.07 ms
Sorting for group	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
Creating sort index	0.02 ms
Removing tmp table	0.01 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.02 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]

Tempo della query: 4.65 ms Dopo l'ultima query: 53.47 ms Memoria query: 0.023 MB memoria prima della query: 4.864 MB Righe restituite: 0

SELECT *

  FROM jos3_kunena_announcement

  WHERE (published = 1) 
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-11-23 19:36:22') 
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-11-23 19:36:22')

  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.14 ms
checking permissions	0.01 ms
Opening tables	0.10 ms
After opening tables	0.01 ms
System lock	0.02 ms
table lock	0.01 ms
init	0.08 ms
Optimizing	0.07 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	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
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]

Tempo della query: 8.02 ms Dopo l'ultima query: 2.03 ms Memoria query: 0.022 MB memoria prima della query: 4.879 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.08 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.02 ms
Statistics	0.12 ms
Preparing	0.04 ms
Executing	0.00 ms
Sending data	0.07 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File e numero di linea
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]

Tempo della query: 0.74 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.021 MB memoria prima della query: 4.887 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.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.06 ms
Optimizing	0.03 ms
Statistics	0.11 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.09 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File e numero di linea
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]

Tempo della query: 0.64 ms Dopo l'ultima query: 22.90 ms Memoria query: 0.023 MB memoria prima della query: 4.955 MB Righe restituite: 0

Query duplicate: #45

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.09 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.14 ms
Preparing	0.04 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File e numero di linea
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]

Tempo della query: 0.53 ms Dopo l'ultima query: 16.82 ms Memoria query: 0.021 MB memoria prima della query: 5.262 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.09 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.08 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]

Tempo della query: 1.33 ms Dopo l'ultima query: 0.97 ms Memoria query: 0.112 MB memoria prima della query: 5.292 MB Righe restituite: 68

Query duplicate: #8

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

  FROM jos3_menu AS m

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

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

  ORDER BY m.lft

Explain

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

Profilo

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.08 ms
Statistics	0.08 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.79 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.63 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: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]

Tempo della query: 4.31 ms Dopo l'ultima query: 21.56 ms Memoria query: 0.025 MB memoria prima della query: 5.395 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.11 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.13 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.06 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.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]

Tempo della query: 6.25 ms Dopo l'ultima query: 3.80 ms Memoria query: 0.022 MB memoria prima della query: 5.548 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.14 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.26 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.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
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]

Tempo della query: 1.26 ms Dopo l'ultima query: 1.59 ms Memoria query: 0.023 MB memoria prima della query: 5.568 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.25 ms
checking permissions	0.01 ms
Opening tables	0.10 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.06 ms
Optimizing	0.03 ms
Statistics	0.27 ms
Preparing	0.04 ms
Executing	0.00 ms
Sending data	0.12 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.04 ms
Reset for next command	0.01 ms

Call Stack

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

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

45 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

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

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `jos3_extensions`

2 × SELECT menutype  
  FROM  jos3_menu

2 × 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

1 × SELECT `data` 
  FROM `jos3_session`

1 × SELECT * 
  FROM jos3_kunena_attachments

1 × SELECT * 
  FROM jos3_kunena_user_topics

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

1 × SELECT code, location 
  FROM jos3_kunena_smiley

1 × 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

1 × SELECT * 
  FROM jos3_kunena_announcement

1 × SELECT * 
  FROM `jos3_kunena_ranks

1 × SELECT userid, MAX(time) AS time 
  FROM `jos3_session`

1 × SELECT *     
  FROM jos3_kunena_thankyou

1 × SELECT * 
  FROM jos3_template_styles

```
1 × SELECT * 
  FROM jos3_menu
```

1 × SELECT `extension_id`,`name`,`enabled`,`params` 
  FROM jos3_extensions

1 × SELECT `name`,`element` 
  FROM `jos3_extensions`

1 × 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

1 × SELECT a.id 
  FROM jos3_kunena_messages AS a

1 × SELECT m.*, t.message 
  FROM jos3_kunena_messages AS m 
  INNER JOIN jos3_kunena_messages_text AS t 
  ON m.id=t.mesid

1 × SELECT `session_id` 
  FROM `jos3_session`

1 × SELECT COUNT(*) 
  FROM jos3_kunena_messages AS a

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

1 × SELECT * 
  FROM `jos3_kunena_topics`

1 × SELECT * 
  FROM jos3_kunena_categories

1 × SELECT `user_id`,`category_id`,`role` 
  FROM `jos3_kunena_user_categories`

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

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

```
1 × SELECT * 
  FROM jos3_languages
```

1 × SELECT * 
  FROM jos3_kunena_aliases

1 × SELECT * 
  FROM `jos3_kunena_configuration`

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM jos3_extensions

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

1 × SELECT id, rules 
  FROM `jos3_viewlevels

1 × SELECT `title` 
  FROM `jos3_finder_taxonomy`

ALTRE tabelle:

1 × INSERT INTO `jos3_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('01s6mlc24v3ea79kfpeovfgiqo', 1, 1732390582, 0, '', 0

1 × UPDATE `jos3_extensions` 
  SET `params` = '{\"mediaversion\":\"bc34237be594be6e2ab3bc908e64d69f\"}'

1 × SHOW FULL COLUMNS 
  FROM `jos3_kunena_sessions

1 × SHOW FULL COLUMNS 
  FROM `jos3_kunena_users

1 × SHOW FULL COLUMNS 
  FROM `jos3_kunena_categories

1 × SHOW FULL COLUMNS 
  FROM `jos3_kunena_topics

1 × SHOW FULL COLUMNS 
  FROM `jos3_kunena_messages

1 × SHOW FULL COLUMNS 
  FROM `jos3_kunena_user_topics

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