La Plazuela

Back Está aquí: Home

NATURALEZA

Naturaleza

Cantidad a mostrar

Título	Autor	Visto
Sigüenza Starlight: por una ciudad abierta al cielo	Escrito por Javier Bussons	40
Aves protegidas: vencejos, golondrinas y aviones	Escrito por Javier Munilla	62
Una tropelía en la Alameda de Sigüenza	Escrito por Javier Munilla	139
El pequeño Yosemite y el dolor de la belleza	Escrito por Julio Álvarez	59
El nombre de los aires de Sigüenza	Escrito por Diego Moreno	165
Cigüeñas en Sigüenza	Escrito por Javier Munilla	211
Viajes en el tiempo III. Agujeros de gusano	Escrito por Luis Montalvo Guitart	180
Las jornadas micológicas de Sigüenza	Escrito por Javier Munilla	190
Viajes en el tiempo II. Mecánica contra Termodinámica	Escrito por Luis Montalvo Guitart	226
Viajes en el tiempo I. El Experimento Hawking	Escrito por Luis Montalvo Guitart	265

Página 1 de 9

Consola de depuración de Joomla!

Sesión

{"__default":{"session":{"counter":1,"timer":{"start":1498608563,"last":1498608563,"now":1498608563}},"registry":{"separator":"."},"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}},"__easycalccheck":{"redirect_url":null}}

Información del perfil

Fecha y hora

Memoria

Fecha y hora: 12.73 ms / 12.73 ms Memoria: 1.163 MB / 1.77 MB Application: afterLoad

Fecha y hora: 70.93 ms / 83.66 ms Memoria: 8.439 MB / 10.21 MB Application: afterInitialise

Fecha y hora: 53.09 ms / 136.75 ms Memoria: 5.609 MB / 15.82 MB Application: afterRoute

Fecha y hora: 1.99 ms / 138.74 ms Memoria: 0.035 MB / 15.85 MB Application: beforeRenderComponent com_content

Fecha y hora: 13.69 ms / 152.43 ms Memoria: 1.750 MB / 17.60 MB Application: Start JAccess::getAssetRules Old (1)

Fecha y hora: 1.21 ms / 153.64 ms Memoria: 0.086 MB / 17.69 MB Application: Finish JAccess::getAssetRules Old (1)

Fecha y hora: 0.07 ms / 153.71 ms Memoria: 0.000 MB / 17.68 MB Application: New JAccess Preloading Process(com_content.category)

Fecha y hora: 9.75 ms / 163.47 ms Memoria: 1.645 MB / 19.33 MB Application: After preloadPermissionsParentIdMapping (com_content.category)

Fecha y hora: 23.95 ms / 187.42 ms Memoria: 2.519 MB / 21.85 MB Application: After preloadPermissions (com_content.category)

Fecha y hora: 0.06 ms / 187.47 ms Memoria: 0.002 MB / 21.85 MB Application: End New JAccess Preloading Process(com_content.category)

Fecha y hora: 0.07 ms / 187.54 ms Memoria: 0.002 MB / 21.85 MB Application: Start JAccess::getAssetRules New (com_content.category.147)

Fecha y hora: 0.24 ms / 187.78 ms Memoria: 0.012 MB / 21.86 MB Application: Finish JAccess::getAssetRules New (com_content.category.147)

Fecha y hora: 16.37 ms / 204.15 ms Memoria: 0.514 MB / 22.38 MB Application: Start JAccess::preload(components)

Fecha y hora: 7.54 ms / 211.69 ms Memoria: 0.467 MB / 22.84 MB Application: Finish JAccess::preload(components)

Fecha y hora: 64.22 ms / 275.91 ms Memoria: 3.159 MB / 26.00 MB Application: afterRenderComponent com_content

Fecha y hora: 0.62 ms / 276.53 ms Memoria: 0.003 MB / 26.00 MB Application: afterDispatch

Fecha y hora: 33.34 ms / 309.87 ms Memoria: 0.842 MB / 26.85 MB Application: beforeRenderModule mod_dchtml (DC Joomla HTML Module)

Fecha y hora: 1.07 ms / 310.94 ms Memoria: 0.066 MB / 26.91 MB Application: afterRenderModule mod_dchtml (DC Joomla HTML Module)

Fecha y hora: 0.27 ms / 311.21 ms Memoria: 0.000 MB / 26.91 MB Application: beforeRenderModule mod_bannerslider (Publicidad_no_home)

Fecha y hora: 8.88 ms / 320.09 ms Memoria: 0.390 MB / 27.30 MB Application: afterRenderModule mod_bannerslider (Publicidad_no_home)

Fecha y hora: 1.04 ms / 321.13 ms Memoria: 0.000 MB / 27.28 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Fecha y hora: 2.11 ms / 323.24 ms Memoria: 0.039 MB / 27.32 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Fecha y hora: 2.53 ms / 325.76 ms Memoria: 0.181 MB / 27.50 MB Application: beforeRenderModule mod_search (Search)

Fecha y hora: 1.79 ms / 327.56 ms Memoria: 0.024 MB / 27.53 MB Application: afterRenderModule mod_search (Search)

Fecha y hora: 44.57 ms / 372.12 ms Memoria: 0.624 MB / 28.15 MB Application: afterRender

Total de consultas a la base de datos: 59.96 ms

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	otyj4_session	const	PRIMARY	PRIMARY	766	const	1

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
12	JSessionStorageDatabase->read()	Same as call in the line below.
11	session_start()	JROOT/libraries/joomla/session/handler/native.php:259
10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
6	JSession->start()	JROOT/libraries/cms/application/cms.php:773
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:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:790
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:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
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:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

'Explicar' no es posible en la consulta: INSERT INTO `otyj4_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('49c3948b98599243feffe95bab59ecd2', 0, 1, '1498608563', 0, '')

Perfil

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.00 ms
init	0.01 ms
update	0.07 ms
Waiting for query cache lock	0.00 ms
update	0.00 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Llamada de pila

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:212
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
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:408
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: 0.54 ms Después de la última consulta: 3.17 ms Consulta a la memoria: 0.012 MB memoria antes de la consulta: 5.875 MB Filas devueltas: 49

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

  FROM `otyj4_extensions`

  WHERE `type` = 'component'

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	otyj4_extensions	ref	extension	extension	82	const	38	Using where

Perfil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.22 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Llamada de pila

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
9	JDatabaseDriver->loadObjectList()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:589
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.32 ms Después de la última consulta: 2.38 ms Consulta a la memoria: 0.014 MB memoria antes de la consulta: 6.187 MB Filas devueltas: 1

SELECT b.id

  FROM otyj4_usergroups AS a

  LEFT JOIN otyj4_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	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	Using where

Perfil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Llamada de pila

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:835
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:904
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
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:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.18 ms Después de la última consulta: 0.86 ms Consulta a la memoria: 0.013 MB memoria antes de la consulta: 6.320 MB Filas devueltas: 5

SELECT id, rules

  FROM `otyj4_viewlevels`

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	otyj4_viewlevels	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	5

Perfil

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Llamada de pila

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:921
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
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:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.00 ms Después de la última consulta: 0.24 ms Consulta a la memoria: 0.011 MB memoria antes de la consulta: 6.339 MB Filas devueltas: 68

SELECT folder AS type, element AS name, params

  FROM otyj4_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	Extra
1	SIMPLE	otyj4_extensions	ref	extension	extension	82	const	144	Using where; Usando 'filesort'

Perfil

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.11 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.51 ms
Sending data	0.15 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Llamada de pila

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
7	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
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:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.90 ms Después de la última consulta: 33.32 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 10.603 MB Filas devueltas: 42

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

  LEFT JOIN otyj4_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	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	308	Using where; Usando 'filesort'
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	laplazue_2015.m.component_id	1

Perfil

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
System lock	0.01 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.97 ms
Sending data	0.31 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Llamada de pila

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1115
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.59 ms Después de la última consulta: 16.29 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 12.385 MB Filas devueltas: 1

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

  FROM `otyj4_extensions`

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

Explicar

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

Perfil

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.22 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Llamada de pila

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
18	JDatabaseDriver->loadObject()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
16	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
15	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
14	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
13	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
12	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
11	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
10	JFactory::getDocument()	JROOT/plugins/system/k2/k2.php:52
9	plgSystemK2->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.43 ms Después de la última consulta: 0.51 ms Consulta a la memoria: 0.017 MB memoria antes de la consulta: 12.367 MB

UPDATE `otyj4_extensions`

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

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

Explicar

'Explicar' no es posible en la consulta: UPDATE `otyj4_extensions` SET `params` = '{\"mediaversion\":\"d32fe3d35fae0a1bfd8ba3facd535e93\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Perfil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.18 ms
Updating	0.07 ms
end	0.00 ms
Waiting for query cache lock	0.00 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Llamada de pila

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
14	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
13	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
12	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
11	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
10	JFactory::getDocument()	JROOT/plugins/system/k2/k2.php:52
9	plgSystemK2->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.24 ms Después de la última consulta: 3.81 ms Consulta a la memoria: 0.018 MB memoria antes de la consulta: 12.959 MB Filas devueltas: 1

SELECT *

  FROM otyj4_languages

  WHERE published=1

  ORDER BY ordering ASC

Explicar

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

Perfil

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.03 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Llamada de pila

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
13	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:329
12	JApplicationSite->getParams()	JROOT/components/com_k2/helpers/utilities.php:331
11	K2HelperUtilities::getParams()	JROOT/administrator/components/com_k2/helpers/html.php:56
10	K2HelperHTML::loadjQuery()	JROOT/plugins/system/k2/k2.php:55
9	plgSystemK2->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.46 ms Después de la última consulta: 3.32 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 13.445 MB Filas devueltas: 12

SELECT id, home, template, s.params

  FROM otyj4_template_styles as s

  LEFT JOIN otyj4_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	Extra
1	SIMPLE	s	ALL	idx_template	No pudo usarse una clave de índice	NULL	NULL	14	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	laplazue_2015.s.template,const	1	Using where

Perfil

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.15 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Llamada de pila

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
20	JApplicationSite->getTemplate()	JROOT/libraries/cms/html/html.php:339
19	JHtml::includeRelativeFiles()	JROOT/libraries/cms/html/html.php:684
18	JHtml::script()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/cms/html/html.php:237
16	JHtml::call()	JROOT/libraries/cms/html/html.php:139
15	JHtml::_()	JROOT/libraries/cms/html/behavior.php:64
14	JHtmlBehavior::framework()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/cms/html/html.php:237
12	JHtml::call()	JROOT/libraries/cms/html/html.php:139
11	JHtml::_()	JROOT/administrator/components/com_k2/helpers/html.php:71
10	K2HelperHTML::loadjQuery()	JROOT/plugins/system/k2/k2.php:55
9	plgSystemK2->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.47 ms Después de la última consulta: 19.95 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 15.772 MB Filas devueltas: 12

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

  FROM otyj4_modules AS m

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

  LEFT JOIN otyj4_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-06-28 00:09:23') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2017-06-28 00:09:23') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 524 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	range	PRIMARY,published,newsfeeds	published	6	NULL	47	Using where; Usando 'filesort'
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	laplazue_2015.m.module,const	1	Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	laplazue_2015.m.id	5	Using where; Using index

Perfil

Status	Duration
starting	0.13 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
System lock	0.01 ms
init	0.06 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.04 ms
executing	0.00 ms
Sorting result	0.26 ms
Sending data	0.63 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Llamada de pila

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jat3/jat3/core/joomla/modulehelper.php:382
17	JModuleHelper::_load()	JROOT/plugins/system/jat3/jat3/core/joomla/modulehelper.php:104
16	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
15	JDocumentHtml->countModules()	JROOT/plugins/system/jat3/jat3/core/template.php:1213
14	T3Template->countModules()	JROOT/plugins/system/jat3/jat3/core/template.php:710
13	T3Template->hasBlock()	JROOT/plugins/system/jat3/jat3/core/template.php:1081
12	T3Template->parseLayout()	JROOT/plugins/system/jat3/jat3/core/template.php:727
11	T3Template->loadLayout()	JROOT/plugins/system/jat3/jat3/core/framework.php:153
10	T3Framework::init_layout()	JROOT/plugins/system/jat3/jat3.php:276
9	plgSystemJAT3->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.96 ms Después de la última consulta: 14.86 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 17.496 MB Filas devueltas: 8

SHOW FULL COLUMNS 
  FROM `otyj4_assets`

Explicar

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

Perfil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.38 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.02 ms
checking permissions	0.04 ms
checking permissions	0.01 ms
checking permissions	0.01 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
Sending data	0.06 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.08 ms
closing tables	0.00 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Llamada de pila

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
21	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
20	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
19	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
18	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
17	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
15	JUser->authorise()	JROOT/components/com_content/models/category.php:142
14	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
13	JModelLegacy->getState()	JROOT/plugins/system/jat3/jat3/core/joomla/viewlegacy.php:348
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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.23 ms Después de la última consulta: 0.98 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 17.584 MB Filas devueltas: 1

SELECT *

  FROM otyj4_assets

  WHERE `id` = '1'

Explicar

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

Perfil

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Llamada de pila

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
19	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
18	JTable->load()	JROOT/libraries/joomla/access/access.php:697
17	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
15	JUser->authorise()	JROOT/components/com_content/models/category.php:142
14	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
13	JModelLegacy->getState()	JROOT/plugins/system/jat3/jat3/core/joomla/viewlegacy.php:348
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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.34 ms Después de la última consulta: 0.34 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 17.605 MB Filas devueltas: 1

SELECT a.rules

  FROM otyj4_assets AS a

  WHERE (a.id = 1 OR a.name = 'root.1')

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	Using union(PRIMARY,idx_asset_name); Using where

Perfil

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.13 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Llamada de pila

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
17	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
15	JUser->authorise()	JROOT/components/com_content/models/category.php:142
14	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
13	JModelLegacy->getState()	JROOT/plugins/system/jat3/jat3/core/joomla/viewlegacy.php:348
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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.14 ms Después de la última consulta: 0.94 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 17.684 MB Filas devueltas: 2084

SELECT a.id, a.parent_id

  FROM otyj4_assets AS a

  WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1)

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	PRIMARY,idx_asset_name	No pudo usarse una clave de índice	NULL	NULL	2314	Using where

Perfil

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	2.79 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Llamada de pila

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:332
18	JAccess::preloadPermissionsParentIdMapping()	JROOT/libraries/joomla/access/access.php:240
17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
16	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
15	JUser->authorise()	JROOT/components/com_content/models/category.php:142
14	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
13	JModelLegacy->getState()	JROOT/plugins/system/jat3/jat3/core/joomla/viewlegacy.php:348
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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.46 ms Después de la última consulta: 7.11 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 19.361 MB Filas devueltas: 2084

SELECT a.id, a.name, a.rules

  FROM otyj4_assets AS a

  WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1 )

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	PRIMARY,idx_asset_name	No pudo usarse una clave de índice	NULL	NULL	2314	Using where

Perfil

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.04 ms
statistics	0.10 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	2.98 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Llamada de pila

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1255
19	JDatabaseDriver->getIterator()	JROOT/libraries/joomla/access/access.php:373
18	JAccess::preloadPermissions()	JROOT/libraries/joomla/access/access.php:243
17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
16	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
15	JUser->authorise()	JROOT/components/com_content/models/category.php:142
14	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
13	JModelLegacy->getState()	JROOT/plugins/system/jat3/jat3/core/joomla/viewlegacy.php:348
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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: 10.50 ms Después de la última consulta: 23.00 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 22.057 MB Filas devueltas: 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,COUNT(i.`id`) AS numitems

  FROM otyj4_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM otyj4_categories AS cat JOIN otyj4_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  LEFT JOIN otyj4_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  LEFT JOIN `otyj4_content` AS i 
  ON i.`catid` = c.id 
  AND i.state = 1

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=147

  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	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Usando 'filesort'
1	PRIMARY	c	range	cat_idx,idx_access,idx_left_right	cat_idx	208	NULL	22	Using where
1	PRIMARY	i	ref	idx_state,idx_catid	idx_catid	4	laplazue_2015.c.id	34
1	PRIMARY	<derived2>	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	111	Using where; Not exists
2	DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	202		111	Using where; Using temporary; Usando 'filesort'
2	DERIVED	cat	range	idx_left_right	idx_left_right	4	NULL	1	Range checked for each record (index map: 0x10)

Perfil

Status	Duration
starting	0.27 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
System lock	0.10 ms
optimizing	0.03 ms
statistics	0.37 ms
preparing	0.03 ms
Creating tmp table	0.03 ms
executing	0.01 ms
Copying to tmp table	3.14 ms
Sorting result	0.03 ms
Sending data	0.03 ms
removing tmp table	0.01 ms
Sending data	0.01 ms
init	0.09 ms
optimizing	0.03 ms
statistics	0.35 ms
preparing	0.08 ms
Creating tmp table	0.45 ms
executing	0.00 ms
Copying to tmp table	5.02 ms
Sorting result	0.02 ms
Sending data	0.05 ms
end	0.01 ms
removing tmp table	0.09 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.00 ms
closing tables	0.02 ms
freeing items	0.04 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Llamada de pila

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
15	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
14	JCategories->get()	JROOT/components/com_content/models/category.php:354
13	ContentModelCategory->getCategory()	JROOT/plugins/system/jat3/jat3/core/joomla/viewlegacy.php:348
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:115
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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.57 ms Después de la última consulta: 3.39 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 22.370 MB Filas devueltas: 49

SELECT element

  FROM otyj4_extensions

  WHERE type = 'component' 
  AND enabled = '1'

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	otyj4_extensions	ref	extension	extension	82	const	38	Using where

Perfil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.10 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.22 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Llamada de pila

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
22	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:413
21	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
20	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
19	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
18	JUser->authorise()	JROOT/components/com_content/models/articles.php:466
17	ContentModelArticles->getListQuery()	JROOT/libraries/legacy/model/list.php:129
16	JModelList->_getListQuery()	JROOT/libraries/legacy/model/list.php:183
15	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/jat3/jat3/core/joomla/viewlegacy.php:348
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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.63 ms Después de la última consulta: 0.56 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 22.409 MB Filas devueltas: 46

SELECT a.name, a.rules

  FROM otyj4_assets AS a

  WHERE (a.name IN ('com_acymailing','com_admin','com_advertisementboard','com_ajax','com_authorlist','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_easy_youtube_gallery','com_finder','com_incapsula','com_installer','com_jaextmanager','com_jce','com_jce','com_jckman','com_joomlaupdate','com_jumi','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_mijopolls','com_mijopolls','com_modules','com_newsfeeds','com_oziogallery3','com_oziogallery3','com_plugins','com_postinstall','com_rantispam','com_redirect','com_search','com_sexypolling','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_youtubegallery') OR a.name = 'root.1')

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	range	idx_asset_name	idx_asset_name	202	NULL	47	Using where

Perfil

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.05 ms
optimizing	0.01 ms
statistics	0.22 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	1.13 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Llamada de pila

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
22	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
21	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
20	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
19	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
18	JUser->authorise()	JROOT/components/com_content/models/articles.php:466
17	ContentModelArticles->getListQuery()	JROOT/libraries/legacy/model/list.php:129
16	JModelList->_getListQuery()	JROOT/libraries/legacy/model/list.php:183
15	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/jat3/jat3/core/joomla/viewlegacy.php:348
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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: 9.83 ms Después de la última consulta: 4.75 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 22.830 MB Filas devueltas: 10

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 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,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  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,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published

  FROM otyj4_content AS a

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

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

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

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

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

  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM otyj4_categories AS cat JOIN otyj4_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id ) AS badcats 
  ON badcats.id = c.id

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND a.catid = 147 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-06-28 00:09:23') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-06-28 00:09:23')

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

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	v	system	PRIMARY	No pudo usarse una clave de índice	NULL	NULL	0	const row not found
1	PRIMARY	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	Using temporary; Usando 'filesort'
1	PRIMARY	a	ref	idx_access,idx_catid	idx_catid	4	const	79	Using where
1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	laplazue_2015.a.created_by	1
1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	laplazue_2015.a.modified_by	1
1	PRIMARY	<derived2>	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	111	Using where
1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	const	1
2	DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	202		111	Using where; Using temporary; Usando 'filesort'
2	DERIVED	cat	range	idx_left_right	idx_left_right	4	NULL	1	Range checked for each record (index map: 0x10)

Perfil

Status	Duration
starting	0.24 ms
checking permissions	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
System lock	0.06 ms
optimizing	0.01 ms
statistics	0.27 ms
preparing	0.02 ms
Creating tmp table	0.02 ms
executing	0.00 ms
Copying to tmp table	3.07 ms
Sorting result	0.03 ms
Sending data	0.02 ms
removing tmp table	0.01 ms
Sending data	0.01 ms
init	0.10 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.04 ms
Creating tmp table	0.41 ms
executing	0.00 ms
Copying to tmp table	4.33 ms
Sorting result	0.27 ms
Sending data	0.29 ms
end	0.01 ms
removing tmp table	0.24 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.00 ms
closing tables	0.02 ms
freeing items	0.03 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Llamada de pila

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:310
16	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:183
15	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/jat3/jat3/core/joomla/viewlegacy.php:348
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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.57 ms Después de la última consulta: 3.53 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 23.311 MB Filas devueltas: 0

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

  FROM `otyj4_contentitem_tag_map` AS m 

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

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

Explicar

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

Perfil

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
System lock	0.01 ms
init	0.05 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.14 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Llamada de pila

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
15	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/jat3/jat3/core/joomla/viewlegacy.php:348
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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.40 ms Después de la última consulta: 0.76 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 23.352 MB Filas devueltas: 0

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

  FROM `otyj4_contentitem_tag_map` AS m 

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

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

Explicar

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

Perfil

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.15 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Llamada de pila

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
15	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/jat3/jat3/core/joomla/viewlegacy.php:348
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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.30 ms Después de la última consulta: 0.67 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 23.392 MB Filas devueltas: 0

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

  FROM `otyj4_contentitem_tag_map` AS m 

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

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

Explicar

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

Perfil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Llamada de pila

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
15	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/jat3/jat3/core/joomla/viewlegacy.php:348
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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.30 ms Después de la última consulta: 0.71 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 23.433 MB Filas devueltas: 0

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

  FROM `otyj4_contentitem_tag_map` AS m 

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

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

Explicar

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

Perfil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Llamada de pila

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
15	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/jat3/jat3/core/joomla/viewlegacy.php:348
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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.29 ms Después de la última consulta: 0.65 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 23.473 MB Filas devueltas: 0

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

  FROM `otyj4_contentitem_tag_map` AS m 

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

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

Explicar

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

Perfil

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Llamada de pila

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
15	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/jat3/jat3/core/joomla/viewlegacy.php:348
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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.28 ms Después de la última consulta: 0.66 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 23.514 MB Filas devueltas: 0

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

  FROM `otyj4_contentitem_tag_map` AS m 

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

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

Explicar

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

Perfil

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Llamada de pila

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
15	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/jat3/jat3/core/joomla/viewlegacy.php:348
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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.28 ms Después de la última consulta: 0.69 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 23.554 MB Filas devueltas: 0

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

  FROM `otyj4_contentitem_tag_map` AS m 

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

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

Explicar

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

Perfil

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Llamada de pila

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
15	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/jat3/jat3/core/joomla/viewlegacy.php:348
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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.28 ms Después de la última consulta: 0.66 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 23.594 MB Filas devueltas: 0

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

  FROM `otyj4_contentitem_tag_map` AS m 

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

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

Explicar

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

Perfil

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Llamada de pila

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
15	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/jat3/jat3/core/joomla/viewlegacy.php:348
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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.29 ms Después de la última consulta: 0.64 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 23.635 MB Filas devueltas: 0

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

  FROM `otyj4_contentitem_tag_map` AS m 

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

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

Explicar

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

Perfil

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Llamada de pila

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
15	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/jat3/jat3/core/joomla/viewlegacy.php:348
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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.29 ms Después de la última consulta: 0.69 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 23.676 MB Filas devueltas: 0

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

  FROM `otyj4_contentitem_tag_map` AS m 

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

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

Explicar

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

Perfil

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Llamada de pila

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
15	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/jat3/jat3/core/joomla/viewlegacy.php:348
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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: 5.21 ms Después de la última consulta: 2.06 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 23.898 MB Filas devueltas: 1

SELECT COUNT(*)

  FROM otyj4_content AS a

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

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

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

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

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

  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM otyj4_categories AS cat JOIN otyj4_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id ) AS badcats 
  ON badcats.id = c.id

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND a.catid = 147 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-06-28 00:09:23') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-06-28 00:09:23')

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	v	system	PRIMARY	No pudo usarse una clave de índice	NULL	NULL	0	const row not found
1	PRIMARY	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
1	PRIMARY	a	ref	idx_access,idx_catid	idx_catid	4	const	79	Using where
1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	laplazue_2015.a.created_by	1	Using index
1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	laplazue_2015.a.modified_by	1	Using index
1	PRIMARY	<derived2>	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	111	Using where
1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using index
2	DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	202		111	Using where; Using temporary; Usando 'filesort'
2	DERIVED	cat	range	idx_left_right	idx_left_right	4	NULL	1	Range checked for each record (index map: 0x10)

Perfil

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
System lock	0.06 ms
optimizing	0.01 ms
statistics	0.29 ms
preparing	0.02 ms
Creating tmp table	0.02 ms
executing	0.00 ms
Copying to tmp table	2.65 ms
Sorting result	0.03 ms
Sending data	0.03 ms
removing tmp table	0.01 ms
Sending data	0.00 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.06 ms
executing	0.01 ms
Sending data	1.61 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Llamada de pila

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
17	JDatabaseDriver->loadResult()	JROOT/libraries/legacy/model/legacy.php:337
16	JModelLegacy->_getListCount()	JROOT/libraries/legacy/model/list.php:278
15	JModelList->getTotal()	JROOT/libraries/legacy/model/list.php:228
14	JModelList->getPagination()	JROOT/components/com_content/models/category.php:265
13	ContentModelCategory->getItems()	JROOT/plugins/system/jat3/jat3/core/joomla/viewlegacy.php:348
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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.29 ms Después de la última consulta: 0.63 ms Consulta a la memoria: 0.018 MB memoria antes de la consulta: 23.905 MB Filas devueltas: 0

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

  FROM `otyj4_contentitem_tag_map` AS m 

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

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

Explicar

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

Perfil

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Llamada de pila

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
12	JHelperTags->getItemTags()	JROOT/libraries/legacy/view/category.php:217
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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.91 ms Después de la última consulta: 21.60 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 26.130 MB Filas devueltas: 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 otyj4_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM otyj4_categories AS cat JOIN otyj4_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  LEFT JOIN otyj4_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) 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 badcats.id is null 
  AND s.id=147

  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	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Usando 'filesort'
1	PRIMARY	c	range	cat_idx,idx_access,idx_left_right	cat_idx	208	NULL	22	Using where
1	PRIMARY	<derived2>	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	111	Using where; Not exists
2	DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	202		111	Using where; Using temporary; Usando 'filesort'
2	DERIVED	cat	range	idx_left_right	idx_left_right	4	NULL	1	Range checked for each record (index map: 0x10)

Perfil

Status	Duration
starting	0.23 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
System lock	0.09 ms
optimizing	0.02 ms
statistics	0.31 ms
preparing	0.03 ms
Creating tmp table	0.02 ms
executing	0.00 ms
Copying to tmp table	2.60 ms
Sorting result	0.03 ms
Sending data	0.03 ms
removing tmp table	0.01 ms
Sending data	0.01 ms
init	0.07 ms
optimizing	0.02 ms
statistics	0.29 ms
preparing	0.03 ms
Creating tmp table	0.41 ms
executing	0.00 ms
Copying to tmp table	0.30 ms
Sorting result	0.02 ms
Sending data	0.04 ms
end	0.00 ms
removing tmp table	0.10 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Llamada de pila

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
19	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
18	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
17	ContentHelperRoute::getArticleRoute()	JROOT/plugins/system/jat3/jat3/base-themes/default/html/com_content/category/default_articles.php:103
16	include JROOT/plugins/system/jat3/jat3/base-themes/default/html/com_content/category/default_articles.php	JROOT/plugins/system/jat3/jat3/core/joomla/viewlegacy.php:582
15	JViewLegacy->loadTemplate()	JROOT/templates/ja_teline_iv/html/com_content/category/default.php:57
14	include JROOT/templates/ja_teline_iv/html/com_content/category/default.php	JROOT/plugins/system/jat3/jat3/core/joomla/viewlegacy.php:582
13	JViewLegacy->loadTemplate()	JROOT/plugins/system/jat3/jat3/core/joomla/viewlegacy.php:180
12	JViewLegacy->display()	JROOT/libraries/legacy/view/category.php:233
11	JViewCategory->display()	JROOT/components/com_content/views/category/view.html.php:258
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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: 5.24 ms Después de la última consulta: 21.44 ms Consulta a la memoria: 0.018 MB memoria antes de la consulta: 26.785 MB Filas devueltas: 1

SELECT `created` 
  FROM otyj4_content a 
  ORDER BY `created` DESC 
  LIMIT 1

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	1859	Usando 'filesort'

Perfil

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	4.76 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.03 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Llamada de pila

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
13	JDatabaseDriver->loadObject()	JROOT/plugins/system/jat3/jat3/core/common.php:1244
12	T3Common::getLastUpdate()	JROOT/templates/ja_teline_iv/blocks/topbar.php:27
11	include JROOT/templates/ja_teline_iv/blocks/topbar.php	JROOT/plugins/system/jat3/jat3/core/template.php:346
10	T3Template->loadBlock()	JROOT/plugins/system/jat3/jat3/core/template.php:312
9	T3Template->loadBlocks()	JROOT/plugins/system/jat3/jat3/core/template.php:742
8	T3Template->render()	JROOT/templates/ja_teline_iv/index.php:7
7	require JROOT/templates/ja_teline_iv/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
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.45 ms Después de la última consulta: 17.19 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 27.099 MB Filas devueltas: 0

SELECT *

  FROM otyj4_banners

  WHERE '2017-06-28 00:09:23' >= 'reset' 
  AND `reset` != '0000-00-00 00:00:00' 
  AND `reset`!= NULL 
  AND (`checked_out` = 0 OR `checked_out` = 0)

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	Impossible WHERE

Perfil

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
System lock	0.02 ms
init	0.07 ms
optimizing	0.02 ms
executing	0.03 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Llamada de pila

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_banners/helpers/banners.php:79
15	BannersHelper::updateReset()	JROOT/modules/mod_bannerslider/mod_bannerslider.php:22
14	require JROOT/modules/mod_bannerslider/mod_bannerslider.php	JROOT/plugins/system/jat3/jat3/core/joomla/modulehelper.php:188
13	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
12	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
11	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
10	JDocumentHtml->getBuffer()	JROOT/plugins/system/jat3/jat3/core/template.php:1676
9	T3Template->getBuffer()	JROOT/plugins/system/jat3/jat3/core/template.php:795
8	T3Template->render()	JROOT/templates/ja_teline_iv/index.php:7
7	require JROOT/templates/ja_teline_iv/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
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.17 ms Después de la última consulta: 1.25 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 27.236 MB Filas devueltas: 10

SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions

  FROM otyj4_banners as a

  LEFT JOIN otyj4_banner_clients AS cl 
  ON cl.id = a.cid

  WHERE a.state=1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-06-28 00:09:23') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-06-28 00:09:23') 
  AND (a.imptotal = 0 OR a.impmade <= a.imptotal) 
  AND a.catid IN (161)

  ORDER BY a.sticky DESC, RAND()  
  LIMIT 10

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_banner_catid	idx_state	1	const	27	Using where; Using temporary; Usando 'filesort'
1	SIMPLE	cl	eq_ref	PRIMARY	PRIMARY	4	laplazue_2015.a.cid	1

Perfil

Status	Duration
starting	0.09 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.03 ms
Creating tmp table	0.32 ms
executing	0.00 ms
Copying to tmp table	0.25 ms
Sorting result	0.05 ms
Sending data	0.05 ms
end	0.00 ms
removing tmp table	0.09 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Llamada de pila

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:310
18	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:183
17	JModelList->getItems()	JROOT/components/com_banners/models/banners.php:205
16	BannersModelBanners->getItems()	JROOT/modules/mod_bannerslider/helper.php:36
15	modWalkswithmeBannerSlider::getList()	JROOT/modules/mod_bannerslider/mod_bannerslider.php:23
14	require JROOT/modules/mod_bannerslider/mod_bannerslider.php	JROOT/plugins/system/jat3/jat3/core/joomla/modulehelper.php:188
13	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
12	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
11	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
10	JDocumentHtml->getBuffer()	JROOT/plugins/system/jat3/jat3/core/template.php:1676
9	T3Template->getBuffer()	JROOT/plugins/system/jat3/jat3/core/template.php:795
8	T3Template->render()	JROOT/templates/ja_teline_iv/index.php:7
7	require JROOT/templates/ja_teline_iv/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
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.40 ms Después de la última consulta: 0.53 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 27.307 MB

UPDATE otyj4_banners

  SET impmade = (impmade + 1)

  WHERE id IN (37,13,32,58,42,53,24,15,12,18)

Explicar

'Explicar' no es posible en la consulta: UPDATE otyj4_banners SET impmade = (impmade + 1) WHERE id IN (37,13,32,58,42,53,24,15,12,18)

Perfil

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.00 ms
init	0.04 ms
Updating	0.21 ms
end	0.00 ms
Waiting for query cache lock	0.00 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Llamada de pila

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/components/com_banners/models/banners.php:246
16	BannersModelBanners->impress()	JROOT/modules/mod_bannerslider/helper.php:37
15	modWalkswithmeBannerSlider::getList()	JROOT/modules/mod_bannerslider/mod_bannerslider.php:23
14	require JROOT/modules/mod_bannerslider/mod_bannerslider.php	JROOT/plugins/system/jat3/jat3/core/joomla/modulehelper.php:188
13	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
12	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
11	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
10	JDocumentHtml->getBuffer()	JROOT/plugins/system/jat3/jat3/core/template.php:1676
9	T3Template->getBuffer()	JROOT/plugins/system/jat3/jat3/core/template.php:795
8	T3Template->render()	JROOT/templates/ja_teline_iv/index.php:7
7	require JROOT/templates/ja_teline_iv/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
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.]

29 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

11 × SELECT `m`.`tag_id`,`t`.* 
  FROM `otyj4_contentitem_tag_map` AS m  
  INNER JOIN `otyj4_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

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

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 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,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  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,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published 
  FROM otyj4_content AS a 
  LEFT JOIN otyj4_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN otyj4_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN otyj4_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN otyj4_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN otyj4_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM otyj4_categories AS cat JOIN otyj4_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT a.name, a.rules 
  FROM otyj4_assets AS a

1 × SELECT element 
  FROM otyj4_extensions

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

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

1 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions 
  FROM otyj4_banners as a 
  LEFT JOIN otyj4_banner_clients AS cl 
  ON cl.id = a.cid

```
1 × SELECT * 
  FROM otyj4_banners
```

1 × SELECT `created` 
  FROM otyj4_content a

1 × SELECT a.id, a.name, a.rules 
  FROM otyj4_assets AS a

1 × SELECT COUNT(*) 
  FROM otyj4_content AS a 
  LEFT JOIN otyj4_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN otyj4_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN otyj4_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN otyj4_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN otyj4_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM otyj4_categories AS cat JOIN otyj4_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT a.rules 
  FROM otyj4_assets AS a

1 × SELECT folder AS type, element AS name, params 
  FROM otyj4_extensions

1 × SELECT id, rules 
  FROM `otyj4_viewlevels

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

1 × SELECT `session_id` 
  FROM `otyj4_session`

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

```
1 × SELECT * 
  FROM otyj4_languages
```

1 × SELECT `data` 
  FROM `otyj4_session`

```
1 × SELECT * 
  FROM otyj4_assets
```

1 × SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM otyj4_modules AS m 
  LEFT JOIN otyj4_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN otyj4_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

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

1 × SELECT a.id, a.parent_id 
  FROM otyj4_assets AS a

OTRAS tablas:

1 × UPDATE otyj4_banners 
  SET impmade = (impmade + 1)

1 × SHOW FULL COLUMNS 
  FROM `otyj4_assets

1 × UPDATE `otyj4_extensions` 
  SET `params` = '{\"mediaversion\":\"d32fe3d35fae0a1bfd8ba3facd535e93\"}'

1 × INSERT INTO `otyj4_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  ('49c3948b98599243feffe95bab59ecd2', 0, 1, '1498608563', 0, ''

```
1 × DELETE  
  FROM `otyj4_session`
```

La Plazuela

Consola de depuración de Joomla!

Sesión

Información del perfil

Fecha y hora

Memoria

Uso de la memoria

Consultas de la base de datos

40 consultas registradas 59.96 ms

29 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

OTRAS tablas: