Console Debug Joomla!

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1732171739,
                "last": 1732171739,
                "now": 1732171739
            }
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Tempo

Memoria

25 query eseguite 34.25 ms

1. Tempo della query: 0.74 ms Memoria query: 0.026 MB memoria prima della query: 0.743 MB Righe restituite: 0

   SELECT `data`
   
     FROM `joom2_session`
   
     WHERE `session_id` = 'nqo61p7uvb6iqvq0ic7dm3kme7'

   Explain

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

   Profilo

   Status	Duration
   starting	0.01 ms
   Waiting for query cache lock	0.00 ms
   Waiting on query cache mutex	0.00 ms
   checking query cache for query	0.02 ms
   checking permissions	0.01 ms
   Opening tables	0.04 ms
   System lock	0.01 ms
   Waiting for query cache lock	0.00 ms
   Waiting on query cache mutex	0.03 ms
   init	0.01 ms
   optimizing	0.01 ms
   statistics	0.03 ms
   preparing	0.00 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   Waiting for query cache lock	0.00 ms
   Waiting on query cache mutex	0.05 ms
   freeing items	0.03 ms
   Waiting for query cache lock	0.00 ms
   Waiting on query cache mutex	0.00 ms
   freeing items	0.00 ms
   storing result in query cache	0.00 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File e numero di linea
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
   12	JSessionStorageDatabase->read()	Chiamata uguale alla linea sottostante.
   11	session_start()	JROOT/libraries/joomla/session/handler/native.php:259
   10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
   9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
   8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
   7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
   6	JSession->start()	JROOT/libraries/cms/application/cms.php:773
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::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.42 ms Dopo l'ultima query: 3.96 ms Memoria query: 0.004 MB memoria prima della query: 0.764 MB
   Query duplicate: #24

   DELETE 
   
     FROM `joom2_session`
   
     WHERE `time` < '1732170839'

   Explain

   EXPLAIN non possibile sulla query: DELETE FROM `joom2_session` WHERE `time` < '1732170839'

   Profilo

   Status	Duration
   starting	0.02 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   System lock	0.01 ms
   init	0.03 ms
   updating	0.02 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.03 ms
   freeing items	0.04 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File e numero di linea
   6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:790
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

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

   ---

3. Tempo della query: 0.43 ms Dopo l'ultima query: 0.21 ms Memoria query: 0.023 MB memoria prima della query: 0.770 MB Righe restituite: 0
   Query duplicate: #25

   SELECT `session_id`
   
     FROM `joom2_session`
   
     WHERE `session_id` = 'nqo61p7uvb6iqvq0ic7dm3kme7' 
     LIMIT 1

   Explain

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

   Profilo

   Status	Duration
   starting	0.01 ms
   Waiting for query cache lock	0.00 ms
   Waiting on query cache mutex	0.01 ms
   checking query cache for query	0.02 ms
   checking permissions	0.02 ms
   Opening tables	0.01 ms
   System lock	0.01 ms
   Waiting for query cache lock	0.00 ms
   Waiting on query cache mutex	0.02 ms
   init	0.01 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.00 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   Waiting for query cache lock	0.01 ms
   Waiting on query cache mutex	0.00 ms
   freeing items	0.03 ms
   Waiting for query cache lock	0.01 ms
   Waiting on query cache mutex	0.00 ms
   freeing items	0.00 ms
   storing result in query cache	0.00 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File e numero di linea
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

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

   ---

4. Tempo della query: 0.41 ms Dopo l'ultima query: 0.18 ms Memoria query: 0.005 MB memoria prima della query: 0.777 MB

   INSERT INTO `joom2_session`
   (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
     VALUES 
   ('nqo61p7uvb6iqvq0ic7dm3kme7', 0, 1, '1732171739', 0, '')

   Explain

   EXPLAIN non possibile sulla query: INSERT INTO `joom2_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('nqo61p7uvb6iqvq0ic7dm3kme7', 0, 1, '1732171739', 0, '')

   Profilo

   Status	Duration
   starting	0.03 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   System lock	0.00 ms
   init	0.01 ms
   update	0.05 ms
   Waiting for query cache lock	0.00 ms
   update	0.02 ms
   end	0.00 ms
   query end	0.04 ms
   closing tables	0.01 ms
   freeing items	0.03 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File e numero di linea
   7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:212
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

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

   ---

5. Tempo della query: 0.31 ms Dopo l'ultima query: 5.38 ms Memoria query: 0.025 MB memoria prima della query: 0.898 MB Righe restituite: 2

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

   Explain

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

   Profilo

   Status	Duration
   starting	0.01 ms
   Waiting for query cache lock	0.00 ms
   Waiting on query cache mutex	0.00 ms
   checking query cache for query	0.01 ms
   checking privileges on cached	0.00 ms
   checking permissions	0.00 ms
   checking permissions	0.00 ms
   sending cached result to clien	0.04 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File e numero di linea
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:835
   9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:904
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->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.15 ms Dopo l'ultima query: 0.57 ms Memoria query: 0.025 MB memoria prima della query: 0.905 MB Righe restituite: 5

   SELECT id, rules
   
     FROM `joom2_viewlevels`

   Explain

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

   Profilo

   Status	Duration
   starting	0.01 ms
   Waiting for query cache lock	0.01 ms
   Waiting on query cache mutex	0.00 ms
   checking query cache for query	0.00 ms
   checking privileges on cached	0.01 ms
   checking permissions	0.00 ms
   sending cached result to clien	0.03 ms
   logging slow query	0.02 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File e numero di linea
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:921
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->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: 3.70 ms Dopo l'ultima query: 17.45 ms Memoria query: 0.056 MB memoria prima della query: 1.297 MB Righe restituite: 30

   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 joom2_menu AS m
   
     LEFT JOIN joom2_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	34	Using where; Using filesort
   1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	Sql793024_2.m.component_id	1

   Profilo

   Status	Duration
   starting	0.02 ms
   Waiting for query cache lock	0.00 ms
   Waiting on query cache mutex	0.01 ms
   checking query cache for query	0.09 ms
   checking permissions	0.00 ms
   checking permissions	0.01 ms
   Opening tables	0.04 ms
   System lock	0.02 ms
   Waiting for query cache lock	0.00 ms
   Waiting on query cache mutex	0.08 ms
   init	0.03 ms
   optimizing	0.03 ms
   statistics	0.05 ms
   preparing	0.05 ms
   executing	0.00 ms
   Sorting result	0.23 ms
   Sending data	0.31 ms
   Waiting for query cache lock	0.00 ms
   Waiting on query cache mutex	0.71 ms
   Sending data	0.80 ms
   end	0.01 ms
   query end	0.00 ms
   closing tables	0.03 ms
   freeing items	0.03 ms
   Waiting for query cache lock	0.00 ms
   Waiting on query cache mutex	0.54 ms
   freeing items	0.07 ms
   Waiting for query cache lock	0.00 ms
   Waiting on query cache mutex	0.07 ms
   freeing items	0.00 ms
   storing result in query cache	0.00 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File e numero di linea
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
   14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
   13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
   12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
   11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
   10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
   9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
   8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
   7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
   6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
   5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1115
   4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
   3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->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.55 ms Dopo l'ultima query: 9.99 ms Memoria query: 0.007 MB memoria prima della query: 1.580 MB

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

   Explain

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

   Profilo

   Status	Duration
   starting	0.03 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   System lock	0.00 ms
   init	0.10 ms
   Updating	0.06 ms
   end	0.00 ms
   Waiting for query cache lock	0.00 ms
   end	0.04 ms
   query end	0.04 ms
   closing tables	0.02 ms
   freeing items	0.05 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File e numero di linea
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
   9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
   8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
   7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
   6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
   5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:977
   4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
   3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->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: 1.36 ms Dopo l'ultima query: 9.51 ms Memoria query: 0.035 MB memoria prima della query: 1.773 MB Righe restituite: 8

   SHOW FULL COLUMNS 
     FROM `joom2_assets`

   Explain

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

   Profilo

   Status	Duration
   starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.40 ms
   System lock	0.01 ms
   init	0.01 ms
   optimizing	0.00 ms
   statistics	0.01 ms
   preparing	0.01 ms
   executing	0.01 ms
   Opening tables	0.02 ms
   checking permissions	0.05 ms
   checking permissions	0.02 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.02 ms
   Sending data	0.05 ms
   end	0.00 ms
   query end	0.01 ms
   closing tables	0.00 ms
   removing tmp table	0.34 ms
   closing tables	0.00 ms
   freeing items	0.04 ms
   logging slow query	0.00 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File e numero di linea
   21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
   19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
   18	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
   17	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
   16	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
   15	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
   14	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
   13	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
   12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
   11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:435
   10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
   9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
   8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
   7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
   6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
   5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
   4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
   3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->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.38 ms Dopo l'ultima query: 1.70 ms Memoria query: 0.031 MB memoria prima della query: 1.806 MB Righe restituite: 1

    SELECT *
    
      FROM joom2_assets
    
      WHERE `id` = '1'

    Explain

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

    Profilo

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.03 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    16	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    15	JTable->load()	JROOT/libraries/joomla/access/access.php:697
    14	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
    13	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
    11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:435
    10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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: 1.64 ms Dopo l'ultima query: 0.18 ms Memoria query: 0.027 MB memoria prima della query: 1.816 MB Righe restituite: 1

    SELECT a.rules
    
      FROM joom2_assets AS a
    
      WHERE (a.id = 1 OR a.name = 'root.1')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	Using union(PRIMARY,idx_asset_name); Using where

    Profilo

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	1.39 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.03 ms
    logging slow query	0.00 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    14	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
    13	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
    11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:435
    10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.95 ms Dopo l'ultima query: 1.16 ms Memoria query: 0.031 MB memoria prima della query: 1.829 MB Righe restituite: 36

    SELECT element
    
      FROM joom2_extensions
    
      WHERE type = 'component' 
      AND enabled = '1'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	joom2_extensions	ref	extension	extension	82	const	36	Using where

    Profilo

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.01 ms
    checking query cache for query	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.20 ms
    init	0.02 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.17 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.05 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.01 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    16	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:413
    15	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
    14	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    13	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
    11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:435
    10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.36 ms Dopo l'ultima query: 0.23 ms Memoria query: 0.032 MB memoria prima della query: 1.846 MB Righe restituite: 36

    SELECT a.name, a.rules
    
      FROM joom2_assets AS a
    
      WHERE (a.name IN ('com_admin','com_admintools','com_ajax','com_akeeba','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_ffexplorer','com_finder','com_hello','com_installer','com_j2xml','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper') OR a.name = 'root.1')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ALL	idx_asset_name	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	100	Using where

    Profilo

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.01 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.03 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    16	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
    15	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
    14	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    13	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
    11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:435
    10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

14. Tempo della query: 1.80 ms Dopo l'ultima query: 2.95 ms Memoria query: 0.039 MB memoria prima della query: 2.048 MB Righe restituite: 30

    SHOW FULL COLUMNS 
      FROM `joom2_content`

    Explain

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

    Profilo

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.44 ms
    System lock	0.01 ms
    init	0.01 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Opening tables	0.02 ms
    checking permissions	0.04 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    Sending data	0.11 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    removing tmp table	0.27 ms
    closing tables	0.01 ms
    freeing items	0.05 ms
    logging slow query	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    12	JTable->__construct()	JROOT/libraries/legacy/table/content.php:31
    11	JTableContent->__construct()	JROOT/libraries/joomla/table/table.php:308
    10	JTable::getInstance()	JROOT/components/com_content/models/article.php:264
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.80 ms Dopo l'ultima query: 3.66 ms Memoria query: 0.094 MB memoria prima della query: 2.126 MB Righe restituite: 1

    SELECT *
    
      FROM joom2_content
    
      WHERE `id` = '28'

    Explain

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

    Profilo

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.01 ms
    checking query cache for query	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.03 ms
    init	0.05 ms
    optimizing	0.01 ms
    statistics	0.79 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.19 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.02 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.00 ms
    logging slow query	0.00 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    10	JTable->load()	JROOT/components/com_content/models/article.php:265
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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: 0.85 ms Dopo l'ultima query: 0.22 ms Memoria query: 0.007 MB memoria prima della query: 2.191 MB

    UPDATE joom2_content
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '28'

    Explain

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

    Profilo

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    init	0.04 ms
    Updating	0.07 ms
    end	0.01 ms
    Waiting for query cache lock	0.00 ms
    end	0.34 ms
    query end	0.05 ms
    closing tables	0.02 ms
    freeing items	0.05 ms
    logging slow query	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1228
    10	JTable->hit()	JROOT/components/com_content/models/article.php:266
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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: 9.16 ms Dopo l'ultima query: 4.47 ms Memoria query: 0.067 MB memoria prima della query: 2.300 MB Righe restituite: 1

    SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
    
      FROM joom2_content AS a
    
      LEFT JOIN joom2_categories AS c 
      on c.id = a.catid
    
      LEFT JOIN joom2_users AS u 
      on u.id = a.created_by
    
      LEFT JOIN joom2_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN joom2_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER JOIN  (SELECT cat.id as id 
      FROM joom2_categories AS cat JOIN joom2_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published <= 0 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      WHERE a.id = 28

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	<derived2>	system	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	0	const row not found
    1	PRIMARY	a	const	PRIMARY	PRIMARY	4	const	1
    1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1
    1	PRIMARY	u	const	PRIMARY	PRIMARY	4	const	1
    1	PRIMARY	parent	const	PRIMARY	PRIMARY	4	const	1
    1	PRIMARY	v	const	PRIMARY	PRIMARY	4	const	0	unique row not found
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	1	Using where; Using temporary; Using filesort
    2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	7	Using where; Using index; Using join buffer

    Profilo

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.02 ms
    checking query cache for query	0.25 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    System lock	0.06 ms
    optimizing	0.02 ms
    statistics	0.06 ms
    preparing	7.42 ms
    Creating tmp table	0.04 ms
    executing	0.00 ms
    Copying to tmp table	0.05 ms
    Sorting result	0.03 ms
    Sending data	0.01 ms
    removing tmp table	0.01 ms
    Sending data	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.10 ms
    init	0.10 ms
    optimizing	0.02 ms
    statistics	0.14 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.11 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.06 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    removing tmp table	0.01 ms
    closing tables	0.05 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.01 ms
    freeing items	0.05 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.01 ms
    freeing items	0.00 ms
    storing result in query cache	0.04 ms
    logging slow query	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    14	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:159
    13	ContentModelArticle->getItem()	JROOT/libraries/legacy/view/legacy.php:408
    12	JViewLegacy->get()	JROOT/components/com_content/views/article/view.html.php:42
    11	ContentViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.87 ms Dopo l'ultima query: 3.80 ms Memoria query: 0.039 MB memoria prima della query: 2.379 MB Righe restituite: 2

    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 joom2_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM joom2_categories AS cat JOIN joom2_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN joom2_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.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 badcats.id is null 
      AND s.id=2
    
      GROUP BY 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
    
      ORDER BY c.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	<derived2>	system	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	0	const row not found
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using filesort
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	7	Using where
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	2	Using where; Using temporary; Using filesort
    2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	7	Using where; Using index; Using join buffer

    Profilo

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.02 ms
    checking query cache for query	0.03 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.04 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    14	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    13	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
    12	ContentHelperRoute::getArticleRoute()	JROOT/components/com_content/views/article/view.html.php:71
    11	ContentViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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: 1.39 ms Dopo l'ultima query: 0.78 ms Memoria query: 0.037 MB memoria prima della query: 2.442 MB Righe restituite: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `joom2_contentitem_tag_map` AS m 
    
      INNER JOIN `joom2_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      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	m	ALL	idx_tag_type	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	Sql793024_2.m.tag_id	1	Using where

    Profilo

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.01 ms
    checking query cache for query	0.06 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.03 ms
    init	0.05 ms
    optimizing	0.02 ms
    statistics	0.09 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.06 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.04 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.02 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
    12	JHelperTags->getItemTags()	JROOT/components/com_content/views/article/view.html.php:156
    11	ContentViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.36 ms Dopo l'ultima query: 4.65 ms Memoria query: 0.034 MB memoria prima della query: 2.470 MB Righe restituite: 39

    SELECT a.id, a.parent_id
    
      FROM joom2_assets AS a
    
      WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ALL	PRIMARY,idx_asset_name	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	100	Using where

    Profilo

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.02 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.05 ms
    logging slow query	0.00 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File e numero di linea
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:332
    18	JAccess::preloadPermissionsParentIdMapping()	JROOT/libraries/joomla/access/access.php:240
    17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    16	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    15	JUser->authorise()	JROOT/plugins/content/pagenavigation/pagenavigation.php:54
    14	PlgContentPagenavigation->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:69
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:167
    11	ContentViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.36 ms Dopo l'ultima query: 1.16 ms Memoria query: 0.035 MB memoria prima della query: 2.507 MB Righe restituite: 39

    SELECT a.id, a.name, a.rules
    
      FROM joom2_assets AS a
    
      WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1 )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ALL	PRIMARY,idx_asset_name	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	100	Using where

    Profilo

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.01 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.05 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1255
    19	JDatabaseDriver->getIterator()	JROOT/libraries/joomla/access/access.php:373
    18	JAccess::preloadPermissions()	JROOT/libraries/joomla/access/access.php:243
    17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    16	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    15	JUser->authorise()	JROOT/plugins/content/pagenavigation/pagenavigation.php:54
    14	PlgContentPagenavigation->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:69
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:167
    11	ContentViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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: 2.56 ms Dopo l'ultima query: 0.57 ms Memoria query: 0.033 MB memoria prima della query: 2.569 MB Righe restituite: 32

    SELECT a.id, a.title, a.catid, a.language, 
      CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
      CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
    
      FROM joom2_content AS a
    
      LEFT JOIN joom2_categories AS cc 
      ON cc.id = a.catid
    
      WHERE a.catid = 2 
      AND a.state = 1 
      AND a.access IN (1,1,5)  
      AND (a.state = 1 OR a.state = -1) 
      AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-11-21 06:48:59') 
      AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-11-21 06:48:59')
    
      ORDER BY  
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	index_merge	idx_access,idx_state,idx_catid	idx_state,idx_catid	1,4	NULL	5	Using intersect(idx_state,idx_catid); Using where; Using filesort
    1	SIMPLE	cc	const	PRIMARY	PRIMARY	4	const	1

    Profilo

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.02 ms
    checking query cache for query	0.14 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.05 ms
    init	0.07 ms
    optimizing	0.03 ms
    statistics	0.11 ms
    preparing	0.03 ms
    executing	0.00 ms
    Sorting result	1.16 ms
    Sending data	0.39 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.05 ms
    freeing items	0.06 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.01 ms
    logging slow query	0.00 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    15	JDatabaseDriver->loadObjectList()	JROOT/plugins/content/pagenavigation/pagenavigation.php:152
    14	PlgContentPagenavigation->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:69
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:167
    11	ContentViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.59 ms Dopo l'ultima query: 19.85 ms Memoria query: 0.029 MB memoria prima della query: 2.718 MB Righe restituite: 6

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM joom2_modules AS m
    
      LEFT JOIN joom2_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN joom2_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-11-21 06:48:59') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-21 06:48:59') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 127 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	8	Using where; Using filesort
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	Sql793024_2.m.id	1	Using where; Using index
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	Sql793024_2.m.module,const	1	Using where

    Profilo

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.01 ms
    checking query cache for query	0.12 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.05 ms
    init	0.06 ms
    optimizing	0.03 ms
    statistics	0.09 ms
    preparing	0.06 ms
    executing	0.00 ms
    Sorting result	0.21 ms
    Sending data	0.18 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.05 ms
    freeing items	0.02 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.18 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.01 ms
    logging slow query	0.00 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:152
    12	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:425
    11	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:361
    10	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
    9	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
    8	JDocumentHtml->countModules()	JROOT/templates/apicloudnature/index.php:34
    7	require JROOT/templates/apicloudnature/index.php	JROOT/libraries/joomla/document/html.php:578
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

24. Tempo della query: 0.43 ms Dopo l'ultima query: 3.27 ms Memoria query: 0.007 MB memoria prima della query: 2.730 MB
    Query duplicate: #2

    DELETE 
    
      FROM `joom2_session`
    
      WHERE `time` < '1732170839'

    Explain

    EXPLAIN non possibile sulla query: DELETE FROM `joom2_session` WHERE `time` < '1732170839'

    Profilo

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    init	0.05 ms
    updating	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.05 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:790
    10	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
    9	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
    8	JApplicationSite->__construct()	JROOT/templates/apicloudnature/index.php:134
    7	require JROOT/templates/apicloudnature/index.php	JROOT/libraries/joomla/document/html.php:578
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

25. Tempo della query: 0.67 ms Dopo l'ultima query: 0.21 ms Memoria query: 0.026 MB memoria prima della query: 2.740 MB Righe restituite: 1
    Query duplicate: #3

    SELECT `session_id`
    
      FROM `joom2_session`
    
      WHERE `session_id` = 'nqo61p7uvb6iqvq0ic7dm3kme7' 
      LIMIT 1

    Explain

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

    Profilo

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.01 ms
    checking query cache for query	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.03 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.19 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.01 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    12	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
    11	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
    10	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
    9	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
    8	JApplicationSite->__construct()	JROOT/templates/apicloudnature/index.php:134
    7	require JROOT/templates/apicloudnature/index.php	JROOT/libraries/joomla/document/html.php:578
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

23 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

1. 2 × SELECT `session_id` 
     FROM `joom2_session`

2. 1 × SELECT `data` 
     FROM `joom2_session`

3. 1 × SELECT a.id, a.title, a.catid, a.language, 
     CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
     CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug 
     FROM joom2_content AS a 
     LEFT JOIN joom2_categories AS cc 
     ON cc.id = a.catid

4. 1 × SELECT a.id, a.name, a.rules 
     FROM joom2_assets AS a

5. 1 × SELECT a.id, a.parent_id 
     FROM joom2_assets AS a

6. 1 × SELECT `m`.`tag_id`,`t`.* 
     FROM `joom2_contentitem_tag_map` AS m  
     INNER JOIN `joom2_tags` AS t  
     ON `m`.`tag_id` = `t`.`id`

7. 1 × 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 joom2_categories as c 
     LEFT JOIN  (SELECT cat.id as id 
     FROM joom2_categories AS cat JOIN joom2_categories AS parent 
     ON cat.lft BETWEEN parent.lft 
     AND parent.rgt

8. 1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
     CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
     CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count 
     FROM joom2_content AS a 
     LEFT JOIN joom2_categories AS c 
     on c.id = a.catid 
     LEFT JOIN joom2_users AS u 
     on u.id = a.created_by 
     LEFT JOIN joom2_categories as parent 
     ON parent.id = c.parent_id 
     LEFT JOIN joom2_content_rating AS v 
     ON a.id = v.content_id 
     LEFT 
     OUTER JOIN  (SELECT cat.id as id 
     FROM joom2_categories AS cat JOIN joom2_categories AS parent 
     ON cat.lft BETWEEN parent.lft 
     AND parent.rgt

9. 1 × SELECT a.name, a.rules 
     FROM joom2_assets AS a

10. 1 × SELECT * 
      FROM joom2_content

11. 1 × SELECT element 
      FROM joom2_extensions

12. 1 × SELECT a.rules 
      FROM joom2_assets AS a

13. 1 × SELECT * 
      FROM joom2_assets

14. 1 × 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 joom2_menu AS m 
      LEFT JOIN joom2_extensions AS e 
      ON m.component_id = e.extension_id

15. 1 × SELECT id, rules 
      FROM `joom2_viewlevels

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

17. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM joom2_modules AS m 
      LEFT JOIN joom2_modules_menu AS mm 
      ON mm.moduleid = m.id 
      LEFT JOIN joom2_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id

ALTRE tabelle:

1. 2 × DELETE  
     FROM `joom2_session`

2. 1 × INSERT INTO `joom2_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
     VALUES  ('nqo61p7uvb6iqvq0ic7dm3kme7', 0, 1, '1732171739', 0, ''

3. 1 × UPDATE `joom2_extensions` 
     SET `params` = '{\"mediaversion\":\"dfc19abebc5bb5cdccb7c0c89e428fbb\"}'

4. 1 × SHOW FULL COLUMNS 
     FROM `joom2_assets

5. 1 × SHOW FULL COLUMNS 
     FROM `joom2_content

6. 1 × UPDATE joom2_content 
     SET `hits` = (`hits` + 1)