Notes als bits

De les notes als bits

La tecnologia al

servei de la música

L’Escola de So

Com ensenyem

Instal·lacions

Professors

Microfusa

Escola associada

a Microfusa

Un segell de qualitat

i solvència

Certificat Microfusa

Cursos de So

Des del micro, fins a

la taula de so

Curs So Bàsic

Curs So Profess.

Curs So Pro. semip

Produccio

Cursos de producció de música electrònica

Fes-te la teua pròpia

música

Curs PME 1

Curs PME 2

Cursos de Dj

Passa de ser un

“punxadiscos” a ser

un professional

Curs Dj Pro 1

Curs Dj Pro 2

Veure més notícies de so i tecnologia

Màsterclass gratuïta d'Ivan Torrent a L'Intèrpret

El productor Ivan Torrent imparteix una màsterclass sobre la producció musical a L’Intèrpret.

L'artista gironí, que es troba de gira promocional del seu darrer disc, parlarà sobre la creació de bandes sonores, orquestracions o sobre com és la seva relació amb Hollywood.

Ivan Torrent és el creador de música per a tràilers de films com Star Wars, Spiderman, Capità Amèrica o Interstellar. Compartirà de manera pràctica i entenedora la seva col·laboració amb grans produccions de Hollywood i explicarà com és l’ofici de productor musical.

L’acte serà demà dijous dia 26 d’abril a les 20.00 h. a L’Intèrpret i l’entrada és lliure fins a esgotar l’aforament.

Tallers Dj i Producció al Juliol

Ja us podeu inscriure als nous tallers de DJ i Producció de Música Electrònica al juliol!

Amb aquest taller us podreu introduir dins l'entorn de la música com a DJs i com a creadors de música digital.
Adreçat a joves d'entre 12 i 18 anys.

15 hores lectives.

Places limitades.

Preu: 120 €

Vull produir música electrònica.

Treu el màxim rendiment al teu home estudio i aprén a utilitzar les principals eines de la producció musical amb els diferents tallers que et proposem.

• Producció de música electrònica.

Del 3 al 7 de juliol, de 10:00 a 13:00 h

Del 10 al 14 de juliol, de 10:00 a 13:00 h

• Ableton Live.

Del 17 al 21 de juliol, de 10.00 a 13.00 h.

Del 24 al 28 de juliol, de 10.00 a 13.00 h.

• Reason.

Del 17 al 21 de juliol, de 10.00 a 13.00 h.

Del 24 al 28 de juliol, de 10.00 a 13.00 h.

• Edició de partitures amb Finale.

Per determinar

Vull ser DJ!

1r torn: del 3 al 7 de juliol, de 10.00 a 13.00 h.

2n torn: del 10 al 14 de juliol, de 10.00 a 13.00 h.

3r torn: del 17 al 21 de juliol, de 10.00 a 13.00 h.

Curs "VULL SER DJ" a L'Intèrpret

Aquest dissabte comença el curs "Vull ser DJ".

Amb aquest taller us podreu introduir dins l'entorn de la música com a DJs i com a creadors de música digital.
Adreçat a joves d'entre 12 i 18 anys.
Dissabtes 9, 16, 23 i 30 de maig i 6 de juny, de 10:00 a 13:00 h.
Les places són limitades.
Preu: 120 €

Al mes de juliol podreu fer, de manera intensiva, els següents cursos(5 classes de 3 h cadascauna):

Vull produir música electrònica. 1r torn del 6 al 10 de juliol; 2n torn del 13 al 17 de juliol.

Vull ser DJ. 1r torn del 6 al 10 de juliol; 2n torn del 13 al 17 de juliol.

Més articles...

L’Intèrpret ofereix un Taller de màstering els dies 1 i 2 de juny

12 »Final

Inici

Inici
Organigrama
Notícies
Activitats
Calendari

Cursos microfusa
Espectacles
Revista STACATTO
Premsa i mitjans
Enllaços

CONTACTA
AVÍS LEGAL
C/ Sangenís Bertran 11
25003 Lleida
Tel. 973 26 39 06 - 973 83 61 80
l-interpret @ l-interpret .com

Escola de música autoritzada i centre autoritzat de grau professional pel Departament d'Ensenyament de la Generalitat .

Consola de Depuració per Joomla!

Sessió

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1555880487,
                "last": 1555880487,
                "now": 1555880487
            },
            "token": "X2Iea2c2YhfBg0yumrnuomyQ9swA0EcE"
        },
        "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
        }
    }
}

Informació de perfils

Hora

Memòria

Hora: 15.15 ms / 15.15 ms Memòria: 1.666 MB / 2.00 MB Application: afterLoad

Hora: 75.94 ms / 91.09 ms Memòria: 5.902 MB / 7.90 MB Application: afterInitialise

Hora: 15.65 ms / 106.74 ms Memòria: 1.008 MB / 8.91 MB Application: afterRoute

Hora: 0.78 ms / 107.52 ms Memòria: 0.031 MB / 8.94 MB Application: beforeRenderComponent com_content

Hora: 5.20 ms / 112.73 ms Memòria: 0.504 MB / 9.45 MB Application: Before Access::preloadComponents (all components)

Hora: 1.03 ms / 113.75 ms Memòria: 0.064 MB / 9.51 MB Application: After Access::preloadComponents (all components)

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

Hora: 1.44 ms / 115.22 ms Memòria: 0.408 MB / 9.92 MB Application: After Access::preloadPermissions (com_content)

Hora: 0.04 ms / 115.25 ms Memòria: 0.000 MB / 9.90 MB Application: Before Access::getAssetRules (id:343 name:com_content.category.193)

Hora: 0.76 ms / 116.01 ms Memòria: 0.027 MB / 9.92 MB Application: After Access::getAssetRules (id:343 name:com_content.category.193)

Hora: 4.15 ms / 120.16 ms Memòria: 0.224 MB / 10.15 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Hora: 0.05 ms / 120.22 ms Memòria: 0.007 MB / 10.15 MB Application: After Access::getAssetRules (id:8 name:com_content)

Hora: 74.80 ms / 195.02 ms Memòria: 2.776 MB / 12.93 MB Application: afterRenderComponent com_content

Hora: 2.72 ms / 197.73 ms Memòria: 0.107 MB / 13.04 MB Application: afterDispatch

Hora: 18.24 ms / 215.97 ms Memòria: 0.380 MB / 13.42 MB Application: beforeRenderModule mod_custom (Submenu So i Tecnologia)

Hora: 2.51 ms / 218.48 ms Memòria: 0.051 MB / 13.47 MB Application: afterRenderModule mod_custom (Submenu So i Tecnologia)

Hora: 0.84 ms / 219.33 ms Memòria: 0.000 MB / 13.47 MB Application: beforeRenderModule mod_custom (L’Escola de So - MENU 1)

Hora: 0.76 ms / 220.09 ms Memòria: 0.004 MB / 13.47 MB Application: afterRenderModule mod_custom (L’Escola de So - MENU 1)

Hora: 0.14 ms / 220.23 ms Memòria: 0.001 MB / 13.47 MB Application: beforeRenderModule mod_custom (L’Escola de So - MENU 2)

Hora: 0.74 ms / 220.97 ms Memòria: 0.003 MB / 13.48 MB Application: afterRenderModule mod_custom (L’Escola de So - MENU 2)

Hora: 0.15 ms / 221.12 ms Memòria: 0.001 MB / 13.48 MB Application: beforeRenderModule mod_custom (L’Escola de So - MENU 3)

Hora: 0.74 ms / 221.86 ms Memòria: 0.003 MB / 13.48 MB Application: afterRenderModule mod_custom (L’Escola de So - MENU 3)

Hora: 0.14 ms / 222.01 ms Memòria: 0.001 MB / 13.48 MB Application: beforeRenderModule mod_custom (L’Escola de So - MENU 4)

Hora: 0.74 ms / 222.74 ms Memòria: 0.003 MB / 13.48 MB Application: afterRenderModule mod_custom (L’Escola de So - MENU 4)

Hora: 0.14 ms / 222.89 ms Memòria: 0.001 MB / 13.48 MB Application: beforeRenderModule mod_custom (L’Escola de So - MENU 5)

Hora: 0.74 ms / 223.63 ms Memòria: 0.003 MB / 13.49 MB Application: afterRenderModule mod_custom (L’Escola de So - MENU 5)

Hora: 3.23 ms / 226.85 ms Memòria: 0.000 MB / 13.49 MB Application: beforeRenderModule mod_custom (Notícies So i Tecnologia)

Hora: 0.81 ms / 227.67 ms Memòria: 0.002 MB / 13.49 MB Application: afterRenderModule mod_custom (Notícies So i Tecnologia)

Hora: 2.62 ms / 230.29 ms Memòria: 0.004 MB / 13.49 MB Application: beforeRenderModule mod_custom (Faldon Nuevo (2))

Hora: 0.43 ms / 230.72 ms Memòria: 0.003 MB / 13.50 MB Application: afterRenderModule mod_custom (Faldon Nuevo (2))

Hora: 9.47 ms / 240.20 ms Memòria: 0.277 MB / 13.77 MB Application: afterRender

Total de peticions a la base de dades: 22.96 ms

Ús de la memòria

Peticions a la base de dades

34 consultes registrades 22.96 ms

2 duplicat trobat.

2 duplicats: #11 #12

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

SELECT `data`

  FROM `jos_session`

  WHERE `session_id` = 'l3ohchc5266e0a62b7esqsbe22'

Explicació

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

Perfil

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.04 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.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1734
15	JDatabaseDriver->loadResult()	JROOT\libraries\joomla\session\storage\database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
13	session_start()	JROOT\libraries\joomla\session\handler\native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT\libraries\joomla\session\handler\native.php:50
11	JSessionHandlerNative->start()	JROOT\libraries\joomla\session\handler\joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT\libraries\src\Session\Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT\libraries\src\Session\Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT\libraries\src\Session\Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT\libraries\src\Session\Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT\libraries\src\Application\CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT\libraries\src\Application\CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT\libraries\src\Application\SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT\libraries\src\Application\CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT\libraries\src\Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT\index.php:46

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

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

SELECT `session_id`

  FROM `jos_session`

  WHERE `session_id` = 'l3ohchc5266e0a62b7esqsbe22' 
  LIMIT 1

Explicació

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

Perfil

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.00 ms
updating status	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1734
8	JDatabaseDriver->loadResult()	JROOT\libraries\src\Session\MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT\libraries\src\Application\CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT\libraries\src\Application\CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT\libraries\src\Application\CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT\libraries\src\Application\SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT\libraries\src\Application\CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT\libraries\src\Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT\index.php:46

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

Temps de petició: 0.90 ms Després de la darrera petició: 0.09 ms Petició de memòria: 0.004 MB Memòria abans de la petició: 3.714 MB

INSERT INTO `jos_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('l3ohchc5266e0a62b7esqsbe22', 1, 1555880487, 0, '', 0)

Explicació

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

Perfil

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
init	0.01 ms
update	0.05 ms
end	0.00 ms
query end	0.72 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.00 ms
updating status	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT\libraries\src\Session\MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT\libraries\src\Application\CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT\libraries\src\Application\CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT\libraries\src\Application\CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT\libraries\src\Application\SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT\libraries\src\Application\CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT\libraries\src\Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT\index.php:46

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

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

SELECT id, rules

  FROM `jos_viewlevels`

Explicació

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

Perfil

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1500
9	JDatabaseDriver->loadAssocList()	JROOT\libraries\src\Access\Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT\libraries\src\User\User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT\libraries\src\Plugin\PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT\libraries\src\Plugin\PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT\libraries\src\Plugin\PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT\libraries\src\Application\SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Temps de petició: 0.24 ms Després de la darrera petició: 0.09 ms Petició de memòria: 0.022 MB Memòria abans de la petició: 4.193 MB Cel·les retornades: 1

SELECT b.id

  FROM jos_usergroups AS a

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

  WHERE a.id = 1

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	1	Using where; Using index

Perfil

Status	Duration
starting	0.03 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
init	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.00 ms
Unlocking tables	0.02 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.00 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1544
10	JDatabaseDriver->loadColumn()	JROOT\libraries\src\Access\Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT\libraries\src\Access\Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT\libraries\src\User\User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT\libraries\src\Plugin\PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT\libraries\src\Plugin\PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT\libraries\src\Plugin\PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT\libraries\src\Application\SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

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

SELECT *

  FROM `jos_admintools_wafexceptions`

  WHERE NOT(`option` LIKE 'com_%')

Explicació

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

Perfil

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1500
10	JDatabaseDriver->loadAssocList()	JROOT\plugins\system\admintools\admintools\main.php:526
9	plgSystemAdmintools->loadWAFExceptionsSEF()	JROOT\plugins\system\admintools\admintools\main.php:447
8	plgSystemAdmintools->loadWAFExceptions()	JROOT\plugins\system\admintools\admintools\main.php:90
7	plgSystemAdmintools->__construct()	JROOT\libraries\src\Plugin\PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT\libraries\src\Plugin\PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT\libraries\src\Application\CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

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

SELECT `value`

  FROM `jos_admintools_storage`

  WHERE `key` = 'cparams'

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_admintools_storage	const	PRIMARY	PRIMARY	402	const	1

Perfil

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1734
12	JDatabaseDriver->loadResult()	JROOT\administrator\components\com_admintools\models\storage.php:99
11	AdmintoolsModelStorage->load()	JROOT\administrator\components\com_admintools\models\storage.php:49
10	AdmintoolsModelStorage->getValue()	JROOT\plugins\system\admintools\feature\httpsizer.php:26
9	AtsystemFeatureHttpsizer->isEnabled()	JROOT\plugins\system\admintools\admintools\main.php:356
8	plgSystemAdmintools->loadFeatures()	JROOT\plugins\system\admintools\admintools\main.php:93
7	plgSystemAdmintools->__construct()	JROOT\libraries\src\Plugin\PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT\libraries\src\Plugin\PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT\libraries\src\Application\CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Temps de petició: 0.59 ms Després de la darrera petició: 14.80 ms Petició de memòria: 0.022 MB Memòria abans de la petició: 7.205 MB Cel·les retornades: 1

SELECT `enabled`

  FROM `jos_extensions`

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

Explicació

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

Perfil

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

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1734
8	JDatabaseDriver->loadResult()	JROOT\plugins\system\backuponupdate\backuponupdate.php:36
7	require_once JROOT\plugins\system\backuponupdate\backuponupdate.php	JROOT\libraries\src\Plugin\PluginHelper.php:253
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT\libraries\src\Plugin\PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT\libraries\src\Application\CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Temps de petició: 0.63 ms Després de la darrera petició: 14.87 ms Petició de memòria: 0.024 MB Memòria abans de la petició: 7.602 MB Cel·les retornades: 1

SHOW VARIABLES LIKE "collation_database"

Explicació

EXPLICACIÓ no possible a la petició: SHOW VARIABLES LIKE "collation_database"

Perfil

Status	Duration
starting	0.03 ms
Opening tables	0.03 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Filling schema table	0.39 ms
executing	0.01 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
freeing items	0.00 ms
updating status	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1656
12	JDatabaseDriver->loadObject()	JROOT\libraries\joomla\database\driver\mysqli.php:342
11	JDatabaseDriverMysqli->getCollation()	JROOT\plugins\system\admintools\feature\utf8mb4.php:28
10	AtsystemFeatureUtf8mb4->onAfterInitialise()	JROOT\plugins\system\admintools\admintools\main.php:685
9	plgSystemAdmintools->runFeature()	JROOT\plugins\system\admintools\admintools\main.php:118
8	plgSystemAdmintools->onAfterInitialise()	JROOT\libraries\joomla\event\event.php:70
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Temps de petició: 0.18 ms Després de la darrera petició: 0.10 ms Petició de memòria: 0.004 MB Memòria abans de la petició: 7.609 MB

DELETE 
  FROM `jos_mi_iptable` 
  WHERE DATE_ADD(`lasthacktime`, INTERVAL 600 SECOND) < NOW() 
  AND `autodelete`=1;

Explicació

EXPLICACIÓ no possible a la petició: DELETE FROM `jos_mi_iptable` WHERE DATE_ADD(`lasthacktime`, INTERVAL 600 SECOND) < NOW() AND `autodelete`=1;

Perfil

Status	Duration
starting	0.03 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
init	0.03 ms
updating	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.00 ms
updating status	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT\plugins\system\marcosinterceptor\marcosinterceptor.php:53
8	plgSystemMarcosinterceptor->onAfterInitialise()	JROOT\libraries\joomla\event\event.php:70
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Temps de petició: 0.17 ms Després de la darrera petició: 0.05 ms Petició de memòria: 0.022 MB Memòria abans de la petició: 7.614 MB Cel·les retornades: 1

Peticions duplicades: #12

SELECT COUNT(*) 
  from `jos_mi_iptable` 
  WHERE ip = '3.88.161.108' 
  AND `hackcount` >= 2

Explicació

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

Perfil

Status	Duration
starting	0.03 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
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.00 ms
freeing items	0.00 ms
updating status	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT\plugins\system\marcosinterceptor\marcosinterceptor.php:61
8	plgSystemMarcosinterceptor->onAfterInitialise()	JROOT\libraries\joomla\event\event.php:70
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Temps de petició: 0.16 ms Després de la darrera petició: 0.05 ms Petició de memòria: 0.022 MB Memòria abans de la petició: 7.618 MB Cel·les retornades: 1

Peticions duplicades: #11

SELECT COUNT(*) 
  from `jos_mi_iptable` 
  WHERE ip = '3.88.161.108' 
  AND `hackcount` >= 2

Explicació

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

Perfil

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
freeing items	0.00 ms
updating status	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1734
9	JDatabaseDriver->loadResult()	JROOT\plugins\system\marcosinterceptor\marcosinterceptor.php:65
8	plgSystemMarcosinterceptor->onAfterInitialise()	JROOT\libraries\joomla\event\event.php:70
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Temps de petició: 1.30 ms Després de la darrera petició: 16.35 ms Petició de memòria: 0.006 MB Memòria abans de la petició: 8.746 MB

UPDATE `jos_extensions`

  SET `params` = '{\"mediaversion\":\"031da88806bde95bff107b8f84ecb7cb\"}'

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

Explicació

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

Perfil

Status	Duration
starting	0.04 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
init	0.07 ms
updating	0.07 ms
end	0.01 ms
query end	0.99 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.00 ms
updating status	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT\libraries\src\Helper\LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT\libraries\src\Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT\libraries\src\Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT\libraries\src\Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT\libraries\src\Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT\plugins\system\kc_cufon\kc_cufon.php:54
8	plgSystemkc_cufon->onAfterRoute()	JROOT\libraries\joomla\event\event.php:70
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT\libraries\src\Application\SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT\libraries\src\Application\SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Temps de petició: 0.81 ms Després de la darrera petició: 7.80 ms Petició de memòria: 0.032 MB Memòria abans de la petició: 9.453 MB Cel·les retornades: 43

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

  FROM `jos_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_admintools','com_aicontactsafe','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_dpcalendar','com_extplorer','com_favicon','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_widgetkit','com_wrapper')

Explicació

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

Perfil

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1695
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:440
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:75
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:118
8	ContentController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_content\content.php:43
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Temps de petició: 0.87 ms Després de la darrera petició: 0.19 ms Petició de memòria: 0.109 MB Memòria abans de la petició: 9.508 MB Cel·les retornades: 476

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

  FROM `jos_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	Extra
1	SIMPLE	jos_assets	ALL	idx_asset_name,idx_parent_id	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	622	Using where

Perfil

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1695
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:440
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:75
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:118
8	ContentController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_content\content.php:43
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Temps de petició: 1.21 ms Després de la darrera petició: 2.65 ms Petició de memòria: 0.038 MB Memòria abans de la petició: 9.978 MB Cel·les retornades: 3

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 `jos_content` AS `i`

  WHERE i.`catid` = c.id 
  AND i.state = 1) AS numitems

  FROM `jos_categories` AS `s`

  INNER JOIN `jos_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) 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 = 193

  ORDER BY c.lft

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	PRIMARY	c	ALL	cat_idx,idx_left_right	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	217	Using where; Utilitzant ordenació d`arxius
2	DEPENDENT SUBQUERY	i	ref	idx_state,idx_catid	idx_catid	4	interpret.c.id	1	Using index condition; Using where

Perfil

Status	Duration
starting	0.14 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.01 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.26 ms
executing	0.00 ms
Sending data	0.03 ms
executing	0.00 ms
Sending data	0.22 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.00 ms
removing tmp table	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Categories\Categories.php:324
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:425
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:75
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:118
8	ContentController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_content\content.php:43
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Temps de petició: 3.93 ms Després de la darrera petició: 1.72 ms Petició de memòria: 0.049 MB Memòria abans de la petició: 10.153 MB Cel·les retornades: 4

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 jos_content AS a

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

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

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

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

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

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.catid = 193 OR a.catid IN (
SELECT sub.id

  FROM jos_categories as sub

  INNER JOIN jos_categories as this 
  ON sub.lft > this.lft 
  AND sub.rgt < this.rgt

  WHERE this.id = 193)) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-04-21 21:01:27') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-04-21 21:01:27')

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

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	ref	idx_access,idx_state,idx_catid	idx_state	1	const	214	Using where; Using temporary; Utilitzant ordenació d`arxius
1	PRIMARY	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	interpret.a.catid	1	Using where
1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	interpret.a.created_by	1	Using where
1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	interpret.a.modified_by	1	Using where
1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	interpret.c.parent_id	1	Using where
1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	interpret.a.id	1	Using where
2	MATERIALIZED	this	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
2	MATERIALIZED	sub	range	PRIMARY,idx_left_right	idx_left_right	4	NULL	6	Using where; Using index

Perfil

Status	Duration
starting	0.20 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
checking permissions	0.00 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
init	0.07 ms
optimizing	0.03 ms
statistics	0.06 ms
preparing	0.03 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.03 ms
Creating tmp table	0.05 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.05 ms
executing	0.00 ms
Sending data	2.45 ms
Creating sort index	0.12 ms
removing tmp table	0.57 ms
Creating sort index	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
removing tmp table	0.01 ms
freeing items	0.01 ms
removing tmp table	0.00 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1695
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:576
15	ContentModelArticles->getItems()	JROOT\components\com_content\models\category.php:253
14	ContentModelCategory->getItems()	JROOT\libraries\src\MVC\View\HtmlView.php:425
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:75
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:118
8	ContentController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_content\content.php:43
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

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

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

  FROM `jos_contentitem_tag_map` AS m 

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

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

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	7	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	interpret.m.tag_id	1	Using where

Perfil

Status	Duration
starting	0.04 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
init	0.02 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Helper\TagsHelper.php:454
16	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT\components\com_content\models\articles.php:706
15	ContentModelArticles->getItems()	JROOT\components\com_content\models\category.php:253
14	ContentModelCategory->getItems()	JROOT\libraries\src\MVC\View\HtmlView.php:425
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:75
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:118
8	ContentController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_content\content.php:43
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

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

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

  FROM `jos_contentitem_tag_map` AS m 

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

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

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	7	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	interpret.m.tag_id	1	Using where

Perfil

Status	Duration
starting	0.03 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
init	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Helper\TagsHelper.php:454
16	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT\components\com_content\models\articles.php:706
15	ContentModelArticles->getItems()	JROOT\components\com_content\models\category.php:253
14	ContentModelCategory->getItems()	JROOT\libraries\src\MVC\View\HtmlView.php:425
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:75
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:118
8	ContentController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_content\content.php:43
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

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

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

  FROM `jos_contentitem_tag_map` AS m 

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

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

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	7	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	interpret.m.tag_id	1	Using where

Perfil

Status	Duration
starting	0.03 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
init	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Helper\TagsHelper.php:454
16	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT\components\com_content\models\articles.php:706
15	ContentModelArticles->getItems()	JROOT\components\com_content\models\category.php:253
14	ContentModelCategory->getItems()	JROOT\libraries\src\MVC\View\HtmlView.php:425
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:75
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:118
8	ContentController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_content\content.php:43
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

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

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

  FROM `jos_contentitem_tag_map` AS m 

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

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

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	7	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	interpret.m.tag_id	1	Using where

Perfil

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Helper\TagsHelper.php:454
16	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT\components\com_content\models\articles.php:706
15	ContentModelArticles->getItems()	JROOT\components\com_content\models\category.php:253
14	ContentModelCategory->getItems()	JROOT\libraries\src\MVC\View\HtmlView.php:425
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:75
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:118
8	ContentController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_content\content.php:43
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Temps de petició: 0.96 ms Després de la darrera petició: 1.13 ms Petició de memòria: 0.026 MB Memòria abans de la petició: 10.590 MB Cel·les retornades: 1

SELECT COUNT(*)

  FROM jos_content AS a

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

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

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

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

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

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.catid = 193 OR a.catid IN (
SELECT sub.id

  FROM jos_categories as sub

  INNER JOIN jos_categories as this 
  ON sub.lft > this.lft 
  AND sub.rgt < this.rgt

  WHERE this.id = 193)) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-04-21 21:01:27') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-04-21 21:01:27')

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	ref	idx_access,idx_state,idx_catid	idx_state	1	const	214	Using where
1	PRIMARY	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	interpret.a.catid	1	Using where
2	MATERIALIZED	this	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
2	MATERIALIZED	sub	range	PRIMARY,idx_left_right	idx_left_right	4	NULL	6	Using where; Using index

Perfil

Status	Duration
starting	0.08 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
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.04 ms
executing	0.00 ms
Sending data	0.44 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.00 ms
removing tmp table	0.01 ms
freeing items	0.01 ms
removing tmp table	0.00 ms
freeing items	0.00 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1734
18	JDatabaseDriver->loadResult()	JROOT\libraries\src\MVC\Model\BaseDatabaseModel.php:340
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:425
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:75
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:118
8	ContentController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_content\content.php:43
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

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

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

  FROM `jos_contentitem_tag_map` AS m 

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

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

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	7	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	interpret.m.tag_id	1	Using where

Perfil

Status	Duration
starting	0.03 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
init	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1695
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:75
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:118
8	ContentController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_content\content.php:43
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Temps de petició: 0.62 ms Després de la darrera petició: 5.76 ms Petició de memòria: 0.039 MB Memòria abans de la petició: 11.111 MB Cel·les retornades: 3

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

  FROM `jos_categories` AS `s`

  INNER JOIN `jos_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) 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 = 193

  ORDER BY c.lft

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	217	Using where; Utilitzant ordenació d`arxius

Perfil

Status	Duration
starting	0.10 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
init	0.03 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.00 ms
Unlocking tables	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.25 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1695
21	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Categories\Categories.php:324
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:203
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:135
15	FieldsHelper::getFields()	JROOT\plugins\system\fields\fields.php:488
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:113
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:118
8	ContentController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_content\content.php:43
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Temps de petició: 0.45 ms Després de la darrera petició: 0.15 ms Petició de memòria: 0.037 MB Memòria abans de la petició: 11.134 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, g.note as group_note

  FROM jos_fields AS a

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

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

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

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

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

  LEFT JOIN `jos_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 (193,0,189)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explicació

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

Perfil

Status	Duration
starting	0.11 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
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1695
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:333
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:135
15	FieldsHelper::getFields()	JROOT\plugins\system\fields\fields.php:488
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:113
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:118
8	ContentController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_content\content.php:43
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Temps de petició: 0.23 ms Després de la darrera petició: 6.10 ms Petició de memòria: 0.028 MB Memòria abans de la petició: 11.578 MB Cel·les retornades: 1

SELECT params 
  FROM jos_extensions AS e 
  WHERE e.element='com_widgetkit'

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	402	const	1	Using index condition

Perfil

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1734
21	JDatabaseDriver->loadResult()	JROOT\administrator\components\com_widgetkit\helpers\system.php:278
20	SystemWidgetkitHelper->_getParams()	JROOT\administrator\components\com_widgetkit\helpers\system.php:54
19	SystemWidgetkitHelper->__construct()	JROOT\administrator\components\com_widgetkit\classes\widgetkit.php:129
18	Widgetkit->loadHelper()	JROOT\administrator\components\com_widgetkit\classes\widgetkit.php:76
17	Widgetkit->getHelper()	JROOT\administrator\components\com_widgetkit\classes\widgetkit.php:137
16	Widgetkit->offsetGet()	JROOT\administrator\components\com_widgetkit\widgetkit.php:17
15	require_once JROOT\administrator\components\com_widgetkit\widgetkit.php	JROOT\plugins\content\widgetkit_content\widgetkit_content.php:23
14	plgContentWidgetkit_Content->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:113
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:118
8	ContentController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_content\content.php:43
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

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

SELECT id,template 
  FROM jos_template_styles 
  WHERE client_id=0 
  AND home=1

Explicació

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

Perfil

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1656
17	JDatabaseDriver->loadObject()	JROOT\administrator\components\com_widgetkit\helpers\system.php:78
16	SystemWidgetkitHelper->init()	JROOT\administrator\components\com_widgetkit\widgetkit.php:17
15	require_once JROOT\administrator\components\com_widgetkit\widgetkit.php	JROOT\plugins\content\widgetkit_content\widgetkit_content.php:23
14	plgContentWidgetkit_Content->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:113
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:118
8	ContentController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_content\content.php:43
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Temps de petició: 0.27 ms Després de la darrera petició: 23.50 ms Petició de memòria: 0.028 MB Memòria abans de la petició: 12.324 MB Cel·les retornades: 1

SELECT * 
  FROM jos_widgetkit_widget 
  WHERE id=60

Explicació

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

Perfil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.00 ms
Unlocking tables	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.01 ms
freeing items	0.00 ms
updating status	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1656
17	JDatabaseDriver->loadObject()	JROOT\administrator\components\com_widgetkit\helpers\widget.php:42
16	WidgetWidgetkitHelper->get()	JROOT\administrator\components\com_widgetkit\helpers\widget.php:160
15	WidgetWidgetkitHelper->render()	JROOT\plugins\content\widgetkit_content\widgetkit_content.php:30
14	plgContentWidgetkit_Content->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:113
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:118
8	ContentController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_content\content.php:43
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Temps de petició: 2.35 ms Després de la darrera petició: 8.94 ms Petició de memòria: 0.040 MB Memòria abans de la petició: 12.425 MB Cel·les retornades: 31

SHOW FULL COLUMNS 
  FROM `jos_content`

Explicació

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

Perfil

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
closing tables	0.00 ms
Opening tables	1.18 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
init	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
checking permissions	0.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
closing tables	0.01 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.69 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
freeing items	0.00 ms
updating status	0.04 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1695
25	JDatabaseDriver->loadObjectList()	JROOT\libraries\joomla\database\driver\mysqli.php:445
24	JDatabaseDriverMysqli->getTableColumns()	JROOT\libraries\src\Table\Table.php:245
23	Joomla\CMS\Table\Table->getFields()	JROOT\libraries\src\Table\Table.php:164
22	Joomla\CMS\Table\Table->__construct()	JROOT\libraries\src\Table\Content.php:39
21	Joomla\CMS\Table\Content->__construct()	JROOT\libraries\src\Table\Table.php:312
20	Joomla\CMS\Table\Table::getInstance()	JROOT\plugins\system\widgetkit_joomla\widgetkit_joomla.php:101
19	plgSystemWidgetkit_Joomla->_applycontentplugins()	JROOT\administrator\components\com_widgetkit\classes\helper.php:64
18	WidgetkitHelper->_call()	JROOT\administrator\components\com_widgetkit\helpers\event.php:53
17	EventWidgetkitHelper->trigger()	JROOT\administrator\components\com_widgetkit\helpers\widget.php:190
16	WidgetWidgetkitHelper->renderWidgetObject()	JROOT\administrator\components\com_widgetkit\helpers\widget.php:161
15	WidgetWidgetkitHelper->render()	JROOT\plugins\content\widgetkit_content\widgetkit_content.php:30
14	plgContentWidgetkit_Content->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:113
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:118
8	ContentController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_content\content.php:43
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Temps de petició: 2.31 ms Després de la darrera petició: 21.84 ms Petició de memòria: 0.214 MB Memòria abans de la petició: 13.252 MB Cel·les retornades: 179

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

  FROM jos_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2019-04-21 21:01:27') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-04-21 21:01:27') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 140 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explicació

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

Perfil

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.04 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	1.76 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1695
18	JDatabaseDriver->loadObjectList()	Same as call in the line below.
17	call_user_func_array()	JROOT\libraries\src\Cache\Controller\CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT\libraries\src\Helper\ModuleHelper.php:432
15	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT\libraries\src\Helper\ModuleHelper.php:362
14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT\libraries\src\Helper\ModuleHelper.php:87
13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT\libraries\src\Document\HtmlDocument.php:581
12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT\templates\yoo_nano2\warp\systems\joomla\helpers\modules.php:49
11	ModulesWarpHelper->count()	JROOT\templates\yoo_nano2\layouts\template.config.php:23
10	include JROOT\templates\yoo_nano2\layouts\template.config.php	JROOT\templates\yoo_nano2\styles\header-interpret\layouts\template.php:10
9	include JROOT\templates\yoo_nano2\styles\header-interpret\layouts\template.php	JROOT\templates\yoo_nano2\warp\helpers\template.php:49
8	TemplateWarpHelper->render()	JROOT\templates\yoo_nano2\index.php:19
7	require JROOT\templates\yoo_nano2\index.php	JROOT\libraries\src\Document\HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT\libraries\src\Application\CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Temps de petició: 0.61 ms Després de la darrera petició: 14.11 ms Petició de memòria: 0.043 MB Memòria abans de la petició: 13.449 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, g.note as group_note

  FROM jos_fields AS a

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

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

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

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

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

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

  WHERE a.context = 'mod_custom.content' 
  AND (fc.category_id IS NULL OR fc.category_id IN (193,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)

  ORDER BY a.ordering ASC

Explicació

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

Perfil

Status	Duration
starting	0.15 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
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.04 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
32	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1695
31	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\MVC\Model\BaseDatabaseModel.php:308
30	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT\administrator\components\com_fields\models\fields.php:333
29	FieldsModelFields->_getList()	JROOT\libraries\src\MVC\Model\ListModel.php:187
28	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT\administrator\components\com_fields\helpers\fields.php:135
27	FieldsHelper::getFields()	JROOT\plugins\system\fields\fields.php:488
26	PlgSystemFields->onContentPrepare()	JROOT\libraries\joomla\event\event.php:70
25	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
24	JEventDispatcher->trigger()	JROOT\libraries\cms\html\content.php:41
23	JHtmlContent::prepare()	Same as call in the line below.
22	call_user_func_array()	JROOT\libraries\src\HTML\HTMLHelper.php:239
21	Joomla\CMS\HTML\HTMLHelper::call()	JROOT\libraries\src\HTML\HTMLHelper.php:146
20	Joomla\CMS\HTML\HTMLHelper::_()	JROOT\modules\mod_custom\mod_custom.php:15
19	include JROOT\modules\mod_custom\mod_custom.php	JROOT\libraries\src\Helper\ModuleHelper.php:200
18	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
17	call_user_func_array()	JROOT\libraries\src\Cache\Controller\CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT\libraries\src\Helper\ModuleHelper.php:598
15	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:95
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\templates\yoo_nano2\warp\systems\joomla\helpers\modules.php:86
13	ModulesWarpHelper->load()	JROOT\templates\yoo_nano2\warp\systems\joomla\layouts\modules.php:10
12	include JROOT\templates\yoo_nano2\warp\systems\joomla\layouts\modules.php	JROOT\templates\yoo_nano2\warp\helpers\template.php:49
11	TemplateWarpHelper->render()	JROOT\templates\yoo_nano2\warp\systems\joomla\helpers\modules.php:64
10	ModulesWarpHelper->render()	JROOT\templates\yoo_nano2\styles\header-interpret\layouts\template.php:47
9	include JROOT\templates\yoo_nano2\styles\header-interpret\layouts\template.php	JROOT\templates\yoo_nano2\warp\helpers\template.php:49
8	TemplateWarpHelper->render()	JROOT\templates\yoo_nano2\index.php:19
7	require JROOT\templates\yoo_nano2\index.php	JROOT\libraries\src\Document\HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT\libraries\src\Application\CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Temps de petició: 0.86 ms Després de la darrera petició: 19.08 ms Petició de memòria: 0.049 MB Memòria abans de la petició: 13.655 MB Cel·les retornades: 20

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

  FROM `jos_categories` AS `s`

  INNER JOIN `jos_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) 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 = 14

  ORDER BY c.lft

Explicació

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NO S`HA POGUT FER SERVIR CAP CLAU INDEX	NULL	NULL	217	Using where; Utilitzant ordenació d`arxius

Perfil

Status	Duration
starting	0.12 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
init	0.04 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.35 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Categories\Categories.php:324
17	Joomla\CMS\Categories\Categories->_load()	JROOT\libraries\src\Categories\Categories.php:184
16	Joomla\CMS\Categories\Categories->get()	JROOT\components\com_content\helpers\legacyrouter.php:173
15	ContentRouterRulesLegacy->build()	JROOT\libraries\src\Component\Router\RouterView.php:244
14	Joomla\CMS\Component\Router\RouterView->build()	JROOT\libraries\src\Router\SiteRouter.php:528
13	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT\libraries\src\Router\SiteRouter.php:498
12	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT\libraries\src\Router\Router.php:281
11	Joomla\CMS\Router\Router->build()	JROOT\libraries\src\Router\SiteRouter.php:154
10	Joomla\CMS\Router\SiteRouter->build()	JROOT\libraries\src\Router\Route.php:102
9	Joomla\CMS\Router\Route::link()	JROOT\libraries\src\Router\Route.php:52
8	Joomla\CMS\Router\Route::_()	JROOT\plugins\system\sef\sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT\libraries\joomla\event\event.php:70
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

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

SELECT `alias`

  FROM `jos_contact_details`

  WHERE id = '1'

Explicació

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

Perfil

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.00 ms
Unlocking tables	0.01 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.01 ms
freeing items	0.00 ms
updating status	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1734
18	JDatabaseDriver->loadResult()	JROOT\components\com_contact\router.php:121
17	ContactRouter->getContactSegment()	Same as call in the line below.
16	call_user_func_array()	JROOT\libraries\src\Component\Router\RouterView.php:120
15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT\libraries\src\Component\Router\Rules\MenuRules.php:111
14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT\libraries\src\Component\Router\RouterView.php:222
13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT\libraries\src\Router\SiteRouter.php:672
12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT\libraries\src\Router\Router.php:266
11	Joomla\CMS\Router\Router->build()	JROOT\libraries\src\Router\SiteRouter.php:154
10	Joomla\CMS\Router\SiteRouter->build()	JROOT\libraries\src\Router\Route.php:102
9	Joomla\CMS\Router\Route::link()	JROOT\libraries\src\Router\Route.php:52
8	Joomla\CMS\Router\Route::_()	JROOT\plugins\system\sef\sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT\libraries\joomla\event\event.php:70
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

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

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

  FROM `jos_categories` AS `s`

  INNER JOIN `jos_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_contact' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id = 188

  ORDER BY c.lft

Explicació

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

Perfil

Status	Duration
starting	0.09 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
init	0.03 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.00 ms
Unlocking tables	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.07 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1695
20	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Categories\Categories.php:324
19	Joomla\CMS\Categories\Categories->_load()	JROOT\libraries\src\Categories\Categories.php:184
18	Joomla\CMS\Categories\Categories->get()	JROOT\components\com_contact\router.php:68
17	ContactRouter->getCategorySegment()	Same as call in the line below.
16	call_user_func_array()	JROOT\libraries\src\Component\Router\RouterView.php:120
15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT\libraries\src\Component\Router\Rules\MenuRules.php:111
14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT\libraries\src\Component\Router\RouterView.php:222
13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT\libraries\src\Router\SiteRouter.php:672
12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT\libraries\src\Router\Router.php:266
11	Joomla\CMS\Router\Router->build()	JROOT\libraries\src\Router\SiteRouter.php:154
10	Joomla\CMS\Router\SiteRouter->build()	JROOT\libraries\src\Router\Route.php:102
9	Joomla\CMS\Router\Route::link()	JROOT\libraries\src\Router\Route.php:52
8	Joomla\CMS\Router\Route::_()	JROOT\plugins\system\sef\sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT\libraries\joomla\event\event.php:70
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

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

Taules SELECCIONADES:

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

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

2 × 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, g.note as group_note
 
  FROM jos_fields AS a
 
  LEFT JOIN `jos_languages` AS l 
  ON l.lang_code = a.language
 
  LEFT JOIN jos_users AS uc 
  ON uc.id=a.checked_out
 
  LEFT JOIN jos_viewlevels AS ag 
  ON ag.id = a.access
 
  LEFT JOIN jos_users AS ua 
  ON ua.id = a.created_user_id
 
  LEFT JOIN jos_fields_groups AS g 
  ON g.id = a.group_id
 
  LEFT JOIN `jos_fields_categories` AS fc 
  ON fc.field_id = a.id

2 × SELECT COUNT(*) 
  from `jos_mi_iptable`

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

1 × SELECT `data`
 
  FROM `jos_session`

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

1 × SELECT * 
  FROM jos_widgetkit_widget

1 × SELECT id,template 
  FROM jos_template_styles

1 × SELECT params 
  FROM jos_extensions AS e

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

1 × SELECT 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 jos_content AS a
 
  LEFT JOIN jos_categories AS c 
  ON c.id = a.catid
 
  LEFT JOIN jos_users AS ua 
  ON ua.id = a.created_by
 
  LEFT JOIN jos_users AS uam 
  ON uam.id = a.modified_by
 
  LEFT JOIN jos_categories as parent 
  ON parent.id = c.parent_id
 
  LEFT JOIN jos_content_rating AS v 
  ON a.id = v.content_id

1 × SELECT `session_id`
 
  FROM `jos_session`

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

1 × SELECT `enabled`
 
  FROM `jos_extensions`

1 × SELECT `value`
 
  FROM `jos_admintools_storage`

1 × SELECT *
 
  FROM `jos_admintools_wafexceptions`

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

1 × SELECT id, rules
 
  FROM `jos_viewlevels

1 × SELECT `alias`
 
  FROM `jos_contact_details`

ALTRES taules:

1 × INSERT INTO `jos_session`
 (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
 ('l3ohchc5266e0a62b7esqsbe22', 1, 1555880487, 0, '', 0

1 × SHOW VARIABLES LIKE "collation_database

```
1 × DELETE 
  FROM `jos_mi_iptable`
```

1 × UPDATE `jos_extensions`
 
  SET `params` = '{\"mediaversion\":\"031da88806bde95bff107b8f84ecb7cb\"}'

1 × SHOW FULL COLUMNS 
  FROM `jos_content