Fets i gent

Llista d'articles en la categoria Fets
Imatge	Títol
	L’església de Santa Maria dels Turers
	La muralla de Banyoles
	L’aeròdrom militar de Martís
	La Casa Consistorial o Casa Ciutat, una obra municipal important
	Guerra i revolució al Pla de l'Estany
	La Guerra del Francès al Pla de l'Estany
	La dictadura franquista al Pla de l’Estany
	La Concòrdia de les Aigües de l’Estany
	La Carta Municipal de Banyoles
	El Monestir de Sant Esteve
	Banyoles subseu olímpica de rem
	Els frares caputxins i el puig de Sant Martirià
	L'arribada dels Servites i la plaça dels Estudis
	L'Era de l'Abat
	Grup Santa Maria dels Turers

Consola de Depuració per Joomla!

Sessió

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

Informació de perfils

Hora

Memòria

Hora: 17.40 ms / 17.40 ms Memòria: 1.529 MB / 1.88 MB Application: afterLoad

Hora: 66.35 ms / 83.75 ms Memòria: 4.186 MB / 6.07 MB Application: afterInitialise

Hora: 9.64 ms / 93.39 ms Memòria: 0.515 MB / 6.58 MB Application: afterRoute

Hora: 5.17 ms / 98.56 ms Memòria: 0.269 MB / 6.85 MB Application: beforeRenderComponent com_content

Hora: 9.54 ms / 108.11 ms Memòria: 0.699 MB / 7.55 MB Application: Before Access::preloadComponents (all components)

Hora: 0.50 ms / 108.61 ms Memòria: 0.064 MB / 7.61 MB Application: After Access::preloadComponents (all components)

Hora: 0.03 ms / 108.64 ms Memòria: 0.000 MB / 7.61 MB Application: Before Access::preloadPermissions (com_content)

Hora: 0.46 ms / 109.10 ms Memòria: 0.167 MB / 7.78 MB Application: After Access::preloadPermissions (com_content)

Hora: 0.02 ms / 109.12 ms Memòria: 0.000 MB / 7.77 MB Application: Before Access::getAssetRules (id:264 name:com_content.category.90)

Hora: 0.75 ms / 109.88 ms Memòria: 0.026 MB / 7.79 MB Application: After Access::getAssetRules (id:264 name:com_content.category.90)

Hora: 5.43 ms / 115.31 ms Memòria: 0.265 MB / 8.06 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Hora: 0.03 ms / 115.34 ms Memòria: 0.002 MB / 8.06 MB Application: After Access::getAssetRules (id:8 name:com_content)

Hora: 142.68 ms / 258.02 ms Memòria: 3.267 MB / 11.32 MB Application: afterRenderComponent com_content

Hora: 5.76 ms / 263.78 ms Memòria: 0.125 MB / 11.45 MB Application: afterDispatch

Hora: 63.75 ms / 327.53 ms Memòria: 1.540 MB / 12.99 MB Application: beforeRenderModule mod_search (Buscar)

Hora: 1.56 ms / 329.09 ms Memòria: 0.039 MB / 13.03 MB Application: afterRenderModule mod_search (Buscar)

Hora: 0.70 ms / 329.78 ms Memòria: 0.000 MB / 13.03 MB Application: beforeRenderModule mod_menu (Off Canvas Menu)

Hora: 116.62 ms / 446.41 ms Memòria: 0.083 MB / 13.11 MB Application: afterRenderModule mod_menu (Off Canvas Menu)

Hora: 2.01 ms / 448.42 ms Memòria: 0.000 MB / 13.10 MB Application: beforeRenderModule mod_languages (Idioma)

Hora: 4.63 ms / 453.04 ms Memòria: 0.045 MB / 13.15 MB Application: afterRenderModule mod_languages (Idioma)

Hora: 2.43 ms / 455.47 ms Memòria: 0.143 MB / 13.29 MB Application: afterRender

Total de peticions a la base de dades: 58.32 ms

Ús de la memòria

Peticions a la base de dades

97 consultes registrades 58.32 ms

10 duplicat trobat.

10 duplicats: #35 #42 #49 #56 #62 #69 #75 #81 #87 #93

Temps de petició: 0.49 ms Petició de memòria: 0.007 MB Memòria abans de la petició: 3.392 MB Cel·les retornades: 0

SELECT `data`

  FROM `chdg4_session`

  WHERE `session_id` = 'dc8e973df6f322acde3c4b656ded9218'

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	chdg4_session	const	PRIMARY	PRIMARY	766	const	1	100.00

Perfil

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.06 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.02 ms
freeing items	0.03 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.11 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Igual que la crida de la línia de sota.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:755
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
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:343
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

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

SELECT `session_id`

  FROM `chdg4_session`

  WHERE `session_id` = 'dc8e973df6f322acde3c4b656ded9218' 
  LIMIT 1

Explicació

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

Perfil

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.08 ms
init	0.01 ms
checking query cache for query	0.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
Waiting for query cache lock	0.03 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.02 ms
freeing items	0.03 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Pila de crides

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

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

Temps de petició: 0.49 ms Després de la darrera petició: 0.07 ms Petició de memòria: 0.004 MB Memòria abans de la petició: 3.500 MB

INSERT INTO `chdg4_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('dc8e973df6f322acde3c4b656ded9218', 1, '1580308991', 0, '', 0)

Explicació

EXPLICACIÓ no possible a la petició: INSERT INTO `chdg4_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('dc8e973df6f322acde3c4b656ded9218', 1, '1580308991', 0, '', 0)

Perfil

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
init	0.01 ms
update	0.06 ms
Waiting for query cache lock	0.00 ms
update	0.02 ms
end	0.00 ms
query end	0.21 ms
closing tables	0.00 ms
Unlocking tables	0.02 ms
freeing items	0.03 ms
updating status	0.01 ms
cleaning up	0.00 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:152
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:757
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
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:343
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Temps de petició: 0.14 ms Després de la darrera petició: 9.14 ms Petició de memòria: 0.005 MB Memòria abans de la petició: 4.074 MB Cel·les retornades: 5

SELECT id, rules

  FROM `chdg4_viewlevels`

Explicació

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

Perfil

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
updating status	0.00 ms
cleaning up	0.00 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
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:310
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:606
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:195
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.08 ms Després de la darrera petició: 0.10 ms Petició de memòria: 0.005 MB Memòria abans de la petició: 4.086 MB Cel·les retornades: 1

SELECT b.id

  FROM chdg4_usergroups AS a

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

  WHERE a.id = 1

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1	100.00
1	SIMPLE	b	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	9	22.22	Using where; Using index

Perfil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.03 ms
updating status	0.00 ms
cleaning up	0.00 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
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:310
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:606
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:195
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ó: 40.88 ms Petició de memòria: 0.005 MB Memòria abans de la petició: 6.599 MB

UPDATE `chdg4_extensions`

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

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

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	chdg4_extensions	range	element_clientid,element_folder_clientid,extension	extension	484	NULL	1	100.00	Using where

Perfil

Status	Duration
starting	0.21 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.12 ms
updating	0.08 ms
end	0.01 ms
Waiting for query cache lock	0.01 ms
end	0.03 ms
query end	0.19 ms
closing tables	0.01 ms
Unlocking tables	0.04 ms
freeing items	0.04 ms
updating status	0.01 ms
cleaning up	0.01 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1113
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
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:195
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.22 ms Després de la darrera petició: 13.27 ms Petició de memòria: 0.010 MB Memòria abans de la petició: 7.553 MB Cel·les retornades: 39

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

  FROM `chdg4_assets`

  WHERE `name` IN ('root.1','com_admin','com_advportfoliopro','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osgallery','com_phocafavicon','com_plugins','com_postinstall','com_redirect','com_search','com_sitemapgenerator','com_sppagebuilder','com_tags','com_templates','com_uniterevolution2','com_users','com_wrapper')

Explicació

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

Perfil

Status	Duration
starting	0.08 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.05 ms
updating status	0.01 ms
cleaning up	0.00 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
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/category.php:139
14	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.20 ms Després de la darrera petició: 0.21 ms Petició de memòria: 0.010 MB Memòria abans de la petició: 7.610 MB Cel·les retornades: 132

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

  FROM `chdg4_assets`

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

Explicació

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

Perfil

Status	Duration
starting	0.05 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.06 ms
updating status	0.01 ms
cleaning up	0.00 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
19	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
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/category.php:139
14	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.65 ms Després de la darrera petició: 2.54 ms Petició de memòria: 0.009 MB Memòria abans de la petició: 7.901 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,(
SELECT COUNT(i.`id`)

  FROM `chdg4_content` AS `i`

  WHERE i.`catid` = c.id 
  AND i.state = 1 
  AND (i.language = '*' OR i.language = 'ca-ES')) AS numitems

  FROM `chdg4_categories` AS `s`

  INNER JOIN `chdg4_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.published = 1 
  AND s.id = 90

  ORDER BY c.lft

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Utilitzant ordenació d`arxius
1	PRIMARY	c	range	cat_idx,idx_left_right,idx_language	cat_idx	203	NULL	11	100.00	Using index condition; Using where
2	DEPENDENT SUBQUERY	i	ref	idx_state,idx_catid,idx_language	idx_catid	4	toallasc_f3t51g3n7.c.id	2	100.00	Using index condition; Using where

