Yo soy empleo
Certificado digital
Horarios
Inicio
Bando
BAN D O
Se pone en conocimiento de todos los vecinos-as interesados-as que el próximo
día 16 de Marzo de 2018 se desplazará el equipo móvil de la Policía Nacional
para la renovación y expedición del DOCUMENTO NACIONAL DE
IDENTIDAD en el centro Guadalinfo (calle Blanca).
El plazo para la inscripción será hasta el día 9 de Marzo de 2018 en el
Ayuntamiento (en horario de oficina), siendo la fecha para la retirada del
Documento el día 5 de Abril de 2018, en el mismo centro.
El Viso, 9 de Enero de 2018
EL ALCALDE
BONIFICACIÓN DEL IMPUESTO SOBRE BIENES INMUEBLES DE NATURALEZA URBANA A EXPLOTACIONES GANADERAS.
EDICTO
Se pone en conocimiento de tod@s los vecin@s interesad@s que hasta el próximo día dos de marzo de dos mil dieciocho, viernes, podrán solicitar la bonificación del 50% del IBI de naturaleza urbana, a favor de los inmuebles en los que se desarrollen actividades económicas – Edificios de Uso Ganadero -.
Para ello, las construcciones estarán directamente destinadas a una explotación ganadera en régimen extensivo o intensivo, ejerciéndose la actividad de modo profesional y en activo. Los edificios habrán de ser el centro de trabajo permanente de al menos una persona a tiempo completo, incluido el dueño de la explotación.
La bonificación se podrá conceder a explotaciones que se encuentren legalizadas, por lo que deberán disponer de Licencia Municipal de Obra, o Apertura, o equivalente, no teniendo derecho a tal bonificación las edificaciones ganaderas de escasa entidad o de uso doméstico.
En El Viso a 26 de diciembre de 2017.
El Alcalde.
Fdo.: D. Juan Díaz Caballero.
Venta Entradas Auto Sacramental Reyes Magos
Ya tienes a la venta las entradas para el auto sacramental de los reyes magos 2018 en el viso click Aqui para acceder a la plataforma de venta
PROGRAMA DE TUTORIZACIÓN EN LA ADQUISICIÓN DE LENGUAS EXTRANJERAS POR PARTE DE ADULTOS
BANDO
Se comunica a todas las personas interesadas en adquirir conocimientos en inglés que el PROGRAMA DE TUTORIZACIÓN EN LA ADQUISICIÓN DE LENGUAS EXTRANJERAS POR PARTE DE ADULTOS de la Universidad de Córdoba tendrá lugar entre los meses de febrero a mayo de 2018.
Los niveles que se impartirán dentro del programa serán:
- Nivel A1 (Elemental).
- Nivel A2 (Pre-Intermedio)
- Nivel B1 (Intermedio Bajo)
Los cursos tendrán una duración de 15 semanas y combinarán actividades teóricas y prácticas. Los alumnos contarán con un seguimiento tutorial individualizado.
Las inscripciones se podrán hacer en Ayuntamiento hasta el día 30 de Noviembre.
El Viso a 24 de Octubre de 2.017 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": 1527434472,
"last": 1527434472,
"now": 1527434472
}
},
"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": {
"1b586ab92b7c50f7a9b418d49e4cea4987c4529c": {
"link": "http:\/\/ayto-elviso.com\/site\/index.php\/bandos\/203-bando-2",
"expiry": 1527434472
},
"389eb744cb44d757be8a24dc03a585dc9c76d163": {
"link": "http:\/\/ayto-elviso.com\/site\/index.php\/bandos-mp\/202-bonificacio-n-del-impuesto-sobre-bienes-inmuebles-de-naturaleza-urbana-a-explotaciones-ganaderas",
"expiry": 1527434472
},
"8d67463eb43639dd0a6d5722c300671ff43a6958": {
"link": "http:\/\/ayto-elviso.com\/site\/index.php\/bandos-mp\/201-venta-entradas-auto-sacramental-reyes-magos",
"expiry": 1527434472
},
"47d0a2cad824c555710ff7bca2c5fc54346ee2ea": {
"link": "http:\/\/ayto-elviso.com\/site\/index.php\/bandos\/200-programa-de-tutorizacio-n-en-la-adquisicio-n-de-lenguas-extranjeras-por-parte-de-adultos",
"expiry": 1527434472
}
}
}
}
}
Time
Memory
Time: 16.71 ms / 16.71 ms Memory: 0.185 MB / 0.41 MB Application: afterLoad
Time: 88.50 ms / 105.21 ms Memory: 1.669 MB / 2.08 MB Application: afterInitialise
Time: 19.46 ms / 124.67 ms Memory: 0.975 MB / 3.05 MB Application: afterRoute
Time: 4.20 ms / 128.87 ms Memory: 0.159 MB / 3.21 MB Application: beforeRenderComponent com_content
Time: 68.29 ms / 197.16 ms Memory: 1.011 MB / 4.22 MB Application: afterRenderComponent com_content
Time: 3.64 ms / 200.80 ms Memory: 0.019 MB / 4.24 MB Application: afterDispatch
Time: 15.04 ms / 215.84 ms Memory: 0.187 MB / 4.43 MB Application: beforeRenderModule mod_custom (Contar con el fútbol y punto limpio)
Time: 2.05 ms / 217.89 ms Memory: 0.012 MB / 4.44 MB Application: afterRenderModule mod_custom (Contar con el fútbol y punto limpio)
Time: 0.09 ms / 217.98 ms Memory: 0.000 MB / 4.44 MB Application: beforeRenderModule mod_custom (Info)
Time: 0.39 ms / 218.37 ms Memory: 0.007 MB / 4.44 MB Application: afterRenderModule mod_custom (Info)
Time: 0.09 ms / 218.46 ms Memory: 0.000 MB / 4.44 MB Application: beforeRenderModule mod_menu (Ayuntamiento)
Time: 6.29 ms / 224.75 ms Memory: 0.066 MB / 4.51 MB Application: afterRenderModule mod_menu (Ayuntamiento)
Time: 0.08 ms / 224.84 ms Memory: 0.000 MB / 4.50 MB Application: beforeRenderModule mod_menu (El Viso)
Time: 6.48 ms / 231.32 ms Memory: 0.071 MB / 4.58 MB Application: afterRenderModule mod_menu (El Viso)
Time: 0.07 ms / 231.38 ms Memory: 0.000 MB / 4.57 MB Application: beforeRenderModule mod_menu (Enlaces)
Time: 4.85 ms / 236.24 ms Memory: 0.056 MB / 4.62 MB Application: afterRenderModule mod_menu (Enlaces)
Time: 0.06 ms / 236.30 ms Memory: 0.000 MB / 4.62 MB Application: beforeRenderModule mod_custom (FACe)
Time: 0.37 ms / 236.67 ms Memory: 0.007 MB / 4.62 MB Application: afterRenderModule mod_custom (FACe)
Time: 0.06 ms / 236.72 ms Memory: 0.000 MB / 4.62 MB Application: beforeRenderModule mod_custom (El tiempo)
Time: 0.38 ms / 237.10 ms Memory: 0.007 MB / 4.63 MB Application: afterRenderModule mod_custom (El tiempo)
Time: 0.10 ms / 237.20 ms Memory: 0.000 MB / 4.62 MB Application: beforeRenderModule mod_custom (Sede electrónica)
Time: 0.36 ms / 237.56 ms Memory: 0.007 MB / 4.63 MB Application: afterRenderModule mod_custom (Sede electrónica)
Time: 0.08 ms / 237.64 ms Memory: 0.000 MB / 4.63 MB Application: beforeRenderModule mod_custom (Emision Directo Auto Sacramental Reyes Magos)
Time: 0.59 ms / 238.23 ms Memory: 0.007 MB / 4.64 MB Application: afterRenderModule mod_custom (Emision Directo Auto Sacramental Reyes Magos)
Time: 0.28 ms / 238.50 ms Memory: 0.013 MB / 4.65 MB Application: beforeRenderModule mod_slideshowck (Importantes)
Time: 18.98 ms / 257.48 ms Memory: 0.129 MB / 4.78 MB Application: afterRenderModule mod_slideshowck (Importantes)
Time: 0.31 ms / 257.79 ms Memory: 0.000 MB / 4.77 MB Application: beforeRenderModule mod_slideshowck (Slideshow CK)
Time: 3.79 ms / 261.57 ms Memory: 0.028 MB / 4.79 MB Application: afterRenderModule mod_slideshowck (Slideshow CK)
Time: 0.18 ms / 261.75 ms Memory: 0.000 MB / 4.77 MB Application: beforeRenderModule mod_maximenuck (Maximenu CK)
Time: 20.30 ms / 282.06 ms Memory: 0.257 MB / 5.03 MB Application: afterRenderModule mod_maximenuck (Maximenu CK)
Time: 82.54 ms / 364.59 ms Memory: 0.114 MB / 5.14 MB Application: afterRender
Database queries total: 20.79 ms
5.77 MB (6,048,552 Bytes)
31 Registro Consultas 20.79 ms
- Query Time: 0.26 ms Query memory: 0.019 MB Memory before query: 0.907 MB Rows returned: 0
SELECT `data`
FROM `vagfk_session`
WHERE `session_id` = '56ggbur1hpi7edmpgnkrht6c54'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.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms init 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.00 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.00 ms updating status 0.02 ms cleaning up 0.00 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: 0.21 ms After last query: 4.03 ms Query memory: 0.012 MB Memory before query: 0.974 MB Rows returned: 0
SELECT `session_id`
FROM `vagfk_session`
WHERE `session_id` = '56ggbur1hpi7edmpgnkrht6c54'
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.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms init 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.00 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 ms updating status 0.02 ms cleaning up 0.00 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: 2.94 ms After last query: 0.18 ms Query memory: 0.009 MB Memory before query: 0.986 MB
INSERT INTO `vagfk_session` (`session_id`, `client_id`, `time`)
VALUES ('56ggbur1hpi7edmpgnkrht6c54', 0, '1527434472')EXPLAIN not possible on query: INSERT INTO `vagfk_session` (`session_id`, `client_id`, `time`) VALUES ('56ggbur1hpi7edmpgnkrht6c54', 0, '1527434472')Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms init 0.01 ms update 0.08 ms end 0.01 ms query end 2.72 ms closing tables 0.01 ms freeing items 0.00 ms updating status 0.02 ms cleaning up 0.00 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: 0.51 ms After last query: 6.34 ms Query memory: 0.018 MB Memory before query: 1.070 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.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.00 ms After table lock 0.00 ms init 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms executing 0.00 ms Sending data 0.16 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.00 ms updating status 0.02 ms cleaning up 0.00 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.24 ms After last query: 2.87 ms Query memory: 0.014 MB Memory before query: 1.131 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.03 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms init 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 ms updating status 0.02 ms cleaning up 0.00 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.17 ms After last query: 0.80 ms Query memory: 0.013 MB Memory before query: 1.151 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.01 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms init 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 ms updating status 0.02 ms cleaning up 0.00 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.69 ms After last query: 0.16 ms Query memory: 0.040 MB Memory before query: 1.170 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.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms init 0.02 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.02 ms executing 0.00 ms Sorting result 0.22 ms Sending data 0.24 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.00 ms updating status 0.01 ms cleaning up 0.00 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.18 ms After last query: 7.35 ms Query memory: 0.018 MB Memory before query: 1.438 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.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms init 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.00 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 ms updating status 0.02 ms cleaning up 0.00 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.21 ms After last query: 2.73 ms Query memory: 0.017 MB Memory before query: 1.468 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.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms init 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 ms updating status 0.02 ms cleaning up 0.00 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.34 ms After last query: 11.26 ms Query memory: 0.014 MB Memory before query: 1.630 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.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms init 0.02 ms optimizing 0.03 ms statistics 0.07 ms preparing 0.02 ms executing 0.00 ms Sending data 0.04 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.00 ms updating status 0.02 ms cleaning up 0.00 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.39 ms After last query: 10.71 ms Query memory: 0.019 MB Memory before query: 1.799 MB Rows returned: 1
SHOW VARIABLES LIKE "collation_database"
EXPLAIN not possible on query: SHOW VARIABLES LIKE "collation_database"Status Duration starting 0.03 ms Opening tables 0.04 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms init 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Filling schema table 0.18 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.01 ms closing tables 0.00 ms freeing items 0.00 ms updating status 0.02 ms cleaning up 0.00 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.21 ms After last query: 0.22 ms Query memory: 0.017 MB Memory before query: 1.822 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.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms init 0.02 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sorting result 0.02 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 ms updating status 0.02 ms cleaning up 0.00 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: 0.45 ms After last query: 0.18 ms Query memory: 0.013 MB Memory before query: 1.839 MB
DELETE
FROM `vagfk_jhackguard_logs`
WHERE `time` < DATE_SUB(CURRENT_DATE, INTERVAL 7 DAY)EXPLAIN not possible on query: DELETE FROM `vagfk_jhackguard_logs` WHERE `time` < DATE_SUB(CURRENT_DATE, INTERVAL 7 DAY)Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms init 0.02 ms updating 0.29 ms end 0.01 ms query end 0.00 ms closing tables 0.00 ms Waiting for query cache lock 0.00 ms closing tables 0.01 ms freeing items 0.00 ms updating status 0.02 ms cleaning up 0.00 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 10 JDatabase->query() JROOT/plugins/system/jhackguard/jhackguard.php:145 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: 0.13 ms After last query: 0.13 ms Query memory: 0.013 MB Memory before query: 1.853 MB
DELETE
FROM `vagfk_jhackguard_ip_filters`
WHERE `expires` BETWEEN DATE_SUB(CURRENT_DATE, INTERVAL 36500 DAY)
AND DATE_SUB(CURRENT_DATE, INTERVAL 1 DAY)EXPLAIN not possible on query: DELETE FROM `vagfk_jhackguard_ip_filters` WHERE `expires` BETWEEN DATE_SUB(CURRENT_DATE, INTERVAL 36500 DAY) AND DATE_SUB(CURRENT_DATE, INTERVAL 1 DAY)Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms init 0.01 ms updating 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms Waiting for query cache lock 0.00 ms closing tables 0.00 ms freeing items 0.00 ms updating status 0.01 ms cleaning up 0.00 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 10 JDatabase->query() JROOT/plugins/system/jhackguard/jhackguard.php:156 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: 0.18 ms After last query: 0.13 ms Query memory: 0.016 MB Memory before query: 1.870 MB Rows returned: 0
SELECT `state`,`rule_type`
FROM `vagfk_jhackguard_ip_filters`
WHERE `ip` = '54.166.212.152'
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.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms init 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sorting result 0.01 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 ms updating status 0.01 ms cleaning up 0.00 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: 1.18 ms After last query: 8.28 ms Query memory: 0.035 MB Memory before query: 2.134 MB Rows returned: 67
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 138 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.07 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms init 0.03 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms executing 0.00 ms Sorting result 0.33 ms Sending data 0.51 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.00 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.33 ms After last query: 4.79 ms Query memory: 0.024 MB Memory before query: 2.943 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.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms init 0.02 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.00 ms Sending data 0.04 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.00 ms updating status 0.02 ms cleaning up 0.00 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: 2.85 ms After last query: 2.50 ms Query memory: 0.018 MB Memory before query: 2.966 MB
UPDATE `vagfk_extensions`
SET `params` = '{\"mediaversion\":\"ccc9f627cc88d44e9d5b7731f23c1dd3\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN not possible on query: UPDATE `vagfk_extensions` SET `params` = '{\"mediaversion\":\"ccc9f627cc88d44e9d5b7731f23c1dd3\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms init 0.05 ms Updating 0.05 ms end 0.01 ms query end 2.64 ms closing tables 0.01 ms freeing items 0.00 ms updating status 0.02 ms cleaning up 0.00 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.28 ms After last query: 4.95 ms Query memory: 0.014 MB Memory before query: 3.089 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.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms init 0.02 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sorting result 0.04 ms Sending data 0.04 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.00 ms updating status 0.02 ms cleaning up 0.00 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: 0.34 ms After last query: 0.47 ms Query memory: 0.011 MB Memory before query: 3.114 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.03 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms init 0.01 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.02 ms executing 0.00 ms Sending data 0.09 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.00 ms updating status 0.02 ms cleaning up 0.00 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: 0.35 ms After last query: 15.99 ms Query memory: 0.024 MB Memory before query: 3.463 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.06 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.00 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.01 ms Sending data 0.01 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.00 ms updating status 0.02 ms cleaning up 0.00 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: 0.92 ms After last query: 1.15 ms Query memory: 0.026 MB Memory before query: 3.497 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.03 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms init 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms executing 0.00 ms Creating tmp table 0.39 ms Copying to tmp table 0.12 ms Sorting result 0.03 ms Sending data 0.04 ms end 0.01 ms removing tmp table 0.07 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.00 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: 1.97 ms After last query: 1.09 ms Query memory: 0.034 MB Memory before query: 3.562 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 <= '2018-05-27 15:21:12')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-05-27 15:21:12')
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 38 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.14 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.01 ms init 0.08 ms optimizing 0.00 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.05 ms statistics 0.08 ms preparing 0.03 ms executing 0.00 ms Creating tmp table 0.28 ms Copying to tmp table 0.07 ms executing 0.00 ms Creating tmp table 0.01 ms Copying to tmp table 0.02 ms Sorting result 0.01 ms Sending data 0.00 ms removing tmp table 0.00 ms Sending data 0.74 ms Sorting result 0.06 ms Sending data 0.05 ms end 0.01 ms removing tmp table 0.06 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.00 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.00 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: 0.72 ms After last query: 3.21 ms Query memory: 0.022 MB Memory before query: 3.735 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 <= '2018-05-27 15:21:12')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-05-27 15:21:12')id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY fp index PRIMARY PRIMARY 4 NULL 38 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.08 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms init 0.04 ms optimizing 0.00 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.04 ms statistics 0.06 ms preparing 0.02 ms executing 0.01 ms Sending data 0.04 ms executing 0.00 ms Creating tmp table 0.01 ms Copying to tmp table 0.02 ms Sorting result 0.01 ms Sending data 0.00 ms removing tmp table 0.00 ms Sending data 0.15 ms end 0.01 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.00 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.00 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: 1.48 ms After last query: 34.15 ms Query memory: 0.034 MB Memory before query: 4.126 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.16 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.01 ms init 0.10 ms optimizing 0.00 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.05 ms statistics 0.14 ms preparing 0.04 ms executing 0.00 ms Creating tmp table 0.34 ms Copying to tmp table 0.03 ms executing 0.00 ms Creating tmp table 0.01 ms Copying to tmp table 0.03 ms Sorting result 0.01 ms Sending data 0.00 ms removing tmp table 0.00 ms Sending data 0.10 ms Sorting result 0.02 ms Sending data 0.05 ms end 0.00 ms removing tmp table 0.07 ms end 0.01 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.00 ms closing tables 0.01 ms freeing items 0.01 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: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.14 ms After last query: 3.57 ms Query memory: 0.034 MB Memory before query: 4.194 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.10 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms init 0.07 ms optimizing 0.00 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.04 ms statistics 0.08 ms preparing 0.03 ms executing 0.01 ms Creating tmp table 0.30 ms Copying to tmp table 0.03 ms executing 0.00 ms Creating tmp table 0.01 ms Copying to tmp table 0.02 ms Sorting result 0.01 ms Sending data 0.00 ms removing tmp table 0.00 ms Sending data 0.09 ms Sorting result 0.02 ms Sending data 0.05 ms end 0.00 ms removing tmp table 0.06 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.00 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.00 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.29 ms After last query: 11.94 ms Query memory: 0.016 MB Memory before query: 4.302 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.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms init 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.00 ms updating status 0.02 ms cleaning up 0.00 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: 0.64 ms After last query: 1.47 ms Query memory: 0.022 MB Memory before query: 4.334 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 <= '2018-05-27 15:21:12')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2018-05-27 15:21:12')
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.05 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms init 0.02 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.03 ms executing 0.00 ms Sorting result 0.10 ms Sending data 0.22 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.00 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.28 ms After last query: 6.42 ms Query memory: 0.016 MB Memory before query: 4.403 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.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms init 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.00 ms updating status 0.02 ms cleaning up 0.00 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.61 ms After last query: 60.04 ms Query memory: 0.029 MB Memory before query: 4.943 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.05 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.01 ms init 0.03 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.01 ms Sorting result 0.06 ms Sending data 0.23 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.00 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: 0.30 ms After last query: 87.17 ms Query memory: 0.014 MB Memory before query: 5.170 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.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.01 ms init 0.03 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.00 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.00 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
29 Tipos de consultas del registro, Ordenado por acontecimientos.
SELECCIONAR Tablas:
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.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\":\"ccc9f627cc88d44e9d5b7731f23c1dd3\"}'1 × DELETE
FROM `vagfk_jhackguard_ip_filters`1 × DELETE
FROM `vagfk_jhackguard_logs`1 × SHOW VARIABLES LIKE "collation_database
1 × INSERT INTO `vagfk_session` (`session_id`, `client_id`, `time`)
VALUES ('56ggbur1hpi7edmpgnkrht6c54', 0, '1527434472'