Gràcies

Gràcies per haver utilitzat la nostra metodologia durant l'estat de confinament a conseqüència de l'COVID-19.

364 centres educatius i més de 10.000 alumnes de diferents països heu pogut gaudir, de forma gratuïta, durant 3 mesos i mig, de l'ús de la plataforma aulavirtualmusica.com

Si necessites més informació de com realitzar la implantació de la metodologia al teu centre, pots escriure a Aquesta adreça de correu-e està protegida dels robots de spam.Necessites Javascript habilitat per veure-la. i t'informarem de tot.

Consola de Depuració per Joomla!

Sessió

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

Informació de perfils

Hora

Memòria

Hora: 15.23 ms / 15.23 ms Memòria: 0.703 MB / 1.08 MB Application: afterLoad

Hora: 72.30 ms / 87.52 ms Memòria: 1.821 MB / 2.90 MB Application: Before Access::preloadComponents (all components)

Hora: 2.84 ms / 90.36 ms Memòria: 0.060 MB / 2.96 MB Application: After Access::preloadComponents (all components)

Hora: 0.01 ms / 90.38 ms Memòria: 0.000 MB / 2.96 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Hora: 0.46 ms / 90.84 ms Memòria: 0.009 MB / 2.97 MB Application: After Access::getAssetRules (id:1 name:root.1)

Hora: 38.37 ms / 129.21 ms Memòria: 1.303 MB / 4.27 MB Application: afterInitialise

Hora: 25.21 ms / 154.42 ms Memòria: 0.731 MB / 5.00 MB Application: afterRoute

Hora: 0.10 ms / 154.52 ms Memòria: 0.014 MB / 5.02 MB Application: beforeRenderComponent com_content

Hora: 2.23 ms / 156.74 ms Memòria: 0.108 MB / 5.13 MB Application: Before Access::preloadPermissions (com_content)

Hora: 0.69 ms / 157.43 ms Memòria: 0.093 MB / 5.22 MB Application: After Access::preloadPermissions (com_content)

Hora: 0.01 ms / 157.44 ms Memòria: 0.000 MB / 5.21 MB Application: Before Access::getAssetRules (id:353 name:com_content.article.208)

Hora: 0.03 ms / 157.47 ms Memòria: 0.007 MB / 5.22 MB Application: After Access::getAssetRules (id:353 name:com_content.article.208)

Hora: 37.34 ms / 194.81 ms Memòria: 0.439 MB / 5.66 MB Application: afterRenderComponent com_content

Hora: 9.23 ms / 204.04 ms Memòria: 0.152 MB / 5.81 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Hora: 0.03 ms / 204.07 ms Memòria: 0.007 MB / 5.82 MB Application: After Access::getAssetRules (id:8 name:com_content)

Hora: 2.65 ms / 206.72 ms Memòria: 0.001 MB / 5.82 MB Application: afterDispatch

Hora: 6.03 ms / 212.74 ms Memòria: 0.047 MB / 5.86 MB Application: beforeRenderModule mod_custom (Footer Social (ca))

Hora: 0.79 ms / 213.54 ms Memòria: 0.070 MB / 5.93 MB Application: afterRenderModule mod_custom (Footer Social (ca))

Hora: 0.03 ms / 213.66 ms Memòria: 0.000 MB / 5.94 MB Application: beforeRenderModule mod_menu (Footer Menu (ca))

Hora: 1.69 ms / 215.35 ms Memòria: 0.024 MB / 5.96 MB Application: afterRenderModule mod_menu (Footer Menu (ca))

Hora: 0.03 ms / 215.38 ms Memòria: 0.000 MB / 5.96 MB Application: beforeRenderModule mod_custom (Footer Info (ca))

Hora: 0.06 ms / 215.44 ms Memòria: 0.011 MB / 5.97 MB Application: afterRenderModule mod_custom (Footer Info (ca))

Hora: 2.18 ms / 217.62 ms Memòria: 0.055 MB / 6.02 MB Application: afterRender

Total de peticions a la base de dades: 54.27 ms

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	aulasession	const	PRIMARY	PRIMARY	194	const	1

#	Autor de la crida	Arxiu i nombre de línia
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Igual que la crida de la línia de sota.
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:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

#	Autor de la crida	Arxiu i nombre de línia
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

EXPLICACIÓ no possible a la petició: INSERT INTO `aulasession` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'756835716e64767135746e6c663864646969316373753865316d', 1, 1714660442, 0, '', 0)

Perfil

Status	Duration
Starting	0.12 ms
Checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.03 ms
Init for update	0.04 ms
Update	0.14 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	1.21 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.09 ms
Reset for next command	0.01 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Afegeix la directiva xdebug.file_link_format al teu php.ini per enllaçar els arxius]

Temps de petició: 1.86 ms Després de la darrera petició: 2.81 ms Petició de memòria: 0.040 MB Memòria abans de la petició: 1.608 MB Cel·les retornades: 42

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

  FROM `aulaextensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	aulaextensions	ref	extension	extension	82	const	45	Using index condition; Using where

Perfil

Status	Duration
Starting	0.13 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.05 ms
Optimizing	0.05 ms
Statistics	0.10 ms
Preparing	0.06 ms
Executing	0.01 ms
Sending data	0.89 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.12 ms
Reset for next command	0.01 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Igual que la crida de la línia de sota.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Afegeix la directiva xdebug.file_link_format al teu php.ini per enllaçar els arxius]

Temps de petició: 1.17 ms Després de la darrera petició: 2.36 ms Petició de memòria: 0.023 MB Memòria abans de la petició: 1.725 MB Cel·les retornades: 17

SELECT id, rules

  FROM `aulaviewlevels`

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	aulaviewlevels	ALL	NULL	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	17

Perfil

Status	Duration
Starting	0.09 ms
Checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.13 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.40 ms
Reset for next command	0.01 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Afegeix la directiva xdebug.file_link_format al teu php.ini per enllaçar els arxius]

Temps de petició: 0.91 ms Després de la darrera petició: 0.20 ms Petició de memòria: 0.022 MB Memòria abans de la petició: 1.904 MB Cel·les retornades: 2

SELECT b.id

  FROM aulausergroups AS a

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

  WHERE a.id = 9

Explicació

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	2	Using where; Using index

Perfil

Status	Duration
Starting	0.11 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.04 ms
Optimizing	0.03 ms
Statistics	0.11 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.07 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.07 ms
Reset for next command	0.01 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Afegeix la directiva xdebug.file_link_format al teu php.ini per enllaçar els arxius]

Temps de petició: 4.72 ms Després de la darrera petició: 0.95 ms Petició de memòria: 0.132 MB Memòria abans de la petició: 1.926 MB Cel·les retornades: 126

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

  FROM aulaextensions

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

  ORDER BY ordering

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	aulaextensions	ref	extension	extension	82	const	255	Using index condition; Using where; Utilitzant ordenació d`arxius

Perfil

Status	Duration
Starting	0.15 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.06 ms
Optimizing	0.06 ms
Statistics	0.10 ms
Preparing	0.09 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	3.50 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.29 ms
Reset for next command	0.02 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Igual que la crida de la línia de sota.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Afegeix la directiva xdebug.file_link_format al teu php.ini per enllaçar els arxius]

Temps de petició: 0.89 ms Després de la darrera petició: 22.22 ms Petició de memòria: 0.024 MB Memòria abans de la petició: 2.761 MB Cel·les retornades: 17

