Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1726164888,
                "last": 1726164888,
                "now": 1726164888
            },
            "token": "FWlrlk0H23RDi8bA98b4qa0rgg5TBKGT"
        },
        "registry": {
            "com_solidres": {
                "reservation": {
                    "process": {
                        "current_selected_tariffs": null
                    }
                }
            }
        },
        "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

45 query eseguite 42.49 ms

Trovati 2 duplicati!

2 duplicati: #23 #42

Tempo della query: 1.15 ms Memoria query: 0.023 MB memoria prima della query: 0.861 MB Righe restituite: 0

SELECT `data`

  FROM `t6ml7_session`

  WHERE `session_id` = 'ba3ba5ade4b4d127c8b087075d24c38b'

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.13 ms
checking permissions	0.01 ms
Opening tables	0.53 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.05 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 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.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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.40 ms Dopo l'ultima query: 1.75 ms Memoria query: 0.019 MB memoria prima della query: 0.876 MB Righe restituite: 0

SELECT `session_id`

  FROM `t6ml7_session`

  WHERE `session_id` = 'ba3ba5ade4b4d127c8b087075d24c38b' 
  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.09 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.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.06 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: 1.08 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.003 MB memoria prima della query: 0.881 MB

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

Explain

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

Profilo

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.02 ms
Update	0.13 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.60 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.27 ms Dopo l'ultima query: 4.50 ms Memoria query: 0.023 MB memoria prima della query: 0.905 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.11 ms
checking permissions	0.01 ms
Opening tables	0.41 ms
After opening tables	0.01 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.05 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.07 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.23 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.06 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: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: 0.89 ms Dopo l'ultima query: 4.54 ms Memoria query: 0.021 MB memoria prima della query: 0.996 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.01 ms
Opening tables	0.36 ms
After opening tables	0.01 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.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.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
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: 0.96 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.021 MB memoria prima della query: 1.008 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.33 ms
After opening tables	0.01 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.08 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.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
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.93 ms Dopo l'ultima query: 1.43 ms Memoria query: 0.030 MB memoria prima della query: 1.030 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.10 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.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.43 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.06 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: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: 1.91 ms Dopo l'ultima query: 31.22 ms Memoria query: 0.028 MB memoria prima della query: 1.537 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.19 ms
checking permissions	0.01 ms
Opening tables	0.61 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.01 ms
closing tables	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.04 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.41 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
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.32 ms Dopo l'ultima query: 20.45 ms Memoria query: 0.024 MB memoria prima della query: 1.727 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.15 ms
checking permissions	0.01 ms
Opening tables	0.45 ms
After opening tables	0.01 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.03 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.05 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.08 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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.75 ms Dopo l'ultima query: 1.08 ms Memoria query: 0.026 MB memoria prima della query: 1.777 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.27 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.02 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.02 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.04 ms Dopo l'ultima query: 0.17 ms Memoria query: 0.009 MB memoria prima della query: 1.772 MB

UPDATE `t6ml7_extensions`

  SET `params` = '{\"mediaversion\":\"67f7bec3501086f7a2292039e25ada94\"}'

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

Explain

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

Profilo

Status	Duration
Starting	0.11 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.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.53 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
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.10 ms Dopo l'ultima query: 5.36 ms Memoria query: 0.019 MB memoria prima della query: 1.885 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.11 ms
checking permissions	0.01 ms
Opening tables	0.43 ms
After opening tables	0.01 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.04 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.07 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: 1.66 ms Dopo l'ultima query: 21.30 ms Memoria query: 0.034 MB memoria prima della query: 2.387 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.16 ms
checking permissions	0.01 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Opening tables	0.31 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.43 ms
After opening tables	0.03 ms
checking permissions	0.15 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Executing	0.01 ms
Sending data	0.08 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.12 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
17	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
16	JTable->__construct()	JROOT/administrator/components/com_solidres/tables/reservationasset.php:24
15	SolidresTableReservationAsset->__construct()	JROOT/libraries/joomla/table/table.php:311
14	JTable::getInstance()	JROOT/administrator/components/com_solidres/models/reservationasset.php:141
13	SolidresModelReservationAsset->getTable()	JROOT/libraries/legacy/model/admin.php:899
12	JModelAdmin->getItem()	JROOT/administrator/components/com_solidres/models/reservationasset.php:249
11	SolidresModelReservationAsset->getItem()	JROOT/components/com_solidres/views/reservationasset/view.html.php:36
10	SolidresViewReservationAsset->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_solidres/controller.php:312
8	SolidresController->display()	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: 0.76 ms Dopo l'ultima query: 1.00 ms Memoria query: 0.024 MB memoria prima della query: 2.449 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.10 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
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.09 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
init	0.04 ms
Optimizing	0.01 ms
Statistics	0.10 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
14	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
13	JTable->load()	JROOT/libraries/legacy/model/admin.php:904
12	JModelAdmin->getItem()	JROOT/administrator/components/com_solidres/models/reservationasset.php:249
11	SolidresModelReservationAsset->getItem()	JROOT/components/com_solidres/views/reservationasset/view.html.php:36
10	SolidresViewReservationAsset->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_solidres/controller.php:312
8	SolidresController->display()	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.18 ms Dopo l'ultima query: 10.60 ms Memoria query: 0.026 MB memoria prima della query: 2.574 MB Righe restituite: 11

SHOW FULL COLUMNS 
  FROM `t6ml7_sr_countries`

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
15	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
14	JTable->__construct()	JROOT/administrator/components/com_solidres/tables/country.php:24
13	SolidresTableCountry->__construct()	JROOT/libraries/joomla/table/table.php:311
12	JTable::getInstance()	JROOT/administrator/components/com_solidres/models/reservationasset.php:276
11	SolidresModelReservationAsset->getItem()	JROOT/components/com_solidres/views/reservationasset/view.html.php:36
10	SolidresViewReservationAsset->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_solidres/controller.php:312
8	SolidresController->display()	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: 0.59 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.022 MB memoria prima della query: 2.597 MB Righe restituite: 1

SELECT *

  FROM t6ml7_sr_countries

  WHERE `id` = '106'

Explain

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

Profilo

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.03 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.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.06 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.02 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.04 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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
12	JTable->load()	JROOT/administrator/components/com_solidres/models/reservationasset.php:277
11	SolidresModelReservationAsset->getItem()	JROOT/components/com_solidres/views/reservationasset/view.html.php:36
10	SolidresViewReservationAsset->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_solidres/controller.php:312
8	SolidresController->display()	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.03 ms Dopo l'ultima query: 0.46 ms Memoria query: 0.026 MB memoria prima della query: 2.607 MB Righe restituite: 6

SHOW FULL COLUMNS 
  FROM `t6ml7_sr_geo_states`

Explain

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

Profilo

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Opening tables	0.22 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.24 ms
After opening tables	0.01 ms
checking permissions	0.06 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.09 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
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
15	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
14	JTable->__construct()	JROOT/administrator/components/com_solidres/tables/state.php:24
13	SolidresTableState->__construct()	JROOT/libraries/joomla/table/table.php:311
12	JTable::getInstance()	JROOT/administrator/components/com_solidres/models/reservationasset.php:281
11	SolidresModelReservationAsset->getItem()	JROOT/components/com_solidres/views/reservationasset/view.html.php:36
10	SolidresViewReservationAsset->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_solidres/controller.php:312
8	SolidresController->display()	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: 0.52 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.022 MB memoria prima della query: 2.626 MB Righe restituite: 1

SELECT *

  FROM t6ml7_sr_geo_states

  WHERE `id` = '297'

Explain

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

Profilo

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.06 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	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.02 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
12	JTable->load()	JROOT/administrator/components/com_solidres/models/reservationasset.php:282
11	SolidresModelReservationAsset->getItem()	JROOT/components/com_solidres/views/reservationasset/view.html.php:36
10	SolidresViewReservationAsset->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_solidres/controller.php:312
8	SolidresController->display()	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.08 ms Dopo l'ultima query: 0.54 ms Memoria query: 0.025 MB memoria prima della query: 2.635 MB Righe restituite: 7

SHOW FULL COLUMNS 
  FROM `t6ml7_sr_currencies`

Explain

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

Profilo

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Opening tables	0.31 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.03 ms
Executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.18 ms
After opening tables	0.01 ms
checking permissions	0.05 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.09 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
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
15	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
14	JTable->__construct()	JROOT/administrator/components/com_solidres/tables/currency.php:24
13	SolidresTableCurrency->__construct()	JROOT/libraries/joomla/table/table.php:311
12	JTable::getInstance()	JROOT/administrator/components/com_solidres/models/reservationasset.php:286
11	SolidresModelReservationAsset->getItem()	JROOT/components/com_solidres/views/reservationasset/view.html.php:36
10	SolidresViewReservationAsset->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_solidres/controller.php:312
8	SolidresController->display()	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: 0.52 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.022 MB memoria prima della query: 2.654 MB Righe restituite: 1

SELECT *

  FROM t6ml7_sr_currencies

  WHERE `id` = '1'

Explain

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

Profilo

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.01 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.02 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.06 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.02 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.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
12	JTable->load()	JROOT/administrator/components/com_solidres/models/reservationasset.php:287
11	SolidresModelReservationAsset->getItem()	JROOT/components/com_solidres/views/reservationasset/view.html.php:36
10	SolidresViewReservationAsset->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_solidres/controller.php:312
8	SolidresController->display()	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: 2.16 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.024 MB memoria prima della query: 2.664 MB Righe restituite: 3

SELECT r.*, asset.name AS reservationasset,COUNT(room.id) as number_of_room,uc.name AS editor

  FROM `t6ml7_sr_room_types` AS r

  LEFT JOIN `t6ml7_users` AS uc 
  ON uc.id= r.checked_out

  LEFT JOIN `t6ml7_sr_rooms` AS room 
  ON room.room_type_id = r.id

  LEFT JOIN `t6ml7_sr_reservation_assets` AS asset 
  ON asset.id = r.reservation_asset_id

  WHERE r.state = 1 
  AND r.reservation_asset_id = 1

  GROUP BY asset.name,uc.name,r.id

  ORDER BY r.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	r	ALL	fk_sr_room_types_sr_reservation_assets1_idx	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	5	Using where; Using temporary; Using filesort
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	ffqcrsgd_sito.r.checked_out	1	Using where
1	SIMPLE	room	ref	fk_sr_rooms_sr_room_types1_idx	fk_sr_rooms_sr_room_types1_idx	4	ffqcrsgd_sito.r.id	3	Using index
1	SIMPLE	asset	const	PRIMARY	PRIMARY	4	const	1

Profilo

Status	Duration
Starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.76 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.06 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.04 ms
Creating tmp table	0.06 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.45 ms
Creating sort index	0.07 ms
Removing tmp table	0.10 ms
Creating sort index	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
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
13	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:186
12	JModelList->getItems()	JROOT/administrator/components/com_solidres/models/reservationasset.php:294
11	SolidresModelReservationAsset->getItem()	JROOT/components/com_solidres/views/reservationasset/view.html.php:36
10	SolidresViewReservationAsset->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_solidres/controller.php:312
8	SolidresController->display()	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.05 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.024 MB memoria prima della query: 2.684 MB Righe restituite: 7

SELECT a.*,x.weight as weight

  FROM `t6ml7_sr_media` AS a

  LEFT JOIN `t6ml7_sr_media_reservation_assets_xref`as x 
  ON a.id = x.media_id

  WHERE x.reservation_asset_id = '1'

  ORDER BY x.weight ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	x	ALL	PRIMARY,fk_sr_media_ref_reservation_assets_sr_media1_idx,fk_sr_media_ref_reservation_assets_sr_reservation1_idx	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	7	Using where; Using filesort
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	ffqcrsgd_sito.x.media_id	1

Profilo

Status	Duration
Starting	0.09 ms
checking permissions	0.03 ms
Opening tables	0.38 ms
After opening tables	0.01 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.06 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.09 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.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
13	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:186
12	JModelList->getItems()	JROOT/administrator/components/com_solidres/models/reservationasset.php:312
11	SolidresModelReservationAsset->getItem()	JROOT/components/com_solidres/views/reservationasset/view.html.php:36
10	SolidresViewReservationAsset->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_solidres/controller.php:312
8	SolidresController->display()	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: 0.65 ms Dopo l'ultima query: 9.28 ms Memoria query: 0.023 MB memoria prima della query: 2.702 MB Righe restituite: 1

Query duplicate: #42

SELECT *

  FROM `t6ml7_sr_currencies`

  WHERE `id` = 1

Explain

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

Profilo

Status	Duration
Starting	0.18 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 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.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
14	JDatabaseDriver->loadObject()	JROOT/libraries/solidres/currency/currency.php:235
13	SRCurrency->getCurrencyDetails()	JROOT/libraries/solidres/currency/currency.php:74
12	SRCurrency->__construct()	JROOT/administrator/components/com_solidres/models/reservationasset.php:367
11	SolidresModelReservationAsset->getItem()	JROOT/components/com_solidres/views/reservationasset/view.html.php:36
10	SolidresViewReservationAsset->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_solidres/controller.php:312
8	SolidresController->display()	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.02 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.024 MB memoria prima della query: 2.707 MB Righe restituite: 5

SELECT a.*,x.weight as weight

  FROM `t6ml7_sr_media` AS a

  LEFT JOIN `t6ml7_sr_media_roomtype_xref`as x 
  ON a.id = x.media_id

  WHERE x.room_type_id = '1'

  ORDER BY x.weight ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	x	ALL	fk_sr_media_ref_roomtype_sr_media1_idx,fk_sr_media_ref_roomtype_sr_room_types1_idx	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	12	Using where; Using filesort
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	ffqcrsgd_sito.x.media_id	1

Profilo

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.32 ms
After opening tables	0.01 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.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.09 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.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
13	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:186
12	JModelList->getItems()	JROOT/administrator/components/com_solidres/models/reservationasset.php:385
11	SolidresModelReservationAsset->getItem()	JROOT/components/com_solidres/views/reservationasset/view.html.php:36
10	SolidresViewReservationAsset->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_solidres/controller.php:312
8	SolidresController->display()	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.14 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.023 MB memoria prima della query: 2.725 MB Righe restituite: 1

SELECT t.*, cgroup.name as customer_group_name

  FROM `t6ml7_sr_tariffs` AS t

  LEFT JOIN `t6ml7_sr_customer_groups` as cgroup 
  ON cgroup.id = t.customer_group_id

  WHERE t.room_type_id = 1 
  AND t.customer_group_id IS NULL 
  AND t.state = 1 
  AND t.valid_from = '0000-00-00' 
  AND t.valid_to = '0000-00-00'

  ORDER BY title ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ref	fk_sr_prices_sr_room_types1_idx,fk_sr_prices_sr_customer_groups1_idx	fk_sr_prices_sr_room_types1_idx	5	const	3	Using where; Using filesort
1	SIMPLE	cgroup	eq_ref	PRIMARY	PRIMARY	4	ffqcrsgd_sito.t.customer_group_id	1	Using where

Profilo

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.41 ms
After opening tables	0.01 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.04 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.04 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.09 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.07 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
13	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:186
12	JModelList->getItems()	JROOT/administrator/components/com_solidres/models/reservationasset.php:398
11	SolidresModelReservationAsset->getItem()	JROOT/components/com_solidres/views/reservationasset/view.html.php:36
10	SolidresViewReservationAsset->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_solidres/controller.php:312
8	SolidresController->display()	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: 0.95 ms Dopo l'ultima query: 0.40 ms Memoria query: 0.028 MB memoria prima della query: 2.738 MB Righe restituite: 15

SHOW FULL COLUMNS 
  FROM `t6ml7_sr_tariffs`

Explain

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

Profilo

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Opening tables	0.28 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
checking permissions	0.08 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Executing	0.03 ms
Sending data	0.04 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.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
18	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
17	JTable->__construct()	JROOT/administrator/components/com_solidres/tables/tariff.php:24
16	SolidresTableTariff->__construct()	JROOT/libraries/joomla/table/table.php:311
15	JTable::getInstance()	JROOT/administrator/components/com_solidres/models/tariff.php:181
14	SolidresModelTariff->getTable()	JROOT/libraries/legacy/model/admin.php:899
13	JModelAdmin->getItem()	JROOT/administrator/components/com_solidres/models/tariff.php:323
12	SolidresModelTariff->getItem()	JROOT/administrator/components/com_solidres/models/reservationasset.php:402
11	SolidresModelReservationAsset->getItem()	JROOT/components/com_solidres/views/reservationasset/view.html.php:36
10	SolidresViewReservationAsset->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_solidres/controller.php:312
8	SolidresController->display()	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: 0.47 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.023 MB memoria prima della query: 2.765 MB Righe restituite: 1

SELECT *

  FROM t6ml7_sr_tariffs

  WHERE `id` = '1'

Explain

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

Profilo

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.04 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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
15	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
14	JTable->load()	JROOT/libraries/legacy/model/admin.php:904
13	JModelAdmin->getItem()	JROOT/administrator/components/com_solidres/models/tariff.php:323
12	SolidresModelTariff->getItem()	JROOT/administrator/components/com_solidres/models/reservationasset.php:402
11	SolidresModelReservationAsset->getItem()	JROOT/components/com_solidres/views/reservationasset/view.html.php:36
10	SolidresViewReservationAsset->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_solidres/controller.php:312
8	SolidresController->display()	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: 0.86 ms Dopo l'ultima query: 1.37 ms Memoria query: 0.024 MB memoria prima della query: 2.777 MB Righe restituite: 7

SELECT t.*

  FROM `t6ml7_sr_tariff_details` AS t

  WHERE t.tariff_id = 1

  ORDER BY w_day ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ref	fk_sr_tariff_details_sr_tariffs1_idx	fk_sr_tariff_details_sr_tariffs1_idx	4	const	7	Using where; Using filesort

Profilo

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.25 ms
After opening tables	0.01 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.01 ms
Statistics	0.06 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.07 ms
End of update loop	0.01 ms
Query end	0.03 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.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
14	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:186
13	JModelList->getItems()	JROOT/administrator/components/com_solidres/models/tariff.php:358
12	SolidresModelTariff->getItem()	JROOT/administrator/components/com_solidres/models/reservationasset.php:402
11	SolidresModelReservationAsset->getItem()	JROOT/components/com_solidres/views/reservationasset/view.html.php:36
10	SolidresViewReservationAsset->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_solidres/controller.php:312
8	SolidresController->display()	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: 0.82 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.023 MB memoria prima della query: 2.787 MB Righe restituite: 5

SELECT field_key, field_value

  FROM `t6ml7_sr_room_type_fields`

  WHERE room_type_id = 1 
  AND field_key LIKE 'roomtype_custom_fields.%'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t6ml7_sr_room_type_fields	range	PRIMARY,fk_sr_room_type_fields_sr_room_types1_idx	PRIMARY	106	NULL	5	Using where

Profilo

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.24 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.02 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.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.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1791
15	JDatabaseDriver->loadRowList()	JROOT/plugins/extension/solidres/solidres.php:702
14	plgExtensionSolidres->onRoomTypePrepareData()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/administrator/components/com_solidres/models/reservationasset.php:722
11	SolidresModelReservationAsset->getItem()	JROOT/components/com_solidres/views/reservationasset/view.html.php:36
10	SolidresViewReservationAsset->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_solidres/controller.php:312
8	SolidresController->display()	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: 0.51 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.023 MB memoria prima della query: 2.793 MB Righe restituite: 4

SELECT a.*,x.weight as weight

  FROM `t6ml7_sr_media` AS a

  LEFT JOIN `t6ml7_sr_media_roomtype_xref`as x 
  ON a.id = x.media_id

  WHERE x.room_type_id = '2'

  ORDER BY x.weight ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	x	ref	fk_sr_media_ref_roomtype_sr_media1_idx,fk_sr_media_ref_roomtype_sr_room_types1_idx	fk_sr_media_ref_roomtype_sr_room_types1_idx	4	const	4	Using where; Using filesort
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	ffqcrsgd_sito.x.media_id	1

Profilo

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

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
13	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:186
12	JModelList->getItems()	JROOT/administrator/components/com_solidres/models/reservationasset.php:385
11	SolidresModelReservationAsset->getItem()	JROOT/components/com_solidres/views/reservationasset/view.html.php:36
10	SolidresViewReservationAsset->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_solidres/controller.php:312
8	SolidresController->display()	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: 0.57 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.023 MB memoria prima della query: 2.805 MB Righe restituite: 1

SELECT t.*, cgroup.name as customer_group_name

  FROM `t6ml7_sr_tariffs` AS t

  LEFT JOIN `t6ml7_sr_customer_groups` as cgroup 
  ON cgroup.id = t.customer_group_id

  WHERE t.room_type_id = 2 
  AND t.customer_group_id IS NULL 
  AND t.state = 1 
  AND t.valid_from = '0000-00-00' 
  AND t.valid_to = '0000-00-00'

  ORDER BY title ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ref	fk_sr_prices_sr_room_types1_idx,fk_sr_prices_sr_customer_groups1_idx	fk_sr_prices_sr_room_types1_idx	5	const	3	Using where; Using filesort
1	SIMPLE	cgroup	eq_ref	PRIMARY	PRIMARY	4	ffqcrsgd_sito.t.customer_group_id	1	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
13	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:186
12	JModelList->getItems()	JROOT/administrator/components/com_solidres/models/reservationasset.php:398
11	SolidresModelReservationAsset->getItem()	JROOT/components/com_solidres/views/reservationasset/view.html.php:36
10	SolidresViewReservationAsset->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_solidres/controller.php:312
8	SolidresController->display()	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: 0.41 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.023 MB memoria prima della query: 2.818 MB Righe restituite: 1

SELECT *

  FROM t6ml7_sr_tariffs

  WHERE `id` = '2'

Explain

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

Profilo

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.02 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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
15	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
14	JTable->load()	JROOT/libraries/legacy/model/admin.php:904
13	JModelAdmin->getItem()	JROOT/administrator/components/com_solidres/models/tariff.php:323
12	SolidresModelTariff->getItem()	JROOT/administrator/components/com_solidres/models/reservationasset.php:402
11	SolidresModelReservationAsset->getItem()	JROOT/components/com_solidres/views/reservationasset/view.html.php:36
10	SolidresViewReservationAsset->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_solidres/controller.php:312
8	SolidresController->display()	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: 0.44 ms Dopo l'ultima query: 0.17 ms Memoria query: 0.025 MB memoria prima della query: 2.832 MB Righe restituite: 7

SELECT t.*

  FROM `t6ml7_sr_tariff_details` AS t

  WHERE t.tariff_id = 2

  ORDER BY w_day ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ref	fk_sr_tariff_details_sr_tariffs1_idx	fk_sr_tariff_details_sr_tariffs1_idx	4	const	7	Using where; Using filesort

Profilo

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

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
14	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:186
13	JModelList->getItems()	JROOT/administrator/components/com_solidres/models/tariff.php:358
12	SolidresModelTariff->getItem()	JROOT/administrator/components/com_solidres/models/reservationasset.php:402
11	SolidresModelReservationAsset->getItem()	JROOT/components/com_solidres/views/reservationasset/view.html.php:36
10	SolidresViewReservationAsset->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_solidres/controller.php:312
8	SolidresController->display()	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: 0.45 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.023 MB memoria prima della query: 2.843 MB Righe restituite: 5

SELECT field_key, field_value

  FROM `t6ml7_sr_room_type_fields`

  WHERE room_type_id = 2 
  AND field_key LIKE 'roomtype_custom_fields.%'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t6ml7_sr_room_type_fields	range	PRIMARY,fk_sr_room_type_fields_sr_room_types1_idx	PRIMARY	106	NULL	5	Using where

Profilo

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1791
15	JDatabaseDriver->loadRowList()	JROOT/plugins/extension/solidres/solidres.php:702
14	plgExtensionSolidres->onRoomTypePrepareData()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/administrator/components/com_solidres/models/reservationasset.php:722
11	SolidresModelReservationAsset->getItem()	JROOT/components/com_solidres/views/reservationasset/view.html.php:36
10	SolidresViewReservationAsset->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_solidres/controller.php:312
8	SolidresController->display()	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: 0.49 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.023 MB memoria prima della query: 2.849 MB Righe restituite: 3

SELECT a.*,x.weight as weight

  FROM `t6ml7_sr_media` AS a

  LEFT JOIN `t6ml7_sr_media_roomtype_xref`as x 
  ON a.id = x.media_id

  WHERE x.room_type_id = '5'

  ORDER BY x.weight ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	x	ref	fk_sr_media_ref_roomtype_sr_media1_idx,fk_sr_media_ref_roomtype_sr_room_types1_idx	fk_sr_media_ref_roomtype_sr_room_types1_idx	4	const	3	Using where; Using filesort
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	ffqcrsgd_sito.x.media_id	1

Profilo

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

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
13	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:186
12	JModelList->getItems()	JROOT/administrator/components/com_solidres/models/reservationasset.php:385
11	SolidresModelReservationAsset->getItem()	JROOT/components/com_solidres/views/reservationasset/view.html.php:36
10	SolidresViewReservationAsset->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_solidres/controller.php:312
8	SolidresController->display()	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: 0.56 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.023 MB memoria prima della query: 2.860 MB Righe restituite: 1

SELECT t.*, cgroup.name as customer_group_name

  FROM `t6ml7_sr_tariffs` AS t

  LEFT JOIN `t6ml7_sr_customer_groups` as cgroup 
  ON cgroup.id = t.customer_group_id

  WHERE t.room_type_id = 5 
  AND t.customer_group_id IS NULL 
  AND t.state = 1 
  AND t.valid_from = '0000-00-00' 
  AND t.valid_to = '0000-00-00'

  ORDER BY title ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ref	fk_sr_prices_sr_room_types1_idx,fk_sr_prices_sr_customer_groups1_idx	fk_sr_prices_sr_room_types1_idx	5	const	3	Using where; Using filesort
1	SIMPLE	cgroup	eq_ref	PRIMARY	PRIMARY	4	ffqcrsgd_sito.t.customer_group_id	1	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
13	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:186
12	JModelList->getItems()	JROOT/administrator/components/com_solidres/models/reservationasset.php:398
11	SolidresModelReservationAsset->getItem()	JROOT/components/com_solidres/views/reservationasset/view.html.php:36
10	SolidresViewReservationAsset->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_solidres/controller.php:312
8	SolidresController->display()	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: 0.40 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.023 MB memoria prima della query: 2.873 MB Righe restituite: 1

SELECT *

  FROM t6ml7_sr_tariffs

  WHERE `id` = '15'

Explain

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

Profilo

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.02 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.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
15	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
14	JTable->load()	JROOT/libraries/legacy/model/admin.php:904
13	JModelAdmin->getItem()	JROOT/administrator/components/com_solidres/models/tariff.php:323
12	SolidresModelTariff->getItem()	JROOT/administrator/components/com_solidres/models/reservationasset.php:402
11	SolidresModelReservationAsset->getItem()	JROOT/components/com_solidres/views/reservationasset/view.html.php:36
10	SolidresViewReservationAsset->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_solidres/controller.php:312
8	SolidresController->display()	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: 0.47 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.024 MB memoria prima della query: 2.881 MB Righe restituite: 7

SELECT t.*

  FROM `t6ml7_sr_tariff_details` AS t

  WHERE t.tariff_id = 15

  ORDER BY w_day ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ref	fk_sr_tariff_details_sr_tariffs1_idx	fk_sr_tariff_details_sr_tariffs1_idx	4	const	7	Using where; Using filesort

Profilo

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

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
14	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:186
13	JModelList->getItems()	JROOT/administrator/components/com_solidres/models/tariff.php:358
12	SolidresModelTariff->getItem()	JROOT/administrator/components/com_solidres/models/reservationasset.php:402
11	SolidresModelReservationAsset->getItem()	JROOT/components/com_solidres/views/reservationasset/view.html.php:36
10	SolidresViewReservationAsset->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_solidres/controller.php:312
8	SolidresController->display()	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: 0.43 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.023 MB memoria prima della query: 2.891 MB Righe restituite: 5

SELECT field_key, field_value

  FROM `t6ml7_sr_room_type_fields`

  WHERE room_type_id = 5 
  AND field_key LIKE 'roomtype_custom_fields.%'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t6ml7_sr_room_type_fields	range	PRIMARY,fk_sr_room_type_fields_sr_room_types1_idx	PRIMARY	106	NULL	5	Using where

