London Swimming

London Swimming

  • Home
  • About
    • Who We Are
    • Staff Team
    • Management Board
    • Governance
    • Awards
    • Health and Safety
    • Membership/Affiliations
    • Other Useful Contacts
  • Disciplines
    • Competitive Swimming
    • Disability Swimming
    • Diving
    • Masters and Adult Swimming
    • Open Water Swimming
    • Synchronised Swimming
    • Water Polo
  • Poolside
    • Coaches
    • Officials
    • Volunteering
    • Jobs Board
  • Clubs
    • Club Development
    • Club Guidance Documents
    • London Clubs List
    • Find a Club – Clubs Map
    • London's Courses
    • Funding
    • Newsletters
    • SwimMark
    • FAQ's
  • Welfare
  • Leisure Swim
    • Learn to Swim
    • Why Swim
    • Where to Swim
    • Swim Schools
  • News
  • Downloads
  • Calendar
  • Contact Us
 
 

Disciplines

  • Competitive Swimming
  • Disability Swimming
  • Diving
  • Masters Swimming
  • Open Water Swimming
  • Synchronised Swimming
  • Water Polo

About Us

  • Who We Are
  • Management Board
  • Staff Team
  • News
  • Awards
  • Downloads
  • Health and Safety
  • Membership/Affiliations
  • Contact Us
  • Other Useful Contacts

Clubs

  • Coaches
  • Officials
  • Volunteering
  • Club Guidance Documents
  • Funding
  • Newsletters
  • SwimMark
  • Find a Club – Clubs Map
  • London Clubs List
  • FAQ's

Leisure Swim

  • Learn to Swim
  • Why Swim
  • Where to Swim
  • Swim Schools

London Clubs Map

london club map small
 
  • SRS Logo
  • SpacerSpacer
  • Facebook
  • Twitter
©2018 London Swimming | Sitemap | Disclaimer | Cookies | Accessibility | Website design by Bluewave Web Solutions
Back to top

Joomla! Debug Console

Session

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

Profile Information

Time

Memory

Time: 275.37 ms / 275.37 ms Memory: 1.830 MB / 2.05 MB Application: afterLoad
Time: 867.66 ms / 1143.04 ms Memory: 6.497 MB / 8.54 MB Application: afterInitialise
Time: 262.31 ms / 1405.35 ms Memory: 2.204 MB / 10.75 MB Application: afterRoute
Time: 33.06 ms / 1438.41 ms Memory: 0.462 MB / 11.21 MB Application: beforeRenderComponent com_phocadownload
Time: 212.99 ms / 1651.40 ms Memory: 1.743 MB / 12.95 MB Application: afterRenderComponent com_phocadownload
Time: 287.72 ms / 1939.13 ms Memory: 1.372 MB / 14.32 MB Application: afterDispatch
Time: 83.08 ms / 2022.20 ms Memory: 0.501 MB / 14.83 MB Application: beforeRenderModule mod_abiviaautocopy (Footer)
Time: 16.16 ms / 2038.36 ms Memory: 0.055 MB / 14.88 MB Application: afterRenderModule mod_abiviaautocopy (Footer)
Time: 0.20 ms / 2038.56 ms Memory: 0.000 MB / 14.88 MB Application: beforeRenderModule mod_menu (Disciplines)
Time: 92.31 ms / 2130.87 ms Memory: 0.183 MB / 15.06 MB Application: afterRenderModule mod_menu (Disciplines)
Time: 0.13 ms / 2131.00 ms Memory: 0.000 MB / 15.05 MB Application: beforeRenderModule mod_menu (About Us)
Time: 82.95 ms / 2213.95 ms Memory: 0.100 MB / 15.15 MB Application: afterRenderModule mod_menu (About Us)
Time: 0.10 ms / 2214.05 ms Memory: 0.000 MB / 15.15 MB Application: beforeRenderModule mod_menu (Clubs)
Time: 83.03 ms / 2297.08 ms Memory: 0.087 MB / 15.23 MB Application: afterRenderModule mod_menu (Clubs)
Time: 0.11 ms / 2297.19 ms Memory: 0.000 MB / 15.23 MB Application: beforeRenderModule mod_menu (Leisure Swim)
Time: 39.38 ms / 2336.58 ms Memory: 0.045 MB / 15.27 MB Application: afterRenderModule mod_menu (Leisure Swim)
Time: 0.09 ms / 2336.67 ms Memory: 0.000 MB / 15.26 MB Application: beforeRenderModule mod_custom (London Clubs Map)
Time: 15.19 ms / 2351.86 ms Memory: 0.012 MB / 15.27 MB Application: afterRenderModule mod_custom (London Clubs Map)
Time: 0.13 ms / 2351.99 ms Memory: 0.000 MB / 15.27 MB Application: beforeRenderModule mod_articles_single (Footer Line)
Time: 30.22 ms / 2382.21 ms Memory: 0.165 MB / 15.44 MB Application: Before Access::preloadComponents (all components)
Time: 1.85 ms / 2384.06 ms Memory: 0.097 MB / 15.53 MB Application: After Access::preloadComponents (all components)
Time: 0.09 ms / 2384.16 ms Memory: 0.000 MB / 15.53 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Time: 7.62 ms / 2391.77 ms Memory: 0.049 MB / 15.58 MB Application: After Access::getAssetRules (id:8 name:com_content)
Time: 247.59 ms / 2639.36 ms Memory: 1.786 MB / 17.36 MB Application: afterRenderModule mod_articles_single (Footer Line)
Time: 0.16 ms / 2639.53 ms Memory: 0.000 MB / 17.32 MB Application: beforeRenderModule mod_menu (Social Media)
Time: 41.15 ms / 2680.68 ms Memory: 0.035 MB / 17.35 MB Application: afterRenderModule mod_menu (Social Media)
Time: 0.23 ms / 2680.91 ms Memory: 0.000 MB / 17.35 MB Application: beforeRenderModule mod_superfish_menu (Main Top Menu)
Time: 324.43 ms / 3005.33 ms Memory: 0.984 MB / 18.33 MB Application: afterRenderModule mod_superfish_menu (Main Top Menu)
Time: 0.51 ms / 3005.84 ms Memory: 0.002 MB / 18.34 MB Application: beforeRenderModule mod_universal_ajaxlivesearch (Search)
Time: 46.39 ms / 3052.23 ms Memory: 0.435 MB / 18.77 MB Application: afterRenderModule mod_universal_ajaxlivesearch (Search)
Time: 339.82 ms / 3392.05 ms Memory: 2.834 MB / 21.60 MB Application: afterRender

Database queries total: 26.96 ms

Memory Usage

22.27 MB (23,354,640 Bytes)

Database Queries

36 Queries Logged 26.96 ms


2 duplicate found!

