• 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
  • Galeria
  • Gallery 6

Galeria

22
25
Depositphotos_60104147_original
tumblr_ndyvrtul9d1tubinno1_1280
  • 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": 1550878222,
                "last": 1550878222,
                "now": 1550878222
            },
            "token": "l5s3rTO17WKsWJ3l1544DgNAWumth1TA"
        },
        "registry": {
            "com_slogin": {
                "return_url": "aHR0cDovL21pY3JvYmx1ZW1hcC5jb20uYnIvaW5kZXgucGhwL2dhbGxlcnkvZ2FsbGVyeS9nYWxsZXJ5LTY="
            }
        },
        "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.02 ms / 0.02 ms Memory: 0.445 MB / 0.44 MB Application: afterLoad
Time: 61.49 ms / 61.51 ms Memory: 1.554 MB / 2.00 MB Application: afterInitialise
Time: 105.68 ms / 167.19 ms Memory: 1.721 MB / 3.72 MB Application: afterRoute
Time: 13.68 ms / 180.87 ms Memory: 0.175 MB / 3.89 MB Application: beforeRenderComponent com_joomgallery
Time: 127.22 ms / 308.09 ms Memory: 3.301 MB / 7.19 MB Application: afterRenderComponent com_joomgallery
Time: 4.75 ms / 312.84 ms Memory: 0.042 MB / 7.24 MB Application: afterDispatch
Time: 5.93 ms / 318.77 ms Memory: 0.096 MB / 7.33 MB Application: beforeRenderModule mod_tm_olark_chat (Olark)
Time: 2.48 ms / 321.25 ms Memory: 0.012 MB / 7.34 MB Application: afterRenderModule mod_tm_olark_chat (Olark)
Time: 0.16 ms / 321.41 ms Memory: 0.000 MB / 7.34 MB Application: beforeRenderModule mod_slogin (Login form)
Time: 10.83 ms / 332.24 ms Memory: 0.255 MB / 7.60 MB Application: afterRenderModule mod_slogin (Login form)
Time: 0.21 ms / 332.45 ms Memory: 0.000 MB / 7.59 MB Application: beforeRenderModule mod_tm_style_switcher (TM Ajax Style Switcher)
Time: 9.51 ms / 341.95 ms Memory: 0.193 MB / 7.78 MB Application: Start JAccess::getAssetRules Old (1)
Time: 1.47 ms / 343.43 ms Memory: 0.037 MB / 7.82 MB Application: Finish JAccess::getAssetRules Old (1)
Time: 0.11 ms / 343.54 ms Memory: 0.000 MB / 7.81 MB Application: Start JAccess::preload(components)
Time: 5.64 ms / 349.18 ms Memory: 0.360 MB / 8.17 MB Application: Finish JAccess::preload(components)
Time: 0.16 ms / 349.34 ms Memory: 0.000 MB / 8.13 MB Application: afterRenderModule mod_tm_style_switcher (TM Ajax Style Switcher)
Time: 0.18 ms / 349.52 ms Memory: 0.000 MB / 8.13 MB Application: beforeRenderModule mod_socialloginandsocialshare (Login or register)
Time: 14.32 ms / 363.85 ms Memory: 0.704 MB / 8.83 MB Application: afterRenderModule mod_socialloginandsocialshare (Login or register)
Time: 0.25 ms / 364.09 ms Memory: 0.000 MB / 8.83 MB Application: beforeRenderModule mod_menu (Footer logo)
Time: 2.96 ms / 367.05 ms Memory: 0.069 MB / 8.90 MB Application: afterRenderModule mod_menu (Footer logo)
Time: 0.11 ms / 367.16 ms Memory: 0.000 MB / 8.89 MB Application: beforeRenderModule mod_articles_single (Endereço)
Time: 33.70 ms / 400.86 ms Memory: 0.730 MB / 9.62 MB Application: afterRenderModule mod_articles_single (Endereço)
Time: 0.18 ms / 401.04 ms Memory: 0.000 MB / 9.60 MB Application: beforeRenderModule mod_articles_single (Telefone)
Time: 7.89 ms / 408.93 ms Memory: 0.070 MB / 9.67 MB Application: afterRenderModule mod_articles_single (Telefone)
Time: 0.23 ms / 409.16 ms Memory: 0.000 MB / 9.65 MB Application: beforeRenderModule mod_menu (Siga-nos)
Time: 3.92 ms / 413.09 ms Memory: 0.019 MB / 9.67 MB Application: afterRenderModule mod_menu (Siga-nos)
Time: 0.27 ms / 413.36 ms Memory: 0.000 MB / 9.66 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 13.16 ms / 426.52 ms Memory: 0.061 MB / 9.72 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 0.31 ms / 426.83 ms Memory: 0.000 MB / 9.72 MB Application: beforeRenderModule mod_icemegamenu (Main menu)
Time: 28.86 ms / 455.69 ms Memory: 0.867 MB / 10.59 MB Application: beforeRenderModule mod_menu (SUPPORT)
Time: 4.48 ms / 460.17 ms Memory: 0.021 MB / 10.61 MB Application: afterRenderModule mod_menu (SUPPORT)
Time: 1.89 ms / 462.06 ms Memory: 0.039 MB / 10.65 MB Application: beforeRenderModule mod_menu (DEVELOPERS)
Time: 4.98 ms / 467.04 ms Memory: 0.020 MB / 10.67 MB Application: afterRenderModule mod_menu (DEVELOPERS)
Time: 1.93 ms / 468.97 ms Memory: 0.045 MB / 10.71 MB Application: beforeRenderModule mod_articles_news_adv (Price)
Time: 19.49 ms / 488.46 ms Memory: 0.521 MB / 11.23 MB Application: afterRenderModule mod_articles_news_adv (Price)
Time: 77.96 ms / 566.41 ms Memory: 0.000 MB / 11.23 MB Application: afterRenderModule mod_icemegamenu (Main menu)
Time: 0.35 ms / 566.77 ms Memory: 0.000 MB / 11.22 MB Application: beforeRenderModule mod_menu (Info)
Time: 3.25 ms / 570.02 ms Memory: 0.018 MB / 11.24 MB Application: afterRenderModule mod_menu (Info)
Time: 9.40 ms / 579.42 ms Memory: 0.151 MB / 11.39 MB Application: afterRender

Database queries total: 163.15 ms

Memory Usage

12.39 MB (12,989,520 Bytes)

Database Queries

58 Queries Logged 163.15 ms


12 duplicate found!

2 duplicates: #8  #42
2 duplicates: #10  #43
2 duplicates: #24  #51
6 duplicates: #25  #26  #30  #32  #34  #36
  1. Query Time: 0.58 ms Query memory: 0.018 MB Memory before query: 0.953 MB Rows returned: 0
    SELECT `data`
    
      FROM `jos_session`
      WHERE `session_id` = '0fe63b333e0ddb690f13636fe67be1b9'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjos_sessionconstPRIMARYPRIMARY766const1
    Profile
    StatusDuration
    starting0.03 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.03 ms
    checking permissions0.01 ms
    Opening tables0.04 ms
    System lock0.03 ms
    Waiting for query cache lock0.03 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.01 ms
    executing0.01 ms
    end0.00 ms
    query end0.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.03 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.54 ms After last query: 2.89 ms Query memory: 0.012 MB Memory before query: 1.020 MB Rows returned: 0
    SELECT `session_id`
    
      FROM `jos_session`
      WHERE `session_id` = '0fe63b333e0ddb690f13636fe67be1b9'
      LIMIT 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjos_sessionconstPRIMARYPRIMARY766const1Using index
    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.02 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.09 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.00 ms
    freeing items0.03 ms
    Waiting for query cache lock0.00 ms
    freeing items0.00 ms
    storing result in query cache0.02 ms
    logging slow query0.00 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: 0.82 ms After last query: 0.21 ms Query memory: 0.009 MB Memory before query: 1.032 MB
    INSERT INTO `jos_session`
    (`session_id`, `client_id`, `time`) 
      VALUES ('0fe63b333e0ddb690f13636fe67be1b9', 0, '1550878222')
    Explain
    EXPLAIN not possible on query: INSERT INTO `jos_session` (`session_id`, `client_id`, `time`) VALUES ('0fe63b333e0ddb690f13636fe67be1b9', 0, '1550878222')
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    System lock0.00 ms
    init0.01 ms
    update0.06 ms
    Waiting for query cache lock0.00 ms
    update0.46 ms
    end0.01 ms
    query end0.03 ms
    closing tables0.01 ms
    freeing items0.02 ms
    logging slow query0.00 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: 1.01 ms After last query: 2.73 ms Query memory: 0.018 MB Memory before query: 1.116 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.01 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.02 ms
    Waiting for query cache lock0.02 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.02 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.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
    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.52 ms After last query: 1.47 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.00 ms
    checking query cache for query0.01 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
    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.23 ms After last query: 0.26 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.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
    sending cached result to clien0.02 ms
    logging slow query0.01 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.02 ms After last query: 0.32 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.05 ms
    checking permissions0.01 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.02 ms
    executing0.00 ms
    Sorting result0.24 ms
    Sending data0.17 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.03 ms
    Waiting for query cache lock0.01 ms
    freeing items0.00 ms
    storing result in query cache2.08 ms
    logging slow query0.01 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: 10.14 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.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.03 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: 82.54 ms After last query: 5.68 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.02 ms
    Waiting for query cache lock0.01 ms
    checking query cache for query0.10 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    System lock0.01 ms
    Waiting for query cache lock0.03 ms
    init0.04 ms
    optimizing0.02 ms
    statistics0.06 ms
    preparing0.02 ms
    executing0.00 ms
    Sorting result0.37 ms
    Sending data0.23 ms
    Waiting for query cache lock0.01 ms
    Sending data0.27 ms
    Waiting for query cache lock0.01 ms
    Sending data0.24 ms
    Waiting for query cache lock0.01 ms
    Sending data0.29 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
    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.79 ms After last query: 19.91 ms Query memory: 0.017 MB Memory before query: 3.715 MB Rows returned: 1
    Duplicate queries: #43
    SELECT cid
    
      FROM jos_joomgallery_catg
      WHERE alias = 'gallery/gallery-6'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjos_joomgallery_catgALLNULLNO INDEX KEY COULD BE USEDNULLNULL8Using where
    Profile
    StatusDuration
    starting0.04 ms
    Waiting for query cache lock0.01 ms
    checking query cache for query0.06 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    System lock0.01 ms
    Waiting for query cache lock0.03 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.06 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.01 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1728
    12JDatabaseDriver->loadResult()JROOT/components/com_joomgallery/helpers/routing.php:44
    11JoomRouting::getId()JROOT/components/com_joomgallery/router.php:499
    10JoomGalleryParseRoute()JROOT/libraries/cms/component/router/legacy.php:104
    9JComponentRouterLegacy->parse()JROOT/libraries/cms/router/site.php:395
    8JRouterSite->parseSefRoute()JROOT/libraries/cms/router/router.php:479
    7JRouter->_parseSefRoute()JROOT/libraries/cms/router/router.php:234
    6JRouter->parse()JROOT/libraries/cms/router/site.php:118
    5JRouterSite->parse()JROOT/libraries/cms/application/cms.php:1098
    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.]

  11. Query Time: 0.72 ms After last query: 0.96 ms Query memory: 0.019 MB Memory before query: 3.745 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.01 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.02 ms
    init0.01 ms
    optimizing0.03 ms
    statistics0.09 ms
    preparing0.01 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.01 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.]

  12. Query Time: 4.99 ms After last query: 0.40 ms Query memory: 0.012 MB Memory before query: 3.747 MB
    UPDATE `jos_extensions`
    
      SET `params` = '{\"mediaversion\":\"1e11db57acf2fa262c0fe8aec2d7227b\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    EXPLAIN not possible on query: UPDATE `jos_extensions` SET `params` = '{\"mediaversion\":\"1e11db57acf2fa262c0fe8aec2d7227b\"}' WHERE `type` = 'library' AND `element` = 'joomla'
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    System lock0.01 ms
    init0.05 ms
    Updating0.06 ms
    end0.01 ms
    Waiting for query cache lock0.00 ms
    end4.39 ms
    query end0.10 ms
    closing tables0.02 ms
    freeing items0.04 ms
    logging slow query0.01 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.]

  13. Query Time: 0.47 ms After last query: 2.37 ms Query memory: 0.014 MB Memory before query: 3.828 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.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
    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.]

  14. Query Time: 0.94 ms After last query: 0.80 ms Query memory: 0.010 MB Memory before query: 3.850 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.01 ms
    checking query cache for query0.07 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    System lock0.01 ms
    Waiting for query cache lock0.03 ms
    init0.03 ms
    optimizing0.02 ms
    statistics0.07 ms
    preparing0.03 ms
    executing0.01 ms
    Sending data0.10 ms
    end0.01 ms
    query end0.03 ms
    closing tables0.01 ms
    freeing items0.01 ms
    Waiting for query cache lock0.00 ms
    freeing items0.03 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
    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.]

  15. Query Time: 7.65 ms After last query: 10.36 ms Query memory: 0.049 MB Memory before query: 4.467 MB Rows returned: 294
    SHOW FULL COLUMNS 
      FROM `jos_joomgallery_config`
    Explain
    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `jos_joomgallery_config`
    Profile
    StatusDuration
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.02 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.02 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
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.02 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.02 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.02 ms
    Sending data1.14 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.00 ms
    removing tmp table0.22 ms
    closing tables0.01 ms
    freeing items0.03 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    18JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/database/driver/mysqli.php:440
    17JDatabaseDriverMysqli->getTableColumns()JROOT/libraries/joomla/table/table.php:241
    16JTable->getFields()JROOT/libraries/joomla/table/table.php:162
    15JTable->__construct()JROOT/administrator/components/com_joomgallery/tables/joomgalleryconfig.php:332
    14TableJoomgalleryConfig->TableJoomGalleryConfig()JROOT/libraries/joomla/table/table.php:304
    13JTable::getInstance()JROOT/administrator/components/com_joomgallery/helpers/config.php:359
    12JoomConfig->__construct()JROOT/administrator/components/com_joomgallery/helpers/config.php:422
    11JoomConfig::getInstance()JROOT/components/com_joomgallery/helpers/ambit.php:147
    10JoomAmbit->__construct()JROOT/components/com_joomgallery/helpers/ambit.php:220
    9JoomAmbit::getInstance()JROOT/components/com_joomgallery/controller.php:71
    8JoomGalleryController->__construct()JROOT/libraries/legacy/controller/legacy.php:306
    7JControllerLegacy::getInstance()JROOT/components/com_joomgallery/joomgallery.php:38
    6require_once JROOT/components/com_joomgallery/joomgallery.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: 22.77 ms After last query: 6.19 ms Query memory: 0.101 MB Memory before query: 5.156 MB Rows returned: 1
    SELECT *
    
      FROM jos_joomgallery_config
      WHERE `id` = '1'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjos_joomgallery_configconstPRIMARYPRIMARY4const1
    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.10 ms
    logging slow query0.01 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1453
    14JDatabaseDriver->loadAssoc()JROOT/libraries/joomla/table/table.php:715
    13JTable->load()JROOT/administrator/components/com_joomgallery/helpers/config.php:360
    12JoomConfig->__construct()JROOT/administrator/components/com_joomgallery/helpers/config.php:422
    11JoomConfig::getInstance()JROOT/components/com_joomgallery/helpers/ambit.php:147
    10JoomAmbit->__construct()JROOT/components/com_joomgallery/helpers/ambit.php:220
    9JoomAmbit::getInstance()JROOT/components/com_joomgallery/controller.php:71
    8JoomGalleryController->__construct()JROOT/libraries/legacy/controller/legacy.php:306
    7JControllerLegacy::getInstance()JROOT/components/com_joomgallery/joomgallery.php:38
    6require_once JROOT/components/com_joomgallery/joomgallery.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: 1.95 ms After last query: 15.71 ms Query memory: 0.026 MB Memory before query: 5.953 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 23:30:22')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-02-22 23:30:22')
      AND m.access IN (1,1,5)
      AND m.client_id = 0
      AND (mm.menuid = 203 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.06 ms
    Waiting for query cache lock0.01 ms
    checking query cache for query0.17 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    Opening tables0.04 ms
    System lock0.01 ms
    Waiting for query cache lock0.04 ms
    init0.05 ms
    optimizing0.03 ms
    statistics0.08 ms
    preparing0.07 ms
    executing0.02 ms
    Sorting result0.24 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.05 ms
    Waiting for query cache lock0.00 ms
    freeing items0.00 ms
    storing result in query cache0.00 ms
    logging slow query0.00 ms
    logging slow query0.01 ms
    Opening table0.02 ms
    System lock0.06 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    16JDatabaseDriver->loadObjectList()JROOT/libraries/cms/module/helper.php:409
    15JModuleHelper::getModuleList()JROOT/libraries/cms/module/helper.php:352
    14JModuleHelper::load()JROOT/libraries/cms/module/helper.php:84
    13JModuleHelper::getModules()JROOT/components/com_joomgallery/helpers/helper.php:499
    12JoomHelper::getModules()JROOT/components/com_joomgallery/helpers/helper.php:535
    11JoomHelper::getRenderedModules()JROOT/components/com_joomgallery/views/category/view.html.php:39
    10JoomGalleryViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_joomgallery/controller.php:100
    8JoomGalleryController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_joomgallery/joomgallery.php:41
    6require_once JROOT/components/com_joomgallery/joomgallery.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: 0.32 ms After last query: 0.94 ms Query memory: 0.021 MB Memory before query: 6.028 MB Rows returned: 7
    SELECT c.cid, c.parent_id, c.name, c.access, c.published, c.hidden, c.owner
    
      FROM jos_joomgallery_catg AS c
      WHERE lft > 0
      AND c.published = 1
      AND c.access IN (1,1,5)
      AND (c.password = '' OR c.cid IN (0))
      ORDER BY c.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEcALLPRIMARYNO INDEX KEY COULD BE USEDNULLNULL8Using 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.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
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    13JDatabaseDriver->loadObjectList()JROOT/components/com_joomgallery/helpers/ambit.php:489
    12JoomAmbit->getCategoryStructure()JROOT/components/com_joomgallery/helpers/helper.php:786
    11JoomHelper::getNumberOfImgHits()JROOT/components/com_joomgallery/views/category/view.html.php:65
    10JoomGalleryViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_joomgallery/controller.php:100
    8JoomGalleryController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_joomgallery/joomgallery.php:41
    6require_once JROOT/components/com_joomgallery/joomgallery.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: 0.30 ms After last query: 0.41 ms Query memory: 0.019 MB Memory before query: 6.057 MB Rows returned: 6
    SELECT catid, COUNT(id) as piccount, SUM(hits) as hitcount
    
      FROM jos_joomgallery
      WHERE approved = 1
      AND published = 1
      AND hidden = 0
      AND access IN (1,1,5)
      GROUP BY catid
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjos_joomgalleryindexNULLidx_catid4NULL34Using 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
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    13JDatabaseDriver->loadObjectList()JROOT/components/com_joomgallery/helpers/ambit.php:505
    12JoomAmbit->getCategoryStructure()JROOT/components/com_joomgallery/helpers/helper.php:786
    11JoomHelper::getNumberOfImgHits()JROOT/components/com_joomgallery/views/category/view.html.php:65
    10JoomGalleryViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_joomgallery/controller.php:100
    8JoomGalleryController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_joomgallery/joomgallery.php:41
    6require_once JROOT/components/com_joomgallery/joomgallery.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.50 ms After last query: 0.59 ms Query memory: 0.020 MB Memory before query: 6.086 MB Rows returned: 1
    SELECT COUNT(*)
    
      FROM jos_joomgallery_catg AS c
      WHERE c.published = 1
      AND c.hidden = 0
      AND c.parent_id = 8
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEcrefidx_parent_ididx_parent_id4const1Using where
    Profile
    StatusDuration
    starting0.01 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.02 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.01 ms
    executing0.01 ms
    Sending data0.02 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.02 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1728
    14JDatabaseDriver->loadResult()JROOT/libraries/legacy/model/legacy.php:341
    13JModelLegacy->_getListCount()JROOT/components/com_joomgallery/models/category.php:163
    12JoomGalleryModelCategory->getTotalCategories()JROOT/libraries/legacy/view/legacy.php:401
    11JViewLegacy->get()JROOT/components/com_joomgallery/views/category/view.html.php:74
    10JoomGalleryViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_joomgallery/controller.php:100
    8JoomGalleryController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_joomgallery/joomgallery.php:41
    6require_once JROOT/components/com_joomgallery/joomgallery.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.62 ms After last query: 8.34 ms Query memory: 0.020 MB Memory before query: 6.652 MB Rows returned: 1
    SELECT COUNT(*)
    
      FROM jos_joomgallery AS a
      LEFT JOIN jos_joomgallery_catg AS c
      ON c.cid = a.catid
      WHERE a.published = 1
      AND a.catid = 8
      AND a.approved = 1
      AND a.hidden = 0
      AND a.access IN (1,1,5)
      AND c.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEcconstPRIMARYPRIMARY4const1
    1SIMPLEarefidx_catididx_catid4const4Using 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.02 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.01 ms
    Sending data0.03 ms
    end0.01 ms
    query end0.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.01 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1728
    14JDatabaseDriver->loadResult()JROOT/libraries/legacy/model/legacy.php:341
    13JModelLegacy->_getListCount()JROOT/components/com_joomgallery/models/category.php:280
    12JoomGalleryModelCategory->getTotalImages()JROOT/libraries/legacy/view/legacy.php:401
    11JViewLegacy->get()JROOT/components/com_joomgallery/views/category/view.html.php:143
    10JoomGalleryViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_joomgallery/controller.php:100
    8JoomGalleryController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_joomgallery/joomgallery.php:41
    6require_once JROOT/components/com_joomgallery/joomgallery.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: 0.93 ms After last query: 0.69 ms Query memory: 0.034 MB Memory before query: 6.663 MB Rows returned: 4
    SELECT *, a.owner AS owner, ROUND(LEAST(IF(imgvotes > 0, a.imgvotesum/a.imgvotes, 0.0), 5), 2)AS rating
    
      FROM jos_joomgallery AS a
      LEFT JOIN jos_joomgallery_catg AS c
      ON c.cid = a.catid
      WHERE a.published = 1
      AND a.catid = 8
      AND a.approved = 1
      AND a.hidden = 0
      AND a.access IN (1,1,5)
      AND c.access IN (1,1,5)
      ORDER BY a.ordering ASC,a.imgdate DESC,a.imgtitle DESC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEcconstPRIMARYPRIMARY4const1Using filesort
    1SIMPLEarefidx_catididx_catid4const4Using where
    Profile
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.05 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    Opening tables0.06 ms
    System lock0.01 ms
    Waiting for query cache lock0.02 ms
    init0.04 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.02 ms
    executing0.00 ms
    Sorting result0.04 ms
    Sending data0.07 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.03 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
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    15JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/model/legacy.php:312
    14JModelLegacy->_getList()JROOT/components/com_joomgallery/models/category.php:564
    13JoomGalleryModelCategory->_loadImages()JROOT/components/com_joomgallery/models/category.php:219
    12JoomGalleryModelCategory->getImages()JROOT/libraries/legacy/view/legacy.php:401
    11JViewLegacy->get()JROOT/components/com_joomgallery/views/category/view.html.php:192
    10JoomGalleryViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_joomgallery/controller.php:100
    8JoomGalleryController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_joomgallery/joomgallery.php:41
    6require_once JROOT/components/com_joomgallery/joomgallery.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.50 ms After last query: 0.93 ms Query memory: 0.022 MB Memory before query: 6.716 MB Rows returned: 1
    SELECT cid, name, parent_id, description, password, owner, metakey, metadesc, params
    
      FROM jos_joomgallery_catg
      WHERE cid = 8
      AND published = 1
      AND access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjos_joomgallery_catgconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    System lock0.04 ms
    Waiting for query cache lock0.03 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.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
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1650
    14JDatabaseDriver->loadObject()JROOT/components/com_joomgallery/models/category.php:453
    13JoomGalleryModelCategory->_loadCategory()JROOT/components/com_joomgallery/models/category.php:127
    12JoomGalleryModelCategory->getCategory()JROOT/libraries/legacy/view/legacy.php:401
    11JViewLegacy->get()JROOT/components/com_joomgallery/views/category/view.html.php:239
    10JoomGalleryViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_joomgallery/controller.php:100
    8JoomGalleryController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_joomgallery/joomgallery.php:41
    6require_once JROOT/components/com_joomgallery/joomgallery.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.33 ms After last query: 0.72 ms Query memory: 0.024 MB Memory before query: 6.744 MB Rows returned: 1
    Duplicate queries: #51
    SELECT alias
    
      FROM jos_joomgallery_catg
      WHERE cid = 2
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjos_joomgallery_catgconstPRIMARYPRIMARY4const1
    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
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1728
    18JDatabaseDriver->loadResult()JROOT/components/com_joomgallery/router.php:310
    17JoomGalleryBuildRoute()JROOT/libraries/cms/component/router/legacy.php:68
    16JComponentRouterLegacy->build()JROOT/libraries/cms/router/site.php:483
    15JRouterSite->buildSefRoute()JROOT/libraries/cms/router/site.php:452
    14JRouterSite->_buildSefRoute()JROOT/libraries/cms/router/router.php:280
    13JRouter->build()JROOT/libraries/cms/router/site.php:134
    12JRouterSite->build()JROOT/libraries/joomla/application/route.php:62
    11JRoute::_()JROOT/components/com_joomgallery/views/category/view.html.php:254
    10JoomGalleryViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_joomgallery/controller.php:100
    8JoomGalleryController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_joomgallery/joomgallery.php:41
    6require_once JROOT/components/com_joomgallery/joomgallery.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.36 ms After last query: 2.76 ms Query memory: 0.024 MB Memory before query: 6.791 MB Rows returned: 1
    Duplicate queries: #26  #30  #32  #34  #36
    SELECT alias
    
      FROM jos_joomgallery_catg
      WHERE cid = 8
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjos_joomgallery_catgconstPRIMARYPRIMARY4const1
    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
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1728
    18JDatabaseDriver->loadResult()JROOT/components/com_joomgallery/router.php:310
    17JoomGalleryBuildRoute()JROOT/libraries/cms/component/router/legacy.php:68
    16JComponentRouterLegacy->build()JROOT/libraries/cms/router/site.php:483
    15JRouterSite->buildSefRoute()JROOT/libraries/cms/router/site.php:452
    14JRouterSite->_buildSefRoute()JROOT/libraries/cms/router/router.php:280
    13JRouter->build()JROOT/libraries/cms/router/site.php:134
    12JRouterSite->build()JROOT/libraries/joomla/application/route.php:62
    11JRoute::_()JROOT/components/com_joomgallery/views/category/view.html.php:368
    10JoomGalleryViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_joomgallery/controller.php:100
    8JoomGalleryController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_joomgallery/joomgallery.php:41
    6require_once JROOT/components/com_joomgallery/joomgallery.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.37 ms After last query: 0.73 ms Query memory: 0.024 MB Memory before query: 6.818 MB Rows returned: 1
    Duplicate queries: #25  #30  #32  #34  #36
    SELECT alias
    
      FROM jos_joomgallery_catg
      WHERE cid = 8
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjos_joomgallery_catgconstPRIMARYPRIMARY4const1
    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
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1728
    18JDatabaseDriver->loadResult()JROOT/components/com_joomgallery/router.php:310
    17JoomGalleryBuildRoute()JROOT/libraries/cms/component/router/legacy.php:68
    16JComponentRouterLegacy->build()JROOT/libraries/cms/router/site.php:483
    15JRouterSite->buildSefRoute()JROOT/libraries/cms/router/site.php:452
    14JRouterSite->_buildSefRoute()JROOT/libraries/cms/router/router.php:280
    13JRouter->build()JROOT/libraries/cms/router/site.php:134
    12JRouterSite->build()JROOT/libraries/joomla/application/route.php:62
    11JRoute::_()JROOT/components/com_joomgallery/views/category/view.html.php:370
    10JoomGalleryViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_joomgallery/controller.php:100
    8JoomGalleryController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_joomgallery/joomgallery.php:41
    6require_once JROOT/components/com_joomgallery/joomgallery.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.63 ms After last query: 0.67 ms Query memory: 0.026 MB Memory before query: 6.842 MB Rows returned: 0
    SELECT c.*
    
      FROM jos_joomgallery_catg AS c
      WHERE c.published = 1
      AND c.hidden = 0
      AND c.parent_id = 8
      ORDER BY c.lft ASC
      LIMIT 9
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEcrefidx_parent_ididx_parent_id4const1Using where; Using filesort
    Profile
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.00 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.02 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.02 ms
    executing0.01 ms
    Sorting result0.03 ms
    Sending data0.03 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.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/model/legacy.php:312
    14JModelLegacy->_getList()JROOT/components/com_joomgallery/models/category.php:492
    13JoomGalleryModelCategory->_loadCategories()JROOT/components/com_joomgallery/models/category.php:143
    12JoomGalleryModelCategory->getCategories()JROOT/libraries/legacy/view/legacy.php:401
    11JViewLegacy->get()JROOT/components/com_joomgallery/views/category/view.html.php:435
    10JoomGalleryViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_joomgallery/controller.php:100
    8JoomGalleryController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_joomgallery/joomgallery.php:41
    6require_once JROOT/components/com_joomgallery/joomgallery.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.29 ms After last query: 0.33 ms Query memory: 0.019 MB Memory before query: 6.863 MB Rows returned: 1
    SELECT catpath
    
      FROM jos_joomgallery_catg
      WHERE cid = 8
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjos_joomgallery_catgconstPRIMARYPRIMARY4const1
    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
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1728
    13JDatabaseDriver->loadResult()JROOT/components/com_joomgallery/helpers/helper.php:141
    12JoomHelper::getCatPath()JROOT/components/com_joomgallery/helpers/ambit.php:338
    11JoomAmbit->getImg()JROOT/components/com_joomgallery/views/category/view.html.php:763
    10JoomGalleryViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_joomgallery/controller.php:100
    8JoomGalleryController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_joomgallery/joomgallery.php:41
    6require_once JROOT/components/com_joomgallery/joomgallery.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: 0.89 ms After last query: 32.38 ms Query memory: 0.032 MB Memory before query: 7.095 MB Rows returned: 1
    SELECT catid, alias
    
      FROM jos_joomgallery
      WHERE id = 104
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjos_joomgalleryconstPRIMARYPRIMARY4const1
    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.03 ms
    System lock0.01 ms
    Waiting for query cache lock0.03 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.01 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    Waiting for query cache lock0.02 ms
    freeing items0.04 ms
    Waiting for query cache lock0.01 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
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1453
    24JDatabaseDriver->loadAssoc()JROOT/components/com_joomgallery/router.php:327
    23JoomGalleryBuildRoute()JROOT/libraries/cms/component/router/legacy.php:68
    22JComponentRouterLegacy->build()JROOT/libraries/cms/router/site.php:483
    21JRouterSite->buildSefRoute()JROOT/libraries/cms/router/site.php:452
    20JRouterSite->_buildSefRoute()JROOT/libraries/cms/router/router.php:280
    19JRouter->build()JROOT/libraries/cms/router/site.php:134
    18JRouterSite->build()JROOT/libraries/joomla/application/route.php:62
    17JRoute::_()JROOT/templates/theme3278/html/com_joomgallery/category/default_images.php:36
    16include JROOT/templates/theme3278/html/com_joomgallery/category/default_images.phpJROOT/libraries/legacy/view/legacy.php:670
    15JViewLegacy->loadTemplate()JROOT/components/com_joomgallery/views/category/tmpl/default.php:11
    14include JROOT/components/com_joomgallery/views/category/tmpl/default.phpJROOT/libraries/legacy/view/legacy.php:670
    13JViewLegacy->loadTemplate()JROOT/libraries/legacy/view/legacy.php:209
    12JViewLegacy->display()JROOT/components/com_joomgallery/view.php:171
    11JoomGalleryView->display()JROOT/components/com_joomgallery/views/category/view.html.php:929
    10JoomGalleryViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_joomgallery/controller.php:100
    8JoomGalleryController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_joomgallery/joomgallery.php:41
    6require_once JROOT/components/com_joomgallery/joomgallery.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.33 ms After last query: 0.28 ms Query memory: 0.032 MB Memory before query: 7.127 MB Rows returned: 1
    Duplicate queries: #25  #26  #32  #34  #36
    SELECT alias
    
      FROM jos_joomgallery_catg
      WHERE cid = 8
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjos_joomgallery_catgconstPRIMARYPRIMARY4const1
    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
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1728
    24JDatabaseDriver->loadResult()JROOT/components/com_joomgallery/router.php:333
    23JoomGalleryBuildRoute()JROOT/libraries/cms/component/router/legacy.php:68
    22JComponentRouterLegacy->build()JROOT/libraries/cms/router/site.php:483
    21JRouterSite->buildSefRoute()JROOT/libraries/cms/router/site.php:452
    20JRouterSite->_buildSefRoute()JROOT/libraries/cms/router/router.php:280
    19JRouter->build()JROOT/libraries/cms/router/site.php:134
    18JRouterSite->build()JROOT/libraries/joomla/application/route.php:62
    17JRoute::_()JROOT/templates/theme3278/html/com_joomgallery/category/default_images.php:36
    16include JROOT/templates/theme3278/html/com_joomgallery/category/default_images.phpJROOT/libraries/legacy/view/legacy.php:670
    15JViewLegacy->loadTemplate()JROOT/components/com_joomgallery/views/category/tmpl/default.php:11
    14include JROOT/components/com_joomgallery/views/category/tmpl/default.phpJROOT/libraries/legacy/view/legacy.php:670
    13JViewLegacy->loadTemplate()JROOT/libraries/legacy/view/legacy.php:209
    12JViewLegacy->display()JROOT/components/com_joomgallery/view.php:171
    11JoomGalleryView->display()JROOT/components/com_joomgallery/views/category/view.html.php:929
    10JoomGalleryViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_joomgallery/controller.php:100
    8JoomGalleryController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_joomgallery/joomgallery.php:41
    6require_once JROOT/components/com_joomgallery/joomgallery.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: 0.58 ms After last query: 1.38 ms Query memory: 0.032 MB Memory before query: 7.161 MB Rows returned: 1
    SELECT catid, alias
    
      FROM jos_joomgallery
      WHERE id = 105
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjos_joomgalleryconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.01 ms
    checking query cache for query0.02 ms
    checking permissions0.01 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.02 ms
    freeing items0.03 ms
    Waiting for query cache lock0.01 ms
    freeing items0.00 ms
    storing result in query cache0.01 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1453
    24JDatabaseDriver->loadAssoc()JROOT/components/com_joomgallery/router.php:327
    23JoomGalleryBuildRoute()JROOT/libraries/cms/component/router/legacy.php:68
    22JComponentRouterLegacy->build()JROOT/libraries/cms/router/site.php:483
    21JRouterSite->buildSefRoute()JROOT/libraries/cms/router/site.php:452
    20JRouterSite->_buildSefRoute()JROOT/libraries/cms/router/router.php:280
    19JRouter->build()JROOT/libraries/cms/router/site.php:134
    18JRouterSite->build()JROOT/libraries/joomla/application/route.php:62
    17JRoute::_()JROOT/templates/theme3278/html/com_joomgallery/category/default_images.php:36
    16include JROOT/templates/theme3278/html/com_joomgallery/category/default_images.phpJROOT/libraries/legacy/view/legacy.php:670
    15JViewLegacy->loadTemplate()JROOT/components/com_joomgallery/views/category/tmpl/default.php:11
    14include JROOT/components/com_joomgallery/views/category/tmpl/default.phpJROOT/libraries/legacy/view/legacy.php:670
    13JViewLegacy->loadTemplate()JROOT/libraries/legacy/view/legacy.php:209
    12JViewLegacy->display()JROOT/components/com_joomgallery/view.php:171
    11JoomGalleryView->display()JROOT/components/com_joomgallery/views/category/view.html.php:929
    10JoomGalleryViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_joomgallery/controller.php:100
    8JoomGalleryController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_joomgallery/joomgallery.php:41
    6require_once JROOT/components/com_joomgallery/joomgallery.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.31 ms After last query: 0.41 ms Query memory: 0.032 MB Memory before query: 7.193 MB Rows returned: 1
    Duplicate queries: #25  #26  #30  #34  #36
    SELECT alias
    
      FROM jos_joomgallery_catg
      WHERE cid = 8
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjos_joomgallery_catgconstPRIMARYPRIMARY4const1
    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.03 ms
    logging slow query0.01 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1728
    24JDatabaseDriver->loadResult()JROOT/components/com_joomgallery/router.php:333
    23JoomGalleryBuildRoute()JROOT/libraries/cms/component/router/legacy.php:68
    22JComponentRouterLegacy->build()JROOT/libraries/cms/router/site.php:483
    21JRouterSite->buildSefRoute()JROOT/libraries/cms/router/site.php:452
    20JRouterSite->_buildSefRoute()JROOT/libraries/cms/router/router.php:280
    19JRouter->build()JROOT/libraries/cms/router/site.php:134
    18JRouterSite->build()JROOT/libraries/joomla/application/route.php:62
    17JRoute::_()JROOT/templates/theme3278/html/com_joomgallery/category/default_images.php:36
    16include JROOT/templates/theme3278/html/com_joomgallery/category/default_images.phpJROOT/libraries/legacy/view/legacy.php:670
    15JViewLegacy->loadTemplate()JROOT/components/com_joomgallery/views/category/tmpl/default.php:11
    14include JROOT/components/com_joomgallery/views/category/tmpl/default.phpJROOT/libraries/legacy/view/legacy.php:670
    13JViewLegacy->loadTemplate()JROOT/libraries/legacy/view/legacy.php:209
    12JViewLegacy->display()JROOT/components/com_joomgallery/view.php:171
    11JoomGalleryView->display()JROOT/components/com_joomgallery/views/category/view.html.php:929
    10JoomGalleryViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_joomgallery/controller.php:100
    8JoomGalleryController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_joomgallery/joomgallery.php:41
    6require_once JROOT/components/com_joomgallery/joomgallery.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.54 ms After last query: 1.17 ms Query memory: 0.032 MB Memory before query: 7.225 MB Rows returned: 1
    SELECT catid, alias
    
      FROM jos_joomgallery
      WHERE id = 106
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjos_joomgalleryconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.02 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    System lock0.01 ms
    Waiting for query cache lock0.02 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.03 ms
    executing0.01 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.01 ms
    freeing items0.00 ms
    storing result in query cache0.01 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1453
    24JDatabaseDriver->loadAssoc()JROOT/components/com_joomgallery/router.php:327
    23JoomGalleryBuildRoute()JROOT/libraries/cms/component/router/legacy.php:68
    22JComponentRouterLegacy->build()JROOT/libraries/cms/router/site.php:483
    21JRouterSite->buildSefRoute()JROOT/libraries/cms/router/site.php:452
    20JRouterSite->_buildSefRoute()JROOT/libraries/cms/router/router.php:280
    19JRouter->build()JROOT/libraries/cms/router/site.php:134
    18JRouterSite->build()JROOT/libraries/joomla/application/route.php:62
    17JRoute::_()JROOT/templates/theme3278/html/com_joomgallery/category/default_images.php:36
    16include JROOT/templates/theme3278/html/com_joomgallery/category/default_images.phpJROOT/libraries/legacy/view/legacy.php:670
    15JViewLegacy->loadTemplate()JROOT/components/com_joomgallery/views/category/tmpl/default.php:11
    14include JROOT/components/com_joomgallery/views/category/tmpl/default.phpJROOT/libraries/legacy/view/legacy.php:670
    13JViewLegacy->loadTemplate()JROOT/libraries/legacy/view/legacy.php:209
    12JViewLegacy->display()JROOT/components/com_joomgallery/view.php:171
    11JoomGalleryView->display()JROOT/components/com_joomgallery/views/category/view.html.php:929
    10JoomGalleryViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_joomgallery/controller.php:100
    8JoomGalleryController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_joomgallery/joomgallery.php:41
    6require_once JROOT/components/com_joomgallery/joomgallery.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.27 ms After last query: 0.28 ms Query memory: 0.032 MB Memory before query: 7.257 MB Rows returned: 1
    Duplicate queries: #25  #26  #30  #32  #36
    SELECT alias
    
      FROM jos_joomgallery_catg
      WHERE cid = 8
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjos_joomgallery_catgconstPRIMARYPRIMARY4const1
    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.03 ms
    logging slow query0.01 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1728
    24JDatabaseDriver->loadResult()JROOT/components/com_joomgallery/router.php:333
    23JoomGalleryBuildRoute()JROOT/libraries/cms/component/router/legacy.php:68
    22JComponentRouterLegacy->build()JROOT/libraries/cms/router/site.php:483
    21JRouterSite->buildSefRoute()JROOT/libraries/cms/router/site.php:452
    20JRouterSite->_buildSefRoute()JROOT/libraries/cms/router/router.php:280
    19JRouter->build()JROOT/libraries/cms/router/site.php:134
    18JRouterSite->build()JROOT/libraries/joomla/application/route.php:62
    17JRoute::_()JROOT/templates/theme3278/html/com_joomgallery/category/default_images.php:36
    16include JROOT/templates/theme3278/html/com_joomgallery/category/default_images.phpJROOT/libraries/legacy/view/legacy.php:670
    15JViewLegacy->loadTemplate()JROOT/components/com_joomgallery/views/category/tmpl/default.php:11
    14include JROOT/components/com_joomgallery/views/category/tmpl/default.phpJROOT/libraries/legacy/view/legacy.php:670
    13JViewLegacy->loadTemplate()JROOT/libraries/legacy/view/legacy.php:209
    12JViewLegacy->display()JROOT/components/com_joomgallery/view.php:171
    11JoomGalleryView->display()JROOT/components/com_joomgallery/views/category/view.html.php:929
    10JoomGalleryViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_joomgallery/controller.php:100
    8JoomGalleryController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_joomgallery/joomgallery.php:41
    6require_once JROOT/components/com_joomgallery/joomgallery.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.54 ms After last query: 0.96 ms Query memory: 0.032 MB Memory before query: 7.289 MB Rows returned: 1
    SELECT catid, alias
    
      FROM jos_joomgallery
      WHERE id = 107
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjos_joomgalleryconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.01 ms
    checking query cache for query0.02 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.02 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.04 ms
    Waiting for query cache lock0.01 ms
    freeing items0.00 ms
    storing result in query cache0.01 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1453
    24JDatabaseDriver->loadAssoc()JROOT/components/com_joomgallery/router.php:327
    23JoomGalleryBuildRoute()JROOT/libraries/cms/component/router/legacy.php:68
    22JComponentRouterLegacy->build()JROOT/libraries/cms/router/site.php:483
    21JRouterSite->buildSefRoute()JROOT/libraries/cms/router/site.php:452
    20JRouterSite->_buildSefRoute()JROOT/libraries/cms/router/router.php:280
    19JRouter->build()JROOT/libraries/cms/router/site.php:134
    18JRouterSite->build()JROOT/libraries/joomla/application/route.php:62
    17JRoute::_()JROOT/templates/theme3278/html/com_joomgallery/category/default_images.php:36
    16include JROOT/templates/theme3278/html/com_joomgallery/category/default_images.phpJROOT/libraries/legacy/view/legacy.php:670
    15JViewLegacy->loadTemplate()JROOT/components/com_joomgallery/views/category/tmpl/default.php:11
    14include JROOT/components/com_joomgallery/views/category/tmpl/default.phpJROOT/libraries/legacy/view/legacy.php:670
    13JViewLegacy->loadTemplate()JROOT/libraries/legacy/view/legacy.php:209
    12JViewLegacy->display()JROOT/components/com_joomgallery/view.php:171
    11JoomGalleryView->display()JROOT/components/com_joomgallery/views/category/view.html.php:929
    10JoomGalleryViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_joomgallery/controller.php:100
    8JoomGalleryController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_joomgallery/joomgallery.php:41
    6require_once JROOT/components/com_joomgallery/joomgallery.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.26 ms After last query: 0.25 ms Query memory: 0.032 MB Memory before query: 7.321 MB Rows returned: 1
    Duplicate queries: #25  #26  #30  #32  #34
    SELECT alias
    
      FROM jos_joomgallery_catg
      WHERE cid = 8
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjos_joomgallery_catgconstPRIMARYPRIMARY4const1
    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.03 ms
    logging slow query0.01 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1728
    24JDatabaseDriver->loadResult()JROOT/components/com_joomgallery/router.php:333
    23JoomGalleryBuildRoute()JROOT/libraries/cms/component/router/legacy.php:68
    22JComponentRouterLegacy->build()JROOT/libraries/cms/router/site.php:483
    21JRouterSite->buildSefRoute()JROOT/libraries/cms/router/site.php:452
    20JRouterSite->_buildSefRoute()JROOT/libraries/cms/router/router.php:280
    19JRouter->build()JROOT/libraries/cms/router/site.php:134
    18JRouterSite->build()JROOT/libraries/joomla/application/route.php:62
    17JRoute::_()JROOT/templates/theme3278/html/com_joomgallery/category/default_images.php:36
    16include JROOT/templates/theme3278/html/com_joomgallery/category/default_images.phpJROOT/libraries/legacy/view/legacy.php:670
    15JViewLegacy->loadTemplate()JROOT/components/com_joomgallery/views/category/tmpl/default.php:11
    14include JROOT/components/com_joomgallery/views/category/tmpl/default.phpJROOT/libraries/legacy/view/legacy.php:670
    13JViewLegacy->loadTemplate()JROOT/libraries/legacy/view/legacy.php:209
    12JViewLegacy->display()JROOT/components/com_joomgallery/view.php:171
    11JoomGalleryView->display()JROOT/components/com_joomgallery/views/category/view.html.php:929
    10JoomGalleryViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_joomgallery/controller.php:100
    8JoomGalleryController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_joomgallery/joomgallery.php:41
    6require_once JROOT/components/com_joomgallery/joomgallery.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: 4.72 ms After last query: 29.88 ms Query memory: 0.030 MB Memory before query: 7.715 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.14 ms
    checking permissions0.01 ms
    Opening tables3.33 ms
    System lock0.02 ms
    init0.01 ms
    optimizing0.01 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.01 ms
    checking permissions0.01 ms
    checking permissions0.02 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.06 ms
    logging slow query0.01 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    20JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/database/driver/mysqli.php:440
    19JDatabaseDriverMysqli->getTableColumns()JROOT/libraries/joomla/table/table.php:241
    18JTable->getFields()JROOT/libraries/joomla/table/table.php:162
    17JTable->__construct()JROOT/libraries/joomla/table/asset.php:60
    16JTableAsset->__construct()JROOT/libraries/joomla/table/table.php:304
    15JTable::getInstance()JROOT/libraries/joomla/access/access.php:714
    14JAccess::getExtensionNameFromAsset()JROOT/libraries/joomla/access/access.php:576
    13JAccess::getAssetRules()JROOT/libraries/joomla/user/user.php:384
    12JUser->authorise()JROOT/modules/mod_tm_style_switcher/tmpl/default.php:20
    11require JROOT/modules/mod_tm_style_switcher/tmpl/default.phpJROOT/modules/mod_tm_style_switcher/mod_tm_style_switcher.php:16
    10include JROOT/modules/mod_tm_style_switcher/mod_tm_style_switcher.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.]

  38. Query Time: 0.36 ms After last query: 0.57 ms Query memory: 0.024 MB Memory before query: 7.764 MB Rows returned: 1
    SELECT *
    
      FROM jos_assets
      WHERE `id` = '1'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjos_assetsconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    starting0.01 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
    sending cached result to clien0.02 ms
    logging slow query0.01 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1453
    16JDatabaseDriver->loadAssoc()JROOT/libraries/joomla/table/table.php:715
    15JTable->load()JROOT/libraries/joomla/access/access.php:715
    14JAccess::getExtensionNameFromAsset()JROOT/libraries/joomla/access/access.php:576
    13JAccess::getAssetRules()JROOT/libraries/joomla/user/user.php:384
    12JUser->authorise()JROOT/modules/mod_tm_style_switcher/tmpl/default.php:20
    11require JROOT/modules/mod_tm_style_switcher/tmpl/default.phpJROOT/modules/mod_tm_style_switcher/mod_tm_style_switcher.php:16
    10include JROOT/modules/mod_tm_style_switcher/mod_tm_style_switcher.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.]

  39. Query Time: 0.30 ms After last query: 0.34 ms Query memory: 0.020 MB Memory before query: 7.782 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.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1538
    14JDatabaseDriver->loadColumn()JROOT/libraries/joomla/access/access.php:670
    13JAccess::getAssetRules()JROOT/libraries/joomla/user/user.php:384
    12JUser->authorise()JROOT/modules/mod_tm_style_switcher/tmpl/default.php:20
    11require JROOT/modules/mod_tm_style_switcher/tmpl/default.phpJROOT/modules/mod_tm_style_switcher/mod_tm_style_switcher.php:16
    10include JROOT/modules/mod_tm_style_switcher/mod_tm_style_switcher.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.]

  40. Query Time: 0.77 ms After last query: 1.34 ms Query memory: 0.023 MB Memory before query: 7.815 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.01 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.04 ms
    checking permissions0.03 ms
    Opening tables0.02 ms
    System lock0.01 ms
    Waiting for query cache lock0.02 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.11 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.07 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1538
    16JDatabaseDriver->loadColumn()JROOT/libraries/joomla/access/access.php:412
    15JAccess::preloadComponents()JROOT/libraries/joomla/access/access.php:213
    14JAccess::preload()JROOT/libraries/joomla/access/access.php:168
    13JAccess::check()JROOT/libraries/joomla/user/user.php:393
    12JUser->authorise()JROOT/modules/mod_tm_style_switcher/tmpl/default.php:20
    11require JROOT/modules/mod_tm_style_switcher/tmpl/default.phpJROOT/modules/mod_tm_style_switcher/mod_tm_style_switcher.php:16
    10include JROOT/modules/mod_tm_style_switcher/mod_tm_style_switcher.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.]

  41. Query Time: 0.46 ms After last query: 0.59 ms Query memory: 0.024 MB Memory before query: 7.844 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.03 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1494
    16JDatabaseDriver->loadAssocList()JROOT/libraries/joomla/access/access.php:439
    15JAccess::preloadComponents()JROOT/libraries/joomla/access/access.php:213
    14JAccess::preload()JROOT/libraries/joomla/access/access.php:168
    13JAccess::check()JROOT/libraries/joomla/user/user.php:393
    12JUser->authorise()JROOT/modules/mod_tm_style_switcher/tmpl/default.php:20
    11require JROOT/modules/mod_tm_style_switcher/tmpl/default.phpJROOT/modules/mod_tm_style_switcher/mod_tm_style_switcher.php:16
    10include JROOT/modules/mod_tm_style_switcher/mod_tm_style_switcher.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.]

  42. Query Time: 0.47 ms After last query: 5.89 ms Query memory: 0.019 MB Memory before query: 8.194 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.00 ms
    checking query cache for query0.02 ms
    checking privileges on cached 0.01 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
    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: 0.30 ms After last query: 1.77 ms Query memory: 0.026 MB Memory before query: 8.231 MB Rows returned: 1
    Duplicate queries: #10
    SELECT cid
    
      FROM jos_joomgallery_catg
      WHERE alias = 'gallery/gallery-6'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjos_joomgallery_catgALLNULLNO INDEX KEY COULD BE USEDNULLNULL8Using 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:1728
    19JDatabaseDriver->loadResult()JROOT/components/com_joomgallery/helpers/routing.php:44
    18JoomRouting::getId()JROOT/components/com_joomgallery/router.php:499
    17JoomGalleryParseRoute()JROOT/libraries/cms/component/router/legacy.php:104
    16JComponentRouterLegacy->parse()JROOT/libraries/cms/router/site.php:395
    15JRouterSite->parseSefRoute()JROOT/libraries/cms/router/router.php:479
    14JRouter->_parseSefRoute()JROOT/libraries/cms/router/router.php:234
    13JRouter->parse()JROOT/libraries/cms/router/site.php:118
    12JRouterSite->parse()JROOT/modules/mod_socialloginandsocialshare/helper.php:50
    11modSocialLoginAndSocialShareHelper::getReturnURL()JROOT/modules/mod_socialloginandsocialshare/mod_socialloginandsocialshare.php:21
    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.]

  44. Query Time: 2.50 ms After last query: 15.63 ms Query memory: 0.028 MB Memory before query: 8.985 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 23:30:22')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-02-22 23:30:22')
    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.03 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.15 ms
    checking permissions0.01 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.05 ms
    System lock0.08 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.02 ms
    Creating tmp table0.02 ms
    executing0.00 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 data1.02 ms
    init0.07 ms
    optimizing0.02 ms
    statistics0.13 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.05 ms
    end0.01 ms
    query end0.01 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.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
    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.]

  45. Query Time: 0.45 ms After last query: 1.89 ms Query memory: 0.028 MB Memory before query: 9.053 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.01 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.]

  46. Query Time: 0.35 ms After last query: 1.01 ms Query memory: 0.025 MB Memory before query: 9.088 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.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
    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.]

  47. Query Time: 3.73 ms After last query: 9.02 ms Query memory: 0.041 MB Memory before query: 9.391 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.06 ms
    checking permissions0.01 ms
    Opening tables2.78 ms
    System lock0.02 ms
    init0.01 ms
    optimizing0.00 ms
    statistics0.02 ms
    preparing0.01 ms
    executing0.01 ms
    Opening tables0.02 ms
    checking permissions0.04 ms
    checking permissions0.02 ms
    Sending data0.04 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.00 ms
    removing tmp table0.07 ms
    closing tables0.01 ms
    freeing items0.05 ms
    logging slow query0.02 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    32JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    31JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/database/driver/mysqli.php:440
    30JDatabaseDriverMysqli->getTableColumns()JROOT/libraries/joomla/table/table.php:241
    29JTable->getFields()JROOT/libraries/joomla/table/table.php:162
    28JTable->__construct()JROOT/administrator/components/com_komento/tables/parent.php:18
    27KomentoParentTable->__construct()JROOT/administrator/components/com_komento/tables/configs.php:40
    26KomentoTableConfigs->__construct()JROOT/libraries/joomla/table/table.php:304
    25JTable::getInstance()JROOT/administrator/components/com_komento/tables/parent.php:49
    24KomentoParentTable::getInstance()JROOT/components/com_komento/helpers/helper.php:99
    23Komento::getTable()JROOT/components/com_komento/helpers/helper.php:228
    22Komento::getKonfig()JROOT/components/com_komento/bootstrap.php:30
    21require_once JROOT/components/com_komento/bootstrap.phpJROOT/plugins/content/komento/komento.php:136
    20plgContentKomento->execute()JROOT/plugins/content/komento/komento.php:111
    19plgContentKomento->onContentPrepare()Same as call in the line below.
    18call_user_func_array()JROOT/libraries/joomla/event/event.php:69
    17JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:159
    16JEventDispatcher->trigger()JROOT/libraries/cms/html/content.php:41
    15JHtmlContent::prepare()Same as call in the line below.
    14call_user_func_array()JROOT/libraries/cms/html/html.php:236
    13JHtml::call()JROOT/libraries/cms/html/html.php:138
    12JHtml::_()JROOT/modules/mod_articles_single/helper.php:33
    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.40 ms After last query: 0.61 ms Query memory: 0.031 MB Memory before query: 9.437 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.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.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1453
    24JDatabaseDriver->loadAssoc()JROOT/libraries/joomla/table/table.php:715
    23JTable->load()JROOT/components/com_komento/helpers/helper.php:229
    22Komento::getKonfig()JROOT/components/com_komento/bootstrap.php:30
    21require_once JROOT/components/com_komento/bootstrap.phpJROOT/plugins/content/komento/komento.php:136
    20plgContentKomento->execute()JROOT/plugins/content/komento/komento.php:111
    19plgContentKomento->onContentPrepare()Same as call in the line below.
    18call_user_func_array()JROOT/libraries/joomla/event/event.php:69
    17JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:159
    16JEventDispatcher->trigger()JROOT/libraries/cms/html/content.php:41
    15JHtmlContent::prepare()Same as call in the line below.
    14call_user_func_array()JROOT/libraries/cms/html/html.php:236
    13JHtml::call()JROOT/libraries/cms/html/html.php:138
    12JHtml::_()JROOT/modules/mod_articles_single/helper.php:33
    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.]

  49. Query Time: 2.61 ms After last query: 12.50 ms Query memory: 0.028 MB Memory before query: 9.644 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 23:30:22')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-02-22 23:30:22')
    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.03 ms
    Waiting for query cache lock0.00 ms
    checking query cache for query0.16 ms
    checking permissions0.01 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.05 ms
    System lock0.07 ms
    optimizing0.02 ms
    statistics0.07 ms
    preparing0.02 ms
    Creating tmp table0.01 ms
    executing0.00 ms
    Copying to tmp table0.07 ms
    Sorting result0.04 ms
    Sending data0.01 ms
    removing tmp table0.01 ms
    Sending data0.01 ms
    Waiting for query cache lock0.00 ms
    Sending data0.99 ms
    init0.05 ms
    optimizing0.01 ms
    statistics0.10 ms
    preparing0.01 ms
    executing0.01 ms
    Sending data0.05 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.00 ms
    removing tmp table0.00 ms
    closing tables0.01 ms
    freeing items0.01 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.10 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.]

  50. Query Time: 0.37 ms After last query: 1.01 ms Query memory: 0.025 MB Memory before query: 9.673 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.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
    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.]

  51. Query Time: 0.45 ms After last query: 18.70 ms Query memory: 0.026 MB Memory before query: 9.716 MB Rows returned: 1
    Duplicate queries: #24
    SELECT alias
    
      FROM jos_joomgallery_catg
      WHERE cid = 2
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjos_joomgallery_catgconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    starting0.04 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
    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:1728
    19JDatabaseDriver->loadResult()JROOT/components/com_joomgallery/router.php:310
    18JoomGalleryBuildRoute()JROOT/libraries/cms/component/router/legacy.php:68
    17JComponentRouterLegacy->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_breadcrumbs/helper.php:56
    11ModBreadCrumbsHelper::getList()JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php:16
    10include JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.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.52 ms After last query: 13.87 ms Query memory: 0.027 MB Memory before query: 10.244 MB Rows returned: 1
    SELECT id,parent_id 
      FROM jos_menu
      WHERE id = 203
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjos_menuconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    starting0.03 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.05 ms
    logging slow query0.02 ms
    cleaning up0.01 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.]

  53. Query Time: 0.31 ms After last query: 0.17 ms Query memory: 0.027 MB Memory before query: 10.270 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.01 ms
    sending cached result to clien0.13 ms
    logging slow query0.01 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.]

  54. Query Time: 0.51 ms After last query: 14.64 ms Query memory: 0.033 MB Memory before query: 10.532 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.03 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
    checking permissions0.00 ms
    sending cached result to clien0.04 ms
    logging slow query0.01 ms
    cleaning up0.02 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.]

  55. Query Time: 0.41 ms After last query: 5.84 ms Query memory: 0.033 MB Memory before query: 10.592 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.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
    checking permissions0.00 ms
    sending cached result to clien0.02 ms
    logging slow query0.01 ms
    cleaning up0.01 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.]

  56. Query Time: 0.56 ms After last query: 6.38 ms Query memory: 0.033 MB Memory before query: 10.653 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.07 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
    checking permissions0.00 ms
    sending cached result to clien0.03 ms
    logging slow query0.00 ms
    cleaning up0.01 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.]

  57. Query Time: 5.18 ms After last query: 7.14 ms Query memory: 0.053 MB Memory before query: 11.118 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 23:30:22')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-02-22 23:30:22')
      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.04 ms
    Waiting for query cache lock0.01 ms
    checking query cache for query0.22 ms
    checking permissions0.01 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.06 ms
    System lock0.07 ms
    optimizing0.02 ms
    statistics0.08 ms
    preparing0.02 ms
    Creating tmp table0.02 ms
    executing0.01 ms
    Copying to tmp table0.06 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 data2.56 ms
    init0.13 ms
    optimizing0.03 ms
    statistics0.15 ms
    preparing0.04 ms
    executing0.01 ms
    Sorting result0.41 ms
    Sending data0.14 ms
    end0.02 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.06 ms
    Waiting for query cache lock0.01 ms
    freeing items0.01 ms
    storing result in query cache0.12 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/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.]

  58. Query Time: 0.62 ms After last query: 1.39 ms Query memory: 0.047 MB Memory before query: 11.198 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.03 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
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    sending cached result to clien0.03 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_ar