S&N assessors - Archives

Consola de Depuració per Joomla!

Sessió

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1738741938,
                "last": 1738741938,
                "now": 1738741938
            },
            "token": "7drelYGL1TafBXwggvBZ1thEKT7gWl05"
        },
        "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"
        },
        "com_rsfirewall": {
            "geoip": "US"
        }
    }
}

Informació de perfils

Hora

Memòria

Hora: 108.42 ms / 108.42 ms Memòria: 1.980 MB / 2.36 MB Application: afterLoad

Hora: 2140.83 ms / 2249.24 ms Memòria: 7.291 MB / 9.65 MB Application: afterInitialise

Hora: 1298.28 ms / 3547.52 ms Memòria: 1.480 MB / 11.13 MB Application: afterRoute

Hora: 36.75 ms / 3584.27 ms Memòria: 0.034 MB / 11.17 MB Application: beforeRenderComponent com_content

Hora: 32.00 ms / 3616.27 ms Memòria: 0.544 MB / 11.71 MB Application: Before Access::preloadComponents (all components)

Hora: 2.81 ms / 3619.08 ms Memòria: 0.056 MB / 11.77 MB Application: After Access::preloadComponents (all components)

Hora: 0.07 ms / 3619.15 ms Memòria: -0.004 MB / 11.76 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Hora: 1.49 ms / 3620.64 ms Memòria: 0.027 MB / 11.79 MB Application: After Access::getAssetRules (id:8 name:com_content)

Hora: 343.49 ms / 3964.13 ms Memòria: 0.777 MB / 12.57 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Hora: 0.09 ms / 3964.22 ms Memòria: 0.007 MB / 12.57 MB Application: After Access::getAssetRules (id:1 name:root.1)

Hora: 1209.53 ms / 5173.75 ms Memòria: 2.486 MB / 15.06 MB Application: afterRenderComponent com_content

Hora: 232.88 ms / 5406.64 ms Memòria: 0.117 MB / 15.18 MB Application: afterDispatch

Hora: 10.43 ms / 5417.06 ms Memòria: 0.155 MB / 15.33 MB Application: beforeRenderModule mod_languages (Idiomes)

Hora: 68.43 ms / 5485.50 ms Memòria: 0.137 MB / 15.47 MB Application: afterRenderModule mod_languages (Idiomes)

Hora: 0.08 ms / 5485.58 ms Memòria: -0.002 MB / 15.47 MB Application: beforeRenderModule mod_custom (Top image ca)

Hora: 2.01 ms / 5487.59 ms Memòria: 0.006 MB / 15.47 MB Application: afterRenderModule mod_custom (Top image ca)

Hora: 0.06 ms / 5487.65 ms Memòria: -0.001 MB / 15.47 MB Application: beforeRenderModule mod_superfish_menu (Superfish Menu ca)

Hora: 10.66 ms / 5498.31 ms Memòria: 0.108 MB / 15.58 MB Application: afterRenderModule mod_superfish_menu (Superfish Menu ca)

Hora: 504.38 ms / 6002.69 ms Memòria: 0.584 MB / 16.17 MB Application: afterRender

Total de peticions a la base de dades: 5106.55 ms

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

#	Autor de la crida	Arxiu i nombre de línia
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
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:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

EXPLICACIÓ no possible a la petició: INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3263633635303963646238336561316335303130633666616235393035666634', 1, 1738741938, 0, '', 0)

Perfil

Status	Duration
Starting	0.10 ms
checking permissions	0.04 ms
Opening tables	0.04 ms
After opening tables	0.04 ms
System lock	0.03 ms
table lock	0.03 ms
init for update	0.04 ms
Update	112.55 ms
End of update loop	0.16 ms
Query end	0.03 ms
Commit	0.16 ms
Query end	0.04 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 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:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
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:386
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ó: 36.55 ms Després de la darrera petició: 6.08 ms Petició de memòria: 0.030 MB Memòria abans de la petició: 4.369 MB Cel·les retornades: 37

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

  FROM `jos_extensions`

  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	jos_extensions	ref	extension	extension	62	const	39	Using index condition; Using where

Perfil

Status	Duration
Starting	0.21 ms
checking permissions	0.04 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.03 ms
init	0.05 ms
Optimizing	0.05 ms
Statistics	0.08 ms
Preparing	0.06 ms
Executing	0.03 ms
Sending data	0.31 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
Query end	0.02 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 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:225
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ó: 57.38 ms Després de la darrera petició: 5.69 ms Petició de memòria: 0.023 MB Memòria abans de la petició: 4.624 MB Cel·les retornades: 4

SELECT id, rules

  FROM `jos_viewlevels`

Explicació

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

Perfil

Status	Duration
Starting	39.06 ms
checking permissions	0.15 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.03 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.04 ms
Executing	0.03 ms
Sending data	7.61 ms
End of update loop	0.16 ms
Query end	0.03 ms
Commit	0.03 ms
Query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.03 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:318
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:225
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ó: 257.62 ms Després de la darrera petició: 0.24 ms Petició de memòria: 0.022 MB Memòria abans de la petició: 4.636 MB Cel·les retornades: 2

SELECT b.id

  FROM jos_usergroups AS a

  LEFT JOIN jos_usergroups 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.23 ms
checking permissions	0.03 ms
Opening tables	231.85 ms
After opening tables	0.14 ms
System lock	0.03 ms
table lock	0.03 ms
init	0.04 ms
Optimizing	0.04 ms
Statistics	0.10 ms
Preparing	0.03 ms
Unlocking tables	0.03 ms
Preparing	0.05 ms
Executing	0.03 ms
Sending data	0.05 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.03 ms
Query end	0.02 ms
closing tables	0.03 ms
Unlocking tables	0.02 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 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:318
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:225
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ó: 90.05 ms Després de la darrera petició: 1.41 ms Petició de memòria: 0.038 MB Memòria abans de la petició: 4.702 MB Cel·les retornades: 65

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

  FROM jos_extensions

  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	jos_extensions	ALL	extension	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	228	Using where; Utilitzant ordenació d`arxius

Perfil

Status	Duration
Starting	0.14 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.02 ms
table lock	35.29 ms
init	0.21 ms
Optimizing	0.07 ms
Statistics	0.14 ms
Preparing	0.07 ms
Sorting result	0.04 ms
Executing	0.03 ms
Sending data	0.05 ms
Creating sort index	47.61 ms
End of update loop	0.15 ms
Query end	0.03 ms
Commit	0.03 ms
Query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.04 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:351
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:356
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:225
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ó: 234.02 ms Després de la darrera petició: 32.61 ms Petició de memòria: 0.023 MB Memòria abans de la petició: 5.363 MB Cel·les retornades: 0

SELECT `path`

  FROM jos_rsfirewall_ignored

  WHERE `type`='ignore_folder' OR `type`='ignore_file'

Explicació

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

Perfil

Status	Duration
Starting	0.19 ms
checking permissions	0.04 ms
Opening tables	226.60 ms
After opening tables	0.16 ms
System lock	0.03 ms
table lock	0.03 ms
init	0.05 ms
Optimizing	0.05 ms
Statistics	0.04 ms
Preparing	0.03 ms
Executing	0.03 ms
End of update loop	0.03 ms
Query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
11	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:53
10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:19
9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:161
8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:27
7	plgSystemRsfirewall->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
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:667
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:225
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ó: 352.61 ms Després de la darrera petició: 0.20 ms Petició de memòria: 0.023 MB Memòria abans de la petició: 5.369 MB Cel·les retornades: 0

SELECT `file`

  FROM jos_rsfirewall_hashes

  WHERE `type`='protect'

Explicació

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

Perfil

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

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
11	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:60
10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:19
9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:161
8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:27
7	plgSystemRsfirewall->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
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:667
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:225
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.02 ms Després de la darrera petició: 0.21 ms Petició de memòria: 0.030 MB Memòria abans de la petició: 5.375 MB Cel·les retornades: 66

SELECT *

  FROM jos_rsfirewall_configuration

Explicació

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

Perfil

Status	Duration
Starting	0.08 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.02 ms
table lock	0.03 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.04 ms
Executing	0.03 ms
Sending data	2.03 ms
End of update loop	0.15 ms
Query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.03 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/administrator/components/com_rsfirewall/helpers/config.php:68
10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:19
9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:161
8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:27
7	plgSystemRsfirewall->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
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:667
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:225
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ó: 9.09 ms Després de la darrera petició: 18.64 ms Petició de memòria: 0.028 MB Memòria abans de la petició: 5.902 MB Cel·les retornades: 10

SHOW FULL COLUMNS 
  FROM `jos_rsfirewall_logs`

Explicació

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

Perfil

Status	Duration
Starting	0.18 ms
checking permissions	0.03 ms
closing tables	0.02 ms
checking permissions	0.03 ms
Opening tables	7.46 ms
After opening tables	0.16 ms
System lock	0.03 ms
table lock	0.03 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.04 ms
Executing	0.03 ms
Filling schema table	0.04 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
checking permissions	0.14 ms
closing tables	0.03 ms
checking permissions	0.03 ms
Executing	0.03 ms
Sending data	0.12 ms
End of update loop	0.03 ms
Query end	0.02 ms
closing tables	0.03 ms
Removing tmp table	0.11 ms
closing tables	0.03 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 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:448
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
12	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_rsfirewall/tables/logs.php:36
11	RsfirewallTableLogs->__construct()	JROOT/libraries/src/Table/Table.php:328
10	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_rsfirewall/helpers/log.php:23
9	RSFirewallLogger->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/log.php:57
8	RSFirewallLogger::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:47
7	plgSystemRsfirewall->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
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:667
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:225
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ó: 307.58 ms Després de la darrera petició: 71.18 ms Petició de memòria: 0.027 MB Memòria abans de la petició: 8.249 MB Cel·les retornades: 3

SELECT *

  FROM jos_languages

  WHERE published=1

  ORDER BY ordering ASC

Explicació

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

Perfil

Status	Duration
Starting	0.18 ms
checking permissions	0.03 ms
Opening tables	22.83 ms
After opening tables	0.15 ms
System lock	0.03 ms
table lock	0.03 ms
init	14.33 ms
Optimizing	0.16 ms
Statistics	0.05 ms
Preparing	0.05 ms
Sorting result	0.04 ms
Executing	0.03 ms
Sending data	0.04 ms
Creating sort index	0.11 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
Query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	268.60 ms
Query end	0.17 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.03 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:280
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:667
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:225
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ó: 22.34 ms Després de la darrera petició: 0.37 ms Petició de memòria: 0.023 MB Memòria abans de la petició: 8.260 MB Cel·les retornades: 6

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

  FROM `jos_extensions`

  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	jos_extensions	ref	extension	extension	62	const	6	Using index condition; Using where

Perfil

Status	Duration
Starting	0.22 ms
checking permissions	0.13 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.03 ms
init	0.05 ms
Optimizing	0.05 ms
Statistics	0.08 ms
Preparing	0.07 ms
Executing	0.03 ms
Sending data	0.10 ms
End of update loop	0.08 ms
Query end	0.03 ms
Commit	0.03 ms
Query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 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:280
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:667
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:225
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ó: 16.17 ms Després de la darrera petició: 41.69 ms Petició de memòria: 0.194 MB Memòria abans de la petició: 8.941 MB Cel·les retornades: 126

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

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

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

  ORDER BY m.lft

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	141	Using index condition; Using where; Utilitzant ordenació d`arxius
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	snasse5_joomla.m.component_id	1	Using where

Perfil

Status	Duration
Starting	0.23 ms
checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.03 ms
init	0.06 ms
Optimizing	0.04 ms
Statistics	0.08 ms
Preparing	0.06 ms
Sorting result	0.04 ms
Executing	0.03 ms
Sending data	0.04 ms
Creating sort index	1.54 ms
End of update loop	0.05 ms
Query end	0.03 ms
Commit	0.03 ms
Query end	0.02 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.03 ms
Reset for next command	0.03 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:78
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:142
15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
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:533
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:668
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:225
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.00 ms Després de la darrera petició: 53.79 ms Petició de memòria: 0.029 MB Memòria abans de la petició: 10.377 MB Cel·les retornades: 2

SHOW FULL COLUMNS 
  FROM `jos_komento_configs`

Explicació

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

Perfil

Status	Duration
Starting	0.18 ms
checking permissions	0.03 ms
closing tables	0.02 ms
checking permissions	0.03 ms
Opening tables	0.28 ms
After opening tables	0.03 ms
System lock	0.02 ms
table lock	0.03 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.04 ms
Executing	0.03 ms
Filling schema table	0.03 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
checking permissions	0.10 ms
closing tables	0.03 ms
checking permissions	0.03 ms
Executing	0.02 ms
Sending data	0.06 ms
End of update loop	0.03 ms
Query end	0.03 ms
closing tables	0.02 ms
Removing tmp table	0.10 ms
closing tables	0.03 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.03 ms
Updating status	0.03 ms
Reset for next command	0.03 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/joomla/database/driver/mysqli.php:448
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
15	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
14	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_komento/tables/parent.php:18
13	KomentoParentTable->__construct()	JROOT/administrator/components/com_komento/tables/configs.php:40
12	KomentoTableConfigs->__construct()	JROOT/libraries/src/Table/Table.php:328
11	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_komento/helpers/helper.php:96
10	Komento::getTable()	JROOT/components/com_komento/helpers/helper.php:219
9	Komento::getKonfig()	JROOT/components/com_komento/bootstrap.php:30
8	require_once JROOT/components/com_komento/bootstrap.php	JROOT/components/com_komento/router.php:16
7	require_once JROOT/components/com_komento/router.php	JROOT/libraries/src/Router/SiteRouter.php:779
6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:131
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
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:225
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ó: 173.16 ms Després de la darrera petició: 0.27 ms Petició de memòria: 0.024 MB Memòria abans de la petició: 10.393 MB Cel·les retornades: 1

SELECT *

  FROM jos_komento_configs

  WHERE `component` = 'com_komento'

Explicació

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

Perfil

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

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
10	Joomla\CMS\Table\Table->load()	JROOT/components/com_komento/helpers/helper.php:220
9	Komento::getKonfig()	JROOT/components/com_komento/bootstrap.php:30
8	require_once JROOT/components/com_komento/bootstrap.php	JROOT/components/com_komento/router.php:16
7	require_once JROOT/components/com_komento/router.php	JROOT/libraries/src/Router/SiteRouter.php:779
6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:131
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
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:225
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ó: 150.38 ms Després de la darrera petició: 10.40 ms Petició de memòria: 0.023 MB Memòria abans de la petició: 10.560 MB Cel·les retornades: 0

SELECT *

  FROM jos_rsfirewall_hashes

  WHERE (`type`='3.10.12' OR `type`='protect') 
  AND `flag`!='C'

Explicació

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

Perfil

Status	Duration
Starting	123.86 ms
checking permissions	0.15 ms
Opening tables	25.10 ms
After opening tables	0.16 ms
System lock	0.03 ms
table lock	0.03 ms
init	0.06 ms
Optimizing	0.04 ms
Statistics	0.04 ms
Preparing	0.04 ms
Executing	0.03 ms
Sending data	0.06 ms
End of update loop	0.03 ms
Query end	0.03 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 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/plugins/system/rsfirewall/rsfirewall.php:1044
8	plgSystemRsfirewall->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:1190
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:225
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ó: 19.77 ms Després de la darrera petició: 0.93 ms Petició de memòria: 0.024 MB Memòria abans de la petició: 10.591 MB Cel·les retornades: 0

SELECT *

  FROM jos_rsfirewall_snapshots

  WHERE `type`='protect'

Explicació

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

Perfil

Status	Duration
Starting	0.07 ms
checking permissions	0.03 ms
Opening tables	18.69 ms
After opening tables	0.15 ms
System lock	0.03 ms
table lock	0.03 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	0.03 ms
Preparing	0.03 ms
Executing	0.04 ms
End of update loop	0.03 ms
Query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 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/administrator/components/com_rsfirewall/helpers/snapshot.php:47
9	RSFirewallSnapshot::get()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1067
8	plgSystemRsfirewall->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:1190
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:225
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ó: 152.11 ms Després de la darrera petició: 0.27 ms Petició de memòria: 0.023 MB Memòria abans de la petició: 10.597 MB Cel·les retornades: 0