2 duplicates: #15  #16
  1. Query Time: 0.39 ms Query memory: 0.021 MB Memory before query: 4.249 MB Rows returned: 0
    SELECT `data`
    
      FROM `fz2kx_session`
      WHERE `session_id` = 'h2o9d2rsbbkdr96us6jnjl1830'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEfz2kx_sessionconstPRIMARYPRIMARY766const1
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.01 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.00 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1730
    15JDatabaseDriver->loadResult()JROOT/libraries/joomla/session/storage/database.php:45
    14JSessionStorageDatabase->read()Same as call in the line below.
    13session_start()JROOT/libraries/joomla/session/handler/native.php:260
    12JSessionHandlerNative->doSessionStart()JROOT/libraries/joomla/session/handler/native.php:50
    11JSessionHandlerNative->start()JROOT/libraries/joomla/session/handler/joomla.php:88
    10JSessionHandlerJoomla->start()JROOT/libraries/src/Session/Session.php:660
    9Joomla\CMS\Session\Session->_start()JROOT/libraries/src/Session/Session.php:620
    8Joomla\CMS\Session\Session->start()JROOT/libraries/src/Session/Session.php:498
    7Joomla\CMS\Session\Session->get()JROOT/libraries/src/Session/Session.php:455
    6Joomla\CMS\Session\Session->isNew()JROOT/libraries/src/Application/CMSApplication.php:755
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:134
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:343
    2Joomla\CMS\Application\CMSApplication::getInstance()JROOT/libraries/src/Factory.php:140
    1Joomla\CMS\Factory::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.34 ms After last query: 17.67 ms Query memory: 0.013 MB Memory before query: 4.426 MB Rows returned: 0
    SELECT `session_id`
    
      FROM `fz2kx_session`
      WHERE `session_id` = 'h2o9d2rsbbkdr96us6jnjl1830'
      LIMIT 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEfz2kx_sessionconstPRIMARYPRIMARY766const1Using index
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.02 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.01 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.00 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    9JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1730
    8JDatabaseDriver->loadResult()JROOT/libraries/src/Session/MetadataManager.php:74
    7Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()JROOT/libraries/src/Application/CMSApplication.php:152
    6Joomla\CMS\Application\CMSApplication->checkSession()JROOT/libraries/src/Application/CMSApplication.php:757
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:134
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:343
    2Joomla\CMS\Application\CMSApplication::getInstance()JROOT/libraries/src/Factory.php:140
    1Joomla\CMS\Factory::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.010 MB Memory before query: 4.443 MB
    INSERT INTO `fz2kx_session`
    (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES ('h2o9d2rsbbkdr96us6jnjl1830', 1, '1524524551', 0, '', 0)
    Explain
    EXPLAIN not possible on query: INSERT INTO `fz2kx_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('h2o9d2rsbbkdr96us6jnjl1830', 1, '1524524551', 0, '', 0)
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.02 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.02 ms
    update0.10 ms
    end0.01 ms
    query end0.21 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    8JDatabaseDriverMysqli->execute()JROOT/libraries/src/Session/MetadataManager.php:116
    7Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()JROOT/libraries/src/Application/CMSApplication.php:152
    6Joomla\CMS\Application\CMSApplication->checkSession()JROOT/libraries/src/Application/CMSApplication.php:757
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:134
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:343
    2Joomla\CMS\Application\CMSApplication::getInstance()JROOT/libraries/src/Factory.php:140
    1Joomla\CMS\Factory::getApplication()JROOT/index.php:46
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  4. Query Time: 0.92 ms After last query: 56.68 ms Query memory: 0.027 MB Memory before query: 4.771 MB Rows returned: 41
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `fz2kx_extensions`
      WHERE `type` = 'component'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEfz2kx_extensionsrefextensionextension82const41Using index condition
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.19 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.22 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.07 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    11JDatabaseDriver->loadObjectList()JROOT/libraries/src/Component/ComponentHelper.php:423
    10Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()Same as call in the line below.
    9call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    8Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Component/ComponentHelper.php:431
    7Joomla\CMS\Component\ComponentHelper::load()JROOT/libraries/src/Component/ComponentHelper.php:497
    6Joomla\CMS\Component\ComponentHelper::getComponents()JROOT/libraries/src/Component/ComponentHelper.php:44
    5Joomla\CMS\Component\ComponentHelper::getComponent()JROOT/libraries/src/Component/ComponentHelper.php:103
    4Joomla\CMS\Component\ComponentHelper::getParams()JROOT/libraries/src/Application/SiteApplication.php:596
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:195
    1Joomla\CMS\Application\CMSApplication->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.42 ms After last query: 47.05 ms Query memory: 0.015 MB Memory before query: 5.089 MB Rows returned: 5
    SELECT id, rules
    
      FROM `fz2kx_viewlevels`
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEfz2kx_viewlevelsALLNULLNO INDEX KEY COULD BE USEDNULLNULL5
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.01 ms
    Sending data0.03 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1496
    9JDatabaseDriver->loadAssocList()JROOT/libraries/src/Access/Access.php:1063
    8Joomla\CMS\Access\Access::getAuthorisedViewLevels()JROOT/libraries/src/User/User.php:458
    7Joomla\CMS\User\User->getAuthorisedViewLevels()JROOT/libraries/src/Plugin/PluginHelper.php:310
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:606
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:195
    1Joomla\CMS\Application\CMSApplication->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.48 ms After last query: 0.25 ms Query memory: 0.015 MB Memory before query: 5.114 MB Rows returned: 2
    SELECT b.id
    
      FROM fz2kx_usergroups AS a
      LEFT JOIN fz2kx_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.id = 9
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaconstPRIMARYPRIMARY4const1
    1SIMPLEbrangeidx_usergroup_nested_set_lookupidx_usergroup_nested_set_lookup4NULL3Using where; Using index
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.03 ms
    optimizing0.01 ms
    statistics0.07 ms
    preparing0.02 ms
    Unlocking tables0.02 ms
    executing0.01 ms
    Sending data0.02 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1540
    10JDatabaseDriver->loadColumn()JROOT/libraries/src/Access/Access.php:980
    9Joomla\CMS\Access\Access::getGroupsByUser()JROOT/libraries/src/Access/Access.php:1095
    8Joomla\CMS\Access\Access::getAuthorisedViewLevels()JROOT/libraries/src/User/User.php:458
    7Joomla\CMS\User\User->getAuthorisedViewLevels()JROOT/libraries/src/Plugin/PluginHelper.php:310
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:606
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:195
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  7. Query Time: 2.44 ms After last query: 7.67 ms Query memory: 0.019 MB Memory before query: 5.208 MB Rows returned: 96
    SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
    
      FROM fz2kx_extensions
      WHERE enabled = 1
      AND type = 'plugin'
      AND state IN (0,1)
      AND access IN (1,1,5)
      ORDER BY ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEfz2kx_extensionsrefextensionextension82const139Using index condition; Using where; Using filesort
    Profile
    StatusDuration
    starting0.08 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.02 ms
    optimizing0.04 ms
    statistics0.04 ms
    preparing0.03 ms
    executing0.01 ms
    Sorting result1.21 ms
    Sending data0.60 ms
    end0.02 ms
    query end0.01 ms
    closing tables0.00 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.05 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    10JDatabaseDriver->loadObjectList()JROOT/libraries/src/Plugin/PluginHelper.php:343
    9Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()Same as call in the line below.
    8call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    7Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Plugin/PluginHelper.php:348
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:606
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:195
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  8. Query Time: 1.42 ms After last query: 449.65 ms Query memory: 0.013 MB Memory before query: 8.276 MB
    DELETE 
    
      FROM `fz2kx_jhackguard_ip_filters`
      WHERE `expires` BETWEEN DATE_SUB(CURRENT_DATE, INTERVAL 36500 DAY)
      AND DATE_SUB(CURRENT_DATE, INTERVAL 1 DAY)
    Explain
    EXPLAIN not possible on query: DELETE FROM `fz2kx_jhackguard_ip_filters` WHERE `expires` BETWEEN DATE_SUB(CURRENT_DATE, INTERVAL 36500 DAY) AND DATE_SUB(CURRENT_DATE, INTERVAL 1 DAY)
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.02 ms
    updating0.02 ms
    end0.01 ms
    query end0.02 ms
    closing tables0.01 ms
    Unlocking tables0.03 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/database.php:33
    10JDatabase->query()JROOT/plugins/system/jhackguard/jhackguard.php:156
    9PlgSystemJhackguard->onAfterInitialise()Same as call in the line below.
    8call_user_func_array()JROOT/libraries/joomla/event/event.php:70
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    6JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    5Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:623
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:688
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:195
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  9. Query Time: 0.37 ms After last query: 0.41 ms Query memory: 0.016 MB Memory before query: 8.294 MB Rows returned: 0
    SELECT `state`,`rule_type`
    
      FROM `fz2kx_jhackguard_ip_filters`
      WHERE `ip` = '54.156.37.174'
      AND `state` = 1
      ORDER BY ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLENULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLImpossible WHERE noticed after reading const tables
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.01 ms
    Unlocking tables0.01 ms
    executing0.01 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.00 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.04 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1652
    11JDatabaseDriver->loadObject()JROOT/plugins/system/jhackguard/jhackguard.php:358
    10PlgSystemJhackguard->ip_is()JROOT/plugins/system/jhackguard/jhackguard.php:174
    9PlgSystemJhackguard->onAfterInitialise()Same as call in the line below.
    8call_user_func_array()JROOT/libraries/joomla/event/event.php:70
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    6JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    5Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:623
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:688
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:195
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  10. Query Time: 2.71 ms After last query: 45.14 ms Query memory: 0.052 MB Memory before query: 8.868 MB Rows returned: 154
    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 fz2kx_menu AS m
      LEFT JOIN fz2kx_extensions AS e
      ON m.component_id = e.extension_id
      WHERE m.published = 1
      AND m.parent_id > 0
      AND m.client_id = 0
      ORDER BY m.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLidx_client_id_parent_id_alias_languageNO INDEX KEY COULD BE USEDNULLNULL260Using where; Using filesort
    1SIMPLEeeq_refPRIMARYPRIMARY4ldswim_jldb3.m.component_id1Using where
    Profile
    StatusDuration
    starting0.12 ms
    checking permissions0.02 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.02 ms
    System lock0.01 ms
    Table lock0.02 ms
    init0.03 ms
    optimizing0.03 ms
    statistics0.05 ms
    preparing0.04 ms
    executing0.01 ms
    Sorting result0.37 ms
    Sending data1.53 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.02 ms
    freeing items0.01 ms
    updating status0.04 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    18JDatabaseDriver->loadObjectList()JROOT/libraries/src/Menu/SiteMenu.php:93
    17Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()Same as call in the line below.
    16call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Menu/SiteMenu.php:101
    14Joomla\CMS\Menu\SiteMenu->load()JROOT/libraries/src/Menu/AbstractMenu.php:76
    13Joomla\CMS\Menu\AbstractMenu->__construct()JROOT/libraries/src/Menu/SiteMenu.php:62
    12Joomla\CMS\Menu\SiteMenu->__construct()JROOT/libraries/src/Menu/AbstractMenu.php:131
    11Joomla\CMS\Menu\AbstractMenu::getInstance()JROOT/libraries/src/Application/CMSApplication.php:374
    10Joomla\CMS\Application\CMSApplication->getMenu()JROOT/libraries/src/Application/SiteApplication.php:275
    9Joomla\CMS\Application\SiteApplication->getMenu()JROOT/libraries/src/Router/SiteRouter.php:64
    8Joomla\CMS\Router\SiteRouter->__construct()JROOT/libraries/src/Router/Router.php:189
    7Joomla\CMS\Router\Router::getInstance()JROOT/libraries/src/Application/CMSApplication.php:488
    6Joomla\CMS\Application\CMSApplication::getRouter()JROOT/libraries/src/Application/SiteApplication.php:405
    5Joomla\CMS\Application\SiteApplication::getRouter()JROOT/libraries/src/Application/CMSApplication.php:1070
    4Joomla\CMS\Application\CMSApplication->route()JROOT/libraries/src/Application/SiteApplication.php:798
    3Joomla\CMS\Application\SiteApplication->route()JROOT/libraries/src/Application/SiteApplication.php:218
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:195
    1Joomla\CMS\Application\CMSApplication->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.53 ms After last query: 235.46 ms Query memory: 0.020 MB Memory before query: 10.801 MB Rows returned: 1
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `fz2kx_extensions`
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEfz2kx_extensionsrefelement_clientid,element_folder_clientid,extensionextension484const,const1Using index condition
    Profile
    StatusDuration
    starting0.07 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.08 ms
    preparing0.03 ms
    executing0.01 ms
    Sending data0.05 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.00 ms
    Unlocking tables0.02 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1652
    14JDatabaseDriver->loadObject()JROOT/libraries/src/Helper/LibraryHelper.php:167
    13Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()Same as call in the line below.
    12call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    11Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/LibraryHelper.php:175
    10Joomla\CMS\Helper\LibraryHelper::loadLibrary()JROOT/libraries/src/Helper/LibraryHelper.php:43
    9Joomla\CMS\Helper\LibraryHelper::getLibrary()JROOT/libraries/src/Helper/LibraryHelper.php:90
    8Joomla\CMS\Helper\LibraryHelper::getParams()JROOT/libraries/src/Version.php:321
    7Joomla\CMS\Version->getMediaVersion()JROOT/libraries/src/Factory.php:778
    6Joomla\CMS\Factory::createDocument()JROOT/libraries/src/Factory.php:234
    5Joomla\CMS\Factory::getDocument()JROOT/libraries/src/Application/WebApplication.php:1113
    4Joomla\CMS\Application\WebApplication->loadDocument()JROOT/libraries/src/Application/SiteApplication.php:133
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:195
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  12. Query Time: 0.71 ms After last query: 0.34 ms Query memory: 0.013 MB Memory before query: 10.804 MB
    UPDATE `fz2kx_extensions`
    
      SET `params` = '{\"mediaversion\":\"93993d2841b1155c0fd7b4aa84c39c02\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    EXPLAIN not possible on query: UPDATE `fz2kx_extensions` SET `params` = '{\"mediaversion\":\"93993d2841b1155c0fd7b4aa84c39c02\"}' WHERE `type` = 'library' AND `element` = 'joomla'
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    init0.08 ms
    updating0.06 ms
    end0.01 ms
    query end0.34 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/src/Helper/LibraryHelper.php:117
    9Joomla\CMS\Helper\LibraryHelper::saveParams()JROOT/libraries/src/Version.php:372
    8Joomla\CMS\Version->setMediaVersion()JROOT/libraries/src/Version.php:331
    7Joomla\CMS\Version->getMediaVersion()JROOT/libraries/src/Factory.php:778
    6Joomla\CMS\Factory::createDocument()JROOT/libraries/src/Factory.php:234
    5Joomla\CMS\Factory::getDocument()JROOT/libraries/src/Application/WebApplication.php:1113
    4Joomla\CMS\Application\WebApplication->loadDocument()JROOT/libraries/src/Application/SiteApplication.php:133
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:195
    1Joomla\CMS\Application\CMSApplication->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.35 ms After last query: 15.45 ms Query memory: 0.014 MB Memory before query: 11.145 MB Rows returned: 1
    SELECT *
    
      FROM fz2kx_languages
      WHERE published=1
      ORDER BY ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEfz2kx_languagesALLNULLNO INDEX KEY COULD BE USEDNULLNULL1Using where; Using filesort
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.01 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sorting result0.03 ms
    Sending data0.02 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.00 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    7JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    6JDatabaseDriver->loadObjectList()JROOT/libraries/src/Language/LanguageHelper.php:150
    5Joomla\CMS\Language\LanguageHelper::getLanguages()JROOT/libraries/src/Application/SiteApplication.php:330
    4Joomla\CMS\Application\SiteApplication->getParams()JROOT/libraries/src/Application/SiteApplication.php:138
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:195
    1Joomla\CMS\Application\CMSApplication->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.42 ms After last query: 1.22 ms Query memory: 0.010 MB Memory before query: 11.169 MB Rows returned: 4
    SELECT id, home, template, s.params
    
      FROM fz2kx_template_styles as s
      LEFT JOIN fz2kx_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
      WHERE s.client_id = 0
      AND e.enabled = 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsALLidx_templateNO INDEX KEY COULD BE USEDNULLNULL6Using where
    1SIMPLEerefelement_clientid,element_folder_clientid,extensionelement_clientid403ldswim_jldb3.s.template,const1Using index condition; Using where
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.06 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    6JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    5JDatabaseDriver->loadObjectList()JROOT/libraries/src/Application/SiteApplication.php:488
    4Joomla\CMS\Application\SiteApplication->getTemplate()JROOT/libraries/src/Application/SiteApplication.php:168
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:195
    1Joomla\CMS\Application\CMSApplication->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.54 ms After last query: 134.01 ms Query memory: 0.020 MB Memory before query: 12.320 MB Rows returned: 0
    Duplicate queries: #16
    SELECT cc.id, cc.title, cc.alias, cc.description, cc.access as cataccess, cc.accessuserid as cataccessuserid 
      FROM fz2kx_phocadownload_categories AS cc
      LEFT JOIN fz2kx_phocadownload AS c
      ON c.catid = cc.id
      WHERE c.id= 152
      AND cc.access IN (1,1,5)
      AND cc.published = 1
      ORDER BY cc.ordering
      LIMIT 0, 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLENULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLImpossible WHERE noticed after reading const tables
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.01 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.21 ms
    preparing0.01 ms
    Unlocking tables0.01 ms
    executing0.01 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    13JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    12Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/components/com_phocadownload/models/file.php:124
    11PhocaDownloadModelFile->getCategory()JROOT/components/com_phocadownload/views/file/view.html.php:44
    10PhocaDownloadViewFile->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_phocadownload/controller.php:34
    8PhocaDownloadController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_phocadownload/phocadownload.php:53
    6require_once JROOT/components/com_phocadownload/phocadownload.phpJROOT/libraries/src/Component/ComponentHelper.php:382
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:357
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:195
    1Joomla\CMS\Application\CMSApplication->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.34 ms After last query: 0.15 ms Query memory: 0.023 MB Memory before query: 12.340 MB Rows returned: 0
    Duplicate queries: #15
    SELECT cc.id, cc.title, cc.alias, cc.description, cc.access as cataccess, cc.accessuserid as cataccessuserid 
      FROM fz2kx_phocadownload_categories AS cc
      LEFT JOIN fz2kx_phocadownload AS c
      ON c.catid = cc.id
      WHERE c.id= 152
      AND cc.access IN (1,1,5)
      AND cc.published = 1
      ORDER BY cc.ordering
      LIMIT 0, 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLENULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLImpossible WHERE noticed after reading const tables
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.00 ms
    Unlocking tables0.01 ms
    executing0.01 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.01 ms
    freeing items0.02 ms
    updating status0.01 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    15JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    14Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/components/com_phocadownload/models/file.php:124
    13PhocaDownloadModelFile->getCategory()JROOT/components/com_phocadownload/models/file.php:75
    12PhocaDownloadModelFile->_getFileQuery()JROOT/components/com_phocadownload/models/file.php:35
    11PhocaDownloadModelFile->getFile()JROOT/components/com_phocadownload/views/file/view.html.php:45
    10PhocaDownloadViewFile->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_phocadownload/controller.php:34
    8PhocaDownloadController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_phocadownload/phocadownload.php:53
    6require_once JROOT/components/com_phocadownload/phocadownload.phpJROOT/libraries/src/Component/ComponentHelper.php:382
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:357
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:195
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  17. Query Time: 1.62 ms After last query: 0.28 ms Query memory: 0.034 MB Memory before query: 12.364 MB Rows returned: 0
    SELECT c.*, cc.id AS categoryid, cc.title AS categorytitle, cc.alias AS categoryalias, cc.access as cataccess, cc.accessuserid as cataccessuserid, lc.title AS licensetitle, lc.description AS licensetext, lc.id AS licenseid 
      FROM fz2kx_phocadownload AS c
      LEFT JOIN fz2kx_phocadownload_categories AS cc
      ON cc.id = c.catid
      LEFT JOIN fz2kx_phocadownload_licenses AS lc
      ON lc.id = c.confirm_license
      WHERE c.catid= 0
      AND c.catid= cc.id
      AND ( (unaccessible_file = 1 ) OR (unaccessible_file = 0
      AND c.access IN (1,1,5) ) )
      AND ( (unaccessible_file = 1 ) OR (unaccessible_file = 0
      AND cc.access IN (1,1,5) ) )
      AND c.published = 1
      AND c.approved = 1
      AND cc.published = 1
      AND c.id = 152
      AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2018-04-23 23:02:32' )
      AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2018-04-23 23:02:32' )
      ORDER BY c.ordering
      LIMIT 0, 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLENULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLImpossible WHERE noticed after reading const tables
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables1.11 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    init0.05 ms
    optimizing0.03 ms
    statistics0.04 ms
    preparing0.01 ms
    executing0.03 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    13JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    12Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/components/com_phocadownload/models/file.php:36
    11PhocaDownloadModelFile->getFile()JROOT/components/com_phocadownload/views/file/view.html.php:45
    10PhocaDownloadViewFile->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_phocadownload/controller.php:34
    8PhocaDownloadController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_phocadownload/phocadownload.php:53
    6require_once JROOT/components/com_phocadownload/phocadownload.phpJROOT/libraries/src/Component/ComponentHelper.php:382
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:357
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:195
    1Joomla\CMS\Application\CMSApplication->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.32 ms After last query: 8.99 ms Query memory: 0.019 MB Memory before query: 12.426 MB Rows returned: 3
    SELECT a.filename as filename, a.type as type, a.menulink as menulink 
      FROM fz2kx_phocadownload_styles AS a
      WHERE a.published = 1
      ORDER BY a.type, a.ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaALLNULLNO INDEX KEY COULD BE USEDNULLNULL6Using where; Using filesort
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sorting result0.02 ms
    Sending data0.02 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    12JDatabaseDriver->loadObjectList()JROOT/administrator/components/com_phocadownload/libraries/phocadownload/render/renderfront.php:22
    11PhocaDownloadRenderFront::renderAllCSS()JROOT/components/com_phocadownload/views/file/view.html.php:47
    10PhocaDownloadViewFile->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_phocadownload/controller.php:34
    8PhocaDownloadController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_phocadownload/phocadownload.php:53
    6require_once JROOT/components/com_phocadownload/phocadownload.phpJROOT/libraries/src/Component/ComponentHelper.php:382
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:357
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:195
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  19. Query Time: 0.41 ms After last query: 384.23 ms Query memory: 0.015 MB Memory before query: 14.442 MB Rows returned: 1
    SELECT template 
      FROM fz2kx_template_styles
      WHERE client_id = 1
      AND home = 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEfz2kx_template_stylesALLidx_homeNO INDEX KEY COULD BE USEDNULLNULL6Using where
    Profile
    StatusDuration
    starting0.07 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.01 ms
    executing0.01 ms
    Sending data0.04 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.00 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1730
    9JDatabaseDriver->loadResult()JROOT/templates/ls_theme/includes/includes.php:21
    8include_once JROOT/templates/ls_theme/includes/includes.phpJROOT/templates/ls_theme/index.php:4
    7require JROOT/templates/ls_theme/index.phpJROOT/libraries/src/Document/HtmlDocument.php:658
    6Joomla\CMS\Document\HtmlDocument->_loadTemplate()JROOT/libraries/src/Document/HtmlDocument.php:720
    5Joomla\CMS\Document\HtmlDocument->_fetchTemplate()JROOT/libraries/src/Document/HtmlDocument.php:535
    4Joomla\CMS\Document\HtmlDocument->parse()JROOT/libraries/src/Application/CMSApplication.php:1027
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:201
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  20. Query Time: 1.40 ms After last query: 6.03 ms Query memory: 0.023 MB Memory before query: 14.614 MB Rows returned: 10
    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM fz2kx_modules AS m
      LEFT JOIN fz2kx_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN fz2kx_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 <= '2018-04-23 23:02:32')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2018-04-23 23:02:32')
      AND m.access IN (1,1,5)
      AND m.client_id = 0
      AND (mm.menuid = 286 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrefPRIMARY,published,newsfeedspublished1const28Using index condition; Using where; Using filesort
    1SIMPLEerefelement_clientid,element_folder_clientidelement_clientid403ldswim_jldb3.m.module,const1Using index condition; Using where
    1SIMPLEmmrefPRIMARYPRIMARY4ldswim_jldb3.m.id1Using where; Using index
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.07 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.07 ms
    optimizing0.03 ms
    statistics0.07 ms
    preparing0.09 ms
    executing0.00 ms
    Sorting result0.30 ms
    Sending data0.44 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    15JDatabaseDriver->loadObjectList()Same as call in the line below.
    14call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    13Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/ModuleHelper.php:433
    12Joomla\CMS\Helper\ModuleHelper::getModuleList()JROOT/libraries/src/Helper/ModuleHelper.php:363
    11Joomla\CMS\Helper\ModuleHelper::load()JROOT/libraries/src/Helper/ModuleHelper.php:87
    10Joomla\CMS\Helper\ModuleHelper::getModules()JROOT/libraries/src/Document/HtmlDocument.php:581
    9Joomla\CMS\Document\HtmlDocument->countModules()JROOT/templates/ls_theme/includes/includes.php:81
    8include_once JROOT/templates/ls_theme/includes/includes.phpJROOT/templates/ls_theme/index.php:4
    7require JROOT/templates/ls_theme/index.phpJROOT/libraries/src/Document/HtmlDocument.php:658
    6Joomla\CMS\Document\HtmlDocument->_loadTemplate()JROOT/libraries/src/Document/HtmlDocument.php:720
    5Joomla\CMS\Document\HtmlDocument->_fetchTemplate()JROOT/libraries/src/Document/HtmlDocument.php:535
    4Joomla\CMS\Document\HtmlDocument->parse()JROOT/libraries/src/Application/CMSApplication.php:1027
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:201
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  21. Query Time: 0.93 ms After last query: 415.27 ms Query memory: 0.028 MB Memory before query: 15.440 MB Rows returned: 41
    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `fz2kx_assets`
      WHERE `name` IN ('root.1','com_admin','com_ajax','com_associations','com_autotweet','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_eventbooking','com_extplorer','com_fields','com_finder','com_installer','com_jce','com_jhackguard','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocadownload','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_universal_ajax_live_search','com_users','com_weblinks','com_wrapper','com_xmap')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEfz2kx_assetsrangeidx_asset_nameidx_asset_name202NULL42Using index condition
    Profile
    StatusDuration
    starting0.07 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.01 ms
    init0.03 ms
    optimizing0.01 ms
    statistics0.10 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.41 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    18JDatabaseDriver->loadObjectList()JROOT/libraries/src/Access/Access.php:429
    17Joomla\CMS\Access\Access::preloadComponents()JROOT/libraries/src/Access/Access.php:213
    16Joomla\CMS\Access\Access::preload()JROOT/libraries/src/Access/Access.php:531
    15Joomla\CMS\Access\Access::getAssetRules()JROOT/libraries/src/Access/Access.php:183
    14Joomla\CMS\Access\Access::check()JROOT/libraries/src/User/User.php:398
    13Joomla\CMS\User\User->authorise()JROOT/components/com_content/models/article.php:125
    12ContentModelArticle->getItem()JROOT/modules/mod_articles_single/helper.php:26
    11modArticlesSingleHelper::getItem()JROOT/modules/mod_articles_single/mod_articles_single.php:13
    10include JROOT/modules/mod_articles_single/mod_articles_single.phpJROOT/libraries/src/Helper/ModuleHelper.php:201
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:783
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1041
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:201
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  22. Query Time: 0.74 ms After last query: 8.36 ms Query memory: 0.028 MB Memory before query: 15.576 MB Rows returned: 1
    SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
      FROM fz2kx_content AS a
      INNER JOIN fz2kx_categories AS c
      on c.id = a.catid
      LEFT JOIN fz2kx_users AS u
      on u.id = a.created_by
      LEFT JOIN fz2kx_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN fz2kx_content_rating AS v
      ON a.id = v.content_id
      WHERE a.id = 65
      AND c.published > 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-23 23:02:32')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-23 23:02:32')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaconstPRIMARY,idx_catidPRIMARY4const1
    1SIMPLEcconstPRIMARYPRIMARY4const1
    1SIMPLEuconstPRIMARYPRIMARY4const1
    1SIMPLEparentconstPRIMARYPRIMARY4const1
    1SIMPLEvconstPRIMARYPRIMARY4const0unique row not found
    Profile
    StatusDuration
    starting0.10 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.05 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.05 ms
    optimizing0.05 ms
    statistics0.10 ms
    preparing0.01 ms
    Unlocking tables0.02 ms
    executing0.00 ms
    Sending data0.04 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.00 ms
    Unlocking tables0.02 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1652
    13JDatabaseDriver->loadObject()JROOT/components/com_content/models/article.php:148
    12ContentModelArticle->getItem()JROOT/modules/mod_articles_single/helper.php:26
    11modArticlesSingleHelper::getItem()JROOT/modules/mod_articles_single/mod_articles_single.php:13
    10include JROOT/modules/mod_articles_single/mod_articles_single.phpJROOT/libraries/src/Helper/ModuleHelper.php:201
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:783
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1041
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:201
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  23. Query Time: 0.51 ms After last query: 0.71 ms Query memory: 0.028 MB Memory before query: 15.626 MB Rows returned: 1
    SELECT `alias`
    
      FROM `fz2kx_content`
      WHERE id = '65'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEfz2kx_contentconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.00 ms
    Unlocking tables0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.01 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    22JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1730
    21JDatabaseDriver->loadResult()JROOT/components/com_content/router.php:125
    20ContentRouter->getArticleSegment()Same as call in the line below.
    19call_user_func_array()JROOT/libraries/src/Component/Router/RouterView.php:120
    18Joomla\CMS\Component\Router\RouterView->getPath()JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    17Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()JROOT/libraries/src/Component/Router/RouterView.php:222
    16Joomla\CMS\Component\Router\RouterView->preprocess()JROOT/libraries/src/Router/SiteRouter.php:670
    15Joomla\CMS\Router\SiteRouter->processBuildRules()JROOT/libraries/src/Router/Router.php:266
    14Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:154
    13Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:66
    12Joomla\CMS\Router\Route::_()JROOT/modules/mod_articles_single/helper.php:30
    11modArticlesSingleHelper::getItem()JROOT/modules/mod_articles_single/mod_articles_single.php:13
    10include JROOT/modules/mod_articles_single/mod_articles_single.phpJROOT/libraries/src/Helper/ModuleHelper.php:201
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:783
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1041
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:201
    1Joomla\CMS\Application\CMSApplication->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.72 ms After last query: 12.88 ms Query memory: 0.037 MB Memory before query: 15.733 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 `fz2kx_categories` AS `s`
      INNER JOIN `fz2kx_categories` AS `c`
      ON (s.lft <= c.lft
      AND c.lft < s.rgt) OR (c.lft < s.lft
      AND s.rgt < c.rgt)
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND s.id = 2
      ORDER BY c.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsconstPRIMARY,idx_left_rightPRIMARY4const1
    1SIMPLEcrangecat_idx,idx_access,idx_left_rightidx_left_right4NULL4Using index condition; Using where
    Profile
    StatusDuration
    starting0.09 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    init0.04 ms
    optimizing0.02 ms
    statistics0.13 ms
    preparing0.01 ms
    Unlocking tables0.03 ms
    executing0.00 ms
    Sorting result0.01 ms
    Sending data0.07 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    24JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    23JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:314
    22Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:186
    21Joomla\CMS\Categories\Categories->get()JROOT/components/com_content/router.php:72
    20ContentRouter->getCategorySegment()Same as call in the line below.
    19call_user_func_array()JROOT/libraries/src/Component/Router/RouterView.php:120
    18Joomla\CMS\Component\Router\RouterView->getPath()JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    17Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()JROOT/libraries/src/Component/Router/RouterView.php:222
    16Joomla\CMS\Component\Router\RouterView->preprocess()JROOT/libraries/src/Router/SiteRouter.php:670
    15Joomla\CMS\Router\SiteRouter->processBuildRules()JROOT/libraries/src/Router/Router.php:266
    14Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:154
    13Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:66
    12Joomla\CMS\Router\Route::_()JROOT/modules/mod_articles_single/helper.php:30
    11modArticlesSingleHelper::getItem()JROOT/modules/mod_articles_single/mod_articles_single.php:13
    10include JROOT/modules/mod_articles_single/mod_articles_single.phpJROOT/libraries/src/Helper/ModuleHelper.php:201
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:783
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1041
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:201
    1Joomla\CMS\Application\CMSApplication->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.45 ms After last query: 4.84 ms Query memory: 0.027 MB Memory before query: 15.832 MB Rows returned: 1
    SELECT alias
    
      FROM fz2kx_content
      WHERE id=65
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEfz2kx_contentconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.01 ms
    Unlocking tables0.05 ms
    executing0.01 ms
    Sending data0.02 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1730
    19JDatabaseDriver->loadResult()JROOT/components/com_content/helpers/legacyrouter.php:140
    18ContentRouterRulesLegacy->build()JROOT/libraries/src/Component/Router/RouterView.php:244
    17Joomla\CMS\Component\Router\RouterView->build()JROOT/libraries/src/Router/SiteRouter.php:528
    16Joomla\CMS\Router\SiteRouter->buildSefRoute()JROOT/libraries/src/Router/SiteRouter.php:498
    15Joomla\CMS\Router\SiteRouter->_buildSefRoute()JROOT/libraries/src/Router/Router.php:281
    14Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:154
    13Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:66
    12Joomla\CMS\Router\Route::_()JROOT/modules/mod_articles_single/helper.php:30
    11modArticlesSingleHelper::getItem()JROOT/modules/mod_articles_single/mod_articles_single.php:13
    10include JROOT/modules/mod_articles_single/mod_articles_single.phpJROOT/libraries/src/Helper/ModuleHelper.php:201
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:783
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1041
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:201
    1Joomla\CMS\Application\CMSApplication->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.79 ms After last query: 162.00 ms Query memory: 0.037 MB Memory before query: 16.749 MB Rows returned: 0
    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
    
      FROM fz2kx_fields AS a
      LEFT JOIN `fz2kx_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN fz2kx_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN fz2kx_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN fz2kx_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN fz2kx_fields_groups AS g
      ON g.id = a.group_id
      WHERE a.context = 'mod_articles_single.content'
      AND a.access IN (1,1,5)
      AND (a.group_id = 0 OR g.access IN (1,1,5))
      AND a.state = 1
      AND (a.group_id = 0 OR g.state = 1)
      ORDER BY a.ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarefidx_state,idx_access,idx_contextidx_state1const1Using where; Using filesort
    1SIMPLEleq_refidx_langcodeidx_langcode28ldswim_jldb3.a.language1Using where
    1SIMPLEuceq_refPRIMARYPRIMARY4ldswim_jldb3.a.checked_out1
    1SIMPLEageq_refPRIMARYPRIMARY4ldswim_jldb3.a.access1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4ldswim_jldb3.a.created_user_id1Using where
    1SIMPLEgeq_refPRIMARYPRIMARY4ldswim_jldb3.a.group_id1Using where
    Profile
    StatusDuration
    starting0.12 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.08 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.05 ms
    optimizing0.03 ms
    statistics0.07 ms
    preparing0.06 ms
    executing0.00 ms
    Sorting result0.02 ms
    Sending data0.03 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.00 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    24JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    23Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:327
    22FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    21Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    20FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:479
    19PlgSystemFields->onContentPrepare()Same as call in the line below.
    18call_user_func_array()JROOT/libraries/joomla/event/event.php:70
    17JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    16JEventDispatcher->trigger()JROOT/libraries/cms/html/content.php:41
    15JHtmlContent::prepare()Same as call in the line below.
    14call_user_func_array()JROOT/libraries/src/HTML/HTMLHelper.php:239
    13Joomla\CMS\HTML\HTMLHelper::call()JROOT/libraries/src/HTML/HTMLHelper.php:146
    12Joomla\CMS\HTML\HTMLHelper::_()JROOT/modules/mod_articles_single/helper.php:33
    11modArticlesSingleHelper::getItem()JROOT/modules/mod_articles_single/mod_articles_single.php:13
    10include JROOT/modules/mod_articles_single/mod_articles_single.phpJROOT/libraries/src/Helper/ModuleHelper.php:201
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:783
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1041
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:201
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  27. Query Time: 0.78 ms After last query: 27.01 ms Query memory: 0.036 MB Memory before query: 16.850 MB Rows returned: 0
    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
    
      FROM fz2kx_fields AS a
      LEFT JOIN `fz2kx_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN fz2kx_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN fz2kx_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN fz2kx_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN fz2kx_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `fz2kx_fields_categories` AS fc
      ON fc.field_id = a.id
      WHERE a.context = 'com_content.article'
      AND (fc.category_id IS NULL OR fc.category_id IN (2,0))
      AND a.access IN (1,1,5)
      AND (a.group_id = 0 OR g.access IN (1,1,5))
      AND a.state = 1
      AND (a.group_id = 0 OR g.state = 1)
      ORDER BY a.ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarefidx_state,idx_access,idx_contextidx_state1const1Using where; Using filesort
    1SIMPLEleq_refidx_langcodeidx_langcode28ldswim_jldb3.a.language1Using where
    1SIMPLEuceq_refPRIMARYPRIMARY4ldswim_jldb3.a.checked_out1
    1SIMPLEageq_refPRIMARYPRIMARY4ldswim_jldb3.a.access1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4ldswim_jldb3.a.created_user_id1Using where
    1SIMPLEgeq_refPRIMARYPRIMARY4ldswim_jldb3.a.group_id1Using where
    1SIMPLEfcrefPRIMARYPRIMARY4ldswim_jldb3.a.id1Using where; Using index
    Profile
    StatusDuration
    starting0.11 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.06 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.04 ms
    optimizing0.03 ms
    statistics0.06 ms
    preparing0.09 ms
    executing0.01 ms
    Sorting result0.03 ms
    Sending data0.03 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.00 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    23JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    22JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    21Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:327
    20FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    19Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    18FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:388
    17PlgSystemFields->display()JROOT/plugins/system/fields/fields.php:342
    16PlgSystemFields->onContentAfterDisplay()Same as call in the line below.
    15call_user_func_array()JROOT/libraries/joomla/event/event.php:70
    14JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    13JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    12Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/modules/mod_articles_single/helper.php:36
    11modArticlesSingleHelper::getItem()JROOT/modules/mod_articles_single/mod_articles_single.php:13
    10include JROOT/modules/mod_articles_single/mod_articles_single.phpJROOT/libraries/src/Helper/ModuleHelper.php:201
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:783
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1041
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:201
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  28. Query Time: 1.72 ms After last query: 445.20 ms Query memory: 0.017 MB Memory before query: 18.839 MB Rows returned: 7
    SELECT extension_id, name 
      FROM fz2kx_extensions
      WHERE type = 'plugin'
      AND folder = 'search'
      AND enabled =1
      AND access IN (1,1,5)
      ORDER BY ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEfz2kx_extensionsrefextensionextension82const139Using index condition; Using where; Using filesort
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.01 ms
    init0.01 ms
    optimizing0.02 ms
    statistics0.03 ms
    preparing0.02 ms
    executing0.00 ms
    Sorting result0.20 ms
    Sending data0.02 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1801
    11JDatabaseDriver->loadRowList()JROOT/modules/mod_universal_ajaxlivesearch/mod_universal_ajaxlivesearch.php:192
    10include JROOT/modules/mod_universal_ajaxlivesearch/mod_universal_ajaxlivesearch.phpJROOT/libraries/src/Helper/ModuleHelper.php:201
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:783
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1041
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:201
    1Joomla\CMS\Application\CMSApplication->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.41 ms After last query: 78.90 ms Query memory: 0.014 MB Memory before query: 19.191 MB Rows returned: 0
    SELECT `name`,`regex`,`replacement`
    
      FROM `fz2kx_jhackguard_output_filters`
      WHERE `state` = 1
      ORDER BY ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLENULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLImpossible WHERE noticed after reading const tables
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.02 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.03 ms
    executing0.01 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.01 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    9JDatabaseDriver->loadObjectList()JROOT/plugins/system/jhackguard/jhackguard.php:91
    8PlgSystemJhackguard->onAfterRender()Same as call in the line below.
    7call_user_func_array()JROOT/libraries/joomla/event/event.php:70
    6JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    5JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    4Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:1047
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:201
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  30. Query Time: 1.08 ms After last query: 232.76 ms Query memory: 0.029 MB Memory before query: 21.304 MB Rows returned: 166
    SHOW TABLES
    Explain
    EXPLAIN not possible on query: SHOW TABLES
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.01 ms
    executing0.00 ms
    Filling schema table0.01 ms
    checking permissions0.58 ms
    executing0.00 ms
    Sending data0.05 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.00 ms
    removing tmp table0.01 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    freeing items0.00 ms
    updating status0.02 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1540
    20JDatabaseDriver->loadColumn()JROOT/libraries/joomla/database/driver/mysqli.php:487
    19JDatabaseDriverMysqli->getTableList()JROOT/libraries/f0f/database/driver/joomla.php:251
    18F0FDatabaseDriverJoomla->getTableList()JROOT/libraries/f0f/table/table.php:2070
    17F0FTable->getTableFields()JROOT/libraries/f0f/table/table.php:536
    16F0FTable->__construct()JROOT/administrator/components/com_autotweet/tables/automator.php:33
    15AutotweetTableAutomator->__construct()JROOT/libraries/f0f/table/table.php:433
    14F0FTable::getAnInstance()JROOT/libraries/f0f/model/model.php:2037
    13F0FModel->_createTable()JROOT/libraries/f0f/model/model.php:1994
    12F0FModel->getTable()JROOT/administrator/components/com_autotweet/models/automators.php:91
    11AutotweetModelAutomators->lastRun()JROOT/administrator/components/com_autotweet/models/automators.php:35
    10AutotweetModelAutomators->lastRunCheck()JROOT/plugins/system/autotweetautomator/autotweetautomator.php:102
    9PlgSystemAutotweetAutomator->_onAfterRender()JROOT/plugins/system/autotweetautomator/autotweetautomator.php:211
    8PlgSystemAutotweetAutomator->onAfterRender()Same as call in the line below.
    7call_user_func_array()JROOT/libraries/joomla/event/event.php:70
    6JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    5JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    4Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:1047
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:201
    1Joomla\CMS\Application\CMSApplication->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.57 ms After last query: 0.48 ms Query memory: 0.029 MB Memory before query: 21.361 MB Rows returned: 3
    SHOW FULL COLUMNS 
      FROM `fz2kx_autotweet_automator`
    Explain
    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `fz2kx_autotweet_automator`
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.01 ms
    closing tables0.01 ms
    Opening tables0.13 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.03 ms
    executing0.00 ms
    Filling schema table0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    checking permissions0.03 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    closing tables0.01 ms
    executing0.00 ms
    Sending data0.04 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.00 ms
    removing tmp table0.03 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    20JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/database/driver/mysqli.php:430
    19JDatabaseDriverMysqli->getTableColumns()JROOT/libraries/f0f/database/driver/joomla.php:229
    18F0FDatabaseDriverJoomla->getTableColumns()JROOT/libraries/f0f/table/table.php:2155
    17F0FTable->getTableFields()JROOT/libraries/f0f/table/table.php:536
    16F0FTable->__construct()JROOT/administrator/components/com_autotweet/tables/automator.php:33
    15AutotweetTableAutomator->__construct()JROOT/libraries/f0f/table/table.php:433
    14F0FTable::getAnInstance()JROOT/libraries/f0f/model/model.php:2037
    13F0FModel->_createTable()JROOT/libraries/f0f/model/model.php:1994
    12F0FModel->getTable()JROOT/administrator/components/com_autotweet/models/automators.php:91
    11AutotweetModelAutomators->lastRun()JROOT/administrator/components/com_autotweet/models/automators.php:35
    10AutotweetModelAutomators->lastRunCheck()JROOT/plugins/system/autotweetautomator/autotweetautomator.php:102
    9PlgSystemAutotweetAutomator->_onAfterRender()JROOT/plugins/system/autotweetautomator/autotweetautomator.php:211
    8PlgSystemAutotweetAutomator->onAfterRender()Same as call in the line below.
    7call_user_func_array()JROOT/libraries/joomla/event/event.php:70
    6JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    5JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    4Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:1047
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:201
    1Joomla\CMS\Application\CMSApplication->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.29 ms After last query: 20.23 ms Query memory: 0.020 MB Memory before query: 21.497 MB Rows returned: 1
    SELECT fz2kx_autotweet_automator.*
    
      FROM fz2kx_autotweet_automator
      WHERE `fz2kx_autotweet_automator`.`plugin` = 'automator'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEfz2kx_autotweet_automatorALLNULLNO INDEX KEY COULD BE USEDNULLNULL2Using where
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.02 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.01 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1455
    14JDatabaseDriver->loadAssoc()JROOT/libraries/f0f/database/driver/joomla.php:291
    13F0FDatabaseDriverJoomla->loadAssoc()JROOT/libraries/f0f/table/table.php:949
    12F0FTable->load()JROOT/administrator/components/com_autotweet/models/automators.php:96
    11AutotweetModelAutomators->lastRun()JROOT/administrator/components/com_autotweet/models/automators.php:35
    10AutotweetModelAutomators->lastRunCheck()JROOT/plugins/system/autotweetautomator/autotweetautomator.php:102
    9PlgSystemAutotweetAutomator->_onAfterRender()JROOT/plugins/system/autotweetautomator/autotweetautomator.php:211
    8PlgSystemAutotweetAutomator->onAfterRender()Same as call in the line below.
    7call_user_func_array()JROOT/libraries/joomla/event/event.php:70
    6JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    5JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    4Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:1047
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:201
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  33. Query Time: 0.32 ms After last query: 0.42 ms Query memory: 0.022 MB Memory before query: 21.517 MB Rows returned: 1
    SELECT fz2kx_autotweet_automator.*
    
      FROM fz2kx_autotweet_automator
      WHERE `fz2kx_autotweet_automator`.`id` = '1'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEfz2kx_autotweet_automatorconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.00 ms
    Unlocking tables0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1455
    15JDatabaseDriver->loadAssoc()JROOT/libraries/f0f/database/driver/joomla.php:291
    14F0FDatabaseDriverJoomla->loadAssoc()JROOT/libraries/f0f/table/table.php:949
    13F0FTable->load()JROOT/libraries/f0f/model/model.php:1154
    12F0FModel->getItem()JROOT/administrator/components/com_autotweet/models/automators.php:100
    11AutotweetModelAutomators->lastRun()JROOT/administrator/components/com_autotweet/models/automators.php:35
    10AutotweetModelAutomators->lastRunCheck()JROOT/plugins/system/autotweetautomator/autotweetautomator.php:102
    9PlgSystemAutotweetAutomator->_onAfterRender()JROOT/plugins/system/autotweetautomator/autotweetautomator.php:211
    8PlgSystemAutotweetAutomator->onAfterRender()Same as call in the line below.
    7call_user_func_array()JROOT/libraries/joomla/event/event.php:70
    6JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    5JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    4Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:1047
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:201
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  34. Query Time: 0.16 ms After last query: 0.50 ms Query memory: 0.013 MB Memory before query: 21.557 MB

      SET sql_big_selects=1
    Explain
    EXPLAIN not possible on query: SET sql_big_selects=1
    Profile
    StatusDuration
    starting0.02 ms
    Opening tables0.00 ms
    After opening tables0.01 ms
    query end0.00 ms
    closing tables0.00 ms
    freeing items0.00 ms
    updating status0.01 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/database.php:33
    10JDatabase->query()JROOT/administrator/components/com_autotweet/helpers/autotweetbase.php:236
    9PlgAutotweetBase->onContentPolling()JROOT/plugins/system/autotweetcontent/autotweetcontent.php:446
    8PlgSystemAutotweetContent->onAfterRender()Same as call in the line below.
    7call_user_func_array()JROOT/libraries/joomla/event/event.php:70
    6JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    5JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    4Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:1047
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:201
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  35. Query Time: 0.45 ms After last query: 0.91 ms Query memory: 0.021 MB Memory before query: 21.589 MB Rows returned: 1
    SELECT fz2kx_autotweet_automator.*
    
      FROM fz2kx_autotweet_automator
      WHERE `fz2kx_autotweet_automator`.`plugin` = 'content'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEfz2kx_autotweet_automatorALLNULLNO INDEX KEY COULD BE USEDNULLNULL2Using where
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.02 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1455
    15JDatabaseDriver->loadAssoc()JROOT/libraries/f0f/database/driver/joomla.php:291
    14F0FDatabaseDriverJoomla->loadAssoc()JROOT/libraries/f0f/table/table.php:949
    13F0FTable->load()JROOT/administrator/components/com_autotweet/models/automators.php:96
    12AutotweetModelAutomators->lastRun()JROOT/administrator/components/com_autotweet/models/automators.php:35
    11AutotweetModelAutomators->lastRunCheck()JROOT/administrator/components/com_autotweet/helpers/autotweetbase.php:648
    10PlgAutotweetBase->executeContentPolling()JROOT/administrator/components/com_autotweet/helpers/autotweetbase.php:238
    9PlgAutotweetBase->onContentPolling()JROOT/plugins/system/autotweetcontent/autotweetcontent.php:446
    8PlgSystemAutotweetContent->onAfterRender()Same as call in the line below.
    7call_user_func_array()JROOT/libraries/joomla/event/event.php:70
    6JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    5JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    4Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:1047
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:201
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  36. Query Time: 0.29 ms After last query: 0.38 ms Query memory: 0.023 MB Memory before query: 21.609 MB Rows returned: 1
    SELECT fz2kx_autotweet_automator.*
    
      FROM fz2kx_autotweet_automator
      WHERE `fz2kx_autotweet_automator`.`id` = '2'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEfz2kx_autotweet_automatorconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.01 ms
    Unlocking tables0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.02 ms
    freeing items0.00 ms
    updating status0.01 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1455
    16JDatabaseDriver->loadAssoc()JROOT/libraries/f0f/database/driver/joomla.php:291
    15F0FDatabaseDriverJoomla->loadAssoc()JROOT/libraries/f0f/table/table.php:949
    14F0FTable->load()JROOT/libraries/f0f/model/model.php:1154
    13F0FModel->getItem()JROOT/administrator/components/com_autotweet/models/automators.php:100
    12AutotweetModelAutomators->lastRun()JROOT/administrator/components/com_autotweet/models/automators.php:35
    11AutotweetModelAutomators->lastRunCheck()JROOT/administrator/components/com_autotweet/helpers/autotweetbase.php:648
    10PlgAutotweetBase->executeContentPolling()JROOT/administrator/components/com_autotweet/helpers/autotweetbase.php:238
    9PlgAutotweetBase->onContentPolling()JROOT/plugins/system/autotweetcontent/autotweetcontent.php:446
    8PlgSystemAutotweetContent->onAfterRender()Same as call in the line below.
    7call_user_func_array()JROOT/libraries/joomla/event/event.php:70
    6JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    5JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    4Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:1047
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:201
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

31 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 4 × SELECT fz2kx_autotweet_automator.* 
      FROM fz2kx_autotweet_automator
  2. 2 × SELECT cc.id, cc.title, cc.alias, cc.description, cc.access as cataccess, cc.accessuserid as cataccessuserid 
      FROM fz2kx_phocadownload_categories AS cc
      LEFT JOIN fz2kx_phocadownload AS c
      ON c.catid = cc.id
  3. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
      FROM `fz2kx_extensions`
  4. 1 × SELECT `alias` 
      FROM `fz2kx_content`
  5. 1 × SELECT `id`,`name`,`rules`,`parent_id` 
      FROM `fz2kx_assets`
  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
      FROM `fz2kx_categories` AS `s`
      INNER JOIN `fz2kx_categories` AS `c`
      ON (s.lft <= c.lft
      AND c.lft < s.rgt) OR (c.lft < s.lft
      AND s.rgt < c.rgt)
  7. 1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
      FROM fz2kx_content AS a
      INNER JOIN fz2kx_categories AS c
      on c.id = a.catid
      LEFT JOIN fz2kx_users AS u
      on u.id = a.created_by
      LEFT JOIN fz2kx_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN fz2kx_content_rating AS v
      ON a.id = v.content_id
  8. 1 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state 
      FROM fz2kx_fields AS a
      LEFT JOIN `fz2kx_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN fz2kx_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN fz2kx_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN fz2kx_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN fz2kx_fields_groups AS g
      ON g.id = a.group_id
  9. 1 × SELECT `name`,`regex`,`replacement` 
      FROM `fz2kx_jhackguard_output_filters`
  10. 1 × SELECT extension_id, name 
      FROM fz2kx_extensions
  11. 1 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state 
      FROM fz2kx_fields AS a
      LEFT JOIN `fz2kx_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN fz2kx_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN fz2kx_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN fz2kx_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN fz2kx_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `fz2kx_fields_categories` AS fc
      ON fc.field_id = a.id
  12. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM fz2kx_modules AS m
      LEFT JOIN fz2kx_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN fz2kx_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
  13. 1 × SELECT alias 
      FROM fz2kx_content
  14. 1 × SELECT a.filename as filename, a.type as type, a.menulink as menulink 
      FROM fz2kx_phocadownload_styles AS a
  15. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
      FROM fz2kx_extensions
  16. 1 × SELECT b.id 
      FROM fz2kx_usergroups AS a
      LEFT JOIN fz2kx_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  17. 1 × SELECT id, rules 
      FROM `fz2kx_viewlevels
  18. 1 × SELECT `session_id` 
      FROM `fz2kx_session`
  19. 1 × SELECT `state`,`rule_type` 
      FROM `fz2kx_jhackguard_ip_filters`
  20. 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 fz2kx_menu AS m
      LEFT JOIN fz2kx_extensions AS e
      ON m.component_id = e.extension_id
  21. 1 × SELECT `data` 
      FROM `fz2kx_session`
  22. 1 × SELECT c.*, cc.id AS categoryid, cc.title AS categorytitle, cc.alias AS categoryalias, cc.access as cataccess, cc.accessuserid as cataccessuserid, lc.title AS licensetitle, lc.description AS licensetext, lc.id AS licenseid 
      FROM fz2kx_phocadownload AS c
      LEFT JOIN fz2kx_phocadownload_categories AS cc
      ON cc.id = c.catid
      LEFT JOIN fz2kx_phocadownload_licenses AS lc
      ON lc.id = c.confirm_license
  23. 1 × SELECT id, home, template, s.params 
      FROM fz2kx_template_styles as s
      LEFT JOIN fz2kx_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
  24. 1 × SELECT * 
      FROM fz2kx_languages
  25. 1 × SELECT template 
      FROM fz2kx_template_styles
OTHER Tables:
  1. 1 × SHOW FULL COLUMNS 
      FROM `fz2kx_autotweet_automator
  2. 1 × 
      SET sql_big_selects=
  3. 1 × SHOW TABLE
  4. 1 × UPDATE `fz2kx_extensions` 
      SET `params` = '{\"mediaversion\":\"93993d2841b1155c0fd7b4aa84c39c02\"}'
  5. 1 × DELETE  
      FROM `fz2kx_jhackguard_ip_filters`
  6. 1 × INSERT INTO `fz2kx_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES ('h2o9d2rsbbkdr96us6jnjl1830', 1, '1524524551', 0, '', 0