Protecció de dades

Registre General de Protecció de Dades

L'usuari queda informat i consent que les dades recollides, d'acord amb el que preveu la Llei Orgànica 15/1999 de Protecció de Dades de Caràcter personal i del Reial Decret 1720/2007 del Reglament de desenvolupament de la LOPD, seran incloses en el fitxer " usuaris curs online "inscrit en el Registre General de Protecció de Dades, el responsable del fitxer és Aulavirtualmusica SL i la finalitat és l'accés al curs en línia, així com les gestions derivades d'això.

Les dades seran eliminats del sistema quen l'usuario cause baixa del curs.

L'usuari podrà exercitar els drets d'accés, rectificació, cancel·lació i, si escau, oposició, presentant o enviat una sol·licitud per escrit, dirigida a Av. 9 d'octubre, 82A- despatx 3.- 46.520.- Port de Sagunt - València (Espanya), acompanyada d'una fotocòpia del seu DNI o document acreditatiu equivalent i indicant a l'assumpte "PROTECCIÓ dE DADES".

Consola de Depuració per Joomla!

Sessió

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1714836025,
                "last": 1714836025,
                "now": 1714836025
            }
        },
        "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.82 ms / 15.82 ms Memòria: 0.703 MB / 1.08 MB Application: afterLoad

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

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

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

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

Hora: 41.47 ms / 124.80 ms Memòria: 1.303 MB / 4.27 MB Application: afterInitialise

Hora: 23.70 ms / 148.50 ms Memòria: 0.731 MB / 5.00 MB Application: afterRoute

Hora: 0.08 ms / 148.59 ms Memòria: 0.014 MB / 5.02 MB Application: beforeRenderComponent com_content

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

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

Hora: 0.01 ms / 152.50 ms Memòria: 0.000 MB / 5.21 MB Application: Before Access::getAssetRules (id:233 name:com_content.article.100)

Hora: 0.03 ms / 152.53 ms Memòria: 0.007 MB / 5.22 MB Application: After Access::getAssetRules (id:233 name:com_content.article.100)

Hora: 33.64 ms / 186.17 ms Memòria: 0.432 MB / 5.65 MB Application: afterRenderComponent com_content

Hora: 5.93 ms / 192.10 ms Memòria: 0.154 MB / 5.80 MB Application: Before Access::getAssetRules (id:8 name:com_content)

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

Hora: 4.59 ms / 196.72 ms Memòria: 0.053 MB / 5.87 MB Application: afterDispatch

Hora: 3.96 ms / 200.68 ms Memòria: 0.050 MB / 5.92 MB Application: beforeRenderModule mod_custom (Footer Social (ca))

Hora: 0.68 ms / 201.36 ms Memòria: 0.008 MB / 5.92 MB Application: afterRenderModule mod_custom (Footer Social (ca))

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

Hora: 1.54 ms / 203.03 ms Memòria: 0.028 MB / 5.95 MB Application: afterRenderModule mod_menu (Footer Menu (ca))

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

Hora: 0.06 ms / 203.12 ms Memòria: 0.003 MB / 5.95 MB Application: afterRenderModule mod_custom (Footer Info (ca))

Hora: 0.03 ms / 203.15 ms Memòria: 0.000 MB / 5.95 MB Application: beforeRenderModule mod_menu (Menu de Acceso (ca))

Hora: 0.22 ms / 203.36 ms Memòria: 0.011 MB / 5.97 MB Application: afterRenderModule mod_menu (Menu de Acceso (ca))

Hora: 2.25 ms / 205.62 ms Memòria: 0.107 MB / 6.07 MB Application: afterRender

Total de peticions a la base de dades: 48.28 ms

Ús de la memòria

Peticions a la base de dades

35 consultes registrades 48.28 ms

Temps de petició: 0.45 ms Petició de memòria: 0.025 MB Memòria abans de la petició: 1.488 MB Cel·les retornades: 0

SELECT `data`

  FROM `aulasession`

  WHERE `session_id` = X'66676173306b6c396c707566346939746673756a6d74306d6566'

Explicació

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

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.04 ms
Preparing	0.00 ms
Executing	0.01 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.02 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: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

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

Temps de petició: 0.38 ms Després de la darrera petició: 1.19 ms Petició de memòria: 0.022 MB Memòria abans de la petició: 1.566 MB Cel·les retornades: 0

SELECT `session_id`

  FROM `aulasession`

  WHERE `session_id` = X'66676173306b6c396c707566346939746673756a6d74306d6566' 
  LIMIT 1

Explicació

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

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	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Executing	0.01 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.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 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
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

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

Temps de petició: 1.16 ms Després de la darrera petició: 0.05 ms Petició de memòria: 0.004 MB Memòria abans de la petició: 1.571 MB

INSERT INTO `aulasession`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'66676173306b6c396c707566346939746673756a6d74306d6566', 1, 1714836025, 0, '', 0)

Explicació

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

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 for update	0.01 ms
Update	0.04 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.77 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
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ó: 0.87 ms Després de la darrera petició: 2.94 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.06 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.22 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
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ó: 0.67 ms Després de la darrera petició: 2.40 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.05 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 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.09 ms
Reset for next command	0.00 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.39 ms Després de la darrera petició: 0.23 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.04 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.04 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 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.03 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/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ó: 1.58 ms Després de la darrera petició: 0.96 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.07 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.02 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.92 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 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.06 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/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.78 ms Després de la darrera petició: 23.21 ms Petició de memòria: 0.024 MB Memòria abans de la petició: 2.762 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.06 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.40 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.00 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 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ó: 0.93 ms Després de la darrera petició: 2.18 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.04 ms
Checking permissions	0.01 ms
Closing tables	0.01 ms
Opening tables	0.30 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
Checking permissions	0.11 ms
Closing tables	0.01 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.00 ms
Closing tables	0.00 ms
Removing tmp table	0.11 ms
Closing tables	0.01 ms
Unlocking tables	0.00 ms
Closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.05 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.74 ms Després de la darrera petició: 0.46 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.05 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.06 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 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.61 ms Després de la darrera petició: 0.08 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.08 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init for update	0.04 ms
Updating	0.04 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.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
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ó: 1.71 ms Després de la darrera petició: 0.10 ms Petició de memòria: 0.031 MB Memòria abans de la petició: 2.909 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.09 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.10 ms
Optimizing	0.02 ms
Statistics	0.17 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.71 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.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 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
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.47 ms Després de la darrera petició: 8.63 ms Petició de memòria: 0.027 MB Memòria abans de la petició: 3.091 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.13 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.05 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.01 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.20 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.22 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.11 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.06 ms
Statistics	0.09 ms
Preparing	0.05 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
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.18 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.61 ms Després de la darrera petició: 8.58 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.16 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.08 ms
Optimizing	0.04 ms
Statistics	0.16 ms
Preparing	0.06 ms
Executing	0.01 ms
Sending data	0.12 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.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.23 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.90 ms Després de la darrera petició: 0.07 ms Petició de memòria: 0.006 MB Memòria abans de la petició: 3.235 MB

UPDATE `aulaextensions`

  SET `params` = '{\"mediaversion\":\"7b46aed45a1621bfad9a10b0524ac6ff\"}'

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

Explicació

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

Perfil

Status	Duration
Starting	0.16 ms
Checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init for update	0.20 ms
Updating	0.23 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	1.39 ms
Closing tables	0.02 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
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ó: 7.71 ms Després de la darrera petició: 5.87 ms Petició de memòria: 0.256 MB Memòria abans de la petició: 3.447 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.23 ms
Checking permissions	0.02 ms
Opening tables	0.06 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.07 ms
Optimizing	0.05 ms
Statistics	0.12 ms
Preparing	0.06 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
Creating sort index	6.16 ms
End of update loop	0.03 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.12 ms
Freeing items	0.02 ms
Updating status	0.26 ms
Reset for next command	0.01 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ó: 2.27 ms Després de la darrera petició: 14.18 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.15 ms
Checking permissions	0.04 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.06 ms
Statistics	0.16 ms
Preparing	0.07 ms
Executing	0.01 ms
Sending data	1.24 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.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
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ó: 1.83 ms Després de la darrera petició: 13.19 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.12 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.05 ms
Optimizing	0.04 ms
Statistics	0.13 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.78 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.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.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: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ó: 2.19 ms Després de la darrera petició: 0.72 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.08 ms
Checking permissions	0.01 ms
Closing tables	0.03 ms
Opening tables	0.64 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.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.02 ms
Checking permissions	0.36 ms
Closing tables	0.03 ms
Executing	0.01 ms
Sending data	0.18 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.23 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.12 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: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.95 ms Després de la darrera petició: 2.42 ms Petició de memòria: 0.005 MB Memòria abans de la petició: 5.292 MB

UPDATE aulacontent

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

  WHERE `id` = '100'

Explicació

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

Perfil

Status	Duration
Starting	0.11 ms
Checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init for update	0.10 ms
Updating	0.12 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	1.19 ms
Closing tables	0.02 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
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ó: 1.89 ms Després de la darrera petició: 1.43 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 = 100 
  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-04 15:20:25') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-04 15:20:25') 
  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.40 ms
Checking permissions	0.02 ms
Opening tables	0.08 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.15 ms
Optimizing	0.09 ms
Statistics	0.25 ms
Preparing	0.02 ms
Unlocking tables	0.03 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.22 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.17 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.76 ms Després de la darrera petició: 1.54 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` = 100 
  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.20 ms
Checking permissions	0.02 ms
Opening tables	0.06 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.11 ms
Optimizing	0.06 ms
Statistics	0.18 ms
Preparing	0.10 ms
Executing	0.01 ms
Sending data	0.21 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.25 ms
Reset for next command	0.02 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ó: 2.22 ms Després de la darrera petició: 7.87 ms Petició de memòria: 0.038 MB Memòria abans de la petició: 5.559 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 = 24

  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	ALL	cat_idx,idx_access,idx_left_right,idx_language	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	29	Using where; Utilitzant ordenació d`arxius