SELECT `ip`,`reason`

  FROM jos_rsfirewall_lists

  WHERE (`ip`='3.129.43.75' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
  AND `type`='1' 
  AND `published`='1'

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_rsfirewall_lists	ref	published,type,ip	type	1	const	2	Using where

Perfil

Status	Duration
Starting	150.99 ms
checking permissions	0.15 ms
Opening tables	0.07 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.03 ms
init	0.07 ms
Optimizing	0.05 ms
Statistics	0.11 ms
Preparing	0.06 ms
Executing	0.03 ms
Sending data	0.07 ms
End of update loop	0.03 ms
Query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 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/plugins/system/rsfirewall/rsfirewall.php:165
10	plgSystemRsfirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:144
9	plgSystemRsfirewall->isWhitelisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1103
8	plgSystemRsfirewall->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:1190
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:225
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ó: 36.37 ms Després de la darrera petició: 0.27 ms Petició de memòria: 0.023 MB Memòria abans de la petició: 10.603 MB Cel·les retornades: 0

SELECT `ip`,`reason`

  FROM jos_rsfirewall_lists

  WHERE (`ip`='3.129.43.75' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
  AND `type`='0' 
  AND `published`='1'

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_rsfirewall_lists	ALL	published,type,ip	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	559	Using where

Perfil

Status	Duration
Starting	0.19 ms
checking permissions	0.04 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.03 ms
init	0.05 ms
Optimizing	0.05 ms
Statistics	0.10 ms
Preparing	0.06 ms
Executing	0.03 ms
Sending data	0.68 ms
End of update loop	0.04 ms
Query end	0.02 ms
closing tables	0.03 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 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/plugins/system/rsfirewall/rsfirewall.php:165
10	plgSystemRsfirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:134
9	plgSystemRsfirewall->isBlacklisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1107
8	plgSystemRsfirewall->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:1190
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:225
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ó: 221.37 ms Després de la darrera petició: 31.06 ms Petició de memòria: 0.025 MB Memòria abans de la petició: 10.899 MB Cel·les retornades: 0

SELECT *

  FROM jos_rsfirewall_exceptions

  WHERE `published`='1'

Explicació

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

Perfil

Status	Duration
Starting	0.19 ms
checking permissions	0.04 ms
Opening tables	181.77 ms
After opening tables	0.15 ms
System lock	0.03 ms
table lock	20.49 ms
init	0.18 ms
Optimizing	0.05 ms
Statistics	0.05 ms
Preparing	0.04 ms
Executing	0.04 ms
End of update loop	0.03 ms
Query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	12.92 ms
Query end	0.15 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.03 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/plugins/system/rsfirewall/rsfirewall.php:695
9	plgSystemRsfirewall->isException()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1238
8	plgSystemRsfirewall->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:1190
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:225
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ó: 425.37 ms Després de la darrera petició: 3.40 ms Petició de memòria: 0.027 MB Memòria abans de la petició: 10.963 MB Cel·les retornades: 1

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

  FROM `jos_extensions`

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

Explicació

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

Perfil

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

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
19	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
18	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Igual que la crida de la línia de sota.
17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
15	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
14	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
13	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/vmogmetatag/vmogmetatag.php:66
9	plgSystemVmogmetatag->_init()	JROOT/plugins/system/vmogmetatag/vmogmetatag.php:103
8	plgSystemVmogmetatag->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:1190
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:225
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ó: 12.86 ms Després de la darrera petició: 0.40 ms Petició de memòria: 0.006 MB Memòria abans de la petició: 10.956 MB

UPDATE `jos_extensions`

  SET `params` = '{\"mediaversion\":\"23dcc4de01f59cc015fa3220519876bc\"}'

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

Explicació

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

Perfil

Status	Duration
Starting	0.18 ms
checking permissions	0.05 ms
Opening tables	0.05 ms
After opening tables	0.04 ms
System lock	0.03 ms
table lock	0.03 ms
init for update	0.13 ms
Updating	0.17 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	11.19 ms
Query end	0.15 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
14	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
13	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/vmogmetatag/vmogmetatag.php:66
9	plgSystemVmogmetatag->_init()	JROOT/plugins/system/vmogmetatag/vmogmetatag.php:103
8	plgSystemVmogmetatag->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:1190
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:225
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ó: 34.47 ms Després de la darrera petició: 4.81 ms Petició de memòria: 0.021 MB Memòria abans de la petició: 11.150 MB Cel·les retornades: 5

SELECT id, home, template, s.params

  FROM jos_template_styles as s

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

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

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	62	const	5	Using index condition; Using where
1	SIMPLE	s	ALL	idx_template,idx_client_id,idx_client_id_home	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	9	Using where; Using join buffer (flat, BNL join)

Perfil

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

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
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:225
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.35 ms Després de la darrera petició: 33.89 ms Petició de memòria: 0.031 MB Memòria abans de la petició: 11.714 MB Cel·les retornades: 37

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

  FROM `jos_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_aimysitemap','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_finder','com_gsd','com_installer','com_joomlaupdate','com_komento','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_rsfirewall','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_assets	range	idx_asset_name	idx_asset_name	152	NULL	38	Using index condition

Perfil

Status	Duration
Starting	0.23 ms
checking permissions	0.04 ms
Opening tables	0.06 ms
After opening tables	0.04 ms
System lock	0.03 ms
table lock	0.03 ms
init	0.09 ms
Optimizing	0.05 ms
Statistics	0.13 ms
Preparing	0.05 ms
Executing	0.04 ms
Sending data	0.37 ms
End of update loop	0.05 ms
Query end	0.03 ms
Commit	0.03 ms
Query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 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/Access/Access.php:429
19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
15	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/articles.php:115
14	ContentModelArticles->populateState()	JROOT/components/com_content/models/archive.php:44
13	ContentModelArchive->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/archive/view.html.php:39
10	ContentViewArchive->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:225
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ó: 305.86 ms Després de la darrera petició: 3.71 ms Petició de memòria: 0.050 MB Memòria abans de la petició: 11.825 MB Cel·les retornades: 1

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug

  FROM jos_content AS a

  LEFT JOIN jos_categories AS c 
  ON c.id = a.catid

  LEFT JOIN jos_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN jos_users AS uam 
  ON uam.id = a.modified_by

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

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

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND ((c.published = 2 
  AND a.state > 0) OR (c.published = 1 
  AND a.state = 2)) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-02-05 07:52:19') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-02-05 07:52:19') 
  AND a.language IN ('ca-ES','*') 
  AND MONTH( 
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END ) = 2

  ORDER BY  
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC , a.created DESC  
  LIMIT 5

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	range	idx_access,idx_state,idx_catid,idx_language	idx_state	1	NULL	145	Using index condition; Using where; Utilitzant ordenació d`arxius
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	snasse5_joomla.a.catid	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	snasse5_joomla.a.created_by	1	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	snasse5_joomla.a.modified_by	1	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	snasse5_joomla.c.parent_id	1	Using where
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	snasse5_joomla.a.id	1	Using where

Perfil

Status	Duration
Starting	2.44 ms
checking permissions	0.13 ms
Opening tables	298.92 ms
After opening tables	0.15 ms
System lock	0.04 ms
table lock	0.03 ms
init	0.21 ms
Optimizing	0.11 ms
Statistics	0.22 ms
Preparing	0.14 ms
Sorting result	0.05 ms
Executing	0.03 ms
Sending data	0.06 ms
Creating sort index	1.08 ms
End of update loop	0.05 ms
Query end	0.03 ms
Commit	0.03 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_content/models/archive.php:180
14	ContentModelArchive->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
12	ContentModelArticles->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/archive/view.html.php:40
10	ContentViewArchive->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:225
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ó: 16.02 ms Després de la darrera petició: 3.82 ms Petició de memòria: 0.039 MB Memòria abans de la petició: 12.009 MB Cel·les retornades: 7

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

  FROM `jos_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 238 
  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	165	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	snasse5_joomla.t.id	1	Using index condition; Using where

Perfil

Status	Duration
Starting	0.22 ms
checking permissions	0.05 ms
Opening tables	13.39 ms
After opening tables	0.17 ms
System lock	0.04 ms
table lock	0.03 ms
init	0.09 ms
Optimizing	0.07 ms
Statistics	0.14 ms
Preparing	0.11 ms
Executing	0.03 ms
Sending data	1.05 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
Query end	0.03 ms
closing tables	0.07 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.04 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()	JROOT/libraries/src/Helper/TagsHelper.php:454
13	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
12	ContentModelArticles->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/archive/view.html.php:40
10	ContentViewArchive->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:225
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.48 ms Després de la darrera petició: 2.82 ms Petició de memòria: 0.025 MB Memòria abans de la petició: 12.126 MB Cel·les retornades: 1

SELECT COUNT(*)

  FROM jos_content AS a

  LEFT JOIN jos_categories AS c 
  ON c.id = a.catid

  LEFT JOIN jos_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN jos_users AS uam 
  ON uam.id = a.modified_by

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

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

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND ((c.published = 2 
  AND a.state > 0) OR (c.published = 1 
  AND a.state = 2)) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-02-05 07:52:19') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-02-05 07:52:19') 
  AND a.language IN ('ca-ES','*') 
  AND MONTH( 
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END ) = 2

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	idx_access,idx_state,idx_catid,idx_language	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	232	Using where
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	snasse5_joomla.a.catid	1	Using where

Perfil

Status	Duration
Starting	0.31 ms
checking permissions	0.04 ms
Opening tables	0.10 ms
After opening tables	0.04 ms
System lock	0.03 ms
table lock	0.03 ms
init	0.11 ms
Optimizing	0.12 ms
Statistics	0.22 ms
Preparing	0.04 ms
Unlocking tables	0.03 ms
Preparing	0.14 ms
Executing	0.04 ms
Sending data	0.67 ms
End of update loop	0.05 ms
Query end	0.03 ms
Commit	0.03 ms
Query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.04 ms
Query end	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.03 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/src/MVC/Model/BaseDatabaseModel.php:354
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:289
13	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:239
12	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/archive/view.html.php:41
10	ContentViewArchive->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:225
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.48 ms Després de la darrera petició: 38.72 ms Petició de memòria: 0.023 MB Memòria abans de la petició: 13.108 MB Cel·les retornades: 1

SELECT DISTINCT (YEAR(`created`))

  FROM `jos_content`

  WHERE `state`= 2 
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2025-02-05 07:52:19') 
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-02-05 07:52:19')

  ORDER BY 1 ASC

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_content	ref	idx_state	idx_state	1	const	8	Using where; Using temporary; Utilitzant ordenació d`arxius

Perfil

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

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
12	JDatabaseDriver->loadColumn()	JROOT/components/com_content/models/archive.php:217
11	ContentModelArchive->getYears()	JROOT/components/com_content/views/archive/view.html.php:117
10	ContentViewArchive->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:225
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ó: 20.42 ms Després de la darrera petició: 20.74 ms Petició de memòria: 0.042 MB Memòria abans de la petició: 13.491 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 `jos_categories` AS `s`

  INNER JOIN `jos_categories` 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.31 ms
checking permissions	0.04 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.03 ms
init	0.10 ms
Optimizing	0.07 ms
Statistics	18.43 ms
Preparing	0.17 ms
Unlocking tables	0.04 ms
Preparing	0.09 ms
Sorting result	0.05 ms
Executing	0.03 ms
Sending data	0.16 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
Query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
28	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
27	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
26	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
25	ContentRouter->getCategorySegment()	Igual que la crida de la línia de sota.
24	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
23	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
22	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
21	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
20	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
16	Joomla\CMS\Router\Route::_()	JROOT/templates/theme1802/html/com_content/archive/default_items.php:29
15	include JROOT/templates/theme1802/html/com_content/archive/default_items.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/templates/theme1802/html/com_content/archive/default.php:51
13	include JROOT/templates/theme1802/html/com_content/archive/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/archive/view.html.php:148
10	ContentViewArchive->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:225
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ó: 353.59 ms Després de la darrera petició: 18.48 ms Petició de memòria: 0.028 MB Memòria abans de la petició: 13.689 MB Cel·les retornades: 1

SELECT *

  FROM jos_komento_configs

  WHERE `component` = 'com_content'

Explicació

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

Perfil

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

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
19	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
18	Joomla\CMS\Table\Table->load()	JROOT/components/com_komento/helpers/helper.php:193
17	Komento::getConfig()	JROOT/components/com_komento/helpers/helper.php:676
16	Komento::commentify()	JROOT/templates/theme1802/html/com_content/archive/default_items.php:128
15	include JROOT/templates/theme1802/html/com_content/archive/default_items.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/templates/theme1802/html/com_content/archive/default.php:51
13	include JROOT/templates/theme1802/html/com_content/archive/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/archive/view.html.php:148
10	ContentViewArchive->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:225
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ó: 167.14 ms Després de la darrera petició: 11.78 ms Petició de memòria: 0.031 MB Memòria abans de la petició: 13.734 MB Cel·les retornades: 1

SELECT a.id, a.title, a.alias, a.catid, a.created_by, a.created_by_alias, a.hits, c.title AS category_title, c.alias AS category_alias, u.name AS author, parent.id AS parent_id, parent.alias AS parent_alias 
  FROM `jos_content` AS a 
  LEFT JOIN `jos_categories` AS c 
  ON c.id = a.catid 
  LEFT JOIN `jos_users` AS u 
  ON u.id = a.created_by 
  LEFT JOIN `jos_categories` AS parent 
  ON parent.id = c.parent_id 
  WHERE a.id = '238'

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows
1	SIMPLE	a	const	PRIMARY	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

Perfil

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

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/components/com_komento/helpers/database.php:151
19	KomentoDatabaseJoomla15->__call()	JROOT/components/com_komento/helpers/database.php:40
18	KomentoDatabaseHelper->__call()	JROOT/components/com_komento/komento_plugins/com_content.php:54
17	KomentoComcontent->load()	JROOT/components/com_komento/helpers/helper.php:722
16	Komento::commentify()	JROOT/templates/theme1802/html/com_content/archive/default_items.php:128
15	include JROOT/templates/theme1802/html/com_content/archive/default_items.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/templates/theme1802/html/com_content/archive/default.php:51
13	include JROOT/templates/theme1802/html/com_content/archive/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/archive/view.html.php:148
10	ContentViewArchive->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:225
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ó: 104.39 ms Després de la darrera petició: 4.84 ms Petició de memòria: 0.029 MB Memòria abans de la petició: 13.938 MB Cel·les retornades: 1

SELECT `rules` 
  FROM `jos_komento_acl` 
  WHERE `cid` = '9' 
  AND `type` = 'usergroup' 
  AND `component` = 'com_content' 
  ORDER BY `id` ASC

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_komento_acl	index	komento_acl_content_type	PRIMARY	8	NULL	9	Using where

Perfil

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

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
24	JDatabaseDriver->loadResult()	JROOT/components/com_komento/helpers/database.php:151
23	KomentoDatabaseJoomla15->__call()	JROOT/components/com_komento/helpers/database.php:40
22	KomentoDatabaseHelper->__call()	JROOT/components/com_komento/classes/sql.php:935
21	KomentoSql->__call()	JROOT/components/com_komento/models/acl.php:29
20	KomentoModelAcl->getAclObject()	JROOT/components/com_komento/helpers/acl.php:133
19	KomentoACLHelper::getRules()	JROOT/components/com_komento/helpers/helper.php:237
18	Komento::getACL()	JROOT/components/com_komento/helpers/document.php:100
17	KomentoDocumentHelper::loadHeaders()	JROOT/components/com_komento/helpers/helper.php:837
16	Komento::commentify()	JROOT/templates/theme1802/html/com_content/archive/default_items.php:128
15	include JROOT/templates/theme1802/html/com_content/archive/default_items.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/templates/theme1802/html/com_content/archive/default.php:51
13	include JROOT/templates/theme1802/html/com_content/archive/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/archive/view.html.php:148
10	ContentViewArchive->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:225
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.00 ms Després de la darrera petició: 1.51 ms Petició de memòria: 0.030 MB Memòria abans de la petició: 13.961 MB Cel·les retornades: 0

SELECT `rules` 
  FROM `jos_komento_acl` 
  WHERE `cid` = '0' 
  AND `type` = 'user' 
  AND `component` = 'com_content' 
  ORDER BY `id` ASC

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_komento_acl	ref	komento_acl_content_type	komento_acl_content_type	767	const	1	Using index condition; Using where

Perfil

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

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
24	JDatabaseDriver->loadResult()	JROOT/components/com_komento/helpers/database.php:151
23	KomentoDatabaseJoomla15->__call()	JROOT/components/com_komento/helpers/database.php:40
22	KomentoDatabaseHelper->__call()	JROOT/components/com_komento/classes/sql.php:935
21	KomentoSql->__call()	JROOT/components/com_komento/models/acl.php:29
20	KomentoModelAcl->getAclObject()	JROOT/components/com_komento/helpers/acl.php:137
19	KomentoACLHelper::getRules()	JROOT/components/com_komento/helpers/helper.php:237
18	Komento::getACL()	JROOT/components/com_komento/helpers/document.php:100
17	KomentoDocumentHelper::loadHeaders()	JROOT/components/com_komento/helpers/helper.php:837
16	Komento::commentify()	JROOT/templates/theme1802/html/com_content/archive/default_items.php:128
15	include JROOT/templates/theme1802/html/com_content/archive/default_items.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/templates/theme1802/html/com_content/archive/default.php:51
13	include JROOT/templates/theme1802/html/com_content/archive/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/archive/view.html.php:148
10	ContentViewArchive->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:225
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ó: 438.80 ms Després de la darrera petició: 9.17 ms Petició de memòria: 0.028 MB Memòria abans de la petició: 14.750 MB Cel·les retornades: 1

SELECT COUNT(1) 
  FROM `jos_komento_comments` 
  WHERE `component` = 'com_content' 
  AND `cid` = 238 
  AND `published` = '1'

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_komento_comments	ref	komento_threaded,komento_threaded_reverse,komento_module_comments	komento_threaded	776	const,const,const	1	Using where; Using index

Perfil

Status	Duration
Starting	100.03 ms
checking permissions	0.14 ms
Opening tables	336.95 ms
After opening tables	0.15 ms
System lock	0.03 ms
table lock	0.03 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.12 ms
Unlocking tables	0.04 ms
closing tables	0.04 ms
init	0.07 ms
Optimizing	0.06 ms
Statistics	0.24 ms
Preparing	0.08 ms
Executing	0.03 ms
Sending data	0.06 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.04 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
20	JDatabaseDriver->loadResult()	JROOT/components/com_komento/helpers/database.php:151
19	KomentoDatabaseJoomla15->__call()	JROOT/components/com_komento/helpers/database.php:40
18	KomentoDatabaseHelper->__call()	JROOT/components/com_komento/models/comments.php:73
17	KomentoModelComments->getCount()	JROOT/components/com_komento/helpers/helper.php:848
16	Komento::commentify()	JROOT/templates/theme1802/html/com_content/archive/default_items.php:128
15	include JROOT/templates/theme1802/html/com_content/archive/default_items.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/templates/theme1802/html/com_content/archive/default.php:51
13	include JROOT/templates/theme1802/html/com_content/archive/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/archive/view.html.php:148
10	ContentViewArchive->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:225
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.55 ms Després de la darrera petició: 0.32 ms Petició de memòria: 0.039 MB Memòria abans de la petició: 14.761 MB Cel·les retornades: 0

SELECT * 
  FROM `jos_komento_comments` 
  WHERE `component` = 'com_content' 
  AND `cid` = 238 
  AND `published` = '1' 
  AND `parent_id` = '0' 
  ORDER BY `created` DESC 
  LIMIT 0,3

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_komento_comments	ref	komento_threaded,komento_threaded_reverse,komento_module_comments,komento_backend	komento_module_comments	776	const,const,const	1	Using where

Perfil

Status	Duration
Starting	0.11 ms
checking permissions	0.04 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.03 ms
init	0.07 ms
Optimizing	0.05 ms
Statistics	0.16 ms
Preparing	0.08 ms
Sorting result	0.04 ms
Executing	0.03 ms
Sending data	0.08 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 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/components/com_komento/helpers/database.php:151
19	KomentoDatabaseJoomla15->__call()	JROOT/components/com_komento/helpers/database.php:40
18	KomentoDatabaseHelper->__call()	JROOT/components/com_komento/models/comments.php:103
17	KomentoModelComments->getComments()	JROOT/components/com_komento/helpers/helper.php:870
16	Komento::commentify()	JROOT/templates/theme1802/html/com_content/archive/default_items.php:128
15	include JROOT/templates/theme1802/html/com_content/archive/default_items.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/templates/theme1802/html/com_content/archive/default.php:51
13	include JROOT/templates/theme1802/html/com_content/archive/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/archive/view.html.php:148
10	ContentViewArchive->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:225
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ó: 11.73 ms Després de la darrera petició: 7.57 ms Petició de memòria: 0.031 MB Memòria abans de la petició: 14.960 MB Cel·les retornades: 0

Peticions duplicades: #39

SELECT `alias`

  FROM `jos_content`

  WHERE id = '2012'

Explicació

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

Perfil

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

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
28	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
27	ContentRouter->getArticleSegment()	Igual que la crida de la línia de sota.
26	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
25	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
24	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
23	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
22	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
21	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
20	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
19	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
18	Joomla\CMS\Router\Route::_()	JROOT/libraries/src/Pagination/Pagination.php:787
17	Joomla\CMS\Pagination\Pagination->_buildDataObject()	JROOT/libraries/src/Pagination/Pagination.php:328
16	Joomla\CMS\Pagination\Pagination->getPagesLinks()	JROOT/templates/theme1802/html/com_content/archive/default_items.php:233
15	include JROOT/templates/theme1802/html/com_content/archive/default_items.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/templates/theme1802/html/com_content/archive/default.php:51
13	include JROOT/templates/theme1802/html/com_content/archive/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/archive/view.html.php:148
10	ContentViewArchive->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:225
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.28 ms Després de la darrera petició: 0.38 ms Petició de memòria: 0.042 MB Memòria abans de la petició: 14.976 MB Cel·les retornades: 0

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 `jos_categories` AS `s`

  INNER JOIN `jos_categories` 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 = 2012

  ORDER BY c.lft

Explicació

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

Perfil

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

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
30	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
29	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
28	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
27	ContentRouter->getCategorySegment()	Igual que la crida de la línia de sota.
26	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:124
25	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
24	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
23	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
22	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
21	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
20	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
19	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
18	Joomla\CMS\Router\Route::_()	JROOT/libraries/src/Pagination/Pagination.php:787
17	Joomla\CMS\Pagination\Pagination->_buildDataObject()	JROOT/libraries/src/Pagination/Pagination.php:328
16	Joomla\CMS\Pagination\Pagination->getPagesLinks()	JROOT/templates/theme1802/html/com_content/archive/default_items.php:233
15	include JROOT/templates/theme1802/html/com_content/archive/default_items.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/templates/theme1802/html/com_content/archive/default.php:51
13	include JROOT/templates/theme1802/html/com_content/archive/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/archive/view.html.php:148
10	ContentViewArchive->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:225
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ó: 222.11 ms Després de la darrera petició: 9.34 ms Petició de memòria: 0.022 MB Memòria abans de la petició: 15.142 MB Cel·les retornades: 3

SELECT language,id

  FROM `jos_menu`

  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	jos_menu	ALL	idx_client_id_parent_id_alias_language	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	197	Using where

Perfil

Status	Duration
Starting	0.20 ms
checking permissions	0.03 ms
Opening tables	211.80 ms
After opening tables	0.16 ms
System lock	0.03 ms
table lock	0.03 ms
init	0.06 ms
Optimizing	0.05 ms
Statistics	8.79 ms
Preparing	0.19 ms
Executing	0.03 ms
Sending data	0.26 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 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:225
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.86 ms Després de la darrera petició: 0.51 ms Petició de memòria: 0.026 MB Memòria abans de la petició: 15.151 MB Cel·les retornades: 0

Peticions duplicades: #36

SELECT `alias`

  FROM `jos_content`

  WHERE id = '2012'

Explicació

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

Perfil

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

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
17	ContentRouter->getArticleSegment()	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:763
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:225
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.31 ms Després de la darrera petició: 8.23 ms Petició de memòria: 0.027 MB Memòria abans de la petició: 15.345 MB Cel·les retornades: 3

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

  FROM jos_modules AS m

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

  LEFT JOIN jos_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-02-05 07:52:19') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-02-05 07:52:19') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 235 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	22	Using index condition; Using where; Utilitzant ordenació d`arxius
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	snasse5_joomla.m.module,const	1	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	snasse5_joomla.m.id	2	Using where; Using index

Perfil

Status	Duration
Starting	0.30 ms
checking permissions	0.04 ms
Opening tables	0.15 ms
After opening tables	0.05 ms
System lock	0.04 ms
table lock	0.04 ms
init	0.10 ms
Optimizing	0.10 ms
Statistics	0.20 ms
Preparing	0.11 ms
Sorting result	0.04 ms
Executing	0.02 ms
Sending data	0.03 ms
Creating sort index	0.58 ms
End of update loop	0.05 ms
Query end	0.03 ms
Commit	0.03 ms
Query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.05 ms
Query end	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 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()	Igual que la crida de la línia de sota.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
12	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
11	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
10	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
9	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/theme1802/includes/includes.php:71
8	include_once JROOT/templates/theme1802/includes/includes.php	JROOT/templates/theme1802/index.php:8
7	require JROOT/templates/theme1802/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
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:231
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ó: 21.51 ms Després de la darrera petició: 8.93 ms Petició de memòria: 0.024 MB Memòria abans de la petició: 15.442 MB Cel·les retornades: 0

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

  FROM `jos_menu` AS `c`

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

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

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

  WHERE c.id = 235

Explicació

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

Perfil

Status	Duration
Starting	0.24 ms
checking permissions	0.04 ms
Opening tables	0.18 ms
After opening tables	0.06 ms
System lock	0.03 ms
table lock	0.03 ms
init	0.06 ms
Optimizing	0.07 ms
Statistics	0.13 ms
Preparing	0.04 ms
Executing	0.04 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 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()	JROOT/libraries/src/Language/Associations.php:115
13	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
12	MenusHelper::getAssociations()	JROOT/modules/mod_languages/helper.php:58
11	ModLanguagesHelper::getList()	JROOT/modules/mod_languages/mod_languages.php:17
10	include JROOT/modules/mod_languages/mod_languages.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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ó: 402.69 ms Després de la darrera petició: 58.49 ms Petició de memòria: 0.031 MB Memòria abans de la petició: 15.691 MB Cel·les retornades: 1

SELECT *

  FROM `jos_extensions`

  WHERE `element` = 'com_gsd' 
  AND `type` = 'component'

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using index condition; Using where

Perfil

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

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
18	JDatabaseDriver->loadAssoc()	JROOT/plugins/system/nrframework/NRFramework/Extension.php:160
17	NRFramework\Extension::get()	JROOT/plugins/system/nrframework/NRFramework/Extension.php:245
16	NRFramework\Extension::isEnabled()	JROOT/plugins/system/nrframework/NRFramework/Extension.php:228
15	NRFramework\Extension::componentIsEnabled()	JROOT/plugins/system/gsd/gsd.php:393
14	plgSystemGSD->setup()	JROOT/plugins/system/gsd/gsd.php:436
13	plgSystemGSD->getHelper()	JROOT/plugins/system/gsd/gsd.php:62
12	plgSystemGSD->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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ó: 60.54 ms Després de la darrera petició: 2.52 ms Petició de memòria: 0.029 MB Memòria abans de la petició: 15.763 MB Cel·les retornades: 2

SHOW FULL COLUMNS 
  FROM `jos_gsd_config`

Explicació

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

Perfil

Status	Duration
Starting	0.20 ms
checking permissions	0.04 ms
closing tables	0.03 ms
checking permissions	0.03 ms
Opening tables	0.31 ms
After opening tables	0.04 ms
System lock	0.03 ms
table lock	0.03 ms
init	0.03 ms
Optimizing	0.04 ms
Statistics	0.04 ms
Preparing	0.05 ms
Executing	0.04 ms
Filling schema table	0.04 ms
Opening tables	32.35 ms
After opening tables	0.15 ms
checking permissions	0.09 ms
closing tables	0.03 ms
checking permissions	0.03 ms
Executing	0.03 ms
Sending data	0.06 ms
End of update loop	0.03 ms
Query end	0.03 ms
closing tables	0.03 ms
Removing tmp table	0.12 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
19	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
18	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_gsd/tables/config.php:27
17	GSDTableConfig->__construct()	JROOT/libraries/src/Table/Table.php:328
16	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_gsd/GSD/Helper.php:436
15	GSD\Helper::getParams()	JROOT/plugins/system/gsd/gsd.php:405
14	plgSystemGSD->setup()	JROOT/plugins/system/gsd/gsd.php:436
13	plgSystemGSD->getHelper()	JROOT/plugins/system/gsd/gsd.php:62
12	plgSystemGSD->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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ó: 18.29 ms Després de la darrera petició: 0.28 ms Petició de memòria: 0.026 MB Memòria abans de la petició: 15.780 MB Cel·les retornades: 1

SELECT *

  FROM jos_gsd_config

  WHERE `name` = 'config'

Explicació

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

Perfil

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

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
17	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
16	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_gsd/GSD/Helper.php:437
15	GSD\Helper::getParams()	JROOT/plugins/system/gsd/gsd.php:405
14	plgSystemGSD->setup()	JROOT/plugins/system/gsd/gsd.php:436
13	plgSystemGSD->getHelper()	JROOT/plugins/system/gsd/gsd.php:62
12	plgSystemGSD->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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]

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

Taules SELECCIONADES:

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

2 × SELECT `rules` 
  FROM `jos_komento_acl`

2 × SELECT `ip`,`reason` 
  FROM jos_rsfirewall_lists

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 `jos_categories` AS `s` 
  INNER JOIN `jos_categories` 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 `alias` 
  FROM `jos_content`

2 × SELECT * 
  FROM jos_komento_configs

1 × SELECT COUNT(*) 
  FROM jos_content AS a 
  LEFT JOIN jos_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN jos_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN jos_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN jos_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN jos_content_rating AS v 
  ON a.id = v.content_id

1 × SELECT DISTINCT (YEAR(`created`)) 
  FROM `jos_content`

1 × SELECT a.id, a.title, a.alias, a.catid, a.created_by, a.created_by_alias, a.hits, c.title AS category_title, c.alias AS category_alias, u.name AS author, parent.id AS parent_id, parent.alias AS parent_alias 
  FROM `jos_content` AS a 
  LEFT JOIN `jos_categories` AS c 
  ON c.id = a.catid 
  LEFT JOIN `jos_users` AS u 
  ON u.id = a.created_by 
  LEFT JOIN `jos_categories` AS parent 
  ON parent.id = c.parent_id

1 × SELECT `session_id` 
  FROM `jos_session`

1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `jos_contentitem_tag_map` AS m  
  INNER JOIN `jos_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

1 × SELECT * 
  FROM `jos_komento_comments`

1 × SELECT language,id 
  FROM `jos_menu`

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

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

```
1 × SELECT * 
  FROM `jos_extensions`
```

1 × SELECT COUNT(1) 
  FROM `jos_komento_comments`

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

1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,        COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug 
  FROM jos_content AS a 
  LEFT JOIN jos_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN jos_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN jos_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN jos_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN jos_content_rating AS v 
  ON a.id = v.content_id

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `jos_assets`

1 × SELECT * 
  FROM jos_rsfirewall_exceptions

1 × SELECT * 
  FROM jos_rsfirewall_snapshots

1 × SELECT * 
  FROM jos_rsfirewall_hashes

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 jos_menu AS m 
  LEFT JOIN jos_extensions AS e 
  ON m.component_id = e.extension_id

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

```
1 × SELECT * 
  FROM jos_languages
```

1 × SELECT * 
  FROM jos_rsfirewall_configuratio

1 × SELECT `file` 
  FROM jos_rsfirewall_hashes

1 × SELECT `path` 
  FROM jos_rsfirewall_ignored

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

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

1 × SELECT id, rules 
  FROM `jos_viewlevels

```
1 × SELECT * 
  FROM jos_gsd_config
```

ALTRES taules:

1 × INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3263633635303963646238336561316335303130633666616235393035666634', 1, 1738741938, 0, '', 0

1 × SHOW FULL COLUMNS 
  FROM `jos_rsfirewall_logs

1 × SHOW FULL COLUMNS 
  FROM `jos_komento_configs

1 × UPDATE `jos_extensions` 
  SET `params` = '{\"mediaversion\":\"23dcc4de01f59cc015fa3220519876bc\"}'

1 × SHOW FULL COLUMNS 
  FROM `jos_gsd_config

Archives

Què és l'acomiadament objectiu?

Consola de Depuració per Joomla!

Sessió

Informació de perfils

Hora

Memòria

Ús de la memòria

Peticions a la base de dades

44 consultes registrades 5106.55 ms

2 duplicat trobat.

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

Taules SELECCIONADES:

ALTRES taules:

We use cookies to improve our website and your experience when using it. Cookies used for the essential operation of this site have already been set. To find out more about the cookies we use and how to delete them, see our privacy policy.
I accept cookies from this site. Agree