: 01 Enero 2016; Visto: 875; Rating:

Calderas y estufas de biomasa

Ratio: 1 / 5

Tarifa de calderas y estufas de biomasa

En la siguiente tabla mostramos nuestra tarifa de estufas y calderas de biomasa clasificada según las diferentes variables que necesitamos conocer en su proyecto de calefacción. La tarifa incluye además las principales variables a tener en cuenta al seleccionar el sistema, que son las siguientes:

Aplicación. Las opciones que podemos elegir son calefacción ambiental, calefacción ambiental varias estancias, calefacción ambiental + calefacción por agua, calentamiento por agua, estufa de leña con clave de apertura, estufa de leña con horno, estufa de leña con horno + cocina y estufa de leña empotrable.
Combustible: El combustible puede ser leña (distintos tipos de biomasa) o pellets.
Superficie: Indicamos la superficie total que podremos calentar.
Pot amb (kW): Es la potencia en kW que transmitimos al ambiente.
Rendim: Es el rendimiento del equipo.
Potencia agua (kW).
Diámetro de la chimenea.
Capacidad de agua.

Los kits se comercializan completos, incluyendo los tubos para un perfil con seis tramos de tubo. Los accesorios del kit son los siguientes:

Tramos rectos.
Codos.
Caperuza.
T
Tapa purga.
Soporte universal.
Juntas.
Abrazaderas de unión.
Evacuación de humos.

Nuestro Compromiso

La optimización de nuestras soluciones es la PRIMERA de nuestras prioridades

Buscamos soluciones fiables, de alta capacidad y buscando siempre la máxima competitividad.

Últimas Noticias

Asia Central 30 Junio 2017

Proyecto CERACM en República Democrática del Congo 08 Mayo 2017

Distributed solar irrigation in Africa 18 Abril 2017

Enlaces

Consola de depuración de Joomla!

Sesión

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1503488588,
                "last": 1503488588,
                "now": 1503488588
            },
            "token": "TK9eFCscLoH2H8TVpv7K45p93GUgALoc"
        },
        "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ón del perfil

Fecha y hora

Memoria

Fecha y hora: 10.03 ms / 10.03 ms Memoria: 0.870 MB / 1.09 MB Application: afterLoad

Fecha y hora: 136.37 ms / 146.40 ms Memoria: 5.905 MB / 7.00 MB Application: afterInitialise

Fecha y hora: 11.65 ms / 158.04 ms Memoria: 0.772 MB / 7.77 MB Application: afterRoute

Fecha y hora: 13.29 ms / 171.33 ms Memoria: 0.475 MB / 8.24 MB Application: beforeRenderComponent com_content

Fecha y hora: 5.96 ms / 177.29 ms Memoria: 0.686 MB / 8.93 MB Application: Before JAccess::preloadComponents (all components)

Fecha y hora: 2.22 ms / 179.51 ms Memoria: 0.087 MB / 9.02 MB Application: After JAccess::preloadComponents (all components)

Fecha y hora: 0.06 ms / 179.56 ms Memoria: 0.000 MB / 9.01 MB Application: Before JAccess::getAssetRules (id:8 name:com_content)

Fecha y hora: 0.54 ms / 180.10 ms Memoria: 0.045 MB / 9.06 MB Application: After JAccess::getAssetRules (id:8 name:com_content)

Fecha y hora: 45.80 ms / 225.90 ms Memoria: 2.603 MB / 11.66 MB Application: Before JAccess::preloadPermissions (com_content)

Fecha y hora: 2.97 ms / 228.87 ms Memoria: 0.175 MB / 11.84 MB Application: After JAccess::preloadPermissions (com_content)

Fecha y hora: 0.07 ms / 228.94 ms Memoria: 0.000 MB / 11.83 MB Application: Before JAccess::getAssetRules (id:262 name:com_content.article.115)

Fecha y hora: 0.13 ms / 229.07 ms Memoria: 0.010 MB / 11.84 MB Application: After JAccess::getAssetRules (id:262 name:com_content.article.115)

Fecha y hora: 22.24 ms / 251.31 ms Memoria: 0.951 MB / 12.79 MB Application: afterRenderComponent com_content

Fecha y hora: 15.71 ms / 267.01 ms Memoria: 0.367 MB / 13.16 MB Application: afterDispatch

Fecha y hora: 30.62 ms / 297.63 ms Memoria: 2.350 MB / 15.51 MB Application: beforeRenderModule mod_search (Search)

Fecha y hora: 2.32 ms / 299.94 ms Memoria: 0.065 MB / 15.57 MB Application: afterRenderModule mod_search (Search)

Fecha y hora: 0.07 ms / 300.02 ms Memoria: 0.000 MB / 15.56 MB Application: beforeRenderModule mod_menu (Off Canvas Menu)

Fecha y hora: 11.87 ms / 311.89 ms Memoria: 0.197 MB / 15.76 MB Application: afterRenderModule mod_menu (Off Canvas Menu)

Fecha y hora: 0.21 ms / 312.10 ms Memoria: 0.000 MB / 15.75 MB Application: beforeRenderModule mod_menu (Enlaces)

Fecha y hora: 1.11 ms / 313.21 ms Memoria: 0.024 MB / 15.77 MB Application: afterRenderModule mod_menu (Enlaces)

Fecha y hora: 0.10 ms / 313.31 ms Memoria: 0.000 MB / 15.77 MB Application: beforeRenderModule mod_articles_latest (Últimas Noticias)

Fecha y hora: 9.88 ms / 323.20 ms Memoria: 0.391 MB / 16.16 MB Application: afterRenderModule mod_articles_latest (Últimas Noticias)

Fecha y hora: 0.19 ms / 323.38 ms Memoria: 0.000 MB / 16.06 MB Application: beforeRenderModule mod_custom (Nuestro Compromiso)

Fecha y hora: 1.22 ms / 324.60 ms Memoria: 0.012 MB / 16.07 MB Application: afterRenderModule mod_custom (Nuestro Compromiso)

Fecha y hora: 4.76 ms / 329.36 ms Memoria: 0.128 MB / 16.20 MB Application: afterRender

Total de consultas a la base de datos: 111.84 ms

Uso de la memoria

Consultas de la base de datos

34 consultas registradas 111.84 ms

Tiempo de la consulta: 3.21 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 3.614 MB Filas devueltas: 0

SELECT `data`

  FROM `portal_session`

  WHERE `session_id` = '4bshpu2e8skjacte030gecvps7'

Explicar

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

Perfil

Status	Duration
starting	0.07 ms
Waiting for query cache lock	0.06 ms
init	0.02 ms
checking query cache for query	0.08 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.02 ms
Waiting for query cache lock	0.02 ms
System lock	0.04 ms
optimizing	0.02 ms
statistics	0.05 ms
executing	0.02 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.02 ms
Waiting for query cache lock	0.02 ms
freeing items	0.04 ms
Waiting for query cache lock	0.03 ms
freeing items	0.03 ms
storing result in query cache	0.02 ms
cleaning up	0.03 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Lo mismo que llamada de la línea de abajo.
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:82
10	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:648
9	JSession->_start()	JROOT/libraries/joomla/session/session.php:608
8	JSession->start()	JROOT/libraries/joomla/session/session.php:486
7	JSession->get()	JROOT/libraries/joomla/session/session.php:443
6	JSession->isNew()	JROOT/libraries/cms/application/cms.php:825
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 5.23 ms Después de la última consulta: 1.40 ms Consulta a la memoria: 0.012 MB memoria antes de la consulta: 3.783 MB Filas devueltas: 0

SELECT `session_id`

  FROM `portal_session`

  WHERE `session_id` = '4bshpu2e8skjacte030gecvps7' 
  LIMIT 1

Explicar

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

Perfil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.04 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.02 ms
Waiting for query cache lock	0.02 ms
System lock	0.05 ms
optimizing	0.03 ms
statistics	2.40 ms
executing	0.05 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.02 ms
Waiting for query cache lock	0.02 ms
freeing items	0.28 ms
Waiting for query cache lock	0.03 ms
freeing items	0.02 ms
storing result in query cache	0.06 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:827
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 2.79 ms Después de la última consulta: 0.27 ms Consulta a la memoria: 0.009 MB memoria antes de la consulta: 3.798 MB

INSERT INTO `portal_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('4bshpu2e8skjacte030gecvps7', 1, '1503488588', 0, '', 0)

Explicar

'Explicar' no es posible en la consulta: INSERT INTO `portal_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('4bshpu2e8skjacte030gecvps7', 1, '1503488588', 0, '', 0)

Perfil

Status	Duration
starting	0.07 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.02 ms
update	0.11 ms
Waiting for query cache lock	0.02 ms
update	0.03 ms
end	0.02 ms
query end	0.07 ms
closing tables	0.03 ms
freeing items	1.50 ms
cleaning up	0.03 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:216
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:827
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 4.94 ms Después de la última consulta: 2.53 ms Consulta a la memoria: 0.019 MB memoria antes de la consulta: 4.096 MB Filas devueltas: 35

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

  FROM `portal_extensions`

  WHERE `type` = 'component'

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	portal_extensions	ref	extension	extension	82	const	35	100.00	Using index condition

Perfil

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.04 ms
init	0.02 ms
checking query cache for query	0.05 ms
checking permissions	0.09 ms
Opening tables	0.07 ms
init	0.04 ms
System lock	0.03 ms
Waiting for query cache lock	0.02 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.03 ms
executing	0.05 ms
Sending data	0.28 ms
Waiting for query cache lock	0.03 ms
Sending data	0.06 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.04 ms
Waiting for query cache lock	0.02 ms
freeing items	0.05 ms
Waiting for query cache lock	0.02 ms
freeing items	0.02 ms
storing result in query cache	0.09 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/component/helper.php:452
9	JComponentHelper::{closure}()	Lo mismo que llamada de la línea de abajo.
8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:460
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:111
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:593
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 2.87 ms Después de la última consulta: 2.56 ms Consulta a la memoria: 0.015 MB memoria antes de la consulta: 4.425 MB Filas devueltas: 1

SELECT b.id

  FROM portal_usergroups AS a

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

  WHERE a.id = 1

Explicar

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

Perfil

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
sending cached result to clien	0.03 ms
cleaning up	0.03 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:978
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:1047
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 3.16 ms Después de la última consulta: 0.67 ms Consulta a la memoria: 0.014 MB memoria antes de la consulta: 4.515 MB Filas devueltas: 6

SELECT id, rules

  FROM `portal_viewlevels`

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	portal_viewlevels	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	6	100.00	NULL

Perfil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.02 ms
checking permissions	0.02 ms
sending cached result to clien	0.04 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1064
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 4.52 ms Después de la última consulta: 0.26 ms Consulta a la memoria: 0.017 MB memoria antes de la consulta: 4.555 MB Filas devueltas: 70

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

  FROM portal_extensions

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

  ORDER BY ordering

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	portal_extensions	ref	extension	extension	82	const	78	100.00	Using index condition; Using where; Usando 'filesort'

Perfil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.03 ms
init	0.02 ms
checking query cache for query	0.06 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.12 ms
System lock	0.05 ms
Waiting for query cache lock	0.02 ms
System lock	0.04 ms
optimizing	0.03 ms
statistics	0.11 ms
preparing	0.05 ms
Sorting result	0.03 ms
executing	0.02 ms
Sending data	0.03 ms
Creating sort index	0.55 ms
end	0.04 ms
query end	0.03 ms
closing tables	0.02 ms
freeing items	0.02 ms
Waiting for query cache lock	0.02 ms
freeing items	0.05 ms
Waiting for query cache lock	0.02 ms
freeing items	0.02 ms
storing result in query cache	0.02 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:311
9	JPluginHelper::{closure}()	Lo mismo que llamada de la línea de abajo.
8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/plugin/helper.php:316
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 3.98 ms Después de la última consulta: 10.76 ms Consulta a la memoria: 0.017 MB memoria antes de la consulta: 5.591 MB Filas devueltas: 2

SELECT *

  FROM portal_languages

  WHERE published=1

  ORDER BY ordering ASC

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	portal_languages	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	2	100.00	Using where; Usando 'filesort'

Perfil

Status	Duration
starting	0.08 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.02 ms
checking permissions	0.02 ms
sending cached result to clien	0.04 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:148
8	JLanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:98
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:682
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 7.22 ms Después de la última consulta: 0.29 ms Consulta a la memoria: 0.015 MB memoria antes de la consulta: 5.613 MB Filas devueltas: 4

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

  FROM `portal_extensions`

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

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	portal_extensions	ref	extension	extension	82	const	4	100.00	Using index condition; Using where

Perfil

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.06 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.03 ms
Waiting for query cache lock	0.09 ms
System lock	0.05 ms
optimizing	0.16 ms
statistics	0.16 ms
preparing	0.06 ms
executing	0.02 ms
Sending data	0.07 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.05 ms
Waiting for query cache lock	0.03 ms
freeing items	0.39 ms
Waiting for query cache lock	0.03 ms
freeing items	0.02 ms
storing result in query cache	0.02 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:207
8	JLanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:109
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:682
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 19.76 ms Después de la última consulta: 7.09 ms Consulta a la memoria: 0.043 MB memoria antes de la consulta: 6.456 MB Filas devueltas: 62

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM portal_menu AS m

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

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

  ORDER BY m.lft

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	115	100.00	Using index condition; Using where; Usando 'filesort'
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	qtx295.m.component_id	1	100.00	Using where

Perfil

Status	Duration
starting	0.07 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.09 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.02 ms
Waiting for query cache lock	0.02 ms
System lock	0.04 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.05 ms
Sorting result	0.02 ms
executing	0.03 ms
Sending data	0.04 ms
Creating sort index	0.88 ms
Waiting for query cache lock	0.04 ms
Creating sort index	0.23 ms
Waiting for query cache lock	0.03 ms
Creating sort index	0.11 ms
Waiting for query cache lock	0.03 ms
Creating sort index	4.53 ms
Waiting for query cache lock	0.05 ms
Creating sort index	0.10 ms
Waiting for query cache lock	0.10 ms
Creating sort index	0.15 ms
Waiting for query cache lock	0.03 ms
Creating sort index	0.13 ms
end	0.06 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.03 ms
Waiting for query cache lock	0.02 ms
freeing items	0.02 ms
Waiting for query cache lock	0.02 ms
freeing items	0.02 ms
storing result in query cache	0.02 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:88
22	JMenuSite->{closure}()	Lo mismo que llamada de la línea de abajo.
21	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
20	JCacheControllerCallback->get()	JROOT/libraries/cms/menu/site.php:96
19	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
18	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
17	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:129
16	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:443
15	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
14	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:59
13	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:198
12	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:548
11	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:402
10	JApplicationSite::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:130
9	PlgSystemLanguageFilter->onAfterInitialise()	Lo mismo que llamada de la línea de abajo.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:683
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 2.12 ms Después de la última consulta: 15.69 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 7.824 MB Filas devueltas: 1

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

  FROM `portal_extensions`

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

Explicar

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

Perfil

Status	Duration
starting	0.08 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.05 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.02 ms
Waiting for query cache lock	0.02 ms
System lock	0.04 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	0.06 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.03 ms
Waiting for query cache lock	0.02 ms
freeing items	0.06 ms
Waiting for query cache lock	0.02 ms
freeing items	0.04 ms
storing result in query cache	0.38 ms
cleaning up	0.03 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
14	JDatabaseDriver->loadObject()	JROOT/libraries/cms/library/helper.php:166
13	JLibraryHelper::{closure}()	Lo mismo que llamada de la línea de abajo.
12	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
11	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:174
10	JLibraryHelper::loadLibrary()	JROOT/libraries/cms/library/helper.php:42
9	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:89
8	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:270
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:1022
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 2.25 ms Después de la última consulta: 0.35 ms Consulta a la memoria: 0.012 MB memoria antes de la consulta: 7.826 MB

UPDATE `portal_extensions`

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

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

Explicar

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

Perfil

Status	Duration
starting	0.05 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.09 ms
updating	0.10 ms
end	0.03 ms
Waiting for query cache lock	0.02 ms
end	0.09 ms
query end	0.19 ms
closing tables	0.03 ms
freeing items	0.05 ms
cleaning up	0.03 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:1022
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 3.40 ms Después de la última consulta: 2.32 ms Consulta a la memoria: 0.018 MB memoria antes de la consulta: 8.140 MB Filas devueltas: 4

SELECT id, home, template, s.params

  FROM portal_template_styles as s

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

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

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	ALL	idx_template	No pudo usarse una clave de índice	NULL	NULL	6	100.00	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	qtx295.s.template,const	1	100.00	Using index condition; Using where

Perfil

Status	Duration
starting	0.32 ms
Waiting for query cache lock	0.03 ms
init	0.02 ms
checking query cache for query	0.06 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.06 ms
System lock	0.03 ms
Waiting for query cache lock	0.02 ms
System lock	0.04 ms
optimizing	0.03 ms
statistics	0.08 ms
preparing	0.05 ms
executing	0.02 ms
Sending data	0.11 ms
Waiting for query cache lock	0.02 ms
Sending data	0.08 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.03 ms
freeing items	0.03 ms
Waiting for query cache lock	0.02 ms
freeing items	0.10 ms
Waiting for query cache lock	0.03 ms
freeing items	0.02 ms
storing result in query cache	0.15 ms
cleaning up	0.03 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:485
4	JApplicationSite->getTemplate()	JROOT/libraries/cms/application/site.php:165
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 1.68 ms Después de la última consulta: 8.45 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 8.936 MB Filas devueltas: 35

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

  FROM `portal_assets`

  WHERE `name` IN ('com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_quicklogout','com_redirect','com_search','com_sppagebuilder','com_spsimpleportfolio','com_tags','com_templates','com_users','com_wrapper') OR `parent_id` = 0

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	portal_assets	ALL	idx_asset_name,idx_parent_id	No pudo usarse una clave de índice	NULL	NULL	196	100.00	Using where

Perfil

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.03 ms
checking privileges on cached	0.03 ms
checking permissions	0.02 ms
sending cached result to clien	0.04 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
16	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
15	JAccess::preload()	JROOT/libraries/joomla/access/access.php:529
14	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
13	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:434
10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:248
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 6.06 ms Después de la última consulta: 1.77 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 9.150 MB Filas devueltas: 30

SHOW FULL COLUMNS 
  FROM `portal_content`

Explicar

'Explicar' no es posible en la consulta: SHOW FULL COLUMNS FROM `portal_content`

Perfil

Status	Duration
starting	0.06 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.28 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.02 ms
Opening tables	0.05 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	2.28 ms
checking permissions	0.06 ms
checking permissions	0.09 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.05 ms
checking permissions	0.03 ms
checking permissions	0.11 ms
checking permissions	0.09 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
Sending data	0.08 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
removing tmp table	0.18 ms
closing tables	0.04 ms
freeing items	0.05 ms
cleaning up	0.03 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
12	JTable->__construct()	JROOT/libraries/legacy/table/content.php:33
11	JTableContent->__construct()	JROOT/libraries/joomla/table/table.php:311
10	JTable::getInstance()	JROOT/components/com_content/models/article.php:250
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 3.57 ms Después de la última consulta: 3.14 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 9.570 MB Filas devueltas: 1

SELECT *

  FROM portal_content

  WHERE `id` = '115'

Explicar

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

Perfil

Status	Duration
starting	2.38 ms
Waiting for query cache lock	0.04 ms
init	0.03 ms
checking query cache for query	0.04 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.03 ms
Waiting for query cache lock	0.02 ms
System lock	0.04 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.04 ms
executing	0.03 ms
Sending data	0.11 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.02 ms
Waiting for query cache lock	0.02 ms
freeing items	0.07 ms
Waiting for query cache lock	0.03 ms
freeing items	0.02 ms
storing result in query cache	0.02 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
10	JTable->load()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 2.85 ms Después de la última consulta: 0.27 ms Consulta a la memoria: 0.014 MB memoria antes de la consulta: 9.587 MB

UPDATE portal_content

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

  WHERE `id` = '115'

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	portal_content	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Perfil

Status	Duration
starting	0.10 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.05 ms
updating	0.09 ms
end	0.03 ms
Waiting for query cache lock	0.03 ms
end	0.34 ms
query end	0.23 ms
closing tables	0.03 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1240
10	JTable->hit()	JROOT/components/com_content/models/article.php:252
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 1.97 ms Después de la última consulta: 1.98 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 9.819 MB Filas devueltas: 1

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

  FROM portal_content AS a

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

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

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

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

  WHERE a.id = 115 
  AND c.published > 0 
  AND a.language in ('es-ES','*') 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-08-23 11:43:08') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-08-23 11:43:08') 
  AND (a.state = 1 OR a.state =2)

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	const	PRIMARY,idx_state,idx_catid,idx_language	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Perfil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.23 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
init	0.09 ms
System lock	0.03 ms
Waiting for query cache lock	0.02 ms
System lock	0.06 ms
optimizing	0.05 ms
statistics	0.19 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	0.06 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.03 ms
Waiting for query cache lock	0.02 ms
freeing items	0.05 ms
Waiting for query cache lock	0.02 ms
freeing items	0.02 ms
storing result in query cache	0.02 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:148
12	ContentModelArticle->getItem()	JROOT/libraries/legacy/view/legacy.php:422
11	JViewLegacy->get()	JROOT/components/com_content/views/article/view.html.php:42
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 2.08 ms Después de la última consulta: 3.24 ms Consulta a la memoria: 0.036 MB memoria antes de la consulta: 10.145 MB Filas devueltas: 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 portal_categories as c

  LEFT JOIN portal_categories AS s 
  ON (s.lft < c.lft 
  AND s.rgt > c.rgt 
  AND c.language in ('es-ES','*')) OR (s.lft >= c.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=19

  GROUP BY 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

  ORDER BY c.lft

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Usando 'filesort'
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	No pudo usarse una clave de índice	NULL	NULL	49	22.45	Using where

Perfil

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.03 ms
checking privileges on cached	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
sending cached result to clien	0.04 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:301
21	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:182
20	JCategories->get()	JROOT/components/com_content/router.php:70
19	ContentRouter->getCategorySegment()	Lo mismo que llamada de la línea de abajo.
18	call_user_func_array()	JROOT/libraries/cms/component/router/view.php:117
17	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
16	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
15	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
14	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
13	JRouter->build()	JROOT/libraries/cms/router/site.php:149
12	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
11	JRoute::_()	JROOT/components/com_content/views/article/view.html.php:71
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 2.47 ms Después de la última consulta: 5.15 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 10.212 MB Filas devueltas: 0

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

  FROM `portal_contentitem_tag_map` AS m 

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

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

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_tag_type	No pudo usarse una clave de índice	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	qtx295.m.tag_id	1	100.00	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
11	JHelperTags->getItemTags()	JROOT/components/com_content/views/article/view.html.php:180
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 1.03 ms Después de la última consulta: 6.43 ms Consulta a la memoria: 0.032 MB memoria antes de la consulta: 11.068 MB Filas devueltas: 0

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

  FROM portal_fields AS a

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

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

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

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

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

  LEFT JOIN `portal_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 (19,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)

  GROUP BY a.id, l.title, l.image, uc.name, ag.title, ua.name, g.title, g.access, g.state

  ORDER BY a.ordering DESC

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using temporary; Usando 'filesort'
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	qtx295.a.language	1	100.00	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	qtx295.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	qtx295.a.access	1	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	qtx295.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	qtx295.a.group_id	1	100.00	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	qtx295.a.id	1	100.00	Using where; Using index

Perfil

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.03 ms
checking privileges on cached	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
sending cached result to clien	0.03 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
18	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
17	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
16	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
14	PlgSystemFields->onContentPrepare()	Lo mismo que llamada de la línea de abajo.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:190
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.97 ms Después de la última consulta: 3.22 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 11.632 MB Filas devueltas: 1

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

  FROM `portal_contact_details` AS `contact`

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

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	contact	ALL	idx_state,idx_language	No pudo usarse una clave de índice	NULL	NULL	9	88.89	Using where

Perfil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.02 ms
checking permissions	0.02 ms
sending cached result to clien	0.04 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
16	JDatabaseDriver->loadObject()	JROOT/plugins/content/contact/contact.php:108
15	PlgContentContact->getContactId()	JROOT/plugins/content/contact/contact.php:60
14	PlgContentContact->onContentPrepare()	Lo mismo que llamada de la línea de abajo.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:190
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 2.38 ms Después de la última consulta: 0.58 ms Consulta a la memoria: 0.031 MB memoria antes de la consulta: 11.664 MB Filas devueltas: 98

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

  FROM `portal_assets`

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

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	portal_assets	ALL	idx_asset_name,idx_parent_id	No pudo usarse una clave de índice	NULL	NULL	196	100.00	Using where

Perfil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.03 ms
checking privileges on cached	0.02 ms
checking permissions	0.02 ms
sending cached result to clien	0.07 ms
cleaning up	0.03 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:357
19	JAccess::preloadPermissions()	JROOT/libraries/joomla/access/access.php:224
18	JAccess::preload()	JROOT/libraries/joomla/access/access.php:538
17	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
16	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
15	JUser->authorise()	JROOT/plugins/content/pagenavigation/pagenavigation.php:54
14	PlgContentPagenavigation->onContentBeforeDisplay()	Lo mismo que llamada de la línea de abajo.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:196
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 4.18 ms Después de la última consulta: 0.94 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 11.852 MB Filas devueltas: 38

SELECT a.id, a.title, a.catid, a.language, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug

  FROM portal_content AS a

  LEFT JOIN portal_categories AS cc 
  ON cc.id = a.catid

  WHERE a.catid = 19 
  AND a.state = 1 
  AND a.access IN (1,1)  
  AND (a.state = 1 OR a.state = -1) 
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2017-08-23 11:43:08') 
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2017-08-23 11:43:08') 
  AND a.language in ('es-ES','*')

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

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid,idx_language	idx_state	1	const	51	100.00	Using where; Usando 'filesort'
1	SIMPLE	cc	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Perfil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.15 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.07 ms
System lock	0.03 ms
Waiting for query cache lock	0.02 ms
System lock	0.06 ms
optimizing	0.05 ms
statistics	0.15 ms
preparing	0.05 ms
Sorting result	0.02 ms
executing	0.02 ms
Sending data	0.05 ms
Creating sort index	0.47 ms
end	0.06 ms
query end	0.03 ms
closing tables	0.02 ms
freeing items	0.03 ms
Waiting for query cache lock	0.02 ms
freeing items	0.05 ms
Waiting for query cache lock	0.02 ms
freeing items	0.03 ms
storing result in query cache	0.25 ms
cleaning up	0.03 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/content/pagenavigation/pagenavigation.php:152
14	PlgContentPagenavigation->onContentBeforeDisplay()	Lo mismo que llamada de la línea de abajo.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:196
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.92 ms Después de la última consulta: 17.92 ms Consulta a la memoria: 0.015 MB memoria antes de la consulta: 12.793 MB Filas devueltas: 2

SELECT language,id

  FROM `portal_menu`

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

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	portal_menu	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	116	100.00	Using where

Perfil

Status	Duration
starting	0.08 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.02 ms
checking permissions	0.02 ms
sending cached result to clien	0.04 ms
cleaning up	0.04 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/multilang.php:106
9	JLanguageMultilang::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:709
8	PlgSystemLanguageFilter->onAfterDispatch()	Lo mismo que llamada de la línea de abajo.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 1.12 ms Después de la última consulta: 0.31 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 12.814 MB Filas devueltas: 1

SELECT `alias`

  FROM `portal_content`

  WHERE id = '115'

Explicar

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

Perfil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.05 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.02 ms
Waiting for query cache lock	0.02 ms
System lock	0.04 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.02 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.02 ms
Waiting for query cache lock	0.02 ms
freeing items	0.19 ms
Waiting for query cache lock	1.02 ms
freeing items	0.07 ms
storing result in query cache	0.11 ms
cleaning up	0.03 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
18	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:123
17	ContentRouter->getArticleSegment()	Lo mismo que llamada de la línea de abajo.
16	call_user_func_array()	JROOT/libraries/cms/component/router/view.php:117
15	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
14	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
13	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
12	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
11	JRouter->build()	JROOT/libraries/cms/router/site.php:149
10	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
9	JRoute::_()	JROOT/plugins/system/languagefilter/languagefilter.php:720
8	PlgSystemLanguageFilter->onAfterDispatch()	Lo mismo que llamada de la línea de abajo.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 3.93 ms Después de la última consulta: 0.24 ms Consulta a la memoria: 0.032 MB memoria antes de la consulta: 12.842 MB Filas devueltas: 0

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

  FROM portal_categories as c

  LEFT JOIN portal_categories AS s 
  ON (s.lft < c.lft 
  AND s.rgt > c.rgt 
  AND c.language in ('es-ES','*')) OR (s.lft >= c.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=115

  GROUP BY 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

  ORDER BY c.lft

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Perfil

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.17 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
init	0.10 ms
System lock	0.02 ms
Waiting for query cache lock	0.02 ms
System lock	0.05 ms
optimizing	0.04 ms
statistics	0.08 ms
executing	0.04 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.03 ms
Waiting for query cache lock	0.02 ms
freeing items	0.07 ms
Waiting for query cache lock	0.03 ms
freeing items	0.02 ms
storing result in query cache	0.11 ms
cleaning up	0.03 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:301
19	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:182
18	JCategories->get()	JROOT/components/com_content/router.php:70
17	ContentRouter->getCategorySegment()	Lo mismo que llamada de la línea de abajo.
16	call_user_func_array()	JROOT/libraries/cms/component/router/view.php:121
15	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
14	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
13	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
12	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
11	JRouter->build()	JROOT/libraries/cms/router/site.php:149
10	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
9	JRoute::_()	JROOT/plugins/system/languagefilter/languagefilter.php:720
8	PlgSystemLanguageFilter->onAfterDispatch()	Lo mismo que llamada de la línea de abajo.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 1.18 ms Después de la última consulta: 1.57 ms Consulta a la memoria: 0.016 MB memoria antes de la consulta: 12.939 MB Filas devueltas: 0

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

  FROM `portal_menu` AS `c`

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

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

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

  WHERE c.id = 552

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Perfil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.06 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.17 ms
init	0.05 ms
System lock	0.02 ms
Waiting for query cache lock	0.02 ms
System lock	0.05 ms
optimizing	0.04 ms
statistics	0.08 ms
executing	0.03 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.03 ms
Waiting for query cache lock	0.02 ms
freeing items	0.14 ms
Waiting for query cache lock	0.04 ms
freeing items	0.02 ms
storing result in query cache	0.09 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/associations.php:101
10	JLanguageAssociations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:314
9	MenusHelper::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:726
8	PlgSystemLanguageFilter->onAfterDispatch()	Lo mismo que llamada de la línea de abajo.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 3.73 ms Después de la última consulta: 0.75 ms Consulta a la memoria: 0.017 MB memoria antes de la consulta: 12.981 MB Filas devueltas: 0

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

  FROM `portal_content` AS `c`

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

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

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

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

  WHERE c.id = 115

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Perfil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.02 ms
init	0.03 ms
checking query cache for query	0.08 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.03 ms
Waiting for query cache lock	0.02 ms
System lock	0.05 ms
optimizing	2.32 ms
statistics	0.14 ms
executing	0.05 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.06 ms
freeing items	0.03 ms
Waiting for query cache lock	0.02 ms
freeing items	0.26 ms
Waiting for query cache lock	0.04 ms
freeing items	0.02 ms
storing result in query cache	0.02 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/associations.php:101
11	JLanguageAssociations::getAssociations()	JROOT/components/com_content/helpers/association.php:43
10	ContentHelperAssociation::getAssociations()	Lo mismo que llamada de la línea de abajo.
9	call_user_func()	JROOT/plugins/system/languagefilter/languagefilter.php:741
8	PlgSystemLanguageFilter->onAfterDispatch()	Lo mismo que llamada de la línea de abajo.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 2.13 ms Después de la última consulta: 26.80 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 15.431 MB Filas devueltas: 12

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

  FROM portal_modules AS m

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

  LEFT JOIN portal_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 <= '2017-08-23 11:43:08') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2017-08-23 11:43:08') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 552 OR mm.menuid <= 0) 
  AND m.language IN ('es-ES','*')

  ORDER BY m.position, m.ordering

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds,idx_language	published	1	const	22	100.00	Using index condition; Using where; Usando 'filesort'
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	qtx295.m.id	1	100.00	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	qtx295.m.module,const	1	100.00	Using index condition; Using where

Perfil

Status	Duration
starting	0.08 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.11 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.07 ms
System lock	0.03 ms
Waiting for query cache lock	0.02 ms
System lock	0.09 ms
optimizing	0.06 ms
statistics	0.13 ms
preparing	0.06 ms
Sorting result	0.02 ms
executing	0.02 ms
Sending data	0.02 ms
Creating sort index	0.43 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.03 ms
Waiting for query cache lock	0.02 ms
freeing items	0.23 ms
Waiting for query cache lock	0.03 ms
freeing items	0.02 ms
storing result in query cache	0.02 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	Lo mismo que llamada de la línea de abajo.
16	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
15	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:424
14	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:360
13	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
12	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:576
11	JDocumentHtml->countModules()	JROOT/plugins/system/helix3/core/helix3.php:502
10	Helix3::countModules()	JROOT/plugins/system/helix3/core/helix3.php:458
9	Helix3::rowColumns()	JROOT/plugins/system/helix3/core/helix3.php:222
8	Helix3::generatelayout()	JROOT/templates/shaper_helix3/index.php:157
7	require JROOT/templates/shaper_helix3/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 2.48 ms Después de la última consulta: 22.28 ms Consulta a la memoria: 0.031 MB memoria antes de la consulta: 16.018 MB Filas devueltas: 3

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,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,
  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 portal_content AS a

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

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

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

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

  LEFT JOIN portal_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.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-08-23 11:43:08') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-08-23 11:43:08') 
  AND a.language in ('es-ES','*')

  ORDER BY a.created DESC 
  LIMIT 3

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid,idx_language	idx_state	1	const	51	100.00	Using where; Usando 'filesort'
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	qtx295.a.catid	1	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	qtx295.a.created_by	1	100.00	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	qtx295.a.modified_by	1	100.00	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	qtx295.c.parent_id	1	100.00	Using where
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	qtx295.a.id	1	100.00	Using where

Perfil

Status	Duration
starting	0.12 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.21 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
init	0.12 ms
System lock	0.04 ms
Waiting for query cache lock	0.02 ms
System lock	0.06 ms
optimizing	0.04 ms
statistics	0.22 ms
preparing	0.08 ms
Sorting result	0.08 ms
executing	0.02 ms
Sending data	0.07 ms
Creating sort index	0.35 ms
Waiting for query cache lock	0.03 ms
Creating sort index	0.09 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.03 ms
Waiting for query cache lock	0.02 ms
freeing items	0.04 ms
Waiting for query cache lock	0.02 ms
freeing items	0.02 ms
storing result in query cache	0.02 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
14	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:186
13	JModelList->getItems()	JROOT/components/com_content/models/articles.php:536
12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_latest/helper.php:113
11	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
10	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.55 ms Después de la última consulta: 0.60 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 16.103 MB Filas devueltas: 0

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

  FROM `portal_contentitem_tag_map` AS m 

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

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

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_tag_type	No pudo usarse una clave de índice	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	qtx295.m.tag_id	1	100.00	Using where

Perfil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.03 ms
init	0.03 ms
checking query cache for query	0.03 ms
checking privileges on cached	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
sending cached result to clien	0.04 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
13	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:662
12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_latest/helper.php:113
11	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
10	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.58 ms Después de la última consulta: 0.43 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 16.142 MB Filas devueltas: 0

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

  FROM `portal_contentitem_tag_map` AS m 

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

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

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_tag_type	No pudo usarse una clave de índice	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	qtx295.m.tag_id	1	100.00	Using where

Perfil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.04 ms
checking privileges on cached	0.03 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
sending cached result to clien	0.04 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
13	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:662
12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_latest/helper.php:113
11	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
10	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.54 ms Después de la última consulta: 0.42 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 16.180 MB Filas devueltas: 0

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

  FROM `portal_contentitem_tag_map` AS m 

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

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

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_tag_type	No pudo usarse una clave de índice	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	qtx295.m.tag_id	1	100.00	Using where

Perfil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.03 ms
checking privileges on cached	0.02 ms
checking permissions	0.05 ms
checking permissions	0.02 ms
sending cached result to clien	0.04 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
13	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:662
12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_latest/helper.php:113
11	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
10	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

28 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

4 × SELECT `m`.`tag_id`,`t`.* 
  FROM `portal_contentitem_tag_map` AS m  
  INNER JOIN `portal_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

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

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 portal_categories as c 
  LEFT JOIN portal_categories AS s 
  ON (s.lft < c.lft 
  AND s.rgt > c.rgt 
  AND c.language in ('es-ES','*')) OR (s.lft >= c.lft 
  AND s.rgt <= c.rgt)

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

1 × SELECT MAX(contact.id) AS contactid, contact.alias, contact.catid 
  FROM `portal_contact_details` AS `contact`

1 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state 
  FROM portal_fields AS a 
  LEFT JOIN `portal_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN portal_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN portal_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN portal_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN portal_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `portal_fields_categories` AS fc 
  ON fc.field_id = a.id

1 × SELECT a.id, a.title, a.catid, a.language, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug 
  FROM portal_content AS a 
  LEFT JOIN portal_categories AS cc 
  ON cc.id = a.catid

1 × SELECT `alias` 
  FROM `portal_content`

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,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,
  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 portal_content AS a 
  LEFT JOIN portal_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN portal_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN portal_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN portal_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN portal_content_rating AS v 
  ON a.id = v.content_id

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

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

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

1 × SELECT language,id 
  FROM `portal_menu`

```
1 × SELECT * 
  FROM portal_content
```

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` 
  FROM portal_extensions

1 × SELECT id, rules 
  FROM `portal_viewlevels

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

1 × SELECT `session_id` 
  FROM `portal_session`

```
1 × SELECT * 
  FROM portal_languages
```

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

1 × SELECT `data` 
  FROM `portal_session`

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

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM portal_menu AS m 
  LEFT JOIN portal_extensions AS e 
  ON m.component_id = e.extension_id

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

OTRAS tablas:

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

1 × SHOW FULL COLUMNS 
  FROM `portal_content

1 × UPDATE `portal_extensions` 
  SET `params` = '{\"mediaversion\":\"a9334ee8d9bfe6449f63005cee229422\"}'

1 × INSERT INTO `portal_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('4bshpu2e8skjacte030gecvps7', 1, '1503488588', 0, '', 0