Console Debug Joomla!

{
    "__default": {
        "session": {
            "counter": 6,
            "timer": {
                "start": 1793220311,
                "last": 1793220331,
                "now": 1793220336
            },
            "token": "h4bSQGTrQyatYJQVsf8Y9mIKGXb0cReX"
        },
        "registry": {
            "com_users": {
                "edit": {
                    "profile": {
                        "id": 0
                    }
                }
            },
            "com_kunena": {
                "user0_read": {
                    "4": 4,
                    "20": 20,
                    "10": 10,
                    "14": 14,
                    "2": 2,
                    "1": 1,
                    "7": 7,
                    "3": 3,
                    "15": 15,
                    "11": 11,
                    "5": 5,
                    "21": 21,
                    "22": 22,
                    "12": 12,
                    "8": 8,
                    "9": 9,
                    "16": 16,
                    "18": 18,
                    "13": 13,
                    "17": 17,
                    "19": 19
                }
            }
        },
        "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
        },
        "jsn_original_id": 0,
        "462641482c47e93c6b42203590facade": 1,
        "36563071e13c1e2caacdac4dd0e1af3f": 1
    },
    "__easyblog": {
        "site": {
            "messages": null
        }
    }
}

Tempo

Memoria

64 query eseguite 60.32 ms

1. Tempo della query: 0.59 ms Memoria query: 0.026 MB memoria prima della query: 1.145 MB Righe restituite: 1

   SELECT `data`
   
     FROM `avjbq_session`
   
     WHERE `session_id` = 'af320839e60d06e2147f31b56270cfb3'

   Explain

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

   Profilo

   Status	Duration
   Starting	0.07 ms
   checking permissions	0.03 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.08 ms
   Optimizing	0.02 ms
   Statistics	0.05 ms
   Preparing	0.01 ms
   Unlocking tables	0.02 ms
   Preparing	0.01 ms
   Executing	0.00 ms
   Sending data	0.02 ms
   End of update loop	0.03 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.01 ms
   closing tables	0.02 ms
   Query end	0.01 ms
   Starting cleanup	0.04 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
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Chiamata uguale alla linea sottostante.
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
   10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:861
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
   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:458
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

2. Tempo della query: 0.80 ms Dopo l'ultima query: 1.49 ms Memoria query: 0.043 MB memoria prima della query: 1.264 MB Righe restituite: 48

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `avjbq_extensions`
   
     WHERE `type` = 'component'

   Explain

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

   Profilo

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

   Call Stack

   #	Caller	File e numero di linea
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
   11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:423
   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:431
   7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:497
   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:596
   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:310
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

3. Tempo della query: 0.47 ms Dopo l'ultima query: 1.19 ms Memoria query: 0.023 MB memoria prima della query: 1.327 MB Righe restituite: 13

   SELECT id, rules
   
     FROM `avjbq_viewlevels`

   Explain

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

   Profilo

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

   Call Stack

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

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

   ---

4. Tempo della query: 0.52 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.023 MB memoria prima della query: 1.342 MB Righe restituite: 2

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

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
   1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	Using where; Using index

   Profilo

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

   Call Stack

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

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

   ---

5. Tempo della query: 1.17 ms Dopo l'ultima query: 0.28 ms Memoria query: 0.041 MB memoria prima della query: 1.364 MB Righe restituite: 182

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

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	avjbq_extensions	ALL	extension	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	473	Using where; Using filesort

   Profilo

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

   Call Stack

   #	Caller	File e numero di linea
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:343
   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:348
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:606
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:310
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

6. Tempo della query: 1.84 ms Dopo l'ultima query: 8.80 ms Memoria query: 0.179 MB memoria prima della query: 1.988 MB Righe restituite: 144

   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 avjbq_menu AS m
   
     LEFT JOIN avjbq_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	154	Using index condition; Using where; Using filesort
   1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	aqtpboka_pc_crash.m.component_id	1	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.03 ms
   Optimizing	0.03 ms
   Statistics	0.09 ms
   Preparing	0.07 ms
   Sorting result	0.02 ms
   Executing	0.01 ms
   Sending data	0.02 ms
   Creating sort index	1.17 ms
   End of update loop	0.02 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.02 ms
   Updating status	0.03 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Caller	File e numero di linea
   22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
   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:489
   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:594
   9	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:405
   8	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/jmap/jmap.php:818
   7	plgSystemJMap->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:272
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:728
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:310
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

7. Tempo della query: 0.49 ms Dopo l'ultima query: 16.22 ms Memoria query: 0.026 MB memoria prima della query: 3.148 MB Righe restituite: 33

   SELECT *
   
     FROM avjbq_rsform_config

   Explain

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

   Profilo

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

   Call Stack

   #	Caller	File e numero di linea
   13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
   12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsform/helpers/config.php:50
   11	RSFormProConfig->load()	JROOT/administrator/components/com_rsform/helpers/config.php:17
   10	RSFormProConfig->__construct()	JROOT/administrator/components/com_rsform/helpers/config.php:97
   9	RSFormProConfig::getInstance()	JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php:28
   8	plgSystemRsformdeletesubmissions->onAfterInitialise()	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:729
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:310
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

8. Tempo della query: 0.66 ms Dopo l'ultima query: 6.26 ms Memoria query: 0.024 MB memoria prima della query: 3.414 MB Righe restituite: 3

   SELECT id, home, template, s.params
   
     FROM avjbq_template_styles as s
   
     LEFT JOIN avjbq_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	s	ALL	idx_template	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	4	Using where
   1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	aqtpboka_pc_crash.s.template,const	1	Using index condition; Using where

   Profilo

   Status	Duration
   Starting	0.08 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.03 ms
   Optimizing	0.03 ms
   Statistics	0.07 ms
   Preparing	0.04 ms
   Executing	0.01 ms
   Sending data	0.10 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.02 ms
   Query end	0.02 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.02 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:1691
   11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:488
   10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/t3/includes/core/t3.php:307
   9	T3::detect()	JROOT/plugins/system/t3/t3.php:81
   8	plgSystemT3->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:1186
   4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
   3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:310
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

9. Tempo della query: 0.97 ms Dopo l'ultima query: 3.44 ms Memoria query: 0.029 MB memoria prima della query: 3.652 MB Righe restituite: 48

   SELECT `id`,`name`,`rules`,`parent_id`
   
     FROM `avjbq_assets`
   
     WHERE `name` IN ('root.1','com_acymailing','com_acysms','com_admin','com_advpoll','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_easyblog','com_edocman','com_eventbooking','com_fields','com_finder','com_helpdeskpro','com_installer','com_jaextmanager','com_jce','com_jmap','com_joomailermailchimpintegration','com_joomlaupdate','com_jsn','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_rsform','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

   Explain

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

   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.06 ms
   Optimizing	0.02 ms
   Statistics	0.15 ms
   Preparing	0.02 ms
   Executing	0.01 ms
   Sending data	0.34 ms
   End of update loop	0.03 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.01 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
   15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
   14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
   13	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
   12	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
   11	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
   10	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
   9	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/jsn_system/jsn_system.php:116
   8	plgSystemJsn_System->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:1186
   4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
   3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:310
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

10. Tempo della query: 0.40 ms Dopo l'ultima query: 3.64 ms Memoria query: 0.025 MB memoria prima della query: 3.999 MB Righe restituite: 19

    SELECT * 
      FROM avjbq_acysms_config

    Explain

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

    Profilo

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.02 ms
    Statistics	0.01 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.06 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 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
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acysms/classes/cpanel.php:17
    12	ACYSMScpanelClass->load()	JROOT/administrator/components/com_acysms/helpers/helper.php:265
    11	ACYSMS::config()	JROOT/administrator/components/com_acysms/helpers/helper.php:774
    10	include_once JROOT/administrator/components/com_acysms/helpers/helper.php	JROOT/plugins/system/acysmsverifnumber/acysmsverifnumber.php:30
    9	plgSystemAcySMSVerifNumber->init()	JROOT/plugins/system/acysmsverifnumber/acysmsverifnumber.php:48
    8	plgSystemAcySMSVerifNumber->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:1186
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:310
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

11. Tempo della query: 0.42 ms Dopo l'ultima query: 1.84 ms Memoria query: 0.030 MB memoria prima della query: 4.051 MB Righe restituite: 1

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

    Explain

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

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
    27	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
    26	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	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/LibraryHelper.php:175
    23	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
    22	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
    21	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
    20	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    19	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    18	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/HTML/HTMLHelper.php:731
    17	Joomla\CMS\HTML\HTMLHelper::script()	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/libraries/cms/html/behavior.php:63
    13	JHtmlBehavior::framework()	Chiamata uguale alla linea sottostante.
    12	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    11	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    10	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/administrator/components/com_acysms/compat/compat3.php:35
    9	acysms_loadMootools()	JROOT/plugins/system/acysmsverifnumber/acysmsverifnumber.php:49
    8	plgSystemAcySMSVerifNumber->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:1186
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:310
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

12. Tempo della query: 0.99 ms Dopo l'ultima query: 0.21 ms Memoria query: 0.010 MB memoria prima della query: 4.047 MB

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

    Explain

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

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    22	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    21	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    20	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    19	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    18	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/HTML/HTMLHelper.php:731
    17	Joomla\CMS\HTML\HTMLHelper::script()	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/libraries/cms/html/behavior.php:63
    13	JHtmlBehavior::framework()	Chiamata uguale alla linea sottostante.
    12	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    11	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    10	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/administrator/components/com_acysms/compat/compat3.php:35
    9	acysms_loadMootools()	JROOT/plugins/system/acysmsverifnumber/acysmsverifnumber.php:49
    8	plgSystemAcySMSVerifNumber->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:1186
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:310
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

13. Tempo della query: 0.44 ms Dopo l'ultima query: 1.11 ms Memoria query: 0.025 MB memoria prima della query: 4.091 MB Righe restituite: 2

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

    Explain

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

    Profilo

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.02 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 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.05 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 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
    7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    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:310
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

14. Tempo della query: 2.68 ms Dopo l'ultima query: 3.06 ms Memoria query: 0.083 MB memoria prima della query: 4.267 MB Righe restituite: 397

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `avjbq_assets`
    
      WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	avjbq_assets	index_merge	idx_asset_name,idx_parent_id	idx_asset_name,idx_parent_id	202,4	NULL	846	Using sort_union(idx_asset_name,idx_parent_id); Using where

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
    18	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
    17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
    16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    14	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
    13	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435
    12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:310
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

15. Tempo della query: 1.06 ms Dopo l'ultima query: 1.45 ms Memoria query: 0.038 MB memoria prima della query: 4.601 MB Righe restituite: 3

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,(
    SELECT COUNT(i.`id`)
    
      FROM `avjbq_content` AS `i`
    
      WHERE i.`catid` = c.id 
      AND i.state = 1) AS numitems
    
      FROM `avjbq_categories` AS `s`
    
      INNER JOIN `avjbq_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.published = 1 
      AND s.id = 28
    
      ORDER BY c.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    1	PRIMARY	c	ALL	cat_idx,idx_left_right	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	48	Using where; Using filesort
    2	DEPENDENT SUBQUERY	i	ref	idx_state,idx_catid	idx_catid	4	aqtpboka_pc_crash.c.id	3	Using index condition; Using where

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:314
    15	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
    14	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/models/category.php:355
    13	ContentModelCategory->getCategory()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
    12	JViewLegacy->get()	JROOT/libraries/src/MVC/View/CategoryView.php:122
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:310
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

16. Tempo della query: 2.08 ms Dopo l'ultima query: 0.97 ms Memoria query: 0.042 MB memoria prima della query: 4.647 MB Righe restituite: 4

    SELECT DISTINCT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2 
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating, 
    							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
    
      FROM avjbq_content AS a
    
      LEFT JOIN avjbq_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN avjbq_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN avjbq_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN avjbq_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN avjbq_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.catid = 28 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-10-28 20:45:36') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-10-28 20:45:36')
    
      ORDER BY  c.lft,   
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC ,  a.created

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	Using temporary; Using filesort
    1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	4	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	aqtpboka_pc_crash.a.created_by	1	Using where
    1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	aqtpboka_pc_crash.a.modified_by	1	Using where
    1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where
    1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	aqtpboka_pc_crash.a.id	1	Using where

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:558
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    13	ContentModelCategory->getItems()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
    12	JViewLegacy->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:310
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

17. Tempo della query: 0.67 ms Dopo l'ultima query: 0.79 ms Memoria query: 0.037 MB memoria prima della query: 4.742 MB Righe restituite: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `avjbq_contentitem_tag_map` AS m 
    
      INNER JOIN `avjbq_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 71 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	t	range	PRIMARY,tag_idx,idx_access	idx_access	4	NULL	2	Using index condition; Using where
    1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	aqtpboka_pc_crash.t.id	12	Using index condition; Using where

    Profilo

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.02 ms
    table lock	0.01 ms
    init	0.05 ms
    Optimizing	0.03 ms
    Statistics	0.07 ms
    Preparing	0.04 ms
    Executing	0.01 ms
    Sending data	0.07 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 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:1691
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:688
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    13	ContentModelCategory->getItems()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
    12	JViewLegacy->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:310
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

18. Tempo della query: 0.62 ms Dopo l'ultima query: 0.29 ms Memoria query: 0.037 MB memoria prima della query: 4.765 MB Righe restituite: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `avjbq_contentitem_tag_map` AS m 
    
      INNER JOIN `avjbq_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 74 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	t	range	PRIMARY,tag_idx,idx_access	idx_access	4	NULL	2	Using index condition; Using where
    1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	aqtpboka_pc_crash.t.id	12	Using index condition; Using where

    Profilo

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.02 ms
    Opening tables	0.02 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.04 ms
    Executing	0.01 ms
    Sending data	0.06 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 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:1691
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:688
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    13	ContentModelCategory->getItems()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
    12	JViewLegacy->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:310
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

19. Tempo della query: 0.52 ms Dopo l'ultima query: 0.35 ms Memoria query: 0.037 MB memoria prima della query: 4.788 MB Righe restituite: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `avjbq_contentitem_tag_map` AS m 
    
      INNER JOIN `avjbq_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 75 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	t	range	PRIMARY,tag_idx,idx_access	idx_access	4	NULL	2	Using index condition; Using where
    1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	aqtpboka_pc_crash.t.id	12	Using index condition; Using where

    Profilo

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.06 ms
    End of update loop	0.02 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 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:1691
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:688
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    13	ContentModelCategory->getItems()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
    12	JViewLegacy->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:310
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

20. Tempo della query: 0.60 ms Dopo l'ultima query: 0.33 ms Memoria query: 0.037 MB memoria prima della query: 4.811 MB Righe restituite: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `avjbq_contentitem_tag_map` AS m 
    
      INNER JOIN `avjbq_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 76 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	t	range	PRIMARY,tag_idx,idx_access	idx_access	4	NULL	2	Using index condition; Using where
    1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	aqtpboka_pc_crash.t.id	12	Using index condition; Using where

    Profilo

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.07 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.05 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:1691
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:688
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    13	ContentModelCategory->getItems()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
    12	JViewLegacy->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:310
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

21. Tempo della query: 0.91 ms Dopo l'ultima query: 0.38 ms Memoria query: 0.026 MB memoria prima della query: 4.828 MB Righe restituite: 1

    SELECT COUNT(*)
    
      FROM avjbq_content AS a
    
      LEFT JOIN avjbq_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN avjbq_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN avjbq_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN avjbq_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN avjbq_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.catid = 28 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-10-28 20:45:36') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-10-28 20:45:36')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
    1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	4	Using where

    Profilo

    Status	Duration
    Starting	0.12 ms
    checking permissions	0.02 ms
    Opening tables	0.07 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.05 ms
    Optimizing	0.06 ms
    Statistics	0.18 ms
    Preparing	0.02 ms
    Unlocking tables	0.01 ms
    Preparing	0.04 ms
    Executing	0.04 ms
    Sending data	0.05 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.02 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:1730
    17	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:335
    16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
    15	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
    14	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/components/com_content/models/category.php:265
    13	ContentModelCategory->getItems()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
    12	JViewLegacy->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:310
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

22. Tempo della query: 0.50 ms Dopo l'ultima query: 0.38 ms Memoria query: 0.035 MB memoria prima della query: 4.836 MB Righe restituite: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `avjbq_contentitem_tag_map` AS m 
    
      INNER JOIN `avjbq_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.category' 
      AND `m`.`content_item_id` = 28 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	t	range	PRIMARY,tag_idx,idx_access	idx_access	4	NULL	2	Using index condition; Using where
    1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	aqtpboka_pc_crash.t.id	12	Using index condition; Using where

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    12	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/libraries/src/MVC/View/CategoryView.php:226
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:310
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

23. Tempo della query: 1.25 ms Dopo l'ultima query: 5.95 ms Memoria query: 0.039 MB memoria prima della query: 4.969 MB Righe restituite: 3

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `avjbq_categories` AS `s`
    
      INNER JOIN `avjbq_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 28
    
      ORDER BY c.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	48	Using where; Using filesort

    Profilo

    Status	Duration
    Starting	0.27 ms
    checking permissions	0.02 ms
    Opening tables	0.05 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.08 ms
    Optimizing	0.05 ms
    Statistics	0.16 ms
    Preparing	0.02 ms
    Unlocking tables	0.01 ms
    Preparing	0.06 ms
    Sorting result	0.03 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.17 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.02 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:1691
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:314
    19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
    18	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:197
    17	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
    16	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:427
    13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:108
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:310
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

24. Tempo della query: 1.12 ms Dopo l'ultima query: 0.36 ms Memoria query: 0.037 MB memoria prima della query: 4.995 MB Righe restituite: 0

    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
    
      FROM avjbq_fields AS a
    
      LEFT JOIN `avjbq_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN avjbq_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN avjbq_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN avjbq_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN avjbq_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `avjbq_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'com_content.article' 
      AND (fc.category_id IS NULL OR fc.category_id IN (28,0,27)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    Explain

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

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
    16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:427
    13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:108
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:310
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

25. Tempo della query: 1.36 ms Dopo l'ultima query: 2.56 ms Memoria query: 0.034 MB memoria prima della query: 5.047 MB Righe restituite: 16

    SHOW FULL COLUMNS 
      FROM `avjbq_users`

    Explain

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

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    25	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
    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/src/Table/User.php:41
    21	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:312
    20	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
    19	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:882
    18	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    17	Joomla\CMS\User\User->__construct()	JROOT/components/com_users/models/profile.php:134
    16	UsersModelProfile->getData()	JROOT/components/com_jsn/helpers/helper.php:524
    15	JsnUser->__construct()	JROOT/components/com_jsn/helpers/helper.php:26
    14	JsnHelper::getUser()	JROOT/plugins/content/jsn_author/jsn_author.php:34
    13	plgContentJsn_Author->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:116
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:310
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

26. Tempo della query: 0.58 ms Dopo l'ultima query: 0.81 ms Memoria query: 0.031 MB memoria prima della query: 5.091 MB Righe restituite: 1
    Query duplicate: #32  #36  #38  #40

    SELECT *
    
      FROM `avjbq_users`
    
      WHERE `id` = 6

    Explain

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

    Profilo

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.07 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.04 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.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:1455
    20	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
    19	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:885
    18	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    17	Joomla\CMS\User\User->__construct()	JROOT/components/com_users/models/profile.php:134
    16	UsersModelProfile->getData()	JROOT/components/com_jsn/helpers/helper.php:524
    15	JsnUser->__construct()	JROOT/components/com_jsn/helpers/helper.php:26
    14	JsnHelper::getUser()	JROOT/plugins/content/jsn_author/jsn_author.php:34
    13	plgContentJsn_Author->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:116
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:310
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

27. Tempo della query: 0.63 ms Dopo l'ultima query: 0.91 ms Memoria query: 0.027 MB memoria prima della query: 5.170 MB Righe restituite: 3
    Query duplicate: #33  #37  #39  #41

    SELECT `g`.`id`,`g`.`title`
    
      FROM `avjbq_usergroups` AS g
    
      INNER JOIN `avjbq_user_usergroup_map` AS m 
      ON m.group_id = g.id
    
      WHERE `m`.`user_id` = 6

    Explain

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

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
    20	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
    19	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:885
    18	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    17	Joomla\CMS\User\User->__construct()	JROOT/components/com_users/models/profile.php:134
    16	UsersModelProfile->getData()	JROOT/components/com_jsn/helpers/helper.php:524
    15	JsnUser->__construct()	JROOT/components/com_jsn/helpers/helper.php:26
    14	JsnHelper::getUser()	JROOT/plugins/content/jsn_author/jsn_author.php:34
    13	plgContentJsn_Author->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:116
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:310
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

28. Tempo della query: 0.81 ms Dopo l'ultima query: 4.27 ms Memoria query: 0.079 MB memoria prima della query: 5.307 MB Righe restituite: 1

    SELECT *
    
      FROM avjbq_easyblog_configs
    
      WHERE `name` = 'config'

    Explain

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

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
    21	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    20	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:441
    19	EB::config()	JROOT/plugins/user/easyblogusers/easyblogusers.php:29
    18	plgUserEasyBlogUsers->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:272
    17	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
    16	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/components/com_jsn/helpers/helper.php:532
    15	JsnUser->__construct()	JROOT/components/com_jsn/helpers/helper.php:26
    14	JsnHelper::getUser()	JROOT/plugins/content/jsn_author/jsn_author.php:34
    13	plgContentJsn_Author->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:116
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:310
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

29. Tempo della query: 0.95 ms Dopo l'ultima query: 7.21 ms Memoria query: 0.049 MB memoria prima della query: 5.518 MB Righe restituite: 1

    SELECT a.*
    
      FROM avjbq_jsn_users AS a
    
      WHERE a.id = 6

    Explain

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

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
    19	JDatabaseDriver->loadObject()	JROOT/plugins/user/jsn_users/jsn_users.php:62
    18	PlgUserJsn_Users->onContentPrepareData()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/components/com_jsn/helpers/helper.php:533
    15	JsnUser->__construct()	JROOT/components/com_jsn/helpers/helper.php:26
    14	JsnHelper::getUser()	JROOT/plugins/content/jsn_author/jsn_author.php:34
    13	plgContentJsn_Author->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:116
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:310
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

30. Tempo della query: 1.30 ms Dopo l'ultima query: 0.19 ms Memoria query: 0.264 MB memoria prima della query: 5.546 MB Righe restituite: 70

    SELECT a.*
    
      FROM avjbq_jsn_fields AS a
    
      WHERE a.level = 2 
      AND a.published = 1

    Explain

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

    Profilo

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.02 ms
    Opening tables	0.03 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.02 ms
    Preparing	0.02 ms
    Executing	0.02 ms
    Sending data	0.72 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    19	JDatabaseDriver->loadObjectList()	JROOT/plugins/user/jsn_users/jsn_users.php:76
    18	PlgUserJsn_Users->onContentPrepareData()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/components/com_jsn/helpers/helper.php:533
    15	JsnUser->__construct()	JROOT/components/com_jsn/helpers/helper.php:26
    14	JsnHelper::getUser()	JROOT/plugins/content/jsn_author/jsn_author.php:34
    13	plgContentJsn_Author->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:116
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:310
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

31. Tempo della query: 1.24 ms Dopo l'ultima query: 6.55 ms Memoria query: 0.259 MB memoria prima della query: 7.135 MB Righe restituite: 70

    SELECT a.*,b.access as parent_access
    
      FROM avjbq_jsn_fields AS a
    
      LEFT JOIN avjbq_jsn_fields AS b 
      ON a.parent_id = b.id
    
      WHERE a.level = 2 
      AND a.published = 1
    
      ORDER BY a.lft ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	95	Using where; Using filesort
    1	SIMPLE	b	eq_ref	PRIMARY	PRIMARY	4	aqtpboka_pc_crash.a.parent_id	1

    Profilo

    Status	Duration
    Starting	0.12 ms
    checking permissions	0.02 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.03 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    Creating sort index	0.65 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jsn/helpers/helper.php:233
    16	JsnHelper::excludeFromProfile()	JROOT/components/com_jsn/helpers/helper.php:545
    15	JsnUser->__construct()	JROOT/components/com_jsn/helpers/helper.php:26
    14	JsnHelper::getUser()	JROOT/plugins/content/jsn_author/jsn_author.php:34
    13	plgContentJsn_Author->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:116
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:310
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

32. Tempo della query: 0.37 ms Dopo l'ultima query: 1.18 ms Memoria query: 0.032 MB memoria prima della query: 7.972 MB Righe restituite: 1
    Query duplicate: #26  #36  #38  #40

    SELECT *
    
      FROM `avjbq_users`
    
      WHERE `id` = 6

    Explain

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

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
    23	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
    22	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:885
    21	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    20	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
    19	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Access/Access.php:1073
    18	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
    17	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/components/com_jsn/helpers/helper.php:237
    16	JsnHelper::excludeFromProfile()	JROOT/components/com_jsn/helpers/helper.php:545
    15	JsnUser->__construct()	JROOT/components/com_jsn/helpers/helper.php:26
    14	JsnHelper::getUser()	JROOT/plugins/content/jsn_author/jsn_author.php:34
    13	plgContentJsn_Author->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:116
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:310
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

33. Tempo della query: 0.41 ms Dopo l'ultima query: 0.25 ms Memoria query: 0.030 MB memoria prima della query: 7.993 MB Righe restituite: 3
    Query duplicate: #27  #37  #39  #41

    SELECT `g`.`id`,`g`.`title`
    
      FROM `avjbq_usergroups` AS g
    
      INNER JOIN `avjbq_user_usergroup_map` AS m 
      ON m.group_id = g.id
    
      WHERE `m`.`user_id` = 6

    Explain

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

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
    23	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
    22	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:885
    21	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    20	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
    19	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Access/Access.php:1073
    18	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
    17	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/components/com_jsn/helpers/helper.php:237
    16	JsnHelper::excludeFromProfile()	JROOT/components/com_jsn/helpers/helper.php:545
    15	JsnUser->__construct()	JROOT/components/com_jsn/helpers/helper.php:26
    14	JsnHelper::getUser()	JROOT/plugins/content/jsn_author/jsn_author.php:34
    13	plgContentJsn_Author->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:116
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:310
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

34. Tempo della query: 0.42 ms Dopo l'ultima query: 0.20 ms Memoria query: 0.027 MB memoria prima della query: 8.004 MB Righe restituite: 8

    SELECT b.id
    
      FROM avjbq_user_usergroup_map AS map
    
      LEFT JOIN avjbq_usergroups AS a 
      ON a.id = map.group_id
    
      LEFT JOIN avjbq_usergroups AS b 
      ON b.lft <= a.lft 
      AND b.rgt >= a.rgt
    
      WHERE map.user_id = 6

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	map	ref	PRIMARY	PRIMARY	4	const	3	Using index
    1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	aqtpboka_pc_crash.map.group_id	1
    1	SIMPLE	b	ALL	idx_usergroup_nested_set_lookup	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	27	Range checked for each record (index map: 0x10)

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
    20	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
    19	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
    18	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
    17	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/components/com_jsn/helpers/helper.php:237
    16	JsnHelper::excludeFromProfile()	JROOT/components/com_jsn/helpers/helper.php:545
    15	JsnUser->__construct()	JROOT/components/com_jsn/helpers/helper.php:26
    14	JsnHelper::getUser()	JROOT/plugins/content/jsn_author/jsn_author.php:34
    13	plgContentJsn_Author->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:116
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:310
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

35. Tempo della query: 1.07 ms Dopo l'ultima query: 1.36 ms Memoria query: 0.263 MB memoria prima della query: 8.048 MB Righe restituite: 70

    SELECT a.*,b.access as parent_access
    
      FROM avjbq_jsn_fields AS a
    
      LEFT JOIN avjbq_jsn_fields AS b 
      ON a.parent_id = b.id
    
      WHERE a.level = 2 
      AND a.published = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	95	Using where
    1	SIMPLE	b	eq_ref	PRIMARY	PRIMARY	4	aqtpboka_pc_crash.a.parent_id	1

    Profilo

    Status	Duration
    Starting	0.10 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.61 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.02 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:1496
    17	JDatabaseDriver->loadAssocList()	JROOT/components/com_jsn/helpers/helper.php:608
    16	JsnUser->getField()	JROOT/components/com_jsn/helpers/helper.php:132
    15	JsnHelper::getFormatName()	JROOT/components/com_jsn/helpers/helper.php:689
    14	JsnUser->getFormatName()	JROOT/plugins/content/jsn_author/jsn_author.php:42
    13	plgContentJsn_Author->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:116
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:310
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

36. Tempo della query: 0.44 ms Dopo l'ultima query: 7.11 ms Memoria query: 0.031 MB memoria prima della query: 8.950 MB Righe restituite: 1
    Query duplicate: #26  #32  #38  #40

    SELECT *
    
      FROM `avjbq_users`
    
      WHERE `id` = 6

    Explain

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

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
    20	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
    19	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:885
    18	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    17	Joomla\CMS\User\User->__construct()	JROOT/components/com_users/models/profile.php:134
    16	UsersModelProfile->getData()	JROOT/components/com_jsn/helpers/helper.php:524
    15	JsnUser->__construct()	JROOT/components/com_jsn/helpers/helper.php:26
    14	JsnHelper::getUser()	JROOT/plugins/content/jsn_author/jsn_author.php:34
    13	plgContentJsn_Author->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:116
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:310
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

37. Tempo della query: 0.39 ms Dopo l'ultima query: 0.19 ms Memoria query: 0.027 MB memoria prima della query: 8.964 MB Righe restituite: 3
    Query duplicate: #27  #33  #39  #41

    SELECT `g`.`id`,`g`.`title`
    
      FROM `avjbq_usergroups` AS g
    
      INNER JOIN `avjbq_user_usergroup_map` AS m 
      ON m.group_id = g.id
    
      WHERE `m`.`user_id` = 6

    Explain

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

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
    20	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
    19	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:885
    18	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    17	Joomla\CMS\User\User->__construct()	JROOT/components/com_users/models/profile.php:134
    16	UsersModelProfile->getData()	JROOT/components/com_jsn/helpers/helper.php:524
    15	JsnUser->__construct()	JROOT/components/com_jsn/helpers/helper.php:26
    14	JsnHelper::getUser()	JROOT/plugins/content/jsn_author/jsn_author.php:34
    13	plgContentJsn_Author->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:116
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:310
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

38. Tempo della query: 0.44 ms Dopo l'ultima query: 7.46 ms Memoria query: 0.031 MB memoria prima della query: 8.970 MB Righe restituite: 1
    Query duplicate: #26  #32  #36  #40

    SELECT *
    
      FROM `avjbq_users`
    
      WHERE `id` = 6

    Explain

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

    Profilo

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.04 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 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:1455
    20	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
    19	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:885
    18	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    17	Joomla\CMS\User\User->__construct()	JROOT/components/com_users/models/profile.php:134
    16	UsersModelProfile->getData()	JROOT/components/com_jsn/helpers/helper.php:524
    15	JsnUser->__construct()	JROOT/components/com_jsn/helpers/helper.php:26
    14	JsnHelper::getUser()	JROOT/plugins/content/jsn_author/jsn_author.php:34
    13	plgContentJsn_Author->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:116
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:310
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

39. Tempo della query: 0.44 ms Dopo l'ultima query: 0.21 ms Memoria query: 0.027 MB memoria prima della query: 8.983 MB Righe restituite: 3
    Query duplicate: #27  #33  #37  #41

    SELECT `g`.`id`,`g`.`title`
    
      FROM `avjbq_usergroups` AS g
    
      INNER JOIN `avjbq_user_usergroup_map` AS m 
      ON m.group_id = g.id
    
      WHERE `m`.`user_id` = 6

    Explain

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

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
    20	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
    19	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:885
    18	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    17	Joomla\CMS\User\User->__construct()	JROOT/components/com_users/models/profile.php:134
    16	UsersModelProfile->getData()	JROOT/components/com_jsn/helpers/helper.php:524
    15	JsnUser->__construct()	JROOT/components/com_jsn/helpers/helper.php:26
    14	JsnHelper::getUser()	JROOT/plugins/content/jsn_author/jsn_author.php:34
    13	plgContentJsn_Author->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:116
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:310
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

40. Tempo della query: 0.50 ms Dopo l'ultima query: 7.17 ms Memoria query: 0.031 MB memoria prima della query: 8.990 MB Righe restituite: 1
    Query duplicate: #26  #32  #36  #38

    SELECT *
    
      FROM `avjbq_users`
    
      WHERE `id` = 6

    Explain

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

    Profilo

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.02 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:1455
    20	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
    19	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:885
    18	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    17	Joomla\CMS\User\User->__construct()	JROOT/components/com_users/models/profile.php:134
    16	UsersModelProfile->getData()	JROOT/components/com_jsn/helpers/helper.php:524
    15	JsnUser->__construct()	JROOT/components/com_jsn/helpers/helper.php:26
    14	JsnHelper::getUser()	JROOT/plugins/content/jsn_author/jsn_author.php:34
    13	plgContentJsn_Author->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:116
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:310
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

41. Tempo della query: 0.55 ms Dopo l'ultima query: 0.21 ms Memoria query: 0.027 MB memoria prima della query: 9.004 MB Righe restituite: 3
    Query duplicate: #27  #33  #37  #39

    SELECT `g`.`id`,`g`.`title`
    
      FROM `avjbq_usergroups` AS g
    
      INNER JOIN `avjbq_user_usergroup_map` AS m 
      ON m.group_id = g.id
    
      WHERE `m`.`user_id` = 6

    Explain

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

    Profilo

    Status	Duration
    Starting	0.09 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.06 ms
    Preparing	0.05 ms
    Executing	0.01 ms
    Sending data	0.04 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 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:1496
    20	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
    19	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:885
    18	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    17	Joomla\CMS\User\User->__construct()	JROOT/components/com_users/models/profile.php:134
    16	UsersModelProfile->getData()	JROOT/components/com_jsn/helpers/helper.php:524
    15	JsnUser->__construct()	JROOT/components/com_jsn/helpers/helper.php:26
    14	JsnHelper::getUser()	JROOT/plugins/content/jsn_author/jsn_author.php:34
    13	plgContentJsn_Author->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:116
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:310
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

42. Tempo della query: 0.94 ms Dopo l'ultima query: 12.41 ms Memoria query: 0.042 MB memoria prima della query: 9.069 MB Righe restituite: 0

    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
    
      FROM avjbq_fields AS a
    
      LEFT JOIN `avjbq_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN avjbq_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN avjbq_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN avjbq_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN avjbq_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `avjbq_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'com_content.category.title' 
      AND (fc.category_id IS NULL OR fc.category_id IN (28,0,27)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    Explain

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

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    29	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    28	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
    27	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    26	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    25	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:427
    24	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    23	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    22	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    21	JHtmlContent::prepare()	Chiamata uguale alla linea sottostante.
    20	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    19	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    18	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/plugins/system/t3/base-bs3/html/layouts/joomla/content/category_default.php:34
    17	include JROOT/plugins/system/t3/base-bs3/html/layouts/joomla/content/category_default.php	JROOT/plugins/system/t3/includes/joomla25/layout/file.php:97
    16	JLayoutFile->render()	JROOT/libraries/src/Layout/LayoutHelper.php:73
    15	Joomla\CMS\Layout\LayoutHelper::render()	JROOT/plugins/system/t3/base-bs3/html/com_content/category/default.php:20
    14	include JROOT/plugins/system/t3/base-bs3/html/com_content/category/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    13	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
    12	JViewLegacy->display()	JROOT/libraries/src/MVC/View/CategoryView.php:242
    11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:269
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:310
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

43. Tempo della query: 2.19 ms Dopo l'ultima query: 10.53 ms Memoria query: 0.033 MB memoria prima della query: 9.184 MB Righe restituite: 14

    SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM avjbq_modules AS m
    
      LEFT JOIN avjbq_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN avjbq_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 <= '2026-10-28 20:45:36') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-10-28 20:45:36') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 240 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	ref	PRIMARY,published,newsfeeds	published	1	const	58	Using index condition; Using where; Using filesort
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	aqtpboka_pc_crash.m.module,const	1	Using index condition; Using where
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	aqtpboka_pc_crash.m.id	2	Using where; Using index

    Profilo

    Status	Duration
    Starting	0.17 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.08 ms
    Optimizing	0.06 ms
    Statistics	0.13 ms
    Preparing	0.10 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	1.26 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.02 ms
    Updating status	0.04 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:1691
    16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:423
    15	JModuleHelper::_load()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:102
    14	JModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:594
    13	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/t3/includes/core/template.php:608
    12	T3Template->countModules()	JROOT/templates/ja_sugite/tpls/blocks/header.php:28
    11	include JROOT/templates/ja_sugite/tpls/blocks/header.php	JROOT/plugins/system/t3/includes/core/template.php:176
    10	T3Template->loadBlock()	JROOT/templates/ja_sugite/tpls/default.php:45
    9	include JROOT/templates/ja_sugite/tpls/default.php	JROOT/plugins/system/t3/includes/core/template.php:200
    8	T3Template->loadLayout()	JROOT/templates/ja_sugite/index.php:34
    7	require JROOT/templates/ja_sugite/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:1133
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:316
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

44. Tempo della query: 0.92 ms Dopo l'ultima query: 7.45 ms Memoria query: 0.040 MB memoria prima della query: 9.283 MB Righe restituite: 6

    SELECT a.*, c.published AS c_published, 
      CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,DATE_FORMAT(a.created, "%Y-%m-%d") AS created,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email
    
      FROM `avjbq_weblinks` AS a
    
      LEFT JOIN avjbq_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN avjbq_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN avjbq_users AS uam 
      ON uam.id = a.modified_by
    
      WHERE a.access IN (1,1,5) 
      AND a.catid = 18 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.state != -2 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-10-28 20:45:36') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-10-28 20:45:36')
    
      ORDER BY ordering asc 
      LIMIT 10

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
    1	SIMPLE	a	ALL	idx_access,idx_state,idx_catid	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	7	Using where; Using filesort
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	aqtpboka_pc_crash.a.created_by	1	Using where

    Profilo

    Status	Duration
    Starting	0.16 ms
    checking permissions	0.01 ms
    Opening tables	0.06 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.07 ms
    Optimizing	0.04 ms
    Statistics	0.11 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.11 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.02 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.02 ms
    Updating status	0.02 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:1691
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_weblinks/models/category.php:81
    12	WeblinksModelCategory->getItems()	JROOT/modules/mod_weblinks/helper.php:94
    11	ModWeblinksHelper::getList()	JROOT/modules/mod_weblinks/mod_weblinks.php:15
    10	include JROOT/modules/mod_weblinks/mod_weblinks.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
    9	JModuleHelper::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:1147
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:316
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

45. Tempo della query: 0.51 ms Dopo l'ultima query: 0.25 ms Memoria query: 0.035 MB memoria prima della query: 9.352 MB Righe restituite: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `avjbq_contentitem_tag_map` AS m 
    
      INNER JOIN `avjbq_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_weblinks.weblink' 
      AND `m`.`content_item_id` = 1 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	t	range	PRIMARY,tag_idx,idx_access	idx_access	4	NULL	2	Using index condition; Using where
    1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	aqtpboka_pc_crash.t.id	12	Using index condition; Using where

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    13	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_weblinks/models/category.php:95
    12	WeblinksModelCategory->getItems()	JROOT/modules/mod_weblinks/helper.php:94
    11	ModWeblinksHelper::getList()	JROOT/modules/mod_weblinks/mod_weblinks.php:15
    10	include JROOT/modules/mod_weblinks/mod_weblinks.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
    9	JModuleHelper::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:1147
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:316
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

46. Tempo della query: 0.48 ms Dopo l'ultima query: 0.21 ms Memoria query: 0.035 MB memoria prima della query: 9.360 MB Righe restituite: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `avjbq_contentitem_tag_map` AS m 
    
      INNER JOIN `avjbq_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_weblinks.weblink' 
      AND `m`.`content_item_id` = 4 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	t	range	PRIMARY,tag_idx,idx_access	idx_access	4	NULL	2	Using index condition; Using where
    1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	aqtpboka_pc_crash.t.id	12	Using index condition; Using where

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    13	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_weblinks/models/category.php:95
    12	WeblinksModelCategory->getItems()	JROOT/modules/mod_weblinks/helper.php:94
    11	ModWeblinksHelper::getList()	JROOT/modules/mod_weblinks/mod_weblinks.php:15
    10	include JROOT/modules/mod_weblinks/mod_weblinks.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
    9	JModuleHelper::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:1147
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:316
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

47. Tempo della query: 0.47 ms Dopo l'ultima query: 0.19 ms Memoria query: 0.035 MB memoria prima della query: 9.368 MB Righe restituite: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `avjbq_contentitem_tag_map` AS m 
    
      INNER JOIN `avjbq_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_weblinks.weblink' 
      AND `m`.`content_item_id` = 6 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	t	range	PRIMARY,tag_idx,idx_access	idx_access	4	NULL	2	Using index condition; Using where
    1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	aqtpboka_pc_crash.t.id	12	Using index condition; Using where

    Profilo

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.07 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	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.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    13	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_weblinks/models/category.php:95
    12	WeblinksModelCategory->getItems()	JROOT/modules/mod_weblinks/helper.php:94
    11	ModWeblinksHelper::getList()	JROOT/modules/mod_weblinks/mod_weblinks.php:15
    10	include JROOT/modules/mod_weblinks/mod_weblinks.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
    9	JModuleHelper::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:1147
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:316
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

48. Tempo della query: 0.43 ms Dopo l'ultima query: 0.19 ms Memoria query: 0.035 MB memoria prima della query: 9.376 MB Righe restituite: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `avjbq_contentitem_tag_map` AS m 
    
      INNER JOIN `avjbq_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_weblinks.weblink' 
      AND `m`.`content_item_id` = 7 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	t	range	PRIMARY,tag_idx,idx_access	idx_access	4	NULL	2	Using index condition; Using where
    1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	aqtpboka_pc_crash.t.id	12	Using index condition; Using where

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    13	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_weblinks/models/category.php:95
    12	WeblinksModelCategory->getItems()	JROOT/modules/mod_weblinks/helper.php:94
    11	ModWeblinksHelper::getList()	JROOT/modules/mod_weblinks/mod_weblinks.php:15
    10	include JROOT/modules/mod_weblinks/mod_weblinks.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
    9	JModuleHelper::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:1147
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:316
    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]

    ---

49. Tempo della query: 0.42 ms Dopo l'ultima query: 0.22 ms Memoria query: 0.035 MB memoria prima della query: 9.384 MB Righe restituite: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `avjbq_contentitem_tag_map` AS m 
    
      INNER JOIN `avjbq_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_weblinks.weblink' 
      AND `m`.`content_item_id` = 3 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	t	range	PRIMARY,tag_idx,idx_access	idx_access	4	NULL	2	Using index condition; Using where
    1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	aqtpboka_pc_crash.t.id	12	Using index condition; Using where

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    13	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_weblinks/models/category.php:95
    12	WeblinksModelCategory->getItems()	JROOT/modules/mod_weblinks/helper.php:94
    11	ModWeblinksHelper::getList()	JROOT/modules/mod_weblinks/mod_weblinks.php:15
    10	include JROOT/modules/mod_weblinks/mod_weblinks.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
    9	JModuleHelper::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:1147
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:316
    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]

    ---

50. Tempo della query: 0.48 ms Dopo l'ultima query: 0.17 ms Memoria query: 0.035 MB memoria prima della query: 9.392 MB Righe restituite: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `avjbq_contentitem_tag_map` AS m 
    
      INNER JOIN `avjbq_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_weblinks.weblink' 
      AND `m`.`content_item_id` = 5 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	t	range	PRIMARY,tag_idx,idx_access	idx_access	4	NULL	2	Using index condition; Using where
    1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	aqtpboka_pc_crash.t.id	12	Using index condition; Using where

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    13	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_weblinks/models/category.php:95
    12	WeblinksModelCategory->getItems()	JROOT/modules/mod_weblinks/helper.php:94
    11	ModWeblinksHelper::getList()	JROOT/modules/mod_weblinks/mod_weblinks.php:15
    10	include JROOT/modules/mod_weblinks/mod_weblinks.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
    9	JModuleHelper::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:1147
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:316
    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]

    ---

51. Tempo della query: 2.85 ms Dopo l'ultima query: 16.58 ms Memoria query: 0.042 MB memoria prima della query: 9.491 MB Righe restituite: 4

    SELECT DISTINCT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2 
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating, 
    							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
    
      FROM avjbq_content AS a
    
      LEFT JOIN avjbq_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN avjbq_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN avjbq_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN avjbq_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN avjbq_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.catid IN (28) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-10-28 20:45:36') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-10-28 20:45:36')
    
      ORDER BY a.ordering ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	Using temporary; Using filesort
    1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	4	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	aqtpboka_pc_crash.a.created_by	1	Using where
    1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	aqtpboka_pc_crash.a.modified_by	1	Using where
    1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where
    1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	aqtpboka_pc_crash.a.id	1	Using where

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:558
    15	ContentModelArticles->getItems()	JROOT/modules/mod_articles_category/helper.php:230
    14	ModArticlesCategoryHelper::getList()	Chiamata uguale alla linea sottostante.
    13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:565
    11	JModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
    10	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
    9	JModuleHelper::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:1147
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:316
    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]

    ---

52. Tempo della query: 1.16 ms Dopo l'ultima query: 3.71 ms Memoria query: 0.040 MB memoria prima della query: 9.498 MB Righe restituite: 6

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,(
    SELECT COUNT(i.`id`)
    
      FROM `avjbq_content` AS `i`
    
      WHERE i.`catid` = c.id 
      AND i.state = 1) AS numitems
    
      FROM `avjbq_categories` AS `s`
    
      INNER JOIN `avjbq_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 27
    
      ORDER BY c.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	48	Using where; Using filesort
    2	DEPENDENT SUBQUERY	i	ref	idx_state,idx_catid	idx_catid	4	aqtpboka_pc_crash.c.id	3	Using index condition; Using where

    Profilo

    Status	Duration
    Starting	0.15 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.06 ms
    Optimizing	0.03 ms
    Statistics	0.12 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.14 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Removing tmp table	0.01 ms
    Freeing items	0.02 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:1691
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:314
    16	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
    15	Joomla\CMS\Categories\Categories->get()	JROOT/modules/mod_articles_categories/helper.php:34
    14	ModArticlesCategoriesHelper::getList()	Chiamata uguale alla linea sottostante.
    13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:565
    11	JModuleHelper::moduleCache()	JROOT/modules/mod_articles_categories/mod_articles_categories.php:28
    10	include JROOT/modules/mod_articles_categories/mod_articles_categories.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
    9	JModuleHelper::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:1147
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:316
    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]

    ---

