Console Debug Joomla!

Sessione

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

Informazioni profilo

Utilizzo memoria

Query Database

15 query eseguite 19.64 ms

Tempo della query: 1.49 ms Memoria query: 0.023 MB memoria prima della query: 0.862 MB Righe restituite: 0

SELECT `data`

  FROM `t6ml7_session`

  WHERE `session_id` = 'a1090958d31d2031a8ca2f6901513027'

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Chiamata uguale alla linea sottostante.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php: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:829
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:413
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]

Tempo della query: 0.51 ms Dopo l'ultima query: 2.22 ms Memoria query: 0.019 MB memoria prima della query: 0.878 MB Righe restituite: 0

SELECT `session_id`

  FROM `t6ml7_session`

  WHERE `session_id` = 'a1090958d31d2031a8ca2f6901513027' 
  LIMIT 1

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:831
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:413
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]

Tempo della query: 0.78 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.003 MB memoria prima della query: 0.882 MB

INSERT INTO `t6ml7_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('a1090958d31d2031a8ca2f6901513027', 1, '1764938986', 0, '', 0)

Explain

EXPLAIN non possibile sulla query: INSERT INTO `t6ml7_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('a1090958d31d2031a8ca2f6901513027', 1, '1764938986', 0, '', 0)

Profilo

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

Call Stack

#	Caller	File e numero di linea
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:216
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:831
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:413
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]

Tempo della query: 1.40 ms Dopo l'ultima query: 7.27 ms Memoria query: 0.023 MB memoria prima della query: 0.907 MB Righe restituite: 37

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `t6ml7_extensions`

  WHERE `type` = 'component'

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/component/helper.php:447
8	JComponentHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:455
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:111
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:593
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
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]

Tempo della query: 1.05 ms Dopo l'ultima query: 7.46 ms Memoria query: 0.021 MB memoria prima della query: 0.998 MB Righe restituite: 5

SELECT id, rules

  FROM `t6ml7_viewlevels`

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1061
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:309
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:265
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]

Tempo della query: 1.00 ms Dopo l'ultima query: 0.18 ms Memoria query: 0.021 MB memoria prima della query: 1.010 MB Righe restituite: 1

SELECT b.id

  FROM t6ml7_usergroups AS a

  LEFT JOIN t6ml7_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 1

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:978
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:1093
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:309
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:265
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]

Tempo della query: 0.97 ms Dopo l'ultima query: 2.08 ms Memoria query: 0.030 MB memoria prima della query: 1.031 MB Righe restituite: 88

SELECT `folder` AS `type`,`element` AS `name`,`params`

  FROM t6ml7_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1)

  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t6ml7_extensions	ALL	extension	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	212	Using where; Using filesort

Profilo

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

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:327
8	JPluginHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/plugin/helper.php:332
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:265
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]

Tempo della query: 2.00 ms Dopo l'ultima query: 33.58 ms Memoria query: 0.028 MB memoria prima della query: 1.539 MB Righe restituite: 12

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 t6ml7_menu AS m

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

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

  ORDER BY m.lft

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:88
16	JMenuSite->{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
15	JCacheControllerCallback->get()	JROOT/libraries/cms/menu/site.php:96
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:129
11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:444
10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:59
8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:198
7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:549
6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:402
5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1145
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:265
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]

Tempo della query: 1.69 ms Dopo l'ultima query: 18.53 ms Memoria query: 0.024 MB memoria prima della query: 1.729 MB Righe restituite: 4

SELECT id, home, template, s.params

  FROM t6ml7_template_styles as s

  LEFT JOIN t6ml7_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	Using index condition; Using where
1	SIMPLE	s	ALL	idx_template	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	6	Using where; Using join buffer (flat, BNL join)

Profilo

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

Call Stack

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:485
16	JApplicationSite->getTemplate()	JROOT/libraries/cms/html/html.php:359
15	JHtml::includeRelativeFiles()	JROOT/libraries/cms/html/html.php:706
14	JHtml::script()	JROOT/libraries/cms/html/html.php:233
13	JHtml::call()	JROOT/libraries/cms/html/html.php:140
12	JHtml::_()	JROOT/libraries/cms/html/jquery.php:52
11	JHtmlJquery::framework()	JROOT/libraries/cms/html/html.php:233
10	JHtml::call()	JROOT/libraries/cms/html/html.php:140
9	JHtml::_()	JROOT/plugins/system/solidres/solidres.php:32
8	plgSystemSolidres->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:1155
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:265
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]

Tempo della query: 0.71 ms Dopo l'ultima query: 1.04 ms Memoria query: 0.026 MB memoria prima della query: 1.779 MB Righe restituite: 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `t6ml7_extensions`

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

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
23	JDatabaseDriver->loadObject()	JROOT/libraries/cms/library/helper.php:166
22	JLibraryHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
21	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:174
20	JLibraryHelper::loadLibrary()	JROOT/libraries/cms/library/helper.php:42
19	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:89
18	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:270
17	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
16	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
15	JFactory::getDocument()	JROOT/libraries/cms/html/html.php:725
14	JHtml::script()	JROOT/libraries/cms/html/html.php:233
13	JHtml::call()	JROOT/libraries/cms/html/html.php:140
12	JHtml::_()	JROOT/libraries/cms/html/jquery.php:52
11	JHtmlJquery::framework()	JROOT/libraries/cms/html/html.php:233
10	JHtml::call()	JROOT/libraries/cms/html/html.php:140
9	JHtml::_()	JROOT/plugins/system/solidres/solidres.php:32
8	plgSystemSolidres->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:1155
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:265
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]

Tempo della query: 1.21 ms Dopo l'ultima query: 0.24 ms Memoria query: 0.009 MB memoria prima della query: 1.774 MB

UPDATE `t6ml7_extensions`

  SET `params` = '{\"mediaversion\":\"1429ad6345ef5e3ecff6db3d6eda8ad5\"}'

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

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
19	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
18	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
17	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
16	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
15	JFactory::getDocument()	JROOT/libraries/cms/html/html.php:725
14	JHtml::script()	JROOT/libraries/cms/html/html.php:233
13	JHtml::call()	JROOT/libraries/cms/html/html.php:140
12	JHtml::_()	JROOT/libraries/cms/html/jquery.php:52
11	JHtmlJquery::framework()	JROOT/libraries/cms/html/html.php:233
10	JHtml::call()	JROOT/libraries/cms/html/html.php:140
9	JHtml::_()	JROOT/plugins/system/solidres/solidres.php:32
8	plgSystemSolidres->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:1155
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:265
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]

Tempo della query: 1.43 ms Dopo l'ultima query: 6.53 ms Memoria query: 0.019 MB memoria prima della query: 1.887 MB Righe restituite: 1

SELECT *

  FROM t6ml7_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t6ml7_languages	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	Using where; Using filesort

Profilo

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

Call Stack

#	Caller	File e numero di linea
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:148
5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:327
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:265
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]

Tempo della query: 2.36 ms Dopo l'ultima query: 18.10 ms Memoria query: 0.033 MB memoria prima della query: 2.101 MB Righe restituite: 47

SHOW FULL COLUMNS 
  FROM `t6ml7_sr_reservation_assets`

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
15	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
14	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
13	JTable->__construct()	JROOT/administrator/components/com_solidres/tables/reservationasset.php:24
12	SolidresTableReservationAsset->__construct()	JROOT/libraries/joomla/table/table.php:311
11	JTable::getInstance()	JROOT/components/com_solidres/models/map.php:24
10	SolidresModelMap->getMapInfo()	JROOT/components/com_solidres/views/map/view.html.php:31
9	SolidresViewMap->display()	JROOT/components/com_solidres/controllers/map.php:58
8	SolidresControllerMap->show()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_solidres/solidres.php:18
6	require_once JROOT/components/com_solidres/solidres.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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:265
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]

Tempo della query: 1.39 ms Dopo l'ultima query: 1.61 ms Memoria query: 0.023 MB memoria prima della query: 2.162 MB Righe restituite: 1

SELECT *

  FROM t6ml7_sr_reservation_assets

  WHERE `id` = '1'

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
12	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
11	JTable->load()	JROOT/components/com_solidres/models/map.php:25
10	SolidresModelMap->getMapInfo()	JROOT/components/com_solidres/views/map/view.html.php:31
9	SolidresViewMap->display()	JROOT/components/com_solidres/controllers/map.php:58
8	SolidresControllerMap->show()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_solidres/solidres.php:18
6	require_once JROOT/components/com_solidres/solidres.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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:265
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]

Tempo della query: 1.64 ms Dopo l'ultima query: 33.80 ms Memoria query: 0.026 MB memoria prima della query: 2.565 MB Righe restituite: 81

SELECT * 
  FROM t6ml7_acymailing_config

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
10	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:392
9	acymailing_config()	JROOT/administrator/components/com_acymailing/helpers/helper.php:1369
8	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:140
7	plgSystemRegacymailing->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1122
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
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 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

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

1 × SELECT `data` 
  FROM `t6ml7_session`

1 × SELECT `session_id` 
  FROM `t6ml7_session`

1 × SELECT id, rules 
  FROM `t6ml7_viewlevels

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

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` 
  FROM t6ml7_extensions

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM t6ml7_menu AS m 
  LEFT JOIN t6ml7_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT id, home, template, s.params 
  FROM t6ml7_template_styles as s 
  LEFT JOIN t6ml7_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

```
1 × SELECT * 
  FROM t6ml7_languages
```

1 × SELECT * 
  FROM t6ml7_sr_reservation_assets

1 × SELECT * 
  FROM t6ml7_acymailing_confi

ALTRE tabelle:

1 × INSERT INTO `t6ml7_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('a1090958d31d2031a8ca2f6901513027', 1, '1764938986', 0, '', 0

1 × UPDATE `t6ml7_extensions` 
  SET `params` = '{\"mediaversion\":\"1429ad6345ef5e3ecff6db3d6eda8ad5\"}'

1 × SHOW FULL COLUMNS 
  FROM `t6ml7_sr_reservation_assets