SELECT `id`,`title`

  FROM `aulaviewlevels`

  ORDER BY ordering ASC

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	aulaviewlevels	ALL	NULL	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	17	Utilitzant ordenació d`arxius

Perfil

Status	Duration
Starting	0.11 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.02 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.13 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.16 ms
Reset for next command	0.01 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
10	JDatabaseDriver->loadAssocList()	JROOT/libraries/chatbro/backends/admin.php:20
9	CBroJoomlaAdminBackend->__construct()	JROOT/libraries/chatbro/init.php:21
8	require_once JROOT/libraries/chatbro/init.php	JROOT/plugins/system/chatbro/chatbro.php:5
7	require_once JROOT/plugins/system/chatbro/chatbro.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Afegeix la directiva xdebug.file_link_format al teu php.ini per enllaçar els arxius]

Temps de petició: 1.99 ms Després de la darrera petició: 2.10 ms Petició de memòria: 0.033 MB Memòria abans de la petició: 2.791 MB Cel·les retornades: 18

SHOW FULL COLUMNS 
  FROM `aulaextensions`

Explicació

EXPLICACIÓ no possible a la petició: SHOW FULL COLUMNS FROM `aulaextensions`

Perfil

Status	Duration
Starting	0.08 ms
Checking permissions	0.03 ms
Closing tables	0.01 ms
Opening tables	0.67 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.03 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
Checking permissions	0.24 ms
Closing tables	0.02 ms
Executing	0.01 ms
Sending data	0.13 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.26 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.10 ms
Reset for next command	0.01 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
16	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Extension.php:32
15	Joomla\CMS\Table\Extension->__construct()	JROOT/libraries/src/Table/Table.php:312
14	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/chatbro/backends/settings.php:52
13	CBroJoomlaSettingsBackend->flush()	JROOT/libraries/chatbro/backends/settings.php:38
12	CBroJoomlaSettingsBackend->set()	JROOT/libraries/chatbro/common/settings/setting.php:34
11	CBroSetting->__construct()	JROOT/libraries/chatbro/common/settings/settings.php:99
10	CBroSettings->__construct()	JROOT/libraries/chatbro/common/core/backendable.php:17
9	CBroBackendable::init()	JROOT/libraries/chatbro/init.php:22
8	require_once JROOT/libraries/chatbro/init.php	JROOT/plugins/system/chatbro/chatbro.php:5
7	require_once JROOT/plugins/system/chatbro/chatbro.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Afegeix la directiva xdebug.file_link_format al teu php.ini per enllaçar els arxius]

Temps de petició: 0.82 ms Després de la darrera petició: 0.45 ms Petició de memòria: 0.030 MB Memòria abans de la petició: 2.899 MB Cel·les retornades: 1

SELECT *

  FROM aulaextensions

  WHERE `extension_id` = '10338'

Explicació

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

Perfil

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.07 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.01 ms
Unlocking tables	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.06 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.10 ms
Reset for next command	0.01 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
14	Joomla\CMS\Table\Table->load()	JROOT/libraries/chatbro/backends/settings.php:53
13	CBroJoomlaSettingsBackend->flush()	JROOT/libraries/chatbro/backends/settings.php:38
12	CBroJoomlaSettingsBackend->set()	JROOT/libraries/chatbro/common/settings/setting.php:34
11	CBroSetting->__construct()	JROOT/libraries/chatbro/common/settings/settings.php:99
10	CBroSettings->__construct()	JROOT/libraries/chatbro/common/core/backendable.php:17
9	CBroBackendable::init()	JROOT/libraries/chatbro/init.php:22
8	require_once JROOT/libraries/chatbro/init.php	JROOT/plugins/system/chatbro/chatbro.php:5
7	require_once JROOT/plugins/system/chatbro/chatbro.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Afegeix la directiva xdebug.file_link_format al teu php.ini per enllaçar els arxius]

Temps de petició: 0.75 ms Després de la darrera petició: 0.07 ms Petició de memòria: 0.008 MB Memòria abans de la petició: 2.909 MB

UPDATE `aulaextensions` 
  SET `package_id`='10339',`name`='COM_CHATBRO',`type`='component',`element`='com_chatbro',`folder`='',`client_id`='1',`enabled`='1',`access`='0',`protected`='0',`manifest_cache`='{\"name\":\"COM_CHATBRO\",\"type\":\"component\",\"creationDate\":\"Feb 2017\",\"author\":\"ChatBro Team\",\"copyright\":\"\",\"authorEmail\":\"\",\"authorUrl\":\"https:\\/\\/www.chatbro.com\",\"version\":\"3.0.1\",\"description\":\"COM_CHATBRO_DESCRIPTION\",\"
  group\":\"\",\"filename\":\"chatbro\"}',`params`='{\"chatbro_chat_guid\":\"20674f1a-ec49-4a12-b54e-5b41baa41dd2\",\"chatbro_chat_display\":\"disable\",\"chatbro_chat_selected_pages\":\"foro\",\"chatbro_chat_user_profile_url\":\"\",\"chatbro_view_access_level\":false}',`custom_data`='',`system_data`='',`checked_out`='0',`checked_out_time`='0000-00-00 00:00:00',`ordering`='0',`state`='0' 
  WHERE `extension_id` = '10338'

Explicació

EXPLICACIÓ no possible a la petició: UPDATE `aulaextensions` SET `package_id`='10339',`name`='COM_CHATBRO',`type`='component',`element`='com_chatbro',`folder`='',`client_id`='1',`enabled`='1',`access`='0',`protected`='0',`manifest_cache`='{\"name\":\"COM_CHATBRO\",\"type\":\"component\",\"creationDate\":\"Feb 2017\",\"author\":\"ChatBro Team\",\"copyright\":\"\",\"authorEmail\":\"\",\"authorUrl\":\"https:\\/\\/www.chatbro.com\",\"version\":\"3.0.1\",\"description\":\"COM_CHATBRO_DESCRIPTION\",\"group\":\"\",\"filename\":\"chatbro\"}',`params`='{\"chatbro_chat_guid\":\"20674f1a-ec49-4a12-b54e-5b41baa41dd2\",\"chatbro_chat_display\":\"disable\",\"chatbro_chat_selected_pages\":\"foro\",\"chatbro_chat_user_profile_url\":\"\",\"chatbro_view_access_level\":false}',`custom_data`='',`system_data`='',`checked_out`='0',`checked_out_time`='0000-00-00 00:00:00',`ordering`='0',`state`='0' WHERE `extension_id` = '10338'

Perfil

Status	Duration
Starting	0.16 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 for update	0.11 ms
Updating	0.07 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.04 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.14 ms
Reset for next command	0.01 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:2304
15	JDatabaseDriver->updateObject()	JROOT/libraries/src/Table/Table.php:801
14	Joomla\CMS\Table\Table->store()	JROOT/libraries/chatbro/backends/settings.php:61
13	CBroJoomlaSettingsBackend->flush()	JROOT/libraries/chatbro/backends/settings.php:38
12	CBroJoomlaSettingsBackend->set()	JROOT/libraries/chatbro/common/settings/setting.php:34
11	CBroSetting->__construct()	JROOT/libraries/chatbro/common/settings/settings.php:99
10	CBroSettings->__construct()	JROOT/libraries/chatbro/common/core/backendable.php:17
9	CBroBackendable::init()	JROOT/libraries/chatbro/init.php:22
8	require_once JROOT/libraries/chatbro/init.php	JROOT/plugins/system/chatbro/chatbro.php:5
7	require_once JROOT/plugins/system/chatbro/chatbro.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Afegeix la directiva xdebug.file_link_format al teu php.ini per enllaçar els arxius]

Temps de petició: 2.75 ms Després de la darrera petició: 0.09 ms Petició de memòria: 0.031 MB Memòria abans de la petició: 2.908 MB Cel·les retornades: 42

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `aulaassets`

  WHERE `name` IN ('root.1','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_chatbro','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_frontendusermanager','com_hikashop','com_installer','com_jaextmanager','com_jalang','com_jce','com_joomlaupdate','com_k2','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_quicklogout','com_redirect','com_redj','com_search','com_tags','com_templates','com_users','com_wrapper')

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	aulaassets	ALL	idx_asset_name	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	283	Using where

Perfil

Status	Duration
Starting	0.15 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.15 ms
Optimizing	0.03 ms
Statistics	0.35 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	1.48 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.19 ms
Reset for next command	0.01 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/libraries/chatbro/backends/user.php:19
11	CBroJoomlaUserBackend->is_admin()	JROOT/libraries/chatbro/common/user/user.php:13
10	CBroUser::is_admin()	JROOT/libraries/chatbro/common/core/l10n/l10n.php:62
9	CBroL10N::load_plugin_textdomain()	JROOT/libraries/chatbro/init.php:26
8	require_once JROOT/libraries/chatbro/init.php	JROOT/plugins/system/chatbro/chatbro.php:5
7	require_once JROOT/plugins/system/chatbro/chatbro.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Afegeix la directiva xdebug.file_link_format al teu php.ini per enllaçar els arxius]

Temps de petició: 1.02 ms Després de la darrera petició: 8.44 ms Petició de memòria: 0.027 MB Memòria abans de la petició: 3.090 MB Cel·les retornades: 4

SELECT *

  FROM aulalanguages

  WHERE published=1

  ORDER BY ordering ASC

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	aulalanguages	ALL	NULL	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	4	Using where; Utilitzant ordenació d`arxius