53. Tempo della query: 0.66 ms Dopo l'ultima query: 1.16 ms Memoria query: 0.041 MB memoria prima della query: 9.524 MB Righe restituite: 3

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `avjbq_categories` AS `s`
    
      INNER JOIN `avjbq_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 29
    
      ORDER BY c.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	48	Using where; Using filesort

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:314
    23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
    22	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    21	ContentRouter->getCategorySegment()	Chiamata uguale alla linea sottostante.
    20	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    19	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    18	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    17	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:670
    16	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
    13	Joomla\CMS\Router\Route::_()	JROOT/templates/ja_sugite/html/mod_articles_categories/default_items.php:19
    12	require JROOT/templates/ja_sugite/html/mod_articles_categories/default_items.php	JROOT/templates/ja_sugite/html/mod_articles_categories/default.php:19
    11	require JROOT/templates/ja_sugite/html/mod_articles_categories/default.php	JROOT/modules/mod_articles_categories/mod_articles_categories.php:35
    10	include JROOT/modules/mod_articles_categories/mod_articles_categories.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
    9	JModuleHelper::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:1147
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:316
    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]

    ---

54. Tempo della query: 0.61 ms Dopo l'ultima query: 0.47 ms Memoria query: 0.041 MB memoria prima della query: 9.543 MB Righe restituite: 3

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `avjbq_categories` AS `s`
    
      INNER JOIN `avjbq_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 30
    
      ORDER BY c.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	48	Using where; Using filesort

    Profilo

    Status	Duration
    Starting	0.08 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.11 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	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.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:314
    23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
    22	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    21	ContentRouter->getCategorySegment()	Chiamata uguale alla linea sottostante.
    20	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    19	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    18	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    17	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:670
    16	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
    13	Joomla\CMS\Router\Route::_()	JROOT/templates/ja_sugite/html/mod_articles_categories/default_items.php:19
    12	require JROOT/templates/ja_sugite/html/mod_articles_categories/default_items.php	JROOT/templates/ja_sugite/html/mod_articles_categories/default.php:19
    11	require JROOT/templates/ja_sugite/html/mod_articles_categories/default.php	JROOT/modules/mod_articles_categories/mod_articles_categories.php:35
    10	include JROOT/modules/mod_articles_categories/mod_articles_categories.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
    9	JModuleHelper::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:1147
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:316
    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]

    ---

55. Tempo della query: 0.62 ms Dopo l'ultima query: 0.44 ms Memoria query: 0.041 MB memoria prima della query: 9.561 MB Righe restituite: 3

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `avjbq_categories` AS `s`
    
      INNER JOIN `avjbq_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 43
    
      ORDER BY c.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	48	Using where; Using filesort

    Profilo

    Status	Duration
    Starting	0.08 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.06 ms
    Optimizing	0.04 ms
    Statistics	0.09 ms
    Preparing	0.01 ms
    Unlocking tables	0.00 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.09 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.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.01 ms

    Call Stack

    #	Caller	File e numero di linea
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:314
    23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
    22	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    21	ContentRouter->getCategorySegment()	Chiamata uguale alla linea sottostante.
    20	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    19	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    18	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    17	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:670
    16	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
    13	Joomla\CMS\Router\Route::_()	JROOT/templates/ja_sugite/html/mod_articles_categories/default_items.php:19
    12	require JROOT/templates/ja_sugite/html/mod_articles_categories/default_items.php	JROOT/templates/ja_sugite/html/mod_articles_categories/default.php:19
    11	require JROOT/templates/ja_sugite/html/mod_articles_categories/default.php	JROOT/modules/mod_articles_categories/mod_articles_categories.php:35
    10	include JROOT/modules/mod_articles_categories/mod_articles_categories.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
    9	JModuleHelper::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:1147
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:316
    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]

    ---

56. Tempo della query: 0.43 ms Dopo l'ultima query: 10.25 ms Memoria query: 0.029 MB memoria prima della query: 9.847 MB Righe restituite: 1

    SELECT * 
      FROM avjbq_kunena_configuration 
      WHERE id=1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	avjbq_kunena_configuration	system	PRIMARY	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1

    Profilo

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.02 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
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
    24	JDatabaseDriver->loadAssoc()	JROOT/libraries/kunena/config.php:1295
    23	KunenaConfig->load()	JROOT/libraries/kunena/config.php:1229
    22	KunenaConfig::getInstance()	JROOT/libraries/kunena/factory.php:28
    21	KunenaFactory::getConfig()	JROOT/libraries/kunena/route/route.php:480
    20	KunenaRoute::initialize()	JROOT/libraries/kunena/route/route.php:17
    19	include_once JROOT/libraries/kunena/route/route.php	JROOT/libraries/loader.php:747
    18	JLoader::_load()	JROOT/libraries/loader.php:695
    17	JLoader::_autoload()	Chiamata uguale alla linea sottostante.
    16	spl_autoload_call()	JROOT/components/com_kunena/router.php:38
    15	KunenaBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    14	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
    13	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
    12	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
    9	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/t3/includes/menu/megamenu.php:162
    8	T3MenuMegamenu->__construct()	JROOT/plugins/system/t3/includes/renderer/megamenurender.php:87
    7	JDocumentRendererMegamenuRender->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:1147
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:316
    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]

    ---

57. Tempo della query: 0.59 ms Dopo l'ultima query: 4.79 ms Memoria query: 0.053 MB memoria prima della query: 9.920 MB Righe restituite: 21

    SELECT * 
      FROM avjbq_kunena_categories 
      ORDER BY ordering, name

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	avjbq_kunena_categories	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	21	Using filesort

    Profilo

    Status	Duration
    Starting	0.08 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.17 ms
    End of update loop	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.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
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/forum/category/helper.php:865
    21	KunenaForumCategoryHelper::loadCategories()	JROOT/libraries/kunena/forum/category/helper.php:43
    20	KunenaForumCategoryHelper::initialize()	JROOT/libraries/kunena/forum/category/helper.php:965
    19	include_once JROOT/libraries/kunena/forum/category/helper.php	JROOT/libraries/loader.php:726
    18	JLoader::_load()	JROOT/libraries/loader.php:695
    17	JLoader::_autoload()	Chiamata uguale alla linea sottostante.
    16	spl_autoload_call()	JROOT/components/com_kunena/router.php:113
    15	KunenaBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    14	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
    13	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
    12	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
    9	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/t3/includes/menu/megamenu.php:162
    8	T3MenuMegamenu->__construct()	JROOT/plugins/system/t3/includes/renderer/megamenurender.php:87
    7	JDocumentRendererMegamenuRender->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:1147
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:316
    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]

    ---

58. Tempo della query: 0.96 ms Dopo l'ultima query: 2.27 ms Memoria query: 0.046 MB memoria prima della query: 10.188 MB Righe restituite: 51

    SHOW FULL COLUMNS 
      FROM `avjbq_kunena_users`

    Explain

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

    Profilo

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    closing tables	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.29 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.01 ms
    Filling schema table	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    checking permissions	0.15 ms
    closing tables	0.01 ms
    checking permissions	0.01 ms
    Executing	0.00 ms
    Sending data	0.06 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.00 ms
    Removing tmp table	0.09 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.01 ms

    Call Stack

    #	Caller	File e numero di linea
    38	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    37	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
    36	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    35	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    34	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/kunena/tables/kunenausers.php:329
    33	TableKunenaUsers->__construct()	JROOT/libraries/src/Table/Table.php:312
    32	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/kunena/user/user.php:252
    31	KunenaUser->getTable()	JROOT/libraries/kunena/user/user.php:275
    30	KunenaUser->load()	JROOT/libraries/kunena/user/user.php:100
    29	KunenaUser->__construct()	JROOT/libraries/kunena/user/helper.php:59
    28	KunenaUserHelper::initialize()	JROOT/libraries/kunena/user/helper.php:13
    27	include_once JROOT/libraries/kunena/user/helper.php	JROOT/libraries/loader.php:726
    26	JLoader::_load()	JROOT/libraries/loader.php:695
    25	JLoader::_autoload()	Chiamata uguale alla linea sottostante.
    24	spl_autoload_call()	JROOT/libraries/kunena/access.php:116
    23	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:82
    22	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:97
    21	KunenaAccess::getInstance()	JROOT/libraries/kunena/forum/category/helper.php:51
    20	KunenaForumCategoryHelper::initialize()	JROOT/libraries/kunena/forum/category/helper.php:965
    19	include_once JROOT/libraries/kunena/forum/category/helper.php	JROOT/libraries/loader.php:726
    18	JLoader::_load()	JROOT/libraries/loader.php:695
    17	JLoader::_autoload()	Chiamata uguale alla linea sottostante.
    16	spl_autoload_call()	JROOT/components/com_kunena/router.php:113
    15	KunenaBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    14	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
    13	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
    12	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
    9	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/t3/includes/menu/megamenu.php:162
    8	T3MenuMegamenu->__construct()	JROOT/plugins/system/t3/includes/renderer/megamenurender.php:87
    7	JDocumentRendererMegamenuRender->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:1147
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:316
    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]

    ---

59. Tempo della query: 2.02 ms Dopo l'ultima query: 1.02 ms Memoria query: 0.030 MB memoria prima della query: 10.307 MB Righe restituite: 2

    SELECT DISTINCT(user_id)
    
      FROM avjbq_usergroups as ug1
    
      INNER JOIN avjbq_usergroups AS ug2 
      ON ug2.lft>=ug1.lft 
      AND ug1.rgt>=ug2.rgt
    
      INNER JOIN avjbq_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	5642	Using where; Using index; Using join buffer (flat, BNL join)

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
    27	JDatabaseDriver->loadColumn()	JROOT/plugins/kunena/joomla/access.php:441
    26	KunenaAccessJoomla->getUsersByGroup()	JROOT/plugins/kunena/joomla/access.php:492
    25	KunenaAccessJoomla->getAuthorisedUsers()	JROOT/plugins/kunena/joomla/access.php:233
    24	KunenaAccessJoomla->loadCategoryRoles()	JROOT/libraries/kunena/access.php:125
    23	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:82
    22	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:97
    21	KunenaAccess::getInstance()	JROOT/libraries/kunena/forum/category/helper.php:51
    20	KunenaForumCategoryHelper::initialize()	JROOT/libraries/kunena/forum/category/helper.php:965
    19	include_once JROOT/libraries/kunena/forum/category/helper.php	JROOT/libraries/loader.php:726
    18	JLoader::_load()	JROOT/libraries/loader.php:695
    17	JLoader::_autoload()	Chiamata uguale alla linea sottostante.
    16	spl_autoload_call()	JROOT/components/com_kunena/router.php:113
    15	KunenaBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    14	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
    13	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
    12	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
    9	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/t3/includes/menu/megamenu.php:162
    8	T3MenuMegamenu->__construct()	JROOT/plugins/system/t3/includes/renderer/megamenurender.php:87
    7	JDocumentRendererMegamenuRender->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:1147
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:316
    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]

    ---

60. Tempo della query: 6.91 ms Dopo l'ultima query: 0.17 ms Memoria query: 0.030 MB memoria prima della query: 10.320 MB Righe restituite: 0

    SELECT DISTINCT(user_id)
    
      FROM avjbq_usergroups as ug1
    
      INNER JOIN avjbq_usergroups AS ug2 
      ON ug2.lft>=ug1.lft 
      AND ug1.rgt>=ug2.rgt
    
      INNER JOIN avjbq_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	5642	Using index
    1	SIMPLE	ug2	eq_ref	PRIMARY,idx_usergroup_nested_set_lookup	PRIMARY	4	aqtpboka_pc_crash.m.group_id	1	Using where; Distinct

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
    27	JDatabaseDriver->loadColumn()	JROOT/plugins/kunena/joomla/access.php:441
    26	KunenaAccessJoomla->getUsersByGroup()	JROOT/plugins/kunena/joomla/access.php:492
    25	KunenaAccessJoomla->getAuthorisedUsers()	JROOT/plugins/kunena/joomla/access.php:233
    24	KunenaAccessJoomla->loadCategoryRoles()	JROOT/libraries/kunena/access.php:125
    23	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:82
    22	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:97
    21	KunenaAccess::getInstance()	JROOT/libraries/kunena/forum/category/helper.php:51
    20	KunenaForumCategoryHelper::initialize()	JROOT/libraries/kunena/forum/category/helper.php:965
    19	include_once JROOT/libraries/kunena/forum/category/helper.php	JROOT/libraries/loader.php:726
    18	JLoader::_load()	JROOT/libraries/loader.php:695
    17	JLoader::_autoload()	Chiamata uguale alla linea sottostante.
    16	spl_autoload_call()	JROOT/components/com_kunena/router.php:113
    15	KunenaBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    14	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
    13	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
    12	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
    9	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/t3/includes/menu/megamenu.php:162
    8	T3MenuMegamenu->__construct()	JROOT/plugins/system/t3/includes/renderer/megamenurender.php:87
    7	JDocumentRendererMegamenuRender->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:1147
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:316
    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]

    ---

61. Tempo della query: 0.41 ms Dopo l'ultima query: 0.21 ms Memoria query: 0.029 MB memoria prima della query: 10.330 MB Righe restituite: 1

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	avjbq_kunena_user_categories	range	role	role	1	NULL	2	Using index condition

    Profilo

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 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.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/access.php:136
    23	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:82
    22	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:97
    21	KunenaAccess::getInstance()	JROOT/libraries/kunena/forum/category/helper.php:51
    20	KunenaForumCategoryHelper::initialize()	JROOT/libraries/kunena/forum/category/helper.php:965
    19	include_once JROOT/libraries/kunena/forum/category/helper.php	JROOT/libraries/loader.php:726
    18	JLoader::_load()	JROOT/libraries/loader.php:695
    17	JLoader::_autoload()	Chiamata uguale alla linea sottostante.
    16	spl_autoload_call()	JROOT/components/com_kunena/router.php:113
    15	KunenaBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    14	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
    13	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
    12	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
    9	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/t3/includes/menu/megamenu.php:162
    8	T3MenuMegamenu->__construct()	JROOT/plugins/system/t3/includes/renderer/megamenurender.php:87
    7	JDocumentRendererMegamenuRender->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:1147
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:316
    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]

    ---

62. Tempo della query: 0.68 ms Dopo l'ultima query: 10.43 ms Memoria query: 0.026 MB memoria prima della query: 10.487 MB Righe restituite: 0

    SELECT *
     
      FROM avjbq_jmap_metainfo
     
      WHERE `linkurl` = 'https://www.pc-crash.marcellinux.com/pc-crash/formazione/programmi-base'
     
      AND `published` = 1

    Explain

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

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
    13	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:393
    12	plgSystemJMap->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->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:1147
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:316
    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]

    ---

63. Tempo della query: 1.45 ms Dopo l'ultima query: 1.53 ms Memoria query: 0.042 MB memoria prima della query: 10.612 MB Righe restituite: 298

    SHOW TABLES

    Explain

    EXPLAIN non possibile sulla query: SHOW TABLES

    Profilo

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.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.01 ms
    Filling schema table	0.01 ms
    checking permissions	0.93 ms
    Executing	0.01 ms
    Sending data	0.08 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.00 ms
    Removing tmp table	0.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.02 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:1540
    15	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:487
    14	JDatabaseDriverMysqli->getTableList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:552
    13	acymailing_getTableList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:16
    12	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:455
    11	acymailing_config()	JROOT/administrator/components/com_acymailing/compat/joomla.php:840
    10	include_once JROOT/administrator/components/com_acymailing/compat/joomla.php	JROOT/administrator/components/com_acymailing/helpers/helper.php:23
    9	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:22
    8	plgSystemRegacymailing->initAcy()	JROOT/plugins/system/regacymailing/regacymailing.php:146
    7	plgSystemRegacymailing->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1153
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:316
    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]

    ---

64. Tempo della query: 0.43 ms Dopo l'ultima query: 0.38 ms Memoria query: 0.038 MB memoria prima della query: 10.654 MB Righe restituite: 184

    SELECT * 
      FROM avjbq_acymailing_config

    Explain

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

    Profilo

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	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
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:478
    13	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:21
    12	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:455
    11	acymailing_config()	JROOT/administrator/components/com_acymailing/compat/joomla.php:840
    10	include_once JROOT/administrator/components/com_acymailing/compat/joomla.php	JROOT/administrator/components/com_acymailing/helpers/helper.php:23
    9	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:22
    8	plgSystemRegacymailing->initAcy()	JROOT/plugins/system/regacymailing/regacymailing.php:146
    7	plgSystemRegacymailing->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1153
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:316
    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]

    ---