Protagonistas del Elche-Albacete: hablan Rubén Cruz, Juan Carlos y Javi Paredes

Detalles: Creado: Domingo, 01 Mayo 2016 21:02; Escrito por Redacción-A11/Foto: Josema Moreno

Rubén Cruz regresaba al once inicial y valoraba positivamente el punto conseguido ante el Elche

RUBÉN CRUZ: "Con lo que hay que quedarse es con que nos llevamos un punto muy valioso"

El atacante del Albacete reconocía que habían tuteado al Elche: "Ha sido un partido disputado hasta el final. Ha sido un encuentro de tú a tú en donde los dos equipos han ido a por el partido y el punto es positivo, que es con lo que nos tenemos que quedar".

Cruz se mostraba satisfecho por haber regresado al once inicial: "Estoy contento por la titularidad porque llevaba ya varias jornadas luchando por ella y espero que haya servido para ayudar al equipo".

JUAN CARLOS SÁNCHEZ: "Hay que sufrir hasta el final"

El guardameta Juan Carlos concluía que el punto había sido satisfactorio: "Nos hubiera gustado ganar, los tres puntos eran gloria pero conforme se ha dado la situación el punto es bueno. Lo mejoraremos ganando en casa al Mallorca. No hay tiempo para disfrutarlo ni para mucho más. El tiempo que tenemos es para los que han jugado recuperarse al máximo y para los que no, apretar el culo y entrenar duro. Hay que sufrir hasta el final".

En opinión del mallorquin, no era momento de echar de menos a los ausentes: "Las bajas no ayudan pero no hay que lamentarse ni llorar porque hay plantilla y los que han salido han dado la talla. Hay que dar el punto por bueno".

Habló de su pasado ilicitano: "En Elche estuve un año, habrá gente que me quiera y gente que no pero estuve bien. Es muy especial para mí y estoy feliz porque me trataron bien y estuve fenomenal".

JAVIER PAREDES: "Nos quedamos con un poco mal sabor de boca"

El ex del Zaragoza Javier Paredes valoraba muy positivamente el punto: "Recortamos distancias con los que están por arriba. Hicimos méritos pero el empate es justo por cómo acabó el partido. Nos quedamos con un poco mal sabor de boca porque con 10 combinamos más y piensas que puedes conseguir la victoria. El equipo estuvo bien ante un rival que está peleando por meterse arriba y era fuera de casa. Lo importante es no perder comba con la gente".

El ovetense apuntaba que el partido clave era ante el Mallorca: "Si ganamos habrá partidos más importantes pero el de Mallorca es el partido clave. Estaría encantado de ver lleno el Belmonte y que la gente estuviera enchufada desde el inicio. Si ganamos habrá muchas posibilidades de salir y meternos en la pomada".

Clasificación

Segunda División B 2016-2017

Pos.	Equipo	PJ	PTS
1	ALBA	38	69
2	Toledo	38	65
3	Fuenlabrada	38	63
4	Majadahonda	38	61
5	Leioa	38	60
6	Logroñés	38	56
7	Real Unión	38	56
8	Athletic B	38	56
9	Arenas	38	55
10	R.Sociedad B	38	52
11	R.Madrid B	38	51
12	Gernika	38	49
13	Barakaldo	38	49
14	Amorebieta	38	48
15	Navalcarnero	38	47
16	Sanse	38	47
17	Mensajero	38	46
18	Socuéllamos	38	38
19	Sestao	38	37
20	Zamudio	38	22

Mostrar Clasificación Completa

A estas alturas

Strict Standards: Non-static method modJLG_a_estas_alturas::getData() should not be called statically in /home/juanlux/domains/quesomecanico.com/public_html/web/modules/mod_a_estas_alturas/mod_a_estas_alturas.php on line 23

Strict Standards: Only variables should be assigned by reference in /home/juanlux/domains/quesomecanico.com/public_html/web/modules/mod_a_estas_alturas/helper.php on line 46

Strict Standards: Only variables should be assigned by reference in /home/juanlux/domains/quesomecanico.com/public_html/web/modules/mod_a_estas_alturas/helper.php on line 49

Strict Standards: Non-static method modJLG_a_estas_alturas::getRoundCode() should not be called statically in /home/juanlux/domains/quesomecanico.com/public_html/web/modules/mod_a_estas_alturas/helper.php on line 57

Strict Standards: Only variables should be assigned by reference in /home/juanlux/domains/quesomecanico.com/public_html/web/modules/mod_a_estas_alturas/helper.php on line 187

Strict Standards: Only variables should be assigned by reference in /home/juanlux/domains/quesomecanico.com/public_html/web/modules/mod_a_estas_alturas/helper.php on line 114

Strict Standards: Only variables should be assigned by reference in /home/juanlux/domains/quesomecanico.com/public_html/web/modules/mod_a_estas_alturas/helper.php on line 117

Strict Standards: Non-static method modJLG_a_estas_alturas::getRoundId_Jornada() should not be called statically in /home/juanlux/domains/quesomecanico.com/public_html/web/modules/mod_a_estas_alturas/helper.php on line 118

Strict Standards: Only variables should be assigned by reference in /home/juanlux/domains/quesomecanico.com/public_html/web/modules/mod_a_estas_alturas/helper.php on line 205

JORNADA Nº 38
Segunda División B 2016-2017
Posición: 1º    Puntos: 69
GF: 64     GC: 36

Segunda División B 2013-2014
Posición: 1º    Puntos: 82
GF: 62     GC: 30

Colaboraciones

Consola de depuración de Joomla!

Sesión

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1498429810,
                "last": 1498429810,
                "now": 1498429810
            },
            "token": "JR07LMOVCi3PPgaLsDASCHzaSrKLvNiO"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "gantry-current-template": "rt_corvus",
        "com_mailto": {
            "links": {
                "56dc17f8b7f00d57cc4a86a0bd36be6f690c5948": {
                    "link": "https:\/\/www.quesomecanico.com\/web\/inicio\/hemeroteca\/101-ultimos-articulos\/3356-protagonistas-del-elche-albacete-hablan-ruben-cruz-juan-carlos-y-javi-paredes",
                    "expiry": 1498429810
                }
            }
        },
        "corvus-5c2b4a93551298954d4c43596e373b7c-name": null,
        "corvus-5c2b4a93551298954d4c43596e373b7c-logo-type": null,
        "corvus-5c2b4a93551298954d4c43596e373b7c-top-customtop-image": null,
        "corvus-5c2b4a93551298954d4c43596e373b7c-header-overlay": null,
        "corvus-5c2b4a93551298954d4c43596e373b7c-main-bg-overlay": null,
        "corvus-5c2b4a93551298954d4c43596e373b7c-main-template": null,
        "corvus-5c2b4a93551298954d4c43596e373b7c-main-body": null,
        "corvus-5c2b4a93551298954d4c43596e373b7c-footer-overlay": null,
        "corvus-5c2b4a93551298954d4c43596e373b7c-bottom-custombottom-image": null,
        "corvus-5c2b4a93551298954d4c43596e373b7c-font-family": null,
        "corvus-5c2b4a93551298954d4c43596e373b7c-font-size-is": null,
        "corvus-5c2b4a93551298954d4c43596e373b7c-menu-type": null,
        "corvus-5c2b4a93551298954d4c43596e373b7c-layout-mode": null
    }
}

Información del perfil

Fecha y hora

Memoria

Fecha y hora: 1.70 ms / 1.70 ms Memoria: 0.206 MB / 0.42 MB Application: afterLoad

Fecha y hora: 193.66 ms / 195.36 ms Memoria: 3.574 MB / 3.99 MB Application: afterInitialise

Fecha y hora: 16.28 ms / 211.64 ms Memoria: 0.845 MB / 4.84 MB Application: Before JAccess::preloadComponents (all components)

Fecha y hora: 0.95 ms / 212.59 ms Memoria: 0.109 MB / 4.95 MB Application: After JAccess::preloadComponents (all components)

Fecha y hora: 0.07 ms / 212.66 ms Memoria: 0.000 MB / 4.94 MB Application: Before JAccess::getAssetRules (id:16 name:com_menus)

Fecha y hora: 0.44 ms / 213.10 ms Memoria: 0.019 MB / 4.96 MB Application: After JAccess::getAssetRules (id:16 name:com_menus)

Fecha y hora: 2.59 ms / 215.69 ms Memoria: 0.053 MB / 5.01 MB Application: afterRoute

Fecha y hora: 32.81 ms / 248.50 ms Memoria: 0.184 MB / 5.20 MB Application: beforeRenderComponent com_content

Fecha y hora: 3.13 ms / 251.64 ms Memoria: 0.104 MB / 5.30 MB Application: Before JAccess::getAssetRules (id:8 name:com_content)

Fecha y hora: 0.12 ms / 251.76 ms Memoria: 0.010 MB / 5.31 MB Application: After JAccess::getAssetRules (id:8 name:com_content)

Fecha y hora: 145.11 ms / 396.87 ms Memoria: 2.765 MB / 8.08 MB Application: afterRenderComponent com_content

Fecha y hora: 19.97 ms / 416.84 ms Memoria: 0.359 MB / 8.44 MB Application: afterDispatch

Fecha y hora: 22.49 ms / 439.33 ms Memoria: 0.527 MB / 8.96 MB Application: beforeRenderModule mod_roknavmenu ()

Fecha y hora: 12.37 ms / 451.70 ms Memoria: 0.760 MB / 9.72 MB Application: afterRenderModule mod_roknavmenu ()

Fecha y hora: 11.24 ms / 462.94 ms Memoria: 0.107 MB / 9.83 MB Application: beforeRenderModule mod_a_estas_alturas (A estas alturas)

Fecha y hora: 116.96 ms / 579.90 ms Memoria: 0.738 MB / 10.57 MB Application: afterRenderModule mod_a_estas_alturas (A estas alturas)

Fecha y hora: 48.30 ms / 628.20 ms Memoria: 0.284 MB / 10.85 MB Application: afterRender

Total de consultas a la base de datos: 168.61 ms

Uso de la memoria

Consultas de la base de datos

54 consultas registradas 168.61 ms

¡ 19 duplicaciones detectadas!

2 duplicaciones: #6 #7

3 duplicaciones: #9 #22 #54

2 duplicaciones: #14 #16

2 duplicaciones: #19 #20

2 duplicaciones: #27 #33

2 duplicaciones: #34 #40

2 duplicaciones: #37 #38

2 duplicaciones: #43 #48

2 duplicaciones: #46 #47

Tiempo de la consulta: 0.34 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 0.930 MB Filas devueltas: 0

SELECT `data`

  FROM `joomla3_session`

  WHERE `session_id` = '8ele9qjf4g9mle109vr6jn7kp5'

Explicar

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

Perfil

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

Llamada de pila

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

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

Tiempo de la consulta: 0.21 ms Después de la última consulta: 0.56 ms Consulta a la memoria: 0.012 MB memoria antes de la consulta: 0.983 MB Filas devueltas: 0

SELECT `session_id`

  FROM `joomla3_session`

  WHERE `session_id` = '8ele9qjf4g9mle109vr6jn7kp5' 
  LIMIT 1

Explicar

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

Perfil

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

Llamada de pila

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

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

Tiempo de la consulta: 108.25 ms Después de la última consulta: 0.18 ms Consulta a la memoria: 0.009 MB memoria antes de la consulta: 0.999 MB

INSERT INTO `joomla3_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('8ele9qjf4g9mle109vr6jn7kp5', 1, '1498429810', 0, '', 0)

Explicar

'Explicar' no es posible en la consulta: INSERT INTO `joomla3_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('8ele9qjf4g9mle109vr6jn7kp5', 1, '1498429810', 0, '', 0)

Perfil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
update	0.09 ms
Waiting for query cache lock	0.01 ms
update	0.08 ms
end	0.00 ms
query end	107.94 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Llamada de pila

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

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

Tiempo de la consulta: 0.11 ms Después de la última consulta: 1.62 ms Consulta a la memoria: 0.015 MB memoria antes de la consulta: 1.178 MB Filas devueltas: 1

SELECT b.id

  FROM joomla3_usergroups AS a

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

  WHERE a.id = 1

Explicar

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

Perfil

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

Llamada de pila

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

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

Tiempo de la consulta: 0.08 ms Después de la última consulta: 0.16 ms Consulta a la memoria: 0.015 MB memoria antes de la consulta: 1.198 MB Filas devueltas: 5

SELECT id, rules

  FROM `joomla3_viewlevels`

Explicar

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

Perfil

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

Llamada de pila

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

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

Tiempo de la consulta: 0.17 ms Después de la última consulta: 16.26 ms Consulta a la memoria: 0.019 MB memoria antes de la consulta: 2.288 MB Filas devueltas: 1

Consultas duplicadas: #7

SELECT template

  FROM joomla3_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	ALL	idx_home	No pudo usarse una clave de índice	NULL	NULL	5	100.00	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
13	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:96
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:54
7	plgSystemRokCommon->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:682
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.08 ms Después de la última consulta: 0.14 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 2.307 MB Filas devueltas: 1

Consultas duplicadas: #6

SELECT template

  FROM joomla3_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	ALL	idx_home	No pudo usarse una clave de índice	NULL	NULL	5	100.00	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
14	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
13	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:96
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:54
7	plgSystemRokCommon->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:682
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.09 ms Después de la última consulta: 2.98 ms Consulta a la memoria: 0.015 MB memoria antes de la consulta: 2.528 MB Filas devueltas: 2

SELECT extension, file, type

  FROM joomla3_rokcommon_configs

  ORDER BY priority

Explicar

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

Perfil

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

Llamada de pila

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

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

Tiempo de la consulta: 1.15 ms Después de la última consulta: 23.62 ms Consulta a la memoria: 0.019 MB memoria antes de la consulta: 3.443 MB Filas devueltas: 183

Consultas duplicadas: #22 #54

SHOW TABLES

Explicar

'Explicar' no es posible en la consulta: SHOW TABLES

Perfil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
checking permissions	0.60 ms
Sending data	0.10 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.01 ms
closing tables	0.00 ms
freeing items	0.03 ms
cleaning up	0.08 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
11	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:497
10	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jdownloads/jdownloads.php:78
9	plgSystemjdownloads->onAfterInitialise()	Lo mismo que llamada de la línea de abajo.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:683
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.46 ms Después de la última consulta: 0.35 ms Consulta a la memoria: 0.015 MB memoria antes de la consulta: 3.494 MB Filas devueltas: 0

SELECT file_id 
  from joomla3_jdownloads_files 
  WHERE published = 1 
  AND use_timeframe = 1 
  AND publish_to != '0000-00-00 00:00:00' 
  AND publish_to <= '2017-06-26 00:30:10'

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joomla3_jdownloads_files	ALL	idx_published	No pudo usarse una clave de índice	NULL	NULL	14	78.57	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
10	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jdownloads/jdownloads.php:106
9	plgSystemjdownloads->onAfterInitialise()	Lo mismo que llamada de la línea de abajo.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:683
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.45 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.015 MB memoria antes de la consulta: 3.508 MB Filas devueltas: 0

SELECT file_id 
  from joomla3_jdownloads_files 
  WHERE published = 0 
  AND use_timeframe = 1 
  AND publish_from != '0000-00-00 00:00:00' 
  AND publish_from <= '2017-06-26 00:30:10'

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joomla3_jdownloads_files	ref	idx_published	idx_published	1	const	1	100.00	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
10	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jdownloads/jdownloads.php:114
9	plgSystemjdownloads->onAfterInitialise()	Lo mismo que llamada de la línea de abajo.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:683
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 1.83 ms Después de la última consulta: 1.15 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 3.561 MB Filas devueltas: 18

SHOW FULL COLUMNS 
  FROM `joomla3_extensions`

Explicar

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

Perfil

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.95 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.01 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.38 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
12	JTable->__construct()	JROOT/libraries/joomla/table/extension.php:31
11	JTableExtension->__construct()	JROOT/libraries/joomla/table/table.php:311
10	JTable::getInstance()	JROOT/plugins/system/roksprocket/roksprocket.php:45
9	plgSystemRokSprocket->onAfterInitialise()	Lo mismo que llamada de la línea de abajo.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:683
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.09 ms Después de la última consulta: 0.79 ms Consulta a la memoria: 0.016 MB memoria antes de la consulta: 3.633 MB Filas devueltas: 1

SELECT `extension_id`

  FROM `joomla3_extensions`

  WHERE type = 'component' 
  AND element = 'com_roksprocket'

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
11	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/table/extension.php:120
10	JTableExtension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:49
9	plgSystemRokSprocket->onAfterInitialise()	Lo mismo que llamada de la línea de abajo.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:683
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.10 ms Después de la última consulta: 0.20 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 3.652 MB Filas devueltas: 1

Consultas duplicadas: #16

SELECT *

  FROM joomla3_extensions

  WHERE `extension_id` = '10024'

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
10	JTable->load()	JROOT/plugins/system/roksprocket/roksprocket.php:54
9	plgSystemRokSprocket->onAfterInitialise()	Lo mismo que llamada de la línea de abajo.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:683
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.08 ms Después de la última consulta: 0.20 ms Consulta a la memoria: 0.016 MB memoria antes de la consulta: 3.666 MB Filas devueltas: 1

SELECT `extension_id`

  FROM `joomla3_extensions`

  WHERE type = 'module' 
  AND element = 'mod_roksprocket'

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
11	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/table/extension.php:120
10	JTableExtension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:72
9	plgSystemRokSprocket->onAfterInitialise()	Lo mismo que llamada de la línea de abajo.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:683
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.09 ms Después de la última consulta: 0.19 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 3.682 MB Filas devueltas: 1

Consultas duplicadas: #14

SELECT *

  FROM joomla3_extensions

  WHERE `extension_id` = '10024'

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
10	JTable->load()	JROOT/plugins/system/roksprocket/roksprocket.php:76
9	plgSystemRokSprocket->onAfterInitialise()	Lo mismo que llamada de la línea de abajo.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:683
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.12 ms Después de la última consulta: 24.92 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 3.939 MB Filas devueltas: 1

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

  FROM joomla3_extensions

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

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
17	JDatabaseDriver->loadObject()	JROOT/components/com_roksprocket/lib/RokSprocket/Addon/AdvancedModuleManager.php:92
16	RokSprocket_Addon_AdvancedModuleManager->isComponentEnabled()	JROOT/components/com_roksprocket/lib/RokSprocket/Addon/AdvancedModuleManager.php:17
15	RokSprocket_Addon_AdvancedModuleManager->__construct()	Lo mismo que llamada de la línea de abajo.
14	ReflectionClass->newInstanceArgs()	JROOT/libraries/rokcommon/RokCommon/Service/Container/Builder.php:248
13	RokCommon_Service_Container_Builder->createService()	JROOT/libraries/rokcommon/RokCommon/Service/Container/Builder.php:86
12	RokCommon_Service_Container_Builder->getService()	JROOT/libraries/rokcommon/RokCommon/Service/ContainerImpl.php:377
11	RokCommon_Service_ContainerImpl->__get()	JROOT/plugins/system/roksprocket/roksprocket.php:225
10	plgSystemRokSprocket->loadAddons()	JROOT/plugins/system/roksprocket/roksprocket.php:91
9	plgSystemRokSprocket->onAfterInitialise()	Lo mismo que llamada de la línea de abajo.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:683
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.22 ms Después de la última consulta: 0.41 ms Consulta a la memoria: 0.012 MB memoria antes de la consulta: 3.942 MB

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

Explicar

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

Perfil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.03 ms
updating	0.01 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
10	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/marcosinterceptor/marcosinterceptor.php:53
9	plgSystemMarcosinterceptor->onAfterInitialise()	Lo mismo que llamada de la línea de abajo.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:683
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.08 ms Después de la última consulta: 0.08 ms Consulta a la memoria: 0.014 MB memoria antes de la consulta: 3.955 MB Filas devueltas: 1

Consultas duplicadas: #20

SELECT COUNT(*) 
  from `joomla3_mi_iptable` 
  WHERE ip = '54.92.178.105' 
  AND `hackcount` >= 3

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
10	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/marcosinterceptor/marcosinterceptor.php:61
9	plgSystemMarcosinterceptor->onAfterInitialise()	Lo mismo que llamada de la línea de abajo.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:683
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.08 ms Después de la última consulta: 0.07 ms Consulta a la memoria: 0.015 MB memoria antes de la consulta: 3.968 MB Filas devueltas: 1

Consultas duplicadas: #19

SELECT COUNT(*) 
  from `joomla3_mi_iptable` 
  WHERE ip = '54.92.178.105' 
  AND `hackcount` >= 3

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
10	JDatabaseDriver->loadResult()	JROOT/plugins/system/marcosinterceptor/marcosinterceptor.php:65
9	plgSystemMarcosinterceptor->onAfterInitialise()	Lo mismo que llamada de la línea de abajo.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:683
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.23 ms Después de la última consulta: 17.18 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 4.849 MB Filas devueltas: 45

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

  FROM `joomla3_assets`

  WHERE `name` IN ('com_admin','com_advancedmodules','com_ajax','com_allvideoshare','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_fpss','com_gantry','com_installer','com_j2xml','com_jce','com_jdownloads','com_jmap','com_joomlaupdate','com_joomleague','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_monthlyarchive','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_rokcandy','com_roksprocket','com_search','com_soccerstats','com_tags','com_templates','com_users','com_wrapper') OR `parent_id` = 0

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joomla3_assets	index_merge	idx_asset_name,idx_parent_id	idx_asset_name,idx_parent_id	202,4	NULL	46	100.00	Using sort_union(idx_asset_name,idx_parent_id); Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
18	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:529
16	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
15	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
14	JUser->authorise()	JROOT/plugins/system/advancedmodules/src/Document.php:28
13	RegularLabs\AdvancedModules\Document::loadFrontEditScript()	JROOT/plugins/system/advancedmodules/src/Helper.php:32
12	RegularLabs\AdvancedModules\Helper->onAfterRoute()	Lo mismo que llamada de la línea de abajo.
11	call_user_func_array()	JROOT/plugins/system/advancedmodules/src/Plugin.php:110
10	RegularLabs\AdvancedModules\Plugin->run()	JROOT/plugins/system/advancedmodules/src/Plugin.php:54
9	RegularLabs\AdvancedModules\Plugin->onAfterRoute()	Lo mismo que llamada de la línea de abajo.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1151
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 1.04 ms Después de la última consulta: 1.42 ms Consulta a la memoria: 0.019 MB memoria antes de la consulta: 4.985 MB Filas devueltas: 183

Consultas duplicadas: #9 #54

SHOW TABLES

Explicar

'Explicar' no es posible en la consulta: SHOW TABLES

Perfil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
checking permissions	0.60 ms
Sending data	0.10 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.08 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
11	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:497
10	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jdownloads/jdownloads.php:353
9	plgSystemjdownloads->onAfterRoute()	Lo mismo que llamada de la línea de abajo.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1151
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 27.84 ms Después de la última consulta: 1.51 ms Consulta a la memoria: 0.013 MB memoria antes de la consulta: 5.028 MB

UPDATE `joomla3_extensions`

  SET `params` = '{\"mediaversion\":\"5de4372309235fed2074328a797ab209\"}'

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

Explicar

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

Perfil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.12 ms
updating	0.10 ms
end	0.01 ms
Waiting for query cache lock	0.00 ms
end	0.27 ms
query end	27.17 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Llamada de pila

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

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

Tiempo de la consulta: 2.16 ms Después de la última consulta: 8.19 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 5.337 MB Filas devueltas: 30

SHOW FULL COLUMNS 
  FROM `joomla3_content`

Explicar

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

Perfil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.98 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Opening tables	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.39 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Llamada de pila

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

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

Tiempo de la consulta: 0.39 ms Después de la última consulta: 1.62 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 5.470 MB Filas devueltas: 1

SELECT *

  FROM joomla3_content

  WHERE `id` = '3356'

Explicar

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

Perfil

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

Llamada de pila

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

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

Tiempo de la consulta: 12.38 ms Después de la última consulta: 0.26 ms Consulta a la memoria: 0.014 MB memoria antes de la consulta: 5.492 MB

UPDATE joomla3_content

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

  WHERE `id` = '3356'

Explicar

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

Perfil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.04 ms
updating	0.07 ms
end	0.01 ms
Waiting for query cache lock	0.00 ms
end	0.29 ms
query end	11.85 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Llamada de pila

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

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

Tiempo de la consulta: 0.85 ms Después de la última consulta: 1.74 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 5.579 MB Filas devueltas: 1

Consultas duplicadas: #33

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

  FROM joomla3_content AS a

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

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

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

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

  WHERE a.id = 3356 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-06-25 22:30:10') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-06-25 22:30:10') 
  AND (a.state = 1 OR a.state =2)

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	const	PRIMARY,idx_state,idx_catid	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found

Perfil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.17 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.03 ms
init	0.07 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.06 ms
optimizing	0.03 ms
statistics	0.17 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.04 ms
Waiting for query cache lock	0.01 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.02 ms

Llamada de pila

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

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

Tiempo de la consulta: 0.14 ms Después de la última consulta: 2.13 ms Consulta a la memoria: 0.037 MB memoria antes de la consulta: 5.712 MB Filas devueltas: 3

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

  FROM joomla3_categories as c

  LEFT JOIN joomla3_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 s.id=101

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Explicar

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

Perfil

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

Llamada de pila

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

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

Tiempo de la consulta: 0.45 ms Después de la última consulta: 0.95 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 5.771 MB Filas devueltas: 0

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

  FROM `joomla3_contentitem_tag_map` AS m 

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

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

Explicar

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

Perfil

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

Llamada de pila

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

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

Tiempo de la consulta: 0.22 ms Después de la última consulta: 91.74 ms Consulta a la memoria: 0.033 MB memoria antes de la consulta: 6.341 MB Filas devueltas: 0

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

  FROM joomla3_fields AS a

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

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

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

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

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

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

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (101,0,96)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

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

  ORDER BY a.ordering DESC

Explicar

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

Perfil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 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
sending cached result to clien	0.02 ms
cleaning up	0.01 ms

Llamada de pila

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

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

Tiempo de la consulta: 2.09 ms Después de la última consulta: 52.96 ms Consulta a la memoria: 0.045 MB memoria antes de la consulta: 8.529 MB Filas devueltas: 35

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params as advancedparams, 0 as menuid, m.publish_up, m.publish_down

  FROM joomla3_modules AS m

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

  LEFT JOIN joomla3_advancedmodules as am 
  ON am.moduleid = m.id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND m.access IN (1,1) 
  AND m.client_id = 0

  ORDER BY m.position, m.ordering

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	range	published,newsfeeds	published	5	NULL	38	100.00	Using index condition; Using where; Usando 'filesort'
1	SIMPLE	am	eq_ref	PRIMARY	PRIMARY	4	juanlux_joomla3.m.id	1	100.00	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	juanlux_joomla3.m.module,const	1	100.00	Using index condition; Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:402
17	PlgSystemAdvancedModuleHelper->getModuleList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:123
16	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	Lo mismo que llamada de la línea de abajo.
15	call_user_func_array()	JROOT/libraries/joomla/event/dispatcher.php:165
14	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
13	JApplicationBase->triggerEvent()	JROOT/libraries/cms/module/helper.php:355
12	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
11	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:576
10	JDocumentHtml->countModules()	JROOT/libraries/gantry/core/gantry.class.php:804
9	Gantry->getJoomlaModuleCount()	JROOT/libraries/gantry/core/gantry.class.php:757
8	Gantry->countModules()	JROOT/templates/rt_corvus/index.php:60
7	require JROOT/templates/rt_corvus/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.21 ms Después de la última consulta: 22.53 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 9.226 MB Filas devueltas: 1

SELECT ts.template

  FROM joomla3_template_styles AS ts

  INNER JOIN joomla3_menu AS m 
  ON ts.id=m.template_style_id

  WHERE m.id = 190 
  AND m.template_style_id != 0

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
17	JDatabaseDriver->loadColumn()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:101
16	RokNavMenu::getTemplates()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:74
15	RokNavMenu::loadCatalogs()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:25
14	RokNavMenu->__construct()	JROOT/modules/mod_roknavmenu/mod_roknavmenu.php:21
13	include JROOT/modules/mod_roknavmenu/mod_roknavmenu.php	JROOT/libraries/cms/module/helper.php:198
12	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
11	JDocumentRendererHtmlModule->render()	JROOT/templates/rt_corvus/features/dropdownmenu.php:56
10	GantryFeatureDropdownMenu->render()	JROOT/libraries/gantry/core/renderers/gantrymodulesrenderer.class.php:70
9	GantryModulesRenderer::display()	JROOT/libraries/gantry/core/gantry.class.php:867
8	Gantry->displayModules()	JROOT/templates/rt_corvus/index.php:80
7	require JROOT/templates/rt_corvus/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.24 ms Después de la última consulta: 13.54 ms Consulta a la memoria: 0.031 MB memoria antes de la consulta: 9.746 MB Filas devueltas: 1

Consultas duplicadas: #27

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

  FROM joomla3_content AS a

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

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

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

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

  WHERE a.id = 3356 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-06-25 22:30:10') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-06-25 22:30:10') 
  AND (a.state = 1 OR a.state =2)

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	const	PRIMARY,idx_state,idx_catid	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
16	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:148
15	ContentModelArticle->getItem()	JROOT/plugins/system/gsd/helper/integrations/content/content.php:65
14	GSDContent->prepareItem()	JROOT/plugins/system/gsd/helper/integration.php:186
13	GSDIntegration->defaultViewItem()	JROOT/plugins/system/gsd/helper/integrations/content/content.php:40
12	GSDContent->viewArticle()	JROOT/plugins/system/gsd/helper/integration.php:89
11	GSDIntegration->getData()	JROOT/plugins/system/gsd/helper/helper.php:50
10	GSDHelper::getJSONByComponent()	JROOT/plugins/system/gsd/gsd.php:99
9	plgSystemGSD->init()	JROOT/plugins/system/gsd/gsd.php:61
8	plgSystemGSD->onBeforeRender()	Lo mismo que llamada de la línea de abajo.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1102
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.15 ms Después de la última consulta: 4.88 ms Consulta a la memoria: 0.032 MB memoria antes de la consulta: 9.996 MB Filas devueltas: 1

Consultas duplicadas: #40

SELECT p.*, l.country, st.id AS sport_type_id, st.name AS sport_type_name,
					LOWER(SUBSTR(st.name, CHAR_LENGTH( "COM_JOOMLEAGUE_ST_")+1)) AS fs_sport_type_name,
					
  CASE WHEN CHAR_LENGTH( p.alias )
					THEN CONCAT_WS( ':', p.id, p.alias )
					ELSE p.id
					END AS slug,
					l.name AS league_name,
					s.name AS season_name
					
  FROM joomla3_joomleague_project AS p
					
  INNER JOIN joomla3_joomleague_sports_type AS st 
  ON p.sports_type_id = st.id
					
  LEFT JOIN joomla3_joomleague_league AS l 
  ON p.league_id = l.id
					
  LEFT JOIN joomla3_joomleague_season AS s 
  ON p.season_id = s.id
					
  WHERE p.id='117' 
  LIMIT 0, 1

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	st	system	PRIMARY	No pudo usarse una clave de índice	NULL	NULL	1	100.00	NULL
1	SIMPLE	p	const	PRIMARY,sports_type_id	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	l	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	s	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
13	JDatabaseDriver->loadObject()	JROOT/components/com_joomleague/models/project.php:99
12	JoomleagueModelProject->getProject()	JROOT/modules/mod_a_estas_alturas/helper.php:49
11	modJLG_a_estas_alturas::getData()	JROOT/modules/mod_a_estas_alturas/mod_a_estas_alturas.php:23
10	include JROOT/modules/mod_a_estas_alturas/mod_a_estas_alturas.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.71 ms Después de la última consulta: 0.17 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 10.025 MB Filas devueltas: 1

SELECT r.id, r.roundcode 
  FROM joomla3_joomleague_round AS r
							 
  WHERE r.project_id=117
								
  AND (r.round_date_first - INTERVAL 0 MINUTE < '2017-06-26 00:30:11')
							 
  ORDER BY r.round_date_first DESC 
  LIMIT 1

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r	ref	project_id	project_id	4	const	46	100.00	Using where; Usando 'filesort'

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
14	JDatabaseDriver->loadObject()	JROOT/components/com_joomleague/models/project.php:197
13	JoomleagueModelProject->increaseRound()	JROOT/components/com_joomleague/models/project.php:128
12	JoomleagueModelProject->getCurrentRound()	JROOT/modules/mod_a_estas_alturas/helper.php:50
11	modJLG_a_estas_alturas::getData()	JROOT/modules/mod_a_estas_alturas/mod_a_estas_alturas.php:23
10	include JROOT/modules/mod_a_estas_alturas/mod_a_estas_alturas.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.22 ms Después de la última consulta: 0.17 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 10.048 MB Filas devueltas: 1

SELECT extension

  FROM joomla3_joomleague_project

  WHERE id='117'

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_joomleague/helpers/joomleaguehelper.php:310
13	JoomleagueHelper::getExtensions()	JROOT/components/com_joomleague/helpers/ranking.php:102
12	JLGRanking::getInstance()	JROOT/modules/mod_a_estas_alturas/helper.php:54
11	modJLG_a_estas_alturas::getData()	JROOT/modules/mod_a_estas_alturas/mod_a_estas_alturas.php:23
10	include JROOT/modules/mod_a_estas_alturas/mod_a_estas_alturas.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.11 ms Después de la última consulta: 12.24 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 10.290 MB Filas devueltas: 1

Consultas duplicadas: #38

SELECT t.params
				   
  FROM joomla3_joomleague_template_config AS t
				   
  INNER JOIN joomla3_joomleague_project AS p 
  ON p.id=t.project_id
				   
  WHERE t.template='ranking'
				   
  AND p.id='117'

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	p	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index
1	SIMPLE	t	ref	project_id	project_id	4	const	6	100.00	Using index condition; Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
15	JDatabaseDriver->loadResult()	JROOT/components/com_joomleague/models/project.php:724
14	JoomleagueModelProject->getTemplateConfig()	JROOT/components/com_joomleague/helpers/ranking.php:144
13	JLGRanking->setProjectId()	JROOT/components/com_joomleague/helpers/ranking.php:126
12	JLGRanking::getInstance()	JROOT/modules/mod_a_estas_alturas/helper.php:54
11	modJLG_a_estas_alturas::getData()	JROOT/modules/mod_a_estas_alturas/mod_a_estas_alturas.php:23
10	include JROOT/modules/mod_a_estas_alturas/mod_a_estas_alturas.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.10 ms Después de la última consulta: 8.97 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 10.324 MB Filas devueltas: 1

Consultas duplicadas: #37

SELECT t.params
				   
  FROM joomla3_joomleague_template_config AS t
				   
  INNER JOIN joomla3_joomleague_project AS p 
  ON p.id=t.project_id
				   
  WHERE t.template='ranking'
				   
  AND p.id='117'

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	p	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index
1	SIMPLE	t	ref	project_id	project_id	4	const	6	100.00	Using index condition; Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
14	JDatabaseDriver->loadResult()	JROOT/components/com_joomleague/models/project.php:724
13	JoomleagueModelProject->getTemplateConfig()	JROOT/components/com_joomleague/helpers/ranking.php:144
12	JLGRanking->setProjectId()	JROOT/modules/mod_a_estas_alturas/helper.php:55
11	modJLG_a_estas_alturas::getData()	JROOT/modules/mod_a_estas_alturas/mod_a_estas_alturas.php:23
10	include JROOT/modules/mod_a_estas_alturas/mod_a_estas_alturas.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.08 ms Después de la última consulta: 0.22 ms Consulta a la memoria: 0.019 MB memoria antes de la consulta: 10.330 MB Filas devueltas: 1

SELECT r.roundcode  
  FROM joomla3_joomleague_round AS r  
  WHERE project_id = '117'   
  AND r.id = '1883'

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
13	JDatabaseDriver->loadResult()	JROOT/modules/mod_a_estas_alturas/helper.php:195
12	modJLG_a_estas_alturas::getRoundCode()	JROOT/modules/mod_a_estas_alturas/helper.php:57
11	modJLG_a_estas_alturas::getData()	JROOT/modules/mod_a_estas_alturas/mod_a_estas_alturas.php:23
10	include JROOT/modules/mod_a_estas_alturas/mod_a_estas_alturas.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.12 ms Después de la última consulta: 0.13 ms Consulta a la memoria: 0.034 MB memoria antes de la consulta: 10.353 MB Filas devueltas: 1

Consultas duplicadas: #34

SELECT p.*, l.country, st.id AS sport_type_id, st.name AS sport_type_name,
					LOWER(SUBSTR(st.name, CHAR_LENGTH( "COM_JOOMLEAGUE_ST_")+1)) AS fs_sport_type_name,
					
  CASE WHEN CHAR_LENGTH( p.alias )
					THEN CONCAT_WS( ':', p.id, p.alias )
					ELSE p.id
					END AS slug,
					l.name AS league_name,
					s.name AS season_name
					
  FROM joomla3_joomleague_project AS p
					
  INNER JOIN joomla3_joomleague_sports_type AS st 
  ON p.sports_type_id = st.id
					
  LEFT JOIN joomla3_joomleague_league AS l 
  ON p.league_id = l.id
					
  LEFT JOIN joomla3_joomleague_season AS s 
  ON p.season_id = s.id
					
  WHERE p.id='117' 
  LIMIT 0, 1

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	st	system	PRIMARY	No pudo usarse una clave de índice	NULL	NULL	1	100.00	NULL
1	SIMPLE	p	const	PRIMARY,sports_type_id	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	l	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	s	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
15	JDatabaseDriver->loadObject()	JROOT/components/com_joomleague/models/project.php:99
14	JoomleagueModelProject->getProject()	JROOT/components/com_joomleague/helpers/ranking.php:281
13	JLGRanking->_collect()	JROOT/components/com_joomleague/helpers/ranking.php:175
12	JLGRanking->getRanking()	JROOT/modules/mod_a_estas_alturas/helper.php:59
11	modJLG_a_estas_alturas::getData()	JROOT/modules/mod_a_estas_alturas/mod_a_estas_alturas.php:23
10	include JROOT/modules/mod_a_estas_alturas/mod_a_estas_alturas.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.16 ms Después de la última consulta: 5.28 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 11.999 MB Filas devueltas: 38

SELECT `r`.`roundcode`,`r`.`id`

  FROM `joomla3_joomleague_round` AS `r`

  WHERE `r`.`project_id` = 117

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r	ref	project_id	project_id	4	const	46	100.00	NULL

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
16	JDatabaseDriver->loadAssocList()	JROOT/components/com_joomleague/helpers/ranking.php:848
15	JLGRanking->_getRoundcode()	JROOT/components/com_joomleague/helpers/ranking.php:814
14	JLGRanking->_countGame()	JROOT/components/com_joomleague/helpers/ranking.php:293
13	JLGRanking->_collect()	JROOT/components/com_joomleague/helpers/ranking.php:175
12	JLGRanking->getRanking()	JROOT/modules/mod_a_estas_alturas/helper.php:59
11	modJLG_a_estas_alturas::getData()	JROOT/modules/mod_a_estas_alturas/mod_a_estas_alturas.php:23
10	include JROOT/modules/mod_a_estas_alturas/mod_a_estas_alturas.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.21 ms Después de la última consulta: 26.41 ms Consulta a la memoria: 0.039 MB memoria antes de la consulta: 10.600 MB Filas devueltas: 20

SELECT	tl.id AS projectteamid,
								tl.division_id,
								tl.standard_playground,
								tl.start_points,
								tl.points_finally,
								tl.neg_points_finally,
								tl.matches_finally,
								tl.won_finally,
								tl.draws_finally,
								tl.lost_finally,
								tl.homegoals_finally,
								tl.guestgoals_finally,
								tl.diffgoals_finally,
								tl.info,
								tl.reason,
								tl.team_id,
								tl.checked_out,
								tl.checked_out_time,
								tl.is_in_score,
								tl.picture AS projectteam_picture,
								t.picture as team_picture,
								IF((ISNULL(tl.picture) OR (tl.picture="")),
									(IF((ISNULL(t.picture) OR (t.picture="")), c.logo_small , t.picture)) , t.picture) as picture,
								tl.project_id,

								t.id,t.name,
								t.short_name,
								t.middle_name,
								t.notes,
								t.club_id,

								c.email as club_email,
								c.logo_small,
								c.logo_middle,
								c.logo_big,
								c.country,
								c.website,

								d.name AS division_name,
								d.picture AS division_picture,
								d.shortname AS division_shortname,
								d.parent_id AS parent_division_id,

								plg.name AS playground_name,
								plg.short_name AS playground_short_name,

								
  CASE WHEN CHAR_LENGTH(p.alias) THEN CONCAT_WS(':',p.id,p.alias) ELSE p.id END AS project_slug,
								
  CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':',t.id,t.alias) ELSE t.id END AS team_slug,
								
  CASE WHEN CHAR_LENGTH(d.alias) THEN CONCAT_WS(':',d.id,d.alias) ELSE d.id END AS division_slug,
								
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':',c.id,c.alias) ELSE c.id END AS club_slug

						
  FROM joomla3_joomleague_project_team tl
							
  LEFT JOIN joomla3_joomleague_team t 
  ON tl.team_id=t.id
							
  LEFT JOIN joomla3_joomleague_club c 
  ON t.club_id=c.id
							
  LEFT JOIN joomla3_joomleague_division d 
  ON d.id=tl.division_id
							
  LEFT JOIN joomla3_joomleague_playground plg 
  ON plg.id=tl.standard_playground
							
  LEFT JOIN joomla3_joomleague_project AS p 
  ON p.id=tl.project_id

						
  WHERE tl.project_id=117

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	d	system	PRIMARY	No pudo usarse una clave de índice	NULL	NULL	0	0.00	const row not found
1	SIMPLE	tl	ref	combi,project_id	combi	4	const	23	100.00	NULL
1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	juanlux_joomla3.tl.team_id	1	100.00	NULL
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	juanlux_joomla3.t.club_id	1	100.00	NULL
1	SIMPLE	plg	eq_ref	PRIMARY	PRIMARY	4	juanlux_joomla3.tl.standard_playground	1	100.00	NULL
1	SIMPLE	p	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Perfil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.03 ms
checking privileges on cached	0.00 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
sending cached result to clien	0.03 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_joomleague/models/project.php:501
14	JoomleagueModelProject->_getTeams()	JROOT/components/com_joomleague/models/project.php:528
13	JoomleagueModelProject->getTeams()	JROOT/components/com_joomleague/models/project.php:568
12	JoomleagueModelProject->getTeamsIndexedByPtid()	JROOT/modules/mod_a_estas_alturas/helper.php:60
11	modJLG_a_estas_alturas::getData()	JROOT/modules/mod_a_estas_alturas/mod_a_estas_alturas.php:23
10	include JROOT/modules/mod_a_estas_alturas/mod_a_estas_alturas.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.12 ms Después de la última consulta: 0.82 ms Consulta a la memoria: 0.032 MB memoria antes de la consulta: 10.800 MB Filas devueltas: 1

Consultas duplicadas: #48

SELECT p.*, l.country, st.id AS sport_type_id, st.name AS sport_type_name,
					LOWER(SUBSTR(st.name, CHAR_LENGTH( "COM_JOOMLEAGUE_ST_")+1)) AS fs_sport_type_name,
					
  CASE WHEN CHAR_LENGTH( p.alias )
					THEN CONCAT_WS( ':', p.id, p.alias )
					ELSE p.id
					END AS slug,
					l.name AS league_name,
					s.name AS season_name
					
  FROM joomla3_joomleague_project AS p
					
  INNER JOIN joomla3_joomleague_sports_type AS st 
  ON p.sports_type_id = st.id
					
  LEFT JOIN joomla3_joomleague_league AS l 
  ON p.league_id = l.id
					
  LEFT JOIN joomla3_joomleague_season AS s 
  ON p.season_id = s.id
					
  WHERE p.id='77' 
  LIMIT 0, 1

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	st	system	PRIMARY	No pudo usarse una clave de índice	NULL	NULL	1	100.00	NULL
1	SIMPLE	p	const	PRIMARY,sports_type_id	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	l	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	s	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
13	JDatabaseDriver->loadObject()	JROOT/components/com_joomleague/models/project.php:99
12	JoomleagueModelProject->getProject()	JROOT/modules/mod_a_estas_alturas/helper.php:117
11	modJLG_a_estas_alturas::getData()	JROOT/modules/mod_a_estas_alturas/mod_a_estas_alturas.php:23
10	include JROOT/modules/mod_a_estas_alturas/mod_a_estas_alturas.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.08 ms Después de la última consulta: 0.16 ms Consulta a la memoria: 0.019 MB memoria antes de la consulta: 10.828 MB Filas devueltas: 1

SELECT r.id AS roundid  
  FROM joomla3_joomleague_round AS r  
  WHERE project_id = '77'   
  AND r.roundcode = '38'

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r	ref	project_id	project_id	4	const	37	100.00	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
13	JDatabaseDriver->loadResult()	JROOT/modules/mod_a_estas_alturas/helper.php:213
12	modJLG_a_estas_alturas::getRoundId_Jornada()	JROOT/modules/mod_a_estas_alturas/helper.php:118
11	modJLG_a_estas_alturas::getData()	JROOT/modules/mod_a_estas_alturas/mod_a_estas_alturas.php:23
10	include JROOT/modules/mod_a_estas_alturas/mod_a_estas_alturas.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.09 ms Después de la última consulta: 0.15 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 10.849 MB Filas devueltas: 1

SELECT extension

  FROM joomla3_joomleague_project

  WHERE id='77'

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_joomleague/helpers/joomleaguehelper.php:310
13	JoomleagueHelper::getExtensions()	JROOT/components/com_joomleague/helpers/ranking.php:102
12	JLGRanking::getInstance()	JROOT/modules/mod_a_estas_alturas/helper.php:121
11	modJLG_a_estas_alturas::getData()	JROOT/modules/mod_a_estas_alturas/mod_a_estas_alturas.php:23
10	include JROOT/modules/mod_a_estas_alturas/mod_a_estas_alturas.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.10 ms Después de la última consulta: 8.93 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 10.882 MB Filas devueltas: 1

Consultas duplicadas: #47

SELECT t.params
				   
  FROM joomla3_joomleague_template_config AS t
				   
  INNER JOIN joomla3_joomleague_project AS p 
  ON p.id=t.project_id
				   
  WHERE t.template='ranking'
				   
  AND p.id='77'

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	p	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index
1	SIMPLE	t	ref	project_id	project_id	4	const	6	100.00	Using index condition; Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
15	JDatabaseDriver->loadResult()	JROOT/components/com_joomleague/models/project.php:724
14	JoomleagueModelProject->getTemplateConfig()	JROOT/components/com_joomleague/helpers/ranking.php:144
13	JLGRanking->setProjectId()	JROOT/components/com_joomleague/helpers/ranking.php:126
12	JLGRanking::getInstance()	JROOT/modules/mod_a_estas_alturas/helper.php:121
11	modJLG_a_estas_alturas::getData()	JROOT/modules/mod_a_estas_alturas/mod_a_estas_alturas.php:23
10	include JROOT/modules/mod_a_estas_alturas/mod_a_estas_alturas.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.09 ms Después de la última consulta: 8.68 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 10.908 MB Filas devueltas: 1

Consultas duplicadas: #46

SELECT t.params
				   
  FROM joomla3_joomleague_template_config AS t
				   
  INNER JOIN joomla3_joomleague_project AS p 
  ON p.id=t.project_id
				   
  WHERE t.template='ranking'
				   
  AND p.id='77'

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	p	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index
1	SIMPLE	t	ref	project_id	project_id	4	const	6	100.00	Using index condition; Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
14	JDatabaseDriver->loadResult()	JROOT/components/com_joomleague/models/project.php:724
13	JoomleagueModelProject->getTemplateConfig()	JROOT/components/com_joomleague/helpers/ranking.php:144
12	JLGRanking->setProjectId()	JROOT/modules/mod_a_estas_alturas/helper.php:122
11	modJLG_a_estas_alturas::getData()	JROOT/modules/mod_a_estas_alturas/mod_a_estas_alturas.php:23
10	include JROOT/modules/mod_a_estas_alturas/mod_a_estas_alturas.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.11 ms Después de la última consulta: 0.23 ms Consulta a la memoria: 0.034 MB memoria antes de la consulta: 10.914 MB Filas devueltas: 1

Consultas duplicadas: #43

SELECT p.*, l.country, st.id AS sport_type_id, st.name AS sport_type_name,
					LOWER(SUBSTR(st.name, CHAR_LENGTH( "COM_JOOMLEAGUE_ST_")+1)) AS fs_sport_type_name,
					
  CASE WHEN CHAR_LENGTH( p.alias )
					THEN CONCAT_WS( ':', p.id, p.alias )
					ELSE p.id
					END AS slug,
					l.name AS league_name,
					s.name AS season_name
					
  FROM joomla3_joomleague_project AS p
					
  INNER JOIN joomla3_joomleague_sports_type AS st 
  ON p.sports_type_id = st.id
					
  LEFT JOIN joomla3_joomleague_league AS l 
  ON p.league_id = l.id
					
  LEFT JOIN joomla3_joomleague_season AS s 
  ON p.season_id = s.id
					
  WHERE p.id='77' 
  LIMIT 0, 1

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	st	system	PRIMARY	No pudo usarse una clave de índice	NULL	NULL	1	100.00	NULL
1	SIMPLE	p	const	PRIMARY,sports_type_id	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	l	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	s	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
15	JDatabaseDriver->loadObject()	JROOT/components/com_joomleague/models/project.php:99
14	JoomleagueModelProject->getProject()	JROOT/components/com_joomleague/helpers/ranking.php:281
13	JLGRanking->_collect()	JROOT/components/com_joomleague/helpers/ranking.php:175
12	JLGRanking->getRanking()	JROOT/modules/mod_a_estas_alturas/helper.php:125
11	modJLG_a_estas_alturas::getData()	JROOT/modules/mod_a_estas_alturas/mod_a_estas_alturas.php:23
10	include JROOT/modules/mod_a_estas_alturas/mod_a_estas_alturas.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.15 ms Después de la última consulta: 5.12 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 12.560 MB Filas devueltas: 38

SELECT `r`.`roundcode`,`r`.`id`

  FROM `joomla3_joomleague_round` AS `r`

  WHERE `r`.`project_id` = 77

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r	ref	project_id	project_id	4	const	37	100.00	NULL

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
16	JDatabaseDriver->loadAssocList()	JROOT/components/com_joomleague/helpers/ranking.php:848
15	JLGRanking->_getRoundcode()	JROOT/components/com_joomleague/helpers/ranking.php:814
14	JLGRanking->_countGame()	JROOT/components/com_joomleague/helpers/ranking.php:293
13	JLGRanking->_collect()	JROOT/components/com_joomleague/helpers/ranking.php:175
12	JLGRanking->getRanking()	JROOT/modules/mod_a_estas_alturas/helper.php:125
11	modJLG_a_estas_alturas::getData()	JROOT/modules/mod_a_estas_alturas/mod_a_estas_alturas.php:23
10	include JROOT/modules/mod_a_estas_alturas/mod_a_estas_alturas.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.22 ms Después de la última consulta: 34.17 ms Consulta a la memoria: 0.039 MB memoria antes de la consulta: 11.159 MB Filas devueltas: 20

SELECT	tl.id AS projectteamid,
								tl.division_id,
								tl.standard_playground,
								tl.start_points,
								tl.points_finally,
								tl.neg_points_finally,
								tl.matches_finally,
								tl.won_finally,
								tl.draws_finally,
								tl.lost_finally,
								tl.homegoals_finally,
								tl.guestgoals_finally,
								tl.diffgoals_finally,
								tl.info,
								tl.reason,
								tl.team_id,
								tl.checked_out,
								tl.checked_out_time,
								tl.is_in_score,
								tl.picture AS projectteam_picture,
								t.picture as team_picture,
								IF((ISNULL(tl.picture) OR (tl.picture="")),
									(IF((ISNULL(t.picture) OR (t.picture="")), c.logo_small , t.picture)) , t.picture) as picture,
								tl.project_id,

								t.id,t.name,
								t.short_name,
								t.middle_name,
								t.notes,
								t.club_id,

								c.email as club_email,
								c.logo_small,
								c.logo_middle,
								c.logo_big,
								c.country,
								c.website,

								d.name AS division_name,
								d.picture AS division_picture,
								d.shortname AS division_shortname,
								d.parent_id AS parent_division_id,

								plg.name AS playground_name,
								plg.short_name AS playground_short_name,

								
  CASE WHEN CHAR_LENGTH(p.alias) THEN CONCAT_WS(':',p.id,p.alias) ELSE p.id END AS project_slug,
								
  CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':',t.id,t.alias) ELSE t.id END AS team_slug,
								
  CASE WHEN CHAR_LENGTH(d.alias) THEN CONCAT_WS(':',d.id,d.alias) ELSE d.id END AS division_slug,
								
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':',c.id,c.alias) ELSE c.id END AS club_slug

						
  FROM joomla3_joomleague_project_team tl
							
  LEFT JOIN joomla3_joomleague_team t 
  ON tl.team_id=t.id
							
  LEFT JOIN joomla3_joomleague_club c 
  ON t.club_id=c.id
							
  LEFT JOIN joomla3_joomleague_division d 
  ON d.id=tl.division_id
							
  LEFT JOIN joomla3_joomleague_playground plg 
  ON plg.id=tl.standard_playground
							
  LEFT JOIN joomla3_joomleague_project AS p 
  ON p.id=tl.project_id

						
  WHERE tl.project_id=77

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	d	system	PRIMARY	No pudo usarse una clave de índice	NULL	NULL	0	0.00	const row not found
1	SIMPLE	tl	ref	combi,project_id	project_id	4	const	19	100.00	NULL
1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	juanlux_joomla3.tl.team_id	1	100.00	NULL
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	juanlux_joomla3.t.club_id	1	100.00	NULL
1	SIMPLE	plg	eq_ref	PRIMARY	PRIMARY	4	juanlux_joomla3.tl.standard_playground	1	100.00	NULL
1	SIMPLE	p	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Perfil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.03 ms
checking privileges on cached	0.00 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
sending cached result to clien	0.03 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_joomleague/models/project.php:501
14	JoomleagueModelProject->_getTeams()	JROOT/components/com_joomleague/models/project.php:528
13	JoomleagueModelProject->getTeams()	JROOT/components/com_joomleague/models/project.php:568
12	JoomleagueModelProject->getTeamsIndexedByPtid()	JROOT/modules/mod_a_estas_alturas/helper.php:126
11	modJLG_a_estas_alturas::getData()	JROOT/modules/mod_a_estas_alturas/mod_a_estas_alturas.php:23
10	include JROOT/modules/mod_a_estas_alturas/mod_a_estas_alturas.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 2.02 ms Después de la última consulta: 3.58 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 10.619 MB Filas devueltas: 6

SHOW FULL COLUMNS 
  FROM `joomla3_template_styles`

Explicar

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

Perfil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	1.11 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Opening tables	0.02 ms
checking permissions	0.09 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Sending data	0.05 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.41 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.14 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
19	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
18	JTable->__construct()	JROOT/administrator/components/com_templates/tables/style.php:30
17	TemplatesTableStyle->__construct()	JROOT/libraries/joomla/table/table.php:311
16	JTable::getInstance()	JROOT/plugins/system/gantry/gantry.php:194
15	plgSystemGantry->getTable()	JROOT/plugins/system/gantry/gantry.php:165
14	plgSystemGantry->isGantryTemplate()	JROOT/plugins/system/gantry/gantry.php:234
13	plgSystemGantry->onBeforeCompileHead()	Lo mismo que llamada de la línea de abajo.
12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
9	JApplicationBase->triggerEvent()	JROOT/libraries/joomla/document/renderer/html/head.php:63
8	JDocumentRendererHtmlHead->fetchHead()	JROOT/libraries/joomla/document/renderer/html/head.php:34
7	JDocumentRendererHtmlHead->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.10 ms Después de la última consulta: 0.32 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 10.662 MB Filas devueltas: 1

SELECT *

  FROM joomla3_template_styles

  WHERE `id` = '14'

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
16	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
15	JTable->load()	JROOT/plugins/system/gantry/gantry.php:168
14	plgSystemGantry->isGantryTemplate()	JROOT/plugins/system/gantry/gantry.php:234
13	plgSystemGantry->onBeforeCompileHead()	Lo mismo que llamada de la línea de abajo.
12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
9	JApplicationBase->triggerEvent()	JROOT/libraries/joomla/document/renderer/html/head.php:63
8	JDocumentRendererHtmlHead->fetchHead()	JROOT/libraries/joomla/document/renderer/html/head.php:34
7	JDocumentRendererHtmlHead->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.43 ms Después de la última consulta: 0.25 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 10.679 MB Filas devueltas: 0

SELECT *
 
  FROM joomla3_jmap_metainfo
 
  WHERE `linkurl` = 'https://www.quesomecanico.com/web/inicio/hemeroteca/101-ultimos-articulos/3356-protagonistas-del-elche-albacete-hablan-ruben-cruz-juan-carlos-y-javi-paredes'
 
  AND `published` = 1

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joomla3_jmap_metainfo	ref	linkurl,published	linkurl	767	const	1	100.00	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
14	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:276
13	plgSystemJMap->onBeforeCompileHead()	Lo mismo que llamada de la línea de abajo.
12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
9	JApplicationBase->triggerEvent()	JROOT/libraries/joomla/document/renderer/html/head.php:63
8	JDocumentRendererHtmlHead->fetchHead()	JROOT/libraries/joomla/document/renderer/html/head.php:34
7	JDocumentRendererHtmlHead->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.89 ms Después de la última consulta: 1.51 ms Consulta a la memoria: 0.018 MB memoria antes de la consulta: 10.820 MB Filas devueltas: 183

Consultas duplicadas: #9 #22

SHOW TABLES

Explicar

'Explicar' no es posible en la consulta: SHOW TABLES

Perfil

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
checking permissions	0.57 ms
Sending data	0.08 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.01 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.05 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:497
9	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jdownloads/jdownloads.php:253
8	plgSystemjdownloads->onAfterRender()	Lo mismo que llamada de la línea de abajo.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1118
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

37 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

4 × SELECT t.params        
  FROM joomla3_joomleague_template_config AS t        
  INNER JOIN joomla3_joomleague_project AS p 
  ON p.id=t.project_id

4 × SELECT p.*, l.country, st.id AS sport_type_id, st.name AS sport_type_name,      LOWER(SUBSTR(st.name, CHAR_LENGTH( "COM_JOOMLEAGUE_ST_")+1)) AS fs_sport_type_name,      
  CASE WHEN CHAR_LENGTH( p.alias )      THEN CONCAT_WS( ':', p.id, p.alias )      ELSE p.id      END AS slug,      l.name AS league_name,      s.name AS season_name      
  FROM joomla3_joomleague_project AS p      
  INNER JOIN joomla3_joomleague_sports_type AS st 
  ON p.sports_type_id = st.id      
  LEFT JOIN joomla3_joomleague_league AS l 
  ON p.league_id = l.id      
  LEFT JOIN joomla3_joomleague_season AS s 
  ON p.season_id = s.id

2 × SELECT COUNT(*) 
  from `joomla3_mi_iptable`

2 × SELECT `r`.`roundcode`,`r`.`id` 
  FROM `joomla3_joomleague_round` AS `r`

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

2 × SELECT extension 
  FROM joomla3_joomleague_project

2 × SELECT `extension_id` 
  FROM `joomla3_extensions`

2 × SELECT * 
  FROM joomla3_extensions

2 × SELECT tl.id AS projectteamid,         tl.division_id,         tl.standard_playground,         tl.start_points,         tl.points_finally,         tl.neg_points_finally,         tl.matches_finally,         tl.won_finally,         tl.draws_finally,         tl.lost_finally,         tl.homegoals_finally,         tl.guestgoals_finally,         tl.diffgoals_finally,         tl.info,         tl.reason,         tl.team_id,         tl.checked_out,         tl.checked_out_time,         tl.is_in_score,         tl.picture AS projectteam_picture,         t.picture as team_picture,         IF((ISNULL(tl.picture) OR (tl.picture="")),          (IF((ISNULL(t.picture) OR (t.picture="")), c.logo_small , t.picture)) , t.picture) as picture,         tl.project_id,          t.id,t.name,         t.short_name,         t.middle_name,         t.notes,         t.club_id,          c.email as club_email,         c.logo_small,         c.logo_middle,         c.logo_big,         c.country,         c.website,          d.name AS division_name,         d.picture AS division_picture,         d.shortname AS division_shortname,         d.parent_id AS parent_division_id,          plg.name AS playground_name,         plg.short_name AS playground_short_name,          
  CASE WHEN CHAR_LENGTH(p.alias) THEN CONCAT_WS(':',p.id,p.alias) ELSE p.id END AS project_slug,         
  CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':',t.id,t.alias) ELSE t.id END AS team_slug,         
  CASE WHEN CHAR_LENGTH(d.alias) THEN CONCAT_WS(':',d.id,d.alias) ELSE d.id END AS division_slug,         
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':',c.id,c.alias) ELSE c.id END AS club_slug        
  FROM joomla3_joomleague_project_team tl        
  LEFT JOIN joomla3_joomleague_team t 
  ON tl.team_id=t.id        
  LEFT JOIN joomla3_joomleague_club c 
  ON t.club_id=c.id        
  LEFT JOIN joomla3_joomleague_division d 
  ON d.id=tl.division_id        
  LEFT JOIN joomla3_joomleague_playground plg 
  ON plg.id=tl.standard_playground        
  LEFT JOIN joomla3_joomleague_project AS p 
  ON p.id=tl.project_id

2 × SELECT template 
  FROM joomla3_template_styles as s

2 × SELECT file_id 
  from joomla3_jdownloads_files

1 × SELECT r.id, r.roundcode 
  FROM joomla3_joomleague_round AS r

1 × SELECT *  
  FROM joomla3_jmap_metainfo

1 × SELECT * 
  FROM joomla3_template_styles

1 × SELECT r.id AS roundid  
  FROM joomla3_joomleague_round AS r

1 × SELECT r.roundcode  
  FROM joomla3_joomleague_round AS r

1 × SELECT ts.template 
  FROM joomla3_template_styles AS ts 
  INNER JOIN joomla3_menu AS m 
  ON ts.id=m.template_style_id

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 joomla3_categories as c 
  LEFT JOIN joomla3_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

1 × SELECT extension, file, type 
  FROM joomla3_rokcommon_configs

1 × SELECT id, rules 
  FROM `joomla3_viewlevels

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

1 × SELECT `session_id` 
  FROM `joomla3_session`

1 × SELECT extension_id AS id, element AS "option", params, enabled 
  FROM joomla3_extensions

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

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

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

1 × SELECT `data` 
  FROM `joomla3_session`

```
1 × SELECT * 
  FROM joomla3_content
```

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params as advancedparams, 0 as menuid, m.publish_up, m.publish_down 
  FROM joomla3_modules AS m 
  LEFT JOIN joomla3_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id 
  LEFT JOIN joomla3_advancedmodules as am 
  ON am.moduleid = m.id

OTRAS tablas:

```
3 × SHOW TABLE
```

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

1 × SHOW FULL COLUMNS 
  FROM `joomla3_template_styles

1 × SHOW FULL COLUMNS 
  FROM `joomla3_content

1 × DELETE 
  FROM `joomla3_mi_iptable`

1 × SHOW FULL COLUMNS 
  FROM `joomla3_extensions

1 × INSERT INTO `joomla3_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('8ele9qjf4g9mle109vr6jn7kp5', 1, '1498429810', 0, '', 0

1 × UPDATE `joomla3_extensions` 
  SET `params` = '{\"mediaversion\":\"5de4372309235fed2074328a797ab209\"}'

Protagonistas del Elche-Albacete: hablan Rubén Cruz, Juan Carlos y Javi Paredes

Clasificación

A estas alturas

Colaboraciones

Secciones

Contacto

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

54 consultas registradas 168.61 ms

¡ 19 duplicaciones detectadas!

37 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

OTRAS tablas: