Console Debug Joomla!

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1729095741,
                "last": 1729095741,
                "now": 1729095741
            }
        },
        "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

35 query eseguite 67.31 ms

1. Tempo della query: 0.33 ms Memoria query: 0.022 MB memoria prima della query: 0.674 MB Righe restituite: 0

   SELECT `data`
   
     FROM `w2bao_session`
   
     WHERE `session_id` = '5mok7pqrhnhnvgt2ugt5cavv4o'

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	w2bao_session	NULL	const	PRIMARY	PRIMARY	766	const	1	100.00	NULL

   Profilo

   Status	Duration
   starting	0.01 ms
   Waiting for query cache lock	0.00 ms
   Waiting on query cache mutex	0.00 ms
   starting	0.00 ms
   checking query cache for query	0.03 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.01 ms
   Waiting for query cache lock	0.00 ms
   Waiting on query cache mutex	0.00 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.03 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.00 ms
   freeing items	0.02 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
   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: 10.52 ms Dopo l'ultima query: 0.55 ms Memoria query: 0.003 MB memoria prima della query: 0.691 MB

   DELETE 
   
     FROM `w2bao_session`
   
     WHERE `time` < '1729094841'

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	DELETE	w2bao_session	NULL	range	time	time	59	const	1	100.00	Using where

   Profilo

   Status	Duration
   starting	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	10.20 ms
   System lock	0.04 ms
   updating	0.02 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.02 ms
   freeing items	0.05 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.77 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.019 MB memoria prima della query: 0.696 MB Righe restituite: 0

   SELECT `session_id`
   
     FROM `w2bao_session`
   
     WHERE `session_id` = '5mok7pqrhnhnvgt2ugt5cavv4o' 
     LIMIT 1

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	w2bao_session	NULL	const	PRIMARY	PRIMARY	766	const	1	100.00	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
   starting	0.00 ms
   checking query cache for query	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.01 ms
   Waiting for query cache lock	0.27 ms
   Waiting on query cache mutex	0.01 ms
   System lock	0.04 ms
   optimizing	0.02 ms
   statistics	0.04 ms
   executing	0.02 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   Waiting for query cache lock	0.01 ms
   Waiting on query cache mutex	0.01 ms
   freeing items	0.07 ms
   Waiting for query cache lock	0.01 ms
   Waiting on query cache mutex	0.01 ms
   freeing items	0.01 ms
   storing result in query cache	0.01 ms
   cleaning up	0.01 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.68 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.003 MB memoria prima della query: 0.700 MB

   INSERT INTO `w2bao_session`
   (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
     VALUES 
   ('5mok7pqrhnhnvgt2ugt5cavv4o', 0, 1, '1729095741', 0, '')

   Explain

   EXPLAIN non possibile sulla query: INSERT INTO `w2bao_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('5mok7pqrhnhnvgt2ugt5cavv4o', 0, 1, '1729095741', 0, '')

   Profilo

   Status	Duration
   starting	0.08 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.02 ms
   System lock	0.01 ms
   update	0.14 ms
   Waiting for query cache lock	0.01 ms
   update	0.03 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.10 ms
   freeing items	0.06 ms
   cleaning up	0.01 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: 1.70 ms Dopo l'ultima query: 0.43 ms Memoria query: 0.022 MB memoria prima della query: 0.722 MB Righe restituite: 32

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

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	w2bao_extensions	NULL	ref	extension	extension	82	const	32	100.00	NULL

   Profilo

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

   Call Stack

   #	Caller	File e numero di linea
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   8	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:152
   7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
   6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
   5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
   4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:589
   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: 0.28 ms Dopo l'ultima query: 0.39 ms Memoria query: 0.021 MB memoria prima della query: 0.737 MB Righe restituite: 1

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

   Explain

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

   Profilo

   Status	Duration
   starting	0.02 ms
   Waiting for query cache lock	0.01 ms
   Waiting on query cache mutex	0.01 ms
   starting	0.01 ms
   checking query cache for query	0.01 ms
   checking privileges on cached	0.01 ms
   checking permissions	0.02 ms
   checking permissions	0.01 ms
   sending cached result to clien	0.05 ms
   cleaning up	0.02 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]

   ---

7. Tempo della query: 0.25 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.021 MB memoria prima della query: 0.741 MB Righe restituite: 3

   SELECT id, rules
   
     FROM `w2bao_viewlevels`

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	w2bao_viewlevels	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	3	100.00	NULL

   Profilo

   Status	Duration
   starting	0.02 ms
   Waiting for query cache lock	0.01 ms
   Waiting on query cache mutex	0.01 ms
   starting	0.01 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.04 ms
   cleaning up	0.01 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]

   ---

8. Tempo della query: 3.08 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.023 MB memoria prima della query: 0.749 MB Righe restituite: 49

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

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	w2bao_extensions	NULL	ref	extension	extension	82	const	63	0.62	Using index condition; Using where; Using filesort

   Profilo

   Status	Duration
   starting	0.02 ms
   Waiting for query cache lock	0.01 ms
   Waiting on query cache mutex	0.01 ms
   starting	0.01 ms
   checking query cache for query	0.10 ms
   checking permissions	0.02 ms
   Opening tables	0.02 ms
   init	0.04 ms
   System lock	0.01 ms
   Waiting for query cache lock	0.01 ms
   Waiting on query cache mutex	0.01 ms
   System lock	0.08 ms
   optimizing	0.03 ms
   statistics	0.34 ms
   preparing	0.08 ms
   Sorting result	0.01 ms
   executing	0.01 ms
   Sending data	0.02 ms
   Creating sort index	1.94 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.03 ms
   freeing items	0.02 ms
   Waiting for query cache lock	0.01 ms
   Waiting on query cache mutex	0.01 ms
   freeing items	0.05 ms
   Waiting for query cache lock	0.01 ms
   Waiting on query cache mutex	0.01 ms
   freeing items	0.01 ms
   storing result in query cache	0.01 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File e numero di linea
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   7	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
   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]

   ---

9. Tempo della query: 0.40 ms Dopo l'ultima query: 10.76 ms Memoria query: 0.023 MB memoria prima della query: 1.153 MB Righe restituite: 1
   Query duplicate: #10

   SELECT template
   
     FROM w2bao_template_styles as s
   
     WHERE s.client_id = 0 
     AND s.home = 1

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	s	NULL	ALL	idx_home	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	3	33.33	Using where

   Profilo

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

   Call Stack

   #	Caller	File e numero di linea
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   13	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
   12	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
   11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
   10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
   9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:95
   8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
   7	plgSystemRokCommon->__construct()	JROOT/libraries/cms/plugin/helper.php:255
   6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
   5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
   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]

   ---

10. Tempo della query: 0.27 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.023 MB memoria prima della query: 1.161 MB Righe restituite: 1
    Query duplicate: #9

    SELECT template
    
      FROM w2bao_template_styles as s
    
      WHERE s.client_id = 0 
      AND s.home = 1

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	NULL	ALL	idx_home	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	3	33.33	Using where

    Profilo

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.03 ms
    starting	0.01 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
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    14	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
    13	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67
    12	RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106
    11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
    10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
    9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:95
    8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
    7	plgSystemRokCommon->__construct()	JROOT/libraries/cms/plugin/helper.php:255
    6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
    5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    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]

    ---

11. Tempo della query: 0.35 ms Dopo l'ultima query: 1.31 ms Memoria query: 0.021 MB memoria prima della query: 1.288 MB Righe restituite: 2

    SELECT extension, file, type
    
      FROM w2bao_rokcommon_configs
    
      ORDER BY priority

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	w2bao_rokcommon_configs	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	2	100.00	Using filesort

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rokcommon/rokcommon.php:131
    8	plgSystemRokCommon->processRegisteredConfigs()	JROOT/plugins/system/rokcommon/rokcommon.php:75
    7	plgSystemRokCommon->__construct()	JROOT/libraries/cms/plugin/helper.php:255
    6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
    5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    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]

    ---

12. Tempo della query: 1.68 ms Dopo l'ultima query: 8.91 ms Memoria query: 0.025 MB memoria prima della query: 1.431 MB Righe restituite: 17

    SHOW FULL COLUMNS 
      FROM `w2bao_extensions`

    Explain

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

    Profilo

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.31 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.02 ms
    executing	0.02 ms
    Opening tables	0.02 ms
    checking permissions	0.06 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.04 ms
    checking permissions	0.07 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.03 ms
    Sending data	0.19 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    removing tmp table	0.07 ms
    closing tables	0.01 ms
    freeing items	0.08 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    13	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    12	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    11	JTable->__construct()	JROOT/libraries/joomla/table/extension.php:31
    10	JTableExtension->__construct()	JROOT/libraries/joomla/table/table.php:308
    9	JTable::getInstance()	JROOT/plugins/system/roksprocket/roksprocket.php:45
    8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    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]

    ---

13. Tempo della query: 8.46 ms Dopo l'ultima query: 0.83 ms Memoria query: 0.021 MB memoria prima della query: 1.459 MB Righe restituite: 1

    SELECT `extension_id`
    
      FROM `w2bao_extensions`
    
      WHERE type = 'component' 
      AND element = 'com_roksprocket'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	w2bao_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

    Profilo

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.88 ms
    starting	0.01 ms
    checking query cache for query	6.07 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.03 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.24 ms
    System lock	0.04 ms
    optimizing	0.02 ms
    statistics	0.60 ms
    preparing	0.04 ms
    executing	0.01 ms
    Sending data	0.08 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.01 ms
    Waiting on query cache mutex	0.01 ms
    freeing items	0.06 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.01 ms
    freeing items	0.01 ms
    storing result in query cache	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    10	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/table/extension.php:109
    9	JTableExtension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:47
    8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    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]

    ---

14. Tempo della query: 0.76 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.021 MB memoria prima della query: 1.465 MB Righe restituite: 1
    Query duplicate: #16

    SELECT *
    
      FROM w2bao_extensions
    
      WHERE `extension_id` = '10057'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	w2bao_extensions	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    10	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    9	JTable->load()	JROOT/plugins/system/roksprocket/roksprocket.php:54
    8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    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]

    ---

15. Tempo della query: 1.37 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.021 MB memoria prima della query: 1.469 MB Righe restituite: 1

    SELECT `extension_id`
    
      FROM `w2bao_extensions`
    
      WHERE type = 'module' 
      AND element = 'mod_roksprocket'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	w2bao_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

    Profilo

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.07 ms
    starting	0.01 ms
    checking query cache for query	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.03 ms
    System lock	0.02 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.04 ms
    System lock	0.04 ms
    optimizing	0.02 ms
    statistics	0.65 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.08 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.01 ms
    Waiting on query cache mutex	0.01 ms
    freeing items	0.06 ms
    Waiting for query cache lock	0.02 ms
    Waiting on query cache mutex	0.09 ms
    freeing items	0.01 ms
    storing result in query cache	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    10	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/table/extension.php:109
    9	JTableExtension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:70
    8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    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]

    ---

16. Tempo della query: 0.41 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.021 MB memoria prima della query: 1.475 MB Righe restituite: 1
    Query duplicate: #14

    SELECT *
    
      FROM w2bao_extensions
    
      WHERE `extension_id` = '10057'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	w2bao_extensions	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profilo

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.02 ms
    Waiting on query cache mutex	0.06 ms
    starting	0.01 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
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    10	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    9	JTable->load()	JROOT/plugins/system/roksprocket/roksprocket.php:76
    8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    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]

    ---

17. Tempo della query: 5.16 ms Dopo l'ultima query: 90.47 ms Memoria query: 0.067 MB memoria prima della query: 1.633 MB Righe restituite: 38

    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 w2bao_menu AS m
    
      LEFT JOIN w2bao_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	1	5.00	Using index condition; Using where; Using filesort
    1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	Sql1535287_1.m.component_id	1	100.00	Using where

    Profilo

    Status	Duration
    starting	0.03 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.02 ms
    starting	0.03 ms
    checking query cache for query	0.15 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.11 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.01 ms
    System lock	0.04 ms
    optimizing	0.03 ms
    statistics	0.16 ms
    preparing	0.04 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.05 ms
    Creating sort index	2.88 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.01 ms
    Creating sort index	0.81 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.04 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.01 ms
    freeing items	0.21 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.01 ms
    freeing items	0.01 ms
    storing result in query cache	0.01 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/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]

    ---

18. Tempo della query: 1.36 ms Dopo l'ultima query: 9.17 ms Memoria query: 0.022 MB memoria prima della query: 1.904 MB Righe restituite: 1

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	w2bao_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

    Profilo

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    starting	0.01 ms
    checking query cache for query	0.10 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.03 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.00 ms
    System lock	0.07 ms
    optimizing	0.02 ms
    statistics	0.54 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.11 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.01 ms
    Waiting on query cache mutex	0.02 ms
    freeing items	0.06 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.01 ms
    freeing items	0.01 ms
    storing result in query cache	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    12	JDatabaseDriver->loadObject()	JROOT/libraries/joomla/cache/controller/callback.php:152
    11	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
    10	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
    9	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
    8	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
    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]

    ---

19. Tempo della query: 1.28 ms Dopo l'ultima query: 0.31 ms Memoria query: 0.005 MB memoria prima della query: 1.894 MB

    UPDATE `w2bao_extensions`
    
      SET `params` = '{\"mediaversion\":\"5f2e487581dc6a5e0eeefeba24d3b385\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	UPDATE	w2bao_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

    Profilo

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.03 ms
    System lock	0.47 ms
    updating	0.15 ms
    end	0.01 ms
    Waiting for query cache lock	0.01 ms
    end	0.20 ms
    query end	0.01 ms
    closing tables	0.06 ms
    freeing items	0.07 ms
    cleaning up	0.01 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]

    ---

20. Tempo della query: 0.38 ms Dopo l'ultima query: 1.01 ms Memoria query: 0.019 MB memoria prima della query: 1.930 MB Righe restituite: 1

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	w2bao_languages	NULL	system	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	100.00	NULL

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
    5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:329
    4	JApplicationSite->getParams()	JROOT/libraries/cms/application/site.php:135
    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: 1.61 ms Dopo l'ultima query: 0.48 ms Memoria query: 0.019 MB memoria prima della query: 1.939 MB Righe restituite: 2

    SELECT id, home, template, s.params
    
      FROM w2bao_template_styles as s
    
      LEFT JOIN w2bao_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	3	1.67	Using index condition; Using where
    1	SIMPLE	s	NULL	ref	idx_template	idx_template	202	Sql1535287_1.e.element	2	33.33	Using index condition; Using where

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    5	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
    4	JApplicationSite->getTemplate()	JROOT/libraries/cms/application/site.php:165
    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: 1.17 ms Dopo l'ultima query: 7.78 ms Memoria query: 0.027 MB memoria prima della query: 2.073 MB Righe restituite: 8

    SHOW FULL COLUMNS 
      FROM `w2bao_assets`

    Explain

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

    Profilo

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.25 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.03 ms
    Opening tables	0.03 ms
    checking permissions	0.05 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 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.01 ms
    removing tmp table	0.06 ms
    closing tables	0.01 ms
    freeing items	0.07 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]

    ---

23. Tempo della query: 0.27 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.024 MB memoria prima della query: 2.095 MB Righe restituite: 1

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	w2bao_assets	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profilo

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.01 ms
    starting	0.01 ms
    checking query cache for query	0.02 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.05 ms
    cleaning up	0.01 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]

    ---

24. Tempo della query: 0.24 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.023 MB memoria prima della query: 2.101 MB Righe restituite: 1

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

    Explain

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

    Profilo

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.01 ms
    starting	0.01 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.04 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]

    ---

25. Tempo della query: 1.36 ms Dopo l'ultima query: 1.39 ms Memoria query: 0.025 MB memoria prima della query: 2.115 MB Righe restituite: 32

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	w2bao_extensions	NULL	ref	extension	extension	82	const	32	10.00	Using where

    Profilo

    Status	Duration
    starting	0.04 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.01 ms
    starting	0.01 ms
    checking query cache for query	0.08 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.03 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.01 ms
    System lock	0.03 ms
    optimizing	0.02 ms
    statistics	0.19 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.54 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.01 ms
    Waiting on query cache mutex	0.01 ms
    freeing items	0.04 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.01 ms
    freeing items	0.01 ms
    storing result in query cache	0.01 ms
    cleaning up	0.01 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]

    ---

26. Tempo della query: 0.38 ms Dopo l'ultima query: 0.33 ms Memoria query: 0.025 MB memoria prima della query: 2.128 MB Righe restituite: 32

    SELECT a.name, a.rules
    
      FROM w2bao_assets AS a
    
      WHERE (a.name IN ('com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_finder','com_installer','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_roksprocket','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper') OR a.name = 'root.1')

    Explain

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

    Profilo

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.02 ms
    starting	0.01 ms
    checking query cache for query	0.02 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.05 ms
    cleaning up	0.01 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]

    ---

27. Tempo della query: 1.87 ms Dopo l'ultima query: 3.67 ms Memoria query: 0.031 MB memoria prima della query: 2.294 MB Righe restituite: 30

    SHOW FULL COLUMNS 
      FROM `w2bao_content`

    Explain

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

    Profilo

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.29 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.02 ms
    executing	0.02 ms
    Opening tables	0.03 ms
    checking permissions	0.08 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 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.03 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.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.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    Sending data	0.28 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    removing tmp table	0.06 ms
    closing tables	0.02 ms
    freeing items	0.13 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/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]

    ---

28. Tempo della query: 1.18 ms Dopo l'ultima query: 1.94 ms Memoria query: 0.022 MB memoria prima della query: 2.343 MB Righe restituite: 1

    SELECT *
    
      FROM w2bao_content
    
      WHERE `id` = '35'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	w2bao_content	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profilo

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.01 ms
    starting	0.01 ms
    checking query cache for query	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.06 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.01 ms
    System lock	0.06 ms
    optimizing	0.02 ms
    statistics	0.32 ms
    preparing	0.02 ms
    executing	0.02 ms
    Sending data	0.08 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.07 ms
    freeing items	0.02 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.01 ms
    freeing items	0.05 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.01 ms
    freeing items	0.01 ms
    storing result in query cache	0.15 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]

    ---

29. Tempo della query: 0.68 ms Dopo l'ultima query: 0.29 ms Memoria query: 0.005 MB memoria prima della query: 2.349 MB

    UPDATE w2bao_content
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '35'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	UPDATE	w2bao_content	NULL	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

    Profilo

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.05 ms
    System lock	0.05 ms
    updating	0.12 ms
    end	0.01 ms
    Waiting for query cache lock	0.01 ms
    end	0.05 ms
    query end	0.01 ms
    closing tables	0.06 ms
    freeing items	0.07 ms
    cleaning up	0.01 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]

    ---

30. Tempo della query: 2.89 ms Dopo l'ultima query: 2.60 ms Memoria query: 0.023 MB memoria prima della query: 2.373 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 w2bao_content AS a
    
      LEFT JOIN w2bao_categories AS c 
      on c.id = a.catid
    
      LEFT JOIN w2bao_users AS u 
      on u.id = a.created_by
    
      LEFT JOIN w2bao_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN w2bao_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER JOIN  (SELECT cat.id as id 
      FROM w2bao_categories AS cat JOIN w2bao_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 = 35 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-10-16 16:22:21') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-10-16 16:22:21') 
      AND (a.state = 1 OR a.state =2)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	v	NULL	system	PRIMARY	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	0	0.00	const row not found
    1	PRIMARY	a	NULL	const	PRIMARY,idx_state	PRIMARY	4	const	1	100.00	NULL
    1	PRIMARY	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	PRIMARY	u	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	PRIMARY	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	const	1	100.00	Using index
    2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	203	NULL	1	100.00	Using index condition; Using temporary; Using filesort
    2	DERIVED	cat	NULL	ALL	PRIMARY,idx_left_right	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	12	11.11	Range checked for each record (index map: 0x11)

    Profilo

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.01 ms
    starting	0.03 ms
    checking query cache for query	0.48 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.01 ms
    checking permissions	0.01 ms
    Opening tables	0.06 ms
    init	0.28 ms
    System lock	0.02 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.01 ms
    System lock	0.10 ms
    optimizing	0.01 ms
    optimizing	0.02 ms
    statistics	0.11 ms
    preparing	0.04 ms
    Creating tmp table	0.03 ms
    Sorting result	0.04 ms
    statistics	0.25 ms
    preparing	0.03 ms
    executing	0.02 ms
    Sending data	0.13 ms
    executing	0.01 ms
    Sending data	0.17 ms
    Creating sort index	0.08 ms
    end	0.01 ms
    query end	0.02 ms
    removing tmp table	0.23 ms
    query end	0.01 ms
    closing tables	0.01 ms
    removing tmp table	0.07 ms
    closing tables	0.08 ms
    freeing items	0.05 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.01 ms
    freeing items	0.06 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.02 ms
    freeing items	0.01 ms
    storing result in query cache	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:159
    12	ContentModelArticle->getItem()	JROOT/libraries/legacy/view/legacy.php:408
    11	JViewLegacy->get()	JROOT/components/com_content/views/article/view.html.php:42
    10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
    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]

    ---

31. Tempo della query: 3.88 ms Dopo l'ultima query: 3.10 ms Memoria query: 0.023 MB memoria prima della query: 2.415 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 w2bao_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM w2bao_categories AS cat JOIN w2bao_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 w2bao_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) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=7
    
      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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Using filesort
    1	PRIMARY	c	NULL	range	cat_idx,idx_access,idx_left_right	cat_idx	208	NULL	4	55.55	Using index condition; Using where
    1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	Sql1535287_1.c.id	2	100.00	Using where; Not exists; Using index
    2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	203	NULL	2	100.00	Using index condition; Using temporary; Using filesort
    2	DERIVED	cat	NULL	ALL	PRIMARY,idx_left_right	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	12	11.11	Range checked for each record (index map: 0x11)

    Profilo

    Status	Duration
    starting	0.03 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.01 ms
    starting	0.03 ms
    checking query cache for query	0.42 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.26 ms
    System lock	0.02 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.02 ms
    System lock	0.07 ms
    optimizing	0.02 ms
    optimizing	0.02 ms
    statistics	0.15 ms
    preparing	0.04 ms
    Creating tmp table	0.03 ms
    Sorting result	0.04 ms
    statistics	0.28 ms
    preparing	0.15 ms
    Creating tmp table	0.22 ms
    Sorting result	0.01 ms
    executing	0.02 ms
    Sending data	0.14 ms
    executing	0.01 ms
    Sending data	0.17 ms
    Creating sort index	0.61 ms
    Creating sort index	0.11 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.07 ms
    query end	0.01 ms
    removing tmp table	0.19 ms
    query end	0.01 ms
    closing tables	0.01 ms
    removing tmp table	0.06 ms
    closing tables	0.04 ms
    freeing items	0.11 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.01 ms
    freeing items	0.06 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.04 ms
    freeing items	0.01 ms
    storing result in query cache	0.09 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    13	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    12	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
    11	ContentHelperRoute::getArticleRoute()	JROOT/components/com_content/views/article/view.html.php:71
    10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
    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]

    ---

32. Tempo della query: 1.83 ms Dopo l'ultima query: 1.07 ms Memoria query: 0.022 MB memoria prima della query: 2.441 MB Righe restituite: 0

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	ALL	idx_tag_type	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	6	16.67	Using where
    1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	Sql1535287_1.m.tag_id	1	85.71	Using where

    Profilo

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.53 ms
    starting	0.01 ms
    checking query cache for query	0.10 ms
    checking permissions	0.01 ms
    checking permissions	0.03 ms
    Opening tables	0.03 ms
    init	0.08 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.01 ms
    System lock	0.03 ms
    optimizing	0.03 ms
    statistics	0.13 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.11 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.01 ms
    Waiting on query cache mutex	0.01 ms
    freeing items	0.33 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.01 ms
    freeing items	0.02 ms
    storing result in query cache	0.11 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
    11	JHelperTags->getItemTags()	JROOT/components/com_content/views/article/view.html.php:156
    10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
    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]

    ---

33. Tempo della query: 6.43 ms Dopo l'ultima query: 18.31 ms Memoria query: 0.044 MB memoria prima della query: 2.855 MB Righe restituite: 15

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM w2bao_modules AS m
    
      LEFT JOIN w2bao_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN w2bao_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-10-16 16:22:21') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-10-16 16:22:21') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 107 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	ref	PRIMARY,published,newsfeeds	published	1	const	9	1.15	Using index condition; Using where; Using filesort
    1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	Sql1535287_1.m.id	1	40.00	Using where; Using index
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_folder_clientid	402	Sql1535287_1.m.module	11	1.00	Using index condition; Using where

    Profilo

    Status	Duration
    starting	0.03 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.01 ms
    starting	0.02 ms
    checking query cache for query	0.21 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    init	0.11 ms
    System lock	0.04 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.01 ms
    System lock	0.05 ms
    optimizing	0.06 ms
    statistics	0.19 ms
    preparing	0.08 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	3.90 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.05 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.01 ms
    freeing items	1.02 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.01 ms
    freeing items	0.01 ms
    storing result in query cache	0.07 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:152
    16	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:434
    15	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:370
    14	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
    13	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
    12	JDocumentHtml->countModules()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:54
    11	Warp\Joomla\Helper\WidgetsHelper->count()	JROOT/templates/jp-rooms/layouts/theme.config.php:28
    10	include JROOT/templates/jp-rooms/layouts/theme.config.php	JROOT/templates/jp-rooms/layouts/theme.php:10
    9	include JROOT/templates/jp-rooms/layouts/theme.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/index.php:16
    7	require JROOT/templates/jp-rooms/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]

    ---

34. Tempo della query: 1.99 ms Dopo l'ultima query: 10.82 ms Memoria query: 0.025 MB memoria prima della query: 2.915 MB Righe restituite: 0

    SELECT *
    
      FROM w2bao_banners
    
      WHERE '2024-10-16 16:22:21' >= 'reset' 
      AND `reset` != '0000-00-00 00:00:00' 
      AND `reset`!= NULL 
      AND (`checked_out` = 0 OR `checked_out` = 0)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	NULL	Impossible WHERE

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_banners/helpers/banners.php:79
    15	BannersHelper::updateReset()	JROOT/modules/mod_banners/mod_banners.php:19
    14	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/cms/module/helper.php:199
    13	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    12	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-rooms/layouts/theme.config.php:74
    10	include JROOT/templates/jp-rooms/layouts/theme.config.php	JROOT/templates/jp-rooms/layouts/theme.php:10
    9	include JROOT/templates/jp-rooms/layouts/theme.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/index.php:16
    7	require JROOT/templates/jp-rooms/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]

    ---

35. Tempo della query: 2.03 ms Dopo l'ultima query: 2.27 ms Memoria query: 0.026 MB memoria prima della query: 2.938 MB Righe restituite: 0

    SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
    
      FROM w2bao_banners as a
    
      LEFT JOIN w2bao_banner_clients AS cl 
      ON cl.id = a.cid
    
      WHERE a.state=1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-10-16 16:22:21') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-10-16 16:22:21') 
      AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
    
      ORDER BY a.sticky DESC,a.ordering 
      LIMIT 5

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	NULL	no matching row in const table

    Profilo

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.01 ms
    starting	0.01 ms
    checking query cache for query	0.20 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.95 ms
    init	0.09 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.01 ms
    System lock	0.04 ms
    optimizing	0.03 ms
    statistics	0.04 ms
    executing	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.06 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.01 ms
    freeing items	0.21 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.02 ms
    freeing items	0.01 ms
    storing result in query cache	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:310
    18	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:183
    17	JModelList->getItems()	JROOT/components/com_banners/models/banners.php:205
    16	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:44
    15	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    14	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/cms/module/helper.php:199
    13	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    12	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-rooms/layouts/theme.config.php:74
    10	include JROOT/templates/jp-rooms/layouts/theme.config.php	JROOT/templates/jp-rooms/layouts/theme.php:10
    9	include JROOT/templates/jp-rooms/layouts/theme.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/index.php:16
    7	require JROOT/templates/jp-rooms/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]

    ---