{
"__default": {
"session": {
"counter": 70,
"timer": {
"start": 1754348441,
"last": 1754348488,
"now": 1754348489
},
"token": "yaSuqSpAg7vSKDrYrGuASppquvJNPoRQ"
},
"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": [
"9"
],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0,
"gid": 1
},
"com_mailto": {
"links": {
"3b578e975f52895fbf4a958d3b8c82569e1079fb": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/19274-puebla-con-potencial-en-energias-limpias-para-movilidad-salomon",
"expiry": 1754348441
},
"d2776a4685e7290a19108d80d5b71a1ea2d4021b": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/6941-la-apuesta-por-la-familia-humana",
"expiry": 1754348443
},
"621728a6101888389c2cbdc3689f4d4f2729206e": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/6778-la-entidad-de-las-mas-inseguras-del-pais-para-mujeres",
"expiry": 1754348443
},
"c6959c5d5cfff50ed272b1e730723deb30a2ad50": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/17992-entre-enero-y-septiembre-la-ied-en-puebla-alcanzo-535-millones-de-dolares",
"expiry": 1754348444
},
"45deab89b132acd62424cace4e6d1232d59062cd": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/21312-800-mil-millones-aumento-presupuesto",
"expiry": 1754348445
},
"040385e4efc26281ef9f681fadac04bd7cd000f4": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/15154-presenta-secretaria-de-cultura-y-museos-puebla-la-iniciativa-pasaporte",
"expiry": 1754348445
},
"4d921858223e285b4f759d23e91c6e241f2c7f2d": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/27284-esquela-diario-de-puebla",
"expiry": 1754348446
},
"0c27d8dccd6a686a75fe2cc29426309297c9f02f": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/24272-mexico-registra-151-muertes-en-24-horas-por-la-covid-19",
"expiry": 1754348447
},
"b62b655e7f134d2535cface512787b514a005d7c": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/6953-cultura-del-agua-i",
"expiry": 1754348448
},
"befd45e28db71431c3a04f0fa767fe40c1604492": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/18943-62-42-de-poblanos-infectados-de-coronavirus-amg",
"expiry": 1754348449
},
"9211c716cadc49f790725c77185d9f2c7ed5fba8": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/2284-el-fracaso-ha-de-reconciliarnos",
"expiry": 1754348449
},
"bc51e73fde203fd821fe6fccaf21deab37207829": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/28788-presupuesto-para-el-bienestar-imv",
"expiry": 1754348450
},
"660b98e1decf7964d2afd12ae92efe6bcc02d680": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/13484-atiende-ibero-puebla-a-personal-de-cruz-roja-mexicana?print=1&tmpl=component",
"expiry": 1754348451
},
"1a403548332d7c9a8fc95afea7b79a1b66a1f91b": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/15238-con-estrategia-nacional-de-primera-infancia-se-garantizaran-derechos-de-ninas-y-ninos?print=1&tmpl=component",
"expiry": 1754348451
},
"fe76678146feb062991b3380abe763dd451d7806": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/7658-autoridades-dan-seguimiento-a-agenda-de-seguridad",
"expiry": 1754348452
},
"b81a5898f3178610403dd7b279cd1a1a81119138": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/30120-guardia-nacional-dependera-de-secretaria-de-seguridad",
"expiry": 1754348453
},
"af554329de0a3a95688e37e613ce995649e99fb4": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/27684-reconocimiento-a-jesus-olguin-colaborador-de-diario-de-puebla-digital",
"expiry": 1754348454
},
"908d514cea3e655c6c83cba070ac792320dfbae2": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/18163-facultades-absolutas-al-presidente-de-scjn-da-la-reforma-judicial?print=1&tmpl=component",
"expiry": 1754348456
},
"669af4c1f39822cdc9e70323bac694d48827f146": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/1099-reciben-habitantes-de-la-junta-auxiliar-de-santa-maria-tonantzintla-jornada-de-atencion-y-gestion-ciudadana?print=1&tmpl=component",
"expiry": 1754348456
},
"2487b2b47e20713ca0dd89586e69daa4625606af": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/24242-clausuraron-casino-clandestino",
"expiry": 1754348456
},
"36526a0f45b8f411c99959cb5c329f72ec32c36a": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/28766-presupuesto-sin-ningun-fin-electoral?print=1&tmpl=component",
"expiry": 1754348457
},
"b63d7f9f967be5418277e3317a78ea75d8dd0a28": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/9608-usaid-presenta-investigacion-sobre-violencia-juvenil-y-prevencion-del-delito",
"expiry": 1754348458
},
"f265b428784450874dc72a0b1d6191aea0067739": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/8729-en-la-buap-ampliacion-de-su-oferta-educativa-de-vanguardia-aeo?print=1&tmpl=component",
"expiry": 1754348458
},
"97b9d7ae81544d8ba93f5365388a942b8cb57292": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/4492-el-ocaso-internacional-mexicano",
"expiry": 1754348459
},
"ed62bec91310c39d11e603f1ebc8e47684a57aba": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/33426-la-economia-de-puebla-se-mantiene-entre-las-10-top-de-mexico?print=1&tmpl=component",
"expiry": 1754348460
},
"3fe0aa7e122cbe744f03c2c91140eae6786ba568": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/15603-mexico-adelantado-en-prevencion-contra-el-coronavirus-oms-y-ops?print=1&tmpl=component",
"expiry": 1754348460
},
"794ca07cbe18b3db0b9785af25d81040d3e8d9e2": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/4481-sorprendido-el-senador-panista-romero-hicks-por-el-padron-de-su-partido-en-puebla?print=1&tmpl=component",
"expiry": 1754348461
},
"64162b92ac48ade208918c0748155a9624f2cfe7": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/7846-tierra-sagrada-conquista-la-feria-de-puebla",
"expiry": 1754348461
},
"e6468fb4793ab6d77ab4e84257ba04cdc6d78c24": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/10095-espiritu-mundano-que-contamina-el-mundo-papa-francisco?print=1&tmpl=component",
"expiry": 1754348462
},
"ed32b8ba96e23af150a4de6e525cae65f69870ad": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/21903-esquela-diario-de-puebla?print=1&tmpl=component",
"expiry": 1754348462
},
"4fe43691cea4b67cea43a6f77ff9a669236d6aa1": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/14677-destruccion-del-patrimonio-historico",
"expiry": 1754348462
},
"cb06301196744659eb077743e54df4f36494430a": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/18173-reporta-salud-1-millon-205-mil-229-casos-positivos-por-covid-19-111-655-decesos",
"expiry": 1754348463
},
"80a6b32d3ec0c83c15c87a31476c509b385ec6ae": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/30162-mexicana-de-aviacion-a-20-destinos?print=1&tmpl=component",
"expiry": 1754348464
},
"02a3f0942699f954c52f958c56817f0791c8a68b": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/15018-presidente-reafirma-trabajo-coordinado-con-gobiernos-estatales",
"expiry": 1754348464
},
"6d0a59ed3c365b77d3d3b3c43d891a1dbcd92758": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/13651-san-andres-cholula-se-alista-para-el-encuentro-nacional-de-artesanos?print=1&tmpl=component",
"expiry": 1754348465
},
"97dde28636ec1803af7f0cbdbec7dc7886a566c3": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/25749-el-proceso-legislativo-avanza-aam",
"expiry": 1754348466
},
"f55cb1648ca46c48d8645c4a98eec353e5435cfe": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/30399-vienen-las-reformas-electoreras-de-amlo",
"expiry": 1754348466
},
"d4b4b40bf4d9bb2ca7702231b1dfecc2513c0c19": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/31330-mario-riestra-se-compromete-con-el-seguro-de-desempleo",
"expiry": 1754348467
},
"f5ebe34a15e126824a2f680f2f384ff0e4456a74": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/9616-mike-pompeo-envia-felicitacion-por-aniversario-de-la-independencia-de-mexico?print=1&tmpl=component",
"expiry": 1754348469
},
"c90be57cf4392cfe1dea2514abbc8ea71195570d": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/22926-motorola-lider-en-la-industria-en-mexico",
"expiry": 1754348469
},
"3814343eacfae41334c900a8664d13b93f1b2659": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/15440-puebla-socio-comercial-competitivo-para-la-union-europea?print=1&tmpl=component",
"expiry": 1754348470
},
"3eac0c438a7d7fd19efbab9a418e98b42de7ad1c": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/11715-samsung-mexico-presenta-nuevos-dispositivos",
"expiry": 1754348470
},
"54662b257ec4b8f33903eb9228c2f4cd443afa7b": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/24533-asesoria-juridica-en-tlachichuca-segob",
"expiry": 1754348471
},
"abb5ef8d0e927a75ebccb41c976edf15c410c01a": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/6186-el-feminicidio-mas-grave-y-cruel-que-el-homicidio-doloso",
"expiry": 1754348472
},
"fc52dfadff3c07cc89f51f4cb82c76751325ae6c": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/26886-vital-analizar-la-politica-migratoria?print=1&tmpl=component",
"expiry": 1754348473
},
"a5405752852737e732effce2fbfbce5ed8b2e586": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/15483-seguridad-y-valoracion-exigen-las-mujeres",
"expiry": 1754348473
},
"722eb4501cdce8ff3e51f60beb54daf506257195": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/1101-ayuntamiento-y-buap-trabajan-en-la-conservacion-del-archivo-historico-municipal?print=1&tmpl=component",
"expiry": 1754348474
},
"296d97bdf571b53e705f87bdd8b925492e02e84e": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/8773-asume-la-dra-velez-iglesias-la-direccion-general-academica-de-la-ibero-puebla?print=1&tmpl=component",
"expiry": 1754348474
},
"8633ccf19b64850b40f15465525d87f1f2528a69": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/5522-aurelio-nuno-y-tony-gali-anuncian-mil-900-mdp-para-rehabilitacion-de-escuelas?print=1&tmpl=component",
"expiry": 1754348475
},
"d35af7abf96c7feac5da1620e98d54b553fc9ce7": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/15863-suman-857-decesos-por-covid-19-en-mexico",
"expiry": 1754348475
},
"395a40f6ce8fb75d3d5eead3412bc4604dd4f5f1": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/26138-fortalecer-a-policias-municipales-scp",
"expiry": 1754348476
},
"1d601629447130d23ac6cb3d05e90fbb0b3d0e47": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/4361-leo-paisano-y-lety-zamora-entregan-aulas-de-medios-en-beneficio-de-la-ninez-sanandresena?print=1&tmpl=component",
"expiry": 1754348476
},
"c888f2e331a143b2c15077b016da009cd3bde33d": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/14313-gobierno-impulsara-a-empresas-poblanas-promete-miguel-barbosa",
"expiry": 1754348477
},
"c4e7889796a91f0aa9304c7563200125b04f2e25": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/30131-ambiente-gelido-en-puebla-y-otros-estados-conagua?print=1&tmpl=component",
"expiry": 1754348478
},
"73ac5d41f06d1d4e3610e18794410c9d79ed7ba1": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/12078-seguridad-y-entornos-dignos-pilares-de-la-promocion-turistica-presidente-amlo?print=1&tmpl=component",
"expiry": 1754348478
},
"2f832c18188571a255b77bbb70a63ee278c03564": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/26223-chidiac-y-nestor-candidatos-unidad-priista?print=1&tmpl=component",
"expiry": 1754348479
},
"61fda3a41191405a033ddb04d9a8879d4e772465": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/24742-evitan-huelga-en-volkswagen?print=1&tmpl=component",
"expiry": 1754348479
},
"9cbd529ac84cb04115ed0e0e42ca06d252f78b5f": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/7466-inicia-periodo-vacacional?print=1&tmpl=component",
"expiry": 1754348480
},
"f78643cb6c39a6e486142dc83c6709204bf04119": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/15136-gobiernos-somos-equilibradores-de-la-vida-social-afirma-el-gobernador-miguel-barbosa?print=1&tmpl=component",
"expiry": 1754348481
},
"fbc528981e263224ced9b028b4c8524a773cc80a": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/34910-el-plan-banca-de-la-mujer-apoyara-con-financiamiento-a-emprendedoras-y-empresarias",
"expiry": 1754348481
},
"5e8a309044088578cbdb85e36631fa4bbeb7ddbd": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/27054-exitoso-grupo-musical-blackstar-de-tehuacan?print=1&tmpl=component",
"expiry": 1754348482
},
"9d7bc404ad1b5b7b68ccc6e837e620ebb804d2b8": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/15614-alcalde-de-puebla-capital-vs-gobernador-una-constante",
"expiry": 1754348483
},
"701a8a4beacac03a3e58ec83e4e71e05a714d054": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/5434-biografia-de-lenin-para-morena-puebla?print=1&tmpl=component",
"expiry": 1754348483
},
"a00c80e0e3b7477307bdad6dec6023e218f7abc6": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/14681-declara-unesco-al-proceso-artesanal-de-la-talavera-como-patrimonio-cultural-inmaterial-de-la-humanidad",
"expiry": 1754348484
},
"385f6faeb14b8b37713d9d68bd7c3932467eca2e": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/15613-puebla-ocupa-el-sexto-lugar-en-coronavirus-con-17-casos?print=1&tmpl=component",
"expiry": 1754348484
},
"6bc3351774b3b731ec4e7bb13977fdbabdafc756": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/16425-sismo-magnitud-7-5-en-oaxaca-deja-6-fallecidos",
"expiry": 1754348488
},
"331cf30e7b5e44a7c8d823d4fad24e6501450d87": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/1782-tony-gali-facilitara-la-apertura-de-mas-empresas-en-el-estado",
"expiry": 1754348489
},
"f7033874bf155bae8368122ddaec9d9dbe454d12": {
"link": "https:\/\/www.diariodepuebla.com.mx\/component\/k2\/item\/26526-gobierno-del-estado-felicita-a-diario-de-puebla?print=1&tmpl=component",
"expiry": 1754348489
}
}
}
}
}
DELETE
FROM `qgn06_session`
WHERE `time` < '1754341289'
| # | Comunicador | Archivo y número de línea |
|---|---|---|
| 6 | JDatabaseDriverMysql->execute() | JROOT/libraries/cms/application/cms.php:765 |
| 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:404 |
| 2 | JApplicationCms::getInstance() | JROOT/libraries/joomla/factory.php:125 |
| 1 | JFactory::getApplication() | JROOT/index.php:46 |
SELECT `session_id`
FROM `qgn06_session`
WHERE `session_id` = 'np8ane8qe9b75lhgi4ckve3a47'
LIMIT 0, 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | qgn06_session | const | PRIMARY | PRIMARY | 766 | const | 1 | Using index |
| # | Comunicador | Archivo y número de línea |
|---|---|---|
| 8 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1731 |
| 7 | JDatabaseDriver->loadResult() | JROOT/libraries/cms/application/cms.php:176 |
| 6 | JApplicationCms->checkSession() | JROOT/libraries/cms/application/cms.php:774 |
| 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:404 |
| 2 | JApplicationCms::getInstance() | JROOT/libraries/joomla/factory.php:125 |
| 1 | JFactory::getApplication() | JROOT/index.php:46 |
SELECT extension_id AS id, element AS "option", params, enabled
FROM qgn06_extensions
WHERE `type` = 'component'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | qgn06_extensions | ref | extension | extension | 82 | const | 33 | Using index condition |
| # | Comunicador | Archivo y número de línea |
|---|---|---|
| 10 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1692 |
| 9 | JDatabaseDriver->loadObjectList() | Lo mismo que llamada de la línea de abajo. |
| 8 | call_user_func_array() | JROOT/libraries/joomla/cache/controller/callback.php:157 |
| 7 | JCacheControllerCallback->get() | JROOT/libraries/cms/component/helper.php:448 |
| 6 | JComponentHelper::load() | JROOT/libraries/cms/component/helper.php:43 |
| 5 | JComponentHelper::getComponent() | JROOT/libraries/cms/component/helper.php:120 |
| 4 | JComponentHelper::getParams() | JROOT/libraries/cms/application/site.php:584 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT folder AS type, element AS name, params
FROM qgn06_extensions
WHERE enabled = 1
AND type ='plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | qgn06_extensions | ref | extension | extension | 82 | const | 66 | Using index condition; Using where; Usando 'filesort' |
| # | Comunicador | Archivo y número de línea |
|---|---|---|
| 7 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1692 |
| 6 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/plugin/helper.php:310 |
| 5 | JPluginHelper::load() | JROOT/libraries/cms/plugin/helper.php:163 |
| 4 | JPluginHelper::importPlugin() | JROOT/libraries/cms/application/site.php:589 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM qgn06_menu AS m
LEFT JOIN qgn06_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 58 | Using index condition; Using where; Usando 'filesort' |
| 1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | admin_ddpue3.m.component_id | 1 | Using where |
| # | Comunicador | Archivo y número de línea |
|---|---|---|
| 16 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1692 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/menu/site.php:86 |
| 14 | JMenuSite->load() | JROOT/libraries/cms/menu/menu.php:74 |
| 13 | JMenu->__construct() | JROOT/libraries/cms/menu/site.php:57 |
| 12 | JMenuSite->__construct() | JROOT/libraries/cms/menu/menu.php:133 |
| 11 | JMenu::getInstance() | JROOT/libraries/cms/application/cms.php:435 |
| 10 | JApplicationCms->getMenu() | JROOT/libraries/cms/application/site.php:272 |
| 9 | JApplicationSite->getMenu() | JROOT/libraries/cms/router/site.php:57 |
| 8 | JRouterSite->__construct() | JROOT/libraries/cms/router/router.php:196 |
| 7 | JRouter::getInstance() | JROOT/libraries/cms/application/cms.php:531 |
| 6 | JApplicationCms::getRouter() | JROOT/libraries/cms/application/site.php:407 |
| 5 | JApplicationSite::getRouter() | JROOT/libraries/cms/application/cms.php:1097 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:763 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT id, home, template, s.params
FROM qgn06_template_styles as s
LEFT JOIN qgn06_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | extension | 82 | const | 5 | Using index condition; Using where |
| 1 | SIMPLE | s | ALL | idx_template | No pudo usarse una clave de índice | NULL | NULL | 11 | Using where; Using join buffer (flat, BNL join) |
| # | Comunicador | Archivo y número de línea |
|---|---|---|
| 13 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1692 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/application/site.php:484 |
| 11 | JApplicationSite->getTemplate() | JROOT/plugins/system/gantry5/gantry5.php:123 |
| 10 | plgSystemGantry5->onAfterRouteSite() | JROOT/plugins/system/gantry5/gantry5.php:56 |
| 9 | plgSystemGantry5->onAfterRoute() | Lo mismo que llamada de la línea de abajo. |
| 8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:69 |
| 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:1107 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:763 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT extension_id AS id, element AS "option", params, enabled
FROM qgn06_extensions
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | qgn06_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using index condition |
| # | Comunicador | Archivo y número de línea |
|---|---|---|
| 24 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1653 |
| 23 | JDatabaseDriver->loadObject() | Lo mismo que llamada de la línea de abajo. |
| 22 | call_user_func_array() | JROOT/libraries/joomla/cache/controller/callback.php:157 |
| 21 | JCacheControllerCallback->get() | JROOT/libraries/cms/library/helper.php:156 |
| 20 | JLibraryHelper::_load() | JROOT/libraries/cms/library/helper.php:47 |
| 19 | JLibraryHelper::getLibrary() | JROOT/libraries/cms/library/helper.php:90 |
| 18 | JLibraryHelper::getParams() | JROOT/libraries/cms/version/version.php:274 |
| 17 | JVersion->getMediaVersion() | JROOT/libraries/joomla/factory.php:737 |
| 16 | JFactory::createDocument() | JROOT/libraries/joomla/factory.php:216 |
| 15 | JFactory::getDocument() | JROOT/libraries/gantry5/classes/Gantry/Framework/Theme.php:116 |
| 14 | Gantry\Framework\Theme->init() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:64 |
| 13 | Gantry\Component\Theme\AbstractTheme->__construct() | JROOT/templates/g5_hydrogen/includes/theme.php:28 |
| 12 | plgSystemGantry5->{closure}() | JROOT/libraries/gantry5/vendor/pimple/pimple/src/Pimple/Container.php:113 |
| 11 | Pimple\Container->offsetGet() | JROOT/plugins/system/gantry5/gantry5.php:153 |
| 10 | plgSystemGantry5->onAfterRouteSite() | JROOT/plugins/system/gantry5/gantry5.php:56 |
| 9 | plgSystemGantry5->onAfterRoute() | Lo mismo que llamada de la línea de abajo. |
| 8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:69 |
| 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:1107 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:763 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
UPDATE `qgn06_extensions`
SET `params` = '{\"mediaversion\":\"8d9f56f0c8b5669cd659459f4256d450\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
| # | Comunicador | Archivo y número de línea |
|---|---|---|
| 20 | JDatabaseDriverMysql->execute() | JROOT/libraries/cms/library/helper.php:119 |
| 19 | JLibraryHelper::saveParams() | JROOT/libraries/cms/version/version.php:325 |
| 18 | JVersion->setMediaVersion() | JROOT/libraries/cms/version/version.php:284 |
| 17 | JVersion->getMediaVersion() | JROOT/libraries/joomla/factory.php:737 |
| 16 | JFactory::createDocument() | JROOT/libraries/joomla/factory.php:216 |
| 15 | JFactory::getDocument() | JROOT/libraries/gantry5/classes/Gantry/Framework/Theme.php:116 |
| 14 | Gantry\Framework\Theme->init() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:64 |
| 13 | Gantry\Component\Theme\AbstractTheme->__construct() | JROOT/templates/g5_hydrogen/includes/theme.php:28 |
| 12 | plgSystemGantry5->{closure}() | JROOT/libraries/gantry5/vendor/pimple/pimple/src/Pimple/Container.php:113 |
| 11 | Pimple\Container->offsetGet() | JROOT/plugins/system/gantry5/gantry5.php:153 |
| 10 | plgSystemGantry5->onAfterRouteSite() | JROOT/plugins/system/gantry5/gantry5.php:56 |
| 9 | plgSystemGantry5->onAfterRoute() | Lo mismo que llamada de la línea de abajo. |
| 8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:69 |
| 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:1107 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:763 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT s.id, e.extension_id, s.template AS name, s.title, s.params
FROM qgn06_template_styles AS s
LEFT JOIN qgn06_extensions AS e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
AND e.state = 0
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | extension | 82 | const | 5 | Using index condition; Using where |
| 1 | SIMPLE | s | ALL | idx_template | No pudo usarse una clave de índice | NULL | NULL | 11 | Using where; Using join buffer (flat, BNL join) |
| # | Comunicador | Archivo y número de línea |
|---|---|---|
| 17 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1692 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/gantry5/classes/Gantry/Admin/ThemeList.php:88 |
| 15 | Gantry\Admin\ThemeList::loadStyles() | JROOT/libraries/gantry5/classes/Gantry/Admin/ThemeList.php:56 |
| 14 | Gantry\Admin\ThemeList::getStyles() | JROOT/libraries/gantry5/classes/Gantry/Framework/Outlines.php:35 |
| 13 | Gantry\Framework\Outlines->load() | JROOT/libraries/gantry5/classes/Gantry/Framework/Base/Gantry.php:186 |
| 12 | Gantry\Framework\Gantry::Gantry\Framework\Base\{closure}() | JROOT/libraries/gantry5/vendor/pimple/pimple/src/Pimple/Container.php:109 |
| 11 | Pimple\Container->offsetGet() | JROOT/plugins/system/gantry5/gantry5.php:156 |
| 10 | plgSystemGantry5->onAfterRouteSite() | JROOT/plugins/system/gantry5/gantry5.php:56 |
| 9 | plgSystemGantry5->onAfterRoute() | Lo mismo que llamada de la línea de abajo. |
| 8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:69 |
| 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:1107 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:763 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT *
FROM qgn06_languages
WHERE published=1
ORDER BY ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | qgn06_languages | ALL | NULL | No pudo usarse una clave de índice | NULL | NULL | 1 | Using where; Usando 'filesort' |
| # | Comunicador | Archivo y número de línea |
|---|---|---|
| 15 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1692 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/language/helper.php:164 |
| 13 | JLanguageHelper::getLanguages() | JROOT/libraries/cms/application/site.php:329 |
| 12 | JApplicationSite->getParams() | JROOT/components/com_k2/helpers/utilities.php:305 |
| 11 | K2HelperUtilities::getParams() | JROOT/administrator/components/com_k2/helpers/html.php:56 |
| 10 | K2HelperHTML::loadjQuery() | JROOT/plugins/system/k2/k2.php:45 |
| 9 | plgSystemK2->onAfterRoute() | Lo mismo que llamada de la línea de abajo. |
| 8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:69 |
| 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:1107 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:763 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT b.rules
FROM qgn06_assets AS a
LEFT JOIN qgn06_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_k2')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | a | const | idx_asset_name | idx_asset_name | 202 | const | 1 | Using temporary; Usando 'filesort' |
| 1 | SIMPLE | b | ALL | idx_lft_rgt | No pudo usarse una clave de índice | NULL | NULL | 250 | Using where |
| # | Comunicador | Archivo y número de línea |
|---|---|---|
| 11 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1541 |
| 10 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/access/access.php:246 |
| 9 | JAccess::getAssetRules() | JROOT/libraries/joomla/access/access.php:107 |
| 8 | JAccess::check() | JROOT/libraries/joomla/user/user.php:393 |
| 7 | JUser->authorise() | JROOT/components/com_k2/k2.php:16 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT b.id
FROM qgn06_usergroups AS a
LEFT JOIN qgn06_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | b | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 3 | Using where; Using index |
| # | Comunicador | Archivo y número de línea |
|---|---|---|
| 11 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1541 |
| 10 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/access/access.php:354 |
| 9 | JAccess::getGroupsByUser() | JROOT/libraries/joomla/access/access.php:111 |
| 8 | JAccess::check() | JROOT/libraries/joomla/user/user.php:393 |
| 7 | JUser->authorise() | JROOT/components/com_k2/k2.php:16 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT id
FROM qgn06_k2_categories
WHERE published=1
AND trash=0
AND access IN(1,1,5)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | qgn06_k2_categories | ref | category,published,access,trash | category | 2 | const | 56 | Using where; Using index |
| # | Comunicador | Archivo y número de línea |
|---|---|---|
| 14 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1541 |
| 13 | JDatabaseDriver->loadColumn() | JROOT/components/com_k2/helpers/permissions.php:274 |
| 12 | K2HelperPermissions::canAddItem() | JROOT/components/com_k2/views/item/view.html.php:36 |
| 11 | K2ViewItem->display() | JROOT/libraries/legacy/controller/legacy.php:690 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:80 |
| 8 | K2ControllerItem->display() | JROOT/libraries/legacy/controller/legacy.php:728 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT *
FROM qgn06_k2_items
WHERE id=26526
LIMIT 0, 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | qgn06_k2_items | const | PRIMARY | PRIMARY | 4 | const | 1 |
| # | Comunicador | Archivo y número de línea |
|---|---|---|
| 14 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1653 |
| 13 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:36 |
| 12 | K2ModelItem->getData() | JROOT/components/com_k2/views/item/view.html.php:42 |
| 11 | K2ViewItem->display() | JROOT/libraries/legacy/controller/legacy.php:690 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:80 |
| 8 | K2ControllerItem->display() | JROOT/libraries/legacy/controller/legacy.php:728 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
SHOW FULL COLUMNS
FROM `qgn06_k2_categories`
| # | Comunicador | Archivo y número de línea |
|---|---|---|
| 19 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1692 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:440 |
| 17 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/joomla/table/table.php:241 |
| 16 | JTable->getFields() | JROOT/libraries/joomla/table/table.php:162 |
| 15 | JTable->__construct() | JROOT/administrator/components/com_k2/tables/k2category.php:36 |
| 14 | TableK2Category->__construct() | JROOT/libraries/joomla/table/table.php:305 |
| 13 | JTable::getInstance() | JROOT/components/com_k2/models/item.php:74 |
| 12 | K2ModelItem->prepareItem() | JROOT/components/com_k2/views/item/view.html.php:51 |
| 11 | K2ViewItem->display() | JROOT/libraries/legacy/controller/legacy.php:690 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:80 |
| 8 | K2ControllerItem->display() | JROOT/libraries/legacy/controller/legacy.php:728 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT *
FROM qgn06_k2_categories
WHERE id = '4'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | qgn06_k2_categories | const | PRIMARY | PRIMARY | 4 | const | 1 |
| # | Comunicador | Archivo y número de línea |
|---|---|---|
| 15 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1456 |
| 14 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_k2/tables/k2category.php:67 |
| 13 | TableK2Category->load() | JROOT/components/com_k2/models/item.php:75 |
| 12 | K2ModelItem->prepareItem() | JROOT/components/com_k2/views/item/view.html.php:51 |
| 11 | K2ViewItem->display() | JROOT/libraries/legacy/controller/legacy.php:690 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:80 |
| 8 | K2ControllerItem->display() | JROOT/libraries/legacy/controller/legacy.php:728 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT id, name, parent
FROM qgn06_k2_categories
WHERE published=1
AND trash=0
AND access IN(1,1,5)
ORDER BY parent
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | qgn06_k2_categories | ref | category,published,access,trash | category | 2 | const | 56 | Using index condition; Using where; Usando 'filesort' |
| # | Comunicador | Archivo y número de línea |
|---|---|---|
| 17 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1692 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/itemlist.php:1245 |
| 15 | K2ModelItemlist->getCategoriesTree() | JROOT/components/com_k2/helpers/route.php:314 |
| 14 | K2HelperRoute::_findItem() | JROOT/components/com_k2/helpers/route.php:58 |
| 13 | K2HelperRoute::getCategoryRoute() | JROOT/components/com_k2/models/item.php:78 |
| 12 | K2ModelItem->prepareItem() | JROOT/components/com_k2/views/item/view.html.php:51 |
| 11 | K2ViewItem->display() | JROOT/libraries/legacy/controller/legacy.php:690 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:80 |
| 8 | K2ControllerItem->display() | JROOT/libraries/legacy/controller/legacy.php:728 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT tag.*
FROM qgn06_k2_tags AS tag JOIN qgn06_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published=1
AND xref.itemID = 26526
ORDER BY xref.id ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | xref | ref | tagID,itemID | itemID | 4 | const | 3 | Using where |
| 1 | SIMPLE | tag | eq_ref | PRIMARY,published | PRIMARY | 4 | admin_ddpue3.xref.tagID | 1 | Using where |
| # | Comunicador | Archivo y número de línea |
|---|---|---|
| 15 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1692 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/item.php:1406 |
| 13 | K2ModelItem->getItemTags() | JROOT/components/com_k2/models/item.php:109 |
| 12 | K2ModelItem->prepareItem() | JROOT/components/com_k2/views/item/view.html.php:51 |
| 11 | K2ViewItem->display() | JROOT/libraries/legacy/controller/legacy.php:690 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:80 |
| 8 | K2ControllerItem->display() | JROOT/libraries/legacy/controller/legacy.php:728 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT COUNT(*)
FROM qgn06_k2_comments
WHERE itemID=26526
AND published=1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | qgn06_k2_comments | ref | itemID,published,latestComments,countComments | countComments | 8 | const,const | 1 | Using index |
| # | Comunicador | Archivo y número de línea |
|---|---|---|
| 15 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1731 |
| 14 | JDatabaseDriver->loadResult() | JROOT/components/com_k2/models/item.php:1741 |
| 13 | K2ModelItem->countItemComments() | JROOT/components/com_k2/models/item.php:275 |
| 12 | K2ModelItem->prepareItem() | JROOT/components/com_k2/views/item/view.html.php:51 |
| 11 | K2ViewItem->display() | JROOT/libraries/legacy/controller/legacy.php:690 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:80 |
| 8 | K2ControllerItem->display() | JROOT/libraries/legacy/controller/legacy.php:728 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
SHOW FULL COLUMNS
FROM `qgn06_k2_items`
| # | Comunicador | Archivo y número de línea |
|---|---|---|
| 19 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1692 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:440 |
| 17 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/joomla/table/table.php:241 |
| 16 | JTable->getFields() | JROOT/libraries/joomla/table/table.php:162 |
| 15 | JTable->__construct() | JROOT/administrator/components/com_k2/tables/k2item.php:58 |
| 14 | TableK2Item->__construct() | JROOT/libraries/joomla/table/table.php:305 |
| 13 | JTable::getInstance() | JROOT/components/com_k2/models/item.php:923 |
| 12 | K2ModelItem->hit() | JROOT/components/com_k2/views/item/view.html.php:135 |
| 11 | K2ViewItem->display() | JROOT/libraries/legacy/controller/legacy.php:690 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:80 |
| 8 | K2ControllerItem->display() | JROOT/libraries/legacy/controller/legacy.php:728 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
UPDATE qgn06_k2_items
SET `hits` = (`hits` + 1)
WHERE `id` = '26526'
| Status | Duration |
|---|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| Table lock | 0.01 ms |
| After table lock | 0.01 ms |
| init | 0.04 ms |
| Updating | 0.21 ms |
| end | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| end | 0.09 ms |
| query end | 0.53 ms |
| closing tables | 0.02 ms |
| freeing items | 0.01 ms |
| updating status | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Comunicador | Archivo y número de línea |
|---|---|---|
| 14 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/table/table.php:1249 |
| 13 | JTable->hit() | JROOT/components/com_k2/models/item.php:924 |
| 12 | K2ModelItem->hit() | JROOT/components/com_k2/views/item/view.html.php:135 |
| 11 | K2ViewItem->display() | JROOT/libraries/legacy/controller/legacy.php:690 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:80 |
| 8 | K2ControllerItem->display() | JROOT/libraries/legacy/controller/legacy.php:728 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT *
FROM qgn06_k2_comments
WHERE itemID=26526
AND published=1
ORDER BY commentDate DESC
LIMIT 0, 10
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | qgn06_k2_comments | ref | itemID,published,latestComments,countComments | itemID | 4 | const | 1 | Using where; Usando 'filesort' |
| Status | Duration |
|---|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.01 ms |
| updating status | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Comunicador | Archivo y número de línea |
|---|---|---|
| 14 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1692 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/item.php:1719 |
| 12 | K2ModelItem->getItemComments() | JROOT/components/com_k2/views/item/view.html.php:241 |
| 11 | K2ViewItem->display() | JROOT/libraries/legacy/controller/legacy.php:690 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:80 |
| 8 | K2ControllerItem->display() | JROOT/libraries/legacy/controller/legacy.php:728 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT DISTINCT itemID
FROM qgn06_k2_tags_xref
WHERE tagID IN (9713,5585,43714)
AND itemID!=26526
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | qgn06_k2_tags_xref | range | tagID,itemID | tagID | 4 | NULL | 26 | Using index condition; Using where; Using temporary |
| Status | Duration |
|---|---|
| starting | 0.00 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.03 ms |
| checking privileges on cached | 0.00 ms |
| checking permissions | 0.00 ms |
| sending cached result to clien | 0.01 ms |
| updating status | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Comunicador | Archivo y número de línea |
|---|---|---|
| 14 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1541 |
| 13 | JDatabaseDriver->loadColumn() | JROOT/components/com_k2/models/itemlist.php:927 |
| 12 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:305 |
| 11 | K2ViewItem->display() | JROOT/libraries/legacy/controller/legacy.php:690 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:80 |
| 8 | K2ControllerItem->display() | JROOT/libraries/legacy/controller/legacy.php:728 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT i.*, c.alias as categoryalias
FROM qgn06_k2_items as i
LEFT JOIN qgn06_k2_categories c
ON c.id = i.catid
WHERE i.published = 1
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-08-04 23:01:29' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-08-04 23:01:29' )
AND i.access IN(1,1,5)
AND i.trash = 0
AND c.published = 1
AND c.access IN(1,1,5)
AND c.trash = 0
AND (i.id) IN (2923,3332,3094,9094,15508,15521,15524,19090,19098,21188,23141,23335,26603,26658,26883,26891,27003,30308,34781,4923,9616,11553)
ORDER BY i.created DESC
LIMIT 0, 5
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | i | range | PRIMARY,item,catid | PRIMARY | 4 | NULL | 22 | Using where; Usando 'filesort' |
| 1 | SIMPLE | c | eq_ref | PRIMARY,category,published,access,trash | PRIMARY | 4 | admin_ddpue3.i.catid | 1 | Using where |
| Status | Duration |
|---|---|
| starting | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.07 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| Table lock | 0.02 ms |
| After table lock | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| After table lock | 0.03 ms |
| init | 0.05 ms |
| optimizing | 0.03 ms |
| statistics | 0.16 ms |
| preparing | 0.09 ms |
| executing | 0.01 ms |
| Sorting result | 1.46 ms |
| Sending data | 0.25 ms |
| Waiting for query cache lock | 0.02 ms |
| Sending data | 0.11 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| updating status | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| updating status | 0.01 ms |
| storing result in query cache | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Comunicador | Archivo y número de línea |
|---|---|---|
| 14 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1692 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/itemlist.php:975 |
| 12 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:305 |
| 11 | K2ViewItem->display() | JROOT/libraries/legacy/controller/legacy.php:690 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:80 |
| 8 | K2ControllerItem->display() | JROOT/libraries/legacy/controller/legacy.php:728 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT *
FROM qgn06_k2_categories
WHERE id = '80'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | qgn06_k2_categories | const | PRIMARY | PRIMARY | 4 | const | 1 |
| Status | Duration |
|---|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.01 ms |
| updating status | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Comunicador | Archivo y número de línea |
|---|---|---|
| 16 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1456 |
| 15 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_k2/tables/k2category.php:67 |
| 14 | TableK2Category->load() | JROOT/components/com_k2/models/item.php:75 |
| 13 | K2ModelItem->prepareItem() | JROOT/components/com_k2/models/itemlist.php:988 |
| 12 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:305 |
| 11 | K2ViewItem->display() | JROOT/libraries/legacy/controller/legacy.php:690 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:80 |
| 8 | K2ControllerItem->display() | JROOT/libraries/legacy/controller/legacy.php:728 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT COUNT(*)
FROM qgn06_k2_comments
WHERE itemID=34781
AND published=1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | qgn06_k2_comments | ref | itemID,published,latestComments,countComments | countComments | 8 | const,const | 1 | Using index |
| Status | Duration |
|---|---|
| starting | 0.08 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.01 ms |
| updating status | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Comunicador | Archivo y número de línea |
|---|---|---|
| 16 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1731 |
| 15 | JDatabaseDriver->loadResult() | JROOT/components/com_k2/models/item.php:1741 |
| 14 | K2ModelItem->countItemComments() | JROOT/components/com_k2/models/item.php:275 |
| 13 | K2ModelItem->prepareItem() | JROOT/components/com_k2/models/itemlist.php:988 |
| 12 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:305 |
| 11 | K2ViewItem->display() | JROOT/libraries/legacy/controller/legacy.php:690 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:80 |
| 8 | K2ControllerItem->display() | JROOT/libraries/legacy/controller/legacy.php:728 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT COUNT(*)
FROM qgn06_k2_comments
WHERE itemID=30308
AND published=1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | qgn06_k2_comments | ref | itemID,published,latestComments,countComments | countComments | 8 | const,const | 1 | Using index |
| Status | Duration |
|---|---|
| starting | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.01 ms |
| updating status | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Comunicador | Archivo y número de línea |
|---|---|---|
| 16 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1731 |
| 15 | JDatabaseDriver->loadResult() | JROOT/components/com_k2/models/item.php:1741 |
| 14 | K2ModelItem->countItemComments() | JROOT/components/com_k2/models/item.php:275 |
| 13 | K2ModelItem->prepareItem() | JROOT/components/com_k2/models/itemlist.php:988 |
| 12 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:305 |
| 11 | K2ViewItem->display() | JROOT/libraries/legacy/controller/legacy.php:690 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:80 |
| 8 | K2ControllerItem->display() | JROOT/libraries/legacy/controller/legacy.php:728 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT *
FROM qgn06_k2_categories
WHERE id = '41'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | qgn06_k2_categories | const | PRIMARY | PRIMARY | 4 | const | 1 |
| Status | Duration |
|---|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.01 ms |
| updating status | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Comunicador | Archivo y número de línea |
|---|---|---|
| 16 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1456 |
| 15 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_k2/tables/k2category.php:67 |
| 14 | TableK2Category->load() | JROOT/components/com_k2/models/item.php:75 |
| 13 | K2ModelItem->prepareItem() | JROOT/components/com_k2/models/itemlist.php:988 |
| 12 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:305 |
| 11 | K2ViewItem->display() | JROOT/libraries/legacy/controller/legacy.php:690 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:80 |
| 8 | K2ControllerItem->display() | JROOT/libraries/legacy/controller/legacy.php:728 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT COUNT(*)
FROM qgn06_k2_comments
WHERE itemID=27003
AND published=1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | qgn06_k2_comments | ref | itemID,published,latestComments,countComments | countComments | 8 | const,const | 1 | Using index |
| Status | Duration |
|---|---|
| starting | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.03 ms |
| checking privileges on cached | 0.00 ms |
| checking permissions | 0.00 ms |
| sending cached result to clien | 0.01 ms |
| updating status | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Comunicador | Archivo y número de línea |
|---|---|---|
| 16 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1731 |
| 15 | JDatabaseDriver->loadResult() | JROOT/components/com_k2/models/item.php:1741 |
| 14 | K2ModelItem->countItemComments() | JROOT/components/com_k2/models/item.php:275 |
| 13 | K2ModelItem->prepareItem() | JROOT/components/com_k2/models/itemlist.php:988 |
| 12 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:305 |
| 11 | K2ViewItem->display() | JROOT/libraries/legacy/controller/legacy.php:690 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:80 |
| 8 | K2ControllerItem->display() | JROOT/libraries/legacy/controller/legacy.php:728 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT COUNT(*)
FROM qgn06_k2_comments
WHERE itemID=26891
AND published=1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | qgn06_k2_comments | ref | itemID,published,latestComments,countComments | countComments | 8 | const,const | 1 | Using index |
| Status | Duration |
|---|---|
| starting | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.01 ms |
| updating status | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Comunicador | Archivo y número de línea |
|---|---|---|
| 16 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1731 |
| 15 | JDatabaseDriver->loadResult() | JROOT/components/com_k2/models/item.php:1741 |
| 14 | K2ModelItem->countItemComments() | JROOT/components/com_k2/models/item.php:275 |
| 13 | K2ModelItem->prepareItem() | JROOT/components/com_k2/models/itemlist.php:988 |
| 12 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:305 |
| 11 | K2ViewItem->display() | JROOT/libraries/legacy/controller/legacy.php:690 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:80 |
| 8 | K2ControllerItem->display() | JROOT/libraries/legacy/controller/legacy.php:728 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT COUNT(*)
FROM qgn06_k2_comments
WHERE itemID=26883
AND published=1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | qgn06_k2_comments | ref | itemID,published,latestComments,countComments | countComments | 8 | const,const | 1 | Using index |
| Status | Duration |
|---|---|
| starting | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.01 ms |
| updating status | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Comunicador | Archivo y número de línea |
|---|---|---|
| 16 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1731 |
| 15 | JDatabaseDriver->loadResult() | JROOT/components/com_k2/models/item.php:1741 |
| 14 | K2ModelItem->countItemComments() | JROOT/components/com_k2/models/item.php:275 |
| 13 | K2ModelItem->prepareItem() | JROOT/components/com_k2/models/itemlist.php:988 |
| 12 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:305 |
| 11 | K2ViewItem->display() | JROOT/libraries/legacy/controller/legacy.php:690 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:80 |
| 8 | K2ControllerItem->display() | JROOT/libraries/legacy/controller/legacy.php:728 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT *
FROM qgn06_k2_items
WHERE id != 26526
AND catid=4
AND ordering > 2953
AND published=1
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2025-08-04 23:01:29' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-08-04 23:01:29' )
AND access IN(1,1,5)
AND trash=0
ORDER BY ordering ASC
LIMIT 0, 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | qgn06_k2_items | range | PRIMARY,item,catid,ordering | ordering | 4 | NULL | 13977 | Using where |
| Status | Duration |
|---|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.06 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| Table lock | 0.01 ms |
| After table lock | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| After table lock | 0.03 ms |
| init | 0.04 ms |
| optimizing | 0.03 ms |
| statistics | 0.60 ms |
| preparing | 0.04 ms |
| executing | 0.01 ms |
| Sorting result | 0.02 ms |
| Sending data | 0.20 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| updating status | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| updating status | 0.01 ms |
| storing result in query cache | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Comunicador | Archivo y número de línea |
|---|---|---|
| 14 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1653 |
| 13 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1857 |
| 12 | K2ModelItem->getNextItem() | JROOT/components/com_k2/views/item/view.html.php:322 |
| 11 | K2ViewItem->display() | JROOT/libraries/legacy/controller/legacy.php:690 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:80 |
| 8 | K2ControllerItem->display() | JROOT/libraries/legacy/controller/legacy.php:728 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT *
FROM qgn06_k2_items
WHERE id != 26526
AND catid=4
AND ordering < 2953
AND published=1
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2025-08-04 23:01:29' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-08-04 23:01:29' )
AND access IN(1,1,5)
AND trash=0
ORDER BY ordering DESC
LIMIT 0, 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | qgn06_k2_items | range | PRIMARY,item,catid,ordering | ordering | 4 | NULL | 13977 | Using where |
| Status | Duration |
|---|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| Table lock | 0.01 ms |
| After table lock | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| After table lock | 0.02 ms |
| init | 0.04 ms |
| optimizing | 0.03 ms |
| statistics | 0.10 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| Sorting result | 0.04 ms |
| Sending data | 0.09 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| updating status | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| updating status | 0.00 ms |
| storing result in query cache | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Comunicador | Archivo y número de línea |
|---|---|---|
| 14 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1653 |
| 13 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1812 |
| 12 | K2ModelItem->getPreviousItem() | JROOT/components/com_k2/views/item/view.html.php:363 |
| 11 | K2ViewItem->display() | JROOT/libraries/legacy/controller/legacy.php:690 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:80 |
| 8 | K2ControllerItem->display() | JROOT/libraries/legacy/controller/legacy.php:728 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM qgn06_modules AS m
LEFT JOIN qgn06_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN qgn06_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-08-04 23:01:29')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-08-04 23:01:29')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 0 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | ref | PRIMARY,published,newsfeeds | published | 1 | const | 144 | Using index condition; Using where; Usando 'filesort' |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | admin_ddpue3.m.module,const | 1 | Using index condition; Using where |
| 1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | admin_ddpue3.m.id | 1 | Using where; Using index |
| Status | Duration |
|---|---|
| starting | 0.02 ms |
| Waiting for query cache lock | 0.01 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 |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.03 ms |
| updating status | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Comunicador | Archivo y número de línea |
|---|---|---|
| 12 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1692 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/module/helper.php:409 |
| 10 | JModuleHelper::getModuleList() | JROOT/libraries/cms/module/helper.php:352 |
| 9 | JModuleHelper::load() | JROOT/libraries/cms/module/helper.php:84 |
| 8 | JModuleHelper::getModules() | JROOT/libraries/joomla/document/renderer/html/modules.php:40 |
| 7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:411 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:697 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:477 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1068 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:745 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:263 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
6 × SELECT COUNT(*)
FROM qgn06_k2_comments
3 × SELECT *
FROM qgn06_k2_items
3 × SELECT *
FROM qgn06_k2_categories
2 × SELECT extension_id AS id, element AS "option", params, enabled
FROM qgn06_extensions
1 × SELECT tag.*
FROM qgn06_k2_tags AS tag JOIN qgn06_k2_tags_xref AS xref
ON tag.id = xref.tagID
1 × SELECT id, name, parent
FROM qgn06_k2_categories
1 × SELECT DISTINCT itemID
FROM qgn06_k2_tags_xref
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM qgn06_modules AS m
LEFT JOIN qgn06_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN qgn06_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT i.*, c.alias as categoryalias
FROM qgn06_k2_items as i
LEFT JOIN qgn06_k2_categories c
ON c.id = i.catid
1 × SELECT *
FROM qgn06_k2_comments
1 × SELECT id
FROM qgn06_k2_categories
1 × SELECT id, home, template, s.params
FROM qgn06_template_styles as s
LEFT JOIN qgn06_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM qgn06_menu AS m
LEFT JOIN qgn06_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT folder AS type, element AS name, params
FROM qgn06_extensions
1 × SELECT s.id, e.extension_id, s.template AS name, s.title, s.params
FROM qgn06_template_styles AS s
LEFT JOIN qgn06_extensions AS e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT *
FROM qgn06_languages
1 × SELECT b.id
FROM qgn06_usergroups AS a
LEFT JOIN qgn06_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT b.rules
FROM qgn06_assets AS a
LEFT JOIN qgn06_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `session_id`
FROM `qgn06_session`
1 × UPDATE qgn06_k2_items
SET `hits` = (`hits` + 1)
1 × SHOW FULL COLUMNS
FROM `qgn06_k2_items
1 × SHOW FULL COLUMNS
FROM `qgn06_k2_categories
1 × UPDATE `qgn06_extensions`
SET `params` = '{\"mediaversion\":\"8d9f56f0c8b5669cd659459f4256d450\"}'
1 × DELETE
FROM `qgn06_session`