Grupo D3

Grupo D3

  • Inicio
      • Log in or Register

        • Forgot your username?
        • Forgot your password?
  • Acerca de nosotros
  • Páginas
      • Precios y paquetes
      • Preguntas frecuentes
      • Nuestro equipo
      • Historia
      • Mapa del sitio
      • Descargas
  • Blog
  • Galería
  • Contacto
  • Búsqueda
  • Inicio | 
  • Páginas | 
  • Mapa del sitio

Mapa del sitio

Pages

  • Inicio
    • Acceso y registro
    • Servicios
    • Servicios adicionales
    • Qué hacemos
  • Acerca de nosotros
  • Páginas
    • Precios y paquetes
    • Preguntas frecuentes
    • Nuestro equipo
    • Historia
    • Mapa del sitio
    • Descargas
  • Blog
  • Galería
  • Contacto
  • Búsqueda
    • Search field

Blog posts

  • ¿Quién sabe? o ¿cómo saber quién SÍ sabe?
  • De la experiencia con el padre Chinchachoma y los modos para con la infancia
  • De la fascista Gloria Álvarez y su video anticomunista.
  • Porqué el capitalismo es un concepto de izquierda.
  • El caso de los botones de Marsella
  • De las quesadillas
  • Del enrarecimiento del ambiente político actual.
  • De la Fascista Gloria Álvarez.
  • Taller: Física, Química y Matemáticas
  • Convocatoria 2017 del CENEVAL para acreditación de secundaria
  • De dioses, chakras y unicornios
  • Algunas perspectivas del terremoto del 19 de septiembre de 2017
  • De la escala de Richter en Wikipedia
  • Por fin están funcionando las tiendas
  • Sesión 1 del taller de cómic de verano
  • Del arte
  • Estamos próximos a abrir nuestra tienda virtual: Ilustra D3
  • Iniciamos una nueva ruta en la profesionalización de nuestros servicios
  • Taller de Dibujo de Cómic

User menu

  • Login form
  • Create account

Portfolio posts

  • Proyecto Ilustraciones ACNUR
  • Proyecto Cómic ACNUR 2013
Grupo D3 © 2022 Privacy Policy. Terms of use
Login or register
Forgot ¿Recordar usuario?/ ¿Recordar contraseña??
Login with Facebook
Login with Google +

Consola de depuración de Joomla!

Sesión

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1653303157,
                "last": 1653303157,
                "now": 1653303157
            },
            "token": "wt2DxS21VLXg4xwhp4agefULdie1lOI4"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Información del perfil

Fecha y hora

Memoria

Fecha y hora: 120.16 ms / 120.16 ms Memoria: 1.973 MB / 2.34 MB Application: afterLoad
Fecha y hora: 164.01 ms / 284.17 ms Memoria: 4.695 MB / 7.04 MB Application: afterInitialise
Fecha y hora: 51.74 ms / 335.90 ms Memoria: 1.722 MB / 8.76 MB Application: afterRoute
Fecha y hora: 12.94 ms / 348.84 ms Memoria: 0.251 MB / 9.01 MB Application: beforeRenderComponent com_content
Fecha y hora: 12.20 ms / 361.04 ms Memoria: 0.538 MB / 9.55 MB Application: Before Access::preloadComponents (all components)
Fecha y hora: 2.04 ms / 363.09 ms Memoria: 0.057 MB / 9.60 MB Application: After Access::preloadComponents (all components)
Fecha y hora: 0.05 ms / 363.14 ms Memoria: -0.004 MB / 9.60 MB Application: Before Access::preloadPermissions (com_content)
Fecha y hora: 1.88 ms / 365.02 ms Memoria: 0.183 MB / 9.78 MB Application: After Access::preloadPermissions (com_content)
Fecha y hora: 0.06 ms / 365.08 ms Memoria: -0.011 MB / 9.77 MB Application: Before Access::getAssetRules (id:27 name:com_content.category.2)
Fecha y hora: 1.13 ms / 366.21 ms Memoria: 0.027 MB / 9.80 MB Application: After Access::getAssetRules (id:27 name:com_content.category.2)
Fecha y hora: 8.21 ms / 374.42 ms Memoria: 0.211 MB / 10.01 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Fecha y hora: 0.13 ms / 374.55 ms Memoria: 0.007 MB / 10.02 MB Application: After Access::getAssetRules (id:8 name:com_content)
Fecha y hora: 95.57 ms / 470.12 ms Memoria: 1.478 MB / 11.49 MB Application: beforeRenderModule mod_search (Search)
Fecha y hora: 29.16 ms / 499.28 ms Memoria: 0.192 MB / 11.69 MB Application: afterRenderModule mod_search (Search)
Fecha y hora: 4.32 ms / 503.60 ms Memoria: -0.003 MB / 11.68 MB Application: afterRenderComponent com_content
Fecha y hora: 7.13 ms / 510.72 ms Memoria: 0.265 MB / 11.95 MB Application: afterDispatch
Fecha y hora: 8.09 ms / 518.81 ms Memoria: 0.155 MB / 12.10 MB Application: beforeRenderModule mod_tm_style_switcher (TM Ajax Style Switcher)
Fecha y hora: 1.35 ms / 520.17 ms Memoria: 0.043 MB / 12.15 MB Application: Before Access::getAssetRules (id:23 name:com_templates)
Fecha y hora: 0.12 ms / 520.29 ms Memoria: 0.007 MB / 12.15 MB Application: After Access::getAssetRules (id:23 name:com_templates)
Fecha y hora: 0.12 ms / 520.41 ms Memoria: -0.025 MB / 12.13 MB Application: afterRenderModule mod_tm_style_switcher (TM Ajax Style Switcher)
Fecha y hora: 0.11 ms / 520.52 ms Memoria: -0.000 MB / 12.13 MB Application: beforeRenderModule mod_socialloginandsocialshare (Login or register)
Fecha y hora: 14.37 ms / 534.89 ms Memoria: 0.364 MB / 12.49 MB Application: afterRenderModule mod_socialloginandsocialshare (Login or register)
Fecha y hora: 0.13 ms / 535.02 ms Memoria: -0.004 MB / 12.49 MB Application: beforeRenderModule mod_menu (Social media)
Fecha y hora: 2.58 ms / 537.60 ms Memoria: 0.041 MB / 12.53 MB Application: afterRenderModule mod_menu (Social media)
Fecha y hora: 0.13 ms / 537.73 ms Memoria: -0.004 MB / 12.53 MB Application: beforeRenderModule mod_menu (Pages)
Fecha y hora: 20.20 ms / 557.93 ms Memoria: 0.129 MB / 12.65 MB Application: afterRenderModule mod_menu (Pages)
Fecha y hora: 0.09 ms / 558.02 ms Memoria: 0.000 MB / 12.65 MB Application: beforeRenderModule mod_articles_category (Blog posts)
Fecha y hora: 562.20 ms / 1120.22 ms Memoria: 0.695 MB / 13.35 MB Application: afterRenderModule mod_articles_category (Blog posts)
Fecha y hora: 0.28 ms / 1120.50 ms Memoria: -0.423 MB / 12.93 MB Application: beforeRenderModule mod_menu (User menu)
Fecha y hora: 2.33 ms / 1122.83 ms Memoria: 0.011 MB / 12.94 MB Application: afterRenderModule mod_menu (User menu)
Fecha y hora: 0.09 ms / 1122.92 ms Memoria: 0.002 MB / 12.94 MB Application: beforeRenderModule mod_articles_category (Portfolio posts)
Fecha y hora: 10.19 ms / 1133.11 ms Memoria: 0.084 MB / 13.02 MB Application: afterRenderModule mod_articles_category (Portfolio posts)
Fecha y hora: 0.17 ms / 1133.28 ms Memoria: -0.042 MB / 12.98 MB Application: beforeRenderModule mod_breadcrumbs (Superior)
Fecha y hora: 2.37 ms / 1135.65 ms Memoria: 0.025 MB / 13.01 MB Application: afterRenderModule mod_breadcrumbs (Superior)
Fecha y hora: 0.14 ms / 1135.79 ms Memoria: -0.004 MB / 13.00 MB Application: beforeRenderModule mod_icemegamenu (Main menu)
Fecha y hora: 18.96 ms / 1154.75 ms Memoria: 0.468 MB / 13.47 MB Application: beforeRenderModule mod_login (Log in or Register)
Fecha y hora: 1.69 ms / 1156.44 ms Memoria: 0.023 MB / 13.49 MB Application: afterRenderModule mod_login (Log in or Register)
Fecha y hora: 6.39 ms / 1162.84 ms Memoria: 0.065 MB / 13.56 MB Application: beforeRenderModule mod_search (Menu search)
Fecha y hora: 1.19 ms / 1164.03 ms Memoria: 0.008 MB / 13.57 MB Application: afterRenderModule mod_search (Menu search)
Fecha y hora: 30.09 ms / 1194.12 ms Memoria: -0.005 MB / 13.56 MB Application: afterRenderModule mod_icemegamenu (Main menu)
Fecha y hora: 4.46 ms / 1198.58 ms Memoria: 0.117 MB / 13.68 MB Application: afterRender

Total de consultas a la base de datos: 72.58 ms

Uso de la memoria

14.29 MB (14,986,208 Bytes)

Consultas de la base de datos

45 consultas registradas 72.58 ms


¡ 3 duplicaciones detectadas!

3 duplicaciones: #8  #24  #31
  1. Tiempo de la consulta: 1.00 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 4.117 MB Filas devueltas: 0
    SELECT `data`
    
      FROM `grupod3_session`
      WHERE `session_id` = X'6463633161376166376636623638363837613732323935643631343731653033'
    Explicar
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEgrupod3_sessionNULLconstPRIMARYPRIMARY194const1100.00NULL
    Perfil
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.43 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.06 ms
    executing0.02 ms
    end0.02 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.04 ms
    cleaning up0.02 ms
    Llamada de pila
    #ComunicadorArchivo y número de línea
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    15JDatabaseDriver->loadResult()JROOT/libraries/joomla/session/storage/database.php:45
    14JSessionStorageDatabase->read()Lo mismo que llamada de la línea de abajo.
    13session_start()JROOT/libraries/joomla/session/handler/native.php:260
    12JSessionHandlerNative->doSessionStart()JROOT/libraries/joomla/session/handler/native.php:50
    11JSessionHandlerNative->start()JROOT/libraries/joomla/session/handler/joomla.php:88
    10JSessionHandlerJoomla->start()JROOT/libraries/src/Session/Session.php:661
    9Joomla\CMS\Session\Session->_start()JROOT/libraries/src/Session/Session.php:621
    8Joomla\CMS\Session\Session->start()JROOT/libraries/src/Session/Session.php:499
    7Joomla\CMS\Session\Session->get()JROOT/libraries/src/Session/Session.php:456
    6Joomla\CMS\Session\Session->isNew()JROOT/libraries/src/Application/CMSApplication.php:854
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:136
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:414
    2Joomla\CMS\Application\CMSApplication::getInstance()JROOT/libraries/src/Factory.php:140
    1Joomla\CMS\Factory::getApplication()JROOT/index.php:46
    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

  2. Tiempo de la consulta: 0.53 ms Después de la última consulta: 2.76 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 4.213 MB Filas devueltas: 0
    SELECT `session_id`
    
      FROM `grupod3_session`
      WHERE `session_id` = X'6463633161376166376636623638363837613732323935643631343731653033'
      LIMIT 1
    Explicar
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEgrupod3_sessionNULLconstPRIMARYPRIMARY194const1100.00Using index
    Perfil
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.03 ms
    System lock0.02 ms
    optimizing0.02 ms
    statistics0.05 ms
    executing0.03 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.04 ms
    cleaning up0.02 ms
    Llamada de pila
    #ComunicadorArchivo y número de línea
    9JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    8JDatabaseDriver->loadResult()JROOT/libraries/src/Session/MetadataManager.php:74
    7Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()JROOT/libraries/src/Application/CMSApplication.php:154
    6Joomla\CMS\Application\CMSApplication->checkSession()JROOT/libraries/src/Application/CMSApplication.php:856
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:136
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:414
    2Joomla\CMS\Application\CMSApplication::getInstance()JROOT/libraries/src/Factory.php:140
    1Joomla\CMS\Factory::getApplication()JROOT/index.php:46
    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

  3. Tiempo de la consulta: 1.09 ms Después de la última consulta: 0.19 ms Consulta a la memoria: 0.004 MB memoria antes de la consulta: 4.218 MB
    INSERT INTO `grupod3_session`
    (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES (X'6463633161376166376636623638363837613732323935643631343731653033', 1, 1653303157, 0, '', 0)
    Explicar
    'Explicar' no es posible en la consulta: INSERT INTO `grupod3_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6463633161376166376636623638363837613732323935643631343731653033', 1, 1653303157, 0, '', 0)
    Perfil
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.03 ms
    System lock0.01 ms
    update0.16 ms
    end0.02 ms
    query end0.48 ms
    closing tables0.04 ms
    freeing items0.04 ms
    cleaning up0.02 ms
    Llamada de pila
    #ComunicadorArchivo y número de línea
    8JDatabaseDriverMysqli->execute()JROOT/libraries/src/Session/MetadataManager.php:116
    7Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()JROOT/libraries/src/Application/CMSApplication.php:154
    6Joomla\CMS\Application\CMSApplication->checkSession()JROOT/libraries/src/Application/CMSApplication.php:856
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:136
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:414
    2Joomla\CMS\Application\CMSApplication::getInstance()JROOT/libraries/src/Factory.php:140
    1Joomla\CMS\Factory::getApplication()JROOT/index.php:46
    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

  4. Tiempo de la consulta: 1.95 ms Después de la última consulta: 6.07 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 4.436 MB Filas devueltas: 39
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `grupod3_extensions`
      WHERE `type` = 'component'
      AND `state` = 0
      AND `enabled` = 1
    Explicar
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEgrupod3_extensionsNULLrefextensionextension82const391.00Using where
    Perfil
    StatusDuration
    starting0.07 ms
    checking permissions0.02 ms
    Opening tables0.58 ms
    init0.04 ms
    System lock0.02 ms
    optimizing0.02 ms
    statistics0.11 ms
    preparing0.03 ms
    executing0.01 ms
    Sending data0.46 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.06 ms
    cleaning up0.02 ms
    Llamada de pila
    #ComunicadorArchivo y número de línea
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    11JDatabaseDriver->loadObjectList()JROOT/libraries/src/Component/ComponentHelper.php:445
    10Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()Lo mismo que llamada de la línea de abajo.
    9call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    8Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Component/ComponentHelper.php:453
    7Joomla\CMS\Component\ComponentHelper::load()JROOT/libraries/src/Component/ComponentHelper.php:519
    6Joomla\CMS\Component\ComponentHelper::getComponents()JROOT/libraries/src/Component/ComponentHelper.php:44
    5Joomla\CMS\Component\ComponentHelper::getComponent()JROOT/libraries/src/Component/ComponentHelper.php:103
    4Joomla\CMS\Component\ComponentHelper::getParams()JROOT/libraries/src/Application/SiteApplication.php:594
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

  5. Tiempo de la consulta: 1.44 ms Después de la última consulta: 5.00 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 4.690 MB Filas devueltas: 5
    SELECT id, rules
    
      FROM `grupod3_viewlevels`
    Explicar
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEgrupod3_viewlevelsNULLALLNULLNo pudo usarse una clave de índiceNULLNULL5100.00NULL
    Perfil
    StatusDuration
    starting0.06 ms
    checking permissions0.02 ms
    Opening tables0.84 ms
    init0.03 ms
    System lock0.02 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.07 ms
    end0.03 ms
    query end0.02 ms
    closing tables0.02 ms
    freeing items0.05 ms
    cleaning up0.03 ms
    Llamada de pila
    #ComunicadorArchivo y número de línea
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1506
    9JDatabaseDriver->loadAssocList()JROOT/libraries/src/Access/Access.php:1063
    8Joomla\CMS\Access\Access::getAuthorisedViewLevels()JROOT/libraries/src/User/User.php:458
    7Joomla\CMS\User\User->getAuthorisedViewLevels()JROOT/libraries/src/Plugin/PluginHelper.php:318
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:604
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

  6. Tiempo de la consulta: 1.45 ms Después de la última consulta: 0.16 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 4.702 MB Filas devueltas: 2
    SELECT b.id
    
      FROM grupod3_usergroups AS a
      LEFT JOIN grupod3_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.id = 9
    Explicar
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLconstPRIMARYPRIMARY4const1100.00NULL
    1SIMPLEbNULLrangeidx_usergroup_nested_set_lookupidx_usergroup_nested_set_lookup4NULL2100.00Using where; Using index
    Perfil
    StatusDuration
    starting0.08 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.69 ms
    init0.04 ms
    System lock0.02 ms
    optimizing0.02 ms
    statistics0.13 ms
    preparing0.03 ms
    executing0.01 ms
    Sending data0.06 ms
    end0.01 ms
    query end0.02 ms
    closing tables0.03 ms
    freeing items0.05 ms
    cleaning up0.03 ms
    Llamada de pila
    #ComunicadorArchivo y número de línea
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1550
    10JDatabaseDriver->loadColumn()JROOT/libraries/src/Access/Access.php:980
    9Joomla\CMS\Access\Access::getGroupsByUser()JROOT/libraries/src/Access/Access.php:1095
    8Joomla\CMS\Access\Access::getAuthorisedViewLevels()JROOT/libraries/src/User/User.php:458
    7Joomla\CMS\User\User->getAuthorisedViewLevels()JROOT/libraries/src/Plugin/PluginHelper.php:318
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:604
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

  7. Tiempo de la consulta: 2.17 ms Después de la última consulta: 1.37 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 4.770 MB Filas devueltas: 94
    SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
    
      FROM grupod3_extensions
      WHERE enabled = 1
      AND type = 'plugin'
      AND state IN (0,1)
      AND access IN (1,1,5)
      ORDER BY ordering
    Explicar
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEgrupod3_extensionsNULLrefextensionextension82const1140.60Using index condition; Using where; Usando 'filesort'
    Perfil
    StatusDuration
    starting0.11 ms
    checking permissions0.02 ms
    Opening tables0.03 ms
    init0.05 ms
    System lock0.02 ms
    optimizing0.03 ms
    statistics0.10 ms
    preparing0.05 ms
    Sorting result0.02 ms
    executing0.01 ms
    Sending data0.02 ms
    Creating sort index1.22 ms
    end0.02 ms
    query end0.02 ms
    closing tables0.02 ms
    freeing items0.06 ms
    cleaning up0.03 ms
    Llamada de pila
    #ComunicadorArchivo y número de línea
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    10JDatabaseDriver->loadObjectList()JROOT/libraries/src/Plugin/PluginHelper.php:351
    9Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()Lo mismo que llamada de la línea de abajo.
    8call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    7Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Plugin/PluginHelper.php:356
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:604
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

  8. Tiempo de la consulta: 1.56 ms Después de la última consulta: 56.58 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 6.728 MB Filas devueltas: 10
    Consultas duplicadas: #24  #31
    SELECT * 
      FROM grupod3_loginradius_settings
    Explicar
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEgrupod3_loginradius_settingsNULLALLNULLNo pudo usarse una clave de índiceNULLNULL10100.00NULL
    Perfil
    StatusDuration
    starting0.06 ms
    checking permissions0.02 ms
    Opening tables0.80 ms
    init0.03 ms
    System lock0.05 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.10 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.05 ms
    cleaning up0.02 ms
    Llamada de pila
    #ComunicadorArchivo y número de línea
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1506
    10JDatabaseDriver->loadAssocList()JROOT/plugins/system/socialloginandsocialshare/socialloginandsocialshare_helper.php:58
    9plgSystemSocialLoginTools::sociallogin_getsettings()JROOT/plugins/system/socialloginandsocialshare/socialloginandsocialshare.php:51
    8plgSystemSocialLoginAndSocialShare->onAfterInitialise()JROOT/libraries/joomla/event/event.php:70
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    6JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    5Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:696
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:686
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

  9. Tiempo de la consulta: 3.99 ms Después de la última consulta: 24.85 ms Consulta a la memoria: 0.116 MB memoria antes de la consulta: 7.226 MB Filas devueltas: 92
    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 grupod3_menu AS m
      LEFT JOIN grupod3_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
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLrangeidx_client_id_parent_id_alias_languageidx_client_id_parent_id_alias_language5NULL11510.00Using index condition; Using where; Usando 'filesort'
    1SIMPLEeNULLeq_refPRIMARYPRIMARY4grupod3_grupod3.m.component_id1100.00Using where
    Perfil
    StatusDuration
    starting0.12 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.67 ms
    init0.05 ms
    System lock0.02 ms
    optimizing0.02 ms
    statistics0.11 ms
    preparing0.04 ms
    Sorting result0.02 ms
    executing0.01 ms
    Sending data0.03 ms
    Creating sort index2.28 ms
    end0.02 ms
    query end0.02 ms
    closing tables0.03 ms
    freeing items0.06 ms
    cleaning up0.03 ms
    Llamada de pila
    #ComunicadorArchivo y número de línea
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    18JDatabaseDriver->loadObjectList()JROOT/libraries/src/Menu/SiteMenu.php:93
    17Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()Lo mismo que llamada de la línea de abajo.
    16call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Menu/SiteMenu.php:101
    14Joomla\CMS\Menu\SiteMenu->load()JROOT/libraries/src/Menu/AbstractMenu.php:78
    13Joomla\CMS\Menu\AbstractMenu->__construct()JROOT/libraries/src/Menu/SiteMenu.php:62
    12Joomla\CMS\Menu\SiteMenu->__construct()JROOT/libraries/src/Menu/AbstractMenu.php:142
    11Joomla\CMS\Menu\AbstractMenu::getInstance()JROOT/libraries/src/Application/CMSApplication.php:445
    10Joomla\CMS\Application\CMSApplication->getMenu()JROOT/libraries/src/Application/SiteApplication.php:275
    9Joomla\CMS\Application\SiteApplication->getMenu()JROOT/libraries/src/Router/SiteRouter.php:65
    8Joomla\CMS\Router\SiteRouter->__construct()JROOT/libraries/src/Router/Router.php:189
    7Joomla\CMS\Router\Router::getInstance()JROOT/libraries/src/Application/CMSApplication.php:561
    6Joomla\CMS\Application\CMSApplication::getRouter()JROOT/libraries/src/Application/SiteApplication.php:403
    5Joomla\CMS\Application\SiteApplication::getRouter()JROOT/libraries/src/Application/CMSApplication.php:1169
    4Joomla\CMS\Application\CMSApplication->route()JROOT/libraries/src/Application/SiteApplication.php:796
    3Joomla\CMS\Application\SiteApplication->route()JROOT/libraries/src/Application/SiteApplication.php:218
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

  10. Tiempo de la consulta: 1.82 ms Después de la última consulta: 27.63 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 8.371 MB Filas devueltas: 2
    SHOW FULL COLUMNS 
      FROM `grupod3_komento_configs`
    Explicar
    'Explicar' no es posible en la consulta: SHOW FULL COLUMNS FROM `grupod3_komento_configs`
    Perfil
    StatusDuration
    starting0.06 ms
    checking permissions0.02 ms
    checking permissions0.01 ms
    Opening tables0.27 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.01 ms
    executing0.04 ms
    Opening tables0.76 ms
    checking permissions0.07 ms
    checking permissions0.03 ms
    Sending data0.05 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    removing tmp table0.04 ms
    closing tables0.01 ms
    freeing items0.04 ms
    cleaning up0.04 ms
    Llamada de pila
    #ComunicadorArchivo y número de línea
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    18JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/database/driver/mysqli.php:448
    17JDatabaseDriverMysqli->getTableColumns()JROOT/libraries/src/Table/Table.php:261
    16Joomla\CMS\Table\Table->getFields()JROOT/libraries/src/Table/Table.php:180
    15Joomla\CMS\Table\Table->__construct()JROOT/administrator/components/com_komento/tables/parent.php:18
    14KomentoParentTable->__construct()JROOT/administrator/components/com_komento/tables/configs.php:40
    13KomentoTableConfigs->__construct()JROOT/libraries/src/Table/Table.php:328
    12Joomla\CMS\Table\Table::getInstance()JROOT/administrator/components/com_komento/tables/parent.php:49
    11KomentoParentTable::getInstance()JROOT/components/com_komento/helpers/helper.php:99
    10Komento::getTable()JROOT/components/com_komento/helpers/helper.php:228
    9Komento::getKonfig()JROOT/components/com_komento/bootstrap.php:30
    8require_once JROOT/components/com_komento/bootstrap.phpJROOT/components/com_komento/router.php:16
    7require_once JROOT/components/com_komento/router.phpJROOT/libraries/src/Router/SiteRouter.php:779
    6Joomla\CMS\Router\SiteRouter->getComponentRouter()JROOT/libraries/src/Router/SiteRouter.php:131
    5Joomla\CMS\Router\SiteRouter->parse()JROOT/libraries/src/Application/CMSApplication.php:1170
    4Joomla\CMS\Application\CMSApplication->route()JROOT/libraries/src/Application/SiteApplication.php:796
    3Joomla\CMS\Application\SiteApplication->route()JROOT/libraries/src/Application/SiteApplication.php:218
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

  11. Tiempo de la consulta: 0.67 ms Después de la última consulta: 1.00 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 8.401 MB Filas devueltas: 1
    SELECT *
    
      FROM grupod3_komento_configs
      WHERE `component` = 'com_komento'
    Explicar
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEgrupod3_komento_configsNULLALLNULLNo pudo usarse una clave de índiceNULLNULL520.00Using where
    Perfil
    StatusDuration
    starting0.07 ms
    checking permissions0.02 ms
    Opening tables0.03 ms
    init0.04 ms
    System lock0.02 ms
    optimizing0.02 ms
    statistics0.03 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.11 ms
    end0.02 ms
    query end0.02 ms
    closing tables0.02 ms
    freeing items0.06 ms
    cleaning up0.03 ms
    Llamada de pila
    #ComunicadorArchivo y número de línea
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1465
    11JDatabaseDriver->loadAssoc()JROOT/libraries/src/Table/Table.php:747
    10Joomla\CMS\Table\Table->load()JROOT/components/com_komento/helpers/helper.php:229
    9Komento::getKonfig()JROOT/components/com_komento/bootstrap.php:30
    8require_once JROOT/components/com_komento/bootstrap.phpJROOT/components/com_komento/router.php:16
    7require_once JROOT/components/com_komento/router.phpJROOT/libraries/src/Router/SiteRouter.php:779
    6Joomla\CMS\Router\SiteRouter->getComponentRouter()JROOT/libraries/src/Router/SiteRouter.php:131
    5Joomla\CMS\Router\SiteRouter->parse()JROOT/libraries/src/Application/CMSApplication.php:1170
    4Joomla\CMS\Application\CMSApplication->route()JROOT/libraries/src/Application/SiteApplication.php:796
    3Joomla\CMS\Application\SiteApplication->route()JROOT/libraries/src/Application/SiteApplication.php:218
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

  12. Tiempo de la consulta: 0.93 ms Después de la última consulta: 12.64 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 8.793 MB Filas devueltas: 1
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `grupod3_extensions`
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explicar
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEgrupod3_extensionsNULLrefelement_clientid,element_folder_clientid,extensionextension484const,const1100.00NULL
    Perfil
    StatusDuration
    starting0.08 ms
    checking permissions0.02 ms
    Opening tables0.03 ms
    init0.05 ms
    System lock0.02 ms
    optimizing0.04 ms
    statistics0.16 ms
    preparing0.03 ms
    executing0.03 ms
    Sending data0.10 ms
    end0.02 ms
    query end0.02 ms
    closing tables0.02 ms
    freeing items0.06 ms
    cleaning up0.03 ms
    Llamada de pila
    #ComunicadorArchivo y número de línea
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    14JDatabaseDriver->loadObject()JROOT/libraries/src/Helper/LibraryHelper.php:167
    13Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()Lo mismo que llamada de la línea de abajo.
    12call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    11Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/LibraryHelper.php:175
    10Joomla\CMS\Helper\LibraryHelper::loadLibrary()JROOT/libraries/src/Helper/LibraryHelper.php:43
    9Joomla\CMS\Helper\LibraryHelper::getLibrary()JROOT/libraries/src/Helper/LibraryHelper.php:90
    8Joomla\CMS\Helper\LibraryHelper::getParams()JROOT/libraries/src/Version.php:321
    7Joomla\CMS\Version->getMediaVersion()JROOT/libraries/src/Factory.php:778
    6Joomla\CMS\Factory::createDocument()JROOT/libraries/src/Factory.php:234
    5Joomla\CMS\Factory::getDocument()JROOT/libraries/src/Application/WebApplication.php:1137
    4Joomla\CMS\Application\WebApplication->loadDocument()JROOT/libraries/src/Application/SiteApplication.php:133
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

  13. Tiempo de la consulta: 1.50 ms Después de la última consulta: 0.28 ms Consulta a la memoria: 0.005 MB memoria antes de la consulta: 8.784 MB
    UPDATE `grupod3_extensions`
    
      SET `params` = '{\"mediaversion\":\"f9c8d36b8f6a78e94076007ad7c5b4ff\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explicar
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1UPDATEgrupod3_extensionsNULLrangeelement_clientid,element_folder_clientid,extensionextension484const,const1100.00Using where
    Perfil
    StatusDuration
    starting0.07 ms
    checking permissions0.02 ms
    Opening tables0.03 ms
    init0.03 ms
    System lock0.14 ms
    updating0.17 ms
    end0.02 ms
    query end0.53 ms
    closing tables0.05 ms
    freeing items0.06 ms
    cleaning up0.03 ms
    Llamada de pila
    #ComunicadorArchivo y número de línea
    10JDatabaseDriverMysqli->execute()JROOT/libraries/src/Helper/LibraryHelper.php:117
    9Joomla\CMS\Helper\LibraryHelper::saveParams()JROOT/libraries/src/Version.php:372
    8Joomla\CMS\Version->setMediaVersion()JROOT/libraries/src/Version.php:331
    7Joomla\CMS\Version->getMediaVersion()JROOT/libraries/src/Factory.php:778
    6Joomla\CMS\Factory::createDocument()JROOT/libraries/src/Factory.php:234
    5Joomla\CMS\Factory::getDocument()JROOT/libraries/src/Application/WebApplication.php:1137
    4Joomla\CMS\Application\WebApplication->loadDocument()JROOT/libraries/src/Application/SiteApplication.php:133
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

  14. Tiempo de la consulta: 1.42 ms Después de la última consulta: 4.03 ms Consulta a la memoria: 0.019 MB memoria antes de la consulta: 8.969 MB Filas devueltas: 1
    SELECT *
    
      FROM grupod3_languages
      WHERE published=1
      ORDER BY ordering ASC
    Explicar
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEgrupod3_languagesNULLALLNULLNo pudo usarse una clave de índiceNULLNULL1100.00Using where; Usando 'filesort'
    Perfil
    StatusDuration
    starting0.07 ms
    checking permissions0.02 ms
    Opening tables0.67 ms
    init0.05 ms
    System lock0.02 ms
    optimizing0.02 ms
    statistics0.03 ms
    preparing0.03 ms
    Sorting result0.01 ms
    executing0.01 ms
    Sending data0.03 ms
    Creating sort index0.11 ms
    end0.02 ms
    query end0.02 ms
    closing tables0.02 ms
    freeing items0.06 ms
    cleaning up0.03 ms
    Llamada de pila
    #ComunicadorArchivo y número de línea
    7JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    6JDatabaseDriver->loadObjectList()JROOT/libraries/src/Language/LanguageHelper.php:150
    5Joomla\CMS\Language\LanguageHelper::getLanguages()JROOT/libraries/src/Application/SiteApplication.php:330
    4Joomla\CMS\Application\SiteApplication->getParams()JROOT/libraries/src/Application/SiteApplication.php:138
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

  15. Tiempo de la consulta: 1.87 ms Después de la última consulta: 0.48 ms Consulta a la memoria: 0.019 MB memoria antes de la consulta: 8.986 MB Filas devueltas: 5
    SELECT id, home, template, s.params
    
      FROM grupod3_template_styles as s
      LEFT JOIN grupod3_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
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEeNULLrefelement_clientid,element_folder_clientid,extensionextension82const51.00Using index condition; Using where
    1SIMPLEsNULLrefidx_template,idx_client_id,idx_client_id_homeidx_template202grupod3_grupod3.e.element171.43Using index condition; Using where
    Perfil
    StatusDuration
    starting0.11 ms
    checking permissions0.02 ms
    checking permissions0.01 ms
    Opening tables0.67 ms
    init0.06 ms
    System lock0.02 ms
    optimizing0.03 ms
    statistics0.18 ms
    preparing0.05 ms
    executing0.01 ms
    Sending data0.24 ms
    end0.02 ms
    query end0.02 ms
    closing tables0.03 ms
    freeing items0.06 ms
    cleaning up0.03 ms
    Llamada de pila
    #ComunicadorArchivo y número de línea
    6JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    5JDatabaseDriver->loadObjectList()JROOT/libraries/src/Application/SiteApplication.php:486
    4Joomla\CMS\Application\SiteApplication->getTemplate()JROOT/libraries/src/Application/SiteApplication.php:168
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

  16. Tiempo de la consulta: 1.59 ms Después de la última consulta: 14.12 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 9.551 MB Filas devueltas: 39
    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `grupod3_assets`
      WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_joomgallery','com_joomlaupdate','com_komento','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_socialloginandsocialshare','com_tags','com_templates','com_users','com_weblinks','com_wrapper')
    Explicar
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEgrupod3_assetsNULLrangeidx_asset_nameidx_asset_name202NULL40100.00Using index condition
    Perfil
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.34 ms
    init0.05 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.14 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.53 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Llamada de pila
    #ComunicadorArchivo y número de línea
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    19JDatabaseDriver->loadObjectList()JROOT/libraries/src/Access/Access.php:429
    18Joomla\CMS\Access\Access::preloadComponents()JROOT/libraries/src/Access/Access.php:213
    17Joomla\CMS\Access\Access::preload()JROOT/libraries/src/Access/Access.php:531
    16Joomla\CMS\Access\Access::getAssetRules()JROOT/libraries/src/Access/Access.php:183
    15Joomla\CMS\Access\Access::check()JROOT/libraries/src/User/User.php:398
    14Joomla\CMS\User\User->authorise()JROOT/components/com_content/models/category.php:139
    13ContentModelCategory->populateState()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
    12Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()JROOT/libraries/src/MVC/View/CategoryView.php:116
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

  17. Tiempo de la consulta: 1.04 ms Después de la última consulta: 0.41 ms Consulta a la memoria: 0.056 MB memoria antes de la consulta: 9.603 MB Filas devueltas: 178
    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `grupod3_assets`
      WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0
    Explicar
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEgrupod3_assetsNULLALLidx_asset_name,idx_parent_idNo pudo usarse una clave de índiceNULLNULL51921.60Using where
    Perfil
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.55 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Llamada de pila
    #ComunicadorArchivo y número de línea
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    19JDatabaseDriver->loadObjectList()JROOT/libraries/src/Access/Access.php:359
    18Joomla\CMS\Access\Access::preloadPermissions()JROOT/libraries/src/Access/Access.php:226
    17Joomla\CMS\Access\Access::preload()JROOT/libraries/src/Access/Access.php:540
    16Joomla\CMS\Access\Access::getAssetRules()JROOT/libraries/src/Access/Access.php:183
    15Joomla\CMS\Access\Access::check()JROOT/libraries/src/User/User.php:398
    14Joomla\CMS\User\User->authorise()JROOT/components/com_content/models/category.php:139
    13ContentModelCategory->populateState()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
    12Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()JROOT/libraries/src/MVC/View/CategoryView.php:116
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

  18. Tiempo de la consulta: 1.85 ms Después de la última consulta: 4.30 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 9.845 MB Filas devueltas: 2
    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`)
      FROM `grupod3_content` AS `i`
      WHERE i.`catid` = c.id
      AND i.state = 1) AS numitems
      FROM `grupod3_categories` AS `s`
      INNER JOIN `grupod3_categories` AS `c`
      ON (s.lft <= c.lft
      AND c.lft < s.rgt) OR (c.lft < s.lft
      AND s.rgt < c.rgt)
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.published = 1
      AND s.id = 2
      ORDER BY c.lft
    Explicar
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1PRIMARYsNULLconstPRIMARY,idx_left_rightPRIMARY4const1100.00NULL
    1PRIMARYcNULLrangecat_idx,idx_left_rightidx_left_right4NULL276.74Using index condition; Using where
    2DEPENDENT SUBQUERYiNULLrefidx_state,idx_catididx_catid4grupod3_grupod3.c.id3100.00Using index condition; Using where
    Perfil
    StatusDuration
    starting0.13 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.79 ms
    init0.06 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.12 ms
    preparing0.03 ms
    Sorting result0.01 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.07 ms
    executing0.01 ms
    Sending data0.05 ms
    executing0.01 ms
    Sending data0.07 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.03 ms
    cleaning up0.02 ms
    Llamada de pila
    #ComunicadorArchivo y número de línea
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    16JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:324
    15Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:184
    14Joomla\CMS\Categories\Categories->get()JROOT/components/com_content/models/category.php:355
    13ContentModelCategory->getCategory()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:122
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

  19. Tiempo de la consulta: 6.03 ms Después de la última consulta: 4.22 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 10.013 MB Filas devueltas: 2
    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN 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 grupod3_content AS a
      LEFT JOIN grupod3_categories AS c
      ON c.id = a.catid
      LEFT JOIN grupod3_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN grupod3_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN grupod3_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN grupod3_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 = 2 OR a.catid IN ( SELECT sub.id
      FROM grupod3_categories as sub
      INNER JOIN grupod3_categories as this
      ON sub.lft > this.lft
      AND sub.rgt < this.rgt
      WHERE this.id = 2))
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-05-23 10:52:37')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-05-23 10:52:37')
      ORDER BY c.lft, a.ordering, a.created
    Explicar
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1PRIMARYcNULLALLPRIMARY,idx_accessNo pudo usarse una clave de índiceNULLNULL4310.00Using where; Using temporary; Usando 'filesort'
    1PRIMARYaNULLrefidx_access,idx_state,idx_catididx_catid4grupod3_grupod3.c.id316.00Using index condition; Using where
    1PRIMARYuaNULLALLPRIMARYNo pudo usarse una clave de índiceNULLNULL2100.00Using where; Using join buffer (Block Nested Loop)
    1PRIMARYuamNULLeq_refPRIMARYPRIMARY4grupod3_grupod3.a.modified_by1100.00Using where
    1PRIMARYparentNULLeq_refPRIMARYPRIMARY4grupod3_grupod3.c.parent_id1100.00Using where
    1PRIMARYvNULLALLPRIMARYNo pudo usarse una clave de índiceNULLNULL1100.00Using where; Using join buffer (Block Nested Loop)
    2DEPENDENT SUBQUERYthisNULLconstPRIMARY,idx_left_rightPRIMARY4const1100.00NULL
    2DEPENDENT SUBQUERYsubNULLeq_refPRIMARY,idx_left_rightPRIMARY4func131.78Using where
    Perfil
    StatusDuration
    executing0.01 ms
    Sending data0.02 ms
    executing0.01 ms
    Sending data0.03 ms
    executing0.01 ms
    Sending data0.02 ms
    executing0.01 ms
    Sending data0.02 ms
    executing0.01 ms
    Sending data0.02 ms
    executing0.01 ms
    Sending data0.03 ms
    executing0.01 ms
    Sending data0.02 ms
    executing0.01 ms
    Sending data0.02 ms
    executing0.01 ms
    Sending data0.02 ms
    executing0.01 ms
    Sending data0.04 ms
    executing0.01 ms
    Sending data0.02 ms
    executing0.01 ms
    Sending data0.02 ms
    executing0.01 ms
    Sending data0.02 ms
    executing0.01 ms
    Sending data0.03 ms
    executing0.01 ms
    Sending data0.02 ms
    executing0.01 ms
    Sending data0.02 ms
    executing0.01 ms
    Sending data0.02 ms
    executing0.01 ms
    Sending data0.02 ms
    executing0.01 ms
    Sending data0.02 ms
    executing0.01 ms
    Sending data0.02 ms
    executing0.01 ms
    Sending data0.02 ms
    executing0.01 ms
    Sending data0.02 ms
    executing0.01 ms
    Sending data0.02 ms
    executing0.01 ms
    Sending data0.02 ms
    executing0.01 ms
    Sending data0.02 ms
    executing0.01 ms
    Sending data0.02 ms
    executing0.01 ms
    Sending data0.02 ms
    executing0.01 ms
    Sending data0.02 ms
    executing0.01 ms
    Sending data0.02 ms
    executing0.01 ms
    Sending data0.02 ms
    executing0.01 ms
    Sending data0.02 ms
    executing0.01 ms
    Sending data0.02 ms
    executing0.01 ms
    Sending data0.02 ms
    executing0.01 ms
    Sending data0.02 ms
    executing0.01 ms
    Sending data0.02 ms
    executing0.01 ms
    Sending data0.02 ms
    executing0.01 ms
    Sending data0.02 ms
    executing0.01 ms
    Sending data0.02 ms
    executing0.01 ms
    Sending data0.02 ms
    executing0.01 ms
    Sending data0.02 ms
    executing0.01 ms
    Sending data0.02 ms
    executing0.01 ms
    Sending data0.02 ms
    executing0.01 ms
    Sending data0.03 ms
    executing0.01 ms
    Sending data0.02 ms
    executing0.01 ms
    Sending data0.04 ms
    executing0.01 ms
    Sending data0.32 ms
    Creating sort index0.08 ms
    end0.01 ms
    query end0.01 ms
    removing tmp table0.03 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.04 ms
    cleaning up0.02 ms
    Llamada de pila
    #ComunicadorArchivo y número de línea
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    17JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    16Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:194
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/components/com_content/models/articles.php:576
    14ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:253
    13ContentModelCategory->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:144
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

  20. Tiempo de la consulta: 1.87 ms Después de la última consulta: 3.41 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 10.187 MB Filas devueltas: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `grupod3_contentitem_tag_map` AS m
      INNER JOIN `grupod3_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 148
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explicar
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLALLidx_tag_typeNo pudo usarse una clave de índiceNULLNULL616.67Using where
    1SIMPLEtNULLeq_refPRIMARY,tag_idx,idx_accessPRIMARY4grupod3_grupod3.m.tag_id136.36Using where
    Perfil
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables1.30 ms
    init0.04 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.08 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.06 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.03 ms
    cleaning up0.02 ms
    Llamada de pila
    #ComunicadorArchivo y número de línea
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    16JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    15Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    14ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:253
    13ContentModelCategory->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:144
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

  21. Tiempo de la consulta: 0.64 ms Después de la última consulta: 0.39 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 10.204 MB Filas devueltas: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `grupod3_contentitem_tag_map` AS m
      INNER JOIN `grupod3_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 65
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explicar
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLALLidx_tag_typeNo pudo usarse una clave de índiceNULLNULL616.67Using where
    1SIMPLEtNULLeq_refPRIMARY,tag_idx,idx_accessPRIMARY4grupod3_grupod3.m.tag_id136.36Using where
    Perfil
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.06 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.05 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Llamada de pila
    #ComunicadorArchivo y número de línea
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    16JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    15Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    14ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:253
    13ContentModelCategory->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:144
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

  22. Tiempo de la consulta: 3.25 ms Después de la última consulta: 2.32 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 10.358 MB Filas devueltas: 1
    SELECT COUNT(*)
    
      FROM grupod3_content AS a
      LEFT JOIN grupod3_categories AS c
      ON c.id = a.catid
      LEFT JOIN grupod3_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN grupod3_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN grupod3_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN grupod3_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 = 2 OR a.catid IN ( SELECT sub.id
      FROM grupod3_categories as sub
      INNER JOIN grupod3_categories as this
      ON sub.lft > this.lft
      AND sub.rgt < this.rgt
      WHERE this.id = 2))
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-05-23 10:52:37')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-05-23 10:52:37')
    Explicar
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1PRIMARYcNULLALLPRIMARY,idx_accessNo pudo usarse una clave de índiceNULLNULL4310.00Using where
    1PRIMARYaNULLrefidx_access,idx_state,idx_catididx_catid4grupod3_grupod3.c.id316.00Using index condition; Using where
    1PRIMARYuaNULLeq_refPRIMARYPRIMARY4grupod3_grupod3.a.created_by1100.00Using where; Using index
    1PRIMARYuamNULLeq_refPRIMARYPRIMARY4grupod3_grupod3.a.modified_by1100.00Using where; Using index
    1PRIMARYparentNULLeq_refPRIMARYPRIMARY4grupod3_grupod3.c.parent_id1100.00Using where; Using index
    1PRIMARYvNULLeq_refPRIMARYPRIMARY4grupod3_grupod3.a.id1100.00Using where; Using index
    2DEPENDENT SUBQUERYthisNULLconstPRIMARY,idx_left_rightPRIMARY4const1100.00NULL
    2DEPENDENT SUBQUERYsubNULLeq_refPRIMARY,idx_left_rightPRIMARY4func131.78Using where
    Perfil
    StatusDuration
    Sending data0.08 ms
    executing0.01 ms
    Sending data0.01 ms
    executing0.01 ms
    Sending data0.01 ms
    executing0.01 ms
    Sending data0.03 ms
    executing0.01 ms
    Sending data0.01 ms
    executing0.01 ms
    Sending data0.01 ms
    executing0.01 ms
    Sending data0.01 ms
    executing0.01 ms
    Sending data0.03 ms
    executing0.01 ms
    Sending data0.01 ms
    executing0.01 ms
    Sending data0.01 ms
    executing0.01 ms
    Sending data0.01 ms
    executing0.01 ms
    Sending data0.03 ms
    executing0.01 ms
    Sending data0.01 ms
    executing0.01 ms
    Sending data0.01 ms
    executing0.01 ms
    Sending data0.05 ms
    executing0.01 ms
    Sending data0.01 ms
    executing0.01 ms
    Sending data0.01 ms
    executing0.01 ms
    Sending data0.01 ms
    executing0.01 ms
    Sending data0.01 ms
    executing0.01 ms
    Sending data0.01 ms
    executing0.01 ms
    Sending data0.01 ms
    executing0.01 ms
    Sending data0.01 ms
    executing0.01 ms
    Sending data0.02 ms
    executing0.01 ms
    Sending data0.01 ms
    executing0.01 ms
    Sending data0.04 ms
    executing0.01 ms
    Sending data0.01 ms
    executing0.01 ms
    Sending data0.01 ms
    executing0.01 ms
    Sending data0.01 ms
    executing0.01 ms
    Sending data0.01 ms
    executing0.01 ms
    Sending data0.01 ms
    executing0.01 ms
    Sending data0.01 ms
    executing0.01 ms
    Sending data0.01 ms
    executing0.01 ms
    Sending data0.04 ms
    executing0.01 ms
    Sending data0.01 ms
    executing0.01 ms
    Sending data0.01 ms
    executing0.01 ms
    Sending data0.01 ms
    executing0.01 ms
    Sending data0.01 ms
    executing0.01 ms
    Sending data0.01 ms
    executing0.01 ms
    Sending data0.01 ms
    executing0.01 ms
    Sending data0.02 ms
    executing0.01 ms
    Sending data0.03 ms
    executing0.01 ms
    Sending data0.01 ms
    executing0.01 ms
    Sending data0.01 ms
    executing0.01 ms
    Sending data0.01 ms
    executing0.01 ms
    Sending data0.03 ms
    executing0.01 ms
    Sending data0.01 ms
    executing0.01 ms
    Sending data0.03 ms
    executing0.01 ms
    Sending data0.03 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.02 ms
    Llamada de pila
    #ComunicadorArchivo y número de línea
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    17JDatabaseDriver->loadResult()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354
    16Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()JROOT/libraries/src/MVC/Model/ListModel.php:289
    15Joomla\CMS\MVC\Model\ListModel->getTotal()JROOT/libraries/src/MVC/Model/ListModel.php:239
    14Joomla\CMS\MVC\Model\ListModel->getPagination()JROOT/components/com_content/models/category.php:265
    13ContentModelCategory->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:144
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

  23. Tiempo de la consulta: 0.55 ms Después de la última consulta: 0.36 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 10.360 MB Filas devueltas: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `grupod3_contentitem_tag_map` AS m
      INNER JOIN `grupod3_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.category'
      AND `m`.`content_item_id` = 2
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explicar
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLALLidx_tag_typeNo pudo usarse una clave de índiceNULLNULL616.67Using where
    1SIMPLEtNULLeq_refPRIMARY,tag_idx,idx_accessPRIMARY4grupod3_grupod3.m.tag_id136.36Using where
    Perfil
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.06 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.05 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Llamada de pila
    #ComunicadorArchivo y número de línea
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    13JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    12Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/libraries/src/MVC/View/CategoryView.php:229
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

  24. Tiempo de la consulta: 0.41 ms Después de la última consulta: 2.13 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 10.429 MB Filas devueltas: 10
    Consultas duplicadas: #8  #31
    SELECT * 
      FROM grupod3_loginradius_settings
    Explicar
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEgrupod3_loginradius_settingsNULLALLNULLNo pudo usarse una clave de índiceNULLNULL10100.00NULL
    Perfil
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.05 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.01 ms
    Sending data0.06 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Llamada de pila
    #ComunicadorArchivo y número de línea
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1506
    15JDatabaseDriver->loadAssocList()JROOT/plugins/content/socialshare/socialshare.php:220
    14plgContentSocialShare->sociallogin_getsettings()JROOT/plugins/content/socialshare/socialshare.php:26
    13plgContentSocialShare->__construct()JROOT/libraries/src/Plugin/PluginHelper.php:280
    12Joomla\CMS\Plugin\PluginHelper::import()JROOT/libraries/src/Plugin/PluginHelper.php:182
    11Joomla\CMS\Plugin\PluginHelper::importPlugin()JROOT/components/com_content/views/category/view.html.php:88
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

  25. Tiempo de la consulta: 0.83 ms Después de la última consulta: 9.00 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 10.753 MB Filas devueltas: 2
    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM `grupod3_categories` AS `s`
      INNER JOIN `grupod3_categories` AS `c`
      ON (s.lft <= c.lft
      AND c.lft < s.rgt) OR (c.lft < s.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
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEsNULLconstPRIMARY,idx_left_rightPRIMARY4const1100.00NULL
    1SIMPLEcNULLrangecat_idx,idx_access,idx_left_rightidx_left_right4NULL281.40Using index condition; Using where
    Perfil
    StatusDuration
    starting0.11 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.05 ms
    System lock0.03 ms
    optimizing0.02 ms
    statistics0.15 ms
    preparing0.03 ms
    Sorting result0.01 ms
    executing0.01 ms
    Sending data0.08 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.05 ms
    cleaning up0.02 ms
    Llamada de pila
    #ComunicadorArchivo y número de línea
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    20JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:324
    19Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:184
    18Joomla\CMS\Categories\Categories->get()JROOT/administrator/components/com_fields/models/fields.php:203
    17FieldsModelFields->getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:140
    16Joomla\CMS\MVC\Model\ListModel->_getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:194
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    13PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

  26. Tiempo de la consulta: 2.64 ms Después de la última consulta: 0.27 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 10.769 MB Filas devueltas: 0
    SELECT DISTINCT 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, g.note as group_note
    
      FROM grupod3_fields AS a
      LEFT JOIN `grupod3_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN grupod3_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN grupod3_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN grupod3_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN grupod3_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `grupod3_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 (2,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)
      ORDER BY a.ordering ASC
    Explicar
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLrefidx_state,idx_access,idx_contextidx_state1const1100.00Using index condition; Using where; Using temporary; Usando 'filesort'
    1SIMPLElNULLeq_refidx_langcodeidx_langcode28grupod3_grupod3.a.language1100.00Using where
    1SIMPLEucNULLeq_refPRIMARYPRIMARY4grupod3_grupod3.a.checked_out1100.00NULL
    1SIMPLEagNULLeq_refPRIMARYPRIMARY4grupod3_grupod3.a.access1100.00Using where
    1SIMPLEuaNULLeq_refPRIMARYPRIMARY4grupod3_grupod3.a.created_user_id1100.00Using where
    1SIMPLEgNULLeq_refPRIMARYPRIMARY4grupod3_grupod3.a.group_id1100.00Using where
    1SIMPLEfcNULLrefPRIMARYPRIMARY4grupod3_grupod3.a.id1100.00Using where; Using index; Distinct
    Perfil
    StatusDuration
    starting0.11 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables1.62 ms
    init0.06 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.13 ms
    preparing0.04 ms
    Creating tmp table0.05 ms
    Sorting result0.01 ms
    executing0.01 ms
    Sending data0.17 ms
    Creating sort index0.03 ms
    end0.01 ms
    query end0.01 ms
    removing tmp table0.04 ms
    query end0.01 ms
    closing tables0.03 ms
    freeing items0.03 ms
    cleaning up0.02 ms
    Llamada de pila
    #ComunicadorArchivo y número de línea
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    18JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    17Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    16FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:194
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    13PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

  27. Tiempo de la consulta: 0.54 ms Después de la última consulta: 33.16 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 11.290 MB Filas devueltas: 1
    SELECT *
    
      FROM grupod3_komento_configs
      WHERE `component` = 'com_content'
    Explicar
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEgrupod3_komento_configsNULLALLNULLNo pudo usarse una clave de índiceNULLNULL520.00Using where
    Perfil
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.01 ms
    Sending data0.05 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Llamada de pila
    #ComunicadorArchivo y número de línea
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1465
    18JDatabaseDriver->loadAssoc()JROOT/libraries/src/Table/Table.php:747
    17Joomla\CMS\Table\Table->load()JROOT/components/com_komento/helpers/helper.php:202
    16Komento::getConfig()JROOT/components/com_komento/helpers/helper.php:697
    15Komento::commentify()JROOT/plugins/content/komento/komento.php:148
    14plgContentKomento->execute()JROOT/plugins/content/komento/komento.php:80
    13plgContentKomento->onContentAfterDisplay()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:124
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

  28. Tiempo de la consulta: 0.70 ms Después de la última consulta: 19.91 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 11.341 MB Filas devueltas: 1
    SELECT a.id, a.title, a.alias, a.catid, a.created_by, a.created_by_alias, a.hits, c.title AS category_title, c.alias AS category_alias, u.name AS author, parent.id AS parent_id, parent.alias AS parent_alias 
      FROM `grupod3_content` AS a
      LEFT JOIN `grupod3_categories` AS c
      ON c.id = a.catid
      LEFT JOIN `grupod3_users` AS u
      ON u.id = a.created_by
      LEFT JOIN `grupod3_categories` AS parent
      ON parent.id = c.parent_id
      WHERE a.id = '148'
    Explicar
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLconstPRIMARYPRIMARY4const1100.00NULL
    1SIMPLEcNULLconstPRIMARYPRIMARY4const1100.00NULL
    1SIMPLEuNULLconstPRIMARYPRIMARY4const1100.00NULL
    1SIMPLEparentNULLconstPRIMARYPRIMARY4const1100.00NULL
    Perfil
    StatusDuration
    starting0.08 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.13 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.02 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.04 ms
    cleaning up0.02 ms
    Llamada de pila
    #ComunicadorArchivo y número de línea
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    19JDatabaseDriver->loadObject()JROOT/components/com_komento/helpers/database.php:151
    18KomentoDatabaseJoomla15->__call()JROOT/components/com_komento/helpers/database.php:40
    17KomentoDatabaseHelper->__call()JROOT/components/com_komento/komento_plugins/com_content.php:54
    16KomentoComcontent->load()JROOT/components/com_komento/helpers/helper.php:743
    15Komento::commentify()JROOT/plugins/content/komento/komento.php:148
    14plgContentKomento->execute()JROOT/plugins/content/komento/komento.php:80
    13plgContentKomento->onContentAfterDisplay()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:124
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

  29. Tiempo de la consulta: 3.61 ms Después de la última consulta: 3.11 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 11.458 MB Filas devueltas: 18
    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM grupod3_modules AS m
      LEFT JOIN grupod3_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN grupod3_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 <= '2022-05-23 10:52:37')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-05-23 10:52:37')
      AND m.access IN (1,1,5)
      AND m.client_id = 0
      AND (mm.menuid = 305 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
    Explicar
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLrefPRIMARY,published,newsfeedspublished1const501.52Using index condition; Using where; Usando 'filesort'
    1SIMPLEeNULLrefelement_clientid,element_folder_clientidelement_clientid403grupod3_grupod3.m.module,const110.00Using index condition; Using where
    1SIMPLEmmNULLrefPRIMARYPRIMARY4grupod3_grupod3.m.id140.00Using where; Using index
    Perfil
    StatusDuration
    starting0.08 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables1.13 ms
    init0.08 ms
    System lock0.02 ms
    optimizing0.03 ms
    statistics0.14 ms
    preparing0.05 ms
    Sorting result0.02 ms
    executing0.01 ms
    Sending data0.02 ms
    Creating sort index1.60 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.03 ms
    freeing items0.05 ms
    cleaning up0.02 ms
    Llamada de pila
    #ComunicadorArchivo y número de línea
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    20JDatabaseDriver->loadObjectList()Lo mismo que llamada de la línea de abajo.
    19call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    18Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/ModuleHelper.php:441
    17Joomla\CMS\Helper\ModuleHelper::getModuleList()JROOT/libraries/src/Helper/ModuleHelper.php:371
    16Joomla\CMS\Helper\ModuleHelper::load()JROOT/libraries/src/Helper/ModuleHelper.php:87
    15Joomla\CMS\Helper\ModuleHelper::getModules()JROOT/plugins/content/loadmodule/loadmodule.php:169
    14PlgContentLoadmodule->_load()JROOT/plugins/content/loadmodule/loadmodule.php:81
    13PlgContentLoadmodule->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

  30. Tiempo de la consulta: 0.79 ms Después de la última consulta: 30.61 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 11.662 MB Filas devueltas: 1
    SELECT a.id, a.title, a.alias, a.catid, a.created_by, a.created_by_alias, a.hits, c.title AS category_title, c.alias AS category_alias, u.name AS author, parent.id AS parent_id, parent.alias AS parent_alias 
      FROM `grupod3_content` AS a
      LEFT JOIN `grupod3_categories` AS c
      ON c.id = a.catid
      LEFT JOIN `grupod3_users` AS u
      ON u.id = a.created_by
      LEFT JOIN `grupod3_categories` AS parent
      ON parent.id = c.parent_id
      WHERE a.id = '65'
    Explicar
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLconstPRIMARYPRIMARY4const1100.00NULL
    1SIMPLEcNULLconstPRIMARYPRIMARY4const1100.00NULL
    1SIMPLEuNULLconstPRIMARYPRIMARY4const1100.00NULL
    1SIMPLEparentNULLconstPRIMARYPRIMARY4const1100.00NULL
    Perfil
    StatusDuration
    starting0.11 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.04 ms
    init0.05 ms
    System lock0.02 ms
    optimizing0.02 ms
    statistics0.13 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.03 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.03 ms
    freeing items0.06 ms
    cleaning up0.03 ms
    Llamada de pila
    #ComunicadorArchivo y número de línea
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    19JDatabaseDriver->loadObject()JROOT/components/com_komento/helpers/database.php:151
    18KomentoDatabaseJoomla15->__call()JROOT/components/com_komento/helpers/database.php:40
    17KomentoDatabaseHelper->__call()JROOT/components/com_komento/komento_plugins/com_content.php:54
    16KomentoComcontent->load()JROOT/components/com_komento/helpers/helper.php:743
    15Komento::commentify()JROOT/plugins/content/komento/komento.php:148
    14plgContentKomento->execute()JROOT/plugins/content/komento/komento.php:80
    13plgContentKomento->onContentAfterDisplay()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:124
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

  31. Tiempo de la consulta: 0.68 ms Después de la última consulta: 20.68 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 12.175 MB Filas devueltas: 10
    Consultas duplicadas: #8  #24
    SELECT * 
      FROM grupod3_loginradius_settings
    Explicar
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEgrupod3_loginradius_settingsNULLALLNULLNo pudo usarse una clave de índiceNULLNULL10100.00NULL
    Perfil
    StatusDuration
    starting0.05 ms
    checking permissions0.02 ms
    Opening tables0.03 ms
    init0.03 ms
    System lock0.09 ms
    optimizing0.02 ms
    statistics0.02 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.11 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.05 ms
    cleaning up0.03 ms
    Llamada de pila
    #ComunicadorArchivo y número de línea
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1506
    12JDatabaseDriver->loadAssocList()JROOT/modules/mod_socialloginandsocialshare/helper.php:96
    11modSocialLoginAndSocialShareHelper::sociallogin_getsettings()JROOT/modules/mod_socialloginandsocialshare/mod_socialloginandsocialshare.php:19
    10include JROOT/modules/mod_socialloginandsocialshare/mod_socialloginandsocialshare.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:511
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:803
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:577
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1140
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

  32. Tiempo de la consulta: 2.72 ms Después de la última consulta: 184.81 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 12.871 MB Filas devueltas: 5
    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,( SELECT COUNT(i.`id`)
      FROM `grupod3_content` AS `i`
      WHERE i.`catid` = c.id
      AND i.state = 1) AS numitems
      FROM `grupod3_categories` AS `s`
      INNER JOIN `grupod3_categories` AS `c`
      ON (s.lft <= c.lft
      AND c.lft < s.rgt) OR (c.lft < s.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 = 11
      ORDER BY c.lft
    Explicar
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1PRIMARYsNULLconstPRIMARY,idx_left_rightPRIMARY4const1100.00Usando 'filesort'
    1PRIMARYcNULLALLcat_idx,idx_access,idx_left_rightNo pudo usarse una clave de índiceNULLNULL4320.82Using where
    2DEPENDENT SUBQUERYiNULLrefidx_state,idx_catididx_catid4grupod3_grupod3.c.id3100.00Using index condition; Using where
    Perfil
    StatusDuration
    starting0.28 ms
    checking permissions0.02 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.04 ms
    init0.11 ms
    System lock0.02 ms
    optimizing0.03 ms
    statistics0.23 ms
    preparing0.08 ms
    Sorting result0.02 ms
    optimizing0.02 ms
    statistics0.06 ms
    preparing0.03 ms
    executing0.01 ms
    Sending data0.04 ms
    Creating sort index0.23 ms
    executing0.01 ms
    Sending data0.08 ms
    executing0.01 ms
    Sending data0.27 ms
    executing0.01 ms
    Sending data0.10 ms
    executing0.02 ms
    Sending data0.09 ms
    executing0.01 ms
    Sending data0.05 ms
    end0.02 ms
    query end0.02 ms
    closing tables0.03 ms
    freeing items0.07 ms
    cleaning up0.05 ms
    Llamada de pila
    #ComunicadorArchivo y número de línea
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    18JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:324
    17Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:184
    16Joomla\CMS\Categories\Categories->get()JROOT/components/com_content/models/categories.php:115
    15ContentModelCategories->getItems()JROOT/modules/mod_articles_category/helper.php:142
    14ModArticlesCategoryHelper::getList()Lo mismo que llamada de la línea de abajo.
    13call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/ModuleHelper.php:566
    11Joomla\CMS\Helper\ModuleHelper::moduleCache()JROOT/modules/mod_articles_category/mod_articles_category.php:61
    10include JROOT/modules/mod_articles_category/mod_articles_category.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:511
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:803
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:577
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1140
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

  33. Tiempo de la consulta: 5.72 ms Después de la última consulta: 0.77 ms Consulta a la memoria: 0.237 MB memoria antes de la consulta: 12.902 MB Filas devueltas: 19
    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN 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 grupod3_content AS a
      LEFT JOIN grupod3_categories AS c
      ON c.id = a.catid
      LEFT JOIN grupod3_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN grupod3_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN grupod3_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN grupod3_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 (11,68,69,70)
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-05-23 10:52:37')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-05-23 10:52:37')
      ORDER BY publish_up DESC
    Explicar
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLrefidx_access,idx_state,idx_catididx_state1const1193.20Using index condition; Using where; Usando 'filesort'
    1SIMPLEcNULLeq_refPRIMARY,idx_accessPRIMARY4grupod3_grupod3.a.catid110.00Using where
    1SIMPLEuaNULLeq_refPRIMARYPRIMARY4grupod3_grupod3.a.created_by1100.00Using where
    1SIMPLEuamNULLeq_refPRIMARYPRIMARY4grupod3_grupod3.a.modified_by1100.00Using where
    1SIMPLEparentNULLeq_refPRIMARYPRIMARY4grupod3_grupod3.c.parent_id1100.00Using where
    1SIMPLEvNULLeq_refPRIMARYPRIMARY4grupod3_grupod3.a.id1100.00Using where
    Perfil
    StatusDuration
    starting0.30 ms
    checking permissions0.02 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.05 ms
    init0.15 ms
    System lock0.02 ms
    optimizing0.04 ms
    statistics0.22 ms
    preparing0.06 ms
    Sorting result0.02 ms
    executing0.01 ms
    Sending data0.05 ms
    Creating sort index3.59 ms
    end0.02 ms
    query end0.02 ms
    closing tables0.02 ms
    freeing items0.04 ms
    cleaning up0.03 ms
    Llamada de pila
    #ComunicadorArchivo y número de línea
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    18JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    17Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:194
    16Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/components/com_content/models/articles.php:576
    15ContentModelArticles->getItems()JROOT/modules/mod_articles_category/helper.php:224
    14ModArticlesCategoryHelper::getList()Lo mismo que llamada de la línea de abajo.
    13call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/ModuleHelper.php:566
    11Joomla\CMS\Helper\ModuleHelper::moduleCache()JROOT/modules/mod_articles_category/mod_articles_category.php:61
    10include JROOT/modules/mod_articles_category/mod_articles_category.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:511
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:803
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:577
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1140
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

  34. Tiempo de la consulta: 1.51 ms Después de la última consulta: 4.13 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 13.325 MB Filas devueltas: 5
    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 `grupod3_categories` AS `s`
      INNER JOIN `grupod3_categories` AS `c`
      ON (s.lft <= c.lft
      AND c.lft < s.rgt) OR (c.lft < s.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 = 11
      ORDER BY c.lft
    Explicar
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEsNULLconstPRIMARY,idx_left_rightPRIMARY4const1100.00Usando 'filesort'
    1SIMPLEcNULLALLcat_idx,idx_access,idx_left_rightNo pudo usarse una clave de índiceNULLNULL4320.82Using where
    Perfil
    StatusDuration
    starting0.18 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    init0.08 ms
    System lock0.02 ms
    optimizing0.03 ms
    statistics0.21 ms
    preparing0.04 ms
    Sorting result0.02 ms
    executing0.01 ms
    Sending data0.04 ms
    Creating sort index0.23 ms
    end0.02 ms
    query end0.02 ms
    closing tables0.02 ms
    freeing items0.06 ms
    cleaning up0.03 ms
    Llamada de pila
    #ComunicadorArchivo y número de línea
    28JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    27JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:324
    26Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:184
    25Joomla\CMS\Categories\Categories->get()JROOT/components/com_content/router.php:72
    24ContentRouter->getCategorySegment()Lo mismo que llamada de la línea de abajo.
    23call_user_func_array()JROOT/libraries/src/Component/Router/RouterView.php:120
    22Joomla\CMS\Component\Router\RouterView->getPath()JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    21Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()JROOT/libraries/src/Component/Router/RouterView.php:222
    20Joomla\CMS\Component\Router\RouterView->preprocess()JROOT/libraries/src/Router/SiteRouter.php:676
    19Joomla\CMS\Router\SiteRouter->processBuildRules()JROOT/libraries/src/Router/Router.php:266
    18Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:155
    17Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    16Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    15Joomla\CMS\Router\Route::_()JROOT/modules/mod_articles_category/helper.php:260
    14ModArticlesCategoryHelper::getList()Lo mismo que llamada de la línea de abajo.
    13call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/ModuleHelper.php:566
    11Joomla\CMS\Helper\ModuleHelper::moduleCache()JROOT/modules/mod_articles_category/mod_articles_category.php:61
    10include JROOT/modules/mod_articles_category/mod_articles_category.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:511
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:803
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:577
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1140
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

  35. Tiempo de la consulta: 2.07 ms Después de la última consulta: 401.83 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 13.007 MB Filas devueltas: 2
    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`)
      FROM `grupod3_content` AS `i`
      WHERE i.`catid` = c.id
      AND i.state = 1) AS numitems
      FROM `grupod3_categories` AS `s`
      INNER JOIN `grupod3_categories` AS `c`
      ON (s.lft <= c.lft
      AND c.lft < s.rgt) OR (c.lft < s.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 = 31
      ORDER BY c.lft
    Explicar
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1PRIMARYsNULLconstPRIMARY,idx_left_rightPRIMARY4const1100.00Usando 'filesort'
    1PRIMARYcNULLALLcat_idx,idx_access,idx_left_rightNo pudo usarse una clave de índiceNULLNULL4337.86Using where
    2DEPENDENT SUBQUERYiNULLrefidx_state,idx_catididx_catid4grupod3_grupod3.c.id3100.00Using index condition; Using where
    Perfil
    StatusDuration
    starting0.32 ms
    checking permissions0.02 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.05 ms
    init0.13 ms
    System lock0.03 ms
    optimizing0.04 ms
    statistics0.27 ms
    preparing0.05 ms
    Sorting result0.02 ms
    optimizing0.02 ms
    statistics0.07 ms
    preparing0.04 ms
    executing0.01 ms
    Sending data0.05 ms
    Creating sort index0.22 ms
    executing0.02 ms
    Sending data0.07 ms
    executing0.01 ms
    Sending data0.14 ms
    end0.02 ms
    query end0.02 ms
    closing tables0.02 ms
    freeing items0.07 ms
    cleaning up0.03 ms
    Llamada de pila
    #ComunicadorArchivo y número de línea
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    18JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:324
    17Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:184
    16Joomla\CMS\Categories\Categories->get()JROOT/components/com_content/models/categories.php:115
    15ContentModelCategories->getItems()JROOT/modules/mod_articles_category/helper.php:142
    14ModArticlesCategoryHelper::getList()Lo mismo que llamada de la línea de abajo.
    13call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/ModuleHelper.php:566
    11Joomla\CMS\Helper\ModuleHelper::moduleCache()JROOT/modules/mod_articles_category/mod_articles_category.php:61
    10include JROOT/modules/mod_articles_category/mod_articles_category.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:511
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:803
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:577
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1140
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

  36. Tiempo de la consulta: 2.20 ms Después de la última consulta: 0.60 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 13.012 MB Filas devueltas: 2
    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN 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 grupod3_content AS a
      LEFT JOIN grupod3_categories AS c
      ON c.id = a.catid
      LEFT JOIN grupod3_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN grupod3_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN grupod3_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN grupod3_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 (31)
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-05-23 10:52:37')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-05-23 10:52:37')
      ORDER BY a.ordering ASC
    Explicar
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcNULLconstPRIMARY,idx_accessPRIMARY4const1100.00Usando 'filesort'
    1SIMPLEaNULLrefidx_access,idx_state,idx_catididx_catid4const616.00Using index condition; Using where
    1SIMPLEuaNULLeq_refPRIMARYPRIMARY4grupod3_grupod3.a.created_by1100.00Using where
    1SIMPLEuamNULLeq_refPRIMARYPRIMARY4grupod3_grupod3.a.modified_by1100.00Using where
    1SIMPLEparentNULLconstPRIMARYPRIMARY4const1100.00Using where
    1SIMPLEvNULLeq_refPRIMARYPRIMARY4grupod3_grupod3.a.id1100.00Using where
    Perfil
    StatusDuration
    starting0.38 ms
    checking permissions0.02 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.05 ms
    init0.18 ms
    System lock0.03 ms
    optimizing0.05 ms
    statistics0.24 ms
    preparing0.07 ms
    Sorting result0.02 ms
    executing0.01 ms
    Sending data0.06 ms
    Creating sort index0.33 ms
    end0.02 ms
    query end0.02 ms
    closing tables0.02 ms
    freeing items0.09 ms
    cleaning up0.03 ms
    Llamada de pila
    #ComunicadorArchivo y número de línea
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    18JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    17Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:194
    16Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/components/com_content/models/articles.php:576
    15ContentModelArticles->getItems()JROOT/modules/mod_articles_category/helper.php:224
    14ModArticlesCategoryHelper::getList()Lo mismo que llamada de la línea de abajo.
    13call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/ModuleHelper.php:566
    11Joomla\CMS\Helper\ModuleHelper::moduleCache()JROOT/modules/mod_articles_category/mod_articles_category.php:61
    10include JROOT/modules/mod_articles_category/mod_articles_category.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:511
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:803
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:577
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1140
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

  37. Tiempo de la consulta: 1.62 ms Después de la última consulta: 0.86 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 13.058 MB Filas devueltas: 2
    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM `grupod3_categories` AS `s`
      INNER JOIN `grupod3_categories` AS `c`
      ON (s.lft <= c.lft
      AND c.lft < s.rgt) OR (c.lft < s.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 = 31
      ORDER BY c.lft
    Explicar
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEsNULLconstPRIMARY,idx_left_rightPRIMARY4const1100.00Usando 'filesort'
    1SIMPLEcNULLALLcat_idx,idx_access,idx_left_rightNo pudo usarse una clave de índiceNULLNULL4337.86Using where
    Perfil
    StatusDuration
    starting0.20 ms
    checking permissions0.02 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    init0.10 ms
    System lock0.02 ms
    optimizing0.03 ms
    statistics0.22 ms
    preparing0.04 ms
    Sorting result0.02 ms
    executing0.01 ms
    Sending data0.04 ms
    Creating sort index0.23 ms
    end0.02 ms
    query end0.02 ms
    closing tables0.02 ms
    freeing items0.10 ms
    cleaning up0.03 ms
    Llamada de pila
    #ComunicadorArchivo y número de línea
    28JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    27JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:324
    26Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:184
    25Joomla\CMS\Categories\Categories->get()JROOT/components/com_content/router.php:72
    24ContentRouter->getCategorySegment()Lo mismo que llamada de la línea de abajo.
    23call_user_func_array()JROOT/libraries/src/Component/Router/RouterView.php:120
    22Joomla\CMS\Component\Router\RouterView->getPath()JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    21Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()JROOT/libraries/src/Component/Router/RouterView.php:222
    20Joomla\CMS\Component\Router\RouterView->preprocess()JROOT/libraries/src/Router/SiteRouter.php:676
    19Joomla\CMS\Router\SiteRouter->processBuildRules()JROOT/libraries/src/Router/Router.php:266
    18Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:155
    17Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    16Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    15Joomla\CMS\Router\Route::_()JROOT/modules/mod_articles_category/helper.php:260
    14ModArticlesCategoryHelper::getList()Lo mismo que llamada de la línea de abajo.
    13call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/ModuleHelper.php:566
    11Joomla\CMS\Helper\ModuleHelper::moduleCache()JROOT/modules/mod_articles_category/mod_articles_category.php:61
    10include JROOT/modules/mod_articles_category/mod_articles_category.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:511
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:803
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:577
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1140
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

  38. Tiempo de la consulta: 0.64 ms Después de la última consulta: 11.71 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 13.218 MB Filas devueltas: 1
    SELECT id,parent_id 
      FROM grupod3_menu
      WHERE id = 305
    Explicar
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEgrupod3_menuNULLconstPRIMARYPRIMARY4const1100.00NULL
    Perfil
    StatusDuration
    starting0.07 ms
    checking permissions0.02 ms
    Opening tables0.03 ms
    init0.03 ms
    System lock0.02 ms
    optimizing0.02 ms
    statistics0.07 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.02 ms
    end0.01 ms
    query end0.02 ms
    closing tables0.02 ms
    freeing items0.05 ms
    cleaning up0.03 ms
    Llamada de pila
    #ComunicadorArchivo y número de línea
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    20JDatabaseDriver->loadObject()JROOT/modules/mod_icemegamenu/libs/menucore.php:83
    19IceMenuTree->getCurrentMenuItem()JROOT/modules/mod_icemegamenu/libs/menucore.php:67
    18IceMenuTree->__construct()JROOT/modules/mod_icemegamenu/helper.php:46
    17modIceMegamenuHelper::buildXML()Lo mismo que llamada de la línea de abajo.
    16call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    14Joomla\CMS\Cache\Controller\CallbackController->call()JROOT/modules/mod_icemegamenu/helper.php:116
    13modIceMegamenuHelper->getXML()JROOT/modules/mod_icemegamenu/helper.php:155
    12modIceMegamenuHelper->render()JROOT/templates/theme3313/html/mod_icemegamenu/default.php:23
    11require JROOT/templates/theme3313/html/mod_icemegamenu/default.phpJROOT/modules/mod_icemegamenu/mod_icemegamenu.php:71
    10include JROOT/modules/mod_icemegamenu/mod_icemegamenu.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:511
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:803
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:577
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1140
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

  39. Tiempo de la consulta: 0.63 ms Después de la última consulta: 0.09 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 13.229 MB Filas devueltas: 1
    SELECT id,parent_id 
      FROM grupod3_menu
      WHERE id = 335
    Explicar
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEgrupod3_menuNULLconstPRIMARYPRIMARY4const1100.00NULL
    Perfil
    StatusDuration
    starting0.05 ms
    checking permissions0.02 ms
    Opening tables0.02 ms
    init0.03 ms
    System lock0.02 ms
    optimizing0.02 ms
    statistics0.06 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.02 ms
    end0.01 ms
    query end0.02 ms
    closing tables0.02 ms
    freeing items0.05 ms
    cleaning up0.02 ms
    Llamada de pila
    #ComunicadorArchivo y número de línea
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    20JDatabaseDriver->loadObject()JROOT/modules/mod_icemegamenu/libs/menucore.php:83
    19IceMenuTree->getCurrentMenuItem()JROOT/modules/mod_icemegamenu/libs/menucore.php:67
    18IceMenuTree->__construct()JROOT/modules/mod_icemegamenu/helper.php:46
    17modIceMegamenuHelper::buildXML()Lo mismo que llamada de la línea de abajo.
    16call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    14Joomla\CMS\Cache\Controller\CallbackController->call()JROOT/modules/mod_icemegamenu/helper.php:116
    13modIceMegamenuHelper->getXML()JROOT/modules/mod_icemegamenu/helper.php:155
    12modIceMegamenuHelper->render()JROOT/templates/theme3313/html/mod_icemegamenu/default.php:23
    11require JROOT/templates/theme3313/html/mod_icemegamenu/default.phpJROOT/modules/mod_icemegamenu/mod_icemegamenu.php:71
    10include JROOT/modules/mod_icemegamenu/mod_icemegamenu.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:511
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:803
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:577
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1140
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

  40. Tiempo de la consulta: 0.64 ms Después de la última consulta: 0.08 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 13.239 MB Filas devueltas: 1
    SELECT id,parent_id 
      FROM grupod3_menu
      WHERE id = 1
    Explicar
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEgrupod3_menuNULLconstPRIMARYPRIMARY4const1100.00NULL
    Perfil
    StatusDuration
    starting0.07 ms
    checking permissions0.02 ms
    Opening tables0.03 ms
    init0.03 ms
    System lock0.02 ms
    optimizing0.02 ms
    statistics0.09 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.02 ms
    end0.01 ms
    query end0.02 ms
    closing tables0.02 ms
    freeing items0.06 ms
    cleaning up0.03 ms
    Llamada de pila
    #ComunicadorArchivo y número de línea
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    20JDatabaseDriver->loadObject()JROOT/modules/mod_icemegamenu/libs/menucore.php:83
    19IceMenuTree->getCurrentMenuItem()JROOT/modules/mod_icemegamenu/libs/menucore.php:67
    18IceMenuTree->__construct()JROOT/modules/mod_icemegamenu/helper.php:46
    17modIceMegamenuHelper::buildXML()Lo mismo que llamada de la línea de abajo.
    16call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    14Joomla\CMS\Cache\Controller\CallbackController->call()JROOT/modules/mod_icemegamenu/helper.php:116
    13modIceMegamenuHelper->getXML()JROOT/modules/mod_icemegamenu/helper.php:155
    12modIceMegamenuHelper->render()JROOT/templates/theme3313/html/mod_icemegamenu/default.php:23
    11require JROOT/templates/theme3313/html/mod_icemegamenu/default.phpJROOT/modules/mod_icemegamenu/mod_icemegamenu.php:71
    10include JROOT/modules/mod_icemegamenu/mod_icemegamenu.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:511
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:803
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:577
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1140
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

  41. Tiempo de la consulta: 0.99 ms Después de la última consulta: 8.36 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 13.439 MB Filas devueltas: 1
    SELECT distinct(m.id), title, module, position, content, showtitle, params 
      FROM grupod3_modules AS m
      LEFT JOIN grupod3_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.id in(223)
      AND m.published > 0
      ORDER BY position, ordering
    Explicar
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLconstPRIMARY,publishedPRIMARY4const1100.00Using temporary
    1SIMPLEmmNULLrefPRIMARYPRIMARY4const1100.00Using index; Distinct
    Perfil
    StatusDuration
    starting0.11 ms
    checking permissions0.02 ms
    checking permissions0.01 ms
    Opening tables0.04 ms
    init0.05 ms
    System lock0.02 ms
    optimizing0.03 ms
    statistics0.14 ms
    preparing0.03 ms
    Creating tmp table0.05 ms
    executing0.01 ms
    Sending data0.07 ms
    Removing duplicates0.03 ms
    end0.01 ms
    query end0.02 ms
    removing tmp table0.02 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.06 ms
    cleaning up0.03 ms
    Llamada de pila
    #ComunicadorArchivo y número de línea
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    24JDatabaseDriver->loadObjectList()JROOT/modules/mod_icemegamenu/libs/module_helper.php:174
    23IceModuleHelper->_getModules()JROOT/modules/mod_icemegamenu/libs/module_helper.php:43
    22IceModuleHelper->getContentByModule()JROOT/modules/mod_icemegamenu/libs/menucore.php:168
    21IceMenuTree->_getSubmenuByType()JROOT/modules/mod_icemegamenu/libs/menucore.php:286
    20IceMenuTree->_getLevelXML()JROOT/modules/mod_icemegamenu/libs/menucore.php:461
    19IceMenuTree->_getLevelXML()JROOT/modules/mod_icemegamenu/libs/menucore.php:142
    18IceMenuTree->toXML()JROOT/modules/mod_icemegamenu/helper.php:104
    17modIceMegamenuHelper::buildXML()Lo mismo que llamada de la línea de abajo.
    16call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    14Joomla\CMS\Cache\Controller\CallbackController->call()JROOT/modules/mod_icemegamenu/helper.php:116
    13modIceMegamenuHelper->getXML()JROOT/modules/mod_icemegamenu/helper.php:155
    12modIceMegamenuHelper->render()JROOT/templates/theme3313/html/mod_icemegamenu/default.php:23
    11require JROOT/templates/theme3313/html/mod_icemegamenu/default.phpJROOT/modules/mod_icemegamenu/mod_icemegamenu.php:71
    10include JROOT/modules/mod_icemegamenu/mod_icemegamenu.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:511
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:803
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:577
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1140
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

  42. Tiempo de la consulta: 0.79 ms Después de la última consulta: 2.16 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 13.486 MB Filas devueltas: 0
    SELECT distinct(m.id), title, module, position, content, showtitle, params 
      FROM grupod3_modules AS m
      LEFT JOIN grupod3_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.id in(155)
      AND m.published > 0
      ORDER BY position, ordering
    Explicar
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLENULLNULLNULLNULLNo pudo usarse una clave de índiceNULLNULLNULLNULLImpossible WHERE noticed after reading const tables
    Perfil
    StatusDuration
    starting0.11 ms
    checking permissions0.02 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    init0.05 ms
    System lock0.02 ms
    optimizing0.03 ms
    statistics0.14 ms
    preparing0.02 ms
    executing0.03 ms
    end0.01 ms
    query end0.02 ms
    closing tables0.02 ms
    freeing items0.06 ms
    cleaning up0.03 ms
    Llamada de pila
    #ComunicadorArchivo y número de línea
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    24JDatabaseDriver->loadObjectList()JROOT/modules/mod_icemegamenu/libs/module_helper.php:174
    23IceModuleHelper->_getModules()JROOT/modules/mod_icemegamenu/libs/module_helper.php:43
    22IceModuleHelper->getContentByModule()JROOT/modules/mod_icemegamenu/libs/menucore.php:168
    21IceMenuTree->_getSubmenuByType()JROOT/modules/mod_icemegamenu/libs/menucore.php:286
    20IceMenuTree->_getLevelXML()JROOT/modules/mod_icemegamenu/libs/menucore.php:461
    19IceMenuTree->_getLevelXML()JROOT/modules/mod_icemegamenu/libs/menucore.php:142
    18IceMenuTree->toXML()JROOT/modules/mod_icemegamenu/helper.php:104
    17modIceMegamenuHelper::buildXML()Lo mismo que llamada de la línea de abajo.
    16call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    14Joomla\CMS\Cache\Controller\CallbackController->call()JROOT/modules/mod_icemegamenu/helper.php:116
    13modIceMegamenuHelper->getXML()JROOT/modules/mod_icemegamenu/helper.php:155
    12modIceMegamenuHelper->render()JROOT/templates/theme3313/html/mod_icemegamenu/default.php:23
    11require JROOT/templates/theme3313/html/mod_icemegamenu/default.phpJROOT/modules/mod_icemegamenu/mod_icemegamenu.php:71
    10include JROOT/modules/mod_icemegamenu/mod_icemegamenu.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:511
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:803
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:577
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1140
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

  43. Tiempo de la consulta: 0.82 ms Después de la última consulta: 0.26 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 13.499 MB Filas devueltas: 0
    SELECT distinct(m.id), title, module, position, content, showtitle, params 
      FROM grupod3_modules AS m
      LEFT JOIN grupod3_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.id in(224)
      AND m.published > 0
      ORDER BY position, ordering
    Explicar
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLENULLNULLNULLNULLNo pudo usarse una clave de índiceNULLNULLNULLNULLImpossible WHERE noticed after reading const tables
    Perfil
    StatusDuration
    starting0.11 ms
    checking permissions0.02 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    init0.05 ms
    System lock0.02 ms
    optimizing0.03 ms
    statistics0.13 ms
    preparing0.02 ms
    executing0.03 ms
    end0.01 ms
    query end0.02 ms
    closing tables0.02 ms
    freeing items0.06 ms
    cleaning up0.03 ms
    Llamada de pila
    #ComunicadorArchivo y número de línea
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    24JDatabaseDriver->loadObjectList()JROOT/modules/mod_icemegamenu/libs/module_helper.php:174
    23IceModuleHelper->_getModules()JROOT/modules/mod_icemegamenu/libs/module_helper.php:43
    22IceModuleHelper->getContentByModule()JROOT/modules/mod_icemegamenu/libs/menucore.php:168
    21IceMenuTree->_getSubmenuByType()JROOT/modules/mod_icemegamenu/libs/menucore.php:286
    20IceMenuTree->_getLevelXML()JROOT/modules/mod_icemegamenu/libs/menucore.php:461
    19IceMenuTree->_getLevelXML()JROOT/modules/mod_icemegamenu/libs/menucore.php:142
    18IceMenuTree->toXML()JROOT/modules/mod_icemegamenu/helper.php:104
    17modIceMegamenuHelper::buildXML()Lo mismo que llamada de la línea de abajo.
    16call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    14Joomla\CMS\Cache\Controller\CallbackController->call()JROOT/modules/mod_icemegamenu/helper.php:116
    13modIceMegamenuHelper->getXML()JROOT/modules/mod_icemegamenu/helper.php:155
    12modIceMegamenuHelper->render()JROOT/templates/theme3313/html/mod_icemegamenu/default.php:23
    11require JROOT/templates/theme3313/html/mod_icemegamenu/default.phpJROOT/modules/mod_icemegamenu/mod_icemegamenu.php:71
    10include JROOT/modules/mod_icemegamenu/mod_icemegamenu.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:511
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:803
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:577
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1140
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

  44. Tiempo de la consulta: 0.79 ms Después de la última consulta: 0.26 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 13.510 MB Filas devueltas: 0
    SELECT distinct(m.id), title, module, position, content, showtitle, params 
      FROM grupod3_modules AS m
      LEFT JOIN grupod3_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.id in(225)
      AND m.published > 0
      ORDER BY position, ordering
    Explicar
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLENULLNULLNULLNULLNo pudo usarse una clave de índiceNULLNULLNULLNULLImpossible WHERE noticed after reading const tables
    Perfil
    StatusDuration
    starting0.11 ms
    checking permissions0.02 ms
    checking permissions0.01 ms
    Opening tables0.05 ms
    init0.05 ms
    System lock0.02 ms
    optimizing0.03 ms
    statistics0.14 ms
    preparing0.02 ms
    executing0.03 ms
    end0.01 ms
    query end0.02 ms
    closing tables0.02 ms
    freeing items0.06 ms
    cleaning up0.03 ms
    Llamada de pila
    #ComunicadorArchivo y número de línea
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    24JDatabaseDriver->loadObjectList()JROOT/modules/mod_icemegamenu/libs/module_helper.php:174
    23IceModuleHelper->_getModules()JROOT/modules/mod_icemegamenu/libs/module_helper.php:43
    22IceModuleHelper->getContentByModule()JROOT/modules/mod_icemegamenu/libs/menucore.php:168
    21IceMenuTree->_getSubmenuByType()JROOT/modules/mod_icemegamenu/libs/menucore.php:286
    20IceMenuTree->_getLevelXML()JROOT/modules/mod_icemegamenu/libs/menucore.php:461
    19IceMenuTree->_getLevelXML()JROOT/modules/mod_icemegamenu/libs/menucore.php:142
    18IceMenuTree->toXML()JROOT/modules/mod_icemegamenu/helper.php:104
    17modIceMegamenuHelper::buildXML()Lo mismo que llamada de la línea de abajo.
    16call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    14Joomla\CMS\Cache\Controller\CallbackController->call()JROOT/modules/mod_icemegamenu/helper.php:116
    13modIceMegamenuHelper->getXML()JROOT/modules/mod_icemegamenu/helper.php:155
    12modIceMegamenuHelper->render()JROOT/templates/theme3313/html/mod_icemegamenu/default.php:23
    11require JROOT/templates/theme3313/html/mod_icemegamenu/default.phpJROOT/modules/mod_icemegamenu/mod_icemegamenu.php:71
    10include JROOT/modules/mod_icemegamenu/mod_icemegamenu.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:511
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:803
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:577
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1140
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

  45. Tiempo de la consulta: 1.01 ms Después de la última consulta: 2.01 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 13.526 MB Filas devueltas: 1
    SELECT distinct(m.id), title, module, position, content, showtitle, params 
      FROM grupod3_modules AS m
      LEFT JOIN grupod3_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.id in(195)
      AND m.published > 0
      ORDER BY position, ordering
    Explicar
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLconstPRIMARY,publishedPRIMARY4const1100.00Using temporary
    1SIMPLEmmNULLrefPRIMARYPRIMARY4const1100.00Using index; Distinct
    Perfil
    StatusDuration
    starting0.11 ms
    checking permissions0.02 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    init0.05 ms
    System lock0.02 ms
    optimizing0.03 ms
    statistics0.13 ms
    preparing0.03 ms
    Creating tmp table0.04 ms
    executing0.01 ms
    Sending data0.06 ms
    Removing duplicates0.03 ms
    end0.01 ms
    query end0.02 ms
    removing tmp table0.02 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.06 ms
    cleaning up0.03 ms
    Llamada de pila
    #ComunicadorArchivo y número de línea
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    24JDatabaseDriver->loadObjectList()JROOT/modules/mod_icemegamenu/libs/module_helper.php:174
    23IceModuleHelper->_getModules()JROOT/modules/mod_icemegamenu/libs/module_helper.php:43
    22IceModuleHelper->getContentByModule()JROOT/modules/mod_icemegamenu/libs/menucore.php:168
    21IceMenuTree->_getSubmenuByType()JROOT/modules/mod_icemegamenu/libs/menucore.php:286
    20IceMenuTree->_getLevelXML()JROOT/modules/mod_icemegamenu/libs/menucore.php:461
    19IceMenuTree->_getLevelXML()JROOT/modules/mod_icemegamenu/libs/menucore.php:142
    18IceMenuTree->toXML()JROOT/modules/mod_icemegamenu/helper.php:104
    17modIceMegamenuHelper::buildXML()Lo mismo que llamada de la línea de abajo.
    16call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    14Joomla\CMS\Cache\Controller\CallbackController->call()JROOT/modules/mod_icemegamenu/helper.php:116
    13modIceMegamenuHelper->getXML()JROOT/modules/mod_icemegamenu/helper.php:155
    12modIceMegamenuHelper->render()JROOT/templates/theme3313/html/mod_icemegamenu/default.php:23
    11require JROOT/templates/theme3313/html/mod_icemegamenu/default.phpJROOT/modules/mod_icemegamenu/mod_icemegamenu.php:71
    10include JROOT/modules/mod_icemegamenu/mod_icemegamenu.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:511
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:803
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:577
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1140
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

25 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:
  1. 5 × SELECT distinct(m.id), title, module, position, content, showtitle, params 
      FROM grupod3_modules AS m
      LEFT JOIN grupod3_modules_menu AS mm
      ON mm.moduleid = m.id
  2. 3 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`)
      FROM `grupod3_content` AS `i`
  3. 3 × SELECT id,parent_id 
      FROM grupod3_menu
  4. 3 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM `grupod3_categories` AS `s`
      INNER JOIN `grupod3_categories` AS `c`
      ON (s.lft <= c.lft
      AND c.lft < s.rgt) OR (c.lft < s.lft
      AND s.rgt < c.rgt)
  5. 3 × SELECT `m`.`tag_id`,`t`.* 
      FROM `grupod3_contentitem_tag_map` AS m
      INNER JOIN `grupod3_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
  6. 3 × SELECT * 
      FROM grupod3_loginradius_setting
  7. 3 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN 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 grupod3_content AS a
      LEFT JOIN grupod3_categories AS c
      ON c.id = a.catid
      LEFT JOIN grupod3_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN grupod3_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN grupod3_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN grupod3_content_rating AS v
      ON a.id = v.content_id
  8. 2 × SELECT a.id, a.title, a.alias, a.catid, a.created_by, a.created_by_alias, a.hits, c.title AS category_title, c.alias AS category_alias, u.name AS author, parent.id AS parent_id, parent.alias AS parent_alias 
      FROM `grupod3_content` AS a
      LEFT JOIN `grupod3_categories` AS c
      ON c.id = a.catid
      LEFT JOIN `grupod3_users` AS u
      ON u.id = a.created_by
      LEFT JOIN `grupod3_categories` AS parent
      ON parent.id = c.parent_id
  9. 2 × SELECT `id`,`name`,`rules`,`parent_id` 
      FROM `grupod3_assets`
  10. 2 × SELECT * 
      FROM grupod3_komento_configs
  11. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
      FROM `grupod3_extensions`
  12. 1 × SELECT * 
      FROM grupod3_languages
  13. 1 × SELECT id, home, template, s.params 
      FROM grupod3_template_styles as s
      LEFT JOIN grupod3_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
  14. 1 × SELECT `session_id` 
      FROM `grupod3_session`
  15. 1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
      FROM grupod3_menu AS m
      LEFT JOIN grupod3_extensions AS e
      ON m.component_id = e.extension_id
  16. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
      FROM grupod3_extensions
  17. 1 × SELECT COUNT(*) 
      FROM grupod3_content AS a
      LEFT JOIN grupod3_categories AS c
      ON c.id = a.catid
      LEFT JOIN grupod3_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN grupod3_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN grupod3_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN grupod3_content_rating AS v
      ON a.id = v.content_id
  18. 1 × SELECT b.id 
      FROM grupod3_usergroups AS a
      LEFT JOIN grupod3_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  19. 1 × SELECT DISTINCT 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, g.note as group_note 
      FROM grupod3_fields AS a
      LEFT JOIN `grupod3_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN grupod3_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN grupod3_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN grupod3_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN grupod3_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `grupod3_fields_categories` AS fc
      ON fc.field_id = a.id
  20. 1 × SELECT id, rules 
      FROM `grupod3_viewlevels
  21. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM grupod3_modules AS m
      LEFT JOIN grupod3_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN grupod3_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
  22. 1 × SELECT `data` 
      FROM `grupod3_session`
OTRAS tablas:
  1. 1 × INSERT INTO `grupod3_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES (X'6463633161376166376636623638363837613732323935643631343731653033', 1, 1653303157, 0, '', 0
  2. 1 × SHOW FULL COLUMNS 
      FROM `grupod3_komento_configs
  3. 1 × UPDATE `grupod3_extensions` 
      SET `params` = '{\"mediaversion\":\"f9c8d36b8f6a78e94076007ad7c5b4ff\"}'