Tarek Amer School
Tarek Amer School
  • Home
  • The School
    • CEO Word
    • About Us
    • The Teacher
    • Mission
    • Vision
    • History
    • Quality
  • English
    • General English
    • IELTS
    • TOEFL
    • Conversational English
    • English for Business
    • English for IT Professionals
    • Central Belarus English Exam
  • Courses
    • Arabic Language
    • Web Development
    • Computer ICDL
  • Library
    • English Books
    • Arabic Books
    • Web Development Books
    • Computer Books
  • Media
    • Russia Today TV
    • Sky News TV
    • Educational Videos
    • Search the Website
    • Site Map
  • Partners
    • Cambridge University
    • The British Council
    • Microsoft
    • Oxford University
    • Arabic Language Academy
    • ECDL Foundation
    • The Joomla Project
  • Teaching
    • School Classes
    • Skype Teaching
    • Private Lessons
    • Courses Pricing
    • Free Lanuage Level Test
    • IELTS Exam Simulation
  • Services
    • Immigration Services
    • CV Writing
    • Research Writing
    • Translation
  • Contact Us
    • Call Us
    • School Location
    • Work with Us
    • Facebook
    • Youtube
    • LinkedIn
    • Site Visitors
    • Login
Title Author Hits
ﺍﻟﻘﺮﺍﻥ ﺍﻟﻜﺮﻳﻢ ﺑﺎﻟﻠﻐﺔ الروسية Written by Belarus in Arabic Hits: 1425
مشروع أبناء الاسكندرية Written by Belarus in Arabic Hits: 1097
نظرية الفلافل Written by Belarus in Arabic Hits: 924
ذات Written by Belarus in Arabic Hits: 1023
عبير Written by Belarus in Arabic Hits: 880
قانا Written by Belarus in Arabic Hits: 852
Blog Written by Belarus in Arabic Hits: 878

  • Terms of Use
  • Privacy Statement
  • Certifications
  • Russian for Arabs
  • Links
  • Book English Exam
  • Blog
  • School Documents
  • ad

Back to Top

© 2022 Tarek Amer School

Joomla! Debug Console

Session

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

Profile Information

Time

Memory

Time: 205.35 ms / 205.35 ms Memory: 0.172 MB / 0.40 MB Application: afterLoad
Time: 905.21 ms / 1110.56 ms Memory: 1.625 MB / 2.02 MB Application: afterInitialise
Time: 105.79 ms / 1216.35 ms Memory: 1.143 MB / 3.17 MB Application: afterRoute
Time: 14.02 ms / 1230.37 ms Memory: 0.075 MB / 3.24 MB Application: beforeRenderComponent com_content
Time: 824.36 ms / 2054.73 ms Memory: 1.456 MB / 4.70 MB Application: afterRenderComponent com_content
Time: 1.20 ms / 2055.93 ms Memory: 0.007 MB / 4.71 MB Application: afterDispatch
Time: 44.37 ms / 2100.30 ms Memory: 0.098 MB / 4.80 MB Application: beforeRenderModule mod_jbmenu (FooterMenu)
Time: 67.58 ms / 2167.88 ms Memory: 0.051 MB / 4.85 MB Application: afterRenderModule mod_jbmenu (FooterMenu)
Time: 0.20 ms / 2168.08 ms Memory: 0.000 MB / 4.85 MB Application: beforeRenderModule mod_ext_vk_community (EXT Vk Community on P7)
Time: 39.16 ms / 2207.24 ms Memory: 0.014 MB / 4.86 MB Application: afterRenderModule mod_ext_vk_community (EXT Vk Community on P7)
Time: 0.10 ms / 2207.34 ms Memory: 0.000 MB / 4.86 MB Application: beforeRenderModule mod_custom (Translation)
Time: 34.47 ms / 2241.81 ms Memory: 0.009 MB / 4.87 MB Application: afterRenderModule mod_custom (Translation)
Time: 0.34 ms / 2242.14 ms Memory: 0.008 MB / 4.87 MB Application: beforeRenderModule mod_ariimageslider (New HomePage Banner Slide Image)
Time: 86.95 ms / 2329.09 ms Memory: 0.201 MB / 5.07 MB Application: afterRenderModule mod_ariimageslider (New HomePage Banner Slide Image)
Time: 0.25 ms / 2329.34 ms Memory: 0.000 MB / 5.03 MB Application: beforeRenderModule mod_jbmenu (JB DropDown Menu)
Time: 35.29 ms / 2364.64 ms Memory: 0.215 MB / 5.24 MB Application: afterRenderModule mod_jbmenu (JB DropDown Menu)
Time: 0.15 ms / 2364.78 ms Memory: 0.000 MB / 5.23 MB Application: beforeRenderModule mod_creativesocialwidget (Creative Social Widget)
Time: 26.93 ms / 2391.72 ms Memory: 0.066 MB / 5.30 MB Application: afterRenderModule mod_creativesocialwidget (Creative Social Widget)
Time: 0.11 ms / 2391.83 ms Memory: 0.000 MB / 5.28 MB Application: beforeRenderModule mod_search (Search main page)
Time: 24.51 ms / 2416.34 ms Memory: 0.028 MB / 5.31 MB Application: afterRenderModule mod_search (Search main page)
Time: 121.54 ms / 2537.89 ms Memory: 0.118 MB / 5.43 MB Application: afterRender

Database queries total: 43.13 ms

Memory Usage

6.04 MB (6,335,864 Bytes)

Database Queries

33 Queries Logged 43.13 ms


2 duplicate found!

2 duplicates: #4  #33
  1. Query Time: 0.52 ms Query memory: 0.017 MB Memory before query: 0.872 MB Rows returned: 0
    SELECT `data`
    
      FROM `jos_session`
      WHERE `session_id` = 'mgrheoii0eduhdephhf5jvesc3'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEjos_sessionconstPRIMARYPRIMARY766const1100.00NULL
    Profile
    StatusDuration
    starting0.09 ms
    checking permissions0.01 ms
    Opening tables0.10 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.05 ms
    executing0.01 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.07 ms
    freeing items0.05 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1731
    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:46
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  2. Query Time: 0.45 ms After last query: 22.52 ms Query memory: 0.010 MB Memory before query: 0.936 MB Rows returned: 0
    SELECT `session_id`
    
      FROM `jos_session`
      WHERE `session_id` = 'mgrheoii0eduhdephhf5jvesc3'
      LIMIT 0, 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEjos_sessionconstPRIMARYPRIMARY766const1100.00Using index
    Profile
    StatusDuration
    starting0.17 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.04 ms
    executing0.01 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.06 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    8JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1731
    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:46
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  3. Query Time: 0.64 ms After last query: 0.21 ms Query memory: 0.009 MB Memory before query: 0.948 MB
    INSERT INTO `jos_session`
    (`session_id`, `client_id`, `time`) 
      VALUES ('mgrheoii0eduhdephhf5jvesc3', 0, '1660667342')
    Explain
    EXPLAIN not possible on query: INSERT INTO `jos_session` (`session_id`, `client_id`, `time`) VALUES ('mgrheoii0eduhdephhf5jvesc3', 0, '1660667342')
    Profile
    StatusDuration
    starting0.08 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.01 ms
    update0.36 ms
    end0.01 ms
    query end0.02 ms
    closing tables0.02 ms
    freeing items0.07 ms
    cleaning up0.01 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:46
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  4. Query Time: 1.30 ms After last query: 48.73 ms Query memory: 0.012 MB Memory before query: 1.029 MB Rows returned: 46
    Duplicate queries: #33
    SELECT extension_id AS id, element AS "option", params, enabled
    
      FROM jos_extensions
      WHERE `type` = 'component'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEjos_extensionsrefextensionextension82const46100.00Using index condition
    Profile
    StatusDuration
    starting0.27 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.36 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.27 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.06 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1692
    9JDatabaseDriver->loadObjectList()Same as call in the line below.
    8call_user_func_array()JROOT/libraries/joomla/cache/controller/callback.php:157
    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:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  5. Query Time: 0.88 ms After last query: 15.52 ms Query memory: 0.013 MB Memory before query: 1.100 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_lenrefrowsfilteredExtra
    1SIMPLEaconstPRIMARYPRIMARY4const1100.00NULL
    1SIMPLEbrangeidx_usergroup_nested_set_lookupidx_usergroup_nested_set_lookup4NULL3100.00Using where; Using index
    Profile
    StatusDuration
    starting0.14 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.42 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.03 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.06 ms
    cleaning up0.05 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1541
    9JDatabaseDriver->loadColumn()JROOT/libraries/joomla/access/access.php:354
    8JAccess::getGroupsByUser()JROOT/libraries/joomla/access/access.php:423
    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:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  6. Query Time: 0.82 ms After last query: 11.88 ms Query memory: 0.011 MB Memory before query: 1.120 MB Rows returned: 5
    SELECT id, rules
    
      FROM `jos_viewlevels`
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEjos_viewlevelsALLNULLNO INDEX KEY COULD BE USEDNULLNULL5100.00NULL
    Profile
    StatusDuration
    starting0.09 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.18 ms
    preparing0.01 ms
    executing0.01 ms
    Sending data0.05 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.27 ms
    freeing items0.06 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    9JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1497
    8JDatabaseDriver->loadAssocList()JROOT/libraries/joomla/access/access.php:440
    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:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  7. Query Time: 1.09 ms After last query: 0.43 ms Query memory: 0.009 MB Memory before query: 1.139 MB Rows returned: 69
    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_lenrefrowsfilteredExtra
    1SIMPLEjos_extensionsrefextensionextension82const72100.00Using index condition; Using where; Using filesort
    Profile
    StatusDuration
    starting0.17 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.05 ms
    preparing0.03 ms
    Sorting result0.01 ms
    executing0.01 ms
    Sending data0.01 ms
    Creating sort index0.54 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.06 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    7JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1692
    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:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  8. Query Time: 0.41 ms After last query: 405.98 ms Query memory: 0.013 MB Memory before query: 1.744 MB Rows returned: 1
    SELECT count(*)
    
      FROM `jos_cwgears_schedule`
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLENULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLNULLSelect tables optimized away
    Profile
    StatusDuration
    starting0.13 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.02 ms
    System lock0.02 ms
    optimizing0.01 ms
    executing0.01 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.08 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1731
    10JDatabaseDriver->loadResult()JROOT/plugins/system/cwgears/cwgears.php:74
    9plgSystemCwgears->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:160
    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:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  9. Query Time: 2.64 ms After last query: 0.15 ms Query memory: 0.013 MB Memory before query: 1.758 MB Rows returned: 1
    SELECT count(*)
    
      FROM `jos_cwgears_schedule`
      WHERE time + '3600'<'1660667342'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLENULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLNULLImpossible WHERE noticed after reading const tables
    Profile
    StatusDuration
    starting0.10 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics2.30 ms
    preparing0.02 ms
    executing0.01 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.59 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1731
    10JDatabaseDriver->loadResult()JROOT/plugins/system/cwgears/cwgears.php:96
    9plgSystemCwgears->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:160
    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:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  10. Query Time: 0.47 ms After last query: 2.07 ms Query memory: 0.014 MB Memory before query: 1.809 MB Rows returned: 1
    SELECT timestamp
    
      FROM jos_zt_visitor_counter
      WHERE ipaddress = '18.207.157.152'
      AND useragent LIKE "%other%"
      ORDER BY timestamp DESC
      LIMIT 0, 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEjos_zt_visitor_counterindexNULLtimestamp4NULL12275300.00Using where
    Profile
    StatusDuration
    starting0.14 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.02 ms
    Sorting result0.01 ms
    executing0.01 ms
    Sending data0.06 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.06 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1731
    11JDatabaseDriver->loadResult()JROOT/plugins/system/zt_visitor_counter/helper.php:65
    10plgZTVisitorCounterHelper::getLastVisit()JROOT/plugins/system/zt_visitor_counter/zt_visitor_counter.php:42
    9plgSystemZT_Visitor_Counter->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:160
    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:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  11. Query Time: 0.70 ms After last query: 0.16 ms Query memory: 0.014 MB Memory before query: 1.821 MB
    UPDATE jos_zt_visitor_counter 
      SET visits=visits + 1, guests=guests + 1, useragent = 'other'
      WHERE timestamp = 1660667572
      AND `ipaddress` = '18.207.157.152';
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEjos_zt_visitor_counterrangetimestamptimestamp4const1100.00Using where
    Profile
    StatusDuration
    starting0.15 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.21 ms
    System lock0.04 ms
    updating0.12 ms
    end0.01 ms
    query end0.03 ms
    closing tables0.01 ms
    freeing items0.06 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/database.php:33
    11JDatabase->query()JROOT/plugins/system/zt_visitor_counter/helper.php:43
    10plgZTVisitorCounterHelper::updateVisits()JROOT/plugins/system/zt_visitor_counter/zt_visitor_counter.php:52
    9plgSystemZT_Visitor_Counter->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:160
    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:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  12. Query Time: 2.02 ms After last query: 118.25 ms Query memory: 0.020 MB Memory before query: 2.082 MB Rows returned: 87
    SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
    
      FROM jos_menu AS m
      LEFT JOIN jos_extensions AS e
      ON m.component_id = e.extension_id
      WHERE m.published = 1
      AND m.parent_id > 0
      AND m.client_id = 0
      ORDER BY m.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmrefidx_client_id_parent_id_alias_languageidx_client_id_parent_id_alias_language1const139100.00Using index condition; Using where; Using filesort
    1SIMPLEeeq_refPRIMARYPRIMARY4i674919_jos8.m.component_id1100.00Using where
    Profile
    StatusDuration
    starting0.17 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    init0.04 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.26 ms
    preparing0.04 ms
    Sorting result0.01 ms
    executing0.01 ms
    Sending data0.02 ms
    Creating sort index1.18 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.09 ms
    cleaning up0.06 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1692
    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:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  13. Query Time: 0.73 ms After last query: 47.65 ms Query memory: 0.022 MB Memory before query: 3.068 MB Rows returned: 1
    SELECT extension_id AS id, element AS "option", params, enabled
    
      FROM jos_extensions
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEjos_extensionsrefelement_clientid,element_folder_clientid,extensionextension484const,const1100.00Using index condition
    Profile
    StatusDuration
    starting0.14 ms
    checking permissions0.01 ms
    Opening tables0.09 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.12 ms
    preparing0.02 ms
    executing0.02 ms
    Sending data0.07 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.08 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1653
    18JDatabaseDriver->loadObject()Same as call in the line below.
    17call_user_func_array()JROOT/libraries/joomla/cache/controller/callback.php:157
    16JCacheControllerCallback->get()JROOT/libraries/cms/library/helper.php:156
    15JLibraryHelper::_load()JROOT/libraries/cms/library/helper.php:47
    14JLibraryHelper::getLibrary()JROOT/libraries/cms/library/helper.php:90
    13JLibraryHelper::getParams()JROOT/libraries/cms/version/version.php:274
    12JVersion->getMediaVersion()JROOT/libraries/joomla/factory.php:737
    11JFactory::createDocument()JROOT/libraries/joomla/factory.php:216
    10JFactory::getDocument()JROOT/plugins/system/cwgears/cwgears.php:123
    9plgSystemCwgears->onAfterRoute()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:160
    6JEventDispatcher->trigger()JROOT/libraries/joomla/application/base.php:106
    5JApplicationBase->triggerEvent()JROOT/libraries/cms/application/cms.php:1107
    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:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  14. Query Time: 0.82 ms After last query: 0.38 ms Query memory: 0.018 MB Memory before query: 3.076 MB
    UPDATE `jos_extensions`
    
      SET `params` = '{\"mediaversion\":\"e2b5490d979331082bab6190bc95b051\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEjos_extensionsrangeelement_clientid,element_folder_clientid,extensionextension484const,const1100.00Using where
    Profile
    StatusDuration
    starting0.10 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.10 ms
    System lock0.17 ms
    updating0.12 ms
    end0.02 ms
    query end0.14 ms
    closing tables0.02 ms
    freeing items0.09 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/cms/library/helper.php:119
    14JLibraryHelper::saveParams()JROOT/libraries/cms/version/version.php:325
    13JVersion->setMediaVersion()JROOT/libraries/cms/version/version.php:284
    12JVersion->getMediaVersion()JROOT/libraries/joomla/factory.php:737
    11JFactory::createDocument()JROOT/libraries/joomla/factory.php:216
    10JFactory::getDocument()JROOT/plugins/system/cwgears/cwgears.php:123
    9plgSystemCwgears->onAfterRoute()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:160
    6JEventDispatcher->trigger()JROOT/libraries/joomla/application/base.php:106
    5JApplicationBase->triggerEvent()JROOT/libraries/cms/application/cms.php:1107
    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:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  15. Query Time: 0.86 ms After last query: 26.58 ms Query memory: 0.014 MB Memory before query: 3.154 MB Rows returned: 1
    SELECT count(*)
    
      FROM `jos_extensions`
      WHERE `element` = 'cwgears'
      AND `extension_id` = ''
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLENULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLNULLImpossible WHERE noticed after reading const tables
    Profile
    StatusDuration
    starting0.24 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.04 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.05 ms
    executing0.02 ms
    end0.01 ms
    query end0.14 ms
    closing tables0.15 ms
    freeing items0.06 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1731
    11JDatabaseDriver->loadResult()JROOT/plugins/system/cwgears/cwgears.php:832
    10plgSystemCwgears->updateDownloadKeySub()JROOT/plugins/system/cwgears/cwgears.php:130
    9plgSystemCwgears->onAfterRoute()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:160
    6JEventDispatcher->trigger()JROOT/libraries/joomla/application/base.php:106
    5JApplicationBase->triggerEvent()JROOT/libraries/cms/application/cms.php:1107
    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:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  16. Query Time: 0.91 ms After last query: 6.85 ms Query memory: 0.009 MB Memory before query: 3.202 MB Rows returned: 2
    SELECT *
    
      FROM jos_languages
      WHERE published=1
      ORDER BY ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEjos_languagesALLNULLNO INDEX KEY COULD BE USEDNULLNULL2100.00Using where; Using filesort
    Profile
    StatusDuration
    starting0.15 ms
    checking permissions0.02 ms
    Opening tables0.03 ms
    init0.05 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.02 ms
    Sorting result0.01 ms
    executing0.01 ms
    Sending data0.02 ms
    Creating sort index0.29 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.07 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    7JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1692
    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:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  17. Query Time: 0.94 ms After last query: 0.75 ms Query memory: 0.008 MB Memory before query: 3.227 MB Rows returned: 1
    SELECT id, home, template, s.params
    
      FROM jos_template_styles as s
      LEFT JOIN jos_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
      WHERE s.client_id = 0
      AND e.enabled = 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEsALLidx_templateNO INDEX KEY COULD BE USEDNULLNULL2100.00Using where
    1SIMPLEerefelement_clientid,element_folder_clientid,extensionelement_clientid403i674919_jos8.s.template,const1100.00Using index condition; Using where
    Profile
    StatusDuration
    starting0.14 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.29 ms
    preparing0.12 ms
    executing0.01 ms
    Sending data0.08 ms
    end0.05 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.06 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    6JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1692
    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:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  18. Query Time: 0.85 ms After last query: 141.44 ms Query memory: 0.022 MB Memory before query: 3.495 MB Rows returned: 1
    SELECT a.rules
    
      FROM jos_assets AS a
      WHERE (a.id = 1)
      GROUP BY a.id, a.rules, a.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaconstPRIMARYPRIMARY4const1100.00NULL
    Profile
    StatusDuration
    starting0.42 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    init0.03 ms
    System lock0.02 ms
    optimizing0.02 ms
    statistics0.08 ms
    preparing0.03 ms
    executing0.01 ms
    Sending data0.03 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.08 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1541
    17JDatabaseDriver->loadColumn()JROOT/libraries/joomla/access/access.php:246
    16JAccess::getAssetRules()JROOT/libraries/joomla/user/user.php:384
    15JUser->authorise()JROOT/components/com_content/models/category.php:137
    14ContentModelCategory->populateState()JROOT/libraries/legacy/model/legacy.php:439
    13JModelLegacy->getState()JROOT/libraries/legacy/view/legacy.php:401
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:114
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:257
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  19. Query Time: 1.85 ms After last query: 23.15 ms Query memory: 0.023 MB Memory before query: 3.529 MB Rows returned: 3
    SELECT b.rules
    
      FROM jos_assets AS a
      LEFT JOIN jos_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE (a.name = 'com_content.category.24')
      GROUP BY b.id, b.rules, b.lft
      ORDER BY b.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaconstidx_asset_nameidx_asset_name202const1100.00Using temporary; Using filesort
    1SIMPLEbALLidx_lft_rgtNO INDEX KEY COULD BE USEDNULLNULL41055.37Using where
    Profile
    StatusDuration
    starting0.17 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.26 ms
    preparing0.02 ms
    Creating tmp table0.05 ms
    Sorting result0.01 ms
    executing0.01 ms
    Sending data0.43 ms
    Creating sort index0.53 ms
    end0.01 ms
    removing tmp table0.10 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.08 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1541
    18JDatabaseDriver->loadColumn()JROOT/libraries/joomla/access/access.php:246
    17JAccess::getAssetRules()JROOT/libraries/joomla/access/access.php:107
    16JAccess::check()JROOT/libraries/joomla/user/user.php:393
    15JUser->authorise()JROOT/components/com_content/models/category.php:137
    14ContentModelCategory->populateState()JROOT/libraries/legacy/model/legacy.php:439
    13JModelLegacy->getState()JROOT/libraries/legacy/view/legacy.php:401
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:114
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:257
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  20. Query Time: 3.36 ms After last query: 41.79 ms Query memory: 0.022 MB Memory before query: 3.593 MB Rows returned: 2
    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems
      FROM jos_categories as c
      LEFT JOIN (SELECT cat.id as id
      FROM jos_categories AS cat JOIN jos_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      LEFT JOIN jos_categories AS s
      ON (s.lft <= c.lft
      AND s.rgt >= c.rgt) OR (s.lft > c.lft
      AND s.rgt < c.rgt)
      LEFT JOIN `jos_content` AS i
      ON i.`catid` = c.id
      AND i.state = 1
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND badcats.id is null
      AND s.id=24
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
      ORDER BY c.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1PRIMARYsconstPRIMARY,idx_left_rightPRIMARY4const1100.00Using temporary; Using filesort
    1PRIMARYcALLcat_idx,idx_access,idx_left_rightNO INDEX KEY COULD BE USEDNULLNULL2487.50Using where
    1PRIMARY<derived2>ref<auto_key0><auto_key0>4i674919_jos8.c.id4100.00Using where; Not exists; Using index
    1PRIMARYirefidx_state,idx_catididx_catid4i674919_jos8.c.id11100.00Using where
    2DERIVEDparentrangecat_idx,idx_left_rightcat_idx203NULL2100.00Using index condition; Using temporary; Using filesort
    2DERIVEDcatindexPRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_aliasidx_left_right8NULL24100.00Using where; Using index; Using join buffer (Block Nested Loop)
    Profile
    StatusDuration
    starting0.35 ms
    checking permissions0.01 ms
    checking permissions0.15 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.02 ms
    Opening tables0.27 ms
    init0.16 ms
    System lock0.02 ms
    optimizing0.01 ms
    optimizing0.03 ms
    statistics0.41 ms
    preparing0.04 ms
    Creating tmp table0.02 ms
    Sorting result0.03 ms
    statistics0.20 ms
    preparing0.05 ms
    Creating tmp table0.07 ms
    Sorting result0.01 ms
    executing0.12 ms
    Sending data0.06 ms
    executing0.04 ms
    Sending data0.08 ms
    Creating sort index0.03 ms
    removing tmp table0.14 ms
    Creating sort index0.60 ms
    Creating sort index0.05 ms
    end0.01 ms
    removing tmp table0.14 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    removing tmp table0.01 ms
    closing tables0.02 ms
    freeing items0.08 ms
    cleaning up0.03 ms
    Call Stack
    #CallerFile and line number
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1692
    17JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/categories/categories.php:309
    16JCategories->_load()JROOT/libraries/legacy/categories/categories.php:184
    15JCategories->get()JROOT/components/com_content/models/category.php:346
    14ContentModelCategory->getCategory()JROOT/components/com_content/models/category.php:223
    13ContentModelCategory->getItems()JROOT/libraries/legacy/view/legacy.php:401
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:115
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:257
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  21. Query Time: 1.17 ms After last query: 17.16 ms Query memory: 0.027 MB Memory before query: 3.676 MB Rows returned: 2
    SELECT b.rules
    
      FROM jos_assets AS a
      LEFT JOIN jos_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE (a.name = 'com_content')
      GROUP BY b.id, b.rules, b.lft
      ORDER BY b.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaconstidx_asset_nameidx_asset_name202const1100.00Using temporary; Using filesort
    1SIMPLEbrangeidx_lft_rgtidx_lft_rgt4NULL11100.00Using where
    Profile
    StatusDuration
    starting0.18 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.11 ms
    preparing0.02 ms
    Creating tmp table0.05 ms
    Sorting result0.01 ms
    executing0.01 ms
    Sending data0.24 ms
    Creating sort index0.11 ms
    end0.01 ms
    removing tmp table0.11 ms
    end0.01 ms
    query end0.02 ms
    closing tables0.02 ms
    freeing items0.10 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    22JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1541
    21JDatabaseDriver->loadColumn()JROOT/libraries/joomla/access/access.php:246
    20JAccess::getAssetRules()JROOT/libraries/joomla/access/access.php:107
    19JAccess::check()JROOT/libraries/joomla/user/user.php:393
    18JUser->authorise()JROOT/components/com_content/models/articles.php:449
    17ContentModelArticles->getListQuery()JROOT/libraries/legacy/model/list.php:129
    16JModelList->_getListQuery()JROOT/libraries/legacy/model/list.php:181
    15JModelList->getItems()JROOT/components/com_content/models/articles.php:537
    14ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:245
    13ContentModelCategory->getItems()JROOT/libraries/legacy/view/legacy.php:401
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:115
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:257
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  22. Query Time: 5.43 ms After last query: 0.29 ms Query memory: 0.022 MB Memory before query: 3.708 MB Rows returned: 7
    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,
      CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
      CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
      FROM jos_content AS a
      LEFT JOIN jos_content_frontpage AS fp
      ON fp.content_id = a.id
      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 = 24
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-08-16 16:29:03')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-08-16 16:29:03')
      ORDER BY c.lft,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created
      LIMIT 0, 10
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1PRIMARYcconstPRIMARY,idx_accessPRIMARY4const1100.00Using temporary; Using filesort
    1PRIMARYarefidx_access,idx_catididx_catid4const10100.00Using where
    1PRIMARYfpeq_refPRIMARYPRIMARY4i674919_jos8.a.id1100.00Using where; Using index
    1PRIMARYuaALLPRIMARYNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where; Using join buffer (Block Nested Loop)
    1PRIMARYuamALLPRIMARYNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where; Using join buffer (Block Nested Loop)
    1PRIMARYparentconstPRIMARYPRIMARY4const1100.00Using where
    1PRIMARYvALLPRIMARYNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where; Using join buffer (Block Nested Loop)
    1PRIMARY<derived2>ref<auto_key0><auto_key0>4const4100.00Using where; Using index
    2DERIVEDparentrangecat_idx,idx_left_rightcat_idx203NULL2100.00Using index condition; Using temporary; Using filesort
    2DERIVEDcatindexPRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_aliasidx_left_right8NULL24100.00Using where; Using index; Using join buffer (Block Nested Loop)
    Profile
    StatusDuration
    starting0.25 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.13 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables2.32 ms
    init0.14 ms
    System lock0.02 ms
    optimizing0.01 ms
    optimizing0.02 ms
    statistics0.17 ms
    preparing0.03 ms
    Creating tmp table0.02 ms
    Sorting result0.03 ms
    statistics0.22 ms
    preparing0.06 ms
    Creating tmp table0.09 ms
    Sorting result0.02 ms
    executing0.09 ms
    Sending data0.34 ms
    executing0.01 ms
    Sending data0.04 ms
    Creating sort index0.27 ms
    removing tmp table0.10 ms
    Creating sort index0.38 ms
    Creating sort index0.34 ms
    end0.01 ms
    removing tmp table0.11 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    removing tmp table0.02 ms
    closing tables0.02 ms
    freeing items1.30 ms
    cleaning up0.04 ms
    Call Stack
    #CallerFile and line number
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1692
    17JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/model/legacy.php:312
    16JModelLegacy->_getList()JROOT/libraries/legacy/model/list.php:185
    15JModelList->getItems()JROOT/components/com_content/models/articles.php:537
    14ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:245
    13ContentModelCategory->getItems()JROOT/libraries/legacy/view/legacy.php:401
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:115
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:257
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  23. Query Time: 1.72 ms After last query: 11.56 ms Query memory: 0.022 MB Memory before query: 3.971 MB Rows returned: 1
    SELECT COUNT(*)
    
      FROM jos_content AS a
      LEFT JOIN jos_content_frontpage AS fp
      ON fp.content_id = a.id
      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 = 24
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-08-16 16:29:03')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-08-16 16:29:03')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1PRIMARYcconstPRIMARY,idx_accessPRIMARY4const1100.00NULL
    1PRIMARYarefidx_access,idx_catididx_catid4const10100.00Using where
    1PRIMARYfpeq_refPRIMARYPRIMARY4i674919_jos8.a.id1100.00Using where; Using index
    1PRIMARYuaeq_refPRIMARYPRIMARY4i674919_jos8.a.created_by1100.00Using where; Using index
    1PRIMARYuameq_refPRIMARYPRIMARY4i674919_jos8.a.modified_by1100.00Using where; Using index
    1PRIMARYparentconstPRIMARYPRIMARY4const1100.00Using where; Using index
    1PRIMARYveq_refPRIMARYPRIMARY4i674919_jos8.a.id1100.00Using where; Using index
    1PRIMARY<derived2>ref<auto_key0><auto_key0>4const4100.00Using where; Using index
    2DERIVEDparentrangecat_idx,idx_left_rightcat_idx203NULL2100.00Using index condition; Using temporary; Using filesort
    2DERIVEDcatindexPRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_aliasidx_left_right8NULL24100.00Using where; Using index; Using join buffer (Block Nested Loop)
    Profile
    StatusDuration
    starting0.24 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
    Opening tables0.09 ms
    init0.06 ms
    System lock0.02 ms
    optimizing0.01 ms
    optimizing0.02 ms
    statistics0.17 ms
    preparing0.04 ms
    Creating tmp table0.02 ms
    Sorting result0.13 ms
    statistics0.15 ms
    preparing0.04 ms
    executing0.02 ms
    Sending data0.09 ms
    executing0.01 ms
    Sending data0.12 ms
    Creating sort index0.02 ms
    removing tmp table0.01 ms
    Creating sort index0.11 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    removing tmp table0.01 ms
    closing tables0.03 ms
    freeing items0.07 ms
    cleaning up0.09 ms
    Call Stack
    #CallerFile and line number
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1731
    17JDatabaseDriver->loadResult()JROOT/libraries/legacy/model/legacy.php:341
    16JModelLegacy->_getListCount()JROOT/libraries/legacy/model/list.php:290
    15JModelList->getTotal()JROOT/libraries/legacy/model/list.php:235
    14JModelList->getPagination()JROOT/components/com_content/models/category.php:257
    13ContentModelCategory->getItems()JROOT/libraries/legacy/view/legacy.php:401
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:115
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:257
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  24. Query Time: 0.67 ms After last query: 25.61 ms Query memory: 0.017 MB Memory before query: 3.994 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `jos_contentitem_tag_map` AS m
      INNER JOIN `jos_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.category'
      AND `m`.`content_item_id` = 24
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4i674919_jos8.m.tag_id1100.00Using where
    Profile
    StatusDuration
    starting0.17 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.05 ms
    System lock0.01 ms
    optimizing0.03 ms
    statistics0.10 ms
    preparing0.03 ms
    executing0.01 ms
    Sending data0.05 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.06 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1692
    13JDatabaseDriver->loadObjectList()JROOT/libraries/cms/helper/tags.php:426
    12JHelperTags->getItemTags()JROOT/libraries/legacy/view/category.php:217
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:257
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  25. Query Time: 0.86 ms After last query: 18.08 ms Query memory: 0.021 MB Memory before query: 4.025 MB
    CREATE TABLE IF NOT EXISTS `jos_powr` ( `data_type` VARCHAR(50) NOT NULL, `value` VARCHAR(50) NOT NULL, PRIMARY KEY (`data_type`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    Explain
    EXPLAIN not possible on query: CREATE TABLE IF NOT EXISTS `jos_powr` ( `data_type` VARCHAR(50) NOT NULL, `value` VARCHAR(50) NOT NULL, PRIMARY KEY (`data_type`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    Profile
    StatusDuration
    starting0.22 ms
    checking permissions0.01 ms
    Opening tables0.33 ms
    After create0.01 ms
    query end0.01 ms
    closing tables0.16 ms
    freeing items0.21 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/database.php:33
    16JDatabase->query()JROOT/plugins/content/powrshortcodes/powrshortcodes.php:44
    15PowrHelper->get_powr_token()JROOT/plugins/content/powrshortcodes/powrshortcodes.php:21
    14PowrHelper->__construct()JROOT/plugins/content/powrshortcodes/powrshortcodes.php:91
    13require_once JROOT/plugins/content/powrshortcodes/powrshortcodes.phpJROOT/libraries/cms/plugin/helper.php:230
    12JPluginHelper::import()JROOT/libraries/cms/plugin/helper.php:170
    11JPluginHelper::importPlugin()JROOT/components/com_content/views/category/view.html.php:105
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:257
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  26. Query Time: 0.66 ms After last query: 0.11 ms Query memory: 0.021 MB Memory before query: 4.047 MB Rows returned: 1
    SELECT value 
      FROM jos_powr
      WHERE data_type = 'powr_token'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEjos_powrconstPRIMARYPRIMARY152const1100.00NULL
    Profile
    StatusDuration
    starting0.09 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.11 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.02 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.26 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1456
    16JDatabaseDriver->loadAssoc()JROOT/plugins/content/powrshortcodes/powrshortcodes.php:49
    15PowrHelper->get_powr_token()JROOT/plugins/content/powrshortcodes/powrshortcodes.php:21
    14PowrHelper->__construct()JROOT/plugins/content/powrshortcodes/powrshortcodes.php:91
    13require_once JROOT/plugins/content/powrshortcodes/powrshortcodes.phpJROOT/libraries/cms/plugin/helper.php:230
    12JPluginHelper::import()JROOT/libraries/cms/plugin/helper.php:170
    11JPluginHelper::importPlugin()JROOT/components/com_content/views/category/view.html.php:105
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:257
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  27. Query Time: 3.96 ms After last query: 525.32 ms Query memory: 0.030 MB Memory before query: 4.707 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=24
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
      ORDER BY c.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1PRIMARYsconstPRIMARY,idx_left_rightPRIMARY4const1100.00Using temporary; Using filesort
    1PRIMARYcALLcat_idx,idx_access,idx_left_rightNO INDEX KEY COULD BE USEDNULLNULL2487.50Using where
    1PRIMARY<derived2>ref<auto_key0><auto_key0>4i674919_jos8.c.id4100.00Using where; Not exists; Using index
    2DERIVEDparentrangecat_idx,idx_left_rightcat_idx203NULL2100.00Using index condition; Using temporary; Using filesort
    2DERIVEDcatindexPRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_aliasidx_left_right8NULL24100.00Using where; Using index; Using join buffer (Block Nested Loop)
    Profile
    StatusDuration
    starting0.38 ms
    checking permissions0.01 ms
    checking permissions0.19 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.09 ms
    init0.14 ms
    System lock0.02 ms
    optimizing0.01 ms
    optimizing0.03 ms
    statistics0.65 ms
    preparing0.05 ms
    Creating tmp table0.04 ms
    Sorting result0.04 ms
    statistics0.26 ms
    preparing0.06 ms
    Creating tmp table0.08 ms
    Sorting result0.01 ms
    executing0.22 ms
    Sending data0.08 ms
    executing0.01 ms
    Sending data0.22 ms
    Creating sort index0.30 ms
    removing tmp table0.02 ms
    Creating sort index0.50 ms
    Creating sort index0.07 ms
    end0.01 ms
    removing tmp table0.13 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    removing tmp table0.10 ms
    closing tables0.02 ms
    freeing items0.07 ms
    cleaning up0.06 ms
    Call Stack
    #CallerFile and line number
    24JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1692
    23JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/categories/categories.php:309
    22JCategories->_load()JROOT/libraries/legacy/categories/categories.php:184
    21JCategories->get()JROOT/components/com_content/helpers/route.php:44
    20ContentHelperRoute::getArticleRoute()JROOT/components/com_content/views/category/tmpl/default_articles.php:128
    19include JROOT/components/com_content/views/category/tmpl/default_articles.phpJROOT/libraries/legacy/view/legacy.php:670
    18JViewLegacy->loadTemplate()JROOT/layouts/joomla/content/category_default.php:60
    17include JROOT/layouts/joomla/content/category_default.phpJROOT/libraries/cms/layout/file.php:121
    16JLayoutFile->render()JROOT/libraries/cms/layout/helper.php:72
    15JLayoutHelper::render()JROOT/components/com_content/views/category/tmpl/default.php:20
    14include JROOT/components/com_content/views/category/tmpl/default.phpJROOT/libraries/legacy/view/legacy.php:670
    13JViewLegacy->loadTemplate()JROOT/libraries/legacy/view/legacy.php:209
    12JViewLegacy->display()JROOT/libraries/legacy/view/category.php:233
    11JViewCategory->display()JROOT/components/com_content/views/category/view.html.php:258
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:257
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  28. Query Time: 2.50 ms After last query: 14.05 ms Query memory: 0.016 MB Memory before query: 4.738 MB Rows returned: 13
    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 <= '2022-08-16 16:29:03')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-08-16 16:29:03')
      AND m.access IN (1,1,5)
      AND m.client_id = 0
      AND (mm.menuid = 349 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmrefPRIMARY,published,newsfeedspublished1const38100.00Using index condition; Using where; Using filesort
    1SIMPLEerefelement_clientid,element_folder_clientidelement_clientid403i674919_jos8.m.module,const1100.00Using index condition; Using where
    1SIMPLEmmrefPRIMARYPRIMARY4i674919_jos8.m.id3100.00Using where; Using index
    Profile
    StatusDuration
    starting0.21 ms
    checking permissions0.01 ms
    checking permissions0.14 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    init0.16 ms
    System lock0.02 ms
    optimizing0.04 ms
    statistics0.12 ms
    preparing0.05 ms
    Sorting result0.01 ms
    executing0.01 ms
    Sending data0.02 ms
    Creating sort index1.34 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.21 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1692
    12JDatabaseDriver->loadObjectList()JROOT/libraries/cms/module/helper.php:409
    11JModuleHelper::getModuleList()JROOT/libraries/cms/module/helper.php:352
    10JModuleHelper::load()JROOT/libraries/cms/module/helper.php:84
    9JModuleHelper::getModules()JROOT/libraries/joomla/document/html.php:501
    8JDocumentHtml->countModules()JROOT/templates/protostar/index.php:60
    7require JROOT/templates/protostar/index.phpJROOT/libraries/joomla/document/html.php:578
    6JDocumentHtml->_loadTemplate()JROOT/libraries/joomla/document/html.php:635
    5JDocumentHtml->_fetchTemplate()JROOT/libraries/joomla/document/html.php:455
    4JDocumentHtml->parse()JROOT/libraries/cms/application/cms.php:1054
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:745
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:263
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  29. Query Time: 0.79 ms After last query: 322.54 ms Query memory: 0.015 MB Memory before query: 5.253 MB Rows returned: 1
    SELECT * 
      FROM `jos_creativesocialwidget_blocks`
      WHERE id = '1'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEjos_creativesocialwidget_blockssystemPRIMARYNO INDEX KEY COULD BE USEDNULLNULL1100.00NULL
    Profile
    StatusDuration
    starting0.13 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.05 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.21 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.04 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.07 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1456
    11JDatabaseDriver->loadAssoc()JROOT/modules/mod_creativesocialwidget/mod_creativesocialwidget.php:27
    10include JROOT/modules/mod_creativesocialwidget/mod_creativesocialwidget.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:697
    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:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  30. Query Time: 0.89 ms After last query: 0.20 ms Query memory: 0.015 MB Memory before query: 5.286 MB Rows returned: 6
    SELECT sp.id id_link, sp.id_type id_type, sp.name link_name, sp.link link_url, sp.target target, sa.name type_name, sa.url type_url 
      FROM `jos_creativesocialwidget_items` sp JOIN `jos_creativesocialwidget_link_types` sa
      ON sa.id = sp.id_type
      WHERE sp.published = '1'
      AND sp.id_share = '1'
      ORDER BY sp.ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEsprefid_share,id_userid_share4const13100.00Using where; Using filesort
    1SIMPLEsaeq_refPRIMARYPRIMARY4i674919_jos8.sp.id_type1100.00NULL
    Profile
    StatusDuration
    starting0.10 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.06 ms
    preparing0.03 ms
    Sorting result0.01 ms
    executing0.01 ms
    Sending data0.01 ms
    Creating sort index0.45 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.06 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1497
    11JDatabaseDriver->loadAssocList()JROOT/modules/mod_creativesocialwidget/mod_creativesocialwidget.php:179
    10include JROOT/modules/mod_creativesocialwidget/mod_creativesocialwidget.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:697
    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:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  31. Query Time: 0.35 ms After last query: 34.60 ms Query memory: 0.019 MB Memory before query: 5.306 MB Rows returned: 0
    SELECT uikit
    
      FROM `jos_cwgears`
      WHERE url = 'http://www.acornsoftware.net/school-en/blog'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLENULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLNULLImpossible WHERE noticed after reading const tables
    Profile
    StatusDuration
    starting0.11 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.02 ms
    executing0.01 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.06 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1731
    15JDatabaseDriver->loadResult()JROOT/plugins/system/cwgears/helpers/loadcount.php:48
    14CwGearsHelperLoadcount::getCounts()JROOT/plugins/system/cwgears/cwgears.php:347
    13plgSystemCwgears->onBeforeCompileHead()Same as call in the line below.
    12call_user_func_array()JROOT/libraries/joomla/event/event.php:69
    11JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    10JEventDispatcher->trigger()JROOT/libraries/joomla/application/base.php:106
    9JApplicationBase->triggerEvent()JROOT/libraries/joomla/document/renderer/html/head.php:58
    8JDocumentRendererHtmlHead->fetchHead()JROOT/libraries/joomla/document/renderer/html/head.php:34
    7JDocumentRendererHtmlHead->render()JROOT/libraries/joomla/document/html.php:411
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:697
    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:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  32. Query Time: 0.28 ms After last query: 0.18 ms Query memory: 0.019 MB Memory before query: 5.326 MB Rows returned: 0
    SELECT uikit_plus
    
      FROM `jos_cwgears`
      WHERE url = 'http://www.acornsoftware.net/school-en/blog'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLENULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLNULLImpossible WHERE noticed after reading const tables
    Profile
    StatusDuration
    starting0.07 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    executing0.01 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.06 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1731
    15JDatabaseDriver->loadResult()JROOT/plugins/system/cwgears/helpers/loadcount.php:48
    14CwGearsHelperLoadcount::getCounts()JROOT/plugins/system/cwgears/cwgears.php:356
    13plgSystemCwgears->onBeforeCompileHead()Same as call in the line below.
    12call_user_func_array()JROOT/libraries/joomla/event/event.php:69
    11JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    10JEventDispatcher->trigger()JROOT/libraries/joomla/application/base.php:106
    9JApplicationBase->triggerEvent()JROOT/libraries/joomla/document/renderer/html/head.php:58
    8JDocumentRendererHtmlHead->fetchHead()JROOT/libraries/joomla/document/renderer/html/head.php:34
    7JDocumentRendererHtmlHead->render()JROOT/libraries/joomla/document/html.php:411
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:697
    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:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  33. Query Time: 1.56 ms After last query: 61.61 ms Query memory: 0.017 MB Memory before query: 5.435 MB Rows returned: 46
    Duplicate queries: #4
    SELECT extension_id AS id, element AS "option", params, enabled
    
      FROM jos_extensions
      WHERE `type` = 'component'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEjos_extensionsrefextensionextension82const46100.00Using index condition
    Profile
    StatusDuration
    starting0.21 ms
    checking permissions0.01 ms
    Opening tables0.19 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.33 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.48 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.95 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1692
    14JDatabaseDriver->loadObjectList()Same as call in the line below.
    13call_user_func_array()JROOT/libraries/joomla/cache/controller/callback.php:157
    12JCacheControllerCallback->get()JROOT/libraries/cms/component/helper.php:448
    11JComponentHelper::load()JROOT/libraries/cms/component/helper.php:43
    10JComponentHelper::getComponent()JROOT/libraries/cms/component/helper.php:120
    9JComponentHelper::getParams()JROOT/plugins/system/cwfacebookjs/cwfacebookjs.php:68
    8plgSystemCwfacebookjs->onAfterRender()Same as call in the line below.
    7call_user_func_array()JROOT/libraries/joomla/event/event.php:69
    6JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    5JEventDispatcher->trigger()JROOT/libraries/joomla/application/base.php:106
    4JApplicationBase->triggerEvent()JROOT/libraries/cms/application/cms.php:1074
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:745
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:263
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

30 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 3 × SELECT extension_id AS id, element AS "option", params, enabled 
      FROM jos_extensions
  2. 2 × SELECT b.rules 
      FROM jos_assets AS a
      LEFT JOIN jos_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  3. 1 × SELECT `m`.`tag_id`,`t`.* 
      FROM `jos_contentitem_tag_map` AS m
      INNER JOIN `jos_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
  4. 1 × SELECT COUNT(*) 
      FROM jos_content AS a
      LEFT JOIN jos_content_frontpage AS fp
      ON fp.content_id = a.id
      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
  5. 1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,
      CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
      CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
      FROM jos_content AS a
      LEFT JOIN jos_content_frontpage AS fp
      ON fp.content_id = a.id
      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
  6. 1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems
      FROM jos_categories as c
      LEFT JOIN (SELECT cat.id as id
      FROM jos_categories AS cat JOIN jos_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
  7. 1 × SELECT value 
      FROM jos_powr
  8. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM jos_modules AS m
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN jos_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
  9. 1 × SELECT uikit_plus 
      FROM `jos_cwgears`
  10. 1 × SELECT uikit 
      FROM `jos_cwgears`
  11. 1 × SELECT sp.id id_link, sp.id_type id_type, sp.name link_name, sp.link link_url, sp.target target, sa.name type_name, sa.url type_url 
      FROM `jos_creativesocialwidget_items` sp JOIN `jos_creativesocialwidget_link_types` sa
      ON sa.id = sp.id_type
  12. 1 × SELECT * 
      FROM `jos_creativesocialwidget_blocks`
  13. 1 × 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
  14. 1 × SELECT id, home, template, s.params 
      FROM jos_template_styles as s
      LEFT JOIN jos_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
  15. 1 × SELECT folder AS type, element AS name, params 
      FROM jos_extensions
  16. 1 × SELECT count(*) 
      FROM `jos_cwgears_schedule
  17. 1 × SELECT id, rules 
      FROM `jos_viewlevels
  18. 1 × SELECT b.id 
      FROM jos_usergroups AS a
      LEFT JOIN jos_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  19. 1 × SELECT `session_id` 
      FROM `jos_session`
  20. 1 × SELECT count(*) 
      FROM `jos_cwgears_schedule`
  21. 1 × SELECT timestamp 
      FROM jos_zt_visitor_counter
  22. 1 × SELECT `data` 
      FROM `jos_session`
  23. 1 × SELECT * 
      FROM jos_languages
  24. 1 × SELECT count(*) 
      FROM `jos_extensions`
  25. 1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
      FROM jos_menu AS m
      LEFT JOIN jos_extensions AS e
      ON m.component_id = e.extension_id
  26. 1 × SELECT a.rules 
      FROM jos_assets AS a
OTHER Tables:
  1. 1 × CREATE TABLE IF NOT EXISTS `jos_powr` ( `data_type` VARCHAR(50) NOT NULL, `value` VARCHAR(50) NOT NULL, PRIMARY KEY (`data_type`)) ENGINE=InnoDB DEFAULT CHARSET=utf8
  2. 1 × UPDATE `jos_extensions` 
      SET `params` = '{\"mediaversion\":\"e2b5490d979331082bab6190bc95b051\"}'
  3. 1 × UPDATE jos_zt_visitor_counter 
      SET visits=visits + 1, guests=guests + 1, useragent = 'other'
  4. 1 × INSERT INTO `jos_session` (`session_id`, `client_id`, `time`) 
      VALUES ('mgrheoii0eduhdephhf5jvesc3', 0, '1660667342'