Consola de depuración de Joomla!

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1529886414,
                "last": 1529886414,
                "now": 1529886414
            }
        },
        "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": {
                "936d4526badd866dd60f92786cbb6891114964a9": {
                    "link": "http:\/\/uniproyectos.com.co\/index.php",
                    "expiry": 1529886416
                }
            }
        }
    }
}

Fecha y hora

Memoria

22 consultas registradas 96.83 ms

1. Tiempo de la consulta: 3.87 ms Consulta a la memoria: 0.012 MB memoria antes de la consulta: 1.968 MB Filas devueltas: 0

   SELECT `data`
   
     FROM `jmla_session`
   
     WHERE `session_id` = 'lahb46r7m2mo5j7f8h1pqia134'

   Explicar

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

   Perfil

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

   Llamada de pila

   #	Comunicador	Archivo y número de línea
   14	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1731
   13	JDatabaseDriver->loadResult()	JROOT\libraries\joomla\session\storage\database.php:44
   12	JSessionStorageDatabase->read()	Lo mismo que llamada de la línea de abajo.
   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:56

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

   ---

2. Tiempo de la consulta: 1.39 ms Después de la última consulta: 25.75 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 2.122 MB Filas devueltas: 0

   SELECT `session_id`
   
     FROM `jmla_session`
   
     WHERE `session_id` = 'lahb46r7m2mo5j7f8h1pqia134' 
     LIMIT 0, 1

   Explicar

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

   Perfil

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

   Llamada de pila

   #	Comunicador	Archivo y número de línea
   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:56

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

   ---

3. Tiempo de la consulta: 3.17 ms Después de la última consulta: 0.36 ms Consulta a la memoria: 0.005 MB memoria antes de la consulta: 2.130 MB

   INSERT INTO `jmla_session`
   (`session_id`, `client_id`, `time`) 
     VALUES 
   ('lahb46r7m2mo5j7f8h1pqia134', 0, '1529886414')

   Explicar

   'Explicar' no es posible en la consulta: INSERT INTO `jmla_session` (`session_id`, `client_id`, `time`) VALUES ('lahb46r7m2mo5j7f8h1pqia134', 0, '1529886414')

   Perfil

   Status	Duration
   starting	0.06 ms
   checking permissions	0.02 ms
   Opening tables	0.03 ms
   init	0.02 ms
   System lock	0.02 ms
   update	0.34 ms
   Waiting for query cache lock	0.01 ms
   update	0.03 ms
   end	0.01 ms
   query end	1.62 ms
   closing tables	0.05 ms
   freeing items	0.05 ms
   cleaning up	0.02 ms

   Llamada de pila

   #	Comunicador	Archivo y número de línea
   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:56

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

   ---

4. Tiempo de la consulta: 4.03 ms Después de la última consulta: 27.42 ms Consulta a la memoria: 0.011 MB memoria antes de la consulta: 2.404 MB Filas devueltas: 31

   SELECT extension_id AS id, element AS "option", params, enabled
   
     FROM jmla_extensions
   
     WHERE `type` = 'component'

   Explicar

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	jmla_extensions	ref	extension	extension	82	const	31	100.00	Using index condition

   Perfil

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

   Llamada de pila

   #	Comunicador	Archivo y número de línea
   10	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1692
   9	JDatabaseDriver->loadObjectList()	Lo mismo que llamada de la línea de abajo.
   8	call_user_func_array()	JROOT\libraries\joomla\cache\controller\callback.php:157
   7	JCacheControllerCallback->get()	JROOT\libraries\cms\component\helper.php:448
   6	JComponentHelper::load()	JROOT\libraries\cms\component\helper.php:43
   5	JComponentHelper::getComponent()	JROOT\libraries\cms\component\helper.php:120
   4	JComponentHelper::getParams()	JROOT\libraries\cms\application\site.php:584
   3	JApplicationSite->initialiseApp()	JROOT\libraries\cms\application\site.php:209
   2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:257
   1	JApplicationCms->execute()	JROOT\index.php:59

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

   ---

5. Tiempo de la consulta: 3.73 ms Después de la última consulta: 9.17 ms Consulta a la memoria: 0.009 MB memoria antes de la consulta: 2.505 MB Filas devueltas: 2

   SELECT b.id
   
     FROM jmla_usergroups AS a
   
     LEFT JOIN jmla_usergroups AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt
   
     WHERE a.id = 9

   Explicar

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

   Perfil

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

   Llamada de pila

   #	Comunicador	Archivo y número de línea
   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:59

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

   ---

6. Tiempo de la consulta: 2.08 ms Después de la última consulta: 2.75 ms Consulta a la memoria: 0.008 MB memoria antes de la consulta: 2.546 MB Filas devueltas: 5

   SELECT id, rules
   
     FROM `jmla_viewlevels`

   Explicar

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

   Perfil

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

   Llamada de pila

   #	Comunicador	Archivo y número de línea
   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:59

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

   ---

7. Tiempo de la consulta: 3.02 ms Después de la última consulta: 0.54 ms Consulta a la memoria: 0.008 MB memoria antes de la consulta: 2.558 MB Filas devueltas: 43

   SELECT folder AS type, element AS name, params
   
     FROM jmla_extensions
   
     WHERE enabled = 1 
     AND type ='plugin' 
     AND state IN (0,1) 
     AND access IN (1,1,5)
   
     ORDER BY ordering

   Explicar

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	jmla_extensions	ref	extension	extension	82	const	56	100.00	Using index condition; Using where; Usando 'filesort'

   Perfil

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

   Llamada de pila

   #	Comunicador	Archivo y número de línea
   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:59

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

   ---

8. Tiempo de la consulta: 4.98 ms Después de la última consulta: 132.16 ms Consulta a la memoria: 0.016 MB memoria antes de la consulta: 3.506 MB Filas devueltas: 7

   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 jmla_menu AS m
   
     LEFT JOIN jmla_extensions AS e 
     ON m.component_id = e.extension_id
   
     WHERE m.published = 1 
     AND m.parent_id > 0 
     AND m.client_id = 0
   
     ORDER BY m.lft

   Explicar

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	10	100.00	Using index condition; Using where; Usando 'filesort'
   1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	web_uniproyectos.m.component_id	1	100.00	Using where

   Perfil

   Status	Duration
   starting	0.02 ms
   Waiting for query cache lock	0.01 ms
   init	0.01 ms
   checking query cache for query	0.13 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   Opening tables	2.26 ms
   init	0.05 ms
   System lock	0.02 ms
   Waiting for query cache lock	0.01 ms
   System lock	0.04 ms
   optimizing	0.03 ms
   statistics	0.27 ms
   preparing	0.05 ms
   Sorting result	0.01 ms
   executing	0.01 ms
   Sending data	0.03 ms
   Creating sort index	0.54 ms
   end	0.02 ms
   query end	0.01 ms
   closing tables	0.02 ms
   freeing items	0.02 ms
   Waiting for query cache lock	0.01 ms
   freeing items	0.05 ms
   Waiting for query cache lock	0.01 ms
   freeing items	0.01 ms
   storing result in query cache	0.02 ms
   cleaning up	0.04 ms

   Llamada de pila

   #	Comunicador	Archivo y número de línea
   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:59

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

   ---

9. Tiempo de la consulta: 1.63 ms Después de la última consulta: 7.47 ms Consulta a la memoria: 0.012 MB memoria antes de la consulta: 3.605 MB Filas devueltas: 1

   SELECT extension_id AS id, element AS "option", params, enabled
   
     FROM jmla_extensions
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explicar

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	jmla_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using index condition

   Perfil

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

   Llamada de pila

   #	Comunicador	Archivo y número de línea
   14	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1653
   13	JDatabaseDriver->loadObject()	Lo mismo que llamada de la línea de abajo.
   12	call_user_func_array()	JROOT\libraries\joomla\cache\controller\callback.php:157
   11	JCacheControllerCallback->get()	JROOT\libraries\cms\library\helper.php:156
   10	JLibraryHelper::_load()	JROOT\libraries\cms\library\helper.php:47
   9	JLibraryHelper::getLibrary()	JROOT\libraries\cms\library\helper.php:90
   8	JLibraryHelper::getParams()	JROOT\libraries\cms\version\version.php:274
   7	JVersion->getMediaVersion()	JROOT\libraries\joomla\factory.php:737
   6	JFactory::createDocument()	JROOT\libraries\joomla\factory.php:216
   5	JFactory::getDocument()	JROOT\libraries\joomla\application\web.php:991
   4	JApplicationWeb->loadDocument()	JROOT\libraries\cms\application\site.php:130
   3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
   2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:257
   1	JApplicationCms->execute()	JROOT\index.php:59

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

   ---

10. Tiempo de la consulta: 3.12 ms Después de la última consulta: 18.20 ms Consulta a la memoria: 0.008 MB memoria antes de la consulta: 3.689 MB

    UPDATE `jmla_extensions`
    
      SET `params` = '{\"mediaversion\":\"4de1f3158fa2302029a3182b97f0edb4\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explicar

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

    Perfil

    Status	Duration
    starting	0.06 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    init	0.03 ms
    System lock	0.14 ms
    updating	0.15 ms
    end	0.02 ms
    Waiting for query cache lock	0.01 ms
    end	0.07 ms
    query end	1.57 ms
    closing tables	0.03 ms
    freeing items	0.05 ms
    cleaning up	0.04 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    10	JDatabaseDriverMysqli->execute()	JROOT\libraries\cms\library\helper.php:119
    9	JLibraryHelper::saveParams()	JROOT\libraries\cms\version\version.php:325
    8	JVersion->setMediaVersion()	JROOT\libraries\cms\version\version.php:284
    7	JVersion->getMediaVersion()	JROOT\libraries\joomla\factory.php:737
    6	JFactory::createDocument()	JROOT\libraries\joomla\factory.php:216
    5	JFactory::getDocument()	JROOT\libraries\joomla\application\web.php:991
    4	JApplicationWeb->loadDocument()	JROOT\libraries\cms\application\site.php:130
    3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:257
    1	JApplicationCms->execute()	JROOT\index.php:59

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

    ---

11. Tiempo de la consulta: 3.69 ms Después de la última consulta: 23.79 ms Consulta a la memoria: 0.009 MB memoria antes de la consulta: 3.877 MB Filas devueltas: 2

    SELECT *
    
      FROM jmla_languages
    
      WHERE published=1
    
      ORDER BY ordering ASC

    Explicar

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

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    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:59

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

    ---

12. Tiempo de la consulta: 3.88 ms Después de la última consulta: 1.10 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 3.892 MB Filas devueltas: 3

    SELECT id, home, template, s.params
    
      FROM jmla_template_styles as s
    
      LEFT JOIN jmla_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id
    
      WHERE s.client_id = 0 
      AND e.enabled = 1

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	ALL	idx_template	No pudo usarse una clave de índice	NULL	NULL	5	100.00	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	web_uniproyectos.s.template,const	1	100.00	Using index condition; Using where

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    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:59

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

    ---

13. Tiempo de la consulta: 4.64 ms Después de la última consulta: 221.28 ms Consulta a la memoria: 0.013 MB memoria antes de la consulta: 4.361 MB Filas devueltas: 1

    SELECT a.rules
    
      FROM jmla_assets AS a
    
      WHERE (a.id = 1)
    
      GROUP BY a.id, a.rules, a.lft

    Explicar

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

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    15	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1541
    14	JDatabaseDriver->loadColumn()	JROOT\libraries\joomla\access\access.php:246
    13	JAccess::getAssetRules()	JROOT\libraries\joomla\user\user.php:384
    12	JUser->authorise()	JROOT\components\com_content\models\article.php:55
    11	ContentModelArticle->populateState()	JROOT\libraries\legacy\model\legacy.php:439
    10	JModelLegacy->getState()	JROOT\components\com_content\models\article.php:262
    9	ContentModelArticle->hit()	JROOT\components\com_content\controller.php:109
    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:59

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

    ---

14. Tiempo de la consulta: 6.41 ms Después de la última consulta: 10.93 ms Consulta a la memoria: 0.013 MB memoria antes de la consulta: 4.397 MB Filas devueltas: 2

    SELECT b.rules
    
      FROM jmla_assets AS a
    
      LEFT JOIN jmla_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.lft

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	const	idx_asset_name	idx_asset_name	202	const	1	100.00	Using temporary; Usando 'filesort'
    1	SIMPLE	b	range	idx_lft_rgt	idx_lft_rgt	4	NULL	11	100.00	Using where

    Perfil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    checking query cache for query	0.08 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.11 ms
    init	0.04 ms
    System lock	0.02 ms
    Waiting for query cache lock	0.01 ms
    System lock	0.03 ms
    optimizing	0.02 ms
    statistics	0.41 ms
    preparing	0.04 ms
    Creating tmp table	0.06 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	2.88 ms
    Creating sort index	0.09 ms
    end	0.01 ms
    removing tmp table	1.30 ms
    end	0.02 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.04 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.01 ms
    storing result in query cache	0.02 ms
    cleaning up	0.03 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    16	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1541
    15	JDatabaseDriver->loadColumn()	JROOT\libraries\joomla\access\access.php:246
    14	JAccess::getAssetRules()	JROOT\libraries\joomla\access\access.php:107
    13	JAccess::check()	JROOT\libraries\joomla\user\user.php:393
    12	JUser->authorise()	JROOT\components\com_content\models\article.php:55
    11	ContentModelArticle->populateState()	JROOT\libraries\legacy\model\legacy.php:439
    10	JModelLegacy->getState()	JROOT\components\com_content\models\article.php:262
    9	ContentModelArticle->hit()	JROOT\components\com_content\controller.php:109
    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:59

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

    ---

15. Tiempo de la consulta: 9.93 ms Después de la última consulta: 13.38 ms Consulta a la memoria: 0.016 MB memoria antes de la consulta: 4.469 MB Filas devueltas: 30

    SHOW FULL COLUMNS 
      FROM `jmla_content`

    Explicar

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

    Perfil

    Status	Duration
    starting	0.05 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    Opening tables	2.67 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.02 ms
    executing	0.02 ms
    Opening tables	3.66 ms
    checking permissions	0.06 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.04 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    Sending data	0.13 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    removing tmp table	1.30 ms
    closing tables	0.02 ms
    freeing items	0.05 ms
    cleaning up	0.02 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    16	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1692
    15	JDatabaseDriver->loadObjectList()	JROOT\libraries\joomla\database\driver\mysqli.php:440
    14	JDatabaseDriverMysqli->getTableColumns()	JROOT\libraries\joomla\table\table.php:241
    13	JTable->getFields()	JROOT\libraries\joomla\table\table.php:162
    12	JTable->__construct()	JROOT\libraries\legacy\table\content.php:31
    11	JTableContent->__construct()	JROOT\libraries\joomla\table\table.php:305
    10	JTable::getInstance()	JROOT\components\com_content\models\article.php:264
    9	ContentModelArticle->hit()	JROOT\components\com_content\controller.php:109
    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:59

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

    ---

16. Tiempo de la consulta: 1.97 ms Después de la última consulta: 59.69 ms Consulta a la memoria: 0.016 MB memoria antes de la consulta: 4.727 MB Filas devueltas: 1

    SELECT *
    
      FROM jmla_content
    
      WHERE `id` = '2'

    Explicar

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

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    12	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1456
    11	JDatabaseDriver->loadAssoc()	JROOT\libraries\joomla\table\table.php:728
    10	JTable->load()	JROOT\components\com_content\models\article.php:265
    9	ContentModelArticle->hit()	JROOT\components\com_content\controller.php:109
    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:59

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

    ---

17. Tiempo de la consulta: 2.73 ms Después de la última consulta: 0.46 ms Consulta a la memoria: 0.009 MB memoria antes de la consulta: 4.737 MB

    UPDATE jmla_content
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '2'

    Explicar

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

    Perfil

    Status	Duration
    starting	0.08 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    init	0.03 ms
    System lock	0.06 ms
    updating	0.10 ms
    end	0.01 ms
    Waiting for query cache lock	0.01 ms
    end	0.03 ms
    query end	1.61 ms
    closing tables	0.03 ms
    freeing items	0.05 ms
    cleaning up	0.05 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    11	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\table\table.php:1249
    10	JTable->hit()	JROOT\components\com_content\models\article.php:266
    9	ContentModelArticle->hit()	JROOT\components\com_content\controller.php:109
    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:59

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

    ---

18. Tiempo de la consulta: 9.39 ms Después de la última consulta: 19.54 ms Consulta a la memoria: 0.018 MB memoria antes de la consulta: 4.871 MB Filas devueltas: 1

    SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
    
      FROM jmla_content AS a
    
      LEFT JOIN jmla_categories AS c 
      on c.id = a.catid
    
      LEFT JOIN jmla_users AS u 
      on u.id = a.created_by
    
      LEFT JOIN jmla_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN jmla_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER JOIN  (SELECT cat.id as id 
      FROM jmla_categories AS cat JOIN jmla_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published <= 0 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      WHERE a.id = 2 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-06-25 00:26:55') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-06-25 00:26:55') 
      AND (a.state = 1 OR a.state =2)

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	const	PRIMARY,idx_state	PRIMARY	4	const	1	100.00	NULL
    1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	PRIMARY	u	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	PRIMARY	parent	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	PRIMARY	v	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found
    1	PRIMARY	<derived2>	ref	<auto_key0>	<auto_key0>	4	const	0	100.00	Using index
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	1	100.00	Using index condition; Using temporary; Usando 'filesort'
    2	DERIVED	cat	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	6	100.00	Using where; Using index; Using join buffer (Block Nested Loop)

    Perfil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    checking query cache for query	0.27 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	6.00 ms
    init	0.11 ms
    System lock	0.02 ms
    Waiting for query cache lock	0.01 ms
    System lock	0.11 ms
    optimizing	0.02 ms
    optimizing	0.03 ms
    statistics	0.29 ms
    preparing	0.04 ms
    Creating tmp table	0.03 ms
    Sorting result	0.04 ms
    statistics	0.72 ms
    preparing	0.03 ms
    executing	0.02 ms
    Sending data	0.06 ms
    executing	0.01 ms
    Sending data	0.06 ms
    Creating sort index	0.03 ms
    removing tmp table	0.02 ms
    Creating sort index	0.04 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    removing tmp table	0.01 ms
    closing tables	0.03 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.05 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.01 ms
    storing result in query cache	0.01 ms
    cleaning up	0.04 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    14	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1653
    13	JDatabaseDriver->loadObject()	JROOT\components\com_content\models\article.php:159
    12	ContentModelArticle->getItem()	JROOT\libraries\legacy\view\legacy.php:401
    11	JViewLegacy->get()	JROOT\components\com_content\views\article\view.html.php:42
    10	ContentViewArticle->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:59

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

    ---

19. Tiempo de la consulta: 7.73 ms Después de la última consulta: 29.86 ms Consulta a la memoria: 0.017 MB memoria antes de la consulta: 5.060 MB Filas devueltas: 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 jmla_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM jmla_categories AS cat JOIN jmla_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 jmla_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.lft

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Usando 'filesort'
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	No pudo usarse una clave de índice	NULL	NULL	6	66.67	Using where
    1	PRIMARY	<derived2>	ref	<auto_key0>	<auto_key0>	4	web_uniproyectos.c.id	2	100.00	Using where; Not exists; Using index
    2	DERIVED	parent	ALL	cat_idx,idx_left_right	No pudo usarse una clave de índice	NULL	NULL	6	33.33	Using where; Using temporary; Usando 'filesort'
    2	DERIVED	cat	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	6	100.00	Using where; Using index; Using join buffer (Block Nested Loop)

    Perfil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    checking query cache for query	0.24 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.11 ms
    init	0.12 ms
    System lock	0.02 ms
    Waiting for query cache lock	0.01 ms
    System lock	0.07 ms
    optimizing	0.01 ms
    optimizing	0.03 ms
    statistics	0.11 ms
    preparing	0.04 ms
    Creating tmp table	0.03 ms
    Sorting result	0.04 ms
    statistics	0.53 ms
    preparing	0.07 ms
    Creating tmp table	0.09 ms
    Sorting result	0.01 ms
    executing	0.02 ms
    Sending data	0.08 ms
    executing	0.01 ms
    Sending data	0.07 ms
    Creating sort index	0.03 ms
    removing tmp table	0.02 ms
    Creating sort index	2.84 ms
    Creating sort index	0.10 ms
    end	0.01 ms
    removing tmp table	1.56 ms
    end	0.02 ms
    query end	0.01 ms
    closing tables	0.01 ms
    removing tmp table	0.02 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.04 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.01 ms
    storing result in query cache	0.01 ms
    cleaning up	0.03 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    15	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1692
    14	JDatabaseDriver->loadObjectList()	JROOT\libraries\legacy\categories\categories.php:309
    13	JCategories->_load()	JROOT\libraries\legacy\categories\categories.php:184
    12	JCategories->get()	JROOT\components\com_content\helpers\route.php:44
    11	ContentHelperRoute::getArticleRoute()	JROOT\components\com_content\views\article\view.html.php:71
    10	ContentViewArticle->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:59

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

    ---

20. Tiempo de la consulta: 6.82 ms Después de la última consulta: 13.72 ms Consulta a la memoria: 0.016 MB memoria antes de la consulta: 5.137 MB Filas devueltas: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `jmla_contentitem_tag_map` AS m 
    
      INNER JOIN `jmla_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 2 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explicar

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

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    13	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1692
    12	JDatabaseDriver->loadObjectList()	JROOT\libraries\cms\helper\tags.php:426
    11	JHelperTags->getItemTags()	JROOT\components\com_content\views\article\view.html.php:156
    10	ContentViewArticle->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:59

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

    ---

21. Tiempo de la consulta: 5.88 ms Después de la última consulta: 48.11 ms Consulta a la memoria: 0.015 MB memoria antes de la consulta: 5.404 MB Filas devueltas: 4

    SELECT b.rules
    
      FROM jmla_assets AS a
    
      LEFT JOIN jmla_assets AS b 
      ON b.lft <= a.lft 
      AND b.rgt >= a.rgt
    
      WHERE (a.name = 'com_content.article.2')
    
      GROUP BY b.id, b.rules, b.lft
    
      ORDER BY b.lft

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	const	idx_asset_name	idx_asset_name	202	const	1	100.00	Using temporary; Usando 'filesort'
    1	SIMPLE	b	ALL	idx_lft_rgt	No pudo usarse una clave de índice	NULL	NULL	62	22.58	Using where

    Perfil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    checking query cache for query	0.08 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.04 ms
    System lock	0.02 ms
    Waiting for query cache lock	0.01 ms
    System lock	0.04 ms
    optimizing	0.02 ms
    statistics	0.12 ms
    preparing	0.03 ms
    Creating tmp table	0.05 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	2.86 ms
    Creating sort index	0.10 ms
    end	0.01 ms
    removing tmp table	1.30 ms
    end	0.02 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.04 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.01 ms
    storing result in query cache	0.03 ms
    cleaning up	0.03 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    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\plugins\content\pagenavigation\pagenavigation.php:54
    14	PlgContentPagenavigation->onContentBeforeDisplay()	Lo mismo que llamada de la línea de abajo.
    13	call_user_func_array()	JROOT\libraries\joomla\event\event.php:69
    12	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT\components\com_content\views\article\view.html.php:167
    10	ContentViewArticle->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:59

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

    ---

22. Tiempo de la consulta: 2.75 ms Después de la última consulta: 0.75 ms Consulta a la memoria: 0.014 MB memoria antes de la consulta: 5.429 MB Filas devueltas: 8

    SELECT a.id, a.title, a.catid, a.language, 
      CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
      CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
    
      FROM jmla_content AS a
    
      LEFT JOIN jmla_categories AS cc 
      ON cc.id = a.catid
    
      WHERE a.catid = 2 
      AND a.state = 1 
      AND a.access IN (1,1,5)  
      AND (a.state = 1 OR a.state = -1) 
      AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2018-06-25 00:26:55') 
      AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2018-06-25 00:26:55')
    
      ORDER BY  
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_state	1	const	8	100.00	Using where; Usando 'filesort'
    1	SIMPLE	cc	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    16	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1692
    15	JDatabaseDriver->loadObjectList()	JROOT\plugins\content\pagenavigation\pagenavigation.php:152
    14	PlgContentPagenavigation->onContentBeforeDisplay()	Lo mismo que llamada de la línea de abajo.
    13	call_user_func_array()	JROOT\libraries\joomla\event\event.php:69
    12	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT\components\com_content\views\article\view.html.php:167
    10	ContentViewArticle->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:59

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

    ---

20 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

1. 2 × SELECT extension_id AS id, element AS "option", params, enabled
    
     FROM jmla_extensions

2. 2 × SELECT b.rules
    
     FROM jmla_assets AS a
    
     LEFT JOIN jmla_assets AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt

3. 1 × SELECT *
    
     FROM jmla_content

4. 1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
     CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
     CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
    
     FROM jmla_content AS a
    
     LEFT JOIN jmla_categories AS c 
     on c.id = a.catid
    
     LEFT JOIN jmla_users AS u 
     on u.id = a.created_by
    
     LEFT JOIN jmla_categories as parent 
     ON parent.id = c.parent_id
    
     LEFT JOIN jmla_content_rating AS v 
     ON a.id = v.content_id
    
     LEFT 
     OUTER JOIN  (SELECT cat.id as id 
     FROM jmla_categories AS cat JOIN jmla_categories AS parent 
     ON cat.lft BETWEEN parent.lft 
     AND parent.rgt

5. 1 × SELECT `m`.`tag_id`,`t`.*
    
     FROM `jmla_contentitem_tag_map` AS m 
    
     INNER JOIN `jmla_tags` AS t  
     ON `m`.`tag_id` = `t`.`id`

6. 1 × SELECT a.id, a.title, a.catid, a.language, 
     CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
     CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
    
     FROM jmla_content AS a
    
     LEFT JOIN jmla_categories AS cc 
     ON cc.id = a.catid

7. 1 × SELECT a.rules
    
     FROM jmla_assets AS a

8. 1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
     CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
     FROM jmla_categories as c
    
     LEFT JOIN  (SELECT cat.id as id 
     FROM jmla_categories AS cat JOIN jmla_categories AS parent 
     ON cat.lft BETWEEN parent.lft 
     AND parent.rgt

9. 1 × SELECT *
    
     FROM jmla_languages

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

11. 1 × SELECT `session_id`
     
      FROM `jmla_session`

12. 1 × SELECT id, rules
     
      FROM `jmla_viewlevels

13. 1 × SELECT folder AS type, element AS name, params
     
      FROM jmla_extensions

14. 1 × SELECT `data`
     
      FROM `jmla_session`

15. 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 jmla_menu AS m
     
      LEFT JOIN jmla_extensions AS e 
      ON m.component_id = e.extension_id

16. 1 × SELECT id, home, template, s.params
     
      FROM jmla_template_styles as s
     
      LEFT JOIN jmla_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id

OTRAS tablas:

1. 1 × UPDATE jmla_content
    
     SET `hits` = (`hits` + 1)

2. 1 × SHOW FULL COLUMNS 
     FROM `jmla_content

3. 1 × UPDATE `jmla_extensions`
    
     SET `params` = '{\"mediaversion\":\"4de1f3158fa2302029a3182b97f0edb4\"}'

4. 1 × INSERT INTO `jmla_session`
    (`session_id`, `client_id`, `time`) 
     VALUES 
    ('lahb46r7m2mo5j7f8h1pqia134', 0, '1529886414'