Perfil

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.20 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.05 ms
init	0.08 ms
optimizing	0.03 ms
statistics	0.16 ms
preparing	0.01 ms
Unlocking tables	0.03 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.03 ms
executing	0.01 ms
Sorting result	0.12 ms
Sending data	0.07 ms
executing	0.01 ms
Sending data	0.04 ms
executing	0.00 ms
Sending data	0.15 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.04 ms
freeing items	0.00 ms
removing tmp table	0.01 ms
freeing items	0.05 ms
updating status	0.00 ms
Waiting for query cache lock	0.13 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.18 ms
cleaning up	0.01 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:312
16	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
15	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/models/category.php:355
14	ContentModelCategory->getCategory()	JROOT/libraries/src/MVC/View/HtmlView.php:423
13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:122
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de petició: 2.27 ms Després de la darrera petició: 2.33 ms Petició de memòria: 0.009 MB Memòria abans de la petició: 8.056 MB Cel·les retornades: 15

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

  FROM chdg4_content AS a

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

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

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

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

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

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.catid = 90 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-29 14:43:11') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-29 14:43:11') 
  AND a.language IN ('ca-ES','*')

  ORDER BY  c.lft,  a.hits DESC,  a.created   
  LIMIT 15

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	Utilitzant ordenació d`arxius
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid,idx_language	idx_catid	4	const	16	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	toallasc_f3t51g3n7.a.created_by	1	100.00	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	toallasc_f3t51g3n7.a.modified_by	1	100.00	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	100.00	Using where
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	toallasc_f3t51g3n7.a.id	1	100.00	Using where

Perfil

Status	Duration
starting	0.05 ms
Waiting for query cache lock	0.40 ms
init	0.01 ms
checking query cache for query	0.24 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.04 ms
init	0.08 ms
optimizing	0.04 ms
statistics	0.13 ms
preparing	0.01 ms
Unlocking tables	0.04 ms
executing	0.00 ms
Sorting result	0.16 ms
Sending data	0.13 ms
Waiting for query cache lock	0.00 ms
Sending data	0.22 ms
Waiting for query cache lock	0.00 ms
Sending data	0.06 ms
Waiting for query cache lock	0.00 ms
Sending data	0.22 ms
Waiting for query cache lock	0.01 ms
Sending data	0.06 ms
Waiting for query cache lock	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.04 ms
freeing items	0.06 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:559
15	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
14	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:423
13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de petició: 0.77 ms Després de la darrera petició: 2.30 ms Petició de memòria: 0.009 MB Memòria abans de la petició: 8.401 MB Cel·les retornades: 4

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

  FROM `chdg4_contentitem_tag_map` AS m 

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

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

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	5	80.00	Using where
1	SIMPLE	m	ALL	idx_tag_type	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	4	75.00	Using where

Perfil

Status	Duration
starting	0.05 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.10 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.03 ms
freeing items	0.04 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.12 ms
cleaning up	0.01 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
16	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:689
15	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
14	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:423
13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de petició: 1.02 ms Després de la darrera petició: 0.21 ms Petició de memòria: 0.009 MB Memòria abans de la petició: 8.440 MB Cel·les retornades: 0

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

  FROM `chdg4_contentitem_tag_map` AS m 

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

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

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	5	80.00	Using where
1	SIMPLE	m	ALL	idx_tag_type	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	4	75.00	Using where

Perfil

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.06 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.02 ms
freeing items	0.03 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.59 ms
cleaning up	0.01 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
16	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:689
15	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
14	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:423
13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de petició: 0.63 ms Després de la darrera petició: 0.17 ms Petició de memòria: 0.009 MB Memòria abans de la petició: 8.464 MB Cel·les retornades: 0

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

  FROM `chdg4_contentitem_tag_map` AS m 

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

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

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	5	80.00	Using where
1	SIMPLE	m	ALL	idx_tag_type	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	4	75.00	Using where

Perfil

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.02 ms
freeing items	0.04 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.12 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.09 ms
cleaning up	0.01 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
16	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:689
15	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
14	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:423
13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.31 ms Després de la darrera petició: 0.17 ms Petició de memòria: 0.009 MB Memòria abans de la petició: 8.488 MB Cel·les retornades: 0

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

  FROM `chdg4_contentitem_tag_map` AS m 

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

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

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	5	80.00	Using where
1	SIMPLE	m	ALL	idx_tag_type	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	4	75.00	Using where

Perfil

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.83 ms
init	0.01 ms
checking query cache for query	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.03 ms
freeing items	0.04 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.06 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
16	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:689
15	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
14	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:423
13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.51 ms Després de la darrera petició: 0.17 ms Petició de memòria: 0.009 MB Memòria abans de la petició: 8.513 MB Cel·les retornades: 0

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

  FROM `chdg4_contentitem_tag_map` AS m 

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

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

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	5	80.00	Using where
1	SIMPLE	m	ALL	idx_tag_type	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	4	75.00	Using where

Perfil

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.03 ms
freeing items	0.04 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.08 ms
cleaning up	0.00 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
16	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:689
15	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
14	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:423
13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.12 ms Després de la darrera petició: 0.16 ms Petició de memòria: 0.009 MB Memòria abans de la petició: 8.537 MB Cel·les retornades: 0

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

  FROM `chdg4_contentitem_tag_map` AS m 

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

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

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	5	80.00	Using where
1	SIMPLE	m	ALL	idx_tag_type	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	4	75.00	Using where

Perfil

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.05 ms
updating status	0.01 ms
cleaning up	0.00 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
16	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:689
15	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
14	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:423
13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de petició: 0.55 ms Després de la darrera petició: 0.18 ms Petició de memòria: 0.009 MB Memòria abans de la petició: 8.563 MB Cel·les retornades: 0

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

  FROM `chdg4_contentitem_tag_map` AS m 

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

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

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	5	80.00	Using where
1	SIMPLE	m	ALL	idx_tag_type	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	4	75.00	Using where

Perfil

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.06 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.00 ms
Waiting for query cache lock	0.03 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.02 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.02 ms
freeing items	0.05 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.08 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
16	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:689
15	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
14	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:423
13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.49 ms Després de la darrera petició: 0.16 ms Petició de memòria: 0.009 MB Memòria abans de la petició: 8.588 MB Cel·les retornades: 0

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

  FROM `chdg4_contentitem_tag_map` AS m 

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

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

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	5	80.00	Using where
1	SIMPLE	m	ALL	idx_tag_type	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	4	75.00	Using where

Perfil

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.03 ms
init	0.01 ms
checking query cache for query	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.02 ms
freeing items	0.04 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.04 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
16	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:689
15	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
14	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:423
13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.56 ms Després de la darrera petició: 0.16 ms Petició de memòria: 0.009 MB Memòria abans de la petició: 8.612 MB Cel·les retornades: 0

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

  FROM `chdg4_contentitem_tag_map` AS m 

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

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

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	5	80.00	Using where
1	SIMPLE	m	ALL	idx_tag_type	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	4	75.00	Using where

Perfil

Status	Duration
starting	0.05 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.03 ms
freeing items	0.03 ms
updating status	0.00 ms
Waiting for query cache lock	0.03 ms
updating status	0.02 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.10 ms
cleaning up	0.00 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
16	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:689
15	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
14	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:423
13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de petició: 0.61 ms Després de la darrera petició: 0.16 ms Petició de memòria: 0.009 MB Memòria abans de la petició: 8.636 MB Cel·les retornades: 0

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

  FROM `chdg4_contentitem_tag_map` AS m 

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

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

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	5	80.00	Using where
1	SIMPLE	m	ALL	idx_tag_type	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	4	75.00	Using where

Perfil

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.03 ms
init	0.00 ms
checking query cache for query	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.03 ms
freeing items	0.04 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.15 ms
Waiting for query cache lock	0.32 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
16	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:689
15	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
14	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:423
13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.62 ms Després de la darrera petició: 0.16 ms Petició de memòria: 0.009 MB Memòria abans de la petició: 8.661 MB Cel·les retornades: 0

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

  FROM `chdg4_contentitem_tag_map` AS m 

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

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

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	5	80.00	Using where
1	SIMPLE	m	ALL	idx_tag_type	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	4	75.00	Using where

Perfil

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
optimizing	0.03 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.02 ms
freeing items	0.03 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.06 ms
cleaning up	0.00 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
16	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:689
15	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
14	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:423
13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.60 ms Després de la darrera petició: 0.17 ms Petició de memòria: 0.009 MB Memòria abans de la petició: 8.685 MB Cel·les retornades: 0

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

  FROM `chdg4_contentitem_tag_map` AS m 

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

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

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	5	80.00	Using where
1	SIMPLE	m	ALL	idx_tag_type	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	4	75.00	Using where

Perfil

Status	Duration
starting	0.07 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Waiting for query cache lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.02 ms
freeing items	0.04 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.04 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.09 ms
cleaning up	0.01 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
16	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:689
15	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
14	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:423
13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.42 ms Després de la darrera petició: 0.18 ms Petició de memòria: 0.009 MB Memòria abans de la petició: 8.709 MB Cel·les retornades: 0

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

  FROM `chdg4_contentitem_tag_map` AS m 

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

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

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	5	80.00	Using where
1	SIMPLE	m	ALL	idx_tag_type	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	4	75.00	Using where

Perfil

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.02 ms
freeing items	0.03 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.02 ms
cleaning up	0.00 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
16	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:689
15	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
14	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:423
13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.49 ms Després de la darrera petició: 0.16 ms Petició de memòria: 0.009 MB Memòria abans de la petició: 8.733 MB Cel·les retornades: 0

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

  FROM `chdg4_contentitem_tag_map` AS m 

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

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

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	5	80.00	Using where
1	SIMPLE	m	ALL	idx_tag_type	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	4	75.00	Using where

Perfil

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.02 ms
freeing items	0.04 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.09 ms
Waiting for query cache lock	0.02 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
16	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:689
15	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
14	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:423
13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.47 ms Després de la darrera petició: 0.17 ms Petició de memòria: 0.009 MB Memòria abans de la petició: 8.758 MB Cel·les retornades: 0

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

  FROM `chdg4_contentitem_tag_map` AS m 

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

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

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	5	80.00	Using where
1	SIMPLE	m	ALL	idx_tag_type	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	4	75.00	Using where

Perfil

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.02 ms
freeing items	0.03 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.07 ms
cleaning up	0.00 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
16	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:689
15	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
14	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:423
13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de petició: 0.93 ms Després de la darrera petició: 1.57 ms Petició de memòria: 0.009 MB Memòria abans de la petició: 8.851 MB Cel·les retornades: 1

SELECT COUNT(*)

  FROM chdg4_content AS a

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

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

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

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

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

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.catid = 90 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-29 14:43:11') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-29 14:43:11') 
  AND a.language IN ('ca-ES','*')

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid,idx_language	idx_catid	4	const	16	100.00	Using where

Perfil

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.09 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.11 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.00 ms
Sending data	0.11 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.03 ms
freeing items	0.04 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.25 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
18	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:335
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
16	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
15	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/components/com_content/models/category.php:265
14	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:423
13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.50 ms Després de la darrera petició: 0.21 ms Petició de memòria: 0.007 MB Memòria abans de la petició: 8.859 MB Cel·les retornades: 0

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

  FROM `chdg4_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.category' 
  AND `m`.`content_item_id` = 90 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	5	80.00	Using where
1	SIMPLE	m	ALL	idx_tag_type	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	4	75.00	Using where

Perfil

Status	Duration
starting	0.05 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.02 ms
freeing items	0.03 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.09 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
13	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/libraries/src/MVC/View/CategoryView.php:229
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.13 ms Després de la darrera petició: 6.96 ms Petició de memòria: 0.010 MB Memòria abans de la petició: 9.313 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 `chdg4_categories` AS `s`

  INNER JOIN `chdg4_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) 
  AND c.published = 1 
  AND s.id = 90

  ORDER BY c.lft

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Utilitzant ordenació d`arxius
1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right,idx_language	cat_idx	207	NULL	11	100.00	Using index condition; Using where

Perfil

Status	Duration
starting	0.05 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.04 ms
updating status	0.00 ms
cleaning up	0.00 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:312
20	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
19	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:197
18	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
17	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:479
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:108
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.11 ms Després de la darrera petició: 0.13 ms Petició de memòria: 0.009 MB Memòria abans de la petició: 9.331 MB Cel·les retornades: 0

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

  FROM chdg4_fields AS a

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

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

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

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

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

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

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

  ORDER BY a.ordering ASC

Explicació

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

Perfil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.00 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.03 ms
updating status	0.00 ms
cleaning up	0.00 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:479
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:108
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.42 ms Després de la darrera petició: 4.24 ms Petició de memòria: 0.008 MB Memòria abans de la petició: 9.739 MB Cel·les retornades: 1

SELECT params 
  FROM chdg4_os_gallery 
  WHERE id=5

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	chdg4_os_gallery	const	PRIMARY	PRIMARY	4	const	1	100.00

Perfil

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.00 ms
Unlocking tables	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.02 ms
freeing items	0.04 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.05 ms
cleaning up	0.00 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
16	JDatabaseDriver->loadResult()	JROOT/components/com_osgallery/helpers/osGalleryHelperSite.php:157
15	osGalleryHelperSite::displayView()	JROOT/plugins/system/osgallery_system/osgallery_system.php:45
14	plgSystemOsGallery_system->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:108
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.05 ms Després de la darrera petició: 0.08 ms Petició de memòria: 0.008 MB Memòria abans de la petició: 9.754 MB Cel·les retornades: 3

SELECT  gim.* , gc.fk_cat_id, cat.name as cat_name, gal.id as galId 
  FROM chdg4_os_gallery_img as gim 
 
  LEFT JOIN chdg4_os_gallery_connect as gc 
  ON gim.id=gc.fk_gal_img_id
 
  LEFT JOIN chdg4_os_gallery_categories as cat 
  ON cat.id=gc.fk_cat_id 
 
  LEFT JOIN chdg4_os_gallery as gal 
  ON gal.id=cat.fk_gal_id 
 
  WHERE cat.fk_gal_id =5 
  AND gal.published
 
  ORDER BY cat.ordering ASC

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	gal	const	PRIMARY	PRIMARY	4	const	1	100.00	Utilitzant ordenació d`arxius
1	SIMPLE	cat	ref	PRIMARY,fk_gal_id	fk_gal_id	5	const	1	100.00	Using where
1	SIMPLE	gc	ref	fk_cat_id,fk_gal_img_id	fk_cat_id	5	toallasc_f3t51g3n7.cat.id	4	100.00	Using where
1	SIMPLE	gim	eq_ref	PRIMARY	PRIMARY	4	toallasc_f3t51g3n7.gc.fk_gal_img_id	1	100.00

Perfil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.07 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.00 ms
Sorting result	0.07 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.03 ms
freeing items	0.04 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.48 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_osgallery/helpers/osGalleryHelperSite.php:186
15	osGalleryHelperSite::displayView()	JROOT/plugins/system/osgallery_system/osgallery_system.php:45
14	plgSystemOsGallery_system->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:108
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.34 ms Després de la darrera petició: 0.07 ms Petició de memòria: 0.008 MB Memòria abans de la petició: 9.766 MB Cel·les retornades: 1

SELECT DISTINCT id,params 
  FROM chdg4_os_gallery_categories
 
  WHERE fk_gal_id =5

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	chdg4_os_gallery_categories	ref	fk_gal_id	fk_gal_id	5	const	1	100.00

Perfil

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.02 ms
freeing items	0.04 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.05 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_osgallery/helpers/osGalleryHelperSite.php:245
15	osGalleryHelperSite::displayView()	JROOT/plugins/system/osgallery_system/osgallery_system.php:45
14	plgSystemOsGallery_system->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:108
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de petició: 0.75 ms Després de la darrera petició: 0.05 ms Petició de memòria: 0.009 MB Memòria abans de la petició: 9.783 MB Cel·les retornades: 3

SELECT DISTINCT galImg.id,galImg.params 
  FROM chdg4_os_gallery_img as galImg
 
  LEFT JOIN chdg4_os_gallery_connect as galCon 
  ON galCon.fk_gal_img_id = galImg.id
 
  LEFT JOIN chdg4_os_gallery_categories as cat 
  ON cat.id = galCon.fk_cat_id
 
  WHERE cat.fk_gal_id =5

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cat	ref	PRIMARY,fk_gal_id	fk_gal_id	5	const	1	100.00	Using temporary
1	SIMPLE	galCon	ref	fk_cat_id,fk_gal_img_id	fk_cat_id	5	toallasc_f3t51g3n7.cat.id	4	100.00	Using where
1	SIMPLE	galImg	eq_ref	PRIMARY	PRIMARY	4	toallasc_f3t51g3n7.galCon.fk_gal_img_id	1	100.00

Perfil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 ms
Creating tmp table	0.20 ms
Copying to tmp table	0.09 ms
Sending data	0.03 ms
end	0.00 ms
removing tmp table	0.06 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.02 ms
freeing items	0.04 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.07 ms
cleaning up	0.00 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_osgallery/helpers/osGalleryHelperSite.php:253
15	osGalleryHelperSite::displayView()	JROOT/plugins/system/osgallery_system/osgallery_system.php:45
14	plgSystemOsGallery_system->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:108
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de petició: 0.61 ms Després de la darrera petició: 0.64 ms Petició de memòria: 0.009 MB Memòria abans de la petició: 9.856 MB Cel·les retornades: 3

SELECT  gim.* , gal.id as galId 
  FROM `chdg4_os_gallery_img` as gim 
 
  LEFT JOIN chdg4_os_gallery_connect as gc 
  ON gim.id=gc.fk_gal_img_id
 
  LEFT JOIN chdg4_os_gallery_categories as cat 
  ON cat.id=gc.fk_cat_id 
 
  LEFT JOIN chdg4_os_gallery as gal 
  ON gal.id=cat.fk_gal_id 
 
  WHERE cat.fk_gal_id =5 
  AND gal.published
 
  ORDER BY cat.ordering ASC

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	gal	const	PRIMARY	PRIMARY	4	const	1	100.00	Utilitzant ordenació d`arxius
1	SIMPLE	cat	ref	PRIMARY,fk_gal_id	fk_gal_id	5	const	1	100.00	Using where
1	SIMPLE	gc	ref	fk_cat_id,fk_gal_img_id	fk_cat_id	5	toallasc_f3t51g3n7.cat.id	4	100.00	Using where
1	SIMPLE	gim	eq_ref	PRIMARY	PRIMARY	4	toallasc_f3t51g3n7.gc.fk_gal_img_id	1	100.00

Perfil

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.07 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.00 ms
Unlocking tables	0.02 ms
executing	0.00 ms
Sorting result	0.02 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.02 ms
freeing items	0.04 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.26 ms
cleaning up	0.00 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_osgallery/helpers/osGalleryHelperSite.php:396
17	osGalleryHelperSite::getButtonsArray()	JROOT/components/com_osgallery/views/defaultTabs/tmpl/default.php:13
16	require JROOT/components/com_osgallery/views/defaultTabs/tmpl/default.php	JROOT/components/com_osgallery/helpers/osGalleryHelperSite.php:331
15	osGalleryHelperSite::displayView()	JROOT/plugins/system/osgallery_system/osgallery_system.php:45
14	plgSystemOsGallery_system->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:108
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.10 ms Després de la darrera petició: 0.53 ms Petició de memòria: 0.009 MB Memòria abans de la petició: 9.889 MB Cel·les retornades: 0

Peticions duplicades: #42 #49 #56 #62 #69 #75 #81 #87 #93

SELECT  gim.* , gal.id as galId 
  FROM `chdg4_os_gallery_img` as gim 
 
  LEFT JOIN chdg4_os_gallery_connect as gc 
  ON gim.id=gc.fk_gal_img_id
 
  LEFT JOIN chdg4_os_gallery_categories as cat 
  ON cat.id=gc.fk_cat_id 
 
  LEFT JOIN chdg4_os_gallery as gal 
  ON gal.id=cat.fk_gal_id 
 
  WHERE gim.id = 0
 
  ORDER BY cat.ordering ASC

Explicació

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

Perfil

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.07 ms
updating status	0.01 ms
cleaning up	0.00 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
18	JDatabaseDriver->loadAssoc()	JROOT/components/com_osgallery/helpers/osGalleryHelperSite.php:40
17	osGalleryHelperSite::addMetaTags()	JROOT/components/com_osgallery/views/defaultTabs/tmpl/default.php:16
16	require JROOT/components/com_osgallery/views/defaultTabs/tmpl/default.php	JROOT/components/com_osgallery/helpers/osGalleryHelperSite.php:331
15	osGalleryHelperSite::displayView()	JROOT/plugins/system/osgallery_system/osgallery_system.php:45
14	plgSystemOsGallery_system->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:108
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT MAX(contact.id) AS contactid, contact.alias, contact.catid

  FROM `chdg4_contact_details` AS `contact`

  WHERE contact.published = 1 
  AND contact.user_id = 304 
  AND (contact.language in ('ca-ES','*')  OR contact.language IS NULL)

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	contact	ALL	idx_state,idx_language	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	8	87.50	Using where

Perfil

Status	Duration
starting	0.09 ms
Waiting for query cache lock	0.65 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 ms
sending cached result to clien	0.09 ms
updating status	0.01 ms
cleaning up	0.01 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
16	JDatabaseDriver->loadObject()	JROOT/plugins/content/contact/contact.php:108
15	PlgContentContact->getContactId()	JROOT/plugins/content/contact/contact.php:60
14	PlgContentContact->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:108
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.20 ms Després de la darrera petició: 2.31 ms Petició de memòria: 0.008 MB Memòria abans de la petició: 10.355 MB Cel·les retornades: 1

SELECT params 
  FROM chdg4_os_gallery 
  WHERE id=33

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	chdg4_os_gallery	const	PRIMARY	PRIMARY	4	const	1	100.00

Perfil

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.10 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.00 ms
Unlocking tables	0.02 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.04 ms
freeing items	0.04 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.69 ms
Waiting for query cache lock	0.58 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
16	JDatabaseDriver->loadResult()	JROOT/components/com_osgallery/helpers/osGalleryHelperSite.php:157
15	osGalleryHelperSite::displayView()	JROOT/plugins/system/osgallery_system/osgallery_system.php:45
14	plgSystemOsGallery_system->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:108
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.24 ms Després de la darrera petició: 0.08 ms Petició de memòria: 0.008 MB Memòria abans de la petició: 10.370 MB Cel·les retornades: 6

SELECT  gim.* , gc.fk_cat_id, cat.name as cat_name, gal.id as galId 
  FROM chdg4_os_gallery_img as gim 
 
  LEFT JOIN chdg4_os_gallery_connect as gc 
  ON gim.id=gc.fk_gal_img_id
 
  LEFT JOIN chdg4_os_gallery_categories as cat 
  ON cat.id=gc.fk_cat_id 
 
  LEFT JOIN chdg4_os_gallery as gal 
  ON gal.id=cat.fk_gal_id 
 
  WHERE cat.fk_gal_id =33 
  AND gal.published
 
  ORDER BY cat.ordering ASC

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	gal	const	PRIMARY	PRIMARY	4	const	1	100.00	Utilitzant ordenació d`arxius
1	SIMPLE	cat	ref	PRIMARY,fk_gal_id	fk_gal_id	5	const	1	100.00	Using where
1	SIMPLE	gc	ref	fk_cat_id,fk_gal_img_id	fk_cat_id	5	toallasc_f3t51g3n7.cat.id	4	100.00	Using where
1	SIMPLE	gim	eq_ref	PRIMARY	PRIMARY	4	toallasc_f3t51g3n7.gc.fk_gal_img_id	1	100.00

Perfil

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.09 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
Unlocking tables	0.03 ms
executing	0.00 ms
Sorting result	0.04 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.03 ms
freeing items	0.09 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.10 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_osgallery/helpers/osGalleryHelperSite.php:186
15	osGalleryHelperSite::displayView()	JROOT/plugins/system/osgallery_system/osgallery_system.php:45
14	plgSystemOsGallery_system->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:108
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.43 ms Després de la darrera petició: 0.07 ms Petició de memòria: 0.008 MB Memòria abans de la petició: 10.385 MB Cel·les retornades: 1

SELECT DISTINCT id,params 
  FROM chdg4_os_gallery_categories
 
  WHERE fk_gal_id =33

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	chdg4_os_gallery_categories	ref	fk_gal_id	fk_gal_id	5	const	1	100.00

Perfil

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.01 ms
Table lock	0.00 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.03 ms
freeing items	0.03 ms
updating status	0.00 ms
Waiting for query cache lock	0.04 ms
updating status	0.02 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
storing result in query cache	0.05 ms
cleaning up	0.00 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_osgallery/helpers/osGalleryHelperSite.php:245
15	osGalleryHelperSite::displayView()	JROOT/plugins/system/osgallery_system/osgallery_system.php:45
14	plgSystemOsGallery_system->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:108
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.94 ms Després de la darrera petició: 0.05 ms Petició de memòria: 0.008 MB Memòria abans de la petició: 10.394 MB Cel·les retornades: 6

SELECT DISTINCT galImg.id,galImg.params 
  FROM chdg4_os_gallery_img as galImg
 
  LEFT JOIN chdg4_os_gallery_connect as galCon 
  ON galCon.fk_gal_img_id = galImg.id
 
  LEFT JOIN chdg4_os_gallery_categories as cat 
  ON cat.id = galCon.fk_cat_id
 
  WHERE cat.fk_gal_id =33

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cat	ref	PRIMARY,fk_gal_id	fk_gal_id	5	const	1	100.00	Using temporary
1	SIMPLE	galCon	ref	fk_cat_id,fk_gal_img_id	fk_cat_id	5	toallasc_f3t51g3n7.cat.id	4	100.00	Using where
1	SIMPLE	galImg	eq_ref	PRIMARY	PRIMARY	4	toallasc_f3t51g3n7.galCon.fk_gal_img_id	1	100.00

Perfil

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.08 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.00 ms
Creating tmp table	0.24 ms
Copying to tmp table	0.11 ms
Sending data	0.03 ms
end	0.00 ms
removing tmp table	0.06 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.04 ms
freeing items	0.04 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Pila de crides

#	Autor de la crida	Arxiu i nombre de línia
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_osgallery/helpers/osGalleryHelperSite.php:

El projecte

Els promotors

La ubicació

La dinàmica

Buscar

Consola de Depuració per Joomla!

Sessió

Informació de perfils

Hora

Memòria

Ús de la memòria

Peticions a la base de dades

97 consultes registrades 58.32 ms

10 duplicat trobat.