Consola de depuración de Joomla!

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1575684581,
                "last": 1575684581,
                "now": 1575684581
            },
            "client": {
                "forwarded": "3.215.182.36"
            }
        },
        "registry": {
            "com_content": {
                "category": {
                    "filter": {
                        "tag": 10
                    }
                }
            }
        },
        "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": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "plg_system_languagefilter": {
            "language": "es-CO"
        }
    }
}

Hora

Memoria

52 consultas registradas 72.03 ms

1. Tiempo de consulta: 2.10 ms

   DELETE 
   
     FROM `sm_session`
   
     WHERE `time` < '1575683681'

   Explicar

   No es posible hacer EXPLAIN en la consulta: DELETE FROM `sm_session` WHERE `time` < '1575683681'

   Perfil

   Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

   Call Stack

   #	Caller	Número de archivo y de línea
   6	JDatabaseDriverMysql->execute()	JROOT/libraries/src/Application/CMSApplication.php:824
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:133
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:415
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

   ---

2. Tiempo de consulta: 0.55 ms Después de la última consulta: 0.27 ms

   SELECT `data`
   
     FROM `sm_session`
   
     WHERE `session_id` = '4pcjvvb45kd1qvek7al78nu653'

   Explicar

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	sm_session	const	PRIMARY	PRIMARY	766	const	1

   Perfil

   Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

   Call Stack

   #	Caller	Número de archivo y de línea
   16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Igual que la llamada en la línea de abajo.
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
   10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:831
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:133
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:415
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

   ---

3. Tiempo de consulta: 0.44 ms Después de la última consulta: 0.63 ms

   SELECT `session_id`
   
     FROM `sm_session`
   
     WHERE `session_id` = '4pcjvvb45kd1qvek7al78nu653' 
     LIMIT 1

   Explicar

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

   Perfil

   Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

   Call Stack

   #	Caller	Número de archivo y de línea
   8	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
   7	JDatabaseDriver->loadResult()	JROOT/libraries/src/Application/CMSApplication.php:178
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:833
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:133
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:415
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

   ---

4. Tiempo de consulta: 1.56 ms Después de la última consulta: 0.19 ms

   INSERT INTO `sm_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('4pcjvvb45kd1qvek7al78nu653', 1, '1575684581', 0, '', 0)

   Explicar

   No es posible hacer EXPLAIN en la consulta: INSERT INTO `sm_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('4pcjvvb45kd1qvek7al78nu653', 1, '1575684581', 0, '', 0)

   Perfil

   Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

   Call Stack

   #	Caller	Número de archivo y de línea
   7	JDatabaseDriverMysql->execute()	JROOT/libraries/src/Application/CMSApplication.php:218
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:833
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:133
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:415
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

   ---

5. Tiempo de consulta: 0.71 ms Después de la última consulta: 0.76 ms

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

   Explicar

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	sm_extensions	ref	extension	extension	82	const	38	Using where

   Perfil

   Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

   Call Stack

   #	Caller	Número de archivo y de línea
   11	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:450
   9	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Igual que la llamada en la línea de abajo.
   8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:458
   6	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:46
   5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:114
   4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:596
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

   ---

6. Tiempo de consulta: 0.22 ms Después de la última consulta: 0.93 ms

   SELECT id, rules
   
     FROM `sm_viewlevels`

   Explicar

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	sm_viewlevels	ALL	NULL	Ninguna llave índice (INDEX KEY) pudo ser utilizada	NULL	NULL	6

   Perfil

   Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

   Call Stack

   #	Caller	Número de archivo y de línea
   10	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1496
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:310
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:606
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

   ---

7. Tiempo de consulta: 0.21 ms Después de la última consulta: 0.19 ms

   SELECT b.id
   
     FROM sm_usergroups AS a
   
     LEFT JOIN sm_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	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

   Perfil

   Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

   Call Stack

   #	Caller	Número de archivo y de línea
   11	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1540
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
   9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:310
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:606
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

   ---

8. Tiempo de consulta: 1.10 ms Después de la última consulta: 0.29 ms

   SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   
     FROM sm_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	Extra
   1	SIMPLE	sm_extensions	ref	extension	extension	82	const	89	Using where; Utilizando filesort

   Perfil

   Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

   Call Stack

   #	Caller	Número de archivo y de línea
   11	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:343
   9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Igual que la llamada en la línea de abajo.
   8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:348
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:606
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

   ---

9. Tiempo de consulta: 0.46 ms Después de la última consulta: 6.16 ms

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

   Explicar

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	sm_languages	ALL	NULL	Ninguna llave índice (INDEX KEY) pudo ser utilizada	NULL	NULL	2	Using where; Utilizando filesort

   Perfil

   Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

   Call Stack

   #	Caller	Número de archivo y de línea
   10	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
   9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
   8	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:98
   7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:272
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:685
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

   ---

10. Tiempo de consulta: 0.66 ms Después de la última consulta: 0.21 ms

    SELECT `element`,`name`,`client_id`,`extension_id`
    
      FROM `sm_extensions`
    
      WHERE `type` = 'language' 
      AND `state` = 0 
      AND `enabled` = 1

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	sm_extensions	ref	extension	extension	82	const	4	Using where

    Perfil

    Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

    Call Stack

    #	Caller	Número de archivo y de línea
    10	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
    9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:209
    8	Joomla\CMS\Language\LanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:109
    7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:272
    6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
    5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:685
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

11. Tiempo de consulta: 2.48 ms Después de la última consulta: 8.36 ms

    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 sm_menu AS m
    
      LEFT JOIN sm_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	Extra
    1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	92	Using where; Utilizando filesort
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	portalsaludmia.m.component_id	1

    Perfil

    Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

    Call Stack

    #	Caller	Número de archivo y de línea
    24	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
    22	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Igual que la llamada en la línea de abajo.
    21	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    20	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
    19	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
    18	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
    17	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
    16	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:446
    15	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
    14	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
    13	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
    12	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:551
    11	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:405
    10	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:130
    9	PlgSystemLanguageFilter->onAfterInitialise()	Igual que la llamada en la línea de abajo.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:686
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

12. Tiempo de consulta: 0.49 ms Después de la última consulta: 6.21 ms

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

    Explicar

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

    Perfil

    Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

    Call Stack

    #	Caller	Número de archivo y de línea
    15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1652
    14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
    13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Igual que la llamada en la línea de abajo.
    12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
    10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
    9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
    8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
    7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1116
    4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

13. Tiempo de consulta: 2.42 ms Después de la última consulta: 0.25 ms

    UPDATE `sm_extensions`
    
      SET `params` = '{\"mediaversion\":\"d0fffce2538fd4f2f116fe798abcb156\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explicar

    No es posible hacer EXPLAIN en la consulta: UPDATE `sm_extensions` SET `params` = '{\"mediaversion\":\"d0fffce2538fd4f2f116fe798abcb156\"}' WHERE `type` = 'library' AND `element` = 'joomla'

    Perfil

    Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

    Call Stack

    #	Caller	Número de archivo y de línea
    10	JDatabaseDriverMysql->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1116
    4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

14. Tiempo de consulta: 0.84 ms Después de la última consulta: 0.92 ms

    SELECT id, home, template, s.params
    
      FROM sm_template_styles as s
    
      LEFT JOIN sm_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	Extra
    1	SIMPLE	s	ALL	idx_template	Ninguna llave índice (INDEX KEY) pudo ser utilizada	NULL	NULL	3	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	portalsaludmia.s.template,const	1	Using where

    Perfil

    Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

    Call Stack

    #	Caller	Número de archivo y de línea
    6	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
    5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:488
    4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

15. Tiempo de consulta: 0.48 ms Después de la última consulta: 5.10 ms

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `sm_assets`
    
      WHERE `name` IN ('root.1','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_chronoforms5','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_extplorer','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocadownload','com_plugins','com_postinstall','com_redirect','com_search','com_speasyimagegallery','com_spsimpleportfolio','com_tags','com_templates','com_users','com_wrapper')

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	sm_assets	ALL	idx_asset_name	Ninguna llave índice (INDEX KEY) pudo ser utilizada	NULL	NULL	395	Using where

    Perfil

    Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

    Call Stack

    #	Caller	Número de archivo y de línea
    20	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    18	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    14	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:142
    13	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435
    12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:392
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

16. Tiempo de consulta: 0.43 ms Después de la última consulta: 0.50 ms

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `sm_assets`
    
      WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	sm_assets	ALL	idx_asset_name,idx_parent_id	Ninguna llave índice (INDEX KEY) pudo ser utilizada	NULL	NULL	395	Using where

    Perfil

    Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

    Call Stack

    #	Caller	Número de archivo y de línea
    20	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
    18	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
    17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
    16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    14	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:142
    13	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435
    12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:392
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

17. Tiempo de consulta: 4.63 ms Después de la última consulta: 1.79 ms

    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,COUNT(i.`id`) AS numitems
    
      FROM sm_categories as c
    
      LEFT JOIN sm_categories AS s 
      ON (s.lft < c.lft 
      AND s.rgt > c.rgt 
      AND c.language in ('es-CO','*')) OR (s.lft >= c.lft 
      AND s.rgt <= c.rgt)
    
      LEFT JOIN `sm_content` AS i 
      ON i.`catid` = c.id 
      AND i.state = 1 
      AND (i.language = '*' OR i.language = 'es-CO')
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.published = 1 
      AND s.id=21
    
      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	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Utilizando filesort
    1	SIMPLE	c	ALL	cat_idx,idx_left_right,idx_language	Ninguna llave índice (INDEX KEY) pudo ser utilizada	NULL	NULL	46	Using where
    1	SIMPLE	i	ref	idx_state,idx_catid,idx_language	idx_catid	4	portalsaludmia.c.id	2

    Perfil

    Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

    Call Stack

    #	Caller	Número de archivo y de línea
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:305
    15	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
    14	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/models/category.php:355
    13	ContentModelCategory->getCategory()	JROOT/libraries/src/MVC/View/HtmlView.php:423
    12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:122
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:392
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

18. Tiempo de consulta: 3.27 ms Después de la última consulta: 1.36 ms

    SELECT DISTINCT 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 c.published = 2 
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      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, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      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,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating, 
    							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
    
      FROM sm_content AS a
    
      LEFT JOIN sm_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN sm_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN sm_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN sm_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN sm_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT JOIN `sm_contentitem_tag_map` AS `tagmap` 
      ON `tagmap`.`content_item_id` = `a`.`id` 
      AND `tagmap`.`type_alias` = 'com_content.article'
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.featured = 0 
      AND a.catid = 21 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-12-07 02:09:41') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-12-07 02:09:41') 
      AND a.language in ('es-CO','*') 
      AND `tagmap`.`tag_id` = 10
    
      ORDER BY  c.lft,  rating DESC ,  a.created   
      LIMIT 9

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	Using temporary; Utilizando filesort
    1	SIMPLE	a	index_merge	PRIMARY,idx_access,idx_state,idx_catid,idx_featured_catid,idx_language	idx_catid,idx_featured_catid,idx_state	4,5,1	NULL	3	Using intersect(idx_catid,idx_featured_catid,idx_state); Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	portalsaludmia.a.created_by	1
    1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	portalsaludmia.a.modified_by	1
    1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	portalsaludmia.a.id	1
    1	SIMPLE	tagmap	ref	idx_tag_type	idx_tag_type	4	const	18	Using where; Distinct

    Perfil

    Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

    Call Stack

    #	Caller	Número de archivo y de línea
    18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:556
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:423
    12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:392
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

19. Tiempo de consulta: 1.45 ms Después de la última consulta: 1.85 ms

    SELECT COUNT(*)
    
      FROM sm_content AS a
    
      LEFT JOIN sm_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN sm_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN sm_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN sm_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN sm_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT JOIN `sm_contentitem_tag_map` AS `tagmap` 
      ON `tagmap`.`content_item_id` = `a`.`id` 
      AND `tagmap`.`type_alias` = 'com_content.article'
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.featured = 0 
      AND a.catid = 21 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-12-07 02:09:41') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-12-07 02:09:41') 
      AND a.language in ('es-CO','*') 
      AND `tagmap`.`tag_id` = 10

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
    1	SIMPLE	a	index_merge	PRIMARY,idx_access,idx_state,idx_catid,idx_featured_catid,idx_language	idx_catid,idx_featured_catid,idx_state	4,5,1	NULL	3	Using intersect(idx_catid,idx_featured_catid,idx_state); Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	portalsaludmia.a.created_by	1	Using index
    1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	portalsaludmia.a.modified_by	1	Using index
    1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using index
    1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	portalsaludmia.a.id	1	Using index
    1	SIMPLE	tagmap	ref	idx_tag_type	idx_tag_type	4	const	18	Using where

    Perfil

    Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

    Call Stack

    #	Caller	Número de archivo y de línea
    18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
    17	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:335
    16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
    15	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
    14	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/components/com_content/models/category.php:265
    13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:423
    12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:392
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

20. Tiempo de consulta: 0.42 ms Después de la última consulta: 0.86 ms

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sm_contentitem_tag_map` AS m 
    
      INNER JOIN `sm_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.category' 
      AND `m`.`content_item_id` = 21 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	Ninguna llave índice (INDEX KEY) pudo ser utilizada	NULL	NULL	19	Using where
    1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	portalsaludmia.t.id	2	Using where

    Perfil

    Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

    Call Stack

    #	Caller	Número de archivo y de línea
    14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    12	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/libraries/src/MVC/View/CategoryView.php:226
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:392
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

21. Tiempo de consulta: 0.42 ms Después de la última consulta: 4.29 ms

    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 sm_categories as c
    
      LEFT JOIN sm_categories AS s 
      ON (s.lft < c.lft 
      AND s.rgt > c.rgt 
      AND c.language in ('es-CO','*')) 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 s.id=21
    
      ORDER BY c.lft

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Utilizando filesort
    1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	Ninguna llave índice (INDEX KEY) pudo ser utilizada	NULL	NULL	46	Using where

    Perfil

    Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

    Call Stack

    #	Caller	Número de archivo y de línea
    22	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:305
    20	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
    19	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:197
    18	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
    17	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
    14	PlgSystemFields->onContentPrepare()	Igual que la llamada en la línea de abajo.
    13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:108
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:392
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

22. Tiempo de consulta: 0.48 ms Después de la última consulta: 0.78 ms

    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
    
      FROM sm_fields AS a
    
      LEFT JOIN `sm_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN sm_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN sm_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN sm_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN sm_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `sm_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'com_content.article' 
      AND (fc.category_id IS NULL OR fc.category_id IN (21,0,16,9)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1) 
      AND a.language in ('*','es-CO')
    
      ORDER BY a.ordering ASC

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_state,idx_access,idx_context,idx_language	idx_context	766	const	1	Using where; Utilizando filesort
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	portalsaludmia.a.language	1
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	portalsaludmia.a.checked_out	1
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	portalsaludmia.a.access	1
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	portalsaludmia.a.created_user_id	1
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	portalsaludmia.a.group_id	1	Using where
    1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	portalsaludmia.a.id	1	Using where; Using index

    Perfil

    Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

    Call Stack

    #	Caller	Número de archivo y de línea
    20	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
    17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
    14	PlgSystemFields->onContentPrepare()	Igual que la llamada en la línea de abajo.
    13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:108
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:392
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

23. Tiempo de consulta: 0.27 ms Después de la última consulta: 1.22 ms

    SELECT `field_id`,`value`
    
      FROM `sm_fields_values`
    
      WHERE `field_id` IN (3,3) 
      AND `item_id` = '21'

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	sm_fields_values	ref	idx_field_id,idx_item_id	idx_item_id	766	const	1	Using where

    Perfil

    Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

    Call Stack

    #	Caller	Número de archivo y de línea
    18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
    17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_fields/models/field.php:708
    16	FieldsModelField->getFieldValues()	JROOT/administrator/components/com_fields/helpers/fields.php:158
    15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
    14	PlgSystemFields->onContentPrepare()	Igual que la llamada en la línea de abajo.
    13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:108
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:392
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

24. Tiempo de consulta: 0.49 ms Después de la última consulta: 17.69 ms

    SELECT `field_id`,`value`
    
      FROM `sm_fields_values`
    
      WHERE `field_id` IN (3,3) 
      AND `item_id` = '22'

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	sm_fields_values	ref	idx_field_id,idx_item_id	idx_item_id	766	const	1	Using where

    Perfil

    Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

    Call Stack

    #	Caller	Número de archivo y de línea
    18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
    17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_fields/models/field.php:708
    16	FieldsModelField->getFieldValues()	JROOT/administrator/components/com_fields/helpers/fields.php:158
    15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
    14	PlgSystemFields->onContentPrepare()	Igual que la llamada en la línea de abajo.
    13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:108
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:392
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

25. Tiempo de consulta: 0.56 ms Después de la última consulta: 8.14 ms

    SELECT `field_id`,`value`
    
      FROM `sm_fields_values`
    
      WHERE `field_id` IN (3,3) 
      AND `item_id` = '23'

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	sm_fields_values	ref	idx_field_id,idx_item_id	idx_item_id	766	const	1	Using where

    Perfil

    Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

    Call Stack

    #	Caller	Número de archivo y de línea
    18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
    17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_fields/models/field.php:708
    16	FieldsModelField->getFieldValues()	JROOT/administrator/components/com_fields/helpers/fields.php:158
    15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
    14	PlgSystemFields->onContentPrepare()	Igual que la llamada en la línea de abajo.
    13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:108
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:392
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

26. Tiempo de consulta: 0.58 ms Después de la última consulta: 10.95 ms

    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
    
      FROM sm_fields AS a
    
      LEFT JOIN `sm_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN sm_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN sm_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN sm_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN sm_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `sm_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'com_content.categories' 
      AND (fc.category_id IS NULL OR fc.category_id IN (21,0,16,9)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1) 
      AND a.language in ('*','es-CO')
    
      ORDER BY a.ordering ASC

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_state,idx_access,idx_context,idx_language	idx_context	766	const	1	Using where; Utilizando filesort
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	portalsaludmia.a.language	1
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	portalsaludmia.a.checked_out	1
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	portalsaludmia.a.access	1
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	portalsaludmia.a.created_user_id	1
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	portalsaludmia.a.group_id	1	Using where
    1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	portalsaludmia.a.id	1	Using where; Using index

    Perfil

    Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

    Call Stack

    #	Caller	Número de archivo y de línea
    24	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
    21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    19	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
    18	PlgSystemFields->onContentPrepare()	Igual que la llamada en la línea de abajo.
    17	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    15	JEventDispatcher->trigger()	JROOT/templates/saludmia/html/com_content/category/blog.php:19
    14	include JROOT/templates/saludmia/html/com_content/category/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
    13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:242
    11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:260
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:392
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

27. Tiempo de consulta: 0.39 ms Después de la última consulta: 4.24 ms

    SELECT language,id
    
      FROM `sm_menu`
    
      WHERE home = 1 
      AND published = 1 
      AND client_id = 0

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	sm_menu	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	93	Using where

    Perfil

    Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

    Call Stack

    #	Caller	Número de archivo y de línea
    11	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
    10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
    9	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:718
    8	PlgSystemLanguageFilter->onAfterDispatch()	Igual que la llamada en la línea de abajo.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

28. Tiempo de consulta: 0.38 ms Después de la última consulta: 1.02 ms

    SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`
    
      FROM `sm_categories` AS `c`
    
      INNER JOIN `sm_associations` AS `a` 
      ON a.id = c.`id` 
      AND a.context='com_categories.item'
    
      INNER JOIN `sm_associations` AS `a2` 
      ON a.key = a2.key
    
      INNER JOIN `sm_categories` AS `c2` 
      ON a2.id = c2.`id` 
      AND c2.extension = 'com_content'
    
      WHERE c.id = 21 
      AND c.extension = 'com_content'

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	Ninguna llave índice (INDEX KEY) pudo ser utilizada	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Perfil

    Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

    Call Stack

    #	Caller	Número de archivo y de línea
    15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:102
    13	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_categories/helpers/categories.php:113
    12	CategoriesHelper::getAssociations()	JROOT/administrator/components/com_categories/helpers/association.php:43
    11	CategoryHelperAssociation::getCategoryAssociations()	JROOT/components/com_content/helpers/association.php:58
    10	ContentHelperAssociation::getAssociations()	Igual que la llamada en la línea de abajo.
    9	call_user_func()	JROOT/plugins/system/languagefilter/languagefilter.php:750
    8	PlgSystemLanguageFilter->onAfterDispatch()	Igual que la llamada en la línea de abajo.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

29. Tiempo de consulta: 2.33 ms Después de la última consulta: 19.26 ms

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM sm_modules AS m
    
      LEFT JOIN sm_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN sm_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 <= '2019-12-07 02:09:41') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-12-07 02:09:41') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 127 OR mm.menuid <= 0) 
      AND m.language IN ('es-CO','*')
    
      ORDER BY m.position, m.ordering

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	PRIMARY,published,newsfeeds,idx_language	published	1	const	41	Using where; Utilizando filesort
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	portalsaludmia.m.id	1	Using where; Using index
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	portalsaludmia.m.module,const	1	Using where

    Perfil

    Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

    Call Stack

    #	Caller	Número de archivo y de línea
    18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
    17	JDatabaseDriver->loadObjectList()	Igual que la llamada en la línea de abajo.
    16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:433
    14	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:363
    13	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    12	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
    11	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/helix3/core/helix3.php:508
    10	Helix3::countModules()	JROOT/plugins/system/helix3/core/helix3.php:455
    9	Helix3::rowColumns()	JROOT/plugins/system/helix3/core/helix3.php:264
    8	Helix3::generatelayout()	JROOT/templates/saludmia/index.php:185
    7	require JROOT/templates/saludmia/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1103
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

30. Tiempo de consulta: 2.71 ms Después de la última consulta: 21.17 ms

    SELECT a.urls, a.images, a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      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,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating, 
    							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
    
      FROM sm_content AS a
    
      LEFT JOIN sm_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN sm_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN sm_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN sm_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN sm_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.catid IN (23) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-12-07 02:09:41') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-12-07 02:09:41') 
      AND a.language in ('es-CO','*')
    
      ORDER BY a.created asc 
      LIMIT 4

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	Utilizando filesort
    1	SIMPLE	a	ref	idx_access,idx_state,idx_catid,idx_language	idx_catid	4	const	1	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	portalsaludmia.a.created_by	1
    1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	portalsaludmia.a.modified_by	1	Using index
    1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	portalsaludmia.a.id	1

    Perfil

    Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

    Call Stack

    #	Caller	Número de archivo y de línea
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    14	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:556
    13	ContentModelArticles->getItems()	JROOT/modules/mod_bt_contentslider/classes/content.php:159
    12	BtContentDataSource->getList()	JROOT/modules/mod_bt_contentslider/helpers/helper.php:69
    11	modBtContentSliderHelper::getList()	JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php:21
    10	include JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

31. Tiempo de consulta: 0.41 ms Después de la última consulta: 0.68 ms

    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 sm_categories as c
    
      LEFT JOIN sm_categories AS s 
      ON (s.lft < c.lft 
      AND s.rgt > c.rgt 
      AND c.language in ('es-CO','*')) 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 s.id=23
    
      ORDER BY c.lft

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Utilizando filesort
    1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	Ninguna llave índice (INDEX KEY) pudo ser utilizada	NULL	NULL	46	Using where

    Perfil

    Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

    Call Stack

    #	Caller	Número de archivo y de línea
    25	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:305
    23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
    22	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    21	ContentRouter->getCategorySegment()	Igual que la llamada en la línea de abajo.
    20	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    19	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:86
    18	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    17	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:669
    16	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
    13	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_bt_contentslider/classes/content.php:207
    12	BtContentDataSource->getList()	JROOT/modules/mod_bt_contentslider/helpers/helper.php:69
    11	modBtContentSliderHelper::getList()	JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php:21
    10	include JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

32. Tiempo de consulta: 2.57 ms Después de la última consulta: 5.73 ms

    SELECT DISTINCT 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 c.published = 2 
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      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, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      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,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating, 
    							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
    
      FROM sm_content AS a
    
      LEFT JOIN sm_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN sm_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN sm_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN sm_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN sm_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.catid IN (24) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-12-07 02:09:41') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-12-07 02:09:41') 
      AND a.language in ('es-CO','*')
    
      ORDER BY a.title ASC 
      LIMIT 3

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	Using temporary; Utilizando filesort
    1	SIMPLE	a	index_merge	idx_access,idx_state,idx_catid,idx_language	idx_catid,idx_state	4,1	NULL	2	Using intersect(idx_catid,idx_state); Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	portalsaludmia.a.created_by	1
    1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	portalsaludmia.a.modified_by	1
    1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	portalsaludmia.a.id	1

    Perfil

    Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

    Call Stack

    #	Caller	Número de archivo y de línea
    19	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:556
    15	ContentModelArticles->getItems()	JROOT/modules/mod_category_articles_saludmia/helper.php:239
    14	ModCategoryArticlesSaludmiaHelper::getList()	Igual que la llamada en la línea de abajo.
    13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:560
    11	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_category_articles_saludmia/mod_category_articles_saludmia.php:61
    10	include JROOT/modules/mod_category_articles_saludmia/mod_category_articles_saludmia.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

33. Tiempo de consulta: 0.43 ms Después de la última consulta: 1.17 ms
    Consultas duplicadas: #35

    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 sm_categories as c
    
      LEFT JOIN sm_categories AS s 
      ON (s.lft < c.lft 
      AND s.rgt > c.rgt 
      AND c.language in ('es-CO','*')) 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 s.id=24
    
      ORDER BY c.lft

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Utilizando filesort
    1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	Ninguna llave índice (INDEX KEY) pudo ser utilizada	NULL	NULL	46	Using where

    Perfil

    Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

    Call Stack

    #	Caller	Número de archivo y de línea
    27	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
    26	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:305
    25	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
    24	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    23	ContentRouter->getCategorySegment()	Igual que la llamada en la línea de abajo.
    22	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    21	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:86
    20	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    19	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:669
    18	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
    15	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_category_articles_saludmia/helper.php:276
    14	ModCategoryArticlesSaludmiaHelper::getList()	Igual que la llamada en la línea de abajo.
    13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:560
    11	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_category_articles_saludmia/mod_category_articles_saludmia.php:61
    10	include JROOT/modules/mod_category_articles_saludmia/mod_category_articles_saludmia.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

34. Tiempo de consulta: 0.35 ms Después de la última consulta: 0.89 ms

    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
    
      FROM sm_fields AS a
    
      LEFT JOIN `sm_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN sm_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN sm_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN sm_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN sm_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `sm_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'mod_category_articles.content' 
      AND (fc.category_id IS NULL OR fc.category_id IN (21,0)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1) 
      AND a.language in ('*','es-CO')
    
      ORDER BY a.ordering ASC

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_state,idx_access,idx_context,idx_language	idx_context	766	const	1	Using where; Utilizando filesort
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	portalsaludmia.a.language	1
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	portalsaludmia.a.checked_out	1
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	portalsaludmia.a.access	1
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	portalsaludmia.a.created_user_id	1
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	portalsaludmia.a.group_id	1	Using where
    1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	portalsaludmia.a.id	1	Using where; Using index

    Perfil

    Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

    Call Stack

    #	Caller	Número de archivo y de línea
    28	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
    27	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    26	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
    25	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    24	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    23	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
    22	PlgSystemFields->onContentPrepare()	Igual que la llamada en la línea de abajo.
    21	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    18	JHtmlContent::prepare()	Igual que la llamada en la línea de abajo.
    17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
    15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_category_articles_saludmia/helper.php:321
    14	ModCategoryArticlesSaludmiaHelper::getList()	Igual que la llamada en la línea de abajo.
    13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:560
    11	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_category_articles_saludmia/mod_category_articles_saludmia.php:61
    10	include JROOT/modules/mod_category_articles_saludmia/mod_category_articles_saludmia.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

35. Tiempo de consulta: 0.33 ms Después de la última consulta: 1.41 ms
    Consultas duplicadas: #33

    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 sm_categories as c
    
      LEFT JOIN sm_categories AS s 
      ON (s.lft < c.lft 
      AND s.rgt > c.rgt 
      AND c.language in ('es-CO','*')) 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 s.id=24
    
      ORDER BY c.lft

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Utilizando filesort
    1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	Ninguna llave índice (INDEX KEY) pudo ser utilizada	NULL	NULL	46	Using where

    Perfil

    Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

    Call Stack

    #	Caller	Número de archivo y de línea
    15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:305
    13	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
    12	Joomla\CMS\Categories\Categories->get()	JROOT/modules/mod_category_articles_saludmia/helper.php:32
    11	ModCategoryArticlesSaludmiaHelper::getCategory()	JROOT/modules/mod_category_articles_saludmia/mod_category_articles_saludmia.php:64
    10	include JROOT/modules/mod_category_articles_saludmia/mod_category_articles_saludmia.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

36. Tiempo de consulta: 1.42 ms Después de la última consulta: 2.19 ms

    SELECT a.urls, a.images, a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      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,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating, 
    							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
    
      FROM sm_content AS a
    
      LEFT JOIN sm_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN sm_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN sm_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN sm_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN sm_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.catid IN (22) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-12-07 02:09:41') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-12-07 02:09:41') 
      AND a.language in ('es-CO','*')
    
      ORDER BY a.created asc 
      LIMIT 4

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	Utilizando filesort
    1	SIMPLE	a	ref	idx_access,idx_state,idx_catid,idx_language	idx_catid	4	const	1	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	portalsaludmia.a.created_by	1
    1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	portalsaludmia.a.modified_by	1	Using index
    1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	portalsaludmia.a.id	1

    Perfil

    Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

    Call Stack

    #	Caller	Número de archivo y de línea
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    14	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:556
    13	ContentModelArticles->getItems()	JROOT/modules/mod_bt_contentslider/classes/content.php:159
    12	BtContentDataSource->getList()	JROOT/modules/mod_bt_contentslider/helpers/helper.php:69
    11	modBtContentSliderHelper::getList()	JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php:21
    10	include JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

37. Tiempo de consulta: 29.02 ms Después de la última consulta: 3.19 ms

    SELECT DISTINCT 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 c.published = 2 
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      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, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      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,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating, 
    							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
    
      FROM sm_content AS a
    
      LEFT JOIN sm_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN sm_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN sm_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN sm_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN sm_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.catid IN (16) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-12-07 02:09:41') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-12-07 02:09:41') 
      AND a.language in ('es-CO','*')
    
      ORDER BY a.ordering DESC

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	Using temporary; Utilizando filesort
    1	SIMPLE	a	index_merge	idx_access,idx_state,idx_catid,idx_language	idx_catid,idx_state	4,1	NULL	9	Using intersect(idx_catid,idx_state); Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	portalsaludmia.a.created_by	1
    1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	portalsaludmia.a.modified_by	1
    1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	portalsaludmia.a.id	1

    Perfil

    Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

    Call Stack

    #	Caller	Número de archivo y de línea
    19	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:556
    15	ContentModelArticles->getItems()	JROOT/modules/mod_articles_category_saludmia/helper.php:229
    14	ModArticlesCategorySaludmiaHelper::getList()	Igual que la llamada en la línea de abajo.
    13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:560
    11	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_articles_category_saludmia/mod_articles_category_saludmia.php:61
    10	include JROOT/modules/mod_articles_category_saludmia/mod_articles_category_saludmia.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

38. Tiempo de consulta: 0.68 ms Después de la última consulta: 7.62 ms

    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
    
      FROM sm_fields AS a
    
      LEFT JOIN `sm_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN sm_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN sm_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN sm_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN sm_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `sm_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'mod_articles_category.content' 
      AND (fc.category_id IS NULL OR fc.category_id IN (21,0)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1) 
      AND a.language in ('*','es-CO')
    
      ORDER BY a.ordering ASC

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_state,idx_access,idx_context,idx_language	idx_context	766	const	1	Using where; Utilizando filesort
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	portalsaludmia.a.language	1
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	portalsaludmia.a.checked_out	1
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	portalsaludmia.a.access	1
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	portalsaludmia.a.created_user_id	1
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	portalsaludmia.a.group_id	1	Using where
    1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	portalsaludmia.a.id	1	Using where; Using index

    Perfil

    Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

    Call Stack

    #	Caller	Número de archivo y de línea
    28	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
    27	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    26	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
    25	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    24	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    23	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
    22	PlgSystemFields->onContentPrepare()	Igual que la llamada en la línea de abajo.
    21	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    18	JHtmlContent::prepare()	Igual que la llamada en la línea de abajo.
    17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
    15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_articles_category_saludmia/helper.php:311
    14	ModArticlesCategorySaludmiaHelper::getList()	Igual que la llamada en la línea de abajo.
    13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:560
    11	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_articles_category_saludmia/mod_articles_category_saludmia.php:61
    10	include JROOT/modules/mod_articles_category_saludmia/mod_articles_category_saludmia.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

39. Tiempo de consulta: 0.56 ms Después de la última consulta: 3156.86 ms

    SELECT `alias`
    
      FROM `sm_content`
    
      WHERE id = '115'

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	sm_content	const	PRIMARY	PRIMARY	4	const	1

    Perfil

    Status	Duration
    starting	0.04 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.05 ms
    logging slow query	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    19	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
    18	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
    17	ContentRouter->getArticleSegment()	Igual que la llamada en la línea de abajo.
    16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:86
    14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:669
    12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
    9	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
    8	PlgSystemSef->onAfterRender()	Igual que la llamada en la línea de abajo.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1123
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

40. Tiempo de consulta: 0.47 ms Después de la última consulta: 0.21 ms

    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 sm_categories as c
    
      LEFT JOIN sm_categories AS s 
      ON (s.lft < c.lft 
      AND s.rgt > c.rgt 
      AND c.language in ('es-CO','*')) 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 s.id=2
    
      ORDER BY c.lft

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Utilizando filesort
    1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	Ninguna llave índice (INDEX KEY) pudo ser utilizada	NULL	NULL	46	Using where

    Perfil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.02 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.04 ms
    logging slow query	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    21	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:305
    19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
    18	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    17	ContentRouter->getCategorySegment()	Igual que la llamada en la línea de abajo.
    16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:86
    14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:669
    12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
    9	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
    8	PlgSystemSef->onAfterRender()	Igual que la llamada en la línea de abajo.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1123
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

41. Tiempo de consulta: 0.27 ms Después de la última consulta: 0.44 ms

    SELECT `alias`
    
      FROM `sm_content`
    
      WHERE id = '90'

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	sm_content	const	PRIMARY	PRIMARY	4	const	1

    Perfil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.04 ms
    logging slow query	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    19	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
    18	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
    17	ContentRouter->getArticleSegment()	Igual que la llamada en la línea de abajo.
    16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:86
    14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:669
    12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
    9	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
    8	PlgSystemSef->onAfterRender()	Igual que la llamada en la línea de abajo.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1123
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

42. Tiempo de consulta: 0.19 ms Después de la última consulta: 0.18 ms

    SELECT alias
    
      FROM sm_content
    
      WHERE id=90

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	sm_content	const	PRIMARY	PRIMARY	4	const	1

    Perfil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.02 ms
    logging slow query	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
    16	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
    15	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
    14	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:528
    13	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
    12	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
    9	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
    8	PlgSystemSef->onAfterRender()	Igual que la llamada en la línea de abajo.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1123
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

43. Tiempo de consulta: 0.19 ms Después de la última consulta: 0.33 ms

    SELECT `alias`
    
      FROM `sm_content`
    
      WHERE id = '91'

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	sm_content	const	PRIMARY	PRIMARY	4	const	1

    Perfil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.02 ms
    logging slow query	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    19	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
    18	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
    17	ContentRouter->getArticleSegment()	Igual que la llamada en la línea de abajo.
    16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:86
    14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:669
    12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
    9	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
    8	PlgSystemSef->onAfterRender()	Igual que la llamada en la línea de abajo.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1123
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

44. Tiempo de consulta: 0.17 ms Después de la última consulta: 0.17 ms

    SELECT alias
    
      FROM sm_content
    
      WHERE id=91

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	sm_content	const	PRIMARY	PRIMARY	4	const	1

    Perfil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.02 ms
    logging slow query	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
    16	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
    15	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
    14	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:528
    13	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
    12	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
    9	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
    8	PlgSystemSef->onAfterRender()	Igual que la llamada en la línea de abajo.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1123
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

45. Tiempo de consulta: 0.18 ms Después de la última consulta: 0.36 ms

    SELECT `alias`
    
      FROM `sm_content`
    
      WHERE id = '92'

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	sm_content	const	PRIMARY	PRIMARY	4	const	1

    Perfil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.02 ms
    logging slow query	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    19	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
    18	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
    17	ContentRouter->getArticleSegment()	Igual que la llamada en la línea de abajo.
    16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:86
    14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:669
    12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
    9	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
    8	PlgSystemSef->onAfterRender()	Igual que la llamada en la línea de abajo.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1123
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

46. Tiempo de consulta: 0.17 ms Después de la última consulta: 0.17 ms

    SELECT alias
    
      FROM sm_content
    
      WHERE id=92

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	sm_content	const	PRIMARY	PRIMARY	4	const	1

    Perfil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.02 ms
    logging slow query	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
    16	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
    15	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
    14	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:528
    13	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
    12	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
    9	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
    8	PlgSystemSef->onAfterRender()	Igual que la llamada en la línea de abajo.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1123
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

47. Tiempo de consulta: 0.19 ms Después de la última consulta: 0.32 ms

    SELECT `alias`
    
      FROM `sm_content`
    
      WHERE id = '93'

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	sm_content	const	PRIMARY	PRIMARY	4	const	1

    Perfil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.02 ms
    logging slow query	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    19	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
    18	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
    17	ContentRouter->getArticleSegment()	Igual que la llamada en la línea de abajo.
    16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:86
    14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:669
    12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
    9	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
    8	PlgSystemSef->onAfterRender()	Igual que la llamada en la línea de abajo.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1123
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

48. Tiempo de consulta: 0.17 ms Después de la última consulta: 0.18 ms

    SELECT alias
    
      FROM sm_content
    
      WHERE id=93

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	sm_content	const	PRIMARY	PRIMARY	4	const	1

    Perfil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.02 ms
    logging slow query	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
    16	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
    15	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
    14	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:528
    13	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
    12	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
    9	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
    8	PlgSystemSef->onAfterRender()	Igual que la llamada en la línea de abajo.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1123
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

49. Tiempo de consulta: 0.17 ms Después de la última consulta: 0.34 ms

    SELECT `alias`
    
      FROM `sm_content`
    
      WHERE id = '108'

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	sm_content	const	PRIMARY	PRIMARY	4	const	1

    Perfil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.02 ms
    logging slow query	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    19	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
    18	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
    17	ContentRouter->getArticleSegment()	Igual que la llamada en la línea de abajo.
    16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:86
    14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:669
    12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
    9	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
    8	PlgSystemSef->onAfterRender()	Igual que la llamada en la línea de abajo.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1123
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

50. Tiempo de consulta: 0.17 ms Después de la última consulta: 0.17 ms

    SELECT alias
    
      FROM sm_content
    
      WHERE id=108

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	sm_content	const	PRIMARY	PRIMARY	4	const	1

    Perfil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.02 ms
    logging slow query	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
    16	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
    15	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
    14	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:528
    13	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
    12	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
    9	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
    8	PlgSystemSef->onAfterRender()	Igual que la llamada en la línea de abajo.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1123
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

51. Tiempo de consulta: 0.19 ms Después de la última consulta: 0.31 ms

    SELECT `alias`
    
      FROM `sm_content`
    
      WHERE id = '109'

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	sm_content	const	PRIMARY	PRIMARY	4	const	1

    Perfil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.02 ms
    logging slow query	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    19	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
    18	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
    17	ContentRouter->getArticleSegment()	Igual que la llamada en la línea de abajo.
    16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:86
    14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:669
    12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
    9	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
    8	PlgSystemSef->onAfterRender()	Igual que la llamada en la línea de abajo.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1123
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---

52. Tiempo de consulta: 0.21 ms Después de la última consulta: 0.17 ms

    SELECT alias
    
      FROM sm_content
    
      WHERE id=109

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	sm_content	const	PRIMARY	PRIMARY	4	const	1

    Perfil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.02 ms
    logging slow query	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
    16	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
    15	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
    14	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:528
    13	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
    12	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
    9	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
    8	PlgSystemSef->onAfterRender()	Igual que la llamada en la línea de abajo.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1123
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

    ---