Yo soy empleo
Certificado digital
Horarios
Inicio
PROGRAMA LABS SOSTIENE RURAL
Se va a impartir un nuevo curso gratuito para la provincia de Córdoba, cuyo objetivo es contribuir a la creación y estabilización/consolidación
La fecha prevista de inicio es Marzo 2021.
En este curso, te ayudaremos a:
- encontrar oportunidades de negocio que puedas desarrollar.
- crear un proyecto para llevar esa idea de negocio al mundo laboral.
- conocer y aprender de la experiencia de otras personas y empresas.
- ampliar las habilidades personales y empresariales para desarrollar tu proyecto.
- actualizar formas de vender/nuevos nichos de mercado/ crear productos diferentes.
- crear tu propio puesto de trabajo.
- contribuir en la riqueza de tu municipio
Contenido Curso
Enlace a solicitud
Concesion Subvencion Memoria Democatica
En el marco de la convocatoria de Subvenciones a Entidades Locales de la provincia
orientada a la realización de actuaciones, estudio e inversiones relacionadas con la
recuperación de la Memoria Democrática de la Diputación de Córdoba - Delegación
de Memoria Democrática, el Ayuntamiento de El Viso ha puesto en marcha el
servicio de audioguías que hará más atractivas las visitas guiadas que se lleven a cabo
en el Refugio Antiaéreo de esta localidad. El Importe subvencionado ha sido
4.804,91€
Plan de Impulso a la movilidad urbana sostenible PIM
BANDO
Se pone en conocimiento de todos los vecin@s de El Viso con una antigüedad de al menos 01-01-2019, que el Ayuntamiento de El Viso (Córdoba) ha aprobado las Bases Reguladoras de Concesión de Subvenciones para la ADQUISICIÓN DE BICICLETAS, en el marco del Plan de Impulso a la Movilidad Urbana Sostenible – PIM - .
Las subvención será de 100€ para la adquisición de bicicleta mecánica de 14” a 32”, o de 250€ para bicicleta eléctrica.
El plazo para la presentación de solicitudes será de 40 días naturales desde la publicación de las Bases Reguladoras en el Tablón de Anuncios y Página Web Oficial del Ayuntamiento de El Viso (Córdoba), es decir desde el día 21 de enero hasta el 1de marzo, ambos incluidos.
Se ha de presentar la solicitud en el modelo creado al efecto que podrá retirar en estas Dependencias Municipales, Página Web Oficial, Tablón de Anuncios y Sede Electrónica del Ayuntamiento de El Viso (Córdoba).
En El Viso a 21 de enero de 2021
EL ALCALDE
Fdo: D. Juan Díaz Caballero
Enlaces
- B.O.E.
- B.O.J.A.
- B.O.P.
- Diputación de Córdoba
- Empremasa - Punto limpio
- Fondos FEDER
- Legislación
- D.O.C.E.
- Junta de Andalucia
- Agencia tributaria
- Universidad de Córdoba
- Mancomunidad de municipios "Los Pedroches"
- ADROCHES
- El Viso en PANC
- Casa Real España
- Empleo en Córdoba
- Mujer en Córdoba
- Medio ambiente
- Wikipedia
El tiempo
Ayuntamiento de El VisoPlaza de la Constitución, 1 El Viso - Córdoba Teléfono: 957 12 70 05 | Fax: 957 12 74 36 |
Aviso Legal Política de Privacidad Política de cookies |
 |
 |
Consola de Joomla! Debug
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1624446499,
"last": 1624446499,
"now": 1624446499
}
},
"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
},
"com_mailto": {
"links": {
"b4d167ab319bf60d15f1b75e316eeeed7eb9c2e2": {
"link": "http:\/\/ayto-elviso.com\/site\/index.php\/noticias-locales\/216-programa-labs-sostiene-rural",
"expiry": 1624446499
},
"a3e065abfb0101f7e50d2f25eef9359cc7c9c022": {
"link": "http:\/\/ayto-elviso.com\/site\/index.php\/noticias-locales\/217-concesion-subvencion-memoria-democatica",
"expiry": 1624446499
},
"ebb1520743774f84a38e9d1b0211db7a54af0bf4": {
"link": "http:\/\/ayto-elviso.com\/site\/index.php\/bandos\/215-plan-de-impulso-a-la-movilidad-urbana-sostenible-pim",
"expiry": 1624446499
},
"716af94f4b3086526d612645f4c8ce9469810e75": {
"link": "http:\/\/ayto-elviso.com\/site\/index.php\/bandos-mp\/214-resolucion-provisional-plan-impulso-movilidad-urbana-sostenible",
"expiry": 1624446499
}
}
}
}
}
Time
Memory
Time: 27.26 ms / 27.26 ms Memory: 0.185 MB / 0.41 MB Application: afterLoad
Time: 125.59 ms / 152.85 ms Memory: 1.649 MB / 2.06 MB Application: afterInitialise
Time: 23.97 ms / 176.82 ms Memory: 0.990 MB / 3.05 MB Application: afterRoute
Time: 6.98 ms / 183.80 ms Memory: 0.159 MB / 3.20 MB Application: beforeRenderComponent com_content
Time: 129.10 ms / 312.91 ms Memory: 1.050 MB / 4.25 MB Application: afterRenderComponent com_content
Time: 6.17 ms / 319.08 ms Memory: 0.019 MB / 4.27 MB Application: afterDispatch
Time: 31.85 ms / 350.93 ms Memory: 0.188 MB / 4.46 MB Application: beforeRenderModule mod_custom (Contar con el fútbol y punto limpio)
Time: 4.01 ms / 354.94 ms Memory: 0.012 MB / 4.47 MB Application: afterRenderModule mod_custom (Contar con el fútbol y punto limpio)
Time: 0.18 ms / 355.13 ms Memory: 0.000 MB / 4.47 MB Application: beforeRenderModule mod_custom (Info)
Time: 0.81 ms / 355.93 ms Memory: 0.007 MB / 4.48 MB Application: afterRenderModule mod_custom (Info)
Time: 0.16 ms / 356.09 ms Memory: 0.000 MB / 4.48 MB Application: beforeRenderModule mod_menu (Ayuntamiento)
Time: 12.97 ms / 369.07 ms Memory: 0.070 MB / 4.55 MB Application: afterRenderModule mod_menu (Ayuntamiento)
Time: 0.16 ms / 369.23 ms Memory: 0.000 MB / 4.54 MB Application: beforeRenderModule mod_menu (El Viso)
Time: 12.73 ms / 381.96 ms Memory: 0.071 MB / 4.61 MB Application: afterRenderModule mod_menu (El Viso)
Time: 0.15 ms / 382.11 ms Memory: 0.000 MB / 4.60 MB Application: beforeRenderModule mod_menu (Enlaces)
Time: 9.92 ms / 392.04 ms Memory: 0.056 MB / 4.66 MB Application: afterRenderModule mod_menu (Enlaces)
Time: 0.14 ms / 392.18 ms Memory: 0.000 MB / 4.65 MB Application: beforeRenderModule mod_custom (FACe)
Time: 0.82 ms / 393.00 ms Memory: 0.007 MB / 4.66 MB Application: afterRenderModule mod_custom (FACe)
Time: 0.09 ms / 393.10 ms Memory: 0.000 MB / 4.66 MB Application: beforeRenderModule mod_custom (El tiempo)
Time: 0.73 ms / 393.83 ms Memory: 0.007 MB / 4.66 MB Application: afterRenderModule mod_custom (El tiempo)
Time: 0.20 ms / 394.03 ms Memory: 0.000 MB / 4.66 MB Application: beforeRenderModule mod_custom (Sede electrónica)
Time: 0.73 ms / 394.75 ms Memory: 0.007 MB / 4.67 MB Application: afterRenderModule mod_custom (Sede electrónica)
Time: 0.20 ms / 394.96 ms Memory: 0.000 MB / 4.67 MB Application: beforeRenderModule mod_custom (Servicio gratuito de recogida de enseres)
Time: 0.88 ms / 395.84 ms Memory: 0.007 MB / 4.67 MB Application: afterRenderModule mod_custom (Servicio gratuito de recogida de enseres)
Time: 0.39 ms / 396.22 ms Memory: 0.014 MB / 4.69 MB Application: beforeRenderModule mod_slideshowck (Importantes)
Time: 38.56 ms / 434.79 ms Memory: 0.129 MB / 4.82 MB Application: afterRenderModule mod_slideshowck (Importantes)
Time: 0.54 ms / 435.33 ms Memory: 0.000 MB / 4.80 MB Application: beforeRenderModule mod_slideshowck (Slideshow CK)
Time: 6.77 ms / 442.10 ms Memory: 0.028 MB / 4.83 MB Application: afterRenderModule mod_slideshowck (Slideshow CK)
Time: 0.41 ms / 442.50 ms Memory: 0.000 MB / 4.81 MB Application: beforeRenderModule mod_maximenuck (Maximenu CK)
Time: 31.96 ms / 474.46 ms Memory: 0.257 MB / 5.07 MB Application: afterRenderModule mod_maximenuck (Maximenu CK)
Time: 115.45 ms / 589.91 ms Memory: 0.115 MB / 5.18 MB Application: afterRender
Database queries total: 42.14 ms
5.83 MB (6,114,608 Bytes)
31 Registro Consultas 42.14 ms
- Query Time: 1.50 ms Query memory: 0.019 MB Memory before query: 0.906 MB Rows returned: 0
SELECT `data`
FROM `vagfk_session`
WHERE `session_id` = 'dn3q145sr5jg48l5239dq2c256'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE vagfk_session const PRIMARY PRIMARY 766 const 1 Status Duration starting 0.11 ms checking permissions 0.02 ms Opening tables 0.64 ms After opening tables 0.01 ms System lock 0.02 ms Table lock 0.03 ms After table lock 0.01 ms init 0.04 ms optimizing 0.03 ms statistics 0.10 ms preparing 0.01 ms executing 0.03 ms end 0.01 ms query end 0.02 ms closing tables 0.12 ms freeing items 0.01 ms updating status 0.06 ms cleaning up 0.02 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 13 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:44 12 JSessionStorageDatabase->read() Same as call in the line below. 11 session_start() JROOT/libraries/joomla/session/handler/native.php:258 10 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:49 9 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:81 8 JSessionHandlerJoomla->start() JROOT/libraries/joomla/session/session.php:636 7 JSession->_start() JROOT/libraries/joomla/session/session.php:596 6 JSession->start() JROOT/libraries/cms/application/cms.php:748 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 - Query Time: 1.71 ms After last query: 5.36 ms Query memory: 0.008 MB Memory before query: 0.972 MB
DELETE
FROM `vagfk_session`
WHERE `time` < '1624445599'EXPLAIN not possible on query: DELETE FROM `vagfk_session` WHERE `time` < '1624445599'Status Duration starting 0.05 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.01 ms After table lock 0.01 ms init 0.12 ms updating 0.39 ms end 0.01 ms query end 0.90 ms closing tables 0.03 ms freeing items 0.01 ms updating status 0.04 ms cleaning up 0.01 ms # Caller File and line number 6 JDatabaseDriverMysqli->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 - Query Time: 0.49 ms After last query: 0.21 ms Query memory: 0.012 MB Memory before query: 0.984 MB Rows returned: 0
SELECT `session_id`
FROM `vagfk_session`
WHERE `session_id` = 'dn3q145sr5jg48l5239dq2c256'
LIMIT 0, 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE vagfk_session const PRIMARY PRIMARY 766 const 1 Using index Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.02 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.03 ms end 0.02 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 8 JDatabaseDriverMysqli->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 - Query Time: 1.22 ms After last query: 0.23 ms Query memory: 0.009 MB Memory before query: 0.997 MB
INSERT INTO `vagfk_session` (`session_id`, `client_id`, `time`)
VALUES ('dn3q145sr5jg48l5239dq2c256', 0, '1624446499')EXPLAIN not possible on query: INSERT INTO `vagfk_session` (`session_id`, `client_id`, `time`) VALUES ('dn3q145sr5jg48l5239dq2c256', 0, '1624446499')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.02 ms init 0.04 ms update 0.08 ms end 0.03 ms query end 0.78 ms closing tables 0.03 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 7 JDatabaseDriverMysqli->execute() JROOT/libraries/cms/application/cms.php:208 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 - Query Time: 1.11 ms After last query: 8.52 ms Query memory: 0.018 MB Memory before query: 1.078 MB Rows returned: 36
SELECT extension_id AS id, element AS "option", params, enabled
FROM vagfk_extensions
WHERE `type` = 'component'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE vagfk_extensions ref extension extension 82 const 36 Using index condition Status Duration starting 0.05 ms checking permissions 0.02 ms Opening tables 0.21 ms After opening tables 0.02 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.02 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.03 ms executing 0.01 ms Sending data 0.22 ms end 0.01 ms query end 0.02 ms closing tables 0.13 ms freeing items 0.01 ms updating status 0.06 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 9 JDatabaseDriver->loadObjectList() Same as call in the line below. 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 - Query Time: 0.84 ms After last query: 3.14 ms Query memory: 0.014 MB Memory before query: 1.139 MB Rows returned: 2
SELECT b.id
FROM vagfk_usergroups AS a
LEFT JOIN vagfk_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id 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 Status Duration starting 0.05 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.30 ms After opening tables 0.03 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.02 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.03 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.02 ms closing tables 0.05 ms freeing items 0.01 ms updating status 0.03 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1541 9 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:354 8 JAccess::getGroupsByUser() JROOT/libraries/joomla/access/access.php:423 7 JAccess::getAuthorisedViewLevels() JROOT/libraries/joomla/user/user.php:453 6 JUser->getAuthorisedViewLevels() JROOT/libraries/cms/plugin/helper.php:296 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 - Query Time: 0.60 ms After last query: 1.06 ms Query memory: 0.013 MB Memory before query: 1.159 MB Rows returned: 4
SELECT id, rules
FROM `vagfk_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE vagfk_viewlevels ALL NULL NO INDEX KEY COULD BE USED NULL NULL 4 Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.19 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.02 ms After table lock 0.01 ms init 0.03 ms optimizing 0.02 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.07 ms freeing items 0.01 ms updating status 0.03 ms cleaning up 0.01 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1497 8 JDatabaseDriver->loadAssocList() JROOT/libraries/joomla/access/access.php:440 7 JAccess::getAuthorisedViewLevels() JROOT/libraries/joomla/user/user.php:453 6 JUser->getAuthorisedViewLevels() JROOT/libraries/cms/plugin/helper.php:296 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 - Query Time: 0.93 ms After last query: 0.26 ms Query memory: 0.040 MB Memory before query: 1.178 MB Rows returned: 57
SELECT folder AS type, element AS name, params
FROM vagfk_extensions
WHERE enabled = 1
AND type ='plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE vagfk_extensions ref extension extension 82 const 72 Using index condition; Using where; Using filesort Status Duration starting 0.06 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.02 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.03 ms executing 0.01 ms Sorting result 0.31 ms Sending data 0.25 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.05 ms # Caller File and line number 7 JDatabaseDriverMysqli->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 - Query Time: 0.75 ms After last query: 9.94 ms Query memory: 0.018 MB Memory before query: 1.447 MB Rows returned: 0
SELECT `value`
FROM `vagfk_admintools_storage`
WHERE `key` = 'cparams'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.13 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.05 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.01 ms executing 0.02 ms end 0.04 ms query end 0.01 ms closing tables 0.07 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 12 JDatabaseDriver->loadResult() JROOT/administrator/components/com_admintools/Helper/Storage.php:118 11 Akeeba\AdminTools\Admin\Helper\Storage->load() JROOT/administrator/components/com_admintools/Helper/Storage.php:48 10 Akeeba\AdminTools\Admin\Helper\Storage->__construct() JROOT/administrator/components/com_admintools/Helper/Storage.php:37 9 Akeeba\AdminTools\Admin\Helper\Storage::getInstance() JROOT/plugins/system/admintools/admintools/main.php:270 8 plgSystemAdmintools->loadComponentParameters() JROOT/plugins/system/admintools/admintools/main.php:84 7 plgSystemAdmintools->__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:662 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:663 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 - Query Time: 0.65 ms After last query: 3.71 ms Query memory: 0.017 MB Memory before query: 1.476 MB Rows returned: 0
SELECT *
FROM `vagfk_admintools_wafexceptions`
WHERE NOT(`option` LIKE 'com_%')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE vagfk_admintools_wafexceptions ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.14 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.03 ms optimizing 0.03 ms statistics 0.02 ms preparing 0.02 ms executing 0.01 ms Sending data 0.04 ms end 0.02 ms query end 0.02 ms closing tables 0.09 ms freeing items 0.02 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1497 10 JDatabaseDriver->loadAssocList() JROOT/plugins/system/admintools/admintools/main.php:555 9 plgSystemAdmintools->loadWAFExceptionsSEF() JROOT/plugins/system/admintools/admintools/main.php:469 8 plgSystemAdmintools->loadWAFExceptions() JROOT/plugins/system/admintools/admintools/main.php:99 7 plgSystemAdmintools->__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:662 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:663 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 - Query Time: 0.82 ms After last query: 15.61 ms Query memory: 0.014 MB Memory before query: 1.639 MB Rows returned: 1
SELECT `enabled`
FROM `vagfk_extensions`
WHERE `element` = 'com_akeeba'
AND `type` = 'component'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE vagfk_extensions ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 Using index condition; Using where Status Duration starting 0.13 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.03 ms Table lock 0.05 ms After table lock 0.01 ms init 0.08 ms optimizing 0.03 ms statistics 0.14 ms preparing 0.02 ms executing 0.01 ms Sending data 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms updating status 0.03 ms cleaning up 0.01 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 8 JDatabaseDriver->loadResult() JROOT/plugins/system/backuponupdate/backuponupdate.php:80 7 require_once JROOT/plugins/system/backuponupdate/backuponupdate.php JROOT/libraries/cms/plugin/helper.php:230 6 JPluginHelper::import() JROOT/libraries/cms/plugin/helper.php:170 5 JPluginHelper::importPlugin() JROOT/libraries/cms/application/cms.php:662 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:663 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 - Query Time: 0.93 ms After last query: 14.31 ms Query memory: 0.019 MB Memory before query: 1.808 MB Rows returned: 1
SHOW VARIABLES LIKE "collation_database"
EXPLAIN not possible on query: SHOW VARIABLES LIKE "collation_database"Status Duration starting 0.08 ms Opening tables 0.09 ms After opening tables 0.02 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.02 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms Filling schema table 0.33 ms executing 0.01 ms Sending data 0.05 ms end 0.04 ms query end 0.01 ms closing tables 0.00 ms removing tmp table 0.02 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1653 13 JDatabaseDriver->loadObject() JROOT/libraries/joomla/database/driver/mysqli.php:337 12 JDatabaseDriverMysqli->getCollation() JROOT/plugins/system/admintools/feature/utf8mb4.php:28 11 AtsystemFeatureUtf8mb4->onAfterInitialise() JROOT/plugins/system/admintools/admintools/main.php:714 10 plgSystemAdmintools->runFeature() JROOT/plugins/system/admintools/admintools/main.php:127 9 plgSystemAdmintools->onAfterInitialise() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:663 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:663 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 - Query Time: 0.72 ms After last query: 0.27 ms Query memory: 0.017 MB Memory before query: 1.831 MB Rows returned: 0
SELECT `source`,`keepurlparams`
FROM `vagfk_admintools_redirects`
WHERE ((`dest` = 'index.php') OR (`dest` = 'index.php') OR ('index.php' LIKE `dest`))
AND `published` = '1'
ORDER BY `ordering` DESC
LIMIT 0, 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE vagfk_admintools_redirects ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where; Using filesort Status Duration starting 0.09 ms checking permissions 0.02 ms Opening tables 0.20 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.01 ms After table lock 0.01 ms init 0.02 ms optimizing 0.02 ms statistics 0.02 ms preparing 0.02 ms executing 0.01 ms Sorting result 0.06 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.07 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1764 12 JDatabaseDriver->loadRow() JROOT/plugins/system/admintools/feature/urlredir.php:89 11 AtsystemFeatureUrlredir->onAfterInitialise() JROOT/plugins/system/admintools/admintools/main.php:714 10 plgSystemAdmintools->runFeature() JROOT/plugins/system/admintools/admintools/main.php:127 9 plgSystemAdmintools->onAfterInitialise() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:663 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:663 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 - Query Time: 1.10 ms After last query: 0.24 ms Query memory: 0.016 MB Memory before query: 1.849 MB Rows returned: 0
SELECT `state`,`rule_type`
FROM `vagfk_jhackguard_ip_filters`
WHERE `ip` = '3.236.98.69'
AND `state` = 1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE vagfk_jhackguard_ip_filters ALL NULL NO INDEX KEY COULD BE USED NULL NULL 2 Using where; Using filesort Status Duration starting 0.03 ms checking permissions 0.02 ms Opening tables 0.63 ms After opening tables 0.02 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.03 ms optimizing 0.02 ms statistics 0.01 ms preparing 0.02 ms executing 0.02 ms Sorting result 0.05 ms Sending data 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.08 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1653 11 JDatabaseDriver->loadObject() JROOT/plugins/system/jhackguard/jhackguard.php:358 10 PlgSystemJhackguard->ip_is() JROOT/plugins/system/jhackguard/jhackguard.php:174 9 PlgSystemJhackguard->onAfterInitialise() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:663 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:663 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 - Query Time: 2.30 ms After last query: 11.55 ms Query memory: 0.036 MB Memory before query: 2.114 MB Rows returned: 68
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 vagfk_menu AS m
LEFT JOIN vagfk_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.lftid 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 139 Using index condition; Using where; Using filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 elviso_joomla303.m.component_id 1 Using where Status Duration starting 0.15 ms checking permissions 0.01 ms checking permissions 0.02 ms Opening tables 0.36 ms After opening tables 0.02 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.03 ms optimizing 0.03 ms statistics 0.14 ms preparing 0.05 ms executing 0.01 ms Sorting result 0.61 ms Sending data 0.57 ms end 0.01 ms query end 0.02 ms closing tables 0.10 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->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 - Query Time: 0.59 ms After last query: 6.09 ms Query memory: 0.024 MB Memory before query: 2.936 MB Rows returned: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM vagfk_extensions
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE vagfk_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using index condition Status Duration starting 0.07 ms checking permissions 0.03 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.00 ms After table lock 0.01 ms init 0.03 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.02 ms executing 0.00 ms Sending data 0.06 ms end 0.02 ms query end 0.03 ms closing tables 0.02 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1653 18 JDatabaseDriver->loadObject() Same as call in the line below. 17 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:157 16 JCacheControllerCallback->get() JROOT/libraries/cms/library/helper.php:156 15 JLibraryHelper::_load() JROOT/libraries/cms/library/helper.php:47 14 JLibraryHelper::getLibrary() JROOT/libraries/cms/library/helper.php:90 13 JLibraryHelper::getParams() JROOT/libraries/cms/version/version.php:274 12 JVersion->getMediaVersion() JROOT/libraries/joomla/factory.php:737 11 JFactory::createDocument() JROOT/libraries/joomla/factory.php:216 10 JFactory::getDocument() JROOT/plugins/system/jcktypography/jcktypography.php:48 9 plgSystemJCKtypography->onAfterRoute() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php: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 - Query Time: 1.24 ms After last query: 3.32 ms Query memory: 0.018 MB Memory before query: 2.960 MB
UPDATE `vagfk_extensions`
SET `params` = '{\"mediaversion\":\"818a37133c8717fb8f14e31c5e231ef4\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN not possible on query: UPDATE `vagfk_extensions` SET `params` = '{\"mediaversion\":\"818a37133c8717fb8f14e31c5e231ef4\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.04 ms System lock 0.02 ms Table lock 0.02 ms After table lock 0.01 ms init 0.06 ms Updating 0.11 ms end 0.01 ms query end 0.81 ms closing tables 0.02 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/cms/library/helper.php:119 14 JLibraryHelper::saveParams() JROOT/libraries/cms/version/version.php:325 13 JVersion->setMediaVersion() JROOT/libraries/cms/version/version.php:284 12 JVersion->getMediaVersion() JROOT/libraries/joomla/factory.php:737 11 JFactory::createDocument() JROOT/libraries/joomla/factory.php:216 10 JFactory::getDocument() JROOT/plugins/system/jcktypography/jcktypography.php:48 9 plgSystemJCKtypography->onAfterRoute() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php: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 - Query Time: 0.97 ms After last query: 6.46 ms Query memory: 0.014 MB Memory before query: 3.083 MB Rows returned: 2
SELECT *
FROM vagfk_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE vagfk_languages ALL NULL NO INDEX KEY COULD BE USED NULL NULL 2 Using where; Using filesort Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.38 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.02 ms optimizing 0.02 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sorting result 0.09 ms Sending data 0.06 ms end 0.04 ms query end 0.01 ms closing tables 0.08 ms freeing items 0.01 ms updating status 0.06 ms cleaning up 0.01 ms # Caller File and line number 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 6 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/language/helper.php:164 5 JLanguageHelper::getLanguages() JROOT/libraries/cms/application/site.php:329 4 JApplicationSite->getParams() JROOT/libraries/cms/application/site.php:135 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 - Query Time: 1.00 ms After last query: 0.62 ms Query memory: 0.010 MB Memory before query: 3.108 MB Rows returned: 6
SELECT id, home, template, s.params
FROM vagfk_template_styles as s
LEFT JOIN vagfk_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 = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ALL idx_template NO INDEX KEY COULD BE USED NULL NULL 8 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 elviso_joomla303.s.template,const 1 Using index condition; Using where Status Duration starting 0.04 ms checking permissions 0.01 ms checking permissions 0.02 ms Opening tables 0.35 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.03 ms optimizing 0.03 ms statistics 0.13 ms preparing 0.03 ms executing 0.01 ms Sending data 0.15 ms end 0.02 ms query end 0.01 ms closing tables 0.04 ms freeing items 0.01 ms updating status 0.05 ms cleaning up 0.01 ms # Caller File and line number 6 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 5 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/application/site.php:484 4 JApplicationSite->getTemplate() JROOT/libraries/cms/application/site.php:165 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 1.03 ms After last query: 21.62 ms Query memory: 0.024 MB Memory before query: 3.457 MB Rows returned: 1
SELECT a.rules
FROM vagfk_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 Status Duration starting 0.13 ms checking permissions 0.02 ms Opening tables 0.26 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.05 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.03 ms executing 0.03 ms Sending data 0.05 ms end 0.02 ms query end 0.01 ms closing tables 0.04 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1541 17 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:246 16 JAccess::getAssetRules() JROOT/libraries/joomla/user/user.php:384 15 JUser->authorise() JROOT/components/com_content/models/articles.php:107 14 ContentModelArticles->populateState() JROOT/components/com_content/models/featured.php:42 13 ContentModelFeatured->populateState() JROOT/libraries/legacy/model/legacy.php:439 12 JModelLegacy->getState() JROOT/libraries/legacy/view/legacy.php:401 11 JViewLegacy->get() JROOT/components/com_content/views/featured/view.html.php:46 10 ContentViewFeatured->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 1.78 ms After last query: 1.51 ms Query memory: 0.026 MB Memory before query: 3.491 MB Rows returned: 2
SELECT b.rules
FROM vagfk_assets AS a
LEFT JOIN vagfk_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftid 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; Using filesort 1 SIMPLE b range idx_lft_rgt idx_lft_rgt 4 NULL 18 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.08 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.02 ms optimizing 0.02 ms statistics 0.16 ms preparing 0.03 ms executing 0.01 ms Creating tmp table 0.52 ms Copying to tmp table 0.28 ms Sorting result 0.07 ms Sending data 0.07 ms end 0.01 ms removing tmp table 0.10 ms end 0.01 ms query end 0.01 ms closing tables 0.08 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.03 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1541 18 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:246 17 JAccess::getAssetRules() JROOT/libraries/joomla/access/access.php:107 16 JAccess::check() JROOT/libraries/joomla/user/user.php:393 15 JUser->authorise() JROOT/components/com_content/models/articles.php:107 14 ContentModelArticles->populateState() JROOT/components/com_content/models/featured.php:42 13 ContentModelFeatured->populateState() JROOT/libraries/legacy/model/legacy.php:439 12 JModelLegacy->getState() JROOT/libraries/legacy/view/legacy.php:401 11 JViewLegacy->get() JROOT/components/com_content/views/featured/view.html.php:46 10 ContentViewFeatured->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 7.33 ms After last query: 1.98 ms Query memory: 0.034 MB Memory before query: 3.555 MB Rows returned: 4
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM vagfk_content AS a
LEFT JOIN vagfk_categories AS c
ON c.id = a.catid
LEFT JOIN vagfk_users AS ua
ON ua.id = a.created_by
LEFT JOIN vagfk_users AS uam
ON uam.id = a.modified_by
LEFT JOIN vagfk_categories as parent
ON parent.id = c.parent_id
LEFT JOIN vagfk_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM vagfk_categories AS cat JOIN vagfk_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
INNER JOIN vagfk_content_frontpage AS fp
ON fp.content_id = a.id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-06-23 11:08:19')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-06-23 11:08:19')
ORDER BY
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created DESC
LIMIT 0, 4id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY fp index PRIMARY PRIMARY 4 NULL 49 Using index; Using temporary; Using filesort 1 PRIMARY a eq_ref PRIMARY,idx_access,idx_catid PRIMARY 4 elviso_joomla303.fp.content_id 1 Using where 1 PRIMARY ua eq_ref PRIMARY PRIMARY 4 elviso_joomla303.a.created_by 1 Using where 1 PRIMARY uam eq_ref PRIMARY PRIMARY 4 elviso_joomla303.a.modified_by 1 Using where 1 PRIMARY c eq_ref PRIMARY,idx_access PRIMARY 4 elviso_joomla303.a.catid 1 Using where 1 PRIMARY parent eq_ref PRIMARY PRIMARY 4 elviso_joomla303.c.parent_id 1 Using where 1 PRIMARY v eq_ref PRIMARY PRIMARY 4 elviso_joomla303.a.id 1 Using where 1 PRIMARY <derived2> ref key0 key0 5 elviso_joomla303.c.id 2 Using where 2 DERIVED parent range cat_idx,idx_left_right cat_idx 203 NULL 2 Using index condition; Using temporary; Using filesort 2 DERIVED cat index idx_left_right idx_left_right 8 NULL 13 Using where; Using index; Using join buffer (flat, BNL join) Status Duration starting 0.36 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 2.32 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.02 ms init 0.13 ms optimizing 0.01 ms optimizing 0.03 ms statistics 0.11 ms preparing 0.08 ms statistics 0.12 ms preparing 0.04 ms executing 0.01 ms Creating tmp table 0.63 ms Copying to tmp table 0.49 ms executing 0.01 ms Creating tmp table 0.03 ms Copying to tmp table 0.07 ms Sorting result 0.04 ms Sending data 0.01 ms removing tmp table 0.01 ms Sending data 1.81 ms Sorting result 0.26 ms Sending data 0.07 ms end 0.01 ms removing tmp table 0.11 ms end 0.02 ms query end 0.01 ms closing tables 0.00 ms removing tmp table 0.02 ms closing tables 0.11 ms freeing items 0.04 ms updating status 0.04 ms cleaning up 0.01 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 16 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/model/legacy.php:312 15 JModelLegacy->_getList() JROOT/libraries/legacy/model/list.php:185 14 JModelList->getItems() JROOT/components/com_content/models/articles.php:537 13 ContentModelArticles->getItems() JROOT/components/com_content/models/featured.php:90 12 ContentModelFeatured->getItems() JROOT/libraries/legacy/view/legacy.php:401 11 JViewLegacy->get() JROOT/components/com_content/views/featured/view.html.php:47 10 ContentViewFeatured->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 1.63 ms After last query: 6.98 ms Query memory: 0.022 MB Memory before query: 3.729 MB Rows returned: 1
SELECT COUNT(*)
FROM vagfk_content AS a
LEFT JOIN vagfk_categories AS c
ON c.id = a.catid
LEFT JOIN vagfk_users AS ua
ON ua.id = a.created_by
LEFT JOIN vagfk_users AS uam
ON uam.id = a.modified_by
LEFT JOIN vagfk_categories as parent
ON parent.id = c.parent_id
LEFT JOIN vagfk_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM vagfk_categories AS cat JOIN vagfk_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
INNER JOIN vagfk_content_frontpage AS fp
ON fp.content_id = a.id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-06-23 11:08:19')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-06-23 11:08:19')id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY fp index PRIMARY PRIMARY 4 NULL 49 Using index 1 PRIMARY a eq_ref PRIMARY,idx_access,idx_catid PRIMARY 4 elviso_joomla303.fp.content_id 1 Using where 1 PRIMARY c eq_ref PRIMARY,idx_access PRIMARY 4 elviso_joomla303.a.catid 1 Using where 1 PRIMARY <derived2> ref key0 key0 5 elviso_joomla303.c.id 2 Using where 2 DERIVED parent range cat_idx,idx_left_right cat_idx 203 NULL 2 Using index condition; Using temporary; Using filesort 2 DERIVED cat index idx_left_right idx_left_right 8 NULL 13 Using where; Using index; Using join buffer (flat, BNL join) Status Duration starting 0.22 ms checking permissions 0.04 ms checking permissions 0.02 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.00 ms checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.02 ms Table lock 0.01 ms After table lock 0.01 ms init 0.08 ms optimizing 0.03 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.08 ms statistics 0.16 ms preparing 0.03 ms executing 0.02 ms Sending data 0.09 ms executing 0.01 ms Creating tmp table 0.02 ms Copying to tmp table 0.05 ms Sorting result 0.01 ms Sending data 0.01 ms removing tmp table 0.01 ms Sending data 0.24 ms end 0.02 ms query end 0.02 ms closing tables 0.01 ms removing tmp table 0.01 ms closing tables 0.01 ms freeing items 0.02 ms updating status 0.03 ms cleaning up 0.02 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 15 JDatabaseDriver->loadResult() JROOT/libraries/legacy/model/legacy.php:341 14 JModelLegacy->_getListCount() JROOT/libraries/legacy/model/list.php:290 13 JModelList->getTotal() JROOT/libraries/legacy/model/list.php:235 12 JModelList->getPagination() JROOT/libraries/legacy/view/legacy.php:401 11 JViewLegacy->get() JROOT/components/com_content/views/featured/view.html.php:48 10 ContentViewFeatured->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 2.50 ms After last query: 65.68 ms Query memory: 0.034 MB Memory before query: 4.121 MB Rows returned: 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM vagfk_categories as c
LEFT JOIN (SELECT cat.id as id
FROM vagfk_categories AS cat JOIN vagfk_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
LEFT JOIN vagfk_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,5)
AND c.published = 1
AND badcats.id is null
AND s.id=10
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.lftid select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY s const PRIMARY,idx_left_right PRIMARY 4 const 1 Using temporary; Using filesort 1 PRIMARY c ALL cat_idx,idx_access,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 13 Using where 1 PRIMARY <derived2> ref key0 key0 5 elviso_joomla303.c.id 2 Using where 2 DERIVED parent range cat_idx,idx_left_right cat_idx 203 NULL 2 Using index condition; Using temporary; Using filesort 2 DERIVED cat index idx_left_right idx_left_right 8 NULL 13 Using where; Using index; Using join buffer (flat, BNL join) Status Duration starting 0.30 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 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.19 ms optimizing 0.01 ms optimizing 0.03 ms statistics 0.11 ms preparing 0.07 ms statistics 0.18 ms preparing 0.05 ms executing 0.01 ms Creating tmp table 0.60 ms Copying to tmp table 0.07 ms executing 0.01 ms Creating tmp table 0.03 ms Copying to tmp table 0.05 ms Sorting result 0.02 ms Sending data 0.01 ms removing tmp table 0.01 ms Sending data 0.17 ms Sorting result 0.03 ms Sending data 0.06 ms end 0.01 ms removing tmp table 0.11 ms end 0.01 ms query end 0.01 ms closing tables 0.00 ms removing tmp table 0.01 ms closing tables 0.03 ms freeing items 0.03 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 19 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:309 18 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:184 17 JCategories->get() JROOT/components/com_content/helpers/route.php:44 16 ContentHelperRoute::getArticleRoute() JROOT/templates/jsn_epic_free/html/com_content/featured/default_item.php:31 15 include JROOT/templates/jsn_epic_free/html/com_content/featured/default_item.php JROOT/libraries/legacy/view/legacy.php:670 14 JViewLegacy->loadTemplate() JROOT/templates/jsn_epic_free/html/com_content/featured/default.php:28 13 include JROOT/templates/jsn_epic_free/html/com_content/featured/default.php JROOT/libraries/legacy/view/legacy.php:670 12 JViewLegacy->loadTemplate() JROOT/libraries/legacy/view/legacy.php:209 11 JViewLegacy->display() JROOT/components/com_content/views/featured/view.html.php:151 10 ContentViewFeatured->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 1.77 ms After last query: 9.43 ms Query memory: 0.034 MB Memory before query: 4.195 MB Rows returned: 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM vagfk_categories as c
LEFT JOIN (SELECT cat.id as id
FROM vagfk_categories AS cat JOIN vagfk_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
LEFT JOIN vagfk_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,5)
AND c.published = 1
AND badcats.id is null
AND s.id=9
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.lftid select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY s const PRIMARY,idx_left_right PRIMARY 4 const 1 Using temporary; Using filesort 1 PRIMARY c ALL cat_idx,idx_access,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 13 Using where 1 PRIMARY <derived2> ref key0 key0 5 elviso_joomla303.c.id 2 Using where 2 DERIVED parent range cat_idx,idx_left_right cat_idx 203 NULL 2 Using index condition; Using temporary; Using filesort 2 DERIVED cat index idx_left_right idx_left_right 8 NULL 13 Using where; Using index; Using join buffer (flat, BNL join) Status Duration starting 0.20 ms checking permissions 0.01 ms checking permissions 0.01 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.01 ms After table lock 0.02 ms init 0.10 ms optimizing 0.02 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.09 ms statistics 0.10 ms preparing 0.03 ms executing 0.01 ms Creating tmp table 0.36 ms Copying to tmp table 0.04 ms executing 0.01 ms Creating tmp table 0.03 ms Copying to tmp table 0.04 ms Sorting result 0.02 ms Sending data 0.01 ms removing tmp table 0.01 ms Sending data 0.11 ms Sorting result 0.03 ms Sending data 0.06 ms end 0.01 ms removing tmp table 0.08 ms end 0.02 ms query end 0.01 ms closing tables 0.01 ms removing tmp table 0.02 ms closing tables 0.02 ms freeing items 0.02 ms updating status 0.04 ms cleaning up 0.01 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 19 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:309 18 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:184 17 JCategories->get() JROOT/components/com_content/helpers/route.php:44 16 ContentHelperRoute::getArticleRoute() JROOT/templates/jsn_epic_free/html/com_content/featured/default_item.php:31 15 include JROOT/templates/jsn_epic_free/html/com_content/featured/default_item.php JROOT/libraries/legacy/view/legacy.php:670 14 JViewLegacy->loadTemplate() JROOT/templates/jsn_epic_free/html/com_content/featured/default.php:58 13 include JROOT/templates/jsn_epic_free/html/com_content/featured/default.php JROOT/libraries/legacy/view/legacy.php:670 12 JViewLegacy->loadTemplate() JROOT/libraries/legacy/view/legacy.php:209 11 JViewLegacy->display() JROOT/components/com_content/views/featured/view.html.php:151 10 ContentViewFeatured->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 1.66 ms After last query: 2.62 ms Query memory: 0.034 MB Memory before query: 4.235 MB Rows returned: 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM vagfk_categories as c
LEFT JOIN (SELECT cat.id as id
FROM vagfk_categories AS cat JOIN vagfk_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
LEFT JOIN vagfk_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,5)
AND c.published = 1
AND badcats.id is null
AND s.id=2
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.lftid select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY s const PRIMARY,idx_left_right PRIMARY 4 const 1 Using temporary; Using filesort 1 PRIMARY c ALL cat_idx,idx_access,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 13 Using where 1 PRIMARY <derived2> ref key0 key0 5 elviso_joomla303.c.id 2 Using where 2 DERIVED parent range cat_idx,idx_left_right cat_idx 203 NULL 2 Using index condition; Using temporary; Using filesort 2 DERIVED cat index idx_left_right idx_left_right 8 NULL 13 Using where; Using index; Using join buffer (flat, BNL join) Status Duration starting 0.15 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.00 ms After table lock 0.01 ms init 0.08 ms optimizing 0.02 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.05 ms statistics 0.09 ms preparing 0.03 ms executing 0.01 ms Creating tmp table 0.34 ms Copying to tmp table 0.04 ms executing 0.01 ms Creating tmp table 0.02 ms Copying to tmp table 0.03 ms Sorting result 0.05 ms Sending data 0.01 ms removing tmp table 0.01 ms Sending data 0.15 ms Sorting result 0.04 ms Sending data 0.05 ms end 0.01 ms removing tmp table 0.08 ms end 0.03 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.01 ms updating status 0.03 ms cleaning up 0.01 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 19 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:309 18 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:184 17 JCategories->get() JROOT/components/com_content/helpers/route.php:44 16 ContentHelperRoute::getArticleRoute() JROOT/templates/jsn_epic_free/html/com_content/featured/default_item.php:31 15 include JROOT/templates/jsn_epic_free/html/com_content/featured/default_item.php JROOT/libraries/legacy/view/legacy.php:670 14 JViewLegacy->loadTemplate() JROOT/templates/jsn_epic_free/html/com_content/featured/default.php:58 13 include JROOT/templates/jsn_epic_free/html/com_content/featured/default.php JROOT/libraries/legacy/view/legacy.php:670 12 JViewLegacy->loadTemplate() JROOT/libraries/legacy/view/legacy.php:209 11 JViewLegacy->display() JROOT/components/com_content/views/featured/view.html.php:151 10 ContentViewFeatured->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.70 ms After last query: 17.79 ms Query memory: 0.016 MB Memory before query: 4.335 MB Rows returned: 1
SELECT manifest_cache
FROM vagfk_extensions
WHERE type ="template"
AND element = "jsn_epic_free"id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE vagfk_extensions ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 Using index condition; Using where Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.04 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.02 ms init 0.03 ms optimizing 0.03 ms statistics 0.17 ms preparing 0.03 ms executing 0.01 ms Sending data 0.05 ms end 0.01 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.01 ms updating status 0.03 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 10 JDatabaseDriver->loadResult() JROOT/templates/jsn_epic_free/includes/lib/jsn_utils.php:563 9 JSNUtils->getTemplateManifestCache() JROOT/templates/jsn_epic_free/includes/jsn_setup.php:106 8 require_once JROOT/templates/jsn_epic_free/includes/jsn_setup.php JROOT/templates/jsn_epic_free/index.php:17 7 require JROOT/templates/jsn_epic_free/index.php JROOT/libraries/joomla/document/html.php:578 6 JDocumentHtml->_loadTemplate() JROOT/libraries/joomla/document/html.php:635 5 JDocumentHtml->_fetchTemplate() JROOT/libraries/joomla/document/html.php:455 4 JDocumentHtml->parse() JROOT/libraries/cms/application/cms.php:1054 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 - Query Time: 1.65 ms After last query: 2.92 ms Query memory: 0.022 MB Memory before query: 4.367 MB Rows returned: 14
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM vagfk_modules AS m
LEFT JOIN vagfk_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN vagfk_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 <= '2021-06-23 11:08:19')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-06-23 11:08:19')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 101 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref PRIMARY,published,newsfeeds published 1 const 27 Using index condition; Using where; Using filesort 1 SIMPLE mm ref PRIMARY PRIMARY 4 elviso_joomla303.m.id 1 Using where; Using index 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 elviso_joomla303.m.module,const 1 Using index condition; Using where Status Duration starting 0.09 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.44 ms After opening tables 0.02 ms System lock 0.01 ms Table lock 0.00 ms After table lock 0.01 ms init 0.04 ms optimizing 0.04 ms statistics 0.12 ms preparing 0.05 ms executing 0.04 ms Sorting result 0.22 ms Sending data 0.24 ms end 0.01 ms query end 0.02 ms closing tables 0.14 ms freeing items 0.01 ms updating status 0.03 ms cleaning up 0.02 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 13 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/module/helper.php:409 12 JModuleHelper::getModuleList() JROOT/libraries/cms/module/helper.php:352 11 JModuleHelper::load() JROOT/libraries/cms/module/helper.php:84 10 JModuleHelper::getModules() JROOT/libraries/joomla/document/html.php:501 9 JDocumentHtml->countModules() JROOT/templates/jsn_epic_free/includes/jsn_setup.php:111 8 require_once JROOT/templates/jsn_epic_free/includes/jsn_setup.php JROOT/templates/jsn_epic_free/index.php:17 7 require JROOT/templates/jsn_epic_free/index.php JROOT/libraries/joomla/document/html.php:578 6 JDocumentHtml->_loadTemplate() JROOT/libraries/joomla/document/html.php:635 5 JDocumentHtml->_fetchTemplate() JROOT/libraries/joomla/document/html.php:455 4 JDocumentHtml->parse() JROOT/libraries/cms/application/cms.php:1054 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 - Query Time: 0.65 ms After last query: 14.42 ms Query memory: 0.016 MB Memory before query: 4.437 MB Rows returned: 0
SELECT extension_id
FROM `vagfk_extensions`
WHERE enabled = 1
AND type = 'component'
AND element = 'com_k2'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE vagfk_extensions ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 Using index condition; Using where Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.04 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.03 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.04 ms executing 0.01 ms Sending data 0.05 ms end 0.01 ms query end 0.02 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 10 JDatabaseDriver->loadResult() JROOT/templates/jsn_epic_free/includes/lib/jsn_utils.php:507 9 JSNUtils->checkK2() JROOT/templates/jsn_epic_free/includes/jsn_head.php:18 8 require_once JROOT/templates/jsn_epic_free/includes/jsn_head.php JROOT/templates/jsn_epic_free/index.php:34 7 require JROOT/templates/jsn_epic_free/index.php JROOT/libraries/joomla/document/html.php:578 6 JDocumentHtml->_loadTemplate() JROOT/libraries/joomla/document/html.php:635 5 JDocumentHtml->_fetchTemplate() JROOT/libraries/joomla/document/html.php:455 4 JDocumentHtml->parse() JROOT/libraries/cms/application/cms.php:1054 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 - Query Time: 0.94 ms After last query: 116.66 ms Query memory: 0.030 MB Memory before query: 4.980 MB Rows returned: 36
SELECT *
FROM vagfk_modules
WHERE published=1
ORDER BY id ;id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE vagfk_modules ref published published 1 const 36 Using where; Using filesort Status Duration starting 0.09 ms checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.02 ms init 0.06 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.03 ms executing 0.01 ms Sorting result 0.15 ms Sending data 0.24 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.03 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 13 JDatabaseDriver->loadObjectList() JROOT/modules/mod_maximenuck/helper.php:435 12 modMaximenuckHelper::CreateModulesList() JROOT/modules/mod_maximenuck/helper.php:62 11 modMaximenuckHelper::getItems() JROOT/modules/mod_maximenuck/mod_maximenuck.php:44 10 include JROOT/modules/mod_maximenuck/mod_maximenuck.php JROOT/libraries/cms/module/helper.php:190 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: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 - Query Time: 1.04 ms After last query: 121.40 ms Query memory: 0.014 MB Memory before query: 5.209 MB Rows returned: 0
SELECT `name`,`regex`,`replacement`
FROM `vagfk_jhackguard_output_filters`
WHERE `state` = 1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.12 ms checking permissions 0.03 ms Opening tables 0.34 ms After opening tables 0.02 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.02 ms optimizing 0.03 ms statistics 0.03 ms preparing 0.01 ms executing 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.07 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 9 JDatabaseDriver->loadObjectList() JROOT/plugins/system/jhackguard/jhackguard.php:91 8 PlgSystemJhackguard->onAfterRender() Same as call in the line below. 7 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 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:1074 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
28 Tipos de consultas del registro, Ordenado por acontecimientos.
SELECCIONAR Tablas:
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 vagfk_categories as c
LEFT JOIN (SELECT cat.id as id
FROM vagfk_categories AS cat JOIN vagfk_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt2 × SELECT extension_id AS id, element AS "option", params, enabled
FROM vagfk_extensions1 × SELECT COUNT(*)
FROM vagfk_content AS a
LEFT JOIN vagfk_categories AS c
ON c.id = a.catid
LEFT JOIN vagfk_users AS ua
ON ua.id = a.created_by
LEFT JOIN vagfk_users AS uam
ON uam.id = a.modified_by
LEFT JOIN vagfk_categories as parent
ON parent.id = c.parent_id
LEFT JOIN vagfk_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM vagfk_categories AS cat JOIN vagfk_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM vagfk_content AS a
LEFT JOIN vagfk_categories AS c
ON c.id = a.catid
LEFT JOIN vagfk_users AS ua
ON ua.id = a.created_by
LEFT JOIN vagfk_users AS uam
ON uam.id = a.modified_by
LEFT JOIN vagfk_categories as parent
ON parent.id = c.parent_id
LEFT JOIN vagfk_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM vagfk_categories AS cat JOIN vagfk_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt1 × SELECT b.rules
FROM vagfk_assets AS a
LEFT JOIN vagfk_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT a.rules
FROM vagfk_assets AS a1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM vagfk_modules AS m
LEFT JOIN vagfk_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN vagfk_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT `name`,`regex`,`replacement`
FROM `vagfk_jhackguard_output_filters`1 × SELECT *
FROM vagfk_modules1 × SELECT extension_id
FROM `vagfk_extensions`1 × SELECT id, home, template, s.params
FROM vagfk_template_styles as s
LEFT JOIN vagfk_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT manifest_cache
FROM vagfk_extensions1 × 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 vagfk_menu AS m
LEFT JOIN vagfk_extensions AS e
ON m.component_id = e.extension_id1 × SELECT folder AS type, element AS name, params
FROM vagfk_extensions1 × SELECT id, rules
FROM `vagfk_viewlevels1 × SELECT b.id
FROM vagfk_usergroups AS a
LEFT JOIN vagfk_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `session_id`
FROM `vagfk_session`1 × SELECT `value`
FROM `vagfk_admintools_storage`1 × SELECT *
FROM `vagfk_admintools_wafexceptions`1 × SELECT `data`
FROM `vagfk_session`1 × SELECT `state`,`rule_type`
FROM `vagfk_jhackguard_ip_filters`1 × SELECT `source`,`keepurlparams`
FROM `vagfk_admintools_redirects`1 × SELECT `enabled`
FROM `vagfk_extensions`1 × SELECT *
FROM vagfk_languages
OTRAS Tablas:
1 × UPDATE `vagfk_extensions`
SET `params` = '{\"mediaversion\":\"818a37133c8717fb8f14e31c5e231ef4\"}'1 × SHOW VARIABLES LIKE "collation_database
1 × INSERT INTO `vagfk_session` (`session_id`, `client_id`, `time`)
VALUES ('dn3q145sr5jg48l5239dq2c256', 0, '1624446499'1 × DELETE
FROM `vagfk_session`