Perfil

Status	Duration
Starting	0.34 ms
Checking permissions	0.02 ms
Opening tables	0.06 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.14 ms
Optimizing	0.09 ms
Statistics	0.35 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.06 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.06 ms
Creating sort index	0.26 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.18 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ó: 3.28 ms Després de la darrera petició: 0.46 ms Petició de memòria: 0.037 MB Memòria abans de la petició: 5.580 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 (24,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	0.34 ms
Checking permissions	0.04 ms
Opening tables	0.11 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.03 ms
Executing	0.03 ms
Sending data	0.94 ms
Creating sort index	0.10 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.07 ms
Updating status	0.12 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ó: 0.63 ms Després de la darrera petició: 6.45 ms Petició de memòria: 0.027 MB Memòria abans de la petició: 5.661 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.02 ms
Checking permissions	0.00 ms
Closing tables	0.00 ms
Opening tables	0.12 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.01 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.03 ms
Closing tables	0.01 ms
Executing	0.00 ms
Sending data	0.02 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.04 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
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.45 ms Després de la darrera petició: 0.05 ms Petició de memòria: 0.023 MB Memòria abans de la petició: 5.681 MB Cel·les retornades: 1

SELECT *

  FROM aulatemplate_styles

  WHERE `id` = '10'

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.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	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 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.01 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
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ó: 0.54 ms Després de la darrera petició: 1.81 ms Petició de memòria: 0.023 MB Memòria abans de la petició: 5.718 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.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	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.12 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.02 ms
Reset for next command	0.00 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ó: 0.55 ms Després de la darrera petició: 1.00 ms Petició de memòria: 0.023 MB Memòria abans de la petició: 5.795 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 = 509

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.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.06 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.05 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.01 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/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ó: 0.70 ms Després de la darrera petició: 0.56 ms Petició de memòria: 0.023 MB Memòria abans de la petició: 5.814 MB Cel·les retornades: 3

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 = 100 
  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-04 15:20:25') 
  AND (c2.publish_down = '0000-00-00 00:00:00' OR c2.publish_down >= '2024-05-04 15:20:25') 
  AND c2.state = 1

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,idx_access,idx_state,idx_catid,idx_language	PRIMARY	4	aulademo2020.a2.id	1	Using where
1	SIMPLE	ca	eq_ref	PRIMARY,cat_idx	PRIMARY	4	aulademo2020.c2.catid	1	Using where

Perfil

Status	Duration
Starting	0.05 ms
Checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.09 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.06 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.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 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/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.57 ms Després de la darrera petició: 0.25 ms Petició de memòria: 0.038 MB Memòria abans de la petició: 5.824 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.06 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.02 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Sorting result	0.00 ms
Executing	0.00 ms
Sending data	0.04 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.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 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
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/components/com_content/router.php:72
17	ContentRouter->getCategorySegment()	Igual que la crida de la línia de sota.
16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/languagefilter/languagefilter.php:810
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.59 ms Després de la darrera petició: 0.22 ms Petició de memòria: 0.038 MB Memòria abans de la petició: 5.840 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 = 45

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

Perfil

Status	Duration
Starting	0.05 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.02 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.04 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.01 ms
Updating status	0.02 ms
Reset for next command	0.01 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/components/com_content/router.php:72
17	ContentRouter->getCategorySegment()	Igual que la crida de la línia de sota.
16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/languagefilter/languagefilter.php:810
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.53 ms Després de la darrera petició: 0.20 ms Petició de memòria: 0.039 MB Memòria abans de la petició: 5.862 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 = 31

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

Perfil

Status	Duration
Starting	0.05 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.02 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Sorting result	0.00 ms
Executing	0.00 ms
Sending data	0.04 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.01 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
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/components/com_content/router.php:72
17	ContentRouter->getCategorySegment()	Igual que la crida de la línia de sota.
16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/languagefilter/languagefilter.php:810
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.41 ms Després de la darrera petició: 2.21 ms Petició de memòria: 0.023 MB Memòria abans de la petició: 5.884 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.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	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.00 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
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/templates/minimalist/aulafunctions.php:64
8	include JROOT/templates/minimalist/aulafunctions.php	JROOT/templates/minimalist/index.php:10
7	require JROOT/templates/minimalist/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ó: 0.73 ms Després de la darrera petició: 1.23 ms Petició de memòria: 0.027 MB Memòria abans de la petició: 5.918 MB Cel·les retornades: 5

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-04 15:20:25') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-04 15:20:25') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 509 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.04 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.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.24 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.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 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
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/minimalist/index.php:207
7	require JROOT/templates/minimalist/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:

4 × 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)

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 `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'66676173306b6c396c707566346939746673756a6d74306d6566', 1, 1714836025, 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\":\"7b46aed45a1621bfad9a10b0524ac6ff\"}'

1 × SHOW FULL COLUMNS 
  FROM `aulacontent

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

1 × SHOW FULL COLUMNS 
  FROM `aulatemplate_styles