El Zenzontle
Toggle Navigation
  • inicio
  • El Zenzontle
    • Editorial
    • Las Armas de La Crítica
    • La Unidad en La Lucha
  • Resistencia
    • Poder Popular
      • Autonomía
      • Autogestión
  • Análisis
  • Multimedia
    • Fotos
    • Videos
    • Audio
  • Archivos
    • Números Anteriores
    • Hemeroteca Digital
  • Contacto
  • Afirmación
    • Identidad
    • Métodos y Estilos
    • Género
    • Sexualidad
  • COMUNERA 67 EN PDF numero de presentación de la voz de la Casa de los pueblos

inicio

El encanto del Che

  • Print
  • Email

Ilka Oliva Corado

30 de octubre de 2017, Estados Unidos.

Estados Unidos es un país con una diversidad de culturas, impresionante. En la parada de un semáforo, esperando cruzar la avenida, puede haber cincuenta personas y todas son de distinto país y todas tienen una historia, un pasado, una raíz. La cantidad de religiones y pensamiento político es también así de variada. En una reunión social, en un restaurante, en un simple supermercado o en el parque se puede encontrar una variedad de culturas e idiomas que es imposible identificar.
 

Details
Category: Cultural
Published: 31 October 2017
Hits: 1810

Read more: El encanto del Che

La misión de Ilka

  • Print
  • Email

Ilka Oliva Corado.

No acostumbro a publicar nada que no sea de mi autoría en mi blog, pero de vez en cuando, dependiendo la importancia hago excepciones, como es el caso de hoy. Y digo importancia no porque este texto se trate de una reseña de mi trabajo, sino por la extraordinaria labor de la estudiante de periodismo que la hizo; que pudo captar la esencia de mis palabras. Es la reseña más original que han realizado de mi trabajo hasta este momento.

Details
Category: Cultural
Published: 16 July 2016
Hits: 1347

Read more: La misión de Ilka

VIDEOS ZENZONTLE (2)

Unpublished
  • Print
  • Email

Details
Written by Atitlan
Category: Saber Convivir
Published: 16 November 2022
Hits: 1071

Boletin 21 Juan de la Cruz, sobreviviente de Tortura

  • Print
  • Email

Centro de Derechos Humanos

Fray Bartolomé de Las Casas, AC.

 

 

 

 

San Cristóbal de Las Casas, Chiapas, México
A 03 de diciembre de 2019

Boletín No. 21

 

Exigimos la libertad de Juan de La Cruz Ruiz

  • Autoridades del gobierno de Chiapas responsables de violaciones a derechos humanos de pueblos originarios.

Details
Category: Derechos Humanos
Published: 12 December 2019
Hits: 1574

Read more: Boletin 21 Juan de la Cruz, sobreviviente de Tortura

No más Violación de Derechos contra los Trabajadores y Trabajadoras de la Economía Informal en Guatemala en medio del COVID -19

  • Print
  • Email

 

Junio 2020. La Red temática Derecho de Protección Social en América Latina y Caribe junto a las 24 organizaciones tanto continentales como regionales que la conforman -siendo la Confederación General de Trabajadores de Guatemala – CGTG una de ellas -  denunciamos los diferentes actos de violencia y discriminación que se están presentando y que atentan contra los derechos humanos y laborales de los trabajadores y trabajadoras en Guatemala. 


 Ante la crisis provocada por el COVID - 19, el Ministerio de Economía de Guatemala a través del gobierno creó el fondo de apoyo para las personas que trabajan en la economía informal, el cual fue anunciado por el presidente Alejandro Giammattei, mencionando que sería uno de los planes para ayudar a los trabajadores y trabajadoras afectadas económicamente.

Details
Category: Análisis
Published: 26 June 2020
Hits: 1374

Read more: No más Violación de Derechos contra los Trabajadores y Trabajadoras de la Economía Informal en...

VIDEOS ZENZONTLE

  • Print
  • Email

Details
Category: Saber Convivir
Published: 16 November 2022
Hits: 4466

¿Hacia dónde va la insurrección anti-racista en EEUU?

  • Print
  • Email

William I. Robinson

A más de dos semanas de la explosión de protesta anti-racista en Estados Unidos, los manifestantes no dan tregua y los grupos dominantes han sido momentáneamente puestos a la defensa, asustados por la magnitud del levantamiento, la primera resistencia de gran escala contra el estado policiaco global en el país mas rico y poderoso en el mundo.  Sin embargo, si el movimiento no profundice el análisis de las causas subyacentes del racismo y por ende, dirigir las protestas más directamente contra dichas causas, será difícil que el levantamiento resista una contraofensiva desde arriba que buscará desarticularlo mediante una combinación de represión, reformas menores y cooptación,

Details
Category: Análisis
Published: 23 June 2020
Hits: 1254

Read more: ¿Hacia dónde va la insurrección anti-racista en EEUU?

  1. Ignacio Ramonet : El mundo de hace unos meses, desapareció
  2. ¿Se puede ser marxista hoy?
  3. La oportunidad en las crisis: Israel, Palestina y la comunidad internacional
  4. Boletín de Prensa Aniversario de la Masacre de El Charco

Page 5 of 7

  • 1
  • 2
  • 3
  • ...
  • 5
  • 6
  • 7
  • You are here:  
  • Home

Back to Top

© 2025 El Zenzontle

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 2,
            "timer": {
                "start": 1746771990,
                "last": 1746771990,
                "now": 1746771991
            },
            "token": "HT7Bn69Y4Fi9xisR20bhmGmeSF352jC2"
        },
        "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
        },
        "com_mailto": {
            "formtime": 1746771990,
            "links": {
                "dadd86a7fa751fdbef35a15dcc571475dfb5a723": {
                    "link": "https:\/\/elzenzontle.org\/index.php\/mresistencia-zenzo\/22-cultural\/1137-el-encanto-del-che",
                    "expiry": 1746771991
                },
                "d89f4841b0e62455cafcd99b50bda31ff189df5f": {
                    "link": "https:\/\/elzenzontle.org\/index.php\/mresistencia-zenzo\/22-cultural\/956-la-mision-de-ilka",
                    "expiry": 1746771991
                },
                "de6c2a945e2e40a26439a0764511add3d17d270c": {
                    "link": "https:\/\/elzenzontle.org\/index.php\/32-educacion\/saber-convivir\/1909-videos-zenzontle-2",
                    "expiry": 1746771991
                },
                "58d1e0bc8116e2552a4784d28b7a6d34103536a7": {
                    "link": "https:\/\/elzenzontle.org\/index.php\/mresistencia-zenzo\/23-derechos-humanos\/1340-boletin-21-juan-de-la-cruz-sobreviviente-de-tortura",
                    "expiry": 1746771991
                },
                "94d3978c26129e6d5a280998b5236112af390411": {
                    "link": "https:\/\/elzenzontle.org\/index.php\/manalisis-zenzo\/1517-no-mas-violacion-de-derechos-contra-los-trabajadores-y-trabajadoras-de-la-economia-informal-en-guatemala-en-medio-del-covid-19",
                    "expiry": 1746771991
                },
                "35088c4c6c51be399b3afb86b415aeaa54d00776": {
                    "link": "https:\/\/elzenzontle.org\/index.php\/comunera-67-en-pdf-numero-de-presentacion-de-la-voz-de-la-casa-de-los-pueblos",
                    "expiry": 1746771991
                },
                "2a7eb341cdbd243367651a31c44274f2f2db9805": {
                    "link": "https:\/\/elzenzontle.org\/index.php\/manalisis-zenzo\/1515-hacia-donde-va-la-insurreccion-anti-racista-en-eeuu",
                    "expiry": 1746771991
                }
            }
        }
    }
}

Profile Information

Time

Memory

Time: 12.71 ms / 12.71 ms Memory: 0.522 MB / 0.86 MB Application: afterLoad
Time: 240.90 ms / 253.61 ms Memory: 3.084 MB / 3.94 MB Application: afterInitialise
Time: 65.81 ms / 319.42 ms Memory: 0.663 MB / 4.61 MB Application: afterRoute
Time: 12.41 ms / 331.83 ms Memory: 0.271 MB / 4.88 MB Application: beforeRenderComponent com_content
Time: 22.51 ms / 354.33 ms Memory: 0.549 MB / 5.43 MB Application: Before JAccess::preloadComponents (all components)
Time: 0.98 ms / 355.31 ms Memory: 0.061 MB / 5.49 MB Application: After JAccess::preloadComponents (all components)
Time: 0.06 ms / 355.37 ms Memory: 0.000 MB / 5.48 MB Application: Before JAccess::getAssetRules (id:8 name:com_content)
Time: 0.90 ms / 356.27 ms Memory: 0.024 MB / 5.51 MB Application: After JAccess::getAssetRules (id:8 name:com_content)
Time: 78.40 ms / 434.66 ms Memory: 1.272 MB / 6.78 MB Application: Before JAccess::getAssetRules (id:1 name:root.1)
Time: 0.07 ms / 434.74 ms Memory: 0.007 MB / 6.79 MB Application: After JAccess::getAssetRules (id:1 name:root.1)
Time: 93.83 ms / 528.57 ms Memory: 1.959 MB / 8.75 MB Application: afterRenderComponent com_content
Time: 0.55 ms / 529.12 ms Memory: 0.005 MB / 8.75 MB Application: afterDispatch
Time: 7.67 ms / 536.79 ms Memory: 0.126 MB / 8.88 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 2.67 ms / 539.45 ms Memory: 0.061 MB / 8.94 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 0.19 ms / 539.64 ms Memory: 0.000 MB / 8.94 MB Application: beforeRenderModule mod_menu (Menu Principal)
Time: 11.44 ms / 551.08 ms Memory: 0.185 MB / 9.12 MB Application: afterRenderModule mod_menu (Menu Principal)
Time: 3.22 ms / 554.30 ms Memory: 0.124 MB / 9.25 MB Application: afterRender

Database queries total: 72.71 ms

Memory Usage

9.78 MB (10,260,304 Bytes)

Database Queries

34 Queries Logged 72.71 ms


  1. Query Time: 2.32 ms Query memory: 0.003 MB Memory before query: 2.459 MB
    DELETE 
    
      FROM `jos_session`
      WHERE `time` < '1746771091'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEjos_sessionrangetimetime4NULL4100.00Using where
    Profile
    StatusDuration
    Starting0.25 ms
    checking permissions0.02 ms
    Opening tables0.04 ms
    After opening tables0.02 ms
    System lock0.01 ms
    table lock0.01 ms
    init for update0.10 ms
    Updating0.28 ms
    End of update loop0.02 ms
    Waiting for query cache lock0.01 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit1.23 ms
    Query end0.02 ms
    closing tables0.03 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    Query end0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.09 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    6JDatabaseDriverMysqli->execute()JROOT/libraries/cms/application/cms.php:818
    5JApplicationCms->loadSession()JROOT/libraries/cms/application/cms.php:131
    4JApplicationCms->__construct()JROOT/libraries/cms/application/site.php:63
    3JApplicationSite->__construct()JROOT/libraries/cms/application/cms.php:412
    2JApplicationCms::getInstance()JROOT/libraries/joomla/factory.php:125
    1JFactory::getApplication()JROOT/index.php:46
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  2. Query Time: 0.91 ms After last query: 0.46 ms Query memory: 0.007 MB Memory before query: 2.475 MB Rows returned: 1
    SELECT `data`
    
      FROM `jos_session`
      WHERE `session_id` = '717d887839c2edc30e53b1bcf00d3c6c'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEjos_sessionconstPRIMARYPRIMARY194const1100.00
    Profile
    StatusDuration
    Starting0.10 ms
    Waiting for query cache lock0.01 ms
    starting0.01 ms
    Checking query cache for query0.05 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    Waiting for query cache lock0.08 ms
    init0.03 ms
    Optimizing0.02 ms
    Statistics0.05 ms
    Preparing0.01 ms
    Unlocking tables0.01 ms
    Preparing0.02 ms
    Executing0.01 ms
    Sending data0.02 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.08 ms
    Updating status0.01 ms
    Waiting for query cache lock0.01 ms
    Updating status0.02 ms
    Waiting for query cache lock0.01 ms
    Updating status0.01 ms
    Storing result in query cache0.13 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1720
    15JDatabaseDriver->loadResult()JROOT/libraries/joomla/session/storage/database.php:45
    14JSessionStorageDatabase->read()Same as call in the line below.
    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:82
    10JSessionHandlerJoomla->start()JROOT/libraries/joomla/session/session.php:648
    9JSession->_start()JROOT/libraries/joomla/session/session.php:608
    8JSession->start()JROOT/libraries/joomla/session/session.php:486
    7JSession->get()JROOT/libraries/joomla/session/session.php:443
    6JSession->isNew()JROOT/libraries/cms/application/cms.php:825
    5JApplicationCms->loadSession()JROOT/libraries/cms/application/cms.php:131
    4JApplicationCms->__construct()JROOT/libraries/cms/application/site.php:63
    3JApplicationSite->__construct()JROOT/libraries/cms/application/cms.php:412
    2JApplicationCms::getInstance()JROOT/libraries/joomla/factory.php:125
    1JFactory::getApplication()JROOT/index.php:46
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  3. Query Time: 1.24 ms After last query: 49.82 ms Query memory: 0.005 MB Memory before query: 2.720 MB Rows returned: 38
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `jos_extensions`
      WHERE `type` = 'component'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEjos_extensionsrefextensionextension82const38100.00Using index condition
    Profile
    StatusDuration
    Starting0.14 ms
    Waiting for query cache lock0.01 ms
    starting0.01 ms
    Checking query cache for query0.08 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    Waiting for query cache lock0.03 ms
    init0.04 ms
    Optimizing0.02 ms
    Statistics0.09 ms
    Preparing0.04 ms
    Executing0.01 ms
    Sending data0.36 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.08 ms
    Updating status0.01 ms
    Waiting for query cache lock0.01 ms
    Updating status0.02 ms
    Waiting for query cache lock0.01 ms
    Updating status0.01 ms
    Storing result in query cache0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    9JDatabaseDriver->loadObjectList()JROOT/libraries/cms/component/helper.php:452
    8JComponentHelper::{closure}()JROOT/libraries/joomla/cache/controller/callback.php:169
    7JCacheControllerCallback->get()JROOT/libraries/cms/component/helper.php:460
    6JComponentHelper::load()JROOT/libraries/cms/component/helper.php:43
    5JComponentHelper::getComponent()JROOT/libraries/cms/component/helper.php:111
    4JComponentHelper::getParams()JROOT/libraries/cms/application/site.php:593
    3JApplicationSite->initialiseApp()JROOT/libraries/cms/application/site.php:209
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  4. Query Time: 0.44 ms After last query: 4.19 ms Query memory: 0.005 MB Memory before query: 2.960 MB Rows returned: 3
    SELECT b.id
    
      FROM jos_usergroups AS a
      LEFT JOIN jos_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.id = 7
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaconstPRIMARYPRIMARY4const1100.00
    1SIMPLEbrangeidx_usergroup_nested_set_lookupidx_usergroup_nested_set_lookup4NULL4100.00Using where; Using index
    Profile
    StatusDuration
    Starting0.20 ms
    Waiting for query cache lock0.01 ms
    starting0.01 ms
    Checking query cache for query0.01 ms
    checking privileges on cached 0.01 ms
    checking permissions0.01 ms
    Sending cached result to clien0.07 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1530
    10JDatabaseDriver->loadColumn()JROOT/libraries/joomla/access/access.php:978
    9JAccess::getGroupsByUser()JROOT/libraries/joomla/access/access.php:1047
    8JAccess::getAuthorisedViewLevels()JROOT/libraries/joomla/user/user.php:453
    7JUser->getAuthorisedViewLevels()JROOT/libraries/cms/plugin/helper.php:293
    6JPluginHelper::load()JROOT/libraries/cms/plugin/helper.php:86
    5JPluginHelper::getPlugin()JROOT/libraries/cms/plugin/helper.php:128
    4JPluginHelper::isEnabled()JROOT/libraries/cms/application/site.php:603
    3JApplicationSite->initialiseApp()JROOT/libraries/cms/application/site.php:209
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  5. Query Time: 0.28 ms After last query: 1.04 ms Query memory: 0.005 MB Memory before query: 3.005 MB Rows returned: 5
    SELECT id, rules
    
      FROM `jos_viewlevels`
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEjos_viewlevelsALLNULLNO INDEX KEY COULD BE USEDNULLNULL5100.00
    Profile
    StatusDuration
    Starting0.09 ms
    Waiting for query cache lock0.01 ms
    starting0.01 ms
    Checking query cache for query0.01 ms
    checking privileges on cached 0.01 ms
    checking permissions0.01 ms
    Sending cached result to clien0.07 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1486
    9JDatabaseDriver->loadAssocList()JROOT/libraries/joomla/access/access.php:1064
    8JAccess::getAuthorisedViewLevels()JROOT/libraries/joomla/user/user.php:453
    7JUser->getAuthorisedViewLevels()JROOT/libraries/cms/plugin/helper.php:293
    6JPluginHelper::load()JROOT/libraries/cms/plugin/helper.php:86
    5JPluginHelper::getPlugin()JROOT/libraries/cms/plugin/helper.php:128
    4JPluginHelper::isEnabled()JROOT/libraries/cms/application/site.php:603
    3JApplicationSite->initialiseApp()JROOT/libraries/cms/application/site.php:209
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  6. Query Time: 2.55 ms After last query: 0.20 ms Query memory: 0.005 MB Memory before query: 3.032 MB Rows returned: 91
    SELECT `folder` AS `type`,`element` AS `name`,`params`
    
      FROM jos_extensions
      WHERE enabled = 1
      AND type = 'plugin'
      AND state IN (0,1)
      AND access IN (1,1,2,3,6)
      ORDER BY ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEjos_extensionsALLextensionNO INDEX KEY COULD BE USEDNULLNULL24550.61Using where; Using filesort
    Profile
    StatusDuration
    Starting0.08 ms
    Waiting for query cache lock0.01 ms
    starting0.01 ms
    Checking query cache for query0.13 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    Waiting for query cache lock0.02 ms
    init0.05 ms
    Optimizing0.04 ms
    Statistics0.08 ms
    Preparing0.03 ms
    Sorting result0.01 ms
    Executing0.01 ms
    Sending data0.01 ms
    Creating sort index0.51 ms
    Waiting for query cache lock0.01 ms
    Creating sort index0.05 ms
    Waiting for query cache lock0.01 ms
    Creating sort index0.53 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.09 ms
    Updating status0.01 ms
    Waiting for query cache lock0.01 ms
    Updating status0.59 ms
    Waiting for query cache lock0.01 ms
    Updating status0.01 ms
    Storing result in query cache0.02 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    9JDatabaseDriver->loadObjectList()JROOT/libraries/cms/plugin/helper.php:311
    8JPluginHelper::{closure}()JROOT/libraries/joomla/cache/controller/callback.php:169
    7JCacheControllerCallback->get()JROOT/libraries/cms/plugin/helper.php:316
    6JPluginHelper::load()JROOT/libraries/cms/plugin/helper.php:86
    5JPluginHelper::getPlugin()JROOT/libraries/cms/plugin/helper.php:128
    4JPluginHelper::isEnabled()JROOT/libraries/cms/application/site.php:603
    3JApplicationSite->initialiseApp()JROOT/libraries/cms/application/site.php:209
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  7. Query Time: 3.52 ms After last query: 29.46 ms Query memory: 0.008 MB Memory before query: 4.169 MB Rows returned: 24
    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 jos_menu AS m
      LEFT JOIN jos_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
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmrefidx_client_id_parent_id_alias_languageidx_client_id_parent_id_alias_language1const5157.95Using index condition; Using where; Using filesort
    1SIMPLEeeq_refPRIMARYPRIMARY4elzenzo_2.m.component_id1100.00Using where
    Profile
    StatusDuration
    Starting0.28 ms
    Waiting for query cache lock0.02 ms
    starting0.01 ms
    Checking query cache for query0.24 ms
    checking permissions0.02 ms
    Opening tables0.07 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.02 ms
    Waiting for query cache lock0.05 ms
    init0.10 ms
    Optimizing0.07 ms
    Statistics0.15 ms
    Preparing0.16 ms
    Sorting result0.04 ms
    Executing0.01 ms
    Sending data0.04 ms
    Creating sort index1.22 ms
    Waiting for query cache lock0.03 ms
    Creating sort index0.30 ms
    End of update loop0.03 ms
    Query end0.01 ms
    Commit0.02 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.04 ms
    Query end0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.22 ms
    Updating status0.03 ms
    Waiting for query cache lock0.01 ms
    Updating status0.06 ms
    Waiting for query cache lock0.02 ms
    Updating status0.01 ms
    Storing result in query cache0.03 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    17JDatabaseDriver->loadObjectList()JROOT/libraries/cms/menu/site.php:88
    16JMenuSite->{closure}()JROOT/libraries/joomla/cache/controller/callback.php:169
    15JCacheControllerCallback->get()JROOT/libraries/cms/menu/site.php:96
    14JMenuSite->load()JROOT/libraries/cms/menu/menu.php:74
    13JMenu->__construct()JROOT/libraries/cms/menu/site.php:57
    12JMenuSite->__construct()JROOT/libraries/cms/menu/menu.php:129
    11JMenu::getInstance()JROOT/libraries/cms/application/cms.php:443
    10JApplicationCms->getMenu()JROOT/libraries/cms/application/site.php:272
    9JApplicationSite->getMenu()JROOT/libraries/cms/router/site.php:59
    8JRouterSite->__construct()JROOT/libraries/cms/router/router.php:198
    7JRouter::getInstance()JROOT/libraries/cms/application/cms.php:548
    6JApplicationCms::getRouter()JROOT/libraries/cms/application/site.php:402
    5JApplicationSite::getRouter()JROOT/libraries/cms/application/cms.php:1141
    4JApplicationCms->route()JROOT/libraries/cms/application/site.php:795
    3JApplicationSite->route()JROOT/libraries/cms/application/site.php:215
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  8. Query Time: 1.85 ms After last query: 59.09 ms Query memory: 0.006 MB Memory before query: 4.640 MB Rows returned: 1
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `jos_extensions`
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEjos_extensionsrefelement_clientid,element_folder_clientid,extensionextension484const,const1100.00Using index condition
    Profile
    StatusDuration
    Starting0.24 ms
    Waiting for query cache lock0.02 ms
    starting0.01 ms
    Checking query cache for query0.13 ms
    checking permissions0.03 ms
    Opening tables0.10 ms
    After opening tables0.03 ms
    System lock0.02 ms
    table lock0.02 ms
    Waiting for query cache lock0.04 ms
    init0.08 ms
    Optimizing0.06 ms
    Statistics0.20 ms
    Preparing0.07 ms
    Executing0.02 ms
    Sending data0.12 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.02 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.03 ms
    Query end0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.24 ms
    Updating status0.03 ms
    Waiting for query cache lock0.01 ms
    Updating status0.04 ms
    Waiting for query cache lock0.01 ms
    Updating status0.01 ms
    Storing result in query cache0.03 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1642
    13JDatabaseDriver->loadObject()JROOT/libraries/cms/library/helper.php:166
    12JLibraryHelper::{closure}()JROOT/libraries/joomla/cache/controller/callback.php:169
    11JCacheControllerCallback->get()JROOT/libraries/cms/library/helper.php:174
    10JLibraryHelper::loadLibrary()JROOT/libraries/cms/library/helper.php:42
    9JLibraryHelper::getLibrary()JROOT/libraries/cms/library/helper.php:89
    8JLibraryHelper::getParams()JROOT/libraries/cms/version/version.php:270
    7JVersion->getMediaVersion()JROOT/libraries/joomla/factory.php:755
    6JFactory::createDocument()JROOT/libraries/joomla/factory.php:216
    5JFactory::getDocument()JROOT/libraries/joomla/application/web.php:1022
    4JApplicationWeb->loadDocument()JROOT/libraries/cms/application/site.php:130
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  9. Query Time: 1.24 ms After last query: 0.38 ms Query memory: 0.005 MB Memory before query: 4.632 MB
    UPDATE `jos_extensions`
    
      SET `params` = '{\"mediaversion\":\"a111eb0f7dc76a011b5d39ab3c1efc2b\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEjos_extensionsrangeelement_clientid,element_folder_clientid,extensionextension484NULL1100.00Using where
    Profile
    StatusDuration
    Starting0.35 ms
    checking permissions0.03 ms
    Opening tables0.04 ms
    After opening tables0.02 ms
    System lock0.01 ms
    table lock0.02 ms
    init for update0.18 ms
    Updating0.10 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.03 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    Query end0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.15 ms
    Updating status0.05 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/cms/library/helper.php:116
    9JLibraryHelper::saveParams()JROOT/libraries/cms/version/version.php:321
    8JVersion->setMediaVersion()JROOT/libraries/cms/version/version.php:280
    7JVersion->getMediaVersion()JROOT/libraries/joomla/factory.php:755
    6JFactory::createDocument()JROOT/libraries/joomla/factory.php:216
    5JFactory::getDocument()JROOT/libraries/joomla/application/web.php:1022
    4JApplicationWeb->loadDocument()JROOT/libraries/cms/application/site.php:130
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  10. Query Time: 0.66 ms After last query: 5.61 ms Query memory: 0.003 MB Memory before query: 4.857 MB Rows returned: 1
    SELECT *
    
      FROM jos_languages
      WHERE published=1
      ORDER BY ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEjos_languagesALLNULLNO INDEX KEY COULD BE USEDNULLNULL2100.00Using where; Using filesort
    Profile
    StatusDuration
    Starting0.22 ms
    Waiting for query cache lock0.02 ms
    starting0.01 ms
    Checking query cache for query0.02 ms
    checking privileges on cached 0.01 ms
    checking permissions0.02 ms
    Sending cached result to clien0.23 ms
    Updating status0.03 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    7JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    6JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/language/helper.php:148
    5JLanguageHelper::getLanguages()JROOT/libraries/cms/application/site.php:327
    4JApplicationSite->getParams()JROOT/libraries/cms/application/site.php:135
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  11. Query Time: 0.39 ms After last query: 0.57 ms Query memory: 0.003 MB Memory before query: 4.871 MB Rows returned: 3
    SELECT id, home, template, s.params
    
      FROM jos_template_styles as s
      LEFT JOIN jos_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
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEsrefidx_template,idx_client_id,idx_client_id_homeidx_client_id1const3100.00
    1SIMPLEerefelement_clientid,element_folder_clientid,extensionelement_clientid403elzenzo_2.s.template,const12.45Using index condition; Using where
    Profile
    StatusDuration
    Starting0.13 ms
    Waiting for query cache lock0.01 ms
    starting0.01 ms
    Checking query cache for query0.02 ms
    checking privileges on cached 0.01 ms
    checking permissions0.02 ms
    Sending cached result to clien0.17 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    6JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    5JDatabaseDriver->loadObjectList()JROOT/libraries/cms/application/site.php:485
    4JApplicationSite->getTemplate()JROOT/libraries/cms/application/site.php:165
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  12. Query Time: 0.46 ms After last query: 23.51 ms Query memory: 0.010 MB Memory before query: 5.431 MB Rows returned: 37
    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `jos_assets`
      WHERE `name` IN ('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_jce','com_jckman','com_joomlaupdate','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_tags','com_templates','com_users','com_weblinks','com_wrapper') OR `parent_id` = 0
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEjos_assetsindex_mergeidx_asset_name,idx_parent_ididx_asset_name,idx_parent_id202,4NULL38100.00Using sort_union(idx_asset_name,idx_parent_id); Using where
    Profile
    StatusDuration
    Starting0.15 ms
    Waiting for query cache lock0.01 ms
    starting0.01 ms
    Checking query cache for query0.01 ms
    checking privileges on cached 0.04 ms
    checking permissions0.01 ms
    Sending cached result to clien0.10 ms
    Updating status0.04 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    20JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/access/access.php:427
    19JAccess::preloadComponents()JROOT/libraries/joomla/access/access.php:211
    18JAccess::preload()JROOT/libraries/joomla/access/access.php:529
    17JAccess::getAssetRules()JROOT/libraries/joomla/access/access.php:181
    16JAccess::check()JROOT/libraries/joomla/user/user.php:393
    15JUser->authorise()JROOT/components/com_content/models/articles.php:113
    14ContentModelArticles->populateState()JROOT/components/com_content/models/featured.php:42
    13ContentModelFeatured->populateState()JROOT/libraries/legacy/model/legacy.php:434
    12JModelLegacy->getState()JROOT/libraries/legacy/view/legacy.php:422
    11JViewLegacy->get()JROOT/components/com_content/views/featured/view.html.php:54
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:671
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:394
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:369
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  13. Query Time: 7.44 ms After last query: 2.65 ms Query memory: 0.008 MB Memory before query: 5.619 MB Rows returned: 11
    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,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,
      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 jos_content AS a
      LEFT JOIN jos_categories AS c
      ON c.id = a.catid
      LEFT JOIN jos_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN jos_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN jos_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN jos_content_rating AS v
      ON a.id = v.content_id
      WHERE a.featured = 1
      AND a.access IN (1,1,2,3,6)
      AND c.access IN (1,1,2,3,6)
      AND c.published = 1
      AND a.state IN (0,1,2)
      ORDER BY c.lft,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created DESC
      LIMIT 30, 11
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEarefidx_access,idx_state,idx_catid,idx_featured_catididx_featured_catid1const13067.76Using where; Using temporary; Using filesort
    1SIMPLEceq_refPRIMARY,idx_accessPRIMARY4elzenzo_2.a.catid1100.00Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4elzenzo_2.a.created_by1100.00Using where
    1SIMPLEuameq_refPRIMARYPRIMARY4elzenzo_2.a.modified_by1100.00Using where
    1SIMPLEparenteq_refPRIMARYPRIMARY4elzenzo_2.c.parent_id1100.00Using where
    1SIMPLEveq_refPRIMARYPRIMARY4elzenzo_2.a.id1100.00Using where
    Profile
    StatusDuration
    Starting0.15 ms
    Waiting for query cache lock0.01 ms
    starting0.01 ms
    Checking query cache for query0.30 ms
    checking permissions0.02 ms
    Opening tables0.08 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    Waiting for query cache lock0.05 ms
    init0.14 ms
    Optimizing0.06 ms
    Statistics0.21 ms
    Preparing0.10 ms
    Creating tmp table0.13 ms
    Sorting result0.02 ms
    Executing0.01 ms
    Sending data3.61 ms
    Creating sort index1.07 ms
    Waiting for query cache lock0.02 ms
    Creating sort index0.07 ms
    Waiting for query cache lock0.01 ms
    Creating sort index0.20 ms
    Waiting for query cache lock0.02 ms
    Creating sort index0.06 ms
    Waiting for query cache lock0.01 ms
    Creating sort index0.22 ms
    Waiting for query cache lock0.01 ms
    Creating sort index0.06 ms
    Waiting for query cache lock0.01 ms
    Creating sort index0.05 ms
    Removing tmp table0.14 ms
    Creating sort index0.02 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.03 ms
    Query end0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.11 ms
    Updating status0.01 ms
    Waiting for query cache lock0.03 ms
    Updating status0.03 ms
    Waiting for query cache lock0.01 ms
    Updating status0.01 ms
    Storing result in query cache0.01 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    16JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/model/legacy.php:307
    15JModelLegacy->_getList()JROOT/libraries/legacy/model/list.php:186
    14JModelList->getItems()JROOT/components/com_content/models/articles.php:536
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:100
    12ContentModelFeatured->getItems()JROOT/libraries/legacy/view/legacy.php:422
    11JViewLegacy->get()JROOT/components/com_content/views/featured/view.html.php:55
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:671
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:394
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:369
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  14. Query Time: 0.36 ms After last query: 7.30 ms Query memory: 0.007 MB Memory before query: 6.027 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `jos_contentitem_tag_map` AS m
      INNER JOIN `jos_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 1137
      AND `t`.`published` = 1
      AND t.access IN (1,1,2,3,6)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL22100.00Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4elzenzo_2.m.tag_id1100.00Using where
    Profile
    StatusDuration
    Starting0.14 ms
    Waiting for query cache lock0.01 ms
    starting0.01 ms
    Checking query cache for query0.01 ms
    checking privileges on cached 0.01 ms
    checking permissions0.02 ms
    Sending cached result to clien0.07 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    15JDatabaseDriver->loadObjectList()JROOT/libraries/cms/helper/tags.php:450
    14JHelperTags->getItemTags()JROOT/components/com_content/models/articles.php:662
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:100
    12ContentModelFeatured->getItems()JROOT/libraries/legacy/view/legacy.php:422
    11JViewLegacy->get()JROOT/components/com_content/views/featured/view.html.php:55
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:671
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:394
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:369
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  15. Query Time: 0.25 ms After last query: 0.49 ms Query memory: 0.007 MB Memory before query: 6.049 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `jos_contentitem_tag_map` AS m
      INNER JOIN `jos_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 956
      AND `t`.`published` = 1
      AND t.access IN (1,1,2,3,6)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL22100.00Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4elzenzo_2.m.tag_id1100.00Using where
    Profile
    StatusDuration
    Starting0.08 ms
    Waiting for query cache lock0.01 ms
    starting0.01 ms
    Checking query cache for query0.01 ms
    checking privileges on cached 0.01 ms
    checking permissions0.01 ms
    Sending cached result to clien0.06 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    15JDatabaseDriver->loadObjectList()JROOT/libraries/cms/helper/tags.php:450
    14JHelperTags->getItemTags()JROOT/components/com_content/models/articles.php:662
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:100
    12ContentModelFeatured->getItems()JROOT/libraries/legacy/view/legacy.php:422
    11JViewLegacy->get()JROOT/components/com_content/views/featured/view.html.php:55
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:671
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:394
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:369
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  16. Query Time: 1.01 ms After last query: 0.36 ms Query memory: 0.007 MB Memory before query: 6.071 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `jos_contentitem_tag_map` AS m
      INNER JOIN `jos_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 1340
      AND `t`.`published` = 1
      AND t.access IN (1,1,2,3,6)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL22100.00Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4elzenzo_2.m.tag_id1100.00Using where
    Profile
    StatusDuration
    Starting0.11 ms
    Waiting for query cache lock0.01 ms
    starting0.01 ms
    Checking query cache for query0.11 ms
    checking permissions0.01 ms
    Opening tables0.04 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    Waiting for query cache lock0.03 ms
    init0.07 ms
    Optimizing0.05 ms
    Statistics0.13 ms
    Preparing0.04 ms
    Executing0.01 ms
    Sending data0.07 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.08 ms
    Updating status0.01 ms
    Waiting for query cache lock0.01 ms
    Updating status0.02 ms
    Waiting for query cache lock0.01 ms
    Updating status0.01 ms
    Storing result in query cache0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    15JDatabaseDriver->loadObjectList()JROOT/libraries/cms/helper/tags.php:450
    14JHelperTags->getItemTags()JROOT/components/com_content/models/articles.php:662
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:100
    12ContentModelFeatured->getItems()JROOT/libraries/legacy/view/legacy.php:422
    11JViewLegacy->get()JROOT/components/com_content/views/featured/view.html.php:55
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:671
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:394
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:369
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  17. Query Time: 0.25 ms After last query: 0.43 ms Query memory: 0.008 MB Memory before query: 6.094 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `jos_contentitem_tag_map` AS m
      INNER JOIN `jos_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 1894
      AND `t`.`published` = 1
      AND t.access IN (1,1,2,3,6)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL22100.00Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4elzenzo_2.m.tag_id1100.00Using where
    Profile
    StatusDuration
    Starting0.07 ms
    Waiting for query cache lock0.01 ms
    starting0.01 ms
    Checking query cache for query0.01 ms
    checking privileges on cached 0.01 ms
    checking permissions0.01 ms
    Sending cached result to clien0.07 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    15JDatabaseDriver->loadObjectList()JROOT/libraries/cms/helper/tags.php:450
    14JHelperTags->getItemTags()JROOT/components/com_content/models/articles.php:662
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:100
    12ContentModelFeatured->getItems()JROOT/libraries/legacy/view/legacy.php:422
    11JViewLegacy->get()JROOT/components/com_content/views/featured/view.html.php:55
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:671
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:394
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:369
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  18. Query Time: 38.19 ms After last query: 0.35 ms Query memory: 0.007 MB Memory before query: 6.117 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `jos_contentitem_tag_map` AS m
      INNER JOIN `jos_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 1909
      AND `t`.`published` = 1
      AND t.access IN (1,1,2,3,6)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL22100.00Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4elzenzo_2.m.tag_id1100.00Using where
    Profile
    StatusDuration
    Starting0.11 ms
    Waiting for query cache lock0.01 ms
    starting0.01 ms
    Checking query cache for query0.01 ms
    checking privileges on cached 0.01 ms
    checking permissions0.01 ms
    Sending cached result to clien0.07 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    15JDatabaseDriver->loadObjectList()JROOT/libraries/cms/helper/tags.php:450
    14JHelperTags->getItemTags()JROOT/components/com_content/models/articles.php:662
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:100
    12ContentModelFeatured->getItems()JROOT/libraries/legacy/view/legacy.php:422
    11JViewLegacy->get()JROOT/components/com_content/views/featured/view.html.php:55
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:671
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:394
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:369
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  19. Query Time: 0.48 ms After last query: 0.50 ms Query memory: 0.007 MB Memory before query: 6.139 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `jos_contentitem_tag_map` AS m
      INNER JOIN `jos_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 1517
      AND `t`.`published` = 1
      AND t.access IN (1,1,2,3,6)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL22100.00Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4elzenzo_2.m.tag_id1100.00Using where
    Profile
    StatusDuration
    Starting0.17 ms
    Waiting for query cache lock0.02 ms
    starting0.01 ms
    Checking query cache for query0.01 ms
    checking privileges on cached 0.01 ms
    checking permissions0.06 ms
    Sending cached result to clien0.12 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    15JDatabaseDriver->loadObjectList()JROOT/libraries/cms/helper/tags.php:450
    14JHelperTags->getItemTags()JROOT/components/com_content/models/articles.php:662
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:100
    12ContentModelFeatured->getItems()JROOT/libraries/legacy/view/legacy.php:422
    11JViewLegacy->get()JROOT/components/com_content/views/featured/view.html.php:55
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:671
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:394
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:369
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  20. Query Time: 0.29 ms After last query: 0.37 ms Query memory: 0.007 MB Memory before query: 6.161 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `jos_contentitem_tag_map` AS m
      INNER JOIN `jos_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 1515
      AND `t`.`published` = 1
      AND t.access IN (1,1,2,3,6)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL22100.00Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4elzenzo_2.m.tag_id1100.00Using where
    Profile
    StatusDuration
    Starting0.10 ms
    Waiting for query cache lock0.01 ms
    starting0.01 ms
    Checking query cache for query0.01 ms
    checking privileges on cached 0.01 ms
    checking permissions0.01 ms
    Sending cached result to clien0.10 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    15JDatabaseDriver->loadObjectList()JROOT/libraries/cms/helper/tags.php:450
    14JHelperTags->getItemTags()JROOT/components/com_content/models/articles.php:662
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:100
    12ContentModelFeatured->getItems()JROOT/libraries/legacy/view/legacy.php:422
    11JViewLegacy->get()JROOT/components/com_content/views/featured/view.html.php:55
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:671
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:394
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:369
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  21. Query Time: 0.30 ms After last query: 0.42 ms Query memory: 0.007 MB Memory before query: 6.183 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `jos_contentitem_tag_map` AS m
      INNER JOIN `jos_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 1514
      AND `t`.`published` = 1
      AND t.access IN (1,1,2,3,6)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL22100.00Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4elzenzo_2.m.tag_id1100.00Using where
    Profile
    StatusDuration
    Starting0.10 ms
    Waiting for query cache lock0.01 ms
    starting0.01 ms
    Checking query cache for query0.01 ms
    checking privileges on cached 0.01 ms
    checking permissions0.01 ms
    Sending cached result to clien0.10 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    15JDatabaseDriver->loadObjectList()JROOT/libraries/cms/helper/tags.php:450
    14JHelperTags->getItemTags()JROOT/components/com_content/models/articles.php:662
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:100
    12ContentModelFeatured->getItems()JROOT/libraries/legacy/view/legacy.php:422
    11JViewLegacy->get()JROOT/components/com_content/views/featured/view.html.php:55
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:671
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:394
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:369
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  22. Query Time: 0.32 ms After last query: 0.35 ms Query memory: 0.007 MB Memory before query: 6.204 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `jos_contentitem_tag_map` AS m
      INNER JOIN `jos_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 1490
      AND `t`.`published` = 1
      AND t.access IN (1,1,2,3,6)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL22100.00Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4elzenzo_2.m.tag_id1100.00Using where
    Profile
    StatusDuration
    Starting0.14 ms
    Waiting for query cache lock0.01 ms
    starting0.01 ms
    Checking query cache for query0.01 ms
    checking privileges on cached 0.01 ms
    checking permissions0.01 ms
    Sending cached result to clien0.10 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    15JDatabaseDriver->loadObjectList()JROOT/libraries/cms/helper/tags.php:450
    14JHelperTags->getItemTags()JROOT/components/com_content/models/articles.php:662
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:100
    12ContentModelFeatured->getItems()JROOT/libraries/legacy/view/legacy.php:422
    11JViewLegacy->get()JROOT/components/com_content/views/featured/view.html.php:55
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:671
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:394
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:369
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  23. Query Time: 0.33 ms After last query: 0.33 ms Query memory: 0.007 MB Memory before query: 6.226 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `jos_contentitem_tag_map` AS m
      INNER JOIN `jos_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 1489
      AND `t`.`published` = 1
      AND t.access IN (1,1,2,3,6)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL22100.00Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4elzenzo_2.m.tag_id1100.00Using where
    Profile
    StatusDuration
    Starting0.10 ms
    Waiting for query cache lock0.01 ms
    starting0.01 ms
    Checking query cache for query0.01 ms
    checking privileges on cached 0.01 ms
    checking permissions0.01 ms
    Sending cached result to clien0.09 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    15JDatabaseDriver->loadObjectList()JROOT/libraries/cms/helper/tags.php:450
    14JHelperTags->getItemTags()JROOT/components/com_content/models/articles.php:662
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:100
    12ContentModelFeatured->getItems()JROOT/libraries/legacy/view/legacy.php:422
    11JViewLegacy->get()JROOT/components/com_content/views/featured/view.html.php:55
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:671
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:394
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:369
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  24. Query Time: 0.31 ms After last query: 0.42 ms Query memory: 0.007 MB Memory before query: 6.248 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `jos_contentitem_tag_map` AS m
      INNER JOIN `jos_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 1488
      AND `t`.`published` = 1
      AND t.access IN (1,1,2,3,6)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL22100.00Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4elzenzo_2.m.tag_id1100.00Using where
    Profile
    StatusDuration
    Starting0.11 ms
    Waiting for query cache lock0.02 ms
    starting0.01 ms
    Checking query cache for query0.01 ms
    checking privileges on cached 0.01 ms
    checking permissions0.01 ms
    Sending cached result to clien0.10 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    15JDatabaseDriver->loadObjectList()JROOT/libraries/cms/helper/tags.php:450
    14JHelperTags->getItemTags()JROOT/components/com_content/models/articles.php:662
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:100
    12ContentModelFeatured->getItems()JROOT/libraries/legacy/view/legacy.php:422
    11JViewLegacy->get()JROOT/components/com_content/views/featured/view.html.php:55
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:671
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:394
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:369
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  25. Query Time: 2.75 ms After last query: 2.34 ms Query memory: 0.007 MB Memory before query: 6.316 MB Rows returned: 1
    SELECT COUNT(*)
    
      FROM jos_content AS a
      LEFT JOIN jos_categories AS c
      ON c.id = a.catid
      LEFT JOIN jos_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN jos_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN jos_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN jos_content_rating AS v
      ON a.id = v.content_id
      WHERE a.featured = 1
      AND a.access IN (1,1,2,3,6)
      AND c.access IN (1,1,2,3,6)
      AND c.published = 1
      AND a.state IN (0,1,2)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEarefidx_access,idx_state,idx_catid,idx_featured_catididx_featured_catid1const13067.76Using where
    1SIMPLEceq_refPRIMARY,idx_accessPRIMARY4elzenzo_2.a.catid1100.00Using where
    Profile
    StatusDuration
    Starting0.15 ms
    Waiting for query cache lock0.02 ms
    starting0.01 ms
    Checking query cache for query0.20 ms
    checking permissions0.02 ms
    Opening tables0.11 ms
    After opening tables0.02 ms
    System lock0.01 ms
    table lock0.01 ms
    Waiting for query cache lock0.04 ms
    init0.10 ms
    Optimizing0.09 ms
    Statistics0.34 ms
    Preparing0.02 ms
    Unlocking tables0.01 ms
    Preparing0.06 ms
    Executing0.01 ms
    Sending data1.11 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    Query end0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.12 ms
    Updating status0.01 ms
    Waiting for query cache lock0.01 ms
    Updating status0.02 ms
    Waiting for query cache lock0.01 ms
    Updating status0.01 ms
    Storing result in query cache0.02 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1720
    15JDatabaseDriver->loadResult()JROOT/libraries/legacy/model/legacy.php:334
    14JModelLegacy->_getListCount()JROOT/libraries/legacy/model/list.php:281
    13JModelList->getTotal()JROOT/libraries/legacy/model/list.php:231
    12JModelList->getPagination()JROOT/libraries/legacy/view/legacy.php:422
    11JViewLegacy->get()JROOT/components/com_content/views/featured/view.html.php:56
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:671
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:394
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:369
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  26. Query Time: 0.33 ms After last query: 10.44 ms Query memory: 0.010 MB Memory before query: 6.756 MB Rows returned: 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 jos_categories as c
      LEFT JOIN jos_categories AS s
      ON (s.lft <= c.lft
      AND s.rgt >= c.rgt) OR (s.lft > c.lft
      AND s.rgt < c.rgt)
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1,2,3,6)
      AND c.published = 1
      AND s.id=22
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
      ORDER BY c.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEsconstPRIMARY,idx_left_rightPRIMARY4const1100.00
    1SIMPLEcALLcat_idx,idx_access,idx_left_rightNO INDEX KEY COULD BE USEDNULLNULL5190.20Using where; Using filesort
    Profile
    StatusDuration
    Starting0.13 ms
    Waiting for query cache lock0.01 ms
    starting0.01 ms
    Checking query cache for query0.02 ms
    checking privileges on cached 0.01 ms
    checking permissions0.01 ms
    Sending cached result to clien0.07 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    20JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/categories/categories.php:301
    19JCategories->_load()JROOT/libraries/legacy/categories/categories.php:182
    18JCategories->get()JROOT/administrator/components/com_fields/models/fields.php:197
    17FieldsModelFields->getListQuery()JROOT/libraries/legacy/model/list.php:132
    16JModelList->_getListQuery()JROOT/libraries/legacy/model/list.php:186
    15JModelList->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:134
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:378
    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/featured/view.html.php:98
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:671
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:394
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:369
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  27. Query Time: 0.25 ms After last query: 0.35 ms Query memory: 0.009 MB Memory before query: 6.786 MB Rows returned: 0
    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
    
      FROM jos_fields AS a
      LEFT JOIN `jos_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN jos_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN jos_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN jos_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN jos_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `jos_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 (22,0,20))
      AND a.access IN (1,1,2,3,6)
      AND (a.group_id = 0 OR g.access IN (1,1,2,3,6))
      AND a.state = 1
      AND (a.group_id = 0 OR g.state = 1)
      GROUP BY a.id, l.title, l.image, uc.name, ag.title, ua.name, g.title, g.access, g.state
      ORDER BY a.ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEarefidx_state,idx_access,idx_contextidx_state1const1100.00Using where; Using temporary; Using filesort
    1SIMPLEleq_refidx_langcodeidx_langcode28elzenzo_2.a.language1100.00Using where
    1SIMPLEuceq_refPRIMARYPRIMARY4elzenzo_2.a.checked_out1100.00
    1SIMPLEageq_refPRIMARYPRIMARY4elzenzo_2.a.access1100.00Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4elzenzo_2.a.created_user_id1100.00Using where
    1SIMPLEgeq_refPRIMARYPRIMARY4elzenzo_2.a.group_id1100.00Using where
    1SIMPLEfcrefPRIMARYPRIMARY4elzenzo_2.a.id1100.00Using where; Using index
    Profile
    StatusDuration
    Starting0.07 ms
    Waiting for query cache lock0.01 ms
    starting0.01 ms
    Checking query cache for query0.02 ms
    checking privileges on cached 0.01 ms
    checking permissions0.01 ms
    Sending cached result to clien0.10 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    18JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/model/legacy.php:307
    17JModelLegacy->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    16FieldsModelFields->_getList()JROOT/libraries/legacy/model/list.php:186
    15JModelList->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:134
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:378
    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/featured/view.html.php:98
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:671
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:394
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:369
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  28. Query Time: 0.31 ms After last query: 6.06 ms Query memory: 0.010 MB Memory before query: 7.119 MB Rows returned: 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 jos_categories as c
      LEFT JOIN jos_categories AS s
      ON (s.lft <= c.lft
      AND s.rgt >= c.rgt) OR (s.lft > c.lft
      AND s.rgt < c.rgt)
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1,2,3,6)
      AND c.published = 1
      AND s.id=23
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
      ORDER BY c.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEsconstPRIMARY,idx_left_rightPRIMARY4const1100.00
    1SIMPLEcALLcat_idx,idx_access,idx_left_rightNO INDEX KEY COULD BE USEDNULLNULL5190.20Using where; Using filesort
    Profile
    StatusDuration
    Starting0.13 ms
    Waiting for query cache lock0.01 ms
    starting0.01 ms
    Checking query cache for query0.02 ms
    checking privileges on cached 0.01 ms
    checking permissions0.01 ms
    Sending cached result to clien0.07 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    20JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/categories/categories.php:301
    19JCategories->_load()JROOT/libraries/legacy/categories/categories.php:182
    18JCategories->get()JROOT/administrator/components/com_fields/models/fields.php:197
    17FieldsModelFields->getListQuery()JROOT/libraries/legacy/model/list.php:132
    16JModelList->_getListQuery()JROOT/libraries/legacy/model/list.php:186
    15JModelList->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:134
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:378
    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/featured/view.html.php:98
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:671
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:394
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:369
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  29. Query Time: 0.24 ms After last query: 0.22 ms Query memory: 0.009 MB Memory before query: 7.125 MB Rows returned: 0
    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
    
      FROM jos_fields AS a
      LEFT JOIN `jos_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN jos_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN jos_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN jos_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN jos_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `jos_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 (23,0,20))
      AND a.access IN (1,1,2,3,6)
      AND (a.group_id = 0 OR g.access IN (1,1,2,3,6))
      AND a.state = 1
      AND (a.group_id = 0 OR g.state = 1)
      GROUP BY a.id, l.title, l.image, uc.name, ag.title, ua.name, g.title, g.access, g.state
      ORDER BY a.ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEarefidx_state,idx_access,idx_contextidx_state1const1100.00Using where; Using temporary; Using filesort
    1SIMPLEleq_refidx_langcodeidx_langcode28elzenzo_2.a.language1100.00Using where
    1SIMPLEuceq_refPRIMARYPRIMARY4elzenzo_2.a.checked_out1100.00
    1SIMPLEageq_refPRIMARYPRIMARY4elzenzo_2.a.access1100.00Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4elzenzo_2.a.created_user_id1100.00Using where
    1SIMPLEgeq_refPRIMARYPRIMARY4elzenzo_2.a.group_id1100.00Using where
    1SIMPLEfcrefPRIMARYPRIMARY4elzenzo_2.a.id1100.00Using where; Using index
    Profile
    StatusDuration
    Starting0.08 ms
    Waiting for query cache lock0.01 ms
    starting0.01 ms
    Checking query cache for query0.01 ms
    checking privileges on cached 0.01 ms
    checking permissions0.01 ms
    Sending cached result to clien0.08 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    18JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/model/legacy.php:307
    17JModelLegacy->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    16FieldsModelFields->_getList()JROOT/libraries/legacy/model/list.php:186
    15JModelList->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:134
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:378
    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/featured/view.html.php:98
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:671
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:394
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:369
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  30. Query Time: 0.24 ms After last query: 0.58 ms Query memory: 0.010 MB Memory before query: 7.145 MB Rows returned: 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 jos_categories as c
      LEFT JOIN jos_categories AS s
      ON (s.lft <= c.lft
      AND s.rgt >= c.rgt) OR (s.lft > c.lft
      AND s.rgt < c.rgt)
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1,2,3,6)
      AND c.published = 1
      AND s.id=32
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
      ORDER BY c.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEsconstPRIMARY,idx_left_rightPRIMARY4const1100.00
    1SIMPLEcALLcat_idx,idx_access,idx_left_rightNO INDEX KEY COULD BE USEDNULLNULL5190.20Using where; Using filesort
    Profile
    StatusDuration
    Starting0.08 ms
    Waiting for query cache lock0.01 ms
    starting0.01 ms
    Checking query cache for query0.01 ms
    checking privileges on cached 0.01 ms
    checking permissions0.01 ms
    Sending cached result to clien0.07 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    20JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/categories/categories.php:301
    19JCategories->_load()JROOT/libraries/legacy/categories/categories.php:182
    18JCategories->get()JROOT/administrator/components/com_fields/models/fields.php:197
    17FieldsModelFields->getListQuery()JROOT/libraries/legacy/model/list.php:132
    16JModelList->_getListQuery()JROOT/libraries/legacy/model/list.php:186
    15JModelList->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:134
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:378
    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/featured/view.html.php:98
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:671
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:394
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:369
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  31. Query Time: 0.25 ms After last query: 0.23 ms Query memory: 0.009 MB Memory before query: 7.156 MB Rows returned: 0
    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
    
      FROM jos_fields AS a
      LEFT JOIN `jos_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN jos_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN jos_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN jos_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN jos_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `jos_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 (32,0,29))
      AND a.access IN (1,1,2,3,6)
      AND (a.group_id = 0 OR g.access IN (1,1,2,3,6))
      AND a.state = 1
      AND (a.group_id = 0 OR g.state = 1)
      GROUP BY a.id, l.title, l.image, uc.name, ag.title, ua.name, g.title, g.access, g.state
      ORDER BY a.ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEarefidx_state,idx_access,idx_contextidx_state1const1100.00Using where; Using temporary; Using filesort
    1SIMPLEleq_refidx_langcodeidx_langcode28elzenzo_2.a.language1100.00Using where
    1SIMPLEuceq_refPRIMARYPRIMARY4elzenzo_2.a.checked_out1100.00
    1SIMPLEageq_refPRIMARYPRIMARY4elzenzo_2.a.access1100.00Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4elzenzo_2.a.created_user_id1100.00Using where
    1SIMPLEgeq_refPRIMARYPRIMARY4elzenzo_2.a.group_id1100.00Using where
    1SIMPLEfcrefPRIMARYPRIMARY4elzenzo_2.a.id1100.00Using where; Using index
    Profile
    StatusDuration
    Starting0.10 ms
    Waiting for query cache lock0.01 ms
    starting0.01 ms
    Checking query cache for query0.01 ms
    checking privileges on cached 0.01 ms
    checking permissions0.01 ms
    Sending cached result to clien0.07 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    18JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/model/legacy.php:307
    17JModelLegacy->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    16FieldsModelFields->_getList()JROOT/libraries/legacy/model/list.php:186
    15JModelList->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:134
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:378
    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/featured/view.html.php:98
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:671
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:394
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:369
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  32. Query Time: 0.34 ms After last query: 0.76 ms Query memory: 0.010 MB Memory before query: 7.177 MB Rows returned: 2
    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM jos_categories as c
      LEFT JOIN jos_categories AS s
      ON (s.lft <= c.lft
      AND s.rgt >= c.rgt) OR (s.lft > c.lft
      AND s.rgt < c.rgt)
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1,2,3,6)
      AND c.published = 1
      AND s.id=34
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
      ORDER BY c.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEsconstPRIMARY,idx_left_rightPRIMARY4const1100.00
    1SIMPLEcALLcat_idx,idx_access,idx_left_rightNO INDEX KEY COULD BE USEDNULLNULL5190.20Using where; Using filesort
    Profile
    StatusDuration
    Starting0.13 ms
    Waiting for query cache lock0.01 ms
    starting0.01 ms
    Checking query cache for query0.01 ms
    checking privileges on cached 0.01 ms
    checking permissions0.01 ms
    Sending cached result to clien0.07 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    20JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/categories/categories.php:301
    19JCategories->_load()JROOT/libraries/legacy/categories/categories.php:182
    18JCategories->get()JROOT/administrator/components/com_fields/models/fields.php:197
    17FieldsModelFields->getListQuery()JROOT/libraries/legacy/model/list.php:132
    16JModelList->_getListQuery()JROOT/libraries/legacy/model/list.php:186
    15JModelList->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:134
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:378
    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/featured/view.html.php:98
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:671
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:394
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:369
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  33. Query Time: 0.23 ms After last query: 0.20 ms Query memory: 0.010 MB Memory before query: 7.189 MB Rows returned: 0
    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
    
      FROM jos_fields AS a
      LEFT JOIN `jos_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN jos_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN jos_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN jos_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN jos_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `jos_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 (34,0))
      AND a.access IN (1,1,2,3,6)
      AND (a.group_id = 0 OR g.access IN (1,1,2,3,6))
      AND a.state = 1
      AND (a.group_id = 0 OR g.state = 1)
      GROUP BY a.id, l.title, l.image, uc.name, ag.title, ua.name, g.title, g.access, g.state
      ORDER BY a.ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEarefidx_state,idx_access,idx_contextidx_state1const1100.00Using where; Using temporary; Using filesort
    1SIMPLEleq_refidx_langcodeidx_langcode28elzenzo_2.a.language1100.00Using where
    1SIMPLEuceq_refPRIMARYPRIMARY4elzenzo_2.a.checked_out1100.00
    1SIMPLEageq_refPRIMARYPRIMARY4elzenzo_2.a.access1100.00Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4elzenzo_2.a.created_user_id1100.00Using where
    1SIMPLEgeq_refPRIMARYPRIMARY4elzenzo_2.a.group_id1100.00Using where
    1SIMPLEfcrefPRIMARYPRIMARY4elzenzo_2.a.id1100.00Using where; Using index
    Profile
    StatusDuration
    Starting0.07 ms
    Waiting for query cache lock0.01 ms
    starting0.01 ms
    Checking query cache for query0.01 ms
    checking privileges on cached 0.01 ms
    checking permissions0.01 ms
    Sending cached result to clien0.07 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    18JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/model/legacy.php:307
    17JModelLegacy->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    16FieldsModelFields->_getList()JROOT/libraries/legacy/model/list.php:186
    15JModelList->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:134
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:378
    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/featured/view.html.php:98
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:671
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:394
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:369
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  34. Query Time: 2.37 ms After last query: 87.60 ms Query memory: 0.007 MB Memory before query: 8.887 MB Rows returned: 2
    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM jos_modules AS m
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN jos_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 <= '2025-05-09 06:26:31')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-05-09 06:26:31')
      AND m.access IN (1,1,2,3,6)
      AND m.client_id = 0
      AND (mm.menuid = 101 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmmindexPRIMARYPRIMARY8NULL22100.00Using where; Using index; Using temporary; Using filesort
    1SIMPLEmeq_refPRIMARY,published,newsfeedsPRIMARY4elzenzo_2.mm.moduleid183.33Using where
    1SIMPLEerefelement_clientid,element_folder_clientidelement_clientid403elzenzo_2.m.module,const1100.00Using index condition; Using where
    Profile
    StatusDuration
    Starting0.16 ms
    Waiting for query cache lock0.01 ms
    starting0.01 ms
    Checking query cache for query0.17 ms
    checking permissions0.01 ms
    Opening tables0.05 ms
    After opening tables0.09 ms
    System lock0.01 ms
    table lock0.01 ms
    Waiting for query cache lock0.03 ms
    init0.15 ms
    Optimizing0.08 ms
    Statistics0.20 ms
    Preparing0.08 ms
    Creating tmp table0.05 ms
    Sorting result0.02 ms
    Executing0.01 ms
    Sending data0.68 ms
    Creating sort index0.08 ms
    Removing tmp table0.08 ms
    Creating sort index0.02 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    Query end0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.11 ms
    Updating status0.01 ms
    Waiting for query cache lock0.01 ms
    Updating status0.02 ms
    Waiting for query cache lock0.01 ms
    Updating status0.01 ms
    Storing result in query cache0.02 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    13JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/cache/controller/callback.php:169
    12JCacheControllerCallback->get()JROOT/libraries/cms/module/helper.php:424
    11JModuleHelper::getModuleList()JROOT/libraries/cms/module/helper.php:360
    10JModuleHelper::load()JROOT/libraries/cms/module/helper.php:84
    9JModuleHelper::getModules()JROOT/libraries/joomla/document/html.php:576
    8JDocumentHtml->countModules()JROOT/templates/protostar/index.php:95
    7require JROOT/templates/protostar/index.phpJROOT/libraries/joomla/document/html.php:653
    6JDocumentHtml->_loadTemplate()JROOT/libraries/joomla/document/html.php:715
    5JDocumentHtml->_fetchTemplate()JROOT/libraries/joomla/document/html.php:530
    4JDocumentHtml->parse()JROOT/libraries/cms/application/cms.php:1098
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:777
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:271
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

17 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 11 × SELECT `m`.`tag_id`,`t`.* 
      FROM `jos_contentitem_tag_map` AS m
      INNER JOIN `jos_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
  2. 4 × 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 jos_categories as c
      LEFT JOIN jos_categories AS s
      ON (s.lft <= c.lft
      AND s.rgt >= c.rgt) OR (s.lft > c.lft
      AND s.rgt < c.rgt)
  3. 4 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state 
      FROM jos_fields AS a
      LEFT JOIN `jos_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN jos_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN jos_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN jos_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN jos_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `jos_fields_categories` AS fc
      ON fc.field_id = a.id
  4. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
      FROM `jos_extensions`
  5. 1 × SELECT `data` 
      FROM `jos_session`
  6. 1 × SELECT b.id 
      FROM jos_usergroups AS a
      LEFT JOIN jos_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  7. 1 × SELECT id, rules 
      FROM `jos_viewlevels
  8. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` 
      FROM jos_extensions
  9. 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 jos_menu AS m
      LEFT JOIN jos_extensions AS e
      ON m.component_id = e.extension_id
  10. 1 × SELECT * 
      FROM jos_languages
  11. 1 × SELECT id, home, template, s.params 
      FROM jos_template_styles as s
      LEFT JOIN jos_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
  12. 1 × SELECT `id`,`name`,`rules`,`parent_id` 
      FROM `jos_assets`
  13. 1 × 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,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,
      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 jos_content AS a
      LEFT JOIN jos_categories AS c
      ON c.id = a.catid
      LEFT JOIN jos_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN jos_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN jos_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN jos_content_rating AS v
      ON a.id = v.content_id
  14. 1 × SELECT COUNT(*) 
      FROM jos_content AS a
      LEFT JOIN jos_categories AS c
      ON c.id = a.catid
      LEFT JOIN jos_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN jos_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN jos_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN jos_content_rating AS v
      ON a.id = v.content_id
  15. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM jos_modules AS m
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN jos_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
OTHER Tables:
  1. 1 × DELETE  
      FROM `jos_session`
  2. 1 × UPDATE `jos_extensions` 
      SET `params` = '{\"mediaversion\":\"a111eb0f7dc76a011b5d39ab3c1efc2b\"}'