Yo soy empleo
Certificado digital
Horarios
Inicio
Oferta Empleo Socorrista en Piscina Municipal.
x
EDICTO
OFERTA DE TRABAJO
El Ayuntamiento de El Viso (Córdoba) abre convocatoria para cubrir el siguiente puesto de trabajo:
.- Puesto de Socorrista en Piscina Municipal.
Los interesad@s habrán de aportar la documentación que a continuación se relaciona, hasta el próximo día 20 de junio, martes, a las 12:00 horas, en las Oficinas de éste Ayuntamiento:
-
- Solicitud debidamente cumplimentada.
-
- Titulación homologada de Socorrista Acuático.
-
- Fotocopia compulsada del D.N.I.
En El Viso a 8 de junio de 2017. EL ALCALDE.
Fdo.: D. Juan Díaz Caballero
Ofertas de empleo para la Feria y Fiestas en Honor a Nuestra Patrona Santa Ana 2017
EDICTO
Se hace saber a todos los vecin@s de la Localidad interesados en ser contratados para la realización de diversos trabajos durante la Feria y Fiestas en Honor a Nuestra Patrona Santa Ana 2017, que podrán dirigirse a este Ayuntamiento y formular la correspondiente solicitud hasta el próximo día 30 de junio, viernes, a las 12:00 horas de la mañana.
Dichos trabajos consistirán en montaje y desmontaje de vallas de encierros, plaza de toros portátil, diversos trabajos en los toriles, arreglo de albero de la plaza de toros, etc.
Los puestos que se ofertan son:
.- Oficial Montador/@. Se valorará experiencia en montaje y manejo de carretilla.
.- Peon@s. Se valorará así mismo experiencia en montaje y tiempo que lleven desempleados.
En El Viso 8 de junio de 2017. EL ALCALDE.
Fdo.: D. Juan Díaz Caballero.
CONTRATO ADMINISTRATIVO ESPECIAL PARA LA CESIÓN DE USO DEL HOTEL RURAL MUNICIPAL “CASAS DE DON ADAME”
EDICTO
Expediente no: 179/2017.
Procedimiento: CONTRATO ADMINISTRATIVO ESPECIAL PARA LA CESIÓN DE USO DEL HOTEL RURAL MUNICIPAL “CASAS DE DON ADAME” Y SUS INSTALACIONES, MEDIANTE PROCEDIMIENTO ABIERTO Y TRAMITACIÓN URGENTE.
Fecha de Iniciación: 29 de mayo de 2017.
Se pone en conocimiento de todos los vecinos interesados, que hasta el próximo día 29 de junio del corriente, jueves, se podrán presentar en las oficinas de este Ayuntamiento, en horario de 08:00 a 14:30 horas, las propuestas con la documentación correspondiente, para tomar parte en el CONTRATO ADMINISTRATIVO ESPECIAL PARA LA CESIÓN DE USO DEL HOTEL RURAL MUNICIPAL “CASAS DE DON ADAME” Y SUS INSTALACIONES, MEDIANTE PROCEDIMIENTO ABIERTO Y TRAMITACIÓN URGENTE.
La antes referida documentación, así como los Pliegos correspondientes, se encuentran a disposición de todas aquellas personas interesadas en las Dependencias del Ayuntamiento de El Viso (Córdoba), en horario de 08:00 a 14:30 horas, así como en la Sede Electrónica de esta Entidad Local – http://elviso.sedelectronica.es/info.0 -.
En El Viso a 8 de junio de 2017. EL ALCALDE.
Fdo.: D. Juan Díaz Caballero.
Explotación de Bar sito en Piscina Municipal.
EDICTO
Expediente no: 178/2017.
Asunto: Explotación de Bar sito en Piscina Municipal.
Procedimiento: CONTRATO ADMINISTRATIVO ESPECIAL PARA LA EXPLOTACIÓN DE BAR SITO EN PISCINA MUNICIPAL POR PROCEDIMIENTO NEGOCIADO SIN PUBLICIDAD Y TRAMITACIÓN URGENTE.
Fecha de Iniciación: 29 de mayo de 2017.
Se pone en conocimiento de todos los vecinos interesados, que hasta el próximo día 14 de junio del corriente, lunes, se podrán presentar en las oficinas de este Ayuntamiento, en horario de 08:00 a 14:30 horas, las propuestas con la documentación correspondiente, para tomar parte en el CONTRATO ADMINISTRATIVO ESPECIAL PARA LA EXPLOTACIÓN DE BAR SITO EN PISCINA MUNICIPAL POR PROCEDIMIENTO NEGOCIADO SIN PUBLICIDAD Y TRAMITACIÓN URGENTE.
La antes referida documentación, así como los Pliegos correspondientes, se encuentran a disposición de todas aquellas personas interesadas en las Dependencias del Ayuntamiento de El Viso (Córdoba), en horario de 08:00 a 14:30 horas, así como en la Sede Electrónica de esta Entidad Local – http://elviso.sedelectronica.es/info.0 -.
En El Viso a 2 de junio de 2017. 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": 1498237881,
"last": 1498237881,
"now": 1498237881
}
},
"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": {
"5a64fab22ef3cf53a124b0f0d597371391ec0246": {
"link": "http:\/\/ayto-elviso.com\/site\/index.php\/bandos\/189-oferta-empleo-socorrista-en-piscina-municipal",
"expiry": 1498237881
},
"9d35126536a83fdd3a442fa3eeb020633d7f1197": {
"link": "http:\/\/ayto-elviso.com\/site\/index.php\/bandos\/188-ofertas-de-empleo-para-la-feria-y-fiestas-en-honor-a-nuestra-patrona-santa-ana-2017",
"expiry": 1498237881
},
"ad4614a08b065b957c9a65b9e1333b38865e1c9f": {
"link": "http:\/\/ayto-elviso.com\/site\/index.php\/bandos\/187-contrato-administrativo-especial-para-la-cesio-n-de-uso-del-hotel-rural-municipal-casas-de-don-adame",
"expiry": 1498237881
},
"e142a4bf014041de38f25f4a6235f8e2ddc3c33e": {
"link": "http:\/\/ayto-elviso.com\/site\/index.php\/bandos\/186-explotacio-n-de-bar-sito-en-piscina-municipal",
"expiry": 1498237881
}
}
}
}
}
Time
Memory
Time: 10.42 ms / 10.42 ms Memory: 0.175 MB / 0.40 MB Application: afterLoad
Time: 68.75 ms / 79.18 ms Memory: 1.625 MB / 2.02 MB Application: afterInitialise
Time: 13.00 ms / 92.18 ms Memory: 0.966 MB / 2.99 MB Application: afterRoute
Time: 5.58 ms / 97.75 ms Memory: 0.157 MB / 3.14 MB Application: beforeRenderComponent com_content
Time: 53.62 ms / 151.37 ms Memory: 0.963 MB / 4.11 MB Application: afterRenderComponent com_content
Time: 3.46 ms / 154.83 ms Memory: 0.019 MB / 4.12 MB Application: afterDispatch
Time: 22.83 ms / 177.66 ms Memory: 0.184 MB / 4.31 MB Application: beforeRenderModule mod_custom (Contar con el fútbol y punto limpio)
Time: 1.87 ms / 179.53 ms Memory: 0.011 MB / 4.32 MB Application: afterRenderModule mod_custom (Contar con el fútbol y punto limpio)
Time: 0.12 ms / 179.65 ms Memory: 0.000 MB / 4.32 MB Application: beforeRenderModule mod_custom (Info)
Time: 0.77 ms / 180.43 ms Memory: 0.007 MB / 4.32 MB Application: afterRenderModule mod_custom (Info)
Time: 0.16 ms / 180.58 ms Memory: 0.000 MB / 4.32 MB Application: beforeRenderModule mod_menu (Ayuntamiento)
Time: 7.20 ms / 187.78 ms Memory: 0.064 MB / 4.39 MB Application: afterRenderModule mod_menu (Ayuntamiento)
Time: 0.10 ms / 187.88 ms Memory: 0.000 MB / 4.38 MB Application: beforeRenderModule mod_menu (El Viso)
Time: 11.73 ms / 199.61 ms Memory: 0.071 MB / 4.45 MB Application: afterRenderModule mod_menu (El Viso)
Time: 0.10 ms / 199.71 ms Memory: 0.000 MB / 4.44 MB Application: beforeRenderModule mod_menu (Enlaces)
Time: 9.31 ms / 209.02 ms Memory: 0.056 MB / 4.50 MB Application: afterRenderModule mod_menu (Enlaces)
Time: 0.09 ms / 209.11 ms Memory: 0.000 MB / 4.49 MB Application: beforeRenderModule mod_custom (FACe)
Time: 0.77 ms / 209.89 ms Memory: 0.007 MB / 4.50 MB Application: afterRenderModule mod_custom (FACe)
Time: 0.08 ms / 209.96 ms Memory: 0.000 MB / 4.50 MB Application: beforeRenderModule mod_custom (El tiempo)
Time: 0.73 ms / 210.70 ms Memory: 0.007 MB / 4.50 MB Application: afterRenderModule mod_custom (El tiempo)
Time: 0.14 ms / 210.83 ms Memory: 0.000 MB / 4.50 MB Application: beforeRenderModule mod_custom (Sede electrónica)
Time: 0.79 ms / 211.62 ms Memory: 0.007 MB / 4.51 MB Application: afterRenderModule mod_custom (Sede electrónica)
Time: 0.12 ms / 211.74 ms Memory: 0.000 MB / 4.51 MB Application: beforeRenderModule mod_custom (Fiestas Santa Ana)
Time: 0.78 ms / 212.52 ms Memory: 0.007 MB / 4.51 MB Application: afterRenderModule mod_custom (Fiestas Santa Ana)
Time: 0.28 ms / 212.80 ms Memory: 0.014 MB / 4.53 MB Application: beforeRenderModule mod_slideshowck (Importantes)
Time: 20.92 ms / 233.71 ms Memory: 0.127 MB / 4.65 MB Application: afterRenderModule mod_slideshowck (Importantes)
Time: 0.38 ms / 234.10 ms Memory: 0.000 MB / 4.64 MB Application: beforeRenderModule mod_slideshowck (Slideshow CK)
Time: 6.92 ms / 241.01 ms Memory: 0.028 MB / 4.67 MB Application: afterRenderModule mod_slideshowck (Slideshow CK)
Time: 0.26 ms / 241.28 ms Memory: 0.000 MB / 4.65 MB Application: beforeRenderModule mod_maximenuck (Maximenu CK)
Time: 12.14 ms / 253.42 ms Memory: 0.252 MB / 4.90 MB Application: afterRenderModule mod_maximenuck (Maximenu CK)
Time: 119.52 ms / 372.94 ms Memory: 0.170 MB / 5.07 MB Application: afterRender
Database queries total: 38.55 ms
5.64 MB (5,916,432 Bytes)
32 Registro Consultas 38.55 ms
- Query Time: 0.36 ms Query memory: 0.018 MB Memory before query: 0.883 MB Rows returned: 0
SELECT `data`
FROM `vagfk_session`
WHERE `session_id` = 'ufg495dbgeg97497ld5t9lef00'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.04 ms checking permissions 0.01 ms Opening tables 0.03 ms System lock 0.01 ms init 0.02 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.00 ms executing 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms logging slow query 0.00 ms cleaning up 0.01 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.34 ms After last query: 2.88 ms Query memory: 0.008 MB Memory before query: 0.947 MB
DELETE
FROM `vagfk_session`
WHERE `time` < '1498236981'EXPLAIN not possible on query: DELETE FROM `vagfk_session` WHERE `time` < '1498236981'Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms System lock 0.01 ms init 0.07 ms updating 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms logging slow query 0.01 ms cleaning up 0.00 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.29 ms After last query: 0.19 ms Query memory: 0.012 MB Memory before query: 0.959 MB Rows returned: 0
SELECT `session_id`
FROM `vagfk_session`
WHERE `session_id` = 'ufg495dbgeg97497ld5t9lef00'
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.03 ms checking permissions 0.01 ms Opening tables 0.01 ms System lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.00 ms executing 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms logging slow query 0.00 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: 19.22 ms After last query: 0.18 ms Query memory: 0.009 MB Memory before query: 0.971 MB
INSERT INTO `vagfk_session` (`session_id`, `client_id`, `time`)
VALUES ('ufg495dbgeg97497ld5t9lef00', 0, '1498237881')EXPLAIN not possible on query: INSERT INTO `vagfk_session` (`session_id`, `client_id`, `time`) VALUES ('ufg495dbgeg97497ld5t9lef00', 0, '1498237881')Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms System lock 0.01 ms init 0.01 ms update 0.06 ms Waiting for query cache lock 0.01 ms update 0.00 ms end 0.00 ms query end 18.92 ms closing tables 0.01 ms freeing items 0.06 ms logging slow query 0.00 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.61 ms After last query: 2.81 ms Query memory: 0.017 MB Memory before query: 1.050 MB Rows returned: 35
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 35 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms System lock 0.01 ms init 0.02 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms executing 0.00 ms Sending data 0.17 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms logging slow query 0.01 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.39 ms After last query: 1.34 ms Query memory: 0.014 MB Memory before query: 1.109 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.04 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms System lock 0.01 ms init 0.02 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.00 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms logging slow query 0.00 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.28 ms After last query: 0.25 ms Query memory: 0.013 MB Memory before query: 1.128 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.02 ms checking permissions 0.01 ms Opening tables 0.01 ms System lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms logging slow query 0.01 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.94 ms After last query: 0.23 ms Query memory: 0.040 MB Memory before query: 1.147 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 where; Using filesort Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms System lock 0.01 ms init 0.02 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.02 ms executing 0.00 ms Sorting result 0.24 ms Sending data 0.29 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms logging slow query 0.01 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/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.29 ms After last query: 5.64 ms Query memory: 0.018 MB Memory before query: 1.411 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.03 ms checking permissions 0.01 ms Opening tables 0.01 ms System lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.00 ms executing 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms logging slow query 0.00 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.32 ms After last query: 0.75 ms Query memory: 0.016 MB Memory before query: 1.440 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.03 ms checking permissions 0.01 ms Opening tables 0.01 ms System lock 0.01 ms init 0.02 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.05 ms logging slow query 0.01 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.37 ms After last query: 6.09 ms Query memory: 0.013 MB Memory before query: 1.597 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 where Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms System lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms logging slow query 0.01 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.50 ms After last query: 4.03 ms Query memory: 0.019 MB Memory before query: 1.761 MB Rows returned: 1
SHOW VARIABLES LIKE "collation_database"
EXPLAIN not possible on query: SHOW VARIABLES LIKE "collation_database"Status Duration starting 0.02 ms Opening tables 0.03 ms System lock 0.01 ms init 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.23 ms Sending data 0.01 ms end 0.01 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.03 ms logging slow query 0.00 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.34 ms After last query: 0.29 ms Query memory: 0.017 MB Memory before query: 1.784 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.04 ms checking permissions 0.01 ms Opening tables 0.01 ms System lock 0.01 ms init 0.02 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sorting result 0.03 ms Sending data 0.01 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.04 ms logging slow query 0.00 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: 0.26 ms After last query: 0.22 ms Query memory: 0.013 MB Memory before query: 1.800 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.03 ms checking permissions 0.01 ms Opening tables 0.02 ms System lock 0.01 ms init 0.03 ms updating 0.02 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.04 ms logging slow query 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.31 ms After last query: 0.20 ms Query memory: 0.016 MB Memory before query: 1.818 MB Rows returned: 0
SELECT `state`,`rule_type`
FROM `vagfk_jhackguard_ip_filters`
WHERE `ip` = '185.93.229.15'
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.01 ms Opening tables 0.01 ms System lock 0.01 ms init 0.02 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sorting result 0.02 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.04 ms logging slow query 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.39 ms After last query: 4.91 ms Query memory: 0.035 MB Memory before query: 2.076 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 where; Using filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 elviso_joomla303.m.component_id 1 Status Duration starting 0.06 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms System lock 0.01 ms init 0.03 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms executing 0.00 ms Sorting result 0.27 ms Sending data 0.65 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms logging slow query 0.00 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.38 ms After last query: 5.71 ms Query memory: 0.024 MB Memory before query: 2.880 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 where Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.02 ms System lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms logging slow query 0.01 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: 0.88 ms After last query: 1.00 ms Query memory: 0.018 MB Memory before query: 2.902 MB
UPDATE `vagfk_extensions`
SET `params` = '{\"mediaversion\":\"2127d15223d014a6853374533ee8dce3\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN not possible on query: UPDATE `vagfk_extensions` SET `params` = '{\"mediaversion\":\"2127d15223d014a6853374533ee8dce3\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms System lock 0.01 ms init 0.09 ms Updating 0.06 ms end 0.01 ms Waiting for query cache lock 0.00 ms end 0.01 ms query end 0.50 ms closing tables 0.01 ms freeing items 0.04 ms logging slow query 0.01 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.35 ms After last query: 3.07 ms Query memory: 0.014 MB Memory before query: 3.023 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 System lock 0.01 ms init 0.02 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sorting result 0.03 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms logging slow query 0.00 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.47 ms After last query: 0.62 ms Query memory: 0.010 MB Memory before query: 3.048 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 where Status Duration starting 0.04 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms System lock 0.01 ms init 0.02 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms executing 0.00 ms Sending data 0.11 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms logging slow query 0.00 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: 0.40 ms After last query: 11.16 ms Query memory: 0.024 MB Memory before query: 3.392 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.04 ms checking permissions 0.01 ms Opening tables 0.02 ms System lock 0.01 ms init 0.02 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.01 ms Sending data 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms logging slow query 0.01 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: 0.98 ms After last query: 1.12 ms Query memory: 0.025 MB Memory before query: 3.425 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.05 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms System lock 0.01 ms init 0.02 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms Creating tmp table 0.33 ms executing 0.01 ms Copying to tmp table 0.13 ms Sorting result 0.03 ms Sending data 0.03 ms end 0.01 ms removing tmp table 0.09 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms logging slow query 0.00 ms cleaning up 0.01 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: 2.44 ms After last query: 1.15 ms Query memory: 0.033 MB Memory before query: 3.489 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 <= '2017-06-23 17:11:21')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-06-23 17:11:21')
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 <derived2> system NULL NO INDEX KEY COULD BE USED NULL NULL 0 const row not found 1 PRIMARY fp index PRIMARY PRIMARY 4 NULL 30 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 1 PRIMARY uam eq_ref PRIMARY PRIMARY 4 elviso_joomla303.a.modified_by 1 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 1 PRIMARY v eq_ref PRIMARY PRIMARY 4 elviso_joomla303.a.id 1 2 DERIVED parent range cat_idx,idx_left_right cat_idx 203 NULL 2 Using where; Using temporary; Using filesort 2 DERIVED cat index idx_left_right idx_left_right 8 NULL 13 Using where; Using index; Using join buffer Status Duration starting 0.20 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.04 ms System lock 0.04 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms Creating tmp table 0.02 ms executing 0.00 ms Copying to tmp table 0.04 ms Sorting result 0.01 ms Sending data 0.01 ms removing tmp table 0.01 ms Sending data 0.01 ms init 0.09 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.03 ms Creating tmp table 0.40 ms executing 0.01 ms Copying to tmp table 0.73 ms Sorting result 0.08 ms Sending data 0.13 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.01 ms freeing items 0.05 ms logging slow query 0.00 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: 0.93 ms After last query: 2.42 ms Query memory: 0.021 MB Memory before query: 3.664 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 <= '2017-06-23 17:11:21')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-06-23 17:11:21')id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY <derived2> system NULL NO INDEX KEY COULD BE USED NULL NULL 0 const row not found 1 PRIMARY fp index PRIMARY PRIMARY 4 NULL 30 Using index 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 index 1 PRIMARY uam eq_ref PRIMARY PRIMARY 4 elviso_joomla303.a.modified_by 1 Using index 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 index 1 PRIMARY v eq_ref PRIMARY PRIMARY 4 elviso_joomla303.a.id 1 Using index 2 DERIVED parent range cat_idx,idx_left_right cat_idx 203 NULL 2 Using where; Using temporary; Using filesort 2 DERIVED cat index idx_left_right idx_left_right 8 NULL 13 Using where; Using index; Using join buffer Status Duration starting 0.11 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.03 ms System lock 0.04 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms Creating tmp table 0.02 ms executing 0.00 ms Copying to tmp table 0.03 ms Sorting result 0.01 ms Sending data 0.01 ms removing tmp table 0.01 ms Sending data 0.01 ms init 0.04 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms executing 0.01 ms Sending data 0.20 ms end 0.01 ms query end 0.01 ms closing tables 0.00 ms removing tmp table 0.01 ms closing tables 0.01 ms freeing items 0.04 ms logging slow query 0.00 ms cleaning up 0.01 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.16 ms After last query: 22.72 ms Query memory: 0.034 MB Memory before query: 4.043 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 <derived2> system NULL NO INDEX KEY COULD BE USED NULL NULL 0 const row not found 1 PRIMARY s const PRIMARY,idx_left_right PRIMARY 4 const 1 Using filesort 1 PRIMARY c ALL cat_idx,idx_access,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 13 Using where 2 DERIVED parent range cat_idx,idx_left_right cat_idx 203 NULL 2 Using where; Using temporary; Using filesort 2 DERIVED cat index idx_left_right idx_left_right 8 NULL 13 Using where; Using index; Using join buffer Status Duration starting 0.19 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.03 ms System lock 0.06 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.02 ms Creating tmp table 0.02 ms executing 0.00 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.01 ms init 0.08 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.03 ms executing 0.00 ms Sorting result 0.06 ms Sending data 0.08 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms removing tmp table 0.01 ms closing tables 0.01 ms freeing items 0.06 ms logging slow query 0.00 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: 0.39 ms After last query: 19.58 ms Query memory: 0.016 MB Memory before query: 4.186 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 where Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms System lock 0.01 ms init 0.02 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms logging slow query 0.00 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.90 ms After last query: 0.60 ms Query memory: 0.022 MB Memory before query: 4.217 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 <= '2017-06-23 17:11:21')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2017-06-23 17:11:21')
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 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 where Status Duration starting 0.07 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms System lock 0.01 ms init 0.04 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.03 ms executing 0.00 ms Sorting result 0.15 ms Sending data 0.28 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms logging slow query 0.00 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/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.37 ms After last query: 14.22 ms Query memory: 0.016 MB Memory before query: 4.286 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 where Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms System lock 0.01 ms init 0.02 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.00 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms logging slow query 0.00 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:24 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.93 ms After last query: 70.11 ms Query memory: 0.029 MB Memory before query: 4.817 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.08 ms checking permissions 0.01 ms Opening tables 0.02 ms System lock 0.01 ms init 0.03 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.00 ms Sorting result 0.07 ms Sending data 0.30 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms logging slow query 0.00 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: 0.46 ms After last query: 119.26 ms Query memory: 0.014 MB Memory before query: 5.044 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 System lock 0.02 ms init 0.02 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.00 ms executing 0.02 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.04 ms logging slow query 0.00 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 - Query Time: 0.32 ms After last query: 0.72 ms Query memory: 0.021 MB Memory before query: 5.061 MB Rows returned: 1
SELECT alias
FROM vagfk_content
WHERE id=127id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE vagfk_content const PRIMARY PRIMARY 4 const 1 Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms System lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.01 ms Sending data 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms logging slow query 0.00 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 15 JDatabaseDriver->loadResult() JROOT/components/com_content/router.php:118 14 ContentRouter->build() JROOT/libraries/cms/router/site.php:483 13 JRouterSite->buildSefRoute() JROOT/libraries/cms/router/site.php:452 12 JRouterSite->_buildSefRoute() JROOT/libraries/cms/router/router.php:280 11 JRouter->build() JROOT/libraries/cms/router/site.php:134 10 JRouterSite->build() JROOT/libraries/joomla/application/route.php:62 9 JRoute::_() JROOT/plugins/system/sef/sef.php:103 8 PlgSystemSef->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 - Query Time: 0.99 ms After last query: 0.29 ms Query memory: 0.029 MB Memory before query: 5.090 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=8
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 <derived2> system NULL NO INDEX KEY COULD BE USED NULL NULL 0 const row not found 1 PRIMARY s const PRIMARY,idx_left_right PRIMARY 4 const 1 Using filesort 1 PRIMARY c ALL cat_idx,idx_access,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 13 Using where 2 DERIVED parent range cat_idx,idx_left_right cat_idx 203 NULL 2 Using where; Using temporary; Using filesort 2 DERIVED cat index idx_left_right idx_left_right 8 NULL 13 Using where; Using index; Using join buffer Status Duration starting 0.17 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.02 ms System lock 0.06 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms Creating tmp table 0.02 ms executing 0.00 ms Copying to tmp table 0.04 ms Sorting result 0.01 ms Sending data 0.01 ms removing tmp table 0.01 ms Sending data 0.01 ms init 0.08 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.03 ms executing 0.00 ms Sorting result 0.05 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.00 ms removing tmp table 0.01 ms closing tables 0.01 ms freeing items 0.05 ms logging slow query 0.00 ms cleaning up 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 17 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:309 16 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:184 15 JCategories->get() JROOT/components/com_content/router.php:151 14 ContentRouter->build() JROOT/libraries/cms/router/site.php:483 13 JRouterSite->buildSefRoute() JROOT/libraries/cms/router/site.php:452 12 JRouterSite->_buildSefRoute() JROOT/libraries/cms/router/router.php:280 11 JRouter->build() JROOT/libraries/cms/router/site.php:134 10 JRouterSite->build() JROOT/libraries/joomla/application/route.php:62 9 JRoute::_() JROOT/plugins/system/sef/sef.php:103 8 PlgSystemSef->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
30 Tipos de consultas del registro, Ordenado por acontecimientos.
SELECCIONAR Tablas:
2 × SELECT extension_id AS id, element AS "option", params, enabled
FROM vagfk_extensions2 × 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.rgt1 × 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 manifest_cache
FROM vagfk_extensions1 × 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 alias
FROM vagfk_content1 × 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 *
FROM vagfk_languages1 × 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 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 `state`,`rule_type`
FROM `vagfk_jhackguard_ip_filters`1 × SELECT `source`,`keepurlparams`
FROM `vagfk_admintools_redirects`1 × SELECT `enabled`
FROM `vagfk_extensions`1 × SELECT `data`
FROM `vagfk_session`
OTRAS Tablas:
1 × UPDATE `vagfk_extensions`
SET `params` = '{\"mediaversion\":\"2127d15223d014a6853374533ee8dce3\"}'1 × DELETE
FROM `vagfk_jhackguard_ip_filters`1 × SHOW VARIABLES LIKE "collation_database
1 × INSERT INTO `vagfk_session` (`session_id`, `client_id`, `time`)
VALUES ('ufg495dbgeg97497ld5t9lef00', 0, '1498237881'1 × DELETE
FROM `vagfk_session`