Perfil

Status	Duration
Starting	0.11 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.07 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.14 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.13 ms
Reset for next command	0.01 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
8	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:96
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Afegeix la directiva xdebug.file_link_format al teu php.ini per enllaçar els arxius]

Temps de petició: 1.15 ms Després de la darrera petició: 0.06 ms Petició de memòria: 0.024 MB Memòria abans de la petició: 3.103 MB Cel·les retornades: 8

SELECT `element`,`name`,`client_id`,`extension_id`

  FROM `aulaextensions`

  WHERE `type` = 'language' 
  AND `state` = 0 
  AND `enabled` = 1

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	aulaextensions	ref	extension	extension	82	const	8	Using index condition; Using where

Perfil

Status	Duration
Starting	0.12 ms
Checking permissions	0.04 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.04 ms
Statistics	0.09 ms
Preparing	0.06 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
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.07 ms
Updating status	0.09 ms
Reset for next command	0.01 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:209
8	Joomla\CMS\Language\LanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:110
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Afegeix la directiva xdebug.file_link_format al teu php.ini per enllaçar els arxius]

Temps de petició: 1.12 ms Després de la darrera petició: 8.72 ms Petició de memòria: 0.027 MB Memòria abans de la petició: 3.242 MB Cel·les retornades: 1

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

  FROM `aulaextensions`

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

Explicació

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

Perfil

Status	Duration
Starting	0.14 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.02 ms
Init	0.07 ms
Optimizing	0.03 ms
Statistics	0.14 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.11 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.09 ms
Reset for next command	0.01 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Igual que la crida de la línia de sota.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:47
8	plgSystemK2->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Afegeix la directiva xdebug.file_link_format al teu php.ini per enllaçar els arxius]

Temps de petició: 2.19 ms Després de la darrera petició: 0.08 ms Petició de memòria: 0.006 MB Memòria abans de la petició: 3.235 MB

UPDATE `aulaextensions`

  SET `params` = '{\"mediaversion\":\"af356572a029bf895ab4a248ca8bb2e1\"}'

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

Explicació

EXPLICACIÓ no possible a la petició: UPDATE `aulaextensions` SET `params` = '{\"mediaversion\":\"af356572a029bf895ab4a248ca8bb2e1\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Perfil

Status	Duration
Starting	0.16 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 for update	0.16 ms
Updating	0.17 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	1.18 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.09 ms
Reset for next command	0.01 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:47
8	plgSystemK2->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Afegeix la directiva xdebug.file_link_format al teu php.ini per enllaçar els arxius]

Temps de petició: 6.30 ms Després de la darrera petició: 5.80 ms Petició de memòria: 0.256 MB Memòria abans de la petició: 3.446 MB Cel·les retornades: 219

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

  LEFT JOIN aulaextensions 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

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_client_id_parent_id_alias_language	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	367	Using where; Utilitzant ordenació d`arxius
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	aulademo2020.m.component_id	1	Using where

Perfil

Status	Duration
Starting	0.20 ms
Checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.06 ms
Optimizing	0.05 ms
Statistics	0.10 ms
Preparing	0.05 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
Creating sort index	5.33 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.03 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.05 ms
Reset for next command	0.00 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Igual que la crida de la línia de sota.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Afegeix la directiva xdebug.file_link_format al teu php.ini per enllaçar els arxius]

Temps de petició: 0.52 ms Després de la darrera petició: 16.24 ms Petició de memòria: 0.048 MB Memòria abans de la petició: 4.728 MB Cel·les retornades: 10

SELECT id, home, template, s.params

  FROM aulatemplate_styles as s

  LEFT JOIN aulaextensions 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

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	10
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	aulademo2020.s.template,const	1	Using index condition; Using where

Perfil

Status	Duration
Starting	0.03 ms
Checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.23 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.03 ms
Reset for next command	0.00 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/t3/includes/core/t3.php:320
9	T3::detect()	JROOT/plugins/system/t3/t3.php:81
8	plgSystemT3->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Afegeix la directiva xdebug.file_link_format al teu php.ini per enllaçar els arxius]

Temps de petició: 0.57 ms Després de la darrera petició: 14.83 ms Petició de memòria: 0.037 MB Memòria abans de la petició: 5.127 MB Cel·les retornades: 78

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `aulaassets`

  WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	aulaassets	ALL	idx_asset_name,idx_parent_id	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	283	Using where

Perfil

Status	Duration
Starting	0.03 ms
Checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.15 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.00 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
16	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Afegeix la directiva xdebug.file_link_format al teu php.ini per enllaçar els arxius]

Temps de petició: 0.55 ms Després de la darrera petició: 0.77 ms Petició de memòria: 0.035 MB Memòria abans de la petició: 5.223 MB Cel·les retornades: 31

SHOW FULL COLUMNS 
  FROM `aulacontent`

Explicació

EXPLICACIÓ no possible a la petició: SHOW FULL COLUMNS FROM `aulacontent`

Perfil

Status	Duration
Starting	0.02 ms
Checking permissions	0.00 ms
Closing tables	0.00 ms
Opening tables	0.14 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.00 ms
Optimizing	0.00 ms
Statistics	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Filling schema table	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
Checking permissions	0.07 ms
Closing tables	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Removing tmp table	0.05 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.03 ms
Reset for next command	0.00 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:312
10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:253
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Afegeix la directiva xdebug.file_link_format al teu php.ini per enllaçar els arxius]

Temps de petició: 1.13 ms Després de la darrera petició: 2.46 ms Petició de memòria: 0.005 MB Memòria abans de la petició: 5.291 MB

UPDATE aulacontent

  SET `hits` = (`hits` + 1)

  WHERE `id` = '208'

Explicació

EXPLICACIÓ no possible a la petició: UPDATE aulacontent SET `hits` = (`hits` + 1) WHERE `id` = '208'

Perfil

Status	Duration
Starting	0.02 ms
Checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init for update	0.02 ms
Updating	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.72 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1245
10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:254
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Afegeix la directiva xdebug.file_link_format al teu php.ini per enllaçar els arxius]

Temps de petició: 2.12 ms Després de la darrera petició: 1.56 ms Petició de memòria: 0.036 MB Memòria abans de la petició: 5.316 MB Cel·les retornades: 1

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM aulacontent AS a

  INNER JOIN aulacategories AS c 
  on c.id = a.catid

  LEFT JOIN aulausers AS u 
  on u.id = a.created_by

  LEFT JOIN aulacategories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN aulacontent_rating AS v 
  ON a.id = v.content_id

  WHERE a.id = 208 
  AND c.published > 0 
  AND a.language in ('ca-ES','*') 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-05-02 14:34:02') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-02 14:34:02') 
  AND (a.state = 1 OR a.state =2)

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY,idx_state,idx_catid,idx_language	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	Unique row not found

Perfil

Status	Duration
Starting	0.38 ms
Checking permissions	0.02 ms
Opening tables	0.08 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.28 ms
Optimizing	0.10 ms
Statistics	0.28 ms
Preparing	0.02 ms
Unlocking tables	0.03 ms
Preparing	0.05 ms
Executing	0.02 ms
Sending data	0.23 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.15 ms
Reset for next command	0.02 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
12	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Afegeix la directiva xdebug.file_link_format al teu php.ini per enllaçar els arxius]

Temps de petició: 1.54 ms Després de la darrera petició: 1.68 ms Petició de memòria: 0.034 MB Memòria abans de la petició: 5.441 MB Cel·les retornades: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `aulacontentitem_tag_map` AS m 

  INNER JOIN `aulatags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 208 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	6	Using where
1	SIMPLE	m	ALL	idx_tag_type	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	4	Using where; Using join buffer (flat, BNL join)

Perfil

Status	Duration
Starting	0.15 ms
Checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.11 ms
Optimizing	0.06 ms
Statistics	0.13 ms
Preparing	0.09 ms
Executing	0.01 ms
Sending data	0.20 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.14 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.12 ms
Reset for next command	0.01 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
11	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Afegeix la directiva xdebug.file_link_format al teu php.ini per enllaçar els arxius]

Temps de petició: 1.81 ms Després de la darrera petició: 8.19 ms Petició de memòria: 0.038 MB Memòria abans de la petició: 5.558 MB Cel·les retornades: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `aulacategories` AS `s`

  INNER JOIN `aulacategories` AS `c` 
  ON (s.lft < c.lft 
  AND c.lft < s.rgt 
  AND c.language IN ('ca-ES','*')) OR (c.lft <= s.lft 
  AND s.rgt <= c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 2

  ORDER BY c.lft

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right,idx_language	idx_left_right	4	NULL	3	Using index condition; Using where

Perfil

Status	Duration
Starting	0.28 ms
Checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.12 ms
Optimizing	0.08 ms
Statistics	0.35 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.07 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.21 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.04 ms
Starting cleanup	0.02 ms
Freeing items	0.05 ms
Updating status	0.14 ms
Reset for next command	0.02 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
18	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
17	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
16	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Afegeix la directiva xdebug.file_link_format al teu php.ini per enllaçar els arxius]

Temps de petició: 4.23 ms Després de la darrera petició: 0.51 ms Petició de memòria: 0.037 MB Memòria abans de la petició: 5.579 MB Cel·les retornades: 0

SELECT DISTINCT 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, g.note as group_note

  FROM aulafields AS a

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

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

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

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

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

  LEFT JOIN `aulafields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (2,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1) 
  AND a.language in ('*','ca-ES')

  ORDER BY a.ordering ASC

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context,idx_language	idx_context	766	const	1	Using where; Using temporary; Utilitzant ordenació d`arxius
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	aulademo2020.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	aulademo2020.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	aulademo2020.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	aulademo2020.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	aulademo2020.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	aulademo2020.a.id	1	Using where; Using index; Distinct

Perfil

Status	Duration
Starting	1.16 ms
Checking permissions	0.02 ms
Opening tables	0.13 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.14 ms
Optimizing	0.10 ms
Statistics	0.29 ms
Preparing	0.12 ms
Creating tmp table	0.13 ms
Sorting result	0.06 ms
Executing	0.01 ms
Sending data	1.24 ms
Creating sort index	0.08 ms
Removing tmp table	0.16 ms
Creating sort index	0.04 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.11 ms
Reset for next command	0.02 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Afegeix la directiva xdebug.file_link_format al teu php.ini per enllaçar els arxius]

Temps de petició: 2.06 ms Després de la darrera petició: 11.37 ms Petició de memòria: 0.027 MB Memòria abans de la petició: 5.730 MB Cel·les retornades: 6

SHOW FULL COLUMNS 
  FROM `aulatemplate_styles`

Explicació

EXPLICACIÓ no possible a la petició: SHOW FULL COLUMNS FROM `aulatemplate_styles`

Perfil

Status	Duration
Starting	0.09 ms
Checking permissions	0.02 ms
Closing tables	0.01 ms
Opening tables	0.63 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.04 ms
Executing	0.02 ms
Filling schema table	0.03 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
Checking permissions	0.25 ms
Closing tables	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
Closing tables	0.01 ms
Removing tmp table	0.22 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.03 ms
Freeing items	0.02 ms
Updating status	0.08 ms
Reset for next command	0.01 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
12	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
11	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
10	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_templates/tables/style.php:30
9	TemplatesTableStyle->__construct()	JROOT/libraries/src/Table/Table.php:312
8	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/helix3/helix3.php:37
7	plgSystemHelix3->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Afegeix la directiva xdebug.file_link_format al teu php.ini per enllaçar els arxius]

Temps de petició: 0.77 ms Després de la darrera petició: 0.06 ms Petició de memòria: 0.023 MB Memòria abans de la petició: 5.750 MB Cel·les retornades: 1

SELECT *

  FROM aulatemplate_styles

  WHERE `id` = '20'

Explicació

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

Perfil

Status	Duration
Starting	0.08 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.04 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.01 ms
Unlocking tables	0.03 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.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.12 ms
Reset for next command	0.01 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
9	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
8	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/helix3/helix3.php:38
7	plgSystemHelix3->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Afegeix la directiva xdebug.file_link_format al teu php.ini per enllaçar els arxius]

Temps de petició: 1.40 ms Després de la darrera petició: 1.48 ms Petició de memòria: 0.023 MB Memòria abans de la petició: 5.786 MB Cel·les retornades: 5

SELECT language,id

  FROM `aulamenu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	aulamenu	ALL	idx_client_id_parent_id_alias_language	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	367	Using where

Perfil

Status	Duration
Starting	0.11 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.04 ms
Optimizing	0.03 ms
Statistics	0.10 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.54 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.08 ms
Reset for next command	0.01 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Afegeix la directiva xdebug.file_link_format al teu php.ini per enllaçar els arxius]

Temps de petició: 1.51 ms Després de la darrera petició: 1.02 ms Petició de memòria: 0.023 MB Memòria abans de la petició: 5.799 MB Cel·les retornades: 4

SELECT `c2`.`language`,`c2`.`id`

  FROM `aulamenu` AS `c`

  INNER JOIN `aulaassociations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item'

  INNER JOIN `aulaassociations` AS `a2` 
  ON `a`.`key` = `a2`.`key`

  INNER JOIN `aulamenu` AS `c2` 
  ON a2.id = c2.`id`

  WHERE c.id = 763

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	a	const	PRIMARY,idx_key	PRIMARY	206	const,const	1
1	SIMPLE	a2	ref	idx_key	idx_key	765	const	4	Using where
1	SIMPLE	c2	eq_ref	PRIMARY	PRIMARY	4	aulademo2020.a2.id	1

Perfil

Status	Duration
Starting	0.16 ms
Checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.05 ms
Optimizing	0.06 ms
Statistics	0.28 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.06 ms
Executing	0.01 ms
Sending data	0.28 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.08 ms
Reset for next command	0.02 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
9	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
8	MenusHelper::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:768
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Afegeix la directiva xdebug.file_link_format al teu php.ini per enllaçar els arxius]

Temps de petició: 1.26 ms Després de la darrera petició: 0.57 ms Petició de memòria: 0.023 MB Memòria abans de la petició: 5.819 MB Cel·les retornades: 0

SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`

  FROM `aulacontent` AS `c`

  INNER JOIN `aulaassociations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_content.item'

  INNER JOIN `aulaassociations` AS `a2` 
  ON `a`.`key` = `a2`.`key`

  INNER JOIN `aulacontent` AS `c2` 
  ON a2.id = c2.`id`

  INNER JOIN `aulacategories` AS `ca` 
  ON `c2`.`catid` = ca.id 
  AND ca.extension = 'com_content'

  WHERE c.id = 208 
  AND c2.access IN (1,1,5) 
  AND c2.language != 'ca-ES' 
  AND (c2.publish_up = '0000-00-00 00:00:00' OR c2.publish_up <= '2024-05-02 14:34:02') 
  AND (c2.publish_down = '0000-00-00 00:00:00' OR c2.publish_down >= '2024-05-02 14:34:02') 
  AND c2.state = 1

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Perfil

Status	Duration
Starting	0.28 ms
Checking permissions	0.02 ms
Opening tables	0.07 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.10 ms
Optimizing	0.10 ms
Statistics	0.18 ms
Preparing	0.02 ms
Executing	0.04 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.03 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.08 ms
Reset for next command	0.01 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
9	Joomla\CMS\Language\Associations::getAssociations()	JROOT/components/com_content/helpers/association.php:76
8	ContentHelperAssociation::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:783
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Afegeix la directiva xdebug.file_link_format al teu php.ini per enllaçar els arxius]

Temps de petició: 0.84 ms Després de la darrera petició: 2.02 ms Petició de memòria: 0.023 MB Memòria abans de la petició: 5.835 MB Cel·les retornades: 1

SELECT title 
  FROM aulausergroups 
  WHERE id = 9

Explicació

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

Perfil

Status	Duration
Starting	0.10 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.06 ms
Preparing	0.01 ms
Unlocking tables	0.03 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
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.10 ms
Reset for next command	0.01 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/templates/gradomedio/aulafunctions.php:23
8	include JROOT/templates/gradomedio/aulafunctions.php	JROOT/templates/gradomedio/index.php:7
7	require JROOT/templates/gradomedio/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Afegeix la directiva xdebug.file_link_format al teu php.ini per enllaçar els arxius]

Temps de petició: 2.57 ms Després de la darrera petició: 1.14 ms Petició de memòria: 0.027 MB Memòria abans de la petició: 5.869 MB Cel·les retornades: 4

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

  FROM aulamodules AS m

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

  LEFT JOIN aulaextensions 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-05-02 14:34:02') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-02 14:34:02') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 763 OR mm.menuid <= 0) 
  AND m.language IN ('ca-ES','*')

  ORDER BY m.position, m.ordering

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds,idx_language	published	1	const	67	Using index condition; Using where; Utilitzant ordenació d`arxius
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	aulademo2020.m.module,const	1	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	aulademo2020.m.id	2	Using where; Using index

Perfil

Status	Duration
Starting	0.22 ms
Checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.10 ms
Optimizing	0.09 ms
Statistics	0.22 ms
Preparing	0.12 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	1.13 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.12 ms
Reset for next command	0.01 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	Igual que la crida de la línia de sota.
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/gradomedio/index.php:199
7	require JROOT/templates/gradomedio/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Afegeix la directiva xdebug.file_link_format al teu php.ini per enllaçar els arxius]

30 tipus de consultes registrades, ordenades per l`ocurrència DESC

Taules SELECCIONADES:

2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `aulaassets`

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

1 × SELECT `data` 
  FROM `aulasession`

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

1 × SELECT title 
  FROM aulausergroups

1 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid` 
  FROM `aulacontent` AS `c` 
  INNER JOIN `aulaassociations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_content.item' 
  INNER JOIN `aulaassociations` AS `a2` 
  ON `a`.`key` = `a2`.`key` 
  INNER JOIN `aulacontent` AS `c2` 
  ON a2.id = c2.`id` 
  INNER JOIN `aulacategories` AS `ca` 
  ON `c2`.`catid` = ca.id 
  AND ca.extension = 'com_content'

1 × SELECT `c2`.`language`,`c2`.`id` 
  FROM `aulamenu` AS `c` 
  INNER JOIN `aulaassociations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item' 
  INNER JOIN `aulaassociations` AS `a2` 
  ON `a`.`key` = `a2`.`key` 
  INNER JOIN `aulamenu` AS `c2` 
  ON a2.id = c2.`id`

1 × SELECT language,id 
  FROM `aulamenu`

1 × SELECT * 
  FROM aulatemplate_styles

1 × SELECT DISTINCT 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, g.note as group_note 
  FROM aulafields AS a 
  LEFT JOIN `aulalanguages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN aulausers AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN aulaviewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN aulausers AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN aulafields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `aulafields_categories` AS fc 
  ON fc.field_id = a.id

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM `aulacategories` AS `s` 
  INNER JOIN `aulacategories` AS `c` 
  ON (s.lft < c.lft 
  AND c.lft < s.rgt 
  AND c.language IN ('ca-ES','*')) OR (c.lft <= s.lft 
  AND s.rgt <= c.rgt)

1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `aulacontentitem_tag_map` AS m  
  INNER JOIN `aulatags` AS t  
  ON `m`.`tag_id` = `t`.`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 aulamenu AS m 
  LEFT JOIN aulaextensions AS e 
  ON m.component_id = e.extension_id

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

1 × SELECT `session_id` 
  FROM `aulasession`

1 × SELECT `element`,`name`,`client_id`,`extension_id` 
  FROM `aulaextensions`

```
1 × SELECT * 
  FROM aulalanguages
```
```
1 × SELECT * 
  FROM aulaextensions
```

1 × SELECT `id`,`title` 
  FROM `aulaviewlevels`

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM aulaextensions

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

1 × SELECT id, rules 
  FROM `aulaviewlevels

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

ALTRES taules:

1 × INSERT INTO `aulasession` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'756835716e64767135746e6c663864646969316373753865316d', 1, 1714660442, 0, '', 0

1 × SHOW FULL COLUMNS 
  FROM `aulaextensions

1 × UPDATE `aulaextensions` 
  SET `package_id`='10339',`name`='COM_CHATBRO',`type`='component',`element`='com_chatbro',`folder`='',`client_id`='1',`enabled`='1',`access`='0',`protected`='0',`manifest_cache`='{\"name\":\"COM_CHATBRO\",\"type\":\"component\",\"creationDate\":\"Feb 2017\",\"author\":\"ChatBro Team\",\"copyright\":\"\",\"authorEmail\":\"\",\"authorUrl\":\"https:\\/\\/www.chatbro.com\",\"version\":\"3.0.1\",\"description\":\"COM_CHATBRO_DESCRIPTION\",\"
  group\":\"\",\"filename\":\"chatbro\"}',`params`='{\"chatbro_chat_guid\":\"20674f1a-ec49-4a12-b54e-5b41baa41dd2\",\"chatbro_chat_display\":\"disable\",\"chatbro_chat_selected_pages\":\"foro\",\"chatbro_chat_user_profile_url\":\"\",\"chatbro_view_access_level\":false}',`custom_data`='',`system_data`='',`checked_out`='0',`checked_out_time`='0000-00-00 00:00:00',`ordering`='0',`state`='0'

1 × UPDATE `aulaextensions` 
  SET `params` = '{\"mediaversion\":\"af356572a029bf895ab4a248ca8bb2e1\"}'

1 × SHOW FULL COLUMNS 
  FROM `aulacontent

1 × UPDATE aulacontent 
  SET `hits` = (`hits` + 1)

1 × SHOW FULL COLUMNS 
  FROM `aulatemplate_styles

Gràcies

Gràcies per haver utilitzat la nostra metodologia durant l'estat de confinament a conseqüència de l'COVID-19.

364 centres educatius i més de 10.000 alumnes de diferents països heu pogut gaudir, de forma gratuïta, durant 3 mesos i mig, de l'ús de la plataforma aulavirtualmusica.com

Si necessites més informació de com realitzar la implantació de la metodologia al teu centre, pots escriure a Aquesta adreça de correu-e està protegida dels robots de spam.Necessites Javascript habilitat per veure-la. i t'informarem de tot.

Consola de Depuració per Joomla!

Sessió

Informació de perfils

Hora

Memòria

Ús de la memòria

Peticions a la base de dades

32 consultes registrades 54.27 ms

30 tipus de consultes registrades, ordenades per l`ocurrència DESC

Taules SELECCIONADES:

ALTRES taules: