Console Debug Joomla!

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

18 query eseguite 139.52 ms

1. Tempo della query: 1.48 ms Memoria query: 0.025 MB memoria prima della query: 0.969 MB Righe restituite: 0

   SELECT `data`
   
     FROM `ecw3r_session`
   
     WHERE `session_id` = 'b4q74gmtj8b47bh5bb9iqhnmod'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	ecw3r_session	const	PRIMARY	PRIMARY	575	const	1	100.00	NULL

   Profilo

   Status	Duration
   starting	0.01 ms
   Waiting for query cache lock	0.01 ms
   Waiting on query cache mutex	0.50 ms
   init	0.01 ms
   checking query cache for query	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.17 ms
   init	0.02 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.03 ms
   optimizing	0.01 ms
   statistics	0.05 ms
   executing	0.01 ms
   end	0.01 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.04 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
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Same as call in the line below.
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:82
   10	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:648
   9	JSession->_start()	JROOT/libraries/joomla/session/session.php:608
   8	JSession->start()	JROOT/libraries/joomla/session/session.php:486
   7	JSession->get()	JROOT/libraries/joomla/session/session.php:443
   6	JSession->isNew()	JROOT/libraries/cms/application/cms.php:832
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:132
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:419
   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.60 ms Dopo l'ultima query: 4.91 ms Memoria query: 0.021 MB memoria prima della query: 0.984 MB Righe restituite: 0

   SELECT `session_id`
   
     FROM `ecw3r_session`
   
     WHERE `session_id` = 'b4q74gmtj8b47bh5bb9iqhnmod' 
     LIMIT 1

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	ecw3r_session	const	PRIMARY	PRIMARY	575	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
   init	0.01 ms
   checking query cache for query	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   init	0.02 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.02 ms
   optimizing	0.01 ms
   statistics	0.04 ms
   executing	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.02 ms
   freeing items	0.04 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
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
   7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:177
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:834
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:132
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:419
   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.82 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.003 MB memoria prima della query: 0.988 MB

   INSERT INTO `ecw3r_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('b4q74gmtj8b47bh5bb9iqhnmod', 1, '1728352688', 0, '', 0)

   Explain

   EXPLAIN non possibile sulla query: INSERT INTO `ecw3r_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('b4q74gmtj8b47bh5bb9iqhnmod', 1, '1728352688', 0, '', 0)

   Profilo

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

   Call Stack

   #	Caller	File and line number
   7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:217
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:834
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:132
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:419
   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.45 ms Dopo l'ultima query: 30.50 ms Memoria query: 0.022 MB memoria prima della query: 1.204 MB Righe restituite: 2

   SELECT b.id
   
     FROM ecw3r_usergroups AS a
   
     LEFT JOIN ecw3r_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	filtered	Extra
   1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
   1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	3	100.00	Using where

   Profilo

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

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:978
   9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:1047
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
   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:603
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
   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]

   ---

5. Tempo della query: 0.44 ms Dopo l'ultima query: 3.30 ms Memoria query: 0.023 MB memoria prima della query: 1.210 MB Righe restituite: 5

   SELECT id, rules
   
     FROM `ecw3r_viewlevels`

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	ecw3r_viewlevels	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	5	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
   init	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.04 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1064
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
   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:603
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
   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: 4.53 ms Dopo l'ultima query: 249.71 ms Memoria query: 0.006 MB memoria prima della query: 2.679 MB

   UPDATE `ecw3r_extensions`
   
     SET `params` = '{\"mediaversion\":\"6706c0be6454b81be3bf07e0d1ed3ea2\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	ecw3r_extensions	range	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	Using where

   Profilo

   Status	Duration
   starting	0.05 ms
   checking permissions	0.01 ms
   Opening tables	3.44 ms
   init	0.03 ms
   System lock	0.41 ms
   updating	0.11 ms
   end	0.01 ms
   Waiting for query cache lock	0.01 ms
   end	0.01 ms
   query end	0.00 ms
   closing tables	0.04 ms
   freeing items	0.05 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
   13	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
   12	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
   11	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
   10	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
   9	JFactory::getDocument()	JROOT/plugins/system/jcomments/jcomments.php:111
   8	plgSystemJComments->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
   5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1158
   4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
   3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
   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: 10.91 ms Dopo l'ultima query: 26.30 ms Memoria query: 0.036 MB memoria prima della query: 2.812 MB Righe restituite: 91

   SELECT *
   
     FROM `ecw3r_jcomments_settings`
   
     WHERE `lang` = '' 
     AND `component` = ''

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	ecw3r_jcomments_settings	ALL	PRIMARY	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	91	86.81	Using where

   Profilo

   Status	Duration
   starting	0.01 ms
   Waiting for query cache lock	0.00 ms
   Waiting on query cache mutex	0.00 ms
   init	0.01 ms
   checking query cache for query	0.03 ms
   checking permissions	0.01 ms
   Opening tables	9.16 ms
   init	0.03 ms
   System lock	0.01 ms
   Waiting for query cache lock	0.00 ms
   Waiting on query cache mutex	0.01 ms
   System lock	0.02 ms
   optimizing	0.02 ms
   statistics	0.62 ms
   preparing	0.02 ms
   executing	0.00 ms
   Sending data	0.18 ms
   end	0.01 ms
   query end	0.00 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.00 ms
   freeing items	0.07 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.26 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
   14	JDatabaseDriver->loadObjectList()	JROOT/components/com_jcomments/classes/config.php:140
   13	JCommentsCfg::_load()	JROOT/libraries/joomla/cache/controller/callback.php:169
   12	JCacheControllerCallback->get()	JROOT/components/com_jcomments/classes/config.php:159
   11	JCommentsCfg->load()	JROOT/components/com_jcomments/classes/config.php:47
   10	JCommentsCfg::getInstance()	JROOT/components/com_jcomments/helpers/system.php:39
   9	JCommentsSystemPluginHelper::getCSS()	JROOT/plugins/system/jcomments/jcomments.php:139
   8	plgSystemJComments->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
   5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1158
   4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
   3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
   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: 6.09 ms Dopo l'ultima query: 82.74 ms Memoria query: 0.032 MB memoria prima della query: 4.069 MB Righe restituite: 39

   SELECT `id`,`name`,`rules`,`parent_id`
   
     FROM `ecw3r_assets`
   
     WHERE `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_foxcontact','com_installer','com_jce','com_jcomments','com_joomlaupdate','com_k2','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_tz_multipurpose','com_tz_portfolio','com_uniterevolution2','com_users','com_weblinks','com_wrapper','com_xmap') OR `parent_id` = 0

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	ecw3r_assets	index_merge	idx_asset_name,idx_parent_id	idx_asset_name,idx_parent_id	152,4	NULL	40	100.00	Using sort_union(idx_asset_name,idx_parent_id); Using where

   Profilo

   Status	Duration
   starting	0.02 ms
   Waiting for query cache lock	0.06 ms
   Waiting on query cache mutex	0.00 ms
   init	0.01 ms
   checking query cache for query	0.11 ms
   checking permissions	0.01 ms
   Opening tables	3.40 ms
   init	0.11 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.05 ms
   optimizing	0.02 ms
   statistics	0.30 ms
   preparing	0.02 ms
   executing	0.00 ms
   Sending data	1.35 ms
   end	0.01 ms
   query end	0.00 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.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.09 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
   21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
   20	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
   19	JAccess::preload()	JROOT/libraries/joomla/access/access.php:529
   18	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
   17	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
   16	JUser->authorise()	JROOT/components/com_content/models/articles.php:113
   15	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:43
   14	ContentModelFeatured->populateState()	JROOT/libraries/legacy/model/legacy.php:434
   13	JModelLegacy->getState()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
   12	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:54
   11	ContentViewFeatured->display()	JROOT/libraries/joomla/cache/controller/view.php:98
   10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
   9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
   8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
   7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
   6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
   5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
   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:272
   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: 26.61 ms Dopo l'ultima query: 5.93 ms Memoria query: 0.026 MB memoria prima della query: 4.199 MB Righe restituite: 1

   SELECT COUNT(*)
   
     FROM ecw3r_content AS a
   
     LEFT JOIN ecw3r_categories AS c 
     ON c.id = a.catid
   
     LEFT JOIN ecw3r_users AS ua 
     ON ua.id = a.created_by
   
     LEFT JOIN ecw3r_users AS uam 
     ON uam.id = a.modified_by
   
     LEFT JOIN ecw3r_categories as parent 
     ON parent.id = c.parent_id
   
     WHERE a.featured = 1 
     AND a.access IN (1,1,5) 
     AND c.access IN (1,1,5) 
     AND c.published = 1 
     AND a.state = 1 
     AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-10-08 01:58:08') 
     AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-10-08 01:58:08')

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	a	ref	idx_access,idx_state,idx_catid,idx_featured_catid	idx_featured_catid	1	const	7	100.00	Using where
   1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	Sql1009297_1.a.catid	1	100.00	Using index condition; Using where
   1	SIMPLE	ua	index	PRIMARY	PRIMARY	4	NULL	2	100.00	Using where; Using index; Using join buffer (Block Nested Loop)
   1	SIMPLE	uam	index	PRIMARY	PRIMARY	4	NULL	2	100.00	Using where; Using index; Using join buffer (Block Nested Loop)
   1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	Sql1009297_1.c.parent_id	1	100.00	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
   init	0.01 ms
   checking query cache for query	0.13 ms
   checking permissions	0.01 ms
   checking permissions	0.00 ms
   checking permissions	0.00 ms
   checking permissions	0.00 ms
   checking permissions	0.01 ms
   Opening tables	25.09 ms
   init	0.07 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.06 ms
   optimizing	0.04 ms
   statistics	0.17 ms
   preparing	0.07 ms
   executing	0.01 ms
   Sending data	0.25 ms
   end	0.13 ms
   query end	0.01 ms
   closing tables	0.06 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.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.16 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
   16	JDatabaseDriver->loadResult()	JROOT/libraries/legacy/model/legacy.php:334
   15	JModelLegacy->_getListCount()	JROOT/libraries/legacy/model/list.php:281
   14	JModelList->getTotal()	JROOT/libraries/legacy/model/list.php:231
   13	JModelList->getPagination()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
   12	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:56
   11	ContentViewFeatured->display()	JROOT/libraries/joomla/cache/controller/view.php:98
   10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
   9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
   8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
   7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
   6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
   5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
   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:272
   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: 38.69 ms Dopo l'ultima query: 139.17 ms Memoria query: 0.039 MB memoria prima della query: 6.446 MB Righe restituite: 16

    SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM ecw3r_modules AS m
    
      LEFT JOIN ecw3r_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN ecw3r_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-08 01:58:08') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-10-08 01:58:08') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 398 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	191	100.00	Using index condition; Using where; Using filesort
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	Sql1009297_1.m.module,const	1	100.00	Using index condition; Using where
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	Sql1009297_1.m.id	3	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
    init	0.02 ms
    checking query cache for query	0.21 ms
    checking permissions	0.02 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	17.65 ms
    init	0.08 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.06 ms
    optimizing	0.04 ms
    statistics	0.13 ms
    preparing	0.06 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	15.16 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.06 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.83 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.22 ms
    freeing items	0.00 ms
    storing result in query cache	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:424
    17	JModuleHelper::_load()	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:102
    16	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:576
    15	JDocumentHtml->countModules()	JROOT/plugins/system/plazart/includes/core/template.php:1471
    14	PlazartTemplate::countModules()	JROOT/plugins/system/plazart/includes/core/template.php:998
    13	PlazartTemplate::showRow()	JROOT/plugins/system/plazart/includes/core/template.php:1118
    12	PlazartTemplate->generatelayout()	JROOT/plugins/system/plazart/includes/core/template.php:1445
    11	PlazartTemplate::layout()	JROOT/templates/tz_jollyany_joomla/layouts/default.php:38
    10	include JROOT/templates/tz_jollyany_joomla/layouts/default.php	JROOT/plugins/system/plazart/includes/core/template.php:138
    9	PlazartTemplate->loadLayout()	JROOT/templates/tz_jollyany_joomla/libraries/plazart.render.php:67
    8	PlazartRender->__construct()	JROOT/templates/tz_jollyany_joomla/index.php:26
    7	require JROOT/templates/tz_jollyany_joomla/index.php	JROOT/libraries/joomla/document/html.php:653
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1105
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:278
    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: 15.68 ms Dopo l'ultima query: 105.66 ms Memoria query: 0.058 MB memoria prima della query: 7.291 MB Righe restituite: 6

    SELECT ct.*,cat.title as category_title,cat.id as catid, cat.alias as category_alias,us.id,us.name as author,tz_xc.type as type_media,tz_xc.*
    
      FROM ecw3r_content as ct
    
      LEFT JOIN ecw3r_categories as cat 
      on cat.id = ct.catid
    
      LEFT JOIN ecw3r_users as us 
      on us.id = ct.created_by
    
      LEFT JOIN ecw3r_tz_portfolio_xref_content as tz_xc 
      on tz_xc.contentid = ct.id
    
      WHERE (tz_xc.type not in('audio','quote','link') or tz_xc.type is null) 
      AND  ct.catid IN(8) 
      and ct.state = 1  
      ORDER BY ct.created DESC 
      LIMIT 9

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ct	index_merge	idx_state,idx_catid	idx_catid,idx_state	4,1	NULL	5	80.00	Using intersect(idx_catid,idx_state); Using where; Using temporary; Using filesort
    1	SIMPLE	cat	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	us	ALL	PRIMARY	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	2	100.00	Using where; Using join buffer (Block Nested Loop)
    1	SIMPLE	tz_xc	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	92	100.00	Using where; Using join buffer (Block Nested Loop)

    Profilo

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    init	0.01 ms
    checking query cache for query	0.12 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	9.34 ms
    init	0.12 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.05 ms
    optimizing	0.03 ms
    statistics	0.11 ms
    preparing	0.06 ms
    Creating tmp table	0.23 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	3.15 ms
    Creating sort index	0.21 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.01 ms
    Creating sort index	0.20 ms
    end	0.13 ms
    removing tmp table	0.60 ms
    end	0.01 ms
    query end	0.00 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.00 ms
    freeing items	0.68 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
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_tz_news_pro/helper.php:105
    11	modTzNewsHelper::getList()	JROOT/modules/mod_tz_news_pro/mod_tz_news_pro.php:45
    10	include JROOT/modules/mod_tz_news_pro/mod_tz_news_pro.php	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:191
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:474
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1119
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:278
    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: 2.02 ms Dopo l'ultima query: 21.62 ms Memoria query: 0.036 MB memoria prima della query: 7.970 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 ecw3r_categories as c
    
      LEFT JOIN ecw3r_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 s.id=8
    
      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	filtered	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using filesort
    1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	17	70.59	Using where

    Profilo

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    init	0.02 ms
    checking query cache for query	0.23 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.14 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.06 ms
    optimizing	0.03 ms
    statistics	0.26 ms
    preparing	0.03 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.04 ms
    Creating sort index	0.14 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.00 ms
    Waiting on query cache mutex	0.23 ms
    freeing items	0.12 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	7.71 ms
    freeing items	0.01 ms
    storing result in query cache	0.18 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:301
    14	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:182
    13	JCategories->get()	JROOT/components/com_tz_portfolio/helpers/route.php:45
    12	TZ_PortfolioHelperRoute::getArticleRoute()	JROOT/modules/mod_tz_news_pro/helper.php:148
    11	modTzNewsHelper::getList()	JROOT/modules/mod_tz_news_pro/mod_tz_news_pro.php:45
    10	include JROOT/modules/mod_tz_news_pro/mod_tz_news_pro.php	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:191
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:474
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1119
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:278
    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: 9.96 ms Dopo l'ultima query: 138.27 ms Memoria query: 0.028 MB memoria prima della query: 10.627 MB Righe restituite: 1

    select * 
      from ecw3r_revslider_sliders 
      where id=6

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ecw3r_revslider_sliders	const	PRIMARY	PRIMARY	4	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.01 ms
    init	0.01 ms
    checking query cache for query	0.03 ms
    checking permissions	0.01 ms
    Opening tables	9.21 ms
    init	0.03 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.03 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.02 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.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.17 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:178
    18	UniteDBRev->fetchSql()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213
    17	UniteDBRev->fetch()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:223
    16	UniteDBRev->fetchSingle()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_slider.class.php:76
    15	RevSlider->initByID()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_slider.class.php:119
    14	RevSlider->initByMixed()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:1943
    13	RevSliderOutput->putSliderBase()	JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:82
    12	include JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:191
    11	JModuleHelper::renderModule()	JROOT/libraries/joomla/cache/controller/callback.php:169
    10	JCacheControllerCallback->get()	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:620
    9	JModuleHelper::moduleCache()	JROOT/libraries/joomla/document/renderer/html/module.php:90
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:474
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1119
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:278
    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: 10.18 ms Dopo l'ultima query: 0.37 ms Memoria query: 0.082 MB memoria prima della query: 10.651 MB Righe restituite: 5

    select * 
      from ecw3r_revslider_slides 
      where slider_id=6 
      order by slide_order

    Explain

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

    Profilo

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    init	0.01 ms
    checking query cache for query	0.03 ms
    checking permissions	0.01 ms
    Opening tables	8.86 ms
    init	0.03 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.03 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.27 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Creating sort index	0.08 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.00 ms
    Creating sort index	0.07 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.00 ms
    Creating sort index	0.05 ms
    end	0.01 ms
    query end	0.00 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.00 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.00 ms
    storing result in query cache	0.08 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:178
    19	UniteDBRev->fetchSql()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213
    18	UniteDBRev->fetch()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_slider.class.php:1579
    17	RevSlider->getSlidesFromGallery()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_slider.class.php:1472
    16	RevSlider->getSlides()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_slider.class.php:1658
    15	RevSlider->getSlidesForOutput()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:260
    14	RevSliderOutput->putSlides()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:2200
    13	RevSliderOutput->putSliderBase()	JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:82
    12	include JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:191
    11	JModuleHelper::renderModule()	JROOT/libraries/joomla/cache/controller/callback.php:169
    10	JCacheControllerCallback->get()	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:620
    9	JModuleHelper::moduleCache()	JROOT/libraries/joomla/document/renderer/html/module.php:90
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:474
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1119
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:278
    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: 9.79 ms Dopo l'ultima query: 3.11 ms Memoria query: 0.028 MB memoria prima della query: 10.684 MB Righe restituite: 6
    Query duplicate: #16  #17  #18

    select * 
      from ecw3r_revslider_layer_animations

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ecw3r_revslider_layer_animations	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	6	100.00	NULL

    Profilo

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.01 ms
    init	0.01 ms
    checking query cache for query	0.02 ms
    checking permissions	0.01 ms
    Opening tables	9.10 ms
    init	0.02 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.02 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.05 ms
    end	0.01 ms
    query end	0.00 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.08 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:178
    18	UniteDBRev->fetchSql()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213
    17	UniteDBRev->fetch()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_operations.class.php:533
    16	RevOperations::getCustomAnimations()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:710
    15	RevSliderOutput->putCreativeLayer()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:678
    14	RevSliderOutput->putSlides()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:2200
    13	RevSliderOutput->putSliderBase()	JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:82
    12	include JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:191
    11	JModuleHelper::renderModule()	JROOT/libraries/joomla/cache/controller/callback.php:169
    10	JCacheControllerCallback->get()	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:620
    9	JModuleHelper::moduleCache()	JROOT/libraries/joomla/document/renderer/html/module.php:90
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:474
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1119
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:278
    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.45 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.028 MB memoria prima della query: 10.695 MB Righe restituite: 6
    Query duplicate: #15  #17  #18

    select * 
      from ecw3r_revslider_layer_animations

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ecw3r_revslider_layer_animations	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	6	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
    init	0.02 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.04 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:178
    18	UniteDBRev->fetchSql()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213
    17	UniteDBRev->fetch()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_operations.class.php:533
    16	RevOperations::getCustomAnimations()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:711
    15	RevSliderOutput->putCreativeLayer()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:678
    14	RevSliderOutput->putSlides()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:2200
    13	RevSliderOutput->putSliderBase()	JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:82
    12	include JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:191
    11	JModuleHelper::renderModule()	JROOT/libraries/joomla/cache/controller/callback.php:169
    10	JCacheControllerCallback->get()	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:620
    9	JModuleHelper::moduleCache()	JROOT/libraries/joomla/document/renderer/html/module.php:90
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:474
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1119
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:278
    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: 0.41 ms Dopo l'ultima query: 0.19 ms Memoria query: 0.028 MB memoria prima della query: 10.705 MB Righe restituite: 6
    Query duplicate: #15  #16  #18

    select * 
      from ecw3r_revslider_layer_animations

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ecw3r_revslider_layer_animations	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	6	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
    init	0.00 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
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:178
    18	UniteDBRev->fetchSql()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213
    17	UniteDBRev->fetch()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_operations.class.php:533
    16	RevOperations::getCustomAnimations()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:710
    15	RevSliderOutput->putCreativeLayer()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:678
    14	RevSliderOutput->putSlides()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:2200
    13	RevSliderOutput->putSliderBase()	JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:82
    12	include JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:191
    11	JModuleHelper::renderModule()	JROOT/libraries/joomla/cache/controller/callback.php:169
    10	JCacheControllerCallback->get()	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:620
    9	JModuleHelper::moduleCache()	JROOT/libraries/joomla/document/renderer/html/module.php:90
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:474
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1119
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:278
    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.41 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.028 MB memoria prima della query: 10.715 MB Righe restituite: 6
    Query duplicate: #15  #16  #17

    select * 
      from ecw3r_revslider_layer_animations

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ecw3r_revslider_layer_animations	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	6	100.00	NULL

    Profilo

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

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:178
    18	UniteDBRev->fetchSql()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213
    17	UniteDBRev->fetch()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_operations.class.php:533
    16	RevOperations::getCustomAnimations()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:711
    15	RevSliderOutput->putCreativeLayer()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:678
    14	RevSliderOutput->putSlides()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:2200
    13	RevSliderOutput->putSliderBase()	JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:82
    12	include JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:191
    11	JModuleHelper::renderModule()	JROOT/libraries/joomla/cache/controller/callback.php:169
    10	JCacheControllerCallback->get()	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:620
    9	JModuleHelper::moduleCache()	JROOT/libraries/joomla/document/renderer/html/module.php:90
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:474
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1119
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:278
    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 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

1. 4 × select * 
     from ecw3r_revslider_layer_animation

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

3. 1 × SELECT `session_id` 
     FROM `ecw3r_session`

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

5. 1 × SELECT id, rules 
     FROM `ecw3r_viewlevels

6. 1 × SELECT * 
     FROM `ecw3r_jcomments_settings`

7. 1 × SELECT `id`,`name`,`rules`,`parent_id` 
     FROM `ecw3r_assets`

8. 1 × SELECT COUNT(*) 
     FROM ecw3r_content AS a 
     LEFT JOIN ecw3r_categories AS c 
     ON c.id = a.catid 
     LEFT JOIN ecw3r_users AS ua 
     ON ua.id = a.created_by 
     LEFT JOIN ecw3r_users AS uam 
     ON uam.id = a.modified_by 
     LEFT JOIN ecw3r_categories as parent 
     ON parent.id = c.parent_id

9. 1 × SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
     FROM ecw3r_modules AS m 
     LEFT JOIN ecw3r_modules_menu AS mm 
     ON mm.moduleid = m.id 
     LEFT JOIN ecw3r_extensions AS e 
     ON e.element = m.module 
     AND e.client_id = m.client_id

10. 1 × SELECT ct.*,cat.title as category_title,cat.id as catid, cat.alias as category_alias,us.id,us.name as author,tz_xc.type as type_media,tz_xc.* 
      FROM ecw3r_content as ct 
      LEFT JOIN ecw3r_categories as cat 
      on cat.id = ct.catid 
      LEFT JOIN ecw3r_users as us 
      on us.id = ct.created_by 
      LEFT JOIN ecw3r_tz_portfolio_xref_content as tz_xc 
      on tz_xc.contentid = ct.id

11. 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 ecw3r_categories as c 
      LEFT JOIN ecw3r_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)

12. 1 × select * 
      from ecw3r_revslider_sliders

13. 1 × select * 
      from ecw3r_revslider_slides

ALTRE tabelle:

1. 1 × INSERT INTO `ecw3r_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES  ('b4q74gmtj8b47bh5bb9iqhnmod', 1, '1728352688', 0, '', 0

2. 1 × UPDATE `ecw3r_extensions` 
     SET `params` = '{\"mediaversion\":\"6706c0be6454b81be3bf07e0d1ed3ea2\"}'