• MICROBLUE Internet - Segunda a Sexta das 8:30 as 18:00
  • (17) 3361 2252
  • Chat Online
Microblue Internet

Microblue Internet

  • Home
      • SUPPORT
        • SUPORTE ONLINE
        • POLITICA DA EMPRESA
        • PLANOS FIBRA ÓPTICA
        • AJUDA
      • DEVELOPERS
        • MICROBLUE INTERNET
        • NOSSOS SERVIÇOS
        • BLUE TV!
      • ILIMITADO A
        • 10Mbit / sec
        • $75 / mensais
        • Trafego: ILIMITADO

        Assine já

  • Sobre
  • Páginas
      • PLANOS
      • FAQs
      • Nossa equipe
      • História
      • Depoimentos
      • Site map
      • Forum
      • Portfolio
  • BLUE TV!
  • Galeria
  • Contatos
  • Home
  • Páginas
  • Portfolio

Portfolio

  • Name
  • Date
  • Popularity
  • Read more
    Internet para sua empresa
  • Read more
    Internet para seu home office
  • Read more
    Art & Illustration
  • Read more
    Web & Interactive
  • Read more
    Promotional
  • Read more
    Games & Entertainment
  • Footer logo
Endereço

Rua Floriano Peixoto, 86

Monte Azul Paulista-SP

Telefone

(17) 3361.2252 ;  (17) 99254.3816

De Segunda a Sexta das 8:30 as 18:00

Sabado das 8:30 as 12:00

Siga-nos
Microblue Internet © 2019. Privacy Policy
Login or register
Create an account
Forgot Forgot your username?/ Forgot your password??
Login with Facebook
Login with Google +
  • Forgot your password?
  • Forgot your username?
  • Create an account
 Facebook  Google

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1550873330,
                "last": 1550873330,
                "now": 1550873330
            },
            "token": "FeE4IH6paMkUb8bDPwpr2BBwUo4QmBlb"
        },
        "registry": {
            "com_slogin": {
                "return_url": "aHR0cDovL21pY3JvYmx1ZW1hcC5jb20uYnIvaW5kZXgucGhwL3BhZ2VzL3BvcnRmb2xpbw=="
            }
        },
        "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
        }
    }
}

Profile Information

Time

Memory

Time: 0.01 ms / 0.01 ms Memory: 0.444 MB / 0.44 MB Application: afterLoad
Time: 46.54 ms / 46.55 ms Memory: 1.554 MB / 2.00 MB Application: afterInitialise
Time: 61.88 ms / 108.43 ms Memory: 1.041 MB / 3.04 MB Application: afterRoute
Time: 25.98 ms / 134.40 ms Memory: 0.200 MB / 3.24 MB Application: beforeRenderComponent com_content
Time: 14.99 ms / 149.39 ms Memory: 0.747 MB / 3.99 MB Application: Start JAccess::getAssetRules Old (1)
Time: 1.11 ms / 150.50 ms Memory: 0.040 MB / 4.03 MB Application: Finish JAccess::getAssetRules Old (1)
Time: 0.05 ms / 150.55 ms Memory: 0.000 MB / 4.02 MB Application: New JAccess Preloading Process(com_content.category)
Time: 3.50 ms / 154.04 ms Memory: 0.845 MB / 4.87 MB Application: After preloadPermissionsParentIdMapping (com_content.category)
Time: 10.38 ms / 164.42 ms Memory: 1.306 MB / 6.17 MB Application: After preloadPermissions (com_content.category)
Time: 0.03 ms / 164.45 ms Memory: 0.002 MB / 6.17 MB Application: End New JAccess Preloading Process(com_content.category)
Time: 0.03 ms / 164.48 ms Memory: 0.002 MB / 6.18 MB Application: Start JAccess::getAssetRules New (com_content.category.31)
Time: 0.15 ms / 164.64 ms Memory: 0.010 MB / 6.19 MB Application: Finish JAccess::getAssetRules New (com_content.category.31)
Time: 8.60 ms / 173.23 ms Memory: 0.271 MB / 6.46 MB Application: Start JAccess::preload(components)
Time: 4.26 ms / 177.50 ms Memory: 0.307 MB / 6.76 MB Application: Finish JAccess::preload(components)
Time: 126.41 ms / 303.91 ms Memory: 1.533 MB / 8.30 MB Application: afterRenderComponent com_content
Time: 4.66 ms / 308.56 ms Memory: 0.042 MB / 8.34 MB Application: afterDispatch
Time: 7.67 ms / 316.23 ms Memory: 0.164 MB / 8.50 MB Application: beforeRenderModule mod_tm_olark_chat (Olark)
Time: 1.56 ms / 317.80 ms Memory: 0.012 MB / 8.51 MB Application: afterRenderModule mod_tm_olark_chat (Olark)
Time: 0.11 ms / 317.90 ms Memory: 0.000 MB / 8.51 MB Application: beforeRenderModule mod_slogin (Login form)
Time: 9.37 ms / 327.27 ms Memory: 0.264 MB / 8.78 MB Application: afterRenderModule mod_slogin (Login form)
Time: 0.33 ms / 327.60 ms Memory: 0.000 MB / 8.77 MB Application: beforeRenderModule mod_tm_style_switcher (TM Ajax Style Switcher)
Time: 3.46 ms / 331.07 ms Memory: 0.028 MB / 8.79 MB Application: afterRenderModule mod_tm_style_switcher (TM Ajax Style Switcher)
Time: 0.26 ms / 331.33 ms Memory: 0.000 MB / 8.79 MB Application: beforeRenderModule mod_socialloginandsocialshare (Login or register)
Time: 16.26 ms / 347.59 ms Memory: 0.899 MB / 9.69 MB Application: afterRenderModule mod_socialloginandsocialshare (Login or register)
Time: 0.25 ms / 347.84 ms Memory: 0.000 MB / 9.69 MB Application: beforeRenderModule mod_menu (Footer logo)
Time: 2.77 ms / 350.61 ms Memory: 0.071 MB / 9.76 MB Application: afterRenderModule mod_menu (Footer logo)
Time: 0.10 ms / 350.70 ms Memory: 0.000 MB / 9.76 MB Application: beforeRenderModule mod_articles_single (Endereço)
Time: 12.21 ms / 362.92 ms Memory: 0.239 MB / 9.99 MB Application: afterRenderModule mod_articles_single (Endereço)
Time: 0.14 ms / 363.06 ms Memory: 0.000 MB / 9.96 MB Application: beforeRenderModule mod_articles_single (Telefone)
Time: 4.88 ms / 367.94 ms Memory: 0.085 MB / 10.04 MB Application: afterRenderModule mod_articles_single (Telefone)
Time: 0.12 ms / 368.07 ms Memory: 0.000 MB / 10.01 MB Application: beforeRenderModule mod_menu (Siga-nos)
Time: 2.91 ms / 370.98 ms Memory: 0.019 MB / 10.03 MB Application: afterRenderModule mod_menu (Siga-nos)
Time: 0.18 ms / 371.15 ms Memory: 0.000 MB / 10.02 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 2.55 ms / 373.70 ms Memory: 0.037 MB / 10.06 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 0.19 ms / 373.89 ms Memory: 0.000 MB / 10.05 MB Application: beforeRenderModule mod_icemegamenu (Main menu)
Time: 42.88 ms / 416.76 ms Memory: 0.986 MB / 11.04 MB Application: beforeRenderModule mod_menu (SUPPORT)
Time: 3.52 ms / 420.29 ms Memory: 0.021 MB / 11.06 MB Application: afterRenderModule mod_menu (SUPPORT)
Time: 1.06 ms / 421.35 ms Memory: 0.039 MB / 11.10 MB Application: beforeRenderModule mod_menu (DEVELOPERS)
Time: 3.11 ms / 424.46 ms Memory: 0.020 MB / 11.12 MB Application: afterRenderModule mod_menu (DEVELOPERS)
Time: 1.36 ms / 425.82 ms Memory: 0.044 MB / 11.16 MB Application: beforeRenderModule mod_articles_news_adv (Price)
Time: 16.45 ms / 442.27 ms Memory: 0.262 MB / 11.42 MB Application: afterRenderModule mod_articles_news_adv (Price)
Time: 69.41 ms / 511.68 ms Memory: 0.000 MB / 11.40 MB Application: afterRenderModule mod_icemegamenu (Main menu)
Time: 0.26 ms / 511.94 ms Memory: 0.000 MB / 11.40 MB Application: beforeRenderModule mod_menu (Info)
Time: 2.87 ms / 514.81 ms Memory: 0.018 MB / 11.41 MB Application: afterRenderModule mod_menu (Info)
Time: 9.01 ms / 523.82 ms Memory: 0.162 MB / 11.58 MB Application: afterRender

Database queries total: 166.49 ms

Memory Usage

12.76 MB (13,380,928 Bytes)

Database Queries

56 Queries Logged 166.49 ms


2 duplicate found!

2 duplicates: #8  #42
  1. Query Time: 0.51 ms Query memory: 0.018 MB Memory before query: 0.953 MB Rows returned: 0
    SELECT `data`
    
      FROM `jos_session`
      WHERE `session_id` = 'f6c6b9219e3469bcf31419e5b5b21df3'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjos_sessionconstPRIMARYPRIMARY766const1
    Profile
    StatusDuration
    starting0.02 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.03 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    System lock0.01 ms
    Waiting for query cache lock0.02 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.01 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.00 ms
    Waiting for query cache lock0.00 ms
    freeing items0.04 ms
    Waiting for query cache lock0.01 ms
    freeing items0.00 ms
    storing result in query cache0.05 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1728
    13JDatabaseDriver->loadResult()JROOT/libraries/joomla/session/storage/database.php:44
    12JSessionStorageDatabase->read()Same as call in the line below.
    11session_start()JROOT/libraries/joomla/session/handler/native.php:258
    10JSessionHandlerNative->doSessionStart()JROOT/libraries/joomla/session/handler/native.php:49
    9JSessionHandlerNative->start()JROOT/libraries/joomla/session/handler/joomla.php:81
    8JSessionHandlerJoomla->start()JROOT/libraries/joomla/session/session.php:636
    7JSession->_start()JROOT/libraries/joomla/session/session.php:596
    6JSession->start()JROOT/libraries/cms/application/cms.php:748
    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:404
    2JApplicationCms::getInstance()JROOT/libraries/joomla/factory.php:125
    1JFactory::getApplication()JROOT/index.php:37
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  2. Query Time: 0.43 ms After last query: 2.75 ms Query memory: 0.012 MB Memory before query: 1.020 MB Rows returned: 0
    SELECT `session_id`
    
      FROM `jos_session`
      WHERE `session_id` = 'f6c6b9219e3469bcf31419e5b5b21df3'
      LIMIT 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjos_sessionconstPRIMARYPRIMARY766const1Using index
    Profile
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    System lock0.01 ms
    Waiting for query cache lock0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.01 ms
    executing0.01 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    Waiting for query cache lock0.01 ms
    freeing items0.04 ms
    Waiting for query cache lock0.01 ms
    freeing items0.00 ms
    storing result in query cache0.06 ms
    logging slow query0.01 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    8JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1728
    7JDatabaseDriver->loadResult()JROOT/libraries/cms/application/cms.php:176
    6JApplicationCms->checkSession()JROOT/libraries/cms/application/cms.php:774
    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:404
    2JApplicationCms::getInstance()JROOT/libraries/joomla/factory.php:125
    1JFactory::getApplication()JROOT/index.php:37
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  3. Query Time: 1.35 ms After last query: 0.19 ms Query memory: 0.009 MB Memory before query: 1.032 MB
    INSERT INTO `jos_session`
    (`session_id`, `client_id`, `time`) 
      VALUES ('f6c6b9219e3469bcf31419e5b5b21df3', 0, '1550873330')
    Explain
    EXPLAIN not possible on query: INSERT INTO `jos_session` (`session_id`, `client_id`, `time`) VALUES ('f6c6b9219e3469bcf31419e5b5b21df3', 0, '1550873330')
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.04 ms
    System lock0.01 ms
    init0.01 ms
    update0.09 ms
    Waiting for query cache lock0.01 ms
    update0.89 ms
    end0.01 ms
    query end0.03 ms
    closing tables0.01 ms
    freeing items0.04 ms
    logging slow query0.01 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    7JDatabaseDriverMysqli->execute()JROOT/libraries/cms/application/cms.php:208
    6JApplicationCms->checkSession()JROOT/libraries/cms/application/cms.php:774
    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:404
    2JApplicationCms::getInstance()JROOT/libraries/joomla/factory.php:125
    1JFactory::getApplication()JROOT/index.php:37
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  4. Query Time: 0.94 ms After last query: 2.90 ms Query memory: 0.018 MB Memory before query: 1.115 MB Rows returned: 36
    SELECT extension_id AS id, element AS "option", params, enabled
    
      FROM jos_extensions
      WHERE `type` = 'component'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjos_extensionsrefextensionextension82const36Using where
    Profile
    StatusDuration
    starting0.02 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    System lock0.01 ms
    Waiting for query cache lock0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.14 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.01 ms
    Waiting for query cache lock0.00 ms
    freeing items0.04 ms
    Waiting for query cache lock0.01 ms
    freeing items0.00 ms
    storing result in query cache0.00 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    9JDatabaseDriver->loadObjectList()Same as call in the line below.
    8call_user_func_array()JROOT/libraries/joomla/cache/controller/callback.php:152
    7JCacheControllerCallback->get()JROOT/libraries/cms/component/helper.php:448
    6JComponentHelper::load()JROOT/libraries/cms/component/helper.php:43
    5JComponentHelper::getComponent()JROOT/libraries/cms/component/helper.php:120
    4JComponentHelper::getParams()JROOT/libraries/cms/application/site.php:584
    3JApplicationSite->initialiseApp()JROOT/libraries/cms/application/site.php:209
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  5. Query Time: 0.51 ms After last query: 1.70 ms Query memory: 0.014 MB Memory before query: 1.184 MB Rows returned: 2
    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 = 9
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaconstPRIMARYPRIMARY4const1
    1SIMPLEbrangeidx_usergroup_nested_set_lookupidx_usergroup_nested_set_lookup4NULL3Using where; Using index
    Profile
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.01 ms
    checking query cache for query0.01 ms
    checking privileges on cached 0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    sending cached result to clien0.03 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1538
    9JDatabaseDriver->loadColumn()JROOT/libraries/joomla/access/access.php:852
    8JAccess::getGroupsByUser()JROOT/libraries/joomla/access/access.php:921
    7JAccess::getAuthorisedViewLevels()JROOT/libraries/joomla/user/user.php:453
    6JUser->getAuthorisedViewLevels()JROOT/libraries/cms/plugin/helper.php:296
    5JPluginHelper::load()JROOT/libraries/cms/plugin/helper.php:163
    4JPluginHelper::importPlugin()JROOT/libraries/cms/application/site.php:589
    3JApplicationSite->initialiseApp()JROOT/libraries/cms/application/site.php:209
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  6. Query Time: 0.37 ms After last query: 0.58 ms Query memory: 0.013 MB Memory before query: 1.203 MB Rows returned: 5
    SELECT id, rules
    
      FROM `jos_viewlevels`
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjos_viewlevelsALLNULLNO INDEX KEY COULD BE USEDNULLNULL5
    Profile
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.00 ms
    checking privileges on cached 0.00 ms
    checking permissions0.00 ms
    sending cached result to clien0.03 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    9JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1494
    8JDatabaseDriver->loadAssocList()JROOT/libraries/joomla/access/access.php:938
    7JAccess::getAuthorisedViewLevels()JROOT/libraries/joomla/user/user.php:453
    6JUser->getAuthorisedViewLevels()JROOT/libraries/cms/plugin/helper.php:296
    5JPluginHelper::load()JROOT/libraries/cms/plugin/helper.php:163
    4JPluginHelper::importPlugin()JROOT/libraries/cms/application/site.php:589
    3JApplicationSite->initialiseApp()JROOT/libraries/cms/application/site.php:209
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  7. Query Time: 1.31 ms After last query: 0.54 ms Query memory: 0.019 MB Memory before query: 1.222 MB Rows returned: 58
    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,5)
      ORDER BY ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjos_extensionsrefextensionextension82const96Using where; Using filesort
    Profile
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.03 ms
    checking permissions0.04 ms
    Opening tables0.01 ms
    System lock0.01 ms
    Waiting for query cache lock0.01 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.00 ms
    Sorting result0.25 ms
    Sending data0.23 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.01 ms
    Waiting for query cache lock0.00 ms
    freeing items0.04 ms
    Waiting for query cache lock0.00 ms
    freeing items0.00 ms
    storing result in query cache0.00 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    7JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    6JDatabaseDriver->loadObjectList()JROOT/libraries/cms/plugin/helper.php:310
    5JPluginHelper::load()JROOT/libraries/cms/plugin/helper.php:163
    4JPluginHelper::importPlugin()JROOT/libraries/cms/application/site.php:589
    3JApplicationSite->initialiseApp()JROOT/libraries/cms/application/site.php:209
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  8. Query Time: 0.38 ms After last query: 9.59 ms Query memory: 0.017 MB Memory before query: 1.754 MB Rows returned: 10
    Duplicate queries: #42
    SELECT * 
      FROM jos_loginradius_settings
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjos_loginradius_settingsALLNULLNO INDEX KEY COULD BE USEDNULLNULL10
    Profile
    StatusDuration
    starting0.02 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.01 ms
    checking privileges on cached 0.00 ms
    checking permissions0.01 ms
    sending cached result to clien0.02 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1494
    11JDatabaseDriver->loadAssocList()JROOT/plugins/system/socialloginandsocialshare/socialloginandsocialshare_helper.php:58
    10plgSystemSocialLoginTools::sociallogin_getsettings()JROOT/plugins/system/socialloginandsocialshare/socialloginandsocialshare.php:51
    9plgSystemSocialLoginAndSocialShare->onAfterInitialise()Same as call in the line below.
    8call_user_func_array()JROOT/libraries/joomla/event/event.php:69
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:159
    6JEventDispatcher->trigger()JROOT/libraries/joomla/application/base.php:106
    5JApplicationBase->triggerEvent()JROOT/libraries/cms/application/cms.php:663
    4JApplicationCms->initialiseApp()JROOT/libraries/cms/application/site.php:663
    3JApplicationSite->initialiseApp()JROOT/libraries/cms/application/site.php:209
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  9. Query Time: 50.95 ms After last query: 3.67 ms Query memory: 0.040 MB Memory before query: 2.059 MB Rows returned: 98
    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_lenrefrowsExtra
    1SIMPLEmrefidx_client_id_parent_id_alias_languageidx_client_id_parent_id_alias_language1const117Using where; Using filesort
    1SIMPLEeeq_refPRIMARYPRIMARY4microbluemap05.m.component_id1
    Profile
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.05 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    System lock0.02 ms
    Waiting for query cache lock0.03 ms
    init0.03 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.02 ms
    executing0.01 ms
    Sorting result0.24 ms
    Sending data0.14 ms
    Waiting for query cache lock0.01 ms
    Sending data0.27 ms
    Waiting for query cache lock0.01 ms
    Sending data0.23 ms
    Waiting for query cache lock0.01 ms
    Sending data0.33 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.01 ms
    Waiting for query cache lock0.00 ms
    freeing items0.02 ms
    Waiting for query cache lock0.00 ms
    freeing items0.00 ms
    storing result in query cache0.00 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    15JDatabaseDriver->loadObjectList()JROOT/libraries/cms/menu/site.php:86
    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:133
    11JMenu::getInstance()JROOT/libraries/cms/application/cms.php:435
    10JApplicationCms->getMenu()JROOT/libraries/cms/application/site.php:272
    9JApplicationSite->getMenu()JROOT/libraries/cms/router/site.php:57
    8JRouterSite->__construct()JROOT/libraries/cms/router/router.php:196
    7JRouter::getInstance()JROOT/libraries/cms/application/cms.php:531
    6JApplicationCms::getRouter()JROOT/libraries/cms/application/site.php:407
    5JApplicationSite::getRouter()JROOT/libraries/cms/application/cms.php:1097
    4JApplicationCms->route()JROOT/libraries/cms/application/site.php:763
    3JApplicationSite->route()JROOT/libraries/cms/application/site.php:215
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  10. Query Time: 0.84 ms After last query: 10.16 ms Query memory: 0.019 MB Memory before query: 3.063 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_lenrefrowsExtra
    1SIMPLEjos_extensionsrefelement_clientid,element_folder_clientid,extensionextension484const,const1Using where
    Profile
    StatusDuration
    starting0.03 ms
    Waiting for query cache lock0.01 ms
    checking query cache for query0.05 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    System lock0.01 ms
    Waiting for query cache lock0.04 ms
    init0.04 ms
    optimizing0.02 ms
    statistics0.07 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.04 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.01 ms
    Waiting for query cache lock0.00 ms
    freeing items0.02 ms
    Waiting for query cache lock0.00 ms
    freeing items0.00 ms
    storing result in query cache0.00 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1650
    13JDatabaseDriver->loadObject()Same as call in the line below.
    12call_user_func_array()JROOT/libraries/joomla/cache/controller/callback.php:152
    11JCacheControllerCallback->get()JROOT/libraries/cms/library/helper.php:156
    10JLibraryHelper::_load()JROOT/libraries/cms/library/helper.php:47
    9JLibraryHelper::getLibrary()JROOT/libraries/cms/library/helper.php:90
    8JLibraryHelper::getParams()JROOT/libraries/cms/version/version.php:274
    7JVersion->getMediaVersion()JROOT/libraries/joomla/factory.php:755
    6JFactory::createDocument()JROOT/libraries/joomla/factory.php:216
    5JFactory::getDocument()JROOT/libraries/joomla/application/web.php:991
    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:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  11. Query Time: 14.60 ms After last query: 0.40 ms Query memory: 0.012 MB Memory before query: 3.065 MB
    UPDATE `jos_extensions`
    
      SET `params` = '{\"mediaversion\":\"1f9cd06f51f826bcd1a8cdece7067c76\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    EXPLAIN not possible on query: UPDATE `jos_extensions` SET `params` = '{\"mediaversion\":\"1f9cd06f51f826bcd1a8cdece7067c76\"}' WHERE `type` = 'library' AND `element` = 'joomla'
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    System lock0.01 ms
    init0.05 ms
    Updating0.05 ms
    end0.01 ms
    Waiting for query cache lock0.00 ms
    end13.87 ms
    query end0.07 ms
    closing tables0.02 ms
    freeing items0.03 ms
    logging slow query0.02 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/cms/library/helper.php:119
    9JLibraryHelper::saveParams()JROOT/libraries/cms/version/version.php:325
    8JVersion->setMediaVersion()JROOT/libraries/cms/version/version.php:284
    7JVersion->getMediaVersion()JROOT/libraries/joomla/factory.php:755
    6JFactory::createDocument()JROOT/libraries/joomla/factory.php:216
    5JFactory::getDocument()JROOT/libraries/joomla/application/web.php:991
    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:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  12. Query Time: 0.76 ms After last query: 3.06 ms Query memory: 0.014 MB Memory before query: 3.172 MB Rows returned: 1
    SELECT *
    
      FROM jos_languages
      WHERE published=1
      ORDER BY ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjos_languagesALLNULLNO INDEX KEY COULD BE USEDNULLNULL1Using where; Using filesort
    Profile
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.01 ms
    checking privileges on cached 0.01 ms
    checking permissions0.01 ms
    sending cached result to clien0.02 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    7JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    6JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/language/helper.php:164
    5JLanguageHelper::getLanguages()JROOT/libraries/cms/application/site.php:329
    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:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  13. Query Time: 0.97 ms After last query: 1.66 ms Query memory: 0.010 MB Memory before query: 3.196 MB Rows returned: 6
    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_lenrefrowsExtra
    1SIMPLEsALLidx_templateNO INDEX KEY COULD BE USEDNULLNULL8Using where
    1SIMPLEerefelement_clientid,element_folder_clientid,extensionelement_clientid403microbluemap05.s.template,const1Using where
    Profile
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.03 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    System lock0.01 ms
    Waiting for query cache lock0.02 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.08 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.01 ms
    Waiting for query cache lock0.00 ms
    freeing items0.02 ms
    Waiting for query cache lock0.00 ms
    freeing items0.00 ms
    storing result in query cache0.00 ms
    logging slow query0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    6JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    5JDatabaseDriver->loadObjectList()JROOT/libraries/cms/application/site.php:484
    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:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  14. Query Time: 3.38 ms After last query: 12.83 ms Query memory: 0.033 MB Memory before query: 3.905 MB Rows returned: 8
    SHOW FULL COLUMNS 
      FROM `jos_assets`
    Explain
    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `jos_assets`
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables2.53 ms
    System lock0.01 ms
    init0.01 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.01 ms
    Opening tables0.02 ms
    checking permissions0.03 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.02 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Sending data0.05 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.00 ms
    removing tmp table0.09 ms
    closing tables0.01 ms
    freeing items0.03 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    24JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    23JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/database/driver/mysqli.php:440
    22JDatabaseDriverMysqli->getTableColumns()JROOT/libraries/joomla/table/table.php:241
    21JTable->getFields()JROOT/libraries/joomla/table/table.php:162
    20JTable->__construct()JROOT/libraries/joomla/table/asset.php:60
    19JTableAsset->__construct()JROOT/libraries/joomla/table/table.php:304
    18JTable::getInstance()JROOT/libraries/joomla/access/access.php:714
    17JAccess::getExtensionNameFromAsset()JROOT/libraries/joomla/access/access.php:576
    16JAccess::getAssetRules()JROOT/libraries/joomla/user/user.php:384
    15JUser->authorise()JROOT/components/com_content/models/category.php:141
    14ContentModelCategory->populateState()JROOT/libraries/legacy/model/legacy.php:439
    13JModelLegacy->getState()JROOT/libraries/legacy/view/legacy.php:401
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:114
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    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:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  15. Query Time: 0.41 ms After last query: 1.27 ms Query memory: 0.027 MB Memory before query: 3.966 MB Rows returned: 1
    SELECT *
    
      FROM jos_assets
      WHERE `id` = '1'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjos_assetsconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    starting0.02 ms
    Waiting for query cache lock0.01 ms
    checking query cache for query0.01 ms
    checking privileges on cached 0.00 ms
    checking permissions0.01 ms
    sending cached result to clien0.02 ms
    logging slow query0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1453
    19JDatabaseDriver->loadAssoc()JROOT/libraries/joomla/table/table.php:715
    18JTable->load()JROOT/libraries/joomla/access/access.php:715
    17JAccess::getExtensionNameFromAsset()JROOT/libraries/joomla/access/access.php:576
    16JAccess::getAssetRules()JROOT/libraries/joomla/user/user.php:384
    15JUser->authorise()JROOT/components/com_content/models/category.php:141
    14ContentModelCategory->populateState()JROOT/libraries/legacy/model/legacy.php:439
    13JModelLegacy->getState()JROOT/libraries/legacy/view/legacy.php:401
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:114
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    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:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  16. Query Time: 0.24 ms After last query: 0.23 ms Query memory: 0.024 MB Memory before query: 3.988 MB Rows returned: 1
    SELECT a.rules
    
      FROM jos_assets AS a
      WHERE (a.id = 1 OR a.name = 'root.1')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaindex_mergePRIMARY,idx_asset_namePRIMARY,idx_asset_name4,202NULL2Using union(PRIMARY,idx_asset_name); Using where
    Profile
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.01 ms
    checking privileges on cached 0.00 ms
    checking permissions0.00 ms
    sending cached result to clien0.02 ms
    logging slow query0.01 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1538
    17JDatabaseDriver->loadColumn()JROOT/libraries/joomla/access/access.php:670
    16JAccess::getAssetRules()JROOT/libraries/joomla/user/user.php:384
    15JUser->authorise()JROOT/components/com_content/models/category.php:141
    14ContentModelCategory->populateState()JROOT/libraries/legacy/model/legacy.php:439
    13JModelLegacy->getState()JROOT/libraries/legacy/view/legacy.php:401
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:114
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    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:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  17. Query Time: 0.59 ms After last query: 0.91 ms Query memory: 0.051 MB Memory before query: 4.025 MB Rows returned: 1088
    SELECT a.id, a.parent_id
    
      FROM jos_assets AS a
      WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaALLPRIMARY,idx_asset_nameNO INDEX KEY COULD BE USEDNULLNULL1963Using where
    Profile
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.01 ms
    checking privileges on cached 0.00 ms
    checking permissions0.00 ms
    sending cached result to clien0.04 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    19JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/access/access.php:331
    18JAccess::preloadPermissionsParentIdMapping()JROOT/libraries/joomla/access/access.php:240
    17JAccess::preload()JROOT/libraries/joomla/access/access.php:168
    16JAccess::check()JROOT/libraries/joomla/user/user.php:393
    15JUser->authorise()JROOT/components/com_content/models/category.php:141
    14ContentModelCategory->populateState()JROOT/libraries/legacy/model/legacy.php:439
    13JModelLegacy->getState()JROOT/libraries/legacy/view/legacy.php:401
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:114
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    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:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  18. Query Time: 3.24 ms After last query: 3.79 ms Query memory: 0.059 MB Memory before query: 4.895 MB Rows returned: 1088
    SELECT a.id, a.name, a.rules
    
      FROM jos_assets AS a
      WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1 )
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaALLPRIMARY,idx_asset_nameNO INDEX KEY COULD BE USEDNULLNULL1963Using where
    Profile
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.01 ms
    checking query cache for query0.01 ms
    checking privileges on cached 0.00 ms
    checking permissions0.00 ms
    sending cached result to clien1.83 ms
    logging slow query0.01 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1255
    19JDatabaseDriver->getIterator()JROOT/libraries/joomla/access/access.php:372
    18JAccess::preloadPermissions()JROOT/libraries/joomla/access/access.php:243
    17JAccess::preload()JROOT/libraries/joomla/access/access.php:168
    16JAccess::check()JROOT/libraries/joomla/user/user.php:393
    15JUser->authorise()JROOT/components/com_content/models/category.php:141
    14ContentModelCategory->populateState()JROOT/libraries/legacy/model/legacy.php:439
    13JModelLegacy->getState()JROOT/libraries/legacy/view/legacy.php:401
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:114
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    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:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  19. Query Time: 4.17 ms After last query: 8.02 ms Query memory: 0.030 MB Memory before query: 6.222 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,COUNT(i.`id`) AS numitems
      FROM jos_categories as c
      LEFT JOIN (SELECT cat.id as id
      FROM jos_categories AS cat JOIN jos_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      LEFT JOIN jos_categories AS s
      ON (s.lft <= c.lft
      AND s.rgt >= c.rgt) OR (s.lft > c.lft
      AND s.rgt < c.rgt)
      LEFT JOIN `jos_content` AS i
      ON i.`catid` = c.id
      AND i.state = 1
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND badcats.id is null
      AND s.id=31
      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_lenrefrowsExtra
    1PRIMARY<derived2>systemNULLNO INDEX KEY COULD BE USEDNULLNULL0const row not found
    1PRIMARYsconstPRIMARY,idx_left_rightPRIMARY4const1Using temporary; Using filesort
    1PRIMARYcALLcat_idx,idx_access,idx_left_rightNO INDEX KEY COULD BE USEDNULLNULL37Using where
    1PRIMARYirefidx_state,idx_catididx_catid4microbluemap05.c.id26
    2DERIVEDparentrangecat_idx,idx_left_rightcat_idx203NULL2Using where; Using temporary; Using filesort
    2DERIVEDcatindexidx_left_rightidx_left_right8NULL37Using where; Using index; Using join buffer
    Profile
    StatusDuration
    starting0.02 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.12 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.03 ms
    System lock0.04 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.01 ms
    Creating tmp table0.01 ms
    executing0.00 ms
    Copying to tmp table0.05 ms
    Sorting result0.01 ms
    Sending data0.01 ms
    removing tmp table0.01 ms
    Sending data0.00 ms
    Waiting for query cache lock0.00 ms
    Sending data0.03 ms
    init0.06 ms
    optimizing0.01 ms
    statistics0.11 ms
    preparing0.03 ms
    Creating tmp table2.17 ms
    executing0.01 ms
    Copying to tmp table0.54 ms
    Sorting result0.05 ms
    Sending data0.04 ms
    end0.01 ms
    removing tmp table0.08 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    removing tmp table0.01 ms
    closing tables0.02 ms
    freeing items0.02 ms
    Waiting for query cache lock0.00 ms
    freeing items0.02 ms
    Waiting for query cache lock0.00 ms
    freeing items0.00 ms
    storing result in query cache0.00 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    17JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/categories/categories.php:309
    16JCategories->_load()JROOT/libraries/legacy/categories/categories.php:184
    15JCategories->get()JROOT/components/com_content/models/category.php:353
    14ContentModelCategory->getCategory()JROOT/components/com_content/models/category.php:229
    13ContentModelCategory->getItems()JROOT/libraries/legacy/view/legacy.php:401
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:115
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    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:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  20. Query Time: 0.64 ms After last query: 2.95 ms Query memory: 0.030 MB Memory before query: 6.455 MB Rows returned: 36
    SELECT element
    
      FROM jos_extensions
      WHERE type = 'component'
      AND enabled = '1'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjos_extensionsrefextensionextension82const36Using where
    Profile
    StatusDuration
    starting0.02 ms
    Waiting for query cache lock0.01 ms
    checking query cache for query0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    System lock0.01 ms
    Waiting for query cache lock0.03 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.09 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    Waiting for query cache lock0.00 ms
    freeing items0.02 ms
    Waiting for query cache lock0.00 ms
    freeing items0.00 ms
    storing result in query cache0.00 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    23JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1538
    22JDatabaseDriver->loadColumn()JROOT/libraries/joomla/access/access.php:412
    21JAccess::preloadComponents()JROOT/libraries/joomla/access/access.php:213
    20JAccess::preload()JROOT/libraries/joomla/access/access.php:168
    19JAccess::check()JROOT/libraries/joomla/user/user.php:393
    18JUser->authorise()JROOT/components/com_content/models/articles.php:467
    17ContentModelArticles->getListQuery()JROOT/libraries/legacy/model/list.php:129
    16JModelList->_getListQuery()JROOT/libraries/legacy/model/list.php:181
    15JModelList->getItems()JROOT/components/com_content/models/articles.php:566
    14ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:252
    13ContentModelCategory->getItems()JROOT/libraries/legacy/view/legacy.php:401
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:115
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    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:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  21. Query Time: 0.50 ms After last query: 0.33 ms Query memory: 0.030 MB Memory before query: 6.491 MB Rows returned: 36
    SELECT a.name, a.rules
    
      FROM jos_assets AS a
      WHERE (a.name IN ('com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_finder','com_installer','com_joomgallery','com_joomlaupdate','com_komento','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_slogin','com_socialloginandsocialshare','com_tags','com_templates','com_users','com_weblinks','com_wrapper') OR a.name = 'root.1')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarangeidx_asset_nameidx_asset_name202NULL37Using where
    Profile
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.01 ms
    checking privileges on cached 0.00 ms
    checking permissions0.00 ms
    sending cached result to clien0.02 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    23JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1494
    22JDatabaseDriver->loadAssocList()JROOT/libraries/joomla/access/access.php:439
    21JAccess::preloadComponents()JROOT/libraries/joomla/access/access.php:213
    20JAccess::preload()JROOT/libraries/joomla/access/access.php:168
    19JAccess::check()JROOT/libraries/joomla/user/user.php:393
    18JUser->authorise()JROOT/components/com_content/models/articles.php:467
    17ContentModelArticles->getListQuery()JROOT/libraries/legacy/model/list.php:129
    16JModelList->_getListQuery()JROOT/libraries/legacy/model/list.php:181
    15JModelList->getItems()JROOT/components/com_content/models/articles.php:566
    14ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:252
    13ContentModelCategory->getItems()JROOT/libraries/legacy/view/legacy.php:401
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:115
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    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:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  22. Query Time: 34.98 ms After last query: 2.87 ms Query memory: 0.035 MB Memory before query: 6.755 MB Rows returned: 6
    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,
      CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
      CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
      FROM 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
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM jos_categories AS cat JOIN jos_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id ) AS badcats
      ON badcats.id = c.id
      WHERE a.access IN (1,1,5)
      AND c.access IN (1,1,5)
      AND
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
      AND (a.catid = 31 OR a.catid IN ( SELECT sub.id
      FROM jos_categories as sub
      INNER JOIN jos_categories as this
      ON sub.lft > this.lft
      AND sub.rgt < this.rgt
      WHERE this.id = 31))
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-02-22 22:08:50')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-02-22 22:08:50')
      ORDER BY c.lft, a.ordering, a.created
      LIMIT 10
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1PRIMARY<derived2>systemNULLNO INDEX KEY COULD BE USEDNULLNULL0const row not found
    1PRIMARYcALLPRIMARY,idx_accessNO INDEX KEY COULD BE USEDNULLNULL37Using where; Using temporary; Using filesort
    1PRIMARYarefidx_access,idx_catididx_catid4microbluemap05.c.id26Using where
    1PRIMARYuaeq_refPRIMARYPRIMARY4microbluemap05.a.created_by1
    1PRIMARYuameq_refPRIMARYPRIMARY4microbluemap05.a.modified_by1
    1PRIMARYparenteq_refPRIMARYPRIMARY4microbluemap05.c.parent_id1
    1PRIMARYveq_refPRIMARYPRIMARY4microbluemap05.a.id1
    3DEPENDENT SUBQUERYthisconstPRIMARY,idx_left_rightPRIMARY4const1
    3DEPENDENT SUBQUERYsubeq_refPRIMARY,idx_left_rightPRIMARY4func1Using where
    2DERIVEDparentrangecat_idx,idx_left_rightcat_idx203NULL2Using where; Using temporary; Using filesort
    2DERIVEDcatindexidx_left_rightidx_left_right8NULL37Using where; Using index; Using join buffer
    Profile
    StatusDuration
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.02 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.12 ms
    Sorting result0.13 ms
    Sending data0.11 ms
    Waiting for query cache lock0.01 ms
    Sending data0.05 ms
    end0.01 ms
    removing tmp table0.14 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.00 ms
    removing tmp table0.01 ms
    closing tables0.02 ms
    freeing items0.02 ms
    Waiting for query cache lock0.00 ms
    freeing items0.01 ms
    Waiting for query cache lock0.00 ms
    freeing items0.00 ms
    storing result in query cache0.03 ms
    logging slow query0.00 ms
    logging slow query0.01 ms
    Opening table0.01 ms
    System lock0.06 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    17JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/model/legacy.php:312
    16JModelLegacy->_getList()JROOT/libraries/legacy/model/list.php:185
    15JModelList->getItems()JROOT/components/com_content/models/articles.php:566
    14ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:252
    13ContentModelCategory->getItems()JROOT/libraries/legacy/view/legacy.php:401
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:115
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    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:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  23. Query Time: 0.46 ms After last query: 2.21 ms Query memory: 0.029 MB Memory before query: 6.894 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` = 66
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEtrefPRIMARY,tag_idx,idx_accesstag_idx1const4Using where
    1SIMPLEmrefidx_tag_typeidx_tag_type4microbluemap05.t.id203Using where
    Profile
    StatusDuration
    starting0.02 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.01 ms
    checking privileges on cached 0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    sending cached result to clien0.02 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    16JDatabaseDriver->loadObjectList()JROOT/libraries/cms/helper/tags.php:426
    15JHelperTags->getItemTags()JROOT/components/com_content/models/articles.php:694
    14ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:252
    13ContentModelCategory->getItems()JROOT/libraries/legacy/view/legacy.php:401
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:115
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    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:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  24. Query Time: 0.40 ms After last query: 0.68 ms Query memory: 0.029 MB Memory before query: 6.935 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` = 67
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEtrefPRIMARY,tag_idx,idx_accesstag_idx1const4Using where
    1SIMPLEmrefidx_tag_typeidx_tag_type4microbluemap05.t.id203Using where
    Profile
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.01 ms
    checking privileges on cached 0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    sending cached result to clien0.02 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    16JDatabaseDriver->loadObjectList()JROOT/libraries/cms/helper/tags.php:426
    15JHelperTags->getItemTags()JROOT/components/com_content/models/articles.php:694
    14ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:252
    13ContentModelCategory->getItems()JROOT/libraries/legacy/view/legacy.php:401
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:115
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    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:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  25. Query Time: 0.52 ms After last query: 0.73 ms Query memory: 0.029 MB Memory before query: 6.977 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` = 68
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEtrefPRIMARY,tag_idx,idx_accesstag_idx1const4Using where
    1SIMPLEmrefidx_tag_typeidx_tag_type4microbluemap05.t.id203Using where
    Profile
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.01 ms
    checking privileges on cached 0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    sending cached result to clien0.04 ms
    logging slow query0.01 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    16JDatabaseDriver->loadObjectList()JROOT/libraries/cms/helper/tags.php:426
    15JHelperTags->getItemTags()JROOT/components/com_content/models/articles.php:694
    14ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:252
    13ContentModelCategory->getItems()JROOT/libraries/legacy/view/legacy.php:401
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:115
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    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:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  26. Query Time: 0.44 ms After last query: 0.81 ms Query memory: 0.029 MB Memory before query: 7.018 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` = 69
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEtrefPRIMARY,tag_idx,idx_accesstag_idx1const4Using where
    1SIMPLEmrefidx_tag_typeidx_tag_type4microbluemap05.t.id203Using where
    Profile
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.01 ms
    checking privileges on cached 0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    sending cached result to clien0.02 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    16JDatabaseDriver->loadObjectList()JROOT/libraries/cms/helper/tags.php:426
    15JHelperTags->getItemTags()JROOT/components/com_content/models/articles.php:694
    14ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:252
    13ContentModelCategory->getItems()JROOT/libraries/legacy/view/legacy.php:401
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:115
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    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:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  27. Query Time: 0.39 ms After last query: 0.64 ms Query memory: 0.029 MB Memory before query: 7.059 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` = 70
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEtrefPRIMARY,tag_idx,idx_accesstag_idx1const4Using where
    1SIMPLEmrefidx_tag_typeidx_tag_type4microbluemap05.t.id203Using where
    Profile
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.01 ms
    checking privileges on cached 0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    sending cached result to clien0.02 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    16JDatabaseDriver->loadObjectList()JROOT/libraries/cms/helper/tags.php:426
    15JHelperTags->getItemTags()JROOT/components/com_content/models/articles.php:694
    14ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:252
    13ContentModelCategory->getItems()JROOT/libraries/legacy/view/legacy.php:401
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:115
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    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:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  28. Query Time: 0.41 ms After last query: 0.64 ms Query memory: 0.029 MB Memory before query: 7.100 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` = 71
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEtrefPRIMARY,tag_idx,idx_accesstag_idx1const4Using where
    1SIMPLEmrefidx_tag_typeidx_tag_type4microbluemap05.t.id203Using where
    Profile
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.01 ms
    checking privileges on cached 0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    sending cached result to clien0.02 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    16JDatabaseDriver->loadObjectList()JROOT/libraries/cms/helper/tags.php:426
    15JHelperTags->getItemTags()JROOT/components/com_content/models/articles.php:694
    14ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:252
    13ContentModelCategory->getItems()JROOT/libraries/legacy/view/legacy.php:401
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:115
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    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:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  29. Query Time: 16.57 ms After last query: 1.73 ms Query memory: 0.024 MB Memory before query: 7.268 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
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM jos_categories AS cat JOIN jos_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id ) AS badcats
      ON badcats.id = c.id
      WHERE a.access IN (1,1,5)
      AND c.access IN (1,1,5)
      AND
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
      AND (a.catid = 31 OR a.catid IN ( SELECT sub.id
      FROM jos_categories as sub
      INNER JOIN jos_categories as this
      ON sub.lft > this.lft
      AND sub.rgt < this.rgt
      WHERE this.id = 31))
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-02-22 22:08:50')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-02-22 22:08:50')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1PRIMARY<derived2>systemNULLNO INDEX KEY COULD BE USEDNULLNULL0const row not found
    1PRIMARYcALLPRIMARY,idx_accessNO INDEX KEY COULD BE USEDNULLNULL37Using where
    1PRIMARYarefidx_access,idx_catididx_catid4microbluemap05.c.id26Using where
    1PRIMARYuaeq_refPRIMARYPRIMARY4microbluemap05.a.created_by1Using index
    1PRIMARYuameq_refPRIMARYPRIMARY4microbluemap05.a.modified_by1Using index
    1PRIMARYparenteq_refPRIMARYPRIMARY4microbluemap05.c.parent_id1Using index
    1PRIMARYveq_refPRIMARYPRIMARY4microbluemap05.a.id1Using index
    3DEPENDENT SUBQUERYthisconstPRIMARY,idx_left_rightPRIMARY4const1
    3DEPENDENT SUBQUERYsubeq_refPRIMARY,idx_left_rightPRIMARY4func1Using where
    2DERIVEDparentrangecat_idx,idx_left_rightcat_idx203NULL2Using where; Using temporary; Using filesort
    2DERIVEDcatindexidx_left_rightidx_left_right8NULL37Using where; Using index; Using join buffer
    Profile
    StatusDuration
    executing0.01 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.02 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.01 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.02 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    executing0.00 ms
    Sending data0.02 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.00 ms
    removing tmp table0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    Waiting for query cache lock0.00 ms
    freeing items0.03 ms
    Waiting for query cache lock0.01 ms
    freeing items0.01 ms
    storing result in query cache0.01 ms
    logging slow query0.00 ms
    logging slow query0.01 ms
    Opening table0.01 ms
    System lock0.04 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1728
    17JDatabaseDriver->loadResult()JROOT/libraries/legacy/model/legacy.php:341
    16JModelLegacy->_getListCount()JROOT/libraries/legacy/model/list.php:290
    15JModelList->getTotal()JROOT/libraries/legacy/model/list.php:235
    14JModelList->getPagination()JROOT/components/com_content/models/category.php:264
    13ContentModelCategory->getItems()JROOT/libraries/legacy/view/legacy.php:401
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:115
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    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:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  30. Query Time: 0.40 ms After last query: 0.87 ms Query memory: 0.025 MB Memory before query: 7.277 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.category'
      AND `m`.`content_item_id` = 31
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEtrefPRIMARY,tag_idx,idx_accesstag_idx1const4Using where
    1SIMPLEmrefidx_tag_typeidx_tag_type4microbluemap05.t.id203Using where
    Profile
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.01 ms
    checking query cache for query0.02 ms
    checking privileges on cached 0.00 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    sending cached result to clien0.02 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    13JDatabaseDriver->loadObjectList()JROOT/libraries/cms/helper/tags.php:426
    12JHelperTags->getItemTags()JROOT/libraries/legacy/view/category.php:217
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    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:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  31. Query Time: 1.98 ms After last query: 5.87 ms Query memory: 0.036 MB Memory before query: 7.571 MB Rows returned: 2
    SHOW FULL COLUMNS 
      FROM `jos_komento_configs`
    Explain
    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `jos_komento_configs`
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables1.39 ms
    System lock0.01 ms
    init0.01 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.01 ms
    Opening tables0.01 ms
    checking permissions0.02 ms
    checking permissions0.02 ms
    Sending data0.03 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.00 ms
    removing tmp table0.07 ms
    closing tables0.01 ms
    freeing items0.02 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    27JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    26JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/database/driver/mysqli.php:440
    25JDatabaseDriverMysqli->getTableColumns()JROOT/libraries/joomla/table/table.php:241
    24JTable->getFields()JROOT/libraries/joomla/table/table.php:162
    23JTable->__construct()JROOT/administrator/components/com_komento/tables/parent.php:18
    22KomentoParentTable->__construct()JROOT/administrator/components/com_komento/tables/configs.php:40
    21KomentoTableConfigs->__construct()JROOT/libraries/joomla/table/table.php:304
    20JTable::getInstance()JROOT/administrator/components/com_komento/tables/parent.php:49
    19KomentoParentTable::getInstance()JROOT/components/com_komento/helpers/helper.php:99
    18Komento::getTable()JROOT/components/com_komento/helpers/helper.php:228
    17Komento::getKonfig()JROOT/components/com_komento/bootstrap.php:30
    16require_once JROOT/components/com_komento/bootstrap.phpJROOT/plugins/content/komento/komento.php:136
    15plgContentKomento->execute()JROOT/plugins/content/komento/komento.php:111
    14plgContentKomento->onContentPrepare()Same as call in the line below.
    13call_user_func_array()JROOT/libraries/joomla/event/event.php:69
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:159
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:106
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    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:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  32. Query Time: 0.30 ms After last query: 0.27 ms Query memory: 0.026 MB Memory before query: 7.612 MB Rows returned: 1
    SELECT *
    
      FROM jos_komento_configs
      WHERE `component` = 'com_komento'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjos_komento_configsALLNULLNO INDEX KEY COULD BE USEDNULLNULL5Using where
    Profile
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.01 ms
    checking privileges on cached 0.00 ms
    checking permissions0.01 ms
    sending cached result to clien0.02 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1453
    19JDatabaseDriver->loadAssoc()JROOT/libraries/joomla/table/table.php:715
    18JTable->load()JROOT/components/com_komento/helpers/helper.php:229
    17Komento::getKonfig()JROOT/components/com_komento/bootstrap.php:30
    16require_once JROOT/components/com_komento/bootstrap.phpJROOT/plugins/content/komento/komento.php:136
    15plgContentKomento->execute()JROOT/plugins/content/komento/komento.php:111
    14plgContentKomento->onContentPrepare()Same as call in the line below.
    13call_user_func_array()JROOT/libraries/joomla/event/event.php:69
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:159
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:106
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    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:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  33. Query Time: 0.58 ms After last query: 6.98 ms Query memory: 0.026 MB Memory before query: 7.878 MB Rows returned: 1
    SELECT *
    
      FROM jos_komento_configs
      WHERE `component` = 'com_content'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjos_komento_configsALLNULLNO INDEX KEY COULD BE USEDNULLNULL5Using where
    Profile
    StatusDuration
    starting0.02 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.01 ms
    checking privileges on cached 0.00 ms
    checking permissions0.01 ms
    sending cached result to clien0.03 ms
    logging slow query0.01 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1453
    19JDatabaseDriver->loadAssoc()JROOT/libraries/joomla/table/table.php:715
    18JTable->load()JROOT/components/com_komento/helpers/helper.php:202
    17Komento::getConfig()JROOT/components/com_komento/helpers/helper.php:697
    16Komento::commentify()JROOT/plugins/content/komento/komento.php:166
    15plgContentKomento->execute()JROOT/plugins/content/komento/komento.php:80
    14plgContentKomento->onContentAfterDisplay()Same as call in the line below.
    13call_user_func_array()JROOT/libraries/joomla/event/event.php:69
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:159
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:117
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    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:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  34. Query Time: 0.87 ms After last query: 3.64 ms Query memory: 0.032 MB Memory before query: 7.932 MB Rows returned: 1
    SELECT a.id, a.title, a.alias, a.catid, a.created_by, a.created_by_alias, a.hits, c.title AS category_title, c.alias AS category_alias, u.name AS author, parent.id AS parent_id, parent.alias AS parent_alias 
      FROM `jos_content` AS a
      LEFT JOIN `jos_categories` AS c
      ON c.id = a.catid
      LEFT JOIN `jos_users` AS u
      ON u.id = a.created_by
      LEFT JOIN `jos_categories` AS parent
      ON parent.id = c.parent_id
      WHERE a.id = '66'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaconstPRIMARYPRIMARY4const1
    1SIMPLEcconstPRIMARYPRIMARY4const1
    1SIMPLEuconstPRIMARYPRIMARY4const0unique row not found
    1SIMPLEparentconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    starting0.03 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.04 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    System lock0.01 ms
    Waiting for query cache lock0.03 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.09 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.01 ms
    Waiting for query cache lock0.00 ms
    freeing items0.02 ms
    Waiting for query cache lock0.01 ms
    freeing items0.00 ms
    storing result in query cache0.00 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1650
    24JDatabaseDriver->loadObject()Same as call in the line below.
    23call_user_func_array()JROOT/components/com_komento/helpers/database.php:151
    22KomentoDatabaseJoomla15->__call()Same as call in the line below.
    21KomentoDatabaseJoomla30->loadObject()Same as call in the line below.
    20call_user_func_array()JROOT/components/com_komento/helpers/database.php:40
    19KomentoDatabaseHelper->__call()JROOT/components/com_komento/komento_plugins/com_content.php:54
    18KomentoDatabaseHelper->loadObject()JROOT/components/com_komento/komento_plugins/com_content.php:54
    17KomentoComcontent->load()JROOT/components/com_komento/helpers/helper.php:743
    16Komento::commentify()JROOT/plugins/content/komento/komento.php:166
    15plgContentKomento->execute()JROOT/plugins/content/komento/komento.php:80
    14plgContentKomento->onContentAfterDisplay()Same as call in the line below.
    13call_user_func_array()JROOT/libraries/joomla/event/event.php:69
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:159
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:117
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    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:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  35. Query Time: 0.56 ms After last query: 0.69 ms Query memory: 0.032 MB Memory before query: 7.965 MB Rows returned: 1
    SELECT a.id, a.title, a.alias, a.catid, a.created_by, a.created_by_alias, a.hits, c.title AS category_title, c.alias AS category_alias, u.name AS author, parent.id AS parent_id, parent.alias AS parent_alias 
      FROM `jos_content` AS a
      LEFT JOIN `jos_categories` AS c
      ON c.id = a.catid
      LEFT JOIN `jos_users` AS u
      ON u.id = a.created_by
      LEFT JOIN `jos_categories` AS parent
      ON parent.id = c.parent_id
      WHERE a.id = '67'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaconstPRIMARYPRIMARY4const1
    1SIMPLEcconstPRIMARYPRIMARY4const1
    1SIMPLEuconstPRIMARYPRIMARY4const0unique row not found
    1SIMPLEparentconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.03 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    System lock0.01 ms
    Waiting for query cache lock0.02 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.00 ms
    Waiting for query cache lock0.00 ms
    freeing items0.02 ms
    Waiting for query cache lock0.00 ms
    freeing items0.00 ms
    storing result in query cache0.00 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1650
    24JDatabaseDriver->loadObject()Same as call in the line below.
    23call_user_func_array()JROOT/components/com_komento/helpers/database.php:151
    22KomentoDatabaseJoomla15->__call()Same as call in the line below.
    21KomentoDatabaseJoomla30->loadObject()Same as call in the line below.
    20call_user_func_array()JROOT/components/com_komento/helpers/database.php:40
    19KomentoDatabaseHelper->__call()JROOT/components/com_komento/komento_plugins/com_content.php:54
    18KomentoDatabaseHelper->loadObject()JROOT/components/com_komento/komento_plugins/com_content.php:54
    17KomentoComcontent->load()JROOT/components/com_komento/helpers/helper.php:743
    16Komento::commentify()JROOT/plugins/content/komento/komento.php:166
    15plgContentKomento->execute()JROOT/plugins/content/komento/komento.php:80
    14plgContentKomento->onContentAfterDisplay()Same as call in the line below.
    13call_user_func_array()JROOT/libraries/joomla/event/event.php:69
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:159
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:117
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    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:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  36. Query Time: 0.49 ms After last query: 0.60 ms Query memory: 0.032 MB Memory before query: 7.998 MB Rows returned: 1
    SELECT a.id, a.title, a.alias, a.catid, a.created_by, a.created_by_alias, a.hits, c.title AS category_title, c.alias AS category_alias, u.name AS author, parent.id AS parent_id, parent.alias AS parent_alias 
      FROM `jos_content` AS a
      LEFT JOIN `jos_categories` AS c
      ON c.id = a.catid
      LEFT JOIN `jos_users` AS u
      ON u.id = a.created_by
      LEFT JOIN `jos_categories` AS parent
      ON parent.id = c.parent_id
      WHERE a.id = '68'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaconstPRIMARYPRIMARY4const1
    1SIMPLEcconstPRIMARYPRIMARY4const1
    1SIMPLEuconstPRIMARYPRIMARY4const0unique row not found
    1SIMPLEparentconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.03 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    System lock0.01 ms
    Waiting for query cache lock0.02 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.01 ms
    Waiting for query cache lock0.00 ms
    freeing items0.02 ms
    Waiting for query cache lock0.00 ms
    freeing items0.00 ms
    storing result in query cache0.00 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1650
    24JDatabaseDriver->loadObject()Same as call in the line below.
    23call_user_func_array()JROOT/components/com_komento/helpers/database.php:151
    22KomentoDatabaseJoomla15->__call()Same as call in the line below.
    21KomentoDatabaseJoomla30->loadObject()Same as call in the line below.
    20call_user_func_array()JROOT/components/com_komento/helpers/database.php:40
    19KomentoDatabaseHelper->__call()JROOT/components/com_komento/komento_plugins/com_content.php:54
    18KomentoDatabaseHelper->loadObject()JROOT/components/com_komento/komento_plugins/com_content.php:54
    17KomentoComcontent->load()JROOT/components/com_komento/helpers/helper.php:743
    16Komento::commentify()JROOT/plugins/content/komento/komento.php:166
    15plgContentKomento->execute()JROOT/plugins/content/komento/komento.php:80
    14plgContentKomento->onContentAfterDisplay()Same as call in the line below.
    13call_user_func_array()JROOT/libraries/joomla/event/event.php:69
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:159
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:117
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    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:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  37. Query Time: 0.55 ms After last query: 0.57 ms Query memory: 0.032 MB Memory before query: 8.031 MB Rows returned: 1
    SELECT a.id, a.title, a.alias, a.catid, a.created_by, a.created_by_alias, a.hits, c.title AS category_title, c.alias AS category_alias, u.name AS author, parent.id AS parent_id, parent.alias AS parent_alias 
      FROM `jos_content` AS a
      LEFT JOIN `jos_categories` AS c
      ON c.id = a.catid
      LEFT JOIN `jos_users` AS u
      ON u.id = a.created_by
      LEFT JOIN `jos_categories` AS parent
      ON parent.id = c.parent_id
      WHERE a.id = '69'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaconstPRIMARYPRIMARY4const1
    1SIMPLEcconstPRIMARYPRIMARY4const1
    1SIMPLEuconstPRIMARYPRIMARY4const0unique row not found
    1SIMPLEparentconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.03 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    System lock0.01 ms
    Waiting for query cache lock0.02 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.01 ms
    Waiting for query cache lock0.00 ms
    freeing items0.02 ms
    Waiting for query cache lock0.01 ms
    freeing items0.00 ms
    storing result in query cache0.00 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1650
    24JDatabaseDriver->loadObject()Same as call in the line below.
    23call_user_func_array()JROOT/components/com_komento/helpers/database.php:151
    22KomentoDatabaseJoomla15->__call()Same as call in the line below.
    21KomentoDatabaseJoomla30->loadObject()Same as call in the line below.
    20call_user_func_array()JROOT/components/com_komento/helpers/database.php:40
    19KomentoDatabaseHelper->__call()JROOT/components/com_komento/komento_plugins/com_content.php:54
    18KomentoDatabaseHelper->loadObject()JROOT/components/com_komento/komento_plugins/com_content.php:54
    17KomentoComcontent->load()JROOT/components/com_komento/helpers/helper.php:743
    16Komento::commentify()JROOT/plugins/content/komento/komento.php:166
    15plgContentKomento->execute()JROOT/plugins/content/komento/komento.php:80
    14plgContentKomento->onContentAfterDisplay()Same as call in the line below.
    13call_user_func_array()JROOT/libraries/joomla/event/event.php:69
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:159
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:117
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    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:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  38. Query Time: 0.51 ms After last query: 0.56 ms Query memory: 0.032 MB Memory before query: 8.064 MB Rows returned: 1
    SELECT a.id, a.title, a.alias, a.catid, a.created_by, a.created_by_alias, a.hits, c.title AS category_title, c.alias AS category_alias, u.name AS author, parent.id AS parent_id, parent.alias AS parent_alias 
      FROM `jos_content` AS a
      LEFT JOIN `jos_categories` AS c
      ON c.id = a.catid
      LEFT JOIN `jos_users` AS u
      ON u.id = a.created_by
      LEFT JOIN `jos_categories` AS parent
      ON parent.id = c.parent_id
      WHERE a.id = '70'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaconstPRIMARYPRIMARY4const1
    1SIMPLEcconstPRIMARYPRIMARY4const1
    1SIMPLEuconstPRIMARYPRIMARY4const0unique row not found
    1SIMPLEparentconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.03 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    System lock0.01 ms
    Waiting for query cache lock0.02 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.01 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.00 ms
    Waiting for query cache lock0.00 ms
    freeing items0.03 ms
    Waiting for query cache lock0.00 ms
    freeing items0.00 ms
    storing result in query cache0.00 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1650
    24JDatabaseDriver->loadObject()Same as call in the line below.
    23call_user_func_array()JROOT/components/com_komento/helpers/database.php:151
    22KomentoDatabaseJoomla15->__call()Same as call in the line below.
    21KomentoDatabaseJoomla30->loadObject()Same as call in the line below.
    20call_user_func_array()JROOT/components/com_komento/helpers/database.php:40
    19KomentoDatabaseHelper->__call()JROOT/components/com_komento/komento_plugins/com_content.php:54
    18KomentoDatabaseHelper->loadObject()JROOT/components/com_komento/komento_plugins/com_content.php:54
    17KomentoComcontent->load()JROOT/components/com_komento/helpers/helper.php:743
    16Komento::commentify()JROOT/plugins/content/komento/komento.php:166
    15plgContentKomento->execute()JROOT/plugins/content/komento/komento.php:80
    14plgContentKomento->onContentAfterDisplay()Same as call in the line below.
    13call_user_func_array()JROOT/libraries/joomla/event/event.php:69
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:159
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:117
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    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:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  39. Query Time: 0.52 ms After last query: 0.56 ms Query memory: 0.032 MB Memory before query: 8.096 MB Rows returned: 1
    SELECT a.id, a.title, a.alias, a.catid, a.created_by, a.created_by_alias, a.hits, c.title AS category_title, c.alias AS category_alias, u.name AS author, parent.id AS parent_id, parent.alias AS parent_alias 
      FROM `jos_content` AS a
      LEFT JOIN `jos_categories` AS c
      ON c.id = a.catid
      LEFT JOIN `jos_users` AS u
      ON u.id = a.created_by
      LEFT JOIN `jos_categories` AS parent
      ON parent.id = c.parent_id
      WHERE a.id = '71'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaconstPRIMARYPRIMARY4const1
    1SIMPLEcconstPRIMARYPRIMARY4const1
    1SIMPLEuconstPRIMARYPRIMARY4const0unique row not found
    1SIMPLEparentconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.03 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    System lock0.01 ms
    Waiting for query cache lock0.03 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.01 ms
    Waiting for query cache lock0.00 ms
    freeing items0.02 ms
    Waiting for query cache lock0.00 ms
    freeing items0.00 ms
    storing result in query cache0.00 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1650
    24JDatabaseDriver->loadObject()Same as call in the line below.
    23call_user_func_array()JROOT/components/com_komento/helpers/database.php:151
    22KomentoDatabaseJoomla15->__call()Same as call in the line below.
    21KomentoDatabaseJoomla30->loadObject()Same as call in the line below.
    20call_user_func_array()JROOT/components/com_komento/helpers/database.php:40
    19KomentoDatabaseHelper->__call()JROOT/components/com_komento/komento_plugins/com_content.php:54
    18KomentoDatabaseHelper->loadObject()JROOT/components/com_komento/komento_plugins/com_content.php:54
    17KomentoComcontent->load()JROOT/components/com_komento/helpers/helper.php:743
    16Komento::commentify()JROOT/plugins/content/komento/komento.php:166
    15plgContentKomento->execute()JROOT/plugins/content/komento/komento.php:80
    14plgContentKomento->onContentAfterDisplay()Same as call in the line below.
    13call_user_func_array()JROOT/libraries/joomla/event/event.php:69
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:159
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:117
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    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:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  40. Query Time: 0.63 ms After last query: 23.71 ms Query memory: 0.034 MB Memory before query: 8.423 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 (SELECT cat.id as id
      FROM jos_categories AS cat JOIN jos_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      LEFT JOIN 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,5)
      AND c.published = 1
      AND badcats.id is null
      AND s.id=31
      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_lenrefrowsExtra
    1PRIMARY<derived2>systemNULLNO INDEX KEY COULD BE USEDNULLNULL0const row not found
    1PRIMARYsconstPRIMARY,idx_left_rightPRIMARY4const1Using filesort
    1PRIMARYcALLcat_idx,idx_access,idx_left_rightNO INDEX KEY COULD BE USEDNULLNULL37Using where
    2DERIVEDparentrangecat_idx,idx_left_rightcat_idx203NULL2Using where; Using temporary; Using filesort
    2DERIVEDcatindexidx_left_rightidx_left_right8NULL37Using where; Using index; Using join buffer
    Profile
    StatusDuration
    starting0.02 ms
    Waiting for query cache lock0.01 ms
    checking query cache for query0.01 ms
    checking privileges on cached 0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    sending cached result to clien0.03 ms
    logging slow query0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    20JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/categories/categories.php:309
    19JCategories->_load()JROOT/libraries/legacy/categories/categories.php:184
    18JCategories->get()JROOT/components/com_content/helpers/route.php:44
    17ContentHelperRoute::getArticleRoute()JROOT/templates/theme3278/html/com_content/category/gallery_item.php:44
    16include JROOT/templates/theme3278/html/com_content/category/gallery_item.phpJROOT/libraries/legacy/view/legacy.php:670
    15JViewLegacy->loadTemplate()JROOT/templates/theme3278/html/com_content/category/gallery.php:131
    14include JROOT/templates/theme3278/html/com_content/category/gallery.phpJROOT/libraries/legacy/view/legacy.php:670
    13JViewLegacy->loadTemplate()JROOT/libraries/legacy/view/legacy.php:209
    12JViewLegacy->display()JROOT/libraries/legacy/view/category.php:233
    11JViewCategory->display()JROOT/components/com_content/views/category/view.html.php:258
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    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:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  41. Query Time: 1.63 ms After last query: 20.19 ms Query memory: 0.022 MB Memory before query: 8.405 MB Rows returned: 22
    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 <= '2019-02-22 22:08:50')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-02-22 22:08:50')
      AND m.access IN (1,1,5)
      AND m.client_id = 0
      AND (mm.menuid = 283 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLPRIMARY,published,newsfeedsNO INDEX KEY COULD BE USEDNULLNULL54Using where; Using filesort
    1SIMPLEmmrefPRIMARYPRIMARY4microbluemap05.m.id1Using where; Using index
    1SIMPLEerefelement_clientid,element_folder_clientidelement_clientid403microbluemap05.m.module,const1Using where
    Profile
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.07 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    System lock0.01 ms
    Waiting for query cache lock0.04 ms
    init0.05 ms
    optimizing0.02 ms
    statistics0.06 ms
    preparing0.02 ms
    executing0.00 ms
    Sorting result0.18 ms
    Sending data0.54 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    Waiting for query cache lock0.00 ms
    freeing items0.04 ms
    Waiting for query cache lock0.00 ms
    freeing items0.00 ms
    storing result in query cache0.13 ms
    logging slow query0.01 ms
    logging slow query0.01 ms
    Opening table0.01 ms
    System lock0.05 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    13JDatabaseDriver->loadObjectList()JROOT/libraries/cms/module/helper.php:409
    12JModuleHelper::getModuleList()JROOT/libraries/cms/module/helper.php:352
    11JModuleHelper::load()JROOT/libraries/cms/module/helper.php:84
    10JModuleHelper::getModules()JROOT/libraries/joomla/document/html.php:501
    9JDocumentHtml->countModules()JROOT/templates/theme3278/includes/includes.php:125
    8include_once JROOT/templates/theme3278/includes/includes.phpJROOT/templates/theme3278/index.php:2
    7require JROOT/templates/theme3278/index.phpJROOT/libraries/joomla/document/html.php:578
    6JDocumentHtml->_loadTemplate()JROOT/libraries/joomla/document/html.php:640
    5JDocumentHtml->_fetchTemplate()JROOT/libraries/joomla/document/html.php:455
    4JDocumentHtml->parse()JROOT/libraries/cms/application/cms.php:1054
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:745
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:263
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  42. Query Time: 0.45 ms After last query: 21.68 ms Query memory: 0.019 MB Memory before query: 8.855 MB Rows returned: 10
    Duplicate queries: #8
    SELECT * 
      FROM jos_loginradius_settings
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjos_loginradius_settingsALLNULLNO INDEX KEY COULD BE USEDNULLNULL10
    Profile
    StatusDuration
    starting0.02 ms
    Waiting for query cache lock0.01 ms
    checking query cache for query0.01 ms
    checking privileges on cached 0.00 ms
    checking permissions0.00 ms
    sending cached result to clien0.02 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1494
    12JDatabaseDriver->loadAssocList()JROOT/modules/mod_socialloginandsocialshare/helper.php:96
    11modSocialLoginAndSocialShareHelper::sociallogin_getsettings()JROOT/modules/mod_socialloginandsocialshare/mod_socialloginandsocialshare.php:19
    10include JROOT/modules/mod_socialloginandsocialshare/mod_socialloginandsocialshare.phpJROOT/libraries/cms/module/helper.php:190
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:411
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:702
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:477
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1068
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:745
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:263
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  43. Query Time: 5.12 ms After last query: 17.95 ms Query memory: 0.028 MB Memory before query: 9.844 MB Rows returned: 1
    SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
      FROM jos_content AS a
      LEFT JOIN jos_categories AS c
      on c.id = a.catid
      LEFT JOIN jos_users AS u
      on u.id = a.created_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
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM jos_categories AS cat JOIN jos_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published <= 0
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE a.id = 147
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-02-22 22:08:50')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-02-22 22:08:50')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1PRIMARY<derived2>systemNULLNO INDEX KEY COULD BE USEDNULLNULL0const row not found
    1PRIMARYaconstPRIMARYPRIMARY4const1
    1PRIMARYcconstPRIMARYPRIMARY4const1
    1PRIMARYuconstPRIMARYPRIMARY4const0unique row not found
    1PRIMARYparentconstPRIMARYPRIMARY4const1
    1PRIMARYvconstPRIMARYPRIMARY4const0unique row not found
    2DERIVEDparentrangecat_idx,idx_left_rightcat_idx203NULL1Using where; Using temporary; Using filesort
    2DERIVEDcatindexidx_left_rightidx_left_right8NULL37Using where; Using index; Using join buffer
    Profile
    StatusDuration
    starting0.02 ms
    Waiting for query cache lock0.01 ms
    checking query cache for query0.11 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.03 ms
    System lock0.04 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.01 ms
    Creating tmp table0.01 ms
    executing0.00 ms
    Copying to tmp table0.03 ms
    Sorting result0.01 ms
    Sending data0.00 ms
    removing tmp table0.00 ms
    Sending data0.00 ms
    Waiting for query cache lock0.00 ms
    Sending data4.08 ms
    init0.05 ms
    optimizing0.01 ms
    statistics0.07 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.03 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    removing tmp table0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    Waiting for query cache lock0.00 ms
    freeing items0.02 ms
    Waiting for query cache lock0.00 ms
    freeing items0.00 ms
    storing result in query cache0.00 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1650
    13JDatabaseDriver->loadObject()JROOT/components/com_content/models/article.php:159
    12ContentModelArticle->getItem()JROOT/modules/mod_articles_single/helper.php:26
    11modArticlesSingleHelper::getItem()JROOT/modules/mod_articles_single/mod_articles_single.php:13
    10include JROOT/modules/mod_articles_single/mod_articles_single.phpJROOT/libraries/cms/module/helper.php:190
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:411
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:702
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:477
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1068
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:745
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:263
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  44. Query Time: 0.36 ms After last query: 0.72 ms Query memory: 0.028 MB Memory before query: 9.891 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 (SELECT cat.id as id
      FROM jos_categories AS cat JOIN jos_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      LEFT JOIN 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,5)
      AND c.published = 1
      AND badcats.id is null
      AND s.id=2
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
      ORDER BY c.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1PRIMARY<derived2>systemNULLNO INDEX KEY COULD BE USEDNULLNULL0const row not found
    1PRIMARYsconstPRIMARY,idx_left_rightPRIMARY4const1Using filesort
    1PRIMARYcALLcat_idx,idx_access,idx_left_rightNO INDEX KEY COULD BE USEDNULLNULL37Using where
    2DERIVEDparentrangecat_idx,idx_left_rightcat_idx203NULL2Using where; Using temporary; Using filesort
    2DERIVEDcatindexidx_left_rightidx_left_right8NULL37Using where; Using index; Using join buffer
    Profile
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.01 ms
    checking privileges on cached 0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    sending cached result to clien0.02 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    15JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/categories/categories.php:309
    14JCategories->_load()JROOT/libraries/legacy/categories/categories.php:184
    13JCategories->get()JROOT/components/com_content/helpers/route.php:44
    12ContentHelperRoute::getArticleRoute()JROOT/modules/mod_articles_single/helper.php:30
    11modArticlesSingleHelper::getItem()JROOT/modules/mod_articles_single/mod_articles_single.php:13
    10include JROOT/modules/mod_articles_single/mod_articles_single.phpJROOT/libraries/cms/module/helper.php:190
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:411
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:702
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:477
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1068
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:745
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:263
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  45. Query Time: 0.24 ms After last query: 0.50 ms Query memory: 0.025 MB Memory before query: 9.916 MB Rows returned: 1
    SELECT alias
    
      FROM jos_content
      WHERE id=147
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjos_contentconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.00 ms
    checking privileges on cached 0.00 ms
    checking permissions0.00 ms
    sending cached result to clien0.01 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1728
    18JDatabaseDriver->loadResult()JROOT/components/com_content/router.php:118
    17ContentRouter->build()JROOT/libraries/cms/router/site.php:483
    16JRouterSite->buildSefRoute()JROOT/libraries/cms/router/site.php:452
    15JRouterSite->_buildSefRoute()JROOT/libraries/cms/router/router.php:280
    14JRouter->build()JROOT/libraries/cms/router/site.php:134
    13JRouterSite->build()JROOT/libraries/joomla/application/route.php:62
    12JRoute::_()JROOT/modules/mod_articles_single/helper.php:30
    11modArticlesSingleHelper::getItem()JROOT/modules/mod_articles_single/mod_articles_single.php:13
    10include JROOT/modules/mod_articles_single/mod_articles_single.phpJROOT/libraries/cms/module/helper.php:190
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:411
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:702
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:477
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1068
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:745
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:263
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  46. Query Time: 1.61 ms After last query: 4.05 ms Query memory: 0.028 MB Memory before query: 9.999 MB Rows returned: 1
    SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
      FROM jos_content AS a
      LEFT JOIN jos_categories AS c
      on c.id = a.catid
      LEFT JOIN jos_users AS u
      on u.id = a.created_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
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM jos_categories AS cat JOIN jos_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published <= 0
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE a.id = 148
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-02-22 22:08:50')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-02-22 22:08:50')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1PRIMARY<derived2>systemNULLNO INDEX KEY COULD BE USEDNULLNULL0const row not found
    1PRIMARYaconstPRIMARYPRIMARY4const1
    1PRIMARYcconstPRIMARYPRIMARY4const1
    1PRIMARYuconstPRIMARYPRIMARY4const0unique row not found
    1PRIMARYparentconstPRIMARYPRIMARY4const1
    1PRIMARYvconstPRIMARYPRIMARY4const0unique row not found
    2DERIVEDparentrangecat_idx,idx_left_rightcat_idx203NULL1Using where; Using temporary; Using filesort
    2DERIVEDcatindexidx_left_rightidx_left_right8NULL37Using where; Using index; Using join buffer
    Profile
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.08 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    System lock0.03 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    Creating tmp table0.01 ms
    executing0.00 ms
    Copying to tmp table0.02 ms
    Sorting result0.01 ms
    Sending data0.00 ms
    removing tmp table0.01 ms
    Sending data0.01 ms
    Waiting for query cache lock0.00 ms
    Sending data0.66 ms
    init0.04 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.03 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    removing tmp table0.00 ms
    closing tables0.01 ms
    freeing items0.01 ms
    Waiting for query cache lock0.01 ms
    freeing items0.02 ms
    Waiting for query cache lock0.00 ms
    freeing items0.00 ms
    storing result in query cache0.04 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1650
    13JDatabaseDriver->loadObject()JROOT/components/com_content/models/article.php:159
    12ContentModelArticle->getItem()JROOT/modules/mod_articles_single/helper.php:26
    11modArticlesSingleHelper::getItem()JROOT/modules/mod_articles_single/mod_articles_single.php:13
    10include JROOT/modules/mod_articles_single/mod_articles_single.phpJROOT/libraries/cms/module/helper.php:190
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:411
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:702
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:477
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1068
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:745
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:263
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  47. Query Time: 0.20 ms After last query: 0.59 ms Query memory: 0.025 MB Memory before query: 10.043 MB Rows returned: 1
    SELECT alias
    
      FROM jos_content
      WHERE id=148
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjos_contentconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.00 ms
    checking privileges on cached 0.00 ms
    checking permissions0.00 ms
    sending cached result to clien0.02 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1728
    18JDatabaseDriver->loadResult()JROOT/components/com_content/router.php:118
    17ContentRouter->build()JROOT/libraries/cms/router/site.php:483
    16JRouterSite->buildSefRoute()JROOT/libraries/cms/router/site.php:452
    15JRouterSite->_buildSefRoute()JROOT/libraries/cms/router/router.php:280
    14JRouter->build()JROOT/libraries/cms/router/site.php:134
    13JRouterSite->build()JROOT/libraries/joomla/application/route.php:62
    12JRoute::_()JROOT/modules/mod_articles_single/helper.php:30
    11modArticlesSingleHelper::getItem()JROOT/modules/mod_articles_single/mod_articles_single.php:13
    10include JROOT/modules/mod_articles_single/mod_articles_single.phpJROOT/libraries/cms/module/helper.php:190
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:411
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:702
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:477
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1068
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:745
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:263
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  48. Query Time: 0.42 ms After last query: 19.96 ms Query memory: 0.027 MB Memory before query: 10.669 MB Rows returned: 1
    SELECT id,parent_id 
      FROM jos_menu
      WHERE id = 283
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjos_menuconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    System lock0.01 ms
    Waiting for query cache lock0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    freeing items0.00 ms
    Waiting for query cache lock0.00 ms
    freeing items0.02 ms
    Waiting for query cache lock0.00 ms
    freeing items0.00 ms
    storing result in query cache0.07 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1650
    20JDatabaseDriver->loadObject()JROOT/modules/mod_icemegamenu/libs/menucore.php:83
    19IceMenuTree->getCurrentMenuItem()JROOT/modules/mod_icemegamenu/libs/menucore.php:67
    18IceMenuTree->__construct()JROOT/modules/mod_icemegamenu/helper.php:46
    17modIceMegamenuHelper::buildXML()Same as call in the line below.
    16call_user_func_array()JROOT/libraries/joomla/cache/controller/callback.php:152
    15JCacheControllerCallback->get()JROOT/libraries/joomla/cache/controller/callback.php:40
    14JCacheControllerCallback->call()JROOT/modules/mod_icemegamenu/helper.php:116
    13modIceMegamenuHelper->getXML()JROOT/modules/mod_icemegamenu/helper.php:155
    12modIceMegamenuHelper->render()JROOT/templates/theme3278/html/mod_icemegamenu/default.php:23
    11require JROOT/templates/theme3278/html/mod_icemegamenu/default.phpJROOT/modules/mod_icemegamenu/mod_icemegamenu.php:71
    10include JROOT/modules/mod_icemegamenu/mod_icemegamenu.phpJROOT/libraries/cms/module/helper.php:190
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:411
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:702
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:477
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1068
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:745
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:263
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  49. Query Time: 0.42 ms After last query: 0.19 ms Query memory: 0.027 MB Memory before query: 10.695 MB Rows returned: 1
    SELECT id,parent_id 
      FROM jos_menu
      WHERE id = 335
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjos_menuconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.01 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    System lock0.01 ms
    Waiting for query cache lock0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    freeing items0.00 ms
    Waiting for query cache lock0.00 ms
    freeing items0.02 ms
    Waiting for query cache lock0.00 ms
    freeing items0.00 ms
    storing result in query cache0.03 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1650
    20JDatabaseDriver->loadObject()JROOT/modules/mod_icemegamenu/libs/menucore.php:83
    19IceMenuTree->getCurrentMenuItem()JROOT/modules/mod_icemegamenu/libs/menucore.php:67
    18IceMenuTree->__construct()JROOT/modules/mod_icemegamenu/helper.php:46
    17modIceMegamenuHelper::buildXML()Same as call in the line below.
    16call_user_func_array()JROOT/libraries/joomla/cache/controller/callback.php:152
    15JCacheControllerCallback->get()JROOT/libraries/joomla/cache/controller/callback.php:40
    14JCacheControllerCallback->call()JROOT/modules/mod_icemegamenu/helper.php:116
    13modIceMegamenuHelper->getXML()JROOT/modules/mod_icemegamenu/helper.php:155
    12modIceMegamenuHelper->render()JROOT/templates/theme3278/html/mod_icemegamenu/default.php:23
    11require JROOT/templates/theme3278/html/mod_icemegamenu/default.phpJROOT/modules/mod_icemegamenu/mod_icemegamenu.php:71
    10include JROOT/modules/mod_icemegamenu/mod_icemegamenu.phpJROOT/libraries/cms/module/helper.php:190
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:411
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:702
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:477
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1068
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:745
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:263
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  50. Query Time: 0.28 ms After last query: 0.13 ms Query memory: 0.027 MB Memory before query: 10.721 MB Rows returned: 1
    SELECT id,parent_id 
      FROM jos_menu
      WHERE id = 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjos_menuconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.01 ms
    checking privileges on cached 0.00 ms
    checking permissions0.00 ms
    sending cached result to clien0.01 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1650
    20JDatabaseDriver->loadObject()JROOT/modules/mod_icemegamenu/libs/menucore.php:83
    19IceMenuTree->getCurrentMenuItem()JROOT/modules/mod_icemegamenu/libs/menucore.php:67
    18IceMenuTree->__construct()JROOT/modules/mod_icemegamenu/helper.php:46
    17modIceMegamenuHelper::buildXML()Same as call in the line below.
    16call_user_func_array()JROOT/libraries/joomla/cache/controller/callback.php:152
    15JCacheControllerCallback->get()JROOT/libraries/joomla/cache/controller/callback.php:40
    14JCacheControllerCallback->call()JROOT/modules/mod_icemegamenu/helper.php:116
    13modIceMegamenuHelper->getXML()JROOT/modules/mod_icemegamenu/helper.php:155
    12modIceMegamenuHelper->render()JROOT/templates/theme3278/html/mod_icemegamenu/default.php:23
    11require JROOT/templates/theme3278/html/mod_icemegamenu/default.phpJROOT/modules/mod_icemegamenu/mod_icemegamenu.php:71
    10include JROOT/modules/mod_icemegamenu/mod_icemegamenu.phpJROOT/libraries/cms/module/helper.php:190
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:411
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:702
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:477
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1068
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:745
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:263
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  51. Query Time: 0.46 ms After last query: 28.27 ms Query memory: 0.033 MB Memory before query: 10.983 MB Rows returned: 1
    SELECT distinct(m.id), title, module, position, content, showtitle, params 
      FROM jos_modules AS m
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.id in(226)
      AND m.published > 0
      ORDER BY position, ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmconstPRIMARY,publishedPRIMARY4const1Using temporary
    1SIMPLEmmrefPRIMARYPRIMARY4const1Using index; Distinct
    Profile
    StatusDuration
    starting0.02 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.01 ms
    checking privileges on cached 0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    sending cached result to clien0.02 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    24JDatabaseDriver->loadObjectList()JROOT/modules/mod_icemegamenu/libs/module_helper.php:174
    23IceModuleHelper->_getModules()JROOT/modules/mod_icemegamenu/libs/module_helper.php:43
    22IceModuleHelper->getContentByModule()JROOT/modules/mod_icemegamenu/libs/menucore.php:168
    21IceMenuTree->_getSubmenuByType()JROOT/modules/mod_icemegamenu/libs/menucore.php:286
    20IceMenuTree->_getLevelXML()JROOT/modules/mod_icemegamenu/libs/menucore.php:461
    19IceMenuTree->_getLevelXML()JROOT/modules/mod_icemegamenu/libs/menucore.php:142
    18IceMenuTree->toXML()JROOT/modules/mod_icemegamenu/helper.php:104
    17modIceMegamenuHelper::buildXML()Same as call in the line below.
    16call_user_func_array()JROOT/libraries/joomla/cache/controller/callback.php:152
    15JCacheControllerCallback->get()JROOT/libraries/joomla/cache/controller/callback.php:40
    14JCacheControllerCallback->call()JROOT/modules/mod_icemegamenu/helper.php:116
    13modIceMegamenuHelper->getXML()JROOT/modules/mod_icemegamenu/helper.php:155
    12modIceMegamenuHelper->render()JROOT/templates/theme3278/html/mod_icemegamenu/default.php:23
    11require JROOT/templates/theme3278/html/mod_icemegamenu/default.phpJROOT/modules/mod_icemegamenu/mod_icemegamenu.php:71
    10include JROOT/modules/mod_icemegamenu/mod_icemegamenu.phpJROOT/libraries/cms/module/helper.php:190
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:411
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:702
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:477
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1068
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:745
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:263
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  52. Query Time: 0.27 ms After last query: 4.37 ms Query memory: 0.033 MB Memory before query: 11.043 MB Rows returned: 1
    SELECT distinct(m.id), title, module, position, content, showtitle, params 
      FROM jos_modules AS m
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.id in(227)
      AND m.published > 0
      ORDER BY position, ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmconstPRIMARY,publishedPRIMARY4const1Using temporary
    1SIMPLEmmrefPRIMARYPRIMARY4const1Using index; Distinct
    Profile
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.01 ms
    checking privileges on cached 0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    sending cached result to clien0.02 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    24JDatabaseDriver->loadObjectList()JROOT/modules/mod_icemegamenu/libs/module_helper.php:174
    23IceModuleHelper->_getModules()JROOT/modules/mod_icemegamenu/libs/module_helper.php:43
    22IceModuleHelper->getContentByModule()JROOT/modules/mod_icemegamenu/libs/menucore.php:168
    21IceMenuTree->_getSubmenuByType()JROOT/modules/mod_icemegamenu/libs/menucore.php:286
    20IceMenuTree->_getLevelXML()JROOT/modules/mod_icemegamenu/libs/menucore.php:461
    19IceMenuTree->_getLevelXML()JROOT/modules/mod_icemegamenu/libs/menucore.php:142
    18IceMenuTree->toXML()JROOT/modules/mod_icemegamenu/helper.php:104
    17modIceMegamenuHelper::buildXML()Same as call in the line below.
    16call_user_func_array()JROOT/libraries/joomla/cache/controller/callback.php:152
    15JCacheControllerCallback->get()JROOT/libraries/joomla/cache/controller/callback.php:40
    14JCacheControllerCallback->call()JROOT/modules/mod_icemegamenu/helper.php:116
    13modIceMegamenuHelper->getXML()JROOT/modules/mod_icemegamenu/helper.php:155
    12modIceMegamenuHelper->render()JROOT/templates/theme3278/html/mod_icemegamenu/default.php:23
    11require JROOT/templates/theme3278/html/mod_icemegamenu/default.phpJROOT/modules/mod_icemegamenu/mod_icemegamenu.php:71
    10include JROOT/modules/mod_icemegamenu/mod_icemegamenu.phpJROOT/libraries/cms/module/helper.php:190
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:411
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:702
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:477
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1068
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:745
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:263
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  53. Query Time: 0.48 ms After last query: 3.79 ms Query memory: 0.033 MB Memory before query: 11.103 MB Rows returned: 1
    SELECT distinct(m.id), title, module, position, content, showtitle, params 
      FROM jos_modules AS m
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.id in(229)
      AND m.published > 0
      ORDER BY position, ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmconstPRIMARY,publishedPRIMARY4const1Using temporary
    1SIMPLEmmrefPRIMARYPRIMARY4const1Using index; Distinct
    Profile
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.01 ms
    checking privileges on cached 0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    sending cached result to clien0.02 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    24JDatabaseDriver->loadObjectList()JROOT/modules/mod_icemegamenu/libs/module_helper.php:174
    23IceModuleHelper->_getModules()JROOT/modules/mod_icemegamenu/libs/module_helper.php:43
    22IceModuleHelper->getContentByModule()JROOT/modules/mod_icemegamenu/libs/menucore.php:168
    21IceMenuTree->_getSubmenuByType()JROOT/modules/mod_icemegamenu/libs/menucore.php:286
    20IceMenuTree->_getLevelXML()JROOT/modules/mod_icemegamenu/libs/menucore.php:461
    19IceMenuTree->_getLevelXML()JROOT/modules/mod_icemegamenu/libs/menucore.php:142
    18IceMenuTree->toXML()JROOT/modules/mod_icemegamenu/helper.php:104
    17modIceMegamenuHelper::buildXML()Same as call in the line below.
    16call_user_func_array()JROOT/libraries/joomla/cache/controller/callback.php:152
    15JCacheControllerCallback->get()JROOT/libraries/joomla/cache/controller/callback.php:40
    14JCacheControllerCallback->call()JROOT/modules/mod_icemegamenu/helper.php:116
    13modIceMegamenuHelper->getXML()JROOT/modules/mod_icemegamenu/helper.php:155
    12modIceMegamenuHelper->render()JROOT/templates/theme3278/html/mod_icemegamenu/default.php:23
    11require JROOT/templates/theme3278/html/mod_icemegamenu/default.phpJROOT/modules/mod_icemegamenu/mod_icemegamenu.php:71
    10include JROOT/modules/mod_icemegamenu/mod_icemegamenu.phpJROOT/libraries/cms/module/helper.php:190
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:411
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:702
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:477
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1068
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:745
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:263
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  54. Query Time: 5.22 ms After last query: 5.70 ms Query memory: 0.053 MB Memory before query: 11.284 MB Rows returned: 1
    SELECT a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured,a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
      CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
      FROM 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
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM jos_categories AS cat JOIN jos_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id ) AS badcats
      ON badcats.id = c.id
      WHERE a.access IN (1,1,5)
      AND c.access IN (1,1,5)
      AND
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
      AND a.catid IN (36)
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-02-22 22:08:50')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-02-22 22:08:50')
      ORDER BY a.ordering ASC
      LIMIT 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1PRIMARY<derived2>systemNULLNO INDEX KEY COULD BE USEDNULLNULL0const row not found
    1PRIMARYcconstPRIMARY,idx_accessPRIMARY4const1Using filesort
    1PRIMARYarefidx_access,idx_catididx_catid4const3Using where
    1PRIMARYuaeq_refPRIMARYPRIMARY4microbluemap05.a.created_by1
    1PRIMARYuameq_refPRIMARYPRIMARY4microbluemap05.a.modified_by1Using index
    1PRIMARYparenteq_refPRIMARYPRIMARY4const1
    1PRIMARYveq_refPRIMARYPRIMARY4microbluemap05.a.id1
    2DERIVEDparentrangecat_idx,idx_left_rightcat_idx203NULL2Using where; Using temporary; Using filesort
    2DERIVEDcatindexidx_left_rightidx_left_right8NULL37Using where; Using index; Using join buffer
    Profile
    StatusDuration
    starting0.02 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.14 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.04 ms
    System lock0.05 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.02 ms
    Creating tmp table0.02 ms
    executing0.01 ms
    Copying to tmp table0.05 ms
    Sorting result0.02 ms
    Sending data0.01 ms
    removing tmp table0.01 ms
    Sending data0.01 ms
    Waiting for query cache lock0.00 ms
    Sending data3.52 ms
    init0.07 ms
    optimizing0.02 ms
    statistics0.08 ms
    preparing0.03 ms
    executing0.00 ms
    Sorting result0.18 ms
    Sending data0.09 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.00 ms
    removing tmp table0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    Waiting for query cache lock0.00 ms
    freeing items0.03 ms
    Waiting for query cache lock0.00 ms
    freeing items0.00 ms
    storing result in query cache0.00 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    32JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    31JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/model/legacy.php:312
    30JModelLegacy->_getList()JROOT/libraries/legacy/model/list.php:185
    29JModelList->getItems()JROOT/components/com_content/models/articles.php:566
    28ContentModelArticles->getItems()JROOT/modules/mod_articles_news_adv/helper.php:107
    27ModArticlesNewsAdvHelper::getList()JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:24
    26include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.phpJROOT/libraries/cms/module/helper.php:190
    25JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    24JDocumentRendererHtmlModule->render()JROOT/modules/mod_icemegamenu/libs/module_helper.php:123
    23IceModuleHelper->_renderModule()JROOT/modules/mod_icemegamenu/libs/module_helper.php:44
    22IceModuleHelper->getContentByModule()JROOT/modules/mod_icemegamenu/libs/menucore.php:168
    21IceMenuTree->_getSubmenuByType()JROOT/modules/mod_icemegamenu/libs/menucore.php:286
    20IceMenuTree->_getLevelXML()JROOT/modules/mod_icemegamenu/libs/menucore.php:461
    19IceMenuTree->_getLevelXML()JROOT/modules/mod_icemegamenu/libs/menucore.php:142
    18IceMenuTree->toXML()JROOT/modules/mod_icemegamenu/helper.php:104
    17modIceMegamenuHelper::buildXML()Same as call in the line below.
    16call_user_func_array()JROOT/libraries/joomla/cache/controller/callback.php:152
    15JCacheControllerCallback->get()JROOT/libraries/joomla/cache/controller/callback.php:40
    14JCacheControllerCallback->call()JROOT/modules/mod_icemegamenu/helper.php:116
    13modIceMegamenuHelper->getXML()JROOT/modules/mod_icemegamenu/helper.php:155
    12modIceMegamenuHelper->render()JROOT/templates/theme3278/html/mod_icemegamenu/default.php:23
    11require JROOT/templates/theme3278/html/mod_icemegamenu/default.phpJROOT/modules/mod_icemegamenu/mod_icemegamenu.php:71
    10include JROOT/modules/mod_icemegamenu/mod_icemegamenu.phpJROOT/libraries/cms/module/helper.php:190
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:411
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:702
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:477
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1068
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:745
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:263
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  55. Query Time: 0.38 ms After last query: 1.72 ms Query memory: 0.045 MB Memory before query: 11.367 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` = 145
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEtrefPRIMARY,tag_idx,idx_accesstag_idx1const4Using where
    1SIMPLEmrefidx_tag_typeidx_tag_type4microbluemap05.t.id203Using where
    Profile
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.01 ms
    checking privileges on cached 0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    sending cached result to clien0.02 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    31JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    30JDatabaseDriver->loadObjectList()JROOT/libraries/cms/helper/tags.php:426
    29JHelperTags->getItemTags()JROOT/components/com_content/models/articles.php:694
    28ContentModelArticles->getItems()JROOT/modules/mod_articles_news_adv/helper.php:107
    27ModArticlesNewsAdvHelper::getList()JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:24
    26include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.phpJROOT/libraries/cms/module/helper.php:190
    25JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    24JDocumentRendererHtmlModule->render()JROOT/modules/mod_icemegamenu/libs/module_helper.php:123
    23IceModuleHelper->_renderModule()JROOT/modules/mod_icemegamenu/libs/module_helper.php:44
    22IceModuleHelper->getContentByModule()JROOT/modules/mod_icemegamenu/libs/menucore.php:168
    21IceMenuTree->_getSubmenuByType()JROOT/modules/mod_icemegamenu/libs/menucore.php:286
    20IceMenuTree->_getLevelXML()JROOT/modules/mod_icemegamenu/libs/menucore.php:461
    19IceMenuTree->_getLevelXML()JROOT/modules/mod_icemegamenu/libs/menucore.php:142
    18IceMenuTree->toXML()JROOT/modules/mod_icemegamenu/helper.php:104
    17modIceMegamenuHelper::buildXML()Same as call in the line below.
    16call_user_func_array()JROOT/libraries/joomla/cache/controller/callback.php:152
    15JCacheControllerCallback->get()JROOT/libraries/joomla/cache/controller/callback.php:40
    14JCacheControllerCallback->call()JROOT/modules/mod_icemegamenu/helper.php:116
    13modIceMegamenuHelper->getXML()JROOT/modules/mod_icemegamenu/helper.php:155
    12modIceMegamenuHelper->render()JROOT/templates/theme3278/html/mod_icemegamenu/default.php:23
    11require JROOT/templates/theme3278/html/mod_icemegamenu/default.phpJROOT/modules/mod_icemegamenu/mod_icemegamenu.php:71
    10include JROOT/modules/mod_icemegamenu/mod_icemegamenu.phpJROOT/libraries/cms/module/helper.php:190
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:411
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:702
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:477
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1068
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:745
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:263
    1JApplicationCms->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  56. Query Time: 0.32 ms After last query: 0.33 ms Query memory: 0.046 MB Memory before query: 11.399 MB Rows returned: 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 (SELECT cat.id as id
      FROM jos_categories AS cat JOIN jos_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      LEFT JOIN 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,5)
      AND c.published = 1
      AND badcats.id is null
      AND s.id=36
      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_lenrefrowsExtra
    1PRIMARY<derived2>systemNULLNO INDEX KEY COULD BE USEDNULLNULL0const row not found
    1PRIMARYsconstPRIMARY,idx_left_rightPRIMARY4const1Using filesort
    1PRIMARYcALLcat_idx,idx_access,idx_left_rightNO INDEX KEY COULD BE USEDNULLNULL37Using where
    2DERIVEDparentrangecat_idx,idx_left_rightcat_idx203NULL2Using where; Using temporary; Using filesort
    2DERIVEDcatindexidx_left_rightidx_left_right8NULL37Using where; Using index; Using join buffer
    Profile
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.01 ms
    checking privileges on cached 0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    sending cached result to clien0.04 ms
    logging slow query0.01 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    32JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    31JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/categories/categories.php:309
    30JCategories->_load()JROOT/libraries/legacy/categories/categories.php:184
    29JCategories->get()JROOT/components/com_content/helpers/route.php:44
    28ContentHelperRoute::getArticleRoute()JROOT/modules/mod_articles_news_adv/helper.php:121
    27ModArticlesNewsAdvHelper::getList()JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:24
    26include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.phpJROOT/libraries/cms/module/helper.php:190
    25JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    24JDocumentRendererHtmlModule->render()JROOT/modules/mod_icemegamenu/libs/module_helper.php:123
    23IceModuleHelper->_renderModule()JROOT/modules/mod_icemegamenu/libs/module_helper.php:44
    22IceModuleHelper->getContentByModule()JROOT/modules/mod_icemegamenu/libs/menucore.php:168
    21IceMenuTree->_getSubmenuByType()JROOT/modules/mod_icemegamenu/libs/menucore.php:286
    20IceMenuTree->_getLevelXML()JROOT/modules/mod_icemegamenu/libs/menucore.php:461
    19IceMenuTree->_getLevelXML()JROOT/modules/mod_icemegamenu/libs/menucore.php:142
    18IceMenuTree->toXML()JROOT/modules/mod_icemegamenu/helper.php:104
    17modIceMegamenuHelper::buildXML()Same as call in the line below.
    16call_user_func