Profilo

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1791
15	JDatabaseDriver->loadRowList()	JROOT/plugins/extension/solidres/solidres.php:702
14	plgExtensionSolidres->onRoomTypePrepareData()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/administrator/components/com_solidres/models/reservationasset.php:722
11	SolidresModelReservationAsset->getItem()	JROOT/components/com_solidres/views/reservationasset/view.html.php:36
10	SolidresViewReservationAsset->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_solidres/controller.php:312
8	SolidresController->display()	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: 0.81 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.025 MB memoria prima della query: 2.901 MB Righe restituite: 33

SELECT field_key, field_value

  FROM `t6ml7_sr_reservation_asset_fields`

  WHERE reservation_asset_id = 1 
  AND field_key LIKE 'reservationasset_extra_fields.%'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t6ml7_sr_reservation_asset_fields	ref	PRIMARY,fk_sr_reservation_asset_fields_sr_reservation_assets1_idx	fk_sr_reservation_asset_fields_sr_reservation_assets1_idx	4	const	33	Using index condition

Profilo

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.21 ms
After opening tables	0.01 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.02 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.07 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.09 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.06 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1791
15	JDatabaseDriver->loadRowList()	JROOT/plugins/extension/solidres/solidres.php:584
14	plgExtensionSolidres->onReservationAssetPrepareData()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/administrator/components/com_solidres/models/reservationasset.php:749
11	SolidresModelReservationAsset->getItem()	JROOT/components/com_solidres/views/reservationasset/view.html.php:36
10	SolidresViewReservationAsset->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_solidres/controller.php:312
8	SolidresController->display()	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: 0.94 ms Dopo l'ultima query: 0.54 ms Memoria query: 0.025 MB memoria prima della query: 2.937 MB Righe restituite: 8

SELECT data_key, data_value

  FROM `t6ml7_sr_config_data`

  WHERE scope_id = 1

Explain

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

Profilo

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.28 ms
After opening tables	0.01 ms
System lock	0.03 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.02 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1791
17	JDatabaseDriver->loadRowList()	JROOT/libraries/solidres/config/config.php:148
16	SRConfig->loadFromDb()	JROOT/libraries/solidres/config/config.php:58
15	SRConfig->__construct()	JROOT/plugins/extension/solidres/solidres.php:602
14	plgExtensionSolidres->onReservationAssetPrepareData()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/administrator/components/com_solidres/models/reservationasset.php:749
11	SolidresModelReservationAsset->getItem()	JROOT/components/com_solidres/views/reservationasset/view.html.php:36
10	SolidresViewReservationAsset->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_solidres/controller.php:312
8	SolidresController->display()	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: 0.44 ms Dopo l'ultima query: 0.17 ms Memoria query: 0.022 MB memoria prima della query: 2.898 MB Righe restituite: 1

Query duplicate: #23

SELECT *

  FROM `t6ml7_sr_currencies`

  WHERE `id` = 1

Explain

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

Profilo

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.02 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.02 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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
13	JDatabaseDriver->loadObject()	JROOT/libraries/solidres/currency/currency.php:235
12	SRCurrency->getCurrencyDetails()	JROOT/libraries/solidres/currency/currency.php:74
11	SRCurrency->__construct()	JROOT/components/com_solidres/views/reservationasset/view.html.php:61
10	SolidresViewReservationAsset->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_solidres/controller.php:312
8	SolidresController->display()	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.74 ms Dopo l'ultima query: 55.09 ms Memoria query: 0.025 MB memoria prima della query: 3.222 MB Righe restituite: 5

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM t6ml7_modules AS m

  LEFT JOIN t6ml7_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN t6ml7_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-09-12 18:14:48') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-09-12 18:14:48') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 560 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	PRIMARY,published,newsfeeds	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	29	Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	ffqcrsgd_sito.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	ffqcrsgd_sito.m.module,const	1	Using index condition; Using where

Profilo

Status	Duration
Starting	0.20 ms
checking permissions	0.01 ms
Opening tables	0.63 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Opening tables	0.05 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.05 ms
init	0.04 ms
Optimizing	0.05 ms
Statistics	0.08 ms
Preparing	0.05 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.19 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
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:169
15	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:424
14	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:360
13	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
12	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:576
11	JDocumentHtml->countModules()	JROOT/plugins/system/helix3/core/helix3.php:508
10	Helix3::countModules()	JROOT/plugins/system/helix3/core/helix3.php:455
9	Helix3::rowColumns()	JROOT/plugins/system/helix3/core/helix3.php:264
8	Helix3::generatelayout()	JROOT/templates/shaper_resort/index.php:157
7	require JROOT/templates/shaper_resort/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:1102
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]

Tempo della query: 3.01 ms Dopo l'ultima query: 32.50 ms Memoria query: 0.026 MB memoria prima della query: 3.342 MB Righe restituite: 0

SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state

  FROM t6ml7_fields AS a

  LEFT JOIN `t6ml7_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN t6ml7_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN t6ml7_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN t6ml7_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN t6ml7_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'mod_custom.content' 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

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

Profilo

Status	Duration
Starting	0.31 ms
checking permissions	0.02 ms
Opening tables	1.41 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.12 ms
System lock	0.01 ms
table lock	0.13 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
init	0.08 ms
Optimizing	0.06 ms
Statistics	0.18 ms
Preparing	0.09 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.10 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File e numero di linea
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
20	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:326
19	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
18	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
17	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
16	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
14	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
13	JHtmlContent::prepare()	JROOT/libraries/cms/html/html.php:233
12	JHtml::call()	JROOT/libraries/cms/html/html.php:140
11	JHtml::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/cms/module/helper.php:198
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:486
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:1116
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]

Tempo della query: 1.57 ms Dopo l'ultima query: 21.33 ms Memoria query: 0.026 MB memoria prima della query: 3.800 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.18 ms
checking permissions	0.02 ms
Opening tables	0.59 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.02 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.17 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.03 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
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]

33 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

3 × SELECT t.* 
  FROM `t6ml7_sr_tariff_details` AS t

3 × SELECT field_key, field_value 
  FROM `t6ml7_sr_room_type_fields`

```
3 × SELECT * 
  FROM t6ml7_sr_tariffs
```

3 × SELECT t.*, cgroup.name as customer_group_name 
  FROM `t6ml7_sr_tariffs` AS t 
  LEFT JOIN `t6ml7_sr_customer_groups` as cgroup 
  ON cgroup.id = t.customer_group_id

3 × SELECT a.*,x.weight as weight 
  FROM `t6ml7_sr_media` AS a 
  LEFT JOIN `t6ml7_sr_media_roomtype_xref`as x 
  ON a.id = x.media_id

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

2 × SELECT * 
  FROM `t6ml7_sr_currencies`

1 × SELECT `data` 
  FROM `t6ml7_session`

1 × SELECT a.*,x.weight as weight 
  FROM `t6ml7_sr_media` AS a 
  LEFT JOIN `t6ml7_sr_media_reservation_assets_xref`as x 
  ON a.id = x.media_id

1 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state 
  FROM t6ml7_fields AS a 
  LEFT JOIN `t6ml7_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN t6ml7_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN t6ml7_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN t6ml7_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN t6ml7_fields_groups AS g 
  ON g.id = a.group_id

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM t6ml7_modules AS m 
  LEFT JOIN t6ml7_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN t6ml7_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT data_key, data_value 
  FROM `t6ml7_sr_config_data`

1 × SELECT field_key, field_value 
  FROM `t6ml7_sr_reservation_asset_fields`

1 × SELECT r.*, asset.name AS reservationasset,COUNT(room.id) as number_of_room,uc.name AS editor 
  FROM `t6ml7_sr_room_types` AS r 
  LEFT JOIN `t6ml7_users` AS uc 
  ON uc.id= r.checked_out 
  LEFT JOIN `t6ml7_sr_rooms` AS room 
  ON room.room_type_id = r.id 
  LEFT JOIN `t6ml7_sr_reservation_assets` AS asset 
  ON asset.id = r.reservation_asset_id

1 × SELECT `session_id` 
  FROM `t6ml7_session`

1 × SELECT * 
  FROM t6ml7_sr_currencies

1 × SELECT * 
  FROM t6ml7_sr_geo_states

1 × SELECT * 
  FROM t6ml7_sr_countries

1 × SELECT * 
  FROM t6ml7_sr_reservation_assets

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

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 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 `folder` AS `type`,`element` AS `name`,`params` 
  FROM t6ml7_extensions

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 id, rules 
  FROM `t6ml7_viewlevels

1 × SELECT * 
  FROM t6ml7_acymailing_confi

ALTRE tabelle:

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

1 × UPDATE `t6ml7_extensions` 
  SET `params` = '{\"mediaversion\":\"67f7bec3501086f7a2292039e25ada94\"}'

1 × SHOW FULL COLUMNS 
  FROM `t6ml7_sr_reservation_assets

1 × SHOW FULL COLUMNS 
  FROM `t6ml7_sr_countries

1 × SHOW FULL COLUMNS 
  FROM `t6ml7_sr_geo_states

1 × SHOW FULL COLUMNS 
  FROM `t6ml7_sr_currencies

1 × SHOW FULL COLUMNS 
  FROM `t6ml7_sr_tariffs

Camere

La Maison delle Terme Hotel

5 Camera Tortora Featured

5 Camera Blu

5 Camera Rosa

Facilities

Policies

Search

Console Debug Joomla!

Sessione

Informazioni profilo

Tempo

Memoria

Utilizzo memoria

Query Database

45 query eseguite 42.49 ms

Trovati 2 duplicati!

33 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

ALTRE